squirrels

37 rows where Combination of Primary and Highlight Color = "Gray+Cinnamon", Foraging = "true" and Location = "Above Ground" sorted by Community Districts

✎ View and edit SQL

This data as json, CSV (advanced)

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

Eating ✖

Location ✖

  • Above Ground · 37 ✖

Foraging ✖

  • true · 37 ✖

Combination of Primary and Highlight Color ✖

  • Gray+Cinnamon · 37 ✖
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
11 11 -73.9702676472613 40.7762126854894 13E-AM-1017-05 13E AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   on tree stump false false false false true   false false false false false false false false   POINT (-73.9702676472613 40.7762126854894)   19 4 19 13
135 135 -73.9694168118643 40.7728877377977 11G-PM-1013-01 11G PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 In the Woods/Brush false false true false true   false false false false false false false true watching me POINT (-73.9694168118643 40.7728877377977)   19 4 19 13
333 333 -73.9667560049684 40.7882333830729 27A-PM-1006-01 27A PM 10062018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   on a tree false false false true true walking up & down branches false false false false false false true false   POINT (-73.9667560049684 40.7882333830729)   19 4 19 13
441 441 -73.9742973420446 40.7691801644292 5F-AM-1007-04 05F AM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   rocks false false false true true   false false false false false false false false   POINT (-73.9742973420446 40.7691801644292)   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
760 760 -73.9718234159557 40.7810842503715 18A-AM-1012-02 18A AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   false false true true true burying false false false true false false false true   POINT (-73.9718234159557 40.7810842503715)   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
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
1045 1045 -73.9730420696993 40.7786151019726 15B-AM-1014-01 15B AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40   false false true false true   false false false false false false false false   POINT (-73.9730420696993 40.7786151019726)   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
1385 1385 -73.9615649773504 40.7954761311501 36A-PM-1013-02 36A PM 10132018 2   Gray Cinnamon Gray+Cinnamon   Above Ground 6   false false false false true   false false false false false false true false   POINT (-73.9615649773504 40.7954761311501)   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
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
1564 1564 -73.9703816112358 40.7773846065919 15D-PM-1017-02 15D PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1   false false true false true   false false false false false false true false   POINT (-73.9703816112358 40.7773846065919)   19 4 19 13
1609 1609 -73.9639024988123 40.7776953065849 18I-PM-1007-01 18I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   false false true true true hanging upside down false false false false false false true false   POINT (-73.9639024988123 40.7776953065849)   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
1714 1714 -73.9763542780331 40.7736531303622 9B-AM-1010-02 09B AM 10102018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 1 in bush false false true false true   false false false false true false false true froze POINT (-73.9763542780331 40.773653130362206)   19 4 19 13
1777 1777 -73.9711751356843 40.7752422758202 12E-AM-1017-06 12E AM 10172018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 2   false false false true true   false false false false false false true false   POINT (-73.9711751356843 40.7752422758202)   19 4 19 13
1875 1875 -73.9527430510248 40.7924807950552 36I-PM-1007-12 36I PM 10072018 12 Juvenile Gray Cinnamon Gray+Cinnamon Tiny! So tiny! Above Ground 2   false false false false true   false false false false false false false false   POINT (-73.9527430510248 40.7924807950552)   19 4 19 13
1923 1923 -73.9743795190073 40.7692030411004 5E-AM-1008-05 05E AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1   false false false false true   false false false false false false true false   POINT (-73.9743795190073 40.7692030411004)   19 4 19 13
2037 2037 -73.9683370417551 40.78135983505 19D-AM-1007-02 19D AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   false false true false true   false false false false true false false false fenced area POINT (-73.9683370417551 40.78135983505)   19 4 19 13
2132 2132 -73.967472660349 40.7772125619715 16F-PM-1013-03 16F PM 10132018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 4 Woods false false true false true   false false false false false false false true   POINT (-73.96747266034902 40.7772125619715)   19 4 19 13
2222 2222 -73.9639048209454 40.7777373345558 18I-PM-1007-02 18I PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   false false true true true hanging upside down false false false false false false true false   POINT (-73.9639048209454 40.7777373345558)   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
2366 2366 -73.9676191846985 40.777641740817 16F-PM-1013-04 16F PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false true true true   false false false false false false false true   POINT (-73.9676191846985 40.777641740817)   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
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
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
2700 2700 -73.9601988871514 40.7943473161329 35C-PM-1013-01 35C PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false true false true   true true false true true false true false   POINT (-73.9601988871514 40.7943473161329)   19 4 19 13
2702 2702 -73.9588339897601 40.7848084865431 26I-PM-1010-06 26I PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 35 tree false false true false true   false false false false true false true false   POINT (-73.9588339897601 40.7848084865431)   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
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
2870 2870 -73.9538475741188 40.796479421955 40F-PM-1006-02 40F PM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   false false false false true   false false false false false false true false   POINT (-73.9538475741188 40.796479421955)   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 149.61ms