2018_Central_Park_Squirrel_Census_-_Squirrel_Data

229 rows where Date = 10082018 and Running = 0 sorted by Date

✎ View and edit SQL

This data as json, CSV (advanced)

Hectare Squirrel Number ✖

Date ✖

  • 10082018 · 29 ✖
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
2625 2625 -73.96991885444591 40.7772180370053 15E-PM-1008-09 15E PM 10082018 9 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9699188544459 40.7772180370053)
2665 2665 -73.969784066769 40.77669404054029 14E-AM-1008-11 14E AM 10082018 11 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1 burying 0 0 0 0 0 0 1 0 curious POINT (-73.969784066769 40.7766940405403)
2675 2675 -73.9762227323096 40.768453603768 3E-PM-1008-02 03E PM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9762227323096 40.768453603768)
2680 2680 -73.9721348050673 40.7666920046704 3H-AM-1008-01 03H AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8   0 0 0 0 0 teasing barking dog 0 0 0 0 0 0 1 0 indifferent by not caring about dog POINT (-73.9721348050673 40.7666920046704)
2690 2690 -73.9572840457971 40.788693337174394 31H-PM-1008-04 31H PM 10082018 4 Adult Gray   Gray+   Above Ground   Also way up 0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.95728404579711 40.7886933371744)
2706 2706 -73.9745141185576 40.76914797812071 5E-AM-1008-01 05E AM 10082018 1 Adult Gray White Gray+White   Above Ground 2 on a checker table 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9745141185576 40.7691479781207)
2722 2722 -73.96922711321359 40.777528508844 15E-PM-1008-04 15E PM 10082018 4 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9692271132136 40.777528508844)
2724 2724 -73.96114340826671 40.7893671772846 30E-PM-1008-01 30E PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40   0 0 1 0 0   0 1 0 0 0 0 0 0   POINT (-73.9611434082667 40.7893671772846)
2725 2725 -73.9658867660358 40.7756523577509 15H-PM-1008-06 15H PM 10082018 6 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE base of gingko tree 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9658867660358 40.7756523577509)
2749 2749 -73.972967003211 40.7711848438157 7F-AM-1008-17 07F AM 10082018 17 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 scratching self 0 0 0 0 0 0 0 1   POINT (-73.972967003211 40.7711848438157)
2775 2775 -73.96971093983021 40.7776218260789 15E-PM-1008-06 15E PM 10082018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1 burying 0 0 0 0 0 0 1 0   POINT (-73.9697109398302 40.7776218260789)
2786 2786 -73.9683883750097 40.7754344396847 13G-PM-1008-01 13G PM 10082018 1 Juvenile Gray   Gray+   Above Ground 20 willow oak tree 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9683883750097 40.7754344396847)
2787 2787 -73.9765306970303 40.769495687585895 4D-PM-1008-09 04D PM 10082018 9 Adult Cinnamon Gray, White Cinnamon+Gray, White         0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9765306970303 40.7694956875859)
2793 2793 -73.9742847552668 40.7731740123046 9D-AM-1008-02 09D AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9742847552668 40.7731740123046)
2801 2801 -73.9697665830132 40.7759094917104 13E-PM-1008-08 13E PM 10082018 8 Juvenile Cinnamon Black, White Cinnamon+Black, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9697665830132 40.7759094917104)
2831 2831 -73.9753585157592 40.7698398607941 5E-AM-1008-07 05E AM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 on fence 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9753585157592 40.7698398607941)
2837 2837 -73.9772691210241 40.7690960712994 4D-PM-1008-13 04D PM 10082018 13 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9772691210241 40.7690960712994)
2850 2850 -73.9744847446854 40.76924227444 5E-AM-1008-04 05E AM 10082018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9744847446854 40.76924227444)
2862 2862 -73.967466716152 40.782434654827796 21D-PM-1008-04 21D PM 10082018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4   0 0 0 1 0   0 0 0 0 0 0 0 1 i scared it POINT (-73.967466716152 40.7824346548278)
2864 2864 -73.9761879300037 40.7683918970301 3E-PM-1008-01 03E PM 10082018 1 Adult Gray   Gray+   Above Ground 3   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9761879300037 40.7683918970301)
2917 2917 -73.9770313887741 40.7724869252099 7B-AM-1008-05 07B AM 10082018 5 Adult Gray   Gray+   Above Ground     0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9770313887741 40.772486925209904)
2921 2921 -73.9699573485164 40.7765857838015 14E-AM-1008-10 14E AM 10082018 10 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9699573485164 40.7765857838015)
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)
2942 2942 -73.9672063784809 40.7826070395665 21D-PM-1008-01 21D PM 10082018 1   Gray   Gray+   Above Ground 8   0 0 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.9672063784809 40.7826070395665)
2952 2952 -73.9763719445827 40.768955141333706 4D-PM-1008-04 04D PM 10082018 4 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9763719445827 40.7689551413337)
2965 2965 -73.9767389132988 40.7689323691424 4D-PM-1008-10 04D PM 10082018 10 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 6 climbed the fence & posed for a picture 0 0 1 0 1   0 0 0 0 0 1 0 0   POINT (-73.9767389132988 40.7689323691424)
2984 2984 -73.9700158929437 40.7762359066591 14E-AM-1008-18 14E AM 10082018 18 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9700158929437 40.7762359066591)
2996 2996 -73.970033345821 40.777259393859 15E-PM-1008-08 15E PM 10082018 8 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.970033345821 40.777259393859)
3009 3009 -73.9675637870968 40.782388067172796 21D-PM-1008-02 21D PM 10082018 2   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9675637870968 40.7823880671728)

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