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, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1891 | 1891 | -73.9749641575871 | 40.7673305056277 | 3F-AM-1006-05 | 03F | AM | 10062018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9749641575871 40.7673305056277) | 19 | 4 | 19 | 13 | |||||
391 | 391 | -73.9790875480358 | 40.7676104780657 | 2C-AM-1010-03 | 02C | AM | 10102018 | 3 | Adult | Black | Gray | Black+Gray | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9790875480358 40.7676104780657) | 19 | 4 | 19 | 13 | |||||
2583 | 2583 | -73.9769693140651 | 40.7684390015166 | 3D-AM-1006-01 | 03D | AM | 10062018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 9 | up a tree | true | false | true | true | true | digging (?) | false | false | false | true | false | false | false | true | runs from (man led his dog into the area to chase squirrel) | POINT (-73.9769693140651 40.7684390015166) | 19 | 4 | 19 | 13 | ||
2280 | 2280 | -73.9767143644151 | 40.7684756941321 | 3D-AM-1006-02 | 03D | AM | 10062018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 25 | tree | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9767143644151 40.7684756941321) | 19 | 4 | 19 | 13 | ||||
377 | 377 | -73.9757001944781 | 40.769499790547 | 5E-AM-1008-09 | 05E | AM | 10082018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | went up tree | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9757001944781 40.769499790547) | 19 | 4 | 19 | 13 | ||||
1799 | 1799 | -73.978844141973 | 40.7696046074378 | 4B-AM-1010-05 | 04B | AM | 10102018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | false | true | false | false | false | chasing squirrel #6 | true | true | false | false | true | false | false | false | POINT (-73.978844141973 40.7696046074378) | 19 | 4 | 19 | 13 | ||||
2521 | 2521 | -73.976869549792 | 40.7706982454723 | 5C-AM-1006-04 | 05C | AM | 10062018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 12 | thin branch of tree | false | false | false | false | false | relaxing | false | false | false | true | false | false | true | false | POINT (-73.976869549792 40.7706982454723) | 19 | 4 | 19 | 13 | |||
1226 | 1226 | -73.97684509717 | 40.7709430375069 | 5C-PM-1010-07 | 05C | PM | 10102018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 13 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.97684509717 40.7709430375069) | 19 | 4 | 19 | 13 | |||||
2646 | 2646 | -73.9772239251936 | 40.7731716665766 | 8A-AM-1013-05 | 08A | AM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | true | false | true | true | false | false | false | false | false | false | true | false | false | POINT (-73.9772239251936 40.7731716665766) | 19 | 4 | 19 | 13 | |||||
399 | 399 | -73.9763433202401 | 40.7738473490681 | 9B-PM-1013-10 | 09B | PM | 10132018 | 10 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | "Brown" written in as Primary | Above Ground | 12 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9763433202401 40.7738473490681) | 19 | 4 | 19 | 13 | ||||
788 | 788 | -73.9687476703117 | 40.7742856696093 | 12G-AM-1012-01 | 12G | AM | 10122018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9687476703117 40.7742856696093) | 19 | 4 | 19 | 13 | |||||
695 | 695 | -73.9685080639873 | 40.7745309794155 | 13G-PM-1008-03 | 13G | PM | 10082018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | maple tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9685080639873 40.77453097941551) | 19 | 4 | 19 | 13 | ||||
1135 | 1135 | -73.9667474482967 | 40.7760643720793 | 15H-PM-1008-01 | 15H | PM | 10082018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | Oak tree | false | true | false | false | false | watching me | false | true | false | true | false | false | false | false | observant | POINT (-73.9667474482967 40.7760643720793) | 19 | 4 | 19 | 13 | ||
1003 | 1003 | -73.9645547556826 | 40.776877007081 | 16I-AM-1008-04 | 16I | AM | 10082018 | 4 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 9 | tree hollow | false | false | false | false | false | in hollow | false | false | false | false | false | false | false | false | curious | POINT (-73.9645547556826 40.776877007081) | 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 | |||||
1680 | 1680 | -73.9638167248251 | 40.7776485679354 | 18I-PM-1007-03 | 18I | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 25 | false | false | true | false | false | false | false | false | false | false | false | false | false | stared at me | POINT (-73.9638167248251 40.77764856793541) | 19 | 4 | 19 | 13 | ||||
894 | 894 | -73.9675198230918 | 40.778631094685 | 17F-AM-1007-02 | 17F | AM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9675198230918 40.778631094685) | 19 | 4 | 19 | 13 | |||||
319 | 319 | -73.9659034359706 | 40.7797516688844 | 19F-AM-1007-02 | 19F | AM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 8 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9659034359706 40.77975166888441) | 19 | 4 | 19 | 13 | |||||
2927 | 2927 | -73.9650120066074 | 40.7805932882407 | 20F-PM-1007-13 | 20F | PM | 10072018 | 13 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9650120066074 40.78059328824071) | 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 | |||||
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 | |||||
2026 | 2026 | -73.9622752768962 | 40.7814921913101 | 22H-PM-1007-02 | 22H | PM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | low branch | false | false | false | false | false | watching me scratching | true | false | false | true | false | false | true | false | POINT (-73.9622752768962 40.7814921913101) | 19 | 4 | 19 | 13 | |||
588 | 588 | -73.9646597452128 | 40.7827698220703 | 22F-AM-1007-07 | 22F | AM | 10072018 | 7 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | false | false | true | false | false | false | false | false | false | true | false | false | false | alert & aware | POINT (-73.9646597452128 40.7827698220703) | 19 | 4 | 19 | 13 | ||||
2487 | 2487 | -73.9595222999173 | 40.7833202577782 | 25I-AM-1012-02 | 25I | AM | 10122018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 31 | on tree | true | true | false | false | false | false | false | false | true | true | false | true | false | POINT (-73.9595222999173 40.7833202577782) | 19 | 4 | 19 | 13 | ||||
166 | 166 | -73.963846339804 | 40.7834051716226 | 23F-AM-1018-01 | 23F | AM | 10182018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.963846339804 40.7834051716226) | 19 | 4 | 19 | 13 | |||||
780 | 780 | -73.9675472064204 | 40.7835947167436 | 22C-PM-1006-06 | 22C | PM | 10062018 | 6 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | on tree | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9675472064204 40.7835947167436) | 19 | 4 | 19 | 13 | ||||
384 | 384 | -73.968045072743 | 40.7836626717225 | 22C-AM-1013-02 | 22C | AM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | false | false | true | false | true | true | false | false | true | false | false | false | true | POINT (-73.968045072743 40.7836626717225) | 19 | 4 | 19 | 13 | |||||
1560 | 1560 | -73.9587072763996 | 40.7850256219415 | 27I-AM-1007-01 | 27I | AM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9587072763996 40.7850256219415) | 19 | 4 | 19 | 13 | |||||
789 | 789 | -73.9675023138703 | 40.7872554700995 | 25A-PM-1007-01 | 25A | PM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 40 | tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9675023138703 40.7872554700995) | 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 | |||||
261 | 261 | -73.9552861155228 | 40.788973931872 | 32I-AM-1013-05 | 32I | AM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | In and below shrub | false | false | true | false | true | false | false | false | true | false | false | true | false | POINT (-73.9552861155228 40.788973931872) | 19 | 4 | 19 | 13 | ||||
1017 | 1017 | -73.9552035011902 | 40.7889851896334 | 32I-AM-1013-06 | 32I | AM | 10132018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | In and below shrub | false | false | true | false | true | false | false | false | true | false | false | true | false | POINT (-73.9552035011902 40.7889851896334) | 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 | |||||
1145 | 1145 | -73.9611446263364 | 40.7911003407299 | 32D-AM-1013-03 | 32D | AM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9611446263364 40.7911003407299) | 19 | 4 | 19 | 13 | |||||
1351 | 1351 | -73.9610985171525 | 40.7913867116989 | 32D-AM-1013-01 | 32D | AM | 10132018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9610985171525 40.7913867116989) | 19 | 4 | 19 | 13 | |||||
1939 | 1939 | -73.9540151828782 | 40.7920066170587 | 35H-AM-1013-01 | 35H | AM | 10132018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | Climbing up tree | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9540151828782 40.7920066170587) | 19 | 4 | 19 | 13 | ||||
1103 | 1103 | -73.9541500874008 | 40.7920329989756 | 35H-AM-1013-02 | 35H | AM | 10132018 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | Sitting on tree limb | false | false | false | false | false | sitting | false | false | false | false | false | false | true | false | watching me from tree,but calm | POINT (-73.9541500874008 40.7920329989756) | 19 | 4 | 19 | 13 | ||
2912 | 2912 | -73.9632164738341 | 40.7921270121312 | 32B-PM-1010-03 | 32B | PM | 10102018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9632164738341 40.7921270121312) | 19 | 4 | 19 | 13 | |||||
1631 | 1631 | -73.9527196716568 | 40.792363826828 | 36I-PM-1007-11 | 36I | PM | 10072018 | 11 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | false | false | true | false | false | false | false | false | false | false | false | false | true | me! | POINT (-73.9527196716568 40.792363826828) | 19 | 4 | 19 | 13 | ||||
1253 | 1253 | -73.9527227282134 | 40.7935061484064 | 37I-AM-1010-03 | 37I | AM | 10102018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | in tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9527227282134 40.7935061484064) | 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 | ||||
2913 | 2913 | -73.9621297946132 | 40.7944058222814 | 34A-PM-1013-05 | 34A | PM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9621297946132 40.7944058222814) | 19 | 4 | 19 | 13 | |||||
525 | 525 | -73.952526164386 | 40.7963759240504 | 40G-AM-1007-02 | 40G | AM | 10072018 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 18 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.952526164386 40.7963759240504) | 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 | |||
2244 | 2244 | -73.9509628195532 | 40.7977775674178 | 42H-PM-1014-01 | 42H | PM | 10142018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | false | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9509628195532 40.7977775674178) | 12423 | 18 | 4 | 36 | 18 |
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 );