2018_Central_Park_Squirrel_Census_-_Squirrel_Data

60 rows where Date = 10072018, Eating = 0, Indifferent = 1 and Shift = "PM"

- 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, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Foraging, Kuks, Tail flags, Tail twitches, Approaches

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
18	18	-73.9532170504865	40.7919669739962	36I-PM-1007-01	36I	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9532170504865 40.7919669739962)
65	65	-73.9741824992294	40.7689486657963	5F-PM-1007-03	05F	PM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	hiding nut	0	0	0	0	1	0	1	0		POINT (-73.9741824992294 40.7689486657963)
73	73	-73.96148483609001	40.7922645521905	33C-PM-1007-03	33C	PM	10072018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.96148483609 40.7922645521905)
76	76	-73.9530035564643	40.792182245761296	36I-PM-1007-07	36I	PM	10072018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9530035564643 40.7921822457613)
190	190	-73.9695507965155	40.7743070423435	12F-PM-1007-04	12F	PM	10072018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0	stared	POINT (-73.96955079651552 40.7743070423435)
192	192	-73.9651654887991	40.7777806006951	17H-PM-1007-02	17H	PM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9651654887991 40.7777806006951)
269	269	-73.9591400366159	40.7891708599318	31F-PM-1007-01	31F	PM	10072018	1	Adult	Gray	White	Gray+White	white neck and belly	Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9591400366159 40.7891708599318)
398	398	-73.9686737866872	40.773971402373206	12G-PM-1007-06	12G	PM	10072018	6		Gray	Cinnamon	Gray+Cinnamon					0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9686737866872 40.7739714023732)
444	444	-73.96414623605409	40.7778316005464	18I-PM-1007-09	18I	PM	10072018	9	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	1	0	0	canoodling w/ 8	0	0	0	0	0	0	1	0		POINT (-73.9641462360541 40.7778316005464)
468	468	-73.9780659679557	40.7672382282781	1D-PM-1007-06	01D	PM	10072018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9780659679557 40.7672382282781)
575	575	-73.9783366903829	40.7668300056094	1D-PM-1007-03	01D	PM	10072018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9783366903829 40.7668300056094)
599	599	-73.95302635524891	40.7920949788358	36I-PM-1007-05	36I	PM	10072018	5	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9530263552489 40.7920949788358)
831	831	-73.9587712679442	40.7944502501428	36D-PM-1007-02	36D	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	1	0		POINT (-73.9587712679442 40.7944502501428)
901	901	-73.97022281317109	40.7742131587983	12F-PM-1007-12	12F	PM	10072018	12	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	5		0	0	0	0	1	going down tree	0	0	0	0	0	0	1	0		POINT (-73.9702228131711 40.7742131587983)
936	936	-73.9684758245091	40.7858531619022	24A-PM-1007-02	24A	PM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9684758245091 40.7858531619022)
937	937	-73.97063234587691	40.7713196034265	9G-PM-1007-03	09G	PM	10072018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9706323458769 40.771319603426505)
971	971	-73.978392591149	40.7668993398193	1D-PM-1007-04	01D	PM	10072018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.978392591149 40.7668993398193)
976	976	-73.9740381194088	40.7675912588173	4G-PM-1007-01	04G	PM	10072018	1	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.9740381194088 40.7675912588173)
1063	1063	-73.97503467782809	40.766540440482395	2G-PM-1007-01	02G	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9750346778281 40.7665404404824)
1300	1300	-73.964280573021	40.777830911491	18I-PM-1007-08	18I	PM	10072018	8	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	1	1	0	0	canoodling w/ #9	0	0	0	0	0	0	1	0		POINT (-73.964280573021 40.777830911491)
1301	1301	-73.95521466657141	40.7892909102377	32I-PM-1007-03	32I	PM	10072018	3	Adult	Gray		Gray+	small adult	Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9552146665714 40.7892909102377)
1326	1326	-73.9747288122551	40.7659918747507	2G-PM-1007-03	02G	PM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9747288122551 40.7659918747507)
1544	1544	-73.9642111283068	40.77777139853271	18I-PM-1007-07	18I	PM	10072018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9642111283068 40.7777713985327)
1570	1570	-73.96628648847891	40.7891062338302	28A-PM-1007-02	28A	PM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0	running from #3	0	0	0	0	0	0	1	0		POINT (-73.9662864884789 40.7891062338302)
1590	1590	-73.9610388059192	40.793952935840004	34B-PM-1007-01	34B	PM	10072018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9610388059192 40.79395293584)
1616	1616	-73.9642666013207	40.7810384867375	21G-PM-1007-03	21G	PM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.96426660132072 40.7810384867375)
1660	1660	-73.98004994980342	40.7702181099573	4A-PM-1007-05	04A	PM	10072018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE	At rock	0	0	0	0	1		0	0	0	1	1	0	1	0		POINT (-73.9800499498034 40.770218109957305)
1668	1668	-73.97469348106671	40.7659431884158	2G-PM-1007-02	02G	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	burying nut	0	0	0	0	1	0	1	0		POINT (-73.9746934810667 40.7659431884158)
1727	1727	-73.96924722995651	40.7722592187215	10H-PM-1007-01	10H	PM	10072018	1	Adult	Gray	White	Gray+White	dark gray	Above Ground	15	in tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9692472299565 40.7722592187215)
1730	1730	-73.97961428483491	40.7702117898305	4A-PM-1007-04	04A	PM	10072018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9796142848349 40.7702117898305)
1750	1750	-73.9684806250183	40.7858776210151	24A-PM-1007-03	24A	PM	10072018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9684806250183 40.7858776210151)
1847	1847	-73.9782283921819	40.766793260207706	1D-PM-1007-02	01D	PM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9782283921819 40.7667932602077)
1851	1851	-73.9623621412501	40.7814673556041	22H-PM-1007-03	22H	PM	10072018	3	Adult	Gray	White	Gray+White		Above Ground	4	chased squirrel #2 away	0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9623621412501 40.7814673556041)
1910	1910	-73.9699876501742	40.774248267675794	12F-PM-1007-06	12F	PM	10072018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	1	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9699876501742 40.77424826767581)
1948	1948	-73.9738410069766	40.7691686156505	5F-PM-1007-06	05F	PM	10072018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	jumping on fence	0	0	0	0	1	0	1	0		POINT (-73.9738410069766 40.7691686156505)
1954	1954	-73.9794840520702	40.7709595369804	4A-PM-1007-02	04A	PM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9794840520702 40.770959536980406)
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)
2031	2031	-73.9795454787631	40.768802689274104	3B-PM-1007-09	03B	PM	10072018	9	Adult			+					0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9795454787631 40.7688026892741)
2075	2075	-73.96362349533341	40.7775138547689	18I-PM-1007-06	18I	PM	10072018	6	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1	digging	0	0	0	0	0	0	1	0		POINT (-73.9636234953334 40.7775138547689)
2111	2111	-73.968446056806	40.785824818871	24A-PM-1007-01	24A	PM	10072018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.96844605680602 40.785824818871)
2210	2210	-73.9699124811406	40.7743016981538	12F-PM-1007-07	12F	PM	10072018	7	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	1	1	0	1		0	0	0	1	0	0	1	0		POINT (-73.9699124811406 40.7743016981538)
2260	2260	-73.9784685928652	40.7669924015341	1D-PM-1007-05	01D	PM	10072018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9784685928652 40.7669924015341)
2305	2305	-73.9679833225379	40.773854709340206	12H-PM-1007-05	12H	PM	10072018	5		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9679833225379 40.7738547093402)
2321	2321	-73.9743060404813	40.7687901781431	5F-PM-1007-02	05F	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9743060404813 40.7687901781431)
2402	2402	-73.9777206733344	40.7668595585487	1D-PM-1007-07	01D	PM	10072018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0	lying down	0	0	0	0	0	0	1	0		POINT (-73.9777206733344 40.7668595585487)
2436	2436	-73.95827701417	40.785661023889105	28I-PM-1007-01	28I	PM	10072018	1	Adult	Gray		Gray+		Above Ground	20		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.95827701417 40.7856610238891)
2448	2448	-73.9668230576555	40.78706372333271	25B-PM-1007-02	25B	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9668230576555 40.7870637233327)
2537	2537	-73.9735533713513	40.7690605609001	5F-PM-1007-05	05F	PM	10072018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9735533713513 40.7690605609001)
2670	2670	-73.95310419064691	40.7919916819219	36I-PM-1007-02	36I	PM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	1	0	0	1		0	0	0	0	1	1	1	0	chased birds (blue jay)	POINT (-73.9531041906469 40.7919916819219)
2686	2686	-73.97755714038921	40.766531658519796	1E-PM-1007-03	01E	PM	10072018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9775571403892 40.7665316585198)
2695	2695	-73.962800448652	40.7915532640139	31B-PM-1007-03	31B	PM	10072018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.962800448652 40.7915532640139)
2704	2704	-73.96577644902841	40.781192322928604	20F-PM-1007-10	20F	PM	10072018	10	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9657764490284 40.7811923229286)
2737	2737	-73.97036835101758	40.774397536395796	12F-PM-1007-10	12F	PM	10072018	10	Adult	Gray	Cinnamon	Gray+Cinnamon					0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9703683510176 40.7743975363958)
2760	2760	-73.9701808122548	40.7744632730919	12F-PM-1007-11	12F	PM	10072018	11	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.9701808122548 40.7744632730919)
2851	2851	-73.955208233231	40.7890574331084	32I-PM-1007-02	32I	PM	10072018	2	Adult			+		Above Ground	30		0	0	1	0	0	different sound - happy,playful chirps	0	0	0	0	1	0	1	0		POINT (-73.955208233231 40.7890574331084)
2891	2891	-73.9636482556874	40.7775831570186	18I-PM-1007-05	18I	PM	10072018	5	Juvenile	Cinnamon	Gray, Black	Cinnamon+Gray, Black		Ground Plane	FALSE		0	0	0	0	1	jumping crazily / digging hole	0	0	0	0	0	0	1	0		POINT (-73.9636482556874 40.7775831570186)
2943	2943	-73.962534856258	40.7812134517411	22H-PM-1007-01	22H	PM	10072018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.962534856258 40.7812134517411)
2961	2961	-73.9736238258579	40.7688712771191	5F-PM-1007-04	05F	PM	10072018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9736238258579 40.7688712771191)
3001	3001	-73.97755922284159	40.7668485329273	1D-PM-1007-01	01D	PM	10072018	1	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.9775592228416 40.7668485329273)
3003	3003	-73.96986639266571	40.773999710413	12F-PM-1007-09	12F	PM	10072018	9	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9698663926657 40.773999710413)

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