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-421417 | 2026-03-25T22:18:24Z | Yuki | M | Contreras | ·03/01/1997 | null | ·· | — | N/A | 4549 BROADWAY | Phoenix·· | AZ | 85046·· | ···· | NAVIGATE-HMO |
| CLM | CLM-431912 | 2026-01-10T10:36:22Z | Omar, Meyer | I. | — | 19970426 | UHC-76229-33 | •••-••-0852 | N/A | - | 6245 Market Street #805 | Dallas | TX | 75202 | - | CHOICE-PLUS-PPO |
| CLM | CLM-423145 | 2026-09-20T13:15:04Z | Rebecca | C. | McDonald | 1999-03-21 | UHC-79820-75 | UNKNOWN | 549-814-9132 | rebecca.mcdonald68@proton.me | 5631 SAGE CT | SCOTTSDALE | AZ | 85275 | null | OPTIONS-PPO |
| CLM | CLM-420115 | 2026-08-25T02:31:01Z | roger | C | ·wang | 06/16/1971·· | UHC-11203-29 | •••-••-3927 | 980-684-0763 | ·NULL | 932 Park Place | Denver | Colorado | 80289 | — | N/A |
| CLM | CLM-401367 | 2026-09-13T11:32:44Z | ANGELA | I | ·HAWKINS | 1940-08-24 | N/A | — | — | N/A | 975 LINCOLN WAY | ·Minneapolis | MN | 55432 | null | CHOICE-PLUS-PPO |
| CLM | CLM-421211 | 2026-06-10T17:46:31Z | ·Steven | R | Price | Jan 16, 1939 | UNKNOWN | ·· | — | — | 2043 Grand Avenue | Houston | TX | 77062 | GRP-3400 | OPTIONS-PPO |
| CLM | CLM-405106 | 2026-05-30T11:38:41Z | ·Mary | ·A. | Miller·· | 1961-10-25 | UHC-64703-56 | NULL | NULL | N/A | 870 Market Street | ORLANDO | Florida | 32832 | GRP-5950 | — |
| CLM | CLM-406980 | 2026-06-01T20:46:16Z | Ralph | I | Howell | 12/28/1978 | UHC-98002-75 | — | 13899958949 | N/A | — | - | — | N/A | null | ·NAVIGATE-HMO |
| CLM | CLM-422270 | 2026-06-05T12:41:28Z | Jim | E | Hanson | 1984-11-23 | UNKNOWN | •••-••-2691 | 622.252.8462 | - | 6778 OCEAN AVENUE | Miami | FL | 33117-5125 | — | UNKNOWN |
| CLM | CLM-423181 | 2026-08-27T18:16:20Z | KAREN | V. | CAMPBELL | 1942-01-28 | UHC-16103-42 | •••-••-0701 | 970-641-3040 | - | 729 Hillcrest Rd | Minneapolis | MN | 55454 | GRP-9573 | — |
| CLM | CLM-421305 | 2026-03-02T07:19:47Z | Judy | — | Ruiz | 1995-01-19 | — | •••-••-5993 | 3034128171 | — | — | null | null | - | — | MEDICARE-ADV-A |
| CLM | CLM-428577 | 2026-03-30T11:39:20Z | HAROLD | — | SANDOVAL | 2006-12-28 | UHC-13759-35 | •••-••-0735 | — | - | 3094 Mountain View Dr Apt 8 | Jacksonville | FL | 32288 | GRP-9841 | NULL |
| CLM | CLM-402843 | 2026-09-06T16:57:22Z | Billy | — | Nunez | 01/11/06 | UHC-35702-03 | N/A | (214) 993-3735 | — | ·UNKNOWN | NULL | NULL | NULL | NULL | SELECT-EPO |
| CLM | CLM-424278 | 2026-06-08T17:16:40Z | Jordan | ···· | Rios | 12/20/2000 | uhc-05278-37 | •••-••-8684 | NULL | — | 4186 MARKET STREET | Phoenix | AZ | 85009 | N/A | UNKNOWN |
| CLM | CLM-424470 | 2026-08-05T20:54:50Z | ·RICHARD | — | GUZMAN | 2003-11-26 | — | •••-••-4006 | (494) 739-4209 | — | — | — | — | — | GRP-5811·· | — |
| CLM | CLM-416508 | 2026-03-25T03:28:12Z | Griffin, Andrew | — | — | 07-09-1956 | UHC-72617-99 | — | ·14723649707 | — | 644 Palm Dr Apt 35 | Atlanta | GA | 30388 | GRP-9689 | N/A |
| CLM | CLM-432250 | 2026-04-29T06:11:07Z | CATHERINE·· | — | ROMERO | 1952-02-09 | UNKNOWN | — | N/A | NULL | 9615 Camelback Road | Tempe | Arizona | 85263-3675 | GRP-0840 | — |
| CLM | CLM-420027 | 2026-05-26T17:39:50Z | AUSTIN·· | — | HERNANDEZ | 1991-02-06 | NULL | - | - | — | 4004 BASELINE ROAD | Denver | CO | 80210 | GRP-3087 | CHOICE-PLUS-PPO |
| CLM | CLM-418326 | 2026-05-29T00:53:19Z | Scott | — | Sims | 06-05-1974 | UHC-03945-14 | •••-••-5809 | — | — | — | null | — | — | — | CORE-HMO·· |
| CLM | CLM-414869 | 2026-06-18T17:25:28Z | Dorothy·· | — | ·Hudson | 1988-11-08 | UHC-18183-88 | ···· | — | — | 3077 MEADOW LANE | MINNEAPOLIS | MN | 55437 | N/A | CHOICE-PLUS-PPO |
| CLM | CLM-406692 | 2026-06-04T04:22:59Z | Lauren | M. | Stevens | 1949-11-25 | UHC-56668-55 | — | 377-328-3181 | N/A | - | UNKNOWN | null | — | NULL | — |
| CLM | CLM-406229 | 2026-09-16T01:35:57Z | ·Billy | — | Contreras | ·1984-05-25 | NULL | — | — | N/A | 1811 Valley View Drive·· | MIAMI | ·FL | NULL | GRP-8820 | null |
| CLM | CLM-424090 | 2026-03-22T05:41:50Z | JACK | L | FRANKLIN·· | 1968-02-01 | UHC-20855-62·· | — | 12224380255 | NULL·· | 3069 MOUNTAIN VIEW DRIVE Apt 9 | Tampa | fl | 33640 | UNKNOWN | CORE-HMO |
| CLM | CLM-420745 | 2026-09-10T17:13:47Z | SUSAN | — | VAZQUEZ | 2000-59-06 | UHC-65517-83 | UNKNOWN | - | — | — | N/A | UNKNOWN | UNKNOWN | — | CHOICE-PLUS-PPO |
| CLM | CLM-419926 | 2026-10-18T18:23:17Z | Armstrong, Olivia | — | — | 1995-09-11 | UHC-25797-48 | •••-••-6239 | — | — | — | NULL | ···· | NULL | N/A | N/A |
| CLM | CLM-406638 | 2026-08-21T21:14:17Z | AMY | — | DANIELS | 2007-04-08 | UHC-31366-36 | N/A | 756-802-2992 | - | 1993 MAIN ST | ·SAN ANTONIO | ·TX | NULL | GRP-2637 | — |
| CLM | CLM-413295 | 2026-09-25T06:01:30Z | andrew | H. | montgomery | 19440727 | UHC-31571-55 | •••-••-6986 | ·UNKNOWN | — | 4498 SUNSET BOULEVARD | Columbus | OH | 43296 | - | OPTIONS-PPO |
| CLM | CLM-426016 | 2026-04-16T05:31:41Z | Larson, Albert | — | — | ·19390303 | UHC-99616-93 | UNKNOWN | UNKNOWN | NULL | 197 Park Place | Glendale | Arizona | 85399 | — | null |
| CLM | CLM-427740 | 2026-06-10T21:59:28Z | Grant, Gloria | — | — | 8/13/1952 | ·UHC-18393-21 | •••-••-7198 | 6624198244 | GLORIA.GRANT98@ICLOUD.COM | 6583 Ridge Rd #273 | Las Vegas | NV | 89187 | - | — |
| CLM | CLM-406648 | 2026-03-06T11:01:01Z | Mason | — | Aguilar | 1941-07-11 | UHC-36480-04 | N/A | 7956968359 | mason.aguilar13@outlook.com | 811 RIVER RD | Glendale | az | 85390 | GRP-7959 | MEDICARE-ADV-A |
| CLM | CLM-402928 | 2026-09-21T11:28:20Z | LINDA | — | HENRY | 1982-07-14 | UHC-84983-22 | •••-••-9682 | (411) 268-7226 | — | 7924 Church Street | Tampa | FL | 33607 | — | OPTIONS-PPO |
| CLM | CLM-418388 | 2026-03-09T03:40:35Z | Mary | — | Fuller | 1963-10-05 | UHC-43878-46·· | ·· | 738-679-9935 | - | 6246 Church Street | SACRAMENTO | CA | 95834 | N/A | — |
| CLM | CLM-404977 | 2026-07-01T01:37:42Z | Jack | — | Marshall | 1963-06-13 | UHC-15423-91 | NULL | (430) 269-6871 | — | ·· | — | NULL | ·· | GRP-8836 | — |
| CLM | CLM-428431 | 2026-09-24T22:45:47Z | DOUGLAS | — | KNIGHT | 1967-12-22 | UHC-58513-50 | •••-••-3637 | — | UNKNOWN | 427 Central Avenue | CHANDLER | AZ | N/A | GRP-7855 | null |
| CLM | CLM-431266 | 2026-01-08T04:26:01Z | PRIYA | ·· | FERNANDEZ | 2007-10-11 | - | null | 9449883064 | — | 595 Elm St | Atlanta | ·Georgia | 30305 | GRP-2450 | MEDICARE-ADV-B·· |
| CLM | CLM-431386 | 2026-07-31T20:56:02Z | Kimberly | — | Mills | 07-12-1955 | UHC-05503-20 | ·UNKNOWN | (801) 623-4112 | UNKNOWN | 9137 Main Street | Gilbert | AZ | 85208 | UNKNOWN | ·OPTIONS-PPO |
| CLM | CLM-405122 | 2026-02-10T06:06:14Z | steven | — | ·knight | 2004-04-20 | UHC-60419-18 | •••-••-8170 | -·· | ···· | 8607 Ocean Ave·· | Miami | FL | 33105 | GRP-7911 | — |
| CLM | CLM-431110 | 2026-10-02T15:44:21Z | LAURA | U | CRUZ | Nov 24, 1974 | — | •••-••-0424 | NULL | NULL | 5143 BROADWAY | Sacramento | CA | ·95882 | ·GRP-4092 | - |
| CLM | CLM-424436 | 2026-08-05T22:12:09Z | BRADLEY | — | MORIS | 1956-11-20 | UHC-07576-73 | — | UNKNOWN | — | 4566 SPRING STREET | TUCSON | AZ | 85761 | — | NULL |
| CLM | CLM-405294 | 2026-06-09T17:24:56Z | Camila | T | Snyder | 1993-06-09 | UHC-17020-16 | — | (419) 634-1764 | null | 3515 Willow Ct | Miami | Florida | 33192 | GRP-4228 | MEDICARE-ADV-A |
| CLM | CLM-411175 | 2026-02-23T12:33:13Z | Betty | — | Wheeler | 15-10-2002 | null | •••-••-4613 | null | BETTY.WHEELER@ICLOUD.COM | ·2733 Church Street | Charlotte | NC | 28288 | GRP-6246 | null |
| CLM | CLM-411766 | 2026-03-29T00:07:24Z | Jeffrey | — | Vazquez | 2007-06-12 | — | — | - | — | 2458 Lincoln Way | HOUSTON | TX | 77061 | UNKNOWN | — |
| CLM | CLM-406341 | 2026-09-24T13:24:03Z | frank | — | guzman | ·2006-10-09 | UHC-66444-28 | — | null | — | ·1500 SPRING STREET | Fresno | CA·· | 93723 | — | — |
| CLM | CLM-419800 | 2026-09-08T12:36:51Z | DIANE | — | ·REID | 1954-02-03 | ·· | UNKNOWN | 4824190082 | NULL | 2365 Sage Ct | Houston | TX | 77045 | GRP-7325 | — |
| CLM | CLM-409346 | 2026-01-30T20:25:02Z | ·TIMOTHY | X | WEBER | 2004-08-09 | uhc-38193-02 | - | 8485910817 | null | 2356 Meadow Lane | MINNEAPOLIS | ·MN | - | GRP-7225 | NULL |
| CLM | CLM-427925 | 2026-04-12T15:55:02Z | samuel | — | daniels | 1987-03-17 | UHC-09665-29 | — | N/A | — | 4305 HIGHLAND AVENUE | Mesa·· | AZ | 85290 | UNKNOWN | — |
| CLM | CLM-417418 | 2026-02-18T02:17:25Z | Sean | U | Carpenter | 1954-10-05 | NULL | null | null | - | N/A | - | UNKNOWN | NULL | GRP-5165 | SELECT-EPO |
| CLM | CLM-422183 | 2026-09-24T16:09:48Z | Lewis, Marcus·· | — | — | 1981-05-06 | UHC-53639-04 | •••-••-4452 | 393-982-7389 | null·· | 2066 Main Street·· | ATLANTA | ·GA | 30343 | GRP-0933 | OPTIONS-PPO |
| CLM | CLM-407223 | 2026-03-15T07:07:37Z | Glria | — | Rogers | 1984-03-18 | UHC4532947 | - | — | — | — | UNKNOWN | null | ···· | GRP-2907 | SELECT-EPO |
| CLM | CLM-426962 | 2026-07-26T01:38:39Z | Ana | — | Pyane | 8/3/1942 | UHC7110634 | — | 384-771-3900 | null | - | UNKNOWN | ·null | ·null | GRP-3361 | - |
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.706Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty