Download list of provinces for Canada in CSV, JSON, HTML, SQL and XML
List of provinces: HTML - Select Control
----------------------------
Alpha-2 code + Alpha-2 code
----------------------------
<select>
<option value="AB">AB</option>
<option value="BC">BC</option>
<option value="MB">MB</option>
<option value="NB">NB</option>
<option value="NL">NL</option>
<option value="NS">NS</option>
<option value="NT">NT</option>
<option value="NU">NU</option>
<option value="ON">ON</option>
<option value="PE">PE</option>
<option value="QC">QC</option>
<option value="SK">SK</option>
<option value="YT">YT</option>
</select>
------------------------------
Alpha-2 code + name - English
------------------------------
<select>
<option value="AB">Alberta</option>
<option value="BC">British Columbia</option>
<option value="MB">Manitoba</option>
<option value="NB">New Brunswick</option>
<option value="NL">Newfoundland and Labrador</option>
<option value="NS">Nova Scotia</option>
<option value="NT">Northwest Territories</option>
<option value="NU">Nunavut</option>
<option value="ON">Ontario</option>
<option value="PE">Prince Edward Island</option>
<option value="QC">Quebec</option>
<option value="SK">Saskatchewan</option>
<option value="YT">Yukon</option>
</select>
------------------------------
Alpha-2 code + name - French
------------------------------
<select>
<option value="AB">Alberta</option>
<option value="BC">Colombie-Britannique</option>
<option value="PE">Île-du-Price-Édouard</option>
<option value="MB">Manitoba</option>
<option value="NB">Nouveau-Brunswick</option>
<option value="NS">Nouvelle-Écosse</option>
<option value="NU">Nunavut</option>
<option value="ON">Ontario</option>
<option value="QC">Québec</option>
<option value="SK">Saskatchewan</option>
<option value="NL">Terre-Neuve-et-Labrador</option>
<option value="NT">Territoires du Nord-Ouest</option>
<option value="YT">Territoire du Yukon</option>
</select>
---------------------------------
ISO_3166-2 code + name - English
---------------------------------
<select>
<option value="CA-AB">Alberta</option>
<option value="CA-BC">British Columbia</option>
<option value="CA-MB">Manitoba</option>
<option value="CA-NB">New Brunswick</option>
<option value="CA-NL">Newfoundland and Labrador</option>
<option value="CA-NS">Nova Scotia</option>
<option value="CA-NT">Northwest Territories</option>
<option value="CA-NU">Nunavut</option>
<option value="CA-ON">Ontario</option>
<option value="CA-PE">Prince Edward Island</option>
<option value="CA-QC">Quebec</option>
<option value="CA-SK">Saskatchewan</option>
<option value="CA-YT">Yukon</option>
</select>
---------------------------------
ISO_3166-2 code + name - French
---------------------------------
<select>
<option value="CA-AB">Alberta</option>
<option value="CA-BC">Colombie-Britannique</option>
<option value="CA-PE">Île-du-Price-Édouard</option>
<option value="CA-MB">Manitoba</option>
<option value="CA-NB">Nouveau-Brunswick</option>
<option value="CA-NS">Nouvelle-Écosse</option>
<option value="CA-NU">Nunavut</option>
<option value="CA-ON">Ontario</option>
<option value="CA-QC">Québec</option>
<option value="CA-SK">Saskatchewan</option>
<option value="CA-NL">Terre-Neuve-et-Labrador</option>
<option value="CA-NT">Territoires du Nord-Ouest</option>
<option value="CA-YT">Territoire du Yukon</option>
</select>
List of provinces: CSV
// Provinces/Territories - English //
CA-AB,"Alberta"
CA-BC,"British Columbia"
CA-MB,"Manitoba"
CA-NB,"New Brunswick"
CA-NL,"Newfoundland and Labrador"
CA-NS,"Nova Scotia"
CA-NT,"Northwest Territories"
CA-NU,"Nunavut"
CA-ON,"Ontario"
CA-PE,"Prince Edward Island"
CA-QC,"Quebec"
CA-SK,"Saskatchewan"
CA-YT,"Yukon"
// Provinces/Territories - French //
CA-AB,"Alberta"
CA-BC,"Colombie-Britannique"
CA-PE,"Île-du-Price-Édouard"
CA-MB,"Manitoba"
CA-NB,"Nouveau-Brunswick"
CA-NE,"Nouvelle-Écosse"
CA-NU,"Nunavut"
CA-ON,"Ontario"
CA-QC,"Québec"
CA-SK,"Saskatchewan"
CA-NL,"Terre-Neuve-et-Labrador"
CA-NT,"Territoires du Nord-Ouest"
CA-YT,"Territoire du Yukon"
List of provinces: JSON
-------------------------------
Alpha-2 code + Name - English
-------------------------------
[
{code: "AB", name: "Alberta"},
{code: "BC", name: "British Columbia"},
{code: "MB", name: "Manitoba"},
{code: "NB", name: "New Brunswick"},
{code: "NL", name: "Newfoundland and Labrador"},
{code: "NS", name: "Nova Scotia"},
{code: "NT", name: "Northwest Territories"},
{code: "NU", name: "Nunavut"},
{code: "ON", name: "Ontario"},
{code: "PE", name: "Prince Edward Island"},
{code: "QC", name: "Quebec"},
{code: "SK", name: "Saskatchewan"},
{code: "YT", name: "Yukon"}
]
-------------------------------
Alpha-2 code + Name - French
-------------------------------
[
{code: "AB", name: "Alberta"},
{code: "BC", name: "Colombie-Britannique"},
{code: "MB", name: "Manitoba"},
{code: "NB", name: "Nouveau-Brunswick"},
{code: "NL", name: "Terre-Neuve-et-Labrador"},
{code: "NS", name: "Nouvelle-Écosse"},
{code: "NT", name: "Territoires du Nord-Ouest"},
{code: "NU", name: "Nunavut"},
{code: "ON", name: "Ontario"},
{code: "PE", name: "Île-du-Price-Édouard"},
{code: "QC", name: "Québec"},
{code: "SK", name: "Saskatchewan"},
{code: "YT", name: "Territoire du Yukon"}
]
----------------------------------
ISO-3166-2 code + Name - English
----------------------------------
[
{code: "CA-AB", name: "Alberta"},
{code: "CA-BC", name: "British Columbia"},
{code: "CA-MB", name: "Manitoba"},
{code: "CA-NB", name: "New Brunswick"},
{code: "CA-NL", name: "Newfoundland and Labrador"},
{code: "CA-NS", name: "Nova Scotia"},
{code: "CA-NT", name: "Northwest Territories"},
{code: "CA-NU", name: "Nunavut"},
{code: "CA-ON", name: "Ontario"},
{code: "CA-PE", name: "Prince Edward Island"},
{code: "CA-QC", name: "Quebec"},
{code: "CA-SK", name: "Saskatchewan"},
{code: "CA-YT", name: "Yukon"}
]
----------------------------------
ISO-3166-2 code + Name - French
----------------------------------
[
{code: "CA-AB", name: "Alberta"},
{code: "CA-BC", name: "Colombie-Britannique"},
{code: "CA-MB", name: "Manitoba"},
{code: "CA-NB", name: "Nouveau-Brunswick"},
{code: "CA-NL", name: "Terre-Neuve-et-Labrador"},
{code: "CA-NS", name: "Nouvelle-Écosse"},
{code: "CA-NT", name: "Territoires du Nord-Ouest"},
{code: "CA-NU", name: "Nunavut"},
{code: "CA-ON", name: "Ontario"},
{code: "CA-PE", name: "Île-du-Price-Édouard"},
{code: "CA-QC", name: "Québec"},
{code: "CA-SK", name: "Saskatchewan"},
{code: "CA-YT", name: "Territoire du Yukon"}
]
List of provinces: SQL
-- -----------------------------------------------------
-- Table `province`
-- -----------------------------------------------------
DROP TABLE IF EXISTS province;
CREATE TABLE IF NOT EXISTS province (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
code VARCHAR(6) NOT NULL,
name_en VARCHAR(50) NOT NULL,
name_fr VARCHAR(50) NOT NULL,
PRIMARY KEY (id),
UNIQUE INDEX id_UNIQUE (id ASC),
UNIQUE INDEX code_UNIQUE (code ASC)
) ENGINE = InnoDB;
---------------------
Alpha-2 code + name
---------------------
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'AB', 'Alberta', 'Alberta');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'BC', 'British Columbia', 'Colombie-Britannique');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'MB', 'Manitoba', 'Manitoba');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'NB', 'New Brunswick', 'Nouveau-Brunswick');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'NL', 'Newfoundland and Labrador', 'Terre-Neuve-et-Labrador');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'NS', 'Nova Scotia', 'Nouvelle-Écosse');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'NT', 'Northwest Territories', 'Territoires du Nord-Ouest');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'NU', 'Nunavut', 'Nunavut');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'ON', 'Ontario', 'Ontario');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'PE', 'Prince Edward Island', 'Île-du-Price-Édouard');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'QC', 'Quebec', 'Québec');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'SK', 'Saskatchewan', 'Saskatchewan');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'YT', 'Yukon', 'Territoire du Yukon');
------------------------
ISO-3166-2 code + name
------------------------
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'CA-AB', 'Alberta', 'Alberta');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'CA-BC', 'British Columbia', 'Colombie-Britannique');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'CA-MB', 'Manitoba', 'Manitoba');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'CA-NB', 'New Brunswick', 'Nouveau-Brunswick');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'CA-NL', 'Newfoundland and Labrador', 'Terre-Neuve-et-Labrador');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'CA-NS', 'Nova Scotia', 'Nouvelle-Écosse');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'CA-NT', 'Northwest Territories', 'Territoires du Nord-Ouest');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'CA-NU', 'Nunavut', 'Nunavut');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'CA-ON', 'Ontario', 'Ontario');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'CA-PE', 'Prince Edward Island', 'Île-du-Price-Édouard');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'CA-QC', 'Quebec', 'Québec');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'CA-SK', 'Saskatchewan', 'Saskatchewan');
INSERT INTO province (id, code, name_en, name_fr) VALUES (null, 'CA-YT', 'Yukon', 'Territoire du Yukon');
List of provinces: XML
<!-- Alpha-2 code + name - English -->
<?xml version="1.0" encoding="UTF-8"?>
<provinces>
<province>
<code>AB</code>
<name>Alberta</name>
</province>
<province>
<code>BC</code>
<name>British Columbia</name>
</province>
<province>
<code>MB</code>
<name>Manitoba</name>
</province>
<province>
<code>NB</code>
<name>New Brunswick</name>
</province>
<province>
<code>NL</code>
<name>Newfoundland and Labrador</name>
</province>
<province>
<code>NS</code>
<name>Nova Scotia</name>
</province>
<province>
<code>NT</code>
<name>Northwest Territories</name>
</province>
<province>
<code>NU</code>
<name>Nunavut</name>
</province>
<province>
<code>ON</code>
<name>Ontario</name>
</province>
<province>
<code>PE</code>
<name>Prince Edward Island</name>
</province>
<province>
<code>QC</code>
<name>Quebec</name>
</province>
<province>
<code>SK</code>
<name>Saskatchewan</name>
</province>
<province>
<code>YT</code>
<name>Yukon</name>
</province>
</provinces>
<!-- Alpha-2 code + name - French -->
<?xml version="1.0" encoding="UTF-8"?>
<provinces>
<province>
<code>AB</code>
<name>Alberta</name>
</province>
<province>
<code>BC</code>
<name>Colombie-Britannique</name>
</province>
<province>
<code>MB</code>
<name>Manitoba</name>
</province>
<province>
<code>NB</code>
<name>Nouveau-Brunswick</name>
</province>
<province>
<code>NL</code>
<name>Terre-Neuve-et-Labrador</name>
</province>
<province>
<code>NS</code>
<name>Nouvelle-Écosse</name>
</province>
<province>
<code>NT</code>
<name>Territoires du Nord-Ouest</name>
</province>
<province>
<code>NU</code>
<name>Nunavut</name>
</province>
<province>
<code>ON</code>
<name>Ontario</name>
</province>
<province>
<code>PE</code>
<name>Île-du-Price-Édouard</name>
</province>
<province>
<code>QC</code>
<name>Québec</name>
</province>
<province>
<code>SK</code>
<name>Saskatchewan</name>
</province>
<province>
<code>YT</code>
<name>Territoire du Yukon</name>
</province>
</provinces>
<!-- ISO 3166-2 code + name - English -->
<?xml version="1.0" encoding="UTF-8"?>
<provinces>
<province>
<code>CA-AB</code>
<name>Alberta</name>
</province>
<province>
<code>CA-BC</code>
<name>British Columbia</name>
</province>
<province>
<code>CA-MB</code>
<name>Manitoba</name>
</province>
<province>
<code>CA-NB</code>
<name>New Brunswick</name>
</province>
<province>
<code>CA-NL</code>
<name>Newfoundland and Labrador</name>
</province>
<province>
<code>CA-NS</code>
<name>Nova Scotia</name>
</province>
<province>
<code>CA-NT</code>
<name>Northwest Territories</name>
</province>
<province>
<code>CA-NU</code>
<name>Nunavut</name>
</province>
<province>
<code>CA-ON</code>
<name>Ontario</name>
</province>
<province>
<code>CA-PE</code>
<name>Prince Edward Island</name>
</province>
<province>
<code>CA-QC</code>
<name>Quebec</name>
</province>
<province>
<code>CA-SK</code>
<name>Saskatchewan</name>
</province>
<province>
<code>CA-YT</code>
<name>Yukon</name>
</province>
</provinces>
<!-- ISO 3166-2 code + name - French -->
<?xml version="1.0" encoding="UTF-8"?>
<provinces>
<province>
<code>CA-AB</code>
<name>Alberta</name>
</province>
<province>
<code>CA-BC</code>
<name>Colombie-Britannique</name>
</province>
<province>
<code>CA-MB</code>
<name>Manitoba</name>
</province>
<province>
<code>CA-NB</code>
<name>Nouveau-Brunswick</name>
</province>
<province>
<code>CA-NL</code>
<name>Terre-Neuve-et-Labrador</name>
</province>
<province>
<code>CA-NS</code>
<name>Nouvelle-Écosse</name>
</province>
<province>
<code>CA-NT</code>
<name>Territoires du Nord-Ouest</name>
</province>
<province>
<code>CA-NU</code>
<name>Nunavut</name>
</province>
<province>
<code>CA-ON</code>
<name>Ontario</name>
</province>
<province>
<code>CA-PE</code>
<name>Île-du-Price-Édouard</name>
</province>
<province>
<code>CA-QC</code>
<name>Québec</name>
</province>
<province>
<code>CA-SK</code>
<name>Saskatchewan</name>
</province>
<province>
<code>CA-YT</code>
<name>Territoire du Yukon</name>
</province>
</provinces>