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-62054 | 2026-07-23T06:24:23Z | Michelle | — | Hart | 04/06/72 | null·· | null | NULL | ···· | 2271 LAKE VIEW ROAD | Houston | tx | 77096 | null | - |
| TPA | TPA-63554 | 2026-02-25T05:46:51Z | Olivia | — | Myers | 2008-06-12 | — | •••-••-1961 | — | - | ·369 Apache Boulevard | LOS ANGELES | CA | 90023 | N/A | UNKNOWN |
| TPA | TPA-52363 | 2026-09-27T10:12:29Z | HELEN | P | ·DAY | 1956-04-28 | UHC-06442-28 | — | UNKNOWN | null | UNKNOWN | — | N/A | ·N/A | GRP-2746 | CHOICE-PLUS-PPO |
| TPA | TPA-61500 | 2026-09-09T19:47:34Z | Palmer, Danielle | — | — | 2001-07-22 | UHC-01567-87 | NULL | UNKNOWN | UNKNOWN·· | 9568 Maple Avenue | San Diego | CA | 92162 | ·UNKNOWN | MEDICARE-ADV-A |
| TPA | TPA-59518 | 2026-10-14T10:49:52Z | Richard | — | Hamilton | 2001-10-03 | NULL | UNKNOWN | - | - | 7349 Bayshore Drive | Plano | TX | 75099 | — | CHOICE-PLUS-PPO |
| TPA | TPA-50522 | 2026-04-21T03:40:22Z | Carl | — | Morrison | 19890626 | N/A | •••-••-6516 | N/A | — | 3084 River Rd | Denver | ·CO | 80236·· | GRP-7832 | UNKNOWN |
| TPA | TPA-50347 | 2026-02-15T12:24:08Z | STEPHANIE | — | GARDNER | 1952-12-28 | UHC-33192-03 | NULL | NULL | — | 1154 Lincoln Way | Seattle | WA | 98159 | null | — |
| TPA | TPA-56472 | 2026-05-02T01:02:55Z | Rachel | — | Ray | 1956-09-26 | — | N/A | — | UNKNOWN | 4441 Palm Drive #535·· | Fresno·· | CA | 93791 | GRP-6454 | - |
| TPA | TPA-58426 | 2026-08-20T14:01:52Z | DANNY | — | ·JOHNSON | 03/27/1941 | N/A | null | 2854810846 | UNKNOWN | 8387 Church St #385 | Tempe | az | null | GRP-9059 | ·CHOICE-PLUS-PPO |
| TPA | TPA-54965 | 2026-01-31T22:08:46Z | Maria | — | Singh | 02/18/1987 | NULL | •••-••-2274 | 421-287-6631 | null | 3060 Lincoln Way | AUSTIN | Texas | 78790 | NULL | — |
| TPA | TPA-51994 | 2026-04-29T23:41:51Z | HIROSHI | — | LI | 1965-02-27 | null | •••-••-7359 | 389-368-6392 | N/A | 4513 Lincoln Way | NASHVILLE | TN | 37208 | null | CORE-HMO |
| TPA | TPA-50557 | 2026-06-28T13:37:03Z | Frank | — | Park | Oct 9, 1940 | NULL | null | 643-270-2924 | UNKNOWN·· | 9254 Cedar Lane | Sacramento | California | 95886 | ·- | - |
| TPA | TPA-62468 | 2026-03-16T04:58:39Z | Jesse | Y·· | Baker | 1/5/1985 | — | null | 3199329132 | - | 6412 Lincoln Way | Houston | TX | ·· | UNKNOWN | NULL |
| TPA | TPA-56147 | 2026-03-19T10:30:24Z | Mason | — | Rios | 19500914 | UNKNOWN | •••-••-8857 | (220) 822-0528 | NULL | 8770 Washington St Apt 33 | GLENDALE | AZ | 85340 | GRP-4905 | MEDICARE-ADV-A |
| TPA | TPA-59299 | 2026-02-06T15:58:02Z | Marquez, Matthew | — | — | 1984-02-09 | — | UNKNOWN | (805) 733-2989 | null | 6565 Maple Avenue | Glendale | Arizona | 85322 | null | ·UNKNOWN |
| TPA | TPA-61884 | 2026-06-25T03:55:13Z | Nathan | — | Sanchez | 19-05-1961 | - | — | UNKNOWN | - | 9173 Cedar Lane | Las Vegas | NV | 89194 | GRP-1330 | OPTIONS-PPO |
| TPA | TPA-61426 | 2026-06-22T17:08:23Z | Dean, Juhn | — | — | 6/25/1983 | NULL | NULL | — | — | ·2971 Broadway | Fresno | California | 93700 | UNKNOWN | — |
| TPA | TPA-53747 | 2026-03-14T01:04:45Z | susan | — | sims | 07/18/58 | null | - | N/A | NULL | 2297 Elm Street | ·Austin | TX | 78742 | GRP-3215 | - |
| TPA | TPA-61416 | 2026-08-31T06:14:12Z | ·Jose | — | Morrison | May 8, 2003 | UNKNOWN | — | UNKNOWN·· | — | 8078 FOREST AVE | Atlanta | ga | ·30301 | — | NULL |
| TPA | TPA-60125 | 2026-09-18T02:00:04Z | Bryan | — | Robertts | 1938-07-04 | UNKNOWN | — | — | N/A | 6377 Indian School Road | Tempe | AZ | 85256 | GRP-4774 | - |
| TPA | TPA-64194 | 2026-03-30T15:34:35Z | Diane | — | Gordon | 1974-08-21 | — | - | 2423452434 | DIANE.GORDON@YAHOO.COM | ·9110 Camelback Road | Dallas | TX | 75211 | NULL | OPTIONS-PPO |
| TPA | TPA-51461 | 2026-05-18T10:35:45Z | Dylan | — | Day | 03/05/1968 | - | - | 4364032927 | N/A | 522 Indian School Rd | Denver | Colorado | 80214 | UNKNOWN | ···· |
| TPA | TPA-55222 | 2026-05-30T15:36:57Z | Patrick·· | — | Le | 7/13/2007 | - | NULL·· | NULL | null | ·N/A | — | - | UNKNOWN | GRP-8650 | — |
| TPA | TPA-57112 | 2026-02-11T01:25:54Z | Richardson, Larry | — | — | 1968-09-23 | NULL | - | UNKNOWN | - | 5408 Ocean Avenue | Atlanta | GA | 30318 | - | NULL |
| TPA | TPA-55336 | 2026-06-24T05:06:17Z | BRITTANY | — | HUDSON | 1974-11-22 | UHC-99834-93 | •••-••-4449 | ·707-708-4336 | null | 1400 Palm Dr | San Diego | CA | 92164 | — | - |
| TPA | TPA-50296 | 2026-05-21T09:47:50Z | David | ·· | Medina | Apr 26, 2006 | — | — | null | N/A | 1177 Sage Court | ·Dallas | TX | 75271 | NULL | — |
| TPA | TPA-54714 | 2026-01-16T11:41:59Z | GREGORY | ·· | HUDSON | ·Feb 4, 1954 | UHC-41204-86 | null·· | — | — | NULL | - | - | — | UNKNOWN | — |
| TPA | TPA-54347 | 2026-04-14T12:15:42Z | ·Omar | — | Wung | 19521111 | — | NULL | null | omar.wong51@gmail.com | 8933 Mesa Drive | Minneapolis | MN | 55458 | GRP-3719 | ·OPTIONS-PPO |
| TPA | TPA-56340 | 2026-06-21T18:25:22Z | Nathan·· | — | Fowler | 2000-07-09 | null | NULL | - | NULL | null | - | UNKNOWN | NULL | null | — |
| TPA | TPA-56309 | 2026-10-06T16:59:25Z | Camila | — | Ortiz | 2008-06-21 | - | null | N/A | ·· | 8674 Cedar Lane | Houston | TX | 77047 | GRP-9032 | NAVIGATE-HMO |
| TPA | TPA-61964 | 2026-03-01T10:27:27Z | olivia | — | grant | 08/15/03 | UHC-01709-43 | null | — | NULL | 4874 WILLOW CT | San Diego | California | 92165 | GRP-2966 | UNKNOWN |
| TPA | TPA-51760 | 2026-01-12T19:20:06Z | KENNETH | — | PAYNE | 10/27/1973 | — | — | NULL | — | 4077 Grand Ave | Chandler | AZ | ·85223 | — | ·- |
| TPA | TPA-62826 | 2026-04-02T04:17:08Z | Gutierrez, Christine | ···· | ···· | 11/17/64 | — | null | (673) 497-2389 | — | 7675 Pine Drive | ·Seattle | WA | 98144 | N/A | null |
| TPA | TPA-58209 | 2026-03-26T13:00:24Z | ETHAN | — | DAVIS | 1973-12-20 | - | null | 6292019441 | null | — | N/A | NULL | — | GRP-0565 | — |
| TPA | TPA-63478 | 2026-04-16T10:12:51Z | ·TONY | — | JOHNSTON | 2005-11-28 | — | null | UNKNOWN | — | NULL | — | — | UNKNOWN | ·GRP-2867 | SELECT-EPO |
| TPA | TPA-56163 | 2026-06-10T23:17:01Z | Waler, Luis | — | ···· | 1980-06-17 | UNKNOWN | — | 670-549-1322 | UNKNOWN | 9567 Canyon Road | Seattle | WA | 98155 | — | N/A |
| TPA | TPA-51899 | 2026-08-01T16:29:29Z | Pamela | — | Harvey | 04-08-1942·· | - | N/A | - | null | — | NULL | N/A | — | — | OPTIONS-PPO |
| TPA | TPA-54415 | 2026-01-23T01:55:58Z | Priya | — | Aguilar | 10/24/2000 | null | — | — | N/A | 6298 PINE DR | San Diego | CA | null | — | - |
| TPA | TPA-54923 | 2026-03-05T08:01:27Z | Nancy | — | Wheeler | Jul 20, 1992·· | — | •••-••-9636 | +1 283 864 3586 | NANCY.WHEELER@AOL.COM | - | null | UNKNOWN | ·· | — | NULL |
| TPA | TPA-63059 | 2026-01-07T00:58:15Z | Pamela | — | Kim·· | 1980-03-14 | UHC-79074-20 | — | 7699753197 | ·· | 2856 Washington Street | MINNEAPOLIS | MN | 55408 | — | ···· |
| TPA | TPA-59247 | 2026-07-24T05:54:13Z | LORI | — | RUIZ | 20040212 | — | ···· | +1 816 684 4985 | null | 5235 Forest Avenue | Miami | ·FL | null | GRP-9936 | — |
| TPA | TPA-63642 | 2026-03-02T10:00:02Z | Dennis | — | Brrown | 05/22/44 | N/A | NULL | NULL | N/A | 5143 Cedar Lane | Minneapolis | MN | 55447 | UNKNOWN | null |
| TPA | TPA-55035 | 2026-04-25T02:33:36Z | Brenda | — | ·Tran | 1994-10-17 | — | — | N/A | ·null | 9506 Lake View Road | Tucson | AZ·· | - | ·· | CHOICE-PLUS-PPO |
| TPA | TPA-62627 | 2026-06-27T05:16:16Z | Brittany | — | Fuller | ·Dec 7, 1965 | — | UNKNOWN | NULL | ·NULL | ·799 Elm Street | LAS VEGAS | NV | 89109 | GRP-8142 | — |
| TPA | TPA-53047 | 2026-06-25T16:01:46Z | FATIMA | — | HOLMES | 1970-05-01 | UHC-66550-61 | ···· | 6189837832 | null | 2343 Camelback Rd | Fresno | CA | 93758 | null | SELECT-EPO·· |
| TPA | TPA-50682 | 2026-05-11T04:29:27Z | Megan | — | Peters | 1991-08-14 | ·UNKNOWN | — | — | — | 5630 Park Pl Apt 36 | Tucson | AZ | 85758 | GRP-1156 | ·· |
| TPA | TPA-53269 | 2026-07-20T04:19:26Z | Joseph | C | King | 1024-19-82 | — | UNKNOWN·· | 703-836-2946 | - | 9130 Broadway | Jacksonville | FL | 32290 | — | OPTIONS-PPO |
| TPA | TPA-55887 | 2026-06-20T02:10:52Z | Eric | — | Jenkinns | 2004-02-27 | — | •••-••-1030 | (401) 425-1483 | N/A | 8967 Pine Drive | Nashville | Tennessee | null | GRP-1843 | — |
| TPA | TPA-59692 | 2026-01-07T07:57:37Z | GERALD | — | PARKER | 1953-07-26 | null | — | 15497961253·· | — | 4446 FOREST AVENUE | Dallas | TX | 75237 | GRP-1697 | — |
| TPA | TPA-52276 | 2026-07-10T23:07:41Z | Joe | — | Cook | 1938-06-26 | UHC9470946 | N/A | null | ·joe.cook@hotmail.com | — | — | N/A | — | ·UNKNOWN | UNKNOWN |
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:49.103Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty