This data as json, CSV (advanced)
Combination of Primary and Highlight Color ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2433 | 2433 | -73.9706949930717 | 40.772362045852 | 10G-AM-1006-08 | 10G | AM | 10062018 | 8 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 3 | false | false | false | true | false | false | false | false | true | true | false | true | false | POINT (-73.9706949930717 40.772362045852) | 19 | 4 | 19 | 13 | |||||
2540 | 2540 | -73.959127912788 | 40.7921197130403 | 33E-AM-1014-13 | 33E | AM | 10142018 | 13 | Adult | Black | Cinnamon | Black+Cinnamon | Cinnamon on the tail | Ground Plane | FALSE | false | false | false | false | false | sitting | false | false | false | false | false | false | true | false | POINT (-73.959127912788 40.7921197130403) | 19 | 4 | 19 | 13 | |||
2974 | 2974 | -73.9575791421589 | 40.7959934459432 | 38D-AM-1017-06 | 38D | AM | 10172018 | 6 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9575791421589 40.7959934459432) | 19 | 4 | 19 | 13 | |||||
2975 | 2975 | -73.959412243507 | 40.7917871123534 | 33E-AM-1014-01 | 33E | AM | 10142018 | 1 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | digging | false | false | false | false | false | false | false | true | POINT (-73.959412243507 40.7917871123534) | 19 | 4 | 19 | 13 | ||||
1223 | 1223 | -73.9591298551111 | 40.7919612446005 | 33E-AM-1014-04 | 33E | AM | 10142018 | 4 | Adult | Black | Cinnamon, White | Black+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9591298551111 40.7919612446005) | 19 | 4 | 19 | 13 | |||||
2879 | 2879 | -73.9744080700098 | 40.7731515721826 | 9C-PM-1006-07 | 09C | PM | 10062018 | 7 | Adult | Black | Cinnamon, White | Black+Cinnamon, White | Ground Plane | FALSE | on top of tarped sand pile | false | false | false | true | false | false | false | false | false | false | false | false | true | (me) | POINT (-73.9744080700098 40.7731515721826) | 19 | 4 | 19 | 13 | |||
1296 | 1296 | -73.9705509170542 | 40.7689416540228 | 6I-PM-1013-04 | 06I | PM | 10132018 | 4 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | Grass | false | false | false | true | false | false | false | false | false | true | false | false | false | POINT (-73.9705509170542 40.7689416540228) | 19 | 4 | 19 | 13 | ||||
1473 | 1473 | -73.9584064190878 | 40.7912992852442 | 33F-PM-1012-03 | 33F | PM | 10122018 | 3 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9584064190878 40.7912992852442) | 19 | 4 | 19 | 13 | |||||
2467 | 2467 | -73.9755923256429 | 40.7672967972471 | 3F-PM-1013-02 | 03F | PM | 10132018 | 2 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.97559232564292 40.7672967972471) | 19 | 4 | 19 | 13 | |||||
2496 | 2496 | -73.9696274291417 | 40.7691980808067 | 7I-PM-1013-03 | 07I | PM | 10132018 | 3 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | Trash bins | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9696274291417 40.7691980808067) | 19 | 4 | 19 | 13 | ||||
2651 | 2651 | -73.9632993246327 | 40.7888199519656 | 29C-AM-1007-05 | 29C | AM | 10072018 | 5 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9632993246327 40.7888199519656) | 19 | 4 | 19 | 13 | |||||
2999 | 2999 | -73.972415182837 | 40.773080463452 | 10E-AM-1010-02 | 10E | AM | 10102018 | 2 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.972415182837 40.773080463452) | 19 | 4 | 19 | 13 | |||||
1345 | 1345 | -73.9581326554206 | 40.7918074743129 | 34E-PM-1006-02 | 34E | PM | 10062018 | 2 | Juvenile | Black | Gray, White | Black+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9581326554206 40.7918074743129) | 19 | 4 | 19 | 13 | |||||
181 | 181 | -73.9708775864433 | 40.772473633538 | 10F-PM-1019-12 | 10F | PM | 10192018 | 12 | Adult | Black | White | Black+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9708775864433 40.772473633538) | 19 | 4 | 19 | 13 | |||||
1210 | 1210 | -73.9707937464541 | 40.7725282708448 | 10G-PM-1017-07 | 10G | PM | 10172018 | 7 | Adult | Black | White | Black+White | Ground Plane | FALSE | false | false | false | false | false | traveling | false | false | false | false | false | false | true | false | POINT (-73.9707937464541 40.7725282708448) | 19 | 4 | 19 | 13 | ||||
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 | ||||||
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 | |||||
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 | ||||||
217 | 217 | -73.9712327308512 | 40.7748702909218 | 12E-PM-1018-06 | 12E | PM | 10182018 | 6 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9712327308512 40.7748702909218) | 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 | |||||
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 | ||||||
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 | ||||||
454 | 454 | -73.9752793195744 | 40.7733960128931 | 9C-AM-1006-03 | 09C | AM | 10062018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9752793195744 40.7733960128931) | 19 | 4 | 19 | 13 | ||||||
805 | 805 | -73.9706851546184 | 40.7780777016038 | 15D-PM-1017-04 | 15D | PM | 10172018 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2 | on fence | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9706851546184 40.7780777016038) | 19 | 4 | 19 | 13 | |||||
893 | 893 | -73.9799311173259 | 40.7685576997559 | 2B-AM-1010-03 | 02B | AM | 10102018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9799311173259 40.7685576997559) | 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 | ||||
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 | |||||
1199 | 1199 | -73.9756993198381 | 40.7681956641913 | 3E-PM-1008-08 | 03E | PM | 10082018 | 8 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9756993198381 40.7681956641913) | 19 | 4 | 19 | 13 | ||||||
1212 | 1212 | -73.9761792189352 | 40.7745745517215 | 9A-AM-1013-09 | 09A | AM | 10132018 | 9 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9761792189352 40.7745745517215) | 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 | |||||
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 | |||||
1323 | 1323 | -73.9744387347626 | 40.7776953143835 | 13A-AM-1017-03 | 13A | AM | 10172018 | 3 | Adult | Cinnamon | Cinnamon+ | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9744387347626 40.7776953143835) | 19 | 4 | 19 | 13 | ||||||||
1363 | 1363 | -73.972112497276 | 40.7702759037428 | 7G-AM-1010-08 | 07G | AM | 10102018 | 8 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.972112497276 40.7702759037428) | 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 | ||||||
1382 | 1382 | -73.9611274898661 | 40.7915250069086 | 32C-AM-1014-05 | 32C | AM | 10142018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9611274898661 40.7915250069086) | 19 | 4 | 19 | 13 | ||||||
1558 | 1558 | -73.968200390984 | 40.7837095769482 | 22B-AM-1013-02 | 22B | AM | 10132018 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | climbed tree | false | false | false | false | false | false | true | false | POINT (-73.968200390984 40.7837095769482) | 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 | |||||
2025 | 2025 | -73.9766541879006 | 40.7674077265375 | 2E-AM-1010-06 | 02E | AM | 10102018 | 6 | Adult | Cinnamon | Cinnamon+ | Above Ground | 35 | false | false | false | false | false | leaping branch to branch | false | false | false | false | false | false | true | false | POINT (-73.9766541879006 40.7674077265375) | 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 | |||||
2241 | 2241 | -73.9575258627966 | 40.787715550749 | 30H-AM-1007-03 | 30H | AM | 10072018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9575258627966 40.787715550749) | 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 | |||||||
2401 | 2401 | -73.972010921173 | 40.7701626919216 | 7G-AM-1010-09 | 07G | AM | 10102018 | 9 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.972010921173 40.7701626919216) | 19 | 4 | 19 | 13 | ||||||
2411 | 2411 | -73.9686907918759 | 40.7839462261858 | 22B-AM-1013-03 | 22B | AM | 10132018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9686907918759 40.7839462261858) | 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 | ||||||
2483 | 2483 | -73.9596083366477 | 40.7949526729608 | 36C-PM-1013-05 | 36C | PM | 10132018 | 5 | Adult | Cinnamon | Cinnamon+ | "Warm brown" written in for Primary. | Ground Plane | FALSE | Ran across path in front of people | true | false | false | true | true | false | false | false | false | true | false | true | true | POINT (-73.9596083366477 40.7949526729608) | 19 | 4 | 19 | 13 | ||||
2492 | 2492 | -73.9801619956135 | 40.7678576697542 | 1B-AM-1012-09 | 01B | AM | 10122018 | 9 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9801619956135 40.7678576697542) | 19 | 4 | 19 | 13 | ||||||
2505 | 2505 | -73.9762974698771 | 40.7740076116964 | 9B-PM-1013-06 | 09B | PM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9762974698771 40.7740076116964) | 19 | 4 | 19 | 13 | ||||||
2601 | 2601 | -73.979636950073 | 40.7677999753976 | 1C-PM-1013-10 | 01C | PM | 10132018 | 10 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.979636950073 40.7677999753976) | 19 | 4 | 19 | 13 | ||||||
2612 | 2612 | -73.9711673006524 | 40.7747979614577 | 12E-PM-1018-05 | 12E | PM | 10182018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9711673006524 40.7747979614577) | 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 | ||||||
2753 | 2753 | -73.9681090824978 | 40.7838275830328 | 22B-PM-1014-04 | 22B | PM | 10142018 | 4 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9681090824978 40.7838275830328) | 19 | 4 | 19 | 13 | ||||||
2838 | 2838 | -73.9507699667119 | 40.7955166039555 | 40I-AM-1018-02 | 40I | AM | 10182018 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9507699667119 40.795516603955505) | 19 | 4 | 19 | 13 | ||||||
2941 | 2941 | -73.9690266660317 | 40.7853134751509 | 23A-AM-1018-01 | 23A | AM | 10182018 | 1 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9690266660317 40.7853134751509) | 19 | 4 | 19 | 13 | ||||||
2955 | 2955 | -73.9711666523376 | 40.7761513057034 | 13D-AM-1014-02 | 13D | AM | 10142018 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9711666523376 40.7761513057034) | 19 | 4 | 19 | 13 | ||||||
358 | 358 | -73.9635658786416 | 40.7777291777901 | 18I-AM-1017-03 | 18I | AM | 10172018 | 3 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9635658786416 40.77772917779011) | 19 | 4 | 19 | 13 | |||||
677 | 677 | -73.9799155966086 | 40.7698034314993 | 3A-PM-1017-08 | 03A | PM | 10172018 | 8 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9799155966086 40.7698034314993) | 19 | 4 | 19 | 13 | |||||
1353 | 1353 | -73.9636476467218 | 40.7775556986702 | 18I-AM-1017-01 | 18I | AM | 10172018 | 1 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9636476467218 40.7775556986702) | 19 | 4 | 19 | 13 | |||||
1843 | 1843 | -73.9685940262068 | 40.776932102013 | 15F-AM-1007-07 | 15F | AM | 10072018 | 7 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9685940262068 40.776932102013) | 19 | 4 | 19 | 13 | |||||
2291 | 2291 | -73.9756894776708 | 40.7681638218212 | 4E-AM-1020-03 | 04E | AM | 10202018 | 3 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9756894776708 40.7681638218212) | 19 | 4 | 19 | 13 | |||||
2367 | 2367 | -73.9681671864047 | 40.7753770538635 | 14G-AM-1012-04 | 14G | AM | 10122018 | 4 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9681671864047 40.7753770538635) | 19 | 4 | 19 | 13 | |||||
2453 | 2453 | -73.9756105226696 | 40.7696531972655 | 5D-AM-1020-03 | 05D | AM | 10202018 | 3 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9756105226696 40.7696531972655) | 19 | 4 | 19 | 13 | |||||
2560 | 2560 | -73.9755459090534 | 40.7680866624003 | 4E-AM-1020-04 | 04E | AM | 10202018 | 4 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | false | chillin' | false | false | false | false | false | false | false | true | POINT (-73.9755459090534 40.7680866624003) | 19 | 4 | 19 | 13 | ||||
2757 | 2757 | -73.9671419119456 | 40.7758602486862 | 14G-AM-1012-01 | 14G | AM | 10122018 | 1 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9671419119456 40.7758602486862) | 19 | 4 | 19 | 13 | |||||
1198 | 1198 | -73.9762187733662 | 40.7739282973004 | 9B-PM-1013-08 | 09B | PM | 10132018 | 8 | Juvenile | Cinnamon | Black, White | Cinnamon+Black, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9762187733662 40.7739282973004) | 19 | 4 | 19 | 13 | |||||
2761 | 2761 | -73.9689204258063 | 40.7712540588951 | 9I-AM-1014-01 | 09I | AM | 10142018 | 1 | Adult | Cinnamon | Black, White | Cinnamon+Black, White | Black on body, White Belly, White tail | Ground Plane | FALSE | false | false | false | false | true | digging deeeep | false | false | false | false | false | false | true | false | POINT (-73.9689204258063 40.7712540588951) | 19 | 4 | 19 | 13 | |||
2801 | 2801 | -73.9697665830132 | 40.7759094917104 | 13E-PM-1008-08 | 13E | PM | 10082018 | 8 | Juvenile | Cinnamon | Black, White | Cinnamon+Black, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9697665830132 40.7759094917104) | 19 | 4 | 19 | 13 | |||||
19 | 19 | -73.9768603630674 | 40.7702795904962 | 5C-PM-1010-09 | 05C | PM | 10102018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9768603630674 40.7702795904962) | 19 | 4 | 19 | 13 | |||||
67 | 67 | -73.968381325559 | 40.7780143443779 | 16E-PM-1018-06 | 16E | PM | 10182018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | On a rock | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.968381325559 40.7780143443779) | 19 | 4 | 19 | 13 | ||||
204 | 204 | -73.9679538163341 | 40.7837103696906 | 22C-AM-1013-03 | 22C | AM | 10132018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | eating (mushroom) | false | false | false | false | false | false | false | true | POINT (-73.9679538163341 40.7837103696906) | 19 | 4 | 19 | 13 | ||||
214 | 214 | -73.9772576561244 | 40.7679895093963 | 3D-AM-1006-08 | 03D | AM | 10062018 | 8 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | approaches (food stand) | POINT (-73.9772576561244 40.7679895093963) | 19 | 4 | 19 | 13 | ||||
224 | 224 | -73.9520592496349 | 40.7975076299811 | 42G-PM-1014-03 | 42G | PM | 10142018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | on fence | true | false | false | false | false | prancing | false | false | false | false | false | false | false | true | POINT (-73.9520592496349 40.7975076299811) | 19 | 4 | 19 | 13 | |||
263 | 263 | -73.9771069181511 | 40.7670538214988 | 2E-PM-1014-05 | 02E | PM | 10142018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9771069181511 40.7670538214988) | 19 | 4 | 19 | 13 | |||||
290 | 290 | -73.9560679864426 | 40.7947887062326 | 37E-PM-1006-06 | 37E | PM | 10062018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9560679864426 40.7947887062326) | 19 | 4 | 19 | 13 | |||||
298 | 298 | -73.957342596188 | 40.7944359654227 | 37E-PM-1006-09 | 37E | PM | 10062018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | false | moseying | false | false | false | false | true | true | false | false | POINT (-73.957342596188 40.7944359654227) | 19 | 4 | 19 | 13 | ||||
305 | 305 | -73.9750283794865 | 40.7724101927821 | 8C-PM-1013-08 | 08C | PM | 10132018 | 8 | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9750283794865 40.7724101927821) | 19 | 4 | 19 | 13 | ||||||
319 | 319 | -73.9659034359706 | 40.7797516688844 | 19F-AM-1007-02 | 19F | AM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 8 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9659034359706 40.77975166888441) | 19 | 4 | 19 | 13 | |||||
377 | 377 | -73.9757001944781 | 40.769499790547 | 5E-AM-1008-09 | 05E | AM | 10082018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | went up tree | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9757001944781 40.769499790547) | 19 | 4 | 19 | 13 | ||||
392 | 392 | -73.9802376131034 | 40.7680707516627 | 1B-AM-1012-12 | 01B | AM | 10122018 | 12 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9802376131034 40.7680707516627) | 19 | 4 | 19 | 13 | |||||
399 | 399 | -73.9763433202401 | 40.7738473490681 | 9B-PM-1013-10 | 09B | PM | 10132018 | 10 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | "Brown" written in as Primary | Above Ground | 12 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9763433202401 40.7738473490681) | 19 | 4 | 19 | 13 | ||||
423 | 423 | -73.9756754297747 | 40.7738518843446 | 9B-PM-1013-02 | 09B | PM | 10132018 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9756754297747 40.7738518843446) | 19 | 4 | 19 | 13 | |||||
432 | 432 | -73.9757787135906 | 40.7737231427345 | 9B-PM-1013-03 | 09B | PM | 10132018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9757787135906 40.7737231427345) | 19 | 4 | 19 | 13 | |||||
493 | 493 | -73.9776854797916 | 40.7683102295663 | 3D-AM-1006-04 | 03D | AM | 10062018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (boy on bike) | POINT (-73.9776854797916 40.7683102295663) | 19 | 4 | 19 | 13 | ||||
545 | 545 | -73.9756810453606 | 40.7756257458036 | 11A-PM-1013-01 | 11A | PM | 10132018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Off-white, decorator's white? | Ground Plane | FALSE | false | false | false | true | false | eating (osage orange) | false | false | false | false | false | false | true | false | POINT (-73.9756810453606 40.7756257458036) | 19 | 4 | 19 | 13 | |||
557 | 557 | -73.9792153893146 | 40.7688272492961 | 3B-AM-1010-01 | 03B | AM | 10102018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9792153893146 40.7688272492961) | 19 | 4 | 19 | 13 | |||||
604 | 604 | -73.9540908513075 | 40.794201225045 | 37G-PM-1007-04 | 37G | PM | 10072018 | 4 | Cinnamon | Gray | Cinnamon+Gray | gray tail | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9540908513075 40.794201225045) | 19 | 4 | 19 | 13 | |||||
636 | 636 | -73.9757536187319 | 40.7755119810678 | 11A-PM-1013-03 | 11A | PM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9757536187319 40.7755119810678) | 19 | 4 | 19 | 13 | |||||
651 | 651 | -73.9801661903932 | 40.7697950141751 | 3A-PM-1017-03 | 03A | PM | 10172018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9801661903932 40.7697950141751) | 19 | 4 | 19 | 13 | |||||
685 | 685 | -73.9658181813014 | 40.7798160637561 | 19F-AM-1007-01 | 19F | AM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | bit scared | POINT (-73.9658181813014 40.7798160637561) | 19 | 4 | 19 | 13 | ||||
687 | 687 | -73.9636971843665 | 40.7825638537362 | 22F-AM-1007-04 | 22F | AM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9636971843665 40.7825638537362) | 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 );