2018_Central_Park_Squirrel_Census_-_Squirrel_Data

66 rows where Foraging = 0, Hectare Squirrel Number = 2 and Highlight Fur Color = "Cinnamon" sorted by Color notes

✎ View and edit SQL

This data as json, CSV (advanced)

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

Highlight Fur Color ✖

  • Cinnamon · 66 ✖

Hectare Squirrel Number ✖

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
6 6 -73.9565700386162 40.7902561000937 33H-AM-1019-02 33H AM 10192018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 wrestling with mother 0 0 0 0 0 0 0 0   POINT (-73.9565700386162 40.7902561000937)
43 43 -73.9574648097543 40.7892508428622 31H-PM-1008-02 31H PM 10082018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   1 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9574648097543 40.78925084286221)
158 158 -73.9710991123992 40.77238897266471 9F-PM-1014-02 09F PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9710991123992 40.7723889726647)
169 169 -73.97487064155841 40.7744174965072 10B-AM-1006-02 10B AM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   High in a tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9748706415584 40.7744174965072)
234 234 -73.9741401377844 40.7758134257881 12B-AM-1007-02 12B AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9741401377844 40.7758134257881)
250 250 -73.97267476660019 40.77030226693079 7F-AM-1008-02 07F AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 see stories and locations POINT (-73.9726747666002 40.7703022669308)
251 251 -73.95708175790921 40.7964221087879 38D-AM-1017-02 38D AM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 hiding in log 0 0 0 0 0 0 1 0   POINT (-73.9570817579092 40.7964221087879)
368 368 -73.970315671921 40.77209053954721 10G-PM-1017-02 10G PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.970315671921 40.7720905395472)
372 372 -73.9781303869038 40.7725000348875 7A-AM-1006-02 07A AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8 in tree 0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9781303869038 40.7725000348875)
374 374 -73.9556817958407 40.788852000621 32I-AM-1013-02 32I AM 10132018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0 watching me from tree - curious POINT (-73.9556817958407 40.788852000621)
419 419 -73.9777328709928 40.7669087724668 1D-AM-1006-02 01D AM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9777328709928 40.7669087724668)
438 438 -73.95257475169142 40.7977257435263 42F-PM-1017-02 42F PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 playing 0 0 0 0 0 0 1 0   POINT (-73.95257475169142 40.7977257435263)
450 450 -73.96442931957729 40.7813829172072 21F-AM-1018-02 21F AM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9644293195773 40.7813829172072)
484 484 -73.9666526554772 40.7756111718355 14H-AM-1007-02 14H AM 10072018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9666526554772 40.77561117183551)
503 503 -73.9598340783572 40.7915857030295 33D-PM-1006-02 33D PM 10062018 2   Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.95983407835722 40.7915857030295)
505 505 -73.9677387336667 40.774269591199996 12H-PM-1007-02 12H PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 in tree 0 0 1 1 0 peanuts 0 0 0 0 0 0 1 0   POINT (-73.9677387336667 40.7742695912)
553 553 -73.9638526062093 40.782693848993 22F-AM-1007-02 22F AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 standing 0 0 0 0 0 0 1 0   POINT (-73.9638526062093 40.782693848993)
650 650 -73.98096101171708 40.7683896665502 2A-AM-1010-02 02A AM 10102018 2   Gray Cinnamon Gray+Cinnamon   Above Ground   perched on small fence 0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9809610117171 40.7683896665502)
657 657 -73.9679008849677 40.7759013923034 14G-AM-1012-02 14G AM 10122018 2   Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9679008849677 40.7759013923034)
680 680 -73.95640114211221 40.7958097849369 38E-AM-1010-02 38E AM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0 climbs POINT (-73.95640114211221 40.7958097849369)
738 738 -73.9725712588741 40.7669101832926 4H-AM-1006-02 04H AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0 climbing (over small wire fence then on the ground) 0 0 0 0 0 1 0 1 approaches (saw me & came forward),runs from (startled by another person) POINT (-73.9725712588741 40.7669101832926)
767 767 -73.9655734633649 40.7805366922231 20F-AM-1014-02 20F AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   0 0 1 0 0 pulling leaves 1 0 0 0 0 0 0 0   POINT (-73.9655734633649 40.7805366922231)
797 797 -73.969345754447 40.7770429650288 15E-AM-1013-02 15E AM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   1 0 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.969345754447 40.7770429650288)
808 808 -73.97168818386709 40.778553537087 15C-PM-1017-02 15C PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 0   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9716881838671 40.778553537087)
883 883 -73.95655337834991 40.7974368491287 40D-PM-1013-02 40D PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9565533783499 40.7974368491287)
993 993 -73.97724226646571 40.773436329163 8A-AM-1013-02 08A AM 10132018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE playground 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9772422664657 40.773436329163)
1062 1062 -73.957259673402 40.7974442913898 39C-AM-1017-02 39C AM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.957259673402 40.7974442913898)
1064 1064 -73.9540257319561 40.798408619116 42E-PM-1012-02 42E PM 10122018 2 Juvenile Gray Cinnamon Gray+Cinnamon         1 0 1 0 0   0 0 0 0 0 0 1 1   POINT (-73.9540257319561 40.798408619116)
1168 1168 -73.9779874405715 40.7730765377366 7A-PM-1007-02 07A PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9779874405715 40.7730765377366)
1186 1186 -73.96740331258341 40.7769132902037 15G-PM-1019-02 15G PM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9674033125834 40.7769132902037)
1333 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)
1444 1444 -73.9763852372393 40.768876248561 4D-AM-1012-02 04D AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9763852372393 40.768876248561)
1451 1451 -73.9645365195454 40.778153102126296 18H-AM-1018-02 18H AM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   Tree 1 1 0 0 0 playing? 0 0 0 0 0 0 0 0   POINT (-73.9645365195454 40.7781531021263)
1515 1515 -73.9530326577312 40.7956922386395 39G-PM-1013-02 39G PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9530326577312 40.795692238639504)
1531 1531 -73.9630381400083 40.7807571827321 21H-PM-1018-02 21H PM 10182018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9630381400083 40.7807571827321)
1635 1635 -73.95607317386771 40.798033601855394 41D-PM-1014-02 41D PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9560731738677 40.7980336018554)
1668 1668 -73.97469348106671 40.7659431884158 2G-PM-1007-02 02G PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 burying nut 0 0 0 0 1 0 1 0   POINT (-73.9746934810667 40.7659431884158)
1698 1698 -73.9631392113757 40.791463563578404 31B-PM-1007-02 31B PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 1 1 0 0 chasing #1 and climbing tree w/ #1 0 0 0 0 0 0 0 1   POINT (-73.9631392113757 40.7914635635784)
1741 1741 -73.9736995552241 40.77227125186371 8E-PM-1008-02 08E PM 10082018 2 Adult Black Cinnamon Black+Cinnamon   Above Ground 10 in tree 1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9736995552241 40.7722712518637)
1884 1884 -73.9733898487296 40.7666975131518 3H-PM-1014-02 03H PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9733898487296 40.7666975131518)
1921 1921 -73.97562782402329 40.766952370137204 2F-AM-1006-02 02F AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 in tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9756278240233 40.7669523701372)
1949 1949 -73.9605362268777 40.7939470599346 35C-AM-1007-02 35C AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9605362268777 40.7939470599346)
1960 1960 -73.97301589136609 40.7701310707272 6F-PM-1008-02 06F PM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   1 1 0 0 0 chasing #2 0 0 0 0 0 0 0 0   POINT (-73.9730158913661 40.7701310707272)
1970 1970 -73.96314646937691 40.793415656751 33A-PM-1018-02 33A PM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 Tree cavity [of] London Plane tree 0 0 0 0 0 hanging out,watching world 0 0 0 0 0 0 0 0 watching POINT (-73.9631464693769 40.793415656751)
1990 1990 -73.9774584305147 40.770813398619204 5B-AM-1008-02 05B AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9774584305147 40.7708133986192)
2029 2029 -73.9687213827744 40.7843586374648 22B-PM-1014-02 22B PM 10142018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9687213827744 40.7843586374648)
2093 2093 -73.9597994674082 40.797298837759 38A-PM-1013-02 38A PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9597994674082 40.797298837759)
2137 2137 -73.96488316116292 40.780132641497296 19G-PM-1017-02 19G PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 patting ground 0 0 0 0 1 0 0 1   POINT (-73.9648831611629 40.7801326414973)
2320 2320 -73.9576897478787 40.796469532845705 38C-AM-1019-02 38C AM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9576897478787 40.7964695328457)
2337 2337 -73.9673490137465 40.778272813040104 17F-PM-1020-02 17F PM 10202018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9673490137465 40.7782728130401)
2368 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)
2380 2380 -73.97613757295049 40.766223189212496 1F-PM-1019-02 01F PM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9761375729505 40.7662231892125)
2426 2426 -73.9790203973636 40.768883711483205 3B-AM-1010-02 03B AM 10102018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 together w/ #3 0 0 0 0 0 0 0 1   POINT (-73.9790203973636 40.7688837114832)
2481 2481 -73.9719068478565 40.7789062312585 15B-AM-1014-02 15B AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 0 0 0 grooming,scratching 0 0 0 0 0 0 1 0   POINT (-73.9719068478565 40.7789062312585)
2543 2543 -73.96914249979191 40.780542852496 18C-AM-1018-02 18C AM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9691424997919 40.780542852496)
2626 2626 -73.9737329655838 40.7726424441344 8D-PM-1007-02 08D PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9737329655838 40.7726424441344)
2683 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)
2783 2783 -73.97917671562679 40.7714445258765 5A-AM-1006-02 05A AM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 12 in tall shrubs near wall next to CPW 0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9791767156268 40.7714445258765)
2796 2796 -73.96310890114121 40.789191946875 29C-PM-1006-02 29C PM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9631089011412 40.789191946875)
2968 2968 -73.9587236619579 40.799185018043396 40A-AM-1010-02 40A AM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE edge of park at 108th West 1 0 1 0 0   0 0 0 1 0 0 0 1   POINT (-73.9587236619579 40.7991850180434)
2979 2979 -73.9571808775915 40.793444386672505 35E-AM-1020-02 35E AM 10202018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   0 0 0 0 0 cleaning herself 0 0 0 0 0 0 1 0   POINT (-73.9571808775915 40.7934443866725)
1844 1844 -73.9682062012675 40.786498436192005 24A-AM-1014-02 24A AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon Blonde? in Highlights Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9682062012675 40.786498436192)
565 565 -73.9615402629655 40.7924082330328 33C-AM-1012-02 33C AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon Cinnamon along back & tail Above Ground 20 tree branches 0 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9615402629655 40.7924082330328)
209 209 -73.97107601968679 40.7725506006789 10F-PM-1019-02 10F PM 10192018 2 Juvenile Gray Cinnamon Gray+Cinnamon Cinnamon head & stripe Ground Plane FALSE Behind fence, grass 1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9710760196868 40.7725506006789)
615 615 -73.96532790698879 40.7758743113817 15I-AM-1008-02 15I AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon Could be same squirrel as #1? Above Ground 4 on fence 0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9653279069888 40.7758743113817)
555 555 -73.9685227310735 40.776599466588 15F-AM-1007-02 15F AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO Above Ground 20   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9685227310735 40.776599466588)

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