Street list of United States in Excel, SQL, CSV or XML

Some companies or ambitious projects need geographical data and require a list of the streets of the communes in United States. In order to help these large projects, listreet has prepared a database listing 1 796 000 streets, spread over 17 500 cities in United States.

List of streets in United States

This type of database provides a list of streets for many types of projects. To help developers better understand the possibilities, here is a short list of possible applications of the database:


  • Form entry.
  • Development of applications requiring the use of postal data.
  • Pre-fill in the street name more easily in a form requesting a postal address.
  • Verify the correctness of an address entered by a user.
  • Generate the postal address of a profile, based on real data.
  • For an application that already has postal addresses, this database of addresses makes it easier to cross-reference the data and to group buildings, establishments or customers more easily, based on their postal addresses.
  • Make various statistics to know the number of "square" or "driveway" for each commune in United States. Same if they wish to know the number of street of "Main Street" in United States.

Did you know: in United States there are 6264 streets / avenues / places / driveways / boulevards... associated with the name of "Main Street"!

Table data

The database contains 4 tables with data that complement each other: streets, municipalities, departments and the nature of the roads.

Table of streets in United States:


  • Iso: country code (INSEE code)
  • Country: country wording
  • Region: name of the regio
  • Commune name: full name of the commune
  • Postal code: postal code
  • Street: full street name, with type of lane
  • Latitude: GPS coordinates
  • Longitude: GPS coordinates
  • Elevation: GPS coordinates

Table of communes in United States


  • Iso: country code (INSEE code)
  • Country: country wording
  • Region: name of the region
  • Commune name: full name of the commune
  • Postal code: postal code

Take note: for a more complete list, please use the more complete list of communes in United States. The INSEE code is used as a reference to link the data together.


Table of departments in United States:


  • Iso: country code (INSEE code)
  • country: country wording
  • Region 1: main region
  • Region 2: secondary region
  • Region 3: Tertiary region
  • Region 4: regional sub-division

Extract from the database

To assess what the data looks like and what can be contained in such a list, you can download an excerpt with a small database of the 100 streets in United States.


Download the list of street names in United States

Or

Download the database of all cities in United States

Take note:


  • The list contains 1 796 000 streets, spread over 17 500 towns and cities in United States.
  • Every week, streets are added, modified or deleted, therefore the list cannot be guaranteed to be 100% accurate.

Buy

If you are interested in the list of all the streets in United States, make a purchase directly on this site.

Make good use of these tables and don't hesitate to share the creations you could have created from this database.

You need other information, such as the nature of the lanes or INSEE, nuts or wire codes for statistical studies. It is available on request. Contact us.