2018_Central_Park_Squirrel_Census_-_Squirrel_Data

172 rows where Foraging = 0, Highlight Fur Color = "White" and Indifferent = 0 sorted by Primary Fur Color

✎ View and edit SQL

This data as json, CSV (advanced)

Above Ground Sighter Measurement ✖

Approaches ✖

  • 0 69
  • 1 3

Highlight Fur Color ✖

  • White · 72 ✖

Foraging ✖

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
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)
1374 1374 -73.9653739273979 40.788976209696706 28B-PM-1010-02 28B PM 10102018 2 Adult Gray White Gray+White   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9653739273979 40.7889762096967)
1381 1381 -73.9586077039567 40.796189647707706 38C-AM-1019-10 38C AM 10192018 10 Adult Gray White Gray+White   Above Ground 20   1 0 1 1 0   1 0 0 0 1 0 0 1   POINT (-73.9586077039567 40.7961896477077)
1395 1395 -73.9710801547498 40.7760872452093 13D-AM-1014-03 13D AM 10142018 3 Juvenile Gray White Gray+White   Above Ground 2   0 1 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9710801547498 40.7760872452093)
1410 1410 -73.95879132892291 40.7961707624534 38C-AM-1019-11 38C AM 10192018 11 Adult Gray White Gray+White   Above Ground 20   1 0 1 1 0   1 0 0 0 1 0 0 1   POINT (-73.9587913289229 40.7961707624534)
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)
1414 1414 -73.9580513096783 40.79909641532 41B-AM-1010-02 41B AM 10102018 2 Adult Gray White Gray+White   Above Ground 16   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9580513096783 40.79909641532)
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)
1461 1461 -73.95692690934399 40.7965323262487 39D-PM-1012-03 39D PM 10122018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.956926909344 40.7965323262487)
1465 1465 -73.9720289863666 40.7763749561607 13C-PM-1019-03 13C PM 10192018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.97202898636661 40.7763749561607)
1466 1466 -73.96511776576759 40.7812408103825 20F-PM-1007-05 20F PM 10072018 5 Juvenile Gray White Gray+White white tail Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9651177657676 40.781240810382506)
1489 1489 -73.9501762527462 40.797553408607705 42H-PM-1014-05 42H PM 10142018 5 Adult Gray White Gray+White   Above Ground 15   1 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9501762527462 40.7975534086077)
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)
1510 1510 -73.9655670884957 40.7763728890554 16H-PM-1014-03 16H PM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0 followed man across bridge POINT (-73.9655670884957 40.7763728890554)
1534 1534 -73.9695226023739 40.7797527775804 17D-AM-1008-01 17D AM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9695226023739 40.7797527775804)
1587 1587 -73.9805517765469 40.7683044693163 2B-PM-1013-05 02B PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 1 0 0 climbing fence! 0 0 0 0 0 0 0 0 snuck into bike cart! POINT (-73.9805517765469 40.7683044693163)
1644 1644 -73.9734654671008 40.7715988711659 8E-PM-1008-06 08E PM 10082018 6 Adult Gray White Gray+White   Ground Plane FALSE 5, 6, 7 all at same tree trunk base 0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9734654671008 40.7715988711659)
1707 1707 -73.96045242711669 40.7956624328733 36B-AM-1013-01 36B AM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9604524271167 40.7956624328733)
1758 1758 -73.9581241870185 40.7961057536141 38C-AM-1019-05 38C AM 10192018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9581241870185 40.7961057536141)
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)
1803 1803 -73.9588076804698 40.7912942607296 33E-AM-1014-06 33E AM 10142018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9588076804698 40.7912942607296)
1805 1805 -73.9590328527128 40.791221441757706 33E-PM-1012-06 33E PM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 playing 0 0 0 0 0 0 0 0   POINT (-73.9590328527128 40.7912214417577)
1814 1814 -73.97223594012421 40.7702891474555 7G-AM-1010-07 07G AM 10102018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9722359401242 40.7702891474555)
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)
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)
1852 1852 -73.9792161469158 40.767928543625295 2C-PM-1013-10 02C PM 10132018 10 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9792161469158 40.7679285436253)
1915 1915 -73.9797112925048 40.76880467784721 2B-PM-1013-09 02B PM 10132018 9 Adult Gray White Gray+White   Above Ground 30   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9797112925048 40.7688046778472)
1956 1956 -73.98089749771201 40.7690578709841 2A-PM-1019-02 02A PM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 0   POINT (-73.980897497712 40.7690578709841)
1987 1987 -73.9573692542155 40.7989252908321 41B-PM-1014-03 41B PM 10142018 3 Adult Gray White Gray+White   Above Ground 28   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9573692542155 40.7989252908321)
1999 1999 -73.95498609472341 40.79115503283089 34H-PM-1006-07 34H PM 10062018 7 Juvenile Gray White Gray+White white belly Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9549860947234 40.7911550328309)
2002 2002 -73.9581706950566 40.790632139726895 32F-AM-1012-05 32F AM 10122018 5 Adult Gray White Gray+White   Above Ground 10   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9581706950566 40.7906321397269)
2042 2042 -73.9800896621713 40.7684379810317 2B-PM-1013-03 02B PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9800896621713 40.7684379810317)
2051 2051 -73.9544808708211 40.7906575852286 34I-AM-1012-02 34I AM 10122018 2 Adult Gray White Gray+White Short tail Ground Plane FALSE   0 0 0 0 0 hiding 0 0 0 0 0 0 0 1   POINT (-73.9544808708211 40.7906575852286)
2084 2084 -73.9567255763265 40.7936331899263 36F-AM-1017-05 36F AM 10172018 5 Adult Gray White Gray+White   Above Ground 8   0 0 0 0 0 staying very still to avoid two very curious dogs on the ground 0 0 0 0 0 0 0 0 petrified,frozen (tail over its back,frozen) POINT (-73.9567255763265 40.7936331899263)
2087 2087 -73.956502663005 40.788160908881004 30I-PM-1006-05 30I PM 10062018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.956502663005 40.788160908881)
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)
2123 2123 -73.959874668294 40.7907004233491 32E-AM-1007-09 32E AM 10072018 9 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.959874668294 40.7907004233491)
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)
2214 2214 -73.9583688637255 40.791388958496 33E-PM-1012-08 33E PM 10122018 8 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9583688637255 40.791388958496)
2231 2231 -73.95454276114769 40.793035381744104 36G-PM-1012-02 36G PM 10122018 2 Adult Gray White Gray+White   Above Ground 10   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9545427611477 40.7930353817441)
2235 2235 -73.9748522796455 40.771958662100296 7D-PM-1010-01 07D PM 10102018 1 Adult Gray White Gray+White   Ground Plane FALSE outside fenced hectare 1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9748522796455 40.7719586621003)
2249 2249 -73.9785709201168 40.7674391934208 2C-PM-1013-02 02C PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9785709201168 40.7674391934208)
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)
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)
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)
2394 2394 -73.97858295460459 40.7719652299132 6A-PM-1012-02 06A PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9785829546046 40.7719652299132)
2397 2397 -73.9704592500888 40.772962887933005 10G-AM-1006-03 10G AM 10062018 3 Juvenile Gray White Gray+White tuft on butt Above Ground 10   0 0 1 0 0   0 0 0 1 0 0 0 1   POINT (-73.9704592500888 40.772962887933)
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)
2444 2444 -73.966590487009 40.780246905289104 19E-PM-1018-02 19E PM 10182018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 1 0 0   0 0 0 1 0 0 0 0   POINT (-73.96659048700901 40.7802469052891)
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)
2519 2519 -73.9589475065438 40.7934846881536 35D-PM-1013-06 35D PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9589475065438 40.7934846881536)
2528 2528 -73.96765297807241 40.7823206990549 21D-PM-1008-03 21D PM 10082018 3 Adult Gray White Gray+White   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9676529780724 40.7823206990549)
2551 2551 -73.970138810251 40.770579297644 8H-PM-1014-02 08H PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0 froze & watched me,then went back to eating POINT (-73.970138810251 40.770579297644)
2617 2617 -73.9564228238736 40.7936908887644 36F-PM-1012-06 36F PM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9564228238736 40.7936908887644)
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)
2628 2628 -73.9770439076963 40.7685720141731 3D-PM-1010-13 03D PM 10102018 13 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9770439076963 40.7685720141731)
2659 2659 -73.95536034380208 40.7985282963244 41D-PM-1014-05 41D PM 10142018 5 Adult Gray White Gray+White   Above Ground 12   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9553603438021 40.7985282963244)
2692 2692 -73.98016364007441 40.769019205592606 2A-AM-1010-09 02A AM 10102018 9 Adult Gray White Gray+White   Above Ground   climbing in bush 0 0 1 0 0 hopping & flipping around. this one was very energetic & jumping aorund 0 0 0 0 1 0 0 0 climbed a foot up a tree and watched me POINT (-73.9801636400744 40.7690192055926)
2730 2730 -73.96535757586871 40.78053399533721 20F-PM-1007-12 20F PM 10072018 12 Adult Gray White Gray+White   Above Ground 20 in tree 0 0 1 1 0   0 0 0 0 0 0 0 0   POINT (-73.9653575758687 40.7805339953372)
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)
2766 2766 -73.95516398474659 40.790858199891 34H-PM-1006-03 34H PM 10062018 3   Gray White Gray+White white belly Ground Plane FALSE Under Tupelo Tree 0 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.9551639847466 40.790858199891)
2767 2767 -73.9751806727197 40.7671940332258 3F-PM-1013-05 03F PM 10132018 5 Adult Gray White Gray+White   Above Ground 13   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.97518067271972 40.7671940332258)
2774 2774 -73.9705409446299 40.7764608087703 14E-PM-1017-03 14E PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9705409446299 40.7764608087703)
2811 2811 -73.97568897660891 40.7676078308589 3F-AM-1006-14 03F AM 10062018 14 Adult Gray White Gray+White   Above Ground 12   1 0 1 0 0 running from dog 0 0 0 0 0 0 0 1   POINT (-73.9756889766089 40.7676078308589)
2815 2815 -73.97473113123941 40.76773197250439 3F-PM-1013-06 03F PM 10132018 6 Adult Gray White Gray+White   Above Ground 19   0 0 1 0 0   0 1 0 0 0 0 0 1   POINT (-73.97473113123941 40.7677319725044)
2865 2865 -73.98028424040159 40.767825738497706 1B-PM-1019-03 01B PM 10192018 3 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.98028424040162 40.7678257384977)
2868 2868 -73.9653873284496 40.7804699882574 20F-PM-1007-11 20F PM 10072018 11 Adult Gray White Gray+White   Above Ground 10 in tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9653873284496 40.7804699882574)
2926 2926 -73.9714653576023 40.77174001395021 9F-AM-1013-03 09F AM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9714653576023 40.7717400139502)
2950 2950 -73.9790980124501 40.7685934093915 2B-PM-1013-08 02B PM 10132018 8 Adult Gray White Gray+White   Above Ground 15   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9790980124501 40.7685934093915)
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)

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