squirrels

44 rows where Date = 10132018 and Hectare Squirrel Number = 5 sorted by Longitude

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, 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, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Police Precincts ✖

Hectare Squirrel Number ✖

Date ✖

  • 10132018 · 44 ✖
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
1900 1900 -73.9529224802393 40.7961895763649 40G-PM-1013-05 40G PM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (to the tree) POINT (-73.9529224802393 40.7961895763649)   19 4 19 13
474 474 -73.9540652304705 40.7955226178199 39G-PM-1013-05 39G PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false true   false false false false false false false false   POINT (-73.9540652304705 40.7955226178199)   19 4 19 13
646 646 -73.954092292214 40.7979800395433 41E-PM-1013-05 41E PM 10132018 5 Juvenile Gray Cinnamon, White Gray+Cinnamon, White White tail Above Ground 10   false false false true false   false false false false false false false false   POINT (-73.954092292214 40.7979800395433)   19 4 19 13
101 101 -73.9544007658685 40.7950689723135 38F-PM-1013-05 38F PM 10132018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true being chased,was pushed by other squirrel true true false false false false false false   POINT (-73.9544007658685 40.7950689723135)   19 4 19 13
261 261 -73.9552861155228 40.788973931872 32I-AM-1013-05 32I AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3 In and below shrub false false true false true   false false false true false false true false   POINT (-73.9552861155228 40.788973931872)   19 4 19 13
2202 2202 -73.9556039997621 40.7977549157287 40D-AM-1013-05 40D AM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9556039997621 40.7977549157287)   19 4 19 13
536 536 -73.9561141662309 40.7976258458604 40D-PM-1013-05 40D PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9561141662309 40.7976258458604)   19 4 19 13
2693 2693 -73.9561498646036 40.7949288561893 37E-AM-1013-05 37E AM 10132018 5 ?     +   Above Ground 10 unsure, just heard kuks false false false false false   true false false false false false false false   POINT (-73.9561498646036 40.79492885618931)   19 4 19 13
1574 1574 -73.9561840935803 40.7992037821497 42C-PM-1013-05 42C PM 10132018 5 Adult Gray   Gray+   Above Ground 20   false false false true false   true false false false false false true false   POINT (-73.9561840935803 40.7992037821497)   19 4 19 13
2012 2012 -73.9587464852561 40.793496354083 35D-PM-1013-05 35D PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9587464852561 40.793496354083)   19 4 19 13
2032 2032 -73.9590157104896 40.7956884493421 37C-PM-1013-05 37C PM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9590157104896 40.7956884493421)   19 4 19 13
2483 2483 -73.9596083366477 40.7949526729608 36C-PM-1013-05 36C PM 10132018 5 Adult Cinnamon   Cinnamon+ "Warm brown" written in for Primary. Ground Plane FALSE Ran across path in front of people true false false true true   false false false false true false true true   POINT (-73.9596083366477 40.7949526729608)   19 4 19 13
2817 2817 -73.9596445861554 40.7971948679007 38A-PM-1013-05 38A PM 10132018 5 Adult Black   Black+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9596445861554 40.7971948679007)   19 4 19 13
516 516 -73.9597418366664 40.7964417084985 37B-PM-1013-05 37B PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9597418366664 40.7964417084985)   19 4 19 13
1348 1348 -73.9599197612389 40.7954836456006 36B-PM-1013-05 36B PM 10132018 5 Adult Gray   Gray+   Above Ground 4   true false false false false   false false false false false false false true   POINT (-73.9599197612389 40.7954836456006)   19 4 19 13
989 989 -73.9603031059614 40.7943667735668 35C-PM-1013-05 35C PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9603031059614 40.7943667735668)   19 4 19 13
1695 1695 -73.9604083891356 40.7910284106931 32D-AM-1013-05 32D AM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   true false false true false   false false false false false false true false   POINT (-73.9604083891356 40.7910284106931)   19 4 19 13
1501 1501 -73.9608167300104 40.7954348688268 36A-PM-1013-05 36A PM 10132018 5   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE EDGE OF WOODS false false false false true   false false false false false false false true   POINT (-73.9608167300104 40.7954348688268)   19 4 19 13
1496 1496 -73.9615500510038 40.7920799263699 32C-PM-1013-05 32C PM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9615500510038 40.7920799263699)   19 4 19 13
2820 2820 -73.9615926031253 40.7944223235385 35B-PM-1013-05 35B PM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   true false true false false chased by dog #2 true false false false false false false true runs from (dog) POINT (-73.96159260312531 40.7944223235385)   19 4 19 13
1854 1854 -73.9618076359384 40.7947808718203 35A-PM-1013-05 35A PM 10132018 5 Adult Gray   Gray+   Above Ground 3 in tree false false true false false   false false false false false false false false   POINT (-73.9618076359384 40.7947808718203)   19 4 19 13
2913 2913 -73.9621297946132 40.7944058222814 34A-PM-1013-05 34A PM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4   true false false false false   false false false false false false false false   POINT (-73.9621297946132 40.7944058222814)   19 4 19 13
887 887 -73.9635028497015 40.7928207574906 32A-PM-1013-05 32A PM 10132018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false true false false false true   POINT (-73.9635028497015 40.7928207574906)   19 4 19 13
1188 1188 -73.9669529835992 40.7871864151365 25A-AM-1013-05 25A AM 10132018 5   Gray   Gray+   Ground Plane FALSE CROSS BRIDLE - INTO TREE TO AVOID DOGGO true false true false false d.p.t. false false false true true false true false calm POINT (-73.96695298359921 40.7871864151365)   19 4 19 13
1571 1571 -73.9673129010312 40.7778169845999 16F-PM-1013-05 16F PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Pine tree near utility shed false false false true true   false false false false false false false true   POINT (-73.9673129010312 40.7778169845999)   19 4 19 13
1467 1467 -73.9684657285532 40.7840113573723 22B-AM-1013-05 22B AM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   tree false false true false false   false false false false false false false false looked down on me like her imperial subject POINT (-73.9684657285532 40.7840113573723)   19 4 19 13
1014 1014 -73.9694468044483 40.770360886038 8I-PM-1013-05 08I PM 10132018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9694468044483 40.770360886038)   19 4 19 13
17 17 -73.9695063535333 40.7823507678183 20B-PM-1013-05 20B PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9695063535333 40.7823507678183)   19 4 19 13
416 416 -73.9702788578386 40.7694484997295 7I-PM-1013-05 07I PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Rock false false false true false   false false false true false false false false   POINT (-73.9702788578386 40.7694484997295)   19 4 19 13
3020 3020 -73.9704015859639 40.7825600069973 19A-PM-1013-05 19A PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9704015859639 40.7825600069973)   19 4 19 13
34 34 -73.9704402681017 40.7798965621203 17C-PM-1013-05 17C PM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true false eating (ate upside down on a tree — #jealous) false false false false false false true false   POINT (-73.9704402681017 40.77989656212031)   19 4 19 13
1157 1157 -73.9704449096084 40.7689970778303 6I-PM-1013-05 06I PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false playing with #6 false false false false true false false false   POINT (-73.9704449096084 40.7689970778303)   19 4 19 13
562 562 -73.972467515471 40.7659131865172 3I-PM-1013-05 03I PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.972467515471 40.7659131865172)   19 4 19 13
595 595 -73.9742804552383 40.7707167671865 7E-PM-1013-05 07E PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE On rocks false false false true true   false false false false true false true false   POINT (-73.9742804552383 40.7707167671865)   19 4 19 13
2767 2767 -73.9751806727197 40.7671940332258 3F-PM-1013-05 03F PM 10132018 5 Adult Gray White Gray+White   Above Ground 13   true false false false false   false false false false false false false true   POINT (-73.97518067271972 40.7671940332258)   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
239 239 -73.9758464905133 40.7725957408841 8C-PM-1013-05 08C PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9758464905133 40.7725957408841)   19 4 19 13
1403 1403 -73.9761632586697 40.7741085606149 9B-PM-1013-05 09B PM 10132018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false true false false true false   POINT (-73.9761632586697 40.7741085606149)   19 4 19 13
1705 1705 -73.9765417282001 40.7740994735325 9A-AM-1013-05 09A AM 10132018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false true false   false false false false false false true false   POINT (-73.9765417282001 40.7740994735325)   19 4 19 13
2646 2646 -73.9772239251936 40.7731716665766 8A-AM-1013-05 08A AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   true false true true false   false false false false false true false false   POINT (-73.9772239251936 40.7731716665766)   19 4 19 13
1594 1594 -73.9778730762957 40.770827251547 5B-PM-1013-05 05B PM 10132018 5 Adult Gray   Gray+   Above Ground 3   true false true false false   false false false false false false false true   POINT (-73.9778730762957 40.770827251547)   19 4 19 13
412 412 -73.9785675798034 40.7672992405289 1C-PM-1013-05 01C PM 10132018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9785675798034 40.7672992405289)   19 4 19 13
1728 1728 -73.9787846880249 40.7682545903488 2C-PM-1013-05 02C PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9787846880249 40.7682545903488)   19 4 19 13
1587 1587 -73.9805517765469 40.7683044693163 2B-PM-1013-05 02B PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false true false false climbing fence! false false false false false false false false snuck into bike cart! POINT (-73.9805517765469 40.7683044693163)   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 72.962ms