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-20095 | 2026-01-30T00:35:41Z | Kyle | — | Mason | 2008-03-16 | - | null | 3804832 | - | 9092 PARK PL | Orlando | Florida·· | 32888-1900 | NULL | UNKNOWN |
| PRV | PRV-21189 | 2026-05-17T04:40:07Z | Little, Marcus | T. | — | 2001-03-28 | N/A | - | 872-584-1589 | ·N/A | 9687 RIDGE RD | GILBERT | AZ | 85266 | — | MEDICARE-ADV-A |
| PRV | PRV-27310 | 2026-07-29T21:12:26Z | FRANK | — | ROBERTSON | 1984-02-24 | UHC-54618-22 | — | 458-259-7528 | — | 5146 JEFFERSON AVE | Miami | FL | 33166-4839·· | N/A | null |
| PRV | PRV-20905 | 2026-02-26T04:38:03Z | JOYCE | L | HUNT | 08/26/1983 | UHC-86921-20 | ·N/A | 2477112906 | — | 2307 Sage Ct | Phoenix·· | ·Arizona | 85069 | — | — |
| PRV | PRV-25298 | 2026-10-02T07:04:54Z | Taylor, Benjamin | — | — | 2001-12-08 | UHC-67866-65 | •••-••-7759 | 940.590.8262 | NULL | 6565 CEDAR LANE | Las Vegas | NV | ·UNKNOWN | UNKNOWN | CORE-HMO |
| PRV | PRV-23490 | 2026-08-23T06:22:58Z | ANDREW | — | LEE | 1991-10-06 | — | •••-••-8401 | N/A | ·andrew.lee47@proton.me | 9648 GRAND AVENUE·· | EDEN PRAIRIE | MN | 55342 | N/A | N/A |
| PRV | PRV-28164 | 2026-01-19T04:38:19Z | Nick | ·· | ·West | 1984-01-12 | UHC-15259-45 | N/A | 2395018715 | ·nicholas.west@proton.me | 5521 Grand Avenue | Fresno | CA | 93776 | — | N/A |
| PRV | PRV-28578 | 2026-06-10T11:41:19Z | NICOLE | B | ·JORDAN | 06/05/1958 | UHC-95049-23·· | — | 665-214-2279 | null | UNKNOWN | — | — | — | UNKNOWN | - |
| PRV | PRV-22942 | 2026-05-07T20:39:28Z | Michelle | — | King | ·Feb 12, 1961 | UHC5927180 | •••-••-1012 | (484) 241-8246 | michelle.king@yahoo.com | 973 Maple Ave·· | Jacksonville | FL | 32293 | UNKNOWN | - |
| PRV | PRV-20139 | 2026-09-30T11:11:49Z | ·Debra | — | Davis·· | 1986-02-13 | — | — | (834) 647-8281·· | ·NULL | 1252 Church Street | Orlando | FL | 32862 | ·· | — |
| PRV | PRV-22974 | 2026-06-29T01:19:37Z | Dylen | — | Wheeler | 2000-01-26 | UHC-34756-24 | null | (705) 810-3344 | — | 5635 PALM DRIVE | EDEN PRAIRIE | MN | 55303 | - | ·UNKNOWN |
| PRV | PRV-23225 | 2026-02-10T14:01:19Z | Scott | — | Nguyn | 20030704 | UHC-18187-48 | NULL | 16503855194 | N/A | 343 Broadway·· | Phoenix | AZ | 85047 | — | — |
| PRV | PRV-25447 | 2026-07-05T17:10:01Z | arthur | — | hunt | 1914-03-03 | UHC-45720-74 | — | 8695945763 | arthur.hunt@icloud.com | 6255 Valley View Drive | COLUMBUS | OH | 43246 | — | UNKNOWN |
| PRV | PRV-22300 | 2026-06-02T11:03:33Z | ·PRIYA | I. | PRICE | NULL | - | - | NULL·· | null | NULL | null | null | — | NULL | — |
| PRV | PRV-23987 | 2026-06-21T12:24:43Z | theresa | — | mendez | 1976-12-25 | - | — | (475) 823-2018 | — | 7707 River Road | Miami | FL | 33156-3536 | - | — |
| PRV | PRV-23130 | 2026-08-05T13:03:51Z | Samuel | — | Marshall | 2008-01-11 | ·uhc-42128-45 | N/A·· | - | samuel.marshall90@proton.me | — | — | — | — | UNKNOWN·· | N/A |
| PRV | PRV-25068 | 2026-09-11T20:59:25Z | Mason | O. | Thompson·· | 1973-11-12 | — | •••-••-4076 | 651-348-3310 | mason.thompson74@proton.me | 3206 Willow Ct | Tucson | AZ | 85745 | — | null |
| PRV | PRV-29066 | 2026-04-05T12:49:07Z | AARON | ···· | FREEMAN | 1945-07-07 | NULL | — | (979) 256-5843 | — | 6995 Oak Street | MESA·· | Arizona | ·85216 | — | — |
| PRV | PRV-29178 | 2026-01-14T16:41:45Z | Mason | — | Stephen | 1947-02-10 | ···· | UNKNOWN·· | (345) 511-0924 | STEPHEN.MASON25@AOL.COM | 5786 Church St | Austin | TX | 78721 | ·- | OPTIONS-PPO |
| PRV | PRV-29500 | 2026-04-12T08:13:38Z | ARJUN | — | ·HANSON | 1962-01-24 | UHC-47578-88 | N/A | +1 628 732 6931 | — | 7609 Spring St | Seattle | WA | null | — | SELECT-EPO |
| PRV | PRV-24639 | 2026-09-30T16:27:45Z | Diego | — | Jimenez | 1957-09-14 | UNKNOWN | ···· | ·720-452-0066 | N/A | — | null | — | — | - | UNKNOWN |
| PRV | PRV-22132 | 2026-10-01T08:14:03Z | Christopher | N | Webb | 1988-01-17 | UHC6269847 | N/A | — | CHRISTOPHER.WEBB@OUTLOOK.COM | 3164 UNION ST | Houston | TX | 77068 | — | ·N/A |
| PRV | PRV-21408 | 2026-03-23T11:35:36Z | Nguyen, Yuki | — | — | 22-01-1955 | UHC-27496-70 | — | +1 868 630 6366 | ·yuki.nguyen39@hotmail.com | ·1631 Jefferson Avenue | Orlando | ·FL | 32805 | NULL | MEDICARE-ADV-B |
| PRV | PRV-20262 | 2026-03-22T07:40:13Z | Hannah | — | Burke | 2008-11-14·· | UHC-00120-23 | UNKNOWN | — | N/A | 7092 Canyon Rd | Chandler | AZ | 85257 | - | null |
| PRV | PRV-29537 | 2026-02-12T15:39:44Z | Jeremy | — | Jacobs·· | 10/04/1965 | UHC5163028 | •••-••-2585 | N/A | UNKNOWN | 4442 MEADOW LANE | SEATTLE | WA | 98134-1824 | null | NULL |
| PRV | PRV-24463 | 2026-09-03T17:34:32Z | EDWARD | — | GARCIA | 1942-12-09 | ·UNKNOWN | null·· | 481.860.2544 | UNKNOWN | 5691 LINCOLN WAY | Austin | TX | 78786 | — | ·null |
| PRV | PRV-23005 | 2026-07-14T13:38:23Z | VINCENT | K. | SMITH | 1954-08-27 | — | UNKNOWN | (349) 226-1141 | VINCENT.SMITH@AOL.COM | 2219 CANYON RD | SAN DIEGO | CA | 92184 | null | — |
| PRV | PRV-27416 | 2026-05-26T02:44:50Z | — | — | — | 02/18/40 | UHC-46209-51·· | ·N/A | 685.291.7215 | N/A | ·3684 CHURCH ST | Charlotte | NC | 28202 | null | SELECT-EPO |
| PRV | PRV-22318 | 2026-03-02T06:06:32Z | Roger | X. | Stephens | 1991-01-11 | — | UNKNOWN | 9248808854 | roger.stephens@outlook.com | 8151 Indian School Rd | JACKSONVILLE | FL | N/A | — | NULL |
| PRV | PRV-22097 | 2026-07-29T22:03:52Z | Yang, Christian | — | ·· | 01-08-1945 | — | NULL | 9002477102 | christian.yang@proton.me | NULL | UNKNOWN | — | UNKNOWN | null·· | SELECT-EPO·· |
| PRV | PRV-22217 | 2026-07-15T00:09:52Z | Maldonado, Lawrence | ···· | — | 1994-07-20 | — | — | (813) 298-0919 | NULL | 7498 Main Street | Glendale | AZ | — | - | null |
| PRV | PRV-24410 | 2026-09-30T13:30:55Z | Janet | — | Jones | 1955-05-14 | UHC-82508-98 | — | 3788306660 | NULL | 2586 River Rd | Eden Prairie | MN | 55337 | N/A | — |
| PRV | PRV-23819 | 2026-09-27T16:24:11Z | Carlson, Steven | C. | — | 09/04/1961 | UHC-37154-70 | •••-••-7962 | 469.472.2563 | — | 4558 HARBOR BLVD·· | HOUSTON | TX | 77065 | NULL | SELECT-EPO |
| PRV | PRV-22615 | 2026-01-01T07:43:35Z | Mary | — | Moreno | 1992-12-28 | — | null | 9167791678 | ·N/A | 2055 CEDAR LANE Apt 30 | Phoenix | AZ | 85050-5681 | UNKNOWN | N/A |
| PRV | PRV-23520 | 2026-06-08T20:29:56Z | Peter | — | Gomez | 2006-03-07 | UHC-23915-84 | ·UNKNOWN | 8544406564 | — | ·7109 APACHE BOULEVARD | Tampa | ·FL | 33676 | ·· | — |
| PRV | PRV-25347 | 2026-03-07T03:28:13Z | Jordan | Z | Perry | 1955-11-17 | — | — | (620) 952-9652 | — | 6145 Sunset Blvd Apt 15 | Phoenix | AZ | - | N/A | — |
| PRV | PRV-25494 | 2026-05-29T16:56:56Z | Miller·· | S | Santiago | 1996-07-17 | UHC-18873-04 | NULL | (450) 845-6758 | — | 161 BROADWAY | Scottsdale | az | 85210 | N/A·· | NULL |
| PRV | PRV-21980 | 2026-06-23T03:24:19Z | gloria | ···· | stone | 1965-04-03 | UHC-46016-18 | — | (486) 337-6974 | NULL | 2107 Park Pl | Charlotte | North Carolina | — | UNKNOWN | null |
| PRV | PRV-22029 | 2026-03-11T01:41:51Z | BRIAN | J. | TAYLOR | 1941-09-09·· | UHC-39486-76 | — | 287-278-4657 | brian.taylor@icloud.com | 3111 Mesa Dr | Columbus | oh | 43207 | — | UNKNOWN |
| PRV | PRV-24376 | 2026-02-21T01:38:57Z | Donna | — | Austin | 1956-02-08 | -·· | N/A | 760-359-2571 | ·donna.austin@yahoo.com | ·3198 Maple Avenue | FRESNO | CA | 93784 | — | — |
| PRV | PRV-20929 | 2026-03-14T18:06:00Z | Diego | S | Nunez | 11/26/2001 | NULL | — | 4509062·· | — | 6629 Canyon Rd | Scottsdale | AZ | 85214·· | — | NAVIGATE-HMO |
| PRV | PRV-25952 | 2026-10-08T05:21:34Z | Christina | — | Hunter | 1598-08-07 | uhc-22457-29 | null | 6496449248 | christina.hunter22@icloud.com | 8080 Palm Dr | Atlanta | GA | 30331 | N/A·· | MEDICARE-ADV-B |
| PRV | PRV-23360 | 2026-10-05T17:03:32Z | ALICE | — | REED | 1960-03-07·· | UHC-07621-79 | — | 2868782398 | — | 8551 Park Place | TUCSON | AZ | 85740 | NULL | UNKNOWN |
| PRV | PRV-29010 | 2026-01-22T02:07:26Z | KATHERINE | Q | WHEELER | 1982-06-17 | UHC1425982 | null | (945) 917-1020 | ·· | 5094 Maple Avenue | Las Vegas | NV | 89196 | null | UNKNOWN·· |
| PRV | PRV-28619 | 2026-05-21T16:38:51Z | Michael | — | Montgomery | 1992-03-02 | UHC-33107-34 | •••-••-8753 | 223-446-0888 | ·N/A | 3406 UNION STREET | Nashville | TN | 37273 | — | null |
| PRV | PRV-23766 | 2026-10-13T12:21:37Z | Gabriel | — | Perry·· | 1957-04-25 | UHC-42198-20 | NULL | 6486338621 | null | 2064 Baseline Road | Denver·· | CO | 80297 | — | — |
| PRV | PRV-27582 | 2026-09-24T18:16:56Z | Theresa | — | Andresw | 2005-05-21 | NULL | N/A | 3275187034 | UNKNOWN·· | 4366 Spring St | Charlotte | NC | 28247 | — | NULL |
| PRV | PRV-24317 | 2026-04-23T13:17:34Z | JACK | ·A | CHAVEZ | May 15, 1996 | - | null | (531) 618-7191 | UNKNOWN | 3756 SUNSET BLVD | GILBERT | AZ | 85275-7327 | — | CHOICE-PLUS-PPO |
| PRV | PRV-26318 | 2026-05-12T22:26:28Z | Katherine | — | Hughes | 1964-08-18 | NULL | — | (957) 374-8697 | NULL | 3745 Maple Ave Apt 17 | San Diego | CA | 92114 | — | OPTIONS-PPO |
| PRV | PRV-25951 | 2026-06-09T11:35:50Z | Priya | — | Ramos | 03/13/1960 | UHC-54011-48 | ·· | ·(217) 834-6182 | null | 814 Apache Boulevard | Miami | FL·· | 33179 | - | 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:43:03.748Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty