squirrels

53 rows where Date = 10122018 and Location = "Above Ground" sorted by Community Districts

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Color notes, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Foraging ✖

Location ✖

  • Above Ground · 53 ✖

Date ✖

  • 10122018 · 53 ✖
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
229 229 -73.972416242971 40.7714260236636 8F-PM-1012-04 08F PM 10122018 4 Adult Gray   Gray+   Above Ground 6   false false false false false   false false false false false false false false   POINT (-73.972416242971 40.7714260236636)   19 4 19 13
255 255 -73.9800669115792 40.7676825134384 1B-AM-1012-07 01B AM 10122018 7 Adult Cinnamon   Cinnamon+   Above Ground 2 on tree trunk false true true false false   false false false false false false true false   POINT (-73.9800669115792 40.7676825134384)   19 4 19 13
344 344 -73.9759432151552 40.7733240612552 8B-PM-1012-06 08B PM 10122018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 2 on a bench false false false true true   false false false false false false true false   POINT (-73.9759432151552 40.7733240612552)   19 4 19 13
401 401 -73.965862100991 40.7825926896917 22D-PM-1012-01 22D PM 10122018 1 Adult Gray Black, White Gray+Black, White   Above Ground 5   false false true false false   true false false false false false false false climbing tree POINT (-73.965862100991 40.7825926896917)   19 4 19 13
565 565 -73.9615402629655 40.7924082330328 33C-AM-1012-02 33C AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon Cinnamon along back & tail Above Ground 20 tree branches false true true false false   false false false false false false true false   POINT (-73.9615402629655 40.7924082330328)   19 4 19 13
657 657 -73.9679008849677 40.7759013923034 14G-AM-1012-02 14G AM 10122018 2   Gray Cinnamon Gray+Cinnamon   Above Ground 15   false false true false false   false false false false false false true false   POINT (-73.9679008849677 40.7759013923034)   19 4 19 13
667 667 -73.9624538733037 40.7883829851518 28D-AM-1012-04 28D AM 10122018 4 Adult Cinnamon White Cinnamon+White   Above Ground 10   false false true false false   false false false false false false false true   POINT (-73.9624538733037 40.7883829851518)   19 4 19 13
698 698 -73.9585537668382 40.7903905787005 32F-AM-1012-03 32F AM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false true false false bringing green leaves to nest false false false false false false false false   POINT (-73.9585537668382 40.7903905787005)   19 4 19 13
760 760 -73.9718234159557 40.7810842503715 18A-AM-1012-02 18A AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   false false true true true burying false false false true false false false true   POINT (-73.9718234159557 40.7810842503715)   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
776 776 -73.9686816795392 40.775770422667 14F-PM-1012-02 14F PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 3   false false true true false   false false false false false false true false   POINT (-73.9686816795392 40.775770422667)   19 4 19 13
788 788 -73.9687476703117 40.7742856696093 12G-AM-1012-01 12G AM 10122018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   false false true false false   false false false false false false true false   POINT (-73.9687476703117 40.7742856696093)   19 4 19 13
820 820 -73.9801902133148 40.769557595068 3A-AM-1012-03 03A AM 10122018 3 Juvenile Gray Black, Cinnamon Gray+Black, Cinnamon Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. Above Ground 1   false false true false false   false false false false true false false true   POINT (-73.9801902133148 40.769557595068)   19 4 19 13
889 889 -73.9681042612938 40.772331431865 11I-PM-1012-04 11I PM 10122018 4 Adult Gray   Gray+   Above Ground 2   true false true false true   false false false false false false false false   POINT (-73.9681042612938 40.772331431865)   19 4 19 13
951 951 -73.971791854883 40.7802971729784 17B-PM-1012-01 17B PM 10122018 1 Adult Gray   Gray+   Above Ground 2 climbed a fence true false false false true   false false false false false false false true   POINT (-73.971791854883 40.7802971729784)   19 4 19 13
1060 1060 -73.9728871061191 40.7712983658944 8F-PM-1012-08 08F PM 10122018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false false true false   false false false false false false false true   POINT (-73.9728871061191 40.7712983658944)   19 4 19 13
1118 1118 -73.9719460335398 40.7810508156287 18A-AM-1012-01 18A AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White White tail Above Ground 3 tree true false true false true   false false false false true false false true   POINT (-73.9719460335398 40.7810508156287)   19 4 19 13
1123 1123 -73.9670858934045 40.7753505024976 14H-PM-1012-02 14H PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   true false false true true   false false false false false false true false   POINT (-73.9670858934045 40.7753505024976)   19 4 19 13
1138 1138 -73.9594357049738 40.7840678890949 25I-AM-1012-01 25I AM 10122018 1 Adult Cinnamon   Cinnamon+   Above Ground 4 on bar false false false true false   false false false true true true false false   POINT (-73.9594357049738 40.7840678890949)   19 4 19 13
1165 1165 -73.9689504114652 40.7766770153764 14F-PM-1012-05 14F PM 10122018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 2 on a fallen branch true false false true false sitting false false false false false false false false looking at me POINT (-73.9689504114652 40.7766770153764)   19 4 19 13
1297 1297 -73.9802831706033 40.7692763295564 3A-AM-1012-02 03A AM 10122018 2 Adult Gray Black, Cinnamon Gray+Black, Cinnamon Gray & Cinnamon selected as Primary. Black & Cinnamon selected as Highlights. Made executive adjustments. Above Ground 1   true false false false false   false false false false true false false true   POINT (-73.9802831706033 40.7692763295564)   19 4 19 13
1317 1317 -73.9680522379372 40.772389813511 11I-PM-1012-06 11I PM 10122018 6 Adult Gray   Gray+   Above Ground 2   true false true false true   false false false false false false false false   POINT (-73.9680522379372 40.772389813511)   19 4 19 13
1487 1487 -73.965394655961 40.7763136791661 15I-PM-1012-05 15I PM 10122018 5 Adult Gray   Gray+   Above Ground 2   true false true false true burying the food on ground false false false false false false false false look at us and continue hiding the food POINT (-73.965394655961 40.7763136791661)   19 4 19 13
1516 1516 -73.9625383795297 40.7883862331728 28D-AM-1012-03 28D AM 10122018 3 Adult Black   Black+   Above Ground 30   true false false false false   false false false false false false true false   POINT (-73.9625383795297 40.7883862331728)   19 4 19 13
1568 1568 -73.9681079869821 40.7723494081345 11I-PM-1012-05 11I PM 10122018 5 Adult Gray   Gray+   Above Ground 2   true false true false true   false false false false false false false false   POINT (-73.9681079869821 40.7723494081345)   19 4 19 13
1576 1576 -73.9619985187616 40.7943277743532 34A-AM-1012-02 34A AM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10 chasing from tree to ground true true true false false   false false false false false false true false   POINT (-73.9619985187616 40.7943277743532)   19 4 19 13
1625 1625 -73.9736873018042 40.7649106677138 1I-PM-1012-02 01I PM 10122018 2 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. Above Ground 1 tree false false true false false   true false false false false false false true   POINT (-73.9736873018042 40.7649106677138)   19 4 19 13
1641 1641 -73.9653135277149 40.7817434070169 21E-PM-1012-01 21E PM 10122018 1 Adult Gray   Gray+   Above Ground 20 in tree false false true false false   false false false false false false false false   POINT (-73.9653135277149 40.7817434070169)   19 4 19 13
1697 1697 -73.9568610943394 40.7935959584643 36E-PM-1012-02 36E PM 10122018 2 Adult Gray   Gray+   Above Ground 28 on tree branch false false true false true picking acorns off oak tree false false false false false false true false   POINT (-73.95686109433942 40.7935959584643)   19 4 19 13
1841 1841 -73.9806377967573 40.7681097168268 1B-AM-1012-15 01B AM 10122018 15 Adult Gray   Gray+   Above Ground 5   false false true true false   false false false false false false true false   POINT (-73.9806377967573 40.7681097168268)   19 4 19 13
1845 1845 -73.9626560807032 40.7884633049896 28D-AM-1012-05 28D AM 10122018 5 Juvenile Black   Black+   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9626560807032 40.7884633049896)   19 4 19 13
1850 1850 -73.975809362521 40.7734702737835 8B-PM-1012-09 08B PM 10122018 9 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   tree true false true false false   false false false false false false false true   POINT (-73.975809362521 40.7734702737835)   19 4 19 13
1871 1871 -73.9748367344424 40.7693513000034 5E-PM-1012-06 05E PM 10122018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 10 oak tree at end of ramp from Chess House true false false false false   false false false false false false false true   POINT (-73.9748367344424 40.7693513000034)   19 4 19 13
2002 2002 -73.9581706950566 40.7906321397269 32F-AM-1012-05 32F AM 10122018 5 Adult Gray White Gray+White   Above Ground 10   true false true false false   false false false false false false false false   POINT (-73.9581706950566 40.7906321397269)   19 4 19 13
2069 2069 -73.9538377039825 40.7980605334961 42E-PM-1012-03 42E PM 10122018 3 Adult Gray White Gray+White   Above Ground 20 in tree false false true false true   true false false false false false true false   POINT (-73.9538377039825 40.7980605334961)   19 4 19 13
2090 2090 -73.9569759970802 40.7931497452294 35F-PM-1012-03 35F PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 7   false false true true true   false false false false false false false true   POINT (-73.9569759970802 40.79314974522941)   19 4 19 13
2205 2205 -73.9594986107981 40.7840083040604 25I-AM-1012-03 25I AM 10122018 3 Adult Cinnamon   Cinnamon+   Above Ground 8 on turn, see map true true false true false   false false false false true true false false   POINT (-73.9594986107981 40.7840083040604)   19 4 19 13
2213 2213 -73.9707487237344 40.7800822831001 17B-PM-1012-03 17B PM 10122018 3 Adult Gray White Gray+White   Above Ground 10   true true false false false 2/3 chasing each other false false false false true false true false   POINT (-73.9707487237344 40.7800822831001)   19 4 19 13
2231 2231 -73.9545427611477 40.7930353817441 36G-PM-1012-02 36G PM 10122018 2 Adult Gray White Gray+White   Above Ground 10   false false false true false   false false false false false false false false   POINT (-73.9545427611477 40.7930353817441)   19 4 19 13
2232 2232 -73.9566277721581 40.7966674587803 39D-PM-1012-04 39D PM 10122018 4 Juvenile Gray White Gray+White   Above Ground 10 on tree trunk (descending from height of ~10 ft) false false true false false   false false false false false false true false   POINT (-73.95662777215811 40.7966674587803)   19 4 19 13
2323 2323 -73.9715921982161 40.7746153066601 11E-PM-1012-06 11E PM 10122018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Above Ground 5   false false true true false   false false false false false false true false   POINT (-73.9715921982161 40.7746153066601)   19 4 19 13
2372 2372 -73.9724879969884 40.771098202397 8F-PM-1012-07 08F PM 10122018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 17   false false true false false gathering false false false false false false false false   POINT (-73.9724879969884 40.771098202397)   19 4 19 13
2389 2389 -73.9801343393329 40.7691512453402 3A-AM-1012-01 03A AM 10122018 1 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 1   false false false true false   false false false false true false false true   POINT (-73.9801343393329 40.7691512453402)   19 4 19 13
2390 2390 -73.9680741975294 40.7847036778165 23B-PM-1012-04 23B PM 10122018 4 Adult Gray White Gray+White   Above Ground 20   false false false false false watching me - didn't move false false false false true false false true   POINT (-73.9680741975294 40.7847036778165)   19 4 19 13
2487 2487 -73.9595222999173 40.7833202577782 25I-AM-1012-02 25I AM 10122018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 31 on tree true true false false false   false false false true true false true false   POINT (-73.9595222999173 40.7833202577782)   19 4 19 13
2652 2652 -73.9620542514749 40.7943731722138 34A-AM-1012-01 34A AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 chasing from tree to ground true true true false false   false false false false false false true false   POINT (-73.9620542514749 40.7943731722138)   19 4 19 13
2742 2742 -73.9628041577934 40.7884180156055 28D-AM-1012-06 28D AM 10122018 6 Juvenile Cinnamon White Cinnamon+White   Above Ground 5   false false false true false   false false false false false false false true   POINT (-73.9628041577934 40.78841801560551)   19 4 19 13
2745 2745 -73.97296259363 40.7652601851275 1I-PM-1012-04 01I PM 10122018 4 Juvenile Cinnamon White Cinnamon+White Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 2 on ledge false false true false false   false false false false true false false true   POINT (-73.97296259363 40.7652601851275)   19 4 19 13
2818 2818 -73.9681664642028 40.7724669681958 11I-PM-1012-02 11I PM 10122018 2 Adult Gray   Gray+   Above Ground 4   true false true false true   false false false false false false false true runs away from the ball POINT (-73.9681664642028 40.7724669681958)   19 4 19 13
2872 2872 -73.9615396457996 40.7923594366783 33C-AM-1012-01 33C AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon along tail & back Above Ground 20 tree branches false true true false false   false false false false false false true false   POINT (-73.9615396457996 40.7923594366783)   19 4 19 13
2903 2903 -73.9670432105975 40.7753462013506 14H-PM-1012-03 14H PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   true false false true true   false false false false false false true false   POINT (-73.9670432105975 40.7753462013506)   19 4 19 13
2988 2988 -73.9766342759486 40.7687518380873 4D-AM-1012-04 04D AM 10122018 4 Adult Gray   Gray+   Above Ground 3 on tree trunk false true true false false   false false false false true false true false   POINT (-73.9766342759486 40.7687518380873)   19 4 19 13
3011 3011 -73.9678831312936 40.7847605974975 23B-PM-1012-06 23B PM 10122018 6 Adult Gray   Gray+   Above Ground 30   false false false false false   true false false false false false false false scolding POINT (-73.9678831312936 40.7847605974975)   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 78.03ms