This data as json, CSV (advanced)
Suggested facets: Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Other Interactions, 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 | ||||
36 | 36 | -73.9662438996681 | 40.7890381809441 | 28A-PM-1007-05 | 28A | PM | 10072018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9662438996681 40.7890381809441) | 19 | 4 | 19 | 13 | ||||||
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 | |||||
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 | ||||||
87 | 87 | -73.9541453465817 | 40.7982162223764 | 42E-PM-1012-06 | 42E | PM | 10122018 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9541453465817 40.79821622237641) | 19 | 4 | 19 | 13 | |||||
95 | 95 | -73.9692883970928 | 40.7768553703082 | 14E-AM-1008-02 | 14E | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | walking | false | false | false | false | false | false | false | true | POINT (-73.9692883970928 40.7768553703082) | 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 | ||||||
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 | |||||
181 | 181 | -73.9708775864433 | 40.772473633538 | 10F-PM-1019-12 | 10F | PM | 10192018 | 12 | Adult | Black | White | Black+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9708775864433 40.772473633538) | 19 | 4 | 19 | 13 | |||||
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 | ||||
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 | |||||
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 | ||||
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 | |||||
312 | 312 | -73.958356112357 | 40.796014459571 | 38C-AM-1019-07 | 38C | AM | 10192018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.958356112357 40.796014459571) | 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 | ||||||
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 | |||||
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 | ||||
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 | |||||
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 | |||||
403 | 403 | -73.9597470659927 | 40.7973215935416 | 38A-PM-1013-01 | 38A | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9597470659927 40.7973215935416) | 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 | ||||
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 | ||||
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 | |||||
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 | |||
513 | 513 | -73.963100689807 | 40.7920255189467 | 32B-AM-1017-02 | 32B | AM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon on its head | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.963100689807 40.79202551894671) | 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 | ||||||
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 | |||
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 | |||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | ||||
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 | ||||||
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 | |||||
697 | 697 | -73.970465600402 | 40.7701125773248 | 7H-PM-1006-05 | 07H | PM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Ran across path to eat behind fence, next to the fence. | true | false | false | true | true | false | false | false | false | true | false | false | true | POINT (-73.970465600402 40.7701125773248) | 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 | |||
706 | 706 | -73.9570132570934 | 40.7932014159087 | 35F-PM-1012-01 | 35F | PM | 10122018 | 1 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | true | false | false | true | true | POINT (-73.9570132570934 40.7932014159087) | 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 | |||||
743 | 743 | -73.9565035705619 | 40.7937382705056 | 36F-AM-1017-04 | 36F | AM | 10172018 | 4 | Juvenile | Gray | White | Gray+White | White legs, front & back | Ground Plane | FALSE | true | false | false | true | true | true | false | false | false | false | true | false | true | approaches (me),runs from (me) | POINT (-73.9565035705619 40.7937382705056) | 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 | |||||
804 | 804 | -73.9697196619878 | 40.7814068507607 | 19B-AM-1019-01 | 19B | AM | 10192018 | 1 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Side stripes | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | true | indifferent then runs from | POINT (-73.9697196619878 40.7814068507607) | 19 | 4 | 19 | 13 | |||
824 | 824 | -73.9606344681252 | 40.7958337780644 | 37B-PM-1013-04 | 37B | PM | 10132018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9606344681252 40.795833778064406) | 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 | |||||
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 | ||||||
888 | 888 | -73.9674177504573 | 40.7769569731993 | 15G-PM-1019-03 | 15G | PM | 10192018 | 3 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9674177504573 40.7769569731993) | 19 | 4 | 19 | 13 | ||||||
898 | 898 | -73.9542828053256 | 40.7941797320355 | 37G-AM-1014-03 | 37G | AM | 10142018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9542828053256 40.7941797320355) | 19 | 4 | 19 | 13 | ||||||
902 | 902 | -73.969105907 | 40.7820474909192 | 20B-PM-1013-08 | 20B | PM | 10132018 | 8 | Adult | Gray | White | Gray+White | (very brown) | Ground Plane | FALSE | true | false | false | false | false | being chased by dog | false | false | false | false | false | false | false | true | POINT (-73.969105907 40.7820474909192) | 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 | ||||
930 | 930 | -73.9622030085794 | 40.7917723228749 | 32B-AM-1017-01 | 32B | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | ran up a tree | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9622030085794 40.7917723228749) | 19 | 4 | 19 | 13 | ||||
932 | 932 | -73.9718597156773 | 40.7765858763313 | 13C-PM-1019-04 | 13C | PM | 10192018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9718597156773 40.7765858763313) | 19 | 4 | 19 | 13 | ||||||
943 | 943 | -73.9773096718574 | 40.7738053862489 | 8A-AM-1013-06 | 08A | AM | 10132018 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9773096718574 40.7738053862489) | 19 | 4 | 19 | 13 | |||||
951 | 951 | -73.971791854883 | 40.7802971729784 | 17B-PM-1012-01 | 17B | PM | 10122018 | 1 | Adult | Gray | Gray+ | Above Ground | 2 | climbed a fence | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.971791854883 40.7802971729784) | 19 | 4 | 19 | 13 | |||||
955 | 955 | -73.960657061561 | 40.7956150744102 | 36A-PM-1013-08 | 36A | PM | 10132018 | 8 | Gray | Gray+ | Ground Plane | FALSE | "FIELD" | true | false | false | false | false | running from #7 | false | false | false | false | false | false | false | true | POINT (-73.960657061561 40.7956150744102) | 19 | 4 | 19 | 13 | |||||
963 | 963 | -73.9621066718851 | 40.7942427079733 | 34A-AM-1012-03 | 34A | AM | 10122018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9621066718851 40.7942427079733) | 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 | |||||
972 | 972 | -73.9704591091677 | 40.7729175143429 | 10G-AM-1006-02 | 10G | AM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | notch on tail | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9704591091677 40.7729175143429) | 19 | 4 | 19 | 13 | ||||
974 | 974 | -73.9753744539307 | 40.7671162211032 | 2F-PM-1014-12 | 02F | PM | 10142018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.97537445393071 40.7671162211032) | 19 | 4 | 19 | 13 | ||||||
979 | 979 | -73.9612349421547 | 40.7959586475744 | 36A-PM-1013-09 | 36A | PM | 10132018 | 9 | Gray | Gray+ | Ground Plane | FALSE | THICK UNDERGROWTH | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9612349421547 40.7959586475744) | 19 | 4 | 19 | 13 | ||||||
987 | 987 | -73.9649827807341 | 40.7817322832767 | 21F-AM-1018-06 | 21F | AM | 10182018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9649827807341 40.7817322832767) | 19 | 4 | 19 | 13 | |||||
993 | 993 | -73.9772422664657 | 40.773436329163 | 8A-AM-1013-02 | 08A | AM | 10132018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | playground | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9772422664657 40.773436329163) | 19 | 4 | 19 | 13 | ||||
1019 | 1019 | -73.9704269630964 | 40.7722964640257 | 10G-AM-1006-09 | 10G | AM | 10062018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9704269630964 40.7722964640257) | 19 | 4 | 19 | 13 | |||||
1029 | 1029 | -73.9601259189134 | 40.7955350609057 | 36B-PM-1013-04 | 36B | PM | 10132018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9601259189134 40.7955350609057) | 19 | 4 | 19 | 13 | ||||||
1040 | 1040 | -73.9702588981432 | 40.776610754288 | 14E-AM-1008-08 | 14E | AM | 10082018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9702588981432 40.776610754288) | 19 | 4 | 19 | 13 | ||||||
1049 | 1049 | -73.9564606426367 | 40.7880546572608 | 30I-PM-1006-06 | 30I | PM | 10062018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | true | ran up tree | POINT (-73.9564606426367 40.7880546572608) | 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 | ||||||
1054 | 1054 | -73.9570050460867 | 40.7985192250745 | 40C-AM-1017-05 | 40C | AM | 10172018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9570050460867 40.7985192250745) | 19 | 4 | 19 | 13 | |||||
1059 | 1059 | -73.9749457516921 | 40.7676712372245 | 3F-PM-1013-07 | 03F | PM | 10132018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9749457516921 40.7676712372245) | 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 | |||||||
1070 | 1070 | -73.9674631254594 | 40.7790076357696 | 17E-AM-1017-10 | 17E | AM | 10172018 | 10 | Juvenile | Gray | Gray+ | Above Ground | 2 | Fence | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9674631254594 40.7790076357696) | 19 | 4 | 19 | 13 | |||||
1075 | 1075 | -73.9640534906634 | 40.7777383899836 | 17I-AM-1014-02 | 17I | AM | 10142018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | standing upright | false | false | false | false | false | true | false | true | runs from (only ran away when a grandpa chased it off) | POINT (-73.9640534906634 40.7777383899836) | 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 |
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 );