2018_Central_Park_Squirrel_Census_-_Squirrel_Data

29 rows where Eating = 0, Hectare Squirrel Number = 7 and Highlight Fur Color = "Cinnamon" sorted by Kuks

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Foraging, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Highlight Fur Color ✖

  • Cinnamon · 29 ✖

Hectare Squirrel Number ✖

Eating ✖

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
284 284 -73.9547336666137 40.7938937756332 37G-PM-1007-07 37G PM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9547336666137 40.7938937756332)
312 312 -73.958356112357 40.796014459571 38C-AM-1019-07 38C AM 10192018 7 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.958356112357 40.796014459571)
327 327 -73.95343062916791 40.7959052073753 39G-PM-1013-07 39G PM 10132018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9534306291679 40.7959052073753)
547 547 -73.9559677963727 40.7951124076946 38E-AM-1010-07 38E AM 10102018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 branches 1 1 0 0 0 chasing and being chased by #6 0 0 0 0 1 0 0 1   POINT (-73.9559677963727 40.7951124076946)
985 985 -73.9681722244801 40.783559826281 22B-PM-1014-07 22B PM 10142018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9681722244801 40.783559826281)
1039 1039 -73.9584646000078 40.7983984665955 40B-PM-1014-07 40B PM 10142018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9584646000078 40.7983984665955)
1059 1059 -73.97494575169209 40.7676712372245 3F-PM-1013-07 03F PM 10132018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9749457516921 40.7676712372245)
1090 1090 -73.967767372181 40.784702631615 23B-PM-1012-07 23B PM 10122018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.967767372181 40.784702631615)
1105 1105 -73.9811218801005 40.7684406206185 1A-PM-1014-07 01A PM 10142018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9811218801005 40.7684406206185)
1209 1209 -73.97631591531379 40.7705785330431 5C-AM-1006-07 05C AM 10062018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9763159153138 40.7705785330431)
1338 1338 -73.9716624574422 40.776203711010105 13D-PM-1018-07 13D PM 10182018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   1 0 1 0 0 scratching 0 0 0 0 0 0 1 0   POINT (-73.9716624574422 40.7762037110101)
1484 1484 -73.9716736557408 40.7749333494336 12E-AM-1017-07 12E AM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9716736557408 40.7749333494336)
1544 1544 -73.9642111283068 40.77777139853271 18I-PM-1007-07 18I PM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9642111283068 40.7777713985327)
1656 1656 -73.9557399927792 40.7971563708988 40D-PM-1013-07 40D PM 10132018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9557399927792 40.7971563708988)
1738 1738 -73.967975586222 40.77356830443129 12H-PM-1007-07 12H PM 10072018 7   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE grass field 0 0 0 0 1   0 0 0 0 0 0 0 1 humans POINT (-73.967975586222 40.7735683044313)
1753 1753 -73.9733437449715 40.778240154836205 14B-PM-1014-07 14B PM 10142018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9733437449715 40.7782401548362)
1861 1861 -73.97555625268109 40.7678821029525 3E-AM-1006-07 03E AM 10062018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 burying nuts 0 0 0 0 0 0 0 0   POINT (-73.9755562526811 40.7678821029525)
1862 1862 -73.97648512317541 40.771573686286104 6C-AM-1007-07 06C AM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0 ambling 0 0 0 0 0 1 0 1 trucks POINT (-73.9764851231754 40.7715736862861)
1897 1897 -73.97107389601 40.7723265810536 10F-PM-1019-07 10F PM 10192018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 Same tree (as #6) 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.97107389601 40.7723265810536)
2217 2217 -73.9652746477521 40.7809326848536 20F-PM-1007-07 20F PM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon cinnamon tail Ground Plane FALSE   1 0 0 0 0 watching 0 0 0 1 0 0 0 1   POINT (-73.96527464775211 40.7809326848536)
2372 2372 -73.9724879969884 40.771098202397 8F-PM-1012-07 08F PM 10122018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 17   0 0 1 0 0 gathering 0 0 0 0 0 0 0 0   POINT (-73.9724879969884 40.771098202397)
2513 2513 -73.9767590273554 40.7717561807266 6B-PM-1017-07 06B PM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9767590273554 40.7717561807266)
2623 2623 -73.9604482901468 40.7898646293603 31E-PM-1006-07 31E PM 10062018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9604482901468 40.7898646293603)
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)
2759 2759 -73.9543373703455 40.7943889087123 38G-PM-1020-07 38G PM 10202018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 1   0 1 0 1 0 0 1 0   POINT (-73.9543373703455 40.7943889087123)
2812 2812 -73.963209639301 40.7926138443715 32A-PM-1013-07 32A PM 10132018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.963209639301 40.7926138443715)
2831 2831 -73.9753585157592 40.7698398607941 5E-AM-1008-07 05E AM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 on fence 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9753585157592 40.7698398607941)
853 853 -73.9534509627885 40.7921084224711 36I-AM-1017-07 36I AM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 1 chasing (#8),scratching 1 0 0 0 1 0 1 0   POINT (-73.9534509627885 40.7921084224711)
1262 1262 -73.9683345414813 40.7779016280345 16E-PM-1018-07 16E PM 10182018 7 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 0 0   1 0 0 0 0 0 1 0   POINT (-73.9683345414813 40.7779016280345)

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