2018_Central_Park_Squirrel_Census_-_Squirrel_Data

28 rows where Date = 10072018, Foraging = 0, Highlight Fur Color = "White" and Running = 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: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Eating, Kuks, 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
115	115	-73.9530040923555	40.7922896176936	36I-PM-1007-10	36I	PM	10072018	10	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0	stole (found?) an entire sandwich	0	0	0	0	0	0	1	0		POINT (-73.9530040923555 40.7922896176936)
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)
269	269	-73.9591400366159	40.7891708599318	31F-PM-1007-01	31F	PM	10072018	1	Adult	Gray	White	Gray+White	white neck and belly	Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9591400366159 40.7891708599318)
354	354	-73.95667510223359	40.799035789744	41C-PM-1007-04	41C	PM	10072018	4	Adult	Gray	White	Gray+White		Above Ground	65		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9566751022336 40.799035789744)
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)
407	407	-73.9787658435198	40.768941976539296	3B-PM-1007-07	03B	PM	10072018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0	eating loudly <- peanuts w/ shells	0	0	0	0	0	0	1	0		POINT (-73.9787658435198 40.7689419765393)
421	421	-73.9664630067791	40.775636151582496	14H-AM-1007-04	14H	AM	10072018	4	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9664630067791 40.7756361515825)
440	440	-73.9642717435966	40.782087049693	22F-AM-1007-05	22F	AM	10072018	5	Adult	Gray	White	Gray+White		Above Ground	10	tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9642717435966 40.782087049693)
574	574	-73.97063600052749	40.7717074044466	9G-PM-1007-05	09G	PM	10072018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9706360005275 40.7717074044466)
575	575	-73.9783366903829	40.7668300056094	1D-PM-1007-03	01D	PM	10072018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9783366903829 40.7668300056094)
741	741	-73.9790214253443	40.7686791169776	3B-PM-1007-10	03B	PM	10072018	10	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0	hopping	0	0	0	0	0	0	1	0		POINT (-73.9790214253443 40.7686791169776)
781	781	-73.955516031113	40.7923188156277	35G-AM-1007-01	35G	AM	10072018	1	Adult	Gray	White	Gray+White		Above Ground	15		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.955516031113 40.7923188156277)
996	996	-73.9703149829421	40.778558363032296	16D-AM-1007-01	16D	AM	10072018	1	Adult	Gray	White	Gray+White		Above Ground	3		0	0	1	1	0		0	0	0	0	0	0	0	1		POINT (-73.9703149829421 40.7785583630323)
1324	1324	-73.954554245377	40.7983935730557	41E-AM-1007-05	41E	AM	10072018	5	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	1	man/pit bull mix wandered	POINT (-73.954554245377 40.7983935730557)
1342	1342	-73.96620636423451	40.789077866530704	28A-PM-1007-04	28A	PM	10072018	4	Adult	Gray	White	Gray+White					0	0	0	0	0	looking at me & #5	1	0	0	0	1	0	0	0	freezes	POINT (-73.9662063642345 40.7890778665307)
1413	1413	-73.98100322064279	40.768162563497896	1A-AM-1007-01	01A	AM	10072018	1	Adult	Gray	White	Gray+White		Above Ground	7		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9810032206428 40.7681625634979)
1466	1466	-73.96511776576759	40.7812408103825	20F-PM-1007-05	20F	PM	10072018	5	Juvenile	Gray	White	Gray+White	white tail	Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9651177657676 40.781240810382506)
1500	1500	-73.9769969548024	40.7710711265211	6C-AM-1007-01	06C	AM	10072018	1	Adult	Gray	White	Gray+White	vid!	Above Ground	15		0	0	1	0	0		0	0	0	0	1	0	0	0	curious,but wary	POINT (-73.97699695480242 40.7710711265211)
1727	1727	-73.96924722995651	40.7722592187215	10H-PM-1007-01	10H	PM	10072018	1	Adult	Gray	White	Gray+White	dark gray	Above Ground	15	in tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9692472299565 40.7722592187215)
1804	1804	-73.98077710643099	40.7681635726316	1A-AM-1007-02	01A	AM	10072018	2	Adult	Gray	White	Gray+White		Above Ground	11		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.980777106431 40.7681635726316)
1826	1826	-73.9707542189896	40.7717032986885	9G-PM-1007-04	09G	PM	10072018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9707542189896 40.77170329868851)
1929	1929	-73.9646023053207	40.7810680044024	20F-PM-1007-14	20F	PM	10072018	14	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9646023053207 40.78106800440241)
1972	1972	-73.9558370309765	40.7921977208472	35G-AM-1007-02	35G	AM	10072018	2	Adult	Gray	White	Gray+White		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9558370309765 40.7921977208472)
2081	2081	-73.96757180595391	40.7786049141486	17F-AM-1007-06	17F	AM	10072018	6	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	8		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9675718059539 40.7786049141486)
2123	2123	-73.959874668294	40.7907004233491	32E-AM-1007-09	32E	AM	10072018	9	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	1	0	0		POINT (-73.959874668294 40.7907004233491)
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)
2730	2730	-73.96535757586871	40.78053399533721	20F-PM-1007-12	20F	PM	10072018	12	Adult	Gray	White	Gray+White		Above Ground	20	in tree	0	0	1	1	0		0	0	0	0	0	0	0	0		POINT (-73.9653575758687 40.7805339953372)
2868	2868	-73.9653873284496	40.7804699882574	20F-PM-1007-11	20F	PM	10072018	11	Adult	Gray	White	Gray+White		Above Ground	10	in tree	0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9653873284496 40.7804699882574)

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