Código PHP:
INSERT INTO `ps_state` (`id_state`, `id_country`, `id_zone`, `name`, `iso_code`, `tax_behavior`, `active`) VALUES
(143, '17', '8', 'Aberdeen City', 'ACY', '0', '1'),
(144, '17', '8', 'Aberdeenshire', 'ABE', '0', '1'),
(145, '17', '8', 'Angus', 'ANG', '0', '1'),
(146, '17', '8', 'Antrim', 'ANT', '0', '1'),
(147, '17', '8', 'Ards', 'ARD', '0', '1'),
(148, '17', '8', 'Argyll and Bute', 'AGB', '0', '1'),
(149, '17', '8', 'Armagh', 'ARM', '0', '1'),
(150, '17', '8', 'Avon', 'AVN', '0', '1'),
(151, '17', '8', 'Ballymena', 'BLY', '0', '1'),
(152, '17', '8', 'Ballymoney', 'BLL', '0', '1'),
(153, '17', '8', 'Banbridge', 'BAN', '0', '1'),
(154, '17', '8', 'Barking and Dagenham', 'BDM', '0', '1'),
(155, '17', '8', 'Barnet', 'BNT', '0', '1'),
(156, '17', '8', 'Barnsley', 'BAR', '0', '1'),
(157, '17', '8', 'Bath and North East Somerset', 'SOM', '0', '1'),
(158, '17', '8', 'Bedfordshire', 'BED', '0', '1'),
(159, '17', '8', 'Belfast', 'BEL', '0', '1'),
(160, '17', '8', 'Berkshire', 'BKS', '0', '1'),
(161, '17', '8', 'Bexley', 'BEX', '0', '1'),
(162, '17', '8', 'Birmingham', 'BRG', '0', '1'),
(163, '17', '8', 'Blackburn with Darwen', 'BDW', '0', '1'),
(164, '17', '8', 'Blackpool', 'BPO', '0', '1'),
(165, '17', '8', 'Blaenau Gwent', 'GWE', '0', '1'),
(166, '17', '8', 'Bolton', 'BOL', '0', '1'),
(167, '17', '8', 'Bournemouth', 'BMT', '0', '1'),
(168, '17', '8', 'Bracknell Forest', 'BKF', '0', '1'),
(169, '17', '8', 'Bradford', 'BRF', '0', '1'),
(170, '17', '8', 'Brent', 'BRE', '0', '1'),
(171, '17', '8', 'Bridgend', 'BRI', '0', '1'),
(172, '17', '8', 'Brighton and Hove', 'BAH', '0', '1'),
(173, '17', '8', 'Bristol, City of', 'COB', '0', '1'),
(174, '17', '8', 'Bromley', 'BRO', '0', '1'),
(175, '17', '8', 'Buckinghamshire', 'BUC', '0', '1'),
(176, '17', '8', 'Bury', 'BUR', '0', '1'),
(177, '17', '8', 'Caerphilly', 'CAE', '0', '1'),
(178, '17', '8', 'Calderdale', 'CAL', '0', '1'),
(179, '17', '8', 'Cambridgeshire', 'CMB', '0', '1'),
(180, '17', '8', 'Camden', 'CAM', '0', '1'),
(181, '17', '8', 'Cardiff', 'CAF', '0', '1'),
(182, '17', '8', 'Carmarthenshire', 'CAR', '0', '1'),
(183, '17', '8', 'Carrickfergus', 'CRR', '0', '1'),
(184, '17', '8', 'Castlereagh', 'CAT', '0', '1'),
(185, '17', '8', 'Central', 'CEN', '0', '1'),
(186, '17', '8', 'Ceredigion', 'CER', '0', '1'),
(187, '17', '8', 'Cheshire', 'CHE', '0', '1'),
(188, '17', '8', 'Clackmannanshire', 'CLA', '0', '1'),
(189, '17', '8', 'Cleveland', 'CLV', '0', '1'),
(190, '17', '8', 'Clwyd', 'CLW', '0', '1'),
(191, '17', '8', 'Coleraine', 'COL', '0', '1'),
(192, '17', '8', 'Conwy', 'CON', '0', '1'),
(193, '17', '8', 'Cookstown', 'COO', '0', '1'),
(194, '17', '8', 'Cornwall', 'COR', '0', '1'),
(195, '17', '8', 'Coventry', 'CON', '0', '1'),
(196, '17', '8', 'Craigavon', 'CRI', '0', '1'),
(197, '17', '8', 'Croydon', 'CRO', '0', '1'),
(198, '17', '8', 'Cumbria', 'CUM', '0', '1'),
(199, '17', '8', 'Darlington', 'DAR', '0', '1'),
(200, '17', '8', 'Denbighshire', 'DEG', '0', '1'),
(201, '17', '8', 'Derby', 'DRB', '0', '1'),
(202, '17', '8', 'Derbyshire', 'DSH', '0', '1'),
(203, '17', '8', 'Derry', 'DRR', '0', '1'),
(204, '17', '8', 'Devon', 'DVN', '0', '1'),
(205, '17', '8', 'Doncaster', 'DOC', '0', '1'),
(206, '17', '8', 'Dorset', 'DOR', '0', '1'),
(207, '17', '8', 'Down', 'DON', '0', '1'),
(208, '17', '8', 'Dudley', 'DUD', '0', '1'),
(209, '17', '8', 'Dumfries and Galloway', 'GAL', '0', '1'),
(210, '17', '8', 'Dundee City', 'DND', '0', '1'),
(211, '17', '8', 'Dungannon', 'DNG', '0', '1'),
(212, '17', '8', 'Durham', 'DUR', '0', '1'),
(213, '17', '8', 'Dyfed', 'DYE', '0', '1'),
(214, '17', '8', 'Ealing', 'EAL', '0', '1'),
(215, '17', '8', 'East Ayrshire', 'AYS', '0', '1'),
(216, '17', '8', 'East Dunbartonshire', 'DUN', '0', '1'),
(217, '17', '8', 'East Renfrewshire', 'REN', '0', '1'),
(218, '17', '8', 'East Riding of Yorkshire', 'RYK', '0', '1'),
(219, '17', '8', 'East Sussex', 'SUS', '0', '1'),
(220, '17', '8', 'Edinburgh, City of', 'EDN', '0', '1'),
(221, '17', '8', 'Eilean Siar', 'EIL', '0', '1'),
(222, '17', '8', 'Enfield', 'ENF', '0', '1'),
(223, '17', '8', 'Essex', 'ESK', '0', '1'),
(224, '17', '8', 'Falkirk', 'FLK', '0', '1'),
(225, '17', '8', 'Fermanagh', 'FER', '0', '1'),
(266, '17', '8', 'Fife', 'FIF', '0', '1'),
(267, '17', '8', 'Flintshire', 'FLI', '0', '1'),
(268, '17', '8', 'Gateshead', 'GAT', '0', '1'),
(269, '17', '8', 'Glasgow City', 'GCY', '0', '1'),
(270, '17', '8', 'Gloucestershire', 'GLO', '0', '1'),
(271, '17', '8', 'Grampian', 'GRM', '0', '1'),
(272, '17', '8', 'Greater London', 'LND', '0', '1'),
(272, '17', '8', 'Greater Manchester', 'MAC', '0', '1'),
(273, '17', '8', 'Greenwich', 'GRE', '0', '1'),
(274, '17', '8', 'Gwent', 'GWN', '0', '1',
(275, '17', '8', 'Gwynedd', 'GWY', '0', '1'),
(276, '17', '8', 'Hackney', 'HAC', '0', '1'),
(277, '17', '8', 'Halton', 'HAL', '0', '1'),
(278, '17', '8', 'Hammersmith and Fulham', 'HAF', '0', '1'),
(279, '17', '8', 'Hampshire', 'HAP', '0', '1'),
(280, '17', '8', 'Haringey', 'HAR', '0', '1'),
(281, '17', '8', 'Harrow', 'HAR', '0', '1'),
(282, '17', '8', 'Hartlepool', 'HTL'),
(283, '17', '8', 'Havering', 'HAV', '0', '1'),
(284, '17', '8', 'Hereford and Worcester', 'HAW', '0', '1'),
(285, '17', '8', 'Herefordshire', 'HSH', '0', '1'),
(286, '17', '8', 'Hertford', 'HER', '0', '1'),
(287, '17', '8', 'Highland', 'HIG', '0', '1'),
(288, '17', '8', 'Hillingdon', 'HIL', '0', '1'),
(289, '17', '8', 'Hounslow', 'HOS', '0', '1'),
(290, '17', '8', 'Humberside', 'HUM', '0', '1'),
(291, '17', '8', 'Inverclyde', 'INV', '0', '1'),
(292, '17', '8', 'Isle of Anglesey', 'ISL', '0', '1'),
(293, '17', '8', 'Isle of Wight', 'WIG', '0', '1'),
(294, '17', '8', 'Islington', 'ISL', '0', '1'),
(295, '17', '8', 'Kensington and Chelsea', 'CHL', '0', '1'),
(296, '17', '8', 'Kent', 'KNT', '0', '1'),
(297, '17', '8', 'Kingston upon Hull, City of', 'HCY', '0', '1'),
(298, '17', '8', 'Kingston upon Thames', 'KUT', '0', '1'),
(299, '17', '8', 'Kirklees', 'KIR', '0', '1'),
(300, '17', '8', 'Knowsley', 'KNO', '0', '1'),
(301, '17', '8', 'Lambeth', 'LAM', '0', '1'),
(302, '17', '8', 'Lancashire', 'LAN', '0', '1'),
(303, '17', '8', 'Larne', 'LAR', '0', '1'),
(304, '17', '8', 'Leeds', 'LED', '0', '1'),
(305, '17', '8', 'Leicester', 'LEI', '0', '1'),
(306, '17', '8', 'Leicestershire', 'LIC', '0', '1'),
(307, '17', '8', 'Lewisham', 'LWS', '0', '1'),
(308, '17', '8', 'Limavady', 'LIM', '0', '1'),
(309, '17', '8', 'Lincolnshire', 'LSH', '0', '1'),
(310, '17', '8', 'Lisburn', 'LSB', '0', '1'),