2018_Central_Park_Squirrel_Census_-_Squirrel_Data

30 rows where Date = 10142018, Hectare Squirrel Number = 2 and Indifferent = 1 sorted by latitude

✎ View and edit SQL

This data as json, CSV (advanced)

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

Indifferent ✖

Hectare Squirrel Number ✖

Date ✖

  • 10142018 · 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
1618 1618 -73.9755836827968 40.7670239327996 2F-PM-1014-02 02F PM 10142018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9755836827968 40.7670239327996)
742 742 -73.9767016963397 40.7674012784541 2E-PM-1014-02 02E PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9767016963397 40.7674012784541)
158 158 -73.9710991123992 40.77238897266471 9F-PM-1014-02 09F PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9710991123992 40.7723889726647)
655 655 -73.9728783802067 40.7731671049246 9E-PM-1014-02 09E PM 10142018 2 Juvenile Gray Black, Cinnamon Gray+Black, Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9728783802067 40.7731671049246)
359 359 -73.9716404781264 40.7753181851766 12D-PM-1014-02 12D PM 10142018 2 Adult Gray White Gray+White   Above Ground 15   0 0 1 0 0 seems to be grinding teeth on a piece of material (sounds from grinding) 0 0 0 0 0 0 1 0   POINT (-73.9716404781264 40.7753181851766)
1097 1097 -73.9761579527932 40.7755877312075 10A-PM-1014-02 10A PM 10142018 2 Adult Gray Black, Cinnamon Gray+Black, Cinnamon   Ground Plane FALSE in the bushes beneath a tree 0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9761579527932 40.7755877312075)
2955 2955 -73.97116665233759 40.776151305703394 13D-AM-1014-02 13D AM 10142018 2 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9711666523376 40.7761513057034)
2112 2112 -73.9655206571055 40.7764851568746 16H-PM-1014-02 16H PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9655206571055 40.7764851568746)
2108 2108 -73.9702420100291 40.7772720889907 14D-AM-1014-02 14D AM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9702420100291 40.7772720889907)
2887 2887 -73.964593167562 40.7780374890066 18H-PM-1014-02 18H PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.964593167562 40.7780374890066)
2949 2949 -73.9651206201297 40.778527906484705 18G-AM-1014-02 18G AM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9651206201297 40.7785279064847)
2481 2481 -73.9719068478565 40.7789062312585 15B-AM-1014-02 15B AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 0 0 0 grooming,scratching 0 0 0 0 0 0 1 0   POINT (-73.9719068478565 40.7789062312585)
1936 1936 -73.9667911565238 40.779321901098 18F-AM-1014-02 18F AM 10142018 2 Adult Gray   Gray+   Ground Plane FALSE In small tree by water 0 0 0 1 1   0 1 0 0 0 0 1 0   POINT (-73.9667911565238 40.77932190109801)
2846 2846 -73.96615704780291 40.7807271518813 20E-AM-1014-02 20E AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9661570478029 40.7807271518813)
428 428 -73.96362827608 40.780799459524204 21G-AM-1014-02 21G AM 10142018 2 Adult Gray White Gray+White   Above Ground 3 fence 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.96362827608 40.7807994595242)
2857 2857 -73.9649230271173 40.7821766215675 22F-PM-1014-02 22F PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9649230271173 40.7821766215675)
1917 1917 -73.9627819112681 40.7886877360376 29D-AM-1014-02 29D AM 10142018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9627819112681 40.7886877360376)
1041 1041 -73.9643236505425 40.7887854771596 28C-AM-1014-02 28C AM 10142018 2 Adult Gray   Gray+   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9643236505425 40.7887854771596)
862 862 -73.9626120417397 40.790512635862605 30C-AM-1014-02 30C AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE on a rock 1 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9626120417397 40.7905126358626)
826 826 -73.95572635334891 40.7939505791448 37F-PM-1014-02 37F PM 10142018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE LAWN 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.95572635334891 40.7939505791448)
1482 1482 -73.95886101956991 40.7945269936639 36C-AM-1014-02 36C AM 10142018 2 Juvenile Gray White Gray+White   Ground Plane FALSE Crossing path 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9588610195699 40.7945269936639)
1708 1708 -73.9618486459307 40.7946365810826 35A-AM-1014-02 35A AM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9618486459307 40.7946365810826)
1873 1873 -73.955754300682 40.795681399740005 38E-PM-1014-02 38E PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.955754300682 40.79568139974)
184 184 -73.9553811810434 40.7970895007931 40E-AM-1014-02 40E AM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9553811810434 40.7970895007931)
2916 2916 -73.95175251116791 40.7974407641075 42G-PM-1014-02 42G PM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 14   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9517525111679 40.7974407641075)
2632 2632 -73.95082755733499 40.797579073666 42H-PM-1014-02 42H PM 10142018 2 Adult Gray White Gray+White   Above Ground   Running along stone ledge 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.950827557335 40.797579073666)
871 871 -73.9583738783348 40.7979302775527 39B-PM-1014-02 39B PM 10142018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9583738783348 40.7979302775527)
1603 1603 -73.95459292421741 40.7986940168685 42D-AM-1014-02 42D AM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9545929242174 40.7986940168685)
656 656 -73.9553726714504 40.798757854112296 41D-AM-1014-02 41D AM 10142018 2 Adult Gray   Gray+   Above Ground 20   0 0 0 0 0 jumping 0 0 0 0 0 0 1 0   POINT (-73.9553726714504 40.7987578541123)
473 473 -73.95701300171591 40.799602742862504 42B-AM-1014-02 42B AM 10142018 2 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9570130017159 40.7996027428625)

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