2018_Central_Park_Squirrel_Census_-_Squirrel_Data

21 rows where Foraging = 1, Hectare Squirrel Number = 3 and Running = 1 sorted by Lat/Long

View and edit SQL

Suggested facets: Hectare, Shift, Date, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Chasing, Climbing, Eating, Tail twitches, Approaches, Indifferent, Runs from

Location

Running

Hectare Squirrel Number

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 ▼
786 -73.953296595236 40.7927644594513 36I-AM-1017-03 36I AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon Cinnamon stripe on back Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.953296595236 40.7927644594513)
828 -73.9545101041865 40.790382361678205 34I-PM-1010-03 34I PM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE in the playground. 1 0 0 0 1 with some nuts in the mouth 0 0 0 0 0 0 0 0   POINT (-73.9545101041865 40.7903823616782)
1748 -73.955710327539 40.797451079756705 40D-AM-1013-03 40D AM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.955710327539 40.7974510797567)
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)
2485 -73.9584950620879 40.790277071064295 32F-PM-1008-03 32F PM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 1 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9584950620879 40.7902770710643)
1447 -73.9601968065017 40.7935831836482 34C-PM-1012-03 34C PM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9601968065017 40.79358318364821)
2373 -73.9613276802049 40.7943813964442 35B-PM-1013-03 35B PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1 threatened by approaching dog (dog #1) 0 0 0 0 0 0 0 1 runs from (dog) POINT (-73.96132768020492 40.7943813964442)
2716 -73.9618094076328 40.7944097368153 35A-PM-1013-03 35A PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9618094076328 40.7944097368153)
963 -73.9621066718851 40.7942427079733 34A-AM-1012-03 34A AM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9621066718851 40.7942427079733)
1200 -73.9657721715305 40.778534830257 18G-PM-1013-03 18G PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9657721715305 40.778534830257)
2903 -73.9670432105975 40.7753462013506 14H-PM-1012-03 14H PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9670432105975 40.7753462013506)
402 -73.9681917366128 40.7723298813768 11I-PM-1012-03 11I PM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 0 0 0 1 runs from the dog POINT (-73.9681917366128 40.7723298813768)
2694 -73.969628583287 40.770406779793205 8H-AM-1017-03 08H AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 fence 1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.969628583287 40.7704067797932)
413 -73.96989341826121 40.7708211633861 8H-PM-1014-03 08H PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9698934182612 40.7708211633861)
21 -73.9703781726172 40.778752613032104 16C-PM-1018-03 16C PM 10182018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9703781726172 40.7787526130321)
1242 -73.9714512125212 40.77602752501139 13D-PM-1018-03 13D PM 10182018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9714512125212 40.7760275250114)
1021 -73.97186968288 40.778926988884 15B-AM-1014-03 15B AM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1 running (from a dog) 0 0 0 0 0 0 1 0   POINT (-73.97186968288 40.778926988884)
2890 -73.9726236083428 40.7788217771475 15B-PM-1017-03 15B PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE by water 1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9726236083428 40.778821777147506)
716 -73.9745427984089 40.7691848214817 5E-AM-1008-03 05E AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9745427984089 40.7691848214817)
2259 -73.975565603566 40.7738462518304 9B-AM-1010-03 09B AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   1 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.975565603566 40.7738462518304)
2871 -73.9777124331985 40.7704051056666 5B-AM-1008-03 05B AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9777124331985 40.7704051056666)

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