2018_Central_Park_Squirrel_Census_-_Squirrel_Data

39 rows where Date = 10172018, Foraging = 0, Shift = "PM" and Tail twitches = 0 sorted by Other Interactions

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Approaches, Indifferent, Runs from

Quaas ✖

  • 0 38
  • 1 1

Tail twitches ✖

Shift ✖

Moans ✖

  • 0 39

Foraging ✖

Date ✖

  • 10172018 · 39 ✖
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
105 105 -73.9589249555235 40.7908193284981 32E-PM-1017-03 32E PM 10172018 3 Adult Gray   Gray+   Above Ground 2 bottom of tree 0 0 0 1 0 still 0 0 0 0 0 0 1 0   POINT (-73.9589249555235 40.7908193284981)
174 174 -73.9707274055755 40.772388908037705 10G-PM-1017-10 10G PM 10172018 10 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0 playing (with #9) 0 0 0 0 0 0 1 0   POINT (-73.9707274055755 40.7723889080377)
288 288 -73.9731113265165 40.778664067635496 15A-PM-1017-01 15A PM 10172018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10   0 0 1 1 0 eating in tree 0 0 0 0 0 0 1 0   POINT (-73.9731113265165 40.7786640676355)
321 321 -73.96942888062121 40.7842952265291 22A-PM-1017-01 22A PM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9694288806212 40.7842952265291)
368 368 -73.970315671921 40.77209053954721 10G-PM-1017-02 10G PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.970315671921 40.7720905395472)
430 430 -73.9710116801402 40.7723689301989 10G-PM-1017-08 10G PM 10172018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9710116801402 40.7723689301989)
438 438 -73.95257475169142 40.7977257435263 42F-PM-1017-02 42F PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 playing 0 0 0 0 0 0 1 0   POINT (-73.95257475169142 40.7977257435263)
457 457 -73.965848283831 40.779724303305706 19F-PM-1017-01 19F PM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.965848283831 40.7797243033057)
542 542 -73.9713487591577 40.7784353043714 15C-PM-1017-03 15C PM 10172018 3 Adult Black   Black+   Above Ground 17 running across overpass 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9713487591577 40.7784353043714)
679 679 -73.955018489069 40.7971235333699 40E-PM-1017-02 40E PM 10172018 2 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.955018489069 40.7971235333699)
805 805 -73.97068515461841 40.7780777016038 15D-PM-1017-04 15D PM 10172018 4 Adult Cinnamon   Cinnamon+   Above Ground 2 on fence 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9706851546184 40.7780777016038)
808 808 -73.97168818386709 40.778553537087 15C-PM-1017-02 15C PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 0   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9716881838671 40.778553537087)
834 834 -73.9703914126866 40.7722457975176 10G-PM-1017-01 10G PM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0 standing 0 0 0 0 0 0 1 0   POINT (-73.9703914126866 40.7722457975176)
940 940 -73.9700879096644 40.7765899724756 14E-PM-1017-05 14E PM 10172018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9700879096644 40.7765899724756)
1139 1139 -73.9716271494641 40.7796462634184 16B-PM-1017-02 16B PM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9716271494641 40.7796462634184)
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)
1182 1182 -73.9667206046912 40.777999356509795 17G-PM-1017-04 17G PM 10172018 4 Adult Gray White Gray+White   Above Ground 10 tree & ground 1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9667206046912 40.7779993565098)
1191 1191 -73.9634835346077 40.7918244310746 31A-PM-1017-03 31A PM 10172018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9634835346077 40.7918244310746)
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)
1426 1426 -73.9664986446294 40.778308334318 17G-PM-1017-02 17G PM 10172018 2 Adult Gray   Gray+   Above Ground 15   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9664986446294 40.778308334318)
1479 1479 -73.97074984303941 40.7723724480959 10G-PM-1017-09 10G PM 10172018 9 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9707498430394 40.7723724480959)
1561 1561 -73.9642397829547 40.7918992406575 31A-PM-1017-02 31A PM 10172018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.96423978295472 40.7918992406575)
1731 1731 -73.9692846326638 40.7841049008492 22A-PM-1017-02 22A PM 10172018 2 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9692846326638 40.7841049008492)
1832 1832 -73.9693159934697 40.7831212338295 21B-PM-1017-03 21B PM 10172018 3 Juvenile Cinnamon White Cinnamon+White   Above Ground 1   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9693159934697 40.7831212338295)
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)
2071 2071 -73.96676944398949 40.7779501809095 17G-PM-1017-03 17G PM 10172018 3 Adult Gray White Gray+White   Above Ground 10 tree & ground 1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9667694439895 40.7779501809095)
2083 2083 -73.9702382274798 40.7721754848905 10G-PM-1017-03 10G PM 10172018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9702382274798 40.7721754848905)
2114 2114 -73.9651541395415 40.7798283208748 19G-PM-1017-01 19G PM 10172018 1 Adult Cinnamon White Cinnamon+White   Above Ground 12   0 0 0 0 0 watching 0 0 0 0 0 1 0 0   POINT (-73.9651541395415 40.7798283208748)
2442 2442 -73.9699369796844 40.772035019127294 10G-PM-1017-04 10G PM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9699369796844 40.7720350191273)
2460 2460 -73.9526681107152 40.7977012009146 42F-PM-1017-01 42F PM 10172018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0 playing 0 0 0 0 0 0 1 0   POINT (-73.9526681107152 40.7977012009146)
2658 2658 -73.9690212174 40.783409940410706 21B-PM-1017-05 21B PM 10172018 5 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9690212174 40.7834099404107)
2774 2774 -73.9705409446299 40.7764608087703 14E-PM-1017-03 14E PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9705409446299 40.7764608087703)
2836 2836 -73.953092053256 40.7982256930243 42F-PM-1017-03 42F PM 10172018 3   Gray Cinnamon Gray+Cinnamon         1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.953092053256 40.7982256930243)
2840 2840 -73.9532163535175 40.7982970313067 42F-PM-1017-04 42F PM 10172018 4   Gray   Gray+         1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9532163535175 40.7982970313067)
2867 2867 -73.969370141813 40.7840721191988 22A-PM-1017-03 22A PM 10172018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.969370141813 40.7840721191988)
2764 2764 -73.9692660977515 40.7830532310766 21B-PM-1017-01 21B PM 10172018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0 paused to look at me POINT (-73.9692660977515 40.7830532310766)
1916 1916 -73.9693504617353 40.7830678709405 21B-PM-1017-02 21B PM 10172018 2 Juvenile Cinnamon White Cinnamon+White   Above Ground 1   0 1 0 0 0   0 1 0 0 0 0 0 0 stood on hind legs with front legs on the chest POINT (-73.9693504617353 40.7830678709405)
2697 2697 -73.9710674928906 40.7778757544025 15D-PM-1017-06 15D PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 walking 0 0 0 0 0 0 0 0 stopped and watched me before slowly moving on POINT (-73.9710674928906 40.7778757544025)
844 844 -73.9642379942652 40.777479252073796 17I-PM-1017-01 17I PM 10172018 1 Juvenile Cinnamon White Cinnamon+White   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0 was in a tree,so i couldn't really tell POINT (-73.9642379942652 40.7774792520738)

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