2018_Central_Park_Squirrel_Census_-_Squirrel_Data

44 rows where Date = 10102018 and Hectare Squirrel Number = 3 sorted by Moans

View and edit SQL

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

Eating

  • 0 31
  • 1 13

Hectare Squirrel Number

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
3 -73.9768311751004 40.766717807255795 2E-AM-1010-03 02E AM 10102018 3 Adult Cinnamon   Cinnamon+   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9768311751004 40.76671780725581)
12 -73.96836135162249 40.772590884749896 11H-AM-1010-03 11H AM 10102018 3 Adult Cinnamon White Cinnamon+White         0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9683613516225 40.7725908847499)
16 -73.97225001968441 40.7742879599026 11D-AM-1010-03 11D AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   0 0 1 0 0 grooming 0 0 0 0 0 0 1 0   POINT (-73.9722500196844 40.7742879599026)
123 -73.9671147090087 40.7772624641112 16G-AM-1010-03 16G AM 10102018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 was hanging out w/ #2 until i showed up 1 0 0 0 0 0 0 1   POINT (-73.9671147090087 40.7772624641112)
124 -73.9588660250232 40.7982597947515 40A-AM-1010-03 40A AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE bottom of great hill 0 0 0 1 1   0 0 0 1 0 0 1 1 dog chased POINT (-73.9588660250232 40.7982597947515)
140 -73.97686527856641 40.768483816820705 3D-PM-1010-03 03D PM 10102018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.97686527856641 40.7684838168207)
297 -73.9685604013735 40.7773439909065 15F-PM-1010-03 15F PM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9685604013735 40.7773439909065)
307 -73.9683965841952 40.771867984897796 10I-AM-1010-03 10I AM 10102018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9683965841952 40.7718679848978)
391 -73.97908754803579 40.767610478065706 2C-AM-1010-03 02C AM 10102018 3 Adult Black Gray Black+Gray   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9790875480358 40.7676104780657)
396 -73.9669206605745 40.7748155701122 13H-PM-1010-03 13H PM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE in glen 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9669206605745 40.7748155701122)
414 -73.9721899838568 40.776151904565104 13C-AM-1010-03 13C AM 10102018 3 Adult Gray   Gray+   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9721899838568 40.7761519045651)
483 -73.9789952029637 40.7697758333099 4B-AM-1010-03 04B AM 10102018 3 Juvenile Gray White Gray+White   Above Ground 25   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9789952029637 40.7697758333099)
530 -73.9696360756453 40.7786545659072 16D-PM-1010-03 16D PM 10102018 3 Adult Gray   Gray+   Above Ground 18   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9696360756453 40.7786545659072)
554 -73.97335194581801 40.768814796037 5G-PM-1010-03 05G PM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.973351945818 40.768814796037)
752 -73.9768617690725 40.7741877060705 9A-PM-1010-03 09A PM 10102018 3   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0 froze - standing on hind legs for ~10 seconds then scampered off POINT (-73.97686176907251 40.7741877060705)
828 -73.9545101041865 40.790382361678205 34I-PM-1010-03 34I PM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE in the playground. 1 0 0 0 1 with some nuts in the mouth 0 0 0 0 0 0 0 0   POINT (-73.9545101041865 40.7903823616782)
893 -73.9799311173259 40.768557699755895 2B-AM-1010-03 02B AM 10102018 3 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9799311173259 40.7685576997559)
1253 -73.9527227282134 40.7935061484064 37I-AM-1010-03 37I AM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 in tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9527227282134 40.7935061484064)
1268 -73.96239842629359 40.7913900453449 31C-PM-1010-03 31C PM 10102018 3 Adult Gray White Gray+White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9623984262936 40.7913900453449)
1448 -73.9772810073685 40.7693577540392 4C-PM-1010-03 04C PM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9772810073685 40.7693577540392)
1548 -73.9790044506465 40.7689469479245 3B-AM-1010-03 03B AM 10102018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0 chasing #2 0 0 0 0 0 0 0 1   POINT (-73.9790044506465 40.7689469479245)
1627 -73.9594391759139 40.784115697669 26I-PM-1010-03 26I PM 10102018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White black in tail Above Ground 15 tree 0 0 1 1 1   0 0 0 0 1 0 1 0   POINT (-73.9594391759139 40.784115697669)
1672 -73.9640989602986 40.789929543926505 29B-PM-1010-03 29B PM 10102018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9640989602986 40.7899295439265)
1773 -73.9611126813593 40.7943113021522 35B-AM-1010-03 35B AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9611126813593 40.7943113021522)
1824 -73.9617250054003 40.7925390432044 33B-PM-1010-03 33B PM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9617250054003 40.7925390432044)
1829 -73.9746965894947 40.766435172430896 2G-AM-1010-03 02G AM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9746965894947 40.7664351724309)
1890 -73.97877230828071 40.7713655754004 5A-PM-1010-03 05A PM 10102018 3 Adult Gray   Gray+   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9787723082807 40.7713655754004)
1979 -73.96127592913992 40.7930468323219 33B-AM-1010-03 33B AM 10102018 3 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9612759291399 40.7930468323219)
2076 -73.9712636931964 40.77998098773 17B-AM-1010-03 17B AM 10102018 3 Adult Gray   Gray+   Above Ground 25   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9712636931964 40.77998098773)
2127 -73.9562442622553 40.7957285542564 38E-AM-1010-03 38E AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9562442622553 40.7957285542564)
2172 -73.9642900903774 40.791701716884205 31A-AM-1010-03 31A AM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9642900903774 40.7917017168842)
2256 -73.9720050204318 40.769941909416794 7G-AM-1010-03 07G AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9720050204318 40.7699419094168)
2259 -73.975565603566 40.7738462518304 9B-AM-1010-03 09B AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   1 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.975565603566 40.7738462518304)
2379 -73.97118651343641 40.7785039981892 15C-AM-1010-03 15C AM 10102018 3 Adult Gray   Gray+   Above Ground 6   0 0 0 1 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9711865134364 40.7785039981892)
2392 -73.9578981223015 40.798996775435796 41B-AM-1010-03 41B AM 10102018 3 Adult     +   Above Ground 60   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9578981223015 40.7989967754358)
2471 -73.964274290774 40.779531955602295 19H-AM-1010-03 19H AM 10102018 3 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0 ran from human w/ dog POINT (-73.964274290774 40.7795319556023)
2476 -73.9710843362124 40.7679739601336 5I-AM-1010-03 05I AM 10102018 3 Adult Gray   Gray+   Above Ground 3   0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9710843362124 40.7679739601336)
2573 -73.9810149147578 40.7683925377714 2A-AM-1010-03 02A AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 on trunk 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9810149147578 40.7683925377714)
2620 -73.97718000981308 40.7708863131336 5C-PM-1010-03 05C PM 10102018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9771800098131 40.7708863131336)
2631 -73.9690080105286 40.7710230515054 9I-PM-1010-03 09I PM 10102018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White         0 0 0 0 1   0 0 0 0 0 0 1 1   POINT (-73.9690080105286 40.7710230515054)
2912 -73.9632164738341 40.7921270121312 32B-PM-1010-03 32B PM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9632164738341 40.7921270121312)
2914 -73.9722053355548 40.7662094993614 3I-AM-1010-03 03I AM 10102018 3 Adult Gray   Gray+   Above Ground 50   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9722053355548 40.7662094993614)
2946 -73.974515099169 40.770065079988605 6E-PM-1010-03 06E PM 10102018 3 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees 0 1 0 1 0 chasing #4 0 0 0 0 0 0 1 0   POINT (-73.974515099169 40.770065079988605)
2957 -73.97473131521521 40.7653888351839 1G-PM-1010-03 01G PM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9747313152152 40.7653888351839)

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