Data downloads

By Jon Brooks, Co-Founder, Momentum Realty · Last updated Nov 19, 2026 · Method and sources · Corrections

Files

FileSizeWhat it is
a3_hit_rankings.csv6 KBTabular export; see the data dictionary
audit_screen.csv7 KBTabular export; see the data dictionary
budget_growth.csv16 KBTabular export; see the data dictionary
budget_growth_by_area.csv33 KBTabular export; see the data dictionary
budget_growth_reasons.csv5 KBTabular export; see the data dictionary
counties.csv85 KBOne row per county: Amendment 3 estimates, scores, ranks, debt, management score
counties.json1,369 KBFull county data, sources, rules and weights
county_responses.csv20 KBTabular export; see the data dictionary
debt_detail.csv1,160 KBDebt by county and year with basis and source document
dollar_pie.csv3 KBTabular export; see the data dictionary
fl_counties.geojson38 KBCensus 2023 county boundaries with slugs
hillsborough_audit_check.csv2 KBTabular export; see the data dictionary
incentives.csv69 KBTabular export; see the data dictionary
management_ranking.csv3 KBTabular export; see the data dictionary
potential_waste.csv73 KBTabular export; see the data dictionary
projects_timeline.csv372 KBTabular export; see the data dictionary
reserves.csv5 KBTabular export; see the data dictionary
review_growth_items.csv37 KBTabular export; see the data dictionary
review_options.csv38 KBTabular export; see the data dictionary
state.json10 KBState money map, trend and peer score
statewide_responses.csv2 KBTabular export; see the data dictionary
timeseries.csv6,914 KBHistory FY2014-15 to FY2024-25, one row per county, year and metric
verification_audit.csv101 KBTabular export; see the data dictionary

Data dictionary

All files are in data/. Data as of Nov 19, 2026. - Units: US dollars unless the field ends in _m ($ millions), _pct/pct_ (percent, 0-100) or share/ratio (fraction, 0-1). - Fiscal years: county FY runs Oct 1 to Sept 30. "FY2023-24" and "LFY2023-24" both mean Oct 1, 2023 to Sept 30, 2024. "FY24" in a field name means FY2023-24. Amendment 3 years: "2027-28"/"2728" means FY2027-28. - Source IDs (e.g. EDR_MET) are defined in counties.json → sources, each with a title and URL. - Join key: county / name is the county name exactly as in fl_counties.geojson → properties.name. fips is the 5-digit GEOID.

fl_counties.geojson

Field Meaning Source
properties.name County name (join key) GEO (Census 2023 cartographic boundary, 1:20M)
properties.geoid 5-digit state+county FIPS GEO
properties.fips 3-digit county FIPS GEO
properties.slug URL slug for /amendment-3/<slug>/ (no -county; matches SEO_SPEC §5.2, e.g. desoto, st-johns) derived
properties.slug_with_county Old <name>-county form; use only for 301 redirects to /amendment-3/<slug>/ derived
geometry Polygon/MultiPolygon, lon/lat (NAD83), 5 decimals GEO

counties.json

Top level: - last_updated; - red_flag_rules (public label "Items to review"; each rule has code, name, threshold, fy, source, url); - sources; - weights (health score weights); - medians (statewide medians used for scoring); - phase2: management weights, dollar-pie exclusions, peer tiers, statewide responses; - counties (keyed by name).

Per county (counties[<name>]):

