squirrels

8 rows where Above Ground Sighter Measurement = 20 and Date = 10122018

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	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
565	565	-73.9615402629655	40.7924082330328	33C-AM-1012-02	33C	AM	10122018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon along back & tail	Above Ground	20	tree branches	false	true	true	false	false		false	false	false	false	false	false	true	false	POINT (-73.9615402629655 40.7924082330328)	19	4	19	13
698	698	-73.9585537668382	40.7903905787005	32F-AM-1012-03	32F	AM	10122018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		false	false	true	false	false	bringing green leaves to nest	false	false	false	false	false	false	false	false	POINT (-73.9585537668382 40.7903905787005)	19	4	19	13
1123	1123	-73.9670858934045	40.7753505024976	14H-PM-1012-02	14H	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	20		true	false	false	true	true		false	false	false	false	false	false	true	false	POINT (-73.9670858934045 40.7753505024976)	19	4	19	13
1641	1641	-73.9653135277149	40.7817434070169	21E-PM-1012-01	21E	PM	10122018	1	Adult	Gray		Gray+		Above Ground	20	in tree	false	false	true	false	false		false	false	false	false	false	false	false	false	POINT (-73.9653135277149 40.7817434070169)	19	4	19	13
2069	2069	-73.9538377039825	40.7980605334961	42E-PM-1012-03	42E	PM	10122018	3	Adult	Gray	White	Gray+White		Above Ground	20	in tree	false	false	true	false	true		true	false	false	false	false	false	true	false	POINT (-73.9538377039825 40.7980605334961)	19	4	19	13
2390	2390	-73.9680741975294	40.7847036778165	23B-PM-1012-04	23B	PM	10122018	4	Adult	Gray	White	Gray+White		Above Ground	20		false	false	false	false	false	watching me - didn't move	false	false	false	false	true	false	false	true	POINT (-73.9680741975294 40.7847036778165)	19	4	19	13
2872	2872	-73.9615396457996	40.7923594366783	33C-AM-1012-01	33C	AM	10122018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon along tail & back	Above Ground	20	tree branches	false	true	true	false	false		false	false	false	false	false	false	true	false	POINT (-73.9615396457996 40.7923594366783)	19	4	19	13
2903	2903	-73.9670432105975	40.7753462013506	14H-PM-1012-03	14H	PM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	20		true	false	false	true	true		false	false	false	false	false	false	true	false	POINT (-73.9670432105975 40.7753462013506)	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
);