2018_Central_Park_Squirrel_Census_-_Squirrel_Data

35 rows where Approaches = 1 and Tail twitches = 1 sorted by Shift

View and edit SQL

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

Tail twitches

Approaches

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)
79 -73.9610705592868 40.7914829661051 32D-AM-1013-06 32D AM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 1 1 eating (a mushroom),circles around us,really fat,scratching himself,grooming activity 0 0 0 0 1 1 0 0   POINT (-73.9610705592868 40.7914829661051)
232 -73.9624184586031 40.7921524868211 32B-AM-1017-03 32B AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 1 1 approaches (primarily),runs from (initially),follows POINT (-73.9624184586031 40.7921524868211)
982 -73.9676424599715 40.777776610680704 16F-AM-1008-01 16F AM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE near fence 0 0 0 0 1   0 0 0 0 1 1 0 0   POINT (-73.9676424599715 40.7777766106807)
1057 -73.9594406225891 40.7918533707789 33D-AM-1017-02 33D AM 10172018 2 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 0 0   POINT (-73.9594406225891 40.7918533707789)
1138 -73.9594357049738 40.7840678890949 25I-AM-1012-01 25I AM 10122018 1 Adult Cinnamon   Cinnamon+   Above Ground 4 on bar 0 0 0 1 0   0 0 0 1 1 1 0 0   POINT (-73.9594357049738 40.7840678890949)
1196 -73.95801114962751 40.7985365971474 40B-AM-1019-05 40B AM 10192018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 1 0   POINT (-73.9580111496275 40.7985365971474)
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)
1808 -73.9698870647042 40.7826510985538 20B-AM-1007-02 20B AM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 1 1 0 0   POINT (-73.9698870647042 40.7826510985538)
2205 -73.9594986107981 40.7840083040604 25I-AM-1012-03 25I AM 10122018 3 Adult Cinnamon   Cinnamon+   Above Ground 8 on turn, see map 1 1 0 1 0   0 0 0 0 1 1 0 0   POINT (-73.9594986107981 40.7840083040604)
2275 -73.96142184133559 40.793894505879294 34B-AM-1013-01 34B AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1 hopping 0 0 0 0 1 1 0 0   POINT (-73.9614218413356 40.7938945058793)
2586 -73.9752965316933 40.775253857578896 10B-AM-1006-03 10B AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   In tree 0 0 1 0 0   0 0 0 0 1 1 0 0   POINT (-73.9752965316933 40.7752538575789)
2816 -73.9809342290598 40.7687265606227 2A-AM-1010-05 02A AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE base of tree with ~ 30 small birds all eating 0 0 0 1 1   0 0 0 0 1 1 1 0   POINT (-73.9809342290598 40.7687265606227)
2998 -73.97520792474191 40.775537697900205 11B-AM-1007-01 11B AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 1 0 0   POINT (-73.9752079247419 40.7755376979002)
136 -73.9528682507794 40.792580780830704 36I-PM-1007-13 36I PM 10072018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 1 0 0   POINT (-73.9528682507794 40.7925807808307)
176 -73.9618064639153 40.792158440043 32C-PM-1013-12 32C PM 10132018 12 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 1 0 0   POINT (-73.9618064639153 40.792158440043)
298 -73.957342596188 40.7944359654227 37E-PM-1006-09 37E PM 10062018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 0 moseying 0 0 0 0 1 1 0 0   POINT (-73.957342596188 40.7944359654227)
314 -73.960601067176 40.7917243850136 32D-PM-1006-09 32D PM 10062018 9 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 1 0 0   POINT (-73.960601067176 40.7917243850136)
482 -73.97217978245759 40.7801213843628 16A-PM-1019-07 16A PM 10192018 7 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 0 0 approaches (very friendly) POINT (-73.9721797824576 40.7801213843628)
644 -73.97221256300399 40.776131146585705 13C-PM-1019-05 13C PM 10192018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 1 1 0   POINT (-73.972212563004 40.7761311465857)
682 -73.9651828383592 40.780282094386294 19F-PM-1017-06 19F PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 1 0 0   0 0 0 0 1 1 0 0   POINT (-73.9651828383592 40.7802820943863)
859 -73.9600964585868 40.7952339524416 36B-PM-1013-02 36B PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 1 1 0 1   POINT (-73.9600964585868 40.7952339524416)
1106 -73.97029709193171 40.7696883113413 7H-PM-1006-08 07H PM 10062018 8 Adult Gray White Gray+White   Ground Plane FALSE in grass 0 0 0 0 1   0 0 0 0 1 1 0 1   POINT (-73.9702970919317 40.7696883113413)
1111 -73.96327993398721 40.7808316436308 21H-PM-1018-01 21H PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 staring 0 0 0 0 1 1 0 0   POINT (-73.9632799339872 40.7808316436308)
1214 -73.9699517492486 40.7753169595373 13F-PM-1008-01 13F PM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 1 0 0   POINT (-73.9699517492486 40.7753169595373)
1312 -73.97120343207409 40.7764415506669 13D-PM-1018-05 13D PM 10182018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 1 0   POINT (-73.9712034320741 40.7764415506669)
1366 -73.97115821991021 40.7783674409485 15C-PM-1017-05 15C PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   1 0 0 0 1 1 0 0   POINT (-73.9711582199102 40.7783674409485)
1704 -73.9624052832372 40.7809656348254 21H-PM-1018-04 21H PM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 0 0   POINT (-73.9624052832372 40.7809656348254)
1725 -73.96574800660741 40.7753465489231 14I-PM-1018-04 14I PM 10182018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 1 0 0   POINT (-73.9657480066074 40.7753465489231)
2030 -73.9749251267433 40.7679111971294 4F-PM-1013-01 04F PM 10132018 1 Adult Cinnamon Gray, Black Cinnamon+Gray, Black   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 1 0 0   POINT (-73.9749251267433 40.7679111971294)
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)
2358 -73.9788379085607 40.7683896583055 2C-PM-1013-06 02C PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 cleaning face & tail 0 0 0 0 1 1 0 0   POINT (-73.9788379085607 40.7683896583055)
2610 -73.9713379914423 40.7696367609606 7H-PM-1006-01 07H PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE middle of grass 0 0 0 1 1   0 0 0 0 1 1 0 0   POINT (-73.9713379914423 40.7696367609606)
2670 -73.95310419064691 40.7919916819219 36I-PM-1007-02 36I PM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 1 1 1 0 chased birds (blue jay) POINT (-73.9531041906469 40.7919916819219)
2782 -73.9563473341712 40.7893712398425 32H-PM-1006-03 32H PM 10062018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 1 0 1   POINT (-73.9563473341712 40.78937123984251)

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