2018_Central_Park_Squirrel_Census_-_Squirrel_Data

37 rows where Date = 10072018, Eating = 1 and Foraging = 1 sorted by Running

✎ View and edit SQL

This data as json, CSV (advanced)

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

Tail twitches ✖

  • 0 31
  • 1 6

Foraging ✖

Eating ✖

Date ✖

  • 10072018 · 37 ✖
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
32 32 -73.9576530157255 40.7868659490397 29I-PM-1007-01 29I PM 10072018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9576530157255 40.7868659490397)
68 68 -73.96942403275091 40.7755898126674 13F-AM-1007-02 13F AM 10072018 2 Adult Cinnamon White Cinnamon+White         0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.96942403275091 40.7755898126674)
161 161 -73.9649632550828 40.7809187761995 20F-PM-1007-01 20F PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon cinnamon tail Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9649632550828 40.7809187761995)
304 304 -73.9523001834395 40.7949231000186 39H-AM-1007-02 39H AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9523001834395 40.7949231000186)
349 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)
437 437 -73.9793952066038 40.7707837657859 4A-PM-1007-03 04A PM 10072018 3 Adult Gray White Gray+White   Ground Plane FALSE by rock 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9793952066038 40.77078376578591)
441 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)
475 475 -73.9697855573137 40.7742186391935 12F-PM-1007-05 12F PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9697855573137 40.7742186391935)
489 489 -73.97780296909 40.7676321060669 2D-AM-1007-06 02D AM 10072018 6 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.97780296909002 40.767632106066905)
912 912 -73.958024711869 40.7938724278575 36D-PM-1007-01 36D PM 10072018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.958024711869 40.7938724278575)
954 954 -73.96584435488221 40.7796704898979 19F-AM-1007-03 19F AM 10072018 3 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0 scared POINT (-73.9658443548822 40.7796704898979)
1067 1067 -73.9695305996721 40.774538689695895 12F-PM-1007-02 12F PM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9695305996721 40.7745386896959)
1115 1115 -73.9545214613307 40.7943801121036 37G-PM-1007-01 37G PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9545214613307 40.7943801121036)
1117 1117 -73.9693465383617 40.7744996336934 12F-PM-1007-01 12F PM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9693465383617 40.7744996336934)
1169 1169 -73.9570391901515 40.7930697207834 35F-AM-1007-01 35F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9570391901515 40.7930697207834)
1216 1216 -73.9707245013626 40.778065658833704 15D-AM-1007-06 15D AM 10072018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9707245013626 40.7780656588337)
1404 1404 -73.9700666654946 40.774285704258105 12F-PM-1007-08 12F PM 10072018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0 stared POINT (-73.9700666654946 40.7742857042581)
1457 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)
1494 1494 -73.95257524081691 40.7954915417553 39H-AM-1007-03 39H AM 10072018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9525752408169 40.7954915417553)
1513 1513 -73.96624099976421 40.789104293543204 28A-PM-1007-03 28A PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 1 0 1 1 chasing #2 took #2 food wrapper and is foraging through it 0 0 0 0 0 0 1 0   POINT (-73.9662409997642 40.7891042935432)
1609 1609 -73.96390249881229 40.777695306584896 18I-PM-1007-01 18I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   0 0 1 1 1 hanging upside down 0 0 0 0 0 0 1 0   POINT (-73.9639024988123 40.7776953065849)
1647 1647 -73.9795585338537 40.768895893226 3B-PM-1007-08 03B PM 10072018 8 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9795585338537 40.768895893226)
1906 1906 -73.9700066659086 40.7744028820163 12F-PM-1007-13 12F PM 10072018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9700066659086 40.7744028820163)
1944 1944 -73.97432920664129 40.7756090404121 11B-AM-1007-05 11B AM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 1 0 1 0 0   POINT (-73.9743292066413 40.7756090404121)
2001 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)
2040 2040 -73.96481673340891 40.7811164976329 20F-PM-1007-02 20F PM 10072018 2 Adult Gray White Gray+White white on tail Ground Plane FALSE   0 0 0 1 1 digging one hole w/ determination 0 0 0 0 1 0 0 1   POINT (-73.96481673340891 40.7811164976329)
2100 2100 -73.9638312025305 40.7903826659569 30B-AM-1007-07 30B AM 10072018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9638312025305 40.7903826659569)
2184 2184 -73.9694938608335 40.7745700102115 12F-PM-1007-03 12F PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9694938608335 40.7745700102115)
2187 2187 -73.96991340526091 40.774446589038 12F-PM-1007-14 12F PM 10072018 14 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 1 1 0   POINT (-73.9699134052609 40.774446589038)
2222 2222 -73.9639048209454 40.777737334555795 18I-PM-1007-02 18I PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   0 0 1 1 1 hanging upside down 0 0 0 0 0 0 1 0   POINT (-73.9639048209454 40.7777373345558)
2566 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)
2579 2579 -73.96981304525809 40.7745000645436 12F-PM-1007-15 12F PM 10072018 15 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.9698130452581 40.7745000645436)
2833 2833 -73.9552595564798 40.7889533029466 32I-PM-1007-01 32I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 1 1 chirps 0 0 0 0 1 0 1 0   POINT (-73.9552595564798 40.7889533029466)
2995 2995 -73.9668442742942 40.7870781042595 25B-PM-1007-01 25B PM 10072018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9668442742942 40.7870781042595)
3019 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)
2424 2424 -73.9684752839242 40.776581626151795 15F-AM-1007-01 15F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 1   POINT (-73.9684752839242 40.7765816261518)
2508 2508 -73.97938145045201 40.770903369788705 4A-PM-1007-01 04A PM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 1 1   0 0 0 0 1 0 1 0   POINT (-73.979381450452 40.770903369788705)

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