2018_Central_Park_Squirrel_Census_-_Squirrel_Data

125 rows where Date = 10182018 and Shift = "PM" sorted by Foraging

✎ View and edit SQL

This data as json, CSV (advanced)

Shift ✖

Quaas ✖

  • 0 25

Date ✖

  • 10182018 · 25 ✖

Color notes ✖

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
1438 1438 -73.97168547522399 40.7706668465923 7G-PM-1018-07 07G PM 10182018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.971685475224 40.7706668465923)
1454 1454 -73.9753818829907 40.76978409861629 5D-PM-1018-06 05D PM 10182018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9753818829907 40.7697840986163)
1463 1463 -73.96300972763659 40.7936658446251 33A-PM-1018-04 33A PM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9630097276366 40.79366584462511)
1541 1541 -73.9711617997772 40.7761212878075 13D-PM-1018-04 13D PM 10182018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9711617997772 40.7761212878075)
1655 1655 -73.96957001271599 40.7816501516863 19B-PM-1018-04 19B PM 10182018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.969570012716 40.7816501516863)
1704 1704 -73.9624052832372 40.7809656348254 21H-PM-1018-04 21H PM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 0 0   POINT (-73.9624052832372 40.7809656348254)
1725 1725 -73.96574800660741 40.7753465489231 14I-PM-1018-04 14I PM 10182018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 1 0 0   POINT (-73.9657480066074 40.7753465489231)
1942 1942 -73.96249054313 40.793538903878705 33A-PM-1018-01 33A PM 10182018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0 stopped to see what i would do 1st POINT (-73.96249054313 40.7935389038787)
1958 1958 -73.96931200900549 40.771096102012 9H-PM-1018-07 09H PM 10182018 7 Adult Gray   Gray+         0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9693120090055 40.771096102012)
2048 2048 -73.96276614653759 40.7819356810575 22G-PM-1018-02 22G PM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9627661465376 40.7819356810575)
2049 2049 -73.9692650850957 40.7713793846002 9H-PM-1018-03 09H PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9692650850957 40.7713793846002)
2082 2082 -73.9696802053043 40.781605740612505 19B-PM-1018-03 19B PM 10182018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9696802053043 40.7816057406125)
2099 2099 -73.9685612289881 40.7778488829217 16E-PM-1018-08 16E PM 10182018 8 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9685612289881 40.7778488829217)
2125 2125 -73.9687933229572 40.7788600242549 17E-PM-1018-01 17E PM 10182018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9687933229572 40.7788600242549)
2201 2201 -73.9717135461165 40.7761780680083 13D-PM-1018-01 13D PM 10182018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9717135461165 40.776178068008306)
2339 2339 -73.9695117797648 40.7802675743233 18C-PM-1018-07 18C PM 10182018 7   Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9695117797648 40.780267574323304)
2432 2432 -73.9657203199746 40.775173008911 14I-PM-1018-02 14I PM 10182018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9657203199746 40.775173008911)
2522 2522 -73.9658747245917 40.77540337375321 14I-PM-1018-01 14I PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   Fallen branch 1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9658747245917 40.7754033737532)
2582 2582 -73.9665004148497 40.780565641175606 19E-PM-1018-05 19E PM 10182018 5   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9665004148497 40.7805656411756)
2612 2612 -73.97116730065241 40.77479796145771 12E-PM-1018-05 12E PM 10182018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9711673006524 40.7747979614577)
2681 2681 -73.968807163616 40.7812018159499 19C-PM-1018-02 19C PM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.968807163616 40.7812018159499)
2712 2712 -73.9682760864462 40.778072756941704 16E-PM-1018-04 16E PM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   1 0 0 0 0 0 1 0   POINT (-73.9682760864462 40.7780727569417)
2765 2765 -73.971525123573 40.770368535984204 7G-PM-1018-06 07G PM 10182018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 grooming 0 0 0 0 0 0 0 0   POINT (-73.971525123573 40.7703685359842)
2853 2853 -73.96786131850709 40.7822170887526 20C-PM-1018-03 20C PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9678613185071 40.7822170887526)
3018 3018 -73.9645437409662 40.7811599933331 21F-PM-1018-02 21F PM 10182018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9645437409662 40.7811599933331)

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