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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2343 | 2343 | -73.9719194877439 | 40.774800096290896 | 11D-AM-1010-04 | 11D | AM | 10102018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9719194877439 40.7748000962909) | ||||
2330 | 2330 | -73.9724618533895 | 40.7745021602455 | 11D-AM-1010-02 | 11D | AM | 10102018 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | walking | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9724618533895 40.7745021602455) | |||
2247 | 2247 | -73.95595201371721 | 40.7950536287174 | 38E-AM-1010-06 | 38E | AM | 10102018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | branches | 1 | 1 | 0 | 0 | 0 | chasing and being chased by #7 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.95595201371721 40.7950536287174) | ||
2229 | 2229 | -73.9620719414292 | 40.788637452988 | 29D-PM-1010-02 | 29D | PM | 10102018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9620719414292 40.788637452988) | ||||
2219 | 2219 | -73.9709242364673 | 40.7684217215595 | 5I-AM-1010-04 | 05I | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9709242364673 40.7684217215595) | |||||
2009 | 2009 | -73.9639505810228 | 40.789573183584 | 29B-PM-1010-01 | 29B | PM | 10102018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 4 | climbing trees | 0 | 0 | 1 | 1 | 1 | scratching self | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9639505810228 40.789573183584) | ||
2007 | 2007 | -73.9684834138222 | 40.772428912021105 | 11H-AM-1010-06 | 11H | AM | 10102018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9684834138222 40.7724289120211) | ||||
1825 | 1825 | -73.9624209799704 | 40.79102009727521 | 31C-PM-1010-01 | 31C | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9624209799704 40.7910200972752) | ||||
1824 | 1824 | -73.9617250054003 | 40.7925390432044 | 33B-PM-1010-03 | 33B | PM | 10102018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9617250054003 40.7925390432044) | |||||
1816 | 1816 | -73.9710187505339 | 40.7797265666746 | 17B-AM-1010-02 | 17B | AM | 10102018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9710187505339 40.7797265666746) | ||||
1799 | 1799 | -73.978844141973 | 40.7696046074378 | 4B-AM-1010-05 | 04B | AM | 10102018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | 0 | 1 | 0 | 0 | 0 | chasing squirrel #6 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.978844141973 40.7696046074378) | |||
1793 | 1793 | -73.97715752493221 | 40.7673873716547 | 2E-AM-1010-07 | 02E | AM | 10102018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9771575249322 40.7673873716547) | ||||
1714 | 1714 | -73.9763542780331 | 40.773653130362206 | 9B-AM-1010-02 | 09B | AM | 10102018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | in bush | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | froze | POINT (-73.9763542780331 40.773653130362206) | ||
1627 | 1627 | -73.9594391759139 | 40.784115697669 | 26I-PM-1010-03 | 26I | PM | 10102018 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | black in tail | Above Ground | 15 | tree | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9594391759139 40.784115697669) | ||
1614 | 1614 | -73.9806718258385 | 40.7692776896995 | 2A-AM-1010-07 | 02A | AM | 10102018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | couldn't get near | POINT (-73.9806718258385 40.76927768969951) | |||
1511 | 1511 | -73.9721642509914 | 40.7701179390078 | 7G-AM-1010-01 | 07G | AM | 10102018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9721642509914 40.7701179390078) | ||||
1492 | 1492 | -73.9807078515193 | 40.768333529264204 | 2A-AM-1010-04 | 02A | AM | 10102018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9807078515193 40.7683335292642) | ||||
1357 | 1357 | -73.96313500206341 | 40.791907210332 | 32B-PM-1010-01 | 32B | PM | 10102018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 25 | in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9631350020634 40.791907210332) | ||||
1333 | 1333 | -73.9754527701832 | 40.7656088463928 | 1G-PM-1010-02 | 01G | PM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | 0 | 0 | 0 | 0 | 0 | laying on tree branch | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | POINT (-73.9754527701832 40.7656088463928) | |||
1256 | 1256 | -73.9679457364586 | 40.7717350221981 | 10I-AM-1010-02 | 10I | AM | 10102018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9679457364586 40.7717350221981) | ||||
1164 | 1164 | -73.97902264006291 | 40.76989976537921 | 4B-AM-1010-01 | 04B | AM | 10102018 | 1 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Above Ground | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9790226400629 40.7698997653792) | ||||
1000 | 1000 | -73.9805137046778 | 40.769275143797 | 2A-AM-1010-08 | 02A | AM | 10102018 | 8 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9805137046778 40.769275143797) | ||||
923 | 923 | -73.9578924882613 | 40.789806297824 | 32G-AM-1010-02 | 32G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 13 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9578924882613 40.789806297824) | |||||
860 | 860 | -73.97135191580271 | 40.7798470142991 | 17B-AM-1010-01 | 17B | AM | 10102018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9713519158027 40.7798470142991) | ||||
847 | 847 | -73.9771335416403 | 40.7668431485224 | 2E-AM-1010-01 | 02E | AM | 10102018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9771335416403 40.7668431485224) | ||||
676 | 676 | -73.9710207438538 | 40.7682187144432 | 5I-AM-1010-05 | 05I | AM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9710207438538 40.7682187144432) | |||||
650 | 650 | -73.98096101171708 | 40.7683896665502 | 2A-AM-1010-02 | 02A | AM | 10102018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | perched on small fence | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9809610117171 40.7683896665502) | |||||
607 | 607 | -73.9547711796823 | 40.7908540751983 | 34I-PM-1010-06 | 34I | PM | 10102018 | 6 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9547711796823 40.7908540751983) | |||||||
547 | 547 | -73.9559677963727 | 40.7951124076946 | 38E-AM-1010-07 | 38E | AM | 10102018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | branches | 1 | 1 | 0 | 0 | 0 | chasing and being chased by #6 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9559677963727 40.7951124076946) | ||
537 | 537 | -73.9682803241007 | 40.772451055832704 | 11H-AM-1010-04 | 11H | AM | 10102018 | 4 | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9682803241007 40.7724510558327) | |||||||
534 | 534 | -73.9650499507011 | 40.7908191782173 | 30A-AM-1010-01 | 30A | AM | 10102018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9650499507011 40.7908191782173) | ||||
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) | |||
417 | 417 | -73.9639888092327 | 40.791449395909 | 31A-AM-1010-01 | 31A | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9639888092327 40.791449395909005) | |||||
278 | 278 | -73.9787796921165 | 40.7707526535381 | 5A-PM-1010-01 | 05A | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9787796921165 40.7707526535381) | ||||
253 | 253 | -73.95896270565609 | 40.7847591558491 | 26I-PM-1010-02 | 26I | PM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | hiding food | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9589627056561 40.7847591558491) | |||
203 | 203 | -73.96387745795491 | 40.79135321291479 | 31A-AM-1010-05 | 31A | AM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | jumping | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | eventually ran from lawnmower (tail flag) | POINT (-73.9638774579549 40.7913532129148) | |||
175 | 175 | -73.9720065066618 | 40.7764043782924 | 13C-AM-1010-04 | 13C | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9720065066618 40.7764043782924) | |||||
157 | 157 | -73.9637946878735 | 40.791570044687795 | 31A-AM-1010-04 | 31A | AM | 10102018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9637946878735 40.7915700446878) | ||||
110 | 110 | -73.97113187902791 | 40.7701941550273 | 7G-AM-1010-02 | 07G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9711318790279 40.7701941550273) | |||||
12 | 12 | -73.96836135162249 | 40.772590884749896 | 11H-AM-1010-03 | 11H | AM | 10102018 | 3 | Adult | Cinnamon | White | Cinnamon+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9683613516225 40.7725908847499) |
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 );