squirrels

6 rows where Chasing = "true" and Combination of Primary and Highlight Color = "Cinnamon+" sorted by Shift

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
255	255	-73.9800669115792	40.7676825134384	1B-AM-1012-07	01B	AM	10122018	7	Adult	Cinnamon	Cinnamon+	Above Ground	2	on tree trunk	false	true	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9800669115792 40.7676825134384)	19	4	19	13
1038	1038	-73.9563311167069	40.7950901563337	38E-AM-1010-12	38E	AM	10102018	12	Adult	Cinnamon	Cinnamon+	Ground Plane	FALSE	running on rocks	false	true	false	false	false		false	false	false	true	false	false	false	false	runs toward something	POINT (-73.9563311167069 40.7950901563337)	19	4	19	13
1260	1260	-73.9811585807616	40.768706748732	2A-AM-1010-06	02A	AM	10102018	6	Adult	Cinnamon	Cinnamon+	Ground Plane	FALSE		true	true	false	false	false	chasing #5	false	false	false	false	false	false	false	false		POINT (-73.9811585807616 40.768706748732)	19	4	19	13
1323	1323	-73.9744387347626	40.7776953143835	13A-AM-1017-03	13A	AM	10172018	3	Adult	Cinnamon	Cinnamon+				false	true	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9744387347626 40.7776953143835)	19	4	19	13
2205	2205	-73.9594986107981	40.7840083040604	25I-AM-1012-03	25I	AM	10122018	3	Adult	Cinnamon	Cinnamon+	Above Ground	8	on turn, see map	true	true	false	true	false		false	false	false	false	true	true	false	false		POINT (-73.9594986107981 40.7840083040604)	19	4	19	13
2955	2955	-73.9711666523376	40.7761513057034	13D-AM-1014-02	13D	AM	10142018	2	Adult	Cinnamon	Cinnamon+	Ground Plane	FALSE		false	true	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9711666523376 40.7761513057034)	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
);