2018_Central_Park_Squirrel_Census_-_Squirrel_Data

64 rows where Eating = 0, Hectare Squirrel Number = 3, Indifferent = 1 and Shift = "PM"

View and edit SQL

Suggested facets: Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Foraging, Kuks, Tail flags, Tail twitches, Approaches, Runs from

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
65 -73.9741824992294 40.7689486657963 5F-PM-1007-03 05F PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 hiding nut 0 0 0 0 1 0 1 0   POINT (-73.9741824992294 40.7689486657963)
73 -73.96148483609001 40.7922645521905 33C-PM-1007-03 33C PM 10072018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.96148483609 40.7922645521905)
149 -73.9576349321357 40.7904409912437 32G-PM-1013-03 32G PM 10132018 3 Juvenile Gray Cinnamon Gray+Cinnamon Cinnamon belly Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9576349321357 40.7904409912437)
164 -73.9758676144255 40.7701671581939 5D-PM-1018-03 05D PM 10182018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9758676144255 40.7701671581939)
196 -73.965796978969 40.7760402842845 15H-PM-1008-03 15H PM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE lawn moving east over Park path 0 0 0 0 0 not sure walk-pause-walk 0 0 0 0 0 0 1 0   POINT (-73.96579697896901 40.7760402842845)
201 -73.9598015842806 40.7973522744237 38A-PM-1013-03 38A PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9598015842806 40.7973522744237)
280 -73.9587401274261 40.7960322222949 37C-PM-1013-03 37C PM 10132018 3 Adult Gray White Gray+White         0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9587401274261 40.7960322222949)
297 -73.9685604013735 40.7773439909065 15F-PM-1010-03 15F PM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9685604013735 40.7773439909065)
329 -73.967832992543 40.778366991340796 17E-PM-1018-03 17E PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.967832992543 40.7783669913408)
345 -73.9724452296309 40.7715792113505 8F-PM-1012-03 08F PM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 buried an acorn 0 0 0 0 0 0 1 0   POINT (-73.9724452296309 40.7715792113505)
408 -73.9633760173635 40.7818422357619 22G-PM-1018-03 22G PM 10182018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 chilling 0 0 0 0 0 0 1 0 observed POINT (-73.96337601736352 40.7818422357619)
432 -73.9757787135906 40.7737231427345 9B-PM-1013-03 09B PM 10132018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9757787135906 40.7737231427345)
542 -73.9713487591577 40.7784353043714 15C-PM-1017-03 15C PM 10172018 3 Adult Black   Black+   Above Ground 17 running across overpass 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9713487591577 40.7784353043714)
569 -73.9709040623777 40.7701163892686 7H-PM-1006-03 07H PM 10062018 3 Adult Gray   Gray+   Above Ground 8 tree 1 0 1 0 0   0 0 0 1 0 0 1 0   POINT (-73.9709040623777 40.7701163892686)
575 -73.9783366903829 40.7668300056094 1D-PM-1007-03 01D PM 10072018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9783366903829 40.7668300056094)
614 -73.9642411990432 40.7779692777193 18H-PM-1014-03 18H PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9642411990432 40.7779692777193)
617 -73.9558809064648 40.795276502224105 38E-PM-1014-03 38E PM 10142018 3   Gray   Gray+   Ground Plane FALSE THICK UNDERGROWTH 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9558809064648 40.7952765022241)
695 -73.96850806398729 40.774530979415495 13G-PM-1008-03 13G PM 10082018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 20 maple tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9685080639873 40.77453097941551)
748 -73.9756603846107 40.7672531319384 3F-PM-1013-03 03F PM 10132018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9756603846107 40.7672531319384)
784 -73.9649658099293 40.782326236907394 22F-PM-1014-03 22F PM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9649658099293 40.7823262369074)
877 -73.9710547484029 40.7723589827074 9F-PM-1014-03 09F PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9710547484029 40.7723589827074)
937 -73.97063234587691 40.7713196034265 9G-PM-1007-03 09G PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9706323458769 40.771319603426505)
1024 -73.9521514669041 40.7949515182825 39H-PM-1013-03 39H PM 10132018 3 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 1 1   POINT (-73.9521514669041 40.7949515182825)
1028 -73.97070123456609 40.7758938984066 13E-PM-1008-03 13E PM 10082018 3 Juvenile Gray White Gray+White   Above Ground 10 hanging upside down to get a nut 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9707012345661 40.7758938984066)
1058 -73.97371007431829 40.7708360121735 7E-PM-1013-03 07E PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE Ground & Tree Base 0 0 0 0 1   0 0 0 1 1 0 1 0   POINT (-73.9737100743183 40.7708360121735)
1150 -73.97447264347429 40.776729630785 12A-PM-1013-03 12A PM 10132018 3   Gray Cinnamon Gray+Cinnamon   Above Ground 3   1 0 0 0 0 chased up a tree by #4 0 0 0 0 0 0 1 0   POINT (-73.9744726434743 40.776729630785)
1222 -73.9691420412059 40.777349258213796 15E-PM-1008-03 15E PM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 walking 0 0 0 0 0 0 1 0   POINT (-73.9691420412059 40.7773492582138)
1291 -73.96859351775 40.7735537139641 11H-PM-1013-03 11H PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0 planting nut 0 0 0 0 0 0 1 0   POINT (-73.96859351775 40.7735537139641)
1301 -73.95521466657141 40.7892909102377 32I-PM-1007-03 32I PM 10072018 3 Adult Gray   Gray+ small adult Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9552146665714 40.7892909102377)
1326 -73.9747288122551 40.7659918747507 2G-PM-1007-03 02G PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9747288122551 40.7659918747507)
1393 -73.96871341377859 40.7812207913391 19C-PM-1018-03 19C PM 10182018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9687134137786 40.7812207913391)
1447 -73.9601968065017 40.7935831836482 34C-PM-1012-03 34C PM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9601968065017 40.79358318364821)
1448 -73.9772810073685 40.7693577540392 4C-PM-1010-03 04C PM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9772810073685 40.7693577540392)
1481 -73.95388671863759 40.794140943400706 38G-PM-1020-03 38G PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9538867186376 40.7941409434007)
1497 -73.9722261495647 40.7690542072646 6G-PM-1020-03 06G PM 10202018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9722261495647 40.7690542072646)
1542 -73.960876728048 40.790357245370004 31D-PM-1006-03 31D PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.960876728048 40.79035724537)
1616 -73.9642666013207 40.7810384867375 21G-PM-1007-03 21G PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.96426660132072 40.7810384867375)
1686 -73.9593373093799 40.7982428507976 39A-PM-1014-03 39A PM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Higlights. Made executive adjustments. Above Ground 6 Jumped from ground onto branch 0 0 0 0 1 digging? 0 0 0 0 1 0 1 0   POINT (-73.95933730937992 40.7982428507976)
1750 -73.9684806250183 40.7858776210151 24A-PM-1007-03 24A PM 10072018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9684806250183 40.7858776210151)
1851 -73.9623621412501 40.7814673556041 22H-PM-1007-03 22H PM 10072018 3 Adult Gray White Gray+White   Above Ground 4 chased squirrel #2 away 0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9623621412501 40.7814673556041)
1860 -73.9767100101318 40.7675779951996 2E-PM-1014-03 02E PM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9767100101318 40.7675779951996)
1874 -73.96573273328491 40.7747554568985 14I-PM-1018-03 14I PM 10182018 3 Juvenile Gray Black Gray+Black   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9657327332849 40.7747554568985)
1876 -73.973598991549 40.7783020016983 14A-PM-1014-03 14A PM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0 chasing (#4) 0 0 0 0 0 0 1 0   POINT (-73.973598991549 40.7783020016983)
1985 -73.9530791622513 40.79598856039671 40G-PM-1013-03 40G PM 10132018 3 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9530791622513 40.7959885603967)
2021 -73.95828003055091 40.798947371297395 40B-PM-1014-03 40B PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9582800305509 40.7989473712974)
2069 -73.9538377039825 40.798060533496106 42E-PM-1012-03 42E PM 10122018 3 Adult Gray White Gray+White   Above Ground 20 in tree 0 0 1 0 1   1 0 0 0 0 0 1 0   POINT (-73.9538377039825 40.7980605334961)
2071 -73.96676944398949 40.7779501809095 17G-PM-1017-03 17G PM 10172018 3 Adult Gray White Gray+White   Above Ground 10 tree & ground 1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9667694439895 40.7779501809095)
2077 -73.95627335110309 40.799314210183894 42C-PM-1013-03 42C PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE Crossing street 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9562733511031 40.7993142101839)
2129 -73.9701182454818 40.777280550087106 15D-PM-1017-03 15D PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9701182454818 40.7772805500871)
2178 -73.9557918001972 40.797922887804205 40D-PM-1013-03 40D PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9557918001972 40.7979228878042)
2213 -73.9707487237344 40.7800822831001 17B-PM-1012-03 17B PM 10122018 3 Adult Gray White Gray+White   Above Ground 10   1 1 0 0 0 2/3 chasing each other 0 0 0 0 1 0 1 0   POINT (-73.9707487237344 40.7800822831001)
2282 -73.9722056538718 40.7805111762703 17A-PM-1013-03 17A PM 10132018 3 Adult Gray   Gray+   Above Ground 15 tree 0 0 0 0 0 grooming! & scratching 0 0 0 0 0 0 1 0   POINT (-73.9722056538718 40.7805111762703)
2396 -73.9704339422613 40.77401495296439 11F-PM-1006-03 11F PM 10062018 3 Adult Gray   Gray+   Above Ground 4   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9704339422613 40.7740149529644)
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)
2477 -73.9663297144622 40.7837932023685 22D-PM-1012-03 22D PM 10122018 3 Adult Gray Black, White Gray+Black, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9663297144622 40.7837932023685)
2493 -73.954767265558 40.7973243644491 40E-PM-1017-03 40E PM 10172018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.954767265558 40.7973243644491)
2542 -73.9754802138871 40.773300804411996 9C-PM-1006-03 09C PM 10062018 3 Adult Gray White Gray+White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9754802138871 40.773300804412)
2631 -73.9690080105286 40.7710230515054 9I-PM-1010-03 09I PM 10102018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White         0 0 0 0 1   0 0 0 0 0 0 1 1   POINT (-73.9690080105286 40.7710230515054)
2686 -73.97755714038921 40.766531658519796 1E-PM-1007-03 01E PM 10072018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9775571403892 40.7665316585198)
2695 -73.962800448652 40.7915532640139 31B-PM-1007-03 31B PM 10072018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.962800448652 40.7915532640139)
2836 -73.953092053256 40.7982256930243 42F-PM-1017-03 42F PM 10172018 3   Gray Cinnamon Gray+Cinnamon         1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.953092053256 40.7982256930243)
2860 -73.95651796713192 40.7936663940365 36F-PM-1012-03 36F PM 10122018 3   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.95651796713192 40.7936663940365)
2890 -73.9726236083428 40.7788217771475 15B-PM-1017-03 15B PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE by water 1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9726236083428 40.778821777147506)
2960 -73.96252481451499 40.7810022923615 21H-PM-1018-03 21H PM 10182018 3 Adult Gray   Gray+   Above Ground 25   0 0 1 0 0   1 0 0 0 0 0 1 0   POINT (-73.962524814515 40.7810022923615)

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