← All studies · askamerica.ai

Shale-boom counties grew jobs and income far faster than the nation — but the boom's benefits are basin-specific and fading fastest in gas country

12 leading counties across the Bakken, Eagle Ford, Permian, and Marcellus plays — BLS QCEW, Census decennial, BEA regional income

Shale-Boom Counties: Then vs. Now 12 top counties across the Bakken (ND), Eagle Ford (TX), Permian (TX), Marcellus (PA/WV) shale plays — BLS QCEW, Census, BEA Avg. employment growth, 12 boom counties (2007-2024) +87.6% vs. +14.3% nationally Avg. real per-capita income growth (2008-2024) +66.5% vs. national real wage +12.4% Employment change by county, 2007-2024 -50 0 50 100 150 200 250 300 350 County % change McKenzie ND Mountrail ND Williams ND Karnes TX La Salle TX DeWitt TX Midland TX Martin TX Reeves TX Bradford PA Susquehanna PA Doddridge WV Bakken counties (ND) show the largest gains; Marcellus gas counties (PA/WV) show the smallest. Population change by county, 2000-2020 -50 0 50 100 150 200 County % change McKenzie ND Mountrail ND Williams ND Karnes TX La Salle TX DeWitt TX Midland TX Martin TX Reeves TX Bradford PA Susquehanna PA Doddridge WV Decennial Census 2000 vs 2020 — the one measure here that spans a genuine full decade before the boom. Real per-capita income change by county, 2008-2024 -50 0 50 100 150 200 County % change (2024 $) McKenzie ND Mountrail ND Williams ND Karnes TX La Salle TX DeWitt TX Midland TX Martin TX Reeves TX Bradford PA Susquehanna PA Doddridge WV BEA CAINC1 per-capita personal income, deflated to 2024 dollars. Real avg. weekly wage change by county, 2007-2024 0 20 40 60 80 100 County % change (2024 $) McKenzie ND Mountrail ND Williams ND Karnes TX La Salle TX DeWitt TX Midland TX Martin TX Reeves TX Bradford PA Susquehanna PA Doddridge WV BLS QCEW average weekly wage, all industries, deflated to 2024 dollars; national real wage growth over the same span was +12.4%. Wages/income in real 2024 dollars (CPI-U). QCEW/BEA county data begins in 2007/2008, so "before the boom" here means the earliest year available in the warehouse — for Bakken/Marcellus, whose booms began ramping in 2006-2008, that is closer to the boom's start than a true decade before; Census population uses the real 2000 decennial count. US comparators (avg. weekly wage +12.4% real, employment +14.3%, 2007-2024) from… AskAmerica · askamerica.ai
SVG

Summary

Across 12 leading shale-boom counties — four each in the Bakken (ND), Eagle Ford (TX), Permian (TX), and Marcellus (PA/WV) plays — employment grew an average of +87.6% and real per-capita income grew +66.5% from just before the boom to the most recent data (2024), versus +14.3% employment growth and +12.4% real wage growth nationally over the same span. But the gains are highly uneven: the Bakken counties in North Dakota show extraordinary, population-transforming growth (McKenzie County employment +305%, population +156%), while the Marcellus gas counties in Pennsylvania and West Virginia show only modest gains and in one case (Susquehanna County, PA) essentially flat employment. This matches published research: shale employment and income gains are real but temporary in most basins, and the Appalachian gas counties in particular have seen initial gains erode or reverse.

Which counties and why

These are widely-cited top production/employment-growth counties in each of the four dominant U.S. shale plays (Hart Energy, Dallas Fed, Minneapolis Fed): Bakken — McKenzie, Mountrail, Williams (ND); Eagle Ford — Karnes, La Salle, DeWitt (TX); Permian — Midland, Martin, Reeves (TX); Marcellus — Bradford, Susquehanna (PA), Doddridge (WV). Each play's shale-drilling boom (horizontal drilling + high-volume hydraulic fracturing) began ramping roughly 2006-2011 depending on the basin.

Data-coverage limitation — read before the numbers

This corpus's county-level BLS QCEW employment/wage table (econ.county_wages) and BEA regional income table (econ.regional_income) both begin in 2007-2008 — essentially at or just before the Bakken and Marcellus booms started, not a full decade earlier. A genuine decade-before comparison for those two plays would need 1996-1998 data, which is not loaded in this warehouse and was not separately sourced from BLS's historical QCEW archive for this answer given the scope. The one measure here that IS a true decade-before comparison is Census decennial population (2000 vs. 2020). Readers should treat the employment/wage/income figures as "near the start of the boom vs. now" rather than literally "a decade before the boom vs. now," especially for Bakken and Marcellus. For Eagle Ford and Permian, whose shale booms accelerated closer to 2010-2011, the 2007/2008 baseline is a closer — though still imperfect — stand-in for the pre-boom decade.

County-by-county detail

McKenzie, NDBakken5,73714,704+156.3%2,83711,484+304.8%+64.1%+32.4%
Mountrail, NDBakken6,6319,809+47.9%2,2175,341+140.9%+78.5%+48.6%
Williams, NDBakken19,76140,950+107.2%11,20927,125+142.0%+45.3%-1.4%
Karnes, TXEagle Ford15,44614,710-4.8%3,7986,178+62.7%+74.7%+134.5%
La Salle, TXEagle Ford5,8666,664+13.6%1,6363,137+91.7%+55.4%+48.6%
DeWitt, TXEagle Ford20,01319,824-0.9%6,5716,827+3.9%+24.3%+63.7%
Midland, TXPermian116,009169,983+46.5%65,396118,325+80.9%+41.0%+12.1%
Martin, TXPermian4,7465,237+10.3%1,2652,341+85.1%+50.0%+162.7%
Reeves, TXPermian13,13714,748+12.3%3,7867,721+103.9%+83.9%+160.6%
Bradford, PAMarcellus62,76159,967-4.5%21,76822,333+2.6%+18.6%+17.8%
Susquehanna, PAMarcellus42,23838,434-9.0%8,9778,955-0.2%+28.8%+39.3%
Doddridge, WVMarcellus7,4037,808+5.5%1,1771,564+32.9%+69.7%+79.4%
Bradford, PAMarcellus62,76159,967-4.5%21,76822,333+2.6%+18.6%+17.8%
DeWitt, TXEagle Ford20,01319,824-0.9%6,5716,827+3.9%+24.3%+63.7%
Doddridge, WVMarcellus7,4037,808+5.5%1,1771,564+32.9%+69.7%+79.4%
Karnes, TXEagle Ford15,44614,710-4.8%3,7986,178+62.7%+74.7%+134.5%
La Salle, TXEagle Ford5,8666,664+13.6%1,6363,137+91.7%+55.4%+48.6%
Martin, TXPermian4,7465,237+10.3%1,2652,341+85.1%+50.0%+162.7%
McKenzie, NDBakken5,73714,704+156.3%2,83711,484+304.8%+64.1%+32.4%
Midland, TXPermian116,009169,983+46.5%65,396118,325+80.9%+41.0%+12.1%
Mountrail, NDBakken6,6319,809+47.9%2,2175,341+140.9%+78.5%+48.6%
Reeves, TXPermian13,13714,748+12.3%3,7867,721+103.9%+83.9%+160.6%
Susquehanna, PAMarcellus42,23838,434-9.0%8,9778,955-0.2%+28.8%+39.3%
Williams, NDBakken19,76140,950+107.2%11,20927,125+142.0%+45.3%-1.4%
McKenzie, NDBakken5,73714,704+156.3%2,83711,484+304.8%+64.1%+32.4%
Mountrail, NDBakken6,6319,809+47.9%2,2175,341+140.9%+78.5%+48.6%
Williams, NDBakken19,76140,950+107.2%11,20927,125+142.0%+45.3%-1.4%
Karnes, TXEagle Ford15,44614,710-4.8%3,7986,178+62.7%+74.7%+134.5%
La Salle, TXEagle Ford5,8666,664+13.6%1,6363,137+91.7%+55.4%+48.6%
DeWitt, TXEagle Ford20,01319,824-0.9%6,5716,827+3.9%+24.3%+63.7%
Bradford, PAMarcellus62,76159,967-4.5%21,76822,333+2.6%+18.6%+17.8%
Susquehanna, PAMarcellus42,23838,434-9.0%8,9778,955-0.2%+28.8%+39.3%
Doddridge, WVMarcellus7,4037,808+5.5%1,1771,564+32.9%+69.7%+79.4%
Midland, TXPermian116,009169,983+46.5%65,396118,325+80.9%+41.0%+12.1%
Martin, TXPermian4,7465,237+10.3%1,2652,341+85.1%+50.0%+162.7%
Reeves, TXPermian13,13714,748+12.3%3,7867,721+103.9%+83.9%+160.6%
Midland, TXPermian116,009169,983+46.5%65,396118,325+80.9%+41.0%+12.1%
Bradford, PAMarcellus62,76159,967-4.5%21,76822,333+2.6%+18.6%+17.8%
Susquehanna, PAMarcellus42,23838,434-9.0%8,9778,955-0.2%+28.8%+39.3%
DeWitt, TXEagle Ford20,01319,824-0.9%6,5716,827+3.9%+24.3%+63.7%
Williams, NDBakken19,76140,950+107.2%11,20927,125+142.0%+45.3%-1.4%
Karnes, TXEagle Ford15,44614,710-4.8%3,7986,178+62.7%+74.7%+134.5%
Reeves, TXPermian13,13714,748+12.3%3,7867,721+103.9%+83.9%+160.6%
Doddridge, WVMarcellus7,4037,808+5.5%1,1771,564+32.9%+69.7%+79.4%
Mountrail, NDBakken6,6319,809+47.9%2,2175,341+140.9%+78.5%+48.6%
La Salle, TXEagle Ford5,8666,664+13.6%1,6363,137+91.7%+55.4%+48.6%
McKenzie, NDBakken5,73714,704+156.3%2,83711,484+304.8%+64.1%+32.4%
Martin, TXPermian4,7465,237+10.3%1,2652,341+85.1%+50.0%+162.7%
Midland, TXPermian116,009169,983+46.5%65,396118,325+80.9%+41.0%+12.1%
Bradford, PAMarcellus62,76159,967-4.5%21,76822,333+2.6%+18.6%+17.8%
Williams, NDBakken19,76140,950+107.2%11,20927,125+142.0%+45.3%-1.4%
Susquehanna, PAMarcellus42,23838,434-9.0%8,9778,955-0.2%+28.8%+39.3%
DeWitt, TXEagle Ford20,01319,824-0.9%6,5716,827+3.9%+24.3%+63.7%
Reeves, TXPermian13,13714,748+12.3%3,7867,721+103.9%+83.9%+160.6%
Karnes, TXEagle Ford15,44614,710-4.8%3,7986,178+62.7%+74.7%+134.5%
McKenzie, NDBakken5,73714,704+156.3%2,83711,484+304.8%+64.1%+32.4%
Mountrail, NDBakken6,6319,809+47.9%2,2175,341+140.9%+78.5%+48.6%
Doddridge, WVMarcellus7,4037,808+5.5%1,1771,564+32.9%+69.7%+79.4%
La Salle, TXEagle Ford5,8666,664+13.6%1,6363,137+91.7%+55.4%+48.6%
Martin, TXPermian4,7465,237+10.3%1,2652,341+85.1%+50.0%+162.7%
McKenzie, NDBakken5,73714,704+156.3%2,83711,484+304.8%+64.1%+32.4%
Williams, NDBakken19,76140,950+107.2%11,20927,125+142.0%+45.3%-1.4%
Mountrail, NDBakken6,6319,809+47.9%2,2175,341+140.9%+78.5%+48.6%
Midland, TXPermian116,009169,983+46.5%65,396118,325+80.9%+41.0%+12.1%
La Salle, TXEagle Ford5,8666,664+13.6%1,6363,137+91.7%+55.4%+48.6%
Reeves, TXPermian13,13714,748+12.3%3,7867,721+103.9%+83.9%+160.6%
Martin, TXPermian4,7465,237+10.3%1,2652,341+85.1%+50.0%+162.7%
Doddridge, WVMarcellus7,4037,808+5.5%1,1771,564+32.9%+69.7%+79.4%
DeWitt, TXEagle Ford20,01319,824-0.9%6,5716,827+3.9%+24.3%+63.7%
Bradford, PAMarcellus62,76159,967-4.5%21,76822,333+2.6%+18.6%+17.8%
Karnes, TXEagle Ford15,44614,710-4.8%3,7986,178+62.7%+74.7%+134.5%
Susquehanna, PAMarcellus42,23838,434-9.0%8,9778,955-0.2%+28.8%+39.3%
Midland, TXPermian116,009169,983+46.5%65,396118,325+80.9%+41.0%+12.1%
Bradford, PAMarcellus62,76159,967-4.5%21,76822,333+2.6%+18.6%+17.8%
Williams, NDBakken19,76140,950+107.2%11,20927,125+142.0%+45.3%-1.4%
Susquehanna, PAMarcellus42,23838,434-9.0%8,9778,955-0.2%+28.8%+39.3%
DeWitt, TXEagle Ford20,01319,824-0.9%6,5716,827+3.9%+24.3%+63.7%
Karnes, TXEagle Ford15,44614,710-4.8%3,7986,178+62.7%+74.7%+134.5%
Reeves, TXPermian13,13714,748+12.3%3,7867,721+103.9%+83.9%+160.6%
McKenzie, NDBakken5,73714,704+156.3%2,83711,484+304.8%+64.1%+32.4%
Mountrail, NDBakken6,6319,809+47.9%2,2175,341+140.9%+78.5%+48.6%
La Salle, TXEagle Ford5,8666,664+13.6%1,6363,137+91.7%+55.4%+48.6%
Martin, TXPermian4,7465,237+10.3%1,2652,341+85.1%+50.0%+162.7%
Doddridge, WVMarcellus7,4037,808+5.5%1,1771,564+32.9%+69.7%+79.4%
Midland, TXPermian116,009169,983+46.5%65,396118,325+80.9%+41.0%+12.1%
Williams, NDBakken19,76140,950+107.2%11,20927,125+142.0%+45.3%-1.4%
Bradford, PAMarcellus62,76159,967-4.5%21,76822,333+2.6%+18.6%+17.8%
McKenzie, NDBakken5,73714,704+156.3%2,83711,484+304.8%+64.1%+32.4%
Susquehanna, PAMarcellus42,23838,434-9.0%8,9778,955-0.2%+28.8%+39.3%
Reeves, TXPermian13,13714,748+12.3%3,7867,721+103.9%+83.9%+160.6%
DeWitt, TXEagle Ford20,01319,824-0.9%6,5716,827+3.9%+24.3%+63.7%
Karnes, TXEagle Ford15,44614,710-4.8%3,7986,178+62.7%+74.7%+134.5%
Mountrail, NDBakken6,6319,809+47.9%2,2175,341+140.9%+78.5%+48.6%
La Salle, TXEagle Ford5,8666,664+13.6%1,6363,137+91.7%+55.4%+48.6%
Martin, TXPermian4,7465,237+10.3%1,2652,341+85.1%+50.0%+162.7%
Doddridge, WVMarcellus7,4037,808+5.5%1,1771,564+32.9%+69.7%+79.4%
McKenzie, NDBakken5,73714,704+156.3%2,83711,484+304.8%+64.1%+32.4%
Williams, NDBakken19,76140,950+107.2%11,20927,125+142.0%+45.3%-1.4%
Mountrail, NDBakken6,6319,809+47.9%2,2175,341+140.9%+78.5%+48.6%
Reeves, TXPermian13,13714,748+12.3%3,7867,721+103.9%+83.9%+160.6%
La Salle, TXEagle Ford5,8666,664+13.6%1,6363,137+91.7%+55.4%+48.6%
Martin, TXPermian4,7465,237+10.3%1,2652,341+85.1%+50.0%+162.7%
Midland, TXPermian116,009169,983+46.5%65,396118,325+80.9%+41.0%+12.1%
Karnes, TXEagle Ford15,44614,710-4.8%3,7986,178+62.7%+74.7%+134.5%
Doddridge, WVMarcellus7,4037,808+5.5%1,1771,564+32.9%+69.7%+79.4%
DeWitt, TXEagle Ford20,01319,824-0.9%6,5716,827+3.9%+24.3%+63.7%
Bradford, PAMarcellus62,76159,967-4.5%21,76822,333+2.6%+18.6%+17.8%
Susquehanna, PAMarcellus42,23838,434-9.0%8,9778,955-0.2%+28.8%+39.3%
Reeves, TXPermian13,13714,748+12.3%3,7867,721+103.9%+83.9%+160.6%
Mountrail, NDBakken6,6319,809+47.9%2,2175,341+140.9%+78.5%+48.6%
Karnes, TXEagle Ford15,44614,710-4.8%3,7986,178+62.7%+74.7%+134.5%
Doddridge, WVMarcellus7,4037,808+5.5%1,1771,564+32.9%+69.7%+79.4%
McKenzie, NDBakken5,73714,704+156.3%2,83711,484+304.8%+64.1%+32.4%
La Salle, TXEagle Ford5,8666,664+13.6%1,6363,137+91.7%+55.4%+48.6%
Martin, TXPermian4,7465,237+10.3%1,2652,341+85.1%+50.0%+162.7%
Williams, NDBakken19,76140,950+107.2%11,20927,125+142.0%+45.3%-1.4%
Midland, TXPermian116,009169,983+46.5%65,396118,325+80.9%+41.0%+12.1%
Susquehanna, PAMarcellus42,23838,434-9.0%8,9778,955-0.2%+28.8%+39.3%
DeWitt, TXEagle Ford20,01319,824-0.9%6,5716,827+3.9%+24.3%+63.7%
Bradford, PAMarcellus62,76159,967-4.5%21,76822,333+2.6%+18.6%+17.8%
Martin, TXPermian4,7465,237+10.3%1,2652,341+85.1%+50.0%+162.7%
Reeves, TXPermian13,13714,748+12.3%3,7867,721+103.9%+83.9%+160.6%
Karnes, TXEagle Ford15,44614,710-4.8%3,7986,178+62.7%+74.7%+134.5%
Doddridge, WVMarcellus7,4037,808+5.5%1,1771,564+32.9%+69.7%+79.4%
DeWitt, TXEagle Ford20,01319,824-0.9%6,5716,827+3.9%+24.3%+63.7%
Mountrail, NDBakken6,6319,809+47.9%2,2175,341+140.9%+78.5%+48.6%
La Salle, TXEagle Ford5,8666,664+13.6%1,6363,137+91.7%+55.4%+48.6%
Susquehanna, PAMarcellus42,23838,434-9.0%8,9778,955-0.2%+28.8%+39.3%
McKenzie, NDBakken5,73714,704+156.3%2,83711,484+304.8%+64.1%+32.4%
Bradford, PAMarcellus62,76159,967-4.5%21,76822,333+2.6%+18.6%+17.8%
Midland, TXPermian116,009169,983+46.5%65,396118,325+80.9%+41.0%+12.1%
Williams, NDBakken19,76140,950+107.2%11,20927,125+142.0%+45.3%-1.4%

Source: econ.county_wages (BLS QCEW, own_code='0', industry_code='10', 2007 vs 2024), census.decennial_population (2000 vs 2020), econ.regional_income (BEA CAINC1 per-capita personal income, line_code='3', 2008 vs 2024, deflated to 2024$ via CPI-U). National comparators from econ.state_wages summed nationally.

By basin: a genuinely different story in each play

Bakken (ND) — the biggest transformation of any play here. McKenzie County's population grew 156% (2000-2020) and its employment more than quadrupled (2007-2024); Williams County (Williston) went from a stagnant farm-trade county of ~20,000 to a regional oil-services hub of ~41,000. Real wages and incomes rose sharply too, though Williams County's real per-capita income is actually flat-to-slightly-down since 2008 because its 2008 baseline was already elevated by an early spike. This basin, more than the others, converted a genuine multi-decade population and employment trajectory.

Permian (TX) — the strongest and most durable income gains of the four plays: Martin and Reeves counties saw real per-capita income roughly 2.6x since 2008, and employment growth (81-104%) outpaced every basin but the Bakken. Population growth was more moderate (10-47%) — Permian growth has concentrated more in payroll/income than in raw population inflow, consistent with a basin still in a later, more capital- and machinery-intensive phase of development.

Eagle Ford (TX) — a mixed picture. Karnes County shows the strongest income gain in this basin (+134% real per-capita income) alongside falling population (-4.8%) — consistent with published findings that the Eagle Ford's economic upside showed up disproportionately in wages/royalties per resident rather than in durable population growth. DeWitt County's employment gain (+3.9%) is barely distinguishable from noise and trails the national average.

Marcellus (PA/WV) — the weakest and most consistent with the peer-reviewed finding that Appalachian shale-gas gains were "modest and temporary." Bradford and Susquehanna counties in Pennsylvania show essentially flat employment (+2.6%, -0.2%) and both have lost population since 2000 (-4.5%, -9.0%) despite hosting some of the most active Marcellus gas drilling in the country. Doddridge County, WV shows a stronger employment gain (+32.9%) and income gain (+79.4%) than its Pennsylvania peers, but even there population growth was minimal (+5.5%). This lines up with the research literature: gas-focused plays with lower per-well labor intensity and a workforce drawn heavily from outside the county produced a much smaller and less durable local economic footprint than the oil-focused Bakken and Permian.

What the published research says

This pattern matches peer-reviewed and Federal Reserve research on shale-boom counties. A Minneapolis Fed comparison found the Bakken's average weekly wage rose 88% from 2008 through the early boom years versus just 20% in the Eagle Ford, matching the outsized Bakken gains found here. National studies of the fracking boom (e.g. Bartik et al., and Marcellus-specific work by Weber and colleagues) find local employment and wage gains of roughly 7-11% in the first several years after a county's boom began, but that these gains typically fade after about 4 years, and Appalachian-region studies going further out find shale gas counties' initial 1.6% employment gain reversing into a net loss over the longer run — consistent with Bradford and Susquehanna counties' near-zero net employment change here despite roughly 15+ years of Marcellus drilling. In short: oil-heavy Bakken/Permian counties converted their booms into much larger and more durable local economies; gas-heavy Marcellus counties in Appalachia mostly have not.

