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-28503 | 2026-04-19T18:23:05Z | Hiroshi | O | Howell | 1963-09-13 | — | null | 6724067669 | hiroshi.howell@gmail.com | — | — | — | — | — | — |
| PRV | PRV-24231 | 2026-01-05T23:12:58Z | Aisha | — | Ryan | 03/11/2006 | UHC-58675-91 | — | 9812238695 | UNKNOWN | N/A | N/A | - | NULL | NULL | - |
| PRV | PRV-29320 | 2026-06-13T08:29:02Z | Chavez, Diana | — | ···· | 1980-02-02·· | UHC-06047-05·· | — | (611) 289-4481 | null | UNKNOWN | — | — | — | — | — |
| PRV | PRV-24815 | 2026-01-12T22:24:38Z | lias | — | mills | ·08/12/1942 | ·null | UNKNOWN | 684.609.7269 | lisa.mills@gmail.com | 4582 PINE DRIVE | Las Vegas | NV | 89107 | — | — |
| PRV | PRV-21233 | 2026-09-01T22:39:05Z | Emma | — | Jensen | 1953-11-01 | — | UNKNOWN | 595.340.7948 | N/A | NULL | NULL | — | - | — | - |
| PRV | PRV-23749 | 2026-08-23T07:14:31Z | JENNIFER | E | WATTSON | 2000-45-07 | — | — | 890-714-0389 | jennifer.watson@aol.com | ·9725 Harbor Boulevard | Tucson | AZ | 85783 | — | MEDICARE-ADV-A |
| PRV | PRV-22790 | 2026-02-07T09:38:35Z | Roy | — | Crawford | 1991-07-27 | — | — | N/A | — | 6673 OAK ST | Seattle | WA | 98175 | ·null | UNKNOWN |
| PRV | PRV-29105 | 2026-08-03T15:11:05Z | Karen | — | Holmes | 1997-05-28 | N/A·· | •••-••-3046 | 930-840-1468 | — | 7304 SAGE COURT | San Diego | ca | 92157 | N/A | UNKNOWN |
| PRV | PRV-25678 | 2026-06-13T22:16:23Z | SAMUEL | — | SALAZAR | ·1980-09-13 | null | null | UNKNOWN·· | N/A | 8284 HARBOR BLVD | Sacramento | CA | 95851 | null | N/A |
| PRV | PRV-27439 | 2026-08-20T12:31:24Z | Judith | — | Larson | 1990-08-18 | ·N/A | - | 15634462235 | — | 7789 Sunset Blvd | SAN DIEGO | CA | - | — | UNKNOWN |
| PRV | PRV-21911 | 2026-09-04T06:53:03Z | jesse | — | pierce | 19600211 | null | N/A | (443) 909-3185 | NULL | 8153 Broadway | Las Vegas·· | NV | 89190 | — | — |
| PRV | PRV-24618 | 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-25411 | 2026-02-24T12:05:59Z | Brue | — | ·Olson | 6/21/1938 | — | NULL | (486) 453-9108 | BRUCE.OLSON@ICLOUD.COM | — | null | N/A | — | N/A | OPTIONS-PPO·· |
| PRV | PRV-26111 | 2026-10-01T21:52:40Z | — | E | — | 2000-05-06 | UHC-64732-99 | — | 767-942-6234 | null | 7447 Central Avenue | Miami | FL | 33171 | N/A | UNKNOWN |
| PRV | PRV-25821 | 2026-02-16T08:41:44Z | ANGELA | — | ·WAGNER | 1942-12-13 | N/A·· | •••-••-9050 | 15744498171 | — | — | ·null | NULL | — | — | NAVIGATE-HMO |
| PRV | PRV-22317 | 2026-06-23T20:52:03Z | ·Roger | — | Stephens | ·1991-01-11 | UHC-94066-98 | — | 19248808854 | roger.stephens@outlook.com | — | - | - | - | — | null |
| PRV | PRV-24490 | 2026-07-12T05:02:40Z | ·diana | ···· | oliver | 10/2/2003 | UHC-09068-41 | UNKNOWN | 328.256.9089 | - | 4633 Hillcrest Road | Seattle | ·WA | 98134 | NULL | MEDICARE-ADV-A |
| PRV | PRV-21805 | 2026-10-16T19:24:43Z | Jean | A·· | Kelly | 2007-01-26 | N/A | - | N/A | N/A | 1655 Cedar Lane | CHANDLER | AZ | 85271 | NULL | - |
| PRV | PRV-20615 | 2026-07-04T00:48:01Z | Charlotte | — | Moore | 2002-02-05 | UNKNOWN | null | 835-765-6917 | UNKNOWN | 3631 Market St·· | Minneapolis | MN | 55475 | — | CORE-HMO |
| PRV | PRV-29466 | 2026-05-22T20:49:18Z | JEREMY | — | MURPHY | 10-01-1938 | UHC-74188-97 | — | — | - | 2694 Ocean Avenue | Miami | FL | 33148 | — | null |
| PRV | PRV-23293 | 2026-01-03T13:56:59Z | Virginia | T | Wright | 1950-01-25 | UNKNOWN | •••-••-1285 | - | - | 4695 Market St | Los Angeles | CA | 90035 | — | N/A |
| PRV | PRV-27454 | 2026-09-15T14:21:22Z | Hicks, Timothy·· | — | — | 03/13/97 | UHC-44481-21 | — | ·(766) 238-4445 | TIMOTHY.HICKS80@GMAIL.COM | - | null | - | ·- | null | — |
| PRV | PRV-28941 | 2026-05-02T14:49:48Z | Frances | — | Powell | 1968-11-17 | UHC-90782-54 | UNKNOWN | 644.288.7489 | null | 7489 Sunset Boulevard | FRESNO | CA | 93710-2600 | NULL | CORE-HMO |
| PRV | PRV-26782 | 2026-01-29T13:59:25Z | susan | X | webb | 19521006 | UHC-58050-50 | •••-••-0080 | ·428.928.5824 | N/A | 2347 Lincoln Way | ·Eden Prairie | Minnesota | 55390 | — | NAVIGATE-HMO·· |
| PRV | PRV-24210 | 2026-03-19T11:02:13Z | Larry | I. | Banks | Jan 4, 2006 | UHC-51013-04 | •••-••-2852 | (390) 487-4762 | — | 152 Lincoln Way | Atlanta | GA | 30367·· | - | null |
| PRV | PRV-21208 | 2026-04-15T07:54:38Z | Benjamin | — | Richardson | 1958-04-17 | null | N/A | (560) 644-6879 | - | 6480 Indian School Rd | Dallas | TX | 75277 | NULL | — |
| PRV | PRV-29516 | 2026-07-23T08:57:18Z | brittany | — | jackson | 01/05/1956 | UHC-56213-21 | •••-••-2212 | — | NULL | 2035 Oak Street | MESA | Arizona | 85281 | — | N/A |
| PRV | PRV-24043 | 2026-02-17T17:05:39Z | Maria | — | Yang | 2007-10-28 | N/A | •••-••-9743 | - | NULL·· | 5815 Hillcrest Rd | Los Angeles | CA | 90047 | UNKNOWN | OPTIONS-PPO |
| PRV | PRV-24492 | 2026-03-07T15:14:55Z | ·Aaron | — | Estrada | 1994-05-27 | UHC-74678-88 | N/A | — | NULL | 433 HILLCREST ROAD #854 | San Diego·· | CA | 92122 | NULL | - |
| PRV | PRV-22119 | 2026-09-16T16:14:50Z | Joice | — | Garrett | 2008-12-28 | UHC-90365-28 | — | — | N/A | 7709 Grand Avenue | Eden Prairie | MN | 55363-4629 | UNKNOWN | — |
| PRV | PRV-27542 | 2026-02-11T23:38:29Z | Andrea | S. | McDonald | 19640703 | UNKNOWN | ···· | - | andrea.mcdonald89@icloud.com | 323 MOUNTAIN VIEW DR #552 | COLUMBUS | ·OH | 43281 | — | SELECT-EPO |
| PRV | PRV-28680 | 2026-10-05T16:17:15Z | kenneth | ·· | cox | 1953-06-17 | UHC-45864-37 | — | — | - | 3484 Maple Ave | Glendale | Arizona | 85331 | — | — |
| PRV | PRV-26402 | 2026-01-17T07:33:30Z | Mariana | — | Auztin | 1967-10-15 | UHC-60247-95 | null | (787) 539-2929 | MARIANA.AUSTIN10@OUTLOOK.COM | ·5576 Oak Street | DENVER | Colorado | 80282 | — | MEDICARE-ADV-A |
| PRV | PRV-28064 | 2026-03-27T12:49:06Z | Bruce | — | Peteron | 1945-11-18 | UHC-86369-01 | - | (394) 736-1826 | bruce.peterson89@outlook.com·· | 6573 HARBOR BOULEVARD | Gilbert | AZ | 85294 | N/A | N/A |
| PRV | PRV-26596 | 2026-09-02T00:21:29Z | Jessica | — | Duncan | 2003-02-01 | — | — | 5967665166 | jessica.duncan99@gmail.com | 8245 Oak Street Apt 34 | Mesa | az·· | 85213 | ···· | OPTIONS-PPO |
| PRV | PRV-28705 | 2026-09-23T17:51:43Z | joseph | — | ·brooks | 1949-02-20 | UHC-78973-47 | — | 4986566407·· | N/A | 4944 Lake View Road | TAMPA | FL | 33658 | — | null·· |
| PRV | PRV-26671 | 2026-07-22T17:56:12Z | Lawrence | M | Gonzalez | 1989-09-19 | — | •••-••-7893 | (311) 408-6887·· | lawrence.gonzalez@gmail.com | 4187 Spring St | Phoenix | AZ | 85036 | NULL | — |
| PRV | PRV-22493 | 2026-03-20T03:43:39Z | Mateo C | — | Fuller | 19970709 | UHC-83792-60 | N/A | 494.543.4855 | — | 8580 Indian School Road | ·Tampa | FL | 33645 | ·null | N/A |
| PRV | PRV-24452 | 2026-01-06T04:25:22Z | Nicholas | — | Dean | 2003-01-24 | UHC-93616-96 | UNKNOWN | null | null | 8973 CENTRAL AVE | Miami | FL | 33123 | — | UNKNOWN·· |
| PRV | PRV-26352 | 2026-08-12T23:55:23Z | Marcus | — | Nichols | 2005-03-17 | NULL | N/A | +1 367 214 2096 | ·NULL | 7137 Sunset Blvd | Eden Prairie | MN | 55334 | - | null |
| PRV | PRV-27241 | 2026-09-09T00:50:53Z | Margaret | — | Ford | 2008-01-08 | UHC-83967-28 | ·null | 372-776-4500 | null | 7510 Washington Street | Miami | FL | 33131 | ·· | — |
| PRV | PRV-24385 | 2026-08-24T01:20:41Z | Hiroshi | H. | Parker | 1979-07-03 | UHC-03341-19 | - | 269-305-8733 | - | 8871 OCEAN AVENUE | Houston | TX | 77028 | UNKNOWN·· | MEDICARE-ADV-B |
| PRV | PRV-28912 | 2026-03-21T20:16:37Z | Morrison, Hannah | — | — | ·1983-07-12 | UHC5697948 | — | ·443-880-3052 | hannah.morrison@proton.me | 3111 Grand Ave | AUSTIN | Texas | 78728 | null | ·MEDICARE-ADV-A |
| PRV | PRV-21368 | 2026-08-10T15:01:50Z | STEPHEN | — | RUSSELL | 1971-10-09 | UHC-67042-21 | - | 19222453799 | N/A | ·6613 Jefferson Ave | Orlando | FL | 32877 | NULL | UNKNOWN |
| PRV | PRV-22522 | 2026-08-15T12:25:52Z | Ralph | — | Fernandez·· | 1991-09-20 | UHC-99815-83 | — | null | - | 8245 OCEAN AVE | Fresno | CA | 93769 | NULL | CORE-HMO |
| PRV | PRV-23493 | 2026-10-16T19:17:23Z | JULIA | C | WELLS | 1952-11-04 | UHC-90402-32 | NULL | 19414955159 | UNKNOWN | UNKNOWN | NULL | NULL | null | — | MEDICARE-ADV-A |
| PRV | PRV-21530 | 2026-05-01T13:58:42Z | Camila | — | Snyder | 1993-06-09 | ·UHC-17020-16 | - | 4196341764 | null | 3515 Willow Court | Miami | FL·· | 33192 | — | - |
| PRV | PRV-21431 | 2026-04-23T17:32:28Z | Kathryn | — | Turner | 22-02-1952 | UHC-15096-04 | — | ·15217913689 | ···· | — | — | — | — | — | N/A |
| PRV | PRV-20418 | 2026-03-05T07:17:42Z | SARA | W. | GOMMEZ | 2002-04-12 | UHC-60271-38 | •••-••-6078 | 6536545230 | — | 5624 ELM STREET | Columbus | OH | 43298 | — | N/A |
| PRV | PRV-22312 | 2026-10-06T04:59:25Z | Denise Q | ···· | Lane | 1943-08-91 | - | — | 3863616140 | NULL | 8532 Sage Ct | Houston | TX | 77041 | 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.707Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty