squirrels

26 rows where Chasing = "true", Combination of Primary and Highlight Color = "Gray+Cinnamon" and Location = "Above Ground" sorted by Longitude

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Color notes, Above Ground Sighter Measurement, Specific Location, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Indifferent, Runs from, Other Interactions, Zip Codes, Community Districts, City Council Districts

Running ✖

Police Precincts ✖

Combination of Primary and Highlight Color ✖

  • Gray+Cinnamon · 26 ✖

Chasing ✖

  • true · 26 ✖
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
3008 3008 -73.9503533343658 40.7976543603953 42H-PM-1014-04 42H PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   true true false false false   false false false false true false false true   POINT (-73.9503533343658 40.7976543603953) 12423 18 4 36 18
2247 2247 -73.9559520137172 40.7950536287174 38E-AM-1010-06 38E AM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 branches true true false false false chasing and being chased by #7 false false false false true false true false   POINT (-73.95595201371721 40.7950536287174)   19 4 19 13
547 547 -73.9559677963727 40.7951124076946 38E-AM-1010-07 38E AM 10102018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 branches true true false false false chasing and being chased by #6 false false false false true false false true   POINT (-73.9559677963727 40.7951124076946)   19 4 19 13
503 503 -73.9598340783572 40.7915857030295 33D-PM-1006-02 33D PM 10062018 2   Gray Cinnamon Gray+Cinnamon   Above Ground 15   false true false false false   false false false false false false false true   POINT (-73.95983407835722 40.7915857030295)   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
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
565 565 -73.9615402629655 40.7924082330328 33C-AM-1012-02 33C AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon Cinnamon along back & tail Above Ground 20 tree branches false true true false false   false false false false false false true false   POINT (-73.9615402629655 40.7924082330328)   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
1698 1698 -73.9631392113757 40.7914635635784 31B-PM-1007-02 31B PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false true true false false chasing #1 and climbing tree w/ #1 false false false false false false false true   POINT (-73.9631392113757 40.7914635635784)   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
1128 1128 -73.9638599044346 40.7809288795308 21G-AM-1014-06 21G AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   false true true false false   false false false false false false false false   POINT (-73.9638599044346 40.7809288795308)   19 4 19 13
2940 2940 -73.963911430308 40.7809127228847 21G-AM-1014-05 21G AM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   false true true false false   false false false false false false false false   POINT (-73.963911430308 40.7809127228847)   19 4 19 13
1300 1300 -73.964280573021 40.777830911491 18I-PM-1007-08 18I PM 10072018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false true true false false canoodling w/ #9 false false false false false false true false   POINT (-73.964280573021 40.777830911491)   19 4 19 13
1451 1451 -73.9645365195454 40.7781531021263 18H-AM-1018-02 18H AM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   Tree true true false false false playing? false false false false false false false false   POINT (-73.9645365195454 40.7781531021263)   19 4 19 13
1163 1163 -73.9677096985223 40.7825358361204 21C-AM-1014-02 21C AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 50   true true true false true   false true false false false false false false looked at us from tree POINT (-73.9677096985223 40.7825358361204)   19 4 19 13
765 765 -73.96797780019 40.7847629473258 23B-PM-1012-05 23B PM 10122018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 chain link fence false true true false false   false false false false false false true false   POINT (-73.96797780019 40.7847629473258)   19 4 19 13
2465 2465 -73.9686999860219 40.7844014735136 22B-PM-1014-03 22B PM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   true true false false false   false false false false false false false false   POINT (-73.9686999860219 40.7844014735136)   19 4 19 13
2029 2029 -73.9687213827744 40.7843586374648 22B-PM-1014-02 22B PM 10142018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   true true false false false   false false false false false false false false   POINT (-73.9687213827744 40.7843586374648)   19 4 19 13
44 44 -73.970252675331 40.7705999588222 8H-AM-1017-06 08H AM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   false true false true false   false false false false false false true false   POINT (-73.970252675331 40.77059995882221)   19 4 19 13
352 352 -73.970540988328 40.7698103067062 7H-AM-1006-06 07H AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   false true false false false   false false false false false false true false   POINT (-73.970540988328 40.7698103067062)   19 4 19 13
20 20 -73.9706105896967 40.7698124821507 7H-AM-1006-05 07H AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false true false false false   false false false false false false true false   POINT (-73.9706105896967 40.7698124821507)   19 4 19 13
1960 1960 -73.9730158913661 40.7701310707272 6F-PM-1008-02 06F PM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   true true false false false chasing #2 false false false false false false false false   POINT (-73.9730158913661 40.7701310707272)   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
2699 2699 -73.9743509423821 40.7690043677328 5F-AM-1007-02 05F AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   tree true true false false true   false false false false false false false false   POINT (-73.97435094238212 40.7690043677328)   19 4 19 13
318 318 -73.9743990576746 40.7768690723163 12A-PM-1013-04 12A PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Above Ground 1   false true false false false chasing #3 false false false false false false true false   POINT (-73.9743990576746 40.7768690723163)   19 4 19 13
729 729 -73.9776044578446 40.7697607308033 4C-PM-1010-15 04C PM 10102018 15 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   on tree false true false false false chasing #14 false false false false false false true false   POINT (-73.9776044578446 40.7697607308033)   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 81.154ms