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-57369 | 2026-01-07T15:59:47Z | JSOEPH | G | STEPHENS | Jun 10, 1976 | N/A | — | N/A | joseph.stephens@aol.com | null | — | UNKNOWN | - | — | UNKNOWN |
| TPA | TPA-50426 | 2026-01-06T12:50:47Z | Lisa | K | Campbell | 1982-04-21 | NULL | •••-••-8037 | NULL | lisa.campbell21@proton.me | 4118 HIGHLAND AVENUE | Nashville | TN | 37289 | — | N/A |
| TPA | TPA-57921 | 2026-09-26T23:56:48Z | John | — | Hicks | 1965-03-05 | UNKNOWN | — | — | — | 5013 Sage Ct | Miami | Florida·· | 33176 | GRP-9531 | N/A |
| TPA | TPA-60975 | 2026-08-18T14:41:38Z | ALAN | — | OBRIEN | 3/2/1961 | UNKNOWN | •••-••-3828 | 15413450956 | null | 2792 Bayshore Dr | Atlanta | ga·· | 30391 | UNKNOWN | null |
| TPA | TPA-58438 | 2026-01-05T13:35:32Z | REBECCA | — | WILLIAMS | 1980-04-20 | — | •••-••-6306 | N/A | — | ·1967 Union St | Charlotte | North Carolina | 28278-9923 | — | - |
| TPA | TPA-50977 | 2026-03-19T20:55:50Z | Mchael | — | Stone | 1974-01-26 | null | •••-••-3386 | UNKNOWN | michael.stone@proton.me | 7918 MEADOW LANE | Miami | FL | 33129·· | GRP-8147 | - |
| TPA | TPA-50916 | 2026-02-05T18:40:54Z | Luis | — | Sullivan | 1943-02-09 | — | - | — | ·· | 2265 Maple Avenue Apt 19 | Los Angeles | CA | 90010 | N/A | - |
| TPA | TPA-53439 | 2026-02-23T15:48:26Z | Armstrong, Emily | — | — | 1959-12-08 | null | •••-••-3504 | — | NULL | 4902 Palm Drive·· | Chandler | AZ | 85289·· | — | N/A |
| TPA | TPA-64326 | 2026-01-12T12:12:23Z | racehl | Q | carter | 1953-11-18 | UHC-82771-64 | •••-••-4333 | (928) 826-4879 | rachel.carter@yahoo.com | 6729 Grand Avenue | San Diego | CA | 92164 | GRP-4674·· | null |
| TPA | TPA-51392 | 2026-03-19T03:43:02Z | Nicole·· | — | Hudson | 1993-09-12 | - | - | 570-550-5372 | nicole.hudson32@outlook.com·· | null | N/A | — | N/A | — | CHOICE-PLUS-PPO |
| TPA | TPA-53617 | 2026-10-11T08:00:03Z | Judith | — | Little | 1976-12-20 | N/A·· | - | 425-367-1536 | — | 3029 Elm St | Mesa | ·Arizona | 85203·· | - | CORE-HMO |
| TPA | TPA-63497 | 2026-02-15T22:52:51Z | ·Logan | — | Greene | 1941-01-16 | NULL·· | UNKNOWN | — | logan.greene@icloud.com | 8341 Market St | Glendale | AZ | 85355 | GRP-2007 | NAVIGATE-HMO |
| TPA | TPA-53299 | 2026-08-24T04:56:06Z | Emily | U. | Aguilar | 1985-08-05 | null | — | null | null | 1301 WILLOW CT | SCOTTSDALE | az | 85292 | GRP-7309 | — |
| TPA | TPA-63892 | 2026-05-15T14:25:37Z | Jessse | U | Bennett | 1940-12-16 | — | UNKNOWN | — | UNKNOWN | - | N/A | null | — | — | - |
| TPA | TPA-58162 | 2026-09-02T06:33:32Z | Keitth·· | — | Simpson | 2007-11-19 | UHC-20710-22 | — | — | ·KEITH.SIMPSON62@GMAIL.COM | 6732 Church St | Fresno·· | CA | 93776 | null | ·null |
| TPA | TPA-62427 | 2026-02-10T23:35:47Z | Rujas, Sophia | — | — | ·1999-11-18 | — | — | null | null | 4947 Mesa Drive | NASHVILLE | TN | 37299 | N/A | - |
| TPA | TPA-60874 | 2026-04-28T12:43:46Z | Carlos·· | — | Kelley | 4/4/1953 | - | — | 9643278543 | - | 3081 Pine Dr | HOUSTON | TX·· | 77077·· | — | — |
| TPA | TPA-54564 | 2026-03-05T04:33:20Z | EMMA | — | HAWKINS | 1947-08-08 | UHC-98014-78 | — | — | — | 1302 Ocean Avenue·· | Nashville | TN·· | ·37263 | null | — |
| TPA | TPA-64157 | 2026-02-20T00:53:50Z | Emily | — | ·Shaw | 1992-02-13 | null | UNKNOWN | UNKNOWN | — | 1137 Washington Street | Gilbert | AZ | 85258 | — | MEDICARE-ADV-A |
| TPA | TPA-52093 | 2026-03-24T10:19:48Z | Schmidt, Bradley | — | — | 19540416 | — | — | — | — | 7492 Camelback Rd | Eden Prairie | mn | 55395 | NULL | — |
| TPA | TPA-50526 | 2026-03-30T20:49:55Z | Jhon | — | Powell | 1942-04-22 | UHC-16950-26 | •••-••-5701 | N/A | NULL | 2053 CANYON ROAD | Los Angeles | CA | 90049 | GRP-6784 | MEDICARE-ADV-B |
| TPA | TPA-53956 | 2026-06-07T00:27:54Z | Dunn, Hiroshi | — | ···· | 1962-03-27 | — | - | — | - | NULL | — | — | - | ·null | — |
| TPA | TPA-57199 | 2026-05-03T02:32:17Z | heather | — | hill | 1993-10-17 | N/A | NULL | (340) 903-3399·· | - | ·· | - | — | — | GRP-5621 | UNKNOWN |
| TPA | TPA-60468 | 2026-04-26T05:05:56Z | Keith | — | Bradley | 11/17/1990 | null | •••-••-7990 | — | keith.bradley47@icloud.com | 8921 Cedar Ln | Jacksonville | FL | 32227 | GRP-8201 | — |
| TPA | TPA-56785 | 2026-06-08T07:28:40Z | brian | — | cunningham | 2003-12-01 | N/A | - | NULL | N/A | 3596 Desert Sky Blvd | Miami | FL | 33115 | NULL·· | UNKNOWN |
| TPA | TPA-53356 | 2026-01-18T15:49:24Z | JUAN | R | CESTRO | Aug 25, 2000 | - | ·· | NULL | JUAN.CASTRO16@HOTMAIL.COM | 7584 Mountain View Drive | Charlotte | NC | 28219 | GRP-8768 | OPTIONS-PPO |
| TPA | TPA-54009 | 2026-04-21T12:18:47Z | HANNAH | ·· | OLIVER | 7/8/1951 | — | — | (255) 802-0399 | HANNAH.OLIVER@PROTON.ME | 926 Oak Street | Scottsdale | Arizona | 85270 | ···· | - |
| TPA | TPA-63062 | 2026-03-24T17:25:04Z | Jeffrey | — | Phillips·· | 1977-60-27 | — | — | 2955335291 | jeffrey.phillips91@outlook.com | - | — | NULL | — | GRP-1106 | - |
| TPA | TPA-61787 | 2026-01-10T08:34:14Z | Tyler | — | Wag·· | 12/14/1941 | NULL | — | (275) 519-6299 | — | 1579 LINCOLN WAY | Dallas | Texas | 75217 | N/A | — |
| TPA | TPA-50884 | 2026-10-04T13:56:00Z | ·Lawrence, Carlos | — | — | Sep 19, 1957 | NULL | •••-••-3512 | — | UNKNOWN | 6107 Mountain View Dr | Phoenix | AZ·· | 85015 | — | null |
| TPA | TPA-50867 | 2026-01-07T10:01:59Z | KELLY | — | FORD | 06-02-1981 | — | •••-••-5014 | N/A | — | 8521 Desert Sky Boulevard | Phoenix | AZ | 85066 | NULL | NAVIGATE-HMO |
| TPA | TPA-54242 | 2026-08-21T06:29:10Z | Albert | — | Ellis | Feb 15, 2004 | — | N/A | — | N/A | 2575 Desert Sky Blvd | ·Seattle | ·WA | 98186·· | null | CHOICE-PLUS-PPO |
| TPA | TPA-58294 | 2026-04-27T04:11:55Z | ETHAN | ···· | WEAVER | 06/05/1967 | NULL | — | NULL | — | 8731 Washington Street | Mesa | AZ | 85268-7172 | GRP-6773 | NULL |
| TPA | TPA-54355 | 2026-07-20T02:38:30Z | Virginia | F. | Hayes | 19800212 | NULL | — | 648-805-6139 | VIRGINIA.HAYES@PROTON.ME | 966 Elm Street | Mesa | AZ | 85297 | GRP-8823·· | ·NAVIGATE-HMO |
| TPA | TPA-56306 | 2026-07-29T05:57:12Z | PAUL | — | NGUYEN | 1997-03-08·· | NULL | N/A | null | - | 5411 Bayshore Dr | Mesa | AZ | 85203 | N/A | OPTIONS-PPO·· |
| TPA | TPA-61284 | 2026-02-21T15:26:08Z | Edwards, Douglas | — | — | 1962-05-28 | — | null | UNKNOWN | douglas.edwards60@proton.me | 3224 Desert Sky Blvd #150·· | SACRAMENTO | ca | 95830 | GRP-6568 | NAVIGATE-HMO |
| TPA | TPA-54691 | 2026-08-01T16:09:29Z | Ashley | — | Ford | ·12/13/2001 | null | •••-••-3529 | 538-312-5194 | N/A | 7109 Forest Avenue | Sacramento | CA | 95846 | null | NULL |
| TPA | TPA-61342 | 2026-10-06T18:33:10Z | Rebecca | — | Foster | 1990-11-23 | NULL | ·null | null | — | N/A | — | N/A | null | - | CHOICE-PLUS-PPO |
| TPA | TPA-62296 | 2026-02-15T18:25:01Z | Nicholas | — | West | Jan 12, 1984 | NULL | — | 239-501-8715 | NICHOLAS.WEST@PROTON.ME | 5521 Grand Avenue | Fresno | CA | 93776 | GRP-9386 | CORE-HMO |
| TPA | TPA-53211 | 2026-02-11T09:19:27Z | SARA | — | MITCHELL | 2007-05-01 | UNKNOWN | •••-••-0167 | null | NULL | 9648 OAK ST | Tampa | FL | 33636 | - | - |
| TPA | TPA-57628 | 2026-08-27T18:54:57Z | Andy | — | Jimenez | 02/28/66 | ·null | ·· | 579-879-0779 | N/A | 3408 Spring Street | ·Dallas | TX | 75209 | — | NULL |
| TPA | TPA-62769 | 2026-08-21T09:17:27Z | MATTHEW | — | KELLY | 2/20/1981 | — | NULL | 333-395-0305 | ···· | 5109 Hillcrest Road·· | SACRAMENTO | CA | 95884 | GRP-9095 | - |
| TPA | TPA-64433 | 2026-01-28T08:54:22Z | William | — | Thomas | 1966-01-16 | — | •••-••-7937 | — | null | 6199 Cedar Ln | SEATTLE | WA | 98173 | N/A | — |
| TPA | TPA-55273 | 2026-02-03T21:53:07Z | Diane | D | Gibson·· | 05/12/1946 | N/A | •••-••-8337 | null | UNKNOWN | 8335 Mesa Drive·· | Eden Prairie | MN | 55387 | — | SELECT-EPO |
| TPA | TPA-55535 | 2026-03-14T22:24:40Z | ·MATEO | — | BROWN | 1938-02-04 | UNKNOWN | N/A | — | mateo.brown60@icloud.com | 5088 SUNSET BLVD | Jacksonville | Florida·· | 32296 | GRP-4570 | NULL |
| TPA | TPA-63131 | 2026-02-20T05:09:40Z | Noah | — | Hudson | Oct 6, 1970 | N/A | — | — | null | 8252 Washington St | Sacramento | CA | 95820 | N/A | — |
| TPA | TPA-63050 | 2026-09-04T08:11:48Z | GEORGE | — | PARK | 2001-08-22 | UHC-72658-41 | — | — | — | 2626 WASHINGTON ST | Plano·· | TX | 75080 | — | N/A |
| TPA | TPA-60500 | 2026-05-28T07:20:49Z | Lauren | L | Johnston | 1983-11-27 | NULL | — | NULL | - | 5404 JEFFERSON AVE | Tempe | ·AZ | 85225-3051 | — | — |
| TPA | TPA-57367 | 2026-10-17T18:22:24Z | SANDRA | — | VEGA | 1949-12-23 | UNKNOWN | •••-••-4745 | - | - | 2681 Lake View Road | Glendale | AZ | 85370 | GRP-1800 | CORE-HMO |
| TPA | TPA-63684 | 2026-05-02T03:02:54Z | SIMMONS | — | JONATHAN | May 11, 1988 | — | null | 791-515-0208 | - | 4316 Mesa Dr | ·Nashville | TN | 37252·· | N/A | 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:38.492Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty