From a 500-row sample across 32 columns.
binapt_suitecommunity_board+12bincommunity_boardcouncil_district+16record_idbusiness_categorybusiness_unique_id+1binMappable — coordinate pair `latitude` / `longitude`.
Open on the map →| record_id | intake_date | intake_channel | _311_sr_number | business_category | complaint_code | business_unique_id | business_name | result_date | result | address_type | building_nbr |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 000001-2026-CMPL | 2026-01-01T00:00:00.000 | 311 | 311-25776008 | Garage & Parking Lot | Non-Delivery of Goods - N01 | BA-1758638-2026 | PLATINUM PLUS GARAGE | 2026-02-01T00:00:00.000 | Requested Information Not Provided | Complete Address |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
record_id | text | An identification number assigned to the complaint record for tracking purposes. | 0% | 006935-2026-CMPL024350-2023-CMPL13532-2023-CMPL |
intake_date | datetime | The method by which the complaint was submitted. | 0% | 2023-07-24T00:00:00.0002025-06-11T00:00:00.0002024-07-16T00:00:00.000 |
intake_channel | categorical | The method by which the complaint was submitted. | 0% | 311OnlineEmail/Faxof 8 |
_311_sr_number | text | An identification number assigned by NYC311 for complaints they receive which are referred to DCWP for resolution. | 30% |
GET /api/datasets/nre2-6m2s GET /api/datasets/nre2-6m2s/quality GET /api/datasets/nre2-6m2s/related GET /api/columns?dataset=nre2-6m2s
apt_suitebusiness_categorybincommunity_boardcouncil_district+5bincommunity_boardcouncil_district+4citybusiness_namestaterecord_idbusiness_unique_idbusiness_name| 350 |
| 000002-2026-CMPL | 2026-01-01T00:00:00.000 | 311 | 311-25776542 | Tow Truck Company | Lost/Stolen/Damaged Property | BA-1758639-2026 | Legacy Towing | 2026-02-01T00:00:00.000 | Requested Information Not Provided | Complete Address | 13101 |
| 000003-2026-CMPL | 2026-01-01T00:00:00.000 | 311 | 311-25776844 | Specialized Vending License - MFV | Advertising/Misleading - A02 | BA-1758640-2026 | The flavor of the new yorm | 2026-01-02T00:00:00.000 | Insufficient Info Received | Complete Address | 134 |
| 000004-2026-CMPL | 2026-01-01T00:00:00.000 | Online | — | Garage & Parking Lot | Other - Z01 | BA-1287019-2022 | LAUREATE GARAGE, LLC | 2026-02-15T00:00:00.000 | Requested Information Not Provided | Complete Address | 2148 |
| 000005-2026-CMPL | 2026-01-01T00:00:00.000 | Online | — | Garage & Parking Lot | Non-Delivery of Service - N02 | BA-1758642-2026 | LAUREATE GARAGE LLC | 2026-02-15T00:00:00.000 | Requested Information Not Provided | Complete Address | — |
| 000006-2026-CMPL | 2026-01-01T00:00:00.000 | 311 | 311-25778242 | Other | Other - Z01 | BA-1758644-2026 | Tiba Poultry | 2026-01-02T00:00:00.000 | Referred | Complete Address | 905 |
| 000007-2026-CMPL | 2026-01-01T00:00:00.000 | 311 | 311-25778527 | Pedicab Business | Overcharge | BA-1758645-2026 | Fabass LLC | 2026-01-05T00:00:00.000 | Insufficient Info Received | Cross Street (Intersection) | — |
| 000008-2026-CMPL | 2026-01-01T00:00:00.000 | 311 | 311-25778947 | Specialized Vending License - MFV | Price Not Posted | BA-1758646-2026 | Hot Dog Stand | 2026-02-01T00:00:00.000 | Requested Information Not Provided | Complete Address | 1 |
| 000009-2026-CMPL | 2026-01-01T00:00:00.000 | 311 | 311-25778929 | Pedicab Business | Price Not Posted | BA-1758647-2026 | B Quick Fix | 2026-02-01T00:00:00.000 | Requested Information Not Provided | Complete Address | 4470 |
| 000010-2026-CMPL | 2026-01-01T00:00:00.000 | Online | — | Other | Other - Z01 | BA-1758648-2026 | PureGym - Formerly Blink Fitness | 2026-01-16T00:00:00.000 | Insufficient Info Received | Complete Address | 301 |
Showing 12 of 28 columns. All of them are listed below.
0311-19304092311-19314560 |
business_category | text | The business activity or business category that is the subject of the complaint. | 2% | OtherMisc Non-Food RetailTow Truck Company |
complaint_code | text | Indicates the type of business practice that is the subject of the complaint. | 14% | Advertising/Misleading -…OverchargeUnlicensed |
business_unique_id | text | An identification number assigned by DCWP to track unique businesses across its systems. | 3% | BA-1103959-2022BA-1669484-2023BA-1120307-2022 |
business_name | text | The legal business name as filed with the New York State Secretary of State or County Clerk or, if an individual, the person’s first name and last name. | 3% | N/AMEMORIAL SLOAN KETTERING…n/a |
result_date | datetime | The date the complaint was resolved. | 0% | 2023-09-25T00:00:00.0002025-07-16T00:00:00.0002024-01-11T00:00:00.000 |
result | text | The type of resolution for the complaint. | 0% | ReferredRequested Information No…Complaint Review Complet… |
referred_to | text | The external agency to which the complainant was referred. | 64% | OtherNYC Department of Sanita…- |
contract_cancelled_amount | float | The amount of consumer restitution awarded in the form of the reduction of a contract amount, that DCWP negotiated on behalf of the consumer. | 100% | 300053.6800000000000000055 |
refund_amount | integer | The amount of consumer restitution awarded in the form of a refund or reduction in fees that DCWP negotiated on behalf of the consumer. | 98% | 1000010050 |
address_type | categorical | The type of address where the business is located. | 5% | Complete AddressCross Street (Intersecti…Place (Landmark)of 5 |
building_nbr | text | The building number where the business is located. | 16% | 1323633 |
street1 | text | The name of the street where the business is located. | 5% | BROADWAY3RD AVE5TH AVE |
street2 | text | The name of the cross street where the business is located. | 96% | PLYMOUTH STREETNORTHERN BOULEVARDWATER STREET |
street3 | text | The name of the street where the business is located. | 100% | BROADWAYGUY R BREWER BOULEVARD8 AVENUE |
unit_type | text | The type of unit of the business' address. | 95% | APTSTEFL |
apt_suite | text | The unit number of the business' address. | 91% | 123 |
city | text | The city where the business is located. | 8% | BROOKLYNNEW YORKBRONX |
state | text | The state where the business is located. | 5% | NYNJCA |
postcode | text | The ZIP Code where the business is located. | 5% | 112011003610019 |
borough | categorical | The NYC Borough where the business is located. | 12% | ManhattanBrooklynQueensof 6 |
community_board | text | The NYC Community District where the business is located. | 14% | 105101104 |
council_district | text | The NYC City Council District where the business is located. | 14% | 030401 |
bin | text | The Building Identification Number where the business is located. | 20% | 300000020186421037174 |
bbl | text | The Borough-Block-Lot number where the business is located. | 20% | 203356010710131475023046850011 |
nta | text | The Neighborhood Tabulation Area where the business is located. | 17% | MN17MN13MN25 |
census_block_2010_ | text | The 2010 Census Block where the business is located. | 17% | 100010012000 |
census_tract_2010_ | text | The 2010 Census Tract where the business is located. | 14% | 21913 |
latitude | coordinate | The latitudinal coordinate where the business is located. | 13% | 40.8789138410909940.6539312654758840.584368247243226 |
longitude | coordinate | The longitudinal coordinate where the business is located. | 13% | -73.8737129159977-73.92124622027247-73.98290981403754 |