squirrels

67 rows where Date = 10192018 and Foraging = "true" sorted by Latitude

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, 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, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Police Precincts ✖

Foraging ✖

  • true · 67 ✖

Date ✖

  • 10192018 · 67 ✖
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
2287 2287 -73.9768173303165 40.7661261813557 1F-PM-1019-01 01F PM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9768173303165 40.7661261813557)   19 4 19 13
1184 1184 -73.9807982742225 40.7678795985389 1B-PM-1019-01 01B PM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9807982742225 40.7678795985389)   19 4 19 13
1175 1175 -73.9803282698463 40.7680809889384 1B-PM-1019-09 01B PM 10192018 9 Adult Gray White Gray+White   Ground Plane FALSE Tree to ground false false false false true   false false false true false false true false   POINT (-73.9803282698463 40.7680809889384)   19 4 19 13
2684 2684 -73.9809688694074 40.7688535974878 2A-PM-1019-06 02A PM 10192018 6 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9809688694074 40.7688535974878)   19 4 19 13
181 181 -73.9708775864433 40.772473633538 10F-PM-1019-12 10F PM 10192018 12 Adult Black White Black+White   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9708775864433 40.772473633538)   19 4 19 13
1026 1026 -73.9710951149579 40.772501245008 10F-PM-1019-04 10F PM 10192018 4 Adult Black   Black+   Ground Plane FALSE Behind fence, grass false false false false true   false false false false false false true false   POINT (-73.9710951149579 40.772501245008)   19 4 19 13
2662 2662 -73.9708628933624 40.7725630886784 10F-PM-1019-08 10F PM 10192018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Under "Grape Arbor" structure behind Bandshell true false false false true digging false false false false false false false true   POINT (-73.9708628933624 40.7725630886784)   19 4 19 13
2384 2384 -73.9708564226824 40.7726219968014 10F-PM-1019-09 10F PM 10192018 9 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Across Arbor path into hill w/ bushes true false false false true   false false false false false false false true   POINT (-73.9708564226824 40.7726219968014)   19 4 19 13
922 922 -73.9708002461415 40.7726685284831 10F-PM-1019-10 10F PM 10192018 10 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Arbor path & hill w/ bushes true false false true true   false false false false true false true false   POINT (-73.9708002461415 40.7726685284831)   19 4 19 13
332 332 -73.9705123624953 40.7731723757869 10F-PM-1019-11 10F PM 10192018 11 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Grassy area false false false false true   false false false false false false false true   POINT (-73.9705123624953 40.7731723757869)   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
2527 2527 -73.9675697600155 40.7766797414463 15G-PM-1019-06 15G PM 10192018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true scratching! false false false false false false false false   POINT (-73.9675697600155 40.7766797414463)   19 4 19 13
1642 1642 -73.9708860879459 40.7768376656119 14D-PM-1019-15 14D PM 10192018 15 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9708860879459 40.7768376656119)   19 4 19 13
2902 2902 -73.9673220504383 40.7770296345963 15G-PM-1019-04 15G PM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9673220504383 40.7770296345963)   19 4 19 13
2597 2597 -73.97063044051 40.7771060594808 14D-PM-1019-14 14D PM 10192018 14 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.97063044051 40.7771060594808)   19 4 19 13
2544 2544 -73.9713680837672 40.7771661508364 14D-PM-1019-03 14D PM 10192018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9713680837672 40.77716615083641)   19 4 19 13
2488 2488 -73.9726920847792 40.7794117463889 16A-PM-1019-02 16A PM 10192018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false false true scared by dog POINT (-73.9726920847792 40.7794117463889)   19 4 19 13
2924 2924 -73.9727230609785 40.7795341640894 16A-PM-1019-01 16A PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9727230609785 40.7795341640894)   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
482 482 -73.9721797824576 40.7801213843628 16A-PM-1019-07 16A PM 10192018 7 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false true true false false approaches (very friendly) POINT (-73.9721797824576 40.7801213843628)   19 4 19 13
2036 2036 -73.9610266708075 40.7817512107392 23I-PM-1019-03 23I PM 10192018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9610266708075 40.7817512107392)   19 4 19 13
2841 2841 -73.9693262952166 40.783260411082 21B-AM-1019-01 21B AM 10192018 1 Juvenile Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9693262952166 40.783260411082)   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
1445 1445 -73.9696196840065 40.7836431098335 21A-AM-1019-09 21A AM 10192018 9 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9696196840065 40.7836431098335)   19 4 19 13
827 827 -73.97002473509 40.7836929044459 21A-AM-1019-08 21A AM 10192018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.97002473509 40.7836929044459)   19 4 19 13
1907 1907 -73.9689227467959 40.7837541607494 21B-AM-1019-03 21B AM 10192018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9689227467959 40.7837541607494)   19 4 19 13
2567 2567 -73.9690241805398 40.7837967580773 21B-AM-1019-07 21B AM 10192018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9690241805398 40.7837967580773)   19 4 19 13
693 693 -73.969353372175 40.7838247422369 21A-AM-1019-06 21A AM 10192018 6 Juvenile Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.969353372175 40.7838247422369)   19 4 19 13
1583 1583 -73.9701030393506 40.7838953063625 21A-AM-1019-04 21A AM 10192018 4 Juvenile Gray Black Gray+Black   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9701030393506 40.7838953063625)   19 4 19 13
2375 2375 -73.9563720614251 40.7879453306251 31I-PM-1019-01 31I PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9563720614251 40.7879453306251)   19 4 19 13
638 638 -73.9562765288004 40.7880617963868 31I-PM-1019-02 31I PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9562765288004 40.7880617963868)   19 4 19 13
2283 2283 -73.9628982772673 40.7884304803386 28D-PM-1019-01 28D PM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9628982772673 40.7884304803386)   19 4 19 13
1833 1833 -73.962516494651 40.7884768989902 28D-PM-1019-02 28D PM 10192018 2 Adult Black   Black+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.962516494651 40.7884768989902)   19 4 19 13
1798 1798 -73.9558180952889 40.7886810505944 31I-PM-1019-03 31I PM 10192018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9558180952889 40.7886810505944)   19 4 19 13
1866 1866 -73.9636027664439 40.790075966587 30B-PM-1019-01 30B PM 10192018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false true true   false false false false true false false true   POINT (-73.9636027664439 40.790075966587)   19 4 19 13
1009 1009 -73.9636551433178 40.7901572818776 30B-PM-1019-02 30B PM 10192018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false true false true true   false false false false true false false true   POINT (-73.9636551433178 40.7901572818776)   19 4 19 13
2825 2825 -73.9643507588008 40.7904324693292 30B-PM-1019-07 30B PM 10192018 7 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.96435075880082 40.7904324693292)   19 4 19 13
1269 1269 -73.9652921233647 40.790440565854 29A-PM-1019-01 29A PM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9652921233647 40.790440565854)   19 4 19 13
1950 1950 -73.9643016116839 40.7904796216068 30B-PM-1019-05 30B PM 10192018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true hiding a nut false false false false true false false true   POINT (-73.9643016116839 40.7904796216068)   19 4 19 13
2834 2834 -73.9651132904127 40.7905384124102 29A-PM-1019-02 29A PM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9651132904127 40.7905384124102)   19 4 19 13
2079 2079 -73.9643025171914 40.790570391517 30B-PM-1019-06 30B PM 10192018 6 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false false true false true   false false false false false false false true   POINT (-73.9643025171914 40.790570391517)   19 4 19 13
964 964 -73.9631045499811 40.7906180969472 30B-PM-1019-04 30B PM 10192018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false true true true   false false false false false false false true   POINT (-73.9631045499811 40.7906180969472)   19 4 19 13
274 274 -73.9639832886071 40.7909532437095 30B-PM-1019-08 30B PM 10192018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false false true   POINT (-73.9639832886071 40.7909532437095)   19 4 19 13
2556 2556 -73.9639828431368 40.7910151996207 30B-PM-1019-09 30B PM 10192018 9 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9639828431368 40.7910151996207)   19 4 19 13
2608 2608 -73.9522677657659 40.7934034811368 38I-AM-1019-02 38I AM 10192018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9522677657659 40.7934034811368)   19 4 19 13
2802 2802 -73.9533101544112 40.7938634280159 38H-AM-1019-01 38H AM 10192018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9533101544112 40.7938634280159)   19 4 19 13
1286 1286 -73.9589096782789 40.7939698757903 35D-AM-1019-02 35D AM 10192018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Black tail & edge, Cinnamon mid, While tail edge Ground Plane FALSE   false false false false true very quietly searching in long grass false false false false false false false false   POINT (-73.9589096782789 40.7939698757903)   19 4 19 13
312 312 -73.958356112357 40.796014459571 38C-AM-1019-07 38C AM 10192018 7 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false false true   false false false false true false false true   POINT (-73.958356112357 40.796014459571)   19 4 19 13
273 273 -73.9579218587172 40.7960605028848 38C-AM-1019-04 38C AM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   true true false false false false true false   POINT (-73.9579218587172 40.79606050288481)   19 4 19 13
2657 2657 -73.9582150734453 40.7962862794303 38C-AM-1019-08 38C AM 10192018 8 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false false true   true false false false false false true false   POINT (-73.9582150734453 40.7962862794303)   19 4 19 13
1759 1759 -73.9576219570858 40.7963351225672 38C-AM-1019-03 38C AM 10192018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9576219570858 40.7963351225672)   19 4 19 13
1977 1977 -73.9586570546871 40.796349417475 38C-AM-1019-09 38C AM 10192018 9 Adult Gray White Gray+White Gray & White selected as Primary & Highlights. Made executive adjustments. Above Ground 3 Between ground & tree false false false true true   false false false false true false false true   POINT (-73.9586570546871 40.796349417475)   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
699 699 -73.9504693544225 40.797225436004 42H-AM-1019-01 42H AM 10192018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9504693544225 40.797225436004)   19 4 19 13
2736 2736 -73.9593895253501 40.7973085844087 38B-AM-1019-03 38B AM 10192018 3 Juvenile Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9593895253501 40.7973085844087)   19 4 19 13
200 200 -73.9510747586301 40.7973106833951 42H-AM-1019-02 42H AM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9510747586301 40.7973106833951)   19 4 19 13
1885 1885 -73.9594174605642 40.7973128653773 38B-AM-1019-02 38B AM 10192018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9594174605642 40.7973128653773)   19 4 19 13
2117 2117 -73.9597192455543 40.7973316178661 38A-AM-1019-03 38A AM 10192018 3 Adult Gray White Gray+White White belly Ground Plane FALSE   false false false false true stood on back legs false false false false false true true true   POINT (-73.9597192455543 40.7973316178661)   19 4 19 13
1591 1591 -73.9576223390082 40.7979746639647 40B-AM-1019-04 40B AM 10192018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true false true   false false false false false true true false   POINT (-73.9576223390082 40.79797466396471)   19 4 19 13
2885 2885 -73.9530811255728 40.7983069118579 42F-AM-1019-02 42F AM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9530811255728 40.79830691185791)   19 4 19 13
1540 1540 -73.957710975899 40.7984055614047 40B-AM-1019-06 40B AM 10192018 6 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.957710975899 40.7984055614047)   19 4 19 13
1801 1801 -73.9587072373474 40.7985209579925 40B-AM-1019-01 40B AM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9587072373474 40.7985209579925)   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
2168 2168 -73.9582363437135 40.7987752300505 40B-AM-1019-06 40B AM 10192018 6 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9582363437135 40.7987752300505)   19 4 19 13
1986 1986 -73.958247706428 40.7989079136796 40B-AM-1019-07 40B AM 10192018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true true   POINT (-73.958247706428 40.7989079136796)   19 4 19 13
1185 1185 -73.958230674366 40.7989268396525 40B-AM-1019-08 40B AM 10192018 8 Adult Gray White Gray+White   Ground Plane FALSE   false false true false true   false false false false false false true true   POINT (-73.958230674366 40.7989268396525)   19 4 19 13
846 846 -73.9582643954055 40.8000460061272 42A-AM-1019-01 42A AM 10192018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.95826439540551 40.8000460061272)   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 82.972ms