-- Table structure for table `product_types`
--

CREATE TABLE `product_types` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `product_type` varchar(255) DEFAULT NULL,
  `status` int(100) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_types`
--

INSERT INTO `product_types` VALUES (3,'Dextrose',1,'2023-11-07 13:40:31','2023-11-07 13:40:31'),(7,'Plant proteins: Concentrates',1,'2023-11-07 13:41:16','2023-11-07 13:41:16'),(8,'Plant proteins: Flours',1,'2023-11-07 13:41:27','2023-11-07 13:41:27'),(9,'Sweetener solutions: Low sugar syrups',1,'2023-11-07 13:41:33','2023-11-07 13:41:33'),(12,'Sweetener solutions: Sugar syrups',1,'2023-11-07 13:41:57','2023-11-07 13:41:57'),(23,'Texturizer solutions: Flours',1,'2023-11-07 14:20:05','2023-11-07 14:20:05'),(24,'Plating agents',1,'2023-11-07 14:21:09','2023-11-07 14:21:09'),(25,'ProductType2',1,'2023-11-07 14:21:21','2023-11-07 14:21:21'),(27,'Texturizer solutions: Hydrocolloids',1,'2023-11-07 14:22:59','2023-11-07 14:22:59'),(30,'Texturizer solutions: Functional native starches',1,'2023-11-07 14:24:34','2023-11-07 14:24:34'),(31,'Texturizer solutions: Native starches',1,'2023-11-07 14:24:45','2023-11-07 14:24:45'),(33,'ProductType1',1,'2023-11-07 17:02:34','2023-11-07 17:02:34'),(35,'Texturizer solutions: Functional native starches, Texturizer solutions: Native starches',1,'2023-11-14 13:09:21','2023-11-14 13:09:21'),(36,'Emulsifiers, Texturizer solutions: Modified starches',1,'2023-11-17 16:20:10','2023-11-17 16:20:10');

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `supplier_id` int(11) NOT NULL,
  `category_id` int(11) DEFAULT NULL,
  `title` varchar(250) NOT NULL,
  `sku` varchar(250) DEFAULT NULL,
  `description` text,
  `type` varchar(250) DEFAULT NULL,
  `slug` varchar(250) NOT NULL,
  `status` enum('0','1','2') NOT NULL COMMENT '''0''-pending,''1''-active,''2''-deleted',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=269 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `products`
--

INSERT INTO `products` VALUES (8,3,44,'PureCircle Sigma Bakery',NULL,'PureCircleTM Sigma Solutions represent a line of specialized extracts \r\nderived from stevia, which are formulated to serve as flavor modifiers \r\nand sweeteners in various food and beverage applications. These \r\nsolutions are carefully designed to address specific challenges \r\nencountered in different categories, with the ultimate goal of enhancing\r\n taste and delivering improved results. The use of stevia, a natural \r\nsweetener, aligns with the growing demand for natural and plant-based \r\nalternatives in the food and beverage industry.','0','purecircle-sigma-bakery','1','2023-12-11 11:53:20','2023-07-27 15:55:47'),(9,3,46,'ADVANTA GEL® S','12140800','ADVANTA-GEL® S is a pregelatinized food starch designed to form a firm, \r\ncuttable gel without the need for heating. This starch offers \r\nexceptional properties for structuring, texture, and overall product \r\nstructure, and it does so with more efficiency in usage levels and time \r\ncompared to similar products. It is recommended as a structuring agent \r\nfor both cold and hot prepared food products, making it a versatile \r\ningredient for various applications.','0','advanta-gel-s','1','2023-12-04 13:33:54','2023-11-06 09:54:56'),(10,3,44,'BAKA-SNAK®','12156101','BAKA-SNAK® modified food starch is a pre-gelatinized starch based on \r\nwaxy maize. It is specifically developed for use in baked or fried \r\nexpanded snacks and crackers. The pre-gelatinization process makes it \r\nconvenient for certain food processing applications.','0','baka-snak','1','2023-12-04 13:41:47','2023-11-06 13:10:39'),(12,3,44,'CERELOSE® Coarse Dextrose','020330','Cerelose® Coarse Dextrose 020330 is a coarse monohydrate dextrose \r\nproduct designed for applications that benefit from a coarser particle \r\nsize profile with fewer fines. Dextrose, also known as glucose, is a \r\nsimple sugar that serves various functions in food and industrial \r\napplications.','0','cerelose-coarse-dextrose-1','1','2023-12-04 13:43:37','2023-11-06 14:33:15'),(13,3,44,'CERELOSE® Dextrose','020010','Cerelose® Dextrose 020010 is a food-grade monohydrate dextrose known for\r\n its exceptionally high purity. Dextrose is a simple sugar (glucose) \r\ncommonly used in various food and beverage applications. Its high purity\r\n makes it suitable for a wide range of uses, including as a sweetener, \r\nbulking agent, or ingredient in food processing.','0','cerelose-dextrose','1','2023-12-04 13:44:34','2023-11-06 14:47:36'),(14,3,44,'Action Gum 1144 Powder','38324906','Action Gum 1144 Powder is an excellent thickener and suspending aid for a wide range of products, from salad dressings, to gravies, to industrial applications.','0','action-gum-1144-powder-1','1','2023-12-04 13:45:23','2023-11-08 12:01:07'),(17,3,42,'NOVATION PRIMA® 300','34131A00','NOVATION PRIMA® 300 functional native starch, emphasizing its attributes\r\n such as very good freeze/thaw stability and tolerance to \r\nlow-temperature storage conditions, making it suitable for frozen and \r\nrefrigerated food products. The starch is recommended for \r\nhigh-temperature and shear food processing at a neutral or low pH.','0','novation-prima-300-1','1','2023-12-04 14:12:25','2023-11-09 11:03:20'),(19,3,61,'BATTER BIND® S','06460003','BATTER BIND® S\r\n  modified food starch is derived from corn. It is used in batters to provide\r\n  good adhesion of the coating to meat, poultry or seafood products.','0','batter-bind-s','1','2023-12-04 14:13:56','2023-11-09 12:12:10'),(20,3,60,'CORN PRODUCTS®/CASCO® Corn Starch Food Grade Unmodified','034030','CORN PRODUCTS®/CASCO® Corn Starch Food Grade Unmodified - 034030 as a \r\ngeneral-purpose, thick-boiling corn starch intended for use in food \r\napplications.','0','corn-products-casco-corn-starch-food-grade-unmodif','1','2023-12-04 14:14:23','2023-11-09 12:20:35'),(21,3,60,'BUFFALO® Corn Starch Food Grade','034010','BUFFALO® Corn Starch Food Grade - 034010 as a general-purpose, thick-boiling corn starch designed for use in food applications.','0','buffalo-corn-starch-food-grade','1','2023-12-11 11:25:43','2023-11-09 13:13:59'),(23,3,65,'NOVATION® 1600','34121404','NOVATION® 1600 functional native starch as a potato-based starch \r\nrecommended for moderate temperature/shear food processing or neutral pH\r\n systems. It is made using revolutionary technology, resulting in \r\nproperties similar to modified starches while meeting clean labeling \r\ncriteria. The product is produced under Ingredion Incorporated’s \r\nTRUETRACE® Identity Preserved Program for non-GM products.','0','novation-1600-1','1','2023-12-04 14:16:01','2023-11-09 17:21:52'),(24,3,123,'NOVATION® 6600','34281400','NOVATION® 6600 functional native starch as a high viscosity, \r\npregelatinized potato-based starch recommended as a binder and a \r\ntexturizing agent for a wide range of cold prepared food products. It is\r\n made using revolutionary technology, resulting in properties similar to\r\n modified starches while meeting clean labeling criteria. The product is\r\n produced under Ingredion Incorporated’s TRUETRACE® Identity Preserved \r\nProgram for non-GM products.','0','novation-6600','1','2023-12-04 14:16:32','2023-11-10 10:10:24'),(26,3,62,'NOVATION® 3300','34131300','NOVATION® 3300 functional native starch as a tapioca-based starch \r\nrecommended for high temperature and shear food processing, particularly\r\n well-suited for use in dairy applications. It is made using \r\nrevolutionary technology, resulting in properties similar to modified \r\nstarches while meeting clean labeling criteria. The product is produced \r\nunder Ingredion Incorporated’s TRUETRACE® Identity Preserved Program for\r\n non-GM products.','0','novation-3300-1','1','2023-12-04 14:17:14','2023-11-10 10:27:48'),(27,3,153,'Testing','06460B07','CRISP FILM® modified food starch, which is derived from high amylose \r\ncorn. This modified starch is designed to provide improved structure and\r\n texture to snacks. It exhibits good film-forming characteristics when \r\nused as a coating for fried foods, such as battered or breaded meats. \r\nThe product is available under Ingredion Incorporated’s TRUETRACE® \r\nIdentity Preserved Program for non-GM products.','0','testing','1','2023-12-04 14:17:48','2023-11-10 10:43:49'),(29,3,66,'N-DULGE® C1','05730303','<div class=\"flex flex-grow flex-col max-w-full\"><div data-message-author-role=\"assistant\" data-message-id=\"077273cc-ee81-4dd8-ba7b-533327c4cadf\" class=\"min-h-[20px] text-message flex flex-col items-start gap-3 whitespace-pre-wrap break-words [.text-message+&amp;]:mt-5 overflow-x-auto\"><div class=\"markdown prose w-full break-words dark:prose-invert light\"><p>N-DULGE® C1 modified starch, derived from tapioca, is part of the N-DULGE® product line and serves as a dairy co-texturizer. This family of co-texturizers from Ingredion provides flexibility for food product developers to create various creamy, rich, and indulgent textures in dairy products, aiming to drive customer preference and build brand equity. N-DULGE® C1 enhances mouth-coating and organoleptic textural attributes, contributing to a smooth, creamy, and slightly flowable product texture. The product is produced under Ingredion Incorporated’s TRUETRACE® Identity Preserved Program for non-GM products.</p></div></div></div>','0','n-dulge-c1-1','1','2023-12-04 14:18:31','2023-11-10 14:17:47'),(30,3,67,'TEXTRA® PLUS','32596302','TEXTRA® PLUS modified starch, derived from tapioca, is a \r\ncold-water-soluble starch that exhibits excellent dispersibility and \r\noil-like properties. It imparts superior sheen, clarity, and a bland \r\ntaste to products. Compared to traditional pre-gelatinized starches, \r\nTEXTRA® PLUS modified starch demonstrates exceptional gelling stability \r\nupon refrigeration. The product is produced under Ingredion \r\nIncorporated’s TRUETRACE® Identity Preserved Program for non-GM \r\nproducts, emphasizing its commitment to quality and non-genetically \r\nmodified status.','0','textra-plus-1','1','2023-12-04 14:19:04','2023-11-10 14:25:29'),(31,3,45,'HOMECRAFT® Pulse 2103 Flour','37103F00','HOMECRAFT® Pulse 2103 Flour is made from lentils and is the mechanically\r\n milled and processed portion of the dehulled split lentil cotyledons of\r\n sound, healthy, dry, and clean lentils (Lens culinaris). Lentil flour \r\ncan be used in various food applications to enhance nutritional content,\r\n provide unique flavors, and contribute to the overall quality of the \r\nend product.','0','homecraft-pulse-2103-flour-1','1','2023-12-04 14:19:35','2023-11-10 14:35:48'),(34,3,61,'HOMECRAFT® Pulse 1103 Flour','37103E00','HOMECRAFT® Pulse 1103 Flour is made from peas and is the mechanically \r\nmilled and processed portion of the dehulled split pea cotyledons of \r\nsound, healthy, dry, and clean peas (Pisum sativum). Pea flour is a \r\nversatile ingredient that can be used in various food applications to \r\nenhance nutritional content, provide unique flavors, and contribute to \r\nthe overall quality of the end product.','0','homecraft-pulse-1103-flour','1','2023-12-11 11:19:34','2023-11-10 15:09:07'),(35,3,156,'MALTISWEET® CM100 Crystalline Maltitol NF/FCC','263021','MALTISWEET® CM100 Crystalline Maltitol 263021 is a crystalline maltitol \r\nthat serves as a direct replacement for sucrose in many food and \r\nconfectionery applications. Its usage is particularly beneficial in \r\napplications where achieving a smooth and less gritty mouthfeel is \r\ndesired. This makes it a versatile ingredient for formulating products \r\nthat require sweetness without the characteristic graininess associated \r\nwith some sweeteners.','0','maltisweet-cm100-crystalline-maltitol-nf-fcc','1','2023-12-04 14:20:42','2023-11-10 15:37:37'),(36,3,156,'MALTISWEET® M95 Maltitol Solution','271121','MALTISWEET® M95 maltitol solution stands out as a liquid product with an\r\n exceptionally high maltitol assay. In contrast to typical maltitol \r\nsyrups that contain longer chain polysaccharides, MALTISWEET® M95 is a \r\ntrue maltitol solution. It is 90% as sweet as sucrose and provides 2.1 \r\nkcal/gram on a dry basis. This makes it suitable for various \r\napplications, including bakery, confectionery, frozen dairy, and food \r\nand nutritional bars. Its liquid form offers convenience and flexibility\r\n in formulation, allowing it to contribute sweetness and other desired \r\nattributes to a wide range of products.','0','maltisweet-m95-maltitol-solution-1','1','2023-12-11 11:19:10','2023-11-10 15:57:56'),(38,3,157,'GLOBE® 18 DE Maltodextrin NON-GMO','019193 - 10540301','GLOBE® 18 DE Maltodextrin 019193 is a tapioca-based maltodextrin that \r\noffers low hygroscopicity and quick solubility, making it suitable for \r\napplications where these characteristics are desired. It is particularly\r\n useful in formulations where adding nutritive bulk without introducing \r\nexcessive sweetness is a requirement. The tapioca origin and non-GMO \r\nstatus are emphasized by the product being produced under Ingredion \r\nIncorporated\'s TrueTrace® Program, ensuring adherence to non-genetically\r\n modified standards. This makes it a versatile ingredient for various \r\nfood and beverage applications where these specific attributes are \r\nessential.','0','globe-18-de-maltodextrin-non-gmo-1','1','2023-12-04 14:22:06','2023-11-13 09:34:54'),(39,3,142,'PENPURE® 55','12100308','PenPure® 55 pregelatinized native tapioca starch is characterized by its\r\n smooth texture and bland flavor. When used as a viscosifier and \r\nstabilizer in food applications, PenPure® 55 imparts clarity and \r\nsmoothness.','0','penpure-55','1','2023-12-04 14:22:51','2023-11-13 09:40:11'),(40,3,159,'FOAMATION™ Q','17955906','FOAMATION® Q foaming agent is a natural extract derived from the \r\nquillaja tree, native to Chile. This foaming agent provides a unique \r\ncapability to generate dense, frothy foams in foods and beverages. \r\nNotably, these foams exhibit prolonged stability compared to foams \r\nproduced using hydrolyzed protein, gum, or stabilizer systems.','0','foamation-q-1','1','2023-12-04 14:23:42','2023-11-13 10:26:58'),(41,3,159,'Q-NATURALE® 100V','17955904','Q-NATURALE® 100V is a natural emulsifier derived from Quillaja trees. It\r\n is particularly recommended as a substitute for gum Arabic in flavor \r\nemulsions. Q-NATURALE® is valued for its ease of use, requiring very low\r\n usage levels, high oil loading capacity, fine emulsion particle size, \r\nand stability, even in alcoholic beverages.','0','q-naturale-100v','1','2023-12-04 14:24:25','2023-11-13 10:29:37'),(43,3,161,'PENNOVO® MD-5','10910402','PENNOVO® MD-5 is a potato maltodextrin with a low dextrose equivalent \r\n(DE) value, indicating a lower level of conversion from starch to \r\nsugars. Additionally, it is noted for its exceptionally bland flavor. \r\nMaltodextrins, in general, are commonly used as food additives to \r\nimprove the texture and mouthfeel of various products. The low DE and \r\nbland flavor of PENNOVO® MD-5 make it suitable for applications where a \r\nneutral taste profile and specific textural properties are desired \r\nwithout introducing significant sweetness.','0','pennovo-md-5','1','2023-12-04 14:32:51','2023-11-13 10:41:12'),(45,3,163,'N-LITE® LP','32596100','N-LITE® LP modified food starch is designed as a fat mimetic for use in \r\ncold-process liquid food systems. The \"LP\" designation indicates its \r\nsuitability for liquid/pregel applications. Notably, N-LITE® LP exhibits\r\n an oily texture, a bland flavor, and exceptional viscosity stability in\r\n liquid systems. It is particularly useful in creating zero or low-fat \r\nproducts while maintaining the desired organoleptic and textural \r\nproperties found in high-quality, fat-rich products.','0','n-lite-lp','1','2023-12-04 14:34:57','2023-11-13 12:27:46'),(46,3,163,'VITESSENCE™ Pulse CT 3602 Protein','37401G00','VITESSENCE™ PULSE CT 360 2 Protein is derived from faba beans and is the\r\n mechanically milled and processed portion of the dehulled split faba \r\nbean cotyledons. These beans come from sound, healthy, dry, and clean \r\nfaba beans (Vicia faba).','0','vitessence-pulse-ct-3602-protein-1','1','2023-12-04 14:38:10','2023-11-13 12:32:08'),(47,3,90,'ENZOSE Brewers Glucose NON GMO IP','01551090','NON GMO IP 01551090 is a high maltose, regular viscosity, ion-exchanged\r\n syrup of high quality, specifically crafted for use as a brewing \r\nadjunct. It is produced under Ingredion Incorporated’s TrueTrace™ \r\nProgram, highlighting its non-GMO status and commitment to product \r\ntraceability.','0','enzose-brewers-glucose-non-gmo-ip-1','1','2023-12-04 14:39:37','2023-11-13 12:38:22'),(48,3,164,'ENZOSE® 55 HM Corn Syrup/Glucose','015530','Enzose® 55 HM Corn Syrup/Glucose 015530 is an ion-exchanged, \r\nenzymatically converted syrup with a high maltose content. This syrup is\r\n specifically crafted to provide desirable brewing characteristics, \r\nmaking it suitable for use as a brewing adjunct.','0','enzose-55-hm-corn-syrup-glucose','1','2023-12-04 14:43:00','2023-11-13 12:41:29'),(50,3,146,'NUTRAFLORA® L95-S soluble prebiotic fiber','11101300','NUTRAFLORA® L95-S is an effective yet gentle prebiotic that promotes \r\ndigestive health by fostering the growth of beneficial bacteria in the \r\ngut. NUTRAFLORA® L95-S is an effective yet gentle prebiotic that promotes \r\ndigestive health by fostering the growth of beneficial bacteria in the \r\ngut. Easy-pouring, slightly yellow syrup form. The prebiotic fiber contributes to humectancy and helps extend the shelf life of products. The prebiotic fiber contributes to humectancy and helps extend the shelf life of products.','0','nutraflora-l95-s-soluble-prebiotic-fiber-1','1','2023-12-04 14:47:16','2023-11-13 15:03:57'),(51,3,141,'GLOBE® 22 DE Corn Syrup/Glucose Solids','019220','Globe® 22 Corn Syrup/Glucose Solids 019220 is a versatile ingredient applicable to various food applications. Easy to handle in both processing and formulation. This corn syrup/glucose solids product is designed to offer \r\nfunctionality in diverse food applications, contributing to texture, \r\nmouthfeel, and sweetness.','0','globe-22-de-corn-syrup-glucose-solids','1','2023-12-04 14:50:02','2023-11-13 16:12:19'),(52,3,141,'GLOBE® 28 DE Corn Syrup/Glucose Solids','019280','Globe® 28 Corn Syrup/Glucose Solids 019280 is a versatile ingredient \r\nsuitable for a wide range of food applications, especially when a liquid\r\n product is not feasible. Applicable to various food applications, providing flexibility in formulation. This corn syrup/glucose solids product is formulated to be a convenient \r\noption in situations where a liquid form is not practical, offering \r\nfunctionality and aiding in achieving desirable qualities in food \r\napplications.','0','globe-28-de-corn-syrup-glucose-solids-1','1','2023-12-04 14:52:33','2023-11-13 16:18:12'),(53,3,42,'GLOBE® 28 DE Glucose Solids NON GMO IP','10060090','Globe ® 28 DE\r\n  Glucose Solids 10060090 Non GMO IP are suitable for all food \r\napplications\r\n  where a liquid product cannot be used. This product is easy to handle \r\nand has\r\n  high solution clarity and a bland flavor. This product is produced \r\nunder Ingredion Incorporated’s TrueTrace™ Program for non -GM products .','0','globe-28-de-glucose-solids-non-gmo-ip-1','1','2023-12-04 15:00:03','2023-11-13 16:24:25'),(54,3,99,'GLOBE® 42 DE Corn Syrup/Glucose Solids','019400','Globe® 42 Corn Syrup/Glucose Solids 019400 suitable for a variety of \r\nfood applications, providing sweetness and texture without introducing \r\nstrong flavors.','0','globe-42-de-corn-syrup-glucose-solids','1','2023-12-11 11:17:04','2023-11-14 09:46:49'),(60,3,100,'CASCO™ 62 DE Corn Syrup/Glucose','016540','Globe® 62 Corn Syrup/Glucose 016540 could be suitable for applications where a moderately thick and sweet syrup is desired.','0','casco-62-de-corn-syrup-glucose','1','2023-12-04 14:53:29','2023-11-14 11:32:38'),(61,3,145,'CRISP FILM®','06460B07','CRISP FILM®\r\n  modified food starch which provides improved structure and texture to snacks\r\n  and is derived from high am ylose corn. CRISP FILM® modified starch exhibits\r\n  good film forming characteristics when used as a coating for fried foods such\r\n  as battered or breaded meats. This product is available under Ingredion\r\n  Incorporated’s TRUETRACE® Identity Preserved Program for non -GM products .','0','crisp-film','1','2023-11-21 10:00:51','2023-11-14 11:39:26'),(63,3,131,'HI-MAIZE® 260 resistant starch','22000b00','<p>HI-MAIZE® resistant starch. Derived from a conventionally bred variety of high-amylose cornved from a conventionally bred variety of high-amylose corn. Glycemic management — Helps reduce short-term blood sugar levels and lower the insulin response of foods. Energy management — Balances energy levels in the hours following a meal. FDA-authorized qualified health claim: May reduce the risk of type 2 diabetes, based on limited scientific evidence</p><p>Appearance and Taste:<br><br>&nbsp;&nbsp;&nbsp; White in appearance<br>&nbsp;&nbsp;&nbsp; Neutral in taste<br>&nbsp;&nbsp;&nbsp; Small particle size<br>&nbsp;&nbsp;&nbsp; Low water-holding capacity<br><br>Functional and Processing Advantages:<br><br>&nbsp;&nbsp;&nbsp; Doesn\'t affect handling during processing<br>&nbsp;&nbsp;&nbsp; Products have an appealing texture without being grainy or gummy<br>&nbsp;&nbsp;&nbsp; Improved yield in breads, higher crumb moisture content in cookies, increased crunchiness and crispiness, and al dente texture in pastas</p><p>Incorporation in Recipes:<br><br>&nbsp;&nbsp;&nbsp; Breads and bakery products<br>&nbsp;&nbsp;&nbsp; Nutrition bars<br>&nbsp;&nbsp;&nbsp; Biscuits and cookies<br>&nbsp;&nbsp;&nbsp; Breakfast cereals<br>&nbsp;&nbsp;&nbsp; Pasta and noodles<br>&nbsp;&nbsp;&nbsp; Sheeted baked snacks and crackers<br>&nbsp;&nbsp;&nbsp; Extruded snacks<br>&nbsp;&nbsp;&nbsp; Soups and ready meal components<br>&nbsp;&nbsp;&nbsp; Thickened beverages<br></p>','0','hi-maize-260-resistant-starch-1','1','2023-12-11 11:15:48','2023-11-14 12:05:58'),(66,3,68,'GLOBE® 10 DE Maltodextrin NON GMO IP','10020091','Globe®\r\n  10&nbsp;maltodextrin NON GMO IP 10020091 is an extremely bland, flavor free\r\n  10 DE&nbsp;maltodextrin. All traces of flavor bearing components have been \r\nremoved,\r\n  making higher use levels in delicately flavored food systems such as \r\nlow or\r\n  no fat dairy products, yogurts, salad dressings, and other foods \r\npossible. &nbsp;This product is produced under Ingredion Incorporated’s \r\nTrueTrace™ Program for non -GM products .​','0','globe-10-de-maltodextrin-non-gmo-ip','1','2023-11-17 10:41:50','2023-11-14 13:41:04'),(68,3,68,'GLOBE® 10 DE Maltodextrin NON-GMO IP','10520011','GLOBE\r\n  ® 10 DE Maltodextrin 1052001 1 is suitable for applications where low\r\n  hygroscopicity and ready solubility are desired characteristics. It is\r\n  especially useful in applications where nutritive bulk without excessive\r\n  sweetness is necessary. This product is produced under Ingredion\r\n  Incorporated’s TrueTrace™ Program for non -GM products .','0','globe-10-de-maltodextrin-non-gmo-ip-1','1','2023-11-17 10:42:25','2023-11-14 13:50:38'),(71,3,121,'PENPURE® 37','04400D01','PenPure® 37 is a\r\n  native waxy rice starch. It has high viscosity, water-holding capacity and\r\n  binding abilities. It has superior freeze-thaw stability. Native rice starch\r\n  is gluten free and easy to digest. It is extremely white in color and bland\r\n  in taste .','0','penpure-37','1','2023-11-20 10:40:14','2023-11-14 14:37:09'),(72,3,73,'GLOBE® 15 DE Maltodextrin NON GMO IP','10030090','Globe®\r\n  15maltodextrin NON GMO IP 10030090 is an extremely bland, flavor free\r\n  15 DE&nbsp;maltodextrin. All traces of flavor bearing components have been removed,\r\n  making higher use levels in delicately flavored food systems such as low or\r\n  no fat dairy products, yogurts, salad dressings, and other foods possible .','0','globe-15-de-maltodextrin-non-gmo-ip','1','2023-11-17 10:53:33','2023-11-14 15:11:51'),(76,3,228,'VITESSENCE® Pulse 1803 pea protein','37422E00','VITESSENCE® Pulse 1803 as a versatile and sustainable ingredient for \r\nformulating plant-based, high-protein products that align with consumer \r\ndemands for health, lifestyle, and environmental considerations.','0','vitessence-pulse-1803-pea-protein','1','2023-12-04 13:28:35','2023-11-14 15:42:57'),(77,3,58,'GLOBE® 63 DE Glucose Syrup NON-GMO - 016603','01660300','GLOBE® 63 DE Glucose Syrup 016603 is a tapioca-based, high conversion \r\nglucose syrup. It is designed for use in various food and confectionery \r\napplications. The higher sweetness of this glucose syrup makes it \r\nparticularly suitable for confections and fruit preparations. \r\nAdditionally, it is highlighted that this product is produced under \r\nIngredion Incorporated\'s TrueTrace™ Program, emphasizing its non-GMO \r\nstatus.','0','globe-63-de-glucose-syrup-non-gmo-016603-1','1','2023-12-04 13:21:37','2023-11-14 15:50:26'),(78,3,98,'CASCO™ 42 DE Corn Syrup/Glucose','011440','42Corn Syrup/Glucose 011440 is an acid-converted, normal viscosity \r\nsyrup. Acid conversion typically involves the use of acid hydrolysis to \r\nbreak down starch into simpler carbohydrates, including glucose. Normal \r\nviscosity suggests a standard thickness or consistency of the syrup.','0','casco-42-de-corn-syrup-glucose-1','1','2023-12-04 13:20:47','2023-11-15 11:45:16'),(79,3,47,'ENZOSE® 42 HM Corn Syrup/Glucose','014420','Enzose® 42 HM Corn Syrup/Glucose 014420 as an ion-exchanged, \r\nenzymatically converted syrup that contains a high level of maltose.','0','enzose-42-hm-corn-syrup-glucose-1','1','2023-12-04 13:17:03','2023-11-15 11:49:28'),(83,3,99,'GLOBE® 42 DE Glucose Syrup NON GMO IP','01440090','Globe® 42 Glucose Syrup is classified as an enzyme-converted, regular D.E. (dextrose equivalent) syrup. The syrup undergoes ion exchange during its production process. It is categorized as a normal viscosity syrup, indicating its flow characteristics. The product is produced under Ingredion Incorporated’s TrueTrace™ \r\nProgram, emphasizing its non-GMO (non-genetically modified organism) \r\nstatus. This program ensures transparency and adherence to non-GMO \r\nstandards.','0','globe-42-de-glucose-syrup-non-gmo-ip-1','1','2023-12-04 13:30:13','2023-11-15 13:12:01'),(88,3,74,'INVERTOSE® High Fructose Corn Syrup','026430','Invertose® High\r\n  Fructose Corn Syrup, 026430, is an excellent liquid sweetener for food\r\n  applications. The high fructose content provides ease of handling and\r\n  improved functionality in a wide variety of end uses .','0','invertose-high-fructose-corn-syrup','1','2023-11-17 10:58:59','2023-11-15 16:15:07'),(91,3,40,'HOMECRAFT® Create 865 Rice Flour','34121d01','HOMECRAFT® Create 865 Rice Flour as a clean label solution for achieving smoother textures in various food applications. Its bland flavor, process tolerance, and cost-saving features make it suitable for soups, sauces, ready meals, snacks, cereals, batters, breadings, dairy-free products, baby food, and chilled/frozen soups and sauces.<p>The emphasis on desirable labeling and ingredients aligns with consumer preferences for natural and healthy options. The versatility of this rice flour allows for a wide range of recipe formulations, providing short, silky texture, stability at low pH, opacity generation, and a \"rice flour\" label.</p>','0','homecraft-create-865-rice-flour-1','1','2023-12-04 13:15:45','2023-11-15 16:59:48'),(92,3,46,'CERELOSE® Dextrose M NON-GMO IP','02001090','CERELOSE® Dextrose M NON-GMO IP 2001090 &nbsp;is a food grade monohydrate \r\ndextrose of exceptionally high purity. &nbsp;This product is produced under \r\nIngredion Incorporated’s TrueTrace™ Program for non -GM products','0','cerelose-dextrose-m-non-gmo-ip','1','2023-11-17 09:23:07','2023-11-16 08:53:04'),(94,3,47,'GLOBE® 42 DE Corn Syrup/Glucose','011420','Globe® 42Corn\r\n  Syrup/Glucose 011420 is a 42regular conversion, ion-exchanged, normal\r\n  viscosity syrup .','0','globe-42-de-corn-syrup-glucose-1','1','2023-12-04 13:14:52','2023-11-16 09:36:09'),(95,3,53,'GLOBE® 63 DE Corn Syrup/Glucose','016520','Globe® 63&nbsp;Corn\r\n  Syrup 016520 is a high conversion, ion-exchanged, highly fermentable syrup of\r\n  fairly low viscosity. The degree of conversion supplies desired fermentables\r\n  and permits ease of handling .','0','globe-63-de-corn-syrup-glucose-1','1','2023-12-04 13:13:39','2023-11-16 09:47:33'),(96,3,53,'GLOBE® 36 DE Corn Syrup/Glucose','010420','Globe® 36Corn\r\n  Syrup/Glucose 010420 is a 36low conversion, ion-exchanged, normal viscosity\r\n  syrup .','0','globe-36-de-corn-syrup-glucose-1','1','2023-12-04 13:12:48','2023-11-16 09:59:11'),(97,3,92,'PURITY GUM® 59','32296101','PURITY GUM® 59, being a low viscosity starch derived from waxy maize, is\r\n tailored for clear film-forming applications. Its attributes of superb \r\npliability and excellent resistance to cracking and chipping make it \r\nsuitable for specific texture-enhancing purposes. The adherence to the \r\nTRUETRACE® Identity Preserved Program emphasizes its non-GMO status and \r\ncommitment to traceability.','0','purity-gum-59','1','2023-12-04 13:10:55','2023-11-16 10:02:15'),(98,3,120,'NOVATION® 2700','34111100','NOVATION® 2700 Functional Native Starch is derived from waxy corn and \r\ndesigned for specific processing conditions. Its unique production \r\ntechnology allows it to mimic the properties of modified starches, \r\naligning with clean labeling requirements. Being part of the TRUETRACE® \r\nIdentity Preserved Program ensures adherence to non-GMO standards.','0','novation-2700','1','2023-12-04 13:10:25','2023-11-16 10:07:18'),(99,3,197,'SORBO® Sorbitol Solution USP/FCC','260151','SORBO® Sorbitol Solution is a versatile ingredient with applications \r\nspanning food, confections, pharmaceuticals, oral care, and industrial \r\nprocesses. Its functionality as a bulking agent, sweetener, and \r\nhumectant makes it valuable in a range of formulations.','0','sorbo-sorbitol-solution-usp-fcc','1','2023-12-04 13:09:50','2023-11-16 10:14:16'),(100,3,198,'CRYSTAL GUM™','07340300','CRYSTAL GUM™ - 07340300 Tapioca Dextrin is a tapioca-derived ingredient \r\nknown for its clear appearance, neutral flavor, and film-forming \r\ncapabilities with resistance to cracking and chipping. The adherence to \r\nthe TRUETRACE® Identity Preserved Program underscores its non-GMO \r\nstatus.','0','crystal-gum','1','2023-12-04 13:09:14','2023-11-16 10:25:49'),(101,3,99,'GLOBE® 42 DE Corn Syrup/Glucose Solids','019420','Globe® 42 Corn Syrup/Glucose Solids 019420 is a corn-derived product \r\nknown for its versatility, high solution clarity, and bland flavor.','0','globe-42-de-corn-syrup-glucose-solids-1','1','2023-12-04 13:07:59','2023-11-16 10:37:18'),(103,3,142,'HYLON® V','04400202','HYLON® V, an unmodified starch derived from high amylose corn, is a \r\nversatile ingredient with notable gelling, film-forming, and opacifying \r\nproperties. Its inclusion in the TRUETRACE® Identity Preserved Program \r\nemphasizes its non-GMO status, providing an additional layer of quality \r\nassurance.','0','hylon-v-1','1','2023-12-04 13:07:17','2023-11-16 10:49:59'),(104,3,142,'HYLON® V','04400204','HYLON® V is an unmodified starch derived from high amylose corn, known \r\nfor its specific characteristics. Its amylose content, along with \r\ngelling, film-forming, and opacifying properties, makes it suitable for a\r\n range of food applications.','0','hylon-v-1','1','2023-12-04 13:05:59','2023-11-16 10:58:50'),(107,3,88,'HYSTAR® 5875 Maltitol Syrup NF/FCC','271351','HYSTAR® 5875 Maltitol Syrup is positioned as a versatile sweetening \r\nsolution with a non-crystallizing nature. Its use in sugar-free and \r\nreduced-sugar applications is facilitated by its taste similarity to \r\nsucrose, providing an option for formulators looking to reduce sugar \r\ncontent without compromising sweetness.','0','hystar-5875-maltitol-syrup-nf-fcc-1','1','2023-12-04 12:54:20','2023-11-16 11:31:22'),(108,3,54,'SORBEX® 70 Sorbitol Solution USP/FCC NON-GMO IP','26010090','MALTISWEET® 3145 accurately. As a non-crystallizing syrup with a \r\nsubstantial maltitol content, it indeed serves as a valuable ingredient \r\nfor a variety of applications. The high maltitol content makes it a \r\nsuitable alternative for sucrose and corn syrup in formulations where \r\nreducing sugar content is a goal.','0','sorbex-70-sorbitol-solution-usp-fcc-non-gmo-ip-1','1','2023-12-04 12:52:44','2023-11-16 11:37:42'),(109,3,203,'MALTISWEET® 3145 Maltitol Syrup,NF/FCC','271051','MALTISWEET® 3145, with its non-crystallizing syrup form and substantial \r\nmaltitol content, is a valuable ingredient for applications aiming to \r\nreplace sucrose and corn syrup. Its high maltitol content makes it a \r\nsuitable choice for formulating sugar-free and reduced-sugar products, \r\noffering sweetness without the use of traditional sugars. This \r\nversatility makes it applicable in various food and beverage \r\nformulations where a reduction in sugar content is desired, catering to \r\nconsumers who seek alternatives for health or dietary reasons.','0','maltisweet-3145-maltitol-syrup-nf-fcc','1','2023-12-04 12:46:34','2023-11-16 11:44:46'),(110,3,93,'SORBOGEM® Fines Crystalline Sorbitol NF/FCC','261053','SORBOGEM® Fines Crystalline Sorbitol 261053 is presented as a versatile \r\ningredient with a small particle size, making it suitable for various \r\napplications in the food, confectionery, pharmaceutical, and industrial \r\nsectors. Its multifunctional properties, including cryoprotection, \r\ncrystallization inhibition, and freeze point depression, contribute to \r\nits utility in diverse formulations.','0','sorbogem-fines-crystalline-sorbitol-nf-fcc','1','2023-12-04 12:28:21','2023-11-16 11:47:39'),(112,3,92,'ULTRA-CRISP® CS','32106102','ULTRA-CRISP® CS Waxy Maize Starch is positioned as a cold-water-swelling\r\n starch suitable for enhancing textures in baked cereals, crackers, and \r\nvarious snack items. Its inclusion in the TRUETRACE® Identity Preserved \r\nProgram emphasizes Ingredion\'s commitment to quality and non-GMO \r\nsourcing.','0','ultra-crisp-cs-1','1','2023-12-04 12:27:03','2023-11-16 12:04:01'),(113,3,90,'ENZOSE® Brewers\' Corn Syrup','015510','BREWERS’ CRYSTALS High Maltose Corn Syrup Solids is positioned as a \r\nvaluable brewing adjunct, offering both functional and flavor-enhancing \r\nbenefits. Breweries are encouraged to leverage Ingredion\'s expertise and\r\n longstanding commitment to quality for their brewing ingredient needs.','0','enzose-brewers-corn-syrup-1','1','2023-12-04 12:26:10','2023-11-16 12:11:34'),(114,3,207,'NOVATION® 4600','34381102','NOVATION® 4600 Functional Native Starch is positioned as a versatile \r\nstarch solution with premium instant properties, offering benefits such \r\nas sheen, clarity, and smoothness. Its clean labeling emphasis and \r\nproduction under the TRUETRACE® Identity Preserved Program underscore \r\nits commitment to transparency and quality.','0','novation-4600','1','2023-12-04 12:24:58','2023-11-16 12:21:14'),(115,3,101,'N-DULGE® CA1','10903303','N-DULGE® CA1 Maltodextrin is positioned as a specialized co-texturizer \r\nto elevate the texture and sensory qualities of dairy products. Its \r\nfocus on enhancing mouth-coating, creaminess, and meltaway, along with a\r\n unique visual appearance, aligns with the goal of providing an \r\nindulgent and pleasant experience for consumers. The inclusion in \r\nIngredion\'s TRUETRACE® Identity Preserved Program emphasizes the \r\nproduct\'s quality and adherence to non-GMO standards.','0','n-dulge-ca1','1','2023-12-04 10:32:06','2023-11-16 12:28:25'),(116,3,208,'CASCO™ Modified Corn Starch Food Grade','050520','CASCO™ Modified Corn Starch, Food Grade - 050520, is a modified corn \r\nstarch known for its thin boil or fluidity. Its typical use in the \r\nconfectionery industry and versatility for a variety of functions \r\nsuggest its applicability in different confectionery formulations.','0','casco-modified-corn-starch-food-grade','1','2023-12-04 10:27:39','2023-11-16 13:21:28'),(117,3,85,'CASCO™ Modified Corn Starch Food Grade','050820','CASCO™ Modified Corn Starch, Food Grade - 050820, is a modified corn \r\nstarch known for its thin boil or fluidity. Its typical use in the \r\nconfectionery industry and versatility for a variety of functions \r\nsuggest its applicability in different confectionery formulations.','0','casco-modified-corn-starch-food-grade-1','1','2023-12-04 10:26:46','2023-11-16 13:32:19'),(118,3,208,'CASCO™ Modified Corn Starch Food Grade','050630','CASCO™ Modified Corn Starch, Food Grade - 050630, is a modified corn \r\nstarch known for its thin boil or fluidity. Its typical use in the \r\nconfectionery industry and versatility for a variety of functions \r\nsuggest its applicability in different confectionery formulations.','0','casco-modified-corn-starch-food-grade-1','1','2023-12-04 10:26:01','2023-11-16 13:39:22'),(119,3,85,'CASCO™ Moulding Corn Starch,Food Grade','036100','CASCO™ Moulding Corn Starch, Food Grade 036100, is a specialized \r\nfood-grade powdered corn starch with the addition of mineral oil. Its \r\ndesign is specifically intended for confectioner’s moulding, indicating \r\nits suitability for molding processes in the confectionery industry.','0','casco-moulding-corn-starch-food-grade-1','1','2023-12-04 10:25:25','2023-11-16 13:46:06'),(120,3,57,'MALTISWEET® CM40 Crystalline Maltitol NF/FCC','263022','MALTISWEET® CM40\r\n  Crystalline Maltitol 263022 is used as a direct replacement for sucrose in\r\n  most food and confectionery applications .','0','maltisweet-cm40-crystalline-maltitol-nf-fcc','1','2023-11-17 10:06:56','2023-11-16 13:50:44'),(121,3,86,'MALTISWEET® CM9820 Crystalline Maltitol NF/FCC','263051','MALTISWEET® CM9820 Crystalline Maltitol 263051 is positioned as a \r\nversatile sweetener, serving as a direct replacement for sucrose in a \r\nwide range of food and confectionery applications. Its specific mention \r\nof suitability for chocolate compound coatings makes it a valuable \r\ningredient in the production of such confectionery products.','0','maltisweet-cm9820-crystalline-maltitol-nf-fcc','1','2023-12-04 10:24:17','2023-11-16 13:54:34'),(122,3,95,'ELASTIGEL® 1000J','05079800','ELASTIGEL® 1000J modified food starch is tailored for confectionery \r\napplications, offering rapid gelling, ease of cooking, low hot \r\nviscosity, and the formation of an elastic gel. Its production under the\r\n TRUETRACE® Identity Preserved Program emphasizes quality assurance and \r\nnon-GMO status.','0','elastigel-1000j-1','1','2023-12-04 10:23:40','2023-11-16 14:05:55'),(123,3,95,'PENBIND® 1225','05790400','PenBind® 1225 modified potato starch is a specialty starch known for its\r\n favorable gelling and texturizing properties. It finds application in \r\nthe production of reduced-casein cheese analogues, contributing to the \r\ntexture of the final product. Additionally, its low viscosity and bland \r\ntaste make it versatile for use in various food formulations.','0','penbind-1225-1','1','2023-12-04 10:23:08','2023-11-16 14:13:12'),(124,3,86,'HYSTAR® 4075 Polyglycitol Syrup','270024','HYSTAR® 4075 polyglycitol syrup is tailored for use in confectionery \r\napplications, including caramel, taffy, and chocolate centers. Its \r\ndesigned functionalities, such as enhancing moisture retention and \r\nextending shelf life, make it a valuable ingredient in these specific \r\napplications.','0','hystar-4075-polyglycitol-syrup','1','2023-12-04 10:22:38','2023-11-16 14:19:44'),(125,3,86,'HYSTAR® 3375 Polyglycitol Syrup','270025','HYSTAR® 3375 polyglycitol syrup is specifically designed for use in \r\nsugar-free candy, leveraging its unique composition of maltitol, \r\nsorbitol, and high molecular weight polymers. Additionally, its \r\nversatility makes it suitable for imparting stability and sweetness to a\r\n range of other food and confectionery systems.','0','hystar-3375-polyglycitol-syrup','1','2023-12-04 10:22:05','2023-11-16 14:22:09'),(126,3,87,'CERELOSE® Anhydrous Dextrose','024010','Cerelose® Anhydrous Dextrose 024010 is positioned as a high-purity \r\nfood-grade anhydrous dextrose. The absence of water and high purity make\r\n it suitable for various food applications where a pure form of dextrose\r\n is desired.','0','cerelose-anhydrous-dextrose','1','2023-12-04 10:21:28','2023-11-16 14:31:36'),(127,3,87,'SORBOGEM® 834 Crystalline Sorbitol NF/FCC','261052','SORBOGEM® 834 crystalline sorbitol 261052 is designed with a focus on \r\nachieving a more uniform particle size distribution, making it suitable \r\nfor various applications in the food, confectionery, and pharmaceutical \r\nindustries. Its functionalities, including cryoprotection, \r\ncrystallization inhibition, and moisture retention, enhance its \r\nversatility.','0','sorbogem-834-crystalline-sorbitol-nf-fcc','1','2023-12-04 10:20:58','2023-11-16 15:02:19'),(128,3,62,'HI-SET® C','05565201','HI -SET ® C\r\n  modified starch is based on high amylose corn starch . HI -SET ® C is used\r\n  primarily in the confectionery industry as a gelling agent in the manufacture\r\n  of jelly gum candies .','0','hi-set-c','1','2023-11-17 10:19:31','2023-11-16 15:07:34'),(129,3,87,'MALTISWEET® B Maltitol Syrup,NF/FCC','271352','MALTISWEET® B is positioned as a versatile ingredient with specific \r\ncharacteristics, making it suitable for a range of applications. Its \r\nnon-crystallizing nature, along with the balance of sweetness and \r\nhumectancy, makes it well-suited for nutritional bars, hard candy, and \r\nvarious soft confections.','0','maltisweet-b-maltitol-syrup-nf-fcc-1','1','2023-12-04 10:20:27','2023-11-16 15:17:06'),(130,3,86,'SORBOGEM® 712 Crystalline Sorbitol NF/FCC','261054','SORBOGEM® 712 crystalline sorbitol 261054 is a versatile polyol widely \r\nused in the food, confectionery, pharmaceutical, and industrial markets.\r\n Its multiple functionalities, including cryoprotection, crystallization\r\n inhibition, and moisture retention, make it valuable in various \r\napplications.','0','sorbogem-712-crystalline-sorbitol-nf-fcc','1','2023-12-04 10:19:43','2023-11-16 15:21:39'),(132,3,88,'GLOBE® 42 DE Glucose Solids C NON GMO IP','10070090','Globe® 42 Glucose Solids C NON GMO IP 10040090 is positioned as a \r\nversatile ingredient suitable for food applications where a liquid \r\nproduct is not suitable. Its coarser size distribution, high solution \r\nclarity, and bland flavor contribute to its adaptability in various \r\nformulations. The adherence to the TrueTrace™ Program underscores its \r\nnon-GMO status and commitment to traceability.','0','globe-42-de-glucose-solids-c-non-gmo-ip','1','2023-12-04 10:19:08','2023-11-16 16:06:24'),(133,3,89,'NUTRAFLORA® P-95 soluble prebiotic fiber','111001','NUTRAFLORA® P-95 soluble prebiotic fiber offers a range of benefits, \r\nincluding digestive health support, sugar reduction, and formulation \r\nflexibility. Its clean taste, stability under various conditions, and \r\nhigh purity make it a valuable ingredient for creating nutritious and \r\nflavorful products.','0','nutraflora-p-95-soluble-prebiotic-fiber','1','2023-12-04 10:18:36','2023-11-16 16:14:14'),(136,3,106,'PURITY® TF','03451002','PURITY® TF food-grade starch, derived from dent corn, is known for its \r\nability to form a strong gel when a cooked dispersion is cooled. This \r\ncharacteristic makes it suitable for various applications where gel \r\nformation is desired, such as in the food industry for thickening and \r\nstabilizing purposes.','0','purity-tf-1','1','2023-12-04 10:02:28','2023-11-16 16:43:42'),(137,3,106,'ULTRA-TEX® 8','32166303','ULTRA-TEX® 8 modified food starch appears to be a high-performance \r\ningredient derived from tapioca, suitable for various applications. Its \r\ncold water swelling, high viscosity, bland flavor profile, and mouth \r\nmelt-away characteristics contribute to its versatility. Additionally, \r\nits inclusion in the TRUETRACE® Identity Preserved Program provides \r\nassurance of non-GMO status.','0','ultra-tex-8-1','1','2023-12-04 10:01:37','2023-11-16 16:49:43'),(138,3,227,'VERSASWEET™ 1526 28 DE NGM Glucose Syrup','01420090','Globe® 28 Glucose Syrup Non-GMO IP 01420090 is a syrup produced through \r\nenzyme conversion and ion exchange, with a normal viscosity. Its non-GMO\r\n status, as ensured by Ingredion Incorporated\'s True Trace™ Program, \r\naligns with the increasing consumer demand for products with \r\nnon-genetically modified ingredients.','0','versasweet-1526-28-de-ngm-glucose-syrup','1','2023-12-04 10:00:55','2023-11-16 17:01:12'),(139,3,40,'HOMECRAFT® Create 835 Rice Flour','34121d00','HOMECRAFT® Create 835 Rice Flour as a valuable and adaptable ingredient in the food industry. Its bland flavor, process tolerance, and cost-saving features make it applicable across a wide range of food applications.','0','homecraft-create-835-rice-flour','1','2023-12-04 09:59:33','2023-11-17 09:03:11'),(140,3,49,'VERSATOSE® Liquid Glucose','013500','Liquid Glucose 013500 is a corn syrup with a variable high dextrose \r\ncontent. Corn syrups are commonly used in the food industry for various \r\napplications, including as sweeteners, thickeners, and moisture \r\nretainers.','0','versatose-liquid-glucose','1','2023-12-04 09:51:05','2023-11-17 09:25:55'),(141,3,50,'EXPANDEX®','16090100','EXPANDEX® modified tapioca starch is tailored for baking applications, \r\nwith a focus on enhancing substrate expansion during baking and \r\nimproving the internal textures of baked products. The gluten-free \r\nnature of this starch makes it suitable for those seeking gluten-free \r\nalternatives.','0','expandex','1','2023-12-04 09:48:49','2023-11-17 09:30:32'),(142,3,50,'HOMECRAFT® Create 390','04400320','HOMECRAFT® Create\r\n  390 functional tapioca flour is a clean label water binder and texturizing\r\n  agent. It is ideally suited for snacks and gluten -free applications. This\r\n  product is produced under Ingredion Incorporated’s TRUETRACE® Identity\r\n  Preserved Program for non -GM products .','0','-1','1','2023-11-17 09:34:55','2023-11-17 09:34:55'),(143,3,51,'HOMECRAFT® Express 390','12100307','HOMECRAFT® Express 390 functional flour is indeed positioned as a \r\nversatile ingredient with several advantageous characteristics. Its \r\nsuitability for various applications, including acting as an instant \r\nwater binder, texturizing agent, and in gluten-free formulations, makes \r\nit adaptable to a range of food products. Additionally, its clean label \r\nstatus emphasizes transparency, and inclusion in the TRUETRACE® Identity\r\n Preserved Program provides assurance of non-GMO sourcing.','0','homecraft-express-390','1','2023-12-04 09:43:46','2023-11-17 09:40:59'),(144,3,54,'ULTRA-TEX® 3','32166300','ULTRA-TEX® 3 modified food starch appears to be a versatile and \r\nhigh-performance ingredient with unique characteristics, especially its \r\ncold water swelling properties. Its bland flavor profile and mouth \r\nmelt-away characteristics make it suitable for various applications. \r\nAdditionally, its inclusion in the TRUETRACE® Identity Preserved Program\r\n provides assurance of non-GMO status.','0','ultra-tex-3','1','2023-12-04 09:40:55','2023-11-17 09:47:50'),(145,3,54,'SORBOGEM® Powder Crystalline Sorbitol NF/FCC','261051','SORBOGEM® Powder crystalline sorbitol 261051 is a versatile product with\r\n multiple functionalities, making it suitable for a range of \r\napplications. Its flexibility in particle size and diverse roles, such \r\nas a cryoprotectant, crystallization inhibitor, freeze point depressant,\r\n plasticizer, humectant, and excipient, suggests broad utility across \r\ndifferent industries.','0','sorbogem-powder-crystalline-sorbitol-nf-fcc','1','2023-12-04 09:39:49','2023-11-17 09:52:01'),(146,3,55,'K4484','08310300','K-4484 specialty tapioca dextrin appears to be a versatile ingredient \r\nwith desirable characteristics, including high solubility, good clarity,\r\n bland flavor, and good film-forming properties. Its inclusion in the \r\nTRUETRACE® Identity Preserved Program provides additional assurance of \r\nnon-GMO status.','0','k4484','1','2023-12-04 09:38:16','2023-11-17 09:55:22'),(147,3,56,'CLEARJEL®','06437100','CLEARJEL® modified food starch appears to be a starch with versatile \r\napplications, making it suitable for use in a range of food products, \r\nincluding canned foods, bakery products, and specialty items.','0','clearjel','1','2023-12-04 09:36:40','2023-11-17 09:59:16'),(148,3,56,'FRIGEX® W - TRUETRACE® IP','06862102','FRIGEX® W modified food starch appears to be a flexible and adaptable \r\ningredient suitable for a variety of food applications. Its versatility \r\nand effectiveness as a thickener make it well-suited for use in \r\naseptically canned products and frozen foods.','0','frigex-w-truetrace-ip-1','1','2023-12-04 09:36:02','2023-11-17 10:03:21'),(149,3,57,'NATIONAL™ T37','12107301','NATIONAL T37 starch, derived from tapioca and produced under the TRUETRACE® \r\nIdentity Preserved Program, aligns with a commitment to non-GMO \r\nstandards and traceability.','0','national-t37-1','1','2023-12-04 09:34:33','2023-11-17 10:07:51'),(150,3,57,'NUTRAFLORA® FB P-95','111002','NUTRAFLORA® FB P-95 is a prebiotic fiber rich in short-chain \r\nfructooligosaccharides, contributing to its potential as a dietary \r\nsupplement for supporting gut health.','0','nutraflora-fb-p-95-1','1','2023-12-04 09:18:28','2023-11-17 10:11:37'),(151,3,64,'BATTER BIND® S TrueTrace® IP','06460000','BATTER BIND® S modified food starch seems to be a starch specifically \r\ndesigned for use in batter applications. It enhances the adhesion of the\r\n coating to meat, poultry, or seafood products. Its inclusion in the \r\nTRUETRACE® Identity Preserved Program provides assurance of non-GMO \r\nstatus.','0','batter-bind-s-truetrace-ip','1','2023-12-04 09:16:09','2023-11-17 10:22:05'),(152,3,64,'NATIONAL™ 0280','07010306','<p>NATIONAL 0280 tapioca dextrin appears to be a starch-based crisping agent designed to enhance the texture, particularly the crispiness, of battered and fried food products, with a specific focus on french fries. Its inclusion in the TRUETRACE® Identity Preserved Program provides assurance of non-GMO status. For specific usage guidelines or more detailed information, it\'s recommended to refer to the product documentation or contact Ingredion Incorporated.</p>','0','national-0280','1','2023-12-04 09:15:23','2023-11-17 10:25:48'),(153,3,65,'TEXTAID® A','12140001','TEXTAID® appears to be a modified food starch with specific \r\nfunctionalities, including easily dispersible pregelatinized properties \r\nand the ability to impart a pulpy or grainy texture to food systems. Its\r\n inclusion in the TRUETRACE® Identity Preserved Program provides \r\nassurance of non-GMO status. <br>','0','textaid-a','1','2023-12-04 09:16:29','2023-11-17 10:32:00'),(154,3,67,'NATIONAL™ 1215','12106005','NATIONAL 1215 corn starch is not chemically modified. This indicates that the starch has not undergone chemical alterations from its natural state. Pregelatinization is a process where starch is heated and then dried for\r\n ease of use. In this case, NATIONAL 1215 corn starch is not \r\npregelatinized, suggesting that it may require cooking or other \r\nprocessing to achieve the desired functionality. This program indicates a commitment to traceability and non-GMO \r\n(non-genetically modified) status, providing transparency about the \r\nsourcing and identity of the ingredients.','0','national-1215','1','2023-12-04 09:16:57','2023-11-17 10:37:10'),(155,3,73,'NOVATION PRIMA 350','34431A00','<p>NOVATION PRIMA® 340 functional native starch appears to be a versatile \r\ningredient offering a combination of functional benefits and marketable \r\nadvantages for manufacturers seeking to enhance the quality, texture, \r\nand appeal of their food products. If you have specific questions or \r\nneed the latest information</p><p>NOVATION PRIMA® 350 Functional Native Starch. It\'s application are<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Refrigerated dressings<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dips and spreads<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sauces, glazes, and marinades<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Fruit preparations<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cream and fruit pie fillings<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Fresh pasta fillings<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Frozen and refrigerated prepared meals<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Instant dairy desserts</p><p></p><p>The provided information suggests that NOVATION PRIMA® 340 functional native starch is designed to enhance the quality and characteristics of various food products, particularly instant dressings, sauces, and fruit preparations. Here\'s a breakdown of the highlighted advantages:<br>Advantages of NOVATION PRIMA® 340 Functional Native Starch:<br><br>&nbsp;&nbsp;&nbsp; Instant Dressings and Sauces:<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Maintains creamy consistency and smooth sheen.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Enables the creation of instant dressings and sauces without compromising texture.<br><br>&nbsp;&nbsp;&nbsp; Fruit Preparations:<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Enhances the appearance of fruit preparations, making them look freshly made.<br><br>&nbsp;&nbsp;&nbsp; Clean Labeling:<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Product labels can feature simple and recognized ingredients.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Labeled as \"corn starch\" for transparency and clean label appeal.</p><ul></ul><p></p><p><br></p><p><strong></strong></p><ul></ul><p></p><br><p></p>','0','novation-prima-350','1','2023-12-04 09:12:04','2023-11-17 10:55:06'),(156,3,74,'Pre-Hydrated® Pectin 1694 Powder','38620900','PRE-HYDRATED<sup>®</sup> Pectin 1694 is a high methoxy pectin that is standardized for viscosity rather than gelling properties. As such, PRE-HYDRATED<sup>®</sup> Pectin 1694 is the ideal candidate for viscosifying fruit juice and other fruit-based beverages. PRE-HYDRATED<sup>®</sup> Pectin 1694 provides an excellent mouthfeel with the taste consumers expect from fruit juices. PRE-HYDRATED<sup>®</sup> Pectin 1694 is typically used at .1% to .2% in most fruit juices.','0','pre-hydrated-pectin-1694-powder','1','2023-12-01 16:16:36','2023-11-17 11:00:04'),(157,3,75,'Dairyblend 366-THK','75000092','<p>DAIRYBLEND 366-THK Powder. It appears to be a versatile stabilizer \r\nsystem with specific applications in thickening milk and cocoa beverages\r\n while addressing whey-off in dairy systems. The fact that it has been \r\nevaluated under both UHT and HTST thermal processing conditions suggests\r\n its suitability for a range of processing methods.</p><p>The recommended usage range of 0.15% to 0.5% based on the desired final viscosity provides practical guidance for formulation.</p>','0','dairyblend-366-thk','1','2023-12-01 16:12:09','2023-11-17 11:02:57'),(158,3,75,'Dairyblend Acidified Beverage 120','38514914','DAIRYBLEND Acidified Beverage 120 stabilizes protein with minimal impact\r\n on viscosity in low pH RTD beverages. This innovative system also \r\nincreases the uniformity of color and the rate at which the product \r\nclears the mouth while reducing the awareness of particulates. \r\nHomogenization is required for optimum stability. Enhances the uniformity of color in the beverage. Requires homogenization for optimum stability during processing.','0','dairyblend-acidified-beverage-120','1','2023-12-01 15:35:41','2023-11-17 11:04:58'),(159,3,76,'INVERTOSE® High Fructose Corn Syrup','026550','Invertose® High Fructose Corn Syrup 026550. The comprehensive \r\ninformation you provided remains consistent with its application \r\nversatility, fermentability, low viscosity, and suitability for various \r\nend uses, especially in the soft drinks industry.','0','invertose-high-fructose-corn-syrup-1','1','2023-12-01 15:28:56','2023-11-17 11:09:08'),(160,3,77,'Pre-Hydrated® Ticalose® CMC 2500 Powder','38510915','PRE-HYDRATED<sup>®</sup> TICALOSE<sup>®</sup> CMC 2500 is a medium viscosity CMC derived from cellulose. Soluble in both cold and hot water, providing versatility in applications. Stable over a broad pH range of 4.0-10.0, allowing for flexibility in formulation. Controls texture and ice crystal growth in frozen dairy products. The agglomerated product undergoes a carefully controlled manufacturing process. Virtually dust-free for enhanced handling in various plant conditions.','0','pre-hydrated-ticalose-cmc-2500-powder','1','2023-12-01 15:24:18','2023-11-17 11:14:59'),(161,3,89,'NOVATION® 2300','34131100','NOVATION® 2300\r\n  functional native starch is a waxy corn starch recommended for high\r\n  temperature/high shear food processing or low pH systems. NOVATION® 2300\r\n  functional native starch is made by a revolutionary technology that results\r\n  in properties similar to modified starches while meeting clean labeling\r\n  criteria. Produced using a revolutionary technology, indicating advanced processing methods. Exhibits properties similar to modified starches, suggesting enhanced functionality. Produced under Ingredion Incorporated’s program for non-GM products, \r\nemphasizing traceability and non-genetically modified (GM) status.','0','novation-2300-1','1','2023-12-01 15:21:32','2023-11-17 11:42:51'),(162,3,91,'NU MOULD OC 20','31609000','NU MOULD OC is a primary component is food-grade corn starch. It contains a small amount of organic oleic sunflower oil.&nbsp;Enables the formation of sharp molded impressions for confections, including marshmallows and gum candies.','0','nu-mould-oc-20-1','1','2023-12-01 15:16:28','2023-11-17 12:52:38'),(163,3,93,'Unidex Agglomerated Dextrose','020540','Unidex®\r\n  Agglomerated Dextrose 020540 is a the primary component is dextrose monohydrate, a simple sugar derived from corn. It contains maltodextrin, which is a carbohydrate derived from starch. It is often used as a thickener or filler in food products.','0','unidex-agglomerated-dextrose-1','1','2023-12-01 15:13:51','2023-11-17 13:08:34'),(164,3,97,'BIOLIGO™ GL 5700 IMF GOS','11300400','A type of indigestible soluble fiber made from lactose. Supports the promotion of a healthy immune system. Supports the promotion of beneficial bacteria in the colon. Easy-to-use syrup form with a high GOS content, suitable for various formulations. Highly tolerant in high-temperature processes and stable in low pH applications, providing versatility in product development. Suitable for a variety of formulations, from shelf-stable juices to nutritional bars.','0','bioligo-gl-5700-imf-gos-1','1','2023-12-01 15:11:30','2023-11-17 13:15:33'),(165,3,97,'Dairyblend BTMLK 06','75000555','DAIRYBLEND BTMLK 06 provideS slight additional viscosity and mouthfeel to products like buttermilk. Specifically designed for use in products like buttermilk, suggesting \r\nits compatibility and effectiveness in enhancing the properties of \r\nbuttermilk-based products.','0','dairyblend-btmlk-06','1','2023-12-01 15:07:05','2023-11-17 13:18:02'),(166,3,98,'Dairyblend SS Instant','38334902','<p>DAIRYBLEND SS Instant is for use in instant soft serve bases. It allows \r\nthe gums to be cold activated and provides a smooth-bodied soft serve \r\nfor the instant dessert mix industry. DAIRYBLEND SS Instant is usually \r\nblended in a finished dry mix base.Tailored for the instant dessert mix industry, indicating its suitability for efficient and quick dessert preparation.</p>','0','dairyblend-ss-instant-1','1','2023-12-01 15:01:25','2023-11-17 13:30:11'),(167,3,100,'FRIGEX® W','06818102','FRIGEX® W modified\r\n  food starch is derived from waxy maize. It is well-suited as a thickener for various food systems. <br><ul><li>Particularly suitable for aseptically canned products.</li></ul>','0','frigex-w','1','2023-12-01 14:58:21','2023-11-17 13:45:42'),(168,3,101,'NOVATION ENDURA® 0100','34610A01','NOVATION ENDURA® 0100 is characterized by exceptional performance in \r\napplications subjected to high heat and high shear processing. Provides excellent stability during freeze/thaw cycles. Aligns with consumer expectations for a simple and transparent label declaration. Aligns with consumer expectations for a simple and transparent label declaration.','0','novation-endura-0100','1','2023-12-01 14:53:07','2023-11-17 13:51:07'),(169,3,102,'Dairyblend Acidified Beverage 120 NGMO','38514933','DAIRYBLEND Acidified Beverage 120 NGMO is formulated to stabilize \r\nproteins, particularly in the challenging environment of low pH RTD \r\nbeverages. Enhances the product\'s mouthfeel by accelerating the rate at which it clears the mouth. Optimum stability requires homogenization, indicating a specific processing step to achieve the desired protein stabilization.','0','dairyblend-acidified-beverage-120-ngmo','1','2023-12-01 14:49:55','2023-11-17 14:05:17'),(170,3,102,'N-DULGE® SA1 - NON-GM IP','10900101','N-DULGE® SA1 is designed to impart a rich and creamy texture to food products. It contributes to a quick and smooth meltaway experience. Provides a texture that is slightly set and cuttable. The product is described as having a texture reminiscent of crème brulee\r\n and similar custard products. This suggests a luxurious and \r\ndessert-like quality. TRUETRACE® Identity Preserved Program, indicating traceability and non-genetically modified (GM) status.','0','n-dulge-sa1-non-gm-ip','1','2023-12-01 14:42:38','2023-11-17 14:08:55'),(171,3,72,'Dairyblend MB2','75000121','DAIRYBLEND MB2 is specifically formulated to stabilize chocolate beverages. Particularly effective for chocolate beverages that undergo UHT \r\nprocessing. UHT processes involve heating a liquid to a very high \r\ntemperature for a short period to achieve microbial stability. Provides a slight increase in viscosity, contributing to the texture of the final product.','0','dairyblend-mb2-1','1','2023-12-01 14:39:29','2023-11-17 14:43:50'),(172,3,72,'ENZOSE® HM Corn Syrup/Glucose','015540','ENZOSE® HM is a syrup with a high maltose content and a regular viscosity.The syrup undergoes ion exchange, a process that involves the replacement of ions to enhance certain properties. Specifically designed for use as a brewing adjunct. This suggests its \r\napplication in the brewing process, possibly for fermentation or flavor \r\nenhancement.','0','enzose-hm-corn-syrup-glucose','1','2023-12-01 14:37:28','2023-11-17 15:14:39'),(173,3,104,'Dairyblend SC-ASC','75000126','DAIRYBLEND SC-ASC is designed to provide a heavy-bodied texture to sour cream. Suitable for both acid set and cultured sour cream formulations. Applicable to both standard and reduced-fat sour cream formulations. Notably, DAIRYBLEND SC-ASC does not contain mono- and di-glyceride emulsifiers.','0','dairyblend-sc-asc','1','2023-12-01 14:33:31','2023-11-17 16:13:39'),(174,3,104,'N-CREAMER® 2000','32136101','N-CREAMER® 2000 is positioned as a modified food starch, indicating its suitability for specific applications. Waxy maize is known for its high amylopectin starch content. N-CREAMER® 2000 exhibits excellent emulsion stabilizing and \r\nencapsulating ability, suggesting its role in maintaining the stability \r\nof emulsions.','0','n-creamer-2000-1','1','2023-12-01 14:31:50','2023-11-17 16:21:23'),(175,3,105,'N-CREAMER® 46','32236103','N-CREAMER® 46 is positioned as a modified food starch, indicating its suitability for specific applications. Waxy maize is known for its high amylopectin starch content. N-CREAMER® 46 exhibits excellent emulsion stabilizing and encapsulating \r\nability, suggesting its role in maintaining the stability of emulsions. Especially suited for use in place of caseinate salts in coffee \r\ncreamers. This indicates its potential as a functional ingredient in \r\ncoffee creamer formulations. Available under Ingredion Incorporated’s TRUETRACE® Identity Preserved \r\nProgram for non-GM products, emphasizing traceability and \r\nnon-genetically modified (GM) status.','0','n-creamer-46-1','1','2023-12-01 14:28:46','2023-11-17 16:25:49'),(176,3,105,'NATIONAL™ 377','06861100','NATIONAL™ 377 is positioned as a modified food starch, indicating its suitability for specific applications. Waxy maize is known for its high amylopectin starch content. Excellent resistance to overcooking, especially in high acid products. Suitable for systems requiring extended cooking periods or high shear. A unique attribute of NATIONAL™ 377 is its bland taste, making it \r\nparticularly suitable for applications where an exceptionally bland \r\nflavor is required. Available under Ingredion Incorporated’s TRUETRACE® Identity Preserved \r\nProgram for non-GM products, emphasizing traceability and \r\nnon-genetically modified (GM) status.','0','national-377-1','1','2023-12-01 14:25:38','2023-11-17 16:31:14'),(177,3,107,'HI FLO®','06440107','HI-FLO® is positioned as a modified food starch, indicating its altered properties for specific applications. Waxy maize is known for its high amylopectin starch content. HI-FLO® exhibits high viscosity, suggesting its effectiveness as a thickening agent. It maintains stability at low temperatures during storage. Particularly well-suited for frozen gravies and sauces, where stability is crucial.','0','hi-flo-1','1','2023-12-01 14:20:46','2023-11-17 16:36:38'),(178,3,107,'HOMECRAFT® Create 860','07897D00','<p>HOMECRAFT® Create 860 Multi-functional Rice Flour. Enables the formulation of smooth and indulgent textures in various applications. It provides opacity, particularly beneficial for sauces. Being rice flour, it can contribute to a potentially healthier and cleaner label image. </p><p>Suitable for a wide range of applications, including:</p><ul><li>Soups and sauces</li><li>Ready meals</li><li>Snacks and cereal</li><li>Batters and breadings</li><li>Dairy-free products</li><li>Baby food</li><li>Chilled and frozen soups, sauces, and ready meals</li><li><br></li></ul><p></p>','0','homecraft-create-860','1','2023-12-01 14:15:21','2023-11-17 16:41:45'),(179,3,108,'Action Gum 10000 EC','75000010','Action Gum 10000 EC is positioned as a versatile thickener and suspending aid suitable for a variety of applications. It can be used in salad dressings, gravies, and industrial applications, showcasing its versatility. Requires low usage levels for effectiveness. Cold water-soluble but equally effective in hot processed systems.','0','action-gum-10000-ec','1','2023-12-01 14:12:46','2023-11-20 08:57:24'),(180,3,108,'INSTANT CLEARJEL - MX','12156128','INSTANT CLEARJEL® is a modified starch, and the term \"instant\" suggests \r\nthat it is pregelatinized, meaning it has been pre-cooked and dried to \r\nmake it readily dispersible in cold water. It indicates that the starch has undergone a process to make it easy to use\r\n in various applications without the need for extensive cooking. This feature makes INSTANT CLEARJEL® suitable for applications involving heat or acidity. Suitable for applications that require cooking or baking, suggesting versatility in both hot and cold preparations.','0','instant-clearjel-mx-1','1','2023-12-01 14:08:25','2023-11-20 09:00:24'),(181,3,109,'AMIOCA™ TF','04400108','AMIOCA TF is a food-grade starch, suitable for use in food applications. Primarily composed of amylopectin, a branched glucose polymer. Amylopectin is one of the two components of starch, the other being amylose. Typically used as a natural thickener and texturizing agent. Starches, in general, are commonly employed in the food industry for their thickening and gelling properties. Available under Ingredion Incorporated’s TRUETRACE® Identity Preserved Program for non-GM products.','0','amioca-tf-1','1','2023-12-01 13:23:10','2023-11-20 09:18:55'),(182,3,109,'CLEARJEL® S','06440108','CLEARJEL® S is a modified starch, indicating that its properties have been altered for specific applications. Derived from waxy maize, suggesting the use of maize with high amylopectin starch content. Primarily used in canned foods and other specialty items. The \r\nversatility of modified starches often allows them to be applied in \r\nvarious formulations. In high pH systems, this starch exhibits high viscosity, making it suitable for applications where thickening is desired. Available under Ingredion Incorporated’s TRUETRACE® Identity Preserved \r\nProgram for non-GM products. This program emphasizes the traceability \r\nand non-genetically modified (GM) status of the product.','0','clearjel-s-1','1','2023-12-01 13:20:05','2023-11-20 09:26:18'),(183,3,110,'Caragum® 200','38364900','CARAGUM® 200 is a special blend of gums.Designed to impart viscosity when added to cold water. Further boosts viscosity after heating to 180°F. Used for thickening and adding body to products such as soups, sauces, and gravies. Widely used to replace wheat starch in traditional sauces. Replaces other starches to allow for more delicate flavors to be detected in the final product.','0','caragum-200','1','2023-12-01 13:15:21','2023-11-20 09:37:02'),(186,3,120,'ULTRA-SPERSE® SR','32566111','ULTRA -SPERSE® SR Modified Food Starch. It is derived from waxy maize (high amylopectin maize). It\'s mainly characterstics&nbsp; is premium cold water swelling starch, particularly well-suited for instant food preparations, resilient under severe processing conditions. Available under Ingredion Incorporated’s TRUETRACE® Identity Preserved Program for non-GM products.','0','ultra-sperse-sr','1','2023-12-01 13:00:40','2023-11-20 10:07:18'),(187,3,121,'PENBIND® 1000','06850403','PenBind® 1000 is a modified starch derived from potatoes, indicating \r\nthat its properties have been altered for specific applications. It indicating \r\nthat its properties have been altered for specific applications.Suggests effective moisture retention.&nbsp; Provides excellent stability during freeze/thaw cycles, which is crucial in frozen food applications. Provides a clear dispersion when combined with proteins at low cooking \r\ntemperatures, indicating versatility in different formulations.','0','penbind-1000-1','1','2023-12-01 12:54:14','2023-11-20 10:42:51'),(188,3,122,'FIRM-TEX®','06811109','FIRM -TEX®\r\n  modified food starch is derived from waxy maize. It is used as a binder and\r\n  texturizer in cooked meat products and other applications where a low\r\n  gelatinization temperature is required .','0','-1','1','2023-11-20 10:56:11','2023-11-20 10:56:11'),(189,3,122,'FIRM-TEX® TrueTrace® IP','06863102','FIRM-TEX® is a modified starch, suggesting that it has undergone processing to alter its properties for specific applications. Commonly utilized in cooked meat products, where it likely contributes to texture and binding characteristics. Suitable for applications where a low gelatinization temperature is \r\nrequired. Gelatinization is the process where starch absorbs water and \r\nswells when heated, leading to changes in texture and viscosity. TRUETRACE® Identity Preserved Program for non-GM products. This program \r\nemphasizes the traceability and non-genetically modified (GM) status of \r\nthe product.','0','firm-tex-truetrace-ip','1','2023-12-01 12:49:59','2023-11-20 11:01:14'),(190,3,124,'N-HANCE® 59','07730402','<ul><li>N-HANCE® 59 is a functional native starch. Recommended for low-temperature and low-shear food processing, making it suitable for specific applications. It exhibits properties similar to modified starches, suggesting improved functionality without extensive modification. Produced under Ingredion Incorporated’s TRUETRACE® Identity Preserved Program for non-GM products. The TRUETRACE® program emphasizes traceability and non-genetically modified (GM) status, aligning with clean labeling trends.</li></ul>','0','n-hance-59','1','2023-12-01 12:48:25','2023-11-20 11:21:12'),(191,3,124,'NATIONAL™ 740','06840000','NATIONAL™ 740 is a modified food starch derived from corn. Modification\r\n typically involves altering the physical or chemical properties of the \r\nstarch for specific applications. The starch is based on corn, which is a common source for modified food starch. This indicates that the starch has a strong thickening ability. Imparts a heavy-bodied, smooth, short texture when hot. This suggests it\r\n may be used for applications where texture is important, such as in \r\nsauces or soups.  The product is available under Ingredion Incorporated’s TRUETRACE® \r\nIdentity Preserved Program for non-GM products. This indicates that it \r\nis part of a program ensuring the traceability and non-genetically \r\nmodified (GM) status of the product.','0','national-740','1','2023-12-01 12:37:51','2023-11-20 11:25:35'),(192,3,127,'HOMECRAFT® PULSE 5101','37102F01','HOMECRAFT Pulse 5101 is a type of flour derived from lentils. The flour is obtained from the mechanically milled and processed portion\r\n of the dehulled split lentil cotyledons, specifically from red lentils. The flour is derived from sound, healthy, dry, and clean red lentils, emphasizing the use of quality raw materials. The flour undergoes mechanical milling and processing. This implies that\r\n the manufacturer uses mechanical methods to grind and process the \r\nlentils into flour.','0','homecraft-pulse-5101','1','2023-12-01 12:34:52','2023-11-20 11:29:18'),(193,3,127,'HOMECRAFT® Pulse CT 2201 Flour','37102F03','HOMECRAFT® Pulse CT 2 201 Flour is a type of flour derived from lentils. The flour is obtained from the mechanically milled and processed portion\r\n of the dehulled split lentil cotyledons, indicating a focus on the \r\ninterior part of the lentil. The flour is derived from sound, healthy, dry, and clean lentils, emphasizing the use of quality raw materials. The flour undergoes proprietary physical treatment, although the \r\nspecific details of this treatment are not provided. This treatment is \r\nlikely part of the manufacturer\'s unique process to achieve specific \r\ncharacteristics. The proprietary physical treatment is mentioned to provide a cleaner \r\nflavor profile. This suggests that the processing method is designed to \r\nreduce undesirable flavors and enhance the overall taste of the lentil flour.<br>','0','homecraft-pulse-ct-2201-flour','1','2023-12-01 12:33:00','2023-11-20 11:36:33'),(194,3,128,'PENCLING® 320','06450402','PenCling® 320 is a modified starch derived from potatoes. Modification \r\ntypically involves physical, chemical, or enzymatic treatments to alter \r\nthe properties of the starch. These characteristics suggest that PenCling® 320 has strong thickening \r\nproperties, can retain moisture effectively, and is capable of binding \r\ningredients together. The starch is noted for providing moisture control, which can be crucial\r\n in certain food applications to maintain the desired texture and shelf \r\nlife. PenCling® 320 is mentioned as contributing to the stability of Asian \r\nnoodles and baked goods. This suggests its role in enhancing the texture\r\n and overall quality of these food products. Noted for not masking subtle flavors of products, which makes it \r\nsuitable for applications where the original flavors of the food product\r\n need to be preserved.','0','pencling-320','1','2023-12-01 12:29:39','2023-11-20 11:38:11'),(195,3,128,'PENPURE® 10','04400403','PenPure® 10 is a type of starch derived directly from potatoes without undergoing significant modification. Extremely high viscosity, which indicates its ability to form thick solutions or gels when mixed with water. The starch is noted for having a high water-holding capacity, suggesting its ability to retain moisture. This characteristic implies that the starch has strong binding \r\nproperties, which can be beneficial in various applications where \r\nbinding or thickening is desired. Mentioned as bland in taste, suggesting that the starch is relatively \r\nneutral, making it suitable for a wide range of applications without \r\ncontributing a distinct flavor.','0','penpure-10','1','2023-12-01 12:25:31','2023-11-20 11:55:06'),(196,3,129,'HOMECRAFT® Pulse CT 4201 Flour','37102H02','HOMECRAFT® Pulse CT 4201 Flour is a type of flour derived from chickpeas.  It is obtained from the mechanically milled and processed portion of the dehulled split chickpea cotyledons. The flour is derived from sound, healthy, dry, and clean chickpeas, indicating a focus on quality raw materials. The flour undergoes proprietary physical treatment. This treatment is \r\nnot specified but is likely a part of the manufacturer\'s unique process \r\nto achieve specific characteristics. The proprietary physical treatment is mentioned to provide a cleaner \r\nflavor profile. This suggests that the processing method is designed to \r\nreduce undesirable flavors and enhance the overall taste of the chickpea\r\n flour.','0','homecraft-pulse-ct-4201-flour-1','1','2023-12-01 11:03:30','2023-11-20 12:49:02'),(199,3,256,'ENZOSE® 36 DE Corn Syrup/Glucose','014300','Enzose® 36Corn\r\n  Syrup/Glucose 014300 is an enzyme conversion, ion-exchanged, normal viscosity\r\n  syrup .&nbsp; This treatment is likely employed to purify and refine the syrup, possibly by removing impurities.','0','enzose-36-de-corn-syrup-glucose-1','1','2023-12-01 10:52:20','2023-11-20 14:27:40'),(200,3,256,'ENZOSE® 62 DE Corn Syrup/Glucose','016500','<p>ENZOSE® 62 DE Corn Syrup/Glucose is an enzyme-converted corn syrup with ion-exchange treatment, is likely to have specific characteristics that make it suitable for various applications. The D.E. value of 62 indicates a substantial conversion of starch into sugars, making it a sweetening agent. The regular viscosity suggests a moderate thickness or consistency.</p>','0','enzose-62-de-corn-syrup-glucose','1','2023-12-01 10:51:04','2023-11-20 14:36:38'),(205,3,255,'GLOBE® 62 DE Corn Syrup/Glucose','016720','Globe® Corn Syrup/Glucose 016720 is a high conversion, ion-exchanged, highly fermentable syrup with high solids .','0','globe-62-de-corn-syrup-glucose','1','2023-12-01 09:52:13','2023-11-20 16:48:25'),(206,3,255,'HOMECRAFT® CREATE 315','34131M00',NULL,'0','homecraft-create-315-1','1','2023-12-01 09:41:30','2023-11-20 16:51:21'),(207,3,255,'HOMECRAFT® CREATE 335','34131M02',NULL,'0','homecraft-create-335','1','2023-12-01 09:41:08','2023-11-20 16:55:19'),(208,3,228,'VERSAFIBE™ 1490 Dietary Fiber','06400400','<div class=\"rte-block\">VERSAFIBE™ dietary fiber.&nbsp; Facilitate the development of high-fiber foods without compromising taste and texture. Addresses the growing consumer demand for increased fiber intake. Suitable for a variety of products, including bread, tortillas, muffins, cereal, pretzels, and pasta. VERSAFIBE™ is introduced as a novel insoluble fiber with minimal impact \r\non taste, color, or texture. It\'s claimed to improve texture, reduce \r\ncalories, and provide processing ease. Supports positive label claims such as \"good source of fiber\" or \"excellent source of fiber.\"&nbsp; Potential to carry a \"gluten-free\" label. Positions products favorably in the competitive grocery aisle landscape, potentially encouraging trial and repeat purchases.</div>','0','versafibe-1490-dietary-fiber-1','1','2023-11-30 17:05:15','2023-11-21 09:28:17'),(209,3,144,'ENZOSE® 62 DE Corn Syrup/Glucose','016700','Enzose® 62 DE Corn Syrup/Glucose 016700 is a corn syrup or glucose syrup. It is mentioned as an \"enzyme conversion, ion-exchanged\" product. Specifically, it mentions a 62 D.E., so this syrup is a 62% dextrose equivalent syrup.','0','enzose-62-de-corn-syrup-glucose-1','1','2023-11-30 17:01:14','2023-11-21 09:45:12'),(210,3,145,'HOMECRAFT® Pulse 2101 Flour','37102F00','HOMECRAFT® Pulse 2101 Flour is a lentil flour. It is derived from the mechanically milled and processed portion of the \r\ndehulled split lentil cotyledons of sound, healthy, dry, and clean \r\nlentils (Lens culinaris). The mention of \"mechanically milled and processed\" suggests the use of \r\nmechanical methods, possibly to preserve certain qualities of the \r\nlentils.','0','homecraft-pulse-2101-flour','1','2023-11-30 16:59:44','2023-11-21 10:20:36'),(211,3,145,'HOMECRAFT® Pulse 1101 Flour','37102E00','HOMECRAFT® Pulse 1101 Flour is a pea flour. It is derived from the mechanically milled and processed portion of the \r\ndehulled split pea cotyledons of sound, healthy, dry, and clean peas \r\n(Pisum sativum). Being specifically obtained from peas, it is likely to carry the \r\nnutritional characteristics and properties associated with peas. The mention of \"mechanically milled and processed\" suggests the use of \r\nmechanical methods, possibly to preserve certain qualities of the peas.','0','homecraft-pulse-1101-flour-1','1','2023-11-30 16:58:10','2023-11-21 10:27:28'),(212,3,146,'HYSTAR® HM-75 Maltitol Syrup','271321','HYSTAR® HM-75 is a maltitol syrup that does not crystallize. It contains at least 50% maltitol, which is a sugar alcohol known for \r\nits sweetness with a reduced caloric content compared to sugar. The non-crystallizing nature of this syrup makes it suitable for certain\r\n applications where avoiding crystal formation is desired. It is mentioned to have a caloric content of 3.0 calories per gram on a dry basis (d.b.). HYSTAR® HM-75 maltitol syrup is specifically noted for its use in baking\r\n and confectionery applications. It contributes sweetness and humectancy\r\n to these products.','0','hystar-hm-75-maltitol-syrup-1','1','2023-11-30 16:53:52','2023-11-21 10:34:36'),(213,3,231,'NOVATION® 9230 - organic starch','34131102','NOVATION® 9230 is a certified organic functional native starch derived from waxy corn. The starch is recommended for high-temperature, high-shear, or low pH food processing systems. Functional native starches, including NOVATION® 9230, are produced using revolutionary technology. The product is produced under Ingredion Incorporated’s TRUETRACE® Identity Preserved Program for non-GM products.','0','novation-9230-organic-starch','1','2023-11-30 16:49:08','2023-11-22 10:09:25'),(215,3,233,'N-TACK®','10860102','N-TACK® corn syrup solids is derived from waxy corn starch. N-TACK® is specifically designed as a specialty product recommended for \r\nthe adhesion of seasonings, flavorings, and particulates to snacks and \r\ncereals.  It is highlighted that N-TACK® corn syrup solids are well suited for \r\nreduced-fat products where oil cannot be used for adhesion purposes. The product is characterized by low viscosity at high solids levels. N-TACK® corn syrup solids exhibit a high degree of tackiness, emphasizing its role in providing adhesion to various ingredients. The product is available under Ingredion Incorporated’s TRUETRACE® Identity Preserved Program for non-GM products.','0','n-tack-1','1','2023-11-30 16:43:40','2023-11-22 10:41:51'),(216,3,234,'CRYSTAL TEX® 627M','07240300','CRYSTAL TEX® 627M dextrin is derived from tapioca, a common and versatile ingredient in the food industry. This dextrin is specifically noted for its exceptional stability, \r\nindicating that it maintains its properties well under various \r\nconditions. The product is produced under Ingredion Incorporated’s TRUETRACE® Identity Preserved Program for non-GM products. This program emphasizes traceability and quality control to verify the non-GMO status of the products.','0','crystal-tex-627m-1','1','2023-11-30 16:15:36','2023-11-22 10:52:34'),(217,3,234,'GLOBE® 28 DE Corn Syrup Solids NON-GMO IP','10560091','GLOBE® 28 DE Corn Syrup Solids has a moderate sweetness level, making it versatile for different applications. Suitable for a wide range of food applications where a liquid product is not practical. The product is in a convenient powdered form, making it easy to handle, store, and incorporate into various food products. GLOBE® 28 DE Corn Syrup Solids provides high solution clarity, which is \r\nbeneficial for applications where a clear appearance is desired. The product has a bland flavor, allowing it to be used without significantly affecting the taste of the final product. Produced from non-genetically modified corn, aligning with the preference for non-GMO ingredients.','0','globe-28-de-corn-syrup-solids-non-gmo-ip','1','2023-11-30 16:07:10','2023-11-22 10:56:51'),(218,3,234,'GLOBE® 62 DE Glucose Syrup NON GMO IP','01650090','Globe® 62 glucose syrup is produced through enzyme conversion. The syrup undergoes ion-exchange, a process that involves the removal or exchange of ions in the solution. The syrup has a Dextrose Equivalent of 62. D.E. is a measure of the \r\nsweetness of a syrup, with higher values indicating higher sweetness. Globe® 62 glucose syrup is described as having regular viscosity. Viscosity is a measure of a fluid\'s resistance to flow. This syrup is derived from corn, which is a common source for glucose syrups. The product is labeled as non-GMO, indicating that it is produced from non-genetically modified corn. The syrup is produced under Ingredion Incorporated’s TrueTrace™ Program for non-GM products.','0','globe-62-de-glucose-syrup-non-gmo-ip','1','2023-11-30 15:55:24','2023-11-22 11:22:44'),(219,3,236,'PENBIND® 800','05090400','PenBind® 800 is noted for its favorable gelling and texturizing \r\nproperties. This suggests that it has the ability to contribute to the \r\ntexture and structure of food products, particularly in applications \r\nwhere gelling is desirable. The starch is specified as suitable for imitation cheese applications. \r\nIn such applications, starches are often used to mimic the texture and \r\nmouthfeel of real cheese. PenBind® 800 forms a firm gel. This characteristic is valuable in applications where a solid or semi-solid texture is desired. The starch is described as extremely white in color. PenBind® 800 is bland in taste. This is advantageous, especially in \r\napplications where the starch is not intended to contribute to the \r\nflavor profile, allowing other ingredients to shine.','0','penbind-800','1','2023-11-30 15:53:31','2023-11-22 11:35:25'),(220,3,236,'PENPURE® 85D','12100410','<div class=\"rte-block\">PENPURE® 85D texturizer allows for the creation of various textures in \r\nbaked snacks, including soft or shattering bites in crackers, loud \r\ncrunch or light crispiness in baked chips, and appealing textures in \r\nvegan, gluten-free crisps. The texturizer is suitable for formulating vegan and gluten-free crisps,\r\n catering to current dietary trends and consumer preferences. Formulators can customize the crispiness of the snacks, providing \r\nflexibility to meet non-grain, clean label, and non-GMO trends. PENPURE® 85D texturizer offers several functional benefits<strong>.</strong> Enhancing the efficiency of the manufacturing process. The texturizer provides the speed advantage of cold water swelling \r\nstarches, indicating quick hydration and functionality in various \r\napplications. The use of PENPURE® 85D texturizer is expected to improve the bottom \r\nline, suggesting potential cost-effectiveness or efficiency gains in \r\nproduction.</div>','0','penpure-85d-1','1','2023-11-30 15:51:29','2023-11-22 11:41:55'),(221,3,237,'PENNOVO® MD-10','10910400','The maltodextrin is described as having an exceptionally bland flavor. \r\nThis is a desirable characteristic in many applications, especially in \r\nfood and beverage formulations where the goal is to provide texture, \r\nbody, or other functional properties without introducing strong flavors.','0','pennovo-md-10-1','1','2023-11-30 14:53:46','2023-11-22 12:39:28'),(222,3,237,'ULTRA-SPERSE® 3','32596301','ULTRA-SPERSE® 3 is described as a high-performance, cold water swelling \r\n(CWS) starch. This means that it can disperse and swell in cold water, \r\nwhich is a useful property in various applications. The starch is derived from tapioca, a root vegetable known for its starchy content. ULTRA-SPERSE® 3 exhibits many properties of a modified cook-up starch. The starch is noted for having a very bland flavor profile, indicating \r\nthat it is unlikely to contribute strong flavors to the final product. ULTRA-SPERSE® 3 exhibits excellent dispersibility, meaning it can mix well with liquids without forming lumps. The starch imparts superior sheen, clarity, and smoothness when compared to traditional pregelatinized starches. The product is produced under Ingredion Incorporated’s TRUETRACE® \r\nIdentity Preserved Program for non-GM products, confirming that it is \r\nsourced from non-genetically modified ingredients.','0','ultra-sperse-3-1','1','2023-11-30 14:51:50','2023-11-22 12:42:34'),(223,3,45,'HOMECRAFT® Pulse 3103 Flour','37103G00','HOMECRAFT® Pulse 3103 Flour is a faba bean flour. The flour is obtained through mechanical milling and processing. The flour is derived from the dehulled split cotyledons of faba beans. \r\nCotyledons are the seed leaves of the plant embryo and are often rich in\r\n nutrients. It specifies that the faba beans used are sound, healthy, dry, and clean.','0','homecraft-pulse-3103-flour-1','1','2023-11-30 14:48:38','2023-11-22 13:40:52'),(224,3,45,'HOMECRAFT® Pulse 4101 Flour','37102H00','HOMECRAFT® Pulse 4101 Flour is a chickpea flour. This flour is obtained through mechanical milling and processing. The flour is derived from the dehulled split cotyledons of chickpeas. It specifies that the chickpeas used are sound, healthy, dry, and clean.','0','homecraft-pulse-4101-flour','1','2023-11-30 14:47:13','2023-11-22 14:31:00'),(225,3,239,'HOMECRAFT® Pulse 3101 Flour','37102G00','HOMECRAFT® Pulse 3101 Flour is a faba bean flour. Faba beans, also known as broad beans. The flour is obtained through mechanical milling and processing. \r\nMechanical milling involves the use of machinery to grind or crush the \r\nbeans into a fine powder. The flour is derived from the dehulled split cotyledons of faba beans. \r\nCotyledons are the seed leaves of the plant embryo and are often rich in\r\n nutrients. It specifies that the faba beans used are sound, healthy, dry, and \r\nclean. This ensures that the starting material is of good quality. It specifies that the faba beans used are sound, healthy, dry, and \r\nclean. This ensures that the starting material is of good quality.','0','homecraft-pulse-3101-flour','1','2023-11-30 14:44:45','2023-11-22 14:45:04'),(226,3,239,'PURITY® 69','06430300','PURITY® 69 is refined from tapioca, a starchy substance extracted from the roots of the cassava plant. This modified food starch is designed to provide smooth, short textural properties. Characteristically bland flavor is mentioned, indicating that the starch\r\n is not expected to contribute strong flavors to the final product. PURITY® 69 is suitable for a wide range of food applications. The product is produced under Ingredion Incorporated’s TRUETRACE® Identity Preserved Program for non-GM products.','0','purity-69-1','1','2023-11-30 14:42:02','2023-11-22 14:52:21'),(227,3,240,'SORBOGEM® 1162 Crystalline Sorbitol NF/FCC','261055','SORBOGEM® 1162 is described as crystalline sorbitol, indicating that it has a crystalline structure. This crystalline sorbitol is designed for use in food, confectionery, and pharmaceutical applications. Typical functionality is as a cryoprotectant, crystallization inhibitor,\r\n freeze point depressant, plasticizer, humectant and excipient .','0','sorbogem-1162-crystalline-sorbitol-nf-fcc-1','1','2023-11-30 14:36:49','2023-11-22 15:08:40'),(228,3,151,'CASCO™ Corn Starch Food Grade','034130','CASCO corn starch, Food Grade 034130, is described as a thick-boiling corn starch. This starch is suitable for use wherever moisture absorbency is required. The starch is packed in moisture barrier bags. This packaging is \r\ndesigned to retain its low moisture characteristic until it is used.','0','casco-corn-starch-food-grade','1','2023-11-30 14:34:37','2023-11-22 15:17:33'),(229,3,242,'HYLON® VII','04400B01','HYLON® VII is described as an unmodified corn starch derived from high amylose corn. This corn starch contains approximately 70% amylose. Amylose is known \r\nfor its role in gelling, film-forming, and opacifying properties, which \r\ncan be significant in various food applications. HYLON® VII starch is used in a variety of food applications. The \r\nspecific mention of its excellent gelling, film-forming, and opacifying \r\nproperties suggests that it can contribute to the texture, structure, \r\nand appearance of food products. The starch is noted for its excellent gelling properties. This indicates\r\n that it has the ability to form gels, which can be valuable in \r\napplications where thickening or gelling is desired. HYLON® VII starch is mentioned to have film-forming properties. \r\nFilm-forming is relevant in applications where a thin layer or coating \r\nis desired, such as in certain confectionery or coating applications. pacifying properties suggest that the starch can contribute to the opacity or cloudiness of a product. The product is available under Ingredion Incorporated’s TRUETRACE® Identity Preserved Program for non-GM products.','0','hylon-vii-1','1','2023-11-30 14:32:10','2023-11-22 15:26:52'),(230,3,243,'HOMECRAFT® Pulse CT 3203 Flour','37101G00',NULL,'0','homecraft-pulse-ct-3203-flour','1','2023-11-30 14:30:11','2023-11-22 15:41:32'),(231,3,244,'N-ZORBIT™ 2144','32110112','​N-ZORBIT™ 2144 is described as a nature-based plating agent, suggesting that it is derived from natural sources. This plating agent is characterized as a high-performance carrier. N-ZORBIT™ 2144 is designed to transform liquid substances into flowable \r\npowders. This functionality can be valuable in various industries, \r\nincluding food, beverage, fragrance, animal nutrition, and industrial \r\napplications. The carrier can be used to deliver a range of substances, including \r\nflavors, seasonings, vitamins, fragrances, syrups, and other oil-soluble\r\n or water-soluble materials. The product is available under Ingredion Incorporated’s TRUETRACE® Identity Preserved Program for non-GM products.','0','n-zorbit-2144','1','2023-11-30 14:29:53','2023-11-22 17:08:38'),(232,3,245,'PURITY® 87','06801302','PURITY® 87 is derived from tapioca, which is a starchy substance extracted from the roots of the cassava plant. This modified food starch is especially suited for use in low pH food \r\nsystems. Low pH environments, which are acidic, can present challenges \r\nfor some ingredients, and this starch is designed to perform well under \r\nsuch conditions. PURITY® 87 is recommended for use in low pH food systems where high temperature and shear conditions are encountered. The product is produced under Ingredion Incorporated’s TRUETRACE® Identity Preserved Program for non-GM products.','0','purity-87','1','2023-11-30 14:27:19','2023-11-23 09:10:44'),(233,3,246,'NATIONAL™ 3700 - NON-GM IP','32636100','NATIONAL™ 3700 is described as a unique emulsion stabilizing starch, and it is derived from waxy maize. NATIONAL™ 3700 is recommended as a replacement for gum arabic in flavor emulsions. NATIONAL™ 3700 is suggested as a stabilizer for other food emulsions. The starch is cold water soluble, which means it can dissolve in cold water. NATIONAL™ 3700 displays very good viscosity stability. The product is available under Ingredion Incorporated’s TRUETRACE® Identity Preserved Program for non-GM products.','0','national-3700-non-gm-ip-1','1','2023-11-30 14:21:26','2023-11-23 09:22:47'),(234,3,246,'PURITY GUM® 2000','32336103','PURITY GUM® 2000 is described as an emulsion stabilizing starch, and it \r\nis derived from waxy maize. Waxy maize, known for its high amylopectin \r\ncontent, can impact the functional properties of the starch. The product is recommended as a replacement for gum arabic in flavor emulsions. Gum arabic is a natural gum.&nbsp;In addition to flavor emulsions, PURITY GUM® 2000 is suggested as a stabilizer for other food emulsions. The product is available under Ingredion Incorporated’s TRUETRACE® Identity Preserved Program for non-GM products.','0','purity-gum-2000','1','2023-11-30 14:19:18','2023-11-23 09:33:14'),(235,3,247,'TIC Pretested® Gum Arabic Spray Dry','38810916',NULL,'0','tic-pretested-gum-arabic-spray-dry-1','1','2023-11-30 14:16:06','2023-11-23 09:41:57'),(236,3,247,'TIC Pretested® Gum Arabic Spray Dry Powder','75000566FP',NULL,'0','tic-pretested-gum-arabic-spray-dry-powder','1','2023-11-30 14:15:46','2023-11-23 09:42:25'),(237,3,248,'FASTir® Xanthan EC','38420904',NULL,'0','fastir-xanthan-ec','1','2023-11-30 14:15:30','2023-11-23 09:59:58'),(238,3,248,'INSTANT TEXTAID® A','12141302','INSTANT TEXTAID® A is a modified food starch that is pregelatinized and \r\nrefined from tapioca. Pregelatinized starch is starch that has been \r\ncooked and then dried, making it easier to disperse in cold water. This starch is designed to add unique textural properties to a wide range of food applications. INSTANT TEXTAID® A is specifically recommended for use in systems where heat and mechanical shear stress are minimal. The product is produced under Ingredion Incorporated’s TRUETRACE® \r\nIdentity Preserved Program for non-GM products. This certification \r\nindicates that it is sourced from non-genetically modified ingredients.','0','instant-textaid-a','1','2023-12-12 10:56:49','2023-11-23 10:11:32'),(239,3,249,'INSTANT TEXTRA®','32196300','INSTANT TEXTRA® is described as a modified starch that is cold water soluble and derived from tapioca. In fluid or semi-solid systems, this starch exhibits oil-like properties. INSTANT TEXTRA® imparts superior sheen, clarity, and bland taste to food products. This modified starch is noted for its exceptional stability to gelling \r\nupon refrigeration. This modified starch is noted for its exceptional stability to gelling \r\nupon refrigeration. This property is likely important in applications \r\nwhere gelling is desired for texture or consistency, especially in \r\nchilled or refrigerated products. INSTANT TEXTRA® is highlighted for its superior sheen, clarity, and stability to gelling. The product is produced under Ingredion Incorporated’s TRUETRACE® \r\nIdentity Preserved Program for non-GM products, indicating that it is \r\nsourced from non-genetically modified ingredients.','0','instant-textra','1','2023-12-12 15:29:50','2023-11-23 10:22:00'),(240,3,249,'N-DULGE® C2 - NON-GM IP','06760100','N-DULGE® C2 is described as a co-texturizer derived from waxy maize. \r\nWaxy maize is known for its high amylopectin content, which can \r\ninfluence the texture and functional properties of starch. This modified food starch imparts a slight mouth-coating and slipperiness, reminiscent of a chocolate sauce-like texture. N-DULGE® C2 is designed to create a smooth and creamy texture in food products. The starch imparts high lubricity. Lubricity refers to the reduction of friction or the slippery quality of a substance. The product is available under Ingredion Incorporated’s TRUETRACE® Identity Preserved Program for non-GM products.','0','n-dulge-c2-non-gm-ip','1','2023-11-30 14:07:04','2023-11-23 10:34:22'),(241,3,250,'NOVATION® 5600','34481102','NOVATION® 5600 is described as a CWS functional native waxy maize \r\nstarch. This indicates that it swells in cold water and is derived from \r\nwaxy maize, which is known for its high amylopectin content. It provides the properties of premium instant starches. Instant starches\r\n are known for their ability to disperse easily and contribute desirable\r\n characteristics to food products. The starch yields a short texture, good sheen, clarity, and smoothness \r\nin food products. These attributes contribute to the overall quality and\r\n sensory appeal of the final product. It is made by a revolutionary technology that results in properties similar to modified cold water swelling (CWS) starches. NOVATION® 5600 functional native starch meets clean label labeling \r\ncriteria. Clean label typically refers to a product with a simplified \r\ningredient list, free from artificial additives and preservatives. The starch is produced under Ingredion Incorporated’s TRUETRACE® \r\nIdentity Preserved Program for non-GM products, indicating that it is \r\nsourced from non-genetically modified ingredients.','0','novation-5600-1','1','2023-11-30 14:04:59','2023-11-23 10:59:44'),(242,3,252,'HI-SET® LJ','05341003','HI-SET® LJ modified food starch is primarily used in the confectionery industry. As a one-piece product, which may imply that it is a single, integrated solution for specific confectionery applications. HI-SET® LJ combines the features of thin-boiling and high amylose starches. Specifically formulated for the manufacture of jelly gum candies, \r\nindicating that it provides functionalities required in this particular \r\ntype of confectionery. It offers&nbsp; low hot viscosity. Despite having low hot viscosity, it provides the quick-setting benefits of high amylose. Unlike conventional high amylose-containing starches, HI-SET® LJ offers \r\nthe confectioner a unique combination of low hot viscosity and \r\nquick-setting benefits.','0','hi-set-lj','1','2023-11-30 14:03:00','2023-11-23 11:13:27'),(243,3,252,'TICorganic® Ticagel® GC-553','75000869',NULL,'0','ticorganic-ticagel-gc-553','1','2023-11-30 13:53:25','2023-11-23 11:17:58'),(244,3,253,'MELOJEL®','03401048','MELOJEL® is derived from dent corn, a variety of field corn known for the dented appearance at the top of the kernels. Being a food-grade starch means that MELOJEL® meets the standards and \r\nrequirements for use in food products. It indicates that it is safe and \r\nsuitable for consumption. The key characteristic of MELOJEL® is its ability to form a strong gel \r\nafter cooling a cooked dispersion. This property is significant in \r\nvarious food applications where gel formation is desired for thickening,\r\n gelling, or stabilizing.','0','melojel','1','2023-11-30 13:49:45','2023-11-23 12:19:10'),(245,3,253,'MELOJEL® - TRUETRACE® IP','03401044','MELOJEL® is derived from dent corn, which is a variety of field corn. \r\nThe source of the corn can influence the properties of the starch. This corn starch is characterized by a strong gel formation after \r\ncooling a cooked dispersion. Gel formation is a common property of \r\nstarches and is often used in food applications for thickening or \r\ngelling. MELOJEL® is described as a food-grade starch, indicating that it meets the standards and requirements for use in food products. The product is available under Ingredion Incorporated’s TRUETRACE® \r\nIdentity Preserved Program for non-GM products. This certification \r\nsignifies that the corn starch is sourced from non-genetically modified \r\ningredients.','0','melojel-truetrace-ip','1','2023-11-30 13:48:44','2023-11-23 12:27:02'),(246,3,254,'THERMFLO®','06810107','THERMFLO® modified\r\n  food starch is derived from waxy maize. It is an extremely versatile product\r\n  that is especially applicable in high and low pH food systems where\r\n  exceptional tolerance to heat and shear is required . <br>','0','-1','1','2023-11-23 13:04:25','2023-11-23 13:04:25'),(247,3,254,'THERMFLO® - TRUETRACE® IP','06810112','THERMFLO® is derived from waxy maize, a type of corn with high \r\namylopectin content. The source can impact the functional properties of \r\nthe starch. Described as an extremely versatile product, indicating that it has a \r\nbroad range of applications and functionalities in food formulations. Particularly applicable in both high and low pH food systems. This \r\nversatility suggests that the starch can function effectively across a \r\nspectrum of acidity levels. THERMFLO® is noted for its exceptional tolerance to heat and shear. This\r\n is important in food processing where ingredients may be subjected to \r\nhigh temperatures and mechanical forces. The product is available under Ingredion Incorporated’s TRUETRACE® \r\nIdentity Preserved Program for non-GM products. This certification \r\nindicates that the starch is sourced from non-genetically modified \r\ningredients, aligning with the preference for non-GM products.','0','thermflo-truetrace-ip','1','2023-11-30 13:46:32','2023-11-23 13:18:04'),(248,3,254,'ULTRA-TEX® 2000','32166107','ULTRA-TEX® 2000 is described as a premium CWS starch, indicating that it\r\n swells and thickens in cold water. This is valuable for certain food \r\napplications where instant dispersion is required. The starch is derived from waxy maize, a type of corn known for its high\r\n amylopectin content. The source can influence the functional properties\r\n of the starch. Well-suited for instant food preparations, suggesting that it is \r\ndesigned for use in products that require quick and easy preparation. ULTRA-TEX® 2000 is highlighted for providing high viscosity, a smooth \r\ntexture, and a creamy mouthfeel. These characteristics are important in \r\nachieving a desirable eating experience, particularly in instant foods. The product is available under Ingredion Incorporated’s TRUETRACE® \r\nIdentity Preserved Program for non-GM products. This certification \r\nindicates that the starch is sourced from non-genetically modified \r\ningredients, aligning with the preference for non-GM products.','0','ultra-tex-2000','1','2023-11-30 13:44:46','2023-11-23 13:42:44'),(249,3,257,'HOMECRAFT® CREATE 365','34131M01',NULL,'0','homecraft-create-365-1','1','2023-12-12 15:36:44','2023-11-23 14:49:45'),(250,3,257,'NATIONAL FRIGEX® HV','06821300','NATIONAL FRIGEX® HV is derived from tapioca, which is a root vegetable. \r\nTapioca starch is commonly used as a thickening agent in various food \r\napplications. The modified starch is noted for its stability under low-temperature \r\nstorage conditions. This stability is crucial for maintaining the \r\nquality and functionality of the starch in products that are stored or \r\ntransported in cold environments. The product is produced under Ingredion Incorporated’s TRUETRACE® \r\nIdentity Preserved Program for non-GM products. This certification \r\nindicates that the starch is sourced from non-genetically modified \r\ningredients, aligning with the preferences of consumers who seek non-GM \r\nproducts.','0','national-frigex-hv','1','2023-11-30 11:49:32','2023-11-23 15:14:31'),(251,3,259,'PENNOVO® 00','06170400','<div class=\"rte-block\">PENNOVO® 00 bakery enhancer is positioned as a versatile solution to enhance the texture and appearance of baked goods. It claims to increase the volume of gluten-free baked goods by up to \r\n25%. This is significant in gluten-free products where achieving good \r\nvolume can be challenging. This is particularly valuable for those seeking egg alternatives, whether due to dietary preferences or allergies. PENNOVO® 00 is described as a highly soluble enzyme-treated potato \r\nstarch. This suggests that it can easily integrate into various recipes \r\nand formulations. The product comes with label claims of being non-GMO, non-allergenic, \r\nand kosher. This aligns with consumer preferences for clean and \r\ntransparent labeling. The bakery enhancer is versatile and can be used in a wide range of \r\napplications, including breads, muffins, bagels, pancakes, waffles, \r\ncookies, cakes, and gluten-free bakery products.</div>','0','pennovo-00','1','2023-11-30 11:48:49','2023-11-23 15:24:44'),(252,3,260,'THERMTEX®','06811105','THERMTEX® is derived from waxy maize, which is a type of corn with high amylopectin content. This modified food starch finds application in canned food systems. \r\nCanned foods often require specific characteristics in their ingredients\r\n to ensure optimal heat penetration and achieve the desired final \r\nviscosity. THERMTEX® is utilized in canned food systems where optimum heat \r\npenetration is crucial. This is important for ensuring that the canned \r\nfood is adequately processed and safe for consumption. The starch contributes to achieving high final viscosity in canned food \r\nproducts. Viscosity is a measure of a fluid\'s resistance to flow and is \r\nimportant for the texture and mouthfeel of the final product.','0','thermtex','1','2023-11-30 11:44:08','2023-11-23 17:11:09'),(253,3,261,'ULTRA-TEX® 2','32156101','ULTRA -TEX® 2\r\n  modified food starch is a high-performance starch that swells in \r\ncold water. This property is valuable in various food applications. The starch is derived from waxy maize, known for its high amylopectin \r\ncontent. Amylopectin affects the functional properties of starch. It\'s noted for possessing superior sheen, clarity, and smoothness when \r\ncompared to traditional pregelatinized starch dispersions. These \r\nattributes contribute to the visual and textural qualities of the final \r\nproduct. The product is available under Ingredion Incorporated’s TRUETRACE® \r\nIdentity Preserved Program, indicating that it is sourced from \r\nnon-genetically modified (non-GM) ingredients. This addresses the \r\npreference for non-GM products.','0','ultra-tex-2-1','1','2023-11-30 11:40:41','2023-11-24 09:25:05'),(254,3,261,'ULTRA-SPERSE® 5','32556100','ULTRA-SPERSE® 5\r\n  modified starch is high-performance starch that swells in cold water. This property can be advantageous in various food applications. The starch is derived from waxy maize, which is a type of corn known for its high amylopectin content. It yields a short texture in food products. In culinary terms, a \"short\"\r\n texture often implies a crumbly or tender quality, which can be \r\ndesirable in certain applications. ULTRA-SPERSE® 5 is noted for providing good sheen, clarity, and smoothness. The product is available under Ingredion Incorporated’s TRUETRACE® \r\nIdentity Preserved Program, indicating that it is sourced from \r\nnon-genetically modified (non-GM) ingredients. This aligns with the \r\npreference for non-GM products.','0','ultra-sperse-5','1','2023-11-30 11:35:26','2023-11-24 09:30:43'),(255,3,262,'NOVATION® LUMINA 300','34131A04',NULL,'30','-1','1','2023-11-24 09:39:24','2023-11-24 09:39:24'),(256,3,262,'NOVATION® Lumina 600 functional native starch','34121a03','<div class=\"rte-block\">NOVATION® Lumina 600 functional native starch is designed to meet consumer demand for clean labels. This implies the use \r\nof simple and recognizable ingredients in the formulation. It allows formulators to maintain appealing and flavorful foods and \r\nbeverages without compromising on light colors, nuanced flavors, or \r\nluxurious textures. The technical specifications for natural ingredients set by the \r\nInternational Organization for Standardization (ISO). This supports the \r\nability to make \"natural\" claims on product labels. The starch is non-GMO and gluten-free, aligning with the preferences of \r\nconsumers who seek such attributes in their food products.&nbsp; It provides modified starch functionality while being a functional native \r\nstarch. This means it offers the benefits of modified starches without \r\nbeing chemically modified and created for mild to moderate processing conditions, indicating its suitability for a range of processing environments. The starch is described as having a versatile texturizer with flavor \r\nrelease and neutral color, making it suitable for white or light-colored\r\n products undergoing harsh processing conditions.</div>','0','novation-lumina-600-functional-native-starch','1','2023-11-30 11:22:21','2023-11-24 09:45:26'),(257,3,263,'Action Gum 8200 Powder','75000022','<p>Action Gum 8200 Powder is recommended for use as Recommended for use as a heat-stable and efficient moisture-binder in \r\nbakery products. This suggests that it helps retain moisture in baked \r\ngoods, potentially contributing to increased shelf-life.This implies that it retains its functionality in acidic conditions and \r\ncan contribute to the texture and stability of various food and \r\nindustrial products. Action Gum 8200 Powder is cold water soluble, meaning it dissolves \r\nreadily in cold water. This characteristic enhances its versatility in \r\ndifferent applications where low-temperature hydration is preferred. Possesses rapid hydration characteristics, suggesting that it can quickly and efficiently absorb water or other liquids. The rapid hydration and cold water solubility make it useful in dry mix applications. This could include various food and industrial formulations where the ease of incorporating the ingredient into dry mixes is important. </p>','0','action-gum-8200-powder','1','2023-11-30 11:12:59','2023-11-24 09:53:50'),(258,3,263,'PENPLUS® MG','12110401','PenPlus® MG is a pregelatinization involves heating and drying the starch to modify its \r\nproperties. In this case, it\'s applied to unmodified potato starch. It\'s&nbsp; tailored for use in tortillas, suggesting that it addresses specific \r\nchallenges or requirements in the tortilla-making process. The starch softens the dough, which can contribute to the desired texture in the final product. Enhances the ability to roll out the dough, making it more pliable and easier to work with during the tortilla-making process.Reduces dough tackiness, improving the machinability of the dough during the manufacturing process. The starch increases moisture retention, contributing to the freshness and softness of the tortillas over an extended period.','0','penplus-mg-1','1','2023-12-11 09:27:12','2023-11-24 09:58:25'),(259,3,264,'H- 50','12175300','H -50 modified food starch is pregelatinized starch has undergone a process to break down the \r\ngranules, making it easier to disperse and thicken without the need for \r\nadditional heat.The starch is characterized by high viscosity, indicating its ability to\r\n form thick or sticky solutions. This is valuable in instant dessert \r\napplications where texture is crucial.Specifically designed for instant dessert applications, suggesting that \r\nit is tailored to meet the requirements of quick and easy preparation.The starch is noted for its superior blandness, implying that it doesn\'t\r\n introduce strong or undesirable flavors to the final product.This characteristic suggests that the starch contributes to a quick and \r\nsmooth melting sensation in the mouth, enhancing the overall eating \r\nexperience.Produced under Ingredion Incorporated’s TRUETRACE® Identity Preserved \r\nProgram, ensuring the product is sourced from non-genetically modified \r\n(non-GM) ingredients.','0','h-50','1','2023-11-30 11:00:21','2023-11-24 10:39:46'),(260,3,264,'INSTANT PURE-FLO® F','12151103','INSTANT PURE-FLO® F modified food starch is being pre-gelatinized means the starch has undergone a process to break \r\ndown the granules, making it easier to disperse and thicken without the \r\nneed for additional heat, refined from waxy corn, which is a type of corn known for its high amylopectin (a component of starch) content.This indicates that the starch can create a thick or sticky solution, \r\nwhich can be desirable in certain food applications for texture and \r\nconsistency.The starch is described as extremely smooth, suggesting it contributes to a pleasing mouthfeel in food products.The product is said to provide excellent clarity, indicating transparency in applications where this is crucial.Available under Ingredion Incorporated’s TRUETRACE® Identity Preserved \r\nProgram, ensuring the product is sourced from non-genetically modified \r\n(non-GM) ingredients. This aligns with the preference for non-GM \r\nproducts.','0','instant-pure-flo-f-1','1','2023-12-05 09:59:17','2023-11-24 11:01:48'),(261,3,265,'NOVATION® LUMINA 0100','34131A02','&nbsp;NOVATION® Lumina 0100 functional native starch, you can formulate for the labels consumers want while maintaining light colors, nuanced flavors and luxurious textures.Formulates for clean, simple labels, meeting consumer preferences for transparency.Meets technical specifications for natural ingredients from the International Organization for Standardization (ISO).&nbsp;&nbsp;&nbsp; Certified non-GMO and gluten-free.&nbsp; Does not require allergen labeling.&nbsp;&nbsp;&nbsp; Provides the functionality of modified starches.Well-suited for high or intense processing conditions.Offers shelf life, freeze/thaw stability, viscosity, and gel strength comparable to modified starches.Performs well in high or intense processing conditions, making it suitable for various applications.Suitable for yogurt, dairy desserts, dairy drinks, white sauces, dressings, soups, dips, fruit preps, and bakery fillings.Provides flavor release and neutral color, contributing to creamy, smooth textures.<br>&nbsp;&nbsp;&nbsp; <br>','0','novation-lumina-0100','1','2023-11-30 10:53:58','2023-11-24 11:11:35'),(262,3,266,'COLFLO® 67 TrueTrace® IP','06442122','COLFLO® 67\r\n  modified food starch is derived from waxy maize. It is characterized by very\r\n  good freeze/thaw stability and resistance to low temperature storage\r\n  conditions which make it particularly suited for application in frozen foods.\r\n  This product is available under Ingredion Incorporated’s TRUETRACE® Identity\r\n  Preserved Program for non-GM products .','0','colflo-67-truetrace-ip','1','2023-12-05 09:58:51','2023-11-24 11:19:07'),(263,3,266,'NOVATION® 4300','34381100','NOVATION® 4300 functional native starch is a cold water swelling (CWS) \r\nwaxy corn starch which provides the properties of premium instant \r\nstarches.Cold water swelling (CWS) waxy corn starch, indicating its ability to swell and thicken in cold water.It is designed to offer properties similar to premium instant starches, suggesting quick and efficient dispersion.Possesses superior sheen, clarity, and smoothness, contributing to the overall appearance and texture of the end product.Produced under Ingredion Incorporated’s TRUETRACE® Identity Preserved \r\nProgram for non-GM products.','0','novation-4300-1','1','2023-12-05 09:58:37','2023-11-24 11:27:17'),(264,3,267,'PENPURE® 10L','04400407','PenPure® 10L is a\r\n  low moisture native potato starch. It has a high viscosity, excellent\r\n  water-binding capacity and freeflowing characteristics. It is white in color\r\n  and bland in taste .','0','penpure-10l','1','2023-11-30 10:41:43','2023-11-24 12:00:35'),(265,3,267,'Ticaxan® Xanthan Salt Tolerant Powder','75000837',NULL,'0','ticaxan-xanthan-salt-tolerant-powder-1','1','2023-12-05 09:57:51','2023-11-24 12:12:12'),(266,3,268,'NATIONAL FRIGEX®','06820302','NATIONAL FRIGEX® modified food starch derived from tapioca, highlighting\r\n its stability under low-temperature storage conditions and its \r\nexcellent resistance to heat and acid. It\'s emphasized \r\nthat this product is produced under Ingredion Incorporated’s TRUETRACE® \r\nIdentity Preserved Program, indicating its non-genetically modified \r\n(non-GM) status.','0','national-frigex','1','2023-11-30 10:39:02','2023-11-24 12:34:17'),(267,3,268,'N-ZORBIT® M - NON-GM, IP','10903302','N-ZORBIT® M maltodextrin, which is derived from tapioca and designed \r\nwith a very low bulk density. This product is primarily used to increase\r\n the volume of dry mixes and acts as a dispersant for dry ingredients in\r\n low solids preparations. It\'s produced under Ingredion \r\nIncorporated’s TRUETRACE® Identity Preserved Program, indicating that it\r\n comes from non-genetically modified (non-GM) sources.','0','n-zorbit-m-non-gm-ip','1','2023-11-30 10:27:44','2023-11-24 12:46:19'),(268,3,270,'THERMTEX® - TRUETRACE® IP','06811102','THERMTEX® modified food starch, which is derived from waxy maize and is \r\nused in canned food systems where optimal heat penetration and high \r\nfinal viscosity are needed. Additionally, the product is available under\r\n Ingredion Incorporated’s TRUETRACE® Identity Preserved Program, \r\nindicating that it comes from non-genetically modified (non-GM) sources.','0','thermtex-truetrace-ip','1','2023-11-30 10:26:39','2023-11-24 14:20:35');

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `role_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `role_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role_slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'Admin','admin',NULL,NULL),(2,'User','user',NULL,NULL),(3,'Supplier','supplier',NULL,NULL);

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `code` varchar(50) DEFAULT NULL,
  `country_id` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4122 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `states`
--

INSERT INTO `states` VALUES (1,'Andaman and Nicobar Islands',NULL,101),(2,'Andhra Pradesh','AD',101),(3,'Arunachal Pradesh','AR',101),(4,'Assam','AS',101),(5,'Bihar','BR',101),(6,'Chandigarh','CH',101),(7,'Chhattisgarh','CG',101),(8,'Dadra and Nagar Haveli','DNH',101),(9,'Daman and Diu','DD',101),(10,'Delhi','DL',101),(11,'Goa','GA',101),(12,'Gujarat','GJ',101),(13,'Haryana','HR',101),(14,'Himachal Pradesh','HP',101),(15,'Jammu and Kashmir','JK',101),(16,'Jharkhand','JH',101),(17,'Karnataka','KA',101),(18,'Kenmore',NULL,101),(19,'Kerala','KA',101),(20,'Lakshadweep','LD',101),(21,'Madhya Pradesh','MP',101),(22,'Maharashtra','MH',101),(23,'Manipur','MN',101),(24,'Meghalaya','ML',101),(25,'Mizoram','MZ',101),(26,'Nagaland',NULL,101),(27,'Narora',NULL,101),(28,'Natwar',NULL,101),(29,'Odisha',NULL,101),(30,'Paschim Medinipur',NULL,101),(31,'Pondicherry',NULL,101),(32,'Punjab',NULL,101),(33,'Rajasthan',NULL,101),(34,'Sikkim',NULL,101),(35,'Tamil Nadu',NULL,101),(36,'Telangana',NULL,101),(37,'Tripura',NULL,101),(38,'Uttar Pradesh',NULL,101),(39,'Uttarakhand',NULL,101),(40,'Vaishali',NULL,101),(41,'West Bengal',NULL,101),(42,'Badakhshan','BDS',231),(43,'Badgis',NULL,231),(44,'Baglan','BGL',231),(45,'Balkh','BAL',231),(46,'Bamiyan','BAM',231),(47,'Farah','FRA',231),(48,'Faryab','FYB',231),(49,'Gawr',NULL,231),(50,'Gazni','GHA',231),(51,'Herat','HER',231),(52,'Helmand','HEL',231),(53,'Jawzjan','jow',231),(54,'Kabul','KAB',231),(55,'Kapisa','KAP',231),(56,'Khawst',NULL,231),(57,'Kunar','KNR',231),(58,'Lagman','LAG',231),(59,'Lawghar','LAM',231),(60,'Nangarhar','NAN',231),(61,'Nimruz','NIM',231),(62,'Nuristan','NUR',231),(63,'Paktika','PKA',231),(64,'Paktiya','PIA',231),(65,'Parwan','PAR',231),(66,'Qandahar',NULL,231),(67,'Qunduz',NULL,231),(68,'Samangan',NULL,231),(69,'Sar-e Pul',NULL,231),(70,'Takhar',NULL,231),(71,'Uruzgan',NULL,231),(72,'Wardag',NULL,231),(73,'Zabul',NULL,231),(74,'Berat',NULL,2),(75,'Bulqize',NULL,2),(76,'Delvine',NULL,2),(77,'Devoll',NULL,2),(78,'Dibre',NULL,2),(79,'Durres',NULL,2),(80,'Elbasan',NULL,2),(81,'Fier',NULL,2),(82,'Gjirokaster',NULL,2),(83,'Gramsh',NULL,2),(84,'Has',NULL,2),(85,'Kavaje',NULL,2),(86,'Kolonje',NULL,2),(87,'Korce',NULL,2),(88,'Kruje',NULL,2),(89,'Kucove',NULL,2),(90,'Kukes',NULL,2),(91,'Kurbin',NULL,2),(92,'Lezhe',NULL,2),(93,'Librazhd',NULL,2),(94,'Lushnje',NULL,2),(95,'Mallakaster',NULL,2),(96,'Malsi e Madhe',NULL,2),(97,'Mat',NULL,2),(98,'Mirdite',NULL,2),(99,'Peqin',NULL,2),(100,'Permet',NULL,2),(101,'Pogradec',NULL,2),(102,'Puke',NULL,2),(103,'Sarande',NULL,2),(104,'Shkoder',NULL,2),(105,'Skrapar',NULL,2),(106,'Tepelene',NULL,2),(107,'Tirane',NULL,2),(108,'Tropoje',NULL,2),(109,'Vlore',NULL,2),(110,'\'Ayn Daflah',NULL,3),(111,'\'Ayn Tamushanat',NULL,3),(112,'Adrar',NULL,3),(113,'Algiers',NULL,3),(114,'Annabah',NULL,3),(115,'Bashshar',NULL,3),(116,'Batnah',NULL,3),(117,'Bijayah',NULL,3),(118,'Biskrah',NULL,3),(119,'Blidah',NULL,3),(120,'Buirah',NULL,3),(121,'Bumardas',NULL,3),(122,'Burj Bu Arririj',NULL,3),(123,'Ghalizan',NULL,3),(124,'Ghardayah',NULL,3),(125,'Ilizi',NULL,3),(126,'Jijili',NULL,3),(127,'Jilfah',NULL,3),(128,'Khanshalah',NULL,3),(129,'Masilah',NULL,3),(130,'Midyah',NULL,3),(131,'Milah',NULL,3),(132,'Muaskar',NULL,3),(133,'Mustaghanam',NULL,3),(134,'Naama',NULL,3),(135,'Oran',NULL,3),(136,'Ouargla',NULL,3),(137,'Qalmah',NULL,3),(138,'Qustantinah',NULL,3),(139,'Sakikdah',NULL,3),(140,'Satif',NULL,3),(141,'Sayda\'',NULL,3),(142,'Sidi ban-al-\'Abbas',NULL,3),(143,'Suq Ahras',NULL,3),(144,'Tamanghasat',NULL,3),(145,'Tibazah',NULL,3),(146,'Tibissah',NULL,3),(147,'Tilimsan',NULL,3),(148,'Tinduf',NULL,3),(149,'Tisamsilt',NULL,3),(150,'Tiyarat',NULL,3),(151,'Tizi Wazu',NULL,3),(152,'Umm-al-Bawaghi',NULL,3),(153,'Wahran',NULL,3),(154,'Warqla',NULL,3),(155,'Wilaya d Alger',NULL,3),(156,'Wilaya de Bejaia',NULL,3),(157,'Wilaya de Constantine',NULL,3),(158,'al-Aghwat',NULL,3),(159,'al-Bayadh',NULL,3),(160,'al-Jaza\'ir',NULL,3),(161,'al-Wad',NULL,3),(162,'ash-Shalif',NULL,3),(163,'at-Tarif',NULL,3),(164,'Eastern',NULL,4),(165,'Manu\'a',NULL,4),(166,'Swains Island',NULL,4),(167,'Western',NULL,4),(168,'Andorra la Vella',NULL,5),(169,'Canillo',NULL,5),(170,'Encamp',NULL,5),(171,'La Massana',NULL,5),(172,'Les Escaldes',NULL,5),(173,'Ordino',NULL,5),(174,'Sant Julia de Loria',NULL,5),(175,'Bengo','BGO',6),(176,'Benguela','BGU',6),(177,'Bie','BIE',6),(178,'Cabinda','CAB',6),(179,'Cunene','CNN',6),(180,'Huambo','HUA',6),(181,'Huila','HUI',6),(182,'Kuando-Kubango',NULL,6),(183,'Kwanza Norte',NULL,6),(184,'Kwanza Sul',NULL,6),(185,'Luanda',NULL,6),(186,'Lunda Norte',NULL,6),(187,'Lunda Sul',NULL,6),(188,'Malanje','MAL',6),(189,'Moxico','MOX',6),(190,'Namibe','NAM',6),(191,'Uige','UIG',6),(192,'Zaire','ZAI',6),(193,'Other Provinces',NULL,7),(194,'Sector claimed by Argentina/Ch',NULL,8),(195,'Sector claimed by Argentina/UK',NULL,8),(196,'Sector claimed by Australia',NULL,8),(197,'Sector claimed by France',NULL,8),(198,'Sector claimed by New Zealand',NULL,8),(199,'Sector claimed by Norway',NULL,8),(200,'Unclaimed Sector',NULL,8),(201,'Barbuda','10',9),(202,'Saint George','03',9),(203,'Saint John','04',9),(204,'Saint Mary','05',9),(205,'Saint Paul','06',9),(206,'Saint Peter','07',9),(207,'Saint Philip','08',9),(208,'Buenos Aires','B',10),(209,'Catamarca','K',10),(210,'Chaco','H',10),(211,'Chubut','U',10),(212,'Cordoba','X',10),(213,'Corrientes','W',10),(214,'Distrito Federal',NULL,10),(215,'Entre Rios','E',10),(216,'Formosa','P',10),(217,'Jujuy','Y',10),(218,'La Pampa','L',10),(219,'La Rioja','F',10),(220,'Mendoza','M',10),(221,'Misiones','N',10),(222,'Neuquen','Q',10),(223,'Rio Negro','R',10),(224,'Salta','A',10),(225,'San Juan','J',10),(226,'San Luis','D',10),(227,'Santa Cruz','Z',10),(228,'Santa Fe','S',10),(229,'Santiago del Estero','G',10),(230,'Tierra del Fuego','V',10),(231,'Tucuman','T',10),(232,'Aragatsotn','AG',11),(233,'Ararat','AR',11),(234,'Armavir','AV',11),(235,'Gegharkunik','GR',11),(236,'Kotaik','KT',11),(237,'Lori','LO',11),(238,'Shirak',NULL,11),(239,'Stepanakert',NULL,11),(240,'Syunik',NULL,11),(241,'Tavush','TV',11),(242,'Vayots Dzor','VD',11),(243,'Yerevan',NULL,11),(244,'Aruba',NULL,12),(246,'Australian Capital Territory','CT',13),(266,'New South Wales','NS',13),(267,'Northern Territory','NT',13),(269,'Queensland','QL',13),(270,'South Australia','SA',13),(271,'Tasmania','TS',13),(273,'Victoria','VA',13),(275,'Western Australia','WA',13),(277,'Bundesland Salzburg','1',14),(278,'Bundesland Steiermark',NULL,14),(279,'Bundesland Tirol',NULL,14),(280,'Burgenland',NULL,14),(281,'Carinthia',NULL,14),(282,'Karnten','2',14),(283,'Liezen',NULL,14),(284,'Lower Austria',NULL,14),(285,'Niederosterreich','3',14),(286,'Oberosterreich','4',14),(287,'Salzburg','5',14),(288,'Schleswig-Holstein',NULL,14),(289,'Steiermark','6',14),(290,'Styria',NULL,14),(291,'Tirol','7',14),(292,'Upper Austria',NULL,14),(293,'Vorarlberg','8',14),(294,'Wien','9',14),(295,'Abseron','ABS',15),(296,'Baki Sahari','BA',15),(297,'Ganca',NULL,15),(298,'Ganja',NULL,15),(299,'Kalbacar',NULL,15),(300,'Lankaran',NULL,15),(301,'Mil-Qarabax',NULL,15),(302,'Mugan-Salyan',NULL,15),(303,'Nagorni-Qarabax',NULL,15),(304,'Naxcivan','N',15),(305,'Priaraks',NULL,15),(306,'Qazax',NULL,15),(307,'Saki','SA',15),(308,'Sirvan','SR',15),(309,'Xacmaz',NULL,15),(310,'Abaco',NULL,16),(311,'Acklins Island',NULL,16),(312,'Andros',NULL,16),(313,'Berry Islands','BY',16),(314,'Biminis','BI',16),(315,'Cat Island','CI',16),(316,'Crooked Island',NULL,16),(317,'Eleuthera',NULL,16),(318,'Exuma and Cays',NULL,16),(319,'Grand Bahama',NULL,16),(320,'Inagua Islands',NULL,16),(321,'Long Island','LI',16),(322,'Mayaguana','MG',16),(323,'New Providence','NP',16),(324,'Ragged Island','RI',16),(325,'Rum Cay','RC',16),(326,'San Salvador',NULL,16),(327,'\'Isa',NULL,17),(328,'Badiyah',NULL,17),(329,'Hidd',NULL,17),(330,'Jidd Hafs',NULL,17),(331,'Mahama',NULL,17),(332,'Manama',NULL,17),(333,'Sitrah',NULL,17),(334,'al-Manamah',NULL,17),(335,'al-Muharraq',NULL,17),(336,'ar-Rifa\'a',NULL,17),(337,'Bagar Hat','05',18),(338,'Bandarban','01',18),(339,'Barguna','02',18),(340,'Barisal','A',18),(341,'Bhola','07',18),(342,'Bogora','03',18),(343,'Brahman Bariya','04',18),(344,'Chandpur','09',18),(345,'Chattagam','B',18),(346,'Chittagong Division','10',18),(347,'Chuadanga','12',18),(348,'Dhaka','C',18),(349,'Dinajpur',NULL,18),(350,'Faridpur',NULL,18),(351,'Feni',NULL,18),(352,'Gaibanda','19',18),(353,'Gazipur','18',18),(354,'Gopalganj','17',18),(355,'Habiganj','20',18),(356,'Jaipur Hat','24',18),(357,'Jamalpur','21',18),(358,'Jessor','22',18),(359,'Jhalakati',NULL,18),(360,'Jhanaydah',NULL,18),(361,'Khagrachhari',NULL,18),(362,'Khulna',NULL,18),(363,'Kishorganj',NULL,18),(364,'Koks Bazar',NULL,18),(365,'Komilla',NULL,18),(366,'Kurigram','28',18),(367,'Kushtiya',NULL,18),(368,'Lakshmipur','31',18),(369,'Lalmanir Hat','32',18),(370,'Madaripur','36',18),(371,'Magura','37',18),(372,'Maimansingh','34',18),(373,'Manikganj',NULL,18),(374,'Maulvi Bazar',NULL,18),(375,'Meherpur',NULL,18),(376,'Munshiganj',NULL,18),(377,'Naral',NULL,18),(378,'Narayanganj',NULL,18),(379,'Narsingdi',NULL,18),(380,'Nator',NULL,18),(381,'Naugaon',NULL,18),(382,'Nawabganj',NULL,18),(383,'Netrakona','41',18),(384,'Nilphamari','46',18),(385,'Noakhali','47',18),(386,'Pabna','49',18),(387,'Panchagarh',NULL,18),(388,'Patuakhali',NULL,18),(389,'Pirojpur','50',18),(390,'Rajbari',NULL,18),(391,'Rajshahi','54',18),(392,'Rangamati','56',18),(393,'Rangpur','55',18),(394,'Satkhira','58',18),(395,'Shariatpur','62',18),(396,'Sherpur','57',18),(397,'Silhat','G',18),(398,'Sirajganj','59',18),(399,'Sunamganj','61',18),(400,'Tangayal','63',18),(401,'Thakurgaon','64',18),(402,'Christ Church','01',19),(403,'Saint Andrew','02',19),(404,'Saint George','03',19),(405,'Saint James','04',19),(406,'Saint John','05',19),(407,'Saint Joseph','06',19),(408,'Saint Lucy','07',19),(409,'Saint Michael','08',19),(410,'Saint Peter','09',19),(411,'Saint Philip','10',19),(412,'Saint Thomas','11',19),(413,'Brest','BR',20),(414,'Homjel\'',NULL,20),(415,'Hrodna','HM',20),(416,'Mahiljow',NULL,20),(417,'Mahilyowskaya Voblasts',NULL,20),(418,'Minsk','',20),(419,'Minskaja Voblasts\'','MI',20),(420,'Petrik',NULL,20),(421,'Vicebsk','VI',20),(422,'Antwerpen','VAN',21),(423,'Berchem','',21),(424,'Brabant','',21),(425,'Brabant Wallon','WBR',21),(426,'Brussel','BR',21),(427,'East Flanders',NULL,21),(428,'Hainaut','WHT',21),(429,'Liege','WLG',21),(430,'Limburg','VLI',21),(431,'Luxembourg','WLX',21),(432,'Namur','WNA',21),(433,'Ontario',NULL,21),(434,'Oost-Vlaanderen','VOV',21),(435,'Provincie Brabant',NULL,21),(436,'Vlaams-Brabant','VBR',21),(437,'Wallonne','WAL',21),(438,'West-Vlaanderen',NULL,21),(439,'Belize','VZ',22),(440,'Cayo','CY',22),(441,'Corozal','CZL',22),(442,'Orange Walk','OW',22),(443,'Stann Creek','SC',22),(444,'Toledo','TOL',22),(445,'Alibori','AL',23),(446,'Atacora','AK',23),(447,'Atlantique','AQ',23),(448,'Borgou','BO',23),(449,'Collines','CO',23),(450,'Couffo','KO',23),(451,'Donga','DO',23),(452,'Littoral','DI',23),(453,'Mono','MO',23),(454,'Oueme','OU',23),(455,'Plateau','PL',23),(456,'Zou','ZO',23),(457,'Hamilton',NULL,24),(458,'Saint George',NULL,24),(459,'Bumthang','33',25),(460,'Chhukha','12',25),(461,'Chirang',NULL,25),(462,'Dagana','22',25),(463,'Geylegphug',NULL,25),(464,'Haa','13',25),(465,'Lhuntshi','44',25),(466,'Mongar','42',25),(467,'Pemagatsel','43',25),(468,'Punakha','23',25),(469,'Rinpung',NULL,25),(470,'Samchi',NULL,25),(471,'Samdrup Jongkhar',NULL,25),(472,'Shemgang',NULL,25),(473,'Tashigang',NULL,25),(474,'Timphu','15',25),(475,'Trongsa','32',25),(476,'Wangdiphodrang','24',25),(477,'Beni','B',26),(478,'Chuquisaca','H',26),(479,'Cochabamba','C',26),(480,'La Paz','L',26),(481,'Oruro','O',26),(482,'Pando','N',26),(483,'Potosi','P',26),(484,'Santa Cruz','S',26),(485,'Tarija','T',26),(486,'Federacija Bosna i Hercegovina','BIH',27),(487,'Republika Srpska','SRP',27),(488,'Central Bobonong','CB',28),(489,'Central Boteti',NULL,28),(490,'Central Mahalapye',NULL,28),(491,'Central Serowe-Palapye',NULL,28),(492,'Central Tutume',NULL,28),(493,'Chobe','CH',28),(494,'Francistown','FR',28),(495,'Gaborone','GA',28),(496,'Ghanzi','GH',28),(497,'Jwaneng','JW',28),(498,'Kgalagadi North',NULL,28),(499,'Kgalagadi South',NULL,28),(500,'Kgatleng','KL',28),(501,'Kweneng',NULL,28),(502,'Lobatse','LO',28),(503,'Ngamiland',NULL,28),(504,'Ngwaketse',NULL,28),(505,'North East','NE',28),(506,'Okavango',NULL,28),(507,'Orapa',NULL,28),(508,'Selibe Phikwe',NULL,28),(509,'South East','SE',28),(510,'Sowa','SO',28),(511,'Bouvet Island',NULL,29),(512,'Acre','AC',30),(513,'Alagoas','AL',30),(514,'Amapa','AP',30),(515,'Amazonas','AM',30),(516,'Bahia','BA',30),(517,'Ceara','CE',30),(518,'Distrito Federal','DF',30),(519,'Espirito Santo','ES',30),(520,'Estado de Sao Paulo','',30),(521,'Goias','GO',30),(522,'Maranhao','MA',30),(523,'Mato Grosso','MT',30),(524,'Mato Grosso do Sul','MS',30),(525,'Minas Gerais','MG',30),(526,'Para','PA',30),(527,'Paraiba','PB',30),(528,'Parana','PR',30),(529,'Pernambuco','PE',30),(530,'Piaui','PI',30),(531,'Rio Grande do Norte','RN',30),(532,'Rio Grande do Sul','RS',30),(533,'Rio de Janeiro','RJ',30),(534,'Rondonia','RO',30),(535,'Roraima','RR',30),(536,'Santa Catarina','SC',30),(537,'Sao Paulo','SP',30),(538,'Sergipe','SE',30),(539,'Tocantins','TO',30),(540,'British Indian Ocean Territory',NULL,31),(541,'Belait','BE',32),(542,'Brunei-Muara','BM',32),(543,'Temburong','TE',32),(544,'Tutong','TU',32),(545,'Blagoevgrad','01',33),(546,'Burgas','02',33),(547,'Dobrich',NULL,33),(548,'Gabrovo','08',33),(549,'Haskovo','26',33),(550,'Jambol',NULL,33),(551,'Kardzhali','09',33),(552,'Kjustendil','10',33),(553,'Lovech','11',33),(554,'Montana','12',33),(555,'Oblast Sofiya-Grad',NULL,33),(556,'Pazardzhik','13',33),(557,'Pernik','14',33),(558,'Pleven','16',33),(559,'Plovdiv','16',33),(560,'Razgrad','17',33),(561,'Ruse','18',33),(562,'Shumen','27',33),(563,'Silistra','19',33),(564,'Sliven','20',33),(565,'Smoljan',NULL,33),(566,'Sofija grad',NULL,33),(567,'Sofijska oblast',NULL,33),(568,'Stara Zagora',NULL,33),(569,'Targovishte','25',33),(570,'Varna','03',33),(571,'Veliko Tarnovo',NULL,33),(572,'Vidin',NULL,33),(573,'Vraca',NULL,33),(574,'Yablaniza',NULL,33),(575,'Bale','BAL',34),(576,'Bam','BAM',34),(577,'Bazega','BAZ',34),(578,'Bougouriba','BGR',34),(579,'Boulgou','BLG',34),(580,'Boulkiemde','BLK',34),(581,'Comoe','COM',34),(582,'Ganzourgou','GAN',34),(583,'Gnagna','GNA',34),(584,'Gourma','GOU',34),(585,'Houet','HOU',34),(586,'Ioba',NULL,34),(587,'Kadiogo',NULL,34),(588,'Kenedougou',NULL,34),(589,'Komandjari',NULL,34),(590,'Kompienga','KMP',34),(591,'Kossi',NULL,34),(592,'Kouritenga','KOT',34),(593,'Kourweogo',NULL,34),(594,'Leraba','LER',34),(595,'Mouhoun','MOU',34),(596,'Nahouri','NAO',34),(597,'Namentenga',NULL,34),(598,'Noumbiel',NULL,34),(599,'Oubritenga','OUB',34),(600,'Oudalan','OUD',34),(601,'Passore','PAS',34),(602,'Poni','PON',34),(603,'Sanguie','SNG',34),(604,'Sanmatenga','SMT',34),(605,'Seno','SEN',34),(606,'Sissili','SIS',34),(607,'Soum','SOU',34),(608,'Sourou','SOR',34),(609,'Tapoa','TAP',34),(610,'Tuy','TUY',34),(611,'Yatenga','YAT',34),(612,'Zondoma','ZON',34),(613,'Zoundweogo','ZOU',34),(614,'Bubanza','BB',35),(615,'Bujumbura','BM',35),(616,'Bururi','BR',35),(617,'Cankuzo','CA',35),(618,'Cibitoke','CI',35),(619,'Gitega','GI',35),(620,'Karuzi','KR',35),(621,'Kayanza','KY',35),(622,'Kirundo','KI',35),(623,'Makamba','MA',35),(624,'Muramvya','MU',35),(625,'Muyinga','MY',35),(626,'Ngozi','NG',35),(627,'Rutana','RT',35),(628,'Ruyigi','RY',35),(629,'Banteay Mean Chey','1',36),(630,'Bat Dambang','2',36),(631,'Kampong Cham','3',36),(632,'Kampong Chhnang','4',36),(633,'Kampong Spoeu','5',36),(634,'Kampong Thum','6',36),(635,'Kampot','7',36),(636,'Kandal','8',36),(637,'Kaoh Kong','9',36),(638,'Kracheh','10',36),(639,'Krong Kaeb',NULL,36),(640,'Krong Pailin',NULL,36),(641,'Krong Preah Sihanouk',NULL,36),(642,'Mondol Kiri',NULL,36),(643,'Otdar Mean Chey',NULL,36),(644,'Phnum Penh',NULL,36),(645,'Pousat','15',36),(646,'Preah Vihear','13',36),(647,'Prey Veaeng',NULL,36),(648,'Rotanak Kiri','16',36),(649,'Siem Reab','17',36),(650,'Stueng Traeng','19',36),(651,'Svay Rieng','20',36),(652,'Takaev','21',36),(653,'Adamaoua','AD',37),(654,'Centre','CE',37),(655,'Est','ES',37),(656,'Littoral','LT',37),(657,'Nord','NO',37),(658,'Nord Extreme',NULL,37),(659,'Nordouest',NULL,37),(660,'Ouest','OU',37),(661,'Sud','SU',37),(662,'Sudouest',NULL,37),(663,'Alberta','AB',38),(664,'British Columbia','BC',38),(665,'Manitoba',NULL,38),(666,'New Brunswick','NB',38),(667,'Newfoundland and Labrador','NL',38),(668,'Northwest Territories','NT',38),(669,'Nova Scotia','NS',38),(670,'Nunavut','NU',38),(671,'Ontario','ON',38),(672,'Prince Edward Island','PE',38),(673,'Quebec','QC',38),(674,'Saskatchewan','SK',38),(675,'Yukon','YT',38),(676,'Boavista','BV',39),(677,'Brava','BR',39),(678,'Fogo',NULL,39),(679,'Maio','MA',39),(680,'Sal','SL',39),(681,'Santo Antao',NULL,39),(682,'Sao Nicolau',NULL,39),(683,'Sao Tiago',NULL,39),(684,'Sao Vicente','SV',39),(685,'Grand Cayman',NULL,40),(686,'Bamingui-Bangoran','BB',41),(687,'Bangui','BGF',41),(688,'Basse-Kotto','BK',41),(689,'Haut-Mbomou',NULL,41),(690,'Haute-Kotto','HK',41),(691,'Kemo','KM',41),(692,'Lobaye','LB',41),(693,'Mambere-Kadei',NULL,41),(694,'Mbomou',NULL,41),(695,'Nana-Gribizi',NULL,41),(696,'Nana-Mambere','NM',41),(697,'Ombella Mpoko','MP',41),(698,'Ouaka','UK',41),(699,'Ouham','AC',41),(700,'Ouham-Pende','OP',41),(701,'Sangha-Mbaere',NULL,41),(702,'Vakaga',NULL,41),(703,'Batha','BA',42),(704,'Biltine',NULL,42),(705,'Bourkou-Ennedi-Tibesti',NULL,42),(706,'Chari-Baguirmi','CB',42),(707,'Guera','GR',42),(708,'Kanem','KA',42),(709,'Lac','LC',42),(710,'Logone Occidental','LO',42),(711,'Logone Oriental','LR',42),(712,'Mayo-Kebbi','MK',42),(713,'Moyen-Chari','MC',42),(714,'Ouaddai','OD',42),(715,'Salamat','SA',42),(716,'Tandjile','TA',42),(717,'Aisen','AL',43),(718,'Antofagasta','AN',43),(719,'Araucania',NULL,43),(720,'Atacama',NULL,43),(721,'Bio Bio','BI',43),(722,'Coquimbo','CO',43),(723,'Libertador General Bernardo O\'','LI',43),(724,'Los Lagos','LL',43),(725,'Magellanes','MA',43),(726,'Maule','ML',43),(727,'Metropolitana',NULL,43),(728,'Metropolitana de Santiago',NULL,43),(729,'Tarapaca','TA',43),(730,'Valparaiso','VS',43),(731,'Anhui','AH',44),(734,'Aomen','MO',44),(735,'Beijing','BJ',44),(736,'Beijing Shi','BJ',44),(737,'Chongqing','CQ',44),(738,'Fujian','FJ',44),(740,'Gansu','GS',44),(741,'Guangdong','GS',44),(743,'Guangxi','GX',44),(744,'Guizhou','GZ',44),(745,'Hainan','HI',44),(746,'Hebei','HE',44),(747,'Heilongjiang','HL',44),(748,'Henan','HA',44),(749,'Hubei','HB',44),(750,'Hunan',NULL,44),(751,'Jiangsu','JS',44),(753,'Jiangxi',NULL,44),(754,'Jilin','JL',44),(755,'Liaoning','LN',44),(757,'Nei Monggol',NULL,44),(758,'Ningxia Hui',NULL,44),(759,'Qinghai','QH',44),(760,'Shaanxi','SX',44),(761,'Shandong','SD',44),(763,'Shanghai',NULL,44),(764,'Shanxi',NULL,44),(765,'Sichuan',NULL,44),(766,'Tianjin',NULL,44),(767,'Xianggang',NULL,44),(768,'Xinjiang',NULL,44),(769,'Xizang',NULL,44),(770,'Yunnan',NULL,44),(771,'Zhejiang',NULL,44),(773,'Christmas Island',NULL,45),(774,'Cocos (Keeling) Islands',NULL,46),(775,'Amazonas','AMA',47),(776,'Antioquia','ANT',47),(777,'Arauca','ARA',47),(778,'Atlantico','ATL',47),(779,'Bogota',NULL,47),(780,'Bolivar','BOL',47),(781,'Boyaca','BOY',47),(782,'Caldas','CAL',47),(783,'Caqueta','CAQ',47),(784,'Casanare','CAS',47),(785,'Cauca','CAU',47),(786,'Cesar','CES',47),(787,'Choco','CHO',47),(788,'Cordoba','COR',47),(789,'Cundinamarca','CUN',47),(790,'Guainia','GUA',47),(791,'Guaviare','GUV',47),(792,'Huila','HUI',47),(793,'La Guajira','LAG',47),(794,'Magdalena','MAG',47),(795,'Meta','MET',47),(796,'Narino','NAR',47),(797,'Norte de Santander','NSA',47),(798,'Putumayo','PUT',47),(799,'Quindio','QUI',47),(800,'Risaralda','RIS',47),(801,'San Andres y Providencia','SAP',47),(802,'Santander','SAN',47),(803,'Sucre','SUC',47),(804,'Tolima','TOL',47),(805,'Valle del Cauca','VAC',47),(806,'Vaupes','VAU',47),(807,'Vichada','VID',47),(808,'Mwali','M',48),(809,'Njazidja','G',48),(810,'Nzwani',NULL,48),(811,'Bouenza',NULL,49),(812,'Brazzaville',NULL,49),(813,'Cuvette',NULL,49),(814,'Kouilou',NULL,49),(815,'Lekoumou',NULL,49),(816,'Likouala',NULL,49),(817,'Niari',NULL,49),(818,'Plateaux',NULL,49),(819,'Pool',NULL,49),(820,'Sangha',NULL,49),(821,'Bandundu',NULL,50),(822,'Bas-Congo',NULL,50),(823,'Equateur','EQ',50),(824,'Haut-Congo',NULL,50),(825,'Kasai-Occidental',NULL,50),(826,'Kasai-Oriental','KE',50),(827,'Katanga',NULL,50),(828,'Kinshasa','KN',50),(829,'Maniema','MA',50),(830,'Nord-Kivu','NK',50),(831,'Sud-Kivu','SK',50),(832,'Aitutaki',NULL,51),(833,'Atiu',NULL,51),(834,'Mangaia',NULL,51),(835,'Manihiki',NULL,51),(836,'Mauke',NULL,51),(837,'Mitiaro',NULL,51),(838,'Nassau',NULL,51),(839,'Pukapuka',NULL,51),(840,'Rakahanga',NULL,51),(841,'Rarotonga',NULL,51),(842,'Tongareva',NULL,51),(843,'Alajuela',NULL,52),(844,'Cartago',NULL,52),(845,'Guanacaste',NULL,52),(846,'Heredia',NULL,52),(847,'Limon',NULL,52),(848,'Puntarenas',NULL,52),(849,'San Jose',NULL,52),(850,'Abidjan',NULL,53),(851,'Agneby',NULL,53),(852,'Bafing',NULL,53),(853,'Denguele',NULL,53),(854,'Dix-huit Montagnes',NULL,53),(855,'Fromager',NULL,53),(856,'Haut-Sassandra',NULL,53),(857,'Lacs',NULL,53),(858,'Lagunes',NULL,53),(859,'Marahoue',NULL,53),(860,'Moyen-Cavally',NULL,53),(861,'Moyen-Comoe',NULL,53),(862,'N\'zi-Comoe',NULL,53),(863,'Sassandra',NULL,53),(864,'Savanes',NULL,53),(865,'Sud-Bandama',NULL,53),(866,'Sud-Comoe',NULL,53),(867,'Vallee du Bandama',NULL,53),(868,'Worodougou',NULL,53),(869,'Zanzan',NULL,53),(870,'Bjelovar-Bilogora','07',54),(871,'Dubrovnik-Neretva','19',54),(872,'Grad Zagreb','21',54),(873,'Istra','18',54),(874,'Karlovac','04',54),(875,'Koprivnica-Krizhevci','06',54),(876,'Krapina-Zagorje','02',54),(877,'Lika-Senj','09',54),(878,'Medhimurje',NULL,54),(879,'Medimurska Zupanija','20',54),(880,'Osijek-Baranja','14',54),(881,'Osjecko-Baranjska Zupanija','11',54),(882,'Pozhega-Slavonija',NULL,54),(883,'Primorje-Gorski Kotar',NULL,54),(884,'Shibenik-Knin',NULL,54),(885,'Sisak-Moslavina',NULL,54),(886,'Slavonski Brod-Posavina',NULL,54),(887,'Split-Dalmacija',NULL,54),(888,'Varazhdin',NULL,54),(889,'Virovitica-Podravina','10',54),(890,'Vukovar-Srijem',NULL,54),(891,'Zadar','13',54),(892,'Zagreb',NULL,54),(893,'Camaguey','09',55),(894,'Ciego de Avila','08',55),(895,'Cienfuegos','06',55),(896,'Ciudad de la Habana',NULL,55),(897,'Granma',NULL,55),(898,'Guantanamo',NULL,55),(899,'Habana',NULL,55),(900,'Holguin',NULL,55),(901,'Isla de la Juventud',NULL,55),(902,'La Habana','03',55),(903,'Las Tunas',NULL,55),(904,'Matanzas','04',55),(905,'Pinar del Rio','01',55),(906,'Sancti Spiritus','07',55),(907,'Santiago de Cuba','13',55),(908,'Villa Clara','05',55),(909,'Government controlled area',NULL,56),(910,'Limassol',NULL,56),(911,'Nicosia District',NULL,56),(912,'Pafos','05',56),(913,'Turkish controlled area',NULL,56),(914,'Central Bohemian',NULL,57),(915,'Frycovice',NULL,57),(916,'Jihocesky Kraj',NULL,57),(917,'Jihochesky','31',57),(918,'Jihomoravsky',NULL,57),(919,'Karlovarsky','41',57),(920,'Klecany',NULL,57),(921,'Kralovehradecky',NULL,57),(922,'Liberecky',NULL,57),(923,'Lipov',NULL,57),(924,'Moravskoslezsky',NULL,57),(925,'Olomoucky',NULL,57),(926,'Olomoucky Kraj',NULL,57),(927,'Pardubicky',NULL,57),(928,'Plzensky',NULL,57),(929,'Praha',NULL,57),(930,'Rajhrad',NULL,57),(931,'Smirice',NULL,57),(932,'South Moravian',NULL,57),(933,'Straz nad Nisou',NULL,57),(934,'Stredochesky',NULL,57),(935,'Unicov',NULL,57),(936,'Ustecky',NULL,57),(937,'Valletta',NULL,57),(938,'Velesin',NULL,57),(939,'Vysochina',NULL,57),(940,'Zlinsky',NULL,57),(941,'Arhus',NULL,58),(942,'Bornholm',NULL,58),(943,'Frederiksborg',NULL,58),(944,'Fyn',NULL,58),(945,'Hovedstaden','84',58),(946,'Kobenhavn',NULL,58),(947,'Kobenhavns Amt',NULL,58),(948,'Kobenhavns Kommune',NULL,58),(949,'Nordjylland','81',58),(950,'Ribe',NULL,58),(951,'Ringkobing',NULL,58),(952,'Roervig',NULL,58),(953,'Roskilde',NULL,58),(954,'Roslev',NULL,58),(955,'Sjaelland','85',58),(956,'Soeborg',NULL,58),(957,'Sonderjylland',NULL,58),(958,'Storstrom',NULL,58),(959,'Syddanmark','83',58),(960,'Toelloese',NULL,58),(961,'Vejle',NULL,58),(962,'Vestsjalland',NULL,58),(963,'Viborg',NULL,58),(964,'\'Ali Sabih','AS',59),(965,'Dikhil','DI',59),(966,'Jibuti','DJ',59),(967,'Tajurah','TA',59),(968,'Ubuk','OB',59),(969,'Saint Andrew','02',60),(970,'Saint David','03',60),(971,'Saint George','04',60),(972,'Saint John','05',60),(973,'Saint Joseph','06',60),(974,'Saint Luke','07',60),(975,'Saint Mark','08',60),(976,'Saint Patrick','09',60),(977,'Saint Paul','10',60),(978,'Saint Peter','11',60),(979,'Azua','02',61),(980,'Bahoruco','03',61),(981,'Barahona','04',61),(982,'Dajabon','05',61),(983,'Distrito Nacional','01',61),(984,'Duarte','06',61),(985,'El Seybo','08',61),(986,'Elias Pina','07',61),(987,'Espaillat','09',61),(988,'Hato Mayor','30',61),(989,'Independencia','10',61),(990,'La Altagracia','11',61),(991,'La Romana','12',61),(992,'La Vega','13',61),(993,'Maria Trinidad Sanchez','14',61),(994,'Monsenor Nouel','28',61),(995,'Monte Cristi','15',61),(996,'Monte Plata',NULL,61),(997,'Pedernales','16',61),(998,'Peravia','17',61),(999,'Puerto Plata','18',61),(1000,'Salcedo',NULL,61),(1001,'Samana','20',61),(1002,'San Cristobal','21',61),(1003,'San Juan','22',61),(1004,'San Pedro de Macoris','23',61),(1005,'Sanchez Ramirez','24',61),(1006,'Santiago','25',61),(1007,'Santiago Rodriguez','26',61),(1008,'Valverde','27',61),(1009,'Aileu',NULL,62),(1010,'Ainaro',NULL,62),(1011,'Ambeno',NULL,62),(1012,'Baucau',NULL,62),(1013,'Bobonaro',NULL,62),(1014,'Cova Lima',NULL,62),(1015,'Dili',NULL,62),(1016,'Ermera',NULL,62),(1017,'Lautem',NULL,62),(1018,'Liquica',NULL,62),(1019,'Manatuto',NULL,62),(1020,'Manufahi',NULL,62),(1021,'Viqueque',NULL,62),(1022,'Azuay','A',63),(1023,'Bolivar','B',63),(1024,'Canar','F',63),(1025,'Carchi','C',63),(1026,'Chimborazo','H',63),(1027,'Cotopaxi','X',63),(1028,'El Oro','O',63),(1029,'Esmeraldas','E',63),(1030,'Galapagos','W',63),(1031,'Guayas','G',63),(1032,'Imbabura','I',63),(1033,'Loja','L',63),(1034,'Los Rios','R',63),(1035,'Manabi','M',63),(1036,'Morona Santiago','S',63),(1037,'Napo','N',63),(1038,'Orellana','D',63),(1039,'Pastaza','Y',63),(1040,'Pichincha','P',63),(1041,'Sucumbios','U',63),(1042,'Tungurahua','T',63),(1043,'Zamora Chinchipe','Z',63),(1044,'Aswan',NULL,64),(1045,'Asyut',NULL,64),(1046,'Bani Suwayf','BNS',64),(1047,'Bur Sa\'id','PTS',64),(1048,'Cairo',NULL,64),(1049,'Dumyat','DT',64),(1050,'Kafr-ash-Shaykh','KFS',64),(1051,'Matruh',NULL,64),(1052,'Muhafazat ad Daqahliyah',NULL,64),(1053,'Muhafazat al Fayyum',NULL,64),(1054,'Muhafazat al Gharbiyah',NULL,64),(1055,'Muhafazat al Iskandariyah',NULL,64),(1056,'Muhafazat al Qahirah',NULL,64),(1057,'Qina','KN',64),(1058,'Sawhaj','SHJ',64),(1059,'Sina al-Janubiyah',NULL,64),(1060,'Sina ash-Shamaliyah',NULL,64),(1061,'ad-Daqahliyah','DK',64),(1062,'al-Bahr-al-Ahmar','BA',64),(1063,'al-Buhayrah','BH',64),(1064,'al-Fayyum','FYM',64),(1065,'al-Gharbiyah','GH',64),(1066,'al-Iskandariyah','ALX',64),(1067,'al-Ismailiyah','IS',64),(1068,'al-Jizah','GZ',64),(1069,'al-Minufiyah','MNF',64),(1070,'al-Minya',NULL,64),(1071,'al-Qahira',NULL,64),(1072,'al-Qalyubiyah','KB',64),(1073,'al-Uqsur',NULL,64),(1074,'al-Wadi al-Jadid','WAD',64),(1075,'as-Suways','SUZ',64),(1076,'ash-Sharqiyah','SHR',64),(1077,'Ahuachapan','AH',65),(1078,'Cabanas','CA',65),(1079,'Chalatenango','CH',65),(1080,'Cuscatlan','CU',65),(1081,'La Libertad','LI',65),(1082,'La Paz','PA',65),(1083,'La Union','UN',65),(1084,'Morazan','MO',65),(1085,'San Miguel','SM',65),(1086,'San Salvador','SS',65),(1087,'San Vicente','SV',65),(1088,'Santa Ana','SA',65),(1089,'Sonsonate','SO',65),(1090,'Usulutan','US',65),(1091,'Annobon',NULL,66),(1092,'Bioko Norte',NULL,66),(1093,'Bioko Sur',NULL,66),(1094,'Centro Sur',NULL,66),(1095,'Kie-Ntem',NULL,66),(1096,'Litoral',NULL,66),(1097,'Wele-Nzas',NULL,66),(1098,'Anseba',NULL,67),(1099,'Debub',NULL,67),(1100,'Debub-Keih-Bahri',NULL,67),(1101,'Gash-Barka',NULL,67),(1102,'Maekel',NULL,67),(1103,'Semien-Keih-Bahri',NULL,67),(1104,'Harju',NULL,68),(1105,'Hiiu',NULL,68),(1106,'Ida-Viru',NULL,68),(1107,'Jarva',NULL,68),(1108,'Jogeva',NULL,68),(1109,'Laane',NULL,68),(1110,'Laane-Viru',NULL,68),(1111,'Parnu',NULL,68),(1112,'Polva',NULL,68),(1113,'Rapla',NULL,68),(1114,'Saare',NULL,68),(1115,'Tartu',NULL,68),(1116,'Valga',NULL,68),(1117,'Viljandi',NULL,68),(1118,'Voru',NULL,68),(1119,'Addis Abeba','AA',69),(1120,'Afar','AF',69),(1121,'Amhara','AM',69),(1122,'Benishangul',NULL,69),(1123,'Diredawa','DD',69),(1124,'Gambella','GA',69),(1125,'Harar',NULL,69),(1126,'Jigjiga',NULL,69),(1127,'Mekele',NULL,69),(1128,'Oromia','OR',69),(1129,'Somali','SO',69),(1130,'Southern','SN',69),(1131,'Tigray','TI',69),(1132,'Christmas Island',NULL,70),(1133,'Cocos Islands',NULL,70),(1134,'Coral Sea Islands',NULL,70),(1135,'Falkland Islands',NULL,71),(1136,'South Georgia',NULL,71),(1137,'Klaksvik',NULL,72),(1138,'Nor ara Eysturoy',NULL,72),(1139,'Nor oy',NULL,72),(1140,'Sandoy',NULL,72),(1141,'Streymoy',NULL,72),(1142,'Su uroy',NULL,72),(1143,'Sy ra Eysturoy',NULL,72),(1144,'Torshavn',NULL,72),(1145,'Vaga',NULL,72),(1146,'Central','C',73),(1147,'Eastern','E',73),(1148,'Northern','N',73),(1149,'South Pacific',NULL,73),(1150,'Western','W',73),(1151,'Ahvenanmaa','01',74),(1152,'Etela-Karjala','02',74),(1153,'Etela-Pohjanmaa',NULL,74),(1154,'Etela-Savo','04',74),(1155,'Etela-Suomen Laani',NULL,74),(1156,'Ita-Suomen Laani',NULL,74),(1157,'Ita-Uusimaa',NULL,74),(1158,'Kainuu','05',74),(1159,'Kanta-Hame','06',74),(1160,'Keski-Pohjanmaa',NULL,74),(1161,'Keski-Suomi',NULL,74),(1162,'Kymenlaakso',NULL,74),(1163,'Lansi-Suomen Laani',NULL,74),(1164,'Lappi',NULL,74),(1165,'Northern Savonia',NULL,74),(1166,'Ostrobothnia','12',74),(1167,'Oulun Laani',NULL,74),(1168,'Paijat-Hame',NULL,74),(1169,'Pirkanmaa','11',74),(1170,'Pohjanmaa','12',74),(1171,'Pohjois-Karjala','13',74),(1172,'Pohjois-Pohjanmaa','14',74),(1173,'Pohjois-Savo','15',74),(1174,'Saarijarvi',NULL,74),(1175,'Satakunta','17',74),(1176,'Southern Savonia',NULL,74),(1177,'Tavastia Proper',NULL,74),(1178,'Uleaborgs Lan',NULL,74),(1179,'Uusimaa',NULL,74),(1180,'Varsinais-Suomi',NULL,74),(1181,'Ain','01',75),(1182,'Aisne','02',75),(1183,'Albi Le Sequestre','03',75),(1184,'Allier',NULL,75),(1185,'Alpes-Cote dAzur','',75),(1186,'Alpes-Maritimes','06',75),(1187,'Alpes-de-Haute-Provence','04',75),(1188,'Alsace','6AE',75),(1189,'Aquitaine',NULL,75),(1190,'Ardeche','07',75),(1191,'Ardennes','08',75),(1192,'Ariege','09',75),(1193,'Aube','10',75),(1194,'Aude','11',75),(1195,'Auvergne',NULL,75),(1196,'Aveyron','12',75),(1197,'Bas-Rhin','67',75),(1198,'Basse-Normandie',NULL,75),(1199,'Bouches-du-Rhone','13',75),(1200,'Bourgogne',NULL,75),(1201,'Bretagne','BRE',75),(1202,'Brittany',NULL,75),(1203,'Burgundy',NULL,75),(1204,'Calvados','14',75),(1205,'Cantal','15',75),(1206,'Cedex',NULL,75),(1207,'Centre',NULL,75),(1208,'Charente',NULL,75),(1209,'Charente-Maritime',NULL,75),(1210,'Cher',NULL,75),(1211,'Correze','19',75),(1212,'Corse-du-Sud',NULL,75),(1213,'Cote-d\'Or','21',75),(1214,'Cotes-d\'Armor','22',75),(1215,'Creuse','23',75),(1216,'Crolles',NULL,75),(1217,'Deux-Sevres',NULL,75),(1218,'Dordogne',NULL,75),(1219,'Doubs','25',75),(1220,'Drome','26',75),(1221,'Essonne','91',75),(1222,'Eure','27',75),(1223,'Eure-et-Loir','28',75),(1224,'Feucherolles',NULL,75),(1225,'Finistere','29',75),(1226,'Franche-Comte',NULL,75),(1227,'Gard',NULL,75),(1228,'Gers','32',75),(1229,'Gironde','33',75),(1230,'Haut-Rhin','68',75),(1231,'Haute-Corse','2B',75),(1232,'Haute-Garonne','31',75),(1233,'Haute-Loire','43',75),(1234,'Haute-Marne','52',75),(1235,'Haute-Saone','70',75),(1236,'Haute-Savoie','74',75),(1237,'Haute-Vienne','87',75),(1238,'Hautes-Alpes','05',75),(1239,'Hautes-Pyrenees','65',75),(1240,'Hauts-de-Seine','92',75),(1241,'Herault','34',75),(1242,'Ile-de-France',NULL,75),(1243,'Ille-et-Vilaine',NULL,75),(1244,'Indre',NULL,75),(1245,'Indre-et-Loire',NULL,75),(1246,'Isere',NULL,75),(1247,'Jura',NULL,75),(1248,'Klagenfurt',NULL,75),(1249,'Landes',NULL,75),(1250,'Languedoc-Roussillon',NULL,75),(1251,'Larcay',NULL,75),(1252,'Le Castellet',NULL,75),(1253,'Le Creusot',NULL,75),(1254,'Limousin',NULL,75),(1255,'Loir-et-Cher',NULL,75),(1256,'Loire',NULL,75),(1257,'Loire-Atlantique',NULL,75),(1258,'Loiret',NULL,75),(1259,'Lorraine',NULL,75),(1260,'Lot',NULL,75),(1261,'Lot-et-Garonne',NULL,75),(1262,'Lower Normandy',NULL,75),(1263,'Lozere',NULL,75),(1264,'Maine-et-Loire',NULL,75),(1265,'Manche',NULL,75),(1266,'Marne',NULL,75),(1267,'Mayenne',NULL,75),(1268,'Meurthe-et-Moselle',NULL,75),(1269,'Meuse',NULL,75),(1270,'Midi-Pyrenees',NULL,75),(1271,'Morbihan',NULL,75),(1272,'Moselle',NULL,75),(1273,'Nievre',NULL,75),(1274,'Nord','59',75),(1275,'Nord-Pas-de-Calais',NULL,75),(1276,'Oise','60',75),(1277,'Orne','61',75),(1278,'Paris','75C',75),(1279,'Pas-de-Calais',NULL,75),(1280,'Pays de la Loire','PDL',75),(1281,'Pays-de-la-Loire',NULL,75),(1282,'Picardy',NULL,75),(1283,'Puy-de-Dome',NULL,75),(1284,'Pyrenees-Atlantiques',NULL,75),(1285,'Pyrenees-Orientales',NULL,75),(1286,'Quelmes',NULL,75),(1287,'Rhone',NULL,75),(1288,'Rhone-Alpes',NULL,75),(1289,'Saint Ouen',NULL,75),(1290,'Saint Viatre',NULL,75),(1291,'Saone-et-Loire',NULL,75),(1292,'Sarthe',NULL,75),(1293,'Savoie',NULL,75),(1294,'Seine-Maritime',NULL,75),(1295,'Seine-Saint-Denis',NULL,75),(1296,'Seine-et-Marne',NULL,75),(1297,'Somme',NULL,75),(1298,'Sophia Antipolis',NULL,75),(1299,'Souvans',NULL,75),(1300,'Tarn',NULL,75),(1301,'Tarn-et-Garonne',NULL,75),(1302,'Territoire de Belfort',NULL,75),(1303,'Treignac',NULL,75),(1304,'Upper Normandy',NULL,75),(1305,'Val-d\'Oise',NULL,75),(1306,'Val-de-Marne',NULL,75),(1307,'Var',NULL,75),(1308,'Vaucluse',NULL,75),(1309,'Vellise',NULL,75),(1310,'Vendee',NULL,75),(1311,'Vienne',NULL,75),(1312,'Vosges',NULL,75),(1313,'Yonne',NULL,75),(1314,'Yvelines',NULL,75),(1315,'Cayenne',NULL,76),(1316,'Saint-Laurent-du-Maroni',NULL,76),(1317,'Iles du Vent',NULL,77),(1318,'Iles sous le Vent',NULL,77),(1319,'Marquesas',NULL,77),(1320,'Tuamotu',NULL,77),(1321,'Tubuai',NULL,77),(1322,'Amsterdam',NULL,78),(1323,'Crozet Islands',NULL,78),(1324,'Kerguelen',NULL,78),(1325,'Estuaire','1',79),(1326,'Haut-Ogooue','2',79),(1327,'Moyen-Ogooue','3',79),(1328,'Ngounie','4',79),(1329,'Nyanga','5',79),(1330,'Ogooue-Ivindo','6',79),(1331,'Ogooue-Lolo','7',79),(1332,'Ogooue-Maritime','8',79),(1333,'Woleu-Ntem','9',79),(1334,'Banjul','B',80),(1335,'Basse','M',80),(1336,'Brikama',NULL,80),(1337,'Janjanbureh',NULL,80),(1338,'Kanifing',NULL,80),(1339,'Kerewan',NULL,80),(1340,'Kuntaur',NULL,80),(1341,'Mansakonko',NULL,80),(1342,'Abhasia',NULL,81),(1343,'Ajaria',NULL,81),(1344,'Guria','GU',81),(1345,'Imereti','IM',81),(1346,'Kaheti','KA',81),(1347,'Kvemo Kartli','KK',81),(1348,'Mcheta-Mtianeti','MM',81),(1349,'Racha',NULL,81),(1350,'Samagrelo-Zemo Svaneti','SZ',81),(1351,'Samche-Zhavaheti',NULL,81),(1352,'Shida Kartli','SK',81),(1353,'Tbilisi','TB',81),(1354,'Auvergne',NULL,82),(1355,'Baden-Wurttemberg','BW',82),(1356,'Bavaria',NULL,82),(1357,'Bayern','BY',82),(1358,'Beilstein Wurtt',NULL,82),(1359,'Berlin','BE',82),(1360,'Brandenburg','BB',82),(1361,'Bremen','HB',82),(1362,'Dreisbach',NULL,82),(1363,'Freistaat Bayern',NULL,82),(1364,'Hamburg','HH',82),(1365,'Hannover',NULL,82),(1366,'Heroldstatt',NULL,82),(1367,'Hesse','HE',82),(1368,'Kortenberg',NULL,82),(1369,'Laasdorf',NULL,82),(1370,'Land Baden-Wurttemberg',NULL,82),(1371,'Land Bayern',NULL,82),(1372,'Land Brandenburg',NULL,82),(1373,'Land Hessen',NULL,82),(1374,'Land Mecklenburg-Vorpommern',NULL,82),(1375,'Land Nordrhein-Westfalen',NULL,82),(1376,'Land Rheinland-Pfalz',NULL,82),(1377,'Land Sachsen',NULL,82),(1378,'Land Sachsen-Anhalt',NULL,82),(1379,'Land Thuringen',NULL,82),(1380,'Lower Saxony','NI',82),(1381,'Mecklenburg-Vorpommern','MV',82),(1382,'Mulfingen',NULL,82),(1383,'Munich',NULL,82),(1384,'Neubeuern',NULL,82),(1385,'Niedersachsen',NULL,82),(1386,'Noord-Holland',NULL,82),(1387,'Nordrhein-Westfalen',NULL,82),(1388,'North Rhine-Westphalia','NW',82),(1389,'Osterode',NULL,82),(1390,'Rheinland-Pfalz',NULL,82),(1391,'Rhineland-Palatinate','RP',82),(1392,'Saarland','SL',82),(1393,'Sachsen',NULL,82),(1394,'Saxony-Anhalt ','ST',82),(1395,'Saxony','SN',82),(1396,'Schleswig-Holstein','SH',82),(1397,'Thuringia','TH',82),(1398,'Webling',NULL,82),(1399,'Weinstrabe',NULL,82),(1400,'schlobborn',NULL,82),(1401,'Ashanti','AH',83),(1402,'Brong-Ahafo',NULL,83),(1403,'Central','CP',83),(1404,'Eastern','EP',83),(1405,'Greater Accra','AA',83),(1406,'Northern','NP',83),(1407,'Upper East','UE',83),(1408,'Upper West','UW',83),(1409,'Volta','TV',83),(1410,'Western','WP',83),(1411,'Gibraltar',NULL,84),(1412,'Acharnes',NULL,85),(1413,'Ahaia',NULL,85),(1414,'Aitolia kai Akarnania',NULL,85),(1415,'Argolis',NULL,85),(1416,'Arkadia',NULL,85),(1417,'Arta',NULL,85),(1418,'Attica',NULL,85),(1419,'Attiki','I',85),(1420,'Ayion Oros',NULL,85),(1421,'Crete',NULL,85),(1422,'Dodekanisos',NULL,85),(1423,'Drama',NULL,85),(1424,'Evia',NULL,85),(1425,'Evritania',NULL,85),(1426,'Evros',NULL,85),(1427,'Evvoia',NULL,85),(1428,'Florina',NULL,85),(1429,'Fokis',NULL,85),(1430,'Fthiotis',NULL,85),(1431,'Grevena',NULL,85),(1432,'Halandri',NULL,85),(1433,'Halkidiki',NULL,85),(1434,'Hania',NULL,85),(1435,'Heraklion',NULL,85),(1436,'Hios',NULL,85),(1437,'Ilia',NULL,85),(1438,'Imathia',NULL,85),(1439,'Ioannina',NULL,85),(1440,'Iraklion',NULL,85),(1441,'Karditsa',NULL,85),(1442,'Kastoria',NULL,85),(1443,'Kavala',NULL,85),(1444,'Kefallinia',NULL,85),(1445,'Kerkira',NULL,85),(1446,'Kiklades',NULL,85),(1447,'Kilkis',NULL,85),(1448,'Korinthia',NULL,85),(1449,'Kozani',NULL,85),(1450,'Lakonia',NULL,85),(1451,'Larisa',NULL,85),(1452,'Lasithi',NULL,85),(1453,'Lesvos',NULL,85),(1454,'Levkas',NULL,85),(1455,'Magnisia',NULL,85),(1456,'Messinia',NULL,85),(1457,'Nomos Attikis',NULL,85),(1458,'Nomos Zakynthou',NULL,85),(1459,'Pella',NULL,85),(1460,'Pieria',NULL,85),(1461,'Piraios',NULL,85),(1462,'Preveza',NULL,85),(1463,'Rethimni',NULL,85),(1464,'Rodopi',NULL,85),(1465,'Samos',NULL,85),(1466,'Serrai',NULL,85),(1467,'Thesprotia',NULL,85),(1468,'Thessaloniki',NULL,85),(1469,'Trikala',NULL,85),(1470,'Voiotia',NULL,85),(1471,'West Greece',NULL,85),(1472,'Xanthi',NULL,85),(1473,'Zakinthos',NULL,85),(1474,'Aasiaat',NULL,86),(1475,'Ammassalik',NULL,86),(1476,'Illoqqortoormiut',NULL,86),(1477,'Ilulissat',NULL,86),(1478,'Ivittuut',NULL,86),(1479,'Kangaatsiaq',NULL,86),(1480,'Maniitsoq',NULL,86),(1481,'Nanortalik',NULL,86),(1482,'Narsaq',NULL,86),(1483,'Nuuk',NULL,86),(1484,'Paamiut',NULL,86),(1485,'Qaanaaq',NULL,86),(1486,'Qaqortoq',NULL,86),(1487,'Qasigiannguit',NULL,86),(1488,'Qeqertarsuaq',NULL,86),(1489,'Sisimiut',NULL,86),(1490,'Udenfor kommunal inddeling',NULL,86),(1491,'Upernavik',NULL,86),(1492,'Uummannaq',NULL,86),(1493,'Carriacou-Petite Martinique',NULL,87),(1494,'Saint Andrew','01',87),(1495,'Saint Davids','02',87),(1496,'Saint George\'s','03',87),(1497,'Saint John','04',87),(1498,'Saint Mark','05',87),(1499,'Saint Patrick','06',87),(1500,'Basse-Terre',NULL,88),(1501,'Grande-Terre',NULL,88),(1502,'Iles des Saintes',NULL,88),(1503,'La Desirade',NULL,88),(1504,'Marie-Galante',NULL,88),(1505,'Saint Barthelemy',NULL,88),(1506,'Saint Martin',NULL,88),(1507,'Agana Heights',NULL,89),(1508,'Agat',NULL,89),(1509,'Barrigada',NULL,89),(1510,'Chalan-Pago-Ordot',NULL,89),(1511,'Dededo',NULL,89),(1512,'Hagatna',NULL,89),(1513,'Inarajan',NULL,89),(1514,'Mangilao',NULL,89),(1515,'Merizo',NULL,89),(1516,'Mongmong-Toto-Maite',NULL,89),(1517,'Santa Rita',NULL,89),(1518,'Sinajana',NULL,89),(1519,'Talofofo',NULL,89),(1520,'Tamuning',NULL,89),(1521,'Yigo',NULL,89),(1522,'Yona',NULL,89),(1523,'Alta Verapaz','16',90),(1524,'Baja Verapaz','15',90),(1525,'Chimaltenango','04',90),(1526,'Chiquimula','20',90),(1527,'El Progreso','02',90),(1528,'Escuintla','05',90),(1529,'Guatemala','01',90),(1530,'Huehuetenango','13',90),(1531,'Izabal','18',90),(1532,'Jalapa','21',90),(1533,'Jutiapa','22',90),(1534,'Peten','17',90),(1535,'Quezaltenango','09',90),(1536,'Quiche','14',90),(1537,'Retalhuleu','11',90),(1538,'Sacatepequez','03',90),(1539,'San Marcos','12',90),(1540,'Santa Rosa','06',90),(1541,'Solola','07',90),(1542,'Suchitepequez','10',90),(1543,'Totonicapan','08',90),(1544,'Zacapa','19',90),(1545,'Alderney',NULL,91),(1546,'Castel',NULL,91),(1547,'Forest',NULL,91),(1548,'Saint Andrew',NULL,91),(1549,'Saint Martin',NULL,91),(1550,'Saint Peter Port',NULL,91),(1551,'Saint Pierre du Bois',NULL,91),(1552,'Saint Sampson',NULL,91),(1553,'Saint Saviour',NULL,91),(1554,'Sark',NULL,91),(1555,'Torteval',NULL,91),(1556,'Vale',NULL,91),(1557,'Beyla','BE',92),(1558,'Boffa','BF',92),(1559,'Boke','B',92),(1560,'Conakry','C',92),(1561,'Coyah','CO',92),(1562,'Dabola','DB',92),(1563,'Dalaba','DL',92),(1564,'Dinguiraye','DI',92),(1565,'Faranah','F',92),(1566,'Forecariah','FO',92),(1567,'Fria','FR',92),(1568,'Gaoual','GA',92),(1569,'Gueckedou','GU',92),(1570,'Kankan','K',92),(1571,'Kerouane','KE',92),(1572,'Kindia','KD',92),(1573,'Kissidougou',NULL,92),(1574,'Koubia','KB',92),(1575,'Koundara','KN',92),(1576,'Kouroussa','KO',92),(1577,'Labe','LA',92),(1578,'Lola','LO',92),(1579,'Macenta','MC',92),(1580,'Mali','ML',92),(1581,'Mamou','MM',92),(1582,'Mandiana','MD',92),(1583,'Nzerekore','NZ',92),(1584,'Pita','PI',92),(1585,'Siguiri','SI',92),(1586,'Telimele','TE',92),(1587,'Tougue','TO',92),(1588,'Yomou','YO',92),(1589,'Bafata',NULL,93),(1590,'Bissau',NULL,93),(1591,'Bolama',NULL,93),(1592,'Cacheu',NULL,93),(1593,'Gabu',NULL,93),(1594,'Oio',NULL,93),(1595,'Quinara',NULL,93),(1596,'Tombali',NULL,93),(1597,'Barima-Waini','BA',94),(1598,'Cuyuni-Mazaruni','CU',94),(1599,'Demerara-Mahaica','DE',94),(1600,'East Berbice-Corentyne','EB',94),(1601,'Essequibo Islands-West Demerar','ES',94),(1602,'Mahaica-Berbice','MA',94),(1603,'Pomeroon-Supenaam','PM',94),(1604,'Potaro-Siparuni','PT',94),(1605,'Upper Demerara-Berbice','UD',94),(1606,'Upper Takutu-Upper Essequibo','UT',94),(1607,'Artibonite','AR',95),(1608,'Centre','CE',95),(1609,'Grand\'Anse','GA',95),(1610,'Nord','ND',95),(1611,'Nord-Est','NE',95),(1612,'Nord-Ouest','NO',95),(1613,'Ouest','OU',95),(1614,'Sud','SD',95),(1615,'Sud-Est','SE',95),(1616,'Heard and McDonald Islands',NULL,96),(1617,'Atlantida','AT',97),(1618,'Choluteca','CH',97),(1619,'Colon','CL',97),(1620,'Comayagua',NULL,97),(1621,'Copan','CP',97),(1622,'Cortes','CR',97),(1623,'Distrito Central',NULL,97),(1624,'El Paraiso','EP',97),(1625,'Francisco Morazan','FM',97),(1626,'Gracias a Dios','GD',97),(1627,'Intibuca','IN',97),(1628,'Islas de la Bahia','IB',97),(1629,'La Paz','LP',97),(1630,'Lempira','LE',97),(1631,'Ocotepeque','OC',97),(1632,'Olancho','OL',97),(1633,'Santa Barbara','SB',97),(1634,'Valle','VA',97),(1635,'Yoro','YO',97),(1636,'Hong Kong',NULL,98),(1637,'Bacs-Kiskun','BK',99),(1638,'Baranya','BA',99),(1639,'Bekes','BE',99),(1640,'Borsod-Abauj-Zemplen','BZ',99),(1641,'Budapest','BU',99),(1642,'Csongrad','CS',99),(1643,'Fejer','FE',99),(1644,'Gyor-Moson-Sopron','GS',99),(1645,'Hajdu-Bihar','HB',99),(1646,'Heves','HE',99),(1647,'Jasz-Nagykun-Szolnok','JN',99),(1648,'Komarom-Esztergom','KE',99),(1649,'Nograd','NO',99),(1650,'Pest','PE',99),(1651,'Somogy','SO',99),(1652,'Szabolcs-Szatmar-Bereg','SZ',99),(1653,'Tolna','TO',99),(1654,'Vas','VA',99),(1655,'Veszprem','VM',99),(1656,'Zala','ZA',99),(1657,'Austurland','7',100),(1658,'Gullbringusysla',NULL,100),(1659,'Hofu borgarsva i','1',100),(1660,'Nor urland eystra','6',100),(1661,'Nor urland vestra','5',100),(1662,'Su urland','8',100),(1663,'Su urnes','2',100),(1664,'Vestfir ir','4',100),(1665,'Vesturland','3',100),(1666,'Aceh','AC',102),(1667,'Bali','BA',102),(1668,'Bangka-Belitung',NULL,102),(1669,'Banten','BT',102),(1670,'Bengkulu','BE',102),(1671,'Gandaria',NULL,102),(1672,'Gorontalo','GO',102),(1673,'Jakarta','JK',102),(1674,'Jambi','JA',102),(1675,'Jawa Barat','JB',102),(1676,'Jawa Tengah','JT',102),(1677,'Jawa Timur','JI',102),(1678,'Kalimantan Barat','KB',102),(1679,'Kalimantan Selatan','KS',102),(1680,'Kalimantan Tengah','KT',102),(1681,'Kalimantan Timur','KI',102),(1682,'Kendal',NULL,102),(1683,'Lampung',NULL,102),(1684,'Maluku','MA',102),(1685,'Maluku Utara','MU',102),(1686,'Nusa Tenggara Barat','NB',102),(1687,'Nusa Tenggara Timur','NT',102),(1688,'Papua','PP',102),(1689,'Riau','RI',102),(1690,'Riau Kepulauan',NULL,102),(1691,'Solo',NULL,102),(1692,'Sulawesi Selatan','SN',102),(1693,'Sulawesi Tengah','ST',102),(1694,'Sulawesi Tenggara','SG',102),(1695,'Sulawesi Utara','SA',102),(1696,'Sumatera Barat','SB',102),(1697,'Sumatera Selatan','SS',102),(1698,'Sumatera Utara','SU',102),(1699,'Yogyakarta','YO',102),(1700,'Ardabil','24',103),(1701,'Azarbayjan-e Bakhtari','18',103),(1702,'Azarbayjan-e Khavari',NULL,103),(1703,'Bushehr',NULL,103),(1704,'Chahar Mahal-e Bakhtiari',NULL,103),(1705,'Esfahan','10',103),(1706,'Fars','07',103),(1707,'Gilan','01',103),(1708,'Golestan','27',103),(1709,'Hamadan','13',103),(1710,'Hormozgan','22',103),(1711,'Ilam','16',103),(1712,'Kerman','08',103),(1713,'Kermanshah','05',103),(1714,'Khorasan',NULL,103),(1715,'Khuzestan','06',103),(1716,'Kohgiluyeh-e Boyerahmad',NULL,103),(1717,'Kordestan','12',103),(1718,'Lorestan','15',103),(1719,'Markazi','00',103),(1720,'Mazandaran','02',103),(1721,'Ostan-e Esfahan',NULL,103),(1722,'Qazvin',NULL,103),(1723,'Qom','25',103),(1724,'Semnan','20',103),(1725,'Sistan-e Baluchestan',NULL,103),(1726,'Tehran',NULL,103),(1727,'Yazd',NULL,103),(1728,'Zanjan',NULL,103),(1729,'Babil','BB',104),(1730,'Baghdad','BG',104),(1731,'Dahuk','DH',104),(1732,'Dhi Qar','DQ',104),(1733,'Diyala','DI',104),(1734,'Erbil',NULL,104),(1735,'Irbil',NULL,104),(1736,'Karbala','NULL',104),(1737,'Kurdistan','KR',104),(1738,'Maysan','MA',104),(1739,'Ninawa','NI',104),(1740,'Salah-ad-Din','SD',104),(1741,'Wasit','WA',104),(1742,'al-Anbar',NULL,104),(1743,'al-Basrah',NULL,104),(1744,'al-Muthanna',NULL,104),(1745,'al-Qadisiyah',NULL,104),(1746,'an-Najaf',NULL,104),(1747,'as-Sulaymaniyah',NULL,104),(1748,'at-Ta\'mim',NULL,104),(1749,'Armagh',NULL,105),(1750,'Carlow','CW',105),(1751,'Cavan','CN',105),(1752,'Clare','CE',105),(1753,'Cork','CO',105),(1754,'Donegal','DL',105),(1755,'Dublin','D',105),(1756,'Galway','G',105),(1757,'Kerry','KY',105),(1758,'Kildare','KE',105),(1759,'Kilkenny','KK',105),(1760,'Laois','LS',105),(1761,'Leinster','L',105),(1762,'Leitrim','LM',105),(1763,'Limerick','LK',105),(1764,'Loch Garman','WX',105),(1765,'Longford','LD',105),(1766,'Louth','LH',105),(1767,'Mayo','MO',105),(1768,'Meath','MH',105),(1769,'Monaghan','MN',105),(1770,'Offaly','OY',105),(1771,'Roscommon',NULL,105),(1772,'Sligo','SO',105),(1773,'Tipperary North Riding','TA',105),(1774,'Tipperary South Riding',NULL,105),(1775,'Ulster','U',105),(1776,'Waterford','WD',105),(1777,'Westmeath','WH',105),(1778,'Wexford','WX',105),(1779,'Wicklow','WW',105),(1780,'Beit Hanania',NULL,106),(1781,'Ben Gurion Airport',NULL,106),(1782,'Bethlehem',NULL,106),(1783,'Caesarea',NULL,106),(1784,'Centre',NULL,106),(1785,'Gaza',NULL,106),(1786,'Hadaron',NULL,106),(1787,'Haifa District','HA',106),(1788,'Hamerkaz',NULL,106),(1789,'Hazafon',NULL,106),(1790,'Hebron',NULL,106),(1791,'Jaffa',NULL,106),(1792,'Jerusalem',NULL,106),(1793,'Khefa',NULL,106),(1794,'Kiryat Yam',NULL,106),(1795,'Lower Galilee',NULL,106),(1796,'Qalqilya',NULL,106),(1797,'Talme Elazar',NULL,106),(1798,'Tel Aviv','TA',106),(1799,'Tsafon',NULL,106),(1800,'Umm El Fahem',NULL,106),(1801,'Yerushalayim',NULL,106),(1802,'Abruzzi',NULL,107),(1803,'Abruzzo','65',107),(1804,'Agrigento','AG',107),(1805,'Alessandria','AL',107),(1806,'Ancona','AN',107),(1807,'Arezzo','AR',107),(1808,'Ascoli Piceno','AP',107),(1809,'Asti','AT',107),(1810,'Avellino','AV',107),(1811,'Bari','BA',107),(1812,'Basilicata','77',107),(1813,'Belluno','BL',107),(1814,'Benevento','BN',107),(1815,'Bergamo','BG',107),(1816,'Biella','BI',107),(1817,'Bologna','BO',107),(1818,'Bolzano','BZ',107),(1819,'Brescia','BS',107),(1820,'Brindisi','BR',107),(1821,'Calabria','78',107),(1822,'Campania','72',107),(1823,'Cartoceto',NULL,107),(1824,'Caserta','CE',107),(1825,'Catania','CT',107),(1826,'Chieti','CH',107),(1827,'Como','CO',107),(1828,'Cosenza',NULL,107),(1829,'Cremona',NULL,107),(1830,'Cuneo','CN',107),(1831,'Emilia-Romagna',NULL,107),(1832,'Ferrara',NULL,107),(1833,'Firenze',NULL,107),(1834,'Florence',NULL,107),(1835,'Forli-Cesena ','FC',107),(1836,'Friuli-Venezia Giulia','36',107),(1837,'Frosinone','FR',107),(1838,'Genoa','GE',107),(1839,'Gorizia','GO',107),(1840,'L\'Aquila','AQ',107),(1841,'Lazio','62',107),(1842,'Lecce','LE',107),(1843,'Lecco','LC',107),(1845,'Liguria','LI',107),(1846,'Lodi','LO',107),(1847,'Lombardia',NULL,107),(1848,'Lombardy',NULL,107),(1849,'Macerata',NULL,107),(1850,'Mantova',NULL,107),(1851,'Marche',NULL,107),(1852,'Messina',NULL,107),(1853,'Milan',NULL,107),(1854,'Modena',NULL,107),(1855,'Molise',NULL,107),(1856,'Molteno','MN',107),(1857,'Montenegro','MT',107),(1858,'Monza and Brianza','MB',107),(1859,'Naples','NA',107),(1860,'Novara','NO',107),(1861,'Padova','PD',107),(1862,'Parma','PR',107),(1863,'Pavia','PV',107),(1864,'Perugia','PG',107),(1865,'Pesaro-Urbino','PU',107),(1866,'Piacenza','PA',107),(1867,'Piedmont','21',107),(1868,'Piemonte','PN',107),(1869,'Pisa',NULL,107),(1870,'Pordenone','PN',107),(1871,'Potenza','PZ',107),(1872,'Puglia','75',107),(1873,'Reggio Emilia','RE',107),(1874,'Rimini','RN',107),(1875,'Roma','RM',107),(1876,'Salerno','SA',107),(1877,'Sardegna',NULL,107),(1878,'Sassari','SS',107),(1879,'Savona','SV',107),(1880,'Sicilia','82',107),(1881,'Siena','SI',107),(1882,'Sondrio','SO',107),(1883,'South Tyrol',NULL,107),(1884,'Taranto','TA',107),(1885,'Teramo','TE',107),(1886,'Torino','TO',107),(1887,'Toscana','52',107),(1888,'Trapani','TP',107),(1889,'Trentino-Alto Adige','32',107),(1890,'Trento','TN',107),(1891,'Treviso','TV',107),(1892,'Udine','UD',107),(1893,'Umbria','55',107),(1894,'Valle d\'Aosta','23',107),(1895,'Varese','VA',107),(1896,'Veneto','34',107),(1897,'Venezia','VE',107),(1898,'Verbano-Cusio-Ossola','VB',107),(1899,'Vercelli','VC',107),(1900,'Verona','VR',107),(1901,'Vicenza','VI',107),(1902,'Viterbo','VT',107),(1903,'Buxoro Viloyati',NULL,108),(1904,'Clarendon','13',108),(1905,'Hanover','09',108),(1906,'Kingston','01',108),(1907,'Manchester','12',108),(1908,'Portland','04',108),(1909,'Saint Andrews','02',108),(1910,'Saint Ann','06',108),(1911,'Saint Catherine','14',108),(1912,'Saint Elizabeth','11',108),(1913,'Saint James','08',108),(1914,'Saint Mary','05',108),(1915,'Saint Thomas','03',108),(1916,'Trelawney','07',108),(1917,'Westmoreland','10',108),(1918,'Aichi',NULL,109),(1919,'Akita','O1',109),(1920,'Aomori','O2',109),(1921,'Chiba','O3',109),(1922,'Ehime','O4',109),(1923,'Fukui','05',109),(1924,'Fukuoka','06',109),(1925,'Fukushima','07',109),(1926,'Gifu','08',109),(1927,'Gunma','O9',109),(1928,'Hiroshima','OA',109),(1929,'Hokkaido','OB',109),(1930,'Hyogo','OC',109),(1931,'Ibaraki','OD',109),(1932,'Ishikawa','OF',109),(1933,'Iwate','OG',109),(1934,'Kagawa','OI',109),(1935,'Kagoshima','OJ',109),(1936,'Kanagawa','OL',109),(1937,'Kanto',NULL,109),(1938,'Kochi','OM',109),(1939,'Kumamoto',NULL,109),(1940,'Kyoto','OP',109),(1941,'Mie','OQ',109),(1942,'Miyagi','OS',109),(1943,'Miyazaki',NULL,109),(1944,'Nagano',NULL,109),(1945,'Nagasaki',NULL,109),(1946,'Nara',NULL,109),(1947,'Niigata',NULL,109),(1948,'Oita',NULL,109),(1949,'Okayama',NULL,109),(1950,'Okinawa',NULL,109),(1951,'Osaka',NULL,109),(1952,'Saga',NULL,109),(1953,'Saitama',NULL,109),(1954,'Shiga',NULL,109),(1955,'Shimane',NULL,109),(1956,'Shizuoka',NULL,109),(1957,'Tochigi',NULL,109),(1958,'Tokushima',NULL,109),(1959,'Tokyo',NULL,109),(1960,'Tottori',NULL,109),(1961,'Toyama',NULL,109),(1962,'Wakayama',NULL,109),(1963,'Yamagata',NULL,109),(1964,'Yamaguchi',NULL,109),(1965,'Yamanashi',NULL,109),(1966,'Grouville',NULL,110),(1967,'Saint Brelade',NULL,110),(1968,'Saint Clement',NULL,110),(1969,'Saint Helier',NULL,110),(1970,'Saint John',NULL,110),(1971,'Saint Lawrence',NULL,110),(1972,'Saint Martin',NULL,110),(1973,'Saint Mary',NULL,110),(1974,'Saint Peter',NULL,110),(1975,'Saint Saviour',NULL,110),(1976,'Trinity',NULL,110),(1977,'\'Ajlun','AJ',111),(1978,'Amman',NULL,111),(1979,'Irbid','IR',111),(1980,'Jarash','JA',111),(1981,'Ma\'an','MN',111),(1982,'Madaba','MD',111),(1983,'al-\'Aqabah','AQ',111),(1984,'al-Balqa\'','BA',111),(1985,'al-Karak','KA',111),(1986,'al-Mafraq','MA',111),(1987,'at-Tafilah','AT',111),(1988,'az-Zarqa\'','AZ',111),(1989,'Akmecet',NULL,112),(1990,'Akmola',NULL,112),(1991,'Aktobe',NULL,112),(1992,'Almati',NULL,112),(1993,'Atirau',NULL,112),(1994,'Batis Kazakstan',NULL,112),(1995,'Burlinsky Region',NULL,112),(1996,'Karagandi',NULL,112),(1997,'Kostanay',NULL,112),(1998,'Mankistau',NULL,112),(1999,'Ontustik Kazakstan',NULL,112),(2000,'Pavlodar',NULL,112),(2001,'Sigis Kazakstan',NULL,112),(2002,'Soltustik Kazakstan',NULL,112),(2003,'Taraz',NULL,112),(2004,'Central',NULL,113),(2005,'Coast',NULL,113),(2006,'Eastern',NULL,113),(2007,'Nairobi','30',113),(2008,'North Eastern',NULL,113),(2009,'Nyanza',NULL,113),(2010,'Rift Valley',NULL,113),(2011,'Western',NULL,113),(2012,'Abaiang',NULL,114),(2013,'Abemana',NULL,114),(2014,'Aranuka',NULL,114),(2015,'Arorae',NULL,114),(2016,'Banaba',NULL,114),(2017,'Beru',NULL,114),(2018,'Butaritari',NULL,114),(2019,'Kiritimati',NULL,114),(2020,'Kuria',NULL,114),(2021,'Maiana',NULL,114),(2022,'Makin',NULL,114),(2023,'Marakei',NULL,114),(2024,'Nikunau',NULL,114),(2025,'Nonouti',NULL,114),(2026,'Onotoa',NULL,114),(2027,'Phoenix Islands',NULL,114),(2028,'Tabiteuea North',NULL,114),(2029,'Tabiteuea South',NULL,114),(2030,'Tabuaeran',NULL,114),(2031,'Tamana',NULL,114),(2032,'Tarawa North',NULL,114),(2033,'Tarawa South',NULL,114),(2034,'Teraina',NULL,114),(2035,'Chagangdo',NULL,115),(2036,'Hamgyeongbukto',NULL,115),(2037,'Hamgyeongnamdo',NULL,115),(2038,'Hwanghaebukto',NULL,115),(2039,'Hwanghaenamdo',NULL,115),(2040,'Kaeseong',NULL,115),(2041,'Kangweon',NULL,115),(2042,'Nampo',NULL,115),(2043,'Pyeonganbukto',NULL,115),(2044,'Pyeongannamdo',NULL,115),(2045,'Pyeongyang',NULL,115),(2046,'Yanggang',NULL,115),(2047,'Busan','26',116),(2048,'Cheju',NULL,116),(2049,'Chollabuk',NULL,116),(2050,'Chollanam',NULL,116),(2051,'Chungbuk',NULL,116),(2052,'Chungcheongbuk',NULL,116),(2053,'Chungcheongnam',NULL,116),(2054,'Chungnam',NULL,116),(2055,'Daegu','27',116),(2056,'Gangwon-do','42',116),(2057,'Goyang-si',NULL,116),(2058,'Gyeonggi-do',NULL,116),(2059,'Gyeongsang ',NULL,116),(2060,'Gyeongsangnam-do',NULL,116),(2061,'Incheon',NULL,116),(2062,'Jeju-Si','49',116),(2063,'Jeonbuk',NULL,116),(2064,'Kangweon',NULL,116),(2065,'Kwangju',NULL,116),(2066,'Kyeonggi',NULL,116),(2067,'Kyeongsangbuk',NULL,116),(2068,'Kyeongsangnam',NULL,116),(2069,'Kyonggi-do',NULL,116),(2070,'Kyungbuk-Do',NULL,116),(2071,'Kyunggi-Do',NULL,116),(2072,'Kyunggi-do',NULL,116),(2073,'Pusan',NULL,116),(2074,'Seoul',NULL,116),(2075,'Sudogwon',NULL,116),(2076,'Taegu',NULL,116),(2077,'Taejeon',NULL,116),(2078,'Taejon-gwangyoksi',NULL,116),(2079,'Ulsan',NULL,116),(2080,'Wonju',NULL,116),(2081,'gwangyoksi',NULL,116),(2082,'Al Asimah',NULL,117),(2083,'Hawalli',NULL,117),(2084,'Mishref',NULL,117),(2085,'Qadesiya',NULL,117),(2086,'Safat',NULL,117),(2087,'Salmiya',NULL,117),(2088,'al-Ahmadi','AH',117),(2089,'al-Farwaniyah','FA',117),(2090,'al-Jahra','JA',117),(2091,'al-Kuwayt',NULL,117),(2092,'Batken','B',118),(2093,'Bishkek','GB',118),(2094,'Chui','C',118),(2095,'Issyk-Kul','Y',118),(2096,'Jalal-Abad','J',118),(2097,'Naryn','N',118),(2098,'Osh','O',118),(2099,'Talas','T',118),(2100,'Attopu','AT',119),(2101,'Bokeo','BK',119),(2102,'Bolikhamsay','BL',119),(2103,'Champasak','CH',119),(2104,'Houaphanh','HO',119),(2105,'Khammouane','KH',119),(2106,'Luang Nam Tha','LM',119),(2107,'Luang Prabang','LP',119),(2108,'Oudomxay','OU',119),(2109,'Phongsaly','PH',119),(2110,'Saravan','SL',119),(2111,'Savannakhet','SV',119),(2112,'Sekong',NULL,119),(2113,'Viangchan Prefecture',NULL,119),(2114,'Viangchan Province',NULL,119),(2115,'Xaignabury',NULL,119),(2116,'Xiang Khuang','ZE',119),(2117,'Aizkraukles','0002',120),(2118,'Aluksnes','007',120),(2119,'Balvu','015',120),(2120,'Bauskas','016',120),(2121,'Cesu','022',120),(2122,'Daugavpils','DGV',120),(2123,'Daugavpils City',NULL,120),(2124,'Dobeles','026',120),(2125,'Gulbenes','033',120),(2126,'Jekabspils','042',120),(2127,'Jelgava','JEL',120),(2128,'Jelgavas','041',120),(2129,'Jurmala City','JUR',120),(2130,'Kraslavas','047',120),(2131,'Kuldigas','050',120),(2132,'Liepaja','LPX',120),(2133,'Liepajas',NULL,120),(2134,'Limbazhu',NULL,120),(2135,'Ludzas','054',120),(2136,'Madonas','059',120),(2137,'Ogres','067',120),(2138,'Preilu','073',120),(2139,'Rezekne',NULL,120),(2140,'Rezeknes','077',120),(2141,'Riga','RIX',120),(2142,'Rigas',NULL,120),(2143,'Saldus','088',120),(2144,'Talsu','097',120),(2145,'Tukuma','099',120),(2146,'Valkas','101',120),(2147,'Valmieras','113',120),(2148,'Ventspils','VEN',120),(2149,'Ventspils City',NULL,120),(2150,'Bayrut','BA',121),(2151,'Jabal Lubnan','JL',121),(2152,'Mohafazat Liban-Nord',NULL,121),(2153,'Mohafazat Mont-Liban',NULL,121),(2154,'Sidon',NULL,121),(2155,'al-Biqa','BI',121),(2156,'al-Janub','ja',121),(2157,'an-Nabatiyah',NULL,121),(2158,'ash-Shamal',NULL,121),(2159,'Berea','D',122),(2160,'Butha-Buthe','B',122),(2161,'Leribe','C',122),(2162,'Mafeteng','E',122),(2163,'Maseru','A',122),(2164,'Mohale\'s Hoek','F',122),(2165,'Mokhotlong','J',122),(2166,'Qacha\'s Nek','H',122),(2167,'Quthing','G',122),(2168,'Thaba-Tseka','K',122),(2169,'Bomi','BM',123),(2170,'Bong','BG',123),(2171,'Grand Bassa','GB',123),(2172,'Grand Cape Mount','CM',123),(2173,'Grand Gedeh','GG',123),(2174,'Loffa','LO',123),(2175,'Margibi','MG',123),(2176,'Maryland and Grand Kru',NULL,123),(2177,'Montserrado','MO',123),(2178,'Nimba','NI',123),(2179,'Rivercess','RI',123),(2180,'Sinoe','SI',123),(2181,'Ajdabiya',NULL,124),(2182,'Fezzan',NULL,124),(2183,'Banghazi','BA',124),(2184,'Darnah','DR',124),(2185,'Ghadamis',NULL,124),(2186,'Gharyan',NULL,124),(2187,'Misratah',NULL,124),(2188,'Murzuq',NULL,124),(2189,'Sabha',NULL,124),(2190,'Sawfajjin',NULL,124),(2191,'Surt',NULL,124),(2192,'Tarabulus',NULL,124),(2193,'Tarhunah',NULL,124),(2194,'Tripolitania',NULL,124),(2195,'Tubruq',NULL,124),(2196,'Yafran',NULL,124),(2197,'Zlitan',NULL,124),(2198,'al-\'Aziziyah',NULL,124),(2199,'al-Fatih',NULL,124),(2200,'al-Jabal al Akhdar','JA',124),(2201,'al-Jufrah','JU',124),(2202,'al-Khums',NULL,124),(2203,'al-Kufrah','KH',124),(2204,'an-Nuqat al-Khams',NULL,124),(2205,'ash-Shati\'',NULL,124),(2206,'az-Zawiyah',NULL,124),(2207,'Balzers','01',125),(2208,'Eschen','02',125),(2209,'Gamprin','03',125),(2210,'Mauren','04',125),(2211,'Planken','05',125),(2212,'Ruggell','06',125),(2213,'Schaan','07',125),(2214,'Schellenberg','08',125),(2215,'Triesen','09',125),(2216,'Triesenberg','10',125),(2217,'Vaduz','11',125),(2218,'Alytaus','03',126),(2219,'Anyksciai','04',126),(2220,'Kauno','16',126),(2221,'Klaipedos','20',126),(2222,'Marijampoles','MR',126),(2223,'Panevezhio','32',126),(2224,'Panevezys','33',126),(2225,'Shiauliu',NULL,126),(2226,'Taurages',NULL,126),(2227,'Telshiu','TE',126),(2228,'Telsiai','51',126),(2229,'Utenos','UT',126),(2230,'Vilniaus','58',126),(2231,'Capellen','CA',127),(2232,'Clervaux','CL',127),(2233,'Diekirch','DI',127),(2234,'Echternach','EC',127),(2235,'Esch-sur-Alzette','ES',127),(2236,'Grevenmacher','GR',127),(2237,'Luxembourg','LU',127),(2238,'Mersch','ME',127),(2239,'Redange','RD',127),(2240,'Remich','RM',127),(2241,'Vianden','VD',127),(2242,'Wiltz','WI',127),(2243,'Macau',NULL,128),(2244,'Berovo','201',129),(2245,'Bitola','501',129),(2246,'Brod',NULL,129),(2247,'Debar','303',129),(2248,'Delchevo','203',129),(2249,'Demir Hisar','502',129),(2250,'Gevgelija','405',129),(2251,'Gostivar','604',129),(2252,'Kavadarci','104',129),(2253,'Kichevo','307',129),(2254,'Kochani','206',129),(2255,'Kratovo','701',129),(2256,'Kriva Palanka','702',129),(2257,'Krushevo','505',129),(2258,'Kumanovo','703',129),(2259,'Negotino','106',129),(2260,'Ohrid','310',129),(2261,'Prilep','508',129),(2262,'Probishtip','209',129),(2263,'Radovish','409',129),(2264,'Resen','509',129),(2265,'Shtip',NULL,129),(2266,'Skopje',NULL,129),(2267,'Struga','312',129),(2268,'Strumica','410',129),(2269,'Sveti Nikole','108',129),(2270,'Tetovo','609',129),(2271,'Valandovo','403',129),(2272,'Veles','101',129),(2273,'Vinica','202',129),(2274,'Antananarivo','T',130),(2275,'Antsiranana','D',130),(2276,'Fianarantsoa','F',130),(2277,'Mahajanga','M',130),(2278,'Toamasina','A',130),(2279,'Toliary','U',130),(2280,'Balaka','BA',131),(2281,'Blantyre City','BL',131),(2282,'Chikwawa','CK',131),(2283,'Chiradzulu','CR',131),(2284,'Chitipa','CT',131),(2285,'Dedza','DE',131),(2286,'Dowa','DO',131),(2287,'Karonga','KR',131),(2288,'Kasungu','KS',131),(2289,'Lilongwe City','LI',131),(2290,'Machinga','MH',131),(2291,'Mangochi','MG',131),(2292,'Mchinji','MC',131),(2293,'Mulanje','MU',131),(2294,'Mwanza','MW',131),(2295,'Mzimba','MZ',131),(2296,'Mzuzu City',NULL,131),(2297,'Nkhata Bay',NULL,131),(2298,'Nkhotakota',NULL,131),(2299,'Nsanje','NS',131),(2300,'Ntcheu','NU',131),(2301,'Ntchisi','NI',131),(2302,'Phalombe','PH',131),(2303,'Rumphi','RU',131),(2304,'Salima','SA',131),(2305,'Thyolo','TH',131),(2306,'Zomba Municipality','ZO',131),(2307,'Johor','01',132),(2308,'Kedah','02',132),(2309,'Kelantan','03',132),(2310,'Kuala Lumpur',NULL,132),(2311,'Labuan',NULL,132),(2312,'Melaka','04',132),(2313,'Negeri Johor',NULL,132),(2314,'Negeri Sembilan','05',132),(2315,'Pahang','06',132),(2316,'Penang',NULL,132),(2317,'Perak','08',132),(2318,'Perlis','09',132),(2319,'Pulau Pinang','07',132),(2320,'Sabah','12',132),(2321,'Sarawak','13',132),(2322,'Selangor','10',132),(2323,'Sembilan',NULL,132),(2324,'Terengganu','11',132),(2325,'Alif Alif',NULL,133),(2326,'Alif Dhaal',NULL,133),(2327,'Baa',NULL,133),(2328,'Dhaal',NULL,133),(2329,'Faaf',NULL,133),(2330,'Gaaf Alif',NULL,133),(2331,'Gaaf Dhaal',NULL,133),(2332,'Ghaviyani',NULL,133),(2333,'Haa Alif',NULL,133),(2334,'Haa Dhaal',NULL,133),(2335,'Kaaf',NULL,133),(2336,'Laam',NULL,133),(2337,'Lhaviyani',NULL,133),(2338,'Male','MLE',133),(2339,'Miim',NULL,133),(2340,'Nuun',NULL,133),(2341,'Raa',NULL,133),(2342,'Shaviyani',NULL,133),(2343,'Siin',NULL,133),(2344,'Thaa',NULL,133),(2345,'Vaav',NULL,133),(2346,'Bamako','BKO',134),(2347,'Gao','7',134),(2348,'Kayes','1',134),(2349,'Kidal','8',134),(2350,'Koulikoro','2',134),(2351,'Mopti','5',134),(2352,'Segou','4',134),(2353,'Sikasso','3',134),(2354,'Tombouctou','6',134),(2355,'Gozo and Comino',NULL,135),(2356,'Inner Harbour',NULL,135),(2357,'Northern',NULL,135),(2358,'Outer Harbour',NULL,135),(2359,'South Eastern',NULL,135),(2360,'Valletta',NULL,135),(2361,'Western',NULL,135),(2362,'Castletown',NULL,136),(2363,'Douglas',NULL,136),(2364,'Laxey',NULL,136),(2365,'Onchan',NULL,136),(2366,'Peel',NULL,136),(2367,'Port Erin',NULL,136),(2368,'Port Saint Mary',NULL,136),(2369,'Ramsey',NULL,136),(2370,'Ailinlaplap','ALL',137),(2371,'Ailuk','ALK',137),(2372,'Arno','ARN',137),(2373,'Aur','AUR',137),(2374,'Bikini','NULL',137),(2375,'Ebon','EBO',137),(2376,'Enewetak','ENE',137),(2377,'Jabat','JAB',137),(2378,'Jaluit','JAL',137),(2379,'Kili','KIL',137),(2380,'Kwajalein','KWA',137),(2381,'Lae','LAE',137),(2382,'Lib','LIB',137),(2383,'Likiep','LIK',137),(2384,'Majuro','MAJ',137),(2385,'Maloelap',NULL,137),(2386,'Mejit','MEJ',137),(2387,'Mili','MIL',137),(2388,'Namorik',NULL,137),(2389,'Namu','NMU',137),(2390,'Rongelap','RON',137),(2391,'Ujae','UJE',137),(2392,'Utrik',NULL,137),(2393,'Wotho','WTH',137),(2394,'Wotje','WTJ',137),(2395,'Fort-de-France',NULL,138),(2396,'La Trinite',NULL,138),(2397,'Le Marin',NULL,138),(2398,'Saint-Pierre',NULL,138),(2399,'Adrar','07',139),(2400,'Assaba','03',139),(2401,'Brakna',NULL,139),(2402,'Dhakhlat Nawadibu',NULL,139),(2403,'Hudh-al-Gharbi',NULL,139),(2404,'Hudh-ash-Sharqi',NULL,139),(2405,'Inshiri','12',139),(2406,'Nawakshut','15',139),(2407,'Qidimagha',NULL,139),(2408,'Qurqul',NULL,139),(2409,'Taqant','09',139),(2410,'Tiris Zammur','11',139),(2411,'Trarza','06',139),(2412,'Black River','BL',140),(2413,'Eau Coulee',NULL,140),(2414,'Flacq','FL',140),(2415,'Floreal',NULL,140),(2416,'Grand Port','GP',140),(2417,'Moka','MO',140),(2418,'Pamplempousses','PA',140),(2419,'Plaines Wilhelm','PW',140),(2420,'Port Louis','PL',140),(2421,'Riviere du Rempart',NULL,140),(2422,'Rodrigues','RO',140),(2423,'Rose Hill',NULL,140),(2424,'Savanne',NULL,140),(2425,'Mayotte',NULL,141),(2426,'Pamanzi',NULL,141),(2427,'Aguascalientes','AG',142),(2428,'Baja California','BJ',142),(2429,'Baja California Sur','BS',142),(2430,'Campeche','CP',142),(2431,'Chiapas','CH',142),(2432,'Chihuahua','CI',142),(2433,'Coahuila','CU',142),(2434,'Colima','CL',142),(2435,'Distrito Federal','DF',142),(2436,'Durango','DG',142),(2437,'Estado de Mexico','EM',142),(2438,'Guanajuato','GJ',142),(2439,'Guerrero','GR',142),(2440,'Hidalgo','HG',142),(2441,'Jalisco','JA',142),(2442,'Mexico','MX',142),(2443,'Michoacan','MH',142),(2444,'Morelos','MR',142),(2445,'Nayarit','NA',142),(2446,'Nuevo Leon','NL',142),(2447,'Oaxaca','OA',142),(2448,'Puebla','PU',142),(2449,'Queretaro','QA',142),(2450,'Quintana Roo','QR',142),(2451,'San Luis Potosi','SL',142),(2452,'Sinaloa','SI',142),(2453,'Sonora','SO',142),(2454,'Tabasco','TA',142),(2455,'Tamaulipas','TM',142),(2456,'Tlaxcala','TL',142),(2457,'Veracruz Llave','VL',142),(2458,'Yucatan','YC',142),(2459,'Zacatecas','ZT',142),(2460,'Chuuk','TRK',143),(2461,'Kosrae ','KSA',143),(2462,'Pohnpei','PNI ',143),(2463,'Yap','YAP ',143),(2464,'Balti','BA',144),(2465,'Cahul','CA',144),(2466,'Chisinau',NULL,144),(2467,'Chisinau Oras',NULL,144),(2468,'Edinet','ED',144),(2469,'Gagauzia','GA',144),(2470,'Lapusna',NULL,144),(2471,'Orhei','OR',144),(2472,'Soroca','SO',144),(2473,'Taraclia','TA',144),(2474,'Tighina',NULL,144),(2475,'Transnistria',NULL,144),(2476,'Ungheni','UN',144),(2477,'Fontvieille','FO',145),(2478,'La Condamine','CO',145),(2479,'Monaco-Ville','MO',145),(2480,'Monte Carlo','MC',145),(2481,'Arhangaj','073',146),(2482,'Bajan-Olgij','071',146),(2483,'Bajanhongor',NULL,146),(2484,'Bulgan','067',146),(2485,'Darhan-Uul','037',146),(2486,'Dornod','061',146),(2487,'Dornogovi','063',146),(2488,'Dundgovi','059',146),(2489,'Govi-Altaj','065',146),(2490,'Govisumber','064',146),(2491,'Hentij','039',146),(2492,'Hovd','043',146),(2493,'Hovsgol','041',146),(2494,'Omnogovi','053',146),(2495,'Orhon',NULL,146),(2496,'Ovorhangaj',NULL,146),(2497,'Selenge',NULL,146),(2498,'Suhbaatar',NULL,146),(2499,'Tov',NULL,146),(2500,'Ulaanbaatar',NULL,146),(2501,'Uvs',NULL,146),(2502,'Zavhan',NULL,146),(2503,'Montserrat',NULL,147),(2504,'Agadir','AGD',148),(2505,'Casablanca','CAS',148),(2506,'Chaouia-Ouardigha',NULL,148),(2507,'Doukkala-Abda',NULL,148),(2508,'Fes-Boulemane',NULL,148),(2509,'Gharb-Chrarda-Beni Hssen',NULL,148),(2510,'Guelmim','GUE',148),(2511,'Kenitra','KEN',148),(2512,'Marrakech-Tensift-Al Haouz',NULL,148),(2513,'Meknes-Tafilalet',NULL,148),(2514,'Oriental',NULL,148),(2515,'Oujda','OUJ',148),(2516,'Province de Tanger',NULL,148),(2517,'Rabat-Sale-Zammour-Zaer','RAB',148),(2518,'Sala Al Jadida',NULL,148),(2519,'Settat','SET',148),(2520,'Souss Massa-Draa','09',148),(2521,'Tadla-Azilal',NULL,148),(2522,'Tangier-Tetouan',NULL,148),(2523,'Taza-Al Hoceima-Taounate',NULL,148),(2524,'Wilaya de Casablanca',NULL,148),(2525,'Wilaya de Rabat-Sale',NULL,148),(2526,'Cabo Delgado','P',149),(2527,'Gaza','G',149),(2528,'Inhambane','I',149),(2529,'Manica','M',149),(2530,'Maputo','L',149),(2531,'Maputo Provincia','MPM',149),(2532,'Nampula','N',149),(2533,'Niassa','A',149),(2534,'Sofala','S',149),(2535,'Tete','T',149),(2536,'Zambezia','Q',149),(2537,'Ayeyarwady',NULL,150),(2538,'Bago',NULL,150),(2539,'Chin',NULL,150),(2540,'Kachin',NULL,150),(2541,'Kayah',NULL,150),(2542,'Kayin',NULL,150),(2543,'Magway',NULL,150),(2544,'Mandalay',NULL,150),(2545,'Mon',NULL,150),(2546,'Nay Pyi Taw',NULL,150),(2547,'Rakhine',NULL,150),(2548,'Sagaing',NULL,150),(2549,'Shan',NULL,150),(2550,'Tanintharyi',NULL,150),(2551,'Yangon',NULL,150),(2552,'Caprivi',NULL,151),(2553,'Erongo',NULL,151),(2554,'Hardap',NULL,151),(2555,'Karas','KA',151),(2556,'Kavango','KE',151),(2557,'Khomas','KH',151),(2558,'Kunene','KU',151),(2559,'Ohangwena','OW',151),(2560,'Omaheke','OH',151),(2561,'Omusati','OS',151),(2562,'Oshana','ON',151),(2563,'Oshikoto','OT',151),(2564,'Otjozondjupa','OD',151),(2565,'Yaren','14',152),(2566,'Bagmati','P3',153),(2567,'Bheri',NULL,153),(2568,'Dhawalagiri',NULL,153),(2569,'Gandaki','P4',153),(2570,'Janakpur',NULL,153),(2571,'Karnali','P6',153),(2572,'Koshi',NULL,153),(2573,'Lumbini','P5',153),(2574,'Mahakali',NULL,153),(2575,'Mechi',NULL,153),(2576,'Narayani',NULL,153),(2577,'Rapti',NULL,153),(2578,'Sagarmatha',NULL,153),(2579,'Seti',NULL,153),(2580,'Bonaire',NULL,154),(2581,'Curacao',NULL,154),(2582,'Saba',NULL,154),(2583,'Sint Eustatius',NULL,154),(2584,'Sint Maarten',NULL,154),(2585,'Amsterdam',NULL,155),(2586,'Benelux',NULL,155),(2587,'Drenthe','DR',155),(2588,'Flevoland','FL',155),(2589,'Friesland','FR',155),(2590,'Gelderland','GE',155),(2591,'Groningen','GR',155),(2592,'Limburg','LI',155),(2593,'Noord-Brabant','NB',155),(2594,'Noord-Holland','NH',155),(2595,'Overijssel','OV',155),(2596,'South Holland',NULL,155),(2597,'Utrecht','UT',155),(2598,'Zeeland','ZE',155),(2599,'Zuid-Holland','ZH',155),(2600,'Iles',NULL,156),(2601,'Nord',NULL,156),(2602,'Sud',NULL,156),(2603,'Area Outside Region',NULL,157),(2604,'Auckland','AUK',157),(2605,'Bay of Plenty','BOP',157),(2606,'Canterbury','CAN',157),(2607,'Christchurch',NULL,157),(2608,'Gisborne','GIS',157),(2609,'Hawke\'s Bay','HKB',157),(2610,'Manawatu-Wanganui','MWT',157),(2611,'Marlborough','MBH',157),(2612,'Nelson','NSN',157),(2613,'Northland','NTL',157),(2614,'Otago','OTA',157),(2615,'Rodney',NULL,157),(2616,'Southland','STL',157),(2617,'Taranaki','TKI',157),(2618,'Tasman','TAS',157),(2619,'Waikato','WKO',157),(2620,'Wellington',NULL,157),(2621,'West Coast','WTC',157),(2622,'Atlantico Norte',NULL,158),(2623,'Atlantico Sur',NULL,158),(2624,'Boaco','BO',158),(2625,'Carazo','CA',158),(2626,'Chinandega','CI',158),(2627,'Chontales','CO',158),(2628,'Esteli','ES',158),(2629,'Granada','GR',158),(2630,'Jinotega','JI',158),(2631,'Leon','LE',158),(2632,'Madriz','MD',158),(2633,'Managua','MN',158),(2634,'Masaya','MS',158),(2635,'Matagalpa','MT',158),(2636,'Nueva Segovia','NS',158),(2637,'Rio San Juan','SJ',158),(2638,'Rivas','RI',158),(2639,'Agadez','1',159),(2640,'Diffa','2',159),(2641,'Dosso','3',159),(2642,'Maradi','4',159),(2643,'Niamey','8',159),(2644,'Tahoua','5',159),(2645,'Tillabery','6',159),(2646,'Zinder','7',159),(2647,'Abia','AB',160),(2648,'Abuja Federal Capital Territor','FC',160),(2649,'Adamawa','AD',160),(2650,'Akwa Ibom','AK',160),(2651,'Anambra','AN',160),(2652,'Bauchi','BA',160),(2653,'Bayelsa','BY',160),(2654,'Benue','BE',160),(2655,'Borno','BO',160),(2656,'Cross River','CR',160),(2657,'Delta','DE',160),(2658,'Ebonyi','EB',160),(2659,'Edo','ED',160),(2660,'Ekiti','EK',160),(2661,'Enugu','EN',160),(2662,'Gombe','GO',160),(2663,'Imo','IM',160),(2664,'Jigawa',NULL,160),(2665,'Kaduna','KD',160),(2666,'Kano','KN',160),(2667,'Katsina','KT',160),(2668,'Kebbi','KE',160),(2669,'Kogi','KO',160),(2670,'Kwara','KW',160),(2671,'Lagos','LA',160),(2672,'Nassarawa',NULL,160),(2673,'Niger',NULL,160),(2674,'Ogun','OG',160),(2675,'Ondo','ON',160),(2676,'Osun',NULL,160),(2677,'Oyo','OY',160),(2678,'Plateau','PL',160),(2679,'Rivers',NULL,160),(2680,'Sokoto','SO',160),(2681,'Taraba','TA',160),(2682,'Yobe','YO',160),(2683,'Zamfara','ZA',160),(2684,'Niue',NULL,161),(2685,'Norfolk Island',NULL,162),(2686,'Northern Islands',NULL,163),(2687,'Rota',NULL,163),(2688,'Saipan',NULL,163),(2689,'Tinian',NULL,163),(2690,'Akershus',NULL,164),(2691,'Aust Agder',NULL,164),(2692,'Bergen',NULL,164),(2693,'Buskerud',NULL,164),(2694,'Finnmark',NULL,164),(2695,'Hedmark',NULL,164),(2696,'Hordaland',NULL,164),(2697,'Moere og Romsdal',NULL,164),(2698,'Nord Trondelag',NULL,164),(2699,'Nordland',NULL,164),(2700,'Oestfold',NULL,164),(2701,'Oppland',NULL,164),(2702,'Oslo','03',164),(2703,'Rogaland','11',164),(2704,'Soer Troendelag',NULL,164),(2705,'Sogn og Fjordane',NULL,164),(2706,'Stavern',NULL,164),(2707,'Sykkylven',NULL,164),(2708,'Telemark',NULL,164),(2709,'Troms','54',164),(2710,'Vest Agder',NULL,164),(2711,'Vestfold',NULL,164),(2712,'ÃƒÂ˜stfold',NULL,164),(2713,'Al Buraimi','BU',165),(2714,'Dhufar',NULL,165),(2715,'Masqat','MA',165),(2716,'Musandam','MU',165),(2717,'Rusayl',NULL,165),(2718,'Wadi Kabir',NULL,165),(2719,'ad-Dakhiliyah',NULL,165),(2720,'adh-Dhahirah',NULL,165),(2721,'al-Batinah',NULL,165),(2722,'ash-Sharqiyah',NULL,165),(2723,'Baluchistan','BA',166),(2724,'Federal Capital Area',NULL,166),(2725,'Federally administered Tribal ',NULL,166),(2726,'North-West Frontier',NULL,166),(2727,'Northern Areas',NULL,166),(2728,'Punjab','PB',166),(2729,'Sind','SD',166),(2730,'Aimeliik','002',167),(2731,'Airai','004',167),(2732,'Angaur','010',167),(2733,'Hatobohei',NULL,167),(2734,'Kayangel','050',167),(2735,'Koror','150',167),(2736,'Melekeok','212',167),(2737,'Ngaraard','214',167),(2738,'Ngardmau','222',167),(2739,'Ngaremlengui','227',167),(2740,'Ngatpang','224',167),(2741,'Ngchesar','226',167),(2742,'Ngerchelong','218',167),(2743,'Ngiwal','228',167),(2744,'Peleliu','350',167),(2745,'Sonsorol','370',167),(2746,'Ariha',NULL,168),(2747,'Bayt Lahm','BTM',168),(2748,'Bethlehem','BTH',168),(2749,'Dayr-al-Balah','DEB',168),(2750,'Ghazzah',NULL,168),(2751,'Ghazzah ash-Shamaliyah','GZA',168),(2752,'Janin','JEN',168),(2753,'Khan Yunis','KYS',168),(2754,'Nabulus','NBS',168),(2755,'Qalqilyah','QQA',168),(2756,'Rafah','RFH',168),(2757,'Ram Allah wal-Birah',NULL,168),(2758,'Salfit','SLT',168),(2759,'Tubas','TBS',168),(2760,'Tulkarm','TKM',168),(2761,'al-Khalil','HBN',168),(2762,'al-Quds','JEM',168),(2763,'Bocas del Toro','1',169),(2764,'Chiriqui','4',169),(2765,'Cocle','3',169),(2766,'Colon',NULL,169),(2767,'Darien','5',169),(2768,'Embera','EM',169),(2769,'Herrera','6',169),(2770,'Kuna Yala',NULL,169),(2771,'Los Santos','7',169),(2772,'Ngobe Bugle',NULL,169),(2773,'Panama','10',169),(2774,'Veraguas','9',169),(2775,'East New Britain','EBR',170),(2776,'East Sepik','ESW',170),(2777,'Eastern Highlands','EHG',170),(2778,'Enga','EPW',170),(2779,'Fly River',NULL,170),(2780,'Gulf',NULL,170),(2781,'Madang','MPM',170),(2782,'Manus','MRL',170),(2783,'Milne Bay',NULL,170),(2784,'Morobe',NULL,170),(2785,'National Capital District',NULL,170),(2786,'New Ireland','NIK',170),(2787,'North Solomons','NIL',170),(2788,'Oro',NULL,170),(2789,'Sandaun',NULL,170),(2790,'Simbu',NULL,170),(2791,'Southern Highlands','SHM',170),(2792,'West New Britain','WBK',170),(2793,'Western Highlands','WHM',170),(2794,'Alto Paraguay','16',171),(2795,'Alto Parana','10',171),(2796,'Amambay','13',171),(2797,'Asuncion','ASU',171),(2798,'Boqueron','19',171),(2799,'Caaguazu','5',171),(2800,'Caazapa','6',171),(2801,'Canendiyu','14',171),(2802,'Central','11',171),(2803,'Concepcion','1',171),(2804,'Cordillera','3',171),(2805,'Guaira','4',171),(2806,'Itapua','7',171),(2807,'Misiones','8',171),(2808,'Neembucu','12',171),(2809,'Paraguari','9',171),(2810,'Presidente Hayes','15',171),(2811,'San Pedro','2',171),(2812,'Amazonas','AMA',172),(2813,'Ancash','ANSH',172),(2814,'Apurimac','APU',172),(2815,'Arequipa','ARE',172),(2816,'Ayacucho','AYA',172),(2817,'Cajamarca','CAJ',172),(2818,'Cusco','CUS',172),(2819,'Huancavelica','HUV',172),(2820,'Huanuco','HUC',172),(2821,'Ica','ICA',172),(2822,'Junin','JUN',172),(2823,'La Libertad','LAL',172),(2824,'Lambayeque','LAM',172),(2825,'Lima y Callao',NULL,172),(2826,'Loreto','LOR',172),(2827,'Madre de Dios','MDD',172),(2828,'Moquegua','MOQ',172),(2829,'Pasco','PAS',172),(2830,'Piura','PIU',172),(2831,'Puno','PUN',172),(2832,'San Martin','SAM',172),(2833,'Tacna','TAC',172),(2834,'Tumbes','TUM',172),(2835,'Ucayali','UCA',172),(2836,'Batangas','BTG',173),(2837,'Bicol',NULL,173),(2838,'Bulacan','BUL',173),(2839,'Cagayan','CAG',173),(2840,'Caraga',NULL,173),(2841,'Central Luzon','CL',173),(2842,'Central Mindanao','CM',173),(2843,'Central Visayas','CV',173),(2844,'Cordillera',NULL,173),(2845,'Davao','DVO',173),(2846,'Eastern Visayas','EV',173),(2847,'Greater Metropolitan Area',NULL,173),(2848,'Ilocos','ILS',173),(2849,'Laguna','LAG',173),(2850,'Luzon',NULL,173),(2851,'Mactan',NULL,173),(2852,'Metropolitan Manila Area',NULL,173),(2853,'Muslim Mindanao',NULL,173),(2854,'Northern Mindanao',NULL,173),(2855,'Southern Mindanao',NULL,173),(2856,'Southern Tagalog',NULL,173),(2857,'Western Mindanao',NULL,173),(2858,'Western Visayas','06',173),(2859,'Pitcairn Island',NULL,174),(2860,'Biale Blota',NULL,175),(2861,'Dobroszyce',NULL,175),(2862,'Dolnoslaskie','02',175),(2863,'Dziekanow Lesny',NULL,175),(2864,'Hopowo',NULL,175),(2865,'Kartuzy',NULL,175),(2866,'Koscian',NULL,175),(2867,'Krakow',NULL,175),(2868,'Kujawsko-Pomorskie','04',175),(2869,'Lodzkie','10',175),(2870,'Lubelskie','06',175),(2871,'Lubuskie','04',175),(2872,'Malomice',NULL,175),(2873,'Malopolskie',NULL,175),(2874,'Mazowieckie','14',175),(2875,'Mirkow',NULL,175),(2876,'Opolskie',NULL,175),(2877,'Ostrowiec',NULL,175),(2878,'Podkarpackie',NULL,175),(2879,'Podlaskie',NULL,175),(2880,'Polska',NULL,175),(2881,'Pomorskie','22',175),(2882,'Poznan',NULL,175),(2883,'Pruszkow',NULL,175),(2884,'Rymanowska',NULL,175),(2885,'Rzeszow',NULL,175),(2886,'Slaskie','24',175),(2887,'Stare Pole',NULL,175),(2888,'Swietokrzyskie','26',175),(2889,'Warminsko-Mazurskie','28',175),(2890,'Warsaw',NULL,175),(2891,'Wejherowo',NULL,175),(2892,'Wielkopolskie',NULL,175),(2893,'Wroclaw',NULL,175),(2894,'Zachodnio-Pomorskie',NULL,175),(2895,'Zukowo',NULL,175),(2896,'Abrantes',NULL,176),(2897,'Acores',NULL,176),(2898,'Alentejo',NULL,176),(2899,'Algarve',NULL,176),(2900,'Braga','03',176),(2901,'Centro',NULL,176),(2902,'Distrito de Leiria','10',176),(2903,'Distrito de Viana do Castelo','16',176),(2904,'Distrito de Vila Real','17',176),(2905,'Distrito do Porto',NULL,176),(2906,'Lisboa e Vale do Tejo',NULL,176),(2907,'Madeira',NULL,176),(2908,'Norte',NULL,176),(2909,'Paivas',NULL,176),(2910,'Arecibo',NULL,177),(2911,'Bayamon',NULL,177),(2912,'Carolina',NULL,177),(2913,'Florida',NULL,177),(2914,'Guayama',NULL,177),(2915,'Humacao',NULL,177),(2916,'Mayaguez-Aguadilla',NULL,177),(2917,'Ponce',NULL,177),(2918,'Salinas',NULL,177),(2919,'San Juan',NULL,177),(2920,'Doha',NULL,178),(2921,'Jarian-al-Batnah',NULL,178),(2922,'Umm Salal','US',178),(2923,'ad-Dawhah','DA',178),(2924,'al-Ghuwayriyah',NULL,178),(2925,'al-Jumayliyah',NULL,178),(2926,'al-Khawr','KH',178),(2927,'al-Wakrah','WA',178),(2928,'ar-Rayyan','RA',178),(2929,'ash-Shamal','MS',178),(2930,'Saint-Benoit',NULL,179),(2931,'Saint-Denis',NULL,179),(2932,'Saint-Paul',NULL,179),(2933,'Saint-Pierre',NULL,179),(2934,'Alba','AB',180),(2935,'Arad','AR',180),(2936,'Arges','AG',180),(2937,'Bacau','BC',180),(2938,'Bihor','BH',180),(2939,'Bistrita-Nasaud','BN',180),(2940,'Botosani','BT',180),(2941,'Braila','BR',180),(2942,'Brasov','BV',180),(2943,'Bucuresti','B',180),(2944,'Buzau','BZ',180),(2945,'Calarasi','CL',180),(2946,'Caras-Severin','CS',180),(2947,'Cluj','CJ',180),(2948,'Constanta','CT',180),(2949,'Covasna','CV',180),(2950,'Dambovita','DB',180),(2951,'Dolj','DJ',180),(2952,'Galati','GL',180),(2953,'Giurgiu',NULL,180),(2954,'Gorj','GJ',180),(2955,'Harghita','HR',180),(2956,'Hunedoara','HD',180),(2957,'Ialomita','IL',180),(2958,'Iasi','IS',180),(2959,'Ilfov',NULL,180),(2960,'Maramures','MS',180),(2961,'Mehedinti','MH',180),(2962,'Mures','MS',180),(2963,'Neamt','NT',180),(2964,'Olt','OT',180),(2965,'Prahova','PH',180),(2966,'Salaj','SJ',180),(2967,'Satu Mare','SM',180),(2968,'Sibiu','SB',180),(2969,'Sondelor',NULL,180),(2970,'Suceava','SU',180),(2971,'Teleorman','TR',180),(2972,'Timis','TM',180),(2973,'Tulcea',NULL,180),(2974,'Valcea','VL',180),(2975,'Vaslui','VS',180),(2976,'Vrancea','VN',180),(2977,'Adygeja','AD',181),(2978,'Aga',NULL,181),(2979,'Alanija',NULL,181),(2980,'Altaj',NULL,181),(2981,'Amur',NULL,181),(2982,'Arhangelsk',NULL,181),(2983,'Astrahan',NULL,181),(2984,'Bashkortostan','BA ',181),(2985,'Belgorod Oblast ','BEL',181),(2986,'Bryansk Oblast','BRY',181),(2987,'Buryatia ','BU',181),(2988,'Chechenija','CE',181),(2989,'Cheljabinsk',NULL,181),(2990,'Chita',NULL,181),(2991,'Chukotka',NULL,181),(2992,'Chuvashija',NULL,181),(2993,'Dagestan','DA',181),(2994,'Evenkija',NULL,181),(2995,'Gorno-Altaj',NULL,181),(2996,'Habarovsk','KHA',181),(2997,'Hakasija','KK',181),(2998,'Hanty-Mansija','KHM',181),(2999,'Ingusetija','IN',181),(3000,'Irkutsk','IRK',181),(3001,'Ivanovo','IVA',181),(3002,'Jamalo-Nenets',NULL,181),(3003,'Jaroslavl',NULL,181),(3004,'Jevrej',NULL,181),(3005,'Kabardino-Balkarija',NULL,181),(3006,'Kaliningrad',NULL,181),(3007,'Kalmykija',NULL,181),(3008,'Kaluga',NULL,181),(3009,'Kamchatka',NULL,181),(3010,'Karachaj-Cherkessija',NULL,181),(3011,'Karelija',NULL,181),(3012,'Kemerovo',NULL,181),(3013,'Khabarovskiy Kray',NULL,181),(3014,'Kirov',NULL,181),(3015,'Komi',NULL,181),(3016,'Komi-Permjakija',NULL,181),(3017,'Korjakija',NULL,181),(3018,'Kostroma',NULL,181),(3019,'Krasnodar',NULL,181),(3020,'Krasnojarsk',NULL,181),(3021,'Krasnoyarskiy Kray',NULL,181),(3022,'Kurgan',NULL,181),(3023,'Kursk',NULL,181),(3024,'Leningrad',NULL,181),(3025,'Lipeck',NULL,181),(3026,'Magadan',NULL,181),(3027,'Marij El',NULL,181),(3028,'Mordovija',NULL,181),(3029,'Moscow',NULL,181),(3030,'Moskovskaja Oblast',NULL,181),(3031,'Moskovskaya Oblast',NULL,181),(3032,'Moskva',NULL,181),(3033,'Murmansk',NULL,181),(3034,'Nenets',NULL,181),(3035,'Nizhnij Novgorod',NULL,181),(3036,'Novgorod',NULL,181),(3037,'Novokusnezk',NULL,181),(3038,'Novosibirsk',NULL,181),(3039,'Omsk',NULL,181),(3040,'Orenburg',NULL,181),(3041,'Orjol',NULL,181),(3042,'Penza','PNZ',181),(3043,'Perm',NULL,181),(3044,'Primorje',NULL,181),(3045,'Pskov',NULL,181),(3046,'Pskovskaya Oblast',NULL,181),(3047,'Rjazan',NULL,181),(3048,'Rostov',NULL,181),(3049,'Sakha','SAK',181),(3050,'Sahalin',NULL,181),(3051,'Samara','SAM',181),(3052,'Samarskaya',NULL,181),(3053,'Sankt-Peterburg',NULL,181),(3054,'Saratov','SAR',181),(3055,'Smolensk','SMO',181),(3056,'Stavropol','STA',181),(3057,'Sverdlovsk','SVE',181),(3058,'Tajmyrija',NULL,181),(3059,'Tambov','TAM',181),(3060,'Tatarstan','TA',181),(3061,'Tjumen',NULL,181),(3062,'Tomsk','TOM',181),(3063,'Tula',NULL,181),(3064,'Tver',NULL,181),(3065,'Tyva','TY',181),(3066,'Udmurtija','UD',181),(3067,'Uljanovsk',NULL,181),(3068,'Ulyanovskaya Oblast','ULY',181),(3069,'Ust-Orda',NULL,181),(3070,'Vladimir','VLR',181),(3071,'Volgograd','VGG',181),(3072,'Vologda','VLG',181),(3073,'Voronezh','VOR',181),(3074,'Butare',NULL,182),(3075,'Byumba',NULL,182),(3076,'Cyangugu',NULL,182),(3077,'Gikongoro',NULL,182),(3078,'Gisenyi',NULL,182),(3079,'Gitarama',NULL,182),(3080,'Kibungo',NULL,182),(3081,'Kibuye',NULL,182),(3082,'Kigali-ngali',NULL,182),(3083,'Ruhengeri',NULL,182),(3084,'Ascension','AC',183),(3085,'Gough Island',NULL,183),(3086,'Saint Helena','HL',183),(3087,'Tristan da Cunha','TA',183),(3088,'Christ Church Nichola Town','01',184),(3089,'Saint Anne Sandy Point','02',184),(3090,'Saint George Basseterre','03',184),(3091,'Saint George Gingerland','04',184),(3092,'Saint James Windward','05',184),(3093,'Saint John Capesterre','06',184),(3094,'Saint John Figtree','07',184),(3095,'Saint Mary Cayon','08',184),(3096,'Saint Paul Capesterre','09',184),(3097,'Saint Paul Charlestown','10',184),(3098,'Saint Peter Basseterre','11',184),(3099,'Saint Thomas Lowland','12',184),(3100,'Saint Thomas Middle Island','13',184),(3101,'Trinity Palmetto Point','15',184),(3102,'Anse-la-Raye','01',185),(3103,'Canaries','12',185),(3104,'Castries','02',185),(3105,'Choiseul','03',185),(3106,'Dennery','05',185),(3107,'Gros Inlet','06',185),(3108,'Laborie','07',185),(3109,'Micoud','08',185),(3110,'Soufriere','10',185),(3111,'Vieux Fort','11',185),(3112,'Miquelon-Langlade',NULL,186),(3113,'Saint-Pierre',NULL,186),(3114,'Charlotte','01',187),(3115,'Grenadines','06',187),(3116,'Saint Andrew','02',187),(3117,'Saint David','03',187),(3118,'Saint George','04',187),(3119,'Saint Patrick','05',187),(3120,'A\'ana','AA',188),(3121,'Aiga-i-le-Tai','AL',188),(3122,'Atua','AT',188),(3123,'Fa\'asaleleaga','FA',188),(3124,'Gaga\'emauga','GE',188),(3125,'Gagaifomauga','GI',188),(3126,'Palauli','PA',188),(3127,'Satupa\'itea','SA',188),(3128,'Tuamasaga','TU',188),(3129,'Va\'a-o-Fonoti','VF',188),(3130,'Vaisigano','VS',188),(3131,'Acquaviva','01',189),(3132,'Borgo Maggiore','06',189),(3133,'Chiesanuova','02',189),(3134,'Domagnano','03',189),(3135,'Faetano','04',189),(3136,'Fiorentino','05',189),(3137,'Montegiardino','08',189),(3138,'San Marino',NULL,189),(3139,'Serravalle','09',189),(3140,'Agua Grande','01',190),(3141,'Cantagalo','02',190),(3142,'Lemba','04',190),(3143,'Lobata','05',190),(3144,'Me-Zochi','06',190),(3145,'Pague',NULL,190),(3146,'Al Khobar',NULL,191),(3147,'Aseer','14',191),(3148,'Ash Sharqiyah','04',191),(3149,'Asir',NULL,191),(3150,'Central Province',NULL,191),(3151,'Eastern Province',NULL,191),(3152,'Ha\'il','06',191),(3153,'Jawf',NULL,191),(3154,'Jazan','09',191),(3155,'Makkah',NULL,191),(3156,'Najran','10',191),(3157,'Qasim',NULL,191),(3158,'Tabuk',NULL,191),(3159,'Western Province',NULL,191),(3160,'al-Bahah',NULL,191),(3161,'al-Hudud-ash-Shamaliyah',NULL,191),(3162,'al-Madinah',NULL,191),(3163,'ar-Riyad',NULL,191),(3164,'Dakar','DK',192),(3165,'Diourbel','DB',192),(3166,'Fatick','FK',192),(3167,'Kaolack','KL',192),(3168,'Kolda','KD',192),(3169,'Louga','LG',192),(3170,'Saint-Louis','SL',192),(3171,'Tambacounda','TC',192),(3172,'Thies','TH',192),(3173,'Ziguinchor','ZG',192),(3174,'Central Serbia',NULL,193),(3175,'Kosovo and Metohija','KM',193),(3176,'Vojvodina','VO',193),(3177,'Anse Boileau','02',194),(3178,'Anse Royale','05',194),(3179,'Cascade','11',194),(3180,'Takamaka','23',194),(3181,'Victoria',NULL,194),(3182,'Eastern','E',195),(3183,'Northern','NW',195),(3184,'Southern','S',195),(3185,'Western','W',195),(3186,'Singapore',NULL,196),(3187,'Banskobystricky','BC',197),(3188,'Bratislavsky','BL',197),(3189,'Kosicky','KI',197),(3190,'Nitriansky','NI',197),(3191,'Presovsky','PV',197),(3192,'Trenciansky','TC',197),(3193,'Trnavsky','TA',197),(3194,'Zilinsky','ZI',197),(3195,'Benedikt','148',198),(3196,'Gorenjska',NULL,198),(3197,'Gorishka','028',198),(3198,'Jugovzhodna Slovenija',NULL,198),(3199,'Koroshka',NULL,198),(3200,'Notranjsko-krashka',NULL,198),(3201,'Obalno-krashka',NULL,198),(3202,'Obcina Domzale',NULL,198),(3203,'Obcina Vitanje',NULL,198),(3204,'Osrednjeslovenska',NULL,198),(3205,'Podravska',NULL,198),(3206,'Pomurska',NULL,198),(3207,'Savinjska',NULL,198),(3208,'Slovenian Littoral',NULL,198),(3209,'Spodnjeposavska',NULL,198),(3210,'Zasavska',NULL,198),(3211,'Pitcairn',NULL,199),(3212,'Central','CE',200),(3213,'Choiseul','CH',200),(3214,'Guadalcanal','GU',200),(3215,'Isabel','IS',200),(3216,'Makira and Ulawa','MK',200),(3217,'Malaita','ML',200),(3218,'Rennell and Bellona','RB',200),(3219,'Temotu','TE',200),(3220,'Western','WE',200),(3221,'Awdal','AW',201),(3222,'Bakol','BK',201),(3223,'Banadir','BN',201),(3224,'Bari','BR',201),(3225,'Bay','BY',201),(3226,'Galgudug','GA',201),(3227,'Gedo','GE',201),(3228,'Hiran','HI',201),(3229,'Jubbada Hose','JH',201),(3230,'Jubbadha Dexe','JD',201),(3231,'Mudug','MU',201),(3232,'Nugal','NU',201),(3233,'Sanag','SA',201),(3234,'Shabellaha Dhexe','SD',201),(3235,'Shabellaha Hoose','SH',201),(3236,'Togdher','TO',201),(3237,'Woqoyi Galbed','WO',201),(3238,'Eastern Cape','EC',202),(3239,'Free State','FS',202),(3240,'Gauteng','GP',202),(3241,'Kempton Park',NULL,202),(3242,'Kramerville',NULL,202),(3243,'KwaZulu Natal','KZN',202),(3244,'Limpopo','LP',202),(3245,'Mpumalanga','MP',202),(3246,'North West','NW',202),(3247,'Northern Cape','NC',202),(3248,'Parow',NULL,202),(3249,'Table View',NULL,202),(3250,'Umtentweni',NULL,202),(3251,'Western Cape','WC',202),(3252,'South Georgia',NULL,203),(3253,'Central Equatoria',NULL,204),(3254,'A Coruna',NULL,205),(3255,'Alacant',NULL,205),(3256,'Alava','VI',205),(3257,'Albacete',NULL,205),(3258,'Almeria',NULL,205),(3260,'Asturias',NULL,205),(3261,'Avila',NULL,205),(3262,'Badajoz','BA',205),(3263,'Balears',NULL,205),(3264,'Barcelona',NULL,205),(3267,'Burgos','BU',205),(3268,'Caceres',NULL,205),(3269,'Cadiz',NULL,205),(3270,'Cantabria',NULL,205),(3271,'Castello','CS',205),(3273,'Ceuta','CE',205),(3274,'Ciudad Real','CR',205),(3281,'Cordoba','CO',205),(3282,'Cuenca','CU',205),(3284,'Girona','GI',205),(3285,'Granada','GR',205),(3286,'Guadalajara','GU',205),(3287,'Guipuzcoa',NULL,205),(3288,'Huelva','H',205),(3289,'Huesca','HU',205),(3290,'Jaen','J',205),(3291,'La Rioja','LR',205),(3292,'Las Palmas','GC',205),(3293,'Leon','LE',205),(3295,'Lleida','L',205),(3296,'Lugo','LU',205),(3297,'Madrid','M',205),(3298,'Malaga',NULL,205),(3299,'Melilla','ML',205),(3300,'Murcia','MU',205),(3301,'Navarra','NA',205),(3302,'Ourense','OR',205),(3303,'Pais Vasco','PV',205),(3304,'Palencia','P',205),(3305,'Pontevedra','PO',205),(3306,'Salamanca','SA',205),(3308,'Segovia','SG',205),(3309,'Sevilla',NULL,205),(3310,'Soria',NULL,205),(3311,'Tarragona',NULL,205),(3312,'Santa Cruz de Tenerife','TF',205),(3313,'Teruel','TE',205),(3314,'Toledo','TO',205),(3315,'Valencia','V',205),(3316,'Valladolid',NULL,205),(3317,'Vizcaya',NULL,205),(3318,'Zamora','ZA',205),(3319,'Zaragoza','Z',205),(3320,'Amparai','54',206),(3321,'Anuradhapuraya','71',206),(3322,'Badulla',NULL,206),(3323,'Boralesgamuwa',NULL,206),(3324,'Colombo','11',206),(3325,'Galla','31',206),(3326,'Gampaha','12',206),(3327,'Hambantota',NULL,206),(3328,'Kalatura',NULL,206),(3329,'Kegalla','92',206),(3330,'Kilinochchi','42',206),(3331,'Kurunegala',NULL,206),(3332,'Madakalpuwa','51',206),(3333,'Maha Nuwara',NULL,206),(3334,'Malwana',NULL,206),(3335,'Mannarama',NULL,206),(3336,'Matale','22',206),(3337,'Matara','32',206),(3338,'Monaragala',NULL,206),(3339,'Mullaitivu',NULL,206),(3340,'North Eastern Province','7',206),(3341,'North Western Province','6',206),(3342,'Nuwara Eliya','23',206),(3343,'Polonnaruwa','72',206),(3344,'Puttalama','62',206),(3345,'Ratnapuraya','91',206),(3346,'Southern Province','3',206),(3347,'Tirikunamalaya','53',206),(3348,'Tuscany',NULL,206),(3349,'Vavuniyawa',NULL,206),(3350,'Western Province','1',206),(3351,'Yapanaya',NULL,206),(3352,'kadawatha',NULL,206),(3353,'A\'ali-an-Nil',NULL,207),(3354,'Bahr-al-Jabal',NULL,207),(3355,'Central Equatoria',NULL,207),(3356,'Gharb Bahr-al-Ghazal',NULL,207),(3357,'Gharb Darfur',NULL,207),(3358,'Gharb Kurdufan',NULL,207),(3359,'Gharb-al-Istiwa\'iyah',NULL,207),(3360,'Janub Darfur',NULL,207),(3361,'Janub Kurdufan','KS',207),(3362,'Junqali',NULL,207),(3363,'Kassala','KA',207),(3364,'Nahr-an-Nil','NR',207),(3365,'Shamal Bahr-al-Ghazal',NULL,207),(3366,'Shamal Darfur',NULL,207),(3367,'Shamal Kurdufan',NULL,207),(3368,'Sharq-al-Istiwa\'iyah',NULL,207),(3369,'Sinnar','SI',207),(3370,'Warab',NULL,207),(3371,'Wilayat al Khartum',NULL,207),(3372,'al-Bahr-al-Ahmar','RS',207),(3373,'al-Buhayrat',NULL,207),(3374,'al-Jazirah','GZ',207),(3375,'al-Khartum',NULL,207),(3376,'al-Qadarif',NULL,207),(3377,'al-Wahdah',NULL,207),(3378,'an-Nil-al-Abyad',NULL,207),(3379,'an-Nil-al-Azraq',NULL,207),(3380,'ash-Shamaliyah','NO',207),(3381,'Brokopondo','BR',208),(3382,'Commewijne','CM',208),(3383,'Coronie','CR',208),(3384,'Marowijne','MA',208),(3385,'Nickerie','NI',208),(3386,'Para','PR',208),(3387,'Paramaribo','PM',208),(3388,'Saramacca','SA',208),(3389,'Wanica','WA',208),(3390,'Svalbard',NULL,209),(3391,'Hhohho','HH',210),(3392,'Lubombo','LU',210),(3393,'Manzini','MA',210),(3394,'Shiselweni','SH',210),(3395,'Alvsborgs Lan',NULL,211),(3396,'Angermanland',NULL,211),(3397,'Blekinge',NULL,211),(3398,'Bohuslan',NULL,211),(3399,'Dalarna',NULL,211),(3400,'Gavleborg',NULL,211),(3401,'Gaza',NULL,211),(3402,'Gotland','I',211),(3403,'Halland',NULL,211),(3404,'Jamtland',NULL,211),(3405,'Jonkoping','F',211),(3406,'Kalmar','H',211),(3407,'Kristianstads',NULL,211),(3408,'Kronoberg','G',211),(3409,'Norrbotten',NULL,211),(3410,'Orebro',NULL,211),(3411,'Ostergotland',NULL,211),(3412,'Saltsjo-Boo',NULL,211),(3413,'Skane',NULL,211),(3414,'Smaland',NULL,211),(3415,'Sodermanland','E',211),(3416,'Stockholm',NULL,211),(3417,'Uppsala',NULL,211),(3418,'Varmland','U',211),(3419,'Vasterbotten',NULL,211),(3420,'Vastergotland',NULL,211),(3421,'Vasternorrland',NULL,211),(3422,'Vastmanland',NULL,211),(3423,'Vastra Gotaland',NULL,211),(3424,'Aargau','AG',212),(3425,'Appenzell Inner-Rhoden','AI',212),(3426,'Appenzell-Ausser Rhoden','AR',212),(3427,'Basel-Landschaft','BL',212),(3428,'Basel-Stadt','BS',212),(3429,'Bern','BE',212),(3430,'Canton Ticino',NULL,212),(3431,'Fribourg','FR',212),(3432,'Geneve','GE',212),(3433,'Glarus','GL',212),(3434,'Graubunden','GR',212),(3435,'Heerbrugg',NULL,212),(3436,'Jura','JU',212),(3437,'Kanton Aargau',NULL,212),(3438,'Luzern','LU',212),(3439,'Morbio Inferiore',NULL,212),(3440,'Muhen',NULL,212),(3441,'Neuchatel',NULL,212),(3442,'Nidwalden',NULL,212),(3443,'Obwalden','OW',212),(3444,'Sankt Gallen',NULL,212),(3445,'Schaffhausen','SH',212),(3446,'Schwyz','SZ',212),(3447,'Solothurn','SO',212),(3448,'Thurgau','TG',212),(3449,'Ticino',NULL,212),(3450,'Uri',NULL,212),(3451,'Valais',NULL,212),(3452,'Vaud',NULL,212),(3453,'Vauffelin',NULL,212),(3454,'Zug',NULL,212),(3455,'Zurich',NULL,212),(3456,'Aleppo',NULL,213),(3457,'Dar\'a','DR',213),(3458,'Dayr-az-Zawr','DY',213),(3459,'Dimashq','DI',213),(3460,'Halab','HL',213),(3461,'Hamah','HM',213),(3462,'Hims','HI',213),(3463,'Idlib',NULL,213),(3464,'Madinat Dimashq',NULL,213),(3465,'Tartus',NULL,213),(3466,'al-Hasakah',NULL,213),(3467,'al-Ladhiqiyah',NULL,213),(3468,'al-Qunaytirah',NULL,213),(3469,'ar-Raqqah',NULL,213),(3470,'as-Suwayda',NULL,213),(3471,'Changhua County','CHA',214),(3472,'Chiayi County','CYI',214),(3473,'Chiayi City',NULL,214),(3474,'Taipei City','TPE',214),(3475,'Hsinchu County','HSZ',214),(3476,'Hsinchu City',NULL,214),(3477,'Hualien County',NULL,214),(3480,'Kaohsiung City',NULL,214),(3481,'Keelung City','KEE',214),(3482,'Kinmen County','KIN',214),(3483,'Miaoli County',NULL,214),(3484,'Nantou County',NULL,214),(3486,'Penghu County',NULL,214),(3487,'Pingtung County',NULL,214),(3488,'Taichung City',NULL,214),(3492,'Tainan City',NULL,214),(3493,'New Taipei City',NULL,214),(3495,'Taitung County',NULL,214),(3496,'Taoyuan City','TAO',214),(3497,'Yilan County','ILA',214),(3498,'YunLin County','YUN',214),(3500,'Dushanbe','DU',215),(3501,'Gorno-Badakhshan',NULL,215),(3502,'Karotegin',NULL,215),(3503,'Khatlon','KT',215),(3504,'Sughd','SU',215),(3505,'Arusha','01',216),(3506,'Dar es Salaam','02',216),(3507,'Dodoma','03',216),(3508,'Iringa','04',216),(3509,'Kagera','05',216),(3510,'Kigoma','08',216),(3511,'Kilimanjaro','09',216),(3512,'Lindi','12',216),(3513,'Mara','13',216),(3514,'Mbeya','14',216),(3515,'Morogoro','16',216),(3516,'Mtwara','17',216),(3517,'Mwanza','18',216),(3518,'Pwani','19',216),(3519,'Rukwa','20',216),(3520,'Ruvuma','21',216),(3521,'Shinyanga','22',216),(3522,'Singida','23',216),(3523,'Tabora','24',216),(3524,'Tanga','25',216),(3525,'Zanzibar and Pemba',NULL,216),(3526,'Amnat Charoen','37',217),(3527,'Ang Thong','15',217),(3528,'Bangkok','38',217),(3529,'Buri Ram','31',217),(3530,'Chachoengsao','21',217),(3531,'Chai Nat','18',217),(3532,'Chaiyaphum','36',217),(3533,'Changwat Chaiyaphum',NULL,217),(3534,'Chanthaburi','22',217),(3535,'Chiang Mai','50',217),(3537,'Chon Buri','20',217),(3538,'Chumphon','86',217),(3539,'Kalasin','46',217),(3540,'Kamphaeng Phet','62',217),(3541,'Kanchanaburi','71',217),(3542,'Khon Kaen','40',217),(3543,'Krabi','81',217),(3544,'Krung Thep','10',217),(3545,'Lampang','52',217),(3546,'Lamphun','51',217),(3547,'Loei','42',217),(3548,'Lop Buri','16',217),(3549,'Mae Hong Son','58',217),(3550,'Maha Sarakham','44',217),(3551,'Mukdahan','49',217),(3552,'Nakhon Nayok','26',217),(3553,'Nakhon Pathom','73',217),(3554,'Nakhon Phanom','48',217),(3555,'Nakhon Ratchasima','30',217),(3556,'Nakhon Sawan','60',217),(3557,'Nakhon Si Thammarat','80',217),(3558,'Nan','55',217),(3559,'Narathiwat','96',217),(3560,'Nong Bua Lam Phu','39',217),(3561,'Nong Khai','43',217),(3562,'Nonthaburi','12',217),(3563,'Pathum Thani','13',217),(3564,'Pattani','94',217),(3565,'Phangnga','82',217),(3566,'Phatthalung','93',217),(3567,'Phayao','56',217),(3568,'Phetchabun','67',217),(3569,'Phetchaburi','76',217),(3570,'Phichit','66',217),(3571,'Phitsanulok','65',217),(3572,'Phra Nakhon Si Ayutthaya','14',217),(3573,'Phrae','54',217),(3574,'Phuket','83',217),(3575,'Prachin Buri','25',217),(3576,'Prachuap Khiri Khan','77',217),(3577,'Ranong','85',217),(3578,'Ratchaburi','70',217),(3579,'Rayong','21',217),(3580,'Roi Et','45',217),(3581,'Sa Kaeo','27',217),(3582,'Sakon Nakhon','47',217),(3583,'Samut Prakan','11',217),(3584,'Samut Sakhon','74',217),(3585,'Samut Songkhran','75',217),(3586,'Saraburi','19',217),(3587,'Satun','91',217),(3588,'Si Sa Ket','33',217),(3589,'Sing Buri','17',217),(3590,'Songkhla','90',217),(3591,'Sukhothai','64',217),(3592,'Suphan Buri','72',217),(3593,'Surat Thani','84',217),(3594,'Surin','32',217),(3595,'Tak','63',217),(3596,'Trang','92',217),(3597,'Trat','23',217),(3598,'Ubon Ratchathani','34',217),(3599,'Udon Thani','41',217),(3600,'Uthai Thani','61',217),(3601,'Uttaradit','53',217),(3602,'Yala','95',217),(3603,'Yasothon','35',217),(3604,'Centre','C',218),(3605,'Kara','K',218),(3606,'Maritime','M',218),(3607,'Plateaux','P',218),(3608,'Savanes','S',218),(3609,'Atafu',NULL,219),(3610,'Fakaofo',NULL,219),(3611,'Nukunonu',NULL,219),(3612,'Eua','01',220),(3613,'Ha\'apai','02',220),(3614,'Niuas','03',220),(3615,'Tongatapu','04',220),(3616,'Vava\'u','05',220),(3617,'Arima-Tunapuna-Piarco','ARI',221),(3618,'Caroni',NULL,221),(3619,'Chaguanas','CHA',221),(3620,'Couva-Tabaquite-Talparo','CTT',221),(3621,'Diego Martin','DMN',221),(3622,'Glencoe',NULL,221),(3623,'Penal Debe',NULL,221),(3624,'Point Fortin','PTF',221),(3625,'Port of Spain','POS',221),(3626,'Princes Town','PRT',221),(3627,'Saint George',NULL,221),(3628,'San Fernando','SFO',221),(3629,'San Juan','SJ',221),(3630,'Sangre Grande','SGE',221),(3631,'Siparia','SIP',221),(3632,'Tobago','TOP',221),(3633,'Aryanah',NULL,222),(3634,'Bajah',NULL,222),(3635,'Bin \'Arus',NULL,222),(3636,'Binzart',NULL,222),(3637,'Gouvernorat de Ariana',NULL,222),(3638,'Gouvernorat de Nabeul',NULL,222),(3639,'Gouvernorat de Sousse',NULL,222),(3640,'Hammamet Yasmine',NULL,222),(3641,'Jundubah',NULL,222),(3642,'Madaniyin',NULL,222),(3643,'Manubah',NULL,222),(3644,'Monastir','52',222),(3645,'Nabeul','21',222),(3646,'Qabis',NULL,222),(3647,'Qafsah',NULL,222),(3648,'Qibili',NULL,222),(3649,'Safaqis',NULL,222),(3650,'Sfax','61',222),(3651,'Sidi Bu Zayd','43',222),(3652,'Silyanah',NULL,222),(3653,'Susah','51',222),(3654,'Tatawin',NULL,222),(3655,'Tawzar',NULL,222),(3656,'Tunis','11',222),(3657,'Zaghwan','22',222),(3658,'al-Kaf',NULL,222),(3659,'al-Mahdiyah',NULL,222),(3660,'al-Munastir',NULL,222),(3661,'al-Qasrayn',NULL,222),(3662,'al-Qayrawan',NULL,222),(3663,'Adana','01',223),(3664,'Adiyaman','02',223),(3665,'Afyon','03',223),(3666,'Agri',NULL,223),(3667,'Aksaray','68',223),(3668,'Amasya','05',223),(3669,'Ankara','06',223),(3670,'Antalya','07',223),(3671,'Ardahan','75',223),(3672,'Artvin','08',223),(3673,'Aydin','09',223),(3674,'Balikesir','10',223),(3675,'Bartin','74',223),(3676,'Batman','72',223),(3677,'Bayburt','69',223),(3678,'Bilecik','11',223),(3679,'Bingol','12',223),(3680,'Bitlis','13',223),(3681,'Bolu','14',223),(3682,'Burdur','15',223),(3683,'Bursa','16',223),(3684,'Canakkale',NULL,223),(3685,'Cankiri',NULL,223),(3686,'Corum',NULL,223),(3687,'Denizli','20',223),(3688,'Diyarbakir','21',223),(3689,'Duzce','81',223),(3690,'Edirne','22',223),(3691,'Elazig','23',223),(3692,'Erzincan','24',223),(3693,'Erzurum','25',223),(3694,'Eskisehir','26',223),(3695,'Gaziantep','27',223),(3696,'Giresun','28',223),(3697,'Gumushane','29',223),(3698,'Hakkari','30',223),(3699,'Hatay','31',223),(3700,'Icel',NULL,223),(3701,'Igdir','76',223),(3702,'Isparta','32',223),(3703,'Istanbul',NULL,223),(3704,'Izmir',NULL,223),(3705,'Kahramanmaras',NULL,223),(3706,'Karabuk','78',223),(3707,'Karaman','70',223),(3708,'Kars','36',223),(3709,'Karsiyaka',NULL,223),(3710,'Kastamonu',NULL,223),(3711,'Kayseri','38',223),(3712,'Kilis','79',223),(3713,'Kirikkale','71',223),(3714,'Kirklareli',NULL,223),(3715,'Kirsehir',NULL,223),(3716,'Kocaeli','',223),(3717,'Konya',NULL,223),(3718,'Kutahya',NULL,223),(3719,'Lefkosa',NULL,223),(3720,'Malatya',NULL,223),(3721,'Manisa','45',223),(3722,'Mardin','47',223),(3723,'Mugla',NULL,223),(3724,'Mus',NULL,223),(3725,'Nevsehir','50',223),(3726,'Nigde','51',223),(3727,'Ordu','52',223),(3728,'Osmaniye','80',223),(3729,'Rize','53',223),(3730,'Sakarya','54',223),(3731,'Samsun','55',223),(3732,'Sanliurfa',NULL,223),(3733,'Siirt','56',223),(3734,'Sinop',NULL,223),(3735,'Sirnak',NULL,223),(3736,'Sivas','58',223),(3737,'Tekirdag','59',223),(3738,'Tokat','60',223),(3739,'Trabzon','61',223),(3740,'Tunceli','62',223),(3741,'Usak','64',223),(3742,'Van','65',223),(3743,'Yalova','77',223),(3744,'Yozgat','66',223),(3745,'Zonguldak','67',223),(3746,'Ahal','A',224),(3747,'Asgabat','S',224),(3748,'Balkan','B',224),(3749,'Dasoguz','D',224),(3750,'Lebap','L',224),(3751,'Mari','M',224),(3752,'Grand Turk',NULL,225),(3753,'South Caicos and East Caicos',NULL,225),(3754,'Funafuti','FUN',226),(3755,'Nanumanga','NMG',226),(3756,'Nanumea','NMA',226),(3757,'Niutao','NIT',226),(3758,'Nui','NUI',226),(3759,'Nukufetau','NKF',226),(3760,'Nukulaelae','NKL',226),(3761,'Vaitupu','VAI',226),(3762,'Central','C',227),(3763,'Eastern','E',227),(3764,'Northern','N',227),(3765,'Western','W',227),(3766,'Cherkas\'ka','71',228),(3767,'Chernihivs\'ka','77',228),(3768,'Chernivets\'ka',NULL,228),(3769,'Crimea',NULL,228),(3770,'Dnipropetrovska','12',228),(3771,'Donets\'ka','14',228),(3772,'Ivano-Frankivs\'ka','26',228),(3773,'Kharkiv',NULL,228),(3774,'Kharkov',NULL,228),(3775,'Khersonska','65',228),(3776,'Khmel\'nyts\'ka','68',228),(3777,'Kirovohrad','35',228),(3778,'Krym',NULL,228),(3779,'Kyyiv',NULL,228),(3780,'Kyyivs\'ka','32',228),(3781,'L\'vivs\'ka','9',228),(3782,'Luhans\'ka','46',228),(3783,'Mykolayivs\'ka','48',228),(3784,'Odes\'ka','51',228),(3785,'Odessa',NULL,228),(3786,'Poltavs\'ka','53',228),(3787,'Rivnens\'ka','56',228),(3788,'Sevastopol\'','40',228),(3789,'Sums\'ka','59',228),(3790,'Ternopil\'s\'ka','61',228),(3791,'Volyns\'ka','07',228),(3792,'Vynnyts\'ka','05',228),(3793,'Zakarpats\'ka','21',228),(3794,'Zaporizhia','23',228),(3795,'Zhytomyrs\'ka','18',228),(3796,'Abu Zabi','AZ',229),(3797,'Ajman',NULL,229),(3798,'Dubai','DU',229),(3799,'Ras al-Khaymah','RK',229),(3800,'Sharjah',NULL,229),(3801,'Sharjha',NULL,229),(3802,'Umm al Qaywayn','UQ',229),(3803,'al-Fujayrah','FU',229),(3804,'ash-Shariqah','SH',229),(3805,'Aberdeen','ABE',230),(3806,'Aberdeenshire','ABD',230),(3807,'Argyll','AG',230),(3808,'Armagh','AR',230),(3809,'Bedfordshire',NULL,230),(3810,'Belfast','BFS',230),(3811,'Berkshire',NULL,230),(3812,'Birmingham','BIR',230),(3813,'Brechin',NULL,230),(3814,'Bridgnorth',NULL,230),(3815,'Bristol','BST',230),(3816,'Buckinghamshire','BKM',230),(3817,'Cambridge','',230),(3818,'Cambridgeshire','CAM',230),(3819,'Channel Islands',NULL,230),(3820,'Cheshire','CHE',230),(3821,'Cleveland',NULL,230),(3822,'Co Fermanagh',NULL,230),(3823,'Conwy',NULL,230),(3824,'Cornwall',NULL,230),(3825,'Coventry','COV',230),(3826,'Craven Arms',NULL,230),(3827,'Cumbria','CMA',230),(3828,'Denbighshire','DEN',230),(3829,'Derby','DER',230),(3830,'Derbyshire','DBY',230),(3831,'Devon','DEV',230),(3832,'Dial Code Dungannon',NULL,230),(3833,'Didcot',NULL,230),(3834,'Dorset','DOR',230),(3835,'Dunbartonshire',NULL,230),(3836,'Durham',NULL,230),(3837,'East Dunbartonshire','EDU',230),(3838,'East Lothian','ELN',230),(3839,'East Midlands',NULL,230),(3840,'East Sussex','ESX',230),(3841,'East Yorkshire',NULL,230),(3842,'England','ENG',230),(3843,'Essex','ESS',230),(3844,'Fermanagh',NULL,230),(3845,'Fife','FIF',230),(3846,'Flintshire','FL',230),(3847,'Fulham',NULL,230),(3848,'Gainsborough',NULL,230),(3849,'Glocestershire',NULL,230),(3850,'Gwent',NULL,230),(3851,'Hampshire','HAM',230),(3852,'Hants',NULL,230),(3853,'Herefordshire','HEF',230),(3854,'Hertfordshire','HRT',230),(3855,'Ireland',NULL,230),(3856,'Isle Of Man',NULL,230),(3857,'Isle of Wight',NULL,230),(3858,'Kenford',NULL,230),(3859,'Kent',NULL,230),(3860,'Kilmarnock',NULL,230),(3861,'Lanarkshire',NULL,230),(3862,'Lancashire','LAN',230),(3863,'Leicestershire','LEC',230),(3864,'Lincolnshire','LIN',230),(3865,'Llanymynech',NULL,230),(3866,'London','LND',230),(3867,'Ludlow',NULL,230),(3868,'Manchester','MAN',230),(3869,'Mayfair',NULL,230),(3870,'Merseyside',NULL,230),(3871,'Mid Glamorgan',NULL,230),(3872,'Middlesex',NULL,230),(3873,'Mildenhall',NULL,230),(3874,'Monmouthshire',NULL,230),(3875,'Newton Stewart',NULL,230),(3876,'Norfolk','NFK',230),(3877,'North Humberside',NULL,230),(3878,'North Yorkshire','NYK',230),(3879,'Northamptonshire',NULL,230),(3880,'Northants',NULL,230),(3881,'Northern Ireland',NULL,230),(3882,'Northumberland','NBL',230),(3883,'Nottinghamshire','NTT',230),(3884,'Oxford','OXF',230),(3885,'Powys','POW',230),(3886,'Roos-shire',NULL,230),(3887,'SUSSEX',NULL,230),(3888,'Sark',NULL,230),(3889,'Scotland','SCT',230),(3890,'Scottish Borders','SCB',230),(3891,'Shropshire',NULL,230),(3892,'Somerset',NULL,230),(3893,'South Glamorgan',NULL,230),(3894,'South Wales',NULL,230),(3895,'South Yorkshire',NULL,230),(3896,'Southwell',NULL,230),(3897,'Staffordshire',NULL,230),(3898,'Strabane',NULL,230),(3899,'Suffolk',NULL,230),(3900,'Surrey','SRY',230),(3901,'Sussex',NULL,230),(3902,'Twickenham',NULL,230),(3903,'Tyne and Wear',NULL,230),(3904,'Tyrone',NULL,230),(3905,'Utah',NULL,230),(3906,'Wales',NULL,230),(3907,'Warwickshire','WAR',230),(3908,'West Lothian','WLN',230),(3909,'West Midlands',NULL,230),(3910,'West Sussex',NULL,230),(3911,'West Yorkshire',NULL,230),(3912,'Whissendine','NIL',230),(3913,'Wiltshire','WIL',230),(3914,'Wokingham','WOK',230),(3915,'Worcestershire','WOR',230),(3916,'Wrexham','WRX',230),(3917,'Wurttemberg',NULL,230),(3918,'Yorkshire','YO',230),(3919,'Alabama','AL',1),(3920,'Alaska','AK',1),(3921,'Arizona','AZ',1),(3922,'Arkansas','AR',1),(3923,'Byram',NULL,1),(3924,'California','CA',1),(3925,'Cokato',NULL,1),(3926,'Colorado','CO',1),(3927,'Connecticut','CT',1),(3928,'Delaware','DE',1),(3929,'District of Columbia','DC',1),(3930,'Florida','FL',1),(3931,'Georgia','GA',1),(3932,'Hawaii','HI',1),(3933,'Idaho','ID',1),(3934,'Illinois','IL',1),(3935,'Indiana','IN',1),(3937,'Kansas','KS',1),(3938,'Kentucky','KY',1),(3939,'Louisiana','LA',1),(3940,'Lowa','IA',1),(3941,'Maine','ME',1),(3942,'Maryland','MD',1),(3943,'Massachusetts','MA',1),(3944,'Medfield',NULL,1),(3945,'Michigan','MI',1),(3946,'Minnesota','MN',1),(3947,'Mississippi','MS',1),(3948,'Missouri','MO',1),(3949,'Montana','MT',1),(3950,'Nebraska','NE',1),(3951,'Nevada','NV',1),(3952,'New Hampshire','NH',1),(3953,'New Jersey','NJ',1),(3955,'New Mexico','NM',1),(3956,'New York','NY',1),(3957,'North Carolina','NC',1),(3958,'North Dakota','ND',1),(3959,'Ohio','OH',1),(3960,'Oklahoma','OK',1),(3961,'Ontario','ON',1),(3962,'Oregon','OR',1),(3963,'Pennsylvania','PA',1),(3964,'Ramey',NULL,1),(3965,'Rhode Island','RI',1),(3966,'South Carolina','SC',1),(3967,'South Dakota','SD',1),(3968,'Sublimity',NULL,1),(3969,'Tennessee','TN',1),(3970,'Texas',NULL,1),(3971,'Trimble',NULL,1),(3972,'Utah',NULL,1),(3973,'Vermont',NULL,1),(3974,'Virginia',NULL,1),(3975,'Washington',NULL,1),(3976,'West Virginia',NULL,1),(3977,'Wisconsin',NULL,1),(3978,'Wyoming',NULL,1),(3979,'United States Minor Outlying I',NULL,232),(3980,'Artigas','AR',233),(3981,'Canelones','CA',233),(3982,'Cerro Largo','NIL',233),(3983,'Colonia','CO',233),(3984,'Durazno','DU',233),(3985,'FLorida','FD',233),(3986,'Flores','FS',233),(3987,'Lavalleja','LA',233),(3988,'Maldonado','MA',233),(3989,'Montevideo','MO',233),(3990,'Paysandu','PA',233),(3991,'Rio Negro','RN',233),(3992,'Rivera','RV',233),(3993,'Rocha','RO',233),(3994,'Salto','SA',233),(3995,'San Jose','SJ',233),(3996,'Soriano','SO',233),(3997,'Tacuarembo','TA',233),(3998,'Treinta y Tres','TT',233),(3999,'Andijon','AN',234),(4000,'Buhoro','NIL',234),(4001,'Buxoro Viloyati','BO',234),(4002,'Cizah',NULL,234),(4003,'Fargona','FA',234),(4004,'Horazm',NULL,234),(4005,'Kaskadar',NULL,234),(4006,'Korakalpogiston',NULL,234),(4007,'Namangan',NULL,234),(4008,'Navoi',NULL,234),(4009,'Samarkand',NULL,234),(4010,'Sirdare','SI',234),(4011,'Surhondar',NULL,234),(4012,'Toskent','TO',234),(4013,'Malampa','MAP',235),(4014,'Penama','PAM',235),(4015,'Sanma','SAM',235),(4016,'Shefa','SEE',235),(4017,'Tafea','TAE',235),(4018,'Torba','TOB',235),(4019,'Vatican City State (Holy See)',NULL,236),(4020,'Amazonas','Z',237),(4021,'Anzoategui','B',237),(4022,'Apure','C',237),(4023,'Aragua','D',237),(4024,'Barinas','E',237),(4025,'Bolivar','F',237),(4026,'Carabobo','G',237),(4027,'Cojedes','H',237),(4028,'Delta Amacuro','Y',237),(4029,'Distrito Federal','A',237),(4030,'Falcon','I',237),(4031,'Guarico','J',237),(4032,'Lara','K',237),(4033,'Merida','L',237),(4034,'Miranda','M',237),(4035,'Monagas','N',237),(4036,'Nueva Esparta','O',237),(4037,'Portuguesa','P',237),(4038,'Sucre','R',237),(4039,'Tachira','S',237),(4040,'Trujillo','T',237),(4041,'Vargas',NULL,237),(4042,'Yaracuy','U',237),(4043,'Zulia','V',237),(4044,'Bac Giang','54',238),(4045,'Binh Dinh','31',238),(4046,'Binh Duong','57',238),(4047,'Da Nang','72',238),(4048,'Dong Bang Song Cuu Long',NULL,238),(4049,'Dong Bang Song Hong',NULL,238),(4050,'Dong Nai','39',238),(4051,'Dong Nam Bo',NULL,238),(4052,'Duyen Hai Mien Trung',NULL,238),(4053,'Hanoi','HN',238),(4054,'Hung Yen','66',238),(4055,'Khu Bon Cu',NULL,238),(4056,'Long An','41',238),(4057,'Mien Nui Va Trung Du',NULL,238),(4058,'Thai Nguyen','69',238),(4059,'Thanh Pho Ho Chi Minh',NULL,238),(4060,'Thu Do Ha Noi',NULL,238),(4061,'Tinh Can Tho',NULL,238),(4062,'Tinh Da Nang',NULL,238),(4063,'Tinh Gia Lai',NULL,238),(4064,'Anegada',NULL,239),(4065,'Jost van Dyke',NULL,239),(4066,'Tortola',NULL,239),(4067,'Saint Croix',NULL,240),(4068,'Saint John',NULL,240),(4069,'Saint Thomas',NULL,240),(4070,'Alo','AL',241),(4071,'Singave','SG',241),(4072,'Uvea','UV',241),(4073,'Bu Jaydur',NULL,242),(4074,'Wad-adh-Dhahab',NULL,242),(4075,'al-\'Ayun',NULL,242),(4076,'as-Samarah',NULL,242),(4077,'\'Adan','AD',243),(4078,'Abyan','AB',243),(4079,'Dhamar','DH',243),(4080,'Hadramaut',NULL,243),(4081,'Hajjah',NULL,243),(4082,'Hudaydah',NULL,243),(4083,'Ibb','IB',243),(4084,'Lahij','LA',243),(4085,'Ma\'rib','MA',243),(4086,'Madinat San\'a',NULL,243),(4087,'Sa\'dah','SD',243),(4088,'Sana','SN',243),(4089,'Shabwah',NULL,243),(4090,'Ta\'izz',NULL,243),(4091,'al-Bayda',NULL,243),(4092,'al-Hudaydah',NULL,243),(4093,'al-Jawf',NULL,243),(4094,'al-Mahrah',NULL,243),(4095,'al-Mahwit',NULL,243),(4096,'Central Serbia',NULL,244),(4097,'Kosovo and Metohija',NULL,244),(4098,'Montenegro',NULL,244),(4099,'Republic of Serbia',NULL,244),(4100,'Serbia',NULL,244),(4101,'Vojvodina',NULL,244),(4102,'Central','02',245),(4103,'Copperbelt','08',245),(4104,'Eastern','03',245),(4105,'Luapala','04',245),(4106,'Lusaka','09',245),(4107,'North-Western','06',245),(4108,'Northern','05',245),(4109,'Southern','07',245),(4110,'Western','01',245),(4111,'Bulawayo',NULL,246),(4112,'Harare',NULL,246),(4113,'Manicaland',NULL,246),(4114,'Mashonaland Central',NULL,246),(4115,'Mashonaland East',NULL,246),(4116,'Mashonaland West',NULL,246),(4117,'Masvingo',NULL,246),(4118,'Matabeleland North',NULL,246),(4119,'Matabeleland South',NULL,246),(4120,'Midlands',NULL,246),(4121,'Lienchiang County',NULL,214);


