2018_Central_Park_Squirrel_Census_-_Squirrel_Data

40 rows where Eating = 0, Highlight Fur Color = "Cinnamon, White", Indifferent = 0, Running = 0 and Tail twitches = 0

- 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

- 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: Hectare, Shift, Date, Hectare Squirrel Number, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Foraging, Kuks, Tail flags, Approaches, 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
60	60	-73.9768674812942	40.7735232648872	8B-PM-1012-02	08B	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	hiding in bushes	0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9768674812942 40.7735232648872)
116	116	-73.9572093760529	40.798848730021604	41B-AM-1010-06	41B	AM	10102018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	6		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9572093760529 40.7988487300216)
119	119	-73.9592038887673	40.796382675378	38B-PM-1018-02	38B	PM	10182018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1	burying nut	0	0	0	0	0	0	0	0		POINT (-73.9592038887673 40.796382675378)
131	131	-73.9755560786227	40.7662992317575	2F-AM-1006-05	02F	AM	10062018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0	curious but shy	POINT (-73.9755560786227 40.7662992317575)
162	162	-73.957219204335	40.7931529059779	35E-PM-1006-01	35E	PM	10062018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0	looking/begging for food	POINT (-73.957219204335 40.7931529059779)
230	230	-73.97314980648721	40.7659963196581	2H-AM-1006-02	02H	AM	10062018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	1	0	0		0	0	0	0	0	1	0	0		POINT (-73.9731498064872 40.7659963196581)
236	236	-73.9737266070919	40.7786338379896	14A-PM-1014-01	14A	PM	10142018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9737266070919 40.7786338379896)
260	260	-73.97843611793199	40.7724769242403	6A-AM-1006-06	06A	AM	10062018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	15	tree	0	0	1	0	0		1	0	0	0	0	0	0	0		POINT (-73.978436117932 40.7724769242403)
270	270	-73.9767191629692	40.7730786298701	8B-PM-1012-03	08B	PM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9767191629692 40.7730786298701)
340	340	-73.97449608298442	40.7652585501959	1H-AM-1012-01	01H	AM	10122018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	1	first approaches then runs from - he was less than 1 yd. away from me.	POINT (-73.9744960829844 40.7652585501959)
362	362	-73.9571407991577	40.793191739640605	35E-PM-1006-02	35E	PM	10062018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0	begging for food	POINT (-73.9571407991577 40.7931917396406)
394	394	-73.9719888241794	40.7667681685356	4I-PM-1007-03	04I	PM	10072018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	3	ran to tree	0	0	0	0	0	being chased	0	0	0	0	0	0	0	0		POINT (-73.9719888241794 40.7667681685356)
523	523	-73.9793103340869	40.767820153596794	1C-PM-1013-06	01C	PM	10132018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9793103340869 40.76782015359681)
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)
782	782	-73.9710559113762	40.779427991420896	16C-PM-1018-01	16C	PM	10182018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	3		0	0	1	0	0		0	0	0	0	0	0	0	0	disappeared up other side of tree	POINT (-73.9710559113762 40.7794279914209)
870	870	-73.97187204036571	40.770233505633705	7G-PM-1018-04	07G	PM	10182018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9718720403657 40.7702335056337)
1036	1036	-73.9709207551033	40.7767932008037	14D-AM-1014-04	14D	AM	10142018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9709207551033 40.7767932008037)
1201	1201	-73.97828135384209	40.7715730368712	6A-AM-1006-02	06A	AM	10062018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	30	tree	0	1	1	0	0		0	0	0	1	0	0	0	0		POINT (-73.9782813538421 40.7715730368712)
1220	1220	-73.97799837948492	40.767545209917294	2D-AM-1007-02	02D	AM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	6	up tree	0	1	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9779983794849 40.7675452099173)
1432	1432	-73.9632577850183	40.793112839016	33A-AM-1008-01	33A	AM	10082018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0	acknowledged	POINT (-73.9632577850183 40.793112839016)
1584	1584	-73.9581310602492	40.7960214726964	38C-PM-1014-05	38C	PM	10142018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	0	0	chasing (#4)	0	0	0	0	0	0	0	1		POINT (-73.9581310602492 40.7960214726964)
1592	1592	-73.9575517912392	40.788915826819206	31H-PM-1008-05	31H	PM	10082018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground			0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9575517912392 40.7889158268192)
1655	1655	-73.96957001271599	40.7816501516863	19B-PM-1018-04	19B	PM	10182018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.969570012716 40.7816501516863)
1721	1721	-73.95873307074629	40.7907682009641	32F-AM-1012-02	32F	AM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray patches on back legs	Ground Plane	FALSE		0	0	0	0	0	curious about me	0	0	0	0	0	1	0	1		POINT (-73.9587330707463 40.7907682009641)
1788	1788	-73.9685567075413	40.7703797723105	8I-AM-1006-10	08I	AM	10062018	10	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	3	bush	0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.96855670754131 40.7703797723105)
1953	1953	-73.9644974196807	40.7810020292593	20G-PM-1013-02	20G	PM	10132018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.96449741968071 40.7810020292593)
2019	2019	-73.9566705412766	40.7935560645735	36F-PM-1012-01	36F	PM	10122018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	Near rock	0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9566705412766 40.7935560645735)
2067	2067	-73.97250779335741	40.7654562710325	2I-PM-1006-01	02I	PM	10062018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	2	Sitting on back of bench with food hanging from mouth	0	0	0	0	0	staring at me	0	0	0	0	0	0	0	1		POINT (-73.9725077933574 40.7654562710325)
2068	2068	-73.9735587560787	40.7672346255151	3G-PM-1013-02	03G	PM	10132018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	0	wandering,interacting with tourists	0	0	0	0	0	1	0	0	approaches (father - son taking photos,talking about giving him planters peanuts)	POINT (-73.9735587560787 40.7672346255151)
2082	2082	-73.9696802053043	40.781605740612505	19B-PM-1018-03	19B	PM	10182018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9696802053043 40.7816057406125)
2251	2251	-73.9587678566254	40.7962656030995	38C-PM-1014-01	38C	PM	10142018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	20		0	0	1	0	0		1	0	0	0	0	0	0	0		POINT (-73.9587678566254 40.7962656030995)
2285	2285	-73.9576325087936	40.7988448745116	41B-AM-1010-04	41B	AM	10102018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9576325087936 40.7988448745116)
2332	2332	-73.9709797467807	40.776909571067904	14D-AM-1014-07	14D	AM	10142018	7	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9709797467807 40.7769095710679)
2333	2333	-73.9771924901559	40.766672272947105	1E-PM-1007-01	01E	PM	10072018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0	people feeding squirrel	POINT (-73.9771924901559 40.7666722729471)
2556	2556	-73.96398284313679	40.7910151996207	30B-PM-1019-09	30B	PM	10192018	9	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9639828431368 40.7910151996207)
2733	2733	-73.9690082314914	40.7738993942891	12G-AM-1012-05	12G	AM	10122018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	0	0		1	0	0	0	0	0	0	1		POINT (-73.9690082314914 40.7738993942891)
2856	2856	-73.9751615527833	40.767013871509	3F-AM-1006-03	03F	AM	10062018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE	on the path	0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9751615527833 40.767013871509)
2901	2901	-73.9735833104203	40.7786318041581	14A-PM-1014-08	14A	PM	10142018	8	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1	new movement flailing arms while foraging	0	0	0	0	0	0	0	1		POINT (-73.9735833104203 40.7786318041581)
2922	2922	-73.97034213914421	40.7773706575356	14D-AM-1014-01	14D	AM	10142018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9703421391442 40.7773706575356)
2977	2977	-73.95806816485471	40.799201001265295	41B-AM-1010-01	41B	AM	10102018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9580681648547 40.7992010012653)

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