Data Analysis Tools
Last Updated on Wednesday, June 25 2014 14:14
The NKY by the Numbers Data Collection
Northern Kentucky (NKY) is a geographical area that is not outlined on any map and does not have an official definition. Residents and those conducting business in Northern Kentucky use a variety of definitions to define the geography of NKY. Unless otherwise noted, on this site NKY is defined to include the seven (7) Kentucky counties included in the Cincinnati Metropolitan Statistical Area as defined by the U.S. Office of Management and Budget which include Boone, Bracken, Campbell, Gallatin, Grant, Kenton and Pendleton counties.
The American Community Survey from the U.S. Census Bureau is considered the replacement for the census "long form." The ACS happens every year with resulting 1-year, 3-year and 5-year estimates for geographies that meet certain population thresholds.
The CEAD has developed a quick and easy, Excel-based look up tool to access these data for geographies in Kentucky and Ohio. (Note: These are large files, 8+MB, and can take awhile to open. Microsoft Excel is needed to run these files. These files are not intended for use with any Mac OS product.)
The Occupational Employment Statistics (OES) program of the U.S. Bureau of Labor Statistics produces employment and wage estimates for over 800 occupations. These are estimates of the number of people employed in certain occupations, and estimates of the wages paid to them. Self-employed persons are not included in the estimates.
The CEAD has developed a quick and easy, Excel-based look up tool to access these data for the Cincinnati MSA. (Note: Microsoft Excel is needed to run these files.These files are not intended for use with any Mac OS product.)
- Moves and Migration (American Community Survey 2005-2009)
The U.S. Census Bureau provides estimates from the American Community Survey showing how many people migrated from one county to another during the course of a year - the first such numbers published since these data were collected as part of the 2000 Census.
The American Community Survey compiles data over a five-year period and asks people where they lived one year prior to being surveyed. The first five-year estimates released covers the years from 2005 to 2009.
The 2005-2009 American Community Survey County-to-County Migration Files provide tables for each county in the nation, showing both "inflows" and "outflows." Inflows are the number of people living in a given county who lived in another specific county one year earlier; outflows represent the number of people who lived in a particular county one year earlier who subsequently moved to another specific county.
Prior to this product, the only migration flow tables available from the American Community Survey covered state-to-state flows; the latest such release, from the 2010 one-year estimates, was published in November 2011. Later this year, the U.S. Census Bureau plans to release a file from the 2006-2010 American Community Survey five-year estimates showing county-to-county flows by demographic characteristics, such as age, sex, and race and Hispanic origin.
While total population change can provide valuable insights into the overall growth of a region, a more granular look can provide a greater understanding of where people are moving to and where they are coming from. CEAD's moves and migration tool allows the user to select one of the 15 metropolitan area counties in either Kentucky, Ohio, or Indiana and query on average from 2006-2010 how many people moved from or to the area, how many people moved within the area, and the county locations of those who moved to or from the area.
Commuter-adjusted populations are based on data from the 2006-2010 5-Year American Community Survey. Commuter-adjusted populations are useful for regional planners to assess the impact of population inflows and outflows of a region during a typical workday. These estimates can be instrumental in emergency planning, road construction planning, and public services. The CEAD has developed an Excel-based lookup tool for users to query this information. (Note: Microsoft Excel is needed to run these files.These files are not intended for use with any Mac OS product.)