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-57127 | 2026-02-04T11:02:59Z | Christina | — | Rodriguez | 05/15/1942 | — | UNKNOWN | - | ·· | 6388 Cedar Lane | AUSTIN | TX | 78770 | — | null |
| TPA | TPA-51032 | 2026-09-22T04:38:26Z | Bobby | ·· | Park | 2/20/1979·· | N/A | UNKNOWN | NULL | bobby.park@hotmail.com·· | 3122 PARK PLACE | Nashville·· | TN | 37230 | NULL | - |
| TPA | TPA-56006 | 2026-06-26T04:51:49Z | Simmons, Betty | — | — | 1972-11-14 | null | NULL | - | - | 797 Maple Ave | San Diego | CA | ·92170 | N/A | CORE-HMO |
| TPA | TPA-54071 | 2026-04-29T17:59:04Z | Waine | — | Bryant | 12/15/58 | UHC-65701-10 | •••-••-2074 | — | — | 7704 Jefferson Ave | EDEN PRAIRIE | MN | 55341-9842 | — | — |
| TPA | TPA-59058 | 2026-07-01T11:48:39Z | Ann | — | Jones | ·1966-09-24 | null | UNKNOWN | — | ·NULL | 6076 Elm St | San Antonio | TX | 78268 | — | UNKNOWN |
| TPA | TPA-63910 | 2026-05-13T18:06:38Z | martha | — | harvey | 1988-01-08 | - | •••-••-3415 | UNKNOWN | UNKNOWN | 6664 Union Street | ·Denver | CO | 80282 | GRP-8917 | MEDICARE-ADV-B |
| TPA | TPA-51765 | 2026-09-15T02:52:18Z | Mary | — | Washington | 2007-02-22 | — | •••-••-7694 | — | — | — | - | null | null | N/A | SELECT-EPO |
| TPA | TPA-54158 | 2026-09-20T07:34:05Z | Brandon·· | — | Jacobs | 1962-07-15 | null | null | +1 732 939 2553 | — | 6182 Lincoln Way | Houston | TX | ·· | N/A | - |
| TPA | TPA-60570 | 2026-01-04T17:10:45Z | Diane | — | Hoffman | 1958-05-26 | — | •••-••-5863 | (837) 549-8609 | — | N/A | UNKNOWN | - | — | GRP-3202 | UNKNOWN |
| TPA | TPA-57105 | 2026-04-20T22:42:15Z | ALAN | ···· | MALDONADO | 1940-09-18 | null | NULL | +1 964 864 0740 | alan.maldonado32@proton.me | 3947 Willow Ct | FRESNO | California | 93760 | null | N/A |
| TPA | TPA-63238 | 2026-01-24T01:29:49Z | MARTHA·· | — | ·HUNTER | 19600525 | null | •••-••-9993 | +1 202 705 2652 | — | 5179 Ridge Rd | Nashville | TN | 37216 | null | N/A·· |
| TPA | TPA-51665 | 2026-08-01T07:56:18Z | Cheryl | Q | Contreras | 1986-08-24 | NULL | — | 678-340-4244 | — | 9492 River Road | Houston·· | TX | 77096 | ·GRP-8890 | N/A |
| TPA | TPA-59615 | 2026-08-17T16:06:47Z | ·Carroll, Julie | — | — | 1953-12-25 | N/A | — | — | — | NULL | UNKNOWN | UNKNOWN | UNKNOWN | UNKNOWN | — |
| TPA | TPA-62843 | 2026-05-13T19:40:29Z | FRNAK | — | SANCHEZ | 06/22/93 | UNKNOWN | UNKNOWN | ·null | frank.sanchez@outlook.com | 3489 RIDGE RD | MIAMI | FL | 33153 | GRP-9934 | NAVIGATE-HMO |
| TPA | TPA-59779 | 2026-04-25T13:21:06Z | Luis | — | Tucker | 1953-09-13·· | UHC-25918-17 | null·· | 13153556975 | NULL | 4409 HILLCREST ROAD | Atlanta | GA | 30307 | GRP-6928 | — |
| TPA | TPA-51733 | 2026-04-23T13:00:29Z | ALBERT | — | SANDERS | 1943-07-28 | ·UHC-97542-95 | — | null | NULL | - | — | — | - | — | N/A |
| TPA | TPA-63667 | 2026-06-03T12:16:04Z | Justin | — | Le·· | 1977-05-22 | NULL | •••-••-2246 | null | null | 1662 Market St | Phoenix·· | AZ | - | — | NAVIGATE-HMO |
| TPA | TPA-55066 | 2026-03-26T02:25:55Z | RUTH | ···· | HICKS | ·1985-02-22 | NULL | UNKNOWN | 3646543765 | ruth.hicks12@aol.com | 5034 Grand Ave | Houston | TX | ·77090 | null | null |
| TPA | TPA-53357 | 2026-09-06T00:51:55Z | MARIANA | — | MARQUEZ | 1973-05-24 | - | null | 280.228.6308 | - | — | — | ·NULL | ·· | null | — |
| TPA | TPA-50565 | 2026-07-27T00:10:04Z | GRACE | — | ALVARADO | ·1945-12-20 | N/A | UNKNOWN | ···· | NULL | 806 DESERT SKY BOULEVARD | Atlanta·· | GA | 30330 | — | NULL |
| TPA | TPA-50603 | 2026-09-23T08:47:00Z | Edward | — | Perez | 1969-07-23 | null | - | null | N/A | NULL | ···· | — | NULL | — | — |
| TPA | TPA-55144 | 2026-02-26T00:04:28Z | martha | J | ramirez | 05/05/1997 | null | -·· | UNKNOWN | ·NULL | 9690 VALLEY VIEW DRIVE | Los Angeles | CA·· | ·90091 | UNKNOWN | UNKNOWN |
| TPA | TPA-54649 | 2026-03-01T11:36:15Z | ANA | X | JAMES·· | 1952-02-17 | UHC-70297-58 | - | 843-905-8580 | - | 1093 JEFFERSON AVENUE·· | ·PLANO | TX | 75077 | — | null |
| TPA | TPA-63556 | 2026-05-13T16:55:20Z | SARAH | — | EVANS | 2005-06-24 | N/A | - | N/A | null | ·834 CEDAR LN | EDEN PRAIRIE | MN | 55356 | - | - |
| TPA | TPA-63405 | 2026-10-11T21:45:30Z | Karen | — | ·Mitchell | 09/02/1949 | ·UNKNOWN | •••-••-6393 | — | NULL | 5453 SPRING ST #400 | Los Angeles | CA | 90075·· | — | — |
| TPA | TPA-55989 | 2026-07-14T00:27:02Z | Day, Hannah | — | — | 1991-08-23 | — | UNKNOWN | N/A | hannah.day@hotmail.com | 914 Indian School Rd | Minneapolis | MN | 55469·· | null | OPTIONS-PPO |
| TPA | TPA-59743 | 2026-04-27T23:33:18Z | SHARON | E. | ROSE | 02/27/2004 | — | •••-••-6916 | null | ·· | - | UNKNOWN | UNKNOWN | UNKNOWN | NULL | - |
| TPA | TPA-63901 | 2026-04-25T02:29:53Z | Emily | — | Dean | ·1938-09-11 | — | •••-••-4015 | N/A | ·· | 45 Oak St | DENVER | CO·· | 80259 | GRP-9978 | — |
| TPA | TPA-63610 | 2026-07-23T23:19:15Z | CHRISTIAN | — | ANDERSON | 1939-07-09 | UHC-03780-58 | — | 9458787180·· | CHRISTIAN.ANDERSON@GMAIL.COM | 2042 Washington Street | Orlando | FL | 32818 | null | CORE-HMO·· |
| TPA | TPA-59509 | 2026-01-08T19:30:08Z | Justin·· | — | Nguyen | 1975-03-19 | N/A | •••-••-6302 | N/A | justin.nguyen63@aol.com | null | UNKNOWN | null | NULL | - | NAVIGATE-HMO |
| TPA | TPA-53953 | 2026-05-28T17:43:43Z | MARIA·· | — | HANSEN | 1939-04-07 | — | •••-••-5524 | NULL | NULL | 1426 Washington St | Seattle | WA | 98139-1098 | GRP-9385 | SELECT-EPO |
| TPA | TPA-57759 | 2026-03-24T03:53:31Z | EMMA | — | REID | 11-07-1993 | — | — | UNKNOWN | ···· | 5948 Palm Dr | Mesa | AZ | 85238 | UNKNOWN | CORE-HMO |
| TPA | TPA-60448 | 2026-10-04T08:16:30Z | CHARLES | — | WRIGHT | 1994-03-21 | - | — | — | — | 3137 Camelback Rd | ·Atlanta | GA | ·30339 | GRP-3057 | N/A |
| TPA | TPA-51460 | 2026-04-19T15:16:57Z | Grace | — | Bell | 1995-11-19 | ···· | — | NULL | — | 6185 River Road | San Antonio | TX | 78256 | GRP-9752 | — |
| TPA | TPA-52943 | 2026-03-12T15:40:34Z | Judith | — | Daniels | 1940-03-13 | ·UHC-61314-90 | UNKNOWN | UNKNOWN | UNKNOWN | 862 Sunset Boulevard | PHOENIX | AZ | — | NULL | CHOICE-PLUS-PPO |
| TPA | TPA-56411 | 2026-04-03T14:01:13Z | MARIA | — | FLORES | 02/23/1998 | UHC-15319-51 | NULL | UNKNOWN | maria.flores@icloud.com | 7307 Oak Street | Tempe | AZ | 85237·· | GRP-7374 | — |
| TPA | TPA-53958 | 2026-07-03T05:27:52Z | CATHERINE | — | BUTLER·· | 1956-04-27 | null | N/A | (423) 954-9224 | - | 9460 Meadow Ln | Phoenix | AZ | 85024 | GRP-9046 | null |
| TPA | TPA-58380 | 2026-06-13T12:30:41Z | JOAN | — | SANDERS | 1956-07-08 | — | — | 811.941.5317 | — | null·· | N/A | null·· | NULL | GRP-8903 | SELECT-EPO |
| TPA | TPA-57051 | 2026-09-17T12:07:31Z | KATHRYN | — | PETERSON | 1958-11-23 | NULL·· | — | ·12235735208 | null | 595 Church Street | Charlotte | ·North Carolina | 28234 | GRP-8477 | — |
| TPA | TPA-64058 | 2026-01-16T17:31:07Z | Jackson, Lauren | ·· | — | Apr 4, 2004 | N/A | — | 8903456751 | N/A | 7895 HARBOR BLVD | Houston | TX | -·· | null | null |
| TPA | TPA-62772 | 2026-09-28T08:16:30Z | JANICE | — | ROSE | 21-07-1962 | — | - | N/A | NULL | 4623 Highland Avenue | Chandler | AZ | 85234 | GRP-9181 | — |
| TPA | TPA-56790 | 2026-05-14T10:36:43Z | Barnes, Jack M | — | — | 1979-04-24 | NULL | ···· | (766) 676-9332·· | — | 3185 WASHINGTON ST | Las Vegas | NV | 89125 | UNKNOWN | NAVIGATE-HMO |
| TPA | TPA-52429 | 2026-02-19T02:42:21Z | BRUCE | — | RAMOS | 19840306 | null·· | N/A | 4985571 | N/A | 6296 Main St | Glendale | AZ | 85347 | — | CORE-HMO |
| TPA | TPA-62915 | 2026-04-21T02:21:30Z | MARCUS | — | TURNER | 1939-12-12 | UNKNOWN·· | •••-••-5982 | 7884604973 | NULL | ·8916 Palm Drive | San Antonio | TX | 78257 | NULL | null |
| TPA | TPA-64267 | 2026-01-08T12:40:30Z | Olivia | — | Richards | Jul 12, 1954 | null | - | — | olivia.richards@outlook.com | UNKNOWN | — | null | — | - | UNKNOWN |
| TPA | TPA-60737 | 2026-01-10T21:16:54Z | Lucia | — | Peters | 01-02-1947 | N/A | •••-••-4773 | NULL | UNKNOWN | 8035 Canyon Road | Houston | TX | 77032 | GRP-2515 | - |
| TPA | TPA-52231 | 2026-09-08T04:35:52Z | Valentina | ···· | Alvarado | 1953-06-20 | NULL | UNKNOWN | 4603363 | NULL | — | — | null | UNKNOWN | GRP-1386 | NULL |
| TPA | TPA-63288 | 2026-06-06T04:08:43Z | SCOTT | — | HWOELL | 18-12-1997 | — | •••-••-1005 | N/A | null | 1511 Willow Court | SCOTTSDALE | Arizona | 85241 | null | MEDICARE-ADV-A·· |
| TPA | TPA-50327 | 2026-03-25T08:34:42Z | Gary | — | Arnold | 1996-08-01 | UHC-90858-30 | null·· | — | — | null | null | NULL | UNKNOWN | N/A | null |
| TPA | TPA-51014 | 2026-02-18T01:45:17Z | RYAN | S | BOYD | 1998-11-04 | - | — | UNKNOWN | ryan.boyd62@yahoo.com | 3945 SAGE CT | Mesa | AZ·· | — | GRP-8661 | ···· |
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:43:00.516Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty