Qipudata
San Francisco · v0.7.1
qipu data›San Francisco›Datasets›x_census_tract

Census tracts, 1980–2020

x_census_tractrelease v0.7.1CC0 1.0

About

One census tract in one census year (1980-2020): 100% counts of people, households and homes, plus sample/ACS foreign-born and median household income. Public domain, US Census Bureau. Not from the Internet Archive.

How far to trust it
The release passed its automatic checks before it was published (what is checked). A hand check by the editor of qipu data is under way: 36 of 38 items checked so far were right, on votes, money, places and the map. A row says what the record states; the scanned page is the authority. Details
Licence
CC0 1.0: use it for anything, no permission needed. The scans and other sources keep their own rights.
Version
v0.7.1, published 21 October 2026. A published release is never changed; corrections come as a new release.
Technical details
Table
x_census_tract
Rows
925
Columns
23
Parquet
x_census_tract.parquet, < 0.1 MB
Version
v0.7.1, 21 October 2026
Licence
CC0 1.0. Sources keep their own rights.

Rows

Rows by source_label

ValueRowsShare
US Census 2020 (DHC) and ACS 2016-2020 (tract)24426.4%
US Census 2010 (SF1) and ACS 2006-2010 (tract)19721.3%
US Census 2000, Summary Files 1 and 3 (tract)17619.0%
US Census 1980, Summary Tape Files 1A and 3A (tract)15616.9%
US Census 1990, Summary Tape Files 1A and 3A (tract)15216.4%

Method and accuracy

No accuracy measure for this table yet.

The release passed its automatic checks before it was published (what is checked). A hand check by the editor of qipu data is under way: 36 of 38 items checked so far were right, on votes, money, places and the map. A row says what the record states; the scanned page is the authority.

Methodology · Accuracy

Columns 23

ColumnTypeCan be emptyPrivacyPublic copyDescription
yearINTEGERyesnoneas isCensus year.
Can be empty yes · Privacy none · Public copy as is
boundary_vintageINTEGERyesnoneas isWhich tract map the code belongs to (1990 map for 1980 and 1990).
Can be empty yes · Privacy none · Public copy as is
tractVARCHARyesnoneas isSix-digit census tract code (e.g. 016300 = tract 163).
Can be empty yes · Privacy none · Public copy as is
tract_nameVARCHARyesnoneas isTract as printed (163, 101.01).
Can be empty yes · Privacy none · Public copy as is
popINTEGERyesnoneas isPersons.
Can be empty yes · Privacy none · Public copy as is
householdsINTEGERyesnoneas isHouseholds (occupied homes).
Can be empty yes · Privacy none · Public copy as is
unitsINTEGERyesnoneas isHousing units.
Can be empty yes · Privacy none · Public copy as is
occupiedINTEGERyesnoneas isOccupied housing units.
Can be empty yes · Privacy none · Public copy as is
vacantINTEGERyesnoneas isVacant housing units.
Can be empty yes · Privacy none · Public copy as is
ownersINTEGERyesnoneas isOwner-occupied homes.
Can be empty yes · Privacy none · Public copy as is
rentersINTEGERyesnoneas isRenter-occupied homes.
Can be empty yes · Privacy none · Public copy as is
under18INTEGERyesnoneas isPersons under 18.
Can be empty yes · Privacy none · Public copy as is
over65INTEGERyesnoneas isPersons 65 and over.
Can be empty yes · Privacy none · Public copy as is
hispanicINTEGERyesnoneas isPersons of Hispanic/Latino (1980: Spanish) origin, any race.
Can be empty yes · Privacy none · Public copy as is
white_nhINTEGERyesnoneas isWhite alone, not Hispanic (1990+).
Can be empty yes · Privacy none · Public copy as is
white_raceINTEGERyesnoneas isWhite by race incl. Hispanic (1980 only).
Can be empty yes · Privacy none · Public copy as is
blackINTEGERyesnoneas isBlack (1980 and 1990: by race, any origin; 2000+: Black alone, not Hispanic).
Can be empty yes · Privacy none · Public copy as is
asianINTEGERyesnoneas isAsian and Pacific Islander (1980 and 1990: by race, any origin; 2000+: alone, not Hispanic).
Can be empty yes · Privacy none · Public copy as is
foreign_bornINTEGERyesnoneas isForeign-born persons (sample: STF3 / SF3 / ACS 5-year).
Can be empty yes · Privacy none · Public copy as is
median_incomeINTEGERyesnoneas isMedian household income in the year before the census, dollars of that year (2010/2020: ACS 5-year).
Can be empty yes · Privacy none · Public copy as is
median_income_2024usdDOUBLEyesnoneas isThe same in 2024 dollars (CPI-U).
Can be empty yes · Privacy none · Public copy as is
source_labelVARCHARyescatalogue textas isSource tables.
Values US Census 1980, Summary Tape Files 1A and 3A (tract), US Census 1990, Summary Tape Files 1A and 3A (tract), US Census 2000, Summary Files 1 and 3 (tract), US Census 2010 (SF1) and ACS 2006-2010 (tract), US Census 2020 (DHC) and ACS 2016-2020 (tract)
Can be empty yes · Privacy catalogue text · Public copy as is
source_urlVARCHARyescatalogue textas isSource file or data.census.gov table for the tract.
Can be empty yes · Privacy catalogue text · Public copy as is

Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.

Preview

yearboundary_vintagetracttract_namepophouseholdsunitsoccupied
19801,9900253002533,7801,5351,6101,535
19801,99002600026013,1684,3434,4954,343
19801,9900353003536,1432,2972,3612,297
19901,9900402004025,3402,3412,4742,341
20002,0000209002095,0921,7621,8131,762
20102,0100130001304,0442,4092,6782,409
20202,020031302313.025,6731,8151,8931,815
20202,020060701607.018,6103,5383,8433,538

8 of 23 columns shown. Eight rows sampled at build time. Hover a shortened value for all of it.

Download

FormatFileSize
Parquetx_census_tract.parquet ↗< 0.1 MB
SQLite (all tables)qipu_sf.db ↗6.44 GB

SQL

SELECT * FROM x_census_tract LIMIT 100

Run in the SQL console (DuckDB in the browser, over the Parquet file).

Python

import duckdb duckdb.sql("SELECT * FROM 'https://tiles.qipu.org/data/releases/v0.7.1/parquet/x_census_tract.parquet' LIMIT 5").show()