2018_Central_Park_Squirrel_Census_-_Squirrel_Data

53 rows where Above Ground Sighter Measurement = "FALSE", Foraging = 0, Hectare Squirrel Number = 4 and Indifferent = 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: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Specific Location, Running, Chasing, Climbing, Eating, Kuks, Tail flags, Tail twitches, Approaches, 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
218	218	-73.9712318712643	40.7773053099657	14D-PM-1019-04	14D	PM	10192018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9712318712643 40.7773053099657)
315	315	-73.95397347709341	40.7956055442	39G-PM-1013-04	39G	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9539734770934 40.7956055442)
338	338	-73.9765595553183	40.7748455340432	10A-PM-1014-04	10A	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9765595553183 40.7748455340432)
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)
493	493	-73.97768547979159	40.768310229566296	3D-AM-1006-04	03D	AM	10062018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	runs from (boy on bike)	POINT (-73.9776854797916 40.7683102295663)
511	511	-73.9653142636891	40.776001512929795	15I-AM-1008-04	15I	AM	10082018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	1	1	0		0	0	0	0	0	0	0	1		POINT (-73.9653142636891 40.7760015129298)
533	533	-73.9652584749758	40.7803011124382	19F-PM-1017-04	19F	PM	10172018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9652584749758 40.7803011124382)
618	618	-73.957976896139	40.797027128241	39C-AM-1017-04	39C	AM	10172018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.957976896139 40.797027128241005)
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)
631	631	-73.95488778301359	40.795015748910295	38F-AM-1018-04	38F	AM	10182018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.95488778301362 40.7950157489103)
654	654	-73.976769659152	40.7741908010484	9A-AM-1013-04	09A	AM	10132018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.976769659152 40.7741908010484)
709	709	-73.9519387881692	40.7936273636929	38I-PM-1014-04	38I	PM	10142018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9519387881692 40.7936273636929)
727	727	-73.9634563222926	40.780992836417	21G-PM-1007-04	21G	PM	10072018	4		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0	0	0	1		POINT (-73.9634563222926 40.780992836417)
824	824	-73.9606344681252	40.7958337780644	37B-PM-1013-04	37B	PM	10132018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9606344681252 40.795833778064406)
916	916	-73.95618876244708	40.7958187455815	38E-AM-1010-04	38E	AM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	1	0	0		0	0	0	1	0	0	0	1	me	POINT (-73.95618876244711 40.7958187455815)
932	932	-73.9718597156773	40.776585876331296	13C-PM-1019-04	13C	PM	10192018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9718597156773 40.7765858763313)
960	960	-73.9623922773932	40.7814944428327	22H-PM-1007-04	22H	PM	10072018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9623922773932 40.7814944428327)
1029	1029	-73.9601259189134	40.795535060905706	36B-PM-1013-04	36B	PM	10132018	4		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9601259189134 40.7955350609057)
1076	1076	-73.96279043284021	40.7939375305761	34A-PM-1013-04	34A	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	digging & burying	0	0	0	0	0	0	0	0		POINT (-73.9627904328402 40.7939375305761)
1176	1176	-73.9553263156025	40.79755920605721	40D-PM-1013-04	40D	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9553263156025 40.7975592060572)
1294	1294	-73.9604089940153	40.7910028063138	32D-AM-1013-04	32D	AM	10132018	4	Adult	Cinnamon		Cinnamon+	Brown legs	Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	1	0	1		POINT (-73.9604089940153 40.7910028063138)
1296	1296	-73.97055091705421	40.7689416540228	6I-PM-1013-04	06I	PM	10132018	4	Adult	Black	Gray	Black+Gray		Ground Plane	FALSE	Grass	0	0	0	1	0		0	0	0	0	1	0	0	0		POINT (-73.9705509170542 40.7689416540228)
1302	1302	-73.9704024529864	40.772925606388895	10G-AM-1006-04	10G	AM	10062018	4	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0	chasing (#3)	1	0	0	0	0	0	0	0		POINT (-73.9704024529864 40.7729256063889)
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)
1533	1533	-73.95200246546021	40.794732982815496	39I-PM-1013-04	39I	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Gray & Cinnamon selected as both Primary and Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	1	0	playing	0	0	0	0	0	1	0	0		POINT (-73.95200246546021 40.7947329828155)
1563	1563	-73.96762706709958	40.776391443152	15G-AM-1008-04	15G	AM	10082018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		1	0	0	0	0	0	0	0		POINT (-73.9676270670996 40.776391443152)
1636	1636	-73.97014086231209	40.7695511718541	7I-PM-1013-04	07I	PM	10132018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	Grass	1	0	0	1	0		0	0	0	1	0	0	0	0		POINT (-73.9701408623121 40.7695511718541)
1780	1780	-73.9640945609381	40.7910513041359	30A-PM-1020-04	30A	PM	10202018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Cinnamon back. Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE	Rock	1	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9640945609381 40.7910513041359)
1794	1794	-73.97579123504819	40.774759862145096	10B-AM-1006-04	10B	AM	10062018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9757912350482 40.7747598621451)
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)
1882	1882	-73.9541601469123	40.7907832744689	34I-PM-1010-04	34I	PM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE	across the lawn and climb up a small tree	1	0	1	0	0	grooming	0	0	0	0	0	0	0	0		POINT (-73.9541601469123 40.79078327446891)
2060	2060	-73.9575798004084	40.795701403548996	38D-PM-1006-04	38D	PM	10062018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	near drive -runners -cyclists	POINT (-73.95757980040841 40.795701403549)
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)
2101	2101	-73.957600085245	40.7936111607879	35E-PM-1006-04	35E	PM	10062018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.957600085245 40.7936111607879)
2113	2113	-73.95829048146521	40.790591574956395	32F-AM-1012-04	32F	AM	10122018	4	Adult	Black		Black+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9582904814652 40.7905915749564)
2162	2162	-73.9583300280173	40.7853495002675	27I-PM-1020-04	27I	PM	10202018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9583300280173 40.7853495002675)
2271	2271	-73.96739494580959	40.7826218539496	21D-AM-1008-04	21D	AM	10082018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9673949458096 40.78262185394961)
2279	2279	-73.9586085858962	40.7990326758282	40A-PM-1014-04	40A	PM	10142018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	runs from (ran from path to bushes)	POINT (-73.9586085858962 40.7990326758282)
2349	2349	-73.98003374000399	40.768360829233295	2B-PM-1013-04	02B	PM	10132018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.980033740004 40.7683608292333)
2475	2475	-73.9736489041867	40.7712143385426	7E-AM-1006-04	07E	AM	10062018	4	Adult	Gray		Gray+		Ground Plane	FALSE	under a tree	0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9736489041867 40.7712143385426)
2514	2514	-73.95744422055	40.7961046528557	38D-AM-1017-04	38D	AM	10172018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.95744422055 40.7961046528557)
2560	2560	-73.97554590905341	40.7680866624003	4E-AM-1020-04	04E	AM	10202018	4	Adult	Cinnamon	Black	Cinnamon+Black		Ground Plane	FALSE		0	0	0	0	0	chillin'	0	0	0	0	0	0	0	1		POINT (-73.9755459090534 40.7680866624003)
2575	2575	-73.97357533521291	40.7687061447032	5G-PM-1010-04	05G	PM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	1	0	0		POINT (-73.9735753352129 40.7687061447032)
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)
2756	2756	-73.9787312025627	40.7701071405918	4B-PM-1018-04	04B	PM	10182018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9787312025627 40.7701071405918)
2809	2809	-73.9686756254868	40.777745910265104	16E-AM-1014-04	16E	AM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9686756254868 40.7777459102651)
2821	2821	-73.97545365660129	40.769860491877104	5E-PM-1012-04	05E	PM	10122018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	0	1		POINT (-73.9754536566013 40.7698604918771)
2847	2847	-73.9568378330302	40.788031780276604	30I-PM-1006-04	30I	PM	10062018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9568378330302 40.7880317802766)
2878	2878	-73.969720780557	40.774110568875706	12F-AM-1020-04	12F	AM	10202018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	1	0	0	0		POINT (-73.969720780557 40.7741105688757)
2895	2895	-73.9747873899653	40.77319452583271	9C-PM-1006-04	09C	PM	10062018	4	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9747873899653 40.7731945258327)
2909	2909	-73.9564478909357	40.79769287754171	40C-PM-1006-04	40C	PM	10062018	4	Adult	Black		Black+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9564478909357 40.7976928775417)
2951	2951	-73.9742986032935	40.7770454318226	13A-PM-1014-04	13A	PM	10142018	4		Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9742986032935 40.7770454318226)
2971	2971	-73.9639801411692	40.7778921302618	18I-PM-1007-04	18I	PM	10072018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	0	walking sitting up	0	0	0	0	0	0	0	1		POINT (-73.9639801411692 40.7778921302618)

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