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-22325 | 2026-06-16T14:56:46Z | Ronald | ···· | ·Espinoza | 1981-09-20·· | UHC-88715-46 | ···· | — | N/A | 763 OAK STREET | ATLANTA | ·Georgia | 30355 | null | SELECT-EPO |
| PRV | PRV-26081 | 2026-05-21T08:38:10Z | Martha | D. | Gardner·· | 1944-05-13 | — | null | 2579837123·· | NULL | 3192 Sunset Blvd | Gilbert·· | AZ | 85215 | — | MEDICARE-ADV-B |
| PRV | PRV-24966 | 2026-03-08T08:14:27Z | danielle | — | garza | 1971-81-07 | UHC-79202-96 | •••-••-3580 | +1 964 863 1091 | DANIELLE.GARZA22@GMAIL.COM | 2118 Desert Sky Boulevard | Charlotte | NC | 28241 | - | NULL |
| PRV | PRV-23061 | 2026-08-05T02:22:54Z | ana | — | james | 1952-02-17 | UHC7029758 | NULL | 843-905-8580 | — | 5758 SUNSET BLVD | Los Angeles | CA | 90047 | null | NULL |
| PRV | PRV-28998 | 2026-09-01T06:29:39Z | Natalie | ···· | Fisher | 1947-12-27 | - | — | NULL | UNKNOWN | 1004 Valley View Drive | AUSTIN | TX | 78757 | N/A | null |
| PRV | PRV-29074 | 2026-01-27T01:58:29Z | Brittany | W. | Taylor | 1941-05-07 | ·· | •••-••-1401 | (940) 329-9157 | ·null | 3835 Ridge Rd | Tempe | AZ | 85298-4011 | NULL | ···· |
| PRV | PRV-23504 | 2026-06-24T02:55:34Z | MARILYN | H | LI | 1995-02-24 | NULL | - | 359.320.9189 | ···· | 2881 Camelback Rd | PHOENIX | AZ | 85052 | NULL | UNKNOWN |
| PRV | PRV-29101 | 2026-06-08T20:31:39Z | DENNIS | — | LYNCH | 01/03/1973 | — | — | +1 345 481 4972 | dennis.lynch44@aol.com | 6422 Lincoln Way | Houston | TX | 77030 | — | N/A |
| PRV | PRV-23796 | 2026-04-07T02:56:43Z | Lori | C. | Williamson | 12-06-1950 | UHC-02443-02 | null | (530) 204-3195 | — | 2701 Union St | TAMPA | FL | 33601 | NULL | NULL |
| PRV | PRV-21702 | 2026-04-23T21:26:04Z | David | — | Lewis | 19810409 | UHC-05353-85 | — | 4563288585 | — | 5645 Apache Boulevard | Eden Prairie | MN | 55366 | - | — |
| PRV | PRV-24566 | 2026-01-26T06:23:07Z | Jack | M | Barnes | 04/24/79 | UHC-75054-56 | — | 6769332 | ·· | 3185 Washington Street | Las Vegas | NV | 89125·· | — | NAVIGATE-HMO |
| PRV | PRV-23228 | 2026-02-09T15:19:48Z | jose | B·· | morrison | 1962-08-14 | UHC-74741-25 | •••-••-7863 | (624) 231-2131 | jose.morrison@yahoo.com | 3629 PARK PL | Tucson | AZ | 85771-2451 | ·- | CHOICE-PLUS-PPO |
| PRV | PRV-21191 | 2026-10-09T09:55:29Z | Marcus·· | — | Little·· | 2001-03-28 | UHC-92454-63 | — | 8725841589 | null | 9687 Ridge Rd | GILBERT | Arizona | 85266·· | — | N/A |
| PRV | PRV-28907 | 2026-08-07T16:08:46Z | BRITTANY | — | FERGUSON | 5/18/1944·· | UHC-92938-61 | — | 319-743-4136·· | brittany.ferguson50@outlook.com | 6556 Ocean Ave | San Diego | ·CA | ·92127 | N/A | N/A |
| PRV | PRV-24704 | 2026-03-04T19:46:22Z | Harold | — | Tran·· | 1979-04-05 | — | ·N/A | 4353993296 | harold.tran@proton.me | 9620 Broadway | Chandler | AZ | 85240 | — | — |
| PRV | PRV-26528 | 2026-02-26T04:49:23Z | Bennett, Emily | ···· | — | 1981-02-04 | null | null | 3986642803 | - | 5579 Lake View Road | Fresno | CA | 93723-3090 | — | OPTIONS-PPO |
| PRV | PRV-25726 | 2026-09-10T22:15:38Z | Sophia | C. | Bell·· | 19461112 | UHC-20089-46 | — | +1 548 636 8009 | sophia.bell64@proton.me | ·381 Jefferson Ave | Scottsdale | AZ | 85285 | — | - |
| PRV | PRV-28049 | 2026-09-09T21:44:58Z | Brittany | M | Marquez | UNKNOWN | NULL | - | 263.379.9907 | - | 4717 Spring St·· | Columbus | OH | 43249 | — | — |
| PRV | PRV-20674 | 2026-05-19T11:28:59Z | George | — | Castillo | 2008-10-04 | ·UHC-12374-30 | NULL | 2074700932 | george.castillo68@yahoo.com | 5752 SAGE CT | Phoenix | AZ | 85055 | - | — |
| PRV | PRV-29042 | 2026-02-22T05:36:17Z | KATHERINE | — | ELLIS | 1945-08-02 | - | null | 342-836-5735 | — | 1385 Jefferson Ave | Eden Prairie | MN | 55322-8204 | NULL | — |
| PRV | PRV-23820 | 2026-10-16T02:44:13Z | ·Kathleen | — | Simpson | 1999-07-27 | — | NULL | 409-949-2267 | null | 9520 Central Avenue | Columbus | OH | 43244 | - | UNKNOWN |
| PRV | PRV-20380 | 2026-03-06T17:07:50Z | Donald | — | Brown | 2008-05-16 | UNKNOWN | — | 500-960-2474 | donald.brown@yahoo.com | 5701 SPRING ST #367 | ·Jacksonville | FL | 32207 | null | null |
| PRV | PRV-27113 | 2026-06-29T08:52:01Z | SARAH | ···· | REED | 1945-11-23 | — | UNKNOWN | (477) 333-6920 | — | 5662 Oak Street | Los Angeles | ca | 90052 | - | NULL·· |
| PRV | PRV-29207 | 2026-09-15T23:48:43Z | LERRY | — | HUNT | ·2006-04-09 | N/A | N/A | 5292811209 | larry.hunt@aol.com | 7696 Desert Sky Boulevard | ·San Antonio | TX | 78273 | NULL | MEDICARE-ADV-A |
| PRV | PRV-23878 | 2026-06-03T10:17:22Z | Bruce | — | ·Murray | 10/11/94 | UHC-95825-79 | — | 289.307.2986 | bruce.murray70@aol.com | 2873 HIGHLAND AVENUE | MINNEAPOLIS | MN | 55438·· | null | OPTIONS-PPO |
| PRV | PRV-26625 | 2026-09-12T12:49:16Z | Amanda | — | Alexander·· | 2/27/1938·· | UHC1069582 | — | 9336832337 | — | 879 Sunset Boulevard | HOUSTON | TX | — | — | N/A |
| PRV | PRV-24404 | 2026-09-18T05:21:58Z | laura | ···· | stone | 02/17/95 | null | •••-••-7006 | 861.409.8541 | — | 9078 CANYON ROAD | Tampa | FL | 33658 | UNKNOWN | null |
| PRV | PRV-27903 | 2026-06-15T22:54:03Z | Melissa | N. | Bennett | 1/21/1966 | UHC-74500-76 | - | (777) 580-5824 | — | 9773 INDIAN SCHOOL RD Apt 39 | Los Angeles | CA | 90071 | - | - |
| PRV | PRV-25353 | 2026-05-17T07:03:44Z | Kyle | — | Hill | 2005-12-22 | UHC-70211-77 | null | 4137661012 | kyle.hill@aol.com | ·4264 MARKET STREET Apt 26 | Charlotte | NC | 28268 | UNKNOWN | — |
| PRV | PRV-24663 | 2026-03-29T00:05:48Z | Morales, Larry | L | — | 2002-09-18 | — | •••-••-1179 | (621) 747-6977 | - | 1782 Ridge Rd | Sacramento | CA | 95853 | — | - |
| PRV | PRV-22788 | 2026-08-05T03:19:43Z | Angela | Q. | Hawkins | 2003-04-13 | — | — | +1 863 202 0678 | ···· | 8940 CHURCH STREET | Mesa | az | 85276 | — | NULL |
| PRV | PRV-23830 | 2026-07-21T11:58:34Z | Jeffrey | — | Black | 01-05-1992 | — | — | (581) 522-2630 | jeffrey.black@proton.me | 4422 Palm Dr | Eden Prairie | MN | 55307 | — | null |
| PRV | PRV-24143 | 2026-09-26T04:40:37Z | MICHELLE | — | RIVERA | 1989-06-02 | UHC-89576-64 | — | (322) 573-7826 | null | 6134 Hillcrest Rd | Tampa | fl | ·33667 | — | CHOICE-PLUS-PPO |
| PRV | PRV-22472 | 2026-09-23T23:19:10Z | JACOB | K. | ADAMS | ·1972-06-23 | NULL·· | ·null | 6324990118 | — | 5341 Oak St | ·Minneapolis | MN | 55456 | null | NAVIGATE-HMO |
| PRV | PRV-29140 | 2026-07-22T22:33:46Z | Raymond | C. | ·Freeman | 1953-10-23 | UHC-96816-88·· | — | 4823648363 | ···· | — | N/A | NULL | NULL | - | — |
| PRV | PRV-25687 | 2026-10-02T15:33:57Z | VINCENT | — | GILBERT | 03/11/05 | - | - | (417) 432-9160 | N/A | 5120 Cedar Lane | San Diego | California | 92158 | NULL | SELECT-EPO |
| PRV | PRV-27503 | 2026-01-21T06:53:20Z | ETHAN | — | SPENCER | 2002-01-09 | ·UHC-46162-88 | UNKNOWN | (280) 748-6166 | ethan.spencer11@yahoo.com | 8718 Ocean Avenue | Atlanta | GA | 30361-1270 | null | NULL |
| PRV | PRV-29576 | 2026-08-07T18:46:40Z | MARIA | D | FIELDS | 3/23/1944 | - | •••-••-3626 | 424-987-2474 | maria.fields15@icloud.com | 7659 Hillcrest Rd | Minneapolis | Minnesota | 55489-3271 | ·· | SELECT-EPO |
| PRV | PRV-21093 | 2026-01-06T11:45:12Z | BTTY | Y. | WILLIS | 2006-05-12 | UNKNOWN | ···· | 9413319643 | BETTY.WILLIS@HOTMAIL.COM | 7434 CANYON ROAD | Gilbert | AZ | 85267 | null | — |
| PRV | PRV-26947 | 2026-06-29T05:41:41Z | KEVIN | O | SINGH | 20-08-1994 | UHC-44191-84·· | UNKNOWN | (659) 398-6444 | kevin.singh86@proton.me | 8045 Broadway | MESA | AZ | 85252 | — | - |
| PRV | PRV-29237 | 2026-01-21T16:26:02Z | NATALIE | — | RYAN | 20040605 | NULL | •••-••-3485 | 13095522514 | — | 9790 WASHINGTON ST | Minneapolis | MN | 55421 | null | — |
| PRV | PRV-26741 | 2026-03-04T21:51:12Z | WILLIAM | V | PERCE | 2/24/1971 | UHC-54866-35 | UNKNOWN | 628-268-5089 | - | 4291 PINE DRIVE | San Antonio | tx | 78228 | — | — |
| PRV | PRV-29551 | 2026-07-22T12:24:03Z | Walker, Bryan | — | ·· | 1691-01-12 | UHC3665610 | •••-••-2794 | ·16824572043 | — | N/A | — | NULL | — | N/A·· | NULL |
| PRV | PRV-28692 | 2026-10-06T21:58:27Z | Charles | — | McDonald | 24-08-1943 | — | — | 6962489850 | ·charles.mcdonald76@proton.me | 841 Spring Street | ORLANDO | FL | 32851 | null | N/A |
| PRV | PRV-26960 | 2026-03-10T20:21:01Z | laarry | — | ·cox | 1983-06-01 | UHC-25922-95 | — | (955) 370-6658 | — | 4973 Grand Avenue·· | TAMPA | FL | 33619 | — | SELECT-EPO |
| PRV | PRV-26572 | 2026-07-28T01:26:33Z | Ruth | — | Ford | 19731226 | — | •••-••-3199 | 7219563712 | NULL | 3627 Desert Sky Boulevard #199 | Tempe | AZ·· | — | - | - |
| PRV | PRV-25885 | 2026-04-04T06:57:06Z | NICHOLAS·· | — | ·BOWMAN | 1993-08-02 | UHC-35066-30 | UNKNOWN | 8917861 | UNKNOWN | 8094 Main St | SACRAMENTO | CA | 95807 | — | - |
| PRV | PRV-27566 | 2026-10-17T15:34:40Z | Gerald | — | Mendez | 1963-01-11·· | — | N/A | 14285249639 | - | — | NULL | — | — | — | null |
| PRV | PRV-20705 | 2026-08-27T01:13:14Z | Jonathan | — | Cunningham | 1971-01-22 | ·null | - | 683-333-4528·· | N/A | 1755 Lake View Road | Plano | TX | 75005 | N/A·· | — |
| PRV | PRV-22261 | 2026-01-16T02:08:39Z | samantha | L. | nelson | 1986-06-05 | N/A | •••-••-8307 | +1 389 413 7288 | NULL | 5634 Bayshore Drive | Sacramento | CA | 95855-8978·· | 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.319Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty