2018_Central_Park_Squirrel_Census_-_Squirrel_Data

31 rows where Foraging = 1, Hectare Squirrel Number = 4 and Runs from = 1 sorted by Tail twitches

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Kuks, Tail flags, Tail twitches, Approaches, Indifferent

Runs from ✖

Moans ✖

  • 0 31

Hectare Squirrel Number ✖

Foraging ✖

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
29 29 -73.96717867152559 40.7867352791232 25A-AM-1013-04 25A AM 10132018 4   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9671786715256 40.7867352791232)
88 88 -73.9683608295976 40.784292740532706 22B-AM-1013-04 22B AM 10132018 4 Adult Cinnamon   Cinnamon+   Ground Plane FALSE Under bench 0 0 0 0 1   0 0 0 0 0 0 0 1 ran from dog-walker POINT (-73.9683608295976 40.7842927405327)
108 108 -73.9574809028248 40.7950013620207 37D-PM-1014-04 37D PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 1 chasing (a chipmunk) 0 0 0 0 0 0 0 1   POINT (-73.9574809028248 40.7950013620207)
205 205 -73.9564724104048 40.7936055508162 36F-PM-1012-04 36F PM 10122018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9564724104048 40.7936055508162)
242 242 -73.9590236602085 40.798263245686606 40A-AM-1010-04 40A AM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE bottom great hill 0 0 0 0 1   0 0 0 1 0 0 1 1 dog chased POINT (-73.9590236602085 40.7982632456866)
245 245 -73.95894143392421 40.790707388827705 32E-PM-1017-04 32E PM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE treed area 0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9589414339242 40.7907073888277)
302 302 -73.9695176417703 40.7741725190048 12G-PM-1007-04 12G PM 10072018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9695176417703 40.7741725190048)
427 427 -73.9589367709165 40.78964653034829 31F-PM-1007-04 31F PM 10072018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9589367709165 40.7896465303483)
743 743 -73.9565035705619 40.7937382705056 36F-AM-1017-04 36F AM 10172018 4 Juvenile Gray White Gray+White White legs, front & back Ground Plane FALSE   1 0 0 1 1   1 0 0 0 0 1 0 1 approaches (me),runs from (me) POINT (-73.9565035705619 40.7937382705056)
914 914 -73.9760801742337 40.7674218954729 3E-AM-1006-04 03E AM 10062018 4 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9760801742337 40.7674218954729)
964 964 -73.9631045499811 40.790618096947206 30B-PM-1019-04 30B PM 10192018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.9631045499811 40.7906180969472)
968 968 -73.9689781843873 40.7709333833783 9I-PM-1010-04 09I PM 10102018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9689781843873 40.7709333833783)
1005 1005 -73.95582687317709 40.7952074193788 38E-PM-1014-04 38E PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE THICK UNDERGROWTH 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9558268731771 40.7952074193788)
1124 1124 -73.959516757215 40.7952545908471 36C-PM-1013-04 36C PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE On rock 1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.959516757215 40.7952545908471)
1617 1617 -73.97520295136441 40.767173466736104 3F-AM-1006-04 03F AM 10062018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE on a rock 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9752029513644 40.7671734667361)
1626 1626 -73.9617519095277 40.794717907138796 35A-PM-1013-04 35A PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE In the weeds by the pool 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9617519095277 40.7947179071388)
1809 1809 -73.96901686738441 40.777761204391396 15E-AM-1013-04 15E AM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9690168673844 40.7777612043914)
2011 2011 -73.9603245806655 40.79427124776971 35C-PM-1013-04 35C PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9603245806655 40.7942712477697)
2158 2158 -73.9597593485091 40.7937528403249 35C-AM-1007-04 35C AM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9597593485091 40.7937528403249)
2175 2175 -73.9657487923637 40.7786823090663 18G-PM-1013-04 18G PM 10132018 4 Adult Gray   Gray+   Above Ground 3   0 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.9657487923637 40.7786823090663)
2329 2329 -73.9717515173863 40.7747999274418 11D-PM-1006-04 11D PM 10062018 4 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9717515173863 40.7747999274418)
2366 2366 -73.96761918469849 40.777641740816996 16F-PM-1013-04 16F PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.9676191846985 40.777641740817)
2607 2607 -73.9642988690682 40.779559128197896 19H-AM-1010-04 19H AM 10102018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 1 runs from human w/ dog POINT (-73.9642988690682 40.7795591281979)
2828 2828 -73.9587439756541 40.7849006107353 27I-AM-1007-04 27I AM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 1   POINT (-73.9587439756541 40.7849006107353)
2934 2934 -73.9561669236168 40.799473743127706 42C-PM-1013-04 42C PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 1   POINT (-73.9561669236168 40.7994737431277)
2983 2983 -73.9689586689061 40.7839613907139 21B-PM-1017-04 21B PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9689586689061 40.7839613907139)
3005 3005 -73.96161411525391 40.7921803313341 33C-PM-1007-04 33C PM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9616141152539 40.7921803313341)
3012 3012 -73.96137019608979 40.7943363227822 35B-PM-1013-04 35B PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 0 1 got threatened by dog (same dog,dog #1) 0 0 0 0 0 0 0 1 runs from (dog) POINT (-73.9613701960898 40.7943363227822)
3019 3019 -73.9639431360458 40.7908677445466 30B-AM-1007-04 30B AM 10072018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9639431360458 40.7908677445466)
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)
2218 2218 -73.9694382427984 40.7846350692923 22A-AM-1008-04 22A AM 10082018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9694382427984 40.7846350692923)

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);
Powered by Datasette · Query took 201.863ms