squirrels

57 rows where Combination of Primary and Highlight Color = "Gray+Cinnamon", Hectare Squirrel Number = 3 and Indifferent = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Tail flags, Tail twitches, Approaches, Runs from, Other Interactions

Link rowid ▼ Longitude Latitude Unique Squirrel ID Hectare Shift Date Hectare Squirrel Number Age Primary Fur Color Highlight Fur Color Combination of Primary and Highlight Color Color notes Location Above Ground Sighter Measurement Specific Location Running Chasing Climbing Eating Foraging Other Activities Kuks Quaas Moans Tail flags Tail twitches Approaches Indifferent Runs from Other Interactions Lat/Long Zip Codes Community Districts Borough Boundaries City Council Districts Police Precincts
16 16 -73.9722500196844 40.7742879599026 11D-AM-1010-03 11D AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   false false true false false grooming false false false false false false true false   POINT (-73.9722500196844 40.7742879599026)   19 4 19 13
23 23 -73.9638179439747 40.7924173263904 32A-PM-1013-03 32A PM 10132018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9638179439747 40.7924173263904)   19 4 19 13
65 65 -73.9741824992294 40.7689486657963 5F-PM-1007-03 05F PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false hiding nut false false false false true false true false   POINT (-73.9741824992294 40.7689486657963)   19 4 19 13
124 124 -73.9588660250232 40.7982597947515 40A-AM-1010-03 40A AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE bottom of great hill false false false true true   false false false true false false true true dog chased POINT (-73.9588660250232 40.7982597947515)   19 4 19 13
149 149 -73.9576349321357 40.7904409912437 32G-PM-1013-03 32G PM 10132018 3 Juvenile Gray Cinnamon Gray+Cinnamon Cinnamon belly Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9576349321357 40.7904409912437)   19 4 19 13
201 201 -73.9598015842806 40.7973522744237 38A-PM-1013-03 38A PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   false false true false false   false false false false false false true false   POINT (-73.9598015842806 40.7973522744237)   19 4 19 13
207 207 -73.9770824412252 40.7709961309457 5C-AM-1006-03 05C AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   false false true false false   false false false false false false true false   POINT (-73.97708244122522 40.7709961309457)   19 4 19 13
232 232 -73.9624184586031 40.7921524868211 32B-AM-1017-03 32B AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true true true true approaches (primarily),runs from (initially),follows POINT (-73.9624184586031 40.7921524868211)   19 4 19 13
345 345 -73.9724452296309 40.7715792113505 8F-PM-1012-03 08F PM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true buried an acorn false false false false false false true false   POINT (-73.9724452296309 40.7715792113505)   19 4 19 13
408 408 -73.9633760173635 40.7818422357619 22G-PM-1018-03 22G PM 10182018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false chilling false false false false false false true false observed POINT (-73.96337601736352 40.7818422357619)   19 4 19 13
418 418 -73.9573604880421 40.7930844158021 35E-PM-1006-03 35E PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9573604880421 40.7930844158021)   19 4 19 13
460 460 -73.9549135206961 40.798525897229 42D-PM-1013-03 42D PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25 in tree false false false true false   false false false false false false true false   POINT (-73.9549135206961 40.798525897229)   19 4 19 13
577 577 -73.9497217674555 40.796517007214 42I-PM-1014-03 42I PM 10142018 3   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9497217674555 40.796517007214)   19 4 19 13
605 605 -73.9573930079918 40.7934570294469 35E-AM-1020-03 35E AM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9573930079918 40.7934570294469)   19 4 19 13
614 614 -73.9642411990432 40.7779692777193 18H-PM-1014-03 18H PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9642411990432 40.7779692777193)   19 4 19 13
784 784 -73.9649658099293 40.7823262369074 22F-PM-1014-03 22F PM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9649658099293 40.7823262369074)   19 4 19 13
786 786 -73.953296595236 40.7927644594513 36I-AM-1017-03 36I AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon Cinnamon stripe on back Ground Plane FALSE   true false false true true   false false false false false false true false   POINT (-73.953296595236 40.7927644594513)   19 4 19 13
830 830 -73.9595645962539 40.7899599350145 31E-PM-1006-03 31E PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE under bushes false false false true true burying false false false false false false true false   POINT (-73.9595645962539 40.7899599350145)   19 4 19 13
877 877 -73.9710547484029 40.7723589827074 9F-PM-1014-03 09F PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9710547484029 40.7723589827074)   19 4 19 13
878 878 -73.9757215415855 40.7668205976986 2F-PM-1014-03 02F PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9757215415855 40.7668205976986)   19 4 19 13
1021 1021 -73.97186968288 40.778926988884 15B-AM-1014-03 15B AM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true running (from a dog) false false false false false false true false   POINT (-73.97186968288 40.778926988884)   19 4 19 13
1150 1150 -73.9744726434743 40.776729630785 12A-PM-1013-03 12A PM 10132018 3   Gray Cinnamon Gray+Cinnamon   Above Ground 3   true false false false false chased up a tree by #4 false false false false false false true false   POINT (-73.9744726434743 40.776729630785)   19 4 19 13
1249 1249 -73.9590132705889 40.7952248279764 37C-AM-1012-03 37C AM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon Cinnamon flanks Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9590132705889 40.7952248279764)   19 4 19 13
1326 1326 -73.9747288122551 40.7659918747507 2G-PM-1007-03 02G PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9747288122551 40.7659918747507)   19 4 19 13
1393 1393 -73.9687134137786 40.7812207913391 19C-PM-1018-03 19C PM 10182018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9687134137786 40.7812207913391)   19 4 19 13
1425 1425 -73.9586252875856 40.7852027586217 27I-AM-1007-03 27I AM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon had .5 of a tail Above Ground 20   false false true false true   false false false false false false true false   POINT (-73.9586252875856 40.7852027586217)   19 4 19 13
1447 1447 -73.9601968065017 40.7935831836482 34C-PM-1012-03 34C PM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9601968065017 40.79358318364821)   19 4 19 13
1481 1481 -73.9538867186376 40.7941409434007 38G-PM-1020-03 38G PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false true false false true false   POINT (-73.9538867186376 40.7941409434007)   19 4 19 13
1542 1542 -73.960876728048 40.79035724537 31D-PM-1006-03 31D PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.960876728048 40.79035724537)   19 4 19 13
1586 1586 -73.9714150090362 40.7774976423922 14C-PM-1006-03 14C PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9714150090362 40.7774976423922)   19 4 19 13
1616 1616 -73.9642666013207 40.7810384867375 21G-PM-1007-03 21G PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.96426660132072 40.7810384867375)   19 4 19 13
1664 1664 -73.9729142912203 40.7724091146678 9E-AM-1008-03 09E AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9729142912203 40.7724091146678)   19 4 19 13
1748 1748 -73.955710327539 40.7974510797567 40D-AM-1013-03 40D AM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.955710327539 40.7974510797567)   19 4 19 13
1773 1773 -73.9611126813593 40.7943113021522 35B-AM-1010-03 35B AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9611126813593 40.7943113021522)   19 4 19 13
1907 1907 -73.9689227467959 40.7837541607494 21B-AM-1019-03 21B AM 10192018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9689227467959 40.7837541607494)   19 4 19 13
2021 2021 -73.9582800305509 40.7989473712974 40B-PM-1014-03 40B PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9582800305509 40.7989473712974)   19 4 19 13
2063 2063 -73.9544763281886 40.7969645476349 40F-PM-1006-03 40F PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9544763281886 40.7969645476349)   19 4 19 13
2065 2065 -73.9768411547701 40.7741377018895 9A-AM-1013-03 09A AM 10132018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9768411547701 40.7741377018895)   19 4 19 13
2109 2109 -73.9744488584414 40.7741627220859 10C-PM-1013-03 10C PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9744488584414 40.7741627220859)   19 4 19 13
2178 2178 -73.9557918001972 40.7979228878042 40D-PM-1013-03 40D PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9557918001972 40.7979228878042)   19 4 19 13
2186 2186 -73.9561103688639 40.794914085004 37E-AM-1013-03 37E AM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9561103688639 40.794914085004)   19 4 19 13
2256 2256 -73.9720050204318 40.7699419094168 7G-AM-1010-03 07G AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9720050204318 40.7699419094168)   19 4 19 13
2259 2259 -73.975565603566 40.7738462518304 9B-AM-1010-03 09B AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   true false true false true   false false false false false false true false   POINT (-73.975565603566 40.7738462518304)   19 4 19 13
2290 2290 -73.9565645716564 40.7959039949577 38D-PM-1006-03 38D PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9565645716564 40.795903994957705)   19 4 19 13
2407 2407 -73.9555724351776 40.7967602498249 39E-AM-1018-03 39E AM 10182018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9555724351776 40.7967602498249)   19 4 19 13
2491 2491 -73.9806905259671 40.7681152210858 1A-AM-1007-03 01A AM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false looking in bush false false false false false false true false   POINT (-73.9806905259671 40.7681152210858)   19 4 19 13
2573 2573 -73.9810149147578 40.7683925377714 2A-AM-1010-03 02A AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 on trunk false false false true false   false false false false false false true false   POINT (-73.9810149147578 40.7683925377714)   19 4 19 13
2599 2599 -73.9689893412693 40.785308737683 23A-AM-1018-03 23A AM 10182018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8 Tree false false true false false   false false false false false false true false   POINT (-73.9689893412693 40.785308737683)   19 4 19 13
2666 2666 -73.9763593390732 40.7717297058549 7C-AM-1012-03 07C AM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true foraging (loving the acorns!) false false false false false false true false   POINT (-73.97635933907321 40.7717297058549)   19 4 19 13
2679 2679 -73.9794481602391 40.770638572864 4A-AM-1007-03 04A AM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9794481602391 40.770638572864)   19 4 19 13
2694 2694 -73.969628583287 40.7704067797932 8H-AM-1017-03 08H AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 fence true false false false true   false false false false false false true false   POINT (-73.969628583287 40.7704067797932)   19 4 19 13
2695 2695 -73.962800448652 40.7915532640139 31B-PM-1007-03 31B PM 10072018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.962800448652 40.7915532640139)   19 4 19 13
2747 2747 -73.971314838366 40.774951285041 12E-AM-1017-03 12E AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8   false false true false true   false false false false false false true false   POINT (-73.971314838366 40.774951285041)   19 4 19 13
2789 2789 -73.9686800784941 40.7766739029138 15F-AM-1007-03 15F AM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9686800784941 40.7766739029138)   19 4 19 13
2836 2836 -73.953092053256 40.7982256930243 42F-PM-1017-03 42F PM 10172018 3   Gray Cinnamon Gray+Cinnamon         true false false false false   false false false false false false true false   POINT (-73.953092053256 40.7982256930243)   19 4 19 13
2871 2871 -73.9777124331985 40.7704051056666 5B-AM-1008-03 05B AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false false false true false   POINT (-73.9777124331985 40.7704051056666)   19 4 19 13
2954 2954 -73.9677474313377 40.7742119240825 12H-PM-1007-03 12H PM 10072018 3   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false peanuts false false false false false false true false   POINT (-73.9677474313377 40.7742119240825)   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 72.34ms