squirrels

10 rows where Chasing = "true", Primary Fur Color = "Cinnamon" and Running = "true" sorted by Color notes

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	Other Activities	Kuks	Quaas	Moans	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
514	514	-73.9768357173861	40.7683813358343	3D-PM-1010-12	03D	PM	10102018	12	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE		true	true	false	false	true		false	true	false	false	false	false	false	false	POINT (-73.9768357173861 40.7683813358343)	19	4	19	13
684	684	-73.9691057326088	40.7765973509721	14F-PM-1012-07	14F	PM	10122018	7	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Ground Plane	FALSE		true	true	false	true	true		false	false	false	false	false	false	true	false	POINT (-73.9691057326088 40.7765973509721)	19	4	19	13
1142	1142	-73.9765805609072	40.7692807820935	4D-PM-1008-07	04D	PM	10082018	7	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Ground Plane	FALSE	hopped over fence and chased # 6 around tree & ran it to end of lawn	true	true	false	false	false		false	false	false	false	false	false	true	false	POINT (-73.9765805609072 40.7692807820935)	19	4	19	13
1260	1260	-73.9811585807616	40.768706748732	2A-AM-1010-06	02A	AM	10102018	6	Adult	Cinnamon		Cinnamon+	Ground Plane	FALSE		true	true	false	false	false	chasing #5	false	false	false	false	false	false	false	false	POINT (-73.9811585807616 40.768706748732)	19	4	19	13
1551	1551	-73.9785114291288	40.7719779589449	6A-PM-1012-03	06A	PM	10122018	3	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE		true	true	true	false	false		false	false	false	false	false	false	false	false	POINT (-73.9785114291288 40.7719779589449)	19	4	19	13
1772	1772	-73.9690540696008	40.7766014124609	14F-PM-1012-08	14F	PM	10122018	8	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Ground Plane	FALSE		true	true	false	true	true		false	false	false	false	false	false	true	false	POINT (-73.9690540696008 40.7766014124609)	19	4	19	13
1822	1822	-73.9775099290913	40.7697609063137	4C-PM-1010-14	04C	PM	10102018	14	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		true	true	false	false	false	chasing #15	false	false	false	false	false	false	false	false	POINT (-73.9775099290913 40.7697609063137)	19	4	19	13
2205	2205	-73.9594986107981	40.7840083040604	25I-AM-1012-03	25I	AM	10122018	3	Adult	Cinnamon		Cinnamon+	Above Ground	8	on turn, see map	true	true	false	true	false		false	false	false	false	true	true	false	false	POINT (-73.9594986107981 40.7840083040604)	19	4	19	13
2487	2487	-73.9595222999173	40.7833202577782	25I-AM-1012-02	25I	AM	10122018	2	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	31	on tree	true	true	false	false	false		false	false	false	true	true	false	true	false	POINT (-73.9595222999173 40.7833202577782)	19	4	19	13
2919	2919	-73.9768563402344	40.7744487310786	9A-AM-1013-12	09A	AM	10132018	12	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE	foot of tree	true	true	false	false	false		false	false	false	false	false	false	true	false	POINT (-73.9768563402344 40.7744487310786)	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
);