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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1374 | 1374 | -73.9653739273979 | 40.788976209696706 | 28B-PM-1010-02 | 28B | PM | 10102018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 4 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9653739273979 40.7889762096967) | ||||
745 | 745 | -73.9671640520938 | 40.7772236833816 | 16G-AM-1010-02 | 16G | AM | 10102018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9671640520938 40.7772236833816) | ||||
46 | 46 | -73.9673253417305 | 40.7749505252981 | 13H-PM-1010-02 | 13H | PM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | tree | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9673253417305 40.7749505252981) | ||||
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) | ||||
2739 | 2739 | -73.9681960138614 | 40.7726867422002 | 11H-AM-1010-02 | 11H | AM | 10102018 | 2 | Cinnamon | Gray | Cinnamon+Gray | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9681960138614 40.7726867422002) | |||||||
1838 | 1838 | -73.9686622009739 | 40.776729438050204 | 15F-PM-1010-02 | 15F | PM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9686622009739 40.7767294380502) | |||||
2500 | 2500 | -73.9689703880705 | 40.7712025611298 | 9I-PM-1010-02 | 09I | PM | 10102018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | standard coloration | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96897038807052 40.7712025611298) | |||
1934 | 1934 | -73.969756965598 | 40.7786455091699 | 16D-PM-1010-02 | 16D | PM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.969756965598 40.7786455091699) | |||||
2361 | 2361 | -73.9708032298419 | 40.7784265674544 | 15C-AM-1010-02 | 15C | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | 0 | 0 | 1 | 0 | 0 | nest building | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9708032298419 40.77842656745441) | ||||
671 | 671 | -73.9709244006956 | 40.7676942639697 | 5I-AM-1010-02 | 05I | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9709244006956 40.7676942639697) | |||||
287 | 287 | -73.9709281471442 | 40.782809793977705 | 20A-AM-1010-02 | 20A | AM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9709281471442 40.7828097939777) | ||||
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) | ||||
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) | |||||
2474 | 2474 | -73.97214488797658 | 40.7762112840981 | 13C-AM-1010-02 | 13C | AM | 10102018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 7 | 0 | 0 | 1 | 0 | 0 | burying | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9721448879766 40.7762112840981) | |||
2136 | 2136 | -73.97218979152109 | 40.7660434203132 | 3I-AM-1010-02 | 03I | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 40 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9721897915211 40.76604342031321) | |||||
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) | ||||
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) | |||
2615 | 2615 | -73.97346051766459 | 40.7686218881386 | 5G-PM-1010-02 | 05G | PM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9734605176646 40.7686218881386) | ||||
3006 | 3006 | -73.97443902173859 | 40.7663168362582 | 2G-AM-1010-02 | 02G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744390217386 40.7663168362582) | |||||
1536 | 1536 | -73.9746128451271 | 40.770095704670894 | 6E-PM-1010-02 | 06E | PM | 10102018 | 2 | Adult | Cinnamon | White | Cinnamon+White | white back legs | Ground Plane | FALSE | small open area but w/ 7 large oak trees | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9746128451271 40.7700957046709) | ||
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) | |||
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) | ||
2578 | 2578 | -73.97653869653709 | 40.766371971272996 | 1F-AM-1010-02 | 01F | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765386965371 40.766371971273) | |||||
711 | 711 | -73.97679809251241 | 40.774362775678 | 9A-PM-1010-02 | 09A | PM | 10102018 | 2 | Adult | + | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9767980925124 40.774362775678) | ||||||
1909 | 1909 | -73.9772070122251 | 40.7694343352509 | 4C-PM-1010-02 | 04C | PM | 10102018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97720701222511 40.7694343352509) | ||||
535 | 535 | -73.9772396728545 | 40.7668696411765 | 2E-AM-1010-02 | 02E | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | totally indifferent | POINT (-73.9772396728545 40.7668696411765) | ||||
2097 | 2097 | -73.9773486521595 | 40.77084549021129 | 5C-PM-1010-02 | 05C | PM | 10102018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9773486521595 40.7708454902113) | ||||
1238 | 1238 | -73.97736921314409 | 40.767977115014894 | 3D-PM-1010-02 | 03D | PM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 8 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9773692131441 40.7679771150149) | |||||
1154 | 1154 | -73.9786936992465 | 40.771394367466606 | 5A-PM-1010-02 | 05A | PM | 10102018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 50 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9786936992465 40.7713943674666) | ||||
2300 | 2300 | -73.9789251806378 | 40.7699558513225 | 4B-AM-1010-02 | 04B | AM | 10102018 | 2 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 30 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9789251806378 40.7699558513225) | ||||
1258 | 1258 | -73.9789385196073 | 40.7675202157155 | 2C-AM-1010-02 | 02C | AM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9789385196073 40.7675202157155) | ||||
2426 | 2426 | -73.9790203973636 | 40.768883711483205 | 3B-AM-1010-02 | 03B | AM | 10102018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | together w/ #3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9790203973636 40.7688837114832) | |||
2038 | 2038 | -73.98035621370491 | 40.7685780990634 | 2B-AM-1010-02 | 02B | AM | 10102018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9803562137049 40.7685780990634) | |||||
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) |
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 );