2018_Central_Park_Squirrel_Census_-_Squirrel_Data

20 rows where Age = "Juvenile", Indifferent = 1, Running = 1 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

- 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, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Eating, Foraging, Kuks, Tail flags, Runs from, Other Interactions

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
187	187	-73.9700162034073	40.7815277479588	19B-AM-1019-02	19B	AM	10192018	2	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	1	0	posing	0	0	0	0	0	0	1	1	indifferent then runs from	POINT (-73.9700162034073 40.7815277479588)
375	375	-73.9752000129992	40.773291812223896	8C-PM-1013-04	08C	PM	10132018	4	Juvenile	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9752000129992 40.7732918122239)
408	408	-73.9633760173635	40.7818422357619	22G-PM-1018-03	22G	PM	10182018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	chilling	0	0	0	0	0	0	1	0	observed	POINT (-73.96337601736352 40.7818422357619)
525	525	-73.952526164386	40.796375924050395	40G-AM-1007-02	40G	AM	10072018	2	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	18		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.952526164386 40.7963759240504)
596	596	-73.9769319450348	40.7743883576247	9A-AM-1013-11	09A	AM	10132018	11	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	foot of tree	1	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9769319450348 40.7743883576247)
706	706	-73.95701325709341	40.793201415908705	35F-PM-1012-01	35F	PM	10122018	1	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		1	0	0	1	1		0	0	0	1	0	0	1	1		POINT (-73.9570132570934 40.7932014159087)
804	804	-73.9697196619878	40.7814068507607	19B-AM-1019-01	19B	AM	10192018	1	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Side stripes	Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	1	1	indifferent then runs from	POINT (-73.9697196619878 40.7814068507607)
928	928	-73.96704295859901	40.778437071937105	17F-AM-1007-05	17F	AM	10072018	5	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	1	0		0	0	0	1	0	0	1	0		POINT (-73.967042958599 40.7784370719371)
999	999	-73.980948293606	40.76856888506279	2A-PM-1019-04	02A	PM	10192018	4	Juvenile	Gray	White	Gray+White		Above Ground	15	in tree!	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.980948293606 40.7685688850628)
1021	1021	-73.97186968288	40.778926988884	15B-AM-1014-03	15B	AM	10142018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	1	running (from a dog)	0	0	0	0	0	0	1	0		POINT (-73.97186968288 40.778926988884)
1064	1064	-73.9540257319561	40.798408619116	42E-PM-1012-02	42E	PM	10122018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon					1	0	1	0	0		0	0	0	0	0	0	1	1		POINT (-73.9540257319561 40.798408619116)
1212	1212	-73.9761792189352	40.7745745517215	9A-AM-1013-09	09A	AM	10132018	9	Juvenile	Cinnamon		Cinnamon+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9761792189352 40.7745745517215)
1403	1403	-73.9761632586697	40.7741085606149	9B-PM-1013-05	09B	PM	10132018	5	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9761632586697 40.7741085606149)
1470	1470	-73.97248065806379	40.771007720613206	7F-AM-1008-15	07F	AM	10082018	15	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9724806580638 40.7710077206132)
1985	1985	-73.9530791622513	40.79598856039671	40G-PM-1013-03	40G	PM	10132018	3	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9530791622513 40.7959885603967)
2289	2289	-73.97458005923929	40.767356541975005	3F-AM-1006-08	03F	AM	10062018	8	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	close to tall tree & light post	1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9745800592393 40.767356541975)
2412	2412	-73.98094464895641	40.768503216587895	2A-PM-1019-03	02A	PM	10192018	3	Juvenile	Gray	White	Gray+White		Above Ground	15	in tree!	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9809446489564 40.7685032165879)
2657	2657	-73.9582150734453	40.7962862794303	38C-AM-1019-08	38C	AM	10192018	8	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		1	0	0	0	0	0	1	0		POINT (-73.9582150734453 40.7962862794303)
2919	2919	-73.9768563402344	40.7744487310786	9A-AM-1013-12	09A	AM	10132018	12	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	foot of tree	1	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9768563402344 40.7744487310786)
2920	2920	-73.9657391918196	40.776502470347	16H-PM-1014-01	16H	PM	10142018	1	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9657391918196 40.776502470347)

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