2018_Central_Park_Squirrel_Census_-_Squirrel_Data

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

✎ View and edit SQL

This data as json, CSV (advanced)

Quaas ✖

  • 0 40
  • 1 1

Highlight Fur Color ✖

  • White · 41 ✖

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
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)

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