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-56986 | 2026-04-02T04:24:59Z | nancy | — | hansen | 1986-12-04 | — | - | (862) 952-2455 | nancy.hansen@gmail.com | 2091 RIDGE RD | Minneapolis | MN | 55420-1802 | UNKNOWN | null |
| TPA | TPA-57337 | 2026-09-29T03:29:10Z | Kyle | — | Olson | 19470301 | UHC-95004-65 | — | 578-723-8091 | null | 5525 APACHE BOULEVARD | Mesa | AZ | - | NULL | NAVIGATE-HMO |
| TPA | TPA-55848 | 2026-05-10T08:28:19Z | Martin, Amy | ···· | — | Jul 4, 1982 | — | •••-••-3737 | UNKNOWN | — | - | N/A | NULL | ·null | UNKNOWN | NAVIGATE-HMO·· |
| TPA | TPA-53834 | 2026-07-02T19:45:55Z | Noah | K | Carroll | 1986-11-02 | -·· | •••-••-8968 | — | — | 9547 Sage Ct | ·AUSTIN | TX | 78758 | NULL | ·CHOICE-PLUS-PPO |
| TPA | TPA-59749 | 2026-01-04T21:35:25Z | Natalie·· | ·· | Thomas | 03/08/1946 | ·NULL | •••-••-7398 | ···· | N/A | 9790 Hillcrest Road·· | Tampa | FL | - | — | - |
| TPA | TPA-57632 | 2026-02-02T20:56:57Z | marilyn | — | ·holms | 8/12/1944 | — | null | — | — | — | NULL | — | NULL | N/A | NULL |
| TPA | TPA-58057 | 2026-02-08T18:22:20Z | ANNA | W | ·MJIA | 1953-01-17 | UHC-23558-66 | - | null | — | 8238 BROADWAY | Tucson | AZ | 85782 | GRP-1818 | NULL |
| TPA | TPA-61818 | 2026-09-05T01:43:54Z | Rebekca | — | Mendoza | 2000-63-10 | UHC-41468-60 | N/A | 869.639.0034 | REBECCA.MENDOZA@PROTON.ME | 9585 Baseline Road | Houston | TX | 77094 | N/A·· | — |
| TPA | TPA-54921 | 2026-08-20T09:30:22Z | Peter | — | McCoy | ·20000402 | - | — | ·N/A | - | 3108 Desert Sky Blvd | Columbus | OH | 43270 | — | NULL |
| TPA | TPA-62352 | 2026-01-06T16:45:11Z | Jacobs, Ruth | X | — | 10-07-2004 | — | — | 517-650-5849 | null | ·· | - | N/A | — | N/A | ·CORE-HMO |
| TPA | TPA-61226 | 2026-01-15T20:09:10Z | LARRY | — | MENDOZA | ·1992-09-08 | — | •••-••-2898 | 943-446-2190 | N/A | 2548 WILLOW COURT | ·Orlando | FL | 32809 | GRP-2801 | — |
| TPA | TPA-57190 | 2026-03-20T17:13:02Z | Hiroshi | — | Hudson | 1986-10-26 | — | — | UNKNOWN | hiroshi.hudson24@aol.com | 6665 Washington St | Orlando | FL | 32842 | N/A | null |
| TPA | TPA-59435 | 2026-10-10T03:38:19Z | Ralph | — | Jimenez | 1989-07-12 | — | •••-••-7381 | — | ralph.jimenez@gmail.com | 5171 DESERT SKY BLVD | Los Angeles | CA | 90063 | — | — |
| TPA | TPA-62350 | 2026-10-13T22:55:13Z | Young, Christine·· | I | ···· | 10/4/1978 | N/A | — | N/A | NULL | 8138 Spring St | Tampa | FL | 33618 | GRP-6504 | — |
| TPA | TPA-55201 | 2026-08-29T03:49:19Z | Henry | ·· | Yang | 1987-12-03 | null | •••-••-0897 | - | — | 4104 Highland Avenue | DALLAS | TX | 75298 | N/A | — |
| TPA | TPA-58824 | 2026-01-25T13:53:55Z | Turner, Staven | ···· | — | ·1940-04-27 | UNKNOWN | •••-••-6080 | — | steven.turner@hotmail.com | 7023 RIVER ROAD | Gilbert | AZ | - | NULL | — |
| TPA | TPA-50116 | 2026-08-17T09:03:50Z | Alexandder | — | Medina | 1962-10-09 | UHC-92974-96 | N/A | ·- | alexander.medina@icloud.com | 3388 Forest Ave | Atlanta | GA | 30372 | N/A | null |
| TPA | TPA-55004 | 2026-10-14T12:11:54Z | Peter | — | Edwards | 1948-09-12 | UNKNOWN | null | 377.431.6210 | NULL | 6925 Pine Dr #517 | MESA | AZ | 85257 | N/A | CHOICE-PLUS-PPO·· |
| TPA | TPA-60981 | 2026-10-01T10:48:25Z | Debra | R.·· | Knight·· | Apr 27, 1992 | null | •••-••-5793 | - | NULL | 4546 Church Street | Tampa·· | FL | 33644 | ·UNKNOWN | - |
| TPA | TPA-62952 | 2026-04-25T19:38:17Z | Rahel | — | Reynolds | 1966-07-05 | UNKNOWN | •••-••-0091 | - | rachel.reynolds@hotmail.com | 9197 Cedar Ln | Atlanta | GA | 30369 | null | - |
| TPA | TPA-50713 | 2026-07-18T16:19:00Z | Marquez, Charles | — | — | 5/9/1991 | — | - | +1 567 565 2015·· | CHARLES.MARQUEZ34@AOL.COM | 357 Willow Ct·· | MIAMI | FL | 33145 | N/A | — |
| TPA | TPA-53875 | 2026-10-09T19:22:58Z | Alan | — | Cole | 6/25/1977·· | N/A | — | ·NULL | — | 4335 Ocean Avenue | Mesa | AZ | 85295 | N/A | — |
| TPA | TPA-55320 | 2026-07-24T21:48:46Z | Julia | — | Wells | 1952-11-04 | UNKNOWN | •••-••-2666 | null | NULL | 1572 Jefferson Avenue | SCOTTSDALE | AZ | 85210 | NULL | - |
| TPA | TPA-59805 | 2026-03-27T17:32:57Z | Lisa | — | Ferguson | 1965-10-13 | — | — | NULL | null | 4972 Cedar Ln | Eden Prairie | Minnesota | 55370 | N/A | ·- |
| TPA | TPA-62941 | 2026-08-11T09:26:31Z | Lucia | — | Ellis | Sep 15, 1972 | — | — | — | NULL | 1316 Sage Court | Chandler | AZ | 85252 | GRP-0260 | ·· |
| TPA | TPA-53043 | 2026-02-13T19:44:12Z | Kelly | ·· | Griffin | 1952-07-16 | null | — | 14939397936 | kelly.griffin@icloud.com·· | 7750 Canyon Road | Mesa | AZ | 85231 | null | — |
| TPA | TPA-63316 | 2026-05-29T06:30:04Z | john·· | — | mattthews | ·08/27/1957 | UHC-47617-95 | •••-••-8653 | NULL | — | — | - | UNKNOWN | UNKNOWN | GRP-9140 | NAVIGATE-HMO |
| TPA | TPA-58793 | 2026-08-20T06:21:06Z | KATHRYN | ···· | HARVEY | 19390606 | — | NULL | N/A | - | 5744 River Rd | Dallas | TX | null | N/A | NAVIGATE-HMO·· |
| TPA | TPA-53741 | 2026-05-04T09:37:16Z | VINCENT | J | STEVENS | Oct 5, 1975 | null | •••-••-0180 | — | VINCENT.STEVENS37@GMAIL.COM | 1528 Baseline Road | Sacramento | CA | 95845 | - | NAVIGATE-HMO |
| TPA | TPA-60987 | 2026-07-13T21:12:16Z | HENRY | — | FISHER | 06/18/05 | NULL | •••-••-7387 | UNKNOWN | N/A | ·409 PARK PL | ·Atlanta | GA | 30388 | GRP-4848 | — |
| TPA | TPA-53887 | 2026-06-10T02:28:26Z | Anthony | — | Vega | 1968-08-01 | ···· | null | 6212547981 | UNKNOWN | 49 Sage Ct | CHARLOTTE | NC | 28292 | NULL | — |
| TPA | TPA-61998 | 2026-08-31T12:54:03Z | lauren | — | hoffman | 1940-07-25·· | UNKNOWN | •••-••-5396 | — | - | 1201 Meadow Ln | Jacksonville | ·fl | 32203 | GRP-5457 | ·MEDICARE-ADV-B |
| TPA | TPA-61911 | 2026-05-20T10:04:00Z | JACK | — | HENRY | 2007-09-06 | - | ·· | 253-575-8250 | — | — | — | — | - | NULL | CHOICE-PLUS-PPO |
| TPA | TPA-64436 | 2026-10-05T07:30:35Z | JACOB | — | ·WAGNER | 08/08/1987 | UNKNOWN | •••-••-1408 | — | null | 6552 Cedar Ln | DENVER | Colorado | 80239 | GRP-7316 | — |
| TPA | TPA-59254 | 2026-06-21T04:18:15Z | JESSICA | ·· | CARTER | 19770802 | UHC-74848-26 | NULL | 18954134479·· | jessica.carter33@proton.me | 2230 Hillcrest Road | Phoenix | AZ | 85044-3379 | NULL | N/A |
| TPA | TPA-53377 | 2026-06-20T11:32:05Z | Walter | — | Spencer | 19730320 | N/A | - | 975-929-6763 | walter.spencer@icloud.com | 8981 Valley View Dr | Chandler | AZ | 85228 | — | OPTIONS-PPO |
| TPA | TPA-50351 | 2026-08-22T05:05:25Z | Matthew | — | Brown | 1973-10-21 | UNKNOWN | •••-••-6800 | 464-462-4267 | — | 4028 Mesa Dr | Austin | tx | 78773·· | GRP-5909 | — |
| TPA | TPA-52483 | 2026-04-25T06:42:34Z | joyce | — | lewis | 1998-12-24 | N/A | — | null | JOYCE.LEWIS85@HOTMAIL.COM·· | 908 RIVER RD | TEMPE | Arizona | 85266 | N/A | — |
| TPA | TPA-55073 | 2026-04-09T12:08:39Z | Linda | — | Smith | 1989-09-17 | — | •••-••-6889 | +1 890 945 0678 | UNKNOWN | 6905 Hillcrest Road | Tempe | AZ | 85222 | — | — |
| TPA | TPA-60617 | 2026-10-09T16:32:33Z | George, Edward | — | — | 1983-06-17 | UNKNOWN | NULL | — | null | 3180 Elm Street | AUSTIN | TX | 78742 | NULL | — |
| TPA | TPA-59079 | 2026-05-04T12:06:28Z | Janet | M | Price | 19710818 | — | - | UNKNOWN | janet.price@gmail.com | 2581 Broadway | Tucson | AZ | 85708 | — | SELECT-EPO |
| TPA | TPA-62893 | 2026-06-25T04:51:22Z | Sara | — | Romero | 1961-01-11 | — | ·- | null | SARA.ROMERO25@HOTMAIL.COM | 1684 Market St | Tucson | Arizona | 85734 | GRP-0785 | null |
| TPA | TPA-51922 | 2026-02-14T16:02:16Z | GREGORY | — | JENSEN | 2005-08-16 | UNKNOWN | N/A | 6088586740 | ·· | — | UNKNOWN | — | - | UNKNOWN | CHOICE-PLUS-PPO |
| TPA | TPA-51747 | 2026-05-06T00:13:28Z | Virginia | — | Watkins | 2001-06-02 | - | •••-••-8531 | UNKNOWN | N/A | NULL | — | ·N/A | — | — | null |
| TPA | TPA-63967 | 2026-02-08T07:36:40Z | Kathleen | — | Duncan | 11/23/1977 | UNKNOWN·· | •••-••-7200 | — | ···· | 8069 UNION ST | TEMPE | AZ | 85237 | GRP-3342 | UNKNOWN |
| TPA | TPA-52936 | 2026-02-11T22:28:22Z | VIRGINIA | — | HOFFMAN | 1947-09-20 | UNKNOWN | — | UNKNOWN | — | 4417 Spring St | Plano | TX | 75000-3762 | GRP-2246 | MEDICARE-ADV-B |
| TPA | TPA-61997 | 2026-04-23T20:03:19Z | Lauren | — | Hoffman | 1940-07-25 | UNKNOWN·· | •••-••-5396 | NULL | UNKNOWN | 1201 Meadow Ln | ·Jacksonville | FL | 32203 | N/A | MEDICARE-ADV-B·· |
| TPA | TPA-56123 | 2026-07-19T01:13:27Z | Berry, Mateo | — | — | 1954-09-13 | null | — | ·(438) 881-7133 | mateo.berry@hotmail.com | 3004 Hillcrest Road | Las Vegas | NV | 89159 | NULL | SELECT-EPO |
| TPA | TPA-52949 | 2026-10-08T18:35:58Z | Terry | — | Hansen | 1942-07-22 | NULL | UNKNOWN | 13253685745 | terry.hansen@outlook.com | 1582 Spring Street | Seattle | ·WA | 98165 | — | NULL |
| TPA | TPA-52379 | 2026-06-15T07:15:24Z | CATHERINE | — | SINGH | 1967-05-16 | -·· | UNKNOWN | 340.795.8892 | — | - | — | null | null | — | UNKNOWN |
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.536Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty