2018_Central_Park_Squirrel_Census_-_Squirrel_Data

123 rows where Date = 10192018 and Eating = 0 sorted by Running

✎ View and edit SQL

This data as json, CSV (advanced)

Tail flags ✖

  • 0 22
  • 1 1

Eating ✖

Date ✖

  • 10192018 · 23 ✖
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
1186 1186 -73.96740331258341 40.7769132902037 15G-PM-1019-02 15G PM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9674033125834 40.7769132902037)
1441 1441 -73.961335649743 40.7818876867842 23H-PM-1019-01 23H PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.961335649743 40.7818876867842)
1517 1517 -73.970041085185 40.7834427580313 21A-AM-1019-07 21A AM 10192018 7 Adult Gray   Gray+   Above Ground 25   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.970041085185 40.783442758031306)
1524 1524 -73.97259615083159 40.7795720444974 16A-PM-1019-06 16A PM 10192018 6 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9725961508316 40.7795720444974)
1613 1613 -73.95992022335359 40.7972599930224 38A-AM-1019-02 38A AM 10192018 2 Adult Gray   Gray+   Above Ground 3   1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9599202233536 40.7972599930224)
1758 1758 -73.9581241870185 40.7961057536141 38C-AM-1019-05 38C AM 10192018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9581241870185 40.7961057536141)
1877 1877 -73.9524490779105 40.7936003219524 38I-AM-1019-01 38I AM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9524490779105 40.7936003219524)
1893 1893 -73.9708108312271 40.7773975776146 14D-PM-1019-09 14D PM 10192018 9 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9708108312271 40.7773975776146)
1956 1956 -73.98089749771201 40.7690578709841 2A-PM-1019-02 02A PM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 0   POINT (-73.980897497712 40.7690578709841)
2053 2053 -73.97118102224209 40.7773445611969 14D-PM-1019-05 14D PM 10192018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9711810222421 40.7773445611969)
2320 2320 -73.9576897478787 40.796469532845705 38C-AM-1019-02 38C AM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9576897478787 40.7964695328457)
2384 2384 -73.9708564226824 40.7726219968014 10F-PM-1019-09 10F PM 10192018 9 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Across Arbor path into hill w/ bushes 1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9708564226824 40.7726219968014)
2412 2412 -73.98094464895641 40.768503216587895 2A-PM-1019-03 02A PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 15 in tree! 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9809446489564 40.7685032165879)
2466 2466 -73.95994199262991 40.797277472881106 38A-AM-1019-01 38A AM 10192018 1 Adult Gray   Gray+   Above Ground 3   1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9599419926299 40.7972774728811)
2629 2629 -73.9604576237503 40.7818120101394 23I-PM-1019-01 23I PM 10192018 1 Adult Gray   Gray+   Above Ground 35   1 0 0 0 0 running (across branches) 0 0 0 0 0 0 0 0   POINT (-73.9604576237503 40.7818120101394)
2657 2657 -73.9582150734453 40.7962862794303 38C-AM-1019-08 38C AM 10192018 8 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   1 0 0 0 0 0 1 0   POINT (-73.9582150734453 40.7962862794303)
2662 2662 -73.97086289336241 40.772563088678396 10F-PM-1019-08 10F PM 10192018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Under "Grape Arbor" structure behind Bandshell 1 0 0 0 1 digging 0 0 0 0 0 0 0 1   POINT (-73.9708628933624 40.7725630886784)
2688 2688 -73.9799302952205 40.767720720979796 1B-PM-1019-02 01B PM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9799302952205 40.7677207209798)
2715 2715 -73.9710273070712 40.776652124615296 14D-PM-1019-16 14D PM 10192018 16 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9710273070712 40.7766521246153)
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)
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)
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)

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