2018_Central_Park_Squirrel_Census_-_Squirrel_Data

44 rows where Hectare Squirrel Number = 5, Highlight Fur Color = "Cinnamon" and Indifferent = 0 sorted by Lat/Long

✎ 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, Foraging, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Runs from

Indifferent ✖

Highlight Fur Color ✖

  • Cinnamon · 44 ✖

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 ▼
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)
231 231 -73.9527808174534 40.7924167234441 36I-AM-1017-05 36I AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1 runs from (me) POINT (-73.9527808174534 40.7924167234441)
474 474 -73.9540652304705 40.7955226178199 39G-PM-1013-05 39G PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9540652304705 40.7955226178199)
101 101 -73.9544007658685 40.7950689723135 38F-PM-1013-05 38F PM 10132018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 being chased,was pushed by other squirrel 1 1 0 0 0 0 0 0   POINT (-73.9544007658685 40.7950689723135)
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)
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)
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)
2439 2439 -73.95874591363909 40.7982497351812 40B-PM-1014-05 40B PM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9587459136391 40.7982497351812)
989 989 -73.96030310596142 40.7943667735668 35C-PM-1013-05 35C PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9603031059614 40.7943667735668)
1501 1501 -73.96081673001041 40.795434868826796 36A-PM-1013-05 36A PM 10132018 5   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE EDGE OF WOODS 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9608167300104 40.7954348688268)
2196 2196 -73.96233563694321 40.7888693815168 29D-AM-1014-05 29D AM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Rocky area 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9623356369432 40.7888693815168)
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)
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)
313 313 -73.9646610347972 40.7790583544252 19H-AM-1010-05 19H AM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE near a brush 0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9646610347972 40.7790583544252)
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)
909 909 -73.9665705456197 40.782355287104394 21D-PM-1008-05 21D PM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9665705456197 40.7823552871044)
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)
1571 1571 -73.96731290103119 40.7778169845999 16F-PM-1013-05 16F PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Pine tree near utility shed 0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9673129010312 40.7778169845999)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
697 697 -73.97046560040201 40.770112577324795 7H-PM-1006-05 07H PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ran across path to eat behind fence, next to the fence. 1 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.970465600402 40.7701125773248)
1366 1366 -73.97115821991021 40.7783674409485 15C-PM-1017-05 15C PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   1 0 0 0 1 1 0 0   POINT (-73.9711582199102 40.7783674409485)
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)
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)
1336 1336 -73.97338200536791 40.76873304735621 5G-PM-1010-05 05G PM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9733820053679 40.7687330473562)
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)
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)
2148 2148 -73.9767317539505 40.7717600450632 6B-PM-1017-05 06B PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9767317539505 40.7717600450632)
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)
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)
90 90 -73.97871808707359 40.7715877863274 5A-AM-1006-05 05A AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE near 65th St arch 0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9787180870736 40.7715877863274)
70 70 -73.9804528867547 40.7696753655986 3A-PM-1017-05 03A PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9804528867547 40.76967536559861)
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)

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