squirrels

33 rows where Combination of Primary and Highlight Color = "Cinnamon+Gray" and Tail twitches = "true" sorted by Quaas

✎ View and edit SQL

This data as json, CSV (advanced)

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

Tail twitches ✖

  • true · 33 ✖

Combination of Primary and Highlight Color ✖

  • Cinnamon+Gray · 33 ✖
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
67 67 -73.968381325559 40.7780143443779 16E-PM-1018-06 16E PM 10182018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE On a rock false false false false true   false false false false true false true false   POINT (-73.968381325559 40.7780143443779)   19 4 19 13
298 298 -73.957342596188 40.7944359654227 37E-PM-1006-09 37E PM 10062018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false false moseying false false false false true true false false   POINT (-73.957342596188 40.7944359654227)   19 4 19 13
423 423 -73.9756754297747 40.7738518843446 9B-PM-1013-02 09B PM 10132018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9756754297747 40.7738518843446)   19 4 19 13
432 432 -73.9757787135906 40.7737231427345 9B-PM-1013-03 09B PM 10132018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9757787135906 40.7737231427345)   19 4 19 13
506 506 -73.9649611089685 40.7814371834837 21F-AM-1018-05 21F AM 10182018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   false false true false false   false false false false true false false true   POINT (-73.9649611089685 40.7814371834837)   19 4 19 13
534 534 -73.9650499507011 40.7908191782173 30A-AM-1010-01 30A AM 10102018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10   true false true false false   false false false false true false false true   POINT (-73.9650499507011 40.7908191782173)   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
748 748 -73.9756603846107 40.7672531319384 3F-PM-1013-03 03F PM 10132018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9756603846107 40.7672531319384)   19 4 19 13
905 905 -73.9757216124349 40.7754310239649 11A-PM-1013-05 11A PM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false true digging false false false false true false false false   POINT (-73.9757216124349 40.7754310239649)   19 4 19 13
987 987 -73.9649827807341 40.7817322832767 21F-AM-1018-06 21F AM 10182018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9649827807341 40.7817322832767)   19 4 19 13
1492 1492 -73.9807078515193 40.7683335292642 2A-AM-1010-04 02A AM 10102018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9807078515193 40.7683335292642)   19 4 19 13
1725 1725 -73.9657480066074 40.7753465489231 14I-PM-1018-04 14I PM 10182018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false true true false false   POINT (-73.9657480066074 40.7753465489231)   19 4 19 13
1808 1808 -73.9698870647042 40.7826510985538 20B-AM-1007-02 20B AM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false true true true false false   POINT (-73.9698870647042 40.7826510985538)   19 4 19 13
1816 1816 -73.9710187505339 40.7797265666746 17B-AM-1010-02 17B AM 10102018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9710187505339 40.7797265666746)   19 4 19 13
1939 1939 -73.9540151828782 40.7920066170587 35H-AM-1013-01 35H AM 10132018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15 Climbing up tree false false true false false   false false false false true false false true   POINT (-73.9540151828782 40.7920066170587)   19 4 19 13
2033 2033 -73.9500167570283 40.7966185836685 41I-AM-1018-01 41I AM 10182018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true false false false cautious,observant,runs off POINT (-73.9500167570283 40.7966185836685)   19 4 19 13
2156 2156 -73.9650387848001 40.7814134438394 21F-AM-1018-04 21F AM 10182018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9650387848001 40.7814134438394)   19 4 19 13
2218 2218 -73.9694382427984 40.7846350692923 22A-AM-1008-04 22A AM 10082018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9694382427984 40.7846350692923)   19 4 19 13
2244 2244 -73.9509628195532 40.7977775674178 42H-PM-1014-01 42H PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   false false false false false   false false false false true false false true   POINT (-73.9509628195532 40.7977775674178) 12423 18 4 36 18
2255 2255 -73.9642967875857 40.7815652353937 21F-AM-1018-08 21F AM 10182018 8 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9642967875857 40.7815652353937)   19 4 19 13
2454 2454 -73.9565151662506 40.7946647987447 37E-PM-1006-07 37E PM 10062018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true false false true me POINT (-73.9565151662506 40.7946647987447)   19 4 19 13
2487 2487 -73.9595222999173 40.7833202577782 25I-AM-1012-02 25I AM 10122018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 31 on tree true true false false false   false false false true true false true false   POINT (-73.9595222999173 40.7833202577782)   19 4 19 13
2488 2488 -73.9726920847792 40.7794117463889 16A-PM-1019-02 16A PM 10192018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false false true scared by dog POINT (-73.9726920847792 40.7794117463889)   19 4 19 13
2696 2696 -73.9501457233643 40.797094356558 42I-PM-1014-01 42I PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true false false   false false false false true false true false   POINT (-73.9501457233643 40.797094356558)   19 4 19 13
2727 2727 -73.974596903918 40.7765498215674 12A-PM-1013-02 12A PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false true false true   false false false false true false false true   POINT (-73.974596903918 40.7765498215674)   19 4 19 13
2739 2739 -73.9681960138614 40.7726867422002 11H-AM-1010-02 11H AM 10102018 2   Cinnamon Gray Cinnamon+Gray         false false false true false   false false false false true false true false   POINT (-73.9681960138614 40.7726867422002)   19 4 19 13
2746 2746 -73.9561432836863 40.7982665347234 41C-AM-1017-07 41C AM 10172018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9561432836863 40.7982665347234)   19 4 19 13
2788 2788 -73.9647845655965 40.7816573808695 21F-AM-1018-07 21F AM 10182018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9647845655965 40.7816573808695)   19 4 19 13
2878 2878 -73.969720780557 40.7741105688757 12F-AM-1020-04 12F AM 10202018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false true false   false false false false true false false false   POINT (-73.969720780557 40.7741105688757)   19 4 19 13
2938 2938 -73.97033289562 40.7701079697795 7H-AM-1006-14 07H AM 10062018 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.97033289562 40.7701079697795)   19 4 19 13
2998 2998 -73.9752079247419 40.7755376979002 11B-AM-1007-01 11B AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true true false false   POINT (-73.9752079247419 40.7755376979002)   19 4 19 13
3004 3004 -73.9528482858163 40.7922056218325 36I-PM-1007-08 36I PM 10072018 8 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9528482858163 40.7922056218325)   19 4 19 13
1799 1799 -73.978844141973 40.7696046074378 4B-AM-1010-05 04B AM 10102018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10   false true false false false chasing squirrel #6 true true false false true false false false   POINT (-73.978844141973 40.7696046074378)   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 3043.361ms