2018_Central_Park_Squirrel_Census_-_Squirrel_Data

43 rows where Foraging = 1 and Primary Fur Color = "Black" sorted by Date

✎ View and edit SQL

This data as json, CSV (advanced)

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

Tail twitches ✖

  • 0 35
  • 1 8

Primary Fur Color ✖

  • Black · 43 ✖

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
546 546 -73.9547423290276 40.7899702628835 33I-PM-1006-09 33I PM 10062018 9 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9547423290276 40.7899702628835)
658 658 -73.9704575848926 40.7693499326095 7H-PM-1006-09 07H PM 10062018 9 Adult Black   Black+   Ground Plane FALSE by tree 0 0 0 1 1   0 0 0 1 0 1 0 1   POINT (-73.9704575848926 40.7693499326095)
872 872 -73.9551524422379 40.7910535596756 34H-PM-1006-01 34H PM 10062018 1 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9551524422379 40.7910535596756)
1486 1486 -73.9545807749923 40.790050753764895 33I-PM-1006-02 33I PM 10062018 2 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9545807749923 40.7900507537649)
1892 1892 -73.9745908987975 40.7655191512308 1G-AM-1006-03 01G AM 10062018 3 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9745908987975 40.7655191512308)
2329 2329 -73.9717515173863 40.7747999274418 11D-PM-1006-04 11D PM 10062018 4 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9717515173863 40.7747999274418)
2351 2351 -73.97458184501092 40.765449887362706 1G-AM-1006-01 01G AM 10062018 1 Adult Black   Black+   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9745818450109 40.7654498873627)
2427 2427 -73.97292974853309 40.767327854143794 4H-AM-1006-03 04H AM 10062018 3 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1 met #4 while foraging and briefly tussled 0 0 0 0 0 0 1 0   POINT (-73.9729297485331 40.7673278541438)
227 227 -73.95981553009129 40.7905887826983 32E-AM-1007-10 32E AM 10072018 10 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9598155300913 40.7905887826983)
2166 2166 -73.9711178122133 40.7672642958437 4I-PM-1007-01 04I PM 10072018 1 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9711178122133 40.76726429584371)
2651 2651 -73.9632993246327 40.78881995196561 29C-AM-1007-05 29C AM 10072018 5 Adult Black Gray Black+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9632993246327 40.7888199519656)
821 821 -73.959077668148 40.7926045823346 34D-AM-1008-02 34D AM 10082018 2 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.959077668148 40.7926045823346)
1101 1101 -73.95912925497 40.7925530280455 34D-AM-1008-01 34D AM 10082018 1 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0 staring at us POINT (-73.95912925497001 40.7925530280455)
2322 2322 -73.97236778547979 40.766731541087104 3H-AM-1008-04 03H AM 10082018 4 Adult Black   Black+   Above Ground 50   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9723677854798 40.7667315410871)
2395 2395 -73.9729603550254 40.7660215710657 3H-AM-1008-06 03H AM 10082018 6 Adult Black   Black+ beauty! Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 1   POINT (-73.9729603550254 40.7660215710657)
1066 1066 -73.9720174997123 40.774889426602705 11D-AM-1010-07 11D AM 10102018 7 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9720174997123 40.7748894266027)
1979 1979 -73.96127592913992 40.7930468323219 33B-AM-1010-03 33B AM 10102018 3 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9612759291399 40.7930468323219)
2999 2999 -73.972415182837 40.773080463452004 10E-AM-1010-02 10E AM 10102018 2 Adult Black Gray Black+Gray   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.972415182837 40.773080463452)
325 325 -73.96309908232429 40.788576428401605 28D-AM-1012-02 28D AM 10122018 2 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9630990823243 40.7885764284016)
1232 1232 -73.9589254878322 40.7914467650712 33E-PM-1012-09 33E PM 10122018 9 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9589254878322 40.7914467650712)
1473 1473 -73.9584064190878 40.7912992852442 33F-PM-1012-03 33F PM 10122018 3 Adult Black Gray Black+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9584064190878 40.7912992852442)
1959 1959 -73.97077370737709 40.780037346583796 17B-PM-1012-02 17B PM 10122018 2 Adult Black   Black+   Ground Plane FALSE   1 1 0 0 1 2/3 chasing each other 1 1 0 1 1 0 1 0   POINT (-73.9707737073771 40.7800373465838)
2638 2638 -73.9598973337711 40.793334636047796 34C-PM-1012-01 34C PM 10122018 1 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9598973337711 40.7933346360478)
481 481 -73.9714303315699 40.774593494770606 11E-AM-1013-04 11E AM 10132018 4 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1 burying 0 0 0 0 0 0 1 0   POINT (-73.9714303315699 40.7745934947706)
854 854 -73.95771130260559 40.7904332453456 32G-PM-1013-02 32G PM 10132018 2 Juvenile Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9577113026056 40.7904332453456)
2284 2284 -73.9730181306326 40.779460132242704 16A-AM-1013-02 16A AM 10132018 2 Adult Black   Black+   Above Ground     0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9730181306326 40.7794601322427)
2467 2467 -73.9755923256429 40.7672967972471 3F-PM-1013-02 03F PM 10132018 2 Adult Black Gray Black+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.97559232564292 40.7672967972471)
2549 2549 -73.972248505758 40.76590436930079 3I-PM-1013-01 03I PM 10132018 1 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.972248505758 40.765904369300806)
2817 2817 -73.9596445861554 40.79719486790071 38A-PM-1013-05 38A PM 10132018 5 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9596445861554 40.7971948679007)
473 473 -73.95701300171591 40.799602742862504 42B-AM-1014-02 42B AM 10142018 2 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9570130017159 40.7996027428625)
2572 2572 -73.9719901848577 40.7720525965356 9F-PM-1014-07 09F PM 10142018 7 Adult Black   Black+ !!! Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9719901848577 40.7720525965356)
2773 2773 -73.96259326649559 40.7885379477349 29D-AM-1014-01 29D AM 10142018 1 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9625932664956 40.7885379477349)
50 50 -73.96806350709491 40.779249873647 17E-AM-1017-05 17E AM 10172018 5 Adult Black   Black+   Above Ground 10 Branch 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9680635070949 40.779249873647)
770 770 -73.95977827620291 40.79207733767571 33D-AM-1017-07 33D AM 10172018 7 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 1 0 1 0 0 1 0   POINT (-73.9597782762029 40.7920773376757)
1057 1057 -73.9594406225891 40.7918533707789 33D-AM-1017-02 33D AM 10172018 2 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 0 0   POINT (-73.9594406225891 40.7918533707789)
1149 1149 -73.960237785199 40.7907831607574 32E-PM-1017-16 32E PM 10172018 16 Adult Black   Black+   Ground Plane FALSE rocky outcrop 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.960237785199 40.7907831607574)
2135 2135 -73.9596251284566 40.7916254797561 33D-AM-1017-05 33D AM 10172018 5 Adult Black   Black+   Above Ground 5   0 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9596251284566 40.7916254797561)
2192 2192 -73.9593410965431 40.7923134010383 33D-AM-1017-08 33D AM 10172018 8 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9593410965431 40.7923134010383)
182 182 -73.9691050656013 40.780813953822204 18C-PM-1018-01 18C PM 10182018 1   Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9691050656013 40.7808139538222)
691 691 -73.96959649834541 40.7802302192799 18C-PM-1018-08 18C PM 10182018 8 Juvenile Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9695964983454 40.7802302192799)
181 181 -73.9708775864433 40.772473633538 10F-PM-1019-12 10F PM 10192018 12 Adult Black White Black+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9708775864433 40.772473633538)
1026 1026 -73.9710951149579 40.772501245008 10F-PM-1019-04 10F PM 10192018 4 Adult Black   Black+   Ground Plane FALSE Behind fence, grass 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9710951149579 40.772501245008)
1833 1833 -73.962516494651 40.788476898990204 28D-PM-1019-02 28D PM 10192018 2 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.962516494651 40.7884768989902)

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