US Gazetteer

United States Place Names of Counties and Local Towns / Cities / Settlements

Data Structure

county [3,141]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
bigint(20) unsigned
+ state_id (100%)
place [175,195]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
bigint(20) unsigned
+ county_id (100%)
state [50]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)

Description

This is the complete United States gazetteer (cities) database created from the official records released by federal government. Table county contains all census designated places (areas) with more than 25,000 population, any town, neighborhood or community (Populated Places) under this criterion but have an official federally recognized name is included as a unique entry in the place table.

Data Profile

Size 16.36M
Tables 3
Last Commit 2016-08-31 03:08:18

Updates / Commits

Time Size Tables Columns Rows
2016-08-31 03:08:18 16.36M 3 14 178386

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
county 3,141 .001 3.141
place 175,195 .001 175.195
state 50 .001 0.05
Total Credits 178.386 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.