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-52883 | 2026-07-13T12:13:12Z | Kevin | — | Martin | 1983-05-19 | UNKNOWN | UNKNOWN | - | UNKNOWN | 3725 Park Pl·· | Dallas | TX | 75262-2422 | null | NULL·· |
| TPA | TPA-57669 | 2026-07-06T03:26:20Z | Billy | — | Edwards | 12/05/85 | — | - | 210.735.0803 | - | 5729 Camelback Rd | Tempe | AZ | 85201 | GRP-2171 | MEDICARE-ADV-B |
| TPA | TPA-55972 | 2026-08-12T21:26:33Z | Dunn, Kyle·· | — | — | 1951-12-01 | null | N/A | 7402838678 | kyle.dunn@gmail.com | NULL | UNKNOWN | — | — | GRP-3565 | null |
| TPA | TPA-64268 | 2026-05-29T21:07:12Z | MATTHEWS | ···· | ·RACHEL | 1985-04-21 | N/A | - | 17363774936 | UNKNOWN | 8619 LINCOLN WAY | Los Angeles | California | 90084·· | — | SELECT-EPO |
| TPA | TPA-62062 | 2026-07-18T18:50:53Z | Joan | — | Santos | 1967-06-04 | N/A | — | 16995986810 | null | 7009 Forest Ave | Chandler | AZ | 85293·· | GRP-9283·· | — |
| TPA | TPA-56210 | 2026-08-06T12:23:53Z | Michael, Gibson | — | — | 1986-02-27 | null·· | — | (815) 737-9451 | null·· | 6105 Main Street | Los Angeles | California·· | 90079 | ·UNKNOWN | — |
| TPA | TPA-51045 | 2026-07-16T12:17:49Z | Keith | — | Price | 18-07-1986 | N/A | UNKNOWN | 4895728598 | - | 9495 Palm Dr | Austin | TX | 78749 | GRP-8710 | NULL |
| TPA | TPA-50405 | 2026-06-10T08:15:01Z | Joan | — | Lane | 03/16/49 | UHC-13637-61 | N/A | — | null | 573 Willow Ct #618 | Plano | Texas | 75001 | GRP-1519 | ···· |
| TPA | TPA-61607 | 2026-04-16T22:22:58Z | ·Camila | — | Chen | ·19770112 | — | N/A | 416-684-0302 | ·CAMILA.CHEN38@AOL.COM | 130 HARBOR BOULEVARD | Glendale | AZ | 85327·· | null | CHOICE-PLUS-PPO |
| TPA | TPA-53036 | 2026-08-18T01:09:40Z | LUICA | — | WELCH | 1954-12-01 | — | null | ·946.980.3168 | UNKNOWN | null | NULL | - | — | GRP-3609 | — |
| TPA | TPA-55651 | 2026-01-23T05:35:22Z | RYAN | — | GRANT | 1989-09-27·· | UHC-15044-36 | — | -·· | N/A | ·6174 VALLEY VIEW DR | Tucson | AZ | 85708 | GRP-4283 | NULL |
| TPA | TPA-53604 | 2026-10-09T06:15:02Z | Janet | — | Aguilar | 05/27/06 | UHC-14912-04 | — | +1 604 363 1534 | - | 8479 Lincoln Way | Chandler | AZ | 85261 | — | OPTIONS-PPO |
| TPA | TPA-55631 | 2026-06-18T23:27:28Z | Jutin | — | Jenkins | 2001-04-23 | UHC-39390-63 | — | ·780-314-3492 | -·· | 2202 Harbor Boulevard | Dallas | TX | 75277 | — | null |
| TPA | TPA-63487 | 2026-09-14T13:57:43Z | Janet | — | Hawkins | 1947-06-21 | UNKNOWN | UNKNOWN | +1 783 455 4394 | - | 2446 Indian School Rd | Seattle | WA | 98147-5849 | GRP-1317 | UNKNOWN |
| TPA | TPA-58414 | 2026-01-17T03:13:43Z | Luna, Sarah | — | — | 1994-12-16 | ·· | N/A | N/A | — | 7313 BAYSHORE DR | Sacramento | CA | - | UNKNOWN | — |
| TPA | TPA-58196 | 2026-09-22T14:39:21Z | susan | — | alvarez | 11/1/1965 | N/A | •••-••-6821 | null | null | NULL | N/A | — | NULL | — | NAVIGATE-HMO |
| TPA | TPA-52640 | 2026-04-01T11:56:55Z | Jack·· | — | ·Andrews | 1957-02-02 | UHC-93954-88 | •••-••-8902 | (343) 808-8516 | — | 3279 Forest Avenue | Plano | TX | 75044 | GRP-8882 | CORE-HMO |
| TPA | TPA-63051 | 2026-06-24T11:39:34Z | sofia | — | richards | Jun 9, 1997 | — | — | 5318896083 | UNKNOWN | 7080 Market Street | Tampa | FL | 33690 | GRP-2377 | — |
| TPA | TPA-63348 | 2026-10-15T07:52:54Z | Jaan | R | Knight | 19610401 | UNKNOWN·· | null | NULL | — | 9744 Jefferson Ave | Fresno | CA | 93744 | N/A | SELECT-EPO |
| TPA | TPA-61598 | 2026-04-14T06:36:47Z | Adam | — | Carlson | 4/20/1990 | NULL | •••-••-8950 | UNKNOWN | — | 2767 Lake View Road | Denver | Colorado | 80281 | null | MEDICARE-ADV-B |
| TPA | TPA-54832 | 2026-03-20T22:34:07Z | Alan | — | Morgan | 06/02/1976 | — | — | UNKNOWN·· | ·· | 9755 ELM ST | Glendale | AZ | 85398 | - | — |
| TPA | TPA-57924 | 2026-09-11T12:31:52Z | ANDREW | L | SIMMONS | 1996-11-15·· | — | NULL | 4038688829 | null | 1958 Valley View Drive | Denver | co | 80241-7368 | GRP-4083 | CHOICE-PLUS-PPO·· |
| TPA | TPA-57363 | 2026-07-01T03:06:53Z | kathryn | — | henderson | 11/28/1953 | UNKNOWN | •••-••-7734 | 3124846062 | N/A | 4192 MARKET STREET | Las Vegas | NV | 89134 | NULL | — |
| TPA | TPA-51430 | 2026-02-06T03:11:44Z | Ashley | — | Park | 1946-12-01 | UHC-07501-14 | null | 877-617-0421 | — | ·9167 Forest Ave | San Antonio | Texas | 78297-1352 | — | null |
| TPA | TPA-59472 | 2026-05-26T09:57:30Z | NATHAN·· | M | MARTINEZ | 1944-04-01 | UNKNOWN·· | null | null | — | UNKNOWN | null | UNKNOWN | ···· | N/A | — |
| TPA | TPA-55513 | 2026-04-15T19:56:03Z | Arjun | — | Lucas | 2003-05-25 | — | •••-••-3934 | UNKNOWN | NULL | 5737 Market St | ·TEMPE | AZ | 85288-2223 | GRP-3195 | MEDICARE-ADV-A |
| TPA | TPA-58273 | 2026-05-15T08:20:57Z | PAUL | — | WHITE | 1995-03-22 | N/A | - | NULL | paul.white53@gmail.com | 3950 Elm Street | Seattle | wa | ·98132 | UNKNOWN | NAVIGATE-HMO |
| TPA | TPA-54208 | 2026-05-26T02:36:30Z | AAROON | — | TAYLOR | 6/11/1978 | NULL | UNKNOWN | — | - | 4151 SAGE COURT | ·Las Vegas | NV | 89197 | NULL | UNKNOWN |
| TPA | TPA-53629 | 2026-02-17T07:51:56Z | Mari | — | Castro·· | 3/13/1982 | UHC-41645-88 | •••-••-9503 | null | UNKNOWN | 2918 Grand Avenue | COLUMBUS | OH | 43214 | - | N/A |
| TPA | TPA-64461 | 2026-08-22T12:51:17Z | ·ZACHARY | — | OBRIEN | 1948-08-01 | UHC-85761-47 | •••-••-2811 | (207) 445-0059 | — | 3899 Main St | Seattle | Washington | 98129 | — | null |
| TPA | TPA-53120 | 2026-08-20T14:46:09Z | Nathan | — | Schultz | 02/18/1968 | NULL | •••-••-8282 | N/A | nathan.schultz@aol.com | 4204 Highland Avenue | Miami | FL·· | 33144-9846 | - | N/A |
| TPA | TPA-53139 | 2026-01-11T03:14:26Z | CHRISTINA | — | GARZA·· | 1981-02-15 | - | •••-••-4769 | null | CHRISTINA.GARZA@PROTON.ME | 305 Church Street | ·Tampa | FL | 33664 | GRP-8585 | UNKNOWN |
| TPA | TPA-61657 | 2026-06-06T06:40:35Z | Teresa | — | Hernandez | 1946-09-11 | NULL | NULL | - | — | 5754 Bayshore Dr | Nashville | TN | 37297 | null | — |
| TPA | TPA-54005 | 2026-06-22T02:04:02Z | megan | — | meyer | 1945-04-12 | UNKNOWN | — | — | null | 4769 Park Place | Atlanta | GA | 30330 | N/A | — |
| TPA | TPA-63482 | 2026-03-08T16:43:46Z | Turner, Rachel | ···· | — | 1990-04-03 | null | •••-••-2949 | (212) 652-7212 | null | 2262 Apache Boulevard | Phoenix | AZ | 85045 | null | NULL |
| TPA | TPA-56362 | 2026-06-20T17:28:49Z | ·Janice | ···· | Richards | 1938-06-13 | UHC-36443-23 | — | NULL | - | 2622 Jefferson Avenue | Charlotte | NC | ·28254 | - | UNKNOWN |
| TPA | TPA-60072 | 2026-08-18T23:44:45Z | Linda | — | Gray | 1996-07-15 | NULL | null | ·UNKNOWN | null | 410 Cedar Ln | Tucson | AZ | 85741 | - | - |
| TPA | TPA-54429 | 2026-07-09T12:43:43Z | Abigail | — | Reynolds | 1976-04-27 | — | - | UNKNOWN | ABIGAIL.REYNOLDS59@YAHOO.COM | 8152 Ocean Ave | Seattle | WA | 98149 | — | UNKNOWN |
| TPA | TPA-57007 | 2026-10-13T15:30:02Z | Bryan | — | Evans | 08/25/2007 | — | null | null | - | 4502 CANYON RD | Los Angeles | CA | 90094 | — | - |
| TPA | TPA-51212 | 2026-08-07T12:19:13Z | joyce | P | guerrero | 1962-03-27 | - | N/A | (858) 478-9486 | N/A | — | null | null | UNKNOWN | GRP-1383 | NULL |
| TPA | TPA-50583 | 2026-09-22T03:19:16Z | RAYMOND | U. | FOSTER | 1973-06-17 | N/A | •••-••-0326 | (286) 986-9404 | — | 9571 Sunset Blvd #201 | Jacksonville | FL | 32262 | GRP-2308 | NULL |
| TPA | TPA-54032 | 2026-03-26T06:32:44Z | stephanie | ···· | hamilton | 19630904 | - | •••-••-3187 | 429-332-9333 | — | - | — | UNKNOWN | NULL | N/A | UNKNOWN·· |
| TPA | TPA-59842 | 2026-06-05T22:52:47Z | Andrew | — | Carr | 1974-06-15 | — | UNKNOWN | N/A | ···· | 1806 CHURCH ST | ·Houston | TX | — | - | null |
| TPA | TPA-50189 | 2026-08-01T06:25:59Z | JACK | — | ROBERTS | 1985-02-01 | — | ···· | null | jack.roberts22@outlook.com | 2800 Lake View Rd | ATLANTA | GA | 30335 | — | CHOICE-PLUS-PPO |
| TPA | TPA-57193 | 2026-04-04T20:38:01Z | KEITH | — | HART | 11/11/1964 | N/A | null | UNKNOWN | UNKNOWN | — | null | ···· | - | — | OPTIONS-PPO |
| TPA | TPA-63915 | 2026-10-09T20:44:19Z | KATHRYN | — | CAMPBELL·· | 1983-12-01 | ·· | UNKNOWN | — | - | 3280 Valley View Drive Apt 8 | Los Angeles | California | NULL | null | UNKNOWN |
| TPA | TPA-60519 | 2026-06-07T13:15:42Z | Brenda | — | Perez | 1983-01-14 | UHC-39508-63 | ···· | 304.705.0832·· | N/A | 6158 Camelback Rd Apt 23 | Houston | Texas | 77070 | GRP-8433 | OPTIONS-PPO |
| TPA | TPA-63004 | 2026-08-23T10:32:13Z | Martha | — | Carpenter | 20010423 | — | UNKNOWN | null | UNKNOWN | 8661 Valley View Drive | Seattle | Washington | 98122 | GRP-9724 | — |
| TPA | TPA-59300 | 2026-06-12T03:37:35Z | SCOTT | — | ROGERS | 1975-04-10 | ···· | — | — | - | — | — | NULL | — | — | NULL |
| TPA | TPA-59992 | 2026-05-25T08:49:49Z | WILLIAM | — | HUDSON | 11-08-1995 | UHC-43451-15 | •••-••-9450 | - | N/A | 5967 CHURCH STREET | Tempe | AZ | 85298 | - | ·· |
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:40.596Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty