2018_Central_Park_Squirrel_Census_-_Squirrel_Data

51 rows where Date = 10082018 and Highlight Fur Color = "Cinnamon" sorted by longitude

✎ View and edit SQL

This data as json, CSV (advanced)

Moans ✖

  • 0 30

Highlight Fur Color ✖

  • Cinnamon · 30 ✖

Date ✖

  • 10082018 · 30 ✖
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
1664 1664 -73.97291429122029 40.772409114667795 9E-AM-1008-03 09E AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9729142912203 40.7724091146678)
250 250 -73.97267476660019 40.77030226693079 7F-AM-1008-02 07F AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 see stories and locations POINT (-73.9726747666002 40.7703022669308)
2429 2429 -73.97266996869429 40.770112379122295 7F-AM-1008-01 07F AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE under bench 0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9726699686943 40.7701123791223)
1364 1364 -73.9726090882487 40.7710199108849 7F-AM-1008-14 07F AM 10082018 14 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9726090882487 40.7710199108849)
1239 1239 -73.9725897240269 40.7691342079294 6G-AM-1008-01 06G AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20 in tree 0 0 0 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9725897240269 40.7691342079294)
1521 1521 -73.97239229041192 40.7729164833027 9E-AM-1008-01 09E AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9723922904119 40.7729164833027)
1079 1079 -73.9722737593623 40.768963018754 6G-AM-1008-04 06G AM 10082018 4 Juvenile Gray Cinnamon Gray+Cinnamon very long tail Above Ground 20 tree 1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9722737593623 40.768963018754)
2680 2680 -73.9721348050673 40.7666920046704 3H-AM-1008-01 03H AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8   0 0 0 0 0 teasing barking dog 0 0 0 0 0 0 1 0 indifferent by not caring about dog POINT (-73.9721348050673 40.7666920046704)
210 210 -73.97112984911321 40.76769026035429 5I-PM-1008-01 05I PM 10082018 1 Adult Black Cinnamon Black+Cinnamon   Above Ground 15 in tree by arsenal - climbing 0 0 1 1 0   0 0 0 1 0 0 0 0   POINT (-73.9711298491132 40.7676902603543)
1237 1237 -73.9705370795538 40.7761725434851 13E-PM-1008-04 13E PM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Gray selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0 he took 2 steps then turned and stared at me POINT (-73.9705370795538 40.7761725434851)
1472 1472 -73.9698611971209 40.7753915552001 13F-PM-1008-02 13F PM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9698611971209 40.7753915552001)
2456 2456 -73.9698446365683 40.784260716857794 22A-AM-1008-01 22A AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4 on fence 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9698446365683 40.7842607168578)
1508 1508 -73.96938943057859 40.775690674802604 13F-PM-1008-04 13F PM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9693894305786 40.7756906748026)
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)
1401 1401 -73.9681202146851 40.7743979416812 13G-PM-1008-04 13G PM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE lawn @ edge of landscaped area 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9681202146851 40.7743979416812)
810 810 -73.967418114684 40.7764595360054 15G-AM-1008-05 15G AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.967418114684 40.7764595360054)
2271 2271 -73.96739494580959 40.7826218539496 21D-AM-1008-04 21D AM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9673949458096 40.78262185394961)
2925 2925 -73.96721526968341 40.782387458182896 21D-AM-1008-05 21D AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9672152696834 40.7823874581829)
2058 2058 -73.9669017345324 40.776692898707296 15G-AM-1008-01 15G AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9669017345324 40.7766928987073)
909 909 -73.9665705456197 40.782355287104394 21D-PM-1008-05 21D PM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9665705456197 40.7823552871044)
2489 2489 -73.9663168490265 40.7825083721362 21D-AM-1008-01 21D AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 1 1 0 1 0   POINT (-73.9663168490265 40.7825083721362)
462 462 -73.96617859405309 40.7742569936186 13I-PM-1008-01 13I PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 climbed tree 1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9661785940531 40.7742569936186)
718 718 -73.9661694463488 40.7757530583569 15H-PM-1008-07 15H PM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE along bottom of rock outcropping 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9661694463488 40.7757530583569)
1089 1089 -73.9655955841325 40.7762063860571 15H-PM-1008-04 15H PM 10082018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE edge of landscape 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9655955841325 40.7762063860571)
615 615 -73.96532790698879 40.7758743113817 15I-AM-1008-02 15I AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon Could be same squirrel as #1? Above Ground 4 on fence 0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9653279069888 40.7758743113817)
112 112 -73.96517544644391 40.7755181941559 15I-AM-1008-01 15I AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7 tree 0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9651754464439 40.7755181941559)
2431 2431 -73.9630054996358 40.790522514702204 30C-PM-1008-01 30C PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9630054996358 40.7905225147022)
2724 2724 -73.96114340826671 40.7893671772846 30E-PM-1008-01 30E PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40   0 0 1 0 0   0 1 0 0 0 0 0 0   POINT (-73.9611434082667 40.7893671772846)
43 43 -73.9574648097543 40.7892508428622 31H-PM-1008-02 31H PM 10082018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   1 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9574648097543 40.78925084286221)
2146 2146 -73.95473986848171 40.7896483795302 33I-AM-1008-01 33I AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE edge of park @ 98th (north) 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9547398684817 40.7896483795302)

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