2018_Central_Park_Squirrel_Census_-_Squirrel_Data

34 rows where Eating = 1, Hectare Squirrel Number = 3 and Shift = "AM" sorted by Tail flags

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Foraging, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Shift ✖

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
154 154 -73.9686056085297 40.7781658424866 16E-AM-1014-03 16E AM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9686056085297 40.7781658424866)
204 204 -73.96795381633409 40.7837103696906 22C-AM-1013-03 22C AM 10132018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1 eating (mushroom) 0 0 0 0 0 0 0 1   POINT (-73.9679538163341 40.7837103696906)
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)
223 223 -73.9737091707831 40.771373256751204 7E-AM-1006-03 07E AM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE under a tree 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9737091707831 40.7713732567512)
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)
258 258 -73.9534333425633 40.793256416332795 37H-AM-1018-03 37H AM 10182018 3 Adult Gray White Gray+White   Above Ground 10 in a tree with red berries 0 0 0 1 0   0 1 0 0 0 0 0 1   POINT (-73.9534333425633 40.7932564163328)
330 330 -73.9708969246276 40.7767695507462 14D-AM-1014-03 14D AM 10142018 3 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.9708969246276 40.7767695507462)
660 660 -73.9638298997554 40.78259663323671 22F-AM-1007-03 22F AM 10072018 3 Adult Cinnamon Gray, White Cinnamon+Gray, White large white highlight Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9638298997554 40.7825966332367)
786 786 -73.953296595236 40.7927644594513 36I-AM-1017-03 36I AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon Cinnamon stripe on back Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.953296595236 40.7927644594513)
900 900 -73.9626527908786 40.7912472380247 31B-AM-1017-03 31B AM 10172018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9626527908786 40.7912472380247)
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)
963 963 -73.9621066718851 40.7942427079733 34A-AM-1012-03 34A AM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9621066718851 40.7942427079733)
1021 1021 -73.97186968288 40.778926988884 15B-AM-1014-03 15B AM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1 running (from a dog) 0 0 0 0 0 0 1 0   POINT (-73.97186968288 40.778926988884)
1375 1375 -73.9564741038174 40.7938845572816 36F-AM-1017-03 36F AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon Cinnamon on shoulders Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1 runs from (me) POINT (-73.9564741038174 40.7938845572816)
1395 1395 -73.9710801547498 40.7760872452093 13D-AM-1014-03 13D AM 10142018 3 Juvenile Gray White Gray+White   Above Ground 2   0 1 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9710801547498 40.7760872452093)
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)
1502 1502 -73.97052548010001 40.7763606494306 13E-AM-1017-03 13E AM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   1 0 0 0 0 0 0 1 acknowledges POINT (-73.9705254801 40.7763606494306)
1620 1620 -73.96356061997841 40.782206970617 22G-AM-1018-03 22G AM 10182018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9635606199784 40.782206970617)
1664 1664 -73.97291429122029 40.772409114667795 9E-AM-1008-03 09E AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9729142912203 40.7724091146678)
1701 1701 -73.9701634768603 40.777869143321794 15D-AM-1007-03 15D AM 10072018 3 Adult Gray   Gray+   Above Ground 10   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9701634768603 40.7778691433218)
1829 1829 -73.9746965894947 40.766435172430896 2G-AM-1010-03 02G AM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9746965894947 40.7664351724309)
2127 2127 -73.9562442622553 40.7957285542564 38E-AM-1010-03 38E AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9562442622553 40.7957285542564)
2151 2151 -73.96971787697879 40.77915441024221 17D-AM-1008-03 17D AM 10082018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.96971787697882 40.7791544102422)
2205 2205 -73.9594986107981 40.7840083040604 25I-AM-1012-03 25I AM 10122018 3 Adult Cinnamon   Cinnamon+   Above Ground 8 on turn, see map 1 1 0 1 0   0 0 0 0 1 1 0 0   POINT (-73.9594986107981 40.7840083040604)
2379 2379 -73.97118651343641 40.7785039981892 15C-AM-1010-03 15C AM 10102018 3 Adult Gray   Gray+   Above Ground 6   0 0 0 1 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9711865134364 40.7785039981892)
2471 2471 -73.964274290774 40.779531955602295 19H-AM-1010-03 19H AM 10102018 3 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0 ran from human w/ dog POINT (-73.964274290774 40.7795319556023)
2573 2573 -73.9810149147578 40.7683925377714 2A-AM-1010-03 02A AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 on trunk 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9810149147578 40.7683925377714)
2736 2736 -73.95938952535009 40.797308584408704 38B-AM-1019-03 38B AM 10192018 3 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9593895253501 40.7973085844087)
2871 2871 -73.9777124331985 40.7704051056666 5B-AM-1008-03 05B AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9777124331985 40.7704051056666)
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)
124 124 -73.9588660250232 40.7982597947515 40A-AM-1010-03 40A AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE bottom of great hill 0 0 0 1 1   0 0 0 1 0 0 1 1 dog chased POINT (-73.9588660250232 40.7982597947515)
335 335 -73.97823514358521 40.7715896672335 6A-AM-1006-03 06A AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree 0 1 0 1 0   0 0 0 1 1 0 0 0   POINT (-73.9782351435852 40.7715896672335)
1230 1230 -73.9790822606486 40.7714466633386 5A-AM-1006-03 05A AM 10062018 3 Juvenile Cinnamon   Cinnamon+   Above Ground 8   0 0 1 1 0   0 0 0 1 0 0 0 1   POINT (-73.9790822606486 40.7714466633386)
1981 1981 -73.972154069981 40.769012800972206 6G-AM-1008-03 06G AM 10082018 3 Adult Gray White Gray+White   Ground Plane FALSE grass 0 0 0 1 1   0 0 0 1 0 0 1 0   POINT (-73.972154069981 40.7690128009722)

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