squirrels

19 rows where Date = 10072018 and Hectare Squirrel Number = 7 sorted by Borough Boundaries

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, 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, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Hectare Squirrel Number ✖

Date ✖

  • 10072018 · 19 ✖
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
25 25 -73.9671130680114 40.7784859700171 17F-AM-1007-07 17F AM 10072018 7 Adult Gray White Gray+White   Above Ground 24   true false false false false   false false false true false false true false   POINT (-73.9671130680114 40.7784859700171)   19 4 19 13
76 76 -73.9530035564643 40.7921822457613 36I-PM-1007-07 36I PM 10072018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9530035564643 40.7921822457613)   19 4 19 13
284 284 -73.9547336666137 40.7938937756332 37G-PM-1007-07 37G PM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   true false false false false   false false false false false false false true   POINT (-73.9547336666137 40.7938937756332)   19 4 19 13
407 407 -73.9787658435198 40.7689419765393 3B-PM-1007-07 03B PM 10072018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false eating loudly <- peanuts w/ shells false false false false false false true false   POINT (-73.9787658435198 40.7689419765393)   19 4 19 13
588 588 -73.9646597452128 40.7827698220703 22F-AM-1007-07 22F AM 10072018 7 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3   false false true false false   false false false false true false false false alert & aware POINT (-73.9646597452128 40.7827698220703)   19 4 19 13
722 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
750 750 -73.9699672074164 40.7774389345748 15D-AM-1007-07 15D AM 10072018 7 Adult Gray White Gray+White   Ground Plane FALSE   false true false false true chasing #8 false false false false false false true false   POINT (-73.9699672074164 40.7774389345748)   19 4 19 13
926 926 -73.9596006938677 40.7834706440535 25I-PM-1007-07 25I PM 10072018 7 Adult Gray   Gray+   Above Ground   playing very high in tree w/ #8 false false false false false   false false false false false false false false   POINT (-73.9596006938677 40.7834706440535)   19 4 19 13
1207 1207 -73.9594708328732 40.791192982895 32E-AM-1007-07 32E AM 10072018 7 Adult Gray   Gray+   Above Ground   on tennis club house roof false false true false false   false false false false false false true false   POINT (-73.9594708328732 40.791192982895)   19 4 19 13
1217 1217 -73.9764850086767 40.7737340720562 8B-AM-1007-07 08B AM 10072018 7 Juvenile Gray Black Gray+Black   Above Ground 8   false false false true false holding nut false false false false false false true false   POINT (-73.9764850086767 40.7737340720562)   19 4 19 13
1388 1388 -73.9685709455958 40.7744877026506 12G-PM-1007-07 12G PM 10072018 7 Juvenile     +   Above Ground 45   false false false true false acorns false false false false false false false false   POINT (-73.9685709455958 40.7744877026506)   19 4 19 13
1544 1544 -73.9642111283068 40.7777713985327 18I-PM-1007-07 18I PM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9642111283068 40.7777713985327)   19 4 19 13
1738 1738 -73.967975586222 40.7735683044313 12H-PM-1007-07 12H PM 10072018 7   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE grass field false false false false true   false false false false false false false true humans POINT (-73.967975586222 40.7735683044313)   19 4 19 13
1843 1843 -73.9685940262068 40.776932102013 15F-AM-1007-07 15F AM 10072018 7 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9685940262068 40.776932102013)   19 4 19 13
1862 1862 -73.9764851231754 40.7715736862861 6C-AM-1007-07 06C AM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false false ambling false false false false false true false true trucks POINT (-73.9764851231754 40.7715736862861)   19 4 19 13
2100 2100 -73.9638312025305 40.7903826659569 30B-AM-1007-07 30B AM 10072018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9638312025305 40.7903826659569)   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
2217 2217 -73.9652746477521 40.7809326848536 20F-PM-1007-07 20F PM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon cinnamon tail Ground Plane FALSE   true false false false false watching false false false true false false false true   POINT (-73.96527464775211 40.7809326848536)   19 4 19 13
2402 2402 -73.9777206733344 40.7668595585487 1D-PM-1007-07 01D PM 10072018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false false false lying down false false false false false false true false   POINT (-73.9777206733344 40.7668595585487)   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 107.25ms