2018_Central_Park_Squirrel_Census_-_Squirrel_Data

48 rows where Date = 10192018, Indifferent = 0, Location = "Ground Plane" 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, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Climbing, Eating, Foraging, 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
6	6	-73.9565700386162	40.7902561000937	33H-AM-1019-02	33H	AM	10192018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	wrestling with mother	0	0	0	0	0	0	0	0		POINT (-73.9565700386162 40.7902561000937)
170	170	-73.95972059663241	40.7969409510133	38B-AM-1019-01	38B	AM	10192018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9597205966324 40.7969409510133)
181	181	-73.9708775864433	40.772473633538	10F-PM-1019-12	10F	PM	10192018	12	Adult	Black	White	Black+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9708775864433 40.772473633538)
218	218	-73.9712318712643	40.7773053099657	14D-PM-1019-04	14D	PM	10192018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9712318712643 40.7773053099657)
274	274	-73.9639832886071	40.7909532437095	30B-PM-1019-08	30B	PM	10192018	8	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	0	0	0	1		POINT (-73.9639832886071 40.7909532437095)
332	332	-73.9705123624953	40.7731723757869	10F-PM-1019-11	10F	PM	10192018	11	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Grassy area	0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9705123624953 40.7731723757869)
365	365	-73.9576035072364	40.7966120824816	38C-AM-1019-01	38C	AM	10192018	1	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	runs from (lawnmower)	POINT (-73.9576035072364 40.7966120824816)
699	699	-73.95046935442251	40.797225436004	42H-AM-1019-01	42H	AM	10192018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9504693544225 40.797225436004)
855	855	-73.9808247660048	40.76894088312871	2A-PM-1019-01	02A	PM	10192018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0	runs from	0	0	0	1	0	0	0	1		POINT (-73.9808247660048 40.7689408831287)
888	888	-73.9674177504573	40.7769569731993	15G-PM-1019-03	15G	PM	10192018	3	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9674177504573 40.7769569731993)
932	932	-73.9718597156773	40.776585876331296	13C-PM-1019-04	13C	PM	10192018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9718597156773 40.7765858763313)
964	964	-73.9631045499811	40.790618096947206	30B-PM-1019-04	30B	PM	10192018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	1	1	1		0	0	0	0	0	0	0	1		POINT (-73.9631045499811 40.7906180969472)
980	980	-73.9709817796369	40.7773554311586	14D-PM-1019-07	14D	PM	10192018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9709817796369 40.7773554311586)
1186	1186	-73.96740331258341	40.7769132902037	15G-PM-1019-02	15G	PM	10192018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9674033125834 40.7769132902037)
1265	1265	-73.96035971176191	40.7824399298414	23I-PM-1019-02	23I	PM	10192018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9603597117619 40.7824399298414)
1286	1286	-73.9589096782789	40.793969875790296	35D-AM-1019-02	35D	AM	10192018	2	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	Black tail & edge, Cinnamon mid, While tail edge	Ground Plane	FALSE		0	0	0	0	1	very quietly searching in long grass	0	0	0	0	0	0	0	0		POINT (-73.9589096782789 40.7939698757903)
1383	1383	-73.96767327256721	40.7763194425467	15G-PM-1019-09	15G	PM	10192018	9	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9676732725672 40.7763194425467)
1392	1392	-73.96480906981759	40.7903882097837	29A-PM-1019-03	29A	PM	10192018	3	Juvenile	Black	Cinnamon	Black+Cinnamon		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	1	0	1	ran from,but now approaching. kind of weirding me out.	POINT (-73.9648090698176 40.7903882097837)
1441	1441	-73.961335649743	40.7818876867842	23H-PM-1019-01	23H	PM	10192018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.961335649743 40.7818876867842)
1465	1465	-73.9720289863666	40.7763749561607	13C-PM-1019-03	13C	PM	10192018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.97202898636661 40.7763749561607)
1540	1540	-73.957710975899	40.79840556140471	40B-AM-1019-06	40B	AM	10192018	6	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.957710975899 40.7984055614047)
1642	1642	-73.97088608794591	40.77683766561189	14D-PM-1019-15	14D	PM	10192018	15	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9708860879459 40.7768376656119)
1758	1758	-73.9581241870185	40.7961057536141	38C-AM-1019-05	38C	AM	10192018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9581241870185 40.7961057536141)
1759	1759	-73.9576219570858	40.79633512256721	38C-AM-1019-03	38C	AM	10192018	3	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9576219570858 40.7963351225672)
1798	1798	-73.9558180952889	40.7886810505944	31I-PM-1019-03	31I	PM	10192018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9558180952889 40.7886810505944)
1833	1833	-73.962516494651	40.788476898990204	28D-PM-1019-02	28D	PM	10192018	2	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.962516494651 40.7884768989902)
1893	1893	-73.9708108312271	40.7773975776146	14D-PM-1019-09	14D	PM	10192018	9	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9708108312271 40.7773975776146)
1956	1956	-73.98089749771201	40.7690578709841	2A-PM-1019-02	02A	PM	10192018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	0	0		POINT (-73.980897497712 40.7690578709841)
1997	1997	-73.97146376830841	40.776898456156296	14D-PM-1019-01	14D	PM	10192018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9714637683084 40.7768984561563)
2036	2036	-73.9610266708075	40.7817512107392	23I-PM-1019-03	23I	PM	10192018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9610266708075 40.7817512107392)
2053	2053	-73.97118102224209	40.7773445611969	14D-PM-1019-05	14D	PM	10192018	5	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9711810222421 40.7773445611969)
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)
2168	2168	-73.95823634371351	40.7987752300505	40B-AM-1019-06	40B	AM	10192018	6	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9582363437135 40.7987752300505)
2198	2198	-73.97097381665309	40.7774102689734	14D-PM-1019-08	14D	PM	10192018	8	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9709738166531 40.7774102689734)
2254	2254	-73.9709991016317	40.7725756707748	10F-PM-1019-03	10F	PM	10192018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Cinnamon head	Ground Plane	FALSE	Behind fence, grass	0	0	0	1	0	eating (nuts)	0	0	0	0	0	1	0	0	approaches (bad tourists w/ nuts)	POINT (-73.9709991016317 40.772575670774806)
2287	2287	-73.97681733031649	40.7661261813557	1F-PM-1019-01	01F	PM	10192018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9768173303165 40.7661261813557)
2384	2384	-73.9708564226824	40.7726219968014	10F-PM-1019-09	10F	PM	10192018	9	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Across Arbor path into hill w/ bushes	1	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9708564226824 40.7726219968014)
2509	2509	-73.97142951022491	40.776954371947	14D-PM-1019-02	14D	PM	10192018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9714295102249 40.776954371947)
2527	2527	-73.9675697600155	40.776679741446294	15G-PM-1019-06	15G	PM	10192018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1	scratching!	0	0	0	0	0	0	0	0		POINT (-73.9675697600155 40.7766797414463)
2544	2544	-73.9713680837672	40.77716615083639	14D-PM-1019-03	14D	PM	10192018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9713680837672 40.77716615083641)
2556	2556	-73.96398284313679	40.7910151996207	30B-PM-1019-09	30B	PM	10192018	9	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9639828431368 40.7910151996207)
2597	2597	-73.97063044050999	40.77710605948079	14D-PM-1019-14	14D	PM	10192018	14	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.97063044051 40.7771060594808)
2608	2608	-73.95226776576591	40.7934034811368	38I-AM-1019-02	38I	AM	10192018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9522677657659 40.7934034811368)
2662	2662	-73.97086289336241	40.772563088678396	10F-PM-1019-08	10F	PM	10192018	8	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Under "Grape Arbor" structure behind Bandshell	1	0	0	0	1	digging	0	0	0	0	0	0	0	1		POINT (-73.9708628933624 40.7725630886784)
2715	2715	-73.9710273070712	40.776652124615296	14D-PM-1019-16	14D	PM	10192018	16	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9710273070712 40.7766521246153)
2825	2825	-73.96435075880079	40.790432469329204	30B-PM-1019-07	30B	PM	10192018	7	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.96435075880082 40.7904324693292)
2882	2882	-73.956581233786	40.7902127690837	33H-AM-1019-01	33H	AM	10192018	1	Adult	Cinnamon	Gray	Cinnamon+Gray	Cinnamon patches	Ground Plane	FALSE		0	0	0	0	0	wrestling with child	0	0	0	0	0	0	0	0		POINT (-73.956581233786 40.79021276908371)
2902	2902	-73.9673220504383	40.777029634596296	15G-PM-1019-04	15G	PM	10192018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9673220504383 40.7770296345963)

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