What formats are available for the US states database?

The dataset can be downloaded as CSV, JSON, SQL, or XML directly from the page.

What fields are included in the states dataset?

Each state record includes the state name, two-letter abbreviation, capital, population, area in square miles, and admission date.

Can developers use this dataset in apps and prototypes?

Yes. The downloads are designed for developer projects, database seed files, prototypes, demos, and spreadsheet analysis.

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.

Download formats See fields

States included

Fields per row

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.