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-59427 | 2026-04-20T11:01:45Z | Hicks, Timothy | J. | — | 1998-07-05 | null | — | ···· | — | - | — | - | NULL | ·· | UNKNOWN |
| TPA | TPA-55115 | 2026-10-05T19:52:15Z | AHMED | — | PATEL | ·2005-02-09 | UHC-86063-13 | NULL | - | ahmed.patel51@icloud.com | 7258 APACHE BOULEVARD Apt 7·· | Austin | ·TX | 78766 | — | UNKNOWN |
| TPA | TPA-62483 | 2026-03-30T15:50:35Z | Brucce | G | Evans | 1965-11-07 | N/A | — | ·null | null | 6479 River Rd | DENVER | CO | 80250-4547 | — | — |
| TPA | TPA-63233 | 2026-03-29T08:07:39Z | Jessica | — | Scott | 12-03-1971 | N/A | •••-••-4022 | null | NULL | 2188 HILLCREST RD | Gilbert·· | AZ·· | 85274 | - | — |
| TPA | TPA-55419 | 2026-02-19T19:38:42Z | SUSAN | — | ROJAS | 10/28/1975 | UHC-53235-16 | •••-••-8590 | — | N/A | 5079 Main St | Dallas | TX·· | 75224 | null | CHOICE-PLUS-PPO |
| TPA | TPA-60413 | 2026-08-30T04:09:16Z | EILJAH | — | HUNTER | 05/21/92 | — | — | ·UNKNOWN | null | 9432 Broadway | Minneapolis | MN | 55466 | — | core-hmo |
| TPA | TPA-50711 | 2026-08-06T03:03:30Z | Walsh | — | Jerry | null | — | ·· | NULL | UNKNOWN | 6984 Union St | Tampa | FL·· | 33621 | UNKNOWN | MEDICARE-ADV-B |
| TPA | TPA-62260 | 2026-05-11T08:47:30Z | Camila | — | Parker | 1957-05-01 | — | — | - | UNKNOWN | ·4559 Bayshore Drive Apt 13 | Chandler | AZ | UNKNOWN | GRP-2875 | CHOICE-PLUS-PPO |
| TPA | TPA-61731 | 2026-05-25T12:11:02Z | Spencer, Matthew | ·· | — | 2002-08-26·· | — | — | 571-907-0427 | - | NULL | — | — | — | GRP-4686 | N/A |
| TPA | TPA-58747 | 2026-02-18T07:06:39Z | Judy | — | Andrews | 1986-09-07 | UHC-49978-58 | NULL | 3546582910 | NULL | 6785 PINE DRIVE | Sacramento | CA | 95845 | null | NULL |
| TPA | TPA-54153 | 2026-08-11T16:27:36Z | Daniel | — | Lynch | 2001-05-17 | - | N/A | NULL | NULL | ·2820 Valley View Drive | Mesa | Arizona | 85224-7924 | GRP-5643 | — |
| TPA | TPA-59702 | 2026-04-05T17:03:54Z | SOFIA·· | A. | WAGNER | 02/27/1947 | N/A | — | 803-466-4294 | null | 1490 Hillcrest Road | ·Tucson | AZ | 85781 | UNKNOWN | MEDICARE-ADV-A |
| TPA | TPA-62240 | 2026-04-20T15:51:52Z | Brooks, Carol | — | — | 1953-08-03 | UHC-66153-39 | — | 12105415131 | ···· | 3003 Oak Street·· | Dallas | TX | 75266 | null | — |
| TPA | TPA-50721 | 2026-07-19T21:10:47Z | Christina | — | Sandoval | 12/28/1983 | null | — | - | UNKNOWN | — | N/A | ·· | — | UNKNOWN·· | — |
| TPA | TPA-58779 | 2026-08-19T22:07:47Z | LINDA | X | WAGNER | 1994-05-17 | NULL | - | 317-927-6389 | linda.wagner@aol.com | 3653 PINE DR | ATLANTA | GA | 30338 | GRP-3499 | UNKNOWN |
| TPA | TPA-62563 | 2026-07-26T05:28:20Z | Kathleen | — | Myers | 1952-10-16 | null | — | 15544103626 | null | 1268 Main St | HOUSTON | TX | 77079·· | - | UNKNOWN |
| TPA | TPA-58272 | 2026-06-28T13:25:02Z | RUSSELL | — | LUNA | 1991-11-16 | NULL | N/A | - | N/A | 3367 Elm Street | Columbus | OH | 43218 | GRP-7477 | - |
| TPA | TPA-59081 | 2026-09-20T04:12:06Z | KAREN | Y | PEREZ | 7/3/1955 | null | •••-••-1052 | - | — | 2263 Palm Drive | Nashville | TN | 37250 | N/A | NULL |
| TPA | TPA-60218 | 2026-08-30T01:54:50Z | Sean | — | James | 1978-05-06 | — | •••-••-1254 | — | ·· | 7309 Mountain View Dr | Tucson | AZ | NULL·· | — | — |
| TPA | TPA-62267 | 2026-01-23T08:39:53Z | Jessica | — | Martin | 1/11/1999 | — | null | 6482936808 | ·N/A | 1720 Willow Ct | Nashville | TN | 37242 | GRP-7686 | NULL |
| TPA | TPA-50979 | 2026-03-21T14:05:47Z | Christine | ·R | Andrews | 1951-11-11 | — | null | 559-379-8758 | — | 5495 Willow Ct Apt 33 | Mesa | AZ | 85224 | GRP-6334 | - |
| TPA | TPA-50532 | 2026-08-21T18:39:03Z | STEVEN | — | LEWIS | 1941-11-08 | NULL | •••-••-3959 | 961-469-2590 | — | 5518 Harbor Blvd | FRESNO | ·CA | — | GRP-6119 | NULL·· |
| TPA | TPA-56089 | 2026-07-18T18:53:43Z | Raymond | — | Sullivan | 1998-06-15·· | - | - | +1 844 630 8632 | — | 9095 Bayshore Drive | Orlando | FL | 32810 | GRP-5461 | CORE-HMO |
| TPA | TPA-57139 | 2026-09-07T17:54:37Z | Emily | A | Brown | 1943-12-10 | NULL | •••-••-5215 | NULL | - | NULL | ·NULL | - | NULL | UNKNOWN | MEDICARE-ADV-B |
| TPA | TPA-57499 | 2026-05-24T06:27:14Z | charles | — | porter | 2004-04-09 | N/A | UNKNOWN | — | ···· | 9313 FOREST AVENUE Apt 22 | Sacramento | CA | 95829·· | null | OPTIONS-PPO |
| TPA | TPA-56734 | 2026-09-25T16:36:59Z | TIMOTHY | — | WEBER | ·1954-08-04 | - | •••-••-2457 | NULL·· | — | 3331 MOUNTAIN VIEW DR | Plano | TX·· | 75003 | GRP-5346 | OPTIONS-PPO·· |
| TPA | TPA-55030 | 2026-03-01T06:21:49Z | Olivia | — | Andrews·· | 19391013 | N/A | •••-••-2835 | — | NULL | 1729 Union Street | Charlotte | NC | 28261 | — | — |
| TPA | TPA-59540 | 2026-08-29T19:39:10Z | AUSTIN | — | MARIANA | 19671015 | null | — | — | NULL | 5576 OAK ST | Denver | co | 80282 | — | N/A |
| TPA | TPA-52921 | 2026-09-26T20:11:47Z | Amy | — | Daniels | 2007-04-08 | — | N/A | — | — | 1993 Main Street | San Antonio | ·Texas | ·78293 | ···· | - |
| TPA | TPA-61253 | 2026-05-27T09:05:45Z | joe | — | bradley | 2005-11-16 | null | NULL | — | null | 5348 Apache Boulevard Apt 39 | Denver | CO | — | GRP-6525 | - |
| TPA | TPA-60571 | 2026-02-08T13:59:05Z | Kenneth | — | Piarce | Mar 28, 1955 | UHC-87501-90 | •••-••-1772 | +1 952 287 9290 | null | 3947 HARBOR BOULEVARD | Dallas | TX | ·75216-6811 | GRP-4912·· | NAVIGATE-HMO |
| TPA | TPA-59335 | 2026-03-06T09:40:47Z | Carlosn, Randy | — | — | 1948-01-28 | N/A | •••-••-8110 | 311-460-0537 | ···· | 9624 BASELINE RD | DALLAS | Texas·· | 75207 | NULL·· | MEDICARE-ADV-B |
| TPA | TPA-57654 | 2026-05-16T08:23:34Z | Judy | — | Pierce | 02/15/91 | ·UHC-76830-07 | — | — | — | 2875 Maple Avenue Apt 8 | SAN ANTONIO | tx | ·78239 | GRP-1592 | OPTIONS-PPO |
| TPA | TPA-53310 | 2026-01-21T14:01:41Z | abby | — | ·kelley | 1987-10-27 | ···· | UNKNOWN | — | — | 3540 HARBOR BOULEVARD | Seattle·· | WA | ·98172 | UNKNOWN | NULL |
| TPA | TPA-58457 | 2026-03-05T00:07:32Z | DREW | — | MARQUEZ | 1997-07-22 | UHC-66250-40 | N/A | 16105242161 | N/A | 6343 WILLOW COURT | Orlando·· | FL | 32838 | NULL | ·- |
| TPA | TPA-58945 | 2026-01-21T07:42:48Z | Helen | ·D. | Wright | 04/24/1968 | null | — | 623-877-5433 | — | NULL | — | — | - | — | — |
| TPA | TPA-63194 | 2026-04-14T10:39:16Z | Gloria | — | Jones | 1962-03-25 | — | N/A | 19573969615 | UNKNOWN | 304 Oak St | Scottsdale | AZ | 85277 | GRP-4882 | MEDICARE-ADV-A |
| TPA | TPA-60925 | 2026-08-30T12:20:27Z | Keith | — | Sliva | Feb 11, 1987 | — | •••-••-4439 | 959-660-5010 | keith.silva@hotmail.com | 3056 Jefferson Avenue | Las Vegas | NV | 89160 | N/A | MEDICARE-ADV-B |
| TPA | TPA-53615 | 2026-08-08T06:21:14Z | Nicholas | — | Williamson | Jul 6, 1986 | - | •••-••-8379 | NULL | null | 4949 Canyon Road | Minneapolis | MN | 55472 | - | NULL |
| TPA | TPA-50190 | 2026-03-29T11:02:02Z | JOE·· | V | FERGUSON | 1963-11-02 | N/A | ···· | 12183520876 | N/A | 4324 JEFFERSON AVENUE | Charlotte | NC | 28225 | N/A | — |
| TPA | TPA-56634 | 2026-08-17T15:50:42Z | Albert | — | Hall | 1981-10-24·· | — | •••-••-9660 | ·N/A | ·· | 8750 Central Avenue | Tampa | FL | 33654 | GRP-9430 | — |
| TPA | TPA-62116 | 2026-01-21T14:28:00Z | Meendoza, Diane | — | — | 1967-08-13 | - | N/A | — | null | ·3454 Bayshore Dr | Mesa | AZ | 85216 | — | UNKNOWN |
| TPA | TPA-62196 | 2026-02-05T20:04:21Z | NATHAN | — | WONG | 2001-08-11 | null | - | UNKNOWN | nathan.wong97@proton.me | ·7166 Sage Court | PHOENIX | AZ | 85084 | N/A | CORE-HMO |
| TPA | TPA-51382 | 2026-07-20T16:25:22Z | ·Davis, Maria | B | — | 1996-12-03 | UNKNOWN | - | - | - | 8013 Union St | Miami | FL | 33132 | N/A | null·· |
| TPA | TPA-60175 | 2026-05-08T08:01:18Z | RANDY | — | WASHINGTON | 1980-02-03 | - | — | 3637071896 | — | 1243 MAPLE AVE | Seattle | WA | 98115 | - | — |
| TPA | TPA-56098 | 2026-02-11T11:31:05Z | Juan | — | Welch | 05-01-1959 | null | •••-••-0492 | +1 347 820 1851 | ···· | 4917 Park Place·· | San Antonio | TX | 78227 | NULL | NULL |
| TPA | TPA-59181 | 2026-06-16T10:32:03Z | Beth | — | Schultz | 1967-12-24·· | ·null | •••-••-3184 | — | — | 9384 PINE DR | Fresno | CA | 93758-0328 | N/A | CORE-HMO |
| TPA | TPA-51732 | 2026-05-17T10:16:14Z | Ramos, Brenda | — | — | 01/12/79 | UNKNOWN | •••-••-1786 | UNKNOWN | — | 4632 Spring Street | Tampa | FL | 33659 | GRP-5001 | null |
| TPA | TPA-60796 | 2026-05-26T18:02:54Z | Ramirez | — | Ryan | 1940-06-16 | — | N/A | - | null | 2106 Cedar Ln | Sacramento | ca | 95845 | — | NULL |
| TPA | TPA-60155 | 2026-01-20T10:52:57Z | Raymond·· | G | Collins | 26-03-1971 | UNKNOWN | — | 353.490.1244 | - | 6254 FOREST AVE | ·Seattle | WA | 98140 | 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:43.425Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty