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-406235 | 2026-02-04T20:34:13Z | VICTORIA | — | SCHMIDT·· | 06/12/1988 | — | •••-••-4488 | (537) 762-7244 | NULL | ·4939 CHURCH STREET | Gilbert·· | AZ | 85276 | GRP-5352 | MEDICARE-ADV-A |
| CLM | CLM-424394 | 2026-07-09T10:10:23Z | ·Mariana | — | Stewart | May 9, 1984 | UHC-55215-31 | N/A | — | - | 4958 INDIAN SCHOOL ROAD | Houston | TX·· | 77056-9345 | GRP-3115 | null |
| CLM | CLM-412072 | 2026-09-30T14:55:28Z | Kevin | Z. | Mejia | 1989-03-13 | UHC-05080-57 | - | 8749023962 | ·· | 6452 RIDGE ROAD | ·Minneapolis | MN | 55486-3858 | GRP-4341 | UNKNOWN |
| CLM | CLM-420209 | 2026-05-17T22:39:02Z | Ben | ···· | Boyd | 02/06/1939 | — | •••-••-7150 | NULL·· | UNKNOWN | 8631 Sage Ct | JACKSONVILLE·· | FL | 32269 | GRP-0481 | UNKNOWN |
| CLM | CLM-421501 | 2026-09-13T13:37:06Z | JAMES | — | RUIZ | 1964-01-24 | UNKNOWN·· | •••-••-4279 | — | james.ruiz66@yahoo.com·· | 7819 Spring St | Jacksonville | FL | 32203 | GRP-5889 | ·· |
| CLM | CLM-422996 | 2026-08-18T09:26:17Z | PAT | — | MARSHALL | 19810608 | UHC-92316-19 | NULL | (612) 442-8236 | ·N/A | 7133 Cedar Lane | Houston | TX | 77072 | - | - |
| CLM | CLM-408547 | 2026-01-21T10:58:04Z | Donna | — | Castro | 11/21/1939 | UHC-02435-42 | null | — | — | NULL | ·· | NULL | NULL·· | — | — |
| CLM | CLM-406374 | 2026-07-14T14:12:32Z | Virginia | — | Graham | ·1943-12-05 | UHC-43956-72 | •••-••-5982 | 274-620-9937 | — | 4639 Palm Dr | San Diego | CA·· | 92193 | N/A | NULL |
| CLM | CLM-413043 | 2026-04-15T18:43:02Z | Kelly | — | Little | 2008-11-24 | uhc-49705-38 | NULL | — | null | 1047 PALM DR | Austin | TX | 78762-6822 | GRP-9329 | MEDICARE-ADV-B |
| CLM | CLM-431652 | 2026-03-18T16:43:45Z | Simmons, Valentina·· | — | — | ·1940-12-10 | UHC-46999-92 | — | 8141007·· | ···· | 5097 Desert Sky Blvd | Tucson | AZ | ·85750 | GRP-1836 | — |
| CLM | CLM-405849 | 2026-03-15T07:17:45Z | Coleman, Willie | Y | — | NULL | UHC-87140-40 | — | (329) 936-3193 | null | 1964 LAKE VIEW RD | ·Scottsdale | Arizona | 85261 | GRP-9072 | MEDICARE-ADV-B |
| CLM | CLM-423012 | 2026-05-21T20:49:31Z | Hiroshi | R | ·Peterson | 1968-09-04 | UHC6115902 | •••-••-6809 | - | — | 2708 OAK STREET | Miami | Florida | 33131 | GRP-4004 | MEDICARE-ADV-B |
| CLM | CLM-401473 | 2026-07-31T05:13:36Z | ·Mateo | — | Shaw | 1955-06-19 | UHC-17274-05 | ·NULL | UNKNOWN | mateo.shaw46@outlook.com | ···· | N/A | NULL | N/A | GRP-5423 | — |
| CLM | CLM-401289 | 2026-02-13T19:59:38Z | Nancy | — | Goerge | 1946-06-28 | UHC-91005-74 | - | NULL | NANCY.GEORGE34@YAHOO.COM | 7699 Grand Avenue | Atlanta | ·GA | 30322 | GRP-3846 | ·N/A |
| CLM | CLM-401974 | 2026-06-11T01:53:59Z | Myers, Justin | — | — | 1972-03-15 | — | •••-••-4051 | null | ···· | 1634 Apache Boulevard | San Diego | California | 92189 | GRP-7670·· | UNKNOWN |
| CLM | CLM-402118 | 2026-03-28T01:42:33Z | ·Raymond | ···· | Sctt | 1988-07-05 | — | N/A | — | — | 7866 Lincoln Way | Denver | CO·· | 80228·· | GRP-6057 | — |
| CLM | CLM-428499 | 2026-06-07T08:57:09Z | JOSE | — | POWELL | Jul 26, 1975 | UHC-57609-34 | •••-••-5420 | UNKNOWN | - | 8444 Highland Ave | Chandler | AZ | 85286-8730 | GRP-9972·· | N/A |
| CLM | CLM-415617 | 2026-03-20T01:36:48Z | Linda | E | ·Green | 1970-08-10 | — | — | — | — | 8032 Valley View Drive·· | LOS ANGELES | CA | 90038 | GRP-7112 | MEDICARE-ADV-A |
| CLM | CLM-432345 | 2026-06-09T10:33:15Z | Michael | — | Weber | 1950-11-17 | UHC-80019-73 | N/A | null | null | 3529 WASHINGTON STREET | COLUMBUS | Ohio | null | — | N/A |
| CLM | CLM-408678 | 2026-05-05T14:15:38Z | Burton, Janice | K | — | 1955-04-03 | UHC-20074-87 | null | — | null | UNKNOWN | NULL | UNKNOWN·· | — | — | — |
| CLM | CLM-425774 | 2026-03-04T00:20:44Z | Joan | — | Soto | 1981-05-17 | NULL | - | null | — | 1004 Apache Blvd | Los Angeles | CA | 90000-6251 | ·GRP-7130 | MEDICARE-ADV-B |
| CLM | CLM-430212 | 2026-04-01T19:46:15Z | evelyn | — | kim·· | 1990-05-18 | UHC-97183-17 | NULL | 8627110973 | evelyn.kim@outlook.com | — | ·· | null | null | GRP-8381 | N/A |
| CLM | CLM-415511 | 2026-04-22T13:48:11Z | joyce | — | moreno | 20-12-1990 | N/A | •••-••-9324 | 908.720.8246 | — | NULL | UNKNOWN | UNKNOWN | - | null | NULL |
| CLM | CLM-402690 | 2026-03-31T21:23:23Z | Luis | — | Sandoval | 02/12/86 | UHC-26897-99·· | null | NULL | NULL | 2264 Harbor Blvd | Charlotte | NC | 28276 | — | — |
| CLM | CLM-429836 | 2026-05-29T09:20:22Z | teresa | G | james | 1987-06-15 | UHC-36227-89 | N/A·· | (620) 845-8818 | N/A | 5550 JEFFERSON AVE | Plano | TX | 75084 | ·- | N/A |
| CLM | CLM-431345 | 2026-07-22T05:04:54Z | Dorothy | ·· | Sandoval | 1994-05-25·· | NULL | — | ·· | — | 1738 Mountain View Dr | Seattle | WA | 98108 | - | CHOICE-PLUS-PPO |
| CLM | CLM-430964 | 2026-09-28T17:23:46Z | LUIS | — | BUTLER | 1948-01-28 | UHC1930115 | •••-••-3337 | null | UNKNOWN | 7243 Sunset Boulevard | Tampa | FL | 33671 | N/A | ···· |
| CLM | CLM-409148 | 2026-02-21T17:42:30Z | Nichos, Zachary | — | — | ·1973-09-11 | UNKNOWN | N/A | 634-494-2060 | — | 7771 Harbor Blvd | Atlanta | GA | 30378 | GRP-6806 | — |
| CLM | CLM-423097 | 2026-06-14T22:09:35Z | Maason | — | Clark | Sep 12, 1949 | UHC-58223-41·· | •••-••-7139 | ···· | — | 3158 BAYSHORE DR | HOUSTON | TX | 77010 | GRP-4962 | null·· |
| CLM | CLM-407298 | 2026-03-21T08:13:49Z | ·Ann | N | Washington | Dec 28, 1963 | UHC-77404-59 | •••-••-7676 | 420-302-4821 | UNKNOWN | 5383 Mountain View Drive | Gilbert | AZ·· | 85282 | GRP-3757 | CORE-HMO |
| CLM | CLM-406534 | 2026-06-01T15:15:36Z | garcia | — | teresa | 19610505 | UHC-54293-79 | — | 3865890680 | UNKNOWN | UNKNOWN | — | — | - | — | NAVIGATE-HMO |
| CLM | CLM-418629 | 2026-06-02T10:47:29Z | JOHN | — | RAMOS | 07-07-1994 | UHC-05969-13 | — | 208-627-8814 | - | ·3869 Baseline Road | Fresno | CA | 93712 | — | UNKNOWN |
| CLM | CLM-422206 | 2026-02-18T21:46:37Z | Alvarado, Jonathan | B. | — | 1956-01-03 | UHC-88343-03·· | — | N/A | — | null | — | — | NULL | GRP-8169 | NULL |
| CLM | CLM-432078 | 2026-05-03T17:59:37Z | Terry | — | Ward | 1946-01-15 | UHC-07080-31 | NULL | 2281569 | N/A | 7505 ELM ST | TAMPA | Florida | ·33604 | GRP-0558 | UNKNOWN |
| CLM | CLM-401528 | 2026-02-14T21:27:48Z | Danny | — | Wright | 24-12-1970 | UHC-24840-66 | •••-••-2174 | 602-257-7663 | ·· | 1934 Valley View Dr | ·Orlando | FL | 32856 | ·GRP-4350 | NULL |
| CLM | CLM-423322 | 2026-06-12T02:56:42Z | Sara | — | Roberts | 1950-08-19 | UHC-52367-88 | — | 15388898222 | ···· | — | UNKNOWN | — | NULL | UNKNOWN | NULL |
| CLM | CLM-424860 | 2026-06-17T21:56:23Z | STEPHANIE | — | BELL | 1957-03-11 | — | — | -·· | — | 2462 Park Pl | Charlotte | NC | 28246 | GRP-6610 | — |
| CLM | CLM-413671 | 2026-07-27T15:50:54Z | Jean | L·· | Lucas | 1978-04-09 | — | — | 583-511-1157 | NULL | 9228 Central Avenue | Jacksonville | FL | 32284 | GRP-9338 | - |
| CLM | CLM-402445 | 2026-02-10T05:52:24Z | NATALIE | ···· | HOWELL | 28-03-1950 | UHC-74422-60 | UNKNOWN | — | — | 5416 Jefferson Avenue | Tempe | ·AZ | 85207 | GRP-5130 | — |
| CLM | CLM-402119 | 2026-06-17T20:42:20Z | RAY | E. | SCOTT | 1988-07-05 | ·· | — | 223-312-2221 | N/A | 7866 Lincoln Way | Denver | CO | 80228-0762 | UNKNOWN | — |
| CLM | CLM-408435 | 2026-05-05T08:07:56Z | RYAN | — | DIAZ | 1991-04-01 | UHC-85118-52 | •••-••-8874 | 3212105174 | RYAN.DIAZ@GMAIL.COM | null | NULL | NULL | NULL | GRP-1969 | — |
| CLM | CLM-409633 | 2026-04-02T06:11:11Z | Luis | — | Sullivan | 1950-06-03 | UHC-55732-71 | •••-••-3952 | ·(387) 267-8215 | UNKNOWN | N/A | NULL | -·· | null | GRP-5248·· | CORE-HMO |
| CLM | CLM-429636 | 2026-03-30T16:34:14Z | Scott | V | Mason | 1974-04-01 | UHC-40347-24 | — | (468) 318-4879 | — | 6312 Grand Avenue | Columbus | ·OH | 43228·· | GRP-4747 | CORE-HMO |
| CLM | CLM-418531 | 2026-02-17T09:36:07Z | ryan | L. | hernandez | 1958-01-19 | UHC-51810-13 | NULL | null | — | 6988 Sage Ct | Charlotte | NC | 28205 | — | SELECT-EPO |
| CLM | CLM-418018 | 2026-08-28T02:22:44Z | Santos, Jennifer | — | — | 1944-02-16 | NULL | N/A | — | null | 4465 HILLCREST ROAD | Seattle | WA | 98130 | GRP-9454 | SELECT-EPO |
| CLM | CLM-432539 | 2026-03-08T18:22:45Z | Jordan, Ruth | — | ·· | 2005-02-16 | UHC-16459-44 | — | NULL | ·N/A | — | — | - | — | GRP-1718 | ·SELECT-EPO |
| CLM | CLM-409821 | 2026-01-22T20:54:50Z | Olivia | — | Tran | 1980-03-18 | UHC-76853-38 | •••-••-7812 | 3307061807 | — | null | — | N/A | NULL | GRP-5994 | - |
| CLM | CLM-414877 | 2026-06-16T23:23:40Z | heather | ·· | burton | 2006-05-11 | UHC-19857-94 | — | — | null | 9594 Maple Avenue | Orlando | FL | 32856 | ·null | — |
| CLM | CLM-428342 | 2026-01-25T06:14:22Z | Betty | M | Oliver | 09/12/1971 | UHC-97972-62 | — | 632-238-3388 | UNKNOWN | 7470 Church St | Denver | CO | 80258 | — | CORE-HMO |
| CLM | CLM-409725 | 2026-07-17T22:36:25Z | LAWRENCE | — | BANKS·· | 1978-09-08 | N/A | - | 5354229068 | LAWRENCE.BANKS@YAHOO.COM | — | — | NULL | NULL | GRP-5283 | 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:43.430Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty