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-26237 | 2026-07-21T19:19:43Z | ·sarah | C. | murphy | 1964-06-03 | ·· | - | 547.354.9016 | SARAH.MURPHY@HOTMAIL.COM | 7273 PALM DR | SCOTTSDALE | AZ | 85237 | - | UNKNOWN |
| PRV | PRV-26537 | 2026-02-24T14:56:55Z | Russell·· | ·P. | Nunez | 06/15/87 | null | NULL | 227-346-9995 | RUSSELL.NUNEZ3@ICLOUD.COM | - | UNKNOWN | — | — | N/A | ···· |
| PRV | PRV-23136 | 2026-10-04T08:39:01Z | Ann | — | Rios | 2003-07-20 | NULL | •••-••-5537 | UNKNOWN | ·· | 6732 VALLEY VIEW DR | Eden Prairie | ·MN | 55331 | N/A | — |
| PRV | PRV-23250 | 2026-09-18T15:47:38Z | Mark | — | Powell | 09/12/98 | UHC-33325-83 | UNKNOWN | 12834216239 | MARK.POWELL@GMAIL.COM | 9187 Ocean Avenue | Plano | TX | 75022 | — | null |
| PRV | PRV-28529 | 2026-01-18T02:55:56Z | Fuller, Sofia | — | — | 1945-03-08 | — | N/A | 4386925750·· | null | 8946 CAMELBACK RD | Sacramento | CA | 95896 | ···· | UNKNOWN |
| PRV | PRV-20907 | 2026-03-03T09:24:00Z | Ann | — | Taylor | 1945-09-03 | — | N/A | 14299117742 | — | 7489 VALLEY VIEW DRIVE Apt 18 | Scottsdale | AZ | 85213 | - | ···· |
| PRV | PRV-25070 | 2026-07-28T19:45:40Z | Mei | — | Wilson | 1978-03-11 | UHC-28950-12 | N/A | 852.468.7102 | MEI.WILSON@ICLOUD.COM | 3147 LINCOLN WAY | Charlotte | NC | 28240·· | null | CORE-HMO |
| PRV | PRV-23556 | 2026-01-19T19:01:50Z | Charlotte | — | Lawson | 1952-02-25 | UHC-42796-35 | UNKNOWN | 836.201.0634 | — | 4101 River Road | Fresno | CA | 93700 | N/A | — |
| PRV | PRV-22299 | 2026-01-27T03:27:44Z | Castro | — | Liz | 1966-07-10 | N/A | N/A | 8217442326 | — | 133 MAIN STREET | San Diego | CA | 92150 | — | - |
| PRV | PRV-20955 | 2026-10-09T05:31:14Z | BETTY·· | ···· | VEGA | 1988-10-12 | — | •••-••-3901 | 7161088 | — | 5155 Camelback Road | San Antonio | TX | 78215 | UNKNOWN | CORE-HMO |
| PRV | PRV-25490 | 2026-06-16T11:12:16Z | Kimberly·· | A. | Morrison | 1943-11-19 | UHC-34877-54·· | •••-••-6926 | 445.918.6280 | ·null | — | - | null | null | null | - |
| PRV | PRV-26027 | 2026-06-18T12:45:35Z | ALAN | ·J | KELLY | 1973-05-25 | — | NULL | 3325331571 | ···· | 8577 BASELINE ROAD | JACKSONVILLE | ·FL | ·32299 | NULL | - |
| PRV | PRV-27748 | 2026-03-25T13:48:12Z | dorothy | — | smith | 2003-10-07 | UHC0158136 | N/A | 534-679-1797 | NULL | 624 Central Avenue·· | Gilbert | AZ | 85257 | null | ·null |
| PRV | PRV-28987 | 2026-05-01T03:34:42Z | Freeman, Ahmed | — | — | 1940-09-12 | - | - | N/A | ahmed.freeman@aol.com | 1848 Pine Drive Apt 28 | ·Las Vegas | Nevada | 89180 | - | — |
| PRV | PRV-23433 | 2026-08-22T07:39:05Z | Julia | — | Adams | 1962-04-13 | UHC-29398-05 | null | 620.827.4753 | UNKNOWN | null | - | NULL | null | null | MEDICARE-ADV-B |
| PRV | PRV-21734 | 2026-02-07T08:52:27Z | Walter·· | — | ·Rivera | Dec 28, 1994 | — | — | UNKNOWN | null | 2298 Main Street | Minneapolis | MN | 55425 | — | null |
| PRV | PRV-25526 | 2026-03-17T18:08:10Z | Elizabeth | — | Hanson | 23-10-1981 | UHC-21503-26 | UNKNOWN | 6745142023 | elizabeth.hanson92@yahoo.com | 1726 Elm Street | ·San Antonio | Texas | 78247-4271 | - | — |
| PRV | PRV-28156 | 2026-07-11T17:31:46Z | logan | V | ·patterson | 1962-09-14 | UHC-77830-85 | N/A | N/A | ···· | 9384 Lincoln Way | Minneapolis | MN | 55467 | - | SELECT-EPO |
| PRV | PRV-22610 | 2026-04-19T06:05:56Z | Paul | — | Patel | Jul 13, 1969 | - | — | ·5283493801 | ···· | 9164 Union Street | Sacramento | CA | 95802 | — | CHOICE-PLUS-PPO |
| PRV | PRV-20452 | 2026-02-21T23:24:30Z | Barnes, Amanda | — | — | 19680720 | UHC-91250-79 | — | +1 244 552 3968 | - | 1270 BAYSHORE DRIVE | Denver | CO·· | 80210 | N/A | — |
| PRV | PRV-22117 | 2026-03-27T00:52:23Z | Tyler | F | Fuller | 1985-06-16 | ·NULL | — | 16562121515 | - | 311 Church St | Los Angeles | CA | 90069 | - | — |
| PRV | PRV-23102 | 2026-08-23T02:55:00Z | HANNAH | — | RIVERA | 1967-09-15 | UHC-32282-46 | •••-••-2307 | (328) 414-6923 | hannah.rivera82@aol.com | 3233 CENTRAL AVENUE | Atlanta | Georgia | NULL | UNKNOWN | CHOICE-PLUS-PPO |
| PRV | PRV-20774 | 2026-06-13T11:51:52Z | AARON | — | HARVEY | 2001-07-05 | UHC-57296-51 | NULL | (819) 959-9752 | UNKNOWN | 5852 Apache Blvd | Glendale | AZ | UNKNOWN | UNKNOWN | — |
| PRV | PRV-23023 | 2026-04-05T15:12:14Z | Victoria | — | Ramirez | 1957-12-09 | UHC-01322-01·· | •••-••-0150 | (891) 781-5866 | null | 635 Forest Ave #652 | Sacramento | CA | 95807 | UNKNOWN | — |
| PRV | PRV-20270 | 2026-10-09T11:32:39Z | brenda | — | mitchell | 10/13/1973 | UHC-31490-89 | UNKNOWN | 7375024807 | brenda.mitchell34@hotmail.com | 194 WILLOW COURT | Minneapolis | MN | 55439 | — | — |
| PRV | PRV-25265 | 2026-07-09T11:40:02Z | Howard, Christina | ···· | — | ·1958-07-15 | - | •••-••-0194 | +1 565 643 6864 | NULL | 5406 Main St | COLUMBUS | OH | 43209 | N/A | null |
| PRV | PRV-24142 | 2026-10-01T18:23:28Z | Kathryn | F. | ·Guzman | Aug 16, 1977 | ·UHC-75140-36 | - | 7483355343 | NULL | ·29 Broadway | JACKSONVILLE | FL | ·32277 | — | null |
| PRV | PRV-28020 | 2026-04-17T01:16:15Z | CAMILA | — | PHILLIPS | 1977-11-17 | UHC-26863-57 | •••-••-6929 | 13873790587 | — | 3465 HILLCREST RD #705 | Atlanta | GA | 30305 | N/A | N/A |
| PRV | PRV-25519 | 2026-08-05T10:16:42Z | Ruth | — | Weber | 1940-05-24 | UHC-58634-65 | UNKNOWN | 6066165 | — | 9877 MARKET STREET | Glendale | AZ | 85334 | UNKNOWN | — |
| PRV | PRV-23324 | 2026-04-04T00:32:31Z | Kenneth | — | Santos | 1944-04-09 | — | NULL | 522-656-4984 | N/A | N/A | — | NULL | — | — | ···· |
| PRV | PRV-24770 | 2026-04-22T01:49:05Z | Angela | — | Fernandez | 2007-09-26 | UHC-71368-61 | •••-••-4672 | UNKNOWN | angela.fernandez@aol.com | 2503 Church St | Miami | FL | ···· | — | NAVIGATE-HMO |
| PRV | PRV-23650 | 2026-04-16T23:42:38Z | Evelyn | — | Stewart | 04-03-1997 | - | NULL | 989-485-1253 | NULL | 8320 Union Street | Atlanta | GA | 30332 | null | UNKNOWN |
| PRV | PRV-20163 | 2026-07-25T01:29:43Z | Tyler | — | Moreno·· | 1994-11-12 | UHC-79913-58 | NULL | ·(246) 291-9795 | tyler.moreno@yahoo.com | 1312 RIDGE RD | Seattle·· | WA | 98120 | ·· | MEDICARE-ADV-A |
| PRV | PRV-25700 | 2026-10-02T22:56:17Z | MADISON | — | HUNTER | 1956-09-19 | ·N/A | N/A | — | madison.hunter25@outlook.com | UNKNOWN | — | — | NULL | — | CHOICE-PLUS-PPO |
| PRV | PRV-25921 | 2026-01-12T11:40:23Z | emma | X. | meyer | 04/22/50 | ·UHC-01738-01 | — | 668.994.7215 | — | 4057 Main St | Tampa | FL | 33669 | null | - |
| PRV | PRV-22741 | 2026-10-10T20:59:24Z | Teresa·· | — | Williamson | 01/26/81 | UHC5451254 | - | (414) 216-2987 | N/A | 2913 Lincoln Way | DALLAS | TX | 75257 | - | UNKNOWN |
| PRV | PRV-23226 | 2026-05-23T03:25:10Z | Brittany | F | Munoz | 19480417 | — | UNKNOWN | 7228508677·· | UNKNOWN | 1220 Desert Sky Blvd | HOUSTON | TX | 77015-1954 | — | — |
| PRV | PRV-25922 | 2026-04-03T07:36:05Z | Gregory | — | Wagner | 1968-04-22 | — | N/A | (989) 277-6402 | — | 3175 Mesa Dr | Scottsdale | AZ | 85228 | N/A | — |
| PRV | PRV-20469 | 2026-03-18T21:52:44Z | ALICE | — | LE | 22-01-1943·· | UHC4955466 | •••-••-7682 | (578) 531-7456 | — | - | - | — | null | - | NULL |
| PRV | PRV-22123 | 2026-05-30T17:55:10Z | David | ·H. | ·Weaver | 12-12-1967 | UHC-28824-31 | NULL | 515-214-5224 | NULL | 6824 ELM STREET Apt 32 | Orlando | FL | 32867 | - | null |
| PRV | PRV-21802 | 2026-01-15T17:37:41Z | BOBBY | Q | ·MEDINA | 03/07/81 | UHC-80283-64 | •••-••-5508 | 5973759403 | bobby.medina@proton.me | 4451 DESERT SKY BOULEVARD | Charlotte | NC | 28243 | - | CORE-HMO |
| PRV | PRV-26956 | 2026-05-16T20:30:53Z | ·Franklin, Bryan | — | — | ·1981-12-17 | UNKNOWN | - | UNKNOWN | — | 325 Valley View Drive | Scottsdale | Arizona·· | 85200 | — | - |
| PRV | PRV-21095 | 2026-08-19T05:26:28Z | Victoria | — | Ford | 1988-05-02 | UHC-37553-98 | •••-••-9670 | 3696394342 | null·· | 1293 MOUNTAIN VIEW DRIVE Apt 18 | Miami | FL | 33164·· | — | CORE-HMO |
| PRV | PRV-28806 | 2026-03-06T05:43:57Z | Austin | M | Knight | 02/20/38 | UHC-16690-66 | UNKNOWN | 369-995-0770 | austin.knight@hotmail.com | 8220 Oak St·· | Minneapolis | MN | 55400 | ···· | — |
| PRV | PRV-26553 | 2026-01-10T19:20:51Z | Morris, Heather | — | — | 1949-06-10 | UHC-15441-17 | null | 9367405 | HEATHER.MORRIS60@AOL.COM·· | 1309 Willow Court | Austin·· | TX | 78751 | NULL | OPTIONS-PPO |
| PRV | PRV-23321 | 2026-08-30T15:59:36Z | ·kathleen | — | robertson | 1975-05-13 | NULL | null | (352) 281-4693 | UNKNOWN | 7407 Pine Drive | Tampa | FL | 33685 | - | UNKNOWN |
| PRV | PRV-29587 | 2026-05-25T19:33:58Z | Eugene | A. | Graham | 1950-06-16 | null | UNKNOWN | 4014915·· | eugene.graham@gmail.com | 7226 Oak Street | Atlanta | GA | 30343 | null | NAVIGATE-HMO |
| PRV | PRV-28086 | 2026-06-19T09:27:11Z | Alexis | — | Salazar·· | 2003-10-05 | UHC-58806-09 | N/A | 379-750-6143 | — | 4868 Lake View Road | LAS VEGAS | NV | 89182 | UNKNOWN | NAVIGATE-HMO |
| PRV | PRV-21962 | 2026-06-02T14:08:31Z | Judith K. | — | Daniels | 1940-03-13 | N/A | •••-••-8504 | (541) 656-2075 | judith.daniels68@aol.com | 862 SUNSET BLVD | Phoenix | AZ | 85015 | N/A | — |
| PRV | PRV-21471 | 2026-09-19T13:26:28Z | Alan | — | Rios | 2002-11-20 | UHC-32796-59 | — | (302) 551-6496 | — | - | — | — | NULL | - | MEDICARE-ADV-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:42:52.227Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty