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-59441 | 2026-09-03T19:36:13Z | SAMANTHA | — | RAY | 9/3/1990 | ·· | •••-••-5484 | — | NULL | 464 Jefferson Ave | Denver | CO | UNKNOWN | — | — |
| TPA | TPA-62372 | 2026-03-15T11:06:55Z | Lisa | — | Hoffman | 1942-01-28 | — | — | ···· | — | 384 MESA DRIVE | Jacksonville | FL | 32281-9896 | null | ·OPTIONS-PPO |
| TPA | TPA-63319 | 2026-02-10T10:19:03Z | Carolyn | — | Li | 1943-09-13 | — | •••-••-8239 | N/A | null | ·2737 Lake View Road | Minneapolis | MN | 55479·· | NULL | MEDICARE-ADV-A |
| TPA | TPA-52599 | 2026-04-02T01:55:05Z | Susn | — | Matthews | 19600604 | — | NULL | +1 409 931 0599 | - | 2622 Meadow Ln Apt 22 | Austin | TX·· | 78742 | N/A | CORE-HMO |
| TPA | TPA-51841 | 2026-09-25T08:29:48Z | MARCUS | — | LITTLE | Mar 28, 2001 | ·· | - | NULL·· | marcus.little9@gmail.com | 9687 Ridge Rd | ·GILBERT | AZ | 85266 | null | - |
| TPA | TPA-59295 | 2026-10-11T03:54:04Z | Arthur·· | ·· | Parker | 03/13/71 | NULL | — | ·920-760-8700 | arthur.parker85@icloud.com | N/A·· | — | UNKNOWN | N/A | - | SELECT-EPO |
| TPA | TPA-51961 | 2026-06-25T03:12:04Z | JUAN | — | MORRISON | 1997-06-09 | UHC-39290-43 | — | N/A | NULL | 1386 Mesa Dr | Sacramento | CA | 95835 | UNKNOWN | — |
| TPA | TPA-56662 | 2026-03-14T05:01:10Z | MARK | — | RAMIREZ | May 3, 1959 | UHC-99276-30 | •••-••-7880 | null | MARK.RAMIREZ@OUTLOOK.COM | 4317 LAKE VIEW ROAD | SEATTLE | WA | 98109 | N/A | NAVIGATE-HMO |
| TPA | TPA-54974 | 2026-03-26T19:14:24Z | stephen·· | A | lawson | 1977-11-05 | ·N/A | NULL | N/A | — | 8901 Meadow Lane·· | Nashville | TN | 37200 | GRP-7371 | — |
| TPA | TPA-60474 | 2026-01-15T08:42:24Z | Bryan | — | Hamilton | 06/03/2002 | — | - | - | N/A·· | 2921 OCEAN AVE | DENVER | CO | 80223-3873 | — | CHOICE-PLUS-PPO |
| TPA | TPA-56151 | 2026-03-10T20:21:03Z | ·BRUCE | — | BANKS | Jun 21, 1983 | — | ·· | NULL | — | 5040 Harbor Blvd | ·Atlanta | GA | 30334 | — | — |
| TPA | TPA-61853 | 2026-01-25T07:30:28Z | Sarrah | — | Patterson | 1962-09-14 | - | NULL | UNKNOWN | null | 2748 MAPLE AVE | Miami | FL | null | GRP-8805 | N/A |
| TPA | TPA-54249 | 2026-02-09T18:49:55Z | Fields, Betty | D | — | 2004-09-15 | null | — | ·844-716-2407 | — | 6147 LINCOLN WAY·· | Columbus | OH | 43228-3737 | null | — |
| TPA | TPA-56054 | 2026-07-15T00:39:16Z | JEAN | — | EDWARDS | 1956-04-04 | — | null | (452) 736-6468 | - | 8902 CENTRAL AVE | Mesa | Arizona | 85238 | N/A | N/A |
| TPA | TPA-54915 | 2026-04-13T05:00:45Z | Mei | — | Elis | Jun 27, 1938 | UHC-77487-48 | NULL | - | NULL | 1321 RIDGE ROAD·· | San Antonio | Texas | 78276 | null | — |
| TPA | TPA-61604 | 2026-07-16T02:59:22Z | Chris·· | — | Robinson | 1990-04-22 | null | — | — | CHRISTOPHER.ROBINSON@YAHOO.COM | 2661 Valley View Drive | LOS ANGELES | CA | 90006 | - | N/A |
| TPA | TPA-63439 | 2026-09-28T09:14:04Z | Jean | — | Smith | 1938-10-14 | ·null | N/A | — | — | 4181 Lake View Rd | Gilbert | AZ | 85200 | GRP-6826 | null |
| TPA | TPA-62049 | 2026-09-28T23:49:16Z | Christine | — | Wright | 24-09-1944·· | — | — | — | NULL | 5725 Ocean Ave | ORLANDO | FL | 32857 | — | ·- |
| TPA | TPA-60189 | 2026-03-07T18:29:54Z | Frances | — | Wnog | 11/20/1997 | — | N/A | (717) 892-1720 | — | 6245 Broadway | Denver | ·CO | 80235 | NULL | — |
| TPA | TPA-61714 | 2026-04-12T02:28:12Z | ·Tyler | — | Reyes | 1970-89-23 | — | - | (478) 903-8854 | null·· | 4440 Maple Ave | ORLANDO | FL | 32849·· | GRP-9510 | — |
| TPA | TPA-51671 | 2026-02-07T06:31:47Z | ANNA | — | ARMSTRONG | 2002-07-05·· | — | N/A | 4383975442 | NULL | null | N/A | — | — | - | null |
| TPA | TPA-59007 | 2026-02-24T18:30:32Z | terry | — | ford | 1994-10-01 | ···· | — | — | ·· | 9719 Market St #759 | Dallas | TX | 75286 | null | NULL |
| TPA | TPA-53339 | 2026-01-15T09:41:28Z | Edward | — | Jones | 1980-01-23 | - | •••-••-6213 | - | NULL | 2430 Canyon Road | GILBERT | AZ | 85235-6763·· | NULL | — |
| TPA | TPA-50634 | 2026-02-17T21:15:41Z | Castro | — | Albert | 1982-05-10 | null | •••-••-6153 | - | ALBERT.CASTRO20@ICLOUD.COM·· | 3576 Desert Sky Boulevard | Sacramento | CA | — | ·UNKNOWN | — |
| TPA | TPA-62707 | 2026-10-18T22:38:28Z | Bobby | — | Ward | 10/1/1955 | null | •••-••-0989 | ·N/A | NULL | 5410 Ocean Ave | Nashville | TN | 37255-5036 | GRP-3136 | null |
| TPA | TPA-59997 | 2026-07-12T01:19:34Z | Andrea | — | Gomez | 10/27/87 | N/A | null | 734-586-9631 | ANDREA.GOMEZ72@AOL.COM | 9419 SUNSET BLVD | Tucson | AZ | 85762 | UNKNOWN | MEDICARE-ADV-B |
| TPA | TPA-55476 | 2026-09-26T02:43:42Z | McDonald, Maria | — | — | 20080624 | ···· | null | 788-894-1751 | NULL | 8439 ELM STREET | Houston | TX | 77044 | — | — |
| TPA | TPA-57536 | 2026-06-02T09:32:38Z | Arjun | — | Ramos | 1999-09-18 | ···· | •••-••-3824 | — | null | 5493 APACHE BLVD | Dallas | Texas | 75280 | UNKNOWN | CHOICE-PLUS-PPO |
| TPA | TPA-53466 | 2026-04-13T21:26:54Z | LARRY | — | WALKER | 0524-19-93 | - | •••-••-1938 | ·UNKNOWN | — | 7933 INDIAN SCHOOL ROAD | Scottsdale | AZ | 85201 | GRP-3308 | — |
| TPA | TPA-56207 | 2026-01-29T03:21:06Z | Sophia | — | Hart | 1944-01-04 | — | NULL | NULL | — | ·4177 Grand Avenue | Las Vegas | nv·· | 89109 | GRP-5316 | null |
| TPA | TPA-57214 | 2026-02-09T12:49:21Z | ·Jaanice | — | Ramos | 1999-11-02 | null | UNKNOWN | 470.898.5083 | null | 7210 Ocean Ave | ATLANTA | Georgia | 30381 | UNKNOWN | OPTIONS-PPO·· |
| TPA | TPA-56651 | 2026-10-17T07:44:01Z | TERESA | — | HARRISON | 2007-01-27 | - | •••-••-5904 | +1 975 304 9752 | NULL | 1781 HARBOR BOULEVARD | San Antonio | ·TX | N/A·· | — | ···· |
| TPA | TPA-51885 | 2026-02-19T03:43:06Z | Madison | — | Simmons | 19640108 | ·· | — | 611-674-0896 | — | 6893 SAGE CT·· | Denver | CO | — | — | N/A |
| TPA | TPA-52409 | 2026-02-26T02:21:43Z | Alicce | — | Kelley·· | 19850109 | NULL | null | NULL | — | 666 Elm Street·· | Tempe | AZ | - | — | ·MEDICARE-ADV-A |
| TPA | TPA-62851 | 2026-02-12T19:02:00Z | STEPHANIE | — | RUIZ | 19600907·· | — | - | - | - | ·7665 Mesa Dr | Los Angeles·· | CA | ·90093-5320 | N/A | select-epo |
| TPA | TPA-55552 | 2026-08-14T19:05:15Z | SARAH | — | SINGH | 2004-10-21 | N/A | — | UNKNOWN | — | 6395 Bayshore Dr | Nashville | TN | 37224-4012 | — | — |
| TPA | TPA-50272 | 2026-06-01T00:58:07Z | CAROL | — | HUNT | Nov 23, 1967 | — | — | +1 553 376 0788 | N/A | 3809 APACHE BOULEVARD Apt 30 | Columbus | OH | 43215 | — | UNKNOWN |
| TPA | TPA-60749 | 2026-03-05T14:54:21Z | Amy | — | Parker | 1963-04-23 | UNKNOWN | •••-••-0161 | — | — | 9756 Lincoln Way | LOS ANGELES | ·CA | 90067 | - | - |
| TPA | TPA-55390 | 2026-10-11T00:52:14Z | Carroll, Diego | — | — | 1953-07-05 | — | •••-••-1902 | null | diego.carroll65@proton.me | NULL | UNKNOWN | NULL | NULL | N/A | — |
| TPA | TPA-59515 | 2026-04-18T13:08:42Z | heather | — | duncan | 5/5/1946 | - | •••-••-6878 | 793-988-1837 | -·· | 7012 Central Avenue | Mesa | AZ | 85231 | UNKNOWN | NAVIGATE-HMO |
| TPA | TPA-62445 | 2026-01-07T00:03:55Z | santiago | — | adams | 12/7/1981·· | null | — | null | ·santiago.adams70@yahoo.com | 9625 Camelback Road | Jacksonville | FL | 32274-9640 | — | ·SELECT-EPO |
| TPA | TPA-52229 | 2026-02-15T01:04:38Z | SOFIA | — | FULLER | 14-08-1956·· | ·N/A | •••-••-7324 | N/A | sofia.fuller@icloud.com | 9744 Cedar Ln | TUCSON | AZ | 85784 | GRP-7381 | - |
| TPA | TPA-62292 | 2026-02-02T13:41:21Z | Dylan | ···· | Cole·· | 2004-07-01 | UHC-93588-47 | — | 258-293-0050 | NULL | N/A | — | NULL | — | GRP-8895 | NULL |
| TPA | TPA-53390 | 2026-06-02T17:50:56Z | Martinez, Jennifer | — | — | 1975-04-05 | — | — | — | — | 3815 Highland Ave #906 | Nashville | TN | 37279 | - | — |
| TPA | TPA-50035 | 2026-05-28T06:02:56Z | CHRISTIAN | — | CONTRERAS | 1983-07-26 | — | — | — | N/A | — | — | — | N/A | GRP-8330 | -·· |
| TPA | TPA-51456 | 2026-09-23T23:46:37Z | JOHN | — | PALMER | 1951-07-24 | — | NULL | (919) 789-8404 | UNKNOWN | 2782 PARK PLACE | Orlando | FL | 32882·· | GRP-6475 | N/A |
| TPA | TPA-50735 | 2026-06-07T14:19:09Z | Arthur | — | Mason | 1975-07-11·· | NULL | null | ·· | NULL | 5652 Jefferson Ave #471 | San Antonio | TX | 78266 | null | ·CHOICE-PLUS-PPO |
| TPA | TPA-51548 | 2026-07-29T14:32:24Z | Judith | — | Mitchell | 05/03/89 | ···· | UNKNOWN | 367-807-2816 | N/A | NULL | — | - | NULL | N/A | OPTIONS-PPO·· |
| TPA | TPA-63224 | 2026-07-31T08:08:05Z | betty | — | sandoval | 9/25/1944 | - | — | - | betty.sandoval@yahoo.com | 1080 Desert Sky Boulevard | DALLAS | TX·· | 75227 | — | SELECT-EPO |
| TPA | TPA-59823 | 2026-06-30T04:01:21Z | Matthew | — | Hoffman | 1995-04-23 | UHC-49069-01 | •••-••-4346 | 2903733827 | matthew.hoffman59@outlook.com | NULL | - | — | UNKNOWN | GRP-3242 | — |
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-19T19:54:25.422Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty