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-50216 | 2026-07-05T08:55:31Z | LAWRENCE | — | LAWRENCE | 1958-03-28 | UHC-77463-23 | •••-••-4691 | UNKNOWN | N/A | 8284 PALM DR | Tempe | AZ | 85286 | GRP-0984 | UNKNOWN·· |
| TPA | TPA-60896 | 2026-01-02T17:21:09Z | JEAN | — | PENA | 11/26/1952 | UHC-63144-44 | - | NULL | jean.pena@hotmail.com | 2729 MARKET STREET | San Antonio | TX | 78227 | — | — |
| TPA | TPA-55292 | 2026-01-22T21:25:02Z | lisa | O. | walker | 01/24/1961 | ·· | - | 496-254-8510 | LISA.WALKER19@ICLOUD.COM | — | N/A | — | — | GRP-0380 | SELECT-EPO |
| TPA | TPA-62122 | 2026-07-24T15:00:36Z | Brittany | — | Marquez | 1964-12-27 | null | N/A | UNKNOWN | - | 4717 Spring St | Columbus | OH | 43249 | — | NAVIGATE-HMO |
| TPA | TPA-50561 | 2026-06-03T23:38:21Z | Johnson, Anthony | — | — | 1959-04-12 | — | null | UNKNOWN | NULL | 4195 MEADOW LN | Orlando | FL | 32872 | N/A·· | - |
| TPA | TPA-58842 | 2026-10-09T02:33:47Z | Daniel | — | Parker | 1977-04-03 | NULL | — | - | — | 5608 CANYON ROAD Apt 7 | TUCSON | AZ | 85759 | GRP-2823·· | MEDICARE-ADV-A |
| TPA | TPA-56788 | 2026-04-26T11:53:29Z | Jack | — | ·Barnas | 1979-04-24 | — | ·- | - | N/A | 3185 Washington Street | Las Vegas | ·nv | 89125 | UNKNOWN | UNKNOWN |
| TPA | TPA-50425 | 2026-06-06T18:53:14Z | Camila | — | Cruz·· | 04/14/1998 | — | -·· | (508) 833-7527 | — | 3842 Ocean Avenue | Atlanta | GA·· | 30346 | GRP-1679 | null |
| TPA | TPA-63983 | 2026-10-04T08:25:36Z | Michael | ·· | Howard | 06/26/1947 | — | — | 709-599-5372 | MICHAEL.HOWARD19@ICLOUD.COM | 2431 PARK PLACE | LAS VEGAS | nv | 89151 | GRP-0633 | N/A |
| TPA | TPA-55157 | 2026-08-22T10:09:02Z | Cook, Frank | P. | — | 1975-10-03 | — | — | — | FRANK.COOK15@ICLOUD.COM | 3893 CANYON ROAD | Scottsdale | AZ | 85234·· | — | NAVIGATE-HMO |
| TPA | TPA-54081 | 2026-01-07T19:36:10Z | KENNETH | — | STEWART | 04/08/2003 | — | •••-••-1384 | NULL | NULL | 333 JEFFERSON AVENUE | ATLANTA | GA | 30389 | GRP-0686 | — |
| TPA | TPA-62764 | 2026-03-18T15:44:57Z | Jack | — | ·Espinoza | — | UHC-29115-37 | UNKNOWN | — | UNKNOWN | 8268 Meadow Ln | Las Vegas | Nevada·· | 89109 | GRP-4527 | SELECT-EPO |
| TPA | TPA-57491 | 2026-07-10T21:59:37Z | MARY | — | STEVENS | 1949-03-27 | — | UNKNOWN | 6478249069 | — | 1708 Lincoln Way | Dallas | TX | 75232 | N/A | — |
| TPA | TPA-55404 | 2026-03-28T04:19:00Z | Benjamin | — | Elliott | 19480308·· | UNKNOWN | N/A | — | UNKNOWN | 5730 Sunset Boulevard | San Antonio | TX | 78208 | GRP-7359 | UNKNOWN·· |
| TPA | TPA-58706 | 2026-07-06T13:53:24Z | George | — | Delgado | May 2, 1984 | null | •••-••-6541 | NULL | george.delgado23@proton.me·· | 2597 Bayshore Drive Apt 40 | SEATTLE | WA | ·98197 | — | MEDICARE-ADV-A |
| TPA | TPA-56963 | 2026-09-08T04:31:35Z | Williams, Judy | — | — | 1997-09-06 | null | N/A | 4322595626 | null | — | N/A | ·· | - | - | null·· |
| TPA | TPA-50317 | 2026-02-02T12:14:11Z | ELIZABETH | — | WILSON | 2/10/1957 | N/A | NULL | — | elizabeth.wilson@hotmail.com | 3145 Desert Sky Boulevard | PHOENIX | ·Arizona | 85002 | null | CHOICE-PLUS-PPO |
| TPA | TPA-52897 | 2026-05-01T13:25:30Z | David | — | Wallace | 1969-09-17 | N/A | — | — | DAVID.WALLACE@YAHOO.COM | 1145 Valley View Dr | Phoenix | AZ | 85047-8130 | N/A·· | — |
| TPA | TPA-58463 | 2026-08-19T20:21:21Z | Jacob | — | Espinoza | 1942-06-20 | — | — | — | - | UNKNOWN | ·- | UNKNOWN | UNKNOWN | NULL | — |
| TPA | TPA-52436 | 2026-09-01T07:25:25Z | JESSE | — | TUCKER | 04-05-1983 | null | — | 597-732-9854 | null | 4341 Church Street·· | Glendale·· | ·AZ | 85315·· | UNKNOWN | MEDICARE-ADV-B |
| TPA | TPA-64434 | 2026-02-24T11:12:30Z | HAROLD | P. | MARTINEZ | 1974-02-21 | — | NULL | — | UNKNOWN | 8897 Broadway #479 | GILBERT | AZ | 85237 | N/A | NULL |
| TPA | TPA-52645 | 2026-01-11T20:41:05Z | Zachary | — | Harris | 1972-03-02 | NULL | — | null | N/A | 6872 Sage Ct | Miami·· | FL | 33103-0292 | NULL | CHOICE-PLUS-PPO |
| TPA | TPA-63480 | 2026-07-20T17:18:33Z | Meyer, Ray | A | — | 1983-01-04 | NULL | — | NULL | ·- | 5905 MOUNTAIN VIEW DR | Gilbert | AZ | 85221 | GRP-0284 | SELECT-EPO |
| TPA | TPA-51968 | 2026-09-07T13:35:34Z | shirley | — | mitchell | 1974-03-17 | UHC-00418-74 | N/A | — | NULL | 1992 Ocean Ave | Seattle·· | WA·· | 98197 | GRP-8030 | — |
| TPA | TPA-61076 | 2026-04-26T11:02:12Z | LAUREN | ·· | HUFFMAN | 01/11/41 | UHC-50586-26 | - | 826-804-1853 | NULL | 7071 Mesa Dr | Tucson | AZ | 85737·· | — | OPTIONS-PPO |
| TPA | TPA-63847 | 2026-03-03T13:03:49Z | McDonald, Raymond | V | — | — | — | •••-••-4251 | 349.234.6630 | ·RAYMOND.MCDONALD@YAHOO.COM | 9897 Canyon Rd | Atlanta | Georgia | 30362 | ·GRP-8799 | NULL |
| TPA | TPA-52333 | 2026-05-13T02:11:55Z | sophia | — | schultz | 5/28/1979 | null | •••-••-2111 | 233.875.0924 | NULL | 2062 JEFFERSON AVE | Phoenix | AZ | 85019 | NULL | — |
| TPA | TPA-61331 | 2026-06-19T21:17:08Z | ·Jesse | — | Ramos | 2008-04-13 | — | — | NULL | jesse.ramos@yahoo.com | 7233 Park Place | Fresno | California·· | 93758 | NULL | N/A |
| TPA | TPA-64180 | 2026-04-14T21:38:42Z | Jeffrey | O | Arnold | 1996-06-16 | UHC-02477-34 | UNKNOWN·· | — | NULL | 838 River Rd | Sacramento | California | 95825 | — | N/A |
| TPA | TPA-62748 | 2026-08-16T00:34:47Z | roger | — | fernanndez | 1963-11-20 | UNKNOWN | — | (366) 943-4908·· | roger.fernandez54@aol.com | 7593 Main St | Sacramento | CA | 95802 | - | NULL |
| TPA | TPA-54720 | 2026-05-24T12:32:46Z | Wei | U | Estarda | 1987-08-21 | - | NULL | NULL | N/A | 5179 Pine Dr | Los Angeles | CA | 90075 | null | ·NULL |
| TPA | TPA-63308 | 2026-03-16T11:55:45Z | Sarah | ···· | Harvey | 1988-04-27 | N/A | UNKNOWN | (717) 718-3687 | SARAH.HARVEY@YAHOO.COM | ·4877 CHURCH ST | Las Vegas | NV | ·89197-7702 | GRP-5442 | null |
| TPA | TPA-56824 | 2026-03-08T12:20:49Z | Perez, Olivia | K. | — | 1963-04-16 | — | •••-••-5557 | — | olivia.perez56@yahoo.com | 1737 UNION ST | Tampa | FL | 33689 | GRP-4040 | NULL |
| TPA | TPA-51634 | 2026-04-27T15:27:59Z | JONATHAN | — | ·VALDEZ | 1938-07-06 | UHC-09612-40 | — | 14458108877 | — | 1279 Bayshore Drive | Nashville | tn | 37286 | GRP-0834 | — |
| TPA | TPA-64360 | 2026-07-16T01:58:52Z | Russell | — | Jacobs | 1986-02-10 | - | UNKNOWN | null | NULL | 3278 Spring Street | Denver | CO | 80225 | — | MEDICARE-ADV-B·· |
| TPA | TPA-53301 | 2026-09-10T08:06:37Z | Alice | — | Yang | 1997-02-18 | — | •••-••-8450 | 2207826753 | alice.yang@outlook.com | 3250 Forest Ave | Sacramento | California | 95866 | GRP-4470 | UNKNOWN |
| TPA | TPA-60725 | 2026-07-25T14:45:17Z | Evelyn | X | Lawson | 10-12-1997 | null·· | UNKNOWN | — | null·· | ·2187 Willow Ct | Minneapolis | MN | ·55402-4608 | N/A·· | — |
| TPA | TPA-55027 | 2026-04-09T19:15:14Z | deborah·· | — | thompson | 1963-04-19 | UNKNOWN | - | null | UNKNOWN | 6191 Lake View Road·· | Tucson | ·Arizona | 85767 | null | NULL |
| TPA | TPA-56395 | 2026-09-10T01:43:17Z | MATEO | — | WOOD | 1955-03-07 | - | NULL | 466-478-6853 | — | 6013 Washington Street | Seattle | WA | 98176-5237 | N/A | - |
| TPA | TPA-56619 | 2026-03-26T21:45:16Z | Janet | — | Jones | 19550514 | - | •••-••-1242 | — | NULL | 2586 River Rd | Eden Prairie | MN | 55337 | UNKNOWN·· | CORE-HMO |
| TPA | TPA-57182 | 2026-07-13T14:37:59Z | Jose | U | Schmidt·· | 1975-12-20 | N/A | — | 546-679-7702 | — | 4255 Broadway | Minneapolis | MN | 55472 | — | — |
| TPA | TPA-56427 | 2026-07-11T01:50:44Z | Ethan | — | Robertson | 7/21/2000 | null | •••-••-5689 | N/A | ethan.robertson38@hotmail.com | 7669 Maple Ave | San Antonio | TX | 78202 | GRP-1872 | SELECT-EPO |
| TPA | TPA-50517 | 2026-02-09T17:01:39Z | CAROLYN | — | BELL | 3/5/1969 | UHC-32776-84 | •••-••-3005 | — | carolyn.bell61@aol.com | UNKNOWN | — | N/A | ···· | GRP-0960 | SELECT-EPO |
| TPA | TPA-59734 | 2026-01-17T02:28:46Z | Fuller, Emily | — | ···· | 1986-02-02 | — | — | — | EMILY.FULLER54@HOTMAIL.COM | 5531 Baseline Rd | Tampa | FL | 33671 | NULL·· | N/A |
| TPA | TPA-56545 | 2026-06-11T11:26:26Z | Aisha | R | Mejia | 1990-12-06 | null | UNKNOWN | — | — | NULL | N/A·· | N/A | NULL | ·- | — |
| TPA | TPA-56655 | 2026-08-22T23:53:35Z | virginia | — | jackson | 5/9/1958 | - | — | null | — | 1576 Oak Street | Austin | TX | 78774 | — | UNKNOWN |
| TPA | TPA-52642 | 2026-03-15T20:28:07Z | lori | — | stevens | Jun 13, 1966 | — | UNKNOWN | — | lori.stevens19@outlook.com | 8079 Sunset Boulevard | LAS VEGAS | Nevada | 89113 | GRP-6834 | — |
| TPA | TPA-57642 | 2026-09-15T08:40:09Z | Danielle | — | Rojas | 1952-05-16 | ·· | •••-••-4862 | 514-950-9022 | ·UNKNOWN | 4114 Forest Ave Apt 28 | Tucson | AZ | 85762 | NULL | — |
| TPA | TPA-56028 | 2026-03-13T01:49:10Z | ·BRITTANY | — | MUNOZ | 1960-04-02 | ·UNKNOWN | •••-••-5683 | ·8025740413 | brittany.munoz@proton.me·· | ·6223 CENTRAL AVENUE | Chandler | AZ | 85268 | GRP-3220 | N/A |
| TPA | TPA-57616 | 2026-06-17T09:56:30Z | Nancy | ·· | Hughes | 05-02-1997 | N/A | ·null | 675-785-5487 | nancy.hughes@yahoo.com | 7424 CEDAR LANE | Las Vegas | NV | 89131 | 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.225Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty