squirrels

11 rows where Above Ground Sighter Measurement = 6 and Foraging = "true" sorted by Approaches

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
21	21	-73.9703781726172	40.7787526130321	16C-PM-1018-03	16C	PM	10182018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	6		true	false	false	true	true		false	false	false	false	false	false	true	false		POINT (-73.9703781726172 40.7787526130321)	19	4	19	13
1020	1020	-73.97016933635	40.7705452529783	8H-AM-1017-05	08H	AM	10172018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	6		true	false	false	true	true		false	false	false	false	false	false	true	false		POINT (-73.97016933635001 40.7705452529783)	19	4	19	13
1385	1385	-73.9615649773504	40.7954761311501	36A-PM-1013-02	36A	PM	10132018	2		Gray	Cinnamon	Gray+Cinnamon		Above Ground	6		false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9615649773504 40.7954761311501)	19	4	19	13
1396	1396	-73.9704677007779	40.7786860108302	16C-PM-1018-02	16C	PM	10182018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	6		false	true	false	true	true		false	false	false	false	true	false	true	false		POINT (-73.9704677007779 40.7786860108302)	19	4	19	13
1566	1566	-73.9695133370801	40.7765009796853	14E-AM-1008-16	14E	AM	10082018	16	Adult	Gray		Gray+		Above Ground	6		false	false	true	true	true		false	false	false	false	false	false	true	false		POINT (-73.9695133370801 40.7765009796853)	19	4	19	13
1686	1686	-73.9593373093799	40.7982428507976	39A-PM-1014-03	39A	PM	10142018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Higlights. Made executive adjustments.	Above Ground	6	Jumped from ground onto branch	false	false	false	false	true	digging?	false	false	false	false	true	false	true	false		POINT (-73.95933730937992 40.7982428507976)	19	4	19	13
1776	1776	-73.9562350820255	40.7913464147989	34G-PM-1006-02	34G	PM	10062018	2	Adult	Gray		Gray+		Above Ground	6		false	false	true	true	true	eating bread it found on ground	false	false	false	false	false	false	false	true		POINT (-73.9562350820255 40.7913464147989)	19	4	19	13
2177	2177	-73.9758211560957	40.7693422860766	5E-AM-1008-10	05E	AM	10082018	10	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	6	up a tree	true	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9758211560957 40.7693422860766)	19	4	19	13
2179	2179	-73.9559663949511	40.7974497269789	40D-AM-1013-07	40D	AM	10132018	7	Adult	Gray		Gray+		Above Ground	6		false	false	true	false	true		false	false	false	false	false	false	false	true	curious	POINT (-73.9559663949511 40.7974497269789)	19	4	19	13
2870	2870	-73.9538475741188	40.796479421955	40F-PM-1006-02	40F	PM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	6		false	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9538475741188 40.796479421955)	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

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