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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1438 | 1438 | -73.97168547522399 | 40.7706668465923 | 7G-PM-1018-07 | 07G | PM | 10182018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.971685475224 40.7706668465923) | |||||
1454 | 1454 | -73.9753818829907 | 40.76978409861629 | 5D-PM-1018-06 | 05D | PM | 10182018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9753818829907 40.7697840986163) | |||||
1463 | 1463 | -73.96300972763659 | 40.7936658446251 | 33A-PM-1018-04 | 33A | PM | 10182018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9630097276366 40.79366584462511) | ||||
1509 | 1509 | -73.9556450015702 | 40.796718805800204 | 39E-AM-1018-04 | 39E | AM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9556450015702 40.7967188058002) | |||||
1528 | 1528 | -73.9690104245067 | 40.7853358193723 | 23A-AM-1018-02 | 23A | AM | 10182018 | 2 | Juvenile | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690104245067 40.7853358193723) | |||||
1530 | 1530 | -73.96893059787509 | 40.781815249626604 | 19C-PM-1018-06 | 19C | PM | 10182018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | Climbed fence | 1 | 0 | 1 | 0 | 0 | climbing (fence) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9689305978751 40.7818152496266) | ||
1531 | 1531 | -73.9630381400083 | 40.7807571827321 | 21H-PM-1018-02 | 21H | PM | 10182018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9630381400083 40.7807571827321) | ||||
1541 | 1541 | -73.9711617997772 | 40.7761212878075 | 13D-PM-1018-04 | 13D | PM | 10182018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711617997772 40.7761212878075) | |||
1691 | 1691 | -73.9703705008688 | 40.7818586173755 | 19B-PM-1018-02 | 19B | PM | 10182018 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703705008688 40.7818586173755) | |||
1736 | 1736 | -73.9743873549635 | 40.7745426051392 | 10C-AM-1018-04 | 10C | AM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9743873549635 40.7745426051392) | |||||
1737 | 1737 | -73.9640741640547 | 40.7807274581426 | 20G-AM-1018-01 | 20G | AM | 10182018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 7 | Tree limb | 0 | 0 | 0 | 0 | 0 | sitting still on limb | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9640741640547 40.7807274581426) | |||
1787 | 1787 | -73.9720365327715 | 40.7762329714016 | 13D-PM-1018-11 | 13D | PM | 10182018 | 11 | Adult | Gray | White | Gray+White | Above Ground | 15 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9720365327715 40.7762329714016) | ||||
1856 | 1856 | -73.97829402311491 | 40.7694236097224 | 4B-PM-1018-05 | 04B | PM | 10182018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9782940231149 40.7694236097224) | |||||
1874 | 1874 | -73.96573273328491 | 40.7747554568985 | 14I-PM-1018-03 | 14I | PM | 10182018 | 3 | Juvenile | Gray | Black | Gray+Black | Above Ground | 4 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9657327332849 40.7747554568985) | ||||
1895 | 1895 | -73.954699659637 | 40.7951308856929 | 38F-AM-1018-02 | 38F | AM | 10182018 | 2 | 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.954699659637 40.7951308856929) | ||||
1898 | 1898 | -73.9721263050502 | 40.7698763846186 | 7G-PM-1018-01 | 07G | PM | 10182018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9721263050502 40.7698763846186) | ||||
1942 | 1942 | -73.96249054313 | 40.793538903878705 | 33A-PM-1018-01 | 33A | PM | 10182018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | stopped to see what i would do 1st | POINT (-73.96249054313 40.7935389038787) | ||||
1978 | 1978 | -73.9579689996645 | 40.794933848991704 | 37D-AM-1018-02 | 37D | AM | 10182018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9579689996645 40.7949338489917) | ||||
1989 | 1989 | -73.96316467546471 | 40.7925716810884 | 32A-AM-1018-02 | 32A | AM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9631646754647 40.7925716810884) | |||||
2048 | 2048 | -73.96276614653759 | 40.7819356810575 | 22G-PM-1018-02 | 22G | PM | 10182018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9627661465376 40.7819356810575) | ||||
2099 | 2099 | -73.9685612289881 | 40.7778488829217 | 16E-PM-1018-08 | 16E | PM | 10182018 | 8 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9685612289881 40.7778488829217) | ||||
2125 | 2125 | -73.9687933229572 | 40.7788600242549 | 17E-PM-1018-01 | 17E | PM | 10182018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9687933229572 40.7788600242549) | ||||
2171 | 2171 | -73.9686370726471 | 40.7780382348833 | 16E-PM-1018-09 | 16E | PM | 10182018 | 9 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 3 | On trunk | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9686370726471 40.7780382348833) | |||
2189 | 2189 | -73.9761776424664 | 40.7695941843825 | 5D-PM-1018-07 | 05D | PM | 10182018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9761776424664 40.7695941843825) | ||||
2201 | 2201 | -73.9717135461165 | 40.7761780680083 | 13D-PM-1018-01 | 13D | PM | 10182018 | 1 | 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.9717135461165 40.776178068008306) | ||||
2255 | 2255 | -73.96429678758571 | 40.78156523539371 | 21F-AM-1018-08 | 21F | AM | 10182018 | 8 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9642967875857 40.7815652353937) | ||||
2294 | 2294 | -73.96308205774409 | 40.7821632293136 | 22G-PM-1018-01 | 22G | PM | 10182018 | 1 | 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 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9630820577441 40.7821632293136) | |||
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) | ||||
2510 | 2510 | -73.9748635473782 | 40.7742591029151 | 10C-AM-1018-02 | 10C | AM | 10182018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | sitting in the sun | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9748635473782 40.7742591029151) | |||
2531 | 2531 | -73.9599424115626 | 40.79574725853271 | 37B-AM-1018-05 | 37B | AM | 10182018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9599424115626 40.7957472585327) | ||||
2543 | 2543 | -73.96914249979191 | 40.780542852496 | 18C-AM-1018-02 | 18C | AM | 10182018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9691424997919 40.780542852496) | ||||
2581 | 2581 | -73.9635981227569 | 40.7928169540326 | 32A-AM-1018-05 | 32A | AM | 10182018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9635981227569 40.7928169540326) | |||||
2582 | 2582 | -73.9665004148497 | 40.780565641175606 | 19E-PM-1018-05 | 19E | PM | 10182018 | 5 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9665004148497 40.7805656411756) | |||||
2599 | 2599 | -73.96898934126929 | 40.785308737683 | 23A-AM-1018-03 | 23A | AM | 10182018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | Tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9689893412693 40.785308737683) | |||
2611 | 2611 | -73.951448051873 | 40.7973951649254 | 42G-AM-1018-02 | 42G | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.951448051873 40.7973951649254) | |||||
2612 | 2612 | -73.97116730065241 | 40.77479796145771 | 12E-PM-1018-05 | 12E | PM | 10182018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9711673006524 40.7747979614577) | |||||
2712 | 2712 | -73.9682760864462 | 40.778072756941704 | 16E-PM-1018-04 | 16E | PM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9682760864462 40.7780727569417) | |||||
2822 | 2822 | -73.9711120079542 | 40.776080191176604 | 13D-PM-1018-14 | 13D | PM | 10182018 | 14 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | climbing (down) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711120079542 40.7760801911766) | |||
2830 | 2830 | -73.9556083695689 | 40.7965223709493 | 39E-AM-1018-02 | 39E | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9556083695689 40.7965223709493) | |||||
2838 | 2838 | -73.9507699667119 | 40.7955166039555 | 40I-AM-1018-02 | 40I | AM | 10182018 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9507699667119 40.795516603955505) | |||||
2876 | 2876 | -73.95589957376541 | 40.7960097734603 | 39E-AM-1018-05 | 39E | AM | 10182018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9558995737654 40.7960097734603) | ||||
2897 | 2897 | -73.9689554458632 | 40.777859339395704 | 16E-PM-1018-10 | 16E | PM | 10182018 | 10 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9689554458632 40.7778593393957) | ||||
2941 | 2941 | -73.96902666603171 | 40.7853134751509 | 23A-AM-1018-01 | 23A | AM | 10182018 | 1 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690266660317 40.7853134751509) | |||||
2960 | 2960 | -73.96252481451499 | 40.7810022923615 | 21H-PM-1018-03 | 21H | PM | 10182018 | 3 | Adult | Gray | Gray+ | Above Ground | 25 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.962524814515 40.7810022923615) | |||||
2966 | 2966 | -73.9630596103391 | 40.792572062055605 | 32A-AM-1018-04 | 32A | AM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | Base of tree | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9630596103391 40.7925720620556) | ||||
2972 | 2972 | -73.9631468456897 | 40.7926110399714 | 32A-AM-1018-03 | 32A | AM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9631468456897 40.7926110399714) | |||||
3014 | 3014 | -73.9665572004288 | 40.780434754830296 | 19E-PM-1018-04 | 19E | PM | 10182018 | 4 | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9665572004288 40.7804347548303) |
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 );