Total Revenue for 51111: Newspaper Publishers, Establishments Subject to Federal Income Tax (REV51111TMSA) | FRED | St. Louis Fed
- Rows
- 80
- Columns
- 2
- Data range
- 2006-07-01 to 2026-04-01
- Last refreshed with new data
- 2026-10-07
Graph and download economic data for Total Revenue for 51111: Newspaper Publishers, Establishments Subject to Federal Income Tax (REV51111TMSA) from Q3 2006 to Q1 2026 about periodicals, printing, revenue, establishments, tax, federal, income, and USA.
AI analysis
Data Analysis: Newspaper Publishers Revenue (REV51111TMSA)
1. Dataset Overview and Value
This dataset, sourced from FRED (Federal Reserve Bank of St. Louis) via fredgraph.csv?id=REV51111TMSA, tracks quarterly total revenue for NAICS code 51111 (Newspaper Publishers) among establishments subject to federal income tax. Spanning Q3 2006 to Q1 2026 (79 quarterly observations), this series is notable for its long time horizon covering the pre-recession peak, the 2008-2009 financial crisis, the ongoing structural decline of print media, and the COVID-19 disruption period. As an official government-aggregated economic indicator, it offers high reliability for time-series and correlation work. However, I'd flag a curiosity: the series extends to Q1 2026, which is beyond the typical present-day FRED release schedule for lagged Census Bureau revenue data — this may indicate forecasted/projected values, a data refresh artifact, or a placeholder that warrants verification before use in analysis. The tagged "Healthcare Prices" topic also seems mismatched to the actual subject matter (newspaper publishing revenue), suggesting a possible metadata/categorization error in the source system.
2. Data Quality Observations
Data quality appears strong at first glance: zero null cells across both columns and zero missing values in either observationdate (79 distinct values, matching row count exactly) or REV51111TMSA (78 distinct values out of 79 rows). The single non-unique value in the revenue column is expected and benign — it simply indicates two quarters share an identical revenue figure, not a data quality defect. The duplicate-row check is listed as pending recomputation ("Phase D"), so overall duplication status is not yet confirmed and should be validated before downstream use. No type mismatches are reported. The sample data rows are also not yet populated, limiting my ability to visually inspect raw values, so I'd recommend pulling a few sample rows directly from the source CSV before finalizing any analysis pipeline.
3. Key Column Distributions
The revenue column (REV51111TMSA, in millions of dollars, unadjusted) shows a mean of $7,218.24M against a lower median of $6,501M — this gap, combined with a skewness of 1.39 (moderately right-skewed), indicates the distribution is pulled upward by a cluster of higher values, almost certainly reflecting the earlier, healthier years of newspaper revenue (2006-2008) before the industry's secular decline. The interquartile range ($5,759M–$7,926M) captures the bulk of "post-decline" observations, while the 7 flagged outliers likely correspond to the pre-crisis peak years when print revenue was substantially higher (max = $12,208M) relative to the recent trough (min = $5,142M). This spread — a 2.4x ratio between max and min — underscores a strong secular downward trend rather than noisy fluctuation, meaning any correlation analysis should account for trend/non-stationarity (e.g., via differencing or detrending) rather than treating this as a stationary series.
4. Recommended Join Key
observationdate is the clear and only viable join key. It's a clean, fully-populated (0 nulls, 79 distinct values) quarterly date field spanning nearly 20 years, making it straightforward to align with other quarterly or monthly macroeconomic series (monthly data would require aggregation/resampling to quarterly frequency first).
5. Suggested Pairings for Correlation Analysis
Given the print media revenue decline narrative, valuable correlation partners include: (a) digital advertising revenue indices or Internet Publishing (NAICS 51913-related) revenue series to quantify the print-to-digital substitution effect; (b) broader advertising expenditure indices (e.g., total U.S. ad spend) to separate industry-specific decline from cyclical ad-market weakness; (c) macroeconomic indicators like GDP, CPI, or PCE to test cyclicality; (d) newsprint/paper commodity prices as a cost-side input; and (e) employment data for the publishing/media sector (e.g., BLS CES series) to see whether revenue declines track workforce reductions. Given the topic tag mentions "Healthcare Prices," it's worth double-checking whether this dataset was miscategorized alongside a healthcare CPI series — if so, correlating it with medical care CPI would likely yield spurious or irrelevant results and should be avoided unless the linkage is intentional and justified.
Columns
- observation_date (date)
- REV51111TMSA (integer)