Collaboration in Civic Spheres

Archive for the ‘Public Data Sets’ Category

Interactive asset map of public art in Seattle

by June 5th, 2012

This data visualization shows the location and site information for each of the 316 art installations sponsored by the City of Seattle as of June 2012. Blue circles indicate the geographic location of each project. Hovering your cursor over a circle will reveal the project’s title, site, artist’s name, type of media, brief description and date installed. In addition, the viz displays the project’s physical address as well as a link to the satellite view in Google Maps. Additional information about a particular project may be found by following the link to the website of the City of Seattle Office of Art and Cultural Affairs. Source: City of Seattle public art data set, via


-Zoom in/out: Use the control panel in the upper left of the viz.
-Move map view: Click and hold until cursor becomes a fist, then drag to desired location.
-Select multiple sites: Click and drag to select desired sites.

Public Data Ferret is a news knowledge base program of the Seattle-based 501c3 public charity, Public Eye Northwest. Ferret In The News. Donate; subscribe (free)/volunteer.

State seeks bids on more probes for geothermal energy

by May 25th, 2012

The State of Washington’s Department of Natural Resources is seeking bidders for drilling exploratory geothermal boreholes in Skamania and Klickitat counties at up to five of six targeted sites that have passed environmental muster: Swift Creek, Northwood and Wind River in Skamania County; and Laurel, Outlet Creek, and Box Canyon Quarry in Klickitat County. (Coordinates table; map.) Each borehole would be six inches in diameter and reach a depth of 700 feet, although the drilling would not require construction of new roads or other major infrastructure alterations. Their purpose would be to determine the extent of geothermal energy at the sites, rather than to generate power. The winning bid will likely be selected the week of June 4th, and drilling of the new probes is scheduled to begin as soon as the first or second week of July, said DNR Procurement Coordinator Melanie Williams.

Regional public utility districts and private energy companies produce energy in Washington, but the state regulates the industry and in the case of geothermal, helps take stock of resource potential. Higher-temperature sites are the most preferable. Following is a mapped visualization of geothermal energy exploration to date in Washington, created by Public Data Ferret.

Washington ranks high in mixed-race households

by May 6th, 2012

A newly-released focus report on U.S. households by the Census Bureau reveals Washington State is in the top fifth nationally in mixed-race households. Which ever way you slice it. Of Washington husband-wife households counted in the 2010 Census, 10.9 percent were mixed race – versus 6.9 percent nationally. That ranks eighth out of the 50 U.S. states plus the District of Columbia and Puerto Rico. The trend carried across other types of couplings in Washington households. Of unmarried, opposite-sex partner households in Washington, 19.6 percent were mixed race versus 14.2 percent nationally; the state ranked eighth of 52. For same-sex households in Washington, 18.5 percent included partners of different races, versus 14.5 percent nationally; and the state ranked 10th of 52. The report was full of other notable findings nationally, and for Washington and Seattle – regarding solo households, households with children, households headed by single women and single moms, and same-sex households.

UW report: King County a national leader in life expectancy

by May 4th, 2012

King County ranks in the top two percent nationally for male and female life expectancy, according to a nationwide survey of all 3,147 U.S. counties or county equivalents, by the Institute for Health Metrics and Evaluation at the University of Washington. IHME’s U.S. County Performance Research Team, led by Dr. Ali Mokdad, of Mercer Island, recently presented the survey data (here, in an Excel file) at a health care journalists conference in Atlanta. Researchers gathered life expectancy data for men and for women in each U.S. county, and used 1989, 1999 and 2009 as key touchpoints.

Washington ranks in the middle nationally on executions

by April 3rd, 2012

According to a recent report from the U.S. Bureau of Justice Statistics, Washington is ranked twenty-fourth among U.S. states in the number of inmates it executed during the years 1930-2010, at 52. However, very few prisoners have received the death penalty in recent years; Washington has executed only five inmates during the years 1977-2010, 22nd of 50 in that time. Texas ranked first, having executed 761 inmates since 1930, and 464 between 1977 and 2010. Data on all 50 states is immediately below, in our visualization based on the BJS report.

Follow the red and blue lines closely with your mouse, to see data on all 50 states.
Source: The Bureau of Justice Statistics

According to a 2008 report by the Washington, D.C.-based Urban Institute on the costs involved in capital-eligible cases in Maryland, cases in which the death penalty was not sought cost on average over $1.1 million. Cases in which the death penalty was unsuccessfully sought cost on average $1.8 million, while cases in which the death penalty was successfully sought cost an average of $3 million.

A bill to abolish the death penalty in Washington, SB 5456, was introduced last year in the state legislature and reintroduced this year, but failed to advance.

Internationally, the death penalty is still very common, according to a recent report from Amnesty International summarized in The Guardian. Amnesty estimates that China alone executes thousands yearly, although exact statistics are difficult to find. China, North Korea, Yemen, Iran and the United States conduct the greatest number of executions. The United States remains the only G8 nation with a death penalty. In total, according to Amnesty, 139 countries still retain a death penalty and last year, at least 676 executions were carried out by nations other than China, roughly half of which were conducted in Iran.

Public Data Ferret’s Data Visualization archive

Public Data Ferret is a news knowledge base program of the Seattle-based 501c3 public charity, Public Eye Northwest. Ferret In The News; Donate.