squirrels

161 rows where Hectare Squirrel Number = 7 sorted by Lat/Long

✎ View and edit SQL

This data as json, CSV (advanced)

Tail twitches ✖

Police Precincts ✖

Hectare Squirrel Number ✖

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
980 980 -73.9709817796369 40.7773554311586 14D-PM-1019-07 14D PM 10192018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9709817796369 40.7773554311586)   19 4 19 13
1897 1897 -73.97107389601 40.7723265810536 10F-PM-1019-07 10F PM 10192018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 Same tree (as #6) false false true false false   false false false false false false true false   POINT (-73.97107389601 40.7723265810536)   19 4 19 13
1791 1791 -73.9710907175834 40.77637391082 13D-AM-1014-07 13D AM 10142018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9710907175834 40.77637391082)   19 4 19 13
2304 2304 -73.9715251156965 40.774621784862 11E-PM-1012-07 11E PM 10122018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9715251156965 40.774621784862)   19 4 19 13
1338 1338 -73.9716624574422 40.7762037110101 13D-PM-1018-07 13D PM 10182018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   true false true false false scratching false false false false false false true false   POINT (-73.9716624574422 40.7762037110101)   19 4 19 13
1484 1484 -73.9716736557408 40.7749333494336 12E-AM-1017-07 12E AM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false true false false   false false false false true false false true   POINT (-73.9716736557408 40.7749333494336)   19 4 19 13
1438 1438 -73.971685475224 40.7706668465923 7G-PM-1018-07 07G PM 10182018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.971685475224 40.7706668465923)   19 4 19 13
301 301 -73.9717425494287 40.7664227676653 3I-PM-1013-07 03I PM 10132018 7 Adult Gray Black Gray+Black   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9717425494287 40.7664227676653)   19 4 19 13
2572 2572 -73.9719901848577 40.7720525965356 9F-PM-1014-07 09F PM 10142018 7 Adult Black   Black+ !!! Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9719901848577 40.7720525965356)   19 4 19 13
1066 1066 -73.9720174997123 40.7748894266027 11D-AM-1010-07 11D AM 10102018 7 Adult Black   Black+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9720174997123 40.7748894266027)   19 4 19 13
482 482 -73.9721797824576 40.7801213843628 16A-PM-1019-07 16A PM 10192018 7 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false true true false false approaches (very friendly) POINT (-73.9721797824576 40.7801213843628)   19 4 19 13
1814 1814 -73.9722359401242 40.7702891474555 7G-AM-1010-07 07G AM 10102018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9722359401242 40.7702891474555)   19 4 19 13
2372 2372 -73.9724879969884 40.771098202397 8F-PM-1012-07 08F PM 10122018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 17   false false true false false gathering false false false false false false false false   POINT (-73.9724879969884 40.771098202397)   19 4 19 13
664 664 -73.9725174868556 40.7664248283566 3H-PM-1014-07 03H PM 10142018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9725174868556 40.7664248283566)   19 4 19 13
2267 2267 -73.9727926335397 40.77037055775 7F-AM-1008-07 07F AM 10082018 7 Adult Gray   Gray+   Above Ground 28 next to the hole of #6 false false false false false standing false false false false false false true false   POINT (-73.9727926335397 40.77037055775)   19 4 19 13
1753 1753 -73.9733437449715 40.7782401548362 14B-PM-1014-07 14B PM 10142018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9733437449715 40.7782401548362)   19 4 19 13
879 879 -73.9735120882106 40.7715915415169 8E-PM-1008-07 08E PM 10082018 7 Adult Gray White Gray+White   Ground Plane FALSE 5, 6, 7 all at same tree trunk base false true true false false   false false false false false false false false   POINT (-73.9735120882106 40.7715915415169)   19 4 19 13
1245 1245 -73.9739326393775 40.7779105370473 14A-PM-1014-07 14A PM 10142018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9739326393775 40.7779105370473)   19 4 19 13
2707 2707 -73.9743165321099 40.7754674678574 11B-PM-1014-07 11B PM 10142018 7   Gray   Gray+   Above Ground 10   true false false true true   false false false false false false false false   POINT (-73.9743165321099 40.7754674678574)   19 4 19 13
2879 2879 -73.9744080700098 40.7731515721826 9C-PM-1006-07 09C PM 10062018 7 Adult Black Cinnamon, White Black+Cinnamon, White   Ground Plane FALSE on top of tarped sand pile false false false true false   false false false false false false false true (me) POINT (-73.9744080700098 40.7731515721826)   19 4 19 13
1243 1243 -73.9745556229855 40.7672921040998 3F-AM-1006-07 03F AM 10062018 7 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE close to tall tree & light post false false false false true   false false false false false false true false   POINT (-73.9745556229855 40.7672921040998)   19 4 19 13
722 722 -73.9745953710328 40.7728284025195 8D-AM-1007-07 08D AM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9745953710328 40.7728284025195)   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
761 761 -73.975062146111 40.7723417173451 8C-PM-1013-07 08C PM 10132018 7   Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.975062146111 40.7723417173451)   19 4 19 13
1771 1771 -73.9750688083336 40.7665584681025 2F-PM-1014-07 02F PM 10142018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9750688083336 40.7665584681025)   19 4 19 13
2831 2831 -73.9753585157592 40.7698398607941 5E-AM-1008-07 05E AM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 on fence false false false false true   false false false false false false true false   POINT (-73.9753585157592 40.7698398607941)   19 4 19 13
1687 1687 -73.9754790964561 40.768336388516 4E-PM-1008-07 04E PM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9754790964561 40.768336388516)   19 4 19 13
1861 1861 -73.9755562526811 40.7678821029525 3E-AM-1006-07 03E AM 10062018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false burying nuts false false false false false false false false   POINT (-73.9755562526811 40.7678821029525)   19 4 19 13
2986 2986 -73.9756533763813 40.7733537881363 8B-PM-1012-07 08B PM 10122018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9756533763813 40.7733537881363)   19 4 19 13
54 54 -73.9760298241178 40.7681954366911 3E-PM-1008-07 03E PM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9760298241178 40.7681954366911)   19 4 19 13
238 238 -73.9760942252437 40.7742035674209 9B-PM-1013-07 09B PM 10132018 7 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.97609422524371 40.7742035674209)   19 4 19 13
2189 2189 -73.9761776424664 40.7695941843825 5D-PM-1018-07 05D PM 10182018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9761776424664 40.7695941843825)   19 4 19 13
2778 2778 -73.9761799699276 40.774213409933 9B-AM-1010-07 09B AM 10102018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9761799699276 40.774213409933)   19 4 19 13
1209 1209 -73.9763159153138 40.7705785330431 5C-AM-1006-07 05C AM 10062018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9763159153138 40.7705785330431)   19 4 19 13
2784 2784 -73.9763722433833 40.7744121430891 9A-AM-1013-07 09A AM 10132018 7 Adult     +         false false false false false   false false false false false false false true   POINT (-73.9763722433833 40.7744121430891)   19 4 19 13
1217 1217 -73.9764850086767 40.7737340720562 8B-AM-1007-07 08B AM 10072018 7 Juvenile Gray Black Gray+Black   Above Ground 8   false false false true false holding nut false false false false false false true false   POINT (-73.9764850086767 40.7737340720562)   19 4 19 13
1862 1862 -73.9764851231754 40.7715736862861 6C-AM-1007-07 06C AM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false false ambling false false false false false true false true trucks POINT (-73.9764851231754 40.7715736862861)   19 4 19 13
1142 1142 -73.9765805609072 40.7692807820935 4D-PM-1008-07 04D PM 10082018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE hopped over fence and chased # 6 around tree & ran it to end of lawn true true false false false   false false false false false false true false   POINT (-73.9765805609072 40.7692807820935)   19 4 19 13
2513 2513 -73.9767590273554 40.7717561807266 6B-PM-1017-07 06B PM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true false false true   false false false false false false false false   POINT (-73.9767590273554 40.7717561807266)   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
2462 2462 -73.9768544488742 40.7680069500977 3D-AM-1006-07 03D AM 10062018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false running (with food in mouth) false false false false false false true false   POINT (-73.9768544488742 40.7680069500977)   19 4 19 13
1073 1073 -73.9769742179824 40.7727484521829 7B-AM-1008-07 07B AM 10082018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9769742179824 40.7727484521829)   19 4 19 13
1793 1793 -73.9771575249322 40.7673873716547 2E-AM-1010-07 02E AM 10102018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9771575249322 40.7673873716547)   19 4 19 13
1580 1580 -73.9775079672882 40.7691500357424 4C-PM-1010-07 04C PM 10102018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9775079672882 40.7691500357424)   19 4 19 13
1127 1127 -73.9776445567926 40.768119107973 3D-PM-1010-07 03D PM 10102018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9776445567926 40.768119107973)   19 4 19 13
2402 2402 -73.9777206733344 40.7668595585487 1D-PM-1007-07 01D PM 10072018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false false false lying down false false false false false false true false   POINT (-73.9777206733344 40.7668595585487)   19 4 19 13
2066 2066 -73.9784610031588 40.7668839966177 1D-AM-1006-07 01D AM 10062018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false true true   false false false false true false false false   POINT (-73.9784610031588 40.7668839966177)   19 4 19 13
816 816 -73.9785300509908 40.7721127748427 6A-AM-1006-07 06A AM 10062018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9785300509908 40.7721127748427)   19 4 19 13
640 640 -73.9785536529136 40.7716184505002 6A-PM-1012-07 06A PM 10122018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE elevated ground false true false false true   false false false false false false true false   POINT (-73.9785536529136 40.771618450500206)   19 4 19 13
407 407 -73.9787658435198 40.7689419765393 3B-PM-1007-07 03B PM 10072018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false eating loudly <- peanuts w/ shells false false false false false false true false   POINT (-73.9787658435198 40.7689419765393)   19 4 19 13
2297 2297 -73.9787771053108 40.769356212275 3B-AM-1010-07 03B AM 10102018 7 Adult Gray   Gray+   Above Ground 10   false false true false false together w/ #8 false false false true false false true false   POINT (-73.9787771053108 40.76935621227501)   19 4 19 13
1648 1648 -73.9790263372004 40.7683513714892 2C-PM-1013-07 02C PM 10132018 7 Adult Gray White Gray+White         true false false false true   false false false false false false false false   POINT (-73.9790263372004 40.7683513714892)   19 4 19 13
1236 1236 -73.9792039071114 40.7678749471267 2C-AM-1010-07 02C AM 10102018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true true false false false #7 & #8 chased each other up diff tree false false false false false false false true   POINT (-73.9792039071114 40.76787494712671)   19 4 19 13
2165 2165 -73.9794371709817 40.768387910254 2B-PM-1013-07 02B PM 10132018 7 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9794371709817 40.768387910254)   19 4 19 13
1281 1281 -73.9795728289645 40.7678669804787 1C-PM-1013-07 01C PM 10132018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9795728289645 40.7678669804787)   19 4 19 13
910 910 -73.9796383715206 40.7682477738244 2B-AM-1010-07 02B AM 10102018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9796383715206 40.7682477738244)   19 4 19 13
1132 1132 -73.9798390387307 40.7700761090896 3A-PM-1017-07 03A PM 10172018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9798390387307 40.7700761090896)   19 4 19 13
255 255 -73.9800669115792 40.7676825134384 1B-AM-1012-07 01B AM 10122018 7 Adult Cinnamon   Cinnamon+   Above Ground 2 on tree trunk false true true false false   false false false false false false true false   POINT (-73.9800669115792 40.7676825134384)   19 4 19 13
2482 2482 -73.9805927710872 40.7679989116642 1B-PM-1019-07 01B PM 10192018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9805927710872 40.7679989116642)   19 4 19 13
1614 1614 -73.9806718258385 40.7692776896995 2A-AM-1010-07 02A AM 10102018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false true false false false couldn't get near POINT (-73.9806718258385 40.76927768969951)   19 4 19 13
1105 1105 -73.9811218801005 40.7684406206185 1A-PM-1014-07 01A PM 10142018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9811218801005 40.7684406206185)   19 4 19 13

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);
Powered by Datasette · Query took 10.344ms