squirrels

8 rows where Combination of Primary and Highlight Color = "Cinnamon+Gray, White" and Tail twitches = "true" sorted by Quaas

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
26	26	-73.9649866016038	40.7764929694457	16I-AM-1008-01	16I	AM	10082018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	true	false	true	false	POINT (-73.9649866016038 40.7764929694457)	19	4	19	13
165	165	-73.969058856545	40.7766356226979	14F-PM-1012-06	14F	PM	10122018	6	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	true	false	true	false	POINT (-73.969058856545 40.7766356226979)	19	4	19	13
982	982	-73.9676424599715	40.7777766106807	16F-AM-1008-01	16F	AM	10082018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE	near fence	false	false	false	false	true		false	false	false	false	true	true	false	false	POINT (-73.9676424599715 40.7777766106807)	19	4	19	13
1121	1121	-73.9645060433292	40.7768322057794	16I-AM-1008-03	16I	AM	10082018	3	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	true	false	true	false	POINT (-73.9645060433292 40.7768322057794)	19	4	19	13
2009	2009	-73.9639505810228	40.789573183584	29B-PM-1010-01	29B	PM	10102018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	4	climbing trees	false	false	true	true	true	scratching self	false	false	false	false	true	false	true	false	POINT (-73.9639505810228 40.789573183584)	19	4	19	13
2330	2330	-73.9724618533895	40.7745021602455	11D-AM-1010-02	11D	AM	10102018	2	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		false	false	false	false	true	walking	false	false	false	false	true	false	false	true	POINT (-73.9724618533895 40.7745021602455)	19	4	19	13
2574	2574	-73.978199543688	40.7695660563362	4C-PM-1010-17	04C	PM	10102018	17	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE	climbed up tree	true	false	true	false	true		false	false	false	false	true	false	false	true	POINT (-73.978199543688 40.7695660563362)	19	4	19	13
2989	2989	-73.9643538221947	40.7917565604735	31A-PM-1017-01	31A	PM	10172018	1	Juvenile	Cinnamon	Gray, White	Cinnamon+Gray, White	Gray lower back, Gray & Cinnamon selected as Primary with "lower back" written in next to Gray. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	true	false	false	false	POINT (-73.9643538221947 40.7917565604735)	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
);