2018_Central_Park_Squirrel_Census_-_Squirrel_Data

47 rows where Date = 10062018, Foraging = 1, Indifferent = 1 and Shift = "AM"

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

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
104	104	-73.9764036522984	40.7705846185121	5C-AM-1006-05	05C	AM	10062018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9764036522984 40.7705846185121)
160	160	-73.9756015005821	40.7670090327736	2F-AM-1006-01	02F	AM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	walking along path	0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.97560150058212 40.7670090327736)
405	405	-73.97866031471492	40.7671937837017	1D-AM-1006-09	01D	AM	10062018	9	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9786603147149 40.7671937837017)
472	472	-73.9702721244652	40.7701011774207	7H-AM-1006-15	07H	AM	10062018	15	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9702721244652 40.7701011774207)
486	486	-73.971213385696	40.769872094337	7H-AM-1006-04	07H	AM	10062018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.97121338569602 40.769872094337)
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)
570	570	-73.9745227769788	40.7673618284782	3F-AM-1006-09	03F	AM	10062018	9	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	in grass by light post	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9745227769788 40.76736182847821)
753	753	-73.9729378674198	40.7672407594559	4H-AM-1006-04	04H	AM	10062018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1	met #3 while foraging and briefly tussled	0	0	0	0	0	0	1	0		POINT (-73.9729378674198 40.7672407594559)
756	756	-73.9773079154219	40.7696506688861	4C-AM-1006-02	04C	AM	10062018	2	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9773079154219 40.7696506688861)
816	816	-73.9785300509908	40.772112774842704	6A-AM-1006-07	06A	AM	10062018	7	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9785300509908 40.7721127748427)
836	836	-73.975086415444	40.7671990131313	3F-AM-1006-01	03F	AM	10062018	1	Adult	Gray		Gray+		Ground Plane	FALSE	just to right when enter sanctuary	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.975086415444 40.7671990131313)
895	895	-73.97868986562791	40.7720833097065	6A-AM-1006-08	06A	AM	10062018	8	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9786898656279 40.77208330970651)
921	921	-73.9698959071826	40.7716763799299	9H-AM-1006-05	09H	AM	10062018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9698959071826 40.7716763799299)
1035	1035	-73.97725699096729	40.7664804797448	1E-AM-1006-02	01E	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	1	0	1	0		POINT (-73.9772569909673 40.7664804797448)
1209	1209	-73.97631591531379	40.7705785330431	5C-AM-1006-07	05C	AM	10062018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9763159153138 40.7705785330431)
1213	1213	-73.9693202078293	40.771043472925	9H-AM-1006-01	09H	AM	10062018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9693202078293 40.771043472925)
1243	1243	-73.97455562298549	40.767292104099795	3F-AM-1006-07	03F	AM	10062018	7	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	close to tall tree & light post	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9745556229855 40.7672921040998)
1275	1275	-73.9702541471417	40.769858423179706	7H-AM-1006-12	07H	AM	10062018	12	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9702541471417 40.7698584231797)
1358	1358	-73.9693772461788	40.770687589290105	8I-AM-1006-03	08I	AM	10062018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9693772461788 40.7706875892901)
1387	1387	-73.9697160572446	40.7711445570446	9H-AM-1006-02	09H	AM	10062018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.96971605724461 40.7711445570446)
1455	1455	-73.9715621134573	40.7695918717513	7H-AM-1006-02	07H	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1	running (along ground,up tree)	0	0	0	0	0	0	1	0		POINT (-73.9715621134573 40.76959187175131)
1529	1529	-73.9692401421068	40.7707128895661	8I-AM-1006-04	08I	AM	10062018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9692401421068 40.7707128895661)
1556	1556	-73.97462382801159	40.7671491962844	3F-AM-1006-06	03F	AM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9746238280116 40.7671491962844)
1634	1634	-73.97264597739951	40.7656357433691	2I-AM-1006-02	02I	AM	10062018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9726459773995 40.7656357433691)
1659	1659	-73.96904988769441	40.7700011818847	8I-AM-1006-07	08I	AM	10062018	7	Adult	Gray	White	Gray+White	White ring on short tail	Above Ground	20		0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9690498876944 40.7700011818847)
1709	1709	-73.9771696835698	40.76970111004871	4C-AM-1006-04	04C	AM	10062018	4	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9771696835698 40.7697011100487)
1779	1779	-73.9695560376915	40.7708835103516	9H-AM-1006-03	09H	AM	10062018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.96955603769152 40.7708835103516)
1813	1813	-73.9706988226435	40.7696684566926	7H-AM-1006-16	07H	AM	10062018	16	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9706988226435 40.7696684566926)
1819	1819	-73.9711378905748	40.7696218346333	7H-AM-1006-03	07H	AM	10062018	3	Adult	Gray		Gray+		Ground Plane	FALSE	on rock (large)	0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9711378905748 40.769621834633305)
1853	1853	-73.9721210372896	40.7667971476099	4I-AM-1006-02	04I	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9721210372896 40.7667971476099)
2191	2191	-73.9734108731087	40.767605139269705	4G-AM-1006-03	04G	AM	10062018	3		Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9734108731087 40.7676051392697)
2221	2221	-73.9771847728747	40.769597116498105	4C-AM-1006-01	04C	AM	10062018	1	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9771847728747 40.7695971164981)
2289	2289	-73.97458005923929	40.767356541975005	3F-AM-1006-08	03F	AM	10062018	8	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	close to tall tree & light post	1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9745800592393 40.767356541975)
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)
2351	2351	-73.97458184501092	40.765449887362706	1G-AM-1006-01	01G	AM	10062018	1	Adult	Black		Black+		Ground Plane	FALSE		0	1	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9745818450109 40.7654498873627)
2363	2363	-73.9690638424196	40.7713869295685	9H-AM-1006-06	09H	AM	10062018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	1	0	1	0		POINT (-73.9690638424196 40.7713869295685)
2425	2425	-73.9791141532217	40.7714888835416	5A-AM-1006-04	05A	AM	10062018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9791141532217 40.77148888354161)
2427	2427	-73.97292974853309	40.767327854143794	4H-AM-1006-03	04H	AM	10062018	3	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1	met #4 while foraging and briefly tussled	0	0	0	0	0	0	1	0		POINT (-73.9729297485331 40.7673278541438)
2539	2539	-73.97810334484679	40.766672406621296	1D-AM-1006-03	01D	AM	10062018	3	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9781033448468 40.7666724066213)
2547	2547	-73.9743393747021	40.767634679832504	3F-AM-1006-12	03F	AM	10062018	12	Juvenile	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9743393747021 40.7676346798325)
2576	2576	-73.9751625910271	40.7671023412885	3F-AM-1006-02	03F	AM	10062018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9751625910271 40.7671023412885)
2605	2605	-73.97368963630059	40.767763086262605	4G-AM-1006-01	04G	AM	10062018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9736896363006 40.7677630862626)
2709	2709	-73.97750689157151	40.7664424394736	1E-AM-1006-01	01E	AM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9775068915715 40.7664424394736)
2792	2792	-73.97237364945971	40.766950134329704	4H-AM-1006-01	04H	AM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9723736494597 40.7669501343297)
2854	2854	-73.9772908667333	40.7697207404744	4C-AM-1006-05	04C	AM	10062018	5	Juvenile	Gray	White	Gray+White		Above Ground	20		0	0	1	1	1		0	0	0	0	0	0	1	0		POINT (-73.9772908667333 40.7697207404744)
2918	2918	-73.9745152462626	40.76554155159079	1G-AM-1006-04	01G	AM	10062018	4	Adult	Gray	White	Gray+White					0	1	0	0	1	collecting nest material	0	0	0	0	1	0	1	0		POINT (-73.9745152462626 40.76554155159081)
2938	2938	-73.97033289561999	40.7701079697795	7H-AM-1006-14	07H	AM	10062018	14	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.97033289562 40.7701079697795)

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