From a 500-row sample across 42 columns.
bbllatitudecensus_tract+7bbllatitudecensus_tract+8vehicle_makevehicle_yearaccount_name+3bbllatitudebinHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| complaint_inquiry_number | date_complaint_inquiry | industry_type | source_of_complaint_inquiry | complaint_inquiry_disposition | complaint_inquiry_status | total_response_time | complaint_or_inquiry | nature_of_complaint_inquiry | complaint_inquiry_street | complaint_inquiry_city | complaint_inquiry_state |
|---|---|---|---|---|---|---|---|---|---|---|---|
| COMP-191399 | 2014-12-06T00:00:00.000 | Trade Waste | PHONE - 6300 | Unsubstantiated | Closed | 4.0 | Complaint | Quality of Life-Noise - Trade Waste | 11 Madison Avenue |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
complaint_inquiry_number | text | — | 0% | 2009-006432007-000042010-00417 |
license_type | categorical | — | 86% | Trade WasteTrade Waste;Transfer Sta…Transfer Stationof 5 |
account_name | text | — | 69% | ACTION CARTING ENVIRONME…WASTE CONNECTIONS OF NEW…ROYAL WASTE SERVICES INC… |
bic_number | text | — | 32% | TWC-NaN |
GET /api/datasets/p2d7-vcsb GET /api/datasets/p2d7-vcsb/quality GET /api/datasets/p2d7-vcsb/related GET /api/columns?dataset=p2d7-vcsb
bbllatitudebin+2bbllatitudebin+4bbllatitudebin+3| New York |
| NY |
| 2008-00037 | — | Trade Waste | 311/PHONE - 9278 | Resolved | Closed | — | Inquiry | Information - All | — | — | NY |
| INQ-192265 | 2015-08-03T00:00:00.000 | Trade Waste | PHONE - 6300 | Resolved | Closed | 2.0 | Inquiry | Licensing - All | — | — | — |
| COMP-192622 | 2015-12-01T00:00:00.000 | Trade Waste | PHONE - 6300 | Resolved | Closed | 2.0 | Complaint | Containers-Theft - Trade Waste | — | — | — |
| 2012-00872 | — | Trade Waste | 311/PHONE - 9278 | Resolved | Closed | — | Inquiry | Information - All | — | — | — |
| 2009-02262 | — | Trade Waste | PHONE - 6300 | Referred to Another Agency | Closed | — | Inquiry | Information - All | — | — | — |
| 2013-00869 | — | Trade Waste | PHONE - 6300 | Resolved | Closed | — | Inquiry | Misinformation - All | — | — | — |
| 2012-01412 | — | Trade Waste | SELF-INITIATED | — | — | — | Complaint | Hurricane Cleanup | 112-32 Rockaway Beach Blvd. | Queens | NY |
| 2009-02344 | — | Trade Waste | FAX | Resolved | Closed | — | Complaint | FOIL - All | — | — | — |
| 2010-00998 | — | Trade Waste | Resolved | Closed | — | Complaint | Unlicensed Carter - Trade Waste | 2339 Enright Road | nyc | NY |
Showing 12 of 25 columns. All of them are listed below.
TWC-0BIC-1181date_complaint_inquiry | datetime | — | 62% | 2014-07-21T00:00:00.0002015-07-07T00:00:00.0002015-06-10T00:00:00.000 |
industry_type | text | — | 0% | Trade Wasteof 1 |
account_status | categorical | — | 83% | ActiveInactiveSoldof 6 |
source_of_complaint_inquiry | categorical | — | 0% | 311/PHONE - 9278PHONE - 6300WEB-MAILof 18 |
complaint_inquiry_disposition | text | — | 4% | ResolvedReferred to Another Agen…Unsubstantiated |
complaint_inquiry_status | categorical | — | 1% | ClosedOpenViolationof 3 |
total_response_time | coordinate | — | 62% | 0.01.02.0 |
complaint_or_inquiry | categorical | — | 0% | InquiryComplaintof 2 |
nature_of_complaint_inquiry | text | — | 2% | Information - AllOther - AllUnlicensed Carter - Trad… |
complaint_inquiry_street | text | — | 63% | UNKNOWNVarious70-20 Austin Street |
complaint_inquiry_city | text | — | 67% | nycBrooklynNew York |
complaint_inquiry_state | text | — | 49% | NYnyNJ |
complaint_inquiry_zip | text | — | 83% | 112351110110011 |
complaint_inquiry_borough | categorical | — | 68% | QueensBrooklynManhattanof 8 |
account_focus_of_complaint | text | — | 25% | N/AACTION CARTING ENVIRONME…ROYAL WASTE SERVICES INC… |
account_address | text | — | 65% | 300 FRANK W. BURR BLVD, …451 FRELINGHUYSEN AVENUE1099 WALL STREET WEST |
account_city | text | — | 65% | BROOKLYNBRONXJAMAICA |
account_state | text | — | 64% | NYRENEWAL APPROVEDRENEWAL PENDING |
account_zip | text | — | 76% | 076660883011714- |
account_phone | phone | — | 83% | (973) 623-7600(201) 443-3000(718) 527-1414 |
vehicle_make | categorical | — | 100% | MackPeterbiltKenworthof 12 |
vehicle_model | text | — | 100% | 520T880Granite |
vehicle_type | categorical | — | 100% | Dump TruckRear End LoaderTruckof 18 |
vehicle_year | text | — | 100% | 202020172016 |
vehicle_color | categorical | — | 100% | WhiteGreenBlueof 15 |
contacted_complainant | categorical | — | 0% | FalseTrueof 2 |
unable_to_contact_complainant | categorical | — | 0% | FalseTrueof 2 |
method_used_to_contact | categorical | — | 72% | Phone CallE-MailIn Personof 4 |
export_date | date | — | 0% | 2026-10-09of 1 |
borough | categorical | — | 86% | BROOKLYNQUEENSMANHATTANof 5 |
latitude | float | — | 86% | 40.74214540.75788440.778558 |
longitide | float | — | 86% | -73.99426-73.985557-73.788363 |
community_board | integer | — | 86% | 125 |
council_district | integer | — | 86% | 314 |
census_tract | integer | — | 86% | 21150243 |
bin | integer | — | 87% | 300000040000002000000 |
bbl | integer | — | 87% | 416350030010076975031010427501 |
nta | text | — | 86% | Midtown-Midtown SouthHudson Yards-Chelsea-Fla…West Village |