2018_Central_Park_Squirrel_Census_-_Squirrel_Data

15 rows where Above Ground Sighter Measurement = 10 and Date = 10082018 sorted by longitude

View and edit SQL

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, Approaches, Indifferent, Runs from

Tail twitches

  • 0 15

Date

  • 10082018 · 15

Above Ground Sighter Measurement

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 -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)
2005 -73.9755259087781 40.770725612418104 6D-AM-1008-01 06D AM 10082018 1 Adult Cinnamon White Cinnamon+White   Above Ground 10   0 0 1 1 0   1 0 0 0 0 1 0 0   POINT (-73.9755259087781 40.7707256124181)
896 -73.9755055978764 40.77074386817421 6D-AM-1008-02 06D AM 10082018 2 Juvenile Gray   Gray+   Above Ground 10   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9755055978764 40.7707438681742)
2334 -73.97549229705109 40.7707686392991 6D-AM-1008-03 06D AM 10082018 3 Juvenile Gray   Gray+   Above Ground 10   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9754922970511 40.7707686392991)
1741 -73.9736995552241 40.77227125186371 8E-PM-1008-02 08E PM 10082018 2 Adult Black Cinnamon Black+Cinnamon   Above Ground 10 in tree 1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9736995552241 40.7722712518637)
144 -73.9730750601212 40.7701304211944 6F-PM-1008-01 06F PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9730750601212 40.7701304211944)
1569 -73.973047824163 40.7700873791211 7F-AM-1008-03 07F AM 10082018 3 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.973047824163 40.7700873791211)
1960 -73.97301589136609 40.7701310707272 6F-PM-1008-02 06F PM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   1 1 0 0 0 chasing #2 0 0 0 0 0 0 0 0   POINT (-73.9730158913661 40.7701310707272)
1116 -73.9729847109778 40.774070904960205 10D-AM-1008-03 10D AM 10082018 3 Adult Gray White Gray+White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9729847109778 40.7740709049602)
2185 -73.9707571364399 40.7758859812524 13E-PM-1008-02 13E PM 10082018 2 Adult Gray White Gray+White   Above Ground 10   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9707571364399 40.7758859812524)
1028 -73.97070123456609 40.7758938984066 13E-PM-1008-03 13E PM 10082018 3 Juvenile Gray White Gray+White   Above Ground 10 hanging upside down to get a nut 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9707012345661 40.7758938984066)
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)
890 -73.9667755678511 40.7760256836088 15H-PM-1008-02 15H PM 10082018 2 Adult Gray   Gray+   Above Ground 10 oak tree 0 1 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9667755678511 40.7760256836088)
1135 -73.9667474482967 40.7760643720793 15H-PM-1008-01 15H PM 10082018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10 Oak tree 0 1 0 0 0 watching me 0 1 0 1 0 0 0 0 observant POINT (-73.9667474482967 40.7760643720793)
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)

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