2018_Central_Park_Squirrel_Census

Data source: NYC Open Data · About: The Squirrel Census

52 rows where Age = "Adult", Date = 1019 and Highlight_Fur_Color = "White" sorted by Foraging

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Longitude, Latitude, Unique_Squirrel_ID, Hectare, Shift, Hectare_Squirrel_Number, Combination_of_Primary_and_Highlight_Color, Color_notes, Location, Above_Ground_Sighter_Measurement, Specific_Location, Running, Climbing, Eating, Foraging, Other_Activities, Kuks, Tail_flags, Tail_twitches, Approaches, Indifferent, Runs_from, Latlong

Primary_Fur_Color ✖

Date ✖

  • 1019 · 52 ✖

Age ✖

  • Adult · 52 ✖
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 Latlong Zip_Codes Community_Districts Borough_Boundaries City_Council_Districts Police_Precincts
305 305 -73.9808247660048 40.76894088312871 2A-PM-1019-01 02A PM 1019 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 runs from 0 0 0 1 0 0 0 1   POINT (-73.9808247660048 40.7689408831287)   19 4 19 13
310 310 -73.97111769994709 40.7724278547281 10F-PM-1019-06 10F PM 1019 6 Adult Gray White Gray+White   Above Ground 10.0 Different tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9711176999471 40.7724278547281)   19 4 19 13
601 601 -73.9581241870185 40.7961057536141 38C-AM-1019-05 38C AM 1019 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9581241870185 40.7961057536141)   19 4 19 13
747 747 -73.9720289863666 40.7763749561607 13C-PM-1019-03 13C PM 1019 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9720289863666 40.7763749561607)   19 4 19 13
837 837 -73.9799302952205 40.767720720979796 1B-PM-1019-02 01B PM 1019 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9799302952205 40.7677207209798)   19 4 19 13
965 965 -73.9805927710872 40.76799891166421 1B-PM-1019-07 01B PM 1019 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9805927710872 40.7679989116642)   19 4 19 13
1028 1028 -73.9586077039567 40.796189647707706 38C-AM-1019-10 38C AM 1019 10 Adult Gray White Gray+White   Above Ground 20.0   1 0 1 1 0   1 0 0 0 1 0 0 1   POINT (-73.9586077039567 40.7961896477077)   19 4 19 13
1252 1252 -73.96002043282009 40.782877291358 24I-AM-1019-01 24I AM 1019 1 Adult Gray White Gray+White   Above Ground 10.0   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9600204328201 40.782877291358)   19 4 19 13
1279 1279 -73.95879132892291 40.7961707624534 38C-AM-1019-11 38C AM 1019 11 Adult Gray White Gray+White   Above Ground 20.0   1 0 1 1 0   1 0 0 0 1 0 0 1   POINT (-73.9587913289229 40.7961707624534)   19 4 19 13
1670 1670 -73.9804065254162 40.7681481183296 1B-PM-1019-08 01B PM 1019 8 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9804065254162 40.7681481183296)   19 4 19 13
2536 2536 -73.98089749771201 40.7690578709841 2A-PM-1019-02 02A PM 1019 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 0   POINT (-73.980897497712 40.7690578709841)   19 4 19 13
2672 2672 -73.95972059663241 40.7969409510133 38B-AM-1019-01 38B AM 1019 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9597205966324 40.7969409510133)   19 4 19 13
2679 2679 -73.9797122322834 40.767834758743504 1B-PM-1019-10 01B PM 1019 10 Adult Cinnamon White Cinnamon+White   Above Ground   Dog chased up tree 0 0 1 0 0   0 0 0 0 1 0 0 0   POINT (-73.9797122322834 40.7678347587435)   19 4 19 13
2797 2797 -73.9802983138318 40.7676540772339 1B-PM-1019-05 01B PM 1019 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9802983138318 40.7676540772339)   19 4 19 13
3328 3328 -73.9808247660048 40.76894088312871 2A-PM-1019-01 02A PM 1019 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 runs from 0 0 0 1 0 0 0 1   POINT (-73.9808247660048 40.7689408831287)   19 4 19 13
3333 3333 -73.97111769994709 40.7724278547281 10F-PM-1019-06 10F PM 1019 6 Adult Gray White Gray+White   Above Ground 10.0 Different tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9711176999471 40.7724278547281)   19 4 19 13
3624 3624 -73.9581241870185 40.7961057536141 38C-AM-1019-05 38C AM 1019 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9581241870185 40.7961057536141)   19 4 19 13
3770 3770 -73.9720289863666 40.7763749561607 13C-PM-1019-03 13C PM 1019 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9720289863666 40.7763749561607)   19 4 19 13
3860 3860 -73.9799302952205 40.767720720979796 1B-PM-1019-02 01B PM 1019 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9799302952205 40.7677207209798)   19 4 19 13
3988 3988 -73.9805927710872 40.76799891166421 1B-PM-1019-07 01B PM 1019 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9805927710872 40.7679989116642)   19 4 19 13
4051 4051 -73.9586077039567 40.796189647707706 38C-AM-1019-10 38C AM 1019 10 Adult Gray White Gray+White   Above Ground 20.0   1 0 1 1 0   1 0 0 0 1 0 0 1   POINT (-73.9586077039567 40.7961896477077)   19 4 19 13
4275 4275 -73.96002043282009 40.782877291358 24I-AM-1019-01 24I AM 1019 1 Adult Gray White Gray+White   Above Ground 10.0   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9600204328201 40.782877291358)   19 4 19 13
4302 4302 -73.95879132892291 40.7961707624534 38C-AM-1019-11 38C AM 1019 11 Adult Gray White Gray+White   Above Ground 20.0   1 0 1 1 0   1 0 0 0 1 0 0 1   POINT (-73.9587913289229 40.7961707624534)   19 4 19 13
4693 4693 -73.9804065254162 40.7681481183296 1B-PM-1019-08 01B PM 1019 8 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9804065254162 40.7681481183296)   19 4 19 13
5559 5559 -73.98089749771201 40.7690578709841 2A-PM-1019-02 02A PM 1019 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 0   POINT (-73.980897497712 40.7690578709841)   19 4 19 13
5695 5695 -73.95972059663241 40.7969409510133 38B-AM-1019-01 38B AM 1019 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9597205966324 40.7969409510133)   19 4 19 13
5702 5702 -73.9797122322834 40.767834758743504 1B-PM-1019-10 01B PM 1019 10 Adult Cinnamon White Cinnamon+White   Above Ground   Dog chased up tree 0 0 1 0 0   0 0 0 0 1 0 0 0   POINT (-73.9797122322834 40.7678347587435)   19 4 19 13
5820 5820 -73.9802983138318 40.7676540772339 1B-PM-1019-05 01B PM 1019 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9802983138318 40.7676540772339)   19 4 19 13
83 83 -73.9586570546871 40.796349417475 38C-AM-1019-09 38C AM 1019 9 Adult Gray White Gray+White Gray & White selected as Primary & Highlights. Made executive adjustments. Above Ground 3.0 Between ground & tree 0 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.9586570546871 40.796349417475)   19 4 19 13
611 611 -73.9587072373474 40.7985209579925 40B-AM-1019-01 40B AM 1019 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9587072373474 40.7985209579925)   19 4 19 13
705 705 -73.9628982772673 40.788430480338604 28D-PM-1019-01 28D PM 1019 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9628982772673 40.7884304803386)   19 4 19 13
824 824 -73.9530811255728 40.7983069118579 42F-AM-1019-02 42F AM 1019 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9530811255728 40.7983069118579)   19 4 19 13
1448 1448 -73.9807982742225 40.7678795985389 1B-PM-1019-01 01B PM 1019 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9807982742225 40.7678795985389)   19 4 19 13
1806 1806 -73.958247706428 40.7989079136796 40B-AM-1019-07 40B AM 1019 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 1   POINT (-73.958247706428 40.7989079136796)   19 4 19 13
2100 2100 -73.9708775864433 40.772473633538 10F-PM-1019-12 10F PM 1019 12 Adult Black White Black+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9708775864433 40.772473633538)   19 4 19 13
2400 2400 -73.9597192455543 40.7973316178661 38A-AM-1019-03 38A AM 1019 3 Adult Gray White Gray+White White belly Ground Plane FALSE   0 0 0 0 1 stood on back legs 0 0 0 0 0 1 1 1   POINT (-73.9597192455543 40.7973316178661)   19 4 19 13
2552 2552 -73.95823067436599 40.7989268396525 40B-AM-1019-08 40B AM 1019 8 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 1 1   POINT (-73.958230674366 40.7989268396525)   19 4 19 13
2614 2614 -73.9803282698463 40.7680809889384 1B-PM-1019-09 01B PM 1019 9 Adult Gray White Gray+White   Ground Plane FALSE Tree to ground 0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9803282698463 40.7680809889384)   19 4 19 13
2640 2640 -73.95046935442251 40.797225436004 42H-AM-1019-01 42H AM 1019 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9504693544225 40.797225436004)   19 4 19 13
2721 2721 -73.9809688694074 40.7688535974878 2A-PM-1019-06 02A PM 1019 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9809688694074 40.7688535974878)   19 4 19 13
3106 3106 -73.9586570546871 40.796349417475 38C-AM-1019-09 38C AM 1019 9 Adult Gray White Gray+White Gray & White selected as Primary & Highlights. Made executive adjustments. Above Ground 3.0 Between ground & tree 0 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.9586570546871 40.796349417475)   19 4 19 13
3634 3634 -73.9587072373474 40.7985209579925 40B-AM-1019-01 40B AM 1019 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9587072373474 40.7985209579925)   19 4 19 13
3728 3728 -73.9628982772673 40.788430480338604 28D-PM-1019-01 28D PM 1019 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9628982772673 40.7884304803386)   19 4 19 13
3847 3847 -73.9530811255728 40.7983069118579 42F-AM-1019-02 42F AM 1019 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9530811255728 40.7983069118579)   19 4 19 13
4471 4471 -73.9807982742225 40.7678795985389 1B-PM-1019-01 01B PM 1019 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9807982742225 40.7678795985389)   19 4 19 13
4829 4829 -73.958247706428 40.7989079136796 40B-AM-1019-07 40B AM 1019 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 1   POINT (-73.958247706428 40.7989079136796)   19 4 19 13
5123 5123 -73.9708775864433 40.772473633538 10F-PM-1019-12 10F PM 1019 12 Adult Black White Black+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9708775864433 40.772473633538)   19 4 19 13
5423 5423 -73.9597192455543 40.7973316178661 38A-AM-1019-03 38A AM 1019 3 Adult Gray White Gray+White White belly Ground Plane FALSE   0 0 0 0 1 stood on back legs 0 0 0 0 0 1 1 1   POINT (-73.9597192455543 40.7973316178661)   19 4 19 13
5575 5575 -73.95823067436599 40.7989268396525 40B-AM-1019-08 40B AM 1019 8 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 1 1   POINT (-73.958230674366 40.7989268396525)   19 4 19 13
5637 5637 -73.9803282698463 40.7680809889384 1B-PM-1019-09 01B PM 1019 9 Adult Gray White Gray+White   Ground Plane FALSE Tree to ground 0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9803282698463 40.7680809889384)   19 4 19 13
5663 5663 -73.95046935442251 40.797225436004 42H-AM-1019-01 42H AM 1019 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9504693544225 40.797225436004)   19 4 19 13
5744 5744 -73.9809688694074 40.7688535974878 2A-PM-1019-06 02A PM 1019 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9809688694074 40.7688535974878)   19 4 19 13

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "2018_Central_Park_Squirrel_Census" (
"Longitude" REAL,
  "Latitude" REAL,
  "Unique_Squirrel_ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" INTEGER,
  "Hectare_Squirrel_Number" INTEGER,
  "Age" REAL,
  "Primary_Fur_Color" REAL,
  "Highlight_Fur_Color" REAL,
  "Combination_of_Primary_and_Highlight_Color" TEXT,
  "Color_notes" REAL,
  "Location" REAL,
  "Above_Ground_Sighter_Measurement" REAL,
  "Specific_Location" REAL,
  "Running" INTEGER,
  "Chasing" INTEGER,
  "Climbing" INTEGER,
  "Eating" INTEGER,
  "Foraging" INTEGER,
  "Other_Activities" REAL,
  "Kuks" INTEGER,
  "Quaas" INTEGER,
  "Moans" INTEGER,
  "Tail_flags" INTEGER,
  "Tail_twitches" INTEGER,
  "Approaches" INTEGER,
  "Indifferent" INTEGER,
  "Runs_from" INTEGER,
  "Other_Interactions" REAL,
  "Latlong" TEXT,
  "Zip_Codes" REAL,
  "Community_Districts" INTEGER,
  "Borough_Boundaries" INTEGER,
  "City_Council_Districts" INTEGER,
  "Police_Precincts" INTEGER
)
Powered by Datasette · Query took 1016.958ms · Data source: NYC Open Data · About: The Squirrel Census