Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare_Squirrel_Number, Highlight_Fur_Color, Combination_of_Primary_and_Highlight_Color, Color_notes, Location, Above_Ground_Sighter_Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail_flags, Tail_twitches, Approaches, Indifferent, Runs_from, Other_Interactions, Zip_Codes, Community_Districts, City_Council_Districts
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 | Latlong | Zip_Codes | Community_Districts | Borough_Boundaries | City_Council_Districts | Police_Precincts |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
185 | 185 | -73.9594986107981 | 40.7840083040604 | 25I-AM-1012-03 | 25I | AM | 1012 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 8.0 | on turn, see map | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9594986107981 40.7840083040604) | 19 | 4 | 19 | 13 | |||||
294 | 294 | -73.9713906492842 | 40.775006131014294 | 12E-PM-1018-03 | 12E | PM | 1018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9713906492842 40.7750061310143) | 19 | 4 | 19 | 13 | ||||||
395 | 395 | -73.9768311751004 | 40.766717807255795 | 2E-AM-1010-03 | 02E | AM | 1010 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 4.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9768311751004 40.7667178072558) | 19 | 4 | 19 | 13 | ||||||
412 | 412 | -73.9794371709817 | 40.768387910254 | 2B-PM-1013-07 | 02B | PM | 1013 | 7 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9794371709817 40.768387910254) | 19 | 4 | 19 | 13 | ||||||
420 | 420 | -73.9684376038582 | 40.78242750672371 | 20C-PM-1018-09 | 20C | PM | 1018 | 9 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9684376038582 40.7824275067237) | 19 | 4 | 19 | 13 | ||||||
484 | 484 | -73.972010921173 | 40.7701626919216 | 7G-AM-1010-09 | 07G | AM | 1010 | 9 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.972010921173 40.7701626919216) | 19 | 4 | 19 | 13 | ||||||
519 | 519 | -73.9596083366477 | 40.7949526729608 | 36C-PM-1013-05 | 36C | PM | 1013 | 5 | Adult | Cinnamon | Cinnamon+ | "Warm brown" written in for Primary. | Ground Plane | FALSE | Ran across path in front of people | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | POINT (-73.9596083366477 40.7949526729608) | 19 | 4 | 19 | 13 | ||||
520 | 520 | -73.9610705592868 | 40.7914829661051 | 32D-AM-1013-06 | 32D | AM | 1013 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | eating (a mushroom),circles around us,really fat,scratching himself,grooming activity | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9610705592868 40.7914829661051) | 19 | 4 | 19 | 13 | |||||
561 | 561 | -73.96481954331921 | 40.7796399955868 | 19G-PM-1017-03 | 19G | PM | 1017 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | staring | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9648195433192 40.7796399955868) | 19 | 4 | 19 | 13 | |||||
764 | 764 | -73.9651601541795 | 40.7761841788025 | 15I-PM-1012-07 | 15I | PM | 1012 | 7 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9651601541795 40.7761841788025) | 19 | 4 | 19 | 13 | ||||||
898 | 898 | -73.9801619956135 | 40.76785766975421 | 1B-AM-1012-09 | 01B | AM | 1012 | 9 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801619956135 40.7678576697542) | 19 | 4 | 19 | 13 | ||||||
925 | 925 | -73.97116665233759 | 40.776151305703394 | 13D-AM-1014-02 | 13D | AM | 1014 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711666523376 40.7761513057034) | 19 | 4 | 19 | 13 | ||||||
973 | 973 | -73.9756993198381 | 40.768195664191296 | 3E-PM-1008-08 | 03E | PM | 1008 | 8 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9756993198381 40.7681956641913) | 19 | 4 | 19 | 13 | ||||||
989 | 989 | -73.9507699667119 | 40.7955166039555 | 40I-AM-1018-02 | 40I | AM | 1018 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9507699667119 40.7955166039555) | 19 | 4 | 19 | 13 | ||||||
1073 | 1073 | -73.97027172608291 | 40.768951107763 | 6I-PM-1013-03 | 06I | PM | 1013 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | Flowers, grass | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9702717260829 40.768951107763) | 19 | 4 | 19 | 13 | |||||
1110 | 1110 | -73.96913180449691 | 40.770980197469605 | 9I-AM-1014-05 | 09I | AM | 1014 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9691318044969 40.7709801974696) | 19 | 4 | 19 | 13 | ||||||
1126 | 1126 | -73.968200390984 | 40.783709576948205 | 22B-AM-1013-02 | 22B | AM | 1013 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | climbed tree | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.968200390984 40.7837095769482) | 19 | 4 | 19 | 13 | |||||
1159 | 1159 | -73.9511118711108 | 40.7950813345902 | 40I-AM-1018-01 | 40I | AM | 1018 | 1 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | begging | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9511118711108 40.7950813345902) | 19 | 4 | 19 | 13 | |||||
1271 | 1271 | -73.9563311167069 | 40.79509015633371 | 38E-AM-1010-12 | 38E | AM | 1010 | 12 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | running on rocks | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | runs toward something | POINT (-73.9563311167069 40.7950901563337) | 19 | 4 | 19 | 13 | ||||
1287 | 1287 | -73.972112497276 | 40.77027590374279 | 7G-AM-1010-08 | 07G | AM | 1010 | 8 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.972112497276 40.7702759037428) | 19 | 4 | 19 | 13 | ||||||
1319 | 1319 | -73.97443873476259 | 40.7776953143835 | 13A-AM-1017-03 | 13A | AM | 1017 | 3 | Adult | Cinnamon | Cinnamon+ | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744387347626 40.7776953143835) | 19 | 4 | 19 | 13 | ||||||||
1364 | 1364 | -73.96810908249779 | 40.783827583032796 | 22B-PM-1014-04 | 22B | PM | 1014 | 4 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9681090824978 40.7838275830328) | 19 | 4 | 19 | 13 | ||||||
1370 | 1370 | -73.96624389966809 | 40.7890381809441 | 28A-PM-1007-05 | 28A | PM | 1007 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9662438996681 40.7890381809441) | 19 | 4 | 19 | 13 | ||||||
1469 | 1469 | -73.97665418790059 | 40.7674077265375 | 2E-AM-1010-06 | 02E | AM | 1010 | 6 | Adult | Cinnamon | Cinnamon+ | Above Ground | 35.0 | 0 | 0 | 0 | 0 | 0 | leaping branch to branch | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9766541879006 40.7674077265375) | 19 | 4 | 19 | 13 | |||||
1517 | 1517 | -73.9796470494747 | 40.7678370925485 | 1C-PM-1013-08 | 01C | PM | 1013 | 8 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9796470494747 40.7678370925485) | 19 | 4 | 19 | 13 | ||||||
1545 | 1545 | -73.96980442184758 | 40.7697007833531 | 7I-PM-1013-06 | 07I | PM | 1013 | 6 | Adult | Cinnamon | Cinnamon+ | "Brown" written in as Primary | Ground Plane | FALSE | Under the tree | 0 | 0 | 0 | 1 | 0 | playing,interacting with #7 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9698044218476 40.7697007833531) | 19 | 4 | 19 | 13 | |||
1639 | 1639 | -73.9564632239432 | 40.7904807427954 | 33G-AM-1013-01 | 33G | AM | 1013 | 1 | Adult | Cinnamon | Cinnamon+ | Above Ground | 13.0 | shelter in hole in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9564632239432 40.7904807427954) | 19 | 4 | 19 | 13 | |||||
1662 | 1662 | -73.97116730065241 | 40.77479796145771 | 12E-PM-1018-05 | 12E | PM | 1018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9711673006524 40.7747979614577) | 19 | 4 | 19 | 13 | ||||||
1716 | 1716 | -73.9604089940153 | 40.7910028063138 | 32D-AM-1013-04 | 32D | AM | 1013 | 4 | Adult | Cinnamon | Cinnamon+ | Brown legs | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | POINT (-73.9604089940153 40.7910028063138) | 19 | 4 | 19 | 13 | |||||
1769 | 1769 | -73.97068515461841 | 40.7780777016038 | 15D-PM-1017-04 | 15D | PM | 1017 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2.0 | on fence | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9706851546184 40.7780777016038) | 19 | 4 | 19 | 13 | |||||
1834 | 1834 | -73.9686907918759 | 40.7839462261858 | 22B-AM-1013-03 | 22B | AM | 1013 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9686907918759 40.7839462261858) | 19 | 4 | 19 | 13 | ||||||
1895 | 1895 | -73.9611274898661 | 40.7915250069086 | 32C-AM-1014-05 | 32C | AM | 1014 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9611274898661 40.7915250069086) | 19 | 4 | 19 | 13 | ||||||
1970 | 1970 | -73.9768286349595 | 40.7687012827059 | 3D-PM-1010-05 | 03D | PM | 1010 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9768286349595 40.7687012827059) | 19 | 4 | 19 | 13 | ||||||
2150 | 2150 | -73.9799311173259 | 40.768557699755895 | 2B-AM-1010-03 | 02B | AM | 1010 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9799311173259 40.7685576997559) | 19 | 4 | 19 | 13 | ||||||
2217 | 2217 | -73.97856757980341 | 40.7672992405289 | 1C-PM-1013-05 | 01C | PM | 1013 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9785675798034 40.7672992405289) | 19 | 4 | 19 | 13 | ||||||
2326 | 2326 | -73.9594357049738 | 40.7840678890949 | 25I-AM-1012-01 | 25I | AM | 1012 | 1 | Adult | Cinnamon | Cinnamon+ | Above Ground | 4.0 | on bar | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | POINT (-73.9594357049738 40.7840678890949) | 19 | 4 | 19 | 13 | |||||
2358 | 2358 | -73.9811585807616 | 40.768706748732 | 2A-AM-1010-06 | 02A | AM | 1010 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | chasing #5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9811585807616 40.768706748732) | 19 | 4 | 19 | 13 | |||||
2365 | 2365 | -73.979636950073 | 40.7677999753976 | 1C-PM-1013-10 | 01C | PM | 1013 | 10 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.979636950073 40.7677999753976) | 19 | 4 | 19 | 13 | ||||||
2397 | 2397 | -73.9701505245419 | 40.768998364571 | 6I-PM-1013-07 | 06I | PM | 1013 | 7 | Adult | Cinnamon | Cinnamon+ | Above Ground | 11.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9701505245419 40.768998364571) | 19 | 4 | 19 | 13 | ||||||
2477 | 2477 | -73.9800669115792 | 40.767682513438395 | 1B-AM-1012-07 | 01B | AM | 1012 | 7 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2.0 | on tree trunk | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9800669115792 40.7676825134384) | 19 | 4 | 19 | 13 | |||||
2481 | 2481 | -73.9617088749928 | 40.7944585082367 | 35A-PM-1013-06 | 35A | PM | 1013 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9617088749928 40.7944585082367) | 19 | 4 | 19 | 13 | ||||||
2521 | 2521 | -73.9714289592392 | 40.775067070209296 | 12E-PM-1018-04 | 12E | PM | 1018 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9714289592392 40.7750670702093) | 19 | 4 | 19 | 13 | ||||||
2555 | 2555 | -73.9762974698771 | 40.7740076116964 | 9B-PM-1013-06 | 09B | PM | 1013 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9762974698771 40.7740076116964) | 19 | 4 | 19 | 13 | ||||||
2560 | 2560 | -73.9683608295976 | 40.784292740532706 | 22B-AM-1013-04 | 22B | AM | 1013 | 4 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | Under bench | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ran from dog-walker | POINT (-73.9683608295976 40.7842927405327) | 19 | 4 | 19 | 13 | ||||
2597 | 2597 | -73.9642288873015 | 40.782043998356706 | 22F-AM-1007-06 | 22F | AM | 1007 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9642288873015 40.7820439983567) | 19 | 4 | 19 | 13 | ||||||
2703 | 2703 | -73.95752586279659 | 40.787715550749 | 30H-AM-1007-03 | 30H | AM | 1007 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9575258627966 40.787715550749) | 19 | 4 | 19 | 13 | ||||||
2705 | 2705 | -73.9752793195744 | 40.7733960128931 | 9C-AM-1006-03 | 09C | AM | 1006 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9752793195744 40.7733960128931) | 19 | 4 | 19 | 13 | ||||||
2883 | 2883 | -73.9684092812839 | 40.7711445841928 | 9I-AM-1014-07 | 09I | AM | 1014 | 7 | Adult | Cinnamon | Cinnamon+ | No real highlight, White tail? | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9684092812839 40.7711445841928) | 19 | 4 | 19 | 13 | |||||
3208 | 3208 | -73.9594986107981 | 40.7840083040604 | 25I-AM-1012-03 | 25I | AM | 1012 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 8.0 | on turn, see map | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9594986107981 40.7840083040604) | 19 | 4 | 19 | 13 | |||||
3317 | 3317 | -73.9713906492842 | 40.775006131014294 | 12E-PM-1018-03 | 12E | PM | 1018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9713906492842 40.7750061310143) | 19 | 4 | 19 | 13 | ||||||
3418 | 3418 | -73.9768311751004 | 40.766717807255795 | 2E-AM-1010-03 | 02E | AM | 1010 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 4.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9768311751004 40.7667178072558) | 19 | 4 | 19 | 13 | ||||||
3435 | 3435 | -73.9794371709817 | 40.768387910254 | 2B-PM-1013-07 | 02B | PM | 1013 | 7 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9794371709817 40.768387910254) | 19 | 4 | 19 | 13 | ||||||
3443 | 3443 | -73.9684376038582 | 40.78242750672371 | 20C-PM-1018-09 | 20C | PM | 1018 | 9 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9684376038582 40.7824275067237) | 19 | 4 | 19 | 13 | ||||||
3507 | 3507 | -73.972010921173 | 40.7701626919216 | 7G-AM-1010-09 | 07G | AM | 1010 | 9 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.972010921173 40.7701626919216) | 19 | 4 | 19 | 13 | ||||||
3542 | 3542 | -73.9596083366477 | 40.7949526729608 | 36C-PM-1013-05 | 36C | PM | 1013 | 5 | Adult | Cinnamon | Cinnamon+ | "Warm brown" written in for Primary. | Ground Plane | FALSE | Ran across path in front of people | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | POINT (-73.9596083366477 40.7949526729608) | 19 | 4 | 19 | 13 | ||||
3543 | 3543 | -73.9610705592868 | 40.7914829661051 | 32D-AM-1013-06 | 32D | AM | 1013 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | eating (a mushroom),circles around us,really fat,scratching himself,grooming activity | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9610705592868 40.7914829661051) | 19 | 4 | 19 | 13 | |||||
3584 | 3584 | -73.96481954331921 | 40.7796399955868 | 19G-PM-1017-03 | 19G | PM | 1017 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | staring | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9648195433192 40.7796399955868) | 19 | 4 | 19 | 13 | |||||
3787 | 3787 | -73.9651601541795 | 40.7761841788025 | 15I-PM-1012-07 | 15I | PM | 1012 | 7 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9651601541795 40.7761841788025) | 19 | 4 | 19 | 13 | ||||||
3921 | 3921 | -73.9801619956135 | 40.76785766975421 | 1B-AM-1012-09 | 01B | AM | 1012 | 9 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801619956135 40.7678576697542) | 19 | 4 | 19 | 13 | ||||||
3948 | 3948 | -73.97116665233759 | 40.776151305703394 | 13D-AM-1014-02 | 13D | AM | 1014 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711666523376 40.7761513057034) | 19 | 4 | 19 | 13 | ||||||
3996 | 3996 | -73.9756993198381 | 40.768195664191296 | 3E-PM-1008-08 | 03E | PM | 1008 | 8 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9756993198381 40.7681956641913) | 19 | 4 | 19 | 13 | ||||||
4012 | 4012 | -73.9507699667119 | 40.7955166039555 | 40I-AM-1018-02 | 40I | AM | 1018 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9507699667119 40.7955166039555) | 19 | 4 | 19 | 13 | ||||||
4096 | 4096 | -73.97027172608291 | 40.768951107763 | 6I-PM-1013-03 | 06I | PM | 1013 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | Flowers, grass | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9702717260829 40.768951107763) | 19 | 4 | 19 | 13 | |||||
4133 | 4133 | -73.96913180449691 | 40.770980197469605 | 9I-AM-1014-05 | 09I | AM | 1014 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9691318044969 40.7709801974696) | 19 | 4 | 19 | 13 | ||||||
4149 | 4149 | -73.968200390984 | 40.783709576948205 | 22B-AM-1013-02 | 22B | AM | 1013 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | climbed tree | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.968200390984 40.7837095769482) | 19 | 4 | 19 | 13 | |||||
4182 | 4182 | -73.9511118711108 | 40.7950813345902 | 40I-AM-1018-01 | 40I | AM | 1018 | 1 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | begging | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9511118711108 40.7950813345902) | 19 | 4 | 19 | 13 | |||||
4294 | 4294 | -73.9563311167069 | 40.79509015633371 | 38E-AM-1010-12 | 38E | AM | 1010 | 12 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | running on rocks | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | runs toward something | POINT (-73.9563311167069 40.7950901563337) | 19 | 4 | 19 | 13 | ||||
4310 | 4310 | -73.972112497276 | 40.77027590374279 | 7G-AM-1010-08 | 07G | AM | 1010 | 8 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.972112497276 40.7702759037428) | 19 | 4 | 19 | 13 | ||||||
4342 | 4342 | -73.97443873476259 | 40.7776953143835 | 13A-AM-1017-03 | 13A | AM | 1017 | 3 | Adult | Cinnamon | Cinnamon+ | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744387347626 40.7776953143835) | 19 | 4 | 19 | 13 | ||||||||
4387 | 4387 | -73.96810908249779 | 40.783827583032796 | 22B-PM-1014-04 | 22B | PM | 1014 | 4 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9681090824978 40.7838275830328) | 19 | 4 | 19 | 13 | ||||||
4393 | 4393 | -73.96624389966809 | 40.7890381809441 | 28A-PM-1007-05 | 28A | PM | 1007 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9662438996681 40.7890381809441) | 19 | 4 | 19 | 13 | ||||||
4492 | 4492 | -73.97665418790059 | 40.7674077265375 | 2E-AM-1010-06 | 02E | AM | 1010 | 6 | Adult | Cinnamon | Cinnamon+ | Above Ground | 35.0 | 0 | 0 | 0 | 0 | 0 | leaping branch to branch | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9766541879006 40.7674077265375) | 19 | 4 | 19 | 13 | |||||
4540 | 4540 | -73.9796470494747 | 40.7678370925485 | 1C-PM-1013-08 | 01C | PM | 1013 | 8 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9796470494747 40.7678370925485) | 19 | 4 | 19 | 13 | ||||||
4568 | 4568 | -73.96980442184758 | 40.7697007833531 | 7I-PM-1013-06 | 07I | PM | 1013 | 6 | Adult | Cinnamon | Cinnamon+ | "Brown" written in as Primary | Ground Plane | FALSE | Under the tree | 0 | 0 | 0 | 1 | 0 | playing,interacting with #7 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9698044218476 40.7697007833531) | 19 | 4 | 19 | 13 | |||
4662 | 4662 | -73.9564632239432 | 40.7904807427954 | 33G-AM-1013-01 | 33G | AM | 1013 | 1 | Adult | Cinnamon | Cinnamon+ | Above Ground | 13.0 | shelter in hole in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9564632239432 40.7904807427954) | 19 | 4 | 19 | 13 | |||||
4685 | 4685 | -73.97116730065241 | 40.77479796145771 | 12E-PM-1018-05 | 12E | PM | 1018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9711673006524 40.7747979614577) | 19 | 4 | 19 | 13 | ||||||
4739 | 4739 | -73.9604089940153 | 40.7910028063138 | 32D-AM-1013-04 | 32D | AM | 1013 | 4 | Adult | Cinnamon | Cinnamon+ | Brown legs | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | POINT (-73.9604089940153 40.7910028063138) | 19 | 4 | 19 | 13 | |||||
4792 | 4792 | -73.97068515461841 | 40.7780777016038 | 15D-PM-1017-04 | 15D | PM | 1017 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2.0 | on fence | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9706851546184 40.7780777016038) | 19 | 4 | 19 | 13 | |||||
4857 | 4857 | -73.9686907918759 | 40.7839462261858 | 22B-AM-1013-03 | 22B | AM | 1013 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9686907918759 40.7839462261858) | 19 | 4 | 19 | 13 | ||||||
4918 | 4918 | -73.9611274898661 | 40.7915250069086 | 32C-AM-1014-05 | 32C | AM | 1014 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9611274898661 40.7915250069086) | 19 | 4 | 19 | 13 | ||||||
4993 | 4993 | -73.9768286349595 | 40.7687012827059 | 3D-PM-1010-05 | 03D | PM | 1010 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9768286349595 40.7687012827059) | 19 | 4 | 19 | 13 | ||||||
5173 | 5173 | -73.9799311173259 | 40.768557699755895 | 2B-AM-1010-03 | 02B | AM | 1010 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9799311173259 40.7685576997559) | 19 | 4 | 19 | 13 | ||||||
5240 | 5240 | -73.97856757980341 | 40.7672992405289 | 1C-PM-1013-05 | 01C | PM | 1013 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9785675798034 40.7672992405289) | 19 | 4 | 19 | 13 | ||||||
5349 | 5349 | -73.9594357049738 | 40.7840678890949 | 25I-AM-1012-01 | 25I | AM | 1012 | 1 | Adult | Cinnamon | Cinnamon+ | Above Ground | 4.0 | on bar | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | POINT (-73.9594357049738 40.7840678890949) | 19 | 4 | 19 | 13 | |||||
5381 | 5381 | -73.9811585807616 | 40.768706748732 | 2A-AM-1010-06 | 02A | AM | 1010 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | chasing #5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9811585807616 40.768706748732) | 19 | 4 | 19 | 13 | |||||
5388 | 5388 | -73.979636950073 | 40.7677999753976 | 1C-PM-1013-10 | 01C | PM | 1013 | 10 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.979636950073 40.7677999753976) | 19 | 4 | 19 | 13 | ||||||
5420 | 5420 | -73.9701505245419 | 40.768998364571 | 6I-PM-1013-07 | 06I | PM | 1013 | 7 | Adult | Cinnamon | Cinnamon+ | Above Ground | 11.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9701505245419 40.768998364571) | 19 | 4 | 19 | 13 | ||||||
5500 | 5500 | -73.9800669115792 | 40.767682513438395 | 1B-AM-1012-07 | 01B | AM | 1012 | 7 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2.0 | on tree trunk | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9800669115792 40.7676825134384) | 19 | 4 | 19 | 13 | |||||
5504 | 5504 | -73.9617088749928 | 40.7944585082367 | 35A-PM-1013-06 | 35A | PM | 1013 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9617088749928 40.7944585082367) | 19 | 4 | 19 | 13 | ||||||
5544 | 5544 | -73.9714289592392 | 40.775067070209296 | 12E-PM-1018-04 | 12E | PM | 1018 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9714289592392 40.7750670702093) | 19 | 4 | 19 | 13 | ||||||
5578 | 5578 | -73.9762974698771 | 40.7740076116964 | 9B-PM-1013-06 | 09B | PM | 1013 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9762974698771 40.7740076116964) | 19 | 4 | 19 | 13 | ||||||
5583 | 5583 | -73.9683608295976 | 40.784292740532706 | 22B-AM-1013-04 | 22B | AM | 1013 | 4 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | Under bench | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ran from dog-walker | POINT (-73.9683608295976 40.7842927405327) | 19 | 4 | 19 | 13 | ||||
5620 | 5620 | -73.9642288873015 | 40.782043998356706 | 22F-AM-1007-06 | 22F | AM | 1007 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9642288873015 40.7820439983567) | 19 | 4 | 19 | 13 | ||||||
5726 | 5726 | -73.95752586279659 | 40.787715550749 | 30H-AM-1007-03 | 30H | AM | 1007 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9575258627966 40.787715550749) | 19 | 4 | 19 | 13 | ||||||
5728 | 5728 | -73.9752793195744 | 40.7733960128931 | 9C-AM-1006-03 | 09C | AM | 1006 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9752793195744 40.7733960128931) | 19 | 4 | 19 | 13 | ||||||
5906 | 5906 | -73.9684092812839 | 40.7711445841928 | 9I-AM-1014-07 | 09I | AM | 1014 | 7 | Adult | Cinnamon | Cinnamon+ | No real highlight, White tail? | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9684092812839 40.7711445841928) | 19 | 4 | 19 | 13 | |||||
78 | 78 | -73.97554590905341 | 40.7680866624003 | 4E-AM-1020-04 | 04E | AM | 1020 | 4 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | chillin' | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9755459090534 40.7680866624003) | 19 | 4 | 19 | 13 | ||||
659 | 659 | -73.9636476467218 | 40.7775556986702 | 18I-AM-1017-01 | 18I | AM | 1017 | 1 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9636476467218 40.7775556986702) | 19 | 4 | 19 | 13 | |||||
776 | 776 | -73.97991559660859 | 40.7698034314993 | 3A-PM-1017-08 | 03A | PM | 1017 | 8 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9799155966086 40.7698034314993) | 19 | 4 | 19 | 13 | |||||
1025 | 1025 | -73.9756894776708 | 40.768163821821204 | 4E-AM-1020-03 | 04E | AM | 1020 | 3 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9756894776708 40.7681638218212) | 19 | 4 | 19 | 13 |
JSON shape: default, array, newline-delimited
CREATE TABLE "2018_Central_Park_Squirrel_Census" ( "Longitude" REAL, "Latitude" REAL, "Unique_Squirrel_ID" TEXT, "Hectare" TEXT, "Shift" TEXT, "Date" INTEGER, "Hectare_Squirrel_Number" INTEGER, "Age" REAL, "Primary_Fur_Color" REAL, "Highlight_Fur_Color" REAL, "Combination_of_Primary_and_Highlight_Color" TEXT, "Color_notes" REAL, "Location" REAL, "Above_Ground_Sighter_Measurement" REAL, "Specific_Location" REAL, "Running" INTEGER, "Chasing" INTEGER, "Climbing" INTEGER, "Eating" INTEGER, "Foraging" INTEGER, "Other_Activities" REAL, "Kuks" INTEGER, "Quaas" INTEGER, "Moans" INTEGER, "Tail_flags" INTEGER, "Tail_twitches" INTEGER, "Approaches" INTEGER, "Indifferent" INTEGER, "Runs_from" INTEGER, "Other_Interactions" REAL, "Latlong" TEXT, "Zip_Codes" REAL, "Community_Districts" INTEGER, "Borough_Boundaries" INTEGER, "City_Council_Districts" INTEGER, "Police_Precincts" INTEGER )