2018_Central_Park_Squirrel_Census_-_Squirrel_Data

41 rows where Date = 10102018 and Hectare Squirrel Number = 4 sorted by latitude

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Climbing, Eating, Foraging, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Running ✖

  • 0 35
  • 1 6

Hectare Squirrel Number ✖

Date ✖

  • 10102018 · 41 ✖
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
2614 2614 -73.9765877920583 40.7660946071574 1F-AM-1010-04 01F AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9765877920583 40.7660946071574)
2533 2533 -73.9766195697096 40.766190726154704 1F-AM-1010-04 01F AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9766195697096 40.7661907261547)
2781 2781 -73.9752673884392 40.7662642413761 2G-AM-1010-04 02G AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9752673884392 40.7662642413761)
584 584 -73.9720553753548 40.7664488175384 3I-AM-1010-04 03I AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9720553753548 40.7664488175384)
1436 1436 -73.97667795856859 40.7669673778105 2E-AM-1010-04 02E AM 10102018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   1 0 0 0 0 0 1 0   POINT (-73.9766779585686 40.7669673778105)
1365 1365 -73.9791648157033 40.767625444347 2C-AM-1010-04 02C AM 10102018 4 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9791648157033 40.767625444347)
1492 1492 -73.9807078515193 40.768333529264204 2A-AM-1010-04 02A AM 10102018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9807078515193 40.7683335292642)
1195 1195 -73.9801698909399 40.7683721553321 2B-AM-1010-04 02B AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9801698909399 40.7683721553321)
2219 2219 -73.9709242364673 40.7684217215595 5I-AM-1010-04 05I AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9709242364673 40.7684217215595)
2315 2315 -73.9767849679735 40.768566516928 3D-PM-1010-04 03D PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9767849679735 40.768566516928)
2575 2575 -73.97357533521291 40.7687061447032 5G-PM-1010-04 05G PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9735753352129 40.7687061447032)
1811 1811 -73.9788088165392 40.769015302587796 3B-AM-1010-04 03B AM 10102018 4 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9788088165392 40.7690153025878)
1597 1597 -73.9789401448556 40.76973731414979 4B-AM-1010-04 04B AM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9789401448556 40.7697373141498)
1282 1282 -73.974451175321 40.770129463526395 6E-PM-1010-04 06E PM 10102018 4 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees 0 1 0 1 0 chasing #3 0 0 0 0 0 0 1 0   POINT (-73.974451175321 40.7701294635264)
903 903 -73.9719941577406 40.77037129313 7G-AM-1010-04 07G AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9719941577406 40.77037129313)
2587 2587 -73.97899712868441 40.7707024146365 5A-PM-1010-04 05A PM 10102018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9789971286844 40.7707024146365)
619 619 -73.9769887473852 40.7707561532949 5C-PM-1010-04 05C PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.97698874738522 40.7707561532949)
968 968 -73.9689781843873 40.7709333833783 9I-PM-1010-04 09I PM 10102018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9689781843873 40.7709333833783)
1901 1901 -73.9680237209555 40.771702220822505 10I-AM-1010-04 10I AM 10102018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9680237209555 40.7717022208225)
537 537 -73.9682803241007 40.772451055832704 11H-AM-1010-04 11H AM 10102018 4   Gray White Gray+White         0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9682803241007 40.7724510558327)
2744 2744 -73.9752915601718 40.7739329570033 9B-AM-1010-04 09B AM 10102018 4       +   Above Ground 10   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9752915601718 40.7739329570033)
256 256 -73.976798124308 40.774131657411296 9A-PM-1010-04 09A PM 10102018 4   Cinnamon   Cinnamon+   Above Ground 20   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.97679812430802 40.7741316574113)
1881 1881 -73.9674984567017 40.7745938268705 13H-PM-1010-04 13H PM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9674984567017 40.7745938268705)
2343 2343 -73.9719194877439 40.774800096290896 11D-AM-1010-04 11D AM 10102018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9719194877439 40.7748000962909)
175 175 -73.9720065066618 40.7764043782924 13C-AM-1010-04 13C AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9720065066618 40.7764043782924)
1718 1718 -73.96826762377029 40.7772653590224 15F-PM-1010-04 15F PM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE on path 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9682676237703 40.7772653590224)
2404 2404 -73.96653096896159 40.7775271020244 16G-AM-1010-04 16G AM 10102018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9665309689616 40.7775271020244)
585 585 -73.9700148248402 40.778778019335796 16D-PM-1010-04 16D PM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9700148248402 40.7787780193358)
2607 2607 -73.9642988690682 40.779559128197896 19H-AM-1010-04 19H AM 10102018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 1 runs from human w/ dog POINT (-73.9642988690682 40.7795591281979)
692 692 -73.9594529310985 40.7840492606552 26I-PM-1010-04 26I PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.95945293109851 40.7840492606552)
1468 1468 -73.96405889194459 40.790044098464 29B-PM-1010-04 29B PM 10102018 4 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.9640588919446 40.790044098464)
1882 1882 -73.9541601469123 40.7907832744689 34I-PM-1010-04 34I PM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE across the lawn and climb up a small tree 1 0 1 0 0 grooming 0 0 0 0 0 0 0 0   POINT (-73.9541601469123 40.79078327446891)
157 157 -73.9637946878735 40.791570044687795 31A-AM-1010-04 31A AM 10102018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9637946878735 40.7915700446878)
1362 1362 -73.9629184712372 40.7921410511633 32B-PM-1010-04 32B PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9629184712372 40.7921410511633)
2062 2062 -73.9618173092433 40.7925800181543 33B-PM-1010-04 33B PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9618173092433 40.7925800181543)
2555 2555 -73.9613127978423 40.79293215045679 33B-AM-1010-04 33B AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9613127978423 40.7929321504568)
1227 1227 -73.9527924755398 40.79343662605329 37I-AM-1010-04 37I AM 10102018 4 Adult Gray   Gray+   Above Ground 50 in tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9527924755398 40.7934366260533)
2461 2461 -73.9605347462123 40.794207544838706 35B-AM-1010-04 35B AM 10102018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE lawn 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9605347462123 40.7942075448387)
916 916 -73.95618876244708 40.7958187455815 38E-AM-1010-04 38E AM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 1 0 0   0 0 0 1 0 0 0 1 me POINT (-73.95618876244711 40.7958187455815)
242 242 -73.9590236602085 40.798263245686606 40A-AM-1010-04 40A AM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE bottom great hill 0 0 0 0 1   0 0 0 1 0 0 1 1 dog chased POINT (-73.9590236602085 40.7982632456866)
2285 2285 -73.9576325087936 40.7988448745116 41B-AM-1010-04 41B AM 10102018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9576325087936 40.7988448745116)

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