PaSDCPennsylvania State Data Center

 

Information about our staff, employment opportunities and our feedback form

PA STATS

Links to our catalog and order forms

The PaSDC Monthly Update

Products & Services

Our Partners

Search

eStore

 


Getting Started


Sources of Data

I. The Census
and
the
American
Community
Survey


II. Census Data
by School and Legislative Districts


III. Population Estimates and Projections

IV. Industry and Workforce

V. Housing
and New
Construction


VI. Transportation

VII. Other Helpful Links




 

 

 

 

 

 

 

Complete list of data links/URLs

 

 

 

Getting Started

If you're new to economic development or want to better understand your local economy, there are a number of websites that can help you develop a plan for analyzing the resources in your community. The underlined links in the paragraphs below will take you to some of these sites and to sources of data that will be useful in your analysis. Links to tutorials of how to extract the data have also been added for some sites.

The Penn State Center for Economic and Community Development has created a series of brief downloadable publications that provide an introduction to using employment data to better understand your local economy. These include explanations of tools and concepts like shift-share analysis, the location quotient, and qualitative analysis of local economic performance. The site also includes a link to a community economic development toolbox. Penn State also hosts a slightly different Community Economic Development Toolbox that allows users to conduct a screen-by-screen analysis of their county, using the tools covered in the Using Employment Data to Better Understand Your Local Economy series. Files and graphic representations of data are downloadable from each screen. Includes links to other helpful resources like the Poverty in America website and Living Wage Calculator.

Another excellent resource is the University of Wisconsin Cooperative Extension Center for Community Economic Development. They have created a step-by-step site for using market data to identify economic opportunities in small cities. Begin with the overview and be sure to visit the market analysis data links and data sources pages.

Community Economic Analysis: A How to Manual is similar to the Penn State series of publications but provides a more exhaustive overview of analysis techniques including easy-to-follow case examples. Produced with funding from the North Central Regional Center for Rural Development and the University of Wisconsin-Extension.

USA Counties in Profile is a website hosted by the Indiana Business Research Center and can get you off and running quickly with developing a snapshot of your economy. The site provides many of the most recent population, housing, income, and various labor and industry statistics at the state and county levels, including data rankings of the area in the state or nation.

Data Place is a one-stop source for housing and demographic data about your community, your region, and the nation. The site not only assembles a variety of data sets from multiple sources, but it also provides tools and guides to assist you in analyzing, interpreting, and applying the data so you can make more informed decisions. Data can be retrieved through charts and tables, area profiles, and a mapping tool. DataPlace is a KnowledgePlex® initiative sponsored by the Fannie Mae Foundation. KnowledgePlex® is an online resource serving affordable housing and community development professionals.

Community Economic Development HotReport provides quick access to information tailored to economic development decision-making.  Topics provided in these reports include the economy, transportation, housing, schools, and more.  The top industries and occupations as well as wages for an area can be retrieved in a click or two.  Information comes from a variety of sources including the Department of Labor’s Quarterly Census of Employment and Wages and State Occupational Projections; the Department of Educations Common Core of Data and Integrated Postsecondary Education Data System; and from the Census Bureau’s Local Employment Dynamics (LED), Census 2000, American Community Survey, Population Estimates, and County Business Patterns.

The U.S. Department of Labor Employment and Training Administration's America's Labor Market Information Services website offers links to a number of workforce investment related resources, including "An Environment Scan: Workforce Information Sources to Assist Employment, Economic Development, Education, and Workforce Investment Planning and Decision Making." This report identifies widely consulted sources and types of labor market and workforce and information available from public, private, and research institution providers. The report also identifies and array of internet-based information delivery systems to illustrate examples of improved and innovative access to workforce information.

The Pennsylvania State System of Higher Education (PASSHE) also has links economic development resources on their website. Here you will find examples of economic development activities at state universities, links to their programs and other resources outside PASSHE.

The Economic Development Research and Training Center (EDRTC), one of the Pennsylvania State Data Center's partners in the Institute of State and Regional Affairs at Penn State Harrisburg, offers the Basic Economic Development Course in Pennsylvania every year. The six-day course is designed to serve the needs of full-time economic development practitioners and those involved in economic development in a secondary way. The course draws participants from across the eastern states whose backgrounds range from the seasoned professional to the beginning practitioner. Participants learn theoretical and practical approaches to economic development and immediately apply this information to a case study. The course is accredited by PEDA, PPA, the PCLECL, or may be taken for graduate credit. The EDRTC also has links to other economic development websites and will undertake economic impact analyses and other research projects requested.

Sources of Data

I. The Census and the American Community Survey         

The Census Bureau is the nation's most comprehensive source for demographic data. For census 2000, population by age, sex, race, and Hispanic origin, household relationships, housing units, and tenure can mostly be obtained down to the block level (avg. size 100 ppl.) while socio-economic date, i.e. income, educational attainment, disability, etc. can often be obtained by block group (optimal size 1,500 ppl.). Much of that data is now available online through American FactFinder. Here you can access data from the 1990 and 2000 censuses, the 2000-2005 American Community Survey (ACS), 2000-2005 selected population estimates, the 2002 Economic Census, and various other economic surveys. The 2005 ACS is available for areas with populations of 65,000 or greater. This is the first opportunity for many communities to examine how their populations have changed since Census 2000. The 2005 dataset is scheduled to be released in waves beginning August 15 and will be complete by the end of 2006. ACS is in the midst of a phased rollout that will cover all geographic areas by 2010. It will replace the census long form and provide annual socioeconomic data permitting multi-year trend analysis. Without the ACS, this type of information — historically gathered just once a decade — would not be available for communities until 2012.
For a tutorial of how to use American Factfinder to extract census data, click here.

To query and map data within a designated radius using latitude and longitude coordinates, the Census Bureau has developed Landview, a DVD product that can be purchased. The website of the Missouri Census Data Center has a Circular Area Profile application, which lets the user specify a site (point location using lat/long coordinates or by entering a ZIP code) anywhere in the U.S. and retrieves small-area data (census block group or MCD/county subdivision level) that is located within the specified circular areas and aggregates them to create (approximate) circular area summaries. The primary output is a summary report with the demographic characteristics of the circular area(s). The report is, by default, in the standard format of the MCDC's dp3_2k demographic profile reports.

Limited historical census data is available from the Census Bureau at this site, through past editions of the United States Statistical Abstract, and through the University of Virginia Geospatial and Statistical Data Center Historical Census Browser. The UVA browser accesses selected county census data for 1790-1960. Much historical census data is still in paper form, however.

II. Census Data by School and State Legislative Districts

The National Center for Education Statistics (NCES) hosts a School District Demographics System that enables users to directly access 1990 and 2000 school district geographic and demographic data. The site includes a map viewer and three options for querying and downloading data in tabular form. Additional links at the top of the page like "tables and figures," "school, college, and library search," and "annual reports" provide access to other data. There currently is no special tabulation available for state legislative districts for census 2000. Contact the Pennsylvania State Data Center (PaSDC) to request data for this geography. A number of other special tabulations are also available on the Bureau website or for purchase for subject areas like migration, the foreign born population, housing affordability, etc.

III. Population Estimates and Projections

Population estimates are currrently available for the states, counties, and municipalities through July 1, 2005 from the Census Bureau Population Estimates homepage. Limited estimates data can also be accessed through American Factfinder, and the PaSDC produces detailed estimate books for the state, counties, and municipalities. The Census Bureau has produced projections by single year of age and sex for the state through 2030. There are currently no county projections based on census 2000, the PaSDC expects to complete these by the summer of 2007. Check with your local planning agencies, they may produce their own county or municipal projections. Formatted estimate and projections tables can also be downloaded from the PA STATS section of the PaSDC website, and the Missouri Census Data Center has a new dynamic web application that lets you generate custom extracts of state and county level population estimates for either pre-defined or user-specified age intervals. The data used in this application are the special "bridged" race estimates from the National Center for Health Statistics (and the Census Bureau) with breakdowns by single years of age, race (just the 4 special bridged categories), hispanic origin and sex. You can choose your geography (by state and level), your time periods (1990 to 2005), your own custom age groupings (under 11, over 27, 18 to 64, etc.), and demographic items of interest (race, hispanic and gender detail).

IV. Industry and Workforce

Location Quotient and Shift-Share Analysis are important tools for analyzing industry and workforce data. Several sites now make it easy to perform these calculations. The U.S. Department of Labor Bureau of Labor Statistics has an online location quotient calculator that calculates the location quotient for up to 3 geographies at a time (state, county, and metropolitan statistical area) down to the 6-digit NAICS industry subsector, for the years 2001-2005. The BLS calculator uses Quarterly Census of Employment and Wages (QCEW) data. The University of Georgia hosts a shift-share analysis website the provides the 3-step calculation for 2 digit NAICS sectors by county and state going back to 1990 using QCEW data.

Economic Census Data, which includes the number of establishments classified by NAICS codes, number of employees, revenue, and payroll, can be obtained either through American Factfinder or from the Economic Census homepage using drill down tables. If you're looking for historical comparisons, much of the 1997 and 1992 data can only be accessed through the Economic Census homepage, but be aware of comparability issues. The statistics issued by industry in the 2002 Economic Census are classified primarily on the 2002 North American Industry Classification System (NAICS), and, to a lesser extent, on the 1997 NAICS used in the previous census. NAICS replaced the Standard Industrial Classification (SIC) system in use up to 1997. NAICS categorizes establishments by the principal activity in which they are engaged. Most of this data is available for the state, counties, metropolitan statistical areas, and many minor civil divisions classified as economic places. For a tutorial of how to extract Economic Census data in American Factfinder, click here.

The Survey of Business Owners (SBO), formerly known as the Surveys of Minority- and Women-Owned Business Enterprises (SMOBE/SWOBE), is part of the Economic Census and provides statistics that describe the composition of U.S. businesses by gender, Hispanic or Latino origin, and race. Additional statistics include owner's age, education level, veteran status, and primary function in the business; family- and home-based businesses; types of customers and workers; and sources of financing for expansion, capital improvements, or start-up. SBO data can be accessed in the economic census dataset page of American Factfinder using the search for datasets link under detailed statistics. Like other economic census data, the SBO is available for the state, counties, metropolitan statistical areas, and many minor civil divisions classified as economic places (if not withheld for confidentiality).

County (and Zip Code) Business Patterns is an annual series that provides subnational economic data by industry. The series is useful for studying the economic activity of small areas; analyzing economic changes over time; and as a benchmark for statistical series, surveys, and databases between economic censuses. Businesses use the data for analyzing market potential, measuring the effectiveness of sales and advertising programs, setting sales quotas, and developing budgets. Government agencies use the data for administration and planning. County Business Patterns covers most of the country’s economic activity. The series excludes data on self-employed individuals, employees of private households, railroad employees, agricultural production employees, and most government employees. The County Business Patterns program has tabulated on a North American Industry Classification System (NAICS) basis since 1998. Data for 1997 and earlier years are based on the Standard Industrial Classification (SIC) System. 2003 and 2004 CBP data can now be accessed using American Factfinder.

Nonemployer Statistics summarizes the number of establishments and sales or receipts of businesses without paid employees that are subject to federal income tax for the state, counties, metropolitan statistical areas, and combined statistical areas. Most nonemployers are self-employed individuals operating very small unincorporated businesses, which may or may not be the owner’s principal source of income. 2003 and 2004 Nonemployer statistics can now be accessed using American Factfinder.

The PaSDC produces the Pennsylvania County Industry Trends and Industry Clusters reports annually in conjunction with PENNTAP and the Team Pennsylvania Foundation. The reports contain information on business establishments and average monthly employment for the state and counties and by workforce investment area and industry clusters (cluster report only) from the second quarter of the most recent years. The data, provided by Pennsylvania Department of Labor and Industry, is compiled from second quarter unemployment tax reports filed by employers. The data in the report only applies to employers covered under Pennsylvania's Unemployment Compensation Law.

The Longitudinal Employer-Household Dynamics Program (LEHD) combines federal and state administrative data on employers and employees with core Census Bureau censuses and surveys to develop new information about local labor market conditions. The main features of this site are Quarterly Workforce Indicators (QWI), a set of economic indicators -- including employment, job creation, wages, and worker turnover -- that can be queried by different levels of geography -- state, county, metro, and workforce investment area -- as well as by detailed industry, gender, and age of workers; Industy Focus -- rankings of industries by economic indicators; and On the Map, an interactive mapping application that shows in high definition where people live and where they work. Most of this data is available for the state, counties, metropolitan statistical areas, and workforce investment areas. For a tutorial of how to use these features, click these links: QWI, Industry Focus, On the Map

The Pennsylvania Department of Labor and Industry Center for Workforce Information and Analysis provides access to data relating to industry, labor force, employment, income and wages, occupation, economic indicators and more. The data on this site is drawn from a variety of sources, including the Census Bureau, the Bureau of Economic Analysis, and the Bureau of Labor Statistics. Much of the data can be found under the PA Work Stats link, including profiles for the state, counties, metropolitan statistical areas (MSA), and some workforce investment areas (WIA). You should also be familiar with the products section of the site, which includes links to employment projections (state), industry forecasts (state, MSA, WIA), and a monthly civilian labor force (unemployment) report that has selected minor civil division data.

Much of the data on the U.S. Department of Labor, Bureau of Labor Statistics website can be obtained from the Center for Workforce Information and Analysis (CWIA), but this site allows users to select some geographies and historical data that cannot be accessed through CWIA (i.e., LAUS data for municipalites with a population of 25,000 or more). Valuable data on this site includes Current Employment Statistics (CES) , Local Area Unemployment Statistics (LAUS), and the Quarterly Census of Employment and Wages (QCEW). You can also find the most recent Consumer Price Index and the Consumer Expediture Survey (CE), which consists of two surveys collected for the Bureau of Labor Statistics by the Census Bureau — the quarterly Interview survey and the Diary survey — that provide information on the buying habits of American consumers, including data on their expenditures, income, and consumer unit (families and single consumers) characteristics. The PaSDC maintains a membership with C2ER, a source of additional PA metro area cost of living index data that cannot be found on the BLS site.

The U.S. Department of Commerce, Bureau of Economic Analysis website provides access to state, county and MSA personal income, wage and employment by industry data, some of which can also be obtained through the CWIA website. Much of this is available in summary form for counties and Metropolitan Statistical Areas through the BEA regional facts, or BEARFACTS.

The University of Wisconsin-Milwaukee Employment and Training Institute has prepared easy-to-use, free downloads of Census data on workers residing in and employed in each U.S. Census tract, along with state-of-the-art purchasing power estimates of consumer expenditures and retail sales leakage/surplus by neighborhood. The drill downs can be used to determine the diversity of the workforce and to further economic development for underserved communities and for underutilized minority populations. For a tutorial of how to use this site, click here.

The Census Bureau entered into a reimbursable agreement with a consortium of four Federal agencies, consisting of the Equal Employment Opportunity Commission (EEOC), the Department of Justice (DOJ), the Department of Labor (DOL), and the Office of Personnel Management (OPM), to create a special tabulation identified as the Census 2000 Special Equal Employment Opportunity (EEO) Tabulation. This Tabulation was created according to the specifications of the agencies in the consortium. However, it contains information similar to comparable tabulations from the 1970, 1980, and 1990 censuses. The Census 2000 Special EEO Tabulation serves as the primary external benchmark for comparing the race, ethnicity, and sex composition of an organization's internal workforce, and the analogous external labor market, within a specified geography and job category.

V. Housing and New Construction

Annual state and county housing unit estimates
are available on the Census Bureau website.

Building Permit data is available from the Census Bureau and the State of the Cities Data Systems (SOCDS) Building Permits Database for states, counties, and places monthly and annually going back to 1996. The SCODS site appears to have more updated data but both sites rely on the same county and local reporting systems, so contact your municipality if you think there are discrepancies or missing data. Quarterly housing starts, completions, and new residential sales are only available for the U.S. and regions on the Bureau website.

Worker Housing Affordability: National Low Income Housing Coalition (NHLIC) Out of Reach 2006. Out of Reach is a side-by-side comparison of wages and rents in every county, Metropolitan Area (MSAs/HMFAs), combined nonmetropolitan area and state in the United States. For each jurisdiction, the report calculates the amount of money a household must earn in order to afford a rental unit at a range of sizes (0, 1, 2, 3, and 4 bedrooms) at the area's Fair Market Rent (FMR), based on the generally accepted affordability standard of paying no more than 30% of income for housing costs. From these calculations the hourly wage a worker must earn to afford the FMR for a two-bedroom home is derived. This figure is the Housing Wage.

Comprehensive Housing Affordability Strategy (CHAS) data are used by HOME and CDBG jurisdictions to prepare their consolidated plans. 2000 special tabulation data showing housing problems and the availability of affordable housing are available through this site for states, counties, places, and CDBG/HOME jurisdictions. For comparision purposes, 1990 data for old CHAS table 1C are also available via this site.

Census 2000 Low and Moderate Income Summary data: Important for Community Block Grants. The Community Block Grant Development program requires that each CDBG-funded activity must either principally benefit low and moderate income persons, aid in the prevention or elimination of slums or blight, or meet a community development need having a particular urgency because existing conditions pose a serious and immediate threat to the health or welfare of the community and other financial resources are not available to meet that need. With respect to activities that principally benefit low- and moderate-income persons, at least 51 percent of the activity's beneficiaries must be low and moderate income. Estimates have been prepared at the Census Bureau's Geographic Summary Level "090": State-County-County Subdivision-Place/Remainder-Census Tract-Urban/Rural-Block Group. Links to various tables can be found on the right of the page under "related information." Table downloads are at the bottom of the pages.

HUD Special Tabulations of Households by Income, Tenure, Age of Householder, and Conditions : 1990 & 2000: The Economic and Market Analysis Division (EMAD) "Special Tabulations" data retrieval system produces tabular statistical summaries of counts of households by tenure, by income intervals, by age of householder, by size of household, by housing conditions based on the 1990 and 2000 Census, for select geographic areas in the United States, including the state, counties, and 9 Pennsylvania cities. This system allows a user to extract data to conduct a longitudinal analysis of changes in a particular area.

VI. Transportation

County to county and residence minor civil division to county workplace/residence county to MCD workplace worker flow files were prepared as a special tabulation for census 2000 and are available on the Bureau website. Journey to work data by county going back to 1970 can also accessed from the Bureau of Economic Analysis website.

Census Transportation Planning Package is a comprehensive source of data on commuters and commuting patterns for transportation planning, and is available on disk (free of charge) from the PaSDC. The tabulation was sponsored by state departments of transportation under a pooled funding arrangement with the American Association of State Highway and Transportation Officials (AASHTO). The package includes: 1) CTPP Place of Residence Profiles. Selected long-form data (vehicles available, travel time to work, household income, etc.) from Summary File 3, with two new tables: the first is household size by vehicle availability, and the second is travel time by mode to work. 2) CTPP Part 1: Detailed Residence Tabulations. Consists of 120 tables on commuters and commuting by place of residence. 3) CTPP Part 2. Detailed Workplace Tabulations. Consists of 66 tables -- only product to show characteristics of workers by place of employment. 4) CTPP Part 3: Commuter Flow Tables. Consists of 14 tables on commuter flows. Parts 2 and 3 are available for states, counties, metropolitan areas, places of 2,500 or more, traffic analysis zones, metropolitan planning organization regions, census tracts.

VII. Other Helpful Links

The Pennsylvania State Data Center is the Commonwealth's Official Source for Population and Socioeconomic data and liaison with the Census Bureau. Services include custom demographic profiles, data extraction and reporting, mapping, publications, trainings, and more. A variety of data is archived on the PaSDC website under the PA Stats, Map of the Month, and Research Briefs sections of the website.

The Pennsylvania Department of Community and Economic Development has a number of useful links, including a funding and program finder and resources provided by the Governor's center for local government services, including county and minor civil division demographic data, local government contacts, taxes and revenue data, and more.

The Team Pennsylvania Foundation provides a number of businss and workforce support services, including links to business assistance programs, Pennsylvania career link, and a business property and site selection search engine.

The O*NET program is the nation's primary source of occupational information. Central to the project is the O*NET database, containing information on hundreds of standardized and occupation-specific descriptors. The database is continually updated by surveying a broad range of workers from each occupation.

Thomas Register Online. Thomas Register is the most comprehensive online resource for finding companies and products manufactured in North America.

The U.S. Department of Agriculture National Agriculture Statistics Service provides online access to recent crop, farm, and census of agriculture data, including number of farms, acres farmed, crop, production, & sales values, etc.

State of the Cities Data Systems: The SOCDS provides data for individual Metropolitan Areas, Central Cities, and Suburbs, including data from the 1970-2000 censuses, employment statistics, county business patterns (Philadelphia and Pittsburgh only), FBI crime data, building permits, urban public finance data, and Comprehensive Housing Affordability Strategy (CHAS) data.

©2006 Pennsylvania State Data Center

 

 

 

 

 

 

 

 

Product Catalog PaSDC Brochure Product Announcement eStore

777 West Harrisburg PikeMiddletown, PA 17057-4898
E-mail: PaSDC@psu.eduVoice: (717) 948-6336FAX: (717) 948-6754

Comments: PaSDC-Webmaster@psu.edu