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-54008 | 2026-03-07T06:29:46Z | Steven | ···· | Johnson·· | null | — | ·N/A | N/A | null | 5694 Union St | Chandler | AZ | 85244-9628 | — | SELECT-EPO |
| TPA | TPA-63635 | 2026-02-03T16:11:46Z | MICHAEL | A | PADILLA | 1982-03-20 | N/A | •••-••-3331 | null | null | 8386 Pine Drive | Miami | FL | 33136 | - | — |
| TPA | TPA-58038 | 2026-07-10T05:19:57Z | STEVEN | — | TAYLOR | 2003-03-25 | UNKNOWN | - | 844-753-3790 | - | 9165 PALM DRIVE | Gilbert | AZ | 85258 | GRP-7820 | — |
| TPA | TPA-62291 | 2026-02-16T00:29:07Z | DYLAN | — | COLE | 2004-07-01 | UHC-93588-47 | — | null | NULL | 6513 Cedar Lane | ·Phoenix | ·AZ | 85086 | GRP-8895 | - |
| TPA | TPA-61495 | 2026-01-07T08:35:59Z | ralph | ·· | jacobs | 1968-07-08 | UHC-62536-21 | NULL | ·+1 972 906 5834 | ralph.jacobs@icloud.com | 5925 JEFFERSON AVE | Los Angeles | CA | 90039 | GRP-4352 | null |
| TPA | TPA-59212 | 2026-07-19T02:37:02Z | Kayla·· | — | Tucker | 1958-05-12 | uhc-60897-29 | null | — | NULL | 5351 Desert Sky Blvd | Las Vegas | NV | 89133 | — | — |
| TPA | TPA-53974 | 2026-09-06T19:09:13Z | gloria U | — | — | 1978-12-18 | - | ·null | — | — | 9333 Hillcrest Rd | MINNEAPOLIS | MN | 55493 | GRP-2452 | N/A |
| TPA | TPA-59522 | 2026-07-17T14:12:44Z | Santiago | — | Perkins | 1972-01-21·· | UHC-86977-19 | — | 2417300455 | N/A | 172 Jefferson Avenue | Glendale | AZ | 85363 | null | OPTIONS-PPO |
| TPA | TPA-58108 | 2026-02-21T14:23:55Z | Brittany | — | ·Feguson | 19601114 | — | •••-••-9560 | - | N/A | ·8443 VALLEY VIEW DRIVE | Fresno | CA | 93729 | GRP-1328 | SELECT-EPO |
| TPA | TPA-63396 | 2026-03-01T23:37:32Z | Lauren | — | West·· | 4/3/1986 | N/A | •••-••-1841 | 970.912.2698 | null | N/A | N/A | — | — | NULL | — |
| TPA | TPA-57685 | 2026-01-03T10:37:07Z | Ralph | — | ·Yang | 02-10-1950 | - | •••-••-9183 | 8738964927 | UNKNOWN | 4177 SUNSET BLVD | Tucson | AZ | 85770 | N/A | — |
| TPA | TPA-61652 | 2026-01-08T00:33:55Z | John | — | Padilla | 19910322 | null | •••-••-9802 | 624-946-2986 | john.padilla@proton.me | 6058 Ocean Avenue·· | Tucson | AZ | 85798 | NULL | NULL |
| TPA | TPA-52516 | 2026-03-04T17:49:21Z | Elizabeth | — | Williamosn | 1965-10-08 | — | null | — | NULL | 2551 SUNSET BOULEVARD | San Antonio | TX | 78293 | — | NULL |
| TPA | TPA-50466 | 2026-07-18T08:11:01Z | HAROLD | — | LAWSOON | 2007-10-22 | — | •••-••-0731 | N/A | HAROLD.LAWSON20@AOL.COM | 4766 Bayshore Drive | San Antonio | Texas | 78291 | UNKNOWN | — |
| TPA | TPA-52954 | 2026-09-04T05:31:40Z | Bryan·· | — | Espinoza | 1994-09-02 | N/A | — | - | — | 1947 LINCOLN WAY | CHANDLER | Arizona | 85275 | UNKNOWN | ·null |
| TPA | TPA-57667 | 2026-01-15T15:29:13Z | PAUL | — | ·WOODS | 2007-09-24 | - | •••-••-7614 | UNKNOWN | UNKNOWN | UNKNOWN | N/A | null | null | - | medicare-adv-b |
| TPA | TPA-58681 | 2026-07-14T02:07:53Z | christine | — | morgan | 9/1/2007 | - | NULL | NULL | UNKNOWN | 469 Pine Dr | AUSTIN | TX | 78759 | GRP-4094 | OPTIONS-PPO |
| TPA | TPA-56894 | 2026-07-10T05:00:32Z | Ashley | — | Kelley | 1990-07-03 | — | UNKNOWN | UNKNOWN | — | 9283 Indian School Road | SAN DIEGO | California | 92129 | — | — |
| TPA | TPA-59977 | 2026-08-03T20:35:11Z | Fisher, Doris | — | — | 12/25/99 | NULL | N/A | 308-211-5052 | N/A | 3931 Oak St Apt 4 | GLENDALE | AZ | 85376 | GRP-3673 | NULL |
| TPA | TPA-60528 | 2026-06-23T20:45:20Z | Matthew | — | Ryan·· | 1949-09-01 | — | ·N/A | NULL | MATTHEW.RYAN76@ICLOUD.COM | 5530 Forest Avenue | LAS VEGAS | NV | 89158 | -·· | — |
| TPA | TPA-53696 | 2026-02-27T00:50:17Z | MARILYN | — | REYNOLDS·· | 1945-06-15 | ·· | — | 18509682835 | null | 5503 Central Avenue | Orlando | FL·· | 32865 | GRP-7718 | — |
| TPA | TPA-63904 | 2026-02-05T23:50:57Z | DEBORAH | — | SULLIVAN | 27-10-1976 | NULL | •••-••-7773 | +1 939 363 7306 | — | 6154 Sage Ct | Orlando | FL | 32871 | GRP-9660 | SELECT-EPO |
| TPA | TPA-54341 | 2026-05-07T16:50:59Z | Jensen, Tommy | — | — | 1993-10-28 | null | ·· | +1 433 990 3320 | NULL | 2508 MAPLE AVENUE | Mesa | AZ | 85243-9247 | GRP-1811 | — |
| TPA | TPA-56718 | 2026-10-16T08:25:13Z | Frank | — | Price | 1939-07-26 | null | •••-••-6866 | — | NULL | 2566 Jefferson Ave | Denver | CO | 80200 | NULL | — |
| TPA | TPA-51976 | 2026-02-28T00:12:22Z | sofia | — | lynch | 1995-01-03 | - | null | N/A | NULL | 2142 MEADOW LANE | Dallas | TX | 75270 | — | — |
| TPA | TPA-58030 | 2026-01-18T12:27:02Z | Noah | — | Wallace | 1952-12-09 | UHC-53723-54 | NULL | 7054127 | UNKNOWN | 3878 Main Street | Minneapolis | MN | 55470 | ·GRP-7504 | ·NAVIGATE-HMO |
| TPA | TPA-61347 | 2026-06-05T14:39:10Z | Emily | — | Knight | Apr 13, 1985 | null | •••-••-4330 | — | — | 7278 HARBOR BOULEVARD | Jacksonville | FL | — | NULL | N/A |
| TPA | TPA-53786 | 2026-02-26T15:48:39Z | KYLE | — | VEGA | 1943-01-08 | UHC-33957-43 | N/A | (476) 318-2938 | - | 7308 Harbor Boulevard | Miami | Florida | 33134 | UNKNOWN | — |
| TPA | TPA-60539 | 2026-08-03T20:31:31Z | ·VICTORIA | G. | SMITH | 1974-10-14 | null | •••-••-6113 | N/A | — | 9563 River Road | Los Angeles | CA | 90017 | — | ·null |
| TPA | TPA-53403 | 2026-06-20T04:15:16Z | Ronald | — | Moore | 1995-01-08·· | - | UNKNOWN | 698-828-9544 | N/A | null | N/A | null | N/A | N/A | NULL |
| TPA | TPA-54728 | 2026-05-15T15:19:45Z | JUDY | — | MARITN | Jul 26, 1977 | N/A | null | 928-811-1335 | ···· | 9886 Highland Ave | Gilbert | AZ | - | ·N/A | — |
| TPA | TPA-50073 | 2026-06-27T10:50:38Z | Sean | V. | Cook | 03/16/84 | — | •••-••-5235 | — | — | UNKNOWN | N/A | — | — | GRP-4499 | N/A |
| TPA | TPA-59980 | 2026-10-08T19:55:16Z | JONATHAN | — | ALEXANDER | 2001-11-14 | NULL | NULL | N/A | null | 1803 Willow Ct #197 | Las Vegas | NV | 89134-1880 | N/A | — |
| TPA | TPA-51442 | 2026-01-08T06:29:44Z | EVELYN | — | MONTGOMERY | 1980-09-25 | N/A | •••-••-5422 | (380) 710-2392 | evelyn.montgomery@aol.com·· | 3702 Valley View Drive | Eden Prairie | ·MN | 55379-0843 | GRP-5226·· | — |
| TPA | TPA-50883 | 2026-01-25T12:28:42Z | mateo | — | carter | 19730809 | UNKNOWN | null | null | mateo.carter37@proton.me | 2383 BASELINE RD | SEATTLE | WA | ·98132 | null | - |
| TPA | TPA-51099 | 2026-02-26T05:30:03Z | Santiago | — | Rojas | ·1960-01-07 | NULL·· | — | 349-649-4190·· | UNKNOWN·· | 594 Mountain View Dr | ·Dallas | TX | 75279 | GRP-1709 | null |
| TPA | TPA-64308 | 2026-04-19T00:38:20Z | JUZTIN | L. | CRUZ | 1944-09-18 | N/A | •••-••-1016 | NULL | - | 2917 Ridge Road Apt 1·· | San Antonio | TX | 78273 | UNKNOWN | NULL |
| TPA | TPA-58497 | 2026-01-24T23:01:52Z | Maria | — | Moore | 15-11-1962 | — | •••-••-6230 | — | null | 7527 Canyon Road | Minneapolis | MN | 55472 | NULL | SELECT-EPO |
| TPA | TPA-59798 | 2026-01-30T17:17:39Z | KAYLA | — | ·WALSH | 1967-03-10·· | UHC-98490-89 | •••-••-3743 | null | — | 8522 LAKE VIEW ROAD | Tucson | AZ | 85705 | null | UNKNOWN |
| TPA | TPA-63477 | 2026-01-24T00:30:08Z | ·BRENDA | — | LITTLE | 1942-01-25 | N/A | N/A | null | null | N/A | — | — | — | GRP-5188 | SELECT-EPO |
| TPA | TPA-54774 | 2026-01-15T19:43:01Z | Sofia | — | Ryan | 01/16/48 | - | •••-••-2135 | N/A | NULL | 6638 SPRING STREET | Tempe | Arizona | ·NULL | — | SELECT-EPO |
| TPA | TPA-56588 | 2026-09-30T17:48:36Z | Amanda | — | Parker | Feb 27, 1947·· | — | •••-••-7257 | N/A | N/A | 2487 Apache Boulevard | Denver | CO | 80204 | NULL | SELECT-EPO |
| TPA | TPA-57668 | 2026-08-06T21:02:53Z | Kathy | — | Burns | 1992-03-25·· | N/A | — | (600) 903-0851·· | kathleen.burns@aol.com | 6715 Cedar Ln | Plano | TX | 75028 | GRP-8945 | null |
| TPA | TPA-55750 | 2026-04-06T18:31:05Z | RIVERA | — | BARBARA | 1996-04-26 | N/A | - | NULL | ·- | 3211 MAIN STREET | Plano | TX | 75077 | GRP-3314 | MEDICARE-ADV-A |
| TPA | TPA-59013 | 2026-01-16T05:48:42Z | Hernandez, Alice | — | — | 06-10-1987 | NULL | null | — | NULL | 4948 Sage Ct | NASHVILLE | TN | 37211-7699 | null | — |
| TPA | TPA-59063 | 2026-05-06T11:03:01Z | Camila | — | Hart | 1953-08-18 | UHC-37443-96 | •••-••-6371 | — | UNKNOWN | 4743 Camelback Rd | Fresno | CA | ·93734 | GRP-0938 | - |
| TPA | TPA-63757 | 2026-05-21T08:37:30Z | Kenneth | ·· | Ryan·· | 1938-12-17 | NULL | N/A | null | N/A | 5284 Washington Street | Atlanta | GA | 30339 | N/A | NULL |
| TPA | TPA-51555 | 2026-08-10T12:59:50Z | Denny | — | Powell | 1977-07-24 | ·· | ·- | NULL | N/A | 8141 Main Street | Tucson | AZ | 85765-1738 | null·· | MEDICARE-ADV-B |
| TPA | TPA-56122 | 2026-04-26T10:18:01Z | JULIA | X. | CUNNINGHAM | 1954-05-28 | — | null | UNKNOWN | — | 3668 Spring Street | Austin | TX | ·78725 | — | N/A·· |
| TPA | TPA-55799 | 2026-10-03T08:57:19Z | Nathan | — | Fernandez | 1993-03-22 | UNKNOWN | - | 591-992-3960 | N/A | 5278 RIVER ROAD | Jacksonville | FL | 32247·· | N/A | — |
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.465Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty