2018_Central_Park_Squirrel_Census_-_Squirrel_Data

76 rows where Climbing = 1, Hectare Squirrel Number = 3 and Runs from = 0 sorted by Highlight Fur Color

✎ View and edit SQL

This data as json, CSV (advanced)

Hectare Squirrel Number ✖

Climbing ✖

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
1610 1610 -73.9607056611532 40.788978610387105 30E-AM-1008-03 30E AM 10082018 3 Adult Gray   Gray+   Above Ground 6   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9607056611532 40.7889786103871)
1701 1701 -73.9701634768603 40.777869143321794 15D-AM-1007-03 15D AM 10072018 3 Adult Gray   Gray+   Above Ground 10   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9701634768603 40.7778691433218)
1715 1715 -73.97457091090558 40.7672225695415 3G-AM-1008-03 03G AM 10082018 3 Adult Gray   Gray+   Above Ground 40   1 0 1 0 0 in tree 0 0 0 0 0 0 1 0   POINT (-73.9745709109056 40.7672225695415)
1796 1796 -73.9765355395622 40.7735653237366 8B-AM-1007-03 08B AM 10072018 3 Adult Gray   Gray+   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.97653553956222 40.7735653237366)
1890 1890 -73.97877230828071 40.7713655754004 5A-PM-1010-03 05A PM 10102018 3 Adult Gray   Gray+   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9787723082807 40.7713655754004)
1931 1931 -73.9533085932603 40.793487786107505 37H-PM-1006-03 37H PM 10062018 3       +   Above Ground 43 tree 0 0 1 0 0   1 0 0 0 0 0 0 0   POINT (-73.9533085932603 40.7934877861075)
2015 2015 -73.9574365550758 40.7886924675052 31H-PM-1008-03 31H PM 10082018 3 Adult Gray   Gray+   Above Ground   no clue, way up a tree! 0 0 1 0 1 throwing down acorns 0 0 0 0 0 0 0 0   POINT (-73.9574365550758 40.7886924675052)
2028 2028 -73.96873477318609 40.7718955594385 10H-AM-1014-03 10H AM 10142018 3 Juvenile     +   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9687347731861 40.7718955594385)
2076 2076 -73.9712636931964 40.77998098773 17B-AM-1010-03 17B AM 10102018 3 Adult Gray   Gray+   Above Ground 25   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9712636931964 40.77998098773)
2154 2154 -73.976716425804 40.7736889979965 8A-PM-1014-03 08A PM 10142018 3 Juvenile Gray   Gray+   Above Ground 23   0 0 1 1 0   0 0 0 0 0 0 0 0   POINT (-73.976716425804 40.7736889979965)
2377 2377 -73.9704328573603 40.7739347247552 11F-AM-1013-03 11F AM 10132018 3 Adult Gray   Gray+   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9704328573603 40.7739347247552)
2396 2396 -73.9704339422613 40.77401495296439 11F-PM-1006-03 11F PM 10062018 3 Adult Gray   Gray+   Above Ground 4   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9704339422613 40.7740149529644)
2441 2441 -73.9579865329778 40.794906535675004 37D-PM-1014-03 37D PM 10142018 3 Adult Gray   Gray+   Above Ground 40   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9579865329778 40.794906535675)
2452 2452 -73.9727323797981 40.766903546395504 3H-AM-1008-03 03H AM 10082018 3 Adult Gray   Gray+   Above Ground 40 building nest 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9727323797981 40.7669035463955)
2598 2598 -73.976658503418 40.768686845691704 4D-AM-1012-03 04D AM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   0 1 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.976658503418 40.7686868456917)
2603 2603 -73.97087815045279 40.7724138070355 10F-AM-1007-03 10F AM 10072018 3 Adult Gray   Gray+   Above Ground 50   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9708781504528 40.7724138070355)
2660 2660 -73.97260564119709 40.77934679047429 16A-PM-1019-03 16A PM 10192018 3   Gray   Gray+   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9726056411971 40.7793467904743)
2933 2933 -73.9677903197449 40.7826561917755 21C-AM-1014-03 21C AM 10142018 3 Adult Gray   Gray+   Above Ground 30   0 1 1 0 0   0 1 0 0 0 0 0 0 looked at us from tree POINT (-73.9677903197449 40.7826561917755)
2960 2960 -73.96252481451499 40.7810022923615 21H-PM-1018-03 21H PM 10182018 3 Adult Gray   Gray+   Above Ground 25   0 0 1 0 0   1 0 0 0 0 0 1 0   POINT (-73.962524814515 40.7810022923615)
991 991 -73.96356890598409 40.790163434915 30B-PM-1019-03 30B PM 10192018 3 Adult Gray Black Gray+Black   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9635689059841 40.790163434915)
1874 1874 -73.96573273328491 40.7747554568985 14I-PM-1018-03 14I PM 10182018 3 Juvenile Gray Black Gray+Black   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9657327332849 40.7747554568985)
2228 2228 -73.9714045891597 40.771541833397606 9G-AM-1007-03 09G AM 10072018 3 Adult Gray Black Gray+Black   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.97140458915972 40.7715418333976)
1627 1627 -73.9594391759139 40.784115697669 26I-PM-1010-03 26I PM 10102018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White black in tail Above Ground 15 tree 0 0 1 1 1   0 0 0 0 1 0 1 0   POINT (-73.9594391759139 40.784115697669)
16 16 -73.97225001968441 40.7742879599026 11D-AM-1010-03 11D AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   0 0 1 0 0 grooming 0 0 0 0 0 0 1 0   POINT (-73.9722500196844 40.7742879599026)
201 201 -73.9598015842806 40.7973522744237 38A-PM-1013-03 38A PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9598015842806 40.7973522744237)
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)
220 220 -73.96718161220299 40.7787752287055 17F-PM-1020-03 17F PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 35   0 0 1 1 0   0 0 0 0 0 0 0 0   POINT (-73.967181612203 40.7787752287055)
698 698 -73.95855376683821 40.7903905787005 32F-AM-1012-03 32F AM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0 bringing green leaves to nest 0 0 0 0 0 0 0 0   POINT (-73.9585537668382 40.7903905787005)
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)
1425 1425 -73.95862528758559 40.7852027586217 27I-AM-1007-03 27I AM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon had .5 of a tail Above Ground 20   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9586252875856 40.7852027586217)
1522 1522 -73.95389705545321 40.7955196793479 39G-PM-1013-03 39G PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9538970554532 40.7955196793479)
2259 2259 -73.975565603566 40.7738462518304 9B-AM-1010-03 09B AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   1 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.975565603566 40.7738462518304)
2262 2262 -73.9556177490335 40.788856916153705 32I-AM-1013-03 32I AM 10132018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0 watching me from tree - curious POINT (-73.9556177490335 40.7888569161537)
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)
2592 2592 -73.9758128509653 40.7715946097064 7C-PM-1020-03 07C PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9758128509653 40.7715946097064)
2599 2599 -73.96898934126929 40.785308737683 23A-AM-1018-03 23A AM 10182018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8 Tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9689893412693 40.785308737683)
2747 2747 -73.971314838366 40.774951285041 12E-AM-1017-03 12E AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.971314838366 40.774951285041)
2471 2471 -73.964274290774 40.779531955602295 19H-AM-1010-03 19H AM 10102018 3 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0 ran from human w/ dog POINT (-73.964274290774 40.7795319556023)
2485 2485 -73.9584950620879 40.790277071064295 32F-PM-1008-03 32F PM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 1 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9584950620879 40.7902770710643)
3013 3013 -73.964661337306 40.7769785494935 17I-AM-1014-03 17I AM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon face Above Ground 10   0 0 1 0 0 climbing (dog barked & it ran up tree) 0 0 0 0 0 0 1 0   POINT (-73.964661337306 40.7769785494935)
257 257 -73.9773317054464 40.7684035996758 3D-AM-1006-03 03D AM 10062018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE on top [of] a big rock/boulder in the area 1 0 1 0 0 climbing (rock) 0 0 0 0 0 1 0 0 approaches (slightly),wary of humans POINT (-73.9773317054464 40.76840359967581)
391 391 -73.97908754803579 40.767610478065706 2C-AM-1010-03 02C AM 10102018 3 Adult Black Gray Black+Gray   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9790875480358 40.7676104780657)
695 695 -73.96850806398729 40.774530979415495 13G-PM-1008-03 13G PM 10082018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 20 maple tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9685080639873 40.77453097941551)
937 937 -73.97063234587691 40.7713196034265 9G-PM-1007-03 09G PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9706323458769 40.771319603426505)
1145 1145 -73.9611446263364 40.7911003407299 32D-AM-1013-03 32D AM 10132018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9611446263364 40.7911003407299)
1253 1253 -73.9527227282134 40.7935061484064 37I-AM-1010-03 37I AM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 in tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9527227282134 40.7935061484064)
1680 1680 -73.9638167248251 40.7776485679354 18I-PM-1007-03 18I PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 25   0 0 1 0 0   0 0 0 0 0 0 0 0 stared at me POINT (-73.9638167248251 40.77764856793541)
483 483 -73.9789952029637 40.7697758333099 4B-AM-1010-03 04B AM 10102018 3 Juvenile Gray White Gray+White   Above Ground 25   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9789952029637 40.7697758333099)
561 561 -73.95819824864691 40.7992194575293 41A-PM-1007-03 41A PM 10072018 3 Adult Gray White Gray+White   Above Ground 55   1 0 1 0 0   0 0 0 0 1 0 0 0   POINT (-73.95819824864691 40.7992194575293)
649 649 -73.9554891003543 40.7968774599654 40E-AM-1014-03 40E AM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9554891003543 40.79687745996541)
1116 1116 -73.9729847109778 40.774070904960205 10D-AM-1008-03 10D AM 10082018 3 Adult Gray White Gray+White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9729847109778 40.7740709049602)
1551 1551 -73.9785114291288 40.771977958944895 6A-PM-1012-03 06A PM 10122018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9785114291288 40.7719779589449)
1747 1747 -73.96657637976071 40.7761316400012 15H-AM-1013-03 15H AM 10132018 3 Adult Gray White Gray+White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9665763797607 40.7761316400012)
1851 1851 -73.9623621412501 40.7814673556041 22H-PM-1007-03 22H PM 10072018 3 Adult Gray White Gray+White   Above Ground 4 chased squirrel #2 away 0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9623621412501 40.7814673556041)
1987 1987 -73.9573692542155 40.7989252908321 41B-PM-1014-03 41B PM 10142018 3 Adult Gray White Gray+White   Above Ground 28   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9573692542155 40.7989252908321)
1988 1988 -73.957138794884 40.7985389822719 40C-AM-1017-03 40C AM 10172018 3 Adult Gray White Gray+White         1 1 1 0 0 chasing (#4),digging 0 0 0 0 1 0 1 0   POINT (-73.957138794884 40.7985389822719)
2069 2069 -73.9538377039825 40.798060533496106 42E-PM-1012-03 42E PM 10122018 3 Adult Gray White Gray+White   Above Ground 20 in tree 0 0 1 0 1   1 0 0 0 0 0 1 0   POINT (-73.9538377039825 40.7980605334961)
2071 2071 -73.96676944398949 40.7779501809095 17G-PM-1017-03 17G PM 10172018 3 Adult Gray White Gray+White   Above Ground 10 tree & ground 1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9667694439895 40.7779501809095)
2528 2528 -73.96765297807241 40.7823206990549 21D-PM-1008-03 21D PM 10082018 3 Adult Gray White Gray+White   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9676529780724 40.7823206990549)

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.264ms