2018_Central_Park_Squirrel_Census_-_Squirrel_Data

23 rows where Hectare Squirrel Number = 11 and Shift = "PM" sorted by Above Ground Sighter Measurement

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, Running, Chasing, Climbing, Eating, Foraging, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Shift

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
390 -73.970720187655 40.7774564799983 14D-PM-1019-11 14D PM 10192018 11 Adult Gray   Gray+         0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.970720187655 40.7774564799983)
281 -73.9619411917909 40.7923536640283 33B-PM-1010-11 33B PM 10102018 11 Adult Gray   Gray+   Above Ground 10   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9619411917909 40.7923536640283)
2868 -73.9653873284496 40.7804699882574 20F-PM-1007-11 20F PM 10072018 11 Adult Gray White Gray+White   Above Ground 10 in tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9653873284496 40.7804699882574)
1596 -73.96669451239221 40.7839956493194 22C-PM-1006-11 22C PM 10062018 11 Juvenile Gray   Gray+   Above Ground 13   0 0 1 0 0   1 0 0 0 0 0 0 0   POINT (-73.9666945123922 40.7839956493194)
1787 -73.9720365327715 40.7762329714016 13D-PM-1018-11 13D PM 10182018 11 Adult Gray White Gray+White   Above Ground 15   0 0 1 1 0   0 0 0 0 1 0 1 0   POINT (-73.9720365327715 40.7762329714016)
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)
1631 -73.9527196716568 40.792363826828 36I-PM-1007-11 36I PM 10072018 11 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3   0 0 1 0 0   0 0 0 0 0 0 0 1 me! POINT (-73.9527196716568 40.792363826828)
366 -73.9673548527075 40.7765669058396 15G-PM-1019-11 15G PM 10192018 11 Adult Gray   Gray+   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 0 0 stared POINT (-73.9673548527075 40.7765669058396)
126 -73.97921554736891 40.7693711799946 3B-PM-1007-11 03B PM 10072018 11 Adult Gray   Gray+   Above Ground 5 in tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9792155473689 40.7693711799946)
332 -73.9705123624953 40.7731723757869 10F-PM-1019-11 10F PM 10192018 11 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Grassy area 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9705123624953 40.7731723757869)
625 -73.9764235373322 40.770606513989 5C-PM-1010-11 05C PM 10102018 11 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.97642353733221 40.770606513989)
678 -73.977447585355 40.769716782800295 4C-PM-1010-11 04C PM 10102018 11 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.977447585355 40.7697167828003)
952 -73.9699763667769 40.775706073102604 13E-PM-1008-11 13E PM 10082018 11 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9699763667769 40.775706073102604)
1131 -73.9793082679745 40.7679930598805 2C-PM-1013-11 02C PM 10132018 11 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9793082679745 40.7679930598805)
1344 -73.96185915109321 40.7921343738001 32C-PM-1013-11 32C PM 10132018 11 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9618591510932 40.7921343738001)
1417 -73.974828939898 40.7668886121909 2F-PM-1014-11 02F PM 10142018 11 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.974828939898 40.7668886121909)
1903 -73.9701379806066 40.7785234812393 16D-PM-1010-11 16D PM 10102018 11 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9701379806066 40.7785234812393)
1913 -73.97746308218541 40.7680626674086 3D-PM-1010-11 03D PM 10102018 11 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9774630821854 40.76806266740861)
1946 -73.9692925815903 40.7774506065008 15E-PM-1008-11 15E PM 10082018 11 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9692925815903 40.7774506065008)
2348 -73.9531965469704 40.794743798397704 38G-PM-1020-11 38G PM 10202018 11 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 1 1 0   POINT (-73.9531965469704 40.7947437983977)
2376 -73.9594204646985 40.790592376521296 32E-PM-1017-11 32E PM 10172018 11 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9594204646985 40.7905923765213)
2672 -73.9614599022015 40.7945181285991 35A-PM-1013-11 35A PM 10132018 11 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9614599022015 40.7945181285991)
2760 -73.9701808122548 40.7744632730919 12F-PM-1007-11 12F PM 10072018 11 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.9701808122548 40.7744632730919)

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