2018_Central_Park_Squirrel_Census_-_Squirrel_Data

30 rows where Date = 10062018, Foraging = 1 and Runs from = 1 sorted by Approaches

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Kuks, Tail flags, Tail twitches, Approaches, Indifferent

Moans ✖

  • 0 30

Foraging ✖

Date ✖

  • 10062018 · 30 ✖
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
90 90 -73.97871808707359 40.7715877863274 5A-AM-1006-05 05A AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE near 65th St arch 0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9787180870736 40.7715877863274)
134 134 -73.9575943815564 40.7933755266787 35E-PM-1006-07 35E PM 10062018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 1   POINT (-73.9575943815564 40.7933755266787)
504 504 -73.95334760207359 40.7933003544685 37H-PM-1006-02 37H PM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE tree 1 0 1 0 1   1 0 0 0 0 0 0 1 dogs POINT (-73.9533476020736 40.7933003544685)
540 540 -73.97468021940121 40.7731347452245 9C-PM-1006-01 09C PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9746802194012 40.7731347452245)
550 550 -73.9714465493257 40.7772135587308 14C-PM-1006-02 14C PM 10062018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9714465493257 40.7772135587308)
663 663 -73.9766440589836 40.7682390282581 3E-AM-1006-02 03E AM 10062018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9766440589836 40.7682390282581)
675 675 -73.9759830650957 40.7683034739069 3E-AM-1006-01 03E AM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9759830650957 40.7683034739069)
697 697 -73.97046560040201 40.770112577324795 7H-PM-1006-05 07H PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ran across path to eat behind fence, next to the fence. 1 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.970465600402 40.7701125773248)
730 730 -73.9607280801601 40.7901506706248 31D-PM-1006-01 31D PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 1 0 0 0 1   POINT (-73.9607280801601 40.7901506706248)
774 774 -73.9673603655908 40.787697417778205 26A-PM-1006-03 26A PM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9673603655908 40.7876974177782)
825 825 -73.9580105174865 40.7974468322692 39C-PM-1006-03 39C PM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9580105174865 40.7974468322692)
914 914 -73.9760801742337 40.7674218954729 3E-AM-1006-04 03E AM 10062018 4 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9760801742337 40.7674218954729)
972 972 -73.9704591091677 40.7729175143429 10G-AM-1006-02 10G AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon notch on tail Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9704591091677 40.7729175143429)
1107 1107 -73.95307395621309 40.7932034409546 37H-PM-1006-01 37H PM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1 from voice POINT (-73.95307395621312 40.7932034409546)
1334 1334 -73.957134662576 40.7872395604122 30I-PM-1006-07 30I PM 10062018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.957134662576 40.7872395604122)
1429 1429 -73.9706533131129 40.768902033818996 6I-AM-1006-01 06I AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground     1 0 1 1 1   0 0 0 0 0 0 0 1 runs from (someone sneezed) POINT (-73.9706533131129 40.768902033819)
1486 1486 -73.9545807749923 40.790050753764895 33I-PM-1006-02 33I PM 10062018 2 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9545807749923 40.7900507537649)
1523 1523 -73.9673103881521 40.78742674096179 26A-PM-1006-01 26A PM 10062018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9673103881521 40.7874267409618)
1617 1617 -73.97520295136441 40.767173466736104 3F-AM-1006-04 03F AM 10062018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE on a rock 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9752029513644 40.7671734667361)
1678 1678 -73.95687265085459 40.7878795081255 30I-PM-1006-03 30I PM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1 up tree POINT (-73.9568726508546 40.7878795081255)
1700 1700 -73.965675791028 40.7887310058451 27B-PM-1006-02 27B PM 10062018 2 Adult Gray   Gray+   Ground Plane FALSE By large tree chasing #1 0 1 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.965675791028 40.7887310058451)
1776 1776 -73.9562350820255 40.7913464147989 34G-PM-1006-02 34G PM 10062018 2 Adult Gray   Gray+   Above Ground 6   0 0 1 1 1 eating bread it found on ground 0 0 0 0 0 0 0 1   POINT (-73.9562350820255 40.7913464147989)
1920 1920 -73.95453837191879 40.7899711263765 33I-PM-1006-03 33I PM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.95453837191882 40.7899711263765)
2329 2329 -73.9717515173863 40.7747999274418 11D-PM-1006-04 11D PM 10062018 4 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9717515173863 40.7747999274418)
2345 2345 -73.965738547469 40.78869627401671 27B-PM-1006-01 27B PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE By large tree 0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.965738547469 40.7886962740167)
2583 2583 -73.97696931406509 40.7684390015166 3D-AM-1006-01 03D AM 10062018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 9 up a tree 1 0 1 1 1 digging (?) 0 0 0 1 0 0 0 1 runs from (man led his dog into the area to chase squirrel) POINT (-73.9769693140651 40.7684390015166)
658 658 -73.9704575848926 40.7693499326095 7H-PM-1006-09 07H PM 10062018 9 Adult Black   Black+   Ground Plane FALSE by tree 0 0 0 1 1   0 0 0 1 0 1 0 1   POINT (-73.9704575848926 40.7693499326095)
1106 1106 -73.97029709193171 40.7696883113413 7H-PM-1006-08 07H PM 10062018 8 Adult Gray White Gray+White   Ground Plane FALSE in grass 0 0 0 0 1   0 0 0 0 1 1 0 1   POINT (-73.9702970919317 40.7696883113413)
2782 2782 -73.9563473341712 40.7893712398425 32H-PM-1006-03 32H PM 10062018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 1 0 1   POINT (-73.9563473341712 40.78937123984251)
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 127.118ms