2018_Central_Park_Squirrel_Census_-_Squirrel_Data

158 rows where Date = 10192018 sorted by longitude descending

✎ View and edit SQL

This data as json, CSV (advanced)

Eating ✖

  • 0 46
  • 1 12

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
332 332 -73.9705123624953 40.7731723757869 10F-PM-1019-11 10F PM 10192018 11 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Grassy area 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9705123624953 40.7731723757869)
2597 2597 -73.97063044050999 40.77710605948079 14D-PM-1019-14 14D PM 10192018 14 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.97063044051 40.7771060594808)
363 363 -73.97071972744808 40.777395680343105 14D-PM-1019-12 14D PM 10192018 12 Adult Gray   Gray+         0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9707197274481 40.7773956803431)
390 390 -73.970720187655 40.7774564799983 14D-PM-1019-11 14D PM 10192018 11 Adult Gray   Gray+         0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.970720187655 40.7774564799983)
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 1 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9708002461415 40.7726685284831)
1893 1893 -73.9708108312271 40.7773975776146 14D-PM-1019-09 14D PM 10192018 9 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9708108312271 40.7773975776146)
2237 2237 -73.9708225719705 40.7772497804149 14D-PM-1019-13 14D PM 10192018 13 Adult Gray   Gray+         0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9708225719705 40.7772497804149)
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 1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9708564226824 40.7726219968014)
2662 2662 -73.97086289336241 40.772563088678396 10F-PM-1019-08 10F PM 10192018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Under "Grape Arbor" structure behind Bandshell 1 0 0 0 1 digging 0 0 0 0 0 0 0 1   POINT (-73.9708628933624 40.7725630886784)
181 181 -73.9708775864433 40.772473633538 10F-PM-1019-12 10F PM 10192018 12 Adult Black White Black+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9708775864433 40.772473633538)
1642 1642 -73.97088608794591 40.77683766561189 14D-PM-1019-15 14D PM 10192018 15 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9708860879459 40.7768376656119)
2198 2198 -73.97097381665309 40.7774102689734 14D-PM-1019-08 14D PM 10192018 8 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9709738166531 40.7774102689734)
980 980 -73.9709817796369 40.7773554311586 14D-PM-1019-07 14D PM 10192018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9709817796369 40.7773554311586)
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 0 0 0 1 0 eating (nuts) 0 0 0 0 0 1 0 0 approaches (bad tourists w/ nuts) POINT (-73.9709991016317 40.772575670774806)
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 0 0 1 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9710221361528 40.7724939691584)
2715 2715 -73.9710273070712 40.776652124615296 14D-PM-1019-16 14D PM 10192018 16 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9710273070712 40.7766521246153)
2203 2203 -73.97105314852979 40.7773757069445 14D-PM-1019-06 14D PM 10192018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.97105314852982 40.777375706944504)
99 99 -73.9710541405708 40.772469160571795 10F-PM-1019-05 10F PM 10192018 5 Adult Black   Black+   Above Ground 10 Behind fence, tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9710541405708 40.7724691605718)
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) 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.97107389601 40.7723265810536)
209 209 -73.97107601968679 40.7725506006789 10F-PM-1019-02 10F PM 10192018 2 Juvenile Gray Cinnamon Gray+Cinnamon Cinnamon head & stripe Ground Plane FALSE Behind fence, grass 1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9710760196868 40.7725506006789)
1026 1026 -73.9710951149579 40.772501245008 10F-PM-1019-04 10F PM 10192018 4 Adult Black   Black+   Ground Plane FALSE Behind fence, grass 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9710951149579 40.772501245008)
737 737 -73.97111769994709 40.7724278547281 10F-PM-1019-06 10F PM 10192018 6 Adult Gray White Gray+White   Above Ground 10 Different tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9711176999471 40.7724278547281)
2053 2053 -73.97118102224209 40.7773445611969 14D-PM-1019-05 14D PM 10192018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9711810222421 40.7773445611969)
218 218 -73.9712318712643 40.7773053099657 14D-PM-1019-04 14D PM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9712318712643 40.7773053099657)
2544 2544 -73.9713680837672 40.77716615083639 14D-PM-1019-03 14D PM 10192018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9713680837672 40.77716615083641)
2509 2509 -73.97142951022491 40.776954371947 14D-PM-1019-02 14D PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9714295102249 40.776954371947)
1997 1997 -73.97146376830841 40.776898456156296 14D-PM-1019-01 14D PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9714637683084 40.7768984561563)
932 932 -73.9718597156773 40.776585876331296 13C-PM-1019-04 13C PM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9718597156773 40.7765858763313)
1465 1465 -73.9720289863666 40.7763749561607 13C-PM-1019-03 13C PM 10192018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.97202898636661 40.7763749561607)
2904 2904 -73.97203897567171 40.7763524091989 13C-PM-1019-02 13C PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9720389756717 40.7763524091989)
286 286 -73.97209073846129 40.7762987836055 13C-PM-1019-01 13C PM 10192018 1 Adult Gray   Gray+   Above Ground 7   0 0 1 0 0   1 0 0 0 0 0 1 0   POINT (-73.9720907384613 40.7762987836055)
482 482 -73.97217978245759 40.7801213843628 16A-PM-1019-07 16A PM 10192018 7 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 0 0 approaches (very friendly) POINT (-73.9721797824576 40.7801213843628)
644 644 -73.97221256300399 40.776131146585705 13C-PM-1019-05 13C PM 10192018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 1 1 0   POINT (-73.972212563004 40.7761311465857)
1524 1524 -73.97259615083159 40.7795720444974 16A-PM-1019-06 16A PM 10192018 6 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9725961508316 40.7795720444974)
2660 2660 -73.97260564119709 40.77934679047429 16A-PM-1019-03 16A PM 10192018 3   Gray   Gray+   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9726056411971 40.7793467904743)
2488 2488 -73.97269208477921 40.779411746388895 16A-PM-1019-02 16A PM 10192018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1 scared by dog POINT (-73.9726920847792 40.7794117463889)
2924 2924 -73.9727230609785 40.7795341640894 16A-PM-1019-01 16A PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9727230609785 40.7795341640894)
2877 2877 -73.9730027200009 40.7798000868804 16A-PM-1019-05 16A PM 10192018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9730027200009 40.7798000868804)
343 343 -73.9730224561601 40.7796833353894 16A-PM-1019-04 16A PM 10192018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9730224561601 40.7796833353894)
2380 2380 -73.97613757295049 40.766223189212496 1F-PM-1019-02 01F PM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9761375729505 40.7662231892125)
1254 1254 -73.97640135898651 40.766306349920704 1F-PM-1019-03 01F PM 10192018 3 Juvenile Gray   Gray+   Above Ground 1   0 0 0 0 0 hiding 0 0 0 0 0 0 0 0   POINT (-73.9764013589865 40.7663063499207)
2287 2287 -73.97681733031649 40.7661261813557 1F-PM-1019-01 01F PM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9768173303165 40.7661261813557)
2153 2153 -73.9797122322834 40.767834758743504 1B-PM-1019-10 01B PM 10192018 10 Adult Cinnamon White Cinnamon+White   Above Ground   Dog chased up tree 0 0 1 0 0   0 0 0 0 1 0 0 0   POINT (-73.97971223228342 40.7678347587435)
2688 2688 -73.9799302952205 40.767720720979796 1B-PM-1019-02 01B PM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9799302952205 40.7677207209798)
495 495 -73.9801007327506 40.7677455633932 1B-PM-1019-06 01B PM 10192018 6 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9801007327506 40.7677455633932)
1411 1411 -73.98028400317591 40.7678599069819 1B-PM-1019-04 01B PM 10192018 4 Juvenile Gray White Gray+White   Above Ground 25 in tree 0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9802840031759 40.7678599069819)
2865 2865 -73.98028424040159 40.767825738497706 1B-PM-1019-03 01B PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 25 in tree 0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.98028424040162 40.7678257384977)
2800 2800 -73.9802983138318 40.7676540772339 1B-PM-1019-05 01B PM 10192018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9802983138318 40.7676540772339)
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 0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9803282698463 40.7680809889384)
1582 1582 -73.9804065254162 40.7681481183296 1B-PM-1019-08 01B PM 10192018 8 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9804065254162 40.7681481183296)
2482 2482 -73.9805927710872 40.76799891166421 1B-PM-1019-07 01B PM 10192018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9805927710872 40.7679989116642)
1184 1184 -73.9807982742225 40.7678795985389 1B-PM-1019-01 01B PM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9807982742225 40.7678795985389)
855 855 -73.9808247660048 40.76894088312871 2A-PM-1019-01 02A PM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 runs from 0 0 0 1 0 0 0 1   POINT (-73.9808247660048 40.7689408831287)
1956 1956 -73.98089749771201 40.7690578709841 2A-PM-1019-02 02A PM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 0   POINT (-73.980897497712 40.7690578709841)
2412 2412 -73.98094464895641 40.768503216587895 2A-PM-1019-03 02A PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 15 in tree! 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9809446489564 40.7685032165879)
999 999 -73.980948293606 40.76856888506279 2A-PM-1019-04 02A PM 10192018 4 Juvenile Gray White Gray+White   Above Ground 15 in tree! 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.980948293606 40.7685688850628)
2684 2684 -73.9809688694074 40.7688535974878 2A-PM-1019-06 02A PM 10192018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9809688694074 40.7688535974878)
2777 2777 -73.98108436110859 40.768790549369896 2A-PM-1019-05 02A PM 10192018 5 ? Gray   Gray+   Above Ground 50 in tall planetree 1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9810843611086 40.7687905493699)

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "2018_Central_Park_Squirrel_Census_-_Squirrel_Data" (
"longitude" REAL,
  "latitude" REAL,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" INTEGER,
  "Hectare Squirrel Number" INTEGER,
  "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" INTEGER,
  "Chasing" INTEGER,
  "Climbing" INTEGER,
  "Eating" INTEGER,
  "Foraging" INTEGER,
  "Other Activities" TEXT,
  "Kuks" INTEGER,
  "Quaas" INTEGER,
  "Moans" INTEGER,
  "Tail flags" INTEGER,
  "Tail twitches" INTEGER,
  "Approaches" INTEGER,
  "Indifferent" INTEGER,
  "Runs from" INTEGER,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT
);
Powered by Datasette · Query took 8.945ms