2018_Central_Park_Squirrel_Census_-_Squirrel_Data

42 rows where Date = 10102018, Highlight Fur Color = "White" and Indifferent = 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

- 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, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail twitches, Approaches, 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
111	111	-73.9763243383771	40.770540931570295	5C-PM-1010-13	05C	PM	10102018	13	Adult	Gray	White	Gray+White		Above Ground	20	way up a tree!	0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9763243383771 40.7705409315703)
123	123	-73.9671147090087	40.7772624641112	16G-AM-1010-03	16G	AM	10102018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1	was hanging out w/ #2 until i showed up	1	0	0	0	0	0	0	1		POINT (-73.9671147090087 40.7772624641112)
140	140	-73.97686527856641	40.768483816820705	3D-PM-1010-03	03D	PM	10102018	3	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.97686527856641 40.7684838168207)
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)
278	278	-73.9787796921165	40.7707526535381	5A-PM-1010-01	05A	PM	10102018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9787796921165 40.7707526535381)
514	514	-73.9768357173861	40.7683813358343	3D-PM-1010-12	03D	PM	10102018	12	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	1	0	0	1		0	1	0	0	0	0	0	0		POINT (-73.9768357173861 40.7683813358343)
520	520	-73.97494466297059	40.77206596960671	7D-PM-1010-01	07D	PM	10102018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE	outside fenced hectare	1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9749446629706 40.7720659696067)
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)
602	602	-73.96857515954851	40.7709413567859	9I-PM-1010-07	09I	PM	10102018	7	Adult	Gray	White	Gray+White		Above Ground	1	ran up tree	1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9685751595485 40.7709413567859)
704	704	-73.97935655643609	40.767925939044794	2C-AM-1010-09	02C	AM	10102018	9	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0	climbed up tree as i neared	POINT (-73.9793565564361 40.7679259390448)
752	752	-73.9768617690725	40.7741877060705	9A-PM-1010-03	09A	PM	10102018	3		Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	0	0	froze - standing on hind legs for ~10 seconds then scampered off	POINT (-73.97686176907251 40.7741877060705)
807	807	-73.97772590224409	40.76820599079029	3D-PM-1010-10	03D	PM	10102018	10	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9777259022441 40.7682059907903)
917	917	-73.9676514056678	40.7730853732876	11H-AM-1010-01	11H	AM	10102018	1	Adult	Gray	White	Gray+White		Above Ground	20		0	0	1	0	0		0	0	0	0	0	1	0	0	started climbing down to me	POINT (-73.9676514056678 40.7730853732876)
1080	1080	-73.96902119353459	40.773038298158	11H-AM-1010-07	11H	AM	10102018	7	Adult	Gray	White	Gray+White		Above Ground	4		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9690211935346 40.773038298158)
1127	1127	-73.9776445567926	40.768119107973	3D-PM-1010-07	03D	PM	10102018	7	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9776445567926 40.768119107973)
1154	1154	-73.9786936992465	40.771394367466606	5A-PM-1010-02	05A	PM	10102018	2	Adult	Gray	White	Gray+White		Above Ground	50		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9786936992465 40.7713943674666)
1158	1158	-73.97638947595429	40.7705523372364	5C-PM-1010-12	05C	PM	10102018	12	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9763894759543 40.7705523372364)
1224	1224	-73.95725308434791	40.7987460430546	41B-AM-1010-05	41B	AM	10102018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9572530843479 40.7987460430546)
1256	1256	-73.9679457364586	40.7717350221981	10I-AM-1010-02	10I	AM	10102018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.9679457364586 40.7717350221981)
1259	1259	-73.976864402584	40.7705663751959	5C-PM-1010-05	05C	PM	10102018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.976864402584 40.7705663751959)
1268	1268	-73.96239842629359	40.7913900453449	31C-PM-1010-03	31C	PM	10102018	3	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9623984262936 40.7913900453449)
1347	1347	-73.9616693665254	40.792971019627	33B-AM-1010-05	33B	AM	10102018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9616693665254 40.792971019627)
1374	1374	-73.9653739273979	40.788976209696706	28B-PM-1010-02	28B	PM	10102018	2	Adult	Gray	White	Gray+White		Above Ground	4		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9653739273979 40.7889762096967)
1414	1414	-73.9580513096783	40.79909641532	41B-AM-1010-02	41B	AM	10102018	2	Adult	Gray	White	Gray+White		Above Ground	16		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9580513096783 40.79909641532)
1532	1532	-73.97792631145721	40.7682681855369	3D-PM-1010-08	03D	PM	10102018	8	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9779263114572 40.7682681855369)
1672	1672	-73.9640989602986	40.789929543926505	29B-PM-1010-03	29B	PM	10102018	3	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9640989602986 40.7899295439265)
1740	1740	-73.95777581255179	40.799384716477	41B-AM-1010-10	41B	AM	10102018	10	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9577758125518 40.799384716477)
1814	1814	-73.97223594012421	40.7702891474555	7G-AM-1010-07	07G	AM	10102018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9722359401242 40.7702891474555)
1825	1825	-73.9624209799704	40.79102009727521	31C-PM-1010-01	31C	PM	10102018	1	Adult	Gray	White	Gray+White		Above Ground	3		0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9624209799704 40.7910200972752)
1913	1913	-73.97746308218541	40.7680626674086	3D-PM-1010-11	03D	PM	10102018	11	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9774630821854 40.76806266740861)
1996	1996	-73.977641787698	40.769583026578395	4C-PM-1010-10	04C	PM	10102018	10	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.977641787698 40.7695830265784)
2097	2097	-73.9773486521595	40.77084549021129	5C-PM-1010-02	05C	PM	10102018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9773486521595 40.7708454902113)
2235	2235	-73.9748522796455	40.771958662100296	7D-PM-1010-01	07D	PM	10102018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE	outside fenced hectare	1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9748522796455 40.7719586621003)
2406	2406	-73.9668964315686	40.777757799088604	16G-AM-1010-01	16G	AM	10102018	1	Adult	Gray	White	Gray+White		Above Ground	3		0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9668964315686 40.7777577990886)
2587	2587	-73.97899712868441	40.7707024146365	5A-PM-1010-04	05A	PM	10102018	4	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	0	0		POINT (-73.9789971286844 40.7707024146365)
2620	2620	-73.97718000981308	40.7708863131336	5C-PM-1010-03	05C	PM	10102018	3	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9771800098131 40.7708863131336)
2628	2628	-73.9770439076963	40.7685720141731	3D-PM-1010-13	03D	PM	10102018	13	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9770439076963 40.7685720141731)
2633	2633	-73.9776151109912	40.7694681558386	4C-PM-1010-09	04C	PM	10102018	9	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9776151109912 40.7694681558386)
2674	2674	-73.97710090245809	40.7688793288864	3D-PM-1010-06	03D	PM	10102018	6	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9771009024581 40.7688793288864)
2692	2692	-73.98016364007441	40.769019205592606	2A-AM-1010-09	02A	AM	10102018	9	Adult	Gray	White	Gray+White		Above Ground		climbing in bush	0	0	1	0	0	hopping & flipping around. this one was very energetic & jumping aorund	0	0	0	0	1	0	0	0	climbed a foot up a tree and watched me	POINT (-73.9801636400744 40.7690192055926)
2701	2701	-73.97912175106559	40.767658347539395	2C-AM-1010-05	02C	AM	10102018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE	right at the base of the same tree as #3	0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9791217510656 40.7676583475394)
2956	2956	-73.9654741695628	40.7890427851106	28B-PM-1010-01	28B	PM	10102018	1	Adult	Gray	White	Gray+White		Above Ground	10	in a tree	0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9654741695628 40.7890427851106)

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