2018_Central_Park_Squirrel_Census_-_Squirrel_Data

32 rows where Eating = 1, Hectare Squirrel Number = 5 and Shift = "AM" sorted by Approaches

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Foraging, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Shift ✖

Hectare Squirrel Number ✖

Eating ✖

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
57 57 -73.9690175838534 40.77604327200171 14F-AM-1007-05 14F AM 10072018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9690175838534 40.7760432720017)
80 80 -73.9688454483585 40.78453012881629 22A-AM-1008-05 22A AM 10082018 5 Adult Gray White Gray+White   Above Ground 3 trash can 0 0 0 1 0   0 0 0 1 0 0 0 1   POINT (-73.9688454483585 40.7845301288163)
203 203 -73.96387745795491 40.79135321291479 31A-AM-1010-05 31A AM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1 jumping 0 0 0 1 1 0 1 0 eventually ran from lawnmower (tail flag) POINT (-73.9638774579549 40.7913532129148)
231 231 -73.9527808174534 40.7924167234441 36I-AM-1017-05 36I AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1 runs from (me) POINT (-73.9527808174534 40.7924167234441)
313 313 -73.9646610347972 40.7790583544252 19H-AM-1010-05 19H AM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE near a brush 0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9646610347972 40.7790583544252)
676 676 -73.9710207438538 40.7682187144432 5I-AM-1010-05 05I AM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9710207438538 40.7682187144432)
703 703 -73.95763044737221 40.795981062234205 38D-AM-1017-05 38D AM 10172018 5 Adult Gray Black, Cinnamon Gray+Black, Cinnamon Black stripe along sides Ground Plane FALSE   1 0 0 1 0 eating (nut) 0 0 0 0 0 0 0 1   POINT (-73.9576304473722 40.7959810622342)
792 792 -73.97301156879641 40.7741018274312 10D-AM-1008-05 10D AM 10082018 5 Juvenile Gray White Gray+White   Above Ground 25   0 0 1 1 0   0 0 0 0 0 0 0 0   POINT (-73.9730115687964 40.7741018274312)
921 921 -73.9698959071826 40.7716763799299 9H-AM-1006-05 09H AM 10062018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9698959071826 40.7716763799299)
928 928 -73.96704295859901 40.778437071937105 17F-AM-1007-05 17F AM 10072018 5 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.967042958599 40.7784370719371)
977 977 -73.9764601882854 40.766070446642 1F-AM-1010-05 01F AM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9764601882854 40.766070446642)
994 994 -73.9718553361982 40.7748584798761 11D-AM-1010-05 11D AM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9718553361982 40.7748584798761)
1020 1020 -73.97016933635 40.770545252978295 8H-AM-1017-05 08H AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.97016933635001 40.7705452529783)
1382 1382 -73.9611274898661 40.7915250069086 32C-AM-1014-05 32C AM 10142018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9611274898661 40.7915250069086)
1491 1491 -73.97130702170709 40.7753795014815 12E-AM-1017-05 12E AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9713070217071 40.7753795014815)
1624 1624 -73.97370600439879 40.772566022498296 8D-AM-1007-05 08D AM 10072018 5 Adult Gray   Gray+   Above Ground 15   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9737060043988 40.7725660224983)
1695 1695 -73.9604083891356 40.7910284106931 32D-AM-1013-05 32D AM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9604083891356 40.7910284106931)
1705 1705 -73.97654172820009 40.7740994735325 9A-AM-1013-05 09A AM 10132018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9765417282001 40.7740994735325)
1734 1734 -73.9524132295658 40.7933777553406 37I-AM-1010-05 37I AM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.95241322956582 40.7933777553406)
1891 1891 -73.9749641575871 40.767330505627704 3F-AM-1006-05 03F AM 10062018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3   0 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9749641575871 40.7673305056277)
2106 2106 -73.9801651470389 40.767769865693495 1B-AM-1012-05 01B AM 10122018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9801651470389 40.7677698656935)
2159 2159 -73.9696688162449 40.774142217718705 12F-AM-1020-05 12F AM 10202018 5 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.9696688162449 40.7741422177187)
2167 2167 -73.9799594281222 40.7701978146968 4A-AM-1007-05 04A AM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9799594281222 40.7701978146968)
2202 2202 -73.95560399976209 40.7977549157287 40D-AM-1013-05 40D AM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9556039997621 40.7977549157287)
2344 2344 -73.9786310308892 40.766934936818295 1D-AM-1006-05 01D AM 10062018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.9786310308892 40.7669349368183)
2701 2701 -73.97912175106559 40.767658347539395 2C-AM-1010-05 02C AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE right at the base of the same tree as #3 0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9791217510656 40.7676583475394)
2805 2805 -73.9711634340673 40.7760553338671 13D-AM-1014-05 13D AM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9711634340673 40.7760553338671)
2854 2854 -73.9772908667333 40.7697207404744 4C-AM-1006-05 04C AM 10062018 5 Juvenile Gray White Gray+White   Above Ground 20   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9772908667333 40.7697207404744)
2925 2925 -73.96721526968341 40.782387458182896 21D-AM-1008-05 21D AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9672152696834 40.7823874581829)
1944 1944 -73.97432920664129 40.7756090404121 11B-AM-1007-05 11B AM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 1 0 1 0 0   POINT (-73.9743292066413 40.7756090404121)
2646 2646 -73.9772239251936 40.7731716665766 8A-AM-1013-05 08A AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   1 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9772239251936 40.7731716665766)
2816 2816 -73.9809342290598 40.7687265606227 2A-AM-1010-05 02A AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE base of tree with ~ 30 small birds all eating 0 0 0 1 1   0 0 0 0 1 1 1 0   POINT (-73.9809342290598 40.7687265606227)

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