2018_Central_Park_Squirrel_Census_-_Squirrel_Data

39 rows where Hectare Squirrel Number = 1, Highlight Fur Color = "White" and Location = "Above Ground" sorted by Lat/Long

✎ View and edit SQL

This data as json, CSV (advanced)

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

Tail twitches ✖

  • 0 31
  • 1 8

Location ✖

  • Above Ground · 39 ✖

Highlight Fur Color ✖

  • White · 39 ✖

Hectare Squirrel Number ✖

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 ▼
601 601 -73.9522291603405 40.7976985385835 42G-PM-1014-01 42G PM 10142018 1 Adult Gray White Gray+White   Above Ground 8   0 0 1 0 1   0 0 1 0 0 0 0 1   POINT (-73.9522291603405 40.7976985385835)
2252 2252 -73.95377032313591 40.7915959393814 35I-AM-1013-01 35I AM 10132018 1 Adult Cinnamon White Cinnamon+White White underbelly Above Ground 18   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9537703231359 40.7915959393814)
1924 1924 -73.95423325052309 40.793347517143395 37G-AM-1014-01 37G AM 10142018 1 Adult Gray White Gray+White White tail Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9542332505231 40.7933475171434)
953 953 -73.9547959269955 40.7925162926273 36H-PM-1008-01 36H PM 10082018 1 Adult Gray White Gray+White white belly Above Ground 20   1 0 1 0 1   1 1 0 0 0 0 1 0   POINT (-73.9547959269955 40.7925162926273)
781 781 -73.955516031113 40.7923188156277 35G-AM-1007-01 35G AM 10072018 1 Adult Gray White Gray+White   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.955516031113 40.7923188156277)
773 773 -73.95661891453521 40.7883417969746 31H-PM-1008-01 31H PM 10082018 1 Adult Gray White Gray+White   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9566189145352 40.7883417969746)
102 102 -73.95759861613641 40.799368134968 41B-PM-1014-01 41B PM 10142018 1 Adult Gray White Gray+White   Above Ground 25 Climbing tree 0 0 1 0 0 climbing (tree) 0 0 0 0 0 0 0 1   POINT (-73.9575986161364 40.799368134968)
45 45 -73.9579645940414 40.7918613498407 34F-AM-1007-01 34F AM 10072018 1 Adult Gray White Gray+White   Above Ground 25   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9579645940414 40.7918613498407)
1225 1225 -73.95848035139392 40.7933802077327 35D-PM-1013-01 35D PM 10132018 1 Adult Gray White Gray+White   Above Ground 12   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9584803513939 40.7933802077327)
1315 1315 -73.9595955824812 40.793304794353396 34D-PM-1007-01 34D PM 10072018 1 Adult Gray White Gray+White   Above Ground 25   0 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.9595955824812 40.7933047943534)
1423 1423 -73.96002043282009 40.782877291358 24I-AM-1019-01 24I AM 10192018 1 Adult Gray White Gray+White   Above Ground 10   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9600204328201 40.782877291358)
488 488 -73.9615751148595 40.795455123814605 36A-AM-1018-01 36A AM 10182018 1 Juvenile Gray White Gray+White   Above Ground 15   0 0 0 1 0 eating (red berries) 0 0 0 0 0 0 1 0   POINT (-73.9615751148595 40.7954551238146)
2497 2497 -73.9622050752008 40.7886373772305 29D-PM-1010-01 29D PM 10102018 1 Juvenile Gray White Gray+White   Above Ground 10   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9622050752008 40.7886373772305)
1825 1825 -73.9624209799704 40.79102009727521 31C-PM-1010-01 31C PM 10102018 1 Adult Gray White Gray+White   Above Ground 3   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9624209799704 40.7910200972752)
844 844 -73.9642379942652 40.777479252073796 17I-PM-1017-01 17I PM 10172018 1 Juvenile Cinnamon White Cinnamon+White   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0 was in a tree,so i couldn't really tell POINT (-73.9642379942652 40.7774792520738)
2114 2114 -73.9651541395415 40.7798283208748 19G-PM-1017-01 19G PM 10172018 1 Adult Cinnamon White Cinnamon+White   Above Ground 12   0 0 0 0 0 watching 0 0 0 0 0 1 0 0   POINT (-73.9651541395415 40.7798283208748)
1241 1241 -73.9651817987035 40.781908283833396 21E-AM-1017-01 21E AM 10172018 1 Adult Gray White Gray+White   Above Ground 3 Climbs small tree 0 0 0 1 1   0 0 0 0 1 0 0 0 walks from POINT (-73.9651817987035 40.7819082838334)
2956 2956 -73.9654741695628 40.7890427851106 28B-PM-1010-01 28B PM 10102018 1 Adult Gray White Gray+White   Above Ground 10 in a tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9654741695628 40.7890427851106)
1397 1397 -73.9655233748105 40.7792737287734 18G-AM-1014-01 18G AM 10142018 1 Juvenile Gray White Gray+White   Above Ground 10   0 0 1 0 0   1 0 0 0 0 0 1 0 looking POINT (-73.9655233748105 40.7792737287734)
2479 2479 -73.9657958433575 40.7763496875058 15H-AM-1013-01 15H AM 10132018 1 Adult Gray White Gray+White   Above Ground 50   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9657958433575 40.7763496875058)
2224 2224 -73.9662310606968 40.7747758221226 14I-AM-1013-01 14I AM 10132018 1 Adult Gray White Gray+White   Above Ground 10   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9662310606968 40.7747758221226)
2406 2406 -73.9668964315686 40.777757799088604 16G-AM-1010-01 16G AM 10102018 1 Adult Gray White Gray+White   Above Ground 3   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9668964315686 40.7777577990886)
498 498 -73.9669432929573 40.779136518298 18F-AM-1014-01 18F AM 10142018 1 Adult Gray White Gray+White   Above Ground   Low tree 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9669432929573 40.779136518298)
1935 1935 -73.9675268877392 40.775040968171794 13H-AM-1013-01 13H AM 10132018 1 Adult Gray White Gray+White   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9675268877392 40.7750409681718)
917 917 -73.9676514056678 40.7730853732876 11H-AM-1010-01 11H AM 10102018 1 Adult Gray White Gray+White   Above Ground 20   0 0 1 0 0   0 0 0 0 0 1 0 0 started climbing down to me POINT (-73.9676514056678 40.7730853732876)
1727 1727 -73.96924722995651 40.7722592187215 10H-PM-1007-01 10H PM 10072018 1 Adult Gray White Gray+White dark gray Above Ground 15 in tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9692472299565 40.7722592187215)
2550 2550 -73.96948057455221 40.774355690284295 12F-AM-1020-01 12F AM 10202018 1 Adult Cinnamon White Cinnamon+White   Above Ground 17 Tree 0 0 0 0 0 jumping 0 0 0 0 0 0 0 0   POINT (-73.9694805745522 40.7743556902843)
996 996 -73.9703149829421 40.778558363032296 16D-AM-1007-01 16D AM 10072018 1 Adult Gray White Gray+White   Above Ground 3   0 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9703149829421 40.7785583630323)
865 865 -73.9741621946917 40.775248147202504 11C-PM-1018-01 11C PM 10182018 1 Adult Gray White Gray+White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9741621946917 40.7752481472025)
426 426 -73.9741944367138 40.7769889953596 13B-PM-1008-01 13B PM 10082018 1 Adult Gray White Gray+White   Above Ground 2 on railing 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9741944367138 40.7769889953596)
2706 2706 -73.9745141185576 40.76914797812071 5E-AM-1008-01 05E AM 10082018 1 Adult Gray White Gray+White   Above Ground 2 on a checker table 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9745141185576 40.7691479781207)
2005 2005 -73.9755259087781 40.770725612418104 6D-AM-1008-01 06D AM 10082018 1 Adult Cinnamon White Cinnamon+White   Above Ground 10   0 0 1 1 0   1 0 0 0 0 1 0 0   POINT (-73.9755259087781 40.7707256124181)
294 294 -73.9756573579063 40.7656644063024 1G-PM-1010-01 01G PM 10102018 1 Adult Gray White Gray+White   Above Ground 15   0 0 1 1 0   0 0 0 1 0 0 1 0 too busy eating in his tree POINT (-73.9756573579063 40.7656644063024)
2973 2973 -73.9766693184436 40.7708879215854 6C-PM-1020-01 06C PM 10202018 1 Adult Gray White Gray+White   Above Ground 25 Across Transverse 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9766693184436 40.7708879215854)
1500 1500 -73.9769969548024 40.7710711265211 6C-AM-1007-01 06C AM 10072018 1 Adult Gray White Gray+White vid! Above Ground 15   0 0 1 0 0   0 0 0 0 1 0 0 0 curious,but wary POINT (-73.97699695480242 40.7710711265211)
137 137 -73.97824171151392 40.77246650364471 7A-AM-1006-01 07A AM 10062018 1 Adult Gray White Gray+White   Above Ground 10 in tree 0 0 0 0 1   0 1 0 0 1 0 0 0 looked at us POINT (-73.9782417115139 40.7724665036447)
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)
2387 2387 -73.98085173247209 40.7683154647217 1A-PM-1014-01 01A PM 10142018 1 Adult Cinnamon White Cinnamon+White   Above Ground 6   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9808517324721 40.7683154647217)
1413 1413 -73.98100322064279 40.768162563497896 1A-AM-1007-01 01A AM 10072018 1 Adult Gray White Gray+White   Above Ground 7   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9810032206428 40.7681625634979)

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