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-29324 | 2026-01-28T20:14:49Z | VICTORIA | — | SINGH | 4/18/1941 | UHC-82237-08 | N/A | 4874165697 | UNKNOWN·· | 3955 Grand Ave | Chandler | AZ | 85255 | — | — |
| PRV | PRV-26679 | 2026-02-24T18:08:37Z | DYLAN | R | RAMOS | 1961-07-22 | UHC-33618-37 | null | 8185998585·· | null | 1058 SUNSET BLVD #765 | Atlanta | GA | 30336 | — | SELECT-EPO |
| PRV | PRV-26134 | 2026-09-15T18:47:50Z | DONNA | U | SULLIVAN | 1998-01-01 | UHC-84309-27 | — | 578-688-8092·· | — | — | NULL | null | — | null·· | SELECT-EPO |
| PRV | PRV-26534 | 2026-07-10T18:12:17Z | Marilyn | — | Daniels | 1964-06-17 | - | — | 902-545-5044 | marilyn.daniels56@yahoo.com | ·2712 CANYON ROAD | Tempe | AZ | — | null | UNKNOWN |
| PRV | PRV-27573 | 2026-07-08T23:38:17Z | Zechary, Davis | — | — | 1984-02-12 | — | •••-••-7854 | 820-960-5083 | — | 6064 Main St | CHARLOTTE | NC | 28293 | - | OPTIONS-PPO |
| PRV | PRV-28238 | 2026-02-11T18:01:29Z | Harvey, Bruce | — | — | 03/21/2004 | — | null | ·6897592283 | N/A | 9486 Indian School Road | Orlando | FL | ·32876 | - | — |
| PRV | PRV-24371 | 2026-01-14T12:20:47Z | wayne | N·· | aguilar | 19980122 | UHC-31468-14 | null | (335) 928-4877 | N/A | ·8546 Hillcrest Road | COLUMBUS | OH | 43204 | null | — |
| PRV | PRV-21172 | 2026-01-19T23:19:34Z | zachary | — | luna | 1949-03-04 | NULL | - | 4993825921 | UNKNOWN | 8165 Harbor Boulevard | GLENDALE | AZ | 85350 | UNKNOWN | null |
| PRV | PRV-26866 | 2026-06-21T15:21:35Z | SEAN | S | JAMES | 1978-05-06 | — | — | +1 911 275 7314 | NULL | 7309 Mountain View Dr | Tucson | AZ | 85758 | null | — |
| PRV | PRV-27415 | 2026-05-12T15:02:57Z | David | — | Nguyen | 1992-12-28 | — | - | (596) 583-6704 | — | 7691 WASHINGTON ST Apt 5 | Jacksonville | FL | 32288 | — | OPTIONS-PPO |
| PRV | PRV-20547 | 2026-10-17T23:15:19Z | Betty | — | Peters | 19401228 | NULL | — | 9106580553 | ···· | ·7521 CAMELBACK ROAD | ·SACRAMENTO | CA | 95881 | UNKNOWN | - |
| PRV | PRV-23779 | 2026-03-26T14:21:07Z | Michelle | C. | Suto | 6/26/1966 | — | ···· | ·+1 533 418 4049 | UNKNOWN | 5905 Maple Ave Apt 34 | Dallas | TX | 75211 | N/A | — |
| PRV | PRV-23910 | 2026-01-20T16:08:58Z | Santiago | — | Tran | 1983-11-27 | NULL | N/A | — | SANTIAGO.TRAN43@YAHOO.COM | ·549 River Road | Austin | TX | 78742·· | — | NULL |
| PRV | PRV-28011 | 2026-01-27T10:22:36Z | Christine | — | ·Valdez | 1960-02-08 | UNKNOWN | •••-••-1477 | (862) 358-7484 | null | 6762 Sunset Blvd | Sacramento | CA | 95853 | - | — |
| PRV | PRV-24531 | 2026-08-10T16:56:37Z | Patricia | — | Spencer | 1947-04-21 | NULL | NULL | — | PATRICIA.SPENCER@PROTON.ME | 450 Apache Blvd | Plano | TX | 75064 | — | null |
| PRV | PRV-20823 | 2026-07-27T03:01:58Z | BRADLEY | — | HAYES | 1943-07-10 | UNKNOWN | - | 3906813 | null | 8430 FOREST AVENUE | LAS VEGAS | Nevada | NULL | — | SELECT-EPO·· |
| PRV | PRV-21103 | 2026-06-15T18:08:22Z | SEAN | — | CARTER | 1949-03-08 | - | - | 17396785895 | sean.carter25@proton.me | 7966 Grand Ave | Tucson | az | ·85719 | UNKNOWN | NULL |
| PRV | PRV-23340 | 2026-01-31T01:17:10Z | BRUCE | — | STONE | 2006-02-06 | uhc-02412-43 | — | 777-763-0224 | UNKNOWN | 4565 Mountain View Drive Apt 36 | Phoenix | AZ | 85096 | N/A | N/A |
| PRV | PRV-29181 | 2026-03-19T15:27:17Z | mark | — | edwards | ·10/11/1956 | UHC-45206-33 | null | — | UNKNOWN | 7708 Highland Ave | ·Eden Prairie | MN | 55339 | NULL | — |
| PRV | PRV-22436 | 2026-04-01T09:33:17Z | Watson | V | Andrea | 1950-09-10 | UHC-73165-75 | N/A | 737-579-5304 | UNKNOWN | 8190 APACHE BOULEVARD·· | Plano | TX | 75029 | UNKNOWN | MEDICARE-ADV-B |
| PRV | PRV-28382 | 2026-03-26T20:48:57Z | ALEXIS | I. | JENKINS | 2001-02-09 | UNKNOWN | •••-••-5514 | 2447997769 | — | 8132 Union St | SCOTTSDALE | AZ | 85240 | — | — |
| PRV | PRV-27931 | 2026-09-20T08:49:23Z | Martha | P·· | Jenkins | 1/15/1987 | UHC-38108-73 | — | - | martha.jenkins55@icloud.com | 8650 Apache Boulevard | Sacramento | CA | 95821 | — | null |
| PRV | PRV-25647 | 2026-04-16T11:50:35Z | omar | ···· | hunt | 1938-05-20 | UNKNOWN | ·· | 454.362.9865 | — | 9314 Bayshore Dr | Los Angeles·· | CA | 90085 | - | NULL |
| PRV | PRV-25662 | 2026-05-26T17:59:07Z | George | — | Washington | 1982-02-08 | — | N/A | (343) 317-5279 | N/A | 3555 Grand Ave | Miami | FL | ·33122 | ·· | UNKNOWN |
| PRV | PRV-22099 | 2026-02-05T12:14:43Z | Jeffrey | — | Roberts | 1942-04-13 | - | N/A | - | — | 2278 HILLCREST RD | Gilbert | Arizona | 85274 | - | CORE-HMO |
| PRV | PRV-23438 | 2026-07-22T19:22:49Z | Austin | — | Bryant | 2006-12-17 | UHC-63037-48 | UNKNOWN·· | (294) 631-6629 | UNKNOWN | 6850 Spring St | Orlando | FL | 32899 | — | CHOICE-PLUS-PPO |
| PRV | PRV-24755 | 2026-04-24T20:40:06Z | Anderson, Doris | M | — | 06/16/1940 | UNKNOWN | — | 476-468-3227 | null | 5796 Broadway | Sacramento | CA | 95828·· | — | — |
| PRV | PRV-20061 | 2026-04-07T00:47:38Z | BRANDON | ·D | BENETT | 1976-10-06 | null | NULL | 637-599-8649 | — | 625 SPRING STREET | TAMPA | FL | 33620 | — | ·UNKNOWN |
| PRV | PRV-21187 | 2026-09-05T20:34:14Z | Welch, Doris | — | — | 19-07-1950 | NULL | null | (442) 891-5456·· | doris.welch72@gmail.com | 2676 Forest Ave | Houston | TX | 77070 | UNKNOWN | MEDICARE-ADV-B |
| PRV | PRV-21567 | 2026-03-22T09:19:52Z | Carolyn | — | Wallace | 1999-01-07 | — | null | 4847170868 | UNKNOWN | UNKNOWN | N/A | — | UNKNOWN | — | N/A·· |
| PRV | PRV-21046 | 2026-06-12T17:55:14Z | Fields, Michael | — | — | ·1967-07-20 | — | - | (871) 633-6458·· | null | 2411 FOREST AVENUE | Plano | TX | 75028 | N/A | UNKNOWN |
| PRV | PRV-28447 | 2026-01-01T05:03:50Z | Wright | — | Anthony | 1957-06-16 | UHC-70779-76 | - | — | ANTHONY.WRIGHT@PROTON.ME | 4821 River Rd | Scottsdale | AZ | ·85231 | — | ·MEDICARE-ADV-A |
| PRV | PRV-22986 | 2026-02-22T19:45:34Z | Moreno, Angela | — | — | ·1984-07-14 | UHC-73326-27·· | •••-••-7786 | 19135859151 | angela.moreno81@hotmail.com | 5944 Park Place | Houston | TX | 77001 | - | — |
| PRV | PRV-27480 | 2026-08-17T23:29:39Z | Theresa | — | Flores | 1941-05-14 | null | - | (853) 598-9960 | theresa.flores@hotmail.com | 3624 Harbor Boulevard | MESA | AZ | 85298 | — | N/A |
| PRV | PRV-20355 | 2026-03-22T12:25:42Z | Christopher·· | — | Montgomery | 2002-04-21 | NULL | ·UNKNOWN | ·4687593474 | N/A | 3292 Apache Blvd | Tampa | FL | 33623 | - | CORE-HMO |
| PRV | PRV-20335 | 2026-04-08T06:18:47Z | Logan | — | Andrews·· | 19460904 | UHC-61157-91 | NULL | UNKNOWN | logan.andrews@yahoo.com | 6199 Sage Court | Miami | FL | 33164 | null | ·· |
| PRV | PRV-23841 | 2026-07-08T17:22:48Z | Isabella | I | Sanchez | 1958-11-22 | NULL | null | (935) 592-0361 | ISABELLA.SANCHEZ75@OUTLOOK.COM·· | 7658 Canyon Rd | Tempe | AZ | 85271 | null | ···· |
| PRV | PRV-24942 | 2026-08-14T18:03:36Z | MELISSA·· | S | HOLMES | 25-12-1950 | UHC-70244-48 | ···· | 5407880357 | melissa.holmes@proton.me | 7566 Spring Street | San Antonio·· | TX | 78203 | — | — |
| PRV | PRV-27728 | 2026-07-09T08:40:11Z | HELEN | N. | WAGNER | 1999-06-21 | — | — | 541.778.7587 | helen.wagner@proton.me | 7248 UNION ST | Atlanta | GA | ·30341 | ·NULL | — |
| PRV | PRV-21071 | 2026-10-11T22:16:21Z | ·STEPHEN | — | COOK | 2001-11-05 | UHC-38054-36 | - | 8816650692 | N/A | — | N/A | UNKNOWN | ···· | N/A | — |
| PRV | PRV-28651 | 2026-09-27T15:43:02Z | Dylan | ·R | Fuller | 1938-03-20 | UHC4970997 | •••-••-8217 | (613) 380-1722 | dylan.fuller@hotmail.com | 9644 Indian School Rd | Miami | fl | -·· | - | MEDICARE-ADV-B |
| PRV | PRV-29151 | 2026-05-24T23:37:27Z | Arthur | — | Boyd | 1978-06-22 | UHC-79630-44 | •••-••-2433 | 218-255-9013 | UNKNOWN | 6927 LINCOLN WAY | San Diego | California | 92194 | — | MEDICARE-ADV-B |
| PRV | PRV-20474 | 2026-07-22T16:45:05Z | MARIA | P. | PETERSON | 1984-06-19 | ·UHC-70195-31 | null | +1 810 434 9538 | MARIA.PETERSON57@YAHOO.COM | 9048 Lake View Rd | Tempe | az | 85271 | - | UNKNOWN |
| PRV | PRV-25514 | 2026-08-13T19:10:46Z | Ray | — | Powell | 09/10/1994 | ·- | null | 13929816205 | NULL | ·9283 Washington St | SAN ANTONIO | TX | 78234 | N/A | — |
| PRV | PRV-26331 | 2026-03-16T07:32:36Z | RONALD | — | GUERRERO | 1953-09-22 | UNKNOWN | ·· | UNKNOWN | — | 8347 Market Street | ·SCOTTSDALE | Arizona | 85262 | N/A | NULL |
| PRV | PRV-27740 | 2026-09-17T09:51:44Z | CHRISTOPHER | — | ROBINSON | 19900422 | - | NULL | 314-211-3859 | — | null | NULL | null | NULL | — | MEDICARE-ADV-B |
| PRV | PRV-23166 | 2026-08-14T02:04:49Z | WILLIE | V | DUNN | 09/07/1967 | UHC-04570-88 | N/A | 2374412395 | — | 7513 Jefferson Avenue | ·MINNEAPOLIS | MN·· | 55476 | — | UNKNOWN |
| PRV | PRV-27920 | 2026-07-17T22:24:25Z | Maria | — | ·OBren | 1962-09-02 | — | — | N/A | MARIA.OBRIEN2@HOTMAIL.COM | 432 Elm Street | Miami | FL | 33149 | - | CHOICE-PLUS-PPO |
| PRV | PRV-28993 | 2026-08-19T18:02:15Z | DIEGO | — | WEAVER | 19700819 | UHC-97229-55 | •••-••-2452 | 14447441769 | null | — | UNKNOWN | - | — | ·· | null |
| PRV | PRV-22004 | 2026-09-22T19:56:15Z | Martha | — | Walker | 09-04-1980 | — | •••-••-0134 | (669) 943-8139 | — | 5060 Broadway | LOS ANGELES | CA | 90067 | - | 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:43.435Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty