Breakdown of Revenue by Media Type: Newspapers - Print Newspapers for Newspaper Publishers, All Establishments, Employer Firms (RPCMPNEF51111ALLEST) | FRED | St. Louis Fed
- Rows
- 9
- Columns
- 2
- Data range
- 2013-01-01 to 2021-01-01
Graph and download economic data for Breakdown of Revenue by Media Type: Newspapers - Print Newspapers for Newspaper Publishers, All Establishments, Employer Firms (RPCMPNEF51111ALLEST) from 2013 to 2021 about periodicals, printing, employer firms, accounting, revenue, establishments, services, and USA.
AI analysis
Dataset Analysis: Newspaper Publisher Print Revenue (RPCMPNEF51111ALLEST)
1. Dataset Overview and Source Context
This dataset, sourced from FRED (Federal Reserve Bank of St. Louis) via their public API (fredgraph.csv), tracks annual revenue generated specifically from print newspaper products by newspaper publishers (NAICS 51111) across all employer-firm establishments in the U.S. The data spans 2013–2021, a period covering significant secular decline in print media consumption, making it valuable for studying structural shifts in the media/publishing economy. As a FRED-hosted series, the data is vetted, stable, and sourced ultimately from the U.S. Census Bureau's Service Annual Survey — a reputable, methodologically consistent government source suitable for longitudinal economic research. Its narrow scope (single metric, annual frequency) makes it most useful as a satellite series to be joined against broader economic or industry indicators rather than a standalone analytical dataset.
2. Data Quality Observations
Data quality here is excellent on the surface: zero null cells across both columns, and both observationdate and the revenue metric show 9 distinct values matching 9 total rows — indicating no duplication and one clean observation per year. There are no type mismatches (date column properly typed as Date, revenue as Integer). The main caveat is not a quality flaw per se but a structural limitation: with only 9 annual observations, this is a very low-N series. Statistical measures (skewness, quartiles) should be interpreted cautiously given the small sample size, and any correlation analysis will have limited degrees of freedom, increasing the risk of spurious or unstable correlation coefficients.
3. Key Column Distributions
The revenue column (RPCMPNEF51111ALLEST) ranges from a minimum of 12,824 to a maximum of 21,456, with a mean of 17,213 and a median of 17,679 — the mean sitting slightly below the median, consistent with the mild negative skew of -0.148, suggesting a modest left tail (likely reflecting the later-year revenue declines pulling the distribution down slightly). The interquartile range (Q1=14,679, Q3=19,171) spans roughly 4,492 units, a substantial relative spread (~26% of the mean), reflecting real volatility/decline over the observation window rather than noise. The standard deviation of 3,003.49 relative to the mean indicates a coefficient of variation of ~17%, moderate dispersion for a 9-point annual series. No outlier counts are flagged, and the tight distinct-count match (9 distinct values, 9 rows) confirms no repeated or stale readings.
4. Recommended Join Keys
The clear join key is observationdate, given its role as the designated Join Key with zero nulls and full distinct coverage of the time range (2013-01-01 to 2021-01-01). Since this is annual data, joins should be performed at year-level granularity — either by truncating higher-frequency series (monthly/quarterly) to annual aggregates or by matching on the year component of the date field. Analysts should be cautious about direct date-equality joins with other FRED series that may use different day-of-month conventions (e.g., some series stamp mid-year or fiscal year-end dates).
5. Suggested Complementary Datasets
To contextualize this print revenue decline, pair this series with: (1) digital advertising revenue series (e.g., FRED's online/digital media revenue equivalents, or IAB/PwC ad spend data) to quantify the print-to-digital substitution effect; (2) newspaper employment and establishment counts (BLS QCEW or FRED employment series for NAICS 51111) to correlate revenue decline with workforce contraction; (3) broader advertising expenditure indices or GDP-level media sector output to normalize for macroeconomic cycles (e.g., the 2020 pandemic dip); and (4) broadband/internet penetration or smartphone adoption rates as a demand-side driver of the print-to-digital shift. Given the "Healthcare Prices" topic tag attached to this dataset (which appears mismatched to its actual content), analysts should also verify topic/category metadata before assuming thematic relevance in automated cross-dataset correlation pipelines.
Columns
- observation_date (date)
- RPCMPNEF51111ALLEST (integer)