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-56625 | 2026-07-06T08:01:21Z | Danielle | — | Kelley | 2003-01-07 | NULL | — | N/A | - | 3285 FOREST AVE | Fresno | CA | 93715 | ···· | null |
| TPA | TPA-57898 | 2026-05-09T15:22:11Z | Thomas | — | Hamilton | 1948-05-17 | UHC-56407-31 | UNKNOWN | 888-878-2186 | — | 3220 BAYSHORE DR #433 | Eden Prairie | MN | 55323 | N/A | null |
| TPA | TPA-58868 | 2026-03-25T04:02:22Z | julia | — | rice | ·1993-04-10 | — | null·· | null | - | 2155 Valley View Dr | Fresno | CA | 93782 | - | OPTIONS-PPO |
| TPA | TPA-62511 | 2026-04-08T15:44:15Z | gary | Q | schultz | 1974-05-01 | — | — | (743) 939-0164 | — | 2035 Jefferson Ave | TUCSON·· | Arizona | 85747 | GRP-5065 | N/A |
| TPA | TPA-56554 | 2026-06-20T18:50:11Z | Scott·· | — | Gibson | 11/03/66 | N/A | ·UNKNOWN | (463) 585-8937 | NULL | — | - | - | N/A | NULL | — |
| TPA | TPA-56918 | 2026-09-18T23:18:11Z | Dunn, Camila | — | — | 2007-12-05 | — | •••-••-7613 | 430-754-1468 | — | 3918 Palm Dr | Minneapolis | MN | 55448 | — | MEDICARE-ADV-A·· |
| TPA | TPA-64410 | 2026-06-29T12:19:39Z | MARY | ·· | FOSTER | 1978-06-27 | UHC-70030-68 | •••-••-6131 | (967) 259-3697 | N/A | 4855 MESA DR #101 | San Diego | CA | UNKNOWN | NULL | N/A |
| TPA | TPA-62297 | 2026-07-13T05:44:37Z | Sean | — | Patel | 6/9/1995 | null | — | — | UNKNOWN | 4719 Camelback Road | GLENDALE | AZ | 85365·· | null | — |
| TPA | TPA-60464 | 2026-01-03T21:15:32Z | Dennis·· | — | Alvarez | 1979-08-21 | - | — | +1 958 773 9772 | — | 3110 Desert Sky Boulevard | Plano | ·Texas | 75063 | ·· | — |
| TPA | TPA-64147 | 2026-05-27T06:50:34Z | wayne | ·· | li | 1960-01-10 | null | UNKNOWN | +1 618 461 4168 | WAYNE.LI@OUTLOOK.COM | 7279 Mountain View Dr Apt 10 | Jacksonville | FL | 32265 | — | — |
| TPA | TPA-59009 | 2026-08-01T08:57:56Z | christina | — | armstrong | 1977-06-05 | — | •••-••-1679 | 667.560.6643 | christina.armstrong@hotmail.com | 7060 PARK PLACE·· | LAS VEGAS | NV | 89113 | NULL | NULL |
| TPA | TPA-59834 | 2026-07-29T16:31:47Z | Grace | — | Ryan | 6/28/1973 | N/A | — | NULL | grace.ryan@outlook.com | 9392 Highland Avenue | MESA | AZ | 85210 | — | null |
| TPA | TPA-51284 | 2026-07-04T23:05:38Z | Sarah | X | Oliver | 07/09/1994·· | UHC-54619-49 | — | N/A | — | 1962 Market Street | Minneapolis | MN | — | NULL | UNKNOWN |
| TPA | TPA-60811 | 2026-02-25T00:59:09Z | Justin | G | Bowman·· | Nov 1, 1980 | UHC-62449-29 | UNKNOWN | +1 666 324 2365 | UNKNOWN | 1535 Washington St | AUSTIN·· | TX | 78731 | GRP-3415 | N/A |
| TPA | TPA-58193 | 2026-07-18T05:03:16Z | SEAN·· | — | ADAMS | 1968-12-24 | uhc-01130-29 | •••-••-7072 | ·835-762-6925 | sean.adams36@yahoo.com | 6127 Indian School Road | Los Angeles | CA | 90001 | N/A | MEDICARE-ADV-A·· |
| TPA | TPA-52285 | 2026-04-24T04:36:39Z | DOROTHY | — | GRAY | 1945-08-20 | - | — | +1 797 663 4776 | NULL | 9607 Meadow Lane | Las Vegas | NV | 89155 | GRP-6117 | null |
| TPA | TPA-59890 | 2026-07-26T06:53:51Z | theresa | — | ·franklin | 1944-11-18 | ·- | UNKNOWN | 404-686-2638 | null | 7509 Willow Court | SEATTLE | wa | 98149 | null | NULL |
| TPA | TPA-55040 | 2026-05-16T16:20:56Z | CHARLES | — | JENKINS | 1979-12-05 | UHC-25820-18 | — | UNKNOWN | charles.jenkins@aol.com | UNKNOWN | — | N/A | NULL | ···· | NAVIGATE-HMO |
| TPA | TPA-53018 | 2026-04-28T12:19:34Z | STEEV | — | MEER | 09/17/1999 | — | •••-••-5954 | — | steven.meyer27@gmail.com | — | UNKNOWN | - | — | null·· | UNKNOWN |
| TPA | TPA-50716 | 2026-08-10T19:44:54Z | Judy | — | Schultz | 1971-11-05 | NULL | — | null | -·· | 3200 Ridge Road | Minneapolis | MN | 55458 | GRP-9513·· | OPTIONS-PPO |
| TPA | TPA-58644 | 2026-05-22T17:37:50Z | ANDREA | ·· | ROBERTSON | 1954-08-24 | UHC-65909-09 | null·· | 965-942-6712 | andrea.robertson34@yahoo.com | 3123 Lake View Rd | Columbus | OH | 43254 | N/A | — |
| TPA | TPA-56117 | 2026-03-19T05:53:11Z | CAROL | — | BURTON | 1984-02-02 | NULL | •••-••-4197 | UNKNOWN | carol.burton@outlook.com | 5385 Broadway | Orlando | FL | 32807-8975 | GRP-7305 | null |
| TPA | TPA-59918 | 2026-02-08T00:51:58Z | Victoria | — | Robertson | 1946-04-04 | UHC-63552-87 | •••-••-9640 | 734-897-6315 | null | null | null | N/A | — | — | — |
| TPA | TPA-53192 | 2026-03-14T18:45:48Z | Ryan | V. | Wagner | 19591211 | — | •••-••-9261 | (736) 446-5106 | — | 7438 Highland Ave | San Diego | CA | 92172 | — | N/A |
| TPA | TPA-51551 | 2026-04-11T13:52:25Z | donald | — | hill | 9/21/1968 | - | — | - | — | null | NULL | — | — | - | SELECT-EPO |
| TPA | TPA-63681 | 2026-07-26T18:07:33Z | SEAN | — | BROWN | 2003-10-25 | null | •••-••-5230 | 364-405-1614 | — | 9064 JEFFERSON AVE | ·FRESNO | CA | 93735 | GRP-6105 | SELECT-EPO |
| TPA | TPA-57887 | 2026-01-17T05:44:06Z | Reid, Alexander | — | — | 2/16/1978 | — | — | — | N/A | 4432 Lake View Rd | Austin | TX | 78712 | GRP-0718 | — |
| TPA | TPA-61042 | 2026-07-16T02:35:02Z | Tyler | — | Jenkins | 19991006 | — | - | — | NULL | 7396 RIDGE ROAD | FRESNO | California | 93743 | — | ·UNKNOWN |
| TPA | TPA-59950 | 2026-04-08T09:04:34Z | PAUL | — | THOMAS | 19760320 | — | — | - | paul.thomas42@hotmail.com | 5585 Grand Avenue | Las Vegas | NV | 89192 | GRP-5878 | - |
| TPA | TPA-53107 | 2026-08-30T18:09:30Z | HENRY | — | RODRIGUEZ | 19380503 | N/A | null | — | null | 5598 Jefferson Ave | Jacksonville | FL | 32243-6698 | - | CHOICE-PLUS-PPO |
| TPA | TPA-53653 | 2026-06-19T12:30:55Z | Katherine | — | Black | ·06/08/1972 | NULL | — | 5484514222 | - | 5352 Mesa Drive | HOUSTON | TX | 77079 | NULL | NULL |
| TPA | TPA-63261 | 2026-03-13T18:22:24Z | Richard | S. | Murray | 5/2/2000 | - | •••-••-2415 | — | ···· | 958 PINE DR | ·Seattle | WA | 98187·· | GRP-4622 | MEDICARE-ADV-B |
| TPA | TPA-58971 | 2026-01-21T16:11:14Z | Tran, Gloria | — | — | 1945-05-04 | ·· | NULL | - | - | 403 Lake View Rd | Tampa | FL | — | GRP-4659 | N/A |
| TPA | TPA-64107 | 2026-09-06T19:49:16Z | RUSSELL | — | SCOTT | ·Jul 6, 2006 | NULL | — | 582-215-7597 | null | 6832 LAKE VIEW RD | Houston·· | TX | 77045 | null | ·UNKNOWN |
| TPA | TPA-64181 | 2026-03-04T02:44:51Z | Anthony | — | Ramos | 8/25/1970 | — | •••-••-5642 | — | — | — | NULL | NULL | - | N/A | null |
| TPA | TPA-56936 | 2026-10-15T03:21:23Z | Gabriel·· | ···· | ·Hawkins | 1949-12-22 | - | NULL | 864-341-9326 | gabriel.hawkins@hotmail.com | 3579 DESERT SKY BLVD | San Antonio | TX·· | 78217 | — | MEDICARE-ADV-B |
| TPA | TPA-61154 | 2026-08-06T05:02:12Z | diane | ·S | moore | 1940-11-02 | UNKNOWN | •••-••-9520 | (490) 647-0638 | — | 3407 Desert Sky Blvd | Chandler | AZ | 85296 | GRP-0920 | CORE-HMO |
| TPA | TPA-63864 | 2026-09-28T19:01:22Z | Steve | — | Mason | 02/10/47 | N/A | - | null | NULL·· | 5786 Church Street | AUSTIN | TX | 78721 | ·GRP-9326 | - |
| TPA | TPA-55084 | 2026-10-11T02:28:37Z | Yuki | ·· | Hays | 11/25/1978 | UNKNOWN | UNKNOWN | 774.284.7603 | NULL | 2971 Grand Ave | ORLANDO | FL·· | 32890 | - | CORE-HMO |
| TPA | TPA-52664 | 2026-04-03T01:50:03Z | maria | — | garcia | 07/16/1947 | NULL | - | NULL | UNKNOWN | 7132 Sage Ct | Tempe | AZ | UNKNOWN | UNKNOWN | ·- |
| TPA | TPA-51474 | 2026-03-10T23:56:32Z | Stone, Emily | — | — | 1960-03-28 | — | ·UNKNOWN | N/A | — | 2674 Baseline Road·· | LOS ANGELES | CA | 90076 | - | — |
| TPA | TPA-53425 | 2026-02-08T19:23:49Z | Benjamin | — | Webb | 1967-03-24 | N/A·· | null | — | UNKNOWN | 9584 HILLCREST ROAD | San Diego | CA | 92173 | GRP-1550 | — |
| TPA | TPA-56598 | 2026-05-27T02:10:43Z | Gregory | E | Garza | 23-12-1941 | NULL | — | - | ·null | 6168 Broadway | Jacksonville | FL | ·32258 | NULL·· | — |
| TPA | TPA-62729 | 2026-09-19T08:24:27Z | Betty | — | Stephens | 12/15/06 | N/A | •••-••-3441 | - | - | 2735 LINCOLN WAY | Atlanta | GA | 30337 | GRP-0690 | - |
| TPA | TPA-53264 | 2026-02-08T16:53:59Z | SHIRLEY | — | WALSH | 2/11/1970 | - | •••-••-0149 | — | - | 4744 Lincoln Way | Sacramento | CA | 95852 | null | — |
| TPA | TPA-55283 | 2026-07-20T23:45:47Z | Julie | — | Bowman | 2000-07-07 | - | •••-••-5742 | 8705186046 | null·· | 23 Desert Sky Blvd | Houston | TX | 77066-4690 | NULL | ·null |
| TPA | TPA-61624 | 2026-10-02T01:55:19Z | alexander | M. | young | ·5/28/1952 | — | — | 4902003656·· | UNKNOWN | 5866 MAIN STREET | Plano·· | Texas | 75072 | — | MEDICARE-ADV-A |
| TPA | TPA-57198 | 2026-07-21T22:28:18Z | HNRY | — | WILLIAMSON | 19750706 | — | -·· | ·907-257-4414 | — | 989 Main Street | MESA | AZ | ·85239 | GRP-6991 | N/A |
| TPA | TPA-60838 | 2026-01-22T06:15:11Z | Diana | — | Castro | 10/11/77 | — | null | — | — | 2172 OCEAN AVENUE·· | ORLANDO | FL | 32838 | ·UNKNOWN | null |
| TPA | TPA-61422 | 2026-05-26T06:49:42Z | Matthew | — | Bowman | 1992-11-25 | — | •••-••-2925 | 307-523-1472 | N/A | 4383 PALM DRIVE | Miami | fl | 33143 | ·- | SELECT-EPO |
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:00.233Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty