Address Database 2023

Self-hosted address autocomplete suggestions

New Version!

Click here for the latest version. More addresses, better quality, Canada included!

 

A SQLite database file with over 130 million U.S. address records. Indexed for very fast queries, even on slow hardware. Sourced from government datasets and cleaned up with a variety of tools.

Columns

  • id INTEGER
  • zipcode CHAR(5)
  • number VARCHAR(30)
  • street VARCHAR(200)
  • street2 VARCHAR(40)
  • city VARCHAR(50)
  • state CHAR(2)

Download

File is approx. 14 GB uncompressed (4 GB zipped). Click here for a small sample to test with if you’re not sure about grabbing all that data.

Processing and hosting all that data costs money and time. Pay what you think is fair, or pay nothing if you want. It’s up to you.

$10 $20 $30 $

SHA256: 89152798543ebdd5fadf8a6a4cc47d835985e96531260fb3872581f9e4796580 addressdb_autocomplete.sqlite.zip

Need Latitude and Longitude?

There is also a version of the database with latitude and longitude columns for every address.

You can choose which file to download (or get both) after purchasing above.

SHA256: eafe385373e8fbc812e233d045af6c1df61b323c3f19070da63d8bf70948bebc addressdb_geo.sqlite.zip

Sources

Data is from the National Address Database version 14 for all states with complete coverage. The remainder is from the OpenAddresses project, which collects and standardizes various government address datasets. Data was processed and sanitized with several scripts. Problematic addresses were cleaned up with the U.S. Census geocoder.