2018_Central_Park_Squirrel_Census_-_Squirrel_Data

24 rows where Hectare = "13E" sorted by Combination of Primary and Highlight Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Eating, Foraging, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Hectare Squirrel Number ✖

Hectare ✖

  • 13E · 24 ✖
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
2801 2801 -73.9697665830132 40.7759094917104 13E-PM-1008-08 13E PM 10082018 8 Juvenile Cinnamon Black, White Cinnamon+Black, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9697665830132 40.7759094917104)
376 376 -73.9698817079185 40.775832262771104 13E-PM-1008-10 13E PM 10082018 10 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.9698817079185 40.7758322627711)
129 129 -73.9705092958892 40.7761092972965 13E-PM-1008-07 13E PM 10082018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9705092958892 40.7761092972965)
806 806 -73.97047575554599 40.7763348062134 13E-AM-1017-02 13E AM 10172018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 begging (came one yard away from me and stood there) 0 0 0 0 0 1 0 0   POINT (-73.970475755546 40.7763348062134)
973 973 -73.97059770598621 40.7760413182276 13E-AM-1017-09 13E AM 10172018 9 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9705977059862 40.776041318227605)
1792 1792 -73.97057045274809 40.7762853012151 13E-AM-1017-06 13E AM 10172018 6 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9705704527481 40.7762853012151)
1941 1941 -73.97047902632241 40.776227064566605 13E-AM-1017-01 13E AM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE in middle of path 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9704790263224 40.7762270645666)
2414 2414 -73.97081754618041 40.7759228565501 13E-AM-1017-10 13E AM 10172018 10 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9708175461804 40.7759228565501)
2964 2964 -73.9703604542938 40.776269022329394 13E-AM-1017-04 13E AM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9703604542938 40.7762690223294)
11 11 -73.9702676472613 40.7762126854894 13E-AM-1017-05 13E AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   on tree stump 0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9702676472613 40.7762126854894)
350 350 -73.9707471099503 40.7759255131734 13E-AM-1017-08 13E AM 10172018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9707471099503 40.7759255131734)
683 683 -73.97076836215841 40.775981556612294 13E-AM-1017-11 13E AM 10172018 11 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   on/in log 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9707683621584 40.77598155661231)
796 796 -73.9706641770728 40.77592292137621 13E-AM-1017-12 13E AM 10172018 12 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9706641770728 40.7759229213762)
1237 1237 -73.9705370795538 40.7761725434851 13E-PM-1008-04 13E PM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Gray selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0 he took 2 steps then turned and stared at me POINT (-73.9705370795538 40.7761725434851)
2649 2649 -73.9706428641753 40.7762933936464 13E-AM-1017-07 13E AM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9706428641753 40.7762933936464)
2932 2932 -73.9705837974358 40.775849484967296 13E-AM-1017-13 13E AM 10172018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE on rock 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.97058379743581 40.7758494849673)
448 448 -73.9706929341294 40.7760473872395 13E-PM-1008-06 13E PM 10082018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9706929341294 40.77604738723951)
689 689 -73.970595381455 40.7762912142457 13E-PM-1008-05 13E PM 10082018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.970595381455 40.7762912142457)
952 952 -73.9699763667769 40.775706073102604 13E-PM-1008-11 13E PM 10082018 11 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9699763667769 40.775706073102604)
1028 1028 -73.97070123456609 40.7758938984066 13E-PM-1008-03 13E PM 10082018 3 Juvenile Gray White Gray+White   Above Ground 10 hanging upside down to get a nut 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9707012345661 40.7758938984066)
1030 1030 -73.9697526733133 40.7759529849808 13E-PM-1008-09 13E PM 10082018 9 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9697526733133 40.7759529849808)
1430 1430 -73.970804709441 40.7758611111219 13E-PM-1008-01 13E PM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.970804709441 40.7758611111219)
1502 1502 -73.97052548010001 40.7763606494306 13E-AM-1017-03 13E AM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   1 0 0 0 0 0 0 1 acknowledges POINT (-73.9705254801 40.7763606494306)
2185 2185 -73.9707571364399 40.7758859812524 13E-PM-1008-02 13E PM 10082018 2 Adult Gray White Gray+White   Above Ground 10   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9707571364399 40.7758859812524)

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