2018_Central_Park_Squirrel_Census_-_Squirrel_Data

28 rows where Hectare Squirrel Number = 4, Highlight Fur Color = "White", Indifferent = 1 and Quaas = 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: Hectare, Shift, Date, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Tail flags, Tail twitches

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
163	163	-73.97123088643941	40.7714534847379	9G-AM-1007-04	09G	AM	10072018	4	Adult	Gray	White	Gray+White		Above Ground	15		0	0	0	0	0	grooming	0	0	0	0	0	0	1	0		POINT (-73.9712308864394 40.7714534847379)
375	375	-73.9752000129992	40.773291812223896	8C-PM-1013-04	08C	PM	10132018	4	Juvenile	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9752000129992 40.7732918122239)
999	999	-73.980948293606	40.76856888506279	2A-PM-1019-04	02A	PM	10192018	4	Juvenile	Gray	White	Gray+White		Above Ground	15	in tree!	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.980948293606 40.7685688850628)
1177	1177	-73.98078982247259	40.768215817511	1A-PM-1014-04	01A	PM	10142018	4	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9807898224726 40.768215817511)
1182	1182	-73.9667206046912	40.777999356509795	17G-PM-1017-04	17G	PM	10172018	4	Adult	Gray	White	Gray+White		Above Ground	10	tree & ground	1	1	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9667206046912 40.7779993565098)
1246	1246	-73.9543044385367	40.7984498571338	41E-AM-1007-04	41E	AM	10072018	4	Adult	Cinnamon	White	Cinnamon+White	white haunches/tail	Ground Plane	FALSE	rubbing belly on ground	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9543044385367 40.798449857133804)
1282	1282	-73.974451175321	40.770129463526395	6E-PM-1010-04	06E	PM	10102018	4	Adult	Cinnamon	White	Cinnamon+White	white back legs	Ground Plane	FALSE	small open area but w/ 7 large oak trees	0	1	0	1	0	chasing #3	0	0	0	0	0	0	1	0		POINT (-73.974451175321 40.7701294635264)
1405	1405	-73.9589371550945	40.7959812504467	37C-PM-1013-04	37C	PM	10132018	4	Adult	Gray	White	Gray+White					0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9589371550945 40.7959812504467)
1460	1460	-73.97143299793049	40.7741873388945	11E-PM-1012-04	11E	PM	10122018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9714329979305 40.7741873388945)
1529	1529	-73.9692401421068	40.7707128895661	8I-AM-1006-04	08I	AM	10062018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9692401421068 40.7707128895661)
1541	1541	-73.9711617997772	40.7761212878075	13D-PM-1018-04	13D	PM	10182018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1	digging	0	0	0	0	0	0	1	0		POINT (-73.9711617997772 40.7761212878075)
1585	1585	-73.96113123553481	40.79501308639129	36A-PM-1013-04	36A	PM	10132018	4		Gray	White	Gray+White		Ground Plane	FALSE	ON ROCK NEAR POND	0	0	0	0	0	sitting	0	0	0	0	1	0	1	0		POINT (-73.9611312355348 40.7950130863913)
1663	1663	-73.96967203626271	40.779185159819704	17D-AM-1008-04	17D	AM	10082018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9696720362627 40.7791851598197)
1709	1709	-73.9771696835698	40.76970111004871	4C-AM-1006-04	04C	AM	10062018	4	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9771696835698 40.7697011100487)
1730	1730	-73.97961428483491	40.7702117898305	4A-PM-1007-04	04A	PM	10072018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9796142848349 40.7702117898305)
1802	1802	-73.9736418085696	40.7716931127716	8E-PM-1008-04	08E	PM	10082018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE	in grass by a grove of tall maples	0	0	0	1	1		0	0	0	0	0	0	1	0	there's a family playing soccer	POINT (-73.9736418085696 40.7716931127716)
1901	1901	-73.9680237209555	40.771702220822505	10I-AM-1010-04	10I	AM	10102018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9680237209555 40.7717022208225)
1961	1961	-73.953664715831	40.7981256393159	41E-PM-1013-04	41E	PM	10132018	4	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.953664715831 40.7981256393159)
2232	2232	-73.9566277721581	40.7966674587803	39D-PM-1012-04	39D	PM	10122018	4	Juvenile	Gray	White	Gray+White		Above Ground	10	on tree trunk (descending from height of ~10 ft)	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.95662777215811 40.7966674587803)
2277	2277	-73.95385121459	40.7981257651433	42E-PM-1012-04	42E	PM	10122018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.95385121459 40.7981257651433)
2340	2340	-73.9730284815849	40.7702462529502	7F-AM-1008-04	07F	AM	10082018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE	bush	0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9730284815849 40.7702462529502)
2353	2353	-73.963623175585	40.7927451068919	32A-PM-1013-04	32A	PM	10132018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.963623175585 40.7927451068919)
2355	2355	-73.9728654439465	40.7724853142211	9E-AM-1008-04	09E	AM	10082018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9728654439465 40.7724853142211)
2478	2478	-73.96749310703241	40.778369369095394	17F-AM-1007-04	17F	AM	10072018	4	Adult	Cinnamon	White	Cinnamon+White		Above Ground	4		0	0	0	1	0	chilling	1	0	0	0	0	0	1	0		POINT (-73.9674931070324 40.7783693690954)
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)
2842	2842	-73.9579292340076	40.7976287835027	39C-PM-1006-04	39C	PM	10062018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9579292340076 40.7976287835027)
2906	2906	-73.9597260014375	40.790707423031	32E-AM-1007-04	32E	AM	10072018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9597260014375 40.790707423031)
2918	2918	-73.9745152462626	40.76554155159079	1G-AM-1006-04	01G	AM	10062018	4	Adult	Gray	White	Gray+White					0	1	0	0	1	collecting nest material	0	0	0	0	1	0	1	0		POINT (-73.9745152462626 40.76554155159081)

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