2018_Central_Park_Squirrel_Census_-_Squirrel_Data

44 rows where Date = 10172018, Eating = 0 and Running = 1 sorted by Unique Squirrel ID

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Foraging, Other Activities, Kuks, Tail twitches, Approaches, Indifferent, Runs from

Hectare Squirrel Number ✖

Running ✖

Eating ✖

Date ✖

  • 10172018 · 44 ✖
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
1717 1717 -73.97149520927671 40.7748063281815 12E-AM-1017-02 12E AM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9714952092767 40.7748063281815)
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)
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)
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)
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)
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)
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)
2890 2890 -73.9726236083428 40.7788217771475 15B-PM-1017-03 15B PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE by water 1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9726236083428 40.778821777147506)
542 542 -73.9713487591577 40.7784353043714 15C-PM-1017-03 15C PM 10172018 3 Adult Black   Black+   Above Ground 17 running across overpass 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9713487591577 40.7784353043714)
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)
805 805 -73.97068515461841 40.7780777016038 15D-PM-1017-04 15D PM 10172018 4 Adult Cinnamon   Cinnamon+   Above Ground 2 on fence 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9706851546184 40.7780777016038)
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)
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)
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)
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)
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)
1426 1426 -73.9664986446294 40.778308334318 17G-PM-1017-02 17G PM 10172018 2 Adult Gray   Gray+   Above Ground 15   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9664986446294 40.778308334318)
2071 2071 -73.96676944398949 40.7779501809095 17G-PM-1017-03 17G PM 10172018 3 Adult Gray White Gray+White   Above Ground 10 tree & ground 1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9667694439895 40.7779501809095)
1182 1182 -73.9667206046912 40.777999356509795 17G-PM-1017-04 17G PM 10172018 4 Adult Gray White Gray+White   Above Ground 10 tree & ground 1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9667206046912 40.7779993565098)
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)
682 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)
2658 2658 -73.9690212174 40.783409940410706 21B-PM-1017-05 21B PM 10172018 5 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9690212174 40.7834099404107)
1731 1731 -73.9692846326638 40.7841049008492 22A-PM-1017-02 22A PM 10172018 2 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9692846326638 40.7841049008492)
930 930 -73.96220300857941 40.7917723228749 32B-AM-1017-01 32B AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 ran up a tree 1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9622030085794 40.7917723228749)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
2460 2460 -73.9526681107152 40.7977012009146 42F-PM-1017-01 42F PM 10172018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0 playing 0 0 0 0 0 0 1 0   POINT (-73.9526681107152 40.7977012009146)
438 438 -73.95257475169142 40.7977257435263 42F-PM-1017-02 42F PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 playing 0 0 0 0 0 0 1 0   POINT (-73.95257475169142 40.7977257435263)
2836 2836 -73.953092053256 40.7982256930243 42F-PM-1017-03 42F PM 10172018 3   Gray Cinnamon Gray+Cinnamon         1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.953092053256 40.7982256930243)
2840 2840 -73.9532163535175 40.7982970313067 42F-PM-1017-04 42F PM 10172018 4   Gray   Gray+         1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9532163535175 40.7982970313067)
240 240 -73.9767080512177 40.7717708794221 6B-PM-1017-04 06B PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9767080512177 40.7717708794221)
2148 2148 -73.9767317539505 40.7717600450632 6B-PM-1017-05 06B PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9767317539505 40.7717600450632)
763 763 -73.9767455430709 40.7717866237826 6B-PM-1017-06 06B PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9767455430709 40.7717866237826)
2513 2513 -73.9767590273554 40.7717561807266 6B-PM-1017-07 06B PM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9767590273554 40.7717561807266)
1179 1179 -73.9696762034757 40.7704883494264 8H-AM-1017-02 08H AM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7 root bed of tree 1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9696762034757 40.7704883494264)
2694 2694 -73.969628583287 40.770406779793205 8H-AM-1017-03 08H AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 fence 1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.969628583287 40.7704067797932)

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.234ms