All Employees: Retail Trade: Book Stores and News Dealers in California (DISCONTINUED) (SMU06000004245120001) | FRED | St. Louis Fed
- Rows
- 396
- Columns
- 2
- Data range
- 1990-01-01 to 2022-12-01
Graph and download economic data for All Employees: Retail Trade: Book Stores and News Dealers in California (DISCONTINUED) (SMU06000004245120001) from Jan 1990 to Dec 2022 about musical, periodicals, book, retail trade, CA, sales, retail, employment, and USA.
AI analysis
Dataset Analysis: Book Stores and News Dealers Employment in California
1. Dataset Overview and Value
This series (SMU06000004245120001) tracks monthly employment counts (in thousands) at book stores and news dealers within California's retail trade sector, spanning January 1990 to December 2022 — a robust 33-year monthly time series with 396 observations. Sourced directly from the St. Louis Fed's FRED API (https://fred.stlouisfed.org/graph/fredgraph.csv?id=SMU06000004245120001), this is a highly authoritative, publicly vetted data feed maintained by a leading economic research institution. Notably, the series is marked "DISCONTINUED", meaning no new observations will be added past Dec 2022 — this caps its usefulness for forward-looking or real-time correlation work but makes it valuable for historical retrospective analysis, particularly around structural shifts in retail (e.g., the rise of e-commerce, Amazon's impact on brick-and-mortar booksellers, and the 2008 recession).
2. Data Quality Observations
Data quality here is strong on the surface: zero null cells across both columns and zero missing observation dates (396 distinct dates matching 396 rows, indicating no gaps in the monthly cadence). The duplicate-row check is flagged as pending recomputation ("Phase D — recomputed against Parquet"), so that should be verified before final use, but no red flags are currently visible. One structural quirk worth noting: the value column shows only 184 distinct values against 396 rows — meaning many months share identical employment counts. This is plausible for a niche, slow-moving employment subsector reported in whole/rounded units, but it's worth confirming this isn't an artifact of data imputation or carried-forward values (a common issue in discontinued or thinly-tracked BLS series).
3. Key Column Distributions
The core metric ranges from a low of 3.6 to a high of 37.8 (thousands of employees), with a mean of 22.54 and median of 26.65 — the mean sitting notably below the median signals a left skew, confirmed by the skewness statistic of -0.227 (mild negative/left skew). This suggests a longer tail of lower employment values, consistent with a secular decline story: the sector likely sustained higher employment (clustering near the 26–33 range, per Q1=10.3/Q3=32.6) for a long stretch before declining toward the 3.6–10 range in later years as bookstores and newsstands contracted. The wide IQR (10.3 to 32.6) and high standard deviation (10.76) relative to the mean indicate substantial volatility/trend movement over the three decades — this is a series with real structural change, not just noise, making it interesting for trend-break and regime-change analysis.
4. Recommended Join Keys
The observationdate column is the clear and only viable join key — it's a clean monthly date field with zero nulls and full distinctness (396/396). For cross-dataset correlation, standardize on month-start timestamps (YYYY-MM-01) to align with other FRED series, which overwhelmingly use this same convention. Analysts should also consider truncating to year-quarter or year granularity if pairing with lower-frequency datasets (e.g., annual retail sales or Census data).
5. Suggested Pairings for Correlation Analysis
Given the "Healthcare Prices" topic tag seems mismatched to this retail employment series (likely a taxonomy/categorization artifact worth flagging), better analytical pairings would include: (a) other California retail employment subsectors (e.g., general merchandise, clothing stores) from the same SMU series family to contextualize whether the decline is sector-specific or part of a broader retail contraction; (b) e-commerce/online retail sales indices (e.g., FRED's ECOMSA or Census Bureau e-commerce data) to test the Amazon-displacement hypothesis; (c) US total book store employment (national analog series) to see if California led or lagged the national trend; and (d) California unemployment rate or total nonfarm payrolls to normalize for broader macroeconomic cycles versus sector-specific decline. Given the discontinuation and left-skewed decline pattern, this series is best used as a historical case study in retail disruption rather than for ongoing monitoring.
Columns
- observation_date (date)
- SMU06000004245120001 (decimal)