2018_Central_Park_Squirrel_Census_-_Squirrel_Data

40 rows where Eating = 1, Foraging = 1, Hectare Squirrel Number = 3 and Runs from = 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

- 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, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Tail flags, Tail twitches, Approaches, 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
21	21	-73.9703781726172	40.778752613032104	16C-PM-1018-03	16C	PM	10182018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	6		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9703781726172 40.7787526130321)
154	154	-73.9686056085297	40.7781658424866	16E-AM-1014-03	16E	AM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9686056085297 40.7781658424866)
330	330	-73.9708969246276	40.7767695507462	14D-AM-1014-03	14D	AM	10142018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9708969246276 40.7767695507462)
418	418	-73.9573604880421	40.7930844158021	35E-PM-1006-03	35E	PM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9573604880421 40.7930844158021)
437	437	-73.9793952066038	40.7707837657859	4A-PM-1007-03	04A	PM	10072018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE	by rock	0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9793952066038 40.77078376578591)
548	548	-73.95846960832841	40.7980121226635	39B-PM-1014-03	39B	PM	10142018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9584696083284 40.7980121226635)
580	580	-73.97509925643621	40.7743391883762	10B-PM-1014-03	10B	PM	10142018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0	avoided people	POINT (-73.9750992564362 40.7743391883762)
636	636	-73.97575361873191	40.775511981067794	11A-PM-1013-03	11A	PM	10132018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9757536187319 40.7755119810678)
723	723	-73.9654397484763	40.7798863522904	19F-PM-1017-03	19F	PM	10172018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9654397484763 40.7798863522904)
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)
830	830	-73.95956459625391	40.7899599350145	31E-PM-1006-03	31E	PM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	under bushes	0	0	0	1	1	burying	0	0	0	0	0	0	1	0		POINT (-73.9595645962539 40.7899599350145)
954	954	-73.96584435488221	40.7796704898979	19F-AM-1007-03	19F	AM	10072018	3	Juvenile	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0	scared	POINT (-73.9658443548822 40.7796704898979)
992	992	-73.97080835874709	40.782542944158294	19A-PM-1013-03	19A	PM	10132018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9708083587471 40.7825429441583)
1018	1018	-73.96953055553921	40.7757541971012	13F-PM-1008-03	13F	PM	10082018	3	Adult	Gray		Gray+		Above Ground	15	tree	0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9695305555392 40.7757541971012)
1021	1021	-73.97186968288	40.778926988884	15B-AM-1014-03	15B	AM	10142018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	1	running (from a dog)	0	0	0	0	0	0	1	0		POINT (-73.97186968288 40.778926988884)
1167	1167	-73.9593244415072	40.794964729747	36C-PM-1013-03	36C	PM	10132018	3	Adult	Gray		Gray+		Ground Plane	FALSE	Clearing near bike path (bikes active)	0	1	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9593244415072 40.794964729747)
1242	1242	-73.9714512125212	40.77602752501139	13D-PM-1018-03	13D	PM	10182018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9714512125212 40.7760275250114)
1289	1289	-73.97246812695259	40.7743474675821	11D-PM-1006-03	11D	PM	10062018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9724681269526 40.7743474675821)
1473	1473	-73.9584064190878	40.7912992852442	33F-PM-1012-03	33F	PM	10122018	3	Adult	Black	Gray	Black+Gray		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9584064190878 40.7912992852442)
1494	1494	-73.95257524081691	40.7954915417553	39H-AM-1007-03	39H	AM	10072018	3	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9525752408169 40.7954915417553)
1513	1513	-73.96624099976421	40.789104293543204	28A-PM-1007-03	28A	PM	10072018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	1	0	1	1	chasing #2 took #2 food wrapper and is foraging through it	0	0	0	0	0	0	1	0		POINT (-73.9662409997642 40.7891042935432)
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)
1669	1669	-73.9691821206863	40.776320316433896	14F-PM-1012-03	14F	PM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9691821206863 40.7763203164339)
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)
1681	1681	-73.9638141923763	40.782922532628795	23F-PM-1013-03	23F	PM	10132018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0	indifferent (noticed me,busy eating,foraging)	POINT (-73.9638141923763 40.7829225326288)
1981	1981	-73.972154069981	40.769012800972206	6G-AM-1008-03	06G	AM	10082018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE	grass	0	0	0	1	1		0	0	0	1	0	0	1	0		POINT (-73.972154069981 40.7690128009722)
2109	2109	-73.9744488584414	40.7741627220859	10C-PM-1013-03	10C	PM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9744488584414 40.7741627220859)
2124	2124	-73.97300395815209	40.7730688398468	9E-PM-1014-03	09E	PM	10142018	3	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE	underneath a tree	0	0	0	1	1		0	0	0	0	1	0	0	0		POINT (-73.9730039581521 40.7730688398468)
2127	2127	-73.9562442622553	40.7957285542564	38E-AM-1010-03	38E	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9562442622553 40.7957285542564)
2184	2184	-73.9694938608335	40.7745700102115	12F-PM-1007-03	12F	PM	10072018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9694938608335 40.7745700102115)
2253	2253	-73.973394428186	40.7722933513053	8E-PM-1008-03	08E	PM	10082018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE	in between 2 trees	0	0	0	1	1		0	0	0	0	0	1	0	0	also being lured by mom & baby w/ food	POINT (-73.973394428186 40.7722933513053)
2290	2290	-73.95656457165641	40.795903994957705	38D-PM-1006-03	38D	PM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9565645716564 40.795903994957705)
2428	2428	-73.9755643404768	40.769756914938796	5E-PM-1012-03	05E	PM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9755643404768 40.7697569149388)
2471	2471	-73.964274290774	40.779531955602295	19H-AM-1010-03	19H	AM	10102018	3	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	0	0	1	0	ran from human w/ dog	POINT (-73.964274290774 40.7795319556023)
2485	2485	-73.9584950620879	40.790277071064295	32F-PM-1008-03	32F	PM	10082018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	1	1	1	1		0	0	0	0	0	0	1	0		POINT (-73.9584950620879 40.7902770710643)
2589	2589	-73.9694166642262	40.7697788641081	8I-PM-1013-03	08I	PM	10132018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9694166642262 40.7697788641081)
2736	2736	-73.95938952535009	40.797308584408704	38B-AM-1019-03	38B	AM	10192018	3	Juvenile	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9593895253501 40.7973085844087)
2871	2871	-73.9777124331985	40.7704051056666	5B-AM-1008-03	05B	AM	10082018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9777124331985 40.7704051056666)
2903	2903	-73.9670432105975	40.7753462013506	14H-PM-1012-03	14H	PM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	20		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9670432105975 40.7753462013506)
2957	2957	-73.97473131521521	40.7653888351839	1G-PM-1010-03	01G	PM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9747313152152 40.7653888351839)

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