2018_Central_Park_Squirrel_Census_-_Squirrel_Data

40 rows where Hectare Squirrel Number = 3, Running = 1 and Shift = "AM" sorted by Quaas

View and edit SQL

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

Eating

  • 0 34
  • 1 6

Shift

Running

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
53 -73.95849706432129 40.7982886348696 40B-AM-1019-03 40B AM 10192018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 1 1 0 0   POINT (-73.9584970643213 40.7982886348696)
107 -73.9521110154872 40.7978449143313 42G-AM-1018-03 42G AM 10182018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 stop to look at me—then ran 0 0 0 0 0 0 0 1   POINT (-73.9521110154872 40.7978449143313)
222 -73.97702735535249 40.7732399463626 8A-AM-1013-03 08A AM 10132018 3 Juvenile     +   Above Ground 3 fence 1 1 1 1 0 playing tag together 0 0 0 0 0 1 0 0   POINT (-73.9770273553525 40.7732399463626)
257 -73.9773317054464 40.7684035996758 3D-AM-1006-03 03D AM 10062018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE on top [of] a big rock/boulder in the area 1 0 1 0 0 climbing (rock) 0 0 0 0 0 1 0 0 approaches (slightly),wary of humans POINT (-73.9773317054464 40.76840359967581)
452 -73.960300330029 40.795347587186896 36B-AM-1013-03 36B AM 10132018 3   Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.960300330029 40.7953475871869)
454 -73.9752793195744 40.7733960128931 9C-AM-1006-03 09C AM 10062018 3 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9752793195744 40.7733960128931)
480 -73.9641293283734 40.7907654006019 30B-AM-1007-03 30B AM 10072018 3 Adult Gray   Gray+   Above Ground 30   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9641293283734 40.7907654006019)
612 -73.9629420113622 40.789133072717 29C-AM-1007-03 29C AM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9629420113622 40.789133072717)
716 -73.9745427984089 40.7691848214817 5E-AM-1008-03 05E AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9745427984089 40.7691848214817)
757 -73.9783185278595 40.7724861675504 7A-AM-1006-03 07A AM 10062018 3 Adult Gray   Gray+ 3/4 length tail, hair loss Above Ground 20 in trees, then to ground 1 0 1 0 0 jumping 0 0 0 0 0 0 1 0   POINT (-73.9783185278595 40.7724861675504)
786 -73.953296595236 40.7927644594513 36I-AM-1017-03 36I AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon Cinnamon stripe on back Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.953296595236 40.7927644594513)
852 -73.9609704650925 40.7938786854735 34B-AM-1013-03 34B AM 10132018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   1 0 1 0 0 hopping 0 0 0 0 0 1 0 1   POINT (-73.9609704650925 40.7938786854735)
898 -73.95428280532559 40.794179732035495 37G-AM-1014-03 37G AM 10142018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9542828053256 40.7941797320355)
961 -73.9731457102903 40.7660255393205 2H-AM-1006-03 02H AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9731457102903 40.7660255393205)
963 -73.9621066718851 40.7942427079733 34A-AM-1012-03 34A AM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9621066718851 40.7942427079733)
1021 -73.97186968288 40.778926988884 15B-AM-1014-03 15B AM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1 running (from a dog) 0 0 0 0 0 0 1 0   POINT (-73.97186968288 40.778926988884)
1328 -73.9765758043111 40.771380315403206 6C-AM-1007-03 06C AM 10072018 3 Adult Gray White Gray+White   Above Ground 8 another tree 1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9765758043111 40.7713803154032)
1418 -73.9673924060436 40.7788781851716 17F-AM-1007-03 17F AM 10072018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9673924060436 40.7788781851716)
1420 -73.9647605121306 40.780396153151706 20G-AM-1018-03 20G AM 10182018 3 Adult Gray   Gray+   Above Ground 12 in tree 1 0 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9647605121306 40.7803961531517)
1516 -73.9625383795297 40.7883862331728 28D-AM-1012-03 28D AM 10122018 3 Adult Black   Black+   Above Ground 30   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9625383795297 40.7883862331728)
1715 -73.97457091090558 40.7672225695415 3G-AM-1008-03 03G AM 10082018 3 Adult Gray   Gray+   Above Ground 40   1 0 1 0 0 in tree 0 0 0 0 0 0 1 0   POINT (-73.9745709109056 40.7672225695415)
1748 -73.955710327539 40.797451079756705 40D-AM-1013-03 40D AM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.955710327539 40.7974510797567)
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)
1968 -73.9699088881236 40.775277835162605 13F-AM-1007-03 13F AM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9699088881236 40.7752778351626)
1988 -73.957138794884 40.7985389822719 40C-AM-1017-03 40C AM 10172018 3 Adult Gray White Gray+White         1 1 1 0 0 chasing (#4),digging 0 0 0 0 1 0 1 0   POINT (-73.957138794884 40.7985389822719)
2041 -73.9651796685091 40.7785578267586 18G-AM-1014-03 18G AM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9651796685091 40.7785578267586)
2091 -73.96761128642859 40.7772792086081 16F-AM-1008-03 16F AM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE road 1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9676112864286 40.7772792086081)
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)
2205 -73.9594986107981 40.7840083040604 25I-AM-1012-03 25I AM 10122018 3 Adult Cinnamon   Cinnamon+   Above Ground 8 on turn, see map 1 1 0 1 0   0 0 0 0 1 1 0 0   POINT (-73.9594986107981 40.7840083040604)
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)
2268 -73.9590191655172 40.7926139425111 34D-AM-1008-03 34D AM 10082018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9590191655172 40.7926139425111)
2407 -73.95557243517759 40.7967602498249 39E-AM-1018-03 39E AM 10182018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9555724351776 40.7967602498249)
2413 -73.959701727877 40.790660026971004 32E-AM-1007-03 32E AM 10072018 3 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.959701727877 40.790660026971)
2630 -73.965019827314 40.775986429132296 15I-AM-1008-03 15I AM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.965019827314 40.7759864291323)
2687 -73.9550235589287 40.7951312356844 38F-AM-1018-03 38F AM 10182018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9550235589287 40.7951312356844)
2694 -73.969628583287 40.770406779793205 8H-AM-1017-03 08H AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 fence 1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.969628583287 40.7704067797932)
2871 -73.9777124331985 40.7704051056666 5B-AM-1008-03 05B AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9777124331985 40.7704051056666)
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)
2948 -73.9545225586988 40.7956074663106 39F-AM-1014-03 39F AM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9545225586988 40.7956074663106)

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