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-21213 | 2026-10-12T21:26:31Z | ALEXANDER | — | MORRISON | 1945-12-23 | NULL | UNKNOWN | 7628921689 | N/A·· | 7056 Cedar Lane | CHANDLER | AZ | 85200 | — | null |
| PRV | PRV-24310 | 2026-07-14T16:39:49Z | Vincent | — | Austin·· | 1943-10-28 | NULL | N/A | 282-433-8277 | UNKNOWN | 9755 Sage Court | Dallas | TX | 75217 | UNKNOWN | — |
| PRV | PRV-23075 | 2026-07-19T04:21:04Z | Fields, Ralph | S.·· | — | 1980-02-01 | — | - | 15338715128 | ralph.fields42@outlook.com | 7885 Washington Street | COLUMBUS | OH | 43225-1224 | — | UNKNOWN |
| PRV | PRV-20947 | 2026-05-19T14:16:42Z | JUSTIN | I. | PALMER | 1950-09-24 | ·- | •••-••-9348 | 841-720-9064 | ···· | 7502 Pine Drive | Phoenix | Arizona | 85043 | NULL | — |
| PRV | PRV-29480 | 2026-03-09T11:45:17Z | Aaron | D | ·Salazar | 19900804 | UNKNOWN | N/A | 4928291758 | N/A | 5972 Sunset Blvd | SACRAMENTO | CA | 95848 | — | - |
| PRV | PRV-25757 | 2026-01-07T17:39:04Z | Ethan | — | Simmons | 1947-08-08 | UHC-10103-53 | — | 927-379-2900 | null | 922 Palm Drive Apt 24 | Tempe | AZ | 85259-7014 | — | — |
| PRV | PRV-26669 | 2026-03-10T22:11:13Z | Kimberly | — | Green | 1987-09-27 | NULL | •••-••-1520 | (822) 339-5011 | N/A | 1921 Hillcrest Road #496 | Orlando | FL | 32823 | — | — |
| PRV | PRV-20408 | 2026-07-29T19:10:58Z | ·joe | Y. | reid | 1960-07-03 | ·uhc-26803-21 | null | 792.630.7434 | joe.reid27@gmail.com | 8020 Sunset Blvd | SEATTLE | Washington | 98118 | UNKNOWN | null |
| PRV | PRV-28219 | 2026-10-04T09:18:32Z | DEBORAH | — | RAY | 03-02-1944·· | UHC-55168-60 | UNKNOWN | (798) 690-7373 | DEBORAH.RAY@PROTON.ME | 596 Indian School Road | Sacramento | California | 95884-0255 | NULL | — |
| PRV | PRV-22476 | 2026-10-02T08:13:02Z | Sara | — | Greene | 1987-04-04 | UHC-84724-26 | UNKNOWN | +1 212 919 2051 | — | — | — | — | UNKNOWN | ···· | — |
| PRV | PRV-27459 | 2026-06-10T15:28:08Z | Michelle | — | Miller | 11/23/48 | UNKNOWN | •••-••-0945 | 898.938.5654 | — | 1803 Main Street | Houston | TX | 77099 | — | N/A |
| PRV | PRV-20215 | 2026-04-02T12:26:39Z | ·Yuki | — | Nichols | 11/24/2006·· | — | — | (382) 709-0440 | — | 2072 Lincoln Way | Denver | CO | 80237 | ·null | NAVIGATE-HMO |
| PRV | PRV-20461 | 2026-01-29T19:49:33Z | MARTHA | G. | CARTER | 09/22/89·· | ·· | — | (892) 333-9841 | - | 8319 Lake View Rd | LAS VEGAS | NV | 89104 | — | NULL |
| PRV | PRV-27524 | 2026-04-25T05:30:13Z | Jason | ·· | Rose | 10/22/1967 | UNKNOWN | — | NULL | — | 4069 Pine Drive | Mesa | AZ | 85230 | null | null |
| PRV | PRV-25250 | 2026-08-08T12:49:39Z | Mariana·· | — | Ryan | 19550509 | — | N/A | — | mariana.ryan99@yahoo.com | 2596 Valley View Drive | Plano | TX | 75082·· | NULL | - |
| PRV | PRV-27534 | 2026-06-16T16:02:51Z | DOUGLAS | — | EDWARDS | 1962-05-28 | UNKNOWN | N/A | 16676298303 | douglas.edwards60@proton.me | 6463 Palm Dr | DENVER | Colorado·· | 80246 | — | — |
| PRV | PRV-27375 | 2026-07-23T07:52:17Z | JERRY·· | W. | CARLSON | Mar 22, 1968 | - | — | 774-793-5492 | UNKNOWN | 6575 Market St | Orlando | FL·· | 32873 | — | UNKNOWN |
| PRV | PRV-24405 | 2026-09-28T06:24:03Z | Judith | ·· | Owens | ·19690917 | — | — | 210-590-6088 | judith.owens@outlook.com·· | null | — | UNKNOWN | null | - | null |
| PRV | PRV-22862 | 2026-07-05T08:28:45Z | frances | D | graham·· | 1971-04-22 | N/A | — | UNKNOWN | UNKNOWN | 1867 Ocean Ave | Nashville | TN | N/A | UNKNOWN | N/A |
| PRV | PRV-28043 | 2026-09-28T04:31:08Z | LAWRENCE | — | ELLIS | 1972-12-15 | UHC-86802-85 | — | (329) 836-6874 | — | 2366 Indian School Road | SAN DIEGO | CA | 92152·· | — | — |
| PRV | PRV-21712 | 2026-05-13T06:03:14Z | kelly | P | aguilar | 1938-11-04 | UHC-52255-77 | null | 2432705425 | kelly.aguilar@yahoo.com | 5312 RIDGE ROAD | San Antonio | Texas | 78246 | — | MEDICARE-ADV-A |
| PRV | PRV-23165 | 2026-01-15T05:38:05Z | maria | — | vazquez | 1980-02-04 | UHC-27606-48 | •••-••-8672 | 12478364773 | — | 8005 Mountain View Dr | Plano | TX | 75021 | UNKNOWN | N/A |
| PRV | PRV-25690 | 2026-06-15T21:55:32Z | JASON | — | GARRETT | 1947-05-05 | N/A | — | NULL | jason.garrett24@aol.com | 3428 HIGHLAND AVE | Austin | TX | 78767 | NULL | null |
| PRV | PRV-29224 | 2026-02-04T22:09:28Z | Mason | Q. | Stone·· | Oct 10, 1983 | - | — | — | — | 5591 Park Place | GLENDALE | AZ | ·85392 | - | ·· |
| PRV | PRV-26160 | 2026-05-06T19:50:14Z | Evelyn | — | ·Rios | ·1993-08-61 | UHC-61519-14 | — | (973) 873-0967 | — | ·5133 Grand Avenue #470 | Tucson | AZ | 85754 | N/A | CHOICE-PLUS-PPO |
| PRV | PRV-28996 | 2026-08-09T11:06:05Z | larry | — | hudson | ·1983-09-17 | UHC-70621-95 | •••-••-4621 | 537.215.6216 | ·larry.hudson14@aol.com | 7931 Elm St | San Diego | CA | 92161 | - | ·NAVIGATE-HMO |
| PRV | PRV-27851 | 2026-08-04T08:15:16Z | Wallace, Lawrence | — | — | 10/13/1975 | — | •••-••-4885 | 846-686-5142 | lawrence.wallace54@gmail.com | — | null | null | - | N/A | CORE-HMO |
| PRV | PRV-22108 | 2026-08-30T02:17:01Z | DYLAN | — | WATKINS | 2007-10-27 | UHC-44967-83 | — | 18029169881 | — | NULL | — | — | NULL | - | - |
| PRV | PRV-22293 | 2026-07-17T19:15:49Z | luis | — | carlson | 1692-02-07 | UHC-63765-77 | •••-••-5905 | - | NULL | 8906 Meadow Lane | Tempe | AZ | - | N/A | ···· |
| PRV | PRV-26687 | 2026-02-11T04:05:15Z | Yang, Marilyn | — | — | 06-11-1980 | null | - | N/A | — | 7292 River Rd | Charlotte | NC | 28209 | - | OPTIONS-PPO |
| PRV | PRV-28436 | 2026-02-27T20:51:52Z | Betty | — | Rodriguez | 2008-01-02 | — | N/A | 8284575874 | BETTY.RODRIGUEZ@PROTON.ME | 1339 Spring St | Plano | TX | 75083 | — | — |
| PRV | PRV-22656 | 2026-03-10T04:10:47Z | alan | — | henry | 04/13/84 | UHC-13004-16 | null | 6118710311 | - | 1586 Maple Ave | Jacksonville | FL | 32243·· | — | SELECT-EPO |
| PRV | PRV-29255 | 2026-04-16T03:07:12Z | Natalie | — | Bennett | 1992-11-25 | UNKNOWN | - | ·19619633546 | - | 517 River Rd | Houston | TX | 77063 | - | — |
| PRV | PRV-23069 | 2026-02-03T02:31:55Z | Victoria | — | Contreras | 1974-07-19 | UHC-26320-40 | •••-••-4448 | 5102282443 | VICTORIA.CONTRERAS@AOL.COM | 7228 Baseline Road | ORLANDO | FL | 32817 | NULL | - |
| PRV | PRV-22860 | 2026-08-21T15:54:16Z | Albert | O | Williams | 1960-08-14 | UHC-50412-25 | - | (660) 267-5424 | UNKNOWN | ·5057 Forest Avenue | Austin | TX | 78727 | — | NULL |
| PRV | PRV-25111 | 2026-09-05T16:32:53Z | Martha | — | Foster | 04/15/1963 | UNKNOWN | - | (209) 499-1159 | null | 539 CHURCH STREET | Nashville | TN | 37292 | — | — |
| PRV | PRV-24126 | 2026-01-11T20:58:24Z | Ralph | — | Wang·· | 03-12-1957 | UHC-14239-31 | — | +1 910 433 6575 | RALPH.WANG11@ICLOUD.COM | 5835 WASHINGTON STREET | CHANDLER·· | AZ | 85295 | — | — |
| PRV | PRV-25340 | 2026-06-27T23:40:25Z | luis | — | pena | 1963-08-21 | UHC-67941-70 | NULL | (940) 837-7937 | null | 7615 River Rd | SAN DIEGO | CA | 92136 | UNKNOWN | OPTIONS-PPO |
| PRV | PRV-29427 | 2026-08-24T00:38:30Z | Martha | — | Luna | 6/14/1981 | N/A | NULL | (874) 418-2831 | ·· | N/A·· | N/A·· | UNKNOWN | - | UNKNOWN | - |
| PRV | PRV-28512 | 2026-08-16T15:13:41Z | ·PRIYA | — | RYAN | Jun 17, 1989 | UHC-94155-47 | - | (477) 641-1864 | — | 6949 Canyon Road | Chandler | AZ·· | ·85249 | — | NULL |
| PRV | PRV-21347 | 2026-07-05T00:53:14Z | ·Mason | — | Bowman | 19-01-1979 | UNKNOWN | NULL | 414-389-4502 | mason.bowman@proton.me | 1815 Sunset Boulevard | Atlanta | Georgia | 30348 | — | ·UNKNOWN |
| PRV | PRV-24388 | 2026-07-10T07:47:20Z | Li, Janice | — | ·· | 5/2/1942 | UHC-15517-50·· | ···· | 396-534-5484 | NULL | 8397 Broadway | Denver | CO | 80201 | ·· | MEDICARE-ADV-A |
| PRV | PRV-21465 | 2026-02-25T05:29:55Z | AUSTIN | V | BERRY | 2007-04-07 | UHC-63286-32 | •••-••-7128 | 15375701799·· | UNKNOWN | 9431 Central Avenue | EDEN PRAIRIE·· | MN | 55329 | null | UNKNOWN |
| PRV | PRV-27596 | 2026-06-18T04:06:24Z | Raymond | Q | Carlson | 2003-12-03 | — | — | 415.662.6976 | raymond.carlson40@aol.com | null | N/A | ···· | N/A | - | NULL |
| PRV | PRV-28044 | 2026-02-03T05:36:13Z | Scott | — | Mitchell | 1975-02-20 | ·NULL | ·N/A | 773.549.2511 | SCOTT.MITCHELL87@YAHOO.COM | 9701 MAIN ST | Scottsdale | AZ | 85219 | null | — |
| PRV | PRV-23148 | 2026-06-02T01:39:22Z | kenneth | — | johnston | 24-01-1958 | UHC-37545-66 | UNKNOWN | 4206521 | — | 7999 Oak St | Tempe | AZ | 85201 | — | MEDICARE-ADV-A |
| PRV | PRV-23628 | 2026-03-08T20:50:07Z | MELIZSA | — | RIVERA | 26-04-1960 | UHC-44304-88 | — | 415.930.7452 | melissa.rivera@gmail.com | 2772 Park Pl·· | ·Atlanta | GA | 30378 | - | null |
| PRV | PRV-27823 | 2026-02-26T23:01:14Z | Ralph | — | Armstrong | 02/11/1957·· | null | — | +1 834 485 6892 | UNKNOWN | 7059 Desert Sky Boulevard | Glendale | AZ | 85367 | NULL | — |
| PRV | PRV-24513 | 2026-01-11T09:18:42Z | BRITTANY·· | — | KELLEY | 1943-09-13 | UHC-07098-28 | null | 3189762810 | — | 9482 Meadow Ln | Dallas·· | TX·· | 75224 | N/A | null |
| PRV | PRV-28757 | 2026-03-19T07:00:44Z | STEPHEN·· | R | FREEMAN | 1991-10-18 | UNKNOWN | NULL | (496) 275-3492 | NULL | 1765 SPRING STREET | Atlanta | GA | 30398 | null | null |
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:03.404Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty