Collaboration in Civic Spheres

Archive for the ‘Federal Government’ Category

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.

CDC: flu vaccine has 38% failure rate this season

by January 22nd, 2013

In little more than six out of ten instances – or 62 percent of the time – has flu vaccine actually prevented patients from getting the influenza virus, according to early results for this winter reported from sampling in five U.S. regions including Seattle. The news comes in a recently-released brief from the U.S. Flu Vaccination Effectiveness Network, that was published in the U.S. Centers For Disease Control open access journal Morbidity and Mortality Weekly Report. The good news for the Seattle area is that it had the highest “influenza-negative rate,” of 76 percent, among the five sampled regional health systems.

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.

OIG report: ignored reforms could save HHS $23B yearly

by January 7th, 2013

The federal government could save more than $23 billion per year and hundreds of billions in the next decade if its Medicare and Medicaid programs and lawmakers acted on ignored audit and efficiency recommendations, some of them now decades old, according to a December 2012 summary report from the Office of the Inspector General of the Department of Health and Human Services. The report is titled “Compendium of Unimplemented Recommendations.”

WA far outpaces U.S. in gun buy background checks

by January 3rd, 2013

New federal data tied to one prominent indicator suggests Washington state is far outpacing neighboring states plus California and the United States in firearms purchases from 1999 through 2012. That’s the number of background checks submitted from federal firearms licensees to the National Instant Criminal Background Check System (NICS) on behalf of unlicensed buyers, under the federal Brady law. The total from Washington has grown from 133,674 in 1999 to 519,209 in 2012, or 288 percent versus 114 percent nationwide, 66 percent in Oregon, 70 percent in Idaho and 28 percent in California. The data come from updated annual state-by-state and nationwide NICS summaries issued this week by the Federal Bureau of Investigation. (See chart, below).

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.

Key state ferry terminal project at Mukilteo $38.7M short

by December 28th, 2012

A new car ferry terminal on the State of Washington’s busiest vehicle run – from Mukilteo in Snohomish County to Clinton on south Whidbey Island – is currently $38.7 million shy of a needed $140.9 million for construction, according to a new report to the legislature from the Washington State Department of Transportation. The current terminal has been a big headache for commuters for years due to poor design which contributes to long backups for vehicles and complications in trying to load cars and foot passengers at the same time. WSDOT says future usage of the terminal is expected to grow 73 percent by 2030. In Washington, car ferries are considered part of the state highway system, particularly where bridges haven’t been built, across scenic Puget Sound. Earlier replacement plans for the strained regional transportation hub were shelved in 2007 due to “funding and constructability” challenges, but then re-started in 2010.