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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2596 | 2596 | -73.9729786570879 | 40.7778238570396 | 14B-AM-1007-01 | 14B | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | tail straight | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.97297865708792 40.7778238570396) | |||
2621 | 2621 | -73.9596904740342 | 40.7897200025671 | 31E-AM-1014-01 | 31E | AM | 10142018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9596904740342 40.7897200025671) | |||||
2647 | 2647 | -73.954499539822 | 40.7949716693686 | 38F-AM-1018-01 | 38F | AM | 10182018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.954499539822 40.7949716693686) | ||||
2673 | 2673 | -73.9768867959365 | 40.7734803954589 | 8B-PM-1012-01 | 08B | PM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9768867959365 40.7734803954589) | ||||
2678 | 2678 | -73.95629468736941 | 40.7938593012595 | 36F-AM-1017-01 | 36F | AM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (dog) | POINT (-73.9562946873694 40.7938593012595) | ||||
2682 | 2682 | -73.97110012783891 | 40.778746609584104 | 15C-PM-1017-01 | 15C | PM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9711001278389 40.7787466095841) | ||||
2729 | 2729 | -73.9615429203441 | 40.7907417648701 | 31D-AM-1014-01 | 31D | AM | 10142018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | Ground then up tree | 0 | 0 | 1 | 0 | 0 | chased by a doggo | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | runs from (dogs!) | POINT (-73.9615429203441 40.7907417648701) | ||
2794 | 2794 | -73.9712187890707 | 40.7750640173134 | 12E-PM-1018-01 | 12E | PM | 10182018 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9712187890707 40.7750640173134) | ||||
2888 | 2888 | -73.955258162768 | 40.7958147673603 | 39E-AM-1018-01 | 39E | AM | 10182018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | standing still | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.955258162768 40.7958147673603) | |||
2929 | 2929 | -73.953123365424 | 40.7941113777459 | 38H-PM-1012-01 | 38H | PM | 10122018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.953123365424 40.7941113777459) | |||||
2975 | 2975 | -73.959412243507 | 40.7917871123534 | 33E-AM-1014-01 | 33E | AM | 10142018 | 1 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.959412243507 40.7917871123534) | |||
2997 | 2997 | -73.96197353854829 | 40.7944667974974 | 35A-PM-1013-01 | 35A | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9619735385483 40.7944667974974) | ||||
3010 | 3010 | -73.9580906814132 | 40.7948404060484 | 37D-PM-1014-01 | 37D | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | eyes from a safe distance | POINT (-73.9580906814132 40.7948404060484) | |||
27 | 27 | -73.9670628558161 | 40.7734991420941 | 12I-AM-1013-01 | 12I | AM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | on tree roots | 0 | 0 | 0 | 0 | 0 | sitting | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9670628558161 40.77349914209411) | ||
109 | 109 | -73.967097592707 | 40.785411934253794 | 24B-AM-1013-01 | 24B | AM | 10132018 | 1 | Gray | Gray+ | Above Ground | 50 | 1 | 0 | 0 | 1 | 0 | took nut to bury | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.967097592707 40.7854119342538) | |||||
342 | 342 | -73.9605966636226 | 40.788984910863704 | 30E-AM-1008-01 | 30E | AM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | scurried into bushes when jogger ran by | POINT (-73.9605966636226 40.7889849108637) | |||
403 | 403 | -73.9597470659927 | 40.797321593541604 | 38A-PM-1013-01 | 38A | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9597470659927 40.7973215935416) | ||||
417 | 417 | -73.9639888092327 | 40.791449395909 | 31A-AM-1010-01 | 31A | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9639888092327 40.791449395909005) | |||||
534 | 534 | -73.9650499507011 | 40.7908191782173 | 30A-AM-1010-01 | 30A | AM | 10102018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9650499507011 40.7908191782173) | ||||
641 | 641 | -73.97190362174459 | 40.7803588122409 | 17A-AM-1017-01 | 17A | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | ground & tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9719036217446 40.7803588122409) | |||
720 | 720 | -73.9669814346326 | 40.780390919948 | 19E-PM-1018-01 | 19E | PM | 10182018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9669814346326 40.780390919948) | ||||
837 | 837 | -73.9557172336815 | 40.79211256577221 | 35G-PM-1006-01 | 35G | PM | 10062018 | 1 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9557172336815 40.7921125657722) | ||||
929 | 929 | -73.97386112577159 | 40.773724677958704 | 10D-AM-1008-01 | 10D | AM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9738611257716 40.7737246779587) | ||||
1118 | 1118 | -73.9719460335398 | 40.7810508156287 | 18A-AM-1012-01 | 18A | AM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | White tail | Above Ground | 3 | tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9719460335398 40.7810508156287) | ||
1183 | 1183 | -73.9525699067954 | 40.7937125788106 | 38I-PM-1014-01 | 38I | PM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | on the lawn East of the fountain | 0 | 0 | 0 | 0 | 0 | scampering thru the grass! | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9525699067954 40.7937125788106) | ||
1303 | 1303 | -73.9603302382958 | 40.7910100435196 | 32D-PM-1006-01 | 32D | PM | 10062018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9603302382958 40.7910100435196) | ||||
1315 | 1315 | -73.9595955824812 | 40.793304794353396 | 34D-PM-1007-01 | 34D | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9595955824812 40.7933047943534) | ||||
1357 | 1357 | -73.96313500206341 | 40.791907210332 | 32B-PM-1010-01 | 32B | PM | 10102018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 25 | in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9631350020634 40.791907210332) | ||||
1825 | 1825 | -73.9624209799704 | 40.79102009727521 | 31C-PM-1010-01 | 31C | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9624209799704 40.7910200972752) | ||||
1840 | 1840 | -73.9733222531339 | 40.764997537154606 | 1I-PM-1012-01 | 01I | PM | 10122018 | 1 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9733222531339 40.7649975371546) | |||
1866 | 1866 | -73.96360276644391 | 40.790075966587 | 30B-PM-1019-01 | 30B | PM | 10192018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9636027664439 40.790075966587) | ||||
1896 | 1896 | -73.973998077367 | 40.773902913391105 | 10C-PM-1013-01 | 10C | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.973998077367 40.7739029133911) | ||||
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) | |||
1939 | 1939 | -73.9540151828782 | 40.7920066170587 | 35H-AM-1013-01 | 35H | AM | 10132018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | Climbing up tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9540151828782 40.7920066170587) | |||
2199 | 2199 | -73.9677500862135 | 40.7726060987821 | 11I-AM-1012-01 | 11I | AM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9677500862135 40.7726060987821) | ||||
2244 | 2244 | -73.9509628195532 | 40.797777567417796 | 42H-PM-1014-01 | 42H | PM | 10142018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9509628195532 40.7977775674178) | ||||
2278 | 2278 | -73.96453903109901 | 40.78099163100121 | 20G-PM-1013-01 | 20G | PM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.964539031099 40.7809916310012) | ||||
2342 | 2342 | -73.9533645762606 | 40.7983709215535 | 42F-AM-1019-01 | 42F | AM | 10192018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | runs from (me) | POINT (-73.9533645762606 40.7983709215535) | |||
2389 | 2389 | -73.9801343393329 | 40.769151245340204 | 3A-AM-1012-01 | 03A | AM | 10122018 | 1 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9801343393329 40.7691512453402) | |||
2406 | 2406 | -73.9668964315686 | 40.777757799088604 | 16G-AM-1010-01 | 16G | AM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9668964315686 40.7777577990886) | ||||
2495 | 2495 | -73.9621253644004 | 40.7912082086879 | 31C-AM-1017-01 | 31C | AM | 10172018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 8 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9621253644004 40.7912082086879) | ||||
2522 | 2522 | -73.9658747245917 | 40.77540337375321 | 14I-PM-1018-01 | 14I | PM | 10182018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Fallen branch | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9658747245917 40.7754033737532) | ||||
2757 | 2757 | -73.96714191194559 | 40.77586024868621 | 14G-AM-1012-01 | 14G | AM | 10122018 | 1 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9671419119456 40.7758602486862) | ||||
2849 | 2849 | -73.9709912560997 | 40.77589655951979 | 13D-AM-1014-01 | 13D | AM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9709912560997 40.7758965595198) | ||||
2874 | 2874 | -73.9597453664295 | 40.7891382153733 | 30F-PM-1007-01 | 30F | PM | 10072018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Above Ground | 1 | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9597453664295 40.7891382153733) | |||
2924 | 2924 | -73.9727230609785 | 40.7795341640894 | 16A-PM-1019-01 | 16A | PM | 10192018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9727230609785 40.7795341640894) | |||||
2969 | 2969 | -73.9654409838612 | 40.7901338748522 | 29A-AM-1013-01 | 29A | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | climbed tree (oak) | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9654409838612 40.7901338748522) |
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 );