2018_Central_Park_Squirrel_Census_-_Squirrel_Data

140 rows where Approaches = 1 and Running = 0 sorted by Climbing

✎ View and edit SQL

This data as json, CSV (advanced)

Hectare Squirrel Number ✖

Running ✖

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
2383 2383 -73.9686551213305 40.772861783717396 11H-PM-1013-04 11H PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 1 0   POINT (-73.9686551213305 40.7728617837174)
2399 2399 -73.9583762071264 40.7852226065643 27I-PM-1020-03 27I PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 1 0 0 begging for food; on hind legs POINT (-73.9583762071264 40.7852226065643)
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)
2453 2453 -73.9756105226696 40.7696531972655 5D-AM-1020-03 05D AM 10202018 3 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9756105226696 40.7696531972655)
2504 2504 -73.9550131837533 40.7958617258176 39E-PM-1013-02 39E PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray Gray tail & butt Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 1 0   POINT (-73.9550131837533 40.7958617258176)
2523 2523 -73.9619016393127 40.792516012692104 33B-PM-1010-06 33B PM 10102018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9619016393127 40.7925160126921)
2536 2536 -73.96850872880721 40.7779068128051 16E-AM-1014-01 16E AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 burying food 0 0 0 0 0 1 0 0   POINT (-73.9685087288072 40.7779068128051)
2575 2575 -73.97357533521291 40.7687061447032 5G-PM-1010-04 05G PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9735753352129 40.7687061447032)
2590 2590 -73.9568524771058 40.7974664985551 40C-PM-1006-06 40C PM 10062018 6 Juvenile Gray   Gray+   Ground Plane FALSE By The Road 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9568524771058 40.7974664985551)
2610 2610 -73.9713379914423 40.7696367609606 7H-PM-1006-01 07H PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE middle of grass 0 0 0 1 1   0 0 0 0 1 1 0 0   POINT (-73.9713379914423 40.7696367609606)
2636 2636 -73.9700264128414 40.7692014637698 7I-PM-1013-01 07I PM 10132018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE Bench 0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9700264128414 40.7692014637698)
2685 2685 -73.9601851468038 40.7968698151479 38A-AM-1019-05 38A AM 10192018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon head, White belly Ground Plane FALSE   0 0 0 0 1 standing on back legs 0 0 0 0 0 1 1 0   POINT (-73.9601851468038 40.7968698151479)
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)
2816 2816 -73.9809342290598 40.7687265606227 2A-AM-1010-05 02A AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE base of tree with ~ 30 small birds all eating 0 0 0 1 1   0 0 0 0 1 1 1 0   POINT (-73.9809342290598 40.7687265606227)
2856 2856 -73.9751615527833 40.767013871509 3F-AM-1006-03 03F AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Ground Plane FALSE on the path 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9751615527833 40.767013871509)
2922 2922 -73.97034213914421 40.7773706575356 14D-AM-1014-01 14D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9703421391442 40.7773706575356)
2928 2928 -73.9767953468937 40.7676376977667 3E-AM-1006-03 03E AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 checkin' his stashes 0 0 0 1 0 1 0 1   POINT (-73.9767953468937 40.7676376977667)
2931 2931 -73.9730926233232 40.7781330751738 14B-PM-1014-08 14B PM 10142018 8   Gray Cinnamon, White Gray+Cinnamon, White White belly & stripes on tail, Cinnamon face & stripes on back Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9730926233232 40.7781330751738)
2932 2932 -73.9705837974358 40.775849484967296 13E-AM-1017-13 13E AM 10172018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE on rock 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.97058379743581 40.7758494849673)
2957 2957 -73.97473131521521 40.7653888351839 1G-PM-1010-03 01G PM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9747313152152 40.7653888351839)
2976 2976 -73.97240833205379 40.7744163768061 11D-AM-1010-08 11D AM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1 drinking 0 0 0 0 0 1 0 0   POINT (-73.9724083320538 40.7744163768061)
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)
230 230 -73.97314980648721 40.7659963196581 2H-AM-1006-02 02H AM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.9731498064872 40.7659963196581)
271 271 -73.9661262885099 40.7844085550945 23D-AM-1013-01 23D AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   0 0 1 0 0   0 0 0 0 0 1 0 0 approaches (he saw me,came towards,then darted up) POINT (-73.9661262885099 40.7844085550945)
738 738 -73.9725712588741 40.7669101832926 4H-AM-1006-02 04H AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0 climbing (over small wire fence then on the ground) 0 0 0 0 0 1 0 1 approaches (saw me & came forward),runs from (startled by another person) POINT (-73.9725712588741 40.7669101832926)
850 850 -73.9642288873015 40.782043998356706 22F-AM-1007-06 22F AM 10072018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9642288873015 40.7820439983567)
917 917 -73.9676514056678 40.7730853732876 11H-AM-1010-01 11H AM 10102018 1 Adult Gray White Gray+White   Above Ground 20   0 0 1 0 0   0 0 0 0 0 1 0 0 started climbing down to me POINT (-73.9676514056678 40.7730853732876)
1215 1215 -73.9728895595977 40.769937833229896 6F-AM-1006-01 06F AM 10062018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9728895595977 40.7699378332299)
1591 1591 -73.95762233900821 40.79797466396471 40B-AM-1019-04 40B AM 10192018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 1 1 0   POINT (-73.9576223390082 40.79797466396471)
1683 1683 -73.9790889008147 40.7676402781925 1C-PM-1013-01 01C PM 10132018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 1 0 0   POINT (-73.9790889008147 40.7676402781925)
1862 1862 -73.97648512317541 40.771573686286104 6C-AM-1007-07 06C AM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0 ambling 0 0 0 0 0 1 0 1 trucks POINT (-73.9764851231754 40.7715736862861)
2005 2005 -73.9755259087781 40.770725612418104 6D-AM-1008-01 06D AM 10082018 1 Adult Cinnamon White Cinnamon+White   Above Ground 10   0 0 1 1 0   1 0 0 0 0 1 0 0   POINT (-73.9755259087781 40.7707256124181)
2123 2123 -73.959874668294 40.7907004233491 32E-AM-1007-09 32E AM 10072018 9 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.959874668294 40.7907004233491)
2187 2187 -73.96991340526091 40.774446589038 12F-PM-1007-14 12F PM 10072018 14 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 1 1 0   POINT (-73.9699134052609 40.774446589038)
2380 2380 -73.97613757295049 40.766223189212496 1F-PM-1019-02 01F PM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9761375729505 40.7662231892125)
2455 2455 -73.9577297187155 40.799225295679 41B-AM-1010-08 41B AM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 20   0 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9577297187155 40.799225295679)
2586 2586 -73.9752965316933 40.775253857578896 10B-AM-1006-03 10B AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   In tree 0 0 1 0 0   0 0 0 0 1 1 0 0   POINT (-73.9752965316933 40.7752538575789)
2762 2762 -73.9656324462902 40.783403475308106 22E-PM-1014-02 22E PM 10142018 2 Adult Gray   Gray+   Above Ground 6   0 0 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.9656324462902 40.7834034753081)
2942 2942 -73.9672063784809 40.7826070395665 21D-PM-1008-01 21D PM 10082018 1   Gray   Gray+   Above Ground 8   0 0 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.9672063784809 40.7826070395665)
2965 2965 -73.9767389132988 40.7689323691424 4D-PM-1008-10 04D PM 10082018 10 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 6 climbed the fence & posed for a picture 0 0 1 0 1   0 0 0 0 0 1 0 0   POINT (-73.9767389132988 40.7689323691424)

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