|
School District Economic Data Analytics -- ACS 2017 Employment, Industry, Occupation, Income, Insurance, Poverty, more
January 2019. Based on ACS 2017 estimates, the U.S. median household income was $57,652 while states ranged from $11,393 (Sacaton Elelemntary School District, AZ -- among districts having 1,000 or more population) to $250,000 (Scarsdale UFSD, NY). See item/column E062 in the interactive table below to view, rank, compare, analyze states based on this measure in context of related economic characteristics. These data uniquely provide insights into many of the most important economic characteristics for all school districts in the U.S. See about how to view/rank/compare districts below in this section. Create comparative analysis profiles for districts of interest. Approximately 600 subject matter items from the American Community Survey ACS 2017 database (released December 2018) are included in these sections: General Demographics Social Characteristics Economic Characteristics -- this section Housing Characteristics Visual Analysis of Patterns of Economic Prosperity by School District The following map shows patterns of median household income ($MHI) by school district in the San Antonio, TX MSA (bold brown boundary) area based on the ACS 2017 5-year estimates. Create a similar map for any area in the U.S. and/or variations of this view using the associated GIS project with the CV XE GIS software. Add your own data. - larger view showing San Antonio city (cross-hatch pattern) - view developed with CV XE GIS software .. click graphic for larger view. Additional views: (opens in new page) Wichita, KS MSA area Analytzing the School & School District Community ProximityOne works with schools, school districts and K-12 education stakeholders to develop, integrate and analyze demographic-economic data for planning, evaluation and policy analysis. Use our custom estimates and projections to better understand trends, what might change when and where -- and how it might impact you. Using the Interactive Table Use the interactive table below to view, query, rank, compare economic characteristics for these areas. The scroll box shown below lists each of the subject matter items available for each area via the ranking table. In the subject matter items scrollbox, subject matter items are organized into to mini-tables with related items. The number at the left of the subject matter item is also used as the short name for the subject matter item in the column header in the ranking table. Economic Characteristics Items .. a few item names and numbers changed from previous year data/table.
EMPLOYMENT STATUS
E001 Population 16 years and over E002 In labor force E003 Civilian labor force E004 Employed E005 Unemployed E006 Armed Forces E007 Not in labor force E008 Civilian labor force E009 Unemployment Rate E010 Females 16 years and over E011 In labor force E012 Civilian labor force E013 Employed E014 Own children of the householder under 6 years E015 All parents in family in labor force E016 Own children of the householder 6 to 17 years E017 All parents in family in labor force COMMUTING TO WORK E018 Workers 16 years and over E019 Car, truck, or van -- drove alone E020 Car, truck, or van -- carpooled E021 Public transportation (excluding taxicab) E022 Walked E023 Other means E024 Worked at home E025 Mean travel time to work (minutes) OCCUPATION E026 Civilian employed population 16 years and over E027 Management, business, science, and arts occupations E028 Service occupations E029 Sales and office occupations E030 Natural resources, construction, and maintenance occupations E031 Production, transportation, and material moving occupations INDUSTRY E032 Civilian employed population 16 years and over E033 Agriculture, forestry, fishing and hunting, and mining E034 Construction E035 Manufacturing E036 Wholesale trade E037 Retail trade E038 Transportation and warehousing, and utilities E039 Information E040 Finance and insurance, and real estate and rental and leasing E041 Professional, scientific, and management, and administrative and waste management services E042 Educational services, and health care and social assistance E043 Arts, entertainment, and recreation, and accommodation and food services E044 Other services, except public administration E045 Public administration CLASS OF WORKER E046 Civilian employed population 16 years and over E047 Private wage and salary workers E048 Government workers E049 Self-employed in own not incorporated business workers E050 Unpaid family workers INCOME AND BENEFITS (IN 2017 INFLATION-ADJUSTED DOLLARS) E051 Total households E052 Less than $10,000 E053 $10,000 to $14,999 E054 $15,000 to $24,999 E055 $25,000 to $34,999 E056 $35,000 to $49,999 E057 $50,000 to $74,999 E058 $75,000 to $99,999 E059 $100,000 to $149,999 E060 $150,000 to $199,999 E061 $200,000 or more E062 Median household income (dollars) E063 Mean household income (dollars) E064 With earnings E065 Mean earnings (dollars) E066 With Social Security E067 Mean Social Security income (dollars) E068 With retirement income E069 Mean retirement income (dollars) E070 With Supplemental Security Income E071 Mean Supplemental Security Income (dollars) E072 With cash public assistance income E073 Mean cash public assistance income (dollars) E074 With Food Stamp/SNAP benefits in the past 12 months E075 Families E076 Less than $10,000 E077 $10,000 to $14,999 E078 $15,000 to $24,999 E079 $25,000 to $34,999 E080 $35,000 to $49,999 E081 $50,000 to $74,999 E082 $75,000 to $99,999 E083 $100,000 to $149,999 E084 $150,000 to $199,999 E085 $200,000 or more E086 Median family income (dollars) E087 Mean family income (dollars) E088 Per capita income (dollars) E089 Nonfamily households E090 Median nonfamily income (dollars) E091 Mean nonfamily income (dollars) E092 Median earnings for workers (dollars) E093 Median earnings for male full-time, year-round workers (dollars) E094 Median earnings for female full-time, year-round workers (dollars) HEALTH INSURANCE COVERAGE E095 .. Civilian Noninstitutionalized Population E096 .... With health insurance coverage E097 ...... With private health insurance coverage E098 ...... With public health coverage E099 .... No health insurance coverage E100 .... Civilian Noninstitutionalized Population Under 18 years E101 ...... No health insurance coverage E102 .... Civilian noninstitutionalized population 18 to 64 years E103 ...... In labor force: E104 ........ Employed: E105 .......... With health insurance coverage E106 ............ With private health insurance E107 ............ With public coverage E108 .......... No health insurance coverage E109 ........ Unemployed: E110 .......... With health insurance coverage E111 ............ With private health insurance E112 ............ With public coverage E113 .......... No health insurance coverage E114 ...... Not in labor force: E115 ........ With health insurance coverage E116 .......... With private health insurance E117 .......... With public coverage E118 ........ No health insurance coverage PERCENTAGE OF FAMILIES AND PEOPLE WHOSE INCOME IN THE PAST 12 MONTHS IS BELOW THE POVERTY LEVEL E119 All families E120 With related children of the householder under 18 years E121 With related children of the householder under 5 years only E122 Married couple families E123 With related children of the householder under 18 years E124 With related children of the householder under 5 years only E125 Families with female householder, no husband present E126 With related children of the householder under 18 years E127 With related children of the householder under 5 years only E128 All people E129 Under 18 years E130 Related children of the householder under 18 years E131 Related children of the householder under 5 years E132 Related children of the householder 5 to 17 years E133 18 years and over E134 18 to 64 years E135 65 years and over E136 People in families E137 Unrelated individuals 15 years and over School District ACS2017 Economic Characteristics .. interactive table .. goto top Districts initially sorted on state by name; click any column header cell to sort on that column/attribute. Example: click E004 header cell twice to sort on "Employed Civilian Labor Force" in descending order. Click ShowAll button between Find/Queries. Use mouseover on column header to view column description. See usage notes below table. See related interactive tables. Usage Notes If table not showing any rows; click ShowAll button below table. Use vertical and horizontal scroll bars to navigate up/down or left/right. Adjust column widths using column divider between header cells. Find CBSA> button -- use to select CBSA/Metro based on exact CBSA 5 character code in column 3. .. CBSA/metro codes may be found in the table at http://proximityone.com/metros.htm#table. .. after entering the code click the Find CBSA> button ... table refreshes with all districts in this CBSA. .. example .. clicking 1) the ShowAll button, then 2) the Find CBSA button with default 41700 value. shows the 39 districts of this size in the San Antonio metro that can now be further examined as this specific set of districts. Find Name> button -- use to select district based on exact spelling of partial name in column 1. .. Key in exact up/low case spelling of partial name of district in the edit box to right of Find Name> button. .. click the Find Name> button ... table refreshes with all districts with matched spelling in column 1. Selected columns -- click the "$MHI.$MFI.$PCI" below the table to show only these columns; .. click "All columns" button to restore view to all columns. All items are estimates for the 5 year period 2013-2017 (centric to 2015). Click ShowAll button between specific area queries. Cells with negative value could not be estimated (for this geography and this time frame). Use school district code/area name based on address. Create a School District Profile .. goto top The interactive table above shows attributes for each school district as a row. To transpose the items into a downloadable profile, follow these steps. Open DP3 XLS -- Economic Characteristics -- requires Excel Select a district from interactive table above. .. click a row; it turns blue. .. right click and click copy. Paste (CTRL-v) in column D1 in spreadhseet. Right click D1 and Copy (all cells pasted in above step) Right click D4 and Paste Special The D column is now populated with with items in the districts selected from interactive table. Optionally save to local XLS file on your computer. Optionally select another district and repeat paste steps into column E1. Completed example: Economic Characteristics - San Antonio ISD, TX Optionally create four types of profiles for any district. General Demographics Social Charactersitics Economic Characteristics Housing Characteristics About these Demographic-Economic Data Data used in this section are estimates developed from the American Community Survey (ACS2017). These data differ from administratively reported data (enrollment, etc.). Data are for the total resident population in the district. Data are not shown separately for charter schools as charter schools have no defined boundaries. If a charter school located in district X has students from district Y, attributes of those students and households are shown in data for district Y. The importance of understanding the demographic-economic make-up and trends can hardly be overstated. Community and educational challenges and opportunities are shaped by demographic-economic dynamics. Only by knowing "where we are" can we develop the most effective plans for improvement. The importance of understanding the demographic-economic make-up and trends can hardly be overstated. Community and educational challenges and opportunities are shaped by demographic-economic dynamics. Only by knowing "where we are" can we develop the most effective plans for improvement. The American Community Survey provides "richer" demographic-economic characteristics for national scope wide-ranging geographic areas. While Census 2010 provides data similar to those items in the General Demographics section, only ACS sourced data provide details on topics such as income and poverty, labor force and employment, housing value and costs, educational participation and attainment, language spoken at home, among many related items. The approximate 600 items accessible via the dataset are supplemented by a wide range of additional subject matter. These data are updated annually in December of each year for each/all political/statistical areas, including census tracts, ZIP code areas and block groups.. FAQS & Related Notes .. goto top How to view/rank/compare largest districts based on total population Use the General Demographics section/table. Click the D001 (total population) table header cell. .. the table refreshes sorted on D001 in one direction; click again to sort in other direction. How to view/rank/compare enrollment Use the Social Characteristics section/table. Click the button School Enrollment below the table. .. the table refreshes with the school enrollment columns. ProximityOne User Group Join the ProximityOne User Group to keep up-to-date with new developments relating to metros and component geography decision-making information resources. Receive updates and access to tools and resources available only to members. Use this form to join the User Group. Support Using these Resources Learn more about accessing and using demographic-economic data and related analytical tools. Join us in a Data Analytics Lab session. There is no fee for these one-hour Web sessions. Each informal session is focused on a specific topic. The open structure also provides for Q&A and discussion of application issues of interest to participants. Additional Information ProximityOne develops geodemographic-economic data and analytical tools and helps organizations knit together and use diverse data in a decision-making and analytical framework. We develop custom demographic/economic estimates and projections, develop geographic and geocoded address files, and assist with impact and geospatial analyses. Wide-ranging organizations use our tools (software, data, methodologies) to analyze their own data integrated with other data. Follow ProximityOne on Twitter at www.twitter.com/proximityone. Contact us (888-364-7656) with questions about data covered in this section or to discuss custom estimates, projections or analyses for your areas of interest. |
|