This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Location, Above Ground Sighter Measurement, Chasing, Climbing, Foraging, Tail flags, Tail twitches, Indifferent, Runs from
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
674 | 674 | -73.9779811967788 | 40.7675178797546 | 2D-AM-1007-01 | 02D | AM | 10072018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9779811967788 40.7675178797546) | ||||
1118 | 1118 | -73.9719460335398 | 40.7810508156287 | 18A-AM-1012-01 | 18A | AM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | White tail | Above Ground | 3 | tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9719460335398 40.7810508156287) | ||
1180 | 1180 | -73.9639726817977 | 40.7829083461049 | 23F-PM-1013-01 | 23F | PM | 10132018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (dove into some bushes/undergrowth,only saw briefly! → not because of humans tho.) | POINT (-73.9639726817977 40.7829083461049) | |||
1299 | 1299 | -73.9766653663947 | 40.7688767713012 | 4D-AM-1012-01 | 04D | AM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9766653663947 40.7688767713012) | ||||
1952 | 1952 | -73.96818104666929 | 40.7720638449419 | 10I-PM-1013-01 | 10I | PM | 10132018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9681810466693 40.7720638449419) | ||||
2460 | 2460 | -73.9526681107152 | 40.7977012009146 | 42F-PM-1017-01 | 42F | PM | 10172018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9526681107152 40.7977012009146) | |||
2673 | 2673 | -73.9768867959365 | 40.7734803954589 | 8B-PM-1012-01 | 08B | PM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9768867959365 40.7734803954589) | ||||
2849 | 2849 | -73.9709912560997 | 40.77589655951979 | 13D-AM-1014-01 | 13D | AM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9709912560997 40.7758965595198) | ||||
2905 | 2905 | -73.9784872728213 | 40.768812260393204 | 3C-AM-1007-01 | 03C | AM | 10072018 | 1 | 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.9784872728213 40.7688122603932) | ||||
947 | 947 | -73.9736543790582 | 40.7651444188432 | 1H-AM-1012-02 | 01H | AM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9736543790582 40.7651444188432) | ||||
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) | ||||
1576 | 1576 | -73.96199851876159 | 40.79432777435321 | 34A-AM-1012-02 | 34A | AM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | chasing from tree to ground | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9619985187616 40.7943277743532) | |||
1895 | 1895 | -73.954699659637 | 40.7951308856929 | 38F-AM-1018-02 | 38F | AM | 10182018 | 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.954699659637 40.7951308856929) | ||||
1954 | 1954 | -73.9794840520702 | 40.7709595369804 | 4A-PM-1007-02 | 04A | PM | 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.9794840520702 40.770959536980406) | ||||
2307 | 2307 | -73.9736997033862 | 40.778497952406 | 14A-PM-1014-02 | 14A | PM | 10142018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9736997033862 40.778497952406) | ||||
2829 | 2829 | -73.95652309635541 | 40.798556387711 | 41C-PM-1007-02 | 41C | PM | 10072018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9565230963554 40.798556387711) | ||||
961 | 961 | -73.9731457102903 | 40.7660255393205 | 2H-AM-1006-03 | 02H | AM | 10062018 | 3 | 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.9731457102903 40.7660255393205) | ||||
2091 | 2091 | -73.96761128642859 | 40.7772792086081 | 16F-AM-1008-03 | 16F | AM | 10082018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | road | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9676112864286 40.7772792086081) | |||
2687 | 2687 | -73.9550235589287 | 40.7951312356844 | 38F-AM-1018-03 | 38F | AM | 10182018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9550235589287 40.7951312356844) | ||||
1600 | 1600 | -73.9753093777 | 40.7666673897583 | 2F-AM-1006-04 | 02F | AM | 10062018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Beautiful white puff at the end of its tail | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.97530937770001 40.7666673897583) | |||
2821 | 2821 | -73.97545365660129 | 40.769860491877104 | 5E-PM-1012-04 | 05E | PM | 10122018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9754536566013 40.7698604918771) | ||||
795 | 795 | -73.9582523503306 | 40.7996897499473 | 41A-PM-1007-05 | 41A | PM | 10072018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9582523503306 40.7996897499473) | ||||
2873 | 2873 | -73.955068474109 | 40.79117881528779 | 34H-PM-1006-05 | 34H | PM | 10062018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | white tail tip | Ground Plane | FALSE | in grass | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.955068474109 40.7911788152878) | ||
494 | 494 | -73.958837574505 | 40.7985003987784 | 40A-PM-1014-06 | 40A | PM | 10142018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.958837574505 40.7985003987784) | ||||
1247 | 1247 | -73.96709048698709 | 40.7832091658006 | 21D-PM-1008-06 | 21D | PM | 10082018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9670904869871 40.7832091658006) | ||||
1555 | 1555 | -73.9784942525972 | 40.767260000368296 | 1D-AM-1006-06 | 01D | AM | 10062018 | 6 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | tumbling | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9784942525972 40.7672600003683) | ||
1910 | 1910 | -73.9699876501742 | 40.774248267675794 | 12F-PM-1007-06 | 12F | PM | 10072018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9699876501742 40.77424826767581) | ||||
1236 | 1236 | -73.97920390711141 | 40.76787494712671 | 2C-AM-1010-07 | 02C | AM | 10102018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | #7 & #8 chased each other up diff tree | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9792039071114 40.76787494712671) | |||
2210 | 2210 | -73.9699124811406 | 40.7743016981538 | 12F-PM-1007-07 | 12F | PM | 10072018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9699124811406 40.7743016981538) | ||||
2301 | 2301 | -73.968906907671 | 40.781627826784295 | 19C-PM-1018-07 | 19C | PM | 10182018 | 7 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.968906907671 40.7816278267843) | |||
1125 | 1125 | -73.9775735077285 | 40.7692872082165 | 4C-PM-1010-08 | 04C | PM | 10102018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | on stone arch | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9775735077285 40.7692872082165) | |||
2289 | 2289 | -73.97458005923929 | 40.767356541975005 | 3F-AM-1006-08 | 03F | AM | 10062018 | 8 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | close to tall tree & light post | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9745800592393 40.767356541975) | |||
316 | 316 | -73.9540616660191 | 40.795155660324504 | 38G-PM-1020-10 | 38G | PM | 10202018 | 10 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9540616660191 40.7951556603245) | ||||
2177 | 2177 | -73.9758211560957 | 40.7693422860766 | 5E-AM-1008-10 | 05E | AM | 10082018 | 10 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6 | up a tree | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9758211560957 40.7693422860766) | |||
2644 | 2644 | -73.97754454411941 | 40.7697096533728 | 4C-PM-1010-13 | 04C | PM | 10102018 | 13 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9775445441194 40.7697096533728) |
JSON shape: default, array, newline-delimited
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 );