squirrels

14 rows where Approaches = "true", Climbing = "true" and Location = "Ground Plane"

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
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
257	257	-73.9773317054464	40.7684035996758	3D-AM-1006-03	03D	AM	10062018	3	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE	on top [of] a big rock/boulder in the area	true	false	true	false	false	climbing (rock)	false	false	false	false	false	true	false	false	approaches (slightly),wary of humans	POINT (-73.9773317054464 40.76840359967581)	19	4	19	13
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
738	738	-73.9725712588741	40.7669101832926	4H-AM-1006-02	04H	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	false	true	false	false	climbing (over small wire fence then on the ground)	false	false	false	false	false	true	false	true	approaches (saw me & came forward),runs from (startled by another person)	POINT (-73.9725712588741 40.7669101832926)	19	4	19	13
850	850	-73.9642288873015	40.7820439983567	22F-AM-1007-06	22F	AM	10072018	6	Adult	Cinnamon		Cinnamon+	Ground Plane	FALSE		false	false	true	true	false		false	false	false	false	false	true	false	false		POINT (-73.9642288873015 40.7820439983567)	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
1215	1215	-73.9728895595977	40.7699378332299	6F-AM-1006-01	06F	AM	10062018	1	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		false	false	true	true	false		false	false	false	false	false	true	false	false		POINT (-73.9728895595977 40.7699378332299)	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
1591	1591	-73.9576223390082	40.7979746639647	40B-AM-1019-04	40B	AM	10192018	4	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		false	false	true	false	true		false	false	false	false	false	true	true	false		POINT (-73.9576223390082 40.79797466396471)	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
1862	1862	-73.9764851231754	40.7715736862861	6C-AM-1007-07	06C	AM	10072018	7	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	false	true	false	false	ambling	false	false	false	false	false	true	false	true	trucks	POINT (-73.9764851231754 40.7715736862861)	19	4	19	13
2044	2044	-73.9771552326199	40.7706917595308	5C-AM-1006-01	05C	AM	10062018	1	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE		true	false	true	false	false		false	false	false	true	false	true	false	false		POINT (-73.9771552326199 40.7706917595308)	19	4	19	13
2123	2123	-73.959874668294	40.7907004233491	32E-AM-1007-09	32E	AM	10072018	9	Adult	Gray	White	Gray+White	Ground Plane	FALSE		false	false	true	false	false		false	false	false	false	false	true	false	false		POINT (-73.959874668294 40.7907004233491)	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

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
);