data1.sql

-- Rwanda
INSERT INTO countries VALUES 
('RW', 'AF', 'Rwanda', 'Kigali');

-- Note: In Rwanda, administrative divisions such as provinces are considered as states for simplicity.
INSERT INTO states VALUES
('RW-01', 'RW', 'Kigali City'),
('RW-02', 'RW', 'Eastern Province'),
('RW-03', 'RW', 'Northern Province'),
('RW-04', 'RW', 'Western Province'),
('RW-05', 'RW', 'Southern Province');

-- Russia
INSERT INTO countries VALUES 
('RU', 'EU', 'Russia', 'Moscow');

-- Note: In Russia, administrative divisions such as federal subjects are considered as states for simplicity.
INSERT INTO states VALUES
('RU-AD', 'RU', 'Republic of Adygea'),
('RU-AL', 'RU', 'Altai Republic'),
('RU-BA', 'RU', 'Republic of Bashkortostan'),
('RU-BU', 'RU', 'Republic of Buryatia'),
('RU-CE', 'RU', 'Chechen Republic'),
('RU-CU', 'RU', 'Chuvash Republic'),
('RU-CR', 'RU', 'Republic of Crimea'),
('RU-DA', 'RU', 'Republic of Dagestan'),
('RU-IN', 'RU', 'Republic of Ingushetia'),
('RU-KB', 'RU', 'Kabardino-Balkar Republic'),
('RU-KL', 'RU', 'Republic of Kalmykia'),
('RU-KR', 'RU', 'Republic of Karelia'),
('RU-KK', 'RU', 'Komi Republic'),
('RU-KAM', 'RU', 'Kamchatka Krai'),
('RU-KC', 'RU', 'Krasnoyarsk Krai'),
('RU-KDA', 'RU', 'Krasnodar Krai'),
('RU-KYA', 'RU', 'Kurgan Oblast'),
('RU-KRS', 'RU', 'Kursk Oblast'),
('RU-LEN', 'RU', 'Leningrad Oblast'),
('RU-LIP', 'RU', 'Lipetsk Oblast'),
('RU-MAG', 'RU', 'Magadan Oblast'),
('RU-ME', 'RU', 'Mari El Republic'),
('RU-MO', 'RU', 'Republic of Mordovia'),
('RU-SA', 'RU', 'Sakha Republic'),
('RU-SAK', 'RU', 'Sakhalin Oblast'),
('RU-SVE', 'RU', 'Sverdlovsk Oblast'),
('RU-TY', 'RU', 'Republic of Tyva'),
('RU-TYU', 'RU', 'Tyumen Oblast'),
('RU-UD', 'RU', 'Udmurt Republic'),
('RU-ULY', 'RU', 'Ulyanovsk Oblast'),
('RU-VLA', 'RU', 'Vladimir Oblast'),
('RU-VGG', 'RU', 'Volgograd Oblast'),
('RU-VLG', 'RU', 'Vologda Oblast'),
('RU-VOR', 'RU', 'Voronezh Oblast'),
('RU-YAN', 'RU', 'Yamalo-Nenets Autonomous Okrug'),
('RU-YAR', 'RU', 'Yaroslavl Oblast');

-- Romania
INSERT INTO countries VALUES 
('RO', 'EU', 'Romania', 'Bucharest');

-- Note: In Romania, administrative divisions such as counties are considered as states for simplicity.
INSERT INTO states VALUES
('RO-AB', 'RO', 'Alba County'),
('RO-AR', 'RO', 'Arad County'),
('RO-AG', 'RO', 'Argeș County'),
('RO-BC', 'RO', 'Bacău County'),
('RO-BN', 'RO', 'Bistrița-Năsăud County'),
('RO-BR', 'RO', 'Brăila County'),
('RO-BV', 'RO', 'Brașov County'),
('RO-B', 'RO', 'Bucharest'),
('RO-BZ', 'RO', 'Buzău County'),
('RO-CS', 'RO', 'Caraș-Severin County'),
('RO-CL', 'RO', 'Călărași County'),
('RO-CJ', 'RO', 'Cluj County'),
('RO-CT', 'RO', 'Constanța County'),
('RO-CV', 'RO', 'Covasna County'),
('RO-DB', 'RO', 'Dâmbovița County'),
('RO-DJ', 'RO', 'Dolj County'),
('RO-GL', 'RO', 'Galați County'),
('RO-GR', 'RO', 'Giurgiu County'),
('RO-GJ', 'RO', 'Gorj County'),
('RO-HR', 'RO', 'Harghita County'),
('RO-HD', 'RO', 'Hunedoara County'),
('RO-IL', 'RO', 'Ialomița County'),
('RO-IS', 'RO', 'Iași County'),
('RO-IF', 'RO', 'Ilfov County'),
('RO-MM', 'RO', 'Maramureș County'),
('RO-MH', 'RO', 'Mehedinți County'),
('RO-MS', 'RO', 'Mureș County'),
('RO-NT', 'RO', 'Neamț County'),
('RO-OT', 'RO', 'Olt County'),
('RO-PH', 'RO', 'Prahova County'),
('RO-SM', 'RO', 'Satu Mare County'),
('RO-SJ', 'RO', 'Sălaj County'),
('RO-SB', 'RO', 'Sibiu County'),
('RO-SV', 'RO', 'Suceava County'),
('RO-TR', 'RO', 'Teleorman County'),
('RO-TM', 'RO', 'Timiș County'),
('RO-TL', 'RO', 'Tulcea County'),
('RO-VS', 'RO', 'Vaslui County'),
('RO-VN', 'RO', 'Vâlcea County'),
('RO-VL', 'RO', 'Vrancea County');

-- Qatar
INSERT INTO countries VALUES 
('QA', 'AS', 'Qatar', 'Doha');

-- Puerto Rico
INSERT INTO countries VALUES 
('PR', 'NA', 'Puerto Rico', 'San Juan');

-- Portugal
INSERT INTO countries VALUES 
('PT', 'EU', 'Portugal', 'Lisbon');

-- Note: In Portugal, administrative divisions such as districts are considered as states for simplicity.
INSERT INTO states VALUES
('PT-01', 'PT', 'Aveiro'),
('PT-02', 'PT', 'Beja'),
('PT-03', 'PT', 'Braga'),
('PT-04', 'PT', 'Bragança'),
('PT-05', 'PT', 'Castelo Branco'),
('PT-06', 'PT', 'Coimbra'),
('PT-07', 'PT', 'Évora'),
('PT-08', 'PT', 'Faro'),
('PT-09', 'PT', 'Guarda'),
('PT-10', 'PT', 'Leiria'),
('PT-11', 'PT', 'Lisbon'),
('PT-12', 'PT', 'Portalegre'),
('PT-13', 'PT', 'Porto'),
('PT-14', 'PT', 'Santarém'),
('PT-15', 'PT', 'Setúbal'),
('PT-16', 'PT', 'Viana do Castelo'),
('PT-17', 'PT', 'Vila Real'),
('PT-18', 'PT', 'Viseu'),
('PT-20', 'PT', 'Azores'),
('PT-30', 'PT', 'Madeira');

-- Poland
INSERT INTO countries VALUES 
('PL', 'EU', 'Poland', 'Warsaw');

-- Note: In Poland, administrative divisions such as voivodeships are considered as states for simplicity.
INSERT INTO states VALUES
('PL-DS', 'PL', 'Lower Silesian Voivodeship'),
('PL-KP', 'PL', 'Kuyavian-Pomeranian Voivodeship'),
('PL-LB', 'PL', 'Lubusz Voivodeship'),
('PL-LD', 'PL', 'Łódź Voivodeship'),
('PL-LU', 'PL', 'Lublin Voivodeship'),
('PL-MA', 'PL', 'Lesser Poland Voivodeship'),
('PL-MZ', 'PL', 'Mazovia Voivodeship'),
('PL-OP', 'PL', 'Opole Voivodeship'),
('PL-PD', 'PL', 'Podlaskie Voivodeship'),
('PL-PK', 'PL', 'Subcarpathian Voivodeship'),
('PL-PM', 'PL', 'Pomeranian Voivodeship'),
('PL-SL', 'PL', 'Silesian Voivodeship'),
('PL-SK', 'PL', 'Świętokrzyskie Voivodeship'),
('PL-WN', 'PL', 'Warmian-Masurian Voivodeship'),
('PL-WP', 'PL', 'Greater Poland Voivodeship'),
('PL-ZP', 'PL', 'West Pomeranian Voivodeship');

-- Philippines
INSERT INTO countries VALUES 
('PH', 'AS', 'Philippines', 'Manila');

-- Note: In the Philippines, administrative divisions such as regions are considered as states for simplicity.
INSERT INTO states VALUES
('PH-00', 'PH', 'National Capital Region'),
('PH-01', 'PH', 'Ilocos Region'),
('PH-02', 'PH', 'Cagayan Valley'),
('PH-03', 'PH', 'Central Luzon'),
('PH-04', 'PH', 'Calabarzon'),
('PH-05', 'PH', 'Bicol Region'),
('PH-06', 'PH', 'Western Visayas'),
('PH-07', 'PH', 'Central Visayas'),
('PH-08', 'PH', 'Eastern Visayas'),
('PH-09', 'PH', 'Zamboanga Peninsula'),
('PH-10', 'PH', 'Northern Mindanao'),
('PH-11', 'PH', 'Davao Region'),
('PH-12', 'PH', 'Soccsksargen'),
('PH-13', 'PH', 'Caraga'),
('PH-14', 'PH', 'Autonomous Region in Muslim Mindanao');

-- Peru
INSERT INTO countries VALUES 
('PE', 'SA', 'Peru', 'Lima');

-- Note: In Peru, administrative divisions such as regions are considered as states for simplicity.
INSERT INTO states VALUES
('PE-AMA', 'PE', 'Amazonas Region'),
('PE-ANC', 'PE', 'Ancash Region'),
('PE-APU', 'PE', 'Apurímac Region'),
('PE-ARE', 'PE', 'Arequipa Region'),
('PE-AYA', 'PE', 'Ayacucho Region'),
('PE-CAJ', 'PE', 'Cajamarca Region'),
('PE-CAL', 'PE', 'Callao'),
('PE-CUS', 'PE', 'Cusco Region'),
('PE-HUV', 'PE', 'Huancavelica Region'),
('PE-HUC', 'PE', 'Huánuco Region'),
('PE-ICA', 'PE', 'Ica Region'),
('PE-JUN', 'PE', 'Junín Region'),
('PE-LAL', 'PE', 'La Libertad Region'),
('PE-LAM', 'PE', 'Lambayeque Region'),
('PE-LIM', 'PE', 'Lima Region'),
('PE-LOR', 'PE', 'Loreto Region'),
('PE-MDD', 'PE', 'Madre de Dios Region'),
('PE-MOQ', 'PE', 'Moquegua Region'),
('PE-PAS', 'PE', 'Pasco Region'),
('PE-PIU', 'PE', 'Piura Region'),
('PE-PUN', 'PE', 'Puno Region'),
('PE-SAM', 'PE', 'San Martín Region'),
('PE-TAC', 'PE', 'Tacna Region'),
('PE-TUM', 'PE', 'Tumbes Region'),
('PE-UCA', 'PE', 'Ucayali Region');

-- Paraguay
INSERT INTO countries VALUES 
('PY', 'SA', 'Paraguay', 'Asunción');

