2018_Central_Park_Squirrel_Census_-_Squirrel_Data

53 rows where Date = 10172018, Foraging = 0 and Shift = "AM" sorted by Approaches

✎ View and edit SQL

This data as json, CSV (advanced)

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

Tail twitches ✖

  • 0 46
  • 1 7

Shift ✖

Moans ✖

  • 0 53

Foraging ✖

Date ✖

  • 10172018 · 53 ✖
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
44 44 -73.970252675331 40.7705999588222 8H-AM-1017-06 08H AM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   0 1 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.970252675331 40.77059995882221)
251 251 -73.95708175790921 40.7964221087879 38D-AM-1017-02 38D AM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 hiding in log 0 0 0 0 0 0 1 0   POINT (-73.9570817579092 40.7964221087879)
293 293 -73.9696173677837 40.7705202790525 8H-AM-1017-04 08H AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9696173677837 40.7705202790525)
300 300 -73.9528149779809 40.7924984810637 36I-AM-1017-06 36I AM 10172018 6 Adult Gray Black Gray+Black Darker than others Above Ground 10 Running down tree 1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9528149779809 40.7924984810637)
364 364 -73.9623696148045 40.792184861375 32B-AM-1017-04 32B AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9623696148045 40.792184861375)
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)
552 552 -73.9625416200877 40.7811302397912 21H-AM-1017-02 21H AM 10172018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 1   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9625416200877 40.78113023979121)
573 573 -73.9674688433583 40.7789728381912 17E-AM-1017-06 17E AM 10172018 6 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9674688433583 40.7789728381912)
618 618 -73.957976896139 40.797027128241 39C-AM-1017-04 39C AM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.957976896139 40.797027128241005)
629 629 -73.95737241332641 40.7980080911115 40C-AM-1017-02 40C AM 10172018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 1 0 chasing (#1) 0 0 0 0 0 0 0 1   POINT (-73.9573724133264 40.7980080911115)
683 683 -73.97076836215841 40.775981556612294 13E-AM-1017-11 13E AM 10172018 11 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   on/in log 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9707683621584 40.77598155661231)
703 703 -73.95763044737221 40.795981062234205 38D-AM-1017-05 38D AM 10172018 5 Adult Gray Black, Cinnamon Gray+Black, Cinnamon Black stripe along sides Ground Plane FALSE   1 0 0 1 0 eating (nut) 0 0 0 0 0 0 0 1   POINT (-73.9576304473722 40.7959810622342)
713 713 -73.956200809768 40.798181446265 40C-AM-1017-06 40C AM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.956200809768 40.798181446265)
724 724 -73.9532952763106 40.792007446262204 36I-AM-1017-08 36I AM 10172018 8 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0 chasing (#7) 0 0 0 0 1 0 0 1 runs from (me) POINT (-73.95329527631061 40.7920074462622)
758 758 -73.9703621616472 40.775032271482 12E-AM-1017-08 12E AM 10172018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1   0 0 0 1 0 chilling 0 0 0 0 0 0 1 0   POINT (-73.9703621616472 40.775032271482)
764 764 -73.9746608786299 40.7776092078254 13A-AM-1017-01 13A AM 10172018 1 Adult Gray   Gray+   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9746608786299 40.7776092078254)
778 778 -73.9677054870327 40.778992870166 17E-AM-1017-03 17E AM 10172018 3 Adult Gray   Gray+   Above Ground 9 Tree trunk 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9677054870327 40.778992870166)
796 796 -73.9706641770728 40.77592292137621 13E-AM-1017-12 13E AM 10172018 12 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9706641770728 40.7759229213762)
900 900 -73.9626527908786 40.7912472380247 31B-AM-1017-03 31B AM 10172018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9626527908786 40.7912472380247)
1054 1054 -73.9570050460867 40.7985192250745 40C-AM-1017-05 40C AM 10172018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9570050460867 40.7985192250745)
1062 1062 -73.957259673402 40.7974442913898 39C-AM-1017-02 39C AM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.957259673402 40.7974442913898)
1070 1070 -73.9674631254594 40.7790076357696 17E-AM-1017-10 17E AM 10172018 10 Juvenile Gray   Gray+   Above Ground 2 Fence 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9674631254594 40.7790076357696)
1072 1072 -73.9566571713254 40.798985577543505 41C-AM-1017-04 41C AM 10172018 4   Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9566571713254 40.7989855775435)
1171 1171 -73.9573477643797 40.797173406050895 39C-AM-1017-01 39C AM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9573477643797 40.7971734060509)
1229 1229 -73.9677751507448 40.779099006665795 17E-AM-1017-11 17E AM 10172018 11 Adult Gray   Gray+   Ground Plane FALSE Shore 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9677751507448 40.7790990066658)
1323 1323 -73.97443873476259 40.7776953143835 13A-AM-1017-03 13A AM 10172018 3 Adult Cinnamon   Cinnamon+         0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9744387347626 40.7776953143835)
1353 1353 -73.9636476467218 40.7775556986702 18I-AM-1017-01 18I AM 10172018 1 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9636476467218 40.7775556986702)
1390 1390 -73.9677146741772 40.77882313323371 17E-AM-1017-07 17E AM 10172018 7 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9677146741772 40.7788231332337)
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)
1491 1491 -73.97130702170709 40.7753795014815 12E-AM-1017-05 12E AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9713070217071 40.7753795014815)
1499 1499 -73.96252055381709 40.7810785055136 21H-AM-1017-01 21H AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9625205538171 40.7810785055136)
1611 1611 -73.9655238539833 40.7815633947684 21E-AM-1017-03 21E AM 10172018 3 Adult Gray   Gray+   Above Ground 7   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9655238539833 40.7815633947684)
1792 1792 -73.97057045274809 40.7762853012151 13E-AM-1017-06 13E AM 10172018 6 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9705704527481 40.7762853012151)
1821 1821 -73.9676314068477 40.7788030406918 17E-AM-1017-08 17E AM 10172018 8 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9676314068477 40.7788030406918)
1886 1886 -73.956806913988 40.7987736900857 41C-AM-1017-06 41C AM 10172018 6 Adult Gray   Gray+   Above Ground 4   0 0 1 0 0   1 0 0 0 0 0 1 0   POINT (-73.956806913988 40.7987736900857)
1988 1988 -73.957138794884 40.7985389822719 40C-AM-1017-03 40C AM 10172018 3 Adult Gray White Gray+White         1 1 1 0 0 chasing (#4),digging 0 0 0 0 1 0 1 0   POINT (-73.957138794884 40.7985389822719)
2084 2084 -73.9567255763265 40.7936331899263 36F-AM-1017-05 36F AM 10172018 5 Adult Gray White Gray+White   Above Ground 8   0 0 0 0 0 staying very still to avoid two very curious dogs on the ground 0 0 0 0 0 0 0 0 petrified,frozen (tail over its back,frozen) POINT (-73.9567255763265 40.7936331899263)
2182 2182 -73.9573656523498 40.7979754563974 40C-AM-1017-01 40C AM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0 chasing (#2) 0 0 0 0 0 0 0 1   POINT (-73.9573656523498 40.7979754563974)
2206 2206 -73.95944460183459 40.7917800352042 33D-AM-1017-06 33D AM 10172018 6 Adult Black   Black+   Above Ground 10   0 0 1 0 0   1 1 0 0 0 0 0 1 runs from (ran into hole in tree trunk) POINT (-73.9594446018346 40.7917800352042)
2246 2246 -73.9711607544742 40.774988247642 12E-AM-1017-04 12E AM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9711607544742 40.774988247642)
2293 2293 -73.9675309175947 40.7788649926486 17E-AM-1017-09 17E AM 10172018 9 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9675309175947 40.7788649926486)
2327 2327 -73.9567801028221 40.7960096659564 38D-AM-1017-01 38D AM 10172018 1       +   Above Ground 30   0 0 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9567801028221 40.7960096659564)
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)
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)
2514 2514 -73.95744422055 40.7961046528557 38D-AM-1017-04 38D AM 10172018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.95744422055 40.7961046528557)
2678 2678 -73.95629468736941 40.7938593012595 36F-AM-1017-01 36F AM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (dog) POINT (-73.9562946873694 40.7938593012595)
2698 2698 -73.9744917362668 40.77783887377 13A-AM-1017-02 13A AM 10172018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9744917362668 40.77783887377)
2731 2731 -73.9595886063173 40.7918405182594 33D-AM-1017-09 33D AM 10172018 9 Adult Black Cinnamon Black+Cinnamon   Above Ground 7   0 0 1 0 0   1 1 0 0 0 0 1 1   POINT (-73.9595886063173 40.7918405182594)
2748 2748 -73.960094705031 40.7916066137699 33D-AM-1017-01 33D AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.960094705031 40.7916066137699)
2866 2866 -73.9744025383371 40.7777296605765 13A-AM-1017-04 13A AM 10172018 4 Adult Gray   Gray+         1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9744025383371 40.7777296605765)
2908 2908 -73.96542881512659 40.7815953970174 21E-AM-1017-02 21E AM 10172018 2 Adult Gray   Gray+   Above Ground 7   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9654288151266 40.7815953970174)
2974 2974 -73.9575791421589 40.7959934459432 38D-AM-1017-06 38D AM 10172018 6 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9575791421589 40.7959934459432)
3007 3007 -73.9635140434993 40.7912807969365 31B-AM-1017-01 31B AM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9635140434993 40.7912807969365)

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