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-50018 | 2026-08-19T05:10:23Z | Jeremy | — | Franklin | 09/25/74 | — | N/A | NULL | - | 3588 JEFFERSON AVENUE | Houston | TX | 77063 | — | - |
| TPA | TPA-54241 | 2026-01-30T18:07:04Z | Cnythia | — | Ford | 1951-09-23 | UHC-92645-67 | NULL | - | N/A | 2718 RIDGE ROAD | Los Angeles | CA | 90098 | null | NULL |
| TPA | TPA-63320 | 2026-05-21T20:19:38Z | CAROLYN | — | LI | ·1943-09-13 | UHC-24165-93 | •••-••-8239 | — | UNKNOWN | — | - | — | null | — | - |
| TPA | TPA-53558 | 2026-03-08T04:38:04Z | Pamela | — | Phillips | 1971-11-10 | N/A | — | N/A | — | 8055 HILLCREST ROAD | Gilbert | AZ | 85294 | GRP-2023 | null |
| TPA | TPA-61335 | 2026-06-22T18:54:32Z | Ajrun | — | Jensen | 1978-03-02 | — | — | UNKNOWN | arjun.jensen@yahoo.com | ·7875 River Rd | LAS VEGAS | NV | 89115 | N/A | SELECT-EPO |
| TPA | TPA-52101 | 2026-02-03T23:52:34Z | Nicole | K | Ortega | 2005-09-13 | NULL | — | 18135244011 | NULL | 376 Baseline Road | Chandler | AZ | 85283 | — | — |
| TPA | TPA-50839 | 2026-02-27T21:17:09Z | KYLE·· | — | PHILLIPS | 1964-08-19 | — | •••-••-3627 | NULL | kyle.phillips75@hotmail.com | ·4114 CEDAR LN | CHANDLER | AZ | 85235 | — | SELECT-EPO |
| TPA | TPA-55737 | 2026-02-23T16:05:08Z | WALTER | — | CARR | 13-11-1972 | N/A | -·· | — | null | ·5262 Jefferson Avenue | ·Houston | TX | 77055 | null | NAVIGATE-HMO |
| TPA | TPA-59219 | 2026-05-29T00:19:53Z | Gerald | — | Tran | 1980-06-22 | — | UNKNOWN·· | — | NULL | 4623 Church St Apt 9 | Mesa | AZ | 85287 | NULL·· | UNKNOWN |
| TPA | TPA-55622 | 2026-04-24T05:55:20Z | KEITH | — | BURNS | 09/16/88 | — | - | (338) 830-9775 | N/A·· | 9209 Lake View Rd | PHOENIX | AZ·· | 85010 | — | CORE-HMO |
| TPA | TPA-57754 | 2026-10-17T01:14:31Z | Marc | — | Alvarado | 1949-06-12 | UHC-99938-50 | UNKNOWN | - | marcus.alvarado63@outlook.com | 53 UNION STREET | SAN ANTONIO | TX | 78272 | — | — |
| TPA | TPA-50712 | 2026-09-18T23:12:55Z | AUSTIN | J. | TORRES·· | 6/15/1970 | UHC-05553-13 | NULL | 324-360-2250 | N/A | 6803 Canyon Road | Jacksonville | FL | 32268 | null | ···· |
| TPA | TPA-58016 | 2026-05-11T11:59:06Z | Thomas, Vincent | — | — | 11-06-1939 | UHC-72529-98 | — | ·8993797926 | null | 1569 ELM ST | Las Vegas | NV | 89177 | — | N/A |
| TPA | TPA-58913 | 2026-09-20T23:55:12Z | Elijah | — | Williamson | 1989-12-24 | — | •••-••-1277 | N/A | — | 868 Union Street | Seattle | WA | 98134 | UNKNOWN | null |
| TPA | TPA-59640 | 2026-03-04T23:18:22Z | kenneth | — | ryan·· | 24-07-1991 | ·NULL | — | NULL·· | UNKNOWN | 2520 SUNSET BLVD | Tampa | FL | NULL·· | — | N/A |
| TPA | TPA-51537 | 2026-07-15T19:46:12Z | Thomas | — | ·Fowler | 1998-02-20 | - | null | — | — | 4295 Lincoln Way | Chandler | AZ | 85237 | UNKNOWN | MEDICARE-ADV-A |
| TPA | TPA-59207 | 2026-08-11T07:25:37Z | Murray | — | Jason | 4/12/1983 | UNKNOWN | null | null | — | 4758 Market Street | Dallas | ·TX | 75278 | - | NULL |
| TPA | TPA-61355 | 2026-08-16T23:02:12Z | Brenda | — | Rodriguez | 1957-10-04 | — | •••-••-1664 | null | null | 4390 Baseline Rd | Tucson | AZ | 85738 | GRP-4273 | — |
| TPA | TPA-64088 | 2026-02-11T15:52:22Z | BRENDA | ···· | WALLACE | 21-02-2007 | UNKNOWN | NULL | 334-618-9246 | - | 1270 Park Place | Orlando·· | FL | 32880-8907 | GRP-6911 | N/A |
| TPA | TPA-52353 | 2026-08-21T21:29:22Z | THERESA | — | HOFFMAN | 1982-08-08 | — | •••-••-0817 | N/A | — | 3909 DESERT SKY BOULEVARD | ·Sacramento | CA | 95839 | GRP-2584 | NULL |
| TPA | TPA-54884 | 2026-06-07T17:27:58Z | Joyce | N. | Pierce | 1945-02-01 | — | — | 9149761760 | UNKNOWN | 3413 Spring Street | ·Scottsdale | AZ | 85262 | GRP-3309 | ···· |
| TPA | TPA-55288 | 2026-02-21T08:29:59Z | adam | — | jacobs | 07/03/1956 | UHC0610459 | null | (752) 991-8001 | null | 2921 MESA DR #424 | Phoenix | AZ·· | 85010 | - | — |
| TPA | TPA-54593 | 2026-04-25T12:31:41Z | Heather | — | Crawford | 1966-01-27 | N/A | NULL | 9885618634 | N/A | null | — | - | — | GRP-8059 | UNKNOWN |
| TPA | TPA-60495 | 2026-10-15T22:10:47Z | Heather | ·· | Fuller | 09/04/38 | UHC-97671-82 | - | NULL | — | ·5849 Mesa Dr | Minneapolis | MN | 55478 | GRP-1643 | — |
| TPA | TPA-58751 | 2026-03-18T17:01:46Z | ERIC | — | MCDONALD | 2006-08-23 | — | null | 7502790087·· | N/A | 4372 CENTRAL AVE | Minneapolis | MN | 55464 | GRP-6984 | — |
| TPA | TPA-59747 | 2026-09-15T14:14:12Z | Michael | ·· | ·Webb | 1984-07-09 | - | •••-••-8698 | 636.619.9993 | UNKNOWN | 5189 Camelback Road | Tucson | az | - | UNKNOWN | null |
| TPA | TPA-60392 | 2026-06-20T01:52:06Z | STEVEN | — | HUNNT | 1959-08-22·· | — | - | 342-691-4413 | steven.hunt@yahoo.com·· | 2211 WILLOW COURT | Charlotte | NC | 28208 | NULL | UNKNOWN |
| TPA | TPA-52110 | 2026-03-27T18:39:25Z | Terry Q. | — | Watson | 1949-06-28 | — | NULL | UNKNOWN | ···· | 9167 CHURCH ST | Tampa | fl | ·- | GRP-8974 | UNKNOWN |
| TPA | TPA-51148 | 2026-03-20T04:03:26Z | Aaron | — | Harevy | 7/5/2001 | — | •••-••-1905 | - | — | 5852 Apache Boulevard | ·Glendale | AZ | 85373 | N/A | NULL |
| TPA | TPA-59788 | 2026-08-03T05:28:44Z | JUDITH | ·· | PALMER·· | 02/02/1997 | UNKNOWN | N/A | 589.272.2807 | JUDITH.PALMER83@YAHOO.COM | 4983 Pine Dr | Orlando | FL | 32891 | NULL | — |
| TPA | TPA-52085 | 2026-05-12T23:15:31Z | Lori | — | ·Payne | 1983-12-05 | — | -·· | (936) 667-7228 | LORI.PAYNE69@OUTLOOK.COM | — | ·· | UNKNOWN | - | GRP-1169 | CHOICE-PLUS-PPO |
| TPA | TPA-53484 | 2026-07-30T20:59:00Z | ALEXIS | — | BURTON | 05-10-1975 | N/A | N/A | null | — | UNKNOWN | null | N/A | ·UNKNOWN | GRP-9769 | — |
| TPA | TPA-53302 | 2026-10-04T15:00:23Z | Jeremy | — | Hunt | 03/21/73 | UHC-40999-45 | UNKNOWN | — | — | 9281 Sunset Blvd | Tucson | az | 85750-9601 | GRP-9057 | SELECT-EPO |
| TPA | TPA-55422 | 2026-10-09T05:31:51Z | Brian | — | Jordan | Nov 12, 1996 | NULL | UNKNOWN | null | — | 3595 HILLCREST ROAD #650 | Eden Prairie | MN | 55382 | N/A | - |
| TPA | TPA-61909 | 2026-03-04T04:59:41Z | ALEXIS | — | ARNOLD | 19781019 | - | - | NULL | ALEXIS.ARNOLD56@AOL.COM | 6036 Bayshore Drive | San Diego | CA | 92150 | GRP-7073 | NAVIGATE-HMO |
| TPA | TPA-57110 | 2026-01-15T16:58:52Z | Fatima | — | Mendez | 1945-07-18 | — | — | N/A | - | 4395 UNION STREET | Orlando | FL | 32809 | ·null | — |
| TPA | TPA-56242 | 2026-04-16T09:15:12Z | Brandon | — | Cole | 1996-09-27 | UHC-38163-34 | null | +1 580 983 1735 | ···· | — | UNKNOWN | - | — | GRP-1502·· | ·· |
| TPA | TPA-51290 | 2026-01-25T10:54:37Z | Turner, Arjun | — | — | 1984-09-08 | — | ···· | (769) 671-7981 | NULL | 8735 Valley View Dr | PHOENIX | az | 85067 | — | NAVIGATE-HMO |
| TPA | TPA-64259 | 2026-09-29T07:50:09Z | Atrhur | — | ·Guerrero | 19590727 | ·- | null | UNKNOWN | N/A | 1737 Highland Avenue | AUSTIN | TX | 78749 | — | — |
| TPA | TPA-50640 | 2026-06-15T12:23:48Z | ASUTIN | — | ·STEVENS | 1992-06-12 | NULL | null | 17376688370 | N/A | 9145 Canyon Road | COLUMBUS | OH | 43281 | N/A | MEDICARE-ADV-B |
| TPA | TPA-51823 | 2026-03-03T22:37:57Z | Evelyn | — | Owens·· | 1998-10-28 | — | N/A | (415) 200-9356 | — | NULL | - | - | — | ·· | NAVIGATE-HMO |
| TPA | TPA-51327 | 2026-03-23T15:23:29Z | ALICE | — | CARROLL | 1948-06-15 | — | — | null | — | 6738 OAK STREET | MESA | AZ | 85272 | GRP-4270 | — |
| TPA | TPA-57968 | 2026-02-02T02:36:39Z | Cynthia | — | Carroll | 2004-07-27 | N/A | — | UNKNOWN | cynthia.carroll99@yahoo.com | 7925 Mountain View Drive Apt 10 | Las Vegas | NV | null | GRP-6868 | — |
| TPA | TPA-55250 | 2026-05-09T10:10:53Z | Olivia | — | Anderson | 1990-05-17 | — | - | — | UNKNOWN | 4847 BAYSHORE DR | Tucson | Arizona | 85760·· | — | — |
| TPA | TPA-58570 | 2026-09-27T00:05:22Z | Doris | — | Fernandez | 04-02-2003 | ·UHC-98369-55 | null | ···· | null | 5596 Bayshore Drive Apt 40 | Jacksonville | FL·· | 32268 | — | NULL |
| TPA | TPA-53459 | 2026-02-25T05:42:59Z | Simpson, Janice | — | — | 1998-06-25 | N/A | NULL | 287.924.4771 | — | null | — | — | — | — | — |
| TPA | TPA-50832 | 2026-01-08T04:37:02Z | JEAN·· | — | CONTRERAS | 19430524 | — | •••-••-7117 | +1 679 619 5090 | JEAN.CONTRERAS@PROTON.ME | null | N/A | ·NULL | null | — | — |
| TPA | TPA-62767 | 2026-05-31T18:49:14Z | Barbara·· | — | Weber | ·19480125 | — | •••-••-1121 | (349) 906-0415 | — | 4863 Ocean Avenue | Eden Prairie | Minnesota | 55336 | GRP-5437 | — |
| TPA | TPA-51450 | 2026-10-13T03:50:17Z | James | ·M | Espinoza | Jan 19, 1998 | UNKNOWN | null | null | james.espinoza@proton.me | 5887 CENTRAL AVE | San Antonio | Texas | 78268 | — | NAVIGATE-HMO |
| TPA | TPA-55579 | 2026-02-08T11:14:39Z | luis | — | lee | 04/28/1965 | NULL | •••-••-1980 | — | NULL | 7876 Bayshore Drive | Phoenix | Arizona | 85075-2101 | — | — |
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:52.240Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty