2018_Central_Park_Squirrel_Census_-_Squirrel_Data

12 rows where Date = 10102018, Hectare Squirrel Number = 2 and Tail twitches = 1 sorted by Combination of Primary and Highlight Color

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	Climbing	Eating	Foraging	Other Activities	Tail flags	Tail twitches	Indifferent	Runs from	Other Interactions	Lat/Long
2999	2999	-73.972415182837	40.773080463452004	10E-AM-1010-02	10E	AM	10102018	2	Adult	Black	Gray	Black+Gray	Ground Plane	FALSE		1	0	0	1		0	1	1	0		POINT (-73.972415182837 40.773080463452)
1816	1816	-73.9710187505339	40.7797265666746	17B-AM-1010-02	17B	AM	10102018	2	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1		0	1	1	0		POINT (-73.9710187505339 40.7797265666746)
2739	2739	-73.9681960138614	40.7726867422002	11H-AM-1010-02	11H	AM	10102018	2		Cinnamon	Gray	Cinnamon+Gray				0	0	1	0		0	1	1	0		POINT (-73.9681960138614 40.7726867422002)
2330	2330	-73.9724618533895	40.7745021602455	11D-AM-1010-02	11D	AM	10102018	2	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Ground Plane	FALSE		0	0	0	1	walking	0	1	0	1		POINT (-73.9724618533895 40.7745021602455)
110	110	-73.97113187902791	40.7701941550273	7G-AM-1010-02	07G	AM	10102018	2	Adult	Gray		Gray+	Above Ground	3		1	0	0	0		0	1	0	1		POINT (-73.9711318790279 40.7701941550273)
923	923	-73.9578924882613	40.789806297824	32G-AM-1010-02	32G	AM	10102018	2	Adult	Gray		Gray+	Above Ground	13		0	1	1	0		0	1	0	1		POINT (-73.9578924882613 40.789806297824)
253	253	-73.95896270565609	40.7847591558491	26I-PM-1010-02	26I	PM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1	hiding food	0	1	1	0		POINT (-73.9589627056561 40.7847591558491)
650	650	-73.98096101171708	40.7683896665502	2A-AM-1010-02	02A	AM	10102018	2		Gray	Cinnamon	Gray+Cinnamon	Above Ground		perched on small fence	0	0	1	0		0	1	0	1		POINT (-73.9809610117171 40.7683896665502)
1333	1333	-73.9754527701832	40.7656088463928	1G-PM-1010-02	01G	PM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	20		0	0	0	0	laying on tree branch	1	1	0	0		POINT (-73.9754527701832 40.7656088463928)
1714	1714	-73.9763542780331	40.773653130362206	9B-AM-1010-02	09B	AM	10102018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground	1	in bush	0	1	0	1		0	1	0	1	froze	POINT (-73.9763542780331 40.773653130362206)
2229	2229	-73.9620719414292	40.788637452988	29D-PM-1010-02	29D	PM	10102018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	0	1	0		0	1	0	1		POINT (-73.9620719414292 40.788637452988)
1256	1256	-73.9679457364586	40.7717350221981	10I-AM-1010-02	10I	AM	10102018	2	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	1		0	1	0	1		POINT (-73.9679457364586 40.7717350221981)

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "2018_Central_Park_Squirrel_Census_-_Squirrel_Data" (
"longitude" REAL,
  "latitude" REAL,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" INTEGER,
  "Hectare Squirrel Number" INTEGER,
  "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" INTEGER,
  "Chasing" INTEGER,
  "Climbing" INTEGER,
  "Eating" INTEGER,
  "Foraging" INTEGER,
  "Other Activities" TEXT,
  "Kuks" INTEGER,
  "Quaas" INTEGER,
  "Moans" INTEGER,
  "Tail flags" INTEGER,
  "Tail twitches" INTEGER,
  "Approaches" INTEGER,
  "Indifferent" INTEGER,
  "Runs from" INTEGER,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT
);