2018_Central_Park_Squirrel_Census_-_Squirrel_Data

22 rows where Hectare Squirrel Number = 2, Highlight Fur Color = "White" and Location = "Above Ground"

- 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, Date, Age, Primary Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Quaas, 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
189	189	-73.9735489537928	40.76812579115229	4G-AM-1006-02	04G	AM	10062018	2		Gray	White	Gray+White		Above Ground	12	tree	0	0	0	0	0	sitting in tree	0	0	0	0	0	0	1	0		POINT (-73.9735489537928 40.7681257911523)
199	199	-73.97716146866159	40.770967798324705	5C-AM-1006-02	05C	AM	10062018	2	Adult	Cinnamon	White	Cinnamon+White		Above Ground	10		1	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9771614686616 40.7709677983247)
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)
359	359	-73.9716404781264	40.7753181851766	12D-PM-1014-02	12D	PM	10142018	2	Adult	Gray	White	Gray+White		Above Ground	15		0	0	1	0	0	seems to be grinding teeth on a piece of material (sounds from grinding)	0	0	0	0	0	0	1	0		POINT (-73.9716404781264 40.7753181851766)
428	428	-73.96362827608	40.780799459524204	21G-AM-1014-02	21G	AM	10142018	2	Adult	Gray	White	Gray+White		Above Ground	3	fence	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.96362827608 40.7807994595242)
508	508	-73.97469187620759	40.765523188367794	1G-AM-1006-02	01G	AM	10062018	2	Juvenile	Gray	White	Gray+White		Above Ground	30		0	0	1	0	1		0	0	0	0	1	0	1	0		POINT (-73.9746918762076 40.7655231883678)
600	600	-73.9808202088503	40.7682921842325	1A-PM-1014-02	01A	PM	10142018	2	Adult	Cinnamon	White	Cinnamon+White		Above Ground	6		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9808202088503 40.7682921842325)
1154	1154	-73.9786936992465	40.771394367466606	5A-PM-1010-02	05A	PM	10102018	2	Adult	Gray	White	Gray+White		Above Ground	50		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9786936992465 40.7713943674666)
1203	1203	-73.9616999731028	40.7954126939561	36A-AM-1018-02	36A	AM	10182018	2	Juvenile	Gray	White	Gray+White		Above Ground	15		0	0	0	1	0	eating (red berries)	0	0	0	0	0	0	1	0		POINT (-73.9616999731028 40.7954126939561)
1252	1252	-73.9777998932399	40.770981586533395	5B-PM-1013-02	05B	PM	10132018	2	Adult	Gray	White	Gray+White		Above Ground	5		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9777998932399 40.7709815865334)
1374	1374	-73.9653739273979	40.788976209696706	28B-PM-1010-02	28B	PM	10102018	2	Adult	Gray	White	Gray+White		Above Ground	4		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9653739273979 40.7889762096967)
1414	1414	-73.9580513096783	40.79909641532	41B-AM-1010-02	41B	AM	10102018	2	Adult	Gray	White	Gray+White		Above Ground	16		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9580513096783 40.79909641532)
1652	1652	-73.94984217462209	40.7969397424182	42I-PM-1014-02	42I	PM	10142018	2	Adult	Cinnamon	White	Cinnamon+White		Above Ground	8		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9498421746221 40.7969397424182)
1804	1804	-73.98077710643099	40.7681635726316	1A-AM-1007-02	01A	AM	10072018	2	Adult	Gray	White	Gray+White		Above Ground	11		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.980777106431 40.7681635726316)
1916	1916	-73.9693504617353	40.7830678709405	21B-PM-1017-02	21B	PM	10172018	2	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	1		0	1	0	0	0		0	1	0	0	0	0	0	0	stood on hind legs with front legs on the chest	POINT (-73.9693504617353 40.7830678709405)
1933	1933	-73.95848243616551	40.7934247634031	35D-PM-1013-02	35D	PM	10132018	2	Adult	Gray	White	Gray+White		Above Ground	24		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9584824361655 40.7934247634031)
1972	1972	-73.9558370309765	40.7921977208472	35G-AM-1007-02	35G	AM	10072018	2	Adult	Gray	White	Gray+White		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9558370309765 40.7921977208472)
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)
2226	2226	-73.9624296435843	40.791320813687	31C-PM-1010-02	31C	PM	10102018	2	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9624296435843 40.791320813687)
2231	2231	-73.95454276114769	40.793035381744104	36G-PM-1012-02	36G	PM	10122018	2	Adult	Gray	White	Gray+White		Above Ground	10		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9545427611477 40.7930353817441)
2298	2298	-73.97553718499721	40.7733561233828	9C-PM-1006-02	09C	PM	10062018	2	Adult	Gray	White	Gray+White		Above Ground	15		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9755371849972 40.7733561233828)
2632	2632	-73.95082755733499	40.797579073666	42H-PM-1014-02	42H	PM	10142018	2	Adult	Gray	White	Gray+White		Above Ground		Running along stone ledge	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.950827557335 40.797579073666)

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