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, Kuks, Quaas, Moans, Tail flags, Tail twitches, Approaches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | -73.9561344937861 | 40.7940823884086 | 37F-PM-1014-03 | 37F | PM | 10142018 | 3 | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9561344937861 40.7940823884086) | 19 | 4 | 19 | 13 | ||||||||||
5 | 5 | -73.9593126695714 | 40.797533370163 | 39B-AM-1018-01 | 39B | AM | 10182018 | 1 | + | Above Ground | false | false | false | false | false | unknown | true | false | false | false | false | false | false | false | POINT (-73.9593126695714 40.797533370163) | 19 | 4 | 19 | 13 | ||||||||
13 | 13 | -73.9541201789795 | 40.7931811701082 | 36H-AM-1010-02 | 36H | AM | 10102018 | 2 | Adult | Gray | Gray+ | just outside hectare | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9541201789795 40.7931811701082) | 19 | 4 | 19 | 13 | |||||
33 | 33 | -73.9738033257473 | 40.7711846894166 | 7E-AM-1006-02 | 07E | AM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | under a tree | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9738033257473 40.7711846894166) | 19 | 4 | 19 | 13 | |||||
39 | 39 | -73.9716147061553 | 40.7813911036179 | 18A-PM-1018-01 | 18A | PM | 10182018 | 1 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9716147061553 40.7813911036179) | 19 | 4 | 19 | 13 | ||||||
42 | 42 | -73.9579564338627 | 40.7959337795027 | 38C-PM-1014-09 | 38C | PM | 10142018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9579564338627 40.7959337795027) | 19 | 4 | 19 | 13 | ||||||
48 | 48 | -73.9595933195409 | 40.7905847332369 | 32E-AM-1007-13 | 32E | AM | 10072018 | 13 | Adult | Gray | Gray+ | Above Ground | 50 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9595933195409 40.7905847332369) | 19 | 4 | 19 | 13 | ||||||
49 | 49 | -73.9602222116708 | 40.793779699421 | 35C-AM-1007-05 | 35C | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9602222116708 40.793779699421) | 19 | 4 | 19 | 13 | ||||||
52 | 52 | -73.9675634326877 | 40.7813477352507 | 19D-AM-1007-01 | 19D | AM | 10072018 | 1 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | false | false | fenced off area can't approach | POINT (-73.9675634326877 40.7813477352507) | 19 | 4 | 19 | 13 | |||||
72 | 72 | -73.9666007935638 | 40.7845098131567 | 23C-PM-1014-03 | 23C | PM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 8 | false | true | false | false | false | chasing (#4 across trees) | false | false | false | false | false | false | false | false | POINT (-73.9666007935638 40.7845098131567) | 19 | 4 | 19 | 13 | |||||
86 | 86 | -73.9708726050721 | 40.7723572030236 | 10F-AM-1007-02 | 10F | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 70 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9708726050721 40.7723572030236) | 19 | 4 | 19 | 13 | ||||||
91 | 91 | -73.9565905868276 | 40.7895654068546 | 32H-PM-1006-01 | 32H | PM | 10062018 | 1 | Gray | Gray+ | Above Ground | in the European Beech | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9565905868276 40.7895654068546) | 19 | 4 | 19 | 13 | |||||||
92 | 92 | -73.9565759733611 | 40.7992461674802 | 42C-AM-1007-02 | 42C | AM | 10072018 | 2 | + | false | false | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9565759733611 40.7992461674802) | 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 | ||||||
126 | 126 | -73.9792155473689 | 40.7693711799946 | 3B-PM-1007-11 | 03B | PM | 10072018 | 11 | Adult | Gray | Gray+ | Above Ground | 5 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9792155473689 40.7693711799946) | 19 | 4 | 19 | 13 | |||||
138 | 138 | -73.9721442939797 | 40.7700750802317 | 7G-PM-1018-03 | 07G | PM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9721442939797 40.7700750802317) | 19 | 4 | 19 | 13 | ||||||
156 | 156 | -73.9576589997493 | 40.7972751877447 | 39C-PM-1006-02 | 39C | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 50 | false | false | true | false | false | false | false | false | false | false | false | false | false | unaware of | POINT (-73.95765899974931 40.7972751877447) | 19 | 4 | 19 | 13 | |||||
171 | 171 | -73.971086588091 | 40.7719703235178 | 9G-PM-1007-06 | 09G | PM | 10072018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.971086588091 40.7719703235178) | 19 | 4 | 19 | 13 | ||||||
179 | 179 | -73.9646901432328 | 40.775995869679 | 15I-PM-1012-03 | 15I | PM | 10122018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9646901432328 40.775995869679) | 19 | 4 | 19 | 13 | ||||||
185 | 185 | -73.9588468413094 | 40.7963852299012 | 38B-AM-1019-05 | 38B | AM | 10192018 | 5 | Adult | Gray | Gray+ | Above Ground | 28 | false | false | true | false | false | sitting still | false | true | false | false | false | false | false | false | POINT (-73.9588468413094 40.7963852299012) | 19 | 4 | 19 | 13 | |||||
198 | 198 | -73.9761107065353 | 40.769642060286 | 5D-AM-1020-01 | 05D | AM | 10202018 | 1 | Adult | + | Too far & cloudy to tell | Above Ground | 30 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9761107065353 40.769642060286) | 19 | 4 | 19 | 13 | ||||||
202 | 202 | -73.9718729101676 | 40.7703692621371 | 7G-PM-1018-05 | 07G | PM | 10182018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9718729101676 40.7703692621371) | 19 | 4 | 19 | 13 | ||||||
218 | 218 | -73.9712318712643 | 40.7773053099657 | 14D-PM-1019-04 | 14D | PM | 10192018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9712318712643 40.7773053099657) | 19 | 4 | 19 | 13 | ||||||
222 | 222 | -73.9770273553525 | 40.7732399463626 | 8A-AM-1013-03 | 08A | AM | 10132018 | 3 | Juvenile | + | Above Ground | 3 | fence | true | true | true | true | false | playing tag together | false | false | false | false | false | true | false | false | POINT (-73.9770273553525 40.7732399463626) | 19 | 4 | 19 | 13 | |||||
223 | 223 | -73.9737091707831 | 40.7713732567512 | 7E-AM-1006-03 | 07E | AM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | under a tree | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9737091707831 40.7713732567512) | 19 | 4 | 19 | 13 | |||||
226 | 226 | -73.9775681731459 | 40.7676421190309 | 2D-AM-1007-03 | 02D | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 100 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9775681731459 40.7676421190309) | 19 | 4 | 19 | 13 | ||||||
227 | 227 | -73.9598155300913 | 40.7905887826983 | 32E-AM-1007-10 | 32E | AM | 10072018 | 10 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9598155300913 40.7905887826983) | 19 | 4 | 19 | 13 | ||||||
229 | 229 | -73.972416242971 | 40.7714260236636 | 8F-PM-1012-04 | 08F | PM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.972416242971 40.7714260236636) | 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 | |||||
264 | 264 | -73.9698714743386 | 40.7743814661685 | 12F-AM-1020-02 | 12F | AM | 10202018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9698714743386 40.7743814661685) | 19 | 4 | 19 | 13 | ||||||
266 | 266 | -73.9786481009499 | 40.7697372811949 | 4B-PM-1018-03 | 04B | PM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9786481009499 40.7697372811949) | 19 | 4 | 19 | 13 | ||||||
281 | 281 | -73.9619411917909 | 40.7923536640283 | 33B-PM-1010-11 | 33B | PM | 10102018 | 11 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9619411917909 40.7923536640283) | 19 | 4 | 19 | 13 | ||||||
296 | 296 | -73.9596964641652 | 40.7957753591585 | 37B-AM-1018-03 | 37B | AM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9596964641652 40.7957753591585) | 19 | 4 | 19 | 13 | ||||||
306 | 306 | -73.9689700100267 | 40.7775169562765 | 15E-PM-1008-05 | 15E | PM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | false | false | sitting | false | true | false | false | false | false | false | false | POINT (-73.9689700100267 40.7775169562765) | 19 | 4 | 19 | 13 | |||||
311 | 311 | -73.9578779556574 | 40.7934116539732 | 35E-PM-1006-06 | 35E | PM | 10062018 | 6 | Adult | Gray | Gray+ | Above Ground | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9578779556574 40.7934116539732) | 19 | 4 | 19 | 13 | |||||||
317 | 317 | -73.9545799024508 | 40.7908084039886 | 34I-PM-1010-01 | 34I | PM | 10102018 | 1 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9545799024508 40.7908084039886) | 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 | ||||||
321 | 321 | -73.9694288806212 | 40.7842952265291 | 22A-PM-1017-01 | 22A | PM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9694288806212 40.7842952265291) | 19 | 4 | 19 | 13 | ||||||
334 | 334 | -73.9687395228846 | 40.7807364481385 | 18D-AM-1018-02 | 18D | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9687395228846 40.7807364481385) | 19 | 4 | 19 | 13 | ||||||
363 | 363 | -73.9707197274481 | 40.7773956803431 | 14D-PM-1019-12 | 14D | PM | 10192018 | 12 | Adult | Gray | Gray+ | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9707197274481 40.7773956803431) | 19 | 4 | 19 | 13 | ||||||||
366 | 366 | -73.9673548527075 | 40.7765669058396 | 15G-PM-1019-11 | 15G | PM | 10192018 | 11 | Adult | Gray | Gray+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | false | stared | POINT (-73.9673548527075 40.7765669058396) | 19 | 4 | 19 | 13 | |||||
369 | 369 | -73.9596398997228 | 40.7933386953847 | 34D-PM-1007-02 | 34D | PM | 10072018 | 2 | Adult | Black | Black+ | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | false | false | cautiously aware | POINT (-73.9596398997228 40.7933386953847) | 19 | 4 | 19 | 13 | |||||
371 | 371 | -73.964080104186 | 40.7907898627287 | 30B-AM-1007-02 | 30B | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.964080104186 40.7907898627287) | 19 | 4 | 19 | 13 | ||||||
373 | 373 | -73.9672127283283 | 40.7810666805133 | 20D-AM-1007-01 | 20D | AM | 10072018 | 1 | Adult | Gray | Gray+ | too far to note 30' | Ground Plane | FALSE | true | false | true | true | false | a lot of activity | false | false | false | true | false | false | false | false | POINT (-73.9672127283283 40.7810666805133) | 19 | 4 | 19 | 13 | ||||
390 | 390 | -73.970720187655 | 40.7774564799983 | 14D-PM-1019-11 | 14D | PM | 10192018 | 11 | Adult | Gray | Gray+ | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.970720187655 40.7774564799983) | 19 | 4 | 19 | 13 | ||||||||
395 | 395 | -73.9565686300382 | 40.797592846003 | 40C-PM-1006-03 | 40C | PM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9565686300382 40.797592846003) | 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 | |||||||
400 | 400 | -73.9590502257662 | 40.794290363687 | 36C-PM-1013-06 | 36C | PM | 10132018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | Running across wide street | true | false | false | false | true | carrying food in mouth | false | false | false | false | false | false | false | false | POINT (-73.9590502257662 40.794290363687) | 19 | 4 | 19 | 13 | ||||
411 | 411 | -73.9669366401071 | 40.7836023897982 | 22C-PM-1006-09 | 22C | PM | 10062018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.96693664010711 40.7836023897982) | 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 | ||||||
442 | 442 | -73.9502466289084 | 40.7959228779883 | 41I-AM-1018-02 | 41I | AM | 10182018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | runs off | POINT (-73.9502466289084 40.7959228779883) | 19 | 4 | 19 | 13 | |||||
449 | 449 | -73.9701335162984 | 40.7722051011357 | 10G-AM-1006-10 | 10G | AM | 10062018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9701335162984 40.7722051011357) | 19 | 4 | 19 | 13 | ||||||
455 | 455 | -73.9688574691102 | 40.7837825208444 | 21B-AM-1019-04 | 21B | AM | 10192018 | 4 | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9688574691102 40.7837825208444) | 19 | 4 | 19 | 13 | ||||||||||
471 | 471 | -73.9707215394887 | 40.7727508149058 | 10G-AM-1006-05 | 10G | AM | 10062018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | chasing (#6) | true | false | false | false | false | false | false | false | POINT (-73.9707215394887 40.7727508149058) | 19 | 4 | 19 | 13 | |||||
480 | 480 | -73.9641293283734 | 40.7907654006019 | 30B-AM-1007-03 | 30B | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9641293283734 40.7907654006019) | 19 | 4 | 19 | 13 | ||||||
487 | 487 | -73.9666521094255 | 40.7842753517648 | 23C-PM-1014-02 | 23C | PM | 10142018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | in bushes, then ran across path | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9666521094255 40.7842753517648) | 19 | 4 | 19 | 13 | |||||
496 | 496 | -73.9548430741605 | 40.798207350942 | 41E-AM-1007-06 | 41E | AM | 10072018 | 6 | Adult | Gray | Gray+ | Above Ground | 30 | tree | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9548430741605 40.798207350942) | 19 | 4 | 19 | 13 | |||||
500 | 500 | -73.9568305513017 | 40.7974086631267 | 40C-PM-1006-05 | 40C | PM | 10062018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9568305513017 40.7974086631267) | 19 | 4 | 19 | 13 | ||||||
502 | 502 | -73.9683312453011 | 40.7801661685712 | 18D-PM-1017-01 | 18D | PM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9683312453011 40.7801661685712) | 19 | 4 | 19 | 13 | ||||||
512 | 512 | -73.9586098170241 | 40.7939653733898 | 35D-AM-1019-01 | 35D | AM | 10192018 | 1 | + | Above Ground | on tree, blue jays gathering nearby | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9586098170241 40.7939653733898) | 19 | 4 | 19 | 13 | ||||||||
519 | 519 | -73.9659010238417 | 40.7791683666215 | 18G-PM-1013-02 | 18G | PM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9659010238417 40.779168366621505) | 19 | 4 | 19 | 13 | ||||||
563 | 563 | -73.9700330712119 | 40.7782913925727 | 16D-PM-1010-06 | 16D | PM | 10102018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | walking | false | false | false | false | false | false | false | false | checking me out | POINT (-73.9700330712119 40.7782913925727) | 19 | 4 | 19 | 13 | ||||
566 | 566 | -73.9708364583591 | 40.7723691587433 | 10F-AM-1007-01 | 10F | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 60 | false | false | true | false | false | false | false | false | true | false | false | false | false | POINT (-73.9708364583591 40.7723691587433) | 19 | 4 | 19 | 13 | ||||||
578 | 578 | -73.9671306431211 | 40.7838870159057 | 22C-PM-1006-05 | 22C | PM | 10062018 | 5 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9671306431211 40.783887015905705) | 19 | 4 | 19 | 13 | ||||||
579 | 579 | -73.9786714207307 | 40.7696870806229 | 4B-PM-1018-01 | 04B | PM | 10182018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9786714207307 40.7696870806229) | 19 | 4 | 19 | 13 | ||||||
639 | 639 | -73.9558589529608 | 40.7892400394941 | 32H-PM-1006-02 | 32H | PM | 10062018 | 2 | Gray | Gray+ | Above Ground | 8 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9558589529608 40.7892400394941) | 19 | 4 | 19 | 13 | |||||||
645 | 645 | -73.9758152322587 | 40.7692377401467 | 4E-PM-1008-03 | 04E | PM | 10082018 | 3 | Adult | Gray | Gray+ | false | true | false | false | false | chasing #4 | false | false | false | false | false | false | false | false | POINT (-73.9758152322587 40.7692377401467) | 19 | 4 | 19 | 13 | |||||||
665 | 665 | -73.9563661256875 | 40.7966823114508 | 39D-AM-1008-03 | 39D | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9563661256875 40.7966823114508) | 19 | 4 | 19 | 13 | ||||||
666 | 666 | -73.9687027782726 | 40.7705162616199 | 9I-AM-1014-09 | 09I | AM | 10142018 | 9 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.96870277827261 40.7705162616199) | 19 | 4 | 19 | 13 | ||||||
686 | 686 | -73.9695745672033 | 40.7791835122147 | 17D-AM-1008-06 | 17D | AM | 10082018 | 6 | + | Above Ground | high in tree, couldn't see it, only heard it | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9695745672033 40.7791835122147) | 19 | 4 | 19 | 13 | ||||||||
691 | 691 | -73.9695964983454 | 40.7802302192799 | 18C-PM-1018-08 | 18C | PM | 10182018 | 8 | Juvenile | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9695964983454 40.7802302192799) | 19 | 4 | 19 | 13 | ||||||
701 | 701 | -73.9529230207908 | 40.7960663442573 | 40G-PM-1013-06 | 40G | PM | 10132018 | 6 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | along the road | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9529230207908 40.7960663442573) | 19 | 4 | 19 | 13 | |||||
708 | 708 | -73.9592819491968 | 40.7941062008626 | 35C-AM-1007-06 | 35C | AM | 10072018 | 6 | Adult | + | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9592819491968 40.7941062008626) | 19 | 4 | 19 | 13 | |||||||
709 | 709 | -73.9519387881692 | 40.7936273636929 | 38I-PM-1014-04 | 38I | PM | 10142018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9519387881692 40.7936273636929) | 19 | 4 | 19 | 13 | ||||||
721 | 721 | -73.9718262034469 | 40.7666771797442 | 4I-PM-1007-02 | 04I | PM | 10072018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9718262034469 40.7666771797442) | 19 | 4 | 19 | 13 | ||||||
739 | 739 | -73.9620597449066 | 40.7922465876813 | 33B-PM-1010-10 | 33B | PM | 10102018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | true | false | false | false | false | false | false | false | POINT (-73.9620597449066 40.7922465876813) | 19 | 4 | 19 | 13 | ||||||
744 | 744 | -73.9745687653791 | 40.7776396926997 | 13A-PM-1014-02 | 13A | PM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 45 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9745687653791 40.7776396926997) | 19 | 4 | 19 | 13 | ||||||
751 | 751 | -73.9683479943823 | 40.7815827298303 | 20C-PM-1018-01 | 20C | PM | 10182018 | 1 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9683479943823 40.7815827298303) | 19 | 4 | 19 | 13 | ||||||
755 | 755 | -73.9579941847434 | 40.7991216713328 | 41B-PM-1014-02 | 41B | PM | 10142018 | 2 | Adult | Black | Black+ | Above Ground | 28 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9579941847434 40.7991216713328) | 19 | 4 | 19 | 13 | ||||||
771 | 771 | -73.9648626810032 | 40.7804506112843 | 20G-AM-1018-02 | 20G | AM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | Ran up tree | true | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9648626810032 40.7804506112843) | 19 | 4 | 19 | 13 | |||||
778 | 778 | -73.9677054870327 | 40.778992870166 | 17E-AM-1017-03 | 17E | AM | 10172018 | 3 | Adult | Gray | Gray+ | Above Ground | 9 | Tree trunk | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9677054870327 40.778992870166) | 19 | 4 | 19 | 13 | |||||
794 | 794 | -73.9790010565108 | 40.7685732369544 | 2C-PM-1013-09 | 02C | PM | 10132018 | 9 | Adult | + | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9790010565108 40.7685732369544) | 19 | 4 | 19 | 13 | |||||||
801 | 801 | -73.9743342303548 | 40.7727742948332 | 8D-AM-1007-08 | 08D | AM | 10072018 | 8 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | false | false | false | communicating from tree | false | false | false | false | false | false | false | false | POINT (-73.97433423035481 40.7727742948332) | 19 | 4 | 19 | 13 | |||||
806 | 806 | -73.970475755546 | 40.7763348062134 | 13E-AM-1017-02 | 13E | AM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | begging (came one yard away from me and stood there) | false | false | false | false | false | true | false | false | POINT (-73.970475755546 40.7763348062134) | 19 | 4 | 19 | 13 | |||||
819 | 819 | -73.9603620122205 | 40.7955965755851 | 36B-AM-1013-02 | 36B | AM | 10132018 | 2 | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | didn't see me | POINT (-73.9603620122205 40.7955965755851) | 19 | 4 | 19 | 13 | ||||||
828 | 828 | -73.9545101041865 | 40.7903823616782 | 34I-PM-1010-03 | 34I | PM | 10102018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | in the playground. | true | false | false | false | true | with some nuts in the mouth | false | false | false | false | false | false | false | false | POINT (-73.9545101041865 40.7903823616782) | 19 | 4 | 19 | 13 | ||||
838 | 838 | -73.9691031094688 | 40.7706693835189 | 9I-AM-1014-02 | 09I | AM | 10142018 | 2 | Adult | Gray | Gray+ | Very far, so appx | Above Ground | 35 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9691031094688 40.7706693835189) | 19 | 4 | 19 | 13 | |||||
849 | 849 | -73.9736165917399 | 40.7724543901497 | 8D-AM-1007-04 | 08D | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | false | true | false | false | false | chasing squirrel #3 | false | false | false | false | false | false | false | false | POINT (-73.9736165917399 40.7724543901497) | 19 | 4 | 19 | 13 | |||||
850 | 850 | -73.9642288873015 | 40.7820439983567 | 22F-AM-1007-06 | 22F | AM | 10072018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | true | false | false | POINT (-73.9642288873015 40.7820439983567) | 19 | 4 | 19 | 13 | ||||||
861 | 861 | -73.953287300494 | 40.793520326789 | 37H-PM-1006-04 | 37H | PM | 10062018 | 4 | + | Above Ground | 43 | tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.953287300494 40.793520326789) | 19 | 4 | 19 | 13 | |||||||
866 | 866 | -73.9792091200122 | 40.7685845475313 | 2B-PM-1013-06 | 02B | PM | 10132018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | true | false | false | sat there! in front of us | POINT (-73.9792091200122 40.7685845475313) | 19 | 4 | 19 | 13 | |||||
872 | 872 | -73.9551524422379 | 40.7910535596756 | 34H-PM-1006-01 | 34H | PM | 10062018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9551524422379 40.7910535596756) | 19 | 4 | 19 | 13 | ||||||
876 | 876 | -73.9672789573537 | 40.7874778720268 | 26A-PM-1006-02 | 26A | PM | 10062018 | 2 | Juvenile | Gray | Gray+ | injured | Ground Plane | FALSE | false | false | false | false | false | not moving | false | false | false | false | false | false | false | false | POINT (-73.96727895735371 40.7874778720268) | 19 | 4 | 19 | 13 | ||||
882 | 882 | -73.9786805884996 | 40.7697559231927 | 4B-PM-1018-02 | 04B | PM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9786805884996 40.7697559231927) | 19 | 4 | 19 | 13 | ||||||
889 | 889 | -73.9681042612938 | 40.772331431865 | 11I-PM-1012-04 | 11I | PM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9681042612938 40.772331431865) | 19 | 4 | 19 | 13 | ||||||
896 | 896 | -73.9755055978764 | 40.7707438681742 | 6D-AM-1008-02 | 06D | AM | 10082018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 10 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9755055978764 40.7707438681742) | 19 | 4 | 19 | 13 | ||||||
903 | 903 | -73.9719941577406 | 40.77037129313 | 7G-AM-1010-04 | 07G | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9719941577406 40.77037129313) | 19 | 4 | 19 | 13 | ||||||
904 | 904 | -73.9531013359625 | 40.7921223556535 | 36I-PM-1007-04 | 36I | PM | 10072018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9531013359625 40.7921223556535) | 19 | 4 | 19 | 13 | ||||||
919 | 919 | -73.9637279711853 | 40.7905198502307 | 30B-AM-1007-09 | 30B | AM | 10072018 | 9 | Adult | Gray | Gray+ | Above Ground | 50 | false | false | true | false | false | jumping b/w trees | false | false | false | false | false | false | false | false | POINT (-73.9637279711853 40.7905198502307) | 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 );