squirrels

4 rows where Above Ground Sighter Measurement = 50 and Running = "true"

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	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
109	109	-73.967097592707	40.7854119342538	24B-AM-1013-01	24B	AM	10132018	1		Gray		Gray+	Above Ground	50		true	false	false	true	false	took nut to bury	false	false	false	false	true	false	false	true		POINT (-73.967097592707 40.7854119342538)	19	4	19	13
1163	1163	-73.9677096985223	40.7825358361204	21C-AM-1014-02	21C	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	50		true	true	true	false	true		false	true	false	false	false	false	false	false	looked at us from tree	POINT (-73.9677096985223 40.7825358361204)	19	4	19	13
2777	2777	-73.9810843611086	40.7687905493699	2A-PM-1019-05	02A	PM	10192018	5	?	Gray		Gray+	Above Ground	50	in tall planetree	true	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9810843611086 40.7687905493699)	19	4	19	13
2914	2914	-73.9722053355548	40.7662094993614	3I-AM-1010-03	03I	AM	10102018	3	Adult	Gray		Gray+	Above Ground	50		true	false	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9722053355548 40.7662094993614)	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
);