2018_Central_Park_Squirrel_Census_-_Squirrel_Data

10 rows where Eating = 0, Foraging = 1, Hectare Squirrel Number = 2, Location = "Above Ground" and Shift = "PM"

- 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

- 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: Date, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Running, Climbing, Tail flags, Tail twitches, Indifferent, 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
46	46	-73.9673253417305	40.7749505252981	13H-PM-1010-02	13H	PM	10102018	2	Adult	Gray		Gray+		Above Ground	5	tree	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9673253417305 40.7749505252981)
248	248	-73.9751729403694	40.774328412311796	10B-PM-1014-02	10B	PM	10142018	2	Adult	Gray	White	Gray+White		Above Ground		gingko tree by traffic light in front of Strawberry Fields	0	0	0	0	1		0	0	0	0	1	0	0	0	came over on tree to see me then disappeared	POINT (-73.9751729403694 40.7743284123118)
1385	1385	-73.9615649773504	40.7954761311501	36A-PM-1013-02	36A	PM	10132018	2		Gray	Cinnamon	Gray+Cinnamon		Above Ground	6		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9615649773504 40.7954761311501)
1564	1564	-73.9703816112358	40.777384606591895	15D-PM-1017-02	15D	PM	10172018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1		0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9703816112358 40.7773846065919)
1697	1697	-73.9568610943394	40.7935959584643	36E-PM-1012-02	36E	PM	10122018	2	Adult	Gray		Gray+		Above Ground	28	on tree branch	0	0	1	0	1	picking acorns off oak tree	0	0	0	0	0	0	1	0		POINT (-73.95686109433942 40.7935959584643)
1904	1904	-73.9684058476942	40.7753959833776	13G-PM-1008-02	13G	PM	10082018	2	Juvenile	Gray		Gray+		Above Ground	15	willow oak tree	0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9684058476942 40.7753959833776)
2185	2185	-73.9707571364399	40.7758859812524	13E-PM-1008-02	13E	PM	10082018	2	Adult	Gray	White	Gray+White		Above Ground	10		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9707571364399 40.7758859812524)
2419	2419	-73.9590551473416	40.7891607060794	31F-PM-1007-02	31F	PM	10072018	2	Adult	Gray		Gray+		Above Ground	2	tree trunk	0	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.95905514734162 40.7891607060794)
2818	2818	-73.9681664642028	40.77246696819579	11I-PM-1012-02	11I	PM	10122018	2	Adult	Gray		Gray+		Above Ground	4		1	0	1	0	1		0	0	0	0	0	0	0	1	runs away from the ball	POINT (-73.9681664642028 40.7724669681958)
2870	2870	-73.9538475741188	40.796479421955	40F-PM-1006-02	40F	PM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	6		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9538475741188 40.796479421955)

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