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-29196 | 2026-08-05T13:51:46Z | ana | X | elliott | 1959-04-12 | — | UNKNOWN | 7853505297 | ·ana.elliott41@gmail.com | 4973 MOUNTAIN VIEW DRIVE | Seattle | WA | 98119 | NULL | NAVIGATE-HMO |
| PRV | PRV-28931 | 2026-03-04T16:48:40Z | Christian | — | Thomas | 20051019 | ···· | N/A | 683-447-6734 | - | 4914 MARKET STREET | GILBERT | AZ | 85274 | N/A | — |
| PRV | PRV-24896 | 2026-09-11T01:22:31Z | Laura | ·I | Herrera | 1959-06-27 | ·UHC7942743 | NULL | +1 211 278 1293 | — | 8443 WILLOW CT | Phoenix | AZ | 85004 | ·· | - |
| PRV | PRV-23333 | 2026-08-06T22:35:49Z | Miller, Santiago | — | — | 2302-91-51 | ·· | N/A | 9432530574 | — | UNKNOWN | — | — | ·· | - | N/A |
| PRV | PRV-20849 | 2026-06-11T02:21:37Z | DAVID | J. | TURNER | 2008-02-01 | NULL | •••-••-5822 | — | — | 6101 Palm Drive | DALLAS | TX | ·75294 | — | — |
| PRV | PRV-29301 | 2026-06-02T18:07:30Z | DENISE | C | MASON | 1965-02-19 | — | N/A | - | denise.mason62@proton.me | 4099 Canyon Road | Atlanta | GA | 30314 | ···· | — |
| PRV | PRV-27356 | 2026-06-02T12:52:07Z | Ralph | H | Morris | 1971-12-28·· | NULL | •••-••-9508 | 471-973-9793 | UNKNOWN | 2055 Forest Ave Apt 20 | Austin | ·TX | 78718 | NULL | SELECT-EPO |
| PRV | PRV-21583 | 2026-05-09T03:28:46Z | Camila | — | Knight | 26-12-1977·· | N/A | — | 866-663-7272 | CAMILA.KNIGHT62@YAHOO.COM | 9815 HARBOR BLVD | Phoenix·· | AZ | 85062 | — | — |
| PRV | PRV-28356 | 2026-01-20T14:44:56Z | JOAN | K | ·ALLEN | 1967-12-22 | UHC-42345-40 | - | (860) 367-9884 | joan.allen@icloud.com | 7075 HARBOR BLVD·· | Orlando | FL | UNKNOWN | — | NULL |
| PRV | PRV-28154 | 2026-09-13T11:24:56Z | Coleman, Teresa | Z | ···· | 2005-06-26 | ·· | •••-••-9674 | +1 814 944 9845 | NULL | 5737 Maple Avenue | Phoenix | AZ | 85029 | UNKNOWN | — |
| PRV | PRV-29136 | 2026-01-17T13:38:07Z | ashley | ·· | diaz | 1976-12-18 | UHC-49500-48 | N/A | 7967096069 | NULL | 6737 Oak St | Minneapolis·· | MN·· | UNKNOWN | N/A | NULL |
| PRV | PRV-25761 | 2026-08-03T22:55:19Z | Yuki | ·· | Valdez | 08/07/43 | UHC4727952 | ·null | 358-690-7058 | — | — | — | — | NULL | ·· | NULL |
| PRV | PRV-26429 | 2026-05-22T23:27:10Z | Timothy | I. | Sullivan | ·19920526 | ·UNKNOWN | — | 390-347-7696 | — | 5317 Washington St·· | ·Charlotte | NC | ·N/A | - | ·- |
| PRV | PRV-27794 | 2026-06-22T19:46:12Z | Morgan, Mark | — | — | 1981-04-13 | UHC-34154-23 | ···· | 524-273-3609 | N/A | 2340 PINE DR #761 | Tampa | FL | 33607 | null | UNKNOWN |
| PRV | PRV-27094 | 2026-02-05T03:44:10Z | Alice | — | Gonzales | Feb 5, 2004 | UHC-98533-24 | •••-••-7138 | (322) 953-1258 | — | 7162 PARK PL | ·Atlanta | Georgia | 30384 | — | — |
| PRV | PRV-22999 | 2026-02-21T03:47:30Z | JANICE | — | DUNN·· | 4/18/1953 | — | — | 690-901-2854 | UNKNOWN | 3591 OAK ST | Denver | CO | 80249 | ·NULL | NULL |
| PRV | PRV-27670 | 2026-08-16T12:56:19Z | John | — | Hayes | 11/20/2002·· | UHC-59901-87 | •••-••-2629 | 8908777429 | — | N/A | UNKNOWN·· | — | N/A | NULL | NAVIGATE-HMO |
| PRV | PRV-22564 | 2026-06-23T09:14:43Z | Danielle | — | Warren | 1978-07-30 | UHC-02346-95 | - | 2193497984 | DANIELLE.WARREN67@ICLOUD.COM | 4650 Maple Ave | Plano | TX | 75033 | — | NULL |
| PRV | PRV-27978 | 2026-07-16T18:44:28Z | Isabella | — | Patel | 2001-11-25 | UHC-65359-86 | - | 8426531571 | — | 9684 Ocean Avenue·· | Fresno | California | 93741 | - | OPTIONS-PPO |
| PRV | PRV-21450 | 2026-04-11T19:58:16Z | PETER·· | — | WALLACE | 1974-02-10 | ·UHC-28274-41 | •••-••-4028 | 7815872506 | - | 1572 Lake View Road | Tampa·· | FL | 33622-7376 | — | NULL |
| PRV | PRV-22597 | 2026-02-24T19:17:42Z | ETHAN | — | ·RAMOS | Apr 1, 2005 | null·· | — | (494) 307-4464 | ethan.ramos12@hotmail.com | 7771 Spring Street | Tampa | FL | 33654-6352 | N/A | - |
| PRV | PRV-27339 | 2026-03-16T06:58:43Z | Emily | F | Porter | 1947-04-11 | UHC-00724-29 | ·UNKNOWN | (854) 311-7653·· | emily.porter@aol.com | 3895 BAYSHORE DRIVE | Austin | TX·· | — | null | — |
| PRV | PRV-24453 | 2026-03-15T12:33:18Z | WEI | — | CARR | 1977-01-10 | NULL | •••-••-8332 | 212-529-9826 | — | NULL | — | - | null | — | — |
| PRV | PRV-24040 | 2026-07-20T14:31:49Z | ·Pamela | — | Chen | 1941-11-06 | ·UNKNOWN | •••-••-7930 | +1 797 943 7379 | pamela.chen@proton.me·· | 8718 Canyon Road | Fresno | CA | 93788 | UNKNOWN | SELECT-EPO |
| PRV | PRV-25240 | 2026-03-04T03:33:31Z | Kevin | — | Jimenez | 1979-05-15 | N/A | null | 2288754057 | UNKNOWN | 6825 Ocean Avenue | Eden Prairie | MN | 55312 | N/A | — |
| PRV | PRV-20936 | 2026-02-26T04:06:11Z | Palmer, Gary | — | — | 08/24/48 | - | •••-••-3785 | ·(731) 888-2464 | ·· | 4655 MEADOW LN | Los Angeles | ca | 90091 | — | navigate-hmo |
| PRV | PRV-27768 | 2026-07-19T13:40:10Z | MORRISON | ·· | SANDRA | 2004-08-01 | UHC-31250-45 | •••-••-7577 | 3203309882 | - | null | null | UNKNOWN | ·UNKNOWN | N/A | MEDICARE-ADV-B |
| PRV | PRV-28490 | 2026-09-28T13:43:16Z | Teresa | P. | Ramos | 1998-03-26 | — | •••-••-3253 | 762-798-3861 | teresa.ramos@yahoo.com | 5696 SUNSET BLVD | Las Vegas | NV | 89186-3253 | N/A | - |
| PRV | PRV-21783 | 2026-04-15T17:40:41Z | Richard | — | Duncna | 12/24/1965 | — | NULL | (512) 663-5512 | — | 573 Oak St | Houston | ·TX | — | — | — |
| PRV | PRV-24516 | 2026-10-07T03:00:24Z | MARIANA | — | HARRISON | 03/03/2007 | N/A | — | 5877232833 | null | null | — | — | — | - | CHOICE-PLUS-PPO·· |
| PRV | PRV-29246 | 2026-08-27T08:10:59Z | JACK | — | ·GRAY | 11/25/66 | UHC-88547-19 | - | 9105895781 | UNKNOWN | 6736 Church St | SACRAMENTO | CA | 95837 | - | N/A |
| PRV | PRV-27913 | 2026-01-26T09:12:39Z | ·Gary | P | Hicks·· | 1953-03-01 | - | - | 461-215-3672 | UNKNOWN | 3882 Jefferson Avenue | Chandler | AZ | 85230 | — | MEDICARE-ADV-B |
| PRV | PRV-25721 | 2026-04-12T06:30:02Z | ·Shirley | — | Wheeler | Aug 12, 1995 | UHC-40849-45 | - | (742) 367-9545 | UNKNOWN | 4790 Ridge Rd | Las Vegas | NV | 89156 | N/A·· | UNKNOWN |
| PRV | PRV-27808 | 2026-02-02T23:27:59Z | Deborah | S | Burns | 1980-01-12 | UHC-63347-73 | ·· | 220-242-4505 | UNKNOWN | 2696 WILLOW COURT | Fresno | CA | 93727 | null | — |
| PRV | PRV-21242 | 2026-04-06T16:40:01Z | Matthew | — | Diaz | — | UHC-83536-21 | - | UNKNOWN | null | 2988 Market St #894 | Scottsdale | Arizona | 85271 | — | NULL |
| PRV | PRV-23202 | 2026-08-26T12:33:02Z | LUIS | — | CLARK | 1983-08-07 | UHC8493813 | — | 201.429.7624 | — | 8275 Church St | Columbus | Ohio | 43264 | — | — |
| PRV | PRV-20563 | 2026-05-22T17:54:25Z | Harvey | Y | Teresa | 24-07-1995·· | UHC-30222-34 | NULL | N/A | UNKNOWN | 4064 Palm Drive | Mesa | AZ | — | — | null |
| PRV | PRV-25689 | 2026-06-01T23:48:10Z | Le, Jonathan | U. | — | Aug 9, 1978 | — | NULL | 808-978-3259 | N/A | 8427 VALLEY VIEW DRIVE | Phoenix | AZ | 85016 | — | null |
| PRV | PRV-22963 | 2026-10-04T17:29:15Z | ZACHARY | K | LONG | 1957-09-19 | UHC-67657-07·· | — | ·791-475-8992 | NULL | ·8115 SPRING STREET | TEMPE | az | N/A | NULL | — |
| PRV | PRV-28672 | 2026-08-26T19:06:05Z | Linda | — | Russell | 1985-11-06 | NULL | ·UNKNOWN | 834-810-0444 | - | — | UNKNOWN | — | — | UNKNOWN | NULL |
| PRV | PRV-29253 | 2026-01-19T04:16:55Z | James | — | Porter | Jun 18, 1948 | ·UHC-83196-09 | N/A | — | NULL | 7495 Ocean Ave | Tempe | AZ | 85253 | — | NULL |
| PRV | PRV-24823 | 2026-08-13T16:18:17Z | ronald Q. | ···· | brown | 19640224 | N/A | null | 5384752 | ronald.brown2@gmail.com | 758 Elm St | Mesa | AZ | 85204 | UNKNOWN | — |
| PRV | PRV-22492 | 2026-06-29T07:27:58Z | mateo | — | fuller | 07/09/97 | UHC-83792-60 | - | 4945434855 | NULL | N/A·· | null | ···· | — | null | N/A |
| PRV | PRV-26909 | 2026-03-22T09:07:54Z | Mei | A | Hoffman | 1938-05-02 | UHC-76616-84 | •••-••-3464 | 656-345-8782 | mei.hoffman64@gmail.com | ·9428 Oak St | Plano | TX | 75031 | UNKNOWN | CHOICE-PLUS-PPO |
| PRV | PRV-22548 | 2026-09-08T11:06:15Z | bailey | — | harold | 19790805·· | NULL | NULL | — | ·HAROLD.BAILEY29@OUTLOOK.COM | 2892 Maple Avenue | Tucson | AZ·· | 85756 | N/A | null |
| PRV | PRV-28214 | 2026-07-02T02:34:41Z | Shirley | — | Murray | 1962-02-06 | — | — | 12977247218 | NULL | 1832 APACHE BOULEVARD | Denver | CO | 80267 | UNKNOWN | ·NULL |
| PRV | PRV-25759 | 2026-03-05T20:29:38Z | Carl | L | Castro | 1997-08-13·· | — | - | 705.610.9115 | — | 3675 LAKE VIEW RD #534 | Plano | TX | 75019 | - | NULL |
| PRV | PRV-28028 | 2026-07-27T22:10:37Z | Peter | — | Austin | 1976-01-23 | uhc-85220-86 | - | 14504836905 | — | 6884 Maple Ave | Gilbert | AZ | 85265 | null | NULL |
| PRV | PRV-24194 | 2026-08-22T13:37:51Z | ·Stephanie | ·Z | Mejia | 1984-11-12 | — | — | +1 564 847 6984 | null | 3840 Highland Ave·· | Glendale | Arizona | 85383-2132 | — | — |
| PRV | PRV-24051 | 2026-02-13T18:00:53Z | Alvarez, Paul | — | — | 20000510 | UNKNOWN | •••-••-0007 | ···· | — | 7640 Washington St | Houston | TX | 77048-6942 | 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:43:00.227Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty