2018_Central_Park_Squirrel_Census_-_Squirrel_Data

68 rows where Above Ground Sighter Measurement = "FALSE", Hectare Squirrel Number = 1, Highlight Fur Color = "White" and Tail twitches = 0

View and edit SQL

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

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
30 -73.96929432916109 40.776953610248796 15E-AM-1013-01 15E AM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9692943291611 40.7769536102488)
51 -73.9801666435401 40.7686905339212 2B-PM-1013-01 02B PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0 running (with nut) 0 0 0 0 0 0 0 0   POINT (-73.9801666435401 40.7686905339212)
143 -73.9661361310677 40.7787872561177 18G-PM-1013-01 18G PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1 burying 0 0 0 0 0 0 0 1   POINT (-73.9661361310677 40.7787872561177)
170 -73.95972059663241 40.7969409510133 38B-AM-1019-01 38B AM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9597205966324 40.7969409510133)
269 -73.9591400366159 40.7891708599318 31F-PM-1007-01 31F PM 10072018 1 Adult Gray White Gray+White white neck and belly Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9591400366159 40.7891708599318)
272 -73.9521950056404 40.794937340844996 39H-PM-1013-01 39H PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0 ran away when a human approached with a dog POINT (-73.9521950056404 40.794937340845)
365 -73.9576035072364 40.7966120824816 38C-AM-1019-01 38C AM 10192018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (lawnmower) POINT (-73.9576035072364 40.7966120824816)
382 -73.9735946835545 40.7724155751282 8E-PM-1008-01 08E PM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE by tree trunk base 0 0 0 1 0   0 0 0 0 0 1 0 0 eating food being thrown at it by a mom & baby POINT (-73.9735946835545 40.7724155751282)
383 -73.9588358879692 40.7912631913057 33E-PM-1012-01 33E PM 10122018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9588358879692 40.7912631913057)
386 -73.95503513809571 40.7974681522214 40E-AM-1014-01 40E AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9550351380957 40.7974681522214)
410 -73.9584024936392 40.785149170194394 27I-PM-1020-01 27I PM 10202018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 1 runs from (us) POINT (-73.9584024936392 40.7851491701944)
465 -73.9683041099256 40.786265230008205 24A-AM-1014-01 24A AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0 freezes POINT (-73.9683041099256 40.7862652300082)
467 -73.95797241199429 40.794870990001606 37D-AM-1018-01 37D AM 10182018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9579724119943 40.7948709900016)
520 -73.97494466297059 40.77206596960671 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.9749446629706 40.7720659696067)
549 -73.9549082481152 40.7933537584624 36G-PM-1012-01 36G PM 10122018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 crossing east drive 0 0 0 0 0 0 0 0   POINT (-73.9549082481152 40.7933537584624)
643 -73.976730206737 40.773709213913996 8A-PM-1014-01 08A PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 0   1 0 0 0 0 0 0 1 runs from (goes up a tree) POINT (-73.976730206737 40.773709213914)
699 -73.95046935442251 40.797225436004 42H-AM-1019-01 42H AM 10192018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9504693544225 40.797225436004)
710 -73.9695569897042 40.771206214717104 9H-PM-1018-01 09H PM 10182018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.96955698970422 40.7712062147171)
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)
817 -73.9540022445432 40.7979409854977 41E-AM-1007-01 41E AM 10072018 1 Adult Gray White Gray+White white haunches Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9540022445432 40.7979409854977)
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 -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)
855 -73.9808247660048 40.76894088312871 2A-PM-1019-01 02A PM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 runs from 0 0 0 1 0 0 0 1   POINT (-73.9808247660048 40.7689408831287)
927 -73.9609885686834 40.796110864031895 37A-PM-1013-01 37A PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.96098856868342 40.7961108640319)
931 -73.97859484138829 40.7718908026758 6A-PM-1012-01 06A PM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9785948413883 40.7718908026758)
965 -73.97083010709241 40.7820200927465 19A-PM-1013-01 19A PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 planting acorns 0 0 0 0 0 0 1 0   POINT (-73.9708301070924 40.7820200927465)
1027 -73.9640016324897 40.7921759097124 32A-PM-1013-01 32A PM 10132018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9640016324897 40.7921759097124)
1107 -73.95307395621309 40.7932034409546 37H-PM-1006-01 37H PM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1 from voice POINT (-73.95307395621312 40.7932034409546)
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)
1184 -73.9807982742225 40.7678795985389 1B-PM-1019-01 01B PM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9807982742225 40.7678795985389)
1264 -73.97853537753821 40.7674923683184 2C-PM-1013-01 02C PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9785353775382 40.7674923683184)
1305 -73.9569324958684 40.7877748374259 30I-PM-1006-01 30I PM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 sitting there 0 0 0 0 0 0 0 1   POINT (-73.9569324958684 40.78777483742591)
1308 -73.95603964408441 40.7945080361909 37E-AM-1013-01 37E AM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9560396440844 40.7945080361909)
1318 -73.97149072356758 40.774058386152 11E-PM-1012-01 11E PM 10122018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9714907235676 40.774058386152)
1340 -73.97730836162592 40.7710535931636 6B-PM-1017-01 06B PM 10172018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 1 0 0   POINT (-73.9773083616259 40.7710535931636)
1435 -73.9582534432858 40.7917772296796 34F-PM-1012-01 34F PM 10122018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9582534432858 40.7917772296796)
1478 -73.9676370985166 40.7869888639434 25A-AM-1013-01 25A AM 10132018 1   Gray White Gray+White White Belly Ground Plane FALSE   0 0 0 1 0 staring at me 0 0 0 0 0 0 1 0   POINT (-73.96763709851662 40.7869888639434)
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)
1588 -73.9693209851947 40.7707450042769 8I-AM-1006-01 08I AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   1 0 0 0 0 0 1 0   POINT (-73.9693209851947 40.7707450042769)
1590 -73.9610388059192 40.793952935840004 34B-PM-1007-01 34B PM 10072018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9610388059192 40.79395293584)
1650 -73.97624942397191 40.775017530671605 10A-AM-1006-01 10A AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE near Strawberry Fields 0 0 0 1 0 eating (a peanut) 0 0 0 0 0 1 0 0   POINT (-73.9762494239719 40.7750175306716)
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)
1671 -73.9611399573659 40.781130706026 22I-AM-1007-01 22I AM 10072018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9611399573659 40.781130706026005)
1685 -73.96788229832741 40.7802960985637 18E-PM-1006-01 18E PM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9678822983274 40.7802960985637)
1689 -73.9547031549299 40.797886753932204 41E-PM-1013-01 41E PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9547031549299 40.7978867539322)
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)
1983 -73.97841448676391 40.771817766751106 6A-AM-1006-01 06A AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 0 0   POINT (-73.9784144867639 40.7718177667511)
2044 -73.97715523261991 40.7706917595308 5C-AM-1006-01 05C AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 1 0 0   0 0 0 1 0 1 0 0   POINT (-73.9771552326199 40.7706917595308)
2089 -73.9535980341677 40.7981186822179 42E-PM-1012-01 42E PM 10122018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9535980341677 40.7981186822179)
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)
2111 -73.968446056806 40.785824818871 24A-PM-1007-01 24A PM 10072018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.96844605680602 40.785824818871)
2116 -73.9801562527339 40.76872673271129 2B-AM-1010-01 02B AM 10102018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9801562527339 40.7687267327113)
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)
2125 -73.9687933229572 40.7788600242549 17E-PM-1018-01 17E PM 10182018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9687933229572 40.7788600242549)
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)
2283 -73.9628982772673 40.788430480338604 28D-PM-1019-01 28D PM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9628982772673 40.7884304803386)
2415 -73.9683598086625 40.7811150451315 19D-PM-1008-01 19D PM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9683598086625 40.7811150451315)
2438 -73.969532160039 40.7822616641357 20B-PM-1013-01 20B PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.969532160039 40.7822616641357)
2526 -73.96464954504991 40.7791203699027 19H-PM-1008-01 19H PM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9646495450499 40.7791203699027)
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)
2605 -73.97368963630059 40.767763086262605 4G-AM-1006-01 04G AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9736896363006 40.7677630862626)
2691 -73.9564599077179 40.7965185098695 39D-PM-1012-01 39D PM 10122018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9564599077179 40.7965185098695)
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)
2764 -73.9692660977515 40.7830532310766 21B-PM-1017-01 21B PM 10172018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0 paused to look at me POINT (-73.9692660977515 40.7830532310766)
2794 -73.9712187890707 40.7750640173134 12E-PM-1018-01 12E PM 10182018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 1 0 0   1 0 0 1 0 0 0 1   POINT (-73.9712187890707 40.7750640173134)
2843 -73.97147871782009 40.779804947074496 16B-PM-1017-01 16B PM 10172018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9714787178201 40.7798049470745)
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)
2997 -73.96197353854829 40.7944667974974 35A-PM-1013-01 35A PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9619735385483 40.7944667974974)

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