squirrels

25 rows where Date = 10192018, Indifferent = "false" and Location = "Above Ground"

✎ View and edit SQL

This data as json, CSV (advanced)

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

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 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
185 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
366 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
512 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
981 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 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 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 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 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
1381 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 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
1411 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 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
1653 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 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
1977 1977 -73.9586570546871 40.796349417475 38C-AM-1019-09 38C AM 10192018 9 Adult Gray White Gray+White Gray & White selected as Primary & Highlights. Made executive adjustments. Above Ground 3 Between ground & tree false false false true true   false false false false true false false true   POINT (-73.9586570546871 40.796349417475)   19 4 19 13
2153 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
2215 2215 -73.9674978826751 40.776288410765 15G-PM-1019-10 15G PM 10192018 10 Adult Gray   Gray+   Above Ground 1 on a log false false false true false   false false false false false false false true   POINT (-73.9674978826751 40.776288410765)   19 4 19 13
2335 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 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
2629 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 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
2777 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 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 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

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 58.187ms