el_wa

INSERT INTO `australian_postcode` (`election_id`, `postcode`, `constituency`) VALUES
(4, 872, 'Pilbara'),
(4, 872, 'Kalgoorlie'),
(4, 6000, 'Perth'),
(4, 6003, 'Perth'),
(4, 6004, 'Perth'),
(4, 6004, 'Mount Lawley'),
(4, 6005, 'Perth'),
(4, 6006, 'Perth'),
(4, 6007, 'Perth'),
(4, 6007, 'Churchlands'),
(4, 6007, 'Nedlands'),
(4, 6008, 'Nedlands'),
(4, 6009, 'Nedlands'),
(4, 6010, 'Nedlands'),
(4, 6010, 'Cottesloe'),
(4, 6010, 'Churchlands'),
(4, 6011, 'Cottesloe'),
(4, 6012, 'Cottesloe'),
(4, 6014, 'Nedlands'),
(4, 6014, 'Churchlands'),
(4, 6015, 'Scarborough'),
(4, 6015, 'Churchlands'),
(4, 6016, 'Churchlands'),
(4, 6016, 'Perth'),
(4, 6017, 'Balcatta'),
(4, 6017, 'Scarborough'),
(4, 6018, 'Churchlands'),
(4, 6018, 'Scarborough'),
(4, 6018, 'Carine'),
(4, 6019, 'Scarborough'),
(4, 6019, 'Churchlands'),
(4, 6020, 'Carine'),
(4, 6020, 'Hillarys'),
(4, 6021, 'Balcatta'),
(4, 6022, 'Balcatta'),
(4, 6022, 'Girrawheen'),
(4, 6023, 'Carine'),
(4, 6024, 'Kingsley'),
(4, 6024, 'Girrawheen'),
(4, 6025, 'Joondalup'),
(4, 6025, 'Hillarys'),
(4, 6026, 'Kingsley'),
(4, 6027, 'Joondalup'),
(4, 6027, 'Ocean Reef'),
(4, 6028, 'Ocean Reef'),
(4, 6028, 'Joondalup'),
(4, 6029, 'Carine'),
(4, 6029, 'Scarborough'),
(4, 6030, 'Butler'),
(4, 6030, 'Ocean Reef'),
(4, 6031, 'Butler'),
(4, 6031, 'Wanneroo'),
(4, 6032, 'Butler'),
(4, 6033, 'Butler'),
(4, 6034, 'Butler'),
(4, 6035, 'Butler'),
(4, 6036, 'Butler'),
(4, 6037, 'Butler'),
(4, 6038, 'Butler'),
(4, 6041, 'Moore'),
(4, 6042, 'Moore'),
(4, 6043, 'Moore'),
(4, 6044, 'Moore'),
(4, 6050, 'Mount Lawley'),
(4, 6050, 'Perth'),
(4, 6051, 'Maylands'),
(4, 6052, 'Maylands'),
(4, 6052, 'Mount Lawley'),
(4, 6053, 'Bassendean'),
(4, 6053, 'Maylands'),
(4, 6054, 'Bassendean'),
(4, 6055, 'West Swan'),
(4, 6055, 'Midland'),
(4, 6055, 'Swan Hills'),
(4, 6055, 'Belmont'),
(4, 6056, 'Swan Hills'),
(4, 6056, 'Midland'),
(4, 6057, 'Forrestfield'),
(4, 6057, 'Kalamunda'),
(4, 6058, 'Forrestfield'),
(4, 6058, 'Kalamunda'),
(4, 6059, 'Morley'),
(4, 6059, 'Mount Lawley'),
(4, 6059, 'Mirrabooka'),
(4, 6060, 'Balcatta'),
(4, 6060, 'Mount Lawley'),
(4, 6061, 'Mirrabooka'),
(4, 6061, 'Morley'),
(4, 6062, 'Maylands'),
(4, 6062, 'Bassendean'),
(4, 6062, 'Morley'),
(4, 6062, 'Mount Lawley'),
(4, 6063, 'Bassendean'),
(4, 6063, 'West Swan'),
(4, 6064, 'Mirrabooka'),
(4, 6064, 'Girrawheen'),
(4, 6065, 'Wanneroo'),
(4, 6065, 'Girrawheen'),
(4, 6066, 'Mirrabooka'),
(4, 6066, 'West Swan'),
(4, 6067, 'West Swan'),
(4, 6068, 'West Swan'),
(4, 6069, 'Swan Hills'),
(4, 6069, 'West Swan'),
(4, 6070, 'Kalamunda'),
(4, 6070, 'Midland'),
(4, 6071, 'Swan Hills'),
(4, 6072, 'Swan Hills'),
(4, 6073, 'Swan Hills'),
(4, 6074, 'Swan Hills'),
(4, 6076, 'Darling Range'),
(4, 6076, 'Kalamunda'),
(4, 6076, 'Forrestfield'),
(4, 6077, 'Wanneroo'),
(4, 6078, 'Wanneroo'),
(4, 6078, 'Butler'),
(4, 6079, 'West Swan'),
(4, 6079, 'Swan Hills'),
(4, 6081, 'Swan Hills'),
(4, 6082, 'Swan Hills'),
(4, 6083, 'Swan Hills'),
(4, 6083, 'Moore'),
(4, 6084, 'Swan Hills'),
(4, 6084, 'Moore'),
(4, 6090, 'West Swan'),
(4, 6100, 'Victoria Park'),
(4, 6101, 'Victoria Park'),
(4, 6102, 'Victoria Park'),
(4, 6103, 'Belmont'),
(4, 6104, 'Belmont'),
(4, 6105, 'Belmont'),
(4, 6105, 'Forrestfield'),
(4, 6106, 'Belmont'),
(4, 6106, 'Victoria Park'),
(4, 6107, 'Cannington'),
(4, 6107, 'Forrestfield'),
(4, 6108, 'Cannington'),
(4, 6108, 'Gosnells'),
(4, 6109, 'Forrestfield'),
(4, 6109, 'Kalamunda'),
(4, 6110, 'Gosnells'),
(4, 6110, 'Kalamunda'),
(4, 6110, 'Southern River'),
(4, 6111, 'Armadale'),
(4, 6111, 'Darling Range'),
(4, 6111, 'Kalamunda'),
(4, 6112, 'Armadale'),
(4, 6112, 'Darling Range'),
(4, 6121, 'Darling Range'),
(4, 6122, 'Darling Range'),
(4, 6123, 'Darling Range'),
(4, 6124, 'Darling Range'),
(4, 6125, 'Darling Range'),
(4, 6126, 'Murray-Wellington'),
(4, 6126, 'Darling Range'),
(4, 6147, 'Cannington'),
(4, 6147, 'Riverton'),
(4, 6148, 'Cannington'),
(4, 6148, 'Riverton'),
(4, 6149, 'Bateman'),
(4, 6149, 'Jandakot'),
(4, 6150, 'Bateman'),
(4, 6151, 'South Perth'),
(4, 6151, 'Victoria Park'),
(4, 6152, 'South Perth'),
(4, 6153, 'Alfred Cove'),
(4, 6153, 'Bateman'),
(4, 6154, 'Alfred Cove'),
(4, 6154, 'Bateman'),
(4, 6155, 'Southern River'),
(4, 6155, 'Riverton'),
(4, 6156, 'Alfred Cove'),
(4, 6156, 'Bateman'),
(4, 6156, 'Willagee'),
(4, 6157, 'Alfred Cove'),
(4, 6157, 'Fremantle'),
(4, 6158, 'Fremantle'),
(4, 6159, 'Cottesloe'),
(4, 6160, 'Fremantle'),
(4, 6161, 'Fremantle'),
(4, 6162, 'Fremantle'),
(4, 6163, 'Cockburn'),
(4, 6163, 'Jandakot'),
(4, 6163, 'Willagee'),
(4, 6163, 'Fremantle'),
(4, 6163, 'Bateman'),
(4, 6164, 'Jandakot'),
(4, 6164, 'Cockburn'),
(4, 6165, 'Kwinana'),
(4, 6166, 'Cockburn'),
(4, 6167, 'Kwinana'),
(4, 6168, 'Kwinana'),
(4, 6168, 'Rockingham'),
(4, 6169, 'Rockingham'),
(4, 6169, 'Kwinana'),
(4, 6169, 'Warnbro'),
(4, 6170, 'Kwinana'),
(4, 6171, 'Kwinana'),
(4, 6171, 'Warnbro'),
(4, 6172, 'Warnbro'),
(4, 6173, 'Warnbro'),
(4, 6174, 'Warnbro'),
(4, 6175, 'Warnbro'),
(4, 6176, 'Warnbro'),
(4, 6180, 'Mandurah'),
(4, 6181, 'Murray-Wellington'),
(4, 6207, 'Murray-Wellington'),
(4, 6208, 'Murray-Wellington'),
(4, 6209, 'Mandurah'),
(4, 6210, 'Mandurah'),
(4, 6210, 'Dawesville'),
(4, 6211, 'Dawesville'),
(4, 6213, 'Murray-Wellington'),
(4, 6214, 'Murray-Wellington'),
(4, 6215, 'Murray-Wellington'),
(4, 6218, 'Murray-Wellington'),
(4, 6220, 'Murray-Wellington'),
(4, 6221, 'Murray-Wellington'),
(4, 6223, 'Murray-Wellington'),
(4, 6224, 'Murray-Wellington'),
(4, 6225, 'Collie-Preston'),
(4, 6225, 'Wagin'),
(4, 6225, 'Warren-Blackwood'),
(4, 6226, 'Murray-Wellington'),
(4, 6227, 'Collie-Preston'),
(4, 6228, 'Collie-Preston'),
(4, 6229, 'Bunbury'),
(4, 6229, 'Collie-Preston'),
(4, 6230, 'Bunbury'),
(4, 6230, 'Collie-Preston'),
(4, 6232, 'Collie-Preston'),
(4, 6233, 'Bunbury'),
(4, 6233, 'Murray-Wellington'),
(4, 6236, 'Collie-Preston'),
(4, 6237, 'Collie-Preston'),
(4, 6239, 'Warren-Blackwood'),
(4, 6240, 'Warren-Blackwood'),
(4, 6243, 'Warren-Blackwood'),
(4, 6244, 'Warren-Blackwood'),
(4, 6244, 'Wagin'),
(4, 6251, 'Warren-Blackwood'),
(4, 6252, 'Warren-Blackwood'),
(4, 6253, 'Warren-Blackwood'),
(4, 6254, 'Warren-Blackwood'),
(4, 6255, 'Warren-Blackwood'),
(4, 6256, 'Warren-Blackwood'),
(4, 6258, 'Warren-Blackwood'),
(4, 6260, 'Warren-Blackwood'),
(4, 6262, 'Warren-Blackwood'),
(4, 6271, 'Collie-Preston'),
(4, 6275, 'Warren-Blackwood'),
(4, 6275, 'Vasse'),
(4, 6280, 'Vasse'),
(4, 6280, 'Collie-Preston'),
(4, 6281, 'Vasse'),
(4, 6282, 'Vasse'),
(4, 6284, 'Vasse'),
(4, 6285, 'Vasse'),
(4, 6285, 'Warren-Blackwood'),
(4, 6286, 'Warren-Blackwood'),
(4, 6286, 'Vasse'),
(4, 6288, 'Warren-Blackwood'),
(4, 6290, 'Warren-Blackwood'),
(4, 6302, 'Central Wheatbelt'),
(4, 6304, 'Central Wheatbelt'),
(4, 6306, 'Central Wheatbelt'),
(4, 6308, 'Wagin'),
(4, 6309, 'Wagin'),
(4, 6311, 'Wagin'),
(4, 6312, 'Wagin'),
(4, 6313, 'Wagin'),
(4, 6315, 'Wagin'),
(4, 6316, 'Wagin'),
(4, 6317, 'Wagin'),
(4, 6318, 'Wagin'),
(4, 6320, 'Wagin'),
(4, 6321, 'Wagin'),
(4, 6322, 'Wagin'),
(4, 6323, 'Wagin'),
(4, 6324, 'Wagin'),
(4, 6324, 'Albany'),
(4, 6326, 'Wagin'),
(4, 6327, 'Albany'),
(4, 6328, 'Albany'),
(4, 6330, 'Albany'),
(4, 6333, 'Warren-Blackwood'),
(4, 6335, 'Wagin'),
(4, 6336, 'Wagin'),
(4, 6337, 'Wagin'),
(4, 6338, 'Wagin'),
(4, 6341, 'Wagin'),
(4, 6343, 'Wagin'),
(4, 6346, 'Wagin'),
(4, 6346, 'Eyre'),
(4, 6348, 'Eyre'),
(4, 6350, 'Wagin'),
(4, 6351, 'Wagin'),
(4, 6352, 'Wagin'),
(4, 6353, 'Wagin'),
(4, 6355, 'Wagin'),
(4, 6356, 'Wagin'),
(4, 6357, 'Wagin'),
(4, 6358, 'Central Wheatbelt'),
(4, 6359, 'Central Wheatbelt'),
(4, 6361, 'Wagin'),
(4, 6363, 'Wagin'),
(4, 6365, 'Wagin'),
(4, 6367, 'Central Wheatbelt'),
(4, 6368, 'Central Wheatbelt'),
(4, 6369, 'Central Wheatbelt'),
(4, 6370, 'Wagin'),
(4, 6372, 'Wagin'),
(4, 6373, 'Central Wheatbelt'),
(4, 6375, 'Central Wheatbelt'),
(4, 6383, 'Central Wheatbelt'),
(4, 6384, 'Central Wheatbelt'),
(4, 6385, 'Central Wheatbelt'),
(4, 6386, 'Central Wheatbelt'),
(4, 6390, 'Wagin'),
(4, 6391, 'Wagin'),
(4, 6392, 'Wagin'),
(4, 6393, 'Wagin'),
(4, 6394, 'Wagin'),
(4, 6395, 'Wagin'),
(4, 6396, 'Wagin'),
(4, 6397, 'Wagin'),
(4, 6398, 'Warren-Blackwood'),
(4, 6401, 'Central Wheatbelt'),
(4, 6403, 'Central Wheatbelt'),
(4, 6405, 'Central Wheatbelt'),
(4, 6407, 'Central Wheatbelt'),
(4, 6409, 'Central Wheatbelt'),
(4, 6410, 'Central Wheatbelt'),
(4, 6411, 'Central Wheatbelt'),
(4, 6412, 'Central Wheatbelt'),
(4, 6413, 'Central Wheatbelt'),
(4, 6414, 'Central Wheatbelt'),
(4, 6415, 'Central Wheatbelt'),
(4, 6418, 'Central Wheatbelt'),
(4, 6419, 'Central Wheatbelt'),
(4, 6420, 'Central Wheatbelt'),
(4, 6421, 'Central Wheatbelt'),
(4, 6421, 'Eyre'),
(4, 6422, 'Eyre'),
(4, 6423, 'Eyre'),
(4, 6424, 'Eyre'),
(4, 6425, 'Eyre'),
(4, 6426, 'Eyre'),
(4, 6427, 'Eyre'),
(4, 6428, 'Central Wheatbelt'),
(4, 6429, 'Eyre'),
(4, 6430, 'Eyre'),
(4, 6430, 'Kalgoorlie'),
(4, 6431, 'Kalgoorlie'),
(4, 6431, 'Eyre'),
(4, 6432, 'Eyre'),
(4, 6434, 'Eyre'),
(4, 6434, 'Kalgoorlie'),
(4, 6436, 'Kalgoorlie'),
(4, 6437, 'Kalgoorlie'),
(4, 6438, 'Kalgoorlie'),
(4, 6440, 'Kalgoorlie'),
(4, 6442, 'Eyre'),
(4, 6443, 'Eyre'),
(4, 6445, 'Eyre'),
(4, 6446, 'Eyre'),
(4, 6447, 'Eyre'),
(4, 6448, 'Eyre'),
(4, 6450, 'Eyre'),
(4, 6460, 'Central Wheatbelt'),
(4, 6461, 'Central Wheatbelt'),
(4, 6462, 'Central Wheatbelt'),
(4, 6463, 'Central Wheatbelt'),
(4, 6465, 'Central Wheatbelt'),
(4, 6466, 'Central Wheatbelt'),
(4, 6467, 'Central Wheatbelt'),
(4, 6468, 'Moore'),
(4, 6470, 'Central Wheatbelt'),
(4, 6472, 'Central Wheatbelt'),
(4, 6473, 'Central Wheatbelt'),
(4, 6475, 'Central Wheatbelt'),
(4, 6476, 'Central Wheatbelt'),
(4, 6477, 'Central Wheatbelt'),
(4, 6479, 'Central Wheatbelt'),
(4, 6479, 'Eyre'),
(4, 6480, 'Central Wheatbelt'),
(4, 6484, 'Eyre'),
(4, 6485, 'Central Wheatbelt'),
(4, 6487, 'Central Wheatbelt'),
(4, 6488, 'Central Wheatbelt'),
(4, 6489, 'Central Wheatbelt'),
(4, 6490, 'Central Wheatbelt'),
(4, 6501, 'Moore'),
(4, 6502, 'Moore'),
(4, 6503, 'Moore'),
(4, 6504, 'Moore'),
(4, 6505, 'Moore'),
(4, 6506, 'Moore'),
(4, 6507, 'Moore'),
(4, 6509, 'Moore'),
(4, 6510, 'Moore'),
(4, 6511, 'Moore'),
(4, 6512, 'Moore'),
(4, 6513, 'Moore'),
(4, 6514, 'Moore'),
(4, 6515, 'Moore'),
(4, 6516, 'Moore'),
(4, 6517, 'Moore'),
(4, 6518, 'Moore'),
(4, 6519, 'Moore'),
(4, 6521, 'Moore'),
(4, 6522, 'Moore'),
(4, 6525, 'Moore'),
(4, 6528, 'Geraldton'),
(4, 6530, 'Geraldton'),
(4, 6530, 'Moore'),
(4, 6532, 'Moore'),
(4, 6532, 'North West Central'),
(4, 6532, 'Geraldton'),
(4, 6535, 'Moore'),
(4, 6536, 'Moore'),
(4, 6537, 'North West Central'),
(4, 6556, 'Swan Hills'),
(4, 6558, 'Swan Hills'),
(4, 6560, 'Central Wheatbelt'),
(4, 6562, 'Central Wheatbelt'),
(4, 6564, 'Central Wheatbelt'),
(4, 6566, 'Moore'),
(4, 6566, 'Central Wheatbelt'),
(4, 6567, 'Moore'),
(4, 6568, 'Moore'),
(4, 6569, 'Moore'),
(4, 6571, 'Moore'),
(4, 6572, 'Moore'),
(4, 6574, 'Moore'),
(4, 6575, 'Moore'),
(4, 6603, 'Central Wheatbelt'),
(4, 6605, 'Central Wheatbelt'),
(4, 6606, 'Central Wheatbelt'),
(4, 6608, 'Moore'),
(4, 6609, 'Moore'),
(4, 6612, 'Moore'),
(4, 6612, 'North West Central'),
(4, 6613, 'Moore'),
(4, 6614, 'Moore'),
(4, 6616, 'Moore'),
(4, 6620, 'Moore'),
(4, 6623, 'Moore'),
(4, 6625, 'Moore'),
(4, 6627, 'Moore'),
(4, 6628, 'Moore'),
(4, 6630, 'Moore'),
(4, 6630, 'North West Central'),
(4, 6631, 'Moore'),
(4, 6632, 'Moore'),
(4, 6635, 'North West Central'),
(4, 6638, 'North West Central'),
(4, 6639, 'North West Central'),
(4, 6640, 'North West Central'),
(4, 6642, 'North West Central'),
(4, 6646, 'North West Central'),
(4, 6701, 'North West Central'),
(4, 6705, 'North West Central'),
(4, 6707, 'North West Central'),
(4, 6710, 'North West Central'),
(4, 6712, 'North West Central'),
(4, 6713, 'Pilbara'),
(4, 6714, 'Pilbara'),
(4, 6716, 'North West Central'),
(4, 6718, 'Pilbara'),
(4, 6720, 'Pilbara'),
(4, 6721, 'Pilbara'),
(4, 6722, 'Pilbara'),
(4, 6725, 'Kimberley'),
(4, 6726, 'Kimberley'),
(4, 6728, 'Kimberley'),
(4, 6740, 'Kimberley'),
(4, 6743, 'Kimberley'),
(4, 6751, 'North West Central'),
(4, 6753, 'Pilbara'),
(4, 6754, 'North West Central'),
(4, 6758, 'Pilbara'),
(4, 6760, 'Pilbara'),
(4, 6762, 'Pilbara'),
(4, 6765, 'Kimberley'),
(4, 6770, 'Kimberley');

INSERT INTO `category` (`category_id`, `name`, `description`, `default_value`) VALUES
(14, 'Justice', NULL, NULL),
(15, 'Sustainability', NULL, NULL),
(16, 'Democracy', NULL, NULL),
(17, 'Social Justice', NULL, NULL),
(17, 'Regional Development', NULL, NULL);

INSERT INTO `category_election` (`category_election_id`, `category_id`, `election_id`) VALUES
(37, 1, 4),
(38, 4, 4),
(39, 5, 4),
(40, 6, 4),
(41, 8, 4),
(42, 10, 4),
(43, 11, 4),
(44, 12, 4),
(45, 13, 4),
(46, 14, 4),
(47, 15, 4),
(48, 16, 4),
(49, 17, 4),
(50, 18, 4);

INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Albany',7,'WA','albany');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Alfred Cove',7,'WA','alfred_cove');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Armadale',7,'WA','armadale');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Balcatta',7,'WA','balcatta');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Bassendean',7,'WA','bassendean');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Bateman',7,'WA','bateman');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Belmont',7,'WA','belmont');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Blackwood-Stirling',7,'WA','blackwood-stirling');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Bunbury',7,'WA','bunbury');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Cannington',7,'WA','cannington');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Carine',7,'WA','carine');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Central Wheatbelt',7,'WA','central_wheatbelt');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Churchlands',7,'WA','churchlands');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Cockburn',7,'WA','cockburn');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Collie-Preston',7,'WA','collie-preston');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Cottesloe',7,'WA','cottesloe');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Darling Range',7,'WA','darling_range');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Dawesville',7,'WA','dawesville');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Eyre',7,'WA','eyre');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Forrestfield',7,'WA','forrestfield');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Fremantle',7,'WA','fremantle');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Geraldton',7,'WA','geraldton');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Girrawheen',7,'WA','girrawheen');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Gosnells',7,'WA','gosnells');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Hillarys',7,'WA','hillarys');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Jandakot',7,'WA','jandakot');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Joondalup',7,'WA','joondalup');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Kalamunda',7,'WA','kalamunda');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Kalgoorlie',7,'WA','kalgoorlie');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Kimberley',7,'WA','kimberley');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Kingsley',7,'WA','kingsley');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Kwinana',7,'WA','kwinana');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Mandurah',7,'WA','mandurah');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Maylands',7,'WA','maylands');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Midland',7,'WA','midland');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Mindarie',7,'WA','mindarie');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Moore',7,'WA','moore');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Morley',7,'WA','morley');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Mount Lawley',7,'WA','mount_lawley');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Murray-Wellington',7,'WA','murray-wellington');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Nedlands',7,'WA','nedlands');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Nollamara',7,'WA','nollamara');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('North West',7,'WA','north_west');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Ocean Reef',7,'WA','ocean_reef');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Perth',7,'WA','perth');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Pilbara',7,'WA','pilbara');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Riverton',7,'WA','riverton');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Rockingham',7,'WA','rockingham');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Scarborough',7,'WA','scarborough');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('South Perth',7,'WA','south_perth');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Southern River',7,'WA','southern_river');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Swan Hills',7,'WA','swan_hills');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Vasse',7,'WA','vasse');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Victoria Park',7,'WA','victoria_park');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Wagin',7,'WA','wagin');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Wanneroo',7,'WA','wanneroo');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Warnbro',7,'WA','warnbro');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('West Swan',7,'WA','west_swan');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Willagee',7,'WA','willagee');

INSERT INTO `constituency_type` VALUES (7,'WA Electoral Division',13,'wa');

INSERT INTO `constituency_election` (constituency_id, election_id) SELECT constituency_id, 4 FROM constituency WHERE constituency_type_id=7;

INSERT INTO `election` VALUES (4,'WA State Election 2013',1,'2013-03-09');

INSERT INTO `party` VALUES (38, 'Australian Christians', 13, NULL, NULL, 'australian_christians', NULL, NULL);

INSERT INTO `party_election` VALUES
(52,4,38),
(53,4,22),
(54,4,14),
(55,4,18),
(56,4,4),
(57,4,13),
(58,4,12),
(59,4,21);