cryptids: cryptids: 12 rows

Data license: CC Attribution 4.0 License · Data source: simonw/cryptozoology

12 rows

descending

id ▼	name	wikipedia_url	additional_url	description	copyright	first_sighted	last_sighted	geom	range
1360667271	Loveland Frogman	https://en.wikipedia.org/wiki/Loveland_frog	http://www.weirdus.com/states/ohio/bizarre_beasts/loveland_frogman/index.php	Humanoid frog described as standing roughly 4 feet tall		1955	1972	<Binary: 1,405 bytes>	<Binary: 269 bytes>
1360667273	Bessie	https://en.wikipedia.org/wiki/Bessie_(lake_monster)		Lake monster in Lake Erie		1793	1993	<Binary: 3,437 bytes>	<Binary: 797 bytes>
1360667275	Beast of Bray Road	https://en.wikipedia.org/wiki/Beast_of_Bray_Road		Unusually large (7 feet tall) intelligent bear-like werewolf-like creature		1936	1992	<Binary: 1,261 bytes>	<Binary: 221 bytes>
1360667289	Bigfoot	https://en.wikipedia.org/wiki/Bigfoot	http://www.bfro.net/	A hairy, upright-walking, ape-like being who dwells in the wilderness and leaves behind footprints				<Binary: 1,072,371 bytes>	<Binary: 824,020 bytes>
1360667293	Nain Rouge	https://en.wikipedia.org/wiki/Nain_Rouge	http://www.gutenberg.org/ebooks/6615?msg=welcome_stranger#2H_4_0209	A shambling, red-faced creature, with a cold, glittering eye and teeth protruding from a grinning mouth.		1701	1976	<Binary: 9,917 bytes>	<Binary: 26,845 bytes>
1360667307	Loch Ness Monster	https://en.wikipedia.org/wiki/Loch_Ness_Monster		Large water monster with a long neck and one or more humps	The data included in this document is from www.openstreetmap.org. The data is made available under ODbL.			<Binary: 4,781 bytes>	<Binary: 22,977 bytes>
1360667327	Snake-Headed Dog		http://cryptidz.wikia.com/wiki/Snake-Headed_Dog	5ft long, sleek serpentine head, red reptilian eyes, a slender neck, shaggy black fur, long hind limbs, shorter forelimbs, and no tail at all		1996	1996	<Binary: 1,261 bytes>	<Binary: 237 bytes>
1360667329	Bunyip		http://cryptidz.wikia.com/wiki/Bunyip	Little is known about its form, covering or habits; observers have been in such dread of it as to have been unable to take note of its characteristics. Its most usual form is said to be that of an enormous starfish. Common features as reported in many 19th-century newspaper accounts include a dog-like face, a crocodile-like head, dark fur, a horse-like tail, flippers, and walrus-like tusks or horns, or a duck-like bill.		1818	1852	<Binary: 6,177 bytes>	<Binary: 1,181 bytes>
1360667851	Yowie		http://cryptidz.wikia.com/wiki/Yowie	A fanged humanoid marsupial, 7 to 9 feet tall, with a large red mouth and talon-like claws. One of the most aggressive Sasquatch species, and has been reported tearing heads off of kangaroos and dogs. It has been seen attacking humans as well. However, that is rare.		1800	2013	<Binary: 6,177 bytes>	<Binary: 1,181 bytes>
1360667855	Drop Bear	https://en.wikipedia.org/wiki/Drop_Bear	https://australianmuseum.net.au/drop-bear	A carnivorous subspecies of Koala		1800	2013	<Binary: 5,351 bytes>	<Binary: 935 bytes>
1360667857	Jackalope		https://en.wikipedia.org/wiki/Jackalope	An angry beastie, as if a rabbit sprouted antalope horns		1000	2011	<Binary: 6,637 bytes>	<Binary: 1,645 bytes>
1360667859	Chessie	https://en.wikipedia.org/wiki/Chessie_(sea_monster)		A serpent-like sea monster		1977	2014	<Binary: 5,581 bytes>	<Binary: 797 bytes>

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE cryptids (
            id integer primary key,
            name text,
            wikipedia_url text,
            additional_url text,
            description text,
            copyright text,
            first_sighted integer,
            last_sighted integer
        , "geom" MULTIPOLYGON, "range" MULTIPOLYGON);