squirrels

12 rows where Combination of Primary and Highlight Color = "Gray+Cinnamon, White", Running = "true" and Tail twitches = "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	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
1108	1108	-73.9638397790384	40.7828950272904	23F-PM-1013-02	23F	PM	10132018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		true	false	false	true	true	false	true	false	false	true	false	true	false	indifferent (mostly,did notice me,busy eating,foraging)	POINT (-73.9638397790384 40.7828950272904)	19	4	19	13
1118	1118	-73.9719460335398	40.7810508156287	18A-AM-1012-01	18A	AM	10122018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	White tail	Above Ground	3	tree	true	false	true	false	true	false	false	false	false	true	false	false	true		POINT (-73.9719460335398 40.7810508156287)	19	4	19	13
1303	1303	-73.9603302382958	40.7910100435196	32D-PM-1006-01	32D	PM	10062018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		true	false	false	true	false	false	false	false	false	true	false	false	true		POINT (-73.9603302382958 40.7910100435196)	19	4	19	13
1462	1462	-73.9584064203778	40.7912272455454	33F-PM-1012-04	33F	PM	10122018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		true	false	false	true	true	false	false	false	false	true	false	false	true		POINT (-73.9584064203778 40.7912272455454)	19	4	19	13
1600	1600	-73.9753093777	40.7666673897583	2F-AM-1006-04	02F	AM	10062018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Beautiful white puff at the end of its tail	Ground Plane	FALSE		true	false	false	false	false	false	false	false	false	true	false	true	false		POINT (-73.97530937770001 40.7666673897583)	19	4	19	13
1866	1866	-73.9636027664439	40.790075966587	30B-PM-1019-01	30B	PM	10192018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		true	false	false	true	true	false	false	false	false	true	false	false	true		POINT (-73.9636027664439 40.790075966587)	19	4	19	13
2091	2091	-73.9676112864286	40.7772792086081	16F-AM-1008-03	16F	AM	10082018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	road	true	false	false	false	false	false	false	false	false	true	false	true	false		POINT (-73.9676112864286 40.7772792086081)	19	4	19	13
2495	2495	-73.9621253644004	40.7912082086879	31C-AM-1017-01	31C	AM	10172018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	8		true	false	true	true	false	false	false	false	false	true	false	false	true		POINT (-73.9621253644004 40.7912082086879)	19	4	19	13
2508	2508	-73.979381450452	40.7709033697887	4A-PM-1007-01	04A	PM	10072018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		true	false	true	true	true	false	false	false	false	true	false	true	false		POINT (-73.979381450452 40.770903369788705)	19	4	19	13
2655	2655	-73.9659156108069	40.7810709818696	20E-AM-1014-01	20E	AM	10142018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		true	false	false	true	true	false	false	false	false	true	false	false	false		POINT (-73.9659156108069 40.7810709818696)	19	4	19	13
2776	2776	-73.9789687905912	40.7692693139328	3B-PM-1007-04	03B	PM	10072018	4	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	4	At fence	true	false	true	true	false	false	false	false	false	true	false	true	true		POINT (-73.9789687905912 40.7692693139328)	19	4	19	13
2849	2849	-73.9709912560997	40.7758965595198	13D-AM-1014-01	13D	AM	10142018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		true	false	false	false	true	false	false	false	false	true	false	false	true		POINT (-73.9709912560997 40.7758965595198)	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
);