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-63520 | 2026-01-27T13:45:09Z | HELEN | — | RYAN | 1998-10-21 | ···· | N/A | 6305830091 | N/A | 3533 Pine Drive | ·Atlanta | GA | 30366 | GRP-8518 | N/A |
| TPA | TPA-58510 | 2026-02-10T07:02:43Z | Judith | — | Garza | 1949-03-27 | N/A | N/A | NULL | - | 7413 Sunset Boulevard·· | Las Vegas | ·NV | 89118 | NULL·· | SELECT-EPO |
| TPA | TPA-55061 | 2026-03-27T14:11:00Z | joe | — | adams | May 4, 2008 | UNKNOWN | •••-••-4903 | 5666361327 | — | 2370 Canyon Road | Atlanta | GA | — | GRP-4495 | CHOICE-PLUS-PPO |
| TPA | TPA-51557 | 2026-07-10T06:36:24Z | Alan | — | Henderson | 1996-06-16 | ·- | •••-••-5099 | 942-929-8962 | — | 6293 Canyon Rd | SAN ANTONIO | TX | 78285-4324 | GRP-5937 | SELECT-EPO |
| TPA | TPA-56280 | 2026-08-18T03:24:32Z | HENRY | — | WELLS | 1994-05-08 | - | — | — | — | 7167 Highland Ave | Scottsdale | AZ | 85216-0832 | GRP-5691 | null |
| TPA | TPA-57969 | 2026-07-02T02:15:09Z | DAVID | E | LEWIS | 2006-06-05·· | null | NULL | — | NULL | 8861 Mesa Drive | Los Angeles | CA | ·90094 | N/A | CORE-HMO |
| TPA | TPA-53854 | 2026-04-02T04:06:38Z | ·Bruce | — | ·Fowler | May 8, 1938 | ·· | - | 3897636212 | N/A | 7225 Lincoln Way | Columbus | OH | 43213 | null·· | - |
| TPA | TPA-50136 | 2026-08-17T15:10:21Z | Christina | ·O | Gray | 06/23/1982 | ···· | — | (211) 618-3763 | null | 8282 CEDAR LN | ·Charlotte | NC | 28285 | - | OPTIONS-PPO |
| TPA | TPA-61098 | 2026-08-06T17:11:10Z | Rose, Ahmed | — | — | 1972-11-01 | UHC-11855-20 | null | UNKNOWN | — | 4535 Camelback Road | Seattle·· | ·Washington | N/A | GRP-8270 | OPTIONS-PPO |
| TPA | TPA-55503 | 2026-06-18T14:56:15Z | FRANCES | — | PAYNE | Oct 16, 1999 | NULL | •••-••-3919 | — | UNKNOWN | 325 DESERT SKY BLVD | San Diego·· | CA | 92113-6464 | UNKNOWN | — |
| TPA | TPA-61534 | 2026-07-13T11:29:36Z | Rebecca | — | Dunn | 1945-09-20 | — | — | 9863831536 | N/A | 3054 Harbor Blvd | Sacramento | CA | 95884 | — | OPTIONS-PPO |
| TPA | TPA-50745 | 2026-03-10T10:36:52Z | PRIYA | — | FULLER | 1954-10-08 | null | — | UNKNOWN | — | 3466 BAYSHORE DRIVE | Eden Prairie | MN | 55384 | — | N/A·· |
| TPA | TPA-55634 | 2026-04-15T22:49:54Z | SANTIAGO | — | DOMINGUEZ·· | 1998-11-18 | — | — | 312.393.5797 | N/A | 2418 Sunset Blvd | Seattle | WA | 98177-8461 | UNKNOWN | null |
| TPA | TPA-56134 | 2026-04-25T17:28:02Z | MADISON | ···· | HENDERSON | 6/23/1973 | — | •••-••-9351 | — | madison.henderson40@outlook.com | 7189 LAKE VIEW ROAD Apt 17 | PLANO | TX | 75015-2473 | - | UNKNOWN |
| TPA | TPA-64222 | 2026-04-07T02:47:12Z | dylan | ·· | castillo·· | 19961013 | NULL | null | — | — | 3459 Baseline Road | Scottsdale | AZ·· | 85273-8902 | null | null |
| TPA | TPA-51213 | 2026-03-10T11:36:55Z | Bruce | — | Ryan | 1978-05-26 | NULL | UNKNOWN | (763) 803-7725 | — | 7237 MOUNTAIN VIEW DR | Chandler | AZ | 85226 | - | MEDICARE-ADV-A |
| TPA | TPA-61702 | 2026-09-28T06:27:07Z | TERESA | — | ELLIOTT | 11/27/1939 | - | •••-••-9298 | null·· | - | 621 Grand Avenue·· | Gilbert·· | AZ·· | 85259-5454 | GRP-7645 | NULL |
| TPA | TPA-53327 | 2026-10-12T02:36:47Z | Betty | — | Tucker | 7/15/1958 | N/A | N/A | NULL | BETTY.TUCKER@GMAIL.COM | ·3595 Central Avenue | Tucson | AZ | 85789 | null | NAVIGATE-HMO |
| TPA | TPA-55598 | 2026-05-17T09:09:28Z | AMMBER | B | KENNEDY·· | 1969-02-27 | — | — | — | N/A | 1169 Apache Blvd | Los Angeles | CA | 90098 | - | UNKNOWN |
| TPA | TPA-62491 | 2026-05-02T10:33:51Z | Bobby | ·· | Gardner | 01/28/1994 | N/A | — | -·· | BOBBY.GARDNER@GMAIL.COM | ·5754 APACHE BLVD | ·Minneapolis | MN | 55491 | null | — |
| TPA | TPA-60720 | 2026-02-28T13:31:33Z | DIANE | D. | DOMINGUEZ | 8/6/1946 | — | — | — | NULL | 9605 Union Street | ·Sacramento | CA | 95862 | GRP-8725 | N/A |
| TPA | TPA-60166 | 2026-06-26T09:11:04Z | CHRISTINA·· | — | MILLS | 1988-03-10 | - | - | (697) 907-2831·· | N/A | 8171 RIDGE RD | Plano | TX | 75059-9327·· | UNKNOWN | CHOICE-PLUS-PPO |
| TPA | TPA-53648 | 2026-04-29T04:03:21Z | Alice B | — | Owens | 06/09/1997 | NULL | •••-••-7050 | - | NULL | — | null | — | — | — | — |
| TPA | TPA-50332 | 2026-08-18T07:41:16Z | Douglas | — | Morales | 19-08-1952 | UNKNOWN | UNKNOWN | 917-245-4353 | — | 2023 Maple Avenue | Gilbert | AZ | 85226-2951 | - | — |
| TPA | TPA-55923 | 2026-03-15T04:45:52Z | MARK | — | GUTIERREZ | 1973-08-10 | - | •••-••-5596 | (276) 886-7944 | UNKNOWN | 9527 Mesa Drive·· | ·Los Angeles | CA | 90069 | N/A | CORE-HMO |
| TPA | TPA-64138 | 2026-07-20T22:40:20Z | NICLOE | — | ARNOLD | 1953-06-26 | UNKNOWN | null | +1 937 557 1813 | — | UNKNOWN | null | N/A | N/A·· | null | - |
| TPA | TPA-55990 | 2026-08-09T22:43:34Z | SANDRA | — | WILLIAMSON·· | 1981-10-08 | UNKNOWN | — | (493) 942-5136 | UNKNOWN | 6358 Canyon Road | Mesa | AZ | 85240 | GRP-2750 | UNKNOWN |
| TPA | TPA-56431 | 2026-03-21T02:10:02Z | Henry | — | Pierce | 2006-12-27 | — | •••-••-5474 | - | — | 1170 Camelback Road | Jacksonville | fl | N/A | N/A | MEDICARE-ADV-A |
| TPA | TPA-51082 | 2026-09-01T15:40:23Z | jennifer | A | baker | 1957-02-01 | NULL | null | - | — | 5369 Lincoln Way | Columbus | OH | 43240 | GRP-0113 | OPTIONS-PPO |
| TPA | TPA-64384 | 2026-02-07T14:43:18Z | DENISE | C. | SULLIVAN·· | 1965-08-05 | ·· | — | (837) 794-4492 | denise.sullivan@aol.com | 7428 Lincoln Way Apt 36 | Chandler | AZ | 85272 | — | NULL |
| TPA | TPA-62035 | 2026-04-28T16:05:49Z | Alexander | W | King | 2/1/1974 | N/A | null | null | — | 2968 Main St | Phoenix | AZ | 85071-0910 | NULL | — |
| TPA | TPA-52061 | 2026-10-11T07:39:07Z | ·Carol | — | ·Henderson | 1948-10-16 | UHC1772327 | ···· | null | UNKNOWN | 2661 Cedar Lane Apt 1 | Los Angeles | CA | 90044 | N/A | ·NULL |
| TPA | TPA-60446 | 2026-04-28T18:38:40Z | Munoz, Brenda | — | — | ·1979-05-11 | null | UNKNOWN | UNKNOWN | - | 6309 PARK PL | San Antonio·· | TX | UNKNOWN | - | — |
| TPA | TPA-55411 | 2026-08-23T05:01:35Z | terry | — | elliott | 5/20/1980 | — | ···· | NULL | - | 6936 Willow Court | Tempe | AZ | 85260 | GRP-8058 | UNKNOWN |
| TPA | TPA-60808 | 2026-03-23T20:08:00Z | Peter | — | Hill | 17-12-1940 | null | null | 876.459.4172 | — | 1619 Central Ave #869 | Tucson | AZ | 85781-9604 | GRP-0270 | UNKNOWN |
| TPA | TPA-51989 | 2026-09-29T04:25:44Z | CARLOS | ···· | ·KNIGHT | 2005-07-06 | UHC-75286-40 | •••-••-6357 | null | carlos.knight13@icloud.com | 1993 Forest Ave | Plano | ·TX | 75014 | NULL | MEDICARE-ADV-A |
| TPA | TPA-63436 | 2026-08-23T12:54:25Z | ELIZABETH | — | PHILLIPS | 1968-02-25 | UHC-03120-55 | NULL | 3446768297 | ·· | ···· | NULL | ·· | NULL | GRP-1577 | NULL |
| TPA | TPA-59132 | 2026-08-22T09:13:19Z | MARIANA U | — | JACKSON | 11/20/1992 | UHC-36939-96 | N/A | 499-631-0529 | - | 8346 Palm Drive | Austin | tx | 78738 | ·UNKNOWN | — |
| TPA | TPA-63602 | 2026-01-29T13:17:49Z | douglas | — | sanders | 1958-07-23 | null | — | 4699400251 | UNKNOWN | 7638 Bayshore Dr | Atlanta | GA | 30371-3508 | null | CHOICE-PLUS-PPO·· |
| TPA | TPA-57989 | 2026-01-07T16:13:24Z | Mills, Margaret | ···· | — | 1980-01-24 | UHC-42099-41 | ···· | N/A | margaret.mills@hotmail.com | — | null | — | — | GRP-7453 | — |
| TPA | TPA-62913 | 2026-07-28T17:17:33Z | DENIEL | ···· | ALEXANDER | Mar 27, 1961 | — | — | 650-483-9090 | — | 100 Oak Street | NASHVILLE | TN | - | NULL | N/A |
| TPA | TPA-58324 | 2026-05-31T21:28:15Z | Paul | — | Jmenez | 1969-01-04 | null | — | ·(420) 739-1721 | — | NULL | — | — | — | UNKNOWN·· | N/A |
| TPA | TPA-59492 | 2026-08-21T14:23:35Z | Webb, Diana·· | — | — | 1967-05-27 | — | — | — | — | 5776 OAK STREET | Scottsdale | AZ | — | GRP-4269 | OPTIONS-PPO |
| TPA | TPA-50091 | 2026-02-19T22:55:10Z | Ranyd | E. | Luna | 1946-09-28 | — | — | (974) 804-7006 | — | 4881 JEFFERSON AVE | Gilbert | AZ | 85235 | — | — |
| TPA | TPA-63108 | 2026-08-24T10:44:54Z | Kevin | — | Burton | 1974-02-28·· | UNKNOWN | — | 884.608.1503·· | null·· | 6383 MOUNTAIN VIEW DR | Gilbert | AZ | 85246 | GRP-6733 | - |
| TPA | TPA-62338 | 2026-01-05T18:07:39Z | Chriistian | — | Bradley | 1979-08-23 | null | - | 983.429.8798·· | CHRISTIAN.BRADLEY@AOL.COM | 1535 Washington St | Houston | TX | 77068 | NULL | OPTIONS-PPO |
| TPA | TPA-51912 | 2026-09-14T01:34:47Z | Alexis | — | Edwards | 3/25/1976 | - | — | (286) 397-3708 | ALEXIS.EDWARDS@HOTMAIL.COM | 561 Indian School Road | San Antonio | TX | 78201 | NULL | N/A |
| TPA | TPA-57208 | 2026-08-06T21:37:13Z | ·Ramirez, Kimberly | — | — | 17-09-1961 | — | — | - | N/A | 8356 Park Pl | Dallas | TX | 75263 | — | ·- |
| TPA | TPA-52845 | 2026-01-28T09:15:32Z | LAURA | — | RYAN | 1993-01-22 | ···· | — | +1 350 748 2025 | UNKNOWN | 9430 SUNSET BOULEVARD | Charlotte | NC | 28259 | GRP-0997 | NAVIGATE-HMO |
| TPA | TPA-56399 | 2026-01-27T05:51:22Z | ARTHUR | — | GRAY | ·1972-11-04 | UHC-65090-47 | •••-••-3523 | 2637232270 | arthur.gray90@gmail.com | 2418 Desert Sky Boulevard | NASHVILLE | TN | 37259 | GRP-0375 | 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:40.636Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty