2018_Central_Park_Squirrel_Census_-_Squirrel_Data

44 rows where Date = 10062018, Highlight Fur Color = "Cinnamon" and Shift = "AM" sorted by Combination of Primary and Highlight Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, Approaches, Indifferent, Runs from

Tail twitches ✖

  • 0 38
  • 1 6

Shift ✖

Highlight Fur Color ✖

  • Cinnamon · 44 ✖

Date ✖

  • 10062018 · 44 ✖
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
1892 1892 -73.9745908987975 40.7655191512308 1G-AM-1006-03 01G AM 10062018 3 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9745908987975 40.7655191512308)
2433 2433 -73.9706949930717 40.772362045852 10G-AM-1006-08 10G AM 10062018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 3   0 0 0 1 0   0 0 0 1 1 0 1 0   POINT (-73.9706949930717 40.772362045852)
20 20 -73.9706105896967 40.769812482150705 7H-AM-1006-05 07H AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9706105896967 40.7698124821507)
90 90 -73.97871808707359 40.7715877863274 5A-AM-1006-05 05A AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE near 65th St arch 0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9787180870736 40.7715877863274)
160 160 -73.9756015005821 40.7670090327736 2F-AM-1006-01 02F AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE walking along path 0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.97560150058212 40.7670090327736)
169 169 -73.97487064155841 40.7744174965072 10B-AM-1006-02 10B AM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   High in a tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9748706415584 40.7744174965072)
207 207 -73.9770824412252 40.770996130945704 5C-AM-1006-03 05C AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.97708244122522 40.7709961309457)
352 352 -73.970540988328 40.769810306706205 7H-AM-1006-06 07H AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.970540988328 40.7698103067062)
372 372 -73.9781303869038 40.7725000348875 7A-AM-1006-02 07A AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8 in tree 0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9781303869038 40.7725000348875)
419 419 -73.9777328709928 40.7669087724668 1D-AM-1006-02 01D AM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9777328709928 40.7669087724668)
435 435 -73.9702963056917 40.7697928730791 7H-AM-1006-11 07H AM 10062018 11 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9702963056917 40.7697928730791)
472 472 -73.9702721244652 40.7701011774207 7H-AM-1006-15 07H AM 10062018 15 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9702721244652 40.7701011774207)
476 476 -73.9690968160819 40.769923269444 8I-AM-1006-08 08I AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6 tree 0 0 0 0 0   1 1 0 0 0 0 0 0 not backing down POINT (-73.9690968160819 40.769923269444)
486 486 -73.971213385696 40.769872094337 7H-AM-1006-04 07H AM 10062018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.97121338569602 40.769872094337)
712 712 -73.9736169886655 40.7714942196257 7E-AM-1006-06 07E AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.9736169886655 40.7714942196257)
738 738 -73.9725712588741 40.7669101832926 4H-AM-1006-02 04H AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0 climbing (over small wire fence then on the ground) 0 0 0 0 0 1 0 1 approaches (saw me & came forward),runs from (startled by another person) POINT (-73.9725712588741 40.7669101832926)
972 972 -73.9704591091677 40.7729175143429 10G-AM-1006-02 10G AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon notch on tail Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9704591091677 40.7729175143429)
1012 1012 -73.9755569170561 40.7668006977526 2F-AM-1006-03 02F AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25 in tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9755569170561 40.7668006977526)
1035 1035 -73.97725699096729 40.7664804797448 1E-AM-1006-02 01E AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9772569909673 40.7664804797448)
1091 1091 -73.97055600790999 40.7698499183436 7H-AM-1006-07 07H AM 10062018 7 Adult Gray Cinnamon Gray+Cinnamon         0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.97055600791 40.7698499183436)
1209 1209 -73.97631591531379 40.7705785330431 5C-AM-1006-07 05C AM 10062018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9763159153138 40.7705785330431)
1285 1285 -73.97051151894291 40.769839557706796 7H-AM-1006-08 07H AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9705115189429 40.7698395577068)
1400 1400 -73.97734958071351 40.7664559937331 1E-AM-1006-05 01E AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9773495807135 40.7664559937331)
1429 1429 -73.9706533131129 40.768902033818996 6I-AM-1006-01 06I AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground     1 0 1 1 1   0 0 0 0 0 0 0 1 runs from (someone sneezed) POINT (-73.9706533131129 40.768902033819)
1440 1440 -73.9748669205206 40.7743879232016 10B-AM-1006-01 10B AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9748669205206 40.7743879232016)
1455 1455 -73.9715621134573 40.7695918717513 7H-AM-1006-02 07H AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1 running (along ground,up tree) 0 0 0 0 0 0 1 0   POINT (-73.9715621134573 40.76959187175131)
1469 1469 -73.97048311770351 40.7699878995692 7H-AM-1006-10 07H AM 10062018 10 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9704831177035 40.7699878995692)
1556 1556 -73.97462382801159 40.7671491962844 3F-AM-1006-06 03F AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9746238280116 40.7671491962844)
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)
1628 1628 -73.97136652496141 40.76971786480021 7H-AM-1006-01 07H AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 nut in mouth 0 0 0 0 0 0 1 0   POINT (-73.9713665249614 40.7697178648002)
1813 1813 -73.9706988226435 40.7696684566926 7H-AM-1006-16 07H AM 10062018 16 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9706988226435 40.7696684566926)
1853 1853 -73.9721210372896 40.7667971476099 4I-AM-1006-02 04I AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9721210372896 40.7667971476099)
1861 1861 -73.97555625268109 40.7678821029525 3E-AM-1006-07 03E AM 10062018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 burying nuts 0 0 0 0 0 0 0 0   POINT (-73.9755562526811 40.7678821029525)
1921 1921 -73.97562782402329 40.766952370137204 2F-AM-1006-02 02F AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 in tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9756278240233 40.7669523701372)
2223 2223 -73.9784863123685 40.7669225020831 1D-AM-1006-08 01D AM 10062018 8 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 45   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9784863123685 40.7669225020831)
2233 2233 -73.9754709117681 40.7681421869407 3E-AM-1006-08 03E AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9754709117681 40.7681421869407)
2425 2425 -73.9791141532217 40.7714888835416 5A-AM-1006-04 05A AM 10062018 4 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9791141532217 40.77148888354161)
2502 2502 -73.9758375334287 40.7676793289765 3E-AM-1006-06 03E AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 14   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9758375334287 40.7676793289765)
2586 2586 -73.9752965316933 40.775253857578896 10B-AM-1006-03 10B AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   In tree 0 0 1 0 0   0 0 0 0 1 1 0 0   POINT (-73.9752965316933 40.7752538575789)
2635 2635 -73.97638367403421 40.7706121151491 5C-AM-1006-06 05C AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9763836740342 40.7706121151491)
2709 2709 -73.97750689157151 40.7664424394736 1E-AM-1006-01 01E AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9775068915715 40.7664424394736)
2783 2783 -73.97917671562679 40.7714445258765 5A-AM-1006-02 05A AM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 12 in tall shrubs near wall next to CPW 0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9791767156268 40.7714445258765)
2792 2792 -73.97237364945971 40.766950134329704 4H-AM-1006-01 04H AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9723736494597 40.7669501343297)
2928 2928 -73.9767953468937 40.7676376977667 3E-AM-1006-03 03E AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 checkin' his stashes 0 0 0 1 0 1 0 1   POINT (-73.9767953468937 40.7676376977667)

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