squirrels

52 rows where Foraging = "true", Hectare Squirrel Number = 5 and Shift = "AM"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date, 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, Other Activities, 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
11 11 -73.9702676472613 40.7762126854894 13E-AM-1017-05 13E AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   on tree stump false false false false true   false false false false false false false false   POINT (-73.9702676472613 40.7762126854894)   19 4 19 13
50 50 -73.9680635070949 40.779249873647 17E-AM-1017-05 17E AM 10172018 5 Adult Black   Black+   Above Ground 10 Branch false false false false true   false false false false false false true false   POINT (-73.9680635070949 40.779249873647)   19 4 19 13
90 90 -73.9787180870736 40.7715877863274 5A-AM-1006-05 05A AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE near 65th St arch false false false false true   false false false true false false false true   POINT (-73.9787180870736 40.7715877863274)   19 4 19 13
104 104 -73.9764036522984 40.7705846185121 5C-AM-1006-05 05C AM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9764036522984 40.7705846185121)   19 4 19 13
131 131 -73.9755560786227 40.7662992317575 2F-AM-1006-05 02F AM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false false false curious but shy POINT (-73.9755560786227 40.7662992317575)   19 4 19 13
203 203 -73.9638774579549 40.7913532129148 31A-AM-1010-05 31A AM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true true jumping false false false true true false true false eventually ran from lawnmower (tail flag) POINT (-73.9638774579549 40.7913532129148)   19 4 19 13
231 231 -73.9527808174534 40.7924167234441 36I-AM-1017-05 36I AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false true runs from (me) POINT (-73.9527808174534 40.7924167234441)   19 4 19 13
261 261 -73.9552861155228 40.788973931872 32I-AM-1013-05 32I AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3 In and below shrub false false true false true   false false false true false false true false   POINT (-73.9552861155228 40.788973931872)   19 4 19 13
313 313 -73.9646610347972 40.7790583544252 19H-AM-1010-05 19H AM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE near a brush false false false true true   false false false false false false false true   POINT (-73.9646610347972 40.7790583544252)   19 4 19 13
370 370 -73.9548957862084 40.7944844464619 37G-AM-1014-05 37G AM 10142018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9548957862084 40.7944844464619)   19 4 19 13
397 397 -73.9690416961886 40.7716618670996 10H-AM-1014-05 10H AM 10142018 5   Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9690416961886 40.7716618670996)   19 4 19 13
439 439 -73.9589770206691 40.791240542172 33E-AM-1014-05 33E AM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9589770206691 40.791240542172)   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
538 538 -73.9553113771098 40.7978431980204 41D-AM-1014-05 41D AM 10142018 5 Adult Gray Black Gray+Black   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9553113771098 40.7978431980204)   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
921 921 -73.9698959071826 40.7716763799299 9H-AM-1006-05 09H AM 10062018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9698959071826 40.7716763799299)   19 4 19 13
975 975 -73.956869086031 40.7988858771114 41C-AM-1017-05 41C AM 10172018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.956869086031 40.7988858771114)   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
1043 1043 -73.9758564394842 40.7674758942811 3E-AM-1006-05 03E AM 10062018 5 Juvenile Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9758564394842 40.7674758942811)   19 4 19 13
1196 1196 -73.9580111496275 40.7985365971474 40B-AM-1019-05 40B AM 10192018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false true true true false   POINT (-73.9580111496275 40.7985365971474)   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
1347 1347 -73.9616693665254 40.792971019627 33B-AM-1010-05 33B AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9616693665254 40.792971019627)   19 4 19 13
1382 1382 -73.9611274898661 40.7915250069086 32C-AM-1014-05 32C AM 10142018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9611274898661 40.7915250069086)   19 4 19 13
1394 1394 -73.95488263914 40.7959474571251 39F-AM-1014-05 39F AM 10142018 5 Juvenile Cinnamon   Cinnamon+   Above Ground 2 up/down tree true false true false true   false false false false true false true false   POINT (-73.95488263914 40.7959474571251)   19 4 19 13
1483 1483 -73.9545773579075 40.7898684635744 33I-AM-1008-05 33I AM 10082018 5 Adult     +   Above Ground 100   false false true false true   false false false false false false true false nearly dropped shell on my head! POINT (-73.9545773579075 40.7898684635744)   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
1784 1784 -73.9748318777506 40.7771821378056 13A-AM-1017-05 13A AM 10172018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9748318777506 40.7771821378056)   19 4 19 13
1800 1800 -73.970962498391 40.7766899040856 14D-AM-1014-05 14D AM 10142018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.970962498391 40.7766899040856)   19 4 19 13
1849 1849 -73.9788436368415 40.7691104998969 3B-AM-1010-05 03B AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9788436368415 40.7691104998969)   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
1944 1944 -73.9743292066413 40.7756090404121 11B-AM-1007-05 11B AM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false true false true false false   POINT (-73.9743292066413 40.7756090404121)   19 4 19 13
2061 2061 -73.9608834102446 40.790624710005 31D-AM-1014-05 31D AM 10142018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9608834102446 40.790624710005)   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
2135 2135 -73.9596251284566 40.7916254797561 33D-AM-1017-05 33D AM 10172018 5 Adult Black   Black+   Above Ground 5   false false true false true   false false false false true false true false   POINT (-73.9596251284566 40.7916254797561)   19 4 19 13
2196 2196 -73.9623356369432 40.7888693815168 29D-AM-1014-05 29D AM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Rocky area false false false false true   false false false false false true false false   POINT (-73.9623356369432 40.7888693815168)   19 4 19 13
2202 2202 -73.9556039997621 40.7977549157287 40D-AM-1013-05 40D AM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9556039997621 40.7977549157287)   19 4 19 13
2464 2464 -73.9691318044969 40.7709801974696 9I-AM-1014-05 09I AM 10142018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9691318044969 40.7709801974696)   19 4 19 13
2486 2486 -73.9766317094163 40.7734230472026 8B-AM-1007-05 08B AM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9766317094163 40.7734230472026)   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
2651 2651 -73.9632993246327 40.7888199519656 29C-AM-1007-05 29C AM 10072018 5 Adult Black Gray Black+Gray   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9632993246327 40.7888199519656)   19 4 19 13
2685 2685 -73.9601851468038 40.7968698151479 38A-AM-1019-05 38A AM 10192018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon head, White belly Ground Plane FALSE   false false false false true standing on back legs false false false false false true true false   POINT (-73.9601851468038 40.7968698151479)   19 4 19 13
2701 2701 -73.9791217510656 40.7676583475394 2C-AM-1010-05 02C AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE right at the base of the same tree as #3 false false false true true   false false false false false false false false   POINT (-73.9791217510656 40.7676583475394)   19 4 19 13
2805 2805 -73.9711634340673 40.7760553338671 13D-AM-1014-05 13D AM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   false true false true true   false false false false false false true false   POINT (-73.9711634340673 40.7760553338671)   19 4 19 13
2816 2816 -73.9809342290598 40.7687265606227 2A-AM-1010-05 02A AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE base of tree with ~ 30 small birds all eating false false false true true   false false false false true true true false   POINT (-73.9809342290598 40.7687265606227)   19 4 19 13
2824 2824 -73.9750618008099 40.7737521167094 9B-AM-1010-05 09B AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9750618008099 40.7737521167094)   19 4 19 13
2854 2854 -73.9772908667333 40.7697207404744 4C-AM-1006-05 04C AM 10062018 5 Juvenile Gray White Gray+White   Above Ground 20   false false true true true   false false false false false false true false   POINT (-73.9772908667333 40.7697207404744)   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
2907 2907 -73.9685201626934 40.783329261225 21B-AM-1019-05 21B AM 10192018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9685201626934 40.783329261225)   19 4 19 13
2944 2944 -73.9739403850622 40.7693162287509 5F-AM-1007-05 05F AM 10072018 5 Adult Gray White Gray+White   Above Ground 2 tree true false false false true   false false false false false false false false   POINT (-73.9739403850622 40.7693162287509)   19 4 19 13
2962 2962 -73.9722530826293 40.7667138028361 3I-AM-1010-05 03I AM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9722530826293 40.7667138028361)   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 77.981ms