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-26149 | 2026-03-21T04:13:23Z | LAURA | — | MENDOZA·· | 10-04-2001 | UHC-72770-86 | — | — | laura.mendoza@proton.me | 5539 OCEAN AVE | Mesa | AZ | 85297 | null | NULL |
| PRV | PRV-25614 | 2026-07-04T09:42:01Z | Matthew | — | Nunez | 5/13/1969 | — | •••-••-7865 | 14632897483 | ·NULL | 7935 Hillcrest Rd·· | TEMPE | AZ | 85279 | UNKNOWN | null |
| PRV | PRV-23460 | 2026-09-07T20:20:09Z | Angela | — | Grene | 1952-05-01 | UNKNOWN | ·- | UNKNOWN | - | 3078 Sage Ct | SAN ANTONIO | TX | — | — | null |
| PRV | PRV-27724 | 2026-07-06T09:33:19Z | Abigail | — | Gibson | 1947-09-22 | UHC-96128-02 | ·N/A | 5025596398 | abigail.gibson83@gmail.com | 8715 Mesa Drive | Dallas | Texas | 75239 | — | — |
| PRV | PRV-22736 | 2026-01-16T08:56:51Z | SCOTT | — | JACOBS | 07/22/1954 | UHC-89192-22 | — | 370-495-4147 | scott.jacobs88@proton.me | 9709 GRAND AVE | Tampa | FL | 33658·· | null·· | SELECT-EPO |
| PRV | PRV-28109 | 2026-08-20T08:11:54Z | JONATHAN | — | FLORES | Sep 19, 1972 | N/A | — | 843-452-4663 | — | 9441 Canyon Rd | Eden Prairie | MN | 55360 | — | NAVIGATE-HMO |
| PRV | PRV-22789 | 2026-01-24T18:39:07Z | jacob | ·· | aguilar | 1970-02-26 | UHC-45993-82 | UNKNOWN | 3825439235 | jacob.aguilar33@outlook.com | 2492 Lake View Rd | San Diego | ·CA | 92105 | - | CHOICE-PLUS-PPO |
| PRV | PRV-29575 | 2026-04-10T06:08:48Z | MARIA | — | ·FIELDS | 19440323 | — | — | 424-987-2474 | — | 7659 HILLCREST ROAD | MINNEAPOLIS | MN | 55489-5839 | - | — |
| PRV | PRV-28972 | 2026-09-21T14:03:00Z | Bryan | U | ·Wallace | 12/01/64 | - | N/A | (690) 877-4170 | ·N/A | 399 Desert Sky Boulevard | Nashville | TN | 37226-9298 | - | null |
| PRV | PRV-21118 | 2026-05-05T20:03:52Z | Hannah | ·X. | Nguyen | 1972-05-08 | - | •••-••-7005 | 723-552-5865 | null | ·8201 Meadow Lane | Dallas | TX | 75293-3660 | — | null |
| PRV | PRV-27960 | 2026-05-05T07:57:46Z | Julia | — | Brown | 5/17/1989 | — | — | 9502303813 | null | 8084 Main St #202 | Sacramento | CA | 95885 | N/A | null |
| PRV | PRV-29059 | 2026-07-19T14:56:26Z | Julie | N | Guerrero | 9176-02-13 | UNKNOWN | - | 900-889-3494 | — | 3375 Apache Boulevard | ·SACRAMENTO | CA | — | NULL | NULL |
| PRV | PRV-23685 | 2026-06-08T05:21:55Z | tucker | E | henry | Nov 16, 1952 | - | NULL | 7985451731 | null | 242 Washington Street | Nashville | TN | 37277 | UNKNOWN | NULL |
| PRV | PRV-28137 | 2026-02-11T05:25:18Z | Christine | — | Valdez | 1969-03-12 | UHC-20572-11 | — | 8573991733·· | - | 8031 UNION STREET #872 | HOUSTON | TX | 77012 | NULL | -·· |
| PRV | PRV-20108 | 2026-09-17T22:27:44Z | Chuck | ···· | Willis | Apr 17, 1954 | UHC-75469-91 | •••-••-3829 | NULL | — | ·- | — | N/A | — | null | N/A |
| PRV | PRV-22063 | 2026-05-27T07:56:41Z | ANDREW | ·· | WOODS | 16-11-1973 | UHC-68285-69 | — | 934-358-2652 | ANDREW.WOODS73@PROTON.ME | 872 UNION STREET | ·Gilbert | Arizona | 85250 | ·· | N/A |
| PRV | PRV-24707 | 2026-03-19T08:39:07Z | Luna, Mei | ·S | — | 1959-07-22 | null | null | (370) 338-7982 | mei.luna23@icloud.com | 6214 Pine Drive | DALLAS | TX | 75285 | NULL | NULL |
| PRV | PRV-29145 | 2026-04-10T21:42:51Z | TERESA | — | MUNOZ | 1949-05-17 | ·NULL | N/A | 528-673-5953 | UNKNOWN | 4514 BROADWAY | Orlando | FL | 32868 | — | - |
| PRV | PRV-23764 | 2026-04-27T10:28:10Z | Jason | — | Lopez | 1994-12-09 | UHC-54594-32 | — | 5914259132 | — | 5705 Desert Sky Boulevard #743 | Minneapolis | MN | 55459 | NULL | - |
| PRV | PRV-21070 | 2026-07-10T22:27:05Z | STEPHEN | ···· | COOK | 2001-11-05·· | - | - | UNKNOWN | NULL | 4900 BAYSHORE DR Apt 33 | Tempe | AZ | 85240 | UNKNOWN | N/A |
| PRV | PRV-28986 | 2026-09-20T08:17:45Z | RACHEL | — | WAGNER | 04/09/1981 | null | — | 4245238136 | — | 8428 Indian School Road #972 | AUSTIN | TX | 78749 | — | UNKNOWN |
| PRV | PRV-29366 | 2026-10-15T06:48:53Z | Brittany | D | Shaw | 9161-08-04 | - | UNKNOWN | 5076170562 | — | 6327 Ridge Rd | Denver | ·CO | 80299 | — | MEDICARE-ADV-B |
| PRV | PRV-28714 | 2026-07-27T21:04:14Z | Omar | — | Gonzalez | 1968-04-12 | UHC-96715-90·· | null | 5024267981 | — | 7931 FOREST AVENUE | Plano | tx | 75052 | — | CHOICE-PLUS-PPO |
| PRV | PRV-22537 | 2026-01-21T19:59:13Z | Jack | O | Hudson | 1999-01-25 | null | N/A | 17907161482 | — | 9203 BROADWAY | MIAMI | fl | 33199-8398 | null | — |
| PRV | PRV-22966 | 2026-09-13T19:10:14Z | Russell | — | Hicks | 1974-03-05 | UHC-25635-11 | null | 329-286-6762 | russell.hicks@gmail.com | 294 Central Ave #984 | Charlotte | nc | 28284 | null | — |
| PRV | PRV-21081 | 2026-02-25T02:31:02Z | fatima | — | green | 1/19/1971 | ·UHC-56858-96 | UNKNOWN | 897-585-5235 | FATIMA.GREEN@AOL.COM | 764 River Rd | Minneapolis | Minnesota | 55442 | - | MEDICARE-ADV-B |
| PRV | PRV-25875 | 2026-09-21T00:35:39Z | Anna | — | Grant | 1985-06-28 | UHC-58902-34 | — | 12085096051 | anna.grant25@yahoo.com | 9801 Jefferson Ave | Columbus | Ohio | 43214 | N/A | - |
| PRV | PRV-26090 | 2026-09-09T22:28:06Z | PATRICIA | — | MALDONADO·· | 01/25/1988 | UHC-13370-92 | UNKNOWN | (530) 349-1512 | — | 599 Apache Boulevard | FRESNO | CA | 93760 | null | — |
| PRV | PRV-21312 | 2026-04-27T22:15:28Z | Simpson, Jacob | — | — | 24-01-2000 | UHC-02926-18 | N/A | 16627987381 | jacob.simpson@outlook.com | 4452 Maple Avenue | CHARLOTTE | NC | 28267 | — | N/A·· |
| PRV | PRV-23676 | 2026-08-04T04:18:42Z | Flores | — | Mateo | 1975-04-04 | UHC-34251-40 | •••-••-8140 | 322-600-7276 | null | 486 Highland Avenue | Jacksonville | FL | 32249 | NULL | ·· |
| PRV | PRV-28923 | 2026-09-12T15:57:26Z | Biilly | — | Wagn | 1952-12-17 | UHC-79350-77 | •••-••-4627 | 283-871-0778 | — | 9796 Canyon Rd | SAN ANTONIO | TX | 78246 | null | NULL |
| PRV | PRV-25911 | 2026-03-30T19:42:32Z | Linda | — | Wagner | 1994-05-17 | — | UNKNOWN | 3179276389 | UNKNOWN | 4845 HILLCREST ROAD | SAN DIEGO | CA | 92136 | — | NULL |
| PRV | PRV-23996 | 2026-10-14T01:43:16Z | Willie | — | Robinson | 08/05/1967 | UHC-34240-65 | null | 883-245-4278 | - | 5548 Valley View Dr | Jacksonville | FL | 32295 | NULL | NULL |
| PRV | PRV-28372 | 2026-06-17T17:34:19Z | Hannaah | D | Little | 1967-01-19 | ···· | — | (628) 469-1390 | hannah.little@hotmail.com | 1136 River Rd | Phoenix | ·AZ | 85024 | — | NULL |
| PRV | PRV-21977 | 2026-06-07T06:55:16Z | KELLY | B | RICHARDS | Jun 22, 1995 | — | — | (865) 265-9128 | kelly.richards55@outlook.com | 7406 Pine Drive | Orlando | FL | 32830 | null | NULL |
| PRV | PRV-27404 | 2026-08-30T14:34:51Z | ·wei | — | knight | 01/13/2003 | - | •••-••-5796 | (656) 512-1326 | — | 5983 Harbor Boulevard #742 | MINNEAPOLIS | MN | 55440 | - | - |
| PRV | PRV-22465 | 2026-10-16T15:57:41Z | ·Ahmed | ·· | Spencer | 1994-06-20 | UHC-74337-10 | null | +1 492 524 5904 | — | 317 Park Place | Mesa | AZ | 85244 | — | NULL |
| PRV | PRV-20826 | 2026-03-04T00:11:36Z | Cynthia | A | Gibson | 1952-11-09 | UHC-98065-16 | NULL | 259-510-5991 | — | 8464 JEFFERSON AVE | Tempe | AZ | 85239-3801 | NULL | UNKNOWN |
| PRV | PRV-28929 | 2026-02-23T10:14:02Z | Hughes, Grace | D | — | 10/15/1965 | - | N/A | 6717940564 | - | 181 Central Avenue | Tampa | FL | 33632 | — | — |
| PRV | PRV-24265 | 2026-02-18T20:55:46Z | Judith | — | Howell | 05/02/93 | UHC-20985-03 | NULL | 15544783967 | judith.howell@aol.com | 5164 Park Pl | Houston | TX | 77081·· | null | MEDICARE-ADV-B |
| PRV | PRV-28295 | 2026-08-21T14:01:22Z | Grace | F | Duncan | 1999-06-14 | UHC-41719-75 | — | ·590.525.1892 | — | 6527 Harbor Boulevard | ORLANDO | FL | 32879 | ·null | SELECT-EPO |
| PRV | PRV-26316 | 2026-06-04T01:32:06Z | katherine | — | hughes | 1964-08-18 | UHC-58411-53 | — | 9573748697 | NULL | N/A·· | — | N/A | - | — | - |
| PRV | PRV-20554 | 2026-08-13T05:25:34Z | JULIE | — | LEE | 01/20/79·· | NULL | UNKNOWN | 13842543307 | N/A | 5571 Harbor Boulevard | Jacksonville | Florida | 32245 | UNKNOWN | null |
| PRV | PRV-21657 | 2026-03-22T07:16:53Z | Danielle | — | Oliver | 1955-07-21 | UHC-04683-72 | ·- | (396) 635-4197 | — | — | — | - | ·N/A | — | UNKNOWN |
| PRV | PRV-24010 | 2026-09-08T18:25:21Z | DENNIS | — | ELLIOTT | 04/06/1975 | N/A | — | 4146987519 | — | 3313 Maple Ave | ·Gilbert | AZ | 85265-7543 | — | — |
| PRV | PRV-24603 | 2026-02-26T23:33:31Z | Jesse | — | Torres | N/A | UHC-40675-77 | — | 12104466260 | - | 6930 Lincoln Way | ATLANTA | GA | 30377 | UNKNOWN | NULL·· |
| PRV | PRV-23678 | 2026-05-04T01:53:56Z | EUGENE | — | RICHARDSON | 2/8/1956 | UHC-44774-84 | NULL | 660-335-0643 | — | 2383 Camelback Rd Apt 1 | Tucson·· | AZ | 85770 | UNKNOWN | — |
| PRV | PRV-27317 | 2026-09-14T04:35:12Z | Betty | P | Wang | 0085-19-77 | N/A | NULL | 3735019281 | betty.wang@outlook.com | 2663 PARK PLACE | Glendale·· | AZ·· | 85335 | - | NAVIGATE-HMO |
| PRV | PRV-20467 | 2026-02-11T21:19:49Z | Kathryn | — | Contreras | 1972-06-05 | UHC-93092-01 | •••-••-5672 | 2874278678 | — | 1935 Church St | Glendale | ·AZ | 85310 | - | NULL |
| PRV | PRV-28881 | 2026-05-07T18:23:08Z | ·SOFIA Y | — | BOWMAN | 1964-11-20 | null·· | — | 5956384139 | — | 3843 Baseline Road | Scottsdale | az | ·85229 | — | ···· |
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.509Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty