squirrels

9 rows where Above Ground Sighter Measurement = 5, Climbing = "true" and Highlight Fur Color = "Cinnamon"

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	Kuks	Quaas	Moans	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
135	135	-73.9694168118643	40.7728877377977	11G-PM-1013-01	11G	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	5	In the Woods/Brush	false	false	true	false	true	false	false	false	false	false	false	false	true	watching me	POINT (-73.9694168118643 40.7728877377977)	19	4	19	13
201	201	-73.9598015842806	40.7973522744237	38A-PM-1013-03	38A	PM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	5		false	false	true	false	false	false	false	false	false	false	false	true	false		POINT (-73.9598015842806 40.7973522744237)	19	4	19	13
462	462	-73.9661785940531	40.7742569936186	13I-PM-1008-01	13I	PM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	5	climbed tree	true	false	true	false	false	false	false	false	false	false	false	true	false		POINT (-73.9661785940531 40.7742569936186)	19	4	19	13
765	765	-73.96797780019	40.7847629473258	23B-PM-1012-05	23B	PM	10122018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	5	chain link fence	false	true	true	false	false	false	false	false	false	false	false	true	false		POINT (-73.96797780019 40.7847629473258)	19	4	19	13
1128	1128	-73.9638599044346	40.7809288795308	21G-AM-1014-06	21G	AM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	5		false	true	true	false	false	false	false	false	false	false	false	false	false		POINT (-73.9638599044346 40.7809288795308)	19	4	19	13
1921	1921	-73.9756278240233	40.7669523701372	2F-AM-1006-02	02F	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	5	in tree	false	false	true	false	false	false	false	false	false	false	false	true	false		POINT (-73.9756278240233 40.7669523701372)	19	4	19	13
2559	2559	-73.9572383478774	40.7876857380722	30H-PM-1006-01	30H	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	5		false	false	true	false	false	false	false	false	false	true	false	true	false		POINT (-73.9572383478774 40.7876857380722)	19	4	19	13
2592	2592	-73.9758128509653	40.7715946097064	7C-PM-1020-03	07C	PM	10202018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	5		false	false	true	false	false	false	false	false	false	false	false	false	false		POINT (-73.9758128509653 40.7715946097064)	19	4	19	13
2748	2748	-73.960094705031	40.7916066137699	33D-AM-1017-01	33D	AM	10172018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	5		false	false	true	false	false	false	false	false	false	false	false	true	false		POINT (-73.960094705031 40.7916066137699)	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
);