2018_Central_Park_Squirrel_Census_-_Squirrel_Data

22 rows where Foraging = 1, Primary Fur Color = "Black" and Shift = "AM" sorted by Kuks

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	Quaas	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	1	0		POINT (-73.9680635070949 40.779249873647)
227	227	-73.95981553009129	40.7905887826983	32E-AM-1007-10	32E	AM	10072018	10	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0		POINT (-73.9598155300913 40.7905887826983)
325	325	-73.96309908232429	40.788576428401605	28D-AM-1012-02	28D	AM	10122018	2	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1		POINT (-73.9630990823243 40.7885764284016)
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	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	1	0		POINT (-73.9714303315699 40.7745934947706)
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		1	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	1	0		POINT (-73.959077668148 40.7926045823346)
1057	1057	-73.9594406225891	40.7918533707789	33D-AM-1017-02	33D	AM	10172018	2	Adult	Black	Cinnamon	Black+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	1	1	0	0		POINT (-73.9594406225891 40.7918533707789)
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	1	0		POINT (-73.9720174997123 40.7748894266027)
1101	1101	-73.95912925497	40.7925530280455	34D-AM-1008-01	34D	AM	10082018	1	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	staring at us	POINT (-73.95912925497001 40.7925530280455)
1892	1892	-73.9745908987975	40.7655191512308	1G-AM-1006-03	01G	AM	10062018	3	Adult	Black	Cinnamon	Black+Cinnamon		Ground Plane	FALSE		0	1	0	0	1		0	0	0	1	0	0		POINT (-73.9745908987975 40.7655191512308)
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	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	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	1	0		POINT (-73.9593410965431 40.7923134010383)
2284	2284	-73.9730181306326	40.779460132242704	16A-AM-1013-02	16A	AM	10132018	2	Adult	Black		Black+		Above Ground			0	0	0	0	1		0	0	0	1	0	0		POINT (-73.9730181306326 40.7794601322427)
2322	2322	-73.97236778547979	40.766731541087104	3H-AM-1008-04	03H	AM	10082018	4	Adult	Black		Black+		Above Ground	50		0	0	0	0	1		0	0	0	0	0	0		POINT (-73.9723677854798 40.7667315410871)
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	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	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	1	0		POINT (-73.9729297485331 40.7673278541438)
2651	2651	-73.9632993246327	40.78881995196561	29C-AM-1007-05	29C	AM	10072018	5	Adult	Black	Gray	Black+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0		POINT (-73.9632993246327 40.7888199519656)
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	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	1	0	1	0		POINT (-73.972415182837 40.773080463452)

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