Free developer dataset

US States Database

Download all 50 US states with names, postal abbreviations, capitals, population, area, and admission dates. Built for seed data, demos, spreadsheets, prototypes, and quick app setup.

50
States included
6
Fields per row
4
File formats

Download the Dataset

CSV / JSON / SQL / XML

CSV

Comma-separated values for spreadsheets, import jobs, Airtable-style tools, or quick data checks.

text/csv · 50 rows

JSON

Readable structured data for JavaScript apps, API prototypes, static sites, and local fixtures.

application/json · pretty printed

SQL

Table creation and insert statements for quickly seeding a relational database with state data.

SQL seed file · us_states

XML

Simple XML for older integrations, structured exports, internal tooling, or data exchange tests.

application/xml · states root

What's Included

Developer-friendly fields

Identity fields

Every row includes the full state name and two-letter postal abbreviation, ready for forms, filters, and dropdown menus.

Reference data

Capital city, population, and area in square miles are included for quick dashboards, examples, and geographic comparisons.

History field

The state admission date is formatted as ISO-style date text, which keeps sorting and parsing simple across formats.

US States Database FAQ

Quick answers
What formats are available?

You can download the US states database as CSV, JSON, SQL, or XML directly from this page.

What fields are included?

Each state includes name, abbreviation, capital, population, area in square miles, and admission date.

What is this useful for?

It works well for seed data, prototypes, tutorials, sample dashboards, state dropdowns, and test databases.