From a 500-row sample across 14 columns.
boronameboroct2020ctlabel+5boronamecdtanamentaabbrev+4boronamecdtanamecountyfips+2boronamegeoidct2020+1Has borough codes (`boroname`) — joinable, but needs boundary shapes to draw.
| geoid | countyfips | borocode | boroname | boroct2020 | ct2020 | ctlabel | ntacode | ntatype | ntaname | ntaabbrev | cdtacode |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 36005001901 | 005 | 2 | Bronx | 2001901 | 001901 | 19.01 | BX0101 | 0 | Mott Haven-Port Morris | MttHvn | BX01 |
| 36005001902 | 005 | 2 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
geoid | text | Unqiue Identifier for 2020 census tracts - the first digit is the County FIPS code, and the last 6 digits are the zero-filled census tract number. This can be used with BYTES of the Big Apple datasets: https://www1.nyc.gov/site/planning/data-maps/open-data.page#district_political | 0% | 360850207023604708560036005023000 |
countyfips | categorical | Federal unique ID for counties (005=Bronx, 047=Kings, 061=New York, 081=Queens, 085=Richmond) | 0% | 047081005of 5 |
borocode | categorical | Borough in which the census tract is located. (1=Manhattan, 2=The Bronx, 3=Brooklyn, 4=Queens, 5=Staten Island) | 0% | 342of 5 |
boroname | categorical | Borough name for the borough in which the census tract is located. |
GET /api/datasets/hm78-6dwm GET /api/datasets/hm78-6dwm/quality GET /api/datasets/hm78-6dwm/related GET /api/columns?dataset=hm78-6dwm
boroct2020ctlabelcdtaname+1| Bronx |
| 2001902 |
| 001902 |
| 19.02 |
| BX0101 |
| 0 |
| Mott Haven-Port Morris |
| MttHvn |
| BX01 |
| 36005001903 | 005 | 2 | Bronx | 2001903 | 001903 | 19.03 | BX0101 | 0 | Mott Haven-Port Morris | MttHvn | BX01 |
| 36005002300 | 005 | 2 | Bronx | 2002300 | 002300 | 23 | BX0101 | 0 | Mott Haven-Port Morris | MttHvn | BX01 |
| 36005002500 | 005 | 2 | Bronx | 2002500 | 002500 | 25 | BX0101 | 0 | Mott Haven-Port Morris | MttHvn | BX01 |
| 36005002701 | 005 | 2 | Bronx | 2002701 | 002701 | 27.01 | BX0101 | 0 | Mott Haven-Port Morris | MttHvn | BX01 |
| 36005002702 | 005 | 2 | Bronx | 2002702 | 002702 | 27.02 | BX0101 | 0 | Mott Haven-Port Morris | MttHvn | BX01 |
| 36005003100 | 005 | 2 | Bronx | 2003100 | 003100 | 31 | BX0101 | 0 | Mott Haven-Port Morris | MttHvn | BX01 |
| 36005003300 | 005 | 2 | Bronx | 2003300 | 003300 | 33 | BX0101 | 0 | Mott Haven-Port Morris | MttHvn | BX01 |
| 36005003500 | 005 | 2 | Bronx | 2003500 | 003500 | 35 | BX0101 | 0 | Mott Haven-Port Morris | MttHvn | BX01 |
Showing 12 of 14 columns. All of them are listed below.
| 0% |
BrooklynQueensBronxof 5 |
boroct2020 | text | Unqiue Identifier for 2020 census tracts - merged string value of the BoroCode and census tract number | 0% | 101290220075003118000 |
ct2020 | text | 2020 census tract number | 0% | 027900003900025100 |
ctlabel | integer | The census tract identifier. Each census tract number is unique to its borough | 0% | 13827977 |
ntacode | text | Unique alphanumeric identifier for each Neighborhood Tabulation Area (NTA). Includes 6 characters: 2 alpha for borough, 2 numeric matching CDTA number, 1 numberic indicating NTA Type, and 1 numeric to create unique ID | 0% | BK1803BK1001BK1101 |
ntatype | categorical | The NTA type differentiates between residential and various non-residential geographies. It is also the 5th character of the NTA code. [0 = Residential, 9 = Park, 8 = Airport, 7 = Cemetery, 6 = Other Special Areas (including forts, navy yard, etc), 5 = Rikers Island] | 0% | 097of 6 |
ntaname | text | Full NTA name [e.g., East New York (North)] | 0% | CanarsieBensonhurstBay Ridge |
ntaabbrev | text | Shortened version of NTA name (e.g., ENY_N) | 0% | CnrsieBnsnhrstByRdg |
cdtacode | text | Unique alphanumeric identifier representing Community District Tabulation Areas (CDTA). Includes 4 characters: 2 alpha characters representing the borough and 2 numeric characters matching the CD number | 0% | QN12BK18QN13 |
cdtatype | categorical | Differentiates between CDTAS which represent a community district (CD) or a joint interest area - areas outside of community districts (JIA) | 0% | CDJIAof 2 |
cdtaname | text | Full name of CDTA [e.g., BK05 East New York-Cypress Hills (CD 5 Approximation)] | 0% | QN12 Jamaica-St. Albans-…BK18 Canarsie-Flatlands …QN13 Queens Village-Bell… |