squirrels

15 rows where Hectare Squirrel Number = 8 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	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
724	724	-73.9532952763106	40.7920074462622	36I-AM-1017-08	36I	AM	10172018	8	Adult	Gray		Gray+		Ground Plane	FALSE		false	true	false	false	false	chasing (#7)	false	false	false	false	true	false	false	true	runs from (me)	POINT (-73.95329527631061 40.7920074462622)	19	4	19	13
839	839	-73.9615602805554	40.7945662185621	35A-PM-1013-08	35A	PM	10132018	8	Adult	Gray	White	Gray+White		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	true	false	false	true		POINT (-73.9615602805554 40.7945662185621)	19	4	19	13
895	895	-73.9786898656279	40.7720833097065	6A-AM-1006-08	06A	AM	10062018	8	Adult	Gray	White	Gray+White		Ground Plane	FALSE		true	false	false	true	true		false	false	false	false	true	false	true	false		POINT (-73.9786898656279 40.77208330970651)	19	4	19	13
1000	1000	-73.9805137046778	40.769275143797	2A-AM-1010-08	02A	AM	10102018	8	Adult	Gray		Gray+	Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		true	false	false	false	true		false	false	false	false	true	false	false	false		POINT (-73.9805137046778 40.769275143797)	19	4	19	13
1106	1106	-73.9702970919317	40.7696883113413	7H-PM-1006-08	07H	PM	10062018	8	Adult	Gray	White	Gray+White		Ground Plane	FALSE	in grass	false	false	false	false	true		false	false	false	false	true	true	false	true		POINT (-73.9702970919317 40.7696883113413)	19	4	19	13
1820	1820	-73.9546337446865	40.7898772579576	33I-PM-1006-08	33I	PM	10062018	8	Adult	Gray		Gray+		Above Ground	6		false	false	true	false	false		false	false	false	false	true	false	true	false		POINT (-73.9546337446865 40.7898772579576)	19	4	19	13
2099	2099	-73.9685612289881	40.7778488829217	16E-PM-1018-08	16E	PM	10182018	8	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	true	false	true	false		POINT (-73.9685612289881 40.7778488829217)	19	4	19	13
2255	2255	-73.9642967875857	40.7815652353937	21F-AM-1018-08	21F	AM	10182018	8	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	true	false	true	false		POINT (-73.9642967875857 40.7815652353937)	19	4	19	13
2433	2433	-73.9706949930717	40.772362045852	10G-AM-1006-08	10G	AM	10062018	8	Adult	Black	Cinnamon	Black+Cinnamon		Above Ground	3		false	false	false	true	false		false	false	false	true	true	false	true	false		POINT (-73.9706949930717 40.772362045852)	19	4	19	13
2535	2535	-73.9700101107283	40.7696729501144	7I-PM-1013-08	07I	PM	10132018	8	Adult	Black		Black+		Above Ground	4		false	false	true	false	false		false	false	false	false	true	false	false	false		POINT (-73.9700101107283 40.7696729501144)	19	4	19	13
2723	2723	-73.960642602756	40.7917265419842	32D-PM-1006-08	32D	PM	10062018	8	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	true	false	false	false	stand on two feet and watching me	POINT (-73.960642602756 40.7917265419842)	19	4	19	13
2801	2801	-73.9697665830132	40.7759094917104	13E-PM-1008-08	13E	PM	10082018	8	Juvenile	Cinnamon	Black, White	Cinnamon+Black, White		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	true	false	true	false		POINT (-73.9697665830132 40.7759094917104)	19	4	19	13
2963	2963	-73.9687020800791	40.7735903424522	11H-AM-1010-08	11H	AM	10102018	8	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	true	false	false	true		POINT (-73.9687020800791 40.7735903424522)	19	4	19	13
3004	3004	-73.9528482858163	40.7922056218325	36I-PM-1007-08	36I	PM	10072018	8	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		false	false	false	true	false		false	false	false	false	true	false	true	false		POINT (-73.9528482858163 40.7922056218325)	19	4	19	13
3015	3015	-73.9759163300535	40.7736180793606	9B-AM-1010-08	09B	AM	10102018	8	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Cinnamon head, White (Almost Silver)	Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	true	false	false	false		POINT (-73.9759163300535 40.7736180793606)	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
);