squirrels

5 rows where Above Ground Sighter Measurement = 7 and Runs from = "true"

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	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
526	526	-73.9680833729772	40.7741871025115	12H-PM-1007-08	12H	PM	10072018	8				+	Above Ground	7	in tree	false	false	false	false	false		false	false	false	false	false	false	false	true	POINT (-73.9680833729772 40.7741871025115)	19	4	19	13
984	984	-73.9672950266018	40.7782477517567	17F-PM-1020-01	17F	PM	10202018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	7		false	false	true	false	false		false	false	false	false	false	false	false	true	POINT (-73.9672950266018 40.7782477517567)	19	4	19	13
1011	1011	-73.9719111470164	40.7758789855474	12D-AM-1013-02	12D	AM	10132018	2	Adult	Gray		Gray+	Above Ground	7	Was on top of the edge of Bow Bridge	false	false	false	false	false	jumped off	false	false	false	true	false	false	false	true	POINT (-73.9719111470164 40.7758789855474)	19	4	19	13
2090	2090	-73.9569759970802	40.7931497452294	35F-PM-1012-03	35F	PM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	7		false	false	true	true	true		false	false	false	false	false	false	false	true	POINT (-73.9569759970802 40.79314974522941)	19	4	19	13
2731	2731	-73.9595886063173	40.7918405182594	33D-AM-1017-09	33D	AM	10172018	9	Adult	Black	Cinnamon	Black+Cinnamon	Above Ground	7		false	false	true	false	false		true	true	false	false	false	false	true	true	POINT (-73.9595886063173 40.7918405182594)	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
);