squirrels

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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, 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
23 23 -73.9638179439747 40.7924173263904 32A-PM-1013-03 32A PM 10132018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9638179439747 40.7924173263904)   19 4 19 13
124 124 -73.9588660250232 40.7982597947515 40A-AM-1010-03 40A AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE bottom of great hill false false false true true   false false false true false false true true dog chased POINT (-73.9588660250232 40.7982597947515)   19 4 19 13
154 154 -73.9686056085297 40.7781658424866 16E-AM-1014-03 16E AM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9686056085297 40.7781658424866)   19 4 19 13
220 220 -73.967181612203 40.7787752287055 17F-PM-1020-03 17F PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 35   false false true true false   false false false false false false false false   POINT (-73.967181612203 40.7787752287055)   19 4 19 13
418 418 -73.9573604880421 40.7930844158021 35E-PM-1006-03 35E PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9573604880421 40.7930844158021)   19 4 19 13
460 460 -73.9549135206961 40.798525897229 42D-PM-1013-03 42D PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25 in tree false false false true false   false false false false false false true false   POINT (-73.9549135206961 40.798525897229)   19 4 19 13
577 577 -73.9497217674555 40.796517007214 42I-PM-1014-03 42I PM 10142018 3   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9497217674555 40.796517007214)   19 4 19 13
591 591 -73.9543323786888 40.7943086530436 37G-PM-1007-03 37G PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   false false false true false lying on belly on branch,eating big nut false false false false false false false false   POINT (-73.9543323786888 40.7943086530436)   19 4 19 13
786 786 -73.953296595236 40.7927644594513 36I-AM-1017-03 36I AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon Cinnamon stripe on back Ground Plane FALSE   true false false true true   false false false false false false true false   POINT (-73.953296595236 40.7927644594513)   19 4 19 13
830 830 -73.9595645962539 40.7899599350145 31E-PM-1006-03 31E PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE under bushes false false false true true burying false false false false false false true false   POINT (-73.9595645962539 40.7899599350145)   19 4 19 13
878 878 -73.9757215415855 40.7668205976986 2F-PM-1014-03 02F PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9757215415855 40.7668205976986)   19 4 19 13
962 962 -73.9715466850324 40.7695584933538 6H-PM-1020-03 06H PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false true true   false false false false false false false true runs from (kids kicking the fence) POINT (-73.9715466850324 40.7695584933538)   19 4 19 13
1021 1021 -73.97186968288 40.778926988884 15B-AM-1014-03 15B AM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true running (from a dog) false false false false false false true false   POINT (-73.97186968288 40.778926988884)   19 4 19 13
1250 1250 -73.9585133340331 40.7963721679474 38C-PM-1014-03 38C PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   true false false false false false false true   POINT (-73.9585133340331 40.7963721679474)   19 4 19 13
1375 1375 -73.9564741038174 40.7938845572816 36F-AM-1017-03 36F AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon Cinnamon on shoulders Ground Plane FALSE   false false false true true   false false false false false false false true runs from (me) POINT (-73.9564741038174 40.7938845572816)   19 4 19 13
1586 1586 -73.9714150090362 40.7774976423922 14C-PM-1006-03 14C PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9714150090362 40.7774976423922)   19 4 19 13
1620 1620 -73.9635606199784 40.782206970617 22G-AM-1018-03 22G AM 10182018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9635606199784 40.782206970617)   19 4 19 13
1664 1664 -73.9729142912203 40.7724091146678 9E-AM-1008-03 09E AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9729142912203 40.7724091146678)   19 4 19 13
2063 2063 -73.9544763281886 40.7969645476349 40F-PM-1006-03 40F PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9544763281886 40.7969645476349)   19 4 19 13
2109 2109 -73.9744488584414 40.7741627220859 10C-PM-1013-03 10C PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9744488584414 40.7741627220859)   19 4 19 13
2110 2110 -73.9647151303629 40.7912681060756 30A-PM-1020-03 30A PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Rock false false false true false   false false false false false false false true   POINT (-73.9647151303629 40.7912681060756)   19 4 19 13
2127 2127 -73.9562442622553 40.7957285542564 38E-AM-1010-03 38E AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9562442622553 40.7957285542564)   19 4 19 13
2254 2254 -73.9709991016317 40.7725756707748 10F-PM-1019-03 10F PM 10192018 3 Juvenile Gray Cinnamon Gray+Cinnamon Cinnamon head Ground Plane FALSE Behind fence, grass false false false true false eating (nuts) false false false false false true false false approaches (bad tourists w/ nuts) POINT (-73.9709991016317 40.772575670774806)   19 4 19 13
2290 2290 -73.9565645716564 40.7959039949577 38D-PM-1006-03 38D PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9565645716564 40.795903994957705)   19 4 19 13
2472 2472 -73.9596820155238 40.7932886803231 34D-PM-1007-03 34D PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true false false true   POINT (-73.9596820155238 40.7932886803231)   19 4 19 13
2573 2573 -73.9810149147578 40.7683925377714 2A-AM-1010-03 02A AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 on trunk false false false true false   false false false false false false true false   POINT (-73.9810149147578 40.7683925377714)   19 4 19 13
2867 2867 -73.969370141813 40.7840721191988 22A-PM-1017-03 22A PM 10172018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.969370141813 40.7840721191988)   19 4 19 13
2871 2871 -73.9777124331985 40.7704051056666 5B-AM-1008-03 05B AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false false false true false   POINT (-73.9777124331985 40.7704051056666)   19 4 19 13
2954 2954 -73.9677474313377 40.7742119240825 12H-PM-1007-03 12H PM 10072018 3   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false peanuts false false false false false false true false   POINT (-73.9677474313377 40.7742119240825)   19 4 19 13
2957 2957 -73.9747313152152 40.7653888351839 1G-PM-1010-03 01G PM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9747313152152 40.7653888351839)   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 112.81ms