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-63662 | 2026-01-23T14:39:33Z | JEAN | — | SCOTT | 20080728 | - | UNKNOWN | — | ·· | — | ·NULL | — | N/A·· | ···· | null |
| TPA | TPA-59172 | 2026-07-15T04:18:45Z | Kenneth | — | ·Gonzales | 1994-09-09 | UHC-22366-98 | — | null | null | 2617 Cedar Ln | CHANDLER | AZ·· | 85216 | GRP-0630 | — |
| TPA | TPA-60742 | 2026-02-13T06:33:09Z | Nick | — | Keley | 1975-12-01 | UNKNOWN | N/A | ·UNKNOWN | UNKNOWN | 6841 MAIN STREET #458 | Atlanta | GA | 30341 | - | NAVIGATE-HMO |
| TPA | TPA-53378 | 2026-02-05T01:15:14Z | Mary | M | Weaver | 1981-06-07 | UNKNOWN | — | 2983848412 | MARY.WEAVER44@OUTLOOK.COM | 5061 MAPLE AVENUE | San Antonio | TX | 78281 | GRP-8756 | OPTIONS-PPO |
| TPA | TPA-52064 | 2026-03-03T20:58:00Z | Karen | — | Walker | 19-08-1965 | null | null | N/A | karen.walker41@aol.com | 8920 GRAND AVE | Denver | CO | 80288 | — | — |
| TPA | TPA-59923 | 2026-02-19T22:34:25Z | CARLOS | — | PEREZ | 1980-01-24 | N/A | N/A | — | - | 8065 Washington St | Chandler | AZ | null | — | null |
| TPA | TPA-60952 | 2026-04-14T22:36:08Z | Elizabeth | — | Meyre | 9161-06-14 | — | null | ·N/A | - | UNKNOWN | — | — | — | GRP-0226 | NAVIGATE-HMO |
| TPA | TPA-61760 | 2026-07-15T07:07:32Z | Charlotte | — | Rogers | 1996-03-20 | NULL | NULL | NULL | — | 7069 Cedar Lane | Houston | tx | ·UNKNOWN | GRP-8405 | null |
| TPA | TPA-63992 | 2026-08-17T05:24:53Z | Anna | — | Rice | ·1938-09-07 | null | null | NULL | ANNA.RICE@GMAIL.COM | 7568 Elm St | Mesa | AZ | 85203 | GRP-7931 | MEDICARE-ADV-A |
| TPA | TPA-60061 | 2026-06-11T01:22:13Z | Hall, Amanda | — | — | 1938-02-04·· | N/A | null | - | AMANDA.HALL41@GMAIL.COM | 4950 WILLOW CT | AUSTIN | ·TX | ·78702 | - | N/A |
| TPA | TPA-51851 | 2026-01-27T22:25:44Z | Jeremy | — | Garrett | 1978-01-24 | — | — | UNKNOWN | jeremy.garrett@aol.com | ·2339 Park Place | San Diego | CA | 92181 | UNKNOWN | UNKNOWN·· |
| TPA | TPA-63024 | 2026-07-23T16:29:53Z | Hannah | — | Sanchez | 1969-05-08 | NULL | — | N/A | — | 3510 Camelback Rd | ·Los Angeles | CA | 90086 | — | NULL |
| TPA | TPA-51272 | 2026-06-14T13:36:37Z | Sanders, Jacqueline | — | — | Nov 23, 1964 | — | — | — | — | 6642 Ridge Road #191 | Gilbert | Arizona | ·85267-5491 | - | NULL |
| TPA | TPA-51447 | 2026-01-24T14:11:17Z | Jean | — | Kelly | 2003-11-20 | - | UNKNOWN | (589) 343-7985·· | jean.kelly@icloud.com | 521 Broadway | Gilbert | AZ | — | ·GRP-6155 | MEDICARE-ADV-B·· |
| TPA | TPA-64345 | 2026-07-31T07:00:59Z | janet | — | hernandez | 1973-05-06 | N/A | null | NULL | NULL | - | UNKNOWN | — | — | GRP-2329 | - |
| TPA | TPA-50235 | 2026-04-25T05:05:48Z | Carl | — | Jacobs | ·1989-03-02 | - | NULL | null | — | UNKNOWN | N/A | - | null | GRP-1967 | - |
| TPA | TPA-59018 | 2026-04-23T20:45:22Z | bruuce | — | perkins | 1973-10-17 | UHC-27600-51 | ·UNKNOWN | — | BRUCE.PERKINS@HOTMAIL.COM | 8366 Lake View Rd | LOS ANGELES | California | 90048 | ·GRP-7908 | — |
| TPA | TPA-54509 | 2026-04-03T04:15:38Z | WEI·· | ·· | BERRY | 09/09/1983 | - | •••-••-4895 | - | N/A | 1615 INDIAN SCHOOL RD | EDEN PRAIRIE | MN | 55342-8893 | — | — |
| TPA | TPA-54166 | 2026-06-09T04:32:04Z | MARILYN | — | TUCKER | 2002-02-22 | null·· | UNKNOWN | UNKNOWN | null | 9692 APACHE BOULEVARD | Tempe | AZ | 85221 | NULL | — |
| TPA | TPA-63265 | 2026-01-14T14:47:22Z | SOPHIA | — | ·LONG | 1941-02-07 | - | - | N/A | sophia.long38@yahoo.com | 4154 Mesa Drive | Eden Prairie | MN | 55324 | UNKNOWN | — |
| TPA | TPA-63372 | 2026-09-23T14:52:37Z | Jeffrey·· | A | George | 26-06-1955 | — | null | (782) 457-3599 | NULL | 5231 Apache Blvd | AUSTIN | TX | 78724-3359 | GRP-1348 | ···· |
| TPA | TPA-56746 | 2026-07-26T13:05:31Z | Dominguez, George | — | — | 04/12/01 | NULL | - | — | UNKNOWN | 974 Sage Court | Seattle | WA | 98194 | N/A | - |
| TPA | TPA-58233 | 2026-03-28T18:14:10Z | GARY | — | TAYLOR | 05/21/50 | — | •••-••-7771 | 9676200728 | N/A | 6786 MAIN ST | PHOENIX | AZ | 85016 | GRP-5164 | MEDICARE-ADV-B |
| TPA | TPA-51636 | 2026-08-09T03:06:23Z | Ashley | ···· | Larson | 1970-12-10 | N/A | •••-••-4295 | — | null | 9382 Jefferson Avenue | Dallas·· | tx | 75279 | - | null |
| TPA | TPA-58013 | 2026-01-07T06:48:57Z | Willis, Lori | Z | — | 2008-09-22 | null | — | (257) 378-1870 | UNKNOWN | 1029 PINE DRIVE | ·Columbus | OH | 43249-4234·· | - | NULL |
| TPA | TPA-58270 | 2026-04-21T18:16:16Z | Martha | R. | Bennett | Mar 18, 1948 | null | N/A | 9561170 | NULL | NULL | N/A | null | — | N/A | N/A |
| TPA | TPA-56622 | 2026-04-08T00:51:05Z | JOSEPH | ·· | DEAN | 07/20/1992 | null | N/A | 12773097253 | ·UNKNOWN | 5930 River Rd #746 | Houston | TX | 77059 | GRP-8245 | N/A |
| TPA | TPA-61897 | 2026-07-05T16:45:53Z | MASON | — | FULLER | 2007-01-11 | — | N/A | 18222418222 | - | 6548 WASHINGTON ST #485 | Austin | TX | 78700 | NULL | CHOICE-PLUS-PPO |
| TPA | TPA-54216 | 2026-06-12T21:51:03Z | ·Danielle | — | Torrees | — | UHC-36695-30 | •••-••-0215 | (855) 832-4572 | N/A | NULL | NULL | null | null | UNKNOWN | choice-plus-ppo |
| TPA | TPA-54469 | 2026-05-05T03:30:15Z | Kevin | — | Wilson | 19950915 | — | NULL | 783.570.2670 | — | 2944 VALLEY VIEW DRIVE | Minneapolis | MN | 55410 | GRP-0748 | - |
| TPA | TPA-51331 | 2026-08-21T13:52:32Z | Doris | — | Weber | 1959-08-24 | UHC8632571 | null | ···· | DORIS.WEBER@AOL.COM | 851 MOUNTAIN VIEW DRIVE | Chandler | AZ | 85236 | UNKNOWN | N/A |
| TPA | TPA-61228 | 2026-02-10T02:52:41Z | ERIIC | — | WANG | 1975-11-25 | UNKNOWN | •••-••-3614 | (567) 563-0413 | ···· | 9887 Mountain View Drive | Austin | TX | 78797 | ·· | — |
| TPA | TPA-55637 | 2026-01-12T20:07:36Z | SCOTT | — | DAVIS | 5/22/1967 | — | •••-••-3717 | — | UNKNOWN | 1816 Ocean Ave | Orlando | FL | 32863 | UNKNOWN | N/A |
| TPA | TPA-59828 | 2026-01-06T05:15:58Z | Douglas | — | Meyer | Apr 10, 1959 | — | •••-••-4681 | 9713337835 | UNKNOWN | N/A | null | - | - | NULL | NULL |
| TPA | TPA-53818 | 2026-01-24T07:22:28Z | Vincent | — | Gordon | 1/3/1973 | null | null | 255-816-9267 | VINCENT.GORDON@OUTLOOK.COM | 1710 Central Ave | Miami | FL | N/A·· | NULL | MEDICARE-ADV-B |
| TPA | TPA-52504 | 2026-09-23T14:06:41Z | Helen | V | Lynch | 19400419 | UNKNOWN | N/A | 792-792-7574 | NULL | 465 HIGHLAND AVENUE | Fresno | CA·· | 93721 | null | SELECT-EPO |
| TPA | TPA-63006 | 2026-04-05T14:57:13Z | Dylan | — | Russell | 20-01-1950 | null | •••-••-2934 | N/A | NULL | 875 Camelback Rd | Fresno | CA | 93795 | GRP-6337·· | CORE-HMO |
| TPA | TPA-52689 | 2026-10-03T14:10:33Z | Debra | — | Collins | 1980-11-19 | null | N/A | UNKNOWN | debra.collins@yahoo.com | 6116 Market St | Sacramento | California | 95866 | GRP-9288 | NAVIGATE-HMO |
| TPA | TPA-59835 | 2026-03-28T13:54:57Z | SARAH | U | KELLEY | 1946-09-03 | null | N/A | — | - | 9831 Mountain View Dr | Orlando | FL | UNKNOWN | null | - |
| TPA | TPA-61135 | 2026-10-10T23:01:13Z | Craol | — | Weber | 1988-09-28 | — | •••-••-5702 | null | — | 21 Indian School Rd | Columbus | OH | 43229 | UNKNOWN | N/A·· |
| TPA | TPA-60164 | 2026-09-08T18:48:43Z | HENRY | — | WEAVER·· | 2006-03-11 | N/A | NULL | — | null | — | NULL | null | N/A·· | GRP-1263 | null |
| TPA | TPA-57469 | 2026-06-02T12:46:24Z | willie | — | harper·· | 2000-09-13 | UNKNOWN | NULL | ·434-850-5661 | - | 750 Central Ave | Gilbert | AZ | 85211 | null | MEDICARE-ADV-B |
| TPA | TPA-55091 | 2026-09-08T15:50:43Z | Crawford, Elizabeth | — | — | 2002-07-18 | — | NULL | 611.353.1127·· | — | — | ···· | — | — | null | - |
| TPA | TPA-59796 | 2026-01-21T11:33:08Z | MARTHA | — | DUNCAN | ·1975-04-24 | - | N/A | ·- | — | 7161 Hillcrest Rd | San Diego | CA | 92135 | — | — |
| TPA | TPA-63539 | 2026-06-28T19:27:36Z | Lori | — | Lason | 11-03-1983 | null | •••-••-8830 | +1 517 372 4329 | - | 1146 Oak St Apt 4 | Houston | TX | ·77031 | GRP-5923·· | null |
| TPA | TPA-60848 | 2026-07-13T08:18:57Z | Marilyn | — | Weaver | 1948-10-26 | NULL | — | — | UNKNOWN | - | null | — | - | ·GRP-9649 | ·· |
| TPA | TPA-53899 | 2026-02-15T02:59:41Z | Paul | — | Stevens | 1973-01-21 | — | •••-••-4607 | NULL | — | 9296 Harbor Blvd | Plano | TX | 75098 | — | ·· |
| TPA | TPA-51326 | 2026-01-13T23:46:00Z | DENISE | — | BENNETT | ·18-06-2003 | N/A | NULL | — | NULL | 3143 MOUNTAIN VIEW DR | Denver | CO | 80286 | NULL | -·· |
| TPA | TPA-52715 | 2026-01-02T18:21:03Z | Judith | — | Dunn | 1969-02-18·· | NULL | N/A | (425) 719-8931 | ·· | 3345 Meadow Lane | Atlanta | ·GA | — | GRP-5103 | NULL |
| TPA | TPA-52359 | 2026-06-05T16:01:25Z | ·Cunningham, Wayne | — | — | ·05/12/1948 | UNKNOWN | N/A | (716) 419-8484 | — | ·6837 Cedar Ln | San Antonio | TX | ·78261 | GRP-0739 | CORE-HMO |
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:53.720Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty