squirrels

16 rows where Chasing = "true", Combination of Primary and Highlight Color = "Gray+Cinnamon" and Foraging = "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
240	240	-73.9767080512177	40.7717708794221	6B-PM-1017-04	06B	PM	10172018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		true	true	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9767080512177 40.7717708794221)	19	4	19	13
474	474	-73.9540652304705	40.7955226178199	39G-PM-1013-05	39G	PM	10132018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	true	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9540652304705 40.7955226178199)	19	4	19	13
633	633	-73.9673243699918	40.7875392957722	26A-AM-1014-01	26A	AM	10142018	1		Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	true	false	false	true		false	false	false	false	false	false	false	false	could not get close due to fences	POINT (-73.9673243699918 40.7875392957722)	19	4	19	13
763	763	-73.9767455430709	40.7717866237826	6B-PM-1017-06	06B	PM	10172018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		true	true	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9767455430709 40.7717866237826)	19	4	19	13
853	853	-73.9534509627885	40.7921084224711	36I-AM-1017-07	36I	AM	10172018	7	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	true	false	false	true	chasing (#8),scratching	true	false	false	false	true	false	true	false		POINT (-73.9534509627885 40.7921084224711)	19	4	19	13
911	911	-73.9697277998257	40.7705198722028	8H-AM-1017-01	08H	AM	10172018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	true	false	true	true		false	false	false	false	false	false	true	false		POINT (-73.9697277998257 40.7705198722028)	19	4	19	13
1143	1143	-73.9628349778362	40.793887005206	34A-PM-1013-03	34A	PM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	true	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9628349778362 40.793887005206)	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
1525	1525	-73.9727115915422	40.7782929320632	14B-PM-1014-02	14B	PM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	true	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9727115915422 40.7782929320632)	19	4	19	13
2106	2106	-73.9801651470389	40.7677698656935	1B-AM-1012-05	01B	AM	10122018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	true	false	true	true		false	false	false	false	false	false	true	false		POINT (-73.9801651470389 40.7677698656935)	19	4	19	13
2148	2148	-73.9767317539505	40.7717600450632	6B-PM-1017-05	06B	PM	10172018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		true	true	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9767317539505 40.7717600450632)	19	4	19	13
2498	2498	-73.9674556940019	40.7875399402461	26A-AM-1014-02	26A	AM	10142018	2		Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	true	false	false	true		false	false	false	false	false	false	false	false	could not get close due to fences	POINT (-73.9674556940019 40.7875399402461)	19	4	19	13
2513	2513	-73.9767590273554	40.7717561807266	6B-PM-1017-07	06B	PM	10172018	7	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		true	true	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9767590273554 40.7717561807266)	19	4	19	13
2699	2699	-73.9743509423821	40.7690043677328	5F-AM-1007-02	05F	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground		tree	true	true	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.97435094238212 40.7690043677328)	19	4	19	13
2759	2759	-73.9543373703455	40.7943889087123	38G-PM-1020-07	38G	PM	10202018	7	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	true	false	false	true		false	true	false	true	false	false	true	false		POINT (-73.9543373703455 40.7943889087123)	19	4	19	13
2993	2993	-73.9570722262693	40.7985706143519	40C-AM-1017-04	40C	AM	10172018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	true	false	true	true	chasing (#3)	false	false	false	false	false	false	true	false		POINT (-73.9570722262693 40.7985706143519)	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
);