2018_Central_Park_Squirrel_Census_-_Squirrel_Data

37 rows where Eating = 1, Hectare Squirrel Number = 4, Indifferent = 1 and Primary Fur Color = "Gray"

- 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: Shift, Date, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Foraging, Kuks, Tail twitches, 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
178	178	-73.9613780522542	40.790786197111004	31D-PM-1006-04	31D	PM	10062018	4	Adult	Gray		Gray+		Above Ground	30		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9613780522542 40.790786197111)
252	252	-73.974420668782	40.7749628597465	10C-PM-1013-04	10C	PM	10132018	4		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.974420668782 40.7749628597465)
275	275	-73.974467903723	40.7686520352868	4F-PM-1013-04	04F	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.974467903723 40.7686520352868)
293	293	-73.9696173677837	40.7705202790525	8H-AM-1017-04	08H	AM	10172018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9696173677837 40.7705202790525)
446	446	-73.9678774314725	40.7738535171265	12H-PM-1007-04	12H	PM	10072018	4		Gray	Cinnamon	Gray+Cinnamon					0	0	0	1	0	mushroom	0	0	0	0	0	0	1	0		POINT (-73.9678774314725 40.7738535171265)
585	585	-73.9700148248402	40.778778019335796	16D-PM-1010-04	16D	PM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9700148248402 40.7787780193358)
619	619	-73.9769887473852	40.7707561532949	5C-PM-1010-04	05C	PM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.97698874738522 40.7707561532949)
670	670	-73.9602398690946	40.7910157676119	32D-PM-1006-04	32D	PM	10062018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	40		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9602398690946 40.7910157676119)
842	842	-73.9645147011741	40.777256683379896	17I-AM-1014-04	17I	AM	10142018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	1	0		POINT (-73.9645147011741 40.7772566833799)
1023	1023	-73.97608800701859	40.7711057827923	6C-PM-1020-04	06C	PM	10202018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9760880070186 40.7711057827923)
1436	1436	-73.97667795856859	40.7669673778105	2E-AM-1010-04	02E	AM	10102018	4	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		1	0	0	0	0	0	1	0		POINT (-73.9766779585686 40.7669673778105)
1468	1468	-73.96405889194459	40.790044098464	29B-PM-1010-04	29B	PM	10102018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9640588919446 40.790044098464)
1690	1690	-73.96052295327	40.7934359372871	34C-PM-1012-04	34C	PM	10122018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.96052295327 40.7934359372871)
1709	1709	-73.9771696835698	40.76970111004871	4C-AM-1006-04	04C	AM	10062018	4	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9771696835698 40.7697011100487)
1742	1742	-73.97010234787459	40.7803527061859	17C-PM-1013-04	17C	PM	10132018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9701023478746 40.7803527061859)
1802	1802	-73.9736418085696	40.7716931127716	8E-PM-1008-04	08E	PM	10082018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE	in grass by a grove of tall maples	0	0	0	1	1		0	0	0	0	0	0	1	0	there's a family playing soccer	POINT (-73.9736418085696 40.7716931127716)
1881	1881	-73.9674984567017	40.7745938268705	13H-PM-1010-04	13H	PM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9674984567017 40.7745938268705)
2050	2050	-73.9555255950648	40.7977720808005	40D-AM-1013-04	40D	AM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9555255950648 40.7977720808005)
2062	2062	-73.9618173092433	40.7925800181543	33B-PM-1010-04	33B	PM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9618173092433 40.7925800181543)
2128	2128	-73.9757673193743	40.7669614322613	2F-PM-1014-04	02F	PM	10142018	4	Adult	Gray		Gray+		Above Ground	20		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9757673193743 40.766961432261304)
2219	2219	-73.9709242364673	40.7684217215595	5I-AM-1010-04	05I	AM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9709242364673 40.7684217215595)
2265	2265	-73.97052601032391	40.782633368659894	19A-PM-1013-04	19A	PM	10132018	4	Adult	Gray	Black, White	Gray+Black, White	Also looks quite brown - minimal body highlight coloring - black edges	Above Ground	2		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9705260103239 40.78263336865991)
2277	2277	-73.95385121459	40.7981257651433	42E-PM-1012-04	42E	PM	10122018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.95385121459 40.7981257651433)
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	0	0	1	0		POINT (-73.9728654439465 40.7724853142211)
2383	2383	-73.9686551213305	40.772861783717396	11H-PM-1013-04	11H	PM	10132018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	1	1	0		POINT (-73.9686551213305 40.7728617837174)
2442	2442	-73.9699369796844	40.772035019127294	10G-PM-1017-04	10G	PM	10172018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9699369796844 40.7720350191273)
2533	2533	-73.9766195697096	40.766190726154704	1F-AM-1010-04	01F	AM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9766195697096 40.7661907261547)
2607	2607	-73.9642988690682	40.779559128197896	19H-AM-1010-04	19H	AM	10102018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	0	0	1	1	runs from human w/ dog	POINT (-73.9642988690682 40.7795591281979)
2613	2613	-73.96393252683	40.7808289765857	21G-AM-1014-04	21G	AM	10142018	4	Adult	Gray	White	Gray+White		Above Ground	6		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.96393252683 40.7808289765857)
2614	2614	-73.9765877920583	40.7660946071574	1F-AM-1010-04	01F	AM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9765877920583 40.7660946071574)
2641	2641	-73.96155167034941	40.790521938835894	31D-AM-1014-04	31D	AM	10142018	4	Juvenile	Gray		Gray+		Ground Plane	FALSE	Open ground	1	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9615516703494 40.7905219388359)
2776	2776	-73.9789687905912	40.769269313932796	3B-PM-1007-04	03B	PM	10072018	4	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	4	At fence	1	0	1	1	0		0	0	0	0	1	0	1	1		POINT (-73.9789687905912 40.7692693139328)
2781	2781	-73.9752673884392	40.7662642413761	2G-AM-1010-04	02G	AM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9752673884392 40.7662642413761)
2863	2863	-73.9698246369929	40.7711472794488	9H-AM-1006-04	09H	AM	10062018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9698246369929 40.7711472794488)
2981	2981	-73.9800094828465	40.7677782585639	1B-AM-1012-04	01B	AM	10122018	4		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9800094828465 40.7677782585639)
2993	2993	-73.95707222626929	40.798570614351895	40C-AM-1017-04	40C	AM	10172018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	1	1	chasing (#3)	0	0	0	0	0	0	1	0		POINT (-73.9570722262693 40.7985706143519)
3014	3014	-73.9665572004288	40.780434754830296	19E-PM-1018-04	19E	PM	10182018	4		Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9665572004288 40.7804347548303)

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