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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1018 | 1018 | -73.96953055553921 | 40.7757541971012 | 13F-PM-1008-03 | 13F | PM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 15 | tree | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9695305555392 40.7757541971012) | ||||
2006 | 2006 | -73.9695641121727 | 40.7769562886685 | 14E-AM-1008-03 | 14E | AM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | walking | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | unaware of | POINT (-73.9695641121727 40.7769562886685) | |||
2151 | 2151 | -73.96971787697879 | 40.77915441024221 | 17D-AM-1008-03 | 17D | AM | 10082018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.96971787697882 40.7791544102422) | ||||
1028 | 1028 | -73.97070123456609 | 40.7758938984066 | 13E-PM-1008-03 | 13E | PM | 10082018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | hanging upside down to get a nut | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9707012345661 40.7758938984066) | |||
1981 | 1981 | -73.972154069981 | 40.769012800972206 | 6G-AM-1008-03 | 06G | AM | 10082018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | grass | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.972154069981 40.7690128009722) | |||
2452 | 2452 | -73.9727323797981 | 40.766903546395504 | 3H-AM-1008-03 | 03H | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 40 | building nest | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9727323797981 40.7669035463955) | ||||
1664 | 1664 | -73.97291429122029 | 40.772409114667795 | 9E-AM-1008-03 | 09E | AM | 10082018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9729142912203 40.7724091146678) | ||||
2393 | 2393 | -73.9729190572117 | 40.770018150904995 | 6F-PM-1008-03 | 06F | PM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 50 | top of tree | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9729190572117 40.770018150905) | ||||
1116 | 1116 | -73.9729847109778 | 40.774070904960205 | 10D-AM-1008-03 | 10D | AM | 10082018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9729847109778 40.7740709049602) | ||||
1569 | 1569 | -73.973047824163 | 40.7700873791211 | 7F-AM-1008-03 | 07F | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.973047824163 40.7700873791211) | |||||
2253 | 2253 | -73.973394428186 | 40.7722933513053 | 8E-PM-1008-03 | 08E | PM | 10082018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | in between 2 trees | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | also being lured by mom & baby w/ food | POINT (-73.973394428186 40.7722933513053) | ||
1834 | 1834 | -73.97390388321558 | 40.7730354890554 | 9D-AM-1008-03 | 09D | AM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9739038832156 40.7730354890554) | |||||
716 | 716 | -73.9745427984089 | 40.7691848214817 | 5E-AM-1008-03 | 05E | AM | 10082018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9745427984089 40.7691848214817) | ||||
1715 | 1715 | -73.97457091090558 | 40.7672225695415 | 3G-AM-1008-03 | 03G | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 40 | 1 | 0 | 1 | 0 | 0 | in tree | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9745709109056 40.7672225695415) | ||||
2334 | 2334 | -73.97549229705109 | 40.7707686392991 | 6D-AM-1008-03 | 06D | AM | 10082018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9754922970511 40.7707686392991) | |||||
645 | 645 | -73.9758152322587 | 40.76923774014671 | 4E-PM-1008-03 | 04E | PM | 10082018 | 3 | Adult | Gray | Gray+ | 0 | 1 | 0 | 0 | 0 | chasing #4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9758152322587 40.7692377401467) | ||||||
219 | 219 | -73.9761209945419 | 40.768240452890296 | 3E-PM-1008-03 | 03E | PM | 10082018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9761209945419 40.7682404528903) | ||||
925 | 925 | -73.9763116425885 | 40.768883957648704 | 4D-PM-1008-03 | 04D | PM | 10082018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ran two feet up tree trunk | POINT (-73.9763116425885 40.7688839576487) | |||
811 | 811 | -73.9771695272048 | 40.772427727626294 | 7B-AM-1008-03 | 07B | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9771695272048 40.7724277276263) | |||||
2871 | 2871 | -73.9777124331985 | 40.7704051056666 | 5B-AM-1008-03 | 05B | AM | 10082018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9777124331985 40.7704051056666) |
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 );