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
Claims only, ordered by line number
| Source | Record | Received | First | Middle | Last | DOB | Member ID | SSN | Phone | Address | City | State | ZIP | Group | Plan | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLM | CLM-407661 | 2026-09-06T07:49:47Z | DYLAN | — | GUERRERO | 1944-04-17 | UHC7094933 | ·null | - | - | ·9202 Spring Street | Las Vegas·· | NV | 89119-2039 | GRP-2481 | — |
| CLM | CLM-401254 | 2026-09-28T16:01:27Z | Maria | F | Washington | 1968-08-24 | N/A | N/A | 16074832921 | null | — | NULL | — | ·· | GRP-8811 | MEDICARE-ADV-A |
| CLM | CLM-418123 | 2026-10-02T20:48:25Z | Sullivan, Donald | — | — | 1972-02-12 | UHC5588026 | — | +1 817 424 8036 | null | 9412 MAIN ST | FRESNO | CA | 93709 | — | OPTIONS-PPO |
| CLM | CLM-404583 | 2026-05-19T22:27:59Z | Donna | — | Austin | 19750522 | - | — | null | donna.austin@yahoo.com | 6301 Valley View Dr | TUCSON | AZ | null | GRP-5670 | — |
| CLM | CLM-428231 | 2026-01-23T07:26:54Z | Jerry | — | Dunn | 1993-02-22 | UNKNOWN | null | - | — | 5397 River Rd | Charlotte | NC | 28296 | GRP-6795 | N/A |
| CLM | CLM-407027 | 2026-02-12T18:26:54Z | Andrew | — | Woods | 1973-11-16 | UHC-68285-69 | null | — | — | 872 Union Street | Gilbert | AZ | 85250 | GRP-2913 | NULL |
| CLM | CLM-417403 | 2026-09-17T16:53:14Z | Terry | ·· | Le | 1982-05-18 | UNKNOWN | — | 411-955-4078 | — | null | — | NULL | — | GRP-3264 | ·CHOICE-PLUS-PPO |
| CLM | CLM-428080 | 2026-07-16T07:25:19Z | TERESA | — | VARGAS | 1944-05-14 | UHC5265373 | — | 325.439.9943 | — | 8464 Broadway | Los Angeles | California | 90090 | GRP-4426 | — |
| CLM | CLM-404071 | 2026-03-04T13:03:31Z | Ryan | — | Jimenez | 6/10/1955 | ·· | N/A | 2765095753 | ·NULL | 2708 Forest Avenue | DENVER | CO | 80294 | GRP-1969 | NULL |
| CLM | CLM-418031 | 2026-03-30T01:22:45Z | Kyle | — | Hill | Dec 22, 2005 | UHC-70211-77 | NULL | NULL | ·N/A | ···· | — | N/A | — | GRP-3670 | ·MEDICARE-ADV-B |
| CLM | CLM-404021 | 2026-06-30T13:32:34Z | Ethan | ·· | Rios | ·1992-05-13 | UHC-98500-33 | •••-••-3779 | (272) 285-6719 | NULL | 143 LAKE VIEW ROAD | Orlando | FL | 32828·· | GRP-6544·· | SELECT-EPO·· |
| CLM | CLM-419039 | 2026-01-27T18:45:18Z | DIAANA | — | WANG | 1941-11-23 | UHC-79599-65 | UNKNOWN | null | NULL | NULL | UNKNOWN | - | null | null | SELECT-EPO |
| CLM | CLM-432738 | 2026-06-06T00:24:07Z | ANA | ·· | GUTIERREZ | 09/20/71 | UHC-10479-88 | null | - | N/A | — | — | — | NULL | UNKNOWN | OPTIONS-PPO |
| CLM | CLM-400553 | 2026-02-17T18:15:52Z | Emily | — | Shaw | 1952-02-06 | UHC-85337-03 | ·N/A | N/A | ·NULL | 1742 Indian School Rd | Nashville·· | TN | 37253 | GRP-3927 | - |
| CLM | CLM-417290 | 2026-02-09T15:24:48Z | Jacob | — | Russell | 3/27/1961 | N/A | null·· | N/A | — | — | — | NULL | - | GRP-6727 | SELECT-EPO |
| CLM | CLM-423851 | 2026-03-17T13:46:19Z | ·MADISON | — | BENNETT | 08/09/87 | UHC-18742-54 | — | — | N/A | 8827 Highland Avenue | Las Vegas | NV | 89113 | — | — |
| CLM | CLM-401546 | 2026-09-30T05:14:42Z | michael | — | clark | 1966-05-02 | UNKNOWN | - | N/A | NULL | 3630 Maple Avenue | Denver | CO | 80232-5562 | GRP-7027 | MEDICARE-ADV-B |
| CLM | CLM-402514 | 2026-03-07T10:12:02Z | Melissa | — | Fuller | 1986-09-12 | uhc-18904-06 | NULL | N/A | melissa.fuller@hotmail.com·· | 9543 Cedar Ln | Houston | TX | 77051 | GRP-0335 | MEDICARE-ADV-B·· |
| CLM | CLM-400615 | 2026-01-02T22:19:27Z | michelle | ·· | payne | 1986-06-24 | UHC-32156-45 | •••-••-5803 | 6979038642 | NULL | - | - | — | - | UNKNOWN | OPTIONS-PPO |
| CLM | CLM-416566 | 2026-10-16T09:00:30Z | JOSE | ·N. | VEGA | 20070823 | UHC-35189-94 | null | - | — | NULL | — | — | ·null | - | CORE-HMO |
| CLM | CLM-420783 | 2026-02-22T22:19:41Z | GARY | — | JENKINS | 1989-05-08 | — | ·N/A | NULL | - | 5509 Palm Dr | Jacksonville | FL | 32273-5807 | ·UNKNOWN | N/A |
| CLM | CLM-401469 | 2026-01-01T12:46:23Z | Jerry | — | Pierce | 2/27/2005 | ·UHC0182746 | •••-••-5762 | (275) 373-5096 | - | 3308 Baseline Rd #173 | Phoenix | AZ | 85020 | GRP-3862 | MEDICARE-ADV-B |
| CLM | CLM-406906 | 2026-05-30T09:54:22Z | LAWRENCE | — | RICE | Nov 12, 1955 | UHC-99232-21 | •••-••-6989 | - | - | - | UNKNOWN | - | null | NULL | SELECT-EPO |
| CLM | CLM-422866 | 2026-08-01T15:40:48Z | ·mary | ·· | morales | 05-07-1952 | UHC-12845-55 | •••-••-3849 | UNKNOWN | — | 2948 CHURCH STREET·· | GLENDALE | AZ | 85330·· | GRP-1368 | MEDICARE-ADV-A |
| CLM | CLM-425309 | 2026-09-14T18:42:21Z | arthur·· | — | carter | 09/20/53 | UHC-46569-38 | — | UNKNOWN·· | ·UNKNOWN | 7582 WASHINGTON STREET | Chandler | AZ | 85272-5318 | GRP-3607 | — |
| CLM | CLM-425676 | 2026-07-09T09:53:12Z | Bryan | — | Ray | 1958-11-20 | UHC1523185 | •••-••-5361 | 18976852507 | ·- | N/A | — | - | — | GRP-3651 | UNKNOWN |
| CLM | CLM-401003 | 2026-02-02T14:11:08Z | ·CHARLES | — | KELLY | 1969-05-21 | — | NULL | null | — | 7308 Park Pl | Charlotte | NC | null | UNKNOWN | - |
| CLM | CLM-432756 | 2026-08-28T10:50:47Z | Adam | W | Wylliamson | 09/07/1957 | UHC-84285-56 | NULL | NULL | null | 6488 Central Ave | Fresno·· | California | 93772 | null | UNKNOWN |
| CLM | CLM-418217 | 2026-05-07T04:02:50Z | JASON | — | MRPHY | 09/21/96 | — | — | — | N/A | 239 Church Street | Nashville | TN | 37253 | ·GRP-0826 | — |
| CLM | CLM-412241 | 2026-03-01T00:15:41Z | ·victoria | O | ross | 1978-06-16 | — | •••-••-9640 | 380.680.5912 | null | 8429 Camelback Road | Dallas | TX | 75251 | UNKNOWN | - |
| CLM | CLM-430279 | 2026-05-25T09:06:34Z | Ruth | — | Baker | 12/09/1971 | UHC-70391-44 | — | 9604275339 | — | 5236 SPRING STREET | Tempe | AZ | 85208 | null | OPTIONS-PPO |
| CLM | CLM-416395 | 2026-05-14T11:43:28Z | jesse | — | george·· | 07/25/1973 | UHC-45885-26 | •••-••-0950 | 5073395219 | - | 2028 River Road | Tempe | Arizona | 85270 | GRP-9006 | CORE-HMO |
| CLM | CLM-422028 | 2026-05-02T02:47:12Z | Cynthia | — | Jenkins | 1996-07-15 | ·UHC-84353-34 | — | — | — | — | - | — | — | UNKNOWN | — |
| CLM | CLM-405120 | 2026-03-25T14:24:00Z | Brenda | ···· | Elliott | 12/23/1951 | UHC-91777-26 | NULL | null | - | 8417 Central Ave #967 | Sacramento | ·CA | 95835 | GRP-0505 | NULL |
| CLM | CLM-430699 | 2026-05-04T18:07:12Z | Alaxander | — | Le | 20051118 | — | •••-••-6400 | — | - | 5252 Lake View Rd #918 | Plano | TX | 75032 | NULL | null |
| CLM | CLM-419355 | 2026-07-24T14:03:58Z | Wei | — | Fuller | 05/22/1956 | N/A | NULL | NULL | WEI.FULLER@HOTMAIL.COM | 1677 WASHINGTON STREET | Scottsdale | AZ | 85231 | GRP-6370 | — |
| CLM | CLM-407625 | 2026-07-11T14:20:36Z | Betty | — | Perkins·· | 1986-12-19 | UHC-63108-91 | UNKNOWN | - | - | 938 CENTRAL AVE·· | DENVER | CO | 80257 | GRP-4025 | SELECT-EPO |
| CLM | CLM-415100 | 2026-04-21T20:22:47Z | Christina | — | Diaz | 1998-11-25 | UHC-22718-61·· | NULL | (885) 550-4775 | N/A | 9396 Meadow Lane | Dallas | TX | ·75272 | N/A | null |
| CLM | CLM-432210 | 2026-05-21T18:01:27Z | Stephanie | E. | Alvarado | 2006-12-17 | - | •••-••-7897 | — | N/A | — | N/A | NULL | null·· | N/A | — |
| CLM | CLM-400441 | 2026-09-26T18:52:32Z | Brndon | — | Alvarado·· | 07/16/1992 | UHC-74312-02 | null | NULL | -·· | 1039 Valley View Dr | Scottsdale | Arizona | 85273 | UNKNOWN | NULL |
| CLM | CLM-407929 | 2026-04-21T15:39:05Z | Bryan | — | Ryan | 1983-01-61 | UHC-05334-68 | N/A | NULL | - | 1607 Desert Sky Boulevard | Sacramento | CA | 95858 | GRP-4234 | — |
| CLM | CLM-418686 | 2026-03-30T07:51:44Z | SAMUEL | — | OLIVER | 1968-03-01 | N/A | - | - | — | 3743 Church St | HOUSTON | ·TX | 77089 | GRP-7258 | N/A |
| CLM | CLM-408455 | 2026-03-09T06:58:00Z | MRAGARET | — | HUNTER | Jan 1, 2005 | ·UHC-03826-60 | •••-••-0049 | (846) 782-7683 | NULL | 2931 Oak Street | Chandler·· | AZ | 85272 | GRP-4899 | OPTIONS-PPO |
| CLM | CLM-408587 | 2026-07-23T17:23:42Z | Gordon, Joshua | D | — | 11/3/1983 | UHC-19807-30 | •••-••-3484 | UNKNOWN | NULL·· | 7170 Willow Ct | Sacramento·· | CA | 95817 | GRP-6728 | NULL |
| CLM | CLM-419466 | 2026-08-23T02:55:33Z | Samuel | — | ·Tucker | 1963-03-27 | UHC-63335-10 | •••-••-5990 | null | NULL | 5075 Spring St·· | Austin | TX | 78787 | GRP-7154 | — |
| CLM | CLM-412774 | 2026-10-14T02:42:20Z | ·Walter | — | Ward | 1961-05-09 | ···· | — | 689-220-5367 | N/A | ·8712 MAIN STREET #960 | Sacramento | CA | 95896 | GRP-5553 | NAVIGATE-HMO |
| CLM | CLM-428539 | 2026-09-10T01:47:20Z | Isabella | — | Murphy | 02/06/1957 | UHC-81397-53 | N/A | 222-647-6767 | — | 1338 CENTRAL AVENUE | Columbus | OH | 43298 | null | N/A |
| CLM | CLM-412081 | 2026-03-08T03:17:51Z | WILLIE | — | PRICE | ·1976-01-15 | uhc-38904-57 | •••-••-5423 | — | - | 2918 Highland Avenue | ·San Diego | CA | 92176 | GRP-4183 | N/A |
| CLM | CLM-417991 | 2026-07-03T11:30:32Z | JACQUELINE | U | BAKER | 20-07-1995 | UHC-58335-95·· | — | UNKNOWN·· | — | 838 Mesa Dr·· | NASHVILLE | ·TN | 37247 | — | CHOICE-PLUS-PPO |
| CLM | CLM-406976 | 2026-04-19T23:45:17Z | Cooper, Emily | — | — | 1987-04-08 | UHC-31685-70 | — | ·· | - | - | ·- | — | N/A | GRP-1494 | MEDICARE-ADV-B |
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:40.598Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty