2018_Central_Park_Squirrel_Census_-_Squirrel_Data

17 rows where Above Ground Sighter Measurement = 5 and Climbing = 0 sorted by Climbing

View and edit SQL

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Eating, Foraging, Kuks, Quaas, Moans, Indifferent, Runs from

Tail twitches

  • 0 15
  • 1 2

Climbing

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
46 -73.9673253417305 40.7749505252981 13H-PM-1010-02 13H PM 10102018 2 Adult Gray   Gray+   Above Ground 5 tree 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9673253417305 40.7749505252981)
284 -73.9547336666137 40.7938937756332 37G-PM-1007-07 37G PM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9547336666137 40.7938937756332)
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)
811 -73.9771695272048 40.772427727626294 7B-AM-1008-03 07B AM 10082018 3 Adult Gray   Gray+   Above Ground 5   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9771695272048 40.7724277276263)
901 -73.97022281317109 40.7742131587983 12F-PM-1007-12 12F PM 10072018 12 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 5   0 0 0 0 1 going down tree 0 0 0 0 0 0 1 0   POINT (-73.9702228131711 40.7742131587983)
1037 -73.96774098419691 40.776357914063894 15G-PM-1019-08 15G PM 10192018 8 Adult     +   Above Ground 5   0 1 0 0 0   0 1 1 0 0 0 0 0   POINT (-73.9677409841969 40.7763579140639)
1065 -73.9769700777377 40.772848957496706 7B-AM-1008-08 07B AM 10082018 8 Adult Gray   Gray+   Above Ground 5   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9769700777377 40.7728489574967)
1408 -73.973230162241 40.768982453144396 5F-AM-1007-01 05F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 fence 1 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.973230162241 40.7689824531444)
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)
1688 -73.9677593344667 40.7763054313195 15G-PM-1019-07 15G PM 10192018 7 Adult     +   Above Ground 5   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9677593344667 40.7763054313195)
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)
1863 -73.96828305109541 40.7810151087286 19D-PM-1008-03 19D PM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White may be same squirrel as #1 - male Above Ground 5 on branch of dead tree 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9682830510954 40.7810151087286)
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)
2008 -73.95243640874371 40.792846505434 37I-PM-1006-01 37I PM 10062018 1 Adult Cinnamon Gray, Black Cinnamon+Gray, Black   Above Ground 5   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9524364087437 40.792846505434)
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)
2708 -73.9528429238071 40.7922651848867 36I-PM-1007-09 36I PM 10072018 9 Juvenile Gray   Gray+   Above Ground 5   1 1 0 0 0 burying nut 0 0 0 0 1 0 0 0   POINT (-73.9528429238071 40.7922651848867)
2742 -73.96280415779341 40.7884180156055 28D-AM-1012-06 28D AM 10122018 6 Juvenile Cinnamon White Cinnamon+White   Above Ground 5   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9628041577934 40.78841801560551)

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