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-52435 | 2026-09-28T02:13:43Z | Judith | — | Riley | 11/28/85 | UNKNOWN | - | - | JUDITH.RILEY24@AOL.COM·· | 2484 Valley View Dr | Columbus·· | OH | 43247-3739 | - | — |
| TPA | TPA-54458 | 2026-09-27T10:01:10Z | CHARLES | — | ·RICE | 1953-09-09 | — | — | UNKNOWN | — | 8697 Main St | JACKSONVILLE | FL | 32245 | - | OPTIONS-PPO |
| TPA | TPA-52731 | 2026-09-05T09:49:58Z | Randy | X. | McCoy | ·1974-02-12 | NULL·· | UNKNOWN | UNKNOWN·· | NULL | 9102 Hillcrest Rd | Denver | CO | 80253 | UNKNOWN | — |
| TPA | TPA-56415 | 2026-07-24T10:52:07Z | Joyce | A·· | Tran | 1939-04-24 | UNKNOWN | •••-••-8326 | 5446290568 | — | 3124 Grand Ave | Miami | Florida | 33162-8428 | ·GRP-2908 | ·OPTIONS-PPO |
| TPA | TPA-58749 | 2026-08-05T01:49:34Z | Ahmed | — | Elliott | 1982-06-21 | - | NULL | ·(498) 680-6513 | ahmed.elliott85@gmail.com | 9238 Pine Dr | Tampa | FL | 33657 | UNKNOWN | UNKNOWN |
| TPA | TPA-55105 | 2026-06-15T18:03:20Z | KLELY | — | WATTSON·· | 1987-01-01·· | N/A | •••-••-5501 | (816) 621-4642 | kelly.watson@gmail.com | 8772 Desert Sky Blvd #732 | Phoenix | AZ | 85015 | GRP-1741 | — |
| TPA | TPA-54705 | 2026-09-07T15:09:55Z | Charlotte·· | — | Ruiz | Sep 20, 1955 | UHC-93692-65 | — | NULL | - | 6948 Broadway | Scottsdale | AZ | 85217 | NULL | - |
| TPA | TPA-58745 | 2026-05-14T04:39:32Z | Kyel | — | Garrett | 02/20/1972 | NULL | — | — | — | ·1381 Apache Boulevard | Jacksonville | FL | 32299 | GRP-7672 | CHOICE-PLUS-PPO |
| TPA | TPA-62779 | 2026-03-23T05:45:29Z | Mark | — | Wang | 2170-19-89 | UHC-57825-02 | N/A | null | — | NULL | — | UNKNOWN | — | N/A | — |
| TPA | TPA-53633 | 2026-07-06T13:10:59Z | Alexander | — | Gutierrez | 1969-08-03 | — | UNKNOWN | (656) 268-7280 | — | 3809 OAK STREET | Sacramento | CA | 95811 | — | MEDICARE-ADV-A |
| TPA | TPA-59602 | 2026-09-24T14:02:38Z | Julie | — | Spencer | 1963-03-20 | — | — | - | julie.spencer47@aol.com | N/A | ···· | — | UNKNOWN | NULL | — |
| TPA | TPA-63318 | 2026-09-09T09:59:41Z | JOHN | ···· | VAZQUEZ | 3/21/1956·· | ·· | N/A | 5213268166 | null | null | NULL | - | NULL | ·GRP-6176 | N/A |
| TPA | TPA-51886 | 2026-09-15T15:46:54Z | EMILY | — | BELL | 06/26/08 | N/A | NULL | 888-600-1377 | emily.bell@gmail.com | 1694 Harbor Boulevard | Nashville | TN | 37238-6109 | NULL | null |
| TPA | TPA-54612 | 2026-06-01T04:41:34Z | LUCIA | — | WATSON | 1976-09-28 | UHC-44470-52 | — | N/A | N/A | null | null | null | UNKNOWN | GRP-6683 | null |
| TPA | TPA-50753 | 2026-04-21T15:27:04Z | JUAN | — | HILL | ·1973-11-18 | ·UHC-37787-33 | null | 765.718.4208 | — | 5687 Washington Street | Phoenix | Arizona·· | 85004 | - | — |
| TPA | TPA-57034 | 2026-07-23T00:15:26Z | PAT | — | ROBERTSON | 23-12-1950 | NULL | •••-••-2536 | — | N/A | ···· | ·- | NULL | — | — | N/A·· |
| TPA | TPA-56948 | 2026-10-04T17:43:37Z | SANTIAGO | — | ·MUNOZ | 1974-11-16 | — | •••-••-5952 | - | N/A | 2618 Broadway | Columbus | OH | 43228 | — | - |
| TPA | TPA-61532 | 2026-03-30T23:16:05Z | Warren, Stpehen | — | — | 6/13/1955 | UNKNOWN | •••-••-7180 | null | - | 5076 APACHE BLVD | Scottsdale | Arizona | 85267-4459 | — | - |
| TPA | TPA-50924 | 2026-04-22T00:48:07Z | Catherine | — | Silva | 18-10-1991 | UHC-28183-55 | •••-••-4550 | (258) 349-5842 | N/A | 1651 OAK STREET | AUSTIN | TX | 78756 | UNKNOWN | null |
| TPA | TPA-55427 | 2026-07-20T10:14:19Z | Barbara | — | Schultz | 1997-02-25 | — | N/A | (730) 343-2627 | N/A | 1266 SPRING STREET | DALLAS | TX | 75294-1279 | GRP-1549 | — |
| TPA | TPA-51371 | 2026-04-27T23:57:37Z | Sarah | — | Crawford | 1996-06-24 | null | •••-••-7441 | 5948358126 | — | 8210 Cedar Lane | Columbus | Ohio | UNKNOWN·· | null | — |
| TPA | TPA-54866 | 2026-01-13T02:52:26Z | Ann | — | Garrett | 1995-08-12 | UNKNOWN | — | +1 869 898 0737 | ann.garrett71@hotmail.com | null | null | - | N/A | null | NULL |
| TPA | TPA-53751 | 2026-06-04T19:23:57Z | Billy | — | Rice | 02/24/49 | N/A | UNKNOWN | +1 376 871 0180 | - | - | — | — | ·· | — | — |
| TPA | TPA-56286 | 2026-03-25T22:22:50Z | Brian | I | Olson | 1998-12-23 | null | •••-••-9694 | N/A | — | 8779 Bayshore Dr | Jacksonville | FL | 32216 | null | — |
| TPA | TPA-58140 | 2026-03-06T10:23:49Z | justin | — | schultz | 19850809 | — | — | 428-609-4867 | null | ·6556 MOUNTAIN VIEW DR | Glendale | AZ | 85309 | GRP-6488 | — |
| TPA | TPA-61327 | 2026-05-22T16:06:15Z | Ryan | — | Barnes | 19570902 | UNKNOWN | •••-••-7061 | 857.379.0866 | — | 4816 Desert Sky Blvd | Gilbert·· | AZ | 85248 | GRP-7730 | OPTIONS-PPO |
| TPA | TPA-50863 | 2026-06-29T23:11:21Z | Vincent | — | Salazar | 1995-11-20 | UNKNOWN | UNKNOWN | ·840-365-6368 | vincent.salazar71@aol.com | 5492 Meadow Lane | ·Eden Prairie | Minnesota | 55335-2098 | null | NULL |
| TPA | TPA-55381 | 2026-02-09T15:37:03Z | ·WAYNE | ·T | GREENE | 5/20/1964 | null | •••-••-5030 | (478) 547-9922 | — | 5071 CEDAR LANE | ·Nashville | TN | 37279-2981·· | UNKNOWN | NULL |
| TPA | TPA-59360 | 2026-08-01T05:59:25Z | Jimmy | — | Gardner·· | Oct 4, 1962 | — | -·· | 235-262-7248 | N/A | 2078 Sunset Blvd | Nashville | TN | NULL·· | UNKNOWN | null |
| TPA | TPA-55584 | 2026-01-27T21:45:24Z | frank | — | bennett | 2007-04-06 | UHC-90848-74 | - | — | NULL | 8560 Park Pl | Miami | FL·· | 33125 | GRP-9518 | UNKNOWN |
| TPA | TPA-63518 | 2026-07-28T05:45:55Z | kimberly | — | vega·· | 1961-03-18 | - | — | null | kimberly.vega@gmail.com | 9577 Spring Street | Nashville | Tennessee | 37217 | NULL | UNKNOWN |
| TPA | TPA-60789 | 2026-01-24T15:54:33Z | Wagner, Tyler | B | — | 1977-08-17 | UHC-29723-33 | N/A | 4056658474 | null | 8116 WILLOW CT | San Antonio | TX | 78239 | N/A | null |
| TPA | TPA-62136 | 2026-02-27T23:25:17Z | Estrada, Jacob | C | — | — | — | •••-••-1023 | UNKNOWN | N/A | 2004 PARK PLACE | Plano | Texas | 75000 | null | NAVIGATE-HMO |
| TPA | TPA-51004 | 2026-03-18T02:57:22Z | Matthew | — | Allen | Jul 11, 1989 | — | N/A | (230) 651-5265 | matthew.allen33@yahoo.com | - | — | NULL | N/A·· | UNKNOWN | -·· |
| TPA | TPA-62531 | 2026-09-04T12:24:15Z | Victoria | — | Evans | 1962-08-16 | — | — | NULL | N/A | 5865 PALM DR | TEMPE | AZ·· | 85230·· | — | N/A |
| TPA | TPA-62846 | 2026-06-30T06:44:56Z | LAUREN | — | ·SILVA | 1946-07-01 | — | •••-••-8148 | (248) 749-8456 | - | 7322 Ocean Ave | PHOENIX | AZ | 85099 | GRP-3565 | N/A·· |
| TPA | TPA-53376 | 2026-01-14T11:34:30Z | — | — | — | 12/12/1990 | UNKNOWN | - | 802-931-2371 | null | 1686 HILLCREST ROAD | Columbus | OH·· | 43227 | GRP-5400 | null |
| TPA | TPA-51254 | 2026-04-01T16:48:12Z | Sarah | — | Reed | 1980-11-17 | - | •••-••-0292 | — | N/A | 6096 HILLCREST RD | Tempe | AZ | 85242·· | N/A | null·· |
| TPA | TPA-55805 | 2026-03-14T04:00:55Z | Gordon, Bobby | — | — | 01/03/1980 | N/A | N/A | 8475740019 | — | 2134 Ridge Rd | Sacramento | CA | 95893 | UNKNOWN | — |
| TPA | TPA-60840 | 2026-04-27T16:31:05Z | Elijah | — | Cole | 1967-10-25 | NULL | — | - | ELIJAH.COLE52@YAHOO.COM | N/A | ·NULL | null | UNKNOWN | — | — |
| TPA | TPA-53942 | 2026-05-01T11:51:05Z | ·Brittany | — | Hawkins | 19820512 | — | •••-••-5251 | -·· | NULL | 2844 MEADOW LN | LOS ANGELES·· | CA | 90098 | N/A | - |
| TPA | TPA-57256 | 2026-03-19T20:09:51Z | alex | — | prekins | 1959-03-26 | UHC-60662-97·· | — | 716-433-6395 | — | 26 Camelback Road | Plano | Texas | 75058 | GRP-7341 | - |
| TPA | TPA-63476 | 2026-02-14T19:58:29Z | Debra·· | — | ·Herrera | 1986-02-20 | — | •••-••-9351 | 648-306-5777 | N/A | 108 Bayshore Dr | Tampa | FL | 33661 | GRP-5170 | NULL |
| TPA | TPA-58823 | 2026-05-21T08:45:36Z | Steen | — | Turner | 1940-04-27 | null | NULL | N/A | steven.turner@hotmail.com | 7023 River Road | Gilbert | Arizona | NULL | GRP-5728 | CHOICE-PLUS-PPO |
| TPA | TPA-61891 | 2026-05-12T05:26:39Z | frank | ···· | garcia | 1941-07-01 | — | NULL | - | - | 9059 Market Street·· | Denver | Colorado | 80268 | UNKNOWN·· | CHOICE-PLUS-PPO |
| TPA | TPA-60588 | 2026-04-24T20:37:07Z | LAURA | — | JORDAN | 1961-07-06 | UNKNOWN | •••-••-2618 | 982-487-7437 | laura.jordan92@icloud.com·· | 7326 Elm Street | Phoenix | AZ | ·85020 | ·GRP-7322 | NULL |
| TPA | TPA-51798 | 2026-03-07T18:11:12Z | Fox, Olivia | — | — | 1976-01-11 | — | •••-••-8993 | N/A | null | null | N/A | UNKNOWN | — | — | ···· |
| TPA | TPA-60314 | 2026-04-02T17:21:23Z | Lisa | — | Valedz | 12/13/2006 | UHC-32379-05 | — | 800-626-0173 | N/A | 7952 Apache Blvd | Columbus | OH | 43200 | N/A | MEDICARE-ADV-A |
| TPA | TPA-62168 | 2026-07-15T07:26:16Z | ·Willie | — | Valdez | 1988-02-17·· | NULL | — | null | — | 5816 WASHINGTON STREET | Charlotte | NC | — | — | - |
| TPA | TPA-62221 | 2026-09-29T02:48:33Z | Sofia | — | Arnold | 1973-09-13 | UHC-41265-38 | — | ···· | null | 423 MARKET STREET | SACRAMENTO | CA | 95843 | — | 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:46.060Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty