[xyz-ihs snippet=”EPM-dash”]

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.

[xyz-ihs snippet=”Degree-attainment”]

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.

[xyz-ihs snippet=”Working-at-home”]

Sources:

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

2013 Estimates: http://factfinder.census.gov/bkmk/table/1.0/en/ACS/13_1YR/B08101/0100000US|0100000US.04000

2012 Estimates: http://factfinder.census.gov/bkmk/table/1.0/en/ACS/12_1YR/B08101/0100000US|0100000US.04000

2011 Estimates: http://factfinder.census.gov/bkmk/table/1.0/en/ACS/11_1YR/B08101/0100000US|0100000US.04000

2010 Estimates: http://factfinder.census.gov/bkmk/table/1.0/en/ACS/10_1YR/B08101/0100000US|0100000US.04000

[xyz-ihs snippet=”Household-Income-Quintiles”]

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.

The American Community Survey 2009-13 ACS 5-Year dataset, released today by the U.S. Census Bureau, provides new economic and demographic data for smaller geographic areas including all 169 Connecticut towns. The visualization below provides a snapshot of just a few measures from one report within this dataset, “DP03 – Selected Economic Characteristics” – just one of the more than 2,000 tables of new data for Connecticut towns, Congressional districts, school districts, Census Tracts, and other areas. To browse for more detailed economic data on any town, follow the link that appears when you hover over any map in the visualization – or start browsing American FactFinder with some of the links below:

• DP02 – SELECTED SOCIAL CHARACTERISTICS
• DP03 – SELECTED ECONOMIC CHARACTERISTICS
• DP04 – SELECTED HOUSING CHARACTERISTICS

[xyz-ihs snippet=”ACS200913DP3″]

The Connecticut State Data Center has been working on visualizations that highlight some of the data available on the Connecticut Open Data Portal.

The first is a look at home sales (above $2,000) in the State of Connecticut during the year 2011. The data covers 140 of the 169 towns in the State. For each individual sale, the data includes assessed home price, actual sale price, geographic coordinates, and the unique sale serial number. You can see the original data here.

In addition to the more statistical views on the first page of the visualization, the second page features the data on GoogleMaps. This allows for changing the basemap to satellite imagery and even using Google Street View to try and get a look at specific houses.

[xyz-ihs snippet=”Housing-browser”]

The Connecticut State Data Center has created a Census Data Browser for the Regional Councils of Governments in Connecticut, allowing users to view a range of demographic, economic, and housing data for any of the nine RCOG planning regions. While the data dashboard draws mainly on Census Bureau data – decennial census, American Community Survey, and building permit data downloaded from Census.gov – the tool also includes other some other sources such as surface permeability and grand list data. There are many deep links within the tool to the Census Bureau’s American FactFinder data engine, allowing users to explore more detailed data for their town or RCOG region.

This is very much a work in progress, and your suggestions for features and inclusion of additional data sources would be appreciated!

[xyz-ihs snippet=”Regional-Council-of-Governments-Census-Data-Browser”]

This data visualization shows the specific origins of people within Hispanic & Latino populations in Connecticut Census tracts, based on published 2010 Census data. This project is modeled on a visualization created by the Census Bureau which shows the distribution of persons of specific Hispanic/Latino origins across U.S. counties; the map below instead can display what percentage of the Hispanic population in a particular Census tract is of Puerto Rican, or Mexican, origins, for example. The data are taken from 2010 Census table PCT11 for Census Tracts (see link in the tooltip when hovering over the map to see original data for any Census Tract in American FactFinder), and are originally derived from part 8 of the 2010 Census questionnaire.

[xyz-ihs snippet=”Hispanic-Origins-in-CT-Census-Tracts”]

This dashboard displays various measures from the National Center for Education Statistics’ Academic Libraries Survey 2012 dataset. The various views allow the user to filter by institutional Carnegie class to compare similar institutions – from 2-year Associate’s colleges to research universities. A filter for sector – public vs. private – allows apples-to-apples comparisons among libraries for things like collections expenditures and staffing. The ‘Compare expenditures of academic libraries’ and ‘Compare staffing of academic libraries’ tabs let you select specific institutions to compare, for measures including:

• expenditures for print and electronic journal subscriptions in 2012
• expenditures for print materials
• numbers and total salaries/wages of librarians, other staff, and student assistants

[xyz-ihs snippet=”Academic-Library-Survey-2012″]

Yesterday the Connecticut State Department of Education released new data on graduation rates for Connecticut school districts, academy districts, and public charter schools in 2013. The visualization below presents 4- and 5-year graduation rates for districts, with the ability to drill down to see detailed information on graduation rates by gender, race, and reduced-price lunch eligibility within the district.

For more information on the data, see and Governor Malloy’s press release and the Department of Education’s data documentation.