squirrels

13 rows where Hectare Squirrel Number = 11 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	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
126	126	-73.9792155473689	40.7693711799946	3B-PM-1007-11	03B	PM	10072018	11	Adult	Gray		Gray+	Above Ground	5	in tree	false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9792155473689 40.7693711799946)	19	4	19	13
150	150	-73.9763430829342	40.7686351097159	4D-PM-1008-11	04D	PM	10082018	11	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Above Ground	3	on tree facing downward	false	true	false	false	false	chased #12	true	false	false	true	false	false	false	true		POINT (-73.9763430829342 40.7686351097159)	19	4	19	13
281	281	-73.9619411917909	40.7923536640283	33B-PM-1010-11	33B	PM	10102018	11	Adult	Gray		Gray+	Above Ground	10		false	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9619411917909 40.7923536640283)	19	4	19	13
366	366	-73.9673548527075	40.7765669058396	15G-PM-1019-11	15G	PM	10192018	11	Adult	Gray		Gray+	Above Ground	4		false	false	true	false	false		false	false	false	false	false	false	false	false	stared	POINT (-73.9673548527075 40.7765669058396)	19	4	19	13
683	683	-73.9707683621584	40.7759815566123	13E-AM-1017-11	13E	AM	10172018	11	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground		on/in log	true	false	false	false	false		false	false	false	false	false	false	false	true		POINT (-73.9707683621584 40.77598155661231)	19	4	19	13
1016	1016	-73.9691293546408	40.7703219076549	8I-AM-1006-11	08I	AM	10062018	11	Adult	Gray		Gray+	Above Ground	50	tree	false	true	false	false	false		false	false	false	false	false	false	true	false		POINT (-73.9691293546408 40.77032190765491)	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
1596	1596	-73.9666945123922	40.7839956493194	22C-PM-1006-11	22C	PM	10062018	11	Juvenile	Gray		Gray+	Above Ground	13		false	false	true	false	false		true	false	false	false	false	false	false	false		POINT (-73.9666945123922 40.7839956493194)	19	4	19	13
1631	1631	-73.9527196716568	40.792363826828	36I-PM-1007-11	36I	PM	10072018	11	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Above Ground	3		false	false	true	false	false		false	false	false	false	false	false	false	true	me!	POINT (-73.9527196716568 40.792363826828)	19	4	19	13
1787	1787	-73.9720365327715	40.7762329714016	13D-PM-1018-11	13D	PM	10182018	11	Adult	Gray	White	Gray+White	Above Ground	15		false	false	true	true	false		false	false	false	false	true	false	true	false		POINT (-73.9720365327715 40.7762329714016)	19	4	19	13
2098	2098	-73.9700779726297	40.7722086251085	10G-AM-1006-11	10G	AM	10062018	11	Juvenile	Gray		Gray+	Above Ground	2		false	false	true	false	false		false	false	false	false	true	false	false	false		POINT (-73.9700779726297 40.7722086251085)	19	4	19	13
2653	2653	-73.958932543729	40.7913445531266	33E-AM-1014-11	33E	AM	10142018	11	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.958932543729 40.7913445531266)	19	4	19	13
2868	2868	-73.9653873284496	40.7804699882574	20F-PM-1007-11	20F	PM	10072018	11	Adult	Gray	White	Gray+White	Above Ground	10	in tree	false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9653873284496 40.7804699882574)	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
);