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-21196 | 2026-04-19T03:20:24Z | Arjun | ·· | Stephens | 1978-12-06·· | - | ·N/A | 399-944-1594 | UNKNOWN | 7955 MESA DRIVE | AUSTIN | TX | 78710 | N/A | null |
| PRV | PRV-28355 | 2026-05-19T06:01:59Z | Janet | R | Ramos | 1989-02-07 | — | - | 308-379-8189 | UNKNOWN | 736 PALM DR·· | FRESNO | CA | 93773 | -·· | — |
| PRV | PRV-24644 | 2026-08-15T13:27:39Z | JOE | — | JENSEN | 1986-02-13 | UHC-10382-91 | N/A | 273.492.0821 | UNKNOWN | 3667 Camelback Road | Phoenix | AZ | 85057 | NULL | — |
| PRV | PRV-29361 | 2026-04-08T02:02:49Z | FREEMAN | — | ALBERT | 04/04/1997 | — | ·· | 980.721.8047 | — | 4258 Palm Dr | Chandler | Arizona | 85267 | — | ·· |
| PRV | PRV-21254 | 2026-04-06T07:27:39Z | ·arthur | K | meyer | 1985-07-06·· | UHC-06599-74 | — | 480-678-6816 | ARTHUR.MEYER4@GMAIL.COM | 1047 Mountain View Dr | Houston | TX | 77050 | - | - |
| PRV | PRV-21738 | 2026-10-02T13:16:07Z | LAWRENCE | — | JIMENEZ | 2008-09-25 | - | - | 929-321-8124 | null | ·8191 Valley View Drive | San Antonio | TX | 78280 | — | MEDICARE-ADV-B |
| PRV | PRV-23033 | 2026-09-25T11:07:11Z | Kayla | — | Bailey | — | NULL | — | (641) 974-0117 | KAYLA.BAILEY@ICLOUD.COM | 5758 Pine Dr | Columbus·· | ·Ohio | 43256·· | null | — |
| PRV | PRV-26479 | 2026-01-03T03:32:08Z | christine | W | singh | 1970-02-03 | - | null | 2526413605 | CHRISTINE.SINGH@GMAIL.COM | 835 Main St | Tempe·· | AZ | 85255 | NULL | — |
| PRV | PRV-26984 | 2026-08-19T07:40:50Z | MEI | — | WARREN | Apr 28, 1993 | ·null | — | (910) 942-6521 | - | 2861 Lincoln Way | San Diego | CA | 92197 | — | — |
| PRV | PRV-29163 | 2026-05-28T23:54:26Z | Jacob | C | Guerrero | 09/21/1973 | NULL | UNKNOWN | (816) 962-2844 | jacob.guerrero@aol.com | 2682 Sunset Boulevard | Columbus | ·OH | 43283 | UNKNOWN | UNKNOWN |
| PRV | PRV-27514 | 2026-10-08T20:41:45Z | Joe | — | Howell | 1964-08-20 | UNKNOWN | N/A | 919-601-7328·· | — | 690 River Road | Plano | TX | 75041 | null | — |
| PRV | PRV-20889 | 2026-01-20T14:49:39Z | Andrea | — | Jimenez | 1972-03-10 | UNKNOWN | — | +1 523 511 3994·· | null | 6052 Jefferson Avenue | Seattle | WA | 98131 | — | MEDICARE-ADV-B |
| PRV | PRV-29555 | 2026-02-19T01:57:59Z | Thomas | — | Harper | 03-08-1974 | UHC-43283-39 | - | N/A | THOMAS.HARPER@ICLOUD.COM | 973 MARKET ST | Tucson | AZ | 85766 | null | UNKNOWN |
| PRV | PRV-25638 | 2026-09-25T14:42:04Z | CAORL | B | GIBSON | 1941-01-10 | UHC-92939-34 | UNKNOWN | 346-522-2203 | CAROL.GIBSON35@OUTLOOK.COM | 6007 Oak St | Tempe | AZ | 85235 | UNKNOWN | UNKNOWN |
| PRV | PRV-22281 | 2026-09-19T08:30:56Z | MARY | M·· | WAVER | 06/07/81 | — | — | 2983848412 | mary.weaver44@outlook.com | 5061 Maple Ave | San Antonio | tx | 78281-2995 | N/A | N/A |
| PRV | PRV-23690 | 2026-08-09T13:21:21Z | Christina | — | Larson | 19550709 | UHC-90485-90 | UNKNOWN | (448) 967-1935 | CHRISTINA.LARSON80@AOL.COM | 2725 Mountain View Drive | Tampa | FL | 33668 | N/A | MEDICARE-ADV-B |
| PRV | PRV-24063 | 2026-09-06T04:42:38Z | CAMILA | — | BURTON | 01/14/03 | — | UNKNOWN | — | camila.burton45@aol.com | ·6355 MESA DRIVE | Seattle | WA | 98185 | N/A·· | NULL |
| PRV | PRV-23697 | 2026-01-15T13:29:53Z | Diana | — | Brown | 1961-08-05·· | UHC-44223-69·· | — | 641-775-8041 | N/A | 4932 Oak Street | Miami | FL | 33133 | UNKNOWN | — |
| PRV | PRV-20822 | 2026-08-03T14:09:08Z | BEVERLY | — | TAYLOR | 12-03-1996 | ·UHC-10404-50 | •••-••-3450 | (484) 248-7245 | — | 8531 Canyon Rd | Mesa | az | 85240 | null | null |
| PRV | PRV-27133 | 2026-01-11T06:41:46Z | Micahel | — | Porter | 9/12/2003 | UHC-50791-32 | — | 4312582237 | null | 5538 ELM STREET | Houston | Texas | 77079 | — | N/A |
| PRV | PRV-25034 | 2026-08-23T00:37:23Z | Kenneth | — | ·Henry | 2001-05-17 | — | •••-••-3303 | 5245542623 | UNKNOWN | 4427 Forest Avenue | Dallas | TX | 75208 | UNKNOWN | ·· |
| PRV | PRV-26718 | 2026-02-20T03:38:47Z | Castillo, Ahmed | — | — | 1996-09-28 | UHC-03994-93 | •••-••-2887 | ·9295262376 | UNKNOWN | 5587 Meadow Lane | Sacramento·· | CA | 95807 | — | null |
| PRV | PRV-24435 | 2026-09-29T18:46:55Z | TERESA | V | HARRISON | 2007-01-27 | UHC-56572-05 | •••-••-5904 | 9753049752 | TERESA.HARRISON@PROTON.ME | 1781 HARBOR BOULEVARD | San Antonio | TX | 78294 | UNKNOWN | NAVIGATE-HMO |
| PRV | PRV-25790 | 2026-09-10T16:44:05Z | JUSTIN | — | MURPHY | 1952-10-21 | UHC5272374 | N/A·· | 374-757-6957 | — | 3207 Union Street | TUCSON | AZ·· | 85764 | null | — |
| PRV | PRV-22238 | 2026-03-13T20:20:10Z | Dean | G | Stephanye | 1984-06-23 | UHC9808512·· | NULL | ·9336402626 | — | 6137 Lake View Road | Jacksonville | FL | — | ·· | OPTIONS-PPO |
| PRV | PRV-28246 | 2026-06-23T05:53:01Z | Megan | Z. | Marquaz | 06/14/90 | UHC-86538-02 | NULL | 7964673988 | N/A | 4790 Washington St | Mesa | AZ | 85238-2217 | — | N/A |
| PRV | PRV-24139 | 2026-06-15T08:18:39Z | CHRIS·· | ···· | GREEN | 1954-06-08 | — | — | 9306245467 | christine.green@gmail.com | 2440 Market St | Los Angeles | California | 90072-9522 | UNKNOWN | null |
| PRV | PRV-28204 | 2026-09-19T08:22:36Z | mateo | ···· | miller | 2000-08-15 | UHC-99133-72 | - | (771) 858-2429 | N/A | 1423 Spring Street Apt 40 | Nashville | TN | 37299 | null | UNKNOWN |
| PRV | PRV-29149 | 2026-08-24T16:41:52Z | Loogan | G. | — | 12/10/06 | UHC-62238-01 | - | +1 529 527 5418 | N/A | 7132 Main Street | ATLANTA | GA | 30364 | - | SELECT-EPO |
| PRV | PRV-26707 | 2026-01-07T00:32:53Z | Valentina | — | ·Coleman | 1965-02-18 | — | — | (262) 901-6360 | ···· | 4830 Palm Dr | Eden Prairie | Minnesota | 55377 | UNKNOWN | NULL |
| PRV | PRV-27857 | 2026-03-15T08:21:38Z | ·Julie | ·· | Hunter | 12-07-1961 | null | NULL·· | NULL·· | — | 5231 HARBOR BLVD·· | MIAMI | FL | 33196 | NULL | NULL |
| PRV | PRV-22786 | 2026-05-04T17:40:35Z | KEVIN | W. | STEWART | 17-06-1974 | UHC-27292-56 | •••-••-6009 | ·8483260593 | kevin.stewart54@icloud.com | 5356 Washington Street | Phoenix | az | 85065 | — | — |
| PRV | PRV-20972 | 2026-01-02T04:35:31Z | ELIJAH | Y | MURRAY | 1998-08-01 | UNKNOWN | UNKNOWN | 291-365-3384 | — | 5442 Desert Sky Blvd | Denver | CO | 80244 | — | CORE-HMO |
| PRV | PRV-24575 | 2026-08-07T08:23:15Z | Alexander | — | Barnes | 1958-02-19 | ·· | — | 6844514517 | null | 5295 Main Street | Charlotte | NC | 28236 | ···· | ·· |
| PRV | PRV-23593 | 2026-04-26T19:59:50Z | Steven | G. | Simmons | 4/13/1956 | UHC-50809-84 | NULL | 729-381-0193 | NULL | 763 Valley View Dr | Tempe | az | 85292 | NULL | — |
| PRV | PRV-28029 | 2026-05-15T16:15:12Z | MARI | ·P | BRYANT | 1966-11-22 | UHC-26238-20 | N/A | (433) 803-0541 | NULL | 756 CEDAR LN | Scottsdale | AZ | 85241 | null | N/A |
| PRV | PRV-23298 | 2026-09-20T04:51:49Z | TERRY | — | ARNOLD | 02/27/52 | - | •••-••-5838 | - | TERRY.ARNOLD84@HOTMAIL.COM | 5298 Elm Street | SACRAMENTO | CA | ·95877 | — | null |
| PRV | PRV-28139 | 2026-10-02T00:44:16Z | Billy | — | ·Romero | 1992-09-22 | UHC5131112 | UNKNOWN | UNKNOWN | NULL | 6253 Church St | MESA | AZ | 85294 | N/A | — |
| PRV | PRV-29154 | 2026-10-01T07:10:43Z | Edward | K. | Burton | 20-10-2004 | — | ···· | 833-908-9193 | edward.burton86@proton.me | 1763 Palm Drive·· | Mesa | Arizona | 85244-8618 | — | — |
| PRV | PRV-23006 | 2026-01-29T02:35:54Z | lucia | Q. | owens | 1974-12-12 | UHC-52968-42 | NULL | +1 967 289 9100 | ·UNKNOWN | N/A | null | NULL | — | ·null | UNKNOWN |
| PRV | PRV-22410 | 2026-08-30T02:33:57Z | Doris·· | — | Cunnigham | 1949-03-07 | UHC-12346-13 | •••-••-0907 | 335-943-8706 | N/A | 6648 PALM DR | Chandler | AZ | 85284 | — | — |
| PRV | PRV-23182 | 2026-06-15T14:39:13Z | Timothy | ·· | Wang·· | 1971-12-13 | N/A | — | NULL | TIMOTHY.WANG52@OUTLOOK.COM | — | null | NULL | null | UNKNOWN | — |
| PRV | PRV-25504 | 2026-03-27T05:44:45Z | ·Thompson, Ashley | — | — | 19991122 | UHC-62776-77 | - | (407) 843-5113 | ASHLEY.THOMPSON@ICLOUD.COM | 8765 Central Ave | Eden Prairie | MN | NULL | UNKNOWN | null |
| PRV | PRV-25375 | 2026-06-25T14:26:22Z | ·Shirley | — | Le | Mar 28, 2002 | UHC-24005-09 | NULL | (914) 807-7555 | shirley.le@proton.me | 7260 Market St·· | MESA | AZ | 85220 | — | NAVIGATE-HMO |
| PRV | PRV-20313 | 2026-07-21T15:07:03Z | KENNETH | I | WOG | 1994-06-21 | - | — | 596-398-1491 | — | 6751 CENTRAL AVENUE | ·Chandler | ·AZ | 85250 | N/A | - |
| PRV | PRV-28199 | 2026-01-10T14:51:57Z | Kevin | — | Guerrero | 1956-03-32 | UHC-55296-65 | — | 379-589-1436 | kevin.guerrero66@icloud.com | 4927 River Road | Fresno | CA | — | — | — |
| PRV | PRV-26880 | 2026-03-01T12:08:36Z | WILLIE | — | HILL | 02/17/1954 | ·UNKNOWN | NULL | ···· | UNKNOWN·· | 6950 Camelback Rd | ·Gilbert | AZ | 85250 | N/A | NAVIGATE-HMO |
| PRV | PRV-24672 | 2026-10-04T22:32:51Z | camila | Y | dunn | 2007-12-05 | null | — | 430-754-1468 | N/A | 3918 Palm Dr | Minneapolis | MN | 55448·· | - | N/A·· |
| PRV | PRV-21487 | 2026-01-12T13:02:31Z | Carl | — | Davis | 1987-07-12 | UHC-93283-17 | null | (509) 881-0468 | null | 4425 Union Street | Scottsdale | AZ·· | 85254 | UNKNOWN | — |
| PRV | PRV-28301 | 2026-06-24T18:48:33Z | Brittany | — | Moore | 1952-10-22 | UNKNOWN | N/A | 677.265.0694 | NULL | 2008 Park Pl | Atlanta | ·GA | 30323 | — | — |
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.726Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty