2018_Central_Park_Squirrel_Census_-_Squirrel_Data

268 rows where Highlight Fur Color = "Cinnamon, White" sorted by Other Interactions

View and edit SQL

Tail twitches

  • 0 54
  • 1 14

Highlight Fur Color

  • Cinnamon, White · 68
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
2500 -73.9689703880705 40.7712025611298 9I-PM-1010-02 09I PM 10102018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White standard coloration Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.96897038807052 40.7712025611298)
2508 -73.97938145045201 40.770903369788705 4A-PM-1007-01 04A PM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 1 1   0 0 0 0 1 0 1 0   POINT (-73.979381450452 40.770903369788705)
2510 -73.9748635473782 40.7742591029151 10C-AM-1018-02 10C AM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0 sitting in the sun 0 0 0 0 0 0 1 0   POINT (-73.9748635473782 40.7742591029151)
2511 -73.95845615374209 40.791121116475395 33F-PM-1012-02 33F PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 1 0 0 0   POINT (-73.9584561537421 40.7911211164754)
2556 -73.96398284313679 40.7910151996207 30B-PM-1019-09 30B PM 10192018 9 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9639828431368 40.7910151996207)
2568 -73.9779039082557 40.7675313108314 2D-PM-1012-01 02D PM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9779039082557 40.7675313108314)
2579 -73.96981304525809 40.7745000645436 12F-PM-1007-15 12F PM 10072018 15 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.9698130452581 40.7745000645436)
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)
2600 -73.9544553697736 40.7912866208106 34I-AM-1012-01 34I AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9544553697736 40.7912866208106)
2610 -73.9713379914423 40.7696367609606 7H-PM-1006-01 07H PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE middle of grass 0 0 0 1 1   0 0 0 0 1 1 0 0   POINT (-73.9713379914423 40.7696367609606)
2631 -73.9690080105286 40.7710230515054 9I-PM-1010-03 09I PM 10102018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White         0 0 0 0 1   0 0 0 0 0 0 1 1   POINT (-73.9690080105286 40.7710230515054)
2644 -73.97754454411941 40.7697096533728 4C-PM-1010-13 04C PM 10102018 13 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9775445441194 40.7697096533728)
2653 -73.958932543729 40.7913445531266 33E-AM-1014-11 33E AM 10142018 11 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.958932543729 40.7913445531266)
2655 -73.9659156108069 40.781070981869604 20E-AM-1014-01 20E AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9659156108069 40.7810709818696)
2661 -73.9693841004072 40.770414865829395 8I-PM-1013-06 08I PM 10132018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9693841004072 40.7704148658294)
2673 -73.9768867959365 40.7734803954589 8B-PM-1012-01 08B PM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9768867959365 40.7734803954589)
2685 -73.9601851468038 40.7968698151479 38A-AM-1019-05 38A AM 10192018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon head, White belly Ground Plane FALSE   0 0 0 0 1 standing on back legs 0 0 0 0 0 1 1 0   POINT (-73.9601851468038 40.7968698151479)
2687 -73.9550235589287 40.7951312356844 38F-AM-1018-03 38F AM 10182018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9550235589287 40.7951312356844)
2733 -73.9690082314914 40.7738993942891 12G-AM-1012-05 12G AM 10122018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0   1 0 0 0 0 0 0 1   POINT (-73.9690082314914 40.7738993942891)
2760 -73.9701808122548 40.7744632730919 12F-PM-1007-11 12F PM 10072018 11 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9701808122548 40.7744632730919)
2776 -73.9789687905912 40.769269313932796 3B-PM-1007-04 03B PM 10072018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 At fence 1 0 1 1 0   0 0 0 0 1 0 1 1   POINT (-73.9789687905912 40.7692693139328)
2785 -73.9729105002306 40.7672758037086 4H-PM-1006-02 04H PM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9729105002306 40.7672758037086)
2806 -73.9714298880357 40.774105786890004 11E-PM-1012-02 11E PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9714298880357 40.77410578689)
2821 -73.97545365660129 40.769860491877104 5E-PM-1012-04 05E PM 10122018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9754536566013 40.7698604918771)
2829 -73.95652309635541 40.798556387711 41C-PM-1007-02 41C PM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9565230963554 40.798556387711)
2849 -73.9709912560997 40.77589655951979 13D-AM-1014-01 13D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9709912560997 40.7758965595198)
2856 -73.9751615527833 40.767013871509 3F-AM-1006-03 03F AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Ground Plane FALSE on the path 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9751615527833 40.767013871509)
2858 -73.9728723853967 40.7670816164986 4H-PM-1006-01 04H PM 10062018 1 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.9728723853967 40.7670816164986)
2863 -73.9698246369929 40.7711472794488 9H-AM-1006-04 09H AM 10062018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9698246369929 40.7711472794488)
2873 -73.955068474109 40.79117881528779 34H-PM-1006-05 34H PM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White white tail tip Ground Plane FALSE in grass 1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.955068474109 40.7911788152878)
2898 -73.97941182346509 40.767449554056896 1C-AM-1012-02 01C AM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9794118234651 40.7674495540569)
2901 -73.9735833104203 40.7786318041581 14A-PM-1014-08 14A PM 10142018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1 new movement flailing arms while foraging 0 0 0 0 0 0 0 1   POINT (-73.9735833104203 40.7786318041581)
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)
2905 -73.9784872728213 40.768812260393204 3C-AM-1007-01 03C AM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9784872728213 40.7688122603932)
2916 -73.95175251116791 40.7974407641075 42G-PM-1014-02 42G PM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 14   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9517525111679 40.7974407641075)
2922 -73.97034213914421 40.7773706575356 14D-AM-1014-01 14D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9703421391442 40.7773706575356)
2931 -73.9730926233232 40.7781330751738 14B-PM-1014-08 14B PM 10142018 8   Gray Cinnamon, White Gray+Cinnamon, White White belly & stripes on tail, Cinnamon face & stripes on back Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9730926233232 40.7781330751738)
2977 -73.95806816485471 40.799201001265295 41B-AM-1010-01 41B AM 10102018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9580681648547 40.7992010012653)
3000 -73.9688293382172 40.7738958027568 12G-AM-1012-04 12G AM 10122018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9688293382172 40.773895802756805)
3001 -73.97755922284159 40.7668485329273 1D-PM-1007-01 01D PM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9775592228416 40.7668485329273)
3002 -73.9710991846972 40.768982782424104 6H-PM-1020-01 06H PM 10202018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9710991846972 40.7689827824241)
3013 -73.964661337306 40.7769785494935 17I-AM-1014-03 17I AM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon face Above Ground 10   0 0 1 0 0 climbing (dog barked & it ran up tree) 0 0 0 0 0 0 1 0   POINT (-73.964661337306 40.7769785494935)
3015 -73.97591633005351 40.7736180793606 9B-AM-1010-08 09B AM 10102018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon head, White (Almost Silver) Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9759163300535 40.7736180793606)
3017 -73.9662895079734 40.7843300758044 23C-AM-1019-01 23C AM 10192018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray, Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 7   0 0 1 1 0 eating (on branch) 1 0 0 0 0 0 1 0   POINT (-73.9662895079734 40.7843300758044)
3022 -73.9639941227864 40.7899152327912 29B-PM-1010-02 29B PM 10102018 2   Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9639941227864 40.7899152327912)
2879 -73.9744080700098 40.773151572182606 9C-PM-1006-07 09C PM 10062018 7 Adult Black Cinnamon, White Black+Cinnamon, White   Ground Plane FALSE on top of tarped sand pile 0 0 0 1 0   0 0 0 0 0 0 0 1 (me) POINT (-73.9744080700098 40.7731515721826)
1432 -73.9632577850183 40.793112839016 33A-AM-1008-01 33A AM 10082018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0 acknowledged POINT (-73.9632577850183 40.793112839016)
2068 -73.9735587560787 40.7672346255151 3G-PM-1013-02 03G PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 0 wandering,interacting with tourists 0 0 0 0 0 1 0 0 approaches (father - son taking photos,talking about giving him planters peanuts) POINT (-73.9735587560787 40.7672346255151)
482 -73.97217978245759 40.7801213843628 16A-PM-1019-07 16A PM 10192018 7 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 0 0 approaches (very friendly) POINT (-73.9721797824576 40.7801213843628)
362 -73.9571407991577 40.793191739640605 35E-PM-1006-02 35E PM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0 begging for food POINT (-73.9571407991577 40.7931917396406)
1048 -73.9782120139407 40.7717154468791 6A-AM-1006-05 06A AM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 tree 0 0 1 0 0   0 0 0 1 1 0 0 0 curious POINT (-73.9782120139407 40.7717154468791)
131 -73.9755560786227 40.7662992317575 2F-AM-1006-05 02F AM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0 curious but shy POINT (-73.9755560786227 40.7662992317575)
782 -73.9710559113762 40.779427991420896 16C-PM-1018-01 16C PM 10182018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 3   0 0 1 0 0   0 0 0 0 0 0 0 0 disappeared up other side of tree POINT (-73.9710559113762 40.7794279914209)
340 -73.97449608298442 40.7652585501959 1H-AM-1012-01 01H AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 1 first approaches then runs from - he was less than 1 yd. away from me. POINT (-73.9744960829844 40.7652585501959)
2862 -73.967466716152 40.782434654827796 21D-PM-1008-04 21D PM 10082018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4   0 0 0 1 0   0 0 0 0 0 0 0 1 i scared it POINT (-73.967466716152 40.7824346548278)
2770 -73.96379835137891 40.7828712516396 23F-PM-1013-04 23F PM 10132018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary: "much browner, like 1/2 & 1/2". Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0 indifferent (busy foraging) POINT (-73.9637983513789 40.7828712516396)
1108 -73.96383977903841 40.782895027290394 23F-PM-1013-02 23F PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 1 0 0 1 0 1 0 indifferent (mostly,did notice me,busy eating,foraging) POINT (-73.9638397790384 40.7828950272904)
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)
187 -73.9700162034073 40.7815277479588 19B-AM-1019-02 19B AM 10192018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 0 posing 0 0 0 0 0 0 1 1 indifferent then runs from POINT (-73.9700162034073 40.7815277479588)
804 -73.9697196619878 40.7814068507607 19B-AM-1019-01 19B AM 10192018 1 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Side stripes Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 1 indifferent then runs from POINT (-73.9697196619878 40.7814068507607)
162 -73.957219204335 40.7931529059779 35E-PM-1006-01 35E PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0 looking/begging for food POINT (-73.957219204335 40.7931529059779)
2333 -73.9771924901559 40.766672272947105 1E-PM-1007-01 01E PM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0 people feeding squirrel POINT (-73.9771924901559 40.7666722729471)
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)
1330 -73.9643032554205 40.7794514526463 19H-AM-1010-02 19H AM 10102018 2   Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE near base of small tree 1 0 0 1 1   0 0 0 1 0 1 0 0 ran from human with dog POINT (-73.9643032554205 40.7794514526463)
2163 -73.9643664403785 40.77936707037271 19H-AM-1010-01 19H AM 10102018 1   Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE near base of small tree 1 0 0 1 1   0 0 0 0 0 0 1 0 run from human w/ dog POINT (-73.9643664403785 40.7793670703727)
1180 -73.9639726817977 40.7829083461049 23F-PM-1013-01 23F PM 10132018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (dove into some bushes/undergrowth,only saw briefly! → not because of humans tho.) POINT (-73.9639726817977 40.7829083461049)
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)
1335 -73.969560591279 40.7705619840715 8I-AM-1006-09 08I AM 10062018 9 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0 very curious,looked like it expected food POINT (-73.969560591279 40.7705619840715)

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