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-405598 | 2026-07-11T01:35:45Z | Herrera, Mason | P | — | 1943-02-05 | - | NULL | 542-419-6196 | — | 182 Willow Ct | Charlotte | NC | ·28299 | - | MEDICARE-ADV-A |
| CLM | CLM-428897 | 2026-04-01T20:33:21Z | Brittany | T·· | Griffin | 1967-12-24 | N/A | •••-••-2935 | (536) 986-4995 | - | 8300 Mountain View Drive | San Antonio | TX | 78229·· | GRP-1377 | ·SELECT-EPO |
| CLM | CLM-412964 | 2026-02-20T23:57:41Z | Susan·· | — | George | 04/05/89 | UHC-79821-24 | UNKNOWN | null | — | — | - | — | null | - | — |
| CLM | CLM-422429 | 2026-06-24T02:33:42Z | aaron | — | vasquez | 1975-02-23 | UHC-95883-06 | - | — | — | 9380 BROADWAY | Houston | TX | 77046 | — | CORE-HMO |
| CLM | CLM-408006 | 2026-08-23T02:04:14Z | YUKI | — | DOMINGUEZ | 09/13/1982 | UHC-20110-23 | — | +1 573 355 2265 | — | — | N/A | NULL | — | GRP-7204 | MEDICARE-ADV-A |
| CLM | CLM-431861 | 2026-05-22T15:23:42Z | LAWRENCE | U. | SCCOTT | 1993-10-27 | UHC-71983-42 | null | (317) 652-3314 | — | 9111 Pine Drive | Chandler | AZ | 85293 | NULL | - |
| CLM | CLM-414575 | 2026-06-14T13:40:03Z | DOALD | M. | LUNA | 19710126 | UHC-91905-46 | •••-••-4325 | — | — | 9766 Washington Street | San Diego | CA | 92137 | GRP-1256 | ·select-epo |
| CLM | CLM-421506 | 2026-10-06T07:43:54Z | Martha | — | Griffin | 1962-01-22 | UHC2703207 | •••-••-9679 | 761-693-3850 | MARTHA.GRIFFIN76@YAHOO.COM | 3725 Main St | Mesa·· | Arizona | 85276 | - | N/A |
| CLM | CLM-416861 | 2026-06-03T23:40:03Z | David | — | Chapman | 1956-09-28 | N/A | — | — | UNKNOWN | 7079 Willow Ct Apt 21 | Jacksonville | FL | 32213·· | GRP-8693 | null |
| CLM | CLM-413180 | 2026-09-08T22:17:51Z | ROGER | — | GIBZON | 1942-12-06 | — | - | 524-660-5111 | - | 2278 CANYON RD | San Diego·· | CA | 92154 | GRP-7954 | — |
| CLM | CLM-422018 | 2026-04-13T18:38:09Z | GERALD | — | BANKS | 8/10/1965 | UHC-01357-83 | •••-••-4714 | 7794184203 | null | ·4255 Canyon Rd | LOS ANGELES | CA | 90034 | GRP-6821 | UNKNOWN |
| CLM | CLM-404082 | 2026-06-26T03:25:28Z | ANA | X. | FULLER | Oct 18, 1978 | N/A | — | UNKNOWN | ·ANA.FULLER18@GMAIL.COM | 9872 Spring Street | Phoenix | AZ | 85042-3519 | GRP-8602 | NULL |
| CLM | CLM-428167 | 2026-07-06T08:41:36Z | KEVIN | — | MATTHEWS | 1965-08-15 | UHC-84075-27 | NULL | - | ·NULL | N/A | NULL | — | UNKNOWN | null | ·· |
| CLM | CLM-430824 | 2026-05-05T00:39:08Z | RANDY | — | WRIGHT | 1947-08-15 | UHC-97517-01 | •••-••-6795 | 890-204-5648 | — | UNKNOWN | ···· | UNKNOWN | — | NULL | — |
| CLM | CLM-425991 | 2026-10-11T15:36:50Z | Clark, Carl | — | — | 1964-10-03 | UHC-07708-62 | null | 8020594 | — | N/A | — | N/A | - | GRP-0551 | OPTIONS-PPO |
| CLM | CLM-416180 | 2026-01-15T18:06:59Z | thomas | — | lawrence | 0180-19-64 | N/A | •••-••-0541 | null | N/A | ·5476 MOUNTAIN VIEW DRIVE #876 | Charlotte | NC | 28276 | GRP-5752 | null |
| CLM | CLM-420609 | 2026-04-07T16:16:57Z | Alice | — | Mendoza | 07/01/1973 | UHC-85886-84 | — | (316) 378-5373 | NULL | 7492 LAKE VIEW RD | Phoenix | AZ | 85041 | — | UNKNOWN |
| CLM | CLM-430392 | 2026-02-04T01:11:03Z | Kelly | — | Diaz | 8/11/1996 | UHC-26056-23 | null·· | 241-691-7221 | null | N/A | NULL | — | — | GRP-1589 | MEDICARE-ADV-A |
| CLM | CLM-422633 | 2026-03-27T15:01:36Z | Hudson, Heather | — | — | ·1938-03-05 | UHC-13473-34 | — | 9293965350 | — | ·359 Jefferson Ave | Fresno | CA | 93771 | GRP-3181 | CHOICE-PLUS-PPO |
| CLM | CLM-412619 | 2026-08-20T21:11:55Z | Justin | B | Torres | 1963-06-01·· | UHC5431947 | UNKNOWN | N/A | UNKNOWN | 866 Sage Ct | Minneapolis | MN | 55487 | null | — |
| CLM | CLM-405197 | 2026-02-21T23:48:09Z | victoria | ·· | mccoy | 1998-05-22 | UHC-62971-33 | — | (701) 845-5061 | — | 8234 OAK STREET | SEATTLE | Washington | 98100 | ·NULL | null |
| CLM | CLM-410014 | 2026-08-07T03:01:17Z | LANE | — | ARTHUR | 1971-08-10 | UHC6074808 | ·- | (201) 221-9236 | UNKNOWN | ·7691 Elm Street | Fresno | CA | 93720 | UNKNOWN | — |
| CLM | CLM-401439 | 2026-06-23T22:30:55Z | ·BRUCE | — | CHAVEZ | 8/25/1940 | UHC-59211-88 | •••-••-3355 | 482-328-6893 | UNKNOWN | null | NULL | — | null | GRP-3955 | NULL |
| CLM | CLM-409910 | 2026-10-17T06:02:26Z | Jordan | O | Fowler | 7/25/1992 | — | NULL | 432-510-3303 | — | — | - | - | — | GRP-2959 | null |
| CLM | CLM-431741 | 2026-06-10T23:58:23Z | Linda | — | White | 03/14/1948 | UHC0045447 | N/A | — | — | ·NULL | — | — | — | — | N/A |
| CLM | CLM-401532 | 2026-01-01T07:51:08Z | Keith | L | Ford | 12/04/1979 | UHC-86520-46 | NULL | - | null | 3256 Meadow Lane | Atlanta | GA | 30389 | GRP-9399 | null |
| CLM | CLM-427859 | 2026-06-17T01:18:26Z | Bradley | ···· | Hernandez | 1998-05-27 | null | NULL·· | (860) 399-2759 | null | — | NULL | NULL | — | GRP-9596 | - |
| CLM | CLM-424939 | 2026-02-08T20:02:41Z | DIANE | — | FLORES | 1957-03-20 | — | UNKNOWN | 967-928-1052 | NULL | - | - | — | UNKNOWN | — | NAVIGATE-HMO |
| CLM | CLM-431360 | 2026-10-15T14:59:48Z | Kimberly | — | Delgado | ·1961-12-14 | UHC-27985-96 | •••-••-5573 | N/A | — | 5493 River Road | Dallas | ·TX | ·75247 | GRP-5722 | null |
| CLM | CLM-416076 | 2026-07-09T10:27:33Z | Jordan | — | Lee | 1969-03-03 | ·UHC-83908-16 | •••-••-9129 | (440) 404-4747 | UNKNOWN | 3342 GRAND AVENUE | Los Angeles | CA | 90009·· | — | — |
| CLM | CLM-416325 | 2026-06-12T04:09:46Z | Deborah | W. | Maldonado | 1950-84-28 | UHC-25667-87 | — | — | deborah.maldonado@hotmail.com | 904 Canyon Road | Fresno | CA | 93786 | — | MEDICARE-ADV-B |
| CLM | CLM-413209 | 2026-09-06T03:08:23Z | Jordan | ·· | Walsh | 5/11/1982 | UHC-64695-37 | •••-••-0038 | null | — | 8634 CHURCH STREET | San Diego | CA | 92132 | GRP-7001·· | - |
| CLM | CLM-429822 | 2026-03-08T02:22:21Z | ETHAN | — | MUNOZ | 1976-07-13 | UHC-06062-99 | N/A | N/A | UNKNOWN·· | 866 HARBOR BOULEVARD Apt 28 | Tucson | Arizona | ·85743 | UNKNOWN | - |
| CLM | CLM-405167 | 2026-01-11T16:54:05Z | Richard | — | Hudson | 1974-01-08 | null | UNKNOWN | - | — | 7415 Sage Ct | Seattle | WA | 98183 | GRP-5109 | NULL |
| CLM | CLM-403942 | 2026-03-13T13:20:53Z | SANDRA | — | SALAZAR | 3/5/2007 | UHC-10794-72 | — | UNKNOWN | — | - | - | N/A | ·· | N/A·· | ·SELECT-EPO |
| CLM | CLM-410669 | 2026-10-07T17:41:53Z | Hernandez | ···· | Ken | 1978-11-12 | UHC8607065 | •••-••-0663 | — | — | 4079 Valley View Dr | Glendale | AZ | — | GRP-7822 | CHOICE-PLUS-PPO |
| CLM | CLM-400675 | 2026-05-31T20:55:20Z | hannah | — | rice | N/A | UHC8407838 | — | NULL | — | — | — | - | UNKNOWN | GRP-0642 | — |
| CLM | CLM-429459 | 2026-06-20T04:36:37Z | Jacobs, Timothy·· | U | — | Aug 19, 1944 | UHC-20013-02 | N/A | 483.553.6919 | N/A | 2140 Palm Drive | Gilbert | AZ | 85240 | GRP-8457·· | null |
| CLM | CLM-401710 | 2026-03-21T03:13:24Z | Betty | — | Young | 1987-10-28 | ·UHC-02259-50 | - | 17782485860 | — | 8656 SUNSET BOULEVARD | PHOENIX | AZ | ·85071 | - | UNKNOWN |
| CLM | CLM-424076 | 2026-08-03T14:53:36Z | roger | — | bowman | 2000-11-08 | - | - | N/A | ···· | 2923 Park Pl | Jacksonville | FL·· | 32241 | GRP-2220 | CHOICE-PLUS-PPO |
| CLM | CLM-411535 | 2026-10-11T15:02:50Z | KENNETH | — | SANTOS | 1944-04-09 | null | null | NULL | NULL | 8325 Forest Ave | Atlanta | GA | 30393 | GRP-8823 | MEDICARE-ADV-B |
| CLM | CLM-426056 | 2026-01-09T23:11:52Z | Perez, Ruh | — | — | 2002-04-14 | — | •••-••-1921 | 14504778897 | — | 8217 Pine Drive·· | Glendale | AZ | 85377 | — | SELECT-EPO |
| CLM | CLM-415958 | 2026-08-06T01:32:31Z | Joan | T. | Lee | 08/13/1994 | UNKNOWN | UNKNOWN | — | NULL | 4173 Apache Boulevard | Jacksonville | Florida | 32226 | null | UNKNOWN |
| CLM | CLM-402482 | 2026-05-25T19:40:28Z | Jackie | — | ·Reyes | 19920622 | — | •••-••-9639 | NULL | UNKNOWN | UNKNOWN | N/A·· | — | — | — | N/A |
| CLM | CLM-403414 | 2026-02-10T07:43:07Z | SAMANTHA | — | PATEL | 12/28/1991 | UHC-66383-92 | null | 9774584774 | null | — | N/A | null·· | — | GRP-4502 | - |
| CLM | CLM-420087 | 2026-01-25T13:14:57Z | Betty | — | Vega | 04/04/46 | UHC-40806-34 | ·UNKNOWN | (293) 753-9021 | betty.vega91@gmail.com | 1690 Bayshore Drive | Columbus | OH | 43248 | GRP-7064 | null |
| CLM | CLM-428012 | 2026-10-06T18:10:22Z | JUSTIN | — | PERKINS | 1938-11-26 | UHC-33199-49 | NULL | ·N/A | null | 4991 Valley View Dr | Orlando | fl | 32832 | GRP-6095 | — |
| CLM | CLM-406232 | 2026-03-11T21:08:37Z | Vicky | — | Schmidt | 1988-06-12 | N/A | — | (537) 762-7244 | — | — | UNKNOWN | ···· | UNKNOWN | — | ·MEDICARE-ADV-A |
| CLM | CLM-406156 | 2026-02-19T08:33:12Z | STEPHENS | — | KATHERINE | 1941-00-95 | UHC-94512-44 | •••-••-8919 | 17707153349 | NULL | 2233 PINE DR | SCOTTSDALE | AZ | 85283 | NULL | SELECT-EPO |
| CLM | CLM-410822 | 2026-09-29T03:52:01Z | Hudson, Teresa | ·· | — | 1994-02-61 | ·- | - | — | — | 7336 Mountain View Dr | Nashville·· | TN | 37259 | — | UNKNOWN |
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.729Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty