2018_Central_Park_Squirrel_Census_-_Squirrel_Data

74 rows where Approaches = 1 and Foraging = 0 sorted by Location

✎ View and edit SQL

This data as json, CSV (advanced)

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
1392 1392 -73.96480906981759 40.7903882097837 29A-PM-1019-03 29A PM 10192018 3 Juvenile Black Cinnamon Black+Cinnamon   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 1 0 1 ran from,but now approaching. kind of weirding me out. POINT (-73.9648090698176 40.7903882097837)
1428 1428 -73.9666113598566 40.775266255031205 14H-PM-1012-05 14H PM 10122018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 0 0 approaches (someone was feeding it) POINT (-73.9666113598566 40.7752662550312)
1442 1442 -73.961241953418 40.7941677113011 35B-PM-1013-07 35B PM 10132018 7 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 1 0 got fed twice by grandpa,grabbed from grass and ate in tree 0 0 0 0 0 1 1 1 approaches (grandpa with food),runs from (kid),kid was slowly creeping up on it; it eventually climbed up. POINT (-73.961241953418 40.7941677113011)
1510 1510 -73.9655670884957 40.7763728890554 16H-PM-1014-03 16H PM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0 followed man across bridge POINT (-73.9655670884957 40.7763728890554)
1533 1533 -73.95200246546021 40.794732982815496 39I-PM-1013-04 39I PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as both Primary and Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 1 0 playing 0 0 0 0 0 1 0 0   POINT (-73.95200246546021 40.7947329828155)
1650 1650 -73.97624942397191 40.775017530671605 10A-AM-1006-01 10A AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE near Strawberry Fields 0 0 0 1 0 eating (a peanut) 0 0 0 0 0 1 0 0   POINT (-73.9762494239719 40.7750175306716)
1721 1721 -73.95873307074629 40.7907682009641 32F-AM-1012-02 32F AM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray patches on back legs Ground Plane FALSE   0 0 0 0 0 curious about me 0 0 0 0 0 1 0 1   POINT (-73.9587330707463 40.7907682009641)
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)
2030 2030 -73.9749251267433 40.7679111971294 4F-PM-1013-01 04F PM 10132018 1 Adult Cinnamon Gray, Black Cinnamon+Gray, Black   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 1 0 0   POINT (-73.9749251267433 40.7679111971294)
2044 2044 -73.97715523261991 40.7706917595308 5C-AM-1006-01 05C AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 1 0 0   0 0 0 1 0 1 0 0   POINT (-73.9771552326199 40.7706917595308)
2068 2068 -73.9735587560787 40.7672346255151 3G-PM-1013-02 03G PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 0 wandering,interacting with tourists 0 0 0 0 0 1 0 0 approaches (father - son taking photos,talking about giving him planters peanuts) POINT (-73.9735587560787 40.7672346255151)
2087 2087 -73.956502663005 40.788160908881004 30I-PM-1006-05 30I PM 10062018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.956502663005 40.788160908881)
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)
2165 2165 -73.9794371709817 40.768387910254 2B-PM-1013-07 02B PM 10132018 7 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9794371709817 40.768387910254)
2170 2170 -73.9678923667678 40.7819675626236 20C-PM-1018-05 20C PM 10182018 5 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.9678923667678 40.781967562623606)
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)
2348 2348 -73.9531965469704 40.794743798397704 38G-PM-1020-11 38G PM 10202018 11 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 1 1 0   POINT (-73.9531965469704 40.7947437983977)
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)
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)
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)
2703 2703 -73.9690174442945 40.7817617696508 19C-PM-1018-05 19C PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.9690174442945 40.7817617696508)
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)
2835 2835 -73.9531953594918 40.7960413520131 40G-PM-1013-01 40G PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9531953594918 40.7960413520131)
2998 2998 -73.97520792474191 40.775537697900205 11B-AM-1007-01 11B AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 1 0 0   POINT (-73.9752079247419 40.7755376979002)

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