2018_Central_Park_Squirrel_Census_-_Squirrel_Data

154 rows where Hectare Squirrel Number = 5 and Indifferent = 0 sorted by Approaches

✎ View and edit SQL

This data as json, CSV (advanced)

Running ✖

  • 1 29
  • 0 25

Indifferent ✖

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
2061 2061 -73.9608834102446 40.790624710005005 31D-AM-1014-05 31D AM 10142018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9608834102446 40.790624710005)
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)
2084 2084 -73.9567255763265 40.7936331899263 36F-AM-1017-05 36F AM 10172018 5 Adult Gray White Gray+White   Above Ground 8   0 0 0 0 0 staying very still to avoid two very curious dogs on the ground 0 0 0 0 0 0 0 0 petrified,frozen (tail over its back,frozen) POINT (-73.9567255763265 40.7936331899263)
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)
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)
2152 2152 -73.9686925781295 40.7705688673142 9I-PM-1010-05 09I PM 10102018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9686925781295 40.7705688673142)
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)
2173 2173 -73.95461232594408 40.7941434862099 37G-PM-1007-05 37G PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0 jumping around! 0 0 0 0 0 0 0 0   POINT (-73.9546123259441 40.7941434862099)
2176 2176 -73.9583201789615 40.7913938722521 33F-PM-1012-05 33F PM 10122018 5 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 0 1   1 0 0 1 1 0 0 1   POINT (-73.95832017896151 40.7913938722521)
2209 2209 -73.9697583235533 40.7787320391004 16D-AM-1007-05 16D AM 10072018 5 Adult Gray   Gray+ didn't get a good look Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.96975832355331 40.7787320391004)
2240 2240 -73.9697787673802 40.7781746195436 16D-PM-1010-05 16D PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9697787673802 40.7781746195436)
2245 2245 -73.9774228454023 40.7686399839016 3D-AM-1006-05 03D AM 10062018 5 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (chased by boy),wary of humans in playground POINT (-73.9774228454023 40.7686399839016)
2344 2344 -73.9786310308892 40.766934936818295 1D-AM-1006-05 01D AM 10062018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.9786310308892 40.7669349368183)
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)
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)
2464 2464 -73.96913180449691 40.770980197469605 9I-AM-1014-05 09I AM 10142018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9691318044969 40.7709801974696)
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)
2604 2604 -73.9605163698302 40.7914179994956 32D-PM-1006-05 32D PM 10062018 5 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 1 1 0   0 0 0 0 1 0 0 1   POINT (-73.9605163698302 40.7914179994956)
2651 2651 -73.9632993246327 40.78881995196561 29C-AM-1007-05 29C AM 10072018 5 Adult Black Gray Black+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9632993246327 40.7888199519656)
2658 2658 -73.9690212174 40.783409940410706 21B-PM-1017-05 21B PM 10172018 5 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9690212174 40.7834099404107)
2659 2659 -73.95536034380208 40.7985282963244 41D-PM-1014-05 41D PM 10142018 5 Adult Gray White Gray+White   Above Ground 12   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9553603438021 40.7985282963244)
2693 2693 -73.95614986460359 40.7949288561893 37E-AM-1013-05 37E AM 10132018 5 ?     +   Above Ground 10 unsure, just heard kuks 0 0 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9561498646036 40.79492885618931)
2701 2701 -73.97912175106559 40.767658347539395 2C-AM-1010-05 02C AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE right at the base of the same tree as #3 0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9791217510656 40.7676583475394)
2733 2733 -73.9690082314914 40.7738993942891 12G-AM-1012-05 12G AM 10122018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0   1 0 0 0 0 0 0 1   POINT (-73.9690082314914 40.7738993942891)
2767 2767 -73.9751806727197 40.7671940332258 3F-PM-1013-05 03F PM 10132018 5 Adult Gray White Gray+White   Above Ground 13   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.97518067271972 40.7671940332258)
2777 2777 -73.98108436110859 40.768790549369896 2A-PM-1019-05 02A PM 10192018 5 ? Gray   Gray+   Above Ground 50 in tall planetree 1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9810843611086 40.7687905493699)
2817 2817 -73.9596445861554 40.79719486790071 38A-PM-1013-05 38A PM 10132018 5 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9596445861554 40.7971948679007)
2820 2820 -73.9615926031253 40.7944223235385 35B-PM-1013-05 35B PM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 0 0 chased by dog #2 1 0 0 0 0 0 0 1 runs from (dog) POINT (-73.96159260312531 40.7944223235385)
2873 2873 -73.955068474109 40.79117881528779 34H-PM-1006-05 34H PM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White white tail tip Ground Plane FALSE in grass 1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.955068474109 40.7911788152878)
2875 2875 -73.95466167829221 40.790974533738996 34I-PM-1010-05 34I PM 10102018 5 Adult Gray   Gray+         0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9546616782922 40.790974533739)
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)
2913 2913 -73.9621297946132 40.7944058222814 34A-PM-1013-05 34A PM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9621297946132 40.7944058222814)
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)
2930 2930 -73.9692563597762 40.770904999952 9H-PM-1018-05 09H PM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9692563597762 40.770904999952)
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)
2944 2944 -73.97394038506219 40.769316228750895 5F-AM-1007-05 05F AM 10072018 5 Adult Gray White Gray+White   Above Ground 2 tree 1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9739403850622 40.7693162287509)
2991 2991 -73.96846326736029 40.784890952519795 23A-AM-1018-05 23A AM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9684632673603 40.7848909525198)
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)
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)
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)
1428 1428 -73.9666113598566 40.775266255031205 14H-PM-1012-05 14H PM 10122018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 0 0 approaches (someone was feeding it) POINT (-73.9666113598566 40.7752662550312)
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)
1947 1947 -73.97471754195459 40.769282003087795 5E-PM-1012-05 05E PM 10122018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 1 0 0 begging POINT (-73.9747175419546 40.7692820030878)
2087 2087 -73.956502663005 40.788160908881004 30I-PM-1006-05 30I PM 10062018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.956502663005 40.788160908881)
2131 2131 -73.9752225195115 40.7703747669865 6D-PM-1020-05 06D PM 10202018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9752225195115 40.7703747669865)
2170 2170 -73.9678923667678 40.7819675626236 20C-PM-1018-05 20C PM 10182018 5 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.9678923667678 40.781967562623606)
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)
2646 2646 -73.9772239251936 40.7731716665766 8A-AM-1013-05 08A AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   1 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9772239251936 40.7731716665766)
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)
2750 2750 -73.957775998085 40.7932880937406 35E-PM-1006-05 35E PM 10062018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.957775998085 40.7932880937406)

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