NYC Open Data Help Desk: Public Dataset Requests

6220

Department of Health and Mental Hygiene (DOHMH)

Hello! I am writing an infant mortality report for ***. In the past, we have included a comparison to other large cities. Would you have 2018 infant mortality rates available for the City of New York? Overall and by race/ethnicity?

I am hoping that 2018 data is available but, if not, would 2017 data be available?


comparison to City of *** data

Good Morning ,

2018 data is not yet available for infant mortality rates for New York City, However, you can find 2017 IMR data in our Annual Summary of Vital Statistics (https://www1.nyc.gov/assets/doh/downloads/pdf/vs/2017sum.pdf).

Thank You,

Open Data Team

Closed: On Time

2019-12-23T00:00:00.000

2020-02-21T00:00:00.000

2019-12-27T00:00:00.000

2026-10-02T00:00:00.000

6211

New York City Police Department (NYPD)

I would like a list of EDP calls by borough, precinct, race, sex, age for 2016, 2017, and 2018?


I would like to understand who calls and what areas are emotionally disturbed people (EDP) call from

​Thank you for contacting NYC Open Data Help Desk. Please be advised that ​release of 911 call data is under review by NYPD legal.
​
Thank you,
- NYPD

Closed: On Time

2019-12-18T00:00:00.000

2020-02-16T00:00:00.000

2020-01-28T00:00:00.000

2026-10-02T00:00:00.000

6193

Department of Education (DOE)

I am looking for criminal complaints and arrests for school based behavior. It would be helpful if it could be broken down to the individual school level. This data would be useful in determining where support for schools should be focused.


Which schools need to be targeted to address:
1. gang based behavior
2. sexual based behavior
3. bullying\harassment
4. overall crime

Which schools have special education programs and would therefore need specialized assistance.

Hi ,

You can find the list of datasets maintained by the Department of Education here:
https://data.cityofnewyork.us/browse?Dataset-Infor...

Here is the link to our most recent stats provided by OSYD

https://data.cityofnewyork.us/Education/2017-2018-Schools-NYPD-Crime-Data-Report/kwvk-z7i9
Thank you,
- NYC Open Data Team

Closed: On Time

2019-12-16T00:00:00.000

2020-02-14T00:00:00.000

2019-12-16T00:00:00.000

2026-10-02T00:00:00.000

6188

Department of Education (DOE)

Data on STEM exposure/programming for black and Hispanic youth in NYC.
Exposure of math and science educational programs to black and Hispanic youth in DOE.
Math/Science test data (Regents) for black and Hispanic youth.


We are trying to determine if black and Hispanic youth are exposed to science, technology, engineering and math and how well they do in these subject areas.

Hi ,

It would help if you were specific about what data you trying to get access to. If it regents scores you need, a search on "Regents", should return the test scores.

Thank you,
- NYC Open Data Team

Closed: On Time

2019-12-13T00:00:00.000

2020-02-11T00:00:00.000

2019-12-16T00:00:00.000

2026-10-02T00:00:00.000

6185

Department of City Planning (DCP)

Hello - I'm look for a shapefile(s) for Subdivions in the five bouroughs.


I'm trying to locate polygons for Subdvisions (or sub-neighborhoods).

Hi, I'm not sure what scale you are looking for but there are several spatial layers that sub-divide the boroughs.

Community Districts:
Description: are mandated by the city charter to review and monitor quality of life issues for New York City neighborhoods
Data: https://data.cityofnewyork.us/City-Government/Community-Districts/yfnk-k7r4

Neighborhood Tabulation Areas (NTAs):
Description: Neighborhood Tabulation Areas (NTAs) were created to project populations at a small area level, from 2000 to 2030 for PlaNYC, the long-term sustainability plan for New York City. Since population size affects the error associated with population projections, these geographic units needed to have a minimum population, which we determined to be 15,000. This criterion resulted in combinations of neighborhoods that probably would not occur if one were solely designating boundaries of historical neighborhoods.
Data: https://data.cityofnewyork.us/City-Government/Neighborhood-Tabulation-Areas/cpf4-rkhq

Census Blocks and Tracts also sub-divide the Boroughs:
2010 Census Blocks water included: https://data.cityofnewyork.us/City-Government/2010-Census-Blocks-water-areas-included-/v9xd-tt3e
2010 Census Blocks (water excluded): https://data.cityofnewyork.us/City-Government/2010-Census-Blocks/v2h8-6mxf
2010 Census Tracts water included: https://data.cityofnewyork.us/City-Government/2010-Census-Tracts-water-areas-included-/gx7x-82rk
2010 Census Tracts (water excluded): https://data.cityofnewyork.us/City-Government/2010-Census-Tracts/fxpq-c8ku


Thank you,
-DCP Open Data Team

Closed: On Time

2019-12-12T00:00:00.000

2020-02-10T00:00:00.000

2019-12-12T00:00:00.000

2026-10-02T00:00:00.000

6178

Department of Education (DOE)

I am looking for a dataset that contains the names, phone numbers, and addresses of each public school in the NYC, hopefully with more demographic data as well including ages, genders, graduation rate. Basically, I would like the book that students in 7th and 8th grade are given for high schools but with all schools grade/middle/highschools in NYC


I want to figure out
1. How many many schools are in each neighborhood based on zip code
2. The percentage of colored students in each neighborhood
3. Percentage of male/female in each zip code.
4. Use population data to see the overall percentage of children being educated in each zip code.

Hi ,

No such dataset exists. I would suggest you combine the Demographic report and School location report to extract the data you require

Thank you,
- NYC Open Data Team

Closed: On Time

2019-12-10T00:00:00.000

2020-02-08T00:00:00.000

2019-12-17T00:00:00.000

2026-10-02T00:00:00.000

6177

Department of Social Services (DSS)

Hi, does the city release any data on the CityFHEPS voucher or any city-funded housing subsidy? Or any data marginally related to statistics on CityFHEPS, the city's subsidy budget?


What are the demographics of the voucher holders? How many of those are able to transition from shelter to the community with the voucher within a 3-month period of receiving a shopping letter? How many of those who have found housing with the voucher did not end up returning to the shelter within a one year and two year period? Where do shelter exits relocate to with the vouchers?How do these data vary for clients in prevention cases? Thanks.

Response not sent yet.

Pending: Past Due

2019-12-09T00:00:00.000

2020-02-07T00:00:00.000

2026-10-02T00:00:00.000

6169

Department of Consumer and Worker Protection (DCWP)

I would like to have access to past Legally Operating Businesses data. In the portal, I can have only access to the most recent data. So I wonder I could get the past histories of legally operating businesses. The interval could be each year, like 2011, 2012, 2013...2019.


I would like to figure out how rapidly the businesses have been changing in the recent years in NYC.

Thank you for contacting NYC Open Data Help Desk. The requested dataset can be found at https://data.cityofnewyork.us/Business/Legally-Operating-Businesses/w7w3-xahh
Please filter this data using License Creation Date column. For example, for 2011, you can specify the following filtering criteria:

License Creation Date is between 1/1/2011 and 12/31/2011

Thank you,
- NYC Open Data Team

Closed: On Time

2019-12-06T00:00:00.000

2020-02-04T00:00:00.000

2019-12-06T00:00:00.000

2026-10-02T00:00:00.000

6166

New York City Police Department (NYPD)

The 'New York model' comprising your Animal Cruelty Investigation Squad and partnership with the ASPCA appears to represent world's best practice.



I am yet to receive the core (comparative) statistics that I need to show what remarkable progress the NYPD and ASPCA have made since ACIS was formed. I have received general statements suggesting a big rise in productivity and protection of animals. However, I specifically require data pertaining to 2016 - present (by year) of: animal cruelty reports received; animal cruelty reports investigated; animals seized; prosecutions initiated and prosecutions finalised.

​Thank you for contacting NYC Open Data Help Desk. ​All criminal complaint reports can be found here:
https://data.cityofnewyork.us/Public-Safety/NYPD-C...
​
Thank you,
- NYPD
​

Closed: On Time

2019-12-06T00:00:00.000

2020-02-04T00:00:00.000

2020-01-28T00:00:00.000

2026-10-02T00:00:00.000

6165

Department of Youth and Community Development (DYCD)

Demographics by Zip Code for 2011 year.


The racial breakdown by zip code -- is racial composition and income related to prosecutorial decision-making?

Hi ,

The question asked in this request is:

‘The racial breakdown by zip code -- is racial composition and income related to prosecutorial decision-making?’

Final Determination:

The racial (and income) breakdown by zip code is for informational purposes only. It was not posted for a targeted audience, hence it is not intended for prosecutorial decision-making.

Also, please know that all the counts/percentages that are displayed for any of DYCD’s datasets pertain only to NYC residents who are funded by DYCD’s programs, and services. These counts/percentages do not include the entire NYC population.

Thanks,

Closed: On Time

2019-12-05T00:00:00.000

2020-02-03T00:00:00.000

2019-12-12T00:00:00.000

2026-10-02T00:00:00.000

6162

Department of Buildings (DOB)

Apparently, the NYC Department of Buildings currently posts 23 datasets in NYC OpenData.

In them I am unable to find the “Actual construction cost of completed work (total job cost)” as shown in toto and in detail on the form “PW3: Cost Affidavit” that every owner is required to submit to obtain Sign-off.

Is this information available in OpenData? If not, will it be made available in the future?

Estimated job cost and initial cost (initial cost = ‘estimated cost of job’) do not suffice as they are mere estimates. “Actual construction cost of completed work” is what is needed, and this is available on every PW3 submitted by permit holders to obtain Sign-off.

The significance is this: since time immemorial the NYC Department of Finance has obtained the actual costs from the Department of Buildings, for the purpose of adding the actual costs of new construction or renovation to the market value of the property, so that they may be taxed. Apparently, these costs have not yet found their way into any of the Department of Buildings’ Open Data datasets.

However, you may be sure that the Department of Finance obtains each and every one of the actual costs directly from the Department of Buildings, and always has. I have not yet been able to open some of the Department of Finance’s Open Data datasets, as it seems they cannot be opened by ordinary means. So, I do not yet know if the Department of Finance lists the actual costs somewhere in its Open Data datasets. But that it lists and analyzes them somewhere in its own internal datasets, is without doubt.

I would like to see two things happen: the Department of Buildings publish this data in its Open Data datasets, and the Department of Finance publish this data in its Open Data datasets.

Thank you.

Response not sent yet.

Pending: Past Due

2019-12-05T00:00:00.000

2020-02-03T00:00:00.000

2026-10-02T00:00:00.000

6151

Department of Education (DOE)

I am trying to download the Public School Locations zip file from your school point locations page.
https://data.cityofnewyork.us/Education/School-Point-Locations/jfju-ynrr

I can't seem to open these files as is, and was hoping you could send me PDF Versions or Excel/Google Spreadsheet. I would really appreciate it.


I am trying to collect information about the schools in our district.

You can find the list of datasets maintained by the Department of Education here:
https://data.cityofnewyork.us/browse?Dataset-Information_Agency=Department+of+Citywide+Administrative+Services+%28DCAS%29&provenance=official

The data is available by doing a search on "SCHOOL LOCATIONS"

https://data.cityofnewyork.us/Education/2019-2020-School-Locations/wg9x-4ke6

Thank you,
- NYC Open Data Team

Closed: On Time

2019-12-04T00:00:00.000

2020-02-02T00:00:00.000

2019-12-06T00:00:00.000

2026-10-02T00:00:00.000

6149

New York City Police Department (NYPD)

Hello,

The Youth Development in Diverse Contexts research lab at *** is seeking weekly or daily data on hate crime, with the inclusion of motivation, type of crime, and victim and perpetrator demographics. We would like this information for 2015, 2016, 2017, 2018, and 2019. We only need data for precincts 26, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 52, 61, 66, 67, 68, 70, 71, 72, 73, 75, 77, 81, 84, 88, 94, 100, 102, 103, 104,
105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, but are happy to have data on all of them if that is easier to compile, as long as we can identify the location that the crime took place.


We are aiming to identify the impact that crime in one's neighborhood impacts sleep quality. We have previously collected other crime statistics, but hate crime data was missing from the dataset.

​Thank you for contacting NYC Open Data Help Desk. Please be advised that due to their sensitive nature, and to avoid potential re-victimization, details on hate crimes are not released.
Thank you,
- NYPD

Closed: On Time

2019-12-04T00:00:00.000

2020-02-02T00:00:00.000

2020-01-28T00:00:00.000

2026-10-02T00:00:00.000

6145

Department of City Planning (DCP)

Hi I am looking to get a list of zip codes in each community district.


I'm looking into identifying what zip codes comprise the newly created commercial waste hauling zones.

There is not a list of zip codes by community district. Both those datasets exist as separate GIS files which you can overlay to determine which zip codes are in each community district.

The data you've requested can be found here:
Zip Codes: https://data.cityofnewyork.us/Business/Zip-Code-Boundaries/i8iw-xf4u
Community Districts: https://data.cityofnewyork.us/City-Government/Community-Districts/yfnk-k7r4

Thank you,
- DCP Open Data Team

Closed: On Time

2019-12-03T00:00:00.000

2020-02-01T00:00:00.000

2019-12-05T00:00:00.000

2026-10-02T00:00:00.000

6141

Department of Citywide Administrative Services (DCAS)

As per Local Law 11 of 2012 (NYC Open Data law), Local Law 109 of 2015 (timely and thorough responses to the public), and Local Law 251 of 2017 (requirement to publish all public datasets on the Open Data Portal), I hereby make the following request and ask that you comply with the above referenced laws:

1. I would like to see Citywide Payroll Data for Fiscal Years 2008 through and including 2013, specifically for the Department of Sanitation. On the NYC Open Data website your data only goes back to FY2014.

2. I would like to know the borough work location of Sanitation Workers for FY 2014. The NYC Open Data portal information is not complete for that sub-dataset. It has the work borough location for DSNY employees for FY 2015-2019, but not for 2014.


I'm exercising my rights under the above cited laws to answer my questions with the data. It's as simple as that.

You denied my previous request on the grounds that medical information cannot be made public. However, the type of information I'm requesting now is ALREADY public. Payroll info is public, it's already in the public domain, so that excuse won't fly. I'm just asking for more transparency in disclosure.

And don't deny it on the grounds that it's "too much" info. I'm not asking for the entire city's payroll info. I'm just asking for the DSNY payroll info, just one department, that's it, for FY 2008-2013. And also the work borough locations for 2014. You guys have this info on spreadsheets already, it doesn't take much to either upload it to the NYC Open Data Portal or send it to me directly.

Please comply with the above cited laws and fulfill this simple request. Cagey responses or denials under false pretenses are not in compliance with the laws.

Thank you in advance.

FISA-OPA maintains this dataset as a point in time. The work borough location was not part of this dataset when it was published for Fiscal Year 2014. What would be produced now would not necessarily match the available published data. The same explanation goes for previous years—we would not be able to produce accurate results on past data without data integrity issues. Please submit a FOIL request to DSNY or OPA on OpenRecords for this data via Open Records: https://a860-openrecords.nyc.gov/.

FOIL stands for the Freedom of Information Law. The New York State Freedom of Information Law requires government agencies to provide records to the public upon request. Government records affect the lives of each New Yorker, and providing easy access to the records makes government work better. The FOIL definition of records is very broad and includes information found in paper and electronic documents and audio and visual recordings. All records are available upon request, unless an exception in FOIL permits an agency to deny access to a record. Learn more about FOIL requests via this Frequently Asked Questions page.

Thank you,
NYC Financial Information Services Agency and the Office of Payroll Administration (FISA-OPA)

Closed: Past Due

2019-12-03T00:00:00.000

2020-02-01T00:00:00.000

2023-05-24T00:00:00.000

2026-10-02T00:00:00.000

6135

Department of Sanitation (DSNY)

The number of injuries on the job for sanitation workers, supervisors, and general superintendents in DSNY

the probabilities of incurring an on the job injury for DSNY workers who perform the most street-level job functions;

also, comparing national statistics about sanitation worker injuries with injury rates for sanitation workers in the 5 boros, seeing if NYC has a higher or lower rate of incidence.

Thank you for contacting NYC Open Data Help Desk. Please be advised that this information does not qualify to be on open data - the information relates to injuries and medical information cannot be made public.

Thank you,
- NYC Open Data Team
- NYC Department of Sanitation

Closed: On Time

2019-11-01T00:00:00.000

2019-12-31T00:00:00.000

2019-12-02T00:00:00.000

2026-10-02T00:00:00.000

6128

Department of Investigation (DOI)

City Marshall eviction data sheet from 1975-1977.

Response not sent yet.

Pending: Past Due

2019-11-29T00:00:00.000

2020-01-28T00:00:00.000

2026-10-02T00:00:00.000

6124

Department of Social Services (DSS)

I would like information on SNAP participation by demographics and zip-code in NYC at the week level during the time range 2018 to present.

To effectively answer my question, I would need at least age demographics, but the more granular the data, the better. To more effectively answer my question, I would like to observe SNAP participation by disability status as well.

I would also like data on SNAP eligibility by county (or zipcode!), if possible.


I am interested in studying why only 42% of eligible elderly take up SNAP benefits.

The introduction of the online purchasing pilot program in April of 2019 is a great setting to answer this question.

Response not sent yet.

Pending: Past Due

2019-11-27T00:00:00.000

2020-01-26T00:00:00.000

2026-10-02T00:00:00.000

6121

Department of City Planning (DCP)

I need a list of all the hotels in New York City, with their latitude and longitude (any additional information about like the amount of rooms would be helpful too).


I am writing a dissertation about restaurants in NYC and I need hotel locations to control for tourist or visitor density.

We are not aware of a specific hotel dataset that is publicly available. You could use PLUTO or MapPLUTO, which contain extensive land use and geographic data at the tax lot level (PLUTO is a CSV field, MapPLUTO is a geographic file available as file geodatabase or shapefile).

Within those datasets there is a Building Class field. You can select lots with Building Classes that start with "H" for hotel. You can see all of the Building Class values in the PLUTO data dictionary (Appendix C). You should review Appendix C to see if there are any other building classes that meet your criteria.

The data you've requested can be found here:
https://www1.nyc.gov/site/planning/data-maps/open-data/dwn-pluto-mappluto.page

Thank you,
-DCP Open Data Team

Closed: On Time

2019-11-27T00:00:00.000

2020-01-26T00:00:00.000

2019-12-05T00:00:00.000

2026-10-02T00:00:00.000

6118

Department of Health and Mental Hygiene (DOHMH)

To see a list of Newest restaurants that are open or before they open.

Your site has restaurants or food places that are not inspected yet, but not available in a list one one health site while another has it but not in order unless one knows the name to see them all.


Trying to see which food places are new to visit first which have discounts sometimes on the first 2 days.
Do you have a link on your site that shows an updated list every day or week? or see what is the newest?
Thanks

Good Afternoon,

The DOHMH New York City restaurant Inspection Results dataset on Open Data portal is updated daily with inspection information for all active restaurant food service establishments. An active restaurant food service establishment is one that has a valid Food Service Establishment Permit, which needs to be renewed annually. Every restaurant in New York City is scheduled for an unannounced inspection at least once a year. During the inspection, an inspector checks for compliance with city and state food safety regulations and marks points for any condition that violates these rules. Information on restaurants that do not have a valid Food Service Establishment Permit is not available.

Thank You,

Open Data Team

Closed: On Time

2019-11-25T00:00:00.000

2020-01-24T00:00:00.000

2019-12-02T00:00:00.000

2026-10-02T00:00:00.000

6117

Agency not assigned yet.

I am looking for information on how much is spent on the capital improvements and operating costs of cemeteries.


I would love some help in identifying which budget data sets to look at specifically for cemeteries across NYC.

​Thank you for contacting NYC Open Data Help Desk. ​At this time, we believe that your requested dataset is not maintained by a New York City agency. You are encouraged to contact New York State Division of Cemeteries at https://www.dos.ny.gov/cmty/cemfaqs.html
​NYC Department of Correction maintains Hart Island and you can reach out to this agency for more information at hartisland@doc.nyc.gov
​
Thank you,
- NYC Open Data Team

Closed: On Time

2019-11-25T00:00:00.000

2020-01-24T00:00:00.000

2019-11-26T00:00:00.000

2026-10-02T00:00:00.000

6115

Department of Transportation (DOT)

Foot traffic count at specific locations


Foot traffic count for retail locations, by address if available?

Hi ,

Thank you for your inquiry on pedestrian foot traffic counts. The data you've requested can be found here: https://data.cityofnewyork.us/Transportation/Bi-Annual-Pedestrian-Counts/2de2-6x2h

This data contains pedestrian counts for 114 locations throughout New York City. For nominations, please visit the Contact DOT website: https://www1.nyc.gov/html/dot/html/contact/contact-form.shtml

Thank you,
- NYCDOT Open Data Team

Closed: On Time

2019-11-24T00:00:00.000

2020-01-23T00:00:00.000

2019-12-30T00:00:00.000

2026-10-02T00:00:00.000

6114

Department of City Planning (DCP)

I am trying to locate demographics by county. Gender, marital status, age and income. I am not able to locate this dataset on any of the ny data sites.


It's for a course I am taking at ***

That data is published by the US Census Bureau and is not required to be on NYC Open Data Portal. However, the Department of City Planning (DCP) has made Census data available for NYC on our website. In New York City, the five boroughs are equivalent to counties so you should use the borough level when downloading any of our data.

Before getting started please read the "How to make sense of the data" section.

For Decennial Census demographic info go here: https://www1.nyc.gov/site/planning/planning-level/nyc-population/census-2010.page (you will probably find what you need here)

For American Community Survey samples go here: https://www1.nyc.gov/site/planning/planning-level/nyc-population/american-community-survey.page

We also have two web applications that may be useful for your research:
NYC Population Fact Finder: https://popfactfinder.planning.nyc.gov/
Metro Region Explorer: https://metroexplorer.planning.nyc.gov/
-If you go to the 'About' section you can download demographic data on many levels (including County) beyond the NYC City limits.


Thank you,
- DCP Open Data Team

Closed: On Time

2019-11-24T00:00:00.000

2020-01-23T00:00:00.000

2019-11-25T00:00:00.000

2026-10-02T00:00:00.000

6107

Department of Environmental Protection (DEP)

I am seeking the shapefiles / feature classes used to delineate the drainage basins in these maps:

http://www.nyc.gov/html/oec/downloads/pdf/2010_ceqr_tm/2010_ceqr_tm_ch13_water_sewer_infrastructure_drainage_areas.pdf


It is far easier and quicker to identify if a project site is within a drainage feature class than digging through these maps.

The information you are looking for is not maintained by NYC Open Data as it is not a dataset as describe in the Open Data law. For information requests (documents, correspondence, etc.) we encourage you to submit a FOIL request via Open Records: https://a860-openrecords.nyc.gov/

FOIL stands for the Freedom of Information Law. The New York State Freedom of Information Law requires government agencies to provide records to the public upon request. Government records affect the lives of each New Yorker, and providing easy access to the records makes government work better. The FOIL definition of records is very broad and includes information found in paper and electronic documents and audio and visual recordings. All records are available upon request, unless an exception in FOIL permits an agency to deny access to a record. Learn more about FOIL requests via this Frequently Asked Questions page.

Thank you,
- NYC Open Data Team

Closed: On Time

2019-11-22T00:00:00.000

2020-01-21T00:00:00.000

2019-11-25T00:00:00.000

2026-10-02T00:00:00.000

6101

Department of Education (DOE)

A share/count of students that are absent every day, by gender and by grade.


We are trying to study the impact of video game releases on school attendance and employment.

You can find the list of attendance datasets maintained by the Department of Education here:
​https://data.cityofnewyork.us/browse?Dataset-Information_Agency=Department+of+Education+%28DOE%29&provenance=official using the keyword "ATTENDANCE"

The NYC Open Data team is committed to making City data available for anyone to access online. We cannot accommodate requests to perform individual lookups or queries for single data points or records available in an Open Data dataset.

For more help with filtering or searching within a single dataset for an individual record, consult these
video guides.

Thank you,
- NYC Open Data Team

Closed: On Time

2019-11-22T00:00:00.000

2020-01-21T00:00:00.000

2019-12-06T00:00:00.000

2026-10-02T00:00:00.000

6097

311

311 Calls regarding unsanitary/dirty conditions made in the last year in the community board 1 Bronx district area.


How many 311 calls regarding unsanitary/dirty conditions were made by Community Board 1 residents in the last year since November 2018 to present? What kinds of conditions are reported?

Thank you for contacting NYC Open Data Help Desk. The requested ​dataset can be found at https://data.cityofnewyork.us/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9/data
You can filter this dataset for the following two conditions:
​
​​Community Board contains 01 BRONX
​Complaint Type contains UNSANITARY
​
Thank you,
- NYC Open Data Team

Closed: On Time

2019-11-21T00:00:00.000

2020-01-20T00:00:00.000

2019-11-21T00:00:00.000

2026-10-02T00:00:00.000

6096

Department of City Planning (DCP)

Our group is interested in finding out what cemeteries are really costing NYC. We want to know how much cemetery land is worth and what NYC is missing out on by keeping the large plots of land as cemeteries. We will also look at how cemeteries impact the housing market: are homes within 100 yards of a cemetery purchased for less than similar homes that are not within that boundary? We will also explore the demand for cemeteries and look at death rates and data on how many people are choosing cremation over burials. This will help us understand if there is still a high demand for cemeteries, or if they remain due to historical preservation.
Currently, We are focusing on calvary and greenwood cemeteries. It would be very much helpful if you could give us some cvs file related to this.


Assessing the economic impact of cemeteries: are cemeteries a waste of space?

The data you've requested can be found here:
https://www1.nyc.gov/site/planning/data-maps/open-data/dwn-pluto-mappluto.page (download MapPLUTO - shoreline clipped (shapefile))

To find tax lots that contain cemeteries you should filter the Building Class field for value 'Z8' - cemetery. You can use the AssessTot field to find the Assessed Total Value. This is not necessarily the property value, this is the value the Department of Finance uses to determine property tax. You can also do a spatial query to determine which lots are within a distance from cemeteries and find their total assessed value as well. You may want to look up the Owner Name of the cemeteries - most are privately owned.

Please consult the PLUTO data dictionary for any questions regarding MapPLUTO fields and values.

The Planimetrics dataset from DOITT also contains a Cemetery outline feature but does not contain much attribute information. That dataset can be found here:
https://data.cityofnewyork.us/Transportation/NYC-Planimetrics/wt4d-p43d


Thank you,
- DCP Open Data Team

Closed: On Time

2019-11-21T00:00:00.000

2020-01-20T00:00:00.000

2019-11-21T00:00:00.000

2026-10-02T00:00:00.000

6090

Taxi and Limousine Commission (TLC)

I'm trying to find a dataset of the Yellow Taxis with the geo information (longitude and latitude) of each trip. I was only able to finde dataset that included the start- and endpoint of the trip, but I would need it of the whole ride. As well I would need the columns that are already in the Datasets (Tip_amount, Total_amount, Payment_type...) especially the tip amount and the total amount. If you could help me with that it would be a huge help for me!
Thank you for taking your time reading it and maybe taking your time getting the data : )


I try to figure out what kind of influence the season, time as well as the beginning- and end point on the tip of the trip has.

Thank you for reaching out about the Taxi and Limousine Commission's yellow taxi trip records. The TLC does not release coordinate data from taxi trips to the public. This information can be used to identify passengers and taxi drivers, and therefore constitutes personally-identifying information, which is exempt under the Freedom of Information Law (FOIL). The fare and tip information you listed is included in the Open Data lists which are already posted online.

Best,
NYC Open Data + Taxi and Limousine Commission

Closed: On Time

2019-11-19T00:00:00.000

2020-01-18T00:00:00.000

2019-11-19T00:00:00.000

2026-10-02T00:00:00.000

6066

Agency not assigned yet.

Up-time and any service outages for MTA card machines.


I’d like to understand the availability of these critical services to purchase subway rides given recent crack-down with date evasion.

Thank you for contacting NYC Open Data Help Desk. At this time, we believe that your nominated data set is not maintained by a New York City agency. The Metropolitan Transportation Authority (MTA) is not a NYC Agency and does not fall under the purview of the Open Data Law.

You are encouraged to directly contact this organization at https://new.mta.info/contact-us
​
Thank you,
- NYC Open Data Team

Closed: On Time

2019-11-14T00:00:00.000

2020-01-13T00:00:00.000

