2018_Central_Park_Squirrel_Census_-_Squirrel_Data

26 rows where Chasing = 1, Location = "Ground Plane" and Runs from = 1 sorted by Running

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Climbing, Eating, Foraging, Other Activities, Kuks, Tail twitches

Hectare Squirrel Number ✖

Location ✖

  • Ground Plane · 26 ✖

Chasing ✖

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
103 103 -73.96077013704429 40.7955418990855 36A-PM-1013-07 36A PM 10132018 7   Gray   Gray+   Ground Plane FALSE "FIELD" 0 1 0 0 0 chasing #8 0 0 0 0 0 0 0 1   POINT (-73.9607701370443 40.7955418990855)
108 108 -73.9574809028248 40.7950013620207 37D-PM-1014-04 37D PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 1 chasing (a chipmunk) 0 0 0 0 0 0 0 1   POINT (-73.9574809028248 40.7950013620207)
356 356 -73.97610364001441 40.77054826845939 6D-PM-1020-03 06D PM 10202018 3 Juvenile Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9761036400144 40.7705482684594)
421 421 -73.9664630067791 40.775636151582496 14H-AM-1007-04 14H AM 10072018 4 Juvenile Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9664630067791 40.7756361515825)
533 533 -73.9652584749758 40.7803011124382 19F-PM-1017-04 19F PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9652584749758 40.7803011124382)
627 627 -73.97637911214379 40.770281512254 5D-PM-1018-04 05D PM 10182018 4 Adult Gray White Gray+White Partial missing tail Ground Plane FALSE   0 1 0 0 0 chasing (dog chasing) 0 0 0 0 0 0 0 1   POINT (-73.9763791121438 40.770281512254)
629 629 -73.95737241332641 40.7980080911115 40C-AM-1017-02 40C AM 10172018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 1 0 chasing (#1) 0 0 0 0 0 0 0 1   POINT (-73.9573724133264 40.7980080911115)
724 724 -73.9532952763106 40.792007446262204 36I-AM-1017-08 36I AM 10172018 8 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0 chasing (#7) 0 0 0 0 1 0 0 1 runs from (me) POINT (-73.95329527631061 40.7920074462622)
732 732 -73.9695041366722 40.779787880948206 17D-AM-1008-02 17D AM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9695041366722 40.7797878809482)
762 762 -73.96792913479558 40.7846973096665 23B-PM-1012-02 23B PM 10122018 2 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.9679291347956 40.7846973096665)
1009 1009 -73.9636551433178 40.790157281877605 30B-PM-1019-02 30B PM 10192018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 1 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.9636551433178 40.7901572818776)
1548 1548 -73.9790044506465 40.7689469479245 3B-AM-1010-03 03B AM 10102018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0 chasing #2 0 0 0 0 0 0 0 1   POINT (-73.9790044506465 40.7689469479245)
1584 1584 -73.9581310602492 40.7960214726964 38C-PM-1014-05 38C PM 10142018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0 chasing (#4) 0 0 0 0 0 0 0 1   POINT (-73.9581310602492 40.7960214726964)
1700 1700 -73.965675791028 40.7887310058451 27B-PM-1006-02 27B PM 10062018 2 Adult Gray   Gray+   Ground Plane FALSE By large tree chasing #1 0 1 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.965675791028 40.7887310058451)
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)
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)
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)
2809 2809 -73.9686756254868 40.777745910265104 16E-AM-1014-04 16E AM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9686756254868 40.7777459102651)
3016 3016 -73.9756457597888 40.7703559775625 6D-PM-1020-02 06D PM 10202018 2 Juvenile Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9756457597888 40.7703559775625)
84 84 -73.9701824825872 40.776653057929295 14E-AM-1008-09 14E AM 10082018 9 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 0   1 0 0 0 0 0 0 1   POINT (-73.9701824825872 40.7766530579293)
628 628 -73.96001657854859 40.795246676183204 36B-PM-1013-03 36B PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9600165785486 40.7952466761832)
1040 1040 -73.9702588981432 40.776610754288 14E-AM-1008-08 14E AM 10082018 8 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9702588981432 40.776610754288)
1236 1236 -73.97920390711141 40.76787494712671 2C-AM-1010-07 02C AM 10102018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 1 0 0 0 #7 & #8 chased each other up diff tree 0 0 0 0 0 0 0 1   POINT (-73.9792039071114 40.76787494712671)
1656 1656 -73.9557399927792 40.7971563708988 40D-PM-1013-07 40D PM 10132018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9557399927792 40.7971563708988)
1754 1754 -73.9652134469963 40.7803438278765 19F-PM-1017-05 19F PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9652134469963 40.7803438278765)
2365 2365 -73.96887733063241 40.7766669852358 15F-AM-1007-05 15F AM 10072018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9688773306324 40.7766669852358)

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