2018_Central_Park_Squirrel_Census_-_Squirrel_Data

163 rows where Hectare Squirrel Number = 6 and Running = 0 sorted by Unique Squirrel ID

✎ View and edit SQL

This data as json, CSV (advanced)

Running ✖

Hectare Squirrel Number ✖

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
1077 1077 -73.9541837143178 40.7944340477396 38G-PM-1020-06 38G PM 10202018 6 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 1 0 0 0 0 0 1   POINT (-73.9541837143178 40.7944340477396)
378 378 -73.95848354168459 40.7978213396921 39B-PM-1014-06 39B PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9584835416846 40.7978213396921)
1162 1162 -73.95685442708809 40.7972517274475 39D-AM-1008-06 39D AM 10082018 6 Adult Gray   Gray+   Above Ground 3 on rock 0 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9568544270881 40.7972517274475)
61 61 -73.9797084866613 40.7698885241349 3A-PM-1017-06 03A PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9797084866613 40.7698885241349)
2141 2141 -73.97870151846621 40.7690114585688 3B-PM-1007-06 03B PM 10072018 6 Juvenile     +         0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9787015184662 40.7690114585688)
2674 2674 -73.97710090245809 40.7688793288864 3D-PM-1010-06 03D PM 10102018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9771009024581 40.7688793288864)
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)
1419 1419 -73.9756017589251 40.7680335996527 3E-PM-1008-06 03E PM 10082018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9756017589251 40.7680335996527)
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)
2815 2815 -73.97473113123941 40.76773197250439 3F-PM-1013-06 03F PM 10132018 6 Adult Gray White Gray+White   Above Ground 19   0 0 1 0 0   0 1 0 0 0 0 0 1   POINT (-73.97473113123941 40.7677319725044)
2395 2395 -73.9729603550254 40.7660215710657 3H-AM-1008-06 03H AM 10082018 6 Adult Black   Black+ beauty! Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 1   POINT (-73.9729603550254 40.7660215710657)
1694 1694 -73.97301963428741 40.766022437401 3H-PM-1014-06 03H PM 10142018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9730196342874 40.766022437401)
1540 1540 -73.957710975899 40.79840556140471 40B-AM-1019-06 40B AM 10192018 6 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.957710975899 40.7984055614047)
2168 2168 -73.95823634371351 40.7987752300505 40B-AM-1019-06 40B AM 10192018 6 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9582363437135 40.7987752300505)
2590 2590 -73.9568524771058 40.7974664985551 40C-PM-1006-06 40C PM 10062018 6 Juvenile Gray   Gray+   Ground Plane FALSE By The Road 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9568524771058 40.7974664985551)
1273 1273 -73.95589438800509 40.7971535141896 40D-PM-1013-06 40D PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9558943880051 40.7971535141896)
701 701 -73.95292302079079 40.7960663442573 40G-PM-1013-06 40G PM 10132018 6 Juvenile Gray   Gray+   Ground Plane FALSE along the road 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9529230207908 40.7960663442573)
116 116 -73.9572093760529 40.798848730021604 41B-AM-1010-06 41B AM 10102018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9572093760529 40.7988487300216)
1886 1886 -73.956806913988 40.7987736900857 41C-AM-1017-06 41C AM 10172018 6 Adult Gray   Gray+   Above Ground 4   0 0 1 0 0   1 0 0 0 0 0 1 0   POINT (-73.956806913988 40.7987736900857)
496 496 -73.9548430741605 40.798207350942 41E-AM-1007-06 41E AM 10072018 6 Adult Gray   Gray+   Above Ground 30 tree 0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9548430741605 40.798207350942)
2720 2720 -73.9566300789162 40.7993692120774 42C-PM-1013-06 42C PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Between park and main drag 0 0 1 1 0   0 0 0 0 0 0 1 1   POINT (-73.9566300789162 40.7993692120774)
2529 2529 -73.98002714878629 40.7702554167042 4A-PM-1007-06 04A PM 10072018 6 Adult Gray White Gray+White   Ground Plane FALSE A rock 0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9800271487863 40.7702554167042)
522 522 -73.97738211356109 40.769045349438294 4C-PM-1010-06 04C PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE behind playground benches 0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9773821135611 40.7690453494383)
194 194 -73.9764839973068 40.7691725326976 4D-PM-1008-06 04D PM 10082018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9764839973068 40.7691725326976)
1878 1878 -73.9761223919286 40.7685998275864 4E-PM-1008-06 04E PM 10082018 6 Adult Gray Cinnamon Gray+Cinnamon         0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9761223919286 40.7685998275864)
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)
2769 2769 -73.9769885189342 40.7708936173356 5C-PM-1010-06 05C PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9769885189342 40.7708936173356)
1454 1454 -73.9753818829907 40.76978409861629 5D-PM-1018-06 05D PM 10182018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9753818829907 40.7697840986163)
1495 1495 -73.97351371783691 40.769109895294 5F-AM-1007-06 05F AM 10072018 6 Adult Gray   Gray+   Above Ground 2 branch 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9735137178369 40.769109895294)
1948 1948 -73.9738410069766 40.7691686156505 5F-PM-1007-06 05F PM 10072018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 jumping on fence 0 0 0 0 1 0 1 0   POINT (-73.9738410069766 40.7691686156505)
2548 2548 -73.9703571491616 40.7678515625131 5I-AM-1010-06 05I AM 10102018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9703571491616 40.7678515625131)
260 260 -73.97843611793199 40.7724769242403 6A-AM-1006-06 06A AM 10062018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15 tree 0 0 1 0 0   1 0 0 0 0 0 0 0   POINT (-73.978436117932 40.7724769242403)
2591 2591 -73.9786351029146 40.771611416400205 6A-PM-1012-06 06A PM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE elevated ground 0 1 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9786351029146 40.771611416400205)
1099 1099 -73.9761527947483 40.770960700253895 6C-AM-1007-06 06C AM 10072018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7   0 0 1 0 0   0 0 0 0 0 0 0 0 disappeared when jogger ran by POINT (-73.9761527947483 40.7709607002539)
2642 2642 -73.97514547259979 40.770291361572 6D-PM-1020-06 06D PM 10202018 6 Adult Gray White Gray+White   Ground Plane FALSE by carousel 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9751454725998 40.770291361572006)
458 458 -73.97357503529591 40.7694500333777 6F-PM-1008-06 06F PM 10082018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White White patches. Almost looks like fox squirrel       0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9735750352959 40.7694500333777)
1769 1769 -73.9721086069437 40.7698172190404 6G-AM-1008-06 06G AM 10082018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White white at end of tail Ground Plane FALSE grass 0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9721086069437 40.7698172190404)
58 58 -73.9704082821356 40.7690280985956 6I-PM-1013-06 06I PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 playing with #5 0 0 0 0 1 0 0 0   POINT (-73.9704082821356 40.7690280985956)
1638 1638 -73.9770628333002 40.7728567364852 7B-AM-1008-06 07B AM 10082018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9770628333002 40.7728567364852)
1629 1629 -73.9759428006237 40.7715081817329 7C-PM-1020-06 07C PM 10202018 6 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 1 0 0 0 0 0 0   POINT (-73.9759428006237 40.7715081817329)
1770 1770 -73.97281709807791 40.770355783043705 7F-AM-1008-06 07F AM 10082018 6 Adult Gray   Gray+   Above Ground 28 in hole in tree 0 0 0 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9728170980779 40.770355783043705)
1233 1233 -73.9722281263634 40.770408328801295 7G-AM-1010-06 07G AM 10102018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9722281263634 40.7704083288013)
2765 2765 -73.971525123573 40.770368535984204 7G-PM-1018-06 07G PM 10182018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 grooming 0 0 0 0 0 0 0 0   POINT (-73.971525123573 40.7703685359842)
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)
1535 1535 -73.9703921271418 40.770027611531404 7H-PM-1006-06 07H PM 10062018 6 Adult Gray   Gray+   Above Ground 15   0 1 1 0 0 playing w/ #7 0 0 0 0 0 0 1 0   POINT (-73.9703921271418 40.770027611531404)
2274 2274 -73.96980442184758 40.7697007833531 7I-PM-1013-06 07I PM 10132018 6 Adult Cinnamon   Cinnamon+ "Brown" written in as Primary Ground Plane FALSE Under the tree 0 0 0 1 0 playing,interacting with #7 0 0 0 0 1 0 0 1   POINT (-73.9698044218476 40.7697007833531)
1498 1498 -73.9765064169087 40.7737211426714 8B-AM-1007-06 08B AM 10072018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9765064169087 40.7737211426714)
344 344 -73.9759432151552 40.7733240612552 8B-PM-1012-06 08B PM 10122018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 2 on a bench 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9759432151552 40.7733240612552)
1966 1966 -73.97509119964991 40.772244521017896 8C-PM-1013-06 08C PM 10132018 6   Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9750911996499 40.7722445210179)
1644 1644 -73.9734654671008 40.7715988711659 8E-PM-1008-06 08E PM 10082018 6 Adult Gray White Gray+White   Ground Plane FALSE 5, 6, 7 all at same tree trunk base 0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9734654671008 40.7715988711659)
1350 1350 -73.9727698663722 40.7714335285174 8F-PM-1012-06 08F PM 10122018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9727698663722 40.7714335285174)
44 44 -73.970252675331 40.7705999588222 8H-AM-1017-06 08H AM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   0 1 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.970252675331 40.77059995882221)
492 492 -73.97030108562241 40.7701983575511 8H-PM-1014-06 08H PM 10142018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9703010856224 40.7701983575511)
2331 2331 -73.9694681803635 40.770585795359004 8I-AM-1006-06 08I AM 10062018 6 Adult Gray White Gray+White   Above Ground     0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9694681803635 40.770585795359)
2661 2661 -73.9693841004072 40.770414865829395 8I-PM-1013-06 08I PM 10132018 6 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.9693841004072 40.7704148658294)
2845 2845 -73.9765016413674 40.77406728629529 9A-AM-1013-06 09A AM 10132018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9765016413674 40.7740672862953)
2144 2144 -73.975198284551 40.7740343763399 9B-AM-1010-06 09B AM 10102018 6 Juvenile Gray White Gray+White   Above Ground 16 tree 0 0 1 0 0 cleaning 0 0 0 0 0 0 1 0   POINT (-73.975198284551 40.7740343763399)
2505 2505 -73.9762974698771 40.7740076116964 9B-PM-1013-06 09B PM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9762974698771 40.7740076116964)
790 790 -73.9745040517502 40.77333038538 9C-PM-1006-06 09C PM 10062018 6 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.97450405175022 40.77333038538)
171 171 -73.971086588091 40.77197032351779 9G-PM-1007-06 09G PM 10072018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.971086588091 40.7719703235178)
2363 2363 -73.9690638424196 40.7713869295685 9H-AM-1006-06 09H AM 10062018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 1 0 1 0   POINT (-73.9690638424196 40.7713869295685)
967 967 -73.9683994064731 40.7710765500799 9I-AM-1014-06 09I AM 10142018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.96839940647311 40.7710765500799)
1670 1670 -73.9682688752331 40.7711934835539 9I-PM-1010-06 09I PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9682688752331 40.7711934835539)

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