2018_Central_Park_Squirrel_Census_-_Squirrel_Data

57 rows where Foraging = 0, Highlight Fur Color = "White", Primary Fur Color = "Gray" 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

- 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, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent

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
45	45	-73.9579645940414	40.7918613498407	34F-AM-1007-01	34F	AM	10072018	1	Adult	Gray	White	Gray+White		Above Ground	25		1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9579645940414 40.7918613498407)
80	80	-73.9688454483585	40.78453012881629	22A-AM-1008-05	22A	AM	10082018	5	Adult	Gray	White	Gray+White		Above Ground	3	trash can	0	0	0	1	0		0	0	0	1	0	0	0	1		POINT (-73.9688454483585 40.7845301288163)
102	102	-73.95759861613641	40.799368134968	41B-PM-1014-01	41B	PM	10142018	1	Adult	Gray	White	Gray+White		Above Ground	25	Climbing tree	0	0	1	0	0	climbing (tree)	0	0	0	0	0	0	0	1		POINT (-73.9575986161364 40.799368134968)
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)
258	258	-73.9534333425633	40.793256416332795	37H-AM-1018-03	37H	AM	10182018	3	Adult	Gray	White	Gray+White		Above Ground	10	in a tree with red berries	0	0	0	1	0		0	1	0	0	0	0	0	1		POINT (-73.9534333425633 40.7932564163328)
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)
331	331	-73.95448101115	40.7954469678857	39F-PM-1006-03	39F	PM	10062018	3	Adult	Gray	White	Gray+White		Above Ground	15	lower branch of tree	0	0	0	1	0		0	0	0	0	0	0	0	1	ran up tree when approached	POINT (-73.95448101115 40.7954469678857)
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)
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)
602	602	-73.96857515954851	40.7709413567859	9I-PM-1010-07	09I	PM	10102018	7	Adult	Gray	White	Gray+White		Above Ground	1	ran up tree	1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9685751595485 40.7709413567859)
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)
865	865	-73.9741621946917	40.775248147202504	11C-PM-1018-01	11C	PM	10182018	1	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9741621946917 40.7752481472025)
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)
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)
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)
1049	1049	-73.9564606426367	40.788054657260794	30I-PM-1006-06	30I	PM	10062018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	1	ran up tree	POINT (-73.9564606426367 40.7880546572608)
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)
1080	1080	-73.96902119353459	40.773038298158	11H-AM-1010-07	11H	AM	10102018	7	Adult	Gray	White	Gray+White		Above Ground	4		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9690211935346 40.773038298158)
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)
1268	1268	-73.96239842629359	40.7913900453449	31C-PM-1010-03	31C	PM	10102018	3	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9623984262936 40.7913900453449)
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)
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)
1328	1328	-73.9765758043111	40.771380315403206	6C-AM-1007-03	06C	AM	10072018	3	Adult	Gray	White	Gray+White		Above Ground	8	another tree	1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9765758043111 40.7713803154032)
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)
1381	1381	-73.9586077039567	40.796189647707706	38C-AM-1019-10	38C	AM	10192018	10	Adult	Gray	White	Gray+White		Above Ground	20		1	0	1	1	0		1	0	0	0	1	0	0	1		POINT (-73.9586077039567 40.7961896477077)
1395	1395	-73.9710801547498	40.7760872452093	13D-AM-1014-03	13D	AM	10142018	3	Juvenile	Gray	White	Gray+White		Above Ground	2		0	1	1	1	0		0	0	0	0	0	0	0	1		POINT (-73.9710801547498 40.7760872452093)
1410	1410	-73.95879132892291	40.7961707624534	38C-AM-1019-11	38C	AM	10192018	11	Adult	Gray	White	Gray+White		Above Ground	20		1	0	1	1	0		1	0	0	0	1	0	0	1		POINT (-73.9587913289229 40.7961707624534)
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)
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)
1489	1489	-73.9501762527462	40.797553408607705	42H-PM-1014-05	42H	PM	10142018	5	Adult	Gray	White	Gray+White		Above Ground	15		1	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9501762527462 40.7975534086077)
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)
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)
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)
1825	1825	-73.9624209799704	40.79102009727521	31C-PM-1010-01	31C	PM	10102018	1	Adult	Gray	White	Gray+White		Above Ground	3		0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9624209799704 40.7910200972752)
1999	1999	-73.95498609472341	40.79115503283089	34H-PM-1006-07	34H	PM	10062018	7	Juvenile	Gray	White	Gray+White	white belly	Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9549860947234 40.7911550328309)
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)
2390	2390	-73.9680741975294	40.7847036778165	23B-PM-1012-04	23B	PM	10122018	4	Adult	Gray	White	Gray+White		Above Ground	20		0	0	0	0	0	watching me - didn't move	0	0	0	0	1	0	0	1		POINT (-73.9680741975294 40.7847036778165)
2397	2397	-73.9704592500888	40.772962887933005	10G-AM-1006-03	10G	AM	10062018	3	Juvenile	Gray	White	Gray+White	tuft on butt	Above Ground	10		0	0	1	0	0		0	0	0	1	0	0	0	1		POINT (-73.9704592500888 40.772962887933)
2406	2406	-73.9668964315686	40.777757799088604	16G-AM-1010-01	16G	AM	10102018	1	Adult	Gray	White	Gray+White		Above Ground	3		0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9668964315686 40.7777577990886)
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)
2767	2767	-73.9751806727197	40.7671940332258	3F-PM-1013-05	03F	PM	10132018	5	Adult	Gray	White	Gray+White		Above Ground	13		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.97518067271972 40.7671940332258)
2811	2811	-73.97568897660891	40.7676078308589	3F-AM-1006-14	03F	AM	10062018	14	Adult	Gray	White	Gray+White		Above Ground	12		1	0	1	0	0	running from dog	0	0	0	0	0	0	0	1		POINT (-73.9756889766089 40.7676078308589)
2815	2815	-73.97473113123941	40.76773197250439	3F-PM-1013-06	03F	PM	10132018	6	Adult	Gray	White	Gray+White		Above Ground	19		0	0	1	0	0		0	1	0	0	0	0	0	1		POINT (-73.97473113123941 40.7677319725044)

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