2018_Central_Park_Squirrel_Census_-_Squirrel_Data

22 rows where Shift = "AM" and Specific Location = "tree"

- 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, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, Tail twitches, 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
98	98	-73.9730277911422	40.771214548882796	7F-AM-1008-16	07F	AM	10082018	16	Juvenile	Gray		Gray+		Above Ground	2	tree	0	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9730277911422 40.7712145488828)
112	112	-73.96517544644391	40.7755181941559	15I-AM-1008-01	15I	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	7	tree	0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9651754464439 40.7755181941559)
189	189	-73.9735489537928	40.76812579115229	4G-AM-1006-02	04G	AM	10062018	2		Gray	White	Gray+White		Above Ground	12	tree	0	0	0	0	0	sitting in tree	0	0	0	0	0	0	1	0		POINT (-73.9735489537928 40.7681257911523)
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)
335	335	-73.97823514358521	40.7715896672335	6A-AM-1006-03	06A	AM	10062018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	30	tree	0	1	0	1	0		0	0	0	1	1	0	0	0		POINT (-73.9782351435852 40.7715896672335)
433	433	-73.9558474701153	40.7913335515534	34H-AM-1007-01	34H	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	40	tree	0	0	0	0	0		1	1	0	0	0	0	0	0		POINT (-73.9558474701153 40.7913335515534)
440	440	-73.9642717435966	40.782087049693	22F-AM-1007-05	22F	AM	10072018	5	Adult	Gray	White	Gray+White		Above Ground	10	tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9642717435966 40.782087049693)
476	476	-73.9690968160819	40.769923269444	8I-AM-1006-08	08I	AM	10062018	8	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	6	tree	0	0	0	0	0		1	1	0	0	0	0	0	0	not backing down	POINT (-73.9690968160819 40.769923269444)
496	496	-73.9548430741605	40.798207350942	41E-AM-1007-06	41E	AM	10072018	6	Adult	Gray		Gray+		Above Ground	30	tree	0	0	1	0	1		0	0	0	0	0	0	0	0		POINT (-73.9548430741605 40.798207350942)
700	700	-73.9691261755936	40.7702929428604	8I-AM-1006-12	08I	AM	10062018	12	Adult	Gray		Gray+		Above Ground	50	tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9691261755936 40.7702929428604)
1016	1016	-73.9691293546408	40.7703219076549	8I-AM-1006-11	08I	AM	10062018	11	Adult	Gray		Gray+		Above Ground	50	tree	0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9691293546408 40.77032190765491)
1048	1048	-73.9782120139407	40.7717154468791	6A-AM-1006-05	06A	AM	10062018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	4	tree	0	0	1	0	0		0	0	0	1	1	0	0	0	curious	POINT (-73.9782120139407 40.7717154468791)
1079	1079	-73.9722737593623	40.768963018754	6G-AM-1008-04	06G	AM	10082018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon	very long tail	Above Ground	20	tree	1	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9722737593623 40.768963018754)
1118	1118	-73.9719460335398	40.7810508156287	18A-AM-1012-01	18A	AM	10122018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	White tail	Above Ground	3	tree	1	0	1	0	1		0	0	0	0	1	0	0	1		POINT (-73.9719460335398 40.7810508156287)
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)
1329	1329	-73.9772164524209	40.768839953875606	3D-AM-1006-06	03D	AM	10062018	6		Gray		Gray+		Above Ground	10	tree	1	0	1	0	0		0	0	0	0	0	0	0	0	did not run from humans,but ran straight to tree & climbed up	POINT (-73.9772164524209 40.7688399538756)
1467	1467	-73.9684657285532	40.7840113573723	22B-AM-1013-05	22B	AM	10132018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground		tree	0	0	1	0	0		0	0	0	0	0	0	0	0	looked down on me like her imperial subject	POINT (-73.9684657285532 40.7840113573723)
1745	1745	-73.9688438058715	40.7703014325728	8I-AM-1006-05	08I	AM	10062018	5	Adult	Gray	White	Gray+White		Above Ground	20	tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9688438058715 40.7703014325728)
2144	2144	-73.975198284551	40.7740343763399	9B-AM-1010-06	09B	AM	10102018	6	Juvenile	Gray	White	Gray+White		Above Ground	16	tree	0	0	1	0	0	cleaning	0	0	0	0	0	0	1	0		POINT (-73.975198284551 40.7740343763399)
2280	2280	-73.97671436441509	40.76847569413211	3D-AM-1006-02	03D	AM	10062018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	25	tree	1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9767143644151 40.7684756941321)
2699	2699	-73.9743509423821	40.7690043677328	5F-AM-1007-02	05F	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground		tree	1	1	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.97435094238212 40.7690043677328)
2944	2944	-73.97394038506219	40.769316228750895	5F-AM-1007-05	05F	AM	10072018	5	Adult	Gray	White	Gray+White		Above Ground	2	tree	1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9739403850622 40.7693162287509)

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