squirrels

5 rows where Above Ground Sighter Measurement = 20, Hectare Squirrel Number = 4 and Shift = "AM"

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
497	497	-73.9602166876979	40.7953811003986	36B-AM-1013-04	36B	AM	10132018	4		Black		Black+		Above Ground	20	Moved 20+ feet high above top of tree limb	false	true	false	false	false		false	false	false	false	false	false	false	true		POINT (-73.9602166876979 40.7953811003986)	19	4	19	13
1079	1079	-73.9722737593623	40.768963018754	6G-AM-1008-04	06G	AM	10082018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon	very long tail	Above Ground	20	tree	true	false	true	false	false		false	false	false	false	true	false	false	true		POINT (-73.9722737593623 40.768963018754)	19	4	19	13
2248	2248	-73.9766477027266	40.7712737417779	6C-AM-1007-04	06C	AM	10072018	4	Adult	Gray		Gray+		Above Ground	20		false	true	true	false	false	chasing #5	false	false	false	false	false	false	true	false		POINT (-73.9766477027266 40.7712737417779)	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
2754	2754	-73.9687025912431	40.7719319822619	10H-AM-1014-04	10H	AM	10142018	4	Juvenile			+		Above Ground	20		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9687025912431 40.7719319822619)	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
);