2018_Central_Park_Squirrel_Census_-_Squirrel_Data

38 rows where Date = 10062018, Highlight Fur Color = "Cinnamon", Indifferent = 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, Hectare Squirrel Number, Age, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Quaas, Tail flags

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
20	20	-73.9706105896967	40.769812482150705	7H-AM-1006-05	07H	AM	10062018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9706105896967 40.7698124821507)
169	169	-73.97487064155841	40.7744174965072	10B-AM-1006-02	10B	AM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground		High in a tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9748706415584 40.7744174965072)
207	207	-73.9770824412252	40.770996130945704	5C-AM-1006-03	05C	AM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.97708244122522 40.7709961309457)
333	333	-73.9667560049684	40.7882333830729	27A-PM-1006-01	27A	PM	10062018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground		on a tree	0	0	0	1	1	walking up & down branches	0	0	0	0	0	0	1	0		POINT (-73.9667560049684 40.7882333830729)
352	352	-73.970540988328	40.769810306706205	7H-AM-1006-06	07H	AM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	12		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.970540988328 40.7698103067062)
418	418	-73.9573604880421	40.7930844158021	35E-PM-1006-03	35E	PM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9573604880421 40.7930844158021)
453	453	-73.959514034869	40.789911786416	31E-PM-1006-02	31E	PM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	under bushes	0	0	0	1	1		0	1	0	0	0	0	1	0		POINT (-73.959514034869 40.789911786416)
472	472	-73.9702721244652	40.7701011774207	7H-AM-1006-15	07H	AM	10062018	15	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9702721244652 40.7701011774207)
486	486	-73.971213385696	40.769872094337	7H-AM-1006-04	07H	AM	10062018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.97121338569602 40.769872094337)
775	775	-73.95957577926829	40.7899242643847	31E-PM-1006-01	31E	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	under bushes	0	0	0	0	1		0	1	0	0	0	0	1	0		POINT (-73.9595757792683 40.7899242643847)
830	830	-73.95956459625391	40.7899599350145	31E-PM-1006-03	31E	PM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	under bushes	0	0	0	1	1	burying	0	0	0	0	0	0	1	0		POINT (-73.9595645962539 40.7899599350145)
1209	1209	-73.97631591531379	40.7705785330431	5C-AM-1006-07	05C	AM	10062018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9763159153138 40.7705785330431)
1400	1400	-73.97734958071351	40.7664559937331	1E-AM-1006-05	01E	AM	10062018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9773495807135 40.7664559937331)
1455	1455	-73.9715621134573	40.7695918717513	7H-AM-1006-02	07H	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1	running (along ground,up tree)	0	0	0	0	0	0	1	0		POINT (-73.9715621134573 40.76959187175131)
1469	1469	-73.97048311770351	40.7699878995692	7H-AM-1006-10	07H	AM	10062018	10	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9704831177035 40.7699878995692)
1503	1503	-73.97321932906308	40.7748791447746	11D-PM-1006-01	11D	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9732193290631 40.7748791447746)
1542	1542	-73.960876728048	40.790357245370004	31D-PM-1006-03	31D	PM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.960876728048 40.79035724537)
1556	1556	-73.97462382801159	40.7671491962844	3F-AM-1006-06	03F	AM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9746238280116 40.7671491962844)
1628	1628	-73.97136652496141	40.76971786480021	7H-AM-1006-01	07H	AM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	nut in mouth	0	0	0	0	0	0	1	0		POINT (-73.9713665249614 40.7697178648002)
1676	1676	-73.9566686940197	40.794924397955	37E-PM-1006-05	37E	PM	10062018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9566686940197 40.794924397955)
1757	1757	-73.9601561064548	40.7900513933531	31E-PM-1006-08	31E	PM	10062018	8	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9601561064548 40.7900513933531)
1813	1813	-73.9706988226435	40.7696684566926	7H-AM-1006-16	07H	AM	10062018	16	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9706988226435 40.7696684566926)
1815	1815	-73.96032682553171	40.7900154505092	31E-PM-1006-06	31E	PM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9603268255317 40.7900154505092)
1853	1853	-73.9721210372896	40.7667971476099	4I-AM-1006-02	04I	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9721210372896 40.7667971476099)
1921	1921	-73.97562782402329	40.766952370137204	2F-AM-1006-02	02F	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5	in tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9756278240233 40.7669523701372)
1995	1995	-73.9603366992925	40.7899612889539	31E-PM-1006-05	31E	PM	10062018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9603366992925 40.789961288953904)
2063	2063	-73.95447632818859	40.7969645476349	40F-PM-1006-03	40F	PM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9544763281886 40.7969645476349)
2290	2290	-73.95656457165641	40.795903994957705	38D-PM-1006-03	38D	PM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9565645716564 40.795903994957705)
2336	2336	-73.95312632141359	40.7965675089932	40F-PM-1006-01	40F	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9531263214136 40.7965675089932)
2368	2368	-73.9731925179247	40.7748962746181	11D-PM-1006-02	11D	PM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9731925179247 40.7748962746181)
2425	2425	-73.9791141532217	40.7714888835416	5A-AM-1006-04	05A	AM	10062018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9791141532217 40.77148888354161)
2623	2623	-73.9604482901468	40.7898646293603	31E-PM-1006-07	31E	PM	10062018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9604482901468 40.7898646293603)
2635	2635	-73.97638367403421	40.7706121151491	5C-AM-1006-06	05C	AM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9763836740342 40.7706121151491)
2650	2650	-73.9538251716292	40.7919360198175	35I-PM-1006-01	35I	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9538251716292 40.7919360198175)
2709	2709	-73.97750689157151	40.7664424394736	1E-AM-1006-01	01E	AM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9775068915715 40.7664424394736)
2783	2783	-73.97917671562679	40.7714445258765	5A-AM-1006-02	05A	AM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	12	in tall shrubs near wall next to CPW	0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9791767156268 40.7714445258765)
2792	2792	-73.97237364945971	40.766950134329704	4H-AM-1006-01	04H	AM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9723736494597 40.7669501343297)
2870	2870	-73.9538475741188	40.796479421955	40F-PM-1006-02	40F	PM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	6		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9538475741188 40.796479421955)

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