squirrels

119 rows where Hectare Squirrel Number = 8 sorted by Specific Location

✎ View and edit SQL

This data as json, CSV (advanced)

Police Precincts ✖

Hectare Squirrel Number ✖

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
2963 2963 -73.9687020800791 40.7735903424522 11H-AM-1010-08 11H AM 10102018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9687020800791 40.7735903424522)   19 4 19 13
2976 2976 -73.9724083320538 40.7744163768061 11D-AM-1010-08 11D AM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true drinking false false false false false true false false   POINT (-73.9724083320538 40.7744163768061)   19 4 19 13
2996 2996 -73.970033345821 40.777259393859 15E-PM-1008-08 15E PM 10082018 8 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.970033345821 40.777259393859)   19 4 19 13
3004 3004 -73.9528482858163 40.7922056218325 36I-PM-1007-08 36I PM 10072018 8 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9528482858163 40.7922056218325)   19 4 19 13
3015 3015 -73.9759163300535 40.7736180793606 9B-AM-1010-08 09B AM 10102018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon head, White (Almost Silver) Ground Plane FALSE   false false false true true   false false false false true false false false   POINT (-73.9759163300535 40.7736180793606)   19 4 19 13
955 955 -73.960657061561 40.7956150744102 36A-PM-1013-08 36A PM 10132018 8   Gray   Gray+   Ground Plane FALSE "FIELD" true false false false false running from #7 false false false false false false false true   POINT (-73.960657061561 40.7956150744102)   19 4 19 13
717 717 -73.9574749571848 40.7981898890735 40C-PM-1006-08 40C PM 10062018 8 Adult Gray   Gray+   Ground Plane FALSE By the main road true false false false false   false false false false false false false true   POINT (-73.9574749571848 40.7981898890735)   19 4 19 13
2945 2945 -73.9649103330443 40.7823913860445 22F-PM-1014-08 22F PM 10142018 8 Adult Gray   Gray+   Above Ground 10 CLIMBED THE TREE false false true false false   false false false false false false true false   POINT (-73.9649103330443 40.7823913860445)   19 4 19 13
2662 2662 -73.9708628933624 40.7725630886784 10F-PM-1019-08 10F PM 10192018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Under "Grape Arbor" structure behind Bandshell true false false false true digging false false false false false false false true   POINT (-73.9708628933624 40.7725630886784)   19 4 19 13
2289 2289 -73.9745800592393 40.767356541975 3F-AM-1006-08 03F AM 10062018 8 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE close to tall tree & light post true false false false true   false false false false false false true false   POINT (-73.9745800592393 40.767356541975)   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
526 526 -73.9680833729772 40.7741871025115 12H-PM-1007-08 12H PM 10072018 8       +   Above Ground 7 in tree false false false false false   false false false false false false false true   POINT (-73.9680833729772 40.7741871025115)   19 4 19 13
1125 1125 -73.9775735077285 40.7692872082165 4C-PM-1010-08 04C PM 10102018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10 on stone arch true false true false false   false false false false false false false true   POINT (-73.9775735077285 40.7692872082165)   19 4 19 13
1069 1069 -73.9595485734618 40.7835326425693 25I-PM-1007-08 25I PM 10072018 8 Adult Gray   Gray+   Above Ground   playing very high in tree w/ #7 false false false false false   false false false false false false false false   POINT (-73.9595485734618 40.7835326425693)   19 4 19 13
1645 1645 -73.9619673317128 40.7924176673037 33B-PM-1010-08 33B PM 10102018 8 Juvenile Gray   Gray+   Above Ground   running up tree false false true false false   false false false false false false false true   POINT (-73.9619673317128 40.7924176673037)   19 4 19 13
899 899 -73.9792754037291 40.7679690700399 2C-AM-1010-08 02C AM 10102018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3 stay on side of trunk false false true false false   false false false false false false false false   POINT (-73.9792754037291 40.7679690700399)   19 4 19 13
476 476 -73.9690968160819 40.769923269444 8I-AM-1006-08 08I AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6 tree false false false false false   true true false false false false false false not backing down POINT (-73.9690968160819 40.769923269444)   19 4 19 13
2826 2826 -73.9600357018376 40.7906539766881 32E-AM-1007-08 32E AM 10072018 8 Adult Gray   Gray+   Above Ground 65 tree top false false true false false   false false false false false false false false   POINT (-73.9600357018376 40.7906539766881)   19 4 19 13
2593 2593 -73.9590191812452 40.7906166981409 32E-PM-1017-08 32E PM 10172018 8 Adult Gray   Gray+   Ground Plane FALSE treed area false false false true true   false false false false false false false true   POINT (-73.9590191812452 40.7906166981409)   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 10.486ms