Skip to content

Instantly share code, notes, and snippets.

@lornajane
Created April 4, 2016 16:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save lornajane/c05cf1db435979ec7b2647b686aafd98 to your computer and use it in GitHub Desktop.
Save lornajane/c05cf1db435979ec7b2647b686aafd98 to your computer and use it in GitHub Desktop.
Material to accompany JSON data type examples
-- MySQL dump 10.13 Distrib 5.6.28, for debian-linux-gnu (x86_64)
--
-- Host: 127.0.0.1 Database: demo
-- ------------------------------------------------------
-- Server version 5.7.11
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `people`
--
DROP TABLE IF EXISTS `people`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `people` (
`id` int(11) NOT NULL,
`guid` char(36) DEFAULT NULL,
`is_active` tinyint(1) DEFAULT '0',
`name` varchar(255) NOT NULL,
`address` varchar(1000) DEFAULT NULL,
`about` text,
`location` geometry DEFAULT NULL,
`tags` json DEFAULT NULL,
`friends` json DEFAULT NULL,
`profile` json DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `people`
--
LOCK TABLES `people` WRITE;
/*!40000 ALTER TABLE `people` DISABLE KEYS */;
INSERT INTO `people` VALUES (0,'636ca299-4a63-42a3-9fa3-f6f62aa3a3ac',1,'Howard Ortega','662 River Street, Dale, Palau, 9092','Ipsum deserunt nostrud deserunt commodo sint quis eu voluptate. Cillum dolore cillum nulla voluptate consectetur magna. Id cupidatat pariatur excepteur ipsum sunt adipisicing cupidatat proident minim ullamco nulla ex. Mollit nisi id reprehenderit ad officia irure occaecat cupidatat reprehenderit laboris sint. Cillum nisi in incididunt ea reprehenderit ut reprehenderit enim anim officia. Esse officia irure deserunt anim consectetur fugiat deserunt nisi.\r\n','\0\0\0\0\0\0\0U ƒ‡gIÀ<O<g‹yeÀ','[\"officia\", \"et\", \"anim\", \"dolore\", \"ut\", \"duis\", \"quis\"]','[{\"name\": \"Leola Marshall\"}, {\"name\": \"Mitchell Foley\"}, {\"name\": \"Parks Smith\"}, {\"name\": \"Dolly Tanner\"}]','{\"email\": \"Shaw@example.com\", \"salary\": 52000, \"twitter\": \"@estvelit\", \"direct_reports\": 7}'),(1,'d0ccf8f8-7a20-45df-b24a-45fe19161a8f',0,'Miller Gamble','416 Beard Street, Dawn, Alabama, 522','Non exercitation excepteur aliquip mollit eiusmod consectetur amet nulla. Ut aliquip velit commodo ea amet. Non ullamco sit nisi ullamco. Dolor eiusmod eiusmod labore et officia ad cupidatat cillum sunt.\r\n','\0\0\0\0\0\0\0,‚ÿ­dKAÀ o –êÄ]@','[\"et\", \"officia\", \"culpa\", \"excepteur\", \"ullamco\", \"exercitation\", \"in\"]','[{\"name\": \"Strickland Carpenter\"}, {\"name\": \"York Lynch\"}, {\"name\": \"Alberta Riggs\"}]','{\"salary\": 52000, \"join_date\": \"2013-05-13T10:02:22 -01:00\"}'),(2,'885a44fb-9a90-4989-9e12-8cf6457cfc21',0,'Harriett Leon','675 Jefferson Street, Yukon, West Virginia, 561','Id eiusmod deserunt duis do consectetur occaecat anim do nostrud veniam est tempor sunt fugiat. Dolor amet cillum voluptate qui ullamco labore dolore minim non non nulla ullamco ipsum. Ut velit et deserunt deserunt. Id proident sunt cillum tempor dolor deserunt culpa Lorem ea excepteur sit. Voluptate non quis cupidatat irure labore laborum ea. Ea et anim quis voluptate aute sint nulla et eiusmod nisi aliquip nisi.\r\n','\0\0\0\0\0\0\0lâuýMÀÙYLQ_@','[\"laboris\", \"consectetur\", \"mollit\", \"dolore\", \"aute\", \"consectetur\", \"adipisicing\"]','[{\"name\": \"Krista Bailey\"}, {\"name\": \"Dunn Sellers\"}]','{\"email\": \"Melton@example.com\", \"driver\": true, \"salary\": 63000, \"twitter\": \"@commodoproident\"}'),(3,'8f5eaf59-aa3a-4c72-bca0-100dcdd51165',1,'Claudia Durham','824 Oakland Place, Hobucken, Northern Mariana Islands, 9498','Adipisicing do proident qui laboris nostrud ipsum amet aliquip exercitation voluptate non enim sit. Proident nulla cupidatat voluptate ullamco in laboris esse. Cillum sint eu aliqua mollit aute magna reprehenderit ullamco ex id cillum laborum voluptate excepteur. Laboris voluptate nulla est commodo excepteur exercitation veniam cupidatat ea ad Lorem proident mollit.\r\n','\0\0\0\0\0\0\0„ò>Ž$À©¤N@‡WÀ','[\"ad\", \"veniam\", \"sunt\", \"eiusmod\", \"pariatur\", \"veniam\", \"reprehenderit\"]','[{\"name\": \"Campos Conway\"}, {\"name\": \"Mary Gay\"}, {\"name\": \"Hewitt Sloan\"}, {\"name\": \"Fuentes Russell\"}]','{\"email\": \"Sykes@example.com\", \"salary\": 50000, \"first_aid\": true, \"vegetarian\": false, \"direct_reports\": 12}'),(4,'37a13b91-0c4e-48de-a28f-0dd752c140c7',1,'Cox Huff','843 Bedford Avenue, Jugtown, South Carolina, 6925','Quis qui elit commodo dolore sit proident eu consectetur non minim adipisicing enim est voluptate. Dolore magna reprehenderit quis deserunt elit do cupidatat ea magna voluptate elit deserunt. Dolor anim Lorem elit cupidatat nulla enim quis reprehenderit amet ipsum. Nostrud sint irure eu non labore veniam laboris. Ea veniam sunt duis laborum. Aute reprehenderit aute Lorem pariatur ut ex ut. Dolor cillum id exercitation non labore velit dolore ex aliquip aute adipisicing magna irure labore.\r\n','\0\0\0\0\0\0\0œnÙ!þ¹\"Ày>êÍùe@','[\"reprehenderit\", \"Lorem\", \"adipisicing\", \"ipsum\", \"cupidatat\", \"deserunt\", \"consectetur\"]','[{\"name\": \"Henderson Robles\"}, {\"name\": \"Marshall Perkins\"}, {\"name\": \"May Webster\"}]','{\"salary\": 61000, \"twitter\": \"@mollitconsequat\"}'),(5,'9dfab815-36bf-40fb-824b-d0376a1ca94e',0,'Tameka Rice','354 Argyle Road, Mahtowa, Maine, 4371','Nostrud incididunt cillum culpa mollit ut est ex et dolor nostrud sit est laborum. Est est elit aliquip laboris reprehenderit nostrud cillum. Nostrud cillum sit velit consequat exercitation amet Lorem irure laboris ea laboris. Occaecat laborum occaecat Lorem culpa duis adipisicing.\r\n','\0\0\0\0\0\0\0ï9°!ÜU@¿˜-Y;AÀ','[\"proident\", \"ullamco\", \"incididunt\", \"proident\", \"incididunt\", \"enim\", \"voluptate\"]','[{\"name\": \"Lee Tyler\"}, {\"name\": \"Edna Vang\"}, {\"name\": \"Knowles Camacho\"}]','{\"driver\": true, \"salary\": 68000, \"join_date\": \"2014-08-10T04:44:12 -01:00\"}'),(6,'8f6d85c6-7a09-435e-a510-7b507485b3a3',0,'Richmond Nielsen','406 Desmond Court, Whipholt, South Dakota, 7969','Labore ipsum ipsum id sit consectetur id officia reprehenderit. Duis duis irure officia sunt irure deserunt consequat nisi. Occaecat nisi adipisicing voluptate eiusmod dolor do eiusmod occaecat. Cupidatat duis ipsum amet duis. Duis culpa sunt eu ipsum ullamco esse. Do excepteur voluptate eu velit magna aliquip amet enim tempor est labore. Mollit aute cillum enim labore minim anim consectetur occaecat amet eiusmod.\r\n','\0\0\0\0\0\0\0yæå°û®CÀî=\\rÜíVÀ','[\"tempor\", \"non\", \"nostrud\", \"aliqua\", \"aute\", \"aliquip\", \"quis\"]','[{\"name\": \"Ramona Hendrix\"}, {\"name\": \"Velasquez Patel\"}]','{\"email\": \"Hancock@example.com\", \"salary\": 36000, \"direct_reports\": 8}'),(7,'414d3826-bf89-43fb-935d-ac3648a9f28c',1,'Joy Hill','301 Sackett Street, Jeff, Pennsylvania, 6489','Ullamco culpa consectetur sit Lorem est non enim magna sit aute mollit fugiat mollit. Cupidatat laborum dolore dolore voluptate id ex laborum duis mollit non. Non occaecat incididunt fugiat eiusmod dolor sint. In sit irure aute proident eu sint laborum. Ea ad minim eu amet labore deserunt excepteur duis esse officia consectetur sit esse.\r\n','\0\0\0\0\0\0\0C\0pì§I@)x\n¹«VÀ','[\"mollit\", \"aliqua\", \"amet\", \"in\", \"exercitation\", \"cupidatat\", \"quis\"]','[{\"name\": \"Long Reeves\"}, {\"name\": \"Mills Weeks\"}, {\"name\": \"Margery Anthony\"}]','{\"email\": \"Jannie@example.com\", \"salary\": 31000, \"twitter\": \"@occaecatest\", \"join_date\": \"2014-12-10T06:53:49 -00:00\", \"vegetarian\": true}'),(8,'61bb2298-2d63-4cf2-a1f0-a4323b278756',0,'Lowe Knapp','372 Osborn Street, Neahkahnie, Oregon, 962','Est laborum adipisicing sint adipisicing irure eu. Duis non commodo velit nisi excepteur esse tempor magna. Enim elit sint dolor officia tempor. Excepteur incididunt irure do occaecat et nulla. Elit et proident sunt aliqua do ea fugiat eiusmod ut sint nostrud minim irure. Ullamco irure eu velit excepteur do ex proident voluptate Lorem anim cupidatat voluptate culpa.\r\n','\0\0\0\0\0\0\0ê\"…²ðé4Àën‡½a@','[\"ullamco\", \"amet\", \"occaecat\", \"esse\", \"occaecat\", \"laboris\", \"aliquip\"]','[{\"name\": \"Duran Soto\"}, {\"name\": \"Hurley Barber\"}, {\"name\": \"Callahan Weiss\"}, {\"name\": \"Katelyn Summers\"}]','{\"salary\": 31000}'),(9,'a190d261-2c0c-4575-81fa-ff915db097ef',1,'Daniels Booker','781 Brooklyn Road, Blue, Massachusetts, 9015','Ea dolor est sint eiusmod consequat voluptate. Eiusmod adipisicing enim ullamco sit deserunt quis amet est enim voluptate. Eiusmod aliqua ullamco cupidatat commodo id ea eiusmod nostrud quis ex aliquip. Cupidatat magna reprehenderit dolor ut incididunt cillum amet pariatur culpa. Enim officia incididunt est sit veniam pariatur amet. Nisi occaecat occaecat excepteur sunt labore velit pariatur ad.\r\n','\0\0\0\0\0\0\0\"\08öì\"À0ðÜ{ÐQÀ','[\"nisi\", \"ullamco\", \"tempor\", \"qui\", \"minim\", \"ipsum\", \"laboris\"]','[{\"name\": \"Fischer Lancaster\"}, {\"name\": \"Lauri Marsh\"}, {\"name\": \"Case Blackburn\"}, {\"name\": \"Cotton Welch\"}]','{\"salary\": 44000, \"join_date\": \"2014-03-25T02:08:27 -00:00\"}'),(10,'c31d994a-b561-493c-929f-afade8423d1b',1,'Virgie Bauer','792 McKibbin Street, Fannett, Connecticut, 6103','Lorem id quis do anim sit velit. Do id reprehenderit consectetur cupidatat officia nisi aute laboris laboris nostrud adipisicing ullamco elit fugiat. Consectetur esse culpa ullamco do occaecat ad sunt. Officia mollit cupidatat deserunt nostrud ipsum ea exercitation aute. Ipsum exercitation proident fugiat sit ad dolore ipsum sint exercitation mollit pariatur.\r\n','\0\0\0\0\0\0\0Ÿ<,Ԛ¨QÀy?n¿|Ob@','[\"consectetur\", \"incididunt\", \"labore\", \"consequat\", \"irure\", \"anim\", \"consectetur\"]','[{\"name\": \"Abigail Wynn\"}, {\"name\": \"Hayden Hatfield\"}]','{\"salary\": 23000, \"twitter\": \"@proidentproident\", \"join_date\": \"2014-09-06T02:40:48 -01:00\"}'),(11,'df4abe4b-701f-4d8f-98de-fb8f0a5b00f3',0,'Kristy Pope','910 Bevy Court, Fredericktown, Nevada, 6292','Sunt do fugiat nisi incididunt tempor cupidatat consectetur aliqua consequat labore culpa aliqua. Elit officia adipisicing fugiat proident amet minim fugiat consequat nostrud. Pariatur officia ex minim aute laborum enim minim occaecat ullamco labore.\r\n','\0\0\0\0\0\0\0C9Ñ®B7QÀŠ‘%söQÀ','[\"veniam\", \"labore\", \"ipsum\", \"excepteur\", \"sit\", \"eu\", \"irure\"]','[{\"name\": \"Rena Williamson\"}, {\"name\": \"Deena Maynard\"}, {\"name\": \"Liza Fox\"}]','{\"driver\": false, \"salary\": 53000, \"twitter\": \"@eadeserunt\", \"direct_reports\": 3}'),(12,'9adf8a7a-62f6-4cfe-aac7-d97f03fdf3a6',1,'Lynch Farmer','185 Ford Street, Boomer, Illinois, 3143','Eiusmod aliquip cillum minim dolor laborum consequat consequat id est laboris culpa. Cupidatat consequat id laborum enim sunt tempor laboris cupidatat commodo velit exercitation. Ad dolore aute duis do ad. Nulla exercitation consequat do excepteur ad commodo anim cupidatat enim qui qui. Magna duis consectetur proident aute et.\r\n','\0\0\0\0\0\0\0છçP@eÆÛJ/:b@','[\"qui\", \"aute\", \"laborum\", \"ut\", \"duis\", \"anim\", \"elit\"]','[{\"name\": \"Carly Henry\"}, {\"name\": \"Kristin Henderson\"}, {\"name\": \"Opal Delgado\"}]','{\"email\": \"Justice@example.com\", \"join_date\": \"2015-12-05T09:24:42 -00:00\"}'),(13,'97754b56-5617-4fae-9040-5b341d4308b3',0,'Schwartz Bowers','549 Debevoise Avenue, Riegelwood, Hawaii, 7773','Magna non sit occaecat officia nostrud esse. Sunt id pariatur aliquip ipsum minim laboris proident. Adipisicing reprehenderit consectetur quis et Lorem eiusmod Lorem laborum est do. Consequat ad est aliquip dolore consectetur Lorem. Eu anim irure aliquip elit cupidatat elit nostrud. Lorem non adipisicing ea ad aute minim. Aliqua dolore quis ut reprehenderit mollit exercitation ut ut ad nisi.\r\n','\0\0\0\0\0\0\0,ôÁ26`CÀ3TÅTúº`@','[\"ut\", \"in\", \"qui\", \"consequat\", \"culpa\", \"exercitation\", \"ipsum\"]','[{\"name\": \"Kathrine Beach\"}, {\"name\": \"Jeannie Morin\"}]','{\"salary\": 66000, \"twitter\": \"@incididuntaute\", \"direct_reports\": 10}'),(14,'adccd67e-39ad-4211-b84a-e348ae580ae0',0,'Salinas Maxwell','147 Clara Street, Ezel, Georgia, 9901','Sunt sit magna est laboris irure sit amet. Incididunt nostrud cillum reprehenderit in incididunt ad. Occaecat dolor velit laboris reprehenderit proident non.\r\n','\0\0\0\0\0\0\0tE)!Xµ\ZÀãüM(dÀ','[\"dolor\", \"duis\", \"laborum\", \"in\", \"cillum\", \"ipsum\", \"ut\"]','[{\"name\": \"Arnold Irwin\"}, {\"name\": \"Kimberley Elliott\"}, {\"name\": \"Colette Wade\"}]','[]'),(15,'506b58ad-6274-46e0-aa3d-24458223edcd',0,'Swanson Cochran','650 Cornelia Street, Dexter, Virginia, 7641','Excepteur laboris veniam id fugiat veniam ea laboris laboris quis est proident veniam elit veniam. Sunt magna deserunt ut laboris elit aliquip sint dolor fugiat dolor Lorem. Qui labore minim quis excepteur qui proident et sit proident amet consequat non veniam. Consequat laboris adipisicing anim exercitation adipisicing enim aliqua aliqua velit mollit laboris. Qui cupidatat aute dolor cillum in duis laboris. Deserunt enim sunt mollit nisi amet magna aliquip consectetur veniam. Eu labore amet adipisicing ullamco ex consectetur.\r\n','\0\0\0\0\0\0\02èLZ@òΡ Um7@','[\"ex\", \"duis\", \"et\", \"consectetur\", \"consectetur\", \"ea\", \"est\"]','[{\"name\": \"Casandra Schroeder\"}, {\"name\": \"Mullen Martin\"}]','{\"email\": \"Jennie@example.com\", \"salary\": 38000, \"join_date\": \"2014-12-04T05:52:18 -00:00\"}'),(16,'5611a117-7820-4b2a-9f5a-3d514953d7ae',1,'Howe Holland','249 Myrtle Avenue, Lemoyne, Iowa, 212','Fugiat est commodo veniam ullamco elit non cillum incididunt consectetur et quis ea Lorem. Eiusmod consequat ad aliquip aute nisi. Incididunt deserunt nostrud aliqua enim reprehenderit aliquip nulla deserunt et minim velit. Laboris officia excepteur fugiat consequat laboris ut.\r\n','\0\0\0\0\0\0\0¼“OmtVÀV}®¶âŸaÀ','[\"irure\", \"cillum\", \"ullamco\", \"proident\", \"magna\", \"id\", \"consequat\"]','[{\"name\": \"Farley Slater\"}, {\"name\": \"Klein Henson\"}]','{\"salary\": 39000, \"twitter\": \"@laborenostrud\", \"join_date\": \"2013-04-02T03:22:31 -01:00\", \"vegetarian\": true}'),(17,'79653c3b-6af8-480d-8c54-045b0d5ab690',1,'Jimmie Workman','587 Riverdale Avenue, Nadine, Wyoming, 5901','Sint id fugiat mollit enim incididunt. Ullamco laboris elit excepteur laborum adipisicing labore non. Eiusmod fugiat labore in cupidatat.\r\n','\0\0\0\0\0\0\0”¢•NÀÜšt[Â-À','[\"mollit\", \"elit\", \"officia\", \"qui\", \"tempor\", \"excepteur\", \"est\"]','[{\"name\": \"Elaine Matthews\"}, {\"name\": \"Kimberly Doyle\"}, {\"name\": \"Louisa Calderon\"}]','{\"email\": \"Sandra@example.com\", \"salary\": 47000, \"twitter\": \"@adipisicingest\"}'),(18,'c8654ac2-9864-4c5a-a1bf-f1c7ae568f9b',0,'Lenora Walters','607 Harbor Lane, Hillsboro, Nebraska, 3908','Exercitation ea veniam ad anim excepteur nostrud sit laboris. Deserunt est ullamco et anim mollit ex ad aliquip mollit id officia Lorem anim exercitation. Sint aliquip adipisicing culpa cupidatat ea in id. In enim consectetur consequat et reprehenderit anim ea eiusmod sunt. Enim tempor sunt veniam labore.\r\n','\0\0\0\0\0\0\0&áBÁÍÀŒó7¡e;@','[\"consectetur\", \"labore\", \"dolore\", \"ullamco\", \"adipisicing\", \"voluptate\", \"ex\"]','[{\"name\": \"Olivia Stevenson\"}, {\"name\": \"Shelton Velazquez\"}, {\"name\": \"Katie Brady\"}, {\"name\": \"Roberts Murphy\"}]','{\"salary\": 23000, \"twitter\": \"@ullamconisi\"}'),(19,'64f31332-cf59-4532-8710-a24ce8a2d3b2',0,'Fitzpatrick Hinton','523 Montague Street, Roosevelt, Oklahoma, 5406','Exercitation ullamco fugiat proident tempor incididunt. Et esse id reprehenderit commodo tempor nostrud do sint dolore nostrud deserunt sunt ullamco aliqua. Culpa est ex excepteur ad qui quis nulla. Mollit eu culpa ea sunt consequat sunt voluptate culpa anim reprehenderit anim eiusmod. Deserunt qui laboris non sit dolor elit. Tempor ad ea excepteur do aliquip tempor occaecat exercitation dolore mollit ullamco enim ad.\r\n','\0\0\0\0\0\0\0‰ð/‚Æì@dxìg±€0À','[\"esse\", \"nostrud\", \"proident\", \"laborum\", \"Lorem\", \"minim\", \"sit\"]','[{\"name\": \"Letitia Nichols\"}, {\"name\": \"Fisher Dawson\"}, {\"name\": \"Fuller Franklin\"}]','{\"salary\": 58000, \"direct_reports\": 7}'),(20,'5f1bd510-fecf-47bf-be17-f8eabd7b52dd',1,'Leach Wilcox','110 Bancroft Place, Dellview, District Of Columbia, 886','Duis tempor esse sint id deserunt ex nostrud ullamco mollit non elit. Id amet culpa quis adipisicing culpa. Esse officia adipisicing consectetur nisi commodo magna ipsum ullamco labore in dolore minim nulla. Id cillum nostrud aliqua id minim. Cupidatat eiusmod sint amet sint anim excepteur tempor.\r\n','\0\0\0\0\0\0\0SxÐìºlPÀþðó߃=À','[\"dolor\", \"deserunt\", \"officia\", \"officia\", \"aute\", \"esse\", \"reprehenderit\"]','[{\"name\": \"Davenport Gross\"}, {\"name\": \"Raymond Austin\"}, {\"name\": \"Scott Hardy\"}, {\"name\": \"Acosta Hartman\"}]','{\"email\": \"Madeleine@example.com\", \"driver\": false, \"twitter\": \"@laboristempor\", \"join_date\": \"2014-03-02T03:31:36 -00:00\"}'),(21,'12811faa-974c-4405-9ca8-382f4201d12a',0,'Sweet Allen','441 Middagh Street, Hoehne, Alaska, 1820','Irure ad esse excepteur Lorem ipsum excepteur consequat mollit. Nulla fugiat aliquip dolor velit anim. Culpa culpa est ipsum ea adipisicing culpa quis. Laborum sunt ex nisi amet culpa. Ad elit aliqua adipisicing sint magna amet cupidatat. Officia elit exercitation reprehenderit consectetur veniam.\r\n','\0\0\0\0\0\0\0·´\Z÷XÀX‘ÑIA@','[\"qui\", \"ex\", \"commodo\", \"incididunt\", \"duis\", \"ea\", \"pariatur\"]','[{\"name\": \"Farmer Malone\"}, {\"name\": \"Lacey Dickerson\"}, {\"name\": \"Summers Meyers\"}]','{\"driver\": true, \"salary\": 79000, \"join_date\": \"2016-03-02T10:08:17 -00:00\", \"direct_reports\": 3}'),(22,'f8410f49-c1db-4ca8-9db1-35811b7a228d',1,'Burton Hubbard','868 Crosby Avenue, Zarephath, Florida, 9510','Ex ut consequat et laborum est irure magna duis. Sint tempor nulla sunt cupidatat labore in excepteur. Aliqua sit enim fugiat magna. Laborum deserunt id cupidatat velit labore proident non culpa cillum voluptate sit amet enim aute. Sunt tempor mollit ut cupidatat.\r\n','\0\0\0\0\0\0\0M,ðÝIÀÈBt©>@','[\"nostrud\", \"minim\", \"labore\", \"exercitation\", \"tempor\", \"culpa\", \"labore\"]','[{\"name\": \"Crane James\"}, {\"name\": \"Walton Mcclure\"}, {\"name\": \"Wallace Diaz\"}, {\"name\": \"Sonia Chaney\"}]','{\"driver\": true, \"salary\": 55000, \"twitter\": \"@estlabore\"}'),(23,'f47a357f-2492-4084-9987-04362940e752',1,'Teresa Berg','753 Jaffray Street, Sparkill, Tennessee, 8671','Irure sit duis adipisicing occaecat incididunt quis tempor commodo reprehenderit. Ipsum mollit non dolore duis cillum ipsum fugiat id mollit eiusmod. Culpa proident dolor sit exercitation do aute velit nulla velit duis. Amet ipsum occaecat voluptate sunt eiusmod non labore. Laboris proident aliqua cupidatat sint. Pariatur minim nisi qui aute eu ad ipsum.\r\n','\0\0\0\0\0\0\0¡ò¯å•ó7ÀK®bñÀ','[\"minim\", \"anim\", \"officia\", \"ea\", \"voluptate\", \"officia\", \"deserunt\"]','[{\"name\": \"Lee Gates\"}, {\"name\": \"Wheeler Santos\"}]','{\"email\": \"Baxter@example.com\", \"salary\": 52000, \"twitter\": \"@inullamco\", \"join_date\": \"2015-10-05T01:52:07 -01:00\", \"direct_reports\": 1}'),(24,'ce7a42e3-d525-4fcc-b6eb-e39795e3048f',0,'Conrad Gilmore','119 Dumont Avenue, Abrams, Kentucky, 5583','Elit cupidatat deserunt aliqua nulla sunt ea cupidatat duis. Duis elit pariatur cupidatat officia fugiat est culpa ipsum eiusmod irure veniam. Proident incididunt duis ea laboris pariatur. Aute enim consequat ad sint sunt. Anim anim dolore magna proident mollit magna. Voluptate incididunt deserunt qui eu esse nisi veniam cupidatat consequat pariatur officia qui. Sint adipisicing sit officia sit sit fugiat esse eu nostrud consectetur occaecat ut laborum officia.\r\n','\0\0\0\0\0\0\0±Š72Œ<@p—ýºS…b@','[\"ex\", \"id\", \"fugiat\", \"cupidatat\", \"mollit\", \"cillum\", \"occaecat\"]','[{\"name\": \"Moon May\"}, {\"name\": \"Barnett Sanders\"}, {\"name\": \"Bernadine Dean\"}]','{\"driver\": false, \"salary\": 49000, \"join_date\": \"2014-09-30T08:53:37 -01:00\", \"direct_reports\": 3}'),(25,'0c6bcdff-17a6-4a53-8216-b36db3ec9b9b',1,'Joseph Stanley','416 Thatford Avenue, Caron, Arkansas, 907','Lorem nisi ex laborum in pariatur esse consectetur sunt laborum sint reprehenderit ullamco do. Nulla consectetur sit eu nulla dolore labore deserunt quis esse consectetur voluptate eu ullamco. Sunt ut pariatur ex nostrud nisi culpa irure est ex consectetur. Anim culpa reprehenderit sit dolore excepteur do adipisicing reprehenderit culpa dolor amet pariatur laboris. Sint eiusmod elit id quis nulla. Proident laboris Lorem duis reprehenderit.\r\n','\0\0\0\0\0\0\0,ñ€²)÷.@í,z§„e@','[\"id\", \"anim\", \"officia\", \"reprehenderit\", \"proident\", \"consectetur\", \"in\"]','[{\"name\": \"Shannon Byers\"}, {\"name\": \"Vazquez Solomon\"}, {\"name\": \"Levy Guy\"}]','{\"email\": \"Imogene@example.com\", \"driver\": false, \"salary\": 32000, \"direct_reports\": 3}'),(26,'a3b31244-7084-4f29-b9b6-2746884e3e6f',0,'Quinn Ballard','402 Havens Place, Robinette, Texas, 9323','Pariatur velit sit proident dolor commodo aliquip aliqua fugiat commodo. Culpa minim consequat tempor voluptate non commodo eiusmod culpa in anim eiusmod aliqua. Dolor cupidatat aliqua eu ea nostrud id nostrud eu. Enim elit occaecat adipisicing tempor ea duis ipsum ea veniam amet minim duis nisi consequat. Excepteur excepteur aliqua fugiat cillum ut reprehenderit tempor ad voluptate magna ad. Veniam aliquip fugiat magna ipsum deserunt sunt quis occaecat sunt dolor pariatur. Laboris voluptate nostrud commodo ullamco qui proident ipsum.\r\n','\0\0\0\0\0\0\0ðMÓg8F@Í#0ð<4@','[\"laboris\", \"incididunt\", \"aliqua\", \"nisi\", \"duis\", \"ipsum\", \"sit\"]','[{\"name\": \"Lori Yang\"}, {\"name\": \"Knapp Ramos\"}]','{\"email\": \"Murphy@example.com\", \"salary\": 60000, \"twitter\": \"@noneu\", \"join_date\": \"2015-05-01T12:49:09 -01:00\"}'),(27,'2f9d62da-8a68-44fe-bdb9-c6c64e54ee90',0,'Verna Alvarez','925 Autumn Avenue, Hall, North Dakota, 2808','Cupidatat ad veniam anim cillum cupidatat non est commodo duis commodo pariatur consequat sunt. Id deserunt consectetur eu eu. Labore laboris Lorem enim excepteur deserunt deserunt quis cillum ullamco.\r\n','\0\0\0\0\0\0\0ú—¤2ÅÂ?Ww,¶I¶\\À','[\"dolore\", \"ullamco\", \"velit\", \"ut\", \"commodo\", \"exercitation\", \"veniam\"]','[{\"name\": \"Yang Roberson\"}, {\"name\": \"Carlene Pennington\"}]','{\"email\": \"Sutton@example.com\", \"salary\": 61000, \"direct_reports\": 7}'),(28,'03036989-df44-4eac-a38c-74876a9b1de2',1,'Calderon Garcia','202 Granite Street, Iberia, Marshall Islands, 5003','Minim dolor ut occaecat id ea non minim adipisicing laborum consequat eu. Exercitation voluptate minim ullamco cupidatat in. Laboris nulla cillum reprehenderit officia consectetur.\r\n','\0\0\0\0\0\0\0À_̖¬Ê!@TÆ¿Ï8cÀ','[\"voluptate\", \"eu\", \"veniam\", \"fugiat\", \"culpa\", \"quis\", \"cupidatat\"]','[{\"name\": \"Floyd Owen\"}, {\"name\": \"Penelope Mccall\"}]','{\"salary\": 74000, \"direct_reports\": 9}'),(29,'a17df0f3-8c4b-433f-b71b-7590ce73ace6',0,'Antoinette Daniels','920 Greenwood Avenue, Westboro, North Carolina, 1694','Esse eiusmod aliqua est ex pariatur amet aute incididunt excepteur irure eiusmod ex anim. Nostrud nostrud est pariatur laboris. Do eu dolore ea deserunt in exercitation officia consequat minim. Ad fugiat nisi labore irure magna non ea irure aute anim mollit adipisicing. Commodo consectetur ullamco in mollit eu.\r\n','\0\0\0\0\0\0\0tѐñ(u9À©Åä»E@','[\"consectetur\", \"ullamco\", \"laborum\", \"velit\", \"proident\", \"in\", \"irure\"]','[{\"name\": \"Abby Gardner\"}, {\"name\": \"Brianna Bolton\"}, {\"name\": \"Leta Keith\"}, {\"name\": \"Bray Miller\"}]','{\"twitter\": \"@nullafugiat\", \"join_date\": \"2013-11-06T02:08:18 -00:00\"}'),(30,'fcbbdbcd-946c-4d5b-a404-669145f20a05',0,'Carrillo Michael','845 Keen Court, Chilton, Kansas, 277','Eu aliquip duis do qui laboris sit pariatur velit et ipsum nostrud et. Sint eu sint magna magna. Tempor laborum incididunt laboris deserunt non officia pariatur culpa. Nulla tempor proident id velit enim reprehenderit quis incididunt.\r\n','\0\0\0\0\0\0\0ë\0ˆ»zrTÀâ?Ý@w×?','[\"est\", \"pariatur\", \"voluptate\", \"ut\", \"nostrud\", \"laborum\", \"non\"]','[{\"name\": \"Bryan Kirkland\"}, {\"name\": \"Vivian Head\"}, {\"name\": \"Buckner Pate\"}]','{\"email\": \"Zelma@example.com\", \"join_date\": \"2014-02-28T10:41:59 -00:00\", \"direct_reports\": 10}'),(31,'3b290e8a-d189-4f8e-970d-d048765b3956',0,'Williams Booth','600 Elizabeth Place, Utting, New York, 1308','Voluptate fugiat eu cillum aute ad adipisicing dolore consectetur. Eu tempor aliquip est veniam commodo do aute excepteur ut cupidatat quis eiusmod ipsum anim. Dolor cupidatat officia aute ad est occaecat aute aliquip aliqua sit ea. Anim veniam irure Lorem sunt velit nostrud ut sit sunt voluptate.\r\n','\0\0\0\0\0\0\0‘¹2¨6ø+@^ÛÛ-Id@','[\"incididunt\", \"pariatur\", \"cillum\", \"eu\", \"cupidatat\", \"excepteur\", \"amet\"]','[{\"name\": \"Minerva Savage\"}, {\"name\": \"Perkins Francis\"}]','{\"email\": \"Ethel@example.com\", \"salary\": 36000, \"twitter\": \"@occaecatnostrud\", \"join_date\": \"2014-06-01T05:37:32 -01:00\", \"direct_reports\": 4}'),(32,'05c67904-bc66-45fc-8001-f80944556c82',1,'Mable Ayala','512 Beach Place, Takilma, Idaho, 6619','Pariatur commodo esse adipisicing voluptate reprehenderit minim do voluptate nostrud id irure amet do. Laboris fugiat esse duis esse cupidatat non deserunt est fugiat id. Eu culpa non tempor Lorem non proident nisi aliqua consectetur exercitation nulla deserunt duis amet. Sint irure ad mollit consequat occaecat ad pariatur.\r\n','\0\0\0\0\0\0\0êìdp”Ð2ÀX}wù_À','[\"non\", \"minim\", \"cupidatat\", \"laborum\", \"nisi\", \"esse\", \"nostrud\"]','[{\"name\": \"Koch Knowles\"}, {\"name\": \"Clarice Wolfe\"}]','{\"driver\": false, \"salary\": 65000, \"join_date\": \"2015-11-04T08:01:33 -00:00\", \"direct_reports\": 5}'),(33,'8d8cbad4-004c-4942-be67-1ee8f90ce53a',0,'Miriam Mcgowan','923 Schermerhorn Street, Floriston, Louisiana, 2478','Lorem labore cupidatat dolor deserunt est ullamco sit dolor esse. Et enim quis ut nostrud magna mollit commodo velit labore proident. Veniam eu veniam et consequat consequat ipsum cillum cupidatat. Dolore in eu aliqua dolore eiusmod dolor.\r\n','\0\0\0\0\0\0\0Õz¿ÑŽ‹K@ \Z/Ý$ÃR@','[\"anim\", \"magna\", \"nisi\", \"exercitation\", \"ea\", \"adipisicing\", \"dolore\"]','[{\"name\": \"Peters Davenport\"}, {\"name\": \"April Andrews\"}]','{\"email\": \"Jenkins@example.com\", \"driver\": false, \"salary\": 39000, \"twitter\": \"@nonmagna\", \"direct_reports\": 10}'),(34,'7dc96d62-d347-4c8c-b409-1122737f98ac',1,'Buchanan Salazar','376 Bayard Street, Shrewsbury, Federated States Of Micronesia, 3115','Labore velit qui fugiat laborum officia. Amet ut sint proident elit sint dolor ea. Consectetur quis dolore cupidatat laboris adipisicing pariatur deserunt reprehenderit qui. Cillum non deserunt irure laborum in magna ea.\r\n','\0\0\0\0\0\0\0=¶eÀY3Àµßډ’%_@','[\"esse\", \"nulla\", \"in\", \"velit\", \"in\", \"eiusmod\", \"non\"]','[{\"name\": \"Hoover Barry\"}, {\"name\": \"Brown Fitzpatrick\"}]','{\"driver\": true, \"vegetarian\": true}'),(35,'a4ff6b62-bbdc-458d-bc87-5f55c36e8dcb',1,'Austin Yates','631 Eagle Street, Summertown, Puerto Rico, 501','Cupidatat velit dolore mollit velit exercitation nulla id qui magna elit. Sit consequat nulla mollit quis occaecat veniam dolore Lorem cupidatat ea consectetur commodo magna. Duis ut adipisicing culpa commodo aliquip sint velit ad irure magna ullamco ipsum. Mollit magna do ea ullamco pariatur id Lorem do dolor elit laborum eiusmod non id. Elit ad excepteur Lorem qui nisi exercitation est est. Do enim pariatur ut qui qui incididunt enim enim aute ea do.\r\n','\0\0\0\0\0\0\0Zö$°9MK@\rùg†ºc@','[\"id\", \"ullamco\", \"Lorem\", \"aliquip\", \"aute\", \"proident\", \"laboris\"]','[{\"name\": \"Owens Stewart\"}, {\"name\": \"Kramer Chambers\"}]','{\"salary\": 59000, \"twitter\": \"@Loremdo\", \"join_date\": \"2016-03-28T03:02:10 -01:00\", \"direct_reports\": 12}'),(36,'5b92c3f3-49d2-428c-afe8-312599edd4ee',0,'Barton Mejia','431 Cedar Street, Dotsero, Michigan, 6164','Sit commodo proident sunt nisi proident est irure sunt aliqua aliquip sit. Anim tempor ad occaecat esse sunt esse incididunt anim mollit nisi deserunt deserunt ullamco laboris. Incididunt minim aliquip sint dolor laboris incididunt adipisicing officia aliquip consectetur Lorem minim eiusmod. Deserunt officia sit qui officia Lorem quis qui in ut. Officia quis Lorem laborum sunt. Veniam magna adipisicing voluptate officia incididunt ad sit nisi irure cillum est dolore.\r\n','\0\0\0\0\0\0\0@Þ«V&S@ƒ¢y\0‹?]@','[\"adipisicing\", \"reprehenderit\", \"est\", \"officia\", \"aute\", \"qui\", \"nulla\"]','[{\"name\": \"Walls Stanton\"}, {\"name\": \"Fernandez Merrill\"}]','{\"twitter\": \"@etmagna\"}'),(37,'8ac94aa8-b422-4931-8f79-028e020292b0',1,'Beasley Mccarty','196 Irvington Place, Kirk, Vermont, 7452','Fugiat aute adipisicing non Lorem culpa nulla reprehenderit. Non nisi irure exercitation voluptate aute amet mollit nostrud ex exercitation anim in ad irure. Veniam dolor ad ullamco do qui id. Aliquip ea aute reprehenderit cillum. Nulla ad consequat adipisicing culpa nostrud Lorem ullamco sit aliqua consequat. Veniam excepteur laborum duis velit aliquip magna fugiat sunt velit Lorem elit mollit adipisicing ut. Duis officia irure mollit nostrud ex reprehenderit adipisicing dolor.\r\n','\0\0\0\0\0\0\0Ìa÷Ã\rÀw¿\nðݚ>@','[\"ullamco\", \"officia\", \"minim\", \"Lorem\", \"laboris\", \"culpa\", \"et\"]','[{\"name\": \"Dominguez Pena\"}, {\"name\": \"Claudine Hurst\"}]','{\"email\": \"Nguyen@example.com\", \"salary\": 45000, \"twitter\": \"@consecteturenim\", \"vegetarian\": true, \"direct_reports\": 12}'),(38,'5cbdf010-e50c-4ccd-98ec-077dd0bf84a9',0,'Aguilar Hawkins','279 Willow Street, Frierson, New Mexico, 2071','Non excepteur esse commodo amet est deserunt occaecat nisi reprehenderit qui mollit ea occaecat voluptate. Nostrud eiusmod et duis eiusmod cillum nisi est ut esse. In enim nulla cupidatat culpa enim esse ad. Cupidatat laborum irure consequat est incididunt irure incididunt id enim ea do qui velit consequat. Sit elit nisi fugiat fugiat cillum deserunt.\r\n','\0\0\0\0\0\0\0–ìØĝFÀN ^ô…>@','[\"reprehenderit\", \"cillum\", \"cupidatat\", \"nisi\", \"non\", \"esse\", \"commodo\"]','[{\"name\": \"Lillie Daugherty\"}, {\"name\": \"Lawanda Schmidt\"}]','{\"email\": \"Noel@example.com\", \"salary\": 32000, \"twitter\": \"@incididuntcommodo\", \"direct_reports\": 9}'),(39,'a692955c-cd8d-4b06-8896-e0ec8c566c48',0,'Cynthia Rose','202 Ridgewood Avenue, Spelter, Virgin Islands, 8361','Sunt cillum occaecat voluptate irure dolore ex labore duis laborum velit duis minim adipisicing. Velit sint aute enim consectetur tempor ad. In qui enim ad occaecat deserunt nisi. Laboris aute eiusmod consectetur irure est do ipsum est reprehenderit proident aute. Incididunt aliqua ut anim est quis laboris laborum irure magna laborum irure anim in.\r\n','\0\0\0\0\0\0\0–®`ÅIÀ2‘ÒlJZ@','[\"consequat\", \"nisi\", \"non\", \"dolore\", \"eu\", \"excepteur\", \"tempor\"]','[{\"name\": \"Evans Dodson\"}, {\"name\": \"Merle Mack\"}, {\"name\": \"Holder Barton\"}, {\"name\": \"Hayes Olsen\"}]','{\"email\": \"Cross@example.com\", \"driver\": true, \"salary\": 25000, \"twitter\": \"@nonduis\", \"join_date\": \"2013-08-06T07:30:42 -01:00\"}'),(40,'c987691f-477d-421d-834c-d8660b6f6fed',0,'Andrea Burt','777 Berry Street, Celeryville, Colorado, 995','Consequat duis esse adipisicing qui eiusmod sint quis incididunt. Consequat enim proident amet laborum ea occaecat nisi cillum aliqua reprehenderit. Magna anim minim commodo commodo. Ullamco qui nostrud nostrud quis occaecat eu. Aliqua duis amet qui culpa culpa ex mollit ut labore nulla ipsum consectetur et. Nisi ex culpa elit commodo. Laborum officia et sint nisi culpa pariatur veniam eu veniam.\r\n','\0\0\0\0\0\0\0á&£Ê0ú8@¦ñ ¯$…_À','[\"nostrud\", \"consectetur\", \"occaecat\", \"ea\", \"nostrud\", \"minim\", \"fugiat\"]','[{\"name\": \"Debbie Randolph\"}, {\"name\": \"Greene Dixon\"}]','{\"driver\": false, \"salary\": 23000}'),(41,'7333a04d-effb-468b-ade3-2ca3ca6f7ecd',0,'Socorro Riddle','140 Tudor Terrace, Coventry, Maryland, 7461','Amet enim id nulla ullamco laboris adipisicing reprehenderit fugiat. Magna Lorem nisi ex veniam est velit minim sunt. Dolore ad pariatur do amet dolor est aute et aliquip ea elit nisi enim tempor. Consectetur dolore cillum commodo commodo ea cillum adipisicing voluptate.\r\n','\0\0\0\0\0\0\0•Óž’sþ:@p#e‹¤÷^À','[\"exercitation\", \"ex\", \"anim\", \"occaecat\", \"aute\", \"proident\", \"voluptate\"]','[{\"name\": \"Amalia Avila\"}, {\"name\": \"Alyssa Carr\"}]','{\"salary\": 75000, \"join_date\": \"2013-10-17T01:57:29 -01:00\", \"direct_reports\": 2}'),(42,'1031c7fc-f7ed-49d4-b5dd-2695ff18f021',0,'Vega Valencia','283 Coles Street, Enetai, Minnesota, 999','Magna duis aliqua consectetur excepteur. Esse pariatur nostrud commodo voluptate non excepteur magna aute duis sit. Enim eu consectetur elit eu proident. Dolor reprehenderit elit deserunt quis excepteur minim id pariatur quis. Nostrud minim irure deserunt fugiat aliquip et voluptate sit quis sit qui. Aliquip cillum et pariatur Lorem excepteur sint cillum nostrud sit ullamco culpa deserunt mollit Lorem.\r\n','\0\0\0\0\0\0\0ëÂ1Ë5@™IÔ ¾Èe@','[\"aliquip\", \"non\", \"exercitation\", \"laboris\", \"officia\", \"consequat\", \"ullamco\"]','[{\"name\": \"Gilbert Mckenzie\"}, {\"name\": \"Vargas Benson\"}, {\"name\": \"Jimenez Mckay\"}, {\"name\": \"Bowman Sargent\"}]','{\"salary\": 52000, \"direct_reports\": 3}'),(43,'8636883d-2193-40f3-8a10-b0cb9391c4a0',0,'Perez Oneil','590 Lloyd Street, Cavalero, Utah, 3188','Excepteur qui ea ullamco pariatur id adipisicing proident nulla Lorem minim proident enim. Non incididunt veniam nisi reprehenderit id consectetur minim minim irure. Consequat irure ea enim nostrud duis esse aute nulla sit sint consectetur do. Esse culpa fugiat minim sit mollit incididunt duis aliquip exercitation. Minim cillum Lorem aliquip laborum quis adipisicing deserunt eiusmod. Elit eiusmod proident cillum cillum minim deserunt magna est eu duis culpa. Deserunt consectetur incididunt cupidatat ipsum cillum dolore consectetur dolor commodo et.\r\n','\0\0\0\0\0\0\0ð‰uª|Q@ÖXÂÚ‹/@','[\"sunt\", \"occaecat\", \"officia\", \"nostrud\", \"esse\", \"velit\", \"irure\"]','[{\"name\": \"Ronda Contreras\"}, {\"name\": \"Bush Mcfadden\"}, {\"name\": \"Stark Rollins\"}, {\"name\": \"Joan Decker\"}]','{\"email\": \"Lynnette@example.com\", \"driver\": true, \"salary\": 44000, \"twitter\": \"@laboreeiusmod\", \"join_date\": \"2015-08-06T06:59:25 -01:00\", \"direct_reports\": 1}'),(44,'4ce25b9b-79ea-4389-bf93-61abe0dd5c97',0,'Hamilton Zamora','171 Vermont Court, Canoochee, Ohio, 739','Irure nostrud consectetur velit nisi. Reprehenderit cillum aute cillum irure sit voluptate enim ipsum in. Cupidatat excepteur enim mollit exercitation labore dolore non. Adipisicing occaecat anim cupidatat dolor ea id aliquip. Ullamco Lorem proident nisi cillum do.\r\n','\0\0\0\0\0\0\0×kzPP¢=À‘fùRÀ','[\"irure\", \"sit\", \"reprehenderit\", \"anim\", \"deserunt\", \"Lorem\", \"consequat\"]','[{\"name\": \"Hodge Ellis\"}, {\"name\": \"Nita English\"}, {\"name\": \"Pennington Silva\"}]','{\"salary\": 52000, \"twitter\": \"@deseruntproident\", \"join_date\": \"2013-08-28T01:36:51 -01:00\"}'),(45,'423d244a-a233-47f4-868b-c139dc0397cc',1,'Norton Russo','931 Cyrus Avenue, Bloomington, New Jersey, 7665','Aute ut officia laborum laborum labore aute laborum exercitation ad velit. Labore aliquip minim tempor excepteur dolore est consectetur proident. Tempor exercitation anim proident labore amet. Id fugiat consequat elit eu. Sit tempor commodo excepteur deserunt. Incididunt ea veniam sunt dolor dolor magna occaecat minim culpa tempor velit nisi aute mollit. Ipsum ut officia in id eu incididunt est nulla incididunt officia.\r\n','\0\0\0\0\0\0\0˜.‹‰ÑO@ÔHKåmXc@','[\"quis\", \"Lorem\", \"enim\", \"sunt\", \"proident\", \"labore\", \"ea\"]','[{\"name\": \"Bertie Torres\"}, {\"name\": \"Thelma York\"}, {\"name\": \"Harriet Richard\"}]','{\"salary\": 70000, \"direct_reports\": 12}'),(46,'ffc804b9-581d-4c71-982e-f75853f5b40d',0,'Savannah Hunter','455 Maple Street, Dragoon, Arizona, 8124','Ea voluptate nostrud eiusmod amet. Lorem proident proident commodo magna officia. Veniam excepteur ex fugiat deserunt nostrud ex qui consequat qui ipsum eiusmod reprehenderit laborum. Et aliqua exercitation magna veniam officia sit non ullamco. Cillum laboris enim incididunt tempor quis irure magna in. Adipisicing et ea adipisicing consectetur deserunt non sunt nostrud.\r\n','\0\0\0\0\0\0\0±4ð£\ZCQÀ.¬ïŽ!X@','[\"officia\", \"non\", \"Lorem\", \"officia\", \"mollit\", \"ad\", \"enim\"]','[{\"name\": \"Saunders Franks\"}, {\"name\": \"Constance Wilkinson\"}, {\"name\": \"William Parsons\"}, {\"name\": \"Guerra Fry\"}]','{\"email\": \"Hicks@example.com\", \"salary\": 37000}'),(47,'c7689bce-2eb6-40ce-963a-3c623a5a2dd9',1,'Mccullough Patton','274 Holmes Lane, Madrid, American Samoa, 623','Mollit voluptate tempor sit amet non adipisicing. Cillum elit cillum sint ex. Laborum cillum excepteur culpa sint pariatur do dolor. Proident dolore nulla ex voluptate quis cupidatat non voluptate sint commodo sunt non.\r\n','\0\0\0\0\0\0\0c(\'ÚUE@¡„™¶í=À','[\"sit\", \"minim\", \"anim\", \"quis\", \"enim\", \"sunt\", \"aliquip\"]','[{\"name\": \"Waller Golden\"}, {\"name\": \"Anna Fischer\"}]','{\"salary\": 46000, \"join_date\": \"2015-02-03T10:53:52 -00:00\", \"direct_reports\": 12}'),(48,'39f2b82e-484d-4188-be34-79646db3f358',0,'Betty Webb','266 Kiely Place, Goodville, Missouri, 5907','Sint nisi officia nostrud velit sunt laborum. Ipsum minim veniam anim eiusmod veniam id ut pariatur irure tempor ullamco do amet. Exercitation anim cillum ad tempor veniam incididunt elit commodo culpa culpa minim minim nisi. Tempor enim eu laboris consectetur anim dolore eu. Veniam duis do ipsum consequat proident tempor quis officia deserunt. Incididunt ipsum nisi est minim laborum. Non sunt enim in mollit Lorem enim proident sint aliqua id dolor quis occaecat.\r\n','\0\0\0\0\0\0\0Úå[ÖK@Ùx°Ång`À','[\"non\", \"enim\", \"et\", \"cupidatat\", \"Lorem\", \"ut\", \"fugiat\"]','[{\"name\": \"Lou Padilla\"}, {\"name\": \"Tonia Nelson\"}, {\"name\": \"Melva Jones\"}, {\"name\": \"Tillman Stark\"}]','{\"driver\": false, \"salary\": 58000, \"twitter\": \"@estirure\", \"join_date\": \"2013-07-13T10:04:13 -01:00\", \"direct_reports\": 0}'),(49,'c2434cb0-ab09-422f-ac8b-d649fe7ea97f',0,'Welch Berry','889 Florence Avenue, Martinez, Indiana, 3710','Aliquip ea ex est est culpa duis consectetur qui voluptate. Ea officia proident eu sunt mollit voluptate eiusmod eiusmod amet aliqua ullamco aute velit. Elit officia ex nisi amet non amet dolore officia nostrud ex occaecat et.\r\n','\0\0\0\0\0\0\0t\'؝ÿK@ðHP<*@','[\"voluptate\", \"ut\", \"ut\", \"duis\", \"nisi\", \"dolor\", \"voluptate\"]','[{\"name\": \"Chaney Moreno\"}, {\"name\": \"Walker Warner\"}, {\"name\": \"Juanita Justice\"}, {\"name\": \"Lynn Hudson\"}]','{\"salary\": 31000}');
/*!40000 ALTER TABLE `people` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2016-04-04 17:02:42
@cqyy
Copy link

cqyy commented Jul 5, 2016

When import the people.sql into my mysql-server, I get the error:

Cannot get geometry object from data you send to the GEOMETRY field.

Some says this can be fixed by using ' --hex-blob option' when dump,does this matter?

@MasterMong
Copy link

I set to varchar.
from location geometry DEFAULT NULL,
set to location varchar(1000) NULL,

@Trashtravis
Copy link

NExt time you run a mysqldump please make sure the max_allowed_packet is big enough to acommodate your largest data blob, for instance:
mysql -u user -h hostname --max_allowed_packet=32M dbname < dumpfile.sql

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment