2018_Central_Park_Squirrel_Census_-_Squirrel_Data

125 rows where Hectare Squirrel Number = 7 and Running = 0 sorted by Date

✎ View and edit SQL

This data as json, CSV (advanced)

Shift ✖

Runs from ✖

  • 0 21
  • 1 4

Hectare Squirrel Number ✖

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
2804 2804 -73.9576094432477 40.7965342664074 38C-PM-1014-07 38C PM 10142018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9576094432477 40.7965342664074)
642 642 -73.9568382279233 40.7975685470963 40C-AM-1017-07 40C AM 10172018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9568382279233 40.7975685470963)
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)
853 853 -73.9534509627885 40.7921084224711 36I-AM-1017-07 36I AM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 1 chasing (#8),scratching 1 0 0 0 1 0 1 0   POINT (-73.9534509627885 40.7921084224711)
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)
1173 1173 -73.959070754026 40.790667514341294 32E-PM-1017-07 32E PM 10172018 7 Adult Gray   Gray+   Ground Plane FALSE treed area 0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.959070754026 40.7906675143413)
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)
1390 1390 -73.9677146741772 40.77882313323371 17E-AM-1017-07 17E AM 10172018 7 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9677146741772 40.7788231332337)
1846 1846 -73.96533111365609 40.780193490342995 19F-PM-1017-07 19F PM 10172018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9653311136561 40.78019349034301)
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)
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)
1262 1262 -73.9683345414813 40.7779016280345 16E-PM-1018-07 16E PM 10182018 7 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 0 0   1 0 0 0 0 0 1 0   POINT (-73.9683345414813 40.7779016280345)
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)
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)
2189 2189 -73.9761776424664 40.7695941843825 5D-PM-1018-07 05D PM 10182018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9761776424664 40.7695941843825)
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)
482 482 -73.97217978245759 40.7801213843628 16A-PM-1019-07 16A PM 10192018 7 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 0 0 approaches (very friendly) POINT (-73.9721797824576 40.7801213843628)
980 980 -73.9709817796369 40.7773554311586 14D-PM-1019-07 14D PM 10192018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9709817796369 40.7773554311586)
1688 1688 -73.9677593344667 40.7763054313195 15G-PM-1019-07 15G PM 10192018 7 Adult     +   Above Ground 5   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9677593344667 40.7763054313195)
1897 1897 -73.97107389601 40.7723265810536 10F-PM-1019-07 10F PM 10192018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 Same tree (as #6) 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.97107389601 40.7723265810536)
1986 1986 -73.958247706428 40.7989079136796 40B-AM-1019-07 40B AM 10192018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 1   POINT (-73.958247706428 40.7989079136796)
2482 2482 -73.9805927710872 40.76799891166421 1B-PM-1019-07 01B PM 10192018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9805927710872 40.7679989116642)
2567 2567 -73.9690241805398 40.783796758077294 21B-AM-1019-07 21B AM 10192018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9690241805398 40.7837967580773)
2825 2825 -73.96435075880079 40.790432469329204 30B-PM-1019-07 30B PM 10192018 7 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.96435075880082 40.7904324693292)
2759 2759 -73.9543373703455 40.7943889087123 38G-PM-1020-07 38G PM 10202018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 1   0 1 0 1 0 0 1 0   POINT (-73.9543373703455 40.7943889087123)

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