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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
699 | 699 | -73.95046935442251 | 40.797225436004 | 42H-AM-1019-01 | 42H | AM | 10192018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9504693544225 40.797225436004) | ||||
736 | 736 | -73.9660110060416 | 40.780999009859705 | 20F-AM-1014-01 | 20F | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9660110060416 40.7809990098597) | ||||
845 | 845 | -73.9582850206205 | 40.7978975855555 | 39B-PM-1014-01 | 39B | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | White belly | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9582850206205 40.7978975855555) | |||
996 | 996 | -73.9703149829421 | 40.778558363032296 | 16D-AM-1007-01 | 16D | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9703149829421 40.7785583630323) | ||||
1107 | 1107 | -73.95307395621309 | 40.7932034409546 | 37H-PM-1006-01 | 37H | PM | 10062018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | from voice | POINT (-73.95307395621312 40.7932034409546) | |||
1241 | 1241 | -73.9651817987035 | 40.781908283833396 | 21E-AM-1017-01 | 21E | AM | 10172018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | Climbs small tree | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | walks from | POINT (-73.9651817987035 40.7819082838334) | ||
1423 | 1423 | -73.96002043282009 | 40.782877291358 | 24I-AM-1019-01 | 24I | AM | 10192018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9600204328201 40.782877291358) | ||||
1430 | 1430 | -73.970804709441 | 40.7758611111219 | 13E-PM-1008-01 | 13E | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.970804709441 40.7758611111219) | ||||
1478 | 1478 | -73.9676370985166 | 40.7869888639434 | 25A-AM-1013-01 | 25A | AM | 10132018 | 1 | Gray | White | Gray+White | White Belly | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | staring at me | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96763709851662 40.7869888639434) | |||
1545 | 1545 | -73.9669207809051 | 40.779276785012605 | 18F-PM-1008-01 | 18F | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9669207809051 40.7792767850126) | ||||
1650 | 1650 | -73.97624942397191 | 40.775017530671605 | 10A-AM-1006-01 | 10A | AM | 10062018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | near Strawberry Fields | 0 | 0 | 0 | 1 | 0 | eating (a peanut) | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9762494239719 40.7750175306716) | ||
1667 | 1667 | -73.96459890035891 | 40.778215745915496 | 18H-PM-1014-01 | 18H | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9645989003589 40.7782157459155) | ||||
1707 | 1707 | -73.96045242711669 | 40.7956624328733 | 36B-AM-1013-01 | 36B | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9604524271167 40.7956624328733) | ||||
1911 | 1911 | -73.9528937660465 | 40.7922919074537 | 36I-AM-1017-01 | 36I | AM | 10172018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | runs from (me!)—from a pretty big distance | POINT (-73.9528937660465 40.7922919074537) | |||
1983 | 1983 | -73.97841448676391 | 40.771817766751106 | 6A-AM-1006-01 | 06A | AM | 10062018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9784144867639 40.7718177667511) | ||||
2005 | 2005 | -73.9755259087781 | 40.770725612418104 | 6D-AM-1008-01 | 06D | AM | 10082018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9755259087781 40.7707256124181) | ||||
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) | ||||
2125 | 2125 | -73.9687933229572 | 40.7788600242549 | 17E-PM-1018-01 | 17E | PM | 10182018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9687933229572 40.7788600242549) | ||||
2221 | 2221 | -73.9771847728747 | 40.769597116498105 | 4C-AM-1006-01 | 04C | AM | 10062018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9771847728747 40.7695971164981) | ||||
2497 | 2497 | -73.9622050752008 | 40.7886373772305 | 29D-PM-1010-01 | 29D | PM | 10102018 | 1 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9622050752008 40.7886373772305) | ||||
2526 | 2526 | -73.96464954504991 | 40.7791203699027 | 19H-PM-1008-01 | 19H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9646495450499 40.7791203699027) | ||||
2545 | 2545 | -73.9617594316752 | 40.7946803725236 | 35A-AM-1014-01 | 35A | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9617594316752 40.7946803725236) | ||||
2706 | 2706 | -73.9745141185576 | 40.76914797812071 | 5E-AM-1008-01 | 05E | AM | 10082018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 2 | on a checker table | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9745141185576 40.7691479781207) | |||
2764 | 2764 | -73.9692660977515 | 40.7830532310766 | 21B-PM-1017-01 | 21B | PM | 10172018 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | paused to look at me | POINT (-73.9692660977515 40.7830532310766) | |||
2843 | 2843 | -73.97147871782009 | 40.779804947074496 | 16B-PM-1017-01 | 16B | PM | 10172018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9714787178201 40.7798049470745) |
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 );