2018_Central_Park_Squirrel_Census_-_Squirrel_Data

165 rows where Above Ground Sighter Measurement = "FALSE", Eating = 1 and Highlight Fur Color = "Cinnamon" sorted by Location

✎ View and edit SQL

This data as json, CSV (advanced)

Tail twitches ✖

  • 0 56
  • 1 9

Highlight Fur Color ✖

  • Cinnamon · 65 ✖

Eating ✖

Above Ground Sighter Measurement ✖

  • FALSE · 65 ✖
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
1720 1720 -73.9725844658514 40.7701092834201 7F-PM-1012-02 07F PM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0 observes POINT (-73.9725844658514 40.7701092834201)
1734 1734 -73.9524132295658 40.7933777553406 37I-AM-1010-05 37I AM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.95241322956582 40.7933777553406)
1853 1853 -73.9721210372896 40.7667971476099 4I-AM-1006-02 04I AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9721210372896 40.7667971476099)
1868 1868 -73.97122650227809 40.778379099119206 15C-PM-1017-04 15C PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9712265022781 40.7783790991192)
1906 1906 -73.9700066659086 40.7744028820163 12F-PM-1007-13 12F PM 10072018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9700066659086 40.7744028820163)
1963 1963 -73.96515918613991 40.781183828857 20F-PM-1007-06 20F PM 10072018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9651591861399 40.781183828857)
1965 1965 -73.9719359643975 40.772699885583 9F-PM-1014-01 09F PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0 he is fed every day by a woman who calls him "chiquita"! he ran right up to her. POINT (-73.9719359643975 40.772699885583)
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)
1990 1990 -73.9774584305147 40.770813398619204 5B-AM-1008-02 05B AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9774584305147 40.7708133986192)
2023 2023 -73.9663977261879 40.775645134229 14H-PM-1012-08 14H PM 10122018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9663977261879 40.775645134229)
2047 2047 -73.9721656413591 40.7722869065638 9F-PM-1014-08 09F PM 10142018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0 turned to face me while eating POINT (-73.9721656413591 40.7722869065638)
2050 2050 -73.9555255950648 40.7977720808005 40D-AM-1013-04 40D AM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9555255950648 40.7977720808005)
2062 2062 -73.9618173092433 40.7925800181543 33B-PM-1010-04 33B PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9618173092433 40.7925800181543)
2063 2063 -73.95447632818859 40.7969645476349 40F-PM-1006-03 40F PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9544763281886 40.7969645476349)
2093 2093 -73.9597994674082 40.797298837759 38A-PM-1013-02 38A PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9597994674082 40.797298837759)
2106 2106 -73.9801651470389 40.767769865693495 1B-AM-1012-05 01B AM 10122018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9801651470389 40.7677698656935)
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)
2110 2110 -73.9647151303629 40.7912681060756 30A-PM-1020-03 30A PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Rock 0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9647151303629 40.7912681060756)
2121 2121 -73.9693462354257 40.776444438545205 14E-PM-1017-01 14E PM 10172018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9693462354257 40.7764444385452)
2127 2127 -73.9562442622553 40.7957285542564 38E-AM-1010-03 38E AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9562442622553 40.7957285542564)
2134 2134 -73.9614373639552 40.7945051962914 35B-PM-1013-01 35B PM 10132018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0 did not notice dog sitting a few yards away (10-20 ft) 0 0 0 1 0 0 1 0   POINT (-73.9614373639552 40.7945051962914)
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)
2169 2169 -73.9787736280005 40.7676126748454 2C-AM-1010-01 02C AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9787736280005 40.7676126748454)
2183 2183 -73.967334936601 40.7773289724189 16F-PM-1013-01 16F PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Woods 0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.967334936601 40.7773289724189)
2254 2254 -73.9709991016317 40.7725756707748 10F-PM-1019-03 10F PM 10192018 3 Juvenile Gray Cinnamon Gray+Cinnamon Cinnamon head Ground Plane FALSE Behind fence, grass 0 0 0 1 0 eating (nuts) 0 0 0 0 0 1 0 0 approaches (bad tourists w/ nuts) POINT (-73.9709991016317 40.772575670774806)
2290 2290 -73.95656457165641 40.795903994957705 38D-PM-1006-03 38D PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9565645716564 40.795903994957705)
2319 2319 -73.97568707891871 40.773364678267896 9B-AM-1010-09 09B AM 10102018 9 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0 food in mouth 0 0 0 0 0 0 0 0   POINT (-73.9756870789187 40.7733646782679)
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)
2325 2325 -73.9728360875598 40.7660637295671 3H-PM-1014-04 03H PM 10142018 4 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9728360875598 40.7660637295671)
2369 2369 -73.9801956082236 40.767836440957 1B-AM-1012-08 01B AM 10122018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9801956082236 40.767836440957)
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)
2423 2423 -73.973552877209 40.7715638228207 7E-PM-1013-01 07E PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ground & Tree Base 1 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.973552877209 40.7715638228207)
2424 2424 -73.9684752839242 40.776581626151795 15F-AM-1007-01 15F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 1   POINT (-73.9684752839242 40.7765816261518)
2431 2431 -73.9630054996358 40.790522514702204 30C-PM-1008-01 30C PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9630054996358 40.7905225147022)
2446 2446 -73.95227045119691 40.796566887896105 41G-AM-1013-01 41G AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9522704511969 40.7965668878961)
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)
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)
2507 2507 -73.964868521585 40.7821064183815 22F-PM-1014-01 22F PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.964868521585 40.7821064183815)
2575 2575 -73.97357533521291 40.7687061447032 5G-PM-1010-04 05G PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9735753352129 40.7687061447032)
2580 2580 -73.970795746101 40.77047272122989 8H-PM-1014-01 08H PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.970795746101 40.7704727212299)
2602 2602 -73.97548229388691 40.771776689383294 7C-PM-1020-01 07C PM 10202018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9754822938869 40.7717766893833)
2615 2615 -73.97346051766459 40.7686218881386 5G-PM-1010-02 05G PM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9734605176646 40.7686218881386)
2626 2626 -73.9737329655838 40.7726424441344 8D-PM-1007-02 08D PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9737329655838 40.7726424441344)
2635 2635 -73.97638367403421 40.7706121151491 5C-AM-1006-06 05C AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9763836740342 40.7706121151491)
2682 2682 -73.97110012783891 40.778746609584104 15C-PM-1017-01 15C PM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9711001278389 40.7787466095841)
2711 2711 -73.96288429601181 40.793804857240296 34A-PM-1013-01 34A PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1 took a chestnut 0 0 0 0 0 0 0 0   POINT (-73.9628842960118 40.7938048572403)
2720 2720 -73.9566300789162 40.7993692120774 42C-PM-1013-06 42C PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Between park and main drag 0 0 1 1 0   0 0 0 0 0 0 1 1   POINT (-73.9566300789162 40.7993692120774)
2769 2769 -73.9769885189342 40.7708936173356 5C-PM-1010-06 05C PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9769885189342 40.7708936173356)
2823 2823 -73.9664054327771 40.7756180893318 14H-PM-1012-07 14H PM 10122018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9664054327771 40.7756180893318)
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)
2845 2845 -73.9765016413674 40.77406728629529 9A-AM-1013-06 09A AM 10132018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9765016413674 40.7740672862953)
2846 2846 -73.96615704780291 40.7807271518813 20E-AM-1014-02 20E AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9661570478029 40.7807271518813)
2867 2867 -73.969370141813 40.7840721191988 22A-PM-1017-03 22A PM 10172018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.969370141813 40.7840721191988)
2871 2871 -73.9777124331985 40.7704051056666 5B-AM-1008-03 05B AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9777124331985 40.7704051056666)
2925 2925 -73.96721526968341 40.782387458182896 21D-AM-1008-05 21D AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9672152696834 40.7823874581829)
2936 2936 -73.9809876538513 40.768322324214296 1A-PM-1014-05 01A PM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9809876538513 40.7683223242143)
2954 2954 -73.9677474313377 40.7742119240825 12H-PM-1007-03 12H PM 10072018 3   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0 peanuts 0 0 0 0 0 0 1 0   POINT (-73.9677474313377 40.7742119240825)
2957 2957 -73.97473131521521 40.7653888351839 1G-PM-1010-03 01G PM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9747313152152 40.7653888351839)
2967 2967 -73.97132575863719 40.776271961946705 13D-AM-1014-09 13D AM 10142018 9 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9713257586372 40.7762719619467)
2980 2980 -73.97164145863809 40.771760114722 9F-PM-1014-06 09F PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0 running (from birds) 0 0 0 1 0 0 1 0   POINT (-73.9716414586381 40.771760114722)
2981 2981 -73.9800094828465 40.7677782585639 1B-AM-1012-04 01B AM 10122018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9800094828465 40.7677782585639)
2983 2983 -73.9689586689061 40.7839613907139 21B-PM-1017-04 21B PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9689586689061 40.7839613907139)
2993 2993 -73.95707222626929 40.798570614351895 40C-AM-1017-04 40C AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 1 1 chasing (#3) 0 0 0 0 0 0 1 0   POINT (-73.9570722262693 40.7985706143519)
2995 2995 -73.9668442742942 40.7870781042595 25B-PM-1007-01 25B PM 10072018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9668442742942 40.7870781042595)

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