Canada Postal Codes

Canadian Postal Codes (Cities / Towns / Places)

Data Structure

place [765,344]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
char(7)
+ postal_code (100%)
varchar(40)
+ city (100%)
varchar(255)
+ province_code (100%)
bigint(20) unsigned
+ province_id (100%)
varchar(255)
+ city_type (100%)
varchar(255)
+ latitude (100%)
varchar(255)
+ longitude (100%)
province [13]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ code (100%)

Description

This database contains 764,852 unique postal codes of Canada across 13 provinces and territories. Each postal code record consists of the city / town name, province / territory (name and abbreviation code), city type, latitude and longitude. List of Canada provinces and territories in this database: Alberta, British Columbia, Manitoba, New Brunswick, Newfoundland, Nova Scotia, Northwest Territories, Nunavut, Ontario, Prince Edward Island, Quebec, Saskatchewan and Yukon Territory.

Data Profile

Size 179.41M
Tables 2
Last Commit 2016-08-30 05:58:24

Updates / Commits

Time Size Tables Columns Rows
2016-08-30 05:58:24 179.41M 2 13 765357

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
place 765,344 .001 765.344
province 13 .001 0.013
Total Credits 765.357 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.