Collaboration in Civic Spheres

Archive for the ‘Public Data Sets’ Category

New DOJ report: U.S. firearm homicide rate at 18-year low

by Matt Rosenberg May 16th, 2013

The rate of firearm-related homicides in the U.S. in 2011 was 3.6 per 100,000 persons, the same as in 2010 and otherwise lower than any year from 1993 forward, according to a new report from the U.S. Justice Department’s Bureau of Justice Statistics. The previous low in the 18-year study period was 3.8 in 2000. And, according to the BJS report, the rate in 2011 of non-fatal firearm victimizations, or reported acts of violence in which firearms were used, was 1.8 per 1,000 people 12 and older. That was up one-fifth of one percent from the last two years but down five-and-one-half points since 1993.

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

by Mike Klaczynski 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.

USER INSTRUCTIONS
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.

    U.S.: Washington stays near top in carbon-free capitalism

    by Matt Rosenberg May 14th, 2013

    A new report from the U.S. Department of Energy shows Washington state has continued through 2010 to remain near the top among all 50 states in fueling its economy with minimal consumption of carbon dioxide emissions. According to the report from the department’s Energy Information Administration, Washington in 2010 ranked sixth lowest nationally for the tenth year in a row in metric tons of energy-related carbon dioxide emissions per million dollars of gross domestic product (GDP). The only states ranking lower in 2010 in proportion of energy-related carbon dioxide emitted to fuel their economies were, in order, New York, Connecticut, Massachusetts, California, and Oregon.

    The report emphasizes that what is being measured is based on where the energy is used, not where it is produced. But in the states whose economies are most tied to carbon emissions in the report, a lot of the consumption of that greenhouse gas actually occurs in order to produce fossil fuels.

    The states using the most energy-related carbon dioxide per million dollars GDP were Wyoming, North Dakota, Alaska, West Virginia and Louisiana. The report notes, “All these are fossil-energy-producing states. The activity of producing energy is itself energy intensive.”

    Another important metric in the report is per-capita, or per person, energy-related carbon dioxide emissions per state. There, Washington ranked eighth lowest among all 50 states in 2010, and between sixth and tenth lowest straight through from 2000 to 2009.

    Looking at the percentage decrease in per capita energy-related carbon dioxide emissions from 2000 through 2010, only nine states outpaced Washington, which decreased by nearly one-fifth, in percentage terms.

    The EIA also analyzed each state for 2010 energy-related carbon dioxide emissions by major sector of usage. In Washington, the commercial sector was responsible for 3.8 percent, electric power production for 13.1 percent of the usage, the residential sector for 5.1 percent, industrial 12.0 and transportation a relatively whopping 42.1 percent.

    RELATED:

    Study overview page with tables in .pdf and Excel.

    Public Data Ferret’s Energy+Environment archive.


    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.

    Few births in Washington outside of marriage; 5th lowest rate

    by Matt Rosenberg May 7th, 2013

    Washington state has one of the lowest rates of out-of-wedlock births in the U.S., according to the Census Bureau. A new report issued in May 2013 says that in the most recent year for which detailed American Community Survey data on the subject are available – 2011 – 35.7 percent of births nationwide were to unmarried women. In Washington, the rate was just 27.7 percent or fifth lowest overall, but it ranged widely within the state by metro region. Tri-Cities and Bremerton were far below the national average, while greater Seattle, Olympia and Bellingham were somewhat below it. Spokane was slightly below the national average, Wenatchee above it, and Longview and Yakima far in excess of it. State-by-state, the only ones with lower overall rates than Washington were Utah, New Hampshire, Montana and Nebraska. They ranged from 14.7 percent to 25.3 percent. It matters, say the authors of the report, because children born outside of marriage are more likely to be raised in poverty, and have poor developmental and behavioral outcomes.

    Data viz: whiteness, not latitude, tied to skin cancer rates

    by Danning Chen April 9th, 2013

    U.S. states with the highest skin cancer rates tend to have a high proportion of whites in their population while those with the lowest rates don’t. And the top two states for skin cancer, Vermont and Utah, feature especially high concentrations – compared to others – of young whites, age 18 to 24. These are a few of the correlations evident from the most recent annual skin cancer rates across the U.S., for 2009, and some of the demographic risk factors identified in scientific research. The official “white/non-Hispanic” population is 80 percent-plus in seven of the top ten skin cancer states, versus only one of the bottom ten. Three of the top ten were in the Northwest: Idaho fifth, Washington sixth and Oregon tied for seventh. Exposure to ultraviolet rays from both sun and tanning beds is considered a major risk factor for skin cancer, but sunny climes alone don’t appear to be a determinant. States typically bathed in ultraviolet rays such as Florida, Texas, and Arizona were in the bottom quintile for skin cancer. You can further explore the data in the visualization below.

    (Additional user tips: You can hover over the dot in each state for all three data points. To quickly rank states, hover over any of the three column headers in chart, then slide cursor to longest of the adjacent horizontal bars and click for a descending sort.)

    The U.S. Centers for Disease Control reports that skin cancer is the most common form of cancer in the United States, with 61,646 melanomas of the skin diagnosed in 2009, and 9,199 attributed deaths. According to research published in the CDC’s Morbidity and Mortality Weekly Report in 2012, skin cancer costs approximately $1.7 billion to treat annually in the U.S. and results in $3.8 billion in lost productivity. The National Cancer Institute’s Cancer Trends Progress Report – 2011-2012 Update notes younger adults and men are less likely to apply forms of sun protection, as are adults with incomes below 200 percent of the poverty level. Another risk group is young white women prone to use of indoor tanning beds.


    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.

    U.S. inpatient death rates down, but not for blood infections

    by Matt Rosenberg April 2nd, 2013

    A recent data brief from the U.S. Centers for Disease Control reports that inpatient hospital death rates are down 20 percent from 2000 to 2010 overall, and down markedly in that time for seven of eight major “first-listed diagnoses” with the notable exception of septicemia, or infections of the bloodstream. The overall death rate for U.S. hospital inpatients dropped from 2.5 per 100 patients in 2000 to 2.2 in 2005 and 2.0 in 2010. Death rates per 100 patients hospitalized for first-listed diagnosis were also down sharply for respiratory failure, pnuemonitis due to solids and liquids, pneumonia, kidney disease, cancer, stroke, and heart disease. But for septicemia, inpatient deaths grew 17 percent – from 13.9 per 100 patients hospitalized for that diagnosis in 2000, to 16.3 per 100 such patients in 2010.

    Washington tops U.S. in 12-year Alzheimer’s Death Rates

    by Matt Rosenberg March 28th, 2013

    Earlier this month, the U.S. government reported the death rate for Alzheimer’s disease rose 39 percent from 2000 to 2010 and that in 2010 Washington had the highest rate among U.S. states. Yet which states had the highest Alzheimer’s death rates not just for 2010, but over the entire last decade? Digging into the Compressed Mortality File of the National Center for Health Statistics, using the “Wonder” data retrieval tool of the U.S. Centers for Disease Control, we found that from 1999 through 2010, Washington state by a wide margin had the highest age-adjusted average annual death rate from Alzheimer’s disease in the U.S. It was 39.75 per 100,000 population. Of the top ten counties for Alzheimer’s deaths in Washington nine were western. This most prevalent type of dementia strikes mainly older people, but life expectancies statewide for both men and women in Washington are only slightly above national averages – as shown in the most recent data (2009, Excel) from the University of Washington’s Institute for Health Metrics and Evaluation. The CDC says the most closely-correlated risk factors for Alzheimer’s are age and genetics but that high blood pressure, high cholesterol and diabetes may also figure in.


    Map: Alzheimer’s Disease Death Rate Per 100K Pop., by U.S. State, 1999-2010

    From National Center for Health Statistics, U.S. Centers for Disease Control, Compressed Mortality File, 1999-2010. Rates are age-adjusted, with 95% confidence interval


    Rounding out the top ten U.S. states in 1999-2010 age-adjusted Alzheimer’ death rates per 100,000 population after Washington are North Dakota (32.70), Arizona (30.82), South Carolina (30.76), Tennessee (30.68), Maine (29.75), Louisiana (29.38), Alabama (28.80), Oregon (28.50) and Colorado (28.35).

    Top three WA counties for Alzheimer’s death rates are Kitsap, Wahkiakum, Skagit
    Within Washington, nine of the ten counties with the highest Alzheimer’s death rate over the 12-year stretch from 1999 through 2010 were in the western part of the state. The 10 were Kitsap (55.91), Wahkiakum (53.38), Skagit (49.42), Thurston (47.18), Island (46.36), Cowlitz (46.32), Pend Oreille (44.73), Pierce (42.91), Lewis (42.73), and Snohomish (42.62).


    Map: Alzheimer’s Disease Death Rate Per 100K Pop., by WA Counties, 1999-2010

    From National Center for Health Statistics, U.S. Centers for Disease Control, Compressed Mortality File, 1999-2010. Rates are age-adjusted, with 95% confidence interval

    The NCHS reports Alzheimer’s is now the sixth most frequent cause of death in the U.S. and fifth for those 65 and up. Non-Hispanic whites have a 26 percent greater risk of death from Alzheimer’s than African-Americans and a 30 percent greater risk compared to the Hispanic population. An estimated $200 million was spent in 2012 caring for patients with Alzheimer’s and other forms of dementia in the U.S. That amount is projected to more than quintuple by 2050.


    RELATED:

  • Explore NCHS’s Compressed Mortality File 1999-2010 with CDC “Wonder” tool
  • Mortality From Alzheimer’s Disease in the United States – Data From 2000 and 2010,” CDC/NCHS Data Brief, March 2013
  • CDC feature, Alzheimer’s Disease
  • Alzheimer’s Disease Research Center, University of Washington

  • 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 combined cancer rates tops in western counties

    by Danning Chen March 15th, 2013

    Five years of data from the National Cancer Institute’s State Cancer Profiles database show that within Washington state, the overall rate of cancer is highest in western counties and lowest in rural and eastern counties. From 2005 through 2009 it was highest in Mason County, at an annual average rate of 554.6 cases per 100,000 population versus 476 per 100,000 across the whole state. Among the state’s 39 counties the rest of the top 10 for 2005-2009 in overall cancer rate, in order, are Grays Harbor, Whatcom, Pierce, Snohomish, Skagit, Thurston Jefferson, Cowlitz and Kitsap. King County ranked 13th. Lowest overall cancer rates were, in order, in the counties of Klickitat, Skamania, Garfield, Asotin and Ferry. Hover over any Washington county in the mapped visualization below to get its overall – known as “all types” – cancer rate, and also use the pull-down menu to select mapped data by Washington county on rates of breast, lung and prostate cancer. A tab atop the map also provides access to U.S. cancer rates by state, for 2009. As we reported recently, Washington ranked 13th among 50 states in the “all types” rate in 2009, but first in breast cancer.

    For breast cancer by county in Washington for 2005-09, Walla Walla County had the highest annual average rate, 159.4 diagnosed cases per 100,000 population. It was followed by the counties of Mason, Cowlitz, Snohomish, Whatcom, King and Thurston. Douglas County had the highest rate of prostate cancer, followed by San Juan, Chelan and Whitman. Grays Harbor County had far and away the highest rate of cancer of the lung and bronchus.

    Contributing to the “all types” rates, according to NCI, are “all invasive cancer sites combined, bladder, breast, brain, cervix, childhood cancers all sites combined, colon and rectum, esophagus, kidney, leukemias, liver and bile duct, lung and bronchus, melanomas of the skin, non-Hodgkin lymphoma, oral cavity and pharynx, ovary, pancreas, prostate, stomach, thyroid, and uterus.”

    (UPDATE: Why one county has a higher rate than another is hard to determine precisely. However in a backgrounder the Washington State Department of Health notes that cancer risk factors include exposure to tobacco and second-hand smoke, excessive alcohol use, excessive exposure to ultraviolet rays from the sun or tanning beds, lack of a diet rich in fruits and vegetables, unhealthy weight, physical inactivity, and not regularly seeking medical care. Additionally, the National Cancer Institute provides an online collection of fact sheets on risks related to different types of cancer.)

    An average annual count of newly-diagnosed cancer cases in each jurisdiction, along with official population data and other statistical and methodological controls are used to develop the rates. More details are available under the links titled, “Interpret,” “About This Table” and “Quick Reference Guide” at the NCI State Cancer Profiles chart for Washington state “all types” rates by county.


    Assistance on the data visualization provided by Mike Klaczynski. Additional reporting 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.