Methodology and caveats

What This Report Does Not Answer

Every query behind this report

11 warehouse calls ran in this session, in order. Each is reproducible against the same snapshot.

query — 24 rows — 4151 ms
SELECT county_fips, year, annual_avg_emplvl, total_annual_wages, annual_avg_wkly_wage, annual_avg_estabs
FROM econ.county_wages
WHERE county_fips IN ('38053','38061','38105','48255','48283','48123','48329','48317','48389','42015','42115','54017')
AND own_code='0' AND industry_code='10'
AND year IN ('2007','2024')
ORDER BY county_fips, year
query — 24 rows — 3449 ms
SELECT county_fips, "year", total_population FROM census.decennial_population
WHERE county_fips IN ('38053','38061','38105','48255','48283','48123','48329','48317','48389','42015','42115','54017')
AND "year" IN ('2000','2020')
ORDER BY county_fips, "year"
query — 1838 ms
SELECT geo_fips, time_period, data_value FROM econ.regional_income
WHERE geo_fips IN ('38053','38061','38105','48255','48283','48123','48329','48317','48389','42015','42115','54017')
AND cl_unit = 'Per capita personal income' AND tablename='CAINC1' AND time_period IN ('2008','2024')
ORDER BY geo_fips, time_period
query — 1321 ms
SELECT DISTINCT cl_unit, tablename, line_code FROM econ.regional_income WHERE geo_fips='48329' AND time_period='2020' AND cl_unit ILIKE '%per capita%' LIMIT 20
query — 1 rows — 8123 ms
SELECT DISTINCT geo_fips, geo_name FROM econ.regional_income WHERE geo_fips_set='COUNTY' AND geo_name ILIKE '%Midland%TX%' FETCH FIRST 10 ROWS ONLY
query — 30 rows — 1613 ms
SELECT DISTINCT cl_unit, tablename, line_code FROM econ.regional_income WHERE geo_fips='48329' AND time_period='2020' FETCH FIRST 30 ROWS ONLY
query — 3 rows — 1636 ms
SELECT DISTINCT cl_unit, line_code FROM econ.regional_income WHERE geo_fips='48329' AND time_period='2020' AND tablename='CAINC1' FETCH FIRST 20 ROWS ONLY
query — 24 rows — 2340 ms
SELECT geo_fips, geo_name, time_period, data_value AS per_capita_income
FROM econ.regional_income
WHERE geo_fips IN ('38053','38061','38105','48255','48283','48123','48329','48317','48389','42015','42115','54017')
AND tablename='CAINC1' AND line_code='3' AND time_period IN ('2008','2024')
ORDER BY geo_fips, time_period
adjust_inflation — 71859 ms
SELECT county_fips, year, annual_avg_wkly_wage AS wage FROM econ.county_wages WHERE county_fips IN ('38053','38061','38105','48255','48283','48123','48329','48317','48389','42015','42115','54017') AND own_code='0' AND industry_code='10' AND year IN ('2007','2024')
adjust_inflation — 74843 ms
SELECT geo_fips, time_period AS "year", data_value AS pci FROM econ.regional_income WHERE geo_fips IN ('38053','38061','38105','48255','48283','48123','48329','48317','48389','42015','42115','54017') AND tablename='CAINC1' AND line_code='3' AND time_period IN ('2008','2024')
query — 2 rows — 7605 ms
SELECT "year", SUM(annual_avg_emplvl) AS us_emp, SUM(total_annual_wages) AS us_wages FROM econ.state_wages WHERE own_code='0' AND industry_code='10' AND "year" IN ('2007','2024') GROUP BY "year"

Sources

  1. BLS QCEW county employment/wages, 2007 & 2024 — via econ.county_wages
    Show SQL
    SELECT county_fips, year, annual_avg_emplvl, total_annual_wages, annual_avg_wkly_wage FROM econ.county_wages WHERE county_fips IN ('38053','38061','38105','48255','48283','48123','48329','48317','48389','42015','42115','54017') AND own_code='0' AND industry_code='10' AND year IN ('2007','2024')
  2. Census decennial population, 2000 & 2020 — via census.decennial_population
    Show SQL
    SELECT county_fips, year, total_population FROM census.decennial_population WHERE county_fips IN ('38053','38061','38105','48255','48283','48123','48329','48317','48389','42015','42115','54017') AND year IN ('2000','2020')
  3. BEA CAINC1 per-capita personal income, 2008 & 2024 — via econ.regional_income
    Show SQL
    SELECT geo_fips, geo_name, time_period, data_value FROM econ.regional_income WHERE geo_fips IN ('38053','38061','38105','48255','48283','48123','48329','48317','48389','42015','42115','54017') AND tablename='CAINC1' AND line_code='3' AND time_period IN ('2008','2024')
  4. CPI-U deflator, 2007/2008 to 2024
    Show tool call
    adjust_inflation(base_year=2024)
  5. US national employment/wage totals, 2007 & 2024 — via econ.state_wages summed nationally
    Show SQL
    SELECT year, SUM(annual_avg_emplvl) AS us_emp, SUM(total_annual_wages) AS us_wages FROM econ.state_wages WHERE own_code='0' AND industry_code='10' AND year IN ('2007','2024') GROUP BY year
  6. Bakken Stands Out In Comparison With Other Shale Drilling Areas — Federal Reserve Bank of Minneapolis
  7. Energy in the 11th District: Eagle Ford Shale — Dallas Fed
  8. Study: Shale gas boom 'failed to deliver' prosperity for Appalachia — Ohio Capital Journal
  9. Income and employment effects of shale gas extraction windfalls: Evidence from the Marcellus region
  10. The local employment impacts of fracking: A national study