Field Unit FY / as-of Source Meaning
name, fips text , GEO County name, FIPS
tier text Nov 2026 , Review depth: county-source cross-check vs statewide data only
review_status text Nov 2026 , Short form of tier
fiscally_constrained bool 2026 FCC On EDR's fiscally constrained county list
population_2025 persons Apr 1, 2025 POP Population estimate
population_change_2020_25 fraction 2020-2025 POP Population growth
a3.edr_county_gov. $ FY2026-27 to FY2031-32 EDR_A3 EDR estimate of the county-government levy reduction from Amendment 3 (county plus dependent districts and MSTUs)
a3.edr_all_local., .recurring $ FY2027-28 to FY2030-31 EDR_A3 All local governments in the county (incl. cities and special districts, excl. schools)
a3.fac.hx_, cap_, total_* $ FY2027-28, FY2028-29 FAC FAC estimate: homestead exemption part, assessment-cap part, total
a3.county_reported.{y1,y2,scope,src,primary} $ / text as stated source ID in src The county's own or news-reported estimate; y1/y2 = first/second year if given; primary = from a county document
a3.county_published.{text,url} text as stated url County-published statement
a3.pct_of_2025_levy_2829 fraction FY2028-29 vs 2025 levy EDR_A3, DOR25 EDR loss ÷ 2025 county-government levy
a3.share_of_fy24_operating_revenue_2829 fraction FY2028-29 vs FY2023-24 EDR_A3, LGFR EDR loss ÷ adjusted operating revenue (includes enterprise revenue such as airports, ports and utilities)
a3.per_resident_2829 $ FY2028-29 EDR_A3, POP EDR loss per resident
a3.mills_to_replace_2829 mills FY2028-29 EDR_A3, DOR_TV Millage needed on the post-A3 taxable base to replace the loss
taxpayer_side.* $ / count / fraction 2027, 2028 (2025 millage) STEPUP Homesteads (parcels), median assessed value, median $ saved in 2027 and 2028, 25th/75th percentile saving in 2028, share of homesteads owing no non-school tax in 2028, 2025 non-school millage
levy_2025.* $ 2025 tax roll DOR25 Taxes levied: county operating, county debt, dependent districts, MSTU, school, independent special districts, municipal, grand total, county-government total
levy_2023_county_gov $ 2023 roll DOR23 County-government levy, 2023
millage_2025.* mills 2025 DOR25 Millage rates by levy type; municipal_avg and total_avg are levy-weighted averages
taxable_value. $ 2015, 2020, 2024, 2025, 2026 (prelim.) DOR_TV County taxable value
operating_revenue_fy24.* $ FY2023-24 LGFR Total unadjusted revenue, other sources, excluded funds (custodial, internal service, pension/trust, component units), intergovernmental revenue, adjusted operating revenue
intergov_revenue. $ FY2018-19, 2020-21, 2023-24 LGFR Intergovernmental revenue
revenue_accounts_fy24.* $ FY2023-24 LGFR Selected revenue accounts: tourist tax, sales surtax, fuel taxes, half-cent sales tax, state revenue sharing, federal grants, state grants, communications services tax, franchise fees, impact fees, utility charges, public safety charges, special assessments
spending_by_function..fy15, .fy24 $ FY2014-15, FY2023-24 EDR_MET Spending by function (public_safety, physical_env, transportation, economic_env, human_services, culture_rec)
spending_by_function..early_real_pc, late_real_pc, real_pc_change $ per resident (2024 $), fraction FY2015-17 avg vs FY2022-24 avg EDR_MET, POP, CPI Inflation-adjusted per-resident spending and its change
debt..{go,enterprise,special_revenue,total} $ Sept 30, 2014 to 2025 EDR_MET (self-reported) Debt outstanding by type
debt_audit_check text FY2025 county audit Present where the audit disagrees with the state filing (e.g. St. Johns)
pension.npl, pension.basis $, text June 30, 2025 FRS (JAX_ACFR for Duval) Net pension liability, FRS + HIS proportionate share for all county-government employers
pension.frs.{pp_npl,his_npl,total,employers} $, list June 30, 2025 FRS Components and employer list
salary_benefit_share fraction FY2025-26 budget EDR_MET Salaries and benefits ÷ budget (null if not reported)
metrics.* various as named as above Scoring inputs: core real growth, debt and pension per resident, levy share of budget, A3 shock (EDR/FAC), taxable value per resident (before and after A3), millage headroom (10-mill cap minus county operating millage, before and after A3), intergovernmental share, grants, economic environment share
score.components. object , derived weight, value_before, value_after, points_before, points_after
score.{before,after,after_fac,drop} 0-100 , derived Health score before A3, after A3 (EDR), after A3 (FAC), drop
score.{rank_before,rank_after,rank_after_fac,rank_change} rank 1-67 , derived 1 = strongest
score.missing list , , Inputs missing for this county (weights rescaled)
map.treasury, inflows, outflows, assets, threats items {label, amount, fy, source} as given as given County money map nodes
red_flags list {rule, metric, threshold, fy, source} as given rule source Items to review
flags list , , Data notes and conflicts (e.g. EDR vs FAC differ by >25%)
why, what_a3_means, where_the_money_went text , derived from fields Narrative text
field_sources.* text , , Source ID per field group
management.* score 0-100, rank, flags, %, $ FY2023-24/FY2025 audits AG 2026-049, audits, EDR_MET, FRS Management score inputs: audit on time, no material weakness, no finding repeated three times, GF unrestricted % of spending plus transfers out, GF balance change %, real spending growth %, debt and pension per resident, coverage %
audit_screen.* FY, text latest audit (FY2025 or FY2024) county audits Material weakness, repeat findings, financial condition, screened flag
general_fund_verified.* %, $M latest audit county audits (hand-checked) GF unrestricted balance % of spending plus transfers out, balance change %, begin/end balance
dollar_pie_fy2324.total_m, .cents. $M, cents per $1 FY2023-24 EDR_MET Where each $1 goes (10 categories; exclusions in phase2.pie_excluded)
review_options.* list, $, % FY2023-24 derived Savings options to review: options, total $, EDR FY2028-29 gap, share of the gap, what is not measured
a3_hit.* $, % , rank inputs FY2028-29 EDR_A3, FAC Hit hardest/least inputs (EDR and FAC versions)
coding_checks. text FY2023-24 EDR_MET vs audit Accounts treated as possible coding changes
incentives_audit.* $, text FY2025 county audits (GASB 77) Tax abatements disclosed
county_responses list or "none found as of " since Nov 3, 2026 see url Same as county_responses.csv

state.json

State money map and trend. treasury, inflows, outflows, assets, threats items each carry label, amount ($ millions unless noted), fy, source. Also: - trend (10-year appropriations, with population and CPI benchmark); - score (peer rank on four Moody's FY2024 measures, with peer_medians); - red_flags (labeled Items to review); - pie data.

CSV files

File One row per Columns (unit) FY Source
counties.csv county fips; tier; fiscally_constrained; pop_2025; pop_change_2020_25; a3_edr_county_fy2728/2829 ($); a3_fac_fy2728/2829 ($); a3_edr_all_local_fy2829 ($); a3_pct_2025_levy_fy2829, a3_share_fy24_oper_rev_fy2829 (fraction); a3_per_resident_fy2829 ($); median_homestead_saving_2028 ($); homesteads; share_homesteads_no_nonschool_tax_2028; county_levy_2025 ($); county_operating_millage_2025 (mills); taxable_value_2025 ($); operating_revenue_fy2324 ($); property_tax_reliance (fraction); core_real_spending_growth (fraction); tax_supported_debt_2025 ($); pension_liability ($); score_before/after_edr/after_fac (0-100); red_flag_count and red_flags (items to review, all rules R1-R17); rank_before/after_edr/after_fac/rank_change; debt_total_2025_audited_or_reported ($, Sept 30, 2025) and debt_2025_basis (see debt_detail.csv); debt_per_resident_2025 ($); management_score (0-100) and management_rank; arpa_slfrf_allocation ($, Treasury, May 2021); sources as counties.json as counties.json
management_ranking.csv county score (0-100), rank, coverage_pct, audit_on_time (0/1), no_material_weakness (0/1), no_three_year_repeat (0/1), gf_unrestricted_pct, gf_balance_change_pct, real_spending_growth_pct, debt_per_resident ($), pension_per_resident ($) FY2023-24 audits filed; FY2025 GF; FY2015-17 to FY2022-24 growth; Sept 30, 2025 debt; June 30, 2025 pension AG 2026-049, audits, EDR_MET, FRS
a3_hit_rankings.csv county rank_pct_rev_page, rank_pct_levy_page, rank_per_res_page (rank); edr_2829, fac_2829 ($); pct_rev, pct_rev_fac, pct_levy, pct_levy_fac (%); per_res, per_res_fac ($); levy_share_rev (%); tv_pc ($); no_tax_share (%); millage (mills) FY2028-29 EDR_A3, FAC, LGFR, DOR, STEPUP
dollar_pie.csv county total_operating_spending_m ($M); 10 categories (cents per $1) FY2023-24 EDR_MET
budget_growth.csv county pop_fy2015, pop_fy2024; spend_fy2015_usd, spend_fy2024_usd; from_population_usd, from_inflation_usd, real_change_usd; real_per_resident_pct; driver1-3 name, excess_usd above population+inflation, coding_check (0/1); fed_grants_fy2015/2024_usd; arpa_fy2024_usd; salary_share_fy2026_pct; data_check LFY2014-15 vs LFY2023-24 EDR county account files, POP, CPI (237.017 to 313.689)
budget_growth_by_area.csv county × area fy2015_usd, fy2024_usd, above_pop_and_inflation_usd same same
budget_growth_reasons.csv county × driver driver, reason, source, status (documented / likely; needs account detail / not yet researched) as stated in reason budget books, audits, council auditor reports, news (named)
hillsborough_audit_check.csv item fy2015_audit, fy2024_audit_or_change, source FY2015 vs FY2024 Hillsborough CAFR/ACFR
potential_waste.csv county × item (label: Spending to review) rank, item, usd_per_year, why, evidence FY2023-24 unless stated derived from review_options, growth, incentives, audit items
review_options.csv county × option type, item, per_resident_rounded, peer_median_rounded ($), ratio_shown, amount_shown_usd, check_coding, amount_unrounded_usd, ratio_unrounded, tradeoff, legal FY2023-24 EDR_MET, peer tiers
review_growth_items.csv county × item type, item, growth_pct, amount_above_threshold_usd, cents_per_dollar, why, tradeoff, legal FY2014-15 to FY2023-24 EDR_MET
reserves.csv county unrestricted_pct, gf_balance_change_pct, begin_m, end_m ($M), note latest audit county audits (hand-checked)
audit_screen.csv county audit_fy, material_weakness, repeat_three_audits, new_flags FY2025 (FY2024 where noted) county audits
county_responses.csv response county, type (cut/plan/revenue/none), proposal, estimate, who, date, status, state_law, url, source_type since Nov 3, 2026 (some pre-vote planning) url
statewide_responses.csv response who, proposal, status, url Nov 2026 url
verification_audit.csv checked figure item, page value, source value, source URL, status (match / rounding / unverifiable / conflict), note Nov 19, 2026 independent re-check

Planned history files (in progress)

  • timeseries.csv: long format, FY2014-15 to FY2024-25. Columns: geo, geo_type (county, or state for "All counties" = sum of reporting counties), fips, fiscal_year (Oct-Sep, e.g. 2014-15), metric, value, unit, source, source_url, note, gap (1 = missing; for health_score_history, 1 = an input besides pension was missing, listed in note). Full method in methodology.md, "History".
metric unit source
county_government_levy USD DOR Data Book, Millage Rates and Taxes Levied (roll years 2018-2025)
county_operating_millage mills DOR Data Book, Millage Rates and Taxes Levied (roll years 2018-2025)
debt_outstanding_total USD EDR Local Government Financial Reporting data set with metrics (debt outstanding Sept 30, self-reported)
debt_tax_supported USD EDR Local Government Financial Reporting data set with metrics (debt outstanding Sept 30, self-reported)
gf_unrestricted_pct percent County audit (hand-checked)
health_rank_history rank 1-67 Derived
health_score_history 0-100 Derived (see methodology)
population persons EDR/BEBR April 1 estimate (via EDR financial data sets)
revenue_charges_for_services USD EDR county (and Jacksonville) revenues/expenditures by account code and fund type, LFY2005-06 to LFY2024-25
revenue_fines_misc_other USD EDR county (and Jacksonville) revenues/expenditures by account code and fund type, LFY2005-06 to LFY2024-25
revenue_grants USD EDR county (and Jacksonville) revenues/expenditures by account code and fund type, LFY2005-06 to LFY2024-25
revenue_operating_total USD EDR county (and Jacksonville) revenues/expenditures by account code and fund type, LFY2005-06 to LFY2024-25
revenue_other_intergovernmental USD EDR county (and Jacksonville) revenues/expenditures by account code and fund type, LFY2005-06 to LFY2024-25
revenue_other_local_taxes USD EDR county (and Jacksonville) revenues/expenditures by account code and fund type, LFY2005-06 to LFY2024-25
revenue_permits_fees_assessments USD EDR county (and Jacksonville) revenues/expenditures by account code and fund type, LFY2005-06 to LFY2024-25
revenue_property_tax USD EDR county (and Jacksonville) revenues/expenditures by account code and fund type, LFY2005-06 to LFY2024-25
revenue_sales_taxes USD EDR county (and Jacksonville) revenues/expenditures by account code and fund type, LFY2005-06 to LFY2024-25
revenue_state_shared USD EDR county (and Jacksonville) revenues/expenditures by account code and fund type, LFY2005-06 to LFY2024-25
score_input_core_real_growth fraction Derived
score_input_levy_share_of_budget fraction Derived
score_input_millage_headroom mills Derived
score_input_tax_supported_debt_pc USD per resident Derived
score_input_tv_pc USD per resident Derived
spending_core_functions USD EDR county (and Jacksonville) revenues/expenditures by account code and fund type, LFY2005-06 to LFY2024-25
spending_court_related USD EDR county (and Jacksonville) revenues/expenditures by account code and fund type, LFY2005-06 to LFY2024-25
spending_culture_recreation USD EDR county (and Jacksonville) revenues/expenditures by account code and fund type, LFY2005-06 to LFY2024-25
spending_debt_service_517 USD EDR county (and Jacksonville) revenues/expenditures by account code and fund type, LFY2005-06 to LFY2024-25
spending_economic_environment USD EDR county (and Jacksonville) revenues/expenditures by account code and fund type, LFY2005-06 to LFY2024-25
spending_general_government USD EDR county (and Jacksonville) revenues/expenditures by account code and fund type, LFY2005-06 to LFY2024-25
spending_human_services USD EDR county (and Jacksonville) revenues/expenditures by account code and fund type, LFY2005-06 to LFY2024-25
spending_other_uses_transfers USD EDR county (and Jacksonville) revenues/expenditures by account code and fund type, LFY2005-06 to LFY2024-25
spending_physical_environment USD EDR county (and Jacksonville) revenues/expenditures by account code and fund type, LFY2005-06 to LFY2024-25
spending_public_safety USD EDR county (and Jacksonville) revenues/expenditures by account code and fund type, LFY2005-06 to LFY2024-25
spending_transportation USD EDR county (and Jacksonville) revenues/expenditures by account code and fund type, LFY2005-06 to LFY2024-25
taxable_value USD DOR Property Tax Data Portal, County Taxable Value History
  • projects_timeline.csv: geo, year, date (YYYY-MM-DD where known), category, title, amount_usd (blank if not stated), amount_note, source, url, verified (yes/no). FEMA amounts: Public Assistance federal share obligated to local applicants in the county (state agencies and the AdventHealth system applicant excluded).

Debt files (added Nov 19, 2026)

debt_detail.csv (one row per county, fiscal year and measure)

column meaning
county County name (Duval = City of Jacksonville primary government)
fiscal_year Oct-Sep fiscal year, e.g. 2024-25
as_of Balance date for outstanding debt (Sept 30 of the fiscal year end)
measure debt_governmental, debt_business_type, debt_total, debt_per_resident, debt_service_principal, debt_service_interest, debt_service_total, debt_by_purpose
purpose For debt_by_purpose: roads_transportation, utilities, airports_ports, stadium_arena_convention_tourism, buildings, voter_approved_GO (purpose not itemized), general_capital (revenue debt, purpose not itemized), leases_subscriptions, other_obligation (listed, not counted in totals)
label Bond or note name as printed in the source
value_usd Dollars (per resident for debt_per_resident); blank = gap
basis audited (ACFR ten-year schedule), audited (audit long-term debt note), self-reported (EDR), or gap
source / source_url Document and link for the figure (Auditor General e-file copy of the audit or ACFR, or EDR data set)
note Scope notes, e.g. totals-only counties, Broward printed-total error, Clay bonds only, Sumter Villages agreement

Rules: one basis per county-year, chosen in order ACFR schedule, audit note, EDR; never mixed within a year. Governmental = governmental activities long-term debt (bonds, notes, loans, leases, subscriptions and premiums where the source includes them); business-type = enterprise debt. Pension, OPEB and compensated absences are excluded. Debt per resident uses the EDR/BEBR April 1 population for every county (it can differ from a county ACFR's own per-capita figure). Debt service = governmental funds principal + interest from the audited statement of revenues, expenditures and changes in fund balances or the ACFR ten-year schedule; 15 counties so far.

New timeseries.csv metrics

metric unit source
debt_governmental USD as debt_detail.csv (basis in note column)
debt_business_type USD as debt_detail.csv
debt_total_audited_or_reported USD as debt_detail.csv; gap = 1 where blank
debt_per_resident USD per resident derived: debt total / EDR population
debt_service_governmental USD county audit or ACFR ten-year schedule

The older debt_outstanding_total and debt_tax_supported metrics stay as the self-reported EDR series used by the health score.

incentives.csv (added Nov 19, 2026)

One row per county × fiscal year × measure. Columns: county, fiscal_year, measure, program_or_deal, value_usd, promised, delivered, cost_per_job, clawback_terms, review_note, source, source_url, note. | measure | meaning | fiscal year | source | |---|---|---|---| | edr_direct, edr_indirect, edr_fee_and_tax_based, edr_below_market_leases_deeds, edr_reported_total | Economic development incentives the county reported to EDR, by type (USD; 0 where the county wrote "None") | LFY2020-21 (latest EDR compilation, published June 2024) | EDR, Florida County & Municipal Economic Development Incentives: LFY 2020-21 Report | | edr_reported_total with blank value | Either "$0 or under $25,000" (EDR does not give the amount) or the county did not respond (Baker, Bradford, Broward, Columbia, Dixie, Franklin, Indian River, Jefferson, Levy, Monroe); see note. No response is not zero | LFY2020-21 | same | | audit_tax_abatements | Taxes abated under the county's own agreements, from the audit's GASB 77 tax abatement disclosure (16 counties report an amount) | FY2024-25 | county audit (Auditor General e-file copy) | | deal_promised_vs_delivered | Promised jobs/investment, delivered (published), cost per job, clawback or recovery terms, and reporting status, for the 10 largest programs reviewed (Miami-Dade, Orange, Hillsborough, Duval, Broward, Palm Beach, Pinellas, Polk, Lee, Osceola) | FY2024-25 | audits, county economic development reports, resolutions (source column) | The EDR county totals add to $341,191,911 ($333,994,269 for counties of 100,000+ and $7,197,642 for smaller counties), matching EDR's printed totals. Orange's $238.3M of fee and tax-based incentives could not be verified by EDR (review_note).

ARPA and new timeline categories (added Nov 19, 2026)

  • timeseries.csv metric arpa_slfrf_allocation (USD, fiscal_year 2020-21): Treasury State and Local Fiscal Recovery Funds allocation to the county government (Allocation for Counties, May 10, 2021). The note gives obligated and spent amounts and the largest expenditure category from the recipient's latest report in Treasury's April 2026 public data release. Duval: the City of Jacksonville reports its county ($186.0M) and city allocations together ($343.7M).
  • projects_timeline.csv new rows: one ARPA allocation row per county (category federal relief (pandemic), date 2021-05-10); 12 debt rows from FY2024-25 debt schedules: bond issue (year = the series year in the bond name), stadium/arena/convention debt (balance) and infrastructure agreement (balance) (year 2025, date 2025-09-30). For all 12, amount_usd is the balance outstanding on Sept 30, 2025, not the original issue amount.