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-21723 | 2026-01-09T13:25:43Z | Webb, Victoria | K | — | 1951-07-08 | ·UHC-59648-01 | NULL | 15186870944 | VICTORIA.WEBB@GMAIL.COM·· | 1681 Desert Sky Boulevard | Miami·· | FL | — | ·- | — |
| PRV | PRV-26611 | 2026-02-05T03:17:06Z | DAVID G. | — | HICKS | Dec 18, 1957 | ·UHC-45736-97 | null | — | null | 3403 SAGE COURT #724·· | San Diego | CA | 92159·· | UNKNOWN | ·- |
| PRV | PRV-24025 | 2026-07-14T19:32:57Z | julia | X | cunningam | 19540528 | null | •••-••-9200 | — | — | 3668 Spring Street | AUSTIN | TX | 78725 | UNKNOWN | — |
| PRV | PRV-26873 | 2026-09-03T04:41:54Z | Christine | — | Robinson | 11/19/1962 | N/A | N/A | UNKNOWN | christine.robinson96@outlook.com | 4555 Canyon Rd | Orlando | FL | 32885 | NULL | N/A |
| PRV | PRV-21129 | 2026-08-16T03:20:41Z | Noah | — | Ross | ·2000-02-10 | null | - | (573) 947-9009 | UNKNOWN | 7804 MAPLE AVENUE Apt 32 | LOS ANGELES | CA | 90050 | ·NULL | null |
| PRV | PRV-22096 | 2026-04-05T00:45:40Z | Valentina | — | Wheeler | 26-03-1944 | — | null | (432) 796-4908 | - | 7039 BROADWAY | Atlanta | GA | 30329 | — | — |
| PRV | PRV-21942 | 2026-09-06T11:49:44Z | Rachel | — | Lopez | 1939-02-07·· | ·UHC-36747-79 | — | 4019144 | — | 8989 Valley View Dr | Chandler | AZ | 85236·· | — | — |
| PRV | PRV-28440 | 2026-06-09T07:04:54Z | ZACHARY | — | GUERRERO | 19611011 | UHC-59045-42 | ·N/A | (961) 725-6423 | zachary.guerrero68@hotmail.com | 9075 DESERT SKY BLVD | CHANDLER | AZ | 85287 | — | — |
| PRV | PRV-25669 | 2026-01-06T00:01:35Z | Karen | S | Rivera | 5/22/1984 | NULL | — | 643.959.5537 | — | 9144 Ridge Rd Apt 34 | Fresno | CA | — | - | null |
| PRV | PRV-26733 | 2026-08-18T06:38:55Z | Arthur | — | Matthews | 2006-07-12 | UHC-68724-72 | •••-••-1207 | (906) 951-3209 | — | ·5542 Pine Drive | LOS ANGELES | CA | 90052 | N/A | — |
| PRV | PRV-26986 | 2026-08-14T07:54:48Z | FATIMA·· | Z | BELL | 1997-02-17 | null | •••-••-9529 | 378-396-2460 | FATIMA.BELL@OUTLOOK.COM | 3325 Harbor Boulevard | Miami | FL | 33179 | — | MEDICARE-ADV-B |
| PRV | PRV-25696 | 2026-04-20T20:10:46Z | McDonald, Theresa | A | — | 0614-02-05 | — | null | 765-792-3963 | N/A | - | N/A | — | — | — | — |
| PRV | PRV-21643 | 2026-06-02T08:16:05Z | ·robert | Z. | tucker | 19460304·· | ·UNKNOWN | — | 14466299185 | — | 7017 Baseline Rd | San Diego | CA | 92176-1118 | — | CORE-HMO |
| PRV | PRV-23392 | 2026-01-31T16:14:12Z | KIMBERLY | Y. | VAZQUEZ | 1959-02-18 | N/A·· | - | N/A | N/A | 7007 Church St | Mesa | AZ | 85246·· | -·· | N/A |
| PRV | PRV-29312 | 2026-01-07T02:46:02Z | Petr | S | Alexander | 1961-05-20 | UHC-95104-59 | UNKNOWN | 3987697238 | null | 6695 Market St | ·Orlando | FL | 32821 | null | NULL |
| PRV | PRV-20098 | 2026-09-27T21:00:15Z | Sims, Eric | — | — | 1947-06-04 | UHC-69655-07·· | — | ·253-577-2240 | NULL | — | — | null | - | null | — |
| PRV | PRV-20203 | 2026-01-17T18:40:06Z | ASHLEY | — | BROWN | 24-06-1940 | UNKNOWN | — | +1 669 679 9132 | NULL | 1274 RIDGE RD | Nashville | ·TN | 37257 | — | NULL |
| PRV | PRV-22283 | 2026-08-06T12:11:48Z | grace | D | santiago | 12/09/02 | UNKNOWN | — | (891) 923-8749 | N/A | 776 FOREST AVENUE | Seattle | ·WA | 98118 | UNKNOWN | CORE-HMO |
| PRV | PRV-23583 | 2026-08-01T22:42:21Z | STEPHANIE | — | CHAVEZ | 6/19/1967 | — | null | (492) 564-5552 | stephanie.chavez29@gmail.com | 1655 Indian School Road | Phoenix | AZ | 85056 | null | N/A |
| PRV | PRV-27359 | 2026-08-21T05:32:56Z | Moore, Ashley | — | — | ·1966-04-16 | null | NULL | (273) 903-5923 | ashley.moore@gmail.com | - | UNKNOWN | null | — | — | CHOICE-PLUS-PPO |
| PRV | PRV-22781 | 2026-08-24T12:43:11Z | Ashley | — | Scott | - | UHC-15919-77 | — | +1 444 443 2041·· | N/A | 5892 Highland Ave | HOUSTON | TX | 77016 | null | -·· |
| PRV | PRV-21569 | 2026-04-09T21:10:41Z | Diego | ···· | Bradley | 1981-06-15 | N/A | •••-••-2068 | (940) 594-8889 | diego.bradley@icloud.com | — | — | — | UNKNOWN | N/A | - |
| PRV | PRV-26661 | 2026-03-05T22:19:08Z | DYLAN | O | REID | 1943-12-05 | UHC-30535-48 | •••-••-7085 | +1 645 547 4498 | -·· | 2056 Mesa Drive | Plano | TX | 75058 | null | MEDICARE-ADV-B |
| PRV | PRV-28798 | 2026-06-08T04:23:00Z | Roger | — | ·Marquez | 1964-12-22 | uhc-62705-91·· | null | +1 308 337 8072 | NULL | 5303 Elm Street | MINNEAPOLIS | mn | 55407-5749 | N/A | NULL |
| PRV | PRV-24593 | 2026-07-03T12:59:49Z | samantha | ·N. | harris·· | 1987-07-06 | — | •••-••-2626 | N/A·· | UNKNOWN | NULL | NULL | null | null | UNKNOWN | - |
| PRV | PRV-21398 | 2026-03-22T18:46:43Z | Steven | — | Estrada | 10/15/1940 | UHC-77984-19 | NULL | (813) 970-4382 | — | 6415 BASELINE RD | Houston | TX | 77090 | UNKNOWN | — |
| PRV | PRV-25964 | 2026-09-18T03:57:19Z | dorothy | — | greene·· | 19651101 | UHC2096516 | — | N/A | null | 1956 Indian School Rd | Glendale | AZ | 85338 | — | UNKNOWN |
| PRV | PRV-25847 | 2026-06-10T22:55:10Z | Virginia | — | Delgado | 1965-02-23 | N/A | •••-••-2676 | — | null | ·7260 Union Street | Sacramento | CA | 95836 | - | NULL |
| PRV | PRV-22725 | 2026-05-06T06:59:36Z | Cheryl | ·· | Kelly | ·Dec 28, 1972 | UHC-30817-37 | - | (745) 393-1076 | UNKNOWN | ·NULL | - | null | — | NULL | N/A |
| PRV | PRV-25156 | 2026-04-07T08:06:28Z | ·ANDREW | — | ROSS | 2003-02-09 | UNKNOWN | null | 825-258-4957 | ANDREW.ROSS29@HOTMAIL.COM | 8067 MEADOW LANE | Seattle | WA | 98192 | - | — |
| PRV | PRV-27678 | 2026-07-30T10:22:03Z | WEI | ·· | ARNOLD | 1976-05-23 | UHC-93430-91 | •••-••-9878 | 593-649-6455 | wei.arnold15@outlook.com | 9213 PINE DR | Glendale | AZ | 85331 | null | NULL |
| PRV | PRV-26297 | 2026-07-11T04:24:56Z | dyln | L | bowman | 19830622·· | ·null | — | 438.697.6432 | NULL·· | 2383 CEDAR LN | Jacksonville | FL | 32237 | null | CHOICE-PLUS-PPO |
| PRV | PRV-23351 | 2026-02-09T14:42:49Z | ROGER | J | CHAVEZ | ·11/09/90 | UHC-74003-19 | ···· | 3275114423 | N/A | ·148 Jefferson Ave | Los Angeles | CA | 90077 | null | — |
| PRV | PRV-22093 | 2026-06-02T23:41:52Z | SAMANTHA | — | FREEMAN | 05/08/1977 | UHC-78622-78 | N/A | 7555115205 | — | 1512 Camelback Road | SCOTTSDALE | AZ | N/A | — | UNKNOWN |
| PRV | PRV-25273 | 2026-02-21T09:18:49Z | Harper, Brandon | — | — | 1987-08-21 | ···· | N/A | 2909477843 | — | 6652 HIGHLAND AVENUE | CHANDLER | AZ | 85297 | — | NAVIGATE-HMO |
| PRV | PRV-23398 | 2026-06-29T23:31:35Z | MARILYN | — | ·GONZALES | 1966-11-14 | UNKNOWN | •••-••-4484 | null | N/A | 5305 FOREST AVE | Sacramento | California | 95848 | — | NULL |
| PRV | PRV-22530 | 2026-03-21T21:57:28Z | RACHEL·· | — | FORD | Sep 6, 2006 | N/A·· | N/A·· | 242-469-2124 | RACHEL.FORD@ICLOUD.COM | 9233 PINE DR | MINNEAPOLIS·· | MN | 55486 | null | — |
| PRV | PRV-20087 | 2026-03-24T15:51:47Z | Eugene | — | Rose | 9147-05-14 | null | - | (781) 694-1665 | null | 4245 MAPLE AVENUE | Orlando | FL | 32846 | — | NULL |
| PRV | PRV-24988 | 2026-02-21T17:53:07Z | Jeffrey | Q. | Mendzoa | 08/12/65 | UHC-92808-15 | null | 6374715196 | jeffrey.mendoza66@outlook.com | 3159 CANYON ROAD | DALLAS | TX | 75221 | UNKNOWN | NAVIGATE-HMO |
| PRV | PRV-22709 | 2026-07-02T01:13:54Z | Walker, Brandon | H·· | — | 1966-03-01 | — | N/A | 16258159431 | null | 5607 Cedar Lane | Mesa | AZ | 85238 | — | NULL |
| PRV | PRV-22413 | 2026-07-16T16:09:33Z | Camila W | ·· | Sandoval | 1983-09-18 | UHC-60824-59 | •••-••-8523 | 459-217-9167 | camila.sandoval43@hotmail.com | 5221 Broadway Apt 16 | Seattle | WA | 98142 | — | — |
| PRV | PRV-25143 | 2026-02-21T04:46:45Z | Sean | F | Price | 1952-05-18 | — | ·· | (643) 359-0619 | ···· | 469 Apache Blvd | ·Chandler | AZ | 85296 | — | ·null |
| PRV | PRV-25894 | 2026-09-22T14:55:24Z | Kelly | — | Vasquez | 1994-11-02 | — | UNKNOWN | — | N/A | 2110 Church Street | Mesa | AZ | 85274 | N/A | — |
| PRV | PRV-22970 | 2026-09-09T00:14:26Z | MATEO | — | ·MILLS | 1941-03-17 | — | - | (477) 326-8064 | ·mateo.mills36@outlook.com | 924 Camelback Rd | Eden Prairie | MN·· | 55312 | — | — |
| PRV | PRV-21023 | 2026-08-03T20:07:53Z | JACOB·· | ···· | BROWN | 1984-09-17 | UHC-55032-13 | — | ·NULL | jacob.brown10@hotmail.com | 2479 CAMELBACK RD | Dallas·· | TX | 75297 | null | OPTIONS-PPO |
| PRV | PRV-25973 | 2026-04-30T23:12:52Z | Maria | E | Kelly | 2006-04-20 | — | ·· | ·890-446-0101 | N/A | 3877 MESA DR | ·Fresno | CA | UNKNOWN | — | ·· |
| PRV | PRV-26291 | 2026-08-26T07:07:49Z | ABIGAIL | — | CUNNINGHAM | 1938-09-28 | null | — | 18772953074 | UNKNOWN | 4046 Oak St | TAMPA·· | Florida | 33663 | null | N/A |
| PRV | PRV-24189 | 2026-10-14T15:18:42Z | Ethan | — | Walsh | 1984-12-22 | — | — | 9759648932 | — | 1433 SAGE CT | Charlotte | NC | 28268 | ·- | null |
| PRV | PRV-29252 | 2026-03-05T22:24:48Z | BLILY | R | FISHER | Jun 20, 1980·· | UHC9803027 | — | 6996269135 | BILLY.FISHER34@AOL.COM | 1611 Hillcrest Rd | ·Seattle | WA | 98155 | NULL | NULL |
| PRV | PRV-24614 | 2026-05-05T14:03:01Z | Jacqueline | — | Gonzales | 1997-03-13 | ·UHC-44443-96 | — | 5432296178 | - | 5010 Cedar Lane | Mesa | Arizona | 85226 | — | 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:53.716Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty