2018_Central_Park_Squirrel_Census_-_Squirrel_Data

16 rows where Chasing = 1, Date = 10072018 and Indifferent = 0

- remove filter - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by longitude Sort by latitude Sort by Unique Squirrel ID Sort by Hectare Sort by Shift Sort by Date Sort by Hectare Squirrel Number Sort by Age Sort by Primary Fur Color Sort by Highlight Fur Color Sort by Combination of Primary and Highlight Color Sort by Color notes Sort by Location Sort by Above Ground Sighter Measurement Sort by Specific Location Sort by Running Sort by Chasing Sort by Climbing Sort by Eating Sort by Foraging Sort by Other Activities Sort by Kuks Sort by Quaas Sort by Moans Sort by Tail flags Sort by Tail twitches Sort by Approaches Sort by Indifferent Sort by Runs from Sort by Other Interactions Sort by Lat/Long

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, 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, Foraging, Tail twitches, Runs from

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
421	421	-73.9664630067791	40.775636151582496	14H-AM-1007-04	14H	AM	10072018	4	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9664630067791 40.7756361515825)
721	721	-73.97182620344691	40.76667717974421	4I-PM-1007-02	04I	PM	10072018	2	Adult	Black		Black+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9718262034469 40.7666771797442)
849	849	-73.9736165917399	40.772454390149704	8D-AM-1007-04	08D	AM	10072018	4	Adult	Gray		Gray+		Above Ground	3		0	1	0	0	0	chasing squirrel #3	0	0	0	0	0	0	0	0		POINT (-73.9736165917399 40.7724543901497)
904	904	-73.9531013359625	40.792122355653504	36I-PM-1007-04	36I	PM	10072018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9531013359625 40.7921223556535)
1055	1055	-73.9632337134707	40.791468237073396	31B-PM-1007-01	31B	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	1	1	0	0	chasing #2 and climbing tree w/ #2	0	0	0	0	0	0	0	1		POINT (-73.9632337134707 40.7914682370734)
1220	1220	-73.97799837948492	40.767545209917294	2D-AM-1007-02	02D	AM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	6	up tree	0	1	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9779983794849 40.7675452099173)
1649	1649	-73.969347812694	40.7744098063421	12G-PM-1007-02	12G	PM	10072018	2		Gray		Gray+		Above Ground		in tree	0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.969347812694 40.7744098063421)
1698	1698	-73.9631392113757	40.791463563578404	31B-PM-1007-02	31B	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	1	1	0	0	chasing #1 and climbing tree w/ #1	0	0	0	0	0	0	0	1		POINT (-73.9631392113757 40.7914635635784)
1760	1760	-73.95970725337871	40.79055818537861	32E-AM-1007-12	32E	AM	10072018	12	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9597072533787 40.79055818537861)
1864	1864	-73.9694344956258	40.7742869276902	12G-PM-1007-01	12G	PM	10072018	1		Gray		Gray+		Above Ground	40	in tree	0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9694344956258 40.7742869276902)
2236	2236	-73.9597845469964	40.790617930344794	32E-AM-1007-11	32E	AM	10072018	11	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9597845469964 40.7906179303448)
2365	2365	-73.96887733063241	40.7766669852358	15F-AM-1007-05	15F	AM	10072018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9688773306324 40.7766669852358)
2512	2512	-73.974275954985	40.775472387930705	11B-AM-1007-02	11B	AM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.974275954985 40.7754723879307)
2524	2524	-73.9743877909071	40.7754706115974	11B-AM-1007-03	11B	AM	10072018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9743877909071 40.7754706115974)
2699	2699	-73.9743509423821	40.7690043677328	5F-AM-1007-02	05F	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground		tree	1	1	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.97435094238212 40.7690043677328)
2708	2708	-73.9528429238071	40.7922651848867	36I-PM-1007-09	36I	PM	10072018	9	Juvenile	Gray		Gray+		Above Ground	5		1	1	0	0	0	burying nut	0	0	0	0	1	0	0	0		POINT (-73.9528429238071 40.7922651848867)

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
);