2018_Central_Park_Squirrel_Census_-_Squirrel_Data

41 rows where Date = 10062018, 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, Other Activities, Quaas, Tail flags, Tail twitches, 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
55	55	-73.9568802149818	40.7972399133816	39C-PM-1006-01	39C	PM	10062018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9568802149818 40.7972399133816)
71	71	-73.9576245992455	40.7873862510001	29H-PM-1006-01	29H	PM	10062018	1	Adult	Gray		Gray+		Above Ground	50		0	0	1	0	0	sitting	0	0	0	0	0	0	1	0		POINT (-73.9576245992455 40.7873862510001)
96	96	-73.9708549670788	40.7699587019058	7H-PM-1006-04	07H	PM	10062018	4	Adult	Gray		Gray+		Above Ground	12	on tree knob	0	0	0	0	0	sitting	0	0	0	0	0	0	1	0		POINT (-73.9708549670788 40.7699587019058)
134	134	-73.9575943815564	40.7933755266787	35E-PM-1006-07	35E	PM	10062018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	1		POINT (-73.9575943815564 40.7933755266787)
367	367	-73.9704862864304	40.773958311167604	11F-PM-1006-02	11F	PM	10062018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9704862864304 40.7739583111676)
546	546	-73.9547423290276	40.7899702628835	33I-PM-1006-09	33I	PM	10062018	9	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9547423290276 40.7899702628835)
564	564	-73.95700862122851	40.7946679755816	37E-PM-1006-08	37E	PM	10062018	8	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.95700862122851 40.7946679755816)
569	569	-73.9709040623777	40.7701163892686	7H-PM-1006-03	07H	PM	10062018	3	Adult	Gray		Gray+		Above Ground	8	tree	1	0	1	0	0		0	0	0	1	0	0	1	0		POINT (-73.9709040623777 40.7701163892686)
673	673	-73.958417813526	40.792730121447605	34E-PM-1006-01	34E	PM	10062018	1	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Above Ground	20		0	0	0	0	0	sitting and watching on a tree	0	0	0	0	0	0	1	0		POINT (-73.958417813526 40.7927301214476)
754	754	-73.9563203089105	40.7906275357726	33G-PM-1006-01	33G	PM	10062018	1	Juvenile	Gray		Gray+		Above Ground	2		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9563203089105 40.7906275357726)
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)
790	790	-73.9745040517502	40.77333038538	9C-PM-1006-06	09C	PM	10062018	6	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.97450405175022 40.77333038538)
1049	1049	-73.9564606426367	40.788054657260794	30I-PM-1006-06	30I	PM	10062018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	1	ran up tree	POINT (-73.9564606426367 40.7880546572608)
1458	1458	-73.9545037193355	40.7900225055417	33I-PM-1006-04	33I	PM	10062018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9545037193355 40.7900225055417)
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)
1535	1535	-73.9703921271418	40.770027611531404	7H-PM-1006-06	07H	PM	10062018	6	Adult	Gray		Gray+		Above Ground	15		0	1	1	0	0	playing w/ #7	0	0	0	0	0	0	1	0		POINT (-73.9703921271418 40.770027611531404)
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)
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)
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)
1820	1820	-73.9546337446865	40.7898772579576	33I-PM-1006-08	33I	PM	10062018	8	Adult	Gray		Gray+		Above Ground	6		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9546337446865 40.7898772579576)
1973	1973	-73.957138759793	40.795592603505504	38D-PM-1006-02	38D	PM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.957138759793 40.7955926035055)
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)
2008	2008	-73.95243640874371	40.792846505434	37I-PM-1006-01	37I	PM	10062018	1	Adult	Cinnamon	Gray, Black	Cinnamon+Gray, Black		Above Ground	5		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9524364087437 40.792846505434)
2035	2035	-73.9527184914182	40.792678590484705	37I-PM-1006-02	37I	PM	10062018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9527184914182 40.7926785904847)
2046	2046	-73.9706414863639	40.7732754837144	11F-PM-1006-01	11F	PM	10062018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0	sitting	0	0	0	0	0	0	1	0		POINT (-73.9706414863639 40.7732754837144)
2180	2180	-73.960864328605	40.7902122634639	31D-PM-1006-02	31D	PM	10062018	2	Adult	Gray		Gray+		Above Ground	15		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.960864328605 40.7902122634639)
2298	2298	-73.97553718499721	40.7733561233828	9C-PM-1006-02	09C	PM	10062018	2	Adult	Gray	White	Gray+White		Above Ground	15		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9755371849972 40.7733561233828)
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)
2362	2362	-73.9700263936574	40.769933509858106	7H-PM-1006-07	07H	PM	10062018	7	Adult	Gray		Gray+		Above Ground	15		0	1	1	0	0	playing w/ #6	0	0	0	0	0	0	1	0		POINT (-73.9700263936574 40.7699335098581)
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)
2396	2396	-73.9704339422613	40.77401495296439	11F-PM-1006-03	11F	PM	10062018	3	Adult	Gray		Gray+		Above Ground	4		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9704339422613 40.7740149529644)
2408	2408	-73.9596949258862	40.79000794792171	31E-PM-1006-04	31E	PM	10062018	4	Adult	Gray		Gray+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9596949258862 40.7900079479217)
2542	2542	-73.9754802138871	40.773300804411996	9C-PM-1006-03	09C	PM	10062018	3	Adult	Gray	White	Gray+White		Above Ground	15		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9754802138871 40.773300804412)
2559	2559	-73.95723834787741	40.787685738072206	30H-PM-1006-01	30H	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9572383478774 40.7876857380722)
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)
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)
2842	2842	-73.9579292340076	40.7976287835027	39C-PM-1006-04	39C	PM	10062018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9579292340076 40.7976287835027)
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)
2935	2935	-73.96045994773449	40.7915035010169	32D-PM-1006-06	32D	PM	10062018	6	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9604599477345 40.7915035010169)
2958	2958	-73.9541748083177	40.795275844289705	39F-PM-1006-01	39F	PM	10062018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1	carrying leaves	0	0	0	0	0	0	1	0		POINT (-73.9541748083177 40.7952758442897)

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