squirrels

32 rows where Combination of Primary and Highlight Color = "Gray+Cinnamon", Date = 10072018 and Eating = "true"

View and edit SQL

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Foraging, Other Activities, Tail flags, Tail twitches, Approaches, Indifferent, 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
32 -73.9576530157255 40.7868659490397 29I-PM-1007-01 29I PM 10072018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9576530157255 40.7868659490397)   19 4 19 13
57 -73.9690175838534 40.7760432720017 14F-AM-1007-05 14F AM 10072018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9690175838534 40.7760432720017)   19 4 19 13
94 -73.9641971813967 40.7813537959435 21G-PM-1007-01 21G PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false true false false true false   POINT (-73.9641971813967 40.7813537959435)   19 4 19 13
136 -73.9528682507794 40.7925807808307 36I-PM-1007-13 36I PM 10072018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true true false false   POINT (-73.9528682507794 40.7925807808307)   19 4 19 13
161 -73.9649632550828 40.7809187761995 20F-PM-1007-01 20F PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon cinnamon tail Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9649632550828 40.7809187761995)   19 4 19 13
304 -73.9523001834395 40.7949231000186 39H-AM-1007-02 39H AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9523001834395 40.7949231000186)   19 4 19 13
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
446 -73.9678774314725 40.7738535171265 12H-PM-1007-04 12H PM 10072018 4   Gray Cinnamon Gray+Cinnamon         false false false true false mushroom false false false false false false true false   POINT (-73.9678774314725 40.7738535171265)   19 4 19 13
505 -73.9677387336667 40.7742695912 12H-PM-1007-02 12H PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 in tree false false true true false peanuts false false false false false false true false   POINT (-73.9677387336667 40.7742695912)   19 4 19 13
591 -73.9543323786888 40.7943086530436 37G-PM-1007-03 37G PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   false false false true false lying on belly on branch,eating big nut false false false false false false false false   POINT (-73.9543323786888 40.7943086530436)   19 4 19 13
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
727 -73.9634563222926 40.780992836417 21G-PM-1007-04 21G PM 10072018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false true false false false true   POINT (-73.9634563222926 40.780992836417)   19 4 19 13
942 -73.9533923917973 40.7961701874769 40G-AM-1007-01 40G AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25 large tree false false true true false   false false false false false false true false   POINT (-73.9533923917973 40.7961701874769)   19 4 19 13
1109 -73.9678154033099 40.7742783484486 12H-PM-1007-01 12H PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 in tree false false false true false   false false false false false false false false   POINT (-73.9678154033099 40.7742783484486)   19 4 19 13
1115 -73.9545214613307 40.7943801121036 37G-PM-1007-01 37G PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9545214613307 40.7943801121036)   19 4 19 13
1169 -73.9570391901515 40.7930697207834 35F-AM-1007-01 35F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9570391901515 40.7930697207834)   19 4 19 13
1208 -73.9662804925774 40.7890284642399 28A-PM-1007-01 28A PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9662804925774 40.7890284642399)   19 4 19 13
1216 -73.9707245013626 40.7780656588337 15D-AM-1007-06 15D AM 10072018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9707245013626 40.7780656588337)   19 4 19 13
1404 -73.9700666654946 40.7742857042581 12F-PM-1007-08 12F PM 10072018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false stared POINT (-73.9700666654946 40.7742857042581)   19 4 19 13
1408 -73.973230162241 40.7689824531444 5F-AM-1007-01 05F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 fence true false false true false   false false false false false false false false   POINT (-73.973230162241 40.7689824531444)   19 4 19 13
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
1906 -73.9700066659086 40.7744028820163 12F-PM-1007-13 12F PM 10072018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9700066659086 40.7744028820163)   19 4 19 13
1963 -73.9651591861399 40.781183828857 20F-PM-1007-06 20F PM 10072018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9651591861399 40.781183828857)   19 4 19 13
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
2382 -73.9743970455533 40.7687880243986 5F-PM-1007-01 05F PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9743970455533 40.7687880243986)   19 4 19 13
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
2463 -73.9653343572865 40.7775286924617 17H-PM-1007-01 17H PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   false false true true false   false false false true false false false true   POINT (-73.9653343572865 40.7775286924617)   19 4 19 13
2472 -73.9596820155238 40.7932886803231 34D-PM-1007-03 34D PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true false false true   POINT (-73.9596820155238 40.7932886803231)   19 4 19 13
2626 -73.9737329655838 40.7726424441344 8D-PM-1007-02 08D PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9737329655838 40.7726424441344)   19 4 19 13
2833 -73.9552595564798 40.7889533029466 32I-PM-1007-01 32I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true true true chirps false false false false true false true false   POINT (-73.9552595564798 40.7889533029466)   19 4 19 13
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
2995 -73.9668442742942 40.7870781042595 25B-PM-1007-01 25B PM 10072018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9668442742942 40.7870781042595)   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 59.884ms