This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Eating, Kuks, Quaas, Tail twitches, Approaches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12 | 12 | -73.96836135162249 | 40.772590884749896 | 11H-AM-1010-03 | 11H | AM | 10102018 | 3 | Adult | Cinnamon | White | Cinnamon+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9683613516225 40.7725908847499) | ||||||
123 | 123 | -73.9671147090087 | 40.7772624641112 | 16G-AM-1010-03 | 16G | AM | 10102018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | was hanging out w/ #2 until i showed up | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9671147090087 40.7772624641112) | |||
157 | 157 | -73.9637946878735 | 40.791570044687795 | 31A-AM-1010-04 | 31A | AM | 10102018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9637946878735 40.7915700446878) | ||||
278 | 278 | -73.9787796921165 | 40.7707526535381 | 5A-PM-1010-01 | 05A | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9787796921165 40.7707526535381) | ||||
307 | 307 | -73.9683965841952 | 40.771867984897796 | 10I-AM-1010-03 | 10I | AM | 10102018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9683965841952 40.7718679848978) | ||||
514 | 514 | -73.9768357173861 | 40.7683813358343 | 3D-PM-1010-12 | 03D | PM | 10102018 | 12 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9768357173861 40.7683813358343) | ||||
537 | 537 | -73.9682803241007 | 40.772451055832704 | 11H-AM-1010-04 | 11H | AM | 10102018 | 4 | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9682803241007 40.7724510558327) | |||||||
807 | 807 | -73.97772590224409 | 40.76820599079029 | 3D-PM-1010-10 | 03D | PM | 10102018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9777259022441 40.7682059907903) | ||||
1127 | 1127 | -73.9776445567926 | 40.768119107973 | 3D-PM-1010-07 | 03D | PM | 10102018 | 7 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9776445567926 40.768119107973) | ||||
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) | ||||
1347 | 1347 | -73.9616693665254 | 40.792971019627 | 33B-AM-1010-05 | 33B | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9616693665254 40.792971019627) | ||||
1532 | 1532 | -73.97792631145721 | 40.7682681855369 | 3D-PM-1010-08 | 03D | PM | 10102018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9779263114572 40.7682681855369) | ||||
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) | ||
1580 | 1580 | -73.9775079672882 | 40.7691500357424 | 4C-PM-1010-07 | 04C | PM | 10102018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9775079672882 40.7691500357424) | ||||
1849 | 1849 | -73.9788436368415 | 40.7691104998969 | 3B-AM-1010-05 | 03B | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9788436368415 40.7691104998969) | ||||
1901 | 1901 | -73.9680237209555 | 40.771702220822505 | 10I-AM-1010-04 | 10I | AM | 10102018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9680237209555 40.7717022208225) | ||||
1913 | 1913 | -73.97746308218541 | 40.7680626674086 | 3D-PM-1010-11 | 03D | PM | 10102018 | 11 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9774630821854 40.76806266740861) | ||||
1996 | 1996 | -73.977641787698 | 40.769583026578395 | 4C-PM-1010-10 | 04C | PM | 10102018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.977641787698 40.7695830265784) | ||||
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) | ||||
2633 | 2633 | -73.9776151109912 | 40.7694681558386 | 4C-PM-1010-09 | 04C | PM | 10102018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9776151109912 40.7694681558386) | ||||
2674 | 2674 | -73.97710090245809 | 40.7688793288864 | 3D-PM-1010-06 | 03D | PM | 10102018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9771009024581 40.7688793288864) | ||||
2778 | 2778 | -73.9761799699276 | 40.774213409933 | 9B-AM-1010-07 | 09B | AM | 10102018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9761799699276 40.774213409933) | ||||
2824 | 2824 | -73.97506180080991 | 40.773752116709396 | 9B-AM-1010-05 | 09B | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9750618008099 40.7737521167094) | ||||
704 | 704 | -73.97935655643609 | 40.767925939044794 | 2C-AM-1010-09 | 02C | AM | 10102018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | climbed up tree as i neared | POINT (-73.9793565564361 40.7679259390448) | |||
1158 | 1158 | -73.97638947595429 | 40.7705523372364 | 5C-PM-1010-12 | 05C | PM | 10102018 | 12 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9763894759543 40.7705523372364) | ||||
1672 | 1672 | -73.9640989602986 | 40.789929543926505 | 29B-PM-1010-03 | 29B | PM | 10102018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9640989602986 40.7899295439265) | ||||
1827 | 1827 | -73.97797608743551 | 40.769823093658296 | 4C-PM-1010-16 | 04C | PM | 10102018 | 16 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9779760874355 40.7698230936583) | ||||
2116 | 2116 | -73.9801562527339 | 40.76872673271129 | 2B-AM-1010-01 | 02B | AM | 10102018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801562527339 40.7687267327113) | ||||
2587 | 2587 | -73.97899712868441 | 40.7707024146365 | 5A-PM-1010-04 | 05A | PM | 10102018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9789971286844 40.7707024146365) | ||||
2701 | 2701 | -73.97912175106559 | 40.767658347539395 | 2C-AM-1010-05 | 02C | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | right at the base of the same tree as #3 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9791217510656 40.7676583475394) | |||
2816 | 2816 | -73.9809342290598 | 40.7687265606227 | 2A-AM-1010-05 | 02A | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | base of tree with ~ 30 small birds all eating | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | POINT (-73.9809342290598 40.7687265606227) |
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 );