2018_Central_Park_Squirrel_Census_-_Squirrel_Data

119 rows where Hectare Squirrel Number = 8 sorted by Above Ground Sighter Measurement descending

✎ View and edit SQL

This data as json, CSV (advanced)

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
1598 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)
2455 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)
2266 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)
801 801 -73.9743342303548 40.772774294833205 8D-AM-1007-08 08D AM 10072018 8 Adult Gray   Gray+   Above Ground 15   0 0 0 0 0 communicating from tree 0 0 0 0 0 0 0 0   POINT (-73.97433423035481 40.7727742948332)
2950 2950 -73.9790980124501 40.7685934093915 2B-PM-1013-08 02B PM 10132018 8 Adult Gray White Gray+White   Above Ground 15   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9790980124501 40.7685934093915)
191 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)
430 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)
1060 1060 -73.97288710611909 40.771298365894395 8F-PM-1012-08 08F PM 10122018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9728871061191 40.7712983658944)
1125 1125 -73.9775735077285 40.7692872082165 4C-PM-1010-08 04C PM 10102018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10 on stone arch 1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9775735077285 40.7692872082165)
1378 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)
1926 1926 -73.9742811484852 40.775533619083 11B-PM-1014-08 11B PM 10142018 8   Gray   Gray+   Above Ground 10   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.97428114848522 40.775533619083)
2945 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)
758 758 -73.9703621616472 40.775032271482 12E-AM-1017-08 12E AM 10172018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1   0 0 0 1 0 chilling 0 0 0 0 0 0 1 0   POINT (-73.9703621616472 40.775032271482)
2595 2595 -73.9692676659807 40.7700678919108 8I-PM-1013-08 08I PM 10132018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 1   0 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.96926766598071 40.7700678919108)
867 867 -73.9762257701293 40.7744032758323 9A-AM-1013-08 09A AM 10132018 8 Adult     +         0 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9762257701293 40.7744032758323)
1069 1069 -73.9595485734618 40.7835326425693 25I-PM-1007-08 25I PM 10072018 8 Adult Gray   Gray+   Above Ground   playing very high in tree w/ #7 0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9595485734618 40.7835326425693)
1645 1645 -73.9619673317128 40.7924176673037 33B-PM-1010-08 33B PM 10102018 8 Juvenile Gray   Gray+   Above Ground   running up tree 0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9619673317128 40.7924176673037)
2257 2257 -73.95431338448 40.7940537582585 37G-PM-1007-08 37G PM 10072018 8 Adult Gray   Gray+         0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.95431338448 40.7940537582585)
2714 2714 -73.9600738985438 40.793832879875204 35C-PM-1013-08 35C PM 10132018 8       +         0 0 0 0 0   1 0 0 0 0 0 0 0 did not *see* POINT (-73.9600738985438 40.7938328798752)

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