2018_Central_Park_Squirrel_Census_-_Squirrel_Data

51 rows where Above Ground Sighter Measurement = 15 and Age = "Adult" sorted by Above Ground Sighter Measurement

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Hectare Squirrel Number, Primary Fur Color, Combination of Primary and Highlight Color, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Kuks, Tail flags, Approaches, Indifferent, Runs from

Highlight Fur Color ✖

Tail twitches ✖

  • 0 42
  • 1 9

Age ✖

  • Adult · 51 ✖

Above Ground Sighter Measurement ✖

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
163 163 -73.97123088643941 40.7714534847379 9G-AM-1007-04 09G AM 10072018 4 Adult Gray White Gray+White   Above Ground 15   0 0 0 0 0 grooming 0 0 0 0 0 0 1 0   POINT (-73.9712308864394 40.7714534847379)
207 207 -73.9770824412252 40.770996130945704 5C-AM-1006-03 05C AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.97708244122522 40.7709961309457)
210 210 -73.97112984911321 40.76769026035429 5I-PM-1008-01 05I PM 10082018 1 Adult Black Cinnamon Black+Cinnamon   Above Ground 15 in tree by arsenal - climbing 0 0 1 1 0   0 0 0 1 0 0 0 0   POINT (-73.9711298491132 40.7676902603543)
260 260 -73.97843611793199 40.7724769242403 6A-AM-1006-06 06A AM 10062018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15 tree 0 0 1 0 0   1 0 0 0 0 0 0 0   POINT (-73.978436117932 40.7724769242403)
294 294 -73.9756573579063 40.7656644063024 1G-PM-1010-01 01G PM 10102018 1 Adult Gray White Gray+White   Above Ground 15   0 0 1 1 0   0 0 0 1 0 0 1 0 too busy eating in his tree POINT (-73.9756573579063 40.7656644063024)
317 317 -73.9545799024508 40.7908084039886 34I-PM-1010-01 34I PM 10102018 1 Adult Gray   Gray+   Above Ground 15   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9545799024508 40.7908084039886)
331 331 -73.95448101115 40.7954469678857 39F-PM-1006-03 39F PM 10062018 3 Adult Gray White Gray+White   Above Ground 15 lower branch of tree 0 0 0 1 0   0 0 0 0 0 0 0 1 ran up tree when approached POINT (-73.95448101115 40.7954469678857)
359 359 -73.9716404781264 40.7753181851766 12D-PM-1014-02 12D PM 10142018 2 Adult Gray White Gray+White   Above Ground 15   0 0 1 0 0 seems to be grinding teeth on a piece of material (sounds from grinding) 0 0 0 0 0 0 1 0   POINT (-73.9716404781264 40.7753181851766)
371 371 -73.964080104186 40.79078986272871 30B-AM-1007-02 30B AM 10072018 2 Adult Gray   Gray+   Above Ground 15   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.964080104186 40.7907898627287)
380 380 -73.9649590119935 40.782210792076896 21F-AM-1018-01 21F AM 10182018 1 Adult Gray   Gray+   Above Ground 15   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9649590119935 40.7822107920769)
387 387 -73.9578316525492 40.789010295962896 31G-PM-1007-01 31G PM 10072018 1 Adult Gray   Gray+   Above Ground 15   0 0 0 0 0 hiding 0 0 0 0 1 0 0 0 froze,sight of dogs POINT (-73.9578316525492 40.7890102959629)
510 510 -73.9638590768396 40.777678211498106 18I-AM-1017-02 18I AM 10172018 2 Adult Gray Black Gray+Black   Above Ground 15   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9638590768396 40.7776782114981)
591 591 -73.95433237868879 40.7943086530436 37G-PM-1007-03 37G PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 0 1 0 lying on belly on branch,eating big nut 0 0 0 0 0 0 0 0   POINT (-73.9543323786888 40.7943086530436)
773 773 -73.95661891453521 40.7883417969746 31H-PM-1008-01 31H PM 10082018 1 Adult Gray White Gray+White   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9566189145352 40.7883417969746)
781 781 -73.955516031113 40.7923188156277 35G-AM-1007-01 35G AM 10072018 1 Adult Gray White Gray+White   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.955516031113 40.7923188156277)
801 801 -73.9743342303548 40.772774294833205 8D-AM-1007-08 08D AM 10072018 8 Adult Gray   Gray+   Above Ground 15   0 0 0 0 0 communicating from tree 0 0 0 0 0 0 0 0   POINT (-73.97433423035481 40.7727742948332)
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)
966 966 -73.95831758180199 40.791656668315795 33E-AM-1014-12 33E AM 10142018 12 Adult Gray White Gray+White   Above Ground 15   0 0 0 0 0 sleeping 0 0 0 0 0 0 0 0 asleep POINT (-73.958317581802 40.7916566683158)
1018 1018 -73.96953055553921 40.7757541971012 13F-PM-1008-03 13F PM 10082018 3 Adult Gray   Gray+   Above Ground 15 tree 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9695305555392 40.7757541971012)
1104 1104 -73.95898529894859 40.7912720015917 33E-AM-1014-07 33E AM 10142018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9589852989486 40.7912720015917)
1145 1145 -73.9611446263364 40.7911003407299 32D-AM-1013-03 32D AM 10132018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9611446263364 40.7911003407299)
1147 1147 -73.96318185288159 40.7925332194132 32A-AM-1018-01 32A AM 10182018 1 Adult Gray   Gray+   Above Ground 15   1 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9631818528816 40.7925332194132)
1426 1426 -73.9664986446294 40.778308334318 17G-PM-1017-02 17G PM 10172018 2 Adult Gray   Gray+   Above Ground 15   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9664986446294 40.778308334318)
1489 1489 -73.9501762527462 40.797553408607705 42H-PM-1014-05 42H PM 10142018 5 Adult Gray White Gray+White   Above Ground 15   1 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9501762527462 40.7975534086077)
1500 1500 -73.9769969548024 40.7710711265211 6C-AM-1007-01 06C AM 10072018 1 Adult Gray White Gray+White vid! Above Ground 15   0 0 1 0 0   0 0 0 0 1 0 0 0 curious,but wary POINT (-73.97699695480242 40.7710711265211)
1522 1522 -73.95389705545321 40.7955196793479 39G-PM-1013-03 39G PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9538970554532 40.7955196793479)
1535 1535 -73.9703921271418 40.770027611531404 7H-PM-1006-06 07H PM 10062018 6 Adult Gray   Gray+   Above Ground 15   0 1 1 0 0 playing w/ #7 0 0 0 0 0 0 1 0   POINT (-73.9703921271418 40.770027611531404)
1595 1595 -73.9754696312232 40.768191647091996 4E-AM-1020-02 04E AM 10202018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White White selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. Above Ground 15   0 0 1 0 1 foraging (on the tree itself) 0 0 0 0 0 0 1 0   POINT (-73.9754696312232 40.768191647092)
1607 1607 -73.9770508584979 40.7710769301257 6C-AM-1007-02 06C AM 10072018 2 Adult     +   Above Ground 15   0 0 1 0 0 pulling things off branches 0 0 0 0 0 0 0 0   POINT (-73.9770508584979 40.7710769301257)
1624 1624 -73.97370600439879 40.772566022498296 8D-AM-1007-05 08D AM 10072018 5 Adult Gray   Gray+   Above Ground 15   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9737060043988 40.7725660224983)
1627 1627 -73.9594391759139 40.784115697669 26I-PM-1010-03 26I PM 10102018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White black in tail Above Ground 15 tree 0 0 1 1 1   0 0 0 0 1 0 1 0   POINT (-73.9594391759139 40.784115697669)
1727 1727 -73.96924722995651 40.7722592187215 10H-PM-1007-01 10H PM 10072018 1 Adult Gray White Gray+White dark gray Above Ground 15 in tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9692472299565 40.7722592187215)
1787 1787 -73.9720365327715 40.7762329714016 13D-PM-1018-11 13D PM 10182018 11 Adult Gray White Gray+White   Above Ground 15   0 0 1 1 0   0 0 0 0 1 0 1 0   POINT (-73.9720365327715 40.7762329714016)
1796 1796 -73.9765355395622 40.7735653237366 8B-AM-1007-03 08B AM 10072018 3 Adult Gray   Gray+   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.97653553956222 40.7735653237366)
1887 1887 -73.95861842328891 40.7993153832942 41A-PM-1007-02 41A PM 10072018 2 Adult Black   Black+   Above Ground 15   0 0 1 0 0 jumping 0 0 0 0 0 0 0 0 stared at me POINT (-73.9586184232889 40.7993153832942)
1939 1939 -73.9540151828782 40.7920066170587 35H-AM-1013-01 35H AM 10132018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15 Climbing up tree 0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9540151828782 40.7920066170587)
1989 1989 -73.96316467546471 40.7925716810884 32A-AM-1018-02 32A AM 10182018 2 Adult Gray   Gray+   Above Ground 15   1 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9631646754647 40.7925716810884)
2052 2052 -73.97464934414141 40.7750478734868 11B-PM-1014-06 11B PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 0 0 0 cleaning 0 0 0 0 0 0 1 0   POINT (-73.9746493441414 40.7750478734868)
2180 2180 -73.960864328605 40.7902122634639 31D-PM-1006-02 31D PM 10062018 2 Adult Gray   Gray+   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.960864328605 40.7902122634639)
2242 2242 -73.9565824187667 40.797312050952 40D-AM-1013-06 40D AM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   1 0 1 0 1   1 0 0 0 1 0 0 1   POINT (-73.9565824187667 40.797312050952)
2282 2282 -73.9722056538718 40.7805111762703 17A-PM-1013-03 17A PM 10132018 3 Adult Gray   Gray+   Above Ground 15 tree 0 0 0 0 0 grooming! & scratching 0 0 0 0 0 0 1 0   POINT (-73.9722056538718 40.7805111762703)
2298 2298 -73.97553718499721 40.7733561233828 9C-PM-1006-02 09C PM 10062018 2 Adult Gray White Gray+White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9755371849972 40.7733561233828)
2361 2361 -73.9708032298419 40.7784265674544 15C-AM-1010-02 15C AM 10102018 2 Adult Gray   Gray+   Above Ground 15   0 0 1 0 0 nest building 0 0 0 0 0 0 1 0   POINT (-73.9708032298419 40.77842656745441)
2362 2362 -73.9700263936574 40.769933509858106 7H-PM-1006-07 07H PM 10062018 7 Adult Gray   Gray+   Above Ground 15   0 1 1 0 0 playing w/ #6 0 0 0 0 0 0 1 0   POINT (-73.9700263936574 40.7699335098581)
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)
2561 2561 -73.9591513028486 40.7835978067328 25I-PM-1007-01 25I PM 10072018 1 Adult Gray   Gray+   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9591513028486 40.7835978067328)
2779 2779 -73.9767835160078 40.767403033048204 2E-PM-1014-04 02E PM 10142018 4 Adult Cinnamon White Cinnamon+White   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9767835160078 40.7674030330482)
2813 2813 -73.96591181893591 40.7765739928504 15H-AM-1013-02 15H AM 10132018 2 Adult Gray   Gray+   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9659118189359 40.7765739928504)
2912 2912 -73.9632164738341 40.7921270121312 32B-PM-1010-03 32B PM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9632164738341 40.7921270121312)
2950 2950 -73.9790980124501 40.7685934093915 2B-PM-1013-08 02B PM 10132018 8 Adult Gray White Gray+White   Above Ground 15   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9790980124501 40.7685934093915)
3008 3008 -73.9503533343658 40.7976543603953 42H-PM-1014-04 42H PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   1 1 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9503533343658 40.7976543603953)

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