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-415219 | 2026-07-01T14:14:06Z | Lawrence | — | Rice | 11/14/1963 | UHC-04124-95 | •••-••-4439 | UNKNOWN | N/A | UNKNOWN | — | N/A | null·· | GRP-1729 | null |
| CLM | CLM-423771 | 2026-06-03T20:25:23Z | CHRISTIAN | — | SPENCER | 1974-07-25 | UHC-07631-84 | •••-••-7081 | NULL | N/A | ·9861 Valley View Dr | Houston | TX | ·77090 | GRP-1973 | — |
| CLM | CLM-408004 | 2026-04-20T05:15:42Z | DANIEL | — | WHEELER | 08/16/1995 | UHC-50459-31 | N/A | (477) 365-9766 | — | 7175 HIGHLAND AVE | Denver | CO | 80263 | — | CORE-HMO |
| CLM | CLM-428086 | 2026-04-15T23:19:51Z | ARTHUR | — | KELLEY | 04/25/88 | UHC-28863-81 | UNKNOWN | 14378213411 | null | 4444 SPRING ST | Tempe | AZ | 85216 | — | UNKNOWN |
| CLM | CLM-426954 | 2026-07-17T23:04:20Z | Gerald | — | Dean | 1964-08-14 | ···· | ···· | ·· | — | UNKNOWN | N/A | UNKNOWN | — | GRP-0689 | NULL |
| CLM | CLM-415297 | 2026-05-09T12:26:16Z | fatima | — | ·myers | 1948-02-05·· | UHC-02930-28 | ·· | N/A | NULL·· | 422 Bayshore Drive | Gilbert | AZ·· | 85235 | GRP-8726 | ···· |
| CLM | CLM-405805 | 2026-01-17T07:29:05Z | ·Wilson, Smuel | — | — | 2003-40-10 | UHC-53403-90 | •••-••-3185 | N/A | samuel.wilson47@outlook.com | - | — | - | NULL | GRP-6879 | null |
| CLM | CLM-417768 | 2026-10-16T21:32:39Z | Susan | — | Burns | Apr 10, 2000·· | — | •••-••-6503 | null | NULL | 6673 Cedar Ln | Tampa | ·Florida | 33655 | GRP-3225 | UNKNOWN |
| CLM | CLM-404584 | 2026-06-12T16:32:24Z | RICHARD | — | ROIS | 2/23/1992 | UHC-20691-71 | ·· | 5839168503 | - | 9572 Park Pl | GLENDALE | AZ | ·85330 | GRP-5810 | ·· |
| CLM | CLM-417310 | 2026-04-13T10:41:24Z | Linda | — | Gray | ·1944-09-06 | UHC-13908-56 | •••-••-5243 | — | — | 8805 Ridge Road | HOUSTON | ·TX | — | GRP-2419 | - |
| CLM | CLM-430432 | 2026-06-09T07:42:29Z | JOAN | — | MEDINA | 02/10/1968 | - | •••-••-8635 | UNKNOWN·· | NULL | 4462 Oak St | Orlando | FL | 32890 | GRP-1695 | NULL |
| CLM | CLM-416065 | 2026-01-09T20:04:43Z | Myers, Ralph | — | — | Apr 5, 1966 | — | ·UNKNOWN | 14093983582 | — | 3366 Hillcrest Road Apt 38 | Glendale | AZ | null·· | — | SELECT-EPO |
| CLM | CLM-407520 | 2026-06-07T22:52:27Z | Grant, Patricia | — | — | 1978-09-07 | ·- | - | 7485931064·· | — | 6500 RIDGE ROAD Apt 27 | Miami | FL | 33172 | GRP-6546 | OPTIONS-PPO |
| CLM | CLM-415350 | 2026-05-20T01:12:32Z | ·Margaret | — | OBrien | 1996-11-16 | UHC-43459-75 | - | — | ·null | UNKNOWN | N/A | ·NULL | - | GRP-8513 | null |
| CLM | CLM-403435 | 2026-04-22T00:03:28Z | RYAN | ·· | PATEL | 2008-04-15 | — | NULL | NULL | RYAN.PATEL@YAHOO.COM | 2016 PINE DRIVE | SAN ANTONIO | Texas | 78270 | GRP-3701 | - |
| CLM | CLM-421771 | 2026-01-08T18:08:44Z | JOSE | — | PEREZ | 19800425 | UHC-94809-39 | •••-••-7105 | (626) 556-7316 | ·N/A | — | null | UNKNOWN | ···· | GRP-6901 | N/A |
| CLM | CLM-424572 | 2026-01-01T18:03:49Z | Gary | — | Knight | 02-09-1974 | UHC-98151-65 | null | — | NULL | — | — | — | N/A | UNKNOWN | MEDICARE-ADV-B·· |
| CLM | CLM-425915 | 2026-07-31T15:23:47Z | Ruth | — | Ross | 04/21/70 | N/A | - | UNKNOWN | ·NULL | 3071 Canyon Road | Phoenix | AZ | 85096 | GRP-5355 | CORE-HMO |
| CLM | CLM-412589 | 2026-03-02T23:28:35Z | Ross, Jesse | — | — | 07/10/40 | UHC-10623-58 | NULL·· | UNKNOWN | jesse.ross81@proton.me | — | null | -·· | null | — | SELECT-EPO |
| CLM | CLM-407151 | 2026-01-21T18:25:30Z | Hannah | — | Rose | 19691116 | — | — | +1 246 535 5809 | NULL | 3727 Sunset Blvd | Denver | CO | — | GRP-0531 | — |
| CLM | CLM-421797 | 2026-07-29T02:12:51Z | ·Kathleen | — | ·Tran | 1975-04-20 | UHC-59783-86 | •••-••-4885 | 13623599237 | - | 4373 Central Avenue | MIAMI | FL | 33166 | GRP-3439 | null |
| CLM | CLM-416509 | 2026-02-14T12:43:12Z | Roy | — | Watson | 1990-06-04 | — | — | 523.827.1614 | — | 9508 Park Pl | Scottsdale | AZ | 85285 | GRP-3749 | choice-plus-ppo |
| CLM | CLM-410348 | 2026-02-22T19:49:01Z | Diana | — | Mills | 1941-03-15 | UNKNOWN | null | (971) 519-3934 | DIANA.MILLS@YAHOO.COM | 3531 Market Street | Austin | TX | 78771 | GRP-8540 | NAVIGATE-HMO |
| CLM | CLM-425315 | 2026-07-15T19:49:02Z | Ralph | P.·· | Henderson | 1/1/1993 | UNKNOWN | — | 254-794-1469 | — | - | - | NULL | null | GRP-2556 | UNKNOWN |
| CLM | CLM-418341 | 2026-05-05T21:04:16Z | Douglas | H. | Gomez | 1989-08-20 | UHC-25187-47 | •••-••-4667 | — | douglas.gomez@aol.com | — | - | ·N/A | — | ·GRP-3986 | ···· |
| CLM | CLM-416107 | 2026-10-05T05:47:40Z | Raymnd | — | Duncan | 06/13/1986 | UHC-84562-95 | NULL | 2309328749 | NULL | — | — | — | - | GRP-5757 | — |
| CLM | CLM-401865 | 2026-05-28T08:45:38Z | GARY | — | ·WALKER | 1999-02-04 | null | ···· | 785-304-5209 | null | 6703 Cedar Lane | ·San Diego | CA | 92189·· | NULL | — |
| CLM | CLM-406896 | 2026-04-15T04:41:16Z | ·Patrick | V. | Cunningham | 1958-10-14 | UHC-50542-14 | UNKNOWN | 211-813-6467 | — | 2632 Canyon Rd | Tucson | AZ·· | 85739 | GRP-3762 | CORE-HMO |
| CLM | CLM-410387 | 2026-08-29T04:02:05Z | Jeeremy | — | Cook | 1948-08-19 | UHC-20902-98 | null | 5055715690·· | - | 7234 Indian School Rd | Columbus | OH | 43239-7557 | ·GRP-7088 | CORE-HMO |
| CLM | CLM-427167 | 2026-07-31T05:35:00Z | JOHN·· | — | — | 1969-04-10 | ·UHC-98605-67 | - | — | — | null | NULL | N/A | - | GRP-0627 | — |
| CLM | CLM-420089 | 2026-10-09T20:55:41Z | Albert | — | Wells | 1942-06-27 | UHC-36051-25 | •••-••-6845 | null | ALBERT.WELLS5@OUTLOOK.COM·· | 5848 Market St | Phoenix | AZ | 85039 | GRP-9218 | NULL |
| CLM | CLM-419111 | 2026-10-10T10:15:43Z | Jackie | — | Nelson | 1956-08-17 | N/A | - | null | null | 9235 JEFFERSON AVENUE | LOS ANGELES | CA | 90026 | - | N/A |
| CLM | CLM-412930 | 2026-03-24T02:04:45Z | Price, Nicholas | — | — | 19420903 | UHC-89676-44 | null·· | 826.686.8530 | NICHOLAS.PRICE44@ICLOUD.COM | 5158 BASELINE RD | Fresno | CA | 93794 | NULL | SELECT-EPO |
| CLM | CLM-426803 | 2026-03-09T19:52:47Z | Hannah | — | Chavez | 1968-07-28 | UHC-39743-86 | null | 691.367.4694 | hannah.chavez@hotmail.com | 2210 PARK PL | Glendale | AZ | null | N/A | MEDICARE-ADV-A·· |
| CLM | CLM-423073 | 2026-03-08T19:18:06Z | Shirley | E. | OBrien | 1969-06-05 | — | •••-••-7881 | ·4902453616 | - | 5922 Maple Avenue | Sacramento | CA | 95838 | GRP-4111 | — |
| CLM | CLM-421949 | 2026-07-08T07:05:39Z | Philip | O | Tucker | 1951-04-02 | uhc-10045-77 | null | NULL·· | - | 8795 Spring St | GLENDALE | AZ | 85359 | GRP-0141 | — |
| CLM | CLM-419398 | 2026-04-12T08:26:46Z | doris | — | fernandez | ·2003-02-04 | UNKNOWN | - | 2485091224 | — | 5596 BAYSHORE DR | Jacksonville | FL | 32268 | GRP-9789 | SELECT-EPO |
| CLM | CLM-430532 | 2026-09-22T05:10:40Z | Philip | — | Stephens | 1940-02-17 | UHC-52177-38 | •••-••-8619 | (521) 826-1425 | — | 145 Cedar Ln | Dallas | TX | ·75271 | GRP-8564 | CORE-HMO |
| CLM | CLM-403959 | 2026-09-02T05:04:24Z | Donald | — | Bishop | Jan 26, 1944 | UHC-63974-50 | •••-••-7547 | 14717731791 | - | 9402 Maple Ave | Charlotte | ·NC | 28262-2108 | UNKNOWN | ·NAVIGATE-HMO |
| CLM | CLM-417671 | 2026-02-28T08:15:54Z | ARJUN | — | GRAHAM | 1969-03-08 | UHC-79356-55 | •••-••-5884 | — | NULL | 5507 Maple Ave | Las Vegas | NV | 89194 | GRP-3458 | null |
| CLM | CLM-428682 | 2026-05-02T09:30:27Z | Gary | K | Perkins | ·01/03/1960 | UHC-08811-48 | •••-••-9408 | - | UNKNOWN | NULL | null | UNKNOWN·· | N/A | GRP-1277 | SELECT-EPO |
| CLM | CLM-410142 | 2026-03-17T04:49:03Z | William | — | Contreras | ·04/08/2002 | null·· | - | — | N/A·· | 3013 Grand Avenue | Seattle | WA | 98116 | GRP-8277 | ···· |
| CLM | CLM-428090 | 2026-08-24T02:07:19Z | John | — | Santiago | 19761227 | UHC-15864-97 | UNKNOWN | (779) 606-7011·· | — | 535 Canyon Rd | Glendale | AZ | 85361 | — | CORE-HMO |
| CLM | CLM-427139 | 2026-04-23T13:26:13Z | Julia | E | Brown | 1989-05-17 | UHC-01468-21 | •••-••-6352 | 950-230-3813 | UNKNOWN·· | 8084 MAIN STREET | Sacramento | California | 95885 | null | — |
| CLM | CLM-400867 | 2026-04-03T02:06:23Z | Zachary | — | Geoge | ·1999-07-23 | UHC9969566 | null | 938.999.9112 | - | 6658 CENTRAL AVENUE | FRESNO | ·CA | 93763 | GRP-1841 | — |
| CLM | CLM-431639 | 2026-08-05T14:45:43Z | ·sufia | H | scott | 1969-07-19 | UHC-21371-17 | N/A·· | 4706346089 | N/A | — | UNKNOWN | N/A | NULL | UNKNOWN | NULL |
| CLM | CLM-407975 | 2026-08-04T15:12:43Z | Alexander | — | Welch | 1966-08-18 | UHC-73387-38 | •••-••-2686 | 223-626-2604 | ···· | 5665 Lake View Road | FRESNO | CA | 93759 | GRP-2344 | MEDICARE-ADV-A·· |
| CLM | CLM-423782 | 2026-09-02T13:08:24Z | SAM | — | ANDREWS | 2009-11-08 | — | ·· | UNKNOWN | N/A | 7446 WASHINGTON ST | Las Vegas | Nevada | 89129 | GRP-9393 | — |
| CLM | CLM-414616 | 2026-06-11T02:01:52Z | Alexander | — | Vasquez | 1951-09-23 | UHC-55510-39 | •••-••-6028 | (797) 362-5493 | null | 9766 CENTRAL AVENUE | Gilbert | AZ | 85284 | GRP-4398 | OPTIONS-PPO |
| CLM | CLM-416034 | 2026-03-11T14:43:52Z | MATEO | A | CHEN | 1988-05-15 | null | •••-••-1039 | 3164790384 | NULL | — | - | — | - | GRP-2012 | 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:36.679Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty