2018_Central_Park_Squirrel_Census_-_Squirrel_Data

19 rows where Age = "Juvenile" and Tail flags = 1 sorted by Hectare Squirrel Number

✎ View and edit SQL

This data as json, CSV (advanced)

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

Tail twitches ✖

  • 0 19

Tail flags ✖

Age ✖

  • Juvenile · 19 ✖
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
706 706 -73.95701325709341 40.793201415908705 35F-PM-1012-01 35F PM 10122018 1 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 1 0 0 1 1   POINT (-73.9570132570934 40.7932014159087)
1523 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)
2134 2134 -73.9614373639552 40.7945051962914 35B-PM-1013-01 35B PM 10132018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0 did not notice dog sitting a few yards away (10-20 ft) 0 0 0 1 0 0 1 0   POINT (-73.9614373639552 40.7945051962914)
2794 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)
1415 1415 -73.9678561384348 40.77828773978221 16E-PM-1018-02 16E PM 10182018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 0 0 gets distance from people but then continues to chase #1 POINT (-73.9678561384348 40.7782877397822)
1531 1531 -73.9630381400083 40.7807571827321 21H-PM-1018-02 21H PM 10182018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9630381400083 40.7807571827321)
2038 2038 -73.98035621370491 40.7685780990634 2B-AM-1010-02 02B AM 10102018 2 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9803562137049 40.7685780990634)
784 784 -73.9649658099293 40.782326236907394 22F-PM-1014-03 22F PM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9649658099293 40.7823262369074)
1230 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)
1836 1836 -73.9751056714758 40.7732060035215 8C-PM-1013-03 08C PM 10132018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.9751056714758 40.7732060035215)
2397 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)
2992 2992 -73.9746063250438 40.7687654196811 4F-PM-1013-03 04F PM 10132018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9746063250438 40.7687654196811)
2425 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)
887 887 -73.9635028497015 40.7928207574906 32A-PM-1013-05 32A PM 10132018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9635028497015 40.7928207574906)
928 928 -73.96704295859901 40.778437071937105 17F-AM-1007-05 17F AM 10072018 5 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.967042958599 40.7784370719371)
1403 1403 -73.9761632586697 40.7741085606149 9B-PM-1013-05 09B PM 10132018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9761632586697 40.7741085606149)
1198 1198 -73.9762187733662 40.7739282973004 9B-PM-1013-08 09B PM 10132018 8 Juvenile Cinnamon Black, White Cinnamon+Black, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9762187733662 40.7739282973004)
2672 2672 -73.9614599022015 40.7945181285991 35A-PM-1013-11 35A PM 10132018 11 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9614599022015 40.7945181285991)
2547 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)

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