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-23295 | 2026-01-01T02:25:48Z | LINDA | R | ROSE | 19900615 | UHC9239993·· | - | ·576-991-7260 | NULL | 9242 Mesa Drive #670 | EDEN PRAIRIE | Minnesota | 55314 | N/A | - |
| PRV | PRV-23311 | 2026-05-18T07:27:18Z | Jordan | — | Bowman | 10-09-1977 | null·· | null | +1 389 749 1542 | UNKNOWN | 732 Bayshore Dr·· | Jacksonville | FL | 32291 | N/A | UNKNOWN |
| PRV | PRV-20134 | 2026-06-10T15:11:31Z | Sarah | — | Patterson | ·2000-04-06 | UHC-49912-64 | ·UNKNOWN | (609) 753-6003 | NULL·· | N/A | — | — | - | — | N/A·· |
| PRV | PRV-21656 | 2026-07-22T11:02:03Z | Carpenter, Anna | — | — | 02/03/1952 | UHC-11448-93 | — | — | N/A | 5759 River Road | JACKSONVILLE | FL | N/A | — | — |
| PRV | PRV-28843 | 2026-06-01T06:04:00Z | Kennedy, Kyle | — | ·· | 2/14/1994 | UHC-77184-96 | — | 5887905978 | KYLE.KENNEDY36@PROTON.ME | 357 Canyon Rd | EDEN PRAIRIE | MN | 55387 | N/A | null·· |
| PRV | PRV-22592 | 2026-02-17T21:59:54Z | Aisha | Z. | Hernandez | 1983-11-18 | — | null | (394) 713-1223 | N/A | NULL | NULL | UNKNOWN·· | NULL | — | — |
| PRV | PRV-20613 | 2026-01-20T09:14:04Z | ·Mateo | D. | Olson | 1957-06-04 | UHC-93325-81 | ·- | 894-221-6360 | ·N/A | 7391 Broadway | Mesa | AZ | 85251 | — | — |
| PRV | PRV-22314 | 2026-05-20T07:52:08Z | Emily | — | Ellis | 01/27/01 | UHC-19306-54 | null | 931-595-9115 | ···· | 321 SAGE COURT | ·Austin | TX | 78748 | NULL | - |
| PRV | PRV-24048 | 2026-03-25T12:24:47Z | Barb·· | — | Shaw | 19-03-1954 | UNKNOWN | •••-••-2946 | 805-292-3555 | — | ···· | N/A | — | — | ·UNKNOWN | MEDICARE-ADV-B |
| PRV | PRV-22120 | 2026-05-22T09:42:24Z | Beverly | E | Burns | 1955-03-05 | UNKNOWN | •••-••-6231 | (592) 274-8806 | NULL | 9202 PALM DR | Seattle | WA | 98198 | N/A | — |
| PRV | PRV-25730 | 2026-04-13T22:47:55Z | VINCENT | C | DIXON | 07/10/1985 | UHC-85495-07 | •••-••-6002 | 2163164367 | vincent.dixon@hotmail.com | 7753 Pine Dr | SEATTLE | WA | 98140 | - | null |
| PRV | PRV-25580 | 2026-03-22T07:48:45Z | Sophia | — | Evans | Dec 27, 1974 | UHC4484473 | — | 8026281086 | N/A | 9437 Sunset Blvd | CHANDLER | AZ | 85230 | — | OPTIONS-PPO |
| PRV | PRV-27222 | 2026-01-16T08:19:46Z | Noah | ···· | Dixon | 1968-05-24 | — | UNKNOWN | +1 526 781 7748 | NOAH.DIXON90@AOL.COM | null | — | UNKNOWN | — | — | NULL |
| PRV | PRV-22143 | 2026-09-22T08:54:23Z | Pamela | — | Long | ·19720414 | — | NULL | - | NULL | 4895 Pine Dr | Atlanta | GA | 30312 | — | ·- |
| PRV | PRV-28485 | 2026-05-20T13:02:35Z | arthur | R | johnson | 04/15/54 | ·· | NULL | (895) 433-4474 | arthur.johnson@hotmail.com | 8934 FOREST AVENUE | Los Angeles | ca | 90099 | — | UNKNOWN |
| PRV | PRV-28146 | 2026-09-09T09:32:03Z | Benjamin | I | Walsh | 1994-02-10 | UHC-49322-36 | - | — | null | 6739 Union Street·· | MESA | AZ | 85207 | NULL | - |
| PRV | PRV-22775 | 2026-05-13T13:05:15Z | BECKY | — | CAMPBELL | 1953-50-09 | UHC-35903-72 | •••-••-5216 | 7623964285 | ·UNKNOWN | 5109 Indian School Rd | Dallas | TX | 75253 | NULL | — |
| PRV | PRV-22086 | 2026-07-16T21:41:12Z | Pamela | — | Mitchell | 1997-11-08 | UHC-76970-81 | NULL | 3541894 | pamela.mitchell@icloud.com | 5418 River Road | Phoenix | AZ | 85073 | UNKNOWN | UNKNOWN |
| PRV | PRV-23156 | 2026-01-08T15:28:39Z | NOAH | — | SCTOT·· | 1995-03-20 | UNKNOWN·· | •••-••-9151 | 763-584-6302 | — | 8854 Mountain View Dr | San Diego | CA | 92129-0086 | N/A | UNKNOWN |
| PRV | PRV-28435 | 2026-03-27T00:58:42Z | Hiroshi | — | Herrera | 1978-01-23 | N/A | - | - | - | 4577 Union St | Plano | tx | 75018 | UNKNOWN | null |
| PRV | PRV-27742 | 2026-08-27T21:16:06Z | WEI | Z. | GREENE | 3/9/1997 | UHC-56726-05 | NULL | — | — | null | ···· | N/A | — | UNKNOWN | null |
| PRV | PRV-22823 | 2026-08-09T22:43:31Z | Ortega, Grace·· | — | — | Nov 15, 1965 | — | — | 18504233760 | - | 6367 Elm St | Los Angeles | CA | 90082 | N/A | — |
| PRV | PRV-20570 | 2026-02-15T23:47:13Z | Amy | — | Dunn | 1978-04-25 | UHC-33934-78 | ·· | 948-951-3000 | amy.dunn@icloud.com | - | UNKNOWN | ···· | - | NULL | — |
| PRV | PRV-27518 | 2026-06-06T00:36:44Z | ·AARON | — | WATKINS | 19671208 | — | — | - | aaron.watkins@outlook.com | N/A | null | — | null | ·null | — |
| PRV | PRV-27915 | 2026-06-12T11:34:41Z | Munoz, Ranndy | — | — | 2003-09-18 | UHC-21023-01 | ·· | (343) 689-3410 | randy.munoz@outlook.com | — | UNKNOWN | - | UNKNOWN | — | CHOICE-PLUS-PPO |
| PRV | PRV-20204 | 2026-05-27T22:47:52Z | Brandon | — | Jackson | 1938-03-22 | null | •••-••-3092 | 2214017 | — | 9363 Bayshore Drive | ATLANTA·· | GA | 30335 | ···· | NULL |
| PRV | PRV-22879 | 2026-06-29T07:42:44Z | Linda | — | Lawrence | ·05/16/1940 | null | — | 873-589-0123 | linda.lawrence@hotmail.com | 9391 INDIAN SCHOOL ROAD | Scottsdale | AZ | 85237-8451 | — | N/A |
| PRV | PRV-26775 | 2026-03-15T13:31:48Z | Elijah | — | Rodriguez | 9143-10-08 | NULL | — | 8889313453 | ELIJAH.RODRIGUEZ83@HOTMAIL.COM | 5994 UNION ST | CHARLOTTE | NC | 28280 | - | N/A |
| PRV | PRV-28862 | 2026-08-07T17:01:36Z | — | — | — | 03/14/2006 | — | NULL | +1 492 873 1767 | ···· | 8767 HARBOR BLVD·· | Sacramento | CA | null | - | N/A |
| PRV | PRV-25122 | 2026-04-03T15:15:49Z | Brittany | — | ·Aguilar | 16-11-2000 | - | NULL | (748) 264-4177 | N/A | — | N/A | — | — | UNKNOWN | null |
| PRV | PRV-21396 | 2026-02-03T16:30:35Z | Diego | S | Espinoza | 1992-02-11 | UHC-74540-68 | UNKNOWN | N/A | diego.espinoza89@outlook.com | 6172 Willow Ct | HOUSTON | TX | 77062 | — | — |
| PRV | PRV-28902 | 2026-10-16T08:50:27Z | CHRISTINA | N | EVANS | 12/04/1944 | UHC-35274-45 | null | ·- | ···· | 6102 CAMELBACK RD | Jacksonville | FL | 32212 | NULL | — |
| PRV | PRV-20307 | 2026-04-10T09:05:54Z | Joseph | — | Gilbert | 07/21/46 | N/A | — | (351) 321-3461 | — | — | NULL | - | null | NULL | UNKNOWN |
| PRV | PRV-24014 | 2026-06-08T10:51:17Z | HEATHER | Q | SCHULTZ | 2003-12-09 | uhc-31606-78 | null | — | - | ·8354 BASELINE RD | TUCSON | AZ | 85745 | - | ···· |
| PRV | PRV-28838 | 2026-10-16T21:31:08Z | CATHEERINE | ···· | RILEY | 11/09/1999 | UHC-20404-24 | UNKNOWN | 5239039881 | — | 7227 Canyon Road | Mesa | AZ | 85254 | null·· | — |
| PRV | PRV-24316 | 2026-04-25T16:04:22Z | BENJAMIN | U | HANSEN | ·12/09/1939 | null | •••-••-5185 | 432-307-7747 | - | 723 LINCOLN WAY | Scottsdale | AZ | 85276 | N/A | - |
| PRV | PRV-22391 | 2026-05-12T13:48:48Z | SARAH·· | — | MARSHALL | 1941-06-20 | NULL | - | (541) 789-1031 | SARAH.MARSHALL@GMAIL.COM | 4580 River Road | TUCSON | AZ | 85708 | — | MEDICARE-ADV-B |
| PRV | PRV-21494 | 2026-10-12T20:07:58Z | EMMA | O | ·RED | 1991-06-07 | N/A | NULL | null | emma.reed49@gmail.com | 161 Desert Sky Blvd·· | Charlotte | North Carolina | 28294 | — | NULL |
| PRV | PRV-21168 | 2026-08-11T06:13:30Z | Padilla, Betty | — | ·· | Sep 12, 1979 | UHC-00259-16 | NULL | 764-837-2199 | ·NULL | 7491 CANYON ROAD | Tampa·· | FL | 33609 | — | NULL |
| PRV | PRV-28050 | 2026-04-16T16:25:32Z | MARIA | W | MUNOZ | 1966-03-01 | NULL | UNKNOWN | +1 574 775 6207 | — | 8893 Sage Court | Minneapolis | mn | 55424 | — | -·· |
| PRV | PRV-28551 | 2026-06-03T21:03:24Z | Anna | — | Perkins | 1942-07-14 | ·UHC-23998-35 | — | 3692099308 | — | 824 Indian School Rd | Chandler | AZ | 85275 | — | — |
| PRV | PRV-21565 | 2026-05-22T23:03:49Z | LOGAN | — | CRUZ | 1999-04-07 | UNKNOWN | N/A | 4067299591 | UNKNOWN | 9725 Oak St | SAN ANTONIO | TX | 78216 | ·null | — |
| PRV | PRV-22601 | 2026-01-18T06:44:32Z | Jerry | — | Butler | 1964-11-15 | — | N/A | ·(441) 491-0136 | jerry.butler@gmail.com | 467 Indian School Rd #319 | Mesa | AZ | 85268 | ·N/A | N/A |
| PRV | PRV-27158 | 2026-01-13T18:11:33Z | Carpenter, Brneda | — | — | 1953-05-23 | — | ·null | 335.443.2906 | brenda.carpenter53@hotmail.com | - | — | — | UNKNOWN | — | null |
| PRV | PRV-24804 | 2026-01-01T15:04:02Z | Danielle | — | Singh | Dec 10, 2002 | ·UHC-69592-89 | — | 5546362564 | danielle.singh78@gmail.com | 46 Baseline Rd | Eden Prairie | MN | 55392 | ·· | null |
| PRV | PRV-20895 | 2026-09-18T23:22:39Z | CARLOS | Z | DAVIS | Oct 11, 1969 | — | N/A | ·924-890-4846 | — | 7596 INDIAN SCHOOL ROAD | Phoenix | AZ | 85098 | — | — |
| PRV | PRV-25846 | 2026-02-12T19:29:51Z | JESSE | — | PENA | 1982-07-12 | — | UNKNOWN | null | jesse.pena@yahoo.com | 9522 OAK STREET | ·Las Vegas | NV | 89171 | - | null |
| PRV | PRV-21425 | 2026-06-12T01:13:24Z | GABRIEL | ·· | OWENS | 12/11/92 | N/A | ·NULL | +1 366 665 4353 | N/A | 5073 Desert Sky Blvd | Houston | TX | 77041·· | — | — |
| PRV | PRV-29423 | 2026-04-03T22:11:19Z | Bryan | — | Vargas | 1991-01-19 | UHC-24573-21 | •••-••-8150 | 4569016596 | null | 6311 Sunset Blvd | LAS VEGAS | NV | 89101 | ···· | OPTIONS-PPO |
| PRV | PRV-20429 | 2026-08-19T07:17:14Z | Carol | P | Powell | 10/05/1948 | N/A | N/A | (933) 393-4679 | carol.powell@outlook.com | 6617 Highland Avenue | Tucson | ·AZ | 85764-3532 | null | OPTIONS-PPO |
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.612Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty