2018_Central_Park_Squirrel_Census_-_Squirrel_Data

123 rows where Date = 10192018 and Eating = 0 sorted by Tail flags

✎ View and edit SQL

This data as json, CSV (advanced)

Tail flags ✖

  • 0 17
  • 1 6

Running ✖

  • 0 15
  • 1 8

Eating ✖

Date ✖

  • 10192018 · 23 ✖
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
2660 2660 -73.97260564119709 40.77934679047429 16A-PM-1019-03 16A PM 10192018 3   Gray   Gray+   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9726056411971 40.7793467904743)
2662 2662 -73.97086289336241 40.772563088678396 10F-PM-1019-08 10F PM 10192018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Under "Grape Arbor" structure behind Bandshell 1 0 0 0 1 digging 0 0 0 0 0 0 0 1   POINT (-73.9708628933624 40.7725630886784)
2684 2684 -73.9809688694074 40.7688535974878 2A-PM-1019-06 02A PM 10192018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9809688694074 40.7688535974878)
2685 2685 -73.9601851468038 40.7968698151479 38A-AM-1019-05 38A AM 10192018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon head, White belly Ground Plane FALSE   0 0 0 0 1 standing on back legs 0 0 0 0 0 1 1 0   POINT (-73.9601851468038 40.7968698151479)
2688 2688 -73.9799302952205 40.767720720979796 1B-PM-1019-02 01B PM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9799302952205 40.7677207209798)
2715 2715 -73.9710273070712 40.776652124615296 14D-PM-1019-16 14D PM 10192018 16 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9710273070712 40.7766521246153)
2777 2777 -73.98108436110859 40.768790549369896 2A-PM-1019-05 02A PM 10192018 5 ? Gray   Gray+   Above Ground 50 in tall planetree 1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9810843611086 40.7687905493699)
2834 2834 -73.9651132904127 40.7905384124102 29A-PM-1019-02 29A PM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9651132904127 40.7905384124102)
2841 2841 -73.9693262952166 40.783260411082004 21B-AM-1019-01 21B AM 10192018 1 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9693262952166 40.783260411082)
2865 2865 -73.98028424040159 40.767825738497706 1B-PM-1019-03 01B PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 25 in tree 0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.98028424040162 40.7678257384977)
2877 2877 -73.9730027200009 40.7798000868804 16A-PM-1019-05 16A PM 10192018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9730027200009 40.7798000868804)
2882 2882 -73.956581233786 40.7902127690837 33H-AM-1019-01 33H AM 10192018 1 Adult Cinnamon Gray Cinnamon+Gray Cinnamon patches Ground Plane FALSE   0 0 0 0 0 wrestling with child 0 0 0 0 0 0 0 0   POINT (-73.956581233786 40.79021276908371)
2902 2902 -73.9673220504383 40.777029634596296 15G-PM-1019-04 15G PM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9673220504383 40.7770296345963)
2904 2904 -73.97203897567171 40.7763524091989 13C-PM-1019-02 13C PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9720389756717 40.7763524091989)
2907 2907 -73.96852016269341 40.783329261225 21B-AM-1019-05 21B AM 10192018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9685201626934 40.783329261225)
2924 2924 -73.9727230609785 40.7795341640894 16A-PM-1019-01 16A PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9727230609785 40.7795341640894)
2987 2987 -73.9563724838337 40.7882504581015 31I-PM-1019-04 31I PM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.95637248383372 40.7882504581015)
855 855 -73.9808247660048 40.76894088312871 2A-PM-1019-01 02A PM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 runs from 0 0 0 1 0 0 0 1   POINT (-73.9808247660048 40.7689408831287)
1175 1175 -73.9803282698463 40.7680809889384 1B-PM-1019-09 01B PM 10192018 9 Adult Gray White Gray+White   Ground Plane FALSE Tree to ground 0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9803282698463 40.7680809889384)
1956 1956 -73.98089749771201 40.7690578709841 2A-PM-1019-02 02A PM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 0   POINT (-73.980897497712 40.7690578709841)
2295 2295 -73.9590632051055 40.79631465848271 38B-AM-1019-04 38B AM 10192018 4 Adult Gray   Gray+   Above Ground 20   0 0 0 0 0 sitting in tree 1 1 0 1 0 0 1 0 observant POINT (-73.9590632051055 40.7963146584827)
2335 2335 -73.9704679459444 40.7773384236212 14D-PM-1019-10 14D PM 10192018 10 Adult Gray   Gray+   Above Ground 20   0 0 1 0 0   0 0 0 1 0 0 0 1   POINT (-73.9704679459444 40.7773384236212)
2588 2588 -73.95810074370941 40.795940311272204 38C-AM-1019-06 38C AM 10192018 6 Adult Gray   Gray+   Above Ground 23   0 0 1 0 0   1 0 0 1 0 0 1 0   POINT (-73.9581007437094 40.7959403112722)

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