2018_Central_Park_Squirrel_Census_-_Squirrel_Data

18 rows where Hectare Squirrel Number = 5, Indifferent = 1 and Running = 1 sorted by Location

View and edit SQL

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

Indifferent

Hectare Squirrel Number

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
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)
1394 -73.95488263914001 40.7959474571251 39F-AM-1014-05 39F AM 10142018 5 Juvenile Cinnamon   Cinnamon+   Above Ground 2 up/down tree 1 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.95488263914 40.7959474571251)
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)
2157 -73.9657171357842 40.7773277532224 16H-PM-1014-05 16H PM 10142018 5 Adult Gray White Gray+White   Above Ground 5 tree 1 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9657171357842 40.7773277532224)
562 -73.972467515471 40.7659131865172 3I-PM-1013-05 03I PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.972467515471 40.7659131865172)
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)
1141 -73.9664669369583 40.7774085361976 16G-AM-1010-05 16G AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9664669369583 40.7774085361976)
1188 -73.9669529835992 40.787186415136496 25A-AM-1013-05 25A AM 10132018 5   Gray   Gray+   Ground Plane FALSE CROSS BRIDLE - INTO TREE TO AVOID DOGGO 1 0 1 0 0 d.p.t. 0 0 0 1 1 0 1 0 calm POINT (-73.96695298359921 40.7871864151365)
1403 -73.9761632586697 40.7741085606149 9B-PM-1013-05 09B PM 10132018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9761632586697 40.7741085606149)
1456 -73.97142424264959 40.774453579812295 11E-PM-1012-05 11E PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 1 foraging (foraged,ran to tree root,munched) 0 0 0 0 0 0 1 0   POINT (-73.9714242426496 40.7744535798123)
1604 -73.9734644470766 40.7782766486921 14A-PM-1014-05 14A PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.97346444707661 40.7782766486921)
1682 -73.97592584072879 40.7667622711142 2F-PM-1014-05 02F PM 10142018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9759258407288 40.7667622711142)
2032 -73.9590157104896 40.7956884493421 37C-PM-1013-05 37C PM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9590157104896 40.7956884493421)
2155 -73.9538938706987 40.7981150065974 42E-PM-1012-05 42E PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9538938706987 40.7981150065974)
2483 -73.9596083366477 40.7949526729608 36C-PM-1013-05 36C PM 10132018 5 Adult Cinnamon   Cinnamon+ "Warm brown" written in for Primary. Ground Plane FALSE Ran across path in front of people 1 0 0 1 1   0 0 0 0 1 0 1 1   POINT (-73.9596083366477 40.7949526729608)
2581 -73.9635981227569 40.7928169540326 32A-AM-1018-05 32A AM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9635981227569 40.7928169540326)
2907 -73.96852016269341 40.783329261225 21B-AM-1019-05 21B AM 10192018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9685201626934 40.783329261225)
2923 -73.9672160533827 40.7830263908749 21C-AM-1014-05 21C AM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9672160533827 40.7830263908749)

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