2018_Central_Park_Squirrel_Census_-_Squirrel_Data

51 rows where Date = 10142018, Foraging = 0, Indifferent = 1 and Shift = "PM"

- 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, Running, Chasing, Climbing, Eating, Kuks, 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
47	47	-73.9640032826529	40.782030982544796	22F-PM-1014-06	22F	PM	10142018	6	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9640032826529 40.7820309825448)
81	81	-73.9578237168359	40.7980959471034	40B-PM-1014-06	40B	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9578237168359 40.7980959471034)
158	158	-73.9710991123992	40.77238897266471	9F-PM-1014-02	09F	PM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9710991123992 40.7723889726647)
359	359	-73.9716404781264	40.7753181851766	12D-PM-1014-02	12D	PM	10142018	2	Adult	Gray	White	Gray+White		Above Ground	15		0	0	1	0	0	seems to be grinding teeth on a piece of material (sounds from grinding)	0	0	0	0	0	0	1	0		POINT (-73.9716404781264 40.7753181851766)
378	378	-73.95848354168459	40.7978213396921	39B-PM-1014-06	39B	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9584835416846 40.7978213396921)
415	415	-73.95701318903791	40.799178673612396	41B-PM-1014-05	41B	PM	10142018	5	Adult	Gray		Gray+		Above Ground	25		0	0	1	0	0		1	0	0	0	0	0	1	1		POINT (-73.9570131890379 40.7991786736124)
499	499	-73.96572880550109	40.776458003628704	16H-PM-1014-04	16H	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9657288055011 40.7764580036287)
577	577	-73.9497217674555	40.796517007214	42I-PM-1014-03	42I	PM	10142018	3		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9497217674555 40.796517007214)
742	742	-73.9767016963397	40.7674012784541	2E-PM-1014-02	02E	PM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9767016963397 40.7674012784541)
840	840	-73.9598084794625	40.797616543450204	39A-PM-1014-01	39A	PM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9598084794625 40.7976165434502)
878	878	-73.9757215415855	40.766820597698604	2F-PM-1014-03	02F	PM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9757215415855 40.7668205976986)
885	885	-73.97504638449841	40.7666871742836	2F-PM-1014-08	02F	PM	10142018	8	Adult	Gray	Black	Gray+Black		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9750463844984 40.7666871742836)
985	985	-73.9681722244801	40.783559826281	22B-PM-1014-07	22B	PM	10142018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9681722244801 40.783559826281)
1122	1122	-73.9728700359494	40.7659842666881	3H-PM-1014-05	03H	PM	10142018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9728700359494 40.7659842666881)
1255	1255	-73.9717469822209	40.7753731930704	12D-PM-1014-03	12D	PM	10142018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9717469822209 40.7753731930704)
1417	1417	-73.974828939898	40.7668886121909	2F-PM-1014-11	02F	PM	10142018	11	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.974828939898 40.7668886121909)
1427	1427	-73.9755321998542	40.766831157600706	2F-PM-1014-01	02F	PM	10142018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.97553219985421 40.7668311576007)
1527	1527	-73.970216605149	40.7702960667277	8H-PM-1014-08	08H	PM	10142018	8	Adult	Gray		Gray+		Above Ground	5		0	1	0	0	0	chasing (#7),playing?	0	0	0	0	0	0	1	0		POINT (-73.970216605149 40.7702960667277)
1537	1537	-73.97672201797249	40.77532621031229	10A-PM-1014-03	10A	PM	10142018	3	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Above Ground		above my head in tree	0	0	0	1	0	eating (in a tree)	0	0	0	0	0	0	1	0	indifferent (lots of people taking its picture,didn't bother it)	POINT (-73.9767220179725 40.7753262103123)
1604	1604	-73.9734644470766	40.7782766486921	14A-PM-1014-05	14A	PM	10142018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.97346444707661 40.7782766486921)
1639	1639	-73.9736800575584	40.778306973575795	14A-PM-1014-04	14A	PM	10142018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	0	0	chasing (#3)	0	0	0	0	1	0	1	0		POINT (-73.9736800575584 40.7783069735758)
1665	1665	-73.95839443533521	40.7979689846815	39B-PM-1014-04	39B	PM	10142018	4	Adult	Gray		Gray+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	1	1	runs from (me—when i approached)	POINT (-73.9583944353352 40.7979689846815)
1666	1666	-73.96494654768709	40.7822708362663	22F-PM-1014-07	22F	PM	10142018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9649465476871 40.7822708362663)
1667	1667	-73.96459890035891	40.778215745915496	18H-PM-1014-01	18H	PM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9645989003589 40.7782157459155)
1682	1682	-73.97592584072879	40.7667622711142	2F-PM-1014-05	02F	PM	10142018	5	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9759258407288 40.7667622711142)
1735	1735	-73.9563652303243	40.795512787396795	38E-PM-1014-05	38E	PM	10142018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	on log	0	0	0	0	0	statue	0	0	0	0	0	0	1	0		POINT (-73.9563652303243 40.7955127873968)
1771	1771	-73.9750688083336	40.766558468102495	2F-PM-1014-07	02F	PM	10142018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9750688083336 40.7665584681025)
1775	1775	-73.951965247933	40.7938167628067	38I-PM-1014-03	38I	PM	10142018	3	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	1		POINT (-73.951965247933 40.7938167628067)
1817	1817	-73.9703076450783	40.770158422628995	8H-PM-1014-07	08H	PM	10142018	7	Adult	Gray		Gray+		Above Ground	5		0	1	0	0	0	chasing (#8),playing?	0	0	0	0	0	0	1	0		POINT (-73.9703076450783 40.770158422629)
1860	1860	-73.9767100101318	40.7675779951996	2E-PM-1014-03	02E	PM	10142018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9767100101318 40.7675779951996)
1876	1876	-73.973598991549	40.7783020016983	14A-PM-1014-03	14A	PM	10142018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	0	0	chasing (#4)	0	0	0	0	0	0	1	0		POINT (-73.973598991549 40.7783020016983)
1930	1930	-73.9744279648953	40.7777760612191	13A-PM-1014-01	13A	PM	10142018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9744279648953 40.7777760612191)
2016	2016	-73.9589492240754	40.798901118974	40A-PM-1014-01	40A	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	30		0	0	1	0	0		0	0	0	0	1	0	1	0	stared & then went back up tree—then ran to different tree	POINT (-73.9589492240754 40.798901118974)
2052	2052	-73.97464934414141	40.7750478734868	11B-PM-1014-06	11B	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		0	0	0	0	0	cleaning	0	0	0	0	0	0	1	0		POINT (-73.9746493441414 40.7750478734868)
2054	2054	-73.97263812347471	40.7752694815985	12D-PM-1014-01	12D	PM	10142018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9726381234747 40.7752694815985)
2112	2112	-73.9655206571055	40.7764851568746	16H-PM-1014-02	16H	PM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9655206571055 40.7764851568746)
2128	2128	-73.9757673193743	40.7669614322613	2F-PM-1014-04	02F	PM	10142018	4	Adult	Gray		Gray+		Above Ground	20		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9757673193743 40.766961432261304)
2160	2160	-73.975028559002	40.7667307335544	2F-PM-1014-09	02F	PM	10142018	9	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.975028559002 40.7667307335544)
2270	2270	-73.9703732649257	40.77019793771029	8H-PM-1014-04	08H	PM	10142018	4	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.97037326492571 40.7701979377103)
2325	2325	-73.9728360875598	40.7660637295671	3H-PM-1014-04	03H	PM	10142018	4	Adult	Black	Cinnamon	Black+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9728360875598 40.7660637295671)
2410	2410	-73.97551920769341	40.7664413570796	2F-PM-1014-06	02F	PM	10142018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9755192076934 40.7664413570796)
2507	2507	-73.964868521585	40.7821064183815	22F-PM-1014-01	22F	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.964868521585 40.7821064183815)
2558	2558	-73.97494695668541	40.7667805367199	2F-PM-1014-10	02F	PM	10142018	10	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9749469566854 40.7667805367199)
2580	2580	-73.970795746101	40.77047272122989	8H-PM-1014-01	08H	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.970795746101 40.7704727212299)
2632	2632	-73.95082755733499	40.797579073666	42H-PM-1014-02	42H	PM	10142018	2	Adult	Gray	White	Gray+White		Above Ground		Running along stone ledge	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.950827557335 40.797579073666)
2696	2696	-73.9501457233643	40.797094356558	42I-PM-1014-01	42I	PM	10142018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9501457233643 40.797094356558)
2804	2804	-73.9576094432477	40.7965342664074	38C-PM-1014-07	38C	PM	10142018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9576094432477 40.7965342664074)
2916	2916	-73.95175251116791	40.7974407641075	42G-PM-1014-02	42G	PM	10142018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	14		0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9517525111679 40.7974407641075)
2920	2920	-73.9657391918196	40.776502470347	16H-PM-1014-01	16H	PM	10142018	1	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9657391918196 40.776502470347)
2945	2945	-73.9649103330443	40.7823913860445	22F-PM-1014-08	22F	PM	10142018	8	Adult	Gray		Gray+		Above Ground	10	CLIMBED THE TREE	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9649103330443 40.7823913860445)
2980	2980	-73.97164145863809	40.771760114722	9F-PM-1014-06	09F	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	0	running (from birds)	0	0	0	1	0	0	1	0		POINT (-73.9716414586381 40.771760114722)

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