Not working in subdirectory #70

2braincells2go · 2024-01-26T07:19:44Z

Greetings!

I have changed the env.php:

Get 404 when trying to install. example.com/install not found. It of course should be example.com/sites/install

Have tried on local dev server and on live server with exact errors?

I did get this to load but many, many 404 errors in dev console:

How to fix? Really like to try it out :)

givanz · 2024-01-26T22:55:18Z

Hi

Thanks for he bug report, the install redirect and install public folder path didn't include the subdirectory path.
I fixed it in the last update, please redownload latest.zip and update the files.

If you are using apache you need to update .htaccess and add the subdirectory path

https://github.com/givanz/Vvveb/blob/master/.htaccess#L44

RewriteRule ^ sites/index.php [L]

Menu links like about, contact us etc are fixed you need to update them after install to include /sites in the url from admin > pages > menu.

2braincells2go · 2024-01-27T03:40:46Z

Thanks @givanz

Unfortunately now this error appears when choosing SQLite. I am pretty sure SQLite is installed and working, tried on local dev and live server with exact results:

Continuing to next step is bad. Can continue and login but nothing really works.

givanz · 2024-01-27T09:58:36Z

Thanks for feedback.

I suspect that admin table fails because some sqlite commands to speed up install are added before the admin table sql code.

https://github.com/givanz/Vvveb/blob/master/install/sql/sqlite/schema/admin/admin.sql#L1-L4

I moved the pragma commands from admin table file to code.

Please reupdate the files from latest.zip

If it still doesn't work please provide more info like php and sqlite version and I will try to reproduce the bug.

If sqlite version is less than 3.9.0 https://sqlite.org/fts5.html#building_fts5_as_part_of_sqlite then fts5 full text search support might be missing.

2braincells2go · 2024-01-27T11:30:21Z

Did not work for me. Same issue.

SQLite is version 3.26.0. Running PHP 8.2.13

Alma 8.9 (Midnight Oncilla) x86_64(Py3.7.8)

givanz · 2024-01-27T21:13:50Z

Thanks for version info.

I installed AlmaLinux 8.9 and tested on sqlite 3.26.0.

There is a bug in full text search module, tried both fts5 and fts4.

I haven't found any fix to make fts work on 3.26.0 it fails with object name reserved for internal use for all configurations I tried.

If you don't need full text search then you can delete the sql from

https://github.com/givanz/Vvveb/blob/master/install/sql/sqlite/schema/post/post_content-fts5.sql#L18-L51

https://github.com/givanz/Vvveb/blob/master/install/sql/sqlite/schema/product/product_content-fts5.sql#L20-L52

and install will work.

On newer sqlite versions like 3.37.2 fts works fine.

2braincells2go · 2024-01-28T02:09:25Z

Sorry @givanz . I am actually working on this for my schoolteacher wife and we used her account to reply earlier. Figured that would confuse us all, lol.

Here is the reply:

Ok, not sure I 100% follow what to delete from fts4 and fts5. Am i deleting a portion of the file or entire contents?

Removing portion I get error:

Unable to prepare statement: 1, malformed database schema (post_content_search_data) - object name reserved for internal use: post_content_search_data
SELECT type as t, name, dflt_value as d, `notnull` as n FROM pragma_table_info('site');

I then cleared the file(s) and left blank, still no go.

Sorry, I just do not understand what you are saying "If you don't need full text search then you can delete the sql from"

On another note: is there a place to change where vvveb looks for sqlite3? I have installed 3.45 but it is in folder /usr/local/bin/sqlite3. Not ready to set server to sqlite 3.45 quite yet.

givanz · 2024-01-28T12:58:29Z

Only the highlighted portion should be deleted, starting with DROP TABLE IF EXISTS *_content_search; until the end of the file.

From the error message it looks like the full text search table is still there.

Delete the database from /vvveb/storage/sqlite/vvveb.db to make sure that the table is removed before retrying.

Sorry, I just do not understand what you are saying "If you don't need full text search then you can delete the sql from"

If you only need to test and don't need to use site search feature then you can remove full text search, if you also need site search then you need to upgrade sqlite or use mysql.

There are also some autocomplete features that depend on search.

Sqlite functions are provided by the php extension https://www.php.net/manual/en/book.sqlite3.php if you upgrade your php version and your distribution sqlite packages it should be enough to have a newer version.

Usually the package is called php-sqlite3 on most distributions.

oleteacher · 2024-01-29T00:04:23Z

Thanks @givanz . Well, I tried on a cPanel account instead of the school server and still no luck using SQLite.

Just get the error below running PHP 8.2.13 and SQLite 3.7.17:

