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-420961 | 2026-08-25T21:06:20Z | Will | — | Freeman | Mar 22, 1954 | UHC-52307-49 | UNKNOWN | 885-855-5367 | NULL | UNKNOWN | UNKNOWN | NULL·· | - | GRP-7298 | navigate-hmo |
| CLM | CLM-418038 | 2026-08-30T06:06:31Z | Gilbert, Brandun | ···· | — | 1979-12-13 | UHC8948707 | •••-••-1379 | (480) 221-8044 | -·· | 2482 Market St | Phoenix | az | 85021 | GRP-7913 | — |
| CLM | CLM-401662 | 2026-09-25T10:04:09Z | CHRISTINA | — | SANDOVAL | 1983-12-28 | UHC-51663-15 | •••-••-3925 | 16713807910 | — | 257 Meadow Lane | Fresno | CA | ·93762 | GRP-0237 | — |
| CLM | CLM-403082 | 2026-03-14T17:35:54Z | Jose | M. | Howell | 11/01/79 | UHC-12973-72 | •••-••-2192 | N/A | ···· | — | UNKNOWN | NULL | null | UNKNOWN·· | CORE-HMO |
| CLM | CLM-425578 | 2026-06-27T09:05:17Z | HNNAH | — | NELSON | 1986-09-27 | UHC-90359-46 | — | ·N/A | null | 7938 FOREST AVE | Minneapolis·· | MN | ·55497 | GRP-0650 | MEDICARE-ADV-B |
| CLM | CLM-401460 | 2026-08-01T07:27:56Z | Pat | ·· | Bishop | 10/03/74 | UHC-93699-11 | — | 9306936920 | UNKNOWN | 7761 Grand Ave | Fresno | ·CA | 93762 | NULL | - |
| CLM | CLM-406391 | 2026-05-30T19:40:03Z | Ann | — | Reid | 1989-06-25 | uhc-69943-35·· | NULL | - | — | 8701 Hillcrest Rd | Nashville | TN | 37208 | GRP-9097 | ·NAVIGATE-HMO |
| CLM | CLM-408466 | 2026-09-30T09:25:39Z | judy | — | payne | ·1950-01-20 | UHC-70825-08 | •••-••-6914 | UNKNOWN | JUDY.PAYNE45@PROTON.ME | 1141 Indian School Rd | Minneapolis·· | MN | 55402 | — | null |
| CLM | CLM-426357 | 2026-05-27T04:19:40Z | Juan | — | Williamson | 1956-04-04 | UHC8509320 | •••-••-7763 | +1 900 365 5053 | null | 8463 Valley View Drive | Denver·· | CO | 80253 | ·GRP-3769 | — |
| CLM | CLM-429406 | 2026-06-15T18:32:23Z | EDWARD | — | EDWARDS | 1964-11-24 | ·UHC-79908-24 | •••-••-7884 | +1 747 799 7808 | null | 1315 Apache Blvd | CHARLOTTE | NC | ·28241 | — | OPTIONS-PPO |
| CLM | CLM-403518 | 2026-01-23T04:10:57Z | luis | — | richards | 1961-02-26 | - | ·· | NULL | ·· | 810 JEFFERSON AVENUE | Orlando | FL | 32859 | GRP-0726 | ·OPTIONS-PPO |
| CLM | CLM-428885 | 2026-08-28T05:18:50Z | AISHA | — | HUDSON | 7/28/1969 | UHC0635521 | •••-••-8494 | ·(351) 593-0306 | UNKNOWN | 7330 Sunset Blvd | Tucson | AZ | 85756 | null | - |
| CLM | CLM-426567 | 2026-03-24T20:42:26Z | Olson, Peter | — | — | 1976-02-17 | UHC-64174-06 | — | ·null | null | 1042 Sunset Blvd | Chandler | AZ | 85207·· | ·GRP-2785 | — |
| CLM | CLM-425262 | 2026-03-31T11:29:45Z | omar | — | mendez·· | 1980-90-18 | UHC-18365-70 | •••-••-9803 | (887) 715-0749 | N/A | 6109 BROADWAY | Phoenix | AZ | 85004-0629 | GRP-6352 | - |
| CLM | CLM-405619 | 2026-07-17T15:20:01Z | Jessica | — | Taylor | 1951-02-22 | UHC-33596-12 | NULL | null | NULL | 2381 Lincoln Way | Nashville | TN | 37246 | UNKNOWN | UNKNOWN |
| CLM | CLM-411754 | 2026-01-03T14:01:54Z | KIMBERLY | — | VAZQUEZ | 18-02-1959 | UHC-98212-72 | •••-••-0377 | 9035527908 | — | — | ·NULL | N/A | UNKNOWN | GRP-7233 | - |
| CLM | CLM-417924 | 2026-08-07T18:23:11Z | KEVIN | — | MEDINA | 1956-06-26 | UHC-95181-03 | •••-••-9677 | 414.682.5677 | - | — | — | - | - | — | — |
| CLM | CLM-417957 | 2026-02-28T17:27:04Z | WAYNE | Q | SILVA | 18-02-2005 | UHC-07518-90 | ···· | - | UNKNOWN | 3386 Union St | Orlando | FL | 32817-1530·· | NULL | null·· |
| CLM | CLM-411645 | 2026-10-16T10:47:10Z | ·Jonathan | — | Ortega | 1993-09-14 | N/A | — | 746-387-4433 | — | — | — | UNKNOWN | UNKNOWN | GRP-6807 | N/A |
| CLM | CLM-429956 | 2026-06-02T08:06:07Z | Ann | — | Davis | 1963-11-05 | — | NULL | 772.654.2740 | — | null | — | NULL | — | GRP-5256 | OPTIONS-PPO |
| CLM | CLM-428698 | 2026-02-18T12:51:48Z | Joyce·· | — | Hansun | Jan 25, 1963 | UHC-16292-82 | NULL | null | — | 7610 Mountain View Drive | Plano·· | TX | 75019 | GRP-6601 | — |
| CLM | CLM-422691 | 2026-08-01T09:07:05Z | RICHARD | — | SANTIAGO | 05/09/86 | UNKNOWN | •••-••-9830 | — | — | UNKNOWN | — | — | - | GRP-3077 | — |
| CLM | CLM-415344 | 2026-07-17T00:32:15Z | George | — | Dominguez | Apr 12, 2001 | UHC-62241-74 | •••-••-0331 | (454) 563-4232 | N/A | 974 Sage Court #437 | Seattle | ·WA | 98194 | GRP-3834 | options-ppo |
| CLM | CLM-407294 | 2026-04-03T00:03:32Z | Kimberly | — | White | 1944-07-03 | UHC-64583-03 | •••-••-2165 | null | KIMBERLY.WHITE95@AOL.COM | — | ·N/A | null | N/A·· | GRP-5058 | MEDICARE-ADV-B |
| CLM | CLM-400821 | 2026-04-28T19:59:13Z | Albert | G | Hanson | 1940-03-10 | — | - | 490-752-4135 | NULL | 7146 Central Ave | SEATTLE | WA | 98191·· | GRP-6622 | MEDICARE-ADV-B |
| CLM | CLM-405704 | 2026-04-27T00:47:27Z | Abigail | — | Little | 1976-10-18 | null | •••-••-7894 | — | NULL | 7922 Apache Boulevard | FRESNO | CA | 93788 | NULL | null |
| CLM | CLM-410057 | 2026-04-02T23:40:51Z | randy | — | mason·· | 10/9/1959 | NULL | — | - | — | N/A | — | — | null | — | MEDICARE-ADV-A |
| CLM | CLM-420287 | 2026-09-22T20:08:21Z | KEVIN | — | MEJIIA | 20020112 | NULL | •••-••-1958 | 8855731349 | NULL | 7772 Mesa Dr | San Antonio | TX | 78225·· | GRP-7779 | — |
| CLM | CLM-400660 | 2026-07-13T14:08:03Z | ASHLEY | U. | BROWN | Jun 24, 1940 | - | •••-••-6175 | (669) 679-9132 | ·- | 1274 Ridge Rd | Nashville | ·TN | 37257 | GRP-9545·· | — |
| CLM | CLM-425506 | 2026-09-14T10:26:37Z | ROGER H. | — | HAWKINS | 1973-01-24 | UHC-17742-30 | UNKNOWN | NULL | — | 7741 Central Avenue | Phoenix | AZ | 85004 | GRP-6716 | MEDICARE-ADV-B |
| CLM | CLM-423348 | 2026-03-15T19:32:00Z | STEPHEN | ···· | FERNANDEZ | 1944-08-17 | UHC-00238-90 | NULL | 9483454267 | N/A | 5103 Lake View Road | Phoenix | az | 85072-0634 | GRP-9693 | MEDICARE-ADV-B |
| CLM | CLM-403654 | 2026-10-12T03:57:01Z | Kyle | — | Salazar | 1988-04-26 | — | — | 6653122516 | - | N/A | ·· | N/A | null | GRP-3582 | - |
| CLM | CLM-416739 | 2026-01-03T00:22:25Z | MICHAEL | — | SIMMONS | 1994-02-27 | UHC-55383-31 | •••-••-4865 | NULL·· | ·UNKNOWN | 3978 Broadway | Houston | TX | 77078 | UNKNOWN | MEDICARE-ADV-B |
| CLM | CLM-404840 | 2026-01-27T17:16:18Z | Lucia | — | Simmons | 04/01/2004 | UHC-50716-66 | NULL | 9276652851 | null | — | — | NULL | — | GRP-0183 | ···· |
| CLM | CLM-405196 | 2026-06-17T09:00:15Z | Jeremy | ·T | Garrett | 11/08/96 | UHC8540426 | NULL | (935) 386-4371 | — | 2455 PINE DRIVE | Nashville | TN·· | 37279 | — | — |
| CLM | CLM-403065 | 2026-05-29T05:36:39Z | Terry | — | Lane | 1969-03-27·· | — | — | ·742-324-5453 | NULL | NULL | — | — | — | null | SELECT-EPO |
| CLM | CLM-400588 | 2026-06-20T03:42:27Z | Alan | L | Contreras | 1939-06-09 | UHC-96866-71 | NULL | — | null | 7196 Bayshore Drive | TAMPA·· | FL | 33627 | GRP-7998 | N/A |
| CLM | CLM-426317 | 2026-03-23T07:56:53Z | Janet | ·· | Harris | 1943-04-01 | UHC-75532-63 | null | 4598996296 | N/A | — | — | UNKNOWN | NULL | — | NULL |
| CLM | CLM-404204 | 2026-02-22T23:12:48Z | GEOREG | — | LEWIS | 20050223 | UHC-96111-39 | •••-••-0600 | null | — | 2058 Sage Ct | Houston | tx | 77017 | NULL | CORE-HMO |
| CLM | CLM-417229 | 2026-03-10T23:10:03Z | Andrea | — | Anderson | 1945-09-25·· | N/A | NULL | (652) 981-1492 | NULL | 1436 Cedar Ln | San Antonio | TX | 78250 | GRP-5118 | MEDICARE-ADV-B |
| CLM | CLM-425629 | 2026-04-20T00:23:47Z | LIUS | — | ·GREEN | ·1964-04-24 | UHC-57723-18 | •••-••-7584 | 2658492 | UNKNOWN | 873 Indian School Road | Fresno | CA | 93783 | ·· | — |
| CLM | CLM-412538 | 2026-07-15T07:07:59Z | Charlotte | — | ·Bryant | 2002-04-24 | UHC-22651-59 | — | N/A | - | 1933 Grand Avenue | Dallas | TX | 75255 | GRP-1336 | — |
| CLM | CLM-417204 | 2026-08-05T22:29:44Z | Carlos | — | Torres | 1970-09-14 | UHC-33962-64 | NULL | ·(971) 370-8636 | NULL | NULL | — | null | NULL | GRP-9904 | NAVIGATE-HMO |
| CLM | CLM-417802 | 2026-06-30T16:24:42Z | Gloria | — | Crawford | 19971204 | — | — | 18296151569 | — | 69 Mesa Dr | Los Angeles | CA | 90061 | GRP-3466 | — |
| CLM | CLM-401115 | 2026-05-08T14:35:41Z | CAMILA | — | AUSTIN·· | 2001-05-25 | UHC-06304-18 | ·- | NULL | — | 3279 Sage Ct | Mesa·· | AZ | 85223 | GRP-3075 | null |
| CLM | CLM-412197 | 2026-07-04T02:47:09Z | EDWARD | — | NICHOLS | 1997-04-26 | UHC-26667-44 | •••-••-2046 | UNKNOWN | — | 4601 Ridge Road | Dallas | TX | 75216 | GRP-5696 | - |
| CLM | CLM-426640 | 2026-03-09T09:20:22Z | Kelly | — | Lawrence | 11/22/00 | null | •••-••-8438 | — | — | 6435 Jefferson Ave | ·Chandler | AZ | 85212 | GRP-7020 | SELECT-EPO |
| CLM | CLM-417397 | 2026-06-18T16:52:34Z | JEFFREY | — | ·RICHARDS | 19730113 | UHC-76290-57·· | •••-••-8854 | 432-357-4624 | - | 1712 Indian School Rd | Mesa | AZ | 85267·· | NULL | UNKNOWN |
| CLM | CLM-419945 | 2026-07-10T13:14:19Z | Robert | Q. | Price | 1967-04-12 | - | •••-••-4191 | — | N/A | — | — | — | — | GRP-6023 | UNKNOWN |
| CLM | CLM-430886 | 2026-09-29T00:09:36Z | Diana | — | Cruz | 19840515 | UHC-19574-09 | null | null | diana.cruz@hotmail.com | — | NULL | NULL | - | GRP-4448 | NAVIGATE-HMO |
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:40.351Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty