squirrels

19 rows where Combination of Primary and Highlight Color = "Cinnamon+White", Police Precincts = 13 and Runs from = "true" sorted by Other Activities

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Other Interactions

Hectare Squirrel Number ✖

Runs from ✖

  • true · 19 ✖

Police Precincts ✖

Combination of Primary and Highlight Color ✖

  • Cinnamon+White · 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
268 268 -73.968107276769 40.7768612676036 15F-AM-1007-09 15F AM 10072018 9 Adult Cinnamon White Cinnamon+White   Above Ground 20   false false true false true   false false false false false false false true   POINT (-73.968107276769 40.7768612676036)   19 4 19 13
376 376 -73.9698817079185 40.7758322627711 13E-PM-1008-10 13E PM 10082018 10 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false true false false true   POINT (-73.9698817079185 40.7758322627711)   19 4 19 13
464 464 -73.9664450399121 40.7887844904695 27A-AM-1008-02 27A AM 10082018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9664450399121 40.7887844904695)   19 4 19 13
667 667 -73.9624538733037 40.7883829851518 28D-AM-1012-04 28D AM 10122018 4 Adult Cinnamon White Cinnamon+White   Above Ground 10   false false true false false   false false false false false false false true   POINT (-73.9624538733037 40.7883829851518)   19 4 19 13
1077 1077 -73.9541837143178 40.7944340477396 38G-PM-1020-06 38G PM 10202018 6 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false true false false false false false true   POINT (-73.9541837143178 40.7944340477396)   19 4 19 13
1290 1290 -73.9668140804066 40.7768100147333 15G-AM-1008-06 15G AM 10082018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9668140804066 40.7768100147333)   19 4 19 13
1577 1577 -73.965390623703 40.7807731363782 20F-PM-1007-08 20F PM 10072018 8 Adult Cinnamon White Cinnamon+White white tail/belly Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.965390623703 40.7807731363782)   19 4 19 13
1617 1617 -73.9752029513644 40.7671734667361 3F-AM-1006-04 03F AM 10062018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE on a rock false false false false true   false false false false false false false true   POINT (-73.9752029513644 40.7671734667361)   19 4 19 13
1652 1652 -73.9498421746221 40.7969397424182 42I-PM-1014-02 42I PM 10142018 2 Adult Cinnamon White Cinnamon+White   Above Ground 8   true false false false false   false false false false false false false true   POINT (-73.9498421746221 40.7969397424182)   19 4 19 13
2278 2278 -73.964539031099 40.7809916310012 20G-PM-1013-01 20G PM 10132018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false true   false false false false true false false true   POINT (-73.964539031099 40.7809916310012)   19 4 19 13
2620 2620 -73.9771800098131 40.7708863131336 5C-PM-1010-03 05C PM 10102018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9771800098131 40.7708863131336)   19 4 19 13
2742 2742 -73.9628041577934 40.7884180156055 28D-AM-1012-06 28D AM 10122018 6 Juvenile Cinnamon White Cinnamon+White   Above Ground 5   false false false true false   false false false false false false false true   POINT (-73.9628041577934 40.78841801560551)   19 4 19 13
2745 2745 -73.97296259363 40.7652601851275 1I-PM-1012-04 01I PM 10122018 4 Juvenile Cinnamon White Cinnamon+White Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 2 on ledge false false true false false   false false false false true false false true   POINT (-73.97296259363 40.7652601851275)   19 4 19 13
2779 2779 -73.9767835160078 40.7674030330482 2E-PM-1014-04 02E PM 10142018 4 Adult Cinnamon White Cinnamon+White   Above Ground 15   false false true false false   false false false false false false false true   POINT (-73.9767835160078 40.7674030330482)   19 4 19 13
2794 2794 -73.9712187890707 40.7750640173134 12E-PM-1018-01 12E PM 10182018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   true false true false false   true false false true false false false true   POINT (-73.9712187890707 40.7750640173134)   19 4 19 13
2886 2886 -73.9729265300533 40.7741768291642 10D-AM-1008-02 10D AM 10082018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9729265300533 40.7741768291642)   19 4 19 13
27 27 -73.9670628558161 40.7734991420941 12I-AM-1013-01 12I AM 10132018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE on tree roots false false false false false sitting false false false false true false false true   POINT (-73.9670628558161 40.77349914209411)   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
2102 2102 -73.9593909381748 40.7961036981921 37B-PM-1013-03 37B PM 10132018 3 Adult Cinnamon White Cinnamon+White White back left leg       false false false true true watching false false false false false false false true   POINT (-73.9593909381748 40.7961036981921)   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.239ms