squirrels

9 rows where Approaches = "true", Climbing = "true" and Shift = "PM" 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	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
682	682	-73.9651828383592	40.7802820943863	19F-PM-1017-06	19F	PM	10172018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		true	true	true	false	false		false	false	false	false	true	true	false	false		POINT (-73.9651828383592 40.7802820943863)	19	4	19	13
859	859	-73.9600964585868	40.7952339524416	36B-PM-1013-02	36B	PM	10132018	2	Adult	Gray	White	Gray+White	Ground Plane	FALSE		true	false	true	false	false		false	false	false	false	true	true	false	true		POINT (-73.9600964585868 40.7952339524416)	19	4	19	13
1683	1683	-73.9790889008147	40.7676402781925	1C-PM-1013-01	01C	PM	10132018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Ground Plane	FALSE		false	false	true	false	true		false	false	false	false	false	true	false	false		POINT (-73.9790889008147 40.7676402781925)	19	4	19	13
2187	2187	-73.9699134052609	40.774446589038	12F-PM-1007-14	12F	PM	10072018	14	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		false	false	true	true	true		false	false	false	false	false	true	true	false		POINT (-73.9699134052609 40.774446589038)	19	4	19	13
2380	2380	-73.9761375729505	40.7662231892125	1F-PM-1019-02	01F	PM	10192018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	2		false	false	true	true	false		false	false	false	false	false	true	false	false		POINT (-73.9761375729505 40.7662231892125)	19	4	19	13
2762	2762	-73.9656324462902	40.7834034753081	22E-PM-1014-02	22E	PM	10142018	2	Adult	Gray		Gray+	Above Ground	6		false	false	true	false	false		false	false	false	false	false	true	false	false		POINT (-73.9656324462902 40.7834034753081)	19	4	19	13
2942	2942	-73.9672063784809	40.7826070395665	21D-PM-1008-01	21D	PM	10082018	1		Gray		Gray+	Above Ground	8		false	false	true	false	false		false	false	false	false	false	true	false	false		POINT (-73.9672063784809 40.7826070395665)	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
1442	1442	-73.961241953418	40.7941677113011	35B-PM-1013-07	35B	PM	10132018	7	Adult	Gray		Gray+	Ground Plane	FALSE		true	false	true	true	false	got fed twice by grandpa,grabbed from grass and ate in tree	false	false	false	false	false	true	true	true	approaches (grandpa with food),runs from (kid),kid was slowly creeping up on it; it eventually climbed up.	POINT (-73.961241953418 40.7941677113011)	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
);