2018_Central_Park_Squirrel_Census_-_Squirrel_Data

19 rows where Date = 10142018, Hectare Squirrel Number = 4, Indifferent = 1 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: Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Climbing, Eating, Foraging, Tail flags, Tail twitches, 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
445	445	-73.97140573271591	40.7720375135272	9F-PM-1014-04	09F	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9714057327159 40.7720375135272)
459	459	-73.9624546917649	40.7888234959792	29D-AM-1014-04	29D	AM	10142018	4	Juvenile	Gray		Gray+		Ground Plane	FALSE	Rock a	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9624546917649 40.78882349597921)
541	541	-73.9617612388703	40.7952875954297	35A-AM-1014-04	35A	AM	10142018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9617612388703 40.7952875954297)
626	626	-73.97050538215771	40.7787503220242	16C-AM-1014-04	16C	AM	10142018	4	Adult	Gray	Black	Gray+Black		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9705053821577 40.7787503220242)
823	823	-73.954595058342	40.7956567934304	39F-AM-1014-04	39F	AM	10142018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.954595058342 40.7956567934304)
842	842	-73.9645147011741	40.777256683379896	17I-AM-1014-04	17I	AM	10142018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	1	0		POINT (-73.9645147011741 40.7772566833799)
1177	1177	-73.98078982247259	40.768215817511	1A-PM-1014-04	01A	PM	10142018	4	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9807898224726 40.768215817511)
1639	1639	-73.9736800575584	40.778306973575795	14A-PM-1014-04	14A	PM	10142018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	0	0	chasing (#3)	0	0	0	0	1	0	1	0		POINT (-73.9736800575584 40.7783069735758)
1665	1665	-73.95839443533521	40.7979689846815	39B-PM-1014-04	39B	PM	10142018	4	Adult	Gray		Gray+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	1	1	runs from (me—when i approached)	POINT (-73.9583944353352 40.7979689846815)
2027	2027	-73.964449990389	40.7830023160643	22F-PM-1014-04	22F	PM	10142018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.964449990389 40.7830023160643)
2059	2059	-73.9710026704697	40.776105276462104	13D-AM-1014-04	13D	AM	10142018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9710026704697 40.7761052764621)
2128	2128	-73.9757673193743	40.7669614322613	2F-PM-1014-04	02F	PM	10142018	4	Adult	Gray		Gray+		Above Ground	20		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9757673193743 40.766961432261304)
2270	2270	-73.9703732649257	40.77019793771029	8H-PM-1014-04	08H	PM	10142018	4	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.97037326492571 40.7701979377103)
2325	2325	-73.9728360875598	40.7660637295671	3H-PM-1014-04	03H	PM	10142018	4	Adult	Black	Cinnamon	Black+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9728360875598 40.7660637295671)
2613	2613	-73.96393252683	40.7808289765857	21G-AM-1014-04	21G	AM	10142018	4	Adult	Gray	White	Gray+White		Above Ground	6		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.96393252683 40.7808289765857)
2654	2654	-73.9549261242548	40.7944701994615	37G-AM-1014-04	37G	AM	10142018	4	Adult	Gray		Gray+		Above Ground	5		0	1	0	0	0	playing	0	0	0	0	0	0	1	0		POINT (-73.9549261242548 40.7944701994615)
2753	2753	-73.96810908249779	40.783827583032796	22B-PM-1014-04	22B	PM	10142018	4	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9681090824978 40.7838275830328)
2790	2790	-73.9673554935258	40.782752724959394	21C-AM-1014-04	21C	AM	10142018	4	Adult			+	High in tree, unable to tell	Above Ground	60		0	0	1	0	0		0	0	0	1	0	0	1	0		POINT (-73.96735549352582 40.7827527249594)
2832	2832	-73.958607566971	40.7983695505584	40B-PM-1014-04	40B	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.958607566971 40.7983695505584)

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