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-29327 | 2026-02-02T20:52:03Z | VINCENT | — | RLIEY | ·1964-12-24 | UHC-46418-02 | - | 6384599174 | UNKNOWN | 1651 GRAND AVE | ATLANTA | GA | 30381 | — | null |
| PRV | PRV-28189 | 2026-07-03T14:42:49Z | Montgoery, Marcus | ·· | — | 1966-02-07 | UHC-94734-12 | — | - | ·· | 1942 Meadow Lane | Chandler | AZ | 85203 | N/A | MEDICARE-ADV-A |
| PRV | PRV-27919 | 2026-02-08T18:48:56Z | JUSTIN | D. | WELCH | 03/05/1981 | UHC-40931-89 | - | (375) 518-7151 | UNKNOWN | 6794 Market Street | San Antonio·· | TX | 78289·· | ·- | options-ppo |
| PRV | PRV-20561 | 2026-08-07T15:18:02Z | ·Sharon | O | Patterson | UNKNOWN | UHC-01025-68 | •••-••-3950 | (489) 214-0421 | NULL·· | 7671 CENTRAL AVE | Atlanta | Georgia | 30364 | N/A | NAVIGATE-HMO |
| PRV | PRV-28250 | 2026-04-14T06:24:19Z | Mei | — | Clark | 1987-03-09 | UHC1554620 | NULL | (765) 896-2929 | — | 4102 Sunset Blvd | Glendale | AZ | 85329 | — | — |
| PRV | PRV-25015 | 2026-09-21T10:48:36Z | Natalie | O. | Shaw | 1966-08-15 | UHC-04451-66 | - | 2396014239 | - | 491 PALM DR | Sacramento | CA | 95819 | NULL | MEDICARE-ADV-A |
| PRV | PRV-28844 | 2026-06-22T09:11:06Z | janet W | — | ford | 10/9/1969 | — | — | 7717112234 | - | 3521 River Rd·· | San Antonio | TX | 78213·· | N/A | NULL·· |
| PRV | PRV-21850 | 2026-07-18T10:27:26Z | Susan | — | Cruz | ·02/13/99 | UHC-91616-29 | •••-••-2651 | (861) 965-4207 | susan.cruz@yahoo.com | 9775 CEDAR LN | Atlanta | Georgia | 30338 | N/A | CHOICE-PLUS-PPO |
| PRV | PRV-28248 | 2026-06-10T17:50:33Z | SARAH | — | — | Jun 9, 1953 | ·UHC9117768 | •••-••-6647 | 16255821797 | — | 6005 Cedar Ln | Phoenix | AZ | 85018 | — | N/A |
| PRV | PRV-21876 | 2026-08-11T23:39:46Z | Samuel | — | Ford | 8/17/1993 | — | N/A | 3986976535 | SAMUEL.FORD19@HOTMAIL.COM | 5737 APACHE BOULEVARD | MIAMI | FL | — | — | MEDICARE-ADV-A |
| PRV | PRV-26973 | 2026-02-28T21:34:34Z | Dennis | — | Morris | 19560801 | UHC-52301-44 | NULL | 452-929-1801 | dennis.morris48@outlook.com | 1163 Willow Ct #689 | MINNEAPOLIS | MN | 55485 | - | null |
| PRV | PRV-22670 | 2026-05-15T10:46:34Z | Theresa | — | Cunningham | Jan 18, 2004 | - | — | 19613903662 | - | 8763 Washington Street·· | ·Tempe | AZ | 85277 | UNKNOWN | — |
| PRV | PRV-23189 | 2026-04-22T16:42:53Z | OLIVIA | — | REMIREZ | 2002-09-06 | UHC-52164-96 | ·· | 9178149036 | N/A | 3487 OAK STREET | AUSTIN | TX | 78763 | null | — |
| PRV | PRV-21245 | 2026-02-24T20:05:10Z | DAVID | — | GARZA | Apr 6, 1938 | null | •••-••-5249 | 6429218121 | — | 4042 Canyon Rd | Plano | ·TX | 75098 | — | - |
| PRV | PRV-21587 | 2026-09-01T03:31:59Z | DENISE | — | SANDERS | 1951-02-16 | — | NULL | 304-763-7656 | — | 6705 Meadow Ln | Columbus | OH | 43288 | — | N/A |
| PRV | PRV-27756 | 2026-02-15T17:06:37Z | BRITTANY | — | WALSH | 1984-05-09 | - | - | 966.401.3822 | — | 6263 Forest Avenue | Denver | ·CO | 80220 | N/A | — |
| PRV | PRV-26303 | 2026-08-11T21:22:59Z | THERESA | — | PENA | 12/11/2007 | N/A | null | (529) 937-8500 | theresa.pena51@aol.com | 3868 Sunset Blvd #377 | Tempe | AZ·· | 85271 | — | — |
| PRV | PRV-28567 | 2026-02-18T11:54:43Z | ·THERESA | — | STEPHENS | 20-10-1963 | NULL·· | •••-••-8107 | 8785544791 | N/A | 5288 Market St | Tempe | AZ | 85225 | N/A | NULL |
| PRV | PRV-29084 | 2026-05-17T11:32:25Z | Daniesl, Gary | ·Q | — | 2007-01-19 | UHC-24336-40 | — | 436.413.7189 | — | — | N/A | — | N/A | N/A | — |
| PRV | PRV-26731 | 2026-01-26T14:49:48Z | Jesse | — | Cunningham | 1993-09-09 | UHC-75159-17 | — | 13543974685 | — | 9591 Palm Drive | Tempe·· | AZ·· | 85211 | — | — |
| PRV | PRV-23897 | 2026-03-18T09:22:53Z | Martinez, Linda | — | — | 1949-11-21·· | — | NULL | 642-238-9030 | — | — | UNKNOWN | null | NULL | null | — |
| PRV | PRV-20577 | 2026-10-11T15:58:55Z | Maldonado, Emma L | — | — | 1941-04-20 | UHC-15232-89 | N/A | (565) 971-6406 | EMMA.MALDONADO59@YAHOO.COM | 3063 Desert Sky Boulevard | Gilbert | ·AZ | 85221 | — | - |
| PRV | PRV-21714 | 2026-05-14T09:55:55Z | Larry | I. | Bradley·· | 1979-01-15 | — | - | 432-315-9224 | ·larry.bradley@aol.com | 1967 Meadow Lane | TUCSON | AZ | 85756 | NULL | — |
| PRV | PRV-22815 | 2026-10-07T19:50:15Z | aisha | ·· | baker | 1944-03-19 | NULL | null | 225-803-1079 | AISHA.BAKER@OUTLOOK.COM | 5994 Indian School Rd #611 | Charlotte | NC | 28210 | UNKNOWN | NULL |
| PRV | PRV-23030 | 2026-02-28T08:46:05Z | Patrick | — | Gutierrez | 1972-12-13 | UHC-95777-12 | — | — | null | 8668 Mesa Dr | LOS ANGELES | CA | ·90012 | N/A | — |
| PRV | PRV-27661 | 2026-01-15T17:33:52Z | Camila | — | Herrera | 1946-01-08 | — | — | 14765411019 | — | 6176 Park Place | GLENDALE | AZ·· | 85380 | null | - |
| PRV | PRV-26836 | 2026-07-23T08:27:51Z | Shirley | — | Fields | 02/13/1946 | — | — | N/A | UNKNOWN | — | — | ·null | NULL | N/A | - |
| PRV | PRV-25305 | 2026-04-18T07:14:55Z | Dorothy | E | Griffin | ·20061203 | UHC-72937-08 | UNKNOWN | ·8475394 | — | 3762 Market Street | Glendale·· | AZ | 85321 | ···· | — |
| PRV | PRV-25791 | 2026-04-10T23:58:46Z | Camila | — | Castro | 5/15/2003 | — | N/A | — | ·camila.castro@yahoo.com | 5948 Pine Drive | Los Angeles | CA | 90058 | UNKNOWN | ·· |
| PRV | PRV-25896 | 2026-03-28T15:59:37Z | SANDRA | — | LAWIS | ·2005-01-08 | NULL | — | ·N/A | — | N/A | null | N/A | - | — | NULL |
| PRV | PRV-21273 | 2026-06-21T13:06:57Z | Gregory | — | Ward | ·19810122 | UHC-42600-61·· | ·null | (422) 714-3570 | — | 886 Bayshore Drive | Miami | FL | 33159 | N/A | ·CHOICE-PLUS-PPO |
| PRV | PRV-27606 | 2026-01-02T01:39:51Z | Willis, Luis | — | — | 19811119 | UHC-03152-84 | null | 407-263-0254 | ·luis.willis@aol.com | 8903 Desert Sky Boulevard | Denver | co | 80210 | N/A | MEDICARE-ADV-B |
| PRV | PRV-24703 | 2026-03-08T15:33:10Z | Aaron | T.·· | Simpson | 2005-05-22 | null | N/A | — | NULL | 659 Washington St | MIAMI | FL | 33175-7116 | — | SELECT-EPO |
| PRV | PRV-22448 | 2026-07-26T13:21:14Z | Alexander | — | Gutierrez | Aug 3, 1969 | UHC-03255-02 | N/A | 656-268-7280 | UNKNOWN | 3809 Oak Street | ·Sacramento | CA | 95811 | — | - |
| PRV | PRV-27413 | 2026-03-21T12:33:09Z | Wagner, Stephanie | J | — | 1966-09-22 | uhc-41796-51 | - | (365) 696-3373 | stephanie.wagner74@hotmail.com | UNKNOWN | NULL | null | UNKNOWN | N/A | N/A |
| PRV | PRV-21449 | 2026-04-02T20:54:43Z | Billy | ·· | Mendez·· | 05/15/1959 | N/A | - | 793-814-7936 | — | 1872 Willow Ct | Miami | FL | 33100-8427 | — | ·OPTIONS-PPO |
| PRV | PRV-24449 | 2026-01-20T07:31:04Z | SAMUEL | P. | MORGAN·· | 2008-03-20 | UHC-61315-08 | •••-••-5670 | 959-712-4132 | samuel.morgan@gmail.com | 3999 Hillcrest Road #932 | TEMPE | AZ | 85285 | UNKNOWN | — |
| PRV | PRV-25990 | 2026-07-28T17:09:23Z | Bryan | B. | Scott | 1944-04-17 | UHC-74488-46 | •••-••-6931 | 7652508425 | — | 9632 LINCOLN WAY | Tempe | AZ | 85202 | — | — |
| PRV | PRV-22406 | 2026-10-01T09:29:37Z | Austin | C. | Tucker | 2004-03-02 | UHC-85356-51 | UNKNOWN | (878) 557-1233 | ·austin.tucker16@aol.com | 6741 Cedar Lane | TAMPA | FL | 33621 | - | null |
| PRV | PRV-27893 | 2026-08-13T16:52:36Z | Elijah | — | Weaver | 1954-12-01 | UHC-12057-36·· | - | 3912403286 | N/A | 2757 CEDAR LN | Seattle | Washington | 98180-7211·· | UNKNOWN | null |
| PRV | PRV-20945 | 2026-08-08T10:31:42Z | Dylan | — | Stone | 1961-03-05 | UHC-00232-43 | — | 433.272.1170 | ·· | 1977 Market St | Denver | CO | 80248 | UNKNOWN | SELECT-EPO |
| PRV | PRV-29404 | 2026-09-17T04:32:53Z | Diane | — | Fowler | 9/21/1962 | — | ·NULL | (636) 223-6489 | N/A | 2837 Park Pl | Tampa | FL | 33665-4345 | — | — |
| PRV | PRV-28018 | 2026-04-21T00:41:02Z | Matthew | — | Padilla | 1988-06-22 | UHC-76766-77 | N/A | (720) 606-4212·· | UNKNOWN | 4283 Valley View Drive | SAN DIEGO | CA | ·92134-1278 | — | null |
| PRV | PRV-29406 | 2026-04-27T01:24:30Z | DENISE | ·· | MORALES | 1952-09-16 | UHC-22051-95 | UNKNOWN | 2914943140 | UNKNOWN | 6636 Meadow Lane | Charlotte·· | NC | 28220 | — | CHOICE-PLUS-PPO |
| PRV | PRV-29409 | 2026-07-03T01:16:10Z | jordan | D. | thomas | 1948-03-05 | — | - | +1 893 366 0562 | — | 5317 Jefferson Avenue | Sacramento | CA | 95895 | - | - |
| PRV | PRV-21065 | 2026-08-09T02:56:06Z | mei | O | matthews | ·1996-00-67 | UHC-74503-34·· | - | null | UNKNOWN | null | - | N/A | NULL·· | NULL | select-epo |
| PRV | PRV-20978 | 2026-04-01T07:44:48Z | Rcahel·· | — | Maldonado | 3/5/1940 | — | •••-••-1858 | +1 300 423 0351 | — | 1474 RIDGE ROAD #742 | Sacramento | CA·· | ·95818 | null | — |
| PRV | PRV-28698 | 2026-02-10T20:15:17Z | Charles | ···· | Hunter | 2000-04-06·· | — | null | 2366062 | null | 433 CEDAR LANE | Fresno | CA | 93714 | — | MEDICARE-ADV-B |
| PRV | PRV-26563 | 2026-07-02T16:15:35Z | Ortega, Pat | — | — | Jul 20, 2001 | UHC-45462-68 | N/A | — | N/A | 348 Cedar Ln | Atlanta | ga | 30305 | — | - |
| PRV | PRV-25255 | 2026-04-15T08:46:07Z | Diane | — | Meyer | Jan 8, 1984 | null | — | 18974579450 | diane.meyer@outlook.com | 6924 Apache Blvd | LAS VEGAS | NV | ·89182 | N/A | — |
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.219Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty