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
Third-party administrator only, ordered by line number
| Source | Record | Received | First | Middle | Last | DOB | Member ID | SSN | Phone | Address | City | State | ZIP | Group | Plan | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TPA | TPA-60148 | 2026-04-01T07:39:16Z | Karen | — | Green | ·1953-06-27 | UNKNOWN | ·· | 16726132324 | karen.green49@gmail.com | 1578 CAMELBACK ROAD | Dallas | TX | 75298 | — | — |
| TPA | TPA-60058 | 2026-01-11T06:29:43Z | VINCENT | — | TAYLOR | 1938-01-18 | NULL | UNKNOWN | N/A | vincent.taylor77@gmail.com | null | — | NULL | UNKNOWN | — | N/A |
| TPA | TPA-61690 | 2026-04-25T00:11:59Z | ·Lawrence, Roy | — | — | Jun 9, 1993 | NULL | UNKNOWN | N/A | — | null | NULL | — | ·- | ·· | — |
| TPA | TPA-56742 | 2026-04-08T01:45:10Z | Nunez | — | Gabriel | 1941-09-11 | UHC-58060-75 | — | - | — | N/A | UNKNOWN | null | — | — | null |
| TPA | TPA-64175 | 2026-09-17T14:32:30Z | Adam | — | Schmidt·· | 1973-02-12 | null | •••-••-4907 | — | ·UNKNOWN | 3416 Palm Dr | Orlando·· | Florida | 32827 | UNKNOWN | — |
| TPA | TPA-51728 | 2026-04-28T07:17:05Z | Williams, Charlotte | — | — | ·1995-11-16 | — | null | ·12986492916 | N/A | 8125 CANYON RD | Austin | TX | 78765 | — | NULL |
| TPA | TPA-60713 | 2026-05-07T05:32:26Z | Lucia | — | Castro | 19560302 | - | •••-••-9327 | 567-659-1519 | lucia.castro11@icloud.com | 7981 Broadway | Scottsdale | AZ | 85251 | GRP-1431 | — |
| TPA | TPA-62858 | 2026-04-10T09:49:58Z | Benjamin | R | Thompson | 1990-07-25 | N/A | — | — | - | NULL | null | N/A | null | GRP-7678 | MEDICARE-ADV-B |
| TPA | TPA-50499 | 2026-02-16T05:52:29Z | Wayne | B | Dunn | 19450903 | - | — | NULL | WAYNE.DUNN80@YAHOO.COM | 3943 Grand Ave | Tampa | FL | ·33628 | null | MEDICARE-ADV-A |
| TPA | TPA-60328 | 2026-05-19T03:47:32Z | ANA | — | THOMAS | 1983-07-19 | ·· | ···· | NULL | - | 8738 Camelback Road Apt 36 | Scottsdale | AZ | 85228 | GRP-4282 | — |
| TPA | TPA-62517 | 2026-02-20T09:34:22Z | Scott | — | Medina | 19380306 | ·UNKNOWN | — | NULL | scott.medina31@yahoo.com·· | 637 SPRING ST | Orlando | FL | 32855 | — | — |
| TPA | TPA-57456 | 2026-02-28T01:35:02Z | Michelle | — | Andrews | 1993-08-24 | — | •••-••-7970 | 237-787-1199 | null | 6315 Highland Ave | Orlando | Florida | 32874 | GRP-0188 | SELECT-EPO |
| TPA | TPA-55867 | 2026-06-26T20:29:54Z | EMMA | — | MENDEZ | 1954-05-08 | UHC-16028-30 | UNKNOWN | 240.383.3741 | null | 5770 Indian School Road | EDEN PRAIRIE | Minnesota | 55348 | — | NULL |
| TPA | TPA-59865 | 2026-09-12T18:46:23Z | Julia | H | Carter | 12/9/1993 | N/A·· | null | null | NULL | 7784 Apache Boulevard | Columbus | OH | 43266 | NULL | - |
| TPA | TPA-57558 | 2026-06-12T22:47:35Z | Timothy | — | Wong | 08/08/1965 | null | null | (683) 410-9706 | timothy.wong@yahoo.com | 3169 CAMELBACK ROAD | FRESNO | CA | 93793 | GRP-5114 | UNKNOWN |
| TPA | TPA-60894 | 2026-07-07T19:20:09Z | Kathryn | — | Medina | 1989-04-08·· | - | null | NULL | kathryn.medina38@yahoo.com | 9619 Camelback Road | Miami | FL | 33194 | GRP-8284 | MEDICARE-ADV-B |
| TPA | TPA-53585 | 2026-06-21T12:44:55Z | VINCENT | I | HAYES | 1945-11-04 | — | •••-••-1578 | — | vincent.hayes37@yahoo.com | ·1652 WASHINGTON STREET | Phoenix | AZ | 85099-1720 | — | MEDICARE-ADV-A |
| TPA | TPA-60077 | 2026-08-01T10:48:15Z | BARBARA | — | COLLINS | 2004-05-17 | UHC-85662-20 | — | ·· | null | 647 MARKET ST | Minneapolis·· | MN | 55468-1224 | UNKNOWN | null |
| TPA | TPA-52260 | 2026-08-20T04:56:27Z | Billy | — | Morgan | 1977-10-28 | NULL | null | 8182485 | N/A | 2010 Union Street | Denver | CO | 80224 | ·- | — |
| TPA | TPA-50857 | 2026-10-02T06:20:30Z | Catherine | ·· | Robinson | 1945-09-28 | — | •••-••-2036 | ·null | catherine.robinson@aol.com | 1847 Willow Court | San Diego | ·CA | 92174 | N/A | - |
| TPA | TPA-63984 | 2026-09-13T18:40:10Z | Jacqueline | — | Singh | 2006-02-07 | null | - | N/A | — | 4215 Church St | Tampa·· | FL | 33693 | — | CHOICE-PLUS-PPO |
| TPA | TPA-63820 | 2026-08-16T11:55:09Z | Billy | — | Reynolds | 1969-01-20 | - | - | ···· | BILLY.REYNOLDS36@PROTON.ME | 6808 Mesa Dr | Scottsdale | AZ | 85213 | - | — |
| TPA | TPA-54951 | 2026-09-05T02:24:45Z | Kimberly | — | Chavez·· | 1943-06-23 | UNKNOWN | — | (556) 522-5136 | — | 3310 OAK ST | Charlotte | NC | 28291 | N/A | NULL |
| TPA | TPA-55177 | 2026-06-10T09:59:38Z | Omar | — | Simpson | ·1999-11-26 | NULL | — | ·N/A | UNKNOWN | 7949 CENTRAL AVENUE | CHARLOTTE | NC | 28273-6612 | NULL | MEDICARE-ADV-B |
| TPA | TPA-53086 | 2026-10-05T03:58:06Z | ·Joyce | C | Chen | 1986-05-01 | NULL | •••-••-4910 | 638-252-9071 | - | — | — | NULL | N/A | GRP-8791 | — |
| TPA | TPA-52489 | 2026-06-29T02:05:28Z | ·STEPHEN | — | CHAVEZ | 1993-06-01 | — | ·- | null | stephen.chavez13@aol.com | 3236 Jefferson Ave | San Antonio | TX | - | ·· | — |
| TPA | TPA-62344 | 2026-07-08T06:11:16Z | JAMES | Q | OWENS | 02/24/66 | — | NULL | 2275331039 | N/A | 9781 Harbor Boulevard | Phoenix | AZ | 85016 | — | N/A |
| TPA | TPA-60763 | 2026-07-04T20:34:21Z | BRADLEY·· | — | MORRIS | 20-11-1956 | N/A | •••-••-0242 | 594-622-3359 | BRADLEY.MORRIS@HOTMAIL.COM | 4566 SPRING ST | Tucson | AZ | 85761 | - | SELECT-EPO |
| TPA | TPA-54703 | 2026-09-20T00:44:39Z | Virginia | ···· | Freeman | 09/05/60 | N/A | N/A | 407-690-3566 | — | 9052 Cedar Ln | Nashville | TN | 37275 | GRP-2203 | MEDICARE-ADV-A |
| TPA | TPA-57113 | 2026-10-18T16:07:12Z | AMANDA | — | WASHINGTON | 7/1/2000·· | — | — | N/A | — | 2909 SPRING STREET | ·Charlotte | NC | 28257 | GRP-9681 | null |
| TPA | TPA-63119 | 2026-03-21T08:20:28Z | Sharon | — | Burke | 2001-12-20 | N/A | •••-••-6318 | 3514196066 | — | 655 Harbor Boulevard | Glendale | AZ | 85344 | null | UNKNOWN |
| TPA | TPA-59240 | 2026-08-18T16:58:57Z | Joyce | — | Rodriguez | 1961-10-22 | UHC-59693-27 | •••-••-2006 | NULL | JOYCE.RODRIGUEZ@PROTON.ME | UNKNOWN | - | UNKNOWN | — | null | — |
| TPA | TPA-51432 | 2026-03-28T08:37:27Z | Vincent | — | Hanson | 12/03/1943 | - | •••-••-3416 | — | ·NULL | 6526 Camelback Rd | Atlanta | GA | 30302 | NULL | — |
| TPA | TPA-52801 | 2026-02-21T19:00:04Z | Natalie | — | Li | Aug 2, 1987 | — | •••-••-6613 | - | NULL | 6412 Indian School Rd | Austin | ·TX | 78774 | UNKNOWN | CORE-HMO·· |
| TPA | TPA-57740 | 2026-09-08T01:33:47Z | HANNAH | V. | BRADLEY | 01/01/1967 | ···· | - | 6474676152 | N/A | 7774 OAK STREET | Los Angeles | CA | — | GRP-5974 | CORE-HMO |
| TPA | TPA-56205 | 2026-03-31T00:35:41Z | ISABELLA | — | WATKINS | 1967-06-02 | NULL | — | — | NULL·· | 1407 OCEAN AVENUE | MESA | ·AZ | 85223 | UNKNOWN | - |
| TPA | TPA-58601 | 2026-01-17T06:20:25Z | Angela | ···· | Flores·· | 1985-04-07 | — | N/A | 938-417-6303 | N/A | 7310 Jefferson Ave | Charlotte | North Carolina | 28231 | — | — |
| TPA | TPA-53343 | 2026-01-01T17:05:21Z | PATRICK | X | JAMES | 2070-03-02 | null | •••-••-4886 | (883) 717-6774 | N/A | 6916 Hillcrest Road | MIAMI | FL | NULL | null | NULL |
| TPA | TPA-60434 | 2026-01-21T00:41:29Z | julia | — | park | 1956-11-04 | NULL | null | (237) 448-8144 | null | 3535 PINE DRIVE | Tampa | FL | UNKNOWN | null | null |
| TPA | TPA-57688 | 2026-09-12T06:52:47Z | ·Lawrence | — | Russell | ·1981-02-16 | — | NULL | 6623194772 | NULL | 7206 Valley View Dr | Miami | ·FL | 33112 | GRP-5228 | — |
| TPA | TPA-51770 | 2026-01-11T09:41:07Z | Roy | — | Hill | 08/12/1977 | -·· | null | 16125030383 | roy.hill23@icloud.com | 5091 Maple Avenue | Orlando | Florida | 32863 | UNKNOWN | - |
| TPA | TPA-58594 | 2026-03-11T15:00:41Z | Mason | — | Jenkins | 1956-09-19 | UHC-24242-13 | N/A | ·NULL | — | 8141 Harbor Blvd | Gilbert | AZ | 85219 | NULL | UNKNOWN |
| TPA | TPA-50703 | 2026-01-20T00:59:39Z | Eric | — | Wood | 1994-08-23 | null | null | NULL | UNKNOWN | N/A | ·null | UNKNOWN | NULL | — | NULL |
| TPA | TPA-60334 | 2026-06-24T23:03:42Z | RALPH | — | BAILEY | 10-01-1968 | N/A | null | ·· | RALPH.BAILEY25@AOL.COM | 9827 Elm St #317 | Houston | TX | 77097 | — | — |
| TPA | TPA-61361 | 2026-10-09T04:02:24Z | arjun | — | marshall | 19740322 | ·· | — | — | NULL | 4070 Willow Court #774 | Tampa | FL | UNKNOWN | null | — |
| TPA | TPA-53037 | 2026-04-09T15:17:38Z | lauren | — | mason | ·1953-05-25 | ·N/A | NULL | — | - | 2872 CHURCH STREET | Tempe | AZ | 85205 | — | NULL |
| TPA | TPA-50300 | 2026-10-13T14:44:44Z | SHIRLEY | — | WOODS | 1959-10-18 | NULL | •••-••-8279 | 6592621873 | UNKNOWN | 9434 Washington Street | Eden Prairie·· | MN | 55379 | GRP-4186 | — |
| TPA | TPA-62418 | 2026-03-22T06:38:54Z | Hamilton, William | — | — | 1950-11-11 | — | — | 2453429974 | null | 3320 Meadow Lane | Fresno | CA | ·- | — | — |
| TPA | TPA-54302 | 2026-01-24T16:57:30Z | Abigail | — | Vargas | ·2005-06-26 | NULL | •••-••-5085 | — | — | UNKNOWN | — | UNKNOWN | UNKNOWN | N/A | NULL |
| TPA | TPA-50917 | 2026-06-23T14:22:15Z | ANA | — | FOX | 1954-09-13 | UHC7015380 | — | 16986402423 | — | 9363 LAKE VIEW ROAD | Minneapolis | MN | ·55496 | — | 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:53.103Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty