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-25262 | 2026-08-31T03:46:19Z | WAYNE | D | CASTRO | 09/06/1950 | — | NULL | (814) 991-2985 | - | 2524 Baseline Road Apt 24 | Sacramento | CA | 95862·· | — | UNKNOWN |
| PRV | PRV-21849 | 2026-04-02T18:58:14Z | Wagner, Mason | — | — | 1962-08-16 | — | null | (914) 318-2055 | UNKNOWN | 1593 Church St | SAN ANTONIO | TX | 78215 | - | CHOICE-PLUS-PPO |
| PRV | PRV-22435 | 2026-01-08T16:07:44Z | Jason | — | Rice | ·09/06/1973 | UNKNOWN | N/A | +1 697 811 9305·· | null | 5229 Sage Court | GILBERT | AZ | 85227 | — | — |
| PRV | PRV-24889 | 2026-03-10T22:32:49Z | ·KENNETH | — | MONTGOMERY | 1985-06-02 | ·· | UNKNOWN | 4746914631·· | UNKNOWN | 476 Harbor Boulevard | Tucson | AZ | NULL | ·null | — |
| PRV | PRV-24873 | 2026-09-19T17:08:11Z | Priya | — | Castro | 10/01/41 | N/A | •••-••-3280 | N/A | PRIYA.CASTRO@HOTMAIL.COM | 1086 Oak St | Seattle | wa | 98156 | null | CORE-HMO |
| PRV | PRV-21589 | 2026-01-31T03:47:58Z | JESSICA | — | ALEXANDER | 06/17/73 | — | ·· | N/A | N/A | 5403 Jefferson Avenue | Phoenix | AZ | 85034-0253 | null | OPTIONS-PPO |
| PRV | PRV-23079 | 2026-09-15T06:20:16Z | Peter | Q | Fox·· | 1989-01-24 | — | - | 9232771914 | - | UNKNOWN | -·· | null | UNKNOWN | UNKNOWN | — |
| PRV | PRV-20219 | 2026-05-20T03:25:08Z | WEI | T | HUGHES | 1987-07-27 | - | •••-••-1067 | 322-689-9064 | wei.hughes81@icloud.com | 9840 Maple Avenue | AUSTIN | TX | N/A | — | — |
| PRV | PRV-23615 | 2026-01-18T05:09:01Z | megan | — | rivera | 1959-08-21 | UNKNOWN | — | 8667528 | — | 1707 BASELINE ROAD | Mesa·· | AZ | 85204 | — | — |
| PRV | PRV-26052 | 2026-07-01T16:08:25Z | Sandra | — | Reynolds | 1954-03-23 | null | — | 758.343.6760 | N/A | 7653 VALLEY VIEW DR | Austin | TX | 78785-9406 | N/A | — |
| PRV | PRV-27152 | 2026-03-30T12:53:44Z | WANYE | — | STEPHENS | 1981-07-10 | UHC-60073-10 | — | (475) 735-5074 | — | 8351 Hillcrest Road #342 | Seattle | WA | 98189 | NULL | — |
| PRV | PRV-28417 | 2026-08-03T23:30:27Z | Ralph | — | Arnold·· | 1998-08-26 | — | NULL·· | ·(914) 379-2078 | — | 1334 JEFFERSON AVENUE #442·· | San Antonio | TX | 78254 | NULL | null |
| PRV | PRV-24888 | 2026-05-10T22:07:09Z | CATHERINE | — | ROBINSON | 06/07/1952 | — | •••-••-7869 | (506) 766-8750 | — | - | — | NULL·· | N/A | N/A | NULL·· |
| PRV | PRV-26401 | 2026-09-28T09:35:13Z | joyce | — | evans | UNKNOWN | UHC-63977-81 | NULL | 9738624698 | JOYCE.EVANS55@AOL.COM | N/A | ·null | — | — | — | SELECT-EPO |
| PRV | PRV-21785 | 2026-09-03T00:47:20Z | LUIS | — | PORTER | 20060617 | — | •••-••-0154 | 6658578571 | UNKNOWN | 2013 LAKE VIEW RD | JACKSONVILLE | Florida | UNKNOWN | — | UNKNOWN |
| PRV | PRV-26128 | 2026-09-29T20:13:22Z | Andrew | — | Bradley | 04/22/51 | UHC-41862-45 | — | 8902605677 | — | 9405 Washington Street | TEMPE | AZ | 85205·· | — | UNKNOWN |
| PRV | PRV-27324 | 2026-09-10T03:24:10Z | Gray, Christopher | — | — | 2000-08-20 | UHC-48386-23 | UNKNOWN | — | N/A | 6500 Elm St·· | MINNEAPOLIS | MN | 55411 | ·· | — |
| PRV | PRV-23780 | 2026-02-25T03:56:15Z | Crar, Walter | S | — | 11/13/72·· | UHC-53046-17 | — | (359) 946-5098 | WALTER.CARR@AOL.COM | 5262 JEFFERSON AVENUE | Houston | TX | 77055-6078 | null | N/A |
| PRV | PRV-22916 | 2026-03-21T02:06:42Z | Samantha | ·· | Perez | 20040820 | UHC-56558-45 | N/A | - | samantha.perez@hotmail.com | 2193 RIDGE RD | Tucson | AZ | 85766 | N/A | -·· |
| PRV | PRV-20145 | 2026-03-10T20:10:45Z | Lawrence | — | Sanchez | 1939-11-80 | UHC-61874-07·· | ·- | 2237078293 | lawrence.sanchez60@yahoo.com | 6912 Baseline Rd | Tucson | AZ | 85716 | null | ·· |
| PRV | PRV-26484 | 2026-04-13T08:06:24Z | Rebecca | ·· | Fox | 4/23/2000 | UHC-17190-79 | UNKNOWN | 2983107 | NULL | 9718 Main Street | Fresno | CA | 93789 | N/A | null |
| PRV | PRV-20610 | 2026-05-14T15:03:23Z | Benjamin | — | Mitchell | 1976-12-10 | UNKNOWN | NULL | ···· | benjamin.mitchell42@gmail.com | 7287 DESERT SKY BOULEVARD | San Diego | CA | 92144 | — | — |
| PRV | PRV-20278 | 2026-08-26T09:37:19Z | Helen | — | Holmes | 1978-08-01 | UHC-13051-27 | UNKNOWN | +1 234 757 4996 | ·- | 2988 ELM ST | Austin | TX | NULL | NULL | — |
| PRV | PRV-27690 | 2026-01-21T07:50:55Z | ·Pat | ···· | Hansen | 5/16/1975 | - | N/A | 928-577-0943 | — | 1164 Broadway Apt 1 | Denver | CO | 80225 | ···· | — |
| PRV | PRV-20302 | 2026-04-07T13:27:30Z | joseph | — | lucas | 1997-08-08 | UHC-25670-12 | - | 2542346012 | null | N/A | — | UNKNOWN | N/A | UNKNOWN | — |
| PRV | PRV-26685 | 2026-01-16T19:04:43Z | STEPHANIE | F | DAY | 1960-85-02 | UHC-13402-27·· | NULL | 576-483-8525 | stephanie.day@outlook.com | 5173 Highland Avenue | Atlanta | GA | 30361-6326 | null | UNKNOWN |
| PRV | PRV-24418 | 2026-01-12T18:11:43Z | Albert | O. | Tran | Dec 8, 2004 | N/A | null | 17418427978 | ·· | 2632 Cedar Ln | AUSTIN | TX | 78779 | N/A | null |
| PRV | PRV-22764 | 2026-01-02T00:49:44Z | JESSICA | — | BROOKS | ·01/08/1968 | UHC-63784-90 | NULL | 5462337236 | — | 5621 Elm St | Glendale | Arizona | 85362 | -·· | - |
| PRV | PRV-24245 | 2026-03-27T20:43:24Z | Raymond | — | Ward | 1972-06-13 | UHC6717296 | N/A | 463-636-9559 | — | NULL | null | NULL | — | — | NULL |
| PRV | PRV-20186 | 2026-03-27T05:14:44Z | EMILY | — | LEWIS | 02-11-1993 | UHC-88929-09 | NULL | 14795943555 | EMILY.LEWIS@YAHOO.COM | 8519 Willow Ct | Glendale | AZ | 85337 | ·null | — |
| PRV | PRV-22924 | 2026-06-13T05:09:55Z | JUSTIN·· | — | ROBERTS | 1993-12-10 | — | — | +1 807 775 4857 | JUSTIN.ROBERTS96@AOL.COM | 3616 Valley View Dr | Plano | TX | — | null | — |
| PRV | PRV-28306 | 2026-04-29T02:03:24Z | Benjamin | — | Ellitt | 11/20/1982 | UHC-21392-85 | null | 7113154958 | benjamin.elliott57@proton.me | 8890 Church St | Las Vegas | NV | 89163 | — | NULL |
| PRV | PRV-20859 | 2026-01-24T11:51:01Z | KEITH | D | MORALES | 1973-08-27 | ·· | NULL | 555-670-4672 | — | 9255 WASHINGTON STREET | Plano | TX | 75009 | UNKNOWN | NULL |
| PRV | PRV-24633 | 2026-08-05T08:16:33Z | Hunt, Mei | — | — | 12/20/1946 | UHC-84600-88 | null | — | ·NULL | 7787 BASELINE ROAD | PHOENIX | AZ | 85053 | ·· | — |
| PRV | PRV-25241 | 2026-07-28T17:10:25Z | RYAN | — | CHEN | 1104-19-63 | UHC-69720-39 | •••-••-6278 | null | ryan.chen51@yahoo.com | 4269 Maple Ave #585 | San Diego | CA | 92151-9763 | — | null |
| PRV | PRV-26003 | 2026-08-29T14:53:08Z | keith | I | gordon | 1965-09-11 | - | - | +1 393 629 3122 | - | 9536 LAKE VIEW RD Apt 38 | Dallas | ·Texas | 75240 | - | CORE-HMO |
| PRV | PRV-23499 | 2026-03-29T12:38:37Z | Hanson, Hiroshi | X. | — | 12/11/39 | UHC-76924-24 | — | +1 948 475 5377 | hiroshi.hanson@icloud.com | 6791 BASELINE ROAD | Minneapolis | MN | 55425·· | — | NULL |
| PRV | PRV-24909 | 2026-04-04T03:28:41Z | Noah | C | Santiago | 1979-07-05 | UHC-16502-20 | — | 461-723-9726 | N/A | 7426 BASELINE ROAD | Los Angeles | CA | 90037 | NULL | NAVIGATE-HMO |
| PRV | PRV-29274 | 2026-06-18T02:30:06Z | CAMILA·· | — | COOK | 1993-11-17 | uhc-38400-90·· | •••-••-7718 | (540) 739-2334 | ·NULL | 8990 Willow Ct | San Diego | ·CA | 92184 | — | ·N/A |
| PRV | PRV-26025 | 2026-02-24T10:26:48Z | Spencer, Michelle | — | ·· | 7/28/2002 | - | N/A·· | 17833940461 | — | 4328 Pine Dr·· | PLANO | TX | 75094 | — | - |
| PRV | PRV-24732 | 2026-05-04T00:36:57Z | Juan | — | Butler | 3/8/1952 | UHC-52359-45 | •••-••-3426 | UNKNOWN | — | 4309 WILLOW CT | Plano | TX | 75031-2575 | — | ·SELECT-EPO |
| PRV | PRV-21113 | 2026-05-24T10:33:13Z | TYLER | — | WAGNER | 07/18/52 | UHC-10977-65 | null | (630) 916-5474 | tyler.wagner@icloud.com | 8381 MAIN STREET | GILBERT | AZ | 85270 | N/A | NULL |
| PRV | PRV-22960 | 2026-06-11T05:17:32Z | TERESA | ···· | YANG | 1939-07-03 | UHC-95957-35 | N/A | 5948036884 | -·· | UNKNOWN | ···· | NULL | N/A | — | CORE-HMO |
| PRV | PRV-23686 | 2026-08-25T17:52:31Z | Henry | — | Tucker | 1952-11-16 | null | null | 7985451731 | N/A | 242 Washington Street | Nashville | tn | 37277 | ·NULL | choice-plus-ppo |
| PRV | PRV-23339 | 2026-05-28T13:07:53Z | Samuel | — | Williamsson | 08/28/60 | UNKNOWN | — | 8539419914 | — | 1245 Sage Court | Orlando | FL | 32837 | null | - |
| PRV | PRV-23916 | 2026-05-24T00:24:54Z | Stephen | — | Schmidt | ·1948-08-13 | — | ···· | — | stephen.schmidt66@yahoo.com | 4988 Pine Drive | Glendale | AZ | ·85340-4315 | null | UNKNOWN |
| PRV | PRV-28812 | 2026-07-13T23:30:50Z | CAROL | ···· | WARREN | 7/21/1952 | — | - | (772) 728-3716 | CAROL.WARREN70@GMAIL.COM | 7040 Hillcrest Road | Gilbert | AZ | 85266 | UNKNOWN | UNKNOWN |
| PRV | PRV-23251 | 2026-07-24T16:33:29Z | Heather·· | — | Webb | 1971-06-17 | UHC-98163-77 | •••-••-6880 | (421) 313-1810 | NULL | 4296 Harbor Blvd | Dallas | TX·· | ·75252 | — | — |
| PRV | PRV-23281 | 2026-05-10T15:50:15Z | Lori·· | — | Jordan | 05/24/85 | UHC-12979-70 | — | +1 721 492 7607 | null | 3367 Ocean Avenue | Mesa | AZ | 85209 | ···· | — |
| PRV | PRV-28112 | 2026-05-08T03:19:34Z | Grace | ·· | Wong | 1999-12-03 | UHC-13056-47 | •••-••-1643 | UNKNOWN | NULL | ·UNKNOWN | - | UNKNOWN | null | — | 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:56.144Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty