State Data Center Affiliates Training Event

uscensusbureaulogoThe Massachusetts State Data Center at the UMass Donahue Institute is hosting free in-person data training from the U.S. Census Bureau on September 21, 2015 in Hadley, MA.  This event will feature two sections, a morning session focused on the 2012 Economic Census and the OnTheMap data tool for emergency management and the afternoon session will focus on how to use Census data to spur economic development. Participants may attend the morning, afternoon or both but please register using the Evenbrite links below. Seating is limited to 35 attendees per session and the sessions are filling up fast.

Session descriptions

Economic Census and Programs Session – Morning

The morning session (9am-12pm) will start with a general overview of the 2012 Economic Census and Census economic programs in general.  Then there will be a demonstration of Census’s OnTheMap data tool for emergency management.  Your local Census Bureau partner from the New York City regional office will close this session with an overview of the regional office’s activities and other training opportunities they offer.

Register for the Sept 21, 2015 Hadley, MA morning session here:

Census Data to Spur Economic Development Session – Afternoon
The afternoon session (1pm-4:30pm) will begin with Census teaching us how to use Census data to spur economic development.  Then Census will show us how to access Longitudinal – Employer Household Dynamics data (LED data), an important new set of data we have been eagerly anticipating.  Your local Census partner will close this session with a demonstration of the Census Reporter web application and an overview of the regional office’s activities and other training opportunities they offer.

Register for the Sept 21, 2015 Hadley, MA afternoon session here:

Location: UMass Donahue Institute 100 Venture Way #9, Hadley, MA 01035

Demographic Change in Connecticut School Districts

This visualization, created for a presentation at the Connecticut Association of Boards of Education‘s Annual Summer Leadership Conference on July 27 includes data from the Connecticut State Data Center’s Population Projections for school districts in Connecticut, along with demographic, socioeconomic, and enrollment data from the U.S. Census Bureau’s American Community Survey and the CT Department of Education CEDAR data portal. This dashboard was created by Steve Batt, Zachary Guarino and Qiwei Zheng.

Data from the 2013 Annual Survey of Public Pensions

This visualization uses data from the U.S. Census Bureau’s 2013 Annual Survey of Public Pensions State-Administered Defined Benefit Pensions Systems downloaded from American FactFinder. The thematic map indicates the ratio of pension obligations to each state’s total cash and investment holdings in its state-run public pension system at the close of fiscal year 2013. Bar graphs indicate FY13 pension fund net investment earnings, and overall pension fund investments by category (i.e. stocks, Treasury bonds, etc). Locally administered (e.g. municipal) public pension data is excluded from the graphs.

State Government Tax Collections 2014

States have remarkably diverse approaches to taxes; the U.S. Census Bureau’s Annual Survey of State Government Tax Collections collects data on revenue derived from five tax categories for 2014: Income taxes, Property taxes, License taxes, Sales and gross receipts taxes, and Other taxes. This visualization compares the relevant importance of each of these categories in contributing to the tax base of each state.

Unlocking the Potential of Public Data Workshop – June 25, 2015

The Connecticut Data Collaborative and the Connecticut State Data Center are hosting the Unlocking the Potential of Public Data workshop. The workshop will include engaging sessions, training, and discussions on public data in Connecticut and will be held on June 25, 2015.

“Unlocking the Potential of Public Data”
June 25, 2015
UConn Graduate Business Learning Center
Hartford, CT
8:00am to 12:30pm
This event is free to attend and registration is required to attend as space is limited. Registration is closed as we have reached the total number of participants we can accommodate for the facility. Stay tuned for a fall conference announcement.
8:00-8:30 Registration
8:30-8:35 Welcome
8:35-9:05 Confused about the different data resources available in the state? This session will include representatives from various organizations across the state who will explain their organization and the data that can be found on each respective site9:15-10:00 Session 1:

  • Have you ever wondered what the difference is between the 1-year, 3-year, and 5- year Census American Community Survey? Come get all your questions answered about using Census data from a Census representative expert.
  • The Surprisingly Subtle Art of Acquiring Public Data from Public Agencies.
  • hands-on training/workshop in a computer lab

10:15-11:00 Session 2:

  • Beyond the ACS – what other census data is available for policymakers and decision makers? Learn more about the economic census, Longitudinal Employer and Household Dynamics (LEHD), and more.
  • hands-on training/workshop in a computer lab

11:15-12 Ever wondered where to find agency data or wonder if it is available publicly? What initiatives are underway or planned at state agencies for improving data access?
12-12:30 Lightning Session: Transportation Hub (t-HUB) Project and CT Crash Repository,

If you have trouble registering, please email


American Community Survey Median Household Income Distressed Tracts 2010 to 2013

This visualization uses data from the American Community Survey to display distressed census tracts, which is a tract at 60% or less of the state median household income level. This study ranges from the year 2010 to 2013.

by: Zachary Guarino


Native Connecticut Residents with Bachelor’s, Graduate, or Professional Degrees

By: Heather Ewry

In the state of Connecticut, the number of people born in-state who went on to get a bachelor’s, graduate, or professional degree made up a sizable fraction of the people who possessed one of those degrees during the years 2012 and 2013, though they made up a much smaller percentage of the Connecticut population as a whole. In 2012, these people were approximately 77% of the state’s degree holders fell within this category while making up just 14% of the state’s total population. In 2013, both of these percentages increased: now, native Connecticut residents with bachelor’s, graduate, or professional degrees made up 78% of its degree holders while making up approximately 15% of the entire population within the state.

The provided tables and charts break these percentages down by county and year. Interestingly, though the total percentage for the state went up, the county breakdown reveals that this increase was not necessarily reflected by the individual counties. Middlesex County, for example, saw a 3% increase in the number of native Connecticut residents who possessed bachelor’s degrees but a 1% decrease in the number native Connecticut residents who possessed graduate or professional degrees instead. Windham County, on the other hand, saw a 4% increase in the number of native Connecticut residents with bachelor’s degrees as well as a 1% increase in those with graduate or professional degrees.

American Community Survey Workers from Home, 2010-2013

Author: Zachary Guarino

Introduction: This project focuses on comparing the annual percentage of workers at home for primarily the State of Connecticut in comparison to the United States National average from the years 2010 to 2013.

Data: The data is derived from the American Community Survey Means of Transportation to Work by Age 1-Year Estimates from 2010 to 2013. The age breakdowns were aggregated together for this analysis because the focus in on the average for the State and not each age grouping. The workers at home percentage was calculated by dividing the number of workers at home by the total number of workers. Utilizing Tableau software I was able to create visualizations for this data set. There is a wide range of interactive visualizations including line and bar graphs. Most of the Dashboard space is used to show comparisons withe Connecticut and the U.S. workers at home percentage, but I went t a step further to also show how Connecticut compared to other states in New England. Several features on the Dashboard can be altered according to a specific year of interest, allowing for closer comparison in a given year. The trend lines also tell a story of how many workers at home there are over the 3 year span of 2010 to 2013.

Findings: Through the data visualizations I was able to come to the conclusion that Connecticut has had an increase in people who work from home, increasing about 0.39% from 2010 to 2013. There was a slight drop in 2012 but the overall trend is increasing. The percentage of people working at home for the National average had a much more gradual trend line, only increasing by 0.03% from 2010 to 2013. Connecticut has never been higher then the National average yet but is approaching closer every year. In 2013, Connecticut was at 4.33% workers from home the National average only was slightly higher at 4.36%. In comparison to New England, Connecticut although not having the highest percentage of workings at home ranks pretty well given its increasing trend. States like New Hampshire and Rhode Island appear to be on a decrease in people working at home. Vermont’s percentage has been fluctuating a lot, however Connecticut, Maine, and Massachusetts all have positive slopes. A closer look at the trend line shows that Maine has the greatest increase, followed by Connecticut and Massachusetts. So I would rank Connecticut 2nd in percentage of workers at home in New England. The visualization for New England on the Dashboard has a year by year comparison bar graph to allow for analysis at the annual level and the line graphs have been omitted for conservation of space.


Means of Transportation to Work by Age, American Community Survey 1-Year Estimates, 2010 – 2013

2013 Estimates:|0100000US.04000

2012 Estimates:|0100000US.04000

2011 Estimates:|0100000US.04000

2010 Estimates:|0100000US.04000

Household Income Quintiles and the Top 5%

The above map, based on table B19080: “Household income quintile upper limits”  from the 2013 American Community Survey, displays income amounts which would put a household among the wealthiest 5% in their state. The stacked bars adjacent to the map display household income distribution within a state by quintiles, providing an overview of household income distribution.

For Connecticut, New Jersey, and District of Columbia, table B19080 from the 2013 ACS reports that the top 5% of households by income have lower income limits of “250,000+”, while more precise estimates are provided for all other states. Connecticut reached this apparent “250,000+” reporting ceiling in the 2011 American Community Survey report. The top 5% of households in District of Columbia surpassed this threshold several years earlier. Interestingly, in 2009 the American Community Survey reported that the lower limit of the top 5% of households in D.C. was $279,845; in this year’s report the figure is reported simply as being “$250,000+”, obscuring the true estimate. Table B19083 from the 2013 ACS indicates that the District of Columbia has a greater level of income inequality than any state; New York and Connecticut have the highest Gini index among states.