2018_Central_Park_Squirrel_Census_-_Squirrel_Data

21 rows where Foraging = 1, Hectare Squirrel Number = 4, Primary Fur Color = "Gray" and Tail twitches = 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: Shift, Date, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Eating, Approaches, Indifferent, Runs from

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
157	157	-73.9637946878735	40.791570044687795	31A-AM-1010-04	31A	AM	10102018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9637946878735 40.7915700446878)
175	175	-73.9720065066618	40.7764043782924	13C-AM-1010-04	13C	AM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9720065066618 40.7764043782924)
343	343	-73.9730224561601	40.7796833353894	16A-PM-1019-04	16A	PM	10192018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9730224561601 40.7796833353894)
537	537	-73.9682803241007	40.772451055832704	11H-AM-1010-04	11H	AM	10102018	4		Gray	White	Gray+White					0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9682803241007 40.7724510558327)
589	589	-73.97826438139	40.7717086090782	6A-AM-1006-04	06A	AM	10062018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	1		0	0	0	0	1	0	0	0	curious	POINT (-73.97826438139 40.7717086090782)
868	868	-73.9738481771673	40.7706540698938	7E-PM-1013-04	07E	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	1	0	0	0		POINT (-73.9738481771673 40.7706540698938)
1237	1237	-73.9705370795538	40.7761725434851	13E-PM-1008-04	13E	PM	10082018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Gray & Cinnamon selected as Primary. Gray selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0	he took 2 steps then turned and stared at me	POINT (-73.9705370795538 40.7761725434851)
1462	1462	-73.9584064203778	40.7912272455454	33F-PM-1012-04	33F	PM	10122018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	1	0	0	1		POINT (-73.9584064203778 40.7912272455454)
1704	1704	-73.9624052832372	40.7809656348254	21H-PM-1018-04	21H	PM	10182018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	1	0	0		POINT (-73.9624052832372 40.7809656348254)
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)
2133	2133	-73.9736164871197	40.7725695048569	8D-PM-1007-04	08D	PM	10072018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9736164871197 40.7725695048569)
2343	2343	-73.9719194877439	40.774800096290896	11D-AM-1010-04	11D	AM	10102018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	0	0		POINT (-73.9719194877439 40.7748000962909)
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)
2532	2532	-73.9695150319891	40.782613519363	20B-PM-1013-04	20B	PM	10132018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1	chased a bird carrying massive wad of grass	0	0	0	0	1	0	0	0		POINT (-73.9695150319891 40.782613519363)
2641	2641	-73.96155167034941	40.790521938835894	31D-AM-1014-04	31D	AM	10142018	4	Juvenile	Gray		Gray+		Ground Plane	FALSE	Open ground	1	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9615516703494 40.7905219388359)
2770	2770	-73.96379835137891	40.7828712516396	23F-PM-1013-04	23F	PM	10132018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary: "much browner, like 1/2 & 1/2".	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0	indifferent (busy foraging)	POINT (-73.9637983513789 40.7828712516396)
2884	2884	-73.9598378495787	40.7956843021662	37B-AM-1018-04	37B	AM	10182018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9598378495787 40.7956843021662)
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)
2961	2961	-73.9736238258579	40.7688712771191	5F-PM-1007-04	05F	PM	10072018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9736238258579 40.7688712771191)
3000	3000	-73.9688293382172	40.7738958027568	12G-AM-1012-04	12G	AM	10122018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9688293382172 40.773895802756805)

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