2018_Central_Park_Squirrel_Census_-_Squirrel_Data

9 rows where Age = "Juvenile", Approaches = 1 and Running = 1 sorted by Other Activities

View and edit SQL

Suggested facets: Hectare, Shift, Date, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Tail twitches, Runs from

Hectare Squirrel Number

Running

Approaches

Age

  • Juvenile · 9
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
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)
743 -73.9565035705619 40.7937382705056 36F-AM-1017-04 36F AM 10172018 4 Juvenile Gray White Gray+White White legs, front & back Ground Plane FALSE   1 0 0 1 1   1 0 0 0 0 1 0 1 approaches (me),runs from (me) POINT (-73.9565035705619 40.7937382705056)
1270 -73.967762162893 40.7823359027165 20C-PM-1018-08 20C PM 10182018 8 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 1 runs from (dog) POINT (-73.967762162893 40.7823359027165)
1756 -73.9755041276839 40.7678213857557 3F-AM-1006-13 03F AM 10062018 13 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9755041276839 40.7678213857557)
2170 -73.9678923667678 40.7819675626236 20C-PM-1018-05 20C PM 10182018 5 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.9678923667678 40.781967562623606)
2772 -73.9677368646039 40.782155096483706 20C-PM-1018-06 20C PM 10182018 6 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.96773686460392 40.782155096483706)
257 -73.9773317054464 40.7684035996758 3D-AM-1006-03 03D AM 10062018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE on top [of] a big rock/boulder in the area 1 0 1 0 0 climbing (rock) 0 0 0 0 0 1 0 0 approaches (slightly),wary of humans POINT (-73.9773317054464 40.76840359967581)
222 -73.97702735535249 40.7732399463626 8A-AM-1013-03 08A AM 10132018 3 Juvenile     +   Above Ground 3 fence 1 1 1 1 0 playing tag together 0 0 0 0 0 1 0 0   POINT (-73.9770273553525 40.7732399463626)
1623 -73.97701191330229 40.773294909000505 8A-AM-1013-04 08A AM 10132018 4 Juvenile     +   Above Ground 4 fence 1 1 0 1 1 playing tag together 0 0 0 0 0 1 0 0   POINT (-73.9770119133023 40.7732949090005)

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