2018_Central_Park_Squirrel_Census_-_Squirrel_Data

37 rows where Foraging = 1, Highlight Fur Color = "Cinnamon" and Location = "Above Ground"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, Tail flags, Approaches, Indifferent, Runs from

Tail twitches ✖

  • 0 29
  • 1 8

Moans ✖

  • 0 37

Location ✖

  • Above Ground · 37 ✖

Highlight Fur Color ✖

  • Cinnamon · 37 ✖

Foraging ✖

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
11 11 -73.9702676472613 40.7762126854894 13E-AM-1017-05 13E AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   on tree stump 0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9702676472613 40.7762126854894)
135 135 -73.9694168118643 40.7728877377977 11G-PM-1013-01 11G PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 In the Woods/Brush 0 0 1 0 1   0 0 0 0 0 0 0 1 watching me POINT (-73.9694168118643 40.7728877377977)
333 333 -73.9667560049684 40.7882333830729 27A-PM-1006-01 27A PM 10062018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   on a tree 0 0 0 1 1 walking up & down branches 0 0 0 0 0 0 1 0   POINT (-73.9667560049684 40.7882333830729)
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)
641 641 -73.97190362174459 40.7803588122409 17A-AM-1017-01 17A AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3 ground & tree 1 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.9719036217446 40.7803588122409)
760 760 -73.97182341595571 40.7810842503715 18A-AM-1012-02 18A AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 1 1 burying 0 0 0 1 0 0 0 1   POINT (-73.9718234159557 40.7810842503715)
930 930 -73.96220300857941 40.7917723228749 32B-AM-1017-01 32B AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 ran up a tree 1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9622030085794 40.7917723228749)
1020 1020 -73.97016933635 40.770545252978295 8H-AM-1017-05 08H AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.97016933635001 40.7705452529783)
1045 1045 -73.9730420696993 40.778615101972605 15B-AM-1014-01 15B AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9730420696993 40.7786151019726)
1163 1163 -73.9677096985223 40.7825358361204 21C-AM-1014-02 21C AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 50   1 1 1 0 1   0 1 0 0 0 0 0 0 looked at us from tree POINT (-73.9677096985223 40.7825358361204)
1179 1179 -73.9696762034757 40.7704883494264 8H-AM-1017-02 08H AM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7 root bed of tree 1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9696762034757 40.7704883494264)
1385 1385 -73.9615649773504 40.7954761311501 36A-PM-1013-02 36A PM 10132018 2   Gray Cinnamon Gray+Cinnamon   Above Ground 6   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9615649773504 40.7954761311501)
1425 1425 -73.95862528758559 40.7852027586217 27I-AM-1007-03 27I AM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon had .5 of a tail Above Ground 20   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9586252875856 40.7852027586217)
1429 1429 -73.9706533131129 40.768902033818996 6I-AM-1006-01 06I AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground     1 0 1 1 1   0 0 0 0 0 0 0 1 runs from (someone sneezed) POINT (-73.9706533131129 40.768902033819)
1564 1564 -73.9703816112358 40.777384606591895 15D-PM-1017-02 15D PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9703816112358 40.7773846065919)
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)
1661 1661 -73.974519308015 40.7691228794395 5E-AM-1008-02 05E AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8 trellis 1 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.974519308015 40.7691228794395)
1714 1714 -73.9763542780331 40.773653130362206 9B-AM-1010-02 09B AM 10102018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 1 in bush 0 0 1 0 1   0 0 0 0 1 0 0 1 froze POINT (-73.9763542780331 40.773653130362206)
1777 1777 -73.9711751356843 40.775242275820204 12E-AM-1017-06 12E AM 10172018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9711751356843 40.7752422758202)
1875 1875 -73.9527430510248 40.792480795055205 36I-PM-1007-12 36I PM 10072018 12 Juvenile Gray Cinnamon Gray+Cinnamon Tiny! So tiny! Above Ground 2   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9527430510248 40.7924807950552)
1923 1923 -73.9743795190073 40.7692030411004 5E-AM-1008-05 05E AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9743795190073 40.7692030411004)
2037 2037 -73.96833704175509 40.781359835050004 19D-AM-1007-02 19D AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 1 0 1   0 0 0 0 1 0 0 0 fenced area POINT (-73.9683370417551 40.78135983505)
2132 2132 -73.967472660349 40.7772125619715 16F-PM-1013-03 16F PM 10132018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 4 Woods 0 0 1 0 1   0 0 0 0 0 0 0 1   POINT (-73.96747266034902 40.7772125619715)
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)
2242 2242 -73.9565824187667 40.797312050952 40D-AM-1013-06 40D AM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   1 0 1 0 1   1 0 0 0 1 0 0 1   POINT (-73.9565824187667 40.797312050952)
2259 2259 -73.975565603566 40.7738462518304 9B-AM-1010-03 09B AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   1 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.975565603566 40.7738462518304)
2366 2366 -73.96761918469849 40.777641740816996 16F-PM-1013-04 16F PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.9676191846985 40.777641740817)
2515 2515 -73.9693338657183 40.775705588453796 13F-PM-1008-05 13F PM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 tree trunk 1 0 0 1 1   1 0 0 0 1 0 0 0   POINT (-73.9693338657183 40.77570558845381)
2522 2522 -73.9658747245917 40.77540337375321 14I-PM-1018-01 14I PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   Fallen branch 1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9658747245917 40.7754033737532)
2639 2639 -73.9543832609857 40.795355063970106 39F-AM-1014-02 39F AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 rocks 1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9543832609857 40.7953550639701)
2694 2694 -73.969628583287 40.770406779793205 8H-AM-1017-03 08H AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 fence 1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.969628583287 40.7704067797932)
2699 2699 -73.9743509423821 40.7690043677328 5F-AM-1007-02 05F AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   tree 1 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.97435094238212 40.7690043677328)
2700 2700 -73.9601988871514 40.7943473161329 35C-PM-1013-01 35C PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 1   1 1 0 1 1 0 1 0   POINT (-73.9601988871514 40.7943473161329)
2702 2702 -73.9588339897601 40.7848084865431 26I-PM-1010-06 26I PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 35 tree 0 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9588339897601 40.7848084865431)
2747 2747 -73.971314838366 40.774951285041 12E-AM-1017-03 12E AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.971314838366 40.774951285041)
2831 2831 -73.9753585157592 40.7698398607941 5E-AM-1008-07 05E AM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 on fence 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9753585157592 40.7698398607941)
2870 2870 -73.9538475741188 40.796479421955 40F-PM-1006-02 40F PM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9538475741188 40.796479421955)

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