2018_Central_Park_Squirrel_Census_-_Squirrel_Data

54 rows where Age = "Adult", Foraging = 0, Hectare Squirrel Number = 6 and Shift = "PM"

- 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

- 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: Date, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, 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
31	31	-73.9540054100539	40.795244599983604	39G-PM-1013-06	39G	PM	10132018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9540054100539 40.7952445999836)
47	47	-73.9640032826529	40.782030982544796	22F-PM-1014-06	22F	PM	10142018	6	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9640032826529 40.7820309825448)
58	58	-73.9704082821356	40.7690280985956	6I-PM-1013-06	06I	PM	10132018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	playing with #5	0	0	0	0	1	0	0	0		POINT (-73.9704082821356 40.7690280985956)
81	81	-73.9578237168359	40.7980959471034	40B-PM-1014-06	40B	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9578237168359 40.7980959471034)
83	83	-73.9617088749928	40.7944585082367	35A-PM-1013-06	35A	PM	10132018	6	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9617088749928 40.7944585082367)
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)
133	133	-73.9664711607022	40.787896428768	26A-PM-1006-06	26A	PM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Tree 90th left 90th & 89	0	0	1	0	0		0	0	0	1	0	0	0	0	studying us looking for food	POINT (-73.9664711607022 40.787896428768)
171	171	-73.971086588091	40.77197032351779	9G-PM-1007-06	09G	PM	10072018	6	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.971086588091 40.7719703235178)
378	378	-73.95848354168459	40.7978213396921	39B-PM-1014-06	39B	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9584835416846 40.7978213396921)
458	458	-73.97357503529591	40.7694500333777	6F-PM-1008-06	06F	PM	10082018	6	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	White patches. Almost looks like fox squirrel				0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9735750352959 40.7694500333777)
494	494	-73.958837574505	40.7985003987784	40A-PM-1014-06	40A	PM	10142018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.958837574505 40.7985003987784)
522	522	-73.97738211356109	40.769045349438294	4C-PM-1010-06	04C	PM	10102018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	behind playground benches	0	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9773821135611 40.7690453494383)
620	620	-73.9655905300923	40.775261463802295	14I-PM-1018-06	14I	PM	10182018	6	Adult	Cinnamon	Black	Cinnamon+Black		Above Ground	2		1	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9655905300923 40.7752614638023)
682	682	-73.9651828383592	40.780282094386294	19F-PM-1017-06	19F	PM	10172018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	1	1	0	0		0	0	0	0	1	1	0	0		POINT (-73.9651828383592 40.7802820943863)
726	726	-73.973305698325	40.778382331129606	14A-PM-1014-06	14A	PM	10142018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	9		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.973305698325 40.7783823311296)
737	737	-73.97111769994709	40.7724278547281	10F-PM-1019-06	10F	PM	10192018	6	Adult	Gray	White	Gray+White		Above Ground	10	Different tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9711176999471 40.7724278547281)
799	799	-73.9529413156461	40.7920963446605	36I-PM-1007-06	36I	PM	10072018	6	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9529413156461 40.7920963446605)
866	866	-73.9792091200122	40.7685845475313	2B-PM-1013-06	02B	PM	10132018	6	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	1	0	0	sat there! in front of us	POINT (-73.9792091200122 40.7685845475313)
1049	1049	-73.9564606426367	40.788054657260794	30I-PM-1006-06	30I	PM	10062018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	1	ran up tree	POINT (-73.9564606426367 40.7880546572608)
1074	1074	-73.9724657562746	40.7658015504376	3I-PM-1013-06	03I	PM	10132018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9724657562746 40.7658015504376)
1082	1082	-73.96174906802979	40.792153784924395	32C-PM-1013-06	32C	PM	10132018	6	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9617490680298 40.7921537849244)
1133	1133	-73.9712550584322	40.7764273475386	13D-PM-1018-06	13D	PM	10182018	6	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0	cleaning	0	0	0	0	0	0	1	0		POINT (-73.9712550584322 40.7764273475386)
1219	1219	-73.96618922004741	40.7836798072777	22D-PM-1012-06	22D	PM	10122018	6	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9661892200474 40.7836798072777)
1247	1247	-73.96709048698709	40.7832091658006	21D-PM-1008-06	21D	PM	10082018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9670904869871 40.7832091658006)
1273	1273	-73.95589438800509	40.7971535141896	40D-PM-1013-06	40D	PM	10132018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9558943880051 40.7971535141896)
1464	1464	-73.95320745731391	40.793466946490796	37H-PM-1006-06	37H	PM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	40	tree	1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9532074573139 40.7934669464908)
1530	1530	-73.96893059787509	40.781815249626604	19C-PM-1018-06	19C	PM	10182018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2	Climbed fence	1	0	1	0	0	climbing (fence)	0	0	0	0	0	0	1	0		POINT (-73.9689305978751 40.7818152496266)
1535	1535	-73.9703921271418	40.770027611531404	7H-PM-1006-06	07H	PM	10062018	6	Adult	Gray		Gray+		Above Ground	15		0	1	1	0	0	playing w/ #7	0	0	0	0	0	0	1	0		POINT (-73.9703921271418 40.770027611531404)
1599	1599	-73.9782603348665	40.7705790257951	5B-PM-1013-06	05B	PM	10132018	6	Adult	Gray		Gray+		Above Ground	5		1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9782603348665 40.7705790257951)
1629	1629	-73.9759428006237	40.7715081817329	7C-PM-1020-06	07C	PM	10202018	6	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	1	0	0	0	0	0	0		POINT (-73.9759428006237 40.7715081817329)
1644	1644	-73.9734654671008	40.7715988711659	8E-PM-1008-06	08E	PM	10082018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE	5, 6, 7 all at same tree trunk base	0	1	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9734654671008 40.7715988711659)
1679	1679	-73.9545399102352	40.7898646267709	33I-PM-1006-06	33I	PM	10062018	6	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9545399102352 40.7898646267709)
1805	1805	-73.9590328527128	40.791221441757706	33E-PM-1012-06	33E	PM	10122018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0	playing	0	0	0	0	0	0	0	0		POINT (-73.9590328527128 40.7912214417577)
1815	1815	-73.96032682553171	40.7900154505092	31E-PM-1006-06	31E	PM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9603268255317 40.7900154505092)
1871	1871	-73.9748367344424	40.7693513000034	5E-PM-1012-06	05E	PM	10122018	6	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	10	oak tree at end of ramp from Chess House	1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9748367344424 40.7693513000034)
1948	1948	-73.9738410069766	40.7691686156505	5F-PM-1007-06	05F	PM	10072018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	jumping on fence	0	0	0	0	1	0	1	0		POINT (-73.9738410069766 40.7691686156505)
2010	2010	-73.9673821557469	40.7786375267659	17F-PM-1020-06	17F	PM	10202018	6	Adult	Gray		Gray+		Above Ground	20		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.96738215574692 40.7786375267659)
2052	2052	-73.97464934414141	40.7750478734868	11B-PM-1014-06	11B	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		0	0	0	0	0	cleaning	0	0	0	0	0	0	1	0		POINT (-73.9746493441414 40.7750478734868)
2203	2203	-73.97105314852979	40.7773757069445	14D-PM-1019-06	14D	PM	10192018	6	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0	0	1	0		POINT (-73.97105314852982 40.777375706944504)
2274	2274	-73.96980442184758	40.7697007833531	7I-PM-1013-06	07I	PM	10132018	6	Adult	Cinnamon		Cinnamon+	"Brown" written in as Primary	Ground Plane	FALSE	Under the tree	0	0	0	1	0	playing,interacting with #7	0	0	0	0	1	0	0	1		POINT (-73.9698044218476 40.7697007833531)
2323	2323	-73.9715921982161	40.7746153066601	11E-PM-1012-06	11E	PM	10122018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Above Ground	5		0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9715921982161 40.7746153066601)
2410	2410	-73.97551920769341	40.7664413570796	2F-PM-1014-06	02F	PM	10142018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9755192076934 40.7664413570796)
2519	2519	-73.9589475065438	40.7934846881536	35D-PM-1013-06	35D	PM	10132018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9589475065438 40.7934846881536)
2562	2562	-73.9615643742864	40.7944678447843	35B-PM-1013-06	35B	PM	10132018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	1	0	0	chased by dog #2	1	0	0	0	0	0	0	1	runs from (dog)	POINT (-73.9615643742864 40.7944678447843)
2617	2617	-73.9564228238736	40.7936908887644	36F-PM-1012-06	36F	PM	10122018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9564228238736 40.7936908887644)
2676	2676	-73.9692849074642	40.7708755098145	9H-PM-1018-06	09H	PM	10182018	6	Adult	Gray		Gray+		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9692849074642 40.7708755098145)
2697	2697	-73.9710674928906	40.7778757544025	15D-PM-1017-06	15D	PM	10172018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	walking	0	0	0	0	0	0	0	0	stopped and watched me before slowly moving on	POINT (-73.9710674928906 40.7778757544025)
2720	2720	-73.9566300789162	40.7993692120774	42C-PM-1013-06	42C	PM	10132018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Between park and main drag	0	0	1	1	0		0	0	0	0	0	0	1	1		POINT (-73.9566300789162 40.7993692120774)
2795	2795	-73.9541056052047	40.793986392323106	37G-PM-1007-06	37G	PM	10072018	6	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9541056052047 40.7939863923231)
2814	2814	-73.9551625272308	40.791193071916	34H-PM-1006-06	34H	PM	10062018	6	Adult	Gray		Gray+		Ground Plane	FALSE	in grass	1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9551625272308 40.791193071916)
2815	2815	-73.97473113123941	40.76773197250439	3F-PM-1013-06	03F	PM	10132018	6	Adult	Gray	White	Gray+White		Above Ground	19		0	0	1	0	0		0	1	0	0	0	0	0	1		POINT (-73.97473113123941 40.7677319725044)
2855	2855	-73.9690832219322	40.782343340985996	20B-PM-1013-06	20B	PM	10132018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.96908322193221 40.782343340986)
2980	2980	-73.97164145863809	40.771760114722	9F-PM-1014-06	09F	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	0	running (from birds)	0	0	0	1	0	0	1	0		POINT (-73.9716414586381 40.771760114722)
3011	3011	-73.96788313129359	40.7847605974975	23B-PM-1012-06	23B	PM	10122018	6	Adult	Gray		Gray+		Above Ground	30		0	0	0	0	0		1	0	0	0	0	0	0	0	scolding	POINT (-73.9678831312936 40.7847605974975)

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