This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Highlight 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, Indifferent, Zip Codes, City Council Districts, Police Precincts
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | 2 | -73.9570437717691 | 40.7948509408039 | 37E-PM-1006-03 | 37E | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | me | POINT (-73.9570437717691 40.794850940803904) | 19 | 4 | 19 | 13 | ||||
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 | ||||||
27 | 27 | -73.9670628558161 | 40.7734991420941 | 12I-AM-1013-01 | 12I | AM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | on tree roots | false | false | false | false | false | sitting | false | false | false | false | true | false | false | true | POINT (-73.9670628558161 40.77349914209411) | 19 | 4 | 19 | 13 | |||
41 | 41 | -73.9639159298446 | 40.7891774637988 | 29C-AM-1007-06 | 29C | AM | 10072018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9639159298446 40.7891774637988) | 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 | |||||
78 | 78 | -73.964474836001 | 40.7883840104749 | 28C-PM-1006-01 | 28C | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | gathering acorns | false | false | false | true | false | false | false | true | gnd to tree | POINT (-73.964474836001 40.7883840104749) | 19 | 4 | 19 | 13 | |||
80 | 80 | -73.9688454483585 | 40.7845301288163 | 22A-AM-1008-05 | 22A | AM | 10082018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 3 | trash can | false | false | false | true | false | false | false | false | true | false | false | false | true | POINT (-73.9688454483585 40.7845301288163) | 19 | 4 | 19 | 13 | ||||
83 | 83 | -73.9617088749928 | 40.7944585082367 | 35A-PM-1013-06 | 35A | PM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9617088749928 40.7944585082367) | 19 | 4 | 19 | 13 | ||||||
84 | 84 | -73.9701824825872 | 40.7766530579293 | 14E-AM-1008-09 | 14E | AM | 10082018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | true | false | false | false | false | false | false | true | POINT (-73.9701824825872 40.7766530579293) | 19 | 4 | 19 | 13 | ||||||
98 | 98 | -73.9730277911422 | 40.7712145488828 | 7F-AM-1008-16 | 07F | AM | 10082018 | 16 | Juvenile | Gray | Gray+ | Above Ground | 2 | tree | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9730277911422 40.7712145488828) | 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 | |||
103 | 103 | -73.9607701370443 | 40.7955418990855 | 36A-PM-1013-07 | 36A | PM | 10132018 | 7 | Gray | Gray+ | Ground Plane | FALSE | "FIELD" | false | true | false | false | false | chasing #8 | false | false | false | false | false | false | false | true | POINT (-73.9607701370443 40.7955418990855) | 19 | 4 | 19 | 13 | |||||
107 | 107 | -73.9521110154872 | 40.7978449143313 | 42G-AM-1018-03 | 42G | AM | 10182018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | stop to look at me—then ran | false | false | false | false | false | false | false | true | POINT (-73.9521110154872 40.7978449143313) | 19 | 4 | 19 | 13 | ||||
109 | 109 | -73.967097592707 | 40.7854119342538 | 24B-AM-1013-01 | 24B | AM | 10132018 | 1 | Gray | Gray+ | Above Ground | 50 | true | false | false | true | false | took nut to bury | false | false | false | false | true | false | false | true | POINT (-73.967097592707 40.7854119342538) | 19 | 4 | 19 | 13 | ||||||
110 | 110 | -73.9711318790279 | 40.7701941550273 | 7G-AM-1010-02 | 07G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9711318790279 40.7701941550273) | 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 | ||||||
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 | |||||
150 | 150 | -73.9763430829342 | 40.7686351097159 | 4D-PM-1008-11 | 04D | PM | 10082018 | 11 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | on tree facing downward | false | true | false | false | false | chased #12 | true | false | false | true | false | false | false | true | POINT (-73.9763430829342 40.7686351097159) | 19 | 4 | 19 | 13 | |||
159 | 159 | -73.9638270331336 | 40.7810450065235 | 21G-PM-1007-02 | 21G | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | false | false | true | POINT (-73.9638270331336 40.7810450065235) | 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 | ||||
170 | 170 | -73.9597205966324 | 40.7969409510133 | 38B-AM-1019-01 | 38B | AM | 10192018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9597205966324 40.7969409510133) | 19 | 4 | 19 | 13 | |||||
187 | 187 | -73.9700162034073 | 40.7815277479588 | 19B-AM-1019-02 | 19B | AM | 10192018 | 2 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | false | posing | false | false | false | false | false | false | true | true | indifferent then runs from | POINT (-73.9700162034073 40.7815277479588) | 19 | 4 | 19 | 13 | |||
193 | 193 | -73.9537691298752 | 40.7941272599797 | 38G-PM-1020-01 | 38G | PM | 10202018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9537691298752 40.7941272599797) | 19 | 4 | 19 | 13 | |||||
209 | 209 | -73.9710760196868 | 40.7725506006789 | 10F-PM-1019-02 | 10F | PM | 10192018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Cinnamon head & stripe | Ground Plane | FALSE | Behind fence, grass | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9710760196868 40.7725506006789) | 19 | 4 | 19 | 13 | |||
224 | 224 | -73.9520592496349 | 40.7975076299811 | 42G-PM-1014-03 | 42G | PM | 10142018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | on fence | true | false | false | false | false | prancing | false | false | false | false | false | false | false | true | POINT (-73.9520592496349 40.7975076299811) | 19 | 4 | 19 | 13 | |||
225 | 225 | -73.963842266151 | 40.7887340867773 | 28C-PM-1006-02 | 28C | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | Near rock | true | false | false | false | false | false | false | false | false | false | false | false | true | dog | POINT (-73.963842266151 40.7887340867773) | 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 | |||||
237 | 237 | -73.967895656898 | 40.7767409597341 | 15F-PM-1010-07 | 15F | PM | 10102018 | 7 | Adult | Gray | Gray+ | Above Ground | 3 | on fence | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.967895656898 40.7767409597341) | 19 | 4 | 19 | 13 | |||||
244 | 244 | -73.9597648775789 | 40.7903443029725 | 32E-AM-1007-01 | 32E | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9597648775789 40.7903443029725) | 19 | 4 | 19 | 13 | ||||||
250 | 250 | -73.9726747666002 | 40.7703022669308 | 7F-AM-1008-02 | 07F | AM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | see stories and locations | POINT (-73.9726747666002 40.7703022669308) | 19 | 4 | 19 | 13 | ||||
258 | 258 | -73.9534333425633 | 40.7932564163328 | 37H-AM-1018-03 | 37H | AM | 10182018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | in a tree with red berries | false | false | false | true | false | false | true | false | false | false | false | false | true | POINT (-73.9534333425633 40.7932564163328) | 19 | 4 | 19 | 13 | ||||
265 | 265 | -73.9691094942294 | 40.776760392858 | 14E-AM-1008-01 | 14E | AM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | walking | false | false | false | false | false | false | false | true | POINT (-73.9691094942294 40.776760392858) | 19 | 4 | 19 | 13 | |||||
277 | 277 | -73.9619070229674 | 40.79525566925 | 35A-AM-1014-05 | 35A | AM | 10142018 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9619070229674 40.79525566925) | 19 | 4 | 19 | 13 | |||||
284 | 284 | -73.9547336666137 | 40.7938937756332 | 37G-PM-1007-07 | 37G | PM | 10072018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9547336666137 40.7938937756332) | 19 | 4 | 19 | 13 | |||||
316 | 316 | -73.9540616660191 | 40.7951556603245 | 38G-PM-1020-10 | 38G | PM | 10202018 | 10 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9540616660191 40.7951556603245) | 19 | 4 | 19 | 13 | |||||
322 | 322 | -73.9546042927016 | 40.7898133734952 | 33I-PM-1006-07 | 33I | PM | 10062018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9546042927016 40.7898133734952) | 19 | 4 | 19 | 13 | ||||||
331 | 331 | -73.95448101115 | 40.7954469678857 | 39F-PM-1006-03 | 39F | PM | 10062018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 15 | lower branch of tree | false | false | false | true | false | false | false | false | false | false | false | false | true | ran up tree when approached | POINT (-73.95448101115 40.7954469678857) | 19 | 4 | 19 | 13 | |||
337 | 337 | -73.9583101927652 | 40.7852649316039 | 27I-PM-1020-05 | 27I | PM | 10202018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | In tree | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (us) | POINT (-73.9583101927652 40.7852649316039) | 19 | 4 | 19 | 13 | |||
338 | 338 | -73.9765595553183 | 40.7748455340432 | 10A-PM-1014-04 | 10A | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9765595553183 40.7748455340432) | 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 | ||||||
356 | 356 | -73.9761036400144 | 40.7705482684594 | 6D-PM-1020-03 | 06D | PM | 10202018 | 3 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9761036400144 40.7705482684594) | 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 | |||||
365 | 365 | -73.9576035072364 | 40.7966120824816 | 38C-AM-1019-01 | 38C | AM | 10192018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (lawnmower) | POINT (-73.9576035072364 40.7966120824816) | 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 | ||||
381 | 381 | -73.959709414696 | 40.7919745085986 | 33D-PM-1006-03 | 33D | PM | 10062018 | 3 | Black | Black+ | Above Ground | 15 | true | false | false | true | false | false | false | false | false | true | false | false | true | ran up tree | POINT (-73.959709414696 40.7919745085986) | 19 | 4 | 19 | 13 | ||||||
386 | 386 | -73.9550351380957 | 40.7974681522214 | 40E-AM-1014-01 | 40E | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9550351380957 40.7974681522214) | 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 | ||||||
409 | 409 | -73.9530809650496 | 40.7959176317705 | 40G-PM-1013-02 | 40G | PM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | hiding from dog | false | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.9530809650496 40.79591763177051) | 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 | ||||||
417 | 417 | -73.9639888092327 | 40.791449395909 | 31A-AM-1010-01 | 31A | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9639888092327 40.791449395909005) | 19 | 4 | 19 | 13 | ||||||
421 | 421 | -73.9664630067791 | 40.7756361515825 | 14H-AM-1007-04 | 14H | AM | 10072018 | 4 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9664630067791 40.7756361515825) | 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 | |||||
434 | 434 | -73.9676639740486 | 40.7745369616499 | 13H-PM-1010-07 | 13H | PM | 10102018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9676639740486 40.7745369616499) | 19 | 4 | 19 | 13 | ||||||
464 | 464 | -73.9664450399121 | 40.7887844904695 | 27A-AM-1008-02 | 27A | AM | 10082018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9664450399121 40.7887844904695) | 19 | 4 | 19 | 13 | |||||
493 | 493 | -73.9776854797916 | 40.7683102295663 | 3D-AM-1006-04 | 03D | AM | 10062018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (boy on bike) | POINT (-73.9776854797916 40.7683102295663) | 19 | 4 | 19 | 13 | ||||
497 | 497 | -73.9602166876979 | 40.7953811003986 | 36B-AM-1013-04 | 36B | AM | 10132018 | 4 | Black | Black+ | Above Ground | 20 | Moved 20+ feet high above top of tree limb | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9602166876979 40.7953811003986) | 19 | 4 | 19 | 13 | ||||||
501 | 501 | -73.9708798496132 | 40.7761532088521 | 13D-AM-1014-06 | 13D | AM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9708798496132 40.7761532088521) | 19 | 4 | 19 | 13 | |||||
503 | 503 | -73.9598340783572 | 40.7915857030295 | 33D-PM-1006-02 | 33D | PM | 10062018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.95983407835722 40.7915857030295) | 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 | ||||||
522 | 522 | -73.9773821135611 | 40.7690453494383 | 4C-PM-1010-06 | 04C | PM | 10102018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | behind playground benches | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9773821135611 40.7690453494383) | 19 | 4 | 19 | 13 | ||||
526 | 526 | -73.9680833729772 | 40.7741871025115 | 12H-PM-1007-08 | 12H | PM | 10072018 | 8 | + | Above Ground | 7 | in tree | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9680833729772 40.7741871025115) | 19 | 4 | 19 | 13 | |||||||
528 | 528 | -73.9647284206644 | 40.7839611840884 | 23E-PM-1006-01 | 23E | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on a tree | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9647284206644 40.7839611840884) | 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 | |||||
536 | 536 | -73.9561141662309 | 40.7976258458604 | 40D-PM-1013-05 | 40D | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9561141662309 40.7976258458604) | 19 | 4 | 19 | 13 | |||||
547 | 547 | -73.9559677963727 | 40.7951124076946 | 38E-AM-1010-07 | 38E | AM | 10102018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | branches | true | true | false | false | false | chasing and being chased by #6 | false | false | false | false | true | false | false | true | POINT (-73.9559677963727 40.7951124076946) | 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 | ||||
568 | 568 | -73.9799441493404 | 40.7671499997527 | 1C-AM-1012-01 | 01C | AM | 10122018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9799441493404 40.7671499997527) | 12081 | 11 | 4 | 51 | 10 | |||
574 | 574 | -73.9706360005275 | 40.7717074044466 | 9G-PM-1007-05 | 09G | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9706360005275 40.7717074044466) | 19 | 4 | 19 | 13 | |||||
581 | 581 | -73.9556218199258 | 40.7980460204041 | 41D-PM-1014-01 | 41D | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | digging,drinking | false | false | false | false | false | false | false | true | POINT (-73.9556218199258 40.7980460204041) | 19 | 4 | 19 | 13 | ||||
583 | 583 | -73.9612398509782 | 40.7950033150385 | 35A-PM-1013-12 | 35A | PM | 10132018 | 12 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9612398509782 40.7950033150385) | 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 | ||||||
598 | 598 | -73.9698196671161 | 40.7802972001469 | 18C-PM-1018-03 | 18C | PM | 10182018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 1 | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9698196671161 40.7802972001469) | 19 | 4 | 19 | 13 | ||||||
602 | 602 | -73.9685751595485 | 40.7709413567859 | 9I-PM-1010-07 | 09I | PM | 10102018 | 7 | Adult | Gray | White | Gray+White | Above Ground | 1 | ran up tree | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9685751595485 40.7709413567859) | 19 | 4 | 19 | 13 | ||||
612 | 612 | -73.9629420113622 | 40.789133072717 | 29C-AM-1007-03 | 29C | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9629420113622 40.789133072717) | 19 | 4 | 19 | 13 | |||||
615 | 615 | -73.9653279069888 | 40.7758743113817 | 15I-AM-1008-02 | 15I | AM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Could be same squirrel as #1? | Above Ground | 4 | on fence | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9653279069888 40.7758743113817) | 19 | 4 | 19 | 13 | |||
618 | 618 | -73.957976896139 | 40.797027128241 | 39C-AM-1017-04 | 39C | AM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.957976896139 40.797027128241005) | 19 | 4 | 19 | 13 | ||||||
623 | 623 | -73.9662939630722 | 40.7878502338031 | 26B-AM-1010-01 | 26B | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | running across bridle path | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9662939630722 40.7878502338031) | 19 | 4 | 19 | 13 | |||||
627 | 627 | -73.9763791121438 | 40.770281512254 | 5D-PM-1018-04 | 05D | PM | 10182018 | 4 | Adult | Gray | White | Gray+White | Partial missing tail | Ground Plane | FALSE | false | true | false | false | false | chasing (dog chasing) | false | false | false | false | false | false | false | true | POINT (-73.9763791121438 40.770281512254) | 19 | 4 | 19 | 13 | |||
628 | 628 | -73.9600165785486 | 40.7952466761832 | 36B-PM-1013-03 | 36B | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9600165785486 40.7952466761832) | 19 | 4 | 19 | 13 | |||||
629 | 629 | -73.9573724133264 | 40.7980080911115 | 40C-AM-1017-02 | 40C | AM | 10172018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | true | false | true | false | chasing (#1) | false | false | false | false | false | false | false | true | POINT (-73.9573724133264 40.7980080911115) | 19 | 4 | 19 | 13 | ||||
630 | 630 | -73.9580109357087 | 40.7855654405447 | 28I-AM-1013-01 | 28I | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Jumped onto path & then back into brush | false | false | false | false | false | stood on fence | false | false | false | false | false | false | false | true | POINT (-73.9580109357087 40.7855654405447) | 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 | ||||
650 | 650 | -73.9809610117171 | 40.7683896665502 | 2A-AM-1010-02 | 02A | AM | 10102018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | perched on small fence | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9809610117171 40.7683896665502) | 19 | 4 | 19 | 13 | ||||||
652 | 652 | -73.9570056123953 | 40.7878756067582 | 30I-PM-1006-02 | 30I | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9570056123953 40.7878756067582) | 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 | |||||
671 | 671 | -73.9709244006956 | 40.7676942639697 | 5I-AM-1010-02 | 05I | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9709244006956 40.7676942639697) | 19 | 4 | 19 | 13 | ||||||
683 | 683 | -73.9707683621584 | 40.7759815566123 | 13E-AM-1017-11 | 13E | AM | 10172018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on/in log | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9707683621584 40.77598155661231) | 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 | ||||||
703 | 703 | -73.9576304473722 | 40.7959810622342 | 38D-AM-1017-05 | 38D | AM | 10172018 | 5 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Black stripe along sides | Ground Plane | FALSE | true | false | false | true | false | eating (nut) | false | false | false | false | false | false | false | true | POINT (-73.9576304473722 40.7959810622342) | 19 | 4 | 19 | 13 | |||
713 | 713 | -73.956200809768 | 40.798181446265 | 40C-AM-1017-06 | 40C | AM | 10172018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.956200809768 40.798181446265) | 19 | 4 | 19 | 13 | |||||
717 | 717 | -73.9574749571848 | 40.7981898890735 | 40C-PM-1006-08 | 40C | PM | 10062018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | By the main road | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9574749571848 40.7981898890735) | 19 | 4 | 19 | 13 | |||||
720 | 720 | -73.9669814346326 | 40.780390919948 | 19E-PM-1018-01 | 19E | PM | 10182018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9669814346326 40.780390919948) | 19 | 4 | 19 | 13 | |||||
724 | 724 | -73.9532952763106 | 40.7920074462622 | 36I-AM-1017-08 | 36I | AM | 10172018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | chasing (#7) | false | false | false | false | true | false | false | true | runs from (me) | POINT (-73.95329527631061 40.7920074462622) | 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 );