squirrels

10 rows where Highlight Fur Color = "Cinnamon" and Location = "" sorted by Longitude

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	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
2836	2836	-73.953092053256	40.7982256930243	42F-PM-1017-03	42F	PM	10172018	3		Gray	Cinnamon	Gray+Cinnamon	true	false	false	false	false		false	false	false	false	false	false	true	false	POINT (-73.953092053256 40.7982256930243)	19	4	19	13
1064	1064	-73.9540257319561	40.798408619116	42E-PM-1012-02	42E	PM	10122018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon	true	false	true	false	false		false	false	false	false	false	false	true	true	POINT (-73.9540257319561 40.798408619116)	19	4	19	13
2797	2797	-73.9576913492669	40.7994216061391	41B-AM-1010-11	41B	AM	10102018	11	Adult	Gray	Cinnamon	Gray+Cinnamon	false	false	false	true	false	eating a mushroom!	false	false	false	false	false	false	true	false	POINT (-73.9576913492669 40.7994216061391)	19	4	19	13
446	446	-73.9678774314725	40.7738535171265	12H-PM-1007-04	12H	PM	10072018	4		Gray	Cinnamon	Gray+Cinnamon	false	false	false	true	false	mushroom	false	false	false	false	false	false	true	false	POINT (-73.9678774314725 40.7738535171265)	19	4	19	13
398	398	-73.9686737866872	40.7739714023732	12G-PM-1007-06	12G	PM	10072018	6		Gray	Cinnamon	Gray+Cinnamon	false	false	false	false	true		false	false	false	false	false	false	true	false	POINT (-73.9686737866872 40.7739714023732)	19	4	19	13
2737	2737	-73.9703683510176	40.7743975363958	12F-PM-1007-10	12F	PM	10072018	10	Adult	Gray	Cinnamon	Gray+Cinnamon	false	false	false	false	true		false	false	false	false	false	false	true	false	POINT (-73.9703683510176 40.7743975363958)	19	4	19	13
1557	1557	-73.9705331808443	40.7699943571296	7H-AM-1006-09	07H	AM	10062018	9	Adult	Gray	Cinnamon	Gray+Cinnamon	false	false	false	false	true		false	false	false	false	false	true	false	false	POINT (-73.9705331808443 40.7699943571296)	19	4	19	13
1091	1091	-73.97055600791	40.7698499183436	7H-AM-1006-07	07H	AM	10062018	7	Adult	Gray	Cinnamon	Gray+Cinnamon	false	false	false	true	false		false	false	false	false	true	false	true	false	POINT (-73.97055600791 40.7698499183436)	19	4	19	13
1928	1928	-73.9725669210177	40.7681496989029	5H-AM-1007-01	05H	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	false	false	false	false	true		false	false	false	false	false	false	false	false	POINT (-73.9725669210177 40.7681496989029)	19	4	19	13
1878	1878	-73.9761223919286	40.7685998275864	4E-PM-1008-06	04E	PM	10082018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	false	false	false	true	true		false	false	false	false	false	false	true	false	POINT (-73.9761223919286 40.7685998275864)	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
);