2018_Central_Park_Squirrel_Census_-_Squirrel_Data

91 rows where Date = 10192018 and Indifferent = 0 sorted by Location

✎ View and edit SQL

This data as json, CSV (advanced)

Indifferent ✖

Date ✖

  • 10192018 · 31 ✖
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
1758 1758 -73.9581241870185 40.7961057536141 38C-AM-1019-05 38C AM 10192018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9581241870185 40.7961057536141)
1759 1759 -73.9576219570858 40.79633512256721 38C-AM-1019-03 38C AM 10192018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9576219570858 40.7963351225672)
1798 1798 -73.9558180952889 40.7886810505944 31I-PM-1019-03 31I PM 10192018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9558180952889 40.7886810505944)
1833 1833 -73.962516494651 40.788476898990204 28D-PM-1019-02 28D PM 10192018 2 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.962516494651 40.7884768989902)
1866 1866 -73.96360276644391 40.790075966587 30B-PM-1019-01 30B PM 10192018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.9636027664439 40.790075966587)
1893 1893 -73.9708108312271 40.7773975776146 14D-PM-1019-09 14D PM 10192018 9 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9708108312271 40.7773975776146)
1950 1950 -73.96430161168391 40.7904796216068 30B-PM-1019-05 30B PM 10192018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1 hiding a nut 0 0 0 0 1 0 0 1   POINT (-73.9643016116839 40.7904796216068)
1956 1956 -73.98089749771201 40.7690578709841 2A-PM-1019-02 02A PM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 0   POINT (-73.980897497712 40.7690578709841)
1997 1997 -73.97146376830841 40.776898456156296 14D-PM-1019-01 14D PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9714637683084 40.7768984561563)
2036 2036 -73.9610266708075 40.7817512107392 23I-PM-1019-03 23I PM 10192018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9610266708075 40.7817512107392)
2053 2053 -73.97118102224209 40.7773445611969 14D-PM-1019-05 14D PM 10192018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9711810222421 40.7773445611969)
2079 2079 -73.96430251719141 40.790570391517 30B-PM-1019-06 30B PM 10192018 6 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 1   POINT (-73.9643025171914 40.790570391517)
2168 2168 -73.95823634371351 40.7987752300505 40B-AM-1019-06 40B AM 10192018 6 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9582363437135 40.7987752300505)
2198 2198 -73.97097381665309 40.7774102689734 14D-PM-1019-08 14D PM 10192018 8 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9709738166531 40.7774102689734)
2254 2254 -73.9709991016317 40.7725756707748 10F-PM-1019-03 10F PM 10192018 3 Juvenile Gray Cinnamon Gray+Cinnamon Cinnamon head Ground Plane FALSE Behind fence, grass 0 0 0 1 0 eating (nuts) 0 0 0 0 0 1 0 0 approaches (bad tourists w/ nuts) POINT (-73.9709991016317 40.772575670774806)
2287 2287 -73.97681733031649 40.7661261813557 1F-PM-1019-01 01F PM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9768173303165 40.7661261813557)
2342 2342 -73.9533645762606 40.7983709215535 42F-AM-1019-01 42F AM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 1 0 0 1 runs from (me) POINT (-73.9533645762606 40.7983709215535)
2384 2384 -73.9708564226824 40.7726219968014 10F-PM-1019-09 10F PM 10192018 9 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Across Arbor path into hill w/ bushes 1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9708564226824 40.7726219968014)
2488 2488 -73.97269208477921 40.779411746388895 16A-PM-1019-02 16A PM 10192018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1 scared by dog POINT (-73.9726920847792 40.7794117463889)
2509 2509 -73.97142951022491 40.776954371947 14D-PM-1019-02 14D PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9714295102249 40.776954371947)
2527 2527 -73.9675697600155 40.776679741446294 15G-PM-1019-06 15G PM 10192018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 scratching! 0 0 0 0 0 0 0 0   POINT (-73.9675697600155 40.7766797414463)
2544 2544 -73.9713680837672 40.77716615083639 14D-PM-1019-03 14D PM 10192018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9713680837672 40.77716615083641)
2556 2556 -73.96398284313679 40.7910151996207 30B-PM-1019-09 30B PM 10192018 9 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9639828431368 40.7910151996207)
2597 2597 -73.97063044050999 40.77710605948079 14D-PM-1019-14 14D PM 10192018 14 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.97063044051 40.7771060594808)
2608 2608 -73.95226776576591 40.7934034811368 38I-AM-1019-02 38I AM 10192018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9522677657659 40.7934034811368)
2662 2662 -73.97086289336241 40.772563088678396 10F-PM-1019-08 10F PM 10192018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Under "Grape Arbor" structure behind Bandshell 1 0 0 0 1 digging 0 0 0 0 0 0 0 1   POINT (-73.9708628933624 40.7725630886784)
2715 2715 -73.9710273070712 40.776652124615296 14D-PM-1019-16 14D PM 10192018 16 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9710273070712 40.7766521246153)
2825 2825 -73.96435075880079 40.790432469329204 30B-PM-1019-07 30B PM 10192018 7 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.96435075880082 40.7904324693292)
2882 2882 -73.956581233786 40.7902127690837 33H-AM-1019-01 33H AM 10192018 1 Adult Cinnamon Gray Cinnamon+Gray Cinnamon patches Ground Plane FALSE   0 0 0 0 0 wrestling with child 0 0 0 0 0 0 0 0   POINT (-73.956581233786 40.79021276908371)
2902 2902 -73.9673220504383 40.777029634596296 15G-PM-1019-04 15G PM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9673220504383 40.7770296345963)
2924 2924 -73.9727230609785 40.7795341640894 16A-PM-1019-01 16A PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9727230609785 40.7795341640894)

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