squirrels

29 rows where Chasing = "true" and Hectare Squirrel Number = 1 sorted by Color notes

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Eating, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Indifferent, Runs from, Other Interactions

Foraging ✖

Police Precincts ✖

Hectare Squirrel Number ✖

Chasing ✖

  • true · 29 ✖
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
38 38 -73.9742073452913 40.7757957380463 12B-AM-1007-01 12B AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false true false false true false   POINT (-73.9742073452913 40.7757957380463)   19 4 19 13
82 82 -73.9688271202401 40.7809719445309 19C-PM-1018-01 19C PM 10182018 1 Adult Gray White Gray+White   Ground Plane FALSE   true true false true false   false false false false true false true false   POINT (-73.9688271202401 40.7809719445309)   19 4 19 13
144 144 -73.9730750601212 40.7701304211944 6F-PM-1008-01 06F PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false true false false false   false false false false false false false false   POINT (-73.9730750601212 40.7701304211944)   19 4 19 13
633 633 -73.9673243699918 40.7875392957722 26A-AM-1014-01 26A AM 10142018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false true   false false false false false false false false could not get close due to fences POINT (-73.9673243699918 40.7875392957722)   19 4 19 13
751 751 -73.9683479943823 40.7815827298303 20C-PM-1018-01 20C PM 10182018 1 Juvenile Gray   Gray+   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9683479943823 40.7815827298303)   19 4 19 13
840 840 -73.9598084794625 40.7976165434502 39A-PM-1014-01 39A PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9598084794625 40.7976165434502)   19 4 19 13
874 874 -73.9591957793992 40.7949568873453 36C-PM-1013-01 36C PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) false true false true true   false false false false true false true false   POINT (-73.9591957793992 40.7949568873453)   19 4 19 13
906 906 -73.9664120826015 40.7888022709721 27A-AM-1008-01 27A AM 10082018 1 Adult Gray   Gray+   Above Ground 3   false true false false false   false false false false false false false true   POINT (-73.96641208260151 40.7888022709721)   19 4 19 13
911 911 -73.9697277998257 40.7705198722028 8H-AM-1017-01 08H AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false true true   false false false false false false true false   POINT (-73.9697277998257 40.7705198722028)   19 4 19 13
1004 1004 -73.9670850805619 40.7833747810387 22C-PM-1006-01 22C PM 10062018 1 Juvenile Gray   Gray+   Ground Plane FALSE   true true false false false for food false true false false false false false false   POINT (-73.9670850805619 40.7833747810387)   19 4 19 13
1007 1007 -73.9635317822977 40.7821352080233 22G-AM-1018-01 22G AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   true false false true false false true false   POINT (-73.9635317822977 40.7821352080233)   19 4 19 13
1055 1055 -73.9632337134707 40.7914682370734 31B-PM-1007-01 31B PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false true true false false chasing #2 and climbing tree w/ #2 false false false false false false false true   POINT (-73.9632337134707 40.7914682370734)   19 4 19 13
1135 1135 -73.9667474482967 40.7760643720793 15H-PM-1008-01 15H PM 10082018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10 Oak tree false true false false false watching me false true false true false false false false observant POINT (-73.9667474482967 40.7760643720793)   19 4 19 13
1147 1147 -73.9631818528816 40.7925332194132 32A-AM-1018-01 32A AM 10182018 1 Adult Gray   Gray+   Above Ground 15   true true false false false   false false false false false false true false   POINT (-73.9631818528816 40.7925332194132)   19 4 19 13
1264 1264 -73.9785353775382 40.7674923683184 2C-PM-1013-01 02C PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9785353775382 40.7674923683184)   19 4 19 13
1588 1588 -73.9693209851947 40.7707450042769 8I-AM-1006-01 08I AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   true true false false false   true false false false false false true false   POINT (-73.9693209851947 40.7707450042769)   19 4 19 13
1835 1835 -73.9562068537632 40.7967332853238 39D-AM-1008-01 39D AM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9562068537632 40.7967332853238)   19 4 19 13
1864 1864 -73.9694344956258 40.7742869276902 12G-PM-1007-01 12G PM 10072018 1   Gray   Gray+   Above Ground 40 in tree false true false false false   false false false false false false false false   POINT (-73.9694344956258 40.7742869276902)   19 4 19 13
1997 1997 -73.9714637683084 40.7768984561563 14D-PM-1019-01 14D PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9714637683084 40.7768984561563)   19 4 19 13
2118 2118 -73.958369699409 40.7902456668332 32F-PM-1008-01 32F PM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   true true true true true   false false false false false false true false   POINT (-73.958369699409 40.7902456668332)   19 4 19 13
2142 2142 -73.9598535425706 40.7915589343685 33D-PM-1006-01 33D PM 10062018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 15   false true false false false hanging on fence true false false true false false false true   POINT (-73.9598535425706 40.7915589343685)   19 4 19 13
2182 2182 -73.9573656523498 40.7979754563974 40C-AM-1017-01 40C AM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   false true false false false chasing (#2) false false false false false false false true   POINT (-73.9573656523498 40.7979754563974)   19 4 19 13
2313 2313 -73.9646174034945 40.7781287528262 18H-AM-1018-01 18H AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Running from one tree to the other true true false false false playing? false false false false false false false false   POINT (-73.9646174034945 40.7781287528262)   19 4 19 13
2351 2351 -73.9745818450109 40.7654498873627 1G-AM-1006-01 01G AM 10062018 1 Adult Black   Black+   Ground Plane FALSE   false true false false true   false false false false true false true false   POINT (-73.9745818450109 40.7654498873627)   19 4 19 13
2387 2387 -73.9808517324721 40.7683154647217 1A-PM-1014-01 01A PM 10142018 1 Adult Cinnamon White Cinnamon+White   Above Ground 6   false true false false false   false false false false true false false false   POINT (-73.9808517324721 40.7683154647217)   19 4 19 13
2466 2466 -73.9599419926299 40.7972774728811 38A-AM-1019-01 38A AM 10192018 1 Adult Gray   Gray+   Above Ground 3   true true true false false   false false false false false false true false   POINT (-73.9599419926299 40.7972774728811)   19 4 19 13
2652 2652 -73.9620542514749 40.7943731722138 34A-AM-1012-01 34A AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 chasing from tree to ground true true true false false   false false false false false false true false   POINT (-73.9620542514749 40.7943731722138)   19 4 19 13
2861 2861 -73.9720102361126 40.7692143930301 6G-PM-1020-01 06G PM 10202018 1 Adult Gray   Gray+   Ground Plane FALSE   true true false false false   false false false false false false true false   POINT (-73.9720102361126 40.7692143930301)   19 4 19 13
2872 2872 -73.9615396457996 40.7923594366783 33C-AM-1012-01 33C AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon along tail & back Above Ground 20 tree branches false true true false false   false false false false false false true false   POINT (-73.9615396457996 40.7923594366783)   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 90.212ms