Collaboration in Civic Spheres

Mike Klaczynski's Profile

Mike Klaczynski is a UW grad and data analyst at Tableau Software in Seattle’s Freemont neighborhood. He curates Viz of the Day, supporting and training journalists and bloggers using Tableau Public. Tableau Public is a data visualization and publishing tool allowing everyone to discover and create compelling interactive content and share it on the web. Free download.


Mike Klaczynski's Recent Posts

Data viz: Seattle public schools “pass rates” on state tests

May 15th, 2013

To graduate from a public high school in Washington, students in the classes of 2013 and 2014 must pass the state’s High School Proficiency Exam (HSPE) in reading and writing and an End-Of-Course (EOC) test in either algebra or geometry. Starting in 2015 those requirements will grow to include EOCs in algebra and geometry, and biology. State assessment tests called the Measurement of Student Progress (MSP) are also given in grades three through eight to help students, parents, teachers and administrators assess academic progress and adjust teaching methods and curriculum as deemed necessary. For non-special education students, passing the regular tests requires a grade of Level 3 (proficient) or Level 4 (advanced). Using Washington state data on achievement tests taken and passed in math and reading in different Seattle public schools across different grade levels, we developed the following interactive data visualization. Explore it to see how neighborhood public schools rate, compared to others in the district.

1) Make your selections. Under “choose grade,” use the pull-down menu to select a type of school (elementary, K-8, middle, high). Using the “compare schools” tool select one school, or all schools within that category, or a custom combination of schools. Under “choose a test,” select either math or reading.

2) Explore the data. Here’s an example. By choosing all elementary schools and state reading test pass rates, you can: a) get a quick comparative overview via a mouse-over of any school’s dot on the map. You’ll see a pop-up box summary for each dot over which you hover, with a combined multi-year pass rate in the chosen subject, and relative ranking versus peer schools within the district; b) drill in to a school’s data by clicking on its map dot. Then you will have two more views of the data – above to the left (percent low-income and not, plus total number of tests taken); and below (yearly results by grade, subject and income group, versus district averages).

Additional technical notes:

  • Aggregate pass rates for schools were calculated by the author using number of tests passed versus number taken, from the state’s data because the state’s own pass rates for some schools in some subjects did not match the data.
  • Pass rate data for some schools in some years are not available because it was not included in the state’s datasets.
  • “Low-income” students are currently defined by the state as those eligible for free or reduced-price school meals.
  • The state high school math assessment test was not offered in the 2010-2011 and 2011-2012 school years because it was being redesigned.
  • In 2008 and prior, the equivalent of the MSP, HSPE and EOC tests was called the Washington Assessment of Student Learning, or WASL.
  • RELATED: FAQs on state testing from Washington Office of Superintendent of Public Instruction; additional information on who must take what when, and alternative tests.

    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: bank failures by state rates; & mapped with docs

    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

    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

    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.