squirrels

63 rows where Combination of Primary and Highlight Color = "Gray+Cinnamon", Foraging = "true" and Running = "true" sorted by Combination of Primary and Highlight Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, Approaches, Indifferent, Runs from, Other Interactions

Tail twitches ✖

Police Precincts ✖

Highlight Fur Color ✖

Foraging ✖

  • true · 63 ✖

Combination of Primary and Highlight Color ✖

  • Gray+Cinnamon · 63 ✖
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
240 240 -73.9767080512177 40.7717708794221 6B-PM-1017-04 06B PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true false false true   false false false false false false false false   POINT (-73.9767080512177 40.7717708794221)   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
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
404 404 -73.9680774548516 40.7762491903691 14F-PM-1012-01 14F PM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false false false true false   POINT (-73.9680774548516 40.7762491903691)   19 4 19 13
413 413 -73.9698934182612 40.7708211633861 8H-PM-1014-03 08H PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9698934182612 40.7708211633861)   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
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
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
716 716 -73.9745427984089 40.7691848214817 5E-AM-1008-03 05E AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9745427984089 40.7691848214817)   19 4 19 13
763 763 -73.9767455430709 40.7717866237826 6B-PM-1017-06 06B PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true false false true   false false false false false false false false   POINT (-73.9767455430709 40.7717866237826)   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
862 862 -73.9626120417397 40.7905126358626 30C-AM-1014-02 30C AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE on a rock true false false false true   false false false false true false true false   POINT (-73.9626120417397 40.7905126358626)   19 4 19 13
868 868 -73.9738481771673 40.7706540698938 7E-PM-1013-04 07E PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false true false false false   POINT (-73.9738481771673 40.7706540698938)   19 4 19 13
922 922 -73.9708002461415 40.7726685284831 10F-PM-1019-10 10F PM 10192018 10 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Arbor path & hill w/ bushes true false false true true   false false false false true false true false   POINT (-73.9708002461415 40.7726685284831)   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
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
995 995 -73.9698843507358 40.7803754187581 18C-PM-1018-02 18C PM 10182018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9698843507358 40.7803754187581)   19 4 19 13
1020 1020 -73.97016933635 40.7705452529783 8H-AM-1017-05 08H AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   true false false true true   false false false false false false true false   POINT (-73.97016933635001 40.7705452529783)   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
1094 1094 -73.9773898301093 40.7708581562057 5B-AM-1008-01 05B AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true running across ball field 5,near home plate false false false false false false true false   POINT (-73.9773898301093 40.7708581562057)   19 4 19 13
1163 1163 -73.9677096985223 40.7825358361204 21C-AM-1014-02 21C AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 50   true true true false true   false true false false false false false false looked at us from tree POINT (-73.9677096985223 40.7825358361204)   19 4 19 13
1179 1179 -73.9696762034757 40.7704883494264 8H-AM-1017-02 08H AM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7 root bed of tree true false false false true   false false false false false false true false   POINT (-73.9696762034757 40.7704883494264)   19 4 19 13
1284 1284 -73.9570891696776 40.7935448802241 36E-PM-1012-01 36E PM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9570891696776 40.7935448802241)   19 4 19 13
1346 1346 -73.9735655529245 40.7716072681474 7E-PM-1013-02 07E PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ground & Tree Base true false false true true   false false false false false false false true   POINT (-73.9735655529245 40.7716072681474)   19 4 19 13
1366 1366 -73.9711582199102 40.7783674409485 15C-PM-1017-05 15C PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   true false false false true true false false   POINT (-73.9711582199102 40.7783674409485)   19 4 19 13
1429 1429 -73.9706533131129 40.768902033819 6I-AM-1006-01 06I AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground     true false true true true   false false false false false false false true runs from (someone sneezed) POINT (-73.9706533131129 40.768902033819)   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
1455 1455 -73.9715621134573 40.7695918717513 7H-AM-1006-02 07H AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true running (along ground,up tree) false false false false false false true false   POINT (-73.9715621134573 40.76959187175131)   19 4 19 13
1565 1565 -73.9803895322385 40.7680730789944 1B-AM-1012-13 01B AM 10122018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9803895322385 40.7680730789944)   19 4 19 13
1567 1567 -73.9774407362587 40.7698056129554 4C-PM-1010-12 04C PM 10102018 12 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9774407362587 40.7698056129554)   19 4 19 13
1579 1579 -73.9768309556127 40.7717803706095 6B-AM-1012-01 06B AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Started in field, crossed busy street, ran up tree true false false false true   false false false false false false true false   POINT (-73.97683095561271 40.7717803706095)   19 4 19 13
1661 1661 -73.974519308015 40.7691228794395 5E-AM-1008-02 05E AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8 trellis true false false false true   false false false false false true false false   POINT (-73.974519308015 40.7691228794395)   19 4 19 13
1719 1719 -73.955429970986 40.7978168629875 40D-AM-1013-02 40D AM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.955429970986 40.7978168629875)   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
1781 1781 -73.96005650463 40.7934048502983 34C-PM-1012-02 34C PM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.96005650463 40.7934048502983)   19 4 19 13
1975 1975 -73.9753291616796 40.7687376032936 4E-PM-1008-01 04E PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false true false true false   POINT (-73.9753291616796 40.7687376032936)   19 4 19 13
2058 2058 -73.9669017345324 40.7766928987073 15G-AM-1008-01 15G AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9669017345324 40.7766928987073)   19 4 19 13
2147 2147 -73.9651217998407 40.7761115392738 15I-PM-1012-01 15I PM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false true false false false   POINT (-73.9651217998407 40.7761115392738)   19 4 19 13
2148 2148 -73.9767317539505 40.7717600450632 6B-PM-1017-05 06B PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true false false true   false false false false false false false false   POINT (-73.9767317539505 40.7717600450632)   19 4 19 13
2242 2242 -73.9565824187667 40.797312050952 40D-AM-1013-06 40D AM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   true false true false true   true false false false true false false true   POINT (-73.9565824187667 40.797312050952)   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
2275 2275 -73.9614218413356 40.7938945058793 34B-AM-1013-01 34B AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true hopping false false false false true true false false   POINT (-73.9614218413356 40.7938945058793)   19 4 19 13
2276 2276 -73.9611985783336 40.791604823372 32C-AM-1014-06 32C AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9611985783336 40.791604823372)   19 4 19 13
2316 2316 -73.957697363244 40.7997576909042 42A-PM-1014-01 42A PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true up on hind legs looking around false false false false false false false false came to about 10' away then ran off POINT (-73.957697363244 40.7997576909042)   19 4 19 13
2384 2384 -73.9708564226824 40.7726219968014 10F-PM-1019-09 10F PM 10192018 9 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Across Arbor path into hill w/ bushes true false false false true   false false false false false false false true   POINT (-73.9708564226824 40.7726219968014)   19 4 19 13
2423 2423 -73.973552877209 40.7715638228207 7E-PM-1013-01 07E PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ground & Tree Base true false true true true   false false false false false false false true   POINT (-73.973552877209 40.7715638228207)   19 4 19 13
2424 2424 -73.9684752839242 40.7765816261518 15F-AM-1007-01 15F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO Ground Plane FALSE   true false false true true   false false false false false false true true   POINT (-73.9684752839242 40.7765816261518)   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
2515 2515 -73.9693338657183 40.7757055884538 13F-PM-1008-05 13F PM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 tree trunk true false false true true   true false false false true false false false   POINT (-73.9693338657183 40.77570558845381)   19 4 19 13
2522 2522 -73.9658747245917 40.7754033737532 14I-PM-1018-01 14I PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   Fallen branch true false false false true   false false false false true false false true   POINT (-73.9658747245917 40.7754033737532)   19 4 19 13
2564 2564 -73.970996228532 40.7715540712285 9G-PM-1007-02 09G PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.970996228532 40.7715540712285)   19 4 19 13
2585 2585 -73.9771726831497 40.7732320781799 8A-AM-1013-01 08A AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE trail true false false false true   false false false false false false false true   POINT (-73.9771726831497 40.7732320781799)   19 4 19 13
2627 2627 -73.9766348078633 40.7717715634438 7C-AM-1012-01 07C AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true hopping around grass false false false false false false true false   POINT (-73.9766348078633 40.7717715634438)   19 4 19 13
2639 2639 -73.9543832609857 40.7953550639701 39F-AM-1014-02 39F AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 rocks true false true false true   false false false false false false false false   POINT (-73.9543832609857 40.7953550639701)   19 4 19 13
2662 2662 -73.9708628933624 40.7725630886784 10F-PM-1019-08 10F PM 10192018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Under "Grape Arbor" structure behind Bandshell true false false false true digging false false false false false false false true   POINT (-73.9708628933624 40.7725630886784)   19 4 19 13
2682 2682 -73.9711001278389 40.7787466095841 15C-PM-1017-01 15C PM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false false false false true   POINT (-73.9711001278389 40.7787466095841)   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
2699 2699 -73.9743509423821 40.7690043677328 5F-AM-1007-02 05F AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   tree true true false false true   false false false false false false false false   POINT (-73.97435094238212 40.7690043677328)   19 4 19 13
2710 2710 -73.9577919365342 40.7960853285059 38C-PM-1014-08 38C PM 10142018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   true false false false false false false true   POINT (-73.9577919365342 40.7960853285059)   19 4 19 13
2758 2758 -73.9542074814296 40.7954322240004 39F-AM-1014-01 39F AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9542074814296 40.7954322240004)   19 4 19 13
2808 2808 -73.9765027953575 40.7717327360835 7C-AM-1012-02 07C AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true hopping around false false false false false false true false   POINT (-73.9765027953575 40.7717327360835)   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

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 5836.285ms