2018_Central_Park_Squirrel_Census_-_Squirrel_Data

27 rows where Indifferent = 1, Primary Fur Color = "Black" 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

- 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, Date, Hectare Squirrel Number, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, Tail twitches, 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
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)
473	473	-73.95701300171591	40.799602742862504	42B-AM-1014-02	42B	AM	10142018	2	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1	digging	0	0	0	0	0	0	1	0		POINT (-73.9570130017159 40.7996027428625)
481	481	-73.9714303315699	40.774593494770606	11E-AM-1013-04	11E	AM	10132018	4	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1	burying	0	0	0	0	0	0	1	0		POINT (-73.9714303315699 40.7745934947706)
608	608	-73.95896759955171	40.791311922358396	33E-AM-1014-09	33E	AM	10142018	9	Juvenile	Black		Black+		Above Ground	15		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9589675995517 40.7913119223584)
634	634	-73.95963759070379	40.79073477083529	32E-AM-1007-05	32E	AM	10072018	5	Adult	Black		Black+		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9596375907038 40.79073477083531)
731	731	-73.97335458025151	40.7675056025357	4G-AM-1006-04	04G	AM	10062018	4	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9733545802515 40.7675056025357)
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)
770	770	-73.95977827620291	40.79207733767571	33D-AM-1017-07	33D	AM	10172018	7	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1		0	1	0	1	0	0	1	0		POINT (-73.9597782762029 40.7920773376757)
821	821	-73.959077668148	40.7926045823346	34D-AM-1008-02	34D	AM	10082018	2	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.959077668148 40.7926045823346)
1066	1066	-73.9720174997123	40.774889426602705	11D-AM-1010-07	11D	AM	10102018	7	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9720174997123 40.7748894266027)
1193	1193	-73.9731880656287	40.766002618615495	2H-AM-1006-01	02H	AM	10062018	1	Adult	Black		Black+		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9731880656287 40.7660026186155)
1223	1223	-73.95912985511109	40.7919612446005	33E-AM-1014-04	33E	AM	10142018	4	Adult	Black	Cinnamon, White	Black+Cinnamon, White		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9591298551111 40.7919612446005)
1516	1516	-73.9625383795297	40.7883862331728	28D-AM-1012-03	28D	AM	10122018	3	Adult	Black		Black+		Above Ground	30		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9625383795297 40.7883862331728)
1528	1528	-73.9690104245067	40.7853358193723	23A-AM-1018-02	23A	AM	10182018	2	Juvenile	Black		Black+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9690104245067 40.7853358193723)
1979	1979	-73.96127592913992	40.7930468323219	33B-AM-1010-03	33B	AM	10102018	3	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9612759291399 40.7930468323219)
2135	2135	-73.9596251284566	40.7916254797561	33D-AM-1017-05	33D	AM	10172018	5	Adult	Black		Black+		Above Ground	5		0	0	1	0	1		0	0	0	0	1	0	1	0		POINT (-73.9596251284566 40.7916254797561)
2192	2192	-73.9593410965431	40.7923134010383	33D-AM-1017-08	33D	AM	10172018	8	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9593410965431 40.7923134010383)
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)
2395	2395	-73.9729603550254	40.7660215710657	3H-AM-1008-06	03H	AM	10082018	6	Adult	Black		Black+	beauty!	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	1		POINT (-73.9729603550254 40.7660215710657)
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)
2433	2433	-73.9706949930717	40.772362045852	10G-AM-1006-08	10G	AM	10062018	8	Adult	Black	Cinnamon	Black+Cinnamon		Above Ground	3		0	0	0	1	0		0	0	0	1	1	0	1	0		POINT (-73.9706949930717 40.772362045852)
2540	2540	-73.959127912788	40.79211971304029	33E-AM-1014-13	33E	AM	10142018	13	Adult	Black	Cinnamon	Black+Cinnamon	Cinnamon on the tail	Ground Plane	FALSE		0	0	0	0	0	sitting	0	0	0	0	0	0	1	0		POINT (-73.959127912788 40.7921197130403)
2731	2731	-73.9595886063173	40.7918405182594	33D-AM-1017-09	33D	AM	10172018	9	Adult	Black	Cinnamon	Black+Cinnamon		Above Ground	7		0	0	1	0	0		1	1	0	0	0	0	1	1		POINT (-73.9595886063173 40.7918405182594)
2755	2755	-73.9712022111028	40.767250436826295	4I-AM-1006-01	04I	AM	10062018	1	Adult	Black		Black+		Above Ground	3	On top of park lamp	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9712022111028 40.7672504368263)
2768	2768	-73.96410881726321	40.7886555184212	28C-AM-1014-01	28C	AM	10142018	1	Adult	Black		Black+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9641088172632 40.7886555184212)
2773	2773	-73.96259326649559	40.7885379477349	29D-AM-1014-01	29D	AM	10142018	1	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9625932664956 40.7885379477349)
2999	2999	-73.972415182837	40.773080463452004	10E-AM-1010-02	10E	AM	10102018	2	Adult	Black	Gray	Black+Gray		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.972415182837 40.773080463452)

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