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-28760 | 2026-04-22T20:03:31Z | ·Charlotte | — | Ramos | 1969-05-05 | N/A | — | (871) 472-7455 | — | 3625 Ocean Ave | Denver | CO | 80249 | NULL | N/A |
| PRV | PRV-29289 | 2026-08-08T14:05:37Z | Graham, Matthew | ·· | — | 1962-06-15 | -·· | •••-••-0477 | (953) 971-0478 | — | 5330 Union St | Nashville | TN | 37248 | UNKNOWN | OPTIONS-PPO·· |
| PRV | PRV-28515 | 2026-01-01T08:19:51Z | BARBARA | — | HAYES | 3/26/1951 | — | N/A | 976.635.8924 | N/A | 590 Meadow Lane | Fresno | CA | 93737 | ·UNKNOWN | NAVIGATE-HMO |
| PRV | PRV-29534 | 2026-02-12T23:55:15Z | JORDAN | — | RIVERA·· | 16-02-1972·· | UHC4280973 | — | 211-898-0110 | N/A | 9207 PARK PLACE | FRESNO | CA | 93752 | null | UNKNOWN |
| PRV | PRV-22301 | 2026-03-10T11:50:22Z | Gloria | — | Black | 1994-12-14 | UHC-21146-15 | null | (794) 804-5970 | gloria.black16@hotmail.com | 509 Camelback Rd | Fresno | CA | 93715 | — | NAVIGATE-HMO |
| PRV | PRV-27429 | 2026-01-22T10:19:14Z | Andraa | — | Sanders | 25-07-1942 | UNKNOWN | •••-••-6323 | 6954847 | — | 1519 Harbor Boulevard | HOUSTON | TX | 77051 | - | CORE-HMO |
| PRV | PRV-26623 | 2026-04-03T22:31:56Z | frank | — | fernandez | 1960-04-04 | UHC-46561-13·· | UNKNOWN | 874-300-6582 | UNKNOWN | 6763 Mesa Drive | Glendale | AZ | 85323 | N/A | CORE-HMO |
| PRV | PRV-21699 | 2026-10-04T00:15:21Z | Jacob·· | — | Sullivan | May 24, 2008 | UNKNOWN | •••-••-0054 | 7661580 | NULL | 1349 OCEAN AVE | SCOTTSDALE | AZ | ·85292 | NULL | ·- |
| PRV | PRV-22130 | 2026-07-10T08:47:24Z | Brenda | — | Rose | Aug 4, 1958 | - | NULL | (714) 731-4899 | - | 6353 APACHE BLVD | Miami | FL | N/A | null | OPTIONS-PPO |
| PRV | PRV-21628 | 2026-03-17T14:25:37Z | Madison | E | Simmons | 1970-06-11 | ···· | NULL | (611) 380-2927·· | madison.simmons33@hotmail.com | null | NULL | N/A | — | ···· | CHOICE-PLUS-PPO |
| PRV | PRV-20818 | 2026-03-26T09:04:31Z | Cook, Catherine | — | — | 19900620 | UHC-04400-74 | UNKNOWN | 679.324.6419 | CATHERINE.COOK44@PROTON.ME | 9282 Church St | Atlanta | GA | ·30369 | - | UNKNOWN |
| PRV | PRV-21537 | 2026-09-20T00:56:33Z | VALENTINA | — | MONTGOMERY | 1983-04-19 | UHC-94649-40 | — | 9148129556·· | - | 9150 Forest Avenue | Nashville | Tennessee·· | 37238 | null | null |
| PRV | PRV-20874 | 2026-05-17T13:28:37Z | Anndrea | — | Fuller | 2005-03-01 | UHC-87746-30 | N/A | 317.741.1713 | — | NULL | null | — | UNKNOWN | NULL | SELECT-EPO |
| PRV | PRV-28008 | 2026-06-28T13:57:10Z | Ronald | R. | Hicks·· | 2/20/1976 | NULL | NULL | 346-345-5568 | — | 8513 Union Street | Tampa | FL | 33671 | - | NULL |
| PRV | PRV-21479 | 2026-10-16T13:22:21Z | Marilyn | W | Romero | 08/02/54 | - | null | 5559000569 | ·N/A | 2973 MAIN ST | Eden Prairie | MN | 55338 | N/A | UNKNOWN |
| PRV | PRV-23395 | 2026-01-25T20:56:26Z | Carl | C | Watson | 1947-06-09 | UHC4611422 | NULL | N/A | — | 4297 Palm Drive | MIAMI | FL | 33100 | — | null |
| PRV | PRV-21563 | 2026-08-28T21:59:56Z | virginia | — | smith | 07/22/01 | — | N/A | (890) 230-0951 | virginia.smith@outlook.com | 9017 Palm Dr | Atlanta | GA | 30382 | — | — |
| PRV | PRV-28332 | 2026-08-17T14:36:37Z | Aaron | — | Gonzalez | 1962-11-03 | NULL | — | 253.891.2028 | UNKNOWN·· | 9680 Mountain View Drive Apt 38 | ·SEATTLE | WA | 98103 | N/A | - |
| PRV | PRV-20779 | 2026-10-16T04:44:02Z | Robert | I | Hicks | 1987-12-14 | UHC-88936-39 | — | 752-502-4330 | robert.hicks@proton.me | 9867 Park Pl | Houston | ·TX | — | — | N/A |
| PRV | PRV-22037 | 2026-03-07T08:56:05Z | Ralph | — | Taylor | 1985-07-21 | UHC-07187-68 | UNKNOWN | 4064124·· | ralph.taylor@gmail.com | — | — | — | - | - | NULL |
| PRV | PRV-28187 | 2026-10-06T07:00:39Z | KEVIN | — | FERNANDEZ | 07-05-1971 | N/A | — | 8087522104 | — | 1111 River Rd | TEMPE | AZ | 85222 | NULL | - |
| PRV | PRV-25027 | 2026-06-04T11:20:29Z | Smith, Jacob | J | — | 1974-05-08 | — | NULL | 205-924-2625 | JACOB.SMITH@HOTMAIL.COM | 4760 CANYON ROAD | Atlanta | GA | 30361 | N/A | UNKNOWN |
| PRV | PRV-25032 | 2026-03-13T23:00:03Z | JUDITH | B | CUNNINGHAM | 1999-05-20 | — | — | 810-709-4477 | JUDITH.CUNNINGHAM@ICLOUD.COM | 2252 MESA DRIVE | Minneapolis | MN | — | N/A | N/A |
| PRV | PRV-23144 | 2026-07-12T07:34:05Z | DOROTHY | — | ELLIOTT | 1963-04-10 | — | — | 6238675387 | null | 6036 Highland Ave | Plano | TX·· | 75048 | — | UNKNOWN |
| PRV | PRV-27822 | 2026-03-10T19:29:54Z | KIMBERLY·· | — | BANKS | 1973-08-14 | UHC-47323-56 | - | 2288029057 | N/A | 1608 PINE DR | Miami | FL | 33145 | — | null |
| PRV | PRV-22062 | 2026-07-09T01:12:55Z | Ruth | ·· | Weaver | 1986-01-08 | UHC-27012-03 | — | (314) 864-4818 | ·- | 7988 Mesa Drive | San Antonio | ·TX | 78217 | — | NULL |
| PRV | PRV-28406 | 2026-10-12T06:59:51Z | Natalie | — | Palmer | 1959-12-10 | UHC-45579-15 | — | (873) 266-9924 | — | NULL | null | - | - | N/A | — |
| PRV | PRV-28200 | 2026-05-18T14:41:18Z | Lauren | — | Howard | 04/18/05 | UHC-54097-94 | — | 782-435-3526 | — | 9045 Harbor Blvd | Minneapolis | mn | 55437 | UNKNOWN | ·null |
| PRV | PRV-25215 | 2026-02-01T05:09:52Z | JASON X | — | GARRETT | 1978-04-08 | — | NULL | (657) 403-6234·· | — | ·5500 Canyon Road | Fresno | CA | 93799 | UNKNOWN | — |
| PRV | PRV-24425 | 2026-02-24T03:02:08Z | denise | J. | richardson | 2002-10-07·· | UNKNOWN | UNKNOWN | 5933811522 | — | 6090 Spring St | Chandler | AZ | 85253 | — | — |
| PRV | PRV-27393 | 2026-06-09T05:38:41Z | Noah | — | Campbell | 06/22/1956 | UNKNOWN | - | (416) 564-6647·· | noah.campbell21@yahoo.com | 3116 Canyon Rd·· | Seattle | WA | 98127 | — | N/A |
| PRV | PRV-29420 | 2026-02-16T20:45:00Z | CATHERINE | ·· | ROMERO | ·19520209 | UHC-95527-11 | — | ·19445379019 | — | 9615 CAMELBACK RD | Tempe | AZ | 85263 | N/A | null |
| PRV | PRV-25984 | 2026-06-14T12:58:25Z | Maria | ···· | Gonzales | 1966-05-05 | UHC-94421-13 | •••-••-0947 | 981-590-2792·· | UNKNOWN | 8457 Cedar Lane #938 | TEMPE | AZ | 85287 | — | NAVIGATE-HMO |
| PRV | PRV-24617 | 2026-05-26T07:38:39Z | beverly·· | — | hunter | 11/15/1996 | UHC-61579-57·· | null | NULL | ·BEVERLY.HUNTER48@YAHOO.COM | 121 DESERT SKY BLVD | Plano | TX | 75041 | — | OPTIONS-PPO |
| PRV | PRV-21111 | 2026-08-07T19:39:55Z | KENNETH | — | TUCKER | 04/12/1947 | N/A | ···· | ·238-429-7613 | ···· | 1345 Meadow Ln | Gilbert | AZ | 85250 | — | - |
| PRV | PRV-29385 | 2026-06-03T23:33:35Z | Jacob | — | ·Garcia | 19880220 | — | - | — | — | 4780 Meadow Ln | Seattle | WA | 98126 | UNKNOWN | null |
| PRV | PRV-27427 | 2026-01-26T04:05:28Z | douglas | M. | ford | 1943-10-27 | UHC-73862-03 | — | (955) 672-2086 | — | — | — | N/A | null | — | ·null |
| PRV | PRV-26452 | 2026-05-10T13:43:00Z | BETTY | ·· | MORALES | 5/13/1968·· | UHC-75997-35·· | •••-••-7652 | 427.855.8517 | betty.morales79@outlook.com | 532 Palm Dr | SACRAMENTO | CA | 95834 | — | — |
| PRV | PRV-26123 | 2026-06-30T14:57:07Z | KATHLEEN | — | CASTILLO·· | 1998-11-21 | ·uhc-90571-84 | — | 412-238-1597 | null | 3704 SAGE COURT | Dallas | TX | 75249 | ·- | — |
| PRV | PRV-29410 | 2026-03-15T16:03:22Z | JORDAN | — | THOMAS | 1948-03-05 | UHC-00688-86 | N/A | 8933660562 | — | 5317 Jefferson Ave·· | Sacramento | CA | 95895 | NULL | N/A·· |
| PRV | PRV-20304 | 2026-03-17T20:01:48Z | BRANDON | — | DUNCAN | 09/27/40·· | UHC1376068 | N/A | 748-656-4965 | NULL | 5044 Market St | Scottsdale | AZ | 85242 | — | - |
| PRV | PRV-24726 | 2026-02-19T06:57:25Z | RONALD | — | LEE | 1941-06-28·· | — | — | — | — | 7618 Desert Sky Boulevard | Seattle | Washington | — | — | N/A |
| PRV | PRV-27797 | 2026-02-23T15:17:23Z | EVELYN | P | PALMER·· | 1997-04-03 | - | •••-••-9988 | (609) 239-0924 | evelyn.palmer@aol.com | 8011 Church St | TUCSON | az | 85758 | null | UNKNOWN |
| PRV | PRV-23255 | 2026-09-30T13:13:27Z | Thomas, Omar | — | — | 1983-02-04 | — | UNKNOWN | null | OMAR.THOMAS39@HOTMAIL.COM | 3899 Union St Apt 32 | EDEN PRAIRIE | Minnesota | 55354 | UNKNOWN | — |
| PRV | PRV-27166 | 2026-05-08T18:11:52Z | Bobby | — | Schultz | 1938-12-12 | ·· | — | (633) 412-7789 | — | 4444 Broadway | Phoenix | AZ | 85037 | — | -·· |
| PRV | PRV-25783 | 2026-01-10T15:22:04Z | mary | — | jensen | 1989-11-16 | UHC-25665-35 | •••-••-5667 | 3715413737 | UNKNOWN | 4180 Spring St | Las Vegas | NV | 89100 | NULL·· | null·· |
| PRV | PRV-26902 | 2026-08-28T21:04:51Z | GRACE | B. | DAVIS | 1944-10-19 | UHC-06537-09 | — | ·+1 533 972 0897 | grace.davis8@proton.me | ·7504 RIDGE ROAD | AUSTIN | tx | 78794 | NULL | — |
| PRV | PRV-27392 | 2026-08-09T12:03:08Z | Sofia | — | Ortiz | ·1995-11-04 | UHC-16134-88 | — | 9816570 | SOFIA.ORTIZ37@AOL.COM·· | 3988 Lincoln Way | Jacksonville | Florida | 32242 | — | UNKNOWN |
| PRV | PRV-24049 | 2026-05-05T07:14:10Z | MARILYN | — | FRANKLIN | 01/13/1965 | UNKNOWN | •••-••-3474 | (975) 671-4135 | UNKNOWN | 3405 MAIN STREET | Phoenix | az | 85044 | — | - |
| PRV | PRV-20690 | 2026-05-27T06:15:12Z | ANN | — | ALEXANDER | 19890168 | N/A | N/A | N/A | null | 8659 Ocean Avenue | Columbus | Ohio | 43267 | - | 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:52.221Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty