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-55021 | 2026-01-09T21:22:56Z | Yuki O | — | Hill | 11/25/1993·· | N/A | N/A | 869.920.8607 | N/A | 8400 MOUNTAIN VIEW DR | Atlanta | GA | 30389 | ·GRP-6666 | UNKNOWN |
| TPA | TPA-54095 | 2026-08-02T23:58:03Z | STEPHEN | — | MILLER | Mar 24, 2007 | — | — | — | — | 5983 Union Street | CHANDLER | AZ | 85276 | null | — |
| TPA | TPA-53023 | 2026-09-26T01:25:56Z | Brandon | — | Coleman·· | 1945-02-20·· | — | — | UNKNOWN | ·· | 3945 Lake View Rd | Mesa | AZ | 85261 | ·N/A | options-ppo |
| TPA | TPA-51632 | 2026-03-01T22:16:53Z | Justin·· | — | Hansen | 1988-07-23 | N/A | ·N/A | UNKNOWN | ···· | 7600 Cedar Ln | Phoenix | AZ | null | N/A | null |
| TPA | TPA-50419 | 2026-04-08T16:24:56Z | Carl | W | Sandoval | 01-04-1998 | null | NULL | NULL | - | ·1075 Elm Street | PLANO | TX·· | 75032 | — | — |
| TPA | TPA-55259 | 2026-03-30T07:48:20Z | Sophia | D. | ·Montgomery | 1947-01-08 | UNKNOWN | N/A | +1 722 281 1380 | — | 2573 Oak St | ·AUSTIN | TX | 78708 | null | UNKNOWN |
| TPA | TPA-61315 | 2026-10-18T06:17:59Z | Loagn | — | Gibson | 1961-12-08 | UNKNOWN | •••-••-6618 | — | NULL·· | 5444 Union Street | Sacramento | CA | 95815-0307 | ···· | NULL |
| TPA | TPA-52129 | 2026-05-20T03:46:01Z | Marcus | — | Payne | 1962-12-06 | UHC-10387-43 | •••-••-4132 | — | — | 8525 Main Street | Austin | TX | 78749 | NULL | — |
| TPA | TPA-53867 | 2026-06-04T15:42:20Z | jack | — | pierce | Dec 15, 1958·· | null | •••-••-6204 | — | - | - | — | NULL | — | N/A | — |
| TPA | TPA-50647 | 2026-10-17T00:51:19Z | MARCUS | — | MENDEZ | 01/10/1998 | — | NULL | 757-879-1239 | null | 878 CAMELBACK RD | Chandler | AZ | 85287 | — | - |
| TPA | TPA-56228 | 2026-02-16T17:54:50Z | ·Jonathan | — | Peterson | 1939-09-22 | NULL | NULL | — | null | 3469 Spring Street | Plano | TX | 75019 | N/A | MEDICARE-ADV-B |
| TPA | TPA-63172 | 2026-09-02T04:24:37Z | Jesse | D | Lewsi | 1976-02-91 | — | •••-••-3588 | ·+1 780 454 2217 | — | ·2263 Oak Street | Gilbert | AZ | 85233 | - | null |
| TPA | TPA-54628 | 2026-08-15T05:55:00Z | AMBER | — | PEREZ | 1943-10-25 | UHC-24581-99 | •••-••-2931 | (401) 301-1768 | — | 6547 Union St | Nashville | TN | 37244 | UNKNOWN | — |
| TPA | TPA-62850 | 2026-04-20T18:53:04Z | Katherine | — | Jackson | 1955-02-11 | null | •••-••-1936 | NULL | katherine.jackson95@proton.me | 6509 Lincoln Way | Dallas | Texas | 75280 | UNKNOWN | — |
| TPA | TPA-54290 | 2026-10-10T05:36:30Z | Amy | — | Kennedy | 6/19/1947 | UHC-82897-98 | NULL | 6655382478 | AMY.KENNEDY@PROTON.ME·· | 2061 Canyon Rd | Atlanta | GA | 30382 | — | ···· |
| TPA | TPA-52434 | 2026-04-29T11:17:12Z | Kelly | I. | Stevens | 1958-08-25 | - | — | — | — | 8166 Ocean Avenue | Houston | TX | 77006 | ·UNKNOWN | — |
| TPA | TPA-59412 | 2026-02-19T22:44:13Z | VINCENT | — | WONG | 15-12-1946 | null | •••-••-9272 | 14454922075 | null | UNKNOWN·· | NULL·· | — | null | GRP-2068 | - |
| TPA | TPA-51755 | 2026-08-28T16:21:44Z | ROGER | — | ·WATSON | 1948-04-27 | — | - | 436-791-4775 | NULL | 6246 FOREST AVE | ·Minneapolis | MN | 55429 | — | NULL |
| TPA | TPA-50219 | 2026-02-22T08:16:47Z | jacob | G. | goez | 1951-07-05·· | — | UNKNOWN | (503) 413-3742 | N/A | 3679 Union St | Sacramento | CA | 95811-8651 | null | ·N/A |
| TPA | TPA-58267 | 2026-08-27T09:06:53Z | ALBERT | — | WALSH | 1947-03-02 | UNKNOWN | •••-••-3005 | — | null | 3120 Elm St | Chandler | AZ | 85298 | GRP-7017 | NULL |
| TPA | TPA-51100 | 2026-03-16T12:08:13Z | ·JANET | — | GRAHAM·· | 1965-01-05 | UNKNOWN | •••-••-0341 | 5643692 | - | 7239 LINCOLN WAY | PHOENIX·· | AZ | 85034-3165 | UNKNOWN | N/A |
| TPA | TPA-53007 | 2026-06-05T04:54:04Z | ·WALTER | — | MURRAY | 1964-02-14 | — | •••-••-4508 | 357-259-6288 | ·walter.murray@yahoo.com | 7714 Washington Street | TAMPA | FL | 33600 | NULL | SELECT-EPO |
| TPA | TPA-53436 | 2026-05-17T05:29:31Z | Bradley | — | Jacobs | 1974-02-03 | UHC-08105-35 | •••-••-6546 | (401) 423-1319 | N/A | 2621 River Road Apt 39 | Gilbert | AZ | 85209 | — | SELECT-EPO·· |
| TPA | TPA-51172 | 2026-01-30T22:26:45Z | Amber | ·· | Graham | 14-10-1969 | NULL | •••-••-3774 | N/A | N/A | 1919 Park Place | SCOTTSDALE | AZ | 85253 | UNKNOWN | — |
| TPA | TPA-62702 | 2026-06-26T00:29:27Z | Patricia | — | Coleman | 1958-05-18 | — | - | — | NULL | 6613 APACHE BOULEVARD | Atlanta | GA | 30344 | UNKNOWN | - |
| TPA | TPA-51358 | 2026-08-27T23:41:26Z | ·Katherine | S | Williamson | 1974-04-22 | ···· | NULL | (378) 317-1459 | — | 5607 CENTRAL AVENUE | PLANO | TX | 75075-9544 | ·· | — |
| TPA | TPA-54234 | 2026-10-07T07:03:12Z | Yuki | — | Lynch | 1963-06-01 | UNKNOWN | UNKNOWN | +1 920 557 7136 | — | 1153 Canyon Rd | Gilbert | AZ | 85223 | GRP-2983 | CORE-HMO |
| TPA | TPA-52155 | 2026-09-27T08:09:02Z | ·Jason | — | Delgado | 1987-09-17 | NULL | - | 5004984982 | JASON.DELGADO41@ICLOUD.COM | 3835 SPRING ST | Jacksonville | FL | 32294 | GRP-8760 | MEDICARE-ADV-B |
| TPA | TPA-64262 | 2026-10-12T23:52:08Z | CHERYL | — | OBRIEN | 1938-08-14 | — | — | UNKNOWN | null | 7836 Union St | Chandler | AZ | — | - | N/A |
| TPA | TPA-62420 | 2026-07-08T16:53:41Z | JAMES | — | HUNT | 1986-06-25 | UHC-70668-32 | - | UNKNOWN | NULL | — | — | NULL | N/A·· | GRP-5751 | null |
| TPA | TPA-59157 | 2026-09-03T06:14:38Z | dennis | — | hannsen | 1940-05-06 | ·UNKNOWN | NULL | 16584496728 | NULL | ·9125 Jefferson Ave | Phoenix | AZ | 85058 | GRP-0968 | ···· |
| TPA | TPA-60134 | 2026-06-20T17:12:31Z | Dois | — | Dunn | 1967-06-25 | null | — | - | NULL | 5802 LAKE VIEW RD | Seattle | WA | 98151 | — | — |
| TPA | TPA-54652 | 2026-06-20T20:29:56Z | Sophia | — | Peterson | 11/21/03 | — | — | — | NULL | 8118 Willow Ct | Fresno | CA | 93757 | NULL | CHOICE-PLUS-PPO |
| TPA | TPA-59218 | 2026-06-21T12:06:46Z | William | — | Freeman | 19540322 | NULL | null | - | NULL | 765 HIGHLAND AVE·· | Plano | TX | 75071 | - | null |
| TPA | TPA-57273 | 2026-01-08T11:25:38Z | Billy | ···· | Price | 1955-12-11 | — | — | — | — | ·8964 WILLOW COURT | DENVER·· | Colorado | 80285 | GRP-2154 | CHOICE-PLUS-PPO |
| TPA | TPA-56581 | 2026-10-12T19:43:29Z | Steve | — | Nichols | ·05/04/45 | — | — | 9552539607 | -·· | 3615 SUNSET BLVD | Los Angeles | CA | 90038 | - | NAVIGATE-HMO |
| TPA | TPA-61629 | 2026-07-27T03:33:03Z | Albert | — | Wells | 11/2/1984 | — | - | — | — | 1734 Park Pl | Miami | FL | 33116 | GRP-0159 | NULL |
| TPA | TPA-64424 | 2026-04-28T03:31:14Z | RALPH | — | FISHER | 1941-07-02 | NULL | null·· | — | ralph.fisher34@outlook.com | 9548 Harbor Boulevard | Miami | FL | ·33126 | GRP-6313 | — |
| TPA | TPA-56983 | 2026-09-13T08:13:34Z | Nanncy | — | Hart | 1988-08-19 | NULL | N/A | 793-637-9585 | null | 9065 Jefferson Ave | Seattle | WA | 98162 | NULL | null |
| TPA | TPA-54171 | 2026-02-05T10:07:20Z | Dean, Russell | — | — | 23-07-1981 | NULL | •••-••-7476 | 734-839-3066 | N/A | — | NULL | — | NULL | GRP-6719 | CHOICE-PLUS-PPO |
| TPA | TPA-50981 | 2026-06-08T04:09:28Z | LAURA·· | ···· | ALVARADO·· | 2006-01-12 | NULL | null·· | — | UNKNOWN·· | 9722 HILLCREST RD | Seattle | WA | 98116 | — | NULL |
| TPA | TPA-60692 | 2026-05-11T06:48:02Z | Kimberly | — | Jimenez | 1952-12-05 | UHC-97816-87 | — | UNKNOWN | — | 9412 Ocean Ave | Denver·· | CO | 80249·· | null·· | — |
| TPA | TPA-55039 | 2026-03-29T07:53:35Z | Montgomery, Ben | — | — | 2002-01-13 | — | - | — | NULL | 1185 Central Avenue | Glendale | AZ | 85306-2886 | GRP-6266 | MEDICARE-ADV-A |
| TPA | TPA-57366 | 2026-07-21T21:37:08Z | Sandra | — | Vega | 1949-12-23 | UHC-13934-86 | •••-••-4745 | (478) 592-5746 | — | 2681 LAKE VIEW RD | Glendale | AZ | 85370 | null | — |
| TPA | TPA-57479 | 2026-02-24T11:22:34Z | Santiago | — | Lynch | 1998-06-15 | - | — | — | UNKNOWN | 2281 River Road | Las Vegas | NV | 89117 | GRP-2235 | UNKNOWN |
| TPA | TPA-62439 | 2026-03-21T17:30:26Z | Sara | — | Fuller·· | 1981-12-28 | — | - | - | sara.fuller@outlook.com | 7171 Sage Ct | Atlanta | GA | 30308 | UNKNOWN | UNKNOWN |
| TPA | TPA-61709 | 2026-06-25T16:10:35Z | AIGAIL | — | LE | 1969-03-21·· | — | - | ·702-842-4762 | abigail.le14@yahoo.com | 1183 MESA DR | Denver | CO | 80294 | UNKNOWN | MEDICARE-ADV-A |
| TPA | TPA-50755 | 2026-06-30T15:56:43Z | James, Camila | — | — | 1990-08-22 | — | — | +1 912 616 8583 | NULL | 5779 Lincoln Way | CHARLOTTE | NC | 28261 | UNKNOWN | - |
| TPA | TPA-62921 | 2026-08-08T05:24:53Z | Henry, Ronald | — | — | 2006-08-23 | UHC-15188-94 | •••-••-2928 | NULL | N/A | 8751 Park Pl | Chandler | AZ | 85202 | null | N/A |
| TPA | TPA-58088 | 2026-03-17T17:03:37Z | kelly | H. | richardson | 1959-01-18 | NULL | null | - | — | 1166 Sunset Blvd | ATLANTA | GA | 30394 | ·GRP-3759 | NULL |
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:38.469Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty