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-53601 | 2026-01-07T16:27:22Z | ANTHONY | — | TORRES | 10/14/1940 | — | — | 845.316.7535 | - | ·6430 Palm Dr | Sacramento | CA | 95812 | GRP-4868 | - |
| TPA | TPA-62004 | 2026-08-31T09:23:15Z | bryan | — | burke | 09/15/98 | ·· | NULL | — | NULL | 8698 Bayshore Dr | Dallas | TX | 75228 | GRP-8719 | UNKNOWN |
| TPA | TPA-55403 | 2026-03-22T08:38:29Z | DAVID | ···· | ·HANSEN | 2003-02-20 | - | null | NULL·· | - | 8251 Apache Boulevard | Jacksonville | FL | 32255 | null | null |
| TPA | TPA-62082 | 2026-06-17T02:32:33Z | MARIA | — | ·BRYANT | 11/22/1966 | - | •••-••-7759 | — | null | 756 Cedar Lane | Scottsdale | AZ | 85241 | GRP-7518 | NULL |
| TPA | TPA-58561 | 2026-04-29T10:41:29Z | — | Q | — | 2001-03-04 | UHC-59973-87 | •••-••-8921 | 643-569-3627 | — | ·4763 Church St Apt 38 | PLANO | TX | 75068-0600 | null | - |
| TPA | TPA-52671 | 2026-01-25T19:12:18Z | JOSE | — | RUIZ | 09/22/1939 | — | •••-••-4604 | N/A | — | 1145 Mountain View Dr | SACRAMENTO | CA | 95899 | — | NULL |
| TPA | TPA-56015 | 2026-04-21T11:26:26Z | stephanie | — | castillo | 07/09/1999 | null | UNKNOWN | null | N/A | UNKNOWN | — | N/A | null | - | — |
| TPA | TPA-60326 | 2026-03-16T21:58:01Z | Ana | ···· | Thomas | 1983-07-19 | - | - | UNKNOWN | — | 6256 Apache Blvd | Tampa | FL | — | UNKNOWN | OPTIONS-PPO |
| TPA | TPA-56736 | 2026-09-12T07:21:48Z | Bobby | J.·· | ·Daniels | 1959-10-15 | UHC-88164-37 | •••-••-3933 | 8419843081 | — | 2303 DESERT SKY BOULEVARD·· | Chandler | AZ | 85256-3329 | - | NULL |
| TPA | TPA-60967 | 2026-06-07T17:11:25Z | Kenneth | ···· | West | 1989-04-08 | — | — | UNKNOWN | null | 8925 PINE DR | ·Austin | Texas·· | NULL | — | — |
| TPA | TPA-50700 | 2026-07-23T07:59:21Z | Porter, Brandon | E. | — | ·22-04-1947 | UNKNOWN | •••-••-8000 | 757-597-6324 | - | 7764 Pine Dr | Miami | FL | 33165 | N/A | MEDICARE-ADV-A |
| TPA | TPA-54167 | 2026-01-20T17:37:26Z | Mason | M | Kelley | 1942-11-17 | ·NULL | •••-••-7643 | — | N/A | 7144 Bayshore Drive | MIAMI·· | FL | 33198 | NULL | CHOICE-PLUS-PPO |
| TPA | TPA-56314 | 2026-02-04T17:08:29Z | — | — | — | 1938-09-25 | NULL | •••-••-3252 | — | ARTHUR.WAGNER52@PROTON.ME | 9144 Desert Sky Blvd | Orlando·· | Florida | 32860 | NULL | — |
| TPA | TPA-53543 | 2026-03-09T10:01:48Z | Scott | — | Pena | 1993-10-14 | NULL | - | N/A | - | — | NULL·· | UNKNOWN | null | N/A | NAVIGATE-HMO |
| TPA | TPA-60730 | 2026-06-17T19:39:07Z | Ruiz, Henry | — | — | 1992-02-13 | UHC-11129-89 | •••-••-9162 | 19188487342 | null | 86 Bayshore Drive | San Antonio | TX | 78296 | GRP-7288 | — |
| TPA | TPA-54488 | 2026-02-11T23:14:53Z | Justin | — | Ruiz | 1975-08-01 | N/A | null | — | justin.ruiz25@icloud.com | 4997 Lake View Rd | Tempe | Arizona | 85219 | NULL | — |
| TPA | TPA-56646 | 2026-09-24T22:47:05Z | daniel | — | jacckson | 1951-11-21 | — | •••-••-5084 | 881-734-3579 | DANIEL.JACKSON@OUTLOOK.COM | 9136 Baseline Road | Denver | CO | 80242 | UNKNOWN | MEDICARE-ADV-B·· |
| TPA | TPA-62591 | 2026-03-21T23:41:18Z | Jose | — | Powell | 26-07-1975 | ···· | UNKNOWN | NULL | null | 8444 HIGHLAND AVE | Chandler | Arizona | ·85286 | GRP-9972 | — |
| TPA | TPA-53021 | 2026-09-01T12:17:02Z | Keith | — | Dixon | 2004-09-02 | -·· | UNKNOWN | 7757626439 | keith.dixon@outlook.com | 9147 Hillcrest Road | Fresno | CA | 93754 | GRP-9351 | SELECT-EPO |
| TPA | TPA-61888 | 2026-04-26T03:23:12Z | ·Alan | — | Gibson | 19880212 | N/A | •••-••-6770 | 8095223235 | N/A | 8041 Mesa Drive | Los Angeles | CA | 90051·· | GRP-0281 | NAVIGATE-HMO |
| TPA | TPA-56898 | 2026-05-28T05:49:25Z | AISHA | — | GORDON | 06/12/1975 | UHC-01782-66 | N/A·· | - | UNKNOWN | 1950 Canyon Rd | Chandler | AZ | — | GRP-3117 | — |
| TPA | TPA-56826 | 2026-08-08T21:28:16Z | PRIYA | ···· | RAY | 1962-05-28 | UHC-58523-45 | — | — | - | 7268 CEDAR LN | ·Gilbert | AZ | 85287 | — | NULL |
| TPA | TPA-56621 | 2026-05-31T23:31:43Z | Joseph | — | Dean | 7/20/1992 | null | •••-••-2901 | — | N/A | — | - | N/A | - | — | — |
| TPA | TPA-59955 | 2026-10-17T09:45:08Z | Billy | — | Bradley | 1998-05-18 | N/A | - | null | billy.bradley@hotmail.com | 2621 Palm Drive Apt 25 | ATLANTA | GA | 30374-3341 | N/A | MEDICARE-ADV-B·· |
| TPA | TPA-50125 | 2026-06-22T03:21:54Z | TOMMY | — | HOLMES | 1959-01-24·· | — | •••-••-9349 | UNKNOWN | UNKNOWN·· | — | — | N/A | — | — | NULL |
| TPA | TPA-53193 | 2026-05-01T19:35:52Z | Carr, Anna | ·F. | — | 1965-06-17 | NULL | -·· | N/A | anna.carr91@gmail.com | 6692 River Rd | Houston | TX | 77033 | N/A | ···· |
| TPA | TPA-59148 | 2026-05-02T14:20:07Z | Jensen, Jacob | — | — | 01/19/1942 | N/A·· | NULL | 423-732-6649 | NULL | 5608 Meadow Lane | Denver | CO | 80260 | ·null | ·· |
| TPA | TPA-62547 | 2026-04-12T16:04:45Z | Jeremy | — | Green | 9/19/1999 | — | NULL | 280-497-7407 | - | ·· | null | — | N/A | NULL·· | — |
| TPA | TPA-60478 | 2026-09-30T23:11:21Z | ANDREA | O. | GUZMAN | 1992-05-15 | UHC-33667-52 | ·null | 4386722012 | N/A | 4778 Sage Court | Tucson | Arizona | 85773 | NULL | — |
| TPA | TPA-63811 | 2026-03-05T03:50:22Z | EMILY | — | FOSTER | 1988-02-21 | UNKNOWN | — | UNKNOWN | null | 1701 Meadow Lane | Gilbert | AZ | 85282 | — | — |
| TPA | TPA-62897 | 2026-08-14T14:37:56Z | Bruce | Q. | Wilson | 2007-09-09 | NULL | ·· | N/A | bruce.wilson52@gmail.com | 2098 Baseline Rd | TAMPA | Florida | 33668 | NULL | null |
| TPA | TPA-55332 | 2026-06-25T19:27:12Z | anggela | — | evans | 2/20/1959 | UNKNOWN | — | NULL | UNKNOWN | 3391 Union St | Gilbert | AZ | 85232 | GRP-2565 | — |
| TPA | TPA-60284 | 2026-04-15T19:45:23Z | Yuki | — | Wright | 1986-02-22 | — | — | 9466835588 | yuki.wright@icloud.com | 9017 Pine Dr | JACKSONVILLE | Florida | ·32241 | N/A | NULL |
| TPA | TPA-57976 | 2026-01-25T07:17:02Z | aisha·· | — | hayes | 1948-06-25 | UHC-52123-64 | null | N/A | — | 5403 Lincoln Way | DALLAS | TX | 75274 | — | NULL |
| TPA | TPA-57419 | 2026-06-21T22:07:55Z | Weaver, Margraet | — | — | 1997-09-16 | — | N/A | - | UNKNOWN | 7606 Cedar Ln | San Diego | CA | 92116 | UNKNOWN | null |
| TPA | TPA-53981 | 2026-04-17T09:11:09Z | Terry | E | Owens | ·05/12/67 | N/A | null | (294) 209-9762 | ·null | 2368 CAMELBACK ROAD | Mesa | AZ | ·85231-9234 | null | — |
| TPA | TPA-64407 | 2026-06-10T13:56:03Z | richard | — | perry | Mar 20, 1964 | — | — | NULL | N/A | NULL | UNKNOWN | N/A | null | - | SELECT-EPO |
| TPA | TPA-55020 | 2026-03-24T11:38:08Z | MADISON | — | BARNES | 1974-01-07 | — | — | 17306893142 | N/A | 7739 Forest Avenue | Charlotte | NC | ·28228 | — | CORE-HMO |
| TPA | TPA-52647 | 2026-08-19T12:37:59Z | Mary·· | — | Garrett | 1997-05-15 | UHC-41408-06 | NULL | NULL | UNKNOWN | 5195 MAPLE AVE | Tempe | AZ | 85265-3731 | — | N/A |
| TPA | TPA-58440 | 2026-03-03T02:14:36Z | Martha | B. | Moorre | ·2008-06-02 | null | N/A | 9028019585 | — | — | UNKNOWN | N/A | — | null | N/A |
| TPA | TPA-58951 | 2026-01-05T15:42:22Z | George | — | Weaver | 19610313 | NULL | ·- | ·· | UNKNOWN | 6059 Bayshore Drive | San Antonio | TX | 78243 | — | NULL |
| TPA | TPA-57474 | 2026-07-16T07:15:04Z | bradley | — | sims | 2006-09-04 | N/A | •••-••-0351 | +1 797 386 4640 | — | 5554 Cedar Ln | ATLANTA | GA | 30300 | GRP-4336 | MEDICARE-ADV-B |
| TPA | TPA-58347 | 2026-03-03T23:16:47Z | Donna | — | Washington | 2003-04-25 | UHC-43146-50 | null | — | donna.washington@outlook.com | NULL | — | null | NULL | GRP-4453 | UNKNOWN |
| TPA | TPA-52052 | 2026-02-01T21:24:17Z | Margaret | ···· | Miller | Jan 12, 1941 | UHC-71305-12 | •••-••-2166 | 3995753322 | null | UNKNOWN | N/A | N/A | NULL | — | ·· |
| TPA | TPA-53251 | 2026-09-14T18:34:42Z | Madison | ···· | Moreno | Jan 4, 1969 | — | null | — | null | 3424 Jefferson Avenue | Fresno·· | ca | 93703 | — | — |
| TPA | TPA-52374 | 2026-03-02T17:56:48Z | Joshua | — | Hill | 6/1/1990 | UHC-62851-11 | — | 12524879032 | joshua.hill54@outlook.com | 1228 CENTRAL AVE | Seattle | WA | 98125 | — | N/A |
| TPA | TPA-52305 | 2026-06-18T07:34:08Z | ·dylan | — | hill | 1/21/1962·· | uhc-19089-37 | •••-••-1532 | 2656423198 | ···· | 5307 Valley View Drive | Charlotte | NC | 28251 | GRP-1348 | NAVIGATE-HMO |
| TPA | TPA-52924 | 2026-04-21T12:15:51Z | Deborah | — | Riley | 1947-04-26 | — | •••-••-1696 | NULL | deborah.riley@outlook.com | 1951 Lincoln Way | Atlanta | Georgia·· | 30315·· | ·UNKNOWN | — |
| TPA | TPA-50456 | 2026-02-26T05:30:30Z | JOAN | — | SMITH | 1972-11-20 | null | null | NULL | UNKNOWN | 248 Oak St | Seattle | WA | 98150 | N/A | UNKNOWN |
| TPA | TPA-54115 | 2026-03-11T05:47:04Z | Stone, Margaret | ·· | — | ·1979-11-12 | ·· | — | 15038517790 | — | — | — | — | null | GRP-8616 | - |
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:56.325Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty