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-26344 | 2026-06-30T12:29:43Z | Danielle | — | Weaver | 04/25/1975 | - | — | 286-943-2840 | - | ·2761 MAPLE AVENUE Apt 38 | Houston | TX | 77011 | - | N/A |
| PRV | PRV-29197 | 2026-06-01T04:47:06Z | DENISE | — | PENA | 09/06/2001 | NULL | — | 683-844-4648 | — | 5007 Pine Drive | MIAMI | FL | 33107 | null | — |
| PRV | PRV-28247 | 2026-07-13T14:21:16Z | Meier, Ruth | — | ·· | 2005-06-19 | UHC-88349-27 | null | 864.735.8107 | ·· | - | UNKNOWN | N/A | — | UNKNOWN | — |
| PRV | PRV-27186 | 2026-02-10T12:10:17Z | Brooks, Heather | — | — | ·07/08/1978 | — | •••-••-1278 | (822) 587-8741 | heather.brooks@hotmail.com | ·8233 INDIAN SCHOOL ROAD | PLANO | TX | 75008 | NULL | — |
| PRV | PRV-22559 | 2026-08-21T14:41:30Z | Ruth | — | Robertsno | 1944-11-19 | UHC1837675 | NULL | (971) 478-4272 | UNKNOWN | 9595 RIDGE ROAD | Phoenix | AZ | 85049 | — | — |
| PRV | PRV-29078 | 2026-01-25T23:06:30Z | NANCY | C. | CONTRERAS | ·20050910 | UHC-96093-36 | — | 360-787-9742 | null | 7476 CEDAR LN | San Antonio | Texas | — | — | NAVIGATE-HMO |
| PRV | PRV-20230 | 2026-01-22T09:22:54Z | Fisher, Anna | S | — | Sep 28, 1990 | UHC-66514-15 | •••-••-6064 | (938) 446-6330 | UNKNOWN | UNKNOWN | null | — | null | UNKNOWN | null |
| PRV | PRV-23838 | 2026-09-09T01:55:43Z | Russell | V | Ramos | 1982-11-04 | null | •••-••-4758 | null | RUSSELL.RAMOS63@YAHOO.COM | 241 LINCOLN WAY·· | SAN DIEGO | CA | 92171 | — | — |
| PRV | PRV-20253 | 2026-05-10T12:55:53Z | Brandon | ·W | Russell | 19440724 | UHC-21934-36 | •••-••-6204 | N/A·· | — | 7081 MAIN ST | JACKSONVILLE | FL | 32262·· | - | N/A |
| PRV | PRV-22814 | 2026-03-23T10:00:43Z | Patrick | — | Fields | 1940-10-02 | UHC-41766-43 | — | (908) 404-6090 | — | 3044 Canyon Road·· | San Diego | CA | 92138 | NULL | - |
| PRV | PRV-22874 | 2026-01-28T05:24:23Z | Diane | — | Johnson | 12/02/61 | UHC-39148-39 | - | 2468226657 | NULL | 2253 Broadway | Tucson | AZ | 85745·· | N/A | - |
| PRV | PRV-27477 | 2026-02-26T06:02:05Z | Logan | — | ·Campbell | 12/26/83 | UHC-12459-58 | - | 3486926379 | — | 201 Central Ave | ·Atlanta | GA·· | 30336 | — | CORE-HMO |
| PRV | PRV-26884 | 2026-01-25T08:11:42Z | Joyce | — | Clark | 19490121 | UHC-03973-63 | — | 2748927201 | NULL | 9737 Sunset Blvd | Columbus | Ohio | 43279·· | NULL | - |
| PRV | PRV-20264 | 2026-09-23T13:14:52Z | Diana | — | Ross | 1985-04-21 | UHC-68670-46 | — | (466) 467-7953 | UNKNOWN | 5464 OAK STREET | Tempe | AZ·· | 85277 | NULL | - |
| PRV | PRV-21283 | 2026-10-14T15:07:37Z | Alvarez, Shirley | — | — | 1986-07-17 | UHC-51388-98 | - | UNKNOWN | shirley.alvarez67@icloud.com | — | null | — | — | N/A | UNKNOWN |
| PRV | PRV-27660 | 2026-05-05T02:44:52Z | VALENTINA | — | MORRIS | 2000-09-25 | UHC-14927-47 | •••-••-1244 | 352-431-3899 | - | NULL | — | NULL | null | UNKNOWN | MEDICARE-ADV-A |
| PRV | PRV-21812 | 2026-09-30T17:27:16Z | Kathryn | — | Ramirez | 19440502·· | — | null | ·(861) 621-2548 | - | 9294 Park Place | GILBERT | AZ | 85281 | — | — |
| PRV | PRV-27707 | 2026-08-25T00:07:47Z | Richard | — | Espinoza | 1957-05-16 | N/A | - | 5163396241 | — | 2683 Mesa Drive | Seattle | WA | 98161 | UNKNOWN | ·null |
| PRV | PRV-21211 | 2026-10-10T07:59:20Z | Charlotte | — | Dunn | 10/01/87 | — | — | - | NULL | 6874 Broadway | Denver | CO | 80250 | NULL | — |
| PRV | PRV-27811 | 2026-04-17T11:09:49Z | Ahmed | J. | Hoffman | 1987-02-08 | ·null | •••-••-8294 | (769) 688-9136 | AHMED.HOFFMAN@PROTON.ME | 7858 Spring Street | Gilbert | AZ | 85296 | - | UNKNOWN |
| PRV | PRV-29350 | 2026-05-31T20:36:24Z | Jacqueline | — | Sandoval·· | 19541117 | — | — | 7052189275 | N/A·· | — | UNKNOWN | ···· | null | null | - |
| PRV | PRV-25022 | 2026-02-20T00:17:19Z | KAREN | — | NUNEZ | 1964-07-26 | UHC-53022-61 | — | 3893833489 | — | 315 INDIAN SCHOOL ROAD | ·Atlanta | Georgia | 30324-0428 | UNKNOWN | NULL |
| PRV | PRV-24479 | 2026-10-02T19:21:21Z | BETTY | ·W | ROMERO | 1970-01-02 | — | N/A | (555) 287-4995 | NULL | 5730 Union Street | Tucson | AZ | 85777 | - | ·N/A |
| PRV | PRV-26471 | 2026-10-10T11:44:31Z | Ryan | — | Nuneez | 1950-10-06 | — | - | 6953116420 | ryan.nunez@icloud.com | 3715 RIVER ROAD | Sacramento | CA | ·NULL | — | — |
| PRV | PRV-21535 | 2026-04-02T18:16:06Z | Danielle | — | Jackson | 1954-10-11 | null | null | +1 265 293 8377·· | DANIELLE.JACKSON14@YAHOO.COM | 3506 Spring Street | DENVER | CO | 80238 | NULL | — |
| PRV | PRV-22022 | 2026-02-03T09:10:20Z | Walter·· | — | ·Bryant | 1946-05-12 | UNKNOWN | ·NULL | 601.388.6323 | ·null | 5632 PINE DRIVE | ·Houston | TX | 77021 | UNKNOWN | — |
| PRV | PRV-27802 | 2026-06-04T14:22:58Z | WEAVER | F | ·MARGARET | N/A | — | — | 379-211-2495 | MARGARET.WEAVER39@ICLOUD.COM | 3370 Mountain View Drive | Phoenix | AZ | 85092 | — | N/A |
| PRV | PRV-28689 | 2026-02-03T01:22:03Z | BARBARA | ···· | OWENS | Jun 24, 2002 | — | — | (595) 349-0383 | null | 4882 Church Street | Chandler | AZ | 85256 | - | — |
| PRV | PRV-22048 | 2026-02-15T21:49:57Z | DIANA·· | — | RAMOS | 1994-10-07 | UHC-98291-09 | NULL | 7007448006 | UNKNOWN | 8705 PINE DRIVE | ATLANTA | GA | 30335 | — | NAVIGATE-HMO |
| PRV | PRV-23626 | 2026-01-02T06:09:50Z | Jason | E | ·Gutirerez | 1971-06-19 | UHC-26533-02·· | — | 371-418-7582 | JASON.GUTIERREZ47@AOL.COM | 4563 MESA DR | Glendale | AZ | 85302 | N/A | — |
| PRV | PRV-20960 | 2026-06-12T17:02:45Z | Kevin·· | U | Price | 1963-08-28 | uhc-73391-84 | ·· | N/A | — | — | — | null | - | null | NULL |
| PRV | PRV-22200 | 2026-10-18T05:22:25Z | Christopher | X. | Adams | 26-06-1956 | null | — | +1 343 321 2790 | NULL | 4764 SPRING STREET | Atlanta | GA | 30333 | - | — |
| PRV | PRV-25842 | 2026-09-28T23:19:56Z | Olivai | — | Arnold | May 23, 1940 | - | UNKNOWN | — | — | 824 Forest Avenue | Plano | Texas | 75049 | - | — |
| PRV | PRV-25719 | 2026-10-16T08:18:53Z | Christina | — | ·Morgan | 2007-03-17 | NULL | — | — | N/A | 5927 Cedar Ln | Phoenix | az | 85021 | — | N/A |
| PRV | PRV-29319 | 2026-06-29T20:33:06Z | charles | I. | stevens | 2004-01-25 | — | null | 13586152962 | - | 9425 Jefferson Ave | Atlanta | GA | 30382 | - | core-hmo |
| PRV | PRV-24060 | 2026-07-24T19:12:56Z | Nancy | ···· | Millls | Jul 20, 1981·· | UHC-00702-28 | N/A | 470-638-9323 | NULL | 7380 OAK ST | CHARLOTTE | NC | 28244-5412 | ···· | null |
| PRV | PRV-23221 | 2026-02-11T11:48:38Z | JEAN | U. | THOMAS | 1942-09-05 | — | — | - | jean.thomas@yahoo.com | 2362 MESA DR | Tempe | AZ | 85209 | — | NULL |
| PRV | PRV-27835 | 2026-03-16T10:20:35Z | ISABELLA | — | LOPEZ | Feb 10, 1942 | — | N/A | 6059015188 | - | 2688 Maple Avenue | NASHVILLE·· | Tennessee | 37280-8888·· | - | — |
| PRV | PRV-28478 | 2026-04-10T14:25:59Z | KELLY | B | CONTRERAS | 2004-02-22 | ·null | •••-••-0119 | 875-971-0356 | null | 6369 Maple Ave | Eden Prairie | MN | 55346 | — | N/A |
| PRV | PRV-20049 | 2026-07-05T19:30:26Z | JANET | — | REYNOLDS | 2006-01-25 | - | •••-••-6376 | ·(483) 815-5220 | JANET.REYNOLDS90@GMAIL.COM | 2291 CENTRAL AVE | Dallas | Texas | 75275 | - | UNKNOWN |
| PRV | PRV-22425 | 2026-01-01T15:47:52Z | Natalie | — | Medina | 05/23/1972 | UHC-72744-31 | •••-••-7700 | +1 397 290 0505 | UNKNOWN | 3602 Sunset Boulevard | ·Tampa | FL | 33623 | — | UNKNOWN |
| PRV | PRV-21279 | 2026-03-09T04:33:19Z | Kelly | G. | Baker | ·8/28/2006 | UHC-48249-92 | •••-••-0130 | (278) 685-9756 | — | 4218 Sunset Blvd | SAN DIEGO | CA·· | — | - | — |
| PRV | PRV-20966 | 2026-05-13T21:20:17Z | EMMA | E | CASTILLO | 1949-12-25 | UHC-27180-71 | UNKNOWN | 4919581776 | emma.castillo24@hotmail.com | 382 Highland Ave | San Diego | CA | 92131 | null | — |
| PRV | PRV-29187 | 2026-07-09T14:38:46Z | WEI | — | COOPER | 1953-10-25 | UHC-84241-56 | •••-••-8848 | (705) 608-8883 | UNKNOWN | 5751 RIVER ROAD | Chandler | AZ | 85261 | - | — |
| PRV | PRV-27399 | 2026-02-05T11:19:48Z | Isabella | — | Turner | 1957-01-04 | — | ·- | 662-577-8854 | - | null | N/A | — | NULL | UNKNOWN | - |
| PRV | PRV-25196 | 2026-08-17T21:29:41Z | Albert | — | Cruz | 1991-04-19 | null·· | null | NULL·· | — | ·8046 CAMELBACK RD | Seattle | WA | 98137 | N/A | — |
| PRV | PRV-28276 | 2026-08-31T11:31:16Z | Joan | — | Vazquez | 1958-10-06 | UNKNOWN | — | (395) 964-8074 | null | 2813 Valley View Drive | ·Chandler | AZ | 85283 | null | OPTIONS-PPO |
| PRV | PRV-25018 | 2026-04-25T20:27:32Z | PHILIP | — | ·MEJIA | 1940-07-22 | NULL | UNKNOWN | 3108702256 | — | 6716 Central Avenue | PLANO·· | Texas | 75019·· | N/A | null |
| PRV | PRV-22619 | 2026-02-19T12:45:21Z | Nicole | — | Arnold | 1998-05-01 | — | UNKNOWN | 912.222.2367 | nicole.arnold@aol.com | 7966 MARKET ST | Fresno | CA | 93733-9326 | — | N/A |
| PRV | PRV-25088 | 2026-04-06T02:58:13Z | Albert | — | Schultz | 1939-12-06 | — | — | 9186930633 | UNKNOWN | ·8850 Hillcrest Road | Columbus | OH | 43219 | 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:00.522Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty