squirrels

13 rows where Date = 10082018 and Hectare Squirrel Number = 7 sorted by Other Activities

View and edit SQL

Suggested facets: Shift, 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, Indifferent

Police Precincts

Hectare Squirrel Number

Date

  • 10082018 · 13
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
28 -73.958736593111 40.7908524370626 32F-PM-1008-07 32F PM 10082018 7 Adult Gray   Gray+   Ground Plane FALSE   true true false false true   false false false false false false true false   POINT (-73.958736593111 40.7908524370626)   19 4 19 13
54 -73.9760298241178 40.7681954366911 3E-PM-1008-07 03E PM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9760298241178 40.7681954366911)   19 4 19 13
129 -73.9705092958892 40.7761092972965 13E-PM-1008-07 13E PM 10082018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9705092958892 40.7761092972965)   19 4 19 13
718 -73.9661694463488 40.7757530583569 15H-PM-1008-07 15H PM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE along bottom of rock outcropping false false false true true   false false false false false false true false   POINT (-73.9661694463488 40.7757530583569)   19 4 19 13
812 -73.9699675160516 40.7773012642758 15E-PM-1008-07 15E PM 10082018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9699675160516 40.7773012642758)   19 4 19 13
879 -73.9735120882106 40.7715915415169 8E-PM-1008-07 08E PM 10082018 7 Adult Gray White Gray+White   Ground Plane FALSE 5, 6, 7 all at same tree trunk base false true true false false   false false false false false false false false   POINT (-73.9735120882106 40.7715915415169)   19 4 19 13
1073 -73.9769742179824 40.7727484521829 7B-AM-1008-07 07B AM 10082018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9769742179824 40.7727484521829)   19 4 19 13
1142 -73.9765805609072 40.7692807820935 4D-PM-1008-07 04D PM 10082018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE hopped over fence and chased # 6 around tree & ran it to end of lawn true true false false false   false false false false false false true false   POINT (-73.9765805609072 40.7692807820935)   19 4 19 13
1687 -73.9754790964561 40.768336388516 4E-PM-1008-07 04E PM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9754790964561 40.768336388516)   19 4 19 13
2713 -73.9687214684206 40.7792841720164 17D-AM-1008-07 17D AM 10082018 7 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9687214684206 40.7792841720164)   19 4 19 13
2831 -73.9753585157592 40.7698398607941 5E-AM-1008-07 05E AM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 on fence false false false false true   false false false false false false true false   POINT (-73.9753585157592 40.7698398607941)   19 4 19 13
2267 -73.9727926335397 40.77037055775 7F-AM-1008-07 07F AM 10082018 7 Adult Gray   Gray+   Above Ground 28 next to the hole of #6 false false false false false standing false false false false false false true false   POINT (-73.9727926335397 40.77037055775)   19 4 19 13
559 -73.9704166194815 40.7766720346576 14E-AM-1008-07 14E AM 10082018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false false true walking false false false false false false true false   POINT (-73.9704166194815 40.7766720346576)   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 67.198ms