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-21784 | 2026-10-09T11:28:42Z | Linda | Y | Palmer | ·1940-08-71 | UNKNOWN | N/A·· | 9225632591 | N/A·· | 4786 Sunset Boulevard | Dallas | Texas | 75228 | — | N/A |
| PRV | PRV-24061 | 2026-07-24T19:12:56Z | Nancy | ···· | Millls | Jul 20, 1981·· | UHC-00702-28 | N/A | 470-638-9323 | NULL | 7380 OAK ST | CHARLOTTE | NC | 28244-5412 | ···· | null |
| PRV | PRV-23651 | 2026-04-14T10:51:25Z | KATHERINE | B. | SNYDER | 1982-05-12 | — | UNKNOWN | (489) 441-1543 | - | 9191 Broadway | Fresno | CA | 93754 | UNKNOWN | NULL |
| PRV | PRV-22547 | 2026-06-02T01:42:56Z | Arthur | K | Lucas | 19820911 | UNKNOWN | •••-••-0223 | N/A | arthur.lucas@proton.me | 2547 OCEAN AVE | ·Nashville | TN | 37228 | — | - |
| PRV | PRV-23619 | 2026-02-03T08:35:15Z | Brandon | — | Ward | 19850815 | UHC-12510-99 | •••-••-6170 | 13788017184 | - | 2264 Sage Court Apt 11 | Charlotte | NC | 28230 | UNKNOWN·· | UNKNOWN |
| PRV | PRV-26958 | 2026-06-21T08:20:03Z | LARRY | — | COX | 1983-06-01 | UHC-25922-95 | — | (955) 370-6658 | null·· | 4973 Grand Ave | Tampa | FL | — | — | SELECT-EPO |
| PRV | PRV-22517 | 2026-02-11T13:16:22Z | ·Dominguez, Bobby | — | — | 2005-12-21 | null | - | (870) 484-1361 | BOBBY.DOMINGUEZ@GMAIL.COM | 1263 Canyon Rd | Dallas | TX | 75265 | ·· | N/A |
| PRV | PRV-24242 | 2026-03-18T10:32:28Z | Allen, William | R | — | 1953-06-12 | - | - | +1 364 707 4187 | william.allen37@icloud.com | 430 HIGHLAND AVE | DALLAS | TX·· | 75267 | — | — |
| PRV | PRV-23761 | 2026-03-08T08:37:41Z | RUTH | — | VAZQUEZ | 9/8/2006 | UHC-11615-56 | null | 2439617794 | RUTH.VAZQUEZ2@HOTMAIL.COM | 3458 Oak St | San Antonio | ·TX | 78282 | — | — |
| PRV | PRV-27641 | 2026-01-07T00:26:23Z | Ruth | — | Ross | 1970-04-21 | UHC-60558-56 | — | ·· | — | 3071 Canyon Road | Phoenix | Arizona | 85096 | N/A·· | — |
| PRV | PRV-25394 | 2026-02-23T09:40:10Z | Ronald | ·· | Price | 1983-08-01 | UHC-60219-54 | NULL | 2872778067 | — | - | - | N/A | N/A | N/A | OPTIONS-PPO |
| PRV | PRV-27308 | 2026-03-27T04:40:52Z | Austin | C | ·Gray | 1995-04-07 | NULL | — | 617-215-5226 | austin.gray@outlook.com | ·305 Canyon Rd Apt 13 | Denver | CO | 80220 | — | — |
| PRV | PRV-29538 | 2026-05-08T19:13:09Z | saen | — | peters | 10/05/2001 | UNKNOWN | — | 340.415.8757 | — | 4637 SAGE CT Apt 5 | Houston | TX | 77053 | ·- | MEDICARE-ADV-B |
| PRV | PRV-28469 | 2026-04-13T00:35:49Z | Eryc | — | Shaw | 01/06/1996·· | - | — | 12552411340 | — | 5021 Indian School Rd | ·Charlotte | NC | 28276 | NULL | — |
| PRV | PRV-25675 | 2026-09-22T21:05:34Z | Flores, Randy | — | ·· | 4/14/1949 | UHC-96097-03 | •••-••-6876 | 18879728592 | NULL | 9683 Indian School Road Apt 33 | ORLANDO | FL | 32876-6733 | ···· | OPTIONS-PPO |
| PRV | PRV-20887 | 2026-04-09T04:59:13Z | JUDITH | — | PENA·· | Aug 25, 1939·· | UHC-47584-45 | - | 561-510-5268 | UNKNOWN | 1931 Baseline Road | Denver | Colorado | 80265 | — | — |
| PRV | PRV-27555 | 2026-04-25T12:21:24Z | benjamin | — | turner | 1986-11-22 | UHC-15001-22 | — | ·18614303476 | - | 8717 Desert Sky Blvd | San Antonio | tx | 78209 | — | -·· |
| PRV | PRV-22072 | 2026-01-17T16:22:15Z | Joshua | Q. | Munoz | 20-01-1994 | UNKNOWN | UNKNOWN | 221.459.4792 | joshua.munoz@gmail.com | 4852 Washington Street | ·Dallas | TX | 75237 | N/A | N/A |
| PRV | PRV-24390 | 2026-02-02T12:43:57Z | ERIC | — | COOPER | 02-04-1969 | UHC-23594-28 | - | 2375841 | ERIC.COOPER@OUTLOOK.COM·· | 282 UNION STREET·· | Phoenix·· | Arizona | 85008 | null | ·· |
| PRV | PRV-26070 | 2026-06-16T15:56:03Z | Patrick | — | Boyd | 1977-05-24 | UHC-93836-29 | ·· | (218) 891-3290 | NULL | 7545 MESA DRIVE | MESA | AZ | 85230 | ···· | — |
| PRV | PRV-24179 | 2026-05-28T12:39:16Z | MEGAN | — | ANDEWS | 07/14/1974 | null | — | 4377103717 | N/A·· | 9086 Palm Drive | COLUMBUS | OH | 43274 | UNKNOWN | CORE-HMO·· |
| PRV | PRV-28959 | 2026-08-03T21:42:04Z | BARB | J | STEVENS | 1977-08-17 | UHC-77280-77 | UNKNOWN | 2502990466 | — | - | — | N/A | null | NULL | OPTIONS-PPO |
| PRV | PRV-26386 | 2026-02-10T16:14:48Z | Yuki | V | Gonzales | Jun 23, 1983 | UHC-45856-82 | — | 8599703479 | YUKI.GONZALES80@ICLOUD.COM | UNKNOWN | - | NULL | NULL·· | N/A | N/A |
| PRV | PRV-21217 | 2026-07-11T09:12:09Z | Suan | — | Sanchez | 1984-01-12 | UHC-49183-97 | •••-••-5261 | — | susan.sanchez58@proton.me | - | — | NULL | — | — | NULL |
| PRV | PRV-22486 | 2026-08-11T20:57:50Z | Kathryn | Z | Sandoval | 19560911 | — | •••-••-6591 | N/A·· | UNKNOWN | 2498 Meadow Ln | Fresno | CA | 93760·· | ·· | — |
| PRV | PRV-22957 | 2026-08-30T15:11:33Z | Gabriel | — | Ward | 13-06-1972 | ···· | — | 19339841450 | ·NULL | ·UNKNOWN | ·· | NULL | — | UNKNOWN | null |
| PRV | PRV-24582 | 2026-07-22T05:35:41Z | JACQUELINE | L | PARKER | 11/17/94 | UHC-11243-95 | — | 9465218534 | jacqueline.parker8@aol.com | 4759 MESA DR | Mesa | AZ | 85254 | NULL | MEDICARE-ADV-B |
| PRV | PRV-26138 | 2026-09-21T09:58:45Z | Daniel | V. | Mendez | 12/08/2000 | - | — | N/A | — | ·7151 HIGHLAND AVE | Scottsdale | AZ | 85269 | UNKNOWN | null |
| PRV | PRV-24320 | 2026-10-18T00:29:53Z | Yuki | G. | Foster | 1987-04-23 | UNKNOWN | null | — | YUKI.FOSTER@YAHOO.COM | 3566 Lake View Rd | Sacramento | CA | 95847 | UNKNOWN·· | null |
| PRV | PRV-20084 | 2026-09-10T16:59:14Z | CHRISTINE | — | SALAZAR | 11/05/1973 | UHC-75118-47 | - | 7804785 | christine.salazar91@outlook.com | 7127 Sunset Blvd | Plano | Texas | 75020 | null | UNKNOWN |
| PRV | PRV-24601 | 2026-05-29T11:36:07Z | PRIYA | — | RAY | 5/28/1962 | UHC-58523-45 | — | +1 970 903 7558 | PRIYA.RAY@GMAIL.COM | 7268 Cedar Ln | Gilbert | AZ | 85287 | — | ·N/A |
| PRV | PRV-20763 | 2026-10-17T07:51:11Z | GREGORY | H. | RICHARDSON | 11-04-1961 | UHC-32697-71 | N/A | 290-966-7947 | null | 1687 PALM DRIVE | Dallas | TX | 75271·· | null | — |
| PRV | PRV-27949 | 2026-10-01T04:35:54Z | Brittany | M | Watson | Apr 25, 1971 | NULL | null | 8380907 | — | 3073 Market Street | Sacramento | CA | 95874 | NULL·· | - |
| PRV | PRV-27349 | 2026-06-20T11:23:48Z | ·arjun | B | coleman | 1985-06-02 | — | N/A | 849.745.0821 | — | 9309 Willow Court | Scottsdale·· | AZ | 85233 | N/A | NULL |
| PRV | PRV-21485 | 2026-01-21T06:45:06Z | JERRY | — | ANDREWS | 8/8/1974 | UHC-29366-06·· | null | 710-321-5741 | — | 3021 HILLCREST RD | Plano | TX | 75055 | — | — |
| PRV | PRV-26202 | 2026-09-06T20:15:49Z | Gregory | — | Walker | 1959-11-26·· | UHC-01696-10 | — | (474) 557-1305 | GREGORY.WALKER79@YAHOO.COM | 6576 Oak Street | GLENDALE | AZ | 85333-9121 | N/A | SELECT-EPO |
| PRV | PRV-26440 | 2026-04-20T21:04:12Z | Janet | ···· | Hunter | 2005-01-06 | NULL | •••-••-7168 | - | null | 5117 LAKE VIEW RD | Charlotte | NC | 28256 | — | — |
| PRV | PRV-22398 | 2026-05-27T01:38:05Z | HELEN | L | AUSTIN | 2003-09-10 | UNKNOWN | NULL | (582) 819-7153 | — | 9204 RIDGE ROAD | Glendale | AZ | ·85345 | null | null |
| PRV | PRV-23731 | 2026-06-22T17:44:41Z | Amanda | — | Cook | 05/04/1967 | - | •••-••-2447 | 557-845-2757 | - | 802 Sage Ct | Miami·· | FL | 33123 | — | ·SELECT-EPO |
| PRV | PRV-24783 | 2026-05-28T21:53:00Z | Victoria | W | Mitchell | 1998-08-11 | UNKNOWN | - | 794-355-8855 | - | 2965 FOREST AVENUE | ·CHANDLER | AZ | 85264 | - | null |
| PRV | PRV-24026 | 2026-06-11T17:46:28Z | Mason | — | Vasquez | 05/27/1967 | — | N/A | 6416859176 | — | - | NULL | UNKNOWN | UNKNOWN | null | — |
| PRV | PRV-27379 | 2026-05-10T17:44:59Z | CHRISTINE | V. | ·WHITE | 10/20/1945 | N/A | — | +1 651 993 0768 | - | 9707 BAYSHORE DRIVE | Gilbert | Arizona | 85269 | — | — |
| PRV | PRV-28813 | 2026-09-06T14:05:42Z | CAROL | — | WARREN·· | 1952-07-21·· | - | — | 772-728-3716 | carol.warren70@gmail.com | 7040 Hillcrest Rd | Gilbert | AZ | NULL | UNKNOWN | — |
| PRV | PRV-28283 | 2026-08-07T18:41:19Z | alice | — | cruz | 1939-01-08 | - | — | 14732383423 | N/A | 4350 Meadow Lane | Houston·· | TX | 77029 | null | NULL |
| PRV | PRV-23963 | 2026-03-05T00:07:40Z | Russell | — | Gray | 2002-03-16 | null | null | 5432285784 | NULL | 92 PALM DR | Eden Prairie | MN | 55349 | — | null |
| PRV | PRV-21881 | 2026-04-09T15:46:06Z | mark | G. | santos | 19450506 | NULL | — | (828) 394-6181 | - | 8733 PARK PLACE | LOS ANGELES | CA | 90042 | ·· | — |
| PRV | PRV-26492 | 2026-10-16T07:09:27Z | CHRISTINA | — | GRAHAM | 2000-01-21 | UHC4176003 | - | (755) 453-8929 | christina.graham@icloud.com | 6748 CAMELBACK RD | Jacksonville | Florida | 32250 | null | — |
| PRV | PRV-20028 | 2026-08-06T23:17:17Z | MORALES | — | DEBRA | 1999-05-17 | — | N/A·· | 462-754-1837 | debra.morales3@outlook.com | 6145 Elm Street | Las Vegas | NV | 89152 | - | OPTIONS-PPO |
| PRV | PRV-26426 | 2026-10-14T06:18:06Z | WAYNE | B | LEE | 1949-01-02 | UHC-57483-83 | •••-••-3606 | (875) 438-4567·· | — | 6588 Sage Ct | DENVER | CO | 80286 | UNKNOWN | UNKNOWN |
| PRV | PRV-28944 | 2026-05-02T14:13:35Z | Janet | — | Grant | 1991-05-18 | null | •••-••-7880 | (431) 273-7256 | JANET.GRANT1@GMAIL.COM | 7089 WILLOW COURT | Los Angeles | CA | - | 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:46.429Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty