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-26116 | 2026-04-16T23:51:01Z | Amanda | H | West | 1947-03-04 | UHC-50165-58 | N/A | 868-915-5554 | ·null | 2156 Apache Blvd | Las Vegas | NV | 89197 | — | N/A |
| PRV | PRV-22503 | 2026-03-12T05:00:48Z | BRANDON | V. | ROSE | 1970-04-09 | ·· | •••-••-6925 | 948-983-5891 | N/A | 202 Ridge Road | Seattle | WA | 98103·· | — | — |
| PRV | PRV-23934 | 2026-07-30T12:09:17Z | Gray, Luis | ···· | — | 20071112 | - | ·N/A | (255) 908-6145 | — | 8034 Park Place | FRESNO | CA | 93719 | — | NULL |
| PRV | PRV-25535 | 2026-10-10T08:05:43Z | Gary | — | Brown | 24-01-1950 | — | ·- | +1 458 847 6731 | — | 5247 Jefferson Avenue·· | Tucson | AZ | N/A | NULL | — |
| PRV | PRV-22780 | 2026-06-20T23:01:48Z | DAVID | — | MARTIN | 09/12/07 | — | — | 13228769904 | ·NULL | 5526 Ridge Road #580 | Denver | CO | 80209 | — | — |
| PRV | PRV-26360 | 2026-06-14T09:07:54Z | Helen | — | Williams | 06/22/96 | null | •••-••-5402 | 7898098614 | - | 6789 Canyon Road | Houston·· | Texas | 77046 | N/A | ·NULL |
| PRV | PRV-27366 | 2026-04-07T14:11:19Z | Kelley, Sara | — | — | 26-12-1984 | UHC1941197 | NULL | ·(266) 665-1923 | ···· | 1137 Meadow Lane | Glendale | AZ | 85353-1788 | N/A | — |
| PRV | PRV-26333 | 2026-02-27T03:05:29Z | Marcus | — | Howell | Jan 1, 1997 | UHC9499660 | — | ·(841) 991-5857 | N/A | 337 Mesa Dr | SAN ANTONIO | TX | 78216-1121 | ···· | N/A |
| PRV | PRV-28718 | 2026-03-19T02:52:12Z | Eveyln | — | Smith | 1939-01-01 | ·· | •••-••-4451 | 672-702-0342 | — | 7492 Ridge Road Apt 9 | Fresno | CA | NULL | UNKNOWN | — |
| PRV | PRV-27218 | 2026-09-25T22:01:57Z | Tyler | V | Fields | 1989-07-21 | UHC-95562-84 | N/A | — | — | 1101 JEFFERSON AVENUE | Houston | TX | 77066 | — | - |
| PRV | PRV-26120 | 2026-10-06T13:14:05Z | MARY | G | NUNEZ | 6/23/1967 | UHC-30029-90 | •••-••-9705 | 407.808.2756 | - | 326 WILLOW COURT | HOUSTON | TX | 77049 | — | — |
| PRV | PRV-26079 | 2026-01-21T03:26:45Z | Terry | — | Ford | 10/01/94·· | - | — | 702.723.5915 | N/A | — | — | — | UNKNOWN | null | null |
| PRV | PRV-23850 | 2026-05-22T13:28:11Z | Katherine | — | Gomez | Jul 28, 2008 | — | NULL | 17553635923 | — | 2883 Hillcrest Rd | ·Jacksonville | FL | 32213 | — | N/A |
| PRV | PRV-29450 | 2026-07-17T15:34:58Z | ARJN | — | KENNEDY | 04/24/55·· | UHC4659412 | •••-••-7545 | 5762675777·· | arjun.kennedy88@hotmail.com | null | — | ·- | UNKNOWN | NULL | NULL |
| PRV | PRV-24608 | 2026-03-03T22:47:57Z | Frank | N. | Bishop | Sep 21, 1987 | UHC-33994-11 | •••-••-9873 | (308) 663-6932 | frank.bishop@gmail.com | 5597 Willow Court | Las Vegas | NV | 89124 | N/A | — |
| PRV | PRV-22800 | 2026-03-26T04:05:29Z | Alert | P | Hayes | 07/03/1944 | — | ···· | 719.543.1617 | N/A | 7339 Hillcrest Road | Plano | TX | 75091 | null | — |
| PRV | PRV-21677 | 2026-05-16T22:29:10Z | Hanson | — | Diego | 03-08-2000 | UNKNOWN | N/A | (489) 309-1213·· | ·· | 3400 Broadway #333 | Mesa | AZ | 85275 | — | null |
| PRV | PRV-28613 | 2026-05-23T17:35:31Z | Ortega, Beverly | — | — | 19500716 | UHC-09931-26 | — | 5759757794 | ···· | 830 BAYSHORE DR | Dallas | TX | 75209 | - | null |
| PRV | PRV-22747 | 2026-06-26T06:59:29Z | Morris, Sophia | — | — | 22-02-2002 | - | — | 774.456.8719 | — | 1447 Broadway #331 | Jacksonville | Florida | 32233-8884 | — | — |
| PRV | PRV-24323 | 2026-04-07T12:09:19Z | Emma | K | Brooks | 1972-05-01 | UHC0956295 | UNKNOWN | 203.975.7599 | — | 453 Canyon Rd | Sacramento | CA | — | N/A | null |
| PRV | PRV-20004 | 2026-07-04T05:48:56Z | james | K | hunter | 1960-03-14 | UHC6851905 | — | +1 974 635 7738 | james.hunter@icloud.com | 6535 Bayshore Drive | Orlando | FL·· | — | — | NULL |
| PRV | PRV-23993 | 2026-04-18T01:41:40Z | HENRY | — | DEAN | 19700910 | UNKNOWN | - | 677-881-4211 | null | 2175 Jefferson Avenue | Glendale | AZ | 85347 | null | — |
| PRV | PRV-21353 | 2026-06-09T16:28:44Z | KATHLEEN | O | OBREN | 1988-02-05 | - | — | (436) 634-4511 | ·· | 9351 Elm Street | Los Angeles | ·CA | 90075-5710 | - | NULL |
| PRV | PRV-26994 | 2026-07-07T19:06:05Z | Alice | — | ·Foster | 1950-02-06 | — | •••-••-6184 | - | UNKNOWN·· | 6836 Maple Avenue | Orlando·· | FL·· | 32801 | UNKNOWN | UNKNOWN |
| PRV | PRV-26612 | 2026-09-01T03:14:22Z | Kyle | Q | ·Castillo | 1959-12-21 | — | •••-••-0014 | (640) 602-2389·· | null | 4313 Grand Ave | Tempe | ·AZ | 85299 | null | N/A |
| PRV | PRV-27934 | 2026-09-01T23:44:31Z | JON | — | WEBER·· | Mar 17, 1998 | N/A | — | 8673342688 | N/A | 4212 MAPLE AVE·· | GILBERT | AZ | 85239-3253 | — | N/A·· |
| PRV | PRV-24107 | 2026-05-01T10:24:50Z | Jesse | M | Sandoval | 10/14/62 | UHC-22226-32 | UNKNOWN·· | 876-267-4493 | — | 2084 Jefferson Ave | Jacksonville | FL | 32286 | NULL | - |
| PRV | PRV-26995 | 2026-06-24T23:18:35Z | Alan | ·· | Thompson | ·05-10-1972 | — | — | 581-628-8126 | UNKNOWN | 2288 Sunset Blvd | Eden Prairie | MN | 55346 | NULL | — |
| PRV | PRV-20468 | 2026-02-10T12:42:42Z | Hanson, Sophia | D. | — | 1969-04-26 | NULL | N/A | 13236540001 | ·· | 975 WASHINGTON STREET | NASHVILLE | TN | 37283 | — | ·· |
| PRV | PRV-24378 | 2026-02-22T22:11:41Z | KATHRYN | — | GONZALEZ | 13-08-1988 | uhc-91606-76 | UNKNOWN | 6019982729 | KATHRYN.GONZALEZ79@OUTLOOK.COM | 4472 MAIN STREET | MINNEAPOLIS | MN | 55483 | null | MEDICARE-ADV-A |
| PRV | PRV-22684 | 2026-02-21T21:37:56Z | Kyle | — | Ross | ·08/03/70 | - | ·· | 244.900.0918 | kyle.ross58@aol.com | N/A | UNKNOWN | - | ·N/A | - | - |
| PRV | PRV-20691 | 2026-03-27T14:03:27Z | Black, Ethan | — | — | 2006-05-10 | ···· | - | (762) 581-2027 | ethan.black91@icloud.com | 4513 Washington St | Columbus | OH | 43285 | — | CHOICE-PLUS-PPO |
| PRV | PRV-25660 | 2026-06-02T00:40:46Z | WALTER | — | GILBERT | 05/27/1963 | — | - | 4285885393 | walter.gilbert@hotmail.com | 2595 Maple Ave Apt 4 | Chandler | AZ | ·NULL | — | — |
| PRV | PRV-20952 | 2026-03-31T03:10:44Z | Alexis | — | Garcia | 1951-02-67 | N/A | N/A | 7847261760 | alexis.garcia@gmail.com·· | 9065 Desert Sky Boulevard | Charlotte | NC | ·28215 | UNKNOWN | ·N/A |
| PRV | PRV-24483 | 2026-04-08T04:58:47Z | Douglas | — | Hunt | 1965-02-04 | N/A | •••-••-8890 | (600) 231-6071·· | null | 9724 SUNSET BLVD | Tempe | AZ | 85249 | null | NULL |
| PRV | PRV-29290 | 2026-04-03T17:11:23Z | Brian | D | Rogers | 1948-09-13 | — | — | null | brian.rogers@yahoo.com | 3843 MOUNTAIN VIEW DRIVE | Glendale | AZ | 85396 | — | null |
| PRV | PRV-25795 | 2026-05-02T23:21:02Z | Logan | — | Schmidt | 1940-05-01 | UHC-14333-36 | NULL | (242) 224-0261 | — | 1699 Desert Sky Boulevard | MESA | AZ | 85237 | N/A·· | NULL |
| PRV | PRV-27232 | 2026-07-11T10:33:24Z | Marilyn | — | Jones | 9158-04-09 | UHC-57668-65 | NULL | — | marilyn.jones@hotmail.com | 9289 MAIN ST | FRESNO | CA | 93780 | — | - |
| PRV | PRV-20433 | 2026-07-29T16:09:24Z | ANDREA | — | ·RUSSELL | 03/04/85 | — | •••-••-6565 | — | — | ·9061 OCEAN AVE | Houston | TX | 77080 | - | null |
| PRV | PRV-28128 | 2026-04-19T14:19:20Z | DONALD | T | HOWARD | 19930321 | UHC-66385-91·· | null | (652) 687-9852 | N/A | 2317 Lake View Rd | SCOTTSDALE | Arizona | 85241 | UNKNOWN | null |
| PRV | PRV-27972 | 2026-01-17T08:50:34Z | ·Amy | ·E | Hicks | 03/21/1960 | UHC-14831-12 | NULL | (959) 654-2063 | UNKNOWN | 6886 Palm Dr | Gilbert | Arizona | 85277 | - | — |
| PRV | PRV-28827 | 2026-07-22T05:08:12Z | ·Justin | ·· | Warren | 2007-01-18 | N/A | •••-••-4417 | (352) 905-2564 | ·NULL | 9861 Harbor Blvd Apt 23 | ATLANTA | GA | 30328 | N/A | UNKNOWN |
| PRV | PRV-28729 | 2026-06-27T07:48:18Z | Samuel | — | Daniels | 1977-11-16 | ···· | NULL | 7770271 | N/A | NULL | null·· | UNKNOWN | N/A | N/A·· | SELECT-EPO |
| PRV | PRV-20695 | 2026-02-20T01:46:35Z | Sandra | — | Woods | Apr 9, 1950·· | UNKNOWN | — | 7283494818 | — | 2795 Broadway | Denver | CO | 80232 | - | NULL |
| PRV | PRV-26549 | 2026-10-10T13:54:20Z | SHRAON | — | ROSE | 2004-02-27·· | UHC-55095-57 | UNKNOWN | (270) 396-5719 | - | ·99 Lake View Rd | Orlando | fl | 32839 | — | - |
| PRV | PRV-22956 | 2026-09-19T13:33:48Z | Kyle | — | Dominguez | 02/12/1954 | UHC-43293-68·· | N/A | 733.206.8412 | UNKNOWN | 2026 Elm St | Minneapolis | MN | 55438-4959 | — | — |
| PRV | PRV-27494 | 2026-08-01T19:11:34Z | Charles | — | Rojas | 20011227 | ·UHC-80561-02 | - | (330) 523-8014 | - | 7847 CAMELBACK ROAD Apt 17 | LOS ANGELES | CA | 90003 | — | CORE-HMO |
| PRV | PRV-23113 | 2026-06-23T21:08:03Z | JUSTIN | Y | CASTRO | Oct 26, 1943 | UNKNOWN | - | 336-602-7995 | justin.castro@proton.me | 5655 Bayshore Drive | TUCSON | AZ | 85719 | — | - |
| PRV | PRV-25756 | 2026-10-11T13:53:53Z | Olivia | — | Franklin | 08/18/03·· | NULL | •••-••-4947 | 2308304907 | UNKNOWN | 2718 Palm Drive | Seattle | WA | 98101 | N/A | — |
| PRV | PRV-24577 | 2026-04-29T19:22:56Z | Sean | — | Stephens | 9140-03-05 | UHC-47949-16 | null | 213-359-1012 | NULL | 6061 Grand Avenue | ·Orlando | FL | 32881 | NULL | ·UNKNOWN |
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:49.122Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty