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-53932 | 2026-01-28T23:30:14Z | JASON | — | KING | 04/09/96 | UNKNOWN | N/A | 18849268391 | JASON.KING@ICLOUD.COM | 5932 Central Ave | Sacramento | ·CA | 95865 | NULL | NAVIGATE-HMO |
| TPA | TPA-60299 | 2026-09-06T03:10:36Z | ELIJAH | — | ·HENDERSON | 02/17/80 | NULL | N/A·· | +1 220 578 4083 | ELIJAH.HENDERSON@GMAIL.COM | 8438 CAMELBACK ROAD | Scottsdale | AZ | 85236·· | UNKNOWN | null·· |
| TPA | TPA-54164 | 2026-09-10T14:12:04Z | Zachary | — | Perry | ·0501-02-08 | — | — | 16392581928 | - | 1235 Main St | CHARLOTTE | NC | 28237-1267 | — | OPTIONS-PPO |
| TPA | TPA-60259 | 2026-08-18T05:02:36Z | Evelyn | — | Palmer | 03-01-1956 | NULL | null | (533) 527-3349 | NULL | NULL | -·· | - | — | UNKNOWN | SELECT-EPO |
| TPA | TPA-62854 | 2026-02-05T15:04:47Z | MARIANA | — | ·WILLIAMSON | 1967-04-01 | — | — | +1 485 885 7683 | — | 4594 MAIN STREET | Denver | co | ·80267 | NULL | N/A |
| TPA | TPA-51022 | 2026-03-02T00:38:22Z | LUIS | — | HILL | 19840820 | — | — | — | -·· | 8111 Indian School Rd·· | Seattle | WA | 98158 | N/A | - |
| TPA | TPA-51243 | 2026-04-13T02:40:28Z | Jerrry | — | Murray | 1986-02-06·· | UHC-55351-47 | •••-••-0957 | UNKNOWN | null | 7532 Cedar Lane | Nashville | TN | 37277 | GRP-1291 | — |
| TPA | TPA-57644 | 2026-09-18T22:59:55Z | RYAN | — | WASHINGTON | 1958-01-19·· | — | null | NULL | - | — | - | ···· | — | N/A | ·- |
| TPA | TPA-61265 | 2026-07-16T05:30:28Z | ·Kimberly | — | Hawkins | 07-02-1992 | - | -·· | null | — | - | NULL | — | — | UNKNOWN | — |
| TPA | TPA-54423 | 2026-03-27T00:12:18Z | gary | ···· | rodriguez | 1952-11-10 | NULL | null | null | — | 1707 Mesa Dr | Chandler | AZ | 85288 | - | — |
| TPA | TPA-56710 | 2026-01-08T10:29:54Z | KEITH | ···· | SCOTT | ·19990709 | — | — | ···· | null | 2392 RIVER ROAD·· | Fresno | CA | 93727 | — | — |
| TPA | TPA-57837 | 2026-03-20T11:57:21Z | ·Gerald | — | Sandoval | 1994-01-28 | — | •••-••-7978 | 460.568.8417 | null | 1877 Mesa Drive | Mesa | AZ | 85212 | GRP-2002 | — |
| TPA | TPA-50794 | 2026-03-04T04:38:30Z | TARESA | C | CHAVEZ | 1953-05-09 | UHC-36535-42 | NULL | (436) 212-4413 | — | 1648 VALLEY VIEW DRIVE | EDEN PRAIRIE | MN | 55343-6390 | GRP-0551 | null |
| TPA | TPA-53131 | 2026-08-07T13:14:35Z | Henry | — | Jackson | 1975-09-28 | UNKNOWN·· | N/A | — | henry.jackson@icloud.com | 6258 FOREST AVENUE #512 | Columbus | OH | 43254 | — | NAVIGATE-HMO |
| TPA | TPA-53217 | 2026-02-15T13:51:55Z | Fowler, Jason | — | — | 26-08-1940·· | NULL | UNKNOWN·· | — | jason.fowler@gmail.com·· | N/A | N/A | N/A | — | — | null |
| TPA | TPA-53049 | 2026-07-03T23:27:38Z | Jean | ·P. | Hudson | 1964-09-02 | N/A·· | — | — | — | 2624 Elm St | ·EDEN PRAIRIE | MN | 55365 | — | - |
| TPA | TPA-50859 | 2026-04-28T22:42:04Z | Maria | ···· | James | 11/10/01 | UNKNOWN | — | - | — | 9109 Broadway·· | ·ORLANDO | FL | 32841 | GRP-4264 | CHOICE-PLUS-PPO |
| TPA | TPA-59036 | 2026-08-06T01:28:42Z | Roy | X. | Young | 1964-04-11 | NULL | — | 6443274383 | ·null | 3149 Mountain View Dr | Jacksonville | FL | 32273 | - | MEDICARE-ADV-B |
| TPA | TPA-58123 | 2026-07-07T05:46:44Z | Gary | — | Perez | 18-08-1980·· | - | •••-••-7004 | (445) 689-5197 | — | NULL | UNKNOWN | null | — | GRP-0914 | ·null |
| TPA | TPA-61509 | 2026-05-17T16:52:58Z | EVALYN | — | RUIZ | 1969-09-25 | — | •••-••-6285 | null | N/A | null | -·· | — | — | null | — |
| TPA | TPA-55233 | 2026-04-15T21:36:23Z | VALENTINA | — | CARR | Oct 14, 1981 | null | — | (229) 340-9192 | — | 1326 Elm St | Chandler | AZ | 85298 | — | MEDICARE-ADV-A |
| TPA | TPA-53586 | 2026-03-10T00:09:45Z | Timothy | — | Ortega | 1995-11-14·· | — | N/A | (546) 580-6924 | NULL | — | — | N/A | - | GRP-3758 | UNKNOWN |
| TPA | TPA-61051 | 2026-06-26T19:18:25Z | AMY | — | SIMPSON | 1969-02-17 | — | N/A | NULL | — | 8176 Bayshore Drive | LAS VEGAS | NV | 89144·· | GRP-7649 | — |
| TPA | TPA-52245 | 2026-02-09T06:19:58Z | Carol | — | Fisher·· | 1991-11-18 | — | •••-••-6530 | (831) 406-7611 | null | 5545 Park Pl | Scottsdale | AZ | 85285 | - | — |
| TPA | TPA-59827 | 2026-07-22T06:14:25Z | Diane | — | Evans | 19600813 | UNKNOWN | •••-••-5868 | (397) 891-8720 | - | 3144 Church St | Austin | TX | 78731 | N/A·· | null |
| TPA | TPA-52430 | 2026-04-08T10:18:14Z | Crawford, Priya | — | — | 8/21/1980 | null | — | +1 655 751 2172 | ···· | 2381 Indian School Road | TUCSON | AZ | 85735 | N/A | UNKNOWN |
| TPA | TPA-63139 | 2026-03-29T12:46:38Z | Lauren | ···· | Franklin | 1954-12-22 | ·NULL | •••-••-0774 | 765-347-3374 | NULL | 506 Elm Street | San Antonio | Texas | 78212 | GRP-4369 | — |
| TPA | TPA-50410 | 2026-05-01T18:42:54Z | ·Emily | — | Hudson | 09/10/63 | - | - | ·N/A | - | 7372 Grand Avenue | Fresno | CA | ···· | UNKNOWN | — |
| TPA | TPA-60246 | 2026-10-01T01:39:31Z | Luis | ···· | Nunez | 1978-02-27 | UNKNOWN | — | — | luis.nunez2@outlook.com | ·967 BAYSHORE DRIVE | TAMPA | FL | 33601 | ·NULL | ···· |
| TPA | TPA-54379 | 2026-09-29T10:11:41Z | Ann | — | ·Thompson | 1985-01-23 | — | N/A | 9413372476 | — | 2064 Pine Drive | Tempe | AZ | 85218·· | UNKNOWN | — |
| TPA | TPA-56660 | 2026-01-27T21:39:24Z | kyle | — | payne | 1959-08-12 | NULL | UNKNOWN | - | ·UNKNOWN | 6422 Forest Ave | Gilbert | AZ | 85239 | — | ·- |
| TPA | TPA-54959 | 2026-05-28T13:22:43Z | Patricia | — | Kennedy | 19910917 | null | NULL | 447.308.3352·· | NULL | 6142 HARBOR BLVD·· | LOS ANGELES | CA | 90015-3232 | GRP-4048 | CHOICE-PLUS-PPO |
| TPA | TPA-55769 | 2026-07-30T08:21:55Z | Sean | — | Hunter | 1963-07-21 | null | •••-••-5237 | NULL | sean.hunter@hotmail.com | 6189 Maple Avenue | Phoenix | AZ | 85038 | GRP-9843·· | N/A |
| TPA | TPA-62505 | 2026-02-15T03:42:43Z | dennis | — | dean | 1974-02-06 | N/A | — | - | NULL | 863 Forest Avenue | Gilbert | ·AZ | 85273 | N/A | — |
| TPA | TPA-53820 | 2026-06-18T15:33:43Z | JUDITH I | ···· | BLACK | 05/25/1993 | - | •••-••-0199 | N/A | — | 198 RIDGE RD | Seattle | WA | 98182 | GRP-2959 | - |
| TPA | TPA-64026 | 2026-08-25T07:05:44Z | Mark | — | Henry·· | 1980-11-23 | NULL | NULL | UNKNOWN | null | 1685 Market Street | Orlando | fl | 32816 | UNKNOWN | N/A |
| TPA | TPA-54213 | 2026-02-14T05:48:25Z | Diego | — | Greene | 06/01/00 | UHC-14523-34 | •••-••-4932 | null | - | 6260 CAMELBACK ROAD | Glendale | AZ | 85370 | — | OPTIONS-PPO |
| TPA | TPA-60160 | 2026-03-20T02:36:34Z | Cole | — | Amanad | 2005-10-28 | UHC-20244-98 | - | 2293378957 | — | UNKNOWN | NULL | - | - | ·· | ···· |
| TPA | TPA-61754 | 2026-04-17T22:37:58Z | Hannah | — | Daniels·· | 1985-05-22 | null | -·· | - | hannah.daniels@gmail.com | 73 Bayshore Dr | Phoenix | Arizona | 85061 | null | NULL |
| TPA | TPA-57940 | 2026-04-01T14:03:06Z | Jacck | ···· | Dunn | 1975-08-10 | NULL | — | — | N/A | 4632 Mesa Dr | Los Angeles | CA | 90029 | — | UNKNOWN |
| TPA | TPA-55906 | 2026-04-23T10:43:11Z | Abby | O | Walker·· | 21-08-1944 | - | null | NULL | — | 9062 Ridge Rd | Sacramento·· | CA | 95815-6890 | - | — |
| TPA | TPA-59325 | 2026-05-26T23:53:43Z | brenda | — | simmons | 23-05-1992 | NULL | ·· | — | - | 6890 SPRING STREET | Sacramento | CA | 95882 | N/A | — |
| TPA | TPA-56420 | 2026-01-10T04:28:18Z | Gloria | X. | Bailey | 1959-02-20 | — | •••-••-8064 | — | NULL | 8919 Indian School Road | Los Angeles·· | CA | 90030 | GRP-4656 | CHOICE-PLUS-PPO·· |
| TPA | TPA-58575 | 2026-09-20T08:49:13Z | VICTORIA·· | — | KING | 1947-04-28 | NULL | UNKNOWN | - | victoria.king42@proton.me | 8023 Hillcrest Rd | Fresno | CA | 93753 | UNKNOWN | — |
| TPA | TPA-51941 | 2026-04-27T17:32:06Z | OBrien | — | Joyce | 7/24/1985 | UNKNOWN | — | 203.250.6673 | NULL | 1865 DESERT SKY BLVD Apt 15 | Los Angeles·· | CA·· | 90017 | — | UNKNOWN |
| TPA | TPA-59183 | 2026-06-24T06:29:34Z | ·SARAH | — | MORRIS | 1994-05-08 | null | •••-••-7699 | 449-650-0273 | — | 4576 HARBOR BOULEVARD | Mesa | AZ | 85264 | GRP-6823 | — |
| TPA | TPA-62695 | 2026-08-13T10:51:18Z | Thomas | O | Larson | 19380709 | ·· | null | UNKNOWN | ·THOMAS.LARSON98@PROTON.ME | — | null | null | — | GRP-1622 | — |
| TPA | TPA-57840 | 2026-03-19T05:57:50Z | Jackson, Shirley | — | — | 19690604 | N/A | •••-••-7884 | - | SHIRLEY.JACKSON@PROTON.ME | 9537 Spring Street·· | Plano | TX | 75009 | GRP-6307·· | UNKNOWN |
| TPA | TPA-50587 | 2026-07-23T04:40:50Z | Catherine | — | Ellis | 1939-12-19 | — | N/A | 751.376.8712 | — | NULL | NULL | ·- | N/A | — | - |
| TPA | TPA-63384 | 2026-08-16T08:24:28Z | KAYLA | X. | HOLMES | 1952-10-16 | null | •••-••-0790 | — | null | 7289 Canyon Road | San Diego | CA | 92136 | — | ·- |
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.345Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty