2018_Central_Park_Squirrel_Census_-_Squirrel_Data

19 rows where Date = 10082018, Foraging = 0 and Hectare Squirrel Number = 4 sorted by Highlight Fur Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Kuks, Tail twitches, Indifferent, Runs from

Hectare Squirrel Number ✖

Foraging ✖

Date ✖

  • 10082018 · 19 ✖
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
336 336 -73.97574132156208 40.7692582758978 4E-PM-1008-04 04E PM 10082018 4 Adult Gray   Gray+   Above Ground 10   1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9757413215621 40.7692582758978)
511 511 -73.9653142636891 40.776001512929795 15I-AM-1008-04 15I AM 10082018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9653142636891 40.7760015129298)
873 873 -73.9770948563006 40.7724063459185 7B-AM-1008-04 07B AM 10082018 4 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9770948563006 40.7724063459185)
1280 1280 -73.9562469727195 40.79685907654 39D-AM-1008-04 39D AM 10082018 4 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9562469727195 40.79685907654)
1563 1563 -73.96762706709958 40.776391443152 15G-AM-1008-04 15G AM 10082018 4 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9676270670996 40.776391443152)
1790 1790 -73.97305925481159 40.7740879251541 10D-AM-1008-04 10D AM 10082018 4 Juvenile Gray   Gray+   Above Ground 25   0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9730592548116 40.7740879251541)
2450 2450 -73.9756273257684 40.7706539186221 6D-AM-1008-04 06D AM 10082018 4 Adult Gray   Gray+   Above Ground     0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9756273257684 40.7706539186221)
2619 2619 -73.9739737592602 40.772713047677705 9D-AM-1008-04 09D AM 10082018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9739737592602 40.7727130476777)
2722 2722 -73.96922711321359 40.777528508844 15E-PM-1008-04 15E PM 10082018 4 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9692271132136 40.777528508844)
2734 2734 -73.9763629541474 40.7682321897044 3E-PM-1008-04 03E PM 10082018 4 Adult Gray   Gray+   Above Ground 6   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9763629541474 40.7682321897044)
1079 1079 -73.9722737593623 40.768963018754 6G-AM-1008-04 06G AM 10082018 4 Juvenile Gray Cinnamon Gray+Cinnamon very long tail Above Ground 20 tree 1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9722737593623 40.768963018754)
1508 1508 -73.96938943057859 40.775690674802604 13F-PM-1008-04 13F PM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9693894305786 40.7756906748026)
2264 2264 -73.97735205827341 40.7708198505781 5B-AM-1008-04 05B AM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9773520582734 40.7708198505781)
2271 2271 -73.96739494580959 40.7826218539496 21D-AM-1008-04 21D AM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9673949458096 40.78262185394961)
2862 2862 -73.967466716152 40.782434654827796 21D-PM-1008-04 21D PM 10082018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4   0 0 0 1 0   0 0 0 0 0 0 0 1 i scared it POINT (-73.967466716152 40.7824346548278)
1003 1003 -73.9645547556826 40.776877007081 16I-AM-1008-04 16I AM 10082018 4 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 9 tree hollow 0 0 0 0 0 in hollow 0 0 0 0 0 0 0 0 curious POINT (-73.9645547556826 40.776877007081)
1663 1663 -73.96967203626271 40.779185159819704 17D-AM-1008-04 17D AM 10082018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9696720362627 40.7791851598197)
2340 2340 -73.9730284815849 40.7702462529502 7F-AM-1008-04 07F AM 10082018 4 Adult Gray White Gray+White   Ground Plane FALSE bush 0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9730284815849 40.7702462529502)
2355 2355 -73.9728654439465 40.7724853142211 9E-AM-1008-04 09E AM 10082018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9728654439465 40.7724853142211)

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