2018_Central_Park_Squirrel_Census_-_Squirrel_Data

27 rows where Date = 10142018, Eating = 0, Runs from = 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

- 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, Foraging, Moans, Tail twitches, Approaches, Indifferent, 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
122	122	-73.9712527809516	40.7763310392591	13D-AM-1014-08	13D	AM	10142018	8	Adult	Gray	Cinnamon	Gray+Cinnamon	Gray & Cinnamon selected as Primary. Cinnamon selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9712527809516 40.7763310392591)
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)
388	388	-73.9592537496995	40.7919271821316	33E-AM-1014-03	33E	AM	10142018	3	Adult	Black		Black+		Above Ground	5		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9592537496995 40.7919271821316)
544	544	-73.9718474480919	40.7794963354254	16B-AM-1014-01	16B	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9718474480919 40.7794963354254)
593	593	-73.95933528061751	40.7918150568046	33E-AM-1014-02	33E	AM	10142018	2	Juvenile	Black		Black+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9593352806175 40.7918150568046)
624	624	-73.96130519573059	40.7909351393505	31D-AM-1014-02	31D	AM	10142018	2	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE	Undergrowth	0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9613051957306 40.7909351393505)
891	891	-73.9613351649026	40.79098668513571	31D-AM-1014-03	31D	AM	10142018	3		Gray	White	Gray+White		Ground Plane	FALSE	Undergrowth	0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9613351649026 40.7909866851357)
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)
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)
1119	1119	-73.9597557819449	40.7949918204459	36C-AM-1014-01	36C	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Gray & Cinnamon selected as Primary. Cinnamon selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9597557819449 40.7949918204459)
1134	1134	-73.9716995507598	40.7797671327739	16B-AM-1014-02	16B	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9716995507598 40.7797671327739)
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)
1803	1803	-73.9588076804698	40.7912942607296	33E-AM-1014-06	33E	AM	10142018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9588076804698 40.7912942607296)
1992	1992	-73.9586085843149	40.7946617684536	36C-AM-1014-03	36C	AM	10142018	3		Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9586085843149 40.7946617684536)
2061	2061	-73.9608834102446	40.790624710005005	31D-AM-1014-05	31D	AM	10142018	5	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9608834102446 40.790624710005)
2105	2105	-73.9738723117119	40.7786845612246	14A-AM-1014-01	14A	AM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1	foraging?,crossing road	0	0	0	0	0	0	1	1	runs from (dogs)	POINT (-73.9738723117119 40.7786845612246)
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)
2276	2276	-73.9611985783336	40.791604823372005	32C-AM-1014-06	32C	AM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9611985783336 40.791604823372)
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)
2729	2729	-73.9615429203441	40.7907417648701	31D-AM-1014-01	31D	AM	10142018	1		Gray	Cinnamon	Gray+Cinnamon		Above Ground	20	Ground then up tree	0	0	1	0	0	chased by a doggo	0	0	1	0	0	0	0	1	runs from (dogs!)	POINT (-73.9615429203441 40.7907417648701)
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)
2849	2849	-73.9709912560997	40.77589655951979	13D-AM-1014-01	13D	AM	10142018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.9709912560997 40.7758965595198)
2892	2892	-73.9688070760806	40.777968829417205	16E-AM-1014-06	16E	AM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	0	0	0	1		POINT (-73.9688070760806 40.777968829417205)
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)
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
);