2018_Central_Park_Squirrel_Census_-_Squirrel_Data

45 rows where Hectare Squirrel Number = 4, Running = 1 and Runs from = 0 sorted by Tail flags

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Climbing, Eating, Foraging, Quaas, Tail flags, Approaches, Indifferent

Tail twitches ✖

  • 0 39
  • 1 6

Running ✖

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
240 240 -73.9767080512177 40.7717708794221 6B-PM-1017-04 06B PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9767080512177 40.7717708794221)
256 256 -73.976798124308 40.774131657411296 9A-PM-1010-04 09A PM 10102018 4   Cinnamon   Cinnamon+   Above Ground 20   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.97679812430802 40.7741316574113)
336 336 -73.97574132156208 40.7692582758978 4E-PM-1008-04 04E PM 10082018 4 Adult Gray   Gray+   Above Ground 10   1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9757413215621 40.7692582758978)
375 375 -73.9752000129992 40.773291812223896 8C-PM-1013-04 08C PM 10132018 4 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9752000129992 40.7732918122239)
490 490 -73.978426472499 40.771904101844 6A-PM-1012-04 06A PM 10122018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.978426472499 40.771904101844)
499 499 -73.96572880550109 40.776458003628704 16H-PM-1014-04 16H PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9657288055011 40.7764580036287)
619 619 -73.9769887473852 40.7707561532949 5C-PM-1010-04 05C PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.97698874738522 40.7707561532949)
709 709 -73.9519387881692 40.7936273636929 38I-PM-1014-04 38I PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9519387881692 40.7936273636929)
805 805 -73.97068515461841 40.7780777016038 15D-PM-1017-04 15D PM 10172018 4 Adult Cinnamon   Cinnamon+   Above Ground 2 on fence 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9706851546184 40.7780777016038)
868 868 -73.9738481771673 40.7706540698938 7E-PM-1013-04 07E PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9738481771673 40.7706540698938)
889 889 -73.96810426129379 40.772331431865 11I-PM-1012-04 11I PM 10122018 4 Adult Gray   Gray+   Above Ground 2   1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9681042612938 40.772331431865)
903 903 -73.9719941577406 40.77037129313 7G-AM-1010-04 07G AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9719941577406 40.77037129313)
960 960 -73.9623922773932 40.7814944428327 22H-PM-1007-04 22H PM 10072018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9623922773932 40.7814944428327)
999 999 -73.980948293606 40.76856888506279 2A-PM-1019-04 02A PM 10192018 4 Juvenile Gray White Gray+White   Above Ground 15 in tree! 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.980948293606 40.7685688850628)
1072 1072 -73.9566571713254 40.798985577543505 41C-AM-1017-04 41C AM 10172018 4   Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9566571713254 40.7989855775435)
1182 1182 -73.9667206046912 40.777999356509795 17G-PM-1017-04 17G PM 10172018 4 Adult Gray White Gray+White   Above Ground 10 tree & ground 1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9667206046912 40.7779993565098)
1223 1223 -73.95912985511109 40.7919612446005 33E-AM-1014-04 33E AM 10142018 4 Adult Black Cinnamon, White Black+Cinnamon, White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9591298551111 40.7919612446005)
1416 1416 -73.97573134819821 40.7754704051391 11A-PM-1013-04 11A PM 10132018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9757313481982 40.7754704051391)
1453 1453 -73.9555856074105 40.7969457685677 40E-AM-1014-04 40E AM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE on rocks/bushy rocks 1 0 0 0 0 hiding from bird 0 1 0 0 1 0 1 0   POINT (-73.9555856074105 40.79694576856771)
1458 1458 -73.9545037193355 40.7900225055417 33I-PM-1006-04 33I PM 10062018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9545037193355 40.7900225055417)
1600 1600 -73.9753093777 40.7666673897583 2F-AM-1006-04 02F AM 10062018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White Beautiful white puff at the end of its tail Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.97530937770001 40.7666673897583)
1623 1623 -73.97701191330229 40.773294909000505 8A-AM-1013-04 08A AM 10132018 4 Juvenile     +   Above Ground 4 fence 1 1 0 1 1 playing tag together 0 0 0 0 0 1 0 0   POINT (-73.9770119133023 40.7732949090005)
1690 1690 -73.96052295327 40.7934359372871 34C-PM-1012-04 34C PM 10122018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.96052295327 40.7934359372871)
1736 1736 -73.9743873549635 40.7745426051392 10C-AM-1018-04 10C AM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9743873549635 40.7745426051392)
1752 1752 -73.9561091686663 40.798146304742495 41D-AM-1014-04 41D AM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9561091686663 40.7981463047425)
1823 1823 -73.9612854506075 40.792083067357105 32C-PM-1013-04 32C PM 10132018 4 Juvenile Gray   Gray+   Above Ground     1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9612854506075 40.7920830673571)
1882 1882 -73.9541601469123 40.7907832744689 34I-PM-1010-04 34I PM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE across the lawn and climb up a small tree 1 0 1 0 0 grooming 0 0 0 0 0 0 0 0   POINT (-73.9541601469123 40.79078327446891)
1961 1961 -73.953664715831 40.7981256393159 41E-PM-1013-04 41E PM 10132018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.953664715831 40.7981256393159)
1962 1962 -73.9647318357023 40.7760936175332 15I-PM-1012-04 15I PM 10122018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9647318357023 40.7760936175332)
1969 1969 -73.96890514730721 40.7764511282884 14F-AM-1007-04 14F AM 10072018 4 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9689051473072 40.7764511282884)
2113 2113 -73.95829048146521 40.790591574956395 32F-AM-1012-04 32F AM 10122018 4 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9582904814652 40.7905915749564)
2204 2204 -73.9532427699097 40.7962643767092 40G-PM-1013-04 40G PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9532427699097 40.7962643767092)
2246 2246 -73.9711607544742 40.774988247642 12E-AM-1017-04 12E AM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9711607544742 40.774988247642)
2442 2442 -73.9699369796844 40.772035019127294 10G-PM-1017-04 10G PM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9699369796844 40.7720350191273)
2514 2514 -73.95744422055 40.7961046528557 38D-AM-1017-04 38D AM 10172018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.95744422055 40.7961046528557)
2619 2619 -73.9739737592602 40.772713047677705 9D-AM-1008-04 09D AM 10082018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9739737592602 40.7727130476777)
2641 2641 -73.96155167034941 40.790521938835894 31D-AM-1014-04 31D AM 10142018 4 Juvenile Gray   Gray+   Ground Plane FALSE Open ground 1 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9615516703494 40.7905219388359)
2744 2744 -73.9752915601718 40.7739329570033 9B-AM-1010-04 09B AM 10102018 4       +   Above Ground 10   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9752915601718 40.7739329570033)
2840 2840 -73.9532163535175 40.7982970313067 42F-PM-1017-04 42F PM 10172018 4   Gray   Gray+         1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9532163535175 40.7982970313067)
2866 2866 -73.9744025383371 40.7777296605765 13A-AM-1017-04 13A AM 10172018 4 Adult Gray   Gray+         1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9744025383371 40.7777296605765)
2878 2878 -73.969720780557 40.774110568875706 12F-AM-1020-04 12F AM 10202018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.969720780557 40.7741105688757)
2981 2981 -73.9800094828465 40.7677782585639 1B-AM-1012-04 01B AM 10122018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9800094828465 40.7677782585639)
2987 2987 -73.9563724838337 40.7882504581015 31I-PM-1019-04 31I PM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.95637248383372 40.7882504581015)
1529 1529 -73.9692401421068 40.7707128895661 8I-AM-1006-04 08I AM 10062018 4 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9692401421068 40.7707128895661)
1636 1636 -73.97014086231209 40.7695511718541 7I-PM-1013-04 07I PM 10132018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE Grass 1 0 0 1 0   0 0 0 1 0 0 0 0   POINT (-73.9701408623121 40.7695511718541)

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