2018_Central_Park_Squirrel_Census_-_Squirrel_Data

20 rows where Climbing = 1, Hectare Squirrel Number = 6, Indifferent = 0 and Running = 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, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Eating, Foraging, Kuks, Quaas, 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
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)
133	133	-73.9664711607022	40.787896428768	26A-PM-1006-06	26A	PM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Tree 90th left 90th & 89	0	0	1	0	0		0	0	0	1	0	0	0	0	studying us looking for food	POINT (-73.9664711607022 40.787896428768)
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)
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)
708	708	-73.9592819491968	40.7941062008626	35C-AM-1007-06	35C	AM	10072018	6	Adult			+		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9592819491968 40.7941062008626)
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)
850	850	-73.9642288873015	40.782043998356706	22F-AM-1007-06	22F	AM	10072018	6	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	1	1	0		0	0	0	0	0	1	0	0		POINT (-73.9642288873015 40.7820439983567)
1032	1032	-73.96328685617941	40.7907806312915	30B-AM-1007-06	30B	AM	10072018	6	Adult	Gray		Gray+		Above Ground	5		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9632868561794 40.7907806312915)
1099	1099	-73.9761527947483	40.770960700253895	6C-AM-1007-06	06C	AM	10072018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	7		0	0	1	0	0		0	0	0	0	0	0	0	0	disappeared when jogger ran by	POINT (-73.9761527947483 40.7709607002539)
1128	1128	-73.9638599044346	40.7809288795308	21G-AM-1014-06	21G	AM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5		0	1	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9638599044346 40.7809288795308)
1273	1273	-73.95589438800509	40.7971535141896	40D-PM-1013-06	40D	PM	10132018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9558943880051 40.7971535141896)
1644	1644	-73.9734654671008	40.7715988711659	8E-PM-1008-06	08E	PM	10082018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE	5, 6, 7 all at same tree trunk base	0	1	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9734654671008 40.7715988711659)
1803	1803	-73.9588076804698	40.7912942607296	33E-AM-1014-06	33E	AM	10142018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9588076804698 40.7912942607296)
2079	2079	-73.96430251719141	40.790570391517	30B-PM-1019-06	30B	PM	10192018	6	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	0	0	0	1		POINT (-73.9643025171914 40.790570391517)
2206	2206	-73.95944460183459	40.7917800352042	33D-AM-1017-06	33D	AM	10172018	6	Adult	Black		Black+		Above Ground	10		0	0	1	0	0		1	1	0	0	0	0	0	1	runs from (ran into hole in tree trunk)	POINT (-73.9594446018346 40.7917800352042)
2519	2519	-73.9589475065438	40.7934846881536	35D-PM-1013-06	35D	PM	10132018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9589475065438 40.7934846881536)
2577	2577	-73.9597048490102	40.7955846466241	37B-AM-1018-06	37B	AM	10182018	6	Adult	Gray		Gray+		Above Ground	1		0	0	1	0	0		0	1	0	0	0	0	0	1		POINT (-73.9597048490102 40.7955846466241)
2815	2815	-73.97473113123941	40.76773197250439	3F-PM-1013-06	03F	PM	10132018	6	Adult	Gray	White	Gray+White		Above Ground	19		0	0	1	0	0		0	1	0	0	0	0	0	1		POINT (-73.97473113123941 40.7677319725044)
2844	2844	-73.9578840941242	40.7955586232429	37D-PM-1014-06	37D	PM	10142018	6	Adult	Gray		Gray+		Above Ground	25		0	0	1	0	1		0	0	0	0	0	0	0	0		POINT (-73.9578840941242 40.7955586232429)
2892	2892	-73.9688070760806	40.777968829417205	16E-AM-1014-06	16E	AM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	0	0	0	1		POINT (-73.9688070760806 40.777968829417205)

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