2018_Central_Park_Squirrel_Census_-_Squirrel_Data

60 rows where Foraging = 0, Hectare Squirrel Number = 6, Shift = "PM" and Tail twitches = 0 sorted by Other Interactions

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Tail flags, Approaches, Indifferent, Runs from

Quaas ✖

  • 0 57
  • 1 3

Tail twitches ✖

Shift ✖

Moans ✖

  • 0 60

Hectare Squirrel Number ✖

Foraging ✖

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
31 31 -73.9540054100539 40.795244599983604 39G-PM-1013-06 39G PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9540054100539 40.7952445999836)
81 81 -73.9578237168359 40.7980959471034 40B-PM-1014-06 40B PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9578237168359 40.7980959471034)
83 83 -73.9617088749928 40.7944585082367 35A-PM-1013-06 35A PM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9617088749928 40.7944585082367)
130 130 -73.95816559494371 40.799770819002205 41A-PM-1007-06 41A PM 10072018 6 Adult Black   Black+   Ground Plane FALSE   1 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9581655949437 40.7997708190022)
171 171 -73.971086588091 40.77197032351779 9G-PM-1007-06 09G PM 10072018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.971086588091 40.7719703235178)
378 378 -73.95848354168459 40.7978213396921 39B-PM-1014-06 39B PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9584835416846 40.7978213396921)
458 458 -73.97357503529591 40.7694500333777 6F-PM-1008-06 06F PM 10082018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White White patches. Almost looks like fox squirrel       0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9735750352959 40.7694500333777)
494 494 -73.958837574505 40.7985003987784 40A-PM-1014-06 40A PM 10142018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.958837574505 40.7985003987784)
495 495 -73.9801007327506 40.7677455633932 1B-PM-1019-06 01B PM 10192018 6 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9801007327506 40.7677455633932)
701 701 -73.95292302079079 40.7960663442573 40G-PM-1013-06 40G PM 10132018 6 Juvenile Gray   Gray+   Ground Plane FALSE along the road 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9529230207908 40.7960663442573)
726 726 -73.973305698325 40.778382331129606 14A-PM-1014-06 14A PM 10142018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 9   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.973305698325 40.7783823311296)
737 737 -73.97111769994709 40.7724278547281 10F-PM-1019-06 10F PM 10192018 6 Adult Gray White Gray+White   Above Ground 10 Different tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9711176999471 40.7724278547281)
780 780 -73.9675472064204 40.7835947167436 22C-PM-1006-06 22C PM 10062018 6 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10 on tree 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9675472064204 40.7835947167436)
799 799 -73.9529413156461 40.7920963446605 36I-PM-1007-06 36I PM 10072018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9529413156461 40.7920963446605)
814 814 -73.9607608482656 40.7954687648248 36A-PM-1013-06 36A PM 10132018 6   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE EDGE OF WOODS 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9607608482656 40.7954687648248)
1074 1074 -73.9724657562746 40.7658015504376 3I-PM-1013-06 03I PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9724657562746 40.7658015504376)
1082 1082 -73.96174906802979 40.792153784924395 32C-PM-1013-06 32C PM 10132018 6 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9617490680298 40.7921537849244)
1133 1133 -73.9712550584322 40.7764273475386 13D-PM-1018-06 13D PM 10182018 6 Adult Gray White Gray+White   Above Ground 10   0 0 1 0 0 cleaning 0 0 0 0 0 0 1 0   POINT (-73.9712550584322 40.7764273475386)
1194 1194 -73.96874625660729 40.783898987005 22B-PM-1014-06 22B PM 10142018 6   Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 0 0 0 digging 0 0 0 0 0 0 0 0   POINT (-73.9687462566073 40.783898987005)
1219 1219 -73.96618922004741 40.7836798072777 22D-PM-1012-06 22D PM 10122018 6 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9661892200474 40.7836798072777)
1247 1247 -73.96709048698709 40.7832091658006 21D-PM-1008-06 21D PM 10082018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9670904869871 40.7832091658006)
1273 1273 -73.95589438800509 40.7971535141896 40D-PM-1013-06 40D PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9558943880051 40.7971535141896)
1314 1314 -73.980919134781 40.7683772453336 1A-PM-1014-06 01A PM 10142018 6 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   1 0 0 0 0 0 0 1   POINT (-73.980919134781 40.7683772453336)
1464 1464 -73.95320745731391 40.793466946490796 37H-PM-1006-06 37H PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40 tree 1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9532074573139 40.7934669464908)
1530 1530 -73.96893059787509 40.781815249626604 19C-PM-1018-06 19C PM 10182018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 Climbed fence 1 0 1 0 0 climbing (fence) 0 0 0 0 0 0 1 0   POINT (-73.9689305978751 40.7818152496266)
1535 1535 -73.9703921271418 40.770027611531404 7H-PM-1006-06 07H PM 10062018 6 Adult Gray   Gray+   Above Ground 15   0 1 1 0 0 playing w/ #7 0 0 0 0 0 0 1 0   POINT (-73.9703921271418 40.770027611531404)
1554 1554 -73.95974626120629 40.783280114530605 25I-PM-1007-06 25I PM 10072018 6       + Didn't see squirrel size, or colors Above Ground 20 up in tree 0 0 0 0 0   0 1 0 0 0 0 0 0   POINT (-73.9597462612063 40.7832801145306)
1599 1599 -73.9782603348665 40.7705790257951 5B-PM-1013-06 05B PM 10132018 6 Adult Gray   Gray+   Above Ground 5   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9782603348665 40.7705790257951)
1629 1629 -73.9759428006237 40.7715081817329 7C-PM-1020-06 07C PM 10202018 6 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 1 0 0 0 0 0 0   POINT (-73.9759428006237 40.7715081817329)
1644 1644 -73.9734654671008 40.7715988711659 8E-PM-1008-06 08E PM 10082018 6 Adult Gray White Gray+White   Ground Plane FALSE 5, 6, 7 all at same tree trunk base 0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9734654671008 40.7715988711659)
1679 1679 -73.9545399102352 40.7898646267709 33I-PM-1006-06 33I PM 10062018 6 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9545399102352 40.7898646267709)
1805 1805 -73.9590328527128 40.791221441757706 33E-PM-1012-06 33E PM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 playing 0 0 0 0 0 0 0 0   POINT (-73.9590328527128 40.7912214417577)
1815 1815 -73.96032682553171 40.7900154505092 31E-PM-1006-06 31E PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9603268255317 40.7900154505092)
1871 1871 -73.9748367344424 40.7693513000034 5E-PM-1012-06 05E PM 10122018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 10 oak tree at end of ramp from Chess House 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9748367344424 40.7693513000034)
1963 1963 -73.96515918613991 40.781183828857 20F-PM-1007-06 20F PM 10072018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9651591861399 40.781183828857)
1966 1966 -73.97509119964991 40.772244521017896 8C-PM-1013-06 08C PM 10132018 6   Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9750911996499 40.7722445210179)
2010 2010 -73.9673821557469 40.7786375267659 17F-PM-1020-06 17F PM 10202018 6 Adult Gray   Gray+   Above Ground 20   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.96738215574692 40.7786375267659)
2052 2052 -73.97464934414141 40.7750478734868 11B-PM-1014-06 11B PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 0 0 0 cleaning 0 0 0 0 0 0 1 0   POINT (-73.9746493441414 40.7750478734868)
2141 2141 -73.97870151846621 40.7690114585688 3B-PM-1007-06 03B PM 10072018 6 Juvenile     +         0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9787015184662 40.7690114585688)
2203 2203 -73.97105314852979 40.7773757069445 14D-PM-1019-06 14D PM 10192018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.97105314852982 40.777375706944504)
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)
2357 2357 -73.96323010348829 40.7925707244111 32A-PM-1013-06 32A PM 10132018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9632301034883 40.7925707244111)
2410 2410 -73.97551920769341 40.7664413570796 2F-PM-1014-06 02F PM 10142018 6 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9755192076934 40.7664413570796)
2519 2519 -73.9589475065438 40.7934846881536 35D-PM-1013-06 35D PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9589475065438 40.7934846881536)
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)
2676 2676 -73.9692849074642 40.7708755098145 9H-PM-1018-06 09H PM 10182018 6 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9692849074642 40.7708755098145)
2720 2720 -73.9566300789162 40.7993692120774 42C-PM-1013-06 42C PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Between park and main drag 0 0 1 1 0   0 0 0 0 0 0 1 1   POINT (-73.9566300789162 40.7993692120774)
2725 2725 -73.9658867660358 40.7756523577509 15H-PM-1008-06 15H PM 10082018 6 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE base of gingko tree 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9658867660358 40.7756523577509)
2772 2772 -73.9677368646039 40.782155096483706 20C-PM-1018-06 20C PM 10182018 6 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.96773686460392 40.782155096483706)
2795 2795 -73.9541056052047 40.793986392323106 37G-PM-1007-06 37G PM 10072018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9541056052047 40.7939863923231)
2814 2814 -73.9551625272308 40.791193071916 34H-PM-1006-06 34H PM 10062018 6 Adult Gray   Gray+   Ground Plane FALSE in grass 1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9551625272308 40.791193071916)
2815 2815 -73.97473113123941 40.76773197250439 3F-PM-1013-06 03F PM 10132018 6 Adult Gray White Gray+White   Above Ground 19   0 0 1 0 0   0 1 0 0 0 0 0 1   POINT (-73.97473113123941 40.7677319725044)
2980 2980 -73.97164145863809 40.771760114722 9F-PM-1014-06 09F PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0 running (from birds) 0 0 0 1 0 0 1 0   POINT (-73.9716414586381 40.771760114722)
1049 1049 -73.9564606426367 40.788054657260794 30I-PM-1006-06 30I PM 10062018 6 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 1 ran up tree POINT (-73.9564606426367 40.7880546572608)
2562 2562 -73.9615643742864 40.7944678447843 35B-PM-1013-06 35B PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   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.9615643742864 40.7944678447843)
866 866 -73.9792091200122 40.7685845475313 2B-PM-1013-06 02B PM 10132018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 1 0 0 sat there! in front of us POINT (-73.9792091200122 40.7685845475313)
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)
594 594 -73.9727488640736 40.7781916780621 14B-PM-1014-06 14B PM 10142018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 watching me 0 0 0 0 0 1 0 0 skittish POINT (-73.9727488640736 40.7781916780621)
2697 2697 -73.9710674928906 40.7778757544025 15D-PM-1017-06 15D PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 walking 0 0 0 0 0 0 0 0 stopped and watched me before slowly moving on POINT (-73.9710674928906 40.7778757544025)
133 133 -73.9664711607022 40.787896428768 26A-PM-1006-06 26A PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Tree 90th left 90th & 89 0 0 1 0 0   0 0 0 1 0 0 0 0 studying us looking for food POINT (-73.9664711607022 40.787896428768)

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