2018_Central_Park_Squirrel_Census_-_Squirrel_Data

41 rows where Date = 10072018, Eating = 1 and Indifferent = 0 sorted by Eating

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Foraging, Tail flags, Tail twitches, Approaches, Runs from

Hectare Squirrel Number ✖

Indifferent ✖

Eating ✖

Date ✖

  • 10072018 · 41 ✖
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
32 32 -73.9576530157255 40.7868659490397 29I-PM-1007-01 29I PM 10072018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9576530157255 40.7868659490397)
52 52 -73.9675634326877 40.781347735250705 19D-AM-1007-01 19D AM 10072018 1 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 0 0 fenced off area can't approach POINT (-73.9675634326877 40.7813477352507)
130 130 -73.95816559494371 40.799770819002205 41A-PM-1007-06 41A PM 10072018 6 Adult Black   Black+   Ground Plane FALSE   1 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9581655949437 40.7997708190022)
136 136 -73.9528682507794 40.792580780830704 36I-PM-1007-13 36I PM 10072018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 1 0 0   POINT (-73.9528682507794 40.7925807808307)
159 159 -73.9638270331336 40.7810450065235 21G-PM-1007-02 21G PM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 0 0 1   POINT (-73.9638270331336 40.7810450065235)
171 171 -73.971086588091 40.77197032351779 9G-PM-1007-06 09G PM 10072018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.971086588091 40.7719703235178)
244 244 -73.9597648775789 40.7903443029725 32E-AM-1007-01 32E AM 10072018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9597648775789 40.7903443029725)
349 349 -73.9689657039917 40.776783427676705 15F-AM-1007-04 15F AM 10072018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9689657039917 40.7767834276767)
373 373 -73.96721272832829 40.7810666805133 20D-AM-1007-01 20D AM 10072018 1 Adult Gray   Gray+ too far to note 30' Ground Plane FALSE   1 0 1 1 0 a lot of activity 0 0 0 1 0 0 0 0   POINT (-73.9672127283283 40.7810666805133)
441 441 -73.9742973420446 40.7691801644292 5F-AM-1007-04 05F AM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   rocks 0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9742973420446 40.7691801644292)
574 574 -73.97063600052749 40.7717074044466 9G-PM-1007-05 09G PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9706360005275 40.7717074044466)
591 591 -73.95433237868879 40.7943086530436 37G-PM-1007-03 37G PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 0 1 0 lying on belly on branch,eating big nut 0 0 0 0 0 0 0 0   POINT (-73.9543323786888 40.7943086530436)
722 722 -73.9745953710328 40.7728284025195 8D-AM-1007-07 08D AM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9745953710328 40.7728284025195)
727 727 -73.9634563222926 40.780992836417 21G-PM-1007-04 21G PM 10072018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 0 0 1   POINT (-73.9634563222926 40.780992836417)
850 850 -73.9642288873015 40.782043998356706 22F-AM-1007-06 22F AM 10072018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9642288873015 40.7820439983567)
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)
996 996 -73.9703149829421 40.778558363032296 16D-AM-1007-01 16D AM 10072018 1 Adult Gray White Gray+White   Above Ground 3   0 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9703149829421 40.7785583630323)
1109 1109 -73.96781540330991 40.774278348448604 12H-PM-1007-01 12H PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 in tree 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9678154033099 40.7742783484486)
1115 1115 -73.9545214613307 40.7943801121036 37G-PM-1007-01 37G PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9545214613307 40.7943801121036)
1117 1117 -73.9693465383617 40.7744996336934 12F-PM-1007-01 12F PM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9693465383617 40.7744996336934)
1307 1307 -73.9565197137317 40.7986011403785 41C-PM-1007-01 41C PM 10072018 1 Adult Black   Black+   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9565197137317 40.7986011403785)
1388 1388 -73.9685709455958 40.774487702650596 12G-PM-1007-07 12G PM 10072018 7 Juvenile     +   Above Ground 45   0 0 0 1 0 acorns 0 0 0 0 0 0 0 0   POINT (-73.9685709455958 40.7744877026506)
1404 1404 -73.9700666654946 40.774285704258105 12F-PM-1007-08 12F PM 10072018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0 stared POINT (-73.9700666654946 40.7742857042581)
1408 1408 -73.973230162241 40.768982453144396 5F-AM-1007-01 05F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 fence 1 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.973230162241 40.7689824531444)
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)
1495 1495 -73.97351371783691 40.769109895294 5F-AM-1007-06 05F AM 10072018 6 Adult Gray   Gray+   Above Ground 2 branch 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9735137178369 40.769109895294)
1560 1560 -73.9587072763996 40.7850256219415 27I-AM-1007-01 27I AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   0 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9587072763996 40.7850256219415)
1624 1624 -73.97370600439879 40.772566022498296 8D-AM-1007-05 08D AM 10072018 5 Adult Gray   Gray+   Above Ground 15   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9737060043988 40.7725660224983)
1684 1684 -73.96378247566071 40.7904737110761 30B-AM-1007-08 30B AM 10072018 8 Adult Gray   Gray+   Above Ground 40   1 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9637824756607 40.7904737110761)
1826 1826 -73.9707542189896 40.7717032986885 9G-PM-1007-04 09G PM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9707542189896 40.77170329868851)
1944 1944 -73.97432920664129 40.7756090404121 11B-AM-1007-05 11B AM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 1 0 1 0 0   POINT (-73.9743292066413 40.7756090404121)
2001 2001 -73.9521655419974 40.7948785497717 39H-AM-1007-04 39H AM 10072018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9521655419974 40.7948785497717)
2040 2040 -73.96481673340891 40.7811164976329 20F-PM-1007-02 20F PM 10072018 2 Adult Gray White Gray+White white on tail Ground Plane FALSE   0 0 0 1 1 digging one hole w/ determination 0 0 0 0 1 0 0 1   POINT (-73.96481673340891 40.7811164976329)
2100 2100 -73.9638312025305 40.7903826659569 30B-AM-1007-07 30B AM 10072018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9638312025305 40.7903826659569)
2370 2370 -73.9573119777312 40.7875347862766 30H-AM-1007-02 30H AM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0 following #1 0 0 0 0 1 0 0 0   POINT (-73.9573119777312 40.7875347862766)
2463 2463 -73.9653343572865 40.77752869246171 17H-PM-1007-01 17H PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 1 0   0 0 0 1 0 0 0 1   POINT (-73.9653343572865 40.7775286924617)
2472 2472 -73.9596820155238 40.7932886803231 34D-PM-1007-03 34D PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9596820155238 40.7932886803231)
2566 2566 -73.9744226682925 40.77556257172729 11B-AM-1007-04 11B AM 10072018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9744226682925 40.7755625717273)
2730 2730 -73.96535757586871 40.78053399533721 20F-PM-1007-12 20F PM 10072018 12 Adult Gray White Gray+White   Above Ground 20 in tree 0 0 1 1 0   0 0 0 0 0 0 0 0   POINT (-73.9653575758687 40.7805339953372)
2869 2869 -73.9630822385425 40.7914844989865 31B-PM-1007-04 31B PM 10072018 4 Juvenile Gray   Gray+         0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9630822385425 40.7914844989865)
3019 3019 -73.9639431360458 40.7908677445466 30B-AM-1007-04 30B AM 10072018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9639431360458 40.7908677445466)

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