2018_Central_Park_Squirrel_Census_-_Squirrel_Data

24 rows where Foraging = 0, Hectare Squirrel Number = 4 and Tail twitches = 1

✎ View and edit SQL

This data as json, CSV (advanced)

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

Climbing ✖

  • 0 17
  • 1 7

Tail twitches ✖

Hectare Squirrel Number ✖

Foraging ✖

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
100 100 -73.9761592532482 40.774721358538706 10A-AM-1006-04 10A AM 10062018 4 Juvenile Gray   Gray+   Above Ground 10 tree near large rock on Bridle Path 0 0 0 0 0 walking on branch 0 0 0 0 1 0 0 0   POINT (-73.9761592532482 40.7747213585387)
533 533 -73.9652584749758 40.7803011124382 19F-PM-1017-04 19F PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9652584749758 40.7803011124382)
567 567 -73.9756972647636 40.773624164826 9B-PM-1013-04 09B PM 10132018 4 Juvenile Gray Black Gray+Black   Above Ground 30   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9756972647636 40.773624164826)
670 670 -73.9602398690946 40.7910157676119 32D-PM-1006-04 32D PM 10062018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 40   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9602398690946 40.7910157676119)
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)
1294 1294 -73.9604089940153 40.7910028063138 32D-AM-1013-04 32D AM 10132018 4 Adult Cinnamon   Cinnamon+ Brown legs Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 1 0 1   POINT (-73.9604089940153 40.7910028063138)
1296 1296 -73.97055091705421 40.7689416540228 6I-PM-1013-04 06I PM 10132018 4 Adult Black Gray Black+Gray   Ground Plane FALSE Grass 0 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.9705509170542 40.7689416540228)
1342 1342 -73.96620636423451 40.789077866530704 28A-PM-1007-04 28A PM 10072018 4 Adult Gray White Gray+White         0 0 0 0 0 looking at me & #5 1 0 0 0 1 0 0 0 freezes POINT (-73.9662063642345 40.7890778665307)
1356 1356 -73.9534910562766 40.7935774443789 37H-AM-1018-04 37H AM 10182018 4 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1 was with a lot of robins POINT (-73.9534910562766 40.7935774443789)
1453 1453 -73.9555856074105 40.7969457685677 40E-AM-1014-04 40E AM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE on rocks/bushy rocks 1 0 0 0 0 hiding from bird 0 1 0 0 1 0 1 0   POINT (-73.9555856074105 40.79694576856771)
1585 1585 -73.96113123553481 40.79501308639129 36A-PM-1013-04 36A PM 10132018 4   Gray White Gray+White   Ground Plane FALSE ON ROCK NEAR POND 0 0 0 0 0 sitting 0 0 0 0 1 0 1 0   POINT (-73.9611312355348 40.7950130863913)
1600 1600 -73.9753093777 40.7666673897583 2F-AM-1006-04 02F AM 10062018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White Beautiful white puff at the end of its tail Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.97530937770001 40.7666673897583)
1639 1639 -73.9736800575584 40.778306973575795 14A-PM-1014-04 14A PM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0 chasing (#3) 0 0 0 0 1 0 1 0   POINT (-73.9736800575584 40.7783069735758)
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)
2219 2219 -73.9709242364673 40.7684217215595 5I-AM-1010-04 05I AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9709242364673 40.7684217215595)
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)
2390 2390 -73.9680741975294 40.7847036778165 23B-PM-1012-04 23B PM 10122018 4 Adult Gray White Gray+White   Above Ground 20   0 0 0 0 0 watching me - didn't move 0 0 0 0 1 0 0 1   POINT (-73.9680741975294 40.7847036778165)
2449 2449 -73.9599911537509 40.791445254284504 33D-AM-1017-04 33D AM 10172018 4 Adult Black   Black+   Above Ground 5   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9599911537509 40.7914452542845)
2745 2745 -73.97296259363002 40.7652601851275 1I-PM-1012-04 01I PM 10122018 4 Juvenile Cinnamon White Cinnamon+White Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 2 on ledge 0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.97296259363 40.7652601851275)
2776 2776 -73.9789687905912 40.769269313932796 3B-PM-1007-04 03B PM 10072018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 At fence 1 0 1 1 0   0 0 0 0 1 0 1 1   POINT (-73.9789687905912 40.7692693139328)
2839 2839 -73.9672252136807 40.787650474321204 26A-PM-1006-04 26A PM 10062018 4 Adult Gray   Gray+   Above Ground 40   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9672252136807 40.7876504743212)
2878 2878 -73.969720780557 40.774110568875706 12F-AM-1020-04 12F AM 10202018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.969720780557 40.7741105688757)
2988 2988 -73.9766342759486 40.7687518380873 4D-AM-1012-04 04D AM 10122018 4 Adult Gray   Gray+   Above Ground 3 on tree trunk 0 1 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9766342759486 40.7687518380873)
3008 3008 -73.9503533343658 40.7976543603953 42H-PM-1014-04 42H PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   1 1 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9503533343658 40.7976543603953)

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.805ms