2018_Central_Park_Squirrel_Census_-_Squirrel_Data

144 rows where Date = 10122018 and Running = 0 sorted by Quaas

✎ View and edit SQL

This data as json, CSV (advanced)

Hectare Squirrel Number ✖

Age ✖

Running ✖

Date ✖

  • 10122018 · 44 ✖
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
2323 2323 -73.9715921982161 40.7746153066601 11E-PM-1012-06 11E PM 10122018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Above Ground 5   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9715921982161 40.7746153066601)
2328 2328 -73.9678620840741 40.784719027304 23B-PM-1012-03 23B PM 10122018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 1 2/3 were chasing each other 0 0 0 0 1 0 0 1   POINT (-73.96786208407411 40.784719027304)
2367 2367 -73.9681671864047 40.7753770538635 14G-AM-1012-04 14G AM 10122018 4 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9681671864047 40.7753770538635)
2369 2369 -73.9801956082236 40.767836440957 1B-AM-1012-08 01B AM 10122018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9801956082236 40.767836440957)
2372 2372 -73.9724879969884 40.771098202397 8F-PM-1012-07 08F PM 10122018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 17   0 0 1 0 0 gathering 0 0 0 0 0 0 0 0   POINT (-73.9724879969884 40.771098202397)
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)
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)
2390 2390 -73.9680741975294 40.7847036778165 23B-PM-1012-04 23B PM 10122018 4 Adult Gray White Gray+White   Above Ground 20   0 0 0 0 0 watching me - didn't move 0 0 0 0 1 0 0 1   POINT (-73.9680741975294 40.7847036778165)
2405 2405 -73.9588361742943 40.791115225155 33E-PM-1012-02 33E PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9588361742943 40.791115225155)
2428 2428 -73.9755643404768 40.769756914938796 5E-PM-1012-03 05E PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9755643404768 40.7697569149388)
2430 2430 -73.9569811285656 40.793091234605 35F-PM-1012-02 35F PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9569811285656 40.793091234605)
2447 2447 -73.9589670987899 40.795212703928705 37C-AM-1012-04 37C AM 10122018 4 Adult Gray Cinnamon Gray+Cinnamon Cinnamon flanks Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9589670987899 40.7952127039287)
2477 2477 -73.9663297144622 40.7837932023685 22D-PM-1012-03 22D PM 10122018 3 Adult Gray Black, White Gray+Black, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9663297144622 40.7837932023685)
2480 2480 -73.9546780963388 40.790321652211105 34I-AM-1012-03 34I AM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 0 nut in mouth 0 0 0 0 0 0 1 0   POINT (-73.9546780963388 40.7903216522111)
2492 2492 -73.9801619956135 40.76785766975421 1B-AM-1012-09 01B AM 10122018 9 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9801619956135 40.7678576697542)
2494 2494 -73.9713968424625 40.774039018852704 11E-PM-1012-03 11E PM 10122018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9713968424625 40.7740390188527)
2511 2511 -73.95845615374209 40.791121116475395 33F-PM-1012-02 33F PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 1 0 0 0   POINT (-73.9584561537421 40.7911211164754)
2538 2538 -73.9796985410897 40.767861283506704 1B-AM-1012-01 01B AM 10122018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9796985410897 40.7678612835067)
2568 2568 -73.9779039082557 40.7675313108314 2D-PM-1012-01 02D PM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9779039082557 40.7675313108314)
2591 2591 -73.9786351029146 40.771611416400205 6A-PM-1012-06 06A PM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE elevated ground 0 1 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9786351029146 40.771611416400205)
2598 2598 -73.976658503418 40.768686845691704 4D-AM-1012-03 04D AM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   0 1 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.976658503418 40.7686868456917)
2600 2600 -73.9544553697736 40.7912866208106 34I-AM-1012-01 34I AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9544553697736 40.7912866208106)
2617 2617 -73.9564228238736 40.7936908887644 36F-PM-1012-06 36F PM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9564228238736 40.7936908887644)
2638 2638 -73.9598973337711 40.793334636047796 34C-PM-1012-01 34C PM 10122018 1 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9598973337711 40.7933346360478)
2666 2666 -73.9763593390732 40.771729705854895 7C-AM-1012-03 07C AM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 foraging (loving the acorns!) 0 0 0 0 0 0 1 0   POINT (-73.97635933907321 40.7717297058549)
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)
2742 2742 -73.96280415779341 40.7884180156055 28D-AM-1012-06 28D AM 10122018 6 Juvenile Cinnamon White Cinnamon+White   Above Ground 5   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9628041577934 40.78841801560551)
2745 2745 -73.97296259363002 40.7652601851275 1I-PM-1012-04 01I PM 10122018 4 Juvenile Cinnamon White Cinnamon+White Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 2 on ledge 0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.97296259363 40.7652601851275)
2757 2757 -73.96714191194559 40.77586024868621 14G-AM-1012-01 14G AM 10122018 1 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9671419119456 40.7758602486862)
2806 2806 -73.9714298880357 40.774105786890004 11E-PM-1012-02 11E PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9714298880357 40.77410578689)
2823 2823 -73.9664054327771 40.7756180893318 14H-PM-1012-07 14H PM 10122018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9664054327771 40.7756180893318)
2852 2852 -73.9728146482385 40.7652951714745 1I-PM-1012-03 01I PM 10122018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Gray, Black, & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 0 0 1   POINT (-73.97281464823851 40.765295171474506)
2860 2860 -73.95651796713192 40.7936663940365 36F-PM-1012-03 36F PM 10122018 3   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.95651796713192 40.7936663940365)
2872 2872 -73.96153964579959 40.792359436678296 33C-AM-1012-01 33C AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon along tail & back Above Ground 20 tree branches 0 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9615396457996 40.7923594366783)
2880 2880 -73.9726598256924 40.7707862446236 7F-PM-1012-03 07F PM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 0 1   POINT (-73.9726598256924 40.7707862446236)
2898 2898 -73.97941182346509 40.767449554056896 1C-AM-1012-02 01C AM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9794118234651 40.7674495540569)
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)
2986 2986 -73.97565337638129 40.7733537881363 8B-PM-1012-07 08B PM 10122018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9756533763813 40.7733537881363)
2988 2988 -73.9766342759486 40.7687518380873 4D-AM-1012-04 04D AM 10122018 4 Adult Gray   Gray+   Above Ground 3 on tree trunk 0 1 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9766342759486 40.7687518380873)
3000 3000 -73.9688293382172 40.7738958027568 12G-AM-1012-04 12G AM 10122018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9688293382172 40.773895802756805)
3011 3011 -73.96788313129359 40.7847605974975 23B-PM-1012-06 23B PM 10122018 6 Adult Gray   Gray+   Above Ground 30   0 0 0 0 0   1 0 0 0 0 0 0 0 scolding POINT (-73.9678831312936 40.7847605974975)
3021 3021 -73.96658719935171 40.783677506488296 22D-PM-1012-07 22D PM 10122018 7 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9665871993517 40.7836775064883)
3023 3023 -73.97547941915529 40.7696404489025 5E-PM-1012-01 05E PM 10122018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9754794191553 40.7696404489025)
1475 1475 -73.96867781674841 40.7765625256946 14F-PM-1012-04 14F PM 10122018 4       +         0 0 0 0 0   1 1 0 0 0 0 0 0   POINT (-73.96867781674841 40.7765625256946)

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