2018_Central_Park_Squirrel_Census_-_Squirrel_Data

44 rows where Above Ground Sighter Measurement = 20 and Shift = "PM" sorted by Primary Fur Color

View and edit SQL

Suggested facets: Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Specific Location, Running, Chasing, Climbing, Eating, Kuks, Quaas, Tail flags, Tail twitches, Indifferent, Runs from

Hectare Squirrel Number

Foraging

  • 0 35
  • 1 9
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
1554 -73.95974626120629 40.783280114530605 25I-PM-1007-06 25I PM 10072018 6       + Didn't see squirrel size, or colors Above Ground 20 up in tree 0 0 0 0 0   0 1 0 0 0 0 0 0   POINT (-73.9597462612063 40.7832801145306)
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)
695 -73.96850806398729 40.774530979415495 13G-PM-1008-03 13G PM 10082018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 20 maple tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9685080639873 40.77453097941551)
1572 -73.9540197079615 40.798039260982996 41E-PM-1013-03 41E PM 10132018 3 Adult Cinnamon Gray, White Cinnamon+Gray, White Gray on legs Above Ground 20   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9540197079615 40.798039260983)
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)
113 -73.9700100617602 40.7815739959357 19B-PM-1018-01 19B PM 10182018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Above Ground 20   1 0 0 0 0 flying 0 0 0 0 0 0 0 0   POINT (-73.9700100617602 40.7815739959357)
306 -73.96897001002671 40.7775169562765 15E-PM-1008-05 15E PM 10082018 5 Adult Gray   Gray+   Above Ground 20   0 0 0 0 0 sitting 0 1 0 0 0 0 0 0   POINT (-73.9689700100267 40.7775169562765)
444 -73.96414623605409 40.7778316005464 18I-PM-1007-09 18I PM 10072018 9 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0 canoodling w/ 8 0 0 0 0 0 0 1 0   POINT (-73.9641462360541 40.7778316005464)
673 -73.958417813526 40.792730121447605 34E-PM-1006-01 34E PM 10062018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Above Ground 20   0 0 0 0 0 sitting and watching on a tree 0 0 0 0 0 0 1 0   POINT (-73.958417813526 40.7927301214476)
953 -73.9547959269955 40.7925162926273 36H-PM-1008-01 36H PM 10082018 1 Adult Gray White Gray+White white belly Above Ground 20   1 0 1 0 1   1 1 0 0 0 0 1 0   POINT (-73.9547959269955 40.7925162926273)
1123 -73.9670858934045 40.7753505024976 14H-PM-1012-02 14H PM 10122018 2 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.9670858934045 40.7753505024976)
1148 -73.9707339200738 40.7796333355689 17C-PM-1013-03 17C PM 10132018 3 Adult Gray   Gray+   Above Ground 20 in a tree 0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9707339200738 40.7796333355689)
1300 -73.964280573021 40.777830911491 18I-PM-1007-08 18I PM 10072018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 1 1 0 0 canoodling w/ #9 0 0 0 0 0 0 1 0   POINT (-73.964280573021 40.777830911491)
1301 -73.95521466657141 40.7892909102377 32I-PM-1007-03 32I PM 10072018 3 Adult Gray   Gray+ small adult Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9552146665714 40.7892909102377)
1333 -73.9754527701832 40.7656088463928 1G-PM-1010-02 01G PM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 0 0 0 laying on tree branch 0 0 0 1 1 0 0 0   POINT (-73.9754527701832 40.7656088463928)
1338 -73.9716624574422 40.776203711010105 13D-PM-1018-07 13D PM 10182018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   1 0 1 0 0 scratching 0 0 0 0 0 0 1 0   POINT (-73.9716624574422 40.7762037110101)
1371 -73.9542733797804 40.795578653743 39F-PM-1006-02 39F PM 10062018 2 Adult Gray   Gray+   Above Ground 20 tree 0 0 0 0 0   0 0 0 0 0 0 0 1 ran up tree when approached POINT (-73.9542733797804 40.795578653743)
1466 -73.96511776576759 40.7812408103825 20F-PM-1007-05 20F PM 10072018 5 Juvenile Gray White Gray+White white tail Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9651177657676 40.781240810382506)
1503 -73.97321932906308 40.7748791447746 11D-PM-1006-01 11D PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9732193290631 40.7748791447746)
1504 -73.97065861080058 40.779635744447106 17C-PM-1013-02 17C PM 10132018 2 Adult Gray   Gray+   Above Ground 20 in a tree 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9706586108006 40.7796357444471)
1506 -73.9728339757306 40.7782891207966 14B-PM-1014-04 14B PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20 running up and down 0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9728339757306 40.7782891207966)
1508 -73.96938943057859 40.775690674802604 13F-PM-1008-04 13F PM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9693894305786 40.7756906748026)
1574 -73.95618409358029 40.799203782149704 42C-PM-1013-05 42C PM 10132018 5 Adult Gray   Gray+   Above Ground 20   0 0 0 1 0   1 0 0 0 0 0 1 0   POINT (-73.9561840935803 40.7992037821497)
1641 -73.96531352771491 40.7817434070169 21E-PM-1012-01 21E PM 10122018 1 Adult Gray   Gray+   Above Ground 20 in tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9653135277149 40.7817434070169)
1807 -73.9581366214863 40.7988964092722 40B-PM-1014-02 40B PM 10142018 2 Adult Gray   Gray+   Above Ground 20   0 0 1 0 0   1 1 0 0 0 0 0 1   POINT (-73.9581366214863 40.7988964092722)
1857 -73.9728797531377 40.778673314868705 15B-PM-1017-01 15B PM 10172018 1   Gray   Gray+   Above Ground 20 in tree 0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9728797531377 40.7786733148687)
1925 -73.95813898706442 40.7993081122523 41A-PM-1007-04 41A PM 10072018 4 Adult Gray   Gray+   Above Ground 20   1 0 1 0 0 laid down on the branch 0 0 0 0 0 0 0 1   POINT (-73.9581389870644 40.799308112252305)
1999 -73.95498609472341 40.79115503283089 34H-PM-1006-07 34H PM 10062018 7 Juvenile Gray White Gray+White white belly Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9549860947234 40.7911550328309)
2010 -73.9673821557469 40.7786375267659 17F-PM-1020-06 17F PM 10202018 6 Adult Gray   Gray+   Above Ground 20   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.96738215574692 40.7786375267659)
2069 -73.9538377039825 40.798060533496106 42E-PM-1012-03 42E PM 10122018 3 Adult Gray White Gray+White   Above Ground 20 in tree 0 0 1 0 1   1 0 0 0 0 0 1 0   POINT (-73.9538377039825 40.7980605334961)
2128 -73.9757673193743 40.7669614322613 2F-PM-1014-04 02F PM 10142018 4 Adult Gray   Gray+   Above Ground 20   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9757673193743 40.766961432261304)
2145 -73.96512504025829 40.7812884929069 20F-PM-1007-04 20F PM 10072018 4 Juvenile Gray White Gray+White white on tail Above Ground 20 climbed tree 0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9651250402583 40.7812884929069)
2251 -73.9587678566254 40.7962656030995 38C-PM-1014-01 38C PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   0 0 1 0 0   1 0 0 0 0 0 0 0   POINT (-73.9587678566254 40.7962656030995)
2335 -73.9704679459444 40.7773384236212 14D-PM-1019-10 14D PM 10192018 10 Adult Gray   Gray+   Above Ground 20   0 0 1 0 0   0 0 0 1 0 0 0 1   POINT (-73.9704679459444 40.7773384236212)
2368 -73.9731925179247 40.7748962746181 11D-PM-1006-02 11D PM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9731925179247 40.7748962746181)
2390 -73.9680741975294 40.7847036778165 23B-PM-1012-04 23B PM 10122018 4 Adult Gray White Gray+White   Above Ground 20   0 0 0 0 0 watching me - didn't move 0 0 0 0 1 0 0 1   POINT (-73.9680741975294 40.7847036778165)
2436 -73.95827701417 40.785661023889105 28I-PM-1007-01 28I PM 10072018 1 Adult Gray   Gray+   Above Ground 20   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.95827701417 40.7856610238891)
2443 -73.96670731869591 40.7840581361598 23C-PM-1014-01 23C PM 10142018 1 Adult Gray   Gray+   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.96670731869591 40.7840581361598)
2683 -73.972179947936 40.7810042827198 17A-PM-1013-02 17A PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20 on a little pedestal-shaped part of a tree 0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.972179947936 40.7810042827198)
2700 -73.9601988871514 40.7943473161329 35C-PM-1013-01 35C PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 1   1 1 0 1 1 0 1 0   POINT (-73.9601988871514 40.7943473161329)
2730 -73.96535757586871 40.78053399533721 20F-PM-1007-12 20F PM 10072018 12 Adult Gray White Gray+White   Above Ground 20 in tree 0 0 1 1 0   0 0 0 0 0 0 0 0   POINT (-73.9653575758687 40.7805339953372)
2786 -73.9683883750097 40.7754344396847 13G-PM-1008-01 13G PM 10082018 1 Juvenile Gray   Gray+   Above Ground 20 willow oak tree 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9683883750097 40.7754344396847)
2877 -73.9730027200009 40.7798000868804 16A-PM-1019-05 16A PM 10192018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9730027200009 40.7798000868804)
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)

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 164.467ms