transcript.md
↑ ContentsState Planner chat · https://stateplanner.com
- State: Florida (FL)
- Started: November 11, 2026, 2:53 PM UTC
- Runtime: 28 sec
- Status: completed
Prompt
Which Florida counties’ economies grew fastest from 2017 to 2022, after adjusting for inflation? Map the change.
Model: Anthropic: Claude Opus 5.5 (anthropic/claude-opus-5.5, via openrouter)
Response
Real GDP growth by Florida county, 2017 to 2022
I measured growth with BEA's real GDP for all industries combined, in chained 2017 dollars. BEA builds this figure to remove inflation, so no hand adjustment is needed. Florida's own BEA figure grew 22.8%, from about $1.01 trillion to $1.25 trillion. BEA published figures for all 67 counties, with none withheld.

Legend: darker green means faster real growth. The darkest green is 40% or more, then 30–40%, 20–30% (the band that holds the state's 22.8%), 10–20%, and pale yellow for 0–10%. Red marks the one county whose real GDP fell. Click a county to see its 2017 and 2022 real GDP and the percent change.
Fastest-growing counties, real GDP 2017–2022 (millions of chained 2017 $)
| Rank | County | 2017 | 2022 | Change |
|---|---|---|---|---|
| 1 | Sumter | 3,208 | 5,085 | +58.5% |
| 2 | Okeechobee | 1,254 | 1,874 | +49.5% |
| 3 | Liberty | 183 | 263 | +43.7% |
| 4 | Walton | 3,073 | 4,396 | +43.1% |
| 5 | St. Johns | 8,971 | 12,811 | +42.8% |
| 6 | Flagler | 2,695 | 3,694 | +37.0% |
| 7 | Nassau | 2,647 | 3,518 | +32.9% |
| 8 | Pasco | 12,597 | 16,683 | +32.4% |
| 9 | Citrus | 3,704 | 4,903 | +32.4% |
| 10 | Brevard | 24,133 | 31,677 | +31.3% |
What the map shows
- The fastest growth is on the edges of the big metros. Around Jacksonville: St. Johns, Nassau and Flagler. North of Tampa: Pasco, Citrus and Hernando. Around Orlando and The Villages: Sumter, Osceola and Lake. On the Space Coast: Brevard. On the Emerald Coast: Walton, Okaloosa and Santa Rosa.
- The large urban counties grew close to the state rate. Hillsborough grew 26.8%, Palm Beach 24.0%, Duval 23.3%, Orange 22.1% and Broward 22.0%. Miami-Dade grew more slowly, at 17.6%.
- Liberty (+43.7%) and Okeechobee (+49.5%) are small economies. Their percentages are large, but the dollar gains behind them are small.
- The slowest growth was in rural North Florida and parts of the interior. Taylor is the only county where real GDP fell (−7.8%). Gadsden (+1.1%), Dixie (+1.4%), Bradford (+2.5%) and Jackson (+4.3%) grew the least.
Caveats
- These are BEA's latest revised figures. Chained dollars should only be compared over time within one county, not added across counties.
- The 2017–2022 window includes the 2020 downturn and the recovery after it, so a county's growth depends partly on how hard 2020 hit it.
- GDP measures output where it is produced, not residents' income. Per-capita income growth (from
fl_bea_county_income) could rank the counties differently.
Exploratory Queries
Query 1 — Compute real GDP change 2017-2022 by county.
SELECT a.geoid,
a.name,
round(a.real_gdp / 1e6, 2) rgdp17_bn,
round(b.real_gdp / 1e6, 2) rgdp22_bn,
round(100 * (b.real_gdp / a.real_gdp -1), 1) pct,
b.codes,
(c.geoid IS NOT NULL) in_census
FROM fl_bea_county_gdp a
JOIN fl_bea_county_gdp b ON a.geoid = b.geoid
AND b.line_code = 1
AND b.year = 2022
LEFT JOIN fl_census_counties c ON c.geoid = a.geoid
WHERE a.line_code = 1
AND a.year = 2017
ORDER BY pct DESC
| geoid | name | rgdp17_bn | rgdp22_bn | pct | codes | in_census |
|---|---|---|---|---|---|---|
| 12119 | Sumter, FL | 3208.20 | 5085.27 | 58.5 | true | |
| 12093 | Okeechobee, FL | 1253.57 | 1873.79 | 49.5 | true | |
| 12077 | Liberty, FL | 183.22 | 263.29 | 43.7 | true | |
| 12131 | Walton, FL | 3072.67 | 4395.86 | 43.1 | true | |
| 12109 | St. Johns, FL | 8970.72 | 12810.50 | 42.8 | true | |
| 12035 | Flagler, FL | 2695.38 | 3693.58 | 37.0 | true | |
| 12089 | Nassau, FL | 2646.89 | 3518.30 | 32.9 | true | |
| 12101 | Pasco, FL | 12596.63 | 16682.89 | 32.4 | true | |
| 12017 | Citrus, FL | 3704.39 | 4902.95 | 32.4 | true | |
| 12009 | Brevard, FL | 24133.06 | 31676.92 | 31.3 | true | |
| 12097 | Osceola, FL | 10505.77 | 13744.82 | 30.8 | true | |
| 12021 | Collier, FL | 18972.22 | 24257.79 | 27.9 | true | |
| 12081 | Manatee, FL | 14216.89 | 18164.12 | 27.8 | true | |
| 12091 | Okaloosa, FL | 11313.09 | 14458.11 | 27.8 | true | |
| 12113 | Santa Rosa, FL | 4429.46 | 5625.51 | 27.0 | true | |
| 12057 | Hillsborough, FL | 87528.49 | 111012.38 | 26.8 | true | |
| 12111 | St. Lucie, FL | 9305.42 | 11773.47 | 26.5 | true | |
| 12115 | Sarasota, FL | 20195.02 | 25555.59 | 26.5 | true | |
| 12053 | Hernando, FL | 4036.62 | 5088.88 | 26.1 | true | |
| 12015 | Charlotte, FL | 5181.24 | 6512.05 | 25.7 | true | |
| 12117 | Seminole, FL | 20979.51 | 26183.24 | 24.8 | true | |
| 12071 | Lee, FL | 31283.53 | 38894.72 | 24.3 | true | |
| 12069 | Lake, FL | 9661.01 | 11988.78 | 24.1 | true | |
| 12099 | Palm Beach, FL | 82713.43 | 102539.99 | 24.0 | true | |
| 12083 | Marion, FL | 9763.72 | 12089.34 | 23.8 | true |
25 out of 68 are listed here.
Map Layer Queries
Real GDP change 2017–2022 (chained 2017 $) — colored by "cls": 40% or more (#00441b), 30–40% (#238b45), 20–30% (state: 22.8%) (#74c476), 10–20% (#c7e9c0), 0–10% (#fff7bc), Decline (#d7301f)
SELECT c.geom,
c.name AS "County",
round(a.real_gdp / 1e6) AS "Real GDP 2017 ($M, 2017 $)",
round(b.real_gdp / 1e6) AS "Real GDP 2022 ($M, 2017 $)",
round(100 * (b.real_gdp / a.real_gdp -1), 1) AS "Change(%)",
CASE
WHEN b.real_gdp / a.real_gdp -1 >= 0.40 THEN '40%+'
WHEN b.real_gdp / a.real_gdp -1 >= 0.30 THEN '30-40%'
WHEN b.real_gdp / a.real_gdp -1 >= 0.20 THEN '20-30%'
WHEN b.real_gdp / a.real_gdp -1 >= 0.10 THEN '10-20%'
WHEN b.real_gdp / a.real_gdp -1 >= 0 THEN '0-10%'
ELSE 'Decline'
END AS cls
FROM fl_census_counties c
JOIN fl_bea_county_gdp a ON a.geoid = c.geoid
AND a.line_code = 1
AND a.year = 2017
JOIN fl_bea_county_gdp b ON b.geoid = c.geoid
AND b.line_code = 1
AND b.year = 2022
Picture: maps/turn-1-real-gdp-growth-county.png
Used Data Sets
fl_bea_county_gdp— last synced 2026-10-16 · 55,488 rowsfl_census_counties— last synced 2026-09-27 · 67 rows