Skip to main content
Use the SQL Server .sql export with SQL Server Management Studio or sqlcmd. It is a script, not a .bak backup.
These instructions use v5.2.0-export.1, published 3 November 2026. Its core tables contain 250 countries, 5,327 states and 156,169 city records. API data and installed package snapshots can differ. Check the latest release before choosing another version.

Download the release

Run these POSIX-shell commands in a new directory. Downloads are compressed; extract them before opening or importing.

Import into a new database

Create a new, empty database before importing. The example uses Windows integrated authentication (-E); select authentication appropriate to your installation.
In SSMS, create csc_world, open the extracted script in a query window connected to that database, and execute it. The release creates a schema named world inside the selected database. Its table names are world.countries, world.states and world.cities.

Verify the import

The pinned release lists 250 countries, 5,327 states and 156,169 city records. Inspect the imported schema when using another release.

Query the hierarchy

Troubleshooting

  • An invalid-object error can mean you omitted the world. schema prefix.
  • Use the SQL Server export; MySQL and PostgreSQL dumps use different syntax.
  • Back up existing databases before replacing data. Restore failed imports into a new database after investigating the error.
See the SQL Server documentation and sqlcmd documentation for authentication, supported versions, backups and tuning. Review the schema reference and preserve applicable data notices.