2018_Central_Park_Squirrel_Census_-_Squirrel_Data

24 rows where Climbing = 0, Hectare Squirrel Number = 6, Primary Fur Color = "Gray" and Runs from = 1

- 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: Unique Squirrel ID, Hectare, Shift, Date, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Eating, Foraging, Kuks, Tail twitches, Indifferent

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
41	41	-73.96391592984459	40.789177463798794	29C-AM-1007-06	29C	AM	10072018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9639159298446 40.7891774637988)
61	61	-73.9797084866613	40.7698885241349	3A-PM-1017-06	03A	PM	10172018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9797084866613 40.7698885241349)
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)
522	522	-73.97738211356109	40.769045349438294	4C-PM-1010-06	04C	PM	10102018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	behind playground benches	0	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9773821135611 40.7690453494383)
713	713	-73.956200809768	40.798181446265	40C-AM-1017-06	40C	AM	10172018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.956200809768 40.798181446265)
943	943	-73.9773096718574	40.773805386248895	8A-AM-1013-06	08A	AM	10132018	6	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9773096718574 40.7738053862489)
988	988	-73.97870401924729	40.767901024728104	2C-AM-1010-06	02C	AM	10102018	6	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0	stood still & watched me then jumped on a fence and ran away	0	0	0	0	0	0	1	1		POINT (-73.9787040192473 40.7679010247281)
1049	1049	-73.9564606426367	40.788054657260794	30I-PM-1006-06	30I	PM	10062018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	1	ran up tree	POINT (-73.9564606426367 40.7880546572608)
1162	1162	-73.95685442708809	40.7972517274475	39D-AM-1008-06	39D	AM	10082018	6	Adult	Gray		Gray+		Above Ground	3	on rock	0	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9568544270881 40.7972517274475)
1219	1219	-73.96618922004741	40.7836798072777	22D-PM-1012-06	22D	PM	10122018	6	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9661892200474 40.7836798072777)
1247	1247	-73.96709048698709	40.7832091658006	21D-PM-1008-06	21D	PM	10082018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9670904869871 40.7832091658006)
1314	1314	-73.980919134781	40.7683772453336	1A-PM-1014-06	01A	PM	10142018	6	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		1	0	0	0	0	0	0	1		POINT (-73.980919134781 40.7683772453336)
1520	1520	-73.968021326951	40.7778807692445	16F-PM-1013-06	16F	PM	10132018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Big rock in meadow	0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.968021326951 40.7778807692445)
1524	1524	-73.97259615083159	40.7795720444974	16A-PM-1019-06	16A	PM	10192018	6	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9725961508316 40.7795720444974)
1540	1540	-73.957710975899	40.79840556140471	40B-AM-1019-06	40B	AM	10192018	6	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.957710975899 40.7984055614047)
1674	1674	-73.9589698681439	40.7906520520417	32E-PM-1017-06	32E	PM	10172018	6	Adult	Gray		Gray+		Ground Plane	FALSE	treed area	0	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9589698681439 40.7906520520417)
1679	1679	-73.9545399102352	40.7898646267709	33I-PM-1006-06	33I	PM	10062018	6	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9545399102352 40.7898646267709)
1699	1699	-73.9706968708903	40.7821499135828	19A-PM-1013-06	19A	PM	10132018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9706968708903 40.7821499135828)
2168	2168	-73.95823634371351	40.7987752300505	40B-AM-1019-06	40B	AM	10192018	6	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9582363437135 40.7987752300505)
2239	2239	-73.9668922014699	40.7823535653774	21D-AM-1008-06	21D	AM	10082018	6	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9668922014699 40.7823535653774)
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)
2357	2357	-73.96323010348829	40.7925707244111	32A-PM-1013-06	32A	PM	10132018	6	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9632301034883 40.7925707244111)
2374	2374	-73.9551370586201	40.7946465469021	38F-AM-1018-06	38F	AM	10182018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	hopped away	0	0	0	0	0	0	0	1		POINT (-73.95513705862011 40.7946465469021)
2637	2637	-73.968891673893	40.776700147172896	15F-AM-1007-06	15F	AM	10072018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	pair with #5	0	0	0	0	0	0	0	1		POINT (-73.968891673893 40.7767001471729)

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