2018_Central_Park_Squirrel_Census_-_Squirrel_Data

48 rows where Date = 10072018 and Hectare Squirrel Number = 4 sorted by Tail twitches

View and edit SQL

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

Tail twitches

  • 0 43
  • 1 5

Kuks

  • 0 46
  • 1 2

Hectare Squirrel Number

Date

  • 10072018 · 48
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
163 -73.97123088643941 40.7714534847379 9G-AM-1007-04 09G AM 10072018 4 Adult Gray White Gray+White   Above Ground 15   0 0 0 0 0 grooming 0 0 0 0 0 0 1 0   POINT (-73.9712308864394 40.7714534847379)
190 -73.9695507965155 40.7743070423435 12F-PM-1007-04 12F PM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0 stared POINT (-73.96955079651552 40.7743070423435)
302 -73.9695176417703 40.7741725190048 12G-PM-1007-04 12G PM 10072018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9695176417703 40.7741725190048)
349 -73.9689657039917 40.776783427676705 15F-AM-1007-04 15F AM 10072018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9689657039917 40.7767834276767)
354 -73.95667510223359 40.799035789744 41C-PM-1007-04 41C PM 10072018 4 Adult Gray White Gray+White   Above Ground 65   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9566751022336 40.799035789744)
421 -73.9664630067791 40.775636151582496 14H-AM-1007-04 14H AM 10072018 4 Juvenile Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9664630067791 40.7756361515825)
427 -73.9589367709165 40.78964653034829 31F-PM-1007-04 31F PM 10072018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9589367709165 40.7896465303483)
441 -73.9742973420446 40.7691801644292 5F-AM-1007-04 05F AM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   rocks 0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9742973420446 40.7691801644292)
446 -73.9678774314725 40.7738535171265 12H-PM-1007-04 12H PM 10072018 4   Gray Cinnamon Gray+Cinnamon         0 0 0 1 0 mushroom 0 0 0 0 0 0 1 0   POINT (-73.9678774314725 40.7738535171265)
604 -73.9540908513075 40.794201225045 37G-PM-1007-04 37G PM 10072018 4   Cinnamon Gray Cinnamon+Gray gray tail Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9540908513075 40.794201225045)
616 -73.9556937218252 40.7990928062435 42C-AM-1007-04 42C AM 10072018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White young adult Ground Plane FALSE   0 0 0 0 0 walking 0 0 0 0 0 0 1 0   POINT (-73.9556937218252 40.7990928062435)
687 -73.96369718436651 40.78256385373621 22F-AM-1007-04 22F AM 10072018 4 Adult Cinnamon Gray Cinnamon+Gray         0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9636971843665 40.7825638537362)
727 -73.9634563222926 40.780992836417 21G-PM-1007-04 21G PM 10072018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 0 0 1   POINT (-73.9634563222926 40.780992836417)
849 -73.9736165917399 40.772454390149704 8D-AM-1007-04 08D AM 10072018 4 Adult Gray   Gray+   Above Ground 3   0 1 0 0 0 chasing squirrel #3 0 0 0 0 0 0 0 0   POINT (-73.9736165917399 40.7724543901497)
904 -73.9531013359625 40.792122355653504 36I-PM-1007-04 36I PM 10072018 4 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9531013359625 40.7921223556535)
960 -73.9623922773932 40.7814944428327 22H-PM-1007-04 22H PM 10072018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9623922773932 40.7814944428327)
971 -73.978392591149 40.7668993398193 1D-PM-1007-04 01D PM 10072018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.978392591149 40.7668993398193)
1056 -73.98110784424621 40.767515940567 1A-AM-1007-04 01A AM 10072018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9811078442462 40.767515940567)
1110 -73.96764342569759 40.78623366244479 24A-PM-1007-04 24A PM 10072018 4 Adult Gray   Gray+   Above Ground 50 in tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9676434256976 40.7862336624448)
1246 -73.9543044385367 40.7984498571338 41E-AM-1007-04 41E AM 10072018 4 Adult Cinnamon White Cinnamon+White white haunches/tail Ground Plane FALSE rubbing belly on ground 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9543044385367 40.798449857133804)
1457 -73.9697744662785 40.775595042897294 13F-AM-1007-04 13F AM 10072018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9697744662785 40.7755950428973)
1573 -73.9595613548804 40.7838057527338 25I-PM-1007-04 25I PM 10072018 4 Adult Gray   Gray+   Above Ground 25   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9595613548804 40.7838057527338)
1675 -73.97774976458341 40.767734470917794 2D-AM-1007-04 02D AM 10072018 4 Adult Gray   Gray+   Above Ground 100   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9777497645834 40.7677344709178)
1729 -73.97650461090191 40.7736674124746 8B-AM-1007-04 08B AM 10072018 4 Adult Gray   Gray+   Above Ground 2   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9765046109019 40.7736674124746)
1826 -73.9707542189896 40.7717032986885 9G-PM-1007-04 09G PM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9707542189896 40.77170329868851)
1919 -73.9637440847107 40.789142741937205 29C-AM-1007-04 29C AM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9637440847107 40.7891427419372)
1925 -73.95813898706442 40.7993081122523 41A-PM-1007-04 41A PM 10072018 4 Adult Gray   Gray+   Above Ground 20   1 0 1 0 0 laid down on the branch 0 0 0 0 0 0 0 1   POINT (-73.9581389870644 40.799308112252305)
1969 -73.96890514730721 40.7764511282884 14F-AM-1007-04 14F AM 10072018 4 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9689051473072 40.7764511282884)
2001 -73.9521655419974 40.7948785497717 39H-AM-1007-04 39H AM 10072018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9521655419974 40.7948785497717)
2094 -73.9701630539326 40.7779553961101 15D-AM-1007-04 15D AM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.97016305393261 40.7779553961101)
2145 -73.96512504025829 40.7812884929069 20F-PM-1007-04 20F PM 10072018 4 Juvenile Gray White Gray+White white on tail Above Ground 20 climbed tree 0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9651250402583 40.7812884929069)
2158 -73.9597593485091 40.7937528403249 35C-AM-1007-04 35C AM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9597593485091 40.7937528403249)
2227 -73.9792814244424 40.770503194056 4A-AM-1007-04 04A AM 10072018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9792814244424 40.770503194056)
2248 -73.9766477027266 40.7712737417779 6C-AM-1007-04 06C AM 10072018 4 Adult Gray   Gray+   Above Ground 20   0 1 1 0 0 chasing #5 0 0 0 0 0 0 1 0   POINT (-73.9766477027266 40.7712737417779)
2478 -73.96749310703241 40.778369369095394 17F-AM-1007-04 17F AM 10072018 4 Adult Cinnamon White Cinnamon+White   Above Ground 4   0 0 0 1 0 chilling 1 0 0 0 0 0 1 0   POINT (-73.9674931070324 40.7783693690954)
2566 -73.9744226682925 40.77556257172729 11B-AM-1007-04 11B AM 10072018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9744226682925 40.7755625717273)
2634 -73.96956851864891 40.7788293026327 16D-AM-1007-04 16D AM 10072018 4 Adult Gray   Gray+   Above Ground 8   0 0 1 0 0   0 0 0 1 0 0 0 1   POINT (-73.9695685186489 40.7788293026327)
2828 -73.9587439756541 40.7849006107353 27I-AM-1007-04 27I AM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 1   POINT (-73.9587439756541 40.7849006107353)
2869 -73.9630822385425 40.7914844989865 31B-PM-1007-04 31B PM 10072018 4 Juvenile Gray   Gray+         0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9630822385425 40.7914844989865)
2906 -73.9597260014375 40.790707423031 32E-AM-1007-04 32E AM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9597260014375 40.790707423031)
2971 -73.9639801411692 40.7778921302618 18I-PM-1007-04 18I PM 10072018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 0 walking sitting up 0 0 0 0 0 0 0 1   POINT (-73.9639801411692 40.7778921302618)
3005 -73.96161411525391 40.7921803313341 33C-PM-1007-04 33C PM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9616141152539 40.7921803313341)
3019 -73.9639431360458 40.7908677445466 30B-AM-1007-04 30B AM 10072018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9639431360458 40.7908677445466)
1342 -73.96620636423451 40.789077866530704 28A-PM-1007-04 28A PM 10072018 4 Adult Gray White Gray+White         0 0 0 0 0 looking at me & #5 1 0 0 0 1 0 0 0 freezes POINT (-73.9662063642345 40.7890778665307)
1730 -73.97961428483491 40.7702117898305 4A-PM-1007-04 04A PM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9796142848349 40.7702117898305)
2133 -73.9736164871197 40.7725695048569 8D-PM-1007-04 08D PM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9736164871197 40.7725695048569)
2776 -73.9789687905912 40.769269313932796 3B-PM-1007-04 03B PM 10072018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 At fence 1 0 1 1 0   0 0 0 0 1 0 1 1   POINT (-73.9789687905912 40.7692693139328)
2961 -73.9736238258579 40.7688712771191 5F-PM-1007-04 05F PM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9736238258579 40.7688712771191)

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