henare/el_qld.sql

## el_qld.sql
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Albert',6,'QLD','albert');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Charters Towers',6,'QLD','charters_towers');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Hinchinbrook',6,'QLD','hinchinbrook');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Mount Coot-tha',6,'QLD','mount_coot-tha');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('South Brisbane',6,'QLD','south_brisbane');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Algester',6,'QLD','algester');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Chatsworth',6,'QLD','chatsworth');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Inala',6,'QLD','inala');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Mount Gravatt',6,'QLD','mount_gravatt');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Southern Downs',6,'QLD','southern_downs');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Ashgrove',6,'QLD','ashgrove');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Clayfield',6,'QLD','clayfield');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Indooroopilly',6,'QLD','indooroopilly');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Mount Isa',6,'QLD','mount_isa');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Southport',6,'QLD','southport');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Aspley',6,'QLD','aspley');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Cleveland',6,'QLD','cleveland');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Ipswich',6,'QLD','ipswich');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Mount Ommaney',6,'QLD','mount_ommaney');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Springwood',6,'QLD','springwood');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Barron River',6,'QLD','barron_river');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Cook',6,'QLD','cook');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Ipswich West',6,'QLD','ipswich_west');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Mudgeeraba',6,'QLD','mudgeeraba');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Stafford',6,'QLD','stafford');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Beaudesert',6,'QLD','beaudesert');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Cunningham',6,'QLD','cunningham');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Kallangur',6,'QLD','kallangur');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Mulgrave',6,'QLD','mulgrave');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Stretton',6,'QLD','stretton');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Brisbane Central',6,'QLD','brisbane_central');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Currumbin',6,'QLD','currumbin');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Kawana',6,'QLD','kawana');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Mundingburra',6,'QLD','mundingburra');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Surfers Paradise',6,'QLD','surfers_paradise');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Broadwater',6,'QLD','broadwater');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Darling Downs',6,'QLD','darling_downs');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Keppel',6,'QLD','keppel');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Murrumba',6,'QLD','murrumba');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Tablelands',6,'QLD','tablelands');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Bulimba',6,'QLD','bulimba');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Everton ',6,'QLD','everton');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Kurwongbah',6,'QLD','kurwongbah');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Nanango',6,'QLD','nanango');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Thuringowa',6,'QLD','thuringowa');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Bundaberg',6,'QLD','bundaberg');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Ferny Grove',6,'QLD','ferny_grove');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Lockyer',6,'QLD','lockyer');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Nicklin',6,'QLD','nicklin');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Toowoomba North',6,'QLD','toowoomba_north');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Bundamba',6,'QLD','bundamba');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Fitzroy',6,'QLD','fitzroy');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Logan',6,'QLD','logan');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Noosa ',6,'QLD','noosa');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Toowoomba South',6,'QLD','toowoomba_south');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Burdekin',6,'QLD','burdekin');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Gaven',6,'QLD','gaven');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Lytton',6,'QLD','lytton');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Nudgee',6,'QLD','nudgee');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Townsville',6,'QLD','townsville');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Burleigh',6,'QLD','burleigh');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Gladstone',6,'QLD','gladstone');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Mackay',6,'QLD','mackay');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Pumicestone',6,'QLD','pumicestone');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Warrego',6,'QLD','warrego');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Burnett',6,'QLD','burnett');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Glass House',6,'QLD','glass_house');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Mansfield',6,'QLD','mansfield');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Redcliffe',6,'QLD','redcliffe');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Waterford',6,'QLD','waterford');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Cairns',6,'QLD','cairns');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Greenslopes',6,'QLD','greenslopes');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Maroochydore',6,'QLD','maroochydore');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Redlands',6,'QLD','redlands');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Whitsunday',6,'QLD','whitsunday');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Callide',6,'QLD','callide');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Gregory',6,'QLD','gregory');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Maryborough',6,'QLD','maryborough');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Robina',6,'QLD','robina');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Woodridge',6,'QLD','woodridge');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Caloundra',6,'QLD','caloundra');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Gympie',6,'QLD','gympie');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Mirani',6,'QLD','mirani');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Rockhampton',6,'QLD','rockhampton');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Yeerongpilly',6,'QLD','yeerongpilly');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Capalaba',6,'QLD','capalaba');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Hervey Bay',6,'QLD','hervey_bay');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Moggill',6,'QLD','moggill');
INSERT INTO constituency (name,constituency_type_id,area_code,url_id) VALUES ('Sandgate',6,'QLD','sandgate');

INSERT INTO `australian_postcode` (`election_id`, `postcode`, `constituency`) VALUES
(3, '4000', 'Brisbane Central'),
(3, '4005', 'Brisbane Central'),
(3, '4006', 'Brisbane Central'),
(3, '4007', 'Clayfield'),
(3, '4008', 'Clayfield'),
(3, '4009', 'Clayfield'),
(3, '4010', 'Clayfield'),
(3, '4011', 'Clayfield'),
(3, '4012', 'Clayfield'),
(3, '4013', 'Nudgee'),
(3, '4014', 'Nudgee'),
(3, '4017', 'Sandgate'),
(3, '4018', 'Sandgate'),
(3, '4019', 'Redcliffe'),
(3, '4020', 'Redcliffe'),
(3, '4021', 'Redcliffe'),
(3, '4022', 'Murrumba'),
(3, '4025', 'Redcliffe'),
(3, '4030', 'Brisbane Central'),
(3, '4031', 'Stafford'),
(3, '4032', 'Stafford'),
(3, '4034', 'Nudgee'),
(3, '4035', 'Everton'),
(3, '4036', 'Sandgate'),
(3, '4037', 'Everton'),
(3, '4051', 'Ashgrove'),
(3, '4053', 'Everton'),
(3, '4054', 'Ferny Grove'),
(3, '4055', 'Ferny Grove'),
(3, '4059', 'Mount Coot-tha'),
(3, '4060', 'Ashgrove'),
(3, '4061', 'Ashgrove'),
(3, '4064', 'Mount Coot-tha'),
(3, '4065', 'Mount Coot-tha'),
(3, '4066', 'Mount Coot-tha'),
(3, '4067', 'Indooroopilly'),
(3, '4068', 'Indooroopilly'),
(3, '4069', 'Moggill'),
(3, '4070', 'Moggill'),
(3, '4072', 'Indooroopilly'),
(3, '4073', 'Mount Ommaney'),
(3, '4074', 'Mount Ommaney'),
(3, '4075', 'Mount Ommaney'),
(3, '4076', 'Inala'),
(3, '4077', 'Inala'),
(3, '4078', 'Inala'),
(3, '4101', 'South Brisbane'),
(3, '4102', 'South Brisbane'),
(3, '4103', 'Yeerongpilly'),
(3, '4104', 'Yeerongpilly'),
(3, '4105', 'Yeerongpilly'),
(3, '4106', 'Yeerongpilly'),
(3, '4107', 'Yeerongpilly'),
(3, '4108', 'Sunnybank'),
(3, '4109', 'Sunnybank'),
(3, '4110', 'Algester'),
(3, '4111', 'Yeerongpilly'),
(3, '4112', 'Stretton'),
(3, '4113', 'Sunnybank'),
(3, '4114', 'Woodridge'),
(3, '4115', 'Algester'),
(3, '4116', 'Stretton'),
(3, '4117', 'Stretton'),
(3, '4118', 'Logan'),
(3, '4119', 'Woodridge'),
(3, '4120', 'South Brisbane'),
(3, '4121', 'Yeerongpilly'),
(3, '4122', 'Mansfield'),
(3, '4123', 'Mansfield'),
(3, '4124', 'Lockyer'),
(3, '4125', 'Logan'),
(3, '4127', 'Springwood'),
(3, '4128', 'Springwood'),
(3, '4129', 'Waterford'),
(3, '4130', 'Redlands'),
(3, '4131', 'Waterford'),
(3, '4132', 'Woodridge'),
(3, '4133', 'Logan'),
(3, '4151', 'Greenslopes'),
(3, '4152', 'Chatsworth'),
(3, '4153', 'Chatsworth'),
(3, '4154', 'Chatsworth'),
(3, '4155', 'Chatsworth'),
(3, '4156', 'Mansfield'),
(3, '4157', 'Redlands'),
(3, '4158', 'Capalaba'),
(3, '4159', 'Capalaba'),
(3, '4160', 'Cleveland'),
(3, '4161', 'Capalaba'),
(3, '4163', 'Cleveland'),
(3, '4164', 'Redlands'),
(3, '4165', 'Redlands'),
(3, '4169', 'South Brisbane'),
(3, '4170', 'Bulimba'),
(3, '4171', 'Bulimba'),
(3, '4172', 'Bulimba'),
(3, '4173', 'Chatsworth'),
(3, '4174', 'Lytton'),
(3, '4178', 'Lytton'),
(3, '4179', 'Lytton'),
(3, '4183', 'Cleveland'),
(3, '4184', 'Redlands'),
(3, '4205', 'Waterford'),
(3, '4207', 'Albert'),
(3, '4208', 'Coomera'),
(3, '4209', 'Coomera'),
(3, '4210', 'Gaven'),
(3, '4211', 'Beaudesert'),
(3, '4212', 'Coomera'),
(3, '4213', 'Mudgeeraba'),
(3, '4214', 'Southport'),
(3, '4215', 'Southport'),
(3, '4216', 'Broadwater'),
(3, '4217', 'Surfers Paradise'),
(3, '4218', 'Mermaid Beach'),
(3, '4220', 'Burleigh'),
(3, '4221', 'Currumbin'),
(3, '4223', 'Currumbin'),
(3, '4224', 'Currumbin'),
(3, '4225', 'Currumbin'),
(3, '4226', 'Mermaid Beach'),
(3, '4227', 'Mudgeeraba'),
(3, '4228', 'Currumbin'),
(3, '4270', 'Beaudesert'),
(3, '4271', 'Beaudesert'),
(3, '4272', 'Beaudesert'),
(3, '4275', 'Beaudesert'),
(3, '4280', 'Logan'),
(3, '4285', 'Beaudesert'),
(3, '4287', 'Beaudesert'),
(3, '4300', 'Bundamba'),
(3, '4301', 'Bundamba'),
(3, '4303', 'Bundamba'),
(3, '4304', 'Bundamba'),
(3, '4305', 'Ipswich'),
(3, '4306', 'Nanango'),
(3, '4307', 'Beaudesert'),
(3, '4309', 'Beaudesert'),
(3, '4310', 'Beaudesert'),
(3, '4311', 'Nanango'),
(3, '4312', 'Nanango'),
(3, '4313', 'Nanango'),
(3, '4340', 'Lockyer'),
(3, '4341', 'Lockyer'),
(3, '4342', 'Lockyer'),
(3, '4343', 'Lockyer'),
(3, '4344', 'Lockyer'),
(3, '4346', 'Ipswich West'),
(3, '4347', 'Gregory'),
(3, '4350', 'Condamine'),
(3, '4352', 'Southern Downs'),
(3, '4353', 'Nanango'),
(3, '4354', 'Nanango'),
(3, '4355', 'Nanango'),
(3, '4356', 'Condamine'),
(3, '4357', 'Southern Downs'),
(3, '4358', 'Condamine'),
(3, '4359', 'Condamine'),
(3, '4360', 'Condamine'),
(3, '4361', 'Condamine'),
(3, '4362', 'Southern Downs'),
(3, '4363', 'Condamine'),
(3, '4364', 'Condamine'),
(3, '4365', 'Southern Downs'),
(3, '4370', 'Southern Downs'),
(3, '4371', 'Southern Downs'),
(3, '4372', 'Southern Downs'),
(3, '4373', 'Southern Downs'),
(3, '4374', 'Southern Downs'),
(3, '4375', 'Southern Downs'),
(3, '4376', 'Southern Downs'),
(3, '4377', 'Southern Downs'),
(3, '4378', 'Southern Downs'),
(3, '4380', 'Southern Downs'),
(3, '4381', 'Southern Downs'),
(3, '4382', 'Southern Downs'),
(3, '4383', 'Southern Downs'),
(3, '4384', 'Southern Downs'),
(3, '4387', 'Southern Downs'),
(3, '4388', 'Southern Downs'),
(3, '4390', 'Southern Downs'),
(3, '4400', 'Condamine'),
(3, '4401', 'Nanango'),
(3, '4402', 'Nanango'),
(3, '4403', 'Condamine'),
(3, '4404', 'Condamine'),
(3, '4405', 'Warrego'),
(3, '4406', 'Warrego'),
(3, '4407', 'Southern Downs'),
(3, '4408', 'Condamine'),
(3, '4410', 'Nanango'),
(3, '4411', 'Warrego'),
(3, '4412', 'Warrego'),
(3, '4413', 'Warrego'),
(3, '4415', 'Warrego'),
(3, '4416', 'Warrego'),
(3, '4417', 'Warrego'),
(3, '4418', 'Callide'),
(3, '4419', 'Callide'),
(3, '4420', 'Callide'),
(3, '4421', 'Warrego'),
(3, '4422', 'Warrego'),
(3, '4423', 'Warrego'),
(3, '4424', 'Warrego'),
(3, '4425', 'Warrego'),
(3, '4426', 'Callide'),
(3, '4427', 'Callide'),
(3, '4428', 'Warrego'),
(3, '4454', 'Warrego'),
(3, '4455', 'Warrego'),
(3, '4461', 'Warrego'),
(3, '4462', 'Warrego'),
(3, '4465', 'Warrego'),
(3, '4467', 'Warrego'),
(3, '4468', 'Warrego'),
(3, '4470', 'Warrego'),
(3, '4472', 'Gregory'),
(3, '4474', 'Gregory'),
(3, '4477', 'Warrego'),
(3, '4478', 'Gregory'),
(3, '4479', 'Warrego'),
(3, '4480', 'Gregory'),
(3, '4481', 'Gregory'),
(3, '4482', 'Mount Isa'),
(3, '4486', 'Warrego'),
(3, '4487', 'Warrego'),
(3, '4488', 'Warrego'),
(3, '4489', 'Warrego'),
(3, '4490', 'Warrego'),
(3, '4491', 'Warrego'),
(3, '4492', 'Warrego'),
(3, '4493', 'Warrego'),
(3, '4494', 'Southern Downs'),
(3, '4496', 'Southern Downs'),
(3, '4497', 'Warrego'),
(3, '4498', 'Southern Downs'),
(3, '4500', 'Pine Rivers'),
(3, '4501', 'Kallangur'),
(3, '4502', 'Kallangur'),
(3, '4503', 'Kallangur'),
(3, '4504', 'Morayfield'),
(3, '4505', 'Murrumba'),
(3, '4506', 'Morayfield'),
(3, '4507', 'Pumicestone'),
(3, '4508', 'Murrumba'),
(3, '4509', 'Murrumba'),
(3, '4510', 'Pumicestone'),
(3, '4511', 'Pumicestone'),
(3, '4512', 'Glass House'),
(3, '4514', 'Glass House'),
(3, '4515', 'Nanango'),
(3, '4516', 'Glass House'),
(3, '4517', 'Glass House'),
(3, '4518', 'Glass House'),
(3, '4519', 'Glass House'),
(3, '4520', 'Ferny Grove'),
(3, '4521', 'Pine Rivers'),
(3, '4550', 'Caloundra'),
(3, '4551', 'Caloundra'),
(3, '4552', 'Glass House'),
(3, '4553', 'Caloundra'),
(3, '4554', 'Glass House'),
(3, '4555', 'Glass House'),
(3, '4556', 'Buderim'),
(3, '4557', 'Buderim'),
(3, '4558', 'Maroochydore'),
(3, '4559', 'Nicklin'),
(3, '4560', 'Nicklin'),
(3, '4561', 'Nicklin'),
(3, '4562', 'Nicklin'),
(3, '4563', 'Nicklin'),
(3, '4564', 'Maroochydore'),
(3, '4565', 'Gympie'),
(3, '4566', 'Noosa'),
(3, '4567', 'Noosa'),
(3, '4568', 'Gympie'),
(3, '4569', 'Gympie'),
(3, '4570', 'Callide'),
(3, '4571', 'Noosa'),
(3, '4572', 'Maroochydore'),
(3, '4573', 'Nicklin'),
(3, '4574', 'Nicklin'),
(3, '4575', 'Kawana'),
(3, '4580', 'Gympie'),
(3, '4581', 'Hervey Bay'),
(3, '4600', 'Callide'),
(3, '4601', 'Callide'),
(3, '4605', 'Callide'),
(3, '4606', 'Callide'),
(3, '4608', 'Callide'),
(3, '4610', 'Nanango'),
(3, '4611', 'Callide'),
(3, '4612', 'Callide'),
(3, '4613', 'Callide'),
(3, '4614', 'Nanango'),
(3, '4615', 'Nanango'),
(3, '4620', 'Maryborough'),
(3, '4621', 'Callide'),
(3, '4625', 'Callide'),
(3, '4627', 'Callide'),
(3, '4627', 'Callide'),
(3, '4650', 'Maryborough'),
(3, '4655', 'Hervey Bay'),
(3, '4659', 'Maryborough'),
(3, '4660', 'Burnett'),
(3, '4662', 'Maryborough'),
(3, '4671', 'Callide'),
(3, '4673', 'Callide'),
(3, '4674', 'Burnett'),
(3, '4676', 'Burnett'),
(3, '4677', 'Burnett'),
(3, '4678', 'Burnett'),
(3, '4680', 'Gladstone'),
(3, '4694', 'Gladstone'),
(3, '4695', 'Gladstone'),
(3, '4697', 'Gladstone'),
(3, '4699', 'Mirani'),
(3, '4700', 'Keppel'),
(3, '4701', 'Keppel'),
(3, '4702', 'Gregory'),
(3, '4703', 'Keppel'),
(3, '4704', 'Keppel'),
(3, '4705', 'Mirani'),
(3, '4706', 'Mirani'),
(3, '4707', 'Mirani'),
(3, '4709', 'Gregory'),
(3, '4710', 'Keppel'),
(3, '4711', 'Mirani'),
(3, '4712', 'Gregory'),
(3, '4713', 'Gregory'),
(3, '4714', 'Mirani'),
(3, '4715', 'Callide'),
(3, '4716', 'Callide'),
(3, '4717', 'Gregory'),
(3, '4718', 'Gregory'),
(3, '4719', 'Callide'),
(3, '4720', 'Gregory'),
(3, '4721', 'Gregory'),
(3, '4722', 'Gregory'),
(3, '4723', 'Gregory'),
(3, '4724', 'Gregory'),
(3, '4725', 'Gregory'),
(3, '4726', 'Gregory'),
(3, '4727', 'Gregory'),
(3, '4728', 'Gregory'),
(3, '4730', 'Gregory'),
(3, '4731', 'Gregory'),
(3, '4732', 'Gregory'),
(3, '4733', 'Mount Isa'),
(3, '4735', 'Mount Isa'),
(3, '4736', 'Gregory'),
(3, '4737', 'Mirani'),
(3, '4738', 'Mirani'),
(3, '4739', 'Mirani'),
(3, '4740', 'Mirani'),
(3, '4741', 'Whitsunday'),
(3, '4742', 'Mirani'),
(3, '4743', 'Mirani'),
(3, '4744', 'Dalrymple'),
(3, '4745', 'Mirani'),
(3, '4746', 'Mirani'),
(3, '4750', 'Whitsunday'),
(3, '4751', 'Mirani'),
(3, '4753', 'Mirani'),
(3, '4754', 'Mirani'),
(3, '4756', 'Mirani'),
(3, '4757', 'Mirani'),
(3, '4798', 'Whitsunday'),
(3, '4799', 'Whitsunday'),
(3, '4800', 'Whitsunday'),
(3, '4801', 'Whitsunday'),
(3, '4802', 'Whitsunday'),
(3, '4803', 'Whitsunday'),
(3, '4804', 'Burdekin'),
(3, '4805', 'Burdekin'),
(3, '4806', 'Burdekin'),
(3, '4807', 'Burdekin'),
(3, '4808', 'Burdekin'),
(3, '4809', 'Burdekin'),
(3, '4810', 'Townsville'),
(3, '4811', 'Burdekin'),
(3, '4812', 'Townsville'),
(3, '4813', 'Burdekin'),
(3, '4814', 'Burdekin'),
(3, '4815', 'Burdekin'),
(3, '4816', 'Mount Isa'),
(3, '4817', 'Dalrymple'),
(3, '4818', 'Hinchinbrook'),
(3, '4819', 'Townsville'),
(3, '4820', 'Dalrymple'),
(3, '4821', 'Mount Isa'),
(3, '4822', 'Mount Isa'),
(3, '4823', 'Mount Isa'),
(3, '4824', 'Mount Isa'),
(3, '4825', 'Mount Isa'),
(3, '4828', 'Mount Isa'),
(3, '4829', 'Mount Isa'),
(3, '4830', 'Mount Isa'),
(3, '4849', 'Hinchinbrook'),
(3, '4850', 'Dalrymple'),
(3, '4852', 'Hinchinbrook'),
(3, '4854', 'Hinchinbrook'),
(3, '4855', 'Hinchinbrook'),
(3, '4856', 'Hinchinbrook'),
(3, '4858', 'Hinchinbrook'),
(3, '4859', 'Mulgrave'),
(3, '4860', 'Mulgrave'),
(3, '4861', 'Mulgrave'),
(3, '4865', 'Mulgrave'),
(3, '4868', 'Cairns'),
(3, '4869', 'Mulgrave'),
(3, '4870', 'Cairns'),
(3, '4871', 'Cook'),
(3, '4872', 'Dalrymple'),
(3, '4873', 'Cook'),
(3, '4874', 'Cook'),
(3, '4875', 'Cook'),
(3, '4876', 'Cook'),
(3, '4877', 'Cook'),
(3, '4878', 'Barron River'),
(3, '4879', 'Barron River'),
(3, '4880', 'Cook'),
(3, '4881', 'Barron River'),
(3, '4882', 'Dalrymple'),
(3, '4883', 'Dalrymple'),
(3, '4884', 'Dalrymple'),
(3, '4885', 'Dalrymple'),
(3, '4886', 'Dalrymple'),
(3, '4887', 'Dalrymple'),
(3, '4888', 'Dalrymple'),
(3, '4890', 'Mount Isa'),
(3, '4891', 'Mount Isa'),
(3, '4895', 'Cook');

INSERT INTO `constituency_type` VALUES (6,'QLD Electoral Division',13,'qld');

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

INSERT INTO `election` VALUES (3,'QLD State Election 2012',1,'2012-03-01');

INSERT INTO `party` VALUES
(34, 'Liberal National Party of Queensland', 13, NULL, NULL, 'liberal_national_party_of_queensland', NULL, NULL),
(35, 'Daylight Saving for South East Queensland', 13, NULL, NULL, 'daylight_saving_for_south_east_queensland', NULL, NULL),
(36, 'The Queensland Party', 13, NULL, NULL, 'the_queensland_party', NULL, NULL),
(37, 'Katter\'s Australian Party', 13, NULL, NULL, 'katters_australian_party', NULL, NULL);

INSERT INTO `party_election` VALUES
(44,3,4),
(45,3,12),
(46,3,16),
(47,3,22),
(48,3,34),
(49,3,35),
(50,3,36),
(51,3,37);

INSERT INTO `category_election` (`category_election_id`, `category_id`, `election_id`) VALUES
(25, 1, 3),
(26, 2, 3),
(27, 3, 3),
(28, 4, 3),
(29, 5, 3),
(30, 6, 3),
(31, 7, 3),
(32, 8, 3),
(33, 9, 3),
(34, 10, 3),
(35, 11, 3),
(36, 12, 3);