2018_Central_Park_Squirrel_Census_-_Squirrel_Data

67 rows where Foraging = 1, Hectare Squirrel Number = 5, Quaas = 0, Shift = "PM" and Tail twitches = 0

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, Running, Chasing, Climbing, Eating, Tail flags, Approaches, Indifferent, 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
17 -73.96950635353329 40.7823507678183 20B-PM-1013-05 20B PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9695063535333 40.7823507678183)
59 -73.9684910712272 40.776881164002106 15F-PM-1010-05 15F PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9684910712272 40.7768811640021)
66 -73.9749243901189 40.7761393551781 11B-PM-1014-05 11B PM 10142018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9749243901189 40.7761393551781)
70 -73.9804528867547 40.7696753655986 3A-PM-1017-05 03A PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9804528867547 40.76967536559861)
202 -73.97187291016759 40.7703692621371 7G-PM-1018-05 07G PM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9718729101676 40.7703692621371)
208 -73.9677646187171 40.7746492806333 13H-PM-1010-05 13H PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9677646187171 40.7746492806333)
239 -73.97584649051329 40.77259574088411 8C-PM-1013-05 08C PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9758464905133 40.7725957408841)
247 -73.97331176635409 40.7694584620114 6F-PM-1008-05 06F PM 10082018 5 Adult Cinnamon White Cinnamon+White white patch Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.97331176635412 40.7694584620114)
263 -73.9771069181511 40.76705382149879 2E-PM-1014-05 02E PM 10142018 5 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9771069181511 40.7670538214988)
355 -73.9639635134738 40.7900337598704 29B-PM-1010-05 29B PM 10102018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9639635134738 40.7900337598704)
357 -73.9724801784201 40.7790131966689 15B-PM-1017-05 15B PM 10172018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9724801784201 40.7790131966689)
412 -73.97856757980341 40.7672992405289 1C-PM-1013-05 01C PM 10132018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9785675798034 40.7672992405289)
436 -73.9734695768004 40.7716297491384 8E-PM-1008-05 08E PM 10082018 5 Adult Gray White Gray+White   Ground Plane FALSE 5, 6, 7 all at same tree trunk base 0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9734695768004 40.7716297491384)
456 -73.9547878025303 40.7899151873467 33I-PM-1006-05 33I PM 10062018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9547878025303 40.7899151873467)
474 -73.9540652304705 40.7955226178199 39G-PM-1013-05 39G PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9540652304705 40.7955226178199)
475 -73.9697855573137 40.7742186391935 12F-PM-1007-05 12F PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9697855573137 40.7742186391935)
516 -73.9597418366664 40.7964417084985 37B-PM-1013-05 37B PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9597418366664 40.7964417084985)
558 -73.95793352754859 40.7953080673706 37D-PM-1014-05 37D PM 10142018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9579335275486 40.7953080673706)
590 -73.97851333014259 40.77182602883379 6A-PM-1012-05 06A PM 10122018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9785133301426 40.7718260288338)
672 -73.9588708103486 40.790579407884294 32F-PM-1008-05 32F PM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9588708103486 40.7905794078843)
689 -73.970595381455 40.7762912142457 13E-PM-1008-05 13E PM 10082018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.970595381455 40.7762912142457)
735 -73.971379936565 40.7721434941226 9F-PM-1014-05 09F PM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.971379936565 40.7721434941226)
793 -73.9730111650468 40.7782157736204 14B-PM-1014-05 14B PM 10142018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9730111650468 40.7782157736204)
863 -73.97640160306659 40.7689894344251 4D-PM-1008-05 04D PM 10082018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9764016030666 40.7689894344251)
864 -73.969485639023 40.780519159069 18C-PM-1018-05 18C PM 10182018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.969485639023 40.780519159069)
887 -73.9635028497015 40.7928207574906 32A-PM-1013-05 32A PM 10132018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9635028497015 40.7928207574906)
908 -73.9594120573719 40.78419457505979 26I-PM-1010-05 26I PM 10102018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10 tree 0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9594120573719 40.7841945750598)
909 -73.9665705456197 40.782355287104394 21D-PM-1008-05 21D PM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9665705456197 40.7823552871044)
989 -73.96030310596142 40.7943667735668 35C-PM-1013-05 35C PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9603031059614 40.7943667735668)
1014 -73.9694468044483 40.770360886038 8I-PM-1013-05 08I PM 10132018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9694468044483 40.770360886038)
1336 -73.97338200536791 40.76873304735621 5G-PM-1010-05 05G PM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9733820053679 40.7687330473562)
1456 -73.97142424264959 40.774453579812295 11E-PM-1012-05 11E PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 1 foraging (foraged,ran to tree root,munched) 0 0 0 0 0 0 1 0   POINT (-73.9714242426496 40.7744535798123)
1487 -73.96539465596099 40.7763136791661 15I-PM-1012-05 15I PM 10122018 5 Adult Gray   Gray+   Above Ground 2   1 0 1 0 1 burying the food on ground 0 0 0 0 0 0 0 0 look at us and continue hiding the food POINT (-73.965394655961 40.7763136791661)
1501 -73.96081673001041 40.795434868826796 36A-PM-1013-05 36A PM 10132018 5   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE EDGE OF WOODS 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9608167300104 40.7954348688268)
1568 -73.96810798698209 40.772349408134495 11I-PM-1012-05 11I PM 10122018 5 Adult Gray   Gray+   Above Ground 2   1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9681079869821 40.7723494081345)
1571 -73.96731290103119 40.7778169845999 16F-PM-1013-05 16F PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Pine tree near utility shed 0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9673129010312 40.7778169845999)
1606 -73.96289327978859 40.7923116396365 32B-PM-1010-05 32B PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9628932797886 40.7923116396365)
1637 -73.9699513151755 40.7722062991044 10G-PM-1017-05 10G PM 10172018 5 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9699513151755 40.7722062991044)
1676 -73.9566686940197 40.794924397955 37E-PM-1006-05 37E PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9566686940197 40.794924397955)
1711 -73.975836799137 40.7691593428471 4E-PM-1008-05 04E PM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.975836799137 40.769159342847104)
1728 -73.9787846880249 40.768254590348796 2C-PM-1013-05 02C PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9787846880249 40.7682545903488)
1763 -73.9768286349595 40.7687012827059 3D-PM-1010-05 03D PM 10102018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9768286349595 40.7687012827059)
1812 -73.9590074024938 40.7907059424675 32E-PM-1017-05 32E PM 10172018 5 Adult Gray   Gray+   Ground Plane FALSE treed area 0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9590074024938 40.7907059424675)
1839 -73.9655925527354 40.7760049171097 15H-PM-1008-05 15H PM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE lawn 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9655925527354 40.7760049171097)
1947 -73.97471754195459 40.769282003087795 5E-PM-1012-05 05E PM 10122018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 1 0 0 begging POINT (-73.9747175419546 40.7692820030878)
2000 -73.9591070579246 40.789677677115705 31F-PM-1007-05 31F PM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9591070579246 40.7896776771157)
2012 -73.95874648525609 40.793496354083 35D-PM-1013-05 35D PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9587464852561 40.793496354083)
2078 -73.9706041173545 40.778015278480396 15D-PM-1017-05 15D PM 10172018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9706041173545 40.7780152784804)
2131 -73.9752225195115 40.7703747669865 6D-PM-1020-05 06D PM 10202018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9752225195115 40.7703747669865)
2148 -73.9767317539505 40.7717600450632 6B-PM-1017-05 06B PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9767317539505 40.7717600450632)
2152 -73.9686925781295 40.7705688673142 9I-PM-1010-05 09I PM 10102018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9686925781295 40.7705688673142)
2155 -73.9538938706987 40.7981150065974 42E-PM-1012-05 42E PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9538938706987 40.7981150065974)
2240 -73.9697787673802 40.7781746195436 16D-PM-1010-05 16D PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9697787673802 40.7781746195436)
2260 -73.9784685928652 40.7669924015341 1D-PM-1007-05 01D PM 10072018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9784685928652 40.7669924015341)
2305 -73.9679833225379 40.773854709340206 12H-PM-1007-05 12H PM 10072018 5   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9679833225379 40.7738547093402)
2306 -73.956453902485 40.7936584431012 36F-PM-1012-05 36F PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.956453902485 40.7936584431012)
2317 -73.97673696861709 40.7735074437085 8B-PM-1012-05 08B PM 10122018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9767369686171 40.7735074437085)
2439 -73.95874591363909 40.7982497351812 40B-PM-1014-05 40B PM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9587459136391 40.7982497351812)
2537 -73.9735533713513 40.7690605609001 5F-PM-1007-05 05F PM 10072018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9735533713513 40.7690605609001)
2582 -73.9665004148497 40.780565641175606 19E-PM-1018-05 19E PM 10182018 5   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9665004148497 40.7805656411756)
2645 -73.9584967368893 40.797732034109394 39B-PM-1014-05 39B PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1 pretended to bury a nut,stuck a leaf on top to make the spot less conspicuous. 0 0 0 0 0 0 1 0   POINT (-73.9584967368893 40.7977320341094)
2750 -73.957775998085 40.7932880937406 35E-PM-1006-05 35E PM 10062018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.957775998085 40.7932880937406)
2817 -73.9596445861554 40.79719486790071 38A-PM-1013-05 38A PM 10132018 5 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9596445861554 40.7971948679007)
2873 -73.955068474109 40.79117881528779 34H-PM-1006-05 34H PM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White white tail tip Ground Plane FALSE in grass 1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.955068474109 40.7911788152878)
2891 -73.9636482556874 40.7775831570186 18I-PM-1007-05 18I PM 10072018 5 Juvenile Cinnamon Gray, Black Cinnamon+Gray, Black   Ground Plane FALSE   0 0 0 0 1 jumping crazily / digging hole 0 0 0 0 0 0 1 0   POINT (-73.9636482556874 40.7775831570186)
2953 -73.9585862117341 40.7986549251083 40A-PM-1014-05 40A PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1 eating (in a tree cage thing) 0 0 0 0 0 0 1 0   POINT (-73.9585862117341 40.7986549251083)
3020 -73.97040158596391 40.7825600069973 19A-PM-1013-05 19A PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9704015859639 40.7825600069973)

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