From a 500-row sample across 31 columns.
bic_numbercommunity_boardaccount_name+7bic_numbercommunity_boardaccount_name+8bic_numberaccount_nameexport_datelatitudelongitudebin+2Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| violation_number | bic_number | account_name | type_of_violation | violation_phase | violation_disposition | account_type | violation_account_address | violation_account_city | violation_account_state | violation_account_postcode | borough_of_violation |
|---|---|---|---|---|---|---|---|---|---|---|---|
| TWC-226379 | 1181 | ACTION CARTING ENVIRONMENTAL SERVICES INC. | OATH | Issued | Settled | License | 300 FRANK W. BURR BLVD, STE. 39 | TEANECK | NJ | 07666 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
violation_number | text | — | 0% | TWC-7380TWC-211450TWC-7856 |
bic_number | text | — | 45% | 124011811431 |
account_name | text | — | 0% | ROYAL WASTE SERVICES INC…ACTION CARTING ENVIRONME…SANITATION SALVAGE CORP. |
type_of_violation | text | — | 0% | OATHof 1 |
violation_phase |
GET /api/datasets/upii-frjc GET /api/datasets/upii-frjc/quality GET /api/datasets/upii-frjc/related GET /api/columns?dataset=upii-frjc
community_boardlatitudelongitude+4community_boardlatitudelongitude+5community_boardlatitudelongitude+4| Bronx |
| TWC-220554 | — | PRESTIGE INDUSTRY CORP. | OATH | Issued | Settled | Unlicensed | 45-42 PEARSON STREET | LONG ISLAND CITY | NY | 11101 | Brooklyn |
| TWC-230831 | 908 | GUMA CONSTRUCTION CORP. | OATH | Issued | Settled | CL2 - Exempt | 240 WATER STREET | BROOKLYN | NY | 11201-1124 | Brooklyn |
| TWC-234740 | 503263 | MIGLIORE RESTORATION INC | OATH | Issued | Calendared | License | 1208 JERICHO TURNPIKE | NEW HYDE PARK | NY | 11040 | Manhattan |
| TWC-231960 | 3353 | WILENTA CARTING OF NY, INC. | OATH | Issued | Settled | License | 46 HENRY STREET | SECAUCUS | NJ | 07094 | Bronx |
| TWC-233262 | — | Rafiq, Mohammad | OATH | Issued | Settled | Unlicensed | 10 Ridge Rd | Albertson | NY | 11507 | Brooklyn |
| TWC-227827 | 504989 | 5 BOROUGHS CONTAINERS LLC | OATH | Issued | Settled | CL2 - Exempt | 1635 SHERBOURNE RD | VALLEY STREAM | NY | 11580 | Bronx |
| TWC-234603 | 513994 | CONSTITUTION WORKGROUP LLC | OATH | Issued | Settled - Pending | License | 9851 WIDMER ROAD | LENEXA | KS | 66215 | Manhattan |
| TWC-228610 | 503306 | 5 BOROUGH WASTE REMOVAL INC | OATH | Issued | Settled | License | 8639 143RD STREET 2ND FLOOR | JAMAICA | NY | 11435 | Brooklyn |
| TWC-227738 | 501970 | COGENT WASTE SOLUTIONS LLC | OATH | Issued | Settled | License | 860 HUMBOLDT STREET | BROOKLYN | NY | 11222 | Brooklyn |
Showing 12 of 31 columns. All of them are listed below.
| text |
| — |
| 0% |
Issuedof 1 |
violation_disposition | categorical | — | 0% | SettledBarred by CPLRDefault - Grantedof 14 |
account_type | categorical | — | 0% | UnlicensedCL2 - ExemptLicenseof 7 |
violation_account_address | text | — | 1% | 300 FRANK W. BURR BLVD, …168-46 DOUGLAS AVENUE421 MANIDA STREET |
violation_account_city | text | — | 1% | BROOKLYNSTATEN ISLANDBRONX |
violation_account_state | text | — | 1% | NYNJPA |
violation_account_postcode | text | — | 1% | 104741137807666 |
borough_of_violation | categorical | — | 7% | ManhattanBrooklynBronxof 11 |
date_of_violation | datetime | — | 0% | 2018-12-07T05:00:00.0002019-08-16T04:00:00.0002016-06-01T04:00:00.000 |
date_violation_issued | datetime | — | 0% | 2023-03-21T04:00:00.000Z2022-11-07T05:00:00.000Z2016-03-15T04:00:00.000Z |
maximum_fine | integer | — | 0% | 0100005000 |
fine_amount | integer | — | 13% | 02502500 |
date_fine_paid | datetime | — | 38% | 2023-03-27T00:00:00.0002023-06-07T00:00:00.0002023-04-20T00:00:00.000 |
early_settlement_violation | categorical | — | 0% | FalseTrueof 2 |
settlement_date | datetime | — | 81% | 2023-04-13T00:00:00.0002023-03-28T00:00:00.0002022-11-30T00:00:00.000 |
rule_code | text | — | 0% | NYC AC 16-505(a)17 RCNY 7-03(e)17 RCNY 1-09 |
number_of_counts | integer | — | 0% | 123 |
description_of_rule | text | — | 0% | Removed collected or dis…It shall be unlawful for…(e) A trade waste vehi… |
export_date | datetime | — | 0% | 2026-05-28T00:00:00.000of 1 |
latitude | float | — | 44% | 40.70394940.8089140.663641 |
longitude | float | — | 44% | -73.789576-73.886944-73.876078 |
community_board | categorical | — | 44% | 1212of 18 |
council_district | integer | — | 44% | 173019 |
census_tract | integer | — | 44% | 93444579 |
bin | integer | — | 46% | 200000030987874458780 |
bbl | integer | — | 46% | 202771021930449900454103520145 |
nta | text | — | 44% | Hunts PointJamaicaHunters Point-Sunnyside-… |