squirrels

11 rows where Climbing = "true", Combination of Primary and Highlight Color = "Gray+Cinnamon, White", Hectare Squirrel Number = 2 and Police Precincts = 13 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	Other Activities ▼	Kuks	Quaas	Moans	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
230	230	-73.9731498064872	40.7659963196581	2H-AM-1006-02	02H	AM	10062018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		false	true	true	false	false		false	false	false	false	false	true	false	false	POINT (-73.9731498064872 40.7659963196581)	19	4	19	13
776	776	-73.9686816795392	40.775770422667	14F-PM-1012-02	14F	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	3		false	false	true	true	false		false	false	false	false	false	false	true	false	POINT (-73.9686816795392 40.775770422667)	19	4	19	13
1201	1201	-73.9782813538421	40.7715730368712	6A-AM-1006-02	06A	AM	10062018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	30	tree	false	true	true	false	false		false	false	false	true	false	false	false	false	POINT (-73.9782813538421 40.7715730368712)	19	4	19	13
1220	1220	-73.9779983794849	40.7675452099173	2D-AM-1007-02	02D	AM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	6	up tree	false	true	true	false	false		false	false	false	false	false	false	false	false	POINT (-73.9779983794849 40.7675452099173)	19	4	19	13
1576	1576	-73.9619985187616	40.7943277743532	34A-AM-1012-02	34A	AM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	10	chasing from tree to ground	true	true	true	false	false		false	false	false	false	false	false	true	false	POINT (-73.9619985187616 40.7943277743532)	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
2829	2829	-73.9565230963554	40.798556387711	41C-PM-1007-02	41C	PM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		true	false	true	false	false		false	false	false	false	false	false	false	false	POINT (-73.9565230963554 40.798556387711)	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
2916	2916	-73.9517525111679	40.7974407641075	42G-PM-1014-02	42G	PM	10142018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	14		false	false	true	true	false		false	false	false	false	false	false	true	false	POINT (-73.9517525111679 40.7974407641075)	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
1595	1595	-73.9754696312232	40.768191647092	4E-AM-1020-02	04E	AM	10202018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	White selected as Primary. Cinnamon selected as Highlights. Made executive adjustments.	Above Ground	15		false	false	true	false	true	foraging (on the tree itself)	false	false	false	false	false	false	true	false	POINT (-73.9754696312232 40.768191647092)	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
);