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-20864 | 2026-05-24T01:02:44Z | JUAN | S | SILVA | 10/08/74 | ·N/A | — | 651-282-6389 | NULL | 5111 Mountain View Drive #820 | Las Vegas·· | NV | 89175 | — | ·- |
| PRV | PRV-21558 | 2026-04-05T05:43:18Z | john | B | oliver | ·1954-09-26 | N/A | •••-••-1097 | 2287725 | - | 3713 Lake View Road | Charlotte | NC | 28226 | ·· | N/A |
| PRV | PRV-27239 | 2026-07-18T09:37:17Z | Phiilip | — | Maldonado | 1995-01-07·· | — | -·· | ·282.477.3887 | PHILIP.MALDONADO@OUTLOOK.COM | 7707 Palm Dr | Tempe | AZ | 85228 | — | — |
| PRV | PRV-26561 | 2026-01-08T06:35:42Z | DYLAN | — | KING | 1987-06-20 | — | - | ·4903523959 | UNKNOWN | 1249 Washington Street #678 | AUSTIN | ·TX | 78754 | — | SELECT-EPO |
| PRV | PRV-26627 | 2026-10-12T11:00:06Z | AMANDA·· | — | — | 2/27/1938 | ···· | NULL | 9336832337 | UNKNOWN | 879 SUNSET BOULEVARD | Houston | TX | 77027 | - | — |
| PRV | PRV-29156 | 2026-05-26T02:04:40Z | Marcus | — | Valdez | 1964-02-25 | UHC-98477-89 | •••-••-2746 | (288) 320-0427 | — | 7713 Ridge Road | ·Scottsdale | AZ | — | NULL | N/A |
| PRV | PRV-27408 | 2026-04-26T07:43:17Z | SOFIIA | — | GUERRERO | 1958-11-24·· | NULL | •••-••-3571 | 17436579225 | — | N/A | -·· | UNKNOWN | — | — | null |
| PRV | PRV-20482 | 2026-04-05T20:43:13Z | JAMES | ·· | RUSSELL | - | ·· | N/A | 2465600484 | — | 8345 Church Street | Denver | CO | 80283 | null | CHOICE-PLUS-PPO |
| PRV | PRV-22674 | 2026-05-10T08:29:12Z | BRUCE | ···· | GRIFFIN | 04-03-1978 | null | UNKNOWN | N/A | N/A | 5529 RIDGE ROAD | Los Angeles | CA | 90041-9224 | UNKNOWN | NULL |
| PRV | PRV-22447 | 2026-08-10T13:06:33Z | Alexander·· | — | Gutierrez | 1969-08-03 | UHC-03255-02 | UNKNOWN | 656-268-7280 | ·N/A | 3809 Oak Street | Sacramento | ca | 95811 | null | — |
| PRV | PRV-25254 | 2026-01-30T12:11:19Z | Brenda | — | Castro | 01-04-1960 | UHC-25301-78 | N/A | 304-273-1898 | N/A | 4199 SPRING ST | Glendale | AZ | 85353 | NULL | NULL |
| PRV | PRV-23111 | 2026-07-26T17:00:23Z | Bryan | — | West | 2006-10-02 | — | N/A | — | - | 5578 Main Street | Minneapolis | MN | 55420 | - | null |
| PRV | PRV-20227 | 2026-08-18T13:10:03Z | Carolyn | — | Hanson | 08/09/2008 | — | •••-••-9099 | NULL | carolyn.hanson@gmail.com | null | - | N/A | — | NULL | — |
| PRV | PRV-25005 | 2026-02-21T00:53:55Z | MICHELLE | — | ANDREWS | 08/24/93·· | null | — | (237) 787-1199 | michelle.andrews@icloud.com | 6315 Highland Ave | Orlando | FL | NULL | — | - |
| PRV | PRV-27896 | 2026-08-13T17:57:05Z | Theresa | P | Gonzales | 1981-09-04 | UHC-23093-68 | — | (640) 737-3218·· | theresa.gonzales75@outlook.com | ·4832 Lake View Rd | Gilbert | AZ | 85258 | NULL | — |
| PRV | PRV-28413 | 2026-07-03T07:49:08Z | Danielle | — | Gordon | 1977-09-25 | UHC-12388-71 | •••-••-3254 | 721-805-7700 | danielle.gordon43@outlook.com | 2404 Spring St | Gilbert | AZ | 85290 | null·· | — |
| PRV | PRV-20024 | 2026-04-09T14:25:57Z | Maria | — | Ortiz | 1999-11-28 | — | •••-••-3542 | null | MARIA.ORTIZ@PROTON.ME·· | 5555 Harbor Boulevard Apt 13 | Jacksonville | FL | 32241 | — | N/A |
| PRV | PRV-23689 | 2026-09-20T00:50:10Z | Martha | F | Tucer | 1998-10-08 | UHC-90948-60 | NULL | (451) 868-9398 | ···· | 4872 Lincoln Way | TEMPE | AZ | 85236 | — | medicare-adv-a |
| PRV | PRV-22730 | 2026-03-22T16:02:51Z | Ann | — | OBrien | 19451204 | UHC-24913-62 | - | +1 549 520 5977 | ·ann.obrien73@gmail.com | 4966 Central Ave #377 | ·GILBERT | AZ | 85228 | NULL | NULL |
| PRV | PRV-25807 | 2026-10-09T09:05:17Z | JORDAN | F | CARPENTER | 1977-03-17 | UHC-22832-79 | •••-••-7146 | (486) 279-9774 | NULL | 7257 Mesa Dr | PHOENIX | AZ | 85088 | NULL | — |
| PRV | PRV-23135 | 2026-01-25T00:51:55Z | Ann | ·· | Ryos | 2003-07-20 | — | — | 900-421-3373 | — | 4831 Lincoln Way | ·Nashville | tn | 37227 | — | N/A |
| PRV | PRV-25780 | 2026-07-30T02:21:08Z | Matthw | ·· | Kelley | 1954-01-02 | — | — | null | N/A | 3283 Camelback Rd | Gilbert | ·AZ | 85261 | null | CHOICE-PLUS-PPO |
| PRV | PRV-27031 | 2026-03-14T05:21:25Z | Nunez | — | Omar | ·1982-10-16 | UHC-16297-37 | — | 963-259-3298 | null | 518 Baseline Road·· | Mesa | AZ | 85227 | UNKNOWN | null·· |
| PRV | PRV-28360 | 2026-01-19T22:27:39Z | ·Jack | ···· | James | 1957-03-03 | UNKNOWN | - | ·+1 895 688 6950 | jack.james@outlook.com | 1297 MAPLE AVENUE | Tampa | FL | 33662 | — | CORE-HMO |
| PRV | PRV-22163 | 2026-04-06T05:40:25Z | BRADLEY | — | SIMS | 1941-06-23 | — | N/A | 697.206.5752 | — | 5562 Apache Blvd | Mesa | AZ | N/A | null | CHOICE-PLUS-PPO |
| PRV | PRV-27825 | 2026-01-21T02:53:29Z | Adam T. | — | Singh | 02/03/48 | ·· | — | NULL | ADAM.SINGH43@ICLOUD.COM | ·- | UNKNOWN | NULL | UNKNOWN | — | OPTIONS-PPO |
| PRV | PRV-26850 | 2026-04-10T12:31:26Z | Wallace, Sara | P. | — | 1970-10-27 | UHC-48359-67 | •••-••-7792 | (665) 967-1601 | SARA.WALLACE29@GMAIL.COM | 298 Ridge Road | Minneapolis | MN | 55471 | — | ·MEDICARE-ADV-A |
| PRV | PRV-29205 | 2026-07-24T02:03:42Z | Mei | — | Thomas | 1976-12-22 | UHC-27268-61 | ···· | 2487190934 | NULL | 5547 Union St | Sacramento | CA | 95871-2573 | — | — |
| PRV | PRV-23047 | 2026-01-10T01:00:02Z | ·Rojas, Harodl | ·P | — | ·Apr 17, 1972 | null | null | 499-874-0265 | harold.rojas@gmail.com | 8669 UNION ST | Tempe | ·AZ | 85224 | NULL | MEDICARE-ADV-A·· |
| PRV | PRV-24172 | 2026-04-02T12:01:36Z | AHMED | — | JACKSON | 19800721 | — | ·N/A | (916) 579-8865 | null | 6354 Lincoln Way | Eden Prairie | MN | 55395 | UNKNOWN | UNKNOWN |
| PRV | PRV-26783 | 2026-07-24T22:34:08Z | Carlos | — | Wilson | 1996-10-09 | ·UHC-72208-43 | NULL | 8044135074 | — | 4898 Lincoln Way | Eden Prairie | MN·· | 55339 | null | - |
| PRV | PRV-23249 | 2026-06-21T20:18:22Z | Phillips, Steven | — | — | 1955-03-05 | UHC-41677-84 | null | (617) 468-0026 | null | 486 Bayshore Dr Apt 30 | Nashville | TN | 37224 | — | — |
| PRV | PRV-25930 | 2026-10-03T00:56:40Z | Dorothy | — | Alvarado·· | Mar 14, 1954 | - | - | 891-723-4380 | N/A | 6812 Park Place | Jacksonville | FL | ·32212-8440 | null | UNKNOWN |
| PRV | PRV-24688 | 2026-03-09T11:19:33Z | Simmons | H. | Austin | 1962-05-06 | UHC-84270-59 | - | NULL | N/A | 4773 Palm Drive | Denver | CO | 80218 | null | — |
| PRV | PRV-21508 | 2026-09-24T08:01:44Z | Austin | ·· | Watson | 1998-06-16 | UHC-30177-94 | — | 628.358.3015·· | austin.watson@proton.me | 7865 Highland Avenue | Minneapolis | MN | 55425 | — | - |
| PRV | PRV-20235 | 2026-01-24T13:34:18Z | Charles M. | — | Bradley | 07/19/51 | UHC-01729-01·· | NULL | ·· | UNKNOWN | 7702 WILLOW CT | Jacksonville·· | FL | 32263 | - | SELECT-EPO·· |
| PRV | PRV-23315 | 2026-06-22T04:33:58Z | Carl | ···· | McCoy | 2008-07-20 | ·UHC-90578-64 | NULL | 402.391.8125 | N/A·· | 9103 Palm Drive | Tampa | FL | 33697 | UNKNOWN | null |
| PRV | PRV-26308 | 2026-07-12T09:38:39Z | Christine | J | Espinoza | NULL | UHC-16134-22 | NULL | 415-805-5756 | — | 6095 Meadow Lane | Plano | ·TX | 75098 | UNKNOWN | - |
| PRV | PRV-22110 | 2026-01-31T21:02:29Z | Janice | — | Harvey | 12/21/68 | UNKNOWN | — | +1 469 347 9054 | ·NULL | 6297 SAGE COURT | Dallas·· | TX | 75297 | UNKNOWN | — |
| PRV | PRV-27390 | 2026-10-04T18:13:12Z | ·Victoria | G | Patel | 1938-09-08 | ·UHC-56400-53 | - | — | - | — | NULL | N/A | ·N/A | null | UNKNOWN |
| PRV | PRV-29079 | 2026-04-09T03:05:21Z | Carl | — | Lynch | 2003-02-23 | UHC-43141-12 | NULL | (515) 297-9945 | UNKNOWN | 9073 River Road | Tempe | AZ | 85212 | — | - |
| PRV | PRV-29442 | 2026-07-31T09:58:38Z | ARTHUR | — | GUERRERO | 1959-07-27 | ···· | NULL | +1 956 647 8487 | ···· | 1737 Highland Ave | Austin | TX | 78749 | — | NULL |
| PRV | PRV-26327 | 2026-01-28T16:17:31Z | Peter | ···· | Ferguson | 1948-03-25 | UHC-45310-05 | ···· | — | peter.ferguson86@proton.me·· | 1560 CENTRAL AVE | Houston | TX | ·77066 | — | MEDICARE-ADV-B |
| PRV | PRV-23959 | 2026-01-12T01:42:09Z | Frances | D | ·Hayes | 1985-11-06 | UHC-79363-79 | •••-••-2448 | 7984806181 | frances.hayes@icloud.com | — | null | UNKNOWN | - | NULL | — |
| PRV | PRV-21310 | 2026-09-29T07:52:44Z | valentina | K | roberts | 2004-06-26 | — | — | NULL | VALENTINA.ROBERTS@YAHOO.COM | 8848 Baseline Rd | ·Charlotte | NC | 28222 | — | — |
| PRV | PRV-21716 | 2026-09-04T02:35:34Z | Heather | ···· | Allen | 7/21/1952 | - | N/A | UNKNOWN | heather.allen@proton.me | 9064 Grand Avenue | Nashville | TN | 37272 | UNKNOWN | — |
| PRV | PRV-23949 | 2026-05-18T07:58:00Z | Carlos | — | Le | 1944-10-15·· | — | •••-••-1106 | 15644707042 | - | NULL | N/A | NULL | UNKNOWN | - | NULL |
| PRV | PRV-27414 | 2026-07-17T12:57:32Z | STEPHANIE | J. | WAGNER·· | 1966-90-22 | UHC-41796-51 | •••-••-7820 | - | - | 7721 RIVER ROAD | Gilbert | AZ | 85205 | N/A | ·MEDICARE-ADV-A |
| PRV | PRV-26253 | 2026-09-27T04:54:16Z | Mark | — | ·Schmidt | 14-10-1966 | ·NULL | •••-••-1209 | 2096465528 | — | — | — | NULL | null | - | — |
| PRV | PRV-27892 | 2026-06-06T08:05:19Z | Matthew | — | Warren | 10/03/1958 | uhc-53986-45 | N/A | N/A | ···· | 6845 Lake View Rd | San Diego | ca | 92154 | UNKNOWN | - |
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.458Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty