2018_Central_Park_Squirrel_Census_-_Squirrel_Data

51 rows where Climbing = 0, Date = 10072018 and Highlight Fur Color = "White" sorted by Runs from

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Running, Chasing, Eating, Foraging, Kuks, Tail flags, Indifferent, Runs from

Tail twitches ✖

  • 0 41
  • 1 10

Highlight Fur Color ✖

  • White · 51 ✖

Date ✖

  • 10072018 · 51 ✖

Climbing ✖

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
25 25 -73.96711306801141 40.7784859700171 17F-AM-1007-07 17F AM 10072018 7 Adult Gray White Gray+White   Above Ground 24   1 0 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9671130680114 40.7784859700171)
68 68 -73.96942403275091 40.7755898126674 13F-AM-1007-02 13F AM 10072018 2 Adult Cinnamon White Cinnamon+White         0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.96942403275091 40.7755898126674)
73 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)
115 115 -73.9530040923555 40.7922896176936 36I-PM-1007-10 36I PM 10072018 10 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0 stole (found?) an entire sandwich 0 0 0 0 0 0 1 0   POINT (-73.9530040923555 40.7922896176936)
163 163 -73.97123088643941 40.7714534847379 9G-AM-1007-04 09G AM 10072018 4 Adult Gray White Gray+White   Above Ground 15   0 0 0 0 0 grooming 0 0 0 0 0 0 1 0   POINT (-73.9712308864394 40.7714534847379)
269 269 -73.9591400366159 40.7891708599318 31F-PM-1007-01 31F PM 10072018 1 Adult Gray White Gray+White white neck and belly Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9591400366159 40.7891708599318)
348 348 -73.9542990150586 40.794091530067796 37G-PM-1007-09 37G PM 10072018 9 Adult Cinnamon White Cinnamon+White         0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9542990150586 40.7940915300678)
349 349 -73.9689657039917 40.776783427676705 15F-AM-1007-04 15F AM 10072018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9689657039917 40.7767834276767)
385 385 -73.979316275899 40.769213472755496 3B-PM-1007-01 03B PM 10072018 1 Adult Gray White Gray+White   Above Ground   in tree 0 0 0 0 0 chased by dog 0 0 0 0 0 0 0 0   POINT (-73.979316275899 40.7692134727555)
407 407 -73.9787658435198 40.768941976539296 3B-PM-1007-07 03B PM 10072018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0 eating loudly <- peanuts w/ shells 0 0 0 0 0 0 1 0   POINT (-73.9787658435198 40.7689419765393)
437 437 -73.9793952066038 40.7707837657859 4A-PM-1007-03 04A PM 10072018 3 Adult Gray White Gray+White   Ground Plane FALSE by rock 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9793952066038 40.77078376578591)
468 468 -73.9780659679557 40.7672382282781 1D-PM-1007-06 01D PM 10072018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9780659679557 40.7672382282781)
475 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)
575 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)
694 694 -73.9698032734704 40.7782343912417 16D-AM-1007-02 16D AM 10072018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9698032734704 40.7782343912417)
741 741 -73.9790214253443 40.7686791169776 3B-PM-1007-10 03B PM 10072018 10 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0 hopping 0 0 0 0 0 0 1 0   POINT (-73.9790214253443 40.7686791169776)
750 750 -73.96996720741642 40.777438934574796 15D-AM-1007-07 15D AM 10072018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 1 chasing #8 0 0 0 0 0 0 1 0   POINT (-73.9699672074164 40.7774389345748)
800 800 -73.96821440393342 40.7773070675393 15F-AM-1007-08 15F AM 10072018 8 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9682144039334 40.7773070675393)
817 817 -73.9540022445432 40.7979409854977 41E-AM-1007-01 41E AM 10072018 1 Adult Gray White Gray+White white haunches Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9540022445432 40.7979409854977)
1246 1246 -73.9543044385367 40.7984498571338 41E-AM-1007-04 41E AM 10072018 4 Adult Cinnamon White Cinnamon+White white haunches/tail Ground Plane FALSE rubbing belly on ground 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9543044385367 40.798449857133804)
1342 1342 -73.96620636423451 40.789077866530704 28A-PM-1007-04 28A PM 10072018 4 Adult Gray White Gray+White         0 0 0 0 0 looking at me & #5 1 0 0 0 1 0 0 0 freezes POINT (-73.9662063642345 40.7890778665307)
1418 1418 -73.9673924060436 40.7788781851716 17F-AM-1007-03 17F AM 10072018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9673924060436 40.7788781851716)
1494 1494 -73.95257524081691 40.7954915417553 39H-AM-1007-03 39H AM 10072018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9525752408169 40.7954915417553)
1498 1498 -73.9765064169087 40.7737211426714 8B-AM-1007-06 08B AM 10072018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9765064169087 40.7737211426714)
1590 1590 -73.9610388059192 40.793952935840004 34B-PM-1007-01 34B PM 10072018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9610388059192 40.79395293584)
1660 1660 -73.98004994980342 40.7702181099573 4A-PM-1007-05 04A PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE At rock 0 0 0 0 1   0 0 0 1 1 0 1 0   POINT (-73.9800499498034 40.770218109957305)
1671 1671 -73.9611399573659 40.781130706026 22I-AM-1007-01 22I AM 10072018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9611399573659 40.781130706026005)
1730 1730 -73.97961428483491 40.7702117898305 4A-PM-1007-04 04A PM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9796142848349 40.7702117898305)
1826 1826 -73.9707542189896 40.7717032986885 9G-PM-1007-04 09G PM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9707542189896 40.77170329868851)
1929 1929 -73.9646023053207 40.7810680044024 20F-PM-1007-14 20F PM 10072018 14 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9646023053207 40.78106800440241)
2111 2111 -73.968446056806 40.785824818871 24A-PM-1007-01 24A PM 10072018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.96844605680602 40.785824818871)
2173 2173 -73.95461232594408 40.7941434862099 37G-PM-1007-05 37G PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0 jumping around! 0 0 0 0 0 0 0 0   POINT (-73.9546123259441 40.7941434862099)
2326 2326 -73.9691692160865 40.7725330502929 10H-PM-1007-02 10H PM 10072018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9691692160865 40.7725330502929)
2346 2346 -73.9562177305881 40.798341327633096 41C-PM-1007-03 41C PM 10072018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9562177305881 40.7983413276331)
2478 2478 -73.96749310703241 40.778369369095394 17F-AM-1007-04 17F AM 10072018 4 Adult Cinnamon White Cinnamon+White   Above Ground 4   0 0 0 1 0 chilling 1 0 0 0 0 0 1 0   POINT (-73.9674931070324 40.7783693690954)
2518 2518 -73.9647219419257 40.781208440293206 20F-PM-1007-03 20F PM 10072018 3 Adult Gray White Gray+White gray on haunches white on tail Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9647219419257 40.7812084402932)
2529 2529 -73.98002714878629 40.7702554167042 4A-PM-1007-06 04A PM 10072018 6 Adult Gray White Gray+White   Ground Plane FALSE A rock 0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9800271487863 40.7702554167042)
2704 2704 -73.96577644902841 40.781192322928604 20F-PM-1007-10 20F PM 10072018 10 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9657764490284 40.7811923229286)
2732 2732 -73.9694185786221 40.7787189999566 16D-AM-1007-06 16D AM 10072018 6 Adult Cinnamon White Cinnamon+White primary color: brown ( I marked cinnamon as closest to brown - JO) Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9694185786221 40.7787189999566)
2743 2743 -73.9587179613803 40.7992119571657 41A-PM-1007-01 41A PM 10072018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9587179613803 40.7992119571657)
2906 2906 -73.9597260014375 40.790707423031 32E-AM-1007-04 32E AM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9597260014375 40.790707423031)
2944 2944 -73.97394038506219 40.769316228750895 5F-AM-1007-05 05F AM 10072018 5 Adult Gray White Gray+White   Above Ground 2 tree 1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9739403850622 40.7693162287509)
421 421 -73.9664630067791 40.775636151582496 14H-AM-1007-04 14H AM 10072018 4 Juvenile Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9664630067791 40.7756361515825)
574 574 -73.97063600052749 40.7717074044466 9G-PM-1007-05 09G PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9706360005275 40.7717074044466)
1126 1126 -73.97001860010491 40.7826052184658 20B-AM-1007-03 20B AM 10072018 3 Adult Gray White Gray+White   Above Ground     0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9700186001049 40.7826052184658)
1421 1421 -73.9595022290348 40.7831151330074 25I-PM-1007-02 25I PM 10072018 2 Adult Gray White Gray+White white belly Ground Plane FALSE   0 0 0 0 1   0 0 0 1 1 0 0 1   POINT (-73.9595022290348 40.783115133007406)
1577 1577 -73.965390623703 40.7807731363782 20F-PM-1007-08 20F PM 10072018 8 Adult Cinnamon White Cinnamon+White white tail/belly Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.965390623703 40.7807731363782)
1914 1914 -73.9588714413332 40.7895787115444 31F-PM-1007-03 31F PM 10072018 3 Adult Gray White Gray+White white belly Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9588714413332 40.7895787115444)
2040 2040 -73.96481673340891 40.7811164976329 20F-PM-1007-02 20F PM 10072018 2 Adult Gray White Gray+White white on tail Ground Plane FALSE   0 0 0 1 1 digging one hole w/ determination 0 0 0 0 1 0 0 1   POINT (-73.96481673340891 40.7811164976329)
2094 2094 -73.9701630539326 40.7779553961101 15D-AM-1007-04 15D AM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.97016305393261 40.7779553961101)
3005 3005 -73.96161411525391 40.7921803313341 33C-PM-1007-04 33C PM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9616141152539 40.7921803313341)

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