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
Provider network only, ordered by line number
| Source | Record | Received | First | Middle | Last | DOB | Member ID | SSN | Phone | Address | City | State | ZIP | Group | Plan | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PRV | PRV-21369 | 2026-10-11T09:57:14Z | Joshua | — | Brown | 1993-10-09 | NULL | — | — | NULL | 509 Sunset Boulevard | TUCSON·· | AZ | 85751 | NULL | N/A |
| PRV | PRV-24134 | 2026-02-02T20:35:15Z | Rice, Lori | — | — | 1950-07-23 | UHC-02844-10 | null | 2503648762 | null | 5646 Cedar Ln | Mesa·· | AZ | 85298 | N/A | - |
| PRV | PRV-20709 | 2026-04-29T17:10:12Z | Ahmed | — | Gutierrez | 1970-04-28 | UHC-73708-45 | - | (885) 327-4555 | — | 4959 Harbor Boulevard | SCOTTSDALE | AZ | 85285 | NULL | — |
| PRV | PRV-25059 | 2026-08-17T22:43:29Z | Grace | Y. | Romero | 01/21/2000 | uhc-22850-73 | UNKNOWN | 15705514475 | null | 2205 Grand Ave | Glendale·· | AZ | 85300 | - | — |
| PRV | PRV-23957 | 2026-07-23T02:34:58Z | Angela | ···· | Mills | 1960-06-23 | UHC-64930-03 | — | 315-335-0659 | N/A | 293 Indian School Road | Atlanta | GA | 30392 | ·· | MEDICARE-ADV-B |
| PRV | PRV-22863 | 2026-06-02T22:49:24Z | Joe | ·Q | Hernandez | 1984-04-12 | — | •••-••-2354 | (744) 837-0918 | null | 795 Maple Ave·· | Tempe | AZ | — | - | — |
| PRV | PRV-22041 | 2026-04-06T03:57:31Z | Diane | — | Gibson | 1/7/1978 | - | — | 17289213628 | DIANE.GIBSON@ICLOUD.COM | 8641 Highland Ave | Austin | TX | 78720-4489 | - | - |
| PRV | PRV-27117 | 2026-07-31T14:34:58Z | Butler | — | Willie | 1978-04-20·· | - | — | 7027638949 | — | UNKNOWN | N/A | UNKNOWN | - | - | — |
| PRV | PRV-21591 | 2026-10-09T16:35:48Z | Valentina | B | ·Dnucan | 1952-02-08 | UHC-28239-76 | - | 3317667418 | valentina.duncan96@proton.me | 5220 Indian School Rd | LOS ANGELES | CA | 90089-0591 | null | — |
| PRV | PRV-22378 | 2026-09-15T00:45:59Z | LOGAN | — | WALSH | 19840512 | UHC-23715-26·· | - | — | — | 1129 Lake View Rd | Tucson | AZ | NULL | — | — |
| PRV | PRV-26080 | 2026-02-25T10:13:27Z | MARTHA | — | GARDNER | 13-05-1944 | UHC-33697-52 | •••-••-0747 | (257) 983-7123 | NULL | 3192 Sunset Blvd | Gilbert | AZ | 85215 | null | NULL |
| PRV | PRV-24116 | 2026-06-29T04:17:08Z | Mdaison | G | Stone | 10/02/1980 | NULL | •••-••-7718 | +1 409 664 5277 | — | 1621 Central Ave | LAS VEGAS | NV | 89196·· | N/A | — |
| PRV | PRV-23053 | 2026-03-23T07:01:10Z | Simmons, Victoria | J. | — | 1960-11-19 | ·· | — | (406) 612-8057 | null | 9567 Highland Ave | Los Angeles | CA | 90089 | — | - |
| PRV | PRV-20922 | 2026-01-03T21:12:55Z | Ann | — | Eliott | 1990-05-15 | UHC-87363-16 | — | 284-312-2218 | — | 3996 Broadway | Glendale | AZ | 85361 | -·· | -·· |
| PRV | PRV-24586 | 2026-10-13T10:28:08Z | Joyce | — | Moreno·· | 12/20/90 | ·UHC-51099-94 | — | N/A | joyce.moreno@icloud.com | 4316 Park Pl | Orlando | ·FL | N/A | — | - |
| PRV | PRV-24592 | 2026-02-14T16:18:18Z | SAMNTHA | — | HARRIS | 1987-07-06 | UHC-52365-84 | - | (814) 677-8222 | UNKNOWN | 3707 Apache Boulevard | Houston | TX | NULL | — | N/A |
| PRV | PRV-28842 | 2026-04-05T19:07:48Z | bradley | — | hunt | 1952-02-13 | UHC-08493-41 | - | 468.452.5828 | BRADLEY.HUNT47@PROTON.ME | 3232 Lake View Rd | Nashville | TN | 37206-7535 | UNKNOWN | ·· |
| PRV | PRV-23552 | 2026-02-22T01:11:09Z | Alice | — | Alvarez | 2007-10-06 | UHC-16932-07 | •••-••-5614 | 18704290398 | ·null | 1521 Harbor Boulevard | Eden Prairie | Minnesota·· | 55373 | N/A | - |
| PRV | PRV-27383 | 2026-07-05T16:09:25Z | JOSHUA | — | ·GRAY | Apr 12, 1994 | N/A | null | 824-988-3339 | joshua.gray@icloud.com | 1373 Lincoln Way | Sacramento | CA | 95872 | NULL·· | NAVIGATE-HMO |
| PRV | PRV-23858 | 2026-06-28T18:24:36Z | Carl | — | Park | 1963-01-14 | — | N/A | 6372563393 | N/A | 9297 Ocean Ave | ·Fresno | CA | 93741 | null | UNKNOWN |
| PRV | PRV-27966 | 2026-07-13T01:18:39Z | Coleman, Priya | — | — | 1979-02-22 | UHC-29997-83 | null | 331-712-7738 | — | 8189 Canyon Rd | Phoenix | Arizona | 85027 | — | MEDICARE-ADV-B |
| PRV | PRV-26150 | 2026-04-10T03:22:20Z | Jordan | F. | Rose | 19801009 | NULL | NULL | 8165713463 | NULL | UNKNOWN | UNKNOWN | NULL | -·· | — | ·null |
| PRV | PRV-25972 | 2026-09-27T22:45:04Z | susan | — | yang | 01/13/2000 | UHC-21009-42 | NULL | 476.986.9935 | - | UNKNOWN | null | - | UNKNOWN | — | N/A |
| PRV | PRV-22366 | 2026-01-08T22:12:43Z | JEEAN | — | WATKINS | 1990-03-21 | - | — | — | jean.watkins82@proton.me | 5101 Mountain View Dr | SEATTLE | ·WA | 98153 | — | UNKNOWN |
| PRV | PRV-24468 | 2026-01-23T07:33:22Z | aisha | — | bishop | 1978-02-27 | UHC-96052-20 | NULL | 2872082209 | N/A | 7086 Oak St | Glendale | AZ | 85305 | UNKNOWN | NULL |
| PRV | PRV-28334 | 2026-03-29T11:47:19Z | Zachary | — | Willis | 2006-07-10 | ·UNKNOWN | — | 17058569267 | ZACHARY.WILLIS@HOTMAIL.COM | 1522 DESERT SKY BOULEVARD | Miami | fl | 33113 | — | null |
| PRV | PRV-27549 | 2026-02-20T22:32:36Z | Ahmed | I | Li | ·1952-05-11 | — | null | +1 807 936 9613 | UNKNOWN | ·9424 Park Pl | Eden Prairie | mn | 55361 | N/A | — |
| PRV | PRV-28955 | 2026-01-07T13:02:32Z | kimberly | — | ·vega | 03/18/1961 | UHC-98431-63 | •••-••-7235 | 812-250-7026 | NULL | 9577 Spring Street | NASHVILLE | TN | 37217 | N/A | — |
| PRV | PRV-26935 | 2026-01-26T17:09:45Z | Laura | — | Tran | 1978-90-10 | — | N/A | 4104394952 | laura.tran44@yahoo.com | 8093 Baseline Road | JACKSONVILLE | FL | 32263·· | — | UNKNOWN |
| PRV | PRV-21079 | 2026-04-11T03:00:00Z | ·OMAR | B | KNIGHT | 03/18/54 | UHC7699654 | null·· | 7195293740 | — | ·6084 Grand Ave | Phoenix | AZ | 85090-5078 | UNKNOWN | NULL |
| PRV | PRV-24652 | 2026-02-20T07:20:44Z | Vincent R. | — | Barnes | 1999-01-17 | UHC-01375-61 | — | (816) 499-0462 | null | 863 MEADOW LN | Plano·· | TX | 75067 | — | - |
| PRV | PRV-25729 | 2026-06-22T12:11:53Z | STEPHEN | W | GRANT | ·1948-05-25 | N/A | •••-••-3315 | +1 909 516 1196 | null | — | — | — | NULL | UNKNOWN | OPTIONS-PPO |
| PRV | PRV-22463 | 2026-08-23T08:50:40Z | Janet | — | Holmes | 2001-05-05 | UNKNOWN | •••-••-8602 | 760.813.2571 | — | 5096 RIVER RD | Las Vegas | NV | NULL | - | - |
| PRV | PRV-26772 | 2026-04-02T22:36:08Z | Steven | — | McDonald | 2000-11-28 | UHC-80624-66 | null | 13519482263 | steven.mcdonald42@hotmail.com | 1739 Canyon Road | San Diego | CA | 92188 | null | N/A |
| PRV | PRV-26404 | 2026-07-02T09:19:02Z | Holmes, Debra | I. | — | 12-01-2003 | UHC-55286-16 | UNKNOWN | 602-479-6303 | — | 6762 River Rd | Eden Prairie | MN | 55326 | NULL | UNKNOWN |
| PRV | PRV-20551 | 2026-03-05T18:47:11Z | Pauul·· | — | Lopez | 1966-00-51 | UHC-40853-63 | N/A | 373-922-6087 | PAUL.LOPEZ@GMAIL.COM | 4018 Ridge Rd | Scottsdale | AZ | 85290 | N/A | OPTIONS-PPO |
| PRV | PRV-24588 | 2026-03-29T20:35:08Z | ETHAN | — | WELCH | 1991-03-18 | UHC7827578 | N/A | 613-502-4126 | ethan.welch7@aol.com | 3867 HIGHLAND AVE | MIAMI | Florida | 33199 | — | N/A |
| PRV | PRV-24915 | 2026-05-17T11:14:11Z | PEGGY | — | TUCKER | 1993-08-05 | UHC-50426-10 | null | (654) 604-1409 | NULL | 3606 Mesa Dr | San Diego | CA | 92146 | null | UNKNOWN |
| PRV | PRV-27009 | 2026-04-05T11:57:20Z | SANDRA | H | VASQUEZ | Sep 12, 1938 | uhc-61566-57·· | — | 8314744473 | SANDRA.VASQUEZ93@AOL.COM | 5203 Church Street | ·Dallas | TX | null | — | ·null |
| PRV | PRV-21424 | 2026-08-22T09:33:31Z | austin | — | wong | 19-03-1961 | UHC-52819-86 | •••-••-4110 | 757-995-6047 | null·· | 7229 Cedar Ln | Los Angeles | California | - | — | MEDICARE-ADV-A |
| PRV | PRV-25343 | 2026-06-20T03:52:12Z | Abigail | ·· | Owens | 11/24/64 | UHC-36998-88 | null | 875-464-9144 | - | 9000 VALLEY VIEW DR Apt 35 | Chandler | AZ | 85247 | ·N/A | — |
| PRV | PRV-24561 | 2026-03-18T04:54:23Z | Elizabeth | — | Ruiz | 1971-02-03 | ·UHC9307829 | - | 231-213-5623·· | - | 1768 Union Street | San Antonio | TX | ·78242-7905 | - | — |
| PRV | PRV-23813 | 2026-05-14T03:02:51Z | Zachary | P. | Morales | Aug 8, 1995 | UHC9521009 | — | (561) 212-6194 | UNKNOWN | 9060 Washington Street | Tampa | FL | 33656 | N/A | N/A |
| PRV | PRV-20684 | 2026-09-16T09:42:19Z | FRANK | — | ·LEEWIS | 1956-08-06 | UHC-19885-12 | — | +1 496 625 9234 | FRANK.LEWIS76@PROTON.ME | 5170 HARBOR BLVD | Glendale | AZ | N/A | UNKNOWN | — |
| PRV | PRV-21160 | 2026-06-09T06:26:32Z | Ahmed | — | Robertson | 1994-02-11 | UHC-07829-56 | UNKNOWN | (227) 708-7311 | ahmed.robertson@yahoo.com·· | 986 BROADWAY | ·Plano | ·TX | NULL | -·· | null |
| PRV | PRV-26506 | 2026-09-30T08:53:16Z | Alexander | — | Turner | 1965-08-27 | ···· | •••-••-3926 | 338-474-3391 | ·· | 429 PINE DR | Sacramento | CA | 95897 | null | null |
| PRV | PRV-26509 | 2026-07-14T04:14:30Z | jason | — | barnes | 2/25/1942 | uhc-10046-01 | N/A | 3638638695 | JASON.BARNES@HOTMAIL.COM·· | 8995 Indian School Rd | Fresno | CA | 93781 | null | MEDICARE-ADV-B |
| PRV | PRV-20717 | 2026-07-04T23:08:34Z | ·christian | — | gomez | 1984-11-27 | UNKNOWN | UNKNOWN | 439-387-4184 | — | 7865 Bayshore Drive | Austin | tx | 78733 | ···· | OPTIONS-PPO |
| PRV | PRV-21928 | 2026-01-21T15:21:54Z | Joyce | — | Hicks | 04-07-1968 | UHC-10074-55 | ·N/A | 4578724720 | joyce.hicks89@outlook.com | 5364 Union Street | Miami | FL | 33192-3512 | N/A | - |
| PRV | PRV-23534 | 2026-01-19T01:08:43Z | Natalie | B | Medina | 1987-05-27·· | UNKNOWN | null | (515) 780-6512·· | null | 6608 Maple Ave Apt 6 | Charlotte | NC | 28262-3590 | N/A | — |
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.233Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty