From a 500-row sample across 21 columns.
:@computed_region_92fq_4b7qlatitude:@computed_region_sbqj_enih+17:@computed_region_92fq_4b7qlatitude:@computed_region_sbqj_enih+4:@computed_region_92fq_4b7qlatitude:@computed_region_sbqj_enih+5Mappable — Socrata point column `location`.
Open on the map →| evnt_key | violation_date | violation_time | chg_law_cd | violation_code | veh_category | reg_plate_num | reg_state_cd | city_nm | rpt_owning_cmd | x_coord_cd | y_coord_cd |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 299096309 | 2025-01-08T00:00:00.000 | 14:38:00 | VTL | 1225D | CAR/SUV | PC294401 | DE | BROOKLYN | 412 | 1012989 | 166056 |
| 178546068 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
evnt_key | text | — | 0% | 137033040137607814137650101 |
violation_date | datetime | — | 0% | 2018-03-06T00:00:00.0002018-04-26T00:00:00.0002018-04-12T00:00:00.000 |
violation_time | text | — | 0% | 17:00:0000:00:0009:00:00 |
chg_law_cd | categorical | — | 0% | VTLNYCNYCTRRof 6 |
GET /api/datasets/bme5-7ty4 GET /api/datasets/bme5-7ty4/quality GET /api/datasets/bme5-7ty4/related GET /api/columns?dataset=bme5-7ty4
:@computed_region_92fq_4b7qlatitude:@computed_region_sbqj_enih+4:@computed_region_92fq_4b7qlatitude:@computed_region_sbqj_enih+6:@computed_region_92fq_4b7qlatitude:@computed_region_sbqj_enih+6latitudelongitude:@computed_region_92fq_4b7qlatitude:@computed_region_sbqj_enih+6| 2018-04-24T00:00:00.000 |
| 13:49:04 |
| VTL |
| 1225D |
| CAR/SUV |
| — |
| — |
| — |
| 46 |
| — |
| — |
| 178656983 | 2018-04-27T00:00:00.000 | 08:10:00 | VTL | 5091 | CAR/SUV | — | — | — | 123 | — | — |
| 178546265 | 2018-04-24T00:00:00.000 | 15:49:27 | NYC | 406A1 | CAR/SUV | — | — | — | 17 | — | — |
| 175894261 | 2018-03-14T00:00:00.000 | 20:35:00 | VTL | 1110A | CAR/SUV | — | — | — | 83 | — | — |
| 174883539 | 2018-02-16T00:00:00.000 | 11:12:00 | VTL | 1229C3A | CAR/SUV | — | — | — | 66 | — | — |
| 177999584 | 2018-04-10T00:00:00.000 | 15:00:40 | VTL | 1160A | CAR/SUV | — | — | — | 14 | — | — |
| 176197590 | 2018-03-22T00:00:00.000 | 14:15:18 | VTL | 37512A1 | CAR/SUV | — | — | — | 77 | — | — |
| 175255923 | 2018-02-27T00:00:00.000 | 10:02:00 | NYC | 405B1 | CAR/SUV | — | — | — | 115 | — | — |
| 177876027 | 2018-04-06T00:00:00.000 | 14:26:33 | VTL | 37512A2 | CAR/SUV | — | — | — | 14 | — | — |
Showing 12 of 16 columns. All of them are listed below.
violation_code| text |
| — |
| 0% |
1110A1180D1225D |
veh_category | categorical | — | 0% | CAR/SUVMCLTRUCK/BUSof 10 |
reg_plate_num | text | Vehicle license plate number | 89% | (null)NONENA |
reg_state_cd | text | Issuing state of the license plate | 89% | NYNJ(null) |
city_nm | categorical | — | 0% | BROOKLYNQUEENSMANHATTANof 10 |
rpt_owning_cmd | integer | — | 0% | 411413412 |
x_coord_cd | integer | — | 0% | 10320919974071017478 |
y_coord_cd | integer | — | 0% | 241976233806256069 |
latitude | float | — | 0% | 40.83072232800003640.74911076500006940.8307223277672 |
longitude | float | — | 0% | -73.827126058999966-73.992007266999963-73.8271260588639 |
location | coordinate | — | 0% | {'coordinates': [-73.827…{'coordinates': [-73.992…{'coordinates': [-73.827… |
juris_cd | text | — | 55% | 01of 1 |