2018_Central_Park_Squirrel_Census_-_Squirrel_Data

122 rows where Climbing = 1 and Highlight Fur Color = "White" sorted by Chasing

✎ View and edit SQL

This data as json, CSV (advanced)

Tail twitches ✖

  • 0 19
  • 1 3

Highlight Fur Color ✖

  • White · 22 ✖

Climbing ✖

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
2528 2528 -73.96765297807241 40.7823206990549 21D-PM-1008-03 21D PM 10082018 3 Adult Gray White Gray+White   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9676529780724 40.7823206990549)
2692 2692 -73.98016364007441 40.769019205592606 2A-AM-1010-09 02A AM 10102018 9 Adult Gray White Gray+White   Above Ground   climbing in bush 0 0 1 0 0 hopping & flipping around. this one was very energetic & jumping aorund 0 0 0 0 1 0 0 0 climbed a foot up a tree and watched me POINT (-73.9801636400744 40.7690192055926)
2730 2730 -73.96535757586871 40.78053399533721 20F-PM-1007-12 20F PM 10072018 12 Adult Gray White Gray+White   Above Ground 20 in tree 0 0 1 1 0   0 0 0 0 0 0 0 0   POINT (-73.9653575758687 40.7805339953372)
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)
2779 2779 -73.9767835160078 40.767403033048204 2E-PM-1014-04 02E PM 10142018 4 Adult Cinnamon White Cinnamon+White   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9767835160078 40.7674030330482)
2794 2794 -73.9712187890707 40.7750640173134 12E-PM-1018-01 12E PM 10182018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 1 0 0   1 0 0 1 0 0 0 1   POINT (-73.9712187890707 40.7750640173134)
2804 2804 -73.9576094432477 40.7965342664074 38C-PM-1014-07 38C PM 10142018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9576094432477 40.7965342664074)
2811 2811 -73.97568897660891 40.7676078308589 3F-AM-1006-14 03F AM 10062018 14 Adult Gray White Gray+White   Above Ground 12   1 0 1 0 0 running from dog 0 0 0 0 0 0 0 1   POINT (-73.9756889766089 40.7676078308589)
2815 2815 -73.97473113123941 40.76773197250439 3F-PM-1013-06 03F PM 10132018 6 Adult Gray White Gray+White   Above Ground 19   0 0 1 0 0   0 1 0 0 0 0 0 1   POINT (-73.97473113123941 40.7677319725044)
2854 2854 -73.9772908667333 40.7697207404744 4C-AM-1006-05 04C AM 10062018 5 Juvenile Gray White Gray+White   Above Ground 20   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9772908667333 40.7697207404744)
2868 2868 -73.9653873284496 40.7804699882574 20F-PM-1007-11 20F PM 10072018 11 Adult Gray White Gray+White   Above Ground 10 in tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9653873284496 40.7804699882574)
2956 2956 -73.9654741695628 40.7890427851106 28B-PM-1010-01 28B PM 10102018 1 Adult Gray White Gray+White   Above Ground 10 in a tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9654741695628 40.7890427851106)
2973 2973 -73.9766693184436 40.7708879215854 6C-PM-1020-01 06C PM 10202018 1 Adult Gray White Gray+White   Above Ground 25 Across Transverse 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9766693184436 40.7708879215854)
212 212 -73.9638837160341 40.7809747900833 21G-AM-1014-07 21G AM 10142018 7 Adult Gray White Gray+White   Above Ground 5   0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9638837160341 40.7809747900833)
879 879 -73.9735120882106 40.7715915415169 8E-PM-1008-07 08E PM 10082018 7 Adult Gray White Gray+White   Ground Plane FALSE 5, 6, 7 all at same tree trunk base 0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9735120882106 40.7715915415169)
1182 1182 -73.9667206046912 40.777999356509795 17G-PM-1017-04 17G PM 10172018 4 Adult Gray White Gray+White   Above Ground 10 tree & ground 1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9667206046912 40.7779993565098)
1395 1395 -73.9710801547498 40.7760872452093 13D-AM-1014-03 13D AM 10142018 3 Juvenile Gray White Gray+White   Above Ground 2   0 1 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9710801547498 40.7760872452093)
1551 1551 -73.9785114291288 40.771977958944895 6A-PM-1012-03 06A PM 10122018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9785114291288 40.7719779589449)
1644 1644 -73.9734654671008 40.7715988711659 8E-PM-1008-06 08E PM 10082018 6 Adult Gray White Gray+White   Ground Plane FALSE 5, 6, 7 all at same tree trunk base 0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9734654671008 40.7715988711659)
1988 1988 -73.957138794884 40.7985389822719 40C-AM-1017-03 40C AM 10172018 3 Adult Gray White Gray+White         1 1 1 0 0 chasing (#4),digging 0 0 0 0 1 0 1 0   POINT (-73.957138794884 40.7985389822719)
2071 2071 -73.96676944398949 40.7779501809095 17G-PM-1017-03 17G PM 10172018 3 Adult Gray White Gray+White   Above Ground 10 tree & ground 1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9667694439895 40.7779501809095)
2394 2394 -73.97858295460459 40.7719652299132 6A-PM-1012-02 06A PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9785829546046 40.7719652299132)

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