squirrels

33 rows where Combination of Primary and Highlight Color = "Gray+Cinnamon", Hectare Squirrel Number = 5 and Indifferent = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Quaas, Tail flags, Tail twitches, Approaches, 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
20 20 -73.9706105896967 40.7698124821507 7H-AM-1006-05 07H AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false true false false false   false false false false false false true false   POINT (-73.9706105896967 40.7698124821507)   19 4 19 13
57 57 -73.9690175838534 40.7760432720017 14F-AM-1007-05 14F AM 10072018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9690175838534 40.7760432720017)   19 4 19 13
339 339 -73.965509576403 40.7752456763263 14I-PM-1018-05 14I PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   false false true true false   false false false false true false true false   POINT (-73.96550957640301 40.7752456763263)   19 4 19 13
516 516 -73.9597418366664 40.7964417084985 37B-PM-1013-05 37B PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9597418366664 40.7964417084985)   19 4 19 13
527 527 -73.9632646049622 40.7817401292083 22G-AM-1018-05 22G AM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9632646049622 40.7817401292083)   19 4 19 13
562 562 -73.972467515471 40.7659131865172 3I-PM-1013-05 03I PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.972467515471 40.7659131865172)   19 4 19 13
595 595 -73.9742804552383 40.7707167671865 7E-PM-1013-05 07E PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE On rocks false false false true true   false false false false true false true false   POINT (-73.9742804552383 40.7707167671865)   19 4 19 13
644 644 -73.972212563004 40.7761311465857 13C-PM-1019-05 13C PM 10192018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false true true true false   POINT (-73.972212563004 40.7761311465857)   19 4 19 13
735 735 -73.971379936565 40.7721434941226 9F-PM-1014-05 09F PM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.971379936565 40.7721434941226)   19 4 19 13
765 765 -73.96797780019 40.7847629473258 23B-PM-1012-05 23B PM 10122018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 chain link fence false true true false false   false false false false false false true false   POINT (-73.96797780019 40.7847629473258)   19 4 19 13
810 810 -73.967418114684 40.7764595360054 15G-AM-1008-05 15G AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.967418114684 40.7764595360054)   19 4 19 13
994 994 -73.9718553361982 40.7748584798761 11D-AM-1010-05 11D AM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9718553361982 40.7748584798761)   19 4 19 13
1020 1020 -73.97016933635 40.7705452529783 8H-AM-1017-05 08H AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   true false false true true   false false false false false false true false   POINT (-73.97016933635001 40.7705452529783)   19 4 19 13
1320 1320 -73.9554327683595 40.7953846381499 38E-AM-1010-05 38E AM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false interested in my presence POINT (-73.9554327683595 40.7953846381499)   19 4 19 13
1367 1367 -73.9542684235907 40.7944237164092 38G-PM-1020-05 38G PM 10202018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false true false true false false true false   POINT (-73.9542684235907 40.7944237164092)   19 4 19 13
1400 1400 -73.9773495807135 40.7664559937331 1E-AM-1006-05 01E AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false true false false   false false false false false false true false   POINT (-73.9773495807135 40.7664559937331)   19 4 19 13
1491 1491 -73.9713070217071 40.7753795014815 12E-AM-1017-05 12E AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9713070217071 40.7753795014815)   19 4 19 13
1676 1676 -73.9566686940197 40.794924397955 37E-PM-1006-05 37E PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9566686940197 40.794924397955)   19 4 19 13
1695 1695 -73.9604083891356 40.7910284106931 32D-AM-1013-05 32D AM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   true false false true false   false false false false false false true false   POINT (-73.9604083891356 40.7910284106931)   19 4 19 13
1705 1705 -73.9765417282001 40.7740994735325 9A-AM-1013-05 09A AM 10132018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false true false   false false false false false false true false   POINT (-73.9765417282001 40.7740994735325)   19 4 19 13
1722 1722 -73.9802564685265 40.7681759098199 2B-AM-1010-05 02B AM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9802564685265 40.7681759098199)   19 4 19 13
1735 1735 -73.9563652303243 40.7955127873968 38E-PM-1014-05 38E PM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE on log false false false false false statue false false false false false false true false   POINT (-73.9563652303243 40.7955127873968)   19 4 19 13
1762 1762 -73.9769106838192 40.7674414870702 2E-AM-1010-05 02E AM 10102018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 33   false false true false false   false false false false false false true false   POINT (-73.9769106838192 40.7674414870702)   19 4 19 13
1923 1923 -73.9743795190073 40.7692030411004 5E-AM-1008-05 05E AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1   false false false false true   false false false false false false true false   POINT (-73.9743795190073 40.7692030411004)   19 4 19 13
1995 1995 -73.9603366992925 40.7899612889539 31E-PM-1006-05 31E PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false true false false true false   POINT (-73.9603366992925 40.789961288953904)   19 4 19 13
2106 2106 -73.9801651470389 40.7677698656935 1B-AM-1012-05 01B AM 10122018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false true true   false false false false false false true false   POINT (-73.9801651470389 40.7677698656935)   19 4 19 13
2260 2260 -73.9784685928652 40.7669924015341 1D-PM-1007-05 01D PM 10072018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9784685928652 40.7669924015341)   19 4 19 13
2305 2305 -73.9679833225379 40.7738547093402 12H-PM-1007-05 12H PM 10072018 5   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9679833225379 40.7738547093402)   19 4 19 13
2506 2506 -73.9719038949487 40.7703533492482 7G-AM-1010-05 07G AM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9719038949487 40.7703533492482)   19 4 19 13
2531 2531 -73.9599424115626 40.7957472585327 37B-AM-1018-05 37B AM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9599424115626 40.7957472585327)   19 4 19 13
2537 2537 -73.9735533713513 40.7690605609001 5F-PM-1007-05 05F PM 10072018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9735533713513 40.7690605609001)   19 4 19 13
2876 2876 -73.9558995737654 40.7960097734603 39E-AM-1018-05 39E AM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9558995737654 40.7960097734603)   19 4 19 13
2923 2923 -73.9672160533827 40.7830263908749 21C-AM-1014-05 21C AM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false true false false true false   POINT (-73.9672160533827 40.7830263908749)   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 63.685ms