2018_Central_Park_Squirrel_Census_-_Squirrel_Data

39 rows where Hectare Squirrel Number = 1, Indifferent = 0, Running = 1 and Runs from = 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, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Eating, Foraging, Quaas, 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
30	30	-73.96929432916109	40.776953610248796	15E-AM-1013-01	15E	AM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9692943291611 40.7769536102488)
51	51	-73.9801666435401	40.7686905339212	2B-PM-1013-01	02B	PM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0	running (with nut)	0	0	0	0	0	0	0	0		POINT (-73.9801666435401 40.7686905339212)
113	113	-73.9700100617602	40.7815739959357	19B-PM-1018-01	19B	PM	10182018	1	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Above Ground	20		1	0	0	0	0	flying	0	0	0	0	0	0	0	0		POINT (-73.9700100617602 40.7815739959357)
118	118	-73.9566346046453	40.7973923396512	40D-PM-1013-01	40D	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9566346046453 40.7973923396512)
120	120	-73.9511118711108	40.7950813345902	40I-AM-1018-01	40I	AM	10182018	1	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		1	0	0	0	1	begging	0	0	0	0	0	0	0	0		POINT (-73.9511118711108 40.7950813345902)
373	373	-73.96721272832829	40.7810666805133	20D-AM-1007-01	20D	AM	10072018	1	Adult	Gray		Gray+	too far to note 30'	Ground Plane	FALSE		1	0	1	1	0	a lot of activity	0	0	0	1	0	0	0	0		POINT (-73.9672127283283 40.7810666805133)
420	420	-73.96718516112429	40.7750878657618	14H-PM-1012-01	14H	PM	10122018	1	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	1	0	0	approaches (came very close to me)	POINT (-73.9671851611243 40.7750878657618)
465	465	-73.9683041099256	40.786265230008205	24A-AM-1014-01	24A	AM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0	freezes	POINT (-73.9683041099256 40.7862652300082)
479	479	-73.95694033658471	40.795659960879796	38D-PM-1006-01	38D	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0	didn't see me or others	POINT (-73.9569403365847 40.7956599608798)
520	520	-73.97494466297059	40.77206596960671	7D-PM-1010-01	07D	PM	10102018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE	outside fenced hectare	1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9749446629706 40.7720659696067)
674	674	-73.9779811967788	40.7675178797546	2D-AM-1007-01	02D	AM	10072018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9779811967788 40.7675178797546)
751	751	-73.9683479943823	40.7815827298303	20C-PM-1018-01	20C	PM	10182018	1	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9683479943823 40.7815827298303)
950	950	-73.9637415893182	40.7898140363534	29B-AM-1007-01	29B	AM	10072018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9637415893182 40.7898140363534)
1004	1004	-73.9670850805619	40.7833747810387	22C-PM-1006-01	22C	PM	10062018	1	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	1	0	0	0	for food	0	1	0	0	0	0	0	0		POINT (-73.9670850805619 40.7833747810387)
1264	1264	-73.97853537753821	40.7674923683184	2C-PM-1013-01	02C	PM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9785353775382 40.7674923683184)
1373	1373	-73.956737220098	40.797580989254996	40C-PM-1006-01	40C	PM	10062018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.95673722009802 40.797580989255)
1408	1408	-73.973230162241	40.768982453144396	5F-AM-1007-01	05F	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5	fence	1	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.973230162241 40.7689824531444)
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)
1549	1549	-73.97779784978941	40.7668620784309	1D-AM-1006-01	01D	AM	10062018	1	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	0	1	0	1		0	0	0	0	1	0	0	0		POINT (-73.9777978497894 40.7668620784309)
1685	1685	-73.96788229832741	40.7802960985637	18E-PM-1006-01	18E	PM	10062018	1	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9678822983274 40.7802960985637)
1795	1795	-73.968004352343	40.7726669278308	11I-PM-1012-01	11I	PM	10122018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	1		0	0	0	1	1	0	0	0	look at humans determining	POINT (-73.968004352343 40.7726669278308)
1867	1867	-73.9745204169071	40.7736282868469	9C-AM-1006-01	09C	AM	10062018	1	Adult	Gray		Gray+		Above Ground	40	Tree	1	0	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.9745204169071 40.7736282868469)
1945	1945	-73.9530257401736	40.795139740737	39G-PM-1013-01	39G	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9530257401736 40.79513974073701)
2033	2033	-73.9500167570283	40.7966185836685	41I-AM-1018-01	41I	AM	10182018	1	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	0	0	cautious,observant,runs off	POINT (-73.9500167570283 40.7966185836685)
2044	2044	-73.97715523261991	40.7706917595308	5C-AM-1006-01	05C	AM	10062018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	1	0	1	0	0		POINT (-73.9771552326199 40.7706917595308)
2147	2147	-73.9651217998407	40.7761115392738	15I-PM-1012-01	15I	PM	10122018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	1	0	0	0		POINT (-73.9651217998407 40.7761115392738)
2235	2235	-73.9748522796455	40.771958662100296	7D-PM-1010-01	07D	PM	10102018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE	outside fenced hectare	1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9748522796455 40.7719586621003)
2275	2275	-73.96142184133559	40.793894505879294	34B-AM-1013-01	34B	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1	hopping	0	0	0	0	1	1	0	0		POINT (-73.9614218413356 40.7938945058793)
2313	2313	-73.9646174034945	40.778128752826206	18H-AM-1018-01	18H	AM	10182018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Running from one tree to the other	1	1	0	0	0	playing?	0	0	0	0	0	0	0	0		POINT (-73.9646174034945 40.7781287528262)
2316	2316	-73.957697363244	40.7997576909042	42A-PM-1014-01	42A	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1	up on hind legs looking around	0	0	0	0	0	0	0	0	came to about 10' away then ran off	POINT (-73.957697363244 40.7997576909042)
2546	2546	-73.9660267365885	40.776444395505	16H-AM-1007-01	16H	AM	10072018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9660267365885 40.776444395505)
2609	2609	-73.95968653180941	40.7893787188526	31F-AM-1013-01	31F	AM	10132018	1	Adult	Gray	Black	Gray+Black		Above Ground	25		1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9596865318094 40.7893787188526)
2629	2629	-73.9604576237503	40.7818120101394	23I-PM-1019-01	23I	PM	10192018	1	Adult	Gray		Gray+		Above Ground	35		1	0	0	0	0	running (across branches)	0	0	0	0	0	0	0	0		POINT (-73.9604576237503 40.7818120101394)
2655	2655	-73.9659156108069	40.781070981869604	20E-AM-1014-01	20E	AM	10142018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	1	0	0	0		POINT (-73.9659156108069 40.7810709818696)
2743	2743	-73.9587179613803	40.7992119571657	41A-PM-1007-01	41A	PM	10072018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9587179613803 40.7992119571657)
2758	2758	-73.95420748142959	40.79543222400039	39F-AM-1014-01	39F	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9542074814296 40.7954322240004)
2835	2835	-73.9531953594918	40.7960413520131	40G-PM-1013-01	40G	PM	10132018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	1	0	0		POINT (-73.9531953594918 40.7960413520131)
2900	2900	-73.9631005470369	40.788549405719294	28D-AM-1012-01	28D	AM	10122018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9631005470369 40.7885494057193)
2998	2998	-73.97520792474191	40.775537697900205	11B-AM-1007-01	11B	AM	10072018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	1	0	0		POINT (-73.9752079247419 40.7755376979002)

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