squirrels

26 rows where Hectare = "07H"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

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
20 20 -73.9706105896967 40.7698124821507 7H-AM-1006-05 07H AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false true false false false   false false false false false false true false   POINT (-73.9706105896967 40.7698124821507)   19 4 19 13
96 96 -73.9708549670788 40.7699587019058 7H-PM-1006-04 07H PM 10062018 4 Adult Gray   Gray+   Above Ground 12 on tree knob false false false false false sitting false false false false false false true false   POINT (-73.9708549670788 40.7699587019058)   19 4 19 13
262 262 -73.9712876234172 40.7695885530701 7H-PM-1006-02 07H PM 10062018 2 Adult Gray   Gray+   Above Ground 25 tree true false true true true   false false false false false false true false   POINT (-73.9712876234172 40.7695885530701)   19 4 19 13
352 352 -73.970540988328 40.7698103067062 7H-AM-1006-06 07H AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   false true false false false   false false false false false false true false   POINT (-73.970540988328 40.7698103067062)   19 4 19 13
435 435 -73.9702963056917 40.7697928730791 7H-AM-1006-11 07H AM 10062018 11 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9702963056917 40.7697928730791)   19 4 19 13
472 472 -73.9702721244652 40.7701011774207 7H-AM-1006-15 07H AM 10062018 15 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9702721244652 40.7701011774207)   19 4 19 13
486 486 -73.971213385696 40.769872094337 7H-AM-1006-04 07H AM 10062018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.97121338569602 40.769872094337)   19 4 19 13
569 569 -73.9709040623777 40.7701163892686 7H-PM-1006-03 07H PM 10062018 3 Adult Gray   Gray+   Above Ground 8 tree true false true false false   false false false true false false true false   POINT (-73.9709040623777 40.7701163892686)   19 4 19 13
658 658 -73.9704575848926 40.7693499326095 7H-PM-1006-09 07H PM 10062018 9 Adult Black   Black+   Ground Plane FALSE by tree false false false true true   false false false true false true false true   POINT (-73.9704575848926 40.7693499326095)   19 4 19 13
697 697 -73.970465600402 40.7701125773248 7H-PM-1006-05 07H PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ran across path to eat behind fence, next to the fence. true false false true true   false false false false true false false true   POINT (-73.970465600402 40.7701125773248)   19 4 19 13
1091 1091 -73.97055600791 40.7698499183436 7H-AM-1006-07 07H AM 10062018 7 Adult Gray Cinnamon Gray+Cinnamon         false false false true false   false false false false true false true false   POINT (-73.97055600791 40.7698499183436)   19 4 19 13
1106 1106 -73.9702970919317 40.7696883113413 7H-PM-1006-08 07H PM 10062018 8 Adult Gray White Gray+White   Ground Plane FALSE in grass false false false false true   false false false false true true false true   POINT (-73.9702970919317 40.7696883113413)   19 4 19 13
1275 1275 -73.9702541471417 40.7698584231797 7H-AM-1006-12 07H AM 10062018 12 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9702541471417 40.7698584231797)   19 4 19 13
1285 1285 -73.9705115189429 40.7698395577068 7H-AM-1006-08 07H AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9705115189429 40.7698395577068)   19 4 19 13
1455 1455 -73.9715621134573 40.7695918717513 7H-AM-1006-02 07H AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true running (along ground,up tree) false false false false false false true false   POINT (-73.9715621134573 40.76959187175131)   19 4 19 13
1469 1469 -73.9704831177035 40.7699878995692 7H-AM-1006-10 07H AM 10062018 10 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9704831177035 40.7699878995692)   19 4 19 13
1535 1535 -73.9703921271418 40.7700276115314 7H-PM-1006-06 07H PM 10062018 6 Adult Gray   Gray+   Above Ground 15   false true true false false playing w/ #7 false false false false false false true false   POINT (-73.9703921271418 40.770027611531404)   19 4 19 13
1557 1557 -73.9705331808443 40.7699943571296 7H-AM-1006-09 07H AM 10062018 9 Adult Gray Cinnamon Gray+Cinnamon         false false false false true   false false false false false true false false   POINT (-73.9705331808443 40.7699943571296)   19 4 19 13
1575 1575 -73.9703169373939 40.7700658823854 7H-AM-1006-13 07H AM 10062018 13 Adult Gray   Gray+   Above Ground 10   true false false false false running (up tree) false false false false false false true false   POINT (-73.9703169373939 40.7700658823854)   19 4 19 13
1628 1628 -73.9713665249614 40.7697178648002 7H-AM-1006-01 07H AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false nut in mouth false false false false false false true false   POINT (-73.9713665249614 40.7697178648002)   19 4 19 13
1813 1813 -73.9706988226435 40.7696684566926 7H-AM-1006-16 07H AM 10062018 16 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9706988226435 40.7696684566926)   19 4 19 13
1819 1819 -73.9711378905748 40.7696218346333 7H-AM-1006-03 07H AM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE on rock (large) false false false false true   false false false false true false true false   POINT (-73.9711378905748 40.769621834633305)   19 4 19 13
2362 2362 -73.9700263936574 40.7699335098581 7H-PM-1006-07 07H PM 10062018 7 Adult Gray   Gray+   Above Ground 15   false true true false false playing w/ #6 false false false false false false true false   POINT (-73.9700263936574 40.7699335098581)   19 4 19 13
2610 2610 -73.9713379914423 40.7696367609606 7H-PM-1006-01 07H PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE middle of grass false false false true true   false false false false true true false false   POINT (-73.9713379914423 40.7696367609606)   19 4 19 13
2624 2624 -73.9706308500637 40.7696174874596 7H-PM-1006-10 07H PM 10062018 10 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9706308500637 40.7696174874596)   19 4 19 13
2938 2938 -73.97033289562 40.7701079697795 7H-AM-1006-14 07H AM 10062018 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.97033289562 40.7701079697795)   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 71.972ms