This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2454 | 2454 | -73.9565151662506 | 40.794664798744705 | 37E-PM-1006-07 | 37E | PM | 10062018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | me | POINT (-73.9565151662506 40.7946647987447) | |||
2461 | 2461 | -73.9605347462123 | 40.794207544838706 | 35B-AM-1010-04 | 35B | AM | 10102018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | lawn | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9605347462123 40.7942075448387) | |||
2462 | 2462 | -73.9768544488742 | 40.76800695009771 | 3D-AM-1006-07 | 03D | AM | 10062018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | running (with food in mouth) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9768544488742 40.7680069500977) | |||
2467 | 2467 | -73.9755923256429 | 40.7672967972471 | 3F-PM-1013-02 | 03F | PM | 10132018 | 2 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.97559232564292 40.7672967972471) | ||||
2487 | 2487 | -73.9595222999173 | 40.7833202577782 | 25I-AM-1012-02 | 25I | AM | 10122018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 31 | on tree | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9595222999173 40.7833202577782) | |||
2488 | 2488 | -73.97269208477921 | 40.779411746388895 | 16A-PM-1019-02 | 16A | PM | 10192018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | scared by dog | POINT (-73.9726920847792 40.7794117463889) | |||
2493 | 2493 | -73.954767265558 | 40.7973243644491 | 40E-PM-1017-03 | 40E | PM | 10172018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.954767265558 40.7973243644491) | ||||
2496 | 2496 | -73.96962742914171 | 40.7691980808067 | 7I-PM-1013-03 | 07I | PM | 10132018 | 3 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | Trash bins | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9696274291417 40.7691980808067) | |||
2514 | 2514 | -73.95744422055 | 40.7961046528557 | 38D-AM-1017-04 | 38D | AM | 10172018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.95744422055 40.7961046528557) | ||||
2521 | 2521 | -73.976869549792 | 40.770698245472296 | 5C-AM-1006-04 | 05C | AM | 10062018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 12 | thin branch of tree | 0 | 0 | 0 | 0 | 0 | relaxing | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.976869549792 40.7706982454723) | ||
2523 | 2523 | -73.9619016393127 | 40.792516012692104 | 33B-PM-1010-06 | 33B | PM | 10102018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9619016393127 40.7925160126921) | ||||
2583 | 2583 | -73.97696931406509 | 40.7684390015166 | 3D-AM-1006-01 | 03D | AM | 10062018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 9 | up a tree | 1 | 0 | 1 | 1 | 1 | digging (?) | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | runs from (man led his dog into the area to chase squirrel) | POINT (-73.9769693140651 40.7684390015166) | |
2608 | 2608 | -73.95226776576591 | 40.7934034811368 | 38I-AM-1019-02 | 38I | AM | 10192018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9522677657659 40.7934034811368) | ||||
2646 | 2646 | -73.9772239251936 | 40.7731716665766 | 8A-AM-1013-05 | 08A | AM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9772239251936 40.7731716665766) | ||||
2651 | 2651 | -73.9632993246327 | 40.78881995196561 | 29C-AM-1007-05 | 29C | AM | 10072018 | 5 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9632993246327 40.7888199519656) | ||||
2696 | 2696 | -73.9501457233643 | 40.797094356558 | 42I-PM-1014-01 | 42I | PM | 10142018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9501457233643 40.797094356558) | ||||
2727 | 2727 | -73.974596903918 | 40.7765498215674 | 12A-PM-1013-02 | 12A | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.974596903918 40.7765498215674) | ||||
2746 | 2746 | -73.95614328368629 | 40.798266534723396 | 41C-AM-1017-07 | 41C | AM | 10172018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9561432836863 40.7982665347234) | ||||
2752 | 2752 | -73.972069937746 | 40.765940262783204 | 3I-PM-1013-04 | 03I | PM | 10132018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97206993774601 40.7659402627832) | ||||
2788 | 2788 | -73.9647845655965 | 40.7816573808695 | 21F-AM-1018-07 | 21F | AM | 10182018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9647845655965 40.7816573808695) | ||||
2799 | 2799 | -73.96826273820729 | 40.773076674345205 | 11H-AM-1010-09 | 11H | AM | 10102018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9682627382073 40.7730766743452) | ||||
2802 | 2802 | -73.9533101544112 | 40.7938634280159 | 38H-AM-1019-01 | 38H | AM | 10192018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9533101544112 40.7938634280159) | ||||
2822 | 2822 | -73.9711120079542 | 40.776080191176604 | 13D-PM-1018-14 | 13D | PM | 10182018 | 14 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | climbing (down) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711120079542 40.7760801911766) | |||
2878 | 2878 | -73.969720780557 | 40.774110568875706 | 12F-AM-1020-04 | 12F | AM | 10202018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.969720780557 40.7741105688757) | ||||
2912 | 2912 | -73.9632164738341 | 40.7921270121312 | 32B-PM-1010-03 | 32B | PM | 10102018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9632164738341 40.7921270121312) | ||||
2913 | 2913 | -73.9621297946132 | 40.7944058222814 | 34A-PM-1013-05 | 34A | PM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9621297946132 40.7944058222814) | ||||
2915 | 2915 | -73.9734630412566 | 40.7653097139415 | 1H-PM-1013-02 | 01H | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9734630412566 40.7653097139415) | ||||
2938 | 2938 | -73.97033289561999 | 40.7701079697795 | 7H-AM-1006-14 | 07H | AM | 10062018 | 14 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.97033289562 40.7701079697795) | ||||
2943 | 2943 | -73.962534856258 | 40.7812134517411 | 22H-PM-1007-01 | 22H | PM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.962534856258 40.7812134517411) | ||||
2971 | 2971 | -73.9639801411692 | 40.7778921302618 | 18I-PM-1007-04 | 18I | PM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | walking sitting up | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9639801411692 40.7778921302618) | |||
2998 | 2998 | -73.97520792474191 | 40.775537697900205 | 11B-AM-1007-01 | 11B | AM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9752079247419 40.7755376979002) | ||||
2999 | 2999 | -73.972415182837 | 40.773080463452004 | 10E-AM-1010-02 | 10E | AM | 10102018 | 2 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.972415182837 40.773080463452) | ||||
3003 | 3003 | -73.96986639266571 | 40.773999710413 | 12F-PM-1007-09 | 12F | PM | 10072018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9698663926657 40.773999710413) | ||||
2882 | 2882 | -73.956581233786 | 40.7902127690837 | 33H-AM-1019-01 | 33H | AM | 10192018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Cinnamon patches | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | wrestling with child | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.956581233786 40.79021276908371) | ||
1098 | 1098 | -73.96049542761291 | 40.7965682182001 | 37A-AM-1012-01 | 37A | AM | 10122018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Drawing included on tally sheet | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | scanning (drawing included) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9604954276129 40.7965682182001) | ||
2504 | 2504 | -73.9550131837533 | 40.7958617258176 | 39E-PM-1013-02 | 39E | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Gray tail & butt | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | POINT (-73.9550131837533 40.7958617258176) | |||
1601 | 1601 | -73.9544278270221 | 40.7987827316512 | 42D-PM-1013-02 | 42D | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Gray tail, Cinnamon feet | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | chasing (chased by #1),found a nut,buried it | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9544278270221 40.7987827316512) | ||
1034 | 1034 | -73.95531638295509 | 40.7988610926249 | 42D-PM-1013-04 | 42D | PM | 10132018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Light Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | carrying nut away | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9553163829551 40.7988610926249) | ||
545 | 545 | -73.97568104536059 | 40.7756257458036 | 11A-PM-1013-01 | 11A | PM | 10132018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Off-white, decorator's white? | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | eating (osage orange) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9756810453606 40.7756257458036) |
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 );