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-28368 | 2026-09-16T00:22:33Z | ·paul | Y | ross | 1893-09-13 | UHC-15295-38·· | UNKNOWN | — | UNKNOWN | 3208 LINCOLN WAY | Plano | TX | 75029-0248 | — | UNKNOWN |
| PRV | PRV-27215 | 2026-08-24T06:40:07Z | JAMES | Y. | DELGDO·· | 1967-08-17 | — | •••-••-5852 | (508) 263-5398 | — | 3875 Mountain View Drive | Orlando | FL | 32838 | — | — |
| PRV | PRV-22387 | 2026-04-18T04:37:31Z | Kimberly | — | — | 1993-05-03 | UHC-01765-28 | N/A·· | 17988648692 | NULL | 4122 MARKET STREET | Dallas | TX | 75257 | - | ·N/A |
| PRV | PRV-23646 | 2026-06-04T07:34:56Z | Stephen | — | Hoffman | 2007-05-08 | — | — | +1 958 633 6505 | null | — | - | UNKNOWN | N/A | — | MEDICARE-ADV-B |
| PRV | PRV-29297 | 2026-09-10T16:44:12Z | Samuel | — | Richards | 1984-02-14 | — | null | 264-545-3770 | UNKNOWN | 2173 Mountain View Drive | Phoenix | AZ | 85006 | — | — |
| PRV | PRV-21302 | 2026-09-12T23:11:58Z | PATRICIA | ·T. | GONZALES | 2002-07-18 | UHC-73800-42 | ···· | - | NULL | 5925 Cedar Lane | Minneapolis | Minnesota | NULL | UNKNOWN | — |
| PRV | PRV-23793 | 2026-07-15T04:17:14Z | Joyce·· | K | Fisher | 01-05-1974 | UHC7128023 | •••-••-4755 | 642-482-9456 | ·NULL | 6729 Washington St | Chandler | AZ | 85205 | N/A | UNKNOWN |
| PRV | PRV-27401 | 2026-10-16T22:43:33Z | Eric | — | Fowler | 2000-03-07 | UHC1186383 | ·UNKNOWN | 631.535.5894 | UNKNOWN | 3681 Market Street | Denver·· | CO | 80281 | NULL | UNKNOWN |
| PRV | PRV-28875 | 2026-09-08T10:03:43Z | LAURA | — | WARREN·· | Jul 17, 2001 | uhc-80409-15 | UNKNOWN | 238.237.9361 | null | 3061 Cedar Lane | Chandler | ·AZ | 85214 | UNKNOWN | — |
| PRV | PRV-20089 | 2026-04-29T10:27:48Z | Rebecca | F | Little | 1941-01-15 | UHC-55146-08 | ·UNKNOWN | ·N/A | N/A | 7903 Desert Sky Boulevard | Austin | TX | 78722 | null | — |
| PRV | PRV-21127 | 2026-05-25T16:16:48Z | ·Diana | J | Russell | 01/05/99 | — | •••-••-7408 | — | N/A | 3778 Apache Boulevard | Tempe | AZ | 85228 | — | - |
| PRV | PRV-25695 | 2026-02-03T22:28:08Z | Cynthia | — | Lopez | 2003-11-17 | — | - | 331-972-5403 | ·cynthia.lopez@aol.com | 4377 Washington St | Austin | Texas | 78715 | - | N/A |
| PRV | PRV-28870 | 2026-07-11T15:04:35Z | Deborah | — | Gordon | 1995-09-18 | UHC-25449-95 | UNKNOWN | 3019583669 | N/A | 5176 Mesa Drive | ·San Diego | CA | 92158 | null | null |
| PRV | PRV-24752 | 2026-10-08T15:10:50Z | Mark | ···· | Hart | 9186-01-20 | - | N/A | 18049933833 | ···· | 9124 Park Place | Atlanta | ·GA | 30313 | null·· | N/A |
| PRV | PRV-27016 | 2026-04-16T17:59:59Z | calros | — | jenzen | 06/19/88 | NULL | null | UNKNOWN | — | 5801 Canyon Rd Apt 38 | Tucson | AZ | 85700·· | N/A | null |
| PRV | PRV-24001 | 2026-06-22T19:04:04Z | jerry | — | vasquez | 1939-08-13 | UNKNOWN | NULL | ·638-957-2398 | jerry.vasquez@gmail.com | ·6965 CAMELBACK RD | Tampa | FL | 33681 | null | - |
| PRV | PRV-29473 | 2026-02-18T08:31:57Z | SOPHHIA | — | BURNS | 1965-11-15 | ·· | •••-••-0073 | null | sophia.burns60@aol.com | 9399 BASELINE RD | Tempe | AZ | 85280 | — | - |
| PRV | PRV-27170 | 2026-08-16T05:09:49Z | pamela | ·· | taylor | 1964-10-09 | - | - | 5728062649 | N/A | 6513 Mountain View Dr | Denver | CO | 80237 | UNKNOWN | null |
| PRV | PRV-20160 | 2026-06-28T05:48:05Z | MADISON | F | COOK | 01/25/60 | - | •••-••-0581 | ·4014081478 | - | 8386 Spring Street·· | TUCSON | AZ | 85738-9497 | — | null |
| PRV | PRV-22415 | 2026-09-12T16:06:59Z | SUFIA | — | SMITH | ·1978-12-13 | — | — | (809) 764-5285 | sofia.smith@yahoo.com·· | 7046 Market St | Las Vegas | NV·· | 89158·· | UNKNOWN | null |
| PRV | PRV-25269 | 2026-02-12T04:34:35Z | Mason | — | Rose | 12-06-1948 | UHC-72109-49 | — | (653) 959-0695 | mason.rose@proton.me | 1468 Central Ave | PHOENIX | Arizona | 85021 | — | - |
| PRV | PRV-28859 | 2026-10-08T21:47:13Z | GARY | — | ·HUNT | 03/16/1951 | UHC-70975-49 | — | 2885966179 | gary.hunt@icloud.com | — | null | N/A | NULL | - | NULL |
| PRV | PRV-24291 | 2026-10-15T15:14:48Z | ALAN | J. | ELLIS | ·Jan 13, 1946 | ···· | UNKNOWN | 942-722-0019 | N/A | 491 Mesa Drive·· | Gilbert | AZ | 85284 | ·null | - |
| PRV | PRV-21841 | 2026-05-08T19:20:33Z | Sarah·· | N. | Smith | Nov 13, 1994 | ·NULL | — | +1 970 922 7611 | - | N/A | UNKNOWN | — | UNKNOWN | — | options-ppo |
| PRV | PRV-26152 | 2026-08-17T15:44:27Z | MARIANA | U. | JACKSON | 1992-11-20 | ·- | •••-••-3344 | 499-631-0529·· | — | 8346 PALM DRIVE | Austin | TX | — | N/A | — |
| PRV | PRV-25467 | 2026-01-08T13:25:26Z | Dunn, Bruce | S | — | 11/25/1962 | UHC-09543-24 | N/A | 16733786713 | — | 805 Grand Ave | Gilbert | AZ | 85235 | UNKNOWN | null·· |
| PRV | PRV-26822 | 2026-05-02T09:50:08Z | ARTHUR | — | JIMENEZ | 02/01/2001 | UHC-75581-43 | UNKNOWN | 7044303301 | ARTHUR.JIMENEZ@ICLOUD.COM·· | 4586 Lake View Road | EDEN PRAIRIE | Minnesota | 55342 | ·· | -·· |
| PRV | PRV-28671 | 2026-06-29T20:16:37Z | KEVIN·· | — | PATEL | 11/19/1986 | — | UNKNOWN | ·380.359.8482 | kevin.patel@proton.me | 6854 PARK PLACE | Seattle | wa | 98140 | UNKNOWN | NULL |
| PRV | PRV-27803 | 2026-02-27T02:48:10Z | Carlson, Cynthia | ·D. | — | 07/15/97 | N/A | N/A | 3745851258 | NULL | 4545 Park Place | Chandler | AZ | 85297 | NULL | N/A |
| PRV | PRV-24624 | 2026-03-28T08:02:49Z | DEBORAH | — | HAMILTON | Mar 5, 1963 | null | NULL | 834-989-4965 | ···· | 4385 Highland Avenue | Austin | TX | 78721 | — | — |
| PRV | PRV-20771 | 2026-04-16T14:21:34Z | ·Ken | — | Perkins | 1996-07-07 | UHC-46973-89 | — | — | KENNETH.PERKINS@HOTMAIL.COM | 6141 Maple Avenue | Glendale | AZ·· | 85301-8353 | ·null | null |
| PRV | PRV-21545 | 2026-01-29T01:57:33Z | ADAM | — | SPENCER | 1959-01-01 | - | null·· | 216.738.2345 | - | 8509 Mesa Drive | Columbus | OH | 43280 | NULL | NULL |
| PRV | PRV-29403 | 2026-03-03T16:52:37Z | Christian | G. | Meedina | 1970-02-20 | UHC-32287-16·· | null | 2992397827 | ·christian.medina52@outlook.com | ·4608 PINE DR | Charlotte | NC | 28247 | - | null |
| PRV | PRV-25853 | 2026-07-22T03:24:37Z | DAVID | — | ·WARD | 1993-02-40 | — | — | (460) 359-2942 | UNKNOWN | 1937 Baseline Rd | MESA | ·AZ | 85232 | — | UNKNOWN |
| PRV | PRV-20531 | 2026-05-19T00:51:31Z | ·Anna | K | King | 1941-01-11 | UHC-76044-90 | •••-••-9511 | 550-701-2262 | NULL | 251 MAIN ST | EDEN PRAIRIE·· | MN | 55323 | null | CHOICE-PLUS-PPO |
| PRV | PRV-21865 | 2026-04-01T21:34:40Z | Larson, Jessica | — | — | 1995-02-09 | UNKNOWN | ···· | 5963489032 | — | 3604 Maple Ave #500 | Las Vegas | Nevada | — | — | — |
| PRV | PRV-26637 | 2026-10-06T01:12:54Z | STEPHEN | ···· | MURPHY | 2002-07-19·· | UNKNOWN | - | 271-477-5640 | NULL | 5656 Central Avenue | Atlanta | Georgia | — | — | N/A |
| PRV | PRV-20285 | 2026-05-01T03:19:14Z | DONNA | H. | SANCHEZ | 09/22/79 | UHC-51598-69 | N/A | (559) 937-0001·· | null | 2472 Harbor Blvd | Scottsdale | ·AZ | 85225 | — | null |
| PRV | PRV-21067 | 2026-02-05T21:44:15Z | Christina | A | Rice | 1951-10-22 | UHC-34431-50 | UNKNOWN | 5904631125 | — | 3889 Mountain View Dr #667 | Gilbert | AZ | 85286 | — | CHOICE-PLUS-PPO |
| PRV | PRV-26508 | 2026-01-11T16:15:48Z | Kimberly | G | Hoffman·· | 03/15/49·· | N/A | •••-••-6907 | NULL | KIMBERLY.HOFFMAN@ICLOUD.COM | ·1843 MOUNTAIN VIEW DRIVE | Houston | TX | 77025 | ·· | MEDICARE-ADV-A |
| PRV | PRV-20958 | 2026-08-11T19:20:30Z | Doris | — | Sullivan | 1938-05-11 | UHC-02605-16 | •••-••-3033 | (277) 654-4676 | UNKNOWN | 2615 Park Place·· | Atlanta | GA | 30380 | UNKNOWN | — |
| PRV | PRV-26722 | 2026-01-31T16:54:59Z | Turner, Terry | A | — | 11/01/1971·· | UNKNOWN | - | (273) 779-8336 | - | 1573 PARK PLACE Apt 38 | ·Eden Prairie | MN | 55331 | — | null |
| PRV | PRV-22882 | 2026-01-11T06:53:54Z | JESS | — | FOX | May 8, 1991 | ·· | null | (493) 229-1787 | NULL | ·2148 Apache Blvd | Jacksonville | Florida | 32241 | UNKNOWN | NULL |
| PRV | PRV-23334 | 2026-01-28T03:01:29Z | Julie | — | Chen | 1981-10-26 | UHC-35660-93 | UNKNOWN | 6966381928 | N/A | 6058 CHURCH STREET #437 | Dallas·· | Texas | 75259 | — | MEDICARE-ADV-B |
| PRV | PRV-25724 | 2026-01-08T00:10:38Z | Lisa | — | Hudson | 1950-71-10 | UHC-49171-42 | — | 719-276-3236 | lisa.hudson@yahoo.com | 19 Broadway | Phoenix | AZ | 85068 | N/A | null |
| PRV | PRV-28034 | 2026-03-11T01:14:19Z | DEBORAH | — | PERY | 1942-09-28 | UHC-90537-38·· | N/A | 4816085049 | DEBORAH.PERRY19@AOL.COM | 1929 OAK STREET | Fresno | CA | 93777 | — | — |
| PRV | PRV-20877 | 2026-07-04T12:37:32Z | ANDREW | — | LITTLE | 1958-05-10·· | UHC-87409-19 | •••-••-4031 | 594-667-3145 | UNKNOWN | 7294 Spring Street | Chandler | az | 85257 | — | null |
| PRV | PRV-21994 | 2026-06-21T05:09:52Z | Bradley·· | B | Russell | 07/16/00 | UHC-45171-11 | UNKNOWN | (274) 992-2193 | — | 5244 Valley View Dr | Minneapolis | MN | 55446-9960 | — | — |
| PRV | PRV-23329 | 2026-10-14T11:06:01Z | JACK N | — | CRATER | 1997-04-23 | NULL | NULL | 693.940.0690 | — | 9198 Mountain View Drive | Tucson | AZ | 85754 | ·- | — |
| PRV | PRV-25169 | 2026-07-15T03:29:19Z | DONNA | A | EVANS | Nov 1, 1960 | ·UHC-46623-02 | •••-••-7474 | (520) 621-6393 | — | 4193 Forest Ave | Denver | CO | 80216 | ·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-19T19:54:25.571Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty