squirrels

158 rows where Date = 10192018 sorted by Longitude

✎ View and edit SQL

This data as json, CSV (advanced)

Police Precincts ✖

Date ✖

  • 10192018 · 58 ✖
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
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
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
363 363 -73.9707197274481 40.7773956803431 14D-PM-1019-12 14D PM 10192018 12 Adult Gray   Gray+         false false false false false   false false false false false false false false   POINT (-73.9707197274481 40.7773956803431)   19 4 19 13
390 390 -73.970720187655 40.7774564799983 14D-PM-1019-11 14D PM 10192018 11 Adult Gray   Gray+         false false false false false   false false false false false false false false   POINT (-73.970720187655 40.7774564799983)   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
1893 1893 -73.9708108312271 40.7773975776146 14D-PM-1019-09 14D PM 10192018 9 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9708108312271 40.7773975776146)   19 4 19 13
2237 2237 -73.9708225719705 40.7772497804149 14D-PM-1019-13 14D PM 10192018 13 Adult Gray   Gray+         false false false false false   false false false false false false false false   POINT (-73.9708225719705 40.7772497804149)   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
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
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
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
2198 2198 -73.9709738166531 40.7774102689734 14D-PM-1019-08 14D PM 10192018 8 Adult Gray   Gray+   Ground Plane FALSE   false false true false false   false false false false false false false false   POINT (-73.9709738166531 40.7774102689734)   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
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
2517 2517 -73.9710221361528 40.7724939691584 10F-PM-1019-01 10F PM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon head & stripe Above Ground 2 Behind fence, tree trunk false false true false false sitting false false false false false false true false   POINT (-73.9710221361528 40.7724939691584)   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
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
99 99 -73.9710541405708 40.7724691605718 10F-PM-1019-05 10F PM 10192018 5 Adult Black   Black+   Above Ground 10 Behind fence, tree false false true false false   false false false false false false true false   POINT (-73.9710541405708 40.7724691605718)   19 4 19 13
1897 1897 -73.97107389601 40.7723265810536 10F-PM-1019-07 10F PM 10192018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 Same tree (as #6) false false true false false   false false false false false false true false   POINT (-73.97107389601 40.7723265810536)   19 4 19 13
209 209 -73.9710760196868 40.7725506006789 10F-PM-1019-02 10F PM 10192018 2 Juvenile Gray Cinnamon Gray+Cinnamon Cinnamon head & stripe Ground Plane FALSE Behind fence, grass true false false false false   false false false false true false false true   POINT (-73.9710760196868 40.7725506006789)   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
737 737 -73.9711176999471 40.7724278547281 10F-PM-1019-06 10F PM 10192018 6 Adult Gray White Gray+White   Above Ground 10 Different tree false false true false false   false false false false false false true false   POINT (-73.9711176999471 40.7724278547281)   19 4 19 13
2053 2053 -73.9711810222421 40.7773445611969 14D-PM-1019-05 14D PM 10192018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9711810222421 40.7773445611969)   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
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
2509 2509 -73.9714295102249 40.776954371947 14D-PM-1019-02 14D PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9714295102249 40.776954371947)   19 4 19 13
1997 1997 -73.9714637683084 40.7768984561563 14D-PM-1019-01 14D PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9714637683084 40.7768984561563)   19 4 19 13
932 932 -73.9718597156773 40.7765858763313 13C-PM-1019-04 13C PM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9718597156773 40.7765858763313)   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
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
286 286 -73.9720907384613 40.7762987836055 13C-PM-1019-01 13C PM 10192018 1 Adult Gray   Gray+   Above Ground 7   false false true false false   true false false false false false true false   POINT (-73.9720907384613 40.7762987836055)   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
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
1524 1524 -73.9725961508316 40.7795720444974 16A-PM-1019-06 16A PM 10192018 6 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9725961508316 40.7795720444974)   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
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
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
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
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
1254 1254 -73.9764013589865 40.7663063499207 1F-PM-1019-03 01F PM 10192018 3 Juvenile Gray   Gray+   Above Ground 1   false false false false false hiding false false false false false false false false   POINT (-73.9764013589865 40.7663063499207)   19 4 19 13
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
2153 2153 -73.9797122322834 40.7678347587435 1B-PM-1019-10 01B PM 10192018 10 Adult Cinnamon White Cinnamon+White   Above Ground   Dog chased up tree false false true false false   false false false false true false false false   POINT (-73.97971223228342 40.7678347587435)   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
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
1411 1411 -73.9802840031759 40.7678599069819 1B-PM-1019-04 01B PM 10192018 4 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.9802840031759 40.7678599069819)   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
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
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
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
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
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
855 855 -73.9808247660048 40.7689408831287 2A-PM-1019-01 02A PM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false runs from false false false true false false false true   POINT (-73.9808247660048 40.7689408831287)   19 4 19 13
1956 1956 -73.980897497712 40.7690578709841 2A-PM-1019-02 02A PM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false true false false false false   POINT (-73.980897497712 40.7690578709841)   19 4 19 13
2412 2412 -73.9809446489564 40.7685032165879 2A-PM-1019-03 02A PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 15 in tree! true false false false false   false false false false false false true false   POINT (-73.9809446489564 40.7685032165879)   19 4 19 13
999 999 -73.980948293606 40.7685688850628 2A-PM-1019-04 02A PM 10192018 4 Juvenile Gray White Gray+White   Above Ground 15 in tree! true false false false false   false false false false false false true false   POINT (-73.980948293606 40.7685688850628)   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
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

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 7.168ms