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-54491 | 2026-08-03T11:54:49Z | JOSE | — | HAMILTON | 1945-01-19 | UHC-75302-49 | •••-••-5292 | null | — | 2825 Spring Street | JACKSONVILLE | FL | 32287 | NULL | NAVIGATE-HMO |
| TPA | TPA-50170 | 2026-02-07T20:49:37Z | Rogers, Sean·· | — | — | 1972-01-26 | — | — | 2185938625 | NULL | null | — | — | -·· | NULL | — |
| TPA | TPA-54776 | 2026-07-31T19:07:07Z | Ortiz, Joseph | — | — | 11/19/49 | — | null | (832) 424-2760 | N/A | 793 CENTRAL AVE | Mesa | az | 85260 | NULL | — |
| TPA | TPA-64160 | 2026-09-08T05:44:12Z | Isabella | C | Dominguez | 2001-11-14 | UNKNOWN | — | — | — | - | null | null | NULL | - | N/A |
| TPA | TPA-61252 | 2026-07-15T17:29:46Z | grace | — | armstrong | 1959-03-16 | — | •••-••-1984 | ·8696162345 | - | 6118 Sage Ct Apt 26 | Scottsdale | AZ | 85288 | GRP-2464 | MEDICARE-ADV-A |
| TPA | TPA-61390 | 2026-01-01T06:39:31Z | ·Lucia | — | Weaver | 2000-08-24 | NULL | — | - | — | 4920 LAKE VIEW ROAD | Columbus | OH·· | 43296-2528 | GRP-4290 | MEDICARE-ADV-A |
| TPA | TPA-64272 | 2026-10-03T21:49:44Z | Benjamin | — | ·Walker | 1995-12-12 | null | UNKNOWN·· | — | UNKNOWN | 4431 Union Street Apt 10 | Jacksonville | FL | NULL | — | MEDICARE-ADV-A·· |
| TPA | TPA-53332 | 2026-10-08T18:06:14Z | ·WILLIE | — | ROBINSON | 1992-04-01 | N/A | •••-••-8140 | ·(502) 368-9952 | — | 3045 Lake View Road | ·Seattle | Washington | 98185 | GRP-7967 | - |
| TPA | TPA-51719 | 2026-09-16T04:59:18Z | DONALD | — | RILEY | Nov 13, 1946 | UHC-31620-46 | •••-••-0883 | - | null | NULL | N/A | null | UNKNOWN | GRP-6695 | — |
| TPA | TPA-59468 | 2026-07-09T22:43:11Z | Brittany | — | Medina | 11/10/95 | null | •••-••-1353 | +1 380 856 3600 | — | 8502 Baseline Road | Glendale | Arizona | 85311 | GRP-7110 | null·· |
| TPA | TPA-51978 | 2026-09-05T11:17:00Z | John | — | West | 1/22/1938 | — | •••-••-1810 | null | — | 8348 Market St | Austin | TX | 78748 | null | N/A |
| TPA | TPA-53172 | 2026-09-22T23:18:13Z | bruce | — | hart | 04/13/63 | UHC-75859-83 | •••-••-8426 | 804-292-1422 | bruce.hart@aol.com | 8947 Market St | CHANDLER | Arizona | 85288 | null | — |
| TPA | TPA-50959 | 2026-07-24T22:45:08Z | Christina | — | Bradley | 8/26/1958 | UHC-61892-18·· | — | ·NULL | NULL | 934 APACHE BLVD | Plano | TX | 75078 | — | CHOICE-PLUS-PPO |
| TPA | TPA-52819 | 2026-02-21T23:19:47Z | MELISSA | — | CARROLL | 1977-10-15 | - | •••-••-6846 | — | — | 8073 SUNSET BLVD | Sacramento | CA | 95805 | — | null |
| TPA | TPA-63815 | 2026-02-09T12:44:02Z | DOROTHY | — | ·LOPEZ | Jan 2, 1994 | N/A | UNKNOWN | ···· | -·· | 2090 OCEAN AVENUE·· | TAMPA | Florida | 33668 | GRP-7380 | CHOICE-PLUS-PPO |
| TPA | TPA-59756 | 2026-09-13T00:00:35Z | ·Freeman, Luis | — | — | 1999-10-21 | null | N/A | null | - | 7776 INDIAN SCHOOL ROAD·· | Chandler | AZ | 85293 | UNKNOWN | — |
| TPA | TPA-59495 | 2026-10-09T01:41:51Z | Frank | — | Crapenter | 1999-02-27 | N/A | — | (722) 277-8346 | null | N/A | — | ·- | — | — | — |
| TPA | TPA-62492 | 2026-07-23T02:37:40Z | Lewis, Valentian | — | — | 08/06/1950 | ·- | — | 575-651-2585 | - | null | — | UNKNOWN | UNKNOWN | - | — |
| TPA | TPA-56690 | 2026-07-29T15:49:25Z | MARIA | — | ROODRIGUEZ | 1941-01-04 | — | •••-••-8374 | - | maria.rodriguez@yahoo.com | 773 INDIAN SCHOOL ROAD | Gilbert | AZ | 85235 | GRP-2101 | N/A |
| TPA | TPA-62845 | 2026-02-23T04:33:26Z | maon | F. | porter | 02/15/65 | — | ···· | 909-780-7963 | - | 6442 APACHE BLVD | San Diego | CA | 92148 | GRP-7561 | CORE-HMO |
| TPA | TPA-59156 | 2026-05-17T19:24:07Z | Hansen, Dennis | — | — | 1940-05-06 | — | - | 6584496728 | ·null | ·4410 River Road | Tampa | FL | 33667 | null | ···· |
| TPA | TPA-61437 | 2026-03-18T02:03:57Z | OLIVIA | — | HAWKINS | ·1990-07-13 | ···· | NULL | (825) 772-4439 | null | ·4345 Lincoln Way | MESA | AZ·· | 85233 | GRP-6520 | NAVIGATE-HMO |
| TPA | TPA-54292 | 2026-05-02T06:35:22Z | Jessica | — | Chavez | 2008-08-08 | N/A | N/A | UNKNOWN·· | N/A | 3793 Washington Street | Phoenix | AZ | 85091 | null | — |
| TPA | TPA-54912 | 2026-05-01T10:00:12Z | Brian | — | Reynolds | 1959-05-10 | NULL | — | UNKNOWN | N/A | ·3126 GRAND AVE | Miami | FL | 33132 | GRP-8057 | — |
| TPA | TPA-57578 | 2026-08-13T04:25:11Z | Amber | — | Harvey | Oct 18, 1998 | UHC4557336 | — | 7266256662 | — | 6154 Main St | Dallas | TX | — | GRP-3706 | — |
| TPA | TPA-58220 | 2026-01-15T21:06:32Z | Douglas | — | Day | 1946-08-13 | — | null | (555) 394-7248 | null | — | - | — | — | GRP-0333 | — |
| TPA | TPA-55850 | 2026-09-04T03:27:13Z | FRANK | — | ALEXANDER | 19991226 | UNKNOWN | — | 7945034676 | — | 2263 WASHINGTON ST | Phoenix·· | Arizona | 85022 | - | ···· |
| TPA | TPA-52619 | 2026-06-14T00:48:05Z | ahmed | — | soto | Aug 6, 2008 | - | — | — | ·· | 4075 PARK PLACE | Charlotte | NC | 28294 | ···· | null |
| TPA | TPA-50730 | 2026-08-18T13:14:42Z | HOLMES | — | CHARLOTTE | 1999-05-21 | null | null | 636-877-8825 | - | 4958 Sage Court | Glendale | AZ | 85366 | — | NULL |
| TPA | TPA-59819 | 2026-05-05T09:55:47Z | Albert | H. | Gardner | 1993-09-01 | null | •••-••-6640 | — | — | 232 JEFFERSON AVE | Mesa | AZ | 85299-0656 | GRP-1201 | — |
| TPA | TPA-54662 | 2026-08-05T00:50:53Z | ·Cynthia | — | Ryan | 04/19/48 | — | NULL | 8147336786 | NULL | 1187 Broadway | San Antonio | Texas | 78200 | NULL | NULL |
| TPA | TPA-58508 | 2026-09-10T15:27:28Z | Maria | — | Oliver | 04/02/1982 | NULL | •••-••-1232 | — | MARIA.OLIVER@HOTMAIL.COM | 8314 Willow Court | MIAMI | FL | 33138-9025 | GRP-7651 | - |
| TPA | TPA-50257 | 2026-08-08T04:04:49Z | Janice | — | Kelley | 1960-05-25 | - | •••-••-4854 | — | UNKNOWN | 5743 Pine Dr | Los Angeles | ·California | 90036 | N/A | — |
| TPA | TPA-64307 | 2026-06-10T13:26:17Z | JUSTIN | — | CRUZ | 1944-09-18 | — | •••-••-1016 | 419.677.8148 | ·justin.cruz@icloud.com | 2917 RIDGE RD | SAN ANTONIO | TX·· | 78273·· | GRP-2211 | — |
| TPA | TPA-54074 | 2026-07-28T01:32:02Z | Walter | — | Morrison | 19940623·· | — | — | — | WALTER.MORRISON63@PROTON.ME | 7247 HILLCREST RD | CHARLOTTE | NC | 28210 | GRP-5387 | — |
| TPA | TPA-59701 | 2026-05-08T17:22:22Z | daniel | D | sanchez | 1968-03-01 | - | •••-••-3032 | NULL | N/A | 1280 Mesa Drive | Eden Prairie | ·MN | 55396 | - | — |
| TPA | TPA-59998 | 2026-02-06T20:11:06Z | Mariana | — | Padilla | 16-05-1949 | - | — | NULL | — | 8125 Valley View Dr·· | Los Angeles | CA | 90070·· | - | MEDICARE-ADV-B |
| TPA | TPA-64240 | 2026-05-26T06:47:19Z | Jason | — | Wells | 1979-06-12 | null | N/A | — | ·jason.wells@yahoo.com | 7236 Valley View Drive | ·SAN ANTONIO | TX | 78296 | null | null |
| TPA | TPA-52569 | 2026-07-13T03:38:38Z | JORDAN | — | DUNCAN | 1993-06-11 | — | UNKNOWN | 786-319-0096 | — | 4713 Indian School Rd | HOUSTON | tx | 77066 | GRP-9330 | - |
| TPA | TPA-54486 | 2026-01-05T08:08:22Z | STEVEN | — | ROGERS | 08/23/84 | null·· | — | ·593-466-2378 | — | 5940 Mesa Drive | Minneapolis | MN | ·55434 | — | null |
| TPA | TPA-58369 | 2026-02-27T04:41:24Z | lori | — | kim | 03/11/69 | — | — | N/A | UNKNOWN | 7025 Cedar Lane | ·Plano | TX | 75076 | NULL | CORE-HMO |
| TPA | TPA-63092 | 2026-05-26T09:45:03Z | Anna | — | Olson | Nov 10, 1977 | — | •••-••-0575 | 2172926 | ·null | 4540 Elm Street | Las Vegas·· | NV | 89181·· | — | UNKNOWN·· |
| TPA | TPA-59578 | 2026-05-10T00:49:17Z | tyler | — | shaaw | 2000-01-22 | null | null·· | 5016323481 | N/A | UNKNOWN | N/A | - | UNKNOWN | GRP-8764 | ·· |
| TPA | TPA-51108 | 2026-03-17T23:01:30Z | Albert | — | Myers | 1959-03-01 | null | UNKNOWN | (752) 888-9110 | ·UNKNOWN | — | - | null | - | — | ·· |
| TPA | TPA-51797 | 2026-01-06T12:12:27Z | ALBERT | — | PARK·· | 1990-08-25 | ···· | — | NULL | NULL | 1473 HILLCREST RD | Chandler | AZ | 85212 | — | null |
| TPA | TPA-56445 | 2026-05-15T20:02:50Z | KAYLA | ·· | MENDEZ | 6/14/1963 | UNKNOWN | - | 5608894991 | NULL | 3449 Forest Ave #281 | Plano·· | TX | 75017 | GRP-1683 | UNKNOWN |
| TPA | TPA-53150 | 2026-07-11T01:17:49Z | brandon | — | murphy | 03/05/69 | UHC3599795 | null | - | — | 5643 VALLEY VIEW DRIVE·· | Houston | TX·· | 77069 | GRP-9209 | null |
| TPA | TPA-50449 | 2026-03-07T23:07:53Z | Gloria | — | Moore | 1955-06-15 | NULL | NULL | — | NULL | 3587 Spring Street | SAN DIEGO | CA | 92136 | — | — |
| TPA | TPA-56813 | 2026-09-25T08:01:12Z | Megan | — | Rios | 1976-08-25 | UHC-68589-64 | N/A | 9348243802 | UNKNOWN | 3996 SAGE CT | Denver | CO | 80218 | — | — |
| TPA | TPA-52119 | 2026-03-15T10:13:47Z | Olivia | — | Shaw·· | 2002-09-01 | NULL | •••-••-9356 | N/A | olivia.shaw@outlook.com | ·8294 Sage Court | Phoenix | AZ | 85073 | — | OPTIONS-PPO |
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:56.122Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty