csv-data

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

Custom SQL query returning 14 rows (show)

Query parameters

This data as json, CSV

rowidLongitudeLatitudeUnique_Squirrel_IDHectareShiftDateHectare_Squirrel_NumberAgePrimary_Fur_ColorHighlight_Fur_ColorCombination_of_Primary_and_Highlight_ColorColor_notesLocationAbove_Ground_Sighter_MeasurementSpecific_LocationRunningChasingClimbingEatingForagingOther_ActivitiesKuksQuaasMoansTail_flagsTail_twitchesApproachesIndifferentRuns_fromOther_InteractionsLatlongZip_CodesCommunity_DistrictsBorough_BoundariesCity_Council_DistrictsPolice_Precincts
2056 -73.97052601032391 40.782633368659894 19A-PM-1013-04 19A PM 1013 4 Adult Gray Black, White Gray+Black, White Also looks quite brown - minimal body highlight coloring - black edges Above Ground 2.0   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9705260103239 40.7826333686599)   19 4 19 13
5079 -73.97052601032391 40.782633368659894 19A-PM-1013-04 19A PM 1013 4 Adult Gray Black, White Gray+Black, White Also looks quite brown - minimal body highlight coloring - black edges Above Ground 2.0   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9705260103239 40.7826333686599)   19 4 19 13
375 -73.965862100991 40.782592689691704 22D-PM-1012-01 22D PM 1012 1 Adult Gray Black, White Gray+Black, White   Above Ground 5.0   0 0 1 0 0   1 0 0 0 0 0 0 0 climbing tree POINT (-73.965862100991 40.7825926896917)   19 4 19 13
3398 -73.965862100991 40.782592689691704 22D-PM-1012-01 22D PM 1012 1 Adult Gray Black, White Gray+Black, White   Above Ground 5.0   0 0 1 0 0   1 0 0 0 0 0 0 0 climbing tree POINT (-73.965862100991 40.7825926896917)   19 4 19 13
449 -73.9759510842771 40.769288289110996 5D-AM-1020-04 05D AM 1020 4 Adult Gray Black, White Gray+Black, White White selected as Primary. Black selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9759510842771 40.769288289111)   19 4 19 13
815 -73.9663297144622 40.7837932023685 22D-PM-1012-03 22D PM 1012 3 Adult Gray Black, White Gray+Black, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9663297144622 40.7837932023685)   19 4 19 13
1609 -73.9665709146738 40.7839384318554 22D-PM-1012-04 22D PM 1012 4 Adult Gray Black, White Gray+Black, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9665709146738 40.7839384318554)   19 4 19 13
2702 -73.96149727573321 40.7921404951324 33C-PM-1007-02 33C PM 1007 2 Adult Gray Black, White Gray+Black, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9614972757332 40.7921404951324)   19 4 19 13
2782 -73.9657504643585 40.783121081359205 22D-PM-1012-02 22D PM 1012 2 Adult Gray Black, White Gray+Black, White No Primary Fur Color selected. Made executive adjustment based on other squirrels. Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9657504643585 40.7831210813592)   19 4 19 13
3472 -73.9759510842771 40.769288289110996 5D-AM-1020-04 05D AM 1020 4 Adult Gray Black, White Gray+Black, White White selected as Primary. Black selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9759510842771 40.769288289111)   19 4 19 13
3838 -73.9663297144622 40.7837932023685 22D-PM-1012-03 22D PM 1012 3 Adult Gray Black, White Gray+Black, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9663297144622 40.7837932023685)   19 4 19 13
4632 -73.9665709146738 40.7839384318554 22D-PM-1012-04 22D PM 1012 4 Adult Gray Black, White Gray+Black, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9665709146738 40.7839384318554)   19 4 19 13
5725 -73.96149727573321 40.7921404951324 33C-PM-1007-02 33C PM 1007 2 Adult Gray Black, White Gray+Black, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9614972757332 40.7921404951324)   19 4 19 13
5805 -73.9657504643585 40.783121081359205 22D-PM-1012-02 22D PM 1012 2 Adult Gray Black, White Gray+Black, White No Primary Fur Color selected. Made executive adjustment based on other squirrels. Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9657504643585 40.7831210813592)   19 4 19 13
Powered by Datasette · Query took 1.993ms · Data source: NYC Open Data · About: The Squirrel Census