squirrels

9 rows where Date = 10182018, Foraging = "true" and Running = "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
120	120	-73.9511118711108	40.7950813345902	40I-AM-1018-01	40I	AM	10182018	1	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		true	false	false	false	true	begging	false	false	false	false	false	false	false	false		POINT (-73.9511118711108 40.7950813345902)	19	4	19	13
442	442	-73.9502466289084	40.7959228779883	41I-AM-1018-02	41I	AM	10182018	2	Juvenile	Gray		Gray+		Ground Plane	FALSE		true	false	false	false	true		false	false	false	false	false	false	false	false	runs off	POINT (-73.9502466289084 40.7959228779883)	19	4	19	13
556	556	-73.9721670042434	40.776085913838	13D-PM-1018-09	13D	PM	10182018	9	Adult	Gray	White	Gray+White		Ground Plane	FALSE		true	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9721670042434 40.776085913838)	19	4	19	13
995	995	-73.9698843507358	40.7803754187581	18C-PM-1018-02	18C	PM	10182018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		true	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9698843507358 40.7803754187581)	19	4	19	13
1242	1242	-73.9714512125212	40.7760275250114	13D-PM-1018-03	13D	PM	10182018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		true	false	false	true	true		false	false	false	false	false	false	true	false		POINT (-73.9714512125212 40.7760275250114)	19	4	19	13
2522	2522	-73.9658747245917	40.7754033737532	14I-PM-1018-01	14I	PM	10182018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground		Fallen branch	true	false	false	false	true		false	false	false	false	true	false	false	true		POINT (-73.9658747245917 40.7754033737532)	19	4	19	13
2838	2838	-73.9507699667119	40.7955166039555	40I-AM-1018-02	40I	AM	10182018	2	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		true	false	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9507699667119 40.795516603955505)	19	4	19	13
320	320	-73.9684376038582	40.7824275067237	20C-PM-1018-09	20C	PM	10182018	9	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		true	false	false	false	true		false	false	false	false	false	true	false	false		POINT (-73.9684376038582 40.7824275067237)	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
);