squirrels

6 rows where Above Ground Sighter Measurement = 2, Foraging = "true" and Highlight Fur Color = "Cinnamon"

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	Kuks	Quaas	Moans	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
1777	1777	-73.9711751356843	40.7752422758202	12E-AM-1017-06	12E	AM	10172018	6	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2		false	false	false	true	true	false	false	false	false	false	false	true	false		POINT (-73.9711751356843 40.7752422758202)	19	4	19	13
1875	1875	-73.9527430510248	40.7924807950552	36I-PM-1007-12	36I	PM	10072018	12	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Tiny! So tiny!	Above Ground	2		false	false	false	false	true	false	false	false	false	false	false	false	false		POINT (-73.9527430510248 40.7924807950552)	19	4	19	13
2037	2037	-73.9683370417551	40.78135983505	19D-AM-1007-02	19D	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2		false	false	true	false	true	false	false	false	false	true	false	false	false	fenced area	POINT (-73.9683370417551 40.78135983505)	19	4	19	13
2515	2515	-73.9693338657183	40.7757055884538	13F-PM-1008-05	13F	PM	10082018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2	tree trunk	true	false	false	true	true	true	false	false	false	true	false	false	false		POINT (-73.9693338657183 40.77570558845381)	19	4	19	13
2639	2639	-73.9543832609857	40.7953550639701	39F-AM-1014-02	39F	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2	rocks	true	false	true	false	true	false	false	false	false	false	false	false	false		POINT (-73.9543832609857 40.7953550639701)	19	4	19	13
2694	2694	-73.969628583287	40.7704067797932	8H-AM-1017-03	08H	AM	10172018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2	fence	true	false	false	false	true	false	false	false	false	false	false	true	false		POINT (-73.969628583287 40.7704067797932)	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
);