search

dr5hn / countries-states-cities-database

🌍 Discover our global repository of countries, states, and cities! 🏙️ Get comprehensive data in JSON, SQL, PSQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native language, timezones (for countries), and more. #countries #states #cities
https://dr5hn.github.io/countries-states-cities-database/
Open Data Commons Open Database License v1.0
7.38k stars 2.56k forks source link

States from Spain #243

Closed tjaoc closed 2 years ago

tjaoc commented 3 years ago 
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, ''),
tjaoc commented 3 years ago

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'),
dr5hn commented 3 years ago

@tjaoc Thank you so much.

I will take a look at this soon.

tjaoc commented 2 years ago

@dr5hn how time uprade this?

dr5hn commented 2 years ago

@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

dr5hn commented 2 years ago

@tjaoc This has been actioned. Please review.