2018_Central_Park_Squirrel_Census_-_Squirrel_Data

47 rows where Climbing = 0, Highlight Fur Color = "White", Location = "Above Ground" 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: Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Approaches, Indifferent, 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
25	25	-73.96711306801141	40.7784859700171	17F-AM-1007-07	17F	AM	10072018	7	Adult	Gray	White	Gray+White		Above Ground	24		1	0	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9671130680114 40.7784859700171)
80	80	-73.9688454483585	40.78453012881629	22A-AM-1008-05	22A	AM	10082018	5	Adult	Gray	White	Gray+White		Above Ground	3	trash can	0	0	0	1	0		0	0	0	1	0	0	0	1		POINT (-73.9688454483585 40.7845301288163)
163	163	-73.97123088643941	40.7714534847379	9G-AM-1007-04	09G	AM	10072018	4	Adult	Gray	White	Gray+White		Above Ground	15		0	0	0	0	0	grooming	0	0	0	0	0	0	1	0		POINT (-73.9712308864394 40.7714534847379)
189	189	-73.9735489537928	40.76812579115229	4G-AM-1006-02	04G	AM	10062018	2		Gray	White	Gray+White		Above Ground	12	tree	0	0	0	0	0	sitting in tree	0	0	0	0	0	0	1	0		POINT (-73.9735489537928 40.7681257911523)
258	258	-73.9534333425633	40.793256416332795	37H-AM-1018-03	37H	AM	10182018	3	Adult	Gray	White	Gray+White		Above Ground	10	in a tree with red berries	0	0	0	1	0		0	1	0	0	0	0	0	1		POINT (-73.9534333425633 40.7932564163328)
299	299	-73.9586214081667	40.7937473968735	35D-PM-1013-03	35D	PM	10132018	3	Juvenile	Gray	White	Gray+White	No Tail!	Above Ground	2	bench	0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9586214081667 40.7937473968735)
331	331	-73.95448101115	40.7954469678857	39F-PM-1006-03	39F	PM	10062018	3	Adult	Gray	White	Gray+White		Above Ground	15	lower branch of tree	0	0	0	1	0		0	0	0	0	0	0	0	1	ran up tree when approached	POINT (-73.95448101115 40.7954469678857)
385	385	-73.979316275899	40.769213472755496	3B-PM-1007-01	03B	PM	10072018	1	Adult	Gray	White	Gray+White		Above Ground		in tree	0	0	0	0	0	chased by dog	0	0	0	0	0	0	0	0		POINT (-73.979316275899 40.7692134727555)
426	426	-73.9741944367138	40.7769889953596	13B-PM-1008-01	13B	PM	10082018	1	Adult	Gray	White	Gray+White		Above Ground	2	on railing	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9741944367138 40.7769889953596)
488	488	-73.9615751148595	40.795455123814605	36A-AM-1018-01	36A	AM	10182018	1	Juvenile	Gray	White	Gray+White		Above Ground	15		0	0	0	1	0	eating (red berries)	0	0	0	0	0	0	1	0		POINT (-73.9615751148595 40.7954551238146)
498	498	-73.9669432929573	40.779136518298	18F-AM-1014-01	18F	AM	10142018	1	Adult	Gray	White	Gray+White		Above Ground		Low tree	0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9669432929573 40.779136518298)
600	600	-73.9808202088503	40.7682921842325	1A-PM-1014-02	01A	PM	10142018	2	Adult	Cinnamon	White	Cinnamon+White		Above Ground	6		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9808202088503 40.7682921842325)
602	602	-73.96857515954851	40.7709413567859	9I-PM-1010-07	09I	PM	10102018	7	Adult	Gray	White	Gray+White		Above Ground	1	ran up tree	1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9685751595485 40.7709413567859)
966	966	-73.95831758180199	40.791656668315795	33E-AM-1014-12	33E	AM	10142018	12	Adult	Gray	White	Gray+White		Above Ground	15		0	0	0	0	0	sleeping	0	0	0	0	0	0	0	0	asleep	POINT (-73.958317581802 40.7916566683158)
999	999	-73.980948293606	40.76856888506279	2A-PM-1019-04	02A	PM	10192018	4	Juvenile	Gray	White	Gray+White		Above Ground	15	in tree!	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.980948293606 40.7685688850628)
1028	1028	-73.97070123456609	40.7758938984066	13E-PM-1008-03	13E	PM	10082018	3	Juvenile	Gray	White	Gray+White		Above Ground	10	hanging upside down to get a nut	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9707012345661 40.7758938984066)
1080	1080	-73.96902119353459	40.773038298158	11H-AM-1010-07	11H	AM	10102018	7	Adult	Gray	White	Gray+White		Above Ground	4		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9690211935346 40.773038298158)
1126	1126	-73.97001860010491	40.7826052184658	20B-AM-1007-03	20B	AM	10072018	3	Adult	Gray	White	Gray+White		Above Ground			0	0	0	0	1		0	0	0	1	0	0	0	1		POINT (-73.9700186001049 40.7826052184658)
1203	1203	-73.9616999731028	40.7954126939561	36A-AM-1018-02	36A	AM	10182018	2	Juvenile	Gray	White	Gray+White		Above Ground	15		0	0	0	1	0	eating (red berries)	0	0	0	0	0	0	1	0		POINT (-73.9616999731028 40.7954126939561)
1411	1411	-73.98028400317591	40.7678599069819	1B-PM-1019-04	01B	PM	10192018	4	Juvenile	Gray	White	Gray+White		Above Ground	25	in tree	0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9802840031759 40.7678599069819)
1414	1414	-73.9580513096783	40.79909641532	41B-AM-1010-02	41B	AM	10102018	2	Adult	Gray	White	Gray+White		Above Ground	16		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9580513096783 40.79909641532)
1423	1423	-73.96002043282009	40.782877291358	24I-AM-1019-01	24I	AM	10192018	1	Adult	Gray	White	Gray+White		Above Ground	10		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9600204328201 40.782877291358)
1489	1489	-73.9501762527462	40.797553408607705	42H-PM-1014-05	42H	PM	10142018	5	Adult	Gray	White	Gray+White		Above Ground	15		1	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9501762527462 40.7975534086077)
1652	1652	-73.94984217462209	40.7969397424182	42I-PM-1014-02	42I	PM	10142018	2	Adult	Cinnamon	White	Cinnamon+White		Above Ground	8		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9498421746221 40.7969397424182)
1832	1832	-73.9693159934697	40.7831212338295	21B-PM-1017-03	21B	PM	10172018	3	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	1		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9693159934697 40.7831212338295)
1915	1915	-73.9797112925048	40.76880467784721	2B-PM-1013-09	02B	PM	10132018	9	Adult	Gray	White	Gray+White		Above Ground	30		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9797112925048 40.7688046778472)
1916	1916	-73.9693504617353	40.7830678709405	21B-PM-1017-02	21B	PM	10172018	2	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	1		0	1	0	0	0		0	1	0	0	0	0	0	0	stood on hind legs with front legs on the chest	POINT (-73.9693504617353 40.7830678709405)
2084	2084	-73.9567255763265	40.7936331899263	36F-AM-1017-05	36F	AM	10172018	5	Adult	Gray	White	Gray+White		Above Ground	8		0	0	0	0	0	staying very still to avoid two very curious dogs on the ground	0	0	0	0	0	0	0	0	petrified,frozen (tail over its back,frozen)	POINT (-73.9567255763265 40.7936331899263)
2114	2114	-73.9651541395415	40.7798283208748	19G-PM-1017-01	19G	PM	10172018	1	Adult	Cinnamon	White	Cinnamon+White		Above Ground	12		0	0	0	0	0	watching	0	0	0	0	0	1	0	0		POINT (-73.9651541395415 40.7798283208748)
2185	2185	-73.9707571364399	40.7758859812524	13E-PM-1008-02	13E	PM	10082018	2	Adult	Gray	White	Gray+White		Above Ground	10		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9707571364399 40.7758859812524)
2190	2190	-73.9657040391563	40.7755567428199	15I-AM-1008-06	15I	AM	10082018	6	Adult	Cinnamon	White	Cinnamon+White		Above Ground	12		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9657040391563 40.7755567428199)
2231	2231	-73.95454276114769	40.793035381744104	36G-PM-1012-02	36G	PM	10122018	2	Adult	Gray	White	Gray+White		Above Ground	10		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9545427611477 40.7930353817441)
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)
2331	2331	-73.9694681803635	40.770585795359004	8I-AM-1006-06	08I	AM	10062018	6	Adult	Gray	White	Gray+White		Above Ground			0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9694681803635 40.770585795359)
2412	2412	-73.98094464895641	40.768503216587895	2A-PM-1019-03	02A	PM	10192018	3	Juvenile	Gray	White	Gray+White		Above Ground	15	in tree!	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9809446489564 40.7685032165879)
2478	2478	-73.96749310703241	40.778369369095394	17F-AM-1007-04	17F	AM	10072018	4	Adult	Cinnamon	White	Cinnamon+White		Above Ground	4		0	0	0	1	0	chilling	1	0	0	0	0	0	1	0		POINT (-73.9674931070324 40.7783693690954)
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)
2550	2550	-73.96948057455221	40.774355690284295	12F-AM-1020-01	12F	AM	10202018	1	Adult	Cinnamon	White	Cinnamon+White		Above Ground	17	Tree	0	0	0	0	0	jumping	0	0	0	0	0	0	0	0		POINT (-73.9694805745522 40.7743556902843)
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)
2632	2632	-73.95082755733499	40.797579073666	42H-PM-1014-02	42H	PM	10142018	2	Adult	Gray	White	Gray+White		Above Ground		Running along stone ledge	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.950827557335 40.797579073666)
2659	2659	-73.95536034380208	40.7985282963244	41D-PM-1014-05	41D	PM	10142018	5	Adult	Gray	White	Gray+White		Above Ground	12		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9553603438021 40.7985282963244)
2706	2706	-73.9745141185576	40.76914797812071	5E-AM-1008-01	05E	AM	10082018	1	Adult	Gray	White	Gray+White		Above Ground	2	on a checker table	0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9745141185576 40.7691479781207)
2742	2742	-73.96280415779341	40.7884180156055	28D-AM-1012-06	28D	AM	10122018	6	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	5		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9628041577934 40.78841801560551)
2767	2767	-73.9751806727197	40.7671940332258	3F-PM-1013-05	03F	PM	10132018	5	Adult	Gray	White	Gray+White		Above Ground	13		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.97518067271972 40.7671940332258)
2865	2865	-73.98028424040159	40.767825738497706	1B-PM-1019-03	01B	PM	10192018	3	Juvenile	Gray	White	Gray+White		Above Ground	25	in tree	0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.98028424040162 40.7678257384977)
2944	2944	-73.97394038506219	40.769316228750895	5F-AM-1007-05	05F	AM	10072018	5	Adult	Gray	White	Gray+White		Above Ground	2	tree	1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9739403850622 40.7693162287509)
2950	2950	-73.9790980124501	40.7685934093915	2B-PM-1013-08	02B	PM	10132018	8	Adult	Gray	White	Gray+White		Above Ground	15		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9790980124501 40.7685934093915)

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