From a 500-row sample across 30 columns.
blockstreet_namebbl+7street_namebbllongitude+8blockbbllongitude+4blockbbllongitude+7Mappable — Socrata point column `location`.
Open on the map →| job_number | job_type | c_o_issue_date | bin_number | borough | house_number | street_name | block | lot | postcode | application_status_raw | filing_status_raw |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 220466350 | A1 | 2021-04-08T00:00:00.000 | 2102454 | Bronx | 340 | BAYCHESTER AVE | 05141 | 00035 | 10475 | Issued | New |
| 321383560 | NB |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
job_number | text | Number assigned by the Department of Buildings for the Certificate of Occupancy Application and Filing. | 0% | 104620288104870533120638122 |
job_type | categorical | Job Type based on DOB Job Code (NB- New Building, A1,A2,A3 - Alternations 1-3, SG-Sign, etc.) | 0% | A1NBof 2 |
c_o_issue_date | datetime | Date the Certificate of Occupancy was issued | 0% | 2018-07-17T00:00:00.0002018-12-20T00:00:00.0002017-08-17T00:00:00.000 |
bin_number | text | Number assigned by City Planning for a specific building. | 0% |
GET /api/datasets/bs8b-p36w GET /api/datasets/bs8b-p36w/quality GET /api/datasets/bs8b-p36w/related GET /api/columns?dataset=bs8b-p36w
blockbbllongitude+6:@computed_region_sbqj_enihbbllongitude+10street_namebbllongitude+7blockstreet_namebbl+10| 2021-04-08T00:00:00.000 |
| 3128179 |
| Brooklyn |
| 639 |
| FOSTER AVENUE |
| 05428 |
| 00092 |
| 11230 |
| Issued |
| New |
| 520382988 | NB | 2021-04-08T00:00:00.000 | 5061795 | Staten Island | 435 | CORBIN AVENUE | 04583 | 00023 | 10308 | Issued | New |
| 301556144 | A1 | 2021-04-08T00:00:00.000 | 3184400 | Brooklyn | 3975 | BEDFORD AVENUE | 06831 | 00056 | 11229 | Issued | New |
| 321537404 | A1 | 2021-04-08T00:00:00.000 | 3056840 | Brooklyn | 38 | DOWNING STREET | 01982 | 00045 | 11238 | Issued | New |
| 520373435 | A1 | 2021-04-08T00:00:00.000 | 5067114 | Staten Island | 115 | HILLCREST STREET | 05262 | 00095 | 10308 | Issued | New |
| 320458768 | NB | 2021-04-08T00:00:00.000 | 3426102 | Brooklyn | 1044 | BEDFORD AVE | 01950 | 00033 | 11205 | Issued | New |
| 321761857 | A1 | 2021-04-08T00:00:00.000 | 3139122 | Brooklyn | 824 | 54TH STREET | 05672 | 00016 | 11220 | Issued | New |
| 321195773 | NB | 2021-04-08T00:00:00.000 | 3421802 | Brooklyn | 588 | WARWICK STREET | 04062 | 00031 | 11207 | Issued | New |
| 520202986 | NB | 2021-04-08T00:00:00.000 | 5164968 | Staten Island | 32 | WANDEL AVENUE | 00623 | 00090 | 10304 | Issued | New |
Showing 12 of 30 columns. All of them are listed below.
101254110158321000060borough | categorical | Borough of Residence or Commercial Property. | 0% | ManhattanBrooklynQueensof 5 |
house_number | text | House Number of Residence or Commercial Property. | 0% | 2001100 |
street_name | text | Street Name where Property is located. | 0% | BROADWAYMADISON AVENUEPARK AVENUE |
block | text | Tax Block assigned by the Department of Finance. | 0% | 159050001616350 |
lot | text | Tax Lot assigned by the Department of Finance. | 0% | 000010750100029 |
postcode | text | Postcode | 0% | 100131001110001 |
pr_dwelling_unit | text | Proposed number of Dwelling Units | 31% | 210 |
ex_dwelling_unit | text | Existing number of Dwelling Units | 64% | 102 |
application_status_raw | categorical | Certificate of Occupancy Application Status (Open, Issued, Withdrawn) | 0% | IssuedOpenof 2 |
filing_status_raw | text | Certificate of Occupancy Filing Status (Amended, Final, New Temporary) | 0% | Newof 1 |
item_number | text | Number of Partitioned Units of Work for a Job. | 0% | 001002003 |
issue_type | categorical | Certificate of Occupancy Issue Type (Temporary, Final) | 0% | TemporaryFinalof 2 |
latitude | coordinate | Latitude | 1% | 40.74187640.74782640.711537 |
longitude | coordinate | Longitude | 1% | -74.004713-73.987101-74.015673 |
community_board | text | Community Board | 1% | 125 |
council_district | text | Council District | 1% | 341 |
census_tract | text | Census Tract | 1% | 33217 |
bin | text | Number assigned by City Planning for a specific building. | 3% | 300000040000001000000 |
bbl | text | Borough-Block_Lot | 3% | 416350040020564375021009720001 |
nta | text | Neighborhood Tabulation Area | 1% | Midtown-Midtown SouthSoHo-TriBeCa-Civic Cente…Hudson Yards-Chelsea-Fla… |
location | coordinate | Latitude and Longitude. Used for mapping purpose | — | — |