2018_Central_Park_Squirrel_Census_-_Squirrel_Data

35 rows where Date = 10142018 and Tail twitches = 1 sorted by Combination of Primary and Highlight Color

View and edit SQL

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

Running

  • 0 22
  • 1 13

Tail twitches

Date

  • 10142018 · 35
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
1394 -73.95488263914001 40.7959474571251 39F-AM-1014-05 39F AM 10142018 5 Juvenile Cinnamon   Cinnamon+   Above Ground 2 up/down tree 1 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.95488263914 40.7959474571251)
2244 -73.9509628195532 40.797777567417796 42H-PM-1014-01 42H PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   0 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9509628195532 40.7977775674178)
2696 -73.9501457233643 40.797094356558 42I-PM-1014-01 42I PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9501457233643 40.797094356558)
2387 -73.98085173247209 40.7683154647217 1A-PM-1014-01 01A PM 10142018 1 Adult Cinnamon White Cinnamon+White   Above Ground 6   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9808517324721 40.7683154647217)
47 -73.9640032826529 40.782030982544796 22F-PM-1014-06 22F PM 10142018 6 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9640032826529 40.7820309825448)
1255 -73.9717469822209 40.7753731930704 12D-PM-1014-03 12D PM 10142018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9717469822209 40.7753731930704)
2641 -73.96155167034941 40.790521938835894 31D-AM-1014-04 31D AM 10142018 4 Juvenile Gray   Gray+   Ground Plane FALSE Open ground 1 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9615516703494 40.7905219388359)
655 -73.9728783802067 40.7731671049246 9E-PM-1014-02 09E PM 10142018 2 Juvenile Gray Black, Cinnamon Gray+Black, Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9728783802067 40.7731671049246)
1097 -73.9761579527932 40.7755877312075 10A-PM-1014-02 10A PM 10142018 2 Adult Gray Black, Cinnamon Gray+Black, Cinnamon   Ground Plane FALSE in the bushes beneath a tree 0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9761579527932 40.7755877312075)
35 -73.97569760767071 40.775389733191794 10A-PM-1014-01 10A PM 10142018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray & White selected as Primary. Black & Cinnamon selected as Highlights. Made executive adjustments. Ground Plane FALSE in b/w trees 0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9756976076707 40.7753897331918)
2124 -73.97300395815209 40.7730688398468 9E-PM-1014-03 09E PM 10142018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE underneath a tree 0 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9730039581521 40.7730688398468)
719 -73.96268812347421 40.7905208345549 30C-AM-1014-01 30C AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9626881234742 40.7905208345549)
862 -73.9626120417397 40.790512635862605 30C-AM-1014-02 30C AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE on a rock 1 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9626120417397 40.7905126358626)
985 -73.9681722244801 40.783559826281 22B-PM-1014-07 22B PM 10142018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9681722244801 40.783559826281)
1015 -73.9720347089273 40.7727750272024 9E-PM-1014-01 09E PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Gathering/digging in grassy area b/w trees 0 0 0 0 1 looked like it was smelling/digging in the ground 0 0 0 0 1 0 1 0 indifferent (was in a grassy area with no humans nearby) POINT (-73.9720347089273 40.7727750272024)
1235 -73.9679686793869 40.7825993867876 21C-AM-1014-01 21C AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   1 0 0 0 0 jumping back & forth on tree 0 0 0 1 1 0 1 0   POINT (-73.9679686793869 40.7825993867876)
1884 -73.9733898487296 40.7666975131518 3H-PM-1014-02 03H PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9733898487296 40.7666975131518)
2016 -73.9589492240754 40.798901118974 40A-PM-1014-01 40A PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   0 0 1 0 0   0 0 0 0 1 0 1 0 stared & then went back up tree—then ran to different tree POINT (-73.9589492240754 40.798901118974)
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)
1183 -73.9525699067954 40.7937125788106 38I-PM-1014-01 38I PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE on the lawn East of the fountain 0 0 0 0 0 scampering thru the grass! 0 0 0 0 1 0 0 1   POINT (-73.9525699067954 40.7937125788106)
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)
1686 -73.9593373093799 40.7982428507976 39A-PM-1014-03 39A PM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Higlights. Made executive adjustments. Above Ground 6 Jumped from ground onto branch 0 0 0 0 1 digging? 0 0 0 0 1 0 1 0   POINT (-73.95933730937992 40.7982428507976)
2086 -73.9525627119429 40.793860286746394 38I-PM-1014-02 38I PM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE hanging out w/ Squirrel #1 0 0 0 0 0 scampering w/ squirrel #1 0 0 0 0 1 0 0 1   POINT (-73.9525627119429 40.7938602867464)
2655 -73.9659156108069 40.781070981869604 20E-AM-1014-01 20E AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9659156108069 40.7810709818696)
2849 -73.9709912560997 40.77589655951979 13D-AM-1014-01 13D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9709912560997 40.7758965595198)
128 -73.97462290946429 40.7748467061969 10B-PM-1014-05 10B PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 0 0 avoided people POINT (-73.9746229094643 40.7748467061969)
184 -73.9553811810434 40.7970895007931 40E-AM-1014-02 40E AM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9553811810434 40.7970895007931)
248 -73.9751729403694 40.774328412311796 10B-PM-1014-02 10B PM 10142018 2 Adult Gray White Gray+White   Above Ground   gingko tree by traffic light in front of Strawberry Fields 0 0 0 0 1   0 0 0 0 1 0 0 0 came over on tree to see me then disappeared POINT (-73.9751729403694 40.7743284123118)
431 -73.97574360194321 40.774606436322706 10B-PM-1014-01 10B PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE on lawn in front of a tree 0 0 0 0 1   0 0 0 0 1 0 0 0 stay on ground but went to other side of tree to hide from a dog POINT (-73.9757436019432 40.7746064363227)
702 -73.963858549251 40.7808999610914 21G-AM-1014-03 21G AM 10142018 3 Adult Gray White Gray+White   Above Ground 7   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.963858549251 40.7808999610914)
1310 -73.9546201403481 40.798942376865604 42D-AM-1014-03 42D AM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9546201403481 40.7989423768656)
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)
2157 -73.9657171357842 40.7773277532224 16H-PM-1014-05 16H PM 10142018 5 Adult Gray White Gray+White   Above Ground 5 tree 1 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9657171357842 40.7773277532224)
2216 -73.97351950184459 40.778714727971504 14A-AM-1014-02 14A AM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 1 0 0 0   POINT (-73.9735195018446 40.7787147279715)
2312 -73.97658670292259 40.7674304266107 2E-PM-1014-01 02E PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 0 0   POINT (-73.9765867029226 40.7674304266107)

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