squirrels

30 rows where Combination of Primary and Highlight Color = "Gray+White", Eating = "true" and Hectare Squirrel Number = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, 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
82 82 -73.9688271202401 40.7809719445309 19C-PM-1018-01 19C PM 10182018 1 Adult Gray White Gray+White   Ground Plane FALSE   true true false true false   false false false false true false true false   POINT (-73.9688271202401 40.7809719445309)   19 4 19 13
143 143 -73.9661361310677 40.7787872561177 18G-PM-1013-01 18G PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true burying false false false false false false false true   POINT (-73.9661361310677 40.7787872561177)   19 4 19 13
272 272 -73.9521950056404 40.794937340845 39H-PM-1013-01 39H PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false ran away when a human approached with a dog POINT (-73.9521950056404 40.794937340845)   19 4 19 13
294 294 -73.9756573579063 40.7656644063024 1G-PM-1010-01 01G PM 10102018 1 Adult Gray White Gray+White   Above Ground 15   false false true true false   false false false true false false true false too busy eating in his tree POINT (-73.9756573579063 40.7656644063024)   19 4 19 13
382 382 -73.9735946835545 40.7724155751282 8E-PM-1008-01 08E PM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE by tree trunk base false false false true false   false false false false false true false false eating food being thrown at it by a mom & baby POINT (-73.9735946835545 40.7724155751282)   19 4 19 13
383 383 -73.9588358879692 40.7912631913057 33E-PM-1012-01 33E PM 10122018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9588358879692 40.7912631913057)   19 4 19 13
488 488 -73.9615751148595 40.7954551238146 36A-AM-1018-01 36A AM 10182018 1 Juvenile Gray White Gray+White   Above Ground 15   false false false true false eating (red berries) false false false false false false true false   POINT (-73.9615751148595 40.7954551238146)   19 4 19 13
498 498 -73.9669432929573 40.779136518298 18F-AM-1014-01 18F AM 10142018 1 Adult Gray White Gray+White   Above Ground   Low tree false false false true false   false false false false false false true false   POINT (-73.9669432929573 40.779136518298)   19 4 19 13
643 643 -73.976730206737 40.773709213914 8A-PM-1014-01 08A PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false true true false   true false false false false false false true runs from (goes up a tree) POINT (-73.976730206737 40.773709213914)   19 4 19 13
736 736 -73.9660110060416 40.7809990098597 20F-AM-1014-01 20F AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9660110060416 40.7809990098597)   19 4 19 13
845 845 -73.9582850206205 40.7978975855555 39B-PM-1014-01 39B PM 10142018 1 Adult Gray White Gray+White White belly Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9582850206205 40.7978975855555)   19 4 19 13
996 996 -73.9703149829421 40.7785583630323 16D-AM-1007-01 16D AM 10072018 1 Adult Gray White Gray+White   Above Ground 3   false false true true false   false false false false false false false true   POINT (-73.9703149829421 40.7785583630323)   19 4 19 13
1107 1107 -73.9530739562131 40.7932034409546 37H-PM-1006-01 37H PM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false false true from voice POINT (-73.95307395621312 40.7932034409546)   19 4 19 13
1241 1241 -73.9651817987035 40.7819082838334 21E-AM-1017-01 21E AM 10172018 1 Adult Gray White Gray+White   Above Ground 3 Climbs small tree false false false true true   false false false false true false false false walks from POINT (-73.9651817987035 40.7819082838334)   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
1430 1430 -73.970804709441 40.7758611111219 13E-PM-1008-01 13E PM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.970804709441 40.7758611111219)   19 4 19 13
1478 1478 -73.9676370985166 40.7869888639434 25A-AM-1013-01 25A AM 10132018 1   Gray White Gray+White White Belly Ground Plane FALSE   false false false true false staring at me false false false false false false true false   POINT (-73.96763709851662 40.7869888639434)   19 4 19 13
1545 1545 -73.9669207809051 40.7792767850126 18F-PM-1008-01 18F PM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9669207809051 40.7792767850126)   19 4 19 13
1667 1667 -73.9645989003589 40.7782157459155 18H-PM-1014-01 18H PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false true true false   false false false false false false true false   POINT (-73.9645989003589 40.7782157459155)   19 4 19 13
1707 1707 -73.9604524271167 40.7956624328733 36B-AM-1013-01 36B AM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9604524271167 40.7956624328733)   19 4 19 13
1911 1911 -73.9528937660465 40.7922919074537 36I-AM-1017-01 36I AM 10172018 1 Adult Gray White Gray+White   Ground Plane FALSE   true false false true true   false false false false true false false true runs from (me!)—from a pretty big distance POINT (-73.9528937660465 40.7922919074537)   19 4 19 13
1983 1983 -73.9784144867639 40.7718177667511 6A-AM-1006-01 06A AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false true true true   false false false false false false false false   POINT (-73.9784144867639 40.7718177667511)   19 4 19 13
2116 2116 -73.9801562527339 40.7687267327113 2B-AM-1010-01 02B AM 10102018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9801562527339 40.7687267327113)   19 4 19 13
2125 2125 -73.9687933229572 40.7788600242549 17E-PM-1018-01 17E PM 10182018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9687933229572 40.7788600242549)   19 4 19 13
2221 2221 -73.9771847728747 40.7695971164981 4C-AM-1006-01 04C AM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9771847728747 40.7695971164981)   19 4 19 13
2497 2497 -73.9622050752008 40.7886373772305 29D-PM-1010-01 29D PM 10102018 1 Juvenile Gray White Gray+White   Above Ground 10   false false true true false   false false false false false false true false   POINT (-73.9622050752008 40.7886373772305)   19 4 19 13
2526 2526 -73.9646495450499 40.7791203699027 19H-PM-1008-01 19H PM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9646495450499 40.7791203699027)   19 4 19 13
2545 2545 -73.9617594316752 40.7946803725236 35A-AM-1014-01 35A AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   true false false true false   false false false false false false true false   POINT (-73.9617594316752 40.7946803725236)   19 4 19 13
2706 2706 -73.9745141185576 40.7691479781207 5E-AM-1008-01 05E AM 10082018 1 Adult Gray White Gray+White   Above Ground 2 on a checker table false false false true false   false false false false false false true false   POINT (-73.9745141185576 40.7691479781207)   19 4 19 13
2843 2843 -73.9714787178201 40.7798049470745 16B-PM-1017-01 16B PM 10172018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9714787178201 40.7798049470745)   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 59.024ms