2018_Central_Park_Squirrel_Census_-_Squirrel_Data

39 rows where Date = 10102018, Indifferent = 1 and Location = "Above Ground"

- 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, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, 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
3	3	-73.9768311751004	40.766717807255795	2E-AM-1010-03	02E	AM	10102018	3	Adult	Cinnamon		Cinnamon+		Above Ground	4		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9768311751004 40.76671780725581)
16	16	-73.97225001968441	40.7742879599026	11D-AM-1010-03	11D	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	30		0	0	1	0	0	grooming	0	0	0	0	0	0	1	0		POINT (-73.9722500196844 40.7742879599026)
46	46	-73.9673253417305	40.7749505252981	13H-PM-1010-02	13H	PM	10102018	2	Adult	Gray		Gray+		Above Ground	5	tree	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9673253417305 40.7749505252981)
191	191	-73.9787105069657	40.7693708133873	3B-AM-1010-08	03B	AM	10102018	8	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	0	0	together w/ #7	0	0	0	0	0	0	1	0		POINT (-73.9787105069657 40.7693708133873)
256	256	-73.976798124308	40.774131657411296	9A-PM-1010-04	09A	PM	10102018	4		Cinnamon		Cinnamon+		Above Ground	20		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.97679812430802 40.7741316574113)
294	294	-73.9756573579063	40.7656644063024	1G-PM-1010-01	01G	PM	10102018	1	Adult	Gray	White	Gray+White		Above Ground	15		0	0	1	1	0		0	0	0	1	0	0	1	0	too busy eating in his tree	POINT (-73.9756573579063 40.7656644063024)
414	414	-73.9721899838568	40.776151904565104	13C-AM-1010-03	13C	AM	10102018	3	Adult	Gray		Gray+		Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9721899838568 40.7761519045651)
483	483	-73.9789952029637	40.7697758333099	4B-AM-1010-03	04B	AM	10102018	3	Juvenile	Gray	White	Gray+White		Above Ground	25		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9789952029637 40.7697758333099)
530	530	-73.9696360756453	40.7786545659072	16D-PM-1010-03	16D	PM	10102018	3	Adult	Gray		Gray+		Above Ground	18		0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9696360756453 40.7786545659072)
729	729	-73.97760445784459	40.7697607308033	4C-PM-1010-15	04C	PM	10102018	15	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground		on tree	0	1	0	0	0	chasing #14	0	0	0	0	0	0	1	0		POINT (-73.9776044578446 40.7697607308033)
822	822	-73.9576559099012	40.7992598626483	41B-AM-1010-09	41B	AM	10102018	9	Adult	Gray		Gray+		Above Ground	3		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9576559099012 40.7992598626483)
908	908	-73.9594120573719	40.78419457505979	26I-PM-1010-05	26I	PM	10102018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	10	tree	0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9594120573719 40.7841945750598)
1164	1164	-73.97902264006291	40.76989976537921	4B-AM-1010-01	04B	AM	10102018	1	Adult	Gray	Black, Cinnamon	Gray+Black, Cinnamon		Above Ground	2		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9790226400629 40.7698997653792)
1227	1227	-73.9527924755398	40.79343662605329	37I-AM-1010-04	37I	AM	10102018	4	Adult	Gray		Gray+		Above Ground	50	in tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9527924755398 40.7934366260533)
1253	1253	-73.9527227282134	40.7935061484064	37I-AM-1010-03	37I	AM	10102018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	4	in tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9527227282134 40.7935061484064)
1331	1331	-73.9588809150045	40.7847231576181	26I-PM-1010-01	26I	PM	10102018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	4		0	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.9588809150045 40.7847231576181)
1627	1627	-73.9594391759139	40.784115697669	26I-PM-1010-03	26I	PM	10102018	3	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	black in tail	Above Ground	15	tree	0	0	1	1	1		0	0	0	0	1	0	1	0		POINT (-73.9594391759139 40.784115697669)
1762	1762	-73.9769106838192	40.7674414870702	2E-AM-1010-05	02E	AM	10102018	5	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	33		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9769106838192 40.7674414870702)
1976	1976	-73.9770920860805	40.769469804008295	4C-PM-1010-01	04C	PM	10102018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	6		0	0	1	0	0		0	1	0	0	0	0	1	0		POINT (-73.9770920860805 40.7694698040083)
2009	2009	-73.9639505810228	40.789573183584	29B-PM-1010-01	29B	PM	10102018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	4	climbing trees	0	0	1	1	1	scratching self	0	0	0	0	1	0	1	0		POINT (-73.9639505810228 40.789573183584)
2025	2025	-73.97665418790059	40.7674077265375	2E-AM-1010-06	02E	AM	10102018	6	Adult	Cinnamon		Cinnamon+		Above Ground	35		0	0	0	0	0	leaping branch to branch	0	0	0	0	0	0	1	0		POINT (-73.9766541879006 40.7674077265375)
2136	2136	-73.97218979152109	40.7660434203132	3I-AM-1010-02	03I	AM	10102018	2	Adult	Gray		Gray+		Above Ground	40		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9721897915211 40.76604342031321)
2144	2144	-73.975198284551	40.7740343763399	9B-AM-1010-06	09B	AM	10102018	6	Juvenile	Gray	White	Gray+White		Above Ground	16	tree	0	0	1	0	0	cleaning	0	0	0	0	0	0	1	0		POINT (-73.975198284551 40.7740343763399)
2226	2226	-73.9624296435843	40.791320813687	31C-PM-1010-02	31C	PM	10102018	2	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9624296435843 40.791320813687)
2247	2247	-73.95595201371721	40.7950536287174	38E-AM-1010-06	38E	AM	10102018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1	branches	1	1	0	0	0	chasing and being chased by #7	0	0	0	0	1	0	1	0		POINT (-73.95595201371721 40.7950536287174)
2259	2259	-73.975565603566	40.7738462518304	9B-AM-1010-03	09B	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4		1	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.975565603566 40.7738462518304)
2297	2297	-73.9787771053108	40.769356212275	3B-AM-1010-07	03B	AM	10102018	7	Adult	Gray		Gray+		Above Ground	10		0	0	1	0	0	together w/ #8	0	0	0	1	0	0	1	0		POINT (-73.9787771053108 40.76935621227501)
2300	2300	-73.9789251806378	40.7699558513225	4B-AM-1010-02	04B	AM	10102018	2	Juvenile	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	30		0	0	1	1	1		1	0	0	0	0	0	1	0		POINT (-73.9789251806378 40.7699558513225)
2361	2361	-73.9708032298419	40.7784265674544	15C-AM-1010-02	15C	AM	10102018	2	Adult	Gray		Gray+		Above Ground	15		0	0	1	0	0	nest building	0	0	0	0	0	0	1	0		POINT (-73.9708032298419 40.77842656745441)
2379	2379	-73.97118651343641	40.7785039981892	15C-AM-1010-03	15C	AM	10102018	3	Adult	Gray		Gray+		Above Ground	6		0	0	0	1	0	sitting	0	0	0	0	0	0	1	0		POINT (-73.9711865134364 40.7785039981892)
2385	2385	-73.9787552947847	40.7690779628762	3B-AM-1010-06	03B	AM	10102018	6	Adult	Gray		Gray+		Above Ground	20		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9787552947847 40.7690779628762)
2474	2474	-73.97214488797658	40.7762112840981	13C-AM-1010-02	13C	AM	10102018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	7		0	0	1	0	0	burying	0	0	0	0	0	0	1	0		POINT (-73.9721448879766 40.7762112840981)
2476	2476	-73.9710843362124	40.7679739601336	5I-AM-1010-03	05I	AM	10102018	3	Adult	Gray		Gray+		Above Ground	3		0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9710843362124 40.7679739601336)
2497	2497	-73.9622050752008	40.7886373772305	29D-PM-1010-01	29D	PM	10102018	1	Juvenile	Gray	White	Gray+White		Above Ground	10		0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9622050752008 40.7886373772305)
2569	2569	-73.9559663734409	40.794582826137706	37F-AM-1010-01	37F	AM	10102018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4		0	0	1	0	0		0	0	0	1	0	0	1	0		POINT (-73.9559663734409 40.7945828261377)
2573	2573	-73.9810149147578	40.7683925377714	2A-AM-1010-03	02A	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1	on trunk	0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9810149147578 40.7683925377714)
2702	2702	-73.9588339897601	40.7848084865431	26I-PM-1010-06	26I	PM	10102018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	35	tree	0	0	1	0	1		0	0	0	0	1	0	1	0		POINT (-73.9588339897601 40.7848084865431)
2896	2896	-73.970595860252	40.7832060751268	20A-AM-1010-01	20A	AM	10102018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.970595860252 40.7832060751268)
2914	2914	-73.9722053355548	40.7662094993614	3I-AM-1010-03	03I	AM	10102018	3	Adult	Gray		Gray+		Above Ground	50		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9722053355548 40.7662094993614)

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