2018_Central_Park_Squirrel_Census_-_Squirrel_Data

144 rows where Eating = 1 and Highlight Fur Color = "White" sorted by latitude

✎ View and edit SQL

This data as json, CSV (advanced)

Above Ground Sighter Measurement ✖

Tail twitches ✖

  • 0 38
  • 1 6

Highlight Fur Color ✖

  • White · 44 ✖

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
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)
1478 1478 -73.9676370985166 40.7869888639434 25A-AM-1013-01 25A AM 10132018 1   Gray White Gray+White White Belly Ground Plane FALSE   0 0 0 1 0 staring at me 0 0 0 0 0 0 1 0   POINT (-73.96763709851662 40.7869888639434)
2742 2742 -73.96280415779341 40.7884180156055 28D-AM-1012-06 28D AM 10122018 6 Juvenile Cinnamon White Cinnamon+White   Above Ground 5   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9628041577934 40.78841801560551)
2497 2497 -73.9622050752008 40.7886373772305 29D-PM-1010-01 29D PM 10102018 1 Juvenile Gray White Gray+White   Above Ground 10   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9622050752008 40.7886373772305)
1672 1672 -73.9640989602986 40.789929543926505 29B-PM-1010-03 29B PM 10102018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9640989602986 40.7899295439265)
1093 1093 -73.9584106786233 40.7902777556926 32F-PM-1008-02 32F PM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9584106786233 40.7902777556926)
2766 2766 -73.95516398474659 40.790858199891 34H-PM-1006-03 34H PM 10062018 3   Gray White Gray+White white belly Ground Plane FALSE Under Tupelo Tree 0 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.9551639847466 40.790858199891)
383 383 -73.9588358879692 40.7912631913057 33E-PM-1012-01 33E PM 10122018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9588358879692 40.7912631913057)
106 106 -73.9634623418761 40.7917685404482 31A-PM-1017-04 31A PM 10172018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9634623418761 40.7917685404482)
1561 1561 -73.9642397829547 40.7918992406575 31A-PM-1017-02 31A PM 10172018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.96423978295472 40.7918992406575)
115 115 -73.9530040923555 40.7922896176936 36I-PM-1007-10 36I PM 10072018 10 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0 stole (found?) an entire sandwich 0 0 0 0 0 0 1 0   POINT (-73.9530040923555 40.7922896176936)
1911 1911 -73.9528937660465 40.7922919074537 36I-AM-1017-01 36I AM 10172018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 1 runs from (me!)—from a pretty big distance POINT (-73.9528937660465 40.7922919074537)
2231 2231 -73.95454276114769 40.793035381744104 36G-PM-1012-02 36G PM 10122018 2 Adult Gray White Gray+White   Above Ground 10   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9545427611477 40.7930353817441)
2430 2430 -73.9569811285656 40.793091234605 35F-PM-1012-02 35F PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9569811285656 40.793091234605)
1107 1107 -73.95307395621309 40.7932034409546 37H-PM-1006-01 37H PM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1 from voice POINT (-73.95307395621312 40.7932034409546)
258 258 -73.9534333425633 40.793256416332795 37H-AM-1018-03 37H AM 10182018 3 Adult Gray White Gray+White   Above Ground 10 in a tree with red berries 0 0 0 1 0   0 1 0 0 0 0 0 1   POINT (-73.9534333425633 40.7932564163328)
1231 1231 -73.9555583724966 40.7932879745739 36F-PM-1012-07 36F PM 10122018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9555583724966 40.7932879745739)
743 743 -73.9565035705619 40.7937382705056 36F-AM-1017-04 36F AM 10172018 4 Juvenile Gray White Gray+White White legs, front & back Ground Plane FALSE   1 0 0 1 1   1 0 0 0 0 1 0 1 approaches (me),runs from (me) POINT (-73.9565035705619 40.7937382705056)
299 299 -73.9586214081667 40.7937473968735 35D-PM-1013-03 35D PM 10132018 3 Juvenile Gray White Gray+White No Tail! Above Ground 2 bench 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9586214081667 40.7937473968735)
2716 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)
1482 1482 -73.95886101956991 40.7945269936639 36C-AM-1014-02 36C AM 10142018 2 Juvenile Gray White Gray+White   Ground Plane FALSE Crossing path 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9588610195699 40.7945269936639)
2545 2545 -73.9617594316752 40.7946803725236 35A-AM-1014-01 35A AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9617594316752 40.7946803725236)
1767 1767 -73.958719099962 40.7947587726617 36C-AM-1014-04 36C AM 10142018 4   Gray White Gray+White   Above Ground 15 Ground then tree to eat 1 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.958719099962 40.7947587726617)
272 272 -73.9521950056404 40.794937340844996 39H-PM-1013-01 39H PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0 ran away when a human approached with a dog POINT (-73.9521950056404 40.794937340845)
1203 1203 -73.9616999731028 40.7954126939561 36A-AM-1018-02 36A AM 10182018 2 Juvenile Gray White Gray+White   Above Ground 15   0 0 0 1 0 eating (red berries) 0 0 0 0 0 0 1 0   POINT (-73.9616999731028 40.7954126939561)
331 331 -73.95448101115 40.7954469678857 39F-PM-1006-03 39F PM 10062018 3 Adult Gray White Gray+White   Above Ground 15 lower branch of tree 0 0 0 1 0   0 0 0 0 0 0 0 1 ran up tree when approached POINT (-73.95448101115 40.7954469678857)
488 488 -73.9615751148595 40.795455123814605 36A-AM-1018-01 36A AM 10182018 1 Juvenile Gray White Gray+White   Above Ground 15   0 0 0 1 0 eating (red berries) 0 0 0 0 0 0 1 0   POINT (-73.9615751148595 40.7954551238146)
1494 1494 -73.95257524081691 40.7954915417553 39H-AM-1007-03 39H AM 10072018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9525752408169 40.7954915417553)
1707 1707 -73.96045242711669 40.7956624328733 36B-AM-1013-01 36B AM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9604524271167 40.7956624328733)
2102 2102 -73.9593909381748 40.7961036981921 37B-PM-1013-03 37B PM 10132018 3 Adult Cinnamon White Cinnamon+White White back left leg       0 0 0 1 1 watching 0 0 0 0 0 0 0 1   POINT (-73.9593909381748 40.7961036981921)
2618 2618 -73.95795157569 40.7961254697958 38C-PM-1014-04 38C PM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 0   0 0 0 1 0 0 0 1   POINT (-73.95795157569 40.7961254697958)
2288 2288 -73.9577009571427 40.796126044520996 38C-PM-1014-10 38C PM 10142018 10 Juvenile Gray White Gray+White   Above Ground 10   0 0 1 1 1 climbing (down from ~10') 0 0 0 0 0 0 0 1   POINT (-73.9577009571427 40.796126044521)
1410 1410 -73.95879132892291 40.7961707624534 38C-AM-1019-11 38C AM 10192018 11 Adult Gray White Gray+White   Above Ground 20   1 0 1 1 0   1 0 0 0 1 0 0 1   POINT (-73.9587913289229 40.7961707624534)
1381 1381 -73.9586077039567 40.796189647707706 38C-AM-1019-10 38C AM 10192018 10 Adult Gray White Gray+White   Above Ground 20   1 0 1 1 0   1 0 0 0 1 0 0 1   POINT (-73.9586077039567 40.7961896477077)
1977 1977 -73.9586570546871 40.796349417475 38C-AM-1019-09 38C AM 10192018 9 Adult Gray White Gray+White Gray & White selected as Primary & Highlights. Made executive adjustments. Above Ground 3 Between ground & tree 0 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.9586570546871 40.796349417475)
2398 2398 -73.95871384837301 40.7963918051751 38C-PM-1014-02 38C PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.958713848373 40.7963918051751)
2804 2804 -73.9576094432477 40.7965342664074 38C-PM-1014-07 38C PM 10142018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9576094432477 40.7965342664074)
699 699 -73.95046935442251 40.797225436004 42H-AM-1019-01 42H AM 10192018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9504693544225 40.797225436004)
2645 2645 -73.9584967368893 40.797732034109394 39B-PM-1014-05 39B PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1 pretended to bury a nut,stuck a leaf on top to make the spot less conspicuous. 0 0 0 0 0 0 1 0   POINT (-73.9584967368893 40.7977320341094)
845 845 -73.9582850206205 40.7978975855555 39B-PM-1014-01 39B PM 10142018 1 Adult Gray White Gray+White White belly Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9582850206205 40.7978975855555)
2277 2277 -73.95385121459 40.7981257651433 42E-PM-1012-04 42E PM 10122018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.95385121459 40.7981257651433)
2885 2885 -73.9530811255728 40.7983069118579 42F-AM-1019-02 42F AM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9530811255728 40.79830691185791)
2659 2659 -73.95536034380208 40.7985282963244 41D-PM-1014-05 41D PM 10142018 5 Adult Gray White Gray+White   Above Ground 12   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9553603438021 40.7985282963244)
2953 2953 -73.9585862117341 40.7986549251083 40A-PM-1014-05 40A PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1 eating (in a tree cage thing) 0 0 0 0 0 0 1 0   POINT (-73.9585862117341 40.7986549251083)

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