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-52036 | 2026-07-20T17:48:57Z | Bowman, Eric | — | — | 1954-03-13 | — | — | 8486886455 | ·NULL | 3834 SPRING STREET | Denver | Colorado | 80251 | UNKNOWN | null |
| TPA | TPA-63299 | 2026-09-25T01:11:35Z | JENNIFER | — | GEORGE | 1999-11-04 | — | •••-••-0531 | - | ·N/A | 2137 SAGE CT | SEATTLE | wa | 98192 | GRP-3801 | MEDICARE-ADV-A |
| TPA | TPA-53758 | 2026-06-28T03:53:56Z | William | — | Hayes | 1968-09-28 | ·null | null | 2172709195 | NULL | - | — | N/A | — | null·· | CORE-HMO |
| TPA | TPA-60228 | 2026-08-10T11:38:41Z | PHILIP | R | ROBINSON | 1977-01-04 | null | - | UNKNOWN | — | 9046 Valley View Dr | DALLAS | TX | 75249 | null | null·· |
| TPA | TPA-62423 | 2026-02-03T02:17:23Z | CHRISTOPHER | — | ·WELLS | 04/09/1953 | - | - | ···· | null | — | UNKNOWN | — | — | — | MEDICARE-ADV-A |
| TPA | TPA-62532 | 2026-09-05T19:22:31Z | Bobby | ·· | Santos | Jan 24, 1953 | ···· | — | N/A | null | 1155 Jefferson Ave | CHANDLER | AZ | 85214 | null | select-epo |
| TPA | TPA-53817 | 2026-06-19T12:11:58Z | Carlos | ···· | ·Li | 1979-07-08 | UNKNOWN | •••-••-4832 | - | ·- | 8294 GRAND AVE #401 | JACKSONVILLE | fl | ·32266 | — | — |
| TPA | TPA-60545 | 2026-01-08T11:42:42Z | JASON | — | BURNS | 1975-12-26 | - | •••-••-0594 | — | N/A | 5434 Camelback Road | EDEN PRAIRIE | MN | 55310 | — | — |
| TPA | TPA-52681 | 2026-07-21T08:27:07Z | DEBRA | — | ROBERTSON | 1940-12-17 | - | •••-••-6083 | 614-314-3770 | — | 668 Union Street | Atlanta·· | GA | 30396·· | GRP-1891 | — |
| TPA | TPA-52159 | 2026-05-25T02:34:23Z | AISHA | — | BERRY | 07-03-1976 | NULL | •••-••-5575 | NULL·· | null | 2814 Oak St | Columbus | OH | 43226 | GRP-9554 | NULL |
| TPA | TPA-58177 | 2026-06-06T17:02:19Z | CAMILA | — | HOWELL | 1993-08-02 | UHC-03133-67 | — | N/A | camila.howell@yahoo.com | 882 Harbor Boulevard | PHOENIX | AZ | 85036 | — | — |
| TPA | TPA-60091 | 2026-04-05T10:18:23Z | Julie | — | Dixon | 19470503 | NULL | N/A | 8718050839 | julie.dixon89@aol.com | 8661 Bayshore Dr | GILBERT | AZ | 85249 | GRP-3678 | N/A |
| TPA | TPA-60951 | 2026-06-04T07:06:13Z | Andrew | — | Hunt·· | 2060-10-23 | — | N/A | N/A·· | null | null | — | — | NULL | - | N/A |
| TPA | TPA-59115 | 2026-05-22T01:36:29Z | gary | — | jenkins | 19809508 | N/A | N/A | — | - | 5509 Palm Dr Apt 32 | ·Jacksonville | FL | 32273 | GRP-1064 | MEDICARE-ADV-B |
| TPA | TPA-62472 | 2026-03-28T05:01:06Z | Vargas, Roy | — | — | 1985-08-04 | null | •••-••-9160 | 5765607975 | roy.vargas@aol.com | 4832 Canyon Road | Los Angeles | CA | 90037 | GRP-6016 | NULL |
| TPA | TPA-64183 | 2026-02-07T15:17:52Z | Robert | — | Nguyen | 2006-12-04 | null | UNKNOWN | — | - | 2915 Bayshore Dr | ·Orlando | FL | 32870 | UNKNOWN | — |
| TPA | TPA-51815 | 2026-05-25T07:11:15Z | JEFFREY | — | ALLEN | 1962-11-20 | NULL | •••-••-2319 | UNKNOWN | — | 1697 Main Street | Charlotte·· | NC | 28217 | GRP-7130 | - |
| TPA | TPA-60180 | 2026-06-28T12:28:23Z | Brittany | — | Tucker | 1999-05-07 | — | null | — | ·NULL | 6765 Central Ave | Los Angeles | CA | 90078 | GRP-2733 | NAVIGATE-HMO·· |
| TPA | TPA-64449 | 2026-07-19T00:09:39Z | Hunter, Jesse | — | — | 1943-06-08 | — | UNKNOWN | ·· | jesse.hunter@yahoo.com | 1690 Willow Ct | Phoenix | Arizona | 85035 | GRP-5954 | — |
| TPA | TPA-57512 | 2026-05-09T20:16:51Z | Sofia | ···· | Carter | Jan 28, 1998 | — | •••-••-5780 | 9024502387 | SOFIA.CARTER@YAHOO.COM | 9329 Broadway | Tucson | AZ | 85703 | null | — |
| TPA | TPA-59773 | 2026-01-06T15:54:31Z | Albert | — | Sanders | 05/06/76 | — | null | N/A | - | 5471 Camelback Road | LAS VEGAS | NV | ·89161 | NULL | N/A |
| TPA | TPA-58636 | 2026-04-02T22:04:21Z | Peter·· | — | Franklin·· | 07/04/1976 | null·· | null | (838) 664-5999 | — | 7052 Camelback Road | Tempe·· | AZ | 85225 | — | NULL |
| TPA | TPA-52267 | 2026-03-22T00:56:48Z | JANICE | — | ROBERTSON | 2007-08-28 | N/A | •••-••-8038 | null | — | ·8290 Broadway | Charlotte | ·NC | 28224 | N/A | ·- |
| TPA | TPA-62615 | 2026-08-15T21:45:46Z | Natalie | — | Phillips | 10/11/1986 | — | null | - | null·· | ·1429 CEDAR LANE | Gilbert | ·AZ | 85213 | N/A | NULL |
| TPA | TPA-62189 | 2026-01-15T14:28:43Z | Kennedy, Christian | — | — | 04/16/89 | UNKNOWN | — | 13328882491 | — | 7388 Canyon Road | ·San Diego | CA | NULL | null | ·N/A |
| TPA | TPA-63698 | 2026-06-07T15:09:59Z | Judy | — | Oliver | 1939-40-05 | ···· | null | ·+1 607 556 4845 | — | 9763 Harbor Blvd | Plano | ·TX | 75089·· | - | — |
| TPA | TPA-61085 | 2026-03-06T07:51:54Z | Sara | — | Hoffman | 1944-11-21 | UHC-72647-57 | — | — | N/A | 4871 Forest Avenue | Fresno | CA | 93792-8980 | GRP-7105 | UNKNOWN |
| TPA | TPA-62270 | 2026-01-31T00:57:26Z | EIMLY | — | LANE | 1943-08-08 | - | NULL·· | NULL | ·· | 3213 BAYSHORE DR | TUCSON | AZ | 85794-0723 | GRP-1369 | ·- |
| TPA | TPA-50598 | 2026-07-16T03:42:15Z | Andrea | — | McDonald | 02/20/60 | N/A | — | NULL | ANDREA.MCDONALD@GMAIL.COM·· | 8541 Camelback Rd | Tempe | Arizona | 85238 | — | CHOICE-PLUS-PPO |
| TPA | TPA-63000 | 2026-10-07T01:12:44Z | Teerry | — | Fernandez | 06/18/91 | - | •••-••-1394 | — | - | 2920 PINE DRIVE | ATLANTA | Georgia | 30330 | null | SELECT-EPO |
| TPA | TPA-54671 | 2026-08-20T00:18:15Z | RACHEL | — | PATTERSON | 27-11-1941·· | — | •••-••-0640 | (891) 751-3625 | — | 8143 MOUNTAIN VIEW DRIVE | Tampa | FL | 33686 | GRP-0645 | null |
| TPA | TPA-61262 | 2026-05-12T09:08:12Z | Jeffrey | V | Soto | ·08/10/2006 | - | •••-••-9590 | 313-405-5672 | - | 4743 DESERT SKY BOULEVARD | Fresno | California | 93734 | GRP-4563 | NULL |
| TPA | TPA-59355 | 2026-09-16T04:07:47Z | Sean | — | Wallacce·· | 10/23/94 | UHC-48266-32 | — | - | SEAN.WALLACE11@GMAIL.COM | — | null | N/A | null | — | N/A·· |
| TPA | TPA-50694 | 2026-07-18T16:17:25Z | Russell | — | Aguilar | 4/6/2004 | — | null | (666) 300-6532 | RUSSELL.AGUILAR@HOTMAIL.COM | 7938 Elm Street | Jacksonville | FL | 32281·· | ·NULL | UNKNOWN |
| TPA | TPA-63687 | 2026-05-14T20:25:11Z | Christian | — | Coleman·· | 2001-06-07 | — | — | (637) 822-6687 | — | 1394 PALM DRIVE #409 | San Diego | CA | N/A | GRP-0513 | — |
| TPA | TPA-52508 | 2026-01-15T05:13:04Z | Jon | — | Foster | 1953-09-06 | NULL | UNKNOWN | 9493297184 | — | 7387 LAKE VIEW RD | CHARLOTTE | NC | 28284 | — | NULL |
| TPA | TPA-61333 | 2026-09-12T05:56:20Z | Judith | — | Martinez | 1/7/1969 | — | UNKNOWN | — | JUDITH.MARTINEZ97@YAHOO.COM | 7901 SPRING STREET | Scottsdale | AZ | 85213 | ·null | — |
| TPA | TPA-64309 | 2026-02-22T18:51:40Z | DOUGLAS | — | WEAVER | 2008-03-14 | — | NULL | 7586783104 | NULL | 1360 Jefferson Avenue | LAS VEGAS | NV | 89105 | ···· | SELECT-EPO |
| TPA | TPA-51092 | 2026-06-03T17:20:04Z | KELLY | — | CARTER | 1946-06-03 | null | null | — | null | 405 Maple Ave | San Antonio | TX | 78269 | — | OPTIONS-PPO |
| TPA | TPA-60242 | 2026-02-18T04:09:34Z | Laura·· | — | Schmidt | 2005-07-10 | - | UNKNOWN | +1 569 975 2119 | UNKNOWN | 4315 Union Street | MESA | ·AZ | 85230 | — | NULL |
| TPA | TPA-60098 | 2026-03-20T00:43:14Z | Omar | — | Schultz | 1966-11-10 | null | •••-••-7237 | NULL | N/A | 6554 Park Pl | AUSTIN | TX | ·78727 | NULL | — |
| TPA | TPA-62118 | 2026-08-13T21:59:10Z | CHRISTIAN | — | HOLMES | 1951-08-01 | NULL | - | 5494875285 | UNKNOWN | 4067 HIGHLAND AVE | Minneapolis | mn | 55474 | N/A | - |
| TPA | TPA-52074 | 2026-08-23T10:22:04Z | Steven | — | ·Alvarez | 1980-01-26 | NULL | •••-••-8662 | — | ···· | 6128 Oak St | Gilbert | AZ | 85277 | ·· | — |
| TPA | TPA-50141 | 2026-06-03T00:48:15Z | JESSICA | — | MEYER | 2008-11-21 | UHC-28846-42 | — | null | — | — | N/A·· | ·N/A | — | N/A | OPTIONS-PPO |
| TPA | TPA-60657 | 2026-01-17T10:51:26Z | brian | — | thomas | 1968-11-22 | — | — | 716.739.8921 | — | 4478 River Road | San Diego | ca | 92183 | NULL | UNKNOWN |
| TPA | TPA-63070 | 2026-01-31T23:21:50Z | JONATHAN | — | GUTIEERREZ | 02/09/04 | — | •••-••-7517 | N/A | null | 2956 Market St | SCOTTSDALE | AZ | 85200 | null | — |
| TPA | TPA-55154 | 2026-02-15T06:49:10Z | Woods, Linda | — | — | 1985-02-22 | UHC-71404-90 | null | 422-223-9785 | null | 2889 PALM DR·· | Austin | TX | 78736 | ·GRP-6186 | - |
| TPA | TPA-53574 | 2026-02-02T02:34:00Z | Charlotte | — | Simmons | ·1961-05-14 | UHC-98486-13 | •••-••-8658 | null | - | — | null | ···· | null | ···· | OPTIONS-PPO |
| TPA | TPA-56154 | 2026-03-02T13:20:59Z | pamela | G | chen | 1941-11-06 | null | — | (797) 943-7379 | pamela.chen@proton.me | null | UNKNOWN | — | ·UNKNOWN | NULL | N/A |
| TPA | TPA-64411 | 2026-08-22T11:42:17Z | EMILY·· | — | STEPHENS | 8/13/1940 | - | N/A | ·· | N/A | 7973 MESA DR | Scottsdale | Arizona | 85204 | ·· | — |
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.478Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty