squirrels

17 rows where Foraging = "true", Kuks = "true" and Tail twitches = "false"

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
101	101	-73.9544007658685	40.7950689723135	38F-PM-1013-05	38F	PM	10132018	5	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	false	true	being chased,was pushed by other squirrel	true	true	false	false	false	false	false	false		POINT (-73.9544007658685 40.7950689723135)	19	4	19	13
123	123	-73.9671147090087	40.7772624641112	16G-AM-1010-03	16G	AM	10102018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		false	false	false	false	true	was hanging out w/ #2 until i showed up	true	false	false	false	false	false	false	true		POINT (-73.9671147090087 40.7772624641112)	19	4	19	13
273	273	-73.9579218587172	40.7960605028848	38C-AM-1019-04	38C	AM	10192018	4	Adult	Gray		Gray+		Ground Plane	FALSE		false	false	false	false	true		true	true	false	false	false	false	true	false		POINT (-73.9579218587172 40.79606050288481)	19	4	19	13
384	384	-73.968045072743	40.7836626717225	22C-AM-1013-02	22C	AM	10132018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	4		false	false	true	false	true		true	false	false	true	false	false	false	true		POINT (-73.968045072743 40.7836626717225)	19	4	19	13
504	504	-73.9533476020736	40.7933003544685	37H-PM-1006-02	37H	PM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	tree	true	false	true	false	true		true	false	false	false	false	false	false	true	dogs	POINT (-73.9533476020736 40.7933003544685)	19	4	19	13
739	739	-73.9620597449066	40.7922465876813	33B-PM-1010-10	33B	PM	10102018	10	Adult	Gray		Gray+		Ground Plane	FALSE		false	false	false	false	true		true	false	false	false	false	false	false	false		POINT (-73.9620597449066 40.7922465876813)	19	4	19	13
743	743	-73.9565035705619	40.7937382705056	36F-AM-1017-04	36F	AM	10172018	4	Juvenile	Gray	White	Gray+White	White legs, front & back	Ground Plane	FALSE		true	false	false	true	true		true	false	false	false	false	true	false	true	approaches (me),runs from (me)	POINT (-73.9565035705619 40.7937382705056)	19	4	19	13
769	769	-73.976521916284	40.773784724458	9B-AM-1010-01	09B	AM	10102018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	false	true		true	false	false	false	false	false	false	true		POINT (-73.976521916284 40.773784724458)	19	4	19	13
953	953	-73.9547959269955	40.7925162926273	36H-PM-1008-01	36H	PM	10082018	1	Adult	Gray	White	Gray+White	white belly	Above Ground	20		true	false	true	false	true		true	true	false	false	false	false	true	false		POINT (-73.9547959269955 40.7925162926273)	19	4	19	13
1250	1250	-73.9585133340331	40.7963721679474	38C-PM-1014-03	38C	PM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	true	true		true	false	false	false	false	false	false	true		POINT (-73.9585133340331 40.7963721679474)	19	4	19	13
1502	1502	-73.9705254801	40.7763606494306	13E-AM-1017-03	13E	AM	10172018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		false	false	false	true	true		true	false	false	false	false	false	false	true	acknowledges	POINT (-73.9705254801 40.7763606494306)	19	4	19	13
1514	1514	-73.9548006161673	40.7945503341011	38G-PM-1020-08	38G	PM	10202018	8	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	false	false	true	true		true	false	false	true	false	false	true	false		POINT (-73.9548006161673 40.7945503341011)	19	4	19	13
2069	2069	-73.9538377039825	40.7980605334961	42E-PM-1012-03	42E	PM	10122018	3	Adult	Gray	White	Gray+White		Above Ground	20	in tree	false	false	true	false	true		true	false	false	false	false	false	true	false		POINT (-73.9538377039825 40.7980605334961)	19	4	19	13
2300	2300	-73.9789251806378	40.7699558513225	4B-AM-1010-02	04B	AM	10102018	2	Juvenile	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	30		false	false	true	true	true		true	false	false	false	false	false	true	false		POINT (-73.9789251806378 40.7699558513225)	19	4	19	13
2657	2657	-73.9582150734453	40.7962862794303	38C-AM-1019-08	38C	AM	10192018	8	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		true	false	false	false	true		true	false	false	false	false	false	true	false		POINT (-73.9582150734453 40.7962862794303)	19	4	19	13
2710	2710	-73.9577919365342	40.7960853285059	38C-PM-1014-08	38C	PM	10142018	8	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		true	false	false	false	true		true	false	false	false	false	false	false	true		POINT (-73.9577919365342 40.7960853285059)	19	4	19	13
2712	2712	-73.9682760864462	40.7780727569417	16E-PM-1018-04	16E	PM	10182018	4	Adult	Gray		Gray+		Ground Plane	FALSE		false	false	false	false	true		true	false	false	false	false	false	true	false		POINT (-73.9682760864462 40.7780727569417)	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
);