CREATE TABLE `stateprovince` (
  `StateProvinceID` int(10) NOT NULL AUTO_INCREMENT,
  `StateProvinceCode` char(3) CHARACTER SET utf8 NOT NULL,
  `CountryRegionCode` varchar(3) CHARACTER SET utf8 NOT NULL,
  `Name` varchar(50) CHARACTER SET utf8 NOT NULL,
  `ModifiedDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `rowguid` varchar(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`StateProvinceID`),
  UNIQUE KEY `AK_StateProvince_Name` (`Name`),
  UNIQUE KEY `AK_StateProvince_StateProvinceC` (`StateProvinceCode`,`CountryRegionCode`),
  KEY `FK_StateProvince_CountryRegion` (`CountryRegionCode`),
  CONSTRAINT `FK_StateProvince_CountryRegion` FOREIGN KEY (`CountryRegionCode`) REFERENCES `countryregion` (`CountryRegionCode`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=latin1;

INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (1,'AB','CA ','Alberta','2002-12-04 08:19:35','D0DC2FDB-AF00-488A-8FDF-818024B0AB63');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (2,'AK','US ','Alaska','2002-12-04 08:19:35','9A201ADA-5CE7-4680-AE1F-46F006793114');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (3,'AL','US ','Alabama','2002-12-04 08:19:35','22248F13-3877-40B5-9206-D62761BED52E');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (4,'AR','US ','Arkansas','2002-12-04 08:19:35','629C0DAD-DE26-4718-A01E-7F334ADDBCFC');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (5,'AS','AS ','American Samoa','2002-12-04 08:19:35','A6F8DC90-38DA-4E3E-AA72-E94418D23D4F');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (6,'AZ','US ','Arizona','2002-12-04 08:19:35','ACC2E639-E32B-4E1E-BED7-263D6B57137A');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (7,'BC','CA ','British Columbia','2002-12-04 08:19:35','2176A6C4-2B68-45B8-ADB4-5E9CDD36F27B');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (8,'BY','DE ','Bayern','2002-12-04 08:19:35','923A63C6-6F9E-496F-A037-1B18A78A2660');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (9,'CA','US ','California','2002-12-04 08:19:35','0D29176C-49BD-4AAD-863A-3055A1FE5165');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (10,'CO','US ','Colorado','2002-12-04 08:19:35','D74010B9-03A8-470C-9DED-3C2CC4AABD75');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (11,'CT','US ','Connecticut','2002-12-04 08:19:35','D1C7175C-8A7A-46D0-A26C-31B96DF68E2D');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (12,'DC','US ','District of Columbia','2002-12-04 08:19:35','8476DB1D-03E3-4A6A-8D8A-29BD988F3274');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (13,'DE','US ','Delaware','2002-12-04 08:19:35','B3C1D75B-61E2-4976-B30C-7EFE8BB386AB');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (14,'ENG','GB ','England','2002-12-04 08:19:35','7A89A9BD-3608-4B02-A31F-EB062889215C');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (15,'FL','US ','Florida','2002-12-04 08:19:35','A1FB6D56-6D58-476F-92A5-6C44A7DF581C');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (16,'FM','FM ','Micronesia','2002-12-04 08:19:35','0638C19E-1D5D-4729-9EC8-139D67B04A5D');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (17,'GA','US ','Georgia','2002-12-04 08:19:35','D2B89AE6-5E6D-4C85-B999-E255B3C9B6AD');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (18,'GU','US ','Guam','2002-12-04 08:19:35','A21A2E38-F16B-426A-AE16-0AEB828CAB5A');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (19,'HE','DE ','Hessen','2002-12-04 08:19:35','47084A39-F821-4AC8-AF66-7A95DC1B62F6');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (20,'HH','DE ','Hamburg','2002-12-04 08:19:35','17090A74-16F3-42EA-A307-350F090A77C3');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (21,'HI','US ','Hawaii','2002-12-04 08:19:35','B5183451-FBFD-477D-BAA2-14CA9140A9FB');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (22,'IA','US ','Iowa','2002-12-04 08:19:35','D5BDF949-BD3F-4FDB-AB26-9CD8FA155C4C');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (23,'ID','US ','Idaho','2002-12-04 08:19:35','D099C36A-1E8D-4FA8-82CD-B86AA4F2AD7A');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (24,'IL','US ','Illinois','2002-12-04 08:19:35','4A01C80D-B955-49F6-B072-C8EA8444E281');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (25,'IN','US ','Indiana','2002-12-04 08:19:35','A137D16E-3F62-417A-80BF-ED57D87ED663');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (26,'KS','US ','Kansas','2002-12-04 08:19:35','0CF49DB4-C567-4761-A4A1-A717F4FA7A4F');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (27,'KY','US ','Kentucky','2002-12-04 08:19:35','11D83210-5753-4E16-9890-835C496F3A96');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (28,'LA','US ','Louisiana','2002-12-04 08:19:35','92F6ECD0-3ACB-470A-97EC-58B76E998C77');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (29,'LB','CA ','Labrador','2002-12-04 08:19:35','FA48D425-6F6A-4CC3-9D4B-EBB0D2E3D13F');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (30,'MA','US ','Massachusetts','2002-12-04 08:19:35','3F7510C4-9769-40E4-835A-990A323FBE8E');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (31,'MB','CA ','Manitoba','2002-12-04 08:19:35','95392AED-90CC-462B-898C-E75B0C837838');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (32,'MD','US ','Maryland','2002-12-04 08:19:35','48433896-7744-4C3B-9D41-1D10041C03A6');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (33,'ME','US ','Maine','2002-12-04 08:19:35','A0A0749B-F87A-4A39-A887-E361269F16E6');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (34,'MH','MH ','Marshall Islands','2002-12-04 08:19:35','58680DC0-A4B7-45F3-8EB9-8E957B4B5587');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (35,'MI','US ','Michigan','2002-12-04 08:19:35','24F6F68C-8E64-4FC8-9BAE-FC41356627FC');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (36,'MN','US ','Minnesota','2002-12-04 08:19:35','9F8CE8D4-6776-4B01-80CF-E80C4C6EA75C');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (37,'MO','US ','Missouri','2002-12-04 08:19:35','99F0A3F1-429A-4BAC-825A-0C45416C77A0');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (38,'MP','MP ','Northern Mariana Islands','2002-12-04 08:19:35','9CEBECFB-7E8F-438E-BE79-0B65E7228C31');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (39,'MS','US ','Mississippi','2002-12-04 08:19:35','B934B12D-19C7-4C9C-87CE-4055B1B3FECE');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (40,'MT','US ','Montana','2002-12-04 08:19:35','E2E8923E-59A1-4BFB-9C6D-8BCF32B05292');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (41,'NB','CA ','Brunswick','2002-12-04 08:19:35','9FB814A6-70FA-4012-B645-A585AA262298');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (42,'NC','US ','North Carolina','2002-12-04 08:19:35','E5BA3F60-38F6-4BEB-A59F-55C1695A00C7');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (43,'ND','US ','North dakota','2002-12-04 08:19:35','F9FFF4B5-DD39-46F3-83EA-2194B21B2A4B');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (44,'NE','US ','Nebraska','2002-12-04 08:19:35','96D42AC3-717A-4754-A8F7-7856FA42DE4F');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (45,'NF','CA ','Newfoundland','2002-12-04 08:19:35','895FF35A-6A32-46D9-BE4A-5C202B3077B4');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (46,'NH','US ','New Hampshire','2002-12-04 08:19:35','A66BC40E-9372-4717-9DA0-7CEB10366A95');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (47,'NJ','US ','New Jersey','2002-12-04 08:19:35','C976C154-CE84-432C-825B-8F134660A2E3');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (48,'NM','US ','New Mexico','2002-12-04 08:19:35','C80F5E3B-84DE-44BB-9C26-FCA8BFF0E6E5');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (49,'NS','CA ','Nova Scotia','2002-12-04 08:19:35','57E4BDC6-07A1-4F59-8245-E463F37366CB');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (50,'NSW','AU ','New South Wales','2002-12-04 08:19:35','DE25D03F-0BAC-40AF-B2CB-47BF66BBA8B0');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (51,'NT','CA ','Northwest Territories','2002-12-04 08:19:35','2DC9BB81-5662-4CB2-ADCD-297BCE0A136C');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (52,'NV','US ','Nevada','2002-12-04 08:19:35','5A0348DB-1996-43A6-8FBC-5BBEC4C87615');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (53,'NW','DE ','Nordrhein-Westfalen','2002-12-04 08:19:35','CDA9BB86-5FC9-4077-BA0D-058BF631285F');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (54,'NY','US ','New York','2002-12-04 08:19:35','B9EC8484-8775-44B1-AFD2-68F621D62B87');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (55,'OH','US ','Ohio','2002-12-04 08:19:35','9FB168B9-22F7-4266-B022-6D65576DC3C5');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (56,'OK','US ','Oklahoma','2002-12-04 08:19:35','A43FF1E9-A837-41F4-94F9-93D5F23AC256');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (57,'ON','CA ','Ontario','2002-12-04 08:19:35','EEDAD499-D0FA-4F25-BE76-099E3F2A781D');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (58,'OR','US ','Oregon','2002-12-04 08:19:35','A41D2DA2-ABB4-4B1F-9127-D3B384944D40');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (59,'PA','US ','Pennsylvania','2002-12-04 08:19:35','0CB3C39D-2F95-4332-B4C8-309433498140');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (60,'PE','CA ','Prince Edward Island','2002-12-04 08:19:35','012A31CF-902B-4A79-8917-4ECDC1A675AD');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (61,'PR','US ','Puerto Rico','2002-12-04 08:19:35','2372C835-4D41-46A3-BC99-5D8CB744E2C2');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (62,'PW','PW ','Palau','2002-12-04 08:19:35','A78D9CD8-8D57-4E13-B277-553DEDE92C08');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (63,'QC','CA ','Quebec','2002-12-04 08:19:35','13EAF15B-C7E7-496B-942F-DD694BC501B9');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (64,'QLD','AU ','Queensland','2002-12-04 08:19:35','88D89FAE-BEAE-4C0B-888A-FCFC064DCE30');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (65,'RI','US ','Rhode Island','2002-12-04 08:19:35','88D83CA2-C4AD-41A6-BE8E-4A571BEA1786');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (66,'SA','AU ','South Australia','2002-12-04 08:19:35','DB451266-2A59-4F1C-8A6A-2C367A5C8552');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (67,'SC','US ','South Carolina','2002-12-04 08:19:35','B951CB59-1F16-4F22-82F3-3D1C405C0028');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (68,'SD','US ','South Dakota','2002-12-04 08:19:35','04CDD7D8-6DF2-4DC7-9332-4E323D8413EF');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (69,'SK','CA ','Saskatchewan','2002-12-04 08:19:35','F83B553D-0285-472F-9D76-5FE6218D75D8');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (70,'SL','DE ','Saarland','2002-12-04 08:19:35','D7B558AC-BCAB-4A39-B835-7FC7010E103A');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (71,'TAS','AU ','Tasmania','2002-12-04 08:19:35','096EB105-9AE0-4A9B-AFD9-22BFC614F393');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (72,'TN','US ','Tennessee','2002-12-04 08:19:35','F38898B8-09E9-4A5B-B12B-415A0975F828');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (73,'TX','US ','Texas','2002-12-04 08:19:35','0152738B-2061-412D-9BC1-3B2451B27BEE');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (74,'UT','US ','Utah','2002-12-04 08:19:35','A9BB6028-237C-49AD-931A-7EC654EFBB89');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (75,'VA','US ','Virginia','2002-12-04 08:19:35','04550704-515F-4EB4-ADAB-56AFDCD188EA');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (76,'VI','VI ','Virgin Islands','2002-12-04 08:19:35','EC691AED-810D-43F7-8E8E-34D92FC0AE2E');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (77,'VIC','AU ','Victoria','2002-12-04 08:19:35','FE271EB1-FAA3-41CD-9100-61B139994000');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (78,'VT','US ','Vermont','2002-12-04 08:19:35','0065C43A-5727-490D-8618-18F3A614BC62');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (79,'WA','US ','Washington','2002-12-04 08:19:35','853A8E78-019C-40DA-8810-316D55048410');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (80,'WI','US ','Wisconsin','2002-12-04 08:19:35','632669C1-CBE1-46DE-9E9E-A9FC9CBDD64E');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (81,'WV','US ','West Virginia','2002-12-04 08:19:35','8EFAAD16-E8B0-4ED7-B495-B45D7992F427');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (82,'WY','US ','Wyoming','2002-12-04 08:19:35','C01F53D8-BFF0-49F4-8B63-FFBB2D3AE039');
INSERT INTO `stateprovince` (`StateProvinceID`, `StateProvinceCode`, `CountryRegionCode`, `Name`, `ModifiedDate`, `rowguid`) VALUES (83,'YT','CA ','Yukon Territory','2002-12-04 08:19:35','0C6A7698-8B61-4BC2-9C11-DECEC4079D1B');