2018_Central_Park_Squirrel_Census_-_Squirrel_Data

49 rows where Climbing = 0, Foraging = 1, Location = "Above Ground" and Tail twitches = 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

- 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, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Eating, Tail flags, Approaches, 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
11	11	-73.9702676472613	40.7762126854894	13E-AM-1017-05	13E	AM	10172018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground		on tree stump	0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9702676472613 40.7762126854894)
21	21	-73.9703781726172	40.778752613032104	16C-PM-1018-03	16C	PM	10182018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	6		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9703781726172 40.7787526130321)
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)
50	50	-73.96806350709491	40.779249873647	17E-AM-1017-05	17E	AM	10172018	5	Adult	Black		Black+		Above Ground	10	Branch	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9680635070949 40.779249873647)
198	198	-73.9761107065353	40.769642060286	5D-AM-1020-01	05D	AM	10202018	1	Adult			+	Too far & cloudy to tell	Above Ground	30		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9761107065353 40.769642060286)
311	311	-73.95787795565741	40.7934116539732	35E-PM-1006-06	35E	PM	10062018	6	Adult	Gray		Gray+		Above Ground			0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9578779556574 40.7934116539732)
333	333	-73.9667560049684	40.7882333830729	27A-PM-1006-01	27A	PM	10062018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground		on a tree	0	0	0	1	1	walking up & down branches	0	0	0	0	0	0	1	0		POINT (-73.9667560049684 40.7882333830729)
344	344	-73.9759432151552	40.7733240612552	8B-PM-1012-06	08B	PM	10122018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	2	on a bench	0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9759432151552 40.7733240612552)
441	441	-73.9742973420446	40.7691801644292	5F-AM-1007-04	05F	AM	10072018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground		rocks	0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9742973420446 40.7691801644292)
749	749	-73.96863045815259	40.7773631337117	15E-PM-1008-01	15E	PM	10082018	1	Adult	Gray		Gray+		Above Ground	4	on fallen tree	1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9686304581526 40.7773631337117)
901	901	-73.97022281317109	40.7742131587983	12F-PM-1007-12	12F	PM	10072018	12	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	5		0	0	0	0	1	going down tree	0	0	0	0	0	0	1	0		POINT (-73.9702228131711 40.7742131587983)
930	930	-73.96220300857941	40.7917723228749	32B-AM-1017-01	32B	AM	10172018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10	ran up a tree	1	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9622030085794 40.7917723228749)
951	951	-73.97179185488301	40.78029717297839	17B-PM-1012-01	17B	PM	10122018	1	Adult	Gray		Gray+		Above Ground	2	climbed a fence	1	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.971791854883 40.7802971729784)
1018	1018	-73.96953055553921	40.7757541971012	13F-PM-1008-03	13F	PM	10082018	3	Adult	Gray		Gray+		Above Ground	15	tree	0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9695305555392 40.7757541971012)
1020	1020	-73.97016933635	40.770545252978295	8H-AM-1017-05	08H	AM	10172018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	6		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.97016933635001 40.7705452529783)
1028	1028	-73.97070123456609	40.7758938984066	13E-PM-1008-03	13E	PM	10082018	3	Juvenile	Gray	White	Gray+White		Above Ground	10	hanging upside down to get a nut	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9707012345661 40.7758938984066)
1123	1123	-73.9670858934045	40.7753505024976	14H-PM-1012-02	14H	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	20		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9670858934045 40.7753505024976)
1126	1126	-73.97001860010491	40.7826052184658	20B-AM-1007-03	20B	AM	10072018	3	Adult	Gray	White	Gray+White		Above Ground			0	0	0	0	1		0	0	0	1	0	0	0	1		POINT (-73.9700186001049 40.7826052184658)
1179	1179	-73.9696762034757	40.7704883494264	8H-AM-1017-02	08H	AM	10172018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	7	root bed of tree	1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9696762034757 40.7704883494264)
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)
1572	1572	-73.9540197079615	40.798039260982996	41E-PM-1013-03	41E	PM	10132018	3	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Gray on legs	Above Ground	20		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9540197079615 40.798039260983)
1623	1623	-73.97701191330229	40.773294909000505	8A-AM-1013-04	08A	AM	10132018	4	Juvenile			+		Above Ground	4	fence	1	1	0	1	1	playing tag together	0	0	0	0	0	1	0	0		POINT (-73.9770119133023 40.7732949090005)
1661	1661	-73.974519308015	40.7691228794395	5E-AM-1008-02	05E	AM	10082018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	8	trellis	1	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.974519308015 40.7691228794395)
1693	1693	-73.9593781427412	40.7841519912635	26I-AM-1010-02	26I	AM	10102018	2	Adult	Gray		Gray+		Above Ground	40		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.95937814274122 40.7841519912635)
1751	1751	-73.9594045885402	40.7840886870652	26I-AM-1010-01	26I	AM	10102018	1	Adult	Gray		Gray+		Above Ground	40		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9594045885402 40.7840886870652)
1777	1777	-73.9711751356843	40.775242275820204	12E-AM-1017-06	12E	AM	10172018	6	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9711751356843 40.7752422758202)
1875	1875	-73.9527430510248	40.792480795055205	36I-PM-1007-12	36I	PM	10072018	12	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Tiny! So tiny!	Above Ground	2		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9527430510248 40.7924807950552)
1923	1923	-73.9743795190073	40.7692030411004	5E-AM-1008-05	05E	AM	10082018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9743795190073 40.7692030411004)
2008	2008	-73.95243640874371	40.792846505434	37I-PM-1006-01	37I	PM	10062018	1	Adult	Cinnamon	Gray, Black	Cinnamon+Gray, Black		Above Ground	5		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9524364087437 40.792846505434)
2177	2177	-73.9758211560957	40.7693422860766	5E-AM-1008-10	05E	AM	10082018	10	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	6	up a tree	1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9758211560957 40.7693422860766)
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)
2265	2265	-73.97052601032391	40.782633368659894	19A-PM-1013-04	19A	PM	10132018	4	Adult	Gray	Black, White	Gray+Black, White	Also looks quite brown - minimal body highlight coloring - black edges	Above Ground	2		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9705260103239 40.78263336865991)
2284	2284	-73.9730181306326	40.779460132242704	16A-AM-1013-02	16A	AM	10132018	2	Adult	Black		Black+		Above Ground			0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9730181306326 40.7794601322427)
2322	2322	-73.97236778547979	40.766731541087104	3H-AM-1008-04	03H	AM	10082018	4	Adult	Black		Black+		Above Ground	50		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9723677854798 40.7667315410871)
2331	2331	-73.9694681803635	40.770585795359004	8I-AM-1006-06	08I	AM	10062018	6	Adult	Gray	White	Gray+White		Above Ground			0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9694681803635 40.770585795359)
2388	2388	-73.9604476047877	40.7938014328732	35C-AM-1007-03	35C	AM	10072018	3	Adult			+		Above Ground	40		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9604476047877 40.7938014328732)
2393	2393	-73.9729190572117	40.770018150904995	6F-PM-1008-03	06F	PM	10082018	3	Adult	Gray		Gray+		Above Ground	50	top of tree	0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9729190572117 40.770018150905)
2403	2403	-73.97778796352159	40.769359455673	4C-AM-1006-03	04C	AM	10062018	3	Juvenile	Gray		Gray+		Above Ground	10		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9777879635216 40.769359455673)
2417	2417	-73.9720323148189	40.772970345961795	10E-PM-1007-01	10E	PM	10072018	1	Adult	Gray		Gray+		Above Ground	35		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9720323148189 40.7729703459618)
2648	2648	-73.97294104880208	40.770948496457706	7F-AM-1008-13	07F	AM	10082018	13	Adult	Gray		Gray+		Above Ground	4	to tree	1	0	0	1	1	ran up tree 4 feet and ate leaves	0	0	0	0	0	0	1	0		POINT (-73.9729410488021 40.7709484964577)
2694	2694	-73.969628583287	40.770406779793205	8H-AM-1017-03	08H	AM	10172018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2	fence	1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.969628583287 40.7704067797932)
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)
2707	2707	-73.97431653210991	40.775467467857396	11B-PM-1014-07	11B	PM	10142018	7		Gray		Gray+		Above Ground	10		1	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9743165321099 40.7754674678574)
2763	2763	-73.96260656728941	40.788722645116	29D-AM-1014-03	29D	AM	10142018	3	Juvenile	Gray		Gray+		Above Ground	35	End of tree limb foraging	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9626065672894 40.788722645116)
2786	2786	-73.9683883750097	40.7754344396847	13G-PM-1008-01	13G	PM	10082018	1	Juvenile	Gray		Gray+		Above Ground	20	willow oak tree	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9683883750097 40.7754344396847)
2831	2831	-73.9753585157592	40.7698398607941	5E-AM-1008-07	05E	AM	10082018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1	on fence	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9753585157592 40.7698398607941)
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)
2903	2903	-73.9670432105975	40.7753462013506	14H-PM-1012-03	14H	PM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	20		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9670432105975 40.7753462013506)
2944	2944	-73.97394038506219	40.769316228750895	5F-AM-1007-05	05F	AM	10072018	5	Adult	Gray	White	Gray+White		Above Ground	2	tree	1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9739403850622 40.7693162287509)

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