squirrels

158 rows where Date = 10192018 sorted by Eating

✎ View and edit SQL

This data as json, CSV (advanced)

Highlight Fur Color ✖

Foraging ✖

Date ✖

  • 10192018 · 58 ✖

City Council Districts ✖

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
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
2588 2588 -73.9581007437094 40.7959403112722 38C-AM-1019-06 38C AM 10192018 6 Adult Gray   Gray+   Above Ground 23   false false true false false   true false false true false false true false   POINT (-73.9581007437094 40.7959403112722)   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
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
2629 2629 -73.9604576237503 40.7818120101394 23I-PM-1019-01 23I PM 10192018 1 Adult Gray   Gray+   Above Ground 35   true false false false false running (across branches) false false false false false false false false   POINT (-73.9604576237503 40.7818120101394)   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
2660 2660 -73.9726056411971 40.7793467904743 16A-PM-1019-03 16A PM 10192018 3   Gray   Gray+   Above Ground 15   false false true false false   false false false false false false false false   POINT (-73.9726056411971 40.7793467904743)   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
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
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
2688 2688 -73.9799302952205 40.7677207209798 1B-PM-1019-02 01B PM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9799302952205 40.7677207209798)   19 4 19 13
2715 2715 -73.9710273070712 40.7766521246153 14D-PM-1019-16 14D PM 10192018 16 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9710273070712 40.7766521246153)   19 4 19 13
2777 2777 -73.9810843611086 40.7687905493699 2A-PM-1019-05 02A PM 10192018 5 ? Gray   Gray+   Above Ground 50 in tall planetree true false false false false   false false false false false false false false   POINT (-73.9810843611086 40.7687905493699)   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
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
2865 2865 -73.9802842404016 40.7678257384977 1B-PM-1019-03 01B PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 25 in tree false true false false false   false false false false false false false false   POINT (-73.98028424040162 40.7678257384977)   19 4 19 13
2877 2877 -73.9730027200009 40.7798000868804 16A-PM-1019-05 16A PM 10192018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false true false false   false false false false false false false false   POINT (-73.9730027200009 40.7798000868804)   19 4 19 13
2882 2882 -73.956581233786 40.7902127690837 33H-AM-1019-01 33H AM 10192018 1 Adult Cinnamon Gray Cinnamon+Gray Cinnamon patches Ground Plane FALSE   false false false false false wrestling with child false false false false false false false false   POINT (-73.956581233786 40.79021276908371)   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
2904 2904 -73.9720389756717 40.7763524091989 13C-PM-1019-02 13C PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.9720389756717 40.7763524091989)   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
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
2987 2987 -73.9563724838337 40.7882504581015 31I-PM-1019-04 31I PM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.95637248383372 40.7882504581015)   19 4 19 13
187 187 -73.9700162034073 40.7815277479588 19B-AM-1019-02 19B AM 10192018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false true false posing false false false false false false true true indifferent then runs from POINT (-73.9700162034073 40.7815277479588)   19 4 19 13
218 218 -73.9712318712643 40.7773053099657 14D-PM-1019-04 14D PM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9712318712643 40.7773053099657)   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
495 495 -73.9801007327506 40.7677455633932 1B-PM-1019-06 01B PM 10192018 6 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9801007327506 40.7677455633932)   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
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
804 804 -73.9697196619878 40.7814068507607 19B-AM-1019-01 19B AM 10192018 1 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Side stripes Ground Plane FALSE   true false false true false   false false false false false false true true indifferent then runs from POINT (-73.9697196619878 40.7814068507607)   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
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
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
980 980 -73.9709817796369 40.7773554311586 14D-PM-1019-07 14D PM 10192018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9709817796369 40.7773554311586)   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
1316 1316 -73.9674724790652 40.7768771349868 15G-PM-1019-01 15G PM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9674724790652 40.7768771349868)   19 4 19 13
1381 1381 -73.9586077039567 40.7961896477077 38C-AM-1019-10 38C AM 10192018 10 Adult Gray White Gray+White   Above Ground 20   true false true true false   true false false false true false false true   POINT (-73.9586077039567 40.7961896477077)   19 4 19 13
1383 1383 -73.9676732725672 40.7763194425467 15G-PM-1019-09 15G PM 10192018 9 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9676732725672 40.7763194425467)   19 4 19 13
1410 1410 -73.9587913289229 40.7961707624534 38C-AM-1019-11 38C AM 10192018 11 Adult Gray White Gray+White   Above Ground 20   true false true true false   true false false false true false false true   POINT (-73.9587913289229 40.7961707624534)   19 4 19 13
1423 1423 -73.9600204328201 40.782877291358 24I-AM-1019-01 24I AM 10192018 1 Adult Gray White Gray+White   Above Ground 10   false false false true false   false false false false false false false false   POINT (-73.9600204328201 40.782877291358)   19 4 19 13
1465 1465 -73.9720289863666 40.7763749561607 13C-PM-1019-03 13C PM 10192018 3 Adult Gray White Gray+White   Ground Plane FALSE   true false false true false   false false false false false false false true   POINT (-73.97202898636661 40.7763749561607)   19 4 19 13
1582 1582 -73.9804065254162 40.7681481183296 1B-PM-1019-08 01B PM 10192018 8 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9804065254162 40.7681481183296)   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
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
1943 1943 -73.9690447463294 40.783913304529 21B-AM-1019-06 21B AM 10192018 6 Juvenile Gray   Gray+   Above Ground 7   false false true true false   false false false false false false true false   POINT (-73.9690447463294 40.78391330452901)   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
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
2203 2203 -73.9710531485298 40.7773757069445 14D-PM-1019-06 14D PM 10192018 6 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false true false false true false   POINT (-73.97105314852982 40.777375706944504)   19 4 19 13
2215 2215 -73.9674978826751 40.776288410765 15G-PM-1019-10 15G PM 10192018 10 Adult Gray   Gray+   Above Ground 1 on a log false false false true false   false false false false false false false true   POINT (-73.9674978826751 40.776288410765)   19 4 19 13
2254 2254 -73.9709991016317 40.7725756707748 10F-PM-1019-03 10F PM 10192018 3 Juvenile Gray Cinnamon Gray+Cinnamon Cinnamon head Ground Plane FALSE Behind fence, grass false false false true false eating (nuts) false false false false false true false false approaches (bad tourists w/ nuts) POINT (-73.9709991016317 40.772575670774806)   19 4 19 13
2380 2380 -73.9761375729505 40.7662231892125 1F-PM-1019-02 01F PM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   false false true true false   false false false false false true false false   POINT (-73.9761375729505 40.7662231892125)   19 4 19 13
2482 2482 -73.9805927710872 40.7679989116642 1B-PM-1019-07 01B PM 10192018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9805927710872 40.7679989116642)   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
2800 2800 -73.9802983138318 40.7676540772339 1B-PM-1019-05 01B PM 10192018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9802983138318 40.7676540772339)   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
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
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
3017 3017 -73.9662895079734 40.7843300758044 23C-AM-1019-01 23C AM 10192018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray, Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 7   false false true true false eating (on branch) true false false false false false true false   POINT (-73.9662895079734 40.7843300758044)   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 8.675ms