squirrels

49 rows where Date = 10192018, Indifferent = "false" and Runs from = "false"

View and edit SQL

Suggested facets: Hectare, Shift, 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, Other Interactions

Runs from

  • false · 49

Date

  • 10192018 · 49
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
6 -73.9565700386162 40.7902561000937 33H-AM-1019-02 33H AM 10192018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false wrestling with mother false false false false false false false false   POINT (-73.9565700386162 40.7902561000937)   19 4 19 13
53 -73.9584970643213 40.7982886348696 40B-AM-1019-03 40B AM 10192018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false true true false false   POINT (-73.9584970643213 40.7982886348696)   19 4 19 13
85 -73.9676410497481 40.7766043512974 15G-PM-1019-05 15G PM 10192018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   false false true false false   false false false false false false false false   POINT (-73.9676410497481 40.7766043512974)   19 4 19 13
172 -73.958535640774 40.7982737896998 40B-AM-1019-02 40B AM 10192018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false true false false false   POINT (-73.958535640774 40.7982737896998)   19 4 19 13
185 -73.9588468413094 40.7963852299012 38B-AM-1019-05 38B AM 10192018 5 Adult Gray   Gray+   Above Ground 28   false false true false false sitting still false true false false false false false false   POINT (-73.9588468413094 40.7963852299012)   19 4 19 13
218 -73.9712318712643 40.7773053099657 14D-PM-1019-04 14D PM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9712318712643 40.7773053099657)   19 4 19 13
363 -73.9707197274481 40.7773956803431 14D-PM-1019-12 14D PM 10192018 12 Adult Gray   Gray+         false false false false false   false false false false false false false false   POINT (-73.9707197274481 40.7773956803431)   19 4 19 13
366 -73.9673548527075 40.7765669058396 15G-PM-1019-11 15G PM 10192018 11 Adult Gray   Gray+   Above Ground 4   false false true false false   false false false false false false false false stared POINT (-73.9673548527075 40.7765669058396)   19 4 19 13
390 -73.970720187655 40.7774564799983 14D-PM-1019-11 14D PM 10192018 11 Adult Gray   Gray+         false false false false false   false false false false false false false false   POINT (-73.970720187655 40.7774564799983)   19 4 19 13
455 -73.9688574691102 40.7837825208444 21B-AM-1019-04 21B AM 10192018 4       +         false false false false false   false false false false false false false false   POINT (-73.9688574691102 40.7837825208444)   19 4 19 13
482 -73.9721797824576 40.7801213843628 16A-PM-1019-07 16A PM 10192018 7 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false true true false false approaches (very friendly) POINT (-73.9721797824576 40.7801213843628)   19 4 19 13
512 -73.9586098170241 40.7939653733898 35D-AM-1019-01 35D AM 10192018 1       +   Above Ground   on tree, blue jays gathering nearby false false false false false   true false false false false false false false   POINT (-73.9586098170241 40.7939653733898)   19 4 19 13
699 -73.9504693544225 40.797225436004 42H-AM-1019-01 42H AM 10192018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9504693544225 40.797225436004)   19 4 19 13
981 -73.9673160165357 40.7766158001202 15G-PM-1019-12 15G PM 10192018 12 Adult Gray   Gray+   Above Ground 4   false false true false false   false false false false false false false false stared POINT (-73.9673160165357 40.7766158001202)   19 4 19 13
991 -73.9635689059841 40.790163434915 30B-PM-1019-03 30B PM 10192018 3 Adult Gray Black Gray+Black   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9635689059841 40.790163434915)   19 4 19 13
1037 -73.9677409841969 40.7763579140639 15G-PM-1019-08 15G PM 10192018 8 Adult     +   Above Ground 5   false true false false false   false true true false false false false false   POINT (-73.9677409841969 40.7763579140639)   19 4 19 13
1152 -73.9608399003798 40.7817704502248 23I-AM-1019-01 23I AM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 18 on a tree false false true false false   false false false false false false false false eyed me warily,then went up the tree POINT (-73.9608399003798 40.7817704502248)   19 4 19 13
1254 -73.9764013589865 40.7663063499207 1F-PM-1019-03 01F PM 10192018 3 Juvenile Gray   Gray+   Above Ground 1   false false false false false hiding false false false false false false false false   POINT (-73.9764013589865 40.7663063499207)   19 4 19 13
1265 -73.9603597117619 40.7824399298414 23I-PM-1019-02 23I PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   false false true false false   false false false false false false false false   POINT (-73.9603597117619 40.7824399298414)   19 4 19 13
1286 -73.9589096782789 40.7939698757903 35D-AM-1019-02 35D AM 10192018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Black tail & edge, Cinnamon mid, While tail edge Ground Plane FALSE   false false false false true very quietly searching in long grass false false false false false false false false   POINT (-73.9589096782789 40.7939698757903)   19 4 19 13
1372 -73.9528353702209 40.7976456178263 41F-PM-1019-02 41F PM 10192018 2       +         false false false false false   false false false false false false false false   POINT (-73.9528353702209 40.7976456178263)   19 4 19 13
1383 -73.9676732725672 40.7763194425467 15G-PM-1019-09 15G PM 10192018 9 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9676732725672 40.7763194425467)   19 4 19 13
1411 -73.9802840031759 40.7678599069819 1B-PM-1019-04 01B PM 10192018 4 Juvenile Gray White Gray+White   Above Ground 25 in tree false true false false false   false false false false false false false false   POINT (-73.9802840031759 40.7678599069819)   19 4 19 13
1423 -73.9600204328201 40.782877291358 24I-AM-1019-01 24I AM 10192018 1 Adult Gray White Gray+White   Above Ground 10   false false false true false   false false false false false false false false   POINT (-73.9600204328201 40.782877291358)   19 4 19 13
1441 -73.961335649743 40.7818876867842 23H-PM-1019-01 23H PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.961335649743 40.7818876867842)   19 4 19 13
1642 -73.9708860879459 40.7768376656119 14D-PM-1019-15 14D PM 10192018 15 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9708860879459 40.7768376656119)   19 4 19 13
1653 -73.9695881075086 40.7842441291991 21A-AM-1019-01 21A AM 10192018 1 Juvenile Gray Black Gray+Black   Above Ground 3   false false true false false   false false false false false false false false keeps to tree,drops down on side away from people POINT (-73.9695881075086 40.7842441291991)   19 4 19 13
1688 -73.9677593344667 40.7763054313195 15G-PM-1019-07 15G PM 10192018 7 Adult     +   Above Ground 5   false true false false false   false false false false true false false false   POINT (-73.9677593344667 40.7763054313195)   19 4 19 13
1764 -73.9534878316472 40.7978951981698 41F-PM-1019-01 41F PM 10192018 1       +         false false false false false   false false false false false false false false   POINT (-73.9534878316472 40.7978951981698)   19 4 19 13
1956 -73.980897497712 40.7690578709841 2A-PM-1019-02 02A PM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false true false false false false   POINT (-73.980897497712 40.7690578709841)   19 4 19 13
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
2036 -73.9610266708075 40.7817512107392 23I-PM-1019-03 23I PM 10192018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9610266708075 40.7817512107392)   19 4 19 13
2053 -73.9711810222421 40.7773445611969 14D-PM-1019-05 14D PM 10192018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9711810222421 40.7773445611969)   19 4 19 13
2153 -73.9797122322834 40.7678347587435 1B-PM-1019-10 01B PM 10192018 10 Adult Cinnamon White Cinnamon+White   Above Ground   Dog chased up tree false false true false false   false false false false true false false false   POINT (-73.97971223228342 40.7678347587435)   19 4 19 13
2198 -73.9709738166531 40.7774102689734 14D-PM-1019-08 14D PM 10192018 8 Adult Gray   Gray+   Ground Plane FALSE   false false true false false   false false false false false false false false   POINT (-73.9709738166531 40.7774102689734)   19 4 19 13
2237 -73.9708225719705 40.7772497804149 14D-PM-1019-13 14D PM 10192018 13 Adult Gray   Gray+         false false false false false   false false false false false false false false   POINT (-73.9708225719705 40.7772497804149)   19 4 19 13
2254 -73.9709991016317 40.7725756707748 10F-PM-1019-03 10F PM 10192018 3 Juvenile Gray Cinnamon Gray+Cinnamon Cinnamon head Ground Plane FALSE Behind fence, grass false false false true false eating (nuts) false false false false false true false false approaches (bad tourists w/ nuts) POINT (-73.9709991016317 40.772575670774806)   19 4 19 13
2380 -73.9761375729505 40.7662231892125 1F-PM-1019-02 01F PM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   false false true true false   false false false false false true false false   POINT (-73.9761375729505 40.7662231892125)   19 4 19 13
2509 -73.9714295102249 40.776954371947 14D-PM-1019-02 14D PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9714295102249 40.776954371947)   19 4 19 13
2527 -73.9675697600155 40.7766797414463 15G-PM-1019-06 15G PM 10192018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true scratching! false false false false false false false false   POINT (-73.9675697600155 40.7766797414463)   19 4 19 13
2597 -73.97063044051 40.7771060594808 14D-PM-1019-14 14D PM 10192018 14 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.97063044051 40.7771060594808)   19 4 19 13
2629 -73.9604576237503 40.7818120101394 23I-PM-1019-01 23I PM 10192018 1 Adult Gray   Gray+   Above Ground 35   true false false false false running (across branches) false false false false false false false false   POINT (-73.9604576237503 40.7818120101394)   19 4 19 13
2660 -73.9726056411971 40.7793467904743 16A-PM-1019-03 16A PM 10192018 3   Gray   Gray+   Above Ground 15   false false true false false   false false false false false false false false   POINT (-73.9726056411971 40.7793467904743)   19 4 19 13
2715 -73.9710273070712 40.7766521246153 14D-PM-1019-16 14D PM 10192018 16 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9710273070712 40.7766521246153)   19 4 19 13
2777 -73.9810843611086 40.7687905493699 2A-PM-1019-05 02A PM 10192018 5 ? Gray   Gray+   Above Ground 50 in tall planetree true false false false false   false false false false false false false false   POINT (-73.9810843611086 40.7687905493699)   19 4 19 13
2865 -73.9802842404016 40.7678257384977 1B-PM-1019-03 01B PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 25 in tree false true false false false   false false false false false false false false   POINT (-73.98028424040162 40.7678257384977)   19 4 19 13
2877 -73.9730027200009 40.7798000868804 16A-PM-1019-05 16A PM 10192018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false true false false   false false false false false false false false   POINT (-73.9730027200009 40.7798000868804)   19 4 19 13
2882 -73.956581233786 40.7902127690837 33H-AM-1019-01 33H AM 10192018 1 Adult Cinnamon Gray Cinnamon+Gray Cinnamon patches Ground Plane FALSE   false false false false false wrestling with child false false false false false false false false   POINT (-73.956581233786 40.79021276908371)   19 4 19 13
2902 -73.9673220504383 40.7770296345963 15G-PM-1019-04 15G PM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9673220504383 40.7770296345963)   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 60.834ms