✖ Db error: "Unable to prepare statement: 1, too many terms in compound SELECT INSERT INTO region VALUES (1, 1, 'Badakhshan', 'BDS', 0), (2, 1, 'Badghis', 'BDG', 0), (3, 1, 'Baghlan', 'BGL', 0), (4, 1, 'Balkh', 'BAL', 0), (5, 1, 'Bamian', 'BAM', 0), (6, 1, 'Farah', 'FRA', 0), (7, 1, 'Faryab', 'FYB', 0), (8, 1, 'Ghazni', 'GHA', 0), (9, 1, 'Ghowr', 'GHO', 0), (10, 1, 'Helmand', 'HEL', 0), (11, 1, 'Herat', 'HER', 0), (12, 1, 'Jowzjan', 'JOW', 0), (13, 1, 'Kabul', 'KAB', 0), (14, 1, 'Kandahar', 'KAN', 0), (15, 1, 'Kapisa', 'KAP', 0), (16, 1, 'Khost', 'KHO', 0), (17, 1, 'Konar', 'KNR', 0), (18, 1, 'Kondoz', 'KDZ', 0), (19, 1, 'Laghman', 'LAG', 0), (20, 1, 'Lowgar', 'LOW', 0), (21, 1, 'Nangrahar', 'NAN', 0), (22, 1, 'Nimruz', 'NIM', 0), (23, 1, 'Nurestan', 'NUR', 0), (24, 1, 'Oruzgan', 'ORU', 0), (25, 1, 'Paktia', 'PIA', 0), (26, 1, 'Paktika', 'PKA', 0), (27, 1, 'Parwan', 'PAR', 0), (28, 1, 'Samangan', 'SAM', 0), (29, 1, 'Sar-e Pol', 'SAR', 0), (30, 1, 'Takhar', 'TAK', 0), (31, 1, 'Wardak', 'WAR', 0), (32, 1, 'Zabol', 'ZAB', 0), (33, 2, 'Berat', 'BR', 0), (34, 2, 'Bulqize', 'BU', 0), (35, 2, 'Delvine', 'DL', 0), (36, 2, 'Devoll', 'DV', 0), (37, 2, 'Diber', 'DI', 0), (38, 2, 'Durres', 'DR', 0), (39, 2, 'Elbasan', 'EL', 0), (40, 2, 'Kolonje', 'ER', 0), (41, 2, 'Fier', 'FR', 0), (42, 2, 'Gjirokaster', 'GJ', 0), (43, 2, 'Gramsh', 'GR', 0), (44, 2, 'Has', 'HA', 0), (45, 2, 'Kavaje', 'KA', 0), (46, 2, 'Kurbin', 'KB', 0), (47, 2, 'Kucove', 'KC', 0), (48, 2, 'Korce', 'KO', 0), (49, 2, 'Kruje', 'KR', 0), (50, 2, 'Kukes', 'KU', 0), (51, 2, 'Librazhd', 'LB', 0), (52, 2, 'Lezhe', 'LE', 0), (53, 2, 'Lushnje', 'LU', 0), (54, 2, 'Malesi e Madhe', 'MM', 0), (55, 2, 'Mallakaster', 'MK', 0), (56, 2, 'Mat', 'MT', 0), (57, 2, 'Mirdite', 'MR', 0), (58, 2, 'Peqin', 'PQ', 0), (59, 2, 'Permet', 'PR', 0), (60, 2, 'Pogradec', 'PG', 0), (61, 2, 'Puke', 'PU', 0), (62, 2, 'Shkoder', 'SH', 0), (63, 2, 'Skrapar', 'SK', 0), (64, 2, 'Sarande', 'SR', 0), (65, 2, 'Tepelene', 'TE', 0), (66, 2, 'Tropoje', 'TP', 0), (67, 2, 'Tirane', 'TR', 0), (68, 2, 'Vlore', 'VL', 0), (69, 3, 'Adrar', '01', 0), (70, 3, 'Ain Defla', '44', 0), (71, 3, 'Ain Temouchent', '46', 0), (72, 3, 'Alger', '16', 0), (73, 3, 'Annaba', '23', 0), (74, 3, 'Batna', '05', 0), (75, 3, 'Bechar', '08', 0), (76, 3, 'Bejaia', '06', 0), (77, 3, 'Biskra', '07', 0), (78, 3, 'Blida', '09', 0), (79, 3, 'Bordj Bou Arreridj', '34', 0), (80, 3, 'Bouira', '10', 0), (81, 3, 'Boumerdes', '35', 0), (82, 3, 'Chlef', '02', 0), (83, 3, 'Constantine', '26', 0), (84, 3, 'Djelfa', '17', 0), (85, 3, 'El Bayadh', '32', 0), (86, 3, 'El Oued', '39', 0), (87, 3, 'El Tarf', '36', 0), (88, 3, 'Ghardaia', '47', 0), (89, 3, 'Guelma', '24', 0), (90, 3, 'Illizi', '33', 0), (91, 3, 'Jijel', '18', 0), (92, 3, 'Khenchela', '40', 0), (93, 3, 'Laghouat', '03', 0), (94, 3, 'Mascara', '29', 0), (95, 3, 'Medea', '26', 0), (96, 3, 'Mila', '43', 0), (97, 3, 'Mostaganem', '27', 0), (98, 3, 'MSila', '28', 0), (99, 3, 'Naama', '45', 0), (100, 3, 'Oran', '31', 0), (101, 3, 'Ouargla', '30', 0), (102, 3, 'Oum el-Bouaghi', '04', 0), (103, 3, 'Relizane', '48', 0), (104, 3, 'Saida', '20', 0), (105, 3, 'Setif', '19', 0), (106, 3, 'Sidi Bel Abbes', '22', 0), (107, 3, 'Skikda', '21', 0), (108, 3, 'Souk Ahras', '41', 0), (109, 3, 'Tamanrasset', '11', 0), (110, 3, 'Tebessa', '12', 0), (111, 3, 'Tiaret', '14', 0), (112, 3, 'Tindouf', '37', 0), (113, 3, 'Tipaza', '42', 0), (114, 3, 'Tissemsilt', '38', 0), (115, 3, 'Tizi Ouzou', '15', 0), (116, 3, 'Tlemcen', '13', 0), (117, 4, 'Eastern', 'E', 0), (118, 4, 'Manua', 'M', 0), (119, 4, 'Rose Island', 'R', 0), (120, 4, 'Swains Island', 'S', 0), (121, 4, 'Western', 'W', 0), (122, 5, 'Andorra la Vella', 'ALV', 0), (123, 5, 'Canillo', 'CAN', 0), (124, 5, 'Encamp', 'ENC', 0), (125, 5, 'Escaldes-Engordany', 'ESE', 0), (126, 5, 'La Massana', 'LMA', 0), (127, 5, 'Ordino', 'ORD', 0), (128, 5, 'Sant Julia de Loria', 'SJL', 0), (129, 6, 'Bengo', 'BGO', 0), (130, 6, 'Benguela', 'BGU', 0), (131, 6, 'Bie', 'BIE', 0), (132, 6, 'Cabinda', 'CAB', 0), (133, 6, 'Cuando-Cubango', 'CCU', 0), (134, 6, 'Cuanza Norte', 'CNO', 0), (135, 6, 'Cuanza Sul', 'CUS', 0), (136, 6, 'Cunene', 'CNN', 0), (137, 6, 'Huambo', 'HUA', 0), (138, 6, 'Huila', 'HUI', 0), (139, 6, 'Luanda', 'LUA', 0), (140, 6, 'Lunda Norte', 'LNO', 0), (141, 6, 'Lunda Sul', 'LSU', 0), (142, 6, 'Malange', 'MAL', 0), (143, 6, 'Moxico', 'MOX', 0), (144, 6, 'Namibe', 'NAM', 0), (145, 6, 'Uige', 'UIG', 0), (146, 6, 'Zaire', 'ZAI', 0), (147, 9, 'Saint George', 'ASG', 0), (148, 9, 'Saint John', 'ASJ', 0), (149, 9, 'Saint Mary', 'ASM', 0), (150, 9, 'Saint Paul', 'ASL', 0), (151, 9, 'Saint Peter', 'ASR', 0), (152, 9, 'Saint Philip', 'ASH', 0), (153, 9, 'Barbuda', 'BAR', 0), (154, 9, 'Redonda', 'RED', 0), (155, 10, 'Antartida e Islas del Atlantico', 'AN', 0), (156, 10, 'Buenos Aires', 'B', 0), (157, 10, 'Catamarca', 'K', 0), (158, 10, 'Chaco', 'H', 0), (159, 10, 'Chubut', 'U', 0), (160, 10, 'Cordoba', 'X', 0), (161, 10, 'Corrientes', 'W', 0), (162, 10, 'Ciudad Autónoma de Buenos Aires', 'C', 0), (163, 10, 'Entre Rios', 'E', 0), (164, 10, 'Formosa', 'P', 0), (165, 10, 'Jujuy', 'Y', 0), (166, 10, 'La Pampa', 'L', 0), (167, 10, 'La Rioja', 'F', 0), (168, 10, 'Mendoza', 'M', 0), (169, 10, 'Misiones', 'N', 0), (170, 10, 'Neuquen', 'Q', 0), (171, 10, 'Rio Negro', 'R', 0), (172, 10, 'Salta', 'A', 0), (173, 10, 'San Juan', 'J', 0), (174, 10, 'San Luis', 'D', 0), (175, 10, 'Santa Cruz', 'Z', 0), (176, 10, 'Santa Fe', 'S', 0), (177, 10, 'Santiago del Estero', 'G', 0), (178, 10, 'Tierra del Fuego', 'V', 0), (179, 10, 'Tucuman', 'T', 0), (180, 11, 'Aragatsotn', 'AGT', 0), (181, 11, 'Ararat', 'ARR', 0), (182, 11, 'Armavir', 'ARM', 0), (183, 11, 'Gegharkunik', 'GEG', 0), (184, 11, 'Kotayk', 'KOT', 0), (185, 11, 'Lorri', 'LOR', 0), (186, 11, 'Shirak', 'SHI', 0), (187, 11, 'Syunik', 'SYU', 0), (188, 11, 'Tavush', 'TAV', 0), (189, 11, 'Vayots Dzor', 'VAY', 0), (190, 11, 'Yerevan', 'YER', 0), (191, 13, 'Australian Capital Territory', 'ACT', 0), (192, 13, 'New South Wales', 'NSW', 0), (193, 13, 'Northern Territory', 'NT', 0), (194, 13, 'Queensland', 'QLD', 0), (195, 13, 'South Australia', 'SA', 0), (196, 13, 'Tasmania', 'TAS', 0), (197, 13, 'Victoria', 'VIC', 0), (198, 13, 'Western Australia', 'WA', 0), (199, 14, 'Burgenland', '1', 0), (200, 14, 'Kärnten', '2', 0), (201, 14, 'Niederösterreich', '3', 0), (202, 14, 'Oberösterreich', '4', 0), (203, 14, 'Salzburg', '5', 0), (204, 14, 'Steiermark', '6', 0), (205, 14, 'Tirol', '7', 0), (206, 14, 'Vorarlberg', '8', 0), (207, 14, 'Wien', '9', 0), (208, 15, 'Ali Bayramli', 'AB', 0), (209, 15, 'Abseron', 'ABS', 0), (210, 15, 'AgcabAdi', 'AGC', 0), (211, 15, 'Agdam', 'AGM', 0), (212, 15, 'Agdas', 'AGS', 0), (213, 15, 'Agstafa', 'AGA', 0), (214, 15, 'Agsu', 'AGU', 0), (215, 15, 'Astara', 'AST', 0), (216, 15, 'Baki', 'BA', 0), (217, 15, 'BabAk', 'BAB', 0), (218, 15, 'BalakAn', 'BAL', 0), (219, 15, 'BArdA', 'BAR', 0), (220, 15, 'Beylaqan', 'BEY', 0), (221, 15, 'Bilasuvar', 'BIL', 0), (222, 15, 'Cabrayil', 'CAB', 0), (223, 15, 'Calilabab', 'CAL', 0), (224, 15, 'Culfa', 'CUL', 0), (225, 15, 'Daskasan', 'DAS', 0), (226, 15, 'Davaci', 'DAV', 0), (227, 15, 'Fuzuli', 'FUZ', 0), (228, 15, 'Ganca', 'GA', 0), (229, 15, 'Gadabay', 'GAD', 0), (230, 15, 'Goranboy', 'GOR', 0), (231, 15, 'Goycay', 'GOY', 0), (232, 15, 'Haciqabul', 'HAC', 0), (233, 15, 'Imisli', 'IMI', 0), (234, 15, 'Ismayilli', 'ISM', 0), (235, 15, 'Kalbacar', 'KAL', 0), (236, 15, 'Kurdamir', 'KUR', 0), (237, 15, 'Lankaran', 'LA', 0), (238, 15, 'Lacin', 'LAC', 0), (239, 15, 'Lankaran', 'LAN', 0), (240, 15, 'Lerik', 'LER', 0), (241, 15, 'Masalli', 'MAS', 0), (242, 15, 'Mingacevir', 'MI', 0), (243, 15, 'Naftalan', 'NA', 0), (244, 15, 'Neftcala', 'NEF', 0), (245, 15, 'Oguz', 'OGU', 0), (246, 15, 'Ordubad', 'ORD', 0), (247, 15, 'Qabala', 'QAB', 0), (248, 15, 'Qax', 'QAX', 0), (249, 15, 'Qazax', 'QAZ', 0), (250, 15, 'Qobustan', 'QOB', 0), (251, 15, 'Quba', 'QBA', 0), (252, 15, 'Qubadli', 'QBI', 0), (253, 15, 'Qusar', 'QUS', 0), (254, 15, 'Saki', 'SA', 0), (255, 15, 'Saatli', 'SAT', 0), (256, 15, 'Sabirabad', 'SAB', 0), (257, 15, 'Sadarak', 'SAD', 0), (258, 15, 'Sahbuz', 'SAH', 0), (259, 15, 'Saki', 'SAK', 0), (260, 15, 'Salyan', 'SAL', 0), (261, 15, 'Sumqayit', 'SM', 0), (262, 15, 'Samaxi', 'SMI', 0), (263, 15, 'Samkir', 'SKR', 0), (264, 15, 'Samux', 'SMX', 0), (265, 15, 'Sarur', 'SAR', 0), (266, 15, 'Siyazan', 'SIY', 0), (267, 15, 'Susa', 'SS', 0), (268, 15, 'Susa', 'SUS', 0), (269, 15, 'Tartar', 'TAR', 0), (270, 15, 'Tovuz', 'TOV', 0), (271, 15, 'Ucar', 'UCA', 0), (272, 15, 'Xankandi', 'XA', 0), (273, 15, 'Xacmaz', 'XAC', 0), (274, 15, 'Xanlar', 'XAN', 0), (275, 15, 'Xizi', 'XIZ', 0), (276, 15, 'Xocali', 'XCI', 0), (277, 15, 'Xocavand', 'XVD', 0), (278, 15, 'Yardimli', 'YAR', 0), (279, 15, 'Yevlax', 'YEV', 0), (280, 15, 'Zangilan', 'ZAN', 0), (281, 15, 'Zaqatala', 'ZAQ', 0), (282, 15, 'Zardab', 'ZAR', 0), (283, 15, 'Naxcivan', 'NX', 0), (284, 16, 'Acklins', 'ACK', 0), (285, 16, 'Berry Islands', 'BER', 0), (286, 16, 'Bimini', 'BIM', 0), (287, 16, 'Black Point', 'BLK', 0), (288, 16, 'Cat Island', 'CAT', 0), (289, 16, 'Central Abaco', 'CAB', 0), (290, 16, 'Central Andros', 'CAN', 0), (291, 16, 'Central Eleuthera', 'CEL', 0), (292, 16, 'City of Freeport', 'FRE', 0), (293, 16, 'Crooked Island', 'CRO', 0), (294, 16, 'East Grand Bahama', 'EGB', 0), (295, 16, 'Exuma', 'EXU', 0), (296, 16, 'Grand Cay', 'GRD', 0), (297, 16, 'Harbour Island', 'HAR', 0), (298, 16, 'Hope Town', 'HOP', 0), (299, 16, 'Inagua', 'INA', 0), (300, 16, 'Long Island', 'LNG', 0), (301, 16, 'Mangrove Cay', 'MAN', 0), (302, 16, 'Mayaguana', 'MAY', 0), (303, 16, 'Moores Island', 'MOO', 0), (304, 16, 'North Abaco', 'NAB', 0), (305, 16, 'North Andros', 'NAN', 0), (306, 16, 'North Eleuthera', 'NEL', 0), (307, 16, 'Ragged Island', 'RAG', 0), (308, 16, 'Rum Cay', 'RUM', 0), (309, 16, 'San Salvador', 'SAL', 0), (310, 16, 'South Abaco', 'SAB', 0), (311, 16, 'South Andros', 'SAN', 0), (312, 16, 'South Eleuthera', 'SEL', 0), (313, 16, 'Spanish Wells', 'SWE', 0), (314, 16, 'West Grand Bahama', 'WGB', 0), (315, 17, 'Capital', 'CAP', 0), (316, 17, 'Central', 'CEN', 0), (317, 17, 'Muharraq', 'MUH', 0), (318, 17, 'Northern', 'NOR', 0), (319, 17, 'Southern', 'SOU', 0), (320, 18, 'Barisal', 'BAR', 0), (321, 18, 'Chittagong', 'CHI', 0), (322, 18, 'Dhaka', 'DHA', 0), (323, 18, 'Khulna', 'KHU', 0), (324, 18, 'Rajshahi', 'RAJ', 0), (325, 18, 'Sylhet', 'SYL', 0), (326, 19, 'Christ Church', 'CC', 0), (327, 19, 'Saint Andrew', 'AND', 0), (328, 19, 'Saint George', 'GEO', 0), (329, 19, 'Saint James', 'JAM', 0), (330, 19, 'Saint John', 'JOH', 0), (331, 19, 'Saint Joseph', 'JOS', 0), (332, 19, 'Saint Lucy', 'LUC', 0), (333, 19, 'Saint Michael', 'MIC', 0), (334, 19, 'Saint Peter', 'PET', 0), (335, 19, 'Saint Philip', 'PHI', 0), (336, 19, 'Saint Thomas', 'THO', 0), (337, 20, 'Brestskaya (Brest)', 'BR', 0), (338, 20, 'Homyelskaya (Homyel)', 'HO', 0), (339, 20, 'Horad Minsk', 'HM', 0), (340, 20, 'Hrodzyenskaya (Hrodna)', 'HR', 0), (341, 20, 'Mahilyowskaya (Mahilyow)', 'MA', 0), (342, 20, 'Minskaya', 'MI', 0), (343, 20, 'Vitsyebskaya (Vitsyebsk)', 'VI', 0), (344, 21, 'Antwerpen', 'VAN', 0), (345, 21, 'Brabant Wallon', 'WBR', 0), (346, 21, 'Hainaut', 'WHT', 0), (347, 21, 'Liège', 'WLG', 0), (348, 21, 'Limburg', 'VLI', 0), (349, 21, 'Luxembourg', 'WLX', 0), (350, 21, 'Namur', 'WNA', 0), (351, 21, 'Oost-Vlaanderen', 'VOV', 0), (352, 21, 'Vlaams Brabant', 'VBR', 0), (353, 21, 'West-Vlaanderen', 'VWV', 0), (354, 22, 'Belize', 'BZ', 0), (355, 22, 'Cayo', 'CY', 0), (356, 22, 'Corozal', 'CR', 0), (357, 22, 'Orange Walk', 'OW', 0), (358, 22, 'Stann Creek', 'SC', 0), (359, 22, 'Toledo', 'TO', 0), (360, 23, 'Alibori', 'AL', 0), (361, 23, 'Atakora', 'AK', 0), (362, 23, 'Atlantique', 'AQ', 0), (363, 23, 'Borgou', 'BO', 0), (364, 23, 'Collines', 'CO', 0), (365, 23, 'Donga', 'DO', 0), (366, 23, 'Kouffo', 'KO', 0), (367, 23, 'Littoral', 'LI', 0), (368, 23, 'Mono', 'MO', 0), (369, 23, 'Oueme', 'OU', 0), (370, 23, 'Plateau', 'PL', 0), (371, 23, 'Zou', 'ZO', 0), (372, 24, 'Devonshire', 'DS', 0), (373, 24, 'Hamilton City', 'HC', 0), (374, 24, 'Hamilton', 'HA', 0), (375, 24, 'Paget', 'PG', 0), (376, 24, 'Pembroke', 'PB', 0), (377, 24, 'Saint George City', 'GC', 0), (378, 24, 'Saint Georges', 'SG', 0), (379, 24, 'Sandys', 'SA', 0), (380, 24, 'Smiths', 'SM', 0), (381, 24, 'Southampton', 'SH', 0), (382, 24, 'Warwick', 'WA', 0), (383, 25, 'Bumthang', 'BUM', 0), (384, 25, 'Chukha', 'CHU', 0), (385, 25, 'Dagana', 'DAG', 0), (386, 25, 'Gasa', 'GAS', 0), (387, 25, 'Haa', 'HAA', 0), (388, 25, 'Lhuntse', 'LHU', 0), (389, 25, 'Mongar', 'MON', 0), (390, 25, 'Paro', 'PAR', 0), (391, 25, 'Pemagatshel', 'PEM', 0), (392, 25, 'Punakha', 'PUN', 0), (393, 25, 'Samdrup Jongkhar', 'SJO', 0), (394, 25, 'Samtse', 'SAT', 0), (395, 25, 'Sarpang', 'SAR', 0), (396, 25, 'Thimphu', 'THI', 0), (397, 25, 'Trashigang', 'TRG', 0), (398, 25, 'Trashiyangste', 'TRY', 0), (399, 25, 'Trongsa', 'TRO', 0), (400, 25, 'Tsirang', 'TSI', 0), (401, 25, 'Wangdue Phodrang', 'WPH', 0), (402, 25, 'Zhemgang', 'ZHE', 0), (403, 26, 'Beni', 'BEN', 0), (404, 26, 'Chuquisaca', 'CHU', 0), (405, 26, 'Cochabamba', 'COC', 0), (406, 26, 'La Paz', 'LPZ', 0), (407, 26, 'Oruro', 'ORU', 0), (408, 26, 'Pando', 'PAN', 0), (409, 26, 'Potosi', 'POT', 0), (410, 26, 'Santa Cruz', 'SCZ', 0), (411, 26, 'Tarija', 'TAR', 0), (412, 27, 'Brcko district', 'BRO', 0), (413, 27, 'Unsko-Sanski Kanton', 'FUS', 0), (414, 27, 'Posavski Kanton', 'FPO', 0), (415, 27, 'Tuzlanski Kanton', 'FTU', 0), (416, 27, 'Zenicko-Dobojski Kanton', 'FZE', 0), (417, 27, 'Bosanskopodrinjski Kanton', 'FBP', 0), (418, 27, 'Srednjebosanski Kanton', 'FSB', 0), (419, 27, 'Hercegovacko-neretvanski Kanton', 'FHN', 0), (420, 27, 'Zapadnohercegovacka Zupanija', 'FZH', 0), (421, 27, 'Kanton Sarajevo', 'FSA', 0), (422, 27, 'Zapadnobosanska', 'FZA', 0), (423, 27, 'Banja Luka', 'SBL', 0), (424, 27, 'Doboj', 'SDO', 0), (425, 27, 'Bijeljina', 'SBI', 0), (426, 27, 'Vlasenica', 'SVL', 0), (427, 27, 'Sarajevo-Romanija or Sokolac', 'SSR', 0), (428, 27, 'Foca', 'SFO', 0), (429, 27, 'Trebinje', 'STR', 0), (430, 28, 'Central', 'CE', 0), (431, 28, 'Ghanzi', 'GH', 0), (432, 28, 'Kgalagadi', 'KD', 0), (433, 28, 'Kgatleng', 'KT', 0), (434, 28, 'Kweneng', 'KW', 0), (435, 28, 'Ngamiland', 'NG', 0), (436, 28, 'North East', 'NE', 0), (437, 28, 'North West', 'NW', 0), (438, 28, 'South East', 'SE', 0), (439, 28, 'Southern', 'SO', 0), (440, 30, 'Acre', 'AC', 0), (441, 30, 'Alagoas', 'AL', 0), (442, 30, 'Amapá', 'AP', 0), (443, 30, 'Amazonas', 'AM', 0), (444, 30, 'Bahia', 'BA', 0), (445, 30, 'Ceará', 'CE', 0), (446, 30, 'Distrito Federal', 'DF', 0), (447, 30, 'Espírito Santo', 'ES', 0), (448, 30, 'Goiás', 'GO', 0), (449, 30, 'Maranhão', 'MA', 0), (450, 30, 'Mato Grosso', 'MT', 0), (451, 30, 'Mato Grosso do Sul', 'MS', 0), (452, 30, 'Minas Gerais', 'MG', 0), (453, 30, 'Pará', 'PA', 0), (454, 30, 'Paraíba', 'PB', 0), (455, 30, 'Paraná', 'PR', 0), (456, 30, 'Pernambuco', 'PE', 0), (457, 30, 'Piauí', 'PI', 0), (458, 30, 'Rio de Janeiro', 'RJ', 0), (459, 30, 'Rio Grande do Norte', 'RN', 0), (460, 30, 'Rio Grande do Sul', 'RS', 0), (461, 30, 'Rondônia', 'RO', 0), (462, 30, 'Roraima', 'RR', 0), (463, 30, 'Santa Catarina', 'SC', 0), (464, 30, 'São Paulo', 'SP', 0), (465, 30, 'Sergipe', 'SE', 0), (466, 30, 'Tocantins', 'TO', 0), (467, 31, 'Peros Banhos', 'PB', 0), (468, 31, 'Salomon Islands', 'SI', 0), (469, 31, 'Nelsons Island', 'NI', 0), (470, 31, 'Three Brothers', 'TB', 0), (471, 31, 'Eagle Islands', 'EA', 0), (472, 31, 'Danger Island', 'DI', 0), (473, 31, 'Egmont Islands', 'EG', 0), (474, 31, 'Diego Garcia', 'DG', 0), (475, 32, 'Belait', 'BEL', 0), (476, 32, 'Brunei and Muara', 'BRM', 0), (477, 32, 'Temburong', 'TEM', 0), (478, 32, 'Tutong', 'TUT', 0), (479, 33, 'Blagoevgrad', '', 0), (480, 33, 'Burgas', '', 0), (481, 33, 'Dobrich', '', 0), (482, 33, 'Gabrovo', '', 0), (483, 33, 'Haskovo', '', 0), (484, 33, 'Kardjali', '', 0), (485, 33, 'Kyustendil', '', 0), (486, 33, 'Lovech', '', 0), (487, 33, 'Montana', '', 0), (488, 33, 'Pazardjik', '', 0), (489, 33, 'Pernik', '', 0), (490, 33, 'Pleven', '', 0), (491, 33, 'Plovdiv', '', 0), (492, 33, 'Razgrad', '', 0), (493, 33, 'Shumen', '', 0), (494, 33, 'Silistra', '', 0), (495, 33, 'Sliven', '', 0), (496, 33, 'Smolyan', '', 0), (497, 33, 'Sofia', '', 0), (498, 33, 'Sofia - town', '', 0), (499, 33, 'Stara Zagora', '', 0), (500, 33, 'Targovishte', '', 0), (501, 33, 'Varna', '', 0), (502, 33, 'Veliko Tarnovo', '', 0), (503, 33, 'Vidin', '', 0), (504, 33, 'Vratza', '', 0), (505, 33, 'Yambol', '', 0), (506, 34, 'Bale', 'BAL', 0), (507, 34, 'Bam', 'BAM', 0), (508, 34, 'Banwa', 'BAN', 0), (509, 34, 'Bazega', 'BAZ', 0), (510, 34, 'Bougouriba', 'BOR', 0), (511, 34, 'Boulgou', 'BLG', 0), (512, 34, 'Boulkiemde', 'BOK', 0), (513, 34, 'Comoe', 'COM', 0), (514, 34, 'Ganzourgou', 'GAN', 0), (515, 34, 'Gnagna', 'GNA', 0), (516, 34, 'Gourma', 'GOU', 0), (517, 34, 'Houet', 'HOU', 0), (518, 34, 'Ioba', 'IOA', 0), (519, 34, 'Kadiogo', 'KAD', 0), (520, 34, 'Kenedougou', 'KEN', 0), (521, 34, 'Komondjari', 'KOD', 0), (522, 34, 'Kompienga', 'KOP', 0), (523, 34, 'Kossi', 'KOS', 0), (524, 34, 'Koulpelogo', 'KOL', 0), (525, 34, 'Kouritenga', 'KOT', 0), (526, 34, 'Kourweogo', 'KOW', 0), (527, 34, 'Leraba', 'LER', 0), (528, 34, 'Loroum', 'LOR', 0), (529, 34, 'Mouhoun', 'MOU', 0), (530, 34, 'Nahouri', 'NAH', 0), (531, 34, 'Namentenga', 'NAM', 0), (532, 34, 'Nayala', 'NAY', 0), (533, 34, 'Noumbiel', 'NOU', 0), (534, 34, 'Oubritenga', 'OUB', 0), (535, 34, 'Oudalan', 'OUD', 0), (536, 34, 'Passore', 'PAS', 0), (537, 34, 'Poni', 'PON', 0), (538, 34, 'Sanguie', 'SAG', 0), (539, 34, 'Sanmatenga', 'SAM', 0), (540, 34, 'Seno', 'SEN', 0), (541, 34, 'Sissili', 'SIS', 0), (542, 34, 'Soum', 'SOM', 0), (543, 34, 'Sourou', 'SOR', 0), (544, 34, 'Tapoa', 'TAP', 0), (545, 34, 'Tuy', 'TUY', 0), (546, 34, 'Yagha', 'YAG', 0), (547, 34, 'Yatenga', 'YAT', 0), (548, 34, 'Ziro', 'ZIR', 0), (549, 34, 'Zondoma', 'ZOD', 0), (550, 34, 'Zoundweogo', 'ZOW', 0), (551, 35, 'Bubanza', 'BB', 0), (552, 35, 'Bujumbura', 'BJ', 0), (553, 35, 'Bururi', 'BR', 0), (554, 35, 'Cankuzo', 'CA', 0), (555, 35, 'Cibitoke', 'CI', 0), (556, 35, 'Gitega', 'GI', 0), (557, 35, 'Karuzi', 'KR', 0), (558, 35, 'Kayanza', 'KY', 0), (559, 35, 'Kirundo', 'KI', 0), (560, 35, 'Makamba', 'MA', 0), (561, 35, 'Muramvya', 'MU', 0), (562, 35, 'Muyinga', 'MY', 0), (563, 35, 'Mwaro', 'MW', 0), (564, 35, 'Ngozi', 'NG', 0), (565, 35, 'Rutana', 'RT', 0), (566, 35, 'Ruyigi', 'RY', 0), (567, 36, 'Phnom Penh', 'PP', 0), (568, 36, 'Preah Seihanu (Kompong Som or Sihanoukville)', 'PS', 0), (569, 36, 'Pailin', 'PA', 0), (570, 36, 'Keb', 'KB', 0), (571, 36, 'Banteay Meanchey', 'BM', 0), (572, 36, 'Battambang', 'BA', 0), (573, 36, 'Kampong Cham', 'KM', 0), (574, 36, 'Kampong Chhnang', 'KN', 0), (575, 36, 'Kampong Speu', 'KU', 0), (576, 36, 'Kampong Som', 'KO', 0), (577, 36, 'Kampong Thom', 'KT', 0), (578, 36, 'Kampot', 'KP', 0), (579, 36, 'Kandal', 'KL', 0), (580, 36, 'Kaoh Kong', 'KK', 0), (581, 36, 'Kratie', 'KR', 0), (582, 36, 'Mondul Kiri', 'MK', 0), (583, 36, 'Oddar Meancheay', 'OM', 0), (584, 36, 'Pursat', 'PU', 0), (585, 36, 'Preah Vihear', 'PR', 0), (586, 36, 'Prey Veng', 'PG', 0), (587, 36, 'Ratanak Kiri', 'RK', 0), (588, 36, 'Siemreap', 'SI', 0), (589, 36, 'Stung Treng', 'ST', 0), (590, 36, 'Svay Rieng', 'SR', 0), (591, 36, 'Takeo', 'TK', 0), (592, 37, 'Adamawa (Adamaoua)', 'ADA', 0), (593, 37, 'Centre', 'CEN', 0), (594, 37, 'East (Est)', 'EST', 0), (595, 37, 'Extreme North (Extreme-Nord)', 'EXN', 0), (596, 37, 'Littoral', 'LIT', 0), (597, 37, 'North (Nord)', 'NOR', 0), (598, 37, 'Northwest (Nord-Ouest)', 'NOT', 0), (599, 37, 'West (Ouest)', 'OUE', 0), (600, 37, 'South (Sud)', 'SUD', 0), (601, 37, 'Southwest (Sud-Ouest).', 'SOU', 0), (602, 38, 'Alberta', 'AB', 0), (603, 38, 'British Columbia', 'BC', 0), (604, 38, 'Manitoba', 'MB', 0), (605, 38, 'New Brunswick', 'NB', 0), (606, 38, 'Newfoundland and Labrador', 'NL', 0), (607, 38, 'Northwest Territories', 'NT', 0), (608, 38, 'Nova Scotia', 'NS', 0), (609, 38, 'Nunavut', 'NU', 0), (610, 38, 'Ontario', 'ON', 0), (611, 38, 'Prince Edward Island', 'PE', 0), (612, 38, 'Québec', 'QC', 0), (613, 38, 'Saskatchewan', 'SK', 0), (614, 38, 'Yukon Territory', 'YT', 0), (615, 39, 'Boa Vista', 'BV', 0), (616, 39, 'Brava', 'BR', 0), (617, 39, 'Calheta de Sao Miguel', 'CS', 0), (618, 39, 'Maio', 'MA', 0), (619, 39, 'Mosteiros', 'MO', 0), (620, 39, 'Paul', 'PA', 0), (621, 39, 'Porto Novo', 'PN', 0), (622, 39, 'Praia', 'PR', 0), (623, 39, 'Ribeira Grande', 'RG', 0), (624, 39, 'Sal', 'SL', 0), (625, 39, 'Santa Catarina', 'CA', 0), (626, 39, 'Santa Cruz', 'CR', 0), (627, 39, 'Sao Domingos', 'SD', 0), (628, 39, 'Sao Filipe', 'SF', 0), (629, 39, 'Sao Nicolau', 'SN', 0), (630, 39, 'Sao Vicente', 'SV', 0), (631, 39, 'Tarrafal', 'TA', 0), (632, 40, 'Creek', 'CR', 0), (633, 40, 'Eastern', 'EA', 0), (634, 40, 'Midland', 'ML', 0), (635, 40, 'South Town', 'ST', 0), (636, 40, 'Spot Bay', 'SP', 0), (637, 40, 'Stake Bay', 'SK', 0), (638, 40, 'West End', 'WD', 0), (639, 40, 'Western', 'WN', 0), (640, 41, 'Bamingui-Bangoran', 'BBA', 0), (641, 41, 'Basse-Kotto', 'BKO', 0), (642, 41, 'Haute-Kotto', 'HKO', 0), (643, 41, 'Haut-Mbomou', 'HMB', 0), (644, 41, 'Kemo', 'KEM', 0), (645, 41, 'Lobaye', 'LOB', 0), (646, 41, 'Mambere-KadeÔ', 'MKD', 0), (647, 41, 'Mbomou', 'MBO', 0), (648, 41, 'Nana-Mambere', 'NMM', 0), (649, 41, 'Ombella-MPoko', 'OMP', 0), (650, 41, 'Ouaka', 'OUK', 0), (651, 41, 'Ouham', 'OUH', 0), (652, 41, 'Ouham-Pende', 'OPE', 0), (653, 41, 'Vakaga', 'VAK', 0), (654, 41, 'Nana-Grebizi', 'NGR', 0), (655, 41, 'Sangha-Mbaere', 'SMB', 0), (656, 41, 'Bangui', 'BAN', 0), (657, 42, 'Batha', 'BA', 0), (658, 42, 'Biltine', 'BI', 0), (659, 42, 'Borkou-Ennedi-Tibesti', 'BE', 0), (660, 42, 'Chari-Baguirmi', 'CB', 0), (661, 42, 'Guera', 'GU', 0), (662, 42, 'Kanem', 'KA', 0), (663, 42, 'Lac', 'LA', 0), (664, 42, 'Logone Occidental', 'LC', 0), (665, 42, 'Logone Oriental', 'LR', 0), (666, 42, 'Mayo-Kebbi', 'MK', 0), (667, 42, 'Moyen-Chari', 'MC', 0), (668, 42, 'Ouaddai', 'OU', 0), (669, 42, 'Salamat', 'SA', 0), (670, 42, 'Tandjile', 'TA', 0), (671, 43, 'Aisen del General Carlos Ibanez', 'AI', 0), (672, 43, 'Antofagasta', 'AN', 0), (673, 43, 'Araucania', 'AR', 0), (674, 43, 'Atacama', 'AT', 0), (675, 43, 'Bio-Bio', 'BI', 0), (676, 43, 'Coquimbo', 'CO', 0), (677, 43, 'Libertador General Bernardo OHiggins', 'LI', 0), (678, 43, 'Los Lagos', 'LL', 0), (679, 43, 'Magallanes y de la Antartica Chilena', 'MA', 0), (680, 43, 'Maule', 'ML', 0), (681, 43, 'region Metropolitana', 'RM', 0), (682, 43, 'Tarapaca', 'TA', 0), (683, 43, 'Valparaiso', 'VS', 0), (684, 44, 'Anhui', 'AN', 0), (685, 44, 'Beijing', 'BE', 0), (686, 44, 'Chongqing', 'CH', 0), (687, 44, 'Fujian', 'FU', 0), (688, 44, 'Gansu', 'GA', 0), (689, 44, 'Guangdong', 'GU', 0), (690, 44, 'Guangxi', 'GX', 0), (691, 44, 'Guizhou', 'GZ', 0), (692, 44, 'Hainan', 'HA', 0), (693, 44, 'Hebei', 'HB', 0), (694, 44, 'Heilongjiang', 'HL', 0), (695, 44, 'Henan', 'HE', 0), (696, 44, 'Hong Kong', 'HK', 0), (697, 44, 'Hubei', 'HU', 0), (698, 44, 'Hunan', 'HN', 0), (699, 44, 'Inner Mongolia', 'IM', 0), (700, 44, 'Jiangsu', 'JI', 0), (701, 44, 'Jiangxi', 'JX', 0), (702, 44, 'Jilin', 'JL', 0), (703, 44, 'Liaoning', 'LI', 0), (704, 44, 'Macau', 'MA', 0), (705, 44, 'Ningxia', 'NI', 0), (706, 44, 'Shaanxi', 'SH', 0), (707, 44, 'Shandong', 'SA', 0), (708, 44, 'Shanghai', 'SG', 0), (709, 44, 'Shanxi', 'SX', 0), (710, 44, 'Sichuan', 'SI', 0), (711, 44, 'Tianjin', 'TI', 0), (712, 44, 'Xinjiang', 'XI', 0), (713, 44, 'Yunnan', 'YU', 0), (714, 44, 'Zhejiang', 'ZH', 0), (715, 46, 'Direction Island', 'D', 0), (716, 46, 'Home Island', 'H', 0), (717, 46, 'Horsburgh Island', 'O', 0), (718, 46, 'South Island', 'S', 0), (719, 46, 'West Island', 'W', 0), (720, 47, 'Amazonas', 'AMA', 0), (721, 47, 'Antioquia', 'ANT', 0), (722, 47, 'Arauca', 'ARA', 0), (723, 47, 'Atlantico', 'ATL', 0), (724, 47, 'Bogota D.C.', 'DC', 0), (725, 47, 'Bolivar', 'BOL', 0), (726, 47, 'Boyaca', 'BOY', 0), (727, 47, 'Caldas', 'CAL', 0), (728, 47, 'Caqueta', 'CAQ', 0), (729, 47, 'Casanare', 'CAS', 0), (730, 47, 'Cauca', 'CAU', 0), (731, 47, 'Cesar', 'CES', 0), (732, 47, 'Choco', 'CHO', 0), (733, 47, 'Cordoba', 'COR', 0), (734, 47, 'Cundinamarca', 'CUN', 0), (735, 47, 'Guainia', 'GNA', 0), (736, 47, 'Guajira', 'GJR', 0), (737, 47, 'Guaviare', 'GUV', 0), (738, 47, 'Huila', 'HUI', 0), (739, 47, 'Magdalena', 'MAG', 0), (740, 47, 'Meta', 'MET', 0), (741, 47, 'Narino', 'NAR', 0), (742, 47, 'Norte de Santander', 'NSA', 0), (743, 47, 'Putumayo', 'PUT', 0), (744, 47, 'Quindio', 'QUI', 0), (745, 47, 'Risaralda', 'RIS', 0), (746, 47, 'San Andres y Providencia', 'SAP', 0), (747, 47, 'Santander', 'SAN', 0), (748, 47, 'Sucre', 'SUC', 0), (749, 47, 'Tolima', 'TOL', 0), (750, 47, 'Valle del Cauca', 'VAC', 0), (751, 47, 'Vaupes', 'VAU', 0), (752, 47, 'Vichada', 'VID', 0), (753, 48, 'Grande Comore', 'G', 0), (754, 48, 'Anjouan', 'A', 0), (755, 48, 'Moheli', 'M', 0), (756, 49, 'Bouenza', 'BO', 0), (757, 49, 'Brazzaville', 'BR', 0), (758, 49, 'Cuvette', 'CU', 0), (759, 49, 'Cuvette-Ouest', 'CO', 0), (760, 49, 'Kouilou', 'KO', 0), (761, 49, 'Lekoumou', 'LE', 0), (762, 49, 'Likouala', 'LI', 0), (763, 49, 'Niari', 'NI', 0), (764, 49, 'Plateaux', 'PL', 0), (765, 49, 'Pool', 'PO', 0), (766, 49, 'Sangha', 'SA', 0), (767, 50, 'Pukapuka', 'PU', 0), (768, 50, 'Rakahanga', 'RK', 0), (769, 50, 'Manihiki', 'MK', 0), (770, 50, 'Penrhyn', 'PE', 0), (771, 50, 'Nassau Island', 'NI', 0), (772, 50, 'Surwarrow', 'SU', 0), (773, 50, 'Palmerston', 'PA', 0), (774, 50, 'Aitutaki', 'AI', 0), (775, 50, 'Manuae', 'MA', 0), (776, 50, 'Takutea', 'TA', 0), (777, 50, 'Mitiaro', 'MT', 0), (778, 50, 'Atiu', 'AT', 0), (779, 50, 'Mauke', 'MU', 0), (780, 50, 'Rarotonga', 'RR', 0), (781, 50, 'Mangaia', 'MG', 0), (782, 51, 'Alajuela', 'AL', 0), (783, 51, 'Cartago', 'CA', 0), (784, 51, 'Guanacaste', 'GU', 0), (785, 51, 'Heredia', 'HE', 0), (786, 51, 'Limon', 'LI', 0), (787, 51, 'Puntarenas', 'PU', 0), (788, 51, 'San Jose', 'SJ', 0), (789, 52, 'Abengourou', 'ABE', 0), (790, 52, 'Abidjan', 'ABI', 0), (791, 52, 'Aboisso', 'ABO', 0), (792, 52, 'Adiake', 'ADI', 0), (793, 52, 'Adzope', 'ADZ', 0), (794, 52, 'Agboville', 'AGB', 0), (795, 52, 'Agnibilekrou', 'AGN', 0), (796, 52, 'Alepe', 'ALE', 0), (797, 52, 'Bocanda', 'BOC', 0), (798, 52, 'Bangolo', 'BAN', 0), (799, 52, 'Beoumi', 'BEO', 0), (800, 52, 'Biankouma', 'BIA', 0), (801, 52, 'Bondoukou', 'BDK', 0), (802, 52, 'Bongouanou', 'BGN', 0), (803, 52, 'Bouafle', 'BFL', 0), (804, 52, 'Bouake', 'BKE', 0), (805, 52, 'Bouna', 'BNA', 0), (806, 52, 'Boundiali', 'BDL', 0), (807, 52, 'Dabakala', 'DKL', 0), (808, 52, 'Dabou', 'DBU', 0), (809, 52, 'Daloa', 'DAL', 0), (810, 52, 'Danane', 'DAN', 0), (811, 52, 'Daoukro', 'DAO', 0), (812, 52, 'Dimbokro', 'DIM', 0), (813, 52, 'Divo', 'DIV', 0), (814, 52, 'Duekoue', 'DUE', 0), (815, 52, 'Ferkessedougou', 'FER', 0), (816, 52, 'Gagnoa', 'GAG', 0), (817, 52, 'Grand-Bassam', 'GBA', 0), (818, 52, 'Grand-Lahou', 'GLA', 0), (819, 52, 'Guiglo', 'GUI', 0), (820, 52, 'Issia', 'ISS', 0), (821, 52, 'Jacqueville', 'JAC', 0), (822, 52, 'Katiola', 'KAT', 0), (823, 52, 'Korhogo', 'KOR', 0), (824, 52, 'Lakota', 'LAK', 0), (825, 52, 'Man', 'MAN', 0), (826, 52, 'Mankono', 'MKN', 0), (827, 52, 'Mbahiakro', 'MBA', 0), (828, 52, 'Odienne', 'ODI', 0), (829, 52, 'Oume', 'OUM', 0), (830, 52, 'Sakassou', 'SAK', 0), (831, 52, 'San-Pedro', 'SPE', 0), (832, 52, 'Sassandra', 'SAS', 0), (833, 52, 'Seguela', 'SEG', 0), (834, 52, 'Sinfra', 'SIN', 0), (835, 52, 'Soubre', 'SOU', 0), (836, 52, 'Tabou', 'TAB', 0), (837, 52, 'Tanda', 'TAN', 0), (838, 52, 'Tiebissou', 'TIE', 0), (839, 52, 'Tingrela', 'TIN', 0), (840, 52, 'Tiassale', 'TIA', 0), (841, 52, 'Touba', 'TBA', 0), (842, 52, 'Toulepleu', 'TLP', 0), (843, 52, 'Toumodi', 'TMD', 0), (844, 52, 'Vavoua', 'VAV', 0), (845, 52, 'Yamoussoukro', 'YAM', 0), (846, 52, 'Zuenoula', 'ZUE', 0), (847, 53, 'Bjelovarsko-bilogorska', 'BB', 0), (848, 53, 'Grad Zagreb', 'GZ', 0), (849, 53, 'Dubrovačko-neretvanska', 'DN', 0), (850, 53, 'Istarska', 'IS', 0), (851, 53, 'Karlovačka', 'KA', 0), (852, 53, 'Koprivničko-križevačka', 'KK', 0), (853, 53, 'Krapinsko-zagorska', 'KZ', 0), (854, 53, 'Ličko-senjska', 'LS', 0), (855, 53, 'Međimurska', 'ME', 0), (856, 53, 'Osječko-baranjska', 'OB', 0), (857, 53, 'Požeško-slavonska', 'PS', 0), (858, 53, 'Primorsko-goranska', 'PG', 0), (859, 53, 'Šibensko-kninska', 'SK', 0), (860, 53, 'Sisačko-moslavačka', 'SM', 0), (861, 53, 'Brodsko-posavska', 'BP', 0), (862, 53, 'Splitsko-dalmatinska', 'SD', 0), (863, 53, 'Varaždinska', 'VA', 0), (864, 53, 'Virovitičko-podravska', 'VP', 0), (865, 53, 'Vukovarsko-srijemska', 'VS', 0), (866, 53, 'Zadarska', 'ZA', 0), (867, 53, 'Zagrebačka', 'ZG', 0), (868, 54, 'Camaguey', 'CA', 0), (869, 54, 'Ciego de Avila', 'CD', 0), (870, 54, 'Cienfuegos', 'CI', 0), (871, 54, 'Ciudad de La Habana', 'CH', 0), (872, 54, 'Granma', 'GR', 0), (873, 54, 'Guantanamo', 'GU', 0), (874, 54, 'Holguin', 'HO', 0), (875, 54, 'Isla de la Juventud', 'IJ', 0), (876, 54, 'La Habana', 'LH', 0), (877, 54, 'Las Tunas', 'LT', 0), (878, 54, 'Matanzas', 'MA', 0), (879, 54, 'Pinar del Rio', 'PR', 0), (880, 54, 'Sancti Spiritus', 'SS', 0), (881, 54, 'Santiago de Cuba', 'SC', 0), (882, 54, 'Villa Clara', 'VC', 0), (883, 55, 'Famagusta', 'F', 0), (884, 55, 'Kyrenia', 'K', 0), (885, 55, 'Larnaca', 'A', 0), (886, 55, 'Limassol', 'I', 0), (887, 55, 'Nicosia', 'N', 0), (888, 55, 'Paphos', 'P', 0), (889, 56, 'Ústecký', 'U', 0), (890, 56, 'Jihočeský', 'C', 0), (891, 56, 'Jihomoravský', 'B', 0), (892, 56, 'Karlovarský', 'K', 0), (893, 56, 'Královehradecký', 'H', 0), (894, 56, 'Liberecký', 'L', 0), (895, 56, 'Moravskoslezský', 'T', 0), (896, 56, 'Olomoucký', 'M', 0), (897, 56, 'Pardubický', 'E', 0), (898, 56, 'Plzeňský', 'P', 0), (899, 56, 'Praha', 'A', 0), (900, 56, 'Středočeský', 'S', 0), (901, 56, 'Vysočina', 'J', 0), (902, 56, 'Zlínský', 'Z', 0), (903, 57, 'Nordjyland', '81', 0), (904, 57, 'Midtjylland', '82', 0), (905, 57, 'Syddanmark', '83', 0), (906, 57, 'Faroe Islands', 'FO', 0), (907, 57, 'Hovedstaden', '84', 0), (908, 57, 'Sjælland', '85', 0), (919, 58, 'Ali Sabih', 'S', 0), (920, 58, 'Dikhil', 'K', 0), (921, 58, 'Djibouti', 'J', 0), (922, 58, 'Obock', 'O', 0), (923, 58, 'Tadjoura', 'T', 0), (924, 59, 'Saint Andrew Parish', 'AND', 0), (925, 59, 'Saint David Parish', 'DAV', 0), (926, 59, 'Saint George Parish', 'GEO', 0), (927, 59, 'Saint John Parish', 'JOH', 0), (928, 59, 'Saint Joseph Parish', 'JOS', 0), (929, 59, 'Saint Luke Parish', 'LUK', 0), (930, 59, 'Saint Mark Parish', 'MAR', 0), (931, 59, 'Saint Patrick Parish', 'PAT', 0), (932, 59, 'Saint Paul Parish', 'PAU', 0), (933, 59, 'Saint Peter Parish', 'PET', 0), (934, 60, 'Distrito Nacional', 'DN', 0), (935, 60, 'Azua', 'AZ', 0), (936, 60, 'Baoruco', 'BC', 0), (937, 60, 'Barahona', 'BH', 0), (938, 60, 'Dajabon', 'DJ', 0), (939, 60, 'Duarte', 'DU', 0), (940, 60, 'Elias Pina', 'EL', 0), (941, 60, 'El Seybo', 'SY', 0), (942, 60, 'Espaillat', 'ET', 0), (943, 60, 'Hato Mayor', 'HM', 0), (944, 60, 'Independencia', 'IN', 0), (945, 60, 'La Altagracia', 'AL', 0), (946, 60, 'La Romana', 'RO', 0), (947, 60, 'La Vega', 'VE', 0), (948, 60, 'Maria Trinidad Sanchez', 'MT', 0), (949, 60, 'Monsenor Nouel', 'MN', 0), (950, 60, 'Monte Cristi', 'MC', 0), (951, 60, 'Monte Plata', 'MP', 0), (952, 60, 'Pedernales', 'PD', 0), (953, 60, 'Peravia (Bani)', 'PR', 0), (954, 60, 'Puerto Plata', 'PP', 0), (955, 60, 'Salcedo', 'SL', 0), (956, 60, 'Samana', 'SM', 0), (957, 60, 'Sanchez Ramirez', 'SH', 0), (958, 60, 'San Cristobal', 'SC', 0), (959, 60, 'San Jose de Ocoa', 'JO', 0), (960, 60, 'San Juan', 'SJ', 0), (961, 60, 'San Pedro de Macoris', 'PM', 0), (962, 60, 'Santiago', 'SA', 0), (963, 60, 'Santiago Rodriguez', 'ST', 0), (964, 60, 'Santo Domingo', 'SD', 0), (965, 60, 'Valverde', 'VA', 0), (966, 61, 'Aileu', 'AL', 0), (967, 61, 'Ainaro', 'AN', 0), (968, 61, 'Baucau', 'BA', 0), (969, 61, 'Bobonaro', 'BO', 0), (970, 61, 'Cova Lima', 'CO', 0), (971, 61, 'Dili', 'DI', 0), (972, 61, 'Ermera', 'ER', 0), (973, 61, 'Lautem', 'LA', 0), (974, 61, 'Liquica', 'LI', 0), (975, 61, 'Manatuto', 'MT', 0), (976, 61, 'Manufahi', 'MF', 0), (977, 61, 'Oecussi', 'OE', 0), (978, 61, 'Viqueque', 'VI', 0), (979, 62, 'Azuay', 'AZU', 0), (980, 62, 'Bolivar', 'BOL', 0), (981, 62, 'Cañar', 'CAN', 0), (982, 62, 'Carchi', 'CAR', 0), (983, 62, 'Chimborazo', 'CHI', 0), (984, 62, 'Cotopaxi', 'COT', 0), (985, 62, 'El Oro', 'EOR', 0), (986, 62, 'Esmeraldas', 'ESM', 0), (987, 62, 'Galápagos', 'GPS', 0), (988, 62, 'Guayas', 'GUA', 0), (989, 62, 'Imbabura', 'IMB', 0), (990, 62, 'Loja', 'LOJ', 0), (991, 62, 'Los Rios', 'LRO', 0), (992, 62, 'Manabí', 'MAN', 0), (993, 62, 'Morona Santiago', 'MSA', 0), (994, 62, 'Napo', 'NAP', 0), (995, 62, 'Orellana', 'ORE', 0), (996, 62, 'Pastaza', 'PAS', 0), (997, 62, 'Pichincha', 'PIC', 0), (998, 62, 'Sucumbíos', 'SUC', 0), (999, 62, 'Tungurahua', 'TUN', 0), (1000, 62, 'Zamora Chinchipe', 'ZCH', 0), (1001, 63, 'Ad Daqahliyah', 'DHY', 0), (1002, 63, 'Al Bahr al Ahmar', 'BAM', 0), (1003, 63, 'Al Buhayrah', 'BHY', 0), (1004, 63, 'Al Fayyum', 'FYM', 0), (1005, 63, 'Al Gharbiyah', 'GBY', 0), (1006, 63, 'Al Iskandariyah', 'IDR', 0), (1007, 63, 'Al Ismailiyah', 'IML', 0), (1008, 63, 'Al Jizah', 'JZH', 0), (1009, 63, 'Al Minufiyah', 'MFY', 0), (1010, 63, 'Al Minya', 'MNY', 0), (1011, 63, 'Al Qahirah', 'QHR', 0), (1012, 63, 'Al Qalyubiyah', 'QLY', 0), (1013, 63, 'Al Wadi al Jadid', 'WJD', 0), (1014, 63, 'Ash Sharqiyah', 'SHQ', 0), (1015, 63, 'As Suways', 'SWY', 0), (1016, 63, 'Aswan', 'ASW', 0), (1017, 63, 'Asyut', 'ASY', 0), (1018, 63, 'Bani Suwayf', 'BSW', 0), (1019, 63, 'Bur Said', 'BSD', 0), (1020, 63, 'Dumyat', 'DMY', 0), (1021, 63, 'Janub Sina', 'JNS', 0), (1022, 63, 'Kafr ash Shaykh', 'KSH', 0), (1023, 63, 'Matruh', 'MAT', 0), (1024, 63, 'Qina', 'QIN', 0), (1025, 63, 'Shamal Sina', 'SHS', 0), (1026, 63, 'Suhaj', 'SUH', 0), (1027, 64, 'Ahuachapan', 'AH', 0), (1028, 64, 'Cabanas', 'CA', 0), (1029, 64, 'Chalatenango', 'CH', 0), (1030, 64, 'Cuscatlan', 'CU', 0), (1031, 64, 'La Libertad', 'LB', 0), (1032, 64, 'La Paz', 'PZ', 0), (1033, 64, 'La Union', 'UN', 0), (1034, 64, 'Morazan', 'MO', 0), (1035, 64, 'San Miguel', 'SM', 0), (1036, 64, 'San Salvador', 'SS', 0), (1037, 64, 'San Vicente', 'SV', 0), (1038, 64, 'Santa Ana', 'SA', 0), (1039, 64, 'Sonsonate', 'SO', 0), (1040, 64, 'Usulutan', 'US', 0), (1041, 65, 'Provincia Annobon', 'AN', 0), (1042, 65, 'Provincia Bioko Norte', 'BN', 0), (1043, 65, 'Provincia Bioko Sur', 'BS', 0), (1044, 65, 'Provincia Centro Sur', 'CS', 0), (1045, 65, 'Provincia Kie-Ntem', 'KN', 0), (1046, 65, 'Provincia Litoral', 'LI', 0), (1047, 65, 'Provincia Wele-Nzas', 'WN', 0), (1048, 66, 'Central (Maekel)', 'MA', 0), (1049, 66, 'Anseba (Keren)', 'KE', 0), (1050, 66, 'Southern Red Sea (Debub-Keih-Bahri)', 'DK', 0), (1051, 66, 'Northern Red Sea (Semien-Keih-Bahri)', 'SK', 0), (1052, 66, 'Southern (Debub)', 'DE', 0), (1053, 66, 'Gash-Barka (Barentu)', 'BR', 0), (1054, 67, 'Harjumaa (Tallinn)', 'HA', 0), (1055, 67, 'Hiiumaa (Kardla)', 'HI', 0), (1056, 67, 'Ida-Virumaa (Johvi)', 'IV', 0), (1057, 67, 'Jarvamaa (Paide)', 'JA', 0), (1058, 67, 'Jogevamaa (Jogeva)', 'JO', 0), (1059, 67, 'Laane-Virumaa (Rakvere)', 'LV', 0), (1060, 67, 'Laanemaa (Haapsalu)', 'LA', 0), (1061, 67, 'Parnumaa (Parnu)', 'PA', 0), (1062, 67, 'Polvamaa (Polva)', 'PO', 0), (1063, 67, 'Raplamaa (Rapla)', 'RA', 0), (1064, 67, 'Saaremaa (Kuessaare)', 'SA', 0), (1065, 67, 'Tartumaa (Tartu)', 'TA', 0), (1066, 67, 'Valgamaa (Valga)', 'VA', 0), (1067, 67, 'Viljandimaa (Viljandi)', 'VI', 0), (1068, 67, 'Vorumaa (Voru)', 'VO', 0), (1069, 68, 'Afar', 'AF', 0), (1070, 68, 'Amhara', 'AH', 0), (1071, 68, 'Benishangul-Gumaz', 'BG', 0), (1072, 68, 'Gambela', 'GB', 0), (1073, 68, 'Hariai', 'HR', 0), (1074, 68, 'Oromia', 'OR', 0), (1075, 68, 'Somali', 'SM', 0), (1076, 68, 'Southern Nations - Nationalities and Peoples Region', 'SN', 0), (1077, 68, 'Tigray', 'TG', 0), (1078, 68, 'Addis Ababa', 'AA', 0), (1079, 68, 'Dire Dawa', 'DD', 0), (1080, 71, 'Central Division', 'C', 0), (1081, 71, 'Northern Division', 'N', 0), (1082, 71, 'Eastern Division', 'E', 0), (1083, 71, 'Western Division', 'W', 0), (1084, 71, 'Rotuma', 'R', 0), (1085, 72, 'Ahvenanmaan lääni', 'AL', 0), (1086, 72, 'Etelä-Suomen lääni', 'ES', 0), (1087, 72, 'Itä-Suomen lääni', 'IS', 0), (1088, 72, 'Länsi-Suomen lääni', 'LS', 0), (1089, 72, 'Lapin lääni', 'LA', 0), (1090, 72, 'Oulun lääni', 'OU', 0), (1114, 74, 'Ain', '01', 0), (1115, 74, 'Aisne', '02', 0), (1116, 74, 'Allier', '03', 0), (1117, 74, 'Alpes de Haute Provence', '04', 0), (1118, 74, 'Hautes-Alpes', '05', 0), (1119, 74, 'Alpes Maritimes', '06', 0), (1120, 74, 'Ardèche', '07', 0), (1121, 74, 'Ardennes', '08', 0), (1122, 74, 'Ariège', '09', 0), (1123, 74, 'Aube', '10', 0), (1124, 74, 'Aude', '11', 0), (1125, 74, 'Aveyron', '12', 0), (1126, 74, 'Bouches du Rhône', '13', 0), (1127, 74, 'Calvados', '14', 0), (1128, 74, 'Cantal', '15', 0), (1129, 74, 'Charente', '16', 0), (1130, 74, 'Charente Maritime', '17', 0), (1131, 74, 'Cher', '18', 0), (1132, 74, 'Corrèze', '19', 0), (1133, 74, 'Corse du Sud', '2A', 0), (1134, 74, 'Haute Corse', '2B', 0), (1135, 74, 'Côte d'or', '21', 0), (1136, 74, 'Côtes d'Armor', '22', 0), (1137, 74, 'Creuse', '23', 0), (1138, 74, 'Dordogne', '24', 0), (1139, 74, 'Doubs', '25', 0), (1140, 74, 'Drôme', '26', 0), (1141, 74, 'Eure', '27', 0), (1142, 74, 'Eure et Loir', '28', 0), (1143, 74, 'Finistère', '29', 0), (1144, 74, 'Gard', '30', 0), (1145, 74, 'Haute Garonne', '31', 0), (1146, 74, 'Gers', '32', 0), (1147, 74, 'Gironde', '33', 0), (1148, 74, 'Hérault', '34', 0), (1149, 74, 'Ille et Vilaine', '35', 0), (1150, 74, 'Indre', '36', 0), (1151, 74, 'Indre et Loire', '37', 0), (1152, 74, 'Isére', '38', 0), (1153, 74, 'Jura', '39', 0), (1154, 74, 'Landes', '40', 0), (1155, 74, 'Loir et Cher', '41', 0), (1156, 74, 'Loire', '42', 0), (1157, 74, 'Haute Loire', '43', 0), (1158, 74, 'Loire Atlantique', '44', 0), (1159, 74, 'Loiret', '45', 0), (1160, 74, 'Lot', '46', 0), (1161, 74, 'Lot et Garonne', '47', 0), (1162, 74, 'Lozère', '48', 0), (1163, 74, 'Maine et Loire', '49', 0), (1164, 74, 'Manche', '50', 0), (1165, 74, 'Marne', '51', 0), (1166, 74, 'Haute Marne', '52', 0), (1167, 74, 'Mayenne', '53', 0), (1168, 74, 'Meurthe et Moselle', '54', 0), (1169, 74, 'Meuse', '55', 0), (1170, 74, 'Morbihan', '56', 0), (1171, 74, 'Moselle', '57', 0), (1172, 74, 'Nièvre', '58', 0), (1173, 74, 'Nord', '59', 0), (1174, 74, 'Oise', '60', 0), (1175, 74, 'Orne', '61', 0), (1176, 74, 'Pas de Calais', '62', 0), (1177, 74, 'Puy de Dôme', '63', 0), (1178, 74, 'Pyrénées Atlantiques', '64', 0), (1179, 74, 'Hautes Pyrénées', '65', 0), (1180, 74, 'Pyrénées Orientales', '66', 0), (1181, 74, 'Bas Rhin', '67', 0), (1182, 74, 'Haut Rhin', '68', 0), (1183, 74, 'Rhône', '69', 0), (1184, 74, 'Haute Saône', '70', 0), (1185, 74, 'Saône et Loire', '71', 0), (1186, 74, 'Sarthe', '72', 0), (1187, 74, 'Savoie', '73', 0), (1188, 74, 'Haute Savoie', '74', 0), (1189, 74, 'Paris', '75', 0), (1190, 74, 'Seine Maritime', '76', 0), (1191, 74, 'Seine et Marne', '77', 0), (1192, 74, 'Yvelines', '78', 0), (1193, 74, 'Deux Sèvres', '79', 0), (1194, 74, 'Somme', '80', 0), (1195, 74, 'Tarn', '81', 0), (1196, 74, 'Tarn et Garonne', '82', 0), (1197, 74, 'Var', '83', 0), (1198, 74, 'Vaucluse', '84', 0), (1199, 74, 'Vendée', '85', 0), (1200, 74, 'Vienne', '86', 0), (1201, 74, 'Haute Vienne', '87', 0), (1202, 74, 'Vosges', '88', 0), (1203, 74, 'Yonne', '89', 0), (1204, 74, 'Territoire de Belfort', '90', 0), (1205, 74, 'Essonne', '91', 0), (1206, 74, 'Hauts de Seine', '92', 0), (1207, 74, 'Seine St-Denis', '93', 0), (1208, 74, 'Val de Marne', '94', 0), (1209, 74, 'Val dOise', '95', 0), (1210, 76, 'Archipel des Marquises', 'M', 0), (1211, 76, 'Archipel des Tuamotu', 'T', 0), (1212, 76, 'Archipel des Tubuai', 'I', 0), (1213, 76, 'Iles du Vent', 'V', 0), (1214, 76, 'Iles Sous-le-Vent', 'S', 0), (1215, 77, 'Iles Crozet', 'C', 0), (1216, 77, 'Iles Kerguelen', 'K', 0), (1217, 77, 'Ile Amsterdam', 'A', 0), (1218, 77, 'Ile Saint-Paul', 'P', 0), (1219, 77, 'Adelie Land', 'D', 0), (1220, 78, 'Estuaire', 'ES', 0), (1221, 78, 'Haut-Ogooue', 'HO', 0), (1222, 78, 'Moyen-Ogooue', 'MO', 0), (1223, 78, 'Ngounie', 'NG', 0), (1224, 78, 'Nyanga', 'NY', 0), (1225, 78, 'Ogooue-Ivindo', 'OI', 0), (1226, 78, 'Ogooue-Lolo', 'OL', 0), (1227, 78, 'Ogooue-Maritime', 'OM', 0), (1228, 78, 'Woleu-Ntem', 'WN', 0), (1229, 79, 'Banjul', 'BJ', 0), (1230, 79, 'Basse', 'BS', 0), (1231, 79, 'Brikama', 'BR', 0), (1232, 79, 'Janjangbure', 'JA', 0), (1233, 79, 'Kanifeng', 'KA', 0), (1234, 79, 'Kerewan', 'KE', 0), (1235, 79, 'Kuntaur', 'KU', 0), (1236, 79, 'Mansakonko', 'MA', 0), (1237, 79, 'Lower River', 'LR', 0), (1238, 79, 'Central River', 'CR', 0), (1239, 79, 'North Bank', 'NB', 0), (1240, 79, 'Upper River', 'UR', 0), (1241, 79, 'Western', 'WE', 0), (1242, 80, 'Abkhazia', 'AB', 0), (1243, 80, 'Ajaria', 'AJ', 0), (1244, 80, 'Tbilisi', 'TB', 0), (1245, 80, 'Guria', 'GU', 0), (1246, 80, 'Imereti', 'IM', 0), (1247, 80, 'Kakheti', 'KA', 0), (1248, 80, 'Kvemo Kartli', 'KK', 0), (1249, 80, 'Mtskheta-Mtianeti', 'MM', 0), (1250, 80, 'Racha Lechkhumi and Kvemo Svanet', 'RL', 0), (1251, 80, 'Samegrelo-Zemo Svaneti', 'SZ', 0), (1252, 80, 'Samtskhe-Javakheti', 'SJ', 0), (1253, 80, 'Shida Kartli', 'SK', 0), (1254, 81, 'Baden-Württemberg', 'BW', 0), (1255, 81, 'Bayern', 'BY', 0), (1256, 81, 'Berlin', 'BE', 0), (1257, 81, 'Brandenburg', 'BB', 0), (1258, 81, 'Bremen', 'HB', 0), (1259, 81, 'Hamburg', 'HH', 0), (1260, 81, 'Hessen', 'HE', 0), (1261, 81, 'Mecklenburg-Vorpommern', 'MV', 0), (1262, 81, 'Niedersachsen', 'NI', 0), (1263, 81, 'Nordrhein-Westfalen', 'NW', 0), (1264, 81, 'Rheinland-Pfalz', 'RP', 0), (1265, 81, 'Saarland', 'SL', 0), (1266, 81, 'Sachsen', 'SN', 0), (1267, 81, 'Sachsen-Anhalt', 'ST', 0), (1268, 81, 'Schleswig-Holstein', 'SH', 0), (1269, 81, 'Thüringen', 'TH', 0), (1270, 82, 'Ashanti Region', 'AS', 0), (1271, 82, 'Brong-Ahafo Region', 'BA', 0), (1272, 82, 'Central Region', 'CE', 0), (1273, 82, 'Eastern Region', 'EA', 0), (1274, 82, 'Greater Accra Region', 'GA', 0), (1275, 82, 'Northern Region', 'NO', 0), (1276, 82, 'Upper East Region', 'UE', 0), (1277, 82, 'Upper West Region', 'UW', 0), (1278, 82, 'Volta Region', 'VO', 0), (1279, 82, 'Western Region', 'WE', 0), (1280, 84, 'Attica', 'AT', 0), (1281, 84, 'Central Greece', 'CN', 0), (1282, 84, 'Central Macedonia', 'CM', 0), (1283, 84, 'Crete', 'CR', 0), (1284, 84, 'East Macedonia and Thrace', 'EM', 0), (1285, 84, 'Epirus', 'EP', 0), (1286, 84, 'Ionian Islands', 'II', 0), (1287, 84, 'North Aegean', 'NA', 0), (1288, 84, 'Peloponnesos', 'PP', 0), (1289, 84, 'South Aegean', 'SA', 0), (1290, 84, 'Thessaly', 'TH', 0), (1291, 84, 'West Greece', 'WG', 0), (1292, 84, 'West Macedonia', 'WM', 0), (1293, 85, 'Avannaa', 'A', 0), (1294, 85, 'Tunu', 'T', 0), (1295, 85, 'Kitaa', 'K', 0), (1296, 86, 'Saint Andrew', 'A', 0), (1297, 86, 'Saint David', 'D', 0), (1298, 86, 'Saint George', 'G', 0), (1299, 86, 'Saint John', 'J', 0), (1300, 86, 'Saint Mark', 'M', 0), (1301, 86, 'Saint Patrick', 'P', 0), (1302, 86, 'Carriacou', 'C', 0), (1303, 86, 'Petit Martinique', 'Q', 0), (1304, 89, 'Alta Verapaz', 'AV', 0), (1305, 89, 'Baja Verapaz', 'BV', 0), (1306, 89, 'Chimaltenango', 'CM', 0), (1307, 89, 'Chiquimula', 'CQ', 0), (1308, 89, 'El Peten', 'PE', 0), (1309, 89, 'El Progreso', 'PR', 0), (1310, 89, 'El Quiche', 'QC', 0), (1311, 89, 'Escuintla', 'ES', 0), (1312, 89, 'Guatemala', 'GU', 0), (1313, 89, 'Huehuetenango', 'HU', 0), (1314, 89, 'Izabal', 'IZ', 0), (1315, 89, 'Jalapa', 'JA', 0), (1316, 89, 'Jutiapa', 'JU', 0), (1317, 89, 'Quetzaltenango', 'QZ', 0), (1318, 89, 'Retalhuleu', 'RE', 0), (1319, 89, 'Sacatepequez', 'ST', 0), (1320, 89, 'San Marcos', 'SM', 0), (1321, 89, 'Santa Rosa', 'SR', 0), (1322, 89, 'Solola', 'SO', 0), (1323, 89, 'Suchitepequez', 'SU', 0), (1324, 89, 'Totonicapan', 'TO', 0), (1325, 89, 'Zacapa', 'ZA', 0), (1326, 90, 'Conakry', 'CNK', 0), (1327, 90, 'Beyla', 'BYL', 0), (1328, 90, 'Boffa', 'BFA', 0), (1329, 90, 'Boke', 'BOK', 0), (1330, 90, 'Coyah', 'COY', 0), (1331, 90, 'Dabola', 'DBL', 0), (1332, 90, 'Dalaba', 'DLB', 0), (1333, 90, 'Dinguiraye', 'DGR', 0), (1334, 90, 'Dubreka', 'DBR', 0), (1335, 90, 'Faranah', 'FRN', 0), (1336, 90, 'Forecariah', 'FRC', 0), (1337, 90, 'Fria', 'FRI', 0), (1338, 90, 'Gaoual', 'GAO', 0), (1339, 90, 'Gueckedou', 'GCD', 0), (1340, 90, 'Kankan', 'KNK', 0), (1341, 90, 'Kerouane', 'KRN', 0), (1342, 90, 'Kindia', 'KND', 0), (1343, 90, 'Kissidougou', 'KSD', 0), (1344, 90, 'Koubia', 'KBA', 0), (1345, 90, 'Koundara', 'KDA', 0), (1346, 90, 'Kouroussa', 'KRA', 0), (1347, 90, 'Labe', 'LAB', 0), (1348, 90, 'Lelouma', 'LLM', 0), (1349, 90, 'Lola', 'LOL', 0), (1350, 90, 'Macenta', 'MCT', 0), (1351, 90, 'Mali', 'MAL', 0), (1352, 90, 'Mamou', 'MAM', 0), (1353, 90, 'Mandiana', 'MAN', 0), (1354, 90, 'Nzerekore', 'NZR', 0), (1355, 90, 'Pita', 'PIT', 0), (1356, 90, 'Siguiri', 'SIG', 0), (1357, 90, 'Telimele', 'TLM', 0), (1358, 90, 'Tougue', 'TOG', 0), (1359, 90, 'Yomou', 'YOM', 0), (1360, 91, 'Bafata Region', 'BF', 0), (1361, 91, 'Biombo Region', 'BB', 0), (1362, 91, 'Bissau Region', 'BS', 0), (1363, 91, 'Bolama Region', 'BL', 0), (1364, 91, 'Cacheu Region', 'CA', 0), (1365, 91, 'Gabu Region', 'GA', 0), (1366, 91, 'Oio Region', 'OI', 0), (1367, 91, 'Quinara Region', 'QU', 0), (1368, 91, 'Tombali Region', 'TO', 0), (1369, 92, 'Barima-Waini', 'BW', 0), (1370, 92, 'Cuyuni-Mazaruni', 'CM', 0), (1371, 92, 'Demerara-Mahaica', 'DM', 0), (1372, 92, 'East Berbice-Corentyne', 'EC', 0), (1373, 92, 'Essequibo Islands-West Demerara', 'EW', 0), (1374, 92, 'Mahaica-Berbice', 'MB', 0), (1375, 92, 'Pomeroon-Supenaam', 'PM', 0), (1376, 92, 'Potaro-Siparuni', 'PI', 0), (1377, 92, 'Upper Demerara-Berbice', 'UD', 0), (1378, 92, 'Upper Takutu-Upper Essequibo', 'UT', 0), (1379, 93, 'Artibonite', 'AR', 0), (1380, 93, 'Centre', 'CE', 0), (1381, 93, 'GrandAnse', 'GA', 0), (1382, 93, 'Nord', 'ND', 0), (1383, 93, 'Nord-Est', 'NE', 0), (1384, 93, 'Nord-Ouest', 'NO', 0), (1385, 93, 'Ouest', 'OU', 0), (1386, 93, 'Sud', 'SD', 0), (1387, 93, 'Sud-Est', 'SE', 0), (1388, 94, 'Flat Island', 'F', 0), (1389, 94, 'McDonald Island', 'M', 0), (1390, 94, 'Shag Island', 'S', 0), (1391, 94, 'Heard Island', 'H', 0), (1392, 95, 'Atlantida', 'AT', 0), (1393, 95, 'Choluteca', 'CH', 0), (1394, 95, 'Colon', 'CL', 0), (1395, 95, 'Comayagua', 'CM', 0), (1396, 95, 'Copan', 'CP', 0), (1397, 95, 'Cortes', 'CR', 0), (1398, 95, 'El Paraiso', 'PA', 0), (1399, 95, 'Francisco Morazan', 'FM', 0), (1400, 95, 'Gracias a Dios', 'GD', 0), (1401, 95, 'Intibuca', 'IN', 0), (1402, 95, 'Islas de la Bahia (Bay Islands)', 'IB', 0), (1403, 95, 'La Paz', 'PZ', 0), (1404, 95, 'Lempira', 'LE', 0), (1405, 95, 'Ocotepeque', 'OC', 0), (1406, 95, 'Olancho', 'OL', 0), (1407, 95, 'Santa Barbara', 'SB', 0), (1408, 95, 'Valle', 'VA', 0), (1409, 95, 'Yoro', 'YO', 0), (1410, 96, 'Central and Western Hong Kong Island', 'HCW', 0), (1411, 96, 'Eastern Hong Kong Island', 'HEA', 0), (1412, 96, 'Southern Hong Kong Island', 'HSO', 0), (1413, 96, 'Wan Chai Hong Kong Island', 'HWC', 0), (1414, 96, 'Kowloon City Kowloon', 'KKC', 0), (1415, 96, 'Kwun Tong Kowloon', 'KKT', 0), (1416, 96, 'Sham Shui Po Kowloon', 'KSS', 0), (1417, 96, 'Wong Tai Sin Kowloon', 'KWT', 0), (1418, 96, 'Yau Tsim Mong Kowloon', 'KYT', 0), (1419, 96, 'Islands New Territories', 'NIS', 0), (1420, 96, 'Kwai Tsing New Territories', 'NKT', 0), (1421, 96, 'North New Territories', 'NNO', 0), (1422, 96, 'Sai Kung New Territories', 'NSK', 0), (1423, 96, 'Sha Tin New Territories', 'NST', 0), (1424, 96, 'Tai Po New Territories', 'NTP', 0), (1425, 96, 'Tsuen Wan New Territories', 'NTW', 0), (1426, 96, 'Tuen Mun New Territories', 'NTM', 0), (1427, 96, 'Yuen Long New Territories', 'NYL', 0), (1467, 98, 'Austurland', 'AL', 0), (1468, 98, 'Hofuoborgarsvaeoi', 'HF', 0), (1469, 98, 'Norourland eystra', 'NE', 0), (1470, 98, 'Norourland vestra', 'NV', 0), (1471, 98, 'Suourland', 'SL', 0), (1472, 98, 'Suournes', 'SN', 0), (1473, 98, 'Vestfiroir', 'VF', 0), (1474, 98, 'Vesturland', 'VL', 0), (1475, 99, 'Andaman and Nicobar Islands', 'AN', 0), (1476, 99, 'Andhra Pradesh', 'AP', 0), (1477, 99, 'Arunachal Pradesh', 'AR', 0), (1478, 99, 'Assam', 'AS', 0), (1479, 99, 'Bihar', 'BR', 0), (1480, 99, 'Chandigarh', 'CH', 0), (1481, 99, 'Dadra and Nagar Haveli and Davan and Diu', 'DH', 0), (1483, 99, 'Delhi', 'DL', 0), (1484, 99, 'Goa', 'GA', 0), (1485, 99, 'Gujarat', 'GJ', 0), (1486, 99, 'Haryana', 'HR', 0), (1487, 99, 'Himachal Pradesh', 'HP', 0), (1488, 99, 'Jammu and Kashmir', 'JK', 0), (1489, 99, 'Karnataka', 'KA', 0), (1490, 99, 'Kerala', 'KL', 0), (1491, 99, 'Lakshadweep', 'LD', 0), (1492, 99, 'Madhya Pradesh', 'MP', 0), (1493, 99, 'Maharashtra', 'MH', 0), (1494, 99, 'Manipur', 'MN', 0), (1495, 99, 'Meghalaya', 'ML', 0), (1496, 99, 'Mizoram', 'MZ', 0), (1497, 99, 'Nagaland', 'NL', 0), (1498, 99, 'Odisha', 'OR', 0), (1499, 99, 'Puducherry', 'PY', 0), (1500, 99, 'Punjab', 'PB', 0), (1501, 99, 'Rajasthan', 'RJ', 0), (1502, 99, 'Sikkim', 'SK', 0), (1503, 99, 'Tamil Nadu', 'TN', 0), (1504, 99, 'Tripura', 'TR', 0), (1505, 99, 'Uttar Pradesh', 'UP', 0), (1506, 99, 'West Bengal', 'WB', 0), (1507, 100, 'Aceh', 'AC', 0), (1508, 100, 'Bali', 'BA', 0), (1509, 100, 'Banten', 'BT', 0), (1510, 100, 'Bengkulu', 'BE', 0), (1511, 100, 'Kalimantan Utara', 'BD', 0), (1512, 100, 'Gorontalo', 'GO', 0), (1513, 100, 'Jakarta', 'JK', 0), (1514, 100, 'Jambi', 'JA', 0), (1515, 100, 'Jawa Barat', 'JB', 0), (1516, 100, 'Jawa Tengah', 'JT', 0), (1517, 100, 'Jawa Timur', 'JI', 0), (1518, 100, 'Kalimantan Barat', 'KB', 0), (1519, 100, 'Kalimantan Selatan', 'KS', 0), (1520, 100, 'Kalimantan Tengah', 'KT', 0), (1521, 100, 'Kalimantan Timur', 'KI', 0), (1522, 100, 'Kepulauan Bangka Belitung', 'BB', 0), (1523, 100, 'Lampung', 'LA', 0), (1524, 100, 'Maluku', 'MA', 0), (1525, 100, 'Maluku Utara', 'MU', 0), (1526, 100, 'Nusa Tenggara Barat', 'NB', 0), (1527, 100, 'Nusa Tenggara Timur', 'NT', 0), (1528, 100, 'Papua', 'PA', 0), (1529, 100, 'Riau', 'RI', 0), (1530, 100, 'Sulawesi Selatan', 'SN', 0), (1531, 100, 'Sulawesi Tengah', 'ST', 0), (1532, 100, 'Sulawesi Tenggara', 'SG', 0), (1533, 100, 'Sulawesi Utara', 'SA', 0), (1534, 100, 'Sumatera Barat', 'SB', 0), (1535, 100, 'Sumatera Selatan', 'SS', 0), (1536, 100, 'Sumatera Utara', 'SU', 0), (1537, 100, 'Yogyakarta', 'YO', 0), (1538, 101, 'Tehran', 'TEH', 0), (1539, 101, 'Qom', 'QOM', 0), (1540, 101, 'Markazi', 'MKZ', 0), (1541, 101, 'Qazvin', 'QAZ', 0), (1542, 101, 'Gilan', 'GIL', 0), (1543, 101, 'Ardabil', 'ARD', 0), (1544, 101, 'Zanjan', 'ZAN', 0), (1545, 101, 'East Azarbaijan', 'EAZ', 0), (1546, 101, 'West Azarbaijan', 'WEZ', 0), (1547, 101, 'Kurdistan', 'KRD', 0), (1548, 101, 'Hamadan', 'HMD', 0), (1549, 101, 'Kermanshah', 'KRM', 0), (1550, 101, 'Ilam', 'ILM', 0), (1551, 101, 'Lorestan', 'LRS', 0), (1552, 101, 'Khuzestan', 'KZT', 0), (1553, 101, 'Chahar Mahaal and Bakhtiari', 'CMB', 0), (1554, 101, 'Kohkiluyeh and Buyer Ahmad', 'KBA', 0), (1555, 101, 'Bushehr', 'BSH', 0), (1556, 101, 'Fars', 'FAR', 0), (1557, 101, 'Hormozgan', 'HRM', 0), (1558, 101, 'Sistan and Baluchistan', 'SBL', 0), (1559, 101, 'Kerman', 'KRB', 0), (1560, 101, 'Yazd', 'YZD', 0), (1561, 101, 'Esfahan', 'EFH', 0), (1562, 101, 'Semnan', 'SMN', 0), (1563, 101, 'Mazandaran', 'MZD', 0), (1564, 101, 'Golestan', 'GLS', 0), (1565, 101, 'North Khorasan', 'NKH', 0), (1566, 101, 'Razavi Khorasan', 'RKH', 0), (1567, 101, 'South Khorasan', 'SKH', 0), (1568, 102, 'Baghdad', 'BD', 0), (1569, 102, 'Salah ad Din', 'SD', 0), (1570, 102, 'Diyala', 'DY', 0), (1571, 102, 'Wasit', 'WS', 0), (1572, 102, 'Maysan', 'MY', 0), (1573, 102, 'Al Basrah', 'BA', 0), (1574, 102, 'Dhi Qar', 'DQ', 0), (1575, 102, 'Al Muthanna', 'MU', 0), (1576, 102, 'Al Qadisyah', 'QA', 0), (1577, 102, 'Babil', 'BB', 0), (1578, 102, 'Al Karbala', 'KB', 0), (1579, 102, 'An Najaf', 'NJ', 0), (1580, 102, 'Al Anbar', 'AB', 0), (1581, 102, 'Ninawa', 'NN', 0), (1582, 102, 'Dahuk', 'DH', 0), (1583, 102, 'Arbil', 'AL', 0), (1584, 102, 'Kirkuk', 'KI', 0), (1585, 102, 'As Sulaymaniyah', 'SL', 0), (1586, 103, 'Carlow', 'CA', 0), (1587, 103, 'Cavan', 'CV', 0), (1588, 103, 'Clare', 'CL', 0), (1589, 103, 'Cork', 'CO', 0), (1590, 103, 'Donegal', 'DO', 0), (1591, 103, 'Dublin', 'DU', 0), (1592, 103, 'Galway', 'GA', 0), (1593, 103, 'Kerry', 'KE', 0), (1594, 103, 'Kildare', 'KI', 0), (1595, 103, 'Kilkenny', 'KL', 0), (1596, 103, 'Laois', 'LA', 0), (1597, 103, 'Leitrim', 'LE', 0), (1598, 103, 'Limerick', 'LI', 0), (1599, 103, 'Longford', 'LO', 0), (1600, 103, 'Louth', 'LU', 0), (1601, 103, 'Mayo', 'MA', 0), (1602, 103, 'Meath', 'ME', 0), (1603, 103, 'Monaghan', 'MO', 0), (1604, 103, 'Offaly', 'OF', 0), (1605, 103, 'Roscommon', 'RO', 0), (1606, 103, 'Sligo', 'SL', 0), (1607, 103, 'Tipperary', 'TI', 0), (1608, 103, 'Waterford', 'WA', 0), (1609, 103, 'Westmeath', 'WE', 0), (1610, 103, 'Wexford', 'WX', 0), (1611, 103, 'Wicklow', 'WI', 0), (1612, 104, 'Beer Sheva', 'BS', 0), (1613, 104, 'Bikaat Hayarden', 'BH', 0), (1614, 104, 'Eilat and Arava', 'EA', 0), (1615, 104, 'Galil', 'GA', 0), (1616, 104, 'Haifa', 'HA', 0), (1617, 104, 'Jehuda Mountains', 'JM', 0), (1618, 104, 'Jerusalem', 'JE', 0), (1619, 104, 'Negev', 'NE', 0), (1620, 104, 'Semaria', 'SE', 0), (1621, 104, 'Sharon', 'SH', 0), (1622, 104, 'Tel Aviv (Gosh Dan)', 'TA', 0), (1643, 106, 'Clarendon Parish', 'CLA', 0), (1644, 106, 'Hanover Parish', 'HAN', 0), (1645, 106, 'Kingston Parish', 'KIN', 0), (1646, 106, 'Manchester Parish', 'MAN', 0), (1647, 106, 'Portland Parish', 'POR', 0), (1648, 106, 'Saint Andrew Parish', 'AND', 0), (1649, 106, 'Saint Ann Parish', 'ANN', 0), (1650, 106, 'Saint Catherine Parish', 'CAT', 0), (1651, 106, 'Saint Elizabeth Parish', 'ELI', 0), (1652, 106, 'Saint James Parish', 'JAM', 0), (1653, 106, 'Saint Mary Parish', 'MAR', 0), (1654, 106, 'Saint Thomas Parish', 'THO', 0), (1655, 106, 'Trelawny Parish', 'TRL', 0), (1656, 106, 'Westmoreland Parish', 'WML', 0), (1657, 107, 'Aichi', 'AI', 0), (1658, 107, 'Akita', 'AK', 0), (1659, 107, 'Aomori', 'AO', 0), (1660, 107, 'Chiba', 'CH', 0), (1661, 107, 'Ehime', 'EH', 0), (1662, 107, 'Fukui', 'FK', 0), (1663, 107, 'Fukuoka', 'FU', 0), (1664, 107, 'Fukushima', 'FS', 0), (1665, 107, 'Gifu', 'GI', 0), (1666, 107, 'Gumma', 'GU', 0), (1667, 107, 'Hiroshima', 'HI', 0), (1668, 107, 'Hokkaido', 'HO', 0), (1669, 107, 'Hyogo', 'HY', 0), (1670, 107, 'Ibaraki', 'IB', 0), (1671, 107, 'Ishikawa', 'IS', 0), (1672, 107, 'Iwate', 'IW', 0), (1673, 107, 'Kagawa', 'KA', 0), (1674, 107, 'Kagoshima', 'KG', 0), (1675, 107, 'Kanagawa', 'KN', 0), (1676, 107, 'Kochi', 'KO', 0), (1677, 107, 'Kumamoto', 'KU', 0), (1678, 107, 'Kyoto', 'KY', 0), (1679, 107, 'Mie', 'MI', 0), (1680, 107, 'Miyagi', 'MY', 0), (1681, 107, 'Miyazaki', 'MZ', 0), (1682, 107, 'Nagano', 'NA', 0), (1683, 107, 'Nagasaki', 'NG', 0), (1684, 107, 'Nara', 'NR', 0), (1685, 107, 'Niigata', 'NI', 0), (1686, 107, 'Oita', 'OI', 0), (1687, 107, 'Okayama', 'OK', 0), (1688, 107, 'Okinawa', 'ON', 0), (1689, 107, 'Osaka', 'OS', 0), (1690, 107, 'Saga', 'SA', 0), (1691, 107, 'Saitama', 'SI', 0), (1692, 107, 'Shiga', 'SH', 0), (1693, 107, 'Shimane', 'SM', 0), (1694, 107, 'Shizuoka', 'SZ', 0), (1695, 107, 'Tochigi', 'TO', 0), (1696, 107, 'Tokushima', 'TS', 0), (1697, 107, 'Tokyo', 'TK', 0), (1698, 107, 'Tottori', 'TT', 0), (1699, 107, 'Toyama', 'TY', 0), (1700, 107, 'Wakayama', 'WA', 0), (1701, 107, 'Yamagata', 'YA', 0), (1702, 107, 'Yamaguchi', 'YM', 0), (1703, 107, 'Yamanashi', 'YN', 0), (1704, 108, 'Amman', 'AM', 0), (1705, 108, 'Ajlun', 'AJ', 0), (1706, 108, 'Al Aqabah', 'AA', 0), (1707, 108, 'Al Balqa', 'AB', 0), (1708, 108, 'Al Karak', 'AK', 0), (1709, 108, 'Al Mafraq', 'AL', 0), (1710, 108, 'At Tafilah', 'AT', 0), (1711, 108, 'Az Zarqa', 'AZ', 0), (1712, 108, 'Irbid', 'IR', 0), (1713, 108, 'Jarash', 'JA', 0), (1714, 108, 'Maan', 'MA', 0), (1715, 108, 'Madaba', 'MD', 0), (1716, 109, 'Almaty', 'AL', 0), (1717, 109, 'Almaty City', 'AC', 0), (1718, 109, 'Aqmola', 'AM', 0), (1719, 109, 'Aqtobe', 'AQ', 0), (1720, 109, 'Astana City', 'AS', 0), (1721, 109, 'Atyrau', 'AT', 0), (1722, 109, 'Batys Qazaqstan', 'BA', 0), (1723, 109, 'Bayqongyr City', 'BY', 0), (1724, 109, 'Mangghystau', 'MA', 0), (1725, 109, 'Ongtustik Qazaqstan', 'ON', 0), (1726, 109, 'Pavlodar', 'PA', 0), (1727, 109, 'Qaraghandy', 'QA', 0), (1728, 109, 'Qostanay', 'QO', 0), (1729, 109, 'Qyzylorda', 'QY', 0), (1730, 109, 'Shyghys Qazaqstan', 'SH', 0), (1731, 109, 'Soltustik Qazaqstan', 'SO', 0), (1732, 109, 'Zhambyl', 'ZH', 0), (1733, 110, 'Central', 'CE', 0), (1734, 110, 'Coast', 'CO', 0), (1735, 110, 'Eastern', 'EA', 0), (1736, 110, 'Nairobi Area', 'NA', 0), (1737, 110, 'North Eastern', 'NE', 0), (1738, 110, 'Nyanza', 'NY', 0), (1739, 110, 'Rift Valley', 'RV', 0), (1740, 110, 'Western', 'WE', 0), (1741, 111, 'Abaiang', 'AG', 0), (1742, 111, 'Abemama', 'AM', 0), (1743, 111, 'Aranuka', 'AK', 0), (1744, 111, 'Arorae', 'AO', 0), (1745, 111, 'Banaba', 'BA', 0), (1746, 111, 'Beru', 'BE', 0), (1747, 111, 'Butaritari', 'bT', 0), (1748, 111, 'Kanton', 'KA', 0), (1749, 111, 'Kiritimati', 'KR', 0), (1750, 111, 'Kuria', 'KU', 0), (1751, 111, 'Maiana', 'MI', 0), (1752, 111, 'Makin', 'MN', 0), (1753, 111, 'Marakei', 'ME', 0), (1754, 111, 'Nikunau', 'NI', 0), (1755, 111, 'Nonouti', 'NO', 0), (1756, 111, 'Onotoa', 'ON', 0), (1757, 111, 'Tabiteuea', 'TT', 0), (1758, 111, 'Tabuaeran', 'TR', 0), (1759, 111, 'Tamana', 'TM', 0), (1760, 111, 'Tarawa', 'TW', 0), (1761, 111, 'Teraina', 'TE', 0), (1762, 112, 'Chagang-do', 'CHA', 0), (1763, 112, 'Hamgyong-bukto', 'HAB', 0), (1764, 112, 'Hamgyong-namdo', 'HAN', 0), (1765, 112, 'Hwanghae-bukto', 'HWB', 0), (1766, 112, 'Hwanghae-namdo', 'HWN', 0), (1767, 112, 'Kangwon-do', 'KAN', 0), (1768, 112, 'Pyongan-bukto', 'PYB', 0), (1769, 112, 'Pyongan-namdo', 'PYN', 0), (1770, 112, 'Ryanggang-do (Yanggang-do)', 'YAN', 0), (1771, 112, 'Rason Directly Governed City', 'NAJ', 0), (1772, 112, 'Pyongyang Special City', 'PYO', 0), (1788, 114, 'Al Asimah', 'AL', 0), (1789, 114, 'Al Ahmadi', 'AA', 0), (1790, 114, 'Al Farwaniyah', 'AF', 0), (1791, 114, 'Al Jahra', 'AJ', 0), (1792, 114, 'Hawalli', 'HA', 0), (1793, 115, 'Bishkek', 'GB', 0), (1794, 115, 'Batken', 'B', 0), (1795, 115, 'Chu', 'C', 0), (1796, 115, 'Jalal-Abad', 'J', 0), (1797, 115, 'Naryn', 'N', 0), (1798, 115, 'Osh', 'O', 0), (1799, 115, 'Talas', 'T', 0), (1800, 115, 'Ysyk-Kol', 'Y', 0), (1801, 116, 'Vientiane', 'VT', 0), (1802, 116, 'Attapu', 'AT', 0), (1803, 116, 'Bokeo', 'BK', 0), (1804, 116, 'Bolikhamxai', 'BL', 0), (1805, 116, 'Champasak', 'CH', 0), (1806, 116, 'Houaphan', 'HO', 0), (1807, 116, 'Khammouan', 'KH', 0), (1808, 116, 'Louang Namtha', 'LM', 0), (1809, 116, 'Louangphabang', 'LP', 0), (1810, 116, 'Oudomxai', 'OU', 0), (1811, 116, 'Phongsali', 'PH', 0), (1812, 116, 'Salavan', 'SL', 0), (1813, 116, 'Savannakhet', 'SV', 0), (1814, 116, 'Vientiane', 'VI', 0), (1815, 116, 'Xaignabouli', 'XA', 0), (1816, 116, 'Xekong', 'XE', 0), (1817, 116, 'Xiangkhoang', 'XI', 0), (1818, 116, 'Xaisomboun', 'XN', 0), (1852, 119, 'Berea', 'BE', 0), (1853, 119, 'Butha-Buthe', 'BB', 0), (1854, 119, 'Leribe', 'LE', 0), (1855, 119, 'Mafeteng', 'MF', 0), (1856, 119, 'Maseru', 'MS', 0), (1857, 119, 'Mohales Hoek', 'MH', 0), (1858, 119, 'Mokhotlong', 'MK', 0), (1859, 119, 'Qachas Nek', 'QN', 0), (1860, 119, 'Quthing', 'QT', 0), (1861, 119, 'Thaba-Tseka', 'TT', 0), (1862, 120, 'Bomi', 'BI', 0), (1863, 120, 'Bong', 'BG', 0), (1864, 120, 'Grand Bassa', 'GB', 0), (1865, 120, 'Grand Cape Mount', 'CM', 0), (1866, 120, 'Grand Gedeh', 'GG', 0), (1867, 120, 'Grand Kru', 'GK', 0), (1868, 120, 'Lofa', 'LO', 0), (1869, 120, 'Margibi', 'MG', 0), (1870, 120, 'Maryland', 'ML', 0), (1871, 120, 'Montserrado', 'MS', 0), (1872, 120, 'Nimba', 'NB', 0), (1873, 120, 'River Cess', 'RC', 0), (1874, 120, 'Sinoe', 'SN', 0), (1875, 121, 'Ajdabiya', 'AJ', 0), (1876, 121, 'Al Aziziyah', 'AZ', 0), (1877, 121, 'Al Fatih', 'FA', 0), (1878, 121, 'Al Jabal al Akhdar', 'JA', 0), (1879, 121, 'Al Jufrah', 'JU', 0), (1880, 121, 'Al Khums', 'KH', 0), (1881, 121, 'Al Kufrah', 'KU', 0), (1882, 121, 'An Nuqat al Khams', 'NK', 0), (1883, 121, 'Ash Shati', 'AS', 0), (1884, 121, 'Awbari', 'AW', 0), (1885, 121, 'Az Zawiyah', 'ZA', 0), (1886, 121, 'Banghazi', 'BA', 0), (1887, 121, 'Darnah', 'DA', 0), (1888, 121, 'Ghadamis', 'GD', 0), (1889, 121, 'Gharyan', 'GY', 0), (1890, 121, 'Misratah', 'MI', 0), (1891, 121, 'Murzuq', 'MZ', 0), (1892, 121, 'Sabha', 'SB', 0), (1893, 121, 'Sawfajjin', 'SW', 0), (1894, 121, 'Surt', 'SU', 0), (1895, 121, 'Tarabulus (Tripoli)', 'TL', 0), (1896, 121, 'Tarhunah', 'TH', 0), (1897, 121, 'Tubruq', 'TU', 0), (1898, 121, 'Yafran', 'YA', 0), (1899, 121, 'Zlitan', 'ZL', 0), (1900, 122, 'Vaduz', 'V', 0), (1901, 122, 'Schaan', 'A', 0), (1902, 122, 'Balzers', 'B', 0), (1903, 122, 'Triesen', 'N', 0), (1904, 122, 'Eschen', 'E', 0), (1905, 122, 'Mauren', 'M', 0), (1906, 122, 'Triesenberg', 'T', 0), (1907, 122, 'Ruggell', 'R', 0), (1908, 122, 'Gamprin', 'G', 0), (1909, 122, 'Schellenberg', 'L', 0), (1910, 122, 'Planken', 'P', 0), (1911, 123, 'Alytus', 'AL', 0), (1912, 123, 'Kaunas', 'KA', 0), (1913, 123, 'Klaipeda', 'KL', 0), (1914, 123, 'Marijampole', 'MA', 0), (1915, 123, 'Panevezys', 'PA', 0), (1916, 123, 'Siauliai', 'SI', 0), (1917, 123, 'Taurage', 'TA', 0), (1918, 123, 'Telsiai', 'TE', 0), (1919, 123, 'Utena', 'UT', 0), (1920, 123, 'Vilnius', 'VI', 0), (1921, 124, 'Diekirch', 'DD', 0), (1922, 124, 'Clervaux', 'DC', 0), (1923, 124, 'Redange', 'DR', 0), (1924, 124, 'Vianden', 'DV', 0), (1925, 124, 'Wiltz', 'DW', 0), (1926, 124, 'Grevenmacher', 'GG', 0), (1927, 124, 'Echternach', 'GE', 0), (1928, 124, 'Remich', 'GR', 0), (1929, 124, 'Luxembourg', 'LL', 0), (1930, 124, 'Capellen', 'LC', 0), (1931, 124, 'Esch-sur-Alzette', 'LE', 0), (1932, 124, 'Mersch', 'LM', 0), (1933, 125, 'Our Lady Fatima Parish', 'OLF', 0), (1934, 125, 'St. Anthony Parish', 'ANT', 0), (1935, 125, 'St. Lazarus Parish', 'LAZ', 0), (1936, 125, 'Cathedral Parish', 'CAT', 0), (1937, 125, 'St. Lawrence Parish', 'LAW', 0), (1938, 127, 'Antananarivo', 'AN', 0), (1939, 127, 'Antsiranana', 'AS', 0), (1940, 127, 'Fianarantsoa', 'FN', 0), (1941, 127, 'Mahajanga', 'MJ', 0), (1942, 127, 'Toamasina', 'TM', 0), (1943, 127, 'Toliara', 'TL', 0), (1944, 128, 'Balaka', 'BLK', 0), (1945, 128, 'Blantyre', 'BLT', 0), (1946, 128, 'Chikwawa', 'CKW', 0), (1947, 128, 'Chiradzulu', 'CRD', 0), (1948, 128, 'Chitipa', 'CTP', 0), (1949, 128, 'Dedza', 'DDZ', 0), (1950, 128, 'Dowa', 'DWA', 0), (1951, 128, 'Karonga', 'KRG', 0), (1952, 128, 'Kasungu', 'KSG', 0), (1953, 128, 'Likoma', 'LKM', 0), (1954, 128, 'Lilongwe', 'LLG', 0), (1955, 128, 'Machinga', 'MCG', 0), (1956, 128, 'Mangochi', 'MGC', 0), (1957, 128, 'Mchinji', 'MCH', 0), (1958, 128, 'Mulanje', 'MLJ', 0), (1959, 128, 'Mwanza', 'MWZ', 0), (1960, 128, 'Mzimba', 'MZM', 0), (1961, 128, 'Ntcheu', 'NTU', 0), (1962, 128, 'Nkhata Bay', 'NKB', 0), (1963, 128, 'Nkhotakota', 'NKH', 0), (1964, 128, 'Nsanje', 'NSJ', 0), (1965, 128, 'Ntchisi', 'NTI', 0), (1966, 128, 'Phalombe', 'PHL', 0), (1967, 128, 'Rumphi', 'RMP', 0), (1968, 128, 'Salima', 'SLM', 0), (1969, 128, 'Thyolo', 'THY', 0), (1970, 128, 'Zomba', 'ZBA', 0), (1971, 129, 'Johor', 'MY-01', 0), (1972, 129, 'Kedah', 'MY-02', 0), (1973, 129, 'Kelantan', 'MY-03', 0), (1974, 129, 'Labuan', 'MY-15', 0), (1975, 129, 'Melaka', 'MY-04', 0), (1976, 129, 'Negeri Sembilan', 'MY-05', 0), (1977, 129, 'Pahang', 'MY-06', 0), (1978, 129, 'Perak', 'MY-08', 0), (1979, 129, 'Perlis', 'MY-09', 0), (1980, 129, 'Pulau Pinang', 'MY-07', 0), (1981, 129, 'Sabah', 'MY-12', 0), (1982, 129, 'Sarawak', 'MY-13', 0), (1983, 129, 'Selangor', 'MY-10', 0), (1984, 129, 'Terengganu', 'MY-11', 0), (1985, 129, 'Kuala Lumpur', 'MY-14', 0), (1986, 130, 'Thiladhunmathi Uthuru', 'THU', 0), (1987, 130, 'Thiladhunmathi Dhekunu', 'THD', 0), (1988, 130, 'Miladhunmadulu Uthuru', 'MLU', 0), (1989, 130, 'Miladhunmadulu Dhekunu', 'MLD', 0), (1990, 130, 'Maalhosmadulu Uthuru', 'MAU', 0), (1991, 130, 'Maalhosmadulu Dhekunu', 'MAD', 0), (1992, 130, 'Faadhippolhu', 'FAA', 0), (1993, 130, 'Male Atoll', 'MAA', 0), (1994, 130, 'Ari Atoll Uthuru', 'AAU', 0), (1995, 130, 'Ari Atoll Dheknu', 'AAD', 0), (1996, 130, 'Felidhe Atoll', 'FEA', 0), (1997, 130, 'Mulaku Atoll', 'MUA', 0), (1998, 130, 'Nilandhe Atoll Uthuru', 'NAU', 0), (1999, 130, 'Nilandhe Atoll Dhekunu', 'NAD', 0), (2000, 130, 'Kolhumadulu', 'KLH', 0), (2001, 130, 'Hadhdhunmathi', 'HDH', 0), (2002, 130, 'Huvadhu Atoll Uthuru', 'HAU', 0), (2003, 130, 'Huvadhu Atoll Dhekunu', 'HAD', 0), (2004, 130, 'Fua Mulaku', 'FMU', 0), (2005, 130, 'Addu', 'ADD', 0), (2006, 131, 'Gao', 'GA', 0), (2007, 131, 'Kayes', 'KY', 0), (2008, 131, 'Kidal', 'KD', 0), (2009, 131, 'Koulikoro', 'KL', 0), (2010, 131, 'Mopti', 'MP', 0), (2011, 131, 'Segou', 'SG', 0), (2012, 131, 'Sikasso', 'SK', 0), (2013, 131, 'Tombouctou', 'TB', 0), (2014, 131, 'Bamako Capital District', 'CD', 0), (2015, 132, 'Attard', 'ATT', 0), (2016, 132, 'Balzan', 'BAL', 0), (2017, 132, 'Birgu', 'BGU', 0), (2018, 132, 'Birkirkara', 'BKK', 0), (2019, 132, 'Birzebbuga', 'BRZ', 0), (2020, 132, 'Bormla', 'BOR', 0), (2021, 132, 'Dingli', 'DIN', 0), (2022, 132, 'Fgura', 'FGU', 0), (2023, 132, 'Floriana', 'FLO', 0), (2024, 132, 'Gudja', 'GDJ', 0), (2025, 132, 'Gzira', 'GZR', 0), (2026, 132, 'Gargur', 'GRG', 0), (2027, 132, 'Gaxaq', 'GXQ', 0), (2028, 132, 'Hamrun', 'HMR', 0), (2029, 132, 'Iklin', 'IKL', 0), (2030, 132, 'Isla', 'ISL', 0), (2031, 132, 'Kalkara', 'KLK', 0), (2032, 132, 'Kirkop', 'KRK', 0), (2033, 132, 'Lija', 'LIJ', 0), (2034, 132, 'Luqa', 'LUQ', 0), (2035, 132, 'Marsa', 'MRS', 0), (2036, 132, 'Marsaskala', 'MKL', 0), (2037, 132, 'Marsaxlokk', 'MXL', 0), (2038, 132, 'Mdina', 'MDN', 0), (2039, 132, 'Melliea', 'MEL', 0), (2040, 132, 'Mgarr', 'MGR', 0), (2041, 132, 'Mosta', 'MST', 0), (2042, 132, 'Mqabba', 'MQA', 0), (2043, 132, 'Msida', 'MSI', 0), (2044, 132, 'Mtarfa', 'MTF', 0), (2045, 132, 'Naxxar', 'NAX', 0), (2046, 132, 'Paola', 'PAO', 0), (2047, 132, 'Pembroke', 'PEM', 0), (2048, 132, 'Pieta', 'PIE', 0), (2049, 132, 'Qormi', 'QOR', 0), (2050, 132, 'Qrendi', 'QRE', 0), (2051, 132, 'Rabat', 'RAB', 0), (2052, 132, 'Safi', 'SAF', 0), (2053, 132, 'San Giljan', 'SGI', 0), (2054, 132, 'Santa Lucija', 'SLU', 0), (2055, 132, 'San Pawl il-Bahar', 'SPB', 0), (2056, 132, 'San Gwann', 'SGW', 0), (2057, 132, 'Santa Venera', 'SVE', 0), (2058, 132, 'Siggiewi', 'SIG', 0), (2059, 132, 'Sliema', 'SLM', 0), (2060, 132, 'Swieqi', 'SWQ', 0), (2061, 132, 'Ta Xbiex', 'TXB', 0), (2062, 132, 'Tarxien', 'TRX', 0), (2063, 132, 'Valletta', 'VLT', 0), (2064, 132, 'Xgajra', 'XGJ', 0), (2065, 132, 'Zabbar', 'ZBR', 0), (2066, 132, 'Zebbug', 'ZBG', 0), (2067, 132, 'Zejtun', 'ZJT', 0), (2068, 132, 'Zurrieq', 'ZRQ', 0), (2069, 132, 'Fontana', 'FNT', 0), (2070, 132, 'Ghajnsielem', 'GHJ', 0), (2071, 132, 'Gharb', 'GHR', 0), (2072, 132, 'Ghasri', 'GHS', 0), (2073, 132, 'Kercem', 'KRC', 0), (2074, 132, 'Munxar', 'MUN', 0), (2075, 132, 'Nadur', 'NAD', 0), (2076, 132, 'Qala', 'QAL', 0), (2077, 132, 'Victoria', 'VIC', 0), (2078, 132, 'San Lawrenz', 'SLA', 0), (2079, 132, 'Sannat', 'SNT', 0), (2080, 132, 'Xagra', 'ZAG', 0), (2081, 132, 'Xewkija', 'XEW', 0), (2082, 132, 'Zebbug', 'ZEB', 0), (2083, 133, 'Ailinginae', 'ALG', 0), (2084, 133, 'Ailinglaplap', 'ALL', 0), (2085, 133, 'Ailuk', 'ALK', 0), (2086, 133, 'Arno', 'ARN', 0), (2087, 133, 'Aur', 'AUR', 0), (2088, 133, 'Bikar', 'BKR', 0), (2089, 133, 'Bikini', 'BKN', 0), (2090, 133, 'Bokak', 'BKK', 0), (2091, 133, 'Ebon', 'EBN', 0), (2092, 133, 'Enewetak', 'ENT', 0), (2093, 133, 'Erikub', 'EKB', 0), (2094, 133, 'Jabat', 'JBT', 0), (2095, 133, 'Jaluit', 'JLT', 0), (2096, 133, 'Jemo', 'JEM', 0), (2097, 133, 'Kili', 'KIL', 0), (2098, 133, 'Kwajalein', 'KWJ', 0), (2099, 133, 'Lae', 'LAE', 0), (2100, 133, 'Lib', 'LIB', 0), (2101, 133, 'Likiep', 'LKP', 0), (2102, 133, 'Majuro', 'MJR', 0), (2103, 133, 'Maloelap', 'MLP', 0), (2104, 133, 'Mejit', 'MJT', 0), (2105, 133, 'Mili', 'MIL', 0), (2106, 133, 'Namorik', 'NMK', 0), (2107, 133, 'Namu', 'NAM', 0), (2108, 133, 'Rongelap', 'RGL', 0), (2109, 133, 'Rongrik', 'RGK', 0), (2110, 133, 'Toke', 'TOK', 0), (2111, 133, 'Ujae', 'UJA', 0), (2112, 133, 'Ujelang', 'UJL', 0), (2113, 133, 'Utirik', 'UTK', 0), (2114, 133, 'Wotho', 'WTH', 0), (2115, 133, 'Wotje', 'WTJ', 0), (2116, 135, 'Adrar', 'AD', 0), (2117, 135, 'Assaba', 'AS', 0), (2118, 135, 'Brakna', 'BR', 0), (2119, 135, 'Dakhlet Nouadhibou', 'DN', 0), (2120, 135, 'Gorgol', 'GO', 0), (2121, 135, 'Guidimaka', 'GM', 0), (2122, 135, 'Hodh Ech Chargui', 'HC', 0), (2123, 135, 'Hodh El Gharbi', 'HG', 0), (2124, 135, 'Inchiri', 'IN', 0), (2125, 135, 'Tagant', 'TA', 0), (2126, 135, 'Tiris Zemmour', 'TZ', 0), (2127, 135, 'Trarza', 'TR', 0), (2128, 135, 'Nouakchott', 'NO', 0), (2129, 136, 'Beau Bassin-Rose Hill', 'BR', 0), (2130, 136, 'Curepipe', 'CU', 0), (2131, 136, 'Port Louis', 'PU', 0), (2132, 136, 'Quatre Bornes', 'QB', 0), (2133, 136, 'Vacoas-Phoenix', 'VP', 0), (2134, 136, 'Agalega Islands', 'AG', 0), (2135, 136, 'Cargados Carajos Shoals (Saint Brandon Islands)', 'CC', 0), (2136, 136, 'Rodrigues', 'RO', 0), (2137, 136, 'Black River', 'BL', 0), (2138, 136, 'Flacq', 'FL', 0), (2139, 136, 'Grand Port', 'GP', 0), (2140, 136, 'Moka', 'MO', 0), (2141, 136, 'Pamplemousses', 'PA', 0), (2142, 136, 'Plaines Wilhems', 'PW', 0), (2143, 136, 'Port Louis', 'PL', 0), (2144, 136, 'Riviere du Rempart', 'RR', 0), (2145, 136, 'Savanne', 'SA', 0), (2146, 138, 'Baja California', 'BCN', 0), (2147, 138, 'Baja California Sur', 'BCS', 0), (2148, 138, 'Campeche', 'CAM', 0), (2149, 138, 'Chiapas', 'CHP', 0), (2150, 138, 'Chihuahua', 'CHH', 0), (2151, 138, 'Coahuila de Zaragoza', 'COA', 0), (2152, 138, 'Colima', 'COL', 0), (2153, 138, 'Cuidad de Mexico', 'CMX', 0), (2154, 138, 'Durango', 'DUR', 0), (2155, 138, 'Guanajuato', 'GUA', 0), (2156, 138, 'Guerrero', 'GRO', 0), (2157, 138, 'Hidalgo', 'HID', 0), (2158, 138, 'Jalisco', 'JAL', 0), (2159, 138, 'Mexico', 'MEX', 0), (2160, 138, 'Michoacan de Ocampo', 'MIC', 0), (2161, 138, 'Morelos', 'MOR', 0), (2162, 138, 'Nayarit', 'NAY', 0), (2163, 138, 'Nuevo Leon', 'NLE', 0), (2164, 138, 'Oaxaca', 'OAX', 0), (2165, 138, 'Puebla', 'PUE', 0), (2166, 138, 'Queretaro', 'QUE', 0), (2167, 138, 'Quintana Roo', 'ROO', 0), (2168, 138, 'San Luis Potosi', 'SLP', 0), (2169, 138, 'Sinaloa', 'SIN', 0), (2170, 138, 'Sonora', 'SON', 0), (2171, 138, 'Tabasco', 'TAB', 0), (2172, 138, 'Tamaulipas', 'TAM', 0), (2173, 138, 'Tlaxcala', 'TLA', 0), (2174, 138, 'Veracruz de Ignacio de la Llave', 'VER', 0), (2175, 138, 'Yucatan', 'YUC', 0), (2176, 138, 'Zacatecas', 'ZAC', 0), (2177, 139, 'Chuuk', 'C', 0), (2178, 139, 'Kosrae', 'K', 0), (2179, 139, 'Pohnpei', 'P', 0), (2180, 139, 'Yap', 'Y', 0), (2181, 140, 'Gagauzia', 'GA', 0), (2182, 140, 'Chisinau', 'CU', 0), (2183, 140, 'Balti', 'BA', 0), (2184, 140, 'Cahul', 'CA', 0), (2185, 140, 'Edinet', 'ED', 0), (2186, 140, 'Lapusna', 'LA', 0), (2187, 140, 'Orhei', 'OR', 0), (2188, 140, 'Soroca', 'SO', 0), (2189, 140, 'Tighina', 'TI', 0), (2190, 140, 'Ungheni', 'UN', 0), (2191, 140, 'St‚nga Nistrului', 'SN', 0), (2192, 141, 'Fontvieille', 'FV', 0), (2193, 141, 'La Condamine', 'LC', 0), (2194, 141, 'Monaco-Ville', 'MV', 0), (2195, 141, 'Monte-Carlo', 'MC', 0), (2196, 142, 'Ulanbaatar', '1', 0), (2197, 142, 'Orhon', '035', 0), (2198, 142, 'Darhan uul', '037', 0), (2199, 142, 'Hentiy', '039', 0), (2200, 142, 'Hovsgol', '041', 0), (2201, 142, 'Hovd', '043', 0), (2202, 142, 'Uvs', '046', 0), (2203, 142, 'Tov', '047', 0), (2204, 142, 'Selenge', '049', 0), (2205, 142, 'Suhbaatar', '051', 0), (2206, 142, 'Omnogovi', '053', 0), (2207, 142, 'Ovorhangay', '055', 0), (2208, 142, 'Dzavhan', '057', 0), (2209, 142, 'DundgovL', '059', 0), (2210, 142, 'Dornod', '061', 0), (2211, 142, 'Dornogov', '063', 0), (2212, 142, 'Govi-Sumber', '064', 0), (2213, 142, 'Govi-Altay', '065', 0), (2214, 142, 'Bulgan', '067', 0), (2215, 142, 'Bayanhongor', '069', 0), (2216, 142, 'Bayan-Olgiy', '071', 0), (2217, 142, 'Arhangay', '073', 0), (2218, 143, 'Saint Anthony', 'A', 0), (2219, 143, 'Saint Georges', 'G', 0), (2220, 143, 'Saint Peter', 'P', 0), (2221, 144, 'Agadir', 'AGD', 0), (2222, 144, 'Al Hoceima', 'HOC', 0), (2223, 144, 'Azilal', 'AZI', 0), (2224, 144, 'Beni Mellal', 'BME', 0), (2225, 144, 'Ben Slimane', 'BSL', 0), (2226, 144, 'Boulemane', 'BLM', 0), (2227, 144, 'Casablanca', 'CBL', 0), (2228, 144, 'Chaouen', 'CHA', 0), (2229, 144, 'El Jadida', 'EJA', 0), (2230, 144, 'El Kelaa des Sraghna', 'EKS', 0), (2231, 144, 'Er Rachidia', 'ERA', 0), (2232, 144, 'Essaouira', 'ESS', 0), (2233, 144, 'Fes', 'FES', 0), (2234, 144, 'Figuig', 'FIG', 0), (2235, 144, 'Guelmim', 'GLM', 0), (2236, 144, 'Ifrane', 'IFR', 0), (2237, 144, 'Kenitra', 'KEN', 0), (2238, 144, 'Khemisset', 'KHM', 0), (2239, 144, 'Khenifra', 'KHN', 0), (2240, 144, 'Khouribga', 'KHO', 0), (2241, 144, 'Laayoune', 'LYN', 0), (2242, 144, 'Larache', 'LAR', 0), (2243, 144, 'Marrakech', 'MRK', 0), (2244, 144, 'Meknes', 'MKN', 0), (2245, 144, 'Nador', 'NAD', 0), (2246, 144, 'Ouarzazate', 'ORZ', 0), (2247, 144, 'Oujda', 'OUJ', 0), (2248, 144, 'Rabat-Sale', 'RSA', 0), (2249, 144, 'Safi', 'SAF', 0), (2250, 144, 'Settat', 'SET', 0), (2251, 144, 'Sidi Kacem', 'SKA', 0), (2252, 144, 'Tangier', 'TGR', 0), (2253, 144, 'Tan-Tan', 'TAN', 0), (2254, 144, 'Taounate', 'TAO', 0), (2255, 144, 'Taroudannt', 'TRD', 0), (2256, 144, 'Tata', 'TAT', 0), (2257, 144, 'Taza', 'TAZ', 0), (2258, 144, 'Tetouan', 'TET', 0), (2259, 144, 'Tiznit', 'TIZ', 0), (2260, 144, 'Ad Dakhla', 'ADK', 0), (2261, 144, 'Boujdour', 'BJD', 0), (2262, 144, 'Es Smara', 'ESM', 0), (2263, 145, 'Cabo Delgado', 'CD', 0), (2264, 145, 'Gaza', 'GZ', 0), (2265, 145, 'Inhambane', 'IN', 0), (2266, 145, 'Manica', 'MN', 0), (2267, 145, 'Maputo (city)', 'MC', 0), (2268, 145, 'Maputo', 'MP', 0), (2269, 145, 'Nampula', 'NA', 0), (2270, 145, 'Niassa', 'NI', 0), (2271, 145, 'Sofala', 'SO', 0), (2272, 145, 'Tete', 'TE', 0), (2273, 145, 'Zambezia', 'ZA', 0), (2274, 146, 'Ayeyarwady', 'AY', 0), (2275, 146, 'Bago', 'BG', 0), (2276, 146, 'Magway', 'MG', 0), (2277, 146, 'Mandalay', 'MD', 0), (2278, 146, 'Sagaing', 'SG', 0), (2279, 146, 'Tanintharyi', 'TN', 0), (2280, 146, 'Yangon', 'YG', 0), (2281, 146, 'Chin State', 'CH', 0), (2282, 146, 'Kachin State', 'KC', 0), (2283, 146, 'Kayah State', 'KH', 0), (2284, 146, 'Kayin State', 'KN', 0), (2285, 146, 'Mon State', 'MN', 0), (2286, 146, 'Rakhine State', 'RK', 0), (2287, 146, 'Shan State', 'SH', 0), (2288, 147, 'Caprivi', 'CA', 0), (2289, 147, 'Erongo', 'ER', 0), (2290, 147, 'Hardap', 'HA', 0), (2291, 147, 'Karas', 'KR', 0), (2292, 147, 'Kavango', 'KV', 0), (2293, 147, 'Khomas', 'KH', 0), (2294, 147, 'Kunene', 'KU', 0), (2295, 147, 'Ohangwena', 'OW', 0), (2296, 147, 'Omaheke', 'OK', 0), (2297, 147, 'Omusati', 'OT', 0), (2298, 147, 'Oshana', 'ON', 0), (2299, 147, 'Oshikoto', 'OO', 0), (2300, 147, 'Otjozondjupa', 'OJ', 0), (2301, 148, 'Aiwo', 'AO', 0), (2302, 148, 'Anabar', 'AA', 0), (2303, 148, 'Anetan', 'AT', 0), (2304, 148, 'Anibare', 'AI', 0), (2305, 148, 'Baiti', 'BA', 0), (2306, 148, 'Boe', 'BO', 0), (2307, 148, 'Buada', 'BU', 0), (2308, 148, 'Denigomodu', 'DE', 0), (2309, 148, 'Ewa', 'EW', 0), (2310, 148, 'Ijuw', 'IJ', 0), (2311, 148, 'Meneng', 'ME', 0), (2312, 148, 'Nibok', 'NI', 0), (2313, 148, 'Uaboe', 'UA', 0), (2314, 148, 'Yaren', 'YA', 0), (2315, 149, 'Bagmati', 'BA', 0), (2316, 149, 'Bheri', 'BH', 0), (2317, 149, 'Dhawalagiri', 'DH', 0), (2318, 149, 'Gandaki', 'GA', 0), (2319, 149, 'Janakpur', 'JA', 0), (2320, 149, 'Karnali', 'KA', 0), (2321, 149, 'Kosi', 'KO', 0), (2322, 149, 'Lumbini', 'LU', 0), (2323, 149, 'Mahakali', 'MA', 0), (2324, 149, 'Mechi', 'ME', 0), (2325, 149, 'Narayani', 'NA', 0), (2326, 149, 'Rapti', 'RA', 0), (2327, 149, 'Sagarmatha', 'SA', 0), (2328, 149, 'Seti', 'SE', 0), (2329, 150, 'Drenthe', 'DR', 0), (2330, 150, 'Flevoland', 'FL', 0), (2331, 150, 'Friesland', 'FR', 0), (2332, 150, 'Gelderland', 'GE', 0), (2333, 150, 'Groningen', 'GR', 0), (2334, 150, 'Limburg', 'LI', 0), (2335, 150, 'Noord-Brabant', 'NB', 0), (2336, 150, 'Noord-Holland', 'NH', 0), (2337, 150, 'Overijssel', 'OV', 0), (2338, 150, 'Utrecht', 'UT', 0), (2339, 150, 'Zeeland', 'ZE', 0), (2340, 150, 'Zuid-Holland', 'ZH', 0), (2341, 152, 'Iles Loyaute', 'L', 0), (2342, 152, 'Nord', 'N', 0), (2343, 152, 'Sud', 'S', 0), (2344, 153, 'Auckland', 'AUK', 0), (2345, 153, 'Bay of Plenty', 'BOP', 0), (2346, 153, 'Canterbury', 'CAN', 0), (2347, 153, 'Coromandel', 'COR', 0), (2348, 153, 'Gisborne', 'GIS', 0), (2349, 153, 'Fiordland', 'FIO', 0), (2350, 153, 'Hawkes Bay', 'HKB', 0), (2351, 153, 'Marlborough', 'MBH', 0), (2352, 153, 'Manawatu-Wanganui', 'MWT', 0), (2353, 153, 'Mt Cook-Mackenzie', 'MCM', 0), (2354, 153, 'Nelson', 'NSN', 0), (2355, 153, 'Northland', 'NTL', 0), (2356, 153, 'Otago', 'OTA', 0), (2357, 153, 'Southland', 'STL', 0), (2358, 153, 'Taranaki', 'TKI', 0), (2359, 153, 'Wellington', 'WGN', 0), (2360, 153, 'Waikato', 'WKO', 0), (2361, 153, 'Wairarapa', 'WAI', 0), (2362, 153, 'West Coast', 'WTC', 0), (2363, 154, 'Atlantico Norte', 'AN', 0), (2364, 154, 'Atlantico Sur', 'AS', 0), (2365, 154, 'Boaco', 'BO', 0), (2366, 154, 'Carazo', 'CA', 0), (2367, 154, 'Chinandega', 'CI', 0), (2368, 154, 'Chontales', 'CO', 0), (2369, 154, 'Esteli', 'ES', 0), (2370, 154, 'Granada', 'GR', 0), (2371, 154, 'Jinotega', 'JI', 0), (2372, 154, 'Leon', 'LE', 0), (2373, 154, 'Madriz', 'MD', 0), (2374, 154, 'Managua', 'MN', 0), (2375, 154, 'Masaya', 'MS', 0), (2376, 154, 'Matagalpa', 'MT', 0), (2377, 154, 'Nuevo Segovia', 'NS', 0), (2378, 154, 'Rio San Juan', 'RS', 0), (2379, 154, 'Rivas', 'RI', 0), (2380, 155, 'Agadez', 'AG', 0), (2381, 155, 'Diffa', 'DF', 0), (2382, 155, 'Dosso', 'DS', 0), (2383, 155, 'Maradi', 'MA', 0), (2384, 155, 'Niamey', 'NM', 0), (2385, 155, 'Tahoua', 'TH', 0), (2386, 155, 'Tillaberi', 'TL', 0), (2387, 155, 'Zinder', 'ZD', 0), (2388, 156, 'Abia', 'AB', 0), (2389, 156, 'Abuja Federal Capital Territory', 'CT', 0), (2390, 156, 'Adamawa', 'AD', 0), (2391, 156, 'Akwa Ibom', 'AK', 0), (2392, 156, 'Anambra', 'AN', 0), (2393, 156, 'Bauchi', 'BC', 0), (2394, 156, 'Bayelsa', 'BY', 0), (2395, 156, 'Benue', 'BN', 0), (2396, 156, 'Borno', 'BO', 0), (2397, 156, 'Cross River', 'CR', 0), (2398, 156, 'Delta', 'DE', 0), (2399, 156, 'Ebonyi', 'EB', 0), (2400, 156, 'Edo', 'ED', 0), (2401, 156, 'Ekiti', 'EK', 0), (2402, 156, 'Enugu', 'EN', 0), (2403, 156, 'Gombe', 'GO', 0), (2404, 156, 'Imo', 'IM', 0), (2405, 156, 'Jigawa', 'JI', 0), (2406, 156, 'Kaduna', 'KD', 0), (2407, 156, 'Kano', 'KN', 0), (2408, 156, 'Katsina', 'KT', 0), (2409, 156, 'Kebbi', 'KE', 0), (2410, 156, 'Kogi', 'KO', 0), (2411, 156, 'Kwara', 'KW', 0), (2412, 156, 'Lagos', 'LA', 0), (2413, 156, 'Nassarawa', 'NA', 0), (2414, 156, 'Niger', 'NI', 0), (2415, 156, 'Ogun', 'OG', 0), (2416, 156, 'Ondo', 'ONG', 0), (2417, 156, 'Osun', 'OS', 0), (2418, 156, 'Oyo', 'OY', 0), (2419, 156, 'Plateau', 'PL', 0), (2420, 156, 'Rivers', 'RI', 0), (2421, 156, 'Sokoto', 'SO', 0), (2422, 156, 'Taraba', 'TA', 0), (2423, 156, 'Yobe', 'YO', 0), (2424, 156, 'Zamfara', 'ZA', 0), (2425, 159, 'Northern Islands', 'N', 0), (2426, 159, 'Rota', 'R', 0), (2427, 159, 'Saipan', 'S', 0), (2428, 159, 'Tinian', 'T', 0), (2429, 160, 'Akershus', 'AK', 0), (2430, 160, 'Aust-Agder', 'AA', 0), (2431, 160, 'Buskerud', 'BU', 0), (2432, 160, 'Finnmark', 'FM', 0), (2433, 160, 'Hedmark', 'HM', 0), (2434, 160, 'Hordaland', 'HL', 0), (2435, 160, 'More og Romdal', 'MR', 0), (2436, 160, 'Nord-Trondelag', 'NT', 0), (2437, 160, 'Nordland', 'NL', 0), (2438, 160, 'Ostfold', 'OF', 0), (2439, 160, 'Oppland', 'OP', 0), (2440, 160, 'Oslo', 'OL', 0), (2441, 160, 'Rogaland', 'RL', 0), (2442, 160, 'Sor-Trondelag', 'ST', 0), (2443, 160, 'Sogn og Fjordane', 'SJ', 0), (2444, 160, 'Svalbard', 'SV', 0), (2445, 160, 'Telemark', 'TM', 0), (2446, 160, 'Troms', 'TR', 0), (2447, 160, 'Vest-Agder', 'VA', 0), (2448, 160, 'Vestfold', 'VF', 0), (2449, 161, 'Ad Dakhiliyah', 'DA', 0), (2450, 161, 'Al Batinah', 'BA', 0), (2451, 161, 'Al Wusta', 'WU', 0), (2452, 161, 'Ash Sharqiyah', 'SH', 0), (2453, 161, 'Az Zahirah', 'ZA', 0), (2454, 161, 'Masqat', 'MA', 0), (2455, 161, 'Musandam', 'MU', 0), (2456, 161, 'Zufar', 'ZU', 0), (2457, 162, 'Balochistan', 'B', 0), (2458, 162, 'Federally Administered Tribal Areas', 'T', 0), (2459, 162, 'Islamabad Capital Territory', 'I', 0), (2460, 162, 'North-West Frontier', 'N', 0), (2461, 162, 'Punjab', 'P', 0), (2462, 162, 'Sindh', 'S', 0), (2463, 163, 'Aimeliik', 'AM', 0), (2464, 163, 'Airai', 'AR', 0), (2465, 163, 'Angaur', 'AN', 0), (2466, 163, 'Hatohobei', 'HA', 0), (2467, 163, 'Kayangel', 'KA', 0), (2468, 163, 'Koror', 'KO', 0), (2469, 163, 'Melekeok', 'ME', 0), (2470, 163, 'Ngaraard', 'NA', 0), (2471, 163, 'Ngarchelong', 'NG', 0), (2472, 163, 'Ngardmau', 'ND', 0), (2473, 163, 'Ngatpang', 'NT', 0), (2474, 163, 'Ngchesar', 'NC', 0), (2475, 163, 'Ngeremlengui', 'NR', 0), (2476, 163, 'Ngiwal', 'NW', 0), (2477, 163, 'Peleliu', 'PE', 0), (2478, 163, 'Sonsorol', 'SO', 0), (2479, 164, 'Bocas del Toro', 'BT', 0), (2480, 164, 'Chiriqui', 'CH', 0), (2481, 164, 'Cocle', 'CC', 0), (2482, 164, 'Colon', 'CL', 0), (2483, 164, 'Darien', 'DA', 0), (2484, 164, 'Herrera', 'HE', 0), (2485, 164, 'Los Santos', 'LS', 0), (2486, 164, 'Panama', 'PA', 0), (2487, 164, 'San Blas', 'SB', 0), (2488, 164, 'Veraguas', 'VG', 0), (2489, 165, 'Bougainville', 'BV', 0), (2490, 165, 'Central', 'CE', 0), (2491, 165, 'Chimbu', 'CH', 0), (2492, 165, 'Eastern Highlands', 'EH', 0), (2493, 165, 'East New Britain', 'EB', 0), (2494, 165, 'East Sepik', 'ES', 0), (2495, 165, 'Enga', 'EN', 0), (2496, 165, 'Gulf', 'GU', 0), (2497, 165, 'Madang', 'MD', 0), (2498, 165, 'Manus', 'MN', 0), (2499, 165, 'Milne Bay', 'MB', 0), (2500, 165, 'Morobe', 'MR', 0), (2501, 165, 'National Capital', 'NC', 0), (2502, 165, 'New Ireland', 'NI', 0), (2503, 165, 'Northern', 'NO', 0), (2504, 165, 'Sandaun', 'SA', 0), (2505, 165, 'Southern Highlands', 'SH', 0), (2506, 165, 'Western', 'WE', 0), (2507, 165, 'Western Highlands', 'WH', 0), (2508, 165, 'West New Britain', 'WB', 0), (2509, 166, 'Alto Paraguay', 'AG', 0), (2510, 166, 'Alto Parana', 'AN', 0), (2511, 166, 'Amambay', 'AM', 0), (2512, 166, 'Asuncion', 'AS', 0), (2513, 166, 'Boqueron', 'BO', 0), (2514, 166, 'Caaguazu', 'CG', 0), (2515, 166, 'Caazapa', 'CZ', 0), (2516, 166, 'Canindeyu', 'CN', 0), (2517, 166, 'Central', 'CE', 0), (2518, 166, 'Concepcion', 'CC', 0), (2519, 166, 'Cordillera', 'CD', 0), (2520, 166, 'Guaira', 'GU', 0), (2521, 166, 'Itapua', 'IT', 0), (2522, 166, 'Misiones', 'MI', 0), (2523, 166, 'Neembucu', 'NE', 0), (2524, 166, 'Paraguari', 'PA', 0), (2525, 166, 'Presidente Hayes', 'PH', 0), (2526, 166, 'San Pedro', 'SP', 0), (2527, 167, 'Amazonas', 'AM', 0), (2528, 167, 'Ancash', 'AN', 0), (2529, 167, 'Apurimac', 'AP', 0), (2530, 167, 'Arequipa', 'AR', 0), (2531, 167, 'Ayacucho', 'AY', 0), (2532, 167, 'Cajamarca', 'CJ', 0), (2533, 167, 'Callao', 'CL', 0), (2534, 167, 'Cusco', 'CU', 0), (2535, 167, 'Huancavelica', 'HV', 0), (2536, 167, 'Huanuco', 'HO', 0), (2537, 167, 'Ica', 'IC', 0), (2538, 167, 'Junin', 'JU', 0), (2539, 167, 'La Libertad', 'LD', 0), (2540, 167, 'Lambayeque', 'LY', 0), (2541, 167, 'Lima', 'LI', 0), (2542, 167, 'Loreto', 'LO', 0), (2543, 167, 'Madre de Dios', 'MD', 0), (2544, 167, 'Moquegua', 'MO', 0), (2545, 167, 'Pasco', 'PA', 0), (2546, 167, 'Piura', 'PI', 0), (2547, 167, 'Puno', 'PU', 0), (2548, 167, 'San Martin', 'SM', 0), (2549, 167, 'Tacna', 'TA', 0), (2550, 167, 'Tumbes', 'TU', 0), (2551, 167, 'Ucayali', 'UC', 0), (2552, 168, 'Abra', 'ABR', 0), (2553, 168, 'Agusan del Norte', 'ANO', 0), (2554, 168, 'Agusan del Sur', 'ASU', 0), (2555, 168, 'Aklan', 'AKL', 0), (2556, 168, 'Albay', 'ALB', 0), (2557, 168, 'Antique', 'ANT', 0), (2558, 168, 'Apayao', 'APY', 0), (2559, 168, 'Aurora', 'AUR', 0), (2560, 168, 'Basilan', 'BAS', 0), (2561, 168, 'Bataan', 'BTA', 0), (2562, 168, 'Batanes', 'BTE', 0), (2563, 168, 'Batangas', 'BTG', 0), (2564, 168, 'Biliran', 'BLR', 0), (2565, 168, 'Benguet', 'BEN', 0), (2566, 168, 'Bohol', 'BOL', 0), (2567, 168, 'Bukidnon', 'BUK', 0), (2568, 168, 'Bulacan', 'BUL', 0), (2569, 168, 'Cagayan', 'CAG', 0), (2570, 168, 'Camarines Norte', 'CNO', 0), (2571, 168, 'Camarines Sur', 'CSU', 0), (2572, 168, 'Camiguin', 'CAM', 0), (2573, 168, 'Capiz', 'CAP', 0), (2574, 168, 'Catanduanes', 'CAT', 0), (2575, 168, 'Cavite', 'CAV', 0), (2576, 168, 'Cebu', 'CEB', 0), (2577, 168, 'Compostela', 'CMP', 0), (2578, 168, 'Davao del Norte', 'DNO', 0), (2579, 168, 'Davao del Sur', 'DSU', 0), (2580, 168, 'Davao Oriental', 'DOR', 0), (2581, 168, 'Eastern Samar', 'ESA', 0), (2582, 168, 'Guimaras', 'GUI', 0), (2583, 168, 'Ifugao', 'IFU', 0), (2584, 168, 'Ilocos Norte', 'INO', 0), (2585, 168, 'Ilocos Sur', 'ISU', 0), (2586, 168, 'Iloilo', 'ILO', 0), (2587, 168, 'Isabela', 'ISA', 0), (2588, 168, 'Kalinga', 'KAL', 0), (2589, 168, 'Laguna', 'LAG', 0), (2590, 168, 'Lanao del Norte', 'LNO', 0), (2591, 168, 'Lanao del Sur', 'LSU', 0), (2592, 168, 'La Union', 'UNI', 0), (2593, 168, 'Leyte', 'LEY', 0), (2594, 168, 'Maguindanao', 'MAG', 0), (2595, 168, 'Marinduque', 'MRN', 0), (2596, 168, 'Masbate', 'MSB', 0), (2597, 168, 'Mindoro Occidental', 'MIC', 0), (2598, 168, 'Mindoro Oriental', 'MIR', 0), (2599, 168, 'Misamis Occidental', 'MSC', 0), (2600, 168, 'Misamis Oriental', 'MOR', 0), (2601, 168, 'Mountain', 'MOP', 0), (2602, 168, 'Negros Occidental', 'NOC', 0), (2603, 168, 'Negros Oriental', 'NOR', 0), (2604, 168, 'North Cotabato', 'NCT', 0), (2605, 168, 'Northern Samar', 'NSM', 0), (2606, 168, 'Nueva Ecija', 'NEC', 0), (2607, 168, 'Nueva Vizcaya', 'NVZ', 0), (2608, 168, 'Palawan', 'PLW', 0), (2609, 168, 'Pampanga', 'PMP', 0), (2610, 168, 'Pangasinan', 'PNG', 0), (2611, 168, 'Quezon', 'QZN', 0), (2612, 168, 'Quirino', 'QRN', 0), (2613, 168, 'Rizal', 'RIZ', 0), (2614, 168, 'Romblon', 'ROM', 0), (2615, 168, 'Samar', 'SMR', 0), (2616, 168, 'Sarangani', 'SRG', 0), (2617, 168, 'Siquijor', 'SQJ', 0), (2618, 168, 'Sorsogon', 'SRS', 0), (2619, 168, 'South Cotabato', 'SCO', 0), (2620, 168, 'Southern Leyte', 'SLE', 0), (2621, 168, 'Sultan Kudarat', 'SKU', 0), (2622, 168, 'Sulu', 'SLU', 0), (2623, 168, 'Surigao del Norte', 'SNO', 0), (2624, 168, 'Surigao del Sur', 'SSU', 0), (2625, 168, 'Tarlac', 'TAR', 0), (2626, 168, 'Tawi-Tawi', 'TAW', 0), (2627, 168, 'Zambales', 'ZBL', 0), (2628, 168, 'Zamboanga del Norte', 'ZNO', 0), (2629, 168, 'Zamboanga del Sur', 'ZSU', 0), (2630, 168, 'Zamboanga Sibugay', 'ZSI', 0), (2631, 170, 'Dolnoslaskie', 'DO', 0), (2632, 170, 'Kujawsko-Pomorskie', 'KP', 0), (2633, 170, 'Lodzkie', 'LO', 0), (2634, 170, 'Lubelskie', 'LL', 0), (2635, 170, 'Lubuskie', 'LU', 0), (2636, 170, 'Malopolskie', 'ML', 0), (2637, 170, 'Mazowieckie', 'MZ', 0), (2638, 170, 'Opolskie', 'OP', 0), (2639, 170, 'Podkarpackie', 'PP', 0), (2640, 170, 'Podlaskie', 'PL', 0), (2641, 170, 'Pomorskie', 'PM', 0), (2642, 170, 'Slaskie', 'SL', 0), (2643, 170, 'Swietokrzyskie', 'SW', 0), (2644, 170, 'Warminsko-Mazurskie', 'WM', 0), (2645, 170, 'Wielkopolskie', 'WP', 0), (2646, 170, 'Zachodniopomorskie', 'ZA', 0), (2647, 198, 'Saint Pierre', 'P', 0), (2648, 198, 'Miquelon', 'M', 0), (2649, 171, 'Açores', '20', 0), (2650, 171, 'Aveiro', '01', 0), (2651, 171, 'Beja', '02', 0), (2652, 171, 'Braga', '03', 0), (2653, 171, 'Bragança', '04', 0), (2654, 171, 'Castelo Branco', '05', 0), (2655, 171, 'Coimbra', '06', 0), (2656, 171, 'Évora', '07', 0), (2657, 171, 'Faro', '08', 0), (2658, 171, 'Guarda', '09', 0), (2659, 171, 'Leiria', '10', 0), (2660, 171, 'Lisboa', '11', 0), (2661, 171, 'Madeira', '30', 0), (2662, 171, 'Portalegre', '12', 0), (2663, 171, 'Porto', '13', 0), (2664, 171, 'Santarém', '14', 0), (2665, 171, 'Setúbal', '15', 0), (2666, 171, 'Viana do Castelo', '16', 0), (2667, 171, 'Vila Real', '17', 0), (2668, 171, 'Viseu', 'VI', 0), (2669, 173, 'Ad Dawhah', 'DW', 0), (2670, 173, 'Al Ghuwayriyah', 'GW', 0), (2671, 173, 'Al Jumayliyah', 'JM', 0), (2672, 173, 'Al Khawr', 'KR', 0), (2673, 173, 'Al Wakrah', 'WK', 0), (2674, 173, 'Ar Rayyan', 'RN', 0), (2675, 173, 'Jarayan al Batinah', 'JB', 0), (2676, 173, 'Madinat ash Shamal', 'MS', 0), (2677, 173, 'Umm Said', 'UD', 0), (2678, 173, 'Umm Salal', 'UL', 0), (2679, 175, 'Alba', 'AB', 0), (2680, 175, 'Arad', 'AR', 0), (2681, 175, 'Argeș', 'AG', 0), (2682, 175, 'Bacău', 'BC', 0), (2683, 175, 'Bihor', 'BH', 0), (2684, 175, 'Bistrița-Năsăud', 'BN', 0), (2685, 175, 'Botoșani', 'BT', 0), (2686, 175, 'Brașov', 'BV', 0), (2687, 175, 'Brăila', 'BR', 0), (2688, 175, 'București', 'B', 0), (2689, 175, 'Buzău', 'BZ', 0), (2690, 175, 'Caraș-Severin', 'CS', 0), (2691, 175, 'Călărași', 'CL', 0), (2692, 175, 'Cluj', 'CJ', 0), (2693, 175, 'Constanța', 'CT', 0), (2694, 175, 'Covasna', 'CV', 0), (2695, 175, 'Dâmbovița', 'DB', 0), (2696, 175, 'Dolj', 'DJ', 0), (2697, 175, 'Galați', 'GL', 0), (2698, 175, 'Giurgiu', 'GR', 0), (2699, 175, 'Gorj', 'GJ', 0), (2700, 175, 'Harghita', 'HR', 0), (2701, 175, 'Hunedoara', 'HD', 0), (2702, 175, 'Ialomița', 'IL', 0), (2703, 175, 'Iași', 'IS', 0), (2704, 175, 'Ilfov', 'IF', 0), (2705, 175, 'Maramureș', 'MM', 0), (2706, 175, 'Mehedinți', 'MH', 0), (2707, 175, 'Mureș', 'MS', 0), (2708, 175, 'Neamț', 'NT', 0), (2709, 175, 'Olt', 'OT', 0), (2710, 175, 'Prahova', 'PH', 0), (2711, 175, 'Satu-Mare', 'SM', 0), (2712, 175, 'Sălaj', 'SJ', 0), (2713, 175, 'Sibiu', 'SB', 0), (2714, 175, 'Suceava', 'SV', 0), (2715, 175, 'Teleorman', 'TR', 0), (2716, 175, 'Timiș', 'TM', 0), (2717, 175, 'Tulcea', 'TL', 0), (2718, 175, 'Vaslui', 'VS', 0), (2719, 175, 'Vâlcea', 'VL', 0), (2720, 175, 'Vrancea', 'VN', 0), (2809, 177, 'Butare', 'BU', 0), (2810, 177, 'Byumba', 'BY', 0), (2811, 177, 'Cyangugu', 'CY', 0), (2812, 177, 'Gikongoro', 'GK', 0), (2813, 177, 'Gisenyi', 'GS', 0), (2814, 177, 'Gitarama', 'GT', 0), (2815, 177, 'Kibungo', 'KG', 0), (2816, 177, 'Kibuye', 'KY', 0), (2817, 177, 'Kigali Rurale', 'KR', 0), (2818, 177, 'Kigali-ville', 'KV', 0), (2819, 177, 'Ruhengeri', 'RU', 0), (2820, 177, 'Umutara', 'UM', 0), (2821, 178, 'Christ Church Nichola Town', 'CCN', 0), (2822, 178, 'Saint Anne Sandy Point', 'SAS', 0), (2823, 178, 'Saint George Basseterre', 'SGB', 0), (2824, 178, 'Saint George Gingerland', 'SGG', 0), (2825, 178, 'Saint James Windward', 'SJW', 0), (2826, 178, 'Saint John Capesterre', 'SJC', 0), (2827, 178, 'Saint John Figtree', 'SJF', 0), (2828, 178, 'Saint Mary Cayon', 'SMC', 0), (2829, 178, 'Saint Paul Capesterre', 'CAP', 0), (2830, 178, 'Saint Paul Charlestown', 'CHA', 0), (2831, 178, 'Saint Peter Basseterre', 'SPB', 0), (2832, 178, 'Saint Thomas Lowland', 'STL', 0), (2833, 178, 'Saint Thomas Middle Island', 'STM', 0), (2834, 178, 'Trinity Palmetto Point', 'TPP', 0), (2835, 179, 'Anse-la-Raye', 'AR', 0), (2836, 179, 'Castries', 'CA', 0), (2837, 179, 'Choiseul', 'CH', 0), (2838, 179, 'Dauphin', 'DA', 0), (2839, 179, 'Dennery', 'DE', 0), (2840, 179, 'Gros-Islet', 'GI', 0), (2841, 179, 'Laborie', 'LA', 0), (2842, 179, 'Micoud', 'MI', 0), (2843, 179, 'Praslin', 'PR', 0), (2844, 179, 'Soufriere', 'SO', 0), (2845, 179, 'Vieux-Fort', 'VF', 0), (2846, 180, 'Charlotte', 'C', 0), (2847, 180, 'Grenadines', 'R', 0), (2848, 180, 'Saint Andrew', 'A', 0), (2849, 180, 'Saint David', 'D', 0), (2850, 180, 'Saint George', 'G', 0), (2851, 180, 'Saint Patrick', 'P', 0), (2852, 181, 'Aana', 'AN', 0), (2853, 181, 'Aiga-i-le-Tai', 'AI', 0), (2854, 181, 'Atua', 'AT', 0), (2855, 181, 'Faasaleleaga', 'FA', 0), (2856, 181, 'Gagaemauga', 'GE', 0), (2857, 181, 'Gagaifomauga', 'GF', 0), (2858, 181, 'Palauli', 'PA', 0), (2859, 181, 'Satupaitea', 'SA', 0), (2860, 181, 'Tuamasaga', 'TU', 0), (2861, 181, 'Vaa-o-Fonoti', 'VF', 0), (2862, 181, 'Vaisigano', 'VS', 0), (2863, 182, 'Acquaviva', 'AC', 0), (2864, 182, 'Borgo Maggiore', 'BM', 0), (2865, 182, 'Chiesanuova', 'CH', 0), (2866, 182, 'Domagnano', 'DO', 0), (2867, 182, 'Faetano', 'FA', 0), (2868, 182, 'Fiorentino', 'FI', 0), (2869, 182, 'Montegiardino', 'MO', 0), (2870, 182, 'Citta di San Marino', 'SM', 0), (2871, 182, 'Serravalle', 'SE', 0), (2872, 183, 'Sao Tome', 'S', 0), (2873, 183, 'Principe', 'P', 0), (2874, 184, 'Al Bahah', 'BH', 0), (2875, 184, 'Al Hudud ash Shamaliyah', 'HS', 0), (2876, 184, 'Al Jawf', 'JF', 0), (2877, 184, 'Al Madinah', 'MD', 0), (2878, 184, 'Al Qasim', 'QS', 0), (2879, 184, 'Ar Riyad', 'RD', 0), (2880, 184, 'Ash Sharqiyah (Eastern)', 'AQ', 0), (2881, 184, 'Asir', 'AS', 0), (2882, 184, 'Hail', 'HL', 0), (2883, 184, 'Jizan', 'JZ', 0), (2884, 184, 'Makkah', 'ML', 0), (2885, 184, 'Najran', 'NR', 0), (2886, 184, 'Tabuk', 'TB', 0), (2887, 185, 'Dakar', 'DA', 0), (2888, 185, 'Diourbel', 'DI', 0), (2889, 185, 'Fatick', 'FA', 0), (2890, 185, 'Kaolack', 'KA', 0), (2891, 185, 'Kolda', 'KO', 0), (2892, 185, 'Louga', 'LO', 0), (2893, 185, 'Matam', 'MA', 0), (2894, 185, 'Saint-Louis', 'SL', 0), (2895, 185, 'Tambacounda', 'TA', 0), (2896, 185, 'Thies', 'TH', 0), (2897, 185, 'Ziguinchor', 'ZI', 0), (2898, 186, 'Anse aux Pins', 'AP', 0), (2899, 186, 'Anse Boileau', 'AB', 0), (2900, 186, 'Anse Etoile', 'AE', 0), (2901, 186, 'Anse Louis', 'AL', 0), (2902, 186, 'Anse Royale', 'AR', 0), (2903, 186, 'Baie Lazare', 'BL', 0), (2904, 186, 'Baie Sainte Anne', 'BS', 0), (2905, 186, 'Beau Vallon', 'BV', 0), (2906, 186, 'Bel Air', 'BA', 0), (2907, 186, 'Bel Ombre', 'BO', 0), (2908, 186, 'Cascade', 'CA', 0), (2909, 186, 'Glacis', 'GL', 0), (2910, 186, 'Grand Anse (on Mahe)', 'GM', 0), (2911, 186, 'Grand Anse (on Praslin)', 'GP', 0), (2912, 186, 'La Digue', 'DG', 0), (2913, 186, 'La Riviere Anglaise', 'RA', 0), (2914, 186, 'Mont Buxton', 'MB', 0), (2915, 186, 'Mont Fleuri', 'MF', 0), (2916, 186, 'Plaisance', 'PL', 0), (2917, 186, 'Pointe La Rue', 'PR', 0), (2918, 186, 'Port Glaud', 'PG', 0), (2919, 186, 'Saint Louis', 'SL', 0), (2920, 186, 'Takamaka', 'TA', 0), (2921, 187, 'Eastern', 'E', 0), (2922, 187, 'Northern', 'N', 0), (2923, 187, 'Southern', 'S', 0), (2924, 187, 'Western', 'W', 0), (2925, 189, 'Banskobystrický', 'BC', 0), (2926, 189, 'Bratislavský', 'BL', 0), (2927, 189, 'Košický', 'KI', 0), (2928, 189, 'Nitriansky', 'NI', 0), (2929, 189, 'Prešovský', 'PV', 0), (2930, 189, 'Trenčiansky', 'TC', 0), (2931, 189, 'Trnavský', 'TA', 0), (2932, 189, 'Žilinský', 'ZI', 0), (2933, 191, 'Central', 'CE', 0), (2934, 191, 'Choiseul', 'CH', 0), (2935, 191, 'Guadalcanal', 'GC', 0), (2936, 191, 'Honiara', 'HO', 0), (2937, 191, 'Isabel', 'IS', 0), (2938, 191, 'Makira', 'MK', 0), (2939, 191, 'Malaita', 'ML', 0), (2940, 191, 'Rennell and Bellona', 'RB', 0), (2941, 191, 'Temotu', 'TM', 0), (2942, 191, 'Western', 'WE', 0), (2943, 192, 'Awdal', 'AW', 0), (2944, 192, 'Bakool', 'BK', 0), (2945, 192, 'Banaadir', 'BN', 0), (2946, 192, 'Bari', 'BR', 0), (2947, 192, 'Bay', 'BY', 0), (2948, 192, 'Galguduud', 'GA', 0), (2949, 192, 'Gedo', 'GE', 0), (2950, 192, 'Hiiraan', 'HI', 0), (2951, 192, 'Jubbada Dhexe', 'JD', 0), (2952, 192, 'Jubbada Hoose', 'JH', 0), (2953, 192, 'Mudug', 'MU', 0), (2954, 192, 'Nugaal', 'NU', 0), (2955, 192, 'Sanaag', 'SA', 0), (2956, 192, 'Shabeellaha Dhexe', 'SD', 0), (2957, 192, 'Shabeellaha Hoose', 'SH', 0), (2958, 192, 'Sool', 'SL', 0), (2959, 192, 'Togdheer', 'TO', 0), (2960, 192, 'Woqooyi Galbeed', 'WG', 0), (2961, 193, 'Eastern Cape', 'EC', 0), (2962, 193, 'Free State', 'FS', 0), (2963, 193, 'Gauteng', 'GP', 0), (2964, 193, 'KwaZulu-Natal', 'KZN', 0), (2965, 193, 'Limpopo', 'LP', 0), (2966, 193, 'Mpumalanga', 'MP', 0), (2967, 193, 'North West', 'NW', 0), (2968, 193, 'Northern Cape', 'NC', 0), (2969, 193, 'Western Cape', 'WC', 0), (2970, 195, 'La Coruña', 'C', 0), (2971, 195, 'Álava', 'VI', 0), (2972, 195, 'Albacete', 'AB', 0), (2973, 195, 'Alicante', 'A', 0), (2974, 195, 'Almeria', 'AL', 0), (2975, 195, 'Asturias', 'O', 0), (2976, 195, 'Ávila', 'AV', 0), (2977, 195, 'Badajoz', 'BA', 0), (2978, 195, 'Baleares', 'IB', 0), (2979, 195, 'Barcelona', 'B', 0), (2980, 195, 'Burgos', 'BU', 0), (2981, 195, 'Cáceres', 'CC', 0), (2982, 195, 'Cádiz', 'CA', 0), (2983, 195, 'Cantabria', 'S', 0), (2984, 195, 'Castellón', 'CS', 0), (2985, 195, 'Ceuta', 'CE', 0), (2986, 195, 'Ciudad Real', 'CR', 0), (2987, 195, 'Córdoba', 'CO', 0), (2988, 195, 'Cuenca', 'CU', 0), (2989, 195, 'Girona', 'GI', 0), (2990, 195, 'Granada', 'GR', 0), (2991, 195, 'Guadalajara', 'GU', 0), (2992, 195, 'Guipúzcoa', 'SS', 0), (2993, 195, 'Huelva', 'H', 0), (2994, 195, 'Huesca', 'HU', 0), (2995, 195, 'Jaén', 'J', 0), (2996, 195, 'La Rioja', 'LO', 0), (2997, 195, 'Las Palmas', 'GC', 0), (2998, 195, 'Leon', 'CL', 0), (2999, 195, 'Lleida', 'L', 0), (3000, 195, 'Lugo', 'LU', 0), (3001, 195, 'Madrid', 'M', 0), (3002, 195, 'Malaga', 'MA', 0), (3003, 195, 'Melilla', 'ML', 0), (3004, 195, 'Murcia', 'MU', 0), (3005, 195, 'Navarra', 'NA', 0), (3006, 195, 'Ourense', 'OR', 0), (3007, 195, 'Palencia', 'P', 0), (3008, 195, 'Pontevedra', 'PO', 0), (3009, 195, 'Salamanca', 'SA', 0), (3010, 195, 'Santa Cruz de Tenerife', 'TF', 0), (3011, 195, 'Segovia', 'SG', 0), (3012, 195, 'Sevilla', 'SE', 0), (3013, 195, 'Soria', 'SO', 0), (3014, 195, 'Tarragona', 'T', 0), (3015, 195, 'Teruel', 'TE', 0), (3016, 195, 'Toledo', 'TO', 0), (3017, 195, 'Valencia', 'V', 0), (3018, 195, 'Valladolid', 'VA', 0), (3019, 195, 'Bizkaia', 'BI', 0), (3020, 195, 'Zamora', 'ZA', 0), (3021, 195, 'Zaragoza', 'Z', 0), (3022, 196, 'Central', 'CE', 0), (3023, 196, 'Eastern', 'EA', 0), (3024, 196, 'North Central', 'NC', 0), (3025, 196, 'Northern', 'NO', 0), (3026, 196, 'North Western', 'NW', 0), (3027, 196, 'Sabaragamuwa', 'SA', 0), (3028, 196, 'Southern', 'SO', 0), (3029, 196, 'Uva', 'UV', 0), (3030, 196, 'Western', 'WE', 0), (3032, 197, 'Saint Helena', 'S', 0), (3034, 199, 'Aali an Nil', 'ANL', 0), (3035, 199, 'Al Bahr al Ahmar', 'BAM', 0), (3036, 199, 'Al Buhayrat', 'BRT', 0), (3037, 199, 'Al Jazirah', 'JZR', 0), (3038, 199, 'Al Khartum', 'KRT', 0), (3039, 199, 'Al Qadarif', 'QDR', 0), (3040, 199, 'Al Wahdah', 'WDH', 0), (3041, 199, 'An Nil al Abyad', 'ANB', 0), (3042, 199, 'An Nil al Azraq', 'ANZ', 0), (3043, 199, 'Ash Shamaliyah', 'ASH', 0), (3044, 199, 'Bahr al Jabal', 'BJA', 0), (3045, 199, 'Gharb al Istiwaiyah', 'GIS', 0), (3046, 199, 'Gharb Bahr al Ghazal', 'GBG', 0), (3047, 199, 'Gharb Darfur', 'GDA', 0), (3048, 199, 'Gharb Kurdufan', 'GKU', 0), (3049, 199, 'Janub Darfur', 'JDA', 0), (3050, 199, 'Janub Kurdufan', 'JKU', 0), (3051, 199, 'Junqali', 'JQL', 0), (3052, 199, 'Kassala', 'KSL', 0), (3053, 199, 'Nahr an Nil', 'NNL', 0), (3054, 199, 'Shamal Bahr al Ghazal', 'SBG', 0), (3055, 199, 'Shamal Darfur', 'SDA', 0), (3056, 199, 'Shamal Kurdufan', 'SKU', 0), (3057, 199, 'Sharq al Istiwaiyah', 'SIS', 0), (3058, 199, 'Sinnar', 'SNR', 0), (3059, 199, 'Warab', 'WRB', 0), (3060, 200, 'Brokopondo', 'BR', 0), (3061, 200, 'Commewijne', 'CM', 0), (3062, 200, 'Coronie', 'CR', 0), (3063, 200, 'Marowijne', 'MA', 0), (3064, 200, 'Nickerie', 'NI', 0), (3065, 200, 'Para', 'PA', 0), (3066, 200, 'Paramaribo', 'PM', 0), (3067, 200, 'Saramacca', 'SA', 0), (3068, 200, 'Sipaliwini', 'SI', 0), (3069, 200, 'Wanica', 'WA', 0), (3070, 202, 'Hhohho', 'H', 0), (3071, 202, 'Lubombo', 'L', 0), (3072, 202, 'Manzini', 'M', 0), (3073, 202, 'Shishelweni', 'S', 0), (3074, 203, 'Blekinge', 'K', 0), (3075, 203, 'Dalarna', 'W', 0), (3076, 203, 'Gävleborg', 'X', 0), (3077, 203, 'Gotland', 'I', 0), (3078, 203, 'Halland', 'N', 0), (3079, 203, 'Jämtland', 'Z', 0), (3080, 203, 'Jönköping', 'F', 0), (3081, 203, 'Kalmar', 'H', 0), (3082, 203, 'Kronoberg', 'G', 0), (3083, 203, 'Norrbotten', 'BD', 0), (3084, 203, 'Örebro', 'T', 0), (3085, 203, 'Östergötland', 'E', 0), (3086, 203, 'Skåne', 'M', 0), (3087, 203, 'Södermanland', 'D', 0), (3088, 203, 'Stockholm', 'AB', 0), (3089, 203, 'Uppsala', 'C', 0), (3090, 203, 'Värmland', 'S', 0), (3091, 203, 'Västerbotten', 'AC', 0), (3092, 203, 'Västernorrland', 'Y', 0), (3093, 203, 'Västmanland', 'U', 0), (3094, 203, 'Västra Götaland', 'O', 0), (3095, 204, 'Aargau', 'AG', 0), (3096, 204, 'Appenzell Ausserrhoden', 'AR', 0), (3097, 204, 'Appenzell Innerrhoden', 'AI', 0), (3098, 204, 'Basel-Stadt', 'BS', 0), (3099, 204, 'Basel-Landschaft', 'BL', 0), (3100, 204, 'Bern', 'BE', 0), (3101, 204, 'Fribourg', 'FR', 0), (3102, 204, 'Genève', 'GE', 0), (3103, 204, 'Glarus', 'GL', 0), (3104, 204, 'Graubünden', 'GR', 0), (3105, 204, 'Jura', 'JU', 0), (3106, 204, 'Luzern', 'LU', 0), (3107, 204, 'Neuchâtel', 'NE', 0), (3108, 204, 'Nidwald', 'NW', 0), (3109, 204, 'Obwald', 'OW', 0), (3110, 204, 'St. Gallen', 'SG', 0), (3111, 204, 'Schaffhausen', 'SH', 0), (3112, 204, 'Schwyz', 'SZ', 0), (3113, 204, 'Solothurn', 'SO', 0), (3114, 204, 'Thurgau', 'TG', 0), (3115, 204, 'Ticino', 'TI', 0), (3116, 204, 'Uri', 'UR', 0), (3117, 204, 'Valais', 'VS', 0), (3118, 204, 'Vaud', 'VD', 0), (3119, 204, 'Zug', 'ZG', 0), (3120, 204, 'Zürich', 'ZH', 0), (3121, 205, 'Al Hasakah', 'HA', 0), (3122, 205, 'Al Ladhiqiyah', 'LA', 0), (3123, 205, 'Al Qunaytirah', 'QU', 0), (3124, 205, 'Ar Raqqah', 'RQ', 0), (3125, 205, 'As Suwayda', 'SU', 0), (3126, 205, 'Dara', 'DA', 0), (3127, 205, 'Dayr az Zawr', 'DZ', 0), (3128, 205, 'Dimashq', 'DI', 0), (3129, 205, 'Halab', 'HL', 0), (3130, 205, 'Hamah', 'HM', 0), (3131, 205, 'Hims', 'HI', 0), (3132, 205, 'Idlib', 'ID', 0), (3133, 205, 'Rif Dimashq', 'RD', 0), (3134, 205, 'Tartus', 'TA', 0), (3135, 206, 'Chang-hua', 'CH', 0), (3136, 206, 'Chia-i', 'CI', 0), (3137, 206, 'Hsin-chu', 'HS', 0), (3138, 206, 'Hua-lien', 'HL', 0), (3139, 206, 'I-lan', 'IL', 0), (3140, 206, 'Kao-hsiung county', 'KH', 0), (3141, 206, 'Kin-men', 'KM', 0), (3142, 206, 'Lien-chiang', 'LC', 0), (3143, 206, 'Miao-li', 'ML', 0), (3144, 206, 'Nan-tou', 'NT', 0), (3145, 206, 'Peng-hu', 'PH', 0), (3146, 206, 'Ping-tung', 'PT', 0), (3147, 206, 'Tai-chung', 'TG', 0), (3148, 206, 'Tai-nan', 'TA', 0), (3149, 206, 'Tai-pei county', 'TP', 0), (3150, 206, 'Tai-tung', 'TT', 0), (3151, 206, 'Tao-yuan', 'TY', 0), (3152, 206, 'Yun-lin', 'YL', 0), (3153, 206, 'Chia-i city', 'CC', 0), (3154, 206, 'Chi-lung', 'CL', 0), (3155, 206, 'Hsin-chu', 'HC', 0), (3156, 206, 'Tai-chung', 'TH', 0), (3157, 206, 'Tai-nan', 'TN', 0), (3158, 206, 'Kao-hsiung city', 'KC', 0), (3159, 206, 'Tai-pei city', 'TC', 0), (3160, 207, 'Gorno-Badakhstan', 'GB', 0), (3161, 207, 'Khatlon', 'KT', 0), (3162, 207, 'Sughd', 'SU', 0), (3163, 208, 'Arusha', 'AR', 0), (3164, 208, 'Dar es Salaam', 'DS', 0), (3165, 208, 'Dodoma', 'DO', 0), (3166, 208, 'Iringa', 'IR', 0), (3167, 208, 'Kagera', 'KA', 0), (3168, 208, 'Kigoma', 'KI', 0), (3169, 208, 'Kilimanjaro', 'KJ', 0), (3170, 208, 'Lindi', 'LN', 0), (3171, 208, 'Manyara', 'MY', 0), (3172, 208, 'Mara', 'MR', 0), (3173, 208, 'Mbeya', 'MB', 0), (3174, 208, 'Morogoro', 'MO', 0), (3175, 208, 'Mtwara', 'MT', 0), (3176, 208, 'Mwanza', 'MW', 0), (3177, 208, 'Pemba North', 'PN', 0), (3178, 208, 'Pemba South', 'PS', 0), (3179, 208, 'Pwani', 'PW', 0), (3180, 208, 'Rukwa', 'RK', 0), (3181, 208, 'Ruvuma', 'RV', 0), (3182, 208, 'Shinyanga', 'SH', 0), (3183, 208, 'Singida', 'SI', 0), (3184, 208, 'Tabora', 'TB', 0), (3185, 208, 'Tanga', 'TN', 0), (3186, 208, 'Zanzibar Central/South', 'ZC', 0), (3187, 208, 'Zanzibar North', 'ZN', 0), (3188, 208, 'Zanzibar Urban/West', 'ZU', 0), (3189, 209, 'Amnat Charoen', '37', 0), (3190, 209, 'Ang Thong', '15', 0), (3192, 209, 'Bangkok', '10', 0), (3193, 209, 'Buri Ram', '31', 0), (3194, 209, 'Chachoengsao', '24', 0), (3195, 209, 'Chai Nat', '18', 0), (3196, 209, 'Chaiyaphum', '36', 0), (3197, 209, 'Chanthaburi', '22', 0), (3198, 209, 'Chiang Mai', '50', 0), (3199, 209, 'Chiang Rai', '57', 0), (3200, 209, 'Chon Buri', '20', 0), (3201, 209, 'Chumphon', '86', 0), (3202, 209, 'Kalasin', '46', 0), (3203, 209, 'Kamphaeng Phet', '62', 0), (3204, 209, 'Kanchanaburi', '71', 0), (3205, 209, 'Khon Kaen', '40', 0), (3206, 209, 'Krabi', '81', 0), (3207, 209, 'Lampang', '52', 0), (3208, 209, 'Lamphun', '51', 0), (3209, 209, 'Loei', '42', 0), (3210, 209, 'Lop Buri', '1', 0), (3211, 209, 'Mae Hong Son', '55', 0), (3212, 209, 'Maha Sarakham', '44', 0), (3213, 209, 'Mukdahan', '49', 0), (3214, 209, 'Nakhon Nayok', '26', 0), (3215, 209, 'Nakhon Pathom', '73', 0), (3216, 209, 'Nakhon Phanom', '48', 0), (3217, 209, 'Nakhon Ratchasima', '30', 0), (3218, 209, 'Nakhon Sawan', '60', 0), (3219, 209, 'Nakhon Si Thammarat', '80', 0), (3220, 209, 'Nan', '55', 0), (3221, 209, 'Narathiwat', '96', 0), (3222, 209, 'Nong Bua Lamphu', '39', 0), (3223, 209, 'Nong Khai', '43', 0), (3224, 209, 'Nonthaburi', '12', 0), (3225, 209, 'Pathum Thani', '13', 0), (3226, 209, 'Pattani', '94', 0), (3227, 209, 'Phangnga', '82', 0), (3228, 209, 'Phatthalung', '93', 0), (3229, 209, 'Phayao', 'Phayao', 0), (3230, 209, 'Phetchabun', '67', 0), (3231, 209, 'Phetchaburi', '76', 0), (3232, 209, 'Phichit', '66', 0), (3233, 209, 'Phitsanulok', '65', 0), (3234, 209, 'Phrae', '54', 0), (3235, 209, 'Phuket', '83', 0), (3236, 209, 'Prachin Buri', '25', 0), (3237, 209, 'Prachuap Khiri Khan', '77', 0), (3238, 209, 'Ranong', '21', 0), (3239, 209, 'Ratchaburi', '70', 0), (3240, 209, 'Rayong', '21', 0), (3241, 209, 'Roi Et', '45', 0), (3242, 209, 'Sa Kaeo', '27', 0), (3243, 209, 'Sakon Nakhon', '47', 0), (3244, 209, 'Samut Prakan', '11', 0), (3245, 209, 'Samut Sakhon', '74', 0), (3246, 209, 'Samut Songkhram', '75', 0), (3247, 209, 'Saraburi', '19', 0), (3248, 209, 'Satun', '91', 0), (3249, 209, 'Sing Buri', '17', 0), (3250, 209, 'Si Sa Ket', '33', 0), (3251, 209, 'Songkhla', '90', 0), (3252, 209, 'Sukhothai', '64', 0), (3253, 209, 'Suphan Buri', '72', 0), (3254, 209, 'Surat Thani', '84', 0), (3255, 209, 'Surin', '32', 0), (3256, 209, 'Tak', '63', 0), (3257, 209, 'Trang', '92', 0), (3258, 209, 'Trat', '23', 0), (3259, 209, 'Ubon Ratchathani', '34', 0), (3260, 209, 'Udon Thani', '41', 0), (3261, 209, 'Uthai Thani', '61', 0), (3262, 209, 'Uttaradit', '53', 0), (3263, 209, 'Yala', '95', 0), (3264, 209, 'Yasothon', '35', 0), (3265, 210, 'Kara', 'K', 0), (3266, 210, 'Plateaux', 'P', 0), (3267, 210, 'Savanes', 'S', 0), (3268, 210, 'Centrale', 'C', 0), (3269, 210, 'Maritime', 'M', 0), (3270, 211, 'Atafu', 'A', 0), (3271, 211, 'Fakaofo', 'F', 0), (3272, 211, 'Nukunonu', 'N', 0), (3273, 212, 'Haapai', 'H', 0), (3274, 212, 'Tongatapu', 'T', 0), (3275, 212, 'Vavau', 'V', 0), (3276, 213, 'Couva/Tabaquite/Talparo', 'CT', 0), (3277, 213, 'Diego Martin', 'DM', 0), (3278, 213, 'Mayaro/Rio Claro', 'MR', 0), (3279, 213, 'Penal/Debe', 'PD', 0), (3280, 213, 'Princes Town', 'PT', 0), (3281, 213, 'Sangre Grande', 'SG', 0), (3282, 213, 'San Juan/Laventille', 'SL', 0), (3283, 213, 'Siparia', 'SI', 0), (3284, 213, 'Tunapuna/Piarco', 'TP', 0), (3285, 213, 'Port of Spain', 'PS', 0), (3286, 213, 'San Fernando', 'SF', 0), (3287, 213, 'Arima', 'AR', 0), (3288, 213, 'Point Fortin', 'PF', 0), (3289, 213, 'Chaguanas', 'CH', 0), (3290, 213, 'Tobago', 'TO', 0), (3291, 214, 'Ariana', 'AR', 0), (3292, 214, 'Beja', 'BJ', 0), (3293, 214, 'Ben Arous', 'BA', 0), (3294, 214, 'Bizerte', 'BI', 0), (3295, 214, 'Gabes', 'GB', 0), (3296, 214, 'Gafsa', 'GF', 0), (3297, 214, 'Jendouba', 'JE', 0), (3298, 214, 'Kairouan', 'KR', 0), (3299, 214, 'Kasserine', 'KS', 0), (3300, 214, 'Kebili', 'KB', 0), (3301, 214, 'Kef', 'KF', 0), (3302, 214, 'Mahdia', 'MH', 0), (3303, 214, 'Manouba', 'MN', 0), (3304, 214, 'Medenine', 'ME', 0), (3305, 214, 'Monastir', 'MO', 0), (3306, 214, 'Nabeul', 'NA', 0), (3307, 214, 'Sfax', 'SF', 0), (3308, 214, 'Sidi', 'SD', 0), (3309, 214, 'Siliana', 'SL', 0), (3310, 214, 'Sousse', 'SO', 0), (3311, 214, 'Tataouine', 'TA', 0), (3312, 214, 'Tozeur', 'TO', 0), (3313, 214, 'Tunis', 'TU', 0), (3314, 214, 'Zaghouan', 'ZA', 0), (3315, 215, 'Adana', 'TR-01', 0), (3316, 215, 'Adıyaman', 'TR-02', 0), (3317, 215, 'Afyonkarahisar', 'TR-03', 0), (3318, 215, 'Ağrı', 'TR-04', 0), (3319, 215, 'Aksaray', 'TR-68', 0), (3320, 215, 'Amasya', 'TR-05', 0), (3321, 215, 'Ankara', 'TR-06', 0), (3322, 215, 'Antalya', 'TR-07', 0), (3323, 215, 'Ardahan', 'TR-75', 0), (3324, 215, 'Artvin', 'TR-08', 0), (3325, 215, 'Aydın', 'TR-09', 0), (3326, 215, 'Balıkesir', 'TR-10', 0), (3327, 215, 'Bartın', 'TR-74', 0), (3328, 215, 'Batman', 'TR-72', 0), (3329, 215, 'Bayburt', 'TR-69', 0), (3330, 215, 'Bilecik', 'TR-11', 0), (3331, 215, 'Bingöl', 'TR-12', 0), (3332, 215, 'Bitlis', 'TR-13', 0), (3333, 215, 'Bolu', 'TR-14', 0), (3334, 215, 'Burdur', 'TR-15', 0), (3335, 215, 'Bursa', 'TR-16', 0), (3336, 215, 'Çanakkale', 'TR-17', 0), (3337, 215, 'Çankırı', 'TR-18', 0), (3338, 215, 'Çorum', 'TR-19', 0), (3339, 215, 'Denizli', 'TR-20', 0), (3340, 215, 'Diyarbakır', 'TR-21', 0), (3341, 215, 'Düzce', 'TR-81', 0), (3342, 215, 'Edirne', 'TR-22', 0), (3343, 215, 'Elazığ', 'TR-23', 0), (3344, 215, 'Erzincan', 'TR-24', 0), (3345, 215, 'Erzurum', 'TR-25', 0), (3346, 215, 'Eskişehir', 'TR-26', 0), (3347, 215, 'Gaziantep', 'TR-27', 0), (3348, 215, 'Giresun', 'TR-28', 0), (3349, 215, 'Gümüşhane', 'TR-29', 0), (3350, 215, 'Hakkari', 'TR-30', 0), (3351, 215, 'Hatay', 'TR-31', 0), (3352, 215, 'Iğdır', 'TR-76', 0), (3353, 215, 'Isparta', 'TR-32', 0), (3354, 215, 'İstanbul', 'TR-34', 0), (3355, 215, 'İzmir', 'TR-35', 0), (3356, 215, 'Kahramanmaraş', 'TR-46', 0), (3357, 215, 'Karabük', 'TR-78', 0), (3358, 215, 'Karaman', 'TR-70', 0), (3359, 215, 'Kars', 'TR-36', 0), (3360, 215, 'Kastamonu', 'TR-37', 0), (3361, 215, 'Kayseri', 'TR-38', 0), (3362, 215, 'Kilis', 'TR-79', 0), (3363, 215, 'Kırıkkale', 'TR-71', 0), (3364, 215, 'Kırklareli', 'TR-39', 0), (3365, 215, 'Kırşehir', 'TR-40', 0), (3366, 215, 'Kocaeli', 'TR-41', 0), (3367, 215, 'Konya', 'TR-42', 0), (3368, 215, 'Kütahya', 'TR-43', 0), (3369, 215, 'Malatya', 'TR-44', 0), (3370, 215, 'Manisa', 'TR-45', 0), (3371, 215, 'Mardin', 'TR-47', 0), (3372, 215, 'Mersin', 'TR-33', 0), (3373, 215, 'Muğla', 'TR-48', 0), (3374, 215, 'Muş', 'TR-49', 0), (3375, 215, 'Nevşehir', 'TR-50', 0), (3376, 215, 'Niğde', 'TR-51', 0), (3377, 215, 'Ordu', 'TR-52', 0), (3378, 215, 'Osmaniye', 'TR-80', 0), (3379, 215, 'Rize', 'TR-53', 0), (3380, 215, 'Sakarya', 'TR-54', 0), (3381, 215, 'Samsun', 'TR-55', 0), (3382, 215, 'Şanlıurfa', 'TR-63', 0), (3383, 215, 'Siirt', 'TR-56', 0), (3384, 215, 'Sinop', 'TR-57', 0), (3385, 215, 'Şırnak', 'TR-73', 0), (3386, 215, 'Sivas', 'TR-58', 0), (3387, 215, 'Tekirdağ', 'TR-59', 0), (3388, 215, 'Tokat', 'TR-60', 0), (3389, 215, 'Trabzon', 'TR-61', 0), (3390, 215, 'Tunceli', 'TR-62', 0), (3391, 215, 'Uşak', 'TR-64', 0), (3392, 215, 'Van', 'TR-65', 0), (3393, 215, 'Yalova', 'TR-77', 0), (3394, 215, 'Yozgat', 'TR-66', 0), (3395, 215, 'Zonguldak', 'TR-67', 0), (3396, 216, 'Ahal Welayaty', 'A', 0), (3397, 216, 'Balkan Welayaty', 'B', 0), (3398, 216, 'Dashhowuz Welayaty', 'D', 0), (3399, 216, 'Lebap Welayaty', 'L', 0), (3400, 216, 'Mary Welayaty', 'M', 0), (3401, 217, 'Ambergris Cays', 'AC', 0), (3402, 217, 'Dellis Cay', 'DC', 0), (3403, 217, 'French Cay', 'FC', 0), (3404, 217, 'Little Water Cay', 'LW', 0), (3405, 217, 'Parrot Cay', 'RC', 0), (3406, 217, 'Pine Cay', 'PN', 0), (3407, 217, 'Salt Cay', 'SL', 0), (3408, 217, 'Grand Turk', 'GT', 0), (3409, 217, 'South Caicos', 'SC', 0), (3410, 217, 'East Caicos', 'EC', 0), (3411, 217, 'Middle Caicos', 'MC', 0), (3412, 217, 'North Caicos', 'NC', 0), (3413, 217, 'Providenciales', 'PR', 0), (3414, 217, 'West Caicos', 'WC', 0), (3415, 218, 'Nanumanga', 'NMG', 0), (3416, 218, 'Niulakita', 'NLK', 0), (3417, 218, 'Niutao', 'NTO', 0), (3418, 218, 'Funafuti', 'FUN', 0), (3419, 218, 'Nanumea', 'NME', 0), (3420, 218, 'Nui', 'NUI', 0), (3421, 218, 'Nukufetau', 'NFT', 0), (3422, 218, 'Nukulaelae', 'NLL', 0), (3423, 218, 'Vaitupu', 'VAI', 0), (3424, 219, 'Kalangala', 'KAL', 0), (3425, 219, 'Kampala', 'KMP', 0), (3426, 219, 'Kayunga', 'KAY', 0), (3427, 219, 'Kiboga', 'KIB', 0), (3428, 219, 'Luwero', 'LUW', 0), (3429, 219, 'Masaka', 'MAS', 0), (3430, 219, 'Mpigi', 'MPI', 0), (3431, 219, 'Mubende', 'MUB', 0), (3432, 219, 'Mukono', 'MUK', 0), (3433, 219, 'Nakasongola', 'NKS', 0), (3434, 219, 'Rakai', 'RAK', 0), (3435, 219, 'Sembabule', 'SEM', 0), (3436, 219, 'Wakiso', 'WAK', 0), (3437, 219, 'Bugiri', 'BUG', 0), (3438, 219, 'Busia', 'BUS', 0), (3439, 219, 'Iganga', 'IGA', 0), (3440, 219, 'Jinja', 'JIN', 0), (3441, 219, 'Kaberamaido', 'KAB', 0), (3442, 219, 'Kamuli', 'KML', 0), (3443, 219, 'Kapchorwa', 'KPC', 0), (3444, 219, 'Katakwi', 'KTK', 0), (3445, 219, 'Kumi', 'KUM', 0), (3446, 219, 'Mayuge', 'MAY', 0), (3447, 219, 'Mbale', 'MBA', 0), (3448, 219, 'Pallisa', 'PAL', 0), (3449, 219, 'Sironko', 'SIR', 0), (3450, 219, 'Soroti', 'SOR', 0), (3451, 219, 'Tororo', 'TOR', 0), (3452, 219, 'Adjumani', 'ADJ', 0), (3453, 219, 'Apac', 'APC', 0), (3454, 219, 'Arua', 'ARU', 0), (3455, 219, 'Gulu', 'GUL', 0), (3456, 219, 'Kitgum', 'KIT', 0), (3457, 219, 'Kotido', 'KOT', 0), (3458, 219, 'Lira', 'LIR', 0), (3459, 219, 'Moroto', 'MRT', 0), (3460, 219, 'Moyo', 'MOY', 0), (3461, 219, 'Nakapiripirit', 'NAK', 0), (3462, 219, 'Nebbi', 'NEB', 0), (3463, 219, 'Pader', 'PAD', 0), (3464, 219, 'Yumbe', 'YUM', 0), (3465, 219, 'Bundibugyo', 'BUN', 0), (3466, 219, 'Bushenyi', 'BSH', 0), (3467, 219, 'Hoima', 'HOI', 0), (3468, 219, 'Kabale', 'KBL', 0), (3469, 219, 'Kabarole', 'KAR', 0), (3470, 219, 'Kamwenge', 'KAM', 0), (3471, 219, 'Kanungu', 'KAN', 0), (3472, 219, 'Kasese', 'KAS', 0), (3473, 219, 'Kibaale', 'KBA', 0), (3474, 219, 'Kisoro', 'KIS', 0), (3475, 219, 'Kyenjojo', 'KYE', 0), (3476, 219, 'Masindi', 'MSN', 0), (3477, 219, 'Mbarara', 'MBR', 0), (3478, 219, 'Ntungamo', 'NTU', 0), (3479, 219, 'Rukungiri', 'RUK', 0), (3480, 220, 'Cherkaska', '23', 0), (3481, 220, 'Chernihivska', '25', 0), (3482, 220, 'Chernivetska', '24', 0), (3483, 220, 'Avtonomna Respublika Krym', '27', 0), (3484, 220, 'Dnipropetrovska', '04', 0), (3485, 220, 'Donetska', '05', 0), (3486, 220, 'Ivano-Frankivska', '09', 0), (3487, 220, 'Khersonska', '21', 0), (3488, 220, 'Khmelnytska', '22', 0), (3489, 220, 'Kirovohradska', '35', 0), (3490, 220, 'Kyiv', '26', 0), (3491, 220, 'Kyivska', '10', 0), (3492, 220, 'Luhanska', '12', 0), (3493, 220, 'Lvivska', '13', 0), (3494, 220, 'Mykolaivska', '14', 0), (3495, 220, 'Odeska', '15', 0), (3496, 220, 'Poltavska', '16', 0), (3497, 220, 'Rivnenska', '17', 0), (3498, 220, 'Sevastopol', '28', 0), (3499, 220, 'Sumska', '18', 0), (3500, 220, 'Ternopilska', '19', 0), (3501, 220, 'Vinnytska', '02', 0), (3502, 220, 'Volynska', '03', 0), (3503, 220, 'Zakarpatska', '07', 0), (3504, 220, 'Zaporizka', '08', 0), (3505, 220, 'Zhytomyrskа', '06', 0), (3506, 221, 'Abu Dhabi', 'ADH', 0), (3507, 221, 'Ajman', 'AJ', 0), (3508, 221, 'Al Fujayrah', 'FU', 0), (3509, 221, 'Ash Shāriqah', 'SH', 0), (3510, 221, 'Dubai', 'DU', 0), (3511, 221, 'Ra’s al Khaymah', 'RK', 0), (3512, 221, 'Umm al Qaywayn', 'UQ', 0), (3513, 222, 'Aberdeen', 'ABN', 1), (3514, 222, 'Aberdeenshire', 'ABNS', 1), (3515, 222, 'Anglesey', 'ANG', 1), (3516, 222, 'Angus', 'AGS', 1), (3517, 222, 'Argyll and Bute', 'ARY', 1), (3518, 222, 'Bedfordshire', 'BEDS', 1), (3519, 222, 'Berkshire', 'BERKS', 1), (3520, 222, 'Blaenau Gwent', 'BLA', 1), (3521, 222, 'Bridgend', 'BRI', 1), (3522, 222, 'Bristol', 'BSTL', 1), (3523, 222, 'Buckinghamshire', 'BUCKS', 1), (3524, 222, 'Caerphilly', 'CAE', 1), (3525, 222, 'Cambridgeshire', 'CAMBS', 1), (3526, 222, 'Cardiff', 'CDF', 1), (3527, 222, 'Carmarthenshire', 'CARM', 1), (3528, 222, 'Ceredigion', 'CDGN', 1), (3529, 222, 'Cheshire', 'CHES', 1), (3530, 222, 'Clackmannanshire', 'CLACK', 1), (3531, 222, 'Conwy', 'CON', 1), (3532, 222, 'Cornwall', 'CORN', 1), (3533, 222, 'Denbighshire', 'DNBG', 1), (3534, 222, 'Derbyshire', 'DERBY', 1), (3535, 222, 'Devon', 'DVN', 1), (3536, 222, 'Dorset', 'DOR', 1), (3537, 222, 'Dumfries and Galloway', 'DGL', 1), (3538, 222, 'Dundee', 'DUND', 1), (3539, 222, 'Durham', 'DHM', 1), (3540, 222, 'East Ayrshire', 'ARYE', 1), (3541, 222, 'East Dunbartonshire', 'DUNBE', 1), (3542, 222, 'East Lothian', 'LOTE', 1), (3543, 222, 'East Renfrewshire', 'RENE', 1), (3544, 222, 'East Riding of Yorkshire', 'ERYS', 1), (3545, 222, 'East Sussex', 'SXE', 1), (3546, 222, 'Edinburgh', 'EDIN', 1), (3547, 222, 'Essex', 'ESX', 1), (3548, 222, 'Falkirk', 'FALK', 1), (3549, 222, 'Fife', 'FFE', 1), (3550, 222, 'Flintshire', 'FLINT', 1), (3551, 222, 'Glasgow', 'GLAS', 1), (3552, 222, 'Gloucestershire', 'GLOS', 1), (3553, 222, 'Greater London', 'LDN', 1), (3554, 222, 'Greater Manchester', 'MCH', 1), (3555, 222, 'Gwynedd', 'GDD', 1), (3556, 222, 'Hampshire', 'HANTS', 1), (3557, 222, 'Herefordshire', 'HWR', 1), (3558, 222, 'Hertfordshire', 'HERTS', 1), (3559, 222, 'Highlands', 'HLD', 1), (3560, 222, 'Inverclyde', 'IVER', 1), (3561, 222, 'Isle of Wight', 'IOW', 1), (3562, 222, 'Kent', 'KNT', 1), (3563, 222, 'Lancashire', 'LANCS', 1), (3564, 222, 'Leicestershire', 'LEICS', 1), (3565, 222, 'Lincolnshire', 'LINCS', 1), (3566, 222, 'Merseyside', 'MSY', 1), (3567, 222, 'Merthyr Tydfil', 'MERT', 1), (3568, 222, 'Midlothian', 'MLOT', 1), (3569, 222, 'Monmouthshire', 'MMOUTH', 1), (3570, 222, 'Moray', 'MORAY', 1), (3571, 222, 'Neath Port Talbot', 'NPRTAL', 1), (3572, 222, 'Newport', 'NEWPT', 1), (3573, 222, 'Norfolk', 'NOR', 1), (3574, 222, 'North Ayrshire', 'ARYN', 1), (3575, 222, 'North Lanarkshire', 'LANN', 1), (3576, 222, 'North Yorkshire', 'YSN', 1), (3577, 222, 'Northamptonshire', 'NHM', 1), (3578, 222, 'Northumberland', 'NLD', 1), (3579, 222, 'Nottinghamshire', 'NOT', 1), (3580, 222, 'Orkney Islands', 'ORK', 1), (3581, 222, 'Oxfordshire', 'OFE', 1), (3582, 222, 'Pembrokeshire', 'PEM', 1), (3583, 222, 'Perth and Kinross', 'PERTH', 1), (3584, 222, 'Powys', 'PWS', 1), (3585, 222, 'Renfrewshire', 'REN', 1), (3586, 222, 'Rhondda Cynon Taff', 'RHON', 1), (3587, 222, 'Rutland', 'RUT', 1), (3588, 222, 'Scottish Borders', 'BOR', 1), (3589, 222, 'Shetland Islands', 'SHET', 1), (3590, 222, 'Shropshire', 'SPE', 1), (3591, 222, 'Somerset', 'SOM', 1), (3592, 222, 'South Ayrshire', 'ARYS', 1), (3593, 222, 'South Lanarkshire', 'LANS', 1), (3594, 222, 'South Yorkshire', 'YSS', 1), (3595, 222, 'Staffordshire', 'SFD', 1), (3596, 222, 'Stirling', 'STIR', 1), (3597, 222, 'Suffolk', 'SFK', 1), (3598, 222, 'Surrey', 'SRY', 1), (3599, 222, 'Swansea', 'SWAN', 1), (3600, 222, 'Torfaen', 'TORF', 1), (3601, 222, 'Tyne and Wear', 'TWR', 1), (3602, 222, 'Vale of Glamorgan', 'VGLAM', 1), (3603, 222, 'Warwickshire', 'WARKS', 1), (3604, 222, 'West Dunbartonshire', 'WDUN', 1), (3605, 222, 'West Lothian', 'WLOT', 1), (3606, 222, 'West Midlands', 'WMD', 1), (3607, 222, 'West Sussex', 'SXW', 1), (3608, 222, 'West Yorkshire', 'YSW', 1), (3609, 222, 'Western Isles', 'WIL', 1), (3610, 222, 'Wiltshire', 'WLT', 1), (3611, 222, 'Worcestershire', 'WORCS', 1), (3612, 222, 'Wrexham', 'WRX', 1), (3949, 222, 'County Antrim', 'ANT', 1), (3950, 222, 'County Armagh', 'ARM', 1), (3951, 222, 'County Down', 'DOW', 1), (3952, 222, 'County Fermanagh', 'FER', 1), (3953, 222, 'County Londonderry', 'LDY', 1), (3954, 222, 'County Tyrone', 'TYR', 1), (3955, 222, 'Cumbria', 'CMA', 1), (3613, 223, 'Alabama', 'AL', 1), (3614, 223, 'Alaska', 'AK', 1), (3615, 223, 'American Samoa', 'AS', 1), (3616, 223, 'Arizona', 'AZ', 1), (3617, 223, 'Arkansas', 'AR', 1), (3618, 223, 'Armed Forces Africa', 'AF', 1), (3619, 223, 'Armed Forces Americas', 'AA', 1), (3620, 223, 'Armed Forces Canada', 'AC', 1), (3621, 223, 'Armed Forces Europe', 'AE', 1), (3622, 223, 'Armed Forces Middle East', 'AM', 1), (3623, 223, 'Armed Forces Pacific', 'AP', 1), (3624, 223, 'California', 'CA', 1), (3625, 223, 'Colorado', 'CO', 1), (3626, 223, 'Connecticut', 'CT', 1), (3627, 223, 'Delaware', 'DE', 1), (3628, 223, 'District of Columbia', 'DC', 1), (3629, 223, 'Federated States Of Micronesia', 'FM', 1), (3630, 223, 'Florida', 'FL', 1), (3631, 223, 'Georgia', 'GA', 1), (3632, 223, 'Guam', 'GU', 1), (3633, 223, 'Hawaii', 'HI', 1), (3634, 223, 'Idaho', 'ID', 1), (3635, 223, 'Illinois', 'IL', 1), (3636, 223, 'Indiana', 'IN', 1), (3637, 223, 'Iowa', 'IA', 1), (3638, 223, 'Kansas', 'KS', 1), (3639, 223, 'Kentucky', 'KY', 1), (3640, 223, 'Louisiana', 'LA', 1), (3641, 223, 'Maine', 'ME', 1), (3642, 223, 'Marshall Islands', 'MH', 1), (3643, 223, 'Maryland', 'MD', 1), (3644, 223, 'Massachusetts', 'MA', 1), (3645, 223, 'Michigan', 'MI', 1), (3646, 223, 'Minnesota', 'MN', 1), (3647, 223, 'Mississippi', 'MS', 1), (3648, 223, 'Missouri', 'MO', 1), (3649, 223, 'Montana', 'MT', 1), (3650, 223, 'Nebraska', 'NE', 1), (3651, 223, 'Nevada', 'NV', 1), (3652, 223, 'New Hampshire', 'NH', 1), (3653, 223, 'New Jersey', 'NJ', 1), (3654, 223, 'New Mexico', 'NM', 1), (3655, 223, 'New York', 'NY', 1), (3656, 223, 'North Carolina', 'NC', 1), (3657, 223, 'North Dakota', 'ND', 1), (3658, 223, 'Northern Mariana Islands', 'MP', 1), (3659, 223, 'Ohio', 'OH', 1), (3660, 223, 'Oklahoma', 'OK', 1), (3661, 223, 'Oregon', 'OR', 1), (3662, 223, 'Palau', 'PW', 1), (3663, 223, 'Pennsylvania', 'PA', 1), (3664, 223, 'Puerto Rico', 'PR', 1), (3665, 223, 'Rhode Island', 'RI', 1), (3666, 223, 'South Carolina', 'SC', 1), (3667, 223, 'South Dakota', 'SD', 1), (3668, 223, 'Tennessee', 'TN', 1), (3669, 223, 'Texas', 'TX', 1), (3670, 223, 'Utah', 'UT', 1), (3671, 223, 'Vermont', 'VT', 1), (3672, 223, 'Virgin Islands', 'VI', 1), (3673, 223, 'Virginia', 'VA', 1), (3674, 223, 'Washington', 'WA', 1), (3675, 223, 'West Virginia', 'WV', 1), (3676, 223, 'Wisconsin', 'WI', 1), (3677, 223, 'Wyoming', 'WY', 1), (3678, 224, 'Baker Island', 'BI', 0), (3679, 224, 'Howland Island', 'HI', 0), (3680, 224, 'Jarvis Island', 'JI', 0), (3681, 224, 'Johnston Atoll', 'JA', 0), (3682, 224, 'Kingman Reef', 'KR', 0), (3683, 224, 'Midway Atoll', 'MA', 0), (3684, 224, 'Navassa Island', 'NI', 0), (3685, 224, 'Palmyra Atoll', 'PA', 0), (3686, 224, 'Wake Island', 'WI', 0), (3687, 225, 'Artigas', 'AR', 0), (3688, 225, 'Canelones', 'CA', 0), (3689, 225, 'Cerro Largo', 'CL', 0), (3690, 225, 'Colonia', 'CO', 0), (3691, 225, 'Durazno', 'DU', 0), (3692, 225, 'Flores', 'FS', 0), (3693, 225, 'Florida', 'FA', 0), (3694, 225, 'Lavalleja', 'LA', 0), (3695, 225, 'Maldonado', 'MA', 0), (3696, 225, 'Montevideo', 'MO', 0), (3697, 225, 'Paysandu', 'PA', 0), (3698, 225, 'Rio Negro', 'RN', 0), (3699, 225, 'Rivera', 'RV', 0), (3700, 225, 'Rocha', 'RO', 0), (3701, 225, 'Salto', 'SL', 0), (3702, 225, 'San Jose', 'SJ', 0), (3703, 225, 'Soriano', 'SO', 0), (3704, 225, 'Tacuarembo', 'TA', 0), (3705, 225, 'Treinta y Tres', 'TT', 0), (3706, 226, 'Andijon', 'AN', 0), (3707, 226, 'Buxoro', 'BU', 0), (3708, 226, 'Fargona', 'FA', 0), (3709, 226, 'Jizzax', 'JI', 0), (3710, 226, 'Namangan', 'NG', 0), (3711, 226, 'Navoiy', 'NW', 0), (3712, 226, 'Qashqadaryo', 'QA', 0), (3713, 226, 'Qoraqalpogiston Republikasi', 'QR', 0), (3714, 226, 'Samarqand', 'SA', 0), (3715, 226, 'Sirdaryo', 'SI', 0), (3716, 226, 'Surxondaryo', 'SU', 0), (3717, 226, 'Toshkent City', 'TK', 0), (3718, 226, 'Toshkent Region', 'TO', 0), (3719, 226, 'Xorazm', 'XO', 0), (3720, 227, 'Malampa', 'MA', 0), (3721, 227, 'Penama', 'PE', 0), (3722, 227, 'Sanma', 'SA', 0), (3723, 227, 'Shefa', 'SH', 0), (3724, 227, 'Tafea', 'TA', 0), (3725, 227, 'Torba', 'TO', 0), (3726, 229, 'Amazonas', 'Z', 0), (3727, 229, 'Anzoategui', 'B', 0), (3728, 229, 'Apure', 'C', 0), (3729, 229, 'Aragua', 'D', 0), (3730, 229, 'Barinas', 'E', 0), (3731, 229, 'Bolivar', 'F', 0), (3732, 229, 'Carabobo', 'G', 0), (3733, 229, 'Cojedes', 'H', 0), (3734, 229, 'Delta Amacuro', 'Y', 0), (3735, 229, 'Dependencias Federales', 'W', 0), (3736, 229, 'Distrito Capital', 'A', 0), (3737, 229, 'Falcon', 'I', 0), (3738, 229, 'Guarico', 'J', 0), (3739, 229, 'Lara', 'K', 0), (3740, 229, 'Merida', 'L', 0), (3741, 229, 'Miranda', 'M', 0), (3742, 229, 'Monagas', 'N', 0), (3743, 229, 'Nueva Esparta', 'O', 0), (3744, 229, 'Portuguesa', 'P', 0), (3745, 229, 'Sucre', 'R', 0), (3746, 229, 'Tachira', 'S', 0), (3747, 229, 'Trujillo', 'T', 0), (3748, 229, 'Vargas', 'X', 0), (3749, 229, 'Yaracuy', 'U', 0), (3750, 229, 'Zulia', 'V', 0), (3751, 230, 'An Giang', 'AG', 0), (3752, 230, 'Bac Giang', 'BG', 0), (3753, 230, 'Bac Kan', 'BK', 0), (3754, 230, 'Bac Lieu', 'BL', 0), (3755, 230, 'Bac Ninh', 'BC', 0), (3756, 230, 'Ba Ria-Vung Tau', 'BR', 0), (3757, 230, 'Ben Tre', 'BN', 0), (3758, 230, 'Binh Dinh', 'BH', 0), (3759, 230, 'Binh Duong', 'BU', 0), (3760, 230, 'Binh Phuoc', 'BP', 0), (3761, 230, 'Binh Thuan', 'BT', 0), (3762, 230, 'Ca Mau', 'CM', 0), (3763, 230, 'Can Tho', 'CT', 0), (3764, 230, 'Cao Bang', 'CB', 0), (3765, 230, 'Dak Lak', 'DL', 0), (3766, 230, 'Dak Nong', 'DG', 0), (3767, 230, 'Da Nang', 'DN', 0), (3768, 230, 'Dien Bien', 'DB', 0), (3769, 230, 'Dong Nai', 'DI', 0), (3770, 230, 'Dong Thap', 'DT', 0), (3771, 230, 'Gia Lai', 'GL', 0), (3772, 230, 'Ha Giang', 'HG', 0), (3773, 230, 'Hai Duong', 'HD', 0), (3774, 230, 'Hai Phong', 'HP', 0), (3775, 230, 'Ha Nam', 'HM', 0), (3776, 230, 'Ha Noi', 'HI', 0), (3777, 230, 'Ha Tay', 'HT', 0), (3778, 230, 'Ha Tinh', 'HH', 0), (3779, 230, 'Hoa Binh', 'HB', 0), (3780, 230, 'Ho Chi Minh City', 'HC', 0), (3781, 230, 'Hau Giang', 'HU', 0), (3782, 230, 'Hung Yen', 'HY', 0), (3783, 232, 'Saint Croix', 'C', 0), (3784, 232, 'Saint John', 'J', 0), (3785, 232, 'Saint Thomas', 'T', 0), (3786, 233, 'Alo', 'A', 0), (3787, 233, 'Sigave', 'S', 0), (3788, 233, 'Wallis', 'W', 0), (3789, 235, 'Abyan', 'AB', 0), (3790, 235, 'Adan', 'AD', 0), (3791, 235, 'Amran', 'AM', 0), (3792, 235, 'Al Bayda', 'BA', 0), (3793, 235, 'Ad Dali', 'DA', 0), (3794, 235, 'Dhamar', 'DH', 0), (3795, 235, 'Hadramawt', 'HD', 0), (3796, 235, 'Hajjah', 'HJ', 0), (3797, 235, 'Al Hudaydah', 'HU', 0), (3798, 235, 'Ibb', 'IB', 0), (3799, 235, 'Al Jawf', 'JA', 0), (3800, 235, 'Lahij', 'LA', 0), (3801, 235, 'Marib', 'MA', 0), (3802, 235, 'Al Mahrah', 'MR', 0), (3803, 235, 'Al Mahwit', 'MW', 0), (3804, 235, 'Sadah', 'SD', 0), (3805, 235, 'Sana', 'SN', 0), (3806, 235, 'Shabwah', 'SH', 0), (3807, 235, 'Taizz', 'TA', 0), (3812, 237, 'Bas-Congo', 'BC', 0), (3813, 237, 'Bandundu', 'BN', 0), (3814, 237, 'Equateur', 'EQ', 0), (3815, 237, 'Katanga', 'KA', 0), (3816, 237, 'Kasai-Oriental', 'KE', 0), (3817, 237, 'Kinshasa', 'KN', 0), (3818, 237, 'Kasai-Occidental', 'KW', 0), (3819, 237, 'Maniema', 'MA', 0), (3820, 237, 'Nord-Kivu', 'NK', 0), (3821, 237, 'Orientale', 'OR', 0), (3822, 237, 'Sud-Kivu', 'SK', 0), (3823, 238, 'Central', 'CE', 0), (3824, 238, 'Copperbelt', 'CB', 0), (3825, 238, 'Eastern', 'EA', 0), (3826, 238, 'Luapula', 'LP', 0), (3827, 238, 'Lusaka', 'LK', 0), (3828, 238, 'Northern', 'NO', 0), (3829, 238, 'North-Western', 'NW', 0), (3830, 238, 'Southern', 'SO', 0), (3831, 238, 'Western', 'WE', 0), (3832, 239, 'Bulawayo', 'BU', 0), (3833, 239, 'Harare', 'HA', 0), (3834, 239, 'Manicaland', 'ML', 0), (3835, 239, 'Mashonaland Central', 'MC', 0), (3836, 239, 'Mashonaland East', 'ME', 0), (3837, 239, 'Mashonaland West', 'MW', 0), (3838, 239, 'Masvingo', 'MV', 0), (3839, 239, 'Matabeleland North', 'MN', 0), (3840, 239, 'Matabeleland South', 'MS', 0), (3841, 239, 'Midlands', 'MD', 0), (3842, 105, 'Agrigento', 'AG', 0), (3843, 105, 'Alessandria', 'AL', 0), (3844, 105, 'Ancona', 'AN', 0), (3845, 105, 'Aosta', 'AO', 0), (3846, 105, 'Arezzo', 'AR', 0), (3847, 105, 'Ascoli Piceno', 'AP', 0), (3848, 105, 'Asti', 'AT', 0), (3849, 105, 'Avellino', 'AV', 0), (3850, 105, 'Bari', 'BA', 0), (3851, 105, 'Belluno', 'BL', 0), (3852, 105, 'Benevento', 'BN', 0), (3853, 105, 'Bergamo', 'BG', 0), (3854, 105, 'Biella', 'BI', 0), (3855, 105, 'Bologna', 'BO', 0), (3856, 105, 'Bolzano', 'BZ', 0), (3857, 105, 'Brescia', 'BS', 0), (3858, 105, 'Brindisi', 'BR', 0), (3859, 105, 'Cagliari', 'CA', 0), (3860, 105, 'Caltanissetta', 'CL', 0), (3861, 105, 'Campobasso', 'CB', 0), (3863, 105, 'Caserta', 'CE', 0), (3864, 105, 'Catania', 'CT', 0), (3865, 105, 'Catanzaro', 'CZ', 0), (3866, 105, 'Chieti', 'CH', 0), (3867, 105, 'Como', 'CO', 0), (3868, 105, 'Cosenza', 'CS', 0), (3869, 105, 'Cremona', 'CR', 0), (3870, 105, 'Crotone', 'KR', 0), (3871, 105, 'Cuneo', 'CN', 0), (3872, 105, 'Enna', 'EN', 0), (3873, 105, 'Ferrara', 'FE', 0), (3874, 105, 'Firenze', 'FI', 0), (3875, 105, 'Foggia', 'FG', 0), (3876, 105, 'Forli-Cesena', 'FC', 0), (3877, 105, 'Frosinone', 'FR', 0), (3878, 105, 'Genova', 'GE', 0), (3879, 105, 'Gorizia', 'GO', 0), (3880, 105, 'Grosseto', 'GR', 0), (3881, 105, 'Imperia', 'IM', 0), (3882, 105, 'Isernia', 'IS', 0), (3883, 105, 'L'Aquila', 'AQ', 0), (3884, 105, 'La Spezia', 'SP', 0), (3885, 105, 'Latina', 'LT', 0), (3886, 105, 'Lecce', 'LE', 0), (3887, 105, 'Lecco', 'LC', 0), (3888, 105, 'Livorno', 'LI', 0), (3889, 105, 'Lodi', 'LO', 0), (3890, 105, 'Lucca', 'LU', 0), (3891, 105, 'Macerata', 'MC', 0), (3892, 105, 'Mantova', 'MN', 0), (3893, 105, 'Massa-Carrara', 'MS', 0), (3894, 105, 'Matera', 'MT', 0), (3896, 105, 'Messina', 'ME', 0), (3897, 105, 'Milano', 'MI', 0), (3898, 105, 'Modena', 'MO', 0), (3899, 105, 'Napoli', 'NA', 0), (3900, 105, 'Novara', 'NO', 0), (3901, 105, 'Nuoro', 'NU', 0), (3904, 105, 'Oristano', 'OR', 0), (3905, 105, 'Padova', 'PD', 0), (3906, 105, 'Palermo', 'PA', 0), (3907, 105, 'Parma', 'PR', 0), (3908, 105, 'Pavia', 'PV', 0), (3909, 105, 'Perugia', 'PG', 0), (3910, 105, 'Pesaro e Urbino', 'PU', 0), (3911, 105, 'Pescara', 'PE', 0), (3912, 105, 'Piacenza', 'PC', 0), (3913, 105, 'Pisa', 'PI', 0), (3914, 105, 'Pistoia', 'PT', 0), (3915, 105, 'Pordenone', 'PN', 0), (3916, 105, 'Potenza', 'PZ', 0), (3917, 105, 'Prato', 'PO', 0), (3918, 105, 'Ragusa', 'RG', 0), (3919, 105, 'Ravenna', 'RA', 0), (3920, 105, 'Reggio Calabria', 'RC', 0), (3921, 105, 'Reggio Emilia', 'RE', 0), (3922, 105, 'Rieti', 'RI', 0), (3923, 105, 'Rimini', 'RN', 0), (3924, 105, 'Roma', 'RM', 0), (3925, 105, 'Rovigo', 'RO', 0), (3926, 105, 'Salerno', 'SA', 0), (3927, 105, 'Sassari', 'SS', 0), (3928, 105, 'Savona', 'SV', 0), (3929, 105, 'Siena', 'SI', 0), (3930, 105, 'Siracusa', 'SR', 0), (3931, 105, 'Sondrio', 'SO', 0), (3932, 105, 'Taranto', 'TA', 0), (3933, 105, 'Teramo', 'TE', 0), (3934, 105, 'Terni', 'TR', 0), (3935, 105, 'Torino', 'TO', 0), (3936, 105, 'Trapani', 'TP', 0), (3937, 105, 'Trento', 'TN', 0), (3938, 105, 'Treviso', 'TV', 0), (3939, 105, 'Trieste', 'TS', 0), (3940, 105, 'Udine', 'UD', 0), (3941, 105, 'Varese', 'VA', 0), (3942, 105, 'Venezia', 'VE', 0), (3943, 105, 'Verbano-Cusio-Ossola', 'VB', 0), (3944, 105, 'Vercelli', 'VC', 0), (3945, 105, 'Verona', 'VR', 0), (3946, 105, 'Vibo Valentia', 'VV', 0), (3947, 105, 'Vicenza', 'VI', 0), (3948, 105, 'Viterbo', 'VT', 0), (3956, 190, 'Pomurska', '1', 0), (3957, 190, 'Podravska', '2', 0), (3958, 190, 'Koroška', '3', 0), (3959, 190, 'Savinjska', '4', 0), (3960, 190, 'Zasavska', '5', 0), (3961, 190, 'Spodnjeposavska', '6', 0), (3962, 190, 'Jugovzhodna Slovenija', '7', 0), (3963, 190, 'Osrednjeslovenska', '8', 0), (3964, 190, 'Gorenjska', '9', 0), (3965, 190, 'Notranjsko-kraška', '10', 0), (3966, 190, 'Goriška', '11', 0), (3967, 190, 'Obalno-kraška', '12', 0), (3968, 33, 'Ruse', '', 0), (3969, 101, 'Alborz', 'ALB', 0), (3970, 21, 'Brussels-Capital Region', 'BRU', 0), (3971, 138, 'Aguascalientes', 'AG', 0), (3973, 242, 'Andrijevica', '01', 0), (3974, 242, 'Bar', '02', 0), (3975, 242, 'Berane', '03', 0), (3976, 242, 'Bijelo Polje', '04', 0), (3977, 242, 'Budva', '05', 0), (3978, 242, 'Cetinje', '06', 0), (3979, 242, 'Danilovgrad', '07', 0), (3980, 242, 'Herceg-Novi', '08', 0), (3981, 242, 'Kolašin', '09', 0), (3982, 242, 'Kotor', '10', 0), (3983, 242, 'Mojkovac', '11', 0), (3984, 242, 'Nikšić', '12', 0), (3985, 242, 'Plav', '13', 0), (3986, 242, 'Pljevlja', '14', 0), (3987, 242, 'Plužine', '15', 0), (3988, 242, 'Podgorica', '16', 0), (3989, 242, 'Rožaje', '17', 0), (3990, 242, 'Šavnik', '18', 0), (3991, 242, 'Tivat', '19', 0), (3992, 242, 'Ulcinj', '20', 0), (3993, 242, 'Žabljak', '21', 0), (3994, 243, 'Belgrade', '00', 0), (3995, 243, 'North Bačka', '01', 0), (3996, 243, 'Central Banat', '02', 0), (3997, 243, 'North Banat', '03', 0), (3998, 243, 'South Banat', '04', 0), (3999, 243, 'West Bačka', '05', 0), (4000, 243, 'South Bačka', '06', 0), (4001, 243, 'Srem', '07', 0), (4002, 243, 'Mačva', '08', 0), (4003, 243, 'Kolubara', '09', 0), (4004, 243, 'Podunavlje', '10', 0), (4005, 243, 'Braničevo', '11', 0), (4006, 243, 'Šumadija', '12', 0), (4007, 243, 'Pomoravlje', '13', 0), (4008, 243, 'Bor', '14', 0), (4009, 243, 'Zaječar', '15', 0), (4010, 243, 'Zlatibor', '16', 0), (4011, 243, 'Moravica', '17', 0), (4012, 243, 'Raška', '18', 0), (4013, 243, 'Rasina', '19', 0), (4014, 243, 'Nišava', '20', 0), (4015, 243, 'Toplica', '21', 0), (4016, 243, 'Pirot', '22', 0), (4017, 243, 'Jablanica', '23', 0), (4018, 243, 'Pčinja', '24', 0), (4020, 245, 'Bonaire', 'BO', 0), (4021, 245, 'Saba', 'SA', 0), (4022, 245, 'Sint Eustatius', 'SE', 0), (4023, 248, 'Central Equatoria', 'EC', 0), (4024, 248, 'Eastern Equatoria', 'EE', 0), (4025, 248, 'Jonglei', 'JG', 0), (4026, 248, 'Lakes', 'LK', 0), (4027, 248, 'Northern Bahr el-Ghazal', 'BN', 0), (4028, 248, 'Unity', 'UY', 0), (4029, 248, 'Upper Nile', 'NU', 0), (4030, 248, 'Warrap', 'WR', 0), (4031, 248, 'Western Bahr el-Ghazal', 'BW', 0), (4032, 248, 'Western Equatoria', 'EW', 0), (4035, 129, 'Putrajaya', 'MY-16', 0), (4038, 117, 'Aizkraukles novads', '002', 0), (4040, 117, 'Aizputes novads', '003', 0), (4042, 117, 'Aknīstes novads', '004', 0), (4044, 117, 'Alojas novads', '005', 0), (4045, 117, 'Alsungas novads', '006', 0), (4047, 117, 'Alūksnes novads', '007', 0), (4048, 117, 'Amatas novads', '008', 0), (4050, 117, 'Apes novads', '008', 0), (4052, 117, 'Auces novads', '010', 0), (4053, 117, 'Ādažu novads', '011', 0), (4054, 117, 'Babītes novads', '012', 0), (4056, 117, 'Baldones novads', '013', 0), (4058, 117, 'Baltinavas novads', '014', 0), (4060, 117, 'Balvu novads', '015', 0), (4062, 117, 'Bauskas novads', '016', 0), (4063, 117, 'Beverīnas novads', '017', 0), (4065, 117, 'Brocēnu novads', '018', 0), (4066, 117, 'Burtnieku novads', '019', 0), (4067, 117, 'Carnikavas novads', '020', 0), (4069, 117, 'Cesvaines novads', '021', 0), (4071, 117, 'Cēsu novads', '022', 0), (4072, 117, 'Ciblas novads', '023', 0), (4074, 117, 'Dagdas novads', '024', 0), (4075, 117, 'Daugavpils', 'DGV', 0), (4076, 117, 'Daugavpils novads', '025', 0), (4078, 117, 'Dobeles novads', '026', 0), (4079, 117, 'Dundagas novads', '027', 0), (4081, 117, 'Durbes novads', '028', 0), (4082, 117, 'Engures novads', '029', 0), (4083, 117, 'Ērgļu novads', '030', 0), (4084, 117, 'Garkalnes novads', '031', 0), (4086, 117, 'Grobiņas novads', '032', 0), (4088, 117, 'Gulbenes novads', '033', 0), (4089, 117, 'Iecavas novads', '034', 0), (4091, 117, 'Ikšķiles novads', '035', 0), (4093, 117, 'Ilūkstes novads', '036', 0), (4094, 117, 'Inčukalna novads', '037', 0), (4096, 117, 'Jaunjelgavas novads', '038', 0), (4097, 117, 'Jaunpiebalgas novads', '039', 0), (4098, 117, 'Jaunpils novads', '040', 0), (4099, 117, 'Jelgava', 'JEL', 0), (4100, 117, 'Jelgavas novads', '041', 0), (4101, 117, 'Jēkabpils', 'JKB', 0), (4102, 117, 'Jēkabpils novads', '042', 0), (4103, 117, 'Jūrmala', 'JUR', 0), (4106, 117, 'Kandavas novads', '043', 0), (4108, 117, 'Kārsavas novads', '044', 0), (4110, 117, 'Kokneses novads', '046', 0), (4112, 117, 'Krāslavas novads', '047', 0), (4113, 117, 'Krimuldas novads', '048', 0), (4114, 117, 'Krustpils novads', '049', 0), (4116, 117, 'Kuldīgas novads', '050', 0), (4117, 117, 'Ķeguma novads', '051', 0), (4119, 117, 'Ķekavas novads', '052', 0), (4121, 117, 'Lielvārdes novads', '053', 0), (4122, 117, 'Liepāja', 'LPX', 0), (4124, 117, 'Limbažu novads', '054', 0), (4126, 117, 'Līgatnes novads', '055', 0), (4128, 117, 'Līvānu novads', '056', 0), (4130, 117, 'Lubānas novads', '057', 0), (4132, 117, 'Ludzas novads', '058', 0), (4134, 117, 'Madonas novads', '059', 0), (4136, 117, 'Mazsalacas novads', '060', 0), (4137, 117, 'Mālpils novads', '061', 0), (4138, 117, 'Mārupes novads', '062', 0), (4139, 117, 'Mērsraga novads', '063', 0), (4140, 117, 'Naukšēnu novads', '064', 0), (4141, 117, 'Neretas novads', '065', 0), (4142, 117, 'Nīcas novads', '066', 0), (4144, 117, 'Ogres novads', '067', 0), (4146, 117, 'Olaines novads', '068', 0), (4147, 117, 'Ozolnieku novads', '069', 0), (4148, 117, 'Pārgaujas novads', '070', 0), (4150, 117, 'Pāvilostas novads', '071', 0), (4153, 117, 'Pļaviņu novads', '072', 0), (4155, 117, 'Preiļu novads', '073', 0), (4157, 117, 'Priekules novads', '074', 0), (4158, 117, 'Priekuļu novads', '075', 0), (4159, 117, 'Raunas novads', '076', 0), (4160, 117, 'Rēzekne', 'REZ', 0), (4161, 117, 'Rēzeknes novads', '077', 0), (4162, 117, 'Riebiņu novads', '078', 0), (4163, 117, 'Rīga', 'RIX', 0), (4164, 117, 'Rojas novads', '079', 0), (4165, 117, 'Ropažu novads', '080', 0), (4166, 117, 'Rucavas novads', '081', 0), (4167, 117, 'Rugāju novads', '082', 0), (4168, 117, 'Rundāles novads', '083', 0), (4170, 117, 'Rūjienas novads', '084', 0), (4173, 117, 'Salacgrīvas novads', '086', 0), (4174, 117, 'Salas novads', '085', 0), (4175, 117, 'Salaspils novads', '087', 0), (4177, 117, 'Saldus novads', '088', 0), (4178, 117, 'Saldus, Saldus novads', '0840201', 0), (4180, 117, 'Saulkrastu novads', '089', 0), (4182, 117, 'Sējas novads', '090', 0), (4184, 117, 'Siguldas novads', '091', 0), (4185, 117, 'Skrīveru novads', '092', 0), (4187, 117, 'Skrundas novads', '093', 0), (4189, 117, 'Smiltenes novads', '094', 0), (4192, 117, 'Stopiņu novads', '095', 0), (4194, 117, 'Strenču novads', '096', 0), (4197, 117, 'Talsu novads', '097', 0), (4198, 117, 'Tērvetes novads', '098', 0), (4199, 117, 'Tukuma novads', '099', 0), (4201, 117, 'Vaiņodes novads', '100', 0), (4204, 117, 'Valkas novads', '101', 0), (4205, 117, 'Valmiera', 'VMR', 0), (4208, 117, 'Varakļānu novads', '102', 0), (4209, 117, 'Vārkavas novads', '103', 0), (4210, 117, 'Vecpiebalgas novads', '104', 0), (4211, 117, 'Vecumnieku novads', '105', 0), (4212, 117, 'Ventspils', 'VEN', 0), (4213, 117, 'Ventspils novads', '106', 0), (4215, 117, 'Viesītes novads', '107', 0), (4217, 117, 'Viļakas novads', '108', 0), (4219, 117, 'Viļānu novads', '109', 0), (4221, 117, 'Zilupes novads', '110', 0), (4222, 43, 'Arica y Parinacota', 'AP', 0), (4223, 43, 'Los Rios', 'LR', 0), (4224, 220, 'Kharkivska Oblast', '63', 0), (4225, 118, 'Beirut', 'LB-BR', 0), (4226, 118, 'Bekaa', 'LB-BE', 0), (4227, 118, 'Mount Lebanon', 'LB-ML', 0), (4228, 118, 'Nabatieh', 'LB-NB', 0), (4229, 118, 'North', 'LB-NR', 0), (4230, 118, 'South', 'LB-ST', 0), (4231, 99, 'Telangana', 'TS', 0), (4232, 44, 'Qinghai', 'QH', 0), (4233, 100, 'Papua Barat', 'PB', 0), (4234, 100, 'Sulawesi Barat', 'SR', 0), (4235, 100, 'Kepulauan Riau', 'KR', 0), (4236, 105, 'Barletta-Andria-Trani', 'BT', 0), (4237, 105, 'Fermo', 'FM', 0), (4238, 105, 'Monza Brianza', 'MB', 0), (4239, 113, 'Seoul-teukbyeolsi', '11', 0), (4240, 113, 'Busan-gwangyeoksi', '26', 0), (4241, 113, 'Daegu-gwangyeoksi', '27', 0), (4242, 113, 'Daejeon-gwangyeoksi', '30', 0), (4243, 113, 'Gwangju-gwangyeoksi', '29', 0), (4244, 113, 'Incheon-gwangyeoksi', '28', 0), (4245, 113, 'Ulsan-gwangyeoksi', '31', 0), (4246, 113, 'Chungcheongbuk-do', '43', 0), (4247, 113, 'Chungcheongnam-do', '44', 0), (4248, 113, 'Gangwon-do', '42', 0), (4249, 113, 'Gyeonggi-do', '41', 0), (4250, 113, 'Gyeongsangbuk-do', '47', 0), (4251, 113, 'Gyeongsangnam-do', '48', 0), (4252, 113, 'Jeollabuk-do', '45', 0), (4253, 113, 'Jeollanam-do', '46', 0), (4254, 113, 'Jeju-teukbyeoljachido', '49', 0), (4255, 113, 'Sejong-teukbyeoljachisi', '50', 0), (4256, 209, 'Phra Nakhon Si Ayutthaya', '14', 0), (4257, 176, 'Adygea, Republic of', 'RU-AD', 0), (4258, 176, 'Bashkortostan, Republic of', 'RU-BA', 0), (4259, 176, 'Buryatia, Republic of', 'RU-BU', 0), (4260, 176, 'Altai Republic', 'RU-AL', 0), (4261, 176, 'Dagestan, Republic of', 'RU-DA', 0), (4262, 176, 'Ingushetia, Republic of', 'RU-IN', 0), (4263, 176, 'Kabardino-Balkar Republic', 'RU-KB', 0), (4264, 176, 'Kalmykia, Republic of', 'RU-KL', 0), (4265, 176, 'Karachay-Cherkess Republic', 'RU-KC', 0), (4266, 176, 'Karelia, Republic of', 'RU-KR', 0), (4267, 176, 'Komi Republic', 'RU-KO', 0), (4268, 176, 'Mari El Republic', 'RU-ME', 0), (4269, 176, 'Mordovia, Republic of', 'RU-MO', 0), (4270, 176, 'Sakha (Yakutia) Republic', 'RU-SA', 0), (4271, 176, 'North Ossetia-Alania, Republic of', 'RU-SE', 0), (4272, 176, 'Tatarstan, Republic of', 'RU-TA', 0), (4273, 176, 'Tuva Republic', 'RU-TY', 0), (4274, 176, 'Udmurt Republic', 'RU-UD', 0), (4275, 176, 'Khakassia, Republic of', 'RU-KK', 0), (4276, 176, 'Chechen Republic', 'RU-CE', 0), (4277, 176, 'Chuvash Republic', 'RU-CU', 0), (4278, 176, 'Altai Krai', 'RU-ALT', 0), (4279, 176, 'Krasnodar Krai', 'RU-KDA', 0), (4280, 176, 'Krasnoyarsk Krai', 'RU-KYA', 0), (4281, 176, 'Primorsky Krai', 'RU-PRI', 0), (4282, 176, 'Stavropol Krai', 'RU-STA', 0), (4283, 176, 'Khabarovsk Krai', 'RU-KHA', 0), (4284, 176, 'Amur Oblast', 'RU-AMU', 0), (4285, 176, 'Arkhangelsk Oblast', 'RU-ARK', 0), (4286, 176, 'Astrakhan Oblast', 'RU-AST', 0), (4287, 176, 'Belgorod Oblast', 'RU-BEL', 0), (4288, 176, 'Bryansk Oblast', 'RU-BRY', 0), (4289, 176, 'Vladimir Oblast', 'RU-VLA', 0), (4290, 176, 'Volgograd Oblast', 'RU-VGG', 0), (4291, 176, 'Vologda Oblast', 'RU-VLG', 0), (4292, 176, 'Voronezh Oblast', 'RU-VOR', 0), (4293, 176, 'Ivanovo Oblast', 'RU-IVA', 0), (4294, 176, 'Irkutsk Oblast', 'RU-IRK', 0), (4295, 176, 'Kaliningrad Oblast', 'RU-KGD', 0), (4296, 176, 'Kaluga Oblast', 'RU-KLU', 0), (4297, 176, 'Kamchatka Krai', 'RU-KAM', 0), (4298, 176, 'Kemerovo Oblast', 'RU-KEM', 0), (4299, 176, 'Kirov Oblast', 'RU-KIR', 0), (4300, 176, 'Kostroma Oblast', 'RU-KOS', 0), (4301, 176, 'Kurgan Oblast', 'RU-KGN', 0), (4302, 176, 'Kursk Oblast', 'RU-KRS', 0), (4303, 176, 'Leningrad Oblast', 'RU-LEN', 0), (4304, 176, 'Lipetsk Oblast', 'RU-LIP', 0), (4305, 176, 'Magadan Oblast', 'RU-MAG', 0), (4306, 176, 'Moscow Oblast', 'RU-MOS', 0), (4307, 176, 'Murmansk Oblast', 'RU-MUR', 0), (4308, 176, 'Nizhny Novgorod Oblast', 'RU-NIZ', 0), (4309, 176, 'Novgorod Oblast', 'RU-NGR', 0), (4310, 176, 'Novosibirsk Oblast', 'RU-NVS', 0), (4311, 176, 'Omsk Oblast', 'RU-OMS', 0), (4312, 176, 'Orenburg Oblast', 'RU-ORE', 0), (4313, 176, 'Oryol Oblast', 'RU-ORL', 0), (4314, 176, 'Penza Oblast', 'RU-PNZ', 0), (4315, 176, 'Perm Krai', 'RU-PER', 0), (4316, 176, 'Pskov Oblast', 'RU-PSK', 0), (4317, 176, 'Rostov Oblast', 'RU-ROS', 0), (4318, 176, 'Ryazan Oblast', 'RU-RYA', 0), (4319, 176, 'Samara Oblast', 'RU-SAM', 0), (4320, 176, 'Saratov Oblast', 'RU-SAR', 0), (4321, 176, 'Sakhalin Oblast', 'RU-SAK', 0), (4322, 176, 'Sverdlovsk Oblast', 'RU-SVE', 0), (4323, 176, 'Smolensk Oblast', 'RU-SMO', 0), (4324, 176, 'Tambov Oblast', 'RU-TAM', 0), (4325, 176, 'Tver Oblast', 'RU-TVE', 0), (4326, 176, 'Tomsk Oblast', 'RU-TOM', 0), (4327, 176, 'Tula Oblast', 'RU-TUL', 0), (4328, 176, 'Tyumen Oblast', 'RU-TYU', 0), (4329, 176, 'Ulyanovsk Oblast', 'RU-ULY', 0), (4330, 176, 'Chelyabinsk Oblast', 'RU-CHE', 0), (4331, 176, 'Zabaykalsky Krai', 'RU-ZAB', 0), (4332, 176, 'Yaroslavl Oblast', 'RU-YAR', 0), (4333, 176, 'Moscow', 'RU-MOW', 0), (4334, 176, 'Saint Petersburg', 'RU-SPE', 0), (4335, 176, 'Jewish Autonomous Oblast', 'RU-YEV', 0), (4336, 176, 'Nenets Autonomous Okrug', 'RU-NEN', 0), (4337, 176, 'Khanty–Mansi Autonomous Okrug – Yugra', 'RU-KHM', 0), (4338, 176, 'Chukotka Autonomous Okrug', 'RU-CHU', 0), (4339, 176, 'Yamalo-Nenets Autonomous Okrug', 'RU-YAN', 0), (4340, 117, 'Aglonas novads', '001', 0), (4341, 99, 'Chhattisgarh', 'CT', 0), (4342, 99, 'Ladakh', 'LA', 0), (4343, 99, 'Uttarakhand', 'UT', 1); INSERT INTO region VALUES (1, 1, 'Badakhshan', 'BDS', 0), (2, 1, 'Badghis', 'BDG', 0), (3, 1, 'Baghlan', 'BGL', 0), (4, 1, 'Balkh', 'BAL', 0), (5, 1, 'Bamian', 'BAM', 0), (6, 1, 'Farah', 'FRA', 0), (7, 1, 'Faryab', 'FYB', 0), (8, 1, 'Ghazni', 'GHA', 0), in /geoip/region.sql" Error code: "0"`

givanz · 2024-01-29T00:42:36Z

It looks like vvveb/install/sql/insert/geoip/region.sql which has 4000+ rows is too big for the sqlite configuration on your server.

I broke the file into 9 separate files so that it does not exceed 500 rows per file, hope it is in the limit of the server configuration.

Please redownload latest.zip and update /install/sql/insert/geoip/ folder.

2braincells2go · 2024-01-29T01:13:21Z

@givanz @oleteacher The code gods above us are testing us, lol

Will give the new version a try in the morning. We really appreciate your hard work Givan.

I did an install using MySQL and went very smooth. The whole system is very smooth. Only issue was chatGPT will not work. Get message that 70 is not an integer. Most likely (int) missing someplace. I recall having to fix an issue with chatGPT / json by placing (int) before the value: like (int)70;

givanz · 2024-01-29T18:24:03Z

The code gods above us are testing us, lol

Let's hope they are pleased with the fixes :)

Thanks for the bug report, chatGPT is fixed in the latest.zip

2braincells2go · 2024-01-29T22:10:39Z

@givanz The code gods are pleased with you Givan => I have no doubt! You are a man of patience :)

No go on the SQLite install. Choose SQLite as database and returned to thie scrren below. Still using SQLite V3.7.17:

No another note: if I wish to upgrade my MySQL install to make chatgpt work, can I simply overwrite files? Using check update in dashboard does not show new version.

givanz · 2024-01-29T22:30:56Z

Let's hope so :) it looks like this should be the last change and it should work.

It seems that fts5 support is missing here also as it's falling back to fts4.

This error happens because I forgot this line uncommented during sqlite testing

https://github.com/givanz/Vvveb/blob/master/install/sql/sqlite/schema/post/post_content-fts4.sql#L22

Please comment back or delete the line like and retry.

It's enough to overwrite files for chatgpt, no database changes were made.

Version is not currently increased for small changes for automatic updates.

oleteacher · 2024-01-29T23:09:46Z

Removing line 22 let the install proceed. Ended up with the messages below:

Site error
Internal server error!
The site is experiencing some dificulties, please try again, if the problem still persists please contact support.

Error
Unable to prepare statement: 1, near "(": syntax error
SELECT type as t, name, dflt_value as d, `notnull` as n FROM pragma_table_info('site');

File
/home/xxxxxxxisd/public_html/recommends/system/db/sqlite.php on line 204

Looks like the school firewall has had enough of me trying installs and causing errors, it just locked me out and message says I need a new security dongle... Anyway, will try later on my own server when I have time to update splite above 3.26.

givanz · 2024-01-30T00:04:45Z

The query looks fine, it also runs without errors on sqlite 3.37.2

Probably the schema is corrupt from something in fts4 configuration, I will try to reproduce it.

Is there a specific setup I can use to have the same configuration for tests?

I used AlmaLinux 8.9 for sqlite 3.26.0 tests should I use AlmaLinux 9 for sqlite 3.7.17?

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Not working in subdirectory #70

Not working in subdirectory #70

2braincells2go commented Jan 26, 2024 •

edited

Loading

givanz commented Jan 26, 2024

2braincells2go commented Jan 27, 2024

givanz commented Jan 27, 2024

2braincells2go commented Jan 27, 2024

givanz commented Jan 27, 2024

2braincells2go commented Jan 28, 2024

givanz commented Jan 28, 2024

oleteacher commented Jan 29, 2024

givanz commented Jan 29, 2024

2braincells2go commented Jan 29, 2024 •

edited

Loading

givanz commented Jan 29, 2024

2braincells2go commented Jan 29, 2024

givanz commented Jan 29, 2024

oleteacher commented Jan 29, 2024 •

edited

Loading

givanz commented Jan 30, 2024

Not working in subdirectory #70

Not working in subdirectory #70

Comments

2braincells2go commented Jan 26, 2024 • edited Loading

givanz commented Jan 26, 2024

2braincells2go commented Jan 27, 2024

givanz commented Jan 27, 2024

2braincells2go commented Jan 27, 2024

givanz commented Jan 27, 2024

2braincells2go commented Jan 28, 2024

givanz commented Jan 28, 2024

oleteacher commented Jan 29, 2024

givanz commented Jan 29, 2024

2braincells2go commented Jan 29, 2024 • edited Loading

givanz commented Jan 29, 2024

2braincells2go commented Jan 29, 2024

givanz commented Jan 29, 2024

oleteacher commented Jan 29, 2024 • edited Loading

givanz commented Jan 30, 2024

2braincells2go commented Jan 26, 2024 •

edited

Loading

2braincells2go commented Jan 29, 2024 •

edited

Loading

oleteacher commented Jan 29, 2024 •

edited

Loading