This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Eating, Foraging, Kuks, Tail flags, Tail twitches, Indifferent, Runs from
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14 | 14 | -73.9582694312289 | 40.7917367820255 | 33F-AM-1008-02 | 33F | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9582694312289 40.7917367820255) | |||||
40 | 40 | -73.9535410657077 | 40.7928711760061 | 36H-PM-1008-02 | 36H | PM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9535410657077 40.79287117600611) | |||||
56 | 56 | -73.97246424363941 | 40.7690526441109 | 6G-AM-1008-02 | 06G | AM | 10082018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | bush | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9724642436394 40.7690526441109) | ||||
127 | 127 | -73.96641005044359 | 40.7828778892276 | 21D-AM-1008-02 | 21D | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9664100504436 40.7828778892276) | |||||
249 | 249 | -73.9786339295735 | 40.7684918638639 | 3C-PM-1008-02 | 03C | PM | 10082018 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9786339295735 40.7684918638639) | ||||
615 | 615 | -73.96532790698879 | 40.7758743113817 | 15I-AM-1008-02 | 15I | AM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Could be same squirrel as #1? | Above Ground | 4 | on fence | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9653279069888 40.7758743113817) | ||
732 | 732 | -73.9695041366722 | 40.779787880948206 | 17D-AM-1008-02 | 17D | AM | 10082018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9695041366722 40.7797878809482) | ||||
747 | 747 | -73.97714226252741 | 40.772361415776 | 7B-AM-1008-02 | 07B | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9771422625274 40.772361415776) | |||||
821 | 821 | -73.959077668148 | 40.7926045823346 | 34D-AM-1008-02 | 34D | AM | 10082018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.959077668148 40.7926045823346) | |||||
896 | 896 | -73.9755055978764 | 40.77074386817421 | 6D-AM-1008-02 | 06D | AM | 10082018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9755055978764 40.7707438681742) | |||||
939 | 939 | -73.97614477914841 | 40.7690147873986 | 4D-PM-1008-02 | 04D | PM | 10082018 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9761447791484 40.7690147873986) | ||||
1153 | 1153 | -73.9688523924488 | 40.7844018035948 | 22A-AM-1008-02 | 22A | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9688523924488 40.7844018035948) | |||||
1319 | 1319 | -73.9562105506291 | 40.796699119790894 | 39D-AM-1008-02 | 39D | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9562105506291 40.7966991197909) | |||||
1439 | 1439 | -73.9729645190377 | 40.7723310150843 | 9E-AM-1008-02 | 09E | AM | 10082018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9729645190377 40.7723310150843) | ||||
1472 | 1472 | -73.9698611971209 | 40.7753915552001 | 13F-PM-1008-02 | 13F | PM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9698611971209 40.7753915552001) | ||||
1593 | 1593 | -73.9676539688726 | 40.7777229934129 | 16F-AM-1008-02 | 16F | AM | 10082018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | near fence | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9676539688726 40.7777229934129) | |||
1702 | 1702 | -73.9752699507508 | 40.7688069184057 | 4E-PM-1008-02 | 04E | PM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9752699507508 40.76880691840571) | |||||
1778 | 1778 | -73.96855981061279 | 40.7807054868066 | 19D-PM-1008-02 | 19D | PM | 10082018 | 2 | + | unknown - cannot see, only hear | Above Ground | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9685598106128 40.7807054868066) | |||||||
1955 | 1955 | -73.9606559309874 | 40.7889527629826 | 30E-AM-1008-02 | 30E | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9606559309874 40.7889527629826) | |||||
2020 | 2020 | -73.96914538859642 | 40.77705240897121 | 15E-PM-1008-02 | 15E | PM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9691453885964 40.7770524089712) | |||||
2185 | 2185 | -73.9707571364399 | 40.7758859812524 | 13E-PM-1008-02 | 13E | PM | 10082018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9707571364399 40.7758859812524) | ||||
2347 | 2347 | -73.9663124560664 | 40.779544003786 | 18F-PM-1008-02 | 18F | PM | 10082018 | 2 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 0 | hopping around | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9663124560664 40.779544003786) | ||||||
2675 | 2675 | -73.9762227323096 | 40.768453603768 | 3E-PM-1008-02 | 03E | PM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9762227323096 40.768453603768) | ||||
2793 | 2793 | -73.9742847552668 | 40.7731740123046 | 9D-AM-1008-02 | 09D | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9742847552668 40.7731740123046) | |||||
3009 | 3009 | -73.9675637870968 | 40.782388067172796 | 21D-PM-1008-02 | 21D | PM | 10082018 | 2 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9675637870968 40.7823880671728) |
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 );