squirrels

8 rows where Combination of Primary and Highlight Color = "Black+" 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	Combination of Primary and Highlight Color	Location	Above Ground Sighter Measurement	Running	Chasing	Climbing	Eating	Foraging	Other Activities	Kuks	Quaas ▼	Moans	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
381	381	-73.959709414696	40.7919745085986	33D-PM-1006-03	33D	PM	10062018	3		Black	Black+	Above Ground	15	true	false	false	true	false		false	false	false	false	true	false	false	true	ran up tree	POINT (-73.959709414696 40.7919745085986)	19	4	19	13
546	546	-73.9547423290276	40.7899702628835	33I-PM-1006-09	33I	PM	10062018	9	Adult	Black	Black+	Ground Plane	FALSE	false	false	false	false	true		false	false	false	false	true	false	true	false		POINT (-73.9547423290276 40.7899702628835)	19	4	19	13
746	746	-73.9591407691	40.7960846903122	37B-AM-1018-01	37B	AM	10182018	1	Adult	Black	Black+	Ground Plane	FALSE	true	false	false	false	false		false	false	false	false	true	false	true	false		POINT (-73.9591407691 40.7960846903122)	19	4	19	13
2135	2135	-73.9596251284566	40.7916254797561	33D-AM-1017-05	33D	AM	10172018	5	Adult	Black	Black+	Above Ground	5	false	false	true	false	true		false	false	false	false	true	false	true	false		POINT (-73.9596251284566 40.7916254797561)	19	4	19	13
2351	2351	-73.9745818450109	40.7654498873627	1G-AM-1006-01	01G	AM	10062018	1	Adult	Black	Black+	Ground Plane	FALSE	false	true	false	false	true		false	false	false	false	true	false	true	false		POINT (-73.9745818450109 40.7654498873627)	19	4	19	13
2449	2449	-73.9599911537509	40.7914452542845	33D-AM-1017-04	33D	AM	10172018	4	Adult	Black	Black+	Above Ground	5	false	false	true	false	false		false	false	false	false	true	false	false	true		POINT (-73.9599911537509 40.7914452542845)	19	4	19	13
2535	2535	-73.9700101107283	40.7696729501144	7I-PM-1013-08	07I	PM	10132018	8	Adult	Black	Black+	Above Ground	4	false	false	true	false	false		false	false	false	false	true	false	false	false		POINT (-73.9700101107283 40.7696729501144)	19	4	19	13
1959	1959	-73.9707737073771	40.7800373465838	17B-PM-1012-02	17B	PM	10122018	2	Adult	Black	Black+	Ground Plane	FALSE	true	true	false	false	true	2/3 chasing each other	true	true	false	true	true	false	true	false		POINT (-73.9707737073771 40.7800373465838)	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
);