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-52400 | 2026-10-11T09:40:36Z | JACOB | — | — | 2004-06-04 | N/A | null | NULL | — | — | — | - | — | GRP-8359 | CHOICE-PLUS-PPO |
| TPA | TPA-59859 | 2026-03-15T09:40:31Z | Jerry | — | Morrison | 2001-04-26 | — | — | 5767986753 | ·N/A | — | NULL | — | N/A | GRP-2375 | NULL |
| TPA | TPA-60013 | 2026-04-24T07:46:22Z | Carlos | — | Daniels | ·1974-11-06 | null | — | NULL | UNKNOWN | ·7882 HARBOR BOULEVARD | San Diego | CA | 92132 | — | null |
| TPA | TPA-55065 | 2026-09-13T09:09:11Z | JACK | — | CLARK | 1957-06-05·· | — | •••-••-8758 | ·(641) 523-5981 | — | 6822 HARBOR BOULEVARD | ·Atlanta | GA | 30388 | — | UNKNOWN |
| TPA | TPA-61162 | 2026-09-04T15:53:40Z | mary | — | gomez | ·11/22/1947 | N/A | — | +1 513 430 3807 | UNKNOWN | 8201 Baseline Rd | Gilbert | AZ | 85244 | ·N/A | — |
| TPA | TPA-61478 | 2026-05-16T19:49:00Z | joan | — | brooks | 1997-11-12 | null | •••-••-0406 | NULL | joan.brooks31@aol.com | N/A | — | NULL | - | UNKNOWN | CHOICE-PLUS-PPO |
| TPA | TPA-62884 | 2026-03-20T12:23:46Z | heather | — | nelson | 1977-12-27 | UHC-32033-88 | NULL | — | NULL | 3480 Main Street | Plano | TX | 75059·· | - | NAVIGATE-HMO |
| TPA | TPA-63187 | 2026-03-03T17:23:05Z | Ann | — | Garrett | 1938-12-18 | UHC-63615-33·· | UNKNOWN | 221-808-5199 | null·· | 5563 LINCOLN WAY | Houston | TX | 77073 | — | UNKNOWN |
| TPA | TPA-52666 | 2026-02-07T15:12:11Z | MERILYN | — | MURPHY | 1974-01-17 | - | — | null | marilyn.murphy31@yahoo.com | 7566 WASHINGTON STREET | Austin | TX | null | NULL | OPTIONS-PPO |
| TPA | TPA-61222 | 2026-01-08T06:32:50Z | Barbara | — | Park·· | 01-05-1982 | NULL | •••-••-7222 | — | NULL | 4177 PINE DR | Scottsdale | AZ | ·85224 | null | null |
| TPA | TPA-56372 | 2026-01-24T10:14:26Z | Emily | — | Wells·· | 1971-03-28 | - | — | 8798240310 | — | 2695 Mountain View Dr | San Diego·· | CA | 92155 | GRP-7152 | SELECT-EPO |
| TPA | TPA-51433 | 2026-07-17T02:00:27Z | ·Judy | — | Harvey | 5/25/1961 | N/A | — | NULL | - | 6205 Highland Avenue | San Antonio | tx | 78210 | NULL | null |
| TPA | TPA-60214 | 2026-03-19T13:32:12Z | Logan | L. | Greene | 1965-08-04 | N/A | — | ·216-510-7683 | N/A | 7931 Canyon Rd Apt 36 | Minneapolis | MN | 55476 | NULL | UNKNOWN |
| TPA | TPA-58126 | 2026-03-07T19:01:11Z | Willie | — | Morales | ·04/17/95 | — | - | UNKNOWN | willie.morales@hotmail.com | 90 Desert Sky Blvd·· | Glendale | AZ | 85358 | — | NAVIGATE-HMO |
| TPA | TPA-54841 | 2026-09-18T23:52:14Z | ROBERT | — | STEVENS | 10/10/1948 | — | •••-••-6437 | — | N/A | 6132 Maple Ave | COLUMBUS | OH | — | GRP-1492 | - |
| TPA | TPA-56747 | 2026-10-01T20:23:34Z | Fisher, Carolyn | — | — | 1959-11-11 | N/A | •••-••-8828 | — | CAROLYN.FISHER@HOTMAIL.COM | 1539 APACHE BLVD | TUCSON | AZ | 85731 | — | — |
| TPA | TPA-54589 | 2026-09-24T16:45:55Z | Juan | — | Santos | N/A·· | — | — | UNKNOWN | - | 9303 Central Ave | Nashville | TN | 37231 | — | - |
| TPA | TPA-50841 | 2026-05-28T04:40:05Z | carl·· | — | young | 1960-02-05 | N/A | •••-••-2281 | N/A | — | N/A | - | null | NULL | — | MEDICARE-ADV-B |
| TPA | TPA-54131 | 2026-09-08T16:48:17Z | Abby | — | Montgomery | Jun 27, 1945 | UHC-74702-59 | •••-••-1520 | — | abigail.montgomery88@aol.com | 3460 Forest Ave | Minneapolis·· | MN | ·55448 | GRP-3310 | - |
| TPA | TPA-59851 | 2026-03-30T15:38:26Z | ELIJAH | — | HARPER | 17-09-1947 | — | - | N/A·· | NULL·· | 4099 Ridge Rd | ·Tempe | AZ | ·85229 | UNKNOWN | null |
| TPA | TPA-56068 | 2026-03-16T18:39:49Z | valentina | — | bishop | 2004-11-17 | null | — | - | UNKNOWN | -·· | - | null | N/A | GRP-5539·· | - |
| TPA | TPA-53130 | 2026-04-08T03:38:42Z | Beverly | — | Cruz | 2004-12-13 | — | •••-••-3712 | +1 453 284 8788·· | null | 9587 Palm Dr | Atlanta | GA | 30367 | N/A | CHOICE-PLUS-PPO |
| TPA | TPA-61640 | 2026-05-26T10:22:43Z | ·Hiiroshi | H. | Smith | 19930606 | NULL | — | 355-874-8275 | — | 3852 Elm Street | Las Vegas | NV | 89111 | — | SELECT-EPO |
| TPA | TPA-60114 | 2026-03-06T23:37:32Z | Hannah | S. | Bailey | 19470514 | NULL | NULL | null | — | 1908 Forest Ave #695 | Houston | TX·· | 77076 | GRP-8886 | UNKNOWN |
| TPA | TPA-55324 | 2026-06-01T16:35:42Z | WALTER | — | ALVAREZ | 6/2/1941 | — | •••-••-7106 | null | ·· | 4448 SAGE COURT | Houston | TX | 77031 | — | null |
| TPA | TPA-52063 | 2026-03-18T21:15:57Z | Harold | — | ·Ortega | 1974-01-26 | — | N/A | UNKNOWN | — | null | — | null·· | UNKNOWN | GRP-9255·· | NULL |
| TPA | TPA-63604 | 2026-08-11T09:46:44Z | JON | M | ALVARADO | 1943-04-06 | — | N/A | (431) 367-3759 | jonathan.alvarado35@outlook.com | — | UNKNOWN | — | NULL | UNKNOWN | — |
| TPA | TPA-56272 | 2026-10-18T06:56:29Z | JANET | — | WALLACE | 1939-11-19 | NULL | •••-••-8846 | (858) 879-3971 | — | — | N/A | null | — | - | — |
| TPA | TPA-58957 | 2026-05-19T14:43:36Z | Mary | — | Wheeler | 1975-09-27 | UNKNOWN | UNKNOWN | N/A | mary.wheeler12@hotmail.com | 4043 Pine Dr Apt 6 | Seattle | WA | 98133·· | — | null |
| TPA | TPA-53842 | 2026-03-12T18:39:26Z | Lisa | — | Reyes | 05/10/1997 | N/A | •••-••-7480 | 947.536.1192 | NULL | — | UNKNOWN | - | - | NULL | — |
| TPA | TPA-58212 | 2026-07-28T15:21:47Z | Catherine | — | Coleman | 2004-08-12 | — | null | 15508284224 | — | 4690 Camelback Rd | SAN ANTONIO | Texas | 78292 | - | — |
| TPA | TPA-64137 | 2026-04-16T07:33:31Z | JOSHUA | A·· | GRIFFIN | 12/20/1945·· | — | — | N/A | ·· | 473 Valley View Dr | Orlando | FL | 32851 | null | SELECT-EPO |
| TPA | TPA-59288 | 2026-02-21T10:39:03Z | STEPHEN | C. | VEGA | 1962-12-18 | ·- | — | — | null | ·8354 MAPLE AVE | ·Denver | CO | 80252 | - | -·· |
| TPA | TPA-60473 | 2026-09-20T06:21:05Z | JEREMY | ···· | BLACK | 06/26/91·· | ·null | — | ·NULL | — | N/A | — | UNKNOWN | - | ·N/A | MEDICARE-ADV-B |
| TPA | TPA-62113 | 2026-08-10T20:41:49Z | PRIIA | ···· | COLLINS | 1942-04-01 | ·NULL | null | null | PRIYA.COLLINS70@ICLOUD.COM | 6339 BASELINE RD | Mesa | AZ | 85246 | NULL | MEDICARE-ADV-A |
| TPA | TPA-51924 | 2026-07-06T04:19:32Z | LIAS | — | CAMPBELL | 1965-10-22 | — | •••-••-6698 | — | — | 1629 Pine Drive | Denver | CO | 80275 | — | — |
| TPA | TPA-55428 | 2026-10-11T10:44:50Z | BARB | — | SCHULTZ | 1997-02-25 | N/A | — | +1 730 343 2627 | BARBARA.SCHULTZ22@PROTON.ME·· | 1266 Spring Street | Dallas | TX | 75294 | — | — |
| TPA | TPA-51377 | 2026-04-12T08:51:35Z | Anthony | — | Knight | 1973-06-22 | ·UHC-86954-11 | •••-••-5360 | — | N/A | 7521 MARKET STREET | San Diego | ca | 92153-9581 | GRP-9526·· | ·NULL |
| TPA | TPA-54987 | 2026-08-19T09:47:42Z | Olivia | — | Stewart | 01/24/1941 | — | •••-••-4751 | — | null | ·2403 Valley View Dr | Gilbert | AZ | 85278 | GRP-4721 | ·CHOICE-PLUS-PPO |
| TPA | TPA-53082 | 2026-05-13T11:13:18Z | Sophia | F | Washington | 1952-06-07 | UHC-03920-31 | — | — | — | 1364 SUNSET BLVD | Las Vegas | NV | 89135 | GRP-2407 | — |
| TPA | TPA-64391 | 2026-04-11T23:37:25Z | JOAN | — | SILVA | 06/25/68 | null | ···· | — | - | null·· | UNKNOWN | — | UNKNOWN·· | UNKNOWN | - |
| TPA | TPA-50206 | 2026-06-12T20:09:03Z | SANTIAGO | ·M | PETERS | 21-11-1999 | NULL | N/A | UNKNOWN | — | 8248 Willow Court | SAN ANTONIO | TX | 78210 | GRP-9972 | MEDICARE-ADV-B |
| TPA | TPA-57920 | 2026-08-03T14:54:26Z | ·Sophia | — | Robertson | 1962-08-17 | — | ·· | 274-497-8695 | ·NULL | 4173 Willow Ct | FRESNO | California | 93754 | — | MEDICARE-ADV-A |
| TPA | TPA-54864 | 2026-03-29T15:26:51Z | sandra | N | snyder | 1952-02-28 | UHC-06644-60 | — | null | — | 3716 WASHINGTON ST | Las Vegas | NV | ·89140-0633 | NULL | N/A |
| TPA | TPA-59570 | 2026-08-23T21:22:11Z | ·Isablla | — | Santos | 1985-12-02 | UNKNOWN | •••-••-3917 | — | null | 7088 Market Street | Tempe | AZ | 85211 | — | SELECT-EPO |
| TPA | TPA-59276 | 2026-08-18T05:36:30Z | Denis | — | Holmes | 1981-01-15 | - | N/A | (904) 423-7368 | — | 8792 Elm St | Miami·· | FL | 33153-2829 | null | MEDICARE-ADV-A |
| TPA | TPA-51225 | 2026-03-09T21:34:05Z | Nunez, Santiago·· | — | — | 1954-08-27 | NULL | •••-••-3515 | - | santiago.nunez80@hotmail.com | 8018 Union Street | CHANDLER | AZ·· | 85236 | N/A | null |
| TPA | TPA-52395 | 2026-06-29T01:41:05Z | stephanie | — | huunt | 1968-03-08 | - | N/A | N/A | ···· | 8932 Park Pl | Atlanta | GA | 30303 | GRP-0636 | MEDICARE-ADV-B |
| TPA | TPA-51417 | 2026-01-16T20:43:00Z | KENNETH | — | COOPER | 1999-04-06 | NULL | null | 447.477.4516 | — | 6394 Baseline Road | MESA | AZ | 85234·· | NULL | CORE-HMO |
| TPA | TPA-61566 | 2026-09-17T14:23:13Z | joan | — | spencer | 1943-03-13 | NULL | UNKNOWN | NULL | joan.spencer@proton.me | 6853 Bayshore Dr | ·Austin | TX | 78781 | GRP-6486 | — |
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:38.461Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty