squirrels

27 rows where Above Ground Sighter Measurement = "FALSE", Date = 10182018, Eating = "true" and Runs from = "false"

View and edit SQL

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Color notes, Specific Location, Running, Chasing, Foraging, Other Activities, Tail flags, Tail twitches, Approaches, Indifferent

Combination of Primary and Highlight Color

Runs from

  • false · 27

Date

  • 10182018 · 27

Above Ground Sighter Measurement

  • FALSE · 27
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 -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
266 -73.9786481009499 40.7697372811949 4B-PM-1018-03 04B PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9786481009499 40.7697372811949)   19 4 19 13
309 -73.9696001184129 40.7820810673532 19B-PM-1018-05 19B PM 10182018 5 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray, Cinnamon & White selected as Primary. Gray & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9696001184129 40.7820810673532)   19 4 19 13
450 -73.9644293195773 40.7813829172072 21F-AM-1018-02 21F AM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9644293195773 40.7813829172072)   19 4 19 13
579 -73.9786714207307 40.7696870806229 4B-PM-1018-01 04B PM 10182018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9786714207307 40.7696870806229)   19 4 19 13
864 -73.969485639023 40.780519159069 18C-PM-1018-05 18C PM 10182018 5 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.969485639023 40.780519159069)   19 4 19 13
882 -73.9786805884996 40.7697559231927 4B-PM-1018-02 04B PM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9786805884996 40.7697559231927)   19 4 19 13
970 -73.97035767623 40.7714036487747 9H-PM-1018-09 09H PM 10182018 9 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.97035767623 40.7714036487747)   19 4 19 13
1085 -73.9722265046794 40.7700916895929 7G-PM-1018-02 07G PM 10182018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9722265046794 40.7700916895929)   19 4 19 13
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
1339 -73.9686413326172 40.7817423907284 19C-PM-1018-08 19C PM 10182018 8 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray, Cinnamon & White selected as Primary. Gray & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9686413326172 40.7817423907284)   19 4 19 13
1528 -73.9690104245067 40.7853358193723 23A-AM-1018-02 23A AM 10182018 2 Juvenile Black   Black+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9690104245067 40.7853358193723)   19 4 19 13
1691 -73.9703705008688 40.7818586173755 19B-PM-1018-02 19B PM 10182018 2 Adult Gray Black, Cinnamon Gray+Black, Cinnamon Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9703705008688 40.7818586173755)   19 4 19 13
1725 -73.9657480066074 40.7753465489231 14I-PM-1018-04 14I PM 10182018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false true true false false   POINT (-73.9657480066074 40.7753465489231)   19 4 19 13
1856 -73.9782940231149 40.7694236097224 4B-PM-1018-05 04B PM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9782940231149 40.7694236097224)   19 4 19 13
1898 -73.9721263050502 40.7698763846186 7G-PM-1018-01 07G PM 10182018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9721263050502 40.7698763846186)   19 4 19 13
2048 -73.9627661465376 40.7819356810575 22G-PM-1018-02 22G PM 10182018 2 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.9627661465376 40.7819356810575)   19 4 19 13
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
2188 -73.9676113345824 40.7803482448467 19E-PM-1018-03 19E PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE Baseball field #3 false false false true false   false false false false false false false false   POINT (-73.9676113345824 40.7803482448467)   19 4 19 13
2189 -73.9761776424664 40.7695941843825 5D-PM-1018-07 05D PM 10182018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9761776424664 40.7695941843825)   19 4 19 13
2255 -73.9642967875857 40.7815652353937 21F-AM-1018-08 21F AM 10182018 8 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9642967875857 40.7815652353937)   19 4 19 13
2294 -73.9630820577441 40.7821632293136 22G-PM-1018-01 22G PM 10182018 1 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 false   false false false true false false true false   POINT (-73.9630820577441 40.7821632293136)   19 4 19 13
2339 -73.9695117797648 40.7802675743233 18C-PM-1018-07 18C PM 10182018 7   Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9695117797648 40.780267574323304)   19 4 19 13
2510 -73.9748635473782 40.7742591029151 10C-AM-1018-02 10C AM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false sitting in the sun false false false false false false true false   POINT (-73.9748635473782 40.7742591029151)   19 4 19 13
2756 -73.9787312025627 40.7701071405918 4B-PM-1018-04 04B PM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9787312025627 40.7701071405918)   19 4 19 13
2941 -73.9690266660317 40.7853134751509 23A-AM-1018-01 23A AM 10182018 1 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9690266660317 40.7853134751509)   19 4 19 13
3014 -73.9665572004288 40.7804347548303 19E-PM-1018-04 19E PM 10182018 4   Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9665572004288 40.7804347548303)   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 86.464ms