2018_Central_Park_Squirrel_Census_-_Squirrel_Data

118 rows where Age = "Juvenile" and Foraging = 1 sorted by Above Ground Sighter Measurement

View and edit SQL

Highlight Fur Color

Foraging

Age

  • Juvenile · 18
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
2434 -73.9545912098958 40.7948301813102 38F-PM-1013-06 38F PM 10132018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9545912098958 40.7948301813102)
2437 -73.9619856085821 40.791951652009104 32C-PM-1013-08 32C PM 10132018 8 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9619856085821 40.7919516520091)
2471 -73.964274290774 40.779531955602295 19H-AM-1010-03 19H AM 10102018 3 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0 ran from human w/ dog POINT (-73.964274290774 40.7795319556023)
2484 -73.9619786450142 40.791987627454795 32C-PM-1013-09 32C PM 10132018 9 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9619786450142 40.7919876274548)
2520 -73.95482071063391 40.7946991812402 38F-PM-1013-04 38F PM 10132018 4 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9548207106339 40.7946991812402)
2544 -73.9713680837672 40.77716615083639 14D-PM-1019-03 14D PM 10192018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9713680837672 40.77716615083641)
2547 -73.9743393747021 40.767634679832504 3F-AM-1006-12 03F AM 10062018 12 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9743393747021 40.7676346798325)
2590 -73.9568524771058 40.7974664985551 40C-PM-1006-06 40C PM 10062018 6 Juvenile Gray   Gray+   Ground Plane FALSE By The Road 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9568524771058 40.7974664985551)
2641 -73.96155167034941 40.790521938835894 31D-AM-1014-04 31D AM 10142018 4 Juvenile Gray   Gray+   Ground Plane FALSE Open ground 1 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9615516703494 40.7905219388359)
2657 -73.9582150734453 40.7962862794303 38C-AM-1019-08 38C AM 10192018 8 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   1 0 0 0 0 0 1 0   POINT (-73.9582150734453 40.7962862794303)
2668 -73.95486485185579 40.7946730924872 38F-PM-1013-03 38F PM 10132018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9548648518558 40.7946730924872)
2695 -73.962800448652 40.7915532640139 31B-PM-1007-03 31B PM 10072018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.962800448652 40.7915532640139)
2736 -73.95938952535009 40.797308584408704 38B-AM-1019-03 38B AM 10192018 3 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9593895253501 40.7973085844087)
2841 -73.9693262952166 40.783260411082004 21B-AM-1019-01 21B AM 10192018 1 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9693262952166 40.783260411082)
2891 -73.9636482556874 40.7775831570186 18I-PM-1007-05 18I PM 10072018 5 Juvenile Cinnamon Gray, Black Cinnamon+Gray, Black   Ground Plane FALSE   0 0 0 0 1 jumping crazily / digging hole 0 0 0 0 0 0 1 0   POINT (-73.9636482556874 40.7775831570186)
2989 -73.9643538221947 40.7917565604735 31A-PM-1017-01 31A PM 10172018 1 Juvenile Cinnamon Gray, White Cinnamon+Gray, White Gray lower back, Gray & Cinnamon selected as Primary with "lower back" written in next to Gray. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9643538221947 40.7917565604735)
2992 -73.9746063250438 40.7687654196811 4F-PM-1013-03 04F PM 10132018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9746063250438 40.7687654196811)
3018 -73.9645437409662 40.7811599933331 21F-PM-1018-02 21F PM 10182018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9645437409662 40.7811599933331)

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