2018_Central_Park_Squirrel_Census_-_Squirrel_Data

37 rows where Above Ground Sighter Measurement = "FALSE", Foraging = 0, Highlight Fur Color = "White", Indifferent = 0 and Runs from = 1

- 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

- 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, Running, Chasing, Climbing, Eating, Kuks, 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
27	27	-73.9670628558161	40.7734991420941	12I-AM-1013-01	12I	AM	10132018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	on tree roots	0	0	0	0	0	sitting	0	0	0	0	1	0	0	1		POINT (-73.9670628558161 40.77349914209411)
170	170	-73.95972059663241	40.7969409510133	38B-AM-1019-01	38B	AM	10192018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9597205966324 40.7969409510133)
277	277	-73.96190702296741	40.795255669250004	35A-AM-1014-05	35A	AM	10142018	5	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9619070229674 40.79525566925)
365	365	-73.9576035072364	40.7966120824816	38C-AM-1019-01	38C	AM	10192018	1	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	runs from (lawnmower)	POINT (-73.9576035072364 40.7966120824816)
386	386	-73.95503513809571	40.7974681522214	40E-AM-1014-01	40E	AM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9550351380957 40.7974681522214)
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)
464	464	-73.96644503991209	40.788784490469496	27A-AM-1008-02	27A	AM	10082018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9664450399121 40.7887844904695)
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)
627	627	-73.97637911214379	40.770281512254	5D-PM-1018-04	05D	PM	10182018	4	Adult	Gray	White	Gray+White	Partial missing tail	Ground Plane	FALSE		0	1	0	0	0	chasing (dog chasing)	0	0	0	0	0	0	0	1		POINT (-73.9763791121438 40.770281512254)
643	643	-73.976730206737	40.773709213913996	8A-PM-1014-01	08A	PM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	1	0		1	0	0	0	0	0	0	1	runs from (goes up a tree)	POINT (-73.976730206737 40.773709213914)
732	732	-73.9695041366722	40.779787880948206	17D-AM-1008-02	17D	AM	10082018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9695041366722 40.7797878809482)
841	841	-73.97469338525721	40.773313866931	9C-PM-1006-05	09C	PM	10062018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1	w/ dog	POINT (-73.9746933852572 40.773313866931)
855	855	-73.9808247660048	40.76894088312871	2A-PM-1019-01	02A	PM	10192018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0	runs from	0	0	0	1	0	0	0	1		POINT (-73.9808247660048 40.7689408831287)
859	859	-73.9600964585868	40.7952339524416	36B-PM-1013-02	36B	PM	10132018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	1	1	0	1		POINT (-73.9600964585868 40.7952339524416)
902	902	-73.969105907	40.782047490919204	20B-PM-1013-08	20B	PM	10132018	8	Adult	Gray	White	Gray+White	(very brown)	Ground Plane	FALSE		1	0	0	0	0	being chased by dog	0	0	0	0	0	0	0	1		POINT (-73.969105907 40.7820474909192)
940	940	-73.9700879096644	40.7765899724756	14E-PM-1017-05	14E	PM	10172018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9700879096644 40.7765899724756)
1019	1019	-73.97042696309641	40.7722964640257	10G-AM-1006-09	10G	AM	10062018	9	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	0	1		POINT (-73.9704269630964 40.7722964640257)
1054	1054	-73.9570050460867	40.7985192250745	40C-AM-1017-05	40C	AM	10172018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9570050460867 40.7985192250745)
1075	1075	-73.9640534906634	40.777738389983604	17I-AM-1014-02	17I	AM	10142018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0	standing upright	0	0	0	0	0	1	0	1	runs from (only ran away when a grandpa chased it off)	POINT (-73.9640534906634 40.7777383899836)
1231	1231	-73.9555583724966	40.7932879745739	36F-PM-1012-07	36F	PM	10122018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9555583724966 40.7932879745739)
1290	1290	-73.96681408040659	40.77681001473329	15G-AM-1008-06	15G	AM	10082018	6	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9668140804066 40.7768100147333)
1305	1305	-73.9569324958684	40.7877748374259	30I-PM-1006-01	30I	PM	10062018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0	sitting there	0	0	0	0	0	0	0	1		POINT (-73.9569324958684 40.78777483742591)
1356	1356	-73.9534910562766	40.7935774443789	37H-AM-1018-04	37H	AM	10182018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	0	1	was with a lot of robins	POINT (-73.9534910562766 40.7935774443789)
1461	1461	-73.95692690934399	40.7965323262487	39D-PM-1012-03	39D	PM	10122018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.956926909344 40.7965323262487)
1465	1465	-73.9720289863666	40.7763749561607	13C-PM-1019-03	13C	PM	10192018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.97202898636661 40.7763749561607)
1534	1534	-73.9695226023739	40.7797527775804	17D-AM-1008-01	17D	AM	10082018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9695226023739 40.7797527775804)
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)
1758	1758	-73.9581241870185	40.7961057536141	38C-AM-1019-05	38C	AM	10192018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9581241870185 40.7961057536141)
1803	1803	-73.9588076804698	40.7912942607296	33E-AM-1014-06	33E	AM	10142018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9588076804698 40.7912942607296)
1814	1814	-73.97223594012421	40.7702891474555	7G-AM-1010-07	07G	AM	10102018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9722359401242 40.7702891474555)
2051	2051	-73.9544808708211	40.7906575852286	34I-AM-1012-02	34I	AM	10122018	2	Adult	Gray	White	Gray+White	Short tail	Ground Plane	FALSE		0	0	0	0	0	hiding	0	0	0	0	0	0	0	1		POINT (-73.9544808708211 40.7906575852286)
2094	2094	-73.9701630539326	40.7779553961101	15D-AM-1007-04	15D	AM	10072018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.97016305393261 40.7779553961101)
2519	2519	-73.9589475065438	40.7934846881536	35D-PM-1013-06	35D	PM	10132018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9589475065438 40.7934846881536)
2618	2618	-73.95795157569	40.7961254697958	38C-PM-1014-04	38C	PM	10142018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	1	0		0	0	0	1	0	0	0	1		POINT (-73.95795157569 40.7961254697958)
2620	2620	-73.97718000981308	40.7708863131336	5C-PM-1010-03	05C	PM	10102018	3	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9771800098131 40.7708863131336)
2794	2794	-73.9712187890707	40.7750640173134	12E-PM-1018-01	12E	PM	10182018	1	Juvenile	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	1	0	0		1	0	0	1	0	0	0	1		POINT (-73.9712187890707 40.7750640173134)
2886	2886	-73.9729265300533	40.774176829164205	10D-AM-1008-02	10D	AM	10082018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9729265300533 40.7741768291642)

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