--
-- Host: localhost    Database: persisters_db_to733
-- ------------------------------------------------------


--
-- Table structure for table `Profiles`
--

CREATE TABLE `Profiles` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `NickName` varchar(255) NOT NULL,
  `Email` varchar(255) NOT NULL DEFAULT '',
  `Password` varchar(40) NOT NULL DEFAULT '',
  `Salt` varchar(10) NOT NULL DEFAULT '',
  `Status` enum('Unconfirmed','Approval','Active','Rejected','Suspended') NOT NULL DEFAULT 'Unconfirmed',
  `Role` tinyint(4) unsigned NOT NULL DEFAULT '1',
  `Couple` int(10) unsigned NOT NULL DEFAULT '0',
  `Sex` varchar(255) NOT NULL DEFAULT '',
  `LookingFor` set('female') NOT NULL DEFAULT '',
  `Headline` varchar(255) NOT NULL,
  `DescriptionMe` text NOT NULL,
  `Country` varchar(255) NOT NULL DEFAULT '',
  `City` varchar(255) NOT NULL,
  `DateOfBirth` date NOT NULL,
  `Featured` tinyint(1) NOT NULL DEFAULT '0',
  `DateReg` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `DateLastEdit` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `DateLastLogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `DateLastNav` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `aff_num` int(10) unsigned NOT NULL DEFAULT '0',
  `Tags` varchar(255) NOT NULL DEFAULT '',
  `zip` varchar(255) NOT NULL,
  `EmailNotify` tinyint(1) NOT NULL DEFAULT '1',
  `LangID` int(11) NOT NULL,
  `UpdateMatch` tinyint(1) NOT NULL DEFAULT '1',
  `Views` int(11) NOT NULL,
  `Rate` float NOT NULL,
  `RateCount` int(11) NOT NULL,
  `CommentsCount` int(11) NOT NULL,
  `PrivacyDefaultGroup` int(11) NOT NULL DEFAULT '3',
  `allow_view_to` int(11) NOT NULL DEFAULT '3',
  `UserStatus` varchar(64) NOT NULL DEFAULT 'online',
  `UserStatusMessage` varchar(255) NOT NULL DEFAULT '',
  `UserStatusMessageWhen` int(10) NOT NULL,
  `Avatar` int(10) unsigned NOT NULL,
  `Height` varchar(255) NOT NULL,
  `Weight` varchar(255) NOT NULL,
  `Income` varchar(255) NOT NULL,
  `Occupation` varchar(255) NOT NULL,
  `SpiritualPractice` enum('--Any--','Agnostic','Atheist','Bahai','Buddhist / Taoist','Christian / Catholic','Christian / LDS','Christian / Protestant','Hindi','Jewish','Muslim / Islam','New Age','Paganism','Rastafarian','Scientology','Sikhism','Spiritual but not religious','Taoism','Unitarianism','Wicca','Other','Christian / Other') DEFAULT NULL,
  `RelationshipStatus` enum('Single','In a Relationship','Engaged','Married','It''s Complicated','In an Open Relationship') DEFAULT NULL,
  `Hobbies` set('Animals','Antiques','Art','Astrology','Beauty','Camping','Concerts','Computer/Video Games','Cooking','Crafts','Cycling','Dancing','Decorating','Drawing','Fashion','Galleries','Gardening','Health','Hiking','Jewelry Making','Kids Arts/Crafts','Knitting','Movies','Museums','Music','Painting','Photography','Play Sports','Programming','Reading','Singing','Sewing','Sculpture','Traveling','Watching Sports','Woodworking','Workout','Writing') NOT NULL DEFAULT '',
  `Interests` text NOT NULL,
  `Ethnicity` enum('Asian','Black/African Descent','East Indian','Latino/Hispanic','Middle Eastern','Native American','Pacific Islander','White/Caucasian','Human','Other') DEFAULT NULL,
  `FavoriteSites` text NOT NULL,
  `FavoriteMusic` text NOT NULL,
  `FavoriteFilms` text NOT NULL,
  `FavoriteBooks` text NOT NULL,
  `FullName` varchar(255) NOT NULL,
  `PoliticalView` enum('--Any--','Very Liberal','Liberal','Middle of The Road','Conservative','Ultra Conservative','Non-Conformist','Other Point of View','Non-Political') DEFAULT NULL,
  `InterestsAltHealing` set('Acupuncture','Bio Feedback','Chiropractic','Energy Therapies','FeldenKrais','Herbalism','Homeopathy','Meditation') NOT NULL DEFAULT '',
  `InterestsArt` set('Crafts','Drawing','Edging','Jewelry Making','Painting','Photography','Videography','Galleries','Museums') NOT NULL DEFAULT '',
  `WomanStatus` set('Single Mother','Single Woman','Involved Woman') NOT NULL DEFAULT '',
  `InterestsBooks` set('Comedy','Drama','Erotica','Fantasy','Fiction','Literary Fiction','Mystery','Non Fiction','Romance','Science','Thrillers','Westerns') NOT NULL DEFAULT '',
  `InterestsEntertainment` set('Animals','Antiques','Art','Astrology','Camping','Concerts','Computer/Video Games','Cooking','Dancing','Decorating','Gardening','Hiking','Kids Arts/Crafts','Knitting','Music','Physical Exercise','Singing','Sowing','Traveling','Woodworking','Writing') NOT NULL DEFAULT '',
  `InterestsGeneral` text NOT NULL,
  `InterestsSports` set('Aerobics','Baseball','Basketball','Cycling','Football','Golf','Martial Arts','Paddle Boarding','Racquetball','Rowing','Running','Skiing','Snowboarding','Soccer','Surfing','Swimming','Tennis','Volleyball','Weight Lifting','Workout','Yoga','Zumba') NOT NULL DEFAULT '',
  `InterestsWomens` set('Affordable Child Care','Discrimination in the Work Force','Equal Rights','Free Speech','Health','Human Trafficking/Sex Slavery','Inadequate Representation','Paid Sick and Parental Leave','Poverty','Pregnancy','Reproductive Rights','Violence Against Women','Women’s Rights') NOT NULL DEFAULT '',
  `InterestsMusic` set('Banjo','Bongo Drum','Base','Clarinet','Djembe Drum','Drums','Flute','Guitar','Oboe','Piano','Recorder','Saxophone','Trumpet','Tuba','Ukulele','Viola','Violin','Voice') NOT NULL DEFAULT '',
  `Education` enum('Elementary School','Home Schooled','Some High School','High School Graduate','Some College','Associates Degree','Bachelor''s Degree','Master''s Degree','PhD. Or Post Doc.') DEFAULT NULL,
  `FirstName` varchar(255) NOT NULL,
  `LastName` varchar(255) NOT NULL,
  `NEW_ITEM` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `NickName` (`NickName`),
  KEY `Country` (`Country`),
  KEY `DateOfBirth` (`DateOfBirth`),
  KEY `DateReg` (`DateReg`),
  KEY `DateLastNav` (`DateLastNav`),
  FULLTEXT KEY `NickName_2` (`NickName`,`City`,`DescriptionMe`,`Tags`)
) ENGINE=MyISAM AUTO_INCREMENT=131 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Profiles`
--

INSERT INTO `Profiles` VALUES (3,'persister1','moniquehillen@gmail.com','c0fe32a552b86b3d7efb5021386cc6c508670734','BSAxcFXM','Active',3,0,'female','female','Founder1','Single mom of 3 sons, raised kids alone for the last 14 years. Although my last son just left the nest :(','US','Amherst','1960-05-15',0,'2015-04-10 03:58:19','2020-04-18 12:22:48','2021-03-08 11:19:19','2021-03-09 09:51:09',0,'','01002',1,1,0,16,0,0,0,3,4,'online','wondering if this works. Cold outside ',1456942976,0,'','','','','Spiritual but not religious','','','','Human','','','','','Monique Hillen','Very Liberal','Energy Therapies,Herbalism,Homeopathy,Meditation','Painting,Photography,Galleries,Museums','Single Mother,Single Woman','Fiction,Non Fiction','Concerts,Cooking,Dancing,Gardening,Hiking,Music,Traveling','','Cycling,Golf,Tennis,Workout,Yoga','Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Poverty,Violence Against Women,Women’s Rights','Viola,Violin','Master\'s Degree','','',''),(12,'ericamlee','erik@yesexactly.com','5782854fe531fb6a231e45521aadcb590b388c85','FkGx4g&Z','Active',3,0,'female','female','','','US','Amherst','1966-06-06',0,'2015-08-27 02:07:34','2017-12-27 12:58:35','2020-04-08 12:01:10','2020-04-08 12:01:10',0,'','01002',1,1,0,11,0,0,0,3,4,'online','',1461255544,0,'','','','','','Single','','','','','','','','Jane Doe','','','','Involved Woman','','','','Paddle Boarding,Swimming','','','','','',''),(27,'dRVHThGtVA','jensprung@yahoo.com','7a56c39c56b20defacb6402bd606487fb4347d08','XvfHipGG','Active',1,0,'','','','Hello, I am a nuerosomatic massage therapist, specializing in Visceral Manipulation, Temporomandibular Joint Dysfunction, Postural Distortions, Pelvic Floor, Trigger Point Therapy, Myofascial Release, Manual Therapies and more. I am a mother of three...a stepdaughter who is 43, a daughter who is 29 and a son who is 27. They, and my work, are my life. I am married to a very interesting fellow who sustains, supports and loves me deeply. I live in Amherst, MA and Treasure Island, FL. Working and teaching in both areas. My parents are still alive and thriving at 83 years of age. They live close to me. I am grateful and thankful. For many things. I work hard to support a healthy environment, eat whole organic foods, stay away from all chemicals in my life, home, work, etc. I have several causes that are close to my heart...creating safe healing for veterans and addicts, as well as my most amazing one year old grandson. A connection that is deep and true!\r\n I look forward to meeting people here and expanding my knowledge as well as sharing all there is to this life.','US','','0000-00-00',0,'2016-10-14 20:22:02','2016-10-27 23:03:56','2016-10-31 10:36:24','2016-10-31 10:38:24',0,'','01002',1,1,0,7,0,0,0,3,3,'online','',0,0,'','','','','Spiritual but not religious','','Art,Astrology,Beauty,Crafts,Cycling,Workout','','White/Caucasian','','','','','Jennifer Sprung','Very Liberal','Acupuncture,Bio Feedback,Energy Therapies,Herbalism,Homeopathy,Meditation','','Involved Woman','Comedy,Fantasy,Fiction','Concerts,Writing','','Aerobics,Cycling,Swimming,Weight Lifting,Workout,Yoga','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights','','','','',''),(26,'PbZPJm4S9Z','lesley.a.duff@gmail.com','0e97346f81eab095caf513ac3c374fe00087ee36','z&i8iwpn','Active',1,0,'','','','','US','','0000-00-00',0,'2016-10-14 12:05:41','0000-00-00 00:00:00','2016-10-14 12:06:46','2016-10-14 12:40:46',0,'','01002',1,1,0,8,0,0,0,3,3,'online','',0,0,'','','','','Spiritual but not religious','','Knitting,Painting,Reading,Workout','','White/Caucasian','','','','','Lesley Francis','Conservative','','Museums','Single Mother','','Traveling','','Yoga','Health','','','','',''),(25,'GhUZaRPUhU','pamrietkerk@gmail.com','47c7e1dad7cebbbcdbed07200771c0f39fe929c3','!iWqdSW3','Active',1,0,'','','','','US','','0000-00-00',0,'2016-10-13 17:20:46','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','01060',1,1,0,3,0,0,0,3,3,'online','',0,0,'','','','','Buddhist / Taoist','','Watching Sports','','Native American','','','','','Pam Rietkerk','Liberal','','','Single Mother','','','','Volleyball','Reproductive Rights,Women’s Rights','','PhD. Or Post Doc.','','',''),(24,'zBQpjhpCG8','robin.jaffin@gmail.com','79e84b74e0450d0b44801457fe643cd1aa7ee463','wy.+wFWR','Active',1,0,'','','','I am a 56 year old single woman living in New England with a grown daughter who lives on the West Coast. I am in a relationship but do not live with my partner. I love to garden, cook and spend as much time outside as possible. ','US','','0000-00-00',1,'2016-10-13 15:01:38','2016-11-04 18:16:33','2019-07-23 08:56:24','2019-07-23 11:13:22',0,'','01060',1,1,0,4,0,0,0,3,4,'online','',0,0,'','','','','Atheist','','Crafts,Gardening,Photography','','White/Caucasian','','','','','Robin Jaffin','Liberal','Acupuncture','Photography','Involved Woman','Fiction','Animals,Antiques,Art,Cooking,Dancing,Gardening,Music','','','','','','','',''),(23,'9Jukj2dZdQ','revisionary@comcast.net','96495dac4e41ba77c80f07ecaa46bc6b2ca6b02c','jX4h,QbC','Active',1,0,'','','','I have 2 children  are out of the house now. I work freelance. I have a partner.  I feel most comfortable communicating and sharing time with women more than men., Even though I\'m in a relationship with a man.  Therefore I like the idea of an all women\'s website.','US','','0000-00-00',0,'2016-10-13 10:56:29','0000-00-00 00:00:00','2019-02-16 13:12:26','2019-02-16 13:22:59',0,'','01060',1,1,0,8,0,0,0,3,3,'online','',0,0,'','','','','','','Art,Astrology,Movies,Reading','','Human','','','','','Fanny Rothschild','Liberal','Acupuncture,Chiropractic,Energy Therapies,Meditation','Crafts,Videography,Galleries','Involved Woman','Comedy,Drama,Fantasy,Literary Fiction','Animals,Concerts,Dancing,Traveling,Writing','','Aerobics,Yoga','Affordable Child Care,Equal Rights,Human Trafficking/Sex Slavery,Paid Sick and Parental Leave,Reproductive Rights,Violence Against Women','Banjo,Voice','','','',''),(28,'bQgGsccZ34','shalkyard@gmail.com','cbe93d9ce5fd519e6f280e6592763c85276c8160','7rytMV7u','Active',1,0,'','','','Funky mom of three young men....married, having raised three young men many moments alone as my husband has often traveled (for work). ','US','','0000-00-00',0,'2016-11-02 14:04:17','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','01002',1,1,0,1,0,0,0,3,3,'online','',0,0,'','','','','Spiritual but not religious','','Art,Beauty,Cooking,Crafts,Cycling,Fashion,Gardening,Health,Jewelry Making,Movies,Photography,Play Sports,Reading,Workout','','Human','','','','','Suzanne Halkyard','Non-Political','Acupuncture,Bio Feedback,Energy Therapies,Herbalism,Homeopathy,Meditation','Crafts,Jewelry Making','Involved Woman','Comedy,Drama,Erotica,Fantasy,Non Fiction,Romance','Antiques,Art,Camping,Concerts,Cooking,Dancing,Decorating,Gardening,Hiking,Music,Physical Exercise,Traveling,Woodworking','','Cycling,Weight Lifting,Workout,Yoga','Discrimination in the Work Force,Equal Rights,Free Speech,Health,Paid Sick and Parental Leave,Reproductive Rights,Violence Against Women,Women’s Rights','','Master\'s Degree','','',''),(29,'A3EKaWGBHV','kalamoma27@gmail.com','fe85e0f36f7916463705624a41d411b533b7b455','6d7RLpp=','Active',1,0,'','','','I have been single with 5 kids for the last 5 years','US','','0000-00-00',0,'2016-11-15 16:16:38','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','01002',1,1,0,2,0,0,0,3,3,'online','',0,0,'','','','','Agnostic','','Art,Astrology,Beauty,Cycling,Fashion,Galleries,Gardening,Movies,Museums,Painting,Reading','','Middle Eastern','','','','','Kala Moma','Liberal','Energy Therapies','Painting','Single Mother','Drama,Fiction,Non Fiction','Art,Concerts','','','Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Women’s Rights','','Some College','','',''),(43,'Cp5u3vYzu2','gwendy123@gmail.com','3e017696e4dc79319409a16afbcb0fa608d9c841','Lcb!LkJa','Active',1,0,'','','','','US','','0000-00-00',0,'2019-01-05 14:27:45','0000-00-00 00:00:00','2019-03-05 16:47:45','2019-03-05 16:49:20',0,'','05038',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Spiritual but not religious','','Animals,Art,Cooking,Crafts,Decorating,Fashion,Gardening,Movies,Reading,Sewing','','White/Caucasian','','','','','Wendy Forbes','Non-Conformist','Homeopathy,Meditation','','Involved Woman','Comedy,Fiction,Literary Fiction,Mystery,Thrillers','','','','','','Master\'s Degree','','',''),(37,'86sHuX9XKv','noremac180@aol.com','e8a25bc37329fd4d190f4de512ea00db50d8baf0','K+B.W2V/','Active',1,0,'','','','Divorced single mother with grown twins living in New York City','US','','0000-00-00',0,'2017-03-10 10:56:29','2019-05-30 15:01:34','2020-10-09 21:17:59','2020-10-09 21:33:14',0,'','10065',1,1,0,5,0,0,0,3,3,'online','',0,0,'','','','','Christian / Protestant','','Animals,Antiques,Cooking,Cycling,Fashion,Gardening,Movies,Museums,Music,Photography,Play Sports,Watching Sports,Workout','','White/Caucasian','','','','','May Francis','Middle of The Road','','Photography,Museums','Single Mother,Involved Woman','Drama,Fiction,Thrillers','Animals,Antiques,Cooking,Decorating,Gardening,Music,Physical Exercise,Traveling','','Cycling,Football,Golf,Racquetball,Skiing,Soccer,Swimming,Weight Lifting,Workout,Yoga','Discrimination in the Work Force,Equal Rights,Violence Against Women','Piano,Trumpet','Master\'s Degree','','',''),(42,'cFLQz5hA6k','erikamlee23@gmail.com','0208d476aafadc5ebb67d7f883e2e78b36408fa5',',3zgfcub','Active',1,0,'','','','','US','','0000-00-00',0,'2019-01-05 13:24:47','0000-00-00 00:00:00','2019-01-05 15:02:48','2019-01-05 15:02:50',0,'','01301',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','New Age','','Hiking,Music,Writing','','White/Caucasian','','','','','Erika M Lee','Liberal','Meditation','','Single Woman','','','','','Poverty,Women’s Rights','Oboe','Master\'s Degree','','',''),(39,'vkhjh8DNZp','isabellabs@icloud.com','9d4b4577982c77cb49287fffa7b6b149626d2a5e','9H.CQbTS','Active',1,0,'','','','','US','','0000-00-00',0,'2018-07-08 15:10:17','0000-00-00 00:00:00','2019-08-05 17:11:03','2019-08-05 17:12:06',0,'','10065',1,1,0,2,0,0,0,3,3,'online','',0,0,'','','','','--Any--','','Animals,Art','','White/Caucasian','','','','','Isabella Botkat Skowronski','--Any--','Homeopathy,Meditation','','Single Mother','','','','','','','Bachelor\'s Degree','','',''),(40,'PgK5Lq9jDX','carlacavellucci@gmail.com','fda2868207737566e92f62dff4969b19d3758869','/=a4=Vfh','Active',1,0,'','','','Mother of 2','US','','0000-00-00',0,'2018-07-08 15:10:59','0000-00-00 00:00:00','2018-07-08 15:11:33','2018-07-09 11:00:46',0,'','07605',1,1,0,1,0,0,0,3,3,'online','',0,0,'','','','','Christian / Catholic','','Art,Cooking,Crafts','','Human','','','','','Carla Cavellucci Landi','Non-Political','','','Involved Woman','','','','','','','Bachelor\'s Degree','','',''),(44,'3K8GZTrXr7','Rdhmfa@yahoo.com','fd96f4e47eeaaabeece95851b9332f8e9a32db59',',K+E8v2e','Unconfirmed',1,0,'','','','Married just moved to the area. A bit difficult meeting new friends the older I get :). I work FT. but would like to volunteer for a nonprofit. ','US','','0000-00-00',0,'2019-01-05 22:13:57','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','05830',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Christian / Other','','Animals,Antiques,Gardening,Movies,Sewing','','Human','','','','','Claudia Richter','Liberal','','Crafts','Involved Woman','Comedy','','','Yoga','Affordable Child Care,Equal Rights,Health,Human Trafficking/Sex Slavery,Poverty,Violence Against Women,Women’s Rights','','Associates Degree','','',''),(45,'ckYFZcvt4h','susanlowery246@yahoo.com','340a6e8f0927bcebf7ab619a26ee8039ea70f048','AnHR?+QH','Active',1,0,'','','','61 yo mother of 3 (24,22 18), retired. \r\nIntrigued to see where this goes!','US','','0000-00-00',0,'2019-01-05 22:43:46','0000-00-00 00:00:00','2019-02-16 11:54:40','2019-02-16 12:10:21',0,'','01002',1,1,0,4,0,0,0,3,3,'online','',0,0,'','','','','Spiritual but not religious','','Animals,Art,Concerts,Cooking,Crafts,Gardening,Knitting,Movies,Museums,Music,Singing,Traveling','','White/Caucasian','','','','','Susan Lowery','Liberal','Herbalism','Galleries,Museums','Single Mother,Single Woman,Involved Woman','Comedy,Fiction,Literary Fiction,Non Fiction','','','Soccer,Surfing,Volleyball','Health,Inadequate Representation,Poverty,Reproductive Rights,Violence Against Women','Guitar,Piano','PhD. Or Post Doc.','','',''),(46,'mVUjgXsesm','jshafpow@gmail.com','c2ca24d75f14ee2f8bfe3c002cb9f31e59ee8e11','.i,E6q8t','Active',1,0,'','','','I am a 57 year old divorced woman with my 14 and 21 year olds still at home, my 25 and 28 year olds live in their own.\r\nI was a homeschool mom and teacher(for 25 years) until 2 years ago; I currently have 2 part-time jobs for small local non-profits. I am director of a rural library and coordinator of a seasonal arts center.\r\nMy divorce 2 years ago brought financial instability, yet I am the happiest I have been in years.  I have a few friends going through the separation and divorce transition and without all our conversations and support of each other, none of us wold be as successful in rebalancing our lives and our children.','US','','0000-00-00',0,'2019-01-07 06:19:39','0000-00-00 00:00:00','2019-02-07 20:51:05','2019-02-09 08:15:33',0,'','01238',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Spiritual but not religious','','Art,Cooking,Crafts,Dancing,Gardening,Health,Museums,Music,Reading,Workout,Writing','','White/Caucasian','','','','','Jodi Shafiroff','Very Liberal','Chiropractic,Herbalism,Homeopathy,Meditation','Crafts,Jewelry Making,Galleries,Museums','Single Mother,Single Woman','Erotica,Fiction,Literary Fiction,Non Fiction','','','Skiing,Workout,Yoga','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights','Djembe Drum','Bachelor\'s Degree','','',''),(47,'bBXYfy2CpQ','berninicaughlin@gmail.com','23f236bced610524c1369bddcd03e9262af5ce01','QYCELjs7','Active',1,0,'','','','Was born in the Valley and now live here again but lived in the Berkshires for years. Raised our family there and moved back down to the Valley after they successfully moved on as young adults. Neither live locally now.  Retired due to full time caregiving for my husband who passed away this summer. Figuring out a new life.......  happy to share much more at the appropriate time.  Not looking for a widows group but rather other women looking to have people to do things with - gentle hikes, possible book group, movies, etc.  I like the concept as I understand it of what this site is attempting to do.','US','','0000-00-00',0,'2019-01-08 10:31:27','0000-00-00 00:00:00','2019-09-19 12:24:01','2019-09-19 12:25:49',0,'','01040',1,1,0,1,0,0,0,3,3,'online','',0,0,'','','','','Unitarianism','','Concerts,Gardening,Hiking,Movies,Museums,Music,Reading,Traveling,Workout','','White/Caucasian','','','','','Maryanne Bernini Caughlin','Liberal','Acupuncture,Meditation','Museums','Single Woman','Fiction,Literary Fiction,Non Fiction','','','Workout,Yoga','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights','','Bachelor\'s Degree','','',''),(48,'qKG9XqaXpL','dbramhall@gmail.com','906536425b986e76c2b33884ad6a5c21e38208e0','UbKJS9pc','Active',1,0,'','','','Director of Marketing at a content marketing agency in New York. Love biking, writing, and fitness/health. ','US','','0000-00-00',0,'2019-01-08 17:02:17','0000-00-00 00:00:00','2019-01-08 17:03:54','2019-01-08 17:10:35',0,'','11201',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Spiritual but not religious','','Art,Beauty,Concerts,Cooking,Fashion,Health,Traveling,Writing','','White/Caucasian','','','','','Devin','Liberal','Acupuncture,Chiropractic,Energy Therapies,Homeopathy,Meditation','Photography','Single Woman','Comedy,Drama,Fiction,Literary Fiction,Non Fiction','','','Cycling,Yoga','','Piano','Bachelor\'s Degree','','',''),(49,'hzk5c648Xf','mrsaedelahi@gmail.com','862604cefbf0babb2253c6e678292f93254464fe','Tt9F!37c','Unconfirmed',1,0,'','','','','US','','0000-00-00',0,'2019-01-10 06:36:52','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','41199',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','--Any--','','Museums,Writing','','White/Caucasian','','','','','saed elahi','--Any--','','','Single Mother','','','','','','','Master\'s Degree','','',''),(50,'aR5qUuRMG7','evadandylion@hotmail.com','2f2532544972e97834574f59af93e8565fabeb56','BrstNam&','Active',1,0,'','','','⭐','US','','0000-00-00',0,'2019-01-18 11:31:41','2019-01-18 11:41:59','2019-11-05 10:25:14','2019-11-05 10:25:54',0,'','01002',1,1,0,3,0,0,0,3,3,'online','',0,0,'','','','','Spiritual but not religious','','Animals,Antiques,Art,Astrology,Beauty,Camping,Concerts,Cooking,Crafts,Dancing,Decorating,Drawing,Fashion,Galleries,Gardening,Health,Hiking,Jewelry Making,Kids Arts/Crafts,Knitting,Museums,Music,Painting,Photography,Reading,Singing,Sewing,Sculpture,Traveling,Woodworking,Writing','','Human','','','','','Eva D','Other Point of View','Acupuncture,Chiropractic,Energy Therapies,Herbalism','Crafts,Drawing,Jewelry Making,Painting,Galleries,Museums','Single Woman','Comedy,Drama,Erotica,Fantasy,Fiction,Literary Fiction,Mystery,Non Fiction,Romance,Science,Thrillers','','','Swimming,Yoga,Zumba','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights','Banjo,Djembe Drum,Ukulele,Voice','Some College','','',''),(51,'8kRh43ZMfY','joanna.campe@gmail.com','d637a1f98915f7034491e192971893d6c7ed61b2','xrY7Xkkp','Unconfirmed',1,0,'','','','I was a dancer and traveled extensively all over the world and based myself in Barcelona, Spain for almost 10 years where I appeared in 40 television commercials.  I also had an antique shop and art gallery in the fishing village  of Cadaques where  Salvador Dali and many other famous artists have lived. Many of my friends were architects, designers and artists.\r\n\r\nI have also spent a lot of time in Kauai. I more recently spend part of the year in Brazil in a wonderful community where people come from all over the world.\r\n\r\nFor many years I have been dedicated to making a difference in the world through a nonprofit organization I founded called Remineralize the Earth. I am passionate about nature, hiking, creating a new vision for a new Earth and sustainable communities as well as food, film and culture.','US','','0000-00-00',0,'2019-01-18 21:57:48','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','01060',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Spiritual but not religious','','Art,Cooking,Dancing,Gardening,Health,Hiking,Movies,Museums,Music,Reading,Traveling','','White/Caucasian','','','','','Joanna Campe','Very Liberal','Energy Therapies,Herbalism,Homeopathy,Meditation','','Single Woman','','','','','','','Associates Degree','','',''),(52,'6VyAakX4yT','ebccat9@gmail.com','67a2443cc731539b0a925efb203f419ff3fe90a2','dqU9r&Gj','Unconfirmed',1,0,'','','','✊','US','','0000-00-00',0,'2019-02-03 17:24:30','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','92551',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Scientology','','Antiques,Galleries,Play Sports,Watching Sports,Woodworking','','Human','','','','','Elaine Ben','Middle of The Road','Bio Feedback,FeldenKrais','Edging,Galleries','Involved Woman','Erotica','','','Paddle Boarding,Zumba','Human Trafficking/Sex Slavery,Paid Sick and Parental Leave','','Bachelor\'s Degree','','',''),(53,'mZggQZa92Y','ebcat9@gmail.com','04bc46591acb8cf6afe268c35704c2769d05547b','A,b.qkzG','Active',1,0,'','','','✊','US','','0000-00-00',0,'2019-02-03 17:27:22','0000-00-00 00:00:00','2019-06-08 02:03:06','2019-06-08 02:08:21',0,'','92551',1,1,0,2,0,0,0,3,3,'online','',0,0,'','','','','Taoism','','Astrology','','Native American','','','','','Elaine Beni','Non-Conformist','','Photography','Involved Woman','Mystery','','','Paddle Boarding','Human Trafficking/Sex Slavery','Clarinet,Djembe Drum','Some High School','','',''),(54,'ExHMAqpGcB','ateschner@comcast.net','487c73a03c01cc8727856f0968a9e97f35246cc4','RRwT6yWN','Active',1,0,'','','','Mother, director Bard Micro college, happy camper, and likes dogs','US','','0000-00-00',0,'2019-02-08 10:10:19','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','01062',1,1,0,1,0,0,0,3,3,'online','',0,0,'','','','','Agnostic','','Animals,Art,Cooking,Gardening,Knitting,Reading','','Human','','','','','Anne Teschner','Very Liberal','Acupuncture,Chiropractic,Meditation','Photography','Single Mother,Single Woman','Comedy,Drama,Erotica,Fantasy,Fiction,Literary Fiction,Mystery,Non Fiction,Romance,Science,Thrillers','','','','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights','Voice','Master\'s Degree','','',''),(55,'TXv98icNqF','froukjefeiner@icloud.com','351a0b80183542440d02d5ced555462ca774073b','9v!xueSr','Active',1,0,'','','','','US','','0000-00-00',0,'2019-02-11 10:22:13','0000-00-00 00:00:00','2019-04-13 19:05:35','2019-04-14 22:16:35',0,'','10003',1,1,0,1,0,0,0,3,3,'busy','',0,0,'','','','','Atheist','','Crafts,Galleries,Gardening,Health,Museums,Photography,Reading,Traveling','','White/Caucasian','','','','','Froukje Feiner','Very Liberal','Acupuncture,Meditation','Crafts,Museums','Involved Woman','Drama,Romance','','','Workout,Yoga,Zumba','Free Speech,Health,Violence Against Women,Women’s Rights','','Bachelor\'s Degree','','',''),(56,'XfBpxhgJ23','test@persisters.com','4d3d6c6045b990cc7c37c68f03950b06d6f79672','EzaqMHqS','Active',1,0,'','','','','US','','0000-00-00',0,'2019-02-14 14:48:35','0000-00-00 00:00:00','2019-04-06 12:00:26','2019-04-06 12:00:59',0,'','90210',1,1,0,1,0,0,0,3,3,'online','',0,0,'','','','',NULL,'','','',NULL,'','','','','Jen Doe',NULL,'','','Involved Woman','','','','','','',NULL,'','',''),(57,'D6qsBKWvXr','M.workinmom@gmail.com','ab6dc39c027870076a637e3e234ec4951567a6eb','53mv!V+F','Active',1,0,'','','','','US','','0000-00-00',0,'2019-02-16 09:32:18','0000-00-00 00:00:00','2019-02-16 09:54:14','2019-02-16 10:03:37',0,'','01002',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Christian / Other','','Cooking,Crafts,Health,Hiking,Sewing,Traveling,Workout','','Human','','','','','Maria Rivera','Middle of The Road','Energy Therapies,Herbalism,Homeopathy','Crafts','Involved Woman','Fantasy,Literary Fiction','','','Football,Workout,Yoga','','','Associates Degree','','',''),(58,'wifVjLAaTv','compsteph@yahoo.com','0e817e8b9d71c71dd75484082bed2a1a1580bb26','vK&ie?Ud','Active',1,0,'','','','Single mom','US','','0000-00-00',0,'2019-03-08 11:54:47','0000-00-00 00:00:00','2019-03-08 11:59:09','2019-03-08 12:08:07',0,'','01050',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Christian / Catholic','','','','White/Caucasian','','','','','Stephanie Miller','Non-Political','','','Single Mother','','','','','Health,Poverty','','Associates Degree','','',''),(59,'9rv6VmHxrC','Kristaelliottriley@gmail.com','6ab85be46b5430cc13f33a6eca982d132b2576da','qdcFh6bW','Unconfirmed',1,0,'','','','','US','','0000-00-00',0,'2019-03-10 17:50:21','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','02568',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Spiritual but not religious','','Animals,Antiques,Astrology,Cooking,Gardening,Hiking,Photography,Traveling','','Human','','','','','Krista Riley ','Non-Political','','Photography','Single Mother,Single Woman,Involved Woman','Mystery,Thrillers','','','','','','Bachelor\'s Degree','','',''),(60,'ZRLNmq6N2f','Avafradkin@gmail.com','5dcd57836792c9c6275e6b5f32ccb870bbd6b285','6/K7VRGW','Unconfirmed',1,0,'','','','','US','','0000-00-00',0,'2019-04-07 20:37:57','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','01002',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Jewish','','Animals,Art,Gardening,Health,Reading,Writing','','White/Caucasian','','','','','Ava Fradkin ','Non-Conformist','Acupuncture,Chiropractic','','Single Mother,Single Woman','Fiction,Non Fiction','','','','Discrimination in the Work Force,Health,Reproductive Rights,Violence Against Women,Women’s Rights','','Master\'s Degree','','',''),(61,'33dQQnbD25','Monica.wisnieski@gmail.com','52e045ec69d95cc5db1bf3c0b17cab273f442e58','qCx/wMt!','Unconfirmed',1,0,'','','','Single mom of 19 and 21 year old adult men. ','US','','0000-00-00',0,'2019-04-08 00:27:13','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','01850',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','--Any--','','Animals,Camping,Concerts,Cooking,Gardening,Health,Hiking,Movies,Photography,Play Sports,Traveling,Watching Sports,Workout','','White/Caucasian','','','','','Monica Wisnieski ','Middle of The Road','Meditation','Photography','Single Mother','Comedy,Drama,Non Fiction','','','Basketball,Cycling,Workout','Discrimination in the Work Force,Equal Rights,Free Speech,Health,Women’s Rights','','Some College','','',''),(62,'GHJh6WVaTx','sheilakwinter@icloud.com','98981ff8b22077ad322cfcaa343997cdf550a294','t&5yb3he','Active',1,0,'','','','Mid-forties wife, business owner, and mom of one pretty great teenager.  I get joy from cycling, the gym, hiking, gardening, exploring the northeast, volunteering, making and eating pretty much all the food.  I love supporting women and helping however I can.  I believe we are our better selves when we use our gifts.  Laughter and coffee are my currency.','US','','0000-00-00',0,'2019-04-08 15:05:12','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','01002',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','--Any--','','Animals,Camping,Cooking,Cycling,Decorating,Fashion,Gardening,Health,Hiking,Kids Arts/Crafts,Reading,Watching Sports,Workout','','White/Caucasian','','','','','Sheila Winter','Liberal','Meditation','Museums','Involved Woman','Comedy,Fantasy,Fiction,Literary Fiction,Mystery,Romance,Thrillers','','','Aerobics,Cycling,Golf,Rowing,Skiing,Workout,Yoga,Zumba','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights','','Bachelor\'s Degree','','',''),(63,'dVD5239W6M','ebcat9+1@gmail.com','10a28c227e3939dd4284ef81a045a94e8c7a07fd',',Sj52QVx','Active',1,0,'','','','','US','','0000-00-00',0,'2019-04-12 23:54:36','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','01564',1,1,0,1,0,0,0,3,3,'online','',0,0,'','','','','Christian / LDS','','Beauty,Galleries,Kids Arts/Crafts,Woodworking','','Human','','','','','Elaine Boromir','Very Liberal','Energy Therapies,FeldenKrais','Edging,Jewelry Making,Galleries','Single Woman,Involved Woman','Erotica,Westerns','','','Cycling,Racquetball','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights','Clarinet,Djembe Drum,Tuba,Viola','Home Schooled','','',''),(64,'wHYEyR9QP3','Gistersister2@sbcglobal.net','bd67d446913a85ab0d19b82e55783ca66621ce79','hENUBFQ/','Unconfirmed',1,0,'','','','I am a single mother. I have a 20 year old son. I have raised him by myself without any support from his father. When my son was younger, I had the support from my mom ( and my dad when he was local). My father has passed, my mom is institutionalized with Alzheimer’s disease, and my sisters are unavailable. Only now has my son started processing the abandonment of his father and the loss of his only grandparents. He is struggling and trying to find his way. I am looking for a supportive community of like minded sisters for strength, resource, and maybe even a little humor. I am a professional musician and teach children music, direct an adult and children’s choir, and lead the concert and jazz band at my school. ','US','','0000-00-00',0,'2019-04-28 10:32:17','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','06423',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Jewish','','Animals,Astrology,Dancing,Music,Singing','','Human','','','','','Margaret Gister','Liberal','Acupuncture,Bio Feedback,Energy Therapies,Meditation','','Single Mother','Non Fiction','','','Martial Arts,Yoga','Free Speech,Health,Violence Against Women,Women’s Rights','Bongo Drum,Djembe Drum,Drums,Flute,Guitar,Piano,Viola,Voice','Master\'s Degree','','',''),(65,'g8DP6pw6Jh','luvsmusic8@gmail.com','9169da4f199fd8522a44946254418d5bd5816714',',EXv99=C','Unconfirmed',1,0,'','','','I am a maturing woman who loves all people, places, and things. I am on an eternal search for knowledge. I love ','US','','0000-00-00',0,'2019-05-02 16:33:51','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','01040',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Christian / Catholic','','Animals,Antiques,Art,Beauty,Concerts,Cooking,Dancing,Decorating,Fashion,Galleries,Gardening,Health,Museums,Music,Painting,Photography,Reading,Singing','','Human','','','','','Carolyn Donahue Martin ','Very Liberal','Energy Therapies,Meditation','Galleries,Museums','Involved Woman','Drama,Erotica,Fantasy,Fiction,Literary Fiction,Mystery,Non Fiction,Science,Thrillers','','','Aerobics,Martial Arts,Skiing,Swimming,Yoga','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights','','Associates Degree','','',''),(66,'e92PH8a6jX','yayirodriguez55@gmail.com','f11aa4f37491156189f3f8bec89867a70276641a','zbY36uks','Unconfirmed',1,0,'','','','','US','','0000-00-00',0,'2019-05-28 09:53:15','0000-00-00 00:00:00','2019-05-28 10:02:41','2019-05-28 10:04:14',0,'','01040',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Christian / Other','','Animals,Art,Beauty,Camping,Cooking,Crafts,Decorating,Drawing,Fashion,Galleries,Gardening,Hiking,Jewelry Making,Knitting,Music,Painting,Photography,Play Sports,Traveling,Workout,Writing','','Latino/Hispanic','','','','','yariely','Non-Political','','Crafts,Drawing,Jewelry Making,Painting,Photography,Galleries','Single Mother','Comedy','','','Volleyball','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Reproductive Rights,Violence Against Women,Women’s Rights','Piano,Violin','Some High School','','',''),(67,'Xe2kMm4jHB','andreeapeguese@gmail.com','d1e6366526fff300980c1026d751b55b09f10bbf','LjN4,x25','Active',1,0,'','','','','US','','0000-00-00',0,'2019-05-28 09:59:49','0000-00-00 00:00:00','2019-05-28 10:03:21','2019-05-28 10:10:00',0,'','01105',1,1,0,1,0,0,0,3,3,'online','',0,0,'','','','','Christian / Protestant','','Animals,Art,Beauty,Cooking,Crafts,Dancing,Fashion,Health,Jewelry Making,Kids Arts/Crafts,Movies,Music,Painting,Photography,Traveling','','Other','','','','','andreea symmone peguese','Other Point of View','Energy Therapies','Crafts,Edging,Jewelry Making,Painting,Photography,Videography,Galleries','Single Mother','Comedy,Fantasy,Mystery,Non Fiction,Science,Thrillers','','','Baseball,Football,Golf,Snowboarding,Soccer,Tennis,Yoga,Zumba','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Paid Sick and Parental Leave,Pregnancy','Drums,Guitar,Piano','Some High School','','',''),(68,'d4mur8SP33','nayaridmaldonado1998@gmail.com','d0f1f18169a9837854bd0700490eea49119b714f','5Vkbshp+','Unconfirmed',1,0,'','','','You can call me Naya. I have a 3 yr old son, his name is Radames Jr. and a daughter on the way her name is Kianny Liz...','US','','0000-00-00',0,'2019-05-28 10:29:13','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','01151',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Other','','Beauty,Hiking,Writing','','Latino/Hispanic','','','','','Nayarid Liz Maldonado','Other Point of View','','','Single Mother','Drama,Mystery','','','Tennis,Workout,Yoga','','','Some High School','','',''),(69,'U3KJyGFhLB','opaskins13@gmail.com','2b8a334518ee271f27ee1cd461f137eb0856c34b','wUqC/map','Unconfirmed',1,0,'','','','','US','','0000-00-00',0,'2019-05-28 10:30:34','0000-00-00 00:00:00','2019-05-28 10:33:03','2019-05-28 10:36:37',0,'','01109',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Atheist','','Cooking,Movies,Music,Play Sports','','Black/African Descent','','','','','octavia paskins','Non-Political','','Painting','Single Mother','Drama,Thrillers','','','Basketball,Running,Soccer,Volleyball,Workout','Affordable Child Care,Women’s Rights','Saxophone,Trumpet','Some High School','','',''),(70,'hQBrXG7BN4','andrealee1212@icloud.com','03e42e61eee1a484233ee2435e63a105d98d82eb','6,SaHBzZ','Unconfirmed',1,0,'','','','\r\n','US','','0000-00-00',0,'2019-05-28 10:39:43','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','01040',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Christian / Other','','','','Latino/Hispanic','','','','','andrealee',NULL,'','','Involved Woman','','','','','','',NULL,'','',''),(71,'msUVzE4GRh','Storres738@gmail.com','4048ab33ec29f01f6fced87b05ccfd4203a734b6','GgQKmTjz','Unconfirmed',1,0,'','','','','US','','0000-00-00',0,'2019-05-28 10:43:07','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','01040',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Other','','Art,Beauty,Crafts,Dancing,Decorating,Kids Arts/Crafts,Traveling,Writing','','Latino/Hispanic','','','','','Sylvia Nicole Torres','--Any--','','Crafts,Painting,Photography','Single Mother','Comedy,Romance','','','Basketball,Rowing,Zumba','Affordable Child Care,Pregnancy,Violence Against Women','','Elementary School','','',''),(72,'ELBx44U8kT','cerekh@gmail.com','cda4f2cfbc983476eae3041212762cd0eb6d6a02','n8Ly5TvD','Active',1,0,'','','','','US','','0000-00-00',0,'2019-06-01 14:25:16','0000-00-00 00:00:00','2019-06-17 00:41:39','2019-06-17 00:41:55',0,'','01002',1,1,0,0,0,0,0,3,5,'online','',0,0,'','','','','--Any--','','Animals,Computer/Video Games,Fashion,Music','','White/Caucasian','','','','','cerekh_testaccount','Liberal','','','Single Mother','','','','','','Guitar','Bachelor\'s Degree','','',''),(73,'vp4eAuermf','ebcat9+7@gmail.com','7056f3f5020e98c146f696e174c7d55de48ff207','FcnFNw.C','Active',1,0,'','','','Just peekin\'','US','','0000-00-00',0,'2019-06-08 01:51:35','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','03132',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Rastafarian','','Antiques,Decorating,Jewelry Making,Play Sports,Woodworking','','Human','','','','','EB Catherune ','Non-Conformist','Bio Feedback,FeldenKrais','Edging,Jewelry Making,Galleries','Single Mother,Single Woman,Involved Woman','Erotica,Non Fiction','','','Aerobics,Workout','Women’s Rights','Djembe Drum,Recorder,Tuba',NULL,'','',''),(74,'r29LqS8L45','jntmartinez2@gmail.com','51e302a7754b110eb667d247110e46cc881c4a8e','4hFJPHbL','Active',1,0,'','','','','US','','0000-00-00',0,'2019-07-04 19:06:21','0000-00-00 00:00:00','2019-07-04 19:08:36','2019-07-04 19:08:47',0,'','75060',1,1,0,1,0,0,0,3,3,'online','',0,0,'','','','','Christian / Catholic','','Animals,Antiques,Art,Astrology,Beauty,Concerts,Cooking,Crafts,Dancing,Decorating,Fashion,Galleries,Health,Kids Arts/Crafts,Movies,Museums,Music,Painting,Photography,Reading,Singing,Watching Sports,Workout','','Latino/Hispanic','','','','','Patricia','--Any--','Chiropractic,Energy Therapies,Herbalism,Meditation','Crafts,Drawing,Jewelry Making,Painting,Photography,Videography,Galleries,Museums','Single Mother,Single Woman,Involved Woman','Comedy,Drama,Erotica,Fantasy,Fiction,Literary Fiction,Mystery,Non Fiction,Romance,Science,Thrillers,Westerns','','','Baseball,Basketball,Cycling,Football,Workout,Yoga,Zumba','Affordable Child Care,Health,Human Trafficking/Sex Slavery,Poverty,Pregnancy,Violence Against Women','','High School Graduate','','',''),(75,'a49R3F5PPt','Suzannejyoung@outlook.com','9600755d354b156bbe53be5247bcd26fbf62be62','Uh.2dp+h','Unconfirmed',1,0,'','','','Hi!\r\nI live in CT- right on the MA line. I have 2 children- ages 11 and 7. I’ve been divorced since 2014, but, still never feel “free”, as my ex husband (Father to both children) is high conflict and continues to control my children and I from outside the house. I work Part time now.','US','','0000-00-00',0,'2019-07-04 19:45:14','0000-00-00 00:00:00','2019-07-05 07:49:14','2019-07-05 07:58:20',0,'','06082',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Christian / Other','','Animals,Beauty,Fashion,Kids Arts/Crafts','','White/Caucasian','','','','','Suzanne Taylor','Liberal','','','Single Mother','Comedy,Drama','','','Swimming','Affordable Child Care,Health,Paid Sick and Parental Leave','','Associates Degree','','',''),(76,'XKp9YU2kXT','sarahbennett917@gmail.com','e0fbbeeefbdb96b62cbe094111cfc2f8c462cd39','MrskbBjm','Unconfirmed',1,0,'','','','I\'m a 34 yr old single mama to a little girl who is currently 4 months old. I moved during my pregnancy from Oregon to Massachusetts in December 2018. I am going through a divorce right now and starting my life over here in western MA. Looking forward to connecting with other single mothers in the area for inspiration, friendship and support!','US','','0000-00-00',0,'2019-07-29 12:01:56','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','01070',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Spiritual but not religious','','Antiques,Art,Astrology,Beauty,Camping,Concerts,Crafts,Decorating,Fashion,Galleries,Gardening,Health,Hiking,Kids Arts/Crafts,Museums,Music,Painting,Photography,Singing,Workout,Writing','','White/Caucasian','','','','','Sarah Bennett','Liberal','Meditation','Crafts,Drawing,Painting,Photography,Galleries,Museums','Single Mother','Comedy,Non Fiction','','','Paddle Boarding,Running,Swimming,Yoga','Affordable Child Care,Equal Rights,Health,Pregnancy,Reproductive Rights,Women’s Rights','','Bachelor\'s Degree','','',''),(77,'8sf3yeUHfC','info@persisters.com','971fc8f6cf10f3fbfc29ec09fc496bc289f3f22e','QkTpJ6Jr','Active',1,0,'','','','','US','','0000-00-00',0,'2019-08-05 14:34:04','0000-00-00 00:00:00','2020-04-18 12:24:44','2020-04-18 12:28:01',0,'','01002',1,1,0,3,0,0,0,3,3,'online','',0,0,'','','','',NULL,'','','',NULL,'','','','','PerSisters Team',NULL,'','','Single Mother,Single Woman','','','','','','',NULL,'','',''),(78,'pPc6CdhFBj','nicoleferraro14@gmail.com','cd88d3934d7823a2d424281e144a6278db9d4b3f','cwvx6G&M','Unconfirmed',1,0,'','','','','US','','0000-00-00',0,'2019-08-12 11:26:09','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','01089',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Spiritual but not religious','','Camping,Concerts,Cooking,Cycling,Dancing,Gardening,Hiking,Movies,Museums,Music,Reading,Traveling','','Human','','','','','Nicole Ferraro','Liberal','Acupuncture,Chiropractic,Energy Therapies,Herbalism,Homeopathy,Meditation','Museums','Single Mother','Comedy,Drama,Fantasy,Fiction,Literary Fiction,Non Fiction,Science','','','Cycling,Swimming,Yoga','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights','','Master\'s Degree','','',''),(79,'p2JLG5p4EP','teresa.furst06@gmail.com','4266184098ca7f143d6ac0c4618a573e77b708f4','eqrhbGzY','Unconfirmed',1,0,'','','','','US','','0000-00-00',0,'2019-09-24 11:52:10','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','10024',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','--Any--','','Art,Beauty,Concerts,Dancing,Decorating,Drawing,Fashion,Galleries,Health,Kids Arts/Crafts,Music,Painting,Photography,Play Sports,Singing,Sewing,Sculpture,Woodworking,Workout','','Latino/Hispanic','','','','','Maria Teresa Furst','--Any--','Acupuncture,Energy Therapies,Herbalism,Homeopathy,Meditation','Crafts,Drawing,Edging,Jewelry Making,Painting,Photography,Videography,Galleries,Museums','Single Mother','Fantasy,Literary Fiction,Non Fiction,Science','','','Aerobics,Cycling,Tennis,Weight Lifting,Workout,Yoga,Zumba','Discrimination in the Work Force,Equal Rights,Free Speech,Health,Inadequate Representation,Poverty,Pregnancy,Violence Against Women,Women’s Rights','','Master\'s Degree','','',''),(80,'5hKtKR3CXf','peggyc8641@gmail.com','3b4ae89a269d68b6b0e2851f64edb24054663ce1','.C5ig9kx','Active',1,0,'','','','','US','','0000-00-00',0,'2019-10-23 03:01:04','0000-00-00 00:00:00','2019-10-23 03:04:14','2019-10-23 17:49:50',0,'','V3R3G2',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','',NULL,'','Art,Photography','','Asian','','','','','Peggy Chien',NULL,'','','Single Woman','','','','','','','Bachelor\'s Degree','','',''),(81,'J7D7FV9kG3','leejessie1997@gmail.com','a06d49e32ae87a82dc8fe2853fd9578627b035c4','N365fv?w','Unconfirmed',1,0,'','','','','US','','0000-00-00',0,'2019-10-23 03:14:45','0000-00-00 00:00:00','2019-12-05 23:52:37','2019-12-05 23:53:09',0,'','H6h0h8',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','',NULL,'','','',NULL,'','','','','Jessie Lee',NULL,'','','Single Mother','','','','','','',NULL,'','',''),(82,'62JALN5mAX','munecita61@gmail.com','34e16f985766290113a5c9db8188a4571a4cca2f','FK2eKVn.','Active',1,0,'','','','I am a single mom of four living with severe PTSD... ','US','','0000-00-00',0,'2019-11-13 15:43:22','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','01105',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Christian / Other','','Animals,Antiques,Art,Beauty,Camping,Concerts,Computer/Video Games,Cooking,Crafts,Dancing,Decorating,Drawing,Fashion,Galleries,Gardening,Health,Hiking,Kids Arts/Crafts,Movies,Museums,Music,Painting,Photography,Reading,Singing,Workout,Writing','','Latino/Hispanic','','','','','Carmen Rivera','Non-Political','Chiropractic','Crafts,Drawing,Jewelry Making,Painting,Photography,Galleries,Museums','Single Mother','Comedy,Drama,Erotica,Fantasy,Fiction,Literary Fiction,Mystery,Non Fiction,Romance,Thrillers','','','Basketball,Running,Soccer,Swimming,Tennis,Workout,Yoga,Zumba','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights','Clarinet','Some High School','','',''),(83,'2gvEtMX6si','acmiceli@ymail.com','134744748958ed2bd3a3cd89d233d2f85b2dfbce','VLFkFauD','Active',1,0,'','','','','US','','0000-00-00',0,'2019-11-30 04:38:02','0000-00-00 00:00:00','2019-11-30 12:51:02','2019-11-30 22:36:40',0,'','98101',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','',NULL,'','','',NULL,'','','','','AC',NULL,'','','Involved Woman','','','','','','',NULL,'','',''),(84,'kvpS2VVBwY','jhl57@sfu.ca','a4b585b2fd26d8424814f64c83d6c4377ce4df49','/c9N9.iU','Active',1,0,'','','','','US','','0000-00-00',0,'2019-12-05 21:13:43','0000-00-00 00:00:00','2019-12-05 23:53:25','2019-12-06 03:59:05',0,'','22313',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','',NULL,'','','',NULL,'','','','','Jessie',NULL,'','','Single Mother','','','','','','',NULL,'','',''),(86,'BshXSNhjBW','aprilchooselove@gmail.com','4cc0d42e9ae67c33fcc6661ecc0bdbd9bdb05301','eu94F97V','Unconfirmed',1,0,'','','','I’m a feminist scholar teaching about and writing on Regenerating the Feminine. \r\nAprilHeaslip.com','US','','0000-00-00',0,'2020-03-14 11:47:22','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','28711',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Paganism','','Animals,Cooking,Knitting,Movies,Museums,Photography,Workout','','White/Caucasian','','','','','April Heaslip','Very Liberal','Acupuncture,Herbalism,Homeopathy,Meditation','Crafts,Jewelry Making,Photography','Single Woman','Literary Fiction,Mystery','','','Tennis,Volleyball,Yoga','Inadequate Representation,Poverty,Violence Against Women,Women’s Rights','Piano,Ukulele','PhD. Or Post Doc.','','',''),(87,'yS6xrQhNLu','Amy@thebloomcommunity.org','3ae189287b96425983b3698613ba6f06a70f94d7','L7h5V!tU','Active',1,0,'','','','I am a professional working mother of five, biodynamic herbalist & homesteader, and Pioneer Valley native currently living in southern Vermont, but my businesses operate out of Northampton, MA.  \r\n\r\nIn 2010 I founded an all-female green cleaning company, GreenLove Eco Cleaning, that has rapidly grown to be the largest green cleaning company in Western Mass and is currently transitioning to be a worker-owned cooperative.  Our team is mainly single mothers and we take pride in our close-knit, family-first company model.  We are hiring!  www.greenloveclean.com.\r\n\r\nI also run a non-profit, The Bloom Community Workspace & Family Center.  We offer community coworking, private offices, meeting rooms, and bodywork & therapy space all with on-site childcare.  Financial aid is available in membership grants to single mothers, survivors of domestic violence, and mothers continuing their education. Free mentoring available to women entrepreneurs.  www.thebloomcommunity.org\r\n\r\n','US','','0000-00-00',0,'2020-03-14 11:48:14','2020-03-15 09:57:51','2020-03-15 09:57:51','2020-03-15 10:02:08',0,'','01060',1,1,0,1,0,0,0,3,3,'online','',0,0,'','','','','Paganism','','Animals,Art,Astrology,Camping,Concerts,Cooking,Crafts,Dancing,Decorating,Drawing,Galleries,Gardening,Health,Hiking,Kids Arts/Crafts,Knitting,Museums,Music,Painting,Photography,Reading,Sewing,Sculpture,Traveling,Writing','','White/Caucasian','','','','','Amy Lovell','Non-Conformist','Acupuncture,Chiropractic,Energy Therapies,Herbalism,Homeopathy,Meditation','Crafts,Drawing,Jewelry Making,Painting,Photography','Single Mother','Literary Fiction,Non Fiction,Science','','','Skiing,Swimming,Yoga','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights','','Bachelor\'s Degree','','',''),(88,'Gwnd8JhsZS','J_Roberts86@yahoo.com','9607bcd4a6f09707fcd9a0eaf1618cc8854c248b','R&H.b8G+','Active',1,0,'','','','I am a mother of 3 needing help asap! I\'m in the beginning stages of a divorce and the kids and I are miserable at home. My kids are my life and they keep me busy. I can\'t afford much right now, praying for a kind heart and a helping hand. I need to get back on my feet after this rollercoaster of a marriage.','US','','0000-00-00',0,'2020-03-17 03:39:45','2020-03-17 03:41:40','2020-03-17 03:40:16','2020-03-17 12:53:06',0,'','97013',1,1,0,1,0,0,0,3,3,'online','',0,0,'','','','','Christian / Catholic','','Animals,Camping,Concerts,Hiking,Kids Arts/Crafts,Movies,Music,Play Sports,Traveling,Watching Sports','','White/Caucasian','','','','','Jennifer','--Any--','','','Single Mother','','','','Baseball,Basketball,Football,Soccer','','','Associates Degree','','',''),(89,'HLyzXFYLp8','kimsdance1@msn.com','45eeea3deea5940f0f4641f737b96a17443b630c','rEgk7HjW','Unconfirmed',1,0,'','','','Mom of  5, grandma of 17, dance teacher in home 26 years. Wife of mayor of Santaquin and stake presidency. Busy and love my family. ','US','','0000-00-00',0,'2020-03-19 16:08:11','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','84655',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Christian / LDS','','Art,Beauty,Cooking,Crafts,Dancing,Decorating,Fashion,Gardening,Health,Hiking,Kids Arts/Crafts,Movies,Museums,Music,Photography,Reading,Singing,Traveling,Workout,Writing','','White/Caucasian','','','','','Kim Hunsaker','Conservative','Chiropractic,Meditation','Crafts,Photography,Museums','Involved Woman','Fiction,Literary Fiction','','','Aerobics,Swimming,Weight Lifting,Workout,Yoga,Zumba','Health','Piano','Some College','','',''),(90,'8is9quRL5x','Jolene.heske@gmail.com','ced9737520f446b473acd171115f65729dcd709c','iTp8?5MV','Active',1,0,'','','','','US','','0000-00-00',0,'2020-03-22 11:09:59','0000-00-00 00:00:00','2020-03-22 11:11:54','2020-03-22 23:46:55',0,'','T0e2m0 ',1,1,0,1,0,0,0,3,3,'online','',0,0,'','','','','Christian / Other','','Animals,Camping,Hiking,Movies,Photography','','White/Caucasian','','','','','Jolene Heske','Conservative','Chiropractic,Herbalism,Homeopathy','Photography','Single Mother','','','','','Affordable Child Care,Inadequate Representation,Paid Sick and Parental Leave,Pregnancy,Violence Against Women','','Some College','','',''),(91,'Gg2M7DfFJa','tgarcia1022@gmail.com','88b25e0781cf38514542b6da3d2c334759df7e47','YccH9svz','Active',1,0,'','','','','US','','0000-00-00',0,'2020-03-22 11:39:14','0000-00-00 00:00:00','2020-03-22 11:39:56','2020-03-22 11:40:25',0,'','30028',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Spiritual but not religious','','Animals,Art,Astrology,Beauty,Camping,Concerts,Crafts,Decorating,Fashion,Health,Hiking,Movies,Music,Reading,Traveling','','Other','','','','','Taylor','Middle of The Road','Energy Therapies,Homeopathy,Meditation','Crafts,Painting','Single Mother','Drama,Fantasy,Fiction,Mystery,Non Fiction,Thrillers','','','Baseball,Football,Swimming,Tennis,Volleyball,Workout,Yoga','Affordable Child Care,Equal Rights,Health,Human Trafficking/Sex Slavery,Paid Sick and Parental Leave,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights','','Bachelor\'s Degree','','',''),(92,'7qBaQqjQ5H','Vhreese@gmail.com','bb2829ab256acaca72cf266952ae64920a50883d','Wv9EiVHe','Unconfirmed',1,0,'','','','Single mom of 3. A boy & 2 girls: 13,12& 11','US','','0000-00-00',0,'2020-03-22 11:50:01','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','35757',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Christian / Other','','Animals,Antiques,Art,Cooking,Crafts,Dancing,Decorating,Jewelry Making,Kids Arts/Crafts,Movies,Museums,Painting,Reading,Singing,Watching Sports','','White/Caucasian','','','','','Valerie Herron-Reese','Non-Political','Chiropractic','Crafts,Jewelry Making,Painting','Single Mother','Drama,Erotica,Fantasy,Fiction,Mystery,Romance,Thrillers','','','','Affordable Child Care,Free Speech,Health,Paid Sick and Parental Leave,Women’s Rights','','Bachelor\'s Degree','','',''),(93,'UeSc8yP66b','P911T143@GMAIL.COM','2008b17b5a83690c3d7d50a20766384fc6e1fef4','!6p8Mpuv','Active',1,0,'','','','I am single mom to an amazing 4 year boy. I work at a local hospital as a Respiratory Therapist.','US','','0000-00-00',0,'2020-03-23 12:02:41','0000-00-00 00:00:00','2020-03-23 12:03:30','2020-03-23 20:02:42',0,'','19317',1,1,0,1,0,0,0,3,3,'online','',0,0,'','','','','Jewish','','Animals,Astrology,Cooking,Fashion,Health,Jewelry Making,Kids Arts/Crafts,Movies,Workout','','White/Caucasian','','','','','Erica Imber','Liberal','','Crafts,Jewelry Making,Painting','Single Mother','Comedy,Romance,Science','','','Aerobics,Football,Swimming,Workout,Yoga','Affordable Child Care,Equal Rights,Health,Paid Sick and Parental Leave,Reproductive Rights,Violence Against Women','','Bachelor\'s Degree','','',''),(95,'DqncumJSmi','elsydash@gmail.com','146c6e58dc19087b79fa6900c7523988ec5f3e5f','FPewAY=F','Active',1,0,'','','','','US','','0000-00-00',0,'2020-03-27 10:33:38','0000-00-00 00:00:00','2020-03-27 10:34:45','2020-03-27 10:36:57',0,'','01002',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Atheist','','Animals,Camping,Concerts,Cooking,Gardening,Hiking,Knitting,Music,Singing','','White/Caucasian','','','','','Laura LeClair','Very Liberal','Acupuncture,Chiropractic,Herbalism,Meditation','Drawing,Galleries,Museums','Single Mother','Non Fiction','','','','Affordable Child Care,Equal Rights,Health,Paid Sick and Parental Leave','Voice','Master\'s Degree','','',''),(96,'7EvXCMH2cF','Seanwheeler2017@gmail.com','33868dfe2b865de77b91fcb8fe7ab2f80418a0ef','nkTT=vRi','Active',1,0,'','','','Very calm person and easy going person and very fun ','US','','0000-00-00',0,'2020-04-07 08:54:52','0000-00-00 00:00:00','2020-04-07 08:57:16','2020-04-07 09:19:15',0,'','77001',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Christian / Other','','Animals,Camping,Computer/Video Games,Movies,Music,Play Sports,Reading,Traveling,Workout,Writing','','Other','','','','','Sean wheeler ','Non-Political','Meditation','Galleries','Involved Woman','Romance,Thrillers','','','Baseball,Basketball,Football,Running,Swimming','Affordable Child Care,Health,Women’s Rights','Piano','Some College','','',''),(97,'kh84CvBTjp','Redwards12@gmail.com','0f35550a89fc8edeef24ad0b428bf2fd0ba800f0','QcMtw!Jc','Active',1,0,'','','','I am a 39 year old mama living in Northampton with my one and three year old boys. I would love to meet some other local single parents!','US','','0000-00-00',0,'2020-04-15 09:59:01','0000-00-00 00:00:00','2020-04-15 10:32:24','2020-04-16 15:44:06',0,'','01060',1,1,0,3,0,0,0,3,3,'online','',0,0,'','','','',NULL,'','Camping,Dancing,Health,Music,Singing,Traveling,Workout','','Human','','','','','Rebecca Edwards','Very Liberal','','','Single Mother','','','','','','','Master\'s Degree','','',''),(98,'NQm67DPxzA','melissabrown1027@aol.com','e6e699f7081b66f53f3d6d48531531fed7ed7989','.GgU5?wM','Active',1,0,'','','',' I am a single mother of two special needs children. ','US','','0000-00-00',0,'2020-04-15 10:11:44','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','01038',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Other','','Cooking,Crafts,Dancing,Health,Hiking,Movies,Play Sports','','White/Caucasian','','','','','Melissa Brown','Liberal','Energy Therapies','','Single Mother','','','','Aerobics,Baseball,Weight Lifting,Workout,Yoga','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Health,Paid Sick and Parental Leave,Poverty,Violence Against Women','','Bachelor\'s Degree','','',''),(99,'7Jynnwtfk6','smh1013@gmail.com','5f87dbdc7fc0289f549fa5b8d80dbbd34a5845ea','R&6x9HzP','Active',1,0,'','','','','US','','0000-00-00',0,'2020-04-15 11:22:33','0000-00-00 00:00:00','2020-04-15 11:24:46','2020-04-15 11:57:27',0,'','01054',1,1,0,1,0,0,0,3,3,'online','',0,0,'','','','',NULL,'','Cycling,Health,Hiking,Movies,Museums,Photography,Reading,Traveling,Workout','','White/Caucasian','','','','','Shelly Hicks','Liberal','','Photography,Galleries,Museums','Single Mother','Fiction,Literary Fiction,Mystery','','','Cycling,Running,Workout,Yoga','','',NULL,'','',''),(100,'hKp6ygQJrX','jus123new@yahoo.com','feebae53ef1e3c5150afa8488cfa2f7500421d3b','83+nCP&g','Active',1,0,'','','','I am single mother of two girls,  27 and 22.  ','US','','0000-00-00',0,'2020-04-15 13:30:29','0000-00-00 00:00:00','2020-04-15 13:31:54','2020-04-15 13:34:08',0,'','01007',1,1,0,1,0,0,0,3,3,'online','',0,0,'','','','','Other','','Camping,Cycling,Gardening,Health,Hiking,Reading','','White/Caucasian','','','','','Justine Stockwell','Non-Political','','','Single Woman','Comedy,Fiction,Non Fiction,Romance','','','','','','Some College','','',''),(101,'3T6agaL3UX','Power_reni@yahoo.de','01a214256a2b84e4905aa991338bbcce5f6706d2','4QX.J747','Active',1,0,'','','','','US','','0000-00-00',0,'2020-04-15 13:51:34','0000-00-00 00:00:00','2020-04-15 13:52:29','2020-04-15 13:55:12',0,'','01002',1,1,0,1,0,0,0,3,3,'online','',0,0,'','','','',NULL,'','','','White/Caucasian','','','','','Ve No',NULL,'','','Single Mother','','','','','','','Master\'s Degree','','',''),(102,'qSepvY8FTM','culverh@hotmail.com','4030c31ce236f25231bc563bbb52e93dbe4d9169','+T9pp,5Z','Unconfirmed',1,0,'','','','I am 33 years old and a single mom of 5. ','US','','0000-00-00',0,'2020-04-15 20:42:07','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','01062',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','--Any--','','Animals,Art,Computer/Video Games,Crafts,Kids Arts/Crafts,Music,Painting,Photography,Play Sports,Traveling','','White/Caucasian','','','','','Heather Culver','--Any--','','Crafts,Painting,Photography','Single Mother','','','','','','','Some High School','','',''),(103,'R66qREUQzY','rebeccanurickwood@hotmail.com','6b0191dfbd1d6be301571192173e709ae862ded6','uvWeWmD=','Active',1,0,'','','','Single (divorced) mother with two young boys. Looking to connect with / get support from / provide support to other like minded people! ','US','','0000-00-00',0,'2020-04-16 03:45:39','2020-04-16 03:49:03','2020-04-16 03:48:03','2020-04-16 04:03:21',0,'','06907',1,1,0,3,0,0,0,3,3,'online','',0,0,'','','','','Jewish','','Beauty,Cooking,Crafts,Dancing,Kids Arts/Crafts,Movies,Museums,Photography,Play Sports,Watching Sports,Workout','','Human','','','','','Rebecca N W','Non-Political','','Photography,Museums','Single Mother','','','','Aerobics,Football,Running,Skiing,Tennis,Weight Lifting,Workout','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Paid Sick and Parental Leave,Reproductive Rights,Violence Against Women,Women’s Rights','','Bachelor\'s Degree','','',''),(104,'QHzAFfxKDH','pfirinne@gmail.com','095f417afa2d4f81a3919cbda0f5df0e86f03e9a','is3CgjLa','Active',1,0,'','','','I am single mom to 3 teens. I work full time as a Rehabilitation Counselor for Deaf blind and blind individuals and their families.  ','US','','0000-00-00',0,'2020-04-16 07:18:08','0000-00-00 00:00:00','2020-04-16 07:18:58','2020-04-16 07:20:12',0,'','01002',1,1,0,2,0,0,0,3,3,'online','',0,0,'','','','','Unitarianism','','Animals,Concerts,Movies,Music,Photography,Reading','','White/Caucasian','','','','','Peggy Feldmann Firinne','Very Liberal','Acupuncture,Chiropractic','Crafts,Photography,Museums','Single Mother','Fiction,Non Fiction','','','','Affordable Child Care,Equal Rights,Health,Paid Sick and Parental Leave,Reproductive Rights,Violence Against Women,Women’s Rights','','Bachelor\'s Degree','','',''),(105,'37m79fAXaV','ellabarron@comcast.net','dc91540bc130b7c38b8b77d449ffb672d59642b8','S7DhPLSf','Unconfirmed',1,0,'','','','My daughter is grown and not living at home. I would like to be a support to single moms because it was a rough and rewarding road for me.','US','','0000-00-00',0,'2020-04-16 09:47:31','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','01062',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Spiritual but not religious','','Animals,Antiques,Art,Astrology,Beauty,Cooking,Dancing,Decorating,Galleries,Health,Jewelry Making,Movies,Reading,Singing','','Human','','','','','Paula','Very Liberal','Acupuncture,Bio Feedback,Chiropractic,Energy Therapies,FeldenKrais,Herbalism,Homeopathy,Meditation','Jewelry Making,Photography,Galleries,Museums','Single Mother','Comedy,Fiction,Literary Fiction,Non Fiction','','','Aerobics,Yoga','Equal Rights,Health,Women’s Rights','','Bachelor\'s Degree','','',''),(106,'RKbUbf7f9V','maiaharris208@gmail.com','5ae57e5e3d43db781e418767f509aac3736a8743','vFMFkbHJ','Unconfirmed',1,0,'','','','I\'d like to learn a little more about this before writing anything about myself. thanks.\r\n','US','','0000-00-00',0,'2020-04-16 11:36:58','0000-00-00 00:00:00','2021-02-26 06:11:50','2021-02-26 08:10:08',0,'','01096',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Jewish','','Cooking,Gardening,Hiking,Movies,Museums,Music,Reading,Traveling,Writing','','Human','','','','','Maia Harris','Very Liberal','','Photography,Museums','Single Mother','Literary Fiction,Non Fiction','','','Running,Swimming,Yoga','Affordable Child Care,Equal Rights,Health,Paid Sick and Parental Leave,Reproductive Rights','Recorder','Master\'s Degree','','',''),(107,'86kfCvXpZb','Catsarge@juno.com','fd978c6ebdce1954ec18244dbfb4b7b697e03b2a','BNj!vvHQ','Active',1,0,'','','','Single Mom of a 14 y/o boy adopted from Kazakhstan.   Work in human services.  Late 50s.  Missing human contact during this time of physical distancing.','US','','0000-00-00',0,'2020-04-16 17:49:52','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','01060',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Spiritual but not religious','','Camping,Concerts,Cycling,Hiking,Movies,Music,Singing','','White/Caucasian','','','','','Cathy Sargent','Liberal','Meditation','Crafts','Single Mother','Comedy,Drama,Fiction,Literary Fiction,Mystery,Non Fiction,Science','','','Yoga','Affordable Child Care,Paid Sick and Parental Leave,Poverty,Reproductive Rights','Voice','Master\'s Degree','','',''),(109,'e8DrXQ2jPw','rebeccagfeinberg@gmail.com','0487c95000640cb05c8d3d0595831402b2cd0179','PTNS2dgJ','Active',1,0,'','','','I\'ve been a single mom for the past 11 years. My son is 14 years old, and we recently relocated to Amherst. I\'m always interested in connecting with other single moms!','US','','0000-00-00',0,'2020-04-19 11:40:49','2020-04-19 11:44:37','2020-04-19 11:41:17','2020-04-19 18:13:36',0,'','01002',1,1,0,1,0,0,0,3,3,'online','',0,0,'','','','','Jewish','','Cooking,Crafts,Gardening,Health,Hiking,Knitting,Movies,Writing','','White/Caucasian','','','','','Rebecca Feinberg','Liberal','','','Single Mother','','','','Yoga','','','Master\'s Degree','','',''),(110,'5fXicRCizb','Emilyachandler1@gmail.com','812592feb0af9cf7300a73c533595b8f12382988','By5!xA5y','Suspended',1,0,'','','','Single mom of 8 and 3 year olds, 100% of the time.','US','','0000-00-00',0,'2020-04-19 12:17:54','0000-00-00 00:00:00','2020-04-19 14:04:43','2020-04-19 14:08:41',0,'','01002',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','',NULL,'','','','Human','','','','','Emily Chandler',NULL,'','','Single Mother','','','','','','','Master\'s Degree','','',''),(111,'FvmSuqPJCv','Bekind291@gmail.com','4f600fc6c87034e7ad534928e63f99827ee25f2b','5+.v8/t7','Active',1,0,'','','','','US','','0000-00-00',0,'2020-04-19 12:54:22','0000-00-00 00:00:00','2020-04-27 16:47:15','2020-04-27 16:50:46',0,'','01002',1,1,0,1,0,0,0,3,3,'online','',0,0,'','','','','Atheist','','Animals,Cooking,Crafts,Kids Arts/Crafts,Knitting,Movies,Museums,Reading,Singing','','Asian','','','','','Jennifer Page','Very Liberal','','Crafts','Single Mother','Comedy,Drama,Erotica,Fiction,Literary Fiction,Non Fiction,Romance','','','Yoga','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights','','Bachelor\'s Degree','','',''),(112,'yDqQSPiH9m','walkdabeach@gmail.com','48ba5777b6964007dbe61b6f6f1b0752cb68cea1','&AhF?aa6','Unconfirmed',1,0,'','','','My name is JoAnn Logan and I am a mother of twin boys (9) and a girl (7).  I am an entrepreneur and enjoy supporting woman business owners. I have a company name Good Fortune Hawaii. I represent over $5B in private funds and high net-worth investors. I offer creative financing that does not rely on credit score.  Just 50 percent collateral and 10-15% capital. Why give away equity when you can likely qualify for financing and continue to own your business?  I look forward to meeting you and learning about your business and goals. ','US','','0000-00-00',0,'2020-04-26 21:12:54','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','96825',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Christian / Protestant','','Animals,Art,Beauty,Concerts,Cooking,Decorating,Fashion,Gardening,Hiking,Movies,Museums,Music,Play Sports,Reading,Singing,Sewing,Traveling,Watching Sports,Workout,Writing','','White/Caucasian','','','','','JoAnn Logan','Middle of The Road','Acupuncture,Chiropractic','Crafts,Drawing,Galleries,Museums','Single Mother','Comedy,Romance','','','Paddle Boarding,Swimming,Yoga,Zumba','Discrimination in the Work Force,Equal Rights,Inadequate Representation,Violence Against Women','Piano,Voice','Master\'s Degree','','',''),(113,'LgqmcMg7wv','sisterinchrist83@yahoo.com','e45eac0b2c51713e9487418d0e65e2cfc62c9793','rCi=!+d=','Active',1,0,'','','','I am a single mom of a 1 yr old with epilepsy.','US','','0000-00-00',0,'2020-05-02 00:31:17','0000-00-00 00:00:00','2020-05-02 13:52:38','2020-05-02 14:17:02',0,'','21811',1,1,0,1,0,0,0,3,3,'online','',0,0,'','','','','Christian / Other','','Art,Beauty,Crafts,Decorating,Kids Arts/Crafts,Painting,Reading,Singing','','Black/African Descent','','','','','Sheinka Nicole Floyd','Liberal','Meditation','Crafts','Single Mother','','','','Zumba','','','Some College','','',''),(114,'NDxct2hufr','fkaulconnolly@gmail.com','a192a08db8d55783c72e590c0ef8532d9cf65225','T86zhK+/','Active',1,0,'','','','Newly single mother since 9/2019.\r\nInterested in connecting with other mothers or fathers in this position.\r\n','US','','0000-00-00',0,'2020-05-06 17:05:38','0000-00-00 00:00:00','2020-05-06 17:07:01','2020-05-06 17:17:45',0,'','01039',1,1,0,1,0,0,0,3,3,'online','',0,0,'','','','','--Any--','','Animals','','Human','','','','','Fiona Kaul-Connolly','Non-Conformist','Acupuncture,Chiropractic,Energy Therapies,Herbalism,Homeopathy,Meditation','','Single Mother','','','','','','','Elementary School','','',''),(115,'Vxjr9wJxW8','melstruzzi@yahoo.com','06532e0a43686e3ebcf07ec76c272f0a3ecde6a2',',Tv5jRYb','Active',1,0,'','','','Mother of 2 boys ages 8 & 11, separated a year ago & pending divorce. ','US','','0000-00-00',0,'2020-05-08 15:54:51','0000-00-00 00:00:00','2020-05-09 08:45:21','2020-05-09 08:56:01',0,'','28715',1,1,0,1,0,0,0,3,3,'online','',0,0,'','','','','Unitarianism','','Animals,Art,Decorating,Drawing,Movies,Reading,Writing','','White/Caucasian','','','','','Melanie Struzzi Sutton','Liberal','Meditation','Drawing','Single Mother','Comedy,Drama,Erotica,Fantasy,Fiction,Literary Fiction,Non Fiction,Science','','','','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights','Voice','PhD. Or Post Doc.','','',''),(116,'JBfvfivaLC','Dragonfly112880@yahoo.com','c6eedfa4bc7d16f7b7b447abf364ae085e179cce','Y726KMuq','Active',1,0,'','','','I am a Single Mom to an Eleven year old girl. I recently moved back to Western Ma after being in the Boston area the past 20 years. I have custody of my daughter. ','US','','0000-00-00',0,'2020-05-17 14:06:47','0000-00-00 00:00:00','2020-05-18 21:03:46','2020-05-18 21:52:03',0,'','01096',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','',NULL,'','Animals,Antiques,Art,Cooking,Crafts,Decorating,Drawing,Galleries,Gardening,Jewelry Making,Kids Arts/Crafts,Movies,Museums,Painting,Photography,Sewing,Sculpture','','White/Caucasian','','','','','Eileen','Very Liberal','','Crafts,Drawing,Jewelry Making,Painting,Photography,Galleries,Museums','Single Mother','','','','','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Poverty,Reproductive Rights,Violence Against Women,Women’s Rights','','Bachelor\'s Degree','','',''),(117,'aXZaFdVp7h','lisa.a.jackson@fsu.edu','2425174421a1df278e8696abb73cbd79efc3b2ff','7eK2r7Di','Active',1,0,'','','','Mother of two, student affairs professional at large state higher education institution, licensed social worker.\r\n','US','','0000-00-00',0,'2020-07-11 10:59:11','0000-00-00 00:00:00','2020-07-11 14:16:16','2020-07-11 14:17:00',0,'','32312',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Christian / Other','','Animals,Antiques,Art,Camping,Cooking,Gardening,Health,Hiking,Movies,Music,Photography,Workout','','White/Caucasian','','','','','Lisa Jackson','Other Point of View','Chiropractic','Photography','Involved Woman','Comedy,Drama','','','Paddle Boarding,Running','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights','','Master\'s Degree','','',''),(118,'2vFkQEdxgh','euta_filo.acnibo@yahoo.com','ba4716526dd348b4cf7ec7f863d99c2fa5cca5b9','FbzwqDdw','Active',1,0,'','','','Hi, My name is Alvyna and I was recently medically discharged from the military in August of this year.  I have two beautiful daughters, who\'ve I\'ve raised on my own for the past 5 years.  I have my eldest who is about to start high school and my youngest who will be in middle school next year.  \r\nI\'m 35 years old, and I will be starting as a full time student next year studying Architecture at the Academy of Art University in San Francisco California.  I\'ve been involved with my partner for the past three years, geographically separated for all 3, but blessed to have all of us under one roof since I left the Air Force.  I\'m excited to see where this community goes, and also very pleased to be accepted as part of this community.   ','US','','0000-00-00',0,'2020-09-19 01:05:27','0000-00-00 00:00:00','2020-09-19 01:08:52','2020-09-19 01:22:24',0,'','93308',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Christian / Other','','Animals,Art,Beauty,Camping,Crafts,Dancing,Decorating,Fashion,Gardening,Movies,Museums','','Pacific Islander','','','','','Alvyna Tuiaulia Euta-Filo','Non-Political','Acupuncture,Chiropractic,Energy Therapies,Meditation','Drawing,Museums','Single Mother,Involved Woman','Fiction,Mystery','','','Workout','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights','','Associates Degree','','',''),(119,'f9h8rYWuxb','Smvich@gmail.com','32da92f9ead4d3c03211d20e5c6c2a8f9166e337','4Q+nftdv','Approval',1,0,'','','','','US','','0000-00-00',0,'2020-10-30 10:09:58','0000-00-00 00:00:00','2020-10-30 10:11:43','2020-10-30 13:59:14',0,'','80904',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Christian / Other','','Cooking,Crafts,Reading,Traveling,Writing','','White/Caucasian','','','','','Shannon Singlevich','Conservative','Chiropractic,Energy Therapies,Homeopathy,Meditation','Crafts,Painting,Photography,Videography,Galleries,Museums','Involved Woman','Literary Fiction,Non Fiction','','','Cycling,Golf,Martial Arts,Snowboarding,Workout,Yoga','Affordable Child Care,Free Speech,Human Trafficking/Sex Slavery,Paid Sick and Parental Leave,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights','','Bachelor\'s Degree','','',''),(120,'QzACzMzwtq','kcollins2420@gmail.com','6384c038cd4f8d1de1b38051c39fb34257996531','Ui5d8wkZ','Unconfirmed',1,0,'','','','I am a single mom to a 20, 9 and 6 year old. I do it all alone with no help. My kids father is not involved at all, which breaks my heart for my boys. Everything I do is for my boys. ','US','','0000-00-00',0,'2020-11-20 08:37:16','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','20120',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Christian / Other','','Movies,Music,Play Sports,Workout','','White/Caucasian','','','','','Katie Collins','Non-Political','','Photography','Single Mother','Drama','','','Football','Affordable Child Care,Paid Sick and Parental Leave,Poverty,Violence Against Women','Voice','Some College','','',''),(121,'UpF83KeZM7','andyandrenagaines@gmail.com','c8770bcb141d55800e0be53bd4b0afe32164d44c','mYC9FS.h','Unconfirmed',1,0,'','','','','US','','0000-00-00',0,'2020-11-20 08:40:57','0000-00-00 00:00:00','2020-11-24 19:17:30','2020-11-24 19:18:25',0,'','20115',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Christian / Other','','Beauty,Concerts,Movies,Music,Reading','','White/Caucasian','','','','','Rena Gaines',NULL,'','','Single Mother','Comedy,Drama','','','Swimming,Zumba','','',NULL,'','',''),(122,'w8EthF9xbh','melaniekpowell@gmail.com','a263d266adf763073b0342b0b717121c086c6be8','=kd6rExw','Unconfirmed',1,0,'','','','Single mom of 2 daughters left my abusive ex husband in 2015 with a couple suitcase of belongings. I live in Northern Virginia near DC. All of my family is in Alabama, Louisiana, and Texas. I have no support system. I lost my job 3 weeks ago. I found a lump on my breast and don\'t have insurance to seak treatment. I need all the help I can get.','US','','0000-00-00',0,'2020-11-20 09:11:37','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','22015',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Christian / Other','','Animals,Concerts,Cooking,Kids Arts/Crafts,Music,Photography,Reading,Traveling','','White/Caucasian','','','','','Melanie Powell','Middle of The Road','Chiropractic,Meditation','Crafts,Photography','Single Mother','Comedy,Drama,Erotica,Fiction,Romance','','','Baseball,Football,Paddle Boarding,Rowing,Swimming,Workout,Yoga,Zumba','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Violence Against Women,Women’s Rights','Guitar,Ukulele','Some College','','',''),(123,'HMvTQqfzkq','Burchieg@comcast.net','ff925ca3b98df12f8fe915ef79d2c5f47b77f4ab','&55XErCc','Unconfirmed',1,0,'','','','I\'m a married woman with a teenager but I work at a Montessori School with some single parents so thought I\'d join.\r\n','US','','0000-00-00',0,'2020-11-29 23:34:46','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','01039',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Spiritual but not religious','','Animals,Camping,Health,Hiking,Music,Singing','','White/Caucasian','','','','','Catherine B Green','Liberal','Acupuncture,Chiropractic,Energy Therapies,Homeopathy,Meditation','','Involved Woman','Drama,Fiction,Mystery,Science','','','Cycling,Skiing,Swimming,Yoga','Equal Rights,Health,Women’s Rights','Banjo,Djembe Drum,Guitar,Ukulele,Voice','Bachelor\'s Degree','','',''),(124,'MFFnCNyL2e','booberry_22@hotmail.com','f624f3ae5f3e00dcd6d925c168075e2e90064c2d','DgasvULL','Unconfirmed',1,0,'','','','Single mom','US','','0000-00-00',0,'2020-12-06 06:50:51','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','22485',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Christian / Other','','Animals,Beauty,Cooking,Decorating,Gardening','','White/Caucasian','','','','','carey nicholson','Middle of The Road','Acupuncture,Meditation','','Single Mother','','','','','','','Bachelor\'s Degree','','',''),(125,'rAseSfZkzF','mrsvabrown@gmail.com','014c2d1d31394f64b313e1506a38bbe2c3571c44','xEG,9HqD','Unconfirmed',1,0,'','','','Single mom for 10 years. My husband and I have a non-profit that helps single mothers called Giving Words. ','US','','0000-00-00',0,'2020-12-06 07:24:55','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','22942',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Christian / Protestant','','Camping,Cycling,Gardening,Health,Kids Arts/Crafts,Movies,Museums,Music,Reading,Singing,Traveling','','White/Caucasian','','','','','Virginia Brown','Middle of The Road','Acupuncture,Chiropractic,Meditation','Galleries,Museums','Involved Woman','Comedy,Drama,Fiction,Literary Fiction,Mystery,Non Fiction','','','Aerobics,Cycling,Tennis,Volleyball,Yoga,Zumba','Affordable Child Care,Human Trafficking/Sex Slavery,Poverty,Pregnancy,Violence Against Women,Women’s Rights','Piano','Bachelor\'s Degree','','',''),(126,'kYsFRbSafT','jenniferfitch@hotmail.com','07e1985043c90dae32fefd4d7153de9507168628','P!=ESjJ8','Unconfirmed',1,0,'','','','Sole custody single mother to a 7 ur old boy and 9 year old girl.','US','','0000-00-00',0,'2020-12-06 08:23:09','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','20169',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Agnostic','','Animals,Antiques,Art,Astrology,Beauty,Camping,Concerts,Computer/Video Games,Cooking,Crafts,Cycling,Decorating,Drawing,Fashion,Galleries,Gardening,Health,Hiking,Jewelry Making,Kids Arts/Crafts,Movies,Museums,Music,Painting,Traveling,Workout','','White/Caucasian','','','','','Jennifer Robinson','Conservative','','Crafts,Drawing,Edging,Jewelry Making,Painting,Galleries,Museums','Single Mother','Comedy,Non Fiction','','','Workout','Affordable Child Care,Health,Human Trafficking/Sex Slavery,Poverty,Violence Against Women,Women’s Rights','','Bachelor\'s Degree','','',''),(127,'CRSWcbgQWh','zs878@yahoo.com','3f93ee711c0df66b31239025bf1a4f2e0d319058','u,Da=X&9','Active',1,0,'','','','','US','','0000-00-00',0,'2020-12-06 17:23:18','0000-00-00 00:00:00','2020-12-06 17:24:37','2020-12-06 17:26:16',0,'','20112',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','','Christian / Other','','Astrology,Beauty,Cooking,Gardening,Kids Arts/Crafts,Movies,Reading,Watching Sports,Writing','','Latino/Hispanic','','','','','Zelda Sligh','Non-Political','Acupuncture,Chiropractic,Homeopathy,Meditation','Drawing,Painting','Involved Woman','Comedy','','','Basketball,Volleyball','Affordable Child Care,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Paid Sick and Parental Leave,Poverty,Reproductive Rights,Women’s Rights','','Some College','','',''),(128,'jPiBQVPzDB','hro.nicole@yahoo.com','66195b42f83cfad53cd50b6a017c9e7e2c31c97a','v2,KQn9A','Active',1,0,'','','','','US','','0000-00-00',0,'2020-12-07 14:43:45','0000-00-00 00:00:00','2020-12-07 14:44:40','2020-12-31 17:24:55',0,'','22192',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','',NULL,'','Art,Astrology,Dancing,Photography','','White/Caucasian','','','','','Heather',NULL,'Acupuncture,Bio Feedback,Chiropractic,Energy Therapies,Herbalism,Homeopathy,Meditation','Photography,Galleries,Museums','Single Mother','','','','Snowboarding,Yoga','Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights','',NULL,'','',''),(129,'8kKXPvRtmh','mexicanlol709@hotmail.com','300f7c5a7ce1b5938df4744c667d6ec3b2069e48','MRv.,b!t','Active',1,0,'','','','','US','','0000-00-00',0,'2020-12-13 08:09:40','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'','20191',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','',NULL,'','','','Latino/Hispanic','','','','','Alma',NULL,'','','Single Mother,Single Woman,Involved Woman','','','','','','',NULL,'','',''),(130,'uV8NCLP2x7','farmergirlbrown@aol.com','9b8417e8d2df017c5bd2bc06567daea1f25c4d9b','P/Q3Htj5','Active',1,0,'','','','I\'m a mom who is a champion for women\'s wellness.','US','','0000-00-00',0,'2020-12-17 09:03:39','2020-12-17 18:25:50','2020-12-17 10:25:48','2020-12-17 18:26:22',0,'','39213',1,1,0,0,0,0,0,3,3,'online','',0,0,'','','','',NULL,'','Camping,Gardening,Health,Hiking,Kids Arts/Crafts','',NULL,'','','','','Marie ',NULL,'Acupuncture,Chiropractic,Herbalism','Jewelry Making,Photography','Single Mother','','','','','Health,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Women’s Rights','','Some College','','','');

--
-- Table structure for table `RayBoardBoards`
--

CREATE TABLE `RayBoardBoards` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) NOT NULL DEFAULT '',
  `Password` varchar(255) NOT NULL DEFAULT '',
  `OwnerID` varchar(20) NOT NULL DEFAULT '0',
  `When` int(11) DEFAULT NULL,
  `Status` enum('new','normal','delete') NOT NULL DEFAULT 'new',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayBoardBoards`
--


--
-- Table structure for table `RayBoardCurrentUsers`
--

CREATE TABLE `RayBoardCurrentUsers` (
  `ID` varchar(20) NOT NULL DEFAULT '',
  `Nick` varchar(255) NOT NULL,
  `Sex` enum('M','F') NOT NULL DEFAULT 'M',
  `Age` int(11) NOT NULL DEFAULT '0',
  `Photo` varchar(255) NOT NULL DEFAULT '',
  `Profile` varchar(255) NOT NULL DEFAULT '',
  `Desc` varchar(255) NOT NULL,
  `When` int(11) NOT NULL DEFAULT '0',
  `Status` enum('new','old','idle') NOT NULL DEFAULT 'new',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayBoardCurrentUsers`
--


--
-- Table structure for table `RayBoardUsers`
--

CREATE TABLE `RayBoardUsers` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Board` int(11) NOT NULL DEFAULT '0',
  `User` varchar(20) NOT NULL DEFAULT '',
  `When` int(11) DEFAULT NULL,
  `Status` enum('normal','delete') NOT NULL DEFAULT 'normal',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayBoardUsers`
--


--
-- Table structure for table `RayChatCurrentUsers`
--

CREATE TABLE `RayChatCurrentUsers` (
  `ID` varchar(20) NOT NULL DEFAULT '',
  `Nick` varchar(36) NOT NULL DEFAULT '',
  `Sex` enum('M','F') NOT NULL DEFAULT 'M',
  `Age` int(11) NOT NULL DEFAULT '0',
  `Desc` text NOT NULL,
  `Photo` varchar(255) NOT NULL DEFAULT '',
  `Profile` varchar(255) NOT NULL DEFAULT '',
  `Online` varchar(10) NOT NULL DEFAULT 'online',
  `Start` int(11) NOT NULL DEFAULT '0',
  `When` int(11) NOT NULL DEFAULT '0',
  `Status` enum('new','old','idle','kick','type','online') NOT NULL DEFAULT 'new',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayChatCurrentUsers`
--


--
-- Table structure for table `RayChatHistory`
--

CREATE TABLE `RayChatHistory` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Room` int(11) NOT NULL DEFAULT '0',
  `SndRcp` varchar(40) NOT NULL DEFAULT '',
  `Sender` varchar(20) NOT NULL DEFAULT '',
  `Recipient` varchar(20) NOT NULL DEFAULT '',
  `Message` text NOT NULL,
  `When` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayChatHistory`
--


--
-- Table structure for table `RayChatMemberships`
--

CREATE TABLE `RayChatMemberships` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Setting` int(11) NOT NULL DEFAULT '0',
  `Value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `Membership` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `RayChatMemberships`
--


--
-- Table structure for table `RayChatMembershipsSettings`
--

CREATE TABLE `RayChatMembershipsSettings` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `Caption` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `Type` enum('boolean','number','custom') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'boolean',
  `Default` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `Range` int(3) NOT NULL DEFAULT '3',
  `Error` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `RayChatMembershipsSettings`
--

INSERT INTO `RayChatMembershipsSettings` VALUES (1,'RoomCreate','New Rooms Creating:','boolean','true',1,'RayzRoomCreate'),(2,'PrivateRoomCreate','Private Rooms Creating:','boolean','true',1,'RayzPrivateRoomCreate'),(3,'AVCasting','Audio/Video Casting:','boolean','true',1,'RayzAVCasting'),(4,'AVPlaying','Audio/Video Playing (for Messenger):','boolean','true',1,'RayzAVPlaying'),(5,'AVLargeWindow','Enable Large Video Window:','boolean','true',1,'RayzAVLargeWindow'),(6,'FileSend','Files Sending:','boolean','true',1,'RayzFileSend'),(7,'WhisperMessages','Whispering Messages:','boolean','true',1,'RayzWhisperMessages'),(8,'DirectMessages','Addressed Messages:','boolean','true',1,'RayzDirectMessages'),(9,'RoomsNumber','Maximum Rooms Number:','number','100',3,'RayzRoomsNumber'),(10,'ChatsNumber','Maximum Private Chats Number:','number','100',3,'RayzChatsNumber'),(11,'AVWindowsNumber','Maximum Video Windows Number:','number','100',3,'RayzAVWindowsNumber'),(12,'RestrictedRooms','Restricted Rooms:','custom','',1,'RayzRestrictedRooms');

--
-- Table structure for table `RayChatMessages`
--

CREATE TABLE `RayChatMessages` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Room` int(11) NOT NULL DEFAULT '0',
  `SndRcp` varchar(40) NOT NULL DEFAULT '',
  `Sender` varchar(20) NOT NULL DEFAULT '',
  `Recipient` varchar(20) NOT NULL DEFAULT '',
  `Whisper` enum('true','false') NOT NULL DEFAULT 'false',
  `Message` text NOT NULL,
  `Style` text NOT NULL,
  `Type` varchar(10) NOT NULL DEFAULT 'text',
  `When` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayChatMessages`
--


--
-- Table structure for table `RayChatProfiles`
--

CREATE TABLE `RayChatProfiles` (
  `ID` varchar(20) NOT NULL DEFAULT '0',
  `Banned` enum('true','false') NOT NULL DEFAULT 'false',
  `Type` varchar(10) NOT NULL DEFAULT 'full',
  `Smileset` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayChatProfiles`
--


--
-- Table structure for table `RayChatRooms`
--

CREATE TABLE `RayChatRooms` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) NOT NULL DEFAULT '',
  `Password` varchar(255) NOT NULL DEFAULT '',
  `Desc` text NOT NULL,
  `OwnerID` varchar(20) NOT NULL DEFAULT '0',
  `When` int(11) DEFAULT NULL,
  `Status` enum('normal','delete') NOT NULL DEFAULT 'normal',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayChatRooms`
--

INSERT INTO `RayChatRooms` VALUES (1,'Lobby','','Welcome to our chat! You are in the \"Lobby\" now, but you can pass into any other public room you wish to - take a look at the \"All rooms\" box.','0',0,'normal'),(2,'Friends','','Welcome to the \"Friends\" room! This is a public room where you can have a fun chat with existing friends or make new ones! Enjoy!','0',1,'normal');

--
-- Table structure for table `RayChatRoomsUsers`
--

CREATE TABLE `RayChatRoomsUsers` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Room` int(11) NOT NULL DEFAULT '0',
  `User` varchar(20) NOT NULL DEFAULT '',
  `When` int(11) DEFAULT NULL,
  `Status` enum('normal','delete') NOT NULL DEFAULT 'normal',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayChatRoomsUsers`
--


--
-- Table structure for table `RayImContacts`
--

CREATE TABLE `RayImContacts` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `SenderID` int(11) NOT NULL DEFAULT '0',
  `RecipientID` int(11) NOT NULL DEFAULT '0',
  `Online` varchar(10) NOT NULL DEFAULT 'online',
  `When` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayImContacts`
--


--
-- Table structure for table `RayImMessages`
--

CREATE TABLE `RayImMessages` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ContactID` int(11) NOT NULL DEFAULT '0',
  `Message` text NOT NULL,
  `Style` text NOT NULL,
  `Type` varchar(10) NOT NULL DEFAULT 'text',
  `When` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayImMessages`
--


--
-- Table structure for table `RayImPendings`
--

CREATE TABLE `RayImPendings` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `SenderID` int(11) NOT NULL DEFAULT '0',
  `RecipientID` int(11) NOT NULL DEFAULT '0',
  `Message` varchar(255) NOT NULL DEFAULT '',
  `When` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `RecipientID` (`RecipientID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayImPendings`
--


--
-- Table structure for table `RayImProfiles`
--

CREATE TABLE `RayImProfiles` (
  `ID` int(11) NOT NULL DEFAULT '0',
  `Smileset` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayImProfiles`
--


--
-- Table structure for table `RayMp3Files`
--

CREATE TABLE `RayMp3Files` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Categories` text NOT NULL,
  `Title` varchar(255) NOT NULL DEFAULT '',
  `Uri` varchar(255) NOT NULL DEFAULT '',
  `Tags` text NOT NULL,
  `Description` text NOT NULL,
  `Time` int(11) NOT NULL DEFAULT '0',
  `Date` int(20) NOT NULL DEFAULT '0',
  `Reports` int(11) NOT NULL DEFAULT '0',
  `Owner` varchar(64) NOT NULL DEFAULT '',
  `Listens` int(12) DEFAULT '0',
  `Rate` float NOT NULL,
  `RateCount` int(11) NOT NULL,
  `CommentsCount` int(11) NOT NULL,
  `Featured` tinyint(4) NOT NULL,
  `Status` enum('approved','disapproved','pending','processing','failed') NOT NULL DEFAULT 'pending',
  PRIMARY KEY (`ID`),
  KEY `Owner` (`Owner`),
  FULLTEXT KEY `ftMain` (`Title`,`Tags`,`Description`,`Categories`),
  FULLTEXT KEY `ftTags` (`Tags`),
  FULLTEXT KEY `ftCategories` (`Categories`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayMp3Files`
--


--
-- Table structure for table `RayMp3Tokens`
--

CREATE TABLE `RayMp3Tokens` (
  `ID` int(11) NOT NULL DEFAULT '0',
  `Token` varchar(32) NOT NULL DEFAULT '',
  `Date` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`,`Token`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayMp3Tokens`
--


--
-- Table structure for table `RayShoutboxMessages`
--

CREATE TABLE `RayShoutboxMessages` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `UserID` varchar(20) NOT NULL DEFAULT '0',
  `Msg` text NOT NULL,
  `When` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayShoutboxMessages`
--


--
-- Table structure for table `RayVideoFiles`
--

CREATE TABLE `RayVideoFiles` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Categories` text NOT NULL,
  `Title` varchar(255) NOT NULL DEFAULT '',
  `Uri` varchar(255) NOT NULL DEFAULT '',
  `Tags` text NOT NULL,
  `Description` text NOT NULL,
  `Time` int(11) NOT NULL DEFAULT '0',
  `Date` int(20) NOT NULL DEFAULT '0',
  `Owner` varchar(64) NOT NULL DEFAULT '',
  `Views` int(12) DEFAULT '0',
  `Rate` float NOT NULL,
  `RateCount` int(11) NOT NULL,
  `CommentsCount` int(11) NOT NULL,
  `Featured` tinyint(4) NOT NULL,
  `Status` enum('approved','disapproved','pending','processing','failed') NOT NULL DEFAULT 'pending',
  `Source` varchar(20) NOT NULL DEFAULT '',
  `Video` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`),
  KEY `Owner` (`Owner`),
  FULLTEXT KEY `ftMain` (`Title`,`Tags`,`Description`,`Categories`),
  FULLTEXT KEY `ftTags` (`Tags`),
  FULLTEXT KEY `ftCategories` (`Categories`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayVideoFiles`
--


--
-- Table structure for table `RayVideoTokens`
--

CREATE TABLE `RayVideoTokens` (
  `ID` int(11) NOT NULL DEFAULT '0',
  `Token` varchar(32) NOT NULL DEFAULT '',
  `Date` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`,`Token`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayVideoTokens`
--


--
-- Table structure for table `RayVideo_commentsFiles`
--

CREATE TABLE `RayVideo_commentsFiles` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Categories` text NOT NULL,
  `Title` varchar(255) NOT NULL DEFAULT '',
  `Uri` varchar(255) NOT NULL DEFAULT '',
  `Tags` text NOT NULL,
  `Description` text NOT NULL,
  `Time` int(11) NOT NULL DEFAULT '0',
  `Date` int(20) NOT NULL DEFAULT '0',
  `Owner` varchar(64) NOT NULL DEFAULT '',
  `Views` int(12) DEFAULT '0',
  `Status` enum('approved','disapproved','pending','processing','failed') NOT NULL DEFAULT 'pending',
  PRIMARY KEY (`ID`),
  KEY `Owner` (`Owner`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayVideo_commentsFiles`
--


--
-- Table structure for table `RayVideo_commentsTokens`
--

CREATE TABLE `RayVideo_commentsTokens` (
  `ID` int(11) NOT NULL DEFAULT '0',
  `Token` varchar(32) NOT NULL DEFAULT '',
  `Date` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`,`Token`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayVideo_commentsTokens`
--


--
-- Table structure for table `States`
--

CREATE TABLE `States` (
  `Country` varchar(255) NOT NULL,
  `CountryCode` varchar(5) NOT NULL,
  `State` varchar(255) NOT NULL,
  `StateCode` varchar(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `States`
--

INSERT INTO `States` VALUES ('Afghanistan','AF','Badakhshan','BAD'),('Afghanistan','AF','Badghis','BAH'),('Afghanistan','AF','Baghlan','BAG'),('Afghanistan','AF','Balkh','BAL'),('Afghanistan','AF','Bamian','BAM'),('Afghanistan','AF','Farah','FAR'),('Afghanistan','AF','Faryab','FAY'),('Afghanistan','AF','Ghazni','GHA'),('Afghanistan','AF','Ghowr','GHO'),('Afghanistan','AF','Helmand','HEL'),('Afghanistan','AF','Herat','HER'),('Afghanistan','AF','Jowzjan','JOW'),('Afghanistan','AF','Kabol','KAB'),('Afghanistan','AF','Kandahar','KAN'),('Afghanistan','AF','Kapisa','KAP'),('Afghanistan','AF','Khowst','KHW'),('Afghanistan','AF','Konar','KNR'),('Afghanistan','AF','Kondoz','KON'),('Afghanistan','AF','Laghman','LAG'),('Afghanistan','AF','Lowgar','LOW'),('Afghanistan','AF','Nangarhar','NAN'),('Afghanistan','AF','Nimruz','NIM'),('Afghanistan','AF','Nurestan','NUR'),('Afghanistan','AF','Oruzgan','ORU'),('Afghanistan','AF','Paktia','PKT'),('Afghanistan','AF','Paktika','PAK'),('Afghanistan','AF','Parvan','PAR'),('Afghanistan','AF','Samangan','SAM'),('Afghanistan','AF','Sar-e Pol','SAR'),('Afghanistan','AF','Takhar','TAK'),('Afghanistan','AF','Unknown','UNK'),('Afghanistan','AF','Vardak','VAR'),('Afghanistan','AF','Zabol','ZAB'),('Albania','AL','Beratit','BER'),('Albania','AL','Dibres','DIB'),('Albania','AL','Durresit','DUR'),('Albania','AL','Elbasanit','ELB'),('Albania','AL','Fierit','FIE'),('Albania','AL','Gjirokastres','GJI'),('Albania','AL','Korces','KOR'),('Albania','AL','Kukesit','KUK'),('Albania','AL','Lezhes','LEZ'),('Albania','AL','Shkodres','SHK'),('Albania','AL','Tiranes','TIR'),('Albania','AL','Vlores','VLO'),('Algeria','DZ','Adrar','ADR'),('Algeria','DZ','Ain Defla','AID'),('Algeria','DZ','Ain Temouchent','AIT'),('Algeria','DZ','Alger','ALG'),('Algeria','DZ','Annaba','ANN'),('Algeria','DZ','Batna','BAT'),('Algeria','DZ','Bechar','BEC'),('Algeria','DZ','Bejaia','BEJ'),('Algeria','DZ','Biskra','BIS'),('Algeria','DZ','Blida','BLI'),('Algeria','DZ','Bordj Bou Arreridj','BOR'),('Algeria','DZ','Bouira','BOU'),('Algeria','DZ','Chlef','CHL'),('Algeria','DZ','Constantine','CON'),('Algeria','DZ','Djelfa','DJE'),('Algeria','DZ','El Bayadh','ELB'),('Algeria','DZ','El Oued','ELO'),('Algeria','DZ','Ghardaia','GHA'),('Algeria','DZ','Guelma','GUE'),('Algeria','DZ','Illizi','ILL'),('Algeria','DZ','Jijel','JIJ'),('Algeria','DZ','Khenchela','KHE'),('Algeria','DZ','Laghouat','LAG'),('Algeria','DZ','M\'Sila','MSI'),('Algeria','DZ','Mascara','MAS'),('Algeria','DZ','Medea','MED'),('Algeria','DZ','Mila','MIL'),('Algeria','DZ','Mostaganem','MOS'),('Algeria','DZ','Naama','NAA'),('Algeria','DZ','Oran','ORA'),('Algeria','DZ','Ouargla','OUA'),('Algeria','DZ','Oum el Bouaghi','OUM'),('Algeria','DZ','Relizane','REL'),('Algeria','DZ','Saida','SAI'),('Algeria','DZ','Setif','SET'),('Algeria','DZ','Sidi Bel Abbes','SID'),('Algeria','DZ','Skikda','SKI'),('Algeria','DZ','Souk Ahras','SOU'),('Algeria','DZ','Tamanghasset','TAM'),('Algeria','DZ','Tebessa','TEB'),('Algeria','DZ','Tiaret','TIA'),('Algeria','DZ','Tindouf','TIN'),('Algeria','DZ','Tipaza','TIP'),('Algeria','DZ','Tissemsilt','TIS'),('Algeria','DZ','Tizi Ouzou','TIZ'),('Algeria','DZ','Tlemcen','TLE'),('Andorra','AD','Andorra','AND'),('Angola','AO','Benguela','BEN'),('Angola','AO','Huambo','HUA'),('Angola','AO','Luanda','LUA'),('Angola','AO','Lunda Sul','LUS'),('Anguilla','AI','Anguilla','ANG'),('Antarctica','AQ','Antarctica','ARC'),('Antigua and Barbuda','AG','Antigua & Barbuda','ANT'),('Argentina','AR','Buenos Aires','BA'),('Argentina','AR','Catamarca','CAT'),('Argentina','AR','Chaco','CHA'),('Argentina','AR','Chubut','CHU'),('Argentina','AR','Cordoba','CDB'),('Argentina','AR','Corrientes','COR'),('Argentina','AR','Distrito Federal','DF'),('Argentina','AR','Entre Rios','ERI'),('Argentina','AR','Formosa','FOR'),('Argentina','AR','Jujuy','JUJ'),('Argentina','AR','La Pampa','LPA'),('Argentina','AR','La Rioja','LRI'),('Argentina','AR','Mendoza','MEN'),('Argentina','AR','Misiones','MIS'),('Argentina','AR','Neuquen','NEU'),('Argentina','AR','Rio Negro','RNE'),('Argentina','AR','Salta','SAL'),('Argentina','AR','San Juan','SJU'),('Argentina','AR','San Luis','SLU'),('Argentina','AR','Santa Cruz','SCR'),('Argentina','AR','Santa Fe','SFE'),('Argentina','AR','Santiago del Estero','SDE'),('Argentina','AR','Tierra del Fuego','TDF'),('Argentina','AR','Tucuman','TUC'),('Armenia','AM','Aragatsotni','ARA'),('Armenia','AM','Ararati','ARR'),('Armenia','AM','Armaviri','ARM'),('Armenia','AM','Geghark\'unik\'i','GEG'),('Armenia','AM','K\'aghak\' Yerevan','KAY'),('Armenia','AM','Kalininskiy Rayon','KAL'),('Armenia','AM','Kotayk\'i','KOT'),('Armenia','AM','Lorru','KAL'),('Armenia','AM','Shiraki','SHI'),('Armenia','AM','Syunik\'i','SYU'),('Armenia','AM','Tavushi','TAV'),('Armenia','AM','Vayots\' Dzori','VAY'),('Aruba','AW','Aruba','ARU'),('Australia','AU','Australian Capital Territory','ACT'),('Australia','AU','New South Wales','NSW'),('Australia','AU','Northern Territory','NTY'),('Australia','AU','Queensland','QLD'),('Australia','AU','South Australia','SAU'),('Australia','AU','Tasmania','TAS'),('Australia','AU','Victoria','VIC'),('Australia','AU','Western Australia','WAU'),('Austria','AT','Burgenland','BUR'),('Austria','AT','Karnten','KAR'),('Austria','AT','Niederosterreich','NIE'),('Austria','AT','Oberosterreich','OBE'),('Austria','AT','Salzburg','SAL'),('Austria','AT','Steiermark','STE'),('Austria','AT','Tirol','TIR'),('Austria','AT','Vorarlberg','VOR'),('Austria','AT','Wien','WIE'),('Azerbaijan','AZ','Abseron','ABS'),('Azerbaijan','AZ','Agcabadi','AGC'),('Azerbaijan','AZ','Agdam','AGM'),('Azerbaijan','AZ','Agdas','AGD'),('Azerbaijan','AZ','Agstafa','AGS'),('Azerbaijan','AZ','Agsu','AGU'),('Azerbaijan','AZ','Ali Bayramli Sahari','ALI'),('Azerbaijan','AZ','Astara','AST'),('Azerbaijan','AZ','Baki Sahari','BAK'),('Azerbaijan','AZ','Balakan','BAL'),('Azerbaijan','AZ','Barda','BAR'),('Azerbaijan','AZ','Beylaqan','BEY'),('Azerbaijan','AZ','Bilasuvar','BIL'),('Azerbaijan','AZ','Cabrayil','CAB'),('Azerbaijan','AZ','Calilabad','CAL'),('Azerbaijan','AZ','Daskasan','DAS'),('Azerbaijan','AZ','Davaci','DAV'),('Azerbaijan','AZ','Fuzuli','FUZ'),('Azerbaijan','AZ','Gadabay','GAD'),('Azerbaijan','AZ','Ganca Sahari','GAN'),('Azerbaijan','AZ','Goranboy','GOR'),('Azerbaijan','AZ','Goycay','GOY'),('Azerbaijan','AZ','Haciqabul','HAC'),('Azerbaijan','AZ','Imisli','IMI'),('Azerbaijan','AZ','Ismayilli','ISM'),('Azerbaijan','AZ','Kalbacar','KAL'),('Azerbaijan','AZ','Kurdamir','KUR'),('Azerbaijan','AZ','Lacin','LAC'),('Azerbaijan','AZ','Lankaran','LAN'),('Azerbaijan','AZ','Lankaran Sahari','LAs'),('Azerbaijan','AZ','Lerik','LER'),('Azerbaijan','AZ','Masalli','MAS'),('Azerbaijan','AZ','Mingacevir Sahari','MIN'),('Azerbaijan','AZ','Naftalan Sahari','NAF'),('Azerbaijan','AZ','Naxcivan Muxtar Respublikasi','NAX'),('Azerbaijan','AZ','Neftcala','NEF'),('Azerbaijan','AZ','Oguz','OGU'),('Azerbaijan','AZ','Qabala','QAB'),('Azerbaijan','AZ','Qax','QAX'),('Azerbaijan','AZ','Qazax','QAZ'),('Azerbaijan','AZ','Qobustan','QOB'),('Azerbaijan','AZ','Quba','QUB'),('Azerbaijan','AZ','Qubadli','QUL'),('Azerbaijan','AZ','Qusar','QUS'),('Azerbaijan','AZ','Saatli','SAA'),('Azerbaijan','AZ','Sabirabad','SAB'),('Azerbaijan','AZ','Saki','SAK'),('Azerbaijan','AZ','Saki Sahari','SAS'),('Azerbaijan','AZ','Salyan','SAL'),('Azerbaijan','AZ','Samaxi','SAM'),('Azerbaijan','AZ','Samkir','SAR'),('Azerbaijan','AZ','Samux','SAX'),('Azerbaijan','AZ','Siyazan','SIY'),('Azerbaijan','AZ','Susa','SUR'),('Azerbaijan','AZ','Tartar','TAR'),('Azerbaijan','AZ','Tovuz','TOV'),('Azerbaijan','AZ','Ucar','UCA'),('Azerbaijan','AZ','Xacmaz','XAC'),('Azerbaijan','AZ','Xankandi Sahari','XAN'),('Azerbaijan','AZ','Xanlar','XAL'),('Azerbaijan','AZ','Xizi','XIZ'),('Azerbaijan','AZ','Xocali','XOC'),('Azerbaijan','AZ','Xocavand','XOV'),('Azerbaijan','AZ','Yardimli','YAR'),('Azerbaijan','AZ','Yevlax','YEV'),('Azerbaijan','AZ','Yevlax Sahari','YES'),('Azerbaijan','AZ','Zangilan','ZAN'),('Azerbaijan','AZ','Zaqatala','ZAQ'),('Azerbaijan','AZ','Zardab','ZAR'),('Bahamas','BS','Abaco','ABA'),('Bahamas','BS','Andros','AND'),('Bahamas','BS','Bimini Islands','BIM'),('Bahamas','BS','Cat Island','CAT'),('Bahamas','BS','Eleuthera','ELE'),('Bahamas','BS','Exuma & Cays','EXU'),('Bahamas','BS','Grand Bahama','GBA'),('Bahamas','BS','Harbour Island & Spanish Wells','HIS'),('Bahamas','BS','Inagua','INA'),('Bahamas','BS','Long Island','LIS'),('Bahamas','BS','Mayaguana','MAY'),('Bahamas','BS','New Providence','NPR'),('Bahamas','BS','Ragged Islands','RAG'),('Bahrain','BH','Al Hadd','HAD'),('Bahrain','BH','Al Manamah','MAN'),('Bahrain','BH','Al Mintaqah al Gharbiyah','GHA'),('Bahrain','BH','Al Mintaqah al Wusta','WUS'),('Bahrain','BH','Al Mintaqah ash Shamaliyah','SHA'),('Bahrain','BH','Al Muharraq','MUH'),('Bahrain','BH','Ar Rifa` wa al Mintaqah al Janubiyah','RIF'),('Bahrain','BH','Jidd Hafs','JID'),('Bahrain','BH','Madinat Hamad','MAH'),('Bahrain','BH','Madinat `Isa','MAI'),('Bahrain','BH','Mintaqat Juzur Hawar','JUZ'),('Bahrain','BH','Sitrah','SIT'),('Bangladesh','BD','Chittagong','CHI'),('Bangladesh','BD','Dhaka','DHA'),('Bangladesh','BD','Khulna','KHU'),('Bangladesh','BD','Rajshahi','RAJ'),('Barbados','BB','Christ Church','CHR'),('Barbados','BB','Saint Andrew','AND'),('Barbados','BB','Saint George','GEO'),('Barbados','BB','Saint James','JAM'),('Barbados','BB','Saint John','JOH'),('Barbados','BB','Saint Joseph','JOS'),('Barbados','BB','Saint Lucy','LUC'),('Barbados','BB','Saint Michael','MIC'),('Barbados','BB','Saint Peter','PET'),('Barbados','BB','Saint Philip','PHI'),('Barbados','BB','Saint Thomas','THO'),('Belarus','BY','Brestskaya','BRE'),('Belarus','BY','Homyel\'skaya','HOM'),('Belarus','BY','Hrodzyenskaya','HRO'),('Belarus','BY','Mahilyowskaya','MAH'),('Belarus','BY','Minskaya','MIN'),('Belarus','BY','Unknown','UNK'),('Belarus','BY','Vitsyebskaya','VIT'),('Belgium','BE','Antwerpen','ANT'),('Belgium','BE','Hainaut','HAI'),('Belgium','BE','Liege','LIE'),('Belgium','BE','Limburg','LIM'),('Belgium','BE','Luxembourg','LUX'),('Belgium','BE','Namur','NAM'),('Belgium','BE','Oost-Vlaanderen','OOV'),('Belgium','BE','Unknown','UNK'),('Belgium','BE','West-Vlaanderen','WEV'),('Belize','BZ','Belize','BEL'),('Belize','BZ','Cayo','CAY'),('Belize','BZ','Corozal','COR'),('Belize','BZ','Orange Walk','ORA'),('Belize','BZ','Stann Creek','STA'),('Belize','BZ','Toledo','TOL'),('Benin','BJ','Unknown','UNK'),('Bermuda','BM','Devonshire','DEV'),('Bermuda','BM','Hamilton','HAM'),('Bermuda','BM','Paget','PAG'),('Bermuda','BM','Pembroke','PEM'),('Bermuda','BM','Saint Georges','SGS'),('Bermuda','BM','Sandys','SAN'),('Bermuda','BM','Smiths','SMI'),('Bermuda','BM','Southampton','SOU'),('Bermuda','BM','Warwick','WAR'),('Bhutan','BT','Bhutan','BHU'),('Bolivia','BO','Beni','BEN'),('Bolivia','BO','Chuquisaca','CHU'),('Bolivia','BO','Cochabamba','COC'),('Bolivia','BO','La Paz','LAP'),('Bolivia','BO','Oruro','ORU'),('Bolivia','BO','Pando','PAN'),('Bolivia','BO','Potosi','POT'),('Bolivia','BO','Santa Cruz','SAN'),('Bolivia','BO','Tarija','TAR'),('Bosnia and Herzegovina','BA','Bosnia and Herzegovina','BOS'),('Bosnia and Herzegovina','BA','Republika Srpska','SRP'),('Bosnia and Herzegovina','BA','Unknown','UNK'),('Botswana','BW','Gaborone','GAB'),('Botswana','BW','Unknown','UNK'),('Brazil','BR','Acre','ACR'),('Brazil','BR','Alagoas','ALA'),('Brazil','BR','Amapa','AMP'),('Brazil','BR','Amazonas','AMZ'),('Brazil','BR','Bahia','BAH'),('Brazil','BR','Ceara','CEA'),('Brazil','BR','Distrito Federal','DF'),('Brazil','BR','Espirito Santo','ESA'),('Brazil','BR','Goias','GOI'),('Brazil','BR','Maranhao','MAR'),('Brazil','BR','Mato Grosso','MGR'),('Brazil','BR','Mato Grosso do Sul','MGS'),('Brazil','BR','Minas Gerais','MGE'),('Brazil','BR','Para','PAR'),('Brazil','BR','Paraiba','PRB'),('Brazil','BR','Parana','PRN'),('Brazil','BR','Pernambuco','PER'),('Brazil','BR','Piaui','PIA'),('Brazil','BR','Rio de Janeiro','RDJ'),('Brazil','BR','Rio Grande do Norte','RGN'),('Brazil','BR','Rio Grande do Sul','RGS'),('Brazil','BR','Rondonia','RON'),('Brazil','BR','Roraima','ROR'),('Brazil','BR','Santa Catarina','SCA'),('Brazil','BR','Sao Paulo','SPA'),('Brazil','BR','Sergipe','SER'),('Brazil','BR','Tocantins','TOC'),('British Virgin Islands','VG','British Virgin Islands','BVI'),('Brunei','BN','Brunei','BRU'),('Bulgaria','BG','Blagoevgrad','BLA'),('Bulgaria','BG','Burgas','BUR'),('Bulgaria','BG','Dobrich','DOB'),('Bulgaria','BG','Gabrovo','GAB'),('Bulgaria','BG','Khaskovo','KHA'),('Bulgaria','BG','Kurdzhali','KUR'),('Bulgaria','BG','Kyustendil','KYU'),('Bulgaria','BG','Lovech','LOV'),('Bulgaria','BG','Montana','MON'),('Bulgaria','BG','Pazardzhik','PAZ'),('Bulgaria','BG','Pernik','PER'),('Bulgaria','BG','Pleven','PLE'),('Bulgaria','BG','Plovdiv','PLO'),('Bulgaria','BG','Razgrad','RAZ'),('Bulgaria','BG','Ruse','RUS'),('Bulgaria','BG','Shumen','SHU'),('Bulgaria','BG','Silistra','SIL'),('Bulgaria','BG','Sliven','SLI'),('Bulgaria','BG','Smolyan','SMO'),('Bulgaria','BG','Sofiya','SOF'),('Bulgaria','BG','Sofiya-Grad','SFG'),('Bulgaria','BG','Stara Zagora','STA'),('Bulgaria','BG','Turgovishte','TUR'),('Bulgaria','BG','Varna','VAR'),('Bulgaria','BG','Veliko Turnovo','VEL'),('Bulgaria','BG','Vidin','VID'),('Bulgaria','BG','Vratsa','VRA'),('Bulgaria','BG','Yambol','YAM'),('Burkina Faso','BF','Burkina Faso','BUF'),('Burundi','BN','Burundi','BUR'),('Cambodia','KH','Batdambang','BAT'),('Cambodia','KH','Kampong Cham','CHA'),('Cambodia','KH','Kampong Chhnang','CHH'),('Cambodia','KH','Kampong Spoe','SPO'),('Cambodia','KH','Kampong Thum','THU'),('Cambodia','KH','Kampot','KAM'),('Cambodia','KH','Kandal','KAN'),('Cambodia','KH','Kaoh Kong','KAO'),('Cambodia','KH','Kracheh','KRA'),('Cambodia','KH','Mondol Kiri','MON'),('Cambodia','KH','Pouthisat','POU'),('Cambodia','KH','Preah Vihear','PRE'),('Cambodia','KH','Prey Veng','PRV'),('Cambodia','KH','Rotanah Kiri','ROT'),('Cambodia','KH','Siem Reab','SIE'),('Cambodia','KH','Stoeng Treng','STO'),('Cambodia','KH','Svay Rieng','SVA'),('Cambodia','KH','Takev','TAK'),('Cambodia','KH','Unknown','UNK'),('Cameroon','CM','Cameroon','CAM'),('Canada','CA','Alberta','AB'),('Canada','CA','British Columbia','BC'),('Canada','CA','Manitoba','MB'),('Canada','CA','New Brunswick','NB'),('Canada','CA','Newfoundland and Labrador','NF'),('Canada','CA','Northwest Territories','NT'),('Canada','CA','Nova Scotia','NS'),('Canada','CA','Nunavut','NU'),('Canada','CA','Ontario','ON'),('Canada','CA','Prince Edward Island','PE'),('Canada','CA','Quebec','QC'),('Canada','CA','Saskatchewan','SK'),('Canada','CA','Yukon','YT'),('Cape Verde','CV','Cape Verde','CPV'),('Cayman Islands','KY','Cayman Islands','CYN'),('Central African Republic','CF','Central African Republic','CAR'),('Chad','TD','Batha','BAT'),('Chad','TD','Biltine','BIL'),('Chad','TD','Borkou-Ennedi-Tibesti','BET'),('Chad','TD','Chari-Baguirmi','CHB'),('Chad','TD','Guera','GUE'),('Chad','TD','Kanem','KAN'),('Chad','TD','Lac','LAC'),('Chad','TD','Logone Occidental','LOC'),('Chad','TD','Logone Oriental','LOR'),('Chad','TD','Mayo-Kebbi','MAK'),('Chad','TD','Moyen-Chari','MOC'),('Chad','TD','Ouaddai','OUA'),('Chad','TD','Salamat','SAL'),('Chad','TD','Tandjile','TAN'),('Chile','CL','Aisen del General Carlos Ibanez del Campo','AIS'),('Chile','CL','Antofagasta','ANT'),('Chile','CL','Araucania','ARA'),('Chile','CL','Atacama','ATA'),('Chile','CL','Bio-Bio','BIO'),('Chile','CL','Coquimbo','COQ'),('Chile','CL','Libertador G.B. O\'Higgins','LIB'),('Chile','CL','Los Lagos','LAG'),('Chile','CL','Magallanes y de la Antartica Chilena','MAG'),('Chile','CL','Maule','MAU'),('Chile','CL','Region Metropolitana','MET'),('Chile','CL','Tarapaca','TAR'),('Chile','CL','Valparaiso','VAL'),('China','CN','Anhui','ANH'),('China','CN','Beijing Shi','BEJ'),('China','CN','Chongqing Shi','CHS'),('China','CN','Fujian','FUJ'),('China','CN','Gansu','GAN'),('China','CN','Guangdong','GUA'),('China','CN','Guangxi Zhuangzu','GUZ'),('China','CN','Guizhou','GUI'),('China','CN','Hainan','HAI'),('China','CN','Hebei','HEB'),('China','CN','Heilongjiang','HEI'),('China','CN','Henan','HEN'),('China','CN','Hubei','HUB'),('China','CN','Hunan','HUN'),('China','CN','Inner Mongolia','IMO'),('China','CN','Jiangsu','JIU'),('China','CN','Jiangxi','JII'),('China','CN','Jilin','JIN'),('China','CN','Liaoning','LIA'),('China','CN','Ningxia Huizu','NIH'),('China','CN','Qinghai','QIN'),('China','CN','Shaanxi','SHX'),('China','CN','Shandong','SHG'),('China','CN','Shanxi','SHI'),('China','CN','Sichuan','SIC'),('China','CN','Tibet','TIB'),('China','CN','Unknown','UNK'),('China','CN','Xinjiang Uygur','XIU'),('China','CN','Yunnan','YUN'),('China','CN','Zhejiang','ZHE'),('Christmas Island','CX','Christmas Island','CHI'),('Columbia','CO','Antioquia','ANT'),('Columbia','CO','Atlantico','ALT'),('Columbia','CO','Bogota','BOG'),('Columbia','CO','Bolivar','BOL'),('Columbia','CO','Cauca','CAU'),('Columbia','CO','Cundinamarca','CUN'),('Columbia','CO','Magdalena','MAG'),('Columbia','CO','Meta','MET'),('Columbia','CO','Santander','SAN'),('Columbia','CO','Valle del Cauca','VAL'),('Comoros','KM','Comoros','COM'),('Congo','CG','Bouenza','BOU'),('Congo','CG','Brazzaville','BRA'),('Congo','CG','Cuvette','CUV'),('Congo','CG','Kouilou','KOU'),('Congo','CG','Lekoumou','LEK'),('Congo','CG','Likouala','LIK'),('Congo','CG','Niari','NIA'),('Congo','CG','Plateaux','PLA'),('Congo','CG','Pool','POO'),('Congo','CG','Sangha','SAN'),('Cook Islands','CW','Cook Islands','CKI'),('Costa Rica','CR','Alajuela','ALA'),('Costa Rica','CR','Cartago','CAR'),('Costa Rica','CR','Guanacaste','GUA'),('Costa Rica','CR','Heredia','HER'),('Costa Rica','CR','Limon','LIM'),('Costa Rica','CR','Puntarenas','PUN'),('Costa Rica','CR','San Jose','SJO'),('Cote D\'Ivoire','CI','Cote D\'Ivoire','CDI'),('Croatia','HR','Bjelovarsko-Bilogorska','BJE'),('Croatia','HR','Brodsko-Posavska','BRO'),('Croatia','HR','Dubrovacko-Neretvanska','DUB'),('Croatia','HR','Grad Zagreb','GRA'),('Croatia','HR','Istarska','IST'),('Croatia','HR','Karlovacka','KAR'),('Croatia','HR','Koprivnicko-Krizevacka','KOP'),('Croatia','HR','Krapinsko-Zagorska','KRA'),('Croatia','HR','Licko-Senjska','LIC'),('Croatia','HR','Medimurska','MED'),('Croatia','HR','Osjecko-Baranjska','OSJ'),('Croatia','HR','Pozesko-Slavonska','POZ'),('Croatia','HR','Primorsko-Goranska','PRI'),('Croatia','HR','Sibensko-Kninska','SIB'),('Croatia','HR','Sisacko-Moslavacka','SIS'),('Croatia','HR','Splitsko-Dalmatinska','SPL'),('Croatia','HR','Varazdinska','VAR'),('Croatia','HR','Viroviticko-Podravska','VIR'),('Croatia','HR','Vukovarsko-Srijemska','VUK'),('Croatia','HR','Zagrebacka','ZAG'),('Cuba','CU','Camaguey','CAM'),('Cuba','CU','Ciego de Avila','CDA'),('Cuba','CU','Cienfuegos','CIE'),('Cuba','CU','Ciudad de la Habana','CLH'),('Cuba','CU','Granma','GRA'),('Cuba','CU','Guantanamo','GUA'),('Cuba','CU','Holguin','HOL'),('Cuba','CU','Isla de la Juventud','JUV'),('Cuba','CU','La Habana','HAB'),('Cuba','CU','Las Tunas','TUN'),('Cuba','CU','Matanzas','MAT'),('Cuba','CU','Pinar del Rio','PIN'),('Cuba','CU','Sancti Spiritus','SSP'),('Cuba','CU','Santiago de Cuba','SAN'),('Cuba','CU','Villa Clara','VIL'),('Cyprus','CY','Cyprus','CYP'),('Czech Republic','CZ','Czech Republic','CZE'),('Democratic Repubilic of Congo','CD','Bandundu','BAN'),('Democratic Repubilic of Congo','CD','Bas-Congo','BAS'),('Democratic Repubilic of Congo','CD','Equateur','EQU'),('Democratic Repubilic of Congo','CD','Kasai-Occidental','KOC'),('Democratic Repubilic of Congo','CD','Katanga','KAT'),('Democratic Repubilic of Congo','CD','Kinshasa','KIN'),('Democratic Repubilic of Congo','CD','Kivu','KIV'),('Democratic Repubilic of Congo','CD','Maniema','MAN'),('Democratic Repubilic of Congo','CD','Nord-Kivu','NKI'),('Democratic Repubilic of Congo','CD','Orientale','ORI'),('Democratic Repubilic of Congo','CD','Sud-Kivu','SKI'),('Denmark','DK','Arhus Amt','ARH'),('Denmark','DK','Bornholms Amt','BOR'),('Denmark','DK','Frederiksberg Kommune','FK'),('Denmark','DK','Frederiksborg Amt','FRE'),('Denmark','DK','Fyns Amt','FYN'),('Denmark','DK','Kobenhavns Amt','KOB'),('Denmark','DK','Kobenhavns Kommune','KK'),('Denmark','DK','Nordjyllands Amt','NJL'),('Denmark','DK','Ribe Amt','RIB'),('Denmark','DK','Ringkobing Amt','RIN'),('Denmark','DK','Roskilde Amt','ROS'),('Denmark','DK','Sonderjyllands Amt','SJL'),('Denmark','DK','Storstroms Amt','STO'),('Denmark','DK','Vejle Amt','VEJ'),('Denmark','DK','Vestsjaellands Amt','VSL'),('Denmark','DK','Viborg Amt','VIB'),('Djibouti','DJ','Djibouti','DJI'),('Dominica','DM','Dominica','DOM'),('Dominican Republic','DO','Azua','AZU'),('Dominican Republic','DO','Baoruco','BAH'),('Dominican Republic','DO','Barahona','BAR'),('Dominican Republic','DO','Dajabon','DAJ'),('Dominican Republic','DO','Distrito Nacional','DN'),('Dominican Republic','DO','Duarte','DUA'),('Dominican Republic','DO','El Seibo','ESE'),('Dominican Republic','DO','Elias Pina','EPA'),('Dominican Republic','DO','Espaillat','ESP'),('Dominican Republic','DO','Hato Mayor','HMA'),('Dominican Republic','DO','Independencia','IND'),('Dominican Republic','DO','La Altagracia','LAL'),('Dominican Republic','DO','La Romana','LRO'),('Dominican Republic','DO','La Vega','LVE'),('Dominican Republic','DO','Maria Trinidad Sanchez','MTS'),('Dominican Republic','DO','Monsenor Nouel','MSN'),('Dominican Republic','DO','Monte Cristi','MCR'),('Dominican Republic','DO','Monte Plata','MPL'),('Dominican Republic','DO','Pedernales','PED'),('Dominican Republic','DO','Peravia','PER'),('Dominican Republic','DO','Puerto Plata','PPL'),('Dominican Republic','DO','Salcedo','SAL'),('Dominican Republic','DO','Samana','SAM'),('Dominican Republic','DO','San Cristobal','SCR'),('Dominican Republic','DO','San Juan','SJU'),('Dominican Republic','DO','San Pedro de Macoris','SPM'),('Dominican Republic','DO','Sanchez Ramirez','SRA'),('Dominican Republic','DO','Santiago','SAN'),('Dominican Republic','DO','Santiago Rodriguez','SRO'),('Dominican Republic','DO','Valverde','VAL'),('East Timor','TL','East Timor','ETM'),('Ecuador','EC','Azuay','AZU'),('Ecuador','EC','Boliar','BOL'),('Ecuador','EC','Canar','CAN'),('Ecuador','EC','Carchi','CAR'),('Ecuador','EC','Chimborazo','CHI'),('Ecuador','EC','Cotopaxi','COT'),('Ecuador','EC','El Oro','EOR'),('Ecuador','EC','Esmeraldas','ESM'),('Ecuador','EC','Galapagos','GAL'),('Ecuador','EC','Guayas','GUA'),('Ecuador','EC','Imbabura','IMB'),('Ecuador','EC','Loja','LOJ'),('Ecuador','EC','Los Rios','LRI'),('Ecuador','EC','Manabi','MAN'),('Ecuador','EC','Morona-Santiago','MSA'),('Ecuador','EC','Napo','NAP'),('Ecuador','EC','Orellana','ORE'),('Ecuador','EC','Pastaza','PAS'),('Ecuador','EC','Pichincha','PIC'),('Ecuador','EC','Sucumbios','SUC'),('Ecuador','EC','Zamora-Chinchipe','ZCH'),('Egypt','EG','Ad-Daqahiyah','DAQ'),('Egypt','EG','Al-Bahr al-Ahmar','BAH'),('Egypt','EG','Al-Buhayrah','BUH'),('Egypt','EG','Al-Fayyum','FAY'),('Egypt','EG','Al-Gharbiyah','GHA'),('Egypt','EG','Al-Iskandariyah','ISK'),('Egypt','EG','Al-Isma\'iliyah','ISM'),('Egypt','EG','Al-Jizah','JIZ'),('Egypt','EG','Al-Minufiyah','MNF'),('Egypt','EG','Al-Minya','MIN'),('Egypt','EG','Al-Qahirah','QAH'),('Egypt','EG','Al-Qalyubyah','QAL'),('Egypt','EG','Al-Wadi al-Jadid','WJA'),('Egypt','EG','As-Suways','SUW'),('Egypt','EG','Ash-Sharqiyah','SHA'),('Egypt','EG','Aswan','ASW'),('Egypt','EG','Asyut','ASY'),('Egypt','EG','Bani Suwayf','BSU'),('Egypt','EG','Bur Sa\'id','BSA'),('Egypt','EG','Dumyat','DUM'),('Egypt','EG','Kafr ash-Shaykh','KSH'),('Egypt','EG','Marsa Matruh','MMA'),('Egypt','EG','Qina','QIN'),('Egypt','EG','Sawhaj','SAW'),('Egypt','EG','Sina\' al-Janubiyah','SJA'),('Egypt','EG','Sina\' ash-Shamaliyah','SSH'),('El Salvador','SV','Ahuachapan','AHU'),('El Salvador','SV','Cabanas','CAB'),('El Salvador','SV','Chalatenango','CHA'),('El Salvador','SV','Cuscatlan','CUS'),('El Salvador','SV','La Libertad','LLI'),('El Salvador','SV','La Paz','LPA'),('El Salvador','SV','La Union','LUN'),('El Salvador','SV','Morazan','MOR'),('El Salvador','SV','San Miguel','SMI'),('El Salvador','SV','San Salvador','SSA'),('El Salvador','SV','San Vicente','SVI'),('El Salvador','SV','Santa Ana','SAN'),('El Salvador','SV','Sonsonate','SON'),('El Salvador','SV','Usulutan','USU'),('Equatorial Guinea','GQ','Equatorial Guinea','EQG'),('Eritrea','ER','Eritrea','ERI'),('Estonia','EE','Estonia','EST'),('Ethiopia','ET','Ethiopia','ETH'),('Falkland Islands','FK','Falkland Islands','FAL'),('Faroe Islands','FO','Faroe Islands','FAR'),('Fiji','FJ','Fiji','FIJ'),('Finland','FI','Alands Lan','ALA'),('Finland','FI','Lapplands Lan','LPA'),('Finland','FI','Ostra Finlands Lan','OST'),('Finland','FI','Sodra Finlands Lan','SOD'),('Finland','FI','Uleaborgs Lan','ULE'),('Finland','FI','Vastra Finlands Lan','VAS'),('France','FR','Alsace','ALS'),('France','FR','Aquitaine','AQU'),('France','FR','Auvergne','AUV'),('France','FR','Basse-Normandie','BAS'),('France','FR','Bourgogne','BOU'),('France','FR','Bretagne','BRE'),('France','FR','Centre','CEN'),('France','FR','Champagne-Ardenne','CHA'),('France','FR','Corse','COR'),('France','FR','Franche-Comte','FRA'),('France','FR','Haute-Normandie','HAU'),('France','FR','Ile-de-France','ILE'),('France','FR','Languedoc-Roussillon','LAN'),('France','FR','Limousin','LIM'),('France','FR','Lorraine','LOR'),('France','FR','Midi-Pyrenees','MID'),('France','FR','Nord-Pas-de-Calais','NOR'),('France','FR','Pays-de-la Loire','PAY'),('France','FR','Picardie','PIC'),('France','FR','Poitou-Charentes','POI'),('France','FR','Provence-Alpes-Cote d\'Azur','PRO'),('France','FR','Rhooe-Alpes','RHO'),('France','FR','Unknown','UNK'),('French Guiana','GF','French Guiana','FGU'),('French Polynesia','FP','French Polynesia','FPY'),('Gabon','GA','Gabon','GAB'),('Gambia','GM','Gambia','GAM'),('Georgia','GE','Georgia','GEO'),('Germany','DE','Baden-Wurttemberg','BW'),('Germany','DE','Bayern','BY'),('Germany','DE','Berlin','BE'),('Germany','DE','Brandenburg','BB'),('Germany','DE','Bremen','HB'),('Germany','DE','Hamburg','HH'),('Germany','DE','Hessen','HE'),('Germany','DE','Mecklenburg-Vorpommern','MV'),('Germany','DE','Niedersachsen','NI'),('Germany','DE','Nordrhein-Westfalen','NW'),('Germany','DE','Rheinland-Pfalz','RP'),('Germany','DE','Saarland','SL'),('Germany','DE','Sachsen','SN'),('Germany','DE','Sachsen-Anhalt','ST'),('Germany','DE','Schleswig-Holstein','SH'),('Germany','DE','Thuringen','TH'),('Ghana','GH','Kumasi','KUI'),('Ghana','GH','Sunyani','SUI'),('Ghana','GH','Cape Coast','CAT'),('Ghana','GH','Koforidua','KOA'),('Ghana','GH','Accra','ACA'),('Ghana','GH','Tamale','TAE'),('Ghana','GH','Bolgatanga','BOA'),('Ghana','GH','Wa','Wa'),('Ghana','GH','Ho','Ho'),('Ghana','GH','Sekondi-Takoradi','STI'),('Gibraltar','GI','Gibraltar','GIB'),('Greece','GR','Aegean Islands','AIY'),('Greece','GR','Attiki','ATT'),('Greece','GR','Central Greece & Evvoia','SEE'),('Greece','GR','Crete','KRI'),('Greece','GR','Epirus','IPI'),('Greece','GR','Ionia Islands','ION'),('Greece','GR','Macedonia','MAK'),('Greece','GR','Peloponnesus','PEL'),('Greece','GR','Thessalia','THE'),('Greece','GR','Thrace','THR'),('Greenland','GL','Greenland','GL'),('Grenada','GD','Grenada','GJ'),('Guadeloupe','GP','Guadeloupe','GUA'),('Guatemala','GT','Alta Verapaz','AVE'),('Guatemala','GT','Baja Verapaz','BVE'),('Guatemala','GT','Chimaltenango','CMT'),('Guatemala','GT','Chiquimula','CQM'),('Guatemala','GT','El Progreso','EPR'),('Guatemala','GT','Escuintla','ESC'),('Guatemala','GT','Guatemala','GUA'),('Guatemala','GT','Huehuetenango','HUE'),('Guatemala','GT','Izabal','IZA'),('Guatemala','GT','Jalapa','JAL'),('Guatemala','GT','Jutiapa','JUT'),('Guatemala','GT','Peten','PET'),('Guatemala','GT','Quetzaltenango','QUE'),('Guatemala','GT','Quiche','QUI'),('Guatemala','GT','Retalhuleu','RET'),('Guatemala','GT','Sacatepequez','SAC'),('Guatemala','GT','San Marcos','SMA'),('Guatemala','GT','Santa Rosa','SRO'),('Guatemala','GT','Solola','SOL'),('Guatemala','GT','Suchitepequez','SUC'),('Guatemala','GT','Totonicapan','TOT'),('Guatemala','GT','Zacapa','ZAC'),('Guernsey','GG','Guernsey','GUR'),('Guinea','GN','Guinea','GUI'),('Guinea-Bissau','GW','Guinea-Bissau','GUB'),('Guyana','GY','Guyana','GUY'),('Haiti','HT','Haiti','HAI'),('Honduras','HN','Atlantida','ATL'),('Honduras','HN','Choluteca','CHO'),('Honduras','HN','Colon','COL'),('Honduras','HN','Comayagua','COM'),('Honduras','HN','Copan','COP'),('Honduras','HN','El Paraiso','EPA'),('Honduras','HN','Francisco Morazan','FMO'),('Honduras','HN','Gracias a Dios','GAD'),('Honduras','HN','Intibuca','INT'),('Honduras','HN','Islas de la Bahia','IBA'),('Honduras','HN','La Paz','LPA'),('Honduras','HN','Lempira','LEM'),('Honduras','HN','Ocotepeque','OCO'),('Honduras','HN','Olancho','OLA'),('Honduras','HN','Santa Barbara','SBA'),('Honduras','HN','Valle','VAL'),('Honduras','HN','Yoro','YOR'),('Hungary','HU','Bacs-Kiskun Megye','BAC'),('Hungary','HU','Baranya Megye','BAR'),('Hungary','HU','Bekes Megye','BEK'),('Hungary','HU','Borsod-Abauj-Zemplen Megye','BOR'),('Hungary','HU','Budapest Fovaros','BUD'),('Hungary','HU','Csongrad Megye','CSO'),('Hungary','HU','Debrecen Megyei Varos','DEB'),('Hungary','HU','Fejer Megye','FEJ'),('Hungary','HU','Gyor Megyei Varos','GYO'),('Hungary','HU','Gyor-Moson-Sopron Megye','GYO'),('Hungary','HU','Hajdu-Bihar Megye','HAJ'),('Hungary','HU','Heves Megye','HEV'),('Hungary','HU','Jasz-Nagykun-Szolnok Megye','JAS'),('Hungary','HU','Komarom-Esztergom Megye','KOM'),('Hungary','HU','Miskolc Megyei Varos','MIS'),('Hungary','HU','Nograd Megye','NOG'),('Hungary','HU','Pecs Megyei Varos','PEC'),('Hungary','HU','Pest Megye','PES'),('Hungary','HU','Somogy Megye','SOM'),('Hungary','HU','Szabolcs-Szatmar-Bereg Megye','SZA'),('Hungary','HU','Szeged Megyei Varos','SZE'),('Hungary','HU','Tolna Megye','TOL'),('Hungary','HU','Vas Megye','VAS'),('Hungary','HU','Veszprem Megye','VES'),('Hungary','HU','Zala Megye','ZAL'),('Iceland','IS','Arnessysla','ARN'),('Iceland','IS','Austur-Bardhastrandarsysla','ABA'),('Iceland','IS','Austur-Hunavatnssysla','AHU'),('Iceland','IS','Austur-Skaftafellssysla','ASK'),('Iceland','IS','Borgarfjardharsysla','BOR'),('Iceland','IS','Dalasysla','DAL'),('Iceland','IS','Eyjafjardharsysla','EYJ'),('Iceland','IS','Gullbringusysla','GUL'),('Iceland','IS','Kjosarsysla','KJY'),('Iceland','IS','Myrasysla','MYR'),('Iceland','IS','Nordhur-Isafjardharsysla','NIS'),('Iceland','IS','Nordhur-Mulasysla','NMU'),('Iceland','IS','Nordhur-Thingeyjarsysla','NTY'),('Iceland','IS','Rangarvallasysla','RNG'),('Iceland','IS','Skagafjardharsysla','SKA'),('Iceland','IS','Snaefellsnessysla- og Hnappadalssysla','SHN'),('Iceland','IS','Strandasysla','STR'),('Iceland','IS','Sudhur-Mulasysla','SMU'),('Iceland','IS','Sudhur-Thingeijjar','STI'),('Iceland','IS','Vestur-Bardhastrandarsysla','VBA'),('Iceland','IS','Vestur-Hunavatnssysla','VHU'),('Iceland','IS','Vestur-Isafjardharsysla','VIS'),('Iceland','IS','Vestur-Skaftafellssysla','VSK'),('India','IN','Andaman & Nicobar Islands','ANI'),('India','IN','Andhra Pradesh','AND'),('India','IN','Arunachal Pradesh','ARU'),('India','IN','Assam','ASS'),('India','IN','Bihar','BIH'),('India','IN','Chandigarh','CHA'),('India','IN','Dadra & Nagar Haveli','DAD'),('India','IN','Delhi','DEL'),('India','IN','Goa','GOA'),('India','IN','Gujarat','GUJ'),('India','IN','Haryana','HAR'),('India','IN','Himachal Pradesh','HIM'),('India','IN','Jammu & Kashmir','JAM'),('India','IN','Jharkhand','JHA'),('India','IN','Karnataka','KAR'),('India','IN','Kerala','KER'),('India','IN','Lakshadweep','LAK'),('India','IN','Madhya Pradesh','MAD'),('India','IN','Maharashtra','MAH'),('India','IN','Manipur','MAN'),('India','IN','Meghalaya','MEG'),('India','IN','Mizoram','MIZ'),('India','IN','Nagaland','NAG'),('India','IN','Orissa','ORI'),('India','IN','Pondicherry','PON'),('India','IN','Punjab','PUN'),('India','IN','Rajasthan','RAJ'),('India','IN','Sikkim','SIK'),('India','IN','Tamil Nadu','TAM'),('India','IN','Tripura','TRI'),('India','IN','Uttar Pradesh','UTT'),('India','IN','Uttaranchal','UAR'),('India','IN','West Bengal','WES'),('Indonesia','ID','Aceh','ACE'),('Indonesia','ID','Bali','BAL'),('Indonesia','ID','Bengkulu','BEN'),('Indonesia','ID','Jambi','JAM'),('Indonesia','ID','Jawa Barat','JBA'),('Indonesia','ID','Jawa Tengah','JTE'),('Indonesia','ID','Jawa Timur','JTI'),('Indonesia','ID','Kalimantan Barat','BAR'),('Indonesia','ID','Kalimantan Selatan','SEL'),('Indonesia','ID','Kalimantan Tengah','TEN'),('Indonesia','ID','Kalimantan Timur','TIM'),('Indonesia','ID','Lampung','LAM'),('Indonesia','ID','Maluku','MAL'),('Indonesia','ID','Nusa Tenggara Barat','NTB'),('Indonesia','ID','Nusa Tenggara Timur','NTT'),('Indonesia','ID','Papua','PAP'),('Indonesia','ID','Riau','RIA'),('Indonesia','ID','Sulawesi Selatan','SSE'),('Indonesia','ID','Sulawesi Tengah','STE'),('Indonesia','ID','Sulawesi Tenggara','STG'),('Indonesia','ID','Sulawesi Utara','SLU'),('Indonesia','ID','Sumatera Barat','SBA'),('Indonesia','ID','Sumatera Utara','SUT'),('Indonesia','ID','Unknown','UNK'),('Indonesia','ID','Yogyakarta','YOG'),('Iran','IR','a Baluchestan','BAL'),('Iran','IR','ahall va Bakhtiari','BAK'),('Iran','IR','an-e Gharbi','GHA'),('Iran','IR','an-e Sharqi','SHA'),('Iran','IR','eh va Buyer Ahmad','KOH'),('Iran','IR','n','KOR'),('Iran','IR','n','KHU'),('Iran','IR','n','HOR'),('Iraq','IQ','Anbar','ANB'),('Iraq','IQ','Arbil','ARB'),('Iraq','IQ','Babil','BAB'),('Iraq','IQ','Baghdad','BAG'),('Iraq','IQ','Basrah','BAS'),('Iraq','IQ','Dahuk','DAH'),('Iraq','IQ','Dhi Qar','DHI'),('Iraq','IQ','Diyala','DIY'),('Iraq','IQ','Karbala\'','KAR'),('Iraq','IQ','Maysan','MAY'),('Iraq','IQ','Muthanna','MUT'),('Iraq','IQ','Najaf','NAJ'),('Iraq','IQ','Ninawa','NIN'),('Iraq','IQ','Qadisiyah','QAD'),('Iraq','IQ','Salah ad Din','SAL'),('Iraq','IQ','Sulaymaniyah','SUL'),('Iraq','IQ','Ta\'mim','TAM'),('Iraq','IQ','Wasit','WAS'),('Ireland','IE','Carlow','CAR'),('Ireland','IE','Cavan','CAV'),('Ireland','IE','Clare','CLA'),('Ireland','IE','Cork','COR'),('Ireland','IE','Donegal','DON'),('Ireland','IE','Dublin','DUB'),('Ireland','IE','Galway','GAL'),('Ireland','IE','Kerry','KRY'),('Ireland','IE','Kildare','KID'),('Ireland','IE','Kilkenny','KIK'),('Ireland','IE','Laois','LAO'),('Ireland','IE','Leitrim','LEI'),('Ireland','IE','Limerick','LIM'),('Ireland','IE','Longford','LON'),('Ireland','IE','Louth','LOU'),('Ireland','IE','Mayo','MAY'),('Ireland','IE','Meath','MEA'),('Ireland','IE','Monaghan','MON'),('Ireland','IE','Offaly','OFF'),('Ireland','IE','Roscommon','ROS'),('Ireland','IE','Sligo','SLI'),('Ireland','IE','Tipperary','TIP'),('Ireland','IE','Unknown','UNK'),('Ireland','IE','Waterford','WAT'),('Ireland','IE','Westmeath','WES'),('Ireland','IE','Wexford','WEX'),('Ireland','IE','Wicklow','WIC'),('Isle of Man','IM','Isle of Man','IOM'),('Israel','IL','Central District','CEN'),('Israel','IL','Haifa District','HAF'),('Israel','IL','Jerusalem District','JER'),('Israel','IL','Northern District','HAF'),('Israel','IL','Southern District','MEH'),('Israel','IL','Tel Aviv District','TEL'),('Italy','IT','Abruzzi','ABR'),('Italy','IT','Basilicata','BAS'),('Italy','IT','Calabria','CAL'),('Italy','IT','Campania','CAM'),('Italy','IT','Emilia-Romagna','EMI'),('Italy','IT','Friuli-Venezia Giulia','FRI'),('Italy','IT','Lazio','LAZ'),('Italy','IT','Liguria','LIG'),('Italy','IT','Lombardia','LOM'),('Italy','IT','Marche','MAR'),('Italy','IT','Molise','MOL'),('Italy','IT','Piemonte','PIE'),('Italy','IT','Puglia','PUG'),('Italy','IT','Sardegna','SAR'),('Italy','IT','Sicilia','SIC'),('Italy','IT','Toscana','TOS'),('Italy','IT','Trentino-Alto Adige','TRE'),('Italy','IT','Umbria','UMB'),('Italy','IT','Valle d\'Aosta','VDA'),('Italy','IT','Veneto','VEN'),('Jamaica','JM','Clarendon','CLA'),('Jamaica','JM','Hanover','HAN'),('Jamaica','JM','Kingston','KIN'),('Jamaica','JM','Manchester','MAN'),('Jamaica','JM','Portland','POR'),('Jamaica','JM','Saint Andrews','AND'),('Jamaica','JM','Saint Ann','ANN'),('Jamaica','JM','Saint Catherine','CAT'),('Jamaica','JM','Saint Elizabeth','ELI'),('Jamaica','JM','Saint James','JAM'),('Jamaica','JM','Saint Mary','MAR'),('Jamaica','JM','Saint Thomas','THO'),('Jamaica','JM','Trelawny','TRE'),('Jamaica','JM','Westmoreland','WML'),('Japan','JP','Aichi','AIC'),('Japan','JP','Akita','AKI'),('Japan','JP','Aomori','AOM'),('Japan','JP','Chiba','CHI'),('Japan','JP','Ehime','EHI'),('Japan','JP','Fukui','FUI'),('Japan','JP','Fukuoka','FUA'),('Japan','JP','Fukushima','FUM'),('Japan','JP','Gifu','GIF'),('Japan','JP','Gumma','GUM'),('Japan','JP','Hiroshima','HIR'),('Japan','JP','Hokkaido','HOK'),('Japan','JP','Hyogo','HYO'),('Japan','JP','Ibaraki','IBA'),('Japan','JP','Ishikawa','ISH'),('Japan','JP','Iwate','IWA'),('Japan','JP','Kagawa','KAG'),('Japan','JP','Kagoshima','KAM'),('Japan','JP','Kanagawa','KAN'),('Japan','JP','Kochi','KOC'),('Japan','JP','Kumamoto','KUM'),('Japan','JP','Kyoto','KYO'),('Japan','JP','Mie','MIE'),('Japan','JP','Miyagi','MIG'),('Japan','JP','Miyazaki','MIZ'),('Japan','JP','Nagano','NAG'),('Japan','JP','Nagasaki','NAK'),('Japan','JP','Nara','NAR'),('Japan','JP','Niigata','NII'),('Japan','JP','Oita','OIT'),('Japan','JP','Okayama','OKA'),('Japan','JP','Okinawa','OKI'),('Japan','JP','Osaka','OSA'),('Japan','JP','Saga','SAG'),('Japan','JP','Saitama','SAI'),('Japan','JP','Shiga','SHG'),('Japan','JP','Shimane','SHM'),('Japan','JP','Shizuoka','SHZ'),('Japan','JP','Tochigi','TOC'),('Japan','JP','Tokushima','TOK'),('Japan','JP','Tokyo','TOY'),('Japan','JP','Tottori','TOT'),('Japan','JP','Toyama','TYM'),('Japan','JP','Wakayama','WAK'),('Japan','JP','Yamagata','YMT'),('Japan','JP','Yamaguchi','YMG'),('Japan','JP','Yamanashi','YMN'),('Jersey','JE','Jersey','JER'),('Jordan','JO','Jordan','JOR'),('Kazakhstan','KZ','Kazakhstan','KAZ'),('Kenya','KE','Central','CEN'),('Kenya','KE','Coast','CST'),('Kenya','KE','Eastern','EST'),('Kenya','KE','Nairobi','NAI'),('Kenya','KE','North Eastern','NEA'),('Kenya','KE','Nyanza','NYA'),('Kenya','KE','Rift Valley','RVY'),('Kenya','KE','Western','WST'),('Kiribati','KI','Kiribati','KIR'),('Kuwait','KW','Al-Ahmadi','AHM'),('Kuwait','KW','Al-Farwaniyah','FAR'),('Kuwait','KW','Al-Kuwayt','KUW'),('Kuwait','KW','Bubiyan & Warbah','BUB'),('Kuwait','KW','Hawalli','HAW'),('Kyrgyzstan','KG','Kyrgyzstan','KYR'),('Laos','LA','Laos','LAO'),('Latvia','LV','Latvia','LAT'),('Lebanon','LB','Lebanon','LEB'),('Lesotho','LS','Lesotho','LES'),('Liberia','LR','Liberia','LIB'),('Libya','LY','Libya','LIB'),('Liechtenstein','LI','Liechtenstein','LIE'),('Lithuania','LT','Lithuania','LIT'),('Luxembourg','LU','Luxembourg','LUX'),('Macau','MA','Macau','MAC'),('Macedonia','MK','Macedonia','MAC'),('Madagascar','MG','Antananarivo','ANT'),('Madagascar','MG','Antsiranana','ASI'),('Madagascar','MG','Fianarantsoa','FIA'),('Madagascar','MG','Mahajanga','MAH'),('Madagascar','MG','Toamasina','TOA'),('Madagascar','MG','Toliary','TOL'),('Malawi','MW','Malawi','MAL'),('Malaysia','MY','Johor','JOH'),('Malaysia','MY','Kedah','KED'),('Malaysia','MY','Kelantan','KEL'),('Malaysia','MY','Melaka','MEL'),('Malaysia','MY','Pahang','PAH'),('Malaysia','MY','Perak','PER'),('Malaysia','MY','Perlis','PES'),('Malaysia','MY','Pulau Pinang','PIN'),('Malaysia','MY','Sabah','SAB'),('Malaysia','MY','Sarawak','SAR'),('Malaysia','MY','Selangor','SEL'),('Malaysia','MY','Sembilan','SEM'),('Malaysia','MY','Terengganu','TER'),('Malaysia','MY','Unknown','UNK'),('Malaysia','MY','Wilayah Persekutuan','WIL'),('Maldives','MV','Maldives','MAL'),('Mali','ML','Mali','MAL'),('Malta','MT','Malta','MAL'),('Marshall Islands','MH','Marshall Islands','MRI'),('Martinique','MB','Martinique','MAR'),('Mauritania','MR','Mauritania','MAU'),('Mauritius','MU','Mauritius','MAU'),('Mayotte','YT','Mayotte','MAY'),('Mexico','MX','Aguascalientes','AGS'),('Mexico','MX','Baja California','BCN'),('Mexico','MX','Baja California Sur','BCS'),('Mexico','MX','Campeche','CAM'),('Mexico','MX','Chiapas','CHS'),('Mexico','MX','Chihuahua','CHI'),('Mexico','MX','Coahuila','COA'),('Mexico','MX','Colima','COL'),('Mexico','MX','Distrito Federal','DF'),('Mexico','MX','Durango','DGO'),('Mexico','MX','Guanajuato','GTO'),('Mexico','MX','Guerrero','GRO'),('Mexico','MX','Hidalgo','HGO'),('Mexico','MX','Jalisco','JAL'),('Mexico','MX','Mexico','MEX'),('Mexico','MX','Michoacan de Ocampo','MIC'),('Mexico','MX','Morelos','MOR'),('Mexico','MX','Nayarit','NAY'),('Mexico','MX','Nuevo Leon','NLN'),('Mexico','MX','Oaxaca','OAX'),('Mexico','MX','Puebla','PUE'),('Mexico','MX','Queretaro de Arteaga','QRO'),('Mexico','MX','Quintana Roo','QTR'),('Mexico','MX','San Luis Potosi','SLP'),('Mexico','MX','Sinaloa','SIN'),('Mexico','MX','Sonora','SON'),('Mexico','MX','Tabasco','TAB'),('Mexico','MX','Tamaulipas','TAM'),('Mexico','MX','Tlaxcala','TLA'),('Mexico','MX','Veracruz-Llave','VER'),('Mexico','MX','Yucatan','YUC'),('Mexico','MX','Zacatecas','ZAC'),('Micronesia','FM','Micronesia','MIC'),('Moldova','MD','Moldova','MOL'),('Monaco','MC','Monaco','MON'),('Mongolia','MN','Mongolia','MNG'),('Montserrat','MS','Montserrat','MON'),('Morocco','MA','Chaouia-Ouardigha','CHO'),('Morocco','MA','Doukkala-Abda','DOA'),('Morocco','MA','Fes-Boulemane','FEB'),('Morocco','MA','Gharb-Chrarda-Beni Hsen','GCB'),('Morocco','MA','Grand Casablanca','CAS'),('Morocco','MA','Marrakech-Tensift-El Haouz','MTH'),('Morocco','MA','Meknes-Tafilalt','MET'),('Morocco','MA','Rabat-Sale-Zemmour-Zaer','RSZ'),('Morocco','MA','Sous-Massa-Draa','SMD'),('Morocco','MA','Tanger-Tetouan','TAT'),('Morocco','MA','Taza-Al Hoceima-Taounate','THT'),('Mozambique','MZ','Mozambique','MOZ'),('Myanmar','MM','Ayeyarwady','AYE'),('Myanmar','MM','Bago','BAG'),('Myanmar','MM','Chin','CHI'),('Myanmar','MM','Kachin','KAC'),('Myanmar','MM','Kayah','KAH'),('Myanmar','MM','Kayin','KAN'),('Myanmar','MM','Magway','MAG'),('Myanmar','MM','Mandalay','MAN'),('Myanmar','MM','Mon','MON'),('Myanmar','MM','Rakhine','RAK'),('Myanmar','MM','Sagaing','SAG'),('Myanmar','MM','Shan','SHA'),('Myanmar','MM','Tanintharyi','TAN'),('Myanmar','MM','Unknown','UNK'),('Namibia','NA','Namibia','NAM'),('Nauru','NR','Nauru','NAU'),('Nepal','NP','Nepal','NEP'),('Netherlands','NL','Drenthe','DRE'),('Netherlands','NL','Flevoland','FLE'),('Netherlands','NL','Friesland','FRI'),('Netherlands','NL','Gelderland','GEL'),('Netherlands','NL','Groningen','GRO'),('Netherlands','NL','Limburg','LIM'),('Netherlands','NL','Noord-Brabant','NBR'),('Netherlands','NL','Noord-Holland','NHL'),('Netherlands','NL','Overijssel','OVE'),('Netherlands','NL','Utrecht','UTR'),('Netherlands','NL','Zeeland','ZEE'),('Netherlands','NL','Zuid-Holland','ZHO'),('Netherlands Antilles','AN','Netherlands Antilles','NTA'),('New Caledonia','NC','New Caledonia','NWC'),('New Zealand','NZ','Chatham Islands','CHI'),('New Zealand','NZ','North Island','NIS'),('New Zealand','NZ','South Island','SIS'),('New Zealand','NZ','Stewart Island','STI'),('Nicaragua','NI','Atlantico Norte','ATN'),('Nicaragua','NI','Atlantico Sur','ATS'),('Nicaragua','NI','Boaco','BOA'),('Nicaragua','NI','Carazo','CAR'),('Nicaragua','NI','Chinandega','CHI'),('Nicaragua','NI','Chontales','CHO'),('Nicaragua','NI','Esteli','EST'),('Nicaragua','NI','Granada','GRA'),('Nicaragua','NI','Jinotega','JIN'),('Nicaragua','NI','Leon','LEO'),('Nicaragua','NI','Madriz','MAD'),('Nicaragua','NI','Managua','MAN'),('Nicaragua','NI','Masaya','MAS'),('Nicaragua','NI','Matagalpa','MAT'),('Nicaragua','NI','Nueva Segovia','NSE'),('Nicaragua','NI','Rio San Juan','RSJ'),('Nicaragua','NI','Rivas','RIV'),('Niger','NE','Agadez','AGA'),('Niger','NE','Diffa','DIF'),('Niger','NE','Dosso','DOS'),('Niger','NE','Maradi','MAR'),('Niger','NE','Niamey','NIA'),('Niger','NE','Tahoua','TAH'),('Niger','NE','Tillaberi','TIL'),('Niger','NE','Zinder','ZIN'),('Nigeria','NG','Abuja','FC'),('Nigeria','NG','Adamawa','AD'),('Nigeria','NG','Bauchi','BA'),('Nigeria','NG','Benue','BE'),('Nigeria','NG','Borno','BO'),('Nigeria','NG','Delta','DE'),('Nigeria','NG','Gombe','GO'),('Nigeria','NG','Gongola','UNK'),('Nigeria','NG','Jigawa','JI'),('Nigeria','NG','Kaduna','KD'),('Nigeria','NG','Kano','KN'),('Nigeria','NG','Katsina','KT'),('Nigeria','NG','Kwara','KW'),('Nigeria','NG','Lagos','LA'),('Nigeria','NG','Nassarawa','NA'),('Nigeria','NG','Niger','NI'),('Nigeria','NG','Ogun','OG'),('Nigeria','NG','Oyo','OY'),('Nigeria','NG','Plateau','PL'),('Nigeria','NG','Sokoto','SO'),('Nigeria','NG','Unknown','UNK'),('Nigeria','NG','Zamfara','ZA'),('Niue','NU','Niue','NIU'),('Norfolk Island','NF','Norfolk Island','NFI'),('North Korea','KP','Chagang-do','CHA'),('North Korea','KP','Hamgyong-bukto','HYP'),('North Korea','KP','Hamgyong-namdo','HYN'),('North Korea','KP','Hwanghae-bukto','HWP'),('North Korea','KP','Hwanghae-namdo','HWN'),('North Korea','KP','Kaesong-si','KAE'),('North Korea','KP','Kangwon-do','KAN'),('North Korea','KP','Najin Sonbong-si','HAM'),('North Korea','KP','Namp\'o-si','NAM'),('North Korea','KP','P\'yongan-bukto','PYP'),('North Korea','KP','P\'yongan-namdo','PYN'),('North Korea','KP','P\'yongyang-si','PYY'),('North Korea','KP','Yanggang-do','YAN'),('Norway','NO','Akershus','AKE'),('Norway','NO','Aust-Agder','AAG'),('Norway','NO','Buskerud','BUS'),('Norway','NO','Finnmark','FIN'),('Norway','NO','Hedmark','HED'),('Norway','NO','Hordaland','HOR'),('Norway','NO','More og Romsdal','MOR'),('Norway','NO','Nord-Trondelag','NTR'),('Norway','NO','Nordland','NOR'),('Norway','NO','Oppland','OPP'),('Norway','NO','Oslo','OSL'),('Norway','NO','Ostfold','OFO'),('Norway','NO','Rogaland','ROG'),('Norway','NO','Sogn og Fjordane','SOF'),('Norway','NO','Sor-Trondelag','STR'),('Norway','NO','Telemark','TEL'),('Norway','NO','Troms','TRO'),('Norway','NO','Vest-Agder','VAG'),('Norway','NO','Vestfold','VFO'),('Oman','OM','Oman','OMN'),('Pakistan','PK','Balochistan','BAL'),('Pakistan','PK','Federally Administered Tribal Areas','TA'),('Pakistan','PK','Islamabad Capital Territory','FCA'),('Pakistan','PK','North-West Frontier Province','NWF'),('Pakistan','PK','Punjab','PUN'),('Pakistan','PK','Sind','SIN'),('Palau','PW','Palau','PAL'),('Panama','PA','Bocas del Toro','BDT'),('Panama','PA','Chiriqui','CHI'),('Panama','PA','Colon','COL'),('Panama','PA','Darien','DAR'),('Panama','PA','Herrera','HER'),('Panama','PA','Kuna Yala','KYA'),('Panama','PA','Los Santos','LSA'),('Panama','PA','Panama','PAN'),('Panama','PA','Veraguas','VER'),('Papua New Guinea','PG','Papua New Guinea','PNG'),('Paraguay','PY','Alto Paraguay','APG'),('Paraguay','PY','Alto Parana','APR'),('Paraguay','PY','Amambay','AMA'),('Paraguay','PY','Boqueron','BOQ'),('Paraguay','PY','Caaguazu','CGZ'),('Paraguay','PY','Caazapa','CZP'),('Paraguay','PY','Canindeyu','CAN'),('Paraguay','PY','Central','CEN'),('Paraguay','PY','Concepcion','CON'),('Paraguay','PY','Cordillera','COR'),('Paraguay','PY','Guaira','GUA'),('Paraguay','PY','Itapua','ITA'),('Paraguay','PY','Misiones','MIS'),('Paraguay','PY','Neembucu','NEE'),('Paraguay','PY','Paraguari','PAR'),('Paraguay','PY','Presidente Hayes','PHA'),('Paraguay','PY','San Pedro','SPE'),('Peru','PE','Amazonas','AMA'),('Peru','PE','Ancash','ANC'),('Peru','PE','Apurimac','APU'),('Peru','PE','Arequipa','ARE'),('Peru','PE','Ayacucho','AYA'),('Peru','PE','Cajamarca','CAJ'),('Peru','PE','Callao','CAL'),('Peru','PE','Cusco','CUS'),('Peru','PE','Huancavelica','HUA'),('Peru','PE','Huanuco','HUO'),('Peru','PE','Ica','ICA'),('Peru','PE','Junin','JUN'),('Peru','PE','La Libertad','LIB'),('Peru','PE','Lambayeque','LAM'),('Peru','PE','Lima','LIM'),('Peru','PE','Loreto','LOR'),('Peru','PE','Madre de Dios','MAD'),('Peru','PE','Moquegua','MOQ'),('Peru','PE','Pasco','PAS'),('Peru','PE','Piura','PIU'),('Peru','PE','Puno','PUN'),('Peru','PE','San Martin','MAR'),('Peru','PE','Tacna','TAC'),('Peru','PE','Tumbes','TUM'),('Peru','PE','Ucayali','UCA'),('Philippines','PH','Abra','01'),('Philippines','PH','Agusan del Norte','02'),('Philippines','PH','Agusan del Sur','03'),('Philippines','PH','Aklan','04'),('Philippines','PH','Albay','05'),('Philippines','PH','Angeles City','A1'),('Philippines','PH','Antique','06'),('Philippines','PH','Aurora','G8'),('Philippines','PH','Bacolod City','A2'),('Philippines','PH','Bago City','A3'),('Philippines','PH','Baguio City','A4'),('Philippines','PH','Basilan','22'),('Philippines','PH','Bataan','07'),('Philippines','PH','Batanes','08'),('Philippines','PH','Batangas','09'),('Philippines','PH','Batangas City','A7'),('Philippines','PH','Benguet','10'),('Philippines','PH','Bohol','11'),('Philippines','PH','Bukidnon','12'),('Philippines','PH','Bulacan','13'),('Philippines','PH','Butuan City','A8'),('Philippines','PH','Cabanatuan City','A9'),('Philippines','PH','Cadiz City','B1'),('Philippines','PH','Cagayan','14'),('Philippines','PH','Cagayan de Oro City','B2'),('Philippines','PH','Calbayog City','B3'),('Philippines','PH','Caloocan City','B4'),('Philippines','PH','Camarines Norte','15'),('Philippines','PH','Camarines Sur','16'),('Philippines','PH','Camiguin','17'),('Philippines','PH','Canlaon City','B5'),('Philippines','PH','Capiz','18'),('Philippines','PH','Catanduanes','19'),('Philippines','PH','Cavite','20'),('Philippines','PH','Cavite City','B6'),('Philippines','PH','Cebu','21'),('Philippines','PH','Cebu City','B7'),('Philippines','PH','City of Manila','D9'),('Philippines','PH','Cotabato City','B8'),('Philippines','PH','Dagupan City','B9'),('Philippines','PH','Danao City','C1'),('Philippines','PH','Dapitan City','C2'),('Philippines','PH','Davao City','C3'),('Philippines','PH','Davao del Norte','24'),('Philippines','PH','Davao del Sur','25'),('Philippines','PH','Davao Oriental','26'),('Philippines','PH','Dipolog City','C4'),('Philippines','PH','Dumaguete City','C5'),('Philippines','PH','Eastern Samar','23'),('Philippines','PH','General Santos City','C6'),('Philippines','PH','Gingoog City','C7'),('Philippines','PH','Ifugao','27'),('Philippines','PH','Iligan City','C8'),('Philippines','PH','Ilocos Norte','28'),('Philippines','PH','Ilocos Sur','29'),('Philippines','PH','Iloilo','30'),('Philippines','PH','Iloilo City','C9'),('Philippines','PH','Iriga City','D1'),('Philippines','PH','Isabela','31'),('Philippines','PH','Kalinga-Apayao','32'),('Philippines','PH','La Carlota City','D2'),('Philippines','PH','La Union','36'),('Philippines','PH','Laguna','33'),('Philippines','PH','Lanao del Norte','34'),('Philippines','PH','Lanao del Sur','35'),('Philippines','PH','Laoag City','D3'),('Philippines','PH','Lapu-Lapu City','D4'),('Philippines','PH','Legaspi City','D5'),('Philippines','PH','Leyte','37'),('Philippines','PH','Lipa City','D6'),('Philippines','PH','Lucena City','D7'),('Philippines','PH','Maguindanao','56'),('Philippines','PH','Mandaue City','D8'),('Philippines','PH','Marawi City','E1'),('Philippines','PH','Marinduque','38'),('Philippines','PH','Masbate','39'),('Philippines','PH','Mindoro Occidental','40'),('Philippines','PH','Mindoro Oriental','41'),('Philippines','PH','Misamis Occidental','42'),('Philippines','PH','Misamis Oriental','43'),('Philippines','PH','Mountain Province','44'),('Philippines','PH','Naga City','E2'),('Philippines','PH','Negros Occidental','H3'),('Philippines','PH','Negros Oriental','46'),('Philippines','PH','North Cotabato','57'),('Philippines','PH','Northern Samar','67'),('Philippines','PH','Nueva Ecija','47'),('Philippines','PH','Nueva Vizcaya','48'),('Philippines','PH','Olongapo City','E3'),('Philippines','PH','Ormoc City','E4'),('Philippines','PH','Oroquieta City','E5'),('Philippines','PH','Ozamis City','E6'),('Philippines','PH','Pagadian City','E7'),('Philippines','PH','Palawan','49'),('Philippines','PH','Palayan City','E8'),('Philippines','PH','Pampanga','50'),('Philippines','PH','Pangasinan','51'),('Philippines','PH','Pasay City','E9'),('Philippines','PH','Puerto Princesa City','F1'),('Philippines','PH','Quezon','H2'),('Philippines','PH','Quezon City','F2'),('Philippines','PH','Quirino','68'),('Philippines','PH','Rizal','53'),('Philippines','PH','Romblon','54'),('Philippines','PH','Roxas City','F3'),('Philippines','PH','Samar','55'),('Philippines','PH','San Carlos City','F4'),('Philippines','PH','San Pablo City','F7'),('Philippines','PH','Silay City','F8'),('Philippines','PH','Siquijor','69'),('Philippines','PH','Sorsogon','58'),('Philippines','PH','South Cotabato','70'),('Philippines','PH','Southern Leyte','59'),('Philippines','PH','Sultan Kudarat','71'),('Philippines','PH','Sulu','60'),('Philippines','PH','Surigao City','F9'),('Philippines','PH','Surigao del Norte','61'),('Philippines','PH','Surigao del Sur','62'),('Philippines','PH','Tacloban City','G1'),('Philippines','PH','Tagaytay City','G2'),('Philippines','PH','Tagbilaran City','G3'),('Philippines','PH','Tangub City','G4'),('Philippines','PH','Tarlac','63'),('Philippines','PH','Tawi-Tawi','72'),('Philippines','PH','Toledo City','G5'),('Philippines','PH','Trece Martires City','G6'),('Philippines','PH','Zambales','64'),('Philippines','PH','Zamboanga City','G7'),('Philippines','PH','Zamboanga del Norte','65'),('Philippines','PH','Zamboanga del Sur','66'),('Pitcairn Islands','PN','Pitcairn Islands','PIT'),('Poland','PL','Dolnoslaskie','DOL'),('Poland','PL','Kujawsko-Pomorskie','KUJ'),('Poland','PL','Lodzkie','LOD'),('Poland','PL','Lubelskie','LUB'),('Poland','PL','Lubuskie','LBU'),('Poland','PL','Malopolskie','MAL'),('Poland','PL','Mazowieckie','MAZ'),('Poland','PL','Opolskie','OPO'),('Poland','PL','Podkarpackie','PDK'),('Poland','PL','Podlaskie','POD'),('Poland','PL','Pomorskie','POM'),('Poland','PL','Slaskie','SLA'),('Poland','PL','Swietokrzyskie','SWI'),('Poland','PL','Warminsko-Mazurskie','WAR'),('Poland','PL','Wielkopolskie','WIE'),('Poland','PL','Zachodniopomorskie','ZAC'),('Portugal','PT','Acores','ACO'),('Portugal','PT','Alentejo','ALE'),('Portugal','PT','Algarve','ALG'),('Portugal','PT','Centro','CEN'),('Portugal','PT','Lisboa','LIS'),('Portugal','PT','Madeira','MAD'),('Portugal','PT','Norte','NOR'),('Qatar','QA','Qatar','QTR'),('Reunion','RE','Reunion','RE'),('Romania','RO','Alba','ALB'),('Romania','RO','Arad','ARA'),('Romania','RO','Arges','ARG'),('Romania','RO','Bacau','BAC'),('Romania','RO','Bihor','BIH'),('Romania','RO','Bistrita-Nasaud','BIS'),('Romania','RO','Botosani','BOT'),('Romania','RO','Braila','BRA'),('Romania','RO','Brasov','BRS'),('Romania','RO','Buzau','BUZ'),('Romania','RO','Calarasi','CAL'),('Romania','RO','Caras-Severin','CAR'),('Romania','RO','Cluj','CLU'),('Romania','RO','Constanta','CON'),('Romania','RO','Covasna','COV'),('Romania','RO','Dambovita','DAM'),('Romania','RO','Dolj','DOL'),('Romania','RO','Galati','GAL'),('Romania','RO','Giurgiu','GIU'),('Romania','RO','Gorj','GOR'),('Romania','RO','Harghita','HAR'),('Romania','RO','Hunedoara','HUN'),('Romania','RO','Ialomita','IAL'),('Romania','RO','Iasi','IAS'),('Romania','RO','Ilfov','ILF'),('Romania','RO','Maramures','MAR'),('Romania','RO','Mehedinti','MEH'),('Romania','RO','Municipiul Bucuresti','BUC'),('Romania','RO','Mures','MUR'),('Romania','RO','Neamt','NEA'),('Romania','RO','Olt','OLT'),('Romania','RO','Prahova','PRA'),('Romania','RO','Salaj','SAL'),('Romania','RO','Satu Mare','SAT'),('Romania','RO','Sibiu','SIB'),('Romania','RO','Suceava','SUC'),('Romania','RO','Teleorman','TEL'),('Romania','RO','Timis','TIM'),('Romania','RO','Tulcea','TUL'),('Romania','RO','Unknown','UNK'),('Romania','RO','Valcea','VAL'),('Romania','RO','Vaslui','VAS'),('Romania','RO','Vrancea','VRA'),('Russia','RU','Aginskiy Buryatskiy','02'),('Russia','RU','Altayskiy Kray','04'),('Russia','RU','Amurskaya','05'),('Russia','RU','Arkhangel\'skaya','06'),('Russia','RU','Astrakhanskaya','07'),('Russia','RU','Belgorodskaya','09'),('Russia','RU','Bryanskaya','10'),('Russia','RU','Chechenskaya','CI'),('Russia','RU','Chelyabinskaya','13'),('Russia','RU','Chitinskaya','14'),('Russia','RU','Chukotskiy','15'),('Russia','RU','Chuvashskaya','16'),('Russia','RU','Evenkiyskiy','18'),('Russia','RU','Gorod Moskva','48'),('Russia','RU','Gorod Sankt-Peterburg','66'),('Russia','RU','Irkutskaya','20'),('Russia','RU','Ivanovskaya','21'),('Russia','RU','Kabardino-Balkarskaya','22'),('Russia','RU','Kaliningradskaya','23'),('Russia','RU','Kaluzhskaya','25'),('Russia','RU','Kamchatskaya','26'),('Russia','RU','Karachayevo-Cherkesskaya','27'),('Russia','RU','Kemerovskaya','29'),('Russia','RU','Khabarovskiy Kray','30'),('Russia','RU','Khanty-Mansiyskiy','32'),('Russia','RU','Kirovskaya','33'),('Russia','RU','Komi-Permyatskiy','35'),('Russia','RU','Koryakskiy','36'),('Russia','RU','Kostromskaya','37'),('Russia','RU','Krasnodarskiy Kray','38'),('Russia','RU','Krasnoyarskiy Kray','39'),('Russia','RU','Kurganskaya','40'),('Russia','RU','Kurskaya','41'),('Russia','RU','Leningradskaya','42'),('Russia','RU','Lipetskaya','43'),('Russia','RU','Magadanskaya','44'),('Russia','RU','Moskovskaya','47'),('Russia','RU','Murmanskaya','49'),('Russia','RU','Nenetskiy','50'),('Russia','RU','Nizhegorodskaya','51'),('Russia','RU','Novgorodskaya','52'),('Russia','RU','Novosibirskaya','53'),('Russia','RU','Omskaya','54'),('Russia','RU','Orenburgskaya','55'),('Russia','RU','Orlovskaya','56'),('Russia','RU','Penzenskaya','57'),('Russia','RU','Permskaya','58'),('Russia','RU','Primorskiy Kray','59'),('Russia','RU','Pskovskaya','60'),('Russia','RU','Respublika Adygeya','01'),('Russia','RU','Respublika Altay','03'),('Russia','RU','Respublika Bashkortostan','08'),('Russia','RU','Respublika Buryatiya','11'),('Russia','RU','Respublika Dagestan','17'),('Russia','RU','Respublika Kalmykiya','24'),('Russia','RU','Respublika Kareliya','28'),('Russia','RU','Respublika Khakasiya','31'),('Russia','RU','Respublika Komi','34'),('Russia','RU','Respublika Mariy-El','45'),('Russia','RU','Respublika Mordoviya','46'),('Russia','RU','Respublika Sakha','Yakut'),('Russia','RU','Respublika Severnaya Osetiya-Alaniya','68'),('Russia','RU','Respublika Tatarstan','73'),('Russia','RU','Respublika Tyva','79'),('Russia','RU','Rostovskaya','61'),('Russia','RU','Ryazanskaya','62'),('Russia','RU','Sakhalinskaya','64'),('Russia','RU','Samarskaya','65'),('Russia','RU','Saratovskaya','67'),('Russia','RU','Smolenskaya','69'),('Russia','RU','Stavropol\'skiy Kray','70'),('Russia','RU','Sverdlovskaya','71'),('Russia','RU','Tambovskaya','72'),('Russia','RU','Taymyrskiy','Dolga'),('Russia','RU','Tomskaya','75'),('Russia','RU','Tul\'skaya','76'),('Russia','RU','Tverskaya','77'),('Russia','RU','Tyumenskaya','78'),('Russia','RU','Udmurtskaya','80'),('Russia','RU','Ul\'yanovskaya','81'),('Russia','RU','Ust\'-Ordynskiy Buryatskiy','82'),('Russia','RU','Vladimirskaya','83'),('Russia','RU','Volgogradskaya','84'),('Russia','RU','Vologodskaya','85'),('Russia','RU','Voronezhskaya','86'),('Russia','RU','Yamalo-Nenetskiy','87'),('Russia','RU','Yaroslavskaya','88'),('Russia','RU','Yevreyskaya','89'),('Rwanda','RW','Rwanda','RWA'),('Saint Helena','SH','Saint Helena','STH'),('Saint Kitts and Nevis','KN','Saint Kitts & Nevis','SKN'),('Saint Lucia','LC','Saint Lucia','SLC'),('Saint Pierre and Miquelon','PM','Saint Pierre & Miquelon','SPM'),('Saint Vincent and the Grenadines','VC','Saint Vincent & the Grenadines','STV'),('Samoa','WS','Samoa','SAM'),('San Marino','SM','San Marino','MAR'),('Sao Tome & Principe','ST','Sao Tome & Principe','SAO'),('Saudi Arabia','SA','Al Bahah','BAH'),('Saudi Arabia','SA','Al Hudud ash Shamaliyah','HUD'),('Saudi Arabia','SA','Al Madinah','MAD'),('Saudi Arabia','SA','Al Mintaqah ash Sharqiyah','MAS'),('Saudi Arabia','SA','Al Qasim','QAS'),('Saudi Arabia','SA','Al-Jawf','JAW'),('Saudi Arabia','SA','Ar Riyad','RIY'),('Saudi Arabia','SA','Ha\'il','HAI'),('Saudi Arabia','SA','Jizan','JIZ'),('Saudi Arabia','SA','Makkah','MAK'),('Saudi Arabia','SA','Tabuk','TAB'),('Senegal','SN','Dakar','DAK'),('Senegal','SN','Saint-Louis','STL'),('Senegal','SN','Thies','THI'),('Serbia and Montenegro','CS','Serbia & Montenegro','SRB'),('Seychelles','SC','Seychelles','SEY'),('Sierra Leone','SL','Eastern Province','EAS'),('Sierra Leone','SL','Northern Province','NOR'),('Sierra Leone','SL','Southern Province','SOU'),('Sierra Leone','SL','Western Area','WES'),('Singapore','SG','Singapore','SNG'),('Slovakia','SK','Slovakia','SLO'),('Slovenia','SI','Slovenia','SLO'),('Solomon Islands','SB','Solomon Islands','SOL'),('Somalia','SO','Bakool','BAK'),('Somalia','SO','Banaadir','BAN'),('Somalia','SO','Bari','BAR'),('Somalia','SO','Bay','BAY'),('Somalia','SO','Gedo','GED'),('Somalia','SO','Jubbada Dhexe','JUD'),('Somalia','SO','Jubbada Hoose','JUH'),('Somalia','SO','Shabeellaha Hoose','SHH'),('South Africa','ZA','Eastern Cape','EAS'),('South Africa','ZA','Free State','FRE'),('South Africa','ZA','Gauteng','GAU'),('South Africa','ZA','KwaZulu-Natal','KWA'),('South Africa','ZA','Limpopo','LIM'),('South Africa','ZA','Mpumalanga','MPU'),('South Africa','ZA','North-West','NRW'),('South Africa','ZA','Northern Cape','NOR'),('South Africa','ZA','Unknown','UNK'),('South Africa','ZA','Western Cape','WES'),('South Georgia','GS','South Georgia & South Sandwich Islands','SGS'),('South Korea','KR','Ch\'ungch\'ong-bukto','CHU'),('South Korea','KR','Ch\'ungch\'ong-namdo','CON'),('South Korea','KR','Cheju-do','CHE'),('South Korea','KR','Cholla-bukto','CHO'),('South Korea','KR','Cholla-namdo','CHN'),('South Korea','KR','Inch\'on-gwangyoksi','INC'),('South Korea','KR','Kangwon-do','KAN'),('South Korea','KR','Kwangju-gwangyoksi','KWA'),('South Korea','KR','Kyonggi-do','KYO'),('South Korea','KR','Kyongsang-bukto','KYB'),('South Korea','KR','Kyongsang-namdo','KGM'),('South Korea','KR','Pusan-gwangyoksi','PUS'),('South Korea','KR','Soul-t\'ukpyolsi','SOU'),('South Korea','KR','Taegu-gwangyoksi','TAE'),('South Korea','KR','Taejon-gwangyoksi','TAG'),('South Korea','KR','Ulsan-gwangyoksi','ULS'),('Spain','ES','Andalucia','AND'),('Spain','ES','Aragon','ARA'),('Spain','ES','Asturias','AST'),('Spain','ES','Baleares','BAL'),('Spain','ES','Canarias','CAN'),('Spain','ES','Cantabria','CAR'),('Spain','ES','Castilla y Leon','CLE'),('Spain','ES','Castilla-La Mancha','CLM'),('Spain','ES','Cataluna','CAT'),('Spain','ES','Ceuta y Melilla','CM'),('Spain','ES','Extremadura','EXT'),('Spain','ES','Galicia','GAL'),('Spain','ES','La Rioja','LAR'),('Spain','ES','Madrid','MAD'),('Spain','ES','Murcia','MUR'),('Spain','ES','Navarra','NAV'),('Spain','ES','Pais Vasco','PAI'),('Spain','ES','Valencia','VAL'),('Sri Lanka','LK','Sri Lanka','SRI'),('Sudan','SD','Sudan','SUD'),('Suriname','SR','Suriname','SUR'),('Svalbard','SJ','Svalbard','SVL'),('Swaziland','SZ','Swaziland','SWZ'),('Sweden','SE','Blekinge lan','BLE'),('Sweden','SE','Dalarnas lan','DAL'),('Sweden','SE','Gavleborgs lan','GAV'),('Sweden','SE','Gotlands lan','GOT'),('Sweden','SE','Hallands lan','HAL'),('Sweden','SE','Jamtlands lan','JAM'),('Sweden','SE','Jonkopings lan','JON'),('Sweden','SE','Kalmar lan','KAL'),('Sweden','SE','Kronobergs lan','KRO'),('Sweden','SE','Norrbottens lan','NOR'),('Sweden','SE','Orebro lan','ORE'),('Sweden','SE','Ostergotlands lan','OST'),('Sweden','SE','Skane lan','SKA'),('Sweden','SE','Sodermanlands lan','SOD'),('Sweden','SE','Stockholms lan','STO'),('Sweden','SE','Uppsala lan','UPP'),('Sweden','SE','Varmlands lan','VAR'),('Sweden','SE','Vasterbottens lan','VAS'),('Sweden','SE','Vasternorrlands lan','VNL'),('Sweden','SE','Vastmanlands lan','VML'),('Sweden','SE','Vastra Gotalands lan','VGI'),('Switzerland','CH','Aargau','1AG'),('Switzerland','CH','Appenzell Ausserrhoden','1AR'),('Switzerland','CH','Appenzell Innerrhoden','1AI'),('Switzerland','CH','Basel-Landschaft','1BL'),('Switzerland','CH','Basel-Stadt','1BS'),('Switzerland','CH','Bern','1BE'),('Switzerland','CH','Fribourg','1FR'),('Switzerland','CH','Geneva','1GE'),('Switzerland','CH','Glarus','1GL'),('Switzerland','CH','Graub','1GR'),('Switzerland','CH','Jura','1JU'),('Switzerland','CH','Lucerne','1LU'),('Switzerland','CH','Neuch','1NE'),('Switzerland','CH','Nidwalden','1NW'),('Switzerland','CH','Obwalden','1OW'),('Switzerland','CH','Schaffhausen','1SH'),('Switzerland','CH','Schwyz','1SZ'),('Switzerland','CH','Solothurn','1SO'),('Switzerland','CH','St. Gallen','1SG'),('Switzerland','CH','Thurgau','1TG'),('Switzerland','CH','Ticino','1TI'),('Switzerland','CH','Uri','1UR'),('Switzerland','CH','Valais','1VS'),('Switzerland','CH','Vaud','1VD'),('Switzerland','CH','Zug','1ZG'),('Switzerland','CH','Zurich','1ZH'),('Syria','SY','Dar`a','DAR'),('Syria','SY','Dayr az Zawr','DAY'),('Syria','SY','Dimashq','DIM'),('Syria','SY','Hamah','HAM'),('Syria','SY','Hasakah','HAS'),('Syria','SY','Hims','HIM'),('Syria','SY','Ladhiqiyah','LAD'),('Syria','SY','Unknown','UNK'),('Taiwan','TW','Kao-hsiung','KAO'),('Taiwan','TW','T\'ai-pei','TPS'),('Taiwan','TW','T\'ai-wan','TWS'),('Tajikistan','TJ','Khatlon','KHA'),('Tajikistan','TJ','Mukhtori Kuhistoni Badakhshon','MKB'),('Tajikistan','TJ','Sughd','SUG'),('Tajikistan','TJ','Unknown','UNK'),('Tanzania','TZ','Kagera','KAG'),('Tanzania','TZ','Kigoma','KIG'),('Tanzania','TZ','Kilimanjaro','KIL'),('Tanzania','TZ','Mwanza','MWA'),('Tanzania','TZ','Rukwa','RUK'),('Tanzania','TZ','Shinyanga','SHI'),('Tanzania','TZ','Tabora','TAB'),('Tanzania','TZ','Unknown','UNK'),('Thailand','TH','Bangkok Metropolis','BKM'),('Thailand','TH','Central','CEN'),('Thailand','TH','Northeastern','NEA'),('Thailand','TH','Northern','NOR'),('Thailand','TH','Southern','SOU'),('Togo','TG','Togo','TOG'),('Tokelau','TK','Tokelau','TOK'),('Tonga','TO','Tonga','TNG'),('Trinidad and Tobago','TT','Trinidad & Tobago','TRT'),('Tunisia','TN','Ariana','ARI'),('Tunisia','TN','Mahdia','MAH'),('Tunisia','TN','Sousse','SOU'),('Tunisia','TN','Tunis','TUN'),('Tunisia','TN','Unknown','UNK'),('Turkey','TR','Adana','ADA'),('Turkey','TR','Ankara','ANK'),('Turkey','TR','Antalya','ANT'),('Turkey','TR','Aydin','AYD'),('Turkey','TR','Bilecik','BIL'),('Turkey','TR','Bursa','BUR'),('Turkey','TR','Diyarbakir','DIY'),('Turkey','TR','Erzurum','ERZ'),('Turkey','TR','Hakkari','HAK'),('Turkey','TR','Hatay','HAT'),('Turkey','TR','Icel','ICE'),('Turkey','TR','Isparta','ISP'),('Turkey','TR','Istanbul','IST'),('Turkey','TR','Izmir','IZM'),('Turkey','TR','Karaman','KAM'),('Turkey','TR','Kilis','KIL'),('Turkey','TR','Kocaeli','KOC'),('Turkey','TR','Konya','KON'),('Turkey','TR','Manisa','MAN'),('Turkey','TR','Nigde','NIG'),('Turkey','TR','Sirnak','SIR'),('Turkey','TR','Sivas','SIV'),('Turkey','TR','Yalova','YAL'),('Turkmenistan','TM','Ahal','AHL'),('Turkmenistan','TM','Balkan','BAL'),('Turkmenistan','TM','Dasoguz','DAS'),('Turkmenistan','TM','Lebap','LEB'),('Turkmenistan','TM','Mary','MAR'),('Turks and Caicos Islands','TC','Turks & Caicos Islands','TUK'),('Tuvalu','TV','Tuvalu','TUV'),('Uganda','UG','Uganda','UGA'),('Ukraine','UA','Cherkas\'ka','CHK'),('Ukraine','UA','Chernihivs\'ka','CHH'),('Ukraine','UA','Chernivets\'ka','CHT'),('Ukraine','UA','Dnipropetrovs\'ka','DNI'),('Ukraine','UA','Donets\'ka','DON'),('Ukraine','UA','Ivano-Frankivs\'ka','IVA'),('Ukraine','UA','Kharkivs\'ka','KHA'),('Ukraine','UA','Khersons\'ka','KHE'),('Ukraine','UA','Khmel\'nyts\'ka','KHM'),('Ukraine','UA','Kirovohrads\'ka','KIR'),('Ukraine','UA','Kyrm','KRY'),('Ukraine','UA','Kyyivs\'ka','KYY'),('Ukraine','UA','L\'vivs\'ka','LVI'),('Ukraine','UA','Luhans\'ka','LUH'),('Ukraine','UA','Misto Kyyiv','KYC'),('Ukraine','UA','Misto Sevastopol\'','SEV'),('Ukraine','UA','Mykolayivs\'ka','MYK'),('Ukraine','UA','Odes\'ka','ODE'),('Ukraine','UA','Poltavs\'ka','POL'),('Ukraine','UA','Rivnens\'ka','RIV'),('Ukraine','UA','Sums\'ka','SUM'),('Ukraine','UA','Ternopil\'s\'ka','TER'),('Ukraine','UA','Vinnyts\'ka','VIN'),('Ukraine','UA','Volyns\'ka','VOL'),('Ukraine','UA','Zakarpats\'ka','ZAK'),('Ukraine','UA','Zaporiz\'ka','ZAP'),('Ukraine','UA','Zhytomyrs\'ka','ZHY'),('United Arab Emirates','AE','United Arab Emirates','UAE'),('United Kingdom','GB','Avon','AVN'),('United Kingdom','GB','Bedfordshire','BFE'),('United Kingdom','GB','Berkshire','BKE'),('United Kingdom','GB','Borders','BDE'),('United Kingdom','GB','Buckinghamshire','BHE'),('United Kingdom','GB','Cambridgeshire','CBE'),('United Kingdom','GB','Central','CTL'),('United Kingdom','GB','Cheshire','CHE'),('United Kingdom','GB','Cleveland','CVD'),('United Kingdom','GB','Clwyd','CLD'),('United Kingdom','GB','Cornwall','CWL'),('United Kingdom','GB','CountyAntrim','CAM'),('United Kingdom','GB','CountyArmagh','CAH'),('United Kingdom','GB','CountyDown','CDN'),('United Kingdom','GB','CountyFermanagh','CFH'),('United Kingdom','GB','CountyLondonderry','CLY'),('United Kingdom','GB','CountyTyrone','CTE'),('United Kingdom','GB','Cumbria','CUA'),('United Kingdom','GB','Derbyshire','DYE'),('United Kingdom','GB','Devon','DVN'),('United Kingdom','GB','Dorset','DST'),('United Kingdom','GB','DumfriesandGalloway','DGY'),('United Kingdom','GB','Durham','DRM'),('United Kingdom','GB','Dyfed','DYD'),('United Kingdom','GB','EastSussex','EAX'),('United Kingdom','GB','Essex','ESX'),('United Kingdom','GB','Fife','FFE'),('United Kingdom','GB','Gloucestershire','GTE'),('United Kingdom','GB','Grampian','GRN'),('United Kingdom','GB','GreaterManchester','GMR'),('United Kingdom','GB','Gwent','GWT'),('United Kingdom','GB','GwyneddCounty','GCY'),('United Kingdom','GB','Hampshire','HHE'),('United Kingdom','GB','Herefordshire','HEE'),('United Kingdom','GB','Hertfordshire','HTE'),('United Kingdom','GB','HighlandsandIslands','HSS'),('United Kingdom','GB','Humberside','HBE'),('United Kingdom','GB','IsleofWight','IWT'),('United Kingdom','GB','Kent','KET'),('United Kingdom','GB','Lancashire','LCE'),('United Kingdom','GB','Leicestershire','LEE'),('United Kingdom','GB','Lincolnshire','LIE'),('United Kingdom','GB','Lothian','LTN'),('United Kingdom','GB','Merseyside','MYE'),('United Kingdom','GB','MidGlamorgan','MGN'),('United Kingdom','GB','Norfolk','NFK'),('United Kingdom','GB','NorthYorkshire','NYE'),('United Kingdom','GB','Northamptonshire','NSE'),('United Kingdom','GB','Northumberland','NLD'),('United Kingdom','GB','Nottinghamshire','NHE'),('United Kingdom','GB','Oxfordshire','OSE'),('United Kingdom','GB','Powys','POS'),('United Kingdom','GB','Rutland','RTD'),('United Kingdom','GB','Shropshire','SSE'),('United Kingdom','GB','Somerset','SRT'),('United Kingdom','GB','SouthGlamorgan','SGN'),('United Kingdom','GB','SouthYorkshire','SYE'),('United Kingdom','GB','Staffordshire','SFE'),('United Kingdom','GB','Strathclyde','STE'),('United Kingdom','GB','Suffolk','SUK'),('United Kingdom','GB','Surrey','SRY'),('United Kingdom','GB','Tayside','TSE'),('United Kingdom','GB','TyneandWear','TWR'),('United Kingdom','GB','Warwickshire','WSE'),('United Kingdom','GB','WestGlamorgan','WGN'),('United Kingdom','GB','WestMidlands','WMS'),('United Kingdom','GB','WestSussex','WSX'),('United Kingdom','GB','WestYorkshire','WYE'),('United Kingdom','GB','Wiltshire','WHE'),('United Kingdom','GB','Worcestershire','WOE'),('United States','US','Alabama','AL'),('United States','US','Alaska','AK'),('United States','US','American Samoa','AS'),('United States','US','Arizona','AZ'),('United States','US','Arkansas','AR'),('United States','US','California','CA'),('United States','US','Colorado','CO'),('United States','US','Connecticut','CT'),('United States','US','Delaware','DE'),('United States','US','District of Columbia','DC'),('United States','US','Florida','FL'),('United States','US','Georgia','GA'),('United States','US','Guam','GU'),('United States','US','Hawaii','HI'),('United States','US','Idaho','ID'),('United States','US','Illinois','IL'),('United States','US','Indiana','IN'),('United States','US','Iowa','IA'),('United States','US','Kansas','KS'),('United States','US','Kentucky','KY'),('United States','US','Louisiana','LA'),('United States','US','Maine','ME'),('United States','US','Maryland','MD'),('United States','US','Massachusetts','MA'),('United States','US','Michigan','MI'),('United States','US','Minnesota','MN'),('United States','US','Mississippi','MS'),('United States','US','Missouri','MO'),('United States','US','Montana','MT'),('United States','US','Nebraska','NE'),('United States','US','Nevada','NV'),('United States','US','New Hampshire','NH'),('United States','US','New Jersey','NJ'),('United States','US','New Mexico','NM'),('United States','US','New York','NY'),('United States','US','North Carolina','NC'),('United States','US','North Dakota','ND'),('United States','US','Northern Mariana Islands','MP'),('United States','US','Ohio','OH'),('United States','US','Oklahoma','OK'),('United States','US','Oregon','OR'),('United States','US','Pennsylvania','PA'),('United States','US','Puerto Rico','PR'),('United States','US','Rhode Island','RI'),('United States','US','South Carolina','SC'),('United States','US','South Dakota','SD'),('United States','US','Tennessee','TN'),('United States','US','Texas','TX'),('United States','US','Utah','UT'),('United States','US','Vermont','VT'),('United States','US','Virgin Islands','VI'),('United States','US','Virginia','VA'),('United States','US','Washington','WA'),('United States','US','West Virginia','WV'),('United States','US','Wisconsin','WI'),('United States','US','Wyoming','WY'),('Uruguay','UY','Artigas','ART'),('Uruguay','UY','Canelones','CAN'),('Uruguay','UY','Cerro Largo','CER'),('Uruguay','UY','Colonia','COL'),('Uruguay','UY','Durazno','DUR'),('Uruguay','UY','Florida','FLO'),('Uruguay','UY','Lavalleja','LAV'),('Uruguay','UY','Maldonado','MAL'),('Uruguay','UY','Montevideo','MON'),('Uruguay','UY','Paysandu','PAY'),('Uruguay','UY','Rio Negro','RNE'),('Uruguay','UY','Rivera','RIV'),('Uruguay','UY','Rocha','ROC'),('Uruguay','UY','Salto','SAL'),('Uruguay','UY','San Jose','SJO'),('Uruguay','UY','Soriano','SOR'),('Uruguay','UY','Tacuarembo','TAC'),('Uruguay','UY','Treinta y Tres','TYT'),('Uzbekistan','UZ','Andijon','AND'),('Uzbekistan','UZ','Buxoro','BUX'),('Uzbekistan','UZ','Jizzax','JIZ'),('Uzbekistan','UZ','Namangan','NAM'),('Uzbekistan','UZ','Navoiy','NAV'),('Uzbekistan','UZ','Qashqadaryo','QAS'),('Uzbekistan','UZ','Qoraqalpog`iston','QOR'),('Uzbekistan','UZ','Samarqand','SAM'),('Uzbekistan','UZ','Sirdaryo','SIR'),('Uzbekistan','UZ','Surxondaryo','SUR'),('Uzbekistan','UZ','Toshkent','TOS'),('Uzbekistan','UZ','Toshkent Shahri','TSH'),('Uzbekistan','UZ','Unknown','UNK'),('Uzbekistan','UZ','Xorazm','XOR'),('Vanuatu','VU','Vanuatu','VAN'),('Vatican City','VA','Vatican City','VTC'),('Venezuela','VE','Amazonas','AMA'),('Venezuela','VE','Anzoategui','ANZ'),('Venezuela','VE','Apure','APU'),('Venezuela','VE','Aragua','ARA'),('Venezuela','VE','Barinas','BAR'),('Venezuela','VE','Bolivar','BOL'),('Venezuela','VE','Carabobo','CAR'),('Venezuela','VE','Falcon','FAL'),('Venezuela','VE','Guarico','GUA'),('Venezuela','VE','Lara','LAR'),('Venezuela','VE','Merida','MER'),('Venezuela','VE','Miranda','MIR'),('Venezuela','VE','Monagas','MON'),('Venezuela','VE','Nueva Esparta','NES'),('Venezuela','VE','Sucre','SUC'),('Venezuela','VE','Tachira','TAC'),('Venezuela','VE','Trujillo','TRU'),('Venezuela','VE','Vargas','VAR'),('Venezuela','VE','Yaracuy','YAR'),('Venezuela','VE','Zulia','ZUL'),('Vietnam','VN','An Giang','ANG'),('Vietnam','VN','Ba Ria-Vung Tau','BRV'),('Vietnam','VN','Bac Giang','GIN'),('Vietnam','VN','Bac Kan','KAN'),('Vietnam','VN','Bac Lieu','LIU'),('Vietnam','VN','Bac Ninh','NIH'),('Vietnam','VN','Ben Tre','BEN'),('Vietnam','VN','Binh Dinh','BDI'),('Vietnam','VN','Binh Duong','DUO'),('Vietnam','VN','Binh Phuoc','BPC'),('Vietnam','VN','Binh Thuan','BTH'),('Vietnam','VN','Ca Mau','CAM'),('Vietnam','VN','Can Tho','CAN'),('Vietnam','VN','Cao Bang','CAO'),('Vietnam','VN','Da Nang','DAN'),('Vietnam','VN','Dac Lak','DAC'),('Vietnam','VN','Dong Nai','DNA'),('Vietnam','VN','Dong Thap','DON'),('Vietnam','VN','Gia Lai','GIA'),('Vietnam','VN','Ha Giang','HAG'),('Vietnam','VN','Ha Nam','HAM'),('Vietnam','VN','Ha Tay','HAT'),('Vietnam','VN','Ha Tinh','HAN'),('Vietnam','VN','Hai Duong','HDG'),('Vietnam','VN','Hoa Binh','HOA'),('Vietnam','VN','Hung Yen','HUY'),('Vietnam','VN','Khanh Hoa','KHH'),('Vietnam','VN','Kien Giang','KIE'),('Vietnam','VN','Kon Tum','KON'),('Vietnam','VN','Lai Chau','LAI'),('Vietnam','VN','Lam Dong','LAM'),('Vietnam','VN','Lang Son','LAN'),('Vietnam','VN','Lao Cai','LAC'),('Vietnam','VN','Long An','LON'),('Vietnam','VN','Nam Dinh','NAN'),('Vietnam','VN','Nghe An','NGH'),('Vietnam','VN','Ninh Binh','NBI'),('Vietnam','VN','Ninh Thuan','NIT'),('Vietnam','VN','Phu Tho','PTO'),('Vietnam','VN','Phu Yen','PHU'),('Vietnam','VN','Quang Binh','QBI'),('Vietnam','VN','Quang Nam','QNM'),('Vietnam','VN','Quang Ngai','QNG'),('Vietnam','VN','Quang Ninh','NIN'),('Vietnam','VN','Quang Tri','QTR'),('Vietnam','VN','Soc Trang','SOC'),('Vietnam','VN','Son La','SOL'),('Vietnam','VN','Tay Ninh','TAY'),('Vietnam','VN','Thai Binh','THB'),('Vietnam','VN','Thai Nguyen','TNY'),('Vietnam','VN','Thanh Hoa','THH'),('Vietnam','VN','Thanh Pho Hai Phong','PHP'),('Vietnam','VN','Thanh Pho Ho Chi Minh','PHC'),('Vietnam','VN','Thu Do Ha Noi','TDH'),('Vietnam','VN','Thua Thien-Hue','TTH'),('Vietnam','VN','Tien Giang','TGI'),('Vietnam','VN','Tra Vinh','TRA'),('Vietnam','VN','Tuyen Quang','TUY'),('Vietnam','VN','Vinh Long','VIL'),('Vietnam','VN','Vinh Phuc','VPC'),('Vietnam','VN','Yen Bai','YEN'),('Wallis and Futuna','WF','Wallis & Futuna','WAF'),('Yemen','YE','Yemen','YEM'),('Zambia','ZM','Central','CEN'),('Zambia','ZM','Eastern','EAS'),('Zambia','ZM','Lusaka','LUS'),('Zambia','ZM','Southern','SOU'),('Zambia','ZM','Unknown','UNK'),('Zambia','ZM','Western','WES'),('Zimbabwe','ZW','Harare','HAR'),('Zimbabwe','ZW','Manicaland','MNL'),('Zimbabwe','ZW','Mashonaland East','MSE'),('Zimbabwe','ZW','Mashonaland West','MSW'),('Zimbabwe','ZW','Masvingo','MVG'),('Zimbabwe','ZW','Matabeleland North','MBN'),('Zimbabwe','ZW','Matabeleland South','MBS'),('Zimbabwe','ZW','Midlands','MID'),('Zimbabwe','ZW','Unknown','UNK');

--
-- Table structure for table `aqb_advanced_search_form_properties`
--

CREATE TABLE `aqb_advanced_search_form_properties` (
  `FieldID` int(11) NOT NULL DEFAULT '0',
  `Control` enum('default','select_box','select_multiple','checkbox_set') DEFAULT 'default',
  `ShowEmptyValue` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`FieldID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aqb_advanced_search_form_properties`
--

INSERT INTO `aqb_advanced_search_form_properties` VALUES (83,'default',1);

--
-- Table structure for table `bx_ads_category`
--

CREATE TABLE `bx_ads_category` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(64) NOT NULL DEFAULT '',
  `CEntryUri` varchar(64) NOT NULL DEFAULT '',
  `Description` varchar(128) DEFAULT NULL,
  `CustomFieldName1` varchar(50) DEFAULT NULL,
  `CustomFieldName2` varchar(50) DEFAULT NULL,
  `Unit1` varchar(8) NOT NULL DEFAULT '$',
  `Unit2` varchar(8) NOT NULL,
  `Picture` varchar(255) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `CEntryUri` (`CEntryUri`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_ads_category`
--

INSERT INTO `bx_ads_category` VALUES (9,'Free / Recycling','For-Sale','Free / Recycling','','','','','shopping-cart');

--
-- Table structure for table `bx_ads_category_subs`
--

CREATE TABLE `bx_ads_category_subs` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `IDClassified` int(11) unsigned DEFAULT NULL,
  `NameSub` varchar(128) NOT NULL DEFAULT '',
  `SEntryUri` varchar(128) NOT NULL DEFAULT '',
  `Description` varchar(150) DEFAULT 'No description',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `SEntryUri` (`SEntryUri`),
  KEY `IDClassified` (`IDClassified`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_ads_category_subs`
--

INSERT INTO `bx_ads_category_subs` VALUES (4,2,'positions and openings','positions-and-openings','positions and openings desc'),(5,2,'instruments for sale','instruments-for-sale','instruments for sale desc'),(6,2,'instruments wanted','instruments-wanted','instruments wanted desc'),(7,3,'activities','activities','activities desc'),(8,3,'artists','artists','artists desc'),(9,3,'childcare','childcare','childcare desc'),(10,4,'apartments / housing','apartments-housing','apartments / housing description'),(11,4,'real estate for sale','real-estate-for-sale','real estate for sale description'),(12,4,'roommates','roommates','roommates description'),(38,1,'accounting / finance','accounting-finance','accounting / finance desc'),(36,5,'automotive','automotive','automotive desc'),(43,1,'education / nonprofit sec','education-nonprofit-sec','education / nonprofit sector desc'),(47,1,'government / legal','government-legal','government/legal desc'),(84,1,'programming / web design','programming-web-design','programming / web design desc'),(54,1,'other','other','other desc'),(55,4,'temporary vacation rental','temporary-vacation-rental','temporary vacation rentals desc'),(56,4,'office / commercial','office-commercial','office / commercial  desc'),(58,5,'financial','financial','financial'),(60,5,'labor / move','labor-move','labor/move desc'),(61,5,'legal','legal','legal desc'),(62,5,'educational','educational','educational desc'),(64,7,'acting','acting','acting desc'),(65,7,'dance','dance','dance desc'),(83,7,'musicians','musicians','musicians desc'),(67,7,'modeling','modeling','modeling desc'),(68,7,'reality shows','reality-shows','reality shows  desc'),(69,8,'men seeking women','men-seeking-women','men seeking women desc'),(70,8,'women seeking men','women-seeking-men','women seeking men desc'),(71,8,'women seeking women','women-seeking-women','women seeking women desc'),(72,8,'men seeking men','men-seeking-men','men seeking men desc'),(73,8,'missed connections','missed-connections','missed connections desc'),(74,9,'barter','barter','barter desc'),(77,9,'clothing','clothing','clothing desc'),(78,9,'collectibles','collectibles','collectibles desc'),(79,9,'miscellaneous','miscellaneous','miscellaneous desc'),(80,10,'autos / trucks','autos-trucks','autos / trucks desc'),(81,10,'motorcycles','motorcycles','motorcycles desc'),(82,10,'auto parts','auto-parts','auto parts desc');

--
-- Table structure for table `bx_ads_cmts`
--

CREATE TABLE `bx_ads_cmts` (
  `cmt_id` int(11) NOT NULL AUTO_INCREMENT,
  `cmt_parent_id` int(11) NOT NULL DEFAULT '0',
  `cmt_object_id` int(11) NOT NULL DEFAULT '0',
  `cmt_author_id` int(10) unsigned NOT NULL DEFAULT '0',
  `cmt_text` text NOT NULL,
  `cmt_mood` tinyint(4) NOT NULL DEFAULT '0',
  `cmt_rate` int(11) NOT NULL DEFAULT '0',
  `cmt_rate_count` int(11) NOT NULL DEFAULT '0',
  `cmt_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cmt_replies` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cmt_id`),
  KEY `cmt_object_id` (`cmt_object_id`,`cmt_parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_ads_cmts`
--


--
-- Table structure for table `bx_ads_main`
--

CREATE TABLE `bx_ads_main` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `IDProfile` int(11) unsigned NOT NULL DEFAULT '0',
  `IDClassifiedsSubs` int(11) unsigned NOT NULL DEFAULT '0',
  `DateTime` int(10) DEFAULT NULL,
  `Subject` varchar(50) NOT NULL DEFAULT '',
  `EntryUri` varchar(255) NOT NULL DEFAULT '',
  `Message` text NOT NULL,
  `Status` enum('new','active','inactive') NOT NULL DEFAULT 'new',
  `CustomFieldValue1` varchar(50) DEFAULT NULL,
  `CustomFieldValue2` varchar(50) DEFAULT NULL,
  `LifeTime` int(3) NOT NULL DEFAULT '30',
  `Media` varchar(50) DEFAULT NULL,
  `Tags` text NOT NULL,
  `Country` varchar(2) DEFAULT NULL,
  `City` varchar(128) DEFAULT NULL,
  `Featured` int(1) NOT NULL DEFAULT '0',
  `Views` int(11) NOT NULL,
  `Rate` float NOT NULL,
  `RateCount` int(11) NOT NULL,
  `CommentsCount` int(11) NOT NULL,
  `AllowView` int(11) NOT NULL,
  `AllowRate` int(11) NOT NULL,
  `AllowComment` int(11) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `EntryUri` (`EntryUri`),
  KEY `IDProfile` (`IDProfile`),
  KEY `IDClassifiedsSubs` (`IDClassifiedsSubs`),
  FULLTEXT KEY `ftMain` (`Subject`,`Tags`,`Message`,`City`),
  FULLTEXT KEY `ftTags` (`Tags`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_ads_main`
--

INSERT INTO `bx_ads_main` VALUES (4,3,79,1476406365,'baby crib','baby-crib','<p>3 year old baby crib, good as new! White with sides that go up and down</p>','active','0','0',30,NULL,'','US','01002',0,5,0,0,0,0,0,0),(7,3,74,1546720198,'Bike','Bike','<p>24\" bike needs work</p>','active','0','0',5,NULL,'','US','Amherst, MA 01002',0,1,0,0,0,5,5,5);

--
-- Table structure for table `bx_ads_main_media`
--

CREATE TABLE `bx_ads_main_media` (
  `MediaID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `MediaProfileID` int(11) unsigned NOT NULL DEFAULT '0',
  `MediaType` enum('photo','other') NOT NULL DEFAULT 'photo',
  `MediaFile` varchar(50) NOT NULL DEFAULT '',
  `MediaDate` int(10) DEFAULT NULL,
  PRIMARY KEY (`MediaID`),
  KEY `med_prof_id` (`MediaProfileID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_ads_main_media`
--


--
-- Table structure for table `bx_ads_rating`
--

CREATE TABLE `bx_ads_rating` (
  `ads_id` int(12) NOT NULL DEFAULT '0',
  `ads_rating_count` int(11) NOT NULL DEFAULT '0',
  `ads_rating_sum` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `med_id` (`ads_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_ads_rating`
--

INSERT INTO `bx_ads_rating` VALUES (6,1,5);

--
-- Table structure for table `bx_ads_views_track`
--

CREATE TABLE `bx_ads_views_track` (
  `id` int(10) unsigned NOT NULL,
  `viewer` int(10) unsigned NOT NULL,
  `ip` int(10) unsigned NOT NULL,
  `ts` int(10) unsigned NOT NULL,
  KEY `id` (`id`,`viewer`,`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_ads_views_track`
--

INSERT INTO `bx_ads_views_track` VALUES (4,3,2923395480,1479249373),(4,12,851164926,1482419474),(7,3,2923395480,1546720206);

--
-- Table structure for table `bx_ads_voting_track`
--

CREATE TABLE `bx_ads_voting_track` (
  `ads_id` int(12) NOT NULL DEFAULT '0',
  `ads_ip` varchar(20) DEFAULT NULL,
  `ads_date` datetime DEFAULT NULL,
  KEY `med_ip` (`ads_ip`,`ads_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_ads_voting_track`
--

INSERT INTO `bx_ads_voting_track` VALUES (6,'50.187.190.254','2017-01-04 12:37:29');

--
-- Table structure for table `bx_arl_comments_bak`
--

CREATE TABLE `bx_arl_comments_bak` (
  `cmt_id` int(11) NOT NULL AUTO_INCREMENT,
  `cmt_parent_id` int(11) NOT NULL DEFAULT '0',
  `cmt_object_id` int(11) NOT NULL DEFAULT '0',
  `cmt_author_id` int(10) unsigned NOT NULL DEFAULT '0',
  `cmt_text` text NOT NULL,
  `cmt_mood` tinyint(4) NOT NULL DEFAULT '0',
  `cmt_rate` int(11) NOT NULL DEFAULT '0',
  `cmt_rate_count` int(11) NOT NULL DEFAULT '0',
  `cmt_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cmt_replies` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cmt_id`),
  KEY `cmt_object_id` (`cmt_object_id`,`cmt_parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_arl_comments_bak`
--


--
-- Table structure for table `bx_arl_comments_track_bak`
--

CREATE TABLE `bx_arl_comments_track_bak` (
  `cmt_system_id` int(11) NOT NULL DEFAULT '0',
  `cmt_id` int(11) NOT NULL DEFAULT '0',
  `cmt_rate` tinyint(4) NOT NULL DEFAULT '0',
  `cmt_rate_author_id` int(10) unsigned NOT NULL DEFAULT '0',
  `cmt_rate_author_nip` int(11) unsigned NOT NULL DEFAULT '0',
  `cmt_rate_ts` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cmt_system_id`,`cmt_id`,`cmt_rate_author_nip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_arl_comments_track_bak`
--


--
-- Table structure for table `bx_arl_entries`
--

CREATE TABLE `bx_arl_entries` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `author_id` int(11) unsigned NOT NULL DEFAULT '0',
  `caption` varchar(64) NOT NULL DEFAULT '',
  `snippet` text NOT NULL,
  `content` text NOT NULL,
  `when` int(11) NOT NULL DEFAULT '0',
  `uri` varchar(64) NOT NULL DEFAULT '',
  `tags` varchar(255) NOT NULL DEFAULT '',
  `categories` varchar(255) NOT NULL DEFAULT '',
  `comment` tinyint(4) NOT NULL DEFAULT '0',
  `vote` tinyint(4) NOT NULL DEFAULT '0',
  `date` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `featured` tinyint(4) NOT NULL DEFAULT '0',
  `rate` int(11) NOT NULL DEFAULT '0',
  `rate_count` int(11) NOT NULL DEFAULT '0',
  `view_count` int(11) NOT NULL DEFAULT '0',
  `cmts_count` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uri` (`uri`),
  FULLTEXT KEY `search_group` (`caption`,`content`,`tags`,`categories`),
  FULLTEXT KEY `search_caption` (`caption`),
  FULLTEXT KEY `search_content` (`content`),
  FULLTEXT KEY `search_tags` (`tags`),
  FULLTEXT KEY `search_categories` (`categories`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_arl_entries`
--


--
-- Table structure for table `bx_arl_entries_bak`
--

CREATE TABLE `bx_arl_entries_bak` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `author_id` int(11) unsigned NOT NULL DEFAULT '0',
  `caption` varchar(64) NOT NULL DEFAULT '',
  `snippet` text NOT NULL,
  `content` text NOT NULL,
  `when` int(11) NOT NULL DEFAULT '0',
  `uri` varchar(64) NOT NULL DEFAULT '',
  `tags` varchar(255) NOT NULL DEFAULT '',
  `categories` varchar(255) NOT NULL DEFAULT '',
  `comment` tinyint(4) NOT NULL DEFAULT '0',
  `vote` tinyint(4) NOT NULL DEFAULT '0',
  `date` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `featured` tinyint(4) NOT NULL DEFAULT '0',
  `rate` int(11) NOT NULL DEFAULT '0',
  `rate_count` int(11) NOT NULL DEFAULT '0',
  `view_count` int(11) NOT NULL DEFAULT '0',
  `cmts_count` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uri` (`uri`),
  FULLTEXT KEY `search_group` (`caption`,`content`,`tags`,`categories`),
  FULLTEXT KEY `search_caption` (`caption`),
  FULLTEXT KEY `search_content` (`content`),
  FULLTEXT KEY `search_tags` (`tags`),
  FULLTEXT KEY `search_categories` (`categories`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_arl_entries_bak`
--


--
-- Table structure for table `bx_arl_views_track_bak`
--

CREATE TABLE `bx_arl_views_track_bak` (
  `id` int(10) unsigned NOT NULL,
  `viewer` int(10) unsigned NOT NULL,
  `ip` int(10) unsigned NOT NULL,
  `ts` int(10) unsigned NOT NULL,
  KEY `id` (`id`,`viewer`,`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_arl_views_track_bak`
--


--
-- Table structure for table `bx_arl_voting_bak`
--

CREATE TABLE `bx_arl_voting_bak` (
  `articles_id` bigint(8) NOT NULL DEFAULT '0',
  `articles_rating_count` int(11) NOT NULL DEFAULT '0',
  `articles_rating_sum` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `articles_id` (`articles_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_arl_voting_bak`
--


--
-- Table structure for table `bx_arl_voting_track_bak`
--

CREATE TABLE `bx_arl_voting_track_bak` (
  `articles_id` bigint(8) NOT NULL DEFAULT '0',
  `articles_ip` varchar(20) DEFAULT NULL,
  `articles_date` datetime DEFAULT NULL,
  KEY `articles_ip` (`articles_ip`,`articles_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_arl_voting_track_bak`
--


--
-- Table structure for table `bx_avatar_images`
--

CREATE TABLE `bx_avatar_images` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `author_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_avatar_images`
--


--
-- Table structure for table `bx_events_admins`
--

CREATE TABLE `bx_events_admins` (
  `id_entry` int(10) unsigned NOT NULL,
  `id_profile` int(10) unsigned NOT NULL,
  `when` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_entry`,`id_profile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_admins`
--


--
-- Table structure for table `bx_events_cmts`
--

CREATE TABLE `bx_events_cmts` (
  `cmt_id` int(11) NOT NULL AUTO_INCREMENT,
  `cmt_parent_id` int(11) NOT NULL DEFAULT '0',
  `cmt_object_id` int(12) NOT NULL DEFAULT '0',
  `cmt_author_id` int(10) unsigned NOT NULL DEFAULT '0',
  `cmt_text` text NOT NULL,
  `cmt_mood` tinyint(4) NOT NULL DEFAULT '0',
  `cmt_rate` int(11) NOT NULL DEFAULT '0',
  `cmt_rate_count` int(11) NOT NULL DEFAULT '0',
  `cmt_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cmt_replies` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cmt_id`),
  KEY `cmt_object_id` (`cmt_object_id`,`cmt_parent_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_cmts`
--

INSERT INTO `bx_events_cmts` VALUES (5,0,7,24,'heeeeelllpppp',0,0,0,'2016-10-14 14:09:02',1),(6,5,7,27,'i may be too late, but if there is more to do then i will do it. otherwise, i will buy it and eat it. and CELEBRATE it and YOU.',0,0,0,'2016-10-27 23:08:09',0);

--
-- Table structure for table `bx_events_cmts_track`
--

CREATE TABLE `bx_events_cmts_track` (
  `cmt_system_id` int(11) NOT NULL DEFAULT '0',
  `cmt_id` int(11) NOT NULL DEFAULT '0',
  `cmt_rate` tinyint(4) NOT NULL DEFAULT '0',
  `cmt_rate_author_id` int(10) unsigned NOT NULL DEFAULT '0',
  `cmt_rate_author_nip` int(11) unsigned NOT NULL DEFAULT '0',
  `cmt_rate_ts` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cmt_system_id`,`cmt_id`,`cmt_rate_author_nip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_cmts_track`
--


--
-- Table structure for table `bx_events_files`
--

CREATE TABLE `bx_events_files` (
  `entry_id` int(10) unsigned NOT NULL,
  `media_id` int(10) unsigned NOT NULL,
  UNIQUE KEY `entry_id` (`entry_id`,`media_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_files`
--


--
-- Table structure for table `bx_events_forum`
--

CREATE TABLE `bx_events_forum` (
  `forum_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `forum_uri` varchar(255) NOT NULL DEFAULT '',
  `cat_id` int(11) NOT NULL DEFAULT '0',
  `forum_title` varchar(255) DEFAULT NULL,
  `forum_desc` varchar(255) NOT NULL DEFAULT '',
  `forum_posts` int(11) NOT NULL DEFAULT '0',
  `forum_topics` int(11) NOT NULL DEFAULT '0',
  `forum_last` int(11) NOT NULL DEFAULT '0',
  `forum_type` enum('public','private') NOT NULL DEFAULT 'public',
  `forum_order` int(11) NOT NULL DEFAULT '0',
  `entry_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`forum_id`),
  KEY `cat_id` (`cat_id`),
  KEY `forum_uri` (`forum_uri`),
  KEY `entry_id` (`entry_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum`
--

INSERT INTO `bx_events_forum` VALUES (1,'Test-Event',1,'Test Event','bethany',0,0,1428510258,'public',0,1),(2,'Mothers-Meeting-Test-Event',1,'Mothers Meeting Test Event','bethany',0,0,1433255749,'public',0,2),(4,'test',1,'test','DAvzeXKiGw',0,0,1466453623,'public',0,4),(5,'Test-2016-06-28',1,'Test','DAvzeXKiGw',0,0,1467139570,'public',0,5),(7,'Canning-my-ass-off',1,'Canning my ass off','zBQpjhpCG8',0,0,1476468494,'public',0,7),(8,'Walk-the-dogs',1,'Walk the dogs','zBQpjhpCG8',0,0,1478297954,'public',0,8),(9,'Dog-talk',1,'Dog talk','persister1',0,0,1479247487,'public',0,9);

--
-- Table structure for table `bx_events_forum_actions_log`
--

CREATE TABLE `bx_events_forum_actions_log` (
  `user_name` varchar(32) NOT NULL DEFAULT '',
  `id` int(11) NOT NULL DEFAULT '0',
  `action_name` varchar(32) NOT NULL DEFAULT '',
  `action_when` int(11) NOT NULL DEFAULT '0',
  KEY `action_when` (`action_when`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_actions_log`
--


--
-- Table structure for table `bx_events_forum_attachments`
--

CREATE TABLE `bx_events_forum_attachments` (
  `att_hash` char(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `post_id` int(10) unsigned NOT NULL,
  `att_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `att_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `att_when` int(11) NOT NULL,
  `att_size` int(11) NOT NULL,
  `att_downloads` int(11) NOT NULL,
  PRIMARY KEY (`att_hash`),
  KEY `post_id` (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_attachments`
--


--
-- Table structure for table `bx_events_forum_cat`
--

CREATE TABLE `bx_events_forum_cat` (
  `cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cat_uri` varchar(255) NOT NULL DEFAULT '',
  `cat_name` varchar(255) DEFAULT NULL,
  `cat_icon` varchar(32) NOT NULL DEFAULT '',
  `cat_order` float NOT NULL DEFAULT '0',
  `cat_expanded` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cat_id`),
  KEY `cat_order` (`cat_order`),
  KEY `cat_uri` (`cat_uri`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_cat`
--

INSERT INTO `bx_events_forum_cat` VALUES (1,'Events','Events','',64,0);

--
-- Table structure for table `bx_events_forum_flag`
--

CREATE TABLE `bx_events_forum_flag` (
  `user` varchar(32) NOT NULL DEFAULT '',
  `topic_id` int(11) NOT NULL DEFAULT '0',
  `when` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user`,`topic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_flag`
--


--
-- Table structure for table `bx_events_forum_post`
--

CREATE TABLE `bx_events_forum_post` (
  `post_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `topic_id` int(11) NOT NULL DEFAULT '0',
  `forum_id` int(11) NOT NULL DEFAULT '0',
  `user` varchar(32) NOT NULL DEFAULT '0',
  `post_text` mediumtext NOT NULL,
  `when` int(11) NOT NULL DEFAULT '0',
  `votes` int(11) NOT NULL DEFAULT '0',
  `reports` int(11) NOT NULL DEFAULT '0',
  `hidden` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`post_id`),
  KEY `topic_id` (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `user` (`user`),
  KEY `when` (`when`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_post`
--


--
-- Table structure for table `bx_events_forum_signatures`
--

CREATE TABLE `bx_events_forum_signatures` (
  `user` varchar(32) NOT NULL,
  `signature` varchar(255) NOT NULL,
  `when` int(11) NOT NULL,
  PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_signatures`
--


--
-- Table structure for table `bx_events_forum_topic`
--

CREATE TABLE `bx_events_forum_topic` (
  `topic_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `topic_uri` varchar(255) NOT NULL DEFAULT '',
  `forum_id` int(11) NOT NULL DEFAULT '0',
  `topic_title` varchar(255) NOT NULL DEFAULT '',
  `when` int(11) NOT NULL DEFAULT '0',
  `topic_posts` int(11) NOT NULL DEFAULT '0',
  `first_post_user` varchar(32) NOT NULL DEFAULT '0',
  `first_post_when` int(11) NOT NULL DEFAULT '0',
  `last_post_user` varchar(32) NOT NULL DEFAULT '',
  `last_post_when` int(11) NOT NULL DEFAULT '0',
  `topic_sticky` int(11) NOT NULL DEFAULT '0',
  `topic_locked` tinyint(4) NOT NULL DEFAULT '0',
  `topic_hidden` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `forum_id_2` (`forum_id`,`when`),
  KEY `topic_uri` (`topic_uri`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_topic`
--


--
-- Table structure for table `bx_events_forum_user`
--

CREATE TABLE `bx_events_forum_user` (
  `user_name` varchar(32) NOT NULL DEFAULT '',
  `user_pwd` varchar(32) NOT NULL DEFAULT '',
  `user_email` varchar(128) NOT NULL DEFAULT '',
  `user_join_date` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_name`),
  UNIQUE KEY `user_email` (`user_email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_user`
--


--
-- Table structure for table `bx_events_forum_user_activity`
--

CREATE TABLE `bx_events_forum_user_activity` (
  `user` varchar(32) NOT NULL DEFAULT '',
  `act_current` int(11) NOT NULL DEFAULT '0',
  `act_last` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_user_activity`
--


--
-- Table structure for table `bx_events_forum_user_stat`
--

CREATE TABLE `bx_events_forum_user_stat` (
  `user` varchar(32) NOT NULL DEFAULT '',
  `posts` int(11) NOT NULL DEFAULT '0',
  `user_last_post` int(11) NOT NULL DEFAULT '0',
  KEY `user` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_user_stat`
--


--
-- Table structure for table `bx_events_forum_vote`
--

CREATE TABLE `bx_events_forum_vote` (
  `user_name` varchar(32) NOT NULL DEFAULT '',
  `post_id` int(11) NOT NULL DEFAULT '0',
  `vote_when` int(11) NOT NULL DEFAULT '0',
  `vote_point` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_name`,`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_vote`
--


--
-- Table structure for table `bx_events_images`
--

CREATE TABLE `bx_events_images` (
  `entry_id` int(10) unsigned NOT NULL,
  `media_id` int(10) unsigned NOT NULL,
  UNIQUE KEY `entry_id` (`entry_id`,`media_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_images`
--

INSERT INTO `bx_events_images` VALUES (9,45);

--
-- Table structure for table `bx_events_main`
--

CREATE TABLE `bx_events_main` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Title` varchar(100) NOT NULL DEFAULT '',
  `EntryUri` varchar(255) NOT NULL,
  `Description` text NOT NULL,
  `Status` enum('approved','pending') NOT NULL DEFAULT 'approved',
  `Country` varchar(2) NOT NULL DEFAULT 'US',
  `City` varchar(50) NOT NULL DEFAULT '',
  `Place` varchar(100) NOT NULL DEFAULT '',
  `PrimPhoto` int(11) NOT NULL,
  `Date` int(11) NOT NULL,
  `EventStart` int(11) NOT NULL DEFAULT '0',
  `EventEnd` int(11) NOT NULL DEFAULT '0',
  `ResponsibleID` int(10) unsigned NOT NULL DEFAULT '0',
  `EventMembershipFilter` varchar(100) NOT NULL DEFAULT '',
  `Tags` varchar(255) NOT NULL DEFAULT '',
  `Categories` text NOT NULL,
  `Views` int(11) NOT NULL,
  `Rate` float NOT NULL,
  `RateCount` int(11) NOT NULL,
  `CommentsCount` int(11) NOT NULL,
  `FansCount` int(11) NOT NULL,
  `Featured` tinyint(4) NOT NULL,
  `allow_view_event_to` int(11) NOT NULL,
  `allow_view_participants_to` varchar(16) NOT NULL,
  `allow_comment_to` varchar(16) NOT NULL,
  `allow_rate_to` varchar(16) NOT NULL,
  `allow_join_to` int(11) NOT NULL,
  `allow_post_in_forum_to` varchar(16) NOT NULL,
  `allow_view_forum_to` varchar(16) NOT NULL,
  `JoinConfirmation` tinyint(4) NOT NULL DEFAULT '0',
  `allow_upload_photos_to` varchar(16) NOT NULL,
  `allow_upload_videos_to` varchar(16) NOT NULL,
  `allow_upload_sounds_to` varchar(16) NOT NULL,
  `allow_upload_files_to` varchar(16) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `EntryUri` (`EntryUri`),
  KEY `ResponsibleID` (`ResponsibleID`),
  KEY `EventStart` (`EventStart`),
  KEY `Date` (`Date`),
  FULLTEXT KEY `Title` (`Title`,`Description`,`City`,`Place`,`Tags`,`Categories`),
  FULLTEXT KEY `Tags` (`Tags`),
  FULLTEXT KEY `Categories` (`Categories`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_main`
--

INSERT INTO `bx_events_main` VALUES (9,'Dog talk','Dog-talk','<p>bla bla bla dogs</p>','approved','US','amherst, MA 01002','hobla',45,1479247486,1478968200,1478960760,3,'','','',1,5,1,0,0,0,3,'','4','',3,'','',0,'a','','',''),(8,'Walk the dogs','Walk-the-dogs','<p>Dog walking in the back field<img src=\"plugins/tinymce/plugins/emoticons/img/smiley-foot-in-mouth.gif\" alt=\"foot-in-mouth\" /></p>','approved','US','Amherst, MA 01002','Back Fields',0,1478297954,1478822400,1478908800,24,'','','',5,0,0,0,0,0,3,'','4','',3,'','',0,'a','','',''),(7,'Canning my ass off','Canning-my-ass-off','<p>help me get all the harvest into cans</p>','approved','US','Amherst, MA 01002','Greenhouse',0,1476468494,1476576000,1476748800,24,'','','',1,0,0,2,0,0,3,'','4','',3,'','',0,'a','','','');

--
-- Table structure for table `bx_events_participants`
--

CREATE TABLE `bx_events_participants` (
  `id_entry` int(10) unsigned NOT NULL,
  `id_profile` int(10) unsigned NOT NULL,
  `when` int(10) unsigned NOT NULL,
  `confirmed` tinyint(4) NOT NULL,
  PRIMARY KEY (`id_entry`,`id_profile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_participants`
--


--
-- Table structure for table `bx_events_rating`
--

CREATE TABLE `bx_events_rating` (
  `gal_id` int(10) unsigned NOT NULL DEFAULT '0',
  `gal_rating_count` int(11) NOT NULL DEFAULT '0',
  `gal_rating_sum` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `gal_id` (`gal_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_rating`
--

INSERT INTO `bx_events_rating` VALUES (9,1,5);

--
-- Table structure for table `bx_events_rating_track`
--

CREATE TABLE `bx_events_rating_track` (
  `gal_id` int(10) unsigned NOT NULL DEFAULT '0',
  `gal_ip` varchar(20) DEFAULT NULL,
  `gal_date` datetime DEFAULT NULL,
  KEY `gal_ip` (`gal_ip`,`gal_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_rating_track`
--

INSERT INTO `bx_events_rating_track` VALUES (9,'50.187.190.254','2016-11-30 20:15:27');

--
-- Table structure for table `bx_events_shoutbox`
--

CREATE TABLE `bx_events_shoutbox` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `HandlerID` int(11) NOT NULL,
  `OwnerID` int(11) NOT NULL,
  `Message` blob NOT NULL,
  `Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `IP` int(10) unsigned NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `IP` (`IP`),
  KEY `HandlerID` (`HandlerID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bx_events_shoutbox`
--


--
-- Table structure for table `bx_events_sounds`
--

CREATE TABLE `bx_events_sounds` (
  `entry_id` int(10) unsigned NOT NULL,
  `media_id` int(10) unsigned NOT NULL,
  UNIQUE KEY `entry_id` (`entry_id`,`media_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_sounds`
--


--
-- Table structure for table `bx_events_videos`
--

CREATE TABLE `bx_events_videos` (
  `entry_id` int(10) unsigned NOT NULL,
  `media_id` int(10) unsigned NOT NULL,
  UNIQUE KEY `entry_id` (`entry_id`,`media_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_videos`
--


--
-- Table structure for table `bx_events_views_track`
--

CREATE TABLE `bx_events_views_track` (
  `id` int(10) unsigned NOT NULL,
  `viewer` int(10) unsigned NOT NULL,
  `ip` int(10) unsigned NOT NULL,
  `ts` int(10) unsigned NOT NULL,
  KEY `id` (`id`,`viewer`,`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_views_track`
--

INSERT INTO `bx_events_views_track` VALUES (7,24,1229237105,1476468506),(8,12,851164926,1483042812),(9,12,1240338797,1495985530),(8,48,3635313828,1546985050),(8,56,299791275,1554486880),(8,96,1768994645,1586265383);

--
-- Table structure for table `bx_fdb_comments`
--

CREATE TABLE `bx_fdb_comments` (
  `cmt_id` int(11) NOT NULL AUTO_INCREMENT,
  `cmt_parent_id` int(11) NOT NULL DEFAULT '0',
  `cmt_object_id` int(11) NOT NULL DEFAULT '0',
  `cmt_author_id` int(10) unsigned NOT NULL DEFAULT '0',
  `cmt_text` text NOT NULL,
  `cmt_mood` tinyint(4) NOT NULL DEFAULT '0',
  `cmt_rate` int(11) NOT NULL DEFAULT '0',
  `cmt_rate_count` int(11) NOT NULL DEFAULT '0',
  `cmt_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cmt_replies` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cmt_id`),
  KEY `cmt_object_id` (`cmt_object_id`,`cmt_parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_fdb_comments`
--


--
-- Table structure for table `bx_fdb_comments_track`
--

CREATE TABLE `bx_fdb_comments_track` (
  `cmt_system_id` int(11) NOT NULL DEFAULT '0',
  `cmt_id` int(11) NOT NULL DEFAULT '0',
  `cmt_rate` tinyint(4) NOT NULL DEFAULT '0',
  `cmt_rate_author_id` int(10) unsigned NOT NULL DEFAULT '0',
  `cmt_rate_author_nip` int(11) unsigned NOT NULL DEFAULT '0',
  `cmt_rate_ts` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cmt_system_id`,`cmt_id`,`cmt_rate_author_nip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_fdb_comments_track`
--


--
-- Table structure for table `bx_fdb_entries`
--

CREATE TABLE `bx_fdb_entries` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `author_id` int(11) unsigned NOT NULL DEFAULT '0',
  `caption` varchar(64) NOT NULL DEFAULT '',
  `content` text NOT NULL,
  `uri` varchar(64) NOT NULL DEFAULT '',
  `tags` varchar(255) NOT NULL DEFAULT '',
  `allow_comment_to` int(11) NOT NULL DEFAULT '0',
  `allow_vote_to` int(11) NOT NULL DEFAULT '0',
  `date` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `rate` int(11) NOT NULL DEFAULT '0',
  `rate_count` int(11) NOT NULL DEFAULT '0',
  `cmts_count` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uri` (`uri`),
  FULLTEXT KEY `search_group` (`caption`,`content`,`tags`),
  FULLTEXT KEY `search_caption` (`caption`),
  FULLTEXT KEY `search_content` (`content`),
  FULLTEXT KEY `search_tags` (`tags`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_fdb_entries`
--


--
-- Table structure for table `bx_fdb_voting`
--

CREATE TABLE `bx_fdb_voting` (
  `fdb_id` bigint(8) NOT NULL DEFAULT '0',
  `fdb_rating_count` int(11) NOT NULL DEFAULT '0',
  `fdb_rating_sum` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `fdb_id` (`fdb_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_fdb_voting`
--


--
-- Table structure for table `bx_fdb_voting_track`
--

CREATE TABLE `bx_fdb_voting_track` (
  `fdb_id` bigint(8) NOT NULL DEFAULT '0',
  `fdb_ip` varchar(20) DEFAULT NULL,
  `fdb_date` datetime DEFAULT NULL,
  KEY `fdb_ip` (`fdb_ip`,`fdb_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_fdb_voting_track`
--


--
-- Table structure for table `bx_forum`
--

CREATE TABLE `bx_forum` (
  `forum_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `forum_uri` varchar(255) NOT NULL DEFAULT '',
  `cat_id` int(11) NOT NULL DEFAULT '0',
  `forum_title` varchar(255) DEFAULT NULL,
  `forum_desc` varchar(255) NOT NULL DEFAULT '',
  `forum_posts` int(11) NOT NULL DEFAULT '0',
  `forum_topics` int(11) NOT NULL DEFAULT '0',
  `forum_last` int(11) NOT NULL DEFAULT '0',
  `forum_type` enum('public','private') NOT NULL DEFAULT 'public',
  `forum_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`forum_id`),
  KEY `cat_id` (`cat_id`),
  KEY `forum_uri` (`forum_uri`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum`
--


--
-- Table structure for table `bx_forum_actions_log`
--

CREATE TABLE `bx_forum_actions_log` (
  `user_name` varchar(32) NOT NULL DEFAULT '',
  `id` int(11) NOT NULL DEFAULT '0',
  `action_name` varchar(32) NOT NULL DEFAULT '',
  `action_when` int(11) NOT NULL DEFAULT '0',
  KEY `action_when` (`action_when`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_actions_log`
--

INSERT INTO `bx_forum_actions_log` VALUES ('ericamlee',2,'hide post',1445808441),('ericamlee',2,'unhide post',1445808444);

--
-- Table structure for table `bx_forum_attachments`
--

CREATE TABLE `bx_forum_attachments` (
  `att_hash` char(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `post_id` int(10) unsigned NOT NULL,
  `att_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `att_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `att_when` int(11) NOT NULL,
  `att_size` int(11) NOT NULL,
  `att_downloads` int(11) NOT NULL,
  PRIMARY KEY (`att_hash`),
  KEY `post_id` (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_attachments`
--


--
-- Table structure for table `bx_forum_cat`
--

CREATE TABLE `bx_forum_cat` (
  `cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cat_uri` varchar(255) NOT NULL DEFAULT '',
  `cat_name` varchar(255) DEFAULT NULL,
  `cat_icon` varchar(32) NOT NULL DEFAULT '',
  `cat_order` float NOT NULL DEFAULT '0',
  `cat_expanded` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cat_id`),
  KEY `cat_order` (`cat_order`),
  KEY `cat_uri` (`cat_uri`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_cat`
--

INSERT INTO `bx_forum_cat` VALUES (1,'General','General','',2,0);

--
-- Table structure for table `bx_forum_flag`
--

CREATE TABLE `bx_forum_flag` (
  `user` varchar(32) NOT NULL DEFAULT '',
  `topic_id` int(11) NOT NULL DEFAULT '0',
  `when` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user`,`topic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_flag`
--


--
-- Table structure for table `bx_forum_post`
--

CREATE TABLE `bx_forum_post` (
  `post_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `topic_id` int(11) NOT NULL DEFAULT '0',
  `forum_id` int(11) NOT NULL DEFAULT '0',
  `user` varchar(32) NOT NULL DEFAULT '0',
  `post_text` mediumtext NOT NULL,
  `when` int(11) NOT NULL DEFAULT '0',
  `votes` int(11) NOT NULL DEFAULT '0',
  `reports` int(11) NOT NULL DEFAULT '0',
  `hidden` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`post_id`),
  KEY `topic_id` (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `user` (`user`),
  KEY `when` (`when`),
  FULLTEXT KEY `post_text` (`post_text`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_post`
--


--
-- Table structure for table `bx_forum_signatures`
--

CREATE TABLE `bx_forum_signatures` (
  `user` varchar(32) NOT NULL,
  `signature` varchar(255) NOT NULL,
  `when` int(11) NOT NULL,
  PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_signatures`
--


--
-- Table structure for table `bx_forum_topic`
--

CREATE TABLE `bx_forum_topic` (
  `topic_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `topic_uri` varchar(255) NOT NULL DEFAULT '',
  `forum_id` int(11) NOT NULL DEFAULT '0',
  `topic_title` varchar(255) NOT NULL DEFAULT '',
  `when` int(11) NOT NULL DEFAULT '0',
  `topic_posts` int(11) NOT NULL DEFAULT '0',
  `first_post_user` varchar(32) NOT NULL DEFAULT '0',
  `first_post_when` int(11) NOT NULL DEFAULT '0',
  `last_post_user` varchar(32) NOT NULL DEFAULT '',
  `last_post_when` int(11) NOT NULL DEFAULT '0',
  `topic_sticky` int(11) NOT NULL DEFAULT '0',
  `topic_locked` tinyint(4) NOT NULL DEFAULT '0',
  `topic_hidden` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `forum_id_2` (`forum_id`,`when`),
  KEY `topic_uri` (`topic_uri`),
  FULLTEXT KEY `topic_title` (`topic_title`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_topic`
--


--
-- Table structure for table `bx_forum_user`
--

CREATE TABLE `bx_forum_user` (
  `user_name` varchar(32) NOT NULL DEFAULT '',
  `user_pwd` varchar(32) NOT NULL DEFAULT '',
  `user_email` varchar(128) NOT NULL DEFAULT '',
  `user_join_date` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_name`),
  UNIQUE KEY `user_email` (`user_email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_user`
--


--
-- Table structure for table `bx_forum_user_activity`
--

CREATE TABLE `bx_forum_user_activity` (
  `user` varchar(32) NOT NULL DEFAULT '',
  `act_current` int(11) NOT NULL DEFAULT '0',
  `act_last` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_user_activity`
--

INSERT INTO `bx_forum_user_activity` VALUES ('test',1448465135,1447431602),('persister1',1447034484,0);

--
-- Table structure for table `bx_forum_user_stat`
--

CREATE TABLE `bx_forum_user_stat` (
  `user` varchar(32) NOT NULL DEFAULT '',
  `posts` int(11) NOT NULL DEFAULT '0',
  `user_last_post` int(11) NOT NULL DEFAULT '0',
  KEY `user` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_user_stat`
--


--
-- Table structure for table `bx_forum_vote`
--

CREATE TABLE `bx_forum_vote` (
  `user_name` varchar(32) NOT NULL DEFAULT '',
  `post_id` int(11) NOT NULL DEFAULT '0',
  `vote_when` int(11) NOT NULL DEFAULT '0',
  `vote_point` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_name`,`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_vote`
--


--
-- Table structure for table `bx_groups_admins`
--

CREATE TABLE `bx_groups_admins` (
  `id_entry` int(10) unsigned NOT NULL,
  `id_profile` int(10) unsigned NOT NULL,
  `when` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_entry`,`id_profile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_admins`
--


--
-- Table structure for table `bx_groups_cmts`
--

CREATE TABLE `bx_groups_cmts` (
  `cmt_id` int(11) NOT NULL AUTO_INCREMENT,
  `cmt_parent_id` int(11) NOT NULL DEFAULT '0',
  `cmt_object_id` int(12) NOT NULL DEFAULT '0',
  `cmt_author_id` int(10) unsigned NOT NULL DEFAULT '0',
  `cmt_text` text NOT NULL,
  `cmt_mood` tinyint(4) NOT NULL DEFAULT '0',
  `cmt_rate` int(11) NOT NULL DEFAULT '0',
  `cmt_rate_count` int(11) NOT NULL DEFAULT '0',
  `cmt_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cmt_replies` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cmt_id`),
  KEY `cmt_object_id` (`cmt_object_id`,`cmt_parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_cmts`
--


--
-- Table structure for table `bx_groups_cmts_track`
--

CREATE TABLE `bx_groups_cmts_track` (
  `cmt_system_id` int(11) NOT NULL DEFAULT '0',
  `cmt_id` int(11) NOT NULL DEFAULT '0',
  `cmt_rate` tinyint(4) NOT NULL DEFAULT '0',
  `cmt_rate_author_id` int(10) unsigned NOT NULL DEFAULT '0',
  `cmt_rate_author_nip` int(11) unsigned NOT NULL DEFAULT '0',
  `cmt_rate_ts` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cmt_system_id`,`cmt_id`,`cmt_rate_author_nip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_cmts_track`
--


--
-- Table structure for table `bx_groups_fans`
--

CREATE TABLE `bx_groups_fans` (
  `id_entry` int(10) unsigned NOT NULL,
  `id_profile` int(10) unsigned NOT NULL,
  `when` int(10) unsigned NOT NULL,
  `confirmed` tinyint(4) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_entry`,`id_profile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_fans`
--

INSERT INTO `bx_groups_fans` VALUES (7,3,1479247581,1),(11,48,1546985181,0);

--
-- Table structure for table `bx_groups_files`
--

CREATE TABLE `bx_groups_files` (
  `entry_id` int(10) unsigned NOT NULL,
  `media_id` int(11) NOT NULL,
  UNIQUE KEY `entry_id` (`entry_id`,`media_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_files`
--


--
-- Table structure for table `bx_groups_forum`
--

CREATE TABLE `bx_groups_forum` (
  `forum_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `forum_uri` varchar(255) NOT NULL DEFAULT '',
  `cat_id` int(11) NOT NULL DEFAULT '0',
  `forum_title` varchar(255) DEFAULT NULL,
  `forum_desc` varchar(255) NOT NULL DEFAULT '',
  `forum_posts` int(11) NOT NULL DEFAULT '0',
  `forum_topics` int(11) NOT NULL DEFAULT '0',
  `forum_last` int(11) NOT NULL DEFAULT '0',
  `forum_type` enum('public','private') NOT NULL DEFAULT 'public',
  `forum_order` int(11) NOT NULL DEFAULT '0',
  `entry_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`forum_id`),
  KEY `cat_id` (`cat_id`),
  KEY `forum_uri` (`forum_uri`),
  KEY `entry_id` (`entry_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum`
--

INSERT INTO `bx_groups_forum` VALUES (6,'Meditate-with-Moms',1,'Meditate with Moms','9Jukj2dZdQ',0,0,1476785074,'public',0,6),(2,'Test',1,'Test','DAvzeXKiGw',0,0,1467139891,'public',0,2),(5,'Bitchy-over-50',1,'Bitchy over 50','zBQpjhpCG8',0,0,1476468366,'public',0,5),(7,'Dog-walkers-unite',1,'Dog walkers unite','zBQpjhpCG8',0,0,1478298037,'public',0,7),(11,'Women-Against-Sexual-Abuse',1,'Women Against Sexual Abuse','persister1',0,0,1546720603,'public',0,11),(12,'Lol',1,'Lol','kvpS2VVBwY',0,0,1575614866,'public',0,12);

--
-- Table structure for table `bx_groups_forum_actions_log`
--

CREATE TABLE `bx_groups_forum_actions_log` (
  `user_name` varchar(32) NOT NULL DEFAULT '',
  `id` int(11) NOT NULL DEFAULT '0',
  `action_name` varchar(32) NOT NULL DEFAULT '',
  `action_when` int(11) NOT NULL DEFAULT '0',
  KEY `action_when` (`action_when`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum_actions_log`
--


--
-- Table structure for table `bx_groups_forum_attachments`
--

CREATE TABLE `bx_groups_forum_attachments` (
  `att_hash` char(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `post_id` int(10) unsigned NOT NULL,
  `att_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `att_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `att_when` int(11) NOT NULL,
  `att_size` int(11) NOT NULL,
  `att_downloads` int(11) NOT NULL,
  PRIMARY KEY (`att_hash`),
  KEY `post_id` (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum_attachments`
--


--
-- Table structure for table `bx_groups_forum_cat`
--

CREATE TABLE `bx_groups_forum_cat` (
  `cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cat_uri` varchar(255) NOT NULL DEFAULT '',
  `cat_name` varchar(255) DEFAULT NULL,
  `cat_icon` varchar(32) NOT NULL DEFAULT '',
  `cat_order` float NOT NULL DEFAULT '0',
  `cat_expanded` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cat_id`),
  KEY `cat_order` (`cat_order`),
  KEY `cat_uri` (`cat_uri`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum_cat`
--

INSERT INTO `bx_groups_forum_cat` VALUES (1,'Groups','Groups','',64,0);

--
-- Table structure for table `bx_groups_forum_flag`
--

CREATE TABLE `bx_groups_forum_flag` (
  `user` varchar(32) NOT NULL DEFAULT '',
  `topic_id` int(11) NOT NULL DEFAULT '0',
  `when` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user`,`topic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum_flag`
--


--
-- Table structure for table `bx_groups_forum_post`
--

CREATE TABLE `bx_groups_forum_post` (
  `post_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `topic_id` int(11) NOT NULL DEFAULT '0',
  `forum_id` int(11) NOT NULL DEFAULT '0',
  `user` varchar(32) NOT NULL DEFAULT '0',
  `post_text` mediumtext NOT NULL,
  `when` int(11) NOT NULL DEFAULT '0',
  `votes` int(11) NOT NULL DEFAULT '0',
  `reports` int(11) NOT NULL DEFAULT '0',
  `hidden` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`post_id`),
  KEY `topic_id` (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `user` (`user`),
  KEY `when` (`when`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum_post`
--


--
-- Table structure for table `bx_groups_forum_signatures`
--

CREATE TABLE `bx_groups_forum_signatures` (
  `user` varchar(32) NOT NULL,
  `signature` varchar(255) NOT NULL,
  `when` int(11) NOT NULL,
  PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum_signatures`
--


--
-- Table structure for table `bx_groups_forum_topic`
--

CREATE TABLE `bx_groups_forum_topic` (
  `topic_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `topic_uri` varchar(255) NOT NULL DEFAULT '',
  `forum_id` int(11) NOT NULL DEFAULT '0',
  `topic_title` varchar(255) NOT NULL DEFAULT '',
  `when` int(11) NOT NULL DEFAULT '0',
  `topic_posts` int(11) NOT NULL DEFAULT '0',
  `first_post_user` varchar(32) NOT NULL DEFAULT '0',
  `first_post_when` int(11) NOT NULL DEFAULT '0',
  `last_post_user` varchar(32) NOT NULL DEFAULT '',
  `last_post_when` int(11) NOT NULL DEFAULT '0',
  `topic_sticky` int(11) NOT NULL DEFAULT '0',
  `topic_locked` tinyint(4) NOT NULL DEFAULT '0',
  `topic_hidden` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `forum_id_2` (`forum_id`,`when`),
  KEY `topic_uri` (`topic_uri`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum_topic`
--


--
-- Table structure for table `bx_groups_forum_user`
--

CREATE TABLE `bx_groups_forum_user` (
  `user_name` varchar(32) NOT NULL DEFAULT '',
  `user_pwd` varchar(32) NOT NULL DEFAULT '',
  `user_email` varchar(128) NOT NULL DEFAULT '',
  `user_join_date` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_name`),
  UNIQUE KEY `user_email` (`user_email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum_user`
--


--
-- Table structure for table `bx_groups_forum_user_activity`
--

CREATE TABLE `bx_groups_forum_user_activity` (
  `user` varchar(32) NOT NULL DEFAULT '',
  `act_current` int(11) NOT NULL DEFAULT '0',
  `act_last` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum_user_activity`
--

INSERT INTO `bx_groups_forum_user_activity` VALUES ('ericamlee',1471532133,1448464449);

--
-- Table structure for table `bx_groups_forum_user_stat`
--

CREATE TABLE `bx_groups_forum_user_stat` (
  `user` varchar(32) NOT NULL DEFAULT '',
  `posts` int(11) NOT NULL DEFAULT '0',
  `user_last_post` int(11) NOT NULL DEFAULT '0',
  KEY `user` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum_user_stat`
--


--
-- Table structure for table `bx_groups_forum_vote`
--

CREATE TABLE `bx_groups_forum_vote` (
  `user_name` varchar(32) NOT NULL DEFAULT '',
  `post_id` int(11) NOT NULL DEFAULT '0',
  `vote_when` int(11) NOT NULL DEFAULT '0',
  `vote_point` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_name`,`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
