2018_Central_Park_Squirrel_Census_-_Squirrel_Data

197 rows where Date = 10142018 and Foraging = 0 sorted by Highlight Fur Color descending

✎ View and edit SQL

This data as json, CSV (advanced)

Moans ✖

  • 0 71

Foraging ✖

Date ✖

  • 10142018 · 71 ✖
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
1537 1537 -73.97672201797249 40.77532621031229 10A-PM-1014-03 10A PM 10142018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Above Ground   above my head in tree 0 0 0 1 0 eating (in a tree) 0 0 0 0 0 0 1 0 indifferent (lots of people taking its picture,didn't bother it) POINT (-73.9767220179725 40.7753262103123)
885 885 -73.97504638449841 40.7666871742836 2F-PM-1014-08 02F PM 10142018 8 Adult Gray Black Gray+Black   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9750463844984 40.7666871742836)
1 1 -73.9561344937861 40.794082388408604 37F-PM-1014-03 37F PM 10142018 3       +         0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9561344937861 40.7940823884086)
42 42 -73.9579564338627 40.795933779502704 38C-PM-1014-09 38C PM 10142018 9 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9579564338627 40.7959337795027)
47 47 -73.9640032826529 40.782030982544796 22F-PM-1014-06 22F PM 10142018 6 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9640032826529 40.7820309825448)
72 72 -73.9666007935638 40.7845098131567 23C-PM-1014-03 23C PM 10142018 3 Adult Gray   Gray+   Above Ground 8   0 1 0 0 0 chasing (#4 across trees) 0 0 0 0 0 0 0 0   POINT (-73.9666007935638 40.7845098131567)
341 341 -73.9703161745884 40.7702610461336 8H-PM-1014-05 08H PM 10142018 5 Juvenile Gray   Gray+   Above Ground 2   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9703161745884 40.7702610461336)
388 388 -73.9592537496995 40.7919271821316 33E-AM-1014-03 33E AM 10142018 3 Adult Black   Black+   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9592537496995 40.7919271821316)
415 415 -73.95701318903791 40.799178673612396 41B-PM-1014-05 41B PM 10142018 5 Adult Gray   Gray+   Above Ground 25   0 0 1 0 0   1 0 0 0 0 0 1 1   POINT (-73.9570131890379 40.7991786736124)
518 518 -73.96878474106559 40.778185700305 16E-AM-1014-09 16E AM 10142018 9 Adult Gray   Gray+   Above Ground 25 In tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9687847410656 40.778185700305)
593 593 -73.95933528061751 40.7918150568046 33E-AM-1014-02 33E AM 10142018 2 Juvenile Black   Black+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9593352806175 40.7918150568046)
608 608 -73.95896759955171 40.791311922358396 33E-AM-1014-09 33E AM 10142018 9 Juvenile Black   Black+   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9589675995517 40.7913119223584)
656 656 -73.9553726714504 40.798757854112296 41D-AM-1014-02 41D AM 10142018 2 Adult Gray   Gray+   Above Ground 20   0 0 0 0 0 jumping 0 0 0 0 0 0 1 0   POINT (-73.9553726714504 40.7987578541123)
709 709 -73.9519387881692 40.7936273636929 38I-PM-1014-04 38I PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9519387881692 40.7936273636929)
744 744 -73.97456876537909 40.7776396926997 13A-PM-1014-02 13A PM 10142018 2 Adult Gray   Gray+   Above Ground 45   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9745687653791 40.7776396926997)
755 755 -73.9579941847434 40.7991216713328 41B-PM-1014-02 41B PM 10142018 2 Adult Black   Black+   Above Ground 28   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9579941847434 40.7991216713328)
838 838 -73.96910310946879 40.77066938351889 9I-AM-1014-02 09I AM 10142018 2 Adult Gray   Gray+ Very far, so appx Above Ground 35   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9691031094688 40.7706693835189)
898 898 -73.95428280532559 40.794179732035495 37G-AM-1014-03 37G AM 10142018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9542828053256 40.7941797320355)
958 958 -73.9613862251332 40.791282169715 32C-AM-1014-03 32C AM 10142018 3 Adult Gray   Gray+   Above Ground 3   0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9613862251332 40.791282169715)
974 974 -73.9753744539307 40.7671162211032 2F-PM-1014-12 02F PM 10142018 12 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.97537445393071 40.7671162211032)
1006 1006 -73.96862962178929 40.771812308875 10H-AM-1014-02 10H AM 10142018 2 Juvenile Cinnamon   Cinnamon+   Above Ground 6   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9686296217893 40.771812308875)
1041 1041 -73.9643236505425 40.7887854771596 28C-AM-1014-02 28C AM 10142018 2 Adult Gray   Gray+   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9643236505425 40.7887854771596)
1102 1102 -73.9688173465755 40.7782009764626 16E-AM-1014-08 16E AM 10142018 8 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (dog) POINT (-73.9688173465755 40.7782009764626)
1206 1206 -73.97487092063541 40.77608025411 11B-PM-1014-01 11B PM 10142018 1 Adult Gray   Gray+ Fat! Above Ground 10   0 0 1 0 0   1 0 0 0 0 0 0 1   POINT (-73.9748709206354 40.77608025411)
1255 1255 -73.9717469822209 40.7753731930704 12D-PM-1014-03 12D PM 10142018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9717469822209 40.7753731930704)
1314 1314 -73.980919134781 40.7683772453336 1A-PM-1014-06 01A PM 10142018 6 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   1 0 0 0 0 0 0 1   POINT (-73.980919134781 40.7683772453336)
1355 1355 -73.9655277320465 40.780612052936895 20F-AM-1014-03 20F AM 10142018 3 Adult Gray   Gray+   Above Ground 30   0 0 1 0 0   1 0 0 0 0 0 0 0   POINT (-73.9655277320465 40.7806120529369)
1417 1417 -73.974828939898 40.7668886121909 2F-PM-1014-11 02F PM 10142018 11 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.974828939898 40.7668886121909)
1427 1427 -73.9755321998542 40.766831157600706 2F-PM-1014-01 02F PM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.97553219985421 40.7668311576007)
1433 1433 -73.9574077497624 40.80011851848921 42B-AM-1014-01 42B AM 10142018 1 Adult Gray   Gray+   Above Ground 3   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9574077497624 40.8001185184892)
1527 1527 -73.970216605149 40.7702960667277 8H-PM-1014-08 08H PM 10142018 8 Adult Gray   Gray+   Above Ground 5   0 1 0 0 0 chasing (#7),playing? 0 0 0 0 0 0 1 0   POINT (-73.970216605149 40.7702960667277)
1630 1630 -73.9710025484537 40.7792529489016 16C-AM-1014-01 16C AM 10142018 1 Juvenile Gray   Gray+   Above Ground 40   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9710025484537 40.7792529489016)
1665 1665 -73.95839443533521 40.7979689846815 39B-PM-1014-04 39B PM 10142018 4 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 1 runs from (me—when i approached) POINT (-73.9583944353352 40.7979689846815)
1666 1666 -73.96494654768709 40.7822708362663 22F-PM-1014-07 22F PM 10142018 7 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9649465476871 40.7822708362663)
1673 1673 -73.9746940851342 40.7760966488186 11B-PM-1014-02 11B PM 10142018 2 Juvenile Gray   Gray+   Above Ground 10   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9746940851342 40.7760966488186)
1682 1682 -73.97592584072879 40.7667622711142 2F-PM-1014-05 02F PM 10142018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9759258407288 40.7667622711142)
1732 1732 -73.97671414072741 40.7737313251559 8A-PM-1014-02 08A PM 10142018 2 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 0 1 runs from (goes up a tree) POINT (-73.9767141407274 40.7737313251559)
1752 1752 -73.9561091686663 40.798146304742495 41D-AM-1014-04 41D AM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9561091686663 40.7981463047425)
1765 1765 -73.9689041600147 40.7781788966185 16E-AM-1014-07 16E AM 10142018 7 Adult Gray   Gray+   Above Ground     1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (dog) POINT (-73.9689041600147 40.7781788966185)
1771 1771 -73.9750688083336 40.766558468102495 2F-PM-1014-07 02F PM 10142018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9750688083336 40.7665584681025)
1807 1807 -73.9581366214863 40.7988964092722 40B-PM-1014-02 40B PM 10142018 2 Adult Gray   Gray+   Above Ground 20   0 0 1 0 0   1 1 0 0 0 0 0 1   POINT (-73.9581366214863 40.7988964092722)
1817 1817 -73.9703076450783 40.770158422628995 8H-PM-1014-07 08H PM 10142018 7 Adult Gray   Gray+   Above Ground 5   0 1 0 0 0 chasing (#8),playing? 0 0 0 0 0 0 1 0   POINT (-73.9703076450783 40.770158422629)
1831 1831 -73.9746877519291 40.7761402808083 11B-PM-1014-03 11B PM 10142018 3   Gray   Gray+   Above Ground 10   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9746877519291 40.7761402808083)
1908 1908 -73.95883455468791 40.7991830272008 40A-PM-1014-02 40A PM 10142018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (ran from base of tree into bushes) POINT (-73.9588345546879 40.7991830272008)
1926 1926 -73.9742811484852 40.775533619083 11B-PM-1014-08 11B PM 10142018 8   Gray   Gray+   Above Ground 10   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.97428114848522 40.775533619083)
1930 1930 -73.9744279648953 40.7777760612191 13A-PM-1014-01 13A PM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9744279648953 40.7777760612191)
2028 2028 -73.96873477318609 40.7718955594385 10H-AM-1014-03 10H AM 10142018 3 Juvenile     +   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9687347731861 40.7718955594385)
2070 2070 -73.9725700261894 40.7668793330427 3H-PM-1014-01 03H PM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE under a parked car 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9725700261894 40.7668793330427)
2128 2128 -73.9757673193743 40.7669614322613 2F-PM-1014-04 02F PM 10142018 4 Adult Gray   Gray+   Above Ground 20   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9757673193743 40.766961432261304)
2154 2154 -73.976716425804 40.7736889979965 8A-PM-1014-03 08A PM 10142018 3 Juvenile Gray   Gray+   Above Ground 23   0 0 1 1 0   0 0 0 0 0 0 0 0   POINT (-73.976716425804 40.7736889979965)
2243 2243 -73.9579967047318 40.7948682042252 37D-PM-1014-02 37D PM 10142018 2 Adult Gray   Gray+   Above Ground 40   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.95799670473181 40.7948682042252)
2261 2261 -73.9609692861012 40.790502891247 31D-AM-1014-07 31D AM 10142018 7   Gray   Gray+   Ground Plane FALSE Crossing path to tree 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9609692861012 40.790502891247)
2270 2270 -73.9703732649257 40.77019793771029 8H-PM-1014-04 08H PM 10142018 4 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.97037326492571 40.7701979377103)
2279 2279 -73.9586085858962 40.7990326758282 40A-PM-1014-04 40A PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (ran from path to bushes) POINT (-73.9586085858962 40.7990326758282)
2341 2341 -73.9665363265054 40.7844967881001 23C-PM-1014-04 23C PM 10142018 4 Adult Gray   Gray+   Above Ground 8   0 0 0 0 0 being chased by #3 across trees 0 0 0 0 0 0 0 0   POINT (-73.9665363265054 40.7844967881001)
2416 2416 -73.95886898209079 40.799238413797205 40A-PM-1014-03 40A PM 10142018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (ran from base of tree into bushes) POINT (-73.9588689820908 40.799238413797205)
2441 2441 -73.9579865329778 40.794906535675004 37D-PM-1014-03 37D PM 10142018 3 Adult Gray   Gray+   Above Ground 40   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9579865329778 40.794906535675)
2443 2443 -73.96670731869591 40.7840581361598 23C-PM-1014-01 23C PM 10142018 1 Adult Gray   Gray+   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.96670731869591 40.7840581361598)
2621 2621 -73.9596904740342 40.7897200025671 31E-AM-1014-01 31E AM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9596904740342 40.7897200025671)
2654 2654 -73.9549261242548 40.7944701994615 37G-AM-1014-04 37G AM 10142018 4 Adult Gray   Gray+   Above Ground 5   0 1 0 0 0 playing 0 0 0 0 0 0 1 0   POINT (-73.9549261242548 40.7944701994615)
2663 2663 -73.96134291849741 40.79121580572671 32C-AM-1014-02 32C AM 10142018 2 Adult Gray   Gray+   Above Ground 3   0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9613429184974 40.7912158057267)
2740 2740 -73.96126586889142 40.7912119940469 32C-AM-1014-04 32C AM 10142018 4 Adult Gray   Gray+   Above Ground 8   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9612658688914 40.7912119940469)
2754 2754 -73.9687025912431 40.7719319822619 10H-AM-1014-04 10H AM 10142018 4 Juvenile     +   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9687025912431 40.7719319822619)
2762 2762 -73.9656324462902 40.783403475308106 22E-PM-1014-02 22E PM 10142018 2 Adult Gray   Gray+   Above Ground 6   0 0 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.9656324462902 40.7834034753081)
2768 2768 -73.96410881726321 40.7886555184212 28C-AM-1014-01 28C AM 10142018 1 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9641088172632 40.7886555184212)
2790 2790 -73.9673554935258 40.782752724959394 21C-AM-1014-04 21C AM 10142018 4 Adult     + High in tree, unable to tell Above Ground 60   0 0 1 0 0   0 0 0 1 0 0 1 0   POINT (-73.96735549352582 40.7827527249594)
2881 2881 -73.9541629063295 40.7934259301577 37G-AM-1014-02 37G AM 10142018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0 ran away & disappeared 0 0 0 0 0 0 0 0   POINT (-73.9541629063295 40.7934259301577)
2910 2910 -73.9506062997507 40.797618949667395 42H-PM-1014-03 42H PM 10142018 3 Adult     +         0 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9506062997507 40.7976189496674)
2933 2933 -73.9677903197449 40.7826561917755 21C-AM-1014-03 21C AM 10142018 3 Adult Gray   Gray+   Above Ground 30   0 1 1 0 0   0 1 0 0 0 0 0 0 looked at us from tree POINT (-73.9677903197449 40.7826561917755)
2945 2945 -73.9649103330443 40.7823913860445 22F-PM-1014-08 22F PM 10142018 8 Adult Gray   Gray+   Above Ground 10 CLIMBED THE TREE 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9649103330443 40.7823913860445)
2951 2951 -73.9742986032935 40.7770454318226 13A-PM-1014-04 13A PM 10142018 4   Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9742986032935 40.7770454318226)

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