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-27813 | 2026-02-21T15:28:38Z | ·ETHAN | Y | FOSTER | 1941-08-06 | NULL | — | 2555960 | NULL | 7698 Lincoln Way | Minneapolis | MN·· | 55426 | — | N/A |
| PRV | PRV-24129 | 2026-01-23T10:28:12Z | Matt | ···· | Lewis | 1980-08-11 | UHC-42467-38 | •••-••-3927 | +1 738 674 2007 | — | 2427 Harbor Blvd | Tempe | ·Arizona | 85217 | null | UNKNOWN |
| PRV | PRV-24383 | 2026-04-05T23:58:09Z | Amanda | — | Parker | 1947-02-27 | UHC-47167-27 | — | 293.829.8489 | amanda.parker84@yahoo.com | null | ·- | N/A | NULL | UNKNOWN | SELECT-EPO |
| PRV | PRV-26936 | 2026-02-01T08:38:51Z | scott | ·· | marshall | 19850216 | UHC-57608-82 | •••-••-2193 | 781-641-4872 | null | 6184 CHURCH STREET | Glendale | AZ | 85347 | — | null |
| PRV | PRV-21119 | 2026-01-25T13:05:44Z | Mark | — | Hudson | 2002-05-17 | UHC-88797-59 | — | 332-377-2261 | — | ·2758 BROADWAY | Gilbert | ·AZ | 85283 | — | UNKNOWN |
| PRV | PRV-21390 | 2026-06-25T11:20:02Z | Bradley | — | Schmidt | 16-04-1954 | UHC-91040-77 | •••-••-9408 | 9573535031 | BRADLEY.SCHMIDT33@AOL.COM | 7492 Camelback Road | Eden Prairie·· | MN | 55395 | - | null |
| PRV | PRV-26914 | 2026-06-26T11:00:39Z | Kevin | — | Franklin | 1971-02-24 | UHC-60980-69 | •••-••-2343 | 3168431466 | kevin.franklin@hotmail.com | 4629 Willow Ct | Nashville | TN | 37284·· | N/A | — |
| PRV | PRV-25554 | 2026-08-15T14:29:30Z | Brittany | — | ·Hill | 2008-08-16 | N/A | UNKNOWN | (483) 958-0570 | — | 9432 Elm Street | ORLANDO | FL | 32875 | NULL | NULL |
| PRV | PRV-24431 | 2026-05-23T18:41:48Z | NATHAN | S | SALAZAR | 19680303 | NULL | - | 844-835-8897·· | null | null | UNKNOWN | — | — | - | — |
| PRV | PRV-29108 | 2026-10-18T10:36:39Z | Kevin | L | Hoffman | Oct 27, 2006 | NULL | — | ·(892) 808-2700 | NULL | 3210 Park Pl | Miami | Florida | 33188 | null | - |
| PRV | PRV-25779 | 2026-01-14T12:10:27Z | Raymond | — | Sullivan | 08/22/1989 | — | N/A | 4874231313 | raymond.sullivan@proton.me | 5591 SAGE COURT #134 | Chandler | AZ | 85201-4036 | — | — |
| PRV | PRV-28354 | 2026-10-01T08:51:15Z | STEVEN | P. | BLACK | 1977-09-05 | N/A | — | (825) 802-2336 | — | 7645 Sage Court #969 | Scottsdale | Arizona | 85251 | null | MEDICARE-ADV-B |
| PRV | PRV-24606 | 2026-03-30T17:20:45Z | lri | — | foster | 1993-05-17 | UHC-94326-05 | NULL | 4796326521 | ·NULL | 8427 River Rd | Eden Prairie | MN | 55339 | — | — |
| PRV | PRV-24835 | 2026-01-27T00:13:03Z | Albert | — | Payne | 11/24/2001·· | — | •••-••-7812 | (599) 855-7374 | UNKNOWN | — | UNKNOWN | — | — | - | — |
| PRV | PRV-21150 | 2026-04-01T15:30:49Z | CHARLOTTE | — | SOTO | 06-07-1999 | NULL·· | •••-••-3515 | 396-525-9977 | NULL | ·8267 PINE DR | ·SAN DIEGO | CA | 92129-5723 | null | - |
| PRV | PRV-22513 | 2026-08-14T04:14:21Z | Samuel | — | Payne | 19761225 | UHC-26523-27 | NULL | 2856540118 | NULL | 3658 Highland Ave | Plano | TX·· | 75059 | UNKNOWN | — |
| PRV | PRV-28583 | 2026-08-30T04:11:29Z | Eugene | — | Elliott | Jul 24, 2000 | UHC-39633-75 | •••-••-4485 | 318-293-6242 | eugene.elliott@outlook.com | — | null·· | - | — | N/A | - |
| PRV | PRV-26204 | 2026-03-17T05:37:56Z | Jose | — | Chapman | 1947-03-16 | UNKNOWN | NULL | - | jose.chapman75@gmail.com | — | — | ·UNKNOWN | null | — | — |
| PRV | PRV-28225 | 2026-04-13T14:06:41Z | Carl | — | Russell | 1790-11-28 | UHC-40882-68 | •••-••-2188 | 9883728663 | CARL.RUSSELL@PROTON.ME | 3970 PALM DR | Dallas | TX | 75204 | — | — |
| PRV | PRV-22627 | 2026-07-12T14:34:44Z | ·Bradley | — | Baker | 2/18/1997 | — | •••-••-1707 | 268-791-6853 | BRADLEY.BAKER66@YAHOO.COM | ·5704 BROADWAY | Sacramento | CA | 95852 | N/A | ···· |
| PRV | PRV-25753 | 2026-04-07T10:53:35Z | santiago | O | hamilton | 2007-02-12 | UHC-80543-19 | N/A | NULL | santiago.hamilton31@proton.me | 6075 CANYON RD | Phoenix | AZ | 85080·· | N/A | — |
| PRV | PRV-22485 | 2026-10-01T09:18:45Z | Diaz, Janice | — | — | 06/13/87 | UHC-88057-73 | UNKNOWN | UNKNOWN | N/A | 2994 Indian School Rd | CHANDLER | az | 85267 | - | — |
| PRV | PRV-24372 | 2026-07-23T08:59:35Z | Doris | X | Carroll | 10/24/1985·· | UHC-14268-87 | — | 477.602.8146 | N/A | 5143 Indian School Road | Dallas·· | TX | 75295 | NULL | MEDICARE-ADV-A |
| PRV | PRV-25623 | 2026-02-03T13:42:34Z | ARJUN | — | ·BARNES | 2000-11-01 | — | •••-••-9128 | (203) 245-2113 | - | ·N/A | NULL | — | null | NULL | — |
| PRV | PRV-26495 | 2026-03-17T06:18:44Z | BRIAN | — | COLEMAN·· | 28-01-1948 | NULL | N/A | ·8497860912 | — | 4479 Ocean Avenue | San Antonio | TX | 78252-5143 | UNKNOWN·· | N/A |
| PRV | PRV-28815 | 2026-03-31T00:06:57Z | ·JSHUA | — | STEWART | 2/15/1988 | null | UNKNOWN | 661-897-9534 | UNKNOWN | 1223 Sunset Blvd #828 | Seattle | WA | N/A | ·· | UNKNOWN |
| PRV | PRV-24499 | 2026-10-10T08:53:09Z | SEAN·· | — | MEYER | 11/03/49 | NULL | — | 4655735390 | UNKNOWN | 158 Mesa Dr | Tucson | AZ | ·85781 | null | MEDICARE-ADV-A |
| PRV | PRV-27577 | 2026-03-05T05:39:00Z | TERRY | ···· | KING | 1952-12-21 | UHC-36331-36 | — | 683-785-8953 | null | ···· | — | NULL | — | — | NAVIGATE-HMO |
| PRV | PRV-29142 | 2026-05-25T02:48:21Z | charlotte | N | ferguson | 06/01/1982 | - | NULL | 15223505975 | - | 1240 Mesa Dr | Gilbert | AZ | 85240 | - | UNKNOWN |
| PRV | PRV-28605 | 2026-05-09T22:47:01Z | BRUCE | — | FOX | 09/06/79 | UHC-44206-81 | NULL | 7739939925 | N/A | 4844 Cedar Ln | ·Austin | Texas | 78744-6387 | — | NULL |
| PRV | PRV-24206 | 2026-06-05T00:18:08Z | REBECCA | — | LEWIS | 1967-03-26 | — | -·· | 805-932-7399 | ·NULL | — | — | null | — | null | — |
| PRV | PRV-25800 | 2026-07-22T10:09:56Z | GERALD | E | FISHER | 6/8/1943 | — | — | (615) 927-2625 | gerald.fisher86@proton.me | 268 INDIAN SCHOOL RD | Charlotte | NC | 28241 | N/A·· | MEDICARE-ADV-B |
| PRV | PRV-23537 | 2026-03-28T04:13:10Z | KATHLEEN | — | HILL | 18-03-1999 | UHC-13926-37 | null | (295) 385-8485·· | kathleen.hill@icloud.com | 8010 Oak Street | Fresno | California | 93746 | N/A | ···· |
| PRV | PRV-27612 | 2026-04-24T20:28:26Z | Ruth | ···· | Moreno | 1977-10-01 | - | N/A | (342) 503-8145 | ·· | 8783 Mesa Drive | Dallas | TX | 75231 | — | — |
| PRV | PRV-27035 | 2026-04-25T02:52:04Z | Stone, Ronald | — | — | 8/28/1948 | UHC-20959-12 | null | — | UNKNOWN | 643 Forest Avenue | Glendale | AZ | 85359 | NULL | N/A |
| PRV | PRV-28140 | 2026-08-26T22:10:00Z | Madison | — | Nichols | 1945-06-25 | — | — | (640) 227-8933 | MADISON.NICHOLS39@OUTLOOK.COM | 9777 DESERT SKY BLVD | Jacksonville | FL | 32201 | — | N/A |
| PRV | PRV-28676 | 2026-10-09T17:23:18Z | janice | — | willis·· | 1943-09-05 | — | ·· | (318) 681-3969 | NULL | — | NULL | — | UNKNOWN | UNKNOWN | null |
| PRV | PRV-23247 | 2026-07-01T22:54:08Z | Turner, Camila | — | — | 05/10/90 | UHC-89373-58·· | N/A | (600) 966-7929 | -·· | 9865 Mesa Dr | Charlotte | NC | ·28218 | - | NAVIGATE-HMO |
| PRV | PRV-20030 | 2026-10-11T07:58:57Z | Denise | E. | Elliott | 09/26/1948 | UHC-47105-88 | •••-••-7764 | 4197073922 | — | N/A | — | N/A | — | N/A | ·UNKNOWN |
| PRV | PRV-27005 | 2026-09-29T23:38:11Z | Benjamin·· | — | Stephens | 2000-09-03 | UHC-97938-47 | UNKNOWN | 5797937196 | ·benjamin.stephens43@yahoo.com | 7552 Sunset Boulevard | Scottsdale | AZ | 85263 | UNKNOWN | UNKNOWN |
| PRV | PRV-28572 | 2026-10-10T01:32:40Z | SARA·· | — | ·WILLIAMS | 1973-12-22 | — | NULL | 688.700.4716 | — | 5037 Washington St | SEATTLE | WA | ···· | UNKNOWN | N/A |
| PRV | PRV-20942 | 2026-08-08T21:16:46Z | ARTHUR | M. | HALL | 11/24/38 | — | NULL | 2655323170 | - | 686 CHURCH STREET·· | Glendale | AZ | 85360 | — | - |
| PRV | PRV-28079 | 2026-04-27T04:53:05Z | Patel, Brian | — | — | 1955-12-13 | - | UNKNOWN | 8403111600 | N/A | 2765 Lincoln Way | Charlotte | NC | 28200 | null | — |
| PRV | PRV-22367 | 2026-01-06T23:24:01Z | THOMAS·· | I | SULLIVAN | 1982-02-28 | UNKNOWN | - | 7659727137 | thomas.sullivan@gmail.com | 8589 Indian School Rd | DENVER | CO | 80285 | N/A | null |
| PRV | PRV-26858 | 2026-10-07T04:42:01Z | kimberly | — | chapman | 1980-11-22 | UHC-86534-05 | — | 425-892-9299 | UNKNOWN | 3546 Meadow Lane | Mesa | AZ | 85213 | null | UNKNOWN |
| PRV | PRV-28925 | 2026-07-03T18:13:24Z | Roger | — | Wallace | 2007-10-20 | UHC-81010-87 | null | 4674144459 | roger.wallace@aol.com | 9216 LAKE VIEW RD | ·Las Vegas | NV | 89131 | — | CHOICE-PLUS-PPO |
| PRV | PRV-28074 | 2026-05-06T17:35:25Z | CYNTHIA | B | BURKE | Jun 14, 1950 | — | null·· | 9508055680 | — | ·5687 Central Ave | Fresno | CA | 93732-6652 | null | SELECT-EPO |
| PRV | PRV-20979 | 2026-05-17T15:15:27Z | Ryan | ·· | Patel | 04/15/2008 | uhc-56279-29 | ·null | 506-868-6599 | ryan.patel@yahoo.com | 2016 Pine Dr | San Antonio | Texas | 78270 | NULL | — |
| PRV | PRV-22302 | 2026-10-18T12:22:00Z | BENJMAIN | R | TAYLOR·· | 1985-01-15 | UHC-56897-70 | - | 5406899345 | ···· | 6028 Maple Avenue | HOUSTON | Texas | 77028 | ···· | CHOICE-PLUS-PPO |
| PRV | PRV-21267 | 2026-01-13T20:59:23Z | Gloria | V | Ortega | 2007-02-20 | — | — | N/A | NULL | 4707 Highland Ave | TEMPE | AZ | 85252 | NULL | 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.628Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty