2018_Central_Park_Squirrel_Census_-_Squirrel_Data

46 rows where Eating = 1, Hectare Squirrel Number = 4 and Indifferent = 1 sorted by Foraging

✎ 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, Running, Chasing, Climbing, Foraging, Kuks, Tail twitches, Approaches, Runs from

Indifferent ✖

Hectare Squirrel Number ✖

Eating ✖

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
178 178 -73.9613780522542 40.790786197111004 31D-PM-1006-04 31D PM 10062018 4 Adult Gray   Gray+   Above Ground 30   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9613780522542 40.790786197111)
293 293 -73.9696173677837 40.7705202790525 8H-AM-1017-04 08H AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9696173677837 40.7705202790525)
446 446 -73.9678774314725 40.7738535171265 12H-PM-1007-04 12H PM 10072018 4   Gray Cinnamon Gray+Cinnamon         0 0 0 1 0 mushroom 0 0 0 0 0 0 1 0   POINT (-73.9678774314725 40.7738535171265)
585 585 -73.9700148248402 40.778778019335796 16D-PM-1010-04 16D PM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9700148248402 40.7787780193358)
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)
670 670 -73.9602398690946 40.7910157676119 32D-PM-1006-04 32D PM 10062018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 40   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9602398690946 40.7910157676119)
731 731 -73.97335458025151 40.7675056025357 4G-AM-1006-04 04G AM 10062018 4 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9733545802515 40.7675056025357)
1023 1023 -73.97608800701859 40.7711057827923 6C-PM-1020-04 06C PM 10202018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9760880070186 40.7711057827923)
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)
1282 1282 -73.974451175321 40.770129463526395 6E-PM-1010-04 06E PM 10102018 4 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees 0 1 0 1 0 chasing #3 0 0 0 0 0 0 1 0   POINT (-73.974451175321 40.7701294635264)
1436 1436 -73.97667795856859 40.7669673778105 2E-AM-1010-04 02E AM 10102018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   1 0 0 0 0 0 1 0   POINT (-73.9766779585686 40.7669673778105)
1742 1742 -73.97010234787459 40.7803527061859 17C-PM-1013-04 17C PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9701023478746 40.7803527061859)
1881 1881 -73.9674984567017 40.7745938268705 13H-PM-1010-04 13H PM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9674984567017 40.7745938268705)
2062 2062 -73.9618173092433 40.7925800181543 33B-PM-1010-04 33B PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9618173092433 40.7925800181543)
2128 2128 -73.9757673193743 40.7669614322613 2F-PM-1014-04 02F PM 10142018 4 Adult Gray   Gray+   Above Ground 20   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9757673193743 40.766961432261304)
2219 2219 -73.9709242364673 40.7684217215595 5I-AM-1010-04 05I AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9709242364673 40.7684217215595)
2270 2270 -73.9703732649257 40.77019793771029 8H-PM-1014-04 08H PM 10142018 4 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.97037326492571 40.7701979377103)
2309 2309 -73.966824257293 40.775340537786896 14H-PM-1012-04 14H PM 10122018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.966824257293 40.7753405377869)
2325 2325 -73.9728360875598 40.7660637295671 3H-PM-1014-04 03H PM 10142018 4 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9728360875598 40.7660637295671)
2355 2355 -73.9728654439465 40.7724853142211 9E-AM-1008-04 09E AM 10082018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9728654439465 40.7724853142211)
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)
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)
2478 2478 -73.96749310703241 40.778369369095394 17F-AM-1007-04 17F AM 10072018 4 Adult Cinnamon White Cinnamon+White   Above Ground 4   0 0 0 1 0 chilling 1 0 0 0 0 0 1 0   POINT (-73.9674931070324 40.7783693690954)
2533 2533 -73.9766195697096 40.766190726154704 1F-AM-1010-04 01F AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9766195697096 40.7661907261547)
2613 2613 -73.96393252683 40.7808289765857 21G-AM-1014-04 21G AM 10142018 4 Adult Gray White Gray+White   Above Ground 6   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.96393252683 40.7808289765857)
2614 2614 -73.9765877920583 40.7660946071574 1F-AM-1010-04 01F AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9765877920583 40.7660946071574)
2776 2776 -73.9789687905912 40.769269313932796 3B-PM-1007-04 03B PM 10072018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 At fence 1 0 1 1 0   0 0 0 0 1 0 1 1   POINT (-73.9789687905912 40.7692693139328)
2781 2781 -73.9752673884392 40.7662642413761 2G-AM-1010-04 02G AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9752673884392 40.7662642413761)
2863 2863 -73.9698246369929 40.7711472794488 9H-AM-1006-04 09H AM 10062018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9698246369929 40.7711472794488)
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)
3014 3014 -73.9665572004288 40.780434754830296 19E-PM-1018-04 19E PM 10182018 4   Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9665572004288 40.7804347548303)
252 252 -73.974420668782 40.7749628597465 10C-PM-1013-04 10C PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.974420668782 40.7749628597465)
275 275 -73.974467903723 40.7686520352868 4F-PM-1013-04 04F PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.974467903723 40.7686520352868)
842 842 -73.9645147011741 40.777256683379896 17I-AM-1014-04 17I AM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 1 0   POINT (-73.9645147011741 40.7772566833799)
1457 1457 -73.9697744662785 40.775595042897294 13F-AM-1007-04 13F AM 10072018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9697744662785 40.7755950428973)
1468 1468 -73.96405889194459 40.790044098464 29B-PM-1010-04 29B PM 10102018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9640588919446 40.790044098464)
1492 1492 -73.9807078515193 40.768333529264204 2A-AM-1010-04 02A AM 10102018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9807078515193 40.7683335292642)
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)
1709 1709 -73.9771696835698 40.76970111004871 4C-AM-1006-04 04C AM 10062018 4 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9771696835698 40.7697011100487)
1802 1802 -73.9736418085696 40.7716931127716 8E-PM-1008-04 08E PM 10082018 4 Adult Gray White Gray+White   Ground Plane FALSE in grass by a grove of tall maples 0 0 0 1 1   0 0 0 0 0 0 1 0 there's a family playing soccer POINT (-73.9736418085696 40.7716931127716)
2050 2050 -73.9555255950648 40.7977720808005 40D-AM-1013-04 40D AM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9555255950648 40.7977720808005)
2265 2265 -73.97052601032391 40.782633368659894 19A-PM-1013-04 19A PM 10132018 4 Adult Gray Black, White Gray+Black, White Also looks quite brown - minimal body highlight coloring - black edges Above Ground 2   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9705260103239 40.78263336865991)
2277 2277 -73.95385121459 40.7981257651433 42E-PM-1012-04 42E PM 10122018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.95385121459 40.7981257651433)
2607 2607 -73.9642988690682 40.779559128197896 19H-AM-1010-04 19H AM 10102018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 1 runs from human w/ dog POINT (-73.9642988690682 40.7795591281979)
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)
2993 2993 -73.95707222626929 40.798570614351895 40C-AM-1017-04 40C AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 1 1 chasing (#3) 0 0 0 0 0 0 1 0   POINT (-73.9570722262693 40.7985706143519)

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