2018_Central_Park_Squirrel_Census_-_Squirrel_Data

174 rows where Eating = 0 and Hectare Squirrel Number = 6 sorted by Date

✎ View and edit SQL

This data as json, CSV (advanced)

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
1273 1273 -73.95589438800509 40.7971535141896 40D-PM-1013-06 40D PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9558943880051 40.7971535141896)
1520 1520 -73.968021326951 40.7778807692445 16F-PM-1013-06 16F PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Big rock in meadow 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.968021326951 40.7778807692445)
1599 1599 -73.9782603348665 40.7705790257951 5B-PM-1013-06 05B PM 10132018 6 Adult Gray   Gray+   Above Ground 5   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9782603348665 40.7705790257951)
1699 1699 -73.9706968708903 40.7821499135828 19A-PM-1013-06 19A PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9706968708903 40.7821499135828)
2242 2242 -73.9565824187667 40.797312050952 40D-AM-1013-06 40D AM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   1 0 1 0 1   1 0 0 0 1 0 0 1   POINT (-73.9565824187667 40.797312050952)
2357 2357 -73.96323010348829 40.7925707244111 32A-PM-1013-06 32A PM 10132018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9632301034883 40.7925707244111)
2358 2358 -73.9788379085607 40.7683896583055 2C-PM-1013-06 02C PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 cleaning face & tail 0 0 0 0 1 1 0 0   POINT (-73.9788379085607 40.7683896583055)
2434 2434 -73.9545912098958 40.7948301813102 38F-PM-1013-06 38F PM 10132018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9545912098958 40.7948301813102)
2505 2505 -73.9762974698771 40.7740076116964 9B-PM-1013-06 09B PM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9762974698771 40.7740076116964)
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)
2562 2562 -73.9615643742864 40.7944678447843 35B-PM-1013-06 35B PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 1 0 0 chased by dog #2 1 0 0 0 0 0 0 1 runs from (dog) POINT (-73.9615643742864 40.7944678447843)
2661 2661 -73.9693841004072 40.770414865829395 8I-PM-1013-06 08I PM 10132018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9693841004072 40.7704148658294)
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)
2855 2855 -73.9690832219322 40.782343340985996 20B-PM-1013-06 20B PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.96908322193221 40.782343340986)
47 47 -73.9640032826529 40.782030982544796 22F-PM-1014-06 22F PM 10142018 6 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9640032826529 40.7820309825448)
81 81 -73.9578237168359 40.7980959471034 40B-PM-1014-06 40B PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9578237168359 40.7980959471034)
378 378 -73.95848354168459 40.7978213396921 39B-PM-1014-06 39B PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9584835416846 40.7978213396921)
492 492 -73.97030108562241 40.7701983575511 8H-PM-1014-06 08H PM 10142018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9703010856224 40.7701983575511)
494 494 -73.958837574505 40.7985003987784 40A-PM-1014-06 40A PM 10142018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.958837574505 40.7985003987784)
576 576 -73.96220476777009 40.7945126358465 35A-AM-1014-06 35A AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9622047677701 40.7945126358465)
594 594 -73.9727488640736 40.7781916780621 14B-PM-1014-06 14B PM 10142018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 watching me 0 0 0 0 0 1 0 0 skittish POINT (-73.9727488640736 40.7781916780621)
726 726 -73.973305698325 40.778382331129606 14A-PM-1014-06 14A PM 10142018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 9   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.973305698325 40.7783823311296)
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)
1128 1128 -73.9638599044346 40.7809288795308 21G-AM-1014-06 21G AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9638599044346 40.7809288795308)
1194 1194 -73.96874625660729 40.783898987005 22B-PM-1014-06 22B PM 10142018 6   Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 0 0 0 digging 0 0 0 0 0 0 0 0   POINT (-73.9687462566073 40.783898987005)
1314 1314 -73.980919134781 40.7683772453336 1A-PM-1014-06 01A PM 10142018 6 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   1 0 0 0 0 0 0 1   POINT (-73.980919134781 40.7683772453336)
1424 1424 -73.9709722223794 40.7767329646325 14D-AM-1014-06 14D AM 10142018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9709722223794 40.7767329646325)
1694 1694 -73.97301963428741 40.766022437401 3H-PM-1014-06 03H PM 10142018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9730196342874 40.766022437401)
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)
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)
1964 1964 -73.9622859117854 40.788616918696604 29D-AM-1014-06 29D AM 10142018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9622859117854 40.7886169186966)
2052 2052 -73.97464934414141 40.7750478734868 11B-PM-1014-06 11B PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 0 0 0 cleaning 0 0 0 0 0 0 1 0   POINT (-73.9746493441414 40.7750478734868)
2276 2276 -73.9611985783336 40.791604823372005 32C-AM-1014-06 32C AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9611985783336 40.791604823372)
2281 2281 -73.96915208260279 40.77171040377829 10H-AM-1014-06 10H AM 10142018 6   Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9691520826028 40.7717104037783)
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)
2844 2844 -73.9578840941242 40.7955586232429 37D-PM-1014-06 37D PM 10142018 6 Adult Gray   Gray+   Above Ground 25   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9578840941242 40.7955586232429)
2892 2892 -73.9688070760806 40.777968829417205 16E-AM-1014-06 16E AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 1   POINT (-73.9688070760806 40.777968829417205)
61 61 -73.9797084866613 40.7698885241349 3A-PM-1017-06 03A PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9797084866613 40.7698885241349)
282 282 -73.97015758910979 40.773097328242294 10G-PM-1017-06 10G PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9701575891098 40.7730973282423)
300 300 -73.9528149779809 40.7924984810637 36I-AM-1017-06 36I AM 10172018 6 Adult Gray Black Gray+Black Darker than others Above Ground 10 Running down tree 1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9528149779809 40.7924984810637)
573 573 -73.9674688433583 40.7789728381912 17E-AM-1017-06 17E AM 10172018 6 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9674688433583 40.7789728381912)
682 682 -73.9651828383592 40.780282094386294 19F-PM-1017-06 19F PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 1 0 0   0 0 0 0 1 1 0 0   POINT (-73.9651828383592 40.7802820943863)
713 713 -73.956200809768 40.798181446265 40C-AM-1017-06 40C AM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.956200809768 40.798181446265)
763 763 -73.9767455430709 40.7717866237826 6B-PM-1017-06 06B PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9767455430709 40.7717866237826)
1792 1792 -73.97057045274809 40.7762853012151 13E-AM-1017-06 13E AM 10172018 6 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9705704527481 40.7762853012151)
1886 1886 -73.956806913988 40.7987736900857 41C-AM-1017-06 41C AM 10172018 6 Adult Gray   Gray+   Above Ground 4   0 0 1 0 0   1 0 0 0 0 0 1 0   POINT (-73.956806913988 40.7987736900857)
2206 2206 -73.95944460183459 40.7917800352042 33D-AM-1017-06 33D AM 10172018 6 Adult Black   Black+   Above Ground 10   0 0 1 0 0   1 1 0 0 0 0 0 1 runs from (ran into hole in tree trunk) POINT (-73.9594446018346 40.7917800352042)
2697 2697 -73.9710674928906 40.7778757544025 15D-PM-1017-06 15D PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 walking 0 0 0 0 0 0 0 0 stopped and watched me before slowly moving on POINT (-73.9710674928906 40.7778757544025)
2974 2974 -73.9575791421589 40.7959934459432 38D-AM-1017-06 38D AM 10172018 6 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9575791421589 40.7959934459432)
67 67 -73.968381325559 40.7780143443779 16E-PM-1018-06 16E PM 10182018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE On a rock 0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.968381325559 40.7780143443779)
217 217 -73.9712327308512 40.7748702909218 12E-PM-1018-06 12E PM 10182018 6 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9712327308512 40.7748702909218)
620 620 -73.9655905300923 40.775261463802295 14I-PM-1018-06 14I PM 10182018 6 Adult Cinnamon Black Cinnamon+Black   Above Ground 2   1 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9655905300923 40.7752614638023)
987 987 -73.96498278073409 40.7817322832767 21F-AM-1018-06 21F AM 10182018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9649827807341 40.7817322832767)
1133 1133 -73.9712550584322 40.7764273475386 13D-PM-1018-06 13D PM 10182018 6 Adult Gray White Gray+White   Above Ground 10   0 0 1 0 0 cleaning 0 0 0 0 0 0 1 0   POINT (-73.9712550584322 40.7764273475386)
1454 1454 -73.9753818829907 40.76978409861629 5D-PM-1018-06 05D PM 10182018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9753818829907 40.7697840986163)
1530 1530 -73.96893059787509 40.781815249626604 19C-PM-1018-06 19C PM 10182018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 Climbed fence 1 0 1 0 0 climbing (fence) 0 0 0 0 0 0 1 0   POINT (-73.9689305978751 40.7818152496266)
2374 2374 -73.9551370586201 40.7946465469021 38F-AM-1018-06 38F AM 10182018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 hopped away 0 0 0 0 0 0 0 1   POINT (-73.95513705862011 40.7946465469021)
2577 2577 -73.9597048490102 40.7955846466241 37B-AM-1018-06 37B AM 10182018 6 Adult Gray   Gray+   Above Ground 1   0 0 1 0 0   0 1 0 0 0 0 0 1   POINT (-73.9597048490102 40.7955846466241)
2676 2676 -73.9692849074642 40.7708755098145 9H-PM-1018-06 09H PM 10182018 6 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9692849074642 40.7708755098145)
2765 2765 -73.971525123573 40.770368535984204 7G-PM-1018-06 07G PM 10182018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 grooming 0 0 0 0 0 0 0 0   POINT (-73.971525123573 40.7703685359842)
2772 2772 -73.9677368646039 40.782155096483706 20C-PM-1018-06 20C PM 10182018 6 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.96773686460392 40.782155096483706)
693 693 -73.969353372175 40.7838247422369 21A-AM-1019-06 21A AM 10192018 6 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.969353372175 40.7838247422369)
737 737 -73.97111769994709 40.7724278547281 10F-PM-1019-06 10F PM 10192018 6 Adult Gray White Gray+White   Above Ground 10 Different tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9711176999471 40.7724278547281)
1524 1524 -73.97259615083159 40.7795720444974 16A-PM-1019-06 16A PM 10192018 6 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9725961508316 40.7795720444974)
1540 1540 -73.957710975899 40.79840556140471 40B-AM-1019-06 40B AM 10192018 6 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.957710975899 40.7984055614047)
2079 2079 -73.96430251719141 40.790570391517 30B-PM-1019-06 30B PM 10192018 6 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 1   POINT (-73.9643025171914 40.790570391517)
2168 2168 -73.95823634371351 40.7987752300505 40B-AM-1019-06 40B AM 10192018 6 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9582363437135 40.7987752300505)
2527 2527 -73.9675697600155 40.776679741446294 15G-PM-1019-06 15G PM 10192018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 scratching! 0 0 0 0 0 0 0 0   POINT (-73.9675697600155 40.7766797414463)
2588 2588 -73.95810074370941 40.795940311272204 38C-AM-1019-06 38C AM 10192018 6 Adult Gray   Gray+   Above Ground 23   0 0 1 0 0   1 0 0 1 0 0 1 0   POINT (-73.9581007437094 40.7959403112722)
2684 2684 -73.9809688694074 40.7688535974878 2A-PM-1019-06 02A PM 10192018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9809688694074 40.7688535974878)
477 477 -73.97014812002979 40.7751110354034 12F-AM-1020-06 12F AM 10202018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9701481200298 40.7751110354034)
1077 1077 -73.9541837143178 40.7944340477396 38G-PM-1020-06 38G PM 10202018 6 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 1 0 0 0 0 0 1   POINT (-73.9541837143178 40.7944340477396)
1629 1629 -73.9759428006237 40.7715081817329 7C-PM-1020-06 07C PM 10202018 6 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 1 0 0 0 0 0 0   POINT (-73.9759428006237 40.7715081817329)
2642 2642 -73.97514547259979 40.770291361572 6D-PM-1020-06 06D PM 10202018 6 Adult Gray White Gray+White   Ground Plane FALSE by carousel 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9751454725998 40.770291361572006)

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