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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2715 | 2715 | -73.9710273070712 | 40.776652124615296 | 14D-PM-1019-16 | 14D | PM | 10192018 | 16 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9710273070712 40.7766521246153) | ||||
2777 | 2777 | -73.98108436110859 | 40.768790549369896 | 2A-PM-1019-05 | 02A | PM | 10192018 | 5 | ? | Gray | Gray+ | Above Ground | 50 | in tall planetree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9810843611086 40.7687905493699) | ||||
2800 | 2800 | -73.9802983138318 | 40.7676540772339 | 1B-PM-1019-05 | 01B | PM | 10192018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9802983138318 40.7676540772339) | ||||
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) | ||||
2825 | 2825 | -73.96435075880079 | 40.790432469329204 | 30B-PM-1019-07 | 30B | PM | 10192018 | 7 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.96435075880082 40.7904324693292) | ||||
2834 | 2834 | -73.9651132904127 | 40.7905384124102 | 29A-PM-1019-02 | 29A | PM | 10192018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9651132904127 40.7905384124102) | ||||
2841 | 2841 | -73.9693262952166 | 40.783260411082004 | 21B-AM-1019-01 | 21B | AM | 10192018 | 1 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9693262952166 40.783260411082) | |||||
2865 | 2865 | -73.98028424040159 | 40.767825738497706 | 1B-PM-1019-03 | 01B | PM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | in tree | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.98028424040162 40.7678257384977) | |||
2877 | 2877 | -73.9730027200009 | 40.7798000868804 | 16A-PM-1019-05 | 16A | PM | 10192018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9730027200009 40.7798000868804) | ||||
2885 | 2885 | -73.9530811255728 | 40.7983069118579 | 42F-AM-1019-02 | 42F | AM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9530811255728 40.79830691185791) | ||||
2902 | 2902 | -73.9673220504383 | 40.777029634596296 | 15G-PM-1019-04 | 15G | PM | 10192018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9673220504383 40.7770296345963) | |||||
2907 | 2907 | -73.96852016269341 | 40.783329261225 | 21B-AM-1019-05 | 21B | AM | 10192018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9685201626934 40.783329261225) | |||||
2987 | 2987 | -73.9563724838337 | 40.7882504581015 | 31I-PM-1019-04 | 31I | PM | 10192018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95637248383372 40.7882504581015) | |||||
2662 | 2662 | -73.97086289336241 | 40.772563088678396 | 10F-PM-1019-08 | 10F | PM | 10192018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Under "Grape Arbor" structure behind Bandshell | 1 | 0 | 0 | 0 | 1 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9708628933624 40.7725630886784) | ||
2254 | 2254 | -73.9709991016317 | 40.7725756707748 | 10F-PM-1019-03 | 10F | PM | 10192018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Cinnamon head | Ground Plane | FALSE | Behind fence, grass | 0 | 0 | 0 | 1 | 0 | eating (nuts) | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | approaches (bad tourists w/ nuts) | POINT (-73.9709991016317 40.772575670774806) |
3017 | 3017 | -73.9662895079734 | 40.7843300758044 | 23C-AM-1019-01 | 23C | AM | 10192018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Gray, Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 7 | 0 | 0 | 1 | 1 | 0 | eating (on branch) | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9662895079734 40.7843300758044) | ||
1254 | 1254 | -73.97640135898651 | 40.766306349920704 | 1F-PM-1019-03 | 01F | PM | 10192018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 1 | 0 | 0 | 0 | 0 | 0 | hiding | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9764013589865 40.7663063499207) | ||||
187 | 187 | -73.9700162034073 | 40.7815277479588 | 19B-AM-1019-02 | 19B | AM | 10192018 | 2 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | posing | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | indifferent then runs from | POINT (-73.9700162034073 40.7815277479588) | ||
2629 | 2629 | -73.9604576237503 | 40.7818120101394 | 23I-PM-1019-01 | 23I | PM | 10192018 | 1 | Adult | Gray | Gray+ | Above Ground | 35 | 1 | 0 | 0 | 0 | 0 | running (across branches) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9604576237503 40.7818120101394) | ||||
855 | 855 | -73.9808247660048 | 40.76894088312871 | 2A-PM-1019-01 | 02A | PM | 10192018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | runs from | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9808247660048 40.7689408831287) | |||
2527 | 2527 | -73.9675697600155 | 40.776679741446294 | 15G-PM-1019-06 | 15G | PM | 10192018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | scratching! | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9675697600155 40.7766797414463) | |||
2517 | 2517 | -73.9710221361528 | 40.7724939691584 | 10F-PM-1019-01 | 10F | PM | 10192018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon head & stripe | Above Ground | 2 | Behind fence, tree trunk | 0 | 0 | 1 | 0 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9710221361528 40.7724939691584) | |
2295 | 2295 | -73.9590632051055 | 40.79631465848271 | 38B-AM-1019-04 | 38B | AM | 10192018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | 0 | 0 | 0 | 0 | 0 | sitting in tree | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | observant | POINT (-73.9590632051055 40.7963146584827) | |||
185 | 185 | -73.95884684130941 | 40.796385229901205 | 38B-AM-1019-05 | 38B | AM | 10192018 | 5 | Adult | Gray | Gray+ | Above Ground | 28 | 0 | 0 | 1 | 0 | 0 | sitting still | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9588468413094 40.7963852299012) | ||||
2685 | 2685 | -73.9601851468038 | 40.7968698151479 | 38A-AM-1019-05 | 38A | AM | 10192018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Cinnamon head, White belly | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | standing on back legs | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | POINT (-73.9601851468038 40.7968698151479) | ||
2117 | 2117 | -73.9597192455543 | 40.7973316178661 | 38A-AM-1019-03 | 38A | AM | 10192018 | 3 | Adult | Gray | White | Gray+White | White belly | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | stood on back legs | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | POINT (-73.9597192455543 40.7973316178661) | ||
1286 | 1286 | -73.9589096782789 | 40.793969875790296 | 35D-AM-1019-02 | 35D | AM | 10192018 | 2 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Black tail & edge, Cinnamon mid, While tail edge | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | very quietly searching in long grass | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9589096782789 40.7939698757903) | ||
2140 | 2140 | -73.9598875541307 | 40.79734155807171 | 38A-AM-1019-04 | 38A | AM | 10192018 | 4 | Adult | Gray | Gray+ | Above Ground | 2 | 0 | 0 | 0 | 0 | 0 | walking | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9598875541307 40.7973415580717) | ||||
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) | ||
6 | 6 | -73.9565700386162 | 40.7902561000937 | 33H-AM-1019-02 | 33H | AM | 10192018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | wrestling with mother | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9565700386162 40.7902561000937) |
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 );