2018_Central_Park_Squirrel_Census_-_Squirrel_Data

149 rows where Hectare Squirrel Number = 1 and Runs from = 1 sorted by Unique Squirrel ID

✎ View and edit SQL

This data as json, CSV (advanced)

Tail twitches ✖

  • 0 44
  • 1 5

Tail flags ✖

  • 0 46
  • 1 3

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
1098 1098 -73.96049542761291 40.7965682182001 37A-AM-1012-01 37A AM 10122018 1 Adult Cinnamon Gray Cinnamon+Gray Drawing included on tally sheet Ground Plane FALSE   0 0 0 0 1 scanning (drawing included) 0 0 0 0 0 0 0 1   POINT (-73.9604954276129 40.7965682182001)
2143 2143 -73.9596232170232 40.7959550843229 37B-PM-1013-01 37B PM 10132018 1 Adult Gray   Gray+ Sighting was far away Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9596232170232 40.795955084322905)
2381 2381 -73.95884149804891 40.7953525481367 37C-AM-1012-01 37C AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 caching 0 0 0 0 0 0 0 1   POINT (-73.9588414980489 40.7953525481367)
3010 3010 -73.9580906814132 40.7948404060484 37D-PM-1014-01 37D PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1 eyes from a safe distance POINT (-73.9580906814132 40.7948404060484)
177 177 -73.9554432393295 40.794566905444896 37F-PM-1014-01 37F PM 10142018 1   Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9554432393295 40.7945669054449)
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)
1107 1107 -73.95307395621309 40.7932034409546 37H-PM-1006-01 37H PM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1 from voice POINT (-73.95307395621312 40.7932034409546)
283 283 -73.9529060669193 40.79279097353879 37I-AM-1010-01 37I AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9529060669193 40.7927909735388)
403 403 -73.9597470659927 40.797321593541604 38A-PM-1013-01 38A PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9597470659927 40.7973215935416)
170 170 -73.95972059663241 40.7969409510133 38B-AM-1019-01 38B AM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9597205966324 40.7969409510133)
365 365 -73.9576035072364 40.7966120824816 38C-AM-1019-01 38C AM 10192018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (lawnmower) POINT (-73.9576035072364 40.7966120824816)
2647 2647 -73.954499539822 40.7949716693686 38F-AM-1018-01 38F AM 10182018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.954499539822 40.7949716693686)
193 193 -73.9537691298752 40.7941272599797 38G-PM-1020-01 38G PM 10202018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9537691298752 40.7941272599797)
2929 2929 -73.953123365424 40.7941113777459 38H-PM-1012-01 38H PM 10122018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.953123365424 40.7941113777459)
1183 1183 -73.9525699067954 40.7937125788106 38I-PM-1014-01 38I PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE on the lawn East of the fountain 0 0 0 0 0 scampering thru the grass! 0 0 0 0 1 0 0 1   POINT (-73.9525699067954 40.7937125788106)
1412 1412 -73.9594676326588 40.7984457363388 39A-AM-1013-01 39A AM 10132018 1 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9594676326588 40.7984457363388)
2888 2888 -73.955258162768 40.7958147673603 39E-AM-1018-01 39E AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 standing still 0 0 0 0 0 0 0 1   POINT (-73.955258162768 40.7958147673603)
1865 1865 -73.9558118887106 40.796885713436 39E-PM-1013-01 39E PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon head Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9558118887106 40.796885713436005)
2389 2389 -73.9801343393329 40.769151245340204 3A-AM-1012-01 03A AM 10122018 1 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 1   0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9801343393329 40.7691512453402)
2583 2583 -73.97696931406509 40.7684390015166 3D-AM-1006-01 03D AM 10062018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 9 up a tree 1 0 1 1 1 digging (?) 0 0 0 1 0 0 0 1 runs from (man led his dog into the area to chase squirrel) POINT (-73.9769693140651 40.7684390015166)
675 675 -73.9759830650957 40.7683034739069 3E-AM-1006-01 03E AM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9759830650957 40.7683034739069)
195 195 -73.97377736133109 40.7673662611015 3G-PM-1013-01 03G PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9737773613311 40.7673662611015)
2070 2070 -73.9725700261894 40.7668793330427 3H-PM-1014-01 03H PM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE under a parked car 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9725700261894 40.7668793330427)
2182 2182 -73.9573656523498 40.7979754563974 40C-AM-1017-01 40C AM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0 chasing (#2) 0 0 0 0 0 0 0 1   POINT (-73.9573656523498 40.7979754563974)
386 386 -73.95503513809571 40.7974681522214 40E-AM-1014-01 40E AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9550351380957 40.7974681522214)
1830 1830 -73.95180081495641 40.7953738093588 40H-AM-1017-01 40H AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE base of tree 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9518008149564 40.7953738093588)
102 102 -73.95759861613641 40.799368134968 41B-PM-1014-01 41B PM 10142018 1 Adult Gray White Gray+White   Above Ground 25 Climbing tree 0 0 1 0 0 climbing (tree) 0 0 0 0 0 0 0 1   POINT (-73.9575986161364 40.799368134968)
1307 1307 -73.9565197137317 40.7986011403785 41C-PM-1007-01 41C PM 10072018 1 Adult Black   Black+   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9565197137317 40.7986011403785)
581 581 -73.9556218199258 40.7980460204041 41D-PM-1014-01 41D PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0 digging,drinking 0 0 0 0 0 0 0 1   POINT (-73.9556218199258 40.7980460204041)
2446 2446 -73.95227045119691 40.796566887896105 41G-AM-1013-01 41G AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9522704511969 40.7965668878961)
2350 2350 -73.9564777440695 40.7993068355401 42C-AM-1007-01 42C AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 nut in mouth 0 0 0 0 0 0 0 1   POINT (-73.9564777440695 40.7993068355401)
2342 2342 -73.9533645762606 40.7983709215535 42F-AM-1019-01 42F AM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 1 0 0 1 runs from (me) POINT (-73.9533645762606 40.7983709215535)
913 913 -73.9514111329059 40.797508587289705 42G-AM-1018-01 42G AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 1   POINT (-73.9514111329059 40.797508587289705)
601 601 -73.9522291603405 40.7976985385835 42G-PM-1014-01 42G PM 10142018 1 Adult Gray White Gray+White   Above Ground 8   0 0 1 0 1   0 0 1 0 0 0 0 1   POINT (-73.9522291603405 40.7976985385835)
2244 2244 -73.9509628195532 40.797777567417796 42H-PM-1014-01 42H PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   0 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9509628195532 40.7977775674178)
813 813 -73.9758959798289 40.7694125671679 4D-PM-1008-01 04D PM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9758959798289 40.7694125671679)
2166 2166 -73.9711178122133 40.7672642958437 4I-PM-1007-01 04I PM 10072018 1 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9711178122133 40.76726429584371)
1033 1033 -73.975673607467 40.7699044294204 5D-PM-1018-01 05D PM 10182018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.975673607467 40.7699044294204)
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)
2423 2423 -73.973552877209 40.7715638228207 7E-PM-1013-01 07E PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ground & Tree Base 1 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.973552877209 40.7715638228207)
2585 2585 -73.9771726831497 40.7732320781799 8A-AM-1013-01 08A AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE trail 1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9771726831497 40.7732320781799)
643 643 -73.976730206737 40.773709213913996 8A-PM-1014-01 08A PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 0   1 0 0 0 0 0 0 1 runs from (goes up a tree) POINT (-73.976730206737 40.773709213914)
2673 2673 -73.9768867959365 40.7734803954589 8B-PM-1012-01 08B PM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9768867959365 40.7734803954589)
1621 1621 -73.97349693209429 40.7722754599865 8E-AM-1013-01 08E AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9734969320943 40.7722754599865)
2371 2371 -73.9769520212123 40.774006725862996 9A-AM-1013-01 09A AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9769520212123 40.774006725863)
769 769 -73.976521916284 40.773784724458 9B-AM-1010-01 09B AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   1 0 0 0 0 0 0 1   POINT (-73.976521916284 40.773784724458)
540 540 -73.97468021940121 40.7731347452245 9C-PM-1006-01 09C PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9746802194012 40.7731347452245)
507 507 -73.9744835563086 40.7729521433235 9D-AM-1008-01 09D AM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9744835563086 40.7729521433235)
1261 1261 -73.9719109949232 40.772313852132704 9F-AM-1013-01 09F AM 10132018 1 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9719109949232 40.7723138521327)

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