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-425080 | 2026-04-26T08:44:00Z | Peter | — | Smith | 1974-03-13 | — | — | +1 927 499 5109 | ·· | 1657 Highland Ave | Fresno | CA·· | ·93778 | GRP-7270 | — |
| CLM | CLM-426130 | 2026-01-03T02:22:52Z | JAMES·· | ·· | ORTIZ | 1940-06-28 | UHC-18976-70 | •••-••-9750 | UNKNOWN | NULL | null | NULL | — | null | — | SELECT-EPO |
| CLM | CLM-431666 | 2026-07-19T22:45:06Z | Luna, Roger | — | — | Oct 11, 1960 | - | — | UNKNOWN | - | ·2436 INDIAN SCHOOL RD | Miami | FL | 33148 | N/A | — |
| CLM | CLM-409530 | 2026-08-09T08:38:53Z | Matthew | — | ·Hanson | 1944-12-11 | UHC-50046-10 | ·· | (292) 760-7482 | N/A | 1870 Spring Street | Glendale | Arizona | 85325 | - | MEDICARE-ADV-B |
| CLM | CLM-416715 | 2026-04-13T06:14:27Z | Donna | ·· | Riley | 1995-08-28 | UHC-34358-22 | •••-••-7509 | NULL | — | — | null | — | ·· | GRP-0338 | NULL |
| CLM | CLM-422755 | 2026-04-18T22:03:39Z | Anderson, Arjun | — | ···· | 1985-07-05 | UHC-56313-59 | N/A | 6009315274 | — | — | UNKNOWN | — | UNKNOWN | GRP-4067 | NULL |
| CLM | CLM-422225 | 2026-06-30T16:53:37Z | Ortega, Patrick | — | — | 2001-07-20 | UHC-45462-68 | •••-••-1613 | 18212622405 | — | 348 Cedar Ln | Atlanta | GA | 30305 | GRP-5629 | null |
| CLM | CLM-415367 | 2026-03-31T07:50:56Z | ·Daniel | T | Warren | 2007-05-06 | — | •••-••-1814 | — | N/A | 6802 Camelback Road·· | Tucson·· | AZ | 85787 | GRP-6268 | NAVIGATE-HMO |
| CLM | CLM-414725 | 2026-02-26T16:10:04Z | ·Benjamin | ···· | Hansen | 19391209 | UHC-98600-37 | NULL | 432-307-7747 | — | 723 LINCOLN WAY | Scottsdale | AZ | 85276-8404 | N/A | — |
| CLM | CLM-430227 | 2026-04-27T22:34:15Z | Aisha | — | Gray | Dec 18, 1983 | — | — | — | N/A | 8462 MAIN STREET | Minneapolis·· | MN | — | NULL | null |
| CLM | CLM-417896 | 2026-01-20T00:22:20Z | Mark | — | Arnold | ·25-10-1983 | UHC-55501-27 | •••-••-7250 | 744-656-3855·· | — | 8580 River Road | Gilbert | AZ | 85227 | — | — |
| CLM | CLM-426714 | 2026-04-28T01:22:05Z | Patricia | — | Hicks | 1984-05-19 | N/A | •••-••-7542 | - | — | ·7193 Main St | Chandler | AZ | 85285 | - | CORE-HMO |
| CLM | CLM-413566 | 2026-04-24T03:00:15Z | kathryn | — | martin | 1972-01-24 | null | ·- | 4135768862 | kathryn.martin@icloud.com | 6768 Valley View Dr | Seattle | WA | 98180 | GRP-6169·· | — |
| CLM | CLM-411505 | 2026-09-09T11:25:59Z | Jordan | — | Bowman | 1977-09-10 | UHC-13738-33 | NULL | (389) 749-1542 | null | 732 Bayshore Dr | Jacksonville | FL | 32291 | GRP-1745 | — |
| CLM | CLM-419463 | 2026-01-19T20:37:03Z | Gerald | A | Rios | 1976-08-18 | UHC-08945-22 | — | (420) 273-1541 | gerald.rios69@outlook.com | 8925 MARKET ST | Mesa | az·· | 85253 | GRP-6514 | ···· |
| CLM | CLM-431141 | 2026-08-29T22:36:50Z | ROGER | — | FRANKLIN | 1974-11-20 | UHC-45290-96 | •••-••-3618 | - | — | ·9628 Willow Ct | Mesa | az | 85206 | GRP-0214 | NAVIGATE-HMO |
| CLM | CLM-426179 | 2026-07-08T03:46:33Z | Jose | — | Hunetr | 2001-02-17 | UNKNOWN·· | •••-••-6254 | UNKNOWN | — | 9111 MAPLE AVE | SEATTLE | WA | 98100 | GRP-5063 | - |
| CLM | CLM-425593 | 2026-03-25T00:11:32Z | sandra | — | davis | 02/20/65 | UNKNOWN | •••-••-0177 | 14305948939 | UNKNOWN | ·680 Maple Avenue | HOUSTON | TX | 77046 | ·GRP-3875 | SELECT-EPO·· |
| CLM | CLM-405239 | 2026-09-03T10:41:51Z | Anthony, Guerrero | W | — | 1993-12-01 | UNKNOWN | — | 617-772-5230 | ·null | — | — | null·· | — | GRP-9452 | NAVIGATE-HMO |
| CLM | CLM-419676 | 2026-07-16T20:47:50Z | Abigail | P | Armstrong | 2006-10-06 | UHC-16262-32 | — | null | ·- | 9469 Apache Boulevard | DALLAS | TX | 75231 | GRP-4799 | SELECT-EPO |
| CLM | CLM-410917 | 2026-01-17T18:43:12Z | TERESA | R | PAYNE·· | Sep 23, 1959 | — | — | 7242527163 | — | 6952 GRAND AVE | DALLAS | TX | 75229 | GRP-9980 | null |
| CLM | CLM-406689 | 2026-07-06T08:56:49Z | CHARLES | — | LARSON | 10/06/03 | UHC-12794-92 | UNKNOWN | 6864622790·· | N/A | 1567 RIVER RD | Austin | TX | 78791 | — | UNKNOWN |
| CLM | CLM-423175 | 2026-05-14T20:04:32Z | Nathan | — | Watkins | 1974-08-06 | UHC-86219-04 | •••-••-5895 | — | null | 2794 Market Street | Minneapolis | mn | 55461 | GRP-2760 | — |
| CLM | CLM-413536 | 2026-05-24T21:47:39Z | ·Bennett, Betty | — | — | 1972-12-08 | uhc-09862-50 | - | null | NULL·· | 1451 MAIN ST | Tampa | FL | 33605 | — | — |
| CLM | CLM-404403 | 2026-05-01T20:41:54Z | Rachel | X | Davis | ·1993-10-04 | UHC-17326-95 | •••-••-1564 | - | UNKNOWN | 4711 River Road | Charlotte | NC | 28247 | UNKNOWN | CORE-HMO |
| CLM | CLM-406492 | 2026-06-26T11:29:28Z | Cheryl | — | Campbell | 19890923 | UHC-77477-89 | UNKNOWN | (657) 479-1634 | - | 3825 Mountain View Dr | Columbus | OH | 43242 | GRP-3912 | UNKNOWN |
| CLM | CLM-407050 | 2026-05-15T05:06:36Z | ·Denise | — | Santos | 1938-08-19 | ·UHC-94172-06 | null | 565-273-4992 | NULL | 8780 Indian School Rd | TAMPA | FL | 33662-3328 | — | ·N/A |
| CLM | CLM-424123 | 2026-06-06T15:41:26Z | MARK | — | ESPINOZA·· | 6/23/1949 | UHC-64946-78 | — | +1 642 868 8761 | — | 6788 OCEAN AVE | Mesa | AZ | 85259 | ·null | — |
| CLM | CLM-420378 | 2026-10-14T15:51:04Z | Sandra·· | — | Reyes | ·1982-05-09 | — | •••-••-3099 | — | SANDRA.REYES@AOL.COM | 2116 OCEAN AVE | LAS VEGAS | NV | 89111 | — | NULL |
| CLM | CLM-400276 | 2026-02-22T21:36:29Z | Alexander | — | Medina | 1962-10-09 | — | — | 7598484612 | NULL | 3388 FOREST AVENUE | ATLANTA | Georgia | 30372 | GRP-3157 | NAVIGATE-HMO |
| CLM | CLM-421718 | 2026-08-03T01:18:38Z | Larry·· | — | Simpson | 1973-01-25 | UHC-81950-28 | •••-••-9850 | ·444.379.1894 | — | 406 Lincoln Way | Charlotte | NC | 28235 | — | select-epo |
| CLM | CLM-410862 | 2026-01-29T18:38:51Z | Rachel | M | Porter | 1945-10-07 | UNKNOWN | - | N/A | — | UNKNOWN | — | N/A | — | — | SELECT-EPO |
| CLM | CLM-429696 | 2026-10-15T09:25:10Z | CHERYL·· | — | CARR | 19860314 | — | — | — | — | 7229 PARK PLACE | San Diego | CA | 92162 | GRP-2783 | N/A |
| CLM | CLM-414172 | 2026-05-07T16:03:06Z | Grace | R. | Collins | 09/08/1988 | ·UHC-78004-18 | — | — | NULL | N/A | N/A | UNKNOWN | N/A | — | — |
| CLM | CLM-410383 | 2026-10-04T03:01:48Z | ·Vincent | — | Smith | 19540827 | UHC-60680-60 | NULL | +1 349 226 1141 | - | 2219 Canyon Road | San Diego | CA | 92184 | null | NAVIGATE-HMO |
| CLM | CLM-419285 | 2026-08-08T01:01:36Z | AMBER | — | MUNOZ | Aug 17, 1984 | null | N/A | UNKNOWN | — | 9780 MAPLE AVE | Chandler | AZ | 85275 | GRP-2481 | N/A |
| CLM | CLM-431822 | 2026-02-05T02:23:25Z | Jesisca | — | Henderson | 19950523 | — | — | (637) 797-0541 | JESSICA.HENDERSON22@YAHOO.COM | — | UNKNOWN | NULL·· | — | NULL | NULL |
| CLM | CLM-421032 | 2026-06-14T12:13:14Z | Bradley | — | Lane | 1/6/1938 | UHC-88564-99 | N/A | — | bradley.lane@aol.com | 9269 VALLEY VIEW DRIVE | Sacramento | CA | ·95818 | GRP-9510 | MEDICARE-ADV-A |
| CLM | CLM-419235 | 2026-04-06T08:40:49Z | Elizabeth | — | Dunn | 2007-08-01 | - | ·null | 726-703-7336 | UNKNOWN | 9639 BAYSHORE DR | Austin | TX | — | GRP-2056 | N/A |
| CLM | CLM-423051 | 2026-08-13T20:35:07Z | Ralph | — | Washington | 1977-07-06 | ·NULL | — | 450.891.3008 | null | 3498 Meadow Lane | Plano | ·TX | 75077 | GRP-5453 | - |
| CLM | CLM-415973 | 2026-09-06T16:04:50Z | Bishop, Christina | — | — | 1975-04-27 | N/A | -·· | — | christina.bishop@aol.com·· | 2857 Bayshore Dr | PHOENIX | AZ | 85009 | GRP-8274 | ·N/A |
| CLM | CLM-407837 | 2026-03-06T01:03:27Z | AHMED | — | VEGA | May 16, 1991 | UHC-71140-57 | — | (391) 433-2193 | null | — | — | N/A | ···· | GRP-5712 | null |
| CLM | CLM-431205 | 2026-05-02T15:34:02Z | Bradley | L | Jons | 1962-03-17·· | UHC-59050-84 | •••-••-6636 | 747-572-1260 | N/A | - | ·UNKNOWN | — | UNKNOWN | UNKNOWN | N/A |
| CLM | CLM-413444 | 2026-07-05T12:19:43Z | amber | — | murphy | 03/06/1987 | UHC-67086-87·· | — | 9599301050 | UNKNOWN | null | - | NULL | UNKNOWN | — | — |
| CLM | CLM-405446 | 2026-03-04T14:30:32Z | cheryl | M | hill | 1949-12-23 | N/A | - | +1 795 988 3143 | — | 3321 Mountain View Dr | CHANDLER | AZ | 85213-7023 | GRP-2743 | SELECT-EPO |
| CLM | CLM-402525 | 2026-07-08T07:04:37Z | DENNIS | — | LOPEZ | 19261007 | uhc-83888-95·· | — | — | - | — | null | - | N/A | — | null |
| CLM | CLM-404091 | 2026-03-26T03:05:52Z | Amanad | — | Rojas | ·05/15/1980 | UHC-37438-87 | •••-••-5692 | 9422130658 | amanda.rojas@gmail.com | - | — | UNKNOWN | null | GRP-7791 | — |
| CLM | CLM-419125 | 2026-02-20T05:31:45Z | Harold | — | Marquez | 02/02/1987 | ·UHC-77141-58 | •••-••-5402 | 19349833759·· | HAROLD.MARQUEZ21@YAHOO.COM | 7215 Highland Avenue | CHARLOTTE | NC | - | - | NULL |
| CLM | CLM-425939 | 2026-03-29T14:05:10Z | GRACE | — | WONG | 21-10-1974 | UHC-64071-61 | •••-••-7243 | 895.358.0520·· | - | — | — | null | N/A | — | NAVIGATE-HMO |
| CLM | CLM-422534 | 2026-06-19T03:25:28Z | STEVEN | — | WATKINS·· | 1956-06-02 | UHC-18796-43 | ·· | 507-994-0693 | N/A | N/A | - | — | N/A | GRP-9669 | SELECT-EPO |
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:37.767Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty