2018_Central_Park_Squirrel_Census_-_Squirrel_Data

82 rows where Approaches = 1 and Shift = "AM" sorted by Runs from

✎ View and edit SQL

This data as json, CSV (advanced)

Hectare Squirrel Number ✖

Eating ✖

  • 0 27
  • 1 7

Shift ✖

Approaches ✖

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
2044 2044 -73.97715523261991 40.7706917595308 5C-AM-1006-01 05C AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 1 0 0   0 0 0 1 0 1 0 0   POINT (-73.9771552326199 40.7706917595308)
2123 2123 -73.959874668294 40.7907004233491 32E-AM-1007-09 32E AM 10072018 9 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.959874668294 40.7907004233491)
2149 2149 -73.9691845420174 40.7707749899254 9I-AM-1014-03 09I AM 10142018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9691845420174 40.7707749899254)
2161 2161 -73.9715375915057 40.7751212088827 12D-AM-1013-01 12D AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9715375915057 40.7751212088827)
2196 2196 -73.96233563694321 40.7888693815168 29D-AM-1014-05 29D AM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Rocky area 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9623356369432 40.7888693815168)
2205 2205 -73.9594986107981 40.7840083040604 25I-AM-1012-03 25I AM 10122018 3 Adult Cinnamon   Cinnamon+   Above Ground 8 on turn, see map 1 1 0 1 0   0 0 0 0 1 1 0 0   POINT (-73.9594986107981 40.7840083040604)
2233 2233 -73.9754709117681 40.7681421869407 3E-AM-1006-08 03E AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9754709117681 40.7681421869407)
2275 2275 -73.96142184133559 40.793894505879294 34B-AM-1013-01 34B AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1 hopping 0 0 0 0 1 1 0 0   POINT (-73.9614218413356 40.7938945058793)
2284 2284 -73.9730181306326 40.779460132242704 16A-AM-1013-02 16A AM 10132018 2 Adult Black   Black+   Above Ground     0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9730181306326 40.7794601322427)
2332 2332 -73.9709797467807 40.776909571067904 14D-AM-1014-07 14D AM 10142018 7 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.9709797467807 40.7769095710679)
2453 2453 -73.9756105226696 40.7696531972655 5D-AM-1020-03 05D AM 10202018 3 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9756105226696 40.7696531972655)
2455 2455 -73.9577297187155 40.799225295679 41B-AM-1010-08 41B AM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 20   0 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9577297187155 40.799225295679)
2536 2536 -73.96850872880721 40.7779068128051 16E-AM-1014-01 16E AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 burying food 0 0 0 0 0 1 0 0   POINT (-73.9685087288072 40.7779068128051)
2586 2586 -73.9752965316933 40.775253857578896 10B-AM-1006-03 10B AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   In tree 0 0 1 0 0   0 0 0 0 1 1 0 0   POINT (-73.9752965316933 40.7752538575789)
2646 2646 -73.9772239251936 40.7731716665766 8A-AM-1013-05 08A AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   1 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9772239251936 40.7731716665766)
2685 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)
2816 2816 -73.9809342290598 40.7687265606227 2A-AM-1010-05 02A AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE base of tree with ~ 30 small birds all eating 0 0 0 1 1   0 0 0 0 1 1 1 0   POINT (-73.9809342290598 40.7687265606227)
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)
2922 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)
2932 2932 -73.9705837974358 40.775849484967296 13E-AM-1017-13 13E AM 10172018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE on rock 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.97058379743581 40.7758494849673)
2976 2976 -73.97240833205379 40.7744163768061 11D-AM-1010-08 11D AM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1 drinking 0 0 0 0 0 1 0 0   POINT (-73.9724083320538 40.7744163768061)
2998 2998 -73.97520792474191 40.775537697900205 11B-AM-1007-01 11B AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 1 0 0   POINT (-73.9752079247419 40.7755376979002)
232 232 -73.9624184586031 40.7921524868211 32B-AM-1017-03 32B AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 1 1 approaches (primarily),runs from (initially),follows POINT (-73.9624184586031 40.7921524868211)
340 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)
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)
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)
852 852 -73.9609704650925 40.7938786854735 34B-AM-1013-03 34B AM 10132018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   1 0 1 0 0 hopping 0 0 0 0 0 1 0 1   POINT (-73.9609704650925 40.7938786854735)
913 913 -73.9514111329059 40.797508587289705 42G-AM-1018-01 42G AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 1   POINT (-73.9514111329059 40.797508587289705)
1075 1075 -73.9640534906634 40.777738389983604 17I-AM-1014-02 17I AM 10142018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0 standing upright 0 0 0 0 0 1 0 1 runs from (only ran away when a grandpa chased it off) POINT (-73.9640534906634 40.7777383899836)
1294 1294 -73.9604089940153 40.7910028063138 32D-AM-1013-04 32D AM 10132018 4 Adult Cinnamon   Cinnamon+ Brown legs Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 1 0 1   POINT (-73.9604089940153 40.7910028063138)
1721 1721 -73.95873307074629 40.7907682009641 32F-AM-1012-02 32F AM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray patches on back legs Ground Plane FALSE   0 0 0 0 0 curious about me 0 0 0 0 0 1 0 1   POINT (-73.9587330707463 40.7907682009641)
1862 1862 -73.97648512317541 40.771573686286104 6C-AM-1007-07 06C AM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0 ambling 0 0 0 0 0 1 0 1 trucks POINT (-73.9764851231754 40.7715736862861)
2117 2117 -73.9597192455543 40.7973316178661 38A-AM-1019-03 38A AM 10192018 3 Adult Gray White Gray+White White belly Ground Plane FALSE   0 0 0 0 1 stood on back legs 0 0 0 0 0 1 1 1   POINT (-73.9597192455543 40.7973316178661)
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)

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