squirrels

16 rows where Hectare Squirrel Number = 10 and Location = "Above Ground" sorted by Community Districts

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
399	399	-73.9763433202401	40.7738473490681	9B-PM-1013-10	09B	PM	10132018	10	Juvenile	Cinnamon	Gray	Cinnamon+Gray	"Brown" written in as Primary	Above Ground	12		false	false	false	true	false		false	false	false	false	false	false	true	false		POINT (-73.9763433202401 40.7738473490681)	19	4	19	13
935	935	-73.9666195118963	40.7839216739357	22C-PM-1006-10	22C	PM	10062018	10	Adult	Gray		Gray+		Above Ground	13		false	false	true	false	false		true	false	false	false	false	false	false	false		POINT (-73.9666195118963 40.78392167393571)	19	4	19	13
1070	1070	-73.9674631254594	40.7790076357696	17E-AM-1017-10	17E	AM	10172018	10	Juvenile	Gray		Gray+		Above Ground	2	Fence	true	false	false	false	false		false	false	false	false	false	false	false	true		POINT (-73.9674631254594 40.7790076357696)	19	4	19	13
1081	1081	-73.9680855277775	40.7769251965381	15F-AM-1007-10	15F	AM	10072018	10	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	20		true	false	true	false	false		false	false	false	false	false	false	false	true		POINT (-73.9680855277775 40.7769251965381)	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
1662	1662	-73.9561600237284	40.7953143196705	38E-AM-1010-10	38E	AM	10102018	10	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1	over a log across stream	false	false	false	false	false	chillin'	false	false	false	false	false	false	false	true	runs from leaf blower	POINT (-73.9561600237284 40.7953143196705)	19	4	19	13
1788	1788	-73.9685567075413	40.7703797723105	8I-AM-1006-10	08I	AM	10062018	10	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	3	bush	false	false	true	false	false		false	false	false	false	false	false	false	true		POINT (-73.96855670754131 40.7703797723105)	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
2177	2177	-73.9758211560957	40.7693422860766	5E-AM-1008-10	05E	AM	10082018	10	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	6	up a tree	true	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9758211560957 40.7693422860766)	19	4	19	13
2215	2215	-73.9674978826751	40.776288410765	15G-PM-1019-10	15G	PM	10192018	10	Adult	Gray		Gray+		Above Ground	1	on a log	false	false	false	true	false		false	false	false	false	false	false	false	true		POINT (-73.9674978826751 40.776288410765)	19	4	19	13
2288	2288	-73.9577009571427	40.796126044521	38C-PM-1014-10	38C	PM	10142018	10	Juvenile	Gray	White	Gray+White		Above Ground	10		false	false	true	true	true	climbing (down from ~10')	false	false	false	false	false	false	false	true		POINT (-73.9577009571427 40.796126044521)	19	4	19	13
2303	2303	-73.9589470461357	40.7912817646361	33E-AM-1014-10	33E	AM	10142018	10	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	15		false	true	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9589470461357 40.7912817646361)	19	4	19	13
2308	2308	-73.9688574856542	40.7780770207023	16E-AM-1014-10	16E	AM	10142018	10	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	25		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9688574856542 40.7780770207023)	19	4	19	13
2335	2335	-73.9704679459444	40.7773384236212	14D-PM-1019-10	14D	PM	10192018	10	Adult	Gray		Gray+		Above Ground	20		false	false	true	false	false		false	false	false	true	false	false	false	true		POINT (-73.9704679459444 40.7773384236212)	19	4	19	13
2503	2503	-73.974382557804	40.7674812627373	3F-AM-1006-10	03F	AM	10062018	10	Adult	Cinnamon	White	Cinnamon+White		Above Ground	6	on fence	false	false	true	false	false		false	false	false	false	false	false	false	false	clueless	POINT (-73.974382557804 40.7674812627373)	19	4	19	13
2965	2965	-73.9767389132988	40.7689323691424	4D-PM-1008-10	04D	PM	10082018	10	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	6	climbed the fence & posed for a picture	false	false	true	false	true		false	false	false	false	false	true	false	false		POINT (-73.9767389132988 40.7689323691424)	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
);