2018_Central_Park_Squirrel_Census_-_Squirrel_Data

50 rows where Eating = 0, Foraging = 0, Indifferent = 1 and Tail twitches = 1

- 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: Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Quaas, Tail flags

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
43	43	-73.9574648097543	40.7892508428622	31H-PM-1008-02	31H	PM	10082018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	8		1	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9574648097543 40.78925084286221)
47	47	-73.9640032826529	40.782030982544796	22F-PM-1014-06	22F	PM	10142018	6	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9640032826529 40.7820309825448)
65	65	-73.9741824992294	40.7689486657963	5F-PM-1007-03	05F	PM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	hiding nut	0	0	0	0	1	0	1	0		POINT (-73.9741824992294 40.7689486657963)
326	326	-73.9699843570636	40.7729480440312	10G-AM-1006-01	10G	AM	10062018	1	Adult	Gray		Gray+		Above Ground	80		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.96998435706361 40.7729480440312)
380	380	-73.9649590119935	40.782210792076896	21F-AM-1018-01	21F	AM	10182018	1	Adult	Gray		Gray+		Above Ground	15		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9649590119935 40.7822107920769)
567	567	-73.9756972647636	40.773624164826	9B-PM-1013-04	09B	PM	10132018	4	Juvenile	Gray	Black	Gray+Black		Above Ground	30		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9756972647636 40.773624164826)
620	620	-73.9655905300923	40.775261463802295	14I-PM-1018-06	14I	PM	10182018	6	Adult	Cinnamon	Black	Cinnamon+Black		Above Ground	2		1	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9655905300923 40.7752614638023)
622	622	-73.97548367967059	40.7738879545412	9B-PM-1013-01	09B	PM	10132018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	playing	0	0	0	0	1	0	1	0		POINT (-73.9754836796706 40.7738879545412)
733	733	-73.9764397550289	40.7737004557104	8B-AM-1007-01	08B	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9764397550289 40.7737004557104)
746	746	-73.9591407691	40.796084690312206	37B-AM-1018-01	37B	AM	10182018	1	Adult	Black		Black+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9591407691 40.7960846903122)
856	856	-73.9591667162801	40.7937602121568	35D-PM-1013-07	35D	PM	10132018	7	Juvenile	Gray	White	Gray+White		Above Ground	12	tree	0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.95916671628011 40.7937602121568)
884	884	-73.96789372898371	40.7782808361645	16E-PM-1018-01	16E	PM	10182018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9678937289837 40.7782808361645)
985	985	-73.9681722244801	40.783559826281	22B-PM-1014-07	22B	PM	10142018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9681722244801 40.783559826281)
1086	1086	-73.9713399316534	40.77506780267571	12E-PM-1018-02	12E	PM	10182018	2	Adult	Black	Cinnamon, White	Black+Cinnamon, White	Black & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Above Ground	3		0	0	1	0	0	lounging on tree upside down	0	0	0	0	1	0	1	0		POINT (-73.9713399316534 40.7750678026757)
1164	1164	-73.97902264006291	40.76989976537921	4B-AM-1010-01	04B	AM	10102018	1	Adult	Gray	Black, Cinnamon	Gray+Black, Cinnamon		Above Ground	2		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9790226400629 40.7698997653792)
1188	1188	-73.9669529835992	40.787186415136496	25A-AM-1013-05	25A	AM	10132018	5		Gray		Gray+		Ground Plane	FALSE	CROSS BRIDLE - INTO TREE TO AVOID DOGGO	1	0	1	0	0	d.p.t.	0	0	0	1	1	0	1	0	calm	POINT (-73.96695298359921 40.7871864151365)
1235	1235	-73.9679686793869	40.7825993867876	21C-AM-1014-01	21C	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	3		1	0	0	0	0	jumping back & forth on tree	0	0	0	1	1	0	1	0		POINT (-73.9679686793869 40.7825993867876)
1413	1413	-73.98100322064279	40.768162563497896	1A-AM-1007-01	01A	AM	10072018	1	Adult	Gray	White	Gray+White		Above Ground	7		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9810032206428 40.7681625634979)
1453	1453	-73.9555856074105	40.7969457685677	40E-AM-1014-04	40E	AM	10142018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE	on rocks/bushy rocks	1	0	0	0	0	hiding from bird	0	1	0	0	1	0	1	0		POINT (-73.9555856074105 40.79694576856771)
1511	1511	-73.9721642509914	40.7701179390078	7G-AM-1010-01	07G	AM	10102018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9721642509914 40.7701179390078)
1585	1585	-73.96113123553481	40.79501308639129	36A-PM-1013-04	36A	PM	10132018	4		Gray	White	Gray+White		Ground Plane	FALSE	ON ROCK NEAR POND	0	0	0	0	0	sitting	0	0	0	0	1	0	1	0		POINT (-73.9611312355348 40.7950130863913)
1600	1600	-73.9753093777	40.7666673897583	2F-AM-1006-04	02F	AM	10062018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Beautiful white puff at the end of its tail	Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.97530937770001 40.7666673897583)
1639	1639	-73.9736800575584	40.778306973575795	14A-PM-1014-04	14A	PM	10142018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	0	0	chasing (#3)	0	0	0	0	1	0	1	0		POINT (-73.9736800575584 40.7783069735758)
1663	1663	-73.96967203626271	40.779185159819704	17D-AM-1008-04	17D	AM	10082018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9696720362627 40.7791851598197)
1668	1668	-73.97469348106671	40.7659431884158	2G-PM-1007-02	02G	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	burying nut	0	0	0	0	1	0	1	0		POINT (-73.9746934810667 40.7659431884158)
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)
1820	1820	-73.9546337446865	40.7898772579576	33I-PM-1006-08	33I	PM	10062018	8	Adult	Gray		Gray+		Above Ground	6		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9546337446865 40.7898772579576)
1894	1894	-73.96997808572979	40.7688706046944	6I-PM-1013-01	06I	PM	10132018	1	Adult	Gray	Black	Gray+Black		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9699780857298 40.7688706046944)
1948	1948	-73.9738410069766	40.7691686156505	5F-PM-1007-06	05F	PM	10072018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	jumping on fence	0	0	0	0	1	0	1	0		POINT (-73.9738410069766 40.7691686156505)
1988	1988	-73.957138794884	40.7985389822719	40C-AM-1017-03	40C	AM	10172018	3	Adult	Gray	White	Gray+White					1	1	1	0	0	chasing (#4),digging	0	0	0	0	1	0	1	0		POINT (-73.957138794884 40.7985389822719)
2007	2007	-73.9684834138222	40.772428912021105	11H-AM-1010-06	11H	AM	10102018	6	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9684834138222 40.7724289120211)
2016	2016	-73.9589492240754	40.798901118974	40A-PM-1014-01	40A	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	30		0	0	1	0	0		0	0	0	0	1	0	1	0	stared & then went back up tree—then ran to different tree	POINT (-73.9589492240754 40.798901118974)
2091	2091	-73.96761128642859	40.7772792086081	16F-AM-1008-03	16F	AM	10082018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	road	1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9676112864286 40.7772792086081)
2171	2171	-73.9686370726471	40.7780382348833	16E-PM-1018-09	16E	PM	10182018	9	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	3	On trunk	0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9686370726471 40.7780382348833)
2213	2213	-73.9707487237344	40.7800822831001	17B-PM-1012-03	17B	PM	10122018	3	Adult	Gray	White	Gray+White		Above Ground	10		1	1	0	0	0	2/3 chasing each other	0	0	0	0	1	0	1	0		POINT (-73.9707487237344 40.7800822831001)
2247	2247	-73.95595201371721	40.7950536287174	38E-AM-1010-06	38E	AM	10102018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1	branches	1	1	0	0	0	chasing and being chased by #7	0	0	0	0	1	0	1	0		POINT (-73.95595201371721 40.7950536287174)
2258	2258	-73.95477850811709	40.789612183711	33I-AM-1008-02	33I	AM	10082018	2	Adult	Gray		Gray+		Above Ground	3	edge of park @ 98th	0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9547785081171 40.789612183711)
2320	2320	-73.9576897478787	40.796469532845705	38C-AM-1019-02	38C	AM	10192018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9576897478787 40.7964695328457)
2396	2396	-73.9704339422613	40.77401495296439	11F-PM-1006-03	11F	PM	10062018	3	Adult	Gray		Gray+		Above Ground	4		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9704339422613 40.7740149529644)
2487	2487	-73.9595222999173	40.7833202577782	25I-AM-1012-02	25I	AM	10122018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	31	on tree	1	1	0	0	0		0	0	0	1	1	0	1	0		POINT (-73.9595222999173 40.7833202577782)
2490	2490	-73.9693876553956	40.7707232748402	8I-AM-1006-02	08I	AM	10062018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9693876553956 40.7707232748402)
2559	2559	-73.95723834787741	40.787685738072206	30H-PM-1006-01	30H	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9572383478774 40.7876857380722)
2598	2598	-73.976658503418	40.768686845691704	4D-AM-1012-03	04D	AM	10122018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.976658503418 40.7686868456917)
2696	2696	-73.9501457233643	40.797094356558	42I-PM-1014-01	42I	PM	10142018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9501457233643 40.797094356558)
2851	2851	-73.955208233231	40.7890574331084	32I-PM-1007-02	32I	PM	10072018	2	Adult			+		Above Ground	30		0	0	1	0	0	different sound - happy,playful chirps	0	0	0	0	1	0	1	0		POINT (-73.955208233231 40.7890574331084)
2855	2855	-73.9690832219322	40.782343340985996	20B-PM-1013-06	20B	PM	10132018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.96908322193221 40.782343340986)
2896	2896	-73.970595860252	40.7832060751268	20A-AM-1010-01	20A	AM	10102018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.970595860252 40.7832060751268)
2904	2904	-73.97203897567171	40.7763524091989	13C-PM-1019-02	13C	PM	10192018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9720389756717 40.7763524091989)
2935	2935	-73.96045994773449	40.7915035010169	32D-PM-1006-06	32D	PM	10062018	6	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9604599477345 40.7915035010169)
2988	2988	-73.9766342759486	40.7687518380873	4D-AM-1012-04	04D	AM	10122018	4	Adult	Gray		Gray+		Above Ground	3	on tree trunk	0	1	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9766342759486 40.7687518380873)

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