From a 500-row sample across 12 columns.
oidoidoidoidHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| oid | blockcode | geo_id | bctcb2010 | borocode | nta_code | nta_name | borough | puma | maximum_residential_broadband | residential_isp_count_by | commerical_fiber_count_by |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 360610037001012 | 360610037001 | 10037001012 | 1 | MN24 | SoHo-TriBeCa-Civic Center-Little Italy | Manhattan | 3810 | 1000 | 3 | 11 |
| 1 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
oid | text | Origin Identification Number. | 0% | 348843251429365 |
blockcode | text | The 2010 census block that the attribute or asset is located in or referencing. | 0% | 360811283001030360470177001016360050351003008 |
geo_id | text | Geographic identifier; GEOIDs are numeric codes that uniquely identify all administrative/legal and statistical geographic areas for which the Census Bureau tabulates data. | 0% | 360810383021360810716001360850291021 |
bctcb2010 | text | Merged string value of the BoroCode, census tract number, and census block number | 0% |
GET /api/datasets/8ess-ssnw GET /api/datasets/8ess-ssnw/quality GET /api/datasets/8ess-ssnw/related GET /api/columns?dataset=8ess-ssnw
oidboroughoid| 360610037002002 |
| 360610037002 |
| 10037002002 |
| 1 |
| MN24 |
| SoHo-TriBeCa-Civic Center-Little Italy |
| Manhattan |
| 3810 |
| 1000 |
| 3 |
| 5 |
| 2 | 360610037003008 | 360610037003 | 10037003008 | 1 | MN24 | SoHo-TriBeCa-Civic Center-Little Italy | Manhattan | 3810 | 940 | 2 | 6 |
| 3 | 360610037001000 | 360610037001 | 10037001000 | 1 | MN24 | SoHo-TriBeCa-Civic Center-Little Italy | Manhattan | 3810 | 940 | 1 | 4 |
| 4 | 360610037001002 | 360610037001 | 10037001002 | 1 | MN24 | SoHo-TriBeCa-Civic Center-Little Italy | Manhattan | 3810 | 940 | 2 | 4 |
| 5 | 360610037001011 | 360610037001 | 10037001011 | 1 | MN24 | SoHo-TriBeCa-Civic Center-Little Italy | Manhattan | 3810 | 940 | 1 | 5 |
| 6 | 360610037001013 | 360610037001 | 10037001013 | 1 | MN24 | SoHo-TriBeCa-Civic Center-Little Italy | Manhattan | 3810 | 940 | 2 | 6 |
| 7 | 360610037001016 | 360610037001 | 10037001016 | 1 | MN24 | SoHo-TriBeCa-Civic Center-Little Italy | Manhattan | 3810 | 940 | 3 | 4 |
| 8 | 360610037001018 | 360610037001 | 10037001018 | 1 | MN24 | SoHo-TriBeCa-Civic Center-Little Italy | Manhattan | 3810 | 940 | 2 | 2 |
| 9 | 360610037002004 | 360610037002 | 10037002004 | 1 | MN24 | SoHo-TriBeCa-Civic Center-Little Italy | Manhattan | 3810 | 940 | 1 | 5 |
302750040002021800400020077001001borocode | categorical | Single digit unique identifier of a borough; Boro code (1 = Manhattan, 2 = Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island) | 0% | 432of 5 |
nta_code | text | Four (4) digit code assigned to neighborhoods to differentiate NYC's five boroughs; The first two letters of each code represent the borough the neighborhood is located in. The two letter abbreviation represents the following boroughs; MN = Manhattan, BX = Bronx, BK = Brooklyn, QU = Queens, SI = Staten Island. | 0% | QN31QN99BK82 |
nta_name | text | Neighborhood name identifiers to differentiate NYC's five boroughs. | 0% | Hunters Point-Sunnyside-…park-cemetery-etc-QueensEast New York |
borough | categorical | The Borough of New York City where the attribute or asset is located. | 0% | QueensBrooklynBronxof 5 |
puma | text | A Public Use Microdata Area, or PUMA, are geographic units used by the US Census for providing statistical and demographic information. Each PUMA contains at least 100,000 people. | 0% | 410539014103 |
maximum_residential_broadband | categorical | The reported maximum advertised downstream speed/bandwidth offered by any provider in a census block for consumer service. | 3% | 9405001000of 3 |
residential_isp_count_by | categorical | The number of residential broadband internet service providers reported to be available per census block. | 3% | 213of 5 |
commerical_fiber_count_by | categorical | The number of commercial fiber internet service providers reported to be available per census block. | 3% | 120of 15 |