2018_Central_Park_Squirrel_Census_-_Squirrel_Data

58 rows where Foraging = 0, Hectare Squirrel Number = 4, Indifferent = 0 and Runs from = 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

- 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, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Kuks, Quaas, Tail flags, Tail twitches, Approaches

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
100	100	-73.9761592532482	40.774721358538706	10A-AM-1006-04	10A	AM	10062018	4	Juvenile	Gray		Gray+		Above Ground	10	tree near large rock on Bridle Path	0	0	0	0	0	walking on branch	0	0	0	0	1	0	0	0		POINT (-73.9761592532482 40.7747213585387)
173	173	-73.95877018015099	40.793412394152796	35D-PM-1013-04	35D	PM	10132018	4	Juvenile	Gray	White	Gray+White					0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.958770180151 40.7934123941528)
218	218	-73.9712318712643	40.7773053099657	14D-PM-1019-04	14D	PM	10192018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9712318712643 40.7773053099657)
229	229	-73.97241624297101	40.7714260236636	8F-PM-1012-04	08F	PM	10122018	4	Adult	Gray		Gray+		Above Ground	6		0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.972416242971 40.7714260236636)
315	315	-73.95397347709341	40.7956055442	39G-PM-1013-04	39G	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9539734770934 40.7956055442)
354	354	-73.95667510223359	40.799035789744	41C-PM-1007-04	41C	PM	10072018	4	Adult	Gray	White	Gray+White		Above Ground	65		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9566751022336 40.799035789744)
455	455	-73.9688574691102	40.7837825208444	21B-AM-1019-04	21B	AM	10192018	4				+					0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9688574691102 40.7837825208444)
631	631	-73.95488778301359	40.795015748910295	38F-AM-1018-04	38F	AM	10182018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.95488778301362 40.7950157489103)
635	635	-73.96732355553209	40.7786749596774	17F-PM-1020-04	17F	PM	10202018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground			0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9673235555321 40.7786749596774)
654	654	-73.976769659152	40.7741908010484	9A-AM-1013-04	09A	AM	10132018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.976769659152 40.7741908010484)
709	709	-73.9519387881692	40.7936273636929	38I-PM-1014-04	38I	PM	10142018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9519387881692 40.7936273636929)
849	849	-73.9736165917399	40.772454390149704	8D-AM-1007-04	08D	AM	10072018	4	Adult	Gray		Gray+		Above Ground	3		0	1	0	0	0	chasing squirrel #3	0	0	0	0	0	0	0	0		POINT (-73.9736165917399 40.7724543901497)
861	861	-73.953287300494	40.793520326789	37H-PM-1006-04	37H	PM	10062018	4				+		Above Ground	43	tree	0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.953287300494 40.793520326789)
920	920	-73.9571233640232	40.7992458980266	41B-PM-1014-04	41B	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	40		0	0	1	0	0		0	0	0	0	0	0	0	0	climbing	POINT (-73.9571233640232 40.7992458980266)
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)
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	0	0	curious	POINT (-73.9645547556826 40.776877007081)
1008	1008	-73.9553038162633	40.7909367783223	34H-PM-1006-04	34H	PM	10062018	4		Gray	Cinnamon	Gray+Cinnamon		Above Ground		Elm tree	0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9553038162633 40.790936778322305)
1022	1022	-73.95488534927121	40.7984783584388	41D-PM-1014-04	41D	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	30		0	0	1	0	0	jumping tree to tree	0	0	0	0	0	0	0	0		POINT (-73.9548853492712 40.7984783584388)
1076	1076	-73.96279043284021	40.7939375305761	34A-PM-1013-04	34A	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	digging & burying	0	0	0	0	0	0	0	0		POINT (-73.9627904328402 40.7939375305761)
1087	1087	-73.9679955831115	40.7818431607916	20C-PM-1018-04	20C	PM	10182018	4	Adult	Gray		Gray+		Above Ground	8		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9679955831115 40.7818431607916)
1110	1110	-73.96764342569759	40.78623366244479	24A-PM-1007-04	24A	PM	10072018	4	Adult	Gray		Gray+		Above Ground	50	in tree	0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9676434256976 40.7862336624448)
1280	1280	-73.9562469727195	40.79685907654	39D-AM-1008-04	39D	AM	10082018	4	Adult	Gray		Gray+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9562469727195 40.79685907654)
1296	1296	-73.97055091705421	40.7689416540228	6I-PM-1013-04	06I	PM	10132018	4	Adult	Black	Gray	Black+Gray		Ground Plane	FALSE	Grass	0	0	0	1	0		0	0	0	0	1	0	0	0		POINT (-73.9705509170542 40.7689416540228)
1302	1302	-73.9704024529864	40.772925606388895	10G-AM-1006-04	10G	AM	10062018	4	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0	chasing (#3)	1	0	0	0	0	0	0	0		POINT (-73.9704024529864 40.7729256063889)
1313	1313	-73.9671813866177	40.783864003203796	22C-PM-1006-04	22C	PM	10062018	4	Juvenile	Gray		Gray+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9671813866177 40.7838640032038)
1342	1342	-73.96620636423451	40.789077866530704	28A-PM-1007-04	28A	PM	10072018	4	Adult	Gray	White	Gray+White					0	0	0	0	0	looking at me & #5	1	0	0	0	1	0	0	0	freezes	POINT (-73.9662063642345 40.7890778665307)
1365	1365	-73.9791648157033	40.767625444347	2C-AM-1010-04	02C	AM	10102018	4	Adult	Gray		Gray+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9791648157033 40.767625444347)
1411	1411	-73.98028400317591	40.7678599069819	1B-PM-1019-04	01B	PM	10192018	4	Juvenile	Gray	White	Gray+White		Above Ground	25	in tree	0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9802840031759 40.7678599069819)
1475	1475	-73.96867781674841	40.7765625256946	14F-PM-1012-04	14F	PM	10122018	4				+					0	0	0	0	0		1	1	0	0	0	0	0	0		POINT (-73.96867781674841 40.7765625256946)
1506	1506	-73.9728339757306	40.7782891207966	14B-PM-1014-04	14B	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20	running up and down	0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9728339757306 40.7782891207966)
1508	1508	-73.96938943057859	40.775690674802604	13F-PM-1008-04	13F	PM	10082018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	0	0	0		1	0	0	0	0	0	0	0		POINT (-73.9693894305786 40.7756906748026)
1518	1518	-73.9632265832593	40.7816914475461	22G-AM-1018-04	22G	AM	10182018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	3		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9632265832593 40.78169144754611)
1533	1533	-73.95200246546021	40.794732982815496	39I-PM-1013-04	39I	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Gray & Cinnamon selected as both Primary and Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	1	0	playing	0	0	0	0	0	1	0	0		POINT (-73.95200246546021 40.7947329828155)
1563	1563	-73.96762706709958	40.776391443152	15G-AM-1008-04	15G	AM	10082018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		1	0	0	0	0	0	0	0		POINT (-73.9676270670996 40.776391443152)
1573	1573	-73.9595613548804	40.7838057527338	25I-PM-1007-04	25I	PM	10072018	4	Adult	Gray		Gray+		Above Ground	25		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9595613548804 40.7838057527338)
1636	1636	-73.97014086231209	40.7695511718541	7I-PM-1013-04	07I	PM	10132018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	Grass	1	0	0	1	0		0	0	0	1	0	0	0	0		POINT (-73.9701408623121 40.7695511718541)
1675	1675	-73.97774976458341	40.767734470917794	2D-AM-1007-04	02D	AM	10072018	4	Adult	Gray		Gray+		Above Ground	100		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9777497645834 40.7677344709178)
1790	1790	-73.97305925481159	40.7740879251541	10D-AM-1008-04	10D	AM	10082018	4	Juvenile	Gray		Gray+		Above Ground	25		0	1	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9730592548116 40.7740879251541)
1823	1823	-73.9612854506075	40.792083067357105	32C-PM-1013-04	32C	PM	10132018	4	Juvenile	Gray		Gray+		Above Ground			1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9612854506075 40.7920830673571)
1826	1826	-73.9707542189896	40.7717032986885	9G-PM-1007-04	09G	PM	10072018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9707542189896 40.77170329868851)
1882	1882	-73.9541601469123	40.7907832744689	34I-PM-1010-04	34I	PM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE	across the lawn and climb up a small tree	1	0	1	0	0	grooming	0	0	0	0	0	0	0	0		POINT (-73.9541601469123 40.79078327446891)
2103	2103	-73.9782983634755	40.766831436426294	1D-AM-1006-04	01D	AM	10062018	4	Adult	Gray	White	Gray+White		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9782983634755 40.7668314364263)
2113	2113	-73.95829048146521	40.790591574956395	32F-AM-1012-04	32F	AM	10122018	4	Adult	Black		Black+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9582904814652 40.7905915749564)
2341	2341	-73.9665363265054	40.7844967881001	23C-PM-1014-04	23C	PM	10142018	4	Adult	Gray		Gray+		Above Ground	8		0	0	0	0	0	being chased by #3 across trees	0	0	0	0	0	0	0	0		POINT (-73.9665363265054 40.7844967881001)
2349	2349	-73.98003374000399	40.768360829233295	2B-PM-1013-04	02B	PM	10132018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.980033740004 40.7683608292333)
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	0	0		POINT (-73.9756273257684 40.7706539186221)
2475	2475	-73.9736489041867	40.7712143385426	7E-AM-1006-04	07E	AM	10062018	4	Adult	Gray		Gray+		Ground Plane	FALSE	under a tree	0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9736489041867 40.7712143385426)
2514	2514	-73.95744422055	40.7961046528557	38D-AM-1017-04	38D	AM	10172018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.95744422055 40.7961046528557)
2575	2575	-73.97357533521291	40.7687061447032	5G-PM-1010-04	05G	PM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	1	0	0		POINT (-73.9735753352129 40.7687061447032)
2740	2740	-73.96126586889142	40.7912119940469	32C-AM-1014-04	32C	AM	10142018	4	Adult	Gray		Gray+		Above Ground	8		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9612658688914 40.7912119940469)
2744	2744	-73.9752915601718	40.7739329570033	9B-AM-1010-04	09B	AM	10102018	4				+		Above Ground	10		1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9752915601718 40.7739329570033)
2754	2754	-73.9687025912431	40.7719319822619	10H-AM-1014-04	10H	AM	10142018	4	Juvenile			+		Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9687025912431 40.7719319822619)
2756	2756	-73.9787312025627	40.7701071405918	4B-PM-1018-04	04B	PM	10182018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9787312025627 40.7701071405918)
2839	2839	-73.9672252136807	40.787650474321204	26A-PM-1006-04	26A	PM	10062018	4	Adult	Gray		Gray+		Above Ground	40		0	1	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.9672252136807 40.7876504743212)
2869	2869	-73.9630822385425	40.7914844989865	31B-PM-1007-04	31B	PM	10072018	4	Juvenile	Gray		Gray+					0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9630822385425 40.7914844989865)
2878	2878	-73.969720780557	40.774110568875706	12F-AM-1020-04	12F	AM	10202018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	1	0	0	0		POINT (-73.969720780557 40.7741105688757)
2895	2895	-73.9747873899653	40.77319452583271	9C-PM-1006-04	09C	PM	10062018	4	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9747873899653 40.7731945258327)
2951	2951	-73.9742986032935	40.7770454318226	13A-PM-1014-04	13A	PM	10142018	4		Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9742986032935 40.7770454318226)

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