2018_Central_Park_Squirrel_Census_-_Squirrel_Data

31 rows where Date = 10142018, Hectare Squirrel Number = 4 and Location = "Ground Plane" sorted by Climbing

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Eating, Foraging, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Location ✖

  • Ground Plane · 31 ✖

Hectare Squirrel Number ✖

Date ✖

  • 10142018 · 31 ✖
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
108 108 -73.9574809028248 40.7950013620207 37D-PM-1014-04 37D PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 1 chasing (a chipmunk) 0 0 0 0 0 0 0 1   POINT (-73.9574809028248 40.7950013620207)
338 338 -73.9765595553183 40.7748455340432 10A-PM-1014-04 10A PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9765595553183 40.7748455340432)
445 445 -73.97140573271591 40.7720375135272 9F-PM-1014-04 09F PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9714057327159 40.7720375135272)
459 459 -73.9624546917649 40.7888234959792 29D-AM-1014-04 29D AM 10142018 4 Juvenile Gray   Gray+   Ground Plane FALSE Rock a 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9624546917649 40.78882349597921)
499 499 -73.96572880550109 40.776458003628704 16H-PM-1014-04 16H PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9657288055011 40.7764580036287)
541 541 -73.9617612388703 40.7952875954297 35A-AM-1014-04 35A AM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9617612388703 40.7952875954297)
626 626 -73.97050538215771 40.7787503220242 16C-AM-1014-04 16C AM 10142018 4 Adult Gray Black Gray+Black   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9705053821577 40.7787503220242)
709 709 -73.9519387881692 40.7936273636929 38I-PM-1014-04 38I PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9519387881692 40.7936273636929)
823 823 -73.954595058342 40.7956567934304 39F-AM-1014-04 39F AM 10142018 4 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.954595058342 40.7956567934304)
842 842 -73.9645147011741 40.777256683379896 17I-AM-1014-04 17I AM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 1 0   POINT (-73.9645147011741 40.7772566833799)
959 959 -73.97461330580771 40.7760646554109 11B-PM-1014-04 11B PM 10142018 4   Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 jumping 0 0 0 0 0 0 0 0   POINT (-73.9746133058077 40.776064655410906)
1005 1005 -73.95582687317709 40.7952074193788 38E-PM-1014-04 38E PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE THICK UNDERGROWTH 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9558268731771 40.7952074193788)
1036 1036 -73.9709207551033 40.7767932008037 14D-AM-1014-04 14D AM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9709207551033 40.7767932008037)
1177 1177 -73.98078982247259 40.768215817511 1A-PM-1014-04 01A PM 10142018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9807898224726 40.768215817511)
1223 1223 -73.95912985511109 40.7919612446005 33E-AM-1014-04 33E AM 10142018 4 Adult Black Cinnamon, White Black+Cinnamon, White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9591298551111 40.7919612446005)
1453 1453 -73.9555856074105 40.7969457685677 40E-AM-1014-04 40E AM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE on rocks/bushy rocks 1 0 0 0 0 hiding from bird 0 1 0 0 1 0 1 0   POINT (-73.9555856074105 40.79694576856771)
1639 1639 -73.9736800575584 40.778306973575795 14A-PM-1014-04 14A PM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0 chasing (#3) 0 0 0 0 1 0 1 0   POINT (-73.9736800575584 40.7783069735758)
1752 1752 -73.9561091686663 40.798146304742495 41D-AM-1014-04 41D AM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9561091686663 40.7981463047425)
2027 2027 -73.964449990389 40.7830023160643 22F-PM-1014-04 22F PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.964449990389 40.7830023160643)
2059 2059 -73.9710026704697 40.776105276462104 13D-AM-1014-04 13D AM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9710026704697 40.7761052764621)
2270 2270 -73.9703732649257 40.77019793771029 8H-PM-1014-04 08H PM 10142018 4 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.97037326492571 40.7701979377103)
2279 2279 -73.9586085858962 40.7990326758282 40A-PM-1014-04 40A PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (ran from path to bushes) POINT (-73.9586085858962 40.7990326758282)
2325 2325 -73.9728360875598 40.7660637295671 3H-PM-1014-04 03H PM 10142018 4 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9728360875598 40.7660637295671)
2618 2618 -73.95795157569 40.7961254697958 38C-PM-1014-04 38C PM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 0   0 0 0 1 0 0 0 1   POINT (-73.95795157569 40.7961254697958)
2641 2641 -73.96155167034941 40.790521938835894 31D-AM-1014-04 31D AM 10142018 4 Juvenile Gray   Gray+   Ground Plane FALSE Open ground 1 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9615516703494 40.7905219388359)
2738 2738 -73.9691801791373 40.770927235357206 9I-AM-1014-04 09I AM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9691801791373 40.7709272353572)
2753 2753 -73.96810908249779 40.783827583032796 22B-PM-1014-04 22B PM 10142018 4 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9681090824978 40.7838275830328)
2809 2809 -73.9686756254868 40.777745910265104 16E-AM-1014-04 16E AM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9686756254868 40.7777459102651)
2832 2832 -73.958607566971 40.7983695505584 40B-PM-1014-04 40B PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.958607566971 40.7983695505584)
2951 2951 -73.9742986032935 40.7770454318226 13A-PM-1014-04 13A PM 10142018 4   Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9742986032935 40.7770454318226)
2959 2959 -73.9747963162162 40.7745023355775 10B-PM-1014-04 10B PM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0 avoided people POINT (-73.9747963162162 40.7745023355775)

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.615ms