squirrels

7 rows where Climbing = "true", Date = 10122018 and Tail twitches = "true" sorted by Other Activities

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	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
820	820	-73.9801902133148	40.769557595068	3A-AM-1012-03	03A	AM	10122018	3	Juvenile	Gray	Black, Cinnamon	Gray+Black, Cinnamon	Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments.	Above Ground	1		false	false	true	false	false	false	false	false	false	true	false	false	true	POINT (-73.9801902133148 40.769557595068)	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
2511	2511	-73.9584561537421	40.7911211164754	33F-PM-1012-02	33F	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	false	true	true	true	false	false	false	false	true	false	false	false	POINT (-73.9584561537421 40.7911211164754)	19	4	19	13
2598	2598	-73.976658503418	40.7686868456917	4D-AM-1012-03	04D	AM	10122018	3	Adult	Gray		Gray+		Ground Plane	FALSE		false	true	true	false	false	false	false	false	false	true	false	true	false	POINT (-73.976658503418 40.7686868456917)	19	4	19	13
2745	2745	-73.97296259363	40.7652601851275	1I-PM-1012-04	01I	PM	10122018	4	Juvenile	Cinnamon	White	Cinnamon+White	Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments.	Above Ground	2	on ledge	false	false	true	false	false	false	false	false	false	true	false	false	true	POINT (-73.97296259363 40.7652601851275)	19	4	19	13
2898	2898	-73.9794118234651	40.7674495540569	1C-AM-1012-02	01C	AM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		false	false	true	false	false	false	false	false	false	true	false	false	true	POINT (-73.9794118234651 40.7674495540569)	19	4	19	13
2988	2988	-73.9766342759486	40.7687518380873	4D-AM-1012-04	04D	AM	10122018	4	Adult	Gray		Gray+		Above Ground	3	on tree trunk	false	true	true	false	false	false	false	false	false	true	false	true	false	POINT (-73.9766342759486 40.7687518380873)	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
);