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-20491 | 2026-09-24T02:19:31Z | ·Gloria | X | Chapman·· | 1944-07-20 | — | - | 634.315.3093 | gloria.chapman@aol.com | 9217 ELM STREET | Phoenix | AZ | 85055 | ···· | — |
| PRV | PRV-28194 | 2026-01-27T20:42:42Z | Nicholas | — | Jackson | 1987-08-03 | UHC-25427-08 | NULL | 577-369-4218 | null | 1109 Maple Avenue | CHANDLER | az | 85260·· | N/A | NAVIGATE-HMO |
| PRV | PRV-27047 | 2026-08-14T03:33:39Z | Larry | J | Medina | 1994-12-02 | UHC-84410-11 | NULL | 668.238.4028 | UNKNOWN | 9134 Desert Sky Boulevard | San Antonio | TX | 78211 | null | null |
| PRV | PRV-29449 | 2026-05-08T21:42:43Z | Benjamin | — | Walker | 19951212 | UHC7083099 | — | ·5879180816 | N/A·· | 4431 Union St | Jacksonville | FL | N/A | - | - |
| PRV | PRV-20396 | 2026-05-03T21:20:45Z | THOMAS | J. | GRIFFIN | 1986-12-03 | — | UNKNOWN | (824) 942-0572 | thomas.griffin87@gmail.com | 3794 MOUNTAIN VIEW DR·· | Charlotte | NC | 28247 | NULL | — |
| PRV | PRV-29242 | 2026-02-04T20:18:26Z | PAT | — | FISHER | 2008-04-12 | UHC-39580-82·· | null | null | ·patrick.fisher89@gmail.com | 799 Church Street | Dallas | TX | 75206 | — | UNKNOWN |
| PRV | PRV-27638 | 2026-06-29T00:15:55Z | CHRSTOPHER | — | TOMAS | ·Sep 8, 2003 | N/A | NULL | 3424954941 | — | — | N/A | — | - | — | SELECT-EPO |
| PRV | PRV-23946 | 2026-08-01T13:41:06Z | ·Sophia | — | Hill | 1975-08-12 | UHC-72031-89 | •••-••-4708 | (290) 841-6465 | ·null | 4128 SPRING STREET | Denver | CO | null | — | CHOICE-PLUS-PPO |
| PRV | PRV-20730 | 2026-08-05T02:33:52Z | Heather | — | Howaard | 1954-04-18 | - | UNKNOWN | — | heather.howard@aol.com | 784 Forest Ave | Houston | TX | 77048 | - | NULL |
| PRV | PRV-28266 | 2026-06-25T18:08:03Z | MARILYN | ·H | CASTRO | 1987-10-05 | UNKNOWN | N/A | +1 972 708 4503 | MARILYN.CASTRO50@PROTON.ME | 4304 Park Pl | Gilbert | AZ | 85295 | NULL | MEDICARE-ADV-B |
| PRV | PRV-24685 | 2026-08-14T07:44:13Z | SARA | — | LITTLE | 1981-10-12 | UHC-34139-98·· | — | (720) 936-1742 | null | 5850 JEFFERSON AVE #409 | Plano | TX | 75086 | — | null |
| PRV | PRV-26853 | 2026-05-19T08:32:21Z | Charlotte | — | Richards | 19380421 | UHC-72303-37 | NULL | ·520-425-4393 | — | 2821 CANYON RD | Plano | TX | 75028 | N/A | NULL |
| PRV | PRV-22740 | 2026-09-23T07:03:01Z | TERESA | — | WILLIAMSON | 1981-01-26 | UHC-54512-54 | UNKNOWN | (414) 216-2987 | — | 2913 Lincoln Way | Dallas | TX | 75257 | null | — |
| PRV | PRV-20239 | 2026-07-25T00:43:53Z | DAVID | ···· | TAYLOR | 1956-08-27 | NULL | - | +1 607 377 8597 | david.taylor@outlook.com | 4578 Baseline Road | JACKSONVILLE | FL | 32221 | ·N/A | NULL |
| PRV | PRV-24848 | 2026-03-26T03:10:55Z | Christian | ·M | Wheeler | 19611205 | N/A | — | 3179274242 | null | — | — | — | ···· | - | — |
| PRV | PRV-28463 | 2026-07-29T06:40:32Z | ralph | — | bradley | 1980-07-27 | UHC-94420-89 | •••-••-3512 | ·7632035783 | — | 4979 PARK PL | ORLANDO | Florida | 32832 | — | - |
| PRV | PRV-22567 | 2026-02-28T09:03:30Z | BRYAN | — | COX | 06/15/1964 | UHC-15669-80 | — | 888-733-1750 | — | null | NULL | — | — | null | — |
| PRV | PRV-27911 | 2026-03-21T06:59:14Z | theresa | E | washington | 1957-04-11 | UHC-57051-33 | — | — | N/A | 3875 Washington St | Scottsdale | AZ | 85265 | UNKNOWN | null |
| PRV | PRV-25928 | 2026-09-19T03:48:34Z | Maria | C | Holmes | Jun 28, 1944·· | UHC-41418-76 | null | 869.720.1138 | — | 3447 Desert Sky Blvd | Tempe | AZ | 85290·· | ·UNKNOWN | — |
| PRV | PRV-22574 | 2026-06-21T14:16:00Z | Paul | ···· | Holmes | 01/28/53 | UHC0595173 | — | (446) 541-2660 | N/A | 5401 Forest Ave | Scottsdale | AZ | 85254 | N/A | - |
| PRV | PRV-27631 | 2026-07-30T14:03:28Z | ·Eric | — | Robertson | 2008-07-10 | UHC-01745-78·· | — | 218-627-1767 | null | 3096 Union Street | Fresno | California | 93766 | N/A | — |
| PRV | PRV-29352 | 2026-09-21T10:34:42Z | ·ralph | R | andrews | 06/10/1985 | null | — | — | RALPH.ANDREWS54@OUTLOOK.COM | 3086 DESERT SKY BOULEVARD | Fresno·· | ·California | 93728 | null | NULL |
| PRV | PRV-20997 | 2026-03-17T07:15:24Z | Luis | — | Richars·· | 02/26/1961 | null | ·· | null | luis.richards54@gmail.com | 810 Jefferson Ave | ORLANDO | FL | 32859 | NULL | NULL |
| PRV | PRV-28197 | 2026-10-07T20:58:41Z | MARCUS | Q. | CLARK | 1950-06-14 | UHC-21648-41 | — | 964-992-4551 | marcus.clark@outlook.com | 3369 WASHINGTON STREET | Dallas | TX | 75290 | — | - |
| PRV | PRV-27827 | 2026-09-23T19:55:37Z | Judith | — | Grant | 1968-06-16 | UHC7369848 | — | (539) 437-9731 | — | 7974 RIDGE RD | Sacramento | California | 95824 | — | N/A |
| PRV | PRV-25283 | 2026-01-03T19:13:16Z | Ashley | S | Bradley | 1956-04-18 | ·UHC-66935-98 | - | (979) 920-7989 | UNKNOWN | 6661 Apache Blvd | Las Vegas | NV | - | — | NULL |
| PRV | PRV-23629 | 2026-08-29T14:20:19Z | Alexander, Wei | — | — | 2000-09-27 | ···· | — | 478-989-0991 | - | 5244 Camelback Rd | Phoenix | AZ | ·85019 | — | UNKNOWN |
| PRV | PRV-25610 | 2026-03-22T03:32:44Z | ARTHUR | — | ·LYNCH | 4/3/1952 | UHC-12744-38 | N/A | (734) 411-1029 | - | 3939 Grand Avenue | Charlotte | NC·· | 28219 | — | NULL |
| PRV | PRV-28504 | 2026-04-18T17:32:51Z | BRADLEY | — | KELLEY | 1979-09-06 | UHC-90063-13 | — | 662-369-1927 | NULL | ·null | null | N/A | null | - | OPTIONS-PPO |
| PRV | PRV-22279 | 2026-04-20T23:14:07Z | EUGENE | H. | KELLLY | 1976-07-07 | UHC-59154-82 | UNKNOWN | 861-408-6016 | — | 1751 Valley View Drive | MIAMI | FL | 33148 | null | — |
| PRV | PRV-24913 | 2026-01-07T06:17:41Z | Mei | T | Le·· | 1942-07-21 | — | •••-••-2456 | 584.543.9885 | mei.le50@outlook.com | 1892 Forest Ave Apt 23 | Sacramento | CA | 95827 | — | — |
| PRV | PRV-24528 | 2026-06-08T16:26:42Z | SOFIA | Y | WILSON | 06/18/2004 | UHC-06608-41 | - | +1 590 299 8121 | - | 3482 River Road | San Diego | CA | 92138 | NULL | N/A |
| PRV | PRV-21227 | 2026-03-06T21:43:47Z | Ana | ·· | Banks | ·1968-01-12 | — | N/A | 5547536159 | — | 5264 Elm St | Minneapolis | mn | 55474 | - | SELECT-EPO |
| PRV | PRV-25565 | 2026-10-03T02:44:36Z | Amy | ···· | Torres | ·01-01-1995 | UHC-25276-49 | — | 6413517923 | - | 206 Lincoln Way | Tampa | FL | 33620-2119 | NULL | NULL |
| PRV | PRV-23600 | 2026-08-02T07:54:46Z | Betty | ·U. | Nichols | 1980-09-27 | N/A | UNKNOWN | (387) 716-9503 | ·- | 6507 Oak Street | Jacksonville | fl·· | 32265 | null | SELECT-EPO |
| PRV | PRV-25154 | 2026-07-31T19:52:52Z | Fernandez, Jessica | — | — | 19510407 | N/A | — | — | JESSICA.FERNANDEZ33@OUTLOOK.COM | 3338 Highland Ave | Austin | TX | 78789 | null | MEDICARE-ADV-B |
| PRV | PRV-23752 | 2026-02-09T06:46:27Z | Dylan | — | Ross | 1942-02-11 | null | •••-••-1650 | ·15644987844 | dylan.ross@proton.me | UNKNOWN | ·· | ···· | UNKNOWN | N/A | - |
| PRV | PRV-26968 | 2026-05-14T20:08:17Z | Charlotte | N | Fowler | 11/27/1967 | UHC-76075-73 | N/A | ·823.804.4717 | CHARLOTTE.FOWLER@HOTMAIL.COM | 9467 INDIAN SCHOOL RD·· | GILBERT | AZ | 85247 | N/A | NULL |
| PRV | PRV-23167 | 2026-10-04T23:35:32Z | Willie | V | Dunn | 1967-09-07 | UHC-04570-88 | •••-••-7306 | 2374412395 | NULL·· | 7513 JEFFERSON AVENUE·· | Minneapolis | MN | 55476 | null | ···· |
| PRV | PRV-23327 | 2026-03-01T11:54:36Z | BETTY | A. | ROE | 2/14/2004·· | UHC-23050-58 | — | 876-713-6718 | null | 1454 Grand Ave | GLENDALE | AZ | 85332 | UNKNOWN | null |
| PRV | PRV-23862 | 2026-02-17T12:02:50Z | CYNTHIA | — | ·RAY | 07/28/1944 | UHC-77905-14 | null | 985-546-5699 | NULL | 2807 LAKE VIEW RD | Houston | TX | 77071 | — | N/A |
| PRV | PRV-22319 | 2026-03-06T12:42:34Z | JACQUELINE | I | WILLIAMSON | 1953-06-01 | — | •••-••-4076 | — | NULL | 1442 CANYON RD | Las Vegas | NV | 89162 | UNKNOWN | — |
| PRV | PRV-23501 | 2026-05-02T02:02:22Z | SAMUEL | — | GRAHAM | 2007-03-12 | NULL | •••-••-9344 | 879.755.7655·· | N/A | null | ·N/A | — | null | — | — |
| PRV | PRV-25469 | 2026-01-02T07:41:38Z | Maria | — | Castillo | 1955-10-06 | UHC-23443-73 | ···· | (621) 336-5926 | null | 3511 Ocean Ave | SEATTLE | WA | 98161 | — | NULL |
| PRV | PRV-20111 | 2026-09-07T08:14:35Z | Watson, Shirley | — | — | ·Jun 9, 1997 | — | NULL | (733) 258-6650 | UNKNOWN | 7724 Canyon Road | Minneapolis | MN | 55499 | NULL | NAVIGATE-HMO |
| PRV | PRV-21584 | 2026-10-08T14:02:08Z | PHILIP | — | LAWRENCE | 10/2/1991 | ·NULL | — | 8023222072 | philip.lawrence@outlook.com | 1594 River Road | Chandler | AZ | 85200 | NULL | null |
| PRV | PRV-28811 | 2026-02-10T07:56:00Z | Howell, Scott | B | — | 1997-12-18 | - | •••-••-1005 | 845-882-4338 | - | 1511 WILLOW CT | Scottsdale | AZ | 85241-3648 | UNKNOWN | UNKNOWN |
| PRV | PRV-28897 | 2026-07-12T18:59:19Z | kelly | — | diaz | 1996-08-11·· | UHC-26056-23 | — | 2416917221 | KELLY.DIAZ9@OUTLOOK.COM | — | UNKNOWN | NULL | NULL | N/A | MEDICARE-ADV-A |
| PRV | PRV-22331 | 2026-09-01T20:28:06Z | Ann | — | Wilson | ·19791203 | UHC-99469-90 | null | (725) 566-6084 | ann.wilson13@icloud.com | 1701 MAIN ST·· | Miami | Florida | 33144 | — | — |
| PRV | PRV-26774 | 2026-08-26T08:46:33Z | jose | — | holmes | 1986-06-03 | null | N/A·· | (247) 901-8921 | UNKNOWN | 4808 Meadow Lane | San Diego | CA | 92189-0264 | — | 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:40.330Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty