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-29481 | 2026-03-24T11:22:14Z | WILLLIE | — | BENNETT | 19690125 | — | N/A | 6495868623 | null | - | — | — | ·· | — | — |
| PRV | PRV-28270 | 2026-08-02T12:59:38Z | Jesse | Y | Baker | 1985-01-05·· | NULL·· | — | (319) 932-9132 | UNKNOWN | ·6412 Lincoln Way | HOUSTON | TX | 77033 | UNKNOWN | - |
| PRV | PRV-24035 | 2026-06-30T11:42:22Z | CHRISTIAN | — | SANDERS | 1966-12-19 | ·UHC-91645-49 | UNKNOWN | 381-377-6241 | N/A | 1092 Park Place | Tucson | AZ | N/A | ·- | null |
| PRV | PRV-22846 | 2026-08-29T15:26:50Z | christine | — | mcdonald | 1952-09-07 | UHC-07777-60 | null·· | 353-477-3061 | null | 1438 Grand Avenue | Eden Prairie | MN | 55300-3747 | -·· | — |
| PRV | PRV-27275 | 2026-02-19T08:28:07Z | Rios, Harold | — | ···· | 1982-09-28 | UHC-13868-34 | NULL | 482-956-3325 | harold.rios@icloud.com | 2214 HARBOR BLVD | Minneapolis | MN | ·55447 | — | — |
| PRV | PRV-22850 | 2026-04-14T17:56:20Z | mariana | Q | stevens | 1967-07-19 | UNKNOWN | NULL | 800-745-4249 | — | 2593 Main St | MINNEAPOLIS | MN | 55471·· | null | N/A |
| PRV | PRV-23781 | 2026-06-29T20:40:55Z | deborah | O. | gordon | 1941-05-26·· | — | null | 3398306272 | UNKNOWN | — | ···· | null | N/A | N/A | CORE-HMO |
| PRV | PRV-29383 | 2026-07-06T15:11:08Z | Raymond | W. | Mendoza | 1993-02-15·· | UHC-69480-21 | •••-••-5032 | +1 867 269 8446 | RAYMOND.MENDOZA@ICLOUD.COM | 5981 Maple Avenue | CHANDLER | AZ | 85268 | NULL | NAVIGATE-HMO |
| PRV | PRV-27322 | 2026-01-01T09:56:37Z | Jacqueline | — | Clark·· | ·1943-06-17 | UNKNOWN·· | — | 5788747654 | N/A | 9455 Willow Ct | Tempe | AZ | 85204 | null | NULL |
| PRV | PRV-28742 | 2026-06-08T08:23:19Z | ALAN | — | ·OLSON | 1953-01-19 | UHC-34288-51 | null | null | — | ·9036 Ridge Rd | San Antonio | TX | ·78201 | NULL·· | OPTIONS-PPO |
| PRV | PRV-27667 | 2026-06-10T17:06:42Z | Albert | — | Larson | — | — | null | (970) 554-9588 | null | 197 Park Pl | Glendale | AZ | 85399 | null | - |
| PRV | PRV-21026 | 2026-07-18T08:54:00Z | Gonzalez, Dorothy | — | — | 1941-03-13 | UHC-11908-79 | •••-••-4027 | 17114479686 | DOROTHY.GONZALEZ2@PROTON.ME | 2871 Elm Street #128·· | TEMPE | AZ | null·· | — | — |
| PRV | PRV-28482 | 2026-06-20T19:51:45Z | Deborah | — | Richards | 06/14/55 | N/A | — | 8277154 | N/A·· | 7280 Bayshore Dr | Atlanta·· | GA | 30396-4868·· | null | - |
| PRV | PRV-28206 | 2026-02-17T01:11:25Z | Emma | P | Alvarez | Aug 21, 1971 | - | null | 7285720272 | — | UNKNOWN | — | null | - | — | — |
| PRV | PRV-23134 | 2026-01-01T19:01:15Z | ERIC | — | LANE | 11/21/1948 | UHC-13620-95 | •••-••-2669 | (598) 637-3246 | NULL | 1483 Meadow Lane | FRESNO | California | 93756 | UNKNOWN | N/A |
| PRV | PRV-25477 | 2026-10-01T03:07:33Z | ·Lawrence | P | Russell | 1987-08-05·· | UHC-94134-10 | NULL | 2872850074 | — | ·· | — | — | - | - | SELECT-EPO |
| PRV | PRV-23737 | 2026-02-27T15:21:00Z | LUCIA | ·· | LITTLE | 2008-01-04 | null | null | 9542185645 | UNKNOWN | null | UNKNOWN | null | N/A | - | — |
| PRV | PRV-23939 | 2026-01-13T20:45:17Z | Heather S | — | Ramirez | 1985-09-07 | — | — | (675) 669-5687 | heather.ramirez@yahoo.com | 3843 MAIN ST | ·PLANO | TX | N/A·· | NULL | — |
| PRV | PRV-26182 | 2026-01-25T20:50:21Z | elijah | — | phillpis | 1996-11-21 | — | — | 952.509.1543 | NULL·· | N/A | — | — | — | NULL | MEDICARE-ADV-B |
| PRV | PRV-20954 | 2026-07-15T06:10:02Z | Lawrence | — | Burke | Mar 7, 1951 | — | - | 488-783-5554 | — | 1137 Palm Drive | GILBERT | AZ | 85259 | N/A | NULL |
| PRV | PRV-20848 | 2026-06-05T18:39:23Z | ·BRUCE | Y | JONES | 1971-05-22 | uhc-03857-67 | •••-••-1113 | 7869575176 | NULL | — | — | — | — | — | — |
| PRV | PRV-24886 | 2026-02-13T07:17:35Z | Megan | R. | ·Lee | 11-08-1974 | UHC-53262-83 | - | ···· | null | 1493 HIGHLAND AVENUE | DENVER | CO | 80254-6189 | — | - |
| PRV | PRV-26100 | 2026-09-13T00:19:00Z | Ahmed | — | Ford | 01/28/1973 | UHC-38320-21 | •••-••-5088 | +1 738 705 4692 | NULL | 9525 Harbor Blvd | Sacramento | CA | 95829 | - | — |
| PRV | PRV-25685 | 2026-05-14T14:59:41Z | Judy | — | Hoffman | 19491107 | UHC-63831-15 | N/A | N/A | JUDY.HOFFMAN83@PROTON.ME | 9408 VALLEY VIEW DR | PHOENIX | AZ | 85016 | — | null |
| PRV | PRV-25414 | 2026-04-19T01:48:58Z | JONATHAN | — | FERGUSON | 06/09/1982 | null | •••-••-2516 | null | null | 4690 Forest Ave Apt 2 | Gilbert | AZ | 85276-9184·· | NULL | NULL |
| PRV | PRV-23544 | 2026-05-08T12:27:24Z | Kathleen | — | Bryant | 08/19/93 | N/A | •••-••-3937 | NULL | N/A | 5236 Mesa Drive | Scottsdale | AZ | 85288 | -·· | N/A |
| PRV | PRV-27387 | 2026-02-24T23:32:52Z | Steven | L | Gibson | 0813-02-04 | NULL | N/A | 473-853-0410 | N/A | - | — | NULL | N/A | NULL | — |
| PRV | PRV-23594 | 2026-01-11T15:12:25Z | Angela | ···· | Kelley | 1985-11-01 | — | - | +1 766 483 8188 | — | 7831 Sage Ct | SEATTLE | WA | 98159 | — | CHOICE-PLUS-PPO |
| PRV | PRV-29231 | 2026-07-17T20:41:07Z | yukki | — | simpson | 1964-09-27 | UHC-06184-67 | N/A | 254.236.6654·· | null·· | 3800 Ridge Road | Charlotte | NC | ·28212 | — | - |
| PRV | PRV-28226 | 2026-04-05T02:09:21Z | LAWRENCE | L | JOHNSTON | 1981-05-16 | UHC-28017-01 | - | ·19333107818 | — | 5252 Highland Ave·· | Tempe | AZ | 85240 | N/A | N/A |
| PRV | PRV-26004 | 2026-02-14T14:38:46Z | AMBER | — | WELLS | 1939-12-20 | UHC-53150-30 | •••-••-7141 | NULL | N/A | 7373 JEFFERSON AVE | ·CHANDLER | AZ | — | NULL | UNKNOWN |
| PRV | PRV-24146 | 2026-07-12T21:40:05Z | LUCIA | — | BANKS | 1952-09-01 | null | — | N/A | - | 2860 Jefferson Avenue | CHANDLER | AZ | 85277 | — | NULL |
| PRV | PRV-25450 | 2026-03-25T07:13:17Z | Jordan, Sean | K | — | 11/12/1968 | UHC-98220-61 | — | +1 326 963 8291 | sean.jordan34@yahoo.com | 6969 Canyon Road | Jacksonville | FL | 32234 | UNKNOWN | MEDICARE-ADV-A |
| PRV | PRV-20501 | 2026-06-02T20:08:32Z | Jerry | — | Walssh | 1994-09-24 | UHC-81721-07 | ···· | 16004562286 | jerry.walsh18@icloud.com | NULL | — | — | UNKNOWN | - | — |
| PRV | PRV-21560 | 2026-02-01T22:00:26Z | ryan | ···· | waarren | 1946-08-13 | UHC-88581-01 | •••-••-8239 | NULL | ryan.warren@yahoo.com | 243 Sunset Boulevard | Nashville | TN | 37259 | N/A·· | ·N/A |
| PRV | PRV-20300 | 2026-06-24T20:47:57Z | justin | — | shaw | 02/13/1971 | uhc-36800-97 | null | 7232522359·· | — | ·9091 Baseline Road | Eden Prairie·· | MN | 55301 | null | CORE-HMO |
| PRV | PRV-23421 | 2026-01-16T15:50:05Z | nancy | ···· | stpehens | 2005-01-22 | - | NULL | (854) 472-9067 | — | 8008 Ocean Avenue | SCOTTSDALE | AZ | 85205 | N/A | — |
| PRV | PRV-24030 | 2026-03-22T11:43:16Z | ·BARRBARA | — | ·STEPHENS | 8/3/2008 | N/A | •••-••-9755 | (717) 950-3033 | NULL | 315 Grand Avenue | Chandler | AZ | 85248·· | — | — |
| PRV | PRV-27681 | 2026-05-02T07:25:49Z | Lauren | ·· | Peters | 1984-07-16 | - | N/A | +1 225 285 7791 | null | 1420 Oak Street | GLENDALE | Arizona | 85392·· | N/A | NULL |
| PRV | PRV-22844 | 2026-04-04T05:52:44Z | Phillips, Anthony | S | ·· | 01/11/1950 | UHC-18242-24 | •••-••-2104 | ·5786686154 | ANTHONY.PHILLIPS@HOTMAIL.COM | ·6503 Lake View Road | Charlotte | NC | 28260 | null | — |
| PRV | PRV-24673 | 2026-01-07T06:46:02Z | Hicks, Brandon | — | — | 1956-90-03 | UHC-36394-59 | N/A | 15655433767 | BRANDON.HICKS@ICLOUD.COM·· | — | - | N/A | — | null | null |
| PRV | PRV-21422 | 2026-04-11T02:54:05Z | Morrison, Arjun | P | — | 1981-02-02 | UHC-53363-37 | null | 13414964629 | ·arjun.morrison@outlook.com | null | NULL | - | - | N/A | null |
| PRV | PRV-20487 | 2026-03-19T15:23:40Z | arjun | ·· | brown | 12/18/1998 | UHC-10496-36 | •••-••-9008 | 5637054767 | — | 1914 Union Street #667 | Plano | Texas | 75036-7673 | NULL | — |
| PRV | PRV-24224 | 2026-07-07T04:42:10Z | ROGER | — | GRAHAM | 1985-04-21 | UHC-31502-30 | — | ·+1 763 749 9012 | - | N/A | null | — | null | - | UNKNOWN |
| PRV | PRV-23723 | 2026-04-05T20:50:23Z | Nancy | — | Johnson | 8/3/1956 | ·UHC0868537 | — | 775-340-0220 | UNKNOWN | 7906 Broadway | Tucson | AZ | 85789·· | N/A | — |
| PRV | PRV-23892 | 2026-07-23T17:27:09Z | Lauren | H. | Shaw | 08/15/1997 | UHC-70188-66 | — | 601-416-9084·· | N/A | 2823 Spring Street | Los Angeles | California | 90095·· | null | — |
| PRV | PRV-24828 | 2026-10-15T06:25:33Z | jonathan | — | weaver | 9170-01-17 | NULL | null·· | +1 868 933 3157 | ·NULL | 7790 Park Pl | Nashville | TN | 37221-6344 | null | — |
| PRV | PRV-29215 | 2026-03-02T10:31:37Z | Roger | — | Reid | 06/04/61 | uhc-97347-56 | •••-••-4073 | (315) 712-7510 | NULL·· | 6939 Broadway | Minneapolis | MN | 55480-0828 | — | — |
| PRV | PRV-20176 | 2026-01-25T14:51:43Z | DANIEL | — | BURTON | 20-04-1962 | ·· | - | ·(754) 432-2656 | N/A | 8924 Canyon Road | PHOENIX | AZ | 85021 | — | MEDICARE-ADV-B |
| PRV | PRV-23402 | 2026-02-04T16:14:32Z | ARJUN | O | JACKSON | 19880106 | ·UHC-19640-97 | •••-••-6764 | 8265469652 | UNKNOWN | 9393 FOREST AVE | Jacksonville | FL | 32294 | 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:56.305Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty