2018_Central_Park_Squirrel_Census_-_Squirrel_Data

135 rows where Hectare Squirrel Number = 3, Indifferent = 0 and Runs from = 0 sorted by Age

✎ View and edit SQL

This data as json, CSV (advanced)

Runs from ✖

Indifferent ✖

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
2571 2571 -73.9695468150218 40.7821142051746 20B-PM-1013-03 20B PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9695468150218 40.7821142051746)
2586 2586 -73.9752965316933 40.775253857578896 10B-AM-1006-03 10B AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   In tree 0 0 1 0 0   0 0 0 0 1 1 0 0   POINT (-73.9752965316933 40.7752538575789)
2592 2592 -73.9758128509653 40.7715946097064 7C-PM-1020-03 07C PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9758128509653 40.7715946097064)
2603 2603 -73.97087815045279 40.7724138070355 10F-AM-1007-03 10F AM 10072018 3 Adult Gray   Gray+   Above Ground 50   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9708781504528 40.7724138070355)
2718 2718 -73.9530587825442 40.7919087309222 36I-PM-1007-03 36I PM 10072018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9530587825442 40.7919087309222)
2719 2719 -73.973425927351 40.7781929919344 14B-AM-1007-03 14B AM 10072018 3 Adult Gray   Gray+         0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.973425927351 40.7781929919344)
2774 2774 -73.9705409446299 40.7764608087703 14E-PM-1017-03 14E PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9705409446299 40.7764608087703)
2827 2827 -73.9778578822323 40.770543270528606 5B-PM-1013-03 05B PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 grooming 0 0 0 0 0 0 0 0   POINT (-73.9778578822323 40.7705432705286)
2853 2853 -73.96786131850709 40.7822170887526 20C-PM-1018-03 20C PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9678613185071 40.7822170887526)
2856 2856 -73.9751615527833 40.767013871509 3F-AM-1006-03 03F AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Ground Plane FALSE on the path 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9751615527833 40.767013871509)
2883 2883 -73.9698592838836 40.7743071443959 12F-AM-1020-03 12F AM 10202018 3 Adult Gray Black Gray+Black   Ground Plane FALSE   0 0 0 0 0 playing 0 0 0 0 1 0 0 0   POINT (-73.9698592838836 40.7743071443959)
2912 2912 -73.9632164738341 40.7921270121312 32B-PM-1010-03 32B PM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9632164738341 40.7921270121312)
2926 2926 -73.9714653576023 40.77174001395021 9F-AM-1013-03 09F AM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9714653576023 40.7717400139502)
2933 2933 -73.9677903197449 40.7826561917755 21C-AM-1014-03 21C AM 10142018 3 Adult Gray   Gray+   Above Ground 30   0 1 1 0 0   0 1 0 0 0 0 0 0 looked at us from tree POINT (-73.9677903197449 40.7826561917755)
2937 2937 -73.96834606070209 40.7805408447877 18D-AM-1018-03 18D AM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9683460607021 40.7805408447877)
2957 2957 -73.97473131521521 40.7653888351839 1G-PM-1010-03 01G PM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9747313152152 40.7653888351839)
53 53 -73.95849706432129 40.7982886348696 40B-AM-1019-03 40B AM 10192018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 1 1 0 0   POINT (-73.9584970643213 40.7982886348696)
222 222 -73.97702735535249 40.7732399463626 8A-AM-1013-03 08A AM 10132018 3 Juvenile     +   Above Ground 3 fence 1 1 1 1 0 playing tag together 0 0 0 0 0 1 0 0   POINT (-73.9770273553525 40.7732399463626)
254 254 -73.9762246600197 40.775164077652 10A-AM-1006-03 10A AM 10062018 3 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE Bridle Path lawn 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9762246600197 40.775164077652)
257 257 -73.9773317054464 40.7684035996758 3D-AM-1006-03 03D AM 10062018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE on top [of] a big rock/boulder in the area 1 0 1 0 0 climbing (rock) 0 0 0 0 0 1 0 0 approaches (slightly),wary of humans POINT (-73.9773317054464 40.76840359967581)
954 954 -73.96584435488221 40.7796704898979 19F-AM-1007-03 19F AM 10072018 3 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0 scared POINT (-73.9658443548822 40.7796704898979)
1254 1254 -73.97640135898651 40.766306349920704 1F-PM-1019-03 01F PM 10192018 3 Juvenile Gray   Gray+   Above Ground 1   0 0 0 0 0 hiding 0 0 0 0 0 0 0 0   POINT (-73.9764013589865 40.7663063499207)
1494 1494 -73.95257524081691 40.7954915417553 39H-AM-1007-03 39H AM 10072018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9525752408169 40.7954915417553)
1672 1672 -73.9640989602986 40.789929543926505 29B-PM-1010-03 29B PM 10102018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9640989602986 40.7899295439265)
1832 1832 -73.9693159934697 40.7831212338295 21B-PM-1017-03 21B PM 10172018 3 Juvenile Cinnamon White Cinnamon+White   Above Ground 1   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9693159934697 40.7831212338295)
2028 2028 -73.96873477318609 40.7718955594385 10H-AM-1014-03 10H AM 10142018 3 Juvenile     +   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9687347731861 40.7718955594385)
2154 2154 -73.976716425804 40.7736889979965 8A-PM-1014-03 08A PM 10142018 3 Juvenile Gray   Gray+   Above Ground 23   0 0 1 1 0   0 0 0 0 0 0 0 0   POINT (-73.976716425804 40.7736889979965)
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)
2262 2262 -73.9556177490335 40.788856916153705 32I-AM-1013-03 32I AM 10132018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0 watching me from tree - curious POINT (-73.9556177490335 40.7888569161537)
2334 2334 -73.97549229705109 40.7707686392991 6D-AM-1008-03 06D AM 10082018 3 Juvenile Gray   Gray+   Above Ground 10   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9754922970511 40.7707686392991)
2403 2403 -73.97778796352159 40.769359455673 4C-AM-1006-03 04C AM 10062018 3 Juvenile Gray   Gray+   Above Ground 10   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9777879635216 40.769359455673)
2465 2465 -73.9686999860219 40.784401473513604 22B-PM-1014-03 22B PM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9686999860219 40.7844014735136)
2668 2668 -73.95486485185579 40.7946730924872 38F-PM-1013-03 38F PM 10132018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9548648518558 40.7946730924872)
2865 2865 -73.98028424040159 40.767825738497706 1B-PM-1019-03 01B PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 25 in tree 0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.98028424040162 40.7678257384977)
2867 2867 -73.969370141813 40.7840721191988 22A-PM-1017-03 22A PM 10172018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.969370141813 40.7840721191988)

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