2018_Central_Park_Squirrel_Census_-_Squirrel_Data

32 rows where Eating = 0 and Highlight Fur Color = "Gray, White" sorted by Moans

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Location, Above Ground Sighter Measurement, Chasing, Climbing, Foraging, Kuks, Tail flags, Approaches, Indifferent, Runs from

Tail twitches ✖

  • 0 26
  • 1 6

Running ✖

  • 0 23
  • 1 9

Highlight Fur Color ✖

  • Gray, White · 32 ✖

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
26 26 -73.9649866016038 40.776492969445705 16I-AM-1008-01 16I AM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9649866016038 40.7764929694457)
87 87 -73.95414534658171 40.798216222376396 42E-PM-1012-06 42E PM 10122018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9541453465817 40.79821622237641)
150 150 -73.97634308293419 40.7686351097159 4D-PM-1008-11 04D PM 10082018 11 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3 on tree facing downward 0 1 0 0 0 chased #12 1 0 0 1 0 0 0 1   POINT (-73.9763430829342 40.7686351097159)
188 188 -73.9570528770427 40.7990973804149 41B-AM-1010-07 41B AM 10102018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 10   0 0 0 0 0   1 0 0 1 0 1 0 0 mad! POINT (-73.9570528770427 40.7990973804149)
194 194 -73.9764839973068 40.7691725326976 4D-PM-1008-06 04D PM 10082018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9764839973068 40.7691725326976)
233 233 -73.9568343093228 40.794940135088204 37E-PM-1006-04 37E PM 10062018 4 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0 doesn't see me POINT (-73.9568343093228 40.7949401350882)
249 249 -73.9786339295735 40.7684918638639 3C-PM-1008-02 03C PM 10082018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9786339295735 40.7684918638639)
458 458 -73.97357503529591 40.7694500333777 6F-PM-1008-06 06F PM 10082018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White White patches. Almost looks like fox squirrel       0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9735750352959 40.7694500333777)
715 715 -73.97720265726741 40.7691598773017 4D-PM-1008-14 04D PM 10082018 14 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9772026572674 40.7691598773017)
863 863 -73.97640160306659 40.7689894344251 4D-PM-1008-05 04D PM 10082018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9764016030666 40.7689894344251)
982 982 -73.9676424599715 40.777776610680704 16F-AM-1008-01 16F AM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE near fence 0 0 0 0 1   0 0 0 0 1 1 0 0   POINT (-73.9676424599715 40.7777766106807)
1121 1121 -73.9645060433292 40.7768322057794 16I-AM-1008-03 16I AM 10082018 3 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9645060433292 40.7768322057794)
1142 1142 -73.9765805609072 40.7692807820935 4D-PM-1008-07 04D PM 10082018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE hopped over fence and chased # 6 around tree & ran it to end of lawn 1 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9765805609072 40.7692807820935)
1287 1287 -73.9763236949008 40.7686815615335 4D-PM-1008-12 04D PM 10082018 12 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3   1 0 0 0 0 was chased by # 11 1 0 0 0 0 0 0 1   POINT (-73.9763236949008 40.7686815615335)
1384 1384 -73.97876087620051 40.7686062296462 3C-PM-1008-01 03C PM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3   0 0 0 0 0 walked between trees 0 0 0 0 0 0 1 0   POINT (-73.9787608762005 40.7686062296462)
1572 1572 -73.9540197079615 40.798039260982996 41E-PM-1013-03 41E PM 10132018 3 Adult Cinnamon Gray, White Cinnamon+Gray, White Gray on legs Above Ground 20   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9540197079615 40.798039260983)
1683 1683 -73.9790889008147 40.7676402781925 1C-PM-1013-01 01C PM 10132018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 1 0 0   POINT (-73.9790889008147 40.7676402781925)
1871 1871 -73.9748367344424 40.7693513000034 5E-PM-1012-06 05E PM 10122018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 10 oak tree at end of ramp from Chess House 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9748367344424 40.7693513000034)
1947 1947 -73.97471754195459 40.769282003087795 5E-PM-1012-05 05E PM 10122018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 1 0 0 begging POINT (-73.9747175419546 40.7692820030878)
2152 2152 -73.9686925781295 40.7705688673142 9I-PM-1010-05 09I PM 10102018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9686925781295 40.7705688673142)
2194 2194 -73.960898739757 40.7961393097144 37A-PM-1013-02 37A PM 10132018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.960898739757 40.7961393097144)
2330 2330 -73.9724618533895 40.7745021602455 11D-AM-1010-02 11D AM 10102018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1 walking 0 0 0 0 1 0 0 1   POINT (-73.9724618533895 40.7745021602455)
2516 2516 -73.96498236876509 40.7763395359636 16I-AM-1008-02 16I AM 10082018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 1   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9649823687651 40.7763395359636)
2574 2574 -73.978199543688 40.7695660563362 4C-PM-1010-17 04C PM 10102018 17 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE climbed up tree 1 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.978199543688 40.7695660563362)
2647 2647 -73.954499539822 40.7949716693686 38F-AM-1018-01 38F AM 10182018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.954499539822 40.7949716693686)
2735 2735 -73.97680969536471 40.7708185213129 5C-PM-1010-08 05C PM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9768096953647 40.7708185213129)
2787 2787 -73.9765306970303 40.769495687585895 4D-PM-1008-09 04D PM 10082018 9 Adult Cinnamon Gray, White Cinnamon+Gray, White         0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9765306970303 40.7694956875859)
2837 2837 -73.9772691210241 40.7690960712994 4D-PM-1008-13 04D PM 10082018 13 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9772691210241 40.7690960712994)
2895 2895 -73.9747873899653 40.77319452583271 9C-PM-1006-04 09C PM 10062018 4 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9747873899653 40.7731945258327)
2952 2952 -73.9763719445827 40.768955141333706 4D-PM-1008-04 04D PM 10082018 4 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9763719445827 40.7689551413337)
2965 2965 -73.9767389132988 40.7689323691424 4D-PM-1008-10 04D PM 10082018 10 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 6 climbed the fence & posed for a picture 0 0 1 0 1   0 0 0 0 0 1 0 0   POINT (-73.9767389132988 40.7689323691424)
2989 2989 -73.9643538221947 40.7917565604735 31A-PM-1017-01 31A PM 10172018 1 Juvenile Cinnamon Gray, White Cinnamon+Gray, White Gray lower back, Gray & Cinnamon selected as Primary with "lower back" written in next to Gray. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9643538221947 40.7917565604735)

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