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-53855 | 2026-07-22T22:58:04Z | Bryan | S. | Smith | 2003-10-02 | — | •••-••-1076 | NULL | BRYAN.SMITH@GMAIL.COM | 8664 Ridge Rd | Nashville | TN | ·· | — | null |
| TPA | TPA-54179 | 2026-01-22T10:17:21Z | RALPH | D. | CHAVEZ | 07-12-1988 | - | null | 5916623 | — | 8378 Ridge Rd | Denver | CO | 80258-5056 | - | - |
| TPA | TPA-57052 | 2026-02-10T23:19:54Z | Bruce | — | Steves | 02/23/2003 | UHC-19250-74 | UNKNOWN | ·(865) 838-7604 | — | 4915 Broadway | TUCSON | AZ | 85778-9145 | GRP-9537 | null |
| TPA | TPA-53341 | 2026-02-28T11:12:01Z | Ana | — | Mason | 2002-01-10 | N/A·· | •••-••-5375 | 13122246069 | - | UNKNOWN | — | — | NULL | NULL | — |
| TPA | TPA-60924 | 2026-09-08T17:45:31Z | ·Brenda | ···· | Lopez | Nov 1, 1950 | — | N/A | - | — | 7991 Park Pl | Columbus | OH | 43204 | UNKNOWN | — |
| TPA | TPA-51483 | 2026-06-24T21:16:00Z | THERESA | — | PHILLIPS | 1968-10-22 | UHC-72370-07 | •••-••-5527 | — | ·· | 7237 Church Street | San Antonio | TX | 78251 | GRP-5000 | N/A |
| TPA | TPA-51406 | 2026-02-07T17:31:16Z | roy | — | green | 10/15/55 | — | •••-••-1792 | (232) 871-9993 | — | 8357 PALM DRIVE | Houston | TX | 77031 | GRP-9545 | — |
| TPA | TPA-60400 | 2026-04-08T12:15:35Z | Eric | — | Simpson | 10/18/1998 | null | •••-••-9695 | ·9843752110 | - | 8776 CANYON ROAD·· | ·Columbus | ·OH | 43289 | GRP-2713 | OPTIONS-PPO |
| TPA | TPA-54961 | 2026-06-06T16:39:24Z | Frank | — | Franklin | ·20051228 | — | •••-••-1303 | null | FRANK.FRANKLIN15@ICLOUD.COM | - | — | NULL | UNKNOWN | — | UNKNOWN |
| TPA | TPA-50504 | 2026-04-24T23:29:28Z | Shirley | — | Griffin | 1997-10-19 | - | •••-••-3122 | 6389941304 | UNKNOWN | 6768 MAIN ST | Tucson | AZ | 85760 | - | — |
| TPA | TPA-54919 | 2026-10-06T18:22:58Z | Roy | — | Olsson | 19561213 | NULL | -·· | ···· | NULL | 6965 INDIAN SCHOOL RD | HOUSTON | TX | 77029·· | null | — |
| TPA | TPA-52563 | 2026-02-11T18:13:11Z | Duris | ···· | — | 1951-03-03 | UNKNOWN | ·UNKNOWN | NULL | — | 1581 CANYON ROAD | Houston | TX | 77097 | ·GRP-9192 | CHOICE-PLUS-PPO |
| TPA | TPA-61496 | 2026-01-11T03:49:22Z | PATRICIA | ·· | DAVIS | 10/12/1983 | N/A | •••-••-5867 | (756) 828-8565 | — | NULL | N/A | — | UNKNOWN | - | OPTIONS-PPO |
| TPA | TPA-56797 | 2026-05-30T05:35:02Z | kevin | — | austin | 1961-08-28 | N/A | •••-••-6635 | null | kevin.austin40@icloud.com | ·5743 UNION ST | SCOTTSDALE | AZ·· | ·85270 | NULL | ·- |
| TPA | TPA-52057 | 2026-10-03T08:46:07Z | RONALD | — | BROOOKS | 1990-04-28 | NULL | UNKNOWN | - | ronald.brooks@gmail.com | 7486 UNION STREET | Glendale | AZ | 85382-5311 | UNKNOWN | SELECT-EPO |
| TPA | TPA-57652 | 2026-09-29T03:59:59Z | Alan | — | Diaz | 19580313 | — | •••-••-6883 | N/A | — | 2159 Mesa Dr | AUSTIN | TX | 78732 | - | NULL |
| TPA | TPA-64122 | 2026-08-17T16:15:34Z | Nicholas | I | Cunningham | 18-07-1971 | UNKNOWN | •••-••-8679 | ·· | nicholas.cunningham7@outlook.com·· | - | N/A | - | — | UNKNOWN | CORE-HMO·· |
| TPA | TPA-61735 | 2026-06-01T01:50:38Z | RUSSELL·· | — | JENKINS | 1965-02-11 | — | N/A | 314-428-6876 | NULL | ·7939 Park Pl | Tempe | AZ | 85257 | GRP-3292 | null |
| TPA | TPA-51341 | 2026-01-10T03:59:31Z | Arthur·· | H. | Rice | 04/24/01 | UHC-69841-73 | — | 356.905.4601 | NULL | 4593 HIGHLAND AVENUE | NASHVILLE | TN | NULL | UNKNOWN | UNKNOWN |
| TPA | TPA-61810 | 2026-04-30T20:53:28Z | Kim, Camila | E. | — | 1941-12-18 | — | - | — | camila.kim@hotmail.com | 9411 Sunset Boulevard | Columbus | OH | 43266 | - | NAVIGATE-HMO |
| TPA | TPA-57238 | 2026-08-26T02:14:01Z | PATRICIA | — | CONTRERAS | 06/01/2007 | UHC-13408-98 | — | 14378620962 | - | 5791 Central Ave | Chandler | ·AZ | 85264 | NULL | - |
| TPA | TPA-56071 | 2026-09-01T11:13:35Z | Betyt | — | Kelly·· | Jun 7, 1961 | — | NULL | NULL | null | 338 Meadow Lane | San Diego | CA | 92165 | N/A | - |
| TPA | TPA-61238 | 2026-05-13T20:17:11Z | Mariana | — | Patel | 1956-02-11 | — | •••-••-6296 | ···· | N/A | 2743 APACHE BOULEVARD·· | Gilbert | Arizona | 85230 | GRP-2048 | NULL |
| TPA | TPA-59579 | 2026-08-10T01:34:18Z | Camila | — | Lawrence | 10/12/1967 | UNKNOWN·· | - | 523-721-9460 | UNKNOWN | ·N/A | — | — | — | UNKNOWN | — |
| TPA | TPA-57103 | 2026-10-18T09:07:43Z | theresa | — | hawkins | 2007-04-19 | N/A | •••-••-3240 | — | theresa.hawkins97@yahoo.com | NULL | — | UNKNOWN | - | - | — |
| TPA | TPA-53089 | 2026-05-22T10:16:41Z | Fuller, Janet Z | — | — | 1948-11-25 | — | •••-••-5280 | — | - | 1869 Palm Drive | Tempe | Arizona | - | ·GRP-4104 | UNKNOWN |
| TPA | TPA-50482 | 2026-05-19T11:10:33Z | LARRY | ···· | BENNETT | 1975-08-04 | null | — | - | — | 5746 MARKET ST | COLUMBUS | OH | 43278 | null | — |
| TPA | TPA-60546 | 2026-08-25T00:04:06Z | Ramos, Diego | — | — | 20040313 | — | •••-••-3304 | +1 407 600 7554 | diego.ramos@proton.me | 6810 Highland Ave | ·Tucson | az | ·85725 | NULL | SELECT-EPO |
| TPA | TPA-56081 | 2026-09-18T04:14:01Z | janeet | ·Y. | reynolds | 1994-06-27 | — | — | UNKNOWN | JANET.REYNOLDS@OUTLOOK.COM | — | - | UNKNOWN | — | — | SELECT-EPO |
| TPA | TPA-59676 | 2026-05-04T12:08:42Z | Lawrence, Sofia | ···· | — | 20010424 | UHC-25799-28 | null | N/A | UNKNOWN | 3103 APACHE BOULEVARD | Los Angeles | ·CA | 90044 | — | NULL |
| TPA | TPA-63950 | 2026-08-22T05:27:58Z | Miller | — | Dick | Jul 22, 1966 | UNKNOWN·· | - | null | — | ·1979 Hillcrest Road | MIAMI | FL | 33154 | - | null |
| TPA | TPA-60997 | 2026-04-28T02:48:17Z | JOE | — | RAMOS·· | 1969-08-23 | — | - | UNKNOWN | ···· | 6532 Mountain View Dr | San Antonio | TX | — | GRP-4893 | OPTIONS-PPO |
| TPA | TPA-52114 | 2026-08-20T18:17:23Z | Priya | — | ·Burton | ·1971-02-22 | N/A | •••-••-3823 | UNKNOWN | - | 5714 PARK PLACE | Columbus | OH | 43229 | GRP-8057 | null |
| TPA | TPA-50538 | 2026-04-03T00:09:36Z | Dylan | — | Dunn | 1949-10-18 | UHC-33426-39 | — | - | — | 2524 Highland Ave·· | Glendale | Arizona | 85311 | — | NAVIGATE-HMO |
| TPA | TPA-54958 | 2026-04-10T23:49:26Z | Willam | Z | Coleman | 19-12-2004 | — | NULL | N/A | N/A | 2790 Forest Ave | Mesa | Arizona | 85200 | GRP-1667 | ·core-hmo |
| TPA | TPA-55910 | 2026-07-11T04:19:13Z | joan | — | porter | Jan 7, 1989 | NULL | N/A | UNKNOWN | null | 6094 Hillcrest Road | Chandler | AZ | 85220 | GRP-4866 | UNKNOWN |
| TPA | TPA-61896 | 2026-04-12T03:37:08Z | ·Tran, Emily | — | — | 1969-09-23 | — | - | NULL | — | 6266 Bayshore Drive | Denver | CO | 80231 | NULL | ···· |
| TPA | TPA-60904 | 2026-01-26T20:53:00Z | NATHAN·· | — | YANG | 1957-05-21 | N/A | null | - | nathan.yang@aol.com | ···· | — | - | - | — | SELECT-EPO |
| TPA | TPA-64195 | 2026-04-29T17:14:50Z | Diane | — | ·Gordon | 1974-08-21 | NULL | null | 2423452434 | DIANE.GORDON@YAHOO.COM | 9110 Camelback Rd | Dallas | TX | 75211-4062 | GRP-5296 | MEDICARE-ADV-B |
| TPA | TPA-53240 | 2026-08-09T10:29:44Z | Charlotte | — | Sanchez | ·1994-04-17 | UHC-17804-04 | NULL | 745-864-5091 | N/A | 7218 Washington Street·· | Orlando | FL | 32845 | GRP-3408 | OPTIONS-PPO |
| TPA | TPA-57505 | 2026-03-29T05:50:40Z | JEAN | — | ANDREWS | ·07/07/40 | null | •••-••-9961 | UNKNOWN | — | ·4756 Jefferson Avenue | Miami | FL·· | 33151 | N/A | OPTIONS-PPO |
| TPA | TPA-64168 | 2026-04-14T08:14:14Z | DEBORAH·· | ·· | MURRAY | 1968-11-04 | — | - | N/A | — | 1166 Park Place #367 | Las Vegas | NV | 89199 | — | NULL |
| TPA | TPA-54339 | 2026-05-20T13:26:44Z | JOSE | — | CARTER | 19960911 | UNKNOWN | null·· | null | jose.carter@aol.com | 9314 Jefferson Avenue | JACKSONVILLE | FL | 32281 | NULL | ·· |
| TPA | TPA-56706 | 2026-03-30T22:16:19Z | Samuel | ·· | Robinson | 03/26/66 | NULL | •••-••-9026 | N/A | — | 944 HILLCREST RD | Los Angeles | CA·· | 90080 | ·· | MEDICARE-ADV-A |
| TPA | TPA-59002 | 2026-03-29T03:59:21Z | ·Washington, Shirley | B | — | 2008-04-16·· | UHC0530116 | NULL | N/A | — | 5417 VALLEY VIEW DRIVE | San Diego | CA | 92163 | NULL | null·· |
| TPA | TPA-63969 | 2026-08-05T14:26:24Z | Jack | — | ·Gray | 1966-11-25 | null | •••-••-7162 | — | — | 6736 Church Street | SACRAMENTO | CA | 95837 | NULL | MEDICARE-ADV-B |
| TPA | TPA-52197 | 2026-07-19T16:13:16Z | CHRISTOPHER | — | CUNNINGHAM·· | 1946-04-04 | UHC-92637-64 | - | 295-663-0065 | christopher.cunningham@hotmail.com | N/A | — | NULL | — | NULL | UNKNOWN |
| TPA | TPA-53979 | 2026-07-24T05:09:35Z | Wei | — | Nelson | Mar 28, 1975 | - | NULL | — | WEI.NELSON@GMAIL.COM | 5374 Mesa Drive | Tampa | FL | 33629 | UNKNOWN | — |
| TPA | TPA-59911 | 2026-08-14T22:35:39Z | KEITH | — | FOSTER | Jan 10, 1973 | null | — | 8466971232 | -·· | 3575 Oak Street | ·Phoenix | AZ | 85043 | -·· | CHOICE-PLUS-PPO |
| TPA | TPA-55313 | 2026-04-11T01:47:10Z | ·Scott, Mariana | — | — | 1995-02-26 | UHC-73872-66 | •••-••-0522 | 7708316082 | — | 221 River Road | Eden Prairie | MN | 55310 | GRP-4270 | OPTIONS-PPO |
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.157Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty