2018_Central_Park_Squirrel_Census_-_Squirrel_Data

1,435 rows where Foraging = 1 sorted by Primary Fur Color

✎ View and edit SQL

This data as json, CSV (advanced)

Kuks ✖

  • 0 27

Foraging ✖

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
2961 2961 -73.9736238258579 40.7688712771191 5F-PM-1007-04 05F PM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9736238258579 40.7688712771191)
2962 2962 -73.9722530826293 40.7667138028361 3I-AM-1010-05 03I AM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9722530826293 40.7667138028361)
2963 2963 -73.9687020800791 40.7735903424522 11H-AM-1010-08 11H AM 10102018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9687020800791 40.7735903424522)
2964 2964 -73.9703604542938 40.776269022329394 13E-AM-1017-04 13E AM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9703604542938 40.7762690223294)
2966 2966 -73.9630596103391 40.792572062055605 32A-AM-1018-04 32A AM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE Base of tree 0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9630596103391 40.7925720620556)
2967 2967 -73.97132575863719 40.776271961946705 13D-AM-1014-09 13D AM 10142018 9 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9713257586372 40.7762719619467)
2969 2969 -73.9654409838612 40.7901338748522 29A-AM-1013-01 29A AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 climbed tree (oak) 0 0 0 0 1 0 0 1   POINT (-73.9654409838612 40.7901338748522)
2972 2972 -73.9631468456897 40.7926110399714 32A-AM-1018-03 32A AM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9631468456897 40.7926110399714)
2977 2977 -73.95806816485471 40.799201001265295 41B-AM-1010-01 41B AM 10102018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9580681648547 40.7992010012653)
2978 2978 -73.96888170064429 40.7829120321438 20B-PM-1013-09 20B PM 10132018 9 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9688817006443 40.7829120321438)
2983 2983 -73.9689586689061 40.7839613907139 21B-PM-1017-04 21B PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9689586689061 40.7839613907139)
2984 2984 -73.9700158929437 40.7762359066591 14E-AM-1008-18 14E AM 10082018 18 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9700158929437 40.7762359066591)
2993 2993 -73.95707222626929 40.798570614351895 40C-AM-1017-04 40C AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 1 1 chasing (#3) 0 0 0 0 0 0 1 0   POINT (-73.9570722262693 40.7985706143519)
2994 2994 -73.96172070912449 40.792283902593496 33B-AM-1010-01 33B AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9617207091245 40.7922839025935)
2995 2995 -73.9668442742942 40.7870781042595 25B-PM-1007-01 25B PM 10072018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9668442742942 40.7870781042595)
2997 2997 -73.96197353854829 40.7944667974974 35A-PM-1013-01 35A PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9619735385483 40.7944667974974)
3000 3000 -73.9688293382172 40.7738958027568 12G-AM-1012-04 12G AM 10122018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9688293382172 40.773895802756805)
3001 3001 -73.97755922284159 40.7668485329273 1D-PM-1007-01 01D PM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9775592228416 40.7668485329273)
3002 3002 -73.9710991846972 40.768982782424104 6H-PM-1020-01 06H PM 10202018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9710991846972 40.7689827824241)
3005 3005 -73.96161411525391 40.7921803313341 33C-PM-1007-04 33C PM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9616141152539 40.7921803313341)
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)
3010 3010 -73.9580906814132 40.7948404060484 37D-PM-1014-01 37D PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1 eyes from a safe distance POINT (-73.9580906814132 40.7948404060484)
3012 3012 -73.96137019608979 40.7943363227822 35B-PM-1013-04 35B PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 0 1 got threatened by dog (same dog,dog #1) 0 0 0 0 0 0 0 1 runs from (dog) POINT (-73.9613701960898 40.7943363227822)
3015 3015 -73.97591633005351 40.7736180793606 9B-AM-1010-08 09B AM 10102018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon head, White (Almost Silver) Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9759163300535 40.7736180793606)
3019 3019 -73.9639431360458 40.7908677445466 30B-AM-1007-04 30B AM 10072018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9639431360458 40.7908677445466)
3020 3020 -73.97040158596391 40.7825600069973 19A-PM-1013-05 19A PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9704015859639 40.7825600069973)
3021 3021 -73.96658719935171 40.783677506488296 22D-PM-1012-07 22D PM 10122018 7 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9665871993517 40.7836775064883)

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