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-21025 | 2026-08-27T03:19:46Z | Little, Megan | — | — | 1998-09-25 | UHC-03625-82 | - | +1 706 429 9237 | UNKNOWN | 2116 Washington Street | Dallas | TX | 75200 | - | null |
| PRV | PRV-22223 | 2026-02-23T03:48:19Z | White, Roger | — | — | 1948-08-05 | UHC-38078-45 | — | 337-457-0252 | roger.white@gmail.com | 1094 Baseline Road | Seattle | WA | 98105 | — | NULL |
| PRV | PRV-20787 | 2026-06-16T23:44:01Z | Jeff | — | Rice | 19860614 | ·UHC-50934-22 | •••-••-9753 | 239-819-5243 | — | 788 WASHINGTON STREET | MESA | Arizona | 85261 | — | CORE-HMO |
| PRV | PRV-28168 | 2026-08-31T09:26:52Z | George | W | Johnston | Jun 1, 1985 | — | •••-••-7472 | NULL | N/A | 1092 Highland Avenue | Austin | TX | 78798 | — | — |
| PRV | PRV-26877 | 2026-09-01T11:31:31Z | JAMES | S | SMITH | 1960-09-01 | UHC-01630-29 | — | 288-634-9456 | - | N/A | null | - | — | — | - |
| PRV | PRV-24557 | 2026-05-03T06:52:16Z | AISHA | Q. | ·HENDERON | 1986-02-18 | N/A | — | 16573880632 | UNKNOWN | 563 SPRING STREET | San Antonio | ·TX | 78287 | N/A | ·SELECT-EPO |
| PRV | PRV-21533 | 2026-10-12T13:37:58Z | Sandra | ·· | Alavrado | 1982-01-28 | UHC-71767-16 | •••-••-5721 | +1 887 902 7880 | null | 5572 Lake View Rd | AUSTIN·· | TX | 78767 | - | — |
| PRV | PRV-28947 | 2026-02-09T11:27:22Z | Wei | — | Rojas | 1959-03-01 | UHC0211150 | ·UNKNOWN | ·(447) 453-6178 | wei.rojas@outlook.com | — | — | — | N/A | N/A | MEDICARE-ADV-A |
| PRV | PRV-24296 | 2026-09-11T14:40:39Z | GLORIA | — | SCHMIDT | 19470908 | - | NULL | +1 386 922 2678 | null | 7128 Lincoln Way | PLANO | TX | UNKNOWN | - | — |
| PRV | PRV-22206 | 2026-06-15T14:07:12Z | Vincent | V | Adams | 19420211 | null | NULL·· | 9709013391 | NULL | 3494 Indian School Rd | Scottsdale | AZ | 85228 | — | NULL |
| PRV | PRV-24737 | 2026-08-12T23:57:13Z | JOAN | — | LEE | 8/13/1994 | UHC-59669-36 | - | — | null | 4173 APACHE BOULEVARD | Jacksonville | FL | 32226 | — | N/A |
| PRV | PRV-26086 | 2026-07-12T04:57:37Z | Jim | — | Wright | 1993-08-27 | UHC-88515-11 | NULL·· | 637-855-2459·· | james.wright@hotmail.com | ·8840 CEDAR LANE | Columbus | OH | 43225 | null·· | null |
| PRV | PRV-28574 | 2026-07-26T06:18:07Z | JOHN | — | MOORE | 11-04-1996 | NULL·· | N/A | (407) 206-1847 | ···· | 3523 Market St·· | SACRAMENTO | CA | 95863-3024 | UNKNOWN | N/A |
| PRV | PRV-25975 | 2026-07-31T15:49:35Z | Chritine | — | Jimenez | 2000-08-25 | UHC-90658-11·· | — | ·(477) 279-7465 | — | 7936 Mountain View Dr | Eden Prairie | MN·· | 55324 | — | — |
| PRV | PRV-21891 | 2026-06-05T04:38:40Z | marcus | ···· | delgado | 1990-12-17 | uhc-19436-23 | •••-••-4640 | (900) 923-9963 | — | 2234 Camelback Road | ·Glendale | AZ | 85375 | null | CORE-HMO |
| PRV | PRV-27377 | 2026-10-04T06:07:28Z | Gregory | V | Weaver | 1940-03-01 | N/A·· | •••-••-5558 | — | — | 2147 Hillcrest Rd | Denver | CO | — | UNKNOWN | NULL |
| PRV | PRV-26811 | 2026-03-07T10:37:08Z | Diego | — | Ferguson | 1984-06-08 | UHC-07762-22 | — | 970-685-9537 | diego.ferguson81@yahoo.com | 1523 Union Street Apt 4 | San Antonio | TX | 78229 | null | - |
| PRV | PRV-25634 | 2026-03-28T03:10:49Z | Hiroshi | — | Espinoza | 1997-12-09 | UNKNOWN | — | -·· | HIROSHI.ESPINOZA@HOTMAIL.COM | 2482 Mesa Drive | TEMPE | AZ | 85226 | — | N/A |
| PRV | PRV-24509 | 2026-08-05T02:55:49Z | fatima | — | myers | 02/05/48 | N/A | — | 948-597-8728·· | — | - | null | — | null | — | N/A·· |
| PRV | PRV-23093 | 2026-07-01T11:58:33Z | Charlotte·· | — | Ruiz | 19550920 | UHC-93692-65 | •••-••-4186 | (883) 892-3998 | NULL | 6948 Broadway Apt 19 | Scottsdale | AZ | 85217-7463 | — | ···· |
| PRV | PRV-26559 | 2026-03-17T04:42:39Z | kelly | I. | reid | 1974-02-13 | - | •••-••-0848 | 858-381-9449 | kelly.reid@yahoo.com | ·7525 Palm Dr | FRESNO | CA | 93721 | — | NULL |
| PRV | PRV-24248 | 2026-04-13T13:03:56Z | Wod, Judith | — | — | 20021127 | UHC-06905-95 | - | 12043851382 | — | 5083 Desert Sky Blvd #551 | Mesa | ·AZ | 85205 | NULL | UNKNOWN |
| PRV | PRV-28195 | 2026-01-27T20:42:42Z | Nicholas | — | Jackson | 1987-08-03 | UHC-25427-08 | NULL | 577-369-4218 | null | 1109 Maple Avenue | CHANDLER | az | 85260·· | N/A | NAVIGATE-HMO |
| PRV | PRV-23178 | 2026-01-01T07:51:19Z | David | — | Rose | 1970-11-27 | null | — | 874-252-2938 | ·N/A | 703 Palm Drive | MINNEAPOLIS | MN | 55433 | ·· | — |
| PRV | PRV-29376 | 2026-08-27T22:33:59Z | Wei | — | Rogers | 1991-09-25 | UHC-97411-91 | NULL | 7742378258 | — | 9562 ELM ST | Orlando | FL | — | UNKNOWN | N/A |
| PRV | PRV-25612 | 2026-06-21T05:52:48Z | DENISE | — | GARZA·· | ·16-10-1982 | NULL | UNKNOWN | (413) 559-3814 | denise.garza94@hotmail.com·· | 7798 Central Ave | PHOENIX | AZ | 85027·· | — | - |
| PRV | PRV-21990 | 2026-07-09T22:39:41Z | Harvey, Gary | — | — | 1955-02-26 | UHC-53525-01 | — | 703-930-8215 | ·· | 3688 River Rd | Gilbert | AZ | 85222 | NULL | CHOICE-PLUS-PPO |
| PRV | PRV-25171 | 2026-03-30T13:25:36Z | Raymond | ···· | Fox | ·2000-10-21 | null | — | 3466170408 | UNKNOWN·· | 7089 MESA DR | Eden Prairie | MN | 55306 | NULL·· | SELECT-EPO |
| PRV | PRV-24792 | 2026-02-23T10:27:15Z | Heather | — | Diaz | 19950925 | UHC-56593-49 | — | +1 622 256 9748 | N/A·· | 247 River Road | Fresno | California·· | ·93778 | NULL | CORE-HMO |
| PRV | PRV-23046 | 2026-01-24T13:56:23Z | Jsesica | Y. | Matthews | 01/06/62 | — | •••-••-2765 | (745) 995-9603 | — | 938 Park Place | Chandler | AZ | 85206 | ·- | CHOICE-PLUS-PPO |
| PRV | PRV-23267 | 2026-09-21T05:46:07Z | Alexander | Y | Reynolds | 08/03/90 | NULL | •••-••-3040 | (699) 304-2577 | NULL | ·7344 Cedar Ln | GLENDALE | AZ | 85333 | - | N/A |
| PRV | PRV-29513 | 2026-05-24T05:09:03Z | Stevens, Jeremy | H | ·· | 1952-01-07 | UHC4717361 | •••-••-7944 | (422) 233-2187 | UNKNOWN | 473 Market Street | Plano | TX | 75072 | null | — |
| PRV | PRV-20373 | 2026-06-19T13:58:29Z | Fatima | — | Davis | 1997-04-15 | N/A | •••-••-2824 | 933-422-8741 | fatima.davis14@outlook.com | 35 CEDAR LN | Chandler | AZ | 85259 | null | UNKNOWN |
| PRV | PRV-27727 | 2026-02-05T14:55:04Z | Hannah | — | Munoz | 1942-11-28 | UHC6797518 | •••-••-4657 | 2096529 | hannah.munoz@outlook.com | 9778 Ridge Rd | Plano | TX | N/A | ·UNKNOWN | ···· |
| PRV | PRV-23109 | 2026-02-19T11:18:49Z | JOE | — | GILBERT | 1955-07-08 | N/A | •••-••-4108 | 726-746-6952 | null | NULL | — | null | null | N/A | CORE-HMO |
| PRV | PRV-24222 | 2026-07-12T19:06:19Z | Joe | — | Fieds | 19521021 | - | null | 4155698963 | - | 3168 Pine Dr | Columbus | OH | 43228-6619 | — | NULL |
| PRV | PRV-26954 | 2026-03-10T09:43:40Z | STEVEN | — | HUNT | 19590822 | - | null | 3426914413 | steven.hunt@yahoo.com | 2211 Willow Ct | CHARLOTTE | NC | 28208 | — | — |
| PRV | PRV-25881 | 2026-01-14T20:10:33Z | ·Linda | — | Martin | 09/27/2006 | N/A·· | NULL | — | — | 1063 Union Street | DALLAS | TX | 75262 | — | — |
| PRV | PRV-20116 | 2026-01-24T01:47:41Z | terry | ·· | martinez | Oct 8, 1970 | UHC-27731-53 | — | 16723861608 | null | 5456 Park Place | San Antonio | TX | 78251 | — | — |
| PRV | PRV-25484 | 2026-08-18T00:53:48Z | Harper, Maria·· | — | — | 1941-06-14 | — | •••-••-7924 | 806-718-3814 | - | null | — | — | - | — | N/A |
| PRV | PRV-26413 | 2026-01-15T02:08:04Z | IZABELLA | B. | KENNEDY | ·1951-08-10 | UHC-97057-97 | — | 4052366527 | - | 2989 Ridge Road | CHANDLER | AZ | 85217 | - | - |
| PRV | PRV-21996 | 2026-01-24T00:49:40Z | Dinaa·· | — | James | 1952-05-22 | — | UNKNOWN | null | ·diana.james96@outlook.com | 3640 Sage Ct | Glendale | ·az | 85358 | null | CORE-HMO |
| PRV | PRV-21087 | 2026-07-09T01:26:00Z | KYLE | Z. | WONG | 1953-12-09 | UHC-64030-81 | N/A | - | KYLE.WONG12@HOTMAIL.COM | 1353 LAKE VIEW RD | Mesa | AZ | 85242 | NULL | ·null |
| PRV | PRV-26855 | 2026-02-20T13:29:22Z | KEITH | — | GRIFFIN | ·Apr 15, 1979 | null | ·· | (508) 842-6049 | — | 9173 Lake View Rd | Tucson | AZ | ·N/A | - | ···· |
| PRV | PRV-23801 | 2026-06-02T04:16:13Z | Aguilar, Marilyn | — | — | 1989-02-22 | N/A | — | (446) 457-8877·· | MARILYN.AGUILAR@GMAIL.COM | 4665 Baseline Rd | CHANDLER | AZ | ·85235-1096 | UNKNOWN | null |
| PRV | PRV-26147 | 2026-10-07T10:15:00Z | ANGELA·· | ···· | COLE | 1959-05-24 | UHC-48801-96·· | •••-••-0076 | 692.403.9409 | — | 8885 Lincoln Way | Las Vegas | NV | 89158 | ·- | null |
| PRV | PRV-28716 | 2026-08-23T04:03:24Z | SAM | — | RODRIGUEZ·· | 1969-03-03 | UHC6307478 | UNKNOWN | 207.551.1467 | ·· | ·3532 Sage Ct #296 | Sacramento | ·ca | 95843 | — | UNKNOWN |
| PRV | PRV-21486 | 2026-03-24T06:39:10Z | DOROTHY | — | JOHNSTON | 11-12-1970 | UHC-64629-02 | •••-••-1832 | ·· | - | 5559 Mountain View Drive | Houston | TX | 77072 | — | N/A |
| PRV | PRV-27382 | 2026-07-25T21:12:34Z | Webb, Hiroshi | — | — | 1978-05-02 | UHC-42260-19 | N/A | (622) 482-2335 | — | 8151 CHURCH ST | Denver | CO | 80296 | — | null |
| PRV | PRV-28948 | 2026-07-01T14:13:02Z | Nicloe | W | Johnston | 11/02/1981 | — | null | +1 842 541 9404 | - | 2100 Apache Blvd | Mesa | AZ | 85272 | UNKNOWN | - |
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:53.703Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty