This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1483 | 1483 | -73.9545773579075 | 40.7898684635744 | 33I-AM-1008-05 | 33I | AM | 10082018 | 5 | Adult | + | Above Ground | 100 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | nearly dropped shell on my head! | POINT (-73.9545773579075 40.7898684635744) | |||||
247 | 247 | -73.97331176635409 | 40.7694584620114 | 6F-PM-1008-05 | 06F | PM | 10082018 | 5 | Adult | Cinnamon | White | Cinnamon+White | white patch | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97331176635412 40.7694584620114) | |||
863 | 863 | -73.97640160306659 | 40.7689894344251 | 4D-PM-1008-05 | 04D | PM | 10082018 | 5 | 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.9764016030666 40.7689894344251) | ||||
80 | 80 | -73.9688454483585 | 40.78453012881629 | 22A-AM-1008-05 | 22A | AM | 10082018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 3 | trash can | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9688454483585 40.7845301288163) | |||
139 | 139 | -73.969847380865 | 40.7769884612305 | 14E-AM-1008-05 | 14E | AM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 25 | 0 | 0 | 1 | 0 | 0 | nest building | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.969847380865 40.7769884612305) | ||||
276 | 276 | -73.9758579666874 | 40.767932654884504 | 3E-PM-1008-05 | 03E | PM | 10082018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | jump | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9758579666874 40.7679326548845) | ||||
306 | 306 | -73.96897001002671 | 40.7775169562765 | 15E-PM-1008-05 | 15E | PM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 20 | 0 | 0 | 0 | 0 | 0 | sitting | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9689700100267 40.7775169562765) | ||||
436 | 436 | -73.9734695768004 | 40.7716297491384 | 8E-PM-1008-05 | 08E | PM | 10082018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 5, 6, 7 all at same tree trunk base | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9734695768004 40.7716297491384) | |||
647 | 647 | -73.9734762649298 | 40.7663703404546 | 3H-AM-1008-05 | 03H | AM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 13 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9734762649298 40.7663703404546) | ||||
672 | 672 | -73.9588708103486 | 40.790579407884294 | 32F-PM-1008-05 | 32F | PM | 10082018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9588708103486 40.7905794078843) | |||||
689 | 689 | -73.970595381455 | 40.7762912142457 | 13E-PM-1008-05 | 13E | PM | 10082018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.970595381455 40.7762912142457) | ||||
696 | 696 | -73.96560981941491 | 40.7757643078973 | 15I-AM-1008-05 | 15I | AM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 5 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9656098194149 40.7757643078973) | |||||
792 | 792 | -73.97301156879641 | 40.7741018274312 | 10D-AM-1008-05 | 10D | AM | 10082018 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9730115687964 40.7741018274312) | ||||
810 | 810 | -73.967418114684 | 40.7764595360054 | 15G-AM-1008-05 | 15G | AM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.967418114684 40.7764595360054) | ||||
909 | 909 | -73.9665705456197 | 40.782355287104394 | 21D-PM-1008-05 | 21D | PM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9665705456197 40.7823552871044) | ||||
1288 | 1288 | -73.97304542959971 | 40.77029094543921 | 7F-AM-1008-05 | 07F | AM | 10082018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | bush | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9730454295997 40.7702909454392) | ||||
1592 | 1592 | -73.9575517912392 | 40.788915826819206 | 31H-PM-1008-05 | 31H | PM | 10082018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9575517912392 40.7889158268192) | |||||
1711 | 1711 | -73.975836799137 | 40.7691593428471 | 4E-PM-1008-05 | 04E | PM | 10082018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.975836799137 40.769159342847104) | |||||
1839 | 1839 | -73.9655925527354 | 40.7760049171097 | 15H-PM-1008-05 | 15H | PM | 10082018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | lawn | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9655925527354 40.7760049171097) | ||||
1883 | 1883 | -73.9568108465086 | 40.7971727026108 | 39D-AM-1008-05 | 39D | AM | 10082018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.95681084650862 40.7971727026108) | |||||
1923 | 1923 | -73.9743795190073 | 40.7692030411004 | 5E-AM-1008-05 | 05E | AM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9743795190073 40.7692030411004) | ||||
1940 | 1940 | -73.9696445614055 | 40.779148620362704 | 17D-AM-1008-05 | 17D | AM | 10082018 | 5 | Juvenile | Gray | Gray+ | Above Ground | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9696445614055 40.7791486203627) | |||||
2515 | 2515 | -73.9693338657183 | 40.775705588453796 | 13F-PM-1008-05 | 13F | PM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | tree trunk | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9693338657183 40.77570558845381) | |||
2552 | 2552 | -73.97249477106979 | 40.7696619340886 | 6G-AM-1008-05 | 06G | AM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 30 | branch | 0 | 0 | 1 | 0 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9724947710698 40.7696619340886) | |||
2917 | 2917 | -73.9770313887741 | 40.7724869252099 | 7B-AM-1008-05 | 07B | AM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9770313887741 40.772486925209904) | ||||||
2925 | 2925 | -73.96721526968341 | 40.782387458182896 | 21D-AM-1008-05 | 21D | AM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9672152696834 40.7823874581829) |
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 );