squirrels

5 rows where Above Ground Sighter Measurement = 2 and Date = 10172018

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
105	105	-73.9589249555235	40.7908193284981	32E-PM-1017-03	32E	PM	10172018	3	Adult	Gray		Gray+	Above Ground	2	bottom of tree	false	false	false	true	false	still	false	false	false	false	false	false	true	false	POINT (-73.9589249555235 40.7908193284981)	19	4	19	13
805	805	-73.9706851546184	40.7780777016038	15D-PM-1017-04	15D	PM	10172018	4	Adult	Cinnamon		Cinnamon+	Above Ground	2	on fence	true	false	false	false	false		false	false	false	false	false	false	true	false	POINT (-73.9706851546184 40.7780777016038)	19	4	19	13
1070	1070	-73.9674631254594	40.7790076357696	17E-AM-1017-10	17E	AM	10172018	10	Juvenile	Gray		Gray+	Above Ground	2	Fence	true	false	false	false	false		false	false	false	false	false	false	false	true	POINT (-73.9674631254594 40.7790076357696)	19	4	19	13
1777	1777	-73.9711751356843	40.7752422758202	12E-AM-1017-06	12E	AM	10172018	6	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground	2		false	false	false	true	true		false	false	false	false	false	false	true	false	POINT (-73.9711751356843 40.7752422758202)	19	4	19	13
2694	2694	-73.969628583287	40.7704067797932	8H-AM-1017-03	08H	AM	10172018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	2	fence	true	false	false	false	true		false	false	false	false	false	false	true	false	POINT (-73.969628583287 40.7704067797932)	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
);