squirrels

21 rows where Climbing = "true", Date = 10072018 and Foraging = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, 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, Eating, 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
97 97 -73.9639744005647 40.7825111950764 22F-AM-1007-01 22F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false true   false false false false false false true false   POINT (-73.9639744005647 40.7825111950764)   19 4 19 13
268 268 -73.968107276769 40.7768612676036 15F-AM-1007-09 15F AM 10072018 9 Adult Cinnamon White Cinnamon+White   Above Ground 20   false false true false true   false false false false false false false true   POINT (-73.968107276769 40.7768612676036)   19 4 19 13
470 470 -73.9581243021722 40.794431473386 36D-AM-1007-01 36D AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true false true   false false false false false false false true avoiding a dog POINT (-73.95812430217221 40.794431473386)   19 4 19 13
496 496 -73.9548430741605 40.798207350942 41E-AM-1007-06 41E AM 10072018 6 Adult Gray   Gray+   Above Ground 30 tree false false true false true   false false false false false false false false   POINT (-73.9548430741605 40.798207350942)   19 4 19 13
1067 1067 -73.9695305996721 40.7745386896959 12F-PM-1007-02 12F PM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.9695305996721 40.7745386896959)   19 4 19 13
1192 1192 -73.9634811495245 40.790705585077 30B-AM-1007-10 30B AM 10072018 10 Adult Gray   Gray+   Ground Plane FALSE   true false true false true   false false false false false false false true   POINT (-73.9634811495245 40.790705585077)   19 4 19 13
1315 1315 -73.9595955824812 40.7933047943534 34D-PM-1007-01 34D PM 10072018 1 Adult Gray White Gray+White   Above Ground 25   false false true false true   false false false false true false false true   POINT (-73.9595955824812 40.7933047943534)   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
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
1729 1729 -73.9765046109019 40.7736674124746 8B-AM-1007-04 08B AM 10072018 4 Adult Gray   Gray+   Above Ground 2   false false true false true   false false false false false false true false   POINT (-73.9765046109019 40.7736674124746)   19 4 19 13
1851 1851 -73.9623621412501 40.7814673556041 22H-PM-1007-03 22H PM 10072018 3 Adult Gray White Gray+White   Above Ground 4 chased squirrel #2 away false false true false true   false false false false false false true false   POINT (-73.9623621412501 40.7814673556041)   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
2145 2145 -73.9651250402583 40.7812884929069 20F-PM-1007-04 20F PM 10072018 4 Juvenile Gray White Gray+White white on tail Above Ground 20 climbed tree false false true false true   false false false false false false false false   POINT (-73.9651250402583 40.7812884929069)   19 4 19 13
2187 2187 -73.9699134052609 40.774446589038 12F-PM-1007-14 12F PM 10072018 14 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false true true false   POINT (-73.9699134052609 40.774446589038)   19 4 19 13
2210 2210 -73.9699124811406 40.7743016981538 12F-PM-1007-07 12F PM 10072018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true true true false true   false false false true false false true false   POINT (-73.9699124811406 40.7743016981538)   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
2354 2354 -73.9636740170308 40.7903538224977 30B-AM-1007-12 30B AM 10072018 12 Adult Gray   Gray+   Above Ground 4   false false true false true   false false false false false false false true   POINT (-73.96367401703081 40.79035382249771)   19 4 19 13
2448 2448 -73.9668230576555 40.7870637233327 25B-PM-1007-02 25B PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false true   false false false false false false true false   POINT (-73.9668230576555 40.7870637233327)   19 4 19 13
2508 2508 -73.979381450452 40.7709033697887 4A-PM-1007-01 04A PM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false true true true   false false false false true false true false   POINT (-73.979381450452 40.770903369788705)   19 4 19 13
2791 2791 -73.9593624259363 40.7905522356793 32E-AM-1007-02 32E AM 10072018 2 Adult Gray   Gray+   Above Ground 40   false false true false true   false false false false false false true false   POINT (-73.9593624259363 40.7905522356793)   19 4 19 13
2833 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

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