2018_Central_Park_Squirrel_Census_-_Squirrel_Data

28 rows where Climbing = 0, Location = "Above Ground", 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: Hectare, Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Running, Chasing, Eating, Foraging, Kuks, Quaas, Tail flags, 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
100	100	-73.9761592532482	40.774721358538706	10A-AM-1006-04	10A	AM	10062018	4	Juvenile	Gray		Gray+		Above Ground	10	tree near large rock on Bridle Path	0	0	0	0	0	walking on branch	0	0	0	0	1	0	0	0		POINT (-73.9761592532482 40.7747213585387)
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)
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)
335	335	-73.97823514358521	40.7715896672335	6A-AM-1006-03	06A	AM	10062018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	30	tree	0	1	0	1	0		0	0	0	1	1	0	0	0		POINT (-73.9782351435852 40.7715896672335)
360	360	-73.9672054610151	40.7876519923501	26A-PM-1006-05	26A	PM	10062018	5	Adult	Gray		Gray+		Above Ground	40		0	1	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.9672054610151 40.7876519923501)
387	387	-73.9578316525492	40.789010295962896	31G-PM-1007-01	31G	PM	10072018	1	Adult	Gray		Gray+		Above Ground	15		0	0	0	0	0	hiding	0	0	0	0	1	0	0	0	froze,sight of dogs	POINT (-73.9578316525492 40.7890102959629)
670	670	-73.9602398690946	40.7910157676119	32D-PM-1006-04	32D	PM	10062018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	40		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9602398690946 40.7910157676119)
702	702	-73.963858549251	40.7808999610914	21G-AM-1014-03	21G	AM	10142018	3	Adult	Gray	White	Gray+White		Above Ground	7		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.963858549251 40.7808999610914)
728	728	-73.96029131055779	40.7910635810038	32D-PM-1006-03	32D	PM	10062018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	40		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9602913105578 40.7910635810038)
1138	1138	-73.9594357049738	40.7840678890949	25I-AM-1012-01	25I	AM	10122018	1	Adult	Cinnamon		Cinnamon+		Above Ground	4	on bar	0	0	0	1	0		0	0	0	1	1	1	0	0		POINT (-73.9594357049738 40.7840678890949)
1235	1235	-73.9679686793869	40.7825993867876	21C-AM-1014-01	21C	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	3		1	0	0	0	0	jumping back & forth on tree	0	0	0	1	1	0	1	0		POINT (-73.9679686793869 40.7825993867876)
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)
1333	1333	-73.9754527701832	40.7656088463928	1G-PM-1010-02	01G	PM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	0	0	0	laying on tree branch	0	0	0	1	1	0	0	0		POINT (-73.9754527701832 40.7656088463928)
1396	1396	-73.9704677007779	40.7786860108302	16C-PM-1018-02	16C	PM	10182018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	6		0	1	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9704677007779 40.7786860108302)
1686	1686	-73.9593373093799	40.7982428507976	39A-PM-1014-03	39A	PM	10142018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Higlights. Made executive adjustments.	Above Ground	6	Jumped from ground onto branch	0	0	0	0	1	digging?	0	0	0	0	1	0	1	0		POINT (-73.95933730937992 40.7982428507976)
1688	1688	-73.9677593344667	40.7763054313195	15G-PM-1019-07	15G	PM	10192018	7	Adult			+		Above Ground	5		0	1	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.9677593344667 40.7763054313195)
1799	1799	-73.978844141973	40.7696046074378	4B-AM-1010-05	04B	AM	10102018	5	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10		0	1	0	0	0	chasing squirrel #6	1	1	0	0	1	0	0	0		POINT (-73.978844141973 40.7696046074378)
1867	1867	-73.9745204169071	40.7736282868469	9C-AM-1006-01	09C	AM	10062018	1	Adult	Gray		Gray+		Above Ground	40	Tree	1	0	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.9745204169071 40.7736282868469)
2205	2205	-73.9594986107981	40.7840083040604	25I-AM-1012-03	25I	AM	10122018	3	Adult	Cinnamon		Cinnamon+		Above Ground	8	on turn, see map	1	1	0	1	0		0	0	0	0	1	1	0	0		POINT (-73.9594986107981 40.7840083040604)
2213	2213	-73.9707487237344	40.7800822831001	17B-PM-1012-03	17B	PM	10122018	3	Adult	Gray	White	Gray+White		Above Ground	10		1	1	0	0	0	2/3 chasing each other	0	0	0	0	1	0	1	0		POINT (-73.9707487237344 40.7800822831001)
2247	2247	-73.95595201371721	40.7950536287174	38E-AM-1010-06	38E	AM	10102018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1	branches	1	1	0	0	0	chasing and being chased by #7	0	0	0	0	1	0	1	0		POINT (-73.95595201371721 40.7950536287174)
2387	2387	-73.98085173247209	40.7683154647217	1A-PM-1014-01	01A	PM	10142018	1	Adult	Cinnamon	White	Cinnamon+White		Above Ground	6		0	1	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.9808517324721 40.7683154647217)
2433	2433	-73.9706949930717	40.772362045852	10G-AM-1006-08	10G	AM	10062018	8	Adult	Black	Cinnamon	Black+Cinnamon		Above Ground	3		0	0	0	1	0		0	0	0	1	1	0	1	0		POINT (-73.9706949930717 40.772362045852)
2487	2487	-73.9595222999173	40.7833202577782	25I-AM-1012-02	25I	AM	10122018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	31	on tree	1	1	0	0	0		0	0	0	1	1	0	1	0		POINT (-73.9595222999173 40.7833202577782)
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)
2683	2683	-73.972179947936	40.7810042827198	17A-PM-1013-02	17A	PM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20	on a little pedestal-shaped part of a tree	0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.972179947936 40.7810042827198)
2708	2708	-73.9528429238071	40.7922651848867	36I-PM-1007-09	36I	PM	10072018	9	Juvenile	Gray		Gray+		Above Ground	5		1	1	0	0	0	burying nut	0	0	0	0	1	0	0	0		POINT (-73.9528429238071 40.7922651848867)
2839	2839	-73.9672252136807	40.787650474321204	26A-PM-1006-04	26A	PM	10062018	4	Adult	Gray		Gray+		Above Ground	40		0	1	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.9672252136807 40.7876504743212)

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