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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
700 | 700 | -73.9691261755936 | 40.7702929428604 | 8I-AM-1006-12 | 08I | AM | 10062018 | 12 | Adult | Gray | Gray+ | Above Ground | 50 | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9691261755936 40.7702929428604) | ||||
2363 | 2363 | -73.9690638424196 | 40.7713869295685 | 9H-AM-1006-06 | 09H | AM | 10062018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9690638424196 40.7713869295685) | ||||
1659 | 1659 | -73.96904988769441 | 40.7700011818847 | 8I-AM-1006-07 | 08I | AM | 10062018 | 7 | Adult | Gray | White | Gray+White | White ring on short tail | Above Ground | 20 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690498876944 40.7700011818847) | |||
1745 | 1745 | -73.9688438058715 | 40.7703014325728 | 8I-AM-1006-05 | 08I | AM | 10062018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 20 | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9688438058715 40.7703014325728) | |||
333 | 333 | -73.9667560049684 | 40.7882333830729 | 27A-PM-1006-01 | 27A | PM | 10062018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on a tree | 0 | 0 | 0 | 1 | 1 | walking up & down branches | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9667560049684 40.7882333830729) | |||
178 | 178 | -73.9613780522542 | 40.790786197111004 | 31D-PM-1006-04 | 31D | PM | 10062018 | 4 | Adult | Gray | Gray+ | Above Ground | 30 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9613780522542 40.790786197111) | |||||
1542 | 1542 | -73.960876728048 | 40.790357245370004 | 31D-PM-1006-03 | 31D | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.960876728048 40.79035724537) | ||||
2180 | 2180 | -73.960864328605 | 40.7902122634639 | 31D-PM-1006-02 | 31D | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.960864328605 40.7902122634639) | |||||
379 | 379 | -73.9606817053484 | 40.7917320450401 | 32D-PM-1006-07 | 32D | PM | 10062018 | 7 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9606817053484 40.7917320450401) | ||||
2299 | 2299 | -73.9605554843228 | 40.7901473714024 | 31E-PM-1006-09 | 31E | PM | 10062018 | 9 | 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.9605554843228 40.7901473714024) | ||||
2935 | 2935 | -73.96045994773449 | 40.7915035010169 | 32D-PM-1006-06 | 32D | PM | 10062018 | 6 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9604599477345 40.7915035010169) | ||||
2623 | 2623 | -73.9604482901468 | 40.7898646293603 | 31E-PM-1006-07 | 31E | PM | 10062018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9604482901468 40.7898646293603) | ||||
1995 | 1995 | -73.9603366992925 | 40.7899612889539 | 31E-PM-1006-05 | 31E | PM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9603366992925 40.789961288953904) | ||||
1815 | 1815 | -73.96032682553171 | 40.7900154505092 | 31E-PM-1006-06 | 31E | PM | 10062018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9603268255317 40.7900154505092) | ||||
728 | 728 | -73.96029131055779 | 40.7910635810038 | 32D-PM-1006-03 | 32D | PM | 10062018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 40 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9602913105578 40.7910635810038) | ||||
670 | 670 | -73.9602398690946 | 40.7910157676119 | 32D-PM-1006-04 | 32D | PM | 10062018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 40 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9602398690946 40.7910157676119) | ||||
1757 | 1757 | -73.9601561064548 | 40.7900513933531 | 31E-PM-1006-08 | 31E | PM | 10062018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9601561064548 40.7900513933531) | ||||
2408 | 2408 | -73.9596949258862 | 40.79000794792171 | 31E-PM-1006-04 | 31E | PM | 10062018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9596949258862 40.7900079479217) | |||||
775 | 775 | -73.95957577926829 | 40.7899242643847 | 31E-PM-1006-01 | 31E | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | under bushes | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9595757792683 40.7899242643847) | |||
830 | 830 | -73.95956459625391 | 40.7899599350145 | 31E-PM-1006-03 | 31E | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | under bushes | 0 | 0 | 0 | 1 | 1 | burying | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9595645962539 40.7899599350145) | ||
453 | 453 | -73.959514034869 | 40.789911786416 | 31E-PM-1006-02 | 31E | PM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | under bushes | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.959514034869 40.789911786416) | |||
673 | 673 | -73.958417813526 | 40.792730121447605 | 34E-PM-1006-01 | 34E | PM | 10062018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Above Ground | 20 | 0 | 0 | 0 | 0 | 0 | sitting and watching on a tree | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.958417813526 40.7927301214476) | |||
2842 | 2842 | -73.9579292340076 | 40.7976287835027 | 39C-PM-1006-04 | 39C | PM | 10062018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9579292340076 40.7976287835027) | ||||
71 | 71 | -73.9576245992455 | 40.7873862510001 | 29H-PM-1006-01 | 29H | PM | 10062018 | 1 | Adult | Gray | Gray+ | Above Ground | 50 | 0 | 0 | 1 | 0 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9576245992455 40.7873862510001) | ||||
134 | 134 | -73.9575943815564 | 40.7933755266787 | 35E-PM-1006-07 | 35E | PM | 10062018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9575943815564 40.7933755266787) | |||||
418 | 418 | -73.9573604880421 | 40.7930844158021 | 35E-PM-1006-03 | 35E | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9573604880421 40.7930844158021) | ||||
2559 | 2559 | -73.95723834787741 | 40.787685738072206 | 30H-PM-1006-01 | 30H | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9572383478774 40.7876857380722) | ||||
1973 | 1973 | -73.957138759793 | 40.795592603505504 | 38D-PM-1006-02 | 38D | PM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.957138759793 40.7955926035055) | ||||
564 | 564 | -73.95700862122851 | 40.7946679755816 | 37E-PM-1006-08 | 37E | PM | 10062018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95700862122851 40.7946679755816) | |||||
1703 | 1703 | -73.956998502609 | 40.7948117428147 | 37E-PM-1006-01 | 37E | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.956998502609 40.7948117428147) | ||||
55 | 55 | -73.9568802149818 | 40.7972399133816 | 39C-PM-1006-01 | 39C | PM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9568802149818 40.7972399133816) | |||||
1676 | 1676 | -73.9566686940197 | 40.794924397955 | 37E-PM-1006-05 | 37E | PM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9566686940197 40.794924397955) | ||||
2290 | 2290 | -73.95656457165641 | 40.795903994957705 | 38D-PM-1006-03 | 38D | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9565645716564 40.795903994957705) | ||||
1049 | 1049 | -73.9564606426367 | 40.788054657260794 | 30I-PM-1006-06 | 30I | PM | 10062018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ran up tree | POINT (-73.9564606426367 40.7880546572608) | |||
754 | 754 | -73.9563203089105 | 40.7906275357726 | 33G-PM-1006-01 | 33G | PM | 10062018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9563203089105 40.7906275357726) | |||||
290 | 290 | -73.95606798644259 | 40.7947887062326 | 37E-PM-1006-06 | 37E | PM | 10062018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9560679864426 40.7947887062326) | ||||
456 | 456 | -73.9547878025303 | 40.7899151873467 | 33I-PM-1006-05 | 33I | PM | 10062018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9547878025303 40.7899151873467) | |||||
546 | 546 | -73.9547423290276 | 40.7899702628835 | 33I-PM-1006-09 | 33I | PM | 10062018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9547423290276 40.7899702628835) | |||||
1820 | 1820 | -73.9546337446865 | 40.7898772579576 | 33I-PM-1006-08 | 33I | PM | 10062018 | 8 | Adult | Gray | Gray+ | Above Ground | 6 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9546337446865 40.7898772579576) | |||||
1458 | 1458 | -73.9545037193355 | 40.7900225055417 | 33I-PM-1006-04 | 33I | PM | 10062018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9545037193355 40.7900225055417) | |||||
2063 | 2063 | -73.95447632818859 | 40.7969645476349 | 40F-PM-1006-03 | 40F | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9544763281886 40.7969645476349) | ||||
2958 | 2958 | -73.9541748083177 | 40.795275844289705 | 39F-PM-1006-01 | 39F | PM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | carrying leaves | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9541748083177 40.7952758442897) | ||||
2870 | 2870 | -73.9538475741188 | 40.796479421955 | 40F-PM-1006-02 | 40F | PM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9538475741188 40.796479421955) | ||||
2650 | 2650 | -73.9538251716292 | 40.7919360198175 | 35I-PM-1006-01 | 35I | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9538251716292 40.7919360198175) | ||||
1422 | 1422 | -73.9537356145842 | 40.7917273773486 | 35I-PM-1006-02 | 35I | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 6 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9537356145842 40.7917273773486) | |||||
2336 | 2336 | -73.95312632141359 | 40.7965675089932 | 40F-PM-1006-01 | 40F | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9531263214136 40.7965675089932) | ||||
2035 | 2035 | -73.9527184914182 | 40.792678590484705 | 37I-PM-1006-02 | 37I | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9527184914182 40.7926785904847) | |||||
2008 | 2008 | -73.95243640874371 | 40.792846505434 | 37I-PM-1006-01 | 37I | PM | 10062018 | 1 | Adult | Cinnamon | Gray, Black | Cinnamon+Gray, Black | Above Ground | 5 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9524364087437 40.792846505434) |
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 );