2018_Central_Park_Squirrel_Census_-_Squirrel_Data

57 rows where Location = "Above Ground", Shift = "AM" and Tail twitches = 1 sorted by Tail twitches

✎ View and edit SQL

This data as json, CSV (advanced)

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

Tail twitches ✖

Shift ✖

Location ✖

  • Above Ground · 57 ✖
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)
109 109 -73.967097592707 40.785411934253794 24B-AM-1013-01 24B AM 10132018 1   Gray   Gray+   Above Ground 50   1 0 0 1 0 took nut to bury 0 0 0 0 1 0 0 1   POINT (-73.967097592707 40.7854119342538)
110 110 -73.97113187902791 40.7701941550273 7G-AM-1010-02 07G AM 10102018 2 Adult Gray   Gray+   Above Ground 3   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9711318790279 40.7701941550273)
137 137 -73.97824171151392 40.77246650364471 7A-AM-1006-01 07A AM 10062018 1 Adult Gray White Gray+White   Above Ground 10 in tree 0 0 0 0 1   0 1 0 0 1 0 0 0 looked at us POINT (-73.9782417115139 40.7724665036447)
326 326 -73.9699843570636 40.7729480440312 10G-AM-1006-01 10G AM 10062018 1 Adult Gray   Gray+   Above Ground 80   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.96998435706361 40.7729480440312)
335 335 -73.97823514358521 40.7715896672335 6A-AM-1006-03 06A AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree 0 1 0 1 0   0 0 0 1 1 0 0 0   POINT (-73.9782351435852 40.7715896672335)
380 380 -73.9649590119935 40.782210792076896 21F-AM-1018-01 21F AM 10182018 1 Adult Gray   Gray+   Above Ground 15   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9649590119935 40.7822107920769)
506 506 -73.9649611089685 40.7814371834837 21F-AM-1018-05 21F AM 10182018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9649611089685 40.7814371834837)
508 508 -73.97469187620759 40.765523188367794 1G-AM-1006-02 01G AM 10062018 2 Juvenile Gray White Gray+White   Above Ground 30   0 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9746918762076 40.7655231883678)
510 510 -73.9638590768396 40.777678211498106 18I-AM-1017-02 18I AM 10172018 2 Adult Gray Black Gray+Black   Above Ground 15   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9638590768396 40.7776782114981)
534 534 -73.9650499507011 40.7908191782173 30A-AM-1010-01 30A AM 10102018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9650499507011 40.7908191782173)
547 547 -73.9559677963727 40.7951124076946 38E-AM-1010-07 38E AM 10102018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 branches 1 1 0 0 0 chasing and being chased by #6 0 0 0 0 1 0 0 1   POINT (-73.9559677963727 40.7951124076946)
588 588 -73.9646597452128 40.7827698220703 22F-AM-1007-07 22F AM 10072018 7 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3   0 0 1 0 0   0 0 0 0 1 0 0 0 alert & aware POINT (-73.9646597452128 40.7827698220703)
641 641 -73.97190362174459 40.7803588122409 17A-AM-1017-01 17A AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3 ground & tree 1 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.9719036217446 40.7803588122409)
647 647 -73.9734762649298 40.7663703404546 3H-AM-1008-05 03H AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   0 0 1 0 0   0 0 0 0 1 0 0 0   POINT (-73.9734762649298 40.7663703404546)
650 650 -73.98096101171708 40.7683896665502 2A-AM-1010-02 02A AM 10102018 2   Gray Cinnamon Gray+Cinnamon   Above Ground   perched on small fence 0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9809610117171 40.7683896665502)
702 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)
733 733 -73.9764397550289 40.7737004557104 8B-AM-1007-01 08B AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9764397550289 40.7737004557104)
820 820 -73.9801902133148 40.769557595068 3A-AM-1012-03 03A AM 10122018 3 Juvenile Gray Black, Cinnamon Gray+Black, Cinnamon Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. Above Ground 1   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9801902133148 40.769557595068)
923 923 -73.9578924882613 40.789806297824 32G-AM-1010-02 32G AM 10102018 2 Adult Gray   Gray+   Above Ground 13   0 0 1 1 0   0 0 0 0 1 0 0 1   POINT (-73.9578924882613 40.789806297824)
1048 1048 -73.9782120139407 40.7717154468791 6A-AM-1006-05 06A AM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 tree 0 0 1 0 0   0 0 0 1 1 0 0 0 curious POINT (-73.9782120139407 40.7717154468791)
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)
1118 1118 -73.9719460335398 40.7810508156287 18A-AM-1012-01 18A AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White White tail Above Ground 3 tree 1 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.9719460335398 40.7810508156287)
1138 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)
1164 1164 -73.97902264006291 40.76989976537921 4B-AM-1010-01 04B AM 10102018 1 Adult Gray Black, Cinnamon Gray+Black, Cinnamon   Above Ground 2   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9790226400629 40.7698997653792)
1235 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)
1241 1241 -73.9651817987035 40.781908283833396 21E-AM-1017-01 21E AM 10172018 1 Adult Gray White Gray+White   Above Ground 3 Climbs small tree 0 0 0 1 1   0 0 0 0 1 0 0 0 walks from POINT (-73.9651817987035 40.7819082838334)
1297 1297 -73.9802831706033 40.7692763295564 3A-AM-1012-02 03A AM 10122018 2 Adult Gray Black, Cinnamon Gray+Black, Cinnamon Gray & Cinnamon selected as Primary. Black & Cinnamon selected as Highlights. Made executive adjustments. Above Ground 1   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9802831706033 40.7692763295564)
1381 1381 -73.9586077039567 40.796189647707706 38C-AM-1019-10 38C AM 10192018 10 Adult Gray White Gray+White   Above Ground 20   1 0 1 1 0   1 0 0 0 1 0 0 1   POINT (-73.9586077039567 40.7961896477077)
1394 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)
1410 1410 -73.95879132892291 40.7961707624534 38C-AM-1019-11 38C AM 10192018 11 Adult Gray White Gray+White   Above Ground 20   1 0 1 1 0   1 0 0 0 1 0 0 1   POINT (-73.9587913289229 40.7961707624534)
1413 1413 -73.98100322064279 40.768162563497896 1A-AM-1007-01 01A AM 10072018 1 Adult Gray White Gray+White   Above Ground 7   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9810032206428 40.7681625634979)
1500 1500 -73.9769969548024 40.7710711265211 6C-AM-1007-01 06C AM 10072018 1 Adult Gray White Gray+White vid! Above Ground 15   0 0 1 0 0   0 0 0 0 1 0 0 0 curious,but wary POINT (-73.97699695480242 40.7710711265211)
1553 1553 -73.9690645326017 40.7773822116124 15E-AM-1013-03 15E AM 10132018 3 Adult Gray   Gray+   Above Ground 2 on fallen log 0 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9690645326017 40.7773822116124)
1714 1714 -73.9763542780331 40.773653130362206 9B-AM-1010-02 09B AM 10102018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 1 in bush 0 0 1 0 1   0 0 0 0 1 0 0 1 froze POINT (-73.9763542780331 40.773653130362206)
1799 1799 -73.978844141973 40.7696046074378 4B-AM-1010-05 04B AM 10102018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10   0 1 0 0 0 chasing squirrel #6 1 1 0 0 1 0 0 0   POINT (-73.978844141973 40.7696046074378)
1804 1804 -73.98077710643099 40.7681635726316 1A-AM-1007-02 01A AM 10072018 2 Adult Gray White Gray+White   Above Ground 11   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.980777106431 40.7681635726316)
1867 1867 -73.9745204169071 40.7736282868469 9C-AM-1006-01 09C AM 10062018 1 Adult Gray   Gray+   Above Ground 40 Tree 1 0 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9745204169071 40.7736282868469)
1939 1939 -73.9540151828782 40.7920066170587 35H-AM-1013-01 35H AM 10132018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15 Climbing up tree 0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9540151828782 40.7920066170587)
1977 1977 -73.9586570546871 40.796349417475 38C-AM-1019-09 38C AM 10192018 9 Adult Gray White Gray+White Gray & White selected as Primary & Highlights. Made executive adjustments. Above Ground 3 Between ground & tree 0 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.9586570546871 40.796349417475)
2037 2037 -73.96833704175509 40.781359835050004 19D-AM-1007-02 19D AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 1 0 1   0 0 0 0 1 0 0 0 fenced area POINT (-73.9683370417551 40.78135983505)
2098 2098 -73.9700779726297 40.7722086251085 10G-AM-1006-11 10G AM 10062018 11 Juvenile Gray   Gray+   Above Ground 2   0 0 1 0 0   0 0 0 0 1 0 0 0   POINT (-73.9700779726297 40.7722086251085)
2135 2135 -73.9596251284566 40.7916254797561 33D-AM-1017-05 33D AM 10172018 5 Adult Black   Black+   Above Ground 5   0 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9596251284566 40.7916254797561)
2205 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)
2242 2242 -73.9565824187667 40.797312050952 40D-AM-1013-06 40D AM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   1 0 1 0 1   1 0 0 0 1 0 0 1   POINT (-73.9565824187667 40.797312050952)
2247 2247 -73.95595201371721 40.7950536287174 38E-AM-1010-06 38E AM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 branches 1 1 0 0 0 chasing and being chased by #7 0 0 0 0 1 0 1 0   POINT (-73.95595201371721 40.7950536287174)
2258 2258 -73.95477850811709 40.789612183711 33I-AM-1008-02 33I AM 10082018 2 Adult Gray   Gray+   Above Ground 3 edge of park @ 98th 0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9547785081171 40.789612183711)
2389 2389 -73.9801343393329 40.769151245340204 3A-AM-1012-01 03A AM 10122018 1 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 1   0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9801343393329 40.7691512453402)
2406 2406 -73.9668964315686 40.777757799088604 16G-AM-1010-01 16G AM 10102018 1 Adult Gray White Gray+White   Above Ground 3   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9668964315686 40.7777577990886)
2433 2433 -73.9706949930717 40.772362045852 10G-AM-1006-08 10G AM 10062018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 3   0 0 0 1 0   0 0 0 1 1 0 1 0   POINT (-73.9706949930717 40.772362045852)
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)
2487 2487 -73.9595222999173 40.7833202577782 25I-AM-1012-02 25I AM 10122018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 31 on tree 1 1 0 0 0   0 0 0 1 1 0 1 0   POINT (-73.9595222999173 40.7833202577782)
2495 2495 -73.9621253644004 40.7912082086879 31C-AM-1017-01 31C AM 10172018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 8   1 0 1 1 0   0 0 0 0 1 0 0 1   POINT (-73.9621253644004 40.7912082086879)
2586 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)
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)
2896 2896 -73.970595860252 40.7832060751268 20A-AM-1010-01 20A AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.970595860252 40.7832060751268)
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)

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