2018_Central_Park_Squirrel_Census_-_Squirrel_Data

268 rows where Date = 10062018 and Tail twitches = 0 sorted by Age

✎ View and edit SQL

This data as json, CSV (advanced)

Tail twitches ✖

Date ✖

  • 10062018 · 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
2542 2542 -73.9754802138871 40.773300804411996 9C-PM-1006-03 09C PM 10062018 3 Adult Gray White Gray+White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9754802138871 40.773300804412)
2583 2583 -73.97696931406509 40.7684390015166 3D-AM-1006-01 03D AM 10062018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 9 up a tree 1 0 1 1 1 digging (?) 0 0 0 1 0 0 0 1 runs from (man led his dog into the area to chase squirrel) POINT (-73.9769693140651 40.7684390015166)
2605 2605 -73.97368963630059 40.767763086262605 4G-AM-1006-01 04G AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9736896363006 40.7677630862626)
2623 2623 -73.9604482901468 40.7898646293603 31E-PM-1006-07 31E PM 10062018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9604482901468 40.7898646293603)
2624 2624 -73.9706308500637 40.769617487459605 7H-PM-1006-10 07H PM 10062018 10 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9706308500637 40.7696174874596)
2635 2635 -73.97638367403421 40.7706121151491 5C-AM-1006-06 05C AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9763836740342 40.7706121151491)
2650 2650 -73.9538251716292 40.7919360198175 35I-PM-1006-01 35I PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9538251716292 40.7919360198175)
2677 2677 -73.97348276186 40.7656171832911 2H-PM-1006-02 02H PM 10062018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.97348276186 40.7656171832911)
2709 2709 -73.97750689157151 40.7664424394736 1E-AM-1006-01 01E AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9775068915715 40.7664424394736)
2726 2726 -73.9734206435334 40.7657854684194 2H-PM-1006-01 02H PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9734206435334 40.7657854684194)
2741 2741 -73.9545877741228 40.79000012103529 33I-PM-1006-01 33I PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9545877741228 40.7900001210353)
2750 2750 -73.957775998085 40.7932880937406 35E-PM-1006-05 35E PM 10062018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.957775998085 40.7932880937406)
2755 2755 -73.9712022111028 40.767250436826295 4I-AM-1006-01 04I AM 10062018 1 Adult Black   Black+   Above Ground 3 On top of park lamp 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9712022111028 40.7672504368263)
2785 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)
2792 2792 -73.97237364945971 40.766950134329704 4H-AM-1006-01 04H AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9723736494597 40.7669501343297)
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)
2811 2811 -73.97568897660891 40.7676078308589 3F-AM-1006-14 03F AM 10062018 14 Adult Gray White Gray+White   Above Ground 12   1 0 1 0 0 running from dog 0 0 0 0 0 0 0 1   POINT (-73.9756889766089 40.7676078308589)
2814 2814 -73.9551625272308 40.791193071916 34H-PM-1006-06 34H PM 10062018 6 Adult Gray   Gray+   Ground Plane FALSE in grass 1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9551625272308 40.791193071916)
2842 2842 -73.9579292340076 40.7976287835027 39C-PM-1006-04 39C PM 10062018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9579292340076 40.7976287835027)
2847 2847 -73.9568378330302 40.788031780276604 30I-PM-1006-04 30I PM 10062018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9568378330302 40.7880317802766)
2856 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 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 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)
2870 2870 -73.9538475741188 40.796479421955 40F-PM-1006-02 40F PM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9538475741188 40.796479421955)
2873 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)
2879 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)
2895 2895 -73.9747873899653 40.77319452583271 9C-PM-1006-04 09C PM 10062018 4 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9747873899653 40.7731945258327)
2909 2909 -73.9564478909357 40.79769287754171 40C-PM-1006-04 40C PM 10062018 4 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9564478909357 40.7976928775417)
2911 2911 -73.9793923984874 40.770847547458295 5A-AM-1006-01 05A AM 10062018 1 Adult Gray   Gray+   Above Ground 10 Oak tree near rock outcropping 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.97939239848742 40.7708475474583)
2928 2928 -73.9767953468937 40.7676376977667 3E-AM-1006-03 03E AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 checkin' his stashes 0 0 0 1 0 1 0 1   POINT (-73.9767953468937 40.7676376977667)
2958 2958 -73.9541748083177 40.795275844289705 39F-PM-1006-01 39F PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 carrying leaves 0 0 0 0 0 0 1 0   POINT (-73.9541748083177 40.7952758442897)
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)
254 254 -73.9762246600197 40.775164077652 10A-AM-1006-03 10A AM 10062018 3 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE Bridle Path lawn 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9762246600197 40.775164077652)
257 257 -73.9773317054464 40.7684035996758 3D-AM-1006-03 03D AM 10062018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE on top [of] a big rock/boulder in the area 1 0 1 0 0 climbing (rock) 0 0 0 0 0 1 0 0 approaches (slightly),wary of humans POINT (-73.9773317054464 40.76840359967581)
333 333 -73.9667560049684 40.7882333830729 27A-PM-1006-01 27A PM 10062018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   on a tree 0 0 0 1 1 walking up & down branches 0 0 0 0 0 0 1 0   POINT (-73.9667560049684 40.7882333830729)
570 570 -73.9745227769788 40.7673618284782 3F-AM-1006-09 03F AM 10062018 9 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE in grass by light post 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9745227769788 40.76736182847821)
578 578 -73.9671306431211 40.783887015905705 22C-PM-1006-05 22C PM 10062018 5 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9671306431211 40.783887015905705)
754 754 -73.9563203089105 40.7906275357726 33G-PM-1006-01 33G PM 10062018 1 Juvenile Gray   Gray+   Above Ground 2   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9563203089105 40.7906275357726)
780 780 -73.9675472064204 40.7835947167436 22C-PM-1006-06 22C PM 10062018 6 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10 on tree 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9675472064204 40.7835947167436)
876 876 -73.96727895735371 40.7874778720268 26A-PM-1006-02 26A PM 10062018 2 Juvenile Gray   Gray+ injured Ground Plane FALSE   0 0 0 0 0 not moving 0 0 0 0 0 0 0 0   POINT (-73.96727895735371 40.7874778720268)
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)
1004 1004 -73.9670850805619 40.7833747810387 22C-PM-1006-01 22C PM 10062018 1 Juvenile Gray   Gray+   Ground Plane FALSE   1 1 0 0 0 for food 0 1 0 0 0 0 0 0   POINT (-73.9670850805619 40.7833747810387)
1107 1107 -73.95307395621309 40.7932034409546 37H-PM-1006-01 37H PM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1 from voice POINT (-73.95307395621312 40.7932034409546)
1172 1172 -73.9706929270645 40.77278411194239 10G-AM-1006-06 10G AM 10062018 6 Juvenile Gray   Gray+ skinny tail Ground Plane FALSE   0 1 0 0 0 chasing (#5) 1 0 0 0 0 0 0 0   POINT (-73.9706929270645 40.7727841119424)
1215 1215 -73.9728895595977 40.769937833229896 6F-AM-1006-01 06F AM 10062018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9728895595977 40.7699378332299)
1230 1230 -73.9790822606486 40.7714466633386 5A-AM-1006-03 05A AM 10062018 3 Juvenile Cinnamon   Cinnamon+   Above Ground 8   0 0 1 1 0   0 0 0 1 0 0 0 1   POINT (-73.9790822606486 40.7714466633386)
1243 1243 -73.97455562298549 40.767292104099795 3F-AM-1006-07 03F AM 10062018 7 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE close to tall tree & light post 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9745556229855 40.7672921040998)
1302 1302 -73.9704024529864 40.772925606388895 10G-AM-1006-04 10G AM 10062018 4 Juvenile Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0 chasing (#3) 1 0 0 0 0 0 0 0   POINT (-73.9704024529864 40.7729256063889)
1313 1313 -73.9671813866177 40.783864003203796 22C-PM-1006-04 22C PM 10062018 4 Juvenile Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9671813866177 40.7838640032038)
1523 1523 -73.9673103881521 40.78742674096179 26A-PM-1006-01 26A PM 10062018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9673103881521 40.7874267409618)
1555 1555 -73.9784942525972 40.767260000368296 1D-AM-1006-06 01D AM 10062018 6 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   1 0 0 0 0 tumbling 0 0 0 0 0 0 0 0   POINT (-73.9784942525972 40.7672600003683)
1596 1596 -73.96669451239221 40.7839956493194 22C-PM-1006-11 22C PM 10062018 11 Juvenile Gray   Gray+   Above Ground 13   0 0 1 0 0   1 0 0 0 0 0 0 0   POINT (-73.9666945123922 40.7839956493194)
1646 1646 -73.9669782832746 40.7841166727168 22C-PM-1006-13 22C PM 10062018 13 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9669782832746 40.7841166727168)
1685 1685 -73.96788229832741 40.7802960985637 18E-PM-1006-01 18E PM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9678822983274 40.7802960985637)
1756 1756 -73.9755041276839 40.7678213857557 3F-AM-1006-13 03F AM 10062018 13 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9755041276839 40.7678213857557)
1783 1783 -73.9730001080547 40.7678719218983 4G-AM-1006-05 04G AM 10062018 5 Juvenile Gray White Gray+White   Above Ground 20   0 0 1 0 0 climbing (tree) 0 0 0 0 0 0 1 0 indifferent—was in front of my face (we were on a bridge)! POINT (-73.9730001080547 40.7678719218983)
1999 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)
2223 2223 -73.9784863123685 40.7669225020831 1D-AM-1006-08 01D AM 10062018 8 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 45   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9784863123685 40.7669225020831)
2289 2289 -73.97458005923929 40.767356541975005 3F-AM-1006-08 03F AM 10062018 8 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE close to tall tree & light post 1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9745800592393 40.767356541975)
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)
2397 2397 -73.9704592500888 40.772962887933005 10G-AM-1006-03 10G AM 10062018 3 Juvenile Gray White Gray+White tuft on butt Above Ground 10   0 0 1 0 0   0 0 0 1 0 0 0 1   POINT (-73.9704592500888 40.772962887933)
2403 2403 -73.97778796352159 40.769359455673 4C-AM-1006-03 04C AM 10062018 3 Juvenile Gray   Gray+   Above Ground 10   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9777879635216 40.769359455673)
2425 2425 -73.9791141532217 40.7714888835416 5A-AM-1006-04 05A AM 10062018 4 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9791141532217 40.77148888354161)
2547 2547 -73.9743393747021 40.767634679832504 3F-AM-1006-12 03F AM 10062018 12 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9743393747021 40.7676346798325)
2590 2590 -73.9568524771058 40.7974664985551 40C-PM-1006-06 40C PM 10062018 6 Juvenile Gray   Gray+   Ground Plane FALSE By The Road 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9568524771058 40.7974664985551)
2671 2671 -73.97433690682541 40.7675726965985 3F-AM-1006-11 03F AM 10062018 11 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9743369068254 40.7675726965985)
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)
2854 2854 -73.9772908667333 40.7697207404744 4C-AM-1006-05 04C AM 10062018 5 Juvenile Gray White Gray+White   Above Ground 20   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9772908667333 40.7697207404744)

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