2018_Central_Park_Squirrel_Census_-_Squirrel_Data

28 rows where Hectare Squirrel Number = 9, Indifferent = 0 and Runs from = 0 sorted by Primary Fur Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Quaas, Tail twitches, Approaches

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
794 794 -73.9790010565108 40.768573236954396 2C-PM-1013-09 02C PM 10132018 9 Adult     +   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9790010565108 40.7685732369544)
42 42 -73.9579564338627 40.795933779502704 38C-PM-1014-09 38C PM 10142018 9 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9579564338627 40.7959337795027)
19 19 -73.9768603630674 40.7702795904962 5C-PM-1010-09 05C PM 10102018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9768603630674 40.7702795904962)
298 298 -73.957342596188 40.7944359654227 37E-PM-1006-09 37E PM 10062018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 0 moseying 0 0 0 0 1 1 0 0   POINT (-73.957342596188 40.7944359654227)
320 320 -73.9684376038582 40.78242750672371 20C-PM-1018-09 20C PM 10182018 9 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9684376038582 40.7824275067237)
348 348 -73.9542990150586 40.794091530067796 37G-PM-1007-09 37G PM 10072018 9 Adult Cinnamon White Cinnamon+White         0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9542990150586 40.7940915300678)
946 946 -73.96540938440491 40.7806896368469 20F-PM-1007-09 20F PM 10072018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.9654093844049 40.7806896368469)
1221 1221 -73.9796409671481 40.767904987118605 1C-PM-1013-09 01C PM 10132018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9796409671481 40.7679049871186)
2799 2799 -73.96826273820729 40.773076674345205 11H-AM-1010-09 11H AM 10102018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9682627382073 40.7730766743452)
314 314 -73.960601067176 40.7917243850136 32D-PM-1006-09 32D PM 10062018 9 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 1 0 0   POINT (-73.960601067176 40.7917243850136)
411 411 -73.9669366401071 40.783602389798205 22C-PM-1006-09 22C PM 10062018 9 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 1 0 0 0 0 0 0   POINT (-73.96693664010711 40.7836023897982)
666 666 -73.96870277827259 40.770516261619896 9I-AM-1014-09 09I AM 10142018 9 Adult Gray   Gray+   Above Ground 5   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.96870277827261 40.7705162616199)
704 704 -73.97935655643609 40.767925939044794 2C-AM-1010-09 02C AM 10102018 9 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0 climbed up tree as i neared POINT (-73.9793565564361 40.7679259390448)
919 919 -73.96372797118529 40.7905198502307 30B-AM-1007-09 30B AM 10072018 9 Adult Gray   Gray+   Above Ground 50   0 0 1 0 0 jumping b/w trees 0 0 0 0 0 0 0 0   POINT (-73.9637279711853 40.7905198502307)
970 970 -73.97035767623 40.77140364877471 9H-PM-1018-09 09H PM 10182018 9 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.97035767623 40.7714036487747)
973 973 -73.97059770598621 40.7760413182276 13E-AM-1017-09 13E AM 10172018 9 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9705977059862 40.776041318227605)
1240 1240 -73.96961191797891 40.780292611186496 18C-PM-1018-09 18C PM 10182018 9 Juvenile Gray   Gray+   Above Ground 5   0 0 1 1 1   0 0 0 0 0 0 0 0   POINT (-73.9696119179789 40.7802926111865)
1277 1277 -73.9619609976132 40.7922824443528 33B-PM-1010-09 33B PM 10102018 9 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9619609976132 40.7922824443528)
1335 1335 -73.969560591279 40.7705619840715 8I-AM-1006-09 08I AM 10062018 9 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0 very curious,looked like it expected food POINT (-73.969560591279 40.7705619840715)
1383 1383 -73.96767327256721 40.7763194425467 15G-PM-1019-09 15G PM 10192018 9 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9676732725672 40.7763194425467)
1557 1557 -73.9705331808443 40.769994357129605 7H-AM-1006-09 07H AM 10062018 9 Adult Gray Cinnamon Gray+Cinnamon         0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9705331808443 40.7699943571296)
1915 1915 -73.9797112925048 40.76880467784721 2B-PM-1013-09 02B PM 10132018 9 Adult Gray White Gray+White   Above Ground 30   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9797112925048 40.7688046778472)
2123 2123 -73.959874668294 40.7907004233491 32E-AM-1007-09 32E AM 10072018 9 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.959874668294 40.7907004233491)
2319 2319 -73.97568707891871 40.773364678267896 9B-AM-1010-09 09B AM 10102018 9 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0 food in mouth 0 0 0 0 0 0 0 0   POINT (-73.9756870789187 40.7733646782679)
2484 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)
2633 2633 -73.9776151109912 40.7694681558386 4C-PM-1010-09 04C PM 10102018 9 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9776151109912 40.7694681558386)
2692 2692 -73.98016364007441 40.769019205592606 2A-AM-1010-09 02A AM 10102018 9 Adult Gray White Gray+White   Above Ground   climbing in bush 0 0 1 0 0 hopping & flipping around. this one was very energetic & jumping aorund 0 0 0 0 1 0 0 0 climbed a foot up a tree and watched me POINT (-73.9801636400744 40.7690192055926)
2708 2708 -73.9528429238071 40.7922651848867 36I-PM-1007-09 36I PM 10072018 9 Juvenile Gray   Gray+   Above Ground 5   1 1 0 0 0 burying nut 0 0 0 0 1 0 0 0   POINT (-73.9528429238071 40.7922651848867)

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