2018_Central_Park_Squirrel_Census_-_Squirrel_Data

83 rows where Above Ground Sighter Measurement = "FALSE", Highlight Fur Color = "Cinnamon" and Tail twitches = 1 sorted by Runs from

✎ View and edit SQL

This data as json, CSV (advanced)

Kuks ✖

  • 0 49
  • 1 1

Highlight Fur Color ✖

  • Cinnamon · 50 ✖

Above Ground Sighter Measurement ✖

  • FALSE · 50 ✖
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
1316 1316 -73.9674724790652 40.7768771349868 15G-PM-1019-01 15G PM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9674724790652 40.7768771349868)
1366 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)
1511 1511 -73.9721642509914 40.7701179390078 7G-AM-1010-01 07G AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9721642509914 40.7701179390078)
1578 1578 -73.97352989433209 40.771493999358896 8E-AM-1013-02 08E AM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9735298943321 40.7714939993589)
1586 1586 -73.9714150090362 40.7774976423922 14C-PM-1006-03 14C PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9714150090362 40.7774976423922)
1614 1614 -73.9806718258385 40.7692776896995 2A-AM-1010-07 02A AM 10102018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 0 0 couldn't get near POINT (-73.9806718258385 40.76927768969951)
1668 1668 -73.97469348106671 40.7659431884158 2G-PM-1007-02 02G PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 burying nut 0 0 0 0 1 0 1 0   POINT (-73.9746934810667 40.7659431884158)
1703 1703 -73.956998502609 40.7948117428147 37E-PM-1006-01 37E PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.956998502609 40.7948117428147)
1704 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)
1948 1948 -73.9738410069766 40.7691686156505 5F-PM-1007-06 05F PM 10072018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 jumping on fence 0 0 0 0 1 0 1 0   POINT (-73.9738410069766 40.7691686156505)
1973 1973 -73.957138759793 40.795592603505504 38D-PM-1006-02 38D PM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.957138759793 40.7955926035055)
1975 1975 -73.9753291616796 40.7687376032936 4E-PM-1008-01 04E PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9753291616796 40.7687376032936)
2109 2109 -73.9744488584414 40.7741627220859 10C-PM-1013-03 10C PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9744488584414 40.7741627220859)
2133 2133 -73.9736164871197 40.7725695048569 8D-PM-1007-04 08D PM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9736164871197 40.7725695048569)
2147 2147 -73.9651217998407 40.7761115392738 15I-PM-1012-01 15I PM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9651217998407 40.7761115392738)
2159 2159 -73.9696688162449 40.774142217718705 12F-AM-1020-05 12F AM 10202018 5 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.9696688162449 40.7741422177187)
2275 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)
2302 2302 -73.9754333866435 40.773239091613796 8C-PM-1013-01 08C PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9754333866435 40.7732390916138)
2320 2320 -73.9576897478787 40.796469532845705 38C-AM-1019-02 38C AM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9576897478787 40.7964695328457)
2321 2321 -73.9743060404813 40.7687901781431 5F-PM-1007-02 05F PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9743060404813 40.7687901781431)
2324 2324 -73.9737247632185 40.7759469280872 12C-PM-1017-01 12C PM 10172018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0 digging/burying,drinking from lake 0 0 0 0 1 0 1 0   POINT (-73.9737247632185 40.7759469280872)
2382 2382 -73.97439704555329 40.7687880243986 5F-PM-1007-01 05F PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9743970455533 40.7687880243986)
2489 2489 -73.9663168490265 40.7825083721362 21D-AM-1008-01 21D AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 1 1 0 1 0   POINT (-73.9663168490265 40.7825083721362)
2553 2553 -73.9714744574918 40.7736266158925 10E-AM-1010-01 10E AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9714744574918 40.7736266158925)
2833 2833 -73.9552595564798 40.7889533029466 32I-PM-1007-01 32I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 1 1 chirps 0 0 0 0 1 0 1 0   POINT (-73.9552595564798 40.7889533029466)
2961 2961 -73.9736238258579 40.7688712771191 5F-PM-1007-04 05F PM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9736238258579 40.7688712771191)
209 209 -73.97107601968679 40.7725506006789 10F-PM-1019-02 10F PM 10192018 2 Juvenile Gray Cinnamon Gray+Cinnamon Cinnamon head & stripe Ground Plane FALSE Behind fence, grass 1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9710760196868 40.7725506006789)
232 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)
312 312 -73.958356112357 40.796014459571 38C-AM-1019-07 38C AM 10192018 7 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.958356112357 40.796014459571)
403 403 -73.9597470659927 40.797321593541604 38A-PM-1013-01 38A PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9597470659927 40.7973215935416)
513 513 -73.96310068980699 40.7920255189467 32B-AM-1017-02 32B AM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon Cinnamon on its head Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.963100689807 40.79202551894671)
522 522 -73.97738211356109 40.769045349438294 4C-PM-1010-06 04C PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE behind playground benches 0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9773821135611 40.7690453494383)
533 533 -73.9652584749758 40.7803011124382 19F-PM-1017-04 19F PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9652584749758 40.7803011124382)
628 628 -73.96001657854859 40.795246676183204 36B-PM-1013-03 36B PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9600165785486 40.7952466761832)
697 697 -73.97046560040201 40.770112577324795 7H-PM-1006-05 07H PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ran across path to eat behind fence, next to the fence. 1 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.970465600402 40.7701125773248)
720 720 -73.9669814346326 40.780390919948 19E-PM-1018-01 19E PM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9669814346326 40.780390919948)
779 779 -73.9745305540008 40.7742043234014 10C-PM-1013-02 10C PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 1   POINT (-73.9745305540008 40.7742043234014)
837 837 -73.9557172336815 40.79211256577221 35G-PM-1006-01 35G PM 10062018 1 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9557172336815 40.7921125657722)
1090 1090 -73.967767372181 40.784702631615 23B-PM-1012-07 23B PM 10122018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.967767372181 40.784702631615)
1159 1159 -73.9682129261841 40.77542323581179 14G-AM-1012-03 14G AM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9682129261841 40.7754232358118)
1484 1484 -73.9716736557408 40.7749333494336 12E-AM-1017-07 12E AM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9716736557408 40.7749333494336)
1754 1754 -73.9652134469963 40.7803438278765 19F-PM-1017-05 19F PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9652134469963 40.7803438278765)
1884 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)
1896 1896 -73.973998077367 40.773902913391105 10C-PM-1013-01 10C PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.973998077367 40.7739029133911)
2137 2137 -73.96488316116292 40.780132641497296 19G-PM-1017-02 19G PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 patting ground 0 0 0 0 1 0 0 1   POINT (-73.9648831611629 40.7801326414973)
2271 2271 -73.96739494580959 40.7826218539496 21D-AM-1008-04 21D AM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9673949458096 40.78262185394961)
2342 2342 -73.9533645762606 40.7983709215535 42F-AM-1019-01 42F AM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 1 0 0 1 runs from (me) POINT (-73.9533645762606 40.7983709215535)
2472 2472 -73.9596820155238 40.7932886803231 34D-PM-1007-03 34D PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9596820155238 40.7932886803231)
2963 2963 -73.9687020800791 40.7735903424522 11H-AM-1010-08 11H AM 10102018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9687020800791 40.7735903424522)
2969 2969 -73.9654409838612 40.7901338748522 29A-AM-1013-01 29A AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 climbed tree (oak) 0 0 0 0 1 0 0 1   POINT (-73.9654409838612 40.7901338748522)

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