2018_Central_Park_Squirrel_Census_-_Squirrel_Data

40 rows where Foraging = 0, Hectare Squirrel Number = 5 and Highlight Fur Color = "Cinnamon" sorted by Color notes

✎ View and edit SQL

This data as json, CSV (advanced)

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

Highlight Fur Color ✖

  • Cinnamon · 40 ✖

Hectare Squirrel Number ✖

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
20 20 -73.9706105896967 40.769812482150705 7H-AM-1006-05 07H AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9706105896967 40.7698124821507)
37 37 -73.96431539204279 40.78208185169571 22F-PM-1014-05 22F PM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9643153920428 40.7820818516957)
57 57 -73.9690175838534 40.77604327200171 14F-AM-1007-05 14F AM 10072018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9690175838534 40.7760432720017)
85 85 -73.9676410497481 40.7766043512974 15G-PM-1019-05 15G PM 10192018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9676410497481 40.7766043512974)
213 213 -73.968367485157 40.7838472644815 22B-PM-1014-05 22B PM 10142018 5   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0 eating (eats with head tilted far to the right (tooth issue?)) 0 0 0 0 0 0 0 0   POINT (-73.968367485157 40.7838472644815)
337 337 -73.95831019276521 40.7852649316039 27I-PM-1020-05 27I PM 10202018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 In tree 1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (us) POINT (-73.9583101927652 40.7852649316039)
339 339 -73.965509576403 40.7752456763263 14I-PM-1018-05 14I PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 1 1 0   0 0 0 0 1 0 1 0   POINT (-73.96550957640301 40.7752456763263)
416 416 -73.9702788578386 40.7694484997295 7I-PM-1013-05 07I PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Rock 0 0 0 1 0   0 0 0 1 0 0 0 0   POINT (-73.9702788578386 40.7694484997295)
447 447 -73.97259060164741 40.7713889729739 8F-PM-1012-05 08F PM 10122018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9725906016474 40.7713889729739)
536 536 -73.9561141662309 40.7976258458604 40D-PM-1013-05 40D PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9561141662309 40.7976258458604)
562 562 -73.972467515471 40.7659131865172 3I-PM-1013-05 03I PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.972467515471 40.7659131865172)
613 613 -73.9688466874605 40.77379115598671 12G-PM-1007-05 12G PM 10072018 5   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9688466874605 40.7737911559867)
647 647 -73.9734762649298 40.7663703404546 3H-AM-1008-05 03H AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   0 0 1 0 0   0 0 0 0 1 0 0 0   POINT (-73.9734762649298 40.7663703404546)
765 765 -73.96797780019 40.784762947325795 23B-PM-1012-05 23B PM 10122018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 chain link fence 0 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.96797780019 40.7847629473258)
1025 1025 -73.9763506612375 40.771611393182 7C-PM-1020-05 07C PM 10202018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9763506612375 40.771611393182)
1174 1174 -73.9682067129876 40.7779911208015 16E-PM-1018-05 16E PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 staring 0 0 0 1 0 1 0 0 approaches (very close) POINT (-73.9682067129876 40.7779911208015)
1367 1367 -73.9542684235907 40.7944237164092 38G-PM-1020-05 38G PM 10202018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 1 0 1 0 0 1 0   POINT (-73.9542684235907 40.7944237164092)
1400 1400 -73.97734958071351 40.7664559937331 1E-AM-1006-05 01E AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9773495807135 40.7664559937331)
1467 1467 -73.9684657285532 40.7840113573723 22B-AM-1013-05 22B AM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   tree 0 0 1 0 0   0 0 0 0 0 0 0 0 looked down on me like her imperial subject POINT (-73.9684657285532 40.7840113573723)
1491 1491 -73.97130702170709 40.7753795014815 12E-AM-1017-05 12E AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9713070217071 40.7753795014815)
1695 1695 -73.9604083891356 40.7910284106931 32D-AM-1013-05 32D AM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9604083891356 40.7910284106931)
1705 1705 -73.97654172820009 40.7740994735325 9A-AM-1013-05 09A AM 10132018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9765417282001 40.7740994735325)
1734 1734 -73.9524132295658 40.7933777553406 37I-AM-1010-05 37I AM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.95241322956582 40.7933777553406)
1735 1735 -73.9563652303243 40.795512787396795 38E-PM-1014-05 38E PM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE on log 0 0 0 0 0 statue 0 0 0 0 0 0 1 0   POINT (-73.9563652303243 40.7955127873968)
1754 1754 -73.9652134469963 40.7803438278765 19F-PM-1017-05 19F PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9652134469963 40.7803438278765)
1762 1762 -73.9769106838192 40.7674414870702 2E-AM-1010-05 02E AM 10102018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 33   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9769106838192 40.7674414870702)
1995 1995 -73.9603366992925 40.7899612889539 31E-PM-1006-05 31E PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9603366992925 40.789961288953904)
2074 2074 -73.9676246014119 40.786355136088 24A-PM-1007-05 24A PM 10072018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 45 in tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9676246014119 40.786355136088)
2107 2107 -73.9772624834791 40.769282191854295 4C-PM-1010-05 04C PM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9772624834791 40.7692821918543)
2159 2159 -73.9696688162449 40.774142217718705 12F-AM-1020-05 12F AM 10202018 5 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.9696688162449 40.7741422177187)
2164 2164 -73.955013129397 40.7954024311542 38F-AM-1018-05 38F AM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 ran up tree 0 0 0 0 0 0 0 1   POINT (-73.955013129397 40.7954024311542)
2365 2365 -73.96887733063241 40.7766669852358 15F-AM-1007-05 15F AM 10072018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9688773306324 40.7766669852358)
2703 2703 -73.9690174442945 40.7817617696508 19C-PM-1018-05 19C PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.9690174442945 40.7817617696508)
2877 2877 -73.9730027200009 40.7798000868804 16A-PM-1019-05 16A PM 10192018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9730027200009 40.7798000868804)
2889 2889 -73.9771646835311 40.769304916508396 4C-PM-1010-05 04C PM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9771646835311 40.7693049165084)
2899 2899 -73.9686358129525 40.7778035516486 16E-AM-1014-05 16E AM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9686358129525 40.7778035516486)
2923 2923 -73.9672160533827 40.7830263908749 21C-AM-1014-05 21C AM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9672160533827 40.7830263908749)
2925 2925 -73.96721526968341 40.782387458182896 21D-AM-1008-05 21D AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9672152696834 40.7823874581829)
2936 2936 -73.9809876538513 40.768322324214296 1A-PM-1014-05 01A PM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9809876538513 40.7683223242143)
2940 2940 -73.963911430308 40.7809127228847 21G-AM-1014-05 21G AM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.963911430308 40.7809127228847)

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