countries-states-cities-database
countries-states-cities-database copied to clipboard
States from Spain
INSERT INTO `states` (`id`, `name`, `country_id`, `country_code`, `fips_code`, `iso2`, `latitude`, `longitude`, `created_at`, `updated_at`, `flag`, `wikiDataId`) VALUES
(1146, 'Álava', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1147, 'Albacete', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1148, 'Alicante', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1149, 'Almería', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1150, 'Asturias', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1151, 'Ávila', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1152, 'Badajoz', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1153, 'Barcelona', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1154, 'Burgos', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1155, 'Cáceres', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1156, 'Cádiz', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1157, 'Cantabria', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1158, 'Castellón', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1159, 'Ciudad Real', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1160, 'Córdoba', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1161, 'La Coruña', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1162, 'Cuenca', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1163, 'Gerona', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1164, 'Granada', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1165, 'Guadalajara', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1166, 'Guipúzcoa', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1167, 'Huelva', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1168, 'Huesca', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1169, 'Palma de Mallorca', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1170, 'Jaén', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1171, 'León', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1172, 'Lérida', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1173, 'Lugo', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1174, 'Madrid', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1175, 'Málaga', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1176, 'Murcia', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1177, 'Navarra', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1178, 'Orense', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1179, 'Palencia', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1180, 'Las Palmas', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1181, 'Pontevedra', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1182, 'La Rioja', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1183, 'Salamanca', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1184, 'Segovia', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1185, 'Sevilla', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1186, 'Soria', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1187, 'Tarragona', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1188, 'Santa Cruz de Tenerife', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1189, 'Teruel', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1190, 'Toledo', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1191, 'Valencia', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1192, 'Valladolid', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1193, 'Vizcaya', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1194, 'Zamora', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1195, 'Zaragoza', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1196, 'Ceuta', 207, 'ES', '', '', '', '', '', '', 1, ''),
(1197, 'Melilla', 207, 'ES', '', '', '', '', '', '', 1, ''),
Remove the Comunities
(1146, 'Burgos Province', 207, 'ES', '', 'BU', '42.33807580', '-3.58126920', '2019-10-05 17:48:40', '2021-04-11 11:56:33', 1, 'Q55271'),
(1147, 'Salamanca Province', 207, 'ES', '', 'SA', '40.95152630', '-6.23759470', '2019-10-05 17:48:40', '2021-04-11 14:37:26', 1, 'Q71080'),
(1157, 'Palencia Province', 207, 'ES', '', 'P', '42.00968320', '-4.52879490', '2019-10-05 17:48:40', '2021-04-11 14:37:32', 1, 'Q55269'),
(1158, 'Madrid', 207, 'ES', '29', 'MD', '40.41675150', '-3.70383220', '2019-10-05 17:48:40', '2021-04-11 14:38:55', 1, 'Q5756'),
(1159, 'Melilla', 207, 'ES', 'ML', 'ML', '35.29227750', '-2.93809730', '2019-10-05 17:48:40', '2020-12-21 15:50:25', 1, 'Q5831'),
(1160, 'Asturias', 207, 'ES', '34', 'AS', '43.36139530', '-5.85932670', '2019-10-05 17:48:40', '2021-04-11 14:30:57', 1, 'Q3934'),
(1161, 'Zamora Province', 207, 'ES', '', 'ZA', '41.60957440', '-5.89871390', '2019-10-05 17:48:40', '2021-04-11 14:37:03', 1, 'Q71113'),
(1167, 'Galicia', 207, 'ES', '58', 'GA', '42.57505540', '-8.13385580', '2019-10-05 17:48:40', '2020-12-21 15:50:25', 1, 'Q3908'),
(1170, 'Cantabria', 207, 'ES', '39', 'CB', '43.18283960', '-3.98784270', '2019-10-05 17:48:40', '2021-04-11 11:57:03', 1, 'Q3946'),
(1171, 'La Rioja', 207, 'ES', '27', 'RI', '42.28707330', '-2.53960300', '2019-10-05 17:48:40', '2020-12-21 15:50:25', 1, 'Q5727'),
(1174, 'Balearic Islands', 207, 'ES', '07', 'PM', '39.35877590', '2.73563280', '2019-10-05 17:48:40', '2020-12-21 15:50:25', 1, 'Q5765'),
(1175, 'Valencia', 207, 'ES', '60', 'VC', '39.48401080', '-0.75328090', '2019-10-05 17:48:40', '2021-04-11 14:38:44', 1, 'Q5720'),
(1176, 'Murcia', 207, 'ES', '31', 'MC', '38.13981410', '-1.36621600', '2019-10-05 17:48:40', '2021-04-11 14:37:47', 1, 'Q5772'),
(1177, 'Aragon', 207, 'ES', '52', 'AR', '41.59762750', '-0.90566230', '2019-10-05 17:48:40', '2020-12-21 15:50:25', 1, 'Q4040'),
(1183, 'Valladolid Province', 207, 'ES', '', 'VA', '41.65173750', '-4.72449500', '2019-10-05 17:48:40', '2021-04-11 14:37:09', 1, 'Q71097'),
(1184, 'Castile and León', 207, 'ES', '55', 'CL', '41.83568210', '-4.39763570', '2019-10-05 17:48:40', '2020-12-21 15:50:25', 1, 'Q5739'),
(1185, 'Canary Islands', 207, 'ES', '53', 'CN', '28.29156370', '-16.62913040', '2019-10-05 17:48:40', '2020-12-21 15:50:25', 1, 'Q5813'),
(1189, 'Ávila', 207, 'ES', '', 'AV', '40.69345110', '-4.89356270', '2019-10-05 17:48:40', '2021-04-11 11:56:01', 1, 'Q55288'),
(1190, 'Extremadura', 207, 'ES', '57', 'EX', '39.49373920', '-6.06791940', '2019-10-05 17:48:40', '2020-12-21 15:50:25', 1, 'Q5777'),
(1191, 'Basque Country', 207, 'ES', '59', 'PV', '42.98962480', '-2.61892730', '2019-10-05 17:48:40', '2020-12-21 15:50:25', 1, 'Q3995'),
(1192, 'Segovia Province', 207, 'ES', '', 'SG', '40.94292960', '-4.10889420', '2019-10-05 17:48:40', '2021-04-11 14:37:21', 1, 'Q55283'),
(1193, 'Andalusia', 207, 'ES', '51', 'AN', '37.54427060', '-4.72775280', '2019-10-05 17:48:40', '2020-12-21 15:50:25', 1, 'Q5783'),
(1200, 'Léon', 207, 'ES', '55', 'LE', '42.59870410', '-5.56708390', '2019-10-05 17:48:40', '2021-04-11 14:21:45', 1, 'Q71140'),
(1203, 'Catalonia', 207, 'ES', '56', 'CT', '41.59115890', '1.52086240', '2019-10-05 17:48:40', '2020-12-21 15:50:25', 1, 'Q5705'),
(1204, 'Navarra', 207, 'ES', '32', 'NC', '42.69539090', '-1.67606910', '2019-10-05 17:48:40', '2021-04-11 11:01:02', 1, 'Q4018'),
(1205, 'Castilla La Mancha', 207, 'ES', '54', 'CM', '39.27956070', '-3.09770200', '2019-10-05 17:48:41', '2021-04-11 11:00:01', 1, 'Q5748'),
(1206, 'Ceuta', 207, 'ES', 'CE', 'CE', '35.88938740', '-5.32134550', '2019-10-05 17:48:41', '2020-12-21 15:50:25', 1, 'Q5823'),
@tjaoc Thank you so much.
I will take a look at this soon.
@dr5hn how time uprade this?
@tjaoc Sorry, I literally missed this. Can you please share a reason for removing them?
This is where I get the data from. https://www.iso.org/obp/ui/#iso:code:3166:ES
@tjaoc This has been actioned. Please review.