NYC Open Data Plan: FOIL Datasets

2024

Department of Health and Mental Hygiene (DOHMH)

Vital Statistics Database

1) The number of deaths occurring each day among New York City residents from Jan 1, 1999 - October 1, 2023

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

2) The number of emergency department visits in New York City from 1/1/2022 - October 31, 2023.

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

3) The total number of New York City resident death certificates for deaths occurring between 1/1/2020 and 12/31/2020 that list COVID-19 as Underlying/Immediate Cause of Death and no other consequential causes in Part 1 of the death certificate and no contributing causes of death in Part II of the death certificate. In other words, the number of death certificates that list only COVID-19 as cause of death:

1

Not on Open Data Plan

While DOHMH is in possession of this data and is legally required to respond pursuant to FOIL, DOHMH does not own this data, and is therefore unable to attest to its accuracy or reliability.

2024

Department of Health and Mental Hygiene (DOHMH)

Vital Statistics Database

Number of deaths occurring daily in NYC

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 Housing Preservation and Development (HPD)

7A

7A Cases Initiated by Referral Source and Borough

1

Scheduled for Future Publication

2024

Department of Housing Preservation and Development (HPD)

CONH Building List

List of Addresses Currently Included on Certificate of No Harassment List

13

Already on Open Data

https://data.cityofnewyork.us/Housing-Development/Certification-of-No-Harassment-CONH-Pilot-Building/bzxi-2tsw

2024

Department of Housing Preservation and Development (HPD)

Homeless Set Aside Data

Homeless Households Placed in HPD Housing

1

Not on Open Data Plan

This dataset is not maintained in a data system that would allow for open data publication while sufficiently protecting PII. The limited data released via FOIL required manual review/redaction

2024

Department of Housing Preservation and Development (HPD)

Housing Connect Data

Data on Housing Lotteries

5

Scheduled for Future Publication

2024

Department of Housing Preservation and Development (HPD)

Housing Maintenance Code Data

Housing Maintenance Code Data: Data related to HPD's enforcement of the Housing Maintenance Code

685

Already on Open Data

Many datasets; see "Enforcement & Neighborhood Services" section here for list: https://www.nyc.gov/site/hpd/about/open-data.page

2024

Department of Parks and Recreation (DPR)

Absence Control

This system is used to track the absences of agency employees

1

Not on Open Data Plan

Contains Personally Identifiable Information, which if disclosed would constitute an unwarranted invasion of personal privacy. This is information from a personnel management system.

2024

Department of Parks and Recreation (DPR)

Asset Management Parks System (AMPS) - Work Orders

This table is the primary table for information about work orders, and contains general information - including a description of the work, assigned title, request date and completion date - about each work order. Each row represents a single work order. The primary key field is EVT_CODE. The EVT_OBJECT field can be joined to the Assets table on OBJ_CODE to know which asset the work order was for.

85

Already on Open Data

https://data.cityofnewyork.us/Environment/Asset-Management-Parks-System-AMPS-Work-Orders/8sdw-8vja

2024

Department of Parks and Recreation (DPR)

Capital Projects

Information about NYC Parks' Capital Improvement projects

30

Scheduled for Future Publication

2024

Department of Parks and Recreation (DPR)

CHRMS

This is the Citywide Human Resources Management System

7

Not on Open Data Plan

Contains Personally Identifiable Information, which if disclosed would constitute an unwarranted invasion of personal privacy. This is information from a personnel management system.

2024

Department of Parks and Recreation (DPR)

Forestry Inspections

Record of Forestry inspections for NYC Parks & Recreation. Inspections are initiated by a service request or internal process and may result in a work order.

Inspections are used to record field observations. ForMS 2.0 requires that Inspections can only be created from either a Tree Point or Planting Space based on the asset in question. Inspection types vary depending on the inspector’s workflow:
• level 1 (limited visual)
• level 2 (basic)
• level 3 (advanced)
• Re-inspection
• Sidewalk Rating (Trees and Sidewalks Inspections)
• General – Planting Space (Street Tree Planting Inspections)

This dataset can be joined to the Forestry Tree Points dataset by joining TreePointGlobalID from Forestry Inspections to GLOBALID from Forestry Tree Points.

109

Already on Open Data

https://data.cityofnewyork.us/Environment/Forestry-Inspections/4pt5-3vv4

2024

Department of Parks and Recreation (DPR)

Forestry Permits and Plan Review

Tracking of applications for work involving NYC Parks trees

2

Scheduled for Future Publication

2024

Department of Parks and Recreation (DPR)

Forestry Service Requests

Record of Forestry service requests for NYC Parks & Recreation.

Two-way integration with 311 is maintained in ForMS 2.0. Forestry related Service Requests (SRs) created by a 311 operator or submitted by the caller through either the 311 website, 311 phone app, or the Parks website stream into the system. Conversely, updates are sent from ForMS 2.0 to 311 when SRs are actioned.

Service Requests can be created directly in ForMS 2.0, however, it is important to note that they will NOT receive a 311 SEIBEL number or be visible in 311. Internally generated SRs should be used to track correspondence, commissioner, or other requests that do not originate from 311.

23

Already on Open Data

https://data.cityofnewyork.us/Environment/Forestry-Service-Requests/mu46-p9is

2024

Department of Parks and Recreation (DPR)

Forestry Tree Points

Record of Forestry tree points for NYC Parks & Recreation.

Tree Points and Planting Spaces form the basis of ForMS 2.0’s data inventory and are the core entities that all Service Requests, Inspections, and Work Orders are associated to. The system has built-in rules to ensure that every Tree Point has a Planting Space and each Planting Space can have no more than one active Tree Point at a given time. Locations that have had one tree removed and another tree replanted will appear in ForMS 2.0 as a single Planting Space associated with one retired Tree Point (that has a removal Work Order) and one active Tree Point.

This dataset can be joined to the Forestry Planting Spaces dataset by joining PlantingSpaceGlobalID from Forestry Tree Points to GLOBALID from Forestry Planting Spaces.

1

Already on Open Data

https://data.cityofnewyork.us/Environment/Forestry-Tree-Points/hn5i-inap

2024

Department of Parks and Recreation (DPR)

Forestry Work Orders

Record of Forestry work orders for NYC Parks & Recreation.

Work Orders are used to record activities performed by Parks staff, contractors, other Agencies, or private entities in the case of permitted work. ForMS 2.0 requires that WOs can only be created from an Inspection, with the exception of a Debris Removal – Misc. Wood WO where the associated tree cannot always be determined.

This dataset can be joined to the Forestry Planting Spaces dataset by joining PlantingSpaceGlobalID from Forestry Work Orders to GLOBALID from Forestry Planting Spaces.

47

Already on Open Data

https://data.cityofnewyork.us/Environment/Forestry-Work-Orders/bdjm-n7q4

2024

Department of Parks and Recreation (DPR)

Park Properties

This dataset identifies property managed partially or solely by NYC Parks. This data has been produced in whole or part using secondary data. Data accuracy is limited by the scale and accuracy of the original sources. Site-specific conditions should be field-verified.

Records are added as more land is designated under NYC Parks’ jurisdiction. Each record represents an acquisition.

87

Already on Open Data

https://data.cityofnewyork.us/Recreation/Parks-Properties/enfh-gkve

2024

Department of Parks and Recreation (DPR)

Parks Inspection Program - Daily Immediate Attentions

This dataset contains immediate attention hazards. These include unacceptable situations that may be potentially hazardous, as well as graffiti that depicts profanity or hate speech. Each row represents a single "immediate attention."

64

Already on Open Data

https://data.cityofnewyork.us/City-Government/Parks-Inspection-Program-Daily-Immediate-Attention/s6dm-mdan

2024

Department of Parks and Recreation (DPR)

Parks Inspection Program - Inspections

This dataset contains overall ratings associated with property inspections. Each row represents an individual inspection.

77

Already on Open Data

https://data.cityofnewyork.us/dataset/Parks-Inspection-Program-Inspections/yg3y-7juh

2024

Department of Parks and Recreation (DPR)

Tree Manager

This DOS-based system was used to track forestry work before approximately 2008.

6

Not on Open Data Plan

This system is only available on local machines, and it is unclear if this data could be exported to a modern format.

2024

Department of Probation (DOP)

DOP Adult Violations of Probation Filed by Calendar Year

Department of Probation (DOP) Annual Adult Cases

1

Already on Open Data

https://data.cityofnewyork.us/Public-Safety/Department-of-Probation-DOP-Annual-Adult-Cases/xsj8-452q

2024

Department of Probation (DOP)

DOP Juvenile Violations of Probation Filed by Calendar Year

Department of Probation (DOP) Annual Juvenile Cases

1

Already on Open Data

https://data.cityofnewyork.us/Public-Safety/Department-of-Probation-DOP-Annual-Juvenile-Cases/5dfs-vnre

2024

Department of Records and Information Services (DORIS)

New York City Municipal Archives Data Collection: Acquisitions / Accessions List

Accession / Acquisition data details groups of records that are transferred from City agencies and donors through a records management disposition process. It typically includes the originating agency/donor and a general summary on the content, formats, and size of the collections.

3

Already on Open Data

https://data.cityofnewyork.us/City-Government/New-York-City-Municipal-Archives-Data-Collection-A/vfa7-chs9/about_data

2024

Department of Records and Information Services (DORIS)

New York City Municipal Archives Data Collection: Digital Objects

Digital objects are used to link born-digital or digitized content of archival collections. The data is collected from an archival management or archival preservation system. The data can be used to assess the extent of digitized content of archival collections.

3

Already on Open Data

https://data.cityofnewyork.us/City-Government/New-York-City-Municipal-Archives-Data-Collection-D/28et-rv7b/about_data

2024

Department of Records and Information Services (DORIS)

OpenRecords FOIL Requests

The OpenRecords Requests dataset consists of information about FOIL Requests including Agency name, date created, date closed, due date, status.

1

Already on Open Data

https://data.cityofnewyork.us/City-Government/OpenRecords-FOIL-Requests/kegn-anvq/about_data

2024

Department of Small Business Services (SBS)

Any listing any business, entity or ratepayer that has applied for inclusion in the Energy Cost Savings Program (ESCP) for the years 2013-2023; list of any business, entity or ratepayer that was approved for inclusion in the Energy Cost Savings Program (ESCP) including the date of their approval for the years 2013-2023.

List of applicants of the energy cost savings program and list of approved applicants.

1

Not on Open Data Plan

Small dataset with minimal updates and contains participant information.

2024

Department of Small Business Services (SBS)

Data on Brooklyn WF1 Center

Data on the Brooklyn WF1 Center in Brooklyn Navy Yard

1

Not on Open Data Plan

Contains some confidential information.

2024

Department of Social Services (DSS) - Department of Homeless Services (DHS)

Associated Address by Borough and Community District

Presents the number of cases and individuals for each shelter case type by borough and community district

1

Already on Open Data

https://data.cityofnewyork.us/Social-Services/Associated-Address-by-Borough-and-Community-Distri/ur7y-ziyb/about_data

2024

Department of Social Services (DSS) - Department of Homeless Services (DHS)

Buildings by Borough and Community District

Displays the total number of shelter buildings by borough and community district

2

Already on Open Data

https://data.cityofnewyork.us/Social-Services/Buildings-by-Borough-and-Community-District/3qem-6v3v/about_data

2024

Department of Social Services (DSS) - Department of Homeless Services (DHS)

Special Initiatives Moveouts and Placements

Special Initiatives Moveouts and Placements

1

Already on Open Data

https://data.cityofnewyork.us/Social-Services/Special-Initiatives-Moveouts-and-Placements/vnwq-9b7b/about_data

2024

Department of Transportation (DOT)

311 Service Requests from 2010- Present

Tracks DOT services in the City's Customer Service center application in Microsoft Dynamics.

1016

Already on Open Data

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

2024

Department of Transportation (DOT)

Bicycle Parking

DOT's CityRacks provide free sidewalk bicycle parking racks throughout the five boroughs. CityRacks are a convenience for the entire cycling community. Also, the availability of CityRacks parking discourages cyclists from parking at mailboxes, parking meters, trees, and other sidewalk structures. Bike corrals are rows of CityRacks installed in the curbside lane of the street instead of the sidewalk.

1

Already on Open Data

https://data.cityofnewyork.us/Transportation/Bicycle-Parking/yh4a-g3fj

2024

Department of Transportation (DOT)

Bike Rack Work Order

Tracks bicycle rack work orders.

2

Already on Open Data

https://data.cityofnewyork.us/Transportation/Traffic-Bollards-Tracking-and-Installations/3f5t-9dqu/about_data

2024

Department of Transportation (DOT)

Bridges-Daily Work Assignment Sheet

Tracks crew schedules and work performed by the Bridge Maintenance team.

5

Not on Open Data Plan

Not Public Data- Internal Administration, contains employee records, facilities data, schedule assignments, etc. Not in tabular format.

2024

Department of Transportation (DOT)

Bridges-Work Ticket

Tracks crew schedules and work performed by the Bridge Maintenance team.

3

Not on Open Data Plan

Not Public Data- Internal Administration, contains employee records, facilities data, schedule assignments, etc. Not in tabular format.

2024

Department of Transportation (DOT)

Commissioner's Correspondences

DOT receives, tracks, and responds to correspondences sent to the Commissioner's Correspondence Unit (CCU) and Borough Commissioner’s (BC) offices. This includes some requests initially sent to 311 and the Mayor's Office, and then forwarded to DOT.

261

Already on Open Data

https://data.cityofnewyork.us/Transportation/Commissioner-s-Correspondence/b4mf-rg6h

2024

Department of Transportation (DOT)

Design Markings

Tracks maintenance and inspections of pavement markings.

8

Not on Open Data Plan

Not Public Data- Internal Administration, contains employee records, facilities data, schedule assignments, etc. Not in tabular format.

2024

Department of Transportation (DOT)

DOT Street Lights and Traffic Signals (311 Service Requests from 2010 to Present)

DOT Street Light and Traffic Signal Work Orders service requests available in 311 Service Request from 2010 to Present.

41

Already on Open Data

https://data.cityofnewyork.us/Transportation/DOT-Street-Lights-and-Traffic-Signals-311-Service-/jwvp-gyiq

2024

Department of Transportation (DOT)

Estimated Street Light Operational Hours

The daily estimated on and off times of street lights using photo electric cell (PEC).

63

Not on Open Data Plan

Not Public Data- Image file; one time data, not regularly updated.

2024

Department of Transportation (DOT)

Gang Sheets-Highways/Arterials

Tracks crew schedules and work performed by the Arterial Highway Maintenance team.

2

Not on Open Data Plan

Not Public Data- Internal Administration, contains employee records, facilities data, schedule assignments, etc. Not in tabular format.

2024

Department of Transportation (DOT)

Gang Sheets-Street Maintenance

Tracks crew schedules and work performed by the Street Maintenance team.

308

Not on Open Data Plan

Not Public Data- Internal Administration, contains employee records, facilities data, schedule assignments, etc. Not in tabular format.

2024

Department of Transportation (DOT)

Meter-Maintenance Detail by Space

Tracks maintenance work by the Meter Collections Group

1

Not on Open Data Plan

Not Public Data- Internal Administration; Security and public safety concerns.

2024

Department of Transportation (DOT)

Meter-Parking Meter Order

Tracks maintenance work by the Meter Collections Group

4

Not on Open Data Plan

Not Public Data- Internal Administration; Security and public safety concerns.

2024

Department of Transportation (DOT)

Open Parking and Camera Violations

American Traffic Solutions is NYC DOT’s vendor to support automated camera enforcement functions for bus lane camera, red light cameras and school speed zone cameras. Axis is their violation processing and tracking system, including violation review by NYC DOT staff, issuance of summonses by NYC DOT staff. It also integrates with DOF functions for adjudication, payment, etc.

3

Already on Open Data

https://data.cityofnewyork.us/City-Government/Open-Parking-and-Camera-Violations/nc67-uf89

2024

Department of Transportation (DOT)

Open Restaurants

The New York City Open Restaurant is an effort to implement a citywide multi-phase program to expand outdoor seating options for food establishments to promote open space, enhance social distancing, and help them rebound in these difficult economic times.

4

Already on Open Data

https://data.cityofnewyork.us/Transportation/Open-Restaurant-Applications-Historic-/pitm-atqc/about_data

2024

Department of Transportation (DOT)

Parking Meter Location and Status

Tracks the condition and status of the parking meters.

1

Already on Open Data

https://data.cityofnewyork.us/Transportation/Parking-Meters-Locations-and-Status/693u-uax6

2024

Department of Transportation (DOT)

Pedestrian Ramp Complaints

This dataset tracks corner and pedestrian ramp complaints and their temporary repair status. Temporary repairs may include but are not limited to the use of asphalt on corners and pedestrian ramps.

5

Already on Open Data

https://data.cityofnewyork.us/Transportation/Pedestrian-Ramp-Complaints/jagj-gttd

2024

Department of Transportation (DOT)

Pedestrian Ramp- Program Progress

The Pedramps application is used to record the accessibility of a street corner, type and grade of pedestrian ramps.

156

Already on Open Data

https://data.cityofnewyork.us/Transportation/Pedestrian-Ramp-Program-Progress/e7gc-ub6z/about_data