squirrels

12 rows where Date = 10192018, Foraging = "false" 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
53	53	-73.9584970643213	40.7982886348696	40B-AM-1019-03	40B	AM	10192018	3	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		true	true	false	false	false	false	false	false	false	true	true	false	false		POINT (-73.9584970643213 40.7982886348696)	19	4	19	13
172	172	-73.958535640774	40.7982737896998	40B-AM-1019-02	40B	AM	10192018	2	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		true	true	false	false	false	false	false	false	false	true	false	false	false		POINT (-73.958535640774 40.7982737896998)	19	4	19	13
209	209	-73.9710760196868	40.7725506006789	10F-PM-1019-02	10F	PM	10192018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Cinnamon head & stripe	Ground Plane	FALSE	Behind fence, grass	true	false	false	false	false	false	false	false	false	true	false	false	true		POINT (-73.9710760196868 40.7725506006789)	19	4	19	13
1316	1316	-73.9674724790652	40.7768771349868	15G-PM-1019-01	15G	PM	10192018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	true	false	false	false	false	false	true	false	true	false		POINT (-73.9674724790652 40.7768771349868)	19	4	19	13
1381	1381	-73.9586077039567	40.7961896477077	38C-AM-1019-10	38C	AM	10192018	10	Adult	Gray	White	Gray+White		Above Ground	20		true	false	true	true	false	true	false	false	false	true	false	false	true		POINT (-73.9586077039567 40.7961896477077)	19	4	19	13
1410	1410	-73.9587913289229	40.7961707624534	38C-AM-1019-11	38C	AM	10192018	11	Adult	Gray	White	Gray+White		Above Ground	20		true	false	true	true	false	true	false	false	false	true	false	false	true		POINT (-73.9587913289229 40.7961707624534)	19	4	19	13
1524	1524	-73.9725961508316	40.7795720444974	16A-PM-1019-06	16A	PM	10192018	6	Juvenile	Gray		Gray+		Ground Plane	FALSE		true	false	false	false	false	false	false	false	false	true	false	false	true		POINT (-73.9725961508316 40.7795720444974)	19	4	19	13
1688	1688	-73.9677593344667	40.7763054313195	15G-PM-1019-07	15G	PM	10192018	7	Adult			+		Above Ground	5		false	true	false	false	false	false	false	false	false	true	false	false	false		POINT (-73.9677593344667 40.7763054313195)	19	4	19	13
2153	2153	-73.9797122322834	40.7678347587435	1B-PM-1019-10	01B	PM	10192018	10	Adult	Cinnamon	White	Cinnamon+White		Above Ground		Dog chased up tree	false	false	true	false	false	false	false	false	false	true	false	false	false		POINT (-73.97971223228342 40.7678347587435)	19	4	19	13
2320	2320	-73.9576897478787	40.7964695328457	38C-AM-1019-02	38C	AM	10192018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		true	false	false	false	false	false	false	false	false	true	false	true	false		POINT (-73.9576897478787 40.7964695328457)	19	4	19	13
2342	2342	-73.9533645762606	40.7983709215535	42F-AM-1019-01	42F	AM	10192018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	false	false	false	false	false	false	true	false	false	true	runs from (me)	POINT (-73.9533645762606 40.7983709215535)	19	4	19	13
2904	2904	-73.9720389756717	40.7763524091989	13C-PM-1019-02	13C	PM	10192018	2	Adult	Gray		Gray+		Ground Plane	FALSE		true	false	false	false	false	false	false	false	false	true	false	true	false		POINT (-73.9720389756717 40.7763524091989)	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
);