2018_Central_Park_Squirrel_Census_-_Squirrel_Data

152 rows where Date = 10172018 and Eating = 0 sorted by Primary Fur Color descending

✎ View and edit SQL

This data as json, CSV (advanced)

Hectare Squirrel Number ✖

Eating ✖

Date ✖

  • 10172018 · 52 ✖
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
2541 2541 -73.9579097104326 40.797227339471604 39C-AM-1017-03 39C AM 10172018 3 Adult Gray Black Gray+Black   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9579097104326 40.7972273394716)
2616 2616 -73.9675917702187 40.7789922281625 17E-AM-1017-02 17E AM 10172018 2 Adult Gray   Gray+   Above Ground 8 Shore 0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9675917702187 40.7789922281625)
2643 2643 -73.9693719015914 40.7768710160557 14E-PM-1017-02 14E PM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 staring 0 0 0 0 0 0 0 0   POINT (-73.9693719015914 40.7768710160557)
2649 2649 -73.9706428641753 40.7762933936464 13E-AM-1017-07 13E AM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9706428641753 40.7762933936464)
2656 2656 -73.97239959684201 40.7788765078432 15B-PM-1017-04 15B PM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE on hill 0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.972399596842 40.7788765078432)
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)
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)
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)
2697 2697 -73.9710674928906 40.7778757544025 15D-PM-1017-06 15D PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 walking 0 0 0 0 0 0 0 0 stopped and watched me before slowly moving on POINT (-73.9710674928906 40.7778757544025)
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)
2721 2721 -73.95519234082391 40.796830266140205 40E-PM-1017-01 40E PM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9551923408239 40.7968302661402)
2728 2728 -73.9507140045973 40.7957700986293 41I-PM-1017-01 41I PM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon oval on back Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9507140045973 40.7957700986293)
2747 2747 -73.971314838366 40.774951285041 12E-AM-1017-03 12E AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.971314838366 40.774951285041)
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)
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)
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)
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)
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)
2932 2932 -73.9705837974358 40.775849484967296 13E-AM-1017-13 13E AM 10172018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE on rock 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.97058379743581 40.7758494849673)
2964 2964 -73.9703604542938 40.776269022329394 13E-AM-1017-04 13E AM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9703604542938 40.7762690223294)
358 358 -73.96356587864159 40.7777291777901 18I-AM-1017-03 18I AM 10172018 3 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9635658786416 40.77772917779011)
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)
651 651 -73.9801661903932 40.7697950141751 3A-PM-1017-03 03A PM 10172018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9801661903932 40.7697950141751)
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)
844 844 -73.9642379942652 40.777479252073796 17I-PM-1017-01 17I PM 10172018 1 Juvenile Cinnamon White Cinnamon+White   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0 was in a tree,so i couldn't really tell POINT (-73.9642379942652 40.7774792520738)
1050 1050 -73.9562642076935 40.798333876307396 41C-AM-1017-02 41C AM 10172018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9562642076935 40.7983338763074)
1132 1132 -73.9798390387307 40.7700761090896 3A-PM-1017-07 03A PM 10172018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9798390387307 40.7700761090896)
1276 1276 -73.9798005188704 40.7691868791734 3A-PM-1017-01 03A PM 10172018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.97980051887042 40.7691868791734)
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)
1712 1712 -73.9801899519657 40.7695777009264 3A-PM-1017-02 03A PM 10172018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9801899519657 40.7695777009264)
1832 1832 -73.9693159934697 40.7831212338295 21B-PM-1017-03 21B PM 10172018 3 Juvenile Cinnamon White Cinnamon+White   Above Ground 1   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9693159934697 40.7831212338295)
1916 1916 -73.9693504617353 40.7830678709405 21B-PM-1017-02 21B PM 10172018 2 Juvenile Cinnamon White Cinnamon+White   Above Ground 1   0 1 0 0 0   0 1 0 0 0 0 0 0 stood on hind legs with front legs on the chest POINT (-73.9693504617353 40.7830678709405)
2114 2114 -73.9651541395415 40.7798283208748 19G-PM-1017-01 19G PM 10172018 1 Adult Cinnamon White Cinnamon+White   Above Ground 12   0 0 0 0 0 watching 0 0 0 0 0 1 0 0   POINT (-73.9651541395415 40.7798283208748)
2493 2493 -73.954767265558 40.7973243644491 40E-PM-1017-03 40E PM 10172018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.954767265558 40.7973243644491)
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)
2746 2746 -73.95614328368629 40.798266534723396 41C-AM-1017-07 41C AM 10172018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9561432836863 40.7982665347234)
2989 2989 -73.9643538221947 40.7917565604735 31A-PM-1017-01 31A PM 10172018 1 Juvenile Cinnamon Gray, White Cinnamon+Gray, White Gray lower back, Gray & Cinnamon selected as Primary with "lower back" written in next to Gray. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9643538221947 40.7917565604735)
50 50 -73.96806350709491 40.779249873647 17E-AM-1017-05 17E AM 10172018 5 Adult Black   Black+   Above Ground 10 Branch 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9680635070949 40.779249873647)
430 430 -73.9710116801402 40.7723689301989 10G-PM-1017-08 10G PM 10172018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9710116801402 40.7723689301989)
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)
770 770 -73.95977827620291 40.79207733767571 33D-AM-1017-07 33D AM 10172018 7 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 1 0 1 0 0 1 0   POINT (-73.9597782762029 40.7920773376757)
1057 1057 -73.9594406225891 40.7918533707789 33D-AM-1017-02 33D AM 10172018 2 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 0 0   POINT (-73.9594406225891 40.7918533707789)
1149 1149 -73.960237785199 40.7907831607574 32E-PM-1017-16 32E PM 10172018 16 Adult Black   Black+   Ground Plane FALSE rocky outcrop 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.960237785199 40.7907831607574)
1210 1210 -73.97079374645409 40.772528270844795 10G-PM-1017-07 10G PM 10172018 7 Adult Black White Black+White   Ground Plane FALSE   0 0 0 0 0 traveling 0 0 0 0 0 0 1 0   POINT (-73.9707937464541 40.7725282708448)
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)
2192 2192 -73.9593410965431 40.7923134010383 33D-AM-1017-08 33D AM 10172018 8 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9593410965431 40.7923134010383)
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)
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)
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)
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)
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)

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