squirrels

31 rows where Date = 10142018, Runs from = "true" and Shift = "AM"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, 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, Moans, Tail twitches, Approaches, Indifferent, 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
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
277 277 -73.9619070229674 40.79525566925 35A-AM-1014-05 35A AM 10142018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9619070229674 40.79525566925)   19 4 19 13
386 386 -73.9550351380957 40.7974681522214 40E-AM-1014-01 40E AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9550351380957 40.7974681522214)   19 4 19 13
388 388 -73.9592537496995 40.7919271821316 33E-AM-1014-03 33E AM 10142018 3 Adult Black   Black+   Above Ground 5   false false true false false   false false false false false false false true   POINT (-73.9592537496995 40.7919271821316)   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
593 593 -73.9593352806175 40.7918150568046 33E-AM-1014-02 33E AM 10142018 2 Juvenile Black   Black+   Above Ground 10   false false true false false   false false false false false false false true   POINT (-73.9593352806175 40.7918150568046)   19 4 19 13
624 624 -73.9613051957306 40.7909351393505 31D-AM-1014-02 31D AM 10142018 2 Juvenile Gray White Gray+White   Ground Plane FALSE Undergrowth false false false false true   false false false false false false false true   POINT (-73.9613051957306 40.7909351393505)   19 4 19 13
891 891 -73.9613351649026 40.7909866851357 31D-AM-1014-03 31D AM 10142018 3   Gray White Gray+White   Ground Plane FALSE Undergrowth false false false false true   false false false false false false false true   POINT (-73.9613351649026 40.7909866851357)   19 4 19 13
898 898 -73.9542828053256 40.7941797320355 37G-AM-1014-03 37G AM 10142018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9542828053256 40.7941797320355)   19 4 19 13
1075 1075 -73.9640534906634 40.7777383899836 17I-AM-1014-02 17I AM 10142018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false standing upright false false false false false true false true runs from (only ran away when a grandpa chased it off) POINT (-73.9640534906634 40.7777383899836)   19 4 19 13
1102 1102 -73.9688173465755 40.7782009764626 16E-AM-1014-08 16E AM 10142018 8 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (dog) POINT (-73.9688173465755 40.7782009764626)   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
1298 1298 -73.9612900553755 40.7912917391867 32C-AM-1014-01 32C AM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false true true   false false false false false false false true   POINT (-73.9612900553755 40.7912917391867)   19 4 19 13
1395 1395 -73.9710801547498 40.7760872452093 13D-AM-1014-03 13D AM 10142018 3 Juvenile Gray White Gray+White   Above Ground 2   false true true true false   false false false false false false false true   POINT (-73.9710801547498 40.7760872452093)   19 4 19 13
1765 1765 -73.9689041600147 40.7781788966185 16E-AM-1014-07 16E AM 10142018 7 Adult Gray   Gray+   Above Ground     true false false false false   false false false false false false false true runs from (dog) POINT (-73.9689041600147 40.7781788966185)   19 4 19 13
1767 1767 -73.958719099962 40.7947587726617 36C-AM-1014-04 36C AM 10142018 4   Gray White Gray+White   Above Ground 15 Ground then tree to eat true false true true false   false false false false false false false true   POINT (-73.958719099962 40.7947587726617)   19 4 19 13
1803 1803 -73.9588076804698 40.7912942607296 33E-AM-1014-06 33E AM 10142018 6 Adult Gray White Gray+White   Ground Plane FALSE   false false true false false   false false false false false false false true   POINT (-73.9588076804698 40.7912942607296)   19 4 19 13
1992 1992 -73.9586085843149 40.7946617684536 36C-AM-1014-03 36C AM 10142018 3   Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9586085843149 40.7946617684536)   19 4 19 13
2061 2061 -73.9608834102446 40.790624710005 31D-AM-1014-05 31D AM 10142018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9608834102446 40.790624710005)   19 4 19 13
2105 2105 -73.9738723117119 40.7786845612246 14A-AM-1014-01 14A AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true foraging?,crossing road false false false false false false true true runs from (dogs) POINT (-73.9738723117119 40.7786845612246)   19 4 19 13
2261 2261 -73.9609692861012 40.790502891247 31D-AM-1014-07 31D AM 10142018 7   Gray   Gray+   Ground Plane FALSE Crossing path to tree true false false false false   false false false false false false false true   POINT (-73.9609692861012 40.790502891247)   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
2621 2621 -73.9596904740342 40.7897200025671 31E-AM-1014-01 31E AM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9596904740342 40.7897200025671)   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
2849 2849 -73.9709912560997 40.7758965595198 13D-AM-1014-01 13D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false true   false false false false true false false true   POINT (-73.9709912560997 40.7758965595198)   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
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

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