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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1159 | 1159 | -73.9682129261841 | 40.77542323581179 | 14G-AM-1012-03 | 14G | AM | 10122018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9682129261841 40.7754232358118) | ||||
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) | ||||
951 | 951 | -73.97179185488301 | 40.78029717297839 | 17B-PM-1012-01 | 17B | PM | 10122018 | 1 | Adult | Gray | Gray+ | Above Ground | 2 | climbed a fence | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.971791854883 40.7802971729784) | ||||
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) | ||
760 | 760 | -73.97182341595571 | 40.7810842503715 | 18A-AM-1012-02 | 18A | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | 0 | 0 | 1 | 1 | 1 | burying | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9718234159557 40.7810842503715) | |||
1219 | 1219 | -73.96618922004741 | 40.7836798072777 | 22D-PM-1012-06 | 22D | PM | 10122018 | 6 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9661892200474 40.7836798072777) | ||||
762 | 762 | -73.96792913479558 | 40.7846973096665 | 23B-PM-1012-02 | 23B | PM | 10122018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 2/3 were chasing each other | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9679291347956 40.7846973096665) | |||
1090 | 1090 | -73.967767372181 | 40.784702631615 | 23B-PM-1012-07 | 23B | PM | 10122018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.967767372181 40.784702631615) | ||||
2390 | 2390 | -73.9680741975294 | 40.7847036778165 | 23B-PM-1012-04 | 23B | PM | 10122018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 20 | 0 | 0 | 0 | 0 | 0 | watching me - didn't move | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9680741975294 40.7847036778165) | |||
2328 | 2328 | -73.9678620840741 | 40.784719027304 | 23B-PM-1012-03 | 23B | PM | 10122018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 2/3 were chasing each other | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.96786208407411 40.784719027304) | |||
667 | 667 | -73.9624538733037 | 40.7883829851518 | 28D-AM-1012-04 | 28D | AM | 10122018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9624538733037 40.7883829851518) | ||||
2742 | 2742 | -73.96280415779341 | 40.7884180156055 | 28D-AM-1012-06 | 28D | AM | 10122018 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 5 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9628041577934 40.78841801560551) | ||||
325 | 325 | -73.96309908232429 | 40.788576428401605 | 28D-AM-1012-02 | 28D | AM | 10122018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9630990823243 40.7885764284016) | |||||
2051 | 2051 | -73.9544808708211 | 40.7906575852286 | 34I-AM-1012-02 | 34I | AM | 10122018 | 2 | Adult | Gray | White | Gray+White | Short tail | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | hiding | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9544808708211 40.7906575852286) | ||
1721 | 1721 | -73.95873307074629 | 40.7907682009641 | 32F-AM-1012-02 | 32F | AM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray patches on back legs | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | curious about me | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | POINT (-73.9587330707463 40.7907682009641) | ||
324 | 324 | -73.9587879699956 | 40.7908135158551 | 32F-AM-1012-01 | 32F | AM | 10122018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | made a back-door escape from dog off-leash | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9587879699956 40.7908135158551) | ||||
2405 | 2405 | -73.9588361742943 | 40.791115225155 | 33E-PM-1012-02 | 33E | PM | 10122018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9588361742943 40.791115225155) | ||||
1462 | 1462 | -73.9584064203778 | 40.7912272455454 | 33F-PM-1012-04 | 33F | PM | 10122018 | 4 | 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.9584064203778 40.7912272455454) | ||||
383 | 383 | -73.9588358879692 | 40.7912631913057 | 33E-PM-1012-01 | 33E | PM | 10122018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9588358879692 40.7912631913057) | ||||
2176 | 2176 | -73.9583201789615 | 40.7913938722521 | 33F-PM-1012-05 | 33F | PM | 10122018 | 5 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | POINT (-73.95832017896151 40.7913938722521) | ||||
1232 | 1232 | -73.9589254878322 | 40.7914467650712 | 33E-PM-1012-09 | 33E | PM | 10122018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9589254878322 40.7914467650712) | |||||
2090 | 2090 | -73.9569759970802 | 40.7931497452294 | 35F-PM-1012-03 | 35F | PM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 7 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9569759970802 40.79314974522941) | ||||
706 | 706 | -73.95701325709341 | 40.793201415908705 | 35F-PM-1012-01 | 35F | PM | 10122018 | 1 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | POINT (-73.9570132570934 40.7932014159087) | ||||
1231 | 1231 | -73.9555583724966 | 40.7932879745739 | 36F-PM-1012-07 | 36F | PM | 10122018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9555583724966 40.7932879745739) | ||||
205 | 205 | -73.9564724104048 | 40.7936055508162 | 36F-PM-1012-04 | 36F | PM | 10122018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9564724104048 40.7936055508162) | ||||
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) | |||||
963 | 963 | -73.9621066718851 | 40.7942427079733 | 34A-AM-1012-03 | 34A | AM | 10122018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9621066718851 40.7942427079733) | |||||
2381 | 2381 | -73.95884149804891 | 40.7953525481367 | 37C-AM-1012-01 | 37C | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | caching | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9588414980489 40.7953525481367) | |||
1283 | 1283 | -73.9566785136491 | 40.7963368332834 | 39D-PM-1012-02 | 39D | PM | 10122018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9566785136491 40.7963368332834) | ||||
1461 | 1461 | -73.95692690934399 | 40.7965323262487 | 39D-PM-1012-03 | 39D | PM | 10122018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.956926909344 40.7965323262487) | ||||
1098 | 1098 | -73.96049542761291 | 40.7965682182001 | 37A-AM-1012-01 | 37A | AM | 10122018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Drawing included on tally sheet | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | scanning (drawing included) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9604954276129 40.7965682182001) | ||
87 | 87 | -73.95414534658171 | 40.798216222376396 | 42E-PM-1012-06 | 42E | PM | 10122018 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9541453465817 40.79821622237641) | ||||
1064 | 1064 | -73.9540257319561 | 40.798408619116 | 42E-PM-1012-02 | 42E | PM | 10122018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9540257319561 40.798408619116) |
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 );