Declaration record by year: recurring dividends, count, and days from declaration to ex-date

Name: Declaration record by year: recurring dividends, count, and days from declaration to ex-date
Creator: Strasmore
Published: 2026-08-03
License: https://www.strasmore.com/terms/

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-08-03, from When Companies Announce Dividend Raises.

as of 2026-08-03 table 11×5read in context →

Declaration record by year: recurring dividends, count, and days from declaration to ex-date — 11 rows by 5 columns, computed 2026-08-03 from US exchange, SIP and OPRA data.
year	company_count	declaration_count	declared_before_ex_pct	median_days_declared_to_ex
2016	7204	27027	99.8	11
2017	7857	28664	99.7	12
2018	9905	33822	99.7	20
2019	10163	33616	99.8	22
2020	9553	31704	99.8	17
2021	9940	33423	99.8	17
2022	10704	38093	98.9	20
2023	10893	39427	99.9	23
2024	11109	42063	100	35
2025	12220	45931	100	32
2026	10493	29319	100	29

Rows × columns: 11 × 5
Computed: 2026-08-03
Completeness: No missing values
Source: US exchange, SIP and OPRA market data
Licence: Strasmore terms · free, no signup
Formats: JSON · CSV · the SQL below

What each column holds

Column definitions for Declaration record by year: recurring dividends, count, and days from declaration to ex-date, derived from the stored result.
Column	Type	Range	Notes
`year`	number	2,016 to 2,026
`company_count`	number	7,204 to 12,220	count
`declaration_count`	number	27,027 to 45,931	count
`declared_before_ex_pct`	number	98.9 to 100	percent
`median_days_declared_to_ex`	number	11 to 35

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on 2026-08-03, and the query below is what returned them.

the exact SQL behind every number

SELECT toYear(declaration_date) AS year,
       uniqExact(ticker) AS company_count,
       count() AS declaration_count,
       round(100 * countIf(declaration_date <= ex_dividend_date) / count(), 1) AS declared_before_ex_pct,
       round(quantileDeterministic(0.5)(dateDiff('day', declaration_date, ex_dividend_date),
                                        cityHash64(ticker))) AS median_days_declared_to_ex
FROM global_markets.stocks_dividends
WHERE distribution_type = 'recurring'
  AND cash_amount > 0
  AND declaration_date > toDate('2015-12-31')
  AND declaration_date <= toDate('2026-07-31')
  AND ex_dividend_date > toDate('2015-12-31')
GROUP BY year
ORDER BY year

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisWhen Companies Announce Dividend Raises

JNJ dividend raises: declaration date, old rate, new rate, 2016 to 2026 table 11×5 → Dividend raises by declaration month: US recurring quarterly payers, July 2015 to July 2026 ranking 12×3 → Typical raise month by company: twelve dividend growers, raises since 2016 series 12×5 → Share of annual raises declared in the same month as the prior raise, by year ranking 10×4 → Verizon (VZ) dividend increases: declaration date, ex dividend date, and step size table 13×5 → Verizon (VZ) dividends per share by calendar year, 2005 to 2025 ranking 21×4 → See all 2,170 queries →