From a 500-row sample across 18 columns.
boroughstatusstatusboroughHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| recoupid | sourcedescription | accidentdate | policereportid | location | datereceived | closedate | status | latestactiondescription | precinctid | description | unitdescription |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 08365-11 | ALBANY | 2011-11-26T00:00:00.000 | 3535 | METROPOLITAN AVENUE @ 69TH STREET, QUEENS | 2012-09-26T00:00:00.000 | 2012-10-22T00:00:00.000 | Closed | Close | 0 | Lightpole | Street lighting |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
recoupid | text | — | 0% | 16400-2409730-1309755-13 |
sourcedescription | categorical | — | 0% | ALBANYINSURANCE COMPANYLOCAL PRECINCTof 11 |
accidentdate | datetime | — | 0% | 2010-11-18T00:00:00.0002008-11-15T00:00:00.0002007-12-02T00:00:00.000 |
policereportid | text | — | 2% | 000/000060N/A |
GET /api/datasets/68k5-hdzw GET /api/datasets/68k5-hdzw/quality GET /api/datasets/68k5-hdzw/related GET /api/columns?dataset=68k5-hdzw
borough| 01716-06 | DOT SAFETY & HEALTH | 2006-11-08T00:00:00.000 | 037 | 3RD AVE @ 18 ST AND 3RD AVE | 2007-05-15T00:00:00.000 | 2007-07-25T00:00:00.000 | Closed | Close | 0 | DOT Vehicle | Fleet Services |
| 01984-07 | DOT SAFETY & HEALTH | 2007-06-18T00:00:00.000 | 0733 | 10TH AVE W 201 ST DYCKMAN | 2007-10-16T00:00:00.000 | 2009-09-09T00:00:00.000 | Closed | Close | 0 | DOT Vehicle | Fleet Services |
| 05218-08 | ALBANY | 2008-01-06T00:00:00.000 | 047 | VAN WYCK EXPWY @ INT WITH LINDEN BLVD | 2010-02-05T00:00:00.000 | 2010-07-29T00:00:00.000 | Closed | Close | 0 | Guide/Guard Rails on Highways | Arterials |
| 08964-13 | INSURANCE COMPANY | 2013-03-18T00:00:00.000 | 802 | MAURICE AVE @ BORDEN AVE, QUEENS | 2013-05-23T00:00:00.000 | 2013-08-09T00:00:00.000 | Closed | Close | 0 | TRAFFIC LIGHT | Traffic Signals |
| 02611-08 | INSURANCE COMPANY | 2008-02-27T00:00:00.000 | 638 | JERSEY ST @ RICHMOND TERRACE, RICHMOND | 2008-05-05T00:00:00.000 | 2011-06-13T00:00:00.000 | Closed | Close | 0 | TRAFFIC POLE | Street lighting |
| 11226-14 | ALBANY | 2014-06-16T00:00:00.000 | 0231400629 | 1ST AVE @ EAST 115TH ST. MANHATTAN | 2016-03-18T00:00:00.000 | 2016-04-01T00:00:00.000 | Closed | Close | 0 | TRAFFIC LIGHT | Traffic Signals |
| 02415-08 | LOCAL PRECINCT | 2008-01-14T00:00:00.000 | 28 | CROSS BAY BLVD @ E. 1ST RD | 2008-03-20T00:00:00.000 | 2008-04-03T00:00:00.000 | Closed | Close | 58 | Utility Pole | Street lighting |
| 10455-14 | INSURANCE COMPANY | 2014-01-07T00:00:00.000 | 0461400030 | SEDGWICK AVENUE @ HALL OF FAME TERRACE, BRONX | 2014-11-07T00:00:00.000 | 2015-04-01T00:00:00.000 | Closed | Close | 0 | Guide/Guard Rails on Highways | Arterials |
| 02042-07 | LOCAL PRECINCT | 2007-09-19T00:00:00.000 | 2684 | ASCH LOOP @ BARTOW AVE, BRONX | 2007-10-30T00:00:00.000 | 2010-12-20T00:00:00.000 | Closed | Close | 28 | Lightpole | Street lighting |
Showing 12 of 18 columns. All of them are listed below.
location |
| text |
| — |
| 0% |
NEPTUNR AVE@BRIGHT FGFGF…COMPLAINT UNKNOWNE/B BELT PKWY @ BAY PKWY |
datereceived | datetime | — | 0% | 2012-12-18T00:00:00.0002011-01-24T00:00:00.0002010-01-20T00:00:00.000 |
closedate | datetime | — | 4% | 2006-03-14T00:00:00.0002010-04-14T00:00:00.0002006-03-13T00:00:00.000 |
status | categorical | — | 0% | ClosedOpenof 2 |
latestactiondescription | categorical | — | 0% | CloseRequest for EstimateRequest for Paymentof 7 |
borough | categorical | — | 86% | Bklyn SouthQns SouthBronxof 8 |
precinctid | integer | — | 0% | 07641 |
description | text | — | 13% | Guide/Guard Rails on Hig…LightpoleUtility Pole |
unitdescription | categorical | — | 13% | Street lightingArterialsFleet Servicesof 12 |
companyname | text | — | 16% | GEICOINSURED (NO INS. CODE)ALLSTATE INS. CO. |
requestamount | float | — | 0% | 116.890345.24 |
hasadminfee | categorical | — | 16% | NoYesof 2 |
adminfee | categorical | — | 0% | 116.89058.45of 5 |
paidamount | float | — | 0% | 0345.24228.35 |