Canada Gazetteer

Canada Gazetteer (Cities) Database by Provinces (Place Names)

Data Structure

city [2,966]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
bigint(20) unsigned
+ province_id (100%)
province [13]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)

Description

Database tables and lists of Canada local place names including 13 provinces and 2,966 cities and towns.

Data Profile

Size 592K
Tables 2
Last Commit 2016-08-30 05:56:27

Updates / Commits

Time Size Tables Columns Rows
2016-08-30 05:56:27 592K 2 8 2979

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 2,966 .001 2.966
province 13 .001 0.013
Total Credits 2.979 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.