Dataset: Census Tracts In 2020

About this Dataset

Census Tracts In 2020

Census Tracts from 2020. The TIGER/Line shapefiles are an extract of selected geographic and cartographic information from the U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB). The MTDB represents a seamless national file with no overlaps or gaps between parts, however, each TIGER/Line shapefile is designed to stand alone as an independent data set, or they can be combined to cover the entire nation. Census tracts are small, relatively permanent statistical subdivisions of a county or equivalent entity, and were defined by local participants as part of the 2020 Census Participant Statistical Areas Program. The Census Bureau delineated the census tracts in situations where no local participant existed or where all the potential participants declined to participate. The primary purpose of census tracts is to provide a stable set of geographic units for the presentation of census data and comparison back to previous decennial censuses. Census tracts generally have a population size between 1,200 and 8,000 people, with an optimum size of 4,000 people. When first delineated, census tracts were designed to be homogeneous with respect to population characteristics, economic status, and living conditions. The spatial size of census tracts varies widely depending on the density of settlement. Physical changes in street patterns caused by highway construction, new development, and so forth, may require boundary revisions. In addition, census tracts occasionally are split due to population growth, or combined as a result of substantial population decline. Census tract boundaries generally follow visible and identifiable features. They may follow legal boundaries such as minor civil division (MCD) or incorporated place boundaries in some States and situations to allow for census tract-to-governmental unit relationships where the governmental boundaries tend to remain unchanged between censuses. State and county boundaries always are census tract boundaries in the standard census geographic hierarchy. In a few rare instances, a census tract may consist of noncontiguous areas. These noncontiguous areas may occur where the census tracts are coextensive with all or parts of legal entities that are themselves noncontiguous. For the 2020 Census, the census tract code range of 9400 through 9499 was enforced for census tracts that include a majority American Indian population according to Census 2010 data and/or their area was primarily covered by federally recognized American Indian reservations and/or off-reservation trust lands; the code range 9800 through 9899 was enforced for those census tracts that contained little or no population and represented a relatively large special land use area such as a National Park, military installation, or a business/industrial park; and the code range 9900 through 9998 was enforced for those census tracts that contained only water area.
Organization: District of Columbia
Last updated: 2024-04-30T19:06:02.322619
Tags: 1-percent-public-use-microdata-area-code, 106th-congressional-district-code, 108th-congressional-district-code, 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, boundaries, census, census-bureau, 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, income, legislative-session-year, metropolitan-statistical-area-consolidated-metropolitan-statistical-area-fips-code, new-england-county-metropolitan-area-fips-code, people, population, primary-metropolitan-statistical-area-fips-code, 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, tabulation-block-number, tribal-subdivision-code, u-s, unified-school-district-local-education-agency-code, urban-growth-area-code, voting-district-code, washington-dc

Tables

Table 1

@usgov.district_of_columbia_census_tracts_in_2020.table_1

275.92 KB
206 rows
315 columns


CREATE TABLE table_1 (
  "tract" BIGINT,
  "geoid" BIGINT,
  "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,
  "shapearea" BIGINT,
  "shapelen" BIGINT,
  "aland" BIGINT,
  "awater" BIGINT,
  "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,
  "p0010063" BIGINT
);