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-64108 | 2026-05-02T02:29:50Z | Cheryl | — | Gibson | 2006-02-01 | - | NULL | NULL | - | 6384 SUNSET BLVD | Sacramento | CA | 95819 | null | NULL |
| TPA | TPA-56400 | 2026-08-01T14:46:53Z | Julia | F.·· | Vasquez | 1965-12-05 | — | - | — | julia.vasquez@proton.me | ·7887 Indian School Road | Minneapolis | MN | 55436 | null | UNKNOWN |
| TPA | TPA-58646 | 2026-04-25T08:03:46Z | VALENTINA | — | SANTIAGO | 1994-10-02 | — | - | NULL | — | 5323 Broadway | Las Vegas | Nevada | 89175 | NULL | N/A |
| TPA | TPA-62667 | 2026-07-07T09:23:05Z | RICHARD | ·· | RILEY | 19610711 | UNKNOWN | — | — | N/A | 3721 Mesa Dr | Tucson | AZ | 85728 | GRP-8393 | N/A |
| TPA | TPA-55331 | 2026-04-03T22:38:43Z | ·michael | — | mills | 1943-11-05 | NULL·· | N/A | 636-935-8509 | - | 5025 HIGHLAND AVENUE | Las Vegas | NV | - | — | — |
| TPA | TPA-53061 | 2026-07-28T18:07:31Z | NATALIE | C. | GREENE | 1994-06-18·· | — | — | — | - | 2081 Apache Boulevard | JACKSONVILLE | FL | 32259 | UNKNOWN | null |
| TPA | TPA-60718 | 2026-07-05T05:12:52Z | Marcus | — | Myers | 1989-08-13 | — | — | - | — | 95 Lake View Rd | Tucson | AZ | 85700 | N/A | — |
| TPA | TPA-59464 | 2026-04-24T06:57:06Z | Christopher | I | ·Jackson | 13-04-1959 | UHC6979347 | null | — | N/A | 4347 Meadow Lane | AUSTIN | TX | 78768 | - | - |
| TPA | TPA-56557 | 2026-05-10T05:28:00Z | ELIZABETH | — | GEORGE | 1960-05-24 | — | — | 6874665661 | elizabeth.george@hotmail.com | UNKNOWN | — | null | NULL·· | GRP-4558 | ·OPTIONS-PPO |
| TPA | TPA-53671 | 2026-09-03T04:02:39Z | Nicholas | — | OBrien | Sep 2, 1958 | ·null | •••-••-5787 | — | NULL | 4628 Sunset Boulevard Apt 9 | Las Vegas | NV | 89125 | null | CHOICE-PLUS-PPO |
| TPA | TPA-50312 | 2026-02-12T19:50:22Z | Elizabeth·· | — | Bailey | 7/17/1991 | UHC-28857-39 | — | ···· | elizabeth.bailey@icloud.com | 2559 MAIN STREET | Dallas | TX | 75202 | — | — |
| TPA | TPA-54410 | 2026-05-15T08:23:33Z | HENRY | — | HARPER | 10/15/1952 | — | •••-••-5323 | 15493534447 | HENRY.HARPER@YAHOO.COM·· | 3110 Desert Sky Blvd | Charlotte | NC | 28206 | GRP-3711 | — |
| TPA | TPA-63205 | 2026-09-15T07:52:13Z | ANA | ·Y | MKCOY | 1965-09-24 | UHC-95888-71 | •••-••-8355 | UNKNOWN | - | 2208 HIGHLAND AVE | San Diego | CA | 92192 | ·GRP-6253 | null |
| TPA | TPA-63049 | 2026-07-13T17:30:30Z | Betty | H | Marshall | 1957-11-08 | NULL | — | UNKNOWN | ···· | 9766 Mesa Dr Apt 17 | Gilbert | AZ | 85212 | NULL | UNKNOWN |
| TPA | TPA-50899 | 2026-02-19T05:23:35Z | Lawrence, Daniel | — | — | 1978-07-10 | UNKNOWN | ···· | 872-669-8499 | — | 8162 Spring Street | Plano | TX | 75004 | null | ·- |
| TPA | TPA-54388 | 2026-03-03T21:54:46Z | Christina | — | Howell | 1939-09-22 | UHC2035610 | — | N/A | N/A | 6124 Mesa Drive | ·Tempe | AZ | 85271 | NULL | -·· |
| TPA | TPA-50889 | 2026-07-09T09:08:05Z | Thomas | — | Harvey | 1944-03-05 | N/A | null | — | - | UNKNOWN | ···· | — | UNKNOWN | GRP-0962 | CHOICE-PLUS-PPO |
| TPA | TPA-63841 | 2026-05-21T04:42:00Z | richard | — | medina | 1972-05-09 | UHC-46415-43 | •••-••-2574 | 9364135708 | richard.medina78@icloud.com | — | - | N/A | - | — | N/A·· |
| TPA | TPA-56672 | 2026-08-29T04:03:41Z | Aaron | — | Webb·· | 1/24/1951 | - | NULL | — | — | 4854 Forest Avenue | Phoenix | AZ | 85084 | GRP-9137 | — |
| TPA | TPA-57166 | 2026-04-25T12:36:47Z | mark | ·· | larson | 1965-08-15 | — | •••-••-8216 | (396) 296-9270·· | - | 2160 HILLCREST RD | Denver | CO | 80245 | GRP-8812 | NULL |
| TPA | TPA-50232 | 2026-01-18T05:57:14Z | BOBBY | — | ALEXANDER | ·2000-12-16 | NULL | - | (316) 307-7428 | bobby.alexander@aol.com | — | — | - | N/A | ·NULL | ···· |
| TPA | TPA-58654 | 2026-09-18T13:57:29Z | Christine | — | Clark | 1968-02-23 | UHC-92710-43 | •••-••-0442 | 6724999413 | CHRISTINE.CLARK@YAHOO.COM | 4908 Elm Street | Los Angeles | California | ·90011 | NULL | -·· |
| TPA | TPA-56779 | 2026-10-16T10:40:07Z | JUSE·· | — | REYES | 1942-06-27 | null | ·- | -·· | jose.reyes@outlook.com | 5287 VALLEY VIEW DRIVE | CHARLOTTE | NC | 28250-6351 | null | select-epo |
| TPA | TPA-61488 | 2026-10-07T04:45:57Z | lucia | — | alvarado | 16-01-2005 | NULL | •••-••-2754 | UNKNOWN | ·lucia.alvarado@aol.com | 1364 Palm Drive·· | Jacksonville | FL | 32284 | — | - |
| TPA | TPA-56130 | 2026-06-22T10:40:18Z | Kathryn | — | Sims | 19671106 | — | •••-••-9301 | - | NULL | 9716 River Road | Minneapolis | Minnesota | 55478 | GRP-2823 | NULL |
| TPA | TPA-52723 | 2026-02-20T23:33:56Z | Maria | — | Li | 1995-03-11 | — | •••-••-2820 | 709.685.1383 | maria.li@yahoo.com | 3122 BAYSHORE DRIVE | EDEN PRAIRIE | MN | 55339-0490 | GRP-7216 | null |
| TPA | TPA-51340 | 2026-10-18T19:18:03Z | MARGARET | — | BAILEY | 01/13/1998 | UHC-09162-99 | — | (831) 591-4501 | null | 9793 ELM ST | Orlando | FL | ·32804 | — | MEDICARE-ADV-A |
| TPA | TPA-58761 | 2026-04-02T04:23:14Z | zachary | — | mendoza | 1960-10-22 | — | ·NULL | 729.233.0664 | — | 1872 Oak St | Houston | TX | 77089 | GRP-2522 | CHOICE-PLUS-PPO |
| TPA | TPA-53075 | 2026-04-14T23:25:30Z | Valentina | — | Mejia | 19871219 | null | N/A | 2706392571 | ·· | 2993 BAYSHORE DRIVE | Tucson | Arizona | 85724 | N/A | N/A |
| TPA | TPA-52020 | 2026-01-29T09:03:10Z | Sophia | ·· | Howell | 28-04-1997 | NULL | — | 492-467-4792 | N/A | 2377 Apache Blvd | ·San Diego | CA | 92144 | null | CHOICE-PLUS-PPO |
| TPA | TPA-58795 | 2026-03-24T03:11:30Z | Doris | — | Jordan | 1991-06-62 | — | — | N/A | doris.jordan@aol.com | 7210 Canyon Rd | Charlotte | NC | 28275 | N/A | OPTIONS-PPO |
| TPA | TPA-63297 | 2026-07-22T14:14:47Z | ISABELLA | — | YOUNG | 10/21/1939 | — | UNKNOWN | NULL | NULL | 289 Baseline Road | Sacramento | CA | 95804 | GRP-7013 | NULL |
| TPA | TPA-53911 | 2026-05-06T05:11:40Z | Helen | — | Freeman | 03/19/2000 | N/A | — | N/A | null | 712 Main Street | San Antonio | TX | 78299 | NULL | OPTIONS-PPO·· |
| TPA | TPA-64119 | 2026-05-16T15:29:53Z | Samuel·· | ···· | Kim·· | 22-07-1969 | ·· | — | 624-644-7393 | N/A | 3839 Park Pl | Columbus | OH | 43216 | ·· | NULL |
| TPA | TPA-58459 | 2026-01-30T17:15:12Z | Jackie | — | Nelson | Aug 17, 1956·· | NULL | NULL | null | — | 9235 Jefferson Avenue | Los Angeles | CA | 90026 | GRP-4312·· | — |
| TPA | TPA-54185 | 2026-01-03T00:36:57Z | ·Albert | — | Hayes·· | 7/3/1944 | null | null | ···· | null | N/A | - | -·· | — | — | — |
| TPA | TPA-52965 | 2026-09-24T18:41:46Z | Philip | — | Peterson | 11/21/38 | ·NULL | — | — | N/A·· | 7400 Sage Ct | Houston | TX | 77021 | UNKNOWN | - |
| TPA | TPA-63673 | 2026-06-11T22:14:38Z | Deborah | — | Hughes | 01/10/56 | — | NULL | UNKNOWN | UNKNOWN | 7923 Lake View Road·· | San Antonio | TX | 78224 | N/A | N/A |
| TPA | TPA-52417 | 2026-06-12T12:45:57Z | sandra | ·E | owens | 1978-11-16 | UHC-89246-62 | •••-••-8296 | (885) 385-6982 | null | 6957 BAYSHORE DRIVE | Seattle | WA | 98175 | GRP-3971 | NAVIGATE-HMO |
| TPA | TPA-56992 | 2026-03-23T22:24:27Z | kelly | — | contreras | ·03/23/92 | UHC-65136-03 | NULL | — | NULL | 9844 Valley View Dr | Las Vegas | NV | 89120 | — | N/A |
| TPA | TPA-60830 | 2026-02-03T16:33:07Z | Jennifer | — | Hawkins | ·19970816 | UHC-31373-79 | N/A | — | UNKNOWN | UNKNOWN | null | NULL | - | — | — |
| TPA | TPA-51932 | 2026-06-03T22:22:47Z | BRANDON | ···· | SALAZAR | 1965-01-21 | N/A | •••-••-2297 | — | NULL | 4338 River Rd | Mesa | AZ | 85268-1067 | — | — |
| TPA | TPA-53190 | 2026-01-19T22:24:13Z | MEI | ·· | WONG | 1940-08-18 | - | •••-••-4233 | — | UNKNOWN | ·NULL | N/A | NULL | - | — | - |
| TPA | TPA-63081 | 2026-03-24T08:48:19Z | MARY | — | ·TAYLOR | 2000-02-17 | NULL | •••-••-8310 | UNKNOWN | N/A·· | 7667 Bayshore Drive | ·Minneapolis | ·MN | 55400 | UNKNOWN | null |
| TPA | TPA-51389 | 2026-08-23T01:26:29Z | Edwards, Brian | — | — | 1983-12-09 | - | •••-••-1682 | 269-292-6807 | NULL | 6740 Meadow Lane | Plano | TX·· | 75007 | null·· | NULL |
| TPA | TPA-54588 | 2026-07-15T13:47:33Z | Juan | — | Santos | 1947-03-14 | — | •••-••-7591 | — | NULL | 9303 Central Ave | Nashville·· | TN | 37231 | N/A | -·· |
| TPA | TPA-51152 | 2026-06-12T20:11:49Z | Juan | — | Wheeler | 1984-09-25 | — | •••-••-8725 | ·· | N/A | 1189 Ocean Avenue | Scottsdale | AZ | 85274 | - | — |
| TPA | TPA-58450 | 2026-04-02T01:28:59Z | Samuel | — | Salazar | ·Sep 13, 1980 | - | — | N/A | N/A | 8284 Harbor Boulevard | ·Sacramento | CA | 95851·· | GRP-3938 | SELECT-EPO |
| TPA | TPA-59860 | 2026-06-16T07:48:58Z | Larry | S·· | Cole | 1986-09-09 | UHC-55286-40 | •••-••-5926 | ···· | — | 7402 Meadow Ln | JACKSONVILLE | FL | 32262-1231 | ·GRP-4727 | NULL |
| TPA | TPA-57355 | 2026-04-01T04:22:03Z | Sctot | — | Kennedy | 1979-06-24 | N/A | •••-••-7964 | 631-777-9780 | scott.kennedy@proton.me | 5665 Ridge Rd | Phoenix | AZ | 85055 | NULL·· | — |
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.508Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty