2018_Central_Park_Squirrel_Census_-_Squirrel_Data

45 rows where Date = 10142018 and Hectare Squirrel Number = 4 sorted by Tail flags

✎ View and edit SQL

This data as json, CSV (advanced)

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

Hectare Squirrel Number ✖

Date ✖

  • 10142018 · 45 ✖
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
108 108 -73.9574809028248 40.7950013620207 37D-PM-1014-04 37D PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 1 chasing (a chipmunk) 0 0 0 0 0 0 0 1   POINT (-73.9574809028248 40.7950013620207)
338 338 -73.9765595553183 40.7748455340432 10A-PM-1014-04 10A PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9765595553183 40.7748455340432)
445 445 -73.97140573271591 40.7720375135272 9F-PM-1014-04 09F PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9714057327159 40.7720375135272)
459 459 -73.9624546917649 40.7888234959792 29D-AM-1014-04 29D AM 10142018 4 Juvenile Gray   Gray+   Ground Plane FALSE Rock a 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9624546917649 40.78882349597921)
499 499 -73.96572880550109 40.776458003628704 16H-PM-1014-04 16H PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9657288055011 40.7764580036287)
541 541 -73.9617612388703 40.7952875954297 35A-AM-1014-04 35A AM 10142018 4 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.9617612388703 40.7952875954297)
626 626 -73.97050538215771 40.7787503220242 16C-AM-1014-04 16C AM 10142018 4 Adult Gray Black Gray+Black   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9705053821577 40.7787503220242)
709 709 -73.9519387881692 40.7936273636929 38I-PM-1014-04 38I PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9519387881692 40.7936273636929)
823 823 -73.954595058342 40.7956567934304 39F-AM-1014-04 39F AM 10142018 4 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.954595058342 40.7956567934304)
842 842 -73.9645147011741 40.777256683379896 17I-AM-1014-04 17I AM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 1 0   POINT (-73.9645147011741 40.7772566833799)
920 920 -73.9571233640232 40.7992458980266 41B-PM-1014-04 41B PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40   0 0 1 0 0   0 0 0 0 0 0 0 0 climbing POINT (-73.9571233640232 40.7992458980266)
959 959 -73.97461330580771 40.7760646554109 11B-PM-1014-04 11B PM 10142018 4   Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 jumping 0 0 0 0 0 0 0 0   POINT (-73.9746133058077 40.776064655410906)
1005 1005 -73.95582687317709 40.7952074193788 38E-PM-1014-04 38E PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE THICK UNDERGROWTH 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9558268731771 40.7952074193788)
1022 1022 -73.95488534927121 40.7984783584388 41D-PM-1014-04 41D PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   0 0 1 0 0 jumping tree to tree 0 0 0 0 0 0 0 0   POINT (-73.9548853492712 40.7984783584388)
1036 1036 -73.9709207551033 40.7767932008037 14D-AM-1014-04 14D AM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9709207551033 40.7767932008037)
1177 1177 -73.98078982247259 40.768215817511 1A-PM-1014-04 01A PM 10142018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9807898224726 40.768215817511)
1223 1223 -73.95912985511109 40.7919612446005 33E-AM-1014-04 33E AM 10142018 4 Adult Black Cinnamon, White Black+Cinnamon, White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9591298551111 40.7919612446005)
1453 1453 -73.9555856074105 40.7969457685677 40E-AM-1014-04 40E AM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE on rocks/bushy rocks 1 0 0 0 0 hiding from bird 0 1 0 0 1 0 1 0   POINT (-73.9555856074105 40.79694576856771)
1506 1506 -73.9728339757306 40.7782891207966 14B-PM-1014-04 14B PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20 running up and down 0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9728339757306 40.7782891207966)
1639 1639 -73.9736800575584 40.778306973575795 14A-PM-1014-04 14A PM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0 chasing (#3) 0 0 0 0 1 0 1 0   POINT (-73.9736800575584 40.7783069735758)
1665 1665 -73.95839443533521 40.7979689846815 39B-PM-1014-04 39B PM 10142018 4 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 1 runs from (me—when i approached) POINT (-73.9583944353352 40.7979689846815)
1752 1752 -73.9561091686663 40.798146304742495 41D-AM-1014-04 41D AM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9561091686663 40.7981463047425)
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)
2027 2027 -73.964449990389 40.7830023160643 22F-PM-1014-04 22F PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.964449990389 40.7830023160643)
2059 2059 -73.9710026704697 40.776105276462104 13D-AM-1014-04 13D AM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9710026704697 40.7761052764621)
2128 2128 -73.9757673193743 40.7669614322613 2F-PM-1014-04 02F PM 10142018 4 Adult Gray   Gray+   Above Ground 20   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9757673193743 40.766961432261304)
2270 2270 -73.9703732649257 40.77019793771029 8H-PM-1014-04 08H PM 10142018 4 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.97037326492571 40.7701979377103)
2279 2279 -73.9586085858962 40.7990326758282 40A-PM-1014-04 40A PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (ran from path to bushes) POINT (-73.9586085858962 40.7990326758282)
2325 2325 -73.9728360875598 40.7660637295671 3H-PM-1014-04 03H PM 10142018 4 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9728360875598 40.7660637295671)
2341 2341 -73.9665363265054 40.7844967881001 23C-PM-1014-04 23C PM 10142018 4 Adult Gray   Gray+   Above Ground 8   0 0 0 0 0 being chased by #3 across trees 0 0 0 0 0 0 0 0   POINT (-73.9665363265054 40.7844967881001)
2613 2613 -73.96393252683 40.7808289765857 21G-AM-1014-04 21G AM 10142018 4 Adult Gray White Gray+White   Above Ground 6   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.96393252683 40.7808289765857)
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)
2654 2654 -73.9549261242548 40.7944701994615 37G-AM-1014-04 37G AM 10142018 4 Adult Gray   Gray+   Above Ground 5   0 1 0 0 0 playing 0 0 0 0 0 0 1 0   POINT (-73.9549261242548 40.7944701994615)
2738 2738 -73.9691801791373 40.770927235357206 9I-AM-1014-04 09I AM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9691801791373 40.7709272353572)
2740 2740 -73.96126586889142 40.7912119940469 32C-AM-1014-04 32C AM 10142018 4 Adult Gray   Gray+   Above Ground 8   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9612658688914 40.7912119940469)
2753 2753 -73.96810908249779 40.783827583032796 22B-PM-1014-04 22B PM 10142018 4 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9681090824978 40.7838275830328)
2754 2754 -73.9687025912431 40.7719319822619 10H-AM-1014-04 10H AM 10142018 4 Juvenile     +   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9687025912431 40.7719319822619)
2779 2779 -73.9767835160078 40.767403033048204 2E-PM-1014-04 02E PM 10142018 4 Adult Cinnamon White Cinnamon+White   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9767835160078 40.7674030330482)
2809 2809 -73.9686756254868 40.777745910265104 16E-AM-1014-04 16E AM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9686756254868 40.7777459102651)
2832 2832 -73.958607566971 40.7983695505584 40B-PM-1014-04 40B PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.958607566971 40.7983695505584)
2951 2951 -73.9742986032935 40.7770454318226 13A-PM-1014-04 13A PM 10142018 4   Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9742986032935 40.7770454318226)
2959 2959 -73.9747963162162 40.7745023355775 10B-PM-1014-04 10B PM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0 avoided people POINT (-73.9747963162162 40.7745023355775)
3008 3008 -73.9503533343658 40.7976543603953 42H-PM-1014-04 42H PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   1 1 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9503533343658 40.7976543603953)
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)
2790 2790 -73.9673554935258 40.782752724959394 21C-AM-1014-04 21C AM 10142018 4 Adult     + High in tree, unable to tell Above Ground 60   0 0 1 0 0   0 0 0 1 0 0 1 0   POINT (-73.96735549352582 40.7827527249594)

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