2018_Central_Park_Squirrel_Census_-_Squirrel_Data

55 rows where Date = 10072018, Location = "Ground Plane" and Running = 1

- 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: Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Chasing, Climbing, Eating, Foraging, Tail flags, Tail twitches, Approaches, Indifferent, 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
36	36	-73.96624389966809	40.7890381809441	28A-PM-1007-05	28A	PM	10072018	5	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.9662438996681 40.7890381809441)
41	41	-73.96391592984459	40.789177463798794	29C-AM-1007-06	29C	AM	10072018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9639159298446 40.7891774637988)
130	130	-73.95816559494371	40.799770819002205	41A-PM-1007-06	41A	PM	10072018	6	Adult	Black		Black+		Ground Plane	FALSE		1	0	1	1	0		0	0	0	0	0	0	0	1		POINT (-73.9581655949437 40.7997708190022)
373	373	-73.96721272832829	40.7810666805133	20D-AM-1007-01	20D	AM	10072018	1	Adult	Gray		Gray+	too far to note 30'	Ground Plane	FALSE		1	0	1	1	0	a lot of activity	0	0	0	1	0	0	0	0		POINT (-73.9672127283283 40.7810666805133)
406	406	-73.97663549671971	40.7734575166319	8B-AM-1007-09	08B	AM	10072018	9	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	0	shelling and eating a nut then a dog chased it up a tree & squirrel carried its nut up the tree,settled in a branch & resumed eating	0	0	0	0	0	0	1	0		POINT (-73.9766354967197 40.7734575166319)
612	612	-73.9629420113622	40.789133072717	29C-AM-1007-03	29C	AM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9629420113622 40.789133072717)
674	674	-73.9779811967788	40.7675178797546	2D-AM-1007-01	02D	AM	10072018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9779811967788 40.7675178797546)
795	795	-73.9582523503306	40.7996897499473	41A-PM-1007-05	41A	PM	10072018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9582523503306 40.7996897499473)
892	892	-73.9611368390233	40.7815619053395	22I-AM-1007-02	22I	AM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9611368390233 40.7815619053395)
928	928	-73.96704295859901	40.778437071937105	17F-AM-1007-05	17F	AM	10072018	5	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	1	0		0	0	0	1	0	0	1	0		POINT (-73.967042958599 40.7784370719371)
936	936	-73.9684758245091	40.7858531619022	24A-PM-1007-02	24A	PM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9684758245091 40.7858531619022)
937	937	-73.97063234587691	40.7713196034265	9G-PM-1007-03	09G	PM	10072018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9706323458769 40.771319603426505)
946	946	-73.96540938440491	40.7806896368469	20F-PM-1007-09	20F	PM	10072018	9	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	1	0	0		POINT (-73.9654093844049 40.7806896368469)
950	950	-73.9637415893182	40.7898140363534	29B-AM-1007-01	29B	AM	10072018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9637415893182 40.7898140363534)
960	960	-73.9623922773932	40.7814944428327	22H-PM-1007-04	22H	PM	10072018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9623922773932 40.7814944428327)
1051	1051	-73.96137470327021	40.7920483852431	33C-PM-1007-01	33C	PM	10072018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9613747032702 40.792048385243106)
1192	1192	-73.9634811495245	40.790705585077	30B-AM-1007-10	30B	AM	10072018	10	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	1	0	1		0	0	0	0	0	0	0	1		POINT (-73.9634811495245 40.790705585077)
1272	1272	-73.9595717225279	40.7829872498299	25I-PM-1007-03	25I	PM	10072018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9595717225279 40.7829872498299)
1307	1307	-73.9565197137317	40.7986011403785	41C-PM-1007-01	41C	PM	10072018	1	Adult	Black		Black+		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9565197137317 40.7986011403785)
1325	1325	-73.97752788478971	40.7687881061059	3C-AM-1007-02	03C	AM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9775278847897 40.7687881061059)
1418	1418	-73.9673924060436	40.7788781851716	17F-AM-1007-03	17F	AM	10072018	3	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9673924060436 40.7788781851716)
1562	1562	-73.97408468107099	40.7728197139621	8D-AM-1007-06	08D	AM	10072018	6	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.974084681071 40.7728197139621)
1570	1570	-73.96628648847891	40.7891062338302	28A-PM-1007-02	28A	PM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0	running from #3	0	0	0	0	0	0	1	0		POINT (-73.9662864884789 40.7891062338302)
1590	1590	-73.9610388059192	40.793952935840004	34B-PM-1007-01	34B	PM	10072018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9610388059192 40.79395293584)
1612	1612	-73.97460490884751	40.772877688739705	8C-AM-1007-01	08C	AM	10072018	1	Adult	Gray		Gray+		Ground Plane	FALSE	behind fence, safe	1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9746049088475 40.7728776887397)
1750	1750	-73.9684806250183	40.7858776210151	24A-PM-1007-03	24A	PM	10072018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9684806250183 40.7858776210151)
1879	1879	-73.97019267362809	40.7778587687376	15D-AM-1007-02	15D	AM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9701926736281 40.7778587687376)
1910	1910	-73.9699876501742	40.774248267675794	12F-PM-1007-06	12F	PM	10072018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	1	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9699876501742 40.77424826767581)
1954	1954	-73.9794840520702	40.7709595369804	4A-PM-1007-02	04A	PM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9794840520702 40.770959536980406)
1968	1968	-73.9699088881236	40.775277835162605	13F-AM-1007-03	13F	AM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9699088881236 40.7752778351626)
1969	1969	-73.96890514730721	40.7764511282884	14F-AM-1007-04	14F	AM	10072018	4	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9689051473072 40.7764511282884)
2000	2000	-73.9591070579246	40.789677677115705	31F-PM-1007-05	31F	PM	10072018	5	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9591070579246 40.7896776771157)
2094	2094	-73.9701630539326	40.7779553961101	15D-AM-1007-04	15D	AM	10072018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.97016305393261 40.7779553961101)
2111	2111	-73.968446056806	40.785824818871	24A-PM-1007-01	24A	PM	10072018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.96844605680602 40.785824818871)
2166	2166	-73.9711178122133	40.7672642958437	4I-PM-1007-01	04I	PM	10072018	1	Adult	Black		Black+		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9711178122133 40.76726429584371)
2173	2173	-73.95461232594408	40.7941434862099	37G-PM-1007-05	37G	PM	10072018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0	jumping around!	0	0	0	0	0	0	0	0		POINT (-73.9546123259441 40.7941434862099)
2209	2209	-73.9697583235533	40.7787320391004	16D-AM-1007-05	16D	AM	10072018	5	Adult	Gray		Gray+	didn't get a good look	Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.96975832355331 40.7787320391004)
2210	2210	-73.9699124811406	40.7743016981538	12F-PM-1007-07	12F	PM	10072018	7	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	1	1	0	1		0	0	0	1	0	0	1	0		POINT (-73.9699124811406 40.7743016981538)
2217	2217	-73.9652746477521	40.7809326848536	20F-PM-1007-07	20F	PM	10072018	7	Adult	Gray	Cinnamon	Gray+Cinnamon	cinnamon tail	Ground Plane	FALSE		1	0	0	0	0	watching	0	0	0	1	0	0	0	1		POINT (-73.96527464775211 40.7809326848536)
2346	2346	-73.9562177305881	40.798341327633096	41C-PM-1007-03	41C	PM	10072018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9562177305881 40.7983413276331)
2365	2365	-73.96887733063241	40.7766669852358	15F-AM-1007-05	15F	AM	10072018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9688773306324 40.7766669852358)
2413	2413	-73.959701727877	40.790660026971004	32E-AM-1007-03	32E	AM	10072018	3	Adult	Black		Black+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.959701727877 40.790660026971)
2424	2424	-73.9684752839242	40.776581626151795	15F-AM-1007-01	15F	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO	Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	1	1		POINT (-73.9684752839242 40.7765816261518)
2469	2469	-73.9600963639087	40.7934962325313	34C-AM-1007-01	34C	AM	10072018	1	Adult	Black		Black+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	0	1	dog	POINT (-73.9600963639087 40.7934962325313)
2508	2508	-73.97938145045201	40.770903369788705	4A-PM-1007-01	04A	PM	10072018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	1	1	1		0	0	0	0	1	0	1	0		POINT (-73.979381450452 40.770903369788705)
2546	2546	-73.9660267365885	40.776444395505	16H-AM-1007-01	16H	AM	10072018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9660267365885 40.776444395505)
2564	2564	-73.970996228532	40.7715540712285	9G-PM-1007-02	09G	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.970996228532 40.7715540712285)
2637	2637	-73.968891673893	40.776700147172896	15F-AM-1007-06	15F	AM	10072018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	pair with #5	0	0	0	0	0	0	0	1		POINT (-73.968891673893 40.7767001471729)
2670	2670	-73.95310419064691	40.7919916819219	36I-PM-1007-02	36I	PM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	1	0	0	1		0	0	0	0	1	1	1	0	chased birds (blue jay)	POINT (-73.9531041906469 40.7919916819219)
2732	2732	-73.9694185786221	40.7787189999566	16D-AM-1007-06	16D	AM	10072018	6	Adult	Cinnamon	White	Cinnamon+White	primary color: brown ( I marked cinnamon as closest to brown - JO)	Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9694185786221 40.7787189999566)
2743	2743	-73.9587179613803	40.7992119571657	41A-PM-1007-01	41A	PM	10072018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9587179613803 40.7992119571657)
2829	2829	-73.95652309635541	40.798556387711	41C-PM-1007-02	41C	PM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9565230963554 40.798556387711)
2905	2905	-73.9784872728213	40.768812260393204	3C-AM-1007-01	03C	AM	10072018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9784872728213 40.7688122603932)
2998	2998	-73.97520792474191	40.775537697900205	11B-AM-1007-01	11B	AM	10072018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	1	0	0		POINT (-73.9752079247419 40.7755376979002)
3003	3003	-73.96986639266571	40.773999710413	12F-PM-1007-09	12F	PM	10072018	9	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9698663926657 40.773999710413)

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