NYC Open Data Help Desk: Data Questions and Reported Errors

7613

Data Question

Department of Buildings (DOB)

Is there a way to get the daily updates only, or does one have to redownload the entire dataset every day to get the daily updates?
Further, is there a way to connect a database to the SODA API in real time?

DOB Job Application Filings

https://data.cityofnewyork.us/d/ic3t-wcy2

Please refer to this link for API purposes. You can request an API key and make recurring API calls without limits.
https://dev.socrata.com/foundry/data.cityofnewyork.us/ic3t-wcy2



Thank you,
- NYC Open Data Team

Closed

2021-04-05T00:00:00.000

2026-10-02T00:00:00.000

7611

Data Question

Department of Buildings (DOB)

How can I get details about which rows are updated daily? Is there an indicator that indicates which rows were updated each day? Is there a way to create a real time connection to this dataset in my DB

DOB Job Application Filings

https://data.cityofnewyork.us/d/ic3t-wcy2

This entire data set is refreshed, and there is no flag or indicator for a record change.

Thank you,
- NYC Open Data Team

Closed

2021-04-05T00:00:00.000

2026-10-02T00:00:00.000

7610

Reported Error

Financial Information Services Agency / Office of Payroll Administration (FISA-OPA)

The name associated with this person should be ***** (my English name) and not *****.

Citywide Payroll Data (Fiscal Year)

https://data.cityofnewyork.us/d/k397-673e

Response not sent yet.

Pending

2021-04-05T00:00:00.000

2026-10-02T00:00:00.000

7607

Data Question

New York City Police Department (NYPD)

Hello,

When I export the data and open it, the excel file shows blank. It might be that the dataset is too large for my laptop. Is there any way for the department to send me violent crimes for the years of 2018-2020 only for the Bronx?

If even possible, could this be sent via shapefile? If not, excel is more than fine.

Thank you so much.

NYPD Complaint Data Historic

https://data.cityofnewyork.us/d/qgea-i56i

This data can be download as CSV. It can then be imported into a GIS like ArcGIS Pro and the latitude and longitude fields can be used to create point features

Thank you,
- NYC Open Data Team

Closed

2021-04-03T00:00:00.000

2026-10-02T00:00:00.000

7599

Data Question

Department of Health and Mental Hygiene (DOHMH)

Can this dataset be updated? It's only up until 2017 currently and seeing the cause of death from 2017 to now is what I'm trying to see (due to covid).

Thanks

New York City Leading Causes of Death

https://data.cityofnewyork.us/d/jb7j-dtam

Thanks for your interest in using NYC vital statistics data. We have reviewed your request for an update to Open Data tables for leading causes of death. Our analysts update and export annualized data tables to URL https://data.cityofnewyork.us/Health/New-York-City-Leading-Causes-of-Death/jb7j-dtam every December. Until this update is accomplished, we suggest that you review the available leading causes data in our recently-published 2018 Annual Summary of Vital Statistics https://www1.nyc.gov/assets/doh/downloads/pdf/vs/2018sum.pdf. Tables 1 and 2, M28, and Figure 10 cover leading causes of death overall, by race/ethnicity, sex and ages less than 65 years (“premature mortality”). Please contact the Office of Vital Statistics (vsdata@health.nyc.gov) if you have any questions about the data. Thank you.

Closed

2021-04-01T00:00:00.000

2026-10-02T00:00:00.000

7594

Data Question

Office of Technology and Innovation (OTI)

There are two shape files from the set. Can you tell me the difference?

Thank you.

Building Footprints (Deprecated)

https://data.cityofnewyork.us/d/nqwf-w8eh

To clarify, the Building Footprint data is offered either as point features or polygon features. So, one layer just has the polygons of the building footprints. The other layer just contains point features which serve as the centroid points of each footprint polygon.

Please feel free to reach out to us if you have anymore questions.

Closed

2021-03-29T00:00:00.000

2026-10-02T00:00:00.000

7593

Data Question

Department of Transportation (DOT)

Would it be possible to add more location information to the 'locations.csv' file? Adding 'phyiscal id', 'blockface id', 'segment id' will make the database more useful by making it possible to link the info to many other Open Data databases. Thank You.

Parking Regulation Locations and Signs

https://data.cityofnewyork.us/d/nfid-uabd