-- Note: In Paraguay, administrative divisions such as departments are considered as states for simplicity.
INSERT INTO states VALUES
('PY-16', 'PY', 'Alto Paraguay'),
('PY-10', 'PY', 'Alto Paraná'),
('PY-13', 'PY', 'Amambay'),
('PY-ASU', 'PY', 'Asunción'),
('PY-19', 'PY', 'Boquerón'),
('PY-5', 'PY', 'Caaguazú'),
('PY-6', 'PY', 'Caazapá'),
('PY-14', 'PY', 'Canindeyú'),
('PY-11', 'PY', 'Central'),
('PY-1', 'PY', 'Concepción'),
('PY-3', 'PY', 'Cordillera'),
('PY-4', 'PY', 'Guairá'),
('PY-7', 'PY', 'Itapúa'),
('PY-8', 'PY', 'Misiones'),
('PY-12', 'PY', 'Ñeembucú'),
('PY-9', 'PY', 'Paraguarí'),
('PY-15', 'PY', 'Presidente Hayes'),
('PY-2', 'PY', 'San Pedro');

-- Panama
INSERT INTO countries VALUES 
('PA', 'NA', 'Panama', 'Panama City');

-- Note: In Panama, administrative divisions such as provinces and indigenous regions are considered as states for simplicity.
INSERT INTO states VALUES
('PA-1', 'PA', 'Bocas del Toro'),
('PA-4', 'PA', 'Chiriquí'),
('PA-2', 'PA', 'Coclé'),
('PA-3', 'PA', 'Colón'),
('PA-5', 'PA', 'Darién'),
('PA-EM', 'PA', 'Emberá'),
('PA-6', 'PA', 'Herrera'),
('PA-KY', 'PA', 'Kuna Yala'),
('PA-7', 'PA', 'Los Santos'),
('PA-NB', 'PA', 'Ngäbe-Buglé'),
('PA-8', 'PA', 'Panamá'),
('PA-10', 'PA', 'Panamá Oeste'),
('PA-9', 'PA', 'Veraguas');

-- Palestine
INSERT INTO countries VALUES 
('PS', 'AS', 'Palestine', 'Ramallah');

-- Note: In Palestine, administrative divisions such as governorates are considered as states for simplicity.
INSERT INTO states VALUES
('PS-BTH', 'PS', 'Bethlehem'),
('PS-DEB', 'PS', 'Deir al-Balah'),
('PS-GZA', 'PS', 'Gaza'),
('PS-HBN', 'PS', 'Hebron'),
('PS-JEM', 'PS', 'Jerusalem'),
('PS-JEN', 'PS', 'Jenin'),
('PS-JRH', 'PS', 'Jericho'),
('PS-KYS', 'PS', 'Khan Yunis'),
('PS-NBS', 'PS', 'Nablus'),
('PS-NGZ', 'PS', 'North Gaza'),
('PS-QQA', 'PS', 'Qalqilya'),
('PS-RBH', 'PS', 'Ramallah and al-Bireh'),
('PS-RFH', 'PS', 'Rafah'),
('PS-SLT', 'PS', 'Salfit'),
('PS-TBS', 'PS', 'Tubas'),
('PS-TKM', 'PS', 'Tulkarm');

-- Pakistan
INSERT INTO countries VALUES 
('PK', 'AS', 'Pakistan', 'Islamabad');

-- Note: In Pakistan, administrative divisions such as provinces and territories are considered as states for simplicity.
INSERT INTO states VALUES
('PK-IS', 'PK', 'Islamabad Capital Territory'),
('PK-PB', 'PK', 'Punjab'),
('PK-SD', 'PK', 'Sindh'),
('PK-KP', 'PK', 'Khyber Pakhtunkhwa'),
('PK-BA', 'PK', 'Balochistan'),
('PK-TA', 'PK', 'Federally Administered Tribal Areas'),
('PK-JK', 'PK', 'Azad Jammu and Kashmir'),
('PK-GB', 'PK', 'Gilgit-Baltistan');

-- Oman
INSERT INTO countries VALUES 
('OM', 'AS', 'Oman', 'Muscat');

-- Note: In Oman, administrative divisions such as governorates are considered as states for simplicity.
INSERT INTO states VALUES
('OM-DA', 'OM', 'Ad Dakhiliyah'),
('OM-BU', 'OM', 'Al Batinah North'),
('OM-BS', 'OM', 'Al Batinah South'),
('OM-WU', 'OM', 'Al Wusta'),
('OM-ZA', 'OM', 'Az Zahirah'),
('OM-JA', 'OM', 'Dhofar'),
('OM-MA', 'OM', 'Musandam'),
('OM-MU', 'OM', 'Muscat'),
('OM-SH', 'OM', 'Ash Sharqiyah North'),
('OM-SS', 'OM', 'Ash Sharqiyah South');

-- Norway
INSERT INTO countries VALUES 
('NO', 'EU', 'Norway', 'Oslo');

-- Note: In Norway, administrative divisions such as counties are considered as states for simplicity.
INSERT INTO states VALUES
('NO-03', 'NO', 'Oslo'),
('NO-11', 'NO', 'Rogaland'),
('NO-15', 'NO', 'Møre og Romsdal'),
('NO-18', 'NO', 'Nordland'),
('NO-30', 'NO', 'Viken'),
('NO-34', 'NO', 'Innlandet'),
('NO-38', 'NO', 'Vestfold og Telemark'),
('NO-42', 'NO', 'Agder'),
('NO-46', 'NO', 'Vestland'),
('NO-50', 'NO', 'Trøndelag'),
('NO-54', 'NO', 'Troms og Finnmark');

-- Nigeria
INSERT INTO countries VALUES 
('NG', 'AF', 'Nigeria', 'Abuja');

-- Note: In Nigeria, administrative divisions such as states are considered as states for simplicity.
INSERT INTO states VALUES
('NG-FC', 'NG', 'Abuja Federal Capital Territory'),
('NG-AB', 'NG', 'Abia'),
('NG-AD', 'NG', 'Adamawa'),
('NG-AK', 'NG', 'Akwa Ibom'),
('NG-AN', 'NG', 'Anambra'),
('NG-BA', 'NG', 'Bauchi'),
('NG-BY', 'NG', 'Bayelsa'),
('NG-BE', 'NG', 'Benue'),
('NG-BO', 'NG', 'Borno'),
('NG-CR', 'NG', 'Cross River'),
('NG-DE', 'NG', 'Delta'),
('NG-EB', 'NG', 'Ebonyi'),
('NG-ED', 'NG', 'Edo'),
('NG-EK', 'NG', 'Ekiti'),
('NG-EN', 'NG', 'Enugu'),
('NG-GO', 'NG', 'Gombe'),
('NG-IM', 'NG', 'Imo'),
('NG-JI', 'NG', 'Jigawa'),
('NG-KD', 'NG', 'Kaduna'),
('NG-KN', 'NG', 'Kano'),
('NG-KT', 'NG', 'Katsina'),
('NG-KE', 'NG', 'Kebbi'),
('NG-KO', 'NG', 'Kogi'),
('NG-KW', 'NG', 'Kwara'),
('NG-LA', 'NG', 'Lagos'),
('NG-NA', 'NG', 'Nasarawa'),
('NG-NI', 'NG', 'Niger'),
('NG-OG', 'NG', 'Ogun'),
('NG-ON', 'NG', 'Ondo'),
('NG-OS', 'NG', 'Osun'),
('NG-OY', 'NG', 'Oyo'),
('NG-PL', 'NG', 'Plateau'),
('NG-RI', 'NG', 'Rivers'),
('NG-SO', 'NG', 'Sokoto'),
('NG-TA', 'NG', 'Taraba'),
('NG-YO', 'NG', 'Yobe'),
('NG-ZA', 'NG', 'Zamfara');

-- Nicaragua
INSERT INTO countries VALUES 
('NI', 'NA', 'Nicaragua', 'Managua');

-- Note: In Nicaragua, administrative divisions such as departments are considered as states for simplicity.
INSERT INTO states VALUES
('NI-BO', 'NI', 'Boaco'),
('NI-CA', 'NI', 'Carazo'),
('NI-CI', 'NI', 'Chinandega'),
('NI-CO', 'NI', 'Chontales'),
('NI-ES', 'NI', 'Estelí'),
('NI-GR', 'NI', 'Granada'),
('NI-JI', 'NI', 'Jinotega'),
('NI-LE', 'NI', 'León'),
('NI-MD', 'NI', 'Madriz'),
('NI-MN', 'NI', 'Managua'),
('NI-MS', 'NI', 'Masaya'),
('NI-MT', 'NI', 'Matagalpa'),
('NI-NS', 'NI', 'Nueva Segovia'),
('NI-SJ', 'NI', 'Río San Juan'),
('NI-RI', 'NI', 'Rivas');

-- New Zealand
INSERT INTO countries VALUES 
('NZ', 'OC', 'New Zealand', 'Wellington');

-- Note: In New Zealand, administrative divisions such as regions are considered as states for simplicity.
INSERT INTO states VALUES
('NZ-N', 'NZ', 'Northland'),
('NZ-AUK', 'NZ', 'Auckland'),
('NZ-WKO', 'NZ', 'Waikato'),
('NZ-BOP', 'NZ', 'Bay of Plenty'),
('NZ-HKB', 'NZ', 'Hawke`s Bay'),
('NZ-MWT', 'NZ', 'Manawatu-Wanganui'),
('NZ-WGN', 'NZ', 'Wellington'),
('NZ-TAS', 'NZ', 'Tasman'),
('NZ-CAN', 'NZ', 'Canterbury'),
('NZ-OTA', 'NZ', 'Otago'),
('NZ-STL', 'NZ', 'Southland');

-- Netherlands
INSERT INTO countries VALUES 
('NL', 'EU', 'Netherlands', 'Amsterdam');

-- Note: In the Netherlands, administrative divisions such as provinces are considered as states for simplicity.
INSERT INTO states VALUES
('NL-DR', 'NL', 'Drenthe'),
('NL-FL', 'NL', 'Flevoland'),
('NL-FR', 'NL', 'Friesland'),
('NL-GE', 'NL', 'Gelderland'),
('NL-GR', 'NL', 'Groningen'),
('NL-LI', 'NL', 'Limburg'),
('NL-NB', 'NL', 'North Brabant'),
('NL-NH', 'NL', 'North Holland'),
('NL-OV', 'NL', 'Overijssel'),
('NL-UT', 'NL', 'Utrecht'),
('NL-ZE', 'NL', 'Zeeland'),
('NL-ZH', 'NL', 'South Holland');

-- Nepal
INSERT INTO countries VALUES 
('NP', 'AS', 'Nepal', 'Kathmandu');

-- Note: In Nepal, administrative divisions such as provinces are considered as states for simplicity.
INSERT INTO states VALUES
('NP-P1', 'NP', 'Province No. 1'),
('NP-P2', 'NP', 'Province No. 2'),
('NP-P3', 'NP', 'Bagmati Province'),
('NP-P4', 'NP', 'Gandaki Province'),
('NP-P5', 'NP', 'Lumbini Province'),
('NP-P6', 'NP', 'Karnali Province'),
('NP-P7', 'NP', 'Sudurpashchim Province');

-- Namibia
INSERT INTO countries VALUES 
('NA', 'AF', 'Namibia', 'Windhoek');

-- Note: In Namibia, administrative divisions such as regions are considered as states for simplicity.
INSERT INTO states VALUES
('NA-CA', 'NA', 'Erongo'),
('NA-HA', 'NA', 'Hardap'),
('NA-KA', 'NA', 'Kavango East'),
('NA-KH', 'NA', 'Khomas'),
('NA-KU', 'NA', 'Kunene'),
('NA-OD', 'NA', 'Otjozondjupa'),
('NA-OH', 'NA', 'Omaheke'),
('NA-ON', 'NA', 'Oshana'),
('NA-OS', 'NA', 'Omusati'),
('NA-OT', 'NA', 'Oshikoto'),
('NA-OW', 'NA', 'Ohangwena');

-- Myanmar