2018_Central_Park_Squirrel_Census_-_Squirrel_Data

52 rows where Date = 10142018, Hectare Squirrel Number = 3 and Tail twitches = 0 sorted by Other Interactions

descending

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	Approaches	Indifferent	Runs from	Other Interactions ▼	Lat/Long
958	958	-73.9613862251332	40.791282169715	32C-AM-1014-03	32C	AM	10142018	3	Adult	Gray		Gray+		Above Ground	3		0	1	1	0	0		0	0	0	0	0		POINT (-73.9613862251332 40.791282169715)
1021	1021	-73.97186968288	40.778926988884	15B-AM-1014-03	15B	AM	10142018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	1	running (from a dog)	0	0	0	1	0		POINT (-73.97186968288 40.778926988884)
1250	1250	-73.9585133340331	40.796372167947396	38C-PM-1014-03	38C	PM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		1	0	0	0	1		POINT (-73.9585133340331 40.7963721679474)
1355	1355	-73.9655277320465	40.780612052936895	20F-AM-1014-03	20F	AM	10142018	3	Adult	Gray		Gray+		Above Ground	30		0	0	1	0	0		1	0	0	0	0		POINT (-73.9655277320465 40.7806120529369)
1395	1395	-73.9710801547498	40.7760872452093	13D-AM-1014-03	13D	AM	10142018	3	Juvenile	Gray	White	Gray+White		Above Ground	2		0	1	1	1	0		0	0	0	0	1		POINT (-73.9710801547498 40.7760872452093)
1443	1443	-73.9728511531484	40.7782654840595	14B-PM-1014-03	14B	PM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1		POINT (-73.9728511531484 40.7782654840595)
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	1	1		POINT (-73.951965247933 40.7938167628067)
1831	1831	-73.9746877519291	40.7761402808083	11B-PM-1014-03	11B	PM	10142018	3		Gray		Gray+		Above Ground	10		0	1	0	0	0		0	0	0	0	0		POINT (-73.9746877519291 40.7761402808083)
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	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	1	0		POINT (-73.973598991549 40.7783020016983)
1987	1987	-73.9573692542155	40.7989252908321	41B-PM-1014-03	41B	PM	10142018	3	Adult	Gray	White	Gray+White		Above Ground	28		0	0	1	0	0		0	0	0	0	0		POINT (-73.9573692542155 40.7989252908321)
1992	1992	-73.9586085843149	40.7946617684536	36C-AM-1014-03	36C	AM	10142018	3		Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1		POINT (-73.9586085843149 40.7946617684536)
2021	2021	-73.95828003055091	40.798947371297395	40B-PM-1014-03	40B	PM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0		POINT (-73.9582800305509 40.7989473712974)
2028	2028	-73.96873477318609	40.7718955594385	10H-AM-1014-03	10H	AM	10142018	3	Juvenile			+		Above Ground	20		0	0	1	0	0		0	0	0	0	0		POINT (-73.9687347731861 40.7718955594385)
2041	2041	-73.9651796685091	40.7785578267586	18G-AM-1014-03	18G	AM	10142018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0		POINT (-73.9651796685091 40.7785578267586)
2055	2055	-73.9806928007664	40.768255422025	1A-PM-1014-03	01A	PM	10142018	3	Adult	Gray	Black	Gray+Black		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1		POINT (-73.9806928007664 40.768255422025)
2096	2096	-73.97089038621759	40.778737067464206	16C-AM-1014-03	16C	AM	10142018	3	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0		POINT (-73.9708903862176 40.7787370674642)
2149	2149	-73.9691845420174	40.7707749899254	9I-AM-1014-03	09I	AM	10142018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	1	0	0		POINT (-73.9691845420174 40.7707749899254)
2154	2154	-73.976716425804	40.7736889979965	8A-PM-1014-03	08A	PM	10142018	3	Juvenile	Gray		Gray+		Above Ground	23		0	0	1	1	0		0	0	0	0	0		POINT (-73.976716425804 40.7736889979965)
2234	2234	-73.9734741818047	40.766328451425	3H-PM-1014-03	03H	PM	10142018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1		POINT (-73.9734741818047 40.766328451425)
2286	2286	-73.95544156650821	40.798420141601795	41D-AM-1014-03	41D	AM	10142018	3	Adult	Gray	Black, Cinnamon	Gray+Black, Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0		POINT (-73.9554415665082 40.7984201416018)
2441	2441	-73.9579865329778	40.794906535675004	37D-PM-1014-03	37D	PM	10142018	3	Adult	Gray		Gray+		Above Ground	40		0	0	1	0	0		0	0	0	0	0		POINT (-73.9579865329778 40.794906535675)
2465	2465	-73.9686999860219	40.784401473513604	22B-PM-1014-03	22B	PM	10142018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	8		1	1	0	0	0		0	0	0	0	0		POINT (-73.9686999860219 40.7844014735136)
2763	2763	-73.96260656728941	40.788722645116	29D-AM-1014-03	29D	AM	10142018	3	Juvenile	Gray		Gray+		Above Ground	35	End of tree limb foraging	0	0	0	0	1		0	0	0	1	0		POINT (-73.9626065672894 40.788722645116)
2910	2910	-73.9506062997507	40.797618949667395	42H-PM-1014-03	42H	PM	10142018	3	Adult			+					0	0	0	0	0		0	0	0	0	1		POINT (-73.9506062997507 40.7976189496674)
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	1		POINT (-73.9545225586988 40.7956074663106)
3013	3013	-73.964661337306	40.7769785494935	17I-AM-1014-03	17I	AM	10142018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Cinnamon face	Above Ground	10		0	0	1	0	0	climbing (dog barked & it ran up tree)	0	0	0	1	0		POINT (-73.964661337306 40.7769785494935)
580	580	-73.97509925643621	40.7743391883762	10B-PM-1014-03	10B	PM	10142018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	avoided people	POINT (-73.9750992564362 40.7743391883762)
168	168	-73.9745691353018	40.777103558929795	13A-PM-1014-03	13A	PM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	6		0	0	1	0	0		0	0	0	0	1	child chasing	POINT (-73.9745691353018 40.7771035589298)
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	1	0	0	followed man across bridge	POINT (-73.9655670884957 40.7763728890554)
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	1	0	indifferent (lots of people taking its picture,didn't bother it)	POINT (-73.9767220179725 40.7753262103123)
2933	2933	-73.9677903197449	40.7826561917755	21C-AM-1014-03	21C	AM	10142018	3	Adult	Gray		Gray+		Above Ground	30		0	1	1	0	0		0	1	0	0	0	looked at us from tree	POINT (-73.9677903197449 40.7826561917755)
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	1	runs from (ran from base of tree into bushes)	POINT (-73.9588689820908 40.799238413797205)

Advanced export

JSON shape: default, array, newline-delimited

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