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-24743 | 2026-02-28T22:33:31Z | Albert | — | Reed | 1972-02-19 | — | NULL | 805.319.4501 | - | 2018 Desert Sky Boulevard | ·Tampa | Florida | 33650 | null | MEDICARE-ADV-A |
| PRV | PRV-25971 | 2026-05-16T06:32:22Z | Marcus | ·· | Bishop | 2007-09-13 | null | N/A | +1 955 694 1252 | — | 853 Park Place | Gilbert | AZ | 85203 | N/A | - |
| PRV | PRV-23903 | 2026-04-04T11:19:16Z | TYLER | X. | DOMINGUEZ | Nov 27, 1982 | UHC-61632-38 | - | 912-288-5514 | tyler.dominguez38@outlook.com | 7545 Canyon Rd | Nashville | TN | 37239 | NULL | N/A |
| PRV | PRV-28636 | 2026-04-10T20:38:11Z | Megan | — | Elliott | 03/18/99 | UHC-54964-91 | null | NULL·· | ·megan.elliott36@icloud.com | 2593 HARBOR BOULEVARD | ORLANDO | FL | ·32822 | — | — |
| PRV | PRV-24854 | 2026-04-10T14:10:26Z | Hiroshi | — | Hudson | 1986-01-26 | — | •••-••-7582 | 7546783296 | hiroshi.hudson24@aol.com | 6665 Washington St | ·ORLANDO | FL | 32842 | N/A | MEDICARE-ADV-B |
| PRV | PRV-21729 | 2026-02-11T05:33:53Z | alexander | — | reed | 08/02/1960 | UHC-32257-08 | •••-••-7592 | (435) 273-1328 | ·· | 7671 Church Street | Austin | TX | 78717 | null·· | — |
| PRV | PRV-23508 | 2026-07-17T13:36:00Z | Jack | — | Soctt·· | 8/22/1949 | UHC-60017-55 | - | 633-307-8231 | — | 6031 Elm Street #686 | Las Vegas | Nevada | 89167 | N/A·· | — |
| PRV | PRV-27895 | 2026-02-20T03:30:49Z | Joe | G | ·Bishop | Oct 4, 1967 | UHC-26419-88 | •••-••-6896 | (625) 825-9436 | joe.bishop@hotmail.com | 3979 Elm Street Apt 38 | Gilbert | AZ | 85264 | - | null |
| PRV | PRV-20651 | 2026-03-12T18:35:36Z | Noah | ···· | Morris | 1981-10-14 | N/A | UNKNOWN | (239) 466-2279 | ·noah.morris68@icloud.com | 6769 Park Place | Glendale | Arizona | 85301 | NULL | null |
| PRV | PRV-25413 | 2026-06-27T02:09:47Z | Warren, Christine | — | — | 1963-10-03 | — | •••-••-8806 | 802-667-9446 | — | 9742 SUNSET BLVD | Dallas | TX | 75248 | -·· | - |
| PRV | PRV-28177 | 2026-09-30T09:35:41Z | Randy | R | Vazquez | 1960-06-15 | UHC-86837-23 | - | 636-577-8967 | null | 9686 LAKE VIEW ROAD | ·Austin | TX | 78792 | - | — |
| PRV | PRV-20946 | 2026-03-17T08:24:01Z | David | F | Garcia | 2008-01-09 | UHC-62582-34 | NULL | (263) 565-3685 | — | 6698 MESA DR | San Diego | CA | 92147 | — | UNKNOWN |
| PRV | PRV-23076 | 2026-06-19T21:44:05Z | ·Amanda | ·· | Foster | 1974-01-09 | UHC-46520-48 | N/A | (728) 719-7021 | null | 395 WASHINGTON ST | San Diego | CA | ·92199 | NULL | null |
| PRV | PRV-21912 | 2026-04-02T17:54:28Z | joan | — | estrada | Sep 22, 1989 | NULL·· | NULL | 726-445-1391 | - | 5173 Highland Avenue | Nashville | Tennessee | 37298 | — | - |
| PRV | PRV-21773 | 2026-06-12T10:46:41Z | laura | — | perkins | 1956-09-28 | — | - | 820.677.8065 | laura.perkins@icloud.com | ·5448 Baseline Road | Minneapolis | MN·· | 55493 | - | — |
| PRV | PRV-25229 | 2026-06-24T21:49:31Z | Matthew | P | Riec | 1999-03-22 | N/A·· | •••-••-3219 | 8689471631 | -·· | 6058 Apache Boulevard | Houston | TX | 77066-3977 | ···· | — |
| PRV | PRV-26674 | 2026-03-02T04:11:21Z | Beverly | — | Nunez | 2004-02-22 | UHC-70757-60 | — | 8342549266 | BEVERLY.NUNEZ@ICLOUD.COM | 9033 Washington St | Minneapolis | MN | 55439 | — | MEDICARE-ADV-A |
| PRV | PRV-24515 | 2026-08-31T13:12:03Z | Brandon | G | Rivera | 1991-04-07 | UNKNOWN | UNKNOWN | +1 773 552 1965 | null·· | 5041 Jefferson Ave | Glendale·· | AZ·· | 85328 | N/A | ·· |
| PRV | PRV-22967 | 2026-05-06T07:51:14Z | Paul | — | Bryant | 1941-11-16 | UHC-60881-82 | - | 290-375-2486 | — | 2302 Sage Court | Los Angeles | CA | 90001 | - | null |
| PRV | PRV-26250 | 2026-09-13T06:39:44Z | Jessica | — | Guerrero | 1953-09-21 | UHC-43793-55·· | NULL | 4625519389 | — | 747 Canyon Road | Gilbert | AZ | ·85223 | — | NAVIGATE-HMO |
| PRV | PRV-25097 | 2026-10-08T05:48:31Z | ashley | W | snyder | 1941-10-24 | UHC-84216-89 | NULL | 359-845-7145 | UNKNOWN | 3146 SAGE COURT #677 | Nashville | TN | 37209 | — | CORE-HMO |
| PRV | PRV-29565 | 2026-09-24T05:46:00Z | MELISSA | — | PEREZ | 08/04/1938 | UHC-17175-25 | — | 939-537-7186 | ·UNKNOWN | 631 Union Street | Sacramento | CA | 95842 | — | UNKNOWN |
| PRV | PRV-20043 | 2026-08-29T23:04:53Z | DORIS | T. | MENDOZA | 1986-11-26 | UHC-29920-87 | •••-••-4666 | (306) 997-7547 | null | 5813 WILLOW COURT | Charlotte | NC | — | N/A | SELECT-EPO |
| PRV | PRV-26029 | 2026-03-20T17:04:49Z | Theresa | — | Green | 06/17/1989 | NULL | •••-••-1093 | N/A | — | 3471 Hillcrest Road | CHANDLER | AZ | 85238 | UNKNOWN | MEDICARE-ADV-B |
| PRV | PRV-24660 | 2026-06-21T11:01:07Z | Teresa | — | Vazquez | 2003-03-18 | null | — | (292) 466-1981 | TERESA.VAZQUEZ3@HOTMAIL.COM | 6244 Union Street | Plano | TX | 75087 | null·· | — |
| PRV | PRV-27918 | 2026-03-21T10:47:40Z | BILLY | — | MILLS | 1946-11-11 | — | N/A | — | — | 8661 INDIAN SCHOOL RD | ·PLANO | TX | 75097 | N/A | ·· |
| PRV | PRV-27192 | 2026-02-26T12:35:34Z | MARK | — | SCHULTZ | 1984-04-08·· | UNKNOWN | N/A | (692) 588-9993 | mark.schultz6@proton.me | 3302 Palm Drive Apt 25 | Denver | CO | 80239·· | — | UNKNOWN |
| PRV | PRV-24036 | 2026-05-19T23:07:20Z | DORIS | — | SINGH | 09/25/50 | UHC-06680-50 | •••-••-3865 | +1 421 608 1762 | — | 7706 Sage Court | Las Vegas | NV | 89120 | — | - |
| PRV | PRV-24104 | 2026-09-16T21:28:58Z | Walter | — | Flores | 1966-11-05 | N/A | null | 4604772449 | UNKNOWN | 4809 Bayshore Drive | Austin | Texas | 78778 | NULL | N/A |
| PRV | PRV-21858 | 2026-07-12T18:52:12Z | Ramos, Betty | — | — | 19440117 | ·uhc-55325-32 | null | 882-660-6445 | — | 9450 Valley View Drive | Tucson | AZ | 85774 | — | SELECT-EPO |
| PRV | PRV-20790 | 2026-07-01T08:59:24Z | LINDA | T | WEAVER | 1945-04-12 | uhc-05696-37 | — | 5934093369 | N/A | 8132 GRAND AVE·· | Seattle | WA | 98145 | NULL·· | N/A |
| PRV | PRV-27341 | 2026-05-03T00:00:45Z | Alan·· | — | Mendez | 04/23/99 | null | N/A | ·270-510-0280 | alan.mendez4@hotmail.com | 9237 LINCOLN WAY | Las Vegas | NV | 89135 | — | ·UNKNOWN |
| PRV | PRV-26870 | 2026-09-17T05:08:12Z | KAREN | P. | HOFFMMAN | 1997-12-06 | — | N/A | 839-356-2660 | -·· | 7045 Mesa Dr | Las Vegas | NV | 89150 | — | - |
| PRV | PRV-20796 | 2026-06-19T19:57:58Z | Katherine | — | Hilll | 1979-09-20 | UHC-53855-27 | — | 751-694-7971 | UNKNOWN | 983 Spring St·· | Fresno | ca | 93731 | — | null |
| PRV | PRV-26223 | 2026-04-16T15:16:03Z | SCOTT | — | HANSEN | 1943-04-11·· | — | null | 9783314 | — | ·212 Meadow Lane | Minneapolis | MN | 55401-2251 | — | NAVIGATE-HMO |
| PRV | PRV-25114 | 2026-07-01T02:33:02Z | NANCY | ···· | BANKS | Mar 10, 1955 | UHC-78948-13 | NULL | 2483066386 | NANCY.BANKS@HOTMAIL.COM | 3184 Bayshore Dr | Chandler | Arizona | 85233 | null | — |
| PRV | PRV-25197 | 2026-09-29T01:07:00Z | ·BILLY | ·· | WEAVER | 06/25/75 | UHC-25544-03 | — | 751-794-6640·· | billy.weaver@yahoo.com·· | 2855 BAYSHORE DR | SCOTTSDALE | AZ | 85267 | — | ·select-epo |
| PRV | PRV-29584 | 2026-01-11T00:37:03Z | DOROTHY | — | ·MURRAY | 1977-09-16 | UHC-85837-03 | ·· | null | UNKNOWN | 3760 Union St | Miami | FL | 33195 | - | — |
| PRV | PRV-21084 | 2026-09-02T03:01:26Z | ·camila | — | walsh | 1956-04-22 | — | ···· | 8404672 | ·camila.walsh53@aol.com | 238 MARKET STREET | Miami | FL | 33187 | - | null |
| PRV | PRV-27368 | 2026-01-03T02:01:11Z | Aaron | — | Lopez | ·20030410 | UHC-79349-76 | — | 283-200-8018·· | - | 2613 Palm Drive | Fresno | ca | 93785 | — | - |
| PRV | PRV-21439 | 2026-05-06T22:52:13Z | Kimberly | — | ·Willis | 1954-04-24 | UHC-79191-29 | — | 12274340284 | - | N/A | null | - | NULL | N/A | ·MEDICARE-ADV-A |
| PRV | PRV-24332 | 2026-09-13T09:16:56Z | Eugene | — | Crawford | 9/21/1980 | — | — | (889) 495-1061 | — | 2129 INDIAN SCHOOL RD #429 | SCOTTSDALE | AZ | 85202 | — | CORE-HMO |
| PRV | PRV-22403 | 2026-10-09T20:49:47Z | Hudson, Sarah | V | — | 2008-11-07 | ·- | - | ·822-977-2895 | sarah.hudson88@gmail.com | 3760 WILLOW CT | Denver | CO | 80207 | — | null |
| PRV | PRV-24544 | 2026-07-20T21:05:47Z | PATRICK | A. | KELLY | 1994-03-12 | UHC-50584-30 | — | 554-683-0225 | UNKNOWN | UNKNOWN | — | NULL | — | UNKNOWN | - |
| PRV | PRV-21605 | 2026-05-08T00:55:53Z | SARA | Y | CARR | 2001-07-14 | UHC-62944-73 | NULL | 15049452051 | N/A | 1350 Market Street | SCOTTSDALE | AZ·· | 85238 | — | — |
| PRV | PRV-24596 | 2026-06-04T06:28:06Z | REBECCA | Y | RAMIREZ | 1951-02-24 | - | — | null | UNKNOWN | 9399 Grand Ave #848 | Dallas | TX | 75223 | — | NULL·· |
| PRV | PRV-27563 | 2026-07-05T22:29:55Z | Mei | — | Maldonado | 1945-11-02 | UHC-86595-66 | — | 4522021 | — | 7457 Park Place | Houston | TX | 77082 | N/A | — |
| PRV | PRV-23871 | 2026-05-30T06:00:26Z | Martha | B | ·Campbell | 1939-01-15 | UHC3028220 | NULL | 4762731071 | — | ·4725 Highland Ave | Plano | tx | 75075 | — | NULL |
| PRV | PRV-23307 | 2026-01-25T04:04:48Z | SARAH | ···· | OLSON | 2000-06-19 | N/A | - | N/A | NULL | 5496 River Road·· | Seattle | WA·· | 98181 | UNKNOWN | null |
| PRV | PRV-25127 | 2026-05-22T06:59:14Z | DOROTHY | U | DIAZ | 1979-02-20 | — | •••-••-7399 | — | NULL | 8960 WILLOW CT | AUSTIN | TX | 78767 | 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:36.683Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty