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-63128 | 2026-10-01T23:36:30Z | Shirley | — | Cunningham | 1973-12-10 | null | •••-••-9431 | 594-940-5444·· | shirley.cunningham60@icloud.com | 3784 Central Avenue | Seattle | WA | 98167 | GRP-2692 | null |
| TPA | TPA-58858 | 2026-04-06T11:57:16Z | KIMBERLY | — | REYNOLDS | 1995-06-10 | UHC5325311 | •••-••-6292 | 807-907-0095 | ·kimberly.reynolds@proton.me | 5724 Elm St | ·AUSTIN | TX | 78741 | GRP-6577 | — |
| TPA | TPA-56345 | 2026-08-30T23:28:17Z | SARA | — | HARPER | 1994-03-15 | N/A | •••-••-2383 | null | - | NULL | null | — | — | - | — |
| TPA | TPA-54368 | 2026-10-05T10:31:46Z | Nicole | — | Hayes | 1939-04-16 | UHC-32516-68 | — | — | NULL | 695 APACHE BLVD Apt 28 | Plano | TX | 75090 | — | OPTIONS-PPO |
| TPA | TPA-56085 | 2026-09-09T12:04:34Z | cooper | — | carl | 1961-11-02 | — | •••-••-0317 | (595) 251-7734 | UNKNOWN | 7817 Maple Avenue | Denver | CO | 80294·· | ···· | UNKNOWN |
| TPA | TPA-62691 | 2026-07-11T07:51:40Z | KIMBERLY | U | SPENCER | 12/11/1982 | — | null·· | UNKNOWN | — | 7814 MESA DR | Orlando | FL | ·32824 | — | — |
| TPA | TPA-60274 | 2026-02-24T02:03:34Z | Madison | — | Kelly | May 25, 1952 | UHC2005454 | UNKNOWN·· | NULL | null | 5238 SAGE CT | NASHVILLE | TN | N/A | null·· | ·NULL |
| TPA | TPA-61139 | 2026-07-27T08:03:22Z | ALEXANDER | — | FOWLER | 1963-20-01 | — | — | (617) 511-6671 | N/A | — | UNKNOWN | NULL | null | GRP-3667 | ·null |
| TPA | TPA-54854 | 2026-03-21T11:56:36Z | Kimberly E | — | Duncan | 7/10/1999 | NULL | — | null | kimberly.duncan@gmail.com | 6835 Jefferson Ave | Jacksonville | FL | 32284·· | — | CHOICE-PLUS-PPO |
| TPA | TPA-64081 | 2026-05-15T13:52:07Z | Logan | U | ·Flores | 1967-12-06 | — | •••-••-1848 | 6116988988 | UNKNOWN | 7165 Sunset Boulevard | SACRAMENTO | CA | 95876 | GRP-5813 | UNKNOWN |
| TPA | TPA-57094 | 2026-05-09T03:36:07Z | Marcus | — | Valdez | 1994-01-05 | — | NULL | NULL | — | — | - | — | N/A | NULL | — |
| TPA | TPA-62166 | 2026-02-25T05:57:50Z | Mariana | — | Owens | 1998-06-24 | - | UNKNOWN | 519-898-1877 | — | 6172 Ocean Avenue | ORLANDO | FL | 32836 | GRP-5780 | - |
| TPA | TPA-53605 | 2026-02-17T03:57:58Z | MICHAEL | — | WALLACE | 1939-08-27 | UHC-31536-42·· | UNKNOWN | (380) 619-2914 | - | 1586 Cedar Ln | LOS ANGELES | ·CA | 90049 | GRP-5680 | NULL |
| TPA | TPA-62160 | 2026-04-08T07:12:00Z | Taylor, Elizabeth | — | — | 1988-03-18 | — | NULL | 9989076 | null | 9091 Forest Ave | Gilbert | AZ | 85237 | — | SELECT-EPO |
| TPA | TPA-61294 | 2026-04-03T05:17:23Z | rachel | — | griffin | 1958-07-06 | UHC-00904-38 | N/A | NULL·· | — | 3033 Camelback Rd | Tampa | FL | 33643 | UNKNOWN | NULL |
| TPA | TPA-63376 | 2026-08-29T08:33:17Z | Terry·· | — | Payne | ·2007-04-07 | — | — | — | TERRY.PAYNE@GMAIL.COM | 1535 Apache Boulevard | Atlanta | GA | 30323 | — | — |
| TPA | TPA-56321 | 2026-04-25T10:06:41Z | angela | — | woods | 08/26/1977 | — | N/A | UNKNOWN | — | 3702 Central Avenue | ·Los Angeles | CA | 90047·· | null | UNKNOWN |
| TPA | TPA-61383 | 2026-02-14T09:35:56Z | JONATHAN | — | REED | 09/05/2006 | ···· | — | 641.917.9846 | NULL | ·1453 VALLEY VIEW DR | Dallas·· | TX | 75208-1957 | GRP-2354 | null |
| TPA | TPA-59107 | 2026-08-26T06:22:03Z | Cheryl | — | Woods | 03-05-1941 | NULL | — | 7933716474 | CHERYL.WOODS49@HOTMAIL.COM | 3117 Union Street | Plano | TX·· | 75005 | — | null |
| TPA | TPA-54274 | 2026-01-14T03:17:49Z | HIROSHI | — | RICE | 1947-09-04 | UNKNOWN | •••-••-8954 | - | N/A | 5783 Oak Street | Jacksonville | FL·· | — | null | NULL |
| TPA | TPA-56485 | 2026-06-11T18:17:58Z | Tyler | — | Jones | 21-04-1946 | — | — | - | ·UNKNOWN | 4500 Indian School Road | Phoenix | Arizona | 85069-4524 | N/A | — |
| TPA | TPA-59776 | 2026-07-24T09:38:26Z | NANCY | — | AUSTIN | 1950-10-02 | — | null | N/A | — | 3707 VALLEY VIEW DR #833 | Austin | TX | N/A | GRP-6758 | null |
| TPA | TPA-59093 | 2026-09-04T06:53:57Z | VIRGINIA | — | WATKINS | 11-05-2004 | UHC-81608-06 | N/A | 564.372.4116 | N/A | 8207 Oak Street | DALLAS | TX | 75296 | ·GRP-7708 | CORE-HMO |
| TPA | TPA-53499 | 2026-07-04T13:45:45Z | SHIRLEY | — | SANDOVAL | Jul 17, 2007 | — | •••-••-8065 | NULL | ·shirley.sandoval@hotmail.com | - | - | ·- | NULL | — | UNKNOWN |
| TPA | TPA-59792 | 2026-01-15T14:03:04Z | AMBER | — | WARD | 04/19/08 | — | — | — | N/A | 1260 Willow Ct | Austin·· | TX | N/A | ···· | SELECT-EPO |
| TPA | TPA-62192 | 2026-01-07T17:28:06Z | WILLIAM | — | COOK·· | 2730-20-02 | null | •••-••-1364 | — | william.cook66@gmail.com | 221 Baseline Road | Seattle | WA | 98135 | — | — |
| TPA | TPA-60249 | 2026-08-17T20:55:00Z | ·Mark | — | Hunt | 1997-06-20 | ·UNKNOWN | — | - | mark.hunt@gmail.com | 1061 MARKET ST | Houston | TX | 77034 | null | — |
| TPA | TPA-58001 | 2026-08-10T19:49:15Z | ZACHARY | — | ALLEN | 1976-03-16 | UHC-86497-60 | — | ·null | — | 6378 Willow Ct·· | Eden Prairie | MN | 55386 | UNKNOWN | — |
| TPA | TPA-61111 | 2026-01-06T16:16:31Z | BRYAN·· | — | MORGAN | 1998-03-16 | null | — | +1 395 222 6884 | ·NULL | ·9619 Maple Ave | ·Los Angeles | CA | 90072·· | GRP-0655 | null |
| TPA | TPA-50489 | 2026-01-13T22:33:10Z | HANNAH·· | ···· | PADILLA | 1982-06-18 | UHC-70306-47 | ·· | - | - | 1746 Spring Street | DALLAS | TX | NULL | N/A | — |
| TPA | TPA-57069 | 2026-01-14T14:53:05Z | michelle | — | taylor | 2003-11-02 | N/A | — | — | — | 9367 Park Place | Tucson | AZ | 85790 | GRP-8761 | — |
| TPA | TPA-58146 | 2026-03-23T03:50:38Z | Arthur | — | Gray·· | 1972-04-02 | — | - | UNKNOWN | ·arthur.gray75@aol.com | 7246 CHURCH STREET | Tempe | AZ·· | 85221 | — | MEDICARE-ADV-A |
| TPA | TPA-55484 | 2026-04-15T21:33:38Z | Ward, Joseph | — | — | 19570424 | N/A | NULL | 513.406.1525 | NULL | 6443 Bayshore Drive | Glendale | AZ | 85367 | NULL | MEDICARE-ADV-A |
| TPA | TPA-57088 | 2026-09-30T06:40:18Z | Arjun | — | ·Torres | 1986-04-21 | — | N/A | 797-826-8816 | arjun.torres16@icloud.com | 4920 Cedar Ln | Orlando | FL | — | GRP-8115 | null |
| TPA | TPA-52517 | 2026-01-29T07:16:37Z | ELIZABETH | B | WILLIAMSON·· | 1965-10-08 | — | UNKNOWN | 17927588074 | - | 2551 SUNSET BOULEVARD | San Antonio | TX | 78293 | GRP-5805 | SELECT-EPO |
| TPA | TPA-61669 | 2026-01-27T01:15:20Z | ARTHUR·· | — | HOLMES | 10/16/1979 | — | - | 400.583.4862 | null | 6471 MEADOW LANE | Austin | TX | 78734 | null | N/A·· |
| TPA | TPA-57609 | 2026-08-07T19:55:51Z | Andrea | — | Anderson | 9/25/1945 | — | — | — | NULL | 1436 Cedar Ln | San Antonio | Texas | 78250 | — | NULL |
| TPA | TPA-59772 | 2026-04-19T20:42:15Z | Christina | — | Payne | 11/02/44 | null | null | — | christina.payne87@icloud.com | ·N/A | null | N/A·· | — | - | null |
| TPA | TPA-53515 | 2026-08-01T09:21:49Z | Joshua | — | Hayes | 13-04-1956 | - | - | 591-858-4128 | null | 3463 Mountain View Drive | San Diego | CA | 92149 | GRP-1321 | null |
| TPA | TPA-62295 | 2026-02-15T18:25:01Z | Nicholas | — | West | Jan 12, 1984 | NULL | — | 239-501-8715 | NICHOLAS.WEST@PROTON.ME | 5521 Grand Avenue | Fresno | CA | 93776 | GRP-9386 | CORE-HMO |
| TPA | TPA-55472 | 2026-03-03T02:30:51Z | heather | — | simmons | ·19591001 | ·null | NULL | — | UNKNOWN | 839 Central Avenue | Sacramento | CA | 95812 | GRP-3363 | ···· |
| TPA | TPA-57317 | 2026-06-02T21:46:00Z | Margaret | S | ·Cole | 1973-09-02 | UHC-65282-20 | NULL | +1 433 317 4026 | N/A | — | — | ·null | — | — | OPTIONS-PPO |
| TPA | TPA-55496 | 2026-05-16T20:53:07Z | JANICE | — | GUTIERREZ | Sep 18, 1975 | - | ···· | NULL | — | ·666 LINCOLN WAY | Phoenix | AZ | — | — | OPTIONS-PPO |
| TPA | TPA-50358 | 2026-07-27T21:15:09Z | David | — | Taylor | 08/27/1956 | UHC-80641-10 | •••-••-0619 | null | — | 4578 Baseline Rd | Jacksonville | ·FL | 32221 | GRP-9183 | null |
| TPA | TPA-53677 | 2026-10-06T02:27:21Z | SOPHIA | — | BROOKS | 2/26/2005 | UHC-28019-56 | •••-••-5478 | 6015276943 | SOPHIA.BROOKS@HOTMAIL.COM | 7594 HIGHLAND AVE | COLUMBUS | ·OH | 43232 | GRP-4784 | NAVIGATE-HMO |
| TPA | TPA-54543 | 2026-05-24T13:25:55Z | Brian | — | Hall | 1946-06-06 | UHC-70681-11 | •••-••-1191 | UNKNOWN | NULL | 7724 RIDGE RD #458 | Dallas | TX | 75281 | UNKNOWN | ·OPTIONS-PPO |
| TPA | TPA-58125 | 2026-06-14T17:09:07Z | CAROL | ·· | COOK | 1973-12-02 | UHC4769712 | — | 14766456400 | carol.cook@hotmail.com | 9188 CENTRAL AVE | Nashville | TN | — | — | null |
| TPA | TPA-64102 | 2026-09-07T09:58:23Z | Williamson, Frances | — | — | 12/8/1960 | — | - | 9629396617 | — | 3123 MOUNTAIN VIEW DRIVE | Nashville | TN | 37278 | GRP-6367 | — |
| TPA | TPA-57980 | 2026-06-15T14:25:34Z | Marcus | — | Stephens | 2007-12-18 | — | •••-••-4193 | 12804886964 | marcus.stephens@gmail.com | 5019 Mesa Drive | Columbus | OH | 43295 | GRP-6415 | core-hmo |
| TPA | TPA-54093 | 2026-07-24T18:27:49Z | ahmed | T. | le | 06/10/03 | — | UNKNOWN | +1 252 929 6783 | — | 8017 Indian School Road Apt 26 | Tucson | AZ | 85742 | ·- | — |
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.709Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty