This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Tail flags, Tail twitches, Approaches, Runs from, Other Interactions
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 | Zip Codes | Community Districts | Borough Boundaries | City Council Districts | Police Precincts |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36 | 36 | -73.9662438996681 | 40.7890381809441 | 28A-PM-1007-05 | 28A | PM | 10072018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9662438996681 40.7890381809441) | 19 | 4 | 19 | 13 | ||||||
83 | 83 | -73.9617088749928 | 40.7944585082367 | 35A-PM-1013-06 | 35A | PM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9617088749928 40.7944585082367) | 19 | 4 | 19 | 13 | ||||||
88 | 88 | -73.9683608295976 | 40.7842927405327 | 22B-AM-1013-04 | 22B | AM | 10132018 | 4 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | Under bench | false | false | false | false | true | false | false | false | false | false | false | false | true | ran from dog-walker | POINT (-73.9683608295976 40.7842927405327) | 19 | 4 | 19 | 13 | ||||
120 | 120 | -73.9511118711108 | 40.7950813345902 | 40I-AM-1018-01 | 40I | AM | 10182018 | 1 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | begging | false | false | false | false | false | false | false | false | POINT (-73.9511118711108 40.7950813345902) | 19 | 4 | 19 | 13 | |||||
125 | 125 | -73.9651601541795 | 40.7761841788025 | 15I-PM-1012-07 | 15I | PM | 10122018 | 7 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9651601541795 40.7761841788025) | 19 | 4 | 19 | 13 | ||||||
254 | 254 | -73.9762246600197 | 40.775164077652 | 10A-AM-1006-03 | 10A | AM | 10062018 | 3 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | Bridle Path lawn | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9762246600197 40.775164077652) | 19 | 4 | 19 | 13 | |||||
397 | 397 | -73.9690416961886 | 40.7716618670996 | 10H-AM-1014-05 | 10H | AM | 10142018 | 5 | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9690416961886 40.7716618670996) | 19 | 4 | 19 | 13 | |||||||
412 | 412 | -73.9785675798034 | 40.7672992405289 | 1C-PM-1013-05 | 01C | PM | 10132018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9785675798034 40.7672992405289) | 19 | 4 | 19 | 13 | ||||||
461 | 461 | -73.9648195433192 | 40.7796399955868 | 19G-PM-1017-03 | 19G | PM | 10172018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | true | true | false | staring | false | false | false | false | true | false | false | false | POINT (-73.9648195433192 40.7796399955868) | 19 | 4 | 19 | 13 | |||||
509 | 509 | -73.9714289592392 | 40.7750670702093 | 12E-PM-1018-04 | 12E | PM | 10182018 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9714289592392 40.7750670702093) | 19 | 4 | 19 | 13 | ||||||
954 | 954 | -73.9658443548822 | 40.7796704898979 | 19F-AM-1007-03 | 19F | AM | 10072018 | 3 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | scared | POINT (-73.9658443548822 40.7796704898979) | 19 | 4 | 19 | 13 | |||||
1006 | 1006 | -73.9686296217893 | 40.771812308875 | 10H-AM-1014-02 | 10H | AM | 10142018 | 2 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 6 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9686296217893 40.771812308875) | 19 | 4 | 19 | 13 | ||||||
1038 | 1038 | -73.9563311167069 | 40.7950901563337 | 38E-AM-1010-12 | 38E | AM | 10102018 | 12 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | running on rocks | false | true | false | false | false | false | false | false | true | false | false | false | false | runs toward something | POINT (-73.9563311167069 40.7950901563337) | 19 | 4 | 19 | 13 | ||||
1230 | 1230 | -73.9790822606486 | 40.7714466633386 | 5A-AM-1006-03 | 05A | AM | 10062018 | 3 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 8 | false | false | true | true | false | false | false | false | true | false | false | false | true | POINT (-73.9790822606486 40.7714466633386) | 19 | 4 | 19 | 13 | ||||||
1260 | 1260 | -73.9811585807616 | 40.768706748732 | 2A-AM-1010-06 | 02A | AM | 10102018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | true | false | false | false | chasing #5 | false | false | false | false | false | false | false | false | POINT (-73.9811585807616 40.768706748732) | 19 | 4 | 19 | 13 | |||||
1369 | 1369 | -73.9702717260829 | 40.768951107763 | 6I-PM-1013-03 | 06I | PM | 10132018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | Flowers, grass | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9702717260829 40.768951107763) | 19 | 4 | 19 | 13 | |||||
1379 | 1379 | -73.9796470494747 | 40.7678370925485 | 1C-PM-1013-08 | 01C | PM | 10132018 | 8 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9796470494747 40.7678370925485) | 19 | 4 | 19 | 13 | ||||||
1543 | 1543 | -73.9713906492842 | 40.7750061310143 | 12E-PM-1018-03 | 12E | PM | 10182018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9713906492842 40.7750061310143) | 19 | 4 | 19 | 13 | ||||||
1763 | 1763 | -73.9768286349595 | 40.7687012827059 | 3D-PM-1010-05 | 03D | PM | 10102018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9768286349595 40.7687012827059) | 19 | 4 | 19 | 13 | ||||||
1932 | 1932 | -73.9616972557304 | 40.7953872829374 | 36A-PM-1013-03 | 36A | PM | 10132018 | 3 | Juvenile | Cinnamon | Cinnamon+ | COULD HAVE BEEN CHIPPY, DEEP BROWN | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9616972557304 40.7953872829374) | 19 | 4 | 19 | 13 | |||||
2274 | 2274 | -73.9698044218476 | 40.7697007833531 | 7I-PM-1013-06 | 07I | PM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | "Brown" written in as Primary | Ground Plane | FALSE | Under the tree | false | false | false | true | false | playing,interacting with #7 | false | false | false | false | true | false | false | true | POINT (-73.9698044218476 40.7697007833531) | 19 | 4 | 19 | 13 | |||
2281 | 2281 | -73.9691520826028 | 40.7717104037783 | 10H-AM-1014-06 | 10H | AM | 10142018 | 6 | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9691520826028 40.7717104037783) | 19 | 4 | 19 | 13 | |||||||
2464 | 2464 | -73.9691318044969 | 40.7709801974696 | 9I-AM-1014-05 | 09I | AM | 10142018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9691318044969 40.7709801974696) | 19 | 4 | 19 | 13 | ||||||
2554 | 2554 | -73.9701505245419 | 40.768998364571 | 6I-PM-1013-07 | 06I | PM | 10132018 | 7 | Adult | Cinnamon | Cinnamon+ | Above Ground | 11 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9701505245419 40.768998364571004) | 19 | 4 | 19 | 13 | ||||||
2672 | 2672 | -73.9614599022015 | 40.7945181285991 | 35A-PM-1013-11 | 35A | PM | 10132018 | 11 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9614599022015 40.7945181285991) | 19 | 4 | 19 | 13 | ||||||
79 | 79 | -73.9610705592868 | 40.7914829661051 | 32D-AM-1013-06 | 32D | AM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | true | true | eating (a mushroom),circles around us,really fat,scratching himself,grooming activity | false | false | false | false | true | true | false | false | POINT (-73.9610705592868 40.7914829661051) | 19 | 4 | 19 | 13 | |||||
320 | 320 | -73.9684376038582 | 40.7824275067237 | 20C-PM-1018-09 | 20C | PM | 10182018 | 9 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9684376038582 40.7824275067237) | 19 | 4 | 19 | 13 | ||||||
850 | 850 | -73.9642288873015 | 40.7820439983567 | 22F-AM-1007-06 | 22F | AM | 10072018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | true | false | false | POINT (-73.9642288873015 40.7820439983567) | 19 | 4 | 19 | 13 | ||||||
1138 | 1138 | -73.9594357049738 | 40.7840678890949 | 25I-AM-1012-01 | 25I | AM | 10122018 | 1 | Adult | Cinnamon | Cinnamon+ | Above Ground | 4 | on bar | false | false | false | true | false | false | false | false | true | true | true | false | false | POINT (-73.9594357049738 40.7840678890949) | 19 | 4 | 19 | 13 | |||||
1270 | 1270 | -73.967762162893 | 40.7823359027165 | 20C-PM-1018-08 | 20C | PM | 10182018 | 8 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | true | false | true | runs from (dog) | POINT (-73.967762162893 40.7823359027165) | 19 | 4 | 19 | 13 | |||||
1294 | 1294 | -73.9604089940153 | 40.7910028063138 | 32D-AM-1013-04 | 32D | AM | 10132018 | 4 | Adult | Cinnamon | Cinnamon+ | Brown legs | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | true | false | true | POINT (-73.9604089940153 40.7910028063138) | 19 | 4 | 19 | 13 | |||||
2165 | 2165 | -73.9794371709817 | 40.768387910254 | 2B-PM-1013-07 | 02B | PM | 10132018 | 7 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9794371709817 40.768387910254) | 19 | 4 | 19 | 13 | ||||||
2205 | 2205 | -73.9594986107981 | 40.7840083040604 | 25I-AM-1012-03 | 25I | AM | 10122018 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 8 | on turn, see map | true | true | false | true | false | false | false | false | false | true | true | false | false | POINT (-73.9594986107981 40.7840083040604) | 19 | 4 | 19 | 13 |
JSON shape: default, array, newline-delimited
CREATE TABLE squirrels( "Longitude" TEXT, "Latitude" TEXT, "Unique Squirrel ID" TEXT, "Hectare" TEXT, "Shift" TEXT, "Date" TEXT, "Hectare Squirrel Number" TEXT, "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" TEXT, "Chasing" TEXT, "Climbing" TEXT, "Eating" TEXT, "Foraging" TEXT, "Other Activities" TEXT, "Kuks" TEXT, "Quaas" TEXT, "Moans" TEXT, "Tail flags" TEXT, "Tail twitches" TEXT, "Approaches" TEXT, "Indifferent" TEXT, "Runs from" TEXT, "Other Interactions" TEXT, "Lat/Long" TEXT, "Zip Codes" TEXT, "Community Districts" TEXT, "Borough Boundaries" TEXT, "City Council Districts" TEXT, "Police Precincts" TEXT );