2018_Central_Park_Squirrel_Census_-_Squirrel_Data

40 rows where Hectare Squirrel Number = 4, Location = "Above Ground" and Shift = "AM"

- 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: Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, Tail twitches, 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
100	100	-73.9761592532482	40.774721358538706	10A-AM-1006-04	10A	AM	10062018	4	Juvenile	Gray		Gray+		Above Ground	10	tree near large rock on Bridle Path	0	0	0	0	0	walking on branch	0	0	0	0	1	0	0	0		POINT (-73.9761592532482 40.7747213585387)
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)
364	364	-73.9623696148045	40.792184861375	32B-AM-1017-04	32B	AM	10172018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	13		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9623696148045 40.792184861375)
441	441	-73.9742973420446	40.7691801644292	5F-AM-1007-04	05F	AM	10072018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground		rocks	0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9742973420446 40.7691801644292)
497	497	-73.96021668769791	40.7953811003986	36B-AM-1013-04	36B	AM	10132018	4		Black		Black+		Above Ground	20	Moved 20+ feet high above top of tree limb	0	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9602166876979 40.7953811003986)
667	667	-73.9624538733037	40.7883829851518	28D-AM-1012-04	28D	AM	10122018	4	Adult	Cinnamon	White	Cinnamon+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9624538733037 40.7883829851518)
849	849	-73.9736165917399	40.772454390149704	8D-AM-1007-04	08D	AM	10072018	4	Adult	Gray		Gray+		Above Ground	3		0	1	0	0	0	chasing squirrel #3	0	0	0	0	0	0	0	0		POINT (-73.9736165917399 40.7724543901497)
1003	1003	-73.9645547556826	40.776877007081	16I-AM-1008-04	16I	AM	10082018	4	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	9	tree hollow	0	0	0	0	0	in hollow	0	0	0	0	0	0	0	0	curious	POINT (-73.9645547556826 40.776877007081)
1053	1053	-73.96858597054859	40.784880506532204	23A-AM-1018-04	23A	AM	10182018	4	Adult	Gray		Gray+		Above Ground	3	Tree	0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9685859705486 40.7848805065322)
1079	1079	-73.9722737593623	40.768963018754	6G-AM-1008-04	06G	AM	10082018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon	very long tail	Above Ground	20	tree	1	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9722737593623 40.768963018754)
1227	1227	-73.9527924755398	40.79343662605329	37I-AM-1010-04	37I	AM	10102018	4	Adult	Gray		Gray+		Above Ground	50	in tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9527924755398 40.7934366260533)
1280	1280	-73.9562469727195	40.79685907654	39D-AM-1008-04	39D	AM	10082018	4	Adult	Gray		Gray+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9562469727195 40.79685907654)
1365	1365	-73.9791648157033	40.767625444347	2C-AM-1010-04	02C	AM	10102018	4	Adult	Gray		Gray+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9791648157033 40.767625444347)
1391	1391	-73.95786586329571	40.7933712188923	35E-AM-1020-04	35E	AM	10202018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	30		0	0	0	0	0	hunkered down,tail over body; sitting perfectly still	0	0	0	0	0	0	1	0		POINT (-73.9578658632957 40.7933712188923)
1449	1449	-73.95611248920629	40.7949440648632	37E-AM-1013-04	37E	AM	10132018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	8		0	0	1	1	0		1	0	0	0	0	0	0	1		POINT (-73.9561124892063 40.7949440648632)
1518	1518	-73.9632265832593	40.7816914475461	22G-AM-1018-04	22G	AM	10182018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	3		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9632265832593 40.78169144754611)
1623	1623	-73.97701191330229	40.773294909000505	8A-AM-1013-04	08A	AM	10132018	4	Juvenile			+		Above Ground	4	fence	1	1	0	1	1	playing tag together	0	0	0	0	0	1	0	0		POINT (-73.9770119133023 40.7732949090005)
1675	1675	-73.97774976458341	40.767734470917794	2D-AM-1007-04	02D	AM	10072018	4	Adult	Gray		Gray+		Above Ground	100		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9777497645834 40.7677344709178)
1729	1729	-73.97650461090191	40.7736674124746	8B-AM-1007-04	08B	AM	10072018	4	Adult	Gray		Gray+		Above Ground	2		0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9765046109019 40.7736674124746)
1767	1767	-73.958719099962	40.7947587726617	36C-AM-1014-04	36C	AM	10142018	4		Gray	White	Gray+White		Above Ground	15	Ground then tree to eat	1	0	1	1	0		0	0	0	0	0	0	0	1		POINT (-73.958719099962 40.7947587726617)
1790	1790	-73.97305925481159	40.7740879251541	10D-AM-1008-04	10D	AM	10082018	4	Juvenile	Gray		Gray+		Above Ground	25		0	1	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9730592548116 40.7740879251541)
1828	1828	-73.9682965197661	40.780537896388296	18D-AM-1018-04	18D	AM	10182018	4	Adult	Gray		Gray+		Above Ground	2		0	0	1	0	1		0	0	0	0	0	0	0	0		POINT (-73.9682965197661 40.7805378963883)
1993	1993	-73.9546367558712	40.789840987798	33I-AM-1008-04	33I	AM	10082018	4	Adult			+		Above Ground	100		0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9546367558712 40.789840987798)
2103	2103	-73.9782983634755	40.766831436426294	1D-AM-1006-04	01D	AM	10062018	4	Adult	Gray	White	Gray+White		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9782983634755 40.7668314364263)
2140	2140	-73.9598875541307	40.79734155807171	38A-AM-1019-04	38A	AM	10192018	4	Adult	Gray		Gray+		Above Ground	2		0	0	0	0	0	walking	0	0	0	0	0	0	1	0		POINT (-73.9598875541307 40.7973415580717)
2248	2248	-73.9766477027266	40.7712737417779	6C-AM-1007-04	06C	AM	10072018	4	Adult	Gray		Gray+		Above Ground	20		0	1	1	0	0	chasing #5	0	0	0	0	0	0	1	0		POINT (-73.9766477027266 40.7712737417779)
2295	2295	-73.9590632051055	40.79631465848271	38B-AM-1019-04	38B	AM	10192018	4	Adult	Gray		Gray+		Above Ground	20		0	0	0	0	0	sitting in tree	1	1	0	1	0	0	1	0	observant	POINT (-73.9590632051055 40.7963146584827)
2322	2322	-73.97236778547979	40.766731541087104	3H-AM-1008-04	03H	AM	10082018	4	Adult	Black		Black+		Above Ground	50		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9723677854798 40.7667315410871)
2449	2449	-73.9599911537509	40.791445254284504	33D-AM-1017-04	33D	AM	10172018	4	Adult	Black		Black+		Above Ground	5		0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9599911537509 40.7914452542845)
2450	2450	-73.9756273257684	40.7706539186221	6D-AM-1008-04	06D	AM	10082018	4	Adult	Gray		Gray+		Above Ground			0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9756273257684 40.7706539186221)
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)
2521	2521	-73.976869549792	40.770698245472296	5C-AM-1006-04	05C	AM	10062018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	12	thin branch of tree	0	0	0	0	0	relaxing	0	0	0	1	0	0	1	0		POINT (-73.976869549792 40.7706982454723)
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)
2634	2634	-73.96956851864891	40.7788293026327	16D-AM-1007-04	16D	AM	10072018	4	Adult	Gray		Gray+		Above Ground	8		0	0	1	0	0		0	0	0	1	0	0	0	1		POINT (-73.9695685186489 40.7788293026327)
2654	2654	-73.9549261242548	40.7944701994615	37G-AM-1014-04	37G	AM	10142018	4	Adult	Gray		Gray+		Above Ground	5		0	1	0	0	0	playing	0	0	0	0	0	0	1	0		POINT (-73.9549261242548 40.7944701994615)
2740	2740	-73.96126586889142	40.7912119940469	32C-AM-1014-04	32C	AM	10142018	4	Adult	Gray		Gray+		Above Ground	8		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9612658688914 40.7912119940469)
2744	2744	-73.9752915601718	40.7739329570033	9B-AM-1010-04	09B	AM	10102018	4				+		Above Ground	10		1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9752915601718 40.7739329570033)
2754	2754	-73.9687025912431	40.7719319822619	10H-AM-1014-04	10H	AM	10142018	4	Juvenile			+		Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9687025912431 40.7719319822619)
2790	2790	-73.9673554935258	40.782752724959394	21C-AM-1014-04	21C	AM	10142018	4	Adult			+	High in tree, unable to tell	Above Ground	60		0	0	1	0	0		0	0	0	1	0	0	1	0		POINT (-73.96735549352582 40.7827527249594)
2988	2988	-73.9766342759486	40.7687518380873	4D-AM-1012-04	04D	AM	10122018	4	Adult	Gray		Gray+		Above Ground	3	on tree trunk	0	1	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9766342759486 40.7687518380873)

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