squirrels

11 rows where Above Ground Sighter Measurement = 7 and Climbing = "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
112	112	-73.9651754464439	40.7755181941559	15I-AM-1008-01	15I	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	7	tree	false	false	true	true	false		false	false	false	false	false	false	true	false		POINT (-73.9651754464439 40.7755181941559)	19	4	19	13
243	243	-73.9754778808471	40.7685619029765	4E-AM-1020-01	04E	AM	10202018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	White selected as Primary. Cinnamon selected as Highlights. Made executive adjustments.	Above Ground	7		false	false	true	false	false	sitting very still	false	false	false	false	false	false	true	false		POINT (-73.9754778808471 40.7685619029765)	19	4	19	13
286	286	-73.9720907384613	40.7762987836055	13C-PM-1019-01	13C	PM	10192018	1	Adult	Gray		Gray+		Above Ground	7		false	false	true	false	false		true	false	false	false	false	false	true	false		POINT (-73.9720907384613 40.7762987836055)	19	4	19	13
984	984	-73.9672950266018	40.7782477517567	17F-PM-1020-01	17F	PM	10202018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	7		false	false	true	false	false		false	false	false	false	false	false	false	true		POINT (-73.9672950266018 40.7782477517567)	19	4	19	13
1099	1099	-73.9761527947483	40.7709607002539	6C-AM-1007-06	06C	AM	10072018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	7		false	false	true	false	false		false	false	false	false	false	false	false	false	disappeared when jogger ran by	POINT (-73.9761527947483 40.7709607002539)	19	4	19	13
1413	1413	-73.9810032206428	40.7681625634979	1A-AM-1007-01	01A	AM	10072018	1	Adult	Gray	White	Gray+White		Above Ground	7		false	false	true	false	false		false	false	false	false	true	false	true	false		POINT (-73.9810032206428 40.7681625634979)	19	4	19	13
1943	1943	-73.9690447463294	40.783913304529	21B-AM-1019-06	21B	AM	10192018	6	Juvenile	Gray		Gray+		Above Ground	7		false	false	true	true	false		false	false	false	false	false	false	true	false		POINT (-73.9690447463294 40.78391330452901)	19	4	19	13
2090	2090	-73.9569759970802	40.7931497452294	35F-PM-1012-03	35F	PM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	7		false	false	true	true	true		false	false	false	false	false	false	false	true		POINT (-73.9569759970802 40.79314974522941)	19	4	19	13
2474	2474	-73.9721448879766	40.7762112840981	13C-AM-1010-02	13C	AM	10102018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	7		false	false	true	false	false	burying	false	false	false	false	false	false	true	false		POINT (-73.9721448879766 40.7762112840981)	19	4	19	13
2731	2731	-73.9595886063173	40.7918405182594	33D-AM-1017-09	33D	AM	10172018	9	Adult	Black	Cinnamon	Black+Cinnamon		Above Ground	7		false	false	true	false	false		true	true	false	false	false	false	true	true		POINT (-73.9595886063173 40.7918405182594)	19	4	19	13
3017	3017	-73.9662895079734	40.7843300758044	23C-AM-1019-01	23C	AM	10192018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. Gray, Cinnamon & White selected as Highlights. Made executive adjustments.	Above Ground	7		false	false	true	true	false	eating (on branch)	true	false	false	false	false	false	true	false		POINT (-73.9662895079734 40.7843300758044)	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
);