2018_Central_Park_Squirrel_Census_-_Squirrel_Data

46 rows where Date = 10082018 and Hectare Squirrel Number = 2 sorted by Primary Fur Color

✎ View and edit SQL

This data as json, CSV (advanced)

Quaas ✖

  • 0 28

Hectare Squirrel Number ✖

Date ✖

  • 10082018 · 28 ✖
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
732 732 -73.9695041366722 40.779787880948206 17D-AM-1008-02 17D AM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9695041366722 40.7797878809482)
747 747 -73.97714226252741 40.772361415776 7B-AM-1008-02 07B AM 10082018 2 Adult Gray   Gray+   Above Ground 5   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9771422625274 40.772361415776)
890 890 -73.9667755678511 40.7760256836088 15H-PM-1008-02 15H PM 10082018 2 Adult Gray   Gray+   Above Ground 10 oak tree 0 1 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9667755678511 40.7760256836088)
896 896 -73.9755055978764 40.77074386817421 6D-AM-1008-02 06D AM 10082018 2 Juvenile Gray   Gray+   Above Ground 10   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9755055978764 40.7707438681742)
1093 1093 -73.9584106786233 40.7902777556926 32F-PM-1008-02 32F PM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9584106786233 40.7902777556926)
1153 1153 -73.9688523924488 40.7844018035948 22A-AM-1008-02 22A AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9688523924488 40.7844018035948)
1274 1274 -73.9745859998733 40.7671634885616 3G-AM-1008-02 03G AM 10082018 2 Adult Gray   Gray+ Big one! Beautiful tail Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9745859998733 40.7671634885616)
1319 1319 -73.9562105506291 40.796699119790894 39D-AM-1008-02 39D AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9562105506291 40.7966991197909)
1439 1439 -73.9729645190377 40.7723310150843 9E-AM-1008-02 09E AM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9729645190377 40.7723310150843)
1472 1472 -73.9698611971209 40.7753915552001 13F-PM-1008-02 13F PM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9698611971209 40.7753915552001)
1593 1593 -73.9676539688726 40.7777229934129 16F-AM-1008-02 16F AM 10082018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE near fence 0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9676539688726 40.7777229934129)
1661 1661 -73.974519308015 40.7691228794395 5E-AM-1008-02 05E AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8 trellis 1 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.974519308015 40.7691228794395)
1702 1702 -73.9752699507508 40.7688069184057 4E-PM-1008-02 04E PM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9752699507508 40.76880691840571)
1904 1904 -73.9684058476942 40.7753959833776 13G-PM-1008-02 13G PM 10082018 2 Juvenile Gray   Gray+   Above Ground 15 willow oak tree 0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9684058476942 40.7753959833776)
1955 1955 -73.9606559309874 40.7889527629826 30E-AM-1008-02 30E AM 10082018 2 Adult Gray   Gray+   Above Ground 5   0 1 0 0 0   1 0 0 0 0 0 1 0   POINT (-73.9606559309874 40.7889527629826)
1960 1960 -73.97301589136609 40.7701310707272 6F-PM-1008-02 06F PM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   1 1 0 0 0 chasing #2 0 0 0 0 0 0 0 0   POINT (-73.9730158913661 40.7701310707272)
1984 1984 -73.9739249209875 40.7768528386853 13B-PM-1008-02 13B PM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9739249209875 40.7768528386853)
1990 1990 -73.9774584305147 40.770813398619204 5B-AM-1008-02 05B AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9774584305147 40.7708133986192)
2020 2020 -73.96914538859642 40.77705240897121 15E-PM-1008-02 15E PM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9691453885964 40.7770524089712)
2095 2095 -73.9747762992858 40.776857907857796 12A-AM-1008-02 12A AM 10082018 2 Adult Gray   Gray+   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9747762992858 40.7768579078578)
2185 2185 -73.9707571364399 40.7758859812524 13E-PM-1008-02 13E PM 10082018 2 Adult Gray White Gray+White   Above Ground 10   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9707571364399 40.7758859812524)
2258 2258 -73.95477850811709 40.789612183711 33I-AM-1008-02 33I AM 10082018 2 Adult Gray   Gray+   Above Ground 3 edge of park @ 98th 0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9547785081171 40.789612183711)
2318 2318 -73.967458693983 40.7769922522105 15G-AM-1008-02 15G AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.967458693983 40.7769922522105)
2347 2347 -73.9663124560664 40.779544003786 18F-PM-1008-02 18F PM 10082018 2 Adult Gray   Gray+         0 0 0 0 0 hopping around 0 0 0 0 0 0 0 1   POINT (-73.9663124560664 40.779544003786)
2584 2584 -73.9727187453699 40.7669595710626 3H-AM-1008-02 03H AM 10082018 2 Adult Gray   Gray+   Above Ground     0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9727187453699 40.7669595710626)
2675 2675 -73.9762227323096 40.768453603768 3E-PM-1008-02 03E PM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9762227323096 40.768453603768)
2793 2793 -73.9742847552668 40.7731740123046 9D-AM-1008-02 09D AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9742847552668 40.7731740123046)
3009 3009 -73.9675637870968 40.782388067172796 21D-PM-1008-02 21D PM 10082018 2   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9675637870968 40.7823880671728)

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.544ms