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-57911 | 2026-09-14T07:35:33Z | WEI | — | YOUNG | 7/19/1952·· | ·N/A | — | null | UNKNOWN | 3533 Church St | Minneapolis | MN | 55487 | null | MEDICARE-ADV-A |
| TPA | TPA-56043 | 2026-08-19T01:32:37Z | Aisha | — | Braadley | 1972-12-24 | N/A | •••-••-5700 | UNKNOWN | N/A | 8630 River Rd #701 | DENVER | CO | 80211 | — | N/A |
| TPA | TPA-62018 | 2026-06-19T03:15:46Z | ·Randy | — | Owens | 2005-12-13 | UHC-66110-46 | •••-••-4128 | 9163843627 | null | 5875 Church St | Fresno | CA | 93795 | — | NAVIGATE-HMO |
| TPA | TPA-53490 | 2026-01-30T04:37:55Z | Donald | — | Aguilar | 7/15/1950 | UHC-95936-49 | — | ·N/A | UNKNOWN | 3963 Mesa Dr | Austin | TX | 78726 | null | NULL |
| TPA | TPA-50870 | 2026-06-02T15:22:38Z | ruth | M | murray | 1938-05-13 | UHC-90896-58 | •••-••-9738 | 289-311-6770 | — | 1962 LAKE VIEW ROAD Apt 5 | DALLAS | TX | 75259 | GRP-5012 | UNKNOWN |
| TPA | TPA-50880 | 2026-05-01T17:24:29Z | Alexander | — | ·Carlson | 06/07/1940 | — | null | — | - | 5227 Ridge Rd Apt 19 | Fresno | CA | 93742 | N/A | SELECT-EPO |
| TPA | TPA-55856 | 2026-02-03T02:24:12Z | lisa | — | chapman·· | 1946-10-13 | - | N/A | N/A | — | 9436 Ocean Avenue | DALLAS | TX | 75214 | N/A | NULL |
| TPA | TPA-54323 | 2026-03-20T15:20:59Z | Laura | — | Harrison | 1977-08-02 | UNKNOWN | UNKNOWN | (546) 233-8471 | — | ·8033 Apache Boulevard #384 | AUSTIN | TX | 78772 | NULL | — |
| TPA | TPA-63906 | 2026-06-29T12:24:46Z | James | — | Le | 20-02-1952 | null | — | — | N/A | 6689 Main Street | Tucson | Arizona | 85758 | N/A·· | SELECT-EPO |
| TPA | TPA-56513 | 2026-07-21T02:26:18Z | Pamela | — | Butler | 1995-11-10 | null | N/A | ·9757403631 | N/A | — | — | - | — | GRP-4497 | — |
| TPA | TPA-60732 | 2026-01-05T12:13:20Z | GLORIA | — | HOWARD | Mar 22, 1996 | — | NULL | - | - | NULL | - | ·· | UNKNOWN | — | NULL |
| TPA | TPA-53835 | 2026-05-14T00:21:02Z | Gerald | — | Rose | 08/05/1982 | NULL | •••-••-7827 | N/A | null | 7637 FOREST AVENUE | Mesa | AZ | 85283 | — | — |
| TPA | TPA-62180 | 2026-04-03T01:26:44Z | JOSHUA·· | — | GIBSON | 19871105 | UHC-80149-44 | null | — | N/A | 4752 Washington Street | Tempe | az | 85232 | N/A | null |
| TPA | TPA-56408 | 2026-08-06T16:08:07Z | Michael | — | Young | 1954-12-19 | null | •••-••-9867 | 16003447974 | — | 2952 Palm Dr | Mesa | AZ | 85236 | ·NULL | null |
| TPA | TPA-50348 | 2026-09-23T14:55:44Z | Noah | ·· | Montgomery | 1994-06-17 | NULL·· | •••-••-0903 | 398-305-6218 | ·noah.montgomery@proton.me | 6546 Elm Street | Glendale | AZ | 85380 | ·· | NULL |
| TPA | TPA-64372 | 2026-08-15T11:37:48Z | Charlotte | — | Ross | 10/21/2004 | ·· | null | 9856596 | CHARLOTTE.ROSS36@AOL.COM | 3803 Willow Court | Houston | TX | 77017 | GRP-0539 | NAVIGATE-HMO |
| TPA | TPA-58884 | 2026-08-19T19:12:03Z | WEI | — | GRIFFIN | 1983-07-13 | - | NULL | NULL | - | UNKNOWN | — | — | null | — | N/A·· |
| TPA | TPA-55555 | 2026-10-14T15:54:47Z | ANDREA | T | ·SANDERS | 1976-03-15 | ·NULL | — | (875) 661-3660 | andrea.sanders@gmail.com | 6103 Market St·· | Columbus | ·OH | 43248 | - | — |
| TPA | TPA-62135 | 2026-02-05T15:32:58Z | LISA | — | EVANS | 1994-05-23 | UHC-03457-44 | — | 16116961911 | ···· | 3982 Willow Ct | Los Angeles | CA | 90056 | GRP-2401 | UNKNOWN |
| TPA | TPA-59383 | 2026-03-06T21:27:42Z | CAMILA | — | JACKSON | 05/15/61 | ·UHC-96379-79 | NULL | null | UNKNOWN | — | — | ·UNKNOWN | — | — | null |
| TPA | TPA-55116 | 2026-04-23T09:30:26Z | Frank | — | Moreno | 07-03-1941 | null | NULL | 8529054 | N/A | 2391 Lincoln Way #874 | Sacramento | CA | 95806 | null | — |
| TPA | TPA-58192 | 2026-01-18T15:09:31Z | Ruth | — | Watson | 1963-01-03 | — | UNKNOWN | (446) 897-4507 | — | ·2307 Sunset Boulevard | Jacksonville | FL | 32283 | — | MEDICARE-ADV-A |
| TPA | TPA-62905 | 2026-10-08T06:03:19Z | ·REED | ···· | MATEO | Jul 21, 1987·· | UHC5686730 | •••-••-8097 | 356-688-5085 | MATEO.REED88@OUTLOOK.COM | 543 FOREST AVENUE | ·Orlando | ·FL | 32804 | — | — |
| TPA | TPA-56691 | 2026-09-02T16:09:13Z | LARRY | — | COLE | 14-05-2003 | UNKNOWN | •••-••-3962 | null | UNKNOWN | 2198 RIVER ROAD | Charlotte | NC | 28220 | GRP-6927 | MEDICARE-ADV-A |
| TPA | TPA-58136 | 2026-05-17T08:30:49Z | Gabriel | F. | Cole | 1988-03-14 | - | NULL | null | — | 2533 Hillcrest Road | ·Eden Prairie | MN | 55350 | GRP-0660 | — |
| TPA | TPA-54238 | 2026-08-03T14:06:15Z | Patricia | ···· | Phillips | 1963-07-20 | N/A | •••-••-5000 | ·· | PATRICIA.PHILLIPS@PROTON.ME | 3971 JEFFERSON AVE | Los Angeles | CA | 90010 | — | NAVIGATE-HMO |
| TPA | TPA-61948 | 2026-07-08T13:58:45Z | Ellis, Angela | — | — | 03-03-1999 | — | •••-••-2227 | — | — | 9680 HILLCREST ROAD | PHOENIX | AZ | 85054 | N/A | N/A |
| TPA | TPA-54306 | 2026-06-14T09:30:50Z | Catherine | — | Harper | 2000-10-15 | NULL | •••-••-4809 | — | NULL | 5487 Ridge Rd | ·Charlotte | NC | 28223 | GRP-7109 | null |
| TPA | TPA-52128 | 2026-02-18T11:39:09Z | Cynthia | — | Allen | Nov 17, 2003 | ···· | null | — | cynthia.allen@gmail.com | — | — | — | - | — | NAVIGATE-HMO |
| TPA | TPA-60922 | 2026-02-25T17:27:40Z | SAMANTHA | S | ADAMS | 1997-01-12 | N/A | •••-••-9238 | 613-471-2450 | — | 6922 SAGE COURT | Fresno | California | ·· | N/A | N/A·· |
| TPA | TPA-55179 | 2026-08-22T04:47:49Z | ·Ashley | — | Perry | 1987-02-07 | - | •••-••-9792 | — | NULL | 3205 Ridge Rd | Atlanta | ga | 30359 | GRP-6462 | OPTIONS-PPO |
| TPA | TPA-51270 | 2026-03-07T02:24:55Z | CARLOS | — | VEGA | 1954-09-24 | ·· | N/A | ·16799189248 | — | 819 Desert Sky Boulevard | Tampa | FL | 33623·· | GRP-7469 | — |
| TPA | TPA-54716 | 2026-07-20T23:17:53Z | ASHLEY | — | HAYES | 1970-03-20 | - | — | NULL | — | 2850 VALLEY VIEW DR | CHANDLER | AZ | 85230 | — | — |
| TPA | TPA-60605 | 2026-06-16T00:41:23Z | KAREN·· | D | JOHNSON | 11/09/84 | — | NULL | N/A | N/A | 5052 Sunset Boulevard | Tampa | FL·· | 33662-7905 | GRP-2387 | — |
| TPA | TPA-52918 | 2026-09-30T03:37:01Z | Bill | ···· | Howard | N/A | — | ·· | — | UNKNOWN | 9694 BAYSHORE DRIVE | Nashville | TN | UNKNOWN | GRP-9925 | null·· |
| TPA | TPA-63650 | 2026-05-21T18:40:46Z | Richard | E. | Roebrtson | — | NULL | •••-••-4973 | NULL | — | null | NULL | NULL | - | ·N/A | — |
| TPA | TPA-50261 | 2026-07-03T15:46:29Z | brandon | — | bryatn | 12/13/80·· | N/A | •••-••-9574 | 19533400231 | brandon.bryant2@proton.me | 2086 Maple Ave·· | Atlanta | GA | ·30342 | -·· | - |
| TPA | TPA-58110 | 2026-02-23T08:26:34Z | LUCIA | — | DIXON | Nov 24, 1993 | NULL | ·· | NULL | — | 7092 Highland Avenue | Dallas | TX | 75291 | UNKNOWN | - |
| TPA | TPA-57546 | 2026-08-05T19:01:13Z | Stephen | — | Martinez | — | — | •••-••-6889 | UNKNOWN | N/A | 6738 Indian School Road | Tampa | FL | 33665 | N/A | MEDICARE-ADV-B |
| TPA | TPA-52575 | 2026-09-12T04:37:22Z | David | — | Lewis | ·Apr 9, 1981 | — | •••-••-7190 | N/A | ···· | 5645 APACHE BOULEVARD | Eden Prairie | MN | 55366 | GRP-8541 | NAVIGATE-HMO |
| TPA | TPA-56658 | 2026-07-31T09:36:41Z | CHARLES·· | — | BURKE | 08-11-1955 | — | null | NULL | charles.burke20@hotmail.com | 5211 Sunset Blvd | ·Atlanta | GA | 30354 | N/A | SELECT-EPO |
| TPA | TPA-53156 | 2026-04-11T16:47:53Z | Espinosa, Theresa | — | — | ·1979-02-20 | - | •••-••-1047 | 387.910.1465 | N/A·· | 8697 Mountain View Drive·· | Orlando | FL | 32873-9667 | GRP-0884 | MEDICARE-ADV-B |
| TPA | TPA-58954 | 2026-08-30T14:26:14Z | AHMD | — | MURRAY·· | 08/15/2003 | null | NULL·· | — | - | 9035 Palm Dr | Dallas | TX | 75286 | UNKNOWN | — |
| TPA | TPA-54855 | 2026-03-21T17:42:01Z | Jessica | — | Evans | 1974-08-13 | NULL | — | N/A | — | 2157 RIVER ROAD | DALLAS | TX | 75242 | ·N/A | - |
| TPA | TPA-58208 | 2026-07-30T10:46:19Z | ·ethan | — | davis | 12/20/1973 | - | N/A | NULL·· | — | 6281 River Road | Eden Prairie | MN | 55344 | GRP-0565 | CHOICE-PLUS-PPO |
| TPA | TPA-62733 | 2026-06-21T03:12:44Z | ASHLEY | — | MYERS | Jul 10, 2001 | ···· | — | 5673906159 | UNKNOWN | 7456 Lake View Rd | ·PLANO | TX | 75015 | null | ···· |
| TPA | TPA-64234 | 2026-06-08T01:42:35Z | Victoria | — | Dunn | 2001-10-11 | UNKNOWN | — | ·(372) 765-6233 | — | 8891 Canyon Road | Tampa | FL | 33620 | NULL | — |
| TPA | TPA-62485 | 2026-05-28T09:00:20Z | MARK | Y. | HICKS | 4/12/1991·· | — | — | UNKNOWN | — | 2633 Hillcrest Road | Austin·· | TX | 78718-1502 | GRP-9282 | OPTIONS-PPO |
| TPA | TPA-61632 | 2026-05-26T23:42:09Z | Brandon | — | White | 1957-08-23 | — | null | 15598901807·· | UNKNOWN | 1017 Broadway | Minneapolis | MN | 55457 | - | UNKNOWN |
| TPA | TPA-51816 | 2026-07-07T04:35:42Z | Elijah | M | ·Delgado | 4/20/1982 | UNKNOWN | — | 264.500.3478 | null | — | - | NULL | ·null | null | -·· |
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.122Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty