Skip to content

Instantly share code, notes, and snippets.

@han-wong
Last active March 17, 2021 13:12
Show Gist options
  • Save han-wong/4e5752ba1167a23070f7ab0ac7ee6144 to your computer and use it in GitHub Desktop.
Save han-wong/4e5752ba1167a23070f7ab0ac7ee6144 to your computer and use it in GitHub Desktop.
100 animals, enclosures
INSERT INTO `animal` (`animal_name`,`animal_age`,`animal_species`,`animal_sex`) VALUES ("Tate",22,"Zebra","Female"),("Benjamin",24,"Wolf","Female"),("Emma",9,"Elephant","Male"),("Hashim",12,"Giraffe","Female"),("Anastasia",11,"Lion","Male"),("Erich",17,"Rhino","Female"),("Ashely",20,"Parrot","Female"),("Amos",25,"Penguin","Male"),("Brent",12,"Lion","Female"),("James",11,"Parrot","Female");
INSERT INTO `animal` (`animal_name`,`animal_age`,`animal_species`,`animal_sex`) VALUES ("Regina",5,"Penguin","Female"),("Zephania",16,"Wolf","Male"),("Lyle",23,"Penguin","Female"),("Orson",2,"Parrot","Male"),("Camden",25,"Wolf","Female"),("Iliana",19,"Parrot","Male"),("Berk",2,"Zebra","Female"),("Odysseus",22,"Wolf","Male"),("Brynn",19,"Giraffe","Male"),("Alvin",21,"Rhino","Male");
INSERT INTO `animal` (`animal_name`,`animal_age`,`animal_species`,`animal_sex`) VALUES ("Gareth",21,"Giraffe","Male"),("Hiram",1,"Giraffe","Female"),("Hayley",30,"Flamingo","Male"),("MacKenzie",11,"Chimpanzee","Female"),("Seth",20,"Gorilla","Male"),("Rudyard",16,"Gorilla","Female"),("Christian",2,"Gorilla","Male"),("Garrison",1,"Tiger","Male"),("Keegan",23,"Flamingo","Male"),("Travis",7,"Parrot","Female");
INSERT INTO `animal` (`animal_name`,`animal_age`,`animal_species`,`animal_sex`) VALUES ("Hanae",5,"Parrot","Female"),("Reece",8,"Penguin","Female"),("Chloe",26,"Elephant","Male"),("Wesley",27,"Chimpanzee","Female"),("Rhona",22,"Flamingo","Male"),("Basia",12,"Lion","Female"),("Allen",20,"Rhino","Male"),("Myles",19,"Penguin","Female"),("Katell",22,"Chimpanzee","Male"),("Oliver",14,"Tiger","Female");
INSERT INTO `animal` (`animal_name`,`animal_age`,`animal_species`,`animal_sex`) VALUES ("Aaron",4,"Penguin","Female"),("Brittany",19,"Lion","Male"),("Naida",6,"Flamingo","Female"),("Naomi",13,"Rhino","Female"),("Ifeoma",13,"Rhino","Female"),("Hedda",10,"Elephant","Female"),("Margaret",5,"Chimpanzee","Male"),("Daryl",6,"Gorilla","Female"),("Murphy",8,"Tiger","Male"),("Sybill",15,"Elephant","Male");
INSERT INTO `animal` (`animal_name`,`animal_age`,`animal_species`,`animal_sex`) VALUES ("Martena",13,"Lion","Female"),("Robin",6,"Chimpanzee","Male"),("Lara",1,"Zebra","Male"),("Bruce",19,"Zebra","Male"),("Bernard",25,"Zebra","Female"),("Melanie",27,"Lion","Female"),("Laura",4,"Elephant","Male"),("Kelly",23,"Rhino","Female"),("Ross",5,"Chimpanzee","Female"),("Wynter",17,"Lion","Male");
INSERT INTO `animal` (`animal_name`,`animal_age`,`animal_species`,`animal_sex`) VALUES ("Geraldine",7,"Gorilla","Female"),("Ursa",6,"Wolf","Male"),("Clinton",22,"Lion","Female"),("Ryder",12,"Parrot","Male"),("Farrah",24,"Rhino","Male"),("Peter",25,"Chimpanzee","Male"),("Maxine",20,"Gorilla","Male"),("Octavius",27,"Parrot","Male"),("Alden",12,"Lion","Male"),("Steel",24,"Flamingo","Female");
INSERT INTO `animal` (`animal_name`,`animal_age`,`animal_species`,`animal_sex`) VALUES ("Thane",24,"Chimpanzee","Female"),("Thor",13,"Gorilla","Female"),("Raya",26,"Parrot","Male"),("Zeus",22,"Gorilla","Female"),("Ann",25,"Penguin","Female"),("Oren",19,"Elephant","Female"),("Orlando",10,"Gorilla","Male"),("May",10,"Zebra","Female"),("Oliver",18,"Rhino","Male"),("Shaine",27,"Giraffe","Male");
INSERT INTO `animal` (`animal_name`,`animal_age`,`animal_species`,`animal_sex`) VALUES ("Gemma",3,"Parrot","Male"),("Cullen",1,"Elephant","Male"),("Edan",18,"Wolf","Female"),("James",30,"Parrot","Male"),("Petra",17,"Elephant","Male"),("Odette",30,"Tiger","Female"),("Raphael",10,"Elephant","Female"),("Jonah",12,"Flamingo","Female"),("Ishmael",29,"Elephant","Female"),("Gretchen",14,"Elephant","Male");
INSERT INTO `animal` (`animal_name`,`animal_age`,`animal_species`,`animal_sex`) VALUES ("Dana",18,"Penguin","Female"),("Kibo",30,"Elephant","Female"),("Alan",2,"Parrot","Female"),("Cally",1,"Wolf","Male"),("Lynn",7,"Chimpanzee","Male"),("Axel",16,"Tiger","Female"),("John",24,"Chimpanzee","Male"),("Zeph",18,"Parrot","Male"),("Cameran",15,"Elephant","Male"),("Kylee",19,"Zebra","Male");
INSERT INTO `enclosure` (`enclosure_name`,`enclosure_area`,`enclosure_has_water`) VALUES ("Chimpanzee",154,"0"),("Rhino",63,"1"),("Flamingo",79,"1"),("Wolf",170,"1"),("Tiger",88,"1"),("Chimpanzee",119,"1"),("Wolf",54,"0"),("Parrot",163,"0"),("Chimpanzee",150,"0"),("Tiger",83,"0");
INSERT INTO `enclosure` (`enclosure_name`,`enclosure_area`,`enclosure_has_water`) VALUES ("Flamingo",112,"1"),("Giraffe",159,"1"),("Gorilla",123,"0"),("Giraffe",122,"1"),("Elephant",143,"1"),("Elephant",132,"0"),("Rhino",107,"0"),("Penguin",128,"1"),("Rhino",94,"1"),("Flamingo",77,"0");
INSERT INTO `enclosure` (`enclosure_name`,`enclosure_area`,`enclosure_has_water`) VALUES ("Gorilla",180,"0"),("Rhino",97,"1"),("Flamingo",192,"1"),("Wolf",174,"1"),("Wolf",88,"0"),("Chimpanzee",89,"1"),("Zebra",180,"1"),("Gorilla",191,"0"),("Penguin",186,"0"),("Giraffe",78,"0");
INSERT INTO `enclosure` (`enclosure_name`,`enclosure_area`,`enclosure_has_water`) VALUES ("Parrot",124,"1"),("Parrot",114,"0"),("Chimpanzee",68,"1"),("Elephant",105,"1"),("Penguin",119,"1"),("Wolf",92,"0"),("Rhino",69,"0"),("Wolf",159,"1"),("Zebra",135,"1"),("Wolf",85,"1");
INSERT INTO `enclosure` (`enclosure_name`,`enclosure_area`,`enclosure_has_water`) VALUES ("Elephant",111,"0"),("Wolf",154,"0"),("Elephant",78,"1"),("Tiger",77,"1"),("Chimpanzee",131,"1"),("Parrot",102,"1"),("Lion",119,"0"),("Parrot",142,"0"),("Chimpanzee",178,"0"),("Gorilla",54,"0");
INSERT INTO `enclosure` (`enclosure_name`,`enclosure_area`,`enclosure_has_water`) VALUES ("Flamingo",58,"1"),("Lion",172,"0"),("Tiger",190,"0"),("Giraffe",198,"1"),("Giraffe",194,"1"),("Zebra",97,"1"),("Lion",169,"1"),("Tiger",168,"0"),("Zebra",167,"0"),("Rhino",62,"1");
INSERT INTO `enclosure` (`enclosure_name`,`enclosure_area`,`enclosure_has_water`) VALUES ("Wolf",156,"1"),("Giraffe",95,"1"),("Gorilla",199,"0"),("Parrot",145,"0"),("Parrot",51,"1"),("Elephant",91,"1"),("Tiger",152,"1"),("Zebra",136,"0"),("Gorilla",145,"0"),("Giraffe",91,"1");
INSERT INTO `enclosure` (`enclosure_name`,`enclosure_area`,`enclosure_has_water`) VALUES ("Tiger",107,"0"),("Chimpanzee",178,"1"),("Chimpanzee",154,"1"),("Chimpanzee",89,"1"),("Parrot",77,"1"),("Wolf",112,"0"),("Giraffe",181,"0"),("Tiger",130,"1"),("Flamingo",158,"1"),("Chimpanzee",159,"1");
INSERT INTO `enclosure` (`enclosure_name`,`enclosure_area`,`enclosure_has_water`) VALUES ("Elephant",160,"0"),("Rhino",114,"0"),("Elephant",61,"0"),("Penguin",128,"0"),("Elephant",54,"1"),("Parrot",182,"1"),("Wolf",100,"0"),("Lion",55,"1"),("Lion",146,"0"),("Elephant",62,"0");
INSERT INTO `enclosure` (`enclosure_name`,`enclosure_area`,`enclosure_has_water`) VALUES ("Rhino",84,"1"),("Tiger",143,"0"),("Gorilla",190,"1"),("Lion",76,"0"),("Lion",128,"1"),("Lion",199,"0"),("Penguin",132,"0"),("Penguin",165,"0"),("Rhino",162,"0"),("Gorilla",150,"0");
INSERT INTO `keeper` (`keeper_name`,`keeper_role`) VALUES ("Judah Bennett","two"),("Caesar Blair","seven"),("Leah Whitfield","seven"),("Ray Miller","eight"),("Jacqueline Dudley","eight"),("Flavia Slater","five"),("Isaac Hudson","two"),("Macaulay Padilla","five"),("Buckminster Pacheco","ten"),("Yen Taylor","eight");
INSERT INTO `keeper` (`keeper_name`,`keeper_role`) VALUES ("Garrett Keller","two"),("Carter Bartlett","two"),("Aileen Albert","ten"),("Oliver Bowman","five"),("Bert Sherman","seven"),("Ignacia Preston","six"),("Ivor Roach","five"),("Fitzgerald Peterson","two"),("Alisa Mccarty","eight"),("Blake Frederick","nine");
INSERT INTO `keeper` (`keeper_name`,`keeper_role`) VALUES ("John Figueroa","six"),("Vivien Huff","one"),("Paula Alexander","one"),("Taylor Berger","two"),("Catherine Mcmahon","eight"),("Quinn Vargas","three"),("Ginger Luna","three"),("Graham Pruitt","four"),("Jorden Pollard","one"),("Brenden Summers","four");
INSERT INTO `keeper` (`keeper_name`,`keeper_role`) VALUES ("Thane Roach","ten"),("Porter Joyner","six"),("Axel Jordan","three"),("Nola Rush","one"),("Tyler Graves","three"),("Oprah Santos","three"),("Lilah Bates","ten"),("Walker Cooley","three"),("Conan Schultz","ten"),("Eaton Guerrero","nine");
INSERT INTO `keeper` (`keeper_name`,`keeper_role`) VALUES ("Eagan Waters","five"),("Salvador Faulkner","six"),("Erich Mullen","five"),("Colin Wolf","nine"),("Bianca Villarreal","five"),("Isabella Morris","two"),("Silas Cameron","three"),("Hoyt Sykes","seven"),("Brett Guy","one"),("Phillip Gray","eight");
INSERT INTO `keeper` (`keeper_name`,`keeper_role`) VALUES ("Dai Houston","three"),("Galena Roach","one"),("Amery Sharpe","one"),("Yoshi Lee","eight"),("Darryl Foster","one"),("Tallulah Russell","four"),("Aurora Payne","two"),("Giacomo Dejesus","two"),("Keith Sawyer","nine"),("Alana Ellison","two");
INSERT INTO `keeper` (`keeper_name`,`keeper_role`) VALUES ("Malachi Howell","six"),("David Walton","four"),("Phelan Roach","one"),("Eric Forbes","four"),("Francis Hyde","six"),("William Jacobson","ten"),("Donovan Kramer","nine"),("Debra Rocha","three"),("Yetta Travis","one"),("Dolan Rush","nine");
INSERT INTO `keeper` (`keeper_name`,`keeper_role`) VALUES ("Candace Frederick","ten"),("Athena Jacobs","five"),("Lance Coffey","nine"),("Rafael Short","six"),("Kessie Wilkinson","two"),("Flavia Michael","nine"),("Kirby Graham","nine"),("Glenna Fulton","two"),("Jamal Farmer","six"),("Gisela Sims","three");
INSERT INTO `keeper` (`keeper_name`,`keeper_role`) VALUES ("Orlando Davenport","five"),("Josiah Cobb","one"),("Kaden Sykes","seven"),("Tasha Rowe","seven"),("Barry Rowe","nine"),("Michael Perez","eight"),("Carolyn Vance","six"),("Olivia Williamson","three"),("Renee Finch","eight"),("Naomi Wilkins","ten");
INSERT INTO `keeper` (`keeper_name`,`keeper_role`) VALUES ("Cathleen Sampson","seven"),("Lucian Chapman","ten"),("Henry Frederick","four"),("Brock Barron","ten"),("Victor Olson","four"),("Caesar Hood","nine"),("Quinn Villarreal","one"),("Brenna Roy","five"),("Kirk Diaz","five"),("Isabella Mcgee","four");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment