Raw sources
Raw sources (bronze)
Rows from every feed, stored exactly as received. Normalisation happens in the silver layer, where each change is flagged.
ENREnrollment
43,101
raw rows
- Usable
- 42,871
- Flagged
- 84%
- No member ID
- 2%
- Linked
- 29,405
- First seen
- 2026-01-01
- Last seen
- 2026-10-18
CLMClaims
32,829
raw rows
- Usable
- 32,674
- Flagged
- 74%
- No member ID
- 35%
- Linked
- 30,209
- First seen
- 2026-01-01
- Last seen
- 2026-10-18
TPAThird-party administrator
14,474
raw rows
- Usable
- 14,404
- Flagged
- 77%
- No member ID
- 85%
- Linked
- 11,671
- First seen
- 2026-01-01
- Last seen
- 2026-10-18
PRVProvider network
9,596
raw rows
- Usable
- 9,546
- Flagged
- 80%
- No member ID
- 50%
- Linked
- 8,676
- First seen
- 2026-01-01
- Last seen
- 2026-10-18
Raw events
Third-party administrator only, ordered by line number
| Source | Record | Received | First | Middle | Last | DOB | Member ID | SSN | Phone | Address | City | State | ZIP | Group | Plan | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TPA | TPA-54835 | 2026-09-13T15:32:08Z | Priya | — | Rivera | 1991-01-18 | null | - | (631) 676-8422 | UNKNOWN | — | UNKNOWN | N/A | — | N/A | UNKNOWN |
| TPA | TPA-60460 | 2026-02-15T15:41:48Z | SANDRA | — | VASQUEZ | 1938-09-12 | — | — | null | UNKNOWN | 5203 CHURCH STREET | Dallas | TX | 75283 | — | NULL |
| TPA | TPA-62889 | 2026-03-25T00:57:44Z | elizabeth·· | — | olson | 1946-11-20·· | - | •••-••-3660 | 5755586667 | N/A | - | — | N/A | UNKNOWN | UNKNOWN | null |
| TPA | TPA-58186 | 2026-06-12T05:53:55Z | Sophia | — | Snider | 04/09/43 | null | ·· | 16444799872 | N/A | 9603 Jefferson Avenue | Fresno | CA | 93747 | GRP-8883 | ·CHOICE-PLUS-PPO |
| TPA | TPA-51250 | 2026-05-27T13:44:02Z | Jonathan·· | — | Greene | 1952-11-14 | NULL | — | — | N/A | NULL | — | — | NULL | GRP-2838 | NAVIGATE-HMO |
| TPA | TPA-52567 | 2026-07-29T18:19:18Z | emily | — | bredley | 2005-11-03 | — | UNKNOWN | NULL | NULL | 1546 Bayshore Dr·· | Chandler | AZ | N/A·· | — | N/A |
| TPA | TPA-58983 | 2026-05-07T23:27:51Z | JERRY | — | MARTIN | 19390308 | null | ·N/A | ···· | UNKNOWN | 8116 Ridge Rd | Nashville | TN | 37256 | GRP-2178 | — |
| TPA | TPA-52028 | 2026-10-15T23:22:38Z | angela | — | chapman | May 15, 1938 | null | null | 489-936-2928 | — | 2648 Cedar Lane | SAN ANTONIO | Texas | 78264 | — | NAVIGATE-HMO |
| TPA | TPA-53949 | 2026-09-01T03:35:59Z | Jennifer | — | Scott | 19990426 | UHC-64421-36 | N/A | - | ·· | null | NULL | NULL | null | GRP-2849 | N/A |
| TPA | TPA-61766 | 2026-02-03T15:42:58Z | Roy | — | Duncan | 1974-12-12·· | — | •••-••-0325 | — | N/A | 6138 Grand Ave | Sacramento·· | CA | 95879 | — | ···· |
| TPA | TPA-54795 | 2026-07-04T22:41:58Z | Lawrence | — | Ortega | 1984-07-09 | UNKNOWN | - | ·- | — | - | — | - | — | null | OPTIONS-PPO |
| TPA | TPA-64456 | 2026-07-30T16:42:14Z | Payne, Mason | V | — | 1979-11-17 | NULL | •••-••-4012 | 3238353551 | - | 5013 Forest Avenue | Atlanta | GA | 30385 | GRP-5351 | CORE-HMO |
| TPA | TPA-53099 | 2026-09-03T05:34:42Z | Alexander | — | Yang | 2004-01-15 | N/A | •••-••-1960 | null | — | 9877 Lake View Road | Seattle | WA | 98168 | NULL | null |
| TPA | TPA-63481 | 2026-01-01T15:26:55Z | Paul | — | Chapman | 01/24/93 | — | — | — | N/A | 9135 CEDAR LN | ·Las Vegas | NV | 89141 | N/A | MEDICARE-ADV-A |
| TPA | TPA-54601 | 2026-09-11T17:55:23Z | KATHLEEN | — | BERRY | Aug 18, 1952 | - | — | 2624806532 | — | 5038 River Road | PHOENIX | AZ | 85046 | — | — |
| TPA | TPA-50957 | 2026-05-18T15:00:57Z | kimberly | — | ·west | 24-09-1987 | - | NULL | 4456279·· | NULL | 1188 Pine Dr | ·Los Angeles | CA | 90005 | null | UNKNOWN |
| TPA | TPA-61205 | 2026-02-09T12:26:37Z | Shirley | — | Cruz | 1951-11-28 | NULL | ···· | (768) 636-8459 | N/A | 7029 Ridge Rd | Tampa | FL | 33643 | NULL | null |
| TPA | TPA-53926 | 2026-02-11T19:17:43Z | ARJUN | — | ·RIOS | 1960-01-03 | N/A | — | NULL | — | 5434 Union Street | Chandler | AZ | 85290 | - | ···· |
| TPA | TPA-56343 | 2026-05-01T01:19:22Z | HELEN·· | — | MILLER | 1943-07-10 | UHC-95414-30 | null·· | 8158995654 | — | 6351 Lake View Rd | Tucson | AZ | 85764 | — | null |
| TPA | TPA-59523 | 2026-07-05T16:14:15Z | Grant, Pamela | — | — | 06/15/1949 | UHC-93251-47 | NULL·· | ·null | PAMELA.GRANT@PROTON.ME | 6343 Maple Ave | DENVER | CO | 80235 | NULL | — |
| TPA | TPA-58295 | 2026-10-08T09:02:08Z | Nanccy | N. | Morgan | 1988-01-04 | — | N/A | — | nancy.morgan1@gmail.com | 1598 CANYON RD | MINNEAPOLIS | MN | NULL | NULL | — |
| TPA | TPA-52077 | 2026-07-17T16:14:38Z | Natalie | — | Welch | 1981-10-07 | UHC-77444-76 | — | NULL | UNKNOWN | 218 VALLEY VIEW DRIVE | Tempe | AZ | 85274 | — | NAVIGATE-HMO |
| TPA | TPA-58503 | 2026-04-23T03:35:52Z | Shirley | — | ·Wheeler | 1995-08-12 | — | •••-••-8581 | — | - | 8363 SAGE COURT | Tucson | Arizona | 85701 | NULL | MEDICARE-ADV-A |
| TPA | TPA-51940 | 2026-06-14T03:06:26Z | LARRY | — | MARTIN | Jan 13, 2001 | null | null | — | N/A·· | 4620 Valley View Drive Apt 1 | San Antonio | Texas·· | 78256 | — | — |
| TPA | TPA-58012 | 2026-07-17T03:48:34Z | MARIA | R·· | WALSH | 4/18/1973 | UNKNOWN·· | null | 15337938631 | — | 581 Sunset Blvd | Tampa | FL | 33685 | - | NAVIGATE-HMO |
| TPA | TPA-60074 | 2026-10-01T18:15:31Z | Tony·· | — | ·Hunter | 2/28/2003 | — | •••-••-5940 | 14328052034 | ·· | 7734 Desert Sky Boulevard | Atlanta | ga | 30338 | — | ·· |
| TPA | TPA-50200 | 2026-09-13T06:23:01Z | PHILIP | B | MENDEZ | 2005-08-23 | N/A | UNKNOWN | NULL | — | 7910 WILLOW COURT | NASHVILLE | TN | 37219-2459 | ·GRP-1803 | NULL |
| TPA | TPA-64438 | 2026-05-19T19:38:58Z | Ana | — | Adams | 1999-09-22 | — | — | — | ·NULL | 8157 Harbor Boulevard | Orlando | FL | 32887 | - | ·NAVIGATE-HMO |
| TPA | TPA-52408 | 2026-08-06T13:19:47Z | ALICE | — | KELLEY | 1985-01-09 | UHC-90765-03 | null | null | — | 666 Elm St | TEMPE | AZ | 85286 | UNKNOWN | — |
| TPA | TPA-57833 | 2026-07-21T17:15:04Z | Gregory | — | Lopez | 03/15/1942 | UHC-33423-97 | — | N/A | N/A | 9239 Market St | Charlotte | NC | 28231 | GRP-9952 | — |
| TPA | TPA-62567 | 2026-08-30T14:37:59Z | KELLY | — | PIERCE | 1975-11-01 | — | •••-••-5575 | (941) 770-4876·· | — | 7028 Mesa Dr | Plano | Texas | 75002-2915 | UNKNOWN | — |
| TPA | TPA-50476 | 2026-06-14T17:54:58Z | Sofia | — | Dominguez | 1951-12-27 | UHC-86327-43 | •••-••-4460 | NULL | — | N/A | N/A | null | - | GRP-5338 | CORE-HMO |
| TPA | TPA-55837 | 2026-07-16T17:48:38Z | Graace | — | Maldonado | NULL | null | — | — | NULL | 6552 Baseline Rd | Jacksonville | FL | 32265 | GRP-0358 | CHOICE-PLUS-PPO |
| TPA | TPA-58847 | 2026-05-21T14:21:33Z | MADISON | B | HENDERSON | 1985-12-16 | NULL | - | UNKNOWN | N/A | 2197 Highland Ave | San Diego | CA | - | — | N/A |
| TPA | TPA-60263 | 2026-09-13T11:21:26Z | Harold | — | Ramirez | ·1943-04-28 | - | UNKNOWN | (722) 316-0778 | null | 6606 Forest Ave | Charlotte·· | NC | 28260 | — | UNKNOWN |
| TPA | TPA-63611 | 2026-01-23T00:38:40Z | MARTHA | — | RUIZ | 1948-04-01 | UHC7927809 | null | — | — | ·5670 Main St | Eden Prairie | MN | 55372 | GRP-7042 | ·· |
| TPA | TPA-50030 | 2026-01-14T00:03:23Z | George | — | ·Ellis | 1977-04-27 | UHC-39266-32 | — | (334) 582-2353 | null | 8317 Elm St | Miami | FL | 33181 | GRP-1660 | - |
| TPA | TPA-62974 | 2026-03-02T20:09:39Z | Alexander | — | Holmes | Jun 18, 1945 | null | — | — | — | 8770 Lincoln Way | ORLANDO | FL | 32849 | — | CORE-HMO |
| TPA | TPA-63362 | 2026-09-25T05:00:48Z | JACOB | — | DOMINGUEZ | 1995-08-07 | NULL | — | null | N/A·· | 3852 Elm Street | Chandler | AZ | 85215 | ···· | SELECT-EPO |
| TPA | TPA-60553 | 2026-07-05T12:33:17Z | Jennifer | — | ·Medina | 27-06-2000 | UNKNOWN·· | - | UNKNOWN | — | 1107 VALLEY VIEW DR | EDEN PRAIRIE | MN | 55325 | N/A | null |
| TPA | TPA-56115 | 2026-02-18T07:47:51Z | ANDREW | ·· | HART | Mar 18, 1968 | UHC-80970-66 | — | N/A | andrew.hart@yahoo.com | N/A | - | UNKNOWN | null | GRP-5705 | ·- |
| TPA | TPA-63995 | 2026-06-20T08:41:49Z | madison | — | lucas | 2007-12-23 | - | ···· | NULL | — | 9850 Baseline Rd | Austin | TX | ·78796 | null | NULL |
| TPA | TPA-51784 | 2026-05-01T11:24:52Z | Ahmed | — | Robertson | 1994-02-11 | UNKNOWN | NULL | — | — | null | - | — | — | — | OPTIONS-PPO·· |
| TPA | TPA-63517 | 2026-05-22T08:47:35Z | Kimberly | P | Vega | 1961-03-18 | NULL | - | — | — | 9577 SPRING STREET·· | Nashville | TN | ·37217 | - | N/A |
| TPA | TPA-61863 | 2026-01-30T06:42:16Z | HANNAH | — | MARTIN | 1965-05-19 | — | — | ·UNKNOWN | — | 483 Central Ave | Plano | TX | 75019 | null | UNKNOWN·· |
| TPA | TPA-57684 | 2026-02-09T14:54:09Z | MELISSA | ···· | EDWARDS | 22-06-1984 | ·· | — | NULL | — | - | — | — | — | GRP-9997 | NULL |
| TPA | TPA-59882 | 2026-01-06T18:58:37Z | Grace | — | Carter | 1092-19-50 | — | NULL | (252) 278-5572 | N/A | 1028 Church St | Denver | CO | 80236 | GRP-7634 | — |
| TPA | TPA-58935 | 2026-03-08T01:35:22Z | Bell, Nathan | — | — | 1942-12-03 | NULL | — | - | N/A | null | NULL | — | NULL | UNKNOWN | — |
| TPA | TPA-60691 | 2026-06-24T03:13:34Z | Anderson, Scott | — | — | 19870726 | — | NULL | (231) 401-2079 | scott.anderson@yahoo.com | ·- | — | — | — | GRP-9477 | NULL |
| TPA | TPA-56512 | 2026-06-02T11:31:30Z | PAMELA·· | K | BUTLER | 1995-11-10 | NULL | N/A | null·· | pamela.butler3@proton.me | 8619 Spring Street | MIAMI·· | FL | NULL | GRP-4497 | — |
Bronze layer rules
What is guaranteed for downstream layers
- As receivedValues are stored exactly as the feed delivered them, including whitespace, inconsistent casing and placeholder tokens such as NULL or N/A.
- No transformationBronze is never edited in place. Every fix lives in silver and is traceable back here by record ID.
- Line number preservedThe line number records each row's position in the source file, so a value can be located in the original extract.
- Load timestampThe load timestamp marks when the row landed in the lakehouse; this batch landed 2026-10-22T12:42:46.102Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty