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-53145 | 2026-03-28T17:58:59Z | Sharon·· | — | Nguyen | 1958-04-27 | UNKNOWN | — | UNKNOWN | - | 1832 Central Ave | Mesa | AZ | 85297 | — | null |
| TPA | TPA-58852 | 2026-05-04T04:59:53Z | Daniel·· | — | Webb | 1951-10-12 | null | N/A | 394-852-1162·· | null | 4456 Harbor Boulevard | Denver | ·CO | 80231 | null | OPTIONS-PPO |
| TPA | TPA-52178 | 2026-08-09T15:02:00Z | Christina | ·· | Kennedy | 1985-08-03 | null | •••-••-5507 | 212-834-7188 | UNKNOWN | ·1803 Central Ave | Tucson | Arizona | 85706 | - | CHOICE-PLUS-PPO |
| TPA | TPA-62078 | 2026-08-09T21:31:07Z | Diana | Z. | Long | 05-11-2007 | NULL | •••-••-6065 | - | diana.long@aol.com | 7104 SAGE CT | Houston | TX | null | GRP-5500 | UNKNOWN |
| TPA | TPA-63148 | 2026-02-14T01:16:37Z | BRUCE | — | PATTERSON | 1944-07-05·· | UHC9261498 | — | (203) 825-7838 | N/A | 9161 LAKE VIEW RD | Mesa | Arizona | 85261 | null | N/A |
| TPA | TPA-63540 | 2026-07-12T04:08:37Z | Sharon | — | Davis | 05-09-1995 | null | •••-••-9602 | NULL | NULL | 8337 Canyon Road | Plano | TX | 75066-8092 | NULL·· | — |
| TPA | TPA-59324 | 2026-01-01T04:53:27Z | OMAR | — | COLEMAN | 1979-12-02 | — | UNKNOWN | (252) 920-4577 | UNKNOWN | 4576 Camelback Road Apt 27 | Sacramento | CA | 95816 | NULL | NULL |
| TPA | TPA-52635 | 2026-02-11T10:42:15Z | Lawrence | W. | Jymenez | 9/25/2008 | NULL | •••-••-6323 | 929-321-8124 | N/A | 8191 Valley View Drive | San Antonio | ·TX | 78280 | GRP-1233 | NULL |
| TPA | TPA-53787 | 2026-03-14T21:11:30Z | Bety | — | Le | 1953-07-25 | null | UNKNOWN | — | NULL | 9800 Mesa Drive | Houston·· | TX·· | null | NULL | ·N/A |
| TPA | TPA-61050 | 2026-05-15T02:14:24Z | AMY | — | SIMPSON | 1969-02-17 | — | ·UNKNOWN | — | NULL | 8176 Bayshore Dr | Las Vegas | NV·· | 89144 | GRP-7649 | — |
| TPA | TPA-52108 | 2026-08-29T15:48:45Z | brenda | X. | johnston | 01/24/1996 | — | •••-••-5408 | null | - | 1490 River Road | Tampa | FL | 33656 | GRP-2395 | null |
| TPA | TPA-51897 | 2026-05-14T09:35:16Z | PAMELA | — | CONTRERAS·· | 1990-04-02 | UHC4241479 | NULL | N/A | PAMELA.CONTRERAS24@AOL.COM | 8748 ELM STREET Apt 24 | Las Vegas | NV | 89196 | - | - |
| TPA | TPA-56608 | 2026-04-18T05:46:46Z | Sofia | — | Rice | 1966-12-03 | — | •••-••-8826 | — | null | 7745 MEADOW LANE | Charlotte | NC | 28250 | — | UNKNOWN·· |
| TPA | TPA-62998 | 2026-03-03T01:54:52Z | Carter, Theresa | — | — | 1968-12-13 | ·UHC-04988-64 | N/A | - | ···· | 4683 PALM DRIVE | Chandler | AZ | 85262 | — | OPTIONS-PPO |
| TPA | TPA-58618 | 2026-03-24T21:06:09Z | Bill | S | Perry | 2005-09-14 | — | ·N/A | 6616504482 | — | 5842 Union St | San Diego | ·CA | ·92161 | — | — |
| TPA | TPA-53129 | 2026-09-27T02:05:55Z | Stephen | — | ·Ortega | 12/09/81·· | UHC-46040-53 | NULL | - | — | 6922 Meadow Lane | Gilbert | AZ | 85224 | — | N/A |
| TPA | TPA-53067 | 2026-04-16T09:02:19Z | AMANDA | — | SIMMONS | 4/10/1964·· | N/A | UNKNOWN | — | ·amanda.simmons37@yahoo.com | 9164 Camelback Road·· | Mesa | AZ | 85207 | - | MEDICARE-ADV-B·· |
| TPA | TPA-57290 | 2026-08-21T07:21:09Z | Debra | — | Wagner | 1967-06-21 | - | •••-••-6028 | NULL | debra.wagner45@hotmail.com | 4557 CANYON ROAD | San Antonio | TX | 78240-0993 | GRP-1718 | null |
| TPA | TPA-56045 | 2026-06-26T18:45:25Z | Fowler, Bradley | — | — | 12/25/1996 | - | •••-••-5921 | — | — | 9853 LAKE VIEW ROAD·· | GILBERT | az | 85288 | GRP-6941 | MEDICARE-ADV-B |
| TPA | TPA-55483 | 2026-07-29T09:54:40Z | Nathan | P | Hanson | 1990-08-26 | NULL | - | — | ·NATHAN.HANSON@ICLOUD.COM | 964 Lincoln Way | Austin | TX | 78716 | GRP-4612 | ·NULL |
| TPA | TPA-55746 | 2026-01-31T18:41:09Z | Diana | — | Jordan | 12/17/1997 | ·NULL | — | — | — | 2158 RIDGE RD | Columbus | ·OH | 43250·· | — | null |
| TPA | TPA-60141 | 2026-03-18T19:35:54Z | KENNETH | — | NGUYEEN | 1990-12-14 | null | -·· | UNKNOWN | UNKNOWN | 8140 Palm Dr | Las Vegas | NV | 89149-2709 | GRP-0918 | SELECT-EPO |
| TPA | TPA-53464 | 2026-01-26T17:21:42Z | GERALD | — | ·MARTINEZ | 1955-10-03 | NULL | — | — | gerald.martinez12@gmail.com·· | 4734 GRAND AVE | ·Dallas | tx | 75298·· | NULL | UNKNOWN |
| TPA | TPA-62027 | 2026-09-17T17:20:34Z | DOROTHY | — | HOWELL | 1990-10-05 | UHC-62871-74 | •••-••-7343 | 319-691-0269 | NULL | 8359 Maple Avenue | San Diego | CA | 92167 | GRP-1323 | — |
| TPA | TPA-52494 | 2026-01-14T14:54:30Z | James | — | Rivera | ·1959-08-11 | NULL | — | +1 689 686 9435 | N/A | 1090 SPRING STREET | GLENDALE | AZ | 85375 | N/A | NULL |
| TPA | TPA-53610 | 2026-07-19T05:52:19Z | Isabella | — | Fernandez | 1970-27-11 | - | N/A | — | — | 4521 Jefferson Avenue | ORLANDO | FL | 32843 | N/A | — |
| TPA | TPA-50987 | 2026-09-30T06:22:23Z | PAMELA | R | VAZQUEZ | 04/22/1976 | — | NULL | (265) 771-8014 | N/A | 2062 Park Place | Fresno | California | 93758-8290 | null | - |
| TPA | TPA-57626 | 2026-06-24T15:22:58Z | adam | — | dunn | 2005-09-13 | — | •••-••-3699 | 9466266907 | ADAM.DUNN@PROTON.ME | 232 Lincoln Way | Atlanta | ·GA | 30366 | GRP-9344 | MEDICARE-ADV-B |
| TPA | TPA-51080 | 2026-08-28T10:48:25Z | lucia | — | ·hansen | 1985-01-22 | - | NULL | +1 335 743 4090 | UNKNOWN | 671 MAPLE AVENUE | MESA | AZ | 85293 | GRP-9331 | NULL |
| TPA | TPA-52825 | 2026-08-30T23:37:19Z | Philip | — | Bradley·· | 1945-06-28 | UHC-47879-82·· | •••-••-4225 | 629.984.4473 | ···· | 2457 HILLCREST RD | Minneapolis | MN | 55448·· | ···· | — |
| TPA | TPA-61716 | 2026-03-20T21:29:26Z | ralph | G | estrada·· | 1976-01-02 | UHC-70370-72 | UNKNOWN | 9007198209 | UNKNOWN | ·4738 Canyon Road | Tempe | AZ | — | — | - |
| TPA | TPA-61176 | 2026-02-04T10:25:50Z | Judy | — | Woods | ·1985-03-26 | null | - | 3097278604 | N/A | 5281 Canyon Road | Houston | Texas | 77098 | GRP-8876·· | — |
| TPA | TPA-63688 | 2026-05-20T04:49:18Z | Christian | ·· | Coleman | Jun 7, 2001 | - | — | N/A | — | 1394 Palm Drive | SAN DIEGO | CA | 92175 | - | null |
| TPA | TPA-62125 | 2026-06-17T23:44:50Z | RALPH | — | HOFFMAN | 16-07-1973 | N/A | UNKNOWN | ·· | UNKNOWN | 1707 PINE DRIVE | Seattle | WA | 98142 | — | N/A |
| TPA | TPA-50780 | 2026-05-30T14:44:02Z | Rice, Amy | — | — | 1991-06-04 | NULL | - | 7905690744 | - | ·null | — | null | N/A | GRP-8122 | choice-plus-ppo |
| TPA | TPA-56792 | 2026-01-06T23:49:28Z | JACOOB | — | GREEENE | 19841002 | ·NULL | — | +1 314 965 7945 | NULL | 9893 MEADOW LN Apt 22 | Jacksonville | FL | 32211 | UNKNOWN | N/A·· |
| TPA | TPA-53081 | 2026-09-24T13:55:28Z | JUDITH | — | HAMILTON | 1971-03-26 | — | — | 18609681024 | ·NULL | 3677 WASHINGTON STREET | ·Tempe | AZ | 85281 | GRP-1801 | ·CORE-HMO |
| TPA | TPA-52963 | 2026-09-25T02:26:31Z | gloria | — | nichols | 05/17/1998 | UHC-58730-81 | — | 485-612-9268 | gloria.nichols85@yahoo.com·· | 328 Willow Court | Dallas | TX | 75202 | GRP-6317 | NAVIGATE-HMO |
| TPA | TPA-51745 | 2026-09-08T16:58:13Z | Estrada, Sam | — | — | 1976-06-12 | — | •••-••-5389 | 2128189582 | — | 1665 Palm Drive Apt 10 | DALLAS | TX | 75266·· | GRP-9076 | SELECT-EPO |
| TPA | TPA-62075 | 2026-04-28T05:25:19Z | Kim, Nicholas | — | ···· | 1960-03-04 | N/A | •••-••-7096 | 2470789 | N/A | 3831 Grand Ave | Miami·· | FL | 33119 | GRP-6653 | null |
| TPA | TPA-62307 | 2026-10-18T16:09:43Z | NANCY | — | JOHNSON | Sep 21, 1982 | — | ·· | — | NANCY.JOHNSON@PROTON.ME | 5070 Mountain View Dr | Atlanta | Georgia | 30375 | - | SELECT-EPO |
| TPA | TPA-51095 | 2026-02-07T17:20:06Z | diana | — | bennett | 1964-09-14 | N/A | — | - | UNKNOWN | 7866 Sunset Boulevard | Minneapolis | MN·· | 55487 | — | — |
| TPA | TPA-51663 | 2026-08-05T22:55:26Z | Susan | — | Kim | 1987-02-04 | UNKNOWN | — | ·(938) 572-3040 | — | 9058 Camelback Rd | Minneapolis | MN | 55456 | ···· | CORE-HMO |
| TPA | TPA-61886 | 2026-05-06T23:15:25Z | ALEXIS | — | HENRY | 09/27/61 | — | — | - | UNKNOWN | ·9695 Harbor Boulevard | ·Tucson | AZ | 85779 | GRP-1845 | N/A |
| TPA | TPA-63284 | 2026-10-10T18:49:20Z | Amy | V | Butler | 1959-06-20 | null | •••-••-2753 | 419.663.3809 | - | 1003 HARBOR BLVD·· | Tucson·· | AZ | 85753 | GRP-4508 | — |
| TPA | TPA-52680 | 2026-02-10T21:58:06Z | DOUGLAS | — | SANDOVAL | 2006-06-15 | — | N/A | 308-949-8236 | UNKNOWN | 6971 OCEAN AVENUE | LAS VEGAS | NV | 89122 | NULL | UNKNOWN·· |
| TPA | TPA-60563 | 2026-06-29T04:22:49Z | Denise | — | Jackson | 1949-03-07 | — | — | — | N/A | 3077 Valley View Dr | Tampa | Florida | 33626 | — | NAVIGATE-HMO |
| TPA | TPA-63832 | 2026-06-20T04:08:52Z | Jordan, Jack | ·· | ·· | 1967-12-26 | ···· | •••-••-7882 | (812) 362-0354 | NULL | 7965 Washington Street | Houston | TX·· | 77007 | — | NAVIGATE-HMO |
| TPA | TPA-50820 | 2026-10-05T19:09:01Z | RUTH | — | LARSON | 1977-09-13 | — | — | N/A | — | 2578 Willow Ct | Tampa | FL | 33684-6403 | — | - |
| TPA | TPA-58998 | 2026-04-28T14:12:38Z | mara | — | romero | 1964-03-15 | - | NULL | NULL | null | 4347 Willow Court | ·Dallas | TX | 75275 | — | — |
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:46.087Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty