2018_Central_Park_Squirrel_Census_-_Squirrel_Data

30 rows where Date = 10062018, Hectare Squirrel Number = 1 and Indifferent = 1 sorted by Highlight Fur Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail twitches

Indifferent ✖

Hectare Squirrel Number ✖

Date ✖

  • 10062018 · 30 ✖
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
55 55 -73.9568802149818 40.7972399133816 39C-PM-1006-01 39C PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9568802149818 40.7972399133816)
71 71 -73.9576245992455 40.7873862510001 29H-PM-1006-01 29H PM 10062018 1 Adult Gray   Gray+   Above Ground 50   0 0 1 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9576245992455 40.7873862510001)
326 326 -73.9699843570636 40.7729480440312 10G-AM-1006-01 10G AM 10062018 1 Adult Gray   Gray+   Above Ground 80   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.96998435706361 40.7729480440312)
754 754 -73.9563203089105 40.7906275357726 33G-PM-1006-01 33G PM 10062018 1 Juvenile Gray   Gray+   Above Ground 2   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9563203089105 40.7906275357726)
836 836 -73.975086415444 40.7671990131313 3F-AM-1006-01 03F AM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE just to right when enter sanctuary 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.975086415444 40.7671990131313)
1193 1193 -73.9731880656287 40.766002618615495 2H-AM-1006-01 02H AM 10062018 1 Adult Black   Black+   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9731880656287 40.7660026186155)
1766 1766 -73.972757765574 40.76542855100671 2I-AM-1006-01 02I AM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.972757765574 40.7654285510067)
2046 2046 -73.9706414863639 40.7732754837144 11F-PM-1006-01 11F PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9706414863639 40.7732754837144)
2351 2351 -73.97458184501092 40.765449887362706 1G-AM-1006-01 01G AM 10062018 1 Adult Black   Black+   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9745818450109 40.7654498873627)
2726 2726 -73.9734206435334 40.7657854684194 2H-PM-1006-01 02H PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9734206435334 40.7657854684194)
2755 2755 -73.9712022111028 40.767250436826295 4I-AM-1006-01 04I AM 10062018 1 Adult Black   Black+   Above Ground 3 On top of park lamp 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9712022111028 40.7672504368263)
2911 2911 -73.9793923984874 40.770847547458295 5A-AM-1006-01 05A AM 10062018 1 Adult Gray   Gray+   Above Ground 10 Oak tree near rock outcropping 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.97939239848742 40.7708475474583)
2958 2958 -73.9541748083177 40.795275844289705 39F-PM-1006-01 39F PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 carrying leaves 0 0 0 0 0 0 1 0   POINT (-73.9541748083177 40.7952758442897)
673 673 -73.958417813526 40.792730121447605 34E-PM-1006-01 34E PM 10062018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Above Ground 20   0 0 0 0 0 sitting and watching on a tree 0 0 0 0 0 0 1 0   POINT (-73.958417813526 40.7927301214476)
160 160 -73.9756015005821 40.7670090327736 2F-AM-1006-01 02F AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE walking along path 0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.97560150058212 40.7670090327736)
333 333 -73.9667560049684 40.7882333830729 27A-PM-1006-01 27A PM 10062018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   on a tree 0 0 0 1 1 walking up & down branches 0 0 0 0 0 0 1 0   POINT (-73.9667560049684 40.7882333830729)
775 775 -73.95957577926829 40.7899242643847 31E-PM-1006-01 31E PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE under bushes 0 0 0 0 1   0 1 0 0 0 0 1 0   POINT (-73.9595757792683 40.7899242643847)
1503 1503 -73.97321932906308 40.7748791447746 11D-PM-1006-01 11D PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9732193290631 40.7748791447746)
1628 1628 -73.97136652496141 40.76971786480021 7H-AM-1006-01 07H AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 nut in mouth 0 0 0 0 0 0 1 0   POINT (-73.9713665249614 40.7697178648002)
1703 1703 -73.956998502609 40.7948117428147 37E-PM-1006-01 37E PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.956998502609 40.7948117428147)
2336 2336 -73.95312632141359 40.7965675089932 40F-PM-1006-01 40F PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9531263214136 40.7965675089932)
2559 2559 -73.95723834787741 40.787685738072206 30H-PM-1006-01 30H PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9572383478774 40.7876857380722)
2650 2650 -73.9538251716292 40.7919360198175 35I-PM-1006-01 35I PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9538251716292 40.7919360198175)
2709 2709 -73.97750689157151 40.7664424394736 1E-AM-1006-01 01E AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9775068915715 40.7664424394736)
2792 2792 -73.97237364945971 40.766950134329704 4H-AM-1006-01 04H AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9723736494597 40.7669501343297)
2008 2008 -73.95243640874371 40.792846505434 37I-PM-1006-01 37I PM 10062018 1 Adult Cinnamon Gray, Black Cinnamon+Gray, Black   Above Ground 5   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9524364087437 40.792846505434)
1213 1213 -73.9693202078293 40.771043472925 9H-AM-1006-01 09H AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9693202078293 40.771043472925)
1588 1588 -73.9693209851947 40.7707450042769 8I-AM-1006-01 08I AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   1 0 0 0 0 0 1 0   POINT (-73.9693209851947 40.7707450042769)
2221 2221 -73.9771847728747 40.769597116498105 4C-AM-1006-01 04C AM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9771847728747 40.7695971164981)
2605 2605 -73.97368963630059 40.767763086262605 4G-AM-1006-01 04G AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9736896363006 40.7677630862626)

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