2018_Central_Park_Squirrel_Census_-_Squirrel_Data

125 rows where Climbing = 0 and Date = 10192018 sorted by Chasing

✎ View and edit SQL

This data as json, CSV (advanced)

Moans ✖

  • 0 24
  • 1 1

Date ✖

  • 10192018 · 25 ✖

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
2736 2736 -73.95938952535009 40.797308584408704 38B-AM-1019-03 38B AM 10192018 3 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9593895253501 40.7973085844087)
2777 2777 -73.98108436110859 40.768790549369896 2A-PM-1019-05 02A PM 10192018 5 ? Gray   Gray+   Above Ground 50 in tall planetree 1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9810843611086 40.7687905493699)
2800 2800 -73.9802983138318 40.7676540772339 1B-PM-1019-05 01B PM 10192018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9802983138318 40.7676540772339)
2802 2802 -73.9533101544112 40.7938634280159 38H-AM-1019-01 38H AM 10192018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9533101544112 40.7938634280159)
2825 2825 -73.96435075880079 40.790432469329204 30B-PM-1019-07 30B PM 10192018 7 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.96435075880082 40.7904324693292)
2834 2834 -73.9651132904127 40.7905384124102 29A-PM-1019-02 29A PM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9651132904127 40.7905384124102)
2841 2841 -73.9693262952166 40.783260411082004 21B-AM-1019-01 21B AM 10192018 1 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9693262952166 40.783260411082)
2882 2882 -73.956581233786 40.7902127690837 33H-AM-1019-01 33H AM 10192018 1 Adult Cinnamon Gray Cinnamon+Gray Cinnamon patches Ground Plane FALSE   0 0 0 0 0 wrestling with child 0 0 0 0 0 0 0 0   POINT (-73.956581233786 40.79021276908371)
2885 2885 -73.9530811255728 40.7983069118579 42F-AM-1019-02 42F AM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9530811255728 40.79830691185791)
2902 2902 -73.9673220504383 40.777029634596296 15G-PM-1019-04 15G PM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9673220504383 40.7770296345963)
2904 2904 -73.97203897567171 40.7763524091989 13C-PM-1019-02 13C PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9720389756717 40.7763524091989)
2907 2907 -73.96852016269341 40.783329261225 21B-AM-1019-05 21B AM 10192018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9685201626934 40.783329261225)
2924 2924 -73.9727230609785 40.7795341640894 16A-PM-1019-01 16A PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9727230609785 40.7795341640894)
2987 2987 -73.9563724838337 40.7882504581015 31I-PM-1019-04 31I PM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.95637248383372 40.7882504581015)
53 53 -73.95849706432129 40.7982886348696 40B-AM-1019-03 40B AM 10192018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 1 1 0 0   POINT (-73.9584970643213 40.7982886348696)
172 172 -73.958535640774 40.7982737896998 40B-AM-1019-02 40B AM 10192018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.958535640774 40.7982737896998)
1009 1009 -73.9636551433178 40.790157281877605 30B-PM-1019-02 30B PM 10192018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 1 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.9636551433178 40.7901572818776)
1037 1037 -73.96774098419691 40.776357914063894 15G-PM-1019-08 15G PM 10192018 8 Adult     +   Above Ground 5   0 1 0 0 0   0 1 1 0 0 0 0 0   POINT (-73.9677409841969 40.7763579140639)
1411 1411 -73.98028400317591 40.7678599069819 1B-PM-1019-04 01B PM 10192018 4 Juvenile Gray White Gray+White   Above Ground 25 in tree 0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9802840031759 40.7678599069819)
1688 1688 -73.9677593344667 40.7763054313195 15G-PM-1019-07 15G PM 10192018 7 Adult     +   Above Ground 5   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9677593344667 40.7763054313195)
1912 1912 -73.9698064901149 40.7842538115839 21A-AM-1019-03 21A AM 10192018 3 Adult Gray   Gray+   Ground Plane FALSE Tree & ground 0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9698064901149 40.78425381158391)
1997 1997 -73.97146376830841 40.776898456156296 14D-PM-1019-01 14D PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9714637683084 40.7768984561563)
2200 2200 -73.96980803283041 40.7842252948542 21A-AM-1019-02 21A AM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE Tree & ground 0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9698080328304 40.7842252948542)
2509 2509 -73.97142951022491 40.776954371947 14D-PM-1019-02 14D PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9714295102249 40.776954371947)
2865 2865 -73.98028424040159 40.767825738497706 1B-PM-1019-03 01B PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 25 in tree 0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.98028424040162 40.7678257384977)

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