Thursday, May 29, 2014

Projected Openings in the Mohawk Valley by Job Type (2010-2020)

The following data comes through the NYS Department of Labor. The graphic is all mine ! Basically it is the projected job openings (not to be confused with job growth) for this decade. These are broken into two categories: replacement jobs (in other words filling a job that has become vacant) and new jobs.

Personal care and health care appear to be where the most new jobs will be opening up, while office administration and sales support will have the most openings of replacement jobs.

Click to Enlarge

Wednesday, May 28, 2014

Popularity of High School Sports: Participation And Number of Schools Offering Various Sports Programs

The National Federation of High Schools provides survey results of the number of participants and the number of schools offering various varsity sports programs to their students. If you visit the link above you can see data for each state as well as the entire country when it comes to everything from basketball and football, to field hockey and skiing.

Just a word about the student participation counts - understand that these numbers account for the participants in VARSITY sports only. Underclassmen participating junior varsity programs, etc., are not counted here. In addition, students may be counted more than once in they participate in more than one sport.

That being said, here are the ten most population boys and girls sports, as well as participation numbers by state.

Tuesday, May 27, 2014

Unemployment and Our Regional Employment Profile: April 2014

Mark Barbano, the Mohawk Valley's Regional Economist at the New York State Department of Labor, recently provided the two tables below covering our regional/county unemployment rates, as well as our regional Labor Market Profile.

Click to Enlarge
Click to Enlarge

Global Migration Infographic: 1990-2010

There's a really interesting infographic at Global-Migration that allows you to look at global migration patterns by clicking on a region of the world and hovering over each country displayed to see the out- and in-migration. This is broken into five year periods from 1990 to 2010. Below is a static view of the migration for North America. Go to the website and click on the North American region to see how migration differed between the US and Canada.

Click to Enlarge

Thursday, May 22, 2014

2013 Sub-County Estimates Released By Census Bureau

The Census Bureau has released the sub-county estimates for 2013, which covers the cities, villages, towns and remainder of towns (minus the villages). Below are these data for Herkimer and Oneida Counties.

Herkimer County

Click to Enlarge

Oneida County 


Click to Enlarge


Wednesday, May 21, 2014

Most Common Language Spoken in Each State After English and Spanish

Ben Blatt of Slate, has created a series of maps looking at the most popular language spoken in each US state. He used data from the Census Bureau’s American Community Survey to create these. They offer an interesting look at language in each state, especially when English and Spanish are removed from the equation..

Click to Enlarge

 Locally, here are the top 10 languages for people ages 5 and over AFTER English and Spanish for the two county region.

Tuesday, May 20, 2014

PUMS Data: A Regional Look at Single Parenting

One of the more interesting tools available to look at census data is the Public Use Microdata Sample. These cover what are called the PUMAs, or Public Use Microdata Areas. For our region, there are two PUMAs that cover 90% of the two county region - all but the lower five towns in Oneida County and the lower four southwestern towns of Herkimer County.

The cool thing about PUMS data is that you can access the actual sample and then manipulate the data to crosstab items that wouldn't otherwise be possible. Without going into a lot of discussion about the methodology of gathering PUMS data (a full description of what PUMS and PUMAs are is found here), suffice it to say that you do need to exercise some caution in viewing it. The margins of error can be quite large and the data should be viewed with some caution. However, it nonetheless provides a very unique opportunity to look at special populations with any of the PUMAs.

As an example of what you might find through PUMS, I've put together the following graphs and graphics concerning single parenting in our region. The graphics are largely based on the 2012 PUMS data and in some cases the 2012 ACS 1 Year data, as noted. Single Parents face a variety of challenges and some of this data provides views of their experiences we may not have been aware of looking at only the ACS data on American FactFinder.



A) The Basics: Family Types, Racial/Hispanic Composition. and the Presence of Children


       1. Family Types

Click to Enlarge

        2. Race and Hispanic Origin

Click to Enlarge

        3. Presence of Children
Click to Enlarge

B) Home Life: Language, Education, Disabilities and Marital Status

       1) Language Spoken At Home

Couples (Click to Enlarge)
Single Moms (Click to Enlarge)
Single Dads (Click to Enlarge)

       2) Attended School in Last 3 Months

Click to Enlarge
        3) Families With Disabilities

Click to Enlarge

       4) Marital Status for Single Moms

Click to Enlarge


C) Employment: Prior Years Work, and Job Sector

       1) Employment in Past 12 Months

Click to Enlarge

       2) Employment Sector

Click to Enlarge

D) Poverty Rates, Presence of Infants, and Accessing Social Services

       1) Poverty for Families, and Families with Young Children

       2) Presence of Infants: Families with a Child Born in Past 12 Months

Click to Enlarge

       3) Accessing Medicaid and Food Stamps

Click to Enlarge

Tuesday, May 13, 2014

2012 Census of Agriculture NOW AVAILABLE !

The 2012 Census of Agriculture is now available and can be accessed through the US Department of Agriculture website. While county profiles are not yet available, you can look at breakouts by county by state, so it's just a matter of going through some of the pages to find Herkimer and Oneida County data.

Below is just a small table of data I pulled out from the 2012 Census of Agriculture and some comparatives form the last time it was done in 2007. Visit the USDA site and find out more about our regions vital farming community.

Click to Enlarge

Monday, May 12, 2014

Medical Procedure Data: Examining Surgical and Procedural Data for Counties In NYS

Have you ever been faced with a medical procedure or operation and wondered about the number of cases similar to yours that have been performed locally? Or who else has had that type procedure, and how they have paid for it? 

Medical data is sometimes difficult to come by. With Health Insurance Portability and Accountability Act (HIPAA) protecting our privacy, data is often closely guarded. However, there is a way to look at classifications of procedures done in your county and get a considerable amount of data about them.The key is using the New York State Health Department's Statewide Planning and Research Cooperative System (SPARCS). 

SPARCS is a comprehensive data reporting system established in 1979 as a result of cooperation between the health care industry and government. Initially created to collect information on discharges from hospitals, SPARCS currently collects patient level detail on patient characteristics, diagnoses and treatments, services, and charges for every hospital discharge, ambulatory surgery patient, and emergency department admission in New York State.

Let’s say, for example, you were facing hip replacement surgery and wondered about the number of cases and the characteristics of patients in Oneida County who have had this type of medical procedure.  By going to the SPARCS homepage, and then accessing the “Health Data Query System” you can begin examining these patients and hip replacement experiences in Oneida County.

After getting to the query page and reading the use policy statement, you then would need to select the type of data base (or “system” you want to look at – in this case, the “Inpatient” system.

 There are then three boxes you need to use to narrow down your search: Inpatient Type of Report (for our purposes select the “Clinical Classification Procedure Category), the Year for which you want data (in this case the most recent year is 2010, so that’s the best choice), and the Area for which you want the data (in our case County). 

 You will then be given the opportunity to specific what you want to see exactly. Under the Clinical Classification Category select “Hip Replacements Total and Partial”, in the Report By box select “Total Patients”, and under County select “Oneida”.

 The result shows that there were 374 hip replacements done in Oneida County last year, with an average length of stay of 4.46 days in the facility. The average cost was roughly $29,500 in each case.
By hitting the back button and selecting Source of Payment instead of Total Patients, you can also find out that roughly 60% of all cases were handled by Medicare, with 16% being covered by personal insurance and another 15% being paid by the patient themselves. 

Click to Enlarge
Obviously going back you can also take a look at the race, sex and ethnic breakdowns of these patients, as well as their ages and their discharge dispositions.

The NYS Health Department also has a system for reviewing Hospital Profiles as well. Visit their New York State Hospital Profiles page to find out more about the facility you might be using.

Friday, May 9, 2014

2010 Oneida County Retrospective: Income and Poverty (Part 2)

Income Measures: Changes in income on the family, household and per capita levels have been considerable over the last 50 years. Income, in all of its various measures, has grown dramatically, increasing by more than 8  times over what it was in 1960. Per capita income, for example, has gone from a level of about $2,000 in 1960 to more than $25,000 in 2010.

Click to Enlarge

Family Income Quintiles: Income growth over the last fifty years wasn’t necessarily uniform among all members of the county.  Looking at changes in the growth of family income by quintile can shed some light onto some of these disparities. Even for the lowest quintile, income growth has been significant since 1960. While the mid-value of the lowest family income quintile was around $2,400 in 1960, by the year 2010 it had risen to nearly $17,000. 

There has been, in fact, substantial income growth for all of the county’s families since 1960. As suggested above, Oneida County families in the lowest quintile have seen their income grow by more than 700% over the last 50 years. In comparison those families comprising the top two quintiles have had income growth of 1100% over the same period. 

Click to Enlarge

Tuesday, May 6, 2014

Happy Older Americans Month !!!

A meeting with the National Council of Senior Citizens resulted in President John F. Kennedy designating May 1963 as Senior Citizens Month, encouraging the nation to pay tribute to older people across the country. In 1980, President Jimmy Carter’s proclamation changed the name to Older Americans Month, a time to celebrate those 65 and older through ceremonies, events and public recognition. 
Below are some factoids from the US Census Bureau, with local data included in parens. To read more statistics about Older American's Month, visit the Census Bureau's Newsroom.

The Numbers   

43.1 million - The number of people who were 65 and older in the United States on July 1, 2012. (38,268 in OC; 11,027 in HC) This group accounted for 13.7 percent of the total population. (16.3% in OC; 17.1% in HC)

92.0 million - Projected population of people 65 and older in 2060. (In 2040, projected to be 47,574 in OC; 14,614 in HC) People in this age group would comprise just over one in five U.S. residents at that time. (21.8% in OC; 27.9% in HC in 2040) Of this number, 18.2 million would be 85 or older. (In 2040, projected to be 8,421 in OC; 3,393 in HC)

Income and Poverty

$33,848 - The 2012 median income of households with householders 65 and older, not significantly different from the previous year. ($33,592 in OC; $28,170 in HC)

9%  - The percent of people 65 and older (3.9 million) who were in poverty in 2012. (9.5% in OC; 10.8% in HC)

Serving Our Nation

9.6 million - Estimated number of people 65 and older who were veterans of the armed forces in 2012. (8,946 in OC; 2,589 in HC) 

Jobs: Older Workforce Members 1990-2012

Click to Enlarge


82.6% - Proportion of people 65 and older in 2013 who had completed high school or higher education. (78% in both OC and HC) 
25.3% - Percentage of the population 65 and older in 2013 who had earned a bachelor’s degree or higher. (16% in OC; 17% in HC)


Marital Status and Living Arrangements

58% - Percentage of people 65 and older who were married in 2013. (49% in both OC and HC)

26% - Percentage of people 65 and older in 2013 who were widowed. (32% in OC; 31% in HC)


53,364 - The number of people age 100 and older counted by the 2010 Census. (58 in OC; 7 in HC)