squirrels

6 rows where Combination of Primary and Highlight Color = "Gray+", Date = 10132018, Foraging = "false" and Tail twitches = "true" sorted by Approaches

descending

Link	rowid	Longitude	Latitude	Unique Squirrel ID	Hectare	Shift	Date	Hectare Squirrel Number	Age	Primary 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
361	361	-73.9614824437251	40.7912929799884	32C-PM-1013-03	32C	PM	10132018	3	Adult	Gray	Gray+	Ground Plane	FALSE		false	true	false	false	false		false	false	false	false	true	false	false	false		POINT (-73.9614824437251 40.7912929799884)	19	4	19	13
979	979	-73.9612349421547	40.7959586475744	36A-PM-1013-09	36A	PM	10132018	9		Gray	Gray+	Ground Plane	FALSE	THICK UNDERGROWTH	true	false	false	false	false		false	false	false	false	true	false	false	true		POINT (-73.9612349421547 40.7959586475744)	19	4	19	13
1188	1188	-73.9669529835992	40.7871864151365	25A-AM-1013-05	25A	AM	10132018	5		Gray	Gray+	Ground Plane	FALSE	CROSS BRIDLE - INTO TREE TO AVOID DOGGO	true	false	true	false	false	d.p.t.	false	false	false	true	true	false	true	false	calm	POINT (-73.96695298359921 40.7871864151365)	19	4	19	13
1553	1553	-73.9690645326017	40.7773822116124	15E-AM-1013-03	15E	AM	10132018	3	Adult	Gray	Gray+	Above Ground	2	on fallen log	false	false	false	false	false		false	false	false	false	true	false	false	true		POINT (-73.9690645326017 40.7773822116124)	19	4	19	13
1872	1872	-73.9613998967903	40.7912437235667	32C-PM-1013-02	32C	PM	10132018	2	Adult	Gray	Gray+	Ground Plane	FALSE		false	true	false	false	false		false	false	false	false	true	false	false	false		POINT (-73.9613998967903 40.7912437235667)	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
);