squirrels

31 rows where Hectare Squirrel Number = 3 and Highlight Fur Color = "Cinnamon, White" sorted by Eating

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

Foraging ✖

Highlight Fur Color ✖

  • Cinnamon, White · 31 ✖

Hectare Squirrel Number ✖

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
270 270 -73.9767191629692 40.7730786298701 8B-PM-1012-03 08B PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9767191629692 40.7730786298701)   19 4 19 13
394 394 -73.9719888241794 40.7667681685356 4I-PM-1007-03 04I PM 10072018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 3 ran to tree false false false false false being chased false false false false false false false false   POINT (-73.9719888241794 40.7667681685356)   19 4 19 13
714 714 -73.9691585756191 40.776340465695 14F-AM-1007-03 14F AM 10072018 3 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.9691585756191 40.776340465695)   19 4 19 13
961 961 -73.9731457102903 40.7660255393205 2H-AM-1006-03 02H AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9731457102903 40.7660255393205)   19 4 19 13
1024 1024 -73.9521514669041 40.7949515182825 39H-PM-1013-03 39H PM 10132018 3 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false true true true   POINT (-73.9521514669041 40.7949515182825)   19 4 19 13
1068 1068 -73.96660639702 40.7756655031741 14H-AM-1007-03 14H AM 10072018 3 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.96660639702002 40.7756655031741)   19 4 19 13
1686 1686 -73.9593373093799 40.7982428507976 39A-PM-1014-03 39A PM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Higlights. Made executive adjustments. Above Ground 6 Jumped from ground onto branch false false false false true digging? false false false false true false true false   POINT (-73.95933730937992 40.7982428507976)   19 4 19 13
1876 1876 -73.973598991549 40.7783020016983 14A-PM-1014-03 14A PM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false false false chasing (#4) false false false false false false true false   POINT (-73.973598991549 40.7783020016983)   19 4 19 13
2082 2082 -73.9696802053043 40.7816057406125 19B-PM-1018-03 19B PM 10182018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9696802053043 40.7816057406125)   19 4 19 13
2091 2091 -73.9676112864286 40.7772792086081 16F-AM-1008-03 16F AM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE road true false false false false   false false false false true false true false   POINT (-73.9676112864286 40.7772792086081)   19 4 19 13
2211 2211 -73.9799250782277 40.7676106598889 1B-AM-1012-03 01B AM 10122018 3 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.97992507822771 40.7676106598889)   19 4 19 13
2480 2480 -73.9546780963388 40.7903216522111 34I-AM-1012-03 34I AM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false false nut in mouth false false false false false false true false   POINT (-73.9546780963388 40.7903216522111)   19 4 19 13
2631 2631 -73.9690080105286 40.7710230515054 9I-PM-1010-03 09I PM 10102018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White         false false false false true   false false false false false false true true   POINT (-73.9690080105286 40.7710230515054)   19 4 19 13
2687 2687 -73.9550235589287 40.7951312356844 38F-AM-1018-03 38F AM 10182018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9550235589287 40.7951312356844)   19 4 19 13
2856 2856 -73.9751615527833 40.767013871509 3F-AM-1006-03 03F AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Ground Plane FALSE on the path false false false false true   false false false false false true false false   POINT (-73.9751615527833 40.767013871509)   19 4 19 13
3013 3013 -73.964661337306 40.7769785494935 17I-AM-1014-03 17I AM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon face Above Ground 10   false false true false false climbing (dog barked & it ran up tree) false false false false false false true false   POINT (-73.964661337306 40.7769785494935)   19 4 19 13
21 21 -73.9703781726172 40.7787526130321 16C-PM-1018-03 16C PM 10182018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6   true false false true true   false false false false false false true false   POINT (-73.9703781726172 40.7787526130321)   19 4 19 13
330 330 -73.9708969246276 40.7767695507462 14D-AM-1014-03 14D AM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9708969246276 40.7767695507462)   19 4 19 13
335 335 -73.9782351435852 40.7715896672335 6A-AM-1006-03 06A AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree false true false true false   false false false true true false false false   POINT (-73.9782351435852 40.7715896672335)   19 4 19 13
728 728 -73.9602913105578 40.7910635810038 32D-PM-1006-03 32D PM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 40   false false false true false   false false false false true false true false   POINT (-73.9602913105578 40.7910635810038)   19 4 19 13
1191 1191 -73.9634835346077 40.7918244310746 31A-PM-1017-03 31A PM 10172018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9634835346077 40.7918244310746)   19 4 19 13
1242 1242 -73.9714512125212 40.7760275250114 13D-PM-1018-03 13D PM 10182018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false true true   false false false false false false true false   POINT (-73.9714512125212 40.7760275250114)   19 4 19 13
1669 1669 -73.9691821206863 40.7763203164339 14F-PM-1012-03 14F PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9691821206863 40.7763203164339)   19 4 19 13
1681 1681 -73.9638141923763 40.7829225326288 23F-PM-1013-03 23F PM 10132018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false true false true false indifferent (noticed me,busy eating,foraging) POINT (-73.9638141923763 40.7829225326288)   19 4 19 13
1863 1863 -73.9682830510954 40.7810151087286 19D-PM-1008-03 19D PM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White may be same squirrel as #1 - male Above Ground 5 on branch of dead tree false false false true false   false false false false false false true false   POINT (-73.9682830510954 40.7810151087286)   19 4 19 13
2090 2090 -73.9569759970802 40.7931497452294 35F-PM-1012-03 35F PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 7   false false true true true   false false false false false false false true   POINT (-73.9569759970802 40.79314974522941)   19 4 19 13
2428 2428 -73.9755643404768 40.7697569149388 5E-PM-1012-03 05E PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9755643404768 40.7697569149388)   19 4 19 13
2471 2471 -73.964274290774 40.7795319556023 19H-AM-1010-03 19H AM 10102018 3 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false true false ran from human w/ dog POINT (-73.964274290774 40.7795319556023)   19 4 19 13
2485 2485 -73.9584950620879 40.7902770710643 32F-PM-1008-03 32F PM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true true true true true   false false false false false false true false   POINT (-73.9584950620879 40.7902770710643)   19 4 19 13
2589 2589 -73.9694166642262 40.7697788641081 8I-PM-1013-03 08I PM 10132018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9694166642262 40.7697788641081)   19 4 19 13
2903 2903 -73.9670432105975 40.7753462013506 14H-PM-1012-03 14H PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   true false false true true   false false false false false false true false   POINT (-73.9670432105975 40.7753462013506)   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 306.929ms