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-59151 | 2026-05-17T13:59:16Z | Jacqueline | — | Vargas | 1983-07-26 | NULL | -·· | (227) 498-0011 | null | 9060 MESA DR | Houston | TX | 77082-0873 | ·GRP-6619 | null |
| TPA | TPA-63027 | 2026-07-15T21:47:18Z | Richard | ·· | Murphy | 14-04-1940 | - | N/A | - | NULL | ·- | UNKNOWN | - | — | - | null |
| TPA | TPA-52422 | 2026-08-22T06:10:37Z | THOMAS | — | POWELL | 12/19/1965·· | null | •••-••-7727 | UNKNOWN | — | 1837 Palm Dr | Atlanta | GA | 30397-3230 | - | — |
| TPA | TPA-53918 | 2026-01-12T14:59:57Z | Samuel | — | Jimenez | 04/02/53 | UHC-67719-04 | — | — | UNKNOWN | 7505 CEDAR LN·· | Atlanta | GA | 30371 | — | — |
| TPA | TPA-53014 | 2026-03-04T11:18:21Z | Aaron | — | ·Smith | 1947-09-28 | ·- | - | N/A | ·· | 6483 Washington Street | Gilbert | AZ | 85253 | GRP-2389 | — |
| TPA | TPA-55686 | 2026-08-13T18:09:42Z | ·Sullivan, Mariana | — | ···· | 2006-01-04 | — | null | - | mariana.sullivan@icloud.com | 1102 Central Ave | Glendale | AZ | 85365 | NULL | — |
| TPA | TPA-56928 | 2026-04-10T01:25:04Z | KAREN | — | WOODS | 1944-07-03 | NULL | UNKNOWN | null | karen.woods59@gmail.com | 9357 INDIAN SCHOOL ROAD | Plano | TX | 75014 | ···· | — |
| TPA | TPA-58354 | 2026-09-25T00:27:23Z | Amanda | — | King | 1986-07-04 | UNKNOWN | UNKNOWN | - | — | 1813 Maple Avenue | Mesa | AZ | 85208·· | GRP-5659 | ···· |
| TPA | TPA-51562 | 2026-04-04T17:25:03Z | Edwards, Mary | — | — | ·1949-09-06 | — | — | null | null | 7363 Forest Avenue | Miami | FL | 33176 | null | — |
| TPA | TPA-62353 | 2026-10-13T14:28:05Z | Ahmed | — | Washington | 1959-10-04 | ·· | •••-••-8643 | N/A | null | 580 Maple Ave | MINNEAPOLIS·· | MN | 55437 | GRP-0106 | MEDICARE-ADV-B |
| TPA | TPA-60628 | 2026-03-20T16:47:15Z | NOAH | — | WILLIS | 1989-12-23 | — | •••-••-3689 | 6124975569 | null | 526 Sage Ct | SACRAMENTO | CA | 95846 | GRP-2098 | ·NULL |
| TPA | TPA-52318 | 2026-03-14T23:29:15Z | CARRL | — | KEENNEDY | 1947-07-22 | UNKNOWN | — | N/A | UNKNOWN | 7406 Ridge Road | Columbus·· | OH | 43259·· | — | UNKNOWN |
| TPA | TPA-52639 | 2026-09-29T23:56:19Z | Cheryl | — | Fields | 02/09/2002 | — | UNKNOWN | 2727914 | ·cheryl.fields6@yahoo.com | 1426 Washington Street·· | Nashville | tn | ·37287 | -·· | UNKNOWN |
| TPA | TPA-57184 | 2026-01-26T00:58:56Z | LARRY | — | PEREZ | 1982-05-22 | UNKNOWN | - | ·- | — | 6800 MAIN ST | Gilbert | ·AZ | 85233-1602 | — | SELECT-EPO |
| TPA | TPA-51607 | 2026-02-08T15:05:09Z | Arhtur | — | Little | 1954-06-05·· | NULL | •••-••-8436 | — | arthur.little@icloud.com | NULL | N/A | N/A | — | null | null |
| TPA | TPA-51478 | 2026-07-14T11:10:52Z | WAYNE | — | LUNA | 05/16/1942 | - | null | (734) 866-2457 | wayne.luna@aol.com | 9591 JEFFERSON AVENUE | Denver | CO | ·80232 | GRP-3132 | NULL |
| TPA | TPA-54382 | 2026-07-31T03:53:44Z | TYLER | — | CARTER | 1997-10-16 | N/A | — | — | N/A | 7468 Lake View Rd | LOS ANGELES | CA | 90055 | NULL | null |
| TPA | TPA-59221 | 2026-08-11T17:12:05Z | Arthur | — | Kelley | 1973-10-12 | UNKNOWN | UNKNOWN | — | UNKNOWN·· | 5723 Washington Street | ·Jacksonville | ·Florida | 32202 | GRP-2789·· | CHOICE-PLUS-PPO |
| TPA | TPA-57514 | 2026-07-13T02:18:42Z | Jonathan | — | Ford | 02/08/55 | ·N/A | — | — | null | 1229 Broadway | ·Nashville | TN | 37279 | — | N/A |
| TPA | TPA-54821 | 2026-09-02T01:37:18Z | McCoy, Helen | — | — | 20040417·· | ···· | •••-••-6349 | null | — | 5375 OAK STREET | Mesa | AZ | 85215 | GRP-0689 | — |
| TPA | TPA-59837 | 2026-07-02T03:04:54Z | Stephanie | — | Williamson | ·9/28/1961 | UNKNOWN | — | null | N/A | 9825 Mesa Dr | LAS VEGAS | NV | 89103-0016 | — | null |
| TPA | TPA-50031 | 2026-08-30T03:26:17Z | George | — | Ellis | 1977-04-27 | UHC-39266-32 | null | - | — | 8317 ELM ST | Miami | FL | 33181 | GRP-1660 | navigate-hmo |
| TPA | TPA-58235 | 2026-05-08T11:45:54Z | Luis | — | Nichols | 03/13/1972 | UHC-68522-27·· | — | 251.827.7999 | — | 3220 Apache Blvd | Nashville | ·Tennessee | 37281·· | GRP-3792 | UNKNOWN |
| TPA | TPA-56867 | 2026-10-05T08:47:54Z | Barbara | — | Brown | 1968-11-14 | — | •••-••-8243 | (730) 908-6890 | ·UNKNOWN | 1741 MARKET STREET | Jacksonville | FL | 32230·· | ···· | OPTIONS-PPO |
| TPA | TPA-55797 | 2026-10-09T03:05:32Z | Lisa | — | Clark | 1977-03-13 | ·N/A | — | 976-876-8845·· | NULL | ·5429 Sunset Boulevard | ATLANTA | GA | 30336-8319 | GRP-9075 | — |
| TPA | TPA-59624 | 2026-02-05T15:07:28Z | haether | — | morrison | 1969-10-25 | N/A·· | - | null | — | — | — | null | NULL | N/A | — |
| TPA | TPA-57834 | 2026-09-18T11:26:37Z | ·JACOB | M | FERGUSON | 01/07/1950 | null·· | — | UNKNOWN | -·· | 846 LAKE VIEW RD | Mesa | az | 85238 | GRP-6088 | choice-plus-ppo |
| TPA | TPA-52910 | 2026-10-04T11:15:37Z | Henderson, Denise | T. | ···· | 1969-40-06 | — | •••-••-1067 | NULL | - | — | — | NULL | — | — | N/A |
| TPA | TPA-50968 | 2026-06-05T17:28:14Z | Olivia | — | Hart | 1976-10-26 | UHC-78547-45 | ·· | 18638372853 | ·- | 9622 HIGHLAND AVE | HOUSTON | TX | — | — | NULL |
| TPA | TPA-61351 | 2026-02-18T22:58:17Z | Richard | — | Montgomery | 02/03/1971 | - | — | ·- | RICHARD.MONTGOMERY41@YAHOO.COM | 1231 MARKET STREET | Nashville | TN | 37293 | NULL | CHOICE-PLUS-PPO |
| TPA | TPA-62857 | 2026-08-02T09:49:20Z | Benjamin | — | Thompson | 07/25/1990 | — | •••-••-9218 | — | benjamin.thompson31@aol.com | 6807 Canyon Road | Denver | CO | 80218 | — | — |
| TPA | TPA-55406 | 2026-07-01T09:41:48Z | Alice | — | Gomez | 11/04/1943 | — | •••-••-0938 | — | alice.gomez6@gmail.com | 6767 Baseline Rd | Tempe | az | ·85258 | ·· | OPTIONS-PPO |
| TPA | TPA-56188 | 2026-05-29T18:25:05Z | Elijah | — | Taylor | 1985-04-15 | null | ·· | NULL | ELIJAH.TAYLOR@PROTON.ME | 5130 Highland Avenue #213 | Dallas | TX | 75270 | UNKNOWN | NAVIGATE-HMO |
| TPA | TPA-61018 | 2026-08-23T00:23:41Z | Meyer, Carol | — | — | ·Jul 21, 1979 | - | •••-••-7702 | 2429489581 | NULL | 3897 CAMELBACK RD Apt 35 | Nashville | tn | 37265 | N/A | MEDICARE-ADV-B |
| TPA | TPA-58093 | 2026-07-20T18:39:36Z | lawrence | ·· | george | 1996-12-12 | null | null | null | - | 6604 INDIAN SCHOOL RD | Fresno | CA | 93721 | GRP-2412 | UNKNOWN |
| TPA | TPA-53166 | 2026-06-01T03:45:42Z | Hunt, Priya | U | — | 1992-04-15 | ·- | N/A | ·- | priya.hunt@proton.me | 9005 Ocean Avenue | Denver | CO | 80251-3896·· | GRP-0440 | NULL |
| TPA | TPA-54136 | 2026-10-01T04:35:47Z | NIOCLE | — | SOTO | 06-07-1976 | UHC-29038-30 | — | 306-532-4847 | nicole.soto@outlook.com | 8682 ELM STREET | Fresno | CA | — | ·UNKNOWN | ·· |
| TPA | TPA-50973 | 2026-03-24T12:46:03Z | Lawrence | — | Johnston | 1952-10-18 | null | •••-••-2701 | ·(523) 804-1388 | N/A | 5968 Park Pl | Chandler | AZ | 85223 | GRP-0133 | MEDICARE-ADV-B |
| TPA | TPA-63403 | 2026-03-25T02:29:57Z | Mariana | — | Garrett | 2003-11-15 | ·null | null | 8297356353 | NULL | 6949 SUNSET BOULEVARD·· | Mesa | az | 85258 | GRP-7459 | NULL |
| TPA | TPA-50400 | 2026-08-06T07:56:56Z | Kim, Ralph | — | — | 4/13/1948 | — | UNKNOWN | (955) 359-1842 | — | 6508 Church St #602·· | Sacramento | CA | ·95893 | — | OPTIONS-PPO |
| TPA | TPA-56606 | 2026-03-26T09:10:58Z | Charles, Burke | I | — | UNKNOWN | — | - | N/A | charles.burke@hotmail.com | 3100 LAKE VIEW ROAD | Atlanta | GA | 30302 | — | UNKNOWN·· |
| TPA | TPA-56496 | 2026-10-05T21:03:15Z | Bradley | — | Romero | 1985-08-13 | — | — | UNKNOWN | — | 4722 Harbor Blvd | Minneapolis | MN | ·55495 | - | OPTIONS-PPO·· |
| TPA | TPA-62413 | 2026-04-15T13:35:39Z | WILLIAM | — | ·HUGHES | 01/02/78 | — | — | ·822.456.3791 | NULL | ·9230 CANYON ROAD | Minneapolis·· | MN | — | — | — |
| TPA | TPA-52273 | 2026-09-06T17:44:58Z | Amy | — | Reed | 12/14/1945 | N/A | — | — | null | 6175 CANYON RD | Austin | TX | 78716·· | UNKNOWN | N/A |
| TPA | TPA-55454 | 2026-07-19T11:14:56Z | Mei | — | ·Lee | ·1996-04-03 | — | •••-••-8323 | NULL | — | 850 PINE DRIVE | Atlanta | GA | 30397 | ·- | UNKNOWN |
| TPA | TPA-58392 | 2026-02-10T14:20:56Z | Carol | — | ·Gibson | 1941-01-10 | — | NULL | ·- | — | 6007 OAK ST | Tempe·· | AZ | 85235 | — | — |
| TPA | TPA-55756 | 2026-07-25T05:52:00Z | AISSHA | N | PEREZ | 1985-06-02 | NULL | - | — | AISHA.PEREZ59@ICLOUD.COM | 9553 Elm St | Tampa | FL | 33622 | ·· | UNKNOWN·· |
| TPA | TPA-55453 | 2026-05-10T17:29:39Z | Mei | ·W. | Lee | ·1996-04-03 | NULL | NULL | NULL | — | 850 PINE DRIVE | Atlanta | GA | 30397 | UNKNOWN | NULL |
| TPA | TPA-60140 | 2026-03-20T00:35:57Z | Roger | — | Powell | 1993-07-07·· | ·· | •••-••-3639 | N/A | UNKNOWN | 7669 Lincoln Way | ·Eden Prairie | MN | 55350 | N/A | — |
| TPA | TPA-50967 | 2026-08-09T22:32:01Z | Olivia | ···· | Hart | 1976-10-26 | — | NULL | 8638372853 | - | ·9622 Highland Avenue | Houston | TX | 77017 | — | - |
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.457Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty