2018_Central_Park_Squirrel_Census_-_Squirrel_Data

47 rows where Foraging = 0, Hectare Squirrel Number = 1, Running = 0 and Runs from = 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, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Climbing, Eating, Kuks, Quaas, Moans, Tail flags, Tail twitches, Indifferent

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
27	27	-73.9670628558161	40.7734991420941	12I-AM-1013-01	12I	AM	10132018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	on tree roots	0	0	0	0	0	sitting	0	0	0	0	1	0	0	1		POINT (-73.9670628558161 40.77349914209411)
78	78	-73.964474836001	40.7883840104749	28C-PM-1006-01	28C	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	gathering acorns	0	0	0	1	0	0	0	1	gnd to tree	POINT (-73.964474836001 40.7883840104749)
102	102	-73.95759861613641	40.799368134968	41B-PM-1014-01	41B	PM	10142018	1	Adult	Gray	White	Gray+White		Above Ground	25	Climbing tree	0	0	1	0	0	climbing (tree)	0	0	0	0	0	0	0	1		POINT (-73.9575986161364 40.799368134968)
236	236	-73.9737266070919	40.7786338379896	14A-PM-1014-01	14A	PM	10142018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9737266070919 40.7786338379896)
244	244	-73.9597648775789	40.7903443029725	32E-AM-1007-01	32E	AM	10072018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9597648775789 40.7903443029725)
265	265	-73.9691094942294	40.776760392858	14E-AM-1008-01	14E	AM	10082018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0	walking	0	0	0	0	0	0	0	1		POINT (-73.9691094942294 40.776760392858)
417	417	-73.9639888092327	40.791449395909	31A-AM-1010-01	31A	AM	10102018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9639888092327 40.791449395909005)
581	581	-73.9556218199258	40.7980460204041	41D-PM-1014-01	41D	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0	digging,drinking	0	0	0	0	0	0	0	1		POINT (-73.9556218199258 40.7980460204041)
630	630	-73.9580109357087	40.78556544054471	28I-AM-1013-01	28I	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Jumped onto path & then back into brush	0	0	0	0	0	stood on fence	0	0	0	0	0	0	0	1		POINT (-73.9580109357087 40.7855654405447)
643	643	-73.976730206737	40.773709213913996	8A-PM-1014-01	08A	PM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	1	0		1	0	0	0	0	0	0	1	runs from (goes up a tree)	POINT (-73.976730206737 40.773709213914)
813	813	-73.9758959798289	40.7694125671679	4D-PM-1008-01	04D	PM	10082018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9758959798289 40.7694125671679)
855	855	-73.9808247660048	40.76894088312871	2A-PM-1019-01	02A	PM	10192018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0	runs from	0	0	0	1	0	0	0	1		POINT (-73.9808247660048 40.7689408831287)
865	865	-73.9741621946917	40.775248147202504	11C-PM-1018-01	11C	PM	10182018	1	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9741621946917 40.7752481472025)
906	906	-73.9664120826015	40.7888022709721	27A-AM-1008-01	27A	AM	10082018	1	Adult	Gray		Gray+		Above Ground	3		0	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.96641208260151 40.7888022709721)
984	984	-73.9672950266018	40.7782477517567	17F-PM-1020-01	17F	PM	10202018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	7		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9672950266018 40.7782477517567)
996	996	-73.9703149829421	40.778558363032296	16D-AM-1007-01	16D	AM	10072018	1	Adult	Gray	White	Gray+White		Above Ground	3		0	0	1	1	0		0	0	0	0	0	0	0	1		POINT (-73.9703149829421 40.7785583630323)
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)
1183	1183	-73.9525699067954	40.7937125788106	38I-PM-1014-01	38I	PM	10142018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	on the lawn East of the fountain	0	0	0	0	0	scampering thru the grass!	0	0	0	0	1	0	0	1		POINT (-73.9525699067954 40.7937125788106)
1206	1206	-73.97487092063541	40.77608025411	11B-PM-1014-01	11B	PM	10142018	1	Adult	Gray		Gray+	Fat!	Above Ground	10		0	0	1	0	0		1	0	0	0	0	0	0	1		POINT (-73.9748709206354 40.77608025411)
1261	1261	-73.9719109949232	40.772313852132704	9F-AM-1013-01	09F	AM	10132018	1	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9719109949232 40.7723138521327)
1305	1305	-73.9569324958684	40.7877748374259	30I-PM-1006-01	30I	PM	10062018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0	sitting there	0	0	0	0	0	0	0	1		POINT (-73.9569324958684 40.78777483742591)
1357	1357	-73.96313500206341	40.791907210332	32B-PM-1010-01	32B	PM	10102018	1	Juvenile	Gray		Gray+		Above Ground	25	in tree	0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9631350020634 40.791907210332)
1499	1499	-73.96252055381709	40.7810785055136	21H-AM-1017-01	21H	AM	10172018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9625205538171 40.7810785055136)
1534	1534	-73.9695226023739	40.7797527775804	17D-AM-1008-01	17D	AM	10082018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9695226023739 40.7797527775804)
1560	1560	-73.9587072763996	40.7850256219415	27I-AM-1007-01	27I	AM	10072018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	20		0	0	1	1	0		0	0	0	0	0	0	0	1		POINT (-73.9587072763996 40.7850256219415)
1581	1581	-73.97157754108001	40.7776249963967	14C-PM-1006-01	14C	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	0	0		0	1	0	0	0	0	0	1		POINT (-73.97157754108 40.7776249963967)
1621	1621	-73.97349693209429	40.7722754599865	8E-AM-1013-01	08E	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9734969320943 40.7722754599865)
1640	1640	-73.9564632239432	40.7904807427954	33G-AM-1013-01	33G	AM	10132018	1	Adult	Cinnamon		Cinnamon+		Above Ground	13	shelter in hole in tree	0	0	1	0	0		0	0	0	0	0	0	1	1		POINT (-73.9564632239432 40.7904807427954)
1707	1707	-73.96045242711669	40.7956624328733	36B-AM-1013-01	36B	AM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9604524271167 40.7956624328733)
1825	1825	-73.9624209799704	40.79102009727521	31C-PM-1010-01	31C	PM	10102018	1	Adult	Gray	White	Gray+White		Above Ground	3		0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9624209799704 40.7910200972752)
1939	1939	-73.9540151828782	40.7920066170587	35H-AM-1013-01	35H	AM	10132018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	15	Climbing up tree	0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9540151828782 40.7920066170587)
2067	2067	-73.97250779335741	40.7654562710325	2I-PM-1006-01	02I	PM	10062018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	2	Sitting on back of bench with food hanging from mouth	0	0	0	0	0	staring at me	0	0	0	0	0	0	0	1		POINT (-73.9725077933574 40.7654562710325)
2142	2142	-73.95985354257058	40.7915589343685	33D-PM-1006-01	33D	PM	10062018	1		Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		0	1	0	0	0	hanging on fence	1	0	0	1	0	0	0	1		POINT (-73.9598535425706 40.7915589343685)
2182	2182	-73.9573656523498	40.7979754563974	40C-AM-1017-01	40C	AM	10172018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0	chasing (#2)	0	0	0	0	0	0	0	1		POINT (-73.9573656523498 40.7979754563974)
2199	2199	-73.9677500862135	40.7726060987821	11I-AM-1012-01	11I	AM	10122018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9677500862135 40.7726060987821)
2244	2244	-73.9509628195532	40.797777567417796	42H-PM-1014-01	42H	PM	10142018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	2		0	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9509628195532 40.7977775674178)
2338	2338	-73.9716621112698	40.774286221946895	11E-AM-1013-01	11E	AM	10132018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	1	1	0		0	0	0	0	0	0	0	1		POINT (-73.9716621112698 40.7742862219469)
2342	2342	-73.9533645762606	40.7983709215535	42F-AM-1019-01	42F	AM	10192018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	1	0	0	1	runs from (me)	POINT (-73.9533645762606 40.7983709215535)
2350	2350	-73.9564777440695	40.7993068355401	42C-AM-1007-01	42C	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	nut in mouth	0	0	0	0	0	0	0	1		POINT (-73.9564777440695 40.7993068355401)
2389	2389	-73.9801343393329	40.769151245340204	3A-AM-1012-01	03A	AM	10122018	1	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments.	Above Ground	1		0	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9801343393329 40.7691512453402)
2406	2406	-73.9668964315686	40.777757799088604	16G-AM-1010-01	16G	AM	10102018	1	Adult	Gray	White	Gray+White		Above Ground	3		0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9668964315686 40.7777577990886)
2435	2435	-73.972087127535	40.776237268628	13C-AM-1010-01	13C	AM	10102018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.972087127535 40.776237268628)
2463	2463	-73.9653343572865	40.77752869246171	17H-PM-1007-01	17H	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4		0	0	1	1	0		0	0	0	1	0	0	0	1		POINT (-73.9653343572865 40.7775286924617)
2729	2729	-73.9615429203441	40.7907417648701	31D-AM-1014-01	31D	AM	10142018	1		Gray	Cinnamon	Gray+Cinnamon		Above Ground	20	Ground then up tree	0	0	1	0	0	chased by a doggo	0	0	1	0	0	0	0	1	runs from (dogs!)	POINT (-73.9615429203441 40.7907417648701)
2874	2874	-73.9597453664295	40.7891382153733	30F-PM-1007-01	30F	PM	10072018	1	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Above Ground	1	tree	0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9597453664295 40.7891382153733)
2888	2888	-73.955258162768	40.7958147673603	39E-AM-1018-01	39E	AM	10182018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	standing still	0	0	0	0	0	0	0	1		POINT (-73.955258162768 40.7958147673603)
2975	2975	-73.959412243507	40.7917871123534	33E-AM-1014-01	33E	AM	10142018	1	Adult	Black	Cinnamon	Black+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	digging	0	0	0	0	0	0	0	1		POINT (-73.959412243507 40.7917871123534)

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