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-25743 | 2026-04-28T17:15:26Z | McDonald, Kayla | — | — | 09/08/04 | UHC-78221-66 | •••-••-8923 | 404-263-4903 | — | -·· | - | N/A | null | — | ·UNKNOWN |
| PRV | PRV-27753 | 2026-04-26T02:57:17Z | CHERYL | H | PERZ | Apr 1, 1963 | — | UNKNOWN | 8639791 | — | — | — | null | — | null | null |
| PRV | PRV-29503 | 2026-01-09T03:19:57Z | doris | — | mcdnald | 06/19/1977 | UHC-00910-81 | — | 5318250759 | doris.mcdonald29@icloud.com | UNKNOWN | - | - | — | - | NULL |
| PRV | PRV-26613 | 2026-07-23T18:08:08Z | MICHAEL | — | REYNOLDS | 20060117 | UHC-88165-10 | •••-••-3275 | 4427216562 | — | 6996 CEDAR LANE | DALLAS | TX | 75289 | — | CORE-HMO |
| PRV | PRV-25532 | 2026-09-30T00:21:52Z | Brandon | J. | White | 1984-09-10 | — | •••-••-9293 | 5795481981 | BRANDON.WHITE96@PROTON.ME | 8193 Cedar Lane | Gilbert | AZ | 85217 | — | — |
| PRV | PRV-29107 | 2026-03-13T01:49:46Z | Kevin | — | Hoffman | 2006-10-27 | UHC-32542-84 | — | 8928082700 | - | ·3210 PARK PLACE | Miami | FL | — | — | - |
| PRV | PRV-28423 | 2026-02-20T06:29:23Z | Jrodan | — | Sullivan | 2001-02-14 | null | •••-••-3496 | 669-850-3292 | NULL | — | ···· | NULL | — | — | UNKNOWN |
| PRV | PRV-23219 | 2026-01-27T02:30:22Z | carol | ·· | thomas | 1955-07-27 | — | •••-••-1105 | UNKNOWN·· | N/A | 621 APACHE BOULEVARD #471 | San Diego | CA | 92113 | ·· | SELECT-EPO |
| PRV | PRV-23353 | 2026-08-18T03:23:13Z | West, Helen | — | — | 1958-11-03 | UHC-25626-75 | - | 9206263118 | HELEN.WEST34@OUTLOOK.COM | 6857 UNION ST | Miami | FL | 33190 | NULL | — |
| PRV | PRV-24910 | 2026-08-07T10:36:32Z | Martha | — | Hawkins | 2004-12-04 | UNKNOWN | N/A | ·618.753.2603 | MARTHA.HAWKINS38@OUTLOOK.COM | 3240 Baseline Rd | Houston | TX | 77021 | null | — |
| PRV | PRV-23578 | 2026-02-14T10:08:40Z | Gmez, Henry | — | — | 1957-07-16 | null | •••-••-3439 | — | — | ·8724 Bayshore Drive | Scottsdale | AZ | 85211 | NULL | — |
| PRV | PRV-23237 | 2026-05-18T08:51:55Z | ·mei | — | ellis | 1938-06-27 | ·UHC-77487-48 | — | NULL | mei.ellis@proton.me | 1321 RIDGE ROAD·· | SAN ANTONIO | Texas | 78276 | N/A | N/A |
| PRV | PRV-24877 | 2026-03-13T23:19:22Z | BRANDON·· | — | STEVENS | 11/18/1976 | — | UNKNOWN | 6343461500 | brandon.stevens@hotmail.com | UNKNOWN | - | UNKNOWN | UNKNOWN | — | — |
| PRV | PRV-26065 | 2026-05-21T02:25:14Z | brenda | — | adams | 1953-06-22 | UHC-68921-36 | NULL | (527) 847-6230 | - | 9136 DESERT SKY BOULEVARD | Orlando | FL | 32846 | NULL | null |
| PRV | PRV-28443 | 2026-06-14T09:49:33Z | Joan | ···· | Weber | 1956-02-06 | UHC-81180-90 | N/A | (839) 597-4612 | - | 1837 Sunset Blvd | Atlanta | GA | 30394 | null | ···· |
| PRV | PRV-27530 | 2026-03-10T11:30:40Z | janet | — | tucker | 1972-06-26 | UHC-36190-80 | - | 8512605489 | NULL | 4988 INDIAN SCHOOL ROAD | Minneapolis | MN | 55460-6598 | UNKNOWN | - |
| PRV | PRV-21580 | 2026-01-15T06:29:35Z | ·Jesse | J. | Hughes | 22-06-1956 | UHC-62926-91 | •••-••-8798 | 299-699-1175 | UNKNOWN | 4783 VALLEY VIEW DRIVE | Phoenix·· | Arizona | ·85059 | UNKNOWN | null |
| PRV | PRV-29331 | 2026-01-10T23:09:25Z | GLORIA·· | — | ROBINSON·· | May 28, 1986 | ···· | — | 2456991630 | ···· | 5674 Maple Avenue | Seattle | wa | 98173-6813 | — | N/A |
| PRV | PRV-24465 | 2026-01-25T00:43:41Z | ·Terry | S. | ·Peterson | 1940-03-22 | — | NULL·· | 782-661-1322 | — | 3240 Apache Boulevard | LOS ANGELES | CA | 90066 | ·NULL | — |
| PRV | PRV-27435 | 2026-07-26T08:26:34Z | jacob·· | — | james | 08/23/1992 | UHC9595982 | ·· | 12063730657 | null | 757 SPRING ST | Seattle | WA | 98199-1913 | — | MEDICARE-ADV-B |
| PRV | PRV-28828 | 2026-06-27T04:13:09Z | Logan | F | McDonald | 1979-12-13 | uhc-23240-38 | - | ·682-893-5222 | N/A | UNKNOWN | — | N/A | - | UNKNOWN | CORE-HMO |
| PRV | PRV-22505 | 2026-04-07T21:47:32Z | ALYCE | ·Q. | SALAZAR | 2002-02-23 | UHC-78437-15 | N/A | 2086741031 | — | 7779 Maple Avenue | Mesa | ·Arizona | ·85223 | N/A·· | MEDICARE-ADV-B |
| PRV | PRV-29234 | 2026-03-06T17:44:33Z | Ruth | F | Mejia | 05-02-1994 | uhc-04349-37 | ·null | +1 524 450 7176 | UNKNOWN | 4936 OCEAN AVE | Seattle | Washington·· | ·98130 | NULL | N/A |
| PRV | PRV-21796 | 2026-03-28T03:00:57Z | Emyly | U | Lopez | 20040812 | UHC-26356-08 | •••-••-3411 | (412) 701-6275 | — | 3277 Forest Avenue | Seattle | WA | ·98153 | — | — |
| PRV | PRV-29328 | 2026-07-20T23:00:57Z | KATHLEEN | — | CRAWFORD | 08/11/69 | UHC-66203-10 | •••-••-6009 | 636-326-2724 | ·N/A | ·432 Central Avenue | San Antonio | TX | 78206 | — | ·· |
| PRV | PRV-25216 | 2026-06-02T08:31:58Z | THERESA | — | MEJIA·· | 1950-03-10 | ·· | — | 537-914-8304·· | theresa.mejia59@proton.me | — | — | — | NULL | ·UNKNOWN | — |
| PRV | PRV-27523 | 2026-03-16T07:07:25Z | stephen | ·· | webb | 1950-06-21 | NULL | NULL | (702) 864-1262 | null | 7464 CANYON ROAD | Minneapolis | MN·· | — | N/A | — |
| PRV | PRV-24334 | 2026-06-14T01:32:41Z | Megan | A. | Morrison | 1981-12-16 | ·UHC-40939-67 | N/A | 18317493170 | — | ·5736 Cedar Lane | Tampa | FL | 33645 | UNKNOWN | NULL |
| PRV | PRV-26830 | 2026-07-16T21:12:25Z | Henry·· | E | Weaver | 2006-03-11 | N/A | — | +1 885 857 9234 | - | 1779 Ridge Road | Tucson | AZ | 85784-1051 | null | — |
| PRV | PRV-24354 | 2026-04-25T23:23:46Z | george | M | bell | ·· | — | - | 5028549 | ·GEORGE.BELL3@ICLOUD.COM | 3580 SPRING STREET | Seattle | ·WA | 98150 | UNKNOWN | MEDICARE-ADV-A |
| PRV | PRV-22612 | 2026-02-09T13:28:03Z | Alexander | — | James | 1942-04-05 | — | - | 6717390757 | - | 2652 Canyon Road | Scottsdale | AZ | 85237 | ·· | — |
| PRV | PRV-20698 | 2026-05-12T22:46:26Z | Jacob | — | Black | Dec 2, 1992 | null | •••-••-4783 | ·368.780.1602 | - | 8159 Canyon Road | SACRAMENTO | CA | 95831-8368 | — | N/A |
| PRV | PRV-20990 | 2026-03-31T07:04:31Z | PATRICK | — | OLSON | ·11/18/1993 | UHC-19445-85 | ·· | 8122132692 | UNKNOWN | 3332 CENTRAL AVENUE | Eden Prairie | MN | 55372 | NULL | — |
| PRV | PRV-21575 | 2026-10-06T19:49:21Z | BENJAMIN | — | OLSON | 2003-05-25 | UHC-22547-34 | — | 536.653.0115 | ·N/A | 7725 Palm Drive #418 | LAS VEGAS | NV | 89195-2721 | — | N/A |
| PRV | PRV-25533 | 2026-07-19T21:27:02Z | Graham, Samuel | — | — | 1999-05-06 | UHC-97254-51 | — | +1 678 798 4350 | samuel.graham@proton.me | ·2511 Valley View Drive | Phoenix | AZ | 85045 | - | - |
| PRV | PRV-26668 | 2026-05-25T14:34:15Z | Jacqueline | — | Bell | 1997-04-19 | — | N/A | 871-867-2673 | — | UNKNOWN | — | — | - | N/A | — |
| PRV | PRV-20603 | 2026-04-27T08:24:45Z | Christina | — | Perez | 01/20/00 | ·UHC-96033-78 | UNKNOWN | +1 455 754 4897 | ···· | 9108 Meadow Ln | Gilbert | Arizona | 85255 | null | N/A |
| PRV | PRV-22025 | 2026-05-25T20:33:30Z | Arthur | L | Bennett·· | 1999-10-06 | UHC-95087-14 | UNKNOWN | (205) 952-9160 | N/A | 9341 Forest Ave | DALLAS | TX | 75241 | — | — |
| PRV | PRV-27906 | 2026-02-20T09:16:14Z | Ethan | — | Rogers | 12/18/1938 | UHC-76883-32 | — | (869) 438-9533 | ETHAN.ROGERS8@GMAIL.COM | 1672 Spring St | San Antonio | Texas | 78251 | — | null |
| PRV | PRV-22678 | 2026-09-22T17:03:15Z | Jean | T | Shaw | 4/23/1940 | — | •••-••-9214 | 587-268-6825 | ·UNKNOWN | 6276 Elm Street | Atlanta | GA | 30308 | — | null |
| PRV | PRV-23621 | 2026-05-26T16:57:17Z | Carlos | Y. | Guerrro | 1960-03-11 | — | — | (697) 585-9369·· | ·carlos.guerrero@outlook.com | 53 Grand Avenue | Gilbert | az | 85241 | null | — |
| PRV | PRV-21945 | 2026-03-10T15:20:16Z | HAROLD | — | VEGA | null·· | UHC-62854-39 | N/A | (616) 959-4956 | harold.vega61@outlook.com | 9470 Highland Ave | Orlando | Florida | 32842 | — | — |
| PRV | PRV-25587 | 2026-09-20T08:07:25Z | Burton, Donald | — | — | 1973-02-10 | ·· | — | 18252467993 | null | 8911 Sunset Blvd | HOUSTON | Texas | 77089 | — | - |
| PRV | PRV-20785 | 2026-10-03T23:11:53Z | Kayla | — | Wells | 1985-07-02 | — | •••-••-9181 | 2699514602 | - | 16 FOREST AVENUE | Glendale | AZ | 85362 | NULL | CHOICE-PLUS-PPO |
| PRV | PRV-29432 | 2026-08-29T08:33:03Z | STEPHEN | D | BOWMAN | - | UNKNOWN | UNKNOWN·· | 683.600.9142 | NULL | 4750 INDIAN SCHOOL ROAD #414 | JACKSONVILLE | FL | 32248-5075 | — | — |
| PRV | PRV-22913 | 2026-06-19T18:02:22Z | GERALD | K | FERNANDEZ | 04/27/1951 | UHC6045838 | •••-••-2775 | (518) 739-4330 | GERALD.FERNANDEZ@OUTLOOK.COM | 6759 CAMELBACK RD | Nashville | TN | - | UNKNOWN | - |
| PRV | PRV-28131 | 2026-07-08T04:51:26Z | melissa | — | simmons | 1993-10-05 | UHC3152124 | UNKNOWN | 3114715238 | MELISSA.SIMMONS@HOTMAIL.COM·· | 3474 SAGE COURT #627 | Atlanta | GA·· | 30381 | — | - |
| PRV | PRV-20527 | 2026-04-11T23:18:40Z | ·JESSICA | — | MITCHELL | ·1962-04-20 | UNKNOWN | — | 565-313-8278 | jessica.mitchell4@icloud.com | — | ···· | N/A | — | null | N/A |
| PRV | PRV-28307 | 2026-10-07T04:24:06Z | ·Marcus | P·· | Davis | 1951-01-24·· | UHC-27003-57 | UNKNOWN | (559) 864-8628 | — | 889 ELM STREET | COLUMBUS | oh | 43225 | UNKNOWN·· | — |
| PRV | PRV-26317 | 2026-06-04T01:32:06Z | katherine | — | hughes | 1964-08-18 | UHC-58411-53 | — | 9573748697 | NULL | N/A·· | — | 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:56.316Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty