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-62800 | 2026-06-25T14:18:02Z | Harold | ···· | Olson | 04/21/82 | — | null | — | HAROLD.OLSON40@HOTMAIL.COM | 2989 BASELINE RD Apt 30 | TUCSON | AZ | 85764 | null | N/A |
| TPA | TPA-58546 | 2026-08-28T12:41:54Z | jeremy | H. | gomez | 1972-08-09 | null | •••-••-3917 | UNKNOWN | UNKNOWN | 5315 MESA DR | Minneapolis·· | MN | 55462 | GRP-1718 | OPTIONS-PPO |
| TPA | TPA-59553 | 2026-05-08T09:07:38Z | ALAN | — | BRADLEY·· | 1971-09-10 | — | •••-••-3172 | 449-517-0482 | N/A | 5458 Oak Street | Tampa | FL | 33633 | - | null |
| TPA | TPA-62376 | 2026-04-15T10:32:27Z | KEN | Q | HAMILTON | 1985-10-18 | uhc-66672-48 | •••-••-5712 | — | — | 4095 LAKE VIEW RD | Sacramento | CA | 95883 | GRP-6545 | N/A |
| TPA | TPA-59258 | 2026-07-26T23:12:03Z | BRITTANY | — | ·KING | 1947-10-03 | - | •••-••-8916 | NULL | N/A | 5343 Indian School Rd | Houston | ·TX | 77094 | NULL | MEDICARE-ADV-B·· |
| TPA | TPA-63026 | 2026-01-08T12:25:50Z | KYLE | — | RICHARDSUN | 01/01/76 | — | •••-••-0150 | 902-323-4080 | kyle.richardson@gmail.com | - | NULL | - | — | GRP-1159 | null·· |
| TPA | TPA-51007 | 2026-08-11T12:04:43Z | Austin | — | Yang | 07/18/1983 | UHC-35695-44 | N/A | 8615822064 | AUSTIN.YANG@OUTLOOK.COM | - | — | — | — | GRP-7817 | CORE-HMO |
| TPA | TPA-64265 | 2026-02-11T07:54:13Z | Tyler | — | Daniels | 1980-04-06 | — | - | 9152512·· | tyler.daniels@outlook.com | 1390 Hillcrest Rd | Las Vegas | NV | ·89104 | NULL | SELECT-EPO |
| TPA | TPA-61492 | 2026-08-16T04:03:11Z | DEBRA | — | ·MARSHALL | 2003-04-13·· | null | — | — | N/A | 5514 Canyon Road | Seattle | WA | 98135 | GRP-6577 | NULL |
| TPA | TPA-53805 | 2026-03-13T19:46:36Z | HANNAH | — | FREEMAN·· | 1989-01-10 | UNKNOWN | NULL | — | N/A | 1191 Palm Drive | Orlando | ·FL | 32829 | ·NULL | — |
| TPA | TPA-54016 | 2026-08-23T09:45:39Z | FRANCES·· | — | SIMPSNO | 2006-12-03 | — | - | (344) 789-4435 | frances.simpson@hotmail.com | 4657 Forest Ave Apt 35 | Plano | tx | 75084-5639 | GRP-6641 | SELECT-EPO |
| TPA | TPA-57440 | 2026-06-01T22:08:15Z | Kevin | — | Reid | 13-06-1941·· | — | •••-••-5045 | - | kevin.reid@gmail.com | 7948 Meadow Ln | ·Scottsdale | AZ | 85232 | NULL | MEDICARE-ADV-B |
| TPA | TPA-63979 | 2026-09-10T13:08:57Z | NATALIE | P | BENNETT | 1992-11-25 | — | •••-••-4005 | - | - | UNKNOWN | null | NULL | null | GRP-9067 | NAVIGATE-HMO |
| TPA | TPA-63054 | 2026-02-05T08:05:34Z | Carol | — | Shaw | 2002-10-06 | N/A | — | - | N/A | 1968 Willow Court | Orlando | fl | 32826 | - | NAVIGATE-HMO |
| TPA | TPA-56670 | 2026-05-30T08:28:28Z | Andrea | — | Murphy | 1945-01-11 | - | NULL | +1 536 665 4368 | NULL | 5040 Highland Ave | Denver | CO | 80204 | NULL | NULL |
| TPA | TPA-63367 | 2026-05-03T15:00:21Z | Santiago | — | Aguilar·· | 1979-04-18 | - | — | — | -·· | 4797 Indian School Rd | Charlotte | NC | null | GRP-0753 | null |
| TPA | TPA-58848 | 2026-09-23T00:26:22Z | Roberts | W | Henry | 04/05/47 | UNKNOWN | — | — | HENRY.ROBERTS73@YAHOO.COM | 709 Camelback Road | Phoenix | AZ | 85059 | GRP-1938·· | NAVIGATE-HMO |
| TPA | TPA-61382 | 2026-05-14T04:51:14Z | Eugene | — | Freeman | 1961-12-23 | — | UNKNOWN | 8543837439 | - | 5162 LINCOLN WAY | Scottsdale | AZ | 85251 | GRP-8670 | MEDICARE-ADV-B |
| TPA | TPA-59411 | 2026-08-28T13:20:45Z | Diego | — | Garza | ·1947-03-02 | N/A | •••-••-4530 | — | N/A | — | - | NULL | — | UNKNOWN | SELECT-EPO |
| TPA | TPA-59765 | 2026-01-22T02:06:09Z | Patrick | — | Orteega·· | 7/20/2001 | NULL | — | 18212622405 | ·NULL | 348 Cedar Lane | Atlanta | ·GA | 30305-9682 | — | ·- |
| TPA | TPA-61877 | 2026-07-28T20:50:21Z | PHILIP·· | — | JOHNSTON | 1966-07-26 | UHC-61230-27 | UNKNOWN | (684) 241-5710 | — | - | NULL·· | — | ·N/A | NULL | ·N/A |
| TPA | TPA-54822 | 2026-07-02T19:16:32Z | ·Arjun | C·· | Schmidt | 1992-12-03 | N/A | •••-••-7046 | — | NULL | 1003 Indian School Road | Mesa | AZ | 85221 | — | — |
| TPA | TPA-63978 | 2026-10-18T01:02:41Z | Gray, Melissa | — | — | 1999-07-22 | N/A | null | (910) 701-8468 | NULL | 720 Sunset Blvd | Eden Prairie | mn | ·55319 | N/A·· | N/A |
| TPA | TPA-56139 | 2026-05-27T21:46:42Z | Adam | — | Welch | 19590612 | - | — | 946-312-8704 | null | 4241 DESERT SKY BOULEVARD·· | Tampa | FL | 33648·· | null | N/A |
| TPA | TPA-64297 | 2026-10-17T04:36:01Z | JEREMY | — | MURPHY | 1938-01-10 | - | •••-••-4202 | 16127206749 | NULL·· | — | null | NULL | UNKNOWN | null | UNKNOWN |
| TPA | TPA-62144 | 2026-10-04T17:51:23Z | Emily | — | Dunncan | 28-02-1995 | NULL | null | 309-960-4838 | - | 9117 Harbor Blvd | Sacramento | CA | 95818 | GRP-8505 | ···· |
| TPA | TPA-55603 | 2026-02-05T08:04:25Z | Weber, Nicole | — | — | 2008-04-01·· | NULL | — | — | ·null | 8660 Broadway | Glendale | AZ | 85354-1862 | UNKNOWN | — |
| TPA | TPA-63240 | 2026-08-15T22:41:46Z | MICHELLE | — | DEAN | 1957-09-09·· | — | •••-••-8312 | +1 266 202 1352 | — | 615 Washington Street | Denver | CO | 80248 | null | ·null |
| TPA | TPA-63761 | 2026-01-12T17:35:21Z | PATRICK | — | RIOS·· | 1957-01-19 | - | •••-••-2706 | N/A | UNKNOWN | — | UNKNOWN | NULL | null | - | MEDICARE-ADV-A |
| TPA | TPA-53279 | 2026-04-27T08:55:19Z | Tyler | — | Fernandez | 1978-08-14 | — | NULL | 6672376826 | N/A | 4638 Mountain View Drive | LOS ANGELES·· | CA | - | NULL | - |
| TPA | TPA-54444 | 2026-03-09T10:51:33Z | William | — | Contreras | 4/8/2002·· | UNKNOWN | •••-••-4890 | — | WILLIAM.CONTRERAS@PROTON.ME | 3013 Grand Avenue | Seattle | WA | — | GRP-8277 | CHOICE-PLUS-PPO |
| TPA | TPA-52165 | 2026-10-17T18:19:36Z | mark | — | ·hernandez | 1962-02-06 | — | NULL·· | 5612488793 | MARK.HERNANDEZ84@YAHOO.COM | 2686 SUNSET BOULEVARD | Charlotte | NC | 28281 | null | MEDICARE-ADV-B |
| TPA | TPA-56046 | 2026-01-06T15:22:33Z | Melissa | — | Yang | 01-05-1968 | UHC-50658-16 | N/A | (869) 434-6413 | — | 6901 HILLCREST RD | Plano | TX | 75036·· | - | — |
| TPA | TPA-56070 | 2026-04-26T04:41:12Z | Martha | — | ·Henderson | ·2000-08-23 | N/A | null | (657) 963-8520 | — | UNKNOWN | UNKNOWN | N/A | UNKNOWN·· | GRP-2339 | NAVIGATE-HMO |
| TPA | TPA-60654 | 2026-09-12T05:18:32Z | Aisha | — | ·Harvey | 0201-29-79 | — | •••-••-4763 | — | null | 4208 MAIN STREET | Dallas | TX | 75211 | UNKNOWN | NAVIGATE-HMO |
| TPA | TPA-60050 | 2026-09-03T02:01:21Z | DOUGLAS | — | MATTHEWS | ·1976-06-02 | — | •••-••-5172 | (311) 913-3819 | UNKNOWN | 1722 Canyon Rd | Tampa | FL | 33601 | - | — |
| TPA | TPA-55526 | 2026-06-08T04:20:48Z | THOMAS | H. | ·WEBB | Jul 3, 1966 | — | •••-••-0748 | NULL·· | — | 5126 CEDAR LN | Scottsdale | AZ | 85220 | — | null |
| TPA | TPA-64395 | 2026-09-09T14:13:50Z | JEREMY | — | GARDNER | 2007-05-17 | null | •••-••-7592 | null | NULL | 7756 Mountain View Dr | ATLANTA | GA | 30307·· | UNKNOWN | MEDICARE-ADV-B |
| TPA | TPA-50505 | 2026-02-01T00:30:08Z | Fox, Terry | — | — | ·2007-08-14 | null | NULL | — | — | 5658 Maple Avenue | Las Vegas | NV | 89181-9304 | GRP-9014 | NULL |
| TPA | TPA-63130 | 2026-02-20T05:09:40Z | Noah | — | Hudson | Oct 6, 1970 | N/A | — | — | null | 8252 Washington St | Sacramento | CA | 95820 | N/A | — |
| TPA | TPA-53114 | 2026-04-24T01:11:38Z | VALENTINA | — | WHEELER | ·1944-03-26 | — | null | 432-796-4908 | N/A | UNKNOWN | null | N/A | — | — | SELECT-EPO |
| TPA | TPA-56368 | 2026-07-24T19:24:18Z | NICOLE | — | BANKS | 1996-12-26 | — | •••-••-3194 | null | ·NULL | 2517 MOUNTAIN VIEW DR | Mesa | AZ | 85200 | — | NULL |
| TPA | TPA-64327 | 2026-02-27T14:00:03Z | LUCIA | — | LUCAS | 1942-09-22 | UNKNOWN | •••-••-1654 | 8948411569 | UNKNOWN·· | 6590 Grand Avenue | SACRAMENTO | CA | NULL | ·UNKNOWN | null |
| TPA | TPA-54930 | 2026-08-04T20:13:47Z | carlos | — | spencer | 1952-05-26 | UHC-03040-35 | UNKNOWN | null | — | 1250 Sage Ct | Minneapolis | MN | 55429 | N/A | NULL |
| TPA | TPA-56359 | 2026-04-11T04:13:43Z | Danielle | — | Ramirez·· | 1/10/1954 | N/A | •••-••-2579 | 295-905-4328 | — | 9333 Lincoln Way | Eden Prairie | MN·· | 55363 | GRP-6864 | MEDICARE-ADV-A |
| TPA | TPA-61696 | 2026-08-28T00:03:05Z | MASON | — | WEAVER | 2008-02-06·· | UHC-52861-29 | — | - | - | 5809 Harbor Boulevard | Mesa | AZ | 85238 | NULL·· | — |
| TPA | TPA-58195 | 2026-09-08T15:51:56Z | Lawrence | — | Alvarado·· | 1956-02-11 | UHC-24233-95 | •••-••-1839 | (847) 819-3882 | UNKNOWN | 8480 Valley View Drive | MINNEAPOLIS | ·MN | 55494 | — | — |
| TPA | TPA-57971 | 2026-06-09T17:44:12Z | MADISN | — | SALAZAR | 1984-11-24 | N/A | - | (714) 650-5589 | — | 1081 PINE DRIVE | Tempe | AZ | 85220 | NULL | UNKNOWN |
| TPA | TPA-60525 | 2026-03-27T07:53:55Z | MARIA | — | JENKINS | 2060-04-01 | NULL | •••-••-2841 | — | maria.jenkins84@hotmail.com | 2486 Mountain View Dr | Jacksonville | FL | 32232 | N/A | N/A |
| TPA | TPA-62590 | 2026-04-08T08:15:09Z | carol | — | pena | 1959-05-16 | UHC-65801-28 | - | NULL | — | 656 Maple Avenue | Eden Prairie | MN | 55375-1825 | GRP-0155 | null |
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:36.711Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty