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-50191 | 2026-09-12T16:44:21Z | Cheryl | R. | Fernandez | 1964-05-13 | UNKNOWN | — | null | — | 5415 LAKE VIEW RD | ·San Diego | CA | 92152 | — | null |
| TPA | TPA-52892 | 2026-10-18T17:21:06Z | Hicks, Joyce | — | — | 1968-07-04 | — | •••-••-1379 | NULL | JOYCE.HICKS89@OUTLOOK.COM·· | 5364 UNION ST | Miami·· | FL | 33192 | N/A | NAVIGATE-HMO |
| TPA | TPA-57825 | 2026-02-13T06:17:55Z | ·Brandon | ···· | Carpenter | 1975-06-24·· | UNKNOWN | null | 254-579-1030 | N/A | 7531 CEDAR LN | Los Angeles | CA | 90067 | N/A | NULL |
| TPA | TPA-63547 | 2026-08-07T03:38:40Z | DENNIS | — | DELGADO·· | Aug 14, 1991 | - | null | - | UNKNOWN | 7235 BAYSHORE DRIVE | Fresno | CA | 93725 | GRP-8528 | MEDICARE-ADV-A |
| TPA | TPA-53349 | 2026-06-13T03:46:08Z | sofia·· | — | castro | 02/28/1999 | UNKNOWN | — | 8704668083 | — | ·3667 Cedar Lane | Charlotte | NC | 28253 | NULL | NAVIGATE-HMO |
| TPA | TPA-52756 | 2026-08-28T21:08:07Z | Stewart, Bill | — | ···· | 0811-91-76 | - | NULL | 219.807.9607 | — | 7629 Ridge Road | Tampa | fl | 33650·· | -·· | MEDICARE-ADV-A |
| TPA | TPA-54424 | 2026-05-05T03:46:40Z | GARY | — | RODRIGUEZ | 1952-11-10 | N/A | ·null | 666.744.2602·· | NULL·· | 1707 Mesa Drive | ·Chandler | AZ | 85288 | GRP-6473 | null |
| TPA | TPA-57345 | 2026-10-14T11:06:56Z | ·KELLY | — | REED | 1965-04-13 | - | — | UNKNOWN | kelly.reed@hotmail.com·· | 1750 Grand Ave | Minneapolis | MN | 55475 | — | null |
| TPA | TPA-58599 | 2026-04-30T21:15:06Z | Santos, Bradley | ·· | — | 2004-03-03 | — | — | 362.404.3138 | - | ·8363 Sage Ct | PHOENIX | AZ | 85079 | - | — |
| TPA | TPA-53237 | 2026-06-10T02:04:14Z | Brian | — | Vazquez | 1970-01-76 | — | N/A | — | null | 4314 Washington St | Sacramento | CA | 95831 | GRP-8130 | CORE-HMO |
| TPA | TPA-51289 | 2026-07-18T08:58:06Z | ARJUN | — | TURNER | 1984-09-08 | — | N/A | 769-671-7981 | NULL | 8735 VALLEY VIEW DRIVE Apt 1 | PHOENIX | AZ | 85067 | UNKNOWN | null |
| TPA | TPA-50944 | 2026-03-19T14:27:38Z | Ryan | — | Cooper | ·1995-07-25 | null | •••-••-8634 | 634-575-8109 | — | — | — | - | - | - | UNKNOWN |
| TPA | TPA-51116 | 2026-05-08T05:45:34Z | MATEO | — | ·DAY | 12/23/93 | UHC-73777-46 | — | NULL | — | 9132 Main St Apt 24·· | Las Vegas | NV | null | N/A | N/A |
| TPA | TPA-52868 | 2026-07-07T13:46:09Z | Linda | — | Myers | 1975-11-06 | - | •••-••-9762 | +1 246 583 6521 | - | 8146 CHURCH ST | Phoenix | Arizona | 85039 | GRP-3394 | SELECT-EPO |
| TPA | TPA-58577 | 2026-01-24T05:33:48Z | Theersa | — | Hill | 2003-30-17 | — | — | — | — | ·5396 CHURCH ST | San Diego | CA | 92118 | — | UNKNOWN |
| TPA | TPA-57601 | 2026-09-25T19:04:24Z | WILLIE | C | ELLIOTT | 01/20/1943 | N/A | •••-••-6820 | — | willie.elliott@yahoo.com | 9782 RIDGE RD | Tempe | AZ | 85289 | GRP-3253 | NULL |
| TPA | TPA-56423 | 2026-10-17T18:17:26Z | VIRRGINIA | — | HART | Oct 13, 1982 | null | — | (506) 749-8822 | N/A | 4504 Church Street #736 | Miami | Florida | 33139 | GRP-8680 | — |
| TPA | TPA-64136 | 2026-07-14T05:51:09Z | VIRGINIA | — | CARLSON | ·03/18/1993 | NULL | null | ·NULL | null | 4591 VALLEY VIEW DRIVE | Dallas | TX | 75241 | — | ·null |
| TPA | TPA-51920 | 2026-05-11T13:02:29Z | Patrick | ···· | Gutierrez | 1993-10-02 | N/A | •••-••-6501 | N/A | UNKNOWN | 6794 Cedar Ln | Mesa | Arizona·· | — | N/A | OPTIONS-PPO |
| TPA | TPA-56049 | 2026-04-04T01:41:53Z | Mills | — | Maria | Feb 20, 2002 | null·· | - | — | - | 4692 Park Pl | Columbus | OH | 43211 | null | — |
| TPA | TPA-56469 | 2026-04-27T09:12:05Z | MAON | — | YANG | 1939-11-28·· | - | — | +1 918 691 4852 | N/A | 8549 LAKE VIEW RD | PLANO | TX·· | 75072 | null | N/A |
| TPA | TPA-57588 | 2026-03-02T14:32:05Z | ·Russell | Q | Lucas | ·1973-06-11 | UHC-16937-14 | - | ·- | — | ·8307 INDIAN SCHOOL RD | SEATTLE | WA | null | GRP-9606 | — |
| TPA | TPA-56553 | 2026-02-24T08:49:18Z | scott | — | gibson·· | 19661103 | NULL·· | •••-••-0766 | N/A·· | N/A | N/A | — | - | UNKNOWN | — | N/A |
| TPA | TPA-59584 | 2026-08-09T00:02:44Z | LARRY | C | MORALES | 1941-06-09 | — | •••-••-8763 | null | larry.morales@aol.com | 3047 MAIN ST·· | Nashville | TN | ·37222 | UNKNOWN | NULL |
| TPA | TPA-53320 | 2026-06-12T05:24:30Z | JONATHAN | J | SCOTT | 16-01-1964 | — | ···· | (600) 288-1178 | JONATHAN.SCOTT60@PROTON.ME | 5318 Maple Avenue | Seattle | WA | 98159 | - | ·UNKNOWN |
| TPA | TPA-53776 | 2026-04-18T10:19:32Z | AISHA | — | GARZA | 11/19/2000 | N/A | N/A | NULL | aisha.garza19@gmail.com | 6081 Sunset Blvd | Gilbert·· | AZ | 85255 | NULL | CORE-HMO |
| TPA | TPA-52199 | 2026-10-09T04:26:30Z | Isabella | B. | Lawrence | 1943-05-05 | — | — | 2977052794 | — | 2092 Indian School Rd | Minneapolis | MN | 55462 | UNKNOWN | N/A |
| TPA | TPA-59431 | 2026-10-16T02:34:11Z | Ana | ·· | Valdez | 07/18/1946 | - | UNKNOWN | 426-467-3262 | — | 7974 Elm Street | COLUMBUS | OH | N/A | N/A·· | NULL |
| TPA | TPA-61032 | 2026-05-01T05:27:27Z | WILLIE | — | SIMMONS | 1960-04-04 | - | — | (434) 280-8770 | N/A | null | N/A | - | null | ·· | — |
| TPA | TPA-57003 | 2026-05-24T04:33:28Z | Alexander | — | Johnston | 2006-02-24 | null·· | null | 802.851.5682 | — | 3793 LAKE VIEW RD | ·GILBERT | AZ | 85247-1905 | UNKNOWN | - |
| TPA | TPA-51230 | 2026-03-27T20:19:38Z | MICHAEL | — | FERNANDEZ | 2005-12-20 | — | ···· | - | -·· | 4113 Highland Avenue | ·Mesa | AZ | 85282 | GRP-4512 | — |
| TPA | TPA-52288 | 2026-01-19T12:26:18Z | THOMAS | — | BOYD | 1984-09-28 | — | N/A | — | thomas.boyd14@hotmail.com | 7546 Sunset Boulevard | Sacramento | ·California | 95883 | N/A | — |
| TPA | TPA-61741 | 2026-01-20T04:47:49Z | PETER | — | GARRETT·· | 2000-01-10 | UHC-91659-77 | — | (387) 225-6359 | peter.garrett42@outlook.com | — | - | — | UNKNOWN | NULL | — |
| TPA | TPA-57118 | 2026-01-12T23:09:40Z | Walter | ···· | Garcia | 08/07/1973 | N/A | — | — | — | 723 Maple Avenue | Miami | FL | 33117 | GRP-6012 | — |
| TPA | TPA-60926 | 2026-02-21T12:48:41Z | Silva, Keith | — | — | 1987-02-11 | — | — | ·· | UNKNOWN | — | null | — | - | — | MEDICARE-ADV-B |
| TPA | TPA-62252 | 2026-09-28T02:56:30Z | ADAM | — | WEBB | Dec 15, 1998 | null | - | N/A | — | 8448 MEADOW LN·· | Seattle | WA | 98191 | NULL | MEDICARE-ADV-B |
| TPA | TPA-59932 | 2026-06-16T01:29:58Z | Lawrence | M | ·Gonzalez | 1989-09-19 | — | - | (311) 408-6887 | — | 4187 Spring Street | Phoenix·· | ·Arizona | 85036 | GRP-5120 | — |
| TPA | TPA-50829 | 2026-09-29T11:54:15Z | Cloe | — | Stephanie·· | 1997-09-22 | — | — | — | N/A | 4353 OCEAN AVE #180 | Houston | TX | 77031 | GRP-3050 | NULL |
| TPA | TPA-54455 | 2026-04-13T19:16:07Z | Gabriel | N·· | Evaans | 1964-09-06 | UHC-98530-62 | — | — | NULL | 9838 Indian School Road | Phoenix | AZ | — | GRP-7107 | NULL·· |
| TPA | TPA-63037 | 2026-09-10T16:31:51Z | King, Steve·· | — | — | 1969-01-20 | UNKNOWN | — | null | — | 5493 MEADOW LANE | Los Angeles | California | 90019 | GRP-2317 | null·· |
| TPA | TPA-60089 | 2026-10-07T05:40:36Z | KATHLEEN | — | FISHER·· | 1940-06-22 | N/A | — | (405) 256-1273 | — | 8461 Harbor Boulevard | San Diego | CA | 92108 | N/A | — |
| TPA | TPA-50040 | 2026-02-26T22:22:20Z | Sean | — | Jordan | 11/07/1974 | UNKNOWN | — | ·NULL | — | 1511 Elm Street | Houston | tx | 77092 | - | NAVIGATE-HMO |
| TPA | TPA-59106 | 2026-08-07T04:36:05Z | nicole | X. | larson | 1949-01-24 | NULL | — | UNKNOWN | UNKNOWN | ·· | - | — | - | — | NULL·· |
| TPA | TPA-58115 | 2026-04-21T09:01:47Z | JACK | — | WILLIAMSON | 01/11/1973 | — | null | NULL | UNKNOWN | — | UNKNOWN | — | — | GRP-3178 | - |
| TPA | TPA-53569 | 2026-05-30T15:48:06Z | SHIRLEY | — | WELCH | 11/10/1944 | NULL | — | - | ·· | 5380 Washington St | MIAMI | FL | 33147 | - | — |
| TPA | TPA-59111 | 2026-10-10T07:14:32Z | Jonathan | — | Marquez | 08/07/53 | null | — | N/A | — | — | NULL | N/A | — | - | SELECT-EPO |
| TPA | TPA-61417 | 2026-05-19T05:05:07Z | Albert | ···· | Fisher | 1981-06-04 | null·· | N/A | N/A·· | N/A | 9784 Harbor Boulevard | Gilbert | AZ | 85212 | - | CORE-HMO |
| TPA | TPA-51699 | 2026-07-12T08:30:07Z | Margaret | — | Kelley | 1961-12-02 | NULL | UNKNOWN·· | null | — | 6289 Jefferson Ave | Las Vegas | NV | 89138 | — | OPTIONS-PPO |
| TPA | TPA-54865 | 2026-10-18T14:44:20Z | ANN | ···· | GARRETT | 1995-08-12·· | ·NULL | - | — | NULL | ·1339 Valley View Dr | Scottsdale | AZ | 85219 | - | N/A |
| TPA | TPA-62206 | 2026-08-02T22:04:10Z | FRANCES | — | MORRISON | 2003-12-12 | UHC-80015-75 | — | ·NULL | — | NULL | null | - | - | GRP-8874 | 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:56.283Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty