squirrels

6 rows where Above Ground Sighter Measurement = 2, Climbing = "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	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
339	339	-73.965509576403	40.7752456763263	14I-PM-1018-05	14I	PM	10182018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2		false	false	true	true	false		false	false	false	false	true	false	true	false		POINT (-73.96550957640301 40.7752456763263)	19	4	19	13
1530	1530	-73.9689305978751	40.7818152496266	19C-PM-1018-06	19C	PM	10182018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2	Climbed fence	true	false	true	false	false	climbing (fence)	false	false	false	false	false	false	true	false		POINT (-73.9689305978751 40.7818152496266)	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
2380	2380	-73.9761375729505	40.7662231892125	1F-PM-1019-02	01F	PM	10192018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2		false	false	true	true	false		false	false	false	false	false	true	false	false		POINT (-73.9761375729505 40.7662231892125)	19	4	19	13
2517	2517	-73.9710221361528	40.7724939691584	10F-PM-1019-01	10F	PM	10192018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon head & stripe	Above Ground	2	Behind fence, tree trunk	false	false	true	false	false	sitting	false	false	false	false	false	false	true	false		POINT (-73.9710221361528 40.7724939691584)	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

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
);