squirrels

10 rows where Chasing = "true" and Combination of Primary and Highlight Color = "Cinnamon+Gray" sorted by Kuks

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	Other Interactions	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
1135	1135	-73.9667474482967	40.7760643720793	15H-PM-1008-01	15H	PM	10082018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10	Oak tree	false	true	false	false	false	watching me	false	true	false	true	false	false	false	false	observant	POINT (-73.9667474482967 40.7760643720793)	19	4	19	13
1226	1226	-73.97684509717	40.7709430375069	5C-PM-1010-07	05C	PM	10102018	7	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	13		false	true	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.97684509717 40.7709430375069)	19	4	19	13
1415	1415	-73.9678561384348	40.7782877397822	16E-PM-1018-02	16E	PM	10182018	2	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		false	true	false	false	false		false	false	false	true	false	false	false	false	gets distance from people but then continues to chase #1	POINT (-73.9678561384348 40.7782877397822)	19	4	19	13
1448	1448	-73.9772810073685	40.7693577540392	4C-PM-1010-03	04C	PM	10102018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		false	true	false	false	true		false	false	false	false	false	false	true	false		POINT (-73.9772810073685 40.7693577540392)	19	4	19	13
1513	1513	-73.9662409997642	40.7891042935432	28A-PM-1007-03	28A	PM	10072018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		false	true	false	true	true	chasing #2 took #2 food wrapper and is foraging through it	false	false	false	false	false	false	true	false		POINT (-73.9662409997642 40.7891042935432)	19	4	19	13
1601	1601	-73.9544278270221	40.7987827316512	42D-PM-1013-02	42D	PM	10132018	2	Adult	Cinnamon	Gray	Cinnamon+Gray	Gray tail, Cinnamon feet	Ground Plane	FALSE		false	true	false	false	true	chasing (chased by #1),found a nut,buried it	false	false	false	false	false	false	true	false		POINT (-73.9544278270221 40.7987827316512)	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
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
1799	1799	-73.978844141973	40.7696046074378	4B-AM-1010-05	04B	AM	10102018	5	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10		false	true	false	false	false	chasing squirrel #6	true	true	false	false	true	false	false	false		POINT (-73.978844141973 40.7696046074378)	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
);