2018_Central_Park_Squirrel_Census_-_Squirrel_Data

29 rows where Date = 10062018 and Tail flags = 1

View and edit SQL

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Kuks, Approaches, Indifferent, Runs from

Tail twitches

  • 0 24
  • 1 5

Tail flags

Date

  • 10062018 · 29
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
15 -73.9674285955293 40.7829723919744 21C-PM-1006-01 21C PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0   0 0 0 1 1 0 0 0   POINT (-73.9674285955293 40.7829723919744)
78 -73.964474836001 40.7883840104749 28C-PM-1006-01 28C PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 gathering acorns 0 0 0 1 0 0 0 1 gnd to tree POINT (-73.964474836001 40.7883840104749)
90 -73.97871808707359 40.7715877863274 5A-AM-1006-05 05A AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE near 65th St arch 0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9787180870736 40.7715877863274)
133 -73.9664711607022 40.787896428768 26A-PM-1006-06 26A PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Tree 90th left 90th & 89 0 0 1 0 0   0 0 0 1 0 0 0 0 studying us looking for food POINT (-73.9664711607022 40.787896428768)
335 -73.97823514358521 40.7715896672335 6A-AM-1006-03 06A AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree 0 1 0 1 0   0 0 0 1 1 0 0 0   POINT (-73.9782351435852 40.7715896672335)
379 -73.9606817053484 40.7917320450401 32D-PM-1006-07 32D PM 10062018 7 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.9606817053484 40.7917320450401)
569 -73.9709040623777 40.7701163892686 7H-PM-1006-03 07H PM 10062018 3 Adult Gray   Gray+   Above Ground 8 tree 1 0 1 0 0   0 0 0 1 0 0 1 0   POINT (-73.9709040623777 40.7701163892686)
652 -73.95700561239529 40.787875606758206 30I-PM-1006-02 30I PM 10062018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9570056123953 40.7878756067582)
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)
663 -73.9766440589836 40.7682390282581 3E-AM-1006-02 03E AM 10062018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9766440589836 40.7682390282581)
730 -73.9607280801601 40.7901506706248 31D-PM-1006-01 31D PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 1 0 0 0 1   POINT (-73.9607280801601 40.7901506706248)
1019 -73.97042696309641 40.7722964640257 10G-AM-1006-09 10G AM 10062018 9 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9704269630964 40.7722964640257)
1048 -73.9782120139407 40.7717154468791 6A-AM-1006-05 06A AM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 tree 0 0 1 0 0   0 0 0 1 1 0 0 0 curious POINT (-73.9782120139407 40.7717154468791)
1201 -73.97828135384209 40.7715730368712 6A-AM-1006-02 06A AM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree 0 1 1 0 0   0 0 0 1 0 0 0 0   POINT (-73.9782813538421 40.7715730368712)
1230 -73.9790822606486 40.7714466633386 5A-AM-1006-03 05A AM 10062018 3 Juvenile Cinnamon   Cinnamon+   Above Ground 8   0 0 1 1 0   0 0 0 1 0 0 0 1   POINT (-73.9790822606486 40.7714466633386)
1523 -73.9673103881521 40.78742674096179 26A-PM-1006-01 26A PM 10062018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9673103881521 40.7874267409618)
1529 -73.9692401421068 40.7707128895661 8I-AM-1006-04 08I AM 10062018 4 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9692401421068 40.7707128895661)
1815 -73.96032682553171 40.7900154505092 31E-PM-1006-06 31E PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9603268255317 40.7900154505092)
1995 -73.9603366992925 40.7899612889539 31E-PM-1006-05 31E PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9603366992925 40.789961288953904)
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)
2142 -73.95985354257058 40.7915589343685 33D-PM-1006-01 33D PM 10062018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 1 0 0 0 hanging on fence 1 0 0 1 0 0 0 1   POINT (-73.9598535425706 40.7915589343685)
2363 -73.9690638424196 40.7713869295685 9H-AM-1006-06 09H AM 10062018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 1 0 1 0   POINT (-73.9690638424196 40.7713869295685)
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)
2425 -73.9791141532217 40.7714888835416 5A-AM-1006-04 05A AM 10062018 4 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9791141532217 40.77148888354161)
2433 -73.9706949930717 40.772362045852 10G-AM-1006-08 10G AM 10062018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 3   0 0 0 1 0   0 0 0 1 1 0 1 0   POINT (-73.9706949930717 40.772362045852)
2521 -73.976869549792 40.770698245472296 5C-AM-1006-04 05C AM 10062018 4 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 12 thin branch of tree 0 0 0 0 0 relaxing 0 0 0 1 0 0 1 0   POINT (-73.976869549792 40.7706982454723)
2547 -73.9743393747021 40.767634679832504 3F-AM-1006-12 03F AM 10062018 12 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9743393747021 40.7676346798325)
2583 -73.97696931406509 40.7684390015166 3D-AM-1006-01 03D AM 10062018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 9 up a tree 1 0 1 1 1 digging (?) 0 0 0 1 0 0 0 1 runs from (man led his dog into the area to chase squirrel) POINT (-73.9769693140651 40.7684390015166)
2928 -73.9767953468937 40.7676376977667 3E-AM-1006-03 03E AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 checkin' his stashes 0 0 0 1 0 1 0 1   POINT (-73.9767953468937 40.7676376977667)

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