About this Dataset

Census Blocks In 2020

Census blocks are statistical areas bounded on all sides by visible features (e.g., streets, roads, streams, and railroad tracks), and by non-visible boundaries (e.g., city, town, township, county limits, and short line-of-sight extensions of streets and roads). Generally, census blocks are small in area (e.g., a block in a city). Census blocks in suburban and rural areas may be large, irregular, and bounded by a variety of features (e.g., roads, streams, and/or transmission line rights-of-way). In remote areas, census blocks may encompass hundreds of square miles. Census blocks cover all territory in the United States, Puerto Rico, and the Island areas. Blocks do not cross the boundaries of any entity for which the Census Bureau tabulates data.

Census Block Numbers—Census blocks are numbered uniquely within the boundaries of each state, county, census tract with a 4-character census block number. The first character of the tabulation block number identifies the block group. A block number can only be unique by using the decennial census state (STATEFP), county (COUNTYFP), census tract (TRACTCE), and block (BLOCKCE)+. There is no consistency in block numbers from census to census.
Organization: District of Columbia
Last updated: 2024-04-30T19:05:37.917117
Tags: 1-percent-public-use-microdata-area-code, 106th-congressional-district-code, 108th-congressional-district-code, 11001, 3-digit-zip-code-tabulation-area-code, 5-digit-zip-code-tabulation-area-code, 5-percent-public-use-microdata-area-code, age, alaska-native-regional-corporation-fips-code, american-indian-alaska-native-native-hawaiian-areas-census-code, block-group, boundaries, census-blocks, census-tract-number, census2020, consolidated-city-fips-code, county-fips-code, county-or-equivalent-entity, county-subdivision-fips-code, dc-gis, demographic, demographics, district-of-columbia, elementary-school-district-local-education-agency-code, fips-55-place-code-for-all-places, housing-units, land-water-flag, legislative-session-year, metropolitan-statistical-area-consolidated-metropolitan-statistical-area-fips-code, new-england-county-metropolitan-area-fips-code, number, open-data, people, population, primary-metropolitan-statistical-area-fips-code, race, rreservation-or-off-reservation-trust-land-indicator, secondary-school-district-local-education-agency-code, state-fips-code, state-legislative-district-lower-chamber-code, state-legislative-district-upper-chamber-code, sub-minor-civil-division-fips-code-in-puerto-rico, table, tabulation-block-number, topological-faces, traffic-analysis-zone-code, tribal-subdivision-code, u-s, unified-school-district-local-education-agency-code, united-states, urban-area-code, urban-growth-area-code, voting-district-code, washington-dc

Tables

Table 1

@usgov.district_of_columbia_census_blocks_in_2020.table_1

874.94 kB
6,012 rows
318 columns

CREATE TABLE table_1 (
  "blkgrp" BIGINT,
  "block" BIGINT,
  "geoid" VARCHAR,
  "p0010001" BIGINT,
  "p0010002" BIGINT,
  "p0010003" BIGINT,
  "p0010004" BIGINT,
  "p0010005" BIGINT,
  "p0010006" BIGINT,
  "p0010007" BIGINT,
  "p0010008" BIGINT,
  "p0020002" BIGINT,
  "p0020005" BIGINT,
  "p0020006" BIGINT,
  "p0020007" BIGINT,
  "p0020008" BIGINT,
  "p0020009" BIGINT,
  "p0020010" BIGINT,
  "p0030001" BIGINT,
  "p0030003" BIGINT,
  "p0030004" BIGINT,
  "p0030005" BIGINT,
  "p0030006" BIGINT,
  "p0030007" BIGINT,
  "p0030008" BIGINT,
  "p0040002" BIGINT,
  "p0040005" BIGINT,
  "p0040006" BIGINT,
  "p0040007" BIGINT,
  "p0040008" BIGINT,
  "p0040009" BIGINT,
  "p0040010" BIGINT,
  "h0010001" BIGINT,
  "h0010002" BIGINT,
  "h0010003" BIGINT,
  "tract" BIGINT,
  "aland" BIGINT,
  "awater" BIGINT,
  "shape_leng" DOUBLE,
  "stusab" VARCHAR,
  "sumlev" BIGINT,
  "geocode" BIGINT,
  "state" BIGINT,
  "name" VARCHAR,
  "pop100" BIGINT,
  "hu100" BIGINT,
  "p0010009" BIGINT,
  "p0010010" BIGINT,
  "p0010011" BIGINT,
  "p0010012" BIGINT,
  "p0010013" BIGINT,
  "p0010014" BIGINT,
  "p0010015" BIGINT,
  "p0010016" BIGINT,
  "p0010017" BIGINT,
  "p0010018" BIGINT,
  "p0010019" BIGINT,
  "p0010020" BIGINT,
  "p0010021" BIGINT,
  "p0010022" BIGINT,
  "p0010023" BIGINT,
  "p0010024" BIGINT,
  "p0010025" BIGINT,
  "p0010026" BIGINT,
  "p0010027" BIGINT,
  "p0010028" BIGINT,
  "p0010029" BIGINT,
  "p0010030" BIGINT,
  "p0010031" BIGINT,
  "p0010032" BIGINT,
  "p0010033" BIGINT,
  "p0010034" BIGINT,
  "p0010035" BIGINT,
  "p0010036" BIGINT,
  "p0010037" BIGINT,
  "p0010038" BIGINT,
  "p0010039" BIGINT,
  "p0010040" BIGINT,
  "p0010041" BIGINT,
  "p0010042" BIGINT,
  "p0010043" BIGINT,
  "p0010044" BIGINT,
  "p0010045" BIGINT,
  "p0010046" BIGINT,
  "p0010047" BIGINT,
  "p0010048" BIGINT,
  "p0010049" BIGINT,
  "p0010050" BIGINT,
  "p0010051" BIGINT,
  "p0010052" BIGINT,
  "p0010053" BIGINT,
  "p0010054" BIGINT,
  "p0010055" BIGINT,
  "p0010056" BIGINT,
  "p0010057" BIGINT,
  "p0010058" BIGINT,
  "p0010059" BIGINT,
  "p0010060" BIGINT,
  "p0010061" BIGINT,
  "p0010062" BIGINT
);