NNDSS Measles Imported Cases Table
- Rows
- 3,710
- Columns
- 31
- Data range
- 2020-01-01 to 2020-01-01
- Auto-refresh
- Re-checks its source every 7 days
Provisional notifiable disease data including measles imported cases, weekly time-series.
AI analysis
Dataset Analysis: NNDSS Measles Imported Cases Table
1. Dataset Representation and Value
This dataset originates from the CDC's National Notifiable Diseases Surveillance System (NNDSS), sourced directly via API from data.cdc.gov (view ID 7xhe-mv2e). This is an authoritative, government-published surveillance feed, which lends it high credibility for epidemiological correlation work. The "provisional" designation in the description signals that figures are preliminary and subject to revision — important caveat for any downstream analysis. Interestingly, the table bundles two distinct diseases (Malaria and Measles, both Imported and Indigenous strains) into one wide-format weekly time series across 70 reporting areas, with MMWR week as the temporal join key. This structure has real value for studying imported-disease patterns alongside domestic spread, and for cross-referencing against travel, immunization, or outbreak datasets — but the join-key date range collapsing to a single timestamp (2020-01-01 to 2020-01-01) is suspicious and should be verified before treating MMWR Year as a usable date field.
2. Data Quality Observations
Data quality is a significant concern here. Across 31 columns, there are 49,025 null cells — averaging roughly 1,580 nulls per column on a 3,710-row table, meaning many columns are majority-empty. The worst offenders are extreme: "Malaria, Previous 52 weeks Max†, flag" is 100% null (3,710/3,710), making it entirely non-informative and a candidate for removal. "Measles§, Imported, Current week" (99.8% null) and "Measles§, Indigenous, Current week" (99.7% null) are likewise almost entirely empty — these "current week" count fields appear to only populate during active case weeks, which is epidemiologically plausible (most weeks have zero imported/indigenous cases reported) but functionally means these columns are nearly useless for row-level analysis without imputing zeros. Notably, the "Current week" measles fields are typed as String rather than Integer (unlike their Malaria counterparts), suggesting inconsistent typing/encoding (possibly mixing numeric values with placeholder text) that will require cleaning before any quantitative use. The duplicate-row count field is marked pending Phase D recomputation, so completeness of dedup cannot yet be confirmed — this should be resolved before final correlation work.
3. Key Columns and Distributions
The cumulative case columns show heavy right-skew typical of disease surveillance data. "Malaria, Cum 2019†" has mean=66.8 vs. median=12 (σ=213.2, skew=6.3, 309 outliers) — a small number of reporting areas are driving extreme cumulative totals. "Malaria, Cum 2020†" shows a similar but less extreme pattern (mean=23.0, median=6, skew=4.4). The Measles Indigenous Cum 2019 column is particularly striking: mean=110.4, median=6, σ=269.4, with values ranging 0–1,192 — indicating a few outbreak hotspots (likely large indigenous transmission events) skew the entire distribution. By contrast, "Measles, Imported, Cum 2020†" is comparatively well-behaved (mean=1.77, median=1, skew=1.46, Q1=1/Q3=2), reflecting that imported cases are sporadic, low-count events rather than outbreak-driven. MMWR Week itself is uniformly distributed as expected (min=1, max=53, mean=median=27, skew≈0), confirming even weekly coverage across the year.
4. Recommended Join Keys
For cross-dataset correlation, the strongest candidates are: - MMWR Year + MMWR Week — standard CDC epidemiological time key, ideal for aligning with other NNDSS tables or weekly health/travel datasets. - Reporting Area (70 distinct values) — likely state/territory-level, useful for joining with state-level demographic, vaccination, or travel datasets. - Reporting Area Sort — appears to encode a year+area composite (values like 2.02001E+07), distinct=3,710 (unique per row), making it a reliable row-level surrogate key but not for cross-table joins. - Location 1 / Location 2 / New Georeferenced Column — useful for geographic joins if Location 1 maps cleanly to state/country names (55 distinct values), pending null-rate check (Location 1 is 21% null).
5. Suggested Pairing Datasets
To build meaningful correlation studies, pair this with: (1) CDC vaccination coverage data (MMR vaccination rates by state) to test the inverse relationship between immunization and indigenous measles spread; (2) International travel/immigration volume data by origin country, given the "Imported" case classification, to correlate travel patterns with imported case spikes; (3) CDC WONDER or NNDSS tables for other diseases (e.g., mumps, rubella) sharing the same MMWR week/reporting area schema for multi-disease outbreak correlation; and (4) CDC outbreak/news event datasets to validate whether the extreme indigenous case outliers align with documented 2019 measles outbreaks (e.g., the well-known NY/Washington outbreaks).
Columns
- MMWR Year (date)
- MMWR Week (integer)
- Reporting Area (string)
- Malaria, Current week (integer)
- Malaria, Current week, flag (string)
- Malaria, Previous 52 weeks Max† (integer)
- Malaria, Previous 52 weeks Max†, flag (string)
- Malaria, Cum 2020† (integer)
- Malaria, Cum 2020†, flag (string)
- Malaria, Cum 2019† (integer)
- Malaria, Cum 2019†, flag (string)
- Measles§, Imported, Current week (string)
- Measles§, Imported, Current week, flag (string)
- Measles§, Imported, Previous 52 weeks Max† (integer)
- Measles§, Imported, Previous 52 weeks Max†, flag (string)
- Measles§, Imported, Cum 2020† (integer)
- Measles§, Imported, Cum 2020†, flag (string)
- Measles§, Imported, Cum 2019† (integer)
- Measles§, Imported, Cum 2019†, flag (string)
- Measles§, Indigenous, Current week (string)
- Measles§, Indigenous, Current week, flag (string)
- Measles§, Indigenous, Previous 52 weeks Max† (integer)
- Measles§, Indigenous, Previous 52 weeks Max†, flag (string)
- Measles§, Indigenous, Cum 2020† (integer)
- Measles§, Indigenous, Cum 2020†, flag (string)
- Measles§, Indigenous, Cum 2019† (integer)
- Measles§, Indigenous, Cum 2019†, flag (string)
- Location 1 (string)
- Location 2 (string)
- Reporting Area Sort (integer)
- New Georeferenced Column (string)