Schema
2020 Census Blocks / 2020 Census Blocks - tl_2024_23_tabblock20 / v1.0.0
Schema from tl_2024_23_tabblock20.parquet, gcp-portolan-published, v1.0.0.
Blocks (Census Blocks) are statistical areas bounded by visible features, such as streets, roads, streams, and railroad tracks, and by non-visible boundaries, such as selected property lines and city, township, school district, and county limits, and short line-of-sight extensions of streets and roads. Generally, census blocks are small in area; for example, a block in a city bounded on all sides by streets. Census blocks in suburban and rural areas may be large, irregular, and bounded by a variety of features, such as roads, streams, and/or transmission line rights-of-way. In remote areas, census blocks may encompass hundreds of square miles. Census blocks cover the entire territory of the United States, Puerto Rico, and the Island Areas. Census blocks nest within all other tabulated census geographic entities and are the basis for all tabulated data.Download: https://www2.census.gov/geo/tiger/TGRGDB24/tlgdb_2024_a_us_block.gdb.zipMetadata: meta.geo.census.gov/data/existing/decennial/GEO/GPMB/TIGERline/Current_19115/series_tl_2023_tabblock20.shp.iso.xml
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| STATEFP20 | string | No | 0 | — | — Range: —Length: 2 | Examples: 23, 23, 23, 23, 23 Values: 23 |
| COUNTYFP20 | string | No | 0 | — | — Range: —Length: 3 | Examples: 029, 013, 015, 003, 017 Values: 001, 003, 005, 007, 009, 011, 013, 015, 017, 019, 021, 023, 025, 027, 029, 031 |
| TRACTCE20 | string | No | 0 | — | — Range: —Length: 6 | Examples: 955100, 970401, 975500, 952600, 966600 Values: — |
| BLOCKCE20 | string | No | 0 | — | — Range: —Length: 4 | Examples: 2022, 1059, 2002, 1006, 4048 Values: — |
| GEOID20 | string | No | 0 | — | — Range: —Length: 15 | Examples: 230299551002022, 230139704011059, 230159755002002, 230039526001006, 230179666004048 Values: — |
| GEOIDFQ20 | string | No | 0 | — | — Range: —Length: 24 | Examples: 1000000US230299551002022, 1000000US230139704011059, 1000000US230159755002002, 1000000US230039526001006, 1000000US230179666004048 Values: — |
| NAME20 | string | No | 0 | — | — Range: —Length: 9 | Examples: Block2022, Block1059, Block2002, Block1006, Block4048 Values: — |
| MTFCC20 | string | No | 0 | — | — Range: —Length: 5 | Examples: G5040, G5040, G5040, G5040, G5040 Values: G5040 |
| UR20 | string | No | 0 | — | — Range: —Length: 1 | Examples: R, R, R, R, R Values: R, U |
| UACE20 | string | Yes | 4,692 | — | — Range: —Length: 5 | Examples: 71263, 49339, 71263, 71506, 04951 Values: 04195, 04951, 06355, 09200, 11040, 12943, 24607, 49339, 57331, 63973, 71263, 71506, 72154, 75799, 76690, 78850, 82387, 83129, 83368, 92782 |
| FUNCSTAT20 | string | No | 0 | — | — Range: —Length: 1 | Examples: S, S, S, S, S Values: S |
| ALAND20 | integer | No | 0 | — | — Range: 0 to 152025945Length: — | Examples: 0, 0, 0, 0, 5500 Values: — |
| AWATER20 | integer | No | 0 | — | — Range: 1 to 159581506Length: — | Examples: 122156, 20140, 320348, 50281, 2341783 Values: — |
| INTPTLAT20 | string | No | 0 | — | — Range: —Length: 11 | Examples: +45.6544492, +44.1217928, +44.0647920, +46.2716731, +44.1536504 Values: — |
| INTPTLON20 | string | No | 0 | — | — Range: —Length: 12 | Examples: -067.8691412, -069.2422308, -069.7000324, -068.0200900, -070.9306349 Values: — |
| HOUSING20 | integer | No | 0 | — | — Range: 0 to 442Length: — | Examples: 0, 0, 0, 0, 1 Values: — |
| POP20 | integer | No | 0 | — | — Range: 0 to 941Length: — | Examples: 0, 0, 0, 0, 1 Values: — |
| id | integer | No | 0 | — | — Range: 1 to 4990Length: — | Examples: 389, 3824, 4827, 4563, 627 Values: — |