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-23197 | 2026-05-20T18:43:43Z | Burke | — | Omar·· | Feb 3, 1949 | UHC-25889-13 | - | 467-421-7776 | NULL | 6704 Washington Street | Glendale·· | AZ | 85336 | UNKNOWN | CORE-HMO |
| PRV | PRV-21498 | 2026-05-09T03:23:35Z | Sophia | M | Anderson | 1944-05-23 | UHC-17148-98 | - | 7069163760·· | ·SOPHIA.ANDERSON50@HOTMAIL.COM | 2387 Sage Court | Houston | Texas | — | - | — |
| PRV | PRV-20463 | 2026-06-05T11:33:40Z | Chen, Sofia | ·· | — | 09/25/96 | NULL | UNKNOWN | 4557419514 | — | 7943 WASHINGTON STREET | Phoenix | AZ | 85006 | - | ·· |
| PRV | PRV-28949 | 2026-09-16T19:08:29Z | Denise·· | — | Thomas | 2003-03-03 | null | — | 12108459799 | ·null | 4212 Church Street #332 | Phoenix | Arizona | 85009 | UNKNOWN | — |
| PRV | PRV-27134 | 2026-02-10T22:04:26Z | Sandra | — | Harrison·· | 19571015 | N/A | — | (498) 517-9661 | sandra.harrison@outlook.com | 9330 Lincoln Way Apt 19 | Eden Prairie | MN | 55337-9765 | - | null |
| PRV | PRV-25767 | 2026-08-05T16:16:52Z | Evvelyn | — | Vargas | Jan 18, 1969 | — | •••-••-6042 | (548) 494-3332·· | - | 9477 FOREST AVENUE | Plano | TX | N/A | N/A | UNKNOWN |
| PRV | PRV-22793 | 2026-03-01T01:21:46Z | Bennett, Andrew | — | — | 07/03/1959 | UHC2524008 | UNKNOWN | +1 341 203 7316 | andrew.bennett6@hotmail.com | 7099 Cedar Ln | Las Vegas | NV | 89149 | NULL | — |
| PRV | PRV-20398 | 2026-05-10T05:25:03Z | maria·· | — | washington | 1968-08-24 | — | •••-••-1184 | +1 607 483 2921 | N/A | — | UNKNOWN | null | — | UNKNOWN | null |
| PRV | PRV-26540 | 2026-05-18T17:32:21Z | ·KELLY | ···· | ·RAY | 1972-10-16 | UHC-34652-06 | - | 641-403-8096 | — | 9554 SAGE CT | Los Angeles | CA | 90009-5930 | NULL | UNKNOWN |
| PRV | PRV-21904 | 2026-04-19T11:03:35Z | aaron | — | obrien | 1967-10-21 | N/A | •••-••-5834 | 244.908.8405 | — | 2467 Central Avenue | Chandler | AZ | 85277 | — | N/A |
| PRV | PRV-26481 | 2026-08-29T20:50:15Z | Kenneth | ···· | Schmidt | 1963-07-03 | null | UNKNOWN | +1 351 206 9883 | — | 2650 Harbor Blvd | Scottsdale | Arizona | 85275 | — | - |
| PRV | PRV-28345 | 2026-08-11T05:48:44Z | MARTHA | E | ESTRADA | 1990-04-12 | UHC-83322-47 | null | 529-374-8078 | — | ·4612 Park Place | MIAMI | Florida | 33164·· | UNKNOWN | CHOICE-PLUS-PPO |
| PRV | PRV-22672 | 2026-01-30T10:46:51Z | Omar | J | Carter | ·1940-09-08 | — | NULL | +1 869 892 4762 | ···· | 6152 CAMELBACK RD | Seattle | WA | 98188 | null | — |
| PRV | PRV-24392 | 2026-07-27T12:24:30Z | ·LORI | — | ELLIOTT | 1987-11-02 | — | •••-••-7759 | — | - | 6009 Jefferson Ave | Denver | CO | 80248 | UNKNOWN | - |
| PRV | PRV-20058 | 2026-08-25T06:12:40Z | CARL | — | MENDEZ | 10/19/1990 | UHC-48311-13 | — | (974) 258-8526 | carl.mendez76@aol.com | 5168 PALM DRIVE | Seattle | WA | 98199 | NULL | null |
| PRV | PRV-24559 | 2026-03-04T02:33:38Z | noah | — | bryant | 1949-03-15 | — | — | 676-881-5208 | noah.bryant5@hotmail.com | 8174 Pine Drive | Jacksonville | FL | 32262 | — | — |
| PRV | PRV-27187 | 2026-01-25T12:28:10Z | Steven | — | Campbell | 1987-11-27 | — | - | (725) 719-2835 | steven.campbell@icloud.com | 4595 Union Street #609 | Plano | TX | 75099 | NULL | ···· |
| PRV | PRV-20085 | 2026-09-02T23:47:22Z | Christine·· | — | Salazar | 1973-11-05 | — | NULL | 944-780-4785 | — | 7127 Sunset Boulevard #559 | Plano·· | tx | 75020 | ·NULL | UNKNOWN |
| PRV | PRV-28472 | 2026-09-10T21:17:09Z | Keith | — | Millre | 1959-70-13 | UHC-21541-75 | •••-••-4655 | — | keith.miller75@icloud.com | — | — | null | — | — | ·MEDICARE-ADV-A |
| PRV | PRV-22483 | 2026-01-27T11:55:49Z | Duris·· | R | George | Jan 18, 1947·· | - | •••-••-5867 | (252) 401-2565 | — | 9649 Canyon Road Apt 38 | PLANO | TX | 75096-4653 | N/A | - |
| PRV | PRV-21534 | 2026-07-29T11:00:49Z | LOGAN | ·· | WILLIAMS | 1942-05-11 | - | — | 9233515901 | - | 9681 JEFFERSON AVENUE | Fresno | California | 93723 | null | UNKNOWN |
| PRV | PRV-24214 | 2026-02-23T11:40:57Z | Carl | — | Vasquez | 2000-10-08 | - | UNKNOWN | UNKNOWN | UNKNOWN | ·null | NULL | N/A | UNKNOWN | — | null |
| PRV | PRV-21198 | 2026-05-13T10:14:19Z | James | — | ·Cunningham | 19490215 | UNKNOWN | ·· | 509-237-6050 | null | 7014 Desert Sky Boulevard | Denver | CO | 80253 | - | ·null |
| PRV | PRV-25385 | 2026-08-11T07:48:53Z | Henry | D | Oliver | 1983-04-09 | - | N/A | 846.997.6841 | - | — | - | — | N/A | - | UNKNOWN |
| PRV | PRV-23074 | 2026-06-01T18:31:50Z | Albert | Q. | Delgado | 25-04-1951 | UHC-21429-15 | •••-••-9933 | 801-521-9221 | null·· | 1506 Broadway | San Diego·· | CA | — | — | NULL |
| PRV | PRV-25809 | 2026-05-30T21:11:38Z | CHARLES | — | ALVAREZ | 1994-01-24 | — | null·· | 532-596-8481 | N/A | 4176 Meadow Ln | Tempe | AZ | 85264 | ···· | — |
| PRV | PRV-27445 | 2026-06-10T05:03:14Z | Green, Christina | — | — | 1969-11-10 | N/A | null | 806-757-7954 | — | 8203 JEFFERSON AVE | Glendale | AZ | 85351 | NULL | null |
| PRV | PRV-20800 | 2026-03-03T21:57:01Z | kimberly | — | ryan | - | uhc-73887-22 | — | +1 325 289 9304 | — | 8063 Broadway | CHARLOTTE | NC | 28277 | — | MEDICARE-ADV-A |
| PRV | PRV-29444 | 2026-08-30T20:39:38Z | Cheryl·· | — | OBrien | 1938-08-14·· | UHC-58364-11 | N/A | 748-935-6743 | cheryl.obrien@proton.me | 7836 Union Street | Chandler | Arizona | 85253 | — | NULL |
| PRV | PRV-26910 | 2026-07-17T16:08:36Z | Kelley, Christian | — | — | 28-11-2008 | UHC-69731-27 | ···· | NULL | christian.kelley2@aol.com | 2826 Union Street | Columbus | OH | 43245 | null | N/A |
| PRV | PRV-26555 | 2026-04-11T05:32:30Z | luis | V. | freeman | 10/21/1999 | ·UHC-92466-19 | •••-••-1786 | (708) 474-2253 | LUIS.FREEMAN@ICLOUD.COM | 7776 INDIAN SCHOOL ROAD | CHANDLER | AZ | - | — | N/A |
| PRV | PRV-28063 | 2026-05-08T19:24:27Z | ·Brittany | — | Murray | 1994-03-07 | UHC-32349-76 | •••-••-8272 | 4447930 | - | N/A | N/A | UNKNOWN | — | - | — |
| PRV | PRV-24166 | 2026-07-18T19:53:43Z | Pena, Fatia | — | ···· | 1940-12-03 | - | NULL | — | NULL | 8502 Broadway | Orlando | FL | 32889 | — | N/A |
| PRV | PRV-22825 | 2026-07-08T06:29:59Z | ·SCOTT | — | HOWELL | 09/04/04 | UHC-80139-48 | UNKNOWN | 2229435045 | — | 1885 Meadow Lane | Houston | TX | 77071 | - | CORE-HMO |
| PRV | PRV-26839 | 2026-06-13T01:10:56Z | MATTHEW | — | FERGUSON | ·19950320 | UHC-66125-48 | — | ·+1 580 628 1556 | UNKNOWN | 1582 Camelback Rd | Houston | TX | 77086 | - | ·NAVIGATE-HMO |
| PRV | PRV-23925 | 2026-06-30T14:47:59Z | Kathy | S | Cruz | 09-09-1938 | UHC-40791-28 | •••-••-2435 | (252) 295-9065 | katherine.cruz54@aol.com | 3116 Baseline Rd | GILBERT·· | AZ | 85270 | null | N/A |
| PRV | PRV-21919 | 2026-04-08T22:11:32Z | Janice·· | — | Gutierrez | 1970-06-20 | NULL | NULL | 499-866-6057 | ···· | — | NULL | — | — | — | — |
| PRV | PRV-23234 | 2026-01-10T21:15:07Z | Wilson, Beverly | — | — | 13-07-1994 | UHC-95133-67 | null | 642.439.5390 | N/A | 554 PINE DR | Atlanta | GA | 30349 | N/A | — |
| PRV | PRV-22142 | 2026-08-21T17:47:08Z | Jackson, Deborah | Y | — | 1951-07-21 | UHC-89997-70 | •••-••-3211 | 651-717-0507 | — | 8786 Jefferson Ave Apt 11 | Las Vegas | NV | UNKNOWN | NULL | null |
| PRV | PRV-28994 | 2026-01-15T17:59:09Z | Mateo | — | Salazar·· | 5/19/1965 | UHC-62782-53 | NULL | — | MATEO.SALAZAR@OUTLOOK.COM | ·4525 HIGHLAND AVENUE #743 | Mesa | AZ | 85215-6505 | - | N/A |
| PRV | PRV-22532 | 2026-01-25T13:29:38Z | MARIANA | — | ANDERSON | 2000-10-14 | — | — | (824) 407-3420 | mariana.anderson@proton.me | 340 OCEAN AVENUE | COLUMBUS | OH | 43274 | ···· | UNKNOWN |
| PRV | PRV-27147 | 2026-06-10T13:59:12Z | Lee, Donald | ···· | — | 9/19/1994 | UHC-53065-99 | N/A | 853-269-6375 | — | 8388 DESERT SKY BLVD | Plano | TX | 75019 | — | — |
| PRV | PRV-26955 | 2026-09-27T11:07:23Z | MEI | ·Q. | CARTER | ·1992-06-24 | — | NULL | 4672594055 | mei.carter@yahoo.com | 635 Highland Avenue·· | HOUSTON | TX | 77055 | — | MEDICARE-ADV-B |
| PRV | PRV-22256 | 2026-10-15T23:52:13Z | Kimberly | — | Bryant | 09/27/2001 | NULL | — | 6588041763 | kimberly.bryant17@aol.com | 9728 Lincoln Way #837 | Orlando | FL | 32888 | — | ·· |
| PRV | PRV-27185 | 2026-06-10T15:23:55Z | Cynthia | — | Ray | 19520809 | UHC-95030-16 | — | 242.334.5231 | - | 5099 OCEAN AVE | SACRAMENTO | CA | ·95899 | null | null |
| PRV | PRV-20875 | 2026-07-15T13:57:40Z | CHRISTINA | U | MEYER | 19550322 | UHC-19804-16 | null | 7786279588 | — | 2100 Meadow Lane | Los Angeles | CA | 90039 | N/A | 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:43:03.771Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty