NYC Open Data Help Desk: Data Questions and Reported Errors

12404

Reported Error

The NYC Open Data Team

The 311 dataset appears to have no rows. When downloaded, filtered, or queried, the entire dataset itself appears to be missing. I am sure it is a syncing issue or something similar.

Thanks for the awesome work y'all do!

311 Service Requests from 2020 to Present

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

Thank you so much for reaching out about the 311 Service Request dataset. We are in the process of doing some improvements on this dataset, and unfortunately due to the size of the dataset and the large number of dependent views it has, the data is unavailable at this time. We are in the process of getting a temporary working version of the data published, and once that is available there will be a link to it on the dataset update page. 

Thank you again,
Claudia

Closed

2025-12-22T00:00:00.000

2026-10-02T00:00:00.000

12402

Data Question

New York City Police Department (NYPD)

Does this dataset include EVERY ticket issued by NYPD from January 1 - September 30, 2025? It says Moving Violation B. Are there any Moving Violation As?

Moving Violation B Summons (Year to Date)

https://data.cityofnewyork.us/d/57p3-pdcj

Response not sent yet.

Pending

2025-12-21T00:00:00.000

2026-10-02T00:00:00.000

12401

Reported Error

The NYC Open Data Team

After hours variances has not been updated since 2023 but there is public dashboard that has the data with fresh updates: https://www.nyc.gov/assets/buildings/html/active-after-hour-variance.html

Can this data set be turned back on and updated?

DOB After Hour Variance Permits

https://data.cityofnewyork.us/d/g76y-dcqj

Our apologies for the late reply here. Thank you for bringing this to our attention. This dataset has now been updated with the latest available information.

Closed

2025-12-18T00:00:00.000

2026-10-02T00:00:00.000

12397

Data Question

Department of Buildings (DOB)

Dear NYC Open Data Team,
 
Working with the DOB ECB Violations dataset (https://data.cityofnewyork.us/Housing-Development/DOB-ECB-Violations/6bgk-3dad), we found that current `INFRACTION_CODE1` values don’t align with the 2019 data dictionary (`DD_DOB_ECB_Violations_2019-07-10.xlsx`). Could you please share the **latest code mapping/data dictionary** and confirm the **update cadence**? If there is a DOB Open Data Coordinator, kindly advise.
 
**Examples of codes not present in the 2019 decode (from recent pulls):**
['B3K','B3R','B47','B43','B2T','B32','B6A','B48','B1H','B7A','B05','B5C', … 'B2C']
 
**Pattern observed in the 2019 decode:** codes typically start with **“B” followed by three digits** (e.g., below from the decode table):
B179, B279, B379, B2B3, B144, B244, B1B7, B2B4, B2F2, B1G5, B2G5, B1G4, B242, B127, B252, B237, B134, B234, B235, B307.
 
Please confirm whether the dataset moved to mixed alphanumeric families (e.g., ‘B3K’, ‘K1S’, ‘C3M’) and provide the current specification.
 
Thank you for your help.
 
Best regards,  

DOB ECB Violations

https://data.cityofnewyork.us/d/6bgk-3dad

Your inquiry is being reviewed and a subject matter expert will pursue the necessary correction(s) or update if warranted.
You may find the below nyc.gov resource useful in identifying the pre-2009 alpha-numeric-alpha structured infraction codes:
http://www1.nyc.gov/assets/buildings/excel/penalty_schedule_with_codes.xlsx

Closed

2025-12-16T00:00:00.000

2026-10-02T00:00:00.000

12396

Data Question

Department of Buildings (DOB)

I have a question about the DOB Violations and the DOB Safety Violations. Will all violations eventually be migrated to the DOB Safety Violations?

Use Case: I am teaching people how to access the violations for their properties. In order to make sure that they see all violations for their property, do they need to use both the DOB Violations and the DOB Safety Violations data? or will they eventually just need to use the DOB Safety Violations data?

DOB Safety Violations

https://data.cityofnewyork.us/d/855j-jady

Technically, an exhaustive view into DOB issued violations requires a reconciliation between the two data sets, though the vast bulk will continue to be issued through DOB NOW.

Closed

2025-12-16T00:00:00.000

2026-10-02T00:00:00.000

12395

Data Question

The NYC Open Data Team

https://opendata.cityofnewyork.us/311-service-requests-from-2010-to-present-updates/

While you are doing this, would it be possible for you guys to do a clean out of obviously wrong data? For example, lat and lon switched, dates that have the Excel error of showing 1900 for the date column and messes up response metrics, etc. I would love to help with this! I am a data engineer and have all the SQL queries already.

311 Service Requests from 2020 to Present

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

Thank you so much for those flags on the 311 Service Request dataset! We are planning more improvements to all of the 311 datasets after this initial update, so this isn’t our only opportunity to make changes. While we can’t include them in this current round, we will add your notes to the list of items we need to look at in the next phases of this work.

Thanks again,
Claudia  

Closed

2025-12-15T00:00:00.000

2026-10-02T00:00:00.000

12394

Reported Error

Department of Sanitation (DSNY)

Hello, I'm running into an issue with the Litter Basket Inventory Data. I want to look into litter basket inventory over time and therefore am attempting to export the archive data. Though a few have downloaded correctly (12/15/25, 09/05/25, 08/15/25, 04/10/24, 02/02/24, 12/12/23), most of the "export archive" records load indefinitely when I click on them. Is there any way that this could be fixed? Additionally, the metadata suggests that up until Sep 5, 2025 updates were made quarterly, would it be possible to know the dates when these updates were made?

Any assistance would be appreciated!

DSNY Litter Basket Inventory

https://data.cityofnewyork.us/d/8znf-7b2c

Response not sent yet.

Pending

2025-12-15T00:00:00.000

2026-10-02T00:00:00.000

12389

Data Question

Department of Health and Mental Hygiene (DOHMH)

The info says the data was last updated in 2025 but the dataset preview only displays data up to 2023. Downloading the dataset also only yields data to 2023. Can you please help? thanks.

Air Quality and Health Impacts

https://data.cityofnewyork.us/d/c3uy-2p5r

Thank you for your inquiry. Information on Open Data was updated in 2025 with the most available data, which is 2023.

Closed

2025-12-11T00:00:00.000

2026-10-02T00:00:00.000

12388

Data Question

Department of Finance (DOF)

The “Issue Date” field in this dataset is not a date, which means that it cannot be sorted by date in Socrata, and I cannot download a subset of data. Given how large the dataset is, it makes it nearly impossible to use.

Open Parking and Camera Violations

https://data.cityofnewyork.us/d/nc67-uf89

The value in the “Issue Date” field in the Open Parking and Camera Violations dataset is the actual value that appears on the summons from the issuing agency. For the most part the value will be an actual date, however, there are instances where the dates are transcribed incorrectly or contains something other than a date from the issuing agency. The Department of Finance cannot alter the value of the Issue Date that it receives from the issuing agency.

Closed

2025-12-11T00:00:00.000

2026-10-02T00:00:00.000

12387

Reported Error

The NYC Open Data Team

It appears that the doc_types are missing.

ACRIS - Document Control Codes

https://data.cityofnewyork.us/d/7isb-wh4c

Thank you for bringing this to our attention. This dataset has now been updated with the latest available information.

Closed

2025-12-10T00:00:00.000

2026-10-02T00:00:00.000

12386

Data Question

Department of Transportation (DOT)

Was hoping to clarify a few things about this dataset!
- the "locker_box_door" and "locker_box_size" fields: It appears that the size of the box is not static for a given locker_name+locker_box_door identifier. Does the box the number refers to change? Any other reason this would be true?
- I'm trying to identify how many boxes each locker_name has, which is surprisingly hard to back out of the reservations. Is this data available at the locker level? As an example, at the 'GoLocker-Fine Fare Supermarkets-LES' locker, we see multiple uses of boxes 1, 4, 7 and 9 (though they report different sizes at different times so I'm not sure if those are actually unique boxes) and a single use of 5. Not sure if I should interpret that as having 9 boxes, where 2, 3, 6 and 8 have never been used. 
- Is there any guidance on how to interpret duplicates? For example, at the 'GoLocker-Fine Fare Supermarkets-LES' locker again, there are two reservations made at '2025-10-23 14:10:00', everything is the same except pickup duration (00.21.22.11 and 00.21.22.28) and delivery duration (00.05.54.20 and 00.05.54.31). I assume it's just a duplicate but since I've seen a few and I'm not very familiar with this sort of pickup system, I just wanted to check that there's not something I'm misunderstanding.

LockerNYC Reservations

https://data.cityofnewyork.us/d/inb9-u6nt

Thank you for catching this data error. GoLocker, the vendor for the program has since fixed the errors but changes were made to the datasets. The locker size information are now in the LockerNYC Location- Pilot Program dataset. The locker size information has been removed from LockerNYC Reservations.

Closed

2025-12-09T00:00:00.000

2026-10-02T00:00:00.000

12381

Reported Error

Department of Transportation (DOT)

This dataset is updeted on September 20th, 2025, and today is December 5th, 2025. I'm wondering why you have the data on December 11, 2025. Is it a prediction or an error?

Automated Traffic Volume Counts

https://data.cityofnewyork.us/d/7ym2-wayt

Thank you for your request and reporting this data error. The Automated Traffic Counts (ATR) data (Request ID- 38291 SegmentID- 30283) was indeed an error, the count dates are between December 3, 2024 and December 11, 2024. We are working with the vendor that collected this data to update and correct this error. We apologize for the inconvenience.

Closed

2025-12-05T00:00:00.000

2026-10-02T00:00:00.000

12379

Reported Error

Department of Sanitation (DSNY)

For the months to 2002/07 to 2003/06, DSNY has listed MGP tonnages, and then reproduced those exact MGP tonnages again as "other organics" tonnages. I assume this is an error?

DSNY Monthly Tonnage Data

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

Response not sent yet.

Pending

2025-12-04T00:00:00.000

2026-10-02T00:00:00.000

12378

Data Question

The NYC Open Data Team

Hi - ’m writing because Googling my name now reveals my address. This only started appearing publicly recentlt. Earlier this year, I was the victim of a violent robbery and identity theft. Someone used details they found online about me to open loans, credit cards, register for college, and even apply for scholarships in my name. Having my location and other personal details so easily discoverable is genuinely frightening. Could you please remove or suppress my name and any identifying details from indexing on Google search results?

https://a836-pts-access.nyc.gov/care/datalets/datalet.aspx?mode=asmt_fin_2026&UseSearch=no&pin=3001861008&jur=65&taxyr=2022&LMparent=20

Thank you for reaching out to us. While we understand your concern, New York State and New York City’s laws require that some types of records, including records with personal information, be shared publicly. This includes details about things like:
- payroll records for government employees
- property records, including transaction and tax details
- business records, including license details

Because the NYC Open Data Law requires us to make these datasets available to anyone for any purpose, sometimes other people republish this information elsewhere.

You can learn more about these requirements by reading Article 6 of the NY State Public Officers Law and NYC Administrative Code 23-5.

Closed

2025-12-04T00:00:00.000

2026-10-02T00:00:00.000

12377

Data Question

Department of Youth and Community Development (DYCD)

How was the dataset created and updated? Who created the dataset? What technologies are involved or may be involved in this particular dataset? What is the organizational mandate? Budget? Staffing?

DYCD Program Sites

https://data.cityofnewyork.us/d/ebkm-iyma

This dataset is maintained by operations staff at DYCD in DYCD Connect, which is built on Microsoft CRM.
 
DYCD invests in a network of community-based organizations and programs to alleviate the effects of poverty and to provide opportunities for New Yorkers and communities to flourish. You can learn more in our section of the Mayor's Management Report: https://www.nyc.gov/assets/operations/downloads/pdf/mmr2025/dycd.pdf.

Closed

2025-12-03T00:00:00.000

2026-10-02T00:00:00.000

12374

Data Question

Office of the Comptroller (COMPTROLLER)

There is a column in this dataset called "Shares/Par Value." According to the notes provided for the dataset "in the case of stock and other financial instruments, this column sets forth the number of shares or units held." However, all of the cells in this column have a monetary value, so I just wanted to confirm that the numbers are in fact the number of shares held? Thank you.

Office of The Comptroller: Teachers Retirement System Holdings Data

https://data.cityofnewyork.us/d/5u2d-n46s

Response not sent yet.

Pending

2025-12-01T00:00:00.000

2026-10-02T00:00:00.000

12371

Data Question

Department of Youth and Community Development (DYCD)

- Who is the data creator(s) and was the original intent for collecting the data was

DYCD Program Sites

https://data.cityofnewyork.us/d/ebkm-iyma

DYCD Program Sites are set depending on the program type. For example, Beacon and Cornerstone sites are determined by DYCD, while Literacy sites are proposed by providers to provide services for neighborhoods determined by DYCD. DYCD strives to prioritize services in the neighborhoods where they are needed most.

This data helps DYCD to examine geographic coverage of its services and is used within the DiscoverDYCD portal (https://discoverdycd.dycdconnect.nyc/home) where prospective participants can explore programs they may want to apply for.

Closed

2025-12-01T00:00:00.000

2026-10-02T00:00:00.000

12367

Data Question

The NYC Open Data Team

Metadata says this is updated daily via automation, but hasn't been updated since Nov 21 - just letting you know in case the automation is broken. thanks!

Order to Repair/Vacate Orders

https://data.cityofnewyork.us/d/tb8q-a3ar

Thank you for bringing this to our attention. This dataset has now been updated with the latest available information.

Closed

2025-11-25T00:00:00.000

2026-10-02T00:00:00.000

12366

Reported Error

The NYC Open Data Team

It appears the dataset isn't fully public on Open Data, and redirects to "You must be logged in to access this page." Link found on the class size report page (https://infohub.nyced.org/reports/government-reports/class-size-reports)

Prelim Average Class Size School - K - 8TH

https://data.cityofnewyork.us/d/sgxc-mnpk

This dataset along with others were individual parts of a whole report that were consolidated into one. The information in this data can be found here: https://data.cityofnewyork.us/Education/Average-Class-Size-2017-2019-Preliminary-/cfuy-6eha/about_data.

Closed

2025-11-25T00:00:00.000

2026-10-02T00:00:00.000

12362

Data Question

The NYC Open Data Team

When I download the data as a CVS I retrieve more than 2300 records. But when I download as an API only the first 1000 are retrieved.
Is there a parameter that I need to set or reset?
Thank you

LinkNYC Kiosk Status

https://data.cityofnewyork.us/d/n6c5-95xh

I'm Aryanna from the NYC Open Data Team, nice to meet you! By default, the API returns a maximum of 1,000 records per request. To retrieve more than that, you can use the following techniques:
1. Increase the Limit: You can increase the number of records returned by using the $limit parameter. For example, to request 50,000 records:  https://data.cityofnewyork.us/resource/abcd-1234.json?$limit=50000
2. Paginate Using $offset: To request additional records, pair $limit with $offset to paginate through the data. This will allow you to pull the data in chunks:
a. First Page: ?$limit=50000&$offset=0 
b. Second Page: ?$limit=50000&$offset=50000 
3. Optimize Your Query: Before making large requests, it's helpful to filter your results using the $select, $where, and $order parameters. This reduces unnecessary records and improves query performance. 
For more information on query parameters and how to work with large datasets please consult the following articles: 
- The LIMIT Clause documentation (https://dev.socrata.com/docs/queries/limit.html)
- How to Query More Than 1000 Rows (https://support.socrata.com/hc/en-us/articles/202949268-How-to-query-more-than-1000-rows-of-a-dataset)

Closed

2025-11-25T00:00:00.000

2026-10-02T00:00:00.000

12361

Data Question

The NYC Open Data Team

Hi -- I am trying to download Attorney Registration Data and have two questions:
1. The oldest dataset available for download is February 22, 2023. However, the web page indicates that the archive was created April 12, 2023. Is it possible to get data going back further than 2023? And if so, how?
2. I would like data snapshots at 5 to 10 points in time. However, when I press the "export archive" button for any dataset older than a week or so, it takes many hours to load, and sometimes times out. Is there a better way to download the older datasets?

https://data.ny.gov/Transparency/NYS-Attorney-Registrations/eqw2-r5nb/about_data

The data you are referring to is New York State open data and does not fall within the scope of what we can assist with via New York City's Open Data Help Desk. Please redirect this inquiry to the NYS Open Data Team at opendata@its.ny.gov.

Closed

2025-11-24T00:00:00.000

2026-10-02T00:00:00.000

12359

Data Question

Department of Buildings (DOB)

I’m trying to perform two specific analyses using the DOB Job Application Filings dataset:
1. Filter the number of new-building job applications/permit filings for projects with exactly 99 units, by year, and
2. Segment and group new-building applications by proposed dwelling units.
A few questions as I work through this:
- Which date column should be used to determine the year in which a new-building job was actually filed? There are multiple date fields in the dataset, but none appear to cleanly represent the “filing date” for a new building, at least not in a way that aligns with how industry groups treat this metric.
- REBNY recently cited 21 filings for 99-unit projects in the last quarter (unclear if Q2 or Q3 2025). When I filter the DOB dataset, I’m unable to replicate or validate that figure. I’d like to understand the methodology and which date field they rely on so that my results are consistent and defensible.
My broader goal is simply to ensure that I’m interpreting the dataset correctly. I need to be able to:
• filter permit filings by year and unit count, and
• sum/count proposed dwelling units per year, broken into buckets (e.g., <100 units, 100–149 units, 150+ units).
I’m comfortable doing the analysis in Python or Excel—the challenge is getting confidence around which fields to use and how to filter the data correctly, especially when my results conflict with published research that supposedly uses the same dataset.
Any guidance or clarification on the proper methodology would be greatly appreciated.

DOB Job Application Filings

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

Your request refers to the DOB Job Applications data set, which is from what we consider the legacy system (BIS). This response pertains to that data set.

The Pre- Filing Date is the date when the application initiated their submission. Unfortunately, it's not possible for coordinators of the portal data or the agencies releasing the data to site the methodologies used by external entities that consume the data. You could approach REBNY, for example, to ask how the data was handled on their end to generate their counts.

Closed

2025-11-22T00:00:00.000

2026-10-02T00:00:00.000

12357

Data Question

New York City Fire Department (FDNY)

Why there are no records for December?

Bureau of Fire Investigations - Fire Causes

https://data.cityofnewyork.us/d/ii3r-svjz

The Bureau of Fire Investigations – Fire Causes dataset is updated once per year. The most recent update was published on September 26, and includes data through August 29, 2025.
Records for December will be included in the next annual update once the full year’s data is processed and released on the Open Data Portal.
 
If you have any additional questions, we’d be happy to assist.

Closed

2025-11-21T00:00:00.000

2026-10-02T00:00:00.000

12356

Data Question

Department of Buildings (DOB)

I have a question about the DOB Violations(https://data.cityofnewyork.us/Housing-Development/DOB-Violations/3h2n-5cm9/about_data) and the DOB Safety Violations(https://data.cityofnewyork.us/Housing-Development/DOB-Safety-Violations/855j-jady/about_data). Does the DOB Safety Violations endpoint include all the violations from DOB Violations plus the DON NOW violations?

My Use Case: I am using these endpoints to check for violations on specific properties. Would I be safe to only use the DOB Safety Violations endpoint? or should use both of them to ensure that all violations are represented?

DOB Violations, DOB Safety Violations

https://data.cityofnewyork.us/d/3h2n-5cm9, 855j-jady

The DOB Violations data set does include instances not within the DOB NOW Safety Violations data set. Once violation issuance is fully migrated to DOB NOW, the Open Data portal descriptions for each of the data sets will be updated to reflect such.

Closed

2025-11-20T00:00:00.000

2026-10-02T00:00:00.000

12355

Data Question

New York City Police Department (NYPD)

Within the 911 calls for service data, specifically, I am trying to learn more about the spot shotter data set (within the TYP_DESC attribute) – what is the range of the mics, how are calls triggered, and other questions.

NYPD Calls for Service (Year to Date)

https://data.cityofnewyork.us/d/n2zq-pubd

As a starting point for your research, the NYC Comptroller completed a report in 2024 which may be helpful in answering your questions. It can be found here:
Audit Report on the New York City Police Department’s Oversight of Its Agreement with ShotSpotter Inc. for the Gunshot Detection and Location System - Office of the New York City Comptroller Brad Lander

Closed

2025-11-20T00:00:00.000

2026-10-02T00:00:00.000

12353

Data Question

New York City Police Department (NYPD)

Sex crimes data (within the OFNS_DESC attribute) in the NYPD Arrests data set (2025) is only published to the precinct level with (lat,long) unlike many other data sets that are locations or corners/mid-block (point data). Trying to understand why the lower precision for data given that this is not about the victims.

NYPD Arrest Data (Year to Date)

https://data.cityofnewyork.us/d/uip8-fykc

In the case of sex crimes, many arrests are made at the victim addresses. In order to protect victim privacy and minimize the risk of repeat victimization, it was decided that these arrest locations should be anonymized to precinct.

Closed

2025-11-19T00:00:00.000

2026-10-02T00:00:00.000

12351

Reported Error

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

Agency start date does not reflect accurate data. I have last year's version and it does not match. You are using City start date as Agency start date. It is not the same.

Citywide Payroll Data (Fiscal Year)

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

the NYC Citywide Payroll Data dataset does not and has never included “City Start Date” as a column.

Closed

2025-11-19T00:00:00.000

2026-10-02T00:00:00.000

12350

Data Question

Department of Finance (DOF)

Hi, I'm trying to determine if the violations listed in this database are unpaid. (I'm looking at a specific plate with hundreds of violations and want to be able to say if they're outstanding.) Any advice? Thanks!

Open Parking and Camera Violations

https://data.cityofnewyork.us/d/nc67-uf89

Please refer to the “Amount Due” column in the dataset to determine if the violations are paid or unpaid.

Closed

2025-11-19T00:00:00.000

2026-10-02T00:00:00.000

12349

Data Question

New York City Police Department (NYPD)

Are victims de-deduplicated in the NYPD Shooting Incident dataset? For instance, when I use the dataset, I find 1,531 shooting incidents in 2020 based on there being 1,531 unique INCIDENT_KEYs. In 2020 (or OCCUR_DATE 1/1/2020 to 12/31/2020), there are 1,948 rows which I think means 1,948 unique shooting victims. Is that correct?

ARCHIVED_NYPD Shooting Incident Data (Historic)

https://data.cityofnewyork.us/d/833y-fsy8

Yes, the duplicate incident ids indicate multiple victims. The NYPD is planning on updating this data in 2026 to include separate tables for victims and suspects.

Closed

2025-11-19T00:00:00.000

2026-10-02T00:00:00.000

12348

Data Question

Department of Environmental Protection (DEP)

I am a student at ***** doing a project on water infrastructure and fire hydrants.
Do you have additional information on the NYC hydrants that you can share? I am specifically looking for manufacturer and installation year.

NYCDEP Citywide Hydrants

https://data.cityofnewyork.us/d/6pui-xhxz

Response not sent yet.

Pending

2025-11-19T00:00:00.000

2026-10-02T00:00:00.000

12347

Data Question

Department of Buildings (DOB)

I would like to discuss what is actually being represented here and how to filter the dataset. I am concerrned I am not correctly identifying permits filed for new buildings. Is there a way to have a 10 minute phone call to discuss the data?

DOB Job Application Filings

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

This data set you're referencing concerns job applications. The permit data can be found here in the DOB NOW: Build - Approved Permits set. If then you are still struggling you can submit an update to your inquiry indicating what specific issues you're running into.

Closed

2025-11-19T00:00:00.000

2026-10-02T00:00:00.000

12344

Data Question

Department of Education (DOE)

What does Demographic.Variable value 'Not Poverty' and 'Poverty' mean? What does Demographic.Category 'Poverty' mean? What were all of these based off of? This information is currently not available on the codebook and would be really helpful!

Attendance Results 2013-2019

https://data.cityofnewyork.us/d/mg8s-7r2b

Response not sent yet.

Pending

2025-11-18T00:00:00.000

2026-10-02T00:00:00.000

12341

Data Question

Department of Citywide Administrative Services (DCAS)

RequestID 20240124139 shows a ContractAmount of $857,240,030,004.00 which is a huge outlier compared to other values for the same VendorName. Is this accurate?

Recent Contract Awards

https://data.cityofnewyork.us/d/qyyg-4tf5

Response not sent yet.

Pending

2025-11-15T00:00:00.000

2026-10-02T00:00:00.000

12340

Data Question

New York City Fire Department (FDNY)

Questions about joining tables. I would like to join the following tables:
1. Can the datasets 'NYPD Calls for Service' and the 'EMS incident Dispatch Data' be joined? if so, what is the joining field/key?
2. Can the 'EMS incident Dispatch Data' and the 'NYPD use of Force' dataset be joined? if so, what is the joining field/key?
Thanks in advance.

NYPD Calls for Service (Year to Date), EMS Incident Dispatch Data, NYPD Use of Force Incidents

https://data.cityofnewyork.us/d/n2zq-pubd, 76xm-jjuj, f4tj-796d

These datasets cannot be cleanly joined because the versions published on NYC Open Data contain limited fields and no shared incident ID between NYPD and EMS.
 
1. NYPD Calls for Service ↔ EMS Incident Dispatch
- No direct join key. NYPD and FDNY use separate CAD systems, and the Open Data versions don’t include any matching incident numbers.
- PD isn’t involved in every EMS incident, so even an approximate join won’t capture all overlap.
- Only possible join is fuzzy (date/time + location), and even that will be inconsistent due to limited fields.
 
2. EMS Incident Dispatch ↔ NYPD Use of Force
- No common identifier in the Open Data versions.
- Use-of-force events may or may not involve EMS, and EMS data on Open Data does not include NYPD incident numbers.
- Again, only approximate joins using time + location, but with low reliability.
 
Not all PD incidents involve EMS and vice versa; and even when they do, similar information available in both tables on Open Data is not a guaranteed incident match

Closed

2025-11-15T00:00:00.000

2026-10-02T00:00:00.000

12338

Data Question

Department of Sanitation (DSNY)

I am requesting a change in the codes and categories used in the DSNY Monthly Tonnages dataset, a long-standing and widely used resource for understanding New York City’s waste generation and collection patterns.
In June 2025, there were revisions to this dataset to expand the range of collection types included in the Refuse, Paper, and MGP recycling categories. While broader reporting is welcome, the aggregation of Schools and Containerized/Special collections with Curbside collections into single lump-sum columns has reduced the dataset’s utility for both Open Data users and policymakers. Documentation of this problem is attached.
The proposed solution is straightforward: restore separate columns for Curbside, Schools, and Containerized/Special collections across all four material streams. This approach would:
- Align with DSNY’s existing internal reporting codes;
- Provide consistency across material categories; and
- Remain compatible with aggregated totals reported in other DSNY publications, including the Annual Report, Mayor’s Management Report, Zero Waste updates, and Solid Waste Management Plan documents.
- Preserve the agency’s goal to “to align with other DSNY published reports.”

Specifically, the curbside refuse should be code 01, Household Collection. School refuse should be code 81, School Trucks. And containerized other refuse should be all other codes. Curbside paper recycling should be code 31, school truck paper should be code 48, and all other codes should be containerized other paper. MGP tons should be code 33 for curbside, code 78 for school truck MGP, and all other MGP codes in containerized other. Organics codes and categories are fine as is and don't need changes.

Maintaining this level of detail is critical for accurate analysis, informed policymaking, and transparent public reporting. I appreciate NYC Open Data’s commitment to providing high-quality, actionable datasets, and believe the adjustments proposed here will enhance the value of DSNY Monthly Tonnages for all stakeholders.
Rationale:
1.     Under current aggregated reporting, calculating a capture rate for the curbside composting program, which is the nation’s largest and vastly outweighs schools or other small organics programs, is no longer possible because we can’t isolate curbside refuse tonnages in the denominator.  The same argument applies to curbside paper recycling and curbside MGP recycling capture rates.  
2.     Blending school tonnages with curbside and containerized tonnages prevents evaluation of school recycling and organics.  While I understand that not all schools are served only by school trucks for all streams, there is public value in reporting school truck collections, as evidenced by DSNY’s continuing reporting of school organics tonnages.
3.     The current method of reporting blends containerized collection data with school and curbside, making it impossible to track the progress of this distinct method of collection.

Thank you for your consideration. I look forward to your response and am happy to provide further clarification or examples if needed.
Respectfully submitted,
*****

DSNY Monthly Tonnage Data

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

Response not sent yet.

Pending

2025-11-14T00:00:00.000

2026-10-02T00:00:00.000

12332

Data Question

Agency not assigned yet.

Hi there,

My name is *** and I am a current senior at *** pursing a degree in applied data science. I'm writing a senior thesis on the impacts of public transit infrastructure expansions on neighborhood space use, looking specifically at the case of the Second Avenue Subway. As someone who grew up on the UES, this is very exciting to me! I'm currently working with the above dataset; however, am finding there to be gaps. My timeframe is looking at all commercial businesses in the neighborhood 2012-2022. This dataset seems to have some of the years, though not much in the late teens - 20s. I've been looking at some of the other datasets online, but finding seperate issues. Is there a good way for me to access all open businesses during this time period?

Let me know!

Thanks so much,
***

https://data.cityofnewyork.us/Business/Historical-Licenses/m4ph-grrm/about_data

The dataset you shared refers to licenses a narrow set of businesses (see https://www.nyc.gov/site/dca/businesses/licenses-apply.page) and likely won't be useful for this kind of analysis. You might want to look at https://data.cityofnewyork.us/City-Government/Storefronts-Reported-Vacant-or-Not/92iy-9c3n/ instead. Alternatively, you can reach out to the MTA (opendata@mtahq.org) Planning, or Transportation Departments to explore any studies they might have completed about the Second Avenue Subway.

Closed

2025-11-11T00:00:00.000

2026-10-02T00:00:00.000

12331

Data Question

Department of Parks and Recreation (PARKS)

Hello, I can't identify the location where the data was collected in this set (except for Pelham Bay because there is a manual helpfully linked). I'd like to receive the other Unit Locator Maps for the Entitation Open Data Set. Thank you!

Entitation Map

https://data.cityofnewyork.us/d/n23c-ym2g

Our apologies for the delay! The location for each entitation record can be found by extracting the first 4+ characters preceding the underscore (_) in either the UEID or UEID_BASE fields. You can then join them on the Parks Properties dataset to find the geographic location.

Closed

2025-11-11T00:00:00.000

2026-10-02T00:00:00.000

12327

Reported Error

Agency not assigned yet.

I feel like the page to check the DCAS Active lists are down quite often. And it probably just not that dataset. It appears that everything is down. Can't search for anything. And like I said, this happens WAY too often.

Civil Service List (Active)

https://data.cityofnewyork.us/d/vx8i-nprf

Response not sent yet.

Pending

2025-11-08T00:00:00.000

2026-10-02T00:00:00.000

12324

Reported Error

The NYC Open Data Team

The export always fails with the message that the export server has failed.

311 Service Requests from 2020 to Present

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

Response not sent yet.

Pending

2025-11-05T00:00:00.000

2026-10-02T00:00:00.000

12321

Data Question

The NYC Open Data Team

Hi, thank you for your great work on keeping these databases going. I'm interested in gathering data for a project on how often some of these data sets have been updated over the years. I know you make a last update field available, but I was wondering if there was a way to get more granular info on when updates were made to data sets over the last few years. Alternatively, if there is a version history on this metadata data set, I could likely get the info from there if you could point me to it. Thank you in advance!!!

Local Law 251 of 2017: Published Data Asset Inventory

https://data.cityofnewyork.us/d/5tqd-u88y

Thanks for reaching out. We have a few questions to clarify your request:
1. Can you please share some more context on your project?
2. You mentioned that you were interested in specific datasets, can you please share that list?
3. Can you please clarify what you're looking for beyond "when updates were made"? What data (content, format, etc.) would you ideally be looking for?

All the best,
Zachary and the Open Data Team

Pending

2025-11-04T00:00:00.000

2026-10-02T00:00:00.000

12319

Data Question

Department of Environmental Protection (DEP)

This dataset has not been updated in over a year (since October 2024), despite prior requests to update. It contains 2023 data, and we are now in late 2025. This dataset should be updated immediately, and the lag between end of year and following year's update should be reduced. If there are reasons for such a long lag, they need to be explained to the public. DEP needs to be more reponsive on this dataset, which is important from a policymaking and planning perspective for NYC solid waste management.

Dewatered Solids and Biosolids Allocations per Biosolids Management Practice Site

https://data.cityofnewyork.us/d/95kh-h6zc

The data is updated annually. Data is currently in the process of being updated for CY 2024 and as this is an entirely manual process, the data is expected to be submitted to OpenData next week. For data requests outside of the listed update cadence on the OpenData "about data" page, submit a FOIL request to agency counsel for additional consideration.  

Closed

2025-11-03T00:00:00.000

2026-10-02T00:00:00.000

12318

Data Question

Department of Housing Preservation and Development (HPD)

Hi,
I'm curious about the column of OrderNumber, to my understanding, it is a reference to a description of the violation condition which cites a specific section of the law which is in violation, according to the user guide. I'm working to analyze this dataset, and the section of the user guide that mentions "OrderNumber Groupings" and some examples:
"Here are some examples of groups of order numbers that are often queried together:
●      Lead-based paint hazards: “616”, “617”
●      Heat violations: “666”, “664”, “966”, “964”
●      Hot water violations: “670”, “970”
●      Mold violations: “550”
"
I'm wondering if there is a longer, comprehensive list of order number groupings such as the one provided above. It would be helpful to know all the violations pertaining to, say, electrical issues, pests, etc. Is there is a list that categorizes all the order numbers?

Thank you very much.

Housing Maintenance Code Violations

https://data.cityofnewyork.us/d/wvxf-dwi5

Thank you for your inquiry. Please see the attached glossary for the order number list.

Please let us know if you have any other questions. 

Closed

2025-11-03T00:00:00.000

2026-10-02T00:00:00.000

12317

Data Question

New York City Fire Department (FDNY)

There are some parts of the data dictionary that are not clear:
- How do I interpret INITIAL_SEVERITY_LEVEL_CODE and  FINAL_SEVERITY_LEVEL_CODE?
- The description for the incident disposition codes are not clear to me. For example I am unsure what 90 (unfounded) means or 95 (triaged at scene no transport). I am also unsure about the difference between 87 (cancelled) and CANCEL (cancelled). I have a few more uncertainties, but I was wondering if there is a way I can get a more detailed description for all incident disposition codes?

Thank you in advance!

EMS Incident Dispatch Data

https://data.cityofnewyork.us/d/76xm-jjuj

1. INITIAL_SEVERITY_LEVEL_CODE & FINAL_SEVERITY_LEVEL_CODE
- Initial severity: This indicates the severity of the incident at the time it is first assigned, based on information provided by the caller (i.e., the first severity assigned to the incident).
- Final severity: This reflects the severity determined after the response and assessment by EMS personnel, likely when the incident is closed.
- Severity levels are generally ranked from 1 (most severe) to 8 (least severe), with 1–3 being life-threatening and 4–8 being non-life-threatening.
- Differences between initial and final severity may occur for a variety of reasons, such as additional phone calls or assessments conducted on scene.
2. Incident Disposition Codes
Disposition codes reflect the outcome or resolution of the incident. Examples include:
- 90 (Unfounded): No actionable incident was found after investigation.
- 95 (Triaged at scene, no transport): EMS evaluated the patient at the scene, but transport was not required.
- 87 (Cancelled) / “CANCEL”: The incident was cancelled before EMS arrival or transport. Both numeric and text codes typically indicate the same outcome, there is NO differences between the two.

Closed

2025-11-03T00:00:00.000

2026-10-02T00:00:00.000

12315

Reported Error

Department of Health and Mental Hygiene (DOHMH)

I just submitted this through the NYC website feedback form, but also sharing here since it's relevant both places:


There seem to be multiple pages/sites around the Community Health Survey data. Not only do they have a lot of overlap, but they don't consistently reference each other, and cover different years.

- https://www.nyc.gov/site/doh/data/data-sets/community-health-survey-public-use-data.page - 2002-2020
- https://a816-dohbesp.nyc.gov/IndicatorPublic/data-explorer/health-care/ - 2012-2022
- https://a816-health.nyc.gov/hdi/epiquery/visualizations?PageType=ps&PopulationSource=CHSl - 2013-2018
- https://data.cityofnewyork.us/Health/New-York-City-Community-Health-Survey/csut-3wpr/about_data - 2010-2020

Maybe there's a good reason for that, but as an outsider, that's very confusing. Some consolidation would definitely help.

Happy to talk about this more if you like. Thanks!

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

Thank you for your feedback. We will take it into consideration for future updates to the Open Data portal and other DOHMH pages for the Community Health Survey.

Closed

2025-11-01T00:00:00.000

2026-10-02T00:00:00.000

12314

Reported Error

Office of Technology and Innovation (OTI)

Missing data from the past few months. The dataset metadata says it is updated daily and was last updated Oct. 30th, but the last entry is from July 2025. I know of a specific .nyc domain name that was registered in late August 2025 and that is not reflected in this dataset.

.nyc Domain Registrations

https://data.cityofnewyork.us/d/9cw8-7heb

Response not sent yet.

Pending

2025-10-31T00:00:00.000

2026-10-02T00:00:00.000

12313

Data Question

Deputy Mayor for Operations (DMOPS)

Could you please share how your team measures or calculates the number of public restrooms? Any information about your methodology or data sources would be greatly appreciated. 
Thank you for time and assistance.

Public Restrooms (Operational)

https://data.cityofnewyork.us/d/vzrx-zg6z

Response not sent yet.

Pending

2025-10-30T00:00:00.000

2026-10-02T00:00:00.000

12311

Data Question

Department of Housing Preservation and Development (HPD)

Are the violations listed in chronological order - that is the oldest first and the latest or newest on the bottom of the list? Is there a way to see what the complaint is? I am looking to rent and have some concerns Thank you

Housing Maintenance Code Violations

https://data.cityofnewyork.us/d/wvxf-dwi5

Thank you for reaching out. The Housing Maintenance Code Violations dataset is not in any particular order, but you can sort the dataset by clicking the field name under the data view

Currently, the users are not able to connect the violations dataset and the complaints dataset. If you are interested in looking for an overview of a property, HPD Online is a great resource for that use.
 
Please let us know if you have any additional questions.

Closed

2025-10-30T00:00:00.000

2026-10-02T00:00:00.000

12310

Data Question

Department of Buildings (DOB)

When will this dataset be updated?

DOB Sign Application Filings

https://data.cityofnewyork.us/d/nyis-y4yr

Response not sent yet.

Pending

2025-10-29T00:00:00.000

2026-10-02T00:00:00.000

12309

Reported Error

Board of Standards and Appeals (BSA)

This bbl field has a bug and is incorrect 80% of the time. You are concatenating wrong. Please correct. It's throwing tons of errors in our software. https://data.cityofnewyork.us/City-Government/Board-of-Standards-and-Appeals-BSA-Applications-St/yvxd-uipr/about_data

Example calendars
37-15-A
112-99-A

❌ bbl (bad data)
1008280056
1008280056

boro|block|lot
4 15485 7
4 12920 95

✅ correct bbl concatenation
4154850007
4129200095

Board of Standards and Appeals (BSA) Applications Status

https://data.cityofnewyork.us/d/yvxd-uipr

Response not sent yet.

Pending

2025-10-29T00:00:00.000

2026-10-02T00:00:00.000

12308

Reported Error

School Construction Authority (SCA)

It seems that there are more recent estimates available (eg https://dnnhh5cc1.blob.core.windows.net/portals/0/Capital_Plan/Demographic_projection_Reports/Volume%201-2025.pdf?sv=2017-04-17&sr=b&si=DNNFileManagerPolicy&sig=fAUJFwKYDbkX04uAirzXF8hWDyOn41rWuADj9vgBNkA%3D).

Could we get the data updated to the most recent projections? Thank you!

Demographic Projection Report - Enrollment Projections - New York City Public Schools prepared by Statistical Forecasting

https://data.cityofnewyork.us/d/xzy8-qqgf

Response not sent yet.

Pending

2025-10-29T00:00:00.000

2026-10-02T00:00:00.000