From a 500-row sample across 17 columns.
:@computed_region_sbqj_enih:@computed_region_92fq_4b7q:@computed_region_f5dn_yrer+1:@computed_region_sbqj_enih:@computed_region_92fq_4b7q:@computed_region_f5dn_yrer+2cent_longitudecent_latitudebbl+3Mappable — Socrata point column `location_1`.
Open on the map →| insptn_ops_detail | insptn_typ_cd | insp_inspect_dt | inspecting_unit_code | bldg_current_bin_fk | borough | cent_latitude | cent_longitude | communitydistrict | citycouncildistrict | bbl | location_1 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 9132047 | RISK | 2018-08-14T00:00:00.000 | L115 | 4000431 | QN | 40.748422 | -73.950426 | 402 | 26 | 4000510028 | 40.748422, -73.950426 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
insptn_ops_detail | integer | Inspection ID | 0% | 100825051008271810081018 |
insptn_typ_cd | text | Type of Inspection | 0% | RISKof 1 |
insp_inspect_dt | datetime | Date inspection was completed | 0% | 2014-01-26T00:00:00.0002019-01-28T00:00:00.0002014-01-19T00:00:00.000 |
inspecting_unit_code | text | Inspecting Unit | 0% | L087E168L082 |
GET /api/datasets/itd7-gx3g GET /api/datasets/itd7-gx3g/quality GET /api/datasets/itd7-gx3g/related GET /api/columns?dataset=itd7-gx3g
:@computed_region_sbqj_enih:@computed_region_92fq_4b7q:@computed_region_f5dn_yrer:@computed_region_sbqj_enih:@computed_region_92fq_4b7q:@computed_region_f5dn_yrer+2cent_longitudecent_latitudebbl+3:@computed_region_sbqj_enih:@computed_region_92fq_4b7q:@computed_region_f5dn_yrer+2cent_longitudecent_latitudebbl+1| 4555617 |
| RISK |
| 2016-01-29T00:00:00.000 |
| L113 |
| 3115797 |
| BK |
| 40.656287 |
| -73.959764 |
| 309 |
| 40 |
| 3050480008 |
| 40.656287, -73.959764 |
| 2145393 | RISK | 2014-05-21T00:00:00.000 | L087 | 5120386 | SI | 40.578294 | -74.157794 | 502 | 51 | 5024507511 | 40.578294, -74.157794 |
| 5047033 | RISK | 2016-05-17T00:00:00.000 | E095 | 1065067 | MN | 40.868562 | -73.924958 | 112 | 10 | 1022480024 | 40.868562, -73.924958 |
| 8714291 | RISK | 2018-06-01T00:00:00.000 | E228 | 3018012 | BK | 40.649863 | -74.004148 | 307 | 38 | 3009170058 | 40.649863, -74.004148 |
| 7202317 | RISK | 2017-08-09T00:00:00.000 | E166 | 5119665 | SI | 40.60714 | -74.151026 | 502 | 50 | 5020877501 | 40.60714, -74.151026 |
| 2434293 | RISK | 2014-08-03T00:00:00.000 | L011 | 1004922 | MN | 40.727376 | -73.978663 | 103 | 2 | 1003940063 | 40.727376, -73.978663 |
| 10088628 | RISK | 2019-01-23T00:00:00.000 | L117 | 4010686 | QN | — | — | — | — | — | — |
| 2007158 | RISK | 2014-04-17T00:00:00.000 | L086 | 5151711 | SI | 40.600441000000004 | -74.16247 | 502 | 50 | 5020300001 | 40.600441, -74.16247 |
| 5759084 | RISK | 2016-10-24T00:00:00.000 | L047 | 2118906 | BX | 40.822481 | -73.85166100000001 | 209 | 18 | 2036120031 | 40.822481, -73.851661 |
Showing 12 of 17 columns. All of them are listed below.
bldg_current_bin_fk |
| integer |
| — |
| 0% |
205704533932865113197 |
borough | categorical | — | 0% | QNBKMNof 5 |
cent_latitude | float | Latitude of Building Centroid | 2% | 40.7435640.61938140.875013 |
cent_longitude | float | Longitude of Building Centroid | 2% | -73.755654-74.092437-73.828362 |
communitydistrict | integer | — | 2% | 501503502 |
citycouncildistrict | integer | — | 2% | 495132 |
bbl | integer | Building Block Lot | 2% | 405917000120514101204159260001 |
location_1 | coordinate | — | — | — |