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-51425 | 2026-02-17T05:55:26Z | Hiroshi | — | Cunningham | 1950-08-06 | — | ·UNKNOWN | 2743143055 | HIROSHI.CUNNINGHAM55@ICLOUD.COM | 590 Spring St | GLENDALE | AZ | 85378 | null | NULL |
| TPA | TPA-55083 | 2026-05-05T06:49:40Z | JUAN | ·· | WILLLIS·· | — | — | UNKNOWN | 18037177315 | NULL | 5963 Maple Avenue·· | Phoenix | AZ·· | 85001 | GRP-2864 | N/A |
| TPA | TPA-62654 | 2026-02-24T06:47:35Z | Martha | — | Davis | 19830103·· | — | NULL | N/A | martha.davis17@aol.com | 1368 HARBOR BLVD | SAN ANTONIO | Texas | 78271 | GRP-9133·· | N/A |
| TPA | TPA-50259 | 2026-10-07T22:25:26Z | DONALD | — | MORRIS | 4/15/1942 | NULL | •••-••-2331 | - | N/A·· | 8022 Elm Street | San Antonio | TX | 78268 | N/A | — |
| TPA | TPA-62683 | 2026-07-26T19:24:12Z | hiroshi | ···· | mccoy | 03/02/1978 | null | NULL | - | N/A | 5533 River Road | JACKSONVILLE | FL | 32240 | GRP-5371 | UNKNOWN |
| TPA | TPA-58922 | 2026-03-17T10:24:04Z | DAN | — | SOTO | 1985-08-17 | UNKNOWN | N/A | ·5748152457 | N/A | 1606 BROADWAY | Seattle | WA | 98175 | - | NAVIGATE-HMO |
| TPA | TPA-59292 | 2026-02-12T14:31:56Z | Hannah | ·· | Huffman | ·1951-10-12 | UHC-41519-61 | •••-••-4346 | NULL | — | 2300 Elm St | Orlando | FL | 32879 | GRP-1567 | — |
| TPA | TPA-54317 | 2026-07-24T08:48:06Z | Charlotte | — | Miills | May 22, 1978 | UNKNOWN | — | 18927547567 | — | — | UNKNOWN | NULL | - | GRP-0829 | UNKNOWN |
| TPA | TPA-51998 | 2026-06-07T17:32:20Z | Susan | R. | Perz | 1949-07-28 | — | UNKNOWN | 7632615146 | null | 4019 Sage Court·· | Nashville | TN | 37255 | GRP-3588 | — |
| TPA | TPA-50308 | 2026-10-14T07:19:12Z | Scott, Dylan | B | ·· | 1971-07-22 | — | null | null | ·· | 450 PINE DR | Houston | TX | 77048 | ·null | ···· |
| TPA | TPA-54357 | 2026-03-09T17:02:01Z | Peter | ···· | Wong | 05/19/65 | ·null | UNKNOWN | 3798657689 | UNKNOWN | 1640 OCEAN AVENUE | Seattle | WA | — | null | UNKNOWN |
| TPA | TPA-59340 | 2026-09-24T18:19:34Z | Virginia | — | Ray | 1956-07-22 | N/A | •••-••-0654 | 937.257.1397 | — | 350 Union St | Phoenix | AZ | 85045 | GRP-5360 | — |
| TPA | TPA-52690 | 2026-05-14T21:30:52Z | Laura | — | Perkins | 1956-09-28 | — | •••-••-1806 | UNKNOWN | — | 5448 Baseline Rd #300 | Minneapolis | MN | UNKNOWN | GRP-9529 | -·· |
| TPA | TPA-61151 | 2026-09-01T23:45:34Z | Josh | — | Ellis | 09/02/98 | UHC-44602-44 | •••-••-1479 | 3792846 | NULL | 1169 Grand Avenue | Los Angeles | CA | 90070 | GRP-1058 | ·N/A |
| TPA | TPA-53990 | 2026-05-30T07:59:06Z | ·cheryl | — | stepehns | 2008-06-25 | NULL | - | N/A | — | 8534 VALLEY VIEW DR Apt 5 | AUSTIN | TX | null | NULL | — |
| TPA | TPA-51503 | 2026-06-23T10:37:43Z | Dorothy | — | Murphy | 2007-02-08 | null | ···· | 901.227.2654 | dorothy.murphy@aol.com | NULL | — | — | ···· | null | SELECT-EPO |
| TPA | TPA-56740 | 2026-07-22T20:30:49Z | JACQUELINE | — | MCCOY | 1939-11-01 | NULL | — | 9819756254 | null | 4927 CHURCH STREET | San Antonio | TX | N/A | NULL | ·NULL |
| TPA | TPA-53482 | 2026-04-23T20:06:01Z | STEPHEN | — | MORRISON·· | 1955-04-04 | — | — | 8273150 | UNKNOWN | 8567 Spring Street | San Diego | CA | 92111 | — | UNKNOWN |
| TPA | TPA-59870 | 2026-05-02T13:58:00Z | Stephen | — | Tran | 01/12/1996 | — | UNKNOWN | 3633447175 | N/A | 7193 Ridge Rd | Las Vegas | NV | 89142 | NULL | UNKNOWN |
| TPA | TPA-50100 | 2026-03-27T13:09:57Z | ·Maria | — | Jenkins | 19770406 | UHC-71956-21 | N/A·· | 925-202-9296 | NULL | 9603 Elm St | CHANDLER | AZ | N/A | ·GRP-2841 | CORE-HMO |
| TPA | TPA-59582 | 2026-03-22T14:58:53Z | TIM | — | SULLIVAN | 05/26/92 | UHC-76596-84 | ·NULL | ·3903477696 | N/A | 5317 WASHINGTON ST | Charlotte | NC | 28214 | — | ·· |
| TPA | TPA-64406 | 2026-07-18T17:04:47Z | Richard | — | Perry | ·Mar 20, 1964 | NULL | N/A | NULL | NULL | ·1196 Park Place | Atlanta | ga | 30302 | UNKNOWN | ·UNKNOWN |
| TPA | TPA-64340 | 2026-05-09T04:18:06Z | Jdy | — | Chen | 1980-06-18 | N/A | N/A | 735-238-0371 | NULL | 7401 DESERT SKY BOULEVARD | Fresno | CA | 93790-1699 | null | — |
| TPA | TPA-57907 | 2026-01-27T07:29:56Z | CARLOS | — | GORDON | 06/11/2005 | UNKNOWN | null | - | null | — | — | ·NULL | UNKNOWN | UNKNOWN | MEDICARE-ADV-B |
| TPA | TPA-51936 | 2026-10-13T03:19:03Z | Justin | — | Crawford | 1982-10-08 | ···· | — | (491) 553-8423 | - | 3216 PARK PLACE | Houston | TX | ·77003 | N/A | SELECT-EPO·· |
| TPA | TPA-50245 | 2026-05-09T11:46:20Z | Tyler·· | L. | Moreno | 1994-11-12 | - | null | 246.291.9795 | — | ·· | N/A | - | — | — | — |
| TPA | TPA-51118 | 2026-08-13T20:45:21Z | Ken | — | Hughes | Aug 17, 1975 | — | — | - | — | 3248 Bayshore Drive | Miami | FL | 33115 | — | null |
| TPA | TPA-62441 | 2026-05-17T21:53:08Z | Mei | — | Clark | 3/9/1987 | NULL | - | null | null | 4102 SUNSET BLVD | Glendale | AZ | 85329 | — | ···· |
| TPA | TPA-50437 | 2026-03-02T17:22:17Z | Heather | — | Spencer | 03/24/1971 | — | •••-••-2098 | N/A | — | 7133 Church St | Los Angeles | CA | 90065 | — | ···· |
| TPA | TPA-56109 | 2026-02-27T07:15:06Z | Diana | V·· | Bowman | 1949-07-02·· | — | N/A | (837) 605-7654 | ···· | 3258 Forest Avenue | Tucson | AZ | 85742 | GRP-9919 | UNKNOWN·· |
| TPA | TPA-63061 | 2026-03-21T17:52:27Z | Jeffrey | — | Phillips | 6/27/1977 | UHC-08341-30 | NULL | ·· | - | null | — | — | N/A | - | — |
| TPA | TPA-55235 | 2026-09-07T16:58:10Z | Ahmed | — | Hicks | Aug 28, 1956 | — | N/A | — | UNKNOWN | 8970 Union St | JACKSONVILLE | FL | 32282 | GRP-0985 | MEDICARE-ADV-B |
| TPA | TPA-53402 | 2026-01-13T23:31:08Z | betty | — | boyd | 2001-09-14 | — | UNKNOWN | — | N/A | 1692 Sage Court | MESA | AZ | 85280 | null | null |
| TPA | TPA-60613 | 2026-05-14T04:12:55Z | TYLER | — | SILVA | 1993-01-21 | ·N/A | ···· | 230.463.2573 | null | UNKNOWN | - | — | — | NULL | UNKNOWN |
| TPA | TPA-54255 | 2026-04-13T15:51:04Z | Christian | — | Weber·· | 09/04/08 | null·· | •••-••-2226 | N/A | — | 9393 Cedar Lane #333 | ·Plano | TX | UNKNOWN | UNKNOWN | — |
| TPA | TPA-63369 | 2026-01-31T02:15:59Z | Stewart, Virginia | — | — | 1982-10-17 | NULL·· | NULL | 229.992.9134 | — | 1770 CHURCH STREET | Tucson | AZ | 85715 | GRP-1207 | NAVIGATE-HMO |
| TPA | TPA-52950 | 2026-06-12T15:04:03Z | ·KATHERINE | — | CONTRERAS | 2008-08-11 | - | — | N/A | — | 5484 Mountain View Dr | San Diego | CA·· | 92100 | NULL | NULL |
| TPA | TPA-60770 | 2026-05-31T23:09:51Z | RALPH | A | RUIZ | 05/14/50 | — | - | null | null | null | N/A | N/A | — | UNKNOWN | ·null |
| TPA | TPA-55002 | 2026-07-21T07:10:40Z | DAINA | — | GRANT | 26-09-1941 | UHC-53597-96 | N/A | 5215756151 | - | 9206 Apache Blvd #662 | Glendale | AZ | 85350 | -·· | ·UNKNOWN |
| TPA | TPA-56202 | 2026-08-30T23:33:20Z | MICHAEL | — | FRANKLIN | 13-08-1977 | — | NULL | — | NULL | 4937 Canyon Road | Plano | Texas | 75059 | null | — |
| TPA | TPA-55809 | 2026-04-01T09:27:47Z | Emily | ···· | Homes | 19790701 | UHC-72045-46 | •••-••-6055 | — | null | - | ·UNKNOWN | — | ···· | N/A | N/A |
| TPA | TPA-57100 | 2026-08-25T02:34:52Z | BETTY | T | ·GREEN | Feb 8, 1957 | — | - | NULL·· | UNKNOWN | 7997 LAKE VIEW ROAD | ·JACKSONVILLE | FL | — | GRP-8572 | CORE-HMO |
| TPA | TPA-52973 | 2026-10-01T10:50:09Z | JEFFREY | — | HOFFMAN | 1975-03-12 | — | NULL | — | ·· | 697 LINCOLN WAY | Tucson | AZ | 85733 | — | — |
| TPA | TPA-56772 | 2026-06-12T22:16:16Z | Tom | — | Wheeler·· | 1949-11-20 | — | — | UNKNOWN | null | 8332 Canyon Rd | Scottsdale | AZ | 85260 | — | null |
| TPA | TPA-63154 | 2026-02-27T22:46:50Z | Julia | — | Chapman | 09/26/2008 | null | •••-••-4623 | NULL | N/A | N/A·· | N/A | NULL | NULL | - | — |
| TPA | TPA-52591 | 2026-02-11T17:39:15Z | Sara | — | King | 1996-12-15 | UNKNOWN | N/A·· | — | SARA.KING@ICLOUD.COM | 4661 CENTRAL AVE | Tucson | AZ | 85706 | GRP-0522 | CORE-HMO |
| TPA | TPA-61904 | 2026-01-15T19:08:15Z | Butler, Katherine | — | — | ·· | - | •••-••-3430 | 7905444668 | katherine.butler64@aol.com | 7504 DESERT SKY BLVD | Houston | TX | UNKNOWN | — | - |
| TPA | TPA-63565 | 2026-07-09T07:23:52Z | Fatima | — | Schmidt | Oct 17, 1955 | — | — | — | UNKNOWN | 6559 Highland Ave | Los Angeles | ca | 90068 | GRP-8031 | UNKNOWN |
| TPA | TPA-55783 | 2026-09-09T22:56:20Z | Zachary | — | Morales | 08/08/95 | NULL | •••-••-2600 | N/A | null | 9060 Washington St | Tampa | FL | — | GRP-2317 | UNKNOWN |
| TPA | TPA-54611 | 2026-07-20T20:19:04Z | jamas | — | burke | Apr 13, 1984 | — | •••-••-0800 | (476) 898-2074 | N/A | 2643 Park Pl·· | Dallas | Texas | 75285·· | — | N/A |
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:43.457Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty