NYC Open Data Plan: FOIL Datasets

2023

Department of Correction (DOC)

Rikers Island Emissions

Records reflecting collection of emissions information on Rikers Island, including emissions testing data collected in connection with Title V permit reporting requirements.

1

Not on Open Data Plan

Detail level data is not kept In a machine-readable format

2023

Department of Correction (DOC)

Rikers Island Hazardous Substances

Any records regarding the release of hazardous substances to the environment on Rikers Island

1

Not on Open Data Plan

Detail level data is not kept In a machine-readable format

2023

Department of Correction (DOC)

Suicide Watch List

The number of detainees on suicide watch per day

1

Not on Open Data Plan

Historical data is not retained in a machine readable format

2023

Department of Correction (DOC)

Video Teleconference

Statistics relative to the number of scheduled VTC appearances per day
The Number of cancellations
The Number of non-produced inmates

1

Not on Open Data Plan

Detail level data is not kept In a machine-readable format

2023

Department of Correction (DOC)

Weapon Contraband Recovered

Inventory of all Weapons Seized, 2020 to Present

1

Not on Open Data Plan

Detail level data is not kept In a machine-readable format

2023

Department of Correction (DOC)

Young Adults in Custody

Number of Individuals in DOC Custody on March 15, 2023 under the age of 22

1

Not on Open Data Plan

This dataset is not historically maintained and must be computed on an ad-hoc basis.

2023

Department of Cultural Affairs (DCLA)

DCLA Programs Funding

Request asked for all applicants for grants to organizations, so we sent the requester the DCLA Programs Funding data available on OpenData.

1

Already on Open Data

https://data.cityofnewyork.us/Recreation/DCLA-Programs-Funding/y6fv-k6p7

2023

Department of Education (DOE)

2005 - 2015 Graduation Outcomes.xslx

Graduation results for all students by year; cohorts of 2001 through 2011 (Classes of 2005 through 2015).

1

Already on Open Data

https://data.cityofnewyork.us/Education/2005-2015-Graduation-Outcomes/qk7d-gecv

2023

Department of Education (DOE)

2019 - 2020 School Year Local Law 226 Report for the Demographics of School Staff - Gender.xlsx

This report is prepared pursuant to Local Law 226 of 2019 regarding the demographics of school staff in New York City public schools.

1

Already on Open Data

https://data.cityofnewyork.us/Education/2019-2020-School-Year-Local-Law-226-Report-for-the/fnzt-d3f7

2023

Department of Education (DOE)

2020-2021 Local Law 102 Physical Education DM.xlsx

Local Law 102 enacted in 2015 requires the Department of Education of the New York City School District to submit to the Council an annual report concerning physical education for the prior school year.

1

Already on Open Data

https://data.cityofnewyork.us/Education/2020-2021-Local-Law-102-Physical-Education/s47t-kwt5

2023

Department of Education (DOE)

2020-21 Diversity Report - Suppressed.xlsx

Report on Demographic Data in New York City Public Schools, 2020-21Enrollment counts are based on the November 13 Audited Register for 2020.

1

Already on Open Data

https://data.cityofnewyork.us/Education/2020-2021-Diversity-Report/8vk5-fzts

2023

Department of Education (DOE)

2022 SHSAT + Discovery Overall Summary.xlsx

2022 Admissions - SHSAT Offers by Ethnicity and School, Discovery Invitations By Ethnicity

1

Already on Open Data

https://data.cityofnewyork.us/dataset/2022-SHSAT-DISCOVERY-OVERALL-SUMMARY/unse-x4pq

2023

Department of Education (DOE)

Final21-22_Avg_ClassSize_School.xlsx

Class Size School report for middle and high school grades by program type, number of students, number of classes, and average class size.

1

Already on Open Data

https://data.cityofnewyork.us/Education/2021-2022-Average-Class-Size-by-School/sgr7-hhwp

2023

Department of Education (DOE)

FY 2020-2021 09212021 LL93 Annual Report on Student Discip DM.xlsx

Student discipline annual report for students in temporary housing aggregated by removals, principal and/or superintendent intervention and expulsions.

2

Already on Open Data

https://data.cityofnewyork.us/Education/2020-2021-Student-Discipline-Annual-Report-All/vzuc-vmd8

2023

Department of Education (DOE)

Learning Preference City Remote Learning - as of Jan 4, 2021.xslx

Total enrollment count for students whose learning preference is remote or blended or missing and who have attended school in person at least once since September 16, 2020.

1

Already on Open Data

https://data.cityofnewyork.us/Education/Learning-Preference-City-Remote-Learning-as-of-Jan/k5d2-tkrr

2023

Department of Education (DOE)

public-school-attendance-results.xlsx

Overall attendance data include students in Districts 1-32 and 75 (Special Education).

2

Already on Open Data

https://data.cityofnewyork.us/Education/2016-17-2020-21-District-End-of-Year-Attendance-an/hags-jh3e

2023

Department of Environmental Protection (DEP)

311 Database

Water/Sewer Complaints

398

Already on Open Data

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

2023

Department of Environmental Protection (DEP)

CHARMS Database

Employee Attendance Record

6

Not on Open Data Plan

Sensitive/Private Information

2023

Department of Environmental Protection (DEP)

DERTA Database/IPS Database

Hazardous Materials Storage

1081

Not on Open Data Plan

Sensitive Information; Disclosure would pose security risks to the public

2023

Department of Environmental Protection (DEP)

IPS Database

DEP Water Sewer Repairs

306

Already on Open Data

Work Order Management Module | NYC Open Data (cityofnewyork.us)

2023

Department of Environmental Protection (DEP)

PARIS Database

Water/Sewer Service Line Permits

2

Already on Open Data

Water and Sewer Permits | NYC Open Data (cityofnewyork.us)

2023

Department of Environmental Protection (DEP)

Passport Database

BID Results Tabulation

18

Not on Open Data Plan

One off report or analysis

2023

Department of Environmental Protection (DEP)

UMAX Database

Customer Water and Wastewater Charges

347

Not on Open Data Plan

Sensitive/Private Information

2023

Department of Finance (DOF)

Complete Report of Accounts (Surplus Funds)

List of all unclaimed monies being held by the DOF's Treasury Division

13

Scheduled for Future Publication

2023

Department of Finance (DOF)

Mortgage & Deed File

Dataset of all recorded deeds and mortgages in ACRIS for set time period

1

Already on Open Data

https://data.cityofnewyork.us/City-Government/ACRIS-Real-Property-Master/bnx9-e6tj

2023

Department of Finance (DOF)

Notice of Property Value (NOPV)

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

12

Not on Open Data Plan

Personal identifying information is contained in file and thus prohibited from publication on OpenData portal under local law. This dataset can only be produced under the state law provisions of FOIL.

2023

Department of Finance (DOF)

Open Parking and Camera Violations

Data of all tickets issued for camera and parking related violations

2

Already on Open Data

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

2023

Department of Finance (DOF)

Property Valuation and Assessment Data

Real Estate Assessment Property data.

4

Already on Open Data

https://data.cityofnewyork.us/City-Government/Property-Valuation-and-Assessment-Data/yjxr-fw8i

2023

Department of Finance (DOF)

Refund List - Real Property Tax

List of property tax refund checks which are 6 months old and uncashed

2

Already on Open Data

https://data.cityofnewyork.us/City-Government/DOF-Refund-List-Real-Property-Tax/w5ea-ydu3

2023

Department of Finance (DOF)

Statement of Account (SOA)

List of NYC properties which includes owner name, billing address, and quarterly billing amount due for property tax

11

Not on Open Data Plan

Personal identifying information is contained in file and thus prohibited from publication on OpenData portal under local law. This dataset can only be produced under the state law provisions of FOIL.

2023

Department of Finance (DOF)

Storefront Registry

Descriptive data found on the storefront registry filing for property owners with commercial storefronts

1

Already on Open Data

https://data.cityofnewyork.us/City-Government/Storefront-Registration-Class-2-and-4-Statistics/dxru-eun8

2023

Department of Finance (DOF)

Tax Lien Sale List

List of all properties scheduled to have property tax liens sold in the 2021 tax lien sale

5

Already on Open Data

https://data.cityofnewyork.us/City-Government/Tax-Lien-Sale-Lists/9rz4-mjek

2023

Department of Finance (DOF)

Tentative and Final Assessment Rolls 2022/23

The tentative and final assessment rolls for tax year 2022/23

10

Already on Open Data

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

2023

Department of Health and Mental Hygiene (DOHMH)

12-year carriage horse dataset

Data on horses 12-year period including names, permit numbers, owners, ages, and license status

2

Scheduled for Future Publication

2023

Department of Health and Mental Hygiene (DOHMH)

Active Hookah Permits in NYC

Current list of all licensed hookah establishments

1

Scheduled for Future Publication

2023

Department of Health and Mental Hygiene (DOHMH)

All Cooling Towers located in NYC

All Cooling Towers located in NYC

2

Already on Open Data

https://data.cityofnewyork.us/Health/NYC-Cooling-Tower-Registrations/y4fw-iqfr

2023

Department of Health and Mental Hygiene (DOHMH)

All deaths in NYC due to liver disease and cirrhosis for the past year

Requested data is contained within the annual Vital Statistics summary

1

Scheduled for Future Publication

2023

Department of Health and Mental Hygiene (DOHMH)

Assisted Outpatient Treatment data

Data on AOT investigations, initial petitions, and renewal petitions, broken down by borough and year

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.

2023

Department of Health and Mental Hygiene (DOHMH)

Campylobacter data

Campylobacter data for specific timeframes

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.

2023

Department of Health and Mental Hygiene (DOHMH)

Childcare programs

Total Group Child Care programs open since 2017 with opening dates, closing dates, and number of violations

1

Scheduled for Future Publication

2023

Department of Health and Mental Hygiene (DOHMH)

Child care sites

List of all childcare sites with complete and incomplete inspections

1

Already on Open Data

https://data.cityofnewyork.us/Health/DOHMH-Childcare-Center-Inspections/dsg6-ifza

2023

Department of Health and Mental Hygiene (DOHMH)

COVID-19 data

COVID-19 cases, hospitalizations, and vaccinations by race/ethnicity in Kings County

1

Scheduled for Future Publication

2023

Department of Health and Mental Hygiene (DOHMH)

COVID-19 death data

COVID-19 deaths broken down by age and year

1

Scheduled for Future Publication

2023

Department of Health and Mental Hygiene (DOHMH)

Current Carriage Horse list

Current list of active NYC carriage horses

3

Scheduled for Future Publication

2023

Department of Health and Mental Hygiene (DOHMH)

Data on DOHMH physicians

Data on DOHMH agency and contract physicians, including titles and salaries

1

Already on Open Data

https://data.cityofnewyork.us/City-Government/Citywide-Payroll-Data-Fiscal-Year-/k397-673e

2023

Department of Health and Mental Hygiene (DOHMH)

Data related to enforcement of Local Law 77

Data on amounts collated in fines and penalties from building owners/operators obligated to comply with Local Law 77, broken down by year from 2016-2021

1

Already on Open Data

https://data.cityofnewyork.us/City-Government/DOHMH-Cooling-Tower-OATH-Hearing-Results/xuea-qzre/data

2023

Department of Health and Mental Hygiene (DOHMH)

Data showing the amount of money spent on community and ethnic media outlets as defined in Executive Order 47

Data broken down by fiscal year and language/community on DOHMH advertising expenditures pursuant to Executive Order 47

1

Not on Open Data Plan

This data is part of the dataset that is not maintained by the DOHMH.

2023

Department of Health and Mental Hygiene (DOHMH)

Death data by day, 2020

All causes of death, broken down by day for calendar year 2020

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.

2023

Department of Health and Mental Hygiene (DOHMH)

Dog license dataset

Data on all licensed dogs in NYC

1

Already on Open Data

https://data.cityofnewyork.us/Health/NYC-Dog-Licensing-Dataset/nu7n-tubp

2023

Department of Health and Mental Hygiene (DOHMH)

DOHMH employee data

Data on name, title, and salary of DOHMH employees

2

Already on Open Data

https://data.cityofnewyork.us/City-Government/Citywide-Payroll-Data-Fiscal-Year-/k397-673e