squirrels

6 rows where Above Ground Sighter Measurement = 20 and Quaas = "true" sorted by Latitude

descending

Link	rowid	Longitude	Latitude ▼	Unique Squirrel ID	Hectare	Shift	Date	Hectare Squirrel Number	Age	Primary Fur Color	Highlight Fur Color	Combination of Primary and Highlight Color	Color notes	Location	Above Ground Sighter Measurement	Specific Location	Running	Chasing	Climbing	Eating	Foraging	Other Activities	Kuks	Quaas	Moans	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
306	306	-73.9689700100267	40.7775169562765	15E-PM-1008-05	15E	PM	10082018	5	Adult	Gray		Gray+		Above Ground	20		false	false	false	false	false	sitting	false	true	false	false	false	false	false	false		POINT (-73.9689700100267 40.7775169562765)	19	4	19	13
1554	1554	-73.9597462612063	40.7832801145306	25I-PM-1007-06	25I	PM	10072018	6				+	Didn't see squirrel size, or colors	Above Ground	20	up in tree	false	false	false	false	false		false	true	false	false	false	false	false	false		POINT (-73.9597462612063 40.7832801145306)	19	4	19	13
953	953	-73.9547959269955	40.7925162926273	36H-PM-1008-01	36H	PM	10082018	1	Adult	Gray	White	Gray+White	white belly	Above Ground	20		true	false	true	false	true		true	true	false	false	false	false	true	false		POINT (-73.9547959269955 40.7925162926273)	19	4	19	13
2700	2700	-73.9601988871514	40.7943473161329	35C-PM-1013-01	35C	PM	10132018	1		Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		false	false	true	false	true		true	true	false	true	true	false	true	false		POINT (-73.9601988871514 40.7943473161329)	19	4	19	13
2295	2295	-73.9590632051055	40.7963146584827	38B-AM-1019-04	38B	AM	10192018	4	Adult	Gray		Gray+		Above Ground	20		false	false	false	false	false	sitting in tree	true	true	false	true	false	false	true	false	observant	POINT (-73.9590632051055 40.7963146584827)	19	4	19	13
1807	1807	-73.9581366214863	40.7988964092722	40B-PM-1014-02	40B	PM	10142018	2	Adult	Gray		Gray+		Above Ground	20		false	false	true	false	false		true	true	false	false	false	false	false	true		POINT (-73.9581366214863 40.7988964092722)	19	4	19	13

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE squirrels(
  "Longitude" TEXT,
  "Latitude" TEXT,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" TEXT,
  "Hectare Squirrel Number" TEXT,
  "Age" TEXT,
  "Primary Fur Color" TEXT,
  "Highlight Fur Color" TEXT,
  "Combination of Primary and Highlight Color" TEXT,
  "Color notes" TEXT,
  "Location" TEXT,
  "Above Ground Sighter Measurement" TEXT,
  "Specific Location" TEXT,
  "Running" TEXT,
  "Chasing" TEXT,
  "Climbing" TEXT,
  "Eating" TEXT,
  "Foraging" TEXT,
  "Other Activities" TEXT,
  "Kuks" TEXT,
  "Quaas" TEXT,
  "Moans" TEXT,
  "Tail flags" TEXT,
  "Tail twitches" TEXT,
  "Approaches" TEXT,
  "Indifferent" TEXT,
  "Runs from" TEXT,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT,
  "Zip Codes" TEXT,
  "Community Districts" TEXT,
  "Borough Boundaries" TEXT,
  "City Council Districts" TEXT,
  "Police Precincts" TEXT
);