2018_Central_Park_Squirrel_Census_-_Squirrel_Data

16 rows where Climbing = 0, Highlight Fur Color = "Gray" and Location = "Above Ground"

- 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, Age, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Eating, 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
224	224	-73.9520592496349	40.797507629981105	42G-PM-1014-03	42G	PM	10142018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	4	on fence	1	0	0	0	0	prancing	0	0	0	0	0	0	0	1		POINT (-73.9520592496349 40.7975076299811)
319	319	-73.96590343597059	40.779751668884394	19F-AM-1007-02	19F	AM	10072018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	8		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9659034359706 40.77975166888441)
377	377	-73.9757001944781	40.769499790547	5E-AM-1008-09	05E	AM	10082018	9	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	2	went up tree	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9757001944781 40.769499790547)
399	399	-73.97634332024009	40.773847349068106	9B-PM-1013-10	09B	PM	10132018	10	Juvenile	Cinnamon	Gray	Cinnamon+Gray	"Brown" written in as Primary	Above Ground	12		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9763433202401 40.7738473490681)
780	780	-73.9675472064204	40.7835947167436	22C-PM-1006-06	22C	PM	10062018	6	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10	on tree	0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9675472064204 40.7835947167436)
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)
1103	1103	-73.9541500874008	40.7920329989756	35H-AM-1013-02	35H	AM	10132018	2	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10	Sitting on tree limb	0	0	0	0	0	sitting	0	0	0	0	0	0	1	0	watching me from tree,but calm	POINT (-73.9541500874008 40.7920329989756)
1135	1135	-73.9667474482967	40.7760643720793	15H-PM-1008-01	15H	PM	10082018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10	Oak tree	0	1	0	0	0	watching me	0	1	0	1	0	0	0	0	observant	POINT (-73.9667474482967 40.7760643720793)
1226	1226	-73.97684509716998	40.7709430375069	5C-PM-1010-07	05C	PM	10102018	7	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	13		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.97684509717 40.7709430375069)
1799	1799	-73.978844141973	40.7696046074378	4B-AM-1010-05	04B	AM	10102018	5	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10		0	1	0	0	0	chasing squirrel #6	1	1	0	0	1	0	0	0		POINT (-73.978844141973 40.7696046074378)
2026	2026	-73.9622752768962	40.7814921913101	22H-PM-1007-02	22H	PM	10072018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	4	low branch	0	0	0	0	0	watching me scratching	1	0	0	1	0	0	1	0		POINT (-73.9622752768962 40.7814921913101)
2244	2244	-73.9509628195532	40.797777567417796	42H-PM-1014-01	42H	PM	10142018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	2		0	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9509628195532 40.7977775674178)
2487	2487	-73.9595222999173	40.7833202577782	25I-AM-1012-02	25I	AM	10122018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	31	on tree	1	1	0	0	0		0	0	0	1	1	0	1	0		POINT (-73.9595222999173 40.7833202577782)
2521	2521	-73.976869549792	40.770698245472296	5C-AM-1006-04	05C	AM	10062018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	12	thin branch of tree	0	0	0	0	0	relaxing	0	0	0	1	0	0	1	0		POINT (-73.976869549792 40.7706982454723)
2912	2912	-73.9632164738341	40.7921270121312	32B-PM-1010-03	32B	PM	10102018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	15		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9632164738341 40.7921270121312)
2913	2913	-73.9621297946132	40.7944058222814	34A-PM-1013-05	34A	PM	10132018	5	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	4		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9621297946132 40.7944058222814)

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