Thank you for contacting the NYC Open Data help desk. Unfortunately NYC DOT is unable to provide the requested information regarding adding segmentid, blockid and physicalid to the location.csv or sign.csv files because this data is computer system generated and the system does not store any LION information.
You may download the LION data from Open Data Portal and use the Spatial Join tool in ArcGIS to combine to the Parking Regulation shapefile (Target layer: Parking Regulation Signs, Join layer: LION, Match Option: Closest) to add the additional data including segmentid, blockid, physicalid and more. To add location.csv to LION fields, you may join the results from the Spatial Join to locations.csv by using sg_order_no (shapefile) and order_no (location.csv) fields.
LION data: https://data.cityofnewyork.us/City-Government/LION...
NOTE: To respond to this inquiry, you must edit your original submission by opening the following link and selecting "Edit Response": https://nyc-moda.forms.fm/nyc-open-data-team-help-desk/responses/FrrcR3eMMeM4

Closed

2021-03-27T00:00:00.000

2026-10-02T00:00:00.000

7592

Reported Error

Department of Transportation (DOT)

Commas in the 'sign description' field of the signs.csv file create a problem when creating an excel file or importing into Access. Extra unwanted fields are created by the insertion of the commas.

Parking Regulation Locations and Signs

https://data.cityofnewyork.us/d/nfid-uabd

Thank you for your request. The Parking Regulations Locations and Signs dataset does not contain any commas in the "Sign_Description" field in either CSV or shape file. Can you provide us with some additional information where you came across the commas so we can further assist you?

Closed

2021-03-27T00:00:00.000

2026-10-02T00:00:00.000

7589

Data Question

Agency not assigned yet.

My colleagues and I have noticed the spelling of Mariners Harbor in Staten Island is different in two NYC OpenData datasets. Your spelling is "Mariner's Harbor" with the apostrophe. From what I can tell, U.S.G.S., NOAA and NYC DoITT all spell it without the apostrophe. Is there are reason for your apostrophe or is it a typo? It's quite a mystery!
Thanks for your help.

No URL Submitted.

The Department of City Planning (DCP) created a map in 2014 called New York: A City of Neighborhoods and two datasets were released as a result of the map and open data laws, Neighborhood Names and Places (fka Areas of Interest). These were not meant to be a comprehensive nor an official list of neighborhoods. The neighborhood names were mostly taken from our Neighborhood Tabulation Areas (NTA) dataset, which listed Mariner's Harbor as an NTA. The source for that spelling came from the 1969 Plan for NYC. Since the release of that dataset in 2014 DCP has also observed several modern sources using different versions of that neighborhood name with and without the apostrophe, both public (NYCHA, Parks Dept., NYPL, USPS) and private (google maps, apple maps, waze, etc.).

DCP has decided that we will drop the apostrophe and use Mariners Harbor when we release our updated Neighborhood Tabulation Areas (NTA) dataset later this year. The Neighborhood Names dataset will also be updated to include this change and any others related to the NTA update.


Thank you,
- DCP Open Data Team

Closed

2021-03-25T00:00:00.000

2026-10-02T00:00:00.000

7588

Reported Error

Department of Buildings (DOB)

The dataset has not updated for two days. Can it please be updated?
Thanks!

DOB Permit Issuance

Thank you for using NYC Open Data and bringing this to our attention. The dataset has now been updated with the latest available information.

Closed

2021-03-24T00:00:00.000

2026-10-02T00:00:00.000

7587

Reported Error

Financial Information Services Agency / Office of Payroll Administration (FISA-OPA)

Please kindly remove the entries for Tamecca Seril/Tamecca Tillard the information reported is incorrect: https://data.cityofnewyork.us/City-Government/Citywide-Payroll-Data-Fiscal-Year-/k397-673e/data

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

Citywide Payroll Data (Fiscal Year)

https://data.cityofnewyork.us/d/k397-673e

Response not sent yet.

Pending

2021-03-24T00:00:00.000

2026-10-02T00:00:00.000

7584

Reported Error

New York City Police Department (NYPD)

Excel file is not open.
There is any other link that I can get this data from?

NYPD Complaint Data Historic

https://data.cityofnewyork.us/d/qgea-i56i

Thank you for contacting the NYC Open Data help desk.

The dataset you referenced contains nearly 7 million records, so it’s possible that the large file size is the reason while you can’t open the file in Excel.

We suggest filtering the dataset on Open Data before exporting to make the file size more manageable. The steps to carry that out are listed on our How-To page here: https://opendata.cityofnewyork.us/how-to/

Please let us know if you have any other questions.

Closed

2021-03-23T00:00:00.000

2026-10-02T00:00:00.000

7583

Data Question

Agency not assigned yet.

Are other variables/data available on the stores inspected? In particular, I was interested in the DCA license number (for tobacco retailers specifically) and other geographic information like Census Tract, Community District, etc. Thanks!

No URL Submitted.

The Inspections dataset is under review as it does not meet the current requirements for geo-spatial information (i.e., Census Tract, Community District) in NYC Open Data. You raise a very good point, that adding the license number where applicable would improve the dataset and make it more useful to the public. This suggestion will be included in the proposed revisions.

Closed

2021-03-22T00:00:00.000

2026-10-02T00:00:00.000

7582

Data Question

Department of Consumer and Worker Protection (DCWP)

In the Legally Operating Businesses dataset (and others) I noticed that the Census Tract variable sometimes doesn't have decimals. Is there a trick to figuring out CTs with decimals or to upload the data differently? It's hard to know if a number like 101 is 1.01 or actually 101.00. Thanks for your help!

Issued Licenses

https://data.cityofnewyork.us/d/w7w3-xahh

All DCWP datasets published to the NYC Open Data Portal are an accurate reflection of the data contained in our systems of record. It is a feature of Census Tracts that they can have decimals, and the existence or non-existence of a decimal is not an indication of data error.

Closed

2021-03-22T00:00:00.000

2026-10-02T00:00:00.000

7579

Data Question

Agency not assigned yet.

Hi, I am a graduate student at ***** and I had a question about the Open Restaurant Inspection dataset. Is it possible to see the reason why roadway restaurants were not compliant? Were the barriers not properly placed? Blocking bike lanes? Please let me know if this information is available to see. Thank you.

No URL Submitted.

Thank you for your request on additional information for the Open Restaurants Inspections dataset. The reason for roadway restaurants that are non-compliant may contain personally identifying information (PII) therefore it is not a public field for Open Data Portal. You may request this information for a specific time period or a specific restaurant through FOIL 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.

Closed

2021-03-22T00:00:00.000

2026-10-02T00:00:00.000

7578

Data Question

Department of Citywide Administrative Services (DCAS)

I found an older version of this dataset at this link https://data.world/city-of-ny/kpav-sd4t and I am enquiring as to whether I have your permission to use this dataset to perform exploratory data analysis for my university project. Your clarification would be appreciated. Kind regards, *****.

Jobs NYC Postings

https://data.cityofnewyork.us/d/kpav-sd4t

Response not sent yet.

Pending

2021-03-22T00:00:00.000

2026-10-02T00:00:00.000

7576

Data Question

Department of City Planning (DCP)

Can you kindly update Pluto data to version 21v1?

Primary Land Use Tax Lot Output (PLUTO)

https://data.cityofnewyork.us/d/64uk-42ks

The dataset has been updated with the latest available information.

Thank you,
- NYC Open Data Team

Closed

2021-03-21T00:00:00.000

2026-10-02T00:00:00.000

7573

Data Question

311

The dataset for 311 calls is 14Gb, can you tell me if there is a tool or method to only download the data of interest instead of the entire file. Excel will not open a file greater than 1 million rows, so basically the data on your site is useless. Why don't you have a query option to select only the data of interest? Thanks

311 Service Requests from 2020 to Present

https://data.cityofnewyork.us/d/erm2-nwe9

For all of our portal's tabular datasets, you can use a filtering option to narrow down the data you want to see. Socrata (the platform that powers NYC Open Data) explains this process here: https://support.socrata.com/hc/en-us/articles/2029...

You can create a smaller filtered view of the dataset and export only that subset of the data. Hope this helps.

Closed

2021-03-19T00:00:00.000

2026-10-02T00:00:00.000

7571

Data Question

Agency not assigned yet.

This data set is updated every month on the 8th. I was told that there is a paid version where we can get access to updated data on daily basis. Can you please point me to the right place to learn more & pricing

No URL Submitted.

Here are the links that will provide you with the information for ACRIS subscriptions.

https://a836-acris.nyc.gov/BandwidthPolicy/ACRIS-BW-POL.html

https://a836-acris.nyc.gov/EDS/index-image.htm

The first link at this location is the Getting Started Page:

https://a836-acris.nyc.gov/EDS/Overview/index-image-gettingstarted.htm

which explains the different offerings:

Subscribers have complete control over their subscriptions and can choose from the following data selections:
Any combination of Boroughs
Images and/or Index Data
Real and/or Personal Property Documents
and has a link to a PDF with fees for the different offerings:

https://a836-acris.nyc.gov/EDS/Overview/acris_fees.pdf

Closed

2021-03-19T00:00:00.000

2026-10-02T00:00:00.000

7570

Reported Error

Agency not assigned yet.

I requested that this be updated by providing a specific error. You updated it months later by ONLY adding the case that I indicated was missing. I just checked it for a new case that I know should be in the system. It is not there. As such, you failed to actually update the dataset. This means that the data says it is up to date and is not. Please actually update the dataset in full after obtaining accurate data from the Law Department's Law Manager database.

No URL Submitted.

Response not sent yet.

Pending

2021-03-18T00:00:00.000

2026-10-02T00:00:00.000

7564

Data Question

Department of Health and Mental Hygiene (DOHMH)

Hello,

Question about DOHMH New York City Restaurant Inspection Results dataset, if a business is no longer in this dataset, can we assume it's closed? Or maybe their permit/renewal has not made it to the dataset yet?

Also, would it be possible to get a direct email I ask further questions specific to this data?

DOHMH New York City Restaurant Inspection Results

https://data.cityofnewyork.us/d/43nn-pn8j

Good Morning

Please review the dataset documentation which is available on the OpenData DOHMH New York City Restaurant Inspection Results dataset page:

https://data.cityofnewyork.us/api/views/43nn-pn8j/files/3016a624-55c0-4bd0-bfb4-95c6b9ea6ba4?download=true&filename=About_NYC_Restaurant_Inspection_Data_on_NYC_OpenData_092418.docx

https://data.cityofnewyork.us/api/views/43nn-pn8j/files/ec33d2c8-81f5-499a-a238-0213a38239cd?download=true&filename=RestaurantInspectionDataDictionary_09242018.xlsx

Closed

2021-03-16T00:00:00.000

2026-10-02T00:00:00.000

7562

Data Question

Agency not assigned yet.

I am trying to retrieve the dataset in CSV format. When I obtain the API link https://data.cityofnewyork.us/resource/64uk-42ks.csv it only retrieves 1001 records and not the full 800K + I am using CURL to FTP the data directly to my AIX server. Is there a setting that I can use to get the full dataset this way or is it a general restriction in using Opendata?

No URL Submitted.

Response not sent yet.

Pending

2021-03-16T00:00:00.000

2026-10-02T00:00:00.000

7558

Data Question

Agency not assigned yet.

Hi! I'm a graduate student working with the 2014-2015, through 2017-2018 school-year student, parent, and teacher school surveys. I was wondering when the surveys are administered? I found an FAQ link from 2019 saying the survey was administered from Feburary 11 - April 3rd. Is this consistent from year to year? If not, when were the surveys administered for those specific years? Is there data available for administration dates by school/DBN. Let me know, thank you!

No URL Submitted.

The time-frame is consistent year over year city-wide

Closed

2021-03-15T00:00:00.000

2026-10-02T00:00:00.000

7555

Data Question

Agency not assigned yet.

Two questions:
1) If all of the borough presidents are required to provide this information, why does this dataset only contain information for Manhattan addresses?
2) Where can I get this same information for the other four boroughs?

No URL Submitted.

Response not sent yet.

Pending

2021-03-14T00:00:00.000

2026-10-02T00:00:00.000

7553

Reported Error

Agency not assigned yet.

Having a huge problem logging on and need to apply for apt before deadline. Plzzz Help

No URL Submitted.

This doesn't seem like a issue with open data. We suggest that you contact technical support for the Housing Connect lottery system. You can send an email to this address: NYChousingconnect@hpd.nyc.gov or call this number: 212-863-7990. If you leave a message either one of these ways, someone from Housing Connect assistance will get back to you. Hope this helps!

Closed

2021-03-13T00:00:00.000

2026-10-02T00:00:00.000

7551

Data Question

Agency not assigned yet.

To the NYC Open Data Team,

I am working with a professor at *** to replice methods from Burt et al. (2019). Following is the excerpt regarding peer school identifier process:

We also identified “peer” schools from the NYC Department of
Education’s (NYC DOE) School Quality Guides. Peer schools are identified
by NYC DOE based on a multi-level matching method that focuses on
demographic characteristics at the school and student level, including economic
need (student housing status, percent of children eligible for free
and reduced price lunch in a school), disability status, English Language
Learner category, as well as previous test scores. This methodology is outlined
at NYC DOE website (New York City Department of Education,
2017). By using the NYC DOE peer schools we could account for similarities
at the school level, reducing selection bias and Type II error; therefore,
we randomly selected two peer schools for each school implementing
NYSW (14 schools) in order to reduce sampling variability (Austin, 2010).
By using officially designated schools matched on demographic characteristics
as comparisons, we reduced the potential for selection bias in our study
sample.

I have attached a spreadsheet that includes the New York Sun Works program middle schools I am trying to identify peer/comparison schools for. I want to identify two peer schools per program school for the reasons included in the methods paragraph above. I cannot find the peer identified schools within the School Quality Reports.

My professor and I intend to make a formal data request once we have the peer/comparison schools identified.

Thank you,

*****, EdS
Doctoral Candidate, ***** Educational Leadership
Assistant Professor and Program Coordinator
Indoor Agriculture
*****
*****

No URL Submitted.

Peer schools do not exist, that was something our team did over 5 years ago. We have something called peer "comparison groups", where we match a student to their 50 peers citywide and that is displayed in our reports (to learn more about comparison groups, go here[https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftools.nycenet.edu%2Fresources%2Fcomp-group.html&data=04%7C01%7CVColeman2%40schools.nyc.gov%7Cfe9762d2e8a348b7386b08d8eaca34b6%7C18492cb7ef45456185710c42e5f7ac07%7C0%7C0%7C637517501480122486%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=RP9GewuWuxcEh22u6L7F4%2FAM%2F2fC54MzsjvjXWRoY70%3D&reserved=0 ]). For the last school year SY 2019-20, we did not show these comparisons as we want users to use this data for informational purposes only. In the previous years, this data has been included in our files.
Thank you,
- NYC Open Data Team

Closed

2021-03-11T00:00:00.000

2026-10-02T00:00:00.000

7544

Reported Error

Agency not assigned yet.

Upon clicking on the desired dataset, the window does not open at all, therefore rendering an access impossible.

No URL Submitted.

We aren't experiencing that issue on our end. If this problem is not solved by refreshing your page, there might be an internet connectivity issue or an issue with Socrata, the platform that powers NYC Open Data. You can follow this link to contact them and submit a request: https://support.socrata.com/hc/en-us. Hope this helps!

Closed

2021-03-09T00:00:00.000

2026-10-02T00:00:00.000

7538

Data Question

Office of Technology and Innovation (OTI)

Is it possible to calculate the area of the buildings? I'm interested in calculating the area of the building rooftops and incorporating the height data that is available in the "Buildings Footprints" file.... it seems from the name footprint, like it would be possible to calculate the area at the base of the buildings? Thanks for your help!

Building Footprints (Deprecated)

https://data.cityofnewyork.us/d/nqwf-w8eh

Response not sent yet.

Pending

2021-03-08T00:00:00.000

2026-10-02T00:00:00.000

7529

Data Question

Agency not assigned yet.

Hello,
I am trying to identify comparison or peer schools for research. I have seen reference to the process, but I cannot find the actual dataset for comparison schools. Could you please help me?
Thank you!
*****, Doctoral Candidate, Educational Leadership, *****

No URL Submitted.

I would need to know where you are seeing/have seen that particular reference so can have a idea of who to contact.
I would suggest however, using tis link to make a request for the data:
Doing Research in New York City Public Schools (nyced.org)

Closed

2021-03-05T00:00:00.000

2026-10-02T00:00:00.000

7527

Data Question

New York City Police Department (NYPD)

My name is ***** and I am an intern at a company that gauges road risk. I was looking for any kind of legal direction pertaining to the NYC crash dataset. I was wondering if the dataset was “open data.” I ask because we are looking to incorporate this crash data as a small feature in our road risk model and want to ensure that we have the legal right to use our analysis as we see fit. I would greatly appreciate it if I could get an indication if this data is open and we can use it for commercial purposes or not. The dataset in question is linked below: https://data.cityofnewyork.us/Public-Safety/Motor-Vehicle-Collisions-Crashes/h9gi-nx95

Motor Vehicle Collisions - Crashes

https://data.cityofnewyork.us/d/h9gi-nx95

Thank you for contacting the NYC Open Data Help Desk. You are welcome to use the dataset for the purposes you referenced.
The full NYC Open Data Terms of Use can be found at the following link: https://opendata.cityofnewyork.us/overview/#termsofuse

Closed

2021-03-05T00:00:00.000

2026-10-02T00:00:00.000

7526

Data Question

Agency not assigned yet.

Hello,

My name is *****, I am a student of ***** in ***** currently taking a Machine Learning course. I want to use the 2020 NYC Parking Violation Dataset to see if I can build a model to predict violation code/type based on other features/columns of the dataset. However, I'm a bit stumped on how to interpret the "Days Parking In Effect" column. I see that it's a string of 7 characters, presumably representing each day of the week, but I'm having trouble understanding what "Y" and "B" mean, and how this column relates to the "Hours In Effect" columns.

Thanks so much in advance for your help!!

No URL Submitted.

The “Days Parking in Effect” column contains data values “Y” and “B” that refer to when Parking Rules are in effect for each day of the week following the order of Sun/Mon/Tues/Weds/Thurs/Fri/Sat (for example YYYYYYB). The “Y” represents “Yes” and the “B” represents “Bypass”.

Closed

2021-03-04T00:00:00.000

2026-10-02T00:00:00.000

7525

Data Question

Agency not assigned yet.

Dear NYC Open Data,

Thank you for making the data open to the public! I have a question for the Stop, Question and Frisk Data. The data has x y coordinates. What is the projection used? I cannot find this in the related documentation (https://www1.nyc.gov/assets/nypd/downloads/zip/analysis_and_planning/stop-question-frisk/SQF-File-Documentation.zip) provided on the website.

Thank you,

*****

No URL Submitted.

Good Morning.
The coordinate system is:
NAD 1983 StatePlane New York Long Island FIPS 3104 Feet
https://epsg.io/102718

Closed

2021-03-04T00:00:00.000

2026-10-02T00:00:00.000

7516

Data Question

Agency not assigned yet.

we want to use this data set and would like to know the following:
1. how is it being kept up to date?
2. who is responsible for its oversight?
3. how stable will the data structure be?
I can be reached at scott@roadify.com or 646 734-8388. Thanks much, Scott Kolber/Roadify CEO

No URL Submitted.

Response not sent yet.

Pending

2021-03-01T00:00:00.000

2026-10-02T00:00:00.000

7515

Data Question

Agency not assigned yet.

Hello-
I'm *****, a data journalist with the ***** Graduate School of Journalism.
I hope you are well.

The "RACE" column of the dataset only has "Black", "Asian" and "UNKNOWN". Is this the correct information? I'd like to find out if there are White, Hispanic and American Indian inmate admissions.
Thank you.
Best,
*****

No URL Submitted.

This is an automated dataset on the NYC Open Data portal. The DOC is planning significant shifts/enhancements to both automated datasets and manual reports for CY2021, including providing further detail in the Admissions, Daily Custody, and Discharge files.

We have not yet implemented these changes, so in the interim, any data requests can be addressed through the FOIL process: https://www1.nyc.gov/site/doc/about/foil-request.page

I hope this helps.

Closed

2021-03-01T00:00:00.000

2026-10-02T00:00:00.000

7514

Data Question

Department of Health and Mental Hygiene (DOHMH)

What does Grade G mean?

For example,

camis ids have a Grade G entry
41436524
50043665
41436524

DOHMH New York City Restaurant Inspection Results

https://data.cityofnewyork.us/d/43nn-pn8j

Please submit the actual data link or name of dataset you are referring to.

Thank you,
- NYC Open Data Team

Closed

2021-03-01T00:00:00.000

2026-10-02T00:00:00.000

7513

Data Question

311

I am student from *****. I am looking into the noise complaint dataset. I found the noise complaints were classified into several categories, such as Noise-residential, Noise-Vehicle, Noise-Street/Sidewalk. But I didn’t find the definition or criteria for the classification.
If possible, could you tell me the definition or navigate me to the person who can help with this issue? Thanks in advance.

Best wishes,
*****

311 Service Requests from 2020 to Present

https://data.cityofnewyork.us/d/erm2-nwe9

Thanks for your interest in our data! We do not provide definitions for all our complaint terms. Noise generally has a pattern that it refers to Noise [created by/coming from]. Thus Noise-Residential refers to noise that comes from inside a residential building, Noise - Vehicle is noise coming from a vehicle, and Noise-Streets/Sidewalk is noise coming from the street or sidewalk.

Hope that is helpful.

Closed

2021-03-01T00:00:00.000

2026-10-02T00:00:00.000

7511

Data Question

Department of Finance (DOF)

Re Summary of Neighborhood Sales Citywide by Borough -- How do I get specific address and property information within data, e.g. getting addresses referenced in a line indicating there were 13 sales in the certain neighborhood? Or is the data at each url all the detail NYC provides?

DOF: Summary of Neighborhood Sales by Neighborhood Citywide by Borough

https://data.cityofnewyork.us/d/5ebm-myj7

The NYC Citywide Annualized Calendar Sales Update has the detailed sales information for all the boroughs.
https://data.cityofnewyork.us/City-Government/NYC-Citywide-Annualized-Calendar-Sales-Update/w2pb-icbu
There is also the NYC Citywide Rolling Calendar Sales which lists sales within the calendar year.
https://data.cityofnewyork.us/dataset/NYC-Citywide-Rolling-Calendar-Sales/usep-8jbt

Closed

2021-02-27T00:00:00.000

2026-10-02T00:00:00.000

7498

Reported Error

Department of Buildings (DOB)

The following columns appear to be showing Applicant information rather than Owner information:
Owner's Business Name
Owner's Street Name
City
State
Zip

I was comparing the data with a filter for Bin=1035404 to what's shown on the DOB Now Public Portal

DOB NOW: Build – Job Application Filings

https://data.cityofnewyork.us/d/w9ak-ipjd

Response not sent yet.

Pending

2021-02-23T00:00:00.000

2026-10-02T00:00:00.000

7492

Reported Error

Department of Buildings (DOB)

This dataset has not been updated since February 8th. It's supposed to be updated daily.

DOB NOW: Build – Job Application Filings

https://data.cityofnewyork.us/d/w9ak-ipjd

Yes. This data set is undergoing revision to include additional fields, and will be refreshed soon.

Thank you,
- NYC Open Data Team

Closed

2021-02-22T00:00:00.000

2026-10-02T00:00:00.000

7489

Data Question

Department of Sanitation (DSNY)

Hello,
There are entries for Borough: Queens, Community District 7A. 7A is obviously not a Community District. I'm assuming that the 7A data belongs to Queens 07. May you tell me what is going on? Here's a screenshot of what I'm talking about: https://i.imgur.com/VNFtt36.png

Will there be any efforts to combine the values for Queens 07 & Queens 7A?
Thank you,

DSNY Monthly Tonnage Data

https://data.cityofnewyork.us/d/ebb7-mvp5

Queens 7A is not a community board district but is still a part of Queens 7.

The Queens 7A designation is for DSNY administrative reasons because we have a Mechanical Broom Garage with some other vehicles, like RO-RO trucks, that are allocated to that garage for a variety of collection activities for different material types.

Closed

2021-02-20T00:00:00.000

2026-10-02T00:00:00.000

7487

Data Question

311

Hello,
First off, thanks for making this data available, it has really been beneficial to me.
Could you add the 311 complaint SR number to the dataset?
When I currently look up a record for more information, I have to search for the record using the map and calendar and then sift through the results. If the SR number was in the dataset, it would make this process so much easier.
Thanks in advance, I look forward to hearing from you.

311 Service Requests from 2020 to Present

https://data.cityofnewyork.us/d/erm2-nwe9

Thank you for your interest in our data! 311 Service Requests numbers are not available in our Open Data set because some Service Requests contain information specific to the customer who submitted the request. We are looking to streamline our data in such a way that we may be able to share the actual Service Request number in Open Data in the future.

Closed

2021-02-20T00:00:00.000

2026-10-02T00:00:00.000

7484

Reported Error

Agency not assigned yet.

I noticed that the city lists three apartments at ***** (Brooklyn) however there are in fact four apartments at this address.

No URL Submitted.

HPD’s records indicate that this building is a 3 family building: the basement and first story are one apartment, the second and third story contain one apartment each for a total of three apartments. If you have any NYC Dept. of Buildings (DOB) documentation that would supersede this information, please submit that documentation and we will evaluate the contents. If you require additional information about this property, please submit a FOIL request at https://www1.nyc.gov/site/hpd/contact/foil.page.

Closed

2021-02-18T00:00:00.000

2026-10-02T00:00:00.000

7483

Reported Error

Department of Buildings (DOB)

the DOB NOW: Build – Job Application Filings
Housing & Development
data has not been updated in 10 days. Will the data be updated soon?

DOB NOW: Build – Job Application Filings

https://data.cityofnewyork.us/d/w9ak-ipjd

This data set is undergoing maintenance and DOITT is working to restore it.

Thank you,
- NYC Open Data Team

Closed

2021-02-18T00:00:00.000

2026-10-02T00:00:00.000

7482

Data Question

Agency not assigned yet.

I would like to confirm the query to select the current, designated landmarks list.
In your Data Dictionary you list:
To determine the present status of any item on the Landmark List, “MOST_CURRENT”, “STATUS” and “LAST_ACTION_ON_LP” must be looked at collectively. DESIGNATED records will appear as “MOST_CURRENT”=1, “STATUS”=DESIGNATED and “LAST_ACTION_ON_LP”=DESIGNATED.

Is the above still accurate?

We noticed a new value in the 'last action' field - DESIGNATED (AMENDMENT/MODIFICATION ACCEPTED). I need to confirm with LPC whether this should be included in the above query. I believe it should since they are technically designated.

The new query would be:
DESIGNATED records will appear as “MOST_CURRENT”=1, “STATUS”=DESIGNATED and “LAST_ACTION_ON_LP”=DESIGNATED or DESIGNATED (AMENDMENT/MODIFICATION ACCEPTED).

Also noticed that 'Most Current' = 1 for all records. If that is accurate, why is that needed in above query? Is there a scenario where it would not equal 1?

No URL Submitted.

Response not sent yet.

Pending

2021-02-17T00:00:00.000

2026-10-02T00:00:00.000

7478

Data Question

Agency not assigned yet.

Looking for a welder, ***** - DOB # 9479. I know he has submitted his renewal and he had an address change. Need to know if his certification has been updated. Thanks

No URL Submitted.

Please contact the Department of Buildings' Licensing Unit at (212) 393-2259 with this inquiry.

Thank you,
- NYC Open Data Team

Closed

2021-02-16T00:00:00.000

2026-10-02T00:00:00.000

7477

Reported Error

Agency not assigned yet.

there's no new data showing for any business started in 2021.the website says it was updated February 8th however, it's not showing any data

No URL Submitted.

This data is not managed by New York City Open Data, it is managed by New York State Open Data. You should be able to ask any questions about the data by clicking the "Contact Dataset Owner" button on the dataset's primer page (https://data.ny.gov/Economic-Development/Active-Co....).

Hope this helps!

Closed

2021-02-16T00:00:00.000

2026-10-02T00:00:00.000

7476

Data Question

Agency not assigned yet.

Page says data updated November 10, 2020. What was the data source for the update? 2020 Census? American Community Survey? Other? The actual download is below:
https://data.cityofnewyork.us/api/views/ye4r-qpmp/files/tEoVjKnohrYC6mDmQyr45wUzaHO40L0w53p1ARKzLfI?filename=sf1_dp_cncld_demoprofile.xlsx

No URL Submitted.

The actual download link you included is for a table NYC Department of City Planning (DCP) provides, which compares 2000 and 2010 census demographics at an approximate of NYC City Council districts.

The November 10, 2020 date comes from a site called Data.gov which DCP does not maintain. I would like to point out that the date referenced on that site is for "metadata" created and updated. This does not refer to the actual date of the data.

Thank you,
- DCP Open Data Team

Closed

2021-02-14T00:00:00.000

2026-10-02T00:00:00.000

7475

Data Question

Agency not assigned yet.

Why are there no schools with fewer than 6 students who have 2+ suspensions? That seems very odd to me.

No URL Submitted.

Hi *****,

In instances where the count of students might be so low as to be able to permit someone to identify a student, we redact those numbers,

Thank you,
- NYC Open Data Team

Closed

2021-02-14T00:00:00.000

2026-10-02T00:00:00.000

7467

Data Question

New York City Police Department (NYPD)

Hi,

My name is ***** and I am an intern at a company that gauges road risk. I was looking for any kind of legal direction pertaining to the PennDOT crash dataset. I was wondering if the dataset was “open data.” I ask because we are looking to incorporate this crash data as a small feature in our road risk model and want to ensure that we have the legal right to use our analysis as we see fit. I would greatly appreciate it if I could get an indication if this data is open and we can use it for commercial purposes or not.

We are not reselling the data - it simply informs our road risk models.

Thank you

Motor Vehicle Collisions - Crashes

https://data.cityofnewyork.us/d/h9gi-nx95

Thank you for contacting NYC Open Data Help Desk. Please be advised that PennDOT data is not maintained by the NYC agencies. You are encouraged to directly contact PennDOT at https://www.penndot.gov/ContactUs/Pages/default.aspx

Thank you,
- NYC Open Data Team

Pending

2021-02-10T00:00:00.000

2026-10-02T00:00:00.000

7463

Data Question

Agency not assigned yet.

Hello,
Hope you are well.
Here is my question about the dataset: does the "amount" column represent total amount between the start date and end date? Or is it the amount of the fiscal year?

Thank you for your support.

No URL Submitted.

The amount column means the total contract budget over the contract's full period (from the start – end date) for all sites.

Also, for future reference, please see the data dictionary in the "Attachments" section of any of our datasets' primer page. These documents have descriptions for all the columns in the dataset, amongst other relevant information. For example, this dataset's Data Dictionary is titled "Verified_Locations_for_NYC_data_dictionary_January_2021.xlsx."

Closed

2021-02-09T00:00:00.000

2026-10-02T00:00:00.000