squirrels

34 rows where Date = 10082018, Running = "true" and Shift = "AM"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, 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, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, 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
63 63 -73.9745630038492 40.7692602628745 5E-AM-1008-06 05E AM 10082018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false true false false   POINT (-73.9745630038492 40.7692602628745)   19 4 19 13
84 84 -73.9701824825872 40.7766530579293 14E-AM-1008-09 14E AM 10082018 9 Adult Gray   Gray+   Ground Plane FALSE   true true false false false   true false false false false false false true   POINT (-73.9701824825872 40.7766530579293)   19 4 19 13
95 95 -73.9692883970928 40.7768553703082 14E-AM-1008-02 14E AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false false true walking false false false false false false false true   POINT (-73.9692883970928 40.7768553703082)   19 4 19 13
152 152 -73.9755133710665 40.7697883435981 5E-AM-1008-08 05E AM 10082018 8 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9755133710665 40.7697883435981)   19 4 19 13
250 250 -73.9726747666002 40.7703022669308 7F-AM-1008-02 07F AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true see stories and locations POINT (-73.9726747666002 40.7703022669308)   19 4 19 13
377 377 -73.9757001944781 40.769499790547 5E-AM-1008-09 05E AM 10082018 9 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2 went up tree true false false false false   false false false false false false true false   POINT (-73.9757001944781 40.769499790547)   19 4 19 13
464 464 -73.9664450399121 40.7887844904695 27A-AM-1008-02 27A AM 10082018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9664450399121 40.7887844904695)   19 4 19 13
716 716 -73.9745427984089 40.7691848214817 5E-AM-1008-03 05E AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9745427984089 40.7691848214817)   19 4 19 13
969 969 -73.9773529368499 40.7728750685699 7B-AM-1008-12 07B AM 10082018 12 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9773529368499 40.7728750685699)   19 4 19 13
1040 1040 -73.9702588981432 40.776610754288 14E-AM-1008-08 14E AM 10082018 8 Adult Gray   Gray+   Ground Plane FALSE   true true false false true   false false false false false false false true   POINT (-73.9702588981432 40.776610754288)   19 4 19 13
1065 1065 -73.9769700777377 40.7728489574967 7B-AM-1008-08 07B AM 10082018 8 Adult Gray   Gray+   Above Ground 5   true false false false false   false false false false false false true false   POINT (-73.9769700777377 40.7728489574967)   19 4 19 13
1079 1079 -73.9722737593623 40.768963018754 6G-AM-1008-04 06G AM 10082018 4 Juvenile Gray Cinnamon Gray+Cinnamon very long tail Above Ground 20 tree true false true false false   false false false false true false false true   POINT (-73.9722737593623 40.768963018754)   19 4 19 13
1094 1094 -73.9773898301093 40.7708581562057 5B-AM-1008-01 05B AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true running across ball field 5,near home plate false false false false false false true false   POINT (-73.9773898301093 40.7708581562057)   19 4 19 13
1266 1266 -73.9709897849823 40.768627964006 6H-AM-1008-02 06H AM 10082018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9709897849823 40.768627964006)   19 4 19 13
1278 1278 -73.9729848996456 40.7707143294261 7F-AM-1008-11 07F AM 10082018 11 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9729848996456 40.7707143294261)   19 4 19 13
1376 1376 -73.9773361580792 40.7729478226715 7B-AM-1008-13 07B AM 10082018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9773361580792 40.7729478226715)   19 4 19 13
1470 1470 -73.9724806580638 40.7710077206132 7F-AM-1008-15 07F AM 10082018 15 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9724806580638 40.7710077206132)   19 4 19 13
1602 1602 -73.9728836727349 40.770815850599 7F-AM-1008-10 07F AM 10082018 10 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9728836727349 40.770815850599)   19 4 19 13
1661 1661 -73.974519308015 40.7691228794395 5E-AM-1008-02 05E AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8 trellis true false false false true   false false false false false true false false   POINT (-73.974519308015 40.7691228794395)   19 4 19 13
1715 1715 -73.9745709109056 40.7672225695415 3G-AM-1008-03 03G AM 10082018 3 Adult Gray   Gray+   Above Ground 40   true false true false false in tree false false false false false false true false   POINT (-73.9745709109056 40.7672225695415)   19 4 19 13
1905 1905 -73.9691968748482 40.7765862996192 14E-AM-1008-14 14E AM 10082018 14 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9691968748482 40.7765862996192)   19 4 19 13
1990 1990 -73.9774584305147 40.7708133986192 5B-AM-1008-02 05B AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false   false false false false false false true false   POINT (-73.9774584305147 40.7708133986192)   19 4 19 13
2058 2058 -73.9669017345324 40.7766928987073 15G-AM-1008-01 15G AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9669017345324 40.7766928987073)   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
2177 2177 -73.9758211560957 40.7693422860766 5E-AM-1008-10 05E AM 10082018 10 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6 up a tree true false false false true   false false false false false false true false   POINT (-73.9758211560957 40.7693422860766)   19 4 19 13
2268 2268 -73.9590191655172 40.7926139425111 34D-AM-1008-03 34D AM 10082018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9590191655172 40.7926139425111)   19 4 19 13
2271 2271 -73.9673949458096 40.7826218539496 21D-AM-1008-04 21D AM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9673949458096 40.78262185394961)   19 4 19 13
2318 2318 -73.967458693983 40.7769922522105 15G-AM-1008-02 15G AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.967458693983 40.7769922522105)   19 4 19 13
2619 2619 -73.9739737592602 40.7727130476777 9D-AM-1008-04 09D AM 10082018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9739737592602 40.7727130476777)   19 4 19 13
2630 2630 -73.965019827314 40.7759864291323 15I-AM-1008-03 15I AM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.965019827314 40.7759864291323)   19 4 19 13
2648 2648 -73.9729410488021 40.7709484964577 7F-AM-1008-13 07F AM 10082018 13 Adult Gray   Gray+   Above Ground 4 to tree true false false true true ran up tree 4 feet and ate leaves false false false false false false true false   POINT (-73.9729410488021 40.7709484964577)   19 4 19 13
2713 2713 -73.9687214684206 40.7792841720164 17D-AM-1008-07 17D AM 10082018 7 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9687214684206 40.7792841720164)   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
2886 2886 -73.9729265300533 40.7741768291642 10D-AM-1008-02 10D AM 10082018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9729265300533 40.7741768291642)   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 72.986ms