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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
741 | 741 | -73.9790214253443 | 40.7686791169776 | 3B-PM-1007-10 | 03B | PM | 10072018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | hopping | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9790214253443 40.7686791169776) | |||
1122 | 1122 | -73.9728700359494 | 40.7659842666881 | 3H-PM-1014-05 | 03H | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9728700359494 40.7659842666881) | ||||
2953 | 2953 | -73.9585862117341 | 40.7986549251083 | 40A-PM-1014-05 | 40A | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | eating (in a tree cage thing) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9585862117341 40.7986549251083) | |||
2659 | 2659 | -73.95536034380208 | 40.7985282963244 | 41D-PM-1014-05 | 41D | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 12 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9553603438021 40.7985282963244) | ||||
2277 | 2277 | -73.95385121459 | 40.7981257651433 | 42E-PM-1012-04 | 42E | PM | 10122018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95385121459 40.7981257651433) | ||||
2885 | 2885 | -73.9530811255728 | 40.7983069118579 | 42F-AM-1019-02 | 42F | AM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9530811255728 40.79830691185791) | ||||
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) | ||||
437 | 437 | -73.9793952066038 | 40.7707837657859 | 4A-PM-1007-03 | 04A | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | by rock | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9793952066038 40.77078376578591) | |||
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) | ||||
756 | 756 | -73.9773079154219 | 40.7696506688861 | 4C-AM-1006-02 | 04C | AM | 10062018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9773079154219 40.7696506688861) | ||||
1709 | 1709 | -73.9771696835698 | 40.76970111004871 | 4C-AM-1006-04 | 04C | AM | 10062018 | 4 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9771696835698 40.7697011100487) | ||||
2854 | 2854 | -73.9772908667333 | 40.7697207404744 | 4C-AM-1006-05 | 04C | AM | 10062018 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 20 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9772908667333 40.7697207404744) | ||||
1827 | 1827 | -73.97797608743551 | 40.769823093658296 | 4C-PM-1010-16 | 04C | PM | 10102018 | 16 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9779760874355 40.7698230936583) | ||||
2587 | 2587 | -73.97899712868441 | 40.7707024146365 | 5A-PM-1010-04 | 05A | PM | 10102018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9789971286844 40.7707024146365) | ||||
199 | 199 | -73.97716146866159 | 40.770967798324705 | 5C-AM-1006-02 | 05C | AM | 10062018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9771614686616 40.7709677983247) | ||||
1158 | 1158 | -73.97638947595429 | 40.7705523372364 | 5C-PM-1010-12 | 05C | PM | 10102018 | 12 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9763894759543 40.7705523372364) | ||||
2189 | 2189 | -73.9761776424664 | 40.7695941843825 | 5D-PM-1018-07 | 05D | PM | 10182018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9761776424664 40.7695941843825) | ||||
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) | |||
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) | ||||
895 | 895 | -73.97868986562791 | 40.7720833097065 | 6A-AM-1006-08 | 06A | AM | 10062018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9786898656279 40.77208330970651) | ||||
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) | ||||
2946 | 2946 | -73.974515099169 | 40.770065079988605 | 6E-PM-1010-03 | 06E | PM | 10102018 | 3 | Adult | Cinnamon | White | Cinnamon+White | white back legs | Ground Plane | FALSE | small open area but w/ 7 large oak trees | 0 | 1 | 0 | 1 | 0 | chasing #4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.974515099169 40.770065079988605) | |
1282 | 1282 | -73.974451175321 | 40.770129463526395 | 6E-PM-1010-04 | 06E | PM | 10102018 | 4 | Adult | Cinnamon | White | Cinnamon+White | white back legs | Ground Plane | FALSE | small open area but w/ 7 large oak trees | 0 | 1 | 0 | 1 | 0 | chasing #3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.974451175321 40.7701294635264) | |
1129 | 1129 | -73.97449068326779 | 40.7699948746776 | 6E-PM-1010-05 | 06E | PM | 10102018 | 5 | Adult | Cinnamon | White | Cinnamon+White | white back legs | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | could this squirrel be eating a white mushroom? | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744906832678 40.76999487467761) | ||
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) | |||
1233 | 1233 | -73.9722281263634 | 40.770408328801295 | 7G-AM-1010-06 | 07G | AM | 10102018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9722281263634 40.7704083288013) | ||||
1814 | 1814 | -73.97223594012421 | 40.7702891474555 | 7G-AM-1010-07 | 07G | AM | 10102018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9722359401242 40.7702891474555) | ||||
1085 | 1085 | -73.9722265046794 | 40.7700916895929 | 7G-PM-1018-02 | 07G | PM | 10182018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9722265046794 40.7700916895929) | ||||
643 | 643 | -73.976730206737 | 40.773709213913996 | 8A-PM-1014-01 | 08A | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (goes up a tree) | POINT (-73.976730206737 40.773709213914) | |||
2317 | 2317 | -73.97673696861709 | 40.7735074437085 | 8B-PM-1012-05 | 08B | PM | 10122018 | 5 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9767369686171 40.7735074437085) | ||||
1836 | 1836 | -73.9751056714758 | 40.7732060035215 | 8C-PM-1013-03 | 08C | PM | 10132018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9751056714758 40.7732060035215) | ||||
761 | 761 | -73.975062146111 | 40.7723417173451 | 8C-PM-1013-07 | 08C | PM | 10132018 | 7 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.975062146111 40.7723417173451) | |||||
382 | 382 | -73.9735946835545 | 40.7724155751282 | 8E-PM-1008-01 | 08E | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | by tree trunk base | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | eating food being thrown at it by a mom & baby | POINT (-73.9735946835545 40.7724155751282) | ||
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) | ||
1802 | 1802 | -73.9736418085696 | 40.7716931127716 | 8E-PM-1008-04 | 08E | PM | 10082018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | in grass by a grove of tall maples | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | there's a family playing soccer | POINT (-73.9736418085696 40.7716931127716) | ||
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) | |||
2551 | 2551 | -73.970138810251 | 40.770579297644 | 8H-PM-1014-02 | 08H | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | froze & watched me,then went back to eating | POINT (-73.970138810251 40.770579297644) | |||
841 | 841 | -73.97469338525721 | 40.773313866931 | 9C-PM-1006-05 | 09C | PM | 10062018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | w/ dog | POINT (-73.9746933852572 40.773313866931) | |||
1439 | 1439 | -73.9729645190377 | 40.7723310150843 | 9E-AM-1008-02 | 09E | AM | 10082018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9729645190377 40.7723310150843) | ||||
2355 | 2355 | -73.9728654439465 | 40.7724853142211 | 9E-AM-1008-04 | 09E | AM | 10082018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9728654439465 40.7724853142211) | ||||
2926 | 2926 | -73.9714653576023 | 40.77174001395021 | 9F-AM-1013-03 | 09F | AM | 10132018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9714653576023 40.7717400139502) | ||||
1826 | 1826 | -73.9707542189896 | 40.7717032986885 | 9G-PM-1007-04 | 09G | PM | 10072018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9707542189896 40.77170329868851) | ||||
574 | 574 | -73.97063600052749 | 40.7717074044466 | 9G-PM-1007-05 | 09G | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9706360005275 40.7717074044466) | ||||
921 | 921 | -73.9698959071826 | 40.7716763799299 | 9H-AM-1006-05 | 09H | AM | 10062018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9698959071826 40.7716763799299) |
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 );