2018_Central_Park_Squirrel_Census_-_Squirrel_Data

29 rows where Chasing = 1 and Date = 10062018

View and edit SQL

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

Tail twitches

  • 0 22
  • 1 7

Shift

Date

  • 10062018 · 29

Chasing

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
20 -73.9706105896967 40.769812482150705 7H-AM-1006-05 07H AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9706105896967 40.7698124821507)
230 -73.97314980648721 40.7659963196581 2H-AM-1006-02 02H AM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.9731498064872 40.7659963196581)
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)
352 -73.970540988328 40.769810306706205 7H-AM-1006-06 07H AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.970540988328 40.7698103067062)
360 -73.9672054610151 40.7876519923501 26A-PM-1006-05 26A PM 10062018 5 Adult Gray   Gray+   Above Ground 40   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9672054610151 40.7876519923501)
449 -73.9701335162984 40.772205101135704 10G-AM-1006-10 10G AM 10062018 10 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 1 0 0 0 0 0 0   POINT (-73.9701335162984 40.7722051011357)
471 -73.97072153948871 40.7727508149058 10G-AM-1006-05 10G AM 10062018 5 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0 chasing (#6) 1 0 0 0 0 0 0 0   POINT (-73.9707215394887 40.7727508149058)
503 -73.9598340783572 40.7915857030295 33D-PM-1006-02 33D PM 10062018 2   Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.95983407835722 40.7915857030295)
589 -73.97826438139 40.7717086090782 6A-AM-1006-04 06A AM 10062018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 1 0 0 0 curious POINT (-73.97826438139 40.7717086090782)
1004 -73.9670850805619 40.7833747810387 22C-PM-1006-01 22C PM 10062018 1 Juvenile Gray   Gray+   Ground Plane FALSE   1 1 0 0 0 for food 0 1 0 0 0 0 0 0   POINT (-73.9670850805619 40.7833747810387)
1016 -73.9691293546408 40.7703219076549 8I-AM-1006-11 08I AM 10062018 11 Adult Gray   Gray+   Above Ground 50 tree 0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9691293546408 40.77032190765491)
1172 -73.9706929270645 40.77278411194239 10G-AM-1006-06 10G AM 10062018 6 Juvenile Gray   Gray+ skinny tail Ground Plane FALSE   0 1 0 0 0 chasing (#5) 1 0 0 0 0 0 0 0   POINT (-73.9706929270645 40.7727841119424)
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)
1302 -73.9704024529864 40.772925606388895 10G-AM-1006-04 10G AM 10062018 4 Juvenile Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0 chasing (#3) 1 0 0 0 0 0 0 0   POINT (-73.9704024529864 40.7729256063889)
1535 -73.9703921271418 40.770027611531404 7H-PM-1006-06 07H PM 10062018 6 Adult Gray   Gray+   Above Ground 15   0 1 1 0 0 playing w/ #7 0 0 0 0 0 0 1 0   POINT (-73.9703921271418 40.770027611531404)
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)
1700 -73.965675791028 40.7887310058451 27B-PM-1006-02 27B PM 10062018 2 Adult Gray   Gray+   Ground Plane FALSE By large tree chasing #1 0 1 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.965675791028 40.7887310058451)
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)
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)
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)
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)
2298 -73.97553718499721 40.7733561233828 9C-PM-1006-02 09C PM 10062018 2 Adult Gray White Gray+White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9755371849972 40.7733561233828)
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)
2362 -73.9700263936574 40.769933509858106 7H-PM-1006-07 07H PM 10062018 7 Adult Gray   Gray+   Above Ground 15   0 1 1 0 0 playing w/ #6 0 0 0 0 0 0 1 0   POINT (-73.9700263936574 40.7699335098581)
2490 -73.9693876553956 40.7707232748402 8I-AM-1006-02 08I AM 10062018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9693876553956 40.7707232748402)
2542 -73.9754802138871 40.773300804411996 9C-PM-1006-03 09C PM 10062018 3 Adult Gray White Gray+White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9754802138871 40.773300804412)
2796 -73.96310890114121 40.789191946875 29C-PM-1006-02 29C PM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9631089011412 40.789191946875)
2839 -73.9672252136807 40.787650474321204 26A-PM-1006-04 26A PM 10062018 4 Adult Gray   Gray+   Above Ground 40   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9672252136807 40.7876504743212)
2918 -73.9745152462626 40.76554155159079 1G-AM-1006-04 01G AM 10062018 4 Adult Gray White Gray+White         0 1 0 0 1 collecting nest material 0 0 0 0 1 0 1 0   POINT (-73.9745152462626 40.76554155159081)

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