2018_Central_Park_Squirrel_Census_-_Squirrel_Data

131 rows where Eating = 1 and Tail twitches = 1 sorted by Other Interactions

✎ View and edit SQL

This data as json, CSV (advanced)

Highlight Fur Color ✖

Tail twitches ✖

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
2508 2508 -73.97938145045201 40.770903369788705 4A-PM-1007-01 04A PM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 1 1   0 0 0 0 1 0 1 0   POINT (-73.979381450452 40.770903369788705)
2511 2511 -73.95845615374209 40.791121116475395 33F-PM-1012-02 33F PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 1 0 0 0   POINT (-73.9584561537421 40.7911211164754)
2515 2515 -73.9693338657183 40.775705588453796 13F-PM-1008-05 13F PM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 tree trunk 1 0 0 1 1   1 0 0 0 1 0 0 0   POINT (-73.9693338657183 40.77570558845381)
2587 2587 -73.97899712868441 40.7707024146365 5A-PM-1010-04 05A PM 10102018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9789971286844 40.7707024146365)
2604 2604 -73.9605163698302 40.7914179994956 32D-PM-1006-05 32D PM 10062018 5 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 1 1 0   0 0 0 0 1 0 0 1   POINT (-73.9605163698302 40.7914179994956)
2606 2606 -73.96143417385001 40.794546426211205 35B-PM-1013-02 35B PM 10132018 2 Juvenile     +   Ground Plane FALSE   0 0 0 1 0 did not notice dog sitting a few yards away (10-20 ft) 0 0 0 0 1 0 1 0   POINT (-73.96143417385 40.7945464262112)
2610 2610 -73.9713379914423 40.7696367609606 7H-PM-1006-01 07H PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE middle of grass 0 0 0 1 1   0 0 0 0 1 1 0 0   POINT (-73.9713379914423 40.7696367609606)
2641 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)
2655 2655 -73.9659156108069 40.781070981869604 20E-AM-1014-01 20E AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9659156108069 40.7810709818696)
2683 2683 -73.972179947936 40.7810042827198 17A-PM-1013-02 17A PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20 on a little pedestal-shaped part of a tree 0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.972179947936 40.7810042827198)
2736 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)
2739 2739 -73.9681960138614 40.7726867422002 11H-AM-1010-02 11H AM 10102018 2   Cinnamon Gray Cinnamon+Gray         0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9681960138614 40.7726867422002)
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)
2776 2776 -73.9789687905912 40.769269313932796 3B-PM-1007-04 03B PM 10072018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 At fence 1 0 1 1 0   0 0 0 0 1 0 1 1   POINT (-73.9789687905912 40.7692693139328)
2801 2801 -73.9697665830132 40.7759094917104 13E-PM-1008-08 13E PM 10082018 8 Juvenile Cinnamon Black, White Cinnamon+Black, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9697665830132 40.7759094917104)
2816 2816 -73.9809342290598 40.7687265606227 2A-AM-1010-05 02A AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE base of tree with ~ 30 small birds all eating 0 0 0 1 1   0 0 0 0 1 1 1 0   POINT (-73.9809342290598 40.7687265606227)
2833 2833 -73.9552595564798 40.7889533029466 32I-PM-1007-01 32I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 1 1 chirps 0 0 0 0 1 0 1 0   POINT (-73.9552595564798 40.7889533029466)
2878 2878 -73.969720780557 40.774110568875706 12F-AM-1020-04 12F AM 10202018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.969720780557 40.7741105688757)
2947 2947 -73.96012151981141 40.7909769801241 32D-PM-1006-02 32D PM 10062018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9601215198114 40.7909769801241)
3004 3004 -73.9528482858163 40.7922056218325 36I-PM-1007-08 36I PM 10072018 8 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9528482858163 40.7922056218325)
3015 3015 -73.97591633005351 40.7736180793606 9B-AM-1010-08 09B AM 10102018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon head, White (Almost Silver) Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9759163300535 40.7736180793606)
128 128 -73.97462290946429 40.7748467061969 10B-PM-1014-05 10B PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 0 0 avoided people POINT (-73.9746229094643 40.7748467061969)
1614 1614 -73.9806718258385 40.7692776896995 2A-AM-1010-07 02A AM 10102018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 0 0 couldn't get near POINT (-73.9806718258385 40.76927768969951)
203 203 -73.96387745795491 40.79135321291479 31A-AM-1010-05 31A AM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1 jumping 0 0 0 1 1 0 1 0 eventually ran from lawnmower (tail flag) POINT (-73.9638774579549 40.7913532129148)
1108 1108 -73.96383977903841 40.782895027290394 23F-PM-1013-02 23F PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 1 0 0 1 0 1 0 indifferent (mostly,did notice me,busy eating,foraging) POINT (-73.9638397790384 40.7828950272904)
1681 1681 -73.9638141923763 40.782922532628795 23F-PM-1013-03 23F PM 10132018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0 indifferent (noticed me,busy eating,foraging) POINT (-73.9638141923763 40.7829225326288)
1795 1795 -73.968004352343 40.7726669278308 11I-PM-1012-01 11I PM 10122018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 1   0 0 0 1 1 0 0 0 look at humans determining POINT (-73.968004352343 40.7726669278308)
381 381 -73.959709414696 40.7919745085986 33D-PM-1006-03 33D PM 10062018 3   Black   Black+   Above Ground 15   1 0 0 1 0   0 0 0 0 1 0 0 1 ran up tree POINT (-73.959709414696 40.7919745085986)
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)
2723 2723 -73.96064260275601 40.791726541984204 32D-PM-1006-08 32D PM 10062018 8 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 0 0 stand on two feet and watching me POINT (-73.960642602756 40.7917265419842)
1241 1241 -73.9651817987035 40.781908283833396 21E-AM-1017-01 21E AM 10172018 1 Adult Gray White Gray+White   Above Ground 3 Climbs small tree 0 0 0 1 1   0 0 0 0 1 0 0 0 walks from POINT (-73.9651817987035 40.7819082838334)

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