This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Eating, Kuks, Tail flags
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3 | 3 | -73.9768311751004 | 40.766717807255795 | 2E-AM-1010-03 | 02E | AM | 10102018 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 4 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9768311751004 40.76671780725581) | |||||
695 | 695 | -73.96850806398729 | 40.774530979415495 | 13G-PM-1008-03 | 13G | PM | 10082018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | maple tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9685080639873 40.77453097941551) | |||
937 | 937 | -73.97063234587691 | 40.7713196034265 | 9G-PM-1007-03 | 09G | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9706323458769 40.771319603426505) | ||||
1145 | 1145 | -73.9611446263364 | 40.7911003407299 | 32D-AM-1013-03 | 32D | AM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9611446263364 40.7911003407299) | ||||
1253 | 1253 | -73.9527227282134 | 40.7935061484064 | 37I-AM-1010-03 | 37I | AM | 10102018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9527227282134 40.7935061484064) | |||
16 | 16 | -73.97225001968441 | 40.7742879599026 | 11D-AM-1010-03 | 11D | AM | 10102018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 30 | 0 | 0 | 1 | 0 | 0 | grooming | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9722500196844 40.7742879599026) | |||
201 | 201 | -73.9598015842806 | 40.7973522744237 | 38A-PM-1013-03 | 38A | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9598015842806 40.7973522744237) | ||||
207 | 207 | -73.9770824412252 | 40.770996130945704 | 5C-AM-1006-03 | 05C | AM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97708244122522 40.7709961309457) | ||||
279 | 279 | -73.9550082056509 | 40.7894521543449 | 33I-AM-1008-03 | 33I | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 2 | 98th @ edge of park | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9550082056509 40.7894521543449) | ||||
347 | 347 | -73.96116961447841 | 40.7816692895155 | 22I-AM-1007-03 | 22I | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9611696144784 40.7816692895155) | |||||
414 | 414 | -73.9721899838568 | 40.776151904565104 | 13C-AM-1010-03 | 13C | AM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9721899838568 40.7761519045651) | |||||
483 | 483 | -73.9789952029637 | 40.7697758333099 | 4B-AM-1010-03 | 04B | AM | 10102018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9789952029637 40.7697758333099) | ||||
530 | 530 | -73.9696360756453 | 40.7786545659072 | 16D-PM-1010-03 | 16D | PM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 18 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9696360756453 40.7786545659072) | |||||
569 | 569 | -73.9709040623777 | 40.7701163892686 | 7H-PM-1006-03 | 07H | PM | 10062018 | 3 | Adult | Gray | Gray+ | Above Ground | 8 | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9709040623777 40.7701163892686) | ||||
649 | 649 | -73.9554891003543 | 40.7968774599654 | 40E-AM-1014-03 | 40E | AM | 10142018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9554891003543 40.79687745996541) | ||||
757 | 757 | -73.9783185278595 | 40.7724861675504 | 7A-AM-1006-03 | 07A | AM | 10062018 | 3 | Adult | Gray | Gray+ | 3/4 length tail, hair loss | Above Ground | 20 | in trees, then to ground | 1 | 0 | 1 | 0 | 0 | jumping | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9783185278595 40.7724861675504) | ||
1301 | 1301 | -73.95521466657141 | 40.7892909102377 | 32I-PM-1007-03 | 32I | PM | 10072018 | 3 | Adult | Gray | Gray+ | small adult | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9552146665714 40.7892909102377) | ||||
1425 | 1425 | -73.95862528758559 | 40.7852027586217 | 27I-AM-1007-03 | 27I | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | had .5 of a tail | Above Ground | 20 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9586252875856 40.7852027586217) | |||
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) | |||||
1610 | 1610 | -73.9607056611532 | 40.788978610387105 | 30E-AM-1008-03 | 30E | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 6 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9607056611532 40.7889786103871) | |||||
1627 | 1627 | -73.9594391759139 | 40.784115697669 | 26I-PM-1010-03 | 26I | PM | 10102018 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | black in tail | Above Ground | 15 | tree | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9594391759139 40.784115697669) | ||
1701 | 1701 | -73.9701634768603 | 40.777869143321794 | 15D-AM-1007-03 | 15D | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 10 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9701634768603 40.7778691433218) | |||||
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) | ||||
1747 | 1747 | -73.96657637976071 | 40.7761316400012 | 15H-AM-1013-03 | 15H | AM | 10132018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9665763797607 40.7761316400012) | ||||
1796 | 1796 | -73.9765355395622 | 40.7735653237366 | 8B-AM-1007-03 | 08B | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97653553956222 40.7735653237366) | |||||
1851 | 1851 | -73.9623621412501 | 40.7814673556041 | 22H-PM-1007-03 | 22H | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 4 | chased squirrel #2 away | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9623621412501 40.7814673556041) | |||
1874 | 1874 | -73.96573273328491 | 40.7747554568985 | 14I-PM-1018-03 | 14I | PM | 10182018 | 3 | Juvenile | Gray | Black | Gray+Black | Above Ground | 4 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9657327332849 40.7747554568985) | ||||
1988 | 1988 | -73.957138794884 | 40.7985389822719 | 40C-AM-1017-03 | 40C | AM | 10172018 | 3 | Adult | Gray | White | Gray+White | 1 | 1 | 1 | 0 | 0 | chasing (#4),digging | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.957138794884 40.7985389822719) | |||||
2069 | 2069 | -73.9538377039825 | 40.798060533496106 | 42E-PM-1012-03 | 42E | PM | 10122018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 20 | in tree | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9538377039825 40.7980605334961) | |||
2071 | 2071 | -73.96676944398949 | 40.7779501809095 | 17G-PM-1017-03 | 17G | PM | 10172018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | tree & ground | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9667694439895 40.7779501809095) | |||
2259 | 2259 | -73.975565603566 | 40.7738462518304 | 9B-AM-1010-03 | 09B | AM | 10102018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.975565603566 40.7738462518304) | ||||
2396 | 2396 | -73.9704339422613 | 40.77401495296439 | 11F-PM-1006-03 | 11F | PM | 10062018 | 3 | Adult | Gray | Gray+ | Above Ground | 4 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9704339422613 40.7740149529644) | |||||
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) | ||||
2471 | 2471 | -73.964274290774 | 40.779531955602295 | 19H-AM-1010-03 | 19H | AM | 10102018 | 3 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ran from human w/ dog | POINT (-73.964274290774 40.7795319556023) | |||
2485 | 2485 | -73.9584950620879 | 40.790277071064295 | 32F-PM-1008-03 | 32F | PM | 10082018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9584950620879 40.7902770710643) | ||||
2598 | 2598 | -73.976658503418 | 40.768686845691704 | 4D-AM-1012-03 | 04D | AM | 10122018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.976658503418 40.7686868456917) | |||||
2599 | 2599 | -73.96898934126929 | 40.785308737683 | 23A-AM-1018-03 | 23A | AM | 10182018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | Tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9689893412693 40.785308737683) | |||
2747 | 2747 | -73.971314838366 | 40.774951285041 | 12E-AM-1017-03 | 12E | AM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.971314838366 40.774951285041) | ||||
2960 | 2960 | -73.96252481451499 | 40.7810022923615 | 21H-PM-1018-03 | 21H | PM | 10182018 | 3 | Adult | Gray | Gray+ | Above Ground | 25 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.962524814515 40.7810022923615) | |||||
3013 | 3013 | -73.964661337306 | 40.7769785494935 | 17I-AM-1014-03 | 17I | AM | 10142018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Cinnamon face | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | climbing (dog barked & it ran up tree) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.964661337306 40.7769785494935) |
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 );