squirrels

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

✎ 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, Chasing, Climbing, Eating, Foraging, Other Activities, Quaas, Tail flags, Tail twitches, 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
190 190 -73.9695507965155 40.7743070423435 12F-PM-1007-04 12F PM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false stared POINT (-73.96955079651552 40.7743070423435)   19 4 19 13
242 242 -73.9590236602085 40.7982632456866 40A-AM-1010-04 40A AM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE bottom great hill false false false false true   false false false true false false true true dog chased POINT (-73.9590236602085 40.7982632456866)   19 4 19 13
252 252 -73.974420668782 40.7749628597465 10C-PM-1013-04 10C PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.974420668782 40.7749628597465)   19 4 19 13
275 275 -73.974467903723 40.7686520352868 4F-PM-1013-04 04F PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.974467903723 40.7686520352868)   19 4 19 13
293 293 -73.9696173677837 40.7705202790525 8H-AM-1017-04 08H AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9696173677837 40.7705202790525)   19 4 19 13
318 318 -73.9743990576746 40.7768690723163 12A-PM-1013-04 12A PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Above Ground 1   false true false false false chasing #3 false false false false false false true false   POINT (-73.9743990576746 40.7768690723163)   19 4 19 13
343 343 -73.9730224561601 40.7796833353894 16A-PM-1019-04 16A PM 10192018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9730224561601 40.7796833353894)   19 4 19 13
445 445 -73.9714057327159 40.7720375135272 9F-PM-1014-04 09F PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9714057327159 40.7720375135272)   19 4 19 13
446 446 -73.9678774314725 40.7738535171265 12H-PM-1007-04 12H PM 10072018 4   Gray Cinnamon Gray+Cinnamon         false false false true false mushroom false false false false false false true false   POINT (-73.9678774314725 40.7738535171265)   19 4 19 13
486 486 -73.971213385696 40.769872094337 7H-AM-1006-04 07H AM 10062018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.97121338569602 40.769872094337)   19 4 19 13
499 499 -73.9657288055011 40.7764580036287 16H-PM-1014-04 16H PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9657288055011 40.7764580036287)   19 4 19 13
619 619 -73.9769887473852 40.7707561532949 5C-PM-1010-04 05C PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false   false false false false false false true false   POINT (-73.97698874738522 40.7707561532949)   19 4 19 13
681 681 -73.9552880892701 40.7889040503316 32I-AM-1013-04 32I AM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9552880892701 40.7889040503316)   19 4 19 13
823 823 -73.954595058342 40.7956567934304 39F-AM-1014-04 39F AM 10142018 4 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.954595058342 40.7956567934304)   19 4 19 13
851 851 -73.9528462779437 40.7923843043685 36I-AM-1017-04 36I AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9528462779437 40.7923843043685)   19 4 19 13
1089 1089 -73.9655955841325 40.7762063860571 15H-PM-1008-04 15H PM 10082018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE edge of landscape false false false false true   false false false false false false true false   POINT (-73.9655955841325 40.7762063860571)   19 4 19 13
1362 1362 -73.9629184712372 40.7921410511633 32B-PM-1010-04 32B PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9629184712372 40.7921410511633)   19 4 19 13
1368 1368 -73.9542770888881 40.7943610366853 38G-PM-1020-04 38G PM 10202018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false true false true false false true false   POINT (-73.9542770888881 40.79436103668531)   19 4 19 13
1391 1391 -73.9578658632957 40.7933712188923 35E-AM-1020-04 35E AM 10202018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   false false false false false hunkered down,tail over body; sitting perfectly still false false false false false false true false   POINT (-73.9578658632957 40.7933712188923)   19 4 19 13
1401 1401 -73.9681202146851 40.7743979416812 13G-PM-1008-04 13G PM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE lawn @ edge of landscaped area false false false false true   false false false false false false true false   POINT (-73.9681202146851 40.7743979416812)   19 4 19 13
1463 1463 -73.9630097276366 40.7936658446251 33A-PM-1018-04 33A PM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9630097276366 40.79366584462511)   19 4 19 13
2050 2050 -73.9555255950648 40.7977720808005 40D-AM-1013-04 40D AM 10132018 4 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 true false   POINT (-73.9555255950648 40.7977720808005)   19 4 19 13
2062 2062 -73.9618173092433 40.7925800181543 33B-PM-1010-04 33B PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9618173092433 40.7925800181543)   19 4 19 13
2264 2264 -73.9773520582734 40.7708198505781 5B-AM-1008-04 05B AM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false   false false false false false false true false   POINT (-73.9773520582734 40.7708198505781)   19 4 19 13
2425 2425 -73.9791141532217 40.7714888835416 5A-AM-1006-04 05A AM 10062018 4 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9791141532217 40.77148888354161)   19 4 19 13
2447 2447 -73.9589670987899 40.7952127039287 37C-AM-1012-04 37C AM 10122018 4 Adult Gray Cinnamon Gray+Cinnamon Cinnamon flanks Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9589670987899 40.7952127039287)   19 4 19 13
2664 2664 -73.9598350385541 40.7973274000224 38A-PM-1013-04 38A PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false false   false false false false false false true false   POINT (-73.9598350385541 40.7973274000224)   19 4 19 13
2798 2798 -73.9753825640019 40.7671662013861 3F-PM-1013-04 03F PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9753825640019 40.7671662013861)   19 4 19 13
2828 2828 -73.9587439756541 40.7849006107353 27I-AM-1007-04 27I AM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true true   POINT (-73.9587439756541 40.7849006107353)   19 4 19 13
2832 2832 -73.958607566971 40.7983695505584 40B-PM-1014-04 40B PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.958607566971 40.7983695505584)   19 4 19 13
2961 2961 -73.9736238258579 40.7688712771191 5F-PM-1007-04 05F PM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9736238258579 40.7688712771191)   19 4 19 13
2981 2981 -73.9800094828465 40.7677782585639 1B-AM-1012-04 01B AM 10122018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false   false false false false false false true false   POINT (-73.9800094828465 40.7677782585639)   19 4 19 13
2993 2993 -73.9570722262693 40.7985706143519 40C-AM-1017-04 40C AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false true true chasing (#3) false false false false false false true false   POINT (-73.9570722262693 40.7985706143519)   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 61.038ms