squirrels

24 rows where Date = 10142018, Highlight Fur Color = "Cinnamon" and Runs from = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Moans, Tail twitches, Other Interactions, Zip Codes, Community Districts, City Council Districts, Police Precincts

Combination of Primary and Highlight Color ✖

Highlight Fur Color ✖

  • Cinnamon · 24 ✖

Date ✖

  • 10142018 · 24 ✖
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
122 122 -73.9712527809516 40.7763310392591 13D-AM-1014-08 13D AM 10142018 8 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9712527809516 40.7763310392591)   19 4 19 13
168 168 -73.9745691353018 40.7771035589298 13A-PM-1014-03 13A PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   false false true false false   false false false false false false false true child chasing POINT (-73.9745691353018 40.7771035589298)   19 4 19 13
338 338 -73.9765595553183 40.7748455340432 10A-PM-1014-04 10A PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9765595553183 40.7748455340432)   19 4 19 13
501 501 -73.9708798496132 40.7761532088521 13D-AM-1014-06 13D AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false   false false false false false false false true   POINT (-73.9708798496132 40.7761532088521)   19 4 19 13
544 544 -73.9718474480919 40.7794963354254 16B-AM-1014-01 16B AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9718474480919 40.7794963354254)   19 4 19 13
581 581 -73.9556218199258 40.7980460204041 41D-PM-1014-01 41D PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false digging,drinking false false false false false false false true   POINT (-73.9556218199258 40.7980460204041)   19 4 19 13
956 956 -73.9581173730857 40.7954772170549 37D-PM-1014-08 37D PM 10142018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9581173730857 40.7954772170549)   19 4 19 13
1119 1119 -73.9597557819449 40.7949918204459 36C-AM-1014-01 36C AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9597557819449 40.7949918204459)   19 4 19 13
1134 1134 -73.9716995507598 40.7797671327739 16B-AM-1014-02 16B AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9716995507598 40.7797671327739)   19 4 19 13
1250 1250 -73.9585133340331 40.7963721679474 38C-PM-1014-03 38C PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   true false false false false false false true   POINT (-73.9585133340331 40.7963721679474)   19 4 19 13
1443 1443 -73.9728511531484 40.7782654840595 14B-PM-1014-03 14B PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9728511531484 40.7782654840595)   19 4 19 13
1635 1635 -73.9560731738677 40.7980336018554 41D-PM-1014-02 41D PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9560731738677 40.7980336018554)   19 4 19 13
1884 1884 -73.9733898487296 40.7666975131518 3H-PM-1014-02 03H PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9733898487296 40.7666975131518)   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
2439 2439 -73.9587459136391 40.7982497351812 40B-PM-1014-05 40B PM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9587459136391 40.7982497351812)   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
2729 2729 -73.9615429203441 40.7907417648701 31D-AM-1014-01 31D AM 10142018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20 Ground then up tree false false true false false chased by a doggo false false true false false false false true runs from (dogs!) POINT (-73.9615429203441 40.7907417648701)   19 4 19 13
2809 2809 -73.9686756254868 40.7777459102651 16E-AM-1014-04 16E AM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false false false false false true   POINT (-73.9686756254868 40.7777459102651)   19 4 19 13
2892 2892 -73.9688070760806 40.7779688294172 16E-AM-1014-06 16E AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false true   false false false false false false false true   POINT (-73.9688070760806 40.777968829417205)   19 4 19 13
2936 2936 -73.9809876538513 40.7683223242143 1A-PM-1014-05 01A PM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9809876538513 40.7683223242143)   19 4 19 13
2948 2948 -73.9545225586988 40.7956074663106 39F-AM-1014-03 39F AM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9545225586988 40.7956074663106)   19 4 19 13
2975 2975 -73.959412243507 40.7917871123534 33E-AM-1014-01 33E AM 10142018 1 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   false false false false false digging false false false false false false false true   POINT (-73.959412243507 40.7917871123534)   19 4 19 13
3008 3008 -73.9503533343658 40.7976543603953 42H-PM-1014-04 42H PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   true true false false false   false false false false true false false true   POINT (-73.9503533343658 40.7976543603953) 12423 18 4 36 18
3010 3010 -73.9580906814132 40.7948404060484 37D-PM-1014-01 37D PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true eyes from a safe distance POINT (-73.9580906814132 40.7948404060484)   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 74.486ms