Collaboration in Civic Spheres

Archive for the ‘Public Data Sets’ Category

Troubles for most Pierce County school districts in 8th grade

by March 3rd, 2013

By a rate of more than two-to-one, public school districts in Pierce County last year underperformed the statewide average for percentage of eighth-graders who could pass Washington’s math achievement test. A majority of districts also lagged the statewide average in percent of eighth-graders who passed Washington’s reading achievement test. Using the Google Public Data Explorer tool and an interface developed by the Center for Education Research and Data of the University of Washington-Bothell, we run two related visualizations incorporating recently-released 2012 data and corollary outcomes dating back to 2006, in math and reading for all 17 Pierce County school districts.

Explore latest K-12 achievement data with UW tool

by February 25th, 2013

Using the Google Public Data Explorer tool, we run two visualizations from recently-released 2012 data on percent of eighth graders meeting the Washington state achievement test passing standard in math, and reading, at 26 selected urban-region districts. In each case, half the districts exceed statewide average performance and half don’t. See custom charts, below. Top performers on the eighth-grade state math achievement test – among districts we examined – were Bellevue, Lake Washington, Port Angeles, Everett, and Olympia. The lowest performers for the same measure in 2012 were the East Valley district near Yakima, plus Yakima, Tacoma, Pasco and Longview. State academic achievement tests data for 2012 have recently been added to the user-friendly, interactive Washington Achievement Data Explorer (WADE) database operated by the Center for Education Data and Research (CEDR) at the University of Washington in Bothell. WADE is integrated with and can be explored using tools from Google Public Data Explorer.

At the WADE site, users can select school districts to compare for achievement test outcomes by grade and subject. Demographic data for each district, which is often correlated with outcomes, is also available. The data come from the Washington State Office of the Superintendent of Public Instruction. Among other features, Google Public Data Explorer provides customized HTML embed code for each data set that is constructed by users. Following are two charts developed by Public Data Ferret using the WADE site.

First are eighth-grade “meeting the math standard” rates for the 26 selected urban-region school districts in Washington state, from 2006 through 2012. They are ranked on the right by 2012 outcomes, but by hovering over any district’s name, its seven-year history for the metric chosen can be tracked.

Next, for the same 26 districts, are the 2012 rankings and seven-year histories of percent of eighth graders meeting the state standard on the reading achievement test.

Public Data Ferret’s Education archive

By clicking on “Explore The Data” in the lower right-hand corner of either of the above charts, you can enter the WADE interface at Google Public Data Explorer and devise a customized report from the state data, choosing different measures and districts. You can also enter the WADE interface, with a tutorial through the the UW-Bothell/CEDR gateway.

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

Washington near top, again, in prescription pain pill misuse

by February 12th, 2013

For the second time in a row, Washington ranks in the top five among 50 U.S. states in the percent of people aged 12 and older who reported having misused prescription painkillers such as Vicodin, OxyContin, Percocet or codeine in the last year by taking them without a prescription or “simply for the experience or feeling the drug caused.” That’s according to newly published findings for 2010-2011 from the National Survey on Drug Use and Health, an ongoing gauge of various concerns which also revealed last fall that from 2008 through 2010 Seattle ranked second out of 33 U.S. metropolitan regions in suicide attempts.

Data viz: bank failures by state rates; & mapped with docs

by February 7th, 2013

The rate of failure for Federal Deposit Insurance Corporation-insured U.S. banks continued to drop in 2012 from its 2010 peak of 2.09 percent. The failure rate was .71 percent in 2012, down from 1.24 percent in 2011. Bank failures eased sharply in 2012 in Washington, to zero, compared to a failure rate in 2011 that was fourth highest in the nation, 4.17 percent; and a rate of 13.92 percent in 2010 that was second highest nationally, after Puerto Rico. These and other data points can be found in the following data visualizations for U.S. states and the nation, based on FDIC open data from 2000 to 2012. To explore: hover your mouse over map dots and dot clusters, graph points, bar tips, and bank names, and use the vertical slider. Following the first, three-part viz is another, which reveals ranked bank failure rates by state each year. There were no recorded bank failures for the years 2005 and 2006.

In this second part of the viz, the map gives average annual bank failure rates for U.S. states. You can scroll down to the chart and mouse over the colored squares for more info. To arrange the states in ranked order of bank failure rates, mouse over the year and click on the small box which contains blue horizontal bars and a downward arrow. Make sure to use the vertical scroll tool on the right to get a full view of the rankings, from top to bottom.

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

Data viz: WA fertility up, abortion down, 1997 to 2011

by January 15th, 2013

From 1997 through 2011 in Washington, abortions are down and fertility is up. Drawn from state Department of Health data, an interactive visualization below that was prepared for Public Data Ferret by Tableau Software of Seattle reveals that within Washington over the 15 years the abortion ratio has been highest in five western counties and lowest in five eastern counties. From 1997 through 2011 the abortion ratio – or abortions per 1,000 live births – was greatest in the counties of King, Pierce, San Juan, Thurston and Jefferson; and lowest in the counties of Garfield, Adams, Grant, Lincoln and Douglas. The state geographic data on abortions is based on county of residence of the woman, not location of the procedure.

Factoring in all 39 Washington counties and all abortions for which the home county of the patient was known (nearly all), the abortion ratio declined markedly from 346.16 abortions per 1,000 live births in 1997 to 230 abortions per 1,000 live births in 2011. On the other hand, the fertility rate, or live births per 1,000 women aged 15-44, grew slightly when counting all 39 Washington counties together, from 61.47 in 1997 to 64.17 in 2011. Across the 15 years in Washington, fertility rates were highest in the eastern or central counties of Adams, Franklin, Grant, Yakima and Okanagan; and lowest in a mix of eastern, central, and western counties. Those were Whitman, Kittitas, San Juan, Garfield and Whatcom.

You can use the data visualization below to reveal abortion ratios, abortion rates and fertility rates for any and all Washington counties in any year from 1997 to 2011 and for all years combined. Using the pull-down menus on the right, below the state map, select the year and statistic to display. For any year and statistic selected, you can scan the comparative results by county in a ranked table under the pull-down menus. You can also hover over a county on the map above for requested data. Additionally, you can single-click on any county on the map for a 15-year line chart below on the left, which will show the general trend and, when hovering directly over the large pinpoints, specific yearly data. Click on that same county once more, on the map above, to go back to the previous view. To get embed code for the viz, click on “share” at bottom left.

The most recent nationwide abortion ratio available is 227 for 2009, according to a Centers For Disease Control report in Morbidity and Mortality Weekly. That compares to a statewide total of 253.7 in 2009 for Washington. Though Washington’s fertility rate has bumped up slightly overall since 1997, it nonetheless tracks closely with the U.S. rate, which is in record decline. According to a National Vital Statistics Report issued by the CDC, the preliminary 2011 U.S. fertility rate of 63.2 is the “lowest rate ever reported for the United States.”

Additional reporting contributed by Matt Rosenberg. Public Data Ferret is a news knowledge base program of the 501c3 public charity, Public Eye Northwest. Ferret In The News. Donate; subscribe (free)/volunteer.

Washington state near top in 51-year rates of rape, larceny

by January 8th, 2013

Washington ranks near the top, or seventh out of 50 states plus the District of Columbia, in average annual rate of reported forcible rape over the 51 years from 1960 through 2011, according to data extracted from the FBI’s Uniform Crime Reporting database and their 2011 update. Washington’s average annual rate of reported forcible rape over the 51 years was 38.97 per 100,000 population. That was exceeded only by Alaska, Michigan, Washington D.C., New Mexico, and Delaware. Washington was also 5th from the top in rate of reported larceny theft from 1961 through 2011. In terms of the rate of violent crime overall, Washington State was 28th of 51 over the same stretch. These are just a few of a wide variety of findings on all 50 states and the nation that are possible through the new Tableau Software crime data visualization below.


From the data viz below, use the pull-down menu titled “crime category” to double-click on a type of crime – there are 10. From the second pull-down menu, choose a year (with “All” covering 1960 through 2011). You’ll get a custom graph showing the rate per 100,000 population of the given crime in the given year. You can hover over states on the U.S. map below in the bottom frame for quick comparisons, and click on a state in the map to get a custom 51-year graph in the top frame.


The viz resides at the “Crime Map” tab – make sure that is the one selected; “Comments” and “Additional Comments” have technical notes on the data processing by the FBI. To generate copy-and-paste embed code for the viz below, click directly on “share.”

RELATED: “Violent crime, murder rates at all-time lows in Washington,” Public Data Ferret; Crime+Data Visualization archive, Public Data Ferret.

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

Violent crime, murder rates at historic lows in Washington

by January 2nd, 2013

The murder rate in Washington state reached a 45-year low of 2.3 per 100,000 population in 2010, and bumped up a scant tenth of a percent in 2011, according to information retrieved from the Federal Bureau of Investigation’s Uniform Crime Reporting database covering 1960 to 2010, and a recently-issued state-by-state update from the bureau. The last year in which the Evergreen State’s murder rate was lower than 2010 was 1965. The rate of total violent crime has also continued to plunge in the state, dropping to a 37-year low of 313.8 per 100,000 in 2010 and then descending further in 2011 to 294.6, according to FBI data. The trend has held in other states and nationwide, even as federal estimates of firearms owned in the U.S. and yearly background checks for new gun purchases have grown markedly from the 1990s through 2012.

Washington juvenile arrest rates highest in rural counties

by October 30th, 2012

Overall 2011 juvenile arrest rates in Washington state were highest in rural counties while the state’s most populous and urbanized county, King, was among those with the lowest rates.

The data come from the Washington Association of Sheriffs and Police Chiefs and is processed by the state’s Statistical Analysis Center. The Center’s Crime Stats Online data hub provides the public with access to the information, which is used in the Office of Financial Management’s annual Washington State Criminal Justice Data Book.

Following are several maps retrieved from the Crime Stats Online data hub, showing juvenile arrest rates by Washington County in 2011, for various types of crimes.

Leading in juvenile arrests per 1,000 population aged 18-39 last year were Adams, Asotin, Benton, Cowlitz, Clark, Douglas, Franklin, Okanagan, Skagit and Walla Walla counties. The rates are calculated according to the metric preferred by law enforcement, which is the number of arrests of juveniles (under 18 years old) for every member of the general population in the same jurisdiction who is between 18 and 39 years old. Here’s that first map, and then four more.