2018_Central_Park_Squirrel_Census_-_Squirrel_Data

49 rows where Above Ground Sighter Measurement = "FALSE", Date = 10142018, Foraging = 0 and Indifferent = 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: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Climbing, Eating, Kuks, Tail flags, Tail twitches, Approaches, Runs from, Other Interactions

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
37	37	-73.96431539204279	40.78208185169571	22F-PM-1014-05	22F	PM	10142018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9643153920428 40.7820818516957)
42	42	-73.9579564338627	40.795933779502704	38C-PM-1014-09	38C	PM	10142018	9	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	1	0	0		POINT (-73.9579564338627 40.7959337795027)
167	167	-73.95976427784271	40.7976368003915	39A-PM-1014-02	39A	PM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9597642778427 40.7976368003915)
213	213	-73.968367485157	40.7838472644815	22B-PM-1014-05	22B	PM	10142018	5		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0	eating (eats with head tilted far to the right (tooth issue?))	0	0	0	0	0	0	0	0		POINT (-73.968367485157 40.7838472644815)
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)
277	277	-73.96190702296741	40.795255669250004	35A-AM-1014-05	35A	AM	10142018	5	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9619070229674 40.79525566925)
338	338	-73.9765595553183	40.7748455340432	10A-PM-1014-04	10A	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9765595553183 40.7748455340432)
386	386	-73.95503513809571	40.7974681522214	40E-AM-1014-01	40E	AM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9550351380957 40.7974681522214)
465	465	-73.9683041099256	40.786265230008205	24A-AM-1014-01	24A	AM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0	freezes	POINT (-73.9683041099256 40.7862652300082)
494	494	-73.958837574505	40.7985003987784	40A-PM-1014-06	40A	PM	10142018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.958837574505 40.7985003987784)
501	501	-73.9708798496132	40.7761532088521	13D-AM-1014-06	13D	AM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9708798496132 40.7761532088521)
517	517	-73.954959868822	40.7985404965582	41D-PM-1014-03	41D	PM	10142018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.954959868822 40.7985404965582)
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)
594	594	-73.9727488640736	40.7781916780621	14B-PM-1014-06	14B	PM	10142018	6	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	watching me	0	0	0	0	0	1	0	0	skittish	POINT (-73.9727488640736 40.7781916780621)
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)
709	709	-73.9519387881692	40.7936273636929	38I-PM-1014-04	38I	PM	10142018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9519387881692 40.7936273636929)
898	898	-73.95428280532559	40.794179732035495	37G-AM-1014-03	37G	AM	10142018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9542828053256 40.7941797320355)
974	974	-73.9753744539307	40.7671162211032	2F-PM-1014-12	02F	PM	10142018	12	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.97537445393071 40.7671162211032)
1075	1075	-73.9640534906634	40.777738389983604	17I-AM-1014-02	17I	AM	10142018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0	standing upright	0	0	0	0	0	1	0	1	runs from (only ran away when a grandpa chased it off)	POINT (-73.9640534906634 40.7777383899836)
1102	1102	-73.9688173465755	40.7782009764626	16E-AM-1014-08	16E	AM	10142018	8	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	runs from (dog)	POINT (-73.9688173465755 40.7782009764626)
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)
1314	1314	-73.980919134781	40.7683772453336	1A-PM-1014-06	01A	PM	10142018	6	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		1	0	0	0	0	0	0	1		POINT (-73.980919134781 40.7683772453336)
1510	1510	-73.9655670884957	40.7763728890554	16H-PM-1014-03	16H	PM	10142018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	1	0	0	followed man across bridge	POINT (-73.9655670884957 40.7763728890554)
1584	1584	-73.9581310602492	40.7960214726964	38C-PM-1014-05	38C	PM	10142018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	0	0	chasing (#4)	0	0	0	0	0	0	0	1		POINT (-73.9581310602492 40.7960214726964)
1635	1635	-73.95607317386771	40.798033601855394	41D-PM-1014-02	41D	PM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9560731738677 40.7980336018554)
1732	1732	-73.97671414072741	40.7737313251559	8A-PM-1014-02	08A	PM	10142018	2	Juvenile	Gray		Gray+		Ground Plane	FALSE		0	0	1	1	0		0	0	0	0	0	0	0	1	runs from (goes up a tree)	POINT (-73.9767141407274 40.7737313251559)
1803	1803	-73.9588076804698	40.7912942607296	33E-AM-1014-06	33E	AM	10142018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9588076804698 40.7912942607296)
1844	1844	-73.9682062012675	40.786498436192005	24A-AM-1014-02	24A	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Blonde? in Highlights	Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9682062012675 40.786498436192)
1884	1884	-73.9733898487296	40.7666975131518	3H-PM-1014-02	03H	PM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9733898487296 40.7666975131518)
1908	1908	-73.95883455468791	40.7991830272008	40A-PM-1014-02	40A	PM	10142018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	runs from (ran from base of tree into bushes)	POINT (-73.9588345546879 40.7991830272008)
1965	1965	-73.9719359643975	40.772699885583	9F-PM-1014-01	09F	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0	he is fed every day by a woman who calls him "chiquita"! he ran right up to her.	POINT (-73.9719359643975 40.772699885583)
2047	2047	-73.9721656413591	40.7722869065638	9F-PM-1014-08	09F	PM	10142018	8	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0	turned to face me while eating	POINT (-73.9721656413591 40.7722869065638)
2070	2070	-73.9725700261894	40.7668793330427	3H-PM-1014-01	03H	PM	10142018	1	Adult	Gray		Gray+		Ground Plane	FALSE	under a parked car	1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9725700261894 40.7668793330427)
2086	2086	-73.9525627119429	40.793860286746394	38I-PM-1014-02	38I	PM	10142018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	hanging out w/ Squirrel #1	0	0	0	0	0	scampering w/ squirrel #1	0	0	0	0	1	0	0	1		POINT (-73.9525627119429 40.7938602867464)
2261	2261	-73.9609692861012	40.790502891247	31D-AM-1014-07	31D	AM	10142018	7		Gray		Gray+		Ground Plane	FALSE	Crossing path to tree	1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9609692861012 40.790502891247)
2279	2279	-73.9586085858962	40.7990326758282	40A-PM-1014-04	40A	PM	10142018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	runs from (ran from path to bushes)	POINT (-73.9586085858962 40.7990326758282)
2307	2307	-73.9736997033862	40.778497952406	14A-PM-1014-02	14A	PM	10142018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9736997033862 40.778497952406)
2416	2416	-73.95886898209079	40.799238413797205	40A-PM-1014-03	40A	PM	10142018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	runs from (ran from base of tree into bushes)	POINT (-73.9588689820908 40.799238413797205)
2536	2536	-73.96850872880721	40.7779068128051	16E-AM-1014-01	16E	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	burying food	0	0	0	0	0	1	0	0		POINT (-73.9685087288072 40.7779068128051)
2551	2551	-73.970138810251	40.770579297644	8H-PM-1014-02	08H	PM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0	froze & watched me,then went back to eating	POINT (-73.970138810251 40.770579297644)
2618	2618	-73.95795157569	40.7961254697958	38C-PM-1014-04	38C	PM	10142018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	1	0		0	0	0	1	0	0	0	1		POINT (-73.95795157569 40.7961254697958)
2621	2621	-73.9596904740342	40.7897200025671	31E-AM-1014-01	31E	AM	10142018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9596904740342 40.7897200025671)
2809	2809	-73.9686756254868	40.777745910265104	16E-AM-1014-04	16E	AM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9686756254868 40.7777459102651)
2881	2881	-73.9541629063295	40.7934259301577	37G-AM-1014-02	37G	AM	10142018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0	ran away & disappeared	0	0	0	0	0	0	0	0		POINT (-73.9541629063295 40.7934259301577)
2899	2899	-73.9686358129525	40.7778035516486	16E-AM-1014-05	16E	AM	10142018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9686358129525 40.7778035516486)
2936	2936	-73.9809876538513	40.768322324214296	1A-PM-1014-05	01A	PM	10142018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9809876538513 40.7683223242143)
2948	2948	-73.9545225586988	40.7956074663106	39F-AM-1014-03	39F	AM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9545225586988 40.7956074663106)
2951	2951	-73.9742986032935	40.7770454318226	13A-PM-1014-04	13A	PM	10142018	4		Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9742986032935 40.7770454318226)
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
);