2018_Central_Park_Squirrel_Census_-_Squirrel_Data

45 rows where Date = 10132018, Hectare Squirrel Number = 1, Indifferent = 0 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, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Other Activities, 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
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)
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)
135	135	-73.9694168118643	40.7728877377977	11G-PM-1013-01	11G	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5	In the Woods/Brush	0	0	1	0	1		0	0	0	0	0	0	0	1	watching me	POINT (-73.9694168118643 40.7728877377977)
143	143	-73.9661361310677	40.7787872561177	18G-PM-1013-01	18G	PM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1	burying	0	0	0	0	0	0	0	1		POINT (-73.9661361310677 40.7787872561177)
195	195	-73.97377736133109	40.7673662611015	3G-PM-1013-01	03G	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9737773613311 40.7673662611015)
197	197	-73.9679336341793	40.7754186579647	14G-PM-1013-01	14G	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	0	watching	POINT (-73.9679336341793 40.7754186579647)
271	271	-73.9661262885099	40.7844085550945	23D-AM-1013-01	23D	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	3		0	0	1	0	0		0	0	0	0	0	1	0	0	approaches (he saw me,came towards,then darted up)	POINT (-73.9661262885099 40.7844085550945)
291	291	-73.9679661308374	40.7837388390673	22C-AM-1013-01	22C	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	0	0	0	sitting still,tail over back	0	0	0	0	0	0	0	0		POINT (-73.9679661308374 40.7837388390673)
630	630	-73.9580109357087	40.78556544054471	28I-AM-1013-01	28I	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Jumped onto path & then back into brush	0	0	0	0	0	stood on fence	0	0	0	0	0	0	0	1		POINT (-73.9580109357087 40.7855654405447)
653	653	-73.97034013856842	40.7795238784266	17C-PM-1013-01	17C	PM	10132018	1	Adult	Gray		Gray+		Ground Plane	FALSE	then perched on 2-ft high border fencing	0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9703401385684 40.7795238784266)
927	927	-73.9609885686834	40.796110864031895	37A-PM-1013-01	37A	PM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.96098856868342 40.7961108640319)
1027	1027	-73.9640016324897	40.7921759097124	32A-PM-1013-01	32A	PM	10132018	1	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9640016324897 40.7921759097124)
1052	1052	-73.9773858189627	40.770807701562	5B-PM-1013-01	05B	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9773858189627 40.770807701562)
1096	1096	-73.95683008997729	40.793585574335395	36E-AM-1013-01	36E	AM	10132018	1	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	runs from (ran into treebrush)	POINT (-73.9568300899773 40.7935855743354)
1180	1180	-73.9639726817977	40.7829083461049	23F-PM-1013-01	23F	PM	10132018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	runs from (dove into some bushes/undergrowth,only saw briefly! → not because of humans tho.)	POINT (-73.9639726817977 40.7829083461049)
1205	1205	-73.9611118778753	40.7952007875354	36A-PM-1013-01	36A	PM	10132018	1		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1	burying	0	0	0	0	0	1	0	0		POINT (-73.9611118778753 40.7952007875354)
1211	1211	-73.9549337398033	40.794655273162796	38F-PM-1013-01	38F	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon tail & belly	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9549337398033 40.7946552731628)
1261	1261	-73.9719109949232	40.772313852132704	9F-AM-1013-01	09F	AM	10132018	1	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9719109949232 40.7723138521327)
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)
1279	1279	-73.95121209494779	40.7947945266515	39I-PM-1013-01	39I	PM	10132018	1	Adult	Gray		Gray+		Ground Plane	FALSE	along the road	0	0	0	1	0	digging	0	0	0	0	0	0	0	0		POINT (-73.9512120949478 40.7947945266515)
1412	1412	-73.9594676326588	40.7984457363388	39A-AM-1013-01	39A	AM	10132018	1	Juvenile	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9594676326588 40.7984457363388)
1493	1493	-73.96847906578509	40.7838818717863	22B-AM-1013-01	22B	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0	looked at me,standing on back feet	POINT (-73.9684790657851 40.7838818717863)
1526	1526	-73.96209645764691	40.791733200173795	32C-PM-1013-01	32C	PM	10132018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9620964576469 40.7917332001738)
1621	1621	-73.97349693209429	40.7722754599865	8E-AM-1013-01	08E	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9734969320943 40.7722754599865)
1683	1683	-73.9790889008147	40.7676402781925	1C-PM-1013-01	01C	PM	10132018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	0	1	0	0		POINT (-73.9790889008147 40.7676402781925)
1707	1707	-73.96045242711669	40.7956624328733	36B-AM-1013-01	36B	AM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9604524271167 40.7956624328733)
1865	1865	-73.9558118887106	40.796885713436	39E-PM-1013-01	39E	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon head	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9558118887106 40.796885713436005)
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)
1952	1952	-73.96818104666929	40.7720638449419	10I-PM-1013-01	10I	PM	10132018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9681810466693 40.7720638449419)
2143	2143	-73.9596232170232	40.7959550843229	37B-PM-1013-01	37B	PM	10132018	1	Adult	Gray		Gray+	Sighting was far away	Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9596232170232 40.795955084322905)
2161	2161	-73.9715375915057	40.7751212088827	12D-AM-1013-01	12D	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9715375915057 40.7751212088827)
2183	2183	-73.967334936601	40.7773289724189	16F-PM-1013-01	16F	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Woods	0	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.967334936601 40.7773289724189)
2338	2338	-73.9716621112698	40.774286221946895	11E-AM-1013-01	11E	AM	10132018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	1	1	0		0	0	0	0	0	0	0	1		POINT (-73.9716621112698 40.7742862219469)
2371	2371	-73.9769520212123	40.774006725862996	9A-AM-1013-01	09A	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9769520212123 40.774006725863)
2423	2423	-73.973552877209	40.7715638228207	7E-PM-1013-01	07E	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Ground & Tree Base	1	0	1	1	1		0	0	0	0	0	0	0	1		POINT (-73.973552877209 40.7715638228207)
2438	2438	-73.969532160039	40.7822616641357	20B-PM-1013-01	20B	PM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.969532160039 40.7822616641357)
2446	2446	-73.95227045119691	40.796566887896105	41G-AM-1013-01	41G	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9522704511969 40.7965668878961)
2479	2479	-73.9657958433575	40.7763496875058	15H-AM-1013-01	15H	AM	10132018	1	Adult	Gray	White	Gray+White		Above Ground	50		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9657958433575 40.7763496875058)
2585	2585	-73.9771726831497	40.7732320781799	8A-AM-1013-01	08A	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	trail	1	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9771726831497 40.7732320781799)
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)
2636	2636	-73.9700264128414	40.7692014637698	7I-PM-1013-01	07I	PM	10132018	1	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	Bench	0	0	0	1	0		0	0	0	0	0	1	0	0		POINT (-73.9700264128414 40.7692014637698)
2711	2711	-73.96288429601181	40.793804857240296	34A-PM-1013-01	34A	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1	took a chestnut	0	0	0	0	0	0	0	0		POINT (-73.9628842960118 40.7938048572403)
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)
2997	2997	-73.96197353854829	40.7944667974974	35A-PM-1013-01	35A	PM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9619735385483 40.7944667974974)

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