Wednesday, February 29, 2012

The Uninsured: Herkimer and Oneida Counties Age Groupings Compared to New York State

One of the advantages of using the American Communities Survey is that it provides data on new topics, such as identifying the number and percentage of persons in the civilian population that lack insurance. Below are several graphs comparing the percent of the population in Herkimer and Oneida Counties that lack insurance coverage with the same population in New York State as a whole.

Tuesday, February 28, 2012

Looking Back - the 2007 Census of Agriculture Data for Herkimer and Oneida Counties

The Census of Agriculture is the leading source of facts and figures about American agriculture. Conducted every five years, the Census provides a detailed picture of U.S. farms and ranches and the people who operate them. It is the only source of uniform, comprehensive agricultural data for every state and county in the United States.

The last Census of Agriculture was conducted in 2007. Below are two pages for both Herkimer and Oneida Counties covering everything from the number of farms, the market value, the government payments, top crops grown and some basic demographics of farm operators. Some comparatives are offered with the 2002 CoA as well.

Herkimer County Agriculture 2007 Summary

Oneida County Agriculture 2007 Summary

Gearing Up for 2012 Census of Agriculture

Surveys are now arriving in mailboxes around the nation to help identify all active farms in the United States. The National Agricultural Classification Survey (NACS), which asks landowners whether or not they are farming and for basic farm information, is one of the most important early steps used to determine who should receive a 2012 Census of Agriculture report form. The Census of Agriculture, conducted every five years by the U.S. Department of Agriculture’s National Agricultural Statistics Service (NASS), is a complete count of U.S. farms and ranches and the people who operate them.

“We are asking everyone who receives the NACS to respond even if they are not farming so that we build the most accurate and comprehensive mailing list to account for all of U.S. agriculture in the Census,” said NASS’s Census and Survey Director, Renee Picanso. “The Census is the leading source of facts about American agriculture and the only source of agricultural statistics that is comparable for each county in the nation. Farm organizations, businesses, government decision-makers, commodity market analysts, news media, researchers and others use Census data to inform their work.”

NACS is required by law as part of the U.S. Census of Agriculture. By this same law, all information reported by individuals is kept confidential. NASS will mail the 2012 Census of Agriculture later this year and data will be collected into early 2013.

“The NACS survey is the first step in getting a complete count, so we ask everyone who receives a survey to complete and return it,” said Picanso. “The Census is a valuable way for producers and rural America to show their strength – in numbers.”

The 2012 Census of Agriculture is your voice, your future, your responsibility. For more information about NACS, the Census of Agriculture, or to add your name to the Census mail list, visit the Census of Agriculture webpage

Monday, February 27, 2012

Life as a Renter in the Two County Region

Based on a survey conducted in Herkimer and Oneida Counties in 2010, the following infographic has been put together showing life as a renter within the two county region.

US Census to Release 1940 Census Records

Every so often i will get a request from someone trying to track down census records for genealogical purposes. Unfortunately, the records they seek are usually not ones that have been released yet by the US government.

Census records can give valuable information about your ancestors and their surnames for people doing genealogy research. The first U.S. Census was in 1790 and there has been one every ten years since then. Census records can provide the names of family members, years of birth, location of birth, profession, and much, much more.

In order to provide some protection for the living, the US Census releases census data only after seventy years has passed since the actual enumeration of the population. This spring, April 2nd, actually, the US Census will release data from the 1940 Census. Older versions of the Census have already been released over the years, and can be found online in many places. Newer censuses, such as from 1950, 1960 or right through the most recent census in 2010, will have to wait until the seventy year protective limit passes before those data sets become available.

In the mean time, information and questions about the 1940 Census and its release can be found at the National Archives website.

For a comprehensive look at ALL US Census questionnaires you might want to visit the US Census Index of Questions page.

Friday, February 24, 2012

NYS Liquor Authority Mapping Project

The New York State Liquor Authority has engaged in a mapping project to search, visualize and analyze liquor licensing across the state. By going to the NYS Liquor Authority website you can reach an interactive map which shows you the locations of establishments with licenses, as well as the types of license and any violations of those establishments.

If you go to the website, click on the "layers" button to select the types of licenses you'd like to see. You can also bring up school and church locations, as well as such things as police precincts.

Two words of caution about the website features. First, allow the site to load properly - it does take some time. Second, the site also allows you to see demographic data about the county in which the establish is located. THIS DATA IS FROM THE CENSUS 2000, NOT THE 2010 CENSUS.

Thursday, February 23, 2012

Regional Housing Unit Counts

Knowing the number of housing units in each county, and in each municipality, helps local policy makers plan for future development and marketing. Below are two simple tables with data for both Herkimer and Oneida Counties and their constituent municipalities from the 2010 Census.

Wednesday, February 22, 2012

How The Census Bureau Gets Your Address

So how is it that the Census Bureau is able to survey each and every housing unit in the United States, anyways ? Well it all comes down to something called the Master Address File, or MAF for short.

Literally the MAF is a HUGE file full of every address that is, or ever has been, reported to the Census Bureau. The MAF in its current format was originally create for the Census 2000. It basically grew out of the 1990 Address Control File combined with the U.S. Postal Service’s Delivery Sequence File (DSF). This is constantly updated for use in conducting the decennial census, along with a host of other Census Bureau surveys, like the American Communities Survey for example.

There are nearly 279 million addresses in the MAF for the U.S. These are updated twice a year, mainly through the US Postal Service DSF. Interestingly, if an address get's demolished or changed, while it may disappear from the active MAF, it actually isn't deleted. It still is listed as an address that had existed. So even though the address has been corrected (due to a demolition or, say, due to an incorrectly provided address in the past), the old address - good, bad, or indifferent - remains in the records. this allows the Bureau to have a full and complete history of addresses from an area.

Tuesday, February 21, 2012

Regional Rental Properties: Private Complexes' Costs and Amenities

Based on a survey conducted in Herkimer and Oneida Counties in 2010, the following infographic has been put together showing some of the costs, and the amenities that come with those costs, at apartment complexes within the two county region.

Friday, February 17, 2012

Herkimer County ACS Basic Demographics (2008-2010 Three Year Estimate)

Earlier I posted the 2010 One Year Estimate for basic demographics from the American Communities Survey for Oneida County. In addition to these 1 Year Estimates, there are 3 year and 5 year estimates put out by the Bureau for Oneida County too.

Because Herkimer County has a population of less than 65,000 people, the Census Bureau doesn't provide any 1 Year ACS data updates. Instead, Herkimer County only has the 3 Year or 5 Year estimates available.

Below are the Three Year ACS Estimates (2008-2010)for basic demographic data for Herkimer County. Housing data and Social data that can be found at the US Census Bureau website.

Thursday, February 16, 2012

Oneida County 2010 ACS Basic Demographic Data

Below is the 2010 One Year Estimate for basic Demographics from the American Communities Survey for Oneida County. Each year, three different data sets are released for municipal entities in excess of 65,000 population - the One, Three and Five Year Estimates from the ACS. This happens to be the One Year Estimate for Demographic Characteristics for the County. There are also sets of data for Economic data, Housing data and Social data that can be found at the US Census Bureau website.

Wednesday, February 15, 2012

Religious Adherents By County

One of the only sites I am aware of that provides any sort of data on the number and types of religious adherents by county is at The Association of Religious Data Archives. The Association of Religion Data Archives (ARDA) strives to democratize access to the best data on religion. Founded as the American Religion Data Archive in 1997 and going online in 1998, the initial archive was targeted at researchers interested in American religion. The targeted audience and the data collection have both greatly expanded since 1998, now including American and international collections and developing features for educators, journalists, religious congregations, and researchers. Data included in the ARDA are submitted by the foremost religion scholars and research centers in the world.

The biggest issue with the ARDA at the moment is that their data is a decade old. While still great information, there is a need to see updated information on religiosity. Fortunately the ARDA does have plans, hopefully this Spring, to release new data on religious affiliations.

In the mean time here are links to Oneida County and Herkimer County 2000 religious data.

Center of the Universe...or Maybe Just Oneida County

Ever wonder where the center of the county is, based on population? If you picture the county as a large flat stiff piece of paper and you were trying to balance it based on the distribution of its population by resting it on the tip of a pencil, let's say, that pencil tip would have to be placed under the county somewhere in the vicinity of the corner of Cider Street and Judd Road.

As seen on the link below, between 1990 and 2000, the population center point moved somewhat westerly. However, by the year 2010 the center of the county (based on population distribution) had shifted ever so slightly back toward the east. Click on the image to see a slightly larger version of it.

Historical Herkimer and Oneida County Municipal Population Counts, 1980 to 2010

Herkimer County

Oneida County

Summary File 2 Data To Be Released Soon by Census Bureau

The US Census in in the process of releasing Summary File 2 (SF2) data. This file provides detailed demographic information from the 2010 Census for up to 331 detailed race and ethnic groups down to the census tract level, adding a new layer of detail to the population and housing topics previously released from the census. The statistics are being released on a state-by-state flow basis. When exactly New York (and subsequently Herkimer and Oneida County) data will be released is not exactly known yet.

More information on the SF2 files, including a list of the sub-populations about which data will be released, can be found HERE

Tuesday, February 14, 2012

BLS Shows Increase in Wages in Oneida County

The Bureau of Labor Statistics recently released data that shows that among counties with at least 75,000 workers in New York State, Oneida County ranks second in terms of wages increases. The report looked at wages changes between the 2nd quarters of 2010 and 2011. In that time the county's average weekly wage increased 4.0%, second only to Rockland County's 4.5% increase.

On the surface this would appear to be great news. However a few other factors need to also be looked at. First off, the report also notes that, among NYS 17 largest counties, Oneida County also had the largest decline in workforce over that same period of time (2nd quarter 2010 to 2nd quarter 2011).

So what does this mean when you have a declining workforce by an increase in average wages? Well one interpretation, according to the Department of Labor, is that it MAY mean that the jobs lost are those in the lower paying positions. The elimination of lower wage positions has the dual impact of lowering the over all number of people working, plus pumping up the average wage of the people who continue to be employed overall. As an example, let's look at manufacturing numbers over the time frame of the report.

Between the second quarter of 2010 and the second quarter of 2011, about 265 manufacturing jobs were lost in Oneida County according to DOL statistics. this is a decline of about 3% in that sector. The average weekly wage for the second quarter in 2011 was actually more than $1,100 higher than the average weekly wage a year prior. This represents an increase of almost $10.5% between the two quarters.

Does this mean that the actual wages increased or is it reflective of just a fewer number of workers who generally make more money being counted as part of the study period?

It appears to be a little of both ! First of all, the total amount of money paid out in wages actually did increase between the second quarter of 2010 and that of 2011. It went from about $95M to almost $102M, an increase of about 7%. So actual wages did increase. At the same time, the average wages showed an increase of more than this 7%, as noted above the average increased by about 10.5%. This would suggest that mathematically the loss of lower wage positions is also coming into play here.

So in the end, while the report from the BLS suggest that we are seeing improvement in local wages, it doesn't necessarily tell the whole story. For that you need to look deeper into the data !

Here's the news release !

Here's the news release !

Workers Report Best Hiring States in US for 2011

Gallup asked U.S. workers whether their employer is hiring workers and increasing the size of its workforce or letting workers go and reducing the size of its workforce. A Job Creation Index was then computed by taking the difference between the two percentages. Gallup interviewed nearly 200,000 workers in 2011, including at least 500 in every state. Full data for each state are below, and the full story can be found on their website at:

Monday, February 13, 2012

The Geography of Government Benefits

The share of Americans’ income that comes from government benefit programs, like Medicare, Medicaid and Social Security, more than doubled over the last four decades, rising from 8 percent in 1969 to 18 percent in 2009. This interactive page from the New York Times allows you to see (by county) the amount of various transfer payment income to areas over time.

Transfer payments are non-compensatory government payment to individuals, such as for welfare or social security benefits. It also includes things like veterans benefits, Medicare and Medicaid, disability payments and earned income credits.

To see the interactive page, CLICK HERE

The interactive map lets you point to a county and see what the present per capita payment is as well as look at the historical trends over the last several decades. The source data is the BEA (Bureau of Economic Analysis).

The Economics of Valentine's Day

Ever wonder about how much of an economic impact Valentines Day has on your purse or wallet, let alone the country ?

The Economics of Valentines Day

Racial And Ethnic Distributions In America

At Mapping America (available through the New York Times) you can find out where in the United States have more immigrants been settling in recent years.  You can browse the distribution of racial and ethnic groups from the Census Bureau's 5 Year American Community Survey (2005-2009). Because these figures are based on samples, they are subject to a margin of error, particularly in places with a low population, and are best regarded as estimates.

Racial and Ethnic Distributions

By clicking "View More Maps" you can also look at things like education and income distribution for any area of the country.

Friday, February 10, 2012

Herkimer County Census Tract Maps

As with the Oneida County Census tract maps below, these are the 2010 Census maps for Herkimer County. Census tracts are small, relatively permanent statistical subdivisions of a county. Census tracts usually have between 1,200 and 8,000 persons and 480 to 1,600 households.

Knowing where these tracts are helps policymakers, business leaders and the public plan for our future. Below are two maps, one for Herkimer County as a whole, and then a separate map for the swath across the valley, showing the tract level geography that will be in place for the next 10 years.