squirrels

37 rows where Date = 10122018 and Primary Fur Color = "Cinnamon"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Eating, Foraging, Other Activities, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Climbing ✖

Primary Fur Color ✖

  • Cinnamon · 37 ✖

Date ✖

  • 10122018 · 37 ✖
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
87 87 -73.9541453465817 40.7982162223764 42E-PM-1012-06 42E PM 10122018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9541453465817 40.79821622237641)   19 4 19 13
125 125 -73.9651601541795 40.7761841788025 15I-PM-1012-07 15I PM 10122018 7 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9651601541795 40.7761841788025)   19 4 19 13
165 165 -73.969058856545 40.7766356226979 14F-PM-1012-06 14F PM 10122018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.969058856545 40.7766356226979)   19 4 19 13
255 255 -73.9800669115792 40.7676825134384 1B-AM-1012-07 01B AM 10122018 7 Adult Cinnamon   Cinnamon+   Above Ground 2 on tree trunk false true true false false   false false false false false false true false   POINT (-73.9800669115792 40.7676825134384)   19 4 19 13
267 267 -73.9754742295091 40.7696998327247 5E-PM-1012-02 05E PM 10122018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9754742295091 40.7696998327247)   19 4 19 13
392 392 -73.9802376131034 40.7680707516627 1B-AM-1012-12 01B AM 10122018 12 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9802376131034 40.7680707516627)   19 4 19 13
424 424 -73.9756557086441 40.773296289824 8B-PM-1012-08 08B PM 10122018 8 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9756557086441 40.773296289824)   19 4 19 13
485 485 -73.9677423154682 40.7728813350245 11I-AM-1012-02 11I AM 10122018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9677423154682 40.77288133502451)   19 4 19 13
490 490 -73.978426472499 40.771904101844 6A-PM-1012-04 06A PM 10122018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.978426472499 40.771904101844)   19 4 19 13
590 590 -73.9785133301426 40.7718260288338 6A-PM-1012-05 06A PM 10122018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9785133301426 40.7718260288338)   19 4 19 13
640 640 -73.9785536529136 40.7716184505002 6A-PM-1012-07 06A PM 10122018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE elevated ground false true false false true   false false false false false false true false   POINT (-73.9785536529136 40.771618450500206)   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
684 684 -73.9691057326088 40.7765973509721 14F-PM-1012-07 14F PM 10122018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true true false true true   false false false false false false true false   POINT (-73.9691057326088 40.7765973509721)   19 4 19 13
788 788 -73.9687476703117 40.7742856696093 12G-AM-1012-01 12G AM 10122018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   false false true false false   false false false false false false true false   POINT (-73.9687476703117 40.7742856696093)   19 4 19 13
931 931 -73.9785948413883 40.7718908026758 6A-PM-1012-01 06A PM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false true false true   false false false false false false false false   POINT (-73.9785948413883 40.7718908026758)   19 4 19 13
1001 1001 -73.9801985977846 40.7680159511705 1B-AM-1012-11 01B AM 10122018 11 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true false fighting w/ pigeons false false false false false false true false   POINT (-73.9801985977846 40.7680159511705)   19 4 19 13
1098 1098 -73.9604954276129 40.7965682182001 37A-AM-1012-01 37A AM 10122018 1 Adult Cinnamon Gray Cinnamon+Gray Drawing included on tally sheet Ground Plane FALSE   false false false false true scanning (drawing included) false false false false false false false true   POINT (-73.9604954276129 40.7965682182001)   19 4 19 13
1138 1138 -73.9594357049738 40.7840678890949 25I-AM-1012-01 25I AM 10122018 1 Adult Cinnamon   Cinnamon+   Above Ground 4 on bar false false false true false   false false false true true true false false   POINT (-73.9594357049738 40.7840678890949)   19 4 19 13
1165 1165 -73.9689504114652 40.7766770153764 14F-PM-1012-05 14F PM 10122018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 2 on a fallen branch true false false true false sitting false false false false false false false false looking at me POINT (-73.9689504114652 40.7766770153764)   19 4 19 13
1551 1551 -73.9785114291288 40.7719779589449 6A-PM-1012-03 06A PM 10122018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true true true false false   false false false false false false false false   POINT (-73.9785114291288 40.7719779589449)   19 4 19 13
1605 1605 -73.9690362384597 40.7767162824413 14F-PM-1012-09 14F PM 10122018 9 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9690362384597 40.7767162824413)   19 4 19 13
1716 1716 -73.9797425262459 40.7679120246352 1B-AM-1012-02 01B AM 10122018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9797425262459 40.7679120246352)   19 4 19 13
1772 1772 -73.9690540696008 40.7766014124609 14F-PM-1012-08 14F PM 10122018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true true false true true   false false false false false false true false   POINT (-73.9690540696008 40.7766014124609)   19 4 19 13
1871 1871 -73.9748367344424 40.7693513000034 5E-PM-1012-06 05E PM 10122018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 10 oak tree at end of ramp from Chess House true false false false false   false false false false false false false true   POINT (-73.9748367344424 40.7693513000034)   19 4 19 13
1947 1947 -73.9747175419546 40.7692820030878 5E-PM-1012-05 05E PM 10122018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true false false false true   false false false false false true false false begging POINT (-73.9747175419546 40.7692820030878)   19 4 19 13
2205 2205 -73.9594986107981 40.7840083040604 25I-AM-1012-03 25I AM 10122018 3 Adult Cinnamon   Cinnamon+   Above Ground 8 on turn, see map true true false true false   false false false false true true false false   POINT (-73.9594986107981 40.7840083040604)   19 4 19 13
2309 2309 -73.966824257293 40.7753405377869 14H-PM-1012-04 14H PM 10122018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.966824257293 40.7753405377869)   19 4 19 13
2317 2317 -73.9767369686171 40.7735074437085 8B-PM-1012-05 08B PM 10122018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.9767369686171 40.7735074437085)   19 4 19 13
2367 2367 -73.9681671864047 40.7753770538635 14G-AM-1012-04 14G AM 10122018 4 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9681671864047 40.7753770538635)   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
2492 2492 -73.9801619956135 40.7678576697542 1B-AM-1012-09 01B AM 10122018 9 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9801619956135 40.7678576697542)   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
2757 2757 -73.9671419119456 40.7758602486862 14G-AM-1012-01 14G AM 10122018 1 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9671419119456 40.7758602486862)   19 4 19 13
2900 2900 -73.9631005470369 40.7885494057193 28D-AM-1012-01 28D AM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false true   false false false false true false false false   POINT (-73.9631005470369 40.7885494057193)   19 4 19 13
2986 2986 -73.9756533763813 40.7733537881363 8B-PM-1012-07 08B PM 10122018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9756533763813 40.7733537881363)   19 4 19 13
3023 3023 -73.9754794191553 40.7696404489025 5E-PM-1012-01 05E PM 10122018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9754794191553 40.7696404489025)   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 184.856ms