2018_Central_Park_Squirrel_Census_-_Squirrel_Data

51 rows where Date = 10132018, Indifferent = 1 and Shift = "AM"

- 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, 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, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, 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
147	147	-73.9564023626619	40.7905423546155	33G-AM-1013-02	33G	AM	10132018	2	Adult	Gray		Gray+		Above Ground	13	shelter in hole in tree	0	0	1	0	0		0	0	0	0	0	0	1	1		POINT (-73.9564023626619 40.7905423546155)
228	228	-73.97286607796221	40.7753294525644	12C-AM-1013-03	12C	AM	10132018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1	burying	0	0	0	0	0	0	1	0		POINT (-73.9728660779622 40.7753294525644)
261	261	-73.9552861155228	40.788973931872	32I-AM-1013-05	32I	AM	10132018	5	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	3	In and below shrub	0	0	1	0	1		0	0	0	1	0	0	1	0		POINT (-73.9552861155228 40.788973931872)
308	308	-73.9554095823557	40.788730580204394	32I-AM-1013-01	32I	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9554095823557 40.7887305802044)
323	323	-73.9573469787503	40.7944044592573	36E-AM-1013-03	36E	AM	10132018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0	indifferent (moving very fast)	POINT (-73.9573469787503 40.7944044592573)
346	346	-73.9712971568288	40.7745520717065	11E-AM-1013-02	11E	AM	10132018	2	Adult	Gray	Black	Gray+Black		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9712971568288 40.7745520717065)
452	452	-73.960300330029	40.795347587186896	36B-AM-1013-03	36B	AM	10132018	3		Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.960300330029 40.7953475871869)
481	481	-73.9714303315699	40.774593494770606	11E-AM-1013-04	11E	AM	10132018	4	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1	burying	0	0	0	0	0	0	1	0		POINT (-73.9714303315699 40.7745934947706)
582	582	-73.9677779408464	40.78674822113489	25A-AM-1013-02	25A	AM	10132018	2		Gray		Gray+		Above Ground	15	BIG TREE	0	1	0	0	0	chasing #3	0	0	0	1	0	0	1	0		POINT (-73.9677779408464 40.7867482211349)
596	596	-73.9769319450348	40.7743883576247	9A-AM-1013-11	09A	AM	10132018	11	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	foot of tree	1	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9769319450348 40.7743883576247)
603	603	-73.9721592378418	40.776034583573	12C-AM-1013-02	12C	AM	10132018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		1	0	0	0	0	0	1	0		POINT (-73.9721592378418 40.776034583573)
662	662	-73.9721854790038	40.776108635243794	12C-AM-1013-01	12C	AM	10132018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1	burying	0	0	0	0	0	0	1	0		POINT (-73.9721854790038 40.7761086352438)
681	681	-73.9552880892701	40.7889040503316	32I-AM-1013-04	32I	AM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9552880892701 40.7889040503316)
783	783	-73.96776542897571	40.786785529449	25A-AM-1013-03	25A	AM	10132018	3		Gray		Gray+		Above Ground	15	BIG TREE	0	0	0	0	0	being chased by #2	0	0	0	0	0	0	1	0		POINT (-73.9677654289757 40.786785529449)
802	802	-73.958494212554	40.7995008636057	41A-AM-1013-01	41A	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	ran across a path	0	0	0	0	0	0	1	0		POINT (-73.958494212554 40.7995008636057)
915	915	-73.9770235090023	40.774135208066	9A-AM-1013-02	09A	AM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9770235090023 40.774135208066)
1017	1017	-73.9552035011902	40.7889851896334	32I-AM-1013-06	32I	AM	10132018	6	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	3	In and below shrub	0	0	1	0	1		0	0	0	1	0	0	1	0		POINT (-73.9552035011902 40.7889851896334)
1103	1103	-73.9541500874008	40.7920329989756	35H-AM-1013-02	35H	AM	10132018	2	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10	Sitting on tree limb	0	0	0	0	0	sitting	0	0	0	0	0	0	1	0	watching me from tree,but calm	POINT (-73.9541500874008 40.7920329989756)
1130	1130	-73.95190816277679	40.7973148719421	41G-AM-1013-02	41G	AM	10132018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9519081627768 40.7973148719421)
1145	1145	-73.9611446263364	40.7911003407299	32D-AM-1013-03	32D	AM	10132018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	15		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9611446263364 40.7911003407299)
1188	1188	-73.9669529835992	40.787186415136496	25A-AM-1013-05	25A	AM	10132018	5		Gray		Gray+		Ground Plane	FALSE	CROSS BRIDLE - INTO TREE TO AVOID DOGGO	1	0	1	0	0	d.p.t.	0	0	0	1	1	0	1	0	calm	POINT (-73.96695298359921 40.7871864151365)
1212	1212	-73.9761792189352	40.7745745517215	9A-AM-1013-09	09A	AM	10132018	9	Juvenile	Cinnamon		Cinnamon+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9761792189352 40.7745745517215)
1308	1308	-73.95603964408441	40.7945080361909	37E-AM-1013-01	37E	AM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9560396440844 40.7945080361909)
1351	1351	-73.9610985171525	40.7913867116989	32D-AM-1013-01	32D	AM	10132018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9610985171525 40.7913867116989)
1478	1478	-73.9676370985166	40.7869888639434	25A-AM-1013-01	25A	AM	10132018	1		Gray	White	Gray+White	White Belly	Ground Plane	FALSE		0	0	0	1	0	staring at me	0	0	0	0	0	0	1	0		POINT (-73.96763709851662 40.7869888639434)
1558	1558	-73.968200390984	40.783709576948205	22B-AM-1013-02	22B	AM	10132018	2	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	0	1	climbed tree	0	0	0	0	0	0	1	0		POINT (-73.968200390984 40.7837095769482)
1578	1578	-73.97352989433209	40.771493999358896	8E-AM-1013-02	08E	AM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9735298943321 40.7714939993589)
1640	1640	-73.9564632239432	40.7904807427954	33G-AM-1013-01	33G	AM	10132018	1	Adult	Cinnamon		Cinnamon+		Above Ground	13	shelter in hole in tree	0	0	1	0	0		0	0	0	0	0	0	1	1		POINT (-73.9564632239432 40.7904807427954)
1695	1695	-73.9604083891356	40.7910284106931	32D-AM-1013-05	32D	AM	10132018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		1	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9604083891356 40.7910284106931)
1705	1705	-73.97654172820009	40.7740994735325	9A-AM-1013-05	09A	AM	10132018	5	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9765417282001 40.7740994735325)
1719	1719	-73.955429970986	40.797816862987496	40D-AM-1013-02	40D	AM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.955429970986 40.7978168629875)
1747	1747	-73.96657637976071	40.7761316400012	15H-AM-1013-03	15H	AM	10132018	3	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9665763797607 40.7761316400012)
1748	1748	-73.955710327539	40.797451079756705	40D-AM-1013-03	40D	AM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.955710327539 40.7974510797567)
1935	1935	-73.9675268877392	40.775040968171794	13H-AM-1013-01	13H	AM	10132018	1	Adult	Gray	White	Gray+White		Above Ground	5		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9675268877392 40.7750409681718)
2050	2050	-73.9555255950648	40.7977720808005	40D-AM-1013-04	40D	AM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9555255950648 40.7977720808005)
2065	2065	-73.9768411547701	40.7741377018895	9A-AM-1013-03	09A	AM	10132018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9768411547701 40.7741377018895)
2126	2126	-73.96126235775479	40.7911558714527	32D-AM-1013-02	32D	AM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9612623577548 40.7911558714527)
2181	2181	-73.97025301726521	40.7736241205021	11F-AM-1013-01	11F	AM	10132018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9702530172652 40.7736241205021)
2186	2186	-73.9561103688639	40.794914085004	37E-AM-1013-03	37E	AM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9561103688639 40.794914085004)
2202	2202	-73.95560399976209	40.7977549157287	40D-AM-1013-05	40D	AM	10132018	5	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9556039997621 40.7977549157287)
2224	2224	-73.9662310606968	40.7747758221226	14I-AM-1013-01	14I	AM	10132018	1	Adult	Gray	White	Gray+White		Above Ground	10		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9662310606968 40.7747758221226)
2225	2225	-73.95623234556741	40.7946180656349	37E-AM-1013-02	37E	AM	10132018	2		Gray	White	Gray+White		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9562323455674 40.79461806563491)
2252	2252	-73.95377032313591	40.7915959393814	35I-AM-1013-01	35I	AM	10132018	1	Adult	Cinnamon	White	Cinnamon+White	White underbelly	Above Ground	18		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9537703231359 40.7915959393814)
2409	2409	-73.97259471799521	40.7794481577234	16A-AM-1013-01	16A	AM	10132018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9725947179952 40.7794481577234)
2411	2411	-73.9686907918759	40.7839462261858	22B-AM-1013-03	22B	AM	10132018	3	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9686907918759 40.7839462261858)
2473	2473	-73.9613347295946	40.7938900965153	34B-AM-1013-02	34B	AM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9613347295946 40.7938900965153)
2530	2530	-73.95610768244549	40.7981145780509	40D-AM-1013-01	40D	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9561076824455 40.7981145780509)
2813	2813	-73.96591181893591	40.7765739928504	15H-AM-1013-02	15H	AM	10132018	2	Adult	Gray		Gray+		Above Ground	15		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9659118189359 40.7765739928504)
2845	2845	-73.9765016413674	40.77406728629529	9A-AM-1013-06	09A	AM	10132018	6	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9765016413674 40.7740672862953)
2848	2848	-73.97159771705479	40.774217265062205	11E-AM-1013-03	11E	AM	10132018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1	burying	0	0	0	0	0	0	1	0		POINT (-73.9715977170548 40.774217265062205)
2919	2919	-73.9768563402344	40.7744487310786	9A-AM-1013-12	09A	AM	10132018	12	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	foot of tree	1	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9768563402344 40.7744487310786)

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