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-24997 | 2026-04-21T15:08:27Z | elijah | — | myers | 12/09/1989 | null·· | -·· | 5506243373 | elijah.myers@icloud.com | 3062 HIGHLAND AVE | Dallas | TX | ·75233 | UNKNOWN | CHOICE-PLUS-PPO |
| PRV | PRV-20288 | 2026-05-27T22:02:45Z | GLORIA | H. | DUNN | 1982-05-22 | N/A | — | (596) 712-5464 | gloria.dunn@hotmail.com | 938 Elm Street | Atlanta | GA | 30329 | — | ·MEDICARE-ADV-A |
| PRV | PRV-20727 | 2026-02-07T13:36:15Z | CAMILA | — | WOODS | Jan 23, 1994 | UHC-11477-78 | UNKNOWN | 5385908180 | N/A | 1429 Lincoln Way | Jacksonville | FL | 32284 | — | — |
| PRV | PRV-27639 | 2026-03-16T05:23:18Z | Emma | — | Roberts | 1991-08-21 | UHC-03591-23 | — | 535.456.6351 | NULL | 5631 Mesa Dr | Fresno | CA | 93740 | N/A | null |
| PRV | PRV-26376 | 2026-08-25T04:35:58Z | SHIRLEY | — | YANG | 08/08/1953 | UHC-48664-66 | N/A | 760-205-6421 | SHIRLEY.YANG27@YAHOO.COM | 699 Baseline Rd | Atlanta | Georgia | 30395 | — | — |
| PRV | PRV-20384 | 2026-05-09T12:19:09Z | Peter | ···· | ·Robertson | 2003-07-16 | UHC-65809-32·· | •••-••-9725 | (894) 281-4396 | peter.robertson71@outlook.com | 3414 Broadway Apt 29 | Chandler·· | AZ | 85227·· | UNKNOWN | - |
| PRV | PRV-26915 | 2026-03-19T20:34:59Z | Kim, Joseph | — | — | 1952-01-04 | UHC-77559-61 | — | null | - | 1052 Jefferson Ave | San Antonio | TX | ·78256 | NULL | — |
| PRV | PRV-25213 | 2026-08-09T12:39:40Z | MARK | — | FORD | 1956-12-04·· | NULL | - | (838) 763-7311 | ···· | 2379 Lake View Rd Apt 9 | Eden Prairie | MN | 55352·· | ·· | — |
| PRV | PRV-21015 | 2026-04-18T05:21:02Z | MARRY | K | RGERS | 1943-04-11 | UHC-81130-66 | UNKNOWN | (476) 819-4588 | N/A | 3310 WASHINGTON STREET | Scottsdale | AZ | 85202 | — | MEDICARE-ADV-A |
| PRV | PRV-21361 | 2026-06-19T05:13:51Z | Mary | G. | Holmes | Jun 25, 1997·· | — | •••-••-4731 | ·3975812 | mary.holmes@hotmail.com | 3467 SUNSET BLVD | LAS VEGAS | Nevada | null | null | - |
| PRV | PRV-21256 | 2026-04-22T19:09:13Z | SANCHEZ | V | DENNIS | 1955-05-06 | — | N/A | 987-844-2270 | — | 5141 Mesa Drive | ORLANDO | FL | 32849 | UNKNOWN·· | NAVIGATE-HMO |
| PRV | PRV-20481 | 2026-08-15T19:07:32Z | John | — | Santiago | 10/04/05 | null | -·· | 19217830770 | JOHN.SANTIAGO88@ICLOUD.COM | 9707 Ridge Road | Dallas | TX | null | NULL | CORE-HMO |
| PRV | PRV-28665 | 2026-07-02T05:39:54Z | brittany | — | patel | Nov 28, 2007 | UHC-64753-20 | •••-••-1098 | 7217012571 | null | 7747 Apache Blvd Apt 35 | Mesa | AZ | 85280 | N/A | null |
| PRV | PRV-23179 | 2026-07-23T03:05:07Z | Marcus | C | Reed | 1954-10-05 | null | •••-••-7577 | 682-363-9021 | UNKNOWN | 9817 OAK ST | Chandler | AZ | 85297 | N/A | UNKNOWN |
| PRV | PRV-23546 | 2026-08-21T02:01:17Z | Nancy | — | Gray | 1941-07-06 | ···· | •••-••-1622 | 336-384-5937 | — | 5749 Ridge Road·· | Mesa | AZ | UNKNOWN | UNKNOWN | ·- |
| PRV | PRV-28158 | 2026-02-05T12:34:17Z | HARPER | — | MICHELLE | 1952-04-17 | UHC-59426-45 | N/A | 18208969482 | — | 3693 Union St | Plano | TX | 75080 | — | MEDICARE-ADV-B |
| PRV | PRV-23553 | 2026-03-12T05:21:57Z | ·ADAM | — | ELLIOTT | 2008-10-01 | UHC-40799-71 | •••-••-7959 | 4595403 | adam.elliott2@proton.me | 4898 Church Street | Glendale | AZ | 85372 | UNKNOWN | - |
| PRV | PRV-26704 | 2026-07-09T22:36:47Z | Eric | — | Bell | 1993-10-26 | NULL | - | 5489420410 | — | 8680 Canyon Road | Miami | FL | 33189 | ·· | null |
| PRV | PRV-21069 | 2026-03-14T06:24:51Z | austin | — | mendoza | 04/11/1939 | - | - | 9407987779 | austin.mendoza5@gmail.com | 4656 Baseline Rd | CHANDLER | ·az | 85245-2759 | — | - |
| PRV | PRV-28501 | 2026-08-22T19:34:39Z | SUSAN | ···· | DIAZ | 09/01/63 | UHC-72659-15 | ···· | 311-562-1473 | N/A | 9143 Desert Sky Boulevard·· | PHOENIX·· | AZ | 85009 | null | — |
| PRV | PRV-26589 | 2026-04-17T04:30:26Z | Lias | — | Ferguson | 19651013 | UHC-46337-12 | ·NULL | (507) 728-9719 | lisa.ferguson64@proton.me | 4972 Cedar Lane #107 | EDEN PRAIRIE | MN | 55370 | N/A | NULL |
| PRV | PRV-28075 | 2026-05-06T17:35:25Z | CYNTHIA | B | BURKE | Jun 14, 1950 | — | null·· | 9508055680 | — | ·5687 Central Ave | Fresno | CA | 93732-6652 | null | SELECT-EPO |
| PRV | PRV-26487 | 2026-09-09T02:23:43Z | Gary | V | Hill | 15950323 | UHC-08265-40 | - | 489-671-3363 | — | 1930 APACHE BLVD·· | Seattle | WA | 98148 | N/A | MEDICARE-ADV-A |
| PRV | PRV-20541 | 2026-10-11T17:14:56Z | Perez, Judy | — | — | 1996-05-07 | — | - | 2814323145 | — | ·9661 MESA DRIVE | Minneapolis | MN | 55456-1519 | - | null |
| PRV | PRV-21527 | 2026-04-09T04:28:28Z | ·Anna | T. | Jordan·· | 2002-11-01 | NULL | •••-••-6699 | (531) 498-6591 | UNKNOWN | 9449 Maple Ave | Atlanta | GA | 30345 | null | — |
| PRV | PRV-24205 | 2026-09-08T03:15:31Z | Wei | — | Castillo | ·NULL | — | N/A | (906) 243-9468 | — | 2397 WILLOW CT | Eden Prairie | MN | 55392 | NULL | CORE-HMO |
| PRV | PRV-23468 | 2026-01-18T04:13:33Z | Sofia | R. | Montgomery | 20070217 | UHC-68722-65 | •••-••-7963 | 4656011090·· | sofia.montgomery78@yahoo.com·· | 9524 APACHE BOULEVARD | Tampa | Florida | 33696 | — | UNKNOWN |
| PRV | PRV-23948 | 2026-05-25T08:04:30Z | Carlos | P | Le | 1944-10-15 | UHC-07359-80 | - | 564-470-7042 | — | null | — | null | — | ···· | OPTIONS-PPO |
| PRV | PRV-25781 | 2026-04-01T01:54:09Z | Jacob | K | Arnold | 1945-11-04 | UHC-45585-13 | — | ·429-917-8212 | ·null | 4195 Jefferson Avenue | Minneapolis | MN | 55427 | — | — |
| PRV | PRV-28833 | 2026-06-16T04:44:47Z | Jesse | D. | Wang | 05/04/1951 | UHC-64399-80 | - | 562-790-3791 | - | 4970 Grand Ave | Chandler | AZ | 85245 | — | UNKNOWN |
| PRV | PRV-28647 | 2026-03-04T16:12:24Z | Rebecca E | — | Cox | 1997-02-09 | UHC-65252-88 | N/A | 3582509037 | — | 8322 SAGE CT | Orlando | FL | 32858 | NULL | null |
| PRV | PRV-21566 | 2026-05-06T12:07:39Z | Carolyn | — | ·Wallace | 1/7/1999 | UNKNOWN | NULL | (484) 717-0868 | null | 2659 Grand Ave | Tampa | FL | 33668 | NULL | — |
| PRV | PRV-28708 | 2026-05-13T02:53:01Z | Romero, Bradley | — | — | 12-02-1955 | — | null | +1 330 814 8498 | bradley.romero52@outlook.com | 2559 LAKE VIEW ROAD Apt 4 | Jacksonville | FL | 32282 | - | null |
| PRV | PRV-23041 | 2026-09-17T13:09:55Z | ETHAN | — | MORRISON | 1978-12-19 | UHC-86725-04 | null | (417) 483-2668 | NULL | 8293 Harbor Boulevard | Fresno | CA | 93715 | null | UNKNOWN |
| PRV | PRV-22693 | 2026-01-05T07:28:27Z | Maria | Y. | McDonald | 1978-04-27 | UHC-46308-89 | UNKNOWN | (233) 613-6170 | — | 266 Mountain View Drive | San Antonio | TX | - | - | UNKNOWN |
| PRV | PRV-28296 | 2026-02-15T01:27:34Z | ·Grace | F | Duncan | 1999-06-14 | UHC-41719-75 | •••-••-6317 | 5905251892 | — | 6527 Harbor Boulevard | ORLANDO | FL | 32879-6990 | null | — |
| PRV | PRV-28458 | 2026-03-11T01:31:01Z | Long, Jose | B | — | 08/05/1972·· | UHC-18259-67·· | — | 468-457-3172 | N/A | 8334 Canyon Rd | Nashville | TN | 37269 | — | MEDICARE-ADV-B |
| PRV | PRV-29217 | 2026-09-09T04:09:54Z | ·Jusitn | ···· | Coleman | 1977-12-02 | NULL | •••-••-0782 | ·(878) 417-3750 | justin.coleman@outlook.com | 6753 BASELINE RD | San Diego | CA | 92138·· | - | CHOICE-PLUS-PPO |
| PRV | PRV-26831 | 2026-10-18T20:20:46Z | Charles | — | Nelson | 1939-03-01 | uhc-63194-22 | - | +1 918 505 7537 | null | 1880 PINE DR | Eden Prairie | MN | 55394 | UNKNOWN | — |
| PRV | PRV-22651 | 2026-07-07T16:44:08Z | Kathryn | — | Tran | ·1970-07-24 | N/A | NULL | 6873848250 | - | 4838 Mountain View Drive | Tucson | Arizona | 85754 | — | — |
| PRV | PRV-29585 | 2026-08-18T21:53:07Z | Tyler | — | Ramirez | 08/04/1985 | - | — | 817-463-7516 | NULL·· | 135 Church St | San Diego | CA | 92111 | N/A | UNKNOWN |
| PRV | PRV-24355 | 2026-01-16T02:55:44Z | Madison | — | Garcia | 9/25/1984 | — | NULL | UNKNOWN | NULL | 6656 CHURCH ST | TAMPA | FL | null | ·NULL | — |
| PRV | PRV-27957 | 2026-07-15T05:37:29Z | Russell, Jesse | — | — | Apr 14, 1983 | UHC-39788-24 | — | 504-567-5582 | jesse.russell77@gmail.com | 8446 Camelback Road·· | PHOENIX | AZ | 85088 | N/A | NAVIGATE-HMO |
| PRV | PRV-28019 | 2026-10-13T14:16:30Z | Emily | — | Reynolds | 19620406 | UHC-54398-28·· | N/A | (890) 339-2682 | UNKNOWN | 5254 MOUNTAIN VIEW DR | Austin | TX | ·78712 | — | SELECT-EPO |
| PRV | PRV-24793 | 2026-04-04T04:42:27Z | ANTHONY | — | REED | 1942-05-02 | - | •••-••-3188 | +1 833 275 1534·· | UNKNOWN | 6410 Cedar Ln | NASHVILLE | Tennessee | 37221·· | null | -·· |
| PRV | PRV-23515 | 2026-03-12T15:37:46Z | BRYAN | — | FLORES | 1970-04-28 | UHC-43147-53 | •••-••-5719 | +1 846 451 8193 | N/A | 8493 Market St | San Antonio | TX | 78273 | N/A | null |
| PRV | PRV-22147 | 2026-03-28T00:29:13Z | bob | — | garrett | 1963-04-16 | — | null | N/A | ·- | 6221 Canyon Rd | Mesa | AZ | 85219 | N/A | — |
| PRV | PRV-29447 | 2026-01-07T20:48:35Z | CHRISTIAN | — | MORANO | 17-05-1939 | - | null | 4474812422 | christian.moreno6@gmail.com·· | 9892 Lake View Rd | SCOTTSDALE | AZ | N/A·· | - | — |
| PRV | PRV-21220 | 2026-08-24T08:07:51Z | Nathan | R | Greene | 1974-10-10 | UHC-57579-63 | — | 8039060134 | - | 277 Cedar Ln | Columbus | OH | 43236 | — | NULL |
| PRV | PRV-24346 | 2026-06-18T07:10:43Z | John | D | Hery | 1944-01-19 | NULL | N/A | (853) 261-4998 | UNKNOWN | 9524 Desert Sky Boulevard | Atlanta | GA | 30391 | — | — |
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.415Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty