2018_Central_Park_Squirrel_Census_-_Squirrel_Data

17 rows where Climbing = 1, Hectare Squirrel Number = 8 and Runs from = 0 sorted by latitude

View and edit SQL

Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Eating, Kuks, Tail twitches, Approaches, Indifferent

Hectare Squirrel Number

Climbing

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
2266 -73.9716402454355 40.7665133780672 3I-PM-1013-08 03I PM 10132018 8 Adult Black   Black+   Above Ground 2   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9716402454355 40.7665133780672)
2223 -73.9784863123685 40.7669225020831 1D-AM-1006-08 01D AM 10062018 8 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 45   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9784863123685 40.7669225020831)
899 -73.97927540372909 40.7679690700399 2C-AM-1010-08 02C AM 10102018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3 stay on side of trunk 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9792754037291 40.7679690700399)
191 -73.9787105069657 40.7693708133873 3B-AM-1010-08 03B AM 10102018 8 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 0 0 together w/ #7 0 0 0 0 0 0 1 0   POINT (-73.9787105069657 40.7693708133873)
2535 -73.9700101107283 40.7696729501144 7I-PM-1013-08 07I PM 10132018 8 Adult Black   Black+   Above Ground 4   0 0 1 0 0   0 0 0 0 1 0 0 0   POINT (-73.9700101107283 40.7696729501144)
1598 -73.9726828460055 40.770570769482205 7F-AM-1008-08 07F AM 10082018 8 Adult Gray   Gray+   Above Ground 20   0 0 1 0 0 playing w/ #9 0 0 0 0 0 0 1 0   POINT (-73.9726828460055 40.7705707694822)
1654 -73.9766342125035 40.7715437147052 6C-AM-1007-08 06C AM 10072018 8 Adult     +   Above Ground 35   0 0 1 0 0 dropping acorns 0 0 0 0 0 0 0 0   POINT (-73.9766342125035 40.7715437147052)
430 -73.9710116801402 40.7723689301989 10G-PM-1017-08 10G PM 10172018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9710116801402 40.7723689301989)
2198 -73.97097381665309 40.7774102689734 14D-PM-1019-08 14D PM 10192018 8 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9709738166531 40.7774102689734)
1300 -73.964280573021 40.777830911491 18I-PM-1007-08 18I PM 10072018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 1 1 0 0 canoodling w/ #9 0 0 0 0 0 0 1 0   POINT (-73.964280573021 40.777830911491)
2945 -73.9649103330443 40.7823913860445 22F-PM-1014-08 22F PM 10142018 8 Adult Gray   Gray+   Above Ground 10 CLIMBED THE TREE 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9649103330443 40.7823913860445)
1378 -73.9669762657479 40.7835913293646 22C-PM-1006-08 22C PM 10062018 8 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9669762657479 40.7835913293646)
1820 -73.9546337446865 40.7898772579576 33I-PM-1006-08 33I PM 10062018 8 Adult Gray   Gray+   Above Ground 6   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9546337446865 40.7898772579576)
2826 -73.9600357018376 40.790653976688105 32E-AM-1007-08 32E AM 10072018 8 Adult Gray   Gray+   Above Ground 65 tree top 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9600357018376 40.7906539766881)
2056 -73.9589600626433 40.7913690265064 33E-AM-1014-08 33E AM 10142018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 5   0 0 1 0 0   1 0 0 0 0 0 1 0   POINT (-73.9589600626433 40.7913690265064)
1140 -73.9615817859213 40.7945839663845 35A-AM-1014-08 35A AM 10142018 8 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9615817859213 40.79458396638451)
2455 -73.9577297187155 40.799225295679 41B-AM-1010-08 41B AM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 20   0 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9577297187155 40.799225295679)

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