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-24753 | 2026-07-06T09:20:02Z | Doris | — | Anderson | Jun 16, 1940 | UHC-85647-30 | •••-••-6546 | 476-468-3227 | NULL | 5796 Broadway | Sacramento | CA | 95828 | — | ·UNKNOWN |
| PRV | PRV-20078 | 2026-06-09T02:52:32Z | LOGAN | — | JENKINS | 2/11/1983 | — | NULL | 9513936562·· | logan.jenkins92@proton.me | 2509 Spring Street | Minneapolis | MN | 55408 | null | — |
| PRV | PRV-21776 | 2026-02-09T08:12:40Z | ·Garrett, Grace | — | — | 10/14/93 | UHC-31113-38 | ·· | 3157222991 | null | 1674 Oak St #574·· | PLANO | TX | 75024 | - | SELECT-EPO |
| PRV | PRV-28002 | 2026-01-15T07:30:25Z | Mary | — | Coleman·· | 06/14/95 | UHC-92494-52 | •••-••-6185 | (555) 631-3855 | null | UNKNOWN | NULL | — | NULL | UNKNOWN | null |
| PRV | PRV-20992 | 2026-06-02T16:13:04Z | RUTH | — | CARR | 2006-04-27 | — | •••-••-6367 | 9594544279 | N/A | 692 Bayshore Drive | Dallas | TX | 75207 | — | UNKNOWN |
| PRV | PRV-24278 | 2026-01-08T23:49:52Z | DONALD | ·· | LUNA | 01/26/1971 | UNKNOWN | - | NULL | — | 9766 Washington Street | San Diego | CA | 92137 | — | N/A |
| PRV | PRV-26372 | 2026-03-01T01:35:05Z | Victoria | — | Fields | 1943-08-20 | UHC-70359-74 | — | 6194885016 | — | 4522 Mesa Drive | Minneapolis | ·MN | NULL | - | ···· |
| PRV | PRV-23516 | 2026-01-02T03:08:42Z | Hiroshi | — | Martinez | 1946-08-27 | N/A | N/A | 3742149810 | — | 5606 MEADOW LANE | MINNEAPOLIS | MN | — | ·· | MEDICARE-ADV-A |
| PRV | PRV-28510 | 2026-05-26T18:49:31Z | Cynthia | — | Weber | ·1989-03-13 | — | - | 6978675698 | UNKNOWN | 4461 Pine Drive | Tampa | FL | 33645 | — | MEDICARE-ADV-B·· |
| PRV | PRV-25531 | 2026-01-30T13:28:15Z | Tucker, Gary | — | — | 2000-06-04 | UHC-38611-50 | NULL | 418-696-4420 | — | UNKNOWN·· | N/A | null | — | - | OPTIONS-PPO |
| PRV | PRV-26054 | 2026-09-26T16:25:56Z | GLORIA | — | TRAN | 19450504 | UHC2362676 | N/A | +1 517 677 8499 | — | — | - | null | N/A | — | UNKNOWN |
| PRV | PRV-24246 | 2026-08-29T22:45:05Z | Donna | — | Welch | 19760660 | UHC-78754-72 | •••-••-6505 | 507-440-5110 | DONNA.WELCH@OUTLOOK.COM | ···· | NULL | — | ·· | — | — |
| PRV | PRV-20564 | 2026-10-06T00:57:42Z | Teresa | — | Harvvey | 1995-07-24 | ·NULL | — | 13347836443 | NULL | 4064 Palm Drive | Mesa | AZ | 85261 | UNKNOWN | null |
| PRV | PRV-28115 | 2026-06-11T04:46:03Z | Frank | ·Q | Hansen·· | 1998-04-09 | UHC-07640-62 | — | (921) 899-3113 | frank.hansen@outlook.com | 1390 Mesa Dr | Los Angeles | CA | N/A | null | CORE-HMO |
| PRV | PRV-29091 | 2026-03-25T22:29:49Z | ·Alexis | B. | Murray | 1990-12-15 | UHC-07375-77 | •••-••-1041 | 580-801-6873 | - | 5747 CAMELBACK ROAD | San Diego | CA | 92131 | NULL | UNKNOWN |
| PRV | PRV-25236 | 2026-10-01T14:07:13Z | Carol | — | Jones | 1945-01-03 | NULL | null | N/A | carol.jones@yahoo.com | 8250 Lincoln Way | San Antonio | TX | ·78292 | — | UNKNOWN |
| PRV | PRV-22260 | 2026-05-21T07:56:38Z | Tyler | — | ·Ellis | 1964-06-11 | ···· | — | (831) 668-7261 | null | 9799 MAPLE AVENUE #918 | LAS VEGAS | NV | 89140 | UNKNOWN | N/A |
| PRV | PRV-23396 | 2026-03-13T23:16:21Z | TERESA | — | KNIGHT | 10/26/1969·· | UHC-05402-97 | •••-••-4155 | +1 698 540 5208 | NULL | ·9898 APACHE BLVD | Mesa | AZ | 85208 | NULL | — |
| PRV | PRV-25747 | 2026-02-04T12:13:44Z | Doris | F | Moore | 2006-12-13 | — | — | +1 216 338 2691 | UNKNOWN | — | — | null | UNKNOWN | UNKNOWN·· | OPTIONS-PPO |
| PRV | PRV-23282 | 2026-01-01T18:44:23Z | Kelly, Jacob | — | — | 1990-05-14 | — | — | +1 281 866 3241 | null | -·· | — | — | UNKNOWN | NULL | - |
| PRV | PRV-26483 | 2026-07-12T03:25:15Z | Grace | T | Taylor | 1987-06-25 | null | null | 6798505 | — | 6983 APACHE BOULEVARD | Charlotte | NC | 28228 | - | N/A |
| PRV | PRV-24540 | 2026-05-26T10:35:34Z | kathryn | N | stephens | 1977-02-28 | null | — | - | null | 9830 Sage Ct | Seattle | WA | ·98147 | - | MEDICARE-ADV-B·· |
| PRV | PRV-27389 | 2026-07-13T02:31:39Z | SARA | — | HOFFMAN | 1944-11-21 | — | — | (409) 509-1371 | sara.hoffman@yahoo.com | — | null | N/A | N/A | null | UNKNOWN |
| PRV | PRV-20588 | 2026-04-22T02:49:12Z | Mari | — | James | 2001-11-10 | N/A | •••-••-7094 | UNKNOWN | maria.james@yahoo.com | - | — | N/A | N/A | — | — |
| PRV | PRV-26385 | 2026-07-12T16:49:11Z | EMMA | — | BARNES | 10/15/1960 | UHC-43601-62 | N/A | (477) 965-4838 | null | 3633 Desert Sky Boulevard | Tucson | AZ | 85724 | ·· | null |
| PRV | PRV-24315 | 2026-07-14T22:19:41Z | ELIZABETH | — | WANG | Dec 22, 1965 | — | — | +1 629 550 6291 | NULL·· | 287 Grand Ave | Plano | TX | 75066 | - | — |
| PRV | PRV-20525 | 2026-03-18T10:09:55Z | Moore, Douglas | K | — | 04-08-1956 | UHC-27864-05 | null | 6942089813 | — | 1328 PINE DRIVE | Denver | CO | ·80266 | — | CORE-HMO |
| PRV | PRV-21074 | 2026-07-02T09:03:34Z | Scott | G | Schultz | 1938-06-06 | UHC-40594-68 | N/A | 432-493-5516 | — | 6925 Bayshore Drive | Tampa | FL | 33699 | UNKNOWN | ·MEDICARE-ADV-A |
| PRV | PRV-21194 | 2026-06-12T06:06:54Z | AUSTIN·· | — | WILLIAMSON | 5/28/1994 | NULL | null | 364-975-2513 | austin.williamson@hotmail.com | 6313 Bayshore Drive | TEMPE | AZ | 85292 | NULL | — |
| PRV | PRV-25546 | 2026-02-25T22:16:21Z | Shaw, George | ···· | — | 1984-10-02 | UHC-36004-77 | •••-••-9406 | (799) 653-9568 | — | ·6572 Bayshore Drive | Tucson | AZ | 85780 | UNKNOWN | — |
| PRV | PRV-21482 | 2026-06-13T05:32:59Z | Brenda | ·· | Elliott | 1951-12-23 | UHC-91777-26 | UNKNOWN | 789-800-0132 | — | null | NULL | — | — | NULL | — |
| PRV | PRV-22761 | 2026-03-05T18:04:26Z | CYNTHIA | ·· | CASTRO | 1981-10-06 | UNKNOWN | — | — | NULL | 1248 SUNSET BLVD | Seattle | WA·· | 98189 | UNKNOWN | null |
| PRV | PRV-26510 | 2026-02-28T14:24:08Z | ·Sharon | — | Vega | 1970-01-16 | UNKNOWN | - | 6665859164 | null | 6900 Baseline Rd | San Diego | ·CA | ·92104 | — | OPTIONS-PPO |
| PRV | PRV-29120 | 2026-05-23T18:30:05Z | Alexis | — | Elliott | 1965-02-04 | UHC-73306-15 | null | null | UNKNOWN | 9576 Cedar Ln | Atlanta | GA | 30344 | NULL | NULL |
| PRV | PRV-27944 | 2026-10-14T21:13:15Z | isabella | — | sinngh | 1949-11-14 | UHC1495140 | •••-••-2505 | (916) 250-9220 | ISABELLA.SINGH@ICLOUD.COM | 8764 Baseline Road #276 | Columbus | ·OH | 43296 | — | UNKNOWN |
| PRV | PRV-25000 | 2026-04-09T02:58:04Z | JULIA | — | CARPENTER | 1399-09-16 | UHC-53528-15 | UNKNOWN | 8972660610 | julia.carpenter@proton.me | 997 Baseline Rd | Mesa | AZ | 85262 | - | ·SELECT-EPO |
| PRV | PRV-27294 | 2026-05-01T12:06:11Z | Micelle | — | Gutierrez·· | 1998-01-28 | N/A | — | ···· | — | 6253 Grand Ave | Orlando | FL | 32870 | NULL | - |
| PRV | PRV-25290 | 2026-03-17T22:29:55Z | Roger | — | Black·· | 1992-07-21 | - | — | 284.730.1448 | ROGER.BLACK4@PROTON.ME | 929 Harbor Blvd | Dallas | TX | 75217 | -·· | — |
| PRV | PRV-22226 | 2026-02-12T12:20:53Z | VIRGINIA | G | YANG·· | 08/28/88 | UHC-41415-62 | — | ···· | null | 200 JEFFERSON AVE | ·Mesa | Arizona | 85287 | NULL | N/A |
| PRV | PRV-20129 | 2026-09-26T16:31:55Z | jack·· | ···· | roberts·· | ·1985-02-01 | NULL | null | 2859058674 | UNKNOWN | 2800 Lake View Road | Atlanta | GA | 30335 | — | — |
| PRV | PRV-23277 | 2026-08-05T16:34:34Z | Diana | L·· | ·Grant | 1941-09-26 | UNKNOWN | — | (521) 575-6151 | — | ·· | N/A | - | - | ·NULL | N/A |
| PRV | PRV-29254 | 2026-04-16T03:07:12Z | Natalie | — | Bennett | 1992-11-25 | UNKNOWN | - | ·19619633546 | - | 517 River Rd | Houston | TX | 77063 | - | — |
| PRV | PRV-24386 | 2026-07-08T15:14:13Z | eugene·· | — | wallace | 1942-06-16 | UHC-99190-14 | •••-••-1802 | 220-733-5096 | eugene.wallace6@yahoo.com | 8878 BASELINE ROAD | Jacksonville | FL | 32219 | N/A | — |
| PRV | PRV-22772 | 2026-05-05T01:02:35Z | KATHRYN | Y | CHAPMAN | ·2006-02-18 | UHC-95395-25 | — | 7795028230 | ·N/A | — | ·NULL | - | NULL | — | — |
| PRV | PRV-28451 | 2026-04-04T06:20:36Z | Elizabeth | — | Champan | 1957-10-14 | null | - | (333) 347-4545 | — | UNKNOWN | null | UNKNOWN | — | null | — |
| PRV | PRV-26642 | 2026-09-12T12:00:15Z | Helen | ·· | Williams | 1978-04-25 | UHC-69324-22 | •••-••-2672 | 3814271921 | — | 1803 Bayshore Dr | SAN ANTONIO | Texas | 78208 | NULL | null |
| PRV | PRV-27249 | 2026-02-24T23:34:39Z | PETER | ···· | FISHER | 4/19/1973 | UHC4964784 | — | +1 505 364 3227 | PETER.FISHER@OUTLOOK.COM | 9503 BROADWAY Apt 37 | Dallas | TX | 75252 | — | — |
| PRV | PRV-26450 | 2026-06-09T20:38:20Z | CATHERINE | — | FORD | 12/27/1977 | - | — | (972) 898-0314 | — | 1919 HARBOR BLVD | Sacramento | CA | UNKNOWN | — | — |
| PRV | PRV-21014 | 2026-09-05T15:12:49Z | ·Edwards, Edward | — | — | 1947-11-16 | — | null | (796) 700-9305 | EDWARD.EDWARDS68@YAHOO.COM | 3370 BASELINE RD | Jacksonville | FL | ·32231 | NULL | — |
| PRV | PRV-22098 | 2026-01-12T04:35:10Z | Jeffrey | — | Roberts | 1942-04-13 | ···· | •••-••-9347 | +1 969 466 3181 | jeffrey.roberts@outlook.com | 2278 Hillcrest Rd | Gilbert | AZ | 85274 | ···· | 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:40.599Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty