squirrels

33 rows where Climbing = "true" and Date = 10192018

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, Chasing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Running

Date

  • 10192018 · 33

Climbing

  • true · 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
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
99 -73.9710541405708 40.7724691605718 10F-PM-1019-05 10F PM 10192018 5 Adult Black   Black+   Above Ground 10 Behind fence, tree false false true false false   false false false false false false true false   POINT (-73.9710541405708 40.7724691605718)   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
274 -73.9639832886071 40.7909532437095 30B-PM-1019-08 30B PM 10192018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false false true   POINT (-73.9639832886071 40.7909532437095)   19 4 19 13
286 -73.9720907384613 40.7762987836055 13C-PM-1019-01 13C PM 10192018 1 Adult Gray   Gray+   Above Ground 7   false false true false false   true false false false false false true false   POINT (-73.9720907384613 40.7762987836055)   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
737 -73.9711176999471 40.7724278547281 10F-PM-1019-06 10F PM 10192018 6 Adult Gray White Gray+White   Above Ground 10 Different tree false false true false false   false false false false false false true false   POINT (-73.9711176999471 40.7724278547281)   19 4 19 13
964 -73.9631045499811 40.7906180969472 30B-PM-1019-04 30B PM 10192018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false true true true   false false false false false false false true   POINT (-73.9631045499811 40.7906180969472)   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
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
1185 -73.958230674366 40.7989268396525 40B-AM-1019-08 40B AM 10192018 8 Adult Gray White Gray+White   Ground Plane FALSE   false false true false true   false false false false false false true true   POINT (-73.958230674366 40.7989268396525)   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
1381 -73.9586077039567 40.7961896477077 38C-AM-1019-10 38C AM 10192018 10 Adult Gray White Gray+White   Above Ground 20   true false true true false   true false false false true false false true   POINT (-73.9586077039567 40.7961896477077)   19 4 19 13
1410 -73.9587913289229 40.7961707624534 38C-AM-1019-11 38C AM 10192018 11 Adult Gray White Gray+White   Above Ground 20   true false true true false   true false false false true false false true   POINT (-73.9587913289229 40.7961707624534)   19 4 19 13
1517 -73.970041085185 40.7834427580313 21A-AM-1019-07 21A AM 10192018 7 Adult Gray   Gray+   Above Ground 25   true false true false false   false false false false false false true false   POINT (-73.970041085185 40.783442758031306)   19 4 19 13
1591 -73.9576223390082 40.7979746639647 40B-AM-1019-04 40B AM 10192018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true false true   false false false false false true true false   POINT (-73.9576223390082 40.79797466396471)   19 4 19 13
1613 -73.9599202233536 40.7972599930224 38A-AM-1019-02 38A AM 10192018 2 Adult Gray   Gray+   Above Ground 3   true true true false false   false false false false false false true false   POINT (-73.9599202233536 40.7972599930224)   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
1897 -73.97107389601 40.7723265810536 10F-PM-1019-07 10F PM 10192018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 Same tree (as #6) false false true false false   false false false false false false true false   POINT (-73.97107389601 40.7723265810536)   19 4 19 13
1943 -73.9690447463294 40.783913304529 21B-AM-1019-06 21B AM 10192018 6 Juvenile Gray   Gray+   Above Ground 7   false false true true false   false false false false false false true false   POINT (-73.9690447463294 40.78391330452901)   19 4 19 13
2064 -73.970260899173 40.783651724865 21A-AM-1019-05 21A AM 10192018 5 Adult Gray   Gray+   Above Ground 2   false false true false false   false false false false false false true false   POINT (-73.970260899173 40.783651724865)   19 4 19 13
2079 -73.9643025171914 40.790570391517 30B-PM-1019-06 30B PM 10192018 6 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false false true false true   false false false false false false false true   POINT (-73.9643025171914 40.790570391517)   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
2335 -73.9704679459444 40.7773384236212 14D-PM-1019-10 14D PM 10192018 10 Adult Gray   Gray+   Above Ground 20   false false true false false   false false false true false false false true   POINT (-73.9704679459444 40.7773384236212)   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
2466 -73.9599419926299 40.7972774728811 38A-AM-1019-01 38A AM 10192018 1 Adult Gray   Gray+   Above Ground 3   true true true false false   false false false false false false true false   POINT (-73.9599419926299 40.7972774728811)   19 4 19 13
2517 -73.9710221361528 40.7724939691584 10F-PM-1019-01 10F PM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon head & stripe Above Ground 2 Behind fence, tree trunk false false true false false sitting false false false false false false true false   POINT (-73.9710221361528 40.7724939691584)   19 4 19 13
2588 -73.9581007437094 40.7959403112722 38C-AM-1019-06 38C AM 10192018 6 Adult Gray   Gray+   Above Ground 23   false false true false false   true false false true false false true false   POINT (-73.9581007437094 40.7959403112722)   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
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
3017 -73.9662895079734 40.7843300758044 23C-AM-1019-01 23C AM 10192018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray, Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 7   false false true true false eating (on branch) true false false false false false true false   POINT (-73.9662895079734 40.7843300758044)   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 68.489ms