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-59919 | 2026-05-22T00:41:07Z | Sara | — | Garrett | 1939-10-03 | N/A | •••-••-7318 | 882-564-3683 | null·· | N/A | — | UNKNOWN | — | GRP-7972 | — |
| TPA | TPA-63228 | 2026-05-12T17:59:10Z | Rachel | — | Fowler | 1983-05-20 | UHC-83408-02 | — | null | RACHEL.FOWLER@YAHOO.COM | 8542 Forest Ave | Minneapolis | MN | — | — | null |
| TPA | TPA-57163 | 2026-09-03T03:55:25Z | kathleen | — | johnston | 05-01-1964 | — | — | ·· | kathleen.johnston6@proton.me | - | UNKNOWN | — | N/A | - | ·- |
| TPA | TPA-51369 | 2026-10-16T07:21:17Z | Robert | — | Ross | 1940-05-01 | - | •••-••-6346 | +1 410 285 9911·· | N/A | — | ·null | NULL | - | UNKNOWN | UNKNOWN |
| TPA | TPA-63237 | 2026-07-18T18:23:30Z | Terry | ···· | Henderrson | 1940-10-05·· | UHC-17287-55 | •••-••-3465 | — | — | 6152 MEADOW LN | Minneapolis | MN | 55461 | GRP-0458 | — |
| TPA | TPA-58189 | 2026-09-02T04:13:45Z | BRYAN | — | BOWMAN | 1967-06-24 | N/A | NULL | N/A·· | bryan.bowman@proton.me | ·2395 Lake View Rd | Seattle | WA | 98184 | ·GRP-0497 | N/A |
| TPA | TPA-52482 | 2026-04-29T10:19:28Z | Wong | ·· | Laura | 1951-08-09 | - | •••-••-2510 | -·· | ·· | 4997 Meadow Ln | Sacramento | CA | 95867 | NULL | null |
| TPA | TPA-52416 | 2026-03-12T02:20:05Z | Emily | — | Martinez | 11-08-2004 | NULL | UNKNOWN | 678-673-6831 | — | 9266 Sage Ct | ORLANDO | FL | 32811 | NULL | -·· |
| TPA | TPA-63140 | 2026-05-07T08:12:37Z | Franklin, Lauren | — | — | 19541222 | N/A | UNKNOWN | UNKNOWN | LAUREN.FRANKLIN@AOL.COM | - | — | N/A·· | null | ·GRP-4369 | — |
| TPA | TPA-50811 | 2026-09-19T17:18:40Z | samuel | ···· | myers | 1979-04-02 | UHC-50709-05 | •••-••-2118 | ···· | UNKNOWN | 2560 Baseline Road | Fresno | California | 93772 | GRP-0640 | SELECT-EPO |
| TPA | TPA-63591 | 2026-04-10T02:54:25Z | Jerry | — | Knight | 1993-08-06 | - | N/A | NULL | jerry.knight@hotmail.com | 2251 Forest Avenue | Los Angeles | CA | 90032-6380 | UNKNOWN | MEDICARE-ADV-A |
| TPA | TPA-53906 | 2026-01-09T04:38:55Z | Brittany | — | Shaw | 7/24/1945 | NULL | •••-••-9575 | N/A | — | 3694 CHURCH STREET | Las Vegas | NV | 89127 | - | N/A |
| TPA | TPA-60852 | 2026-07-07T23:06:46Z | MASON | — | GARRETT | 1942-05-13 | - | — | 538.403.3079 | N/A | 2814 DESERT SKY BOULEVARD | Tucson | AZ | 85751 | — | NULL·· |
| TPA | TPA-63923 | 2026-03-29T15:21:26Z | Sophia | — | Gonzales | 04/12/44 | N/A | •••-••-3669 | ···· | — | 9811 Ocean Avenue | Minneapolis | MN | 55454 | GRP-3550 | N/A |
| TPA | TPA-61138 | 2026-07-05T08:59:15Z | Johnston, Matthew | — | — | 1963-11-09 | — | — | NULL | — | N/A·· | NULL | NULL | NULL | N/A | ···· |
| TPA | TPA-55397 | 2026-08-31T18:33:18Z | Joradn | D | Wheeler | 1954-09-25 | — | - | - | null | 9746 Mesa Drive | ·MESA | AZ | 85258 | — | null |
| TPA | TPA-57104 | 2026-10-18T09:07:43Z | theresa | — | hawkins | 2007-04-19 | N/A | •••-••-3240 | — | theresa.hawkins97@yahoo.com | NULL | — | UNKNOWN | - | - | — |
| TPA | TPA-55778 | 2026-07-15T01:17:28Z | austin | ·· | morgan | ·1982-12-01 | UHC-70663-96 | •••-••-6128 | 6709815 | AUSTIN.MORGAN@ICLOUD.COM | 6776 Sunset Boulevard | ·Chandler | AZ | 85258 | — | UNKNOWN |
| TPA | TPA-56764 | 2026-06-03T15:20:16Z | JANET | — | EDWARDS | 19650710 | — | NULL | 737.826.3478·· | NULL | 3833 Market Street | Scottsdale | AZ | — | ·· | NULL |
| TPA | TPA-53524 | 2026-02-27T10:25:22Z | christine | X | chen | 1943-01-02 | - | NULL | 9012937786 | null | 7525 APACHE BLVD | ·ATLANTA | GA | 30397 | GRP-7958 | null |
| TPA | TPA-54518 | 2026-09-24T20:46:07Z | JERRY | — | DEAN | 11/01/1942 | null | null | 413.817.3266 | ···· | 2630 Mesa Dr | Dallas | TX | ·75228 | - | - |
| TPA | TPA-56486 | 2026-05-26T01:44:42Z | CAROL·· | G | BISHOP | 15-06-1991 | - | •••-••-9026 | 2999235884 | ·- | 8981 CHURCH STREET | COLUMBUS·· | OH | 43232 | — | ·CHOICE-PLUS-PPO |
| TPA | TPA-61528 | 2026-04-05T10:44:22Z | EVELYN | — | ALVARADO | 1979-10-24 | — | — | — | — | 6542 Mesa Drive | San Antonio | TX | 78232 | GRP-8057 | MEDICARE-ADV-A |
| TPA | TPA-60757 | 2026-03-28T07:11:43Z | Gonzales, Jacob | N | — | 2003-01-01 | — | — | null·· | JACOB.GONZALES@ICLOUD.COM | ·· | — | ·· | UNKNOWN | NULL | MEDICARE-ADV-A |
| TPA | TPA-53266 | 2026-10-02T06:54:36Z | lawrence | — | li | ·1995-04-25 | — | — | 778-533-8097 | — | 2804 Cedar Lane | Phoenix | AZ | 85024 | N/A | MEDICARE-ADV-B |
| TPA | TPA-55741 | 2026-08-19T13:26:47Z | AMBER | — | WOOD | 1993-11-26 | UHC-35662-31 | null | (212) 237-3795 | — | — | — | — | — | GRP-9586 | CORE-HMO |
| TPA | TPA-52263 | 2026-06-26T14:22:38Z | BRIAN | — | FERNANDEZ | 1989-07-08 | null | null | NULL | UNKNOWN | UNKNOWN | NULL | - | NULL·· | — | N/A |
| TPA | TPA-59365 | 2026-07-27T13:17:49Z | Lawrence | — | Shaw | 10/26/68 | N/A | UNKNOWN | NULL | UNKNOWN | 1839 Ridge Rd | Columbus | OH | 43205-6472 | — | null |
| TPA | TPA-55578 | 2026-08-14T10:20:10Z | ·Luis | ···· | Lee | 04/28/65 | UHC-56887-73 | — | 5827180 | — | 7876 Bayshore Dr | Phoenix | AZ | 85075 | GRP-7019 | — |
| TPA | TPA-54945 | 2026-04-28T03:25:17Z | LAURA | — | ·COLEMAN | 1977-10-16 | — | — | (727) 742-6152 | UNKNOWN | 8086 WASHINGTON ST #220 | Houston | TX | 77027-6630 | NULL·· | NAVIGATE-HMO |
| TPA | TPA-61616 | 2026-08-01T22:02:35Z | ·Logan | — | ·Webb | 06/25/1979 | NULL | — | null | UNKNOWN | 8356 Jefferson Avenue | Plano | tx | 75056·· | — | SELECT-EPO |
| TPA | TPA-52428 | 2026-09-03T08:12:18Z | ·MARIANA | — | SANDERS | 1991-09-09 | N/A | NULL | 18117223521 | MARIANA.SANDERS7@OUTLOOK.COM | 2727 Willow Ct | Tempe | AZ | — | — | — |
| TPA | TPA-59620 | 2026-05-05T01:07:54Z | Stephanie | — | Campbell | 26-03-1952 | UNKNOWN | - | — | STEPHANIE.CAMPBELL48@OUTLOOK.COM | null | null | — | — | UNKNOWN·· | OPTIONS-PPO |
| TPA | TPA-56502 | 2026-10-13T16:03:39Z | Alice | — | Marquez | Jul 18, 1978 | — | null | — | — | 664 Oak Street | Jacksonville | Florida | 32229 | UNKNOWN | — |
| TPA | TPA-54661 | 2026-01-10T06:28:10Z | Carl | — | Long | 10/17/1982 | UHC-98459-44 | •••-••-4218 | 609-431-1303 | N/A | 4180 Maple Avenue | Orlando | FL·· | 32860·· | — | MEDICARE-ADV-B |
| TPA | TPA-56863 | 2026-01-20T10:46:37Z | Young, Theresa | ·· | — | 01/10/1940 | null | N/A | NULL | THERESA.YOUNG@OUTLOOK.COM | 97 Broadway·· | Sacramento·· | CA | 95843 | GRP-8491 | — |
| TPA | TPA-55970 | 2026-05-24T22:12:01Z | Philip | — | Lawson | 12/27/08 | ···· | •••-••-2826 | — | ···· | 8364 Main St | DALLAS | TX | 75217 | — | N/A |
| TPA | TPA-50933 | 2026-05-19T08:16:41Z | gary | — | munoz | 10/25/65 | NULL | •••-••-8179 | 737.601.8815 | - | 8538 Ocean Ave | Nashville | TN | 37225 | — | NULL |
| TPA | TPA-57906 | 2026-09-17T13:04:18Z | Emily | — | Luna | 09/28/39 | ·- | null | 8089212340·· | — | 4489 MARKET STREET Apt 36 | Denver | CO | 80299 | N/A | NULL |
| TPA | TPA-62058 | 2026-06-19T02:09:12Z | samuel | — | weaver | 1995-11-10 | UNKNOWN | •••-••-6396 | — | — | 7528 CENTRAL AVENUE | Mesa | AZ | 85233 | GRP-6892 | - |
| TPA | TPA-54966 | 2026-02-06T00:50:18Z | AMBER | — | YOUNG | 1990-08-06 | NULL | - | — | null | 5945 RIVER RD | Nashville | TN | 37218 | - | — |
| TPA | TPA-53740 | 2026-06-03T00:21:14Z | Kenneth | U. | Larson | 1982-07-22 | null | ·NULL | 3224386680 | — | 3899 CENTRAL AVENUE | Tempe | AZ | 85267 | — | NULL |
| TPA | TPA-59404 | 2026-08-19T23:22:19Z | Mason | L | Miller | 19551223 | NULL | — | 5818967848 | N/A | 825 Mountain View Dr | ·Houston | Texas | 77005 | — | — |
| TPA | TPA-60520 | 2026-07-17T15:50:48Z | Hamilton, John | ···· | — | 1939-02-07 | - | •••-••-5272 | 6365820436 | john.hamilton53@yahoo.com | 3945 Main St | Tucson | Arizona | 85749 | - | NULL·· |
| TPA | TPA-54177 | 2026-02-22T22:00:29Z | Ryan | — | Evans | 02/07/74 | - | •••-••-9491 | 6479882680 | N/A | 1580 Sunset Blvd | San Diego | CA | 92191 | GRP-2487 | NAVIGATE-HMO·· |
| TPA | TPA-52700 | 2026-04-07T00:31:25Z | Willie | — | Harrison | 04-05-1989·· | null | •••-••-8031 | 755-294-7311 | - | 9217 Bayshore Dr | Las Vegas | NV | 89105 | GRP-9592 | — |
| TPA | TPA-60991 | 2026-01-10T13:30:37Z | ·Amanda | ·· | Little | 02/07/1953 | — | •••-••-5553 | 424-273-9824 | — | 3360 Canyon Road | LAS VEGAS | Nevada | ·89116-1378 | NULL | NULL |
| TPA | TPA-59934 | 2026-02-05T14:46:11Z | JONATHAN | — | GARRETT·· | ·Feb 22, 1961 | — | -·· | 9173091687 | NULL | NULL | NULL | null | — | GRP-9474 | UNKNOWN |
| TPA | TPA-62971 | 2026-06-18T16:46:03Z | frank | — | carroll | ·4/13/1958 | - | — | — | ·null | 546 FOREST AVENUE | San Diego | CA | ·92108 | null | null |
| TPA | TPA-59103 | 2026-02-12T12:03:39Z | ASHLEY | W | WALKER | 1952-12-07 | N/A | NULL | — | — | 524 Indian School Road | Atlanta | Georgia | 30310-2165 | 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:43:03.435Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty