NYC Open Data Plan: FOIL Datasets

2024

Department of Consumer and Worker Protection (DCWP)

Traverse Reports

List of Process Server Individual Traverse reports

20

Not on Open Data Plan

This was mistakenly identified as a “dataset”. Traverse Reports are individual forms submitted to the agency, their content is considered non-public information.

2024

Department of Consumer and Worker Protection (DCWP)

Vacant Newsstands

List of vacant newsstands

1

Not on Open Data Plan

DCWP does not track physical newsstand structures and their occupancy; for this request DCWP provided a list of expired or inactive Newsstand licenses and their address information.

2024

Department of Correction (DOC)

AMKC Grievances

All grievances, related to the temperature and/or ventilation (including air conditioning failures and other issues) at CAPS in AMKC and grievances of any kind originating from the CAPS units or medical clinic at AMKCRecords

1

Scheduled for Future Publication

2024

Department of Correction (DOC)

Securus Payments

Data available in Invoices or Statements between DOC and its Communication Vendor Securus from January 2018 to Present:
1. Monthly Phone Calls, Minutes, Revenue and Commissions
2. Monthly Electronic Messages and /or Stamp, E-Messaging Revenue and E-Messaging Commissions
3. Monthly Video Calls, Minutes, Revenue and Video Call Commissions

1

Not on Open Data Plan

These financial records are not kept in a regularly maintained database and are produced on an ad hoc basis.

2024

Department of Education (DOE)

2017-2018 Computer Science Report LL177

Local Law 177 enacted in 2016 requires the Department of Education of the New York City School District to submit to the Council an annual report concerning computer science education for the prior school year.

1

Already on Open Data

https://data.cityofnewyork.us/Education/2017-2018-Computer-Science-Report-LL177/gnum-kz6r/about_data

2024

Department of Education (DOE)

2018-2021 Daily Attendance by School

Daily listing of students enrolled, present, absent or released statistical count by district, borough and school.

1

Already on Open Data

https://data.cityofnewyork.us/Education/2018-2021-Daily-Attendance-by-School/xc44-2jrh/about_data

2024

Department of Education (DOE)

Bullying Harassment Discrimination Bi- Annual Report

Report on bullying, harassment and discrimination by school for July 1, 2020 through December 31, 2020 and for July 1, 2022 through June 31, 2023.

2

Already on Open Data

https://data.cityofnewyork.us/Education/2018-2019-Bullying-Harassment-Discrimination-Bi-An/uk7t-q4s9/about_data

Older version of this data has already been published on NYC Open Data; latest update is scheduled to be released.

2024

Department of Education (DOE)

Local Law 171 of 2018—PA/PTA Fundraising Report

Local Law 171 enacted in 2018 requires the Department of Education of the New York City School District to submit to the Council and post on the department's website a report regarding the income and total expenditure for each PA and PTA in the prior school year.

1

Scheduled for Future Publication

2024

Department of Environmental Protection (DEP)

311 Database

Water/Sewer Complaints

300

Already on Open Data

https://data.cityofnewyork.us/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9

2024

Department of Environmental Protection (DEP)

Asbestos Abatement Activities

Abatement Forms and Reports

55

Already on Open Data

https://data.cityofnewyork.us/Environment/Asbestos-Control-Program-ACP7-/vq35-j9qm

Data is disclosed to the extent it does not contain Sensitive/Private Information

2024

Department of Environmental Protection (DEP)

CHARMS Database

Employee Attendance Record

5

Not on Open Data Plan

Sensitive/Private Information

2024

Department of Environmental Protection (DEP)

DERTA Database/IPS Database

Hazardous Materials Storage

1182

Not on Open Data Plan

Sensitive Information; Disclosure would pose security risks to the public

2024

Department of Environmental Protection (DEP)

Dynamics 365

Idling Complaints

150

Not on Open Data Plan

Sensitive/Private Information

2024

Department of Environmental Protection (DEP)

IPS Database

DEP Water Sewer Repairs

237

Already on Open Data

https://data.cityofnewyork.us/Environment/Work-Order-Management-Module/4fvw-nn9c

2024

Department of Environmental Protection (DEP)

PARIS Database

Water/Sewer Service Line Permits

175

Already on Open Data

https://data.cityofnewyork.us/Environment/Water-and-Sewer-Permits/hphy-6g7m

2024

Department of Environmental Protection (DEP)

Passport Database

Contracts

19

Not on Open Data Plan

One off report or analysis

2024

Department of Environmental Protection (DEP)

UMAX Database

Customer Water and Wastewater Charges

322

Not on Open Data Plan

Sensitive/Private Information

2024

Department of Finance (DOF)

Historical Property Assessment Roll with Remissions

List of properties in NYC, which includes the assessed value and changes to the assessed value which caused the assessed value to decrease

4

Scheduled for Future Publication

2024

Department of Finance (DOF)

Mortgage and Deed

Real property documents, which are recorded in ACRIS

1

Already on Open Data

https://data.cityofnewyork.us/City-Government/ACRIS-Real-Property-Master/bnx9-e6tj; https://data.cityofnewyork.us/City-Government/ACRIS-Real-Property-Legals/8h5j-fqxa; https://data.cityofnewyork.us/City-Government/ACRIS-Real-Property-Parties/636b-3b5g; https://data.cityofnewyork.us/City-Government/ACRIS-Real-Property-Remarks/9p4w-7npp; https://data.cityofnewyork.us/City-Government/ACRIS-Real-Property-References/pwkr-dpni

2024

Department of Finance (DOF)

Name and Address

List of NYC properties, which includes property address, owner name and mailing address, and mail recipient name and mailing address

17

Not on Open Data Plan

DOF is currently reviewing the request but will need more time to provide a roadmap to publish this data or provide a proper explanation for not publishing it.

2024

Department of Finance (DOF)

Notice of Property Value (NOPV)

List of NYC properties, which includes owner name and mailing address, and certain descriptive data such as market value, assessed value, and property tax exemptions

16

Not on Open Data Plan

DOF is currently reviewing the request but will need more time to provide a roadmap to publish this data or provide a proper explanation for not publishing it.

2024

Department of Finance (DOF)

Property Assessment Roll

List of NYC properties, which includes owner name, property characteristics, market value, assessed value, and exemptions for a property

9

Already on Open Data

https://data.cityofnewyork.us/City-Government/Property-Valuation-and-Assessment-Data-Tax-Classes/8y4t-faws

2024

Department of Finance (DOF)

Property Charges

Property taxes, related charges, credits, payments, etc. by property and by period

2

Already on Open Data

https://data.cityofnewyork.us/City-Government/DOF-Property-Charges-Balance/scjx-j6np

2024

Department of Finance (DOF)

Property Exemptions

Government, Not-for-Profit and Commercial Exemptions maintained by NYC Department of Finance. The Department of Finance administers a number of benefits for property owners in the form of exemptions and abatements. Exemptions lower the amount of tax one owes by reducing the property's assessed value. This data contains exemption information for Government, Not-for-Profit and Commercial Exemptions.

1

Already on Open Data

https://data.cityofnewyork.us/City-Government/Property-Exemption-Detail/muvi-b6kx

2024

Department of Finance (DOF)

Property Value Change Details

Changes to Property Assessment. The data is collected and entered into the system from different sources within the agency and is a record of value changes to assessments and exemptions for property.

2

Already on Open Data

https://data.cityofnewyork.us/City-Government/DOF-Property-Assessment-Change/a5nd-6mit

2024

Department of Health and Mental Hygiene (DOHMH)

311 Service Requests

Data collected about illegal or exotic animals being kept as pets

1

Already on Open Data

https://data.cityofnewyork.us/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9/explore/query/SELECT%0A%20%20%60unique_key%60%2C%0A%20%20%60created_date%60%2C%0A%20%20%60closed_date%60%2C%0A%20%20%60agency%60%2C%0A%20%20%60agency_name%60%2C%0A%20%20%60complaint_type%60%2C%0A%20%20%60descriptor%60%2C%0A%20%20%60location_type%60%2C%0A%20%20%60incident_zip%60%2C%0A%20%20%60incident_address%60%2C%0A%20%20%60street_name%60%2C%0A%20%20%60cross_street_1%60%2C%0A%20%20%60cross_street_2%60%2C%0A%20%20%60intersection_street_1%60%2C%0A%20%20%60intersection_street_2%60%2C%0A%20%20%60address_type%60%2C%0A%20%20%60city%60%2C%0A%20%20%60landmark%60%2C%0A%20%20%60facility_type%60%2C%0A%20%20%60status%60%2C%0A%20%20%60due_date%60%2C%0A%20%20%60resolution_description%60%2C%0A%20%20%60resolution_action_updated_date%60%2C%0A%20%20%60community_board%60%2C%0A%20%20%60bbl%60%2C%0A%20%20%60borough%60%2C%0A%20%20%60x_coordinate_state_plane%60%2C%0A%20%20%60y_coordinate_state_plane%60%2C%0A%20%20%60open_data_channel_type%60%2C%0A%20%20%60park_facility_name%60%2C%0A%20%20%60park_borough%60%2C%0A%20%20%60vehicle_type%60%2C%0A%20%20%60taxi_company_borough%60%2C%0A%20%20%60taxi_pick_up_location%60%2C%0A%20%20%60bridge_highway_name%60%2C%0A%20%20%60bridge_highway_direction%60%2C%0A%20%20%60road_ramp%60%2C%0A%20%20%60bridge_highway_segment%60%2C%0A%20%20%60latitude%60%2C%0A%20%20%60longitude%60%2C%0A%20%20%60location%60%2C%0A%20%20%60%3A%40computed_region_efsh_h5xi%60%2C%0A%20%20%60%3A%40computed_region_f5dn_yrer%60%2C%0A%20%20%60%3A%40computed_region_yeji_bk3q%60%2C%0A%20%20%60%3A%40computed_region_92fq_4b7q%60%2C%0A%20%20%60%3A%40computed_region_sbqj_enih%60%0AWHERE%0A%20%20caseless_one_of%28%60agency%60%2C%20%22dohmh%22%29%0A%20%20AND%20caseless_contains%28%60complaint_type%60%2C%20%22animal%22%29%0AORDER%20BY%20%60created_date%60%20DESC%20NULL%20FIRST/page/filter

2024

Department of Health and Mental Hygiene (DOHMH)

311 Service Requests

311 complaints of Childcare establishments- referred to OpenData

1

Already on Open Data

https://data.cityofnewyork.us/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9/explore/query/SELECT%0A%20%20%60unique_key%60%2C%0A%20%20%60created_date%60%2C%0A%20%20%60closed_date%60%2C%0A%20%20%60agency%60%2C%0A%20%20%60agency_name%60%2C%0A%20%20%60complaint_type%60%2C%0A%20%20%60descriptor%60%2C%0A%20%20%60location_type%60%2C%0A%20%20%60incident_zip%60%2C%0A%20%20%60incident_address%60%2C%0A%20%20%60street_name%60%2C%0A%20%20%60cross_street_1%60%2C%0A%20%20%60cross_street_2%60%2C%0A%20%20%60intersection_street_1%60%2C%0A%20%20%60intersection_street_2%60%2C%0A%20%20%60address_type%60%2C%0A%20%20%60city%60%2C%0A%20%20%60landmark%60%2C%0A%20%20%60facility_type%60%2C%0A%20%20%60status%60%2C%0A%20%20%60due_date%60%2C%0A%20%20%60resolution_description%60%2C%0A%20%20%60resolution_action_updated_date%60%2C%0A%20%20%60community_board%60%2C%0A%20%20%60bbl%60%2C%0A%20%20%60borough%60%2C%0A%20%20%60x_coordinate_state_plane%60%2C%0A%20%20%60y_coordinate_state_plane%60%2C%0A%20%20%60open_data_channel_type%60%2C%0A%20%20%60park_facility_name%60%2C%0A%20%20%60park_borough%60%2C%0A%20%20%60vehicle_type%60%2C%0A%20%20%60taxi_company_borough%60%2C%0A%20%20%60taxi_pick_up_location%60%2C%0A%20%20%60bridge_highway_name%60%2C%0A%20%20%60bridge_highway_direction%60%2C%0A%20%20%60road_ramp%60%2C%0A%20%20%60bridge_highway_segment%60%2C%0A%20%20%60latitude%60%2C%0A%20%20%60longitude%60%2C%0A%20%20%60location%60%2C%0A%20%20%60%3A%40computed_region_efsh_h5xi%60%2C%0A%20%20%60%3A%40computed_region_f5dn_yrer%60%2C%0A%20%20%60%3A%40computed_region_yeji_bk3q%60%2C%0A%20%20%60%3A%40computed_region_92fq_4b7q%60%2C%0A%20%20%60%3A%40computed_region_sbqj_enih%60%0AWHERE%0A%20%20caseless_one_of%28%60agency%60%2C%20%22dohmh%22%29%0A%20%20AND%20caseless_contains%28%60complaint_type%60%2C%20%22animal%22%29%0AORDER%20BY%20%60created_date%60%20DESC%20NULL%20FIRST/page/filter

2024

Department of Health and Mental Hygiene (DOHMH)

Beekeeping - Number of Hives Data

Number of Hives by year, borough, and total hives/colonies

1

Scheduled for Future Publication

2024

Department of Health and Mental Hygiene (DOHMH)

Bureau of Mental Health Database

All data associated with 9.58 removals (provision of MH law)

1

Not on Open Data Plan

It would be an undue administrative burden for DOHMH to regularly maintain the dataset released in response to this FOIL request on Open Data.  The underlying dataset includes confidential information that cannot be released to the public pursuant to the NYC Privacy Law, HIPAA, and/or the NYS Public Health Law

2024

Department of Health and Mental Hygiene (DOHMH)

Child Care Application Tracking System

From the New York State Department of Labor. NYC Childcare capacity data, I believe the plan is to put this on OpenData.

1

Scheduled for Future Publication

2024

Department of Health and Mental Hygiene (DOHMH)

Community Health Survey

Records of specific answers to the Community Health Survey

1

Already on Open Data

https://data.cityofnewyork.us/Health/New-York-City-Community-Health-Survey/csut-3wpr/about_data

2024

Department of Health and Mental Hygiene (DOHMH)

Correctional Health Services Referrals to AOT

Rikers Referrals to Assisted Outpatient Treatment Program: Number of times Correctional Health Services referred a patient to the Assisted Outpatient Treatment program and the results of those referrals.

1

Not on Open Data Plan

It would be an undue administrative burden for DOHMH to regularly maintain the dataset released in response to this FOIL request on Open Data.  The underlying dataset includes confidential information that cannot be released to the public pursuant to the NYC Privacy Law, HIPAA, and/or the NYS Public Health Law

2024

Department of Health and Mental Hygiene (DOHMH)

DOHMH FOIL Log

Log containing all FOIL requests

2

Not on Open Data Plan

Source data includes information protected by various privacy laws so redactions were required to process this FOIL. Therefore, the dataset cannot be made available to open data.

2024

Department of Health and Mental Hygiene (DOHMH)

DOHMH HR Database

Data on DOHMH staff vacancy rates

1

Not on Open Data Plan

It would be an undue administrative burden for DOHMH to regularly maintain the dataset released in response to this FOIL request on Open Data.

2024

Department of Health and Mental Hygiene (DOHMH)

Foodborne NYC

Code and dataset for “improving Foodborne Disease Outbreak Detection Incorporating Complaints Identified in Social Media Data.”

1

Not on Open Data Plan

It would be an undue administrative burden for DOHMH to regularly maintain the dataset released in response to this FOIL request on Open Data.

2024

Department of Health and Mental Hygiene (DOHMH)

Horse Licensing

Current Carriage Horse List

1

Scheduled for Future Publication

2024

Department of Health and Mental Hygiene (DOHMH)

Horse Licensing

Updated carriage horse list as of 6.28.23

1

Scheduled for Future Publication

2024

Department of Health and Mental Hygiene (DOHMH)

Lead Data

1. Number of contestations of DOHMH orders to abate or remediate lead-based paint hazards, with corresponding DOHMH determination, by owner (NYCHA vs non-NYCHA), 2013-2023

2. Changes in blood lead levels for children (N=106*) in NYCHA housings where DOHMH accepted the NYCHA contestation

3. Number of contestations of DOHMH orders to abate or remediate lead-based paint hazards, with corresponding DOHMH determination, by owner (NYCHA vs non-NYCHA), 2018-2023*

1

Not on Open Data Plan

Please see the DOHMH website for the most recent Lead Data [https://www.nyc.gov/site/doh/data/data-sets/lead-pubs.page].  DOHMH maintains Environmental & Health Data Portal [https://a816-dohbesp.nyc.gov/IndicatorPublic/data-explorer/lead/?id=2189#display=summary] with computational automation features not available through Open data. Due to the burden involved in replicating these data on Open Data, these data will continue to be available through the links provided above

2024

Department of Health and Mental Hygiene (DOHMH)

Mental Health Services Waitlist

Waitlist for outpatient mental health services.

1

Not on Open Data Plan

It would be an undue administrative burden for DOHMH to regularly maintain the dataset released in response to this FOIL request on Open Data.  The underlying dataset includes confidential information that cannot be released to the public pursuant to the NYC Privacy Law, HIPAA, and/or the NYS Public Health Law

2024

Department of Health and Mental Hygiene (DOHMH)

Mental Health Transports

Table 1. Voluntary and involuntary transports aggregated for Mobile Crisis Teams (MCT) and Subway Homelessness Outreach Teams (all ages)
Table 2. Voluntary and involuntary transports by Race/Ethnicity (MCT only) for all ages
Table 3. Voluntary and Involuntary Transports by H+H facility for MCT and Subway Homelessness Outreach Teams (all ages)
Table 4. Voluntary and Involuntary Transports to H+H facility by race/ethnicity for MCT only (all ages)

1

Not on Open Data Plan

It would be an undue administrative burden for DOHMH to regularly maintain the dataset released in response to this FOIL request on Open Data.  The underlying dataset includes confidential information that cannot be released to the public pursuant to the NYC Privacy Law, HIPAA, and/or the NYS Public Health Law

2024

Department of Health and Mental Hygiene (DOHMH)

Mobile Food Vending

Complete list of all mobile food vending licenses issued by DOHMH

1

Scheduled for Future Publication

2024

Department of Health and Mental Hygiene (DOHMH)

Mobile Food Vending

Number of mobile food vender permits issued to ice cream trucks

1

Scheduled for Future Publication

2024

Department of Health and Mental Hygiene (DOHMH)

Mobile Food Vending

Data on mobile food vendor commissaries and commissaries that have serviced ice cream trucks

1

Scheduled for Future Publication

2024

Department of Health and Mental Hygiene (DOHMH)

Mobile Food Vending

Mobile food vendor supervisory waiting lists

1

Scheduled for Future Publication

2024

Department of Health and Mental Hygiene (DOHMH)

Office of School Health/BOI Database

Number of medical exemptions from vaccine mandates

1

Not on Open Data Plan

It would be an undue administrative burden for DOHMH to regularly maintain the dataset released in response to this FOIL request on Open Data. The underlying dataset includes confidential information that cannot be released to the public pursuant to the NYC Privacy Law, HIPAA, and/or the NYS Public Health Law.

2024

Department of Health and Mental Hygiene (DOHMH)

Overdose Prevention Center Utilization Database

Total monthly OPC utilization during first year of operations across OnPoint NYC's Washington Heights and East Harlem OPC sites. Nov 2021-Nov 2022

1

Not on Open Data Plan

It would be an undue administrative burden for DOHMH to regularly maintain the dataset released in response to this FOIL request on Open Data.  The underlying dataset includes confidential information that cannot be released to the public pursuant to the NYC Privacy Law, HIPAA, and/or the NYS Public Health Law

2024

Department of Health and Mental Hygiene (DOHMH)

Syndromic Surveillance

Daily emergency department visits in zip code 11373, from 1/1/2007 - 12/1/2023

1

Scheduled for Future Publication

2024

Department of Health and Mental Hygiene (DOHMH)

TeenSpace Database

Data collected from the TeenSpace contract

1

Not on Open Data Plan

It would be an undue administrative burden for DOHMH to regularly maintain the dataset released in response to this FOIL request on Open Data.

2024

Department of Health and Mental Hygiene (DOHMH)

Vital Statistics Database

NYC Residents COVID Hospital Inpatient Death.

1

Not on Open Data Plan

It would be an undue administrative burden for DOHMH to regularly maintain the dataset released in response to this FOIL request on Open Data. The underlying dataset includes confidential information that cannot be released to public pursuant to NYC Privacy Law, HIPAA, and/or the NYS Public Health Law

2024

Department of Health and Mental Hygiene (DOHMH)

Vital Statistics Database

The number of New York City live births occurring daily from 1/1/2015 through 12/31/2022, per the dates on the infant’s birth certificate.

1

Not on Open Data Plan

It would be an undue administrative burden for DOHMH to regularly maintain the dataset released in response to this FOIL request on Open Data. The underlying dataset includes confidential information that cannot be released to the public pursuant to the NYC Privacy Law, HIPAA, and/or the NYS Public Health Law.