2018_Central_Park_Squirrel_Census_-_Squirrel_Data

165 rows where Date = 10082018 and Shift = "AM" sorted by Specific Location

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	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
2190	2190	-73.9657040391563	40.7755567428199	15I-AM-1008-06	15I	AM	10082018	6	Adult	Cinnamon	White	Cinnamon+White		Above Ground	12		0	0	0	1	0		0	0	0	0	1	0		POINT (-73.9657040391563 40.7755567428199)
2218	2218	-73.9694382427984	40.7846350692923	22A-AM-1008-04	22A	AM	10082018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	1	0	0	1		POINT (-73.9694382427984 40.7846350692923)
2239	2239	-73.9668922014699	40.7823535653774	21D-AM-1008-06	21D	AM	10082018	6	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1		POINT (-73.9668922014699 40.7823535653774)
2264	2264	-73.97735205827341	40.7708198505781	5B-AM-1008-04	05B	AM	10082018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	1	0		POINT (-73.9773520582734 40.7708198505781)
2268	2268	-73.9590191655172	40.7926139425111	34D-AM-1008-03	34D	AM	10082018	3	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0		POINT (-73.9590191655172 40.7926139425111)
2269	2269	-73.9695518341907	40.776214599393704	14E-AM-1008-15	14E	AM	10082018	15	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1	walking	0	0	0	0	1	0		POINT (-73.9695518341907 40.7762145993937)
2271	2271	-73.96739494580959	40.7826218539496	21D-AM-1008-04	21D	AM	10082018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	1	0	0	1		POINT (-73.9673949458096 40.78262185394961)
2318	2318	-73.967458693983	40.7769922522105	15G-AM-1008-02	15G	AM	10082018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	1		POINT (-73.967458693983 40.7769922522105)
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)
2334	2334	-73.97549229705109	40.7707686392991	6D-AM-1008-03	06D	AM	10082018	3	Juvenile	Gray		Gray+		Above Ground	10		0	0	0	0	0		0	0	0	0	0	0		POINT (-73.9754922970511 40.7707686392991)
2355	2355	-73.9728654439465	40.7724853142211	9E-AM-1008-04	09E	AM	10082018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0		POINT (-73.9728654439465 40.7724853142211)
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)
2450	2450	-73.9756273257684	40.7706539186221	6D-AM-1008-04	06D	AM	10082018	4	Adult	Gray		Gray+		Above Ground			0	0	1	0	0		0	0	0	0	0	0		POINT (-73.9756273257684 40.7706539186221)
2489	2489	-73.9663168490265	40.7825083721362	21D-AM-1008-01	21D	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	1	1	0	1	0		POINT (-73.9663168490265 40.7825083721362)
2499	2499	-73.96900799240942	40.7845473505585	22A-AM-1008-06	22A	AM	10082018	6	Adult	Gray		Gray+		Above Ground	30		0	0	0	1	0		0	0	0	0	0	0		POINT (-73.9690079924094 40.7845473505585)
2516	2516	-73.96498236876509	40.7763395359636	16I-AM-1008-02	16I	AM	10082018	2	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	1		0	0	1	0	0		0	0	0	0	1	0		POINT (-73.9649823687651 40.7763395359636)
2563	2563	-73.9664536611195	40.7827694131949	21D-AM-1008-03	21D	AM	10082018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0		POINT (-73.9664536611195 40.7827694131949)
2584	2584	-73.9727187453699	40.7669595710626	3H-AM-1008-02	03H	AM	10082018	2	Adult	Gray		Gray+		Above Ground			0	0	1	0	0		0	0	0	0	1	0		POINT (-73.9727187453699 40.7669595710626)
2619	2619	-73.9739737592602	40.772713047677705	9D-AM-1008-04	09D	AM	10082018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0		POINT (-73.9739737592602 40.7727130476777)
2630	2630	-73.965019827314	40.775986429132296	15I-AM-1008-03	15I	AM	10082018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0		POINT (-73.965019827314 40.7759864291323)
2665	2665	-73.969784066769	40.77669404054029	14E-AM-1008-11	14E	AM	10082018	11	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1	burying	0	0	0	0	1	0	curious	POINT (-73.969784066769 40.7766940405403)
2680	2680	-73.9721348050673	40.7666920046704	3H-AM-1008-01	03H	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	8		0	0	0	0	0	teasing barking dog	0	0	0	0	1	0	indifferent by not caring about dog	POINT (-73.9721348050673 40.7666920046704)
2713	2713	-73.9687214684206	40.779284172016396	17D-AM-1008-07	17D	AM	10082018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0		POINT (-73.9687214684206 40.7792841720164)
2749	2749	-73.972967003211	40.7711848438157	7F-AM-1008-17	07F	AM	10082018	17	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1	scratching self	0	0	0	0	0	1		POINT (-73.972967003211 40.7711848438157)
2793	2793	-73.9742847552668	40.7731740123046	9D-AM-1008-02	09D	AM	10082018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0		POINT (-73.9742847552668 40.7731740123046)
2850	2850	-73.9744847446854	40.76924227444	5E-AM-1008-04	05E	AM	10082018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0		POINT (-73.9744847446854 40.76924227444)
2871	2871	-73.9777124331985	40.7704051056666	5B-AM-1008-03	05B	AM	10082018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	1	0		POINT (-73.9777124331985 40.7704051056666)
2886	2886	-73.9729265300533	40.774176829164205	10D-AM-1008-02	10D	AM	10082018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	1		POINT (-73.9729265300533 40.7741768291642)
2917	2917	-73.9770313887741	40.7724869252099	7B-AM-1008-05	07B	AM	10082018	5	Adult	Gray		Gray+		Above Ground			0	1	0	0	0		0	0	0	0	1	0		POINT (-73.9770313887741 40.772486925209904)
2921	2921	-73.9699573485164	40.7765857838015	14E-AM-1008-10	14E	AM	10082018	10	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0		POINT (-73.9699573485164 40.7765857838015)
2925	2925	-73.96721526968341	40.782387458182896	21D-AM-1008-05	21D	AM	10082018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	1		POINT (-73.9672152696834 40.7823874581829)
2984	2984	-73.9700158929437	40.7762359066591	14E-AM-1008-18	14E	AM	10082018	18	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0		POINT (-73.9700158929437 40.7762359066591)
279	279	-73.9550082056509	40.7894521543449	33I-AM-1008-03	33I	AM	10082018	3	Adult	Gray		Gray+		Above Ground	2	98th @ edge of park	0	0	1	0	0		0	0	0	0	1	0		POINT (-73.9550082056509 40.7894521543449)
2552	2552	-73.97249477106979	40.7696619340886	6G-AM-1008-05	06G	AM	10082018	5	Adult	Gray		Gray+		Above Ground	30	branch	0	0	1	0	0	sitting	0	0	0	0	1	0		POINT (-73.9724947710698 40.7696619340886)
2452	2452	-73.9727323797981	40.766903546395504	3H-AM-1008-03	03H	AM	10082018	3	Adult	Gray		Gray+		Above Ground	40	building nest	0	0	1	0	0		0	0	0	0	1	0		POINT (-73.9727323797981 40.7669035463955)
56	56	-73.97246424363941	40.7690526441109	6G-AM-1008-02	06G	AM	10082018	2	Juvenile	Gray		Gray+		Ground Plane	FALSE	bush	0	0	0	0	1		0	0	0	0	1	0		POINT (-73.9724642436394 40.7690526441109)
1288	1288	-73.97304542959971	40.77029094543921	7F-AM-1008-05	07F	AM	10082018	5	Adult	Gray		Gray+		Ground Plane	FALSE	bush	0	1	0	0	0		0	0	0	0	1	0		POINT (-73.9730454295997 40.7702909454392)
2340	2340	-73.9730284815849	40.7702462529502	7F-AM-1008-04	07F	AM	10082018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE	bush	0	1	0	0	0		0	0	0	0	1	0		POINT (-73.9730284815849 40.7702462529502)
2258	2258	-73.95477850811709	40.789612183711	33I-AM-1008-02	33I	AM	10082018	2	Adult	Gray		Gray+		Above Ground	3	edge of park @ 98th	0	0	1	0	0		0	0	1	0	1	0		POINT (-73.9547785081171 40.789612183711)
2146	2146	-73.95473986848171	40.7896483795302	33I-AM-1008-01	33I	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	edge of park @ 98th (north)	0	0	0	0	1		0	0	0	0	1	0		POINT (-73.9547398684817 40.7896483795302)
1769	1769	-73.9721086069437	40.7698172190404	6G-AM-1008-06	06G	AM	10082018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	white at end of tail	Ground Plane	FALSE	grass	0	0	0	0	1		0	0	1	0	1	0		POINT (-73.9721086069437 40.7698172190404)
1981	1981	-73.972154069981	40.769012800972206	6G-AM-1008-03	06G	AM	10082018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE	grass	0	0	0	1	1		0	1	0	0	1	0		POINT (-73.972154069981 40.7690128009722)
686	686	-73.9695745672033	40.7791835122147	17D-AM-1008-06	17D	AM	10082018	6				+		Above Ground		high in tree, couldn't see it, only heard it	0	0	0	0	0		1	0	0	0	0	0		POINT (-73.9695745672033 40.7791835122147)
1770	1770	-73.97281709807791	40.770355783043705	7F-AM-1008-06	07F	AM	10082018	6	Adult	Gray		Gray+		Above Ground	28	in hole in tree	0	0	0	0	0	sitting	0	0	0	0	1	0		POINT (-73.9728170980779 40.770355783043705)
1239	1239	-73.9725897240269	40.7691342079294	6G-AM-1008-01	06G	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20	in tree	0	0	0	0	0	sitting	0	0	0	0	1	0		POINT (-73.9725897240269 40.7691342079294)
982	982	-73.9676424599715	40.777776610680704	16F-AM-1008-01	16F	AM	10082018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE	near fence	0	0	0	0	1		0	0	1	1	0	0		POINT (-73.9676424599715 40.7777766106807)
1593	1593	-73.9676539688726	40.7777229934129	16F-AM-1008-02	16F	AM	10082018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	near fence	0	0	0	0	1		0	0	1	0	0	0		POINT (-73.9676539688726 40.7777229934129)
2267	2267	-73.97279263353971	40.77037055775	7F-AM-1008-07	07F	AM	10082018	7	Adult	Gray		Gray+		Above Ground	28	next to the hole of #6	0	0	0	0	0	standing	0	0	0	0	1	0		POINT (-73.9727926335397 40.77037055775)
2706	2706	-73.9745141185576	40.76914797812071	5E-AM-1008-01	05E	AM	10082018	1	Adult	Gray	White	Gray+White		Above Ground	2	on a checker table	0	0	0	1	0		0	0	0	0	1	0		POINT (-73.9745141185576 40.7691479781207)
615	615	-73.96532790698879	40.7758743113817	15I-AM-1008-02	15I	AM	10082018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Could be same squirrel as #1?	Above Ground	4	on fence	0	0	0	1	0		0	0	0	0	0	1		POINT (-73.9653279069888 40.7758743113817)
2017	2017	-73.9775067398903	40.772656614240105	7B-AM-1008-14	07B	AM	10082018	14	Adult	Gray		Gray+		Above Ground		on fence	0	0	1	0	0		0	0	0	0	1	0		POINT (-73.9775067398903 40.7726566142401)
2456	2456	-73.9698446365683	40.784260716857794	22A-AM-1008-01	22A	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4	on fence	0	0	0	1	0		0	0	0	0	0	0		POINT (-73.9698446365683 40.7842607168578)
2831	2831	-73.9753585157592	40.7698398607941	5E-AM-1008-07	05E	AM	10082018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1	on fence	0	0	0	0	1		0	0	0	0	1	0		POINT (-73.9753585157592 40.7698398607941)
1162	1162	-73.95685442708809	40.7972517274475	39D-AM-1008-06	39D	AM	10082018	6	Adult	Gray		Gray+		Above Ground	3	on rock	0	0	0	0	0		0	0	0	0	0	1		POINT (-73.9568544270881 40.7972517274475)
2091	2091	-73.96761128642859	40.7772792086081	16F-AM-1008-03	16F	AM	10082018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	road	1	0	0	0	0		0	0	1	0	1	0		POINT (-73.9676112864286 40.7772792086081)
2648	2648	-73.97294104880208	40.770948496457706	7F-AM-1008-13	07F	AM	10082018	13	Adult	Gray		Gray+		Above Ground	4	to tree	1	0	0	1	1	ran up tree 4 feet and ate leaves	0	0	0	0	1	0		POINT (-73.9729410488021 40.7709484964577)
80	80	-73.9688454483585	40.78453012881629	22A-AM-1008-05	22A	AM	10082018	5	Adult	Gray	White	Gray+White		Above Ground	3	trash can	0	0	0	1	0		0	1	0	0	0	1		POINT (-73.9688454483585 40.7845301288163)
98	98	-73.9730277911422	40.771214548882796	7F-AM-1008-16	07F	AM	10082018	16	Juvenile	Gray		Gray+		Above Ground	2	tree	0	0	0	0	0		0	0	0	0	0	1		POINT (-73.9730277911422 40.7712145488828)
112	112	-73.96517544644391	40.7755181941559	15I-AM-1008-01	15I	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	7	tree	0	0	1	1	0		0	0	0	0	1	0		POINT (-73.9651754464439 40.7755181941559)
1079	1079	-73.9722737593623	40.768963018754	6G-AM-1008-04	06G	AM	10082018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon	very long tail	Above Ground	20	tree	1	0	1	0	0		0	0	1	0	0	1		POINT (-73.9722737593623 40.768963018754)
1003	1003	-73.9645547556826	40.776877007081	16I-AM-1008-04	16I	AM	10082018	4	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	9	tree hollow	0	0	0	0	0	in hollow	0	0	0	0	0	0	curious	POINT (-73.9645547556826 40.776877007081)
1661	1661	-73.974519308015	40.7691228794395	5E-AM-1008-02	05E	AM	10082018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	8	trellis	1	0	0	0	1		0	0	0	1	0	0		POINT (-73.974519308015 40.7691228794395)
2429	2429	-73.97266996869429	40.770112379122295	7F-AM-1008-01	07F	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	under bench	0	0	0	0	1		0	1	0	0	1	0		POINT (-73.9726699686943 40.7701123791223)
2177	2177	-73.9758211560957	40.7693422860766	5E-AM-1008-10	05E	AM	10082018	10	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	6	up a tree	1	0	0	0	1		0	0	0	0	1	0		POINT (-73.9758211560957 40.7693422860766)
377	377	-73.9757001944781	40.769499790547	5E-AM-1008-09	05E	AM	10082018	9	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	2	went up tree	1	0	0	0	0		0	0	0	0	1	0		POINT (-73.9757001944781 40.769499790547)

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