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-28984 | 2026-06-17T06:11:34Z | BRYAN | — | RBINSON | 1961-03-19 | — | — | 3862410356 | bryan.robinson@proton.me | 6564 MAPLE AVENUE | Seattle | WA | 98191 | UNKNOWN | — |
| PRV | PRV-28759 | 2026-08-02T17:44:50Z | Fatima | T | Knight | 09/13/63 | UHC-92327-02 | ·null | ·6345513 | fatima.knight@yahoo.com·· | 5467 Oak Street | PHOENIX·· | AZ | ·85045 | N/A | MEDICARE-ADV-B |
| PRV | PRV-24306 | 2026-04-27T09:56:18Z | ·Steven | — | George | 1971-03-07 | UHC3960773 | — | 18165342757 | null | 1231 Park Pl | LOS ANGELES | CA | 90067 | UNKNOWN | — |
| PRV | PRV-29122 | 2026-07-05T22:45:54Z | ·grace | — | porter | ·1948-11-03 | UHC-43858-93 | •••-••-4069 | (748) 616-8913 | — | 1565 Indian School Rd | Seattle | Washington | 98192 | UNKNOWN | ·CHOICE-PLUS-PPO |
| PRV | PRV-28249 | 2026-07-03T18:37:00Z | Clark, Mei | — | — | 19870309 | UHC-15546-20 | — | 7658962929 | — | 4102 SUNSET BOULEVARD | GLENDALE | AZ | 85329 | null | NULL |
| PRV | PRV-28724 | 2026-03-10T12:36:24Z | Jacob | — | Gomez | 1976-07-10 | UHC-45306-71 | NULL | 253-237-5044 | null | 6461 VALLEY VIEW DRIVE | Atlanta | GA | N/A | — | - |
| PRV | PRV-21701 | 2026-03-31T19:18:19Z | James, Terry | ···· | — | 02/05/1977 | — | null | 8332920171 | — | 7796 Camelback Rd | Mesa | AZ | 85273 | N/A | UNKNOWN |
| PRV | PRV-28041 | 2026-04-06T22:58:19Z | RANDY | D. | LAWRENCE | 1968-05-03 | UNKNOWN | N/A | (912) 405-0085 | — | ·4612 Highland Avenue | Charlotte | NC | ·28283 | null | — |
| PRV | PRV-21288 | 2026-08-31T14:23:31Z | ·Thomas | — | Espinoza | 4/25/1975 | — | NULL·· | 2457435717 | NULL | 2938 MAPLE AVENUE·· | Atlanta | GA | 30397 | — | — |
| PRV | PRV-25632 | 2026-01-27T11:39:13Z | MEI | J. | STEVENS | 1990-07-72 | — | N/A | 250-768-4229 | UNKNOWN | 7727 HIGHLAND AVENUE | Glendale | AZ | 85383 | N/A·· | UNKNOWN |
| PRV | PRV-24135 | 2026-08-14T16:09:15Z | Bryant | — | Cynthia | 1971-11-16 | NULL | UNKNOWN | 377-468-2174 | UNKNOWN | 5310 WASHINGTON ST | Los Angeles | CA | 90011-2216 | - | NULL |
| PRV | PRV-21281 | 2026-09-20T12:07:25Z | Logan | N | Bell | 1970-08-22 | — | NULL·· | (224) 759-8345 | LOGAN.BELL@ICLOUD.COM | 8447 River Road Apt 1 | Miami | FL | 33145-0494 | - | N/A·· |
| PRV | PRV-25138 | 2026-02-06T18:56:50Z | ANNA·· | — | BARNES | 08/23/86 | UHC-89276-13 | NULL | (945) 752-0541 | — | 6560 Lincoln Way | Fresno | CA | 93767 | UNKNOWN | null |
| PRV | PRV-29025 | 2026-05-25T19:22:54Z | RONALD | ···· | SILVA | 1946-07-18 | null | •••-••-3896 | (840) 545-0144 | ronald.silva@gmail.com | N/A | UNKNOWN | - | N/A | NULL | NULL·· |
| PRV | PRV-29439 | 2026-02-25T12:06:01Z | Samantha | — | Williamson | 05/21/92 | NULL | — | 17719194035 | - | — | ·· | — | — | — | - |
| PRV | PRV-26987 | 2026-10-18T20:59:19Z | CALROS | — | WANG | 21-05-1947 | ·UHC-28233-13 | •••-••-0114 | (984) 422-9467 | — | - | — | — | NULL | UNKNOWN | — |
| PRV | PRV-28196 | 2026-02-27T02:48:33Z | Nicholas | V | Jackson | 08/03/1987 | ·UHC-25427-08 | null | (577) 369-4218 | null | — | NULL | — | — | null | NAVIGATE-HMO |
| PRV | PRV-21978 | 2026-06-03T00:06:35Z | ·daniel | V | miller | 11/11/1964·· | UHC-96988-93 | •••-••-3159 | 12362954985 | daniel.miller@aol.com | 7620 PALM DRIVE·· | TUCSON | AZ | 85746 | N/A | NULL |
| PRV | PRV-24691 | 2026-02-25T19:52:18Z | Randy | — | Robertson | 1977-01-15 | N/A·· | NULL | (448) 914-7374 | randy.robertson66@gmail.com | 6663 Church Street | San Diego·· | CA | 92137 | null | — |
| PRV | PRV-21747 | 2026-08-26T14:54:12Z | Gibson, Ahmed | N. | — | 19550110 | — | •••-••-6974 | 563-597-6220 | NULL | 5266 Main Street | San Diego | CA | 92155 | NULL | UNKNOWN·· |
| PRV | PRV-24745 | 2026-03-02T03:54:48Z | Mariana | T | Kelly | — | UHC-73475-49 | UNKNOWN | — | mariana.kelly@outlook.com | - | — | N/A | null | — | CHOICE-PLUS-PPO |
| PRV | PRV-21736 | 2026-08-15T06:39:31Z | MICHAEL | — | WELLS | 1953-10-18 | null | - | 6285783924 | michael.wells@icloud.com | 4425 MESA DRIVE | Charlotte | NC | 28254 | NULL·· | MEDICARE-ADV-A |
| PRV | PRV-25454 | 2026-02-11T03:38:44Z | Martha | — | Castro | 1984-04-01 | UNKNOWN·· | NULL | UNKNOWN | martha.castro@proton.me | 5565 HILLCREST ROAD Apt 25 | Nashville | TN | 37234-9351 | — | SELECT-EPO |
| PRV | PRV-22181 | 2026-02-06T17:25:09Z | Maria | I | Estrada | 1953-05-25 | — | •••-••-9512 | 6723712656 | NULL | 5526 VALLEY VIEW DR | Jacksonville | FL | — | null | — |
| PRV | PRV-29354 | 2026-08-14T10:58:42Z | RALPH | — | RODRIGUEZ | Aug 3, 1991 | UHC-39276-85 | null | 287-396-4684 | null | 7263 Washington St | Plano | TX | 75098·· | - | - |
| PRV | PRV-23514 | 2026-05-03T21:05:22Z | Lawrence | — | Garza | 1959-02-09 | UNKNOWN | NULL | ·226-702-1806 | lawrence.garza13@icloud.com | 6718 Park Place | LAS VEGAS | NV | 89176 | NULL | N/A |
| PRV | PRV-21250 | 2026-03-19T17:37:08Z | JEFFREY | S | LARSON | 1955-09-24·· | UHC-00373-95 | •••-••-7859 | 12895514159 | JEFFREY.LARSON62@OUTLOOK.COM | ·5242 Jefferson Avenue | Scottsdale | AZ | 85236 | N/A | - |
| PRV | PRV-26293 | 2026-06-23T18:01:40Z | ·Walter | ·· | Cook | ·06/25/62 | UHC-07206-18 | N/A | 835-367-6991 | — | 4996 MEADOW LN·· | TAMPA | FL | 33611 | ·N/A | MEDICARE-ADV-B |
| PRV | PRV-20152 | 2026-06-25T01:21:25Z | ·Amy | — | Hanson | 10/08/1987 | — | UNKNOWN·· | N/A | UNKNOWN | 62 LAKE VIEW ROAD | Tucson | AZ | — | null | — |
| PRV | PRV-25019 | 2026-08-06T06:42:02Z | DIANE | — | ROGERS | 2004-10-08 | UHC2603276 | NULL | 9448180415 | null | 7771 Maple Avenue·· | Gilbert | AZ | 85215 | UNKNOWN | — |
| PRV | PRV-29230 | 2026-03-21T02:31:56Z | Linda | — | Cooper | 1950-12-07 | — | null | 2522521993·· | - | 4702 JEFFERSON AVENUE | Las Vegas | Nevada | 89153 | NULL | — |
| PRV | PRV-22590 | 2026-07-16T07:12:52Z | SULLIVAN | E | MICHELLE | 1950-10-26 | null | NULL | +1 634 474 6191 | NULL | 2442 MARKET ST | DALLAS | tx | ·75255 | ·· | UNKNOWN |
| PRV | PRV-20843 | 2026-05-29T13:01:10Z | Amanda | — | Herrera | 20-10-1943 | ·· | null | 340-210-2249 | AMANDA.HERRERA@HOTMAIL.COM | 1424 Lake View Rd | Eden Prairie | MN·· | 55330 | N/A | N/A |
| PRV | PRV-29459 | 2026-04-05T07:34:22Z | Teresa | — | Woods | 09/17/68 | N/A | •••-••-4930 | 7654510728 | — | 4912 Hillcrest Rd | Chandler | AZ·· | 85221 | — | — |
| PRV | PRV-26184 | 2026-03-10T10:29:14Z | Alexander | F | Ellis | 08/14/1979 | — | UNKNOWN | 7955709797 | ALEXANDER.ELLIS98@GMAIL.COM | 219 Lincoln Way | DENVER | CO | 80234-3073 | — | ···· |
| PRV | PRV-26606 | 2026-01-05T08:41:04Z | dylan | ·· | gibson | Jan 13, 2002 | UHC-54125-64 | N/A | 675-709-8180 | — | 8165 Meadow Lane | JACKSONVILLE | FL·· | 32264 | - | CHOICE-PLUS-PPO |
| PRV | PRV-24742 | 2026-04-02T14:09:32Z | Jesse | — | ·Kelley | 6/3/1954 | — | •••-••-0800 | ·9762097230 | null | 6169 Camelback Road | San Antonio·· | TX | 78217 | — | MEDICARE-ADV-B |
| PRV | PRV-28231 | 2026-09-22T20:04:30Z | Susan | — | Bradley | Nov 11, 1982 | UHC-96595-29·· | — | 19597875567 | NULL | 3310 Camelback Rd | DENVER | CO | 80201 | null | — |
| PRV | PRV-25035 | 2026-01-11T04:54:14Z | Alan·· | U | Rice | 1997-01-02 | UHC-08546-54 | N/A·· | 4873637638 | ALAN.RICE@PROTON.ME | 5955 Sage Ct | Seattle | Washington | 98161 | UNKNOWN | N/A |
| PRV | PRV-27880 | 2026-01-07T15:08:43Z | Marshall, Samantha | ·· | — | 11/04/02 | UHC-35254-25 | •••-••-2671 | (538) 785-2236 | — | 1627 BROADWAY | Minneapolis | MN | 55490 | null | — |
| PRV | PRV-24415 | 2026-04-15T03:18:56Z | YUKI | — | RUSSELL | ·1942-02-14 | UHC-06443-59 | null | 483-990-4752 | yuki.russell94@proton.me | 4736 Ridge Rd | Mesa | Arizona | 85223 | - | - |
| PRV | PRV-25007 | 2026-06-24T10:15:28Z | Charles | L. | Webb | 08/11/90 | UHC-53654-01 | — | +1 444 407 9877 | - | ·2023 Desert Sky Blvd | LAS VEGAS·· | NV | 89154 | N/A | UNKNOWN |
| PRV | PRV-21469 | 2026-08-14T14:07:47Z | Little, Brian | — | — | 19460209·· | UHC-65114-56 | NULL | 986-588-1087 | — | 9016 Maple Ave | Mesa | AZ | 85278 | - | — |
| PRV | PRV-24117 | 2026-10-08T01:17:18Z | RAYMOND | — | BANKS | 1966-04-28 | UNKNOWN | — | — | raymond.banks@hotmail.com·· | 3219 GRAND AVENUE | Eden Prairie | MN | 55344 | — | null |
| PRV | PRV-20967 | 2026-05-10T21:20:50Z | GARY | — | AUSTIN | 1949-04-24 | - | N/A | ·307-949-9616 | UNKNOWN | 2402 Ridge Road | AUSTIN | TX·· | 78735 | — | ·MEDICARE-ADV-A |
| PRV | PRV-26779 | 2026-07-24T06:12:56Z | BARBARA | — | COLLINS | 20040517 | — | UNKNOWN | 19139945612·· | BARBARA.COLLINS38@YAHOO.COM·· | 647 Market Street | Minneapolis | MN | 55468 | ·UNKNOWN | — |
| PRV | PRV-28108 | 2026-09-25T07:17:26Z | Kevin | — | Scott | 1951-12-01 | UHC-71708-68 | - | 711.993.8218 | - | null | - | UNKNOWN | — | NULL | - |
| PRV | PRV-26042 | 2026-10-08T23:04:41Z | Ashley | — | Ramos | 1994-03-27 | - | NULL | 9385921902 | UNKNOWN | 1140 FOREST AVE | Jacksonville | ·FL | 32283-2943 | null | - |
| PRV | PRV-29593 | 2026-01-25T18:25:19Z | EUGENE | V. | DANIELS | 02/05/94 | — | UNKNOWN | NULL | UNKNOWN | 9891 Oak Street | Mesa | Arizona | 85232 | NULL | SELECT-EPO |
| PRV | PRV-24635 | 2026-07-30T14:19:22Z | Aaron | — | Vazquez | 2003-11-22 | UHC-00207-30 | — | 880-616-5840 | UNKNOWN | 5948 APACHE BLVD | Gilbert | AZ | 85252 | 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:53.742Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty