2018_Central_Park_Squirrel_Census_-_Squirrel_Data

67 rows where Hectare Squirrel Number = 4 and Highlight Fur Color = "White" sorted by Highlight Fur Color

✎ View and edit SQL

This data as json, CSV (advanced)

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

Tail twitches ✖

  • 0 50
  • 1 17

Highlight Fur Color ✖

  • White · 67 ✖

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
29 29 -73.96717867152559 40.7867352791232 25A-AM-1013-04 25A AM 10132018 4   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9671786715256 40.7867352791232)
106 106 -73.9634623418761 40.7917685404482 31A-PM-1017-04 31A PM 10172018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9634623418761 40.7917685404482)
157 157 -73.9637946878735 40.791570044687795 31A-AM-1010-04 31A AM 10102018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9637946878735 40.7915700446878)
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)
173 173 -73.95877018015099 40.793412394152796 35D-PM-1013-04 35D PM 10132018 4 Juvenile Gray White Gray+White         0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.958770180151 40.7934123941528)
205 205 -73.9564724104048 40.7936055508162 36F-PM-1012-04 36F PM 10122018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9564724104048 40.7936055508162)
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)
354 354 -73.95667510223359 40.799035789744 41C-PM-1007-04 41C PM 10072018 4 Adult Gray White Gray+White   Above Ground 65   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9566751022336 40.799035789744)
375 375 -73.9752000129992 40.773291812223896 8C-PM-1013-04 08C PM 10132018 4 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9752000129992 40.7732918122239)
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)
490 490 -73.978426472499 40.771904101844 6A-PM-1012-04 06A PM 10122018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.978426472499 40.771904101844)
537 537 -73.9682803241007 40.772451055832704 11H-AM-1010-04 11H AM 10102018 4   Gray White Gray+White         0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9682803241007 40.7724510558327)
589 589 -73.97826438139 40.7717086090782 6A-AM-1006-04 06A AM 10062018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 1 0 0 0 curious POINT (-73.97826438139 40.7717086090782)
627 627 -73.97637911214379 40.770281512254 5D-PM-1018-04 05D PM 10182018 4 Adult Gray White Gray+White Partial missing tail Ground Plane FALSE   0 1 0 0 0 chasing (dog chasing) 0 0 0 0 0 0 0 1   POINT (-73.9763791121438 40.770281512254)
667 667 -73.9624538733037 40.7883829851518 28D-AM-1012-04 28D AM 10122018 4 Adult Cinnamon White Cinnamon+White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9624538733037 40.7883829851518)
743 743 -73.9565035705619 40.7937382705056 36F-AM-1017-04 36F AM 10172018 4 Juvenile Gray White Gray+White White legs, front & back Ground Plane FALSE   1 0 0 1 1   1 0 0 0 0 1 0 1 approaches (me),runs from (me) POINT (-73.9565035705619 40.7937382705056)
897 897 -73.97346875380642 40.769430895922206 6F-PM-1008-04 06F PM 10082018 4 Adult Cinnamon White Cinnamon+White patches of white on haunches Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9734687538064 40.7694308959222)
999 999 -73.980948293606 40.76856888506279 2A-PM-1019-04 02A PM 10192018 4 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.980948293606 40.7685688850628)
1083 1083 -73.9788117755401 40.7707347137469 5B-PM-1013-04 05B PM 10132018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.97881177554011 40.7707347137469)
1146 1146 -73.97943670962741 40.7672720598482 1C-PM-1013-04 01C PM 10132018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9794367096274 40.7672720598482)
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)
1182 1182 -73.9667206046912 40.777999356509795 17G-PM-1017-04 17G PM 10172018 4 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.9667206046912 40.7779993565098)
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)
1282 1282 -73.974451175321 40.770129463526395 6E-PM-1010-04 06E PM 10102018 4 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees 0 1 0 1 0 chasing #3 0 0 0 0 0 0 1 0   POINT (-73.974451175321 40.7701294635264)
1302 1302 -73.9704024529864 40.772925606388895 10G-AM-1006-04 10G AM 10062018 4 Juvenile Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0 chasing (#3) 1 0 0 0 0 0 0 0   POINT (-73.9704024529864 40.7729256063889)
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)
1356 1356 -73.9534910562766 40.7935774443789 37H-AM-1018-04 37H AM 10182018 4 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1 was with a lot of robins POINT (-73.9534910562766 40.7935774443789)
1405 1405 -73.9589371550945 40.7959812504467 37C-PM-1013-04 37C PM 10132018 4 Adult Gray White Gray+White         0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9589371550945 40.7959812504467)
1411 1411 -73.98028400317591 40.7678599069819 1B-PM-1019-04 01B PM 10192018 4 Juvenile Gray White Gray+White   Above Ground 25 in tree 0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9802840031759 40.7678599069819)
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)
1460 1460 -73.97143299793049 40.7741873388945 11E-PM-1012-04 11E PM 10122018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9714329979305 40.7741873388945)
1529 1529 -73.9692401421068 40.7707128895661 8I-AM-1006-04 08I AM 10062018 4 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9692401421068 40.7707128895661)
1541 1541 -73.9711617997772 40.7761212878075 13D-PM-1018-04 13D PM 10182018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9711617997772 40.7761212878075)
1547 1547 -73.958939037549 40.7913193931203 33E-PM-1012-04 33E PM 10122018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 playing 0 0 0 0 0 0 0 0   POINT (-73.958939037549 40.7913193931203)
1585 1585 -73.96113123553481 40.79501308639129 36A-PM-1013-04 36A PM 10132018 4   Gray White Gray+White   Ground Plane FALSE ON ROCK NEAR POND 0 0 0 0 0 sitting 0 0 0 0 1 0 1 0   POINT (-73.9611312355348 40.7950130863913)
1617 1617 -73.97520295136441 40.767173466736104 3F-AM-1006-04 03F AM 10062018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE on a rock 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9752029513644 40.7671734667361)
1663 1663 -73.96967203626271 40.779185159819704 17D-AM-1008-04 17D AM 10082018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9696720362627 40.7791851598197)
1709 1709 -73.9771696835698 40.76970111004871 4C-AM-1006-04 04C AM 10062018 4 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9771696835698 40.7697011100487)
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)
1767 1767 -73.958719099962 40.7947587726617 36C-AM-1014-04 36C AM 10142018 4   Gray White Gray+White   Above Ground 15 Ground then tree to eat 1 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.958719099962 40.7947587726617)
1802 1802 -73.9736418085696 40.7716931127716 8E-PM-1008-04 08E PM 10082018 4 Adult Gray White Gray+White   Ground Plane FALSE in grass by a grove of tall maples 0 0 0 1 1   0 0 0 0 0 0 1 0 there's a family playing soccer POINT (-73.9736418085696 40.7716931127716)
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)
1901 1901 -73.9680237209555 40.771702220822505 10I-AM-1010-04 10I AM 10102018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9680237209555 40.7717022208225)
1961 1961 -73.953664715831 40.7981256393159 41E-PM-1013-04 41E PM 10132018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.953664715831 40.7981256393159)
2014 2014 -73.97864748095141 40.7679715341109 2C-PM-1013-04 02C PM 10132018 4 Adult Gray White Gray+White         0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9786474809514 40.7679715341109)
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)
2103 2103 -73.9782983634755 40.766831436426294 1D-AM-1006-04 01D AM 10062018 4 Adult Gray White Gray+White   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9782983634755 40.7668314364263)
2145 2145 -73.96512504025829 40.7812884929069 20F-PM-1007-04 20F PM 10072018 4 Juvenile Gray White Gray+White white on tail Above Ground 20 climbed tree 0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9651250402583 40.7812884929069)
2232 2232 -73.9566277721581 40.7966674587803 39D-PM-1012-04 39D PM 10122018 4 Juvenile Gray White Gray+White   Above Ground 10 on tree trunk (descending from height of ~10 ft) 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.95662777215811 40.7966674587803)
2277 2277 -73.95385121459 40.7981257651433 42E-PM-1012-04 42E PM 10122018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.95385121459 40.7981257651433)
2340 2340 -73.9730284815849 40.7702462529502 7F-AM-1008-04 07F AM 10082018 4 Adult Gray White Gray+White   Ground Plane FALSE bush 0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9730284815849 40.7702462529502)
2349 2349 -73.98003374000399 40.768360829233295 2B-PM-1013-04 02B PM 10132018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.980033740004 40.7683608292333)
2353 2353 -73.963623175585 40.7927451068919 32A-PM-1013-04 32A PM 10132018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.963623175585 40.7927451068919)
2355 2355 -73.9728654439465 40.7724853142211 9E-AM-1008-04 09E AM 10082018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9728654439465 40.7724853142211)
2390 2390 -73.9680741975294 40.7847036778165 23B-PM-1012-04 23B PM 10122018 4 Adult Gray White Gray+White   Above Ground 20   0 0 0 0 0 watching me - didn't move 0 0 0 0 1 0 0 1   POINT (-73.9680741975294 40.7847036778165)
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)
2532 2532 -73.9695150319891 40.782613519363 20B-PM-1013-04 20B PM 10132018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 chased a bird carrying massive wad of grass 0 0 0 0 1 0 0 0   POINT (-73.9695150319891 40.782613519363)
2587 2587 -73.97899712868441 40.7707024146365 5A-PM-1010-04 05A PM 10102018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9789971286844 40.7707024146365)
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)
2618 2618 -73.95795157569 40.7961254697958 38C-PM-1014-04 38C PM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 0   0 0 0 1 0 0 0 1   POINT (-73.95795157569 40.7961254697958)
2745 2745 -73.97296259363002 40.7652601851275 1I-PM-1012-04 01I PM 10122018 4 Juvenile Cinnamon White Cinnamon+White Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 2 on ledge 0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.97296259363 40.7652601851275)
2779 2779 -73.9767835160078 40.767403033048204 2E-PM-1014-04 02E PM 10142018 4 Adult Cinnamon White Cinnamon+White   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9767835160078 40.7674030330482)
2842 2842 -73.9579292340076 40.7976287835027 39C-PM-1006-04 39C PM 10062018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9579292340076 40.7976287835027)
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)
2918 2918 -73.9745152462626 40.76554155159079 1G-AM-1006-04 01G AM 10062018 4 Adult Gray White Gray+White         0 1 0 0 1 collecting nest material 0 0 0 0 1 0 1 0   POINT (-73.9745152462626 40.76554155159081)
2959 2959 -73.9747963162162 40.7745023355775 10B-PM-1014-04 10B PM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0 avoided people POINT (-73.9747963162162 40.7745023355775)
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 133.037ms