2018_Central_Park_Squirrel_Census_-_Squirrel_Data

43 rows where Climbing = 0, Date = 10142018, Foraging = 0 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

- 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, Running, Chasing, Eating, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

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
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)
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)
465	465	-73.9683041099256	40.786265230008205	24A-AM-1014-01	24A	AM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0	freezes	POINT (-73.9683041099256 40.7862652300082)
498	498	-73.9669432929573	40.779136518298	18F-AM-1014-01	18F	AM	10142018	1	Adult	Gray	White	Gray+White		Above Ground		Low tree	0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9669432929573 40.779136518298)
501	501	-73.9708798496132	40.7761532088521	13D-AM-1014-06	13D	AM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9708798496132 40.7761532088521)
576	576	-73.96220476777009	40.7945126358465	35A-AM-1014-06	35A	AM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9622047677701 40.7945126358465)
608	608	-73.95896759955171	40.791311922358396	33E-AM-1014-09	33E	AM	10142018	9	Juvenile	Black		Black+		Above Ground	15		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9589675995517 40.7913119223584)
656	656	-73.9553726714504	40.798757854112296	41D-AM-1014-02	41D	AM	10142018	2	Adult	Gray		Gray+		Above Ground	20		0	0	0	0	0	jumping	0	0	0	0	0	0	1	0		POINT (-73.9553726714504 40.7987578541123)
818	818	-73.96087574240521	40.790668650465705	31D-AM-1014-06	31D	AM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9608757424052 40.7906686504657)
898	898	-73.95428280532559	40.794179732035495	37G-AM-1014-03	37G	AM	10142018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9542828053256 40.7941797320355)
966	966	-73.95831758180199	40.791656668315795	33E-AM-1014-12	33E	AM	10142018	12	Adult	Gray	White	Gray+White		Above Ground	15		0	0	0	0	0	sleeping	0	0	0	0	0	0	0	0	asleep	POINT (-73.958317581802 40.7916566683158)
1006	1006	-73.96862962178929	40.771812308875	10H-AM-1014-02	10H	AM	10142018	2	Juvenile	Cinnamon		Cinnamon+		Above Ground	6		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9686296217893 40.771812308875)
1075	1075	-73.9640534906634	40.777738389983604	17I-AM-1014-02	17I	AM	10142018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0	standing upright	0	0	0	0	0	1	0	1	runs from (only ran away when a grandpa chased it off)	POINT (-73.9640534906634 40.7777383899836)
1102	1102	-73.9688173465755	40.7782009764626	16E-AM-1014-08	16E	AM	10142018	8	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	runs from (dog)	POINT (-73.9688173465755 40.7782009764626)
1223	1223	-73.95912985511109	40.7919612446005	33E-AM-1014-04	33E	AM	10142018	4	Adult	Black	Cinnamon, White	Black+Cinnamon, White		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9591298551111 40.7919612446005)
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)
1453	1453	-73.9555856074105	40.7969457685677	40E-AM-1014-04	40E	AM	10142018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE	on rocks/bushy rocks	1	0	0	0	0	hiding from bird	0	1	0	0	1	0	1	0		POINT (-73.9555856074105 40.79694576856771)
1708	1708	-73.9618486459307	40.7946365810826	35A-AM-1014-02	35A	AM	10142018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9618486459307 40.7946365810826)
1752	1752	-73.9561091686663	40.798146304742495	41D-AM-1014-04	41D	AM	10142018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9561091686663 40.7981463047425)
1765	1765	-73.9689041600147	40.7781788966185	16E-AM-1014-07	16E	AM	10142018	7	Adult	Gray		Gray+		Above Ground			1	0	0	0	0		0	0	0	0	0	0	0	1	runs from (dog)	POINT (-73.9689041600147 40.7781788966185)
1844	1844	-73.9682062012675	40.786498436192005	24A-AM-1014-02	24A	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Blonde? in Highlights	Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9682062012675 40.786498436192)
2041	2041	-73.9651796685091	40.7785578267586	18G-AM-1014-03	18G	AM	10142018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9651796685091 40.7785578267586)
2059	2059	-73.9710026704697	40.776105276462104	13D-AM-1014-04	13D	AM	10142018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9710026704697 40.7761052764621)
2104	2104	-73.9622419917579	40.794579797904	35A-AM-1014-07	35A	AM	10142018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9622419917579 40.794579797904)
2261	2261	-73.9609692861012	40.790502891247	31D-AM-1014-07	31D	AM	10142018	7		Gray		Gray+		Ground Plane	FALSE	Crossing path to tree	1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9609692861012 40.790502891247)
2303	2303	-73.9589470461357	40.7912817646361	33E-AM-1014-10	33E	AM	10142018	10	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	15		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9589470461357 40.7912817646361)
2481	2481	-73.9719068478565	40.7789062312585	15B-AM-1014-02	15B	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	0	0	0	grooming,scratching	0	0	0	0	0	0	1	0		POINT (-73.9719068478565 40.7789062312585)
2536	2536	-73.96850872880721	40.7779068128051	16E-AM-1014-01	16E	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	burying food	0	0	0	0	0	1	0	0		POINT (-73.9685087288072 40.7779068128051)
2540	2540	-73.959127912788	40.79211971304029	33E-AM-1014-13	33E	AM	10142018	13	Adult	Black	Cinnamon	Black+Cinnamon	Cinnamon on the tail	Ground Plane	FALSE		0	0	0	0	0	sitting	0	0	0	0	0	0	1	0		POINT (-73.959127912788 40.7921197130403)
2545	2545	-73.9617594316752	40.7946803725236	35A-AM-1014-01	35A	AM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9617594316752 40.7946803725236)
2613	2613	-73.96393252683	40.7808289765857	21G-AM-1014-04	21G	AM	10142018	4	Adult	Gray	White	Gray+White		Above Ground	6		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.96393252683 40.7808289765857)
2621	2621	-73.9596904740342	40.7897200025671	31E-AM-1014-01	31E	AM	10142018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9596904740342 40.7897200025671)
2653	2653	-73.958932543729	40.7913445531266	33E-AM-1014-11	33E	AM	10142018	11	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	15		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.958932543729 40.7913445531266)
2654	2654	-73.9549261242548	40.7944701994615	37G-AM-1014-04	37G	AM	10142018	4	Adult	Gray		Gray+		Above Ground	5		0	1	0	0	0	playing	0	0	0	0	0	0	1	0		POINT (-73.9549261242548 40.7944701994615)
2740	2740	-73.96126586889142	40.7912119940469	32C-AM-1014-04	32C	AM	10142018	4	Adult	Gray		Gray+		Above Ground	8		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9612658688914 40.7912119940469)
2768	2768	-73.96410881726321	40.7886555184212	28C-AM-1014-01	28C	AM	10142018	1	Adult	Black		Black+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9641088172632 40.7886555184212)
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)
2881	2881	-73.9541629063295	40.7934259301577	37G-AM-1014-02	37G	AM	10142018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0	ran away & disappeared	0	0	0	0	0	0	0	0		POINT (-73.9541629063295 40.7934259301577)
2899	2899	-73.9686358129525	40.7778035516486	16E-AM-1014-05	16E	AM	10142018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9686358129525 40.7778035516486)
2923	2923	-73.9672160533827	40.7830263908749	21C-AM-1014-05	21C	AM	10142018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9672160533827 40.7830263908749)
2948	2948	-73.9545225586988	40.7956074663106	39F-AM-1014-03	39F	AM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9545225586988 40.7956074663106)
2949	2949	-73.9651206201297	40.778527906484705	18G-AM-1014-02	18G	AM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9651206201297 40.7785279064847)
2975	2975	-73.959412243507	40.7917871123534	33E-AM-1014-01	33E	AM	10142018	1	Adult	Black	Cinnamon	Black+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	digging	0	0	0	0	0	0	0	1		POINT (-73.959412243507 40.7917871123534)

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