2018_Central_Park_Squirrel_Census_-_Squirrel_Data

27 rows where Date = 10172018, Indifferent = 1 and Running = 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

- 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, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Eating, Foraging, Other Activities, 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
300	300	-73.9528149779809	40.7924984810637	36I-AM-1017-06	36I	AM	10172018	6	Adult	Gray	Black	Gray+Black	Darker than others	Above Ground	10	Running down tree	1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9528149779809 40.7924984810637)
438	438	-73.95257475169142	40.7977257435263	42F-PM-1017-02	42F	PM	10172018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	playing	0	0	0	0	0	0	1	0		POINT (-73.95257475169142 40.7977257435263)
542	542	-73.9713487591577	40.7784353043714	15C-PM-1017-03	15C	PM	10172018	3	Adult	Black		Black+		Above Ground	17	running across overpass	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9713487591577 40.7784353043714)
573	573	-73.9674688433583	40.7789728381912	17E-AM-1017-06	17E	AM	10172018	6	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9674688433583 40.7789728381912)
786	786	-73.953296595236	40.7927644594513	36I-AM-1017-03	36I	AM	10172018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon stripe on back	Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.953296595236 40.7927644594513)
805	805	-73.97068515461841	40.7780777016038	15D-PM-1017-04	15D	PM	10172018	4	Adult	Cinnamon		Cinnamon+		Above Ground	2	on fence	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9706851546184 40.7780777016038)
1020	1020	-73.97016933635	40.770545252978295	8H-AM-1017-05	08H	AM	10172018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	6		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.97016933635001 40.7705452529783)
1072	1072	-73.9566571713254	40.798985577543505	41C-AM-1017-04	41C	AM	10172018	4		Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9566571713254 40.7989855775435)
1139	1139	-73.9716271494641	40.7796462634184	16B-PM-1017-02	16B	PM	10172018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	1	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9716271494641 40.7796462634184)
1171	1171	-73.9573477643797	40.797173406050895	39C-AM-1017-01	39C	AM	10172018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9573477643797 40.7971734060509)
1179	1179	-73.9696762034757	40.7704883494264	8H-AM-1017-02	08H	AM	10172018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	7	root bed of tree	1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9696762034757 40.7704883494264)
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)
1229	1229	-73.9677751507448	40.779099006665795	17E-AM-1017-11	17E	AM	10172018	11	Adult	Gray		Gray+		Ground Plane	FALSE	Shore	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9677751507448 40.7790990066658)
1717	1717	-73.97149520927671	40.7748063281815	12E-AM-1017-02	12E	AM	10172018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9714952092767 40.7748063281815)
1988	1988	-73.957138794884	40.7985389822719	40C-AM-1017-03	40C	AM	10172018	3	Adult	Gray	White	Gray+White					1	1	1	0	0	chasing (#4),digging	0	0	0	0	1	0	1	0		POINT (-73.957138794884 40.7985389822719)
2071	2071	-73.96676944398949	40.7779501809095	17G-PM-1017-03	17G	PM	10172018	3	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.9667694439895 40.7779501809095)
2246	2246	-73.9711607544742	40.774988247642	12E-AM-1017-04	12E	AM	10172018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9711607544742 40.774988247642)
2293	2293	-73.9675309175947	40.7788649926486	17E-AM-1017-09	17E	AM	10172018	9	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9675309175947 40.7788649926486)
2324	2324	-73.9737247632185	40.7759469280872	12C-PM-1017-01	12C	PM	10172018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	0	digging/burying,drinking from lake	0	0	0	0	1	0	1	0		POINT (-73.9737247632185 40.7759469280872)
2442	2442	-73.9699369796844	40.772035019127294	10G-PM-1017-04	10G	PM	10172018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9699369796844 40.7720350191273)
2460	2460	-73.9526681107152	40.7977012009146	42F-PM-1017-01	42F	PM	10172018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0	playing	0	0	0	0	0	0	1	0		POINT (-73.9526681107152 40.7977012009146)
2694	2694	-73.969628583287	40.770406779793205	8H-AM-1017-03	08H	AM	10172018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2	fence	1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.969628583287 40.7704067797932)
2698	2698	-73.9744917362668	40.77783887377	13A-AM-1017-02	13A	AM	10172018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9744917362668 40.77783887377)
2836	2836	-73.953092053256	40.7982256930243	42F-PM-1017-03	42F	PM	10172018	3		Gray	Cinnamon	Gray+Cinnamon					1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.953092053256 40.7982256930243)
2840	2840	-73.9532163535175	40.7982970313067	42F-PM-1017-04	42F	PM	10172018	4		Gray		Gray+					1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9532163535175 40.7982970313067)
2866	2866	-73.9744025383371	40.7777296605765	13A-AM-1017-04	13A	AM	10172018	4	Adult	Gray		Gray+					1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9744025383371 40.7777296605765)
2890	2890	-73.9726236083428	40.7788217771475	15B-PM-1017-03	15B	PM	10172018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE	by water	1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9726236083428 40.778821777147506)

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