2023 Updated dataset of Popular US Cities with State abbreviation and full state name. CSV/SQL Format

Latest 2023 Updated dataset of Popular US Cities with State abbreviation and full state name. Available in CSV/SQL Format.

I collected (from the US census), filtered, and sorted cities' names of the US and provided it in CSV, SQL format for your Programmatic SEO Projects.

All cities have a minimum of 20k population.

I ran a Keywords search volume test for popular categories like Plumbers in City + State Abbr variations for all 1600+ cities in the database and got an average of 332 search volume.

It will help you in working with keywords with search volume instead of bulk publishing thousands of no-volume keywords of cities where there are few people living.