2018_Central_Park_Squirrel_Census_-_Squirrel_Data

59 rows where Foraging = 1, Indifferent = 0, Runs from = 0 and Tail twitches = 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, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Kuks, Quaas, Tail flags, 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
79	79	-73.9610705592868	40.7914829661051	32D-AM-1013-06	32D	AM	10132018	6	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		1	0	0	1	1	eating (a mushroom),circles around us,really fat,scratching himself,grooming activity	0	0	0	0	1	1	0	0		POINT (-73.9610705592868 40.7914829661051)
128	128	-73.97462290946429	40.7748467061969	10B-PM-1014-05	10B	PM	10142018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	0	0	avoided people	POINT (-73.9746229094643 40.7748467061969)
137	137	-73.97824171151392	40.77246650364471	7A-AM-1006-01	07A	AM	10062018	1	Adult	Gray	White	Gray+White		Above Ground	10	in tree	0	0	0	0	1		0	1	0	0	1	0	0	0	looked at us	POINT (-73.9782417115139 40.7724665036447)
157	157	-73.9637946878735	40.791570044687795	31A-AM-1010-04	31A	AM	10102018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9637946878735 40.7915700446878)
176	176	-73.9618064639153	40.792158440043	32C-PM-1013-12	32C	PM	10132018	12	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	1	0	0		POINT (-73.9618064639153 40.792158440043)
248	248	-73.9751729403694	40.774328412311796	10B-PM-1014-02	10B	PM	10142018	2	Adult	Gray	White	Gray+White		Above Ground		gingko tree by traffic light in front of Strawberry Fields	0	0	0	0	1		0	0	0	0	1	0	0	0	came over on tree to see me then disappeared	POINT (-73.9751729403694 40.7743284123118)
278	278	-73.9787796921165	40.7707526535381	5A-PM-1010-01	05A	PM	10102018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9787796921165 40.7707526535381)
310	310	-73.9795081274695	40.7691431548544	3B-PM-1007-03	03B	PM	10072018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9795081274695 40.7691431548544)
431	431	-73.97574360194321	40.774606436322706	10B-PM-1014-01	10B	PM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE	on lawn in front of a tree	0	0	0	0	1		0	0	0	0	1	0	0	0	stay on ground but went to other side of tree to hide from a dog	POINT (-73.9757436019432 40.7746064363227)
482	482	-73.97217978245759	40.7801213843628	16A-PM-1019-07	16A	PM	10192018	7	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	1	0	0	approaches (very friendly)	POINT (-73.9721797824576 40.7801213843628)
537	537	-73.9682803241007	40.772451055832704	11H-AM-1010-04	11H	AM	10102018	4		Gray	White	Gray+White					0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9682803241007 40.7724510558327)
589	589	-73.97826438139	40.7717086090782	6A-AM-1006-04	06A	AM	10062018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	1		0	0	0	0	1	0	0	0	curious	POINT (-73.97826438139 40.7717086090782)
607	607	-73.9547711796823	40.7908540751983	34I-PM-1010-06	34I	PM	10102018	6	Adult	Gray		Gray+					0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9547711796823 40.7908540751983)
740	740	-73.95834778506341	40.7914073632782	33F-PM-1012-06	33F	PM	10122018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	1	1		1	0	0	0	1	0	0	0		POINT (-73.9583477850634 40.7914073632782)
868	868	-73.9738481771673	40.7706540698938	7E-PM-1013-04	07E	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	1	0	0	0		POINT (-73.9738481771673 40.7706540698938)
905	905	-73.9757216124349	40.7754310239649	11A-PM-1013-05	11A	PM	10132018	5	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	1	digging	0	0	0	0	1	0	0	0		POINT (-73.9757216124349 40.7754310239649)
982	982	-73.9676424599715	40.777776610680704	16F-AM-1008-01	16F	AM	10082018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE	near fence	0	0	0	0	1		0	0	0	0	1	1	0	0		POINT (-73.9676424599715 40.7777766106807)
1000	1000	-73.9805137046778	40.769275143797	2A-AM-1010-08	02A	AM	10102018	8	Adult	Gray		Gray+	Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9805137046778 40.769275143797)
1043	1043	-73.9758564394842	40.7674758942811	3E-AM-1006-05	03E	AM	10062018	5	Juvenile	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9758564394842 40.7674758942811)
1057	1057	-73.9594406225891	40.7918533707789	33D-AM-1017-02	33D	AM	10172018	2	Adult	Black	Cinnamon	Black+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	1	0	0		POINT (-73.9594406225891 40.7918533707789)
1160	1160	-73.97772569893621	40.766623699564	1E-AM-1006-03	01E	AM	10062018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9777256989362 40.766623699564)
1214	1214	-73.9699517492486	40.7753169595373	13F-PM-1008-01	13F	PM	10082018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	1	0	0		POINT (-73.9699517492486 40.7753169595373)
1237	1237	-73.9705370795538	40.7761725434851	13E-PM-1008-04	13E	PM	10082018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Gray & Cinnamon selected as Primary. Gray selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0	he took 2 steps then turned and stared at me	POINT (-73.9705370795538 40.7761725434851)
1241	1241	-73.9651817987035	40.781908283833396	21E-AM-1017-01	21E	AM	10172018	1	Adult	Gray	White	Gray+White		Above Ground	3	Climbs small tree	0	0	0	1	1		0	0	0	0	1	0	0	0	walks from	POINT (-73.9651817987035 40.7819082838334)
1352	1352	-73.9616770335086	40.792164863109605	32C-PM-1013-13	32C	PM	10132018	13	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1	buried nut	0	0	0	0	1	0	0	0		POINT (-73.9616770335086 40.7921648631096)
1366	1366	-73.97115821991021	40.7783674409485	15C-PM-1017-05	15C	PM	10172018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		1	0	0	0	1	1	0	0		POINT (-73.9711582199102 40.7783674409485)
1549	1549	-73.97779784978941	40.7668620784309	1D-AM-1006-01	01D	AM	10062018	1	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	0	1	0	1		0	0	0	0	1	0	0	0		POINT (-73.9777978497894 40.7668620784309)
1593	1593	-73.9676539688726	40.7777229934129	16F-AM-1008-02	16F	AM	10082018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	near fence	0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9676539688726 40.7777229934129)
1614	1614	-73.9806718258385	40.7692776896995	2A-AM-1010-07	02A	AM	10102018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	0	0	couldn't get near	POINT (-73.9806718258385 40.76927768969951)
1704	1704	-73.9624052832372	40.7809656348254	21H-PM-1018-04	21H	PM	10182018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	1	0	0		POINT (-73.9624052832372 40.7809656348254)
1725	1725	-73.96574800660741	40.7753465489231	14I-PM-1018-04	14I	PM	10182018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	1	0	0		POINT (-73.9657480066074 40.7753465489231)
1795	1795	-73.968004352343	40.7726669278308	11I-PM-1012-01	11I	PM	10122018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	1		0	0	0	1	1	0	0	0	look at humans determining	POINT (-73.968004352343 40.7726669278308)
1808	1808	-73.9698870647042	40.7826510985538	20B-AM-1007-02	20B	AM	10072018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	1	1	0	0		POINT (-73.9698870647042 40.7826510985538)
2037	2037	-73.96833704175509	40.781359835050004	19D-AM-1007-02	19D	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2		0	0	1	0	1		0	0	0	0	1	0	0	0	fenced area	POINT (-73.9683370417551 40.78135983505)
2066	2066	-73.9784610031588	40.7668839966177	1D-AM-1006-07	01D	AM	10062018	7	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	0	0		POINT (-73.9784610031588 40.7668839966177)
2088	2088	-73.96511558803459	40.790694632578	30A-PM-1020-01	30A	PM	10202018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9651155880346 40.790694632578)
2124	2124	-73.97300395815209	40.7730688398468	9E-PM-1014-03	09E	PM	10142018	3	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE	underneath a tree	0	0	0	1	1		0	0	0	0	1	0	0	0		POINT (-73.9730039581521 40.7730688398468)
2133	2133	-73.9736164871197	40.7725695048569	8D-PM-1007-04	08D	PM	10072018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9736164871197 40.7725695048569)
2147	2147	-73.9651217998407	40.7761115392738	15I-PM-1012-01	15I	PM	10122018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	1	0	0	0		POINT (-73.9651217998407 40.7761115392738)
2156	2156	-73.96503878480009	40.7814134438394	21F-AM-1018-04	21F	AM	10182018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9650387848001 40.7814134438394)
2216	2216	-73.97351950184459	40.778714727971504	14A-AM-1014-02	14A	AM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	1	0	0	0		POINT (-73.9735195018446 40.7787147279715)
2273	2273	-73.9671534029191	40.7810849804467	20D-AM-1007-02	20D	AM	10072018	2	Adult	Gray		Gray+	too far to note 30'	Ground Plane	FALSE		0	0	0	0	1	quieter	0	0	0	0	1	0	0	0		POINT (-73.9671534029191 40.7810849804467)
2275	2275	-73.96142184133559	40.793894505879294	34B-AM-1013-01	34B	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1	hopping	0	0	0	0	1	1	0	0		POINT (-73.9614218413356 40.7938945058793)
2312	2312	-73.97658670292259	40.7674304266107	2E-PM-1014-01	02E	PM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	1	0	0		POINT (-73.9765867029226 40.7674304266107)
2326	2326	-73.9691692160865	40.7725330502929	10H-PM-1007-02	10H	PM	10072018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9691692160865 40.7725330502929)
2343	2343	-73.9719194877439	40.774800096290896	11D-AM-1010-04	11D	AM	10102018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	0	0		POINT (-73.9719194877439 40.7748000962909)
2358	2358	-73.9788379085607	40.7683896583055	2C-PM-1013-06	02C	PM	10132018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1	cleaning face & tail	0	0	0	0	1	1	0	0		POINT (-73.9788379085607 40.7683896583055)
2511	2511	-73.95845615374209	40.791121116475395	33F-PM-1012-02	33F	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	1	0	0	0		POINT (-73.9584561537421 40.7911211164754)
2515	2515	-73.9693338657183	40.775705588453796	13F-PM-1008-05	13F	PM	10082018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2	tree trunk	1	0	0	1	1		1	0	0	0	1	0	0	0		POINT (-73.9693338657183 40.77570558845381)
2529	2529	-73.98002714878629	40.7702554167042	4A-PM-1007-06	04A	PM	10072018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE	A rock	0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9800271487863 40.7702554167042)
2532	2532	-73.9695150319891	40.782613519363	20B-PM-1013-04	20B	PM	10132018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1	chased a bird carrying massive wad of grass	0	0	0	0	1	0	0	0		POINT (-73.9695150319891 40.782613519363)
2587	2587	-73.97899712868441	40.7707024146365	5A-PM-1010-04	05A	PM	10102018	4	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	0	0		POINT (-73.9789971286844 40.7707024146365)
2610	2610	-73.9713379914423	40.7696367609606	7H-PM-1006-01	07H	PM	10062018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	middle of grass	0	0	0	1	1		0	0	0	0	1	1	0	0		POINT (-73.9713379914423 40.7696367609606)
2655	2655	-73.9659156108069	40.781070981869604	20E-AM-1014-01	20E	AM	10142018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	1	0	0	0		POINT (-73.9659156108069 40.7810709818696)
2875	2875	-73.95466167829221	40.790974533738996	34I-PM-1010-05	34I	PM	10102018	5	Adult	Gray		Gray+					0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9546616782922 40.790974533739)
2884	2884	-73.9598378495787	40.7956843021662	37B-AM-1018-04	37B	AM	10182018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9598378495787 40.7956843021662)
2900	2900	-73.9631005470369	40.788549405719294	28D-AM-1012-01	28D	AM	10122018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9631005470369 40.7885494057193)
2989	2989	-73.9643538221947	40.7917565604735	31A-PM-1017-01	31A	PM	10172018	1	Juvenile	Cinnamon	Gray, White	Cinnamon+Gray, White	Gray lower back, Gray & Cinnamon selected as Primary with "lower back" written in next to Gray. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9643538221947 40.7917565604735)
3015	3015	-73.97591633005351	40.7736180793606	9B-AM-1010-08	09B	AM	10102018	8	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Cinnamon head, White (Almost Silver)	Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	0	0		POINT (-73.9759163300535 40.7736180793606)

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