2018_Central_Park_Squirrel_Census_-_Squirrel_Data

93 rows where Date = 10182018 and Indifferent = 1 sorted by Runs from

✎ View and edit SQL

This data as json, CSV (advanced)

Tail twitches ✖

  • 0 30
  • 1 5

Primary Fur Color ✖

Indifferent ✖

Date ✖

  • 10182018 · 35 ✖
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
1856 1856 -73.97829402311491 40.7694236097224 4B-PM-1018-05 04B PM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9782940231149 40.7694236097224)
1874 1874 -73.96573273328491 40.7747554568985 14I-PM-1018-03 14I PM 10182018 3 Juvenile Gray Black Gray+Black   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9657327332849 40.7747554568985)
1895 1895 -73.954699659637 40.7951308856929 38F-AM-1018-02 38F AM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.954699659637 40.7951308856929)
1898 1898 -73.9721263050502 40.7698763846186 7G-PM-1018-01 07G PM 10182018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9721263050502 40.7698763846186)
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)
1978 1978 -73.9579689996645 40.794933848991704 37D-AM-1018-02 37D AM 10182018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9579689996645 40.7949338489917)
1989 1989 -73.96316467546471 40.7925716810884 32A-AM-1018-02 32A AM 10182018 2 Adult Gray   Gray+   Above Ground 15   1 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9631646754647 40.7925716810884)
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)
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)
2171 2171 -73.9686370726471 40.7780382348833 16E-PM-1018-09 16E PM 10182018 9 Juvenile Cinnamon White Cinnamon+White   Above Ground 3 On trunk 0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9686370726471 40.7780382348833)
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)
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)
2255 2255 -73.96429678758571 40.78156523539371 21F-AM-1018-08 21F AM 10182018 8 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9642967875857 40.7815652353937)
2294 2294 -73.96308205774409 40.7821632293136 22G-PM-1018-01 22G PM 10182018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   1 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.9630820577441 40.7821632293136)
2407 2407 -73.95557243517759 40.7967602498249 39E-AM-1018-03 39E AM 10182018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9555724351776 40.7967602498249)
2510 2510 -73.9748635473782 40.7742591029151 10C-AM-1018-02 10C AM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0 sitting in the sun 0 0 0 0 0 0 1 0   POINT (-73.9748635473782 40.7742591029151)
2531 2531 -73.9599424115626 40.79574725853271 37B-AM-1018-05 37B AM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9599424115626 40.7957472585327)
2543 2543 -73.96914249979191 40.780542852496 18C-AM-1018-02 18C AM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9691424997919 40.780542852496)
2581 2581 -73.9635981227569 40.7928169540326 32A-AM-1018-05 32A AM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9635981227569 40.7928169540326)
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)
2599 2599 -73.96898934126929 40.785308737683 23A-AM-1018-03 23A AM 10182018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8 Tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9689893412693 40.785308737683)
2611 2611 -73.951448051873 40.7973951649254 42G-AM-1018-02 42G AM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.951448051873 40.7973951649254)
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)
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)
2822 2822 -73.9711120079542 40.776080191176604 13D-PM-1018-14 13D PM 10182018 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 1 0 0 climbing (down) 0 0 0 0 0 0 1 0   POINT (-73.9711120079542 40.7760801911766)
2830 2830 -73.9556083695689 40.7965223709493 39E-AM-1018-02 39E AM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9556083695689 40.7965223709493)
2838 2838 -73.9507699667119 40.7955166039555 40I-AM-1018-02 40I AM 10182018 2 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9507699667119 40.795516603955505)
2876 2876 -73.95589957376541 40.7960097734603 39E-AM-1018-05 39E AM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9558995737654 40.7960097734603)
2897 2897 -73.9689554458632 40.777859339395704 16E-PM-1018-10 16E PM 10182018 10 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9689554458632 40.7778593393957)
2941 2941 -73.96902666603171 40.7853134751509 23A-AM-1018-01 23A AM 10182018 1 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9690266660317 40.7853134751509)
2960 2960 -73.96252481451499 40.7810022923615 21H-PM-1018-03 21H PM 10182018 3 Adult Gray   Gray+   Above Ground 25   0 0 1 0 0   1 0 0 0 0 0 1 0   POINT (-73.962524814515 40.7810022923615)
2966 2966 -73.9630596103391 40.792572062055605 32A-AM-1018-04 32A AM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE Base of tree 0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9630596103391 40.7925720620556)
2972 2972 -73.9631468456897 40.7926110399714 32A-AM-1018-03 32A AM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9631468456897 40.7926110399714)
3014 3014 -73.9665572004288 40.780434754830296 19E-PM-1018-04 19E PM 10182018 4   Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9665572004288 40.7804347548303)

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