This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Climbing, Foraging, Tail flags, Tail twitches
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21 | 21 | -73.9703781726172 | 40.778752613032104 | 16C-PM-1018-03 | 16C | PM | 10182018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703781726172 40.7787526130321) | ||||
329 | 329 | -73.967832992543 | 40.778366991340796 | 17E-PM-1018-03 | 17E | PM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.967832992543 40.7783669913408) | |||||
408 | 408 | -73.9633760173635 | 40.7818422357619 | 22G-PM-1018-03 | 22G | PM | 10182018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | chilling | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | observed | POINT (-73.96337601736352 40.7818422357619) | ||
452 | 452 | -73.960300330029 | 40.795347587186896 | 36B-AM-1013-03 | 36B | AM | 10132018 | 3 | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.960300330029 40.7953475871869) | ||||||
454 | 454 | -73.9752793195744 | 40.7733960128931 | 9C-AM-1006-03 | 09C | AM | 10062018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9752793195744 40.7733960128931) | |||||
542 | 542 | -73.9713487591577 | 40.7784353043714 | 15C-PM-1017-03 | 15C | PM | 10172018 | 3 | Adult | Black | Black+ | Above Ground | 17 | running across overpass | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9713487591577 40.7784353043714) | ||||
569 | 569 | -73.9709040623777 | 40.7701163892686 | 7H-PM-1006-03 | 07H | PM | 10062018 | 3 | Adult | Gray | Gray+ | Above Ground | 8 | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9709040623777 40.7701163892686) | ||||
757 | 757 | -73.9783185278595 | 40.7724861675504 | 7A-AM-1006-03 | 07A | AM | 10062018 | 3 | Adult | Gray | Gray+ | 3/4 length tail, hair loss | Above Ground | 20 | in trees, then to ground | 1 | 0 | 1 | 0 | 0 | jumping | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9783185278595 40.7724861675504) | ||
786 | 786 | -73.953296595236 | 40.7927644594513 | 36I-AM-1017-03 | 36I | AM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon stripe on back | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.953296595236 40.7927644594513) | |||
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) | ||||
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) | ||||
1021 | 1021 | -73.97186968288 | 40.778926988884 | 15B-AM-1014-03 | 15B | AM | 10142018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | running (from a dog) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97186968288 40.778926988884) | |||
1150 | 1150 | -73.97447264347429 | 40.776729630785 | 12A-PM-1013-03 | 12A | PM | 10132018 | 3 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | 1 | 0 | 0 | 0 | 0 | chased up a tree by #4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744726434743 40.776729630785) | ||||
1242 | 1242 | -73.9714512125212 | 40.77602752501139 | 13D-PM-1018-03 | 13D | PM | 10182018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9714512125212 40.7760275250114) | |||
1255 | 1255 | -73.9717469822209 | 40.7753731930704 | 12D-PM-1014-03 | 12D | PM | 10142018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9717469822209 40.7753731930704) | |||||
1418 | 1418 | -73.9673924060436 | 40.7788781851716 | 17F-AM-1007-03 | 17F | AM | 10072018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9673924060436 40.7788781851716) | ||||
1447 | 1447 | -73.9601968065017 | 40.7935831836482 | 34C-PM-1012-03 | 34C | PM | 10122018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9601968065017 40.79358318364821) | ||||
1481 | 1481 | -73.95388671863759 | 40.794140943400706 | 38G-PM-1020-03 | 38G | PM | 10202018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9538867186376 40.7941409434007) | ||||
1516 | 1516 | -73.9625383795297 | 40.7883862331728 | 28D-AM-1012-03 | 28D | AM | 10122018 | 3 | Adult | Black | Black+ | Above Ground | 30 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9625383795297 40.7883862331728) | |||||
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) | ||||
1748 | 1748 | -73.955710327539 | 40.797451079756705 | 40D-AM-1013-03 | 40D | AM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.955710327539 40.7974510797567) | ||||
1750 | 1750 | -73.9684806250183 | 40.7858776210151 | 24A-PM-1007-03 | 24A | PM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9684806250183 40.7858776210151) | |||||
1773 | 1773 | -73.9611126813593 | 40.7943113021522 | 35B-AM-1010-03 | 35B | AM | 10102018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9611126813593 40.7943113021522) | ||||
1985 | 1985 | -73.9530791622513 | 40.79598856039671 | 40G-PM-1013-03 | 40G | PM | 10132018 | 3 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9530791622513 40.7959885603967) | |||||
2041 | 2041 | -73.9651796685091 | 40.7785578267586 | 18G-AM-1014-03 | 18G | AM | 10142018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9651796685091 40.7785578267586) | ||||
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) | |||
2172 | 2172 | -73.9642900903774 | 40.791701716884205 | 31A-AM-1010-03 | 31A | AM | 10102018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9642900903774 40.7917017168842) | |||||
2256 | 2256 | -73.9720050204318 | 40.769941909416794 | 7G-AM-1010-03 | 07G | AM | 10102018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9720050204318 40.7699419094168) | ||||
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) | ||||
2268 | 2268 | -73.9590191655172 | 40.7926139425111 | 34D-AM-1008-03 | 34D | AM | 10082018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9590191655172 40.7926139425111) | ||||
2407 | 2407 | -73.95557243517759 | 40.7967602498249 | 39E-AM-1018-03 | 39E | AM | 10182018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9555724351776 40.7967602498249) | ||||
2412 | 2412 | -73.98094464895641 | 40.768503216587895 | 2A-PM-1019-03 | 02A | PM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | in tree! | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9809446489564 40.7685032165879) | |||
2630 | 2630 | -73.965019827314 | 40.775986429132296 | 15I-AM-1008-03 | 15I | AM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.965019827314 40.7759864291323) | |||||
2694 | 2694 | -73.969628583287 | 40.770406779793205 | 8H-AM-1017-03 | 08H | AM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | fence | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.969628583287 40.7704067797932) | |||
2836 | 2836 | -73.953092053256 | 40.7982256930243 | 42F-PM-1017-03 | 42F | PM | 10172018 | 3 | Gray | Cinnamon | Gray+Cinnamon | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.953092053256 40.7982256930243) | |||||||
2871 | 2871 | -73.9777124331985 | 40.7704051056666 | 5B-AM-1008-03 | 05B | AM | 10082018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9777124331985 40.7704051056666) | ||||
2890 | 2890 | -73.9726236083428 | 40.7788217771475 | 15B-PM-1017-03 | 15B | PM | 10172018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | by water | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9726236083428 40.778821777147506) | |||
2903 | 2903 | -73.9670432105975 | 40.7753462013506 | 14H-PM-1012-03 | 14H | PM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9670432105975 40.7753462013506) | ||||
2914 | 2914 | -73.9722053355548 | 40.7662094993614 | 3I-AM-1010-03 | 03I | AM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 50 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9722053355548 40.7662094993614) | |||||
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) | |||||
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) | |||
2213 | 2213 | -73.9707487237344 | 40.7800822831001 | 17B-PM-1012-03 | 17B | PM | 10122018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | 1 | 1 | 0 | 0 | 0 | 2/3 chasing each other | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9707487237344 40.7800822831001) | |||
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) |
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 );