TIGER/Line
MySQL Dumps
MySQL Dumps of TIGER/Line 2024 data from the U.S. Census Bureau. This data was imported and processed first and then dumped to a .sql file that is compressed with gzip. This data is originally provided by the U.S. Census Bureau (Public Domain) and this database is a derivative work licensed under the GeoCat Download License.
Data may be directly imported into an existing or new MySQL database and used from there.
As this is a huge database (110Gb after importing), it has been split by table. You'll want to click any of the filename links below to download each table that you need. You can then decompress and import them into your MySQL database. For decompression of gzip files on Windows, we suggest using 7-Zip, which is lightweight, free, doesn't contain ads or popups, and works for all compression/archive formats.
All SHA256 checksums are here: SHA256SUM
ADDR
Download: 584MiB
Imported: 2.6GiB
ADDRFEAT
Download: 2.5GiB
Imported: 6.7GiB
ADDRFN
Download: 306MiB
Imported: 1.6GiB
AIANNH
Download: 9.1MiB
Imported: 18.5MiB
AITSN
Download: 6.1MiB
Imported: 13.5MiB
ANRC
Download: 736KiB
Imported: 1.5MiB
AREALM
Download: 68MiB
Imported: 131.1MiB
AREAWATER
Download: 1.1GiB
Imported: 2.1GiB
BG
Download: 699MiB
Imported: 1.4GiB
CBSA
Download: 35MiB
Imported: 60.5MiB
CD
Download: 41MiB
Imported: 65.5MiB
COASTLINE
Download: 17MiB
Imported: 31.6MiB
CONCITY
Download: 240KiB
Imported: 432KiB
COUNTY
Download: 83MiB
Imported: 152.6MiB
COUSUB
Download: 303MiB
Imported: 605.2MiB
CSA
Download: 13MiB
Imported: 21.5MiB
EDGES
Download: 11GiB
Imported: 23.7GiB
ELSD
Download: 14MiB
Imported: 33.6MiB
ESTATE
Download: 656KiB
Imported: 1.5MiB
FACES
Download: 9.7GiB
Imported: 23GiB
FACESAH
Download: 25MiB
Imported: 154.7MiB
FACESAL
Download: 3.6MiB
Imported: 25.2MiB
FACESMIL
Download: 812KiB
Imported: 7.5MiB
FEATNAMES
Download: 934MiB
Imported: 5.9GiB
INTL. BOUNDARY
Download: 800KiB
Imported: 1.6MiB
LINEARWATER
Download: 3.1GiB
Imported: 5.7GiB
METDIV
Download: 2.5MiB
Imported: 4.5MiB
MIL
Download: 3MiB
Imported: 6.5MiB
PLACE
Download: 143MiB
Imported: 291.1MiB
POINTLM
Download: 27MiB
Imported: 112.2MiB
PRIMARYROADS
Download: 38MiB
Imported: 76.8MiB
PRISECROADS
Download: 288MiB
Imported: 594.5MiB
PUMA20
Download: 73MiB
Imported: 129.6MiB
RAILS
Download: 32MiB
Imported: 64.1MiB
ROADS
Download: 3.8GiB
Imported: 7.4GiB
SCSD
Download: 7.2MiB
Imported: 16.5MiB
SDADM
Download: 456KiB
Imported: 1.5MiB
SLDL
Download: 123MiB
Imported: 221.6MiB
SLDU
Download: 84MiB
Imported: 143.6MiB
STATE
Download: 9.9MiB
Imported: 15.5MiB
SUBBARRIO
Download: 128KiB
Imported: 288KiB
TABBLOCK20
Download: 6.1GiB
Imported: 12.3GiB
TABBLOCKSUFX
Download: 6.3GiB
Imported: 12.4GiB
TBG
Download: 11MiB
Imported: 22.5MiB
TRACT
Download: 417MiB
Imported: 864.3MiB
TTRACT
Download: 7.7MiB
Imported: 16.5MiB
UAC20
Download: 73MiB
Imported: 129.6MiB
UNSD
Download: 151MiB
Imported: 298.7MiB
ZCTA520
Download: 522MiB
Imported: 1GiB