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
Provider network only, ordered by line number
| Source | Record | Received | First | Middle | Last | DOB | Member ID | SSN | Phone | Address | City | State | ZIP | Group | Plan | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PRV | PRV-21317 | 2026-03-24T17:00:44Z | amber | — | mejia | 1953-02-17 | UHC-13136-66 | — | null | — | ·5149 Mesa Drive Apt 11 | Gilbert | AZ | — | — | - |
| PRV | PRV-20829 | 2026-01-13T14:10:49Z | BEN | — | GREENE | 1994-06-08 | NULL | •••-••-6427 | 583-692-5529 | BENJAMIN.GREENE@AOL.COM | 1364 Oak Street | DALLAS | TX | 75286 | - | null |
| PRV | PRV-23118 | 2026-03-11T05:12:58Z | Ethan | J. | Lopez | 1993-10-04·· | UHC-85031-68 | NULL | 5283224793 | - | 2946 Central Avenue | Austin | TX | 78750 | NULL | MEDICARE-ADV-B |
| PRV | PRV-23632 | 2026-04-28T00:18:11Z | ·Anthony | — | Harrison | ·1983-09-08 | — | •••-••-0821 | 13208394348 | — | 5047 Canyon Rd | LAS VEGAS | nv | 89172·· | — | — |
| PRV | PRV-25428 | 2026-07-02T06:20:13Z | Teressa | — | Yang | 2006-01-17 | UNKNOWN | null | UNKNOWN | TERESA.YANG@ICLOUD.COM | 3126 Bayshore Drive | NASHVILLE | Tennessee | 37242 | UNKNOWN | UNKNOWN |
| PRV | PRV-21445 | 2026-07-22T16:42:11Z | Samuel | K.·· | Cruz | 01/09/82 | N/A | UNKNOWN | (848) 726-7946 | ·samuel.cruz21@gmail.com | UNKNOWN | — | null | N/A·· | — | — |
| PRV | PRV-22395 | 2026-08-13T05:11:44Z | Andrea | — | Coleman | 1998-03-17 | — | •••-••-6518 | 5059686150 | - | 7471 Washington St | ·Tempe | AZ | 85232 | N/A | - |
| PRV | PRV-24773 | 2026-01-22T20:50:31Z | ELIJAH·· | — | PRICE | 1986-12-26 | UHC5010232 | null | 232-315-9074 | UNKNOWN | 3333 Palm Dr | PHOENIX | AZ | — | - | N/A·· |
| PRV | PRV-25544 | 2026-04-19T18:30:27Z | BRYAN | Z. | BLACK | 1971-12-12 | ·UHC-91280-66 | - | 317-792-5074 | BRYAN.BLACK22@ICLOUD.COM | 6915 Lake View Rd | Atlanta | GA | 30392 | — | NAVIGATE-HMO |
| PRV | PRV-25090 | 2026-02-01T06:38:07Z | Eugene | — | Parker | 06/25/88 | null·· | — | 17575722235 | — | 2035 Ocean Ave | Minneapolis | MN | 55413 | null | NAVIGATE-HMO |
| PRV | PRV-22100 | 2026-03-11T10:51:18Z | Bradley | H | Weaver | 1986-04-15 | — | •••-••-6204 | 593.663.3482 | NULL | ···· | — | NULL | - | null | NULL |
| PRV | PRV-27648 | 2026-04-20T14:49:47Z | Gracce | — | Wong | 1975-10-21 | null | — | — | NULL | 6636 MARKET ST | SACRAMENTO | CA | 95806 | — | — |
| PRV | PRV-22077 | 2026-07-26T23:16:57Z | AUSTIN | — | ·HENDERSON | 1993-03-13 | UHC-20641-02 | — | 468-812-9841 | AUSTIN.HENDERSON@AOL.COM | 4944 Indian School Road Apt 2 | SAN DIEGO | California | 92114 | null·· | null |
| PRV | PRV-23822 | 2026-05-21T09:17:22Z | roy | P | smith | 1945-01-07·· | — | UNKNOWN | 465-377-3812 | ROY.SMITH@HOTMAIL.COM | — | — | ·· | — | ·N/A | — |
| PRV | PRV-25365 | 2026-08-24T10:10:16Z | LAURA | — | BANKS | 1969-10-15 | UHC-77350-19 | ·UNKNOWN | 650-582-3891 | — | — | NULL | NULL | — | — | CHOICE-PLUS-PPO |
| PRV | PRV-28378 | 2026-09-24T07:59:47Z | Jordan | — | Moore | 1991-03-02 | UHC-88341-37 | — | +1 830 250 0727 | JORDAN.MOORE75@ICLOUD.COM | 8323 Union St | Tampa | FL | N/A | ·NULL | — |
| PRV | PRV-22708 | 2026-09-17T13:45:49Z | Hiroshi | ···· | Miller | 1978-09-12 | NULL | •••-••-0228 | 312-918-6501 | — | 8858 Sage Ct | ·Gilbert | AZ | 85263 | - | null |
| PRV | PRV-27995 | 2026-03-21T04:38:59Z | THOMAS | A | REYNOLDS | ·1946-11-28 | UHC-63941-86 | — | ·· | - | 4967 VALLEY VIEW DR | San Antonio | Texas | 78205 | null | MEDICARE-ADV-A |
| PRV | PRV-29369 | 2026-01-26T23:09:36Z | jacqueline | — | mitchell | 1952-08-19 | - | N/A | 9025108443 | ·UNKNOWN | 4556 Grand Ave | Atlanta | GA | 30384 | N/A | — |
| PRV | PRV-20842 | 2026-06-23T02:39:28Z | Maria | — | Snyder·· | 1940-07-24 | N/A | — | NULL | — | 6204 Ocean Avenue Apt 13 | Plano | TX | 75030 | NULL | — |
| PRV | PRV-27344 | 2026-08-28T23:58:27Z | Julia | — | Wright | 5/15/1994 | UHC-22171-70·· | UNKNOWN | 606-845-2677 | NULL | 5217 Main Street | Dallas | TX | 75241 | null | CORE-HMO |
| PRV | PRV-22458 | 2026-03-09T04:07:20Z | Simmons, Abigail | — | — | 04-10-1944 | — | — | 12564847168 | ·· | 5286 Cedar Lane | Eden Prairie | mn | ·55328 | - | NAVIGATE-HMO |
| PRV | PRV-23655 | 2026-03-05T00:25:37Z | KATHY | Q | WRIGHT | 1949-05-25 | UHC-81490-13 | — | 285.237.9084 | - | 4168 OAK ST | Fresno | ca | 93768 | — | — |
| PRV | PRV-21596 | 2026-06-19T22:51:23Z | kevin | — | payne | 1968-05-07 | UHC5346333 | UNKNOWN | (820) 936-2751 | — | 8737 DESERT SKY BOULEVARD | Seattle | WA | 98125 | null·· | N/A |
| PRV | PRV-23633 | 2026-05-09T13:04:47Z | Lane, Kathleen | — | — | 2001-01-26 | — | UNKNOWN | (494) 972-5027 | KATHLEEN.LANE@YAHOO.COM | 7643 HIGHLAND AVENUE Apt 13 | Miami | FL | 33193 | - | NULL |
| PRV | PRV-26073 | 2026-08-13T04:52:16Z | DIEGO | H | PATEL | 1946-05-27 | null | — | 676.629.7575·· | - | 4558 SAGE COURT | Plano | Texas | 75023 | UNKNOWN | UNKNOWN |
| PRV | PRV-24629 | 2026-05-26T19:36:45Z | Theresa | — | Young | 19400110 | ·· | •••-••-2556 | 2378236056 | - | 97 Broadway | Sacramento | CA | ·95843-3751 | ·· | — |
| PRV | PRV-27933 | 2026-05-12T21:12:08Z | Terry | — | Lane | 22-07-2004 | UHC-64702-47 | — | ·(690) 702-5122 | terry.lane47@gmail.com | 5422 CANYON ROAD | Sacramento | CA | 95833 | UNKNOWN | — |
| PRV | PRV-27200 | 2026-02-02T15:28:48Z | AMY | Y | SIMPSON | 19401205 | N/A | — | N/A | N/A | 7977 BAYSHORE DR | Jacksonville | FL | 32260 | — | — |
| PRV | PRV-23938 | 2026-07-13T08:20:43Z | Ahmed·· | — | Hayes | 10-10-1995 | UHC-59600-25 | - | 2407723846 | - | 1557 BASELINE RD | Fresno | CA | 93702 | null | — |
| PRV | PRV-20614 | 2026-02-11T07:23:26Z | CHARLOTTE | V | MOORE | 2002-02-05·· | N/A·· | N/A | 835.765.6917 | UNKNOWN | 3631 Market Street | Minneapolis | MN | 55475 | N/A | null |
| PRV | PRV-21199 | 2026-09-17T10:20:11Z | Julia | — | Hunt | 1965-02-23 | UNKNOWN | null | (673) 980-3505 | - | 9025 Cedar Lane | Seattle | Washington | 98161 | NULL | MEDICARE-ADV-A |
| PRV | PRV-20153 | 2026-02-12T04:32:06Z | EVELYN | — | RODRIGUEZ | 12/04/1946 | UHC-93535-65 | — | N/A | — | 44 Palm Drive | Austin | TX | 78767 | UNKNOWN | ···· |
| PRV | PRV-23612 | 2026-09-16T07:18:10Z | Marrcus | — | Stephens | 19830518 | null | •••-••-5401 | (811) 462-2134 | — | 3957 Sage Court Apt 22·· | EDEN PRAIRIE | MN | ·55338 | UNKNOWN | OPTIONS-PPO |
| PRV | PRV-23665 | 2026-03-18T03:13:10Z | Ralh | U | ·Weaver | 03/16/45 | UHC-96928-89 | •••-••-9768 | 849-534-6181 | ·N/A | 2322 Hillcrest Rd | Miami | FL | 33123 | null | UNKNOWN |
| PRV | PRV-24851 | 2026-03-02T04:15:35Z | Taylor, Madison | — | — | 1957-08-22 | - | — | 2967985659 | madison.taylor24@icloud.com | 16 Ocean Ave | ·Jacksonville | FL | 32299 | ·· | UNKNOWN |
| PRV | PRV-27470 | 2026-04-05T04:45:53Z | Mason | ···· | Edwards | ·1998-08-27 | — | - | (726) 406-6114 | UNKNOWN | ·· | — | N/A | - | NULL | NULL |
| PRV | PRV-20512 | 2026-09-09T12:18:46Z | Carl, King | — | ·· | Feb 6, 1958 | UHC-56378-01 | ·NULL | 12633404744 | — | ·6441 MESA DRIVE | Houston | TX | 77050 | null | — |
| PRV | PRV-20847 | 2026-03-15T16:31:37Z | MADISON | — | ROSE | 1970-12-15 | UHC-87593-49 | — | 5759296150 | UNKNOWN | ·8668 Desert Sky Blvd | Chandler | AZ | 85292 | — | - |
| PRV | PRV-27526 | 2026-09-02T07:43:06Z | Nacy | — | Daniels | 1976-11-12 | UHC-96138-11·· | •••-••-4382 | ·(649) 638-7234 | UNKNOWN | 8662 CEDAR LANE | Orlando | FL | 32823 | UNKNOWN | N/A |
| PRV | PRV-23696 | 2026-02-23T11:47:42Z | Robert | — | Simmons | 1947-10-08 | UHC-52762-25 | •••-••-1485 | 5082913918 | robert.simmons73@yahoo.com | 1818 MAPLE AVE | San Diego | CA | 92157 | — | — |
| PRV | PRV-22989 | 2026-10-15T06:58:15Z | CHARLES | — | GARZA | 1956-06-28 | N/A | — | (462) 968-3657 | CHARLES.GARZA94@PROTON.ME | 4858 INDIAN SCHOOL RD | San Diego·· | CA·· | 92125-8155 | NULL | NULL |
| PRV | PRV-21597 | 2026-09-23T21:46:18Z | Mariana | ···· | Sanders | 1991-09-09 | UNKNOWN | •••-••-9212 | (811) 722-3521 | NULL | 2727 WILLOW COURT | Tempe | ·AZ | 85244 | - | core-hmo |
| PRV | PRV-20092 | 2026-02-19T06:51:26Z | Charyl | — | Howard | 1946-08-24 | UHC-29543-47 | UNKNOWN | 431-836-6154 | — | 5314 APACHE BOULEVARD | Las Vegas | NV | 89176 | — | NULL |
| PRV | PRV-24648 | 2026-09-08T20:13:35Z | Geoorge·· | V | Weaver | 1982-06-25 | NULL | — | (438) 437-8463 | null | 1304 BAYSHORE DRIVE | NASHVILLE | TN | 37281·· | N/A | null |
| PRV | PRV-22042 | 2026-03-06T19:04:56Z | KAITH | — | DUNCAN | 19430228 | UNKNOWN | NULL | ·(651) 284-1016 | UNKNOWN | 1784 Sage Court | Orlando | FL | 32826 | N/A | ···· |
| PRV | PRV-23873 | 2026-09-26T21:57:39Z | Smith, Keith | — | — | 05/06/1997 | ·UHC-42383-68 | — | (413) 484-5736 | keith.smith@icloud.com | 8139 Washington Street | Jacksonville | FL | 32275 | N/A | null |
| PRV | PRV-27428 | 2026-04-12T11:13:29Z | ETHAN | S | SIMS | 5/8/1969 | UHC-64045-26 | — | 6139380739 | — | 6288 Elm St | Plano | TX | 75005 | — | ·- |
| PRV | PRV-27784 | 2026-09-05T15:17:17Z | MARK | — | HOLMES | 1985-06-05 | NULL | ·NULL | (657) 699-0025 | null | 9633 River Rd | HOUSTON | TX | ···· | UNKNOWN | ·· |
| PRV | PRV-22926 | 2026-06-18T02:15:05Z | Sarah | — | Campbell·· | 1945-02-09 | UHC-65576-41 | — | — | N/A | 671 Canyon Road | CHARLOTTE | NC | 28223 | — | — |
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-19T19:54:25.429Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty