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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1561 | 1561 | -73.9642397829547 | 40.7918992406575 | 31A-PM-1017-02 | 31A | PM | 10172018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.96423978295472 40.7918992406575) | ||||
1611 | 1611 | -73.9655238539833 | 40.7815633947684 | 21E-AM-1017-03 | 21E | AM | 10172018 | 3 | Adult | Gray | Gray+ | Above Ground | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9655238539833 40.7815633947684) | |||||
1731 | 1731 | -73.9692846326638 | 40.7841049008492 | 22A-PM-1017-02 | 22A | PM | 10172018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9692846326638 40.7841049008492) | |||||
1754 | 1754 | -73.9652134469963 | 40.7803438278765 | 19F-PM-1017-05 | 19F | PM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9652134469963 40.7803438278765) | ||||
1792 | 1792 | -73.97057045274809 | 40.7762853012151 | 13E-AM-1017-06 | 13E | AM | 10172018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9705704527481 40.7762853012151) | |||||
1821 | 1821 | -73.9676314068477 | 40.7788030406918 | 17E-AM-1017-08 | 17E | AM | 10172018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9676314068477 40.7788030406918) | |||||
1832 | 1832 | -73.9693159934697 | 40.7831212338295 | 21B-PM-1017-03 | 21B | PM | 10172018 | 3 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9693159934697 40.7831212338295) | ||||
1846 | 1846 | -73.96533111365609 | 40.780193490342995 | 19F-PM-1017-07 | 19F | PM | 10172018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9653311136561 40.78019349034301) | ||||
1886 | 1886 | -73.956806913988 | 40.7987736900857 | 41C-AM-1017-06 | 41C | AM | 10172018 | 6 | Adult | Gray | Gray+ | Above Ground | 4 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.956806913988 40.7987736900857) | |||||
1916 | 1916 | -73.9693504617353 | 40.7830678709405 | 21B-PM-1017-02 | 21B | PM | 10172018 | 2 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | stood on hind legs with front legs on the chest | POINT (-73.9693504617353 40.7830678709405) | |||
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) | |||||
2083 | 2083 | -73.9702382274798 | 40.7721754848905 | 10G-PM-1017-03 | 10G | PM | 10172018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9702382274798 40.7721754848905) | |||||
2084 | 2084 | -73.9567255763265 | 40.7936331899263 | 36F-AM-1017-05 | 36F | AM | 10172018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 8 | 0 | 0 | 0 | 0 | 0 | staying very still to avoid two very curious dogs on the ground | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | petrified,frozen (tail over its back,frozen) | POINT (-73.9567255763265 40.7936331899263) | ||
2114 | 2114 | -73.9651541395415 | 40.7798283208748 | 19G-PM-1017-01 | 19G | PM | 10172018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 12 | 0 | 0 | 0 | 0 | 0 | watching | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9651541395415 40.7798283208748) | |||
2137 | 2137 | -73.96488316116292 | 40.780132641497296 | 19G-PM-1017-02 | 19G | PM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | patting ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9648831611629 40.7801326414973) | |||
2182 | 2182 | -73.9573656523498 | 40.7979754563974 | 40C-AM-1017-01 | 40C | AM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (#2) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9573656523498 40.7979754563974) | ||||
2206 | 2206 | -73.95944460183459 | 40.7917800352042 | 33D-AM-1017-06 | 33D | AM | 10172018 | 6 | Adult | Black | Black+ | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (ran into hole in tree trunk) | POINT (-73.9594446018346 40.7917800352042) | ||||
2246 | 2246 | -73.9711607544742 | 40.774988247642 | 12E-AM-1017-04 | 12E | AM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711607544742 40.774988247642) | |||||
2293 | 2293 | -73.9675309175947 | 40.7788649926486 | 17E-AM-1017-09 | 17E | AM | 10172018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9675309175947 40.7788649926486) | |||||
2324 | 2324 | -73.9737247632185 | 40.7759469280872 | 12C-PM-1017-01 | 12C | PM | 10172018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | digging/burying,drinking from lake | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9737247632185 40.7759469280872) | |||
2327 | 2327 | -73.9567801028221 | 40.7960096659564 | 38D-AM-1017-01 | 38D | AM | 10172018 | 1 | + | Above Ground | 30 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9567801028221 40.7960096659564) | |||||||
2442 | 2442 | -73.9699369796844 | 40.772035019127294 | 10G-PM-1017-04 | 10G | PM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9699369796844 40.7720350191273) | |||||
2449 | 2449 | -73.9599911537509 | 40.791445254284504 | 33D-AM-1017-04 | 33D | AM | 10172018 | 4 | Adult | Black | Black+ | Above Ground | 5 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9599911537509 40.7914452542845) | |||||
2460 | 2460 | -73.9526681107152 | 40.7977012009146 | 42F-PM-1017-01 | 42F | PM | 10172018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9526681107152 40.7977012009146) | |||
2495 | 2495 | -73.9621253644004 | 40.7912082086879 | 31C-AM-1017-01 | 31C | AM | 10172018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 8 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9621253644004 40.7912082086879) | ||||
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) | ||||
2658 | 2658 | -73.9690212174 | 40.783409940410706 | 21B-PM-1017-05 | 21B | PM | 10172018 | 5 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9690212174 40.7834099404107) | |||||
2678 | 2678 | -73.95629468736941 | 40.7938593012595 | 36F-AM-1017-01 | 36F | AM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (dog) | POINT (-73.9562946873694 40.7938593012595) | ||||
2697 | 2697 | -73.9710674928906 | 40.7778757544025 | 15D-PM-1017-06 | 15D | PM | 10172018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | walking | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | stopped and watched me before slowly moving on | POINT (-73.9710674928906 40.7778757544025) | ||
2698 | 2698 | -73.9744917362668 | 40.77783887377 | 13A-AM-1017-02 | 13A | AM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744917362668 40.77783887377) | |||||
2731 | 2731 | -73.9595886063173 | 40.7918405182594 | 33D-AM-1017-09 | 33D | AM | 10172018 | 9 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 7 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9595886063173 40.7918405182594) | ||||
2748 | 2748 | -73.960094705031 | 40.7916066137699 | 33D-AM-1017-01 | 33D | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.960094705031 40.7916066137699) | ||||
2764 | 2764 | -73.9692660977515 | 40.7830532310766 | 21B-PM-1017-01 | 21B | PM | 10172018 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | paused to look at me | POINT (-73.9692660977515 40.7830532310766) | |||
2774 | 2774 | -73.9705409446299 | 40.7764608087703 | 14E-PM-1017-03 | 14E | PM | 10172018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9705409446299 40.7764608087703) | ||||
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) | |||||||
2840 | 2840 | -73.9532163535175 | 40.7982970313067 | 42F-PM-1017-04 | 42F | PM | 10172018 | 4 | Gray | Gray+ | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9532163535175 40.7982970313067) | ||||||||
2866 | 2866 | -73.9744025383371 | 40.7777296605765 | 13A-AM-1017-04 | 13A | AM | 10172018 | 4 | Adult | Gray | Gray+ | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744025383371 40.7777296605765) | |||||||
2867 | 2867 | -73.969370141813 | 40.7840721191988 | 22A-PM-1017-03 | 22A | PM | 10172018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.969370141813 40.7840721191988) | ||||
2908 | 2908 | -73.96542881512659 | 40.7815953970174 | 21E-AM-1017-02 | 21E | AM | 10172018 | 2 | Adult | Gray | Gray+ | Above Ground | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9654288151266 40.7815953970174) | |||||
2974 | 2974 | -73.9575791421589 | 40.7959934459432 | 38D-AM-1017-06 | 38D | AM | 10172018 | 6 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9575791421589 40.7959934459432) | ||||
3007 | 3007 | -73.9635140434993 | 40.7912807969365 | 31B-AM-1017-01 | 31B | AM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9635140434993 40.7912807969365) | |||||
1070 | 1070 | -73.9674631254594 | 40.7790076357696 | 17E-AM-1017-10 | 17E | AM | 10172018 | 10 | Juvenile | Gray | Gray+ | Above Ground | 2 | Fence | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9674631254594 40.7790076357696) | ||||
300 | 300 | -73.9528149779809 | 40.7924984810637 | 36I-AM-1017-06 | 36I | AM | 10172018 | 6 | Adult | Gray | Black | Gray+Black | Darker than others | Above Ground | 10 | Running down tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9528149779809 40.7924984810637) | ||
1229 | 1229 | -73.9677751507448 | 40.779099006665795 | 17E-AM-1017-11 | 17E | AM | 10172018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | Shore | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9677751507448 40.7790990066658) | ||||
778 | 778 | -73.9677054870327 | 40.778992870166 | 17E-AM-1017-03 | 17E | AM | 10172018 | 3 | Adult | Gray | Gray+ | Above Ground | 9 | Tree trunk | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9677054870327 40.778992870166) | ||||
105 | 105 | -73.9589249555235 | 40.7908193284981 | 32E-PM-1017-03 | 32E | PM | 10172018 | 3 | Adult | Gray | Gray+ | Above Ground | 2 | bottom of tree | 0 | 0 | 0 | 1 | 0 | still | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9589249555235 40.7908193284981) | |||
805 | 805 | -73.97068515461841 | 40.7780777016038 | 15D-PM-1017-04 | 15D | PM | 10172018 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2 | on fence | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9706851546184 40.7780777016038) | ||||
683 | 683 | -73.97076836215841 | 40.775981556612294 | 13E-AM-1017-11 | 13E | AM | 10172018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on/in log | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9707683621584 40.77598155661231) | ||||
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) | ||||
1182 | 1182 | -73.9667206046912 | 40.777999356509795 | 17G-PM-1017-04 | 17G | PM | 10172018 | 4 | 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.9667206046912 40.7779993565098) | |||
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) | |||
1173 | 1173 | -73.959070754026 | 40.790667514341294 | 32E-PM-1017-07 | 32E | PM | 10172018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.959070754026 40.7906675143413) |
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 );