This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Primary 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, Runs from, Other Interactions, 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 | Lat/Long | Zip Codes | Community Districts | Borough Boundaries | City Council Districts | Police Precincts |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
508 | 508 | -73.9746918762076 | 40.7655231883678 | 1G-AM-1006-02 | 01G | AM | 10062018 | 2 | Juvenile | Gray | White | Gray+White | Above Ground | 30 | false | false | true | false | true | false | false | false | false | true | false | true | false | POINT (-73.9746918762076 40.7655231883678) | 19 | 4 | 19 | 13 | |||||
2918 | 2918 | -73.9745152462626 | 40.7655415515908 | 1G-AM-1006-04 | 01G | AM | 10062018 | 4 | Adult | Gray | White | Gray+White | false | true | false | false | true | collecting nest material | false | false | false | false | true | false | true | false | POINT (-73.9745152462626 40.76554155159081) | 19 | 4 | 19 | 13 | ||||||
294 | 294 | -73.9756573579063 | 40.7656644063024 | 1G-PM-1010-01 | 01G | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | true | true | false | false | false | false | true | false | false | true | false | too busy eating in his tree | POINT (-73.9756573579063 40.7656644063024) | 19 | 4 | 19 | 13 | ||||
1122 | 1122 | -73.9728700359494 | 40.7659842666881 | 3H-PM-1014-05 | 03H | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9728700359494 40.7659842666881) | 19 | 4 | 19 | 13 | |||||
664 | 664 | -73.9725174868556 | 40.7664248283566 | 3H-PM-1014-07 | 03H | PM | 10142018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9725174868556 40.7664248283566) | 19 | 4 | 19 | 13 | |||||
2410 | 2410 | -73.9755192076934 | 40.7664413570796 | 2F-PM-1014-06 | 02F | PM | 10142018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9755192076934 40.7664413570796) | 19 | 4 | 19 | 13 | |||||
2539 | 2539 | -73.9781033448468 | 40.7666724066213 | 1D-AM-1006-03 | 01D | AM | 10062018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9781033448468 40.7666724066213) | 19 | 4 | 19 | 13 | |||||
2160 | 2160 | -73.975028559002 | 40.7667307335544 | 2F-PM-1014-09 | 02F | PM | 10142018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.975028559002 40.7667307335544) | 19 | 4 | 19 | 13 | |||||
2558 | 2558 | -73.9749469566854 | 40.7667805367199 | 2F-PM-1014-10 | 02F | PM | 10142018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9749469566854 40.7667805367199) | 19 | 4 | 19 | 13 | |||||
575 | 575 | -73.9783366903829 | 40.7668300056094 | 1D-PM-1007-03 | 01D | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9783366903829 40.7668300056094) | 19 | 4 | 19 | 13 | |||||
2576 | 2576 | -73.9751625910271 | 40.7671023412885 | 3F-AM-1006-02 | 03F | AM | 10062018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9751625910271 40.7671023412885) | 19 | 4 | 19 | 13 | |||||
405 | 405 | -73.9786603147149 | 40.7671937837017 | 1D-AM-1006-09 | 01D | AM | 10062018 | 9 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9786603147149 40.7671937837017) | 19 | 4 | 19 | 13 | |||||
468 | 468 | -73.9780659679557 | 40.7672382282781 | 1D-PM-1007-06 | 01D | PM | 10072018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9780659679557 40.7672382282781) | 19 | 4 | 19 | 13 | |||||
742 | 742 | -73.9767016963397 | 40.7674012784541 | 2E-PM-1014-02 | 02E | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9767016963397 40.7674012784541) | 19 | 4 | 19 | 13 | |||||
1860 | 1860 | -73.9767100101318 | 40.7675779951996 | 2E-PM-1014-03 | 02E | PM | 10142018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9767100101318 40.7675779951996) | 19 | 4 | 19 | 13 | |||||
2191 | 2191 | -73.9734108731087 | 40.7676051392697 | 4G-AM-1006-03 | 04G | AM | 10062018 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9734108731087 40.7676051392697) | 19 | 4 | 19 | 13 | ||||||
2547 | 2547 | -73.9743393747021 | 40.7676346798325 | 3F-AM-1006-12 | 03F | AM | 10062018 | 12 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9743393747021 40.7676346798325) | 19 | 4 | 19 | 13 | |||||
2800 | 2800 | -73.9802983138318 | 40.7676540772339 | 1B-PM-1019-05 | 01B | PM | 10192018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9802983138318 40.7676540772339) | 19 | 4 | 19 | 13 | |||||
2688 | 2688 | -73.9799302952205 | 40.7677207209798 | 1B-PM-1019-02 | 01B | PM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9799302952205 40.7677207209798) | 19 | 4 | 19 | 13 | |||||
495 | 495 | -73.9801007327506 | 40.7677455633932 | 1B-PM-1019-06 | 01B | PM | 10192018 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9801007327506 40.7677455633932) | 19 | 4 | 19 | 13 | |||||
2605 | 2605 | -73.9736896363006 | 40.7677630862626 | 4G-AM-1006-01 | 04G | AM | 10062018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9736896363006 40.7677630862626) | 19 | 4 | 19 | 13 | |||||
1783 | 1783 | -73.9730001080547 | 40.7678719218983 | 4G-AM-1006-05 | 04G | AM | 10062018 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 20 | false | false | true | false | false | climbing (tree) | false | false | false | false | false | false | true | false | indifferent—was in front of my face (we were on a bridge)! | POINT (-73.9730001080547 40.7678719218983) | 19 | 4 | 19 | 13 | |||
1184 | 1184 | -73.9807982742225 | 40.7678795985389 | 1B-PM-1019-01 | 01B | PM | 10192018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9807982742225 40.7678795985389) | 19 | 4 | 19 | 13 | |||||
2482 | 2482 | -73.9805927710872 | 40.7679989116642 | 1B-PM-1019-07 | 01B | PM | 10192018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9805927710872 40.7679989116642) | 19 | 4 | 19 | 13 | |||||
1001 | 1001 | -73.9801985977846 | 40.7680159511705 | 1B-AM-1012-11 | 01B | AM | 10122018 | 11 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | true | false | fighting w/ pigeons | false | false | false | false | false | false | true | false | POINT (-73.9801985977846 40.7680159511705) | 19 | 4 | 19 | 13 | ||||
1175 | 1175 | -73.9803282698463 | 40.7680809889384 | 1B-PM-1019-09 | 01B | PM | 10192018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Tree to ground | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9803282698463 40.7680809889384) | 19 | 4 | 19 | 13 | ||||
189 | 189 | -73.9735489537928 | 40.7681257911523 | 4G-AM-1006-02 | 04G | AM | 10062018 | 2 | Gray | White | Gray+White | Above Ground | 12 | tree | false | false | false | false | false | sitting in tree | false | false | false | false | false | false | true | false | POINT (-73.9735489537928 40.7681257911523) | 19 | 4 | 19 | 13 | ||||
1582 | 1582 | -73.9804065254162 | 40.7681481183296 | 1B-PM-1019-08 | 01B | PM | 10192018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9804065254162 40.7681481183296) | 19 | 4 | 19 | 13 | |||||
1349 | 1349 | -73.9806805581636 | 40.7681537966505 | 1B-AM-1012-16 | 01B | AM | 10122018 | 16 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9806805581636 40.7681537966505) | 19 | 4 | 19 | 13 | |||||
1413 | 1413 | -73.9810032206428 | 40.7681625634979 | 1A-AM-1007-01 | 01A | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 7 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9810032206428 40.7681625634979) | 19 | 4 | 19 | 13 | |||||
1804 | 1804 | -73.980777106431 | 40.7681635726316 | 1A-AM-1007-02 | 01A | AM | 10072018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 11 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.980777106431 40.7681635726316) | 19 | 4 | 19 | 13 | |||||
1177 | 1177 | -73.9807898224726 | 40.768215817511 | 1A-PM-1014-04 | 01A | PM | 10142018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9807898224726 40.768215817511) | 19 | 4 | 19 | 13 | |||||
2412 | 2412 | -73.9809446489564 | 40.7685032165879 | 2A-PM-1019-03 | 02A | PM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | in tree! | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9809446489564 40.7685032165879) | 19 | 4 | 19 | 13 | ||||
999 | 999 | -73.980948293606 | 40.7685688850628 | 2A-PM-1019-04 | 02A | PM | 10192018 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | in tree! | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.980948293606 40.7685688850628) | 19 | 4 | 19 | 13 | ||||
741 | 741 | -73.9790214253443 | 40.7686791169776 | 3B-PM-1007-10 | 03B | PM | 10072018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | hopping | false | false | false | false | false | false | true | false | POINT (-73.9790214253443 40.7686791169776) | 19 | 4 | 19 | 13 | ||||
2816 | 2816 | -73.9809342290598 | 40.7687265606227 | 2A-AM-1010-05 | 02A | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | base of tree with ~ 30 small birds all eating | false | false | false | true | true | false | false | false | false | true | true | true | false | POINT (-73.9809342290598 40.7687265606227) | 19 | 4 | 19 | 13 | ||||
2116 | 2116 | -73.9801562527339 | 40.7687267327113 | 2B-AM-1010-01 | 02B | AM | 10102018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9801562527339 40.7687267327113) | 19 | 4 | 19 | 13 | |||||
2684 | 2684 | -73.9809688694074 | 40.7688535974878 | 2A-PM-1019-06 | 02A | PM | 10192018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9809688694074 40.7688535974878) | 19 | 4 | 19 | 13 | |||||
407 | 407 | -73.9787658435198 | 40.7689419765393 | 3B-PM-1007-07 | 03B | PM | 10072018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | eating loudly <- peanuts w/ shells | false | false | false | false | false | false | true | false | POINT (-73.9787658435198 40.7689419765393) | 19 | 4 | 19 | 13 | ||||
1981 | 1981 | -73.972154069981 | 40.7690128009722 | 6G-AM-1008-03 | 06G | AM | 10082018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | grass | false | false | false | true | true | false | false | false | true | false | false | true | false | POINT (-73.972154069981 40.7690128009722) | 19 | 4 | 19 | 13 | ||||
1849 | 1849 | -73.9788436368415 | 40.7691104998969 | 3B-AM-1010-05 | 03B | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9788436368415 40.7691104998969) | 19 | 4 | 19 | 13 | |||||
2706 | 2706 | -73.9745141185576 | 40.7691479781207 | 5E-AM-1008-01 | 05E | AM | 10082018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 2 | on a checker table | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9745141185576 40.7691479781207) | 19 | 4 | 19 | 13 | ||||
1580 | 1580 | -73.9775079672882 | 40.7691500357424 | 4C-PM-1010-07 | 04C | PM | 10102018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9775079672882 40.7691500357424) | 19 | 4 | 19 | 13 | |||||
247 | 247 | -73.9733117663541 | 40.7694584620114 | 6F-PM-1008-05 | 06F | PM | 10082018 | 5 | Adult | Cinnamon | White | Cinnamon+White | white patch | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.97331176635412 40.7694584620114) | 19 | 4 | 19 | 13 | ||||
2189 | 2189 | -73.9761776424664 | 40.7695941843825 | 5D-PM-1018-07 | 05D | PM | 10182018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9761776424664 40.7695941843825) | 19 | 4 | 19 | 13 | |||||
2221 | 2221 | -73.9771847728747 | 40.7695971164981 | 4C-AM-1006-01 | 04C | AM | 10062018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9771847728747 40.7695971164981) | 19 | 4 | 19 | 13 | |||||
756 | 756 | -73.9773079154219 | 40.7696506688861 | 4C-AM-1006-02 | 04C | AM | 10062018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9773079154219 40.7696506688861) | 19 | 4 | 19 | 13 | |||||
1709 | 1709 | -73.9771696835698 | 40.7697011100487 | 4C-AM-1006-04 | 04C | AM | 10062018 | 4 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9771696835698 40.7697011100487) | 19 | 4 | 19 | 13 | |||||
2854 | 2854 | -73.9772908667333 | 40.7697207404744 | 4C-AM-1006-05 | 04C | AM | 10062018 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 20 | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9772908667333 40.7697207404744) | 19 | 4 | 19 | 13 | |||||
483 | 483 | -73.9789952029637 | 40.7697758333099 | 4B-AM-1010-03 | 04B | AM | 10102018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9789952029637 40.7697758333099) | 19 | 4 | 19 | 13 | |||||
1827 | 1827 | -73.9779760874355 | 40.7698230936583 | 4C-PM-1010-16 | 04C | PM | 10102018 | 16 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9779760874355 40.7698230936583) | 19 | 4 | 19 | 13 | |||||
1129 | 1129 | -73.9744906832678 | 40.7699948746776 | 6E-PM-1010-05 | 06E | PM | 10102018 | 5 | Adult | Cinnamon | White | Cinnamon+White | white back legs | Ground Plane | FALSE | false | false | false | true | false | could this squirrel be eating a white mushroom? | false | false | false | false | false | false | true | false | POINT (-73.9744906832678 40.76999487467761) | 19 | 4 | 19 | 13 | |||
1659 | 1659 | -73.9690498876944 | 40.7700011818847 | 8I-AM-1006-07 | 08I | AM | 10062018 | 7 | Adult | Gray | White | Gray+White | White ring on short tail | Above Ground | 20 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9690498876944 40.7700011818847) | 19 | 4 | 19 | 13 | ||||
2946 | 2946 | -73.974515099169 | 40.7700650799886 | 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 | false | true | false | true | false | chasing #4 | false | false | false | false | false | false | true | false | POINT (-73.974515099169 40.770065079988605) | 19 | 4 | 19 | 13 | ||
1085 | 1085 | -73.9722265046794 | 40.7700916895929 | 7G-PM-1018-02 | 07G | PM | 10182018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9722265046794 40.7700916895929) | 19 | 4 | 19 | 13 | |||||
1536 | 1536 | -73.9746128451271 | 40.7700957046709 | 6E-PM-1010-02 | 06E | PM | 10102018 | 2 | Adult | Cinnamon | White | Cinnamon+White | white back legs | Ground Plane | FALSE | small open area but w/ 7 large oak trees | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9746128451271 40.7700957046709) | 19 | 4 | 19 | 13 | |||
1282 | 1282 | -73.974451175321 | 40.7701294635264 | 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 | false | true | false | true | false | chasing #3 | false | false | false | false | false | false | true | false | POINT (-73.974451175321 40.7701294635264) | 19 | 4 | 19 | 13 | ||
164 | 164 | -73.9758676144255 | 40.7701671581939 | 5D-PM-1018-03 | 05D | PM | 10182018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9758676144255 40.7701671581939) | 19 | 4 | 19 | 13 | |||||
1730 | 1730 | -73.9796142848349 | 40.7702117898305 | 4A-PM-1007-04 | 04A | PM | 10072018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9796142848349 40.7702117898305) | 19 | 4 | 19 | 13 | |||||
1660 | 1660 | -73.9800499498034 | 40.7702181099573 | 4A-PM-1007-05 | 04A | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | At rock | false | false | false | false | true | false | false | false | true | true | false | true | false | POINT (-73.9800499498034 40.770218109957305) | 19 | 4 | 19 | 13 | ||||
2340 | 2340 | -73.9730284815849 | 40.7702462529502 | 7F-AM-1008-04 | 07F | AM | 10082018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | bush | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9730284815849 40.7702462529502) | 19 | 4 | 19 | 13 | ||||
2642 | 2642 | -73.9751454725998 | 40.770291361572 | 6D-PM-1020-06 | 06D | PM | 10202018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | by carousel | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9751454725998 40.770291361572006) | 19 | 4 | 19 | 13 | ||||
1745 | 1745 | -73.9688438058715 | 40.7703014325728 | 8I-AM-1006-05 | 08I | AM | 10062018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 20 | tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9688438058715 40.7703014325728) | 19 | 4 | 19 | 13 | ||||
1233 | 1233 | -73.9722281263634 | 40.7704083288013 | 7G-AM-1010-06 | 07G | AM | 10102018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9722281263634 40.7704083288013) | 19 | 4 | 19 | 13 | |||||
2331 | 2331 | -73.9694681803635 | 40.770585795359 | 8I-AM-1006-06 | 08I | AM | 10062018 | 6 | Adult | Gray | White | Gray+White | Above Ground | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9694681803635 40.770585795359) | 19 | 4 | 19 | 13 | ||||||
1358 | 1358 | -73.9693772461788 | 40.7706875892901 | 8I-AM-1006-03 | 08I | AM | 10062018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9693772461788 40.7706875892901) | 19 | 4 | 19 | 13 | |||||
1529 | 1529 | -73.9692401421068 | 40.7707128895661 | 8I-AM-1006-04 | 08I | AM | 10062018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9692401421068 40.7707128895661) | 19 | 4 | 19 | 13 | |||||
2490 | 2490 | -73.9693876553956 | 40.7707232748402 | 8I-AM-1006-02 | 08I | AM | 10062018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | true | false | true | false | POINT (-73.9693876553956 40.7707232748402) | 19 | 4 | 19 | 13 | |||||
1588 | 1588 | -73.9693209851947 | 40.7707450042769 | 8I-AM-1006-01 | 08I | AM | 10062018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | true | false | false | false | false | false | true | false | POINT (-73.9693209851947 40.7707450042769) | 19 | 4 | 19 | 13 | |||||
437 | 437 | -73.9793952066038 | 40.7707837657859 | 4A-PM-1007-03 | 04A | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | by rock | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9793952066038 40.77078376578591) | 19 | 4 | 19 | 13 | ||||
1779 | 1779 | -73.9695560376915 | 40.7708835103516 | 9H-AM-1006-03 | 09H | AM | 10062018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.96955603769152 40.7708835103516) | 19 | 4 | 19 | 13 | |||||
2973 | 2973 | -73.9766693184436 | 40.7708879215854 | 6C-PM-1020-01 | 06C | PM | 10202018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | Across Transverse | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9766693184436 40.7708879215854) | 19 | 4 | 19 | 13 | ||||
199 | 199 | -73.9771614686616 | 40.7709677983247 | 5C-AM-1006-02 | 05C | AM | 10062018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10 | true | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9771614686616 40.7709677983247) | 19 | 4 | 19 | 13 | |||||
1213 | 1213 | -73.9693202078293 | 40.771043472925 | 9H-AM-1006-01 | 09H | AM | 10062018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9693202078293 40.771043472925) | 19 | 4 | 19 | 13 | |||||
967 | 967 | -73.9683994064731 | 40.7710765500799 | 9I-AM-1014-06 | 09I | AM | 10142018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.96839940647311 40.7710765500799) | 19 | 4 | 19 | 13 | |||||
1387 | 1387 | -73.9697160572446 | 40.7711445570446 | 9H-AM-1006-02 | 09H | AM | 10062018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.96971605724461 40.7711445570446) | 19 | 4 | 19 | 13 | |||||
710 | 710 | -73.9695569897042 | 40.7712062147171 | 9H-PM-1018-01 | 09H | PM | 10182018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.96955698970422 40.7712062147171) | 19 | 4 | 19 | 13 | |||||
2363 | 2363 | -73.9690638424196 | 40.7713869295685 | 9H-AM-1006-06 | 09H | AM | 10062018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | true | false | true | false | POINT (-73.9690638424196 40.7713869295685) | 19 | 4 | 19 | 13 | |||||
163 | 163 | -73.9712308864394 | 40.7714534847379 | 9G-AM-1007-04 | 09G | AM | 10072018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | false | false | false | grooming | false | false | false | false | false | false | true | false | POINT (-73.9712308864394 40.7714534847379) | 19 | 4 | 19 | 13 | ||||
2591 | 2591 | -73.9786351029146 | 40.7716114164002 | 6A-PM-1012-06 | 06A | PM | 10122018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | elevated ground | false | true | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9786351029146 40.771611416400205) | 19 | 4 | 19 | 13 | ||||
640 | 640 | -73.9785536529136 | 40.7716184505002 | 6A-PM-1012-07 | 06A | PM | 10122018 | 7 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | elevated ground | false | true | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9785536529136 40.771618450500206) | 19 | 4 | 19 | 13 | ||||
921 | 921 | -73.9698959071826 | 40.7716763799299 | 9H-AM-1006-05 | 09H | AM | 10062018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9698959071826 40.7716763799299) | 19 | 4 | 19 | 13 | |||||
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 | false | false | false | true | true | false | false | false | false | false | false | true | false | there's a family playing soccer | POINT (-73.9736418085696 40.7716931127716) | 19 | 4 | 19 | 13 | |||
1901 | 1901 | -73.9680237209555 | 40.7717022208225 | 10I-AM-1010-04 | 10I | AM | 10102018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9680237209555 40.7717022208225) | 19 | 4 | 19 | 13 | |||||
307 | 307 | -73.9683965841952 | 40.7718679848978 | 10I-AM-1010-03 | 10I | AM | 10102018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9683965841952 40.7718679848978) | 19 | 4 | 19 | 13 | |||||
895 | 895 | -73.9786898656279 | 40.7720833097065 | 6A-AM-1006-08 | 06A | AM | 10062018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9786898656279 40.77208330970651) | 19 | 4 | 19 | 13 | |||||
1727 | 1727 | -73.9692472299565 | 40.7722592187215 | 10H-PM-1007-01 | 10H | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | dark gray | Above Ground | 15 | in tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9692472299565 40.7722592187215) | 19 | 4 | 19 | 13 | |||
1439 | 1439 | -73.9729645190377 | 40.7723310150843 | 9E-AM-1008-02 | 09E | AM | 10082018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9729645190377 40.7723310150843) | 19 | 4 | 19 | 13 | |||||
761 | 761 | -73.975062146111 | 40.7723417173451 | 8C-PM-1013-07 | 08C | PM | 10132018 | 7 | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.975062146111 40.7723417173451) | 19 | 4 | 19 | 13 | ||||||
737 | 737 | -73.9711176999471 | 40.7724278547281 | 10F-PM-1019-06 | 10F | PM | 10192018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 10 | Different tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9711176999471 40.7724278547281) | 19 | 4 | 19 | 13 | ||||
2007 | 2007 | -73.9684834138222 | 40.7724289120211 | 11H-AM-1010-06 | 11H | AM | 10102018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | true | false | true | false | POINT (-73.9684834138222 40.7724289120211) | 19 | 4 | 19 | 13 | |||||
532 | 532 | -73.9685429060839 | 40.7724786961619 | 11H-AM-1010-05 | 11H | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9685429060839 40.7724786961619) | 19 | 4 | 19 | 13 | |||||
2355 | 2355 | -73.9728654439465 | 40.7724853142211 | 9E-AM-1008-04 | 09E | AM | 10082018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9728654439465 40.7724853142211) | 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 | ||||
12 | 12 | -73.9683613516225 | 40.7725908847499 | 11H-AM-1010-03 | 11H | AM | 10102018 | 3 | Adult | Cinnamon | White | Cinnamon+White | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9683613516225 40.7725908847499) | 19 | 4 | 19 | 13 | |||||||
239 | 239 | -73.9758464905133 | 40.7725957408841 | 8C-PM-1013-05 | 08C | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9758464905133 40.7725957408841) | 19 | 4 | 19 | 13 | |||||
485 | 485 | -73.9677423154682 | 40.7728813350245 | 11I-AM-1012-02 | 11I | AM | 10122018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9677423154682 40.77288133502451) | 19 | 4 | 19 | 13 | |||||
1836 | 1836 | -73.9751056714758 | 40.7732060035215 | 8C-PM-1013-03 | 08C | PM | 10132018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | false | true | false | POINT (-73.9751056714758 40.7732060035215) | 19 | 4 | 19 | 13 | |||||
375 | 375 | -73.9752000129992 | 40.7732918122239 | 8C-PM-1013-04 | 08C | PM | 10132018 | 4 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9752000129992 40.7732918122239) | 19 | 4 | 19 | 13 | |||||
424 | 424 | -73.9756557086441 | 40.773296289824 | 8B-PM-1012-08 | 08B | PM | 10122018 | 8 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9756557086441 40.773296289824) | 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 );