U.S. Granted Patents: Total Patents Originating in Connecticut (PATENTUSCTTOTAL) | FRED | St. Louis Fed
- Rows
- 29
- Columns
- 2
- Data range
- 1992-01-01 to 2020-01-01
Graph and download economic data for U.S. Granted Patents: Total Patents Originating in Connecticut (PATENTUSCTTOTAL) from 1992 to 2020 about patent granted, patents, intellectual property, origination, CT, and USA.
AI analysis
Data Analysis: U.S. Granted Patents Originating in Connecticut
1. Dataset Overview and Value
This dataset, sourced from the Federal Reserve Bank of St. Louis's FRED database (via fredgraph.csv?id=PATENTUSCTTOTAL), tracks the annual count of U.S. granted patents originating in Connecticut from 1992 to 2020. As a FRED-hosted series, it benefits from institutional credibility and standardized formatting, though the underlying data likely originates from the USPTO. The 29-year annual time series makes it well-suited for longitudinal correlation studies — particularly for examining relationships between innovation output and state-level economic indicators (GDP, R&D spending, employment in manufacturing/tech sectors). Since FRED aggregates thousands of comparable state- and country-level economic series, this dataset's real value lies in its compatibility with FRED's broader ecosystem for multi-variate regional economic analysis.
2. Data Quality Observations
The dataset shows strong quality fundamentals for its small size: zero null cells across both columns and zero missing observations in the 29-row series. The duplicate-row check is flagged as pending recomputation ("Phase D"), so that should be verified before finalizing any analysis, though with only 29 expected annual rows (one per year, 1992–2020), duplication risk is low and easily auditable manually. One minor data-integrity note: the PATENTUSCTTOTAL column has 28 distinct values across 29 rows, meaning one year repeats a value seen elsewhere — this is very plausible for count data at this scale and likely not an error, but worth a quick manual spot-check.
3. Key Column Distributions
The PATENTUSCTTOTAL column ranges from 1,595 to 3,561 patents/year, with a mean of 2,121 and median of 2,026 — the mean exceeding the median suggests a right-skewed distribution, confirmed by the skewness coefficient of 1.44 (moderately/strongly positive skew). This aligns with a plausible real-world pattern: patent counts likely stayed in a lower band for years before a surge (e.g., in the 2010s tech/biotech boom), pulling the tail rightward. The IQR (Q1=1,722, Q3=2,367) spans about 645 patents, while the full range spans 1,966 — indicating the 2 flagged outliers (likely peak years) sit well above Q3. The standard deviation (σ=525.5) is substantial relative to the mean, signaling meaningful year-over-year volatility rather than a flat trend.
4. Recommended Join Keys
The observationdate column (Date type, zero nulls, 29 distinct values) is the clear and only viable join key. Since it's annual data stamped at January 1 of each year, it will need to be normalized (e.g., extracting just the year) to join cleanly with other FRED series that may use quarterly or monthly date stamps. Analysts should confirm date alignment conventions (start-of-period vs. end-of-period) when merging with series of different frequencies.
5. Complementary Datasets for Correlation Analysis
Strong pairing candidates include: (1) Connecticut-specific economic indicators on FRED, such as state GDP (CTNGSP), unemployment rate, or manufacturing employment; (2) R&D expenditure data by state or industry, to test innovation-input vs. patent-output relationships; (3) national patent totals or other states' patent series (e.g., Massachusetts, California) for comparative regional innovation benchmarking; (4) venture capital investment or business formation data in Connecticut, which may lead or lag patent grants; and (5) sector-specific indices (aerospace, pharmaceuticals, insurance-tech) given Connecticut's known industry concentrations, to explore whether patent surges correlate with specific sector booms.
Columns
- observation_date (date)
- PATENTUSCTTOTAL (integer)