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-64444 | 2026-04-01T06:48:39Z | Joyce | W. | Henry | 19950216 | UHC-60364-77 | — | 773-575-8245 | UNKNOWN | 7448 Cedar Ln·· | Chandler | AZ | 85270 | NULL | CHOICE-PLUS-PPO |
| TPA | TPA-52885 | 2026-02-11T03:02:44Z | Gordon, James | — | ·· | 1988-04-11 | ·· | — | — | — | 9822 HIGHLAND AVE·· | Tempe | az | 85243 | null | N/A |
| TPA | TPA-53137 | 2026-05-30T09:54:09Z | Fuller, Jose | ·· | — | 1988-04-27·· | NULL | null | 4255450830 | jose.fuller@proton.me | 7713 Willow Ct | Denver | CO | 80223 | — | — |
| TPA | TPA-55794 | 2026-03-06T01:57:09Z | Kathlleen | — | Simpson | 1999-07-27 | null | — | (409) 949-2267 | - | 9520 Central Avenue | Columbus | OH·· | 43244 | GRP-3885 | CORE-HMO·· |
| TPA | TPA-63041 | 2026-07-20T02:08:16Z | Patricia | — | Wilson | 1962-09-25 | - | •••-••-0096 | — | UNKNOWN | 7558 Mesa Drive | COLUMBUS | Ohio | 43220 | null | ·- |
| TPA | TPA-59469 | 2026-05-12T18:30:18Z | Jon | — | Woods·· | 07/25/70 | UNKNOWN | — | 9612302794 | jonathan.woods6@yahoo.com | ·727 Church Street #855 | Las Vegas | NV | 89156 | null | - |
| TPA | TPA-57379 | 2026-02-20T00:08:46Z | Peter | — | Bennett | 11/28/1998 | — | UNKNOWN | NULL | — | 9378 Cedar Lane | TEMPE | ·AZ | 85255 | -·· | N/A |
| TPA | TPA-56223 | 2026-03-23T02:01:35Z | Fatima | Y. | Nunez | ···· | — | •••-••-1127 | — | ·N/A | 9002 Maple Ave | Glendale | Arizona | 85307-6760 | NULL | MEDICARE-ADV-A |
| TPA | TPA-54998 | 2026-05-15T22:29:42Z | Nathan | — | Harvey | 1976-03-06 | — | — | NULL | — | 3666 Lake View Rd | Phoenix | AZ | 85092-1592 | ·GRP-4101 | null |
| TPA | TPA-62565 | 2026-04-06T12:58:55Z | Cheryl | — | ·Armstrong | 1967-04-06 | — | •••-••-0829 | 724-907-3323 | ·NULL | 1762 LAKE VIEW ROAD | SAN DIEGO | CA | 92136 | UNKNOWN | ···· |
| TPA | TPA-61898 | 2026-02-12T08:04:56Z | MASON | — | FULLER | 2006-01-11 | N/A | - | — | null | 6548 Washington St | Austin | Texas | 78700 | — | N/A |
| TPA | TPA-61626 | 2026-05-07T19:22:49Z | Abigail | — | ·Price | ·- | UHC-79699-27 | null | — | NULL | 2730 Desert Sky Blvd | ·TEMPE | AZ | 85245 | GRP-4005 | — |
| TPA | TPA-54481 | 2026-08-01T21:33:53Z | Edwward·· | — | Robinson·· | 1999-06-06 | UHC-97690-56 | ·· | - | — | 3550 MAPLE AVE | Miami | FL | 33136 | - | — |
| TPA | TPA-57478 | 2026-03-06T03:11:10Z | ALBERT | — | NELSON | 1942-10-10 | null | •••-••-1808 | 15446530671 | — | 4813 Central Avenue | Las Vegas | NV | 89140 | GRP-6300 | CORE-HMO |
| TPA | TPA-62100 | 2026-05-29T02:33:32Z | Madison | — | Reyes | 1946-04-18 | — | •••-••-8736 | — | — | 6130 Elm Street | Orlando | FL | 32897 | null | MEDICARE-ADV-A |
| TPA | TPA-62828 | 2026-02-07T04:17:52Z | brenda | — | green | 1966-08-06 | UHC-46437-60 | null | (246) 461-9923·· | N/A | 4014 Canyon Road | Eden Prairie | ·MN | 55348 | - | NAVIGATE-HMO |
| TPA | TPA-63135 | 2026-04-30T19:32:46Z | BARBARA | — | RODRIGUEZ | 1954-04-20 | UHC-58424-93 | •••-••-0643 | N/A | UNKNOWN | 8259 Sage Ct | ·Phoenix | AZ | 85014 | UNKNOWN | — |
| TPA | TPA-58556 | 2026-08-14T12:04:30Z | Christine | — | Duncan | Sep 21, 2004 | - | •••-••-8863 | 14579378079 | NULL | - | — | — | - | N/A | N/A |
| TPA | TPA-51740 | 2026-01-04T17:39:05Z | Judy | — | Gomez | 1977-08-18 | UHC-18172-29 | — | +1 940 250 4971 | JUDY.GOMEZ2@HOTMAIL.COM | 8411 Canyon Rd | ORLANDO | FL | 32840 | GRP-2678 | — |
| TPA | TPA-63179 | 2026-07-03T16:55:43Z | JEFFREY | — | COX | 1998-05-27 | UNKNOWN | •••-••-8821 | — | ·· | 2169 DESERT SKY BOULEVARD | Sacramento | CA | 95842 | N/A | — |
| TPA | TPA-61827 | 2026-02-04T09:34:51Z | Megan | — | Sandoval | Dec 5, 2004 | N/A | - | 18978076545 | NULL | 8968 HIGHLAND AVE Apt 37 | ·ATLANTA | GA | 30327 | GRP-4117 | - |
| TPA | TPA-50705 | 2026-10-12T08:19:10Z | SANDRA | — | BOYD | 03/18/73 | — | N/A | — | null | 1044 Spring St | Tucson | AZ·· | 85737 | GRP-0440 | -·· |
| TPA | TPA-60938 | 2026-08-13T21:15:43Z | KAREN | — | PEREZ | 1/22/1938 | NULL | UNKNOWN | — | ·UNKNOWN | 5839 BROADWAY | TUCSON | AZ | 85776 | - | NAVIGATE-HMO |
| TPA | TPA-58144 | 2026-02-07T00:09:03Z | MARIA | O | HARPER | ·1941-06-14 | UHC-43044-73 | — | N/A | MARIA.HARPER28@PROTON.ME | 48 GRAND AVENUE | Seattle | Washington | 98157 | N/A | — |
| TPA | TPA-60785 | 2026-08-01T16:45:02Z | Sara | — | Oliver | 09/03/57·· | — | - | UNKNOWN | sara.oliver66@yahoo.com | 9299 Highland Avenue·· | SCOTTSDALE | AZ | 85268 | NULL | UNKNOWN |
| TPA | TPA-52544 | 2026-07-26T15:53:24Z | Joe | — | Hamilton | 2003-10-17 | null | - | 233-584-9051 | — | NULL | NULL | N/A | - | — | N/A |
| TPA | TPA-62087 | 2026-04-07T18:12:29Z | LAURA | — | SIMPSON | 1948-01-26 | null | •••-••-5902 | — | laura.simpson32@aol.com | 7788 Sunset Blvd | Chandler | Arizona | 85271 | — | - |
| TPA | TPA-51053 | 2026-04-13T18:05:06Z | peter | — | roberts | 1988-04-11 | UHC-41456-86 | — | 4076290973 | PETER.ROBERTS@AOL.COM·· | NULL | — | UNKNOWN | — | GRP-8886 | N/A |
| TPA | TPA-63197 | 2026-10-08T06:57:21Z | Janice | — | Park | 19711021 | — | NULL | ·748-551-2400 | janice.park86@outlook.com | 7404 Meadow Lane | Eden Prairie | mn | 55363 | N/A | N/A |
| TPA | TPA-51602 | 2026-06-06T12:29:45Z | Janice | — | Ramirez | ·2/17/1972 | null | — | NULL | - | 4673 Sunset Boulevard | EDEN PRAIRIE | MN | 55358 | N/A | - |
| TPA | TPA-63391 | 2026-01-28T07:09:57Z | HELEN | Y. | MURPHY | 1940-04-15 | - | NULL | 263-732-8246 | NULL | UNKNOWN | null | null·· | — | GRP-7794 | SELECT-EPO·· |
| TPA | TPA-61084 | 2026-02-13T03:43:11Z | MARY | P | OLSON | 1959-05-05 | — | — | null | — | 853 Forest Ave | Orlando | ·FL | 32830 | GRP-2325 | NULL |
| TPA | TPA-51420 | 2026-07-02T19:44:19Z | Harrold | — | Cox | 19900721 | UNKNOWN | N/A | 18966329013 | UNKNOWN | 7364 Lincoln Way | LAS VEGAS | NV | 89137 | - | — |
| TPA | TPA-59946 | 2026-02-26T11:01:42Z | Miller, William | — | ···· | 1998-08-23 | N/A | — | (406) 291-1484 | WILLIAM.MILLER41@GMAIL.COM | 2824 Grand Avenue | Miami | FL | 33161-7641 | — | CHOICE-PLUS-PPO |
| TPA | TPA-62426 | 2026-09-26T16:06:47Z | ·sophia | — | rojas | 1999-11-18 | ·- | — | (346) 724-9967 | NULL·· | 4947 MESA DR | Nashville | TN | 37299 | GRP-9669 | CORE-HMO |
| TPA | TPA-62890 | 2026-07-31T02:16:44Z | NATHAN | — | PETERS | 14-03-1984 | null | null | — | NATHAN.PETERS46@HOTMAIL.COM | 7611 Spring Street | GILBERT | AZ | — | NULL | SELECT-EPO |
| TPA | TPA-61142 | 2026-05-02T05:44:24Z | MICHAEL | ···· | COLE | 1958-07-12 | null | - | ·- | UNKNOWN | 4135 Washington St | Minneapolis | MN | 55477 | UNKNOWN | — |
| TPA | TPA-60695 | 2026-04-04T05:46:00Z | Lawrence | — | Carpenter | 1948-04-25 | UHC-02642-89·· | NULL | — | null | 132 Valley View Drive Apt 22 | COLUMBUS | OH | 43281 | GRP-0862 | — |
| TPA | TPA-52743 | 2026-08-02T10:06:10Z | Gloria | ···· | Bennett | 1901-19-85 | null | •••-••-9850 | 3613735871 | — | 8792 Grand Avenue | Minneapolis | Minnesota·· | ·55419 | - | UNKNOWN |
| TPA | TPA-59917 | 2026-09-23T17:27:42Z | Gabriel | — | Cox | Aug 17, 1994 | - | •••-••-5667 | — | - | 3550 WILLOW CT | SCOTTSDALE | AZ | ·85217 | GRP-4913 | MEDICARE-ADV-B |
| TPA | TPA-64220 | 2026-06-19T11:16:50Z | Grace | — | Gilbert | 04/17/2005 | UHC-23695-84 | NULL·· | 437-744-9257 | GRACE.GILBERT@YAHOO.COM | 821 Cedar Ln | Denver | CO | 80242 | — | — |
| TPA | TPA-60575 | 2026-06-05T13:39:36Z | Marcus | — | Ramireez | 4/23/1979 | NULL | — | N/A | — | 8995 SAGE COURT | Mesa | AZ | 85298·· | — | SELECT-EPO |
| TPA | TPA-59505 | 2026-04-23T06:59:29Z | TERESA | — | CHAVEZ | 1955-12-19 | UHC-86083-05 | •••-••-0801 | 897-285-7938 | teresa.chavez86@yahoo.com | 8567 CHURCH STREET | Houston | TX | 77019 | GRP-9637 | CHOICE-PLUS-PPO |
| TPA | TPA-61396 | 2026-06-27T01:34:27Z | GARY | — | TORRES | 1950-01-13 | NULL | - | NULL·· | — | 3540 HARBOR BLVD | Chandler | ·AZ | 85287 | NULL | N/A |
| TPA | TPA-56182 | 2026-02-06T18:47:25Z | Thomas | — | Watson | 1971-09-05 | UNKNOWN·· | null | — | — | 7825 Lincoln Way | Phoenix | AZ | ·85072 | GRP-5710 | N/A |
| TPA | TPA-54522 | 2026-05-25T09:28:51Z | Patricia | — | Hayes | 1993-05-27·· | — | •••-••-8047 | +1 619 410 0159 | ·NULL | NULL | ·N/A | — | NULL | — | UNKNOWN |
| TPA | TPA-57930 | 2026-03-21T18:30:14Z | Eugene | N. | Greene | 1979-09-16 | UHC-12315-94 | — | null | EUGENE.GREENE34@HOTMAIL.COM | 7677 HIGHLAND AVENUE | Tampa | FL | 33615 | ·null | — |
| TPA | TPA-59284 | 2026-08-09T08:43:47Z | Artthur | — | Chavez | 1976-01-33 | - | null | (428) 838-6557 | arthur.chavez@icloud.com | UNKNOWN | — | null | null | GRP-6797 | SELECT-EPO |
| TPA | TPA-51229 | 2026-08-12T17:10:25Z | LUIS | — | PAYNE·· | 12/14/1986·· | — | - | 782.853.8699 | NULL | UNKNOWN | NULL | — | NULL | null | — |
| TPA | TPA-56174 | 2026-04-07T09:40:49Z | JUDITH | — | FOSTER | 03-07-1972 | — | •••-••-9040 | null | — | 6667 Elm St | DALLAS | TX | 75243 | GRP-8828 | — |
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:43.417Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty