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-55034 | 2026-08-13T18:00:50Z | TRAN | — | BRENDA | 1994-10-17 | UNKNOWN | NULL | — | brenda.tran@gmail.com | 9506 Lake View Rd Apt 23 | Tucson | AZ | 85739 | null | — |
| TPA | TPA-57375 | 2026-10-14T21:51:50Z | Santiago | — | Patterson | ·Jun 28, 1960 | NULL | •••-••-8375 | 15913420133 | — | ·- | - | - | — | NULL | NULL |
| TPA | TPA-52922 | 2026-03-17T13:48:04Z | HAROLD·· | ···· | VEGA | 1946-06-06 | — | ·NULL | 616-959-4956 | N/A | 9470 HIGHLAND AVE·· | Orlando | FL | null | null | — |
| TPA | TPA-62509 | 2026-05-27T23:19:19Z | Angela | — | Johnston | 1938-09-11 | null | — | -·· | ·· | 6887 Forest Avenue | Fresno | CA | 93754 | NULL | UNKNOWN |
| TPA | TPA-57095 | 2026-02-11T22:41:31Z | Janet | K | Richardson | ·1989-10-21 | N/A | •••-••-8431 | — | JANET.RICHARDSON@AOL.COM | 3273 Maple Avenue | Atlanta | Georgia | ·30344 | — | NULL |
| TPA | TPA-57838 | 2026-04-30T12:34:25Z | Heather | — | ·Pierce | 1966-05-21 | — | null | — | UNKNOWN | 3017 Ocean Avenue | Minneapolis | MN | ·55455 | GRP-5152 | null |
| TPA | TPA-64402 | 2026-08-31T08:09:21Z | CAROLYN | ·· | ARNOLD | 1/28/1961 | — | UNKNOWN | 9093511403 | CAROLYN.ARNOLD86@AOL.COM | 5629 BROADWAY | Dallas | TX | 75254 | NULL | CHOICE-PLUS-PPO |
| TPA | TPA-53603 | 2026-10-18T20:03:56Z | Madison | W | Lopez | 1970-08-17 | ·· | N/A | N/A | madison.lopez94@icloud.com | 3579 WILLOW COURT | Miami | Florida | 33104 | null | — |
| TPA | TPA-59736 | 2026-03-23T04:00:29Z | Megan | — | Ford | 1985-05-10 | UNKNOWN | — | 13983677615 | megan.ford@aol.com | 8879 Market Street | Atlanta | GA | 30360 | — | MEDICARE-ADV-B |
| TPA | TPA-52620 | 2026-08-31T09:43:34Z | gregory | — | webb | 1/26/1977 | ···· | •••-••-5630 | — | N/A | 462 MEADOW LANE | Miami | FL | NULL | — | UNKNOWN |
| TPA | TPA-61649 | 2026-08-29T23:13:20Z | Jeremy | — | Fields | 1941-08-04 | null | null | NULL | N/A | 806 JEFFERSON AVE | San Antonio | TX·· | 78264·· | — | CHOICE-PLUS-PPO |
| TPA | TPA-53566 | 2026-10-08T16:38:06Z | carlos | M | thomas | 1/24/1983 | null | — | ···· | — | 1777 Highland Ave | Houston·· | Texas | 77034-5862 | UNKNOWN·· | CORE-HMO |
| TPA | TPA-55153 | 2026-01-24T08:30:29Z | donna | — | stephens | 19840307 | — | - | (545) 827-6708 | — | UNKNOWN | UNKNOWN | — | — | null | SELECT-EPO |
| TPA | TPA-54675 | 2026-03-27T01:00:29Z | gloria | — | ray·· | 1983-08-41 | UHC-03742-07 | •••-••-3760 | (813) 710-1495 | N/A | 2459 Oak St | Columbus | OH | ·43204 | N/A | OPTIONS-PPO·· |
| TPA | TPA-62498 | 2026-09-27T10:12:30Z | Brenda | K | Price | 1950-07-23 | UNKNOWN | NULL | null | NULL | 553 Forest Ave | Atlanta | ga | 30397 | GRP-1199 | NULL |
| TPA | TPA-54631 | 2026-03-16T18:07:35Z | Jessica | — | Matthews | ·1/6/1962 | — | — | — | JESSICA.MATTHEWS@YAHOO.COM | 938 Park Pl·· | Chandler | AZ | 85206 | GRP-4726 | — |
| TPA | TPA-50377 | 2026-04-08T05:38:22Z | STEVE | — | ARMSTROONG·· | Sep 3, 1947 | - | — | 8308514947 | UNKNOWN | 2077 Grand Avenue | Plano | TX | — | N/A | NULL |
| TPA | TPA-63670 | 2026-04-05T08:02:03Z | MARILYN·· | — | RILEY | 02/05/1961 | — | •••-••-4547 | (328) 602-6124 | UNKNOWN | 4027 Park Pl·· | Charlotte·· | NC | 28299 | — | — |
| TPA | TPA-50301 | 2026-04-22T20:06:10Z | Mroales, Albert | — | ·· | 1949-06-03 | - | N/A | — | null | 4504 Lake View Road | Gilbert | AZ | 85215 | — | UNKNOWN |
| TPA | TPA-61789 | 2026-05-15T08:32:26Z | BILLY | ···· | LOPEZ | 1940-09-21 | ·UHC-11120-88 | - | (491) 709-4308 | ·· | 6638 Highland Ave | Columbus | OH | 43220 | UNKNOWN | — |
| TPA | TPA-57594 | 2026-10-17T03:44:56Z | MASON | — | ARMSTRONG | 1938-08-21 | null·· | •••-••-7200 | UNKNOWN | mason.armstrong76@aol.com | 3613 Highland Ave Apt 37 | Columbus | OH | 43250 | — | NULL |
| TPA | TPA-61456 | 2026-08-17T20:25:10Z | ·Mariana | — | Fernandez | 12/05/1951 | N/A | •••-••-1302 | (389) 712-7054 | — | 3623 PINE DRIVE Apt 30 | Charlotte | NC | ·28208 | — | ···· |
| TPA | TPA-62390 | 2026-02-26T21:49:18Z | Yang, Rachel | — | — | 1945-11-12 | — | •••-••-2360 | 13817367496 | - | 2921 Palm Dr | Denver | CO | 80243 | UNKNOWN | - |
| TPA | TPA-58434 | 2026-03-03T11:19:11Z | Christine | — | ·Lawson | 1940-02-08 | null | UNKNOWN | (454) 879-8020 | NULL | 8494 Market Street | CHARLOTTE | NC | 28251 | GRP-9216 | — |
| TPA | TPA-63199 | 2026-08-08T12:59:18Z | kyle·· | — | contreras | 1962-06-10 | - | •••-••-2510 | — | null | 5877 Church St | SCOTTSDALE | AZ | 85228 | - | UNKNOWN |
| TPA | TPA-56972 | 2026-01-31T07:41:18Z | Brenda | K. | Nichols | 1998-10-20 | — | — | — | brenda.nichols48@hotmail.com | — | NULL | UNKNOWN | ·UNKNOWN | - | UNKNOWN |
| TPA | TPA-56249 | 2026-06-15T16:29:38Z | angela | — | espinoza | 12/14/2005 | — | •••-••-8897 | — | - | 764 CEDAR LN | Gilbert | AZ | 85219 | - | NULL |
| TPA | TPA-57426 | 2026-08-19T00:26:53Z | Noah | — | Mogran | 1976-03-20 | - | NULL | N/A | null | 5058 Palm Dr | Nashville | TN | 37274 | — | - |
| TPA | TPA-51655 | 2026-05-27T06:58:19Z | STEPHEN | — | COOK | 2001-11-05 | UHC-38054-36 | •••-••-5762 | — | stephen.cook90@proton.me | 433 Main St | SAN ANTONIO | ·TX | 78202 | — | - |
| TPA | TPA-58149 | 2026-06-20T15:35:26Z | JULIA | ·· | PERKINS | 1945-03-26 | null | — | NULL | — | 5328 WASHINGTON ST Apt 8 | Tempe | az | ·85269 | GRP-8698 | - |
| TPA | TPA-50819 | 2026-09-02T03:35:26Z | Lopez, Emma | P | — | 19820716 | UHC-06552-13 | •••-••-4400 | 7443418913 | emma.lopez72@proton.me | 932 Harbor Blvd·· | Tampa | FL | ·33652 | GRP-6317 | MEDICARE-ADV-A |
| TPA | TPA-59898 | 2026-05-21T09:26:34Z | MARK | — | PEREZ | 13-05-1962·· | NULL | UNKNOWN | — | - | 8922 Canyon Road | Los Angeles | CA | 90089 | GRP-6803 | CHOICE-PLUS-PPO |
| TPA | TPA-57042 | 2026-04-16T06:58:44Z | SEAN | H | WALSH | 1940-11-14 | — | UNKNOWN·· | — | sean.walsh56@icloud.com | 1571 Union St | Glendale | AZ | 85347 | N/A·· | — |
| TPA | TPA-62687 | 2026-01-10T15:02:16Z | GARY | — | PERKINS | Jan 3, 1960 | — | •••-••-9408 | null | — | 207 Lincoln Way | Denver | ·CO | 80224 | NULL | — |
| TPA | TPA-59811 | 2026-05-02T04:48:26Z | SAMANTHA | — | PETERS | 1997-12-01 | null | UNKNOWN·· | ·NULL | UNKNOWN | 4730 MOUNTAIN VIEW DR | MIAMI | Florida | 33142 | GRP-7288 | - |
| TPA | TPA-51688 | 2026-06-23T22:21:48Z | Maria | — | Munoz | 1974-05-22 | N/A | — | NULL | UNKNOWN | 7712 CEDAR LANE | Tempe | AZ | 85257 | — | — |
| TPA | TPA-54253 | 2026-04-06T04:51:55Z | Mei | — | Johnson | 2/23/1978 | UHC-36165-09 | — | 363-761-0823 | — | 4634 RIVER ROAD | Plano | TX | 75089 | GRP-9331 | N/A |
| TPA | TPA-54078 | 2026-07-12T18:55:30Z | Olivia | — | Gibson | 1956-06-01 | null | NULL·· | 13217201855 | ·UNKNOWN | 7786 HIGHLAND AVE | Plano | ·Texas | 75076 | — | UNKNOWN |
| TPA | TPA-59067 | 2026-05-02T05:30:30Z | JULIE | — | ·KELLY | 1984-06-24 | — | ·NULL | ·· | NULL | 2150 PARK PLACE | GLENDALE | Arizona | 85313 | — | CORE-HMO |
| TPA | TPA-63742 | 2026-03-19T19:07:28Z | Kimberly | — | Bakeer | 1956-01-26 | — | UNKNOWN·· | — | kimberly.baker65@outlook.com·· | 8898 Lake View Rd | San Diego | CA | 92119 | null | MEDICARE-ADV-A |
| TPA | TPA-63080 | 2026-01-11T13:14:58Z | Hansen | — | Linda | Oct 9, 1941 | UHC-10492-62 | ·- | null | UNKNOWN | 6644 Union St | HOUSTON | TX | 77022 | N/A | N/A |
| TPA | TPA-62131 | 2026-01-25T11:17:35Z | James | — | Johnston | 1960-06-27 | - | — | — | null | 3248 Mesa Dr | NASHVILLE | TN·· | 37296 | null | — |
| TPA | TPA-52579 | 2026-02-13T14:42:56Z | Janet | — | Ryan | 2005-00-55 | — | — | 3459233061 | null | 7220 Market St·· | Orlando | FL | — | N/A | CORE-HMO |
| TPA | TPA-53560 | 2026-07-07T10:33:45Z | Nancy | — | Morales | 2004-10-22 | UNKNOWN | NULL | NULL | UNKNOWN | ·· | — | ···· | - | — | NULL |
| TPA | TPA-58944 | 2026-01-17T18:49:05Z | DAVID | R | YANG | 1947-05-10 | — | null | 388-472-1360 | UNKNOWN | — | NULL | null | — | GRP-4497 | — |
| TPA | TPA-62335 | 2026-05-05T12:48:39Z | Jackson, Nicholas | — | — | 03-08-1987 | — | — | (577) 369-4218 | — | 1109 Maple Avenue #558 | Chandler | ·Arizona | 85260 | null | UNKNOWN·· |
| TPA | TPA-53419 | 2026-06-28T15:39:21Z | Brian | — | Wang | — | — | •••-••-5863 | N/A | — | 2019 VALLEY VIEW DR | Eden Prairie·· | MN | 55356 | null | ···· |
| TPA | TPA-59478 | 2026-05-22T12:58:34Z | ·Kim | — | Harvey·· | 1960-01-28 | NULL | N/A | N/A | kimberly.harvey@aol.com | 1939 Palm Drive | ·MIAMI | FL | 33153 | — | MEDICARE-ADV-B |
| TPA | TPA-62806 | 2026-04-02T04:25:45Z | ·AMBER | — | HENDERSON | 1970-08-09 | null | ·null | ·- | — | 7298 BROADWAY | Sacramento | ca | N/A | — | null |
| TPA | TPA-59806 | 2026-06-24T12:47:40Z | LAUREN | — | CHEN | 7/26/1973 | UNKNOWN | — | +1 457 440 7425 | null | — | UNKNOWN | N/A | ···· | UNKNOWN | 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:42:53.713Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty