2018_Central_Park_Squirrel_Census_-_Squirrel_Data

32 rows where Date = 10082018 and Hectare Squirrel Number = 4 sorted by Shift

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	Climbing	Eating	Foraging	Kuks	Tail twitches	Indifferent	Runs from	Other Interactions	Lat/Long
897	897	-73.97346875380642	40.769430895922206	6F-PM-1008-04	06F	PM	10082018	4	Adult	Cinnamon	White	Cinnamon+White	patches of white on haunches	Ground Plane	FALSE		0	0	0	1	0	0	0	0		POINT (-73.9734687538064 40.7694308959222)
1089	1089	-73.9655955841325	40.7762063860571	15H-PM-1008-04	15H	PM	10082018	4		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	edge of landscape	0	0	0	1	0	0	1	0		POINT (-73.9655955841325 40.7762063860571)
1237	1237	-73.9705370795538	40.7761725434851	13E-PM-1008-04	13E	PM	10082018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Gray & Cinnamon selected as Primary. Gray selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	1	0	1	0	0	he took 2 steps then turned and stared at me	POINT (-73.9705370795538 40.7761725434851)
1401	1401	-73.9681202146851	40.7743979416812	13G-PM-1008-04	13G	PM	10082018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	lawn @ edge of landscaped area	0	0	0	1	0	0	1	0		POINT (-73.9681202146851 40.7743979416812)
1450	1450	-73.9580813119325	40.79055382370421	32F-PM-1008-04	32F	PM	10082018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0	0	0	0		POINT (-73.9580813119325 40.7905538237042)
1508	1508	-73.96938943057859	40.775690674802604	13F-PM-1008-04	13F	PM	10082018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	0	0	1	0	0	0		POINT (-73.9693894305786 40.7756906748026)
1802	1802	-73.9736418085696	40.7716931127716	8E-PM-1008-04	08E	PM	10082018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE	in grass by a grove of tall maples	0	0	1	1	0	0	1	0	there's a family playing soccer	POINT (-73.9736418085696 40.7716931127716)
2690	2690	-73.9572840457971	40.788693337174394	31H-PM-1008-04	31H	PM	10082018	4	Adult	Gray		Gray+		Above Ground		Also way up	0	1	0	1	0	0	0	0		POINT (-73.95728404579711 40.7886933371744)
2722	2722	-73.96922711321359	40.777528508844	15E-PM-1008-04	15E	PM	10082018	4	Adult	Gray		Gray+		Above Ground	10		0	1	0	0	0	0	1	0		POINT (-73.9692271132136 40.777528508844)
2734	2734	-73.9763629541474	40.7682321897044	3E-PM-1008-04	03E	PM	10082018	4	Adult	Gray		Gray+		Above Ground	6		1	1	0	0	0	0	0	1		POINT (-73.9763629541474 40.7682321897044)
2862	2862	-73.967466716152	40.782434654827796	21D-PM-1008-04	21D	PM	10082018	4	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	4		0	0	1	0	0	0	0	1	i scared it	POINT (-73.967466716152 40.7824346548278)
2952	2952	-73.9763719445827	40.768955141333706	4D-PM-1008-04	04D	PM	10082018	4	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	0	1	0	0	1	0		POINT (-73.9763719445827 40.7689551413337)

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