Friday, February 26, 2016

Regional Businesses Located in Households

Based on Census data from the 2014 ACS, here's a look at businesses that are operated out of residential homes in the two county region. Click on the graphic to enlarge it.

Wednesday, February 24, 2016

Children of Foreign Born Parents (2014)

Recently the Urban Institute released an article on the numbers of children with at least one foreign born parent. Below I've provided similar numbers for the state, as well as Herkimer and Oneida Counties.

Tuesday, February 23, 2016

Regional Changes in Group Quarter Populations: 1970 to 2010

The Census Bureau qualifies where you live as either a housing unit, or as something called a group quarter. Group Quarters (GQ) are places where people live or stay, in a group living arrangement, which is owned or managed by an entity or organization providing housing and/or services for the residents. This is not a typical household-type living arrangement. These services  may  include custodial or medical care as well as other types of assistance, and residency is commonly restricted to those receiving these services. People living in group quarters are usually not related to each other.

For our region, the group quarters population has ebbed and flowed, and in the end, over the last 40 years, it has not actually changed a lot in terms of the total numbers of people living in these facilities. Slightly less than 14,776 people lived in GQs in the Herkimer-Oneida County region in 1970; that's almost the same number as live in GQs today. Click on the chart below to enlarge it.

So while the number of people in GQs seems to not have changed much, that doesn't mean that the characteristics of the group quarters population has remained the same. Group quarters can be classified into two large categories: Institutionalize GQs, and Non-Institutionalized GQs. 

  • Institutionalized GQs include facilities for people under formally authorized, supervised care or custody at the time of interview, such as correctional facilities, nursing facilities/skilled nursing facilities, in-patient hospice facilities, mental (psychiatric) hospitals, group homes for juveniles, and residential treatment centers for juveniles.
  • Non-institutionalized GQs are facilities that are not classified as institutional group quarters, such as college/university housing, group homes intended for adult, residential  treatment facilities for adults, workers’ group living quarters and Job Corps centers, and religious group quarters.

The chart below shows how each of these components of GQs has changed over time. Click to enlarge it.

These two components have seen very different changes over the last 40 years. The light green area represents the Institutionalized GQ population for the region. While it dropped significantly from 1970 to 1980, it then began climbing through the year 2000; in the last decade it then saw another substantial drop. In contrast, the Non-Institutional GQ population, represented by the orange bars, has seen a pretty steady rise since the 1970s in the region.

What might the differences in these changes be attributed to? Further analysis of the GQs populations suggest several things have impacted both components.

In terms of the Institutionalized GQ population, changes in mental health laws in the 1970s resulted in the release of large numbers of mental health patients from institutional care, thus driving down the numbers for Institutional GQs between 1970 and 1980. Subsequent to that there was a large growth in incarcerated persons, and hence the growth between 1980 and 2000 can partly be attributed to rising prison and jail populations. By around 2000, there was also the impact of the "baby boom" generation as people in that generation began to entire a phase of life where institutional care became needed in some cases. Interestingly, by 2010 baby boomers indeed are beginning to be felt in terms of long term care facilities such as nursing homes. At the same time however, New York State has begun reducing its prison population and as a result the region experienced the closure of correctional facilities. This conflicting push-pull (the growth of baby boomer need for facility access, and the reduction of correctional facilities) seems to have resulted in a temporary lull in institutional demand overall in the last decade.

In contrast, the growth of Non-Institutional GQ populations is quite straight forward. Based on census data, college dormitory populations have more than doubled in the last 40 years clearly driving the steady growth of this component. Between 1970 and 2010, college dormitory populations grew by more than 130%. 

Below you can see how nursing home populations have risen  (impacting Institutionalized GQ numbers) and how dormitory populations have grown (impacting Non-Institutionalized GQ numbers).

So while the overall regional GQ population is still very similar to what it was in 1970, its components, and the underlying parts of those components, have changed considerably.

Monday, February 22, 2016

Women Owned Businesses in the Region

Last week I posted about the region's minority owned businesses. Just like those data, data on women owned businesses can also be found in the 2012 Census of Business Owner, and specifically Table SB1200CSA01: Statistics for Firms by Industry, Gender, Ethnicity and Race. Below are just a few tidbits about female owned businesses in the Herkimer Oneida Counties region.

Friday, February 19, 2016

Regional Minority Owned Businesses from the 2012 Survey of Business Owners

The 2012 Census of Business Owners includes data on minority owned businesses. Table SB1200CSA01: Statistics for Firms by Industry, Gender, Ethnicity and Race, provide a plethora of data about these firms, some of which I have tried to capture below. Visit American Fact Finder at the Census Bureau and see what other data exists for these businesses !

The graphics below are based on regional data - meaning the two counties combined.

Thursday, February 18, 2016

Projected Openings in Occupations Within the Mohawk Valley: 2012 to 2022

A while ago I posted on job openings in the Mohawk Valley by occupation through 2020. Note that the "Mohawk Valley" includes Fulton, Herkimer, Montgomery, Oneida, Otsego, and Schoharie Counties combined. The information has been updated an is now available for the period 2012 to 2022.

There are several ways to look at this data. First, and similar to what I did the last time, you might take a look at the actual numbers of jobs being created. Job creation takes into account brand new jobs, as well as hirees selected to replace workers that have left or retired. The chart below shows the top 10 jobs with projected growth from 2012 to 2022 for the Mohawk Valley Region.

As the data shows, the top growth is in Office and Administrative Support jobs. The vast majority of that projected growth involves openings created mostly by current job holders leaving those positions - 770 out of a projected 900 openings.  On the other hand nearly half of the growth in Personal Care and Service jobs come from new job creation (200 out of 410 job openings).

Another way to look at these job openings is by the percentage growth they are projected to have. It's one thing to see a projected increase of 900 jobs, but another if those 900 jobs represent only a small percentage of that particular market sector. So as an alternative way to view these projections, here are the top ten projected openings by their percentages of job sector.

In this case you can now see how the sectors with the largest percentage projected growth is Personal Care and Service (17.6% projected growth), and Healthcare Practitioners and Technical Support (15.6% projected growth).

Lastly, here is a summation of all of the sectors, their job creation projections, and current salary data.


Wednesday, February 17, 2016

Occupational Attractions: Who Marries Whom By Occupation

When it comes to falling in love, it’s not just fate that brings people together—sometimes it’s their jobs. scanned data from the U.S. Census Bureau’s 2014 American Community Survey—which covers 3.5 million households—to find out how people are pairing up by occupation.

Interestingly, here's how Urban Planners seem to match up. Click to Enlarge the graphic. Type your occupation into the space on the page to see how you might match up to your mate, job-wise. 


Tuesday, February 16, 2016

Projected National Job Growth By Occupation (2024)

From the Bureau of Labor Statistics comes projected job growth within various occupations through 2024. The data provides a comparison of 2014 occupational data with the projected changes by the year 2024.

Here are three basic tables found in the Excel spreadsheet download: overall employment by major occupational group; the fastest growing occupations; and the fastest declining occupations. Click each to see them enlarged.




Thursday, February 11, 2016

Trulia Maps Cover Everything from Demographics to Crime to Home Values

Trulia is basically a real estate website but it also has an incredible amount of tools available that would be useful perhaps for grant writing and even program development.These tools can be found for any place/zip code you insert into their search engine. Here's a screen shot below on age demographics for the a census tract in south Utica.  Click on it to enlarge it.


You can basically check out any tract by clicking it. Note that the bar at the top of the map allows you to bring up data on any number of topics and subtopics.

So click on this link to the trulia mapping page and see how your neighborhood or town stacks up !

Wednesday, February 10, 2016

How We Travel to Work: An Interactive Map

A couple days ago I posted about an interactive map from that showed the times we left for work. They also have one on the mode of transportation we used to get to work. Below is a screen shot of Herkimer County's data. Click on it to enlarge it.

Note that the colored boxes near the top of the map break out this modes into vehicle based modes and non-vehicle based modes. By clicking the boxes (on the actual interactive map) you can toggle each mode on or off...or turn them ALL off but one to see how a county compares to the rest of the state.

So visit this mode of transportation to work interactive map and check out the info for your area !


Tuesday, February 9, 2016

Popular Running and Biking Routes Based on App Tracking

The use of apps to track your movements, especially when exercising is exploding with the use of smart phones and body-wearable technology. Below is an example of how that technology can be used to show popular running and biking routes. Strava, a company that provides such an app, creates maps by (1) taking all of the routes reported through their app, then (2) stripping all the personal information from the data, and finally (3) provide the data to DOTs and interested groups to perform detailed analysis and glean insights into the running and biking patterns of it's patrons.

Below is a map of the Valley area (Ilion-Mohawk-Herkimer) showing the running routes popular in the area. Visit the Strava website and see what the biking routes entail, or go to your area to see popular routes!


Monday, February 8, 2016

Interactive Map on Time Leaving for Work

The website offers the an interactive version of the map below which shows when people leave home for work. The rates are for people who have jobs and are 16 years or older. The data does not include people who work from home. Take a look at how the flow changes by varying the time bar at the top of the map!

Here's what Oneida County looks like between 7:30 and 7:59 on any given workday ! Click on the map to enlarge it.


Thursday, February 4, 2016

County Level Health Metrics

The Institute for Health Metrics and Evaluation has provided US County Profiles for every county in the United States. These profiles analyze the performance of all 3,143 US counties or county-equivalents in terms of alcohol use, life expectancy at birth, smoking prevalence, obesity, physical activity, and poverty using novel small area estimation techniques and the most up-to-date county-level information.

Below are summaries of the Herkimer and Oneida Counties data as well as links to their full profiles:

To see the full profiles, click on the county name below:




Overviews of both counties...



Tuesday, February 2, 2016

The Regional Foreign-Born Self-Employed Workforce: 2014

Of the nearly 13,000 employed foreign-born workers in the Herkimer-Oneida Counties region, about 7%, or roughly 900, are self-employed. Below is a breakdown of the top 10 occupations for these foreign-born self-employed workers. You can click the graph to enlarge it.


Because several people have asked about the "Lab Technicians" category, the actual title of the NAICS category is “Medical, Dental, and Ophthalmic Laboratory Technicians”. The definition includes:
  • Dental Laboratory Technicians: Construct and repair full or partial dentures or dental appliances. Excludes "Dental Assistants";
  • Medical Appliance Technicians: Construct, fit, maintain, or repair medical supportive devices, such as braces, orthotics and prosthetic devices, joints, arch supports, and other surgical and medical appliances;
  • Ophthalmic Laboratory Technicians: Cut, grind, and polish eyeglasses, contact lenses, or other precision optical elements. Assemble and mount lenses into frames or process other optical elements. Includes precision lens polishers or grinders, centerer-edgers, and lens mounters. Excludes "Opticians, Dispensing".