2018_Central_Park_Squirrel_Census_-_Squirrel_Data

41 rows where Date = 10072018, Hectare Squirrel Number = 2 and Shift = "AM" sorted by Kuks

✎ View and edit SQL

This data as json, CSV (advanced)

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

Shift ✖

Hectare Squirrel Number ✖

Date ✖

  • 10072018 · 41 ✖
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
68 68 -73.96942403275091 40.7755898126674 13F-AM-1007-02 13F AM 10072018 2 Adult Cinnamon White Cinnamon+White         0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.96942403275091 40.7755898126674)
86 86 -73.9708726050721 40.7723572030236 10F-AM-1007-02 10F AM 10072018 2 Adult Gray   Gray+   Above Ground 70   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9708726050721 40.7723572030236)
92 92 -73.9565759733611 40.7992461674802 42C-AM-1007-02 42C AM 10072018 2       +         0 0 0 0 0   0 1 0 0 0 0 0 0   POINT (-73.9565759733611 40.7992461674802)
234 234 -73.9741401377844 40.7758134257881 12B-AM-1007-02 12B AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9741401377844 40.7758134257881)
304 304 -73.9523001834395 40.7949231000186 39H-AM-1007-02 39H AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9523001834395 40.7949231000186)
319 319 -73.96590343597059 40.779751668884394 19F-AM-1007-02 19F AM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 8   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9659034359706 40.77975166888441)
371 371 -73.964080104186 40.79078986272871 30B-AM-1007-02 30B AM 10072018 2 Adult Gray   Gray+   Above Ground 15   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.964080104186 40.7907898627287)
425 425 -73.9704485231855 40.7717290560806 9G-AM-1007-02 09G AM 10072018 2 Adult Gray   Gray+   Above Ground 25   0 0 1 0 0   0 0 0 0 0 0 0 1 kids were trying to poke it with a stick POINT (-73.9704485231855 40.7717290560806)
484 484 -73.9666526554772 40.7756111718355 14H-AM-1007-02 14H AM 10072018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9666526554772 40.77561117183551)
525 525 -73.952526164386 40.796375924050395 40G-AM-1007-02 40G AM 10072018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 18   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.952526164386 40.7963759240504)
553 553 -73.9638526062093 40.782693848993 22F-AM-1007-02 22F AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 standing 0 0 0 0 0 0 1 0   POINT (-73.9638526062093 40.782693848993)
555 555 -73.9685227310735 40.776599466588 15F-AM-1007-02 15F AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO Above Ground 20   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9685227310735 40.776599466588)
648 648 -73.95394000282359 40.79800412717 41E-AM-1007-02 41E AM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9539400028236 40.79800412717)
694 694 -73.9698032734704 40.7782343912417 16D-AM-1007-02 16D AM 10072018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9698032734704 40.7782343912417)
848 848 -73.9692190295442 40.776336630915395 14F-AM-1007-02 14F AM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9692190295442 40.7763366309154)
858 858 -73.96293834202741 40.7889383725489 29C-AM-1007-02 29C AM 10072018 2 Adult Black Gray Black+Gray   Above Ground 10   1 0 1 0 0   0 1 0 0 0 0 0 1   POINT (-73.9629383420274 40.7889383725489)
892 892 -73.9611368390233 40.7815619053395 22I-AM-1007-02 22I AM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9611368390233 40.7815619053395)
894 894 -73.96751982309179 40.778631094685004 17F-AM-1007-02 17F AM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9675198230918 40.778631094685)
1046 1046 -73.9647891228606 40.789853066039 29B-AM-1007-02 29B AM 10072018 2 Adult Gray   Gray+   Above Ground 30   1 0 0 0 0   0 0 0 1 0 0 0 0   POINT (-73.9647891228606 40.789853066039)
1095 1095 -73.9735547926323 40.772342007610796 8D-AM-1007-02 08D AM 10072018 2 Adult Gray   Gray+   Above Ground 12   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9735547926323 40.7723420076108)
1220 1220 -73.97799837948492 40.767545209917294 2D-AM-1007-02 02D AM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6 up tree 0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9779983794849 40.7675452099173)
1228 1228 -73.9729090336637 40.779434005250295 15A-AM-1007-02 15A AM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0 in fenced in lawn (chill) POINT (-73.9729090336637 40.7794340052503)
1325 1325 -73.97752788478971 40.7687881061059 3C-AM-1007-02 03C AM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9775278847897 40.7687881061059)
1607 1607 -73.9770508584979 40.7710769301257 6C-AM-1007-02 06C AM 10072018 2 Adult     +   Above Ground 15   0 0 1 0 0 pulling things off branches 0 0 0 0 0 0 0 0   POINT (-73.9770508584979 40.7710769301257)
1633 1633 -73.97470601437419 40.7728528164878 8C-AM-1007-02 08C AM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0 peeps out from behind tree at cooing tourists POINT (-73.9747060143742 40.7728528164878)
1724 1724 -73.9795492724533 40.770949747173795 4A-AM-1007-02 04A AM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9795492724533 40.7709497471738)
1804 1804 -73.98077710643099 40.7681635726316 1A-AM-1007-02 01A AM 10072018 2 Adult Gray White Gray+White   Above Ground 11   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.980777106431 40.7681635726316)
1808 1808 -73.9698870647042 40.7826510985538 20B-AM-1007-02 20B AM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 1 1 0 0   POINT (-73.9698870647042 40.7826510985538)
1879 1879 -73.97019267362809 40.7778587687376 15D-AM-1007-02 15D AM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9701926736281 40.7778587687376)
1899 1899 -73.9764314091366 40.773645805795205 8B-AM-1007-02 08B AM 10072018 2 Adult Gray   Gray+   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9764314091366 40.773645805795205)
1949 1949 -73.9605362268777 40.7939470599346 35C-AM-1007-02 35C AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9605362268777 40.7939470599346)
1972 1972 -73.9558370309765 40.7921977208472 35G-AM-1007-02 35G AM 10072018 2 Adult Gray White Gray+White   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9558370309765 40.7921977208472)
2037 2037 -73.96833704175509 40.781359835050004 19D-AM-1007-02 19D AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 1 0 1   0 0 0 0 1 0 0 0 fenced area POINT (-73.9683370417551 40.78135983505)
2230 2230 -73.9730813162152 40.7779315720879 14B-AM-1007-02 14B AM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9730813162152 40.7779315720879)
2273 2273 -73.9671534029191 40.7810849804467 20D-AM-1007-02 20D AM 10072018 2 Adult Gray   Gray+ too far to note 30' Ground Plane FALSE   0 0 0 0 1 quieter 0 0 0 0 1 0 0 0   POINT (-73.9671534029191 40.7810849804467)
2356 2356 -73.9611355303487 40.793069353224 34C-AM-1007-02 34C AM 10072018 2 Adult Gray   Gray+   Above Ground 40   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9611355303487 40.793069353224)
2370 2370 -73.9573119777312 40.7875347862766 30H-AM-1007-02 30H AM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0 following #1 0 0 0 0 1 0 0 0   POINT (-73.9573119777312 40.7875347862766)
2512 2512 -73.974275954985 40.775472387930705 11B-AM-1007-02 11B AM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.974275954985 40.7754723879307)
2699 2699 -73.9743509423821 40.7690043677328 5F-AM-1007-02 05F AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   tree 1 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.97435094238212 40.7690043677328)
2791 2791 -73.9593624259363 40.7905522356793 32E-AM-1007-02 32E AM 10072018 2 Adult Gray   Gray+   Above Ground 40   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9593624259363 40.7905522356793)
1112 1112 -73.9583934264026 40.7854742185504 27I-AM-1007-02 27I AM 10072018 2       +         0 0 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9583934264026 40.785474218550405)

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