This data as json, CSV (advanced)
Suggested facets: 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, Foraging, Other Activities, Kuks, Quaas, Moans, Tail twitches, Approaches, Indifferent, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4 | 4 | -73.9757249834141 | 40.7697032606755 | 5D-PM-1018-05 | 05D | PM | 10182018 | 5 | Juvenile | Gray | Gray+ | Above Ground | 3 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9757249834141 40.7697032606755) | 19 | 4 | 19 | 13 | ||||||
45 | 45 | -73.9579645940414 | 40.7918613498407 | 34F-AM-1007-01 | 34F | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9579645940414 40.7918613498407) | 19 | 4 | 19 | 13 | |||||
102 | 102 | -73.9575986161364 | 40.799368134968 | 41B-PM-1014-01 | 41B | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | Climbing tree | false | false | true | false | false | climbing (tree) | false | false | false | false | false | false | false | true | POINT (-73.9575986161364 40.799368134968) | 19 | 4 | 19 | 13 | |||
130 | 130 | -73.9581655949437 | 40.7997708190022 | 41A-PM-1007-06 | 41A | PM | 10072018 | 6 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9581655949437 40.7997708190022) | 19 | 4 | 19 | 13 | ||||||
135 | 135 | -73.9694168118643 | 40.7728877377977 | 11G-PM-1013-01 | 11G | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | In the Woods/Brush | false | false | true | false | true | false | false | false | false | false | false | false | true | watching me | POINT (-73.9694168118643 40.7728877377977) | 19 | 4 | 19 | 13 | |||
147 | 147 | -73.9564023626619 | 40.7905423546155 | 33G-AM-1013-02 | 33G | AM | 10132018 | 2 | Adult | Gray | Gray+ | Above Ground | 13 | shelter in hole in tree | false | false | true | false | false | false | false | false | false | false | false | true | true | POINT (-73.9564023626619 40.7905423546155) | 19 | 4 | 19 | 13 | |||||
168 | 168 | -73.9745691353018 | 40.7771035589298 | 13A-PM-1014-03 | 13A | PM | 10142018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | false | false | true | false | false | false | false | false | false | false | false | false | true | child chasing | POINT (-73.9745691353018 40.7771035589298) | 19 | 4 | 19 | 13 | ||||
235 | 235 | -73.9753574279936 | 40.7683211694257 | 4E-PM-1008-08 | 04E | PM | 10082018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9753574279936 40.7683211694257) | 19 | 4 | 19 | 13 | ||||||
236 | 236 | -73.9737266070919 | 40.7786338379896 | 14A-PM-1014-01 | 14A | PM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9737266070919 40.7786338379896) | 19 | 4 | 19 | 13 | |||||
268 | 268 | -73.968107276769 | 40.7768612676036 | 15F-AM-1007-09 | 15F | AM | 10072018 | 9 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 20 | false | false | true | false | true | false | false | false | false | false | false | false | true | POINT (-73.968107276769 40.7768612676036) | 19 | 4 | 19 | 13 | |||||
274 | 274 | -73.9639832886071 | 40.7909532437095 | 30B-PM-1019-08 | 30B | PM | 10192018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.9639832886071 40.7909532437095) | 19 | 4 | 19 | 13 | |||||
303 | 303 | -73.9762348224648 | 40.7694522315322 | 4D-PM-1008-08 | 04D | PM | 10082018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | true | true | true | climbed fence staring at me - went up tree | false | false | false | false | false | false | false | true | POINT (-73.97623482246482 40.7694522315322) | 19 | 4 | 19 | 13 | ||||
341 | 341 | -73.9703161745884 | 40.7702610461336 | 8H-PM-1014-05 | 08H | PM | 10142018 | 5 | Juvenile | Gray | Gray+ | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9703161745884 40.7702610461336) | 19 | 4 | 19 | 13 | ||||||
364 | 364 | -73.9623696148045 | 40.792184861375 | 32B-AM-1017-04 | 32B | AM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 13 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9623696148045 40.792184861375) | 19 | 4 | 19 | 13 | |||||
372 | 372 | -73.9781303869038 | 40.7725000348875 | 7A-AM-1006-02 | 07A | AM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9781303869038 40.7725000348875) | 19 | 4 | 19 | 13 | ||||
384 | 384 | -73.968045072743 | 40.7836626717225 | 22C-AM-1013-02 | 22C | AM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | false | false | true | false | true | true | false | false | true | false | false | false | true | POINT (-73.968045072743 40.7836626717225) | 19 | 4 | 19 | 13 | |||||
388 | 388 | -73.9592537496995 | 40.7919271821316 | 33E-AM-1014-03 | 33E | AM | 10142018 | 3 | Adult | Black | Black+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9592537496995 40.7919271821316) | 19 | 4 | 19 | 13 | ||||||
402 | 402 | -73.9681917366128 | 40.7723298813768 | 11I-PM-1012-03 | 11I | PM | 10122018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | true | false | false | false | false | false | false | false | true | runs from the dog | POINT (-73.9681917366128 40.7723298813768) | 19 | 4 | 19 | 13 | |||||
415 | 415 | -73.9570131890379 | 40.7991786736124 | 41B-PM-1014-05 | 41B | PM | 10142018 | 5 | Adult | Gray | Gray+ | Above Ground | 25 | false | false | true | false | false | true | false | false | false | false | false | true | true | POINT (-73.9570131890379 40.7991786736124) | 19 | 4 | 19 | 13 | ||||||
425 | 425 | -73.9704485231855 | 40.7717290560806 | 9G-AM-1007-02 | 09G | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 25 | false | false | true | false | false | false | false | false | false | false | false | false | true | kids were trying to poke it with a stick | POINT (-73.9704485231855 40.7717290560806) | 19 | 4 | 19 | 13 | |||||
470 | 470 | -73.9581243021722 | 40.794431473386 | 36D-AM-1007-01 | 36D | AM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | false | true | avoiding a dog | POINT (-73.95812430217221 40.794431473386) | 19 | 4 | 19 | 13 | ||||
504 | 504 | -73.9533476020736 | 40.7933003544685 | 37H-PM-1006-02 | 37H | PM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | tree | true | false | true | false | true | true | false | false | false | false | false | false | true | dogs | POINT (-73.9533476020736 40.7933003544685) | 19 | 4 | 19 | 13 | |||
506 | 506 | -73.9649611089685 | 40.7814371834837 | 21F-AM-1018-05 | 21F | AM | 10182018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9649611089685 40.7814371834837) | 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 | ||||||
510 | 510 | -73.9638590768396 | 40.7776782114981 | 18I-AM-1017-02 | 18I | AM | 10172018 | 2 | Adult | Gray | Black | Gray+Black | Above Ground | 15 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9638590768396 40.7776782114981) | 19 | 4 | 19 | 13 | |||||
511 | 511 | -73.9653142636891 | 40.7760015129298 | 15I-AM-1008-04 | 15I | AM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9653142636891 40.7760015129298) | 19 | 4 | 19 | 13 | ||||||
529 | 529 | -73.9635290751183 | 40.7820936628202 | 22G-AM-1018-02 | 22G | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | false | true | false | false | false | false | false | false | true | POINT (-73.9635290751183 40.7820936628202) | 19 | 4 | 19 | 13 | ||||||
533 | 533 | -73.9652584749758 | 40.7803011124382 | 19F-PM-1017-04 | 19F | PM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9652584749758 40.7803011124382) | 19 | 4 | 19 | 13 | |||||
534 | 534 | -73.9650499507011 | 40.7908191782173 | 30A-AM-1010-01 | 30A | AM | 10102018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | true | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9650499507011 40.7908191782173) | 19 | 4 | 19 | 13 | |||||
552 | 552 | -73.9625416200877 | 40.7811302397912 | 21H-AM-1017-02 | 21H | AM | 10172018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 1 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9625416200877 40.78113023979121) | 19 | 4 | 19 | 13 | |||||
555 | 555 | -73.9685227310735 | 40.776599466588 | 15F-AM-1007-02 | 15F | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9685227310735 40.776599466588) | 19 | 4 | 19 | 13 | ||||
593 | 593 | -73.9593352806175 | 40.7918150568046 | 33E-AM-1014-02 | 33E | AM | 10142018 | 2 | Juvenile | Black | Black+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9593352806175 40.7918150568046) | 19 | 4 | 19 | 13 | ||||||
641 | 641 | -73.9719036217446 | 40.7803588122409 | 17A-AM-1017-01 | 17A | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | ground & tree | true | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.9719036217446 40.7803588122409) | 19 | 4 | 19 | 13 | ||||
643 | 643 | -73.976730206737 | 40.773709213914 | 8A-PM-1014-01 | 08A | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | true | false | true | false | false | false | false | false | false | true | runs from (goes up a tree) | POINT (-73.976730206737 40.773709213914) | 19 | 4 | 19 | 13 | ||||
667 | 667 | -73.9624538733037 | 40.7883829851518 | 28D-AM-1012-04 | 28D | AM | 10122018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9624538733037 40.7883829851518) | 19 | 4 | 19 | 13 | |||||
696 | 696 | -73.9656098194149 | 40.7757643078973 | 15I-AM-1008-05 | 15I | AM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9656098194149 40.7757643078973) | 19 | 4 | 19 | 13 | ||||||
726 | 726 | -73.973305698325 | 40.7783823311296 | 14A-PM-1014-06 | 14A | PM | 10142018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 9 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.973305698325 40.7783823311296) | 19 | 4 | 19 | 13 | |||||
738 | 738 | -73.9725712588741 | 40.7669101832926 | 4H-AM-1006-02 | 04H | AM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | false | climbing (over small wire fence then on the ground) | false | false | false | false | false | true | false | true | approaches (saw me & came forward),runs from (startled by another person) | POINT (-73.9725712588741 40.7669101832926) | 19 | 4 | 19 | 13 | |||
760 | 760 | -73.9718234159557 | 40.7810842503715 | 18A-AM-1012-02 | 18A | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | false | false | true | true | true | burying | false | false | false | true | false | false | false | true | POINT (-73.9718234159557 40.7810842503715) | 19 | 4 | 19 | 13 | ||||
768 | 768 | -73.9729394928432 | 40.7743256716496 | 11D-AM-1010-01 | 11D | AM | 10102018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.9729394928432 40.7743256716496) | 19 | 4 | 19 | 13 | |||||
795 | 795 | -73.9582523503306 | 40.7996897499473 | 41A-PM-1007-05 | 41A | PM | 10072018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9582523503306 40.7996897499473) | 19 | 4 | 19 | 13 | |||||
808 | 808 | -73.9716881838671 | 40.778553537087 | 15C-PM-1017-02 | 15C | PM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 0 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9716881838671 40.778553537087) | 19 | 4 | 19 | 13 | |||||
820 | 820 | -73.9801902133148 | 40.769557595068 | 3A-AM-1012-03 | 03A | AM | 10122018 | 3 | Juvenile | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. | Above Ground | 1 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9801902133148 40.769557595068) | 19 | 4 | 19 | 13 | ||||
833 | 833 | -73.9741846413977 | 40.7762518164182 | 12B-PM-1018-01 | 12B | PM | 10182018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | Climbing up rocks | false | false | true | false | true | climbing (up rocks) | false | false | false | false | false | false | false | true | POINT (-73.9741846413977 40.7762518164182) | 19 | 4 | 19 | 13 | ||||
837 | 837 | -73.9557172336815 | 40.7921125657722 | 35G-PM-1006-01 | 35G | PM | 10062018 | 1 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9557172336815 40.7921125657722) | 19 | 4 | 19 | 13 | |||||
852 | 852 | -73.9609704650925 | 40.7938786854735 | 34B-AM-1013-03 | 34B | AM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | true | false | true | false | false | hopping | false | false | false | false | false | true | false | true | POINT (-73.9609704650925 40.7938786854735) | 19 | 4 | 19 | 13 | ||||
858 | 858 | -73.9629383420274 | 40.7889383725489 | 29C-AM-1007-02 | 29C | AM | 10072018 | 2 | Adult | Black | Gray | Black+Gray | Above Ground | 10 | true | false | true | false | false | false | true | false | false | false | false | false | true | POINT (-73.9629383420274 40.7889383725489) | 19 | 4 | 19 | 13 | |||||
859 | 859 | -73.9600964585868 | 40.7952339524416 | 36B-PM-1013-02 | 36B | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | true | true | false | true | POINT (-73.9600964585868 40.7952339524416) | 19 | 4 | 19 | 13 | |||||
865 | 865 | -73.9741621946917 | 40.7752481472025 | 11C-PM-1018-01 | 11C | PM | 10182018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9741621946917 40.7752481472025) | 19 | 4 | 19 | 13 | |||||
869 | 869 | -73.9629483374528 | 40.7936809905265 | 33A-PM-1018-03 | 33A | PM | 10182018 | 3 | Adult | Gray | Gray+ | Above Ground | 6 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9629483374528 40.7936809905265) | 19 | 4 | 19 | 13 | ||||||
890 | 890 | -73.9667755678511 | 40.7760256836088 | 15H-PM-1008-02 | 15H | PM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 10 | oak tree | false | true | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9667755678511 40.7760256836088) | 19 | 4 | 19 | 13 | |||||
916 | 916 | -73.9561887624471 | 40.7958187455815 | 38E-AM-1010-04 | 38E | AM | 10102018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | true | false | false | false | false | false | true | false | false | false | true | me | POINT (-73.95618876244711 40.7958187455815) | 19 | 4 | 19 | 13 | ||||
923 | 923 | -73.9578924882613 | 40.789806297824 | 32G-AM-1010-02 | 32G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 13 | false | false | true | true | false | false | false | false | false | true | false | false | true | POINT (-73.9578924882613 40.789806297824) | 19 | 4 | 19 | 13 | ||||||
964 | 964 | -73.9631045499811 | 40.7906180969472 | 30B-PM-1019-04 | 30B | PM | 10192018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.9631045499811 40.7906180969472) | 19 | 4 | 19 | 13 | |||||
984 | 984 | -73.9672950266018 | 40.7782477517567 | 17F-PM-1020-01 | 17F | PM | 10202018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9672950266018 40.7782477517567) | 19 | 4 | 19 | 13 | |||||
996 | 996 | -73.9703149829421 | 40.7785583630323 | 16D-AM-1007-01 | 16D | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9703149829421 40.7785583630323) | 19 | 4 | 19 | 13 | |||||
1051 | 1051 | -73.9613747032702 | 40.7920483852431 | 33C-PM-1007-01 | 33C | PM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9613747032702 40.792048385243106) | 19 | 4 | 19 | 13 | ||||||
1053 | 1053 | -73.9685859705486 | 40.7848805065322 | 23A-AM-1018-04 | 23A | AM | 10182018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | Tree | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9685859705486 40.7848805065322) | 19 | 4 | 19 | 13 | |||||
1055 | 1055 | -73.9632337134707 | 40.7914682370734 | 31B-PM-1007-01 | 31B | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | true | true | false | false | chasing #2 and climbing tree w/ #2 | false | false | false | false | false | false | false | true | POINT (-73.9632337134707 40.7914682370734) | 19 | 4 | 19 | 13 | ||||
1064 | 1064 | -73.9540257319561 | 40.798408619116 | 42E-PM-1012-02 | 42E | PM | 10122018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | true | false | true | false | false | false | false | false | false | false | false | true | true | POINT (-73.9540257319561 40.798408619116) | 19 | 4 | 19 | 13 | |||||||
1079 | 1079 | -73.9722737593623 | 40.768963018754 | 6G-AM-1008-04 | 06G | AM | 10082018 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | very long tail | Above Ground | 20 | tree | true | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9722737593623 40.768963018754) | 19 | 4 | 19 | 13 | |||
1081 | 1081 | -73.9680855277775 | 40.7769251965381 | 15F-AM-1007-10 | 15F | AM | 10072018 | 10 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9680855277775 40.7769251965381) | 19 | 4 | 19 | 13 | |||||
1118 | 1118 | -73.9719460335398 | 40.7810508156287 | 18A-AM-1012-01 | 18A | AM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | White tail | Above Ground | 3 | tree | true | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.9719460335398 40.7810508156287) | 19 | 4 | 19 | 13 | |||
1125 | 1125 | -73.9775735077285 | 40.7692872082165 | 4C-PM-1010-08 | 04C | PM | 10102018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | on stone arch | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9775735077285 40.7692872082165) | 19 | 4 | 19 | 13 | ||||
1173 | 1173 | -73.959070754026 | 40.7906675143413 | 32E-PM-1017-07 | 32E | PM | 10172018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.959070754026 40.7906675143413) | 19 | 4 | 19 | 13 | |||||
1185 | 1185 | -73.958230674366 | 40.7989268396525 | 40B-AM-1019-08 | 40B | AM | 10192018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | true | true | POINT (-73.958230674366 40.7989268396525) | 19 | 4 | 19 | 13 | |||||
1192 | 1192 | -73.9634811495245 | 40.790705585077 | 30B-AM-1007-10 | 30B | AM | 10072018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | true | false | false | false | false | false | false | false | true | POINT (-73.9634811495245 40.790705585077) | 19 | 4 | 19 | 13 | ||||||
1206 | 1206 | -73.9748709206354 | 40.77608025411 | 11B-PM-1014-01 | 11B | PM | 10142018 | 1 | Adult | Gray | Gray+ | Fat! | Above Ground | 10 | false | false | true | false | false | true | false | false | false | false | false | false | true | POINT (-73.9748709206354 40.77608025411) | 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 | ||||||
1268 | 1268 | -73.9623984262936 | 40.7913900453449 | 31C-PM-1010-03 | 31C | PM | 10102018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9623984262936 40.7913900453449) | 19 | 4 | 19 | 13 | |||||
1273 | 1273 | -73.9558943880051 | 40.7971535141896 | 40D-PM-1013-06 | 40D | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9558943880051 40.7971535141896) | 19 | 4 | 19 | 13 | |||||
1315 | 1315 | -73.9595955824812 | 40.7933047943534 | 34D-PM-1007-01 | 34D | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | false | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.9595955824812 40.7933047943534) | 19 | 4 | 19 | 13 | |||||
1324 | 1324 | -73.954554245377 | 40.7983935730557 | 41E-AM-1007-05 | 41E | AM | 10072018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | man/pit bull mix wandered | POINT (-73.954554245377 40.7983935730557) | 19 | 4 | 19 | 13 | ||||
1328 | 1328 | -73.9765758043111 | 40.7713803154032 | 6C-AM-1007-03 | 06C | AM | 10072018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 8 | another tree | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9765758043111 40.7713803154032) | 19 | 4 | 19 | 13 | ||||
1354 | 1354 | -73.9765269282059 | 40.7746876635248 | 9A-AM-1013-10 | 09A | AM | 10132018 | 10 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9765269282059 40.7746876635248) | 19 | 4 | 19 | 13 | |||||
1357 | 1357 | -73.9631350020634 | 40.791907210332 | 32B-PM-1010-01 | 32B | PM | 10102018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 25 | in tree | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9631350020634 40.791907210332) | 19 | 4 | 19 | 13 | |||||
1381 | 1381 | -73.9586077039567 | 40.7961896477077 | 38C-AM-1019-10 | 38C | AM | 10192018 | 10 | Adult | Gray | White | Gray+White | Above Ground | 20 | true | false | true | true | false | true | false | false | false | true | false | false | true | POINT (-73.9586077039567 40.7961896477077) | 19 | 4 | 19 | 13 | |||||
1395 | 1395 | -73.9710801547498 | 40.7760872452093 | 13D-AM-1014-03 | 13D | AM | 10142018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 2 | false | true | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9710801547498 40.7760872452093) | 19 | 4 | 19 | 13 | |||||
1410 | 1410 | -73.9587913289229 | 40.7961707624534 | 38C-AM-1019-11 | 38C | AM | 10192018 | 11 | Adult | Gray | White | Gray+White | Above Ground | 20 | true | false | true | true | false | true | false | false | false | true | false | false | true | POINT (-73.9587913289229 40.7961707624534) | 19 | 4 | 19 | 13 | |||||
1426 | 1426 | -73.9664986446294 | 40.778308334318 | 17G-PM-1017-02 | 17G | PM | 10172018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9664986446294 40.778308334318) | 19 | 4 | 19 | 13 | ||||||
1429 | 1429 | -73.9706533131129 | 40.768902033819 | 6I-AM-1006-01 | 06I | AM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | true | false | true | true | true | false | false | false | false | false | false | false | true | runs from (someone sneezed) | POINT (-73.9706533131129 40.768902033819) | 19 | 4 | 19 | 13 | |||||
1442 | 1442 | -73.961241953418 | 40.7941677113011 | 35B-PM-1013-07 | 35B | PM | 10132018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | true | false | got fed twice by grandpa,grabbed from grass and ate in tree | false | false | false | false | false | true | true | true | approaches (grandpa with food),runs from (kid),kid was slowly creeping up on it; it eventually climbed up. | POINT (-73.961241953418 40.7941677113011) | 19 | 4 | 19 | 13 | ||||
1449 | 1449 | -73.9561124892063 | 40.7949440648632 | 37E-AM-1013-04 | 37E | AM | 10132018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 8 | false | false | true | true | false | true | false | false | false | false | false | false | true | POINT (-73.9561124892063 40.7949440648632) | 19 | 4 | 19 | 13 | |||||
1466 | 1466 | -73.9651177657676 | 40.7812408103825 | 20F-PM-1007-05 | 20F | PM | 10072018 | 5 | Juvenile | Gray | White | Gray+White | white tail | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9651177657676 40.781240810382506) | 19 | 4 | 19 | 13 | ||||
1476 | 1476 | -73.976609486498 | 40.7717832922535 | 7C-PM-1020-04 | 07C | PM | 10202018 | 4 | Adult | Gray | Gray+ | Above Ground | 1 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.976609486498 40.7717832922535) | 19 | 4 | 19 | 13 | ||||||
1484 | 1484 | -73.9716736557408 | 40.7749333494336 | 12E-AM-1017-07 | 12E | AM | 10172018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9716736557408 40.7749333494336) | 19 | 4 | 19 | 13 | |||||
1507 | 1507 | -73.9699799501516 | 40.7736576286234 | 11F-AM-1013-02 | 11F | AM | 10132018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9699799501516 40.7736576286234) | 19 | 4 | 19 | 13 | ||||||
1534 | 1534 | -73.9695226023739 | 40.7797527775804 | 17D-AM-1008-01 | 17D | AM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9695226023739 40.7797527775804) | 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 | ||||||
1560 | 1560 | -73.9587072763996 | 40.7850256219415 | 27I-AM-1007-01 | 27I | AM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9587072763996 40.7850256219415) | 19 | 4 | 19 | 13 | |||||
1581 | 1581 | -73.97157754108 | 40.7776249963967 | 14C-PM-1006-01 | 14C | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | true | false | false | false | true | false | false | false | false | false | true | POINT (-73.97157754108 40.7776249963967) | 19 | 4 | 19 | 13 | |||||
1592 | 1592 | -73.9575517912392 | 40.7889158268192 | 31H-PM-1008-05 | 31H | PM | 10082018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9575517912392 40.7889158268192) | 19 | 4 | 19 | 13 | ||||||
1594 | 1594 | -73.9778730762957 | 40.770827251547 | 5B-PM-1013-05 | 05B | PM | 10132018 | 5 | Adult | Gray | Gray+ | Above Ground | 3 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9778730762957 40.770827251547) | 19 | 4 | 19 | 13 | ||||||
1608 | 1608 | -73.9545425520879 | 40.7956853415959 | 39F-PM-1006-04 | 39F | PM | 10062018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 35 | in tree | false | false | true | false | false | climbing down | false | false | false | false | false | false | false | true | ran when saw me | POINT (-73.9545425520879 40.7956853415959) | 19 | 4 | 19 | 13 | ||
1625 | 1625 | -73.9736873018042 | 40.7649106677138 | 1I-PM-1012-02 | 01I | PM | 10122018 | 2 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. | Above Ground | 1 | tree | false | false | true | false | false | true | false | false | false | false | false | false | true | POINT (-73.9736873018042 40.7649106677138) | 19 | 4 | 19 | 13 | |||
1631 | 1631 | -73.9527196716568 | 40.792363826828 | 36I-PM-1007-11 | 36I | PM | 10072018 | 11 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | false | false | true | false | false | false | false | false | false | false | false | false | true | me! | POINT (-73.9527196716568 40.792363826828) | 19 | 4 | 19 | 13 | ||||
1640 | 1640 | -73.9564632239432 | 40.7904807427954 | 33G-AM-1013-01 | 33G | AM | 10132018 | 1 | Adult | Cinnamon | Cinnamon+ | Above Ground | 13 | shelter in hole in tree | false | false | true | false | false | false | false | false | false | false | false | true | true | POINT (-73.9564632239432 40.7904807427954) | 19 | 4 | 19 | 13 | |||||
1645 | 1645 | -73.9619673317128 | 40.7924176673037 | 33B-PM-1010-08 | 33B | PM | 10102018 | 8 | Juvenile | Gray | Gray+ | Above Ground | running up tree | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9619673317128 40.7924176673037) | 19 | 4 | 19 | 13 | ||||||
1665 | 1665 | -73.9583944353352 | 40.7979689846815 | 39B-PM-1014-04 | 39B | PM | 10142018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | true | true | runs from (me—when i approached) | POINT (-73.9583944353352 40.7979689846815) | 19 | 4 | 19 | 13 | |||||
1698 | 1698 | -73.9631392113757 | 40.7914635635784 | 31B-PM-1007-02 | 31B | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | true | true | false | false | chasing #1 and climbing tree w/ #1 | false | false | false | false | false | false | false | true | POINT (-73.9631392113757 40.7914635635784) | 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 );