2018_Central_Park_Squirrel_Census_-_Squirrel_Data

23 rows where Hectare Squirrel Number = 8 and Primary Fur Color = "Cinnamon" sorted by Hectare Squirrel Number

View and edit SQL

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

Hectare Squirrel Number

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
214 -73.97725765612441 40.767989509396294 3D-AM-1006-08 03D AM 10062018 8 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0 approaches (food stand) POINT (-73.9772576561244 40.7679895093963)
303 -73.9762348224648 40.7694522315322 4D-PM-1008-08 04D PM 10082018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 1 1 1 climbed fence staring at me - went up tree 0 0 0 0 0 0 0 1   POINT (-73.97623482246482 40.7694522315322)
305 -73.9750283794865 40.772410192782104 8C-PM-1013-08 08C PM 10132018 8   Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9750283794865 40.7724101927821)
424 -73.9756557086441 40.773296289823996 8B-PM-1012-08 08B PM 10122018 8 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9756557086441 40.773296289824)
677 -73.97991559660859 40.7698034314993 3A-PM-1017-08 03A PM 10172018 8 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9799155966086 40.7698034314993)
800 -73.96821440393342 40.7773070675393 15F-AM-1007-08 15F AM 10072018 8 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9682144039334 40.7773070675393)
1140 -73.9615817859213 40.7945839663845 35A-AM-1014-08 35A AM 10142018 8 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9615817859213 40.79458396638451)
1198 -73.9762187733662 40.7739282973004 9B-PM-1013-08 09B PM 10132018 8 Juvenile Cinnamon Black, White Cinnamon+Black, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9762187733662 40.7739282973004)
1199 -73.9756993198381 40.768195664191296 3E-PM-1008-08 03E PM 10082018 8 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9756993198381 40.7681956641913)
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)
1363 -73.972112497276 40.77027590374279 7G-AM-1010-08 07G AM 10102018 8 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.972112497276 40.7702759037428)
1379 -73.9796470494747 40.7678370925485 1C-PM-1013-08 01C PM 10132018 8 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9796470494747 40.7678370925485)
1577 -73.965390623703 40.7807731363782 20F-PM-1007-08 20F PM 10072018 8 Adult Cinnamon White Cinnamon+White white tail/belly Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.965390623703 40.7807731363782)
1772 -73.9690540696008 40.7766014124609 14F-PM-1012-08 14F PM 10122018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 1 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9690540696008 40.7766014124609)
1855 -73.9791826197108 40.768577844752 2B-AM-1010-08 02B AM 10102018 8 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9791826197108 40.768577844752)
2099 -73.9685612289881 40.7778488829217 16E-PM-1018-08 16E PM 10182018 8 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9685612289881 40.7778488829217)
2255 -73.96429678758571 40.78156523539371 21F-AM-1018-08 21F AM 10182018 8 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9642967875857 40.7815652353937)
2455 -73.9577297187155 40.799225295679 41B-AM-1010-08 41B AM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 20   0 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9577297187155 40.799225295679)
2595 -73.9692676659807 40.7700678919108 8I-PM-1013-08 08I PM 10132018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 1   0 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.96926766598071 40.7700678919108)
2735 -73.97680969536471 40.7708185213129 5C-PM-1010-08 05C PM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9768096953647 40.7708185213129)
2801 -73.9697665830132 40.7759094917104 13E-PM-1008-08 13E PM 10082018 8 Juvenile Cinnamon Black, White Cinnamon+Black, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9697665830132 40.7759094917104)
2976 -73.97240833205379 40.7744163768061 11D-AM-1010-08 11D AM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1 drinking 0 0 0 0 0 1 0 0   POINT (-73.9724083320538 40.7744163768061)
3004 -73.9528482858163 40.7922056218325 36I-PM-1007-08 36I PM 10072018 8 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9528482858163 40.7922056218325)

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