2019-11-14T00:00:00.000

2026-10-02T00:00:00.000

6061

New York City Housing Authority (NYCHA)

Can you add all the data that in behind this reporting system on lead testing: https://my.nycha.info/PublicSite/Transparency/XrfReport


Study conditions in NYCHA housing and health affects on tenants

Thank you for contacting NYC Open Data Help Desk. Please be advised that this request has to be submitted to NYCHA’s FOIL unit with the Freedom of Information Law Request Form at https://www1.nyc.gov/assets/nycha/downloads/pdf/nycha-foil-request-form.pdf
​For additional information, please visit https://www1.nyc.gov/assets/nycha/downloads/pdf/FOIL.FAQ.pdf

Thank you,
- NYC Open Data Team

Closed: On Time

2019-11-13T00:00:00.000

2020-01-12T00:00:00.000

2019-11-13T00:00:00.000

2026-10-02T00:00:00.000

6057

Mayor's Office of Climate and Environmental Justice (MOCEJ)

Number of new developments in CEQR phase, as well as the following characteristics of each development: building type (commercial, resi, hotel etc), sqft, # of stories, architect, construction cost and if owner is public or private.


We are trying to get a better understanding of new construction projects, so we can create more relevant offerings for our engineering services.

​Thank you for contacting NYC Open Data Help Desk. The requested information might be found in the following dataset(s):
​
​https://data.cityofnewyork.us/browse?q=ceqr&sortBy=relevance&tags=moec
​
Thank you,
- NYC Open Data Team

Closed: On Time

2019-11-13T00:00:00.000

2020-01-12T00:00:00.000

2019-11-13T00:00:00.000

2026-10-02T00:00:00.000

6055

Administration for Children's Services (ACS)

Children In 24-hour Foster Care by Community District - for 2017 and prior years if available.


I have the as of December 31, 2018 data, but would like to compare with previous point in time.

Response not sent yet.

Pending: Past Due

2019-11-12T00:00:00.000

2020-01-11T00:00:00.000

2026-10-02T00:00:00.000

6054

New York City Police Department (NYPD)

all 911 calls assigned to NYPD (non CIP) from June of 2008 to June of 2016. Each individual call should have the date and time, the NYPD Sector or Police Precinct it came from, and the Final Incident Type.


Was there a drop in 911 calls among more Hispanic Precincts after NYC was activated for Secure Communities in May of 2012? Was there a drop in specific types of crimes reported? I need before and after data to make this analysis.

​Thank you for contacting NYC Open Data Help Desk. Please be advised that the release of 911 call data is being reviewed by NYPD legal. There is no anticipated date.
​
​Thank you,
- NYPD

Closed: Past Due

2019-11-12T00:00:00.000

2020-01-11T00:00:00.000

2020-01-28T00:00:00.000

2026-10-02T00:00:00.000

6043

Department of Health and Mental Hygiene (DOHMH)

I am interested in the DOHMH Farmers Markets dataset for multiple years (1990-2014) by community district.


I would like to know how farmers markets have grown throughout NYC from 1990-present.

Response not sent yet.

Pending: Past Due

2019-11-11T00:00:00.000

2020-01-10T00:00:00.000

2026-10-02T00:00:00.000

6041

New York City Fire Department (FDNY)

Hello. You have a dataset called "EMS Incident Dispatch Data" Seems like it only goes back to 2013. Wondering if you have prior years 2008 - 2012? Thank you.


Trying to determine if this data set exists for the years 2008 - 2012

​Thank you for contacting NYC Open Data Help Desk. Please be advised that ​EMS Incident Dispatch Data dataset was updated to include data for 2008-2019.
​https://data.cityofnewyork.us/Public-Safety/EMS-Incident-Dispatch-Data/76xm-jjuj
​
​To generate a specific list of records, you are encouraged to utilize Filter feature. For more information on how to filter a dataset, please refer to https://support.socrata.com/hc/en-us/articles/202950808-Creating-a-Filtered-View or directly reach out to Socrata support at https://support.socrata.com/hc/en-us
​
Thank you,
- NYC Open Data Team

Closed: Past Due

2019-11-11T00:00:00.000

2020-01-10T00:00:00.000

2020-02-20T00:00:00.000

2026-10-02T00:00:00.000

6040

Department of Finance (DOF)

I am interested in data sets related to real estate in the city and what’s in the neighborhoods


Services near a location
Past property information

Thank you for contacting NYC Open data Help Desk. You are encouraged to explore these datasets from the Department of Finance at ​https://data.cityofnewyork.us/browse?q=acris&sortBy=relevance
​​
Thank you,
- NYC Open Data Team

Closed: On Time

2019-11-08T00:00:00.000

2020-01-07T00:00:00.000

2019-11-12T00:00:00.000

2026-10-02T00:00:00.000

6036

Department of Buildings (DOB)

Historical data for the certificate of occupancy (that dates before the publically available dataset since 2012)


To measure the process of construction for multi-family houses and the uncertainty surrounding construction activity. I have a companion paper on single family housing construction (https://doi.org/10.1016/j.jfineco.2018.10.019) and was wondering if I could also extend it to multi-family housing in NYC.

Response not sent yet.

Pending: Past Due

2019-11-08T00:00:00.000

2020-01-07T00:00:00.000

2026-10-02T00:00:00.000

6034

Department of Buildings (DOB)

We, the Church, need to know if a contractor is operating with legal and clean license. Many send offer to build, to correct violations and build, but we need that they to be consider, are legal.


Contractor licensed list

Response not sent yet.

Pending: Past Due

2019-11-08T00:00:00.000

2020-01-07T00:00:00.000

2026-10-02T00:00:00.000

6031

Department of Finance (DOF)

A data set that contains the total number of units in a building, preferably by unit number so as to ascertain the arrangement of units within the structure.


We do surveys of buildings and in order to equitably distribute the survey to the occupants, we need to have a configuration of the units so we can equitably distribute to unit numbers that would provide the most equatable coverage of issues across the architecture and design for any particular building. For example, we wish to ascertain if certain parts of a building are receiving better or worse heating or A/C coverage. If we focus entirely on just one section of the building with our surveys, it would be unbalanced - so we need to distribute the surveys across all floors and levels but without swamping the entire building with surveys.

Hi ,
Department of Finance does not have a dataset of rental only buildings.

Thank you,
- NYC Open Data Team

Closed: On Time

2019-11-07T00:00:00.000

2020-01-06T00:00:00.000

2019-11-09T00:00:00.000

2026-10-02T00:00:00.000

6030

Mayor's Office of Climate and Environmental Justice (MOCEJ)

Energy and Water Data Disclosure for Local Law 84 2019( data for 2018)


To know the letter grade of my portfolio of buildings for LL33

Thank you for contacting NYC Open Data Help Desk. The requested dataset is expected to be released to public in November of this year.

Thank you,
- Mayor's Office of Sustainability (MOS)

Closed: On Time

2019-11-07T00:00:00.000

2020-01-06T00:00:00.000

2019-11-08T00:00:00.000

2026-10-02T00:00:00.000

6024

Department of Education (DOE)

Hello, I'm looking for individual exam-level information from NYC Department of Education. It should include records for the universe of NYC public school students who took one or more Regents exams over the period 1999 to 2018.


I'm interested how extreme weather impacts students' academic performance.

You can find the list of datasets maintained by the Department of Education here:
https://data.cityofnewyork.us/browse?Dataset-Information_Agency=Department+of+Citywide+Administrative+Services+%28DCAS%29&provenance=official

Aggregated regents scores can be found by doing a search on 'regents'. We would not provide individual regents records. That would be a FERPA violation


Thank you,
- NYC Open Data Team

Closed: On Time

2019-11-07T00:00:00.000

2020-01-06T00:00:00.000

2019-11-07T00:00:00.000

2026-10-02T00:00:00.000

6020

Department of Housing Preservation and Development (HPD)

I'd like to request that the automatic update schedule for HMC Complaints and Complaint Problems be changed from monthly to daily, to mirror when complaints become available via the HPD portal.


To provide the most up-to-date analysis it would be helpful to have the most recent HPD complaint data available at the same frequency as similar datasets such as HPD violations and DOB complaints, which are updated daily.

​Thank you for contacting NYC Open Data Help Desk. We are planning to change an update frequency for ​Housing Maintenance Code Complaints dataset from monthly to daily in a near future. Your request to change update frequency for the Complaint Problems dataset will be taken under consideration.
​
Thank you,
- NYC Open Data Team

Closed: On Time

2019-11-05T00:00:00.000

2020-01-04T00:00:00.000

2019-11-06T00:00:00.000

2026-10-02T00:00:00.000

6019

New York City Housing Authority (NYCHA)

Historical data for the size of the waitlist for public housing units. I am interested in how many people were on the waiting list for a public housing unit at its largest in each of the past 15 years.


I want to know whether demand for NYCHA Public Housing units has been growing or shrinking.

Thank you for contacting NYC Open Data Help Desk. Please be advised that this request has to be submitted to NYCHA’s FOIL unit with the Freedom of Information Law Request Form at https://www1.nyc.gov/assets/nycha/downloads/pdf/nycha-foil-request-form.pdf
​For additional information, please visit https://www1.nyc.gov/assets/nycha/downloads/pdf/FOIL.FAQ.pdf

Thank you,
- NYC Open Data Team

Closed: On Time

2019-11-05T00:00:00.000

2020-01-04T00:00:00.000

2019-11-06T00:00:00.000

2026-10-02T00:00:00.000

6016

New York City Police Department (NYPD)

I am an investigative researcher at***

I am interested in finding data regarding hotel crime in NYC. I have found an article from June of 2018 citing a research study done using NYPD data. (https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fnypost.com%2F2018%2F06%2F04%2Fcrime-in-nyc-hotels-has-skyrocketed-in-recent-years%2F&data=02%7C01%7Cagencyincoming%40customercare.nyc.gov%7C6343427219a54ad9f34308d7612a24ac%7C73d61799c28440228d4154cc4f1929ef%7C0%7C0%7C637084706697287412&sdata=bMWD7%2FH0FQIJ3DQPKE2bLUDC4%2FuyKVB2U%2FHqvrcgxZA%3D&reserved=0)

I was wondering if you could share where I could find information that is similar to what is listed in this article, if possible.


I am looking for the most RECENT data on hotel crime! If there is even more recent data than the article, I linked, I would be ever so grateful for it!

​Thank you for contacting NYC Open Data Help Desk. For the latest information on the NYC crime data, please refer to the NYPD Complaint Data Current (Year To Date) dataset at https://data.cityofnewyork.us/Public-Safety/NYPD-Complaint-Data-Current-Year-To-Date-/5uac-w243
Historical data is maintained at https://data.cityofnewyork.us/Public-Safety/NYPD-Complaint-Data-Historic/qgea-i56i
​
​For the hotel-specific complaints, please filter these datasets for the ​"PREM_TYP_DESC is HOTEL/MOTEL"
​
Thank you,
- NYC Open Data Team

Closed: On Time

2019-11-05T00:00:00.000

2020-01-04T00:00:00.000

2019-11-06T00:00:00.000

2026-10-02T00:00:00.000

6013

Department of Housing Preservation and Development (HPD)

When I look up a building in the HPD database, I can see information about the registration of the building. IE last filing date, property manager, etc.


I would love to have this to query which property managers are late on registering a building with the HPD.

Hi ,

The registration data be used to determine which property registrations are out of date, per our documentation. Each of our registration records contain information on the last valid registration date at the time of posting. A valid registration is one in which all of the appropriate data is supplied. Each registration will also display an expiration date. If the expiration date has passed, the property registration is not current. Note that this dataset is updated quarterly, so any information submitted after the last quarter ahead of the current publication date will not be available.

Thank you,
- NYC Open Data Team + NYC Department of Housing Preservation & Development

Closed: Past Due

2019-11-04T00:00:00.000

2020-01-03T00:00:00.000

2020-02-07T00:00:00.000

2026-10-02T00:00:00.000

6012

Department of City Planning (DCP)

I'm looking for PDF/Tiff files that are referenced from here: https://www1.nyc.gov/site/planning/zoning/zoning-map-table.page


Maps for a CEQR require zoning plans wherever our sites are located.

The data you've requested can be found here:
https://data.cityofnewyork.us/City-Government/Georeferenced-NYC-Zoning-Maps/mxbm-493w

There will be an update for October released soon.

Thank you,
- NYC DCP Open Data Team

Closed: On Time

2019-11-04T00:00:00.000

2020-01-03T00:00:00.000

2019-11-12T00:00:00.000

2026-10-02T00:00:00.000

6011

Department of Sanitation (DSNY)

Map of eligible bottle deposit sites, including reverse vending machines and recycling centers.
Create a presentation for showing people how easy it is to return bottles and cans; show variety of options available for people who have had one bad experience and have written it off.

​Thank you for contacting NYC Open Data Help Desk. Please be advised that ​New York’s Returnable Container Act is overseen by the New York State Dept of Environmental Conservation and not by a city agency - https://www.dec.ny.gov/chemical/8500.html
You are encouraged to reach out to the appropriate New York State agency for more information.
​
Thank you,
- NYC Open Data Team

Closed: On Time

2019-11-04T00:00:00.000

2020-01-03T00:00:00.000

2019-11-06T00:00:00.000

2026-10-02T00:00:00.000

6009

Department of Housing Preservation and Development (HPD)

I'd like to request that the automatic update schedule for HMC Complaints and Complaint Problems be changed from monthly to daily, to mirror when complaints become available via the HPD portal.


An app my organization has developed aims to provide users with the most recent HPD complaint data available. Currently, data on our app lag behind the HPD portal up to one month. In contrast, similar datasets such as HPD violations and DOB complaints are updated daily.

​Thank you for contacting NYC Open Data Help Desk. We are planning to change an update frequency for ​Housing Maintenance Code Complaints dataset from monthly to daily in a near future. Your request to change update frequency for the Complaint Problems dataset will be taken under consideration.
​
Thank you,
- NYC Open Data Team

Closed: On Time

2019-11-04T00:00:00.000

2020-01-03T00:00:00.000

2019-11-04T00:00:00.000

2026-10-02T00:00:00.000

6008

311

We are looking to locate a 311 call made by a *** on 04/13/2019 around 1:30PM. Police records show - Dispatch listed the location as *** as a “pickup” - possibly mentioned was a missing/stolen vehicle.


please let me know if you are able to locate this call and how i can obtain these records, and/or both audio and call log.

​​Thank you for contacting NYC Open Data Help Desk. Please submit your request through the NYC OpenRecords FOIL portal at nyc.gov/openrecords and FOIL Department of Information Technology & Telecommunications (DoITT).
Thank you,
- NYC Open Data Team

Closed: On Time

2019-11-04T00:00:00.000

2020-01-03T00:00:00.000

2019-11-07T00:00:00.000

2026-10-02T00:00:00.000

6007

New York City Police Department (NYPD)

Crime Data set


Research project

​Thank you for contacting NYC Open Data Help Desk. NYC Open Data portal maintains a number of datasets from the NYPD which contain the requested data. The list of all the NYPD datasets can be accessed at https://data.cityofnewyork.us/browse?Dataset-Information_Agency=Police+Department+%28NYPD%29&q=&sortBy=relevance
All the reported crime information for NYC is available at https://data.cityofnewyork.us/Public-Safety/NYPD-Complaint-Data-Current-Year-To-Date-/5uac-w243 and https://data.cityofnewyork.us/Public-Safety/NYPD-Complaint-Data-Historic/qgea-i56i

Thank you,
- NYC Open Data Team

Closed: On Time

2019-11-02T00:00:00.000

2020-01-01T00:00:00.000

2019-11-04T00:00:00.000

2026-10-02T00:00:00.000