2018_Central_Park_Squirrel_Census_-_Squirrel_Data

47 rows where Date = 10142018, Highlight Fur Color = "White" and Indifferent = 1 sorted by Combination of Primary and Highlight Color

✎ 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, Climbing, Eating, Foraging, Kuks, Quaas, Runs from

Tail twitches ✖

  • 0 42
  • 1 5

Indifferent ✖

Highlight Fur Color ✖

  • White · 47 ✖

Date ✖

  • 10142018 · 47 ✖
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
967 967 -73.9683994064731 40.7710765500799 9I-AM-1014-06 09I AM 10142018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.96839940647311 40.7710765500799)
1140 1140 -73.9615817859213 40.7945839663845 35A-AM-1014-08 35A AM 10142018 8 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9615817859213 40.79458396638451)
1177 1177 -73.98078982247259 40.768215817511 1A-PM-1014-04 01A PM 10142018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9807898224726 40.768215817511)
77 77 -73.9615696577673 40.7951278622399 35A-AM-1014-03 35A AM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9615696577673 40.7951278622399)
184 184 -73.9553811810434 40.7970895007931 40E-AM-1014-02 40E AM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9553811810434 40.7970895007931)
359 359 -73.9716404781264 40.7753181851766 12D-PM-1014-02 12D PM 10142018 2 Adult Gray White Gray+White   Above Ground 15   0 0 1 0 0 seems to be grinding teeth on a piece of material (sounds from grinding) 0 0 0 0 0 0 1 0   POINT (-73.9716404781264 40.7753181851766)
428 428 -73.96362827608 40.780799459524204 21G-AM-1014-02 21G AM 10142018 2 Adult Gray White Gray+White   Above Ground 3 fence 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.96362827608 40.7807994595242)
439 439 -73.9589770206691 40.791240542172 33E-AM-1014-05 33E AM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9589770206691 40.791240542172)
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)
649 649 -73.9554891003543 40.7968774599654 40E-AM-1014-03 40E AM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9554891003543 40.79687745996541)
664 664 -73.9725174868556 40.7664248283566 3H-PM-1014-07 03H PM 10142018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9725174868556 40.7664248283566)
702 702 -73.963858549251 40.7808999610914 21G-AM-1014-03 21G AM 10142018 3 Adult Gray White Gray+White   Above Ground 7   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.963858549251 40.7808999610914)
736 736 -73.9660110060416 40.780999009859705 20F-AM-1014-01 20F AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9660110060416 40.7809990098597)
742 742 -73.9767016963397 40.7674012784541 2E-PM-1014-02 02E PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9767016963397 40.7674012784541)
840 840 -73.9598084794625 40.797616543450204 39A-PM-1014-01 39A PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9598084794625 40.7976165434502)
845 845 -73.9582850206205 40.7978975855555 39B-PM-1014-01 39B PM 10142018 1 Adult Gray White Gray+White White belly Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9582850206205 40.7978975855555)
1122 1122 -73.9728700359494 40.7659842666881 3H-PM-1014-05 03H PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9728700359494 40.7659842666881)
1151 1151 -73.9557602499712 40.7956452424385 38E-PM-1014-01 38E PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9557602499712 40.7956452424385)
1310 1310 -73.9546201403481 40.798942376865604 42D-AM-1014-03 42D AM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9546201403481 40.7989423768656)
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)
1453 1453 -73.9555856074105 40.7969457685677 40E-AM-1014-04 40E AM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE on rocks/bushy rocks 1 0 0 0 0 hiding from bird 0 1 0 0 1 0 1 0   POINT (-73.9555856074105 40.79694576856771)
1482 1482 -73.95886101956991 40.7945269936639 36C-AM-1014-02 36C AM 10142018 2 Juvenile Gray White Gray+White   Ground Plane FALSE Crossing path 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9588610195699 40.7945269936639)
1604 1604 -73.9734644470766 40.7782766486921 14A-PM-1014-05 14A PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.97346444707661 40.7782766486921)
1667 1667 -73.96459890035891 40.778215745915496 18H-PM-1014-01 18H PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9645989003589 40.7782157459155)
1860 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)
1870 1870 -73.9542118614769 40.7939171395463 37G-AM-1014-06 37G AM 10142018 6 Adult Gray White Gray+White White tail Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.95421186147692 40.7939171395463)
1873 1873 -73.955754300682 40.795681399740005 38E-PM-1014-02 38E PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.955754300682 40.79568139974)
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)
2041 2041 -73.9651796685091 40.7785578267586 18G-AM-1014-03 18G AM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9651796685091 40.7785578267586)
2104 2104 -73.9622419917579 40.794579797904 35A-AM-1014-07 35A AM 10142018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9622419917579 40.794579797904)
2105 2105 -73.9738723117119 40.7786845612246 14A-AM-1014-01 14A AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 foraging?,crossing road 0 0 0 0 0 0 1 1 runs from (dogs) POINT (-73.9738723117119 40.7786845612246)
2112 2112 -73.9655206571055 40.7764851568746 16H-PM-1014-02 16H PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9655206571055 40.7764851568746)
2119 2119 -73.96415843952991 40.7816571644072 21G-AM-1014-01 21G AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9641584395299 40.7816571644072)
2157 2157 -73.9657171357842 40.7773277532224 16H-PM-1014-05 16H PM 10142018 5 Adult Gray White Gray+White   Above Ground 5 tree 1 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9657171357842 40.7773277532224)
2160 2160 -73.975028559002 40.7667307335544 2F-PM-1014-09 02F PM 10142018 9 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.975028559002 40.7667307335544)
2410 2410 -73.97551920769341 40.7664413570796 2F-PM-1014-06 02F PM 10142018 6 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9755192076934 40.7664413570796)
2545 2545 -73.9617594316752 40.7946803725236 35A-AM-1014-01 35A AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9617594316752 40.7946803725236)
2558 2558 -73.97494695668541 40.7667805367199 2F-PM-1014-10 02F PM 10142018 10 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9749469566854 40.7667805367199)
2613 2613 -73.96393252683 40.7808289765857 21G-AM-1014-04 21G AM 10142018 4 Adult Gray White Gray+White   Above Ground 6   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.96393252683 40.7808289765857)
2632 2632 -73.95082755733499 40.797579073666 42H-PM-1014-02 42H PM 10142018 2 Adult Gray White Gray+White   Above Ground   Running along stone ledge 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.950827557335 40.797579073666)
2645 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)
2804 2804 -73.9576094432477 40.7965342664074 38C-PM-1014-07 38C PM 10142018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9576094432477 40.7965342664074)
2805 2805 -73.9711634340673 40.7760553338671 13D-AM-1014-05 13D AM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9711634340673 40.7760553338671)
2887 2887 -73.964593167562 40.7780374890066 18H-PM-1014-02 18H PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.964593167562 40.7780374890066)
2920 2920 -73.9657391918196 40.776502470347 16H-PM-1014-01 16H PM 10142018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9657391918196 40.776502470347)
2949 2949 -73.9651206201297 40.778527906484705 18G-AM-1014-02 18G AM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9651206201297 40.7785279064847)
2953 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)

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