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-21043 | 2026-04-02T10:29:31Z | Samantha | — | Guzman | 1969-12-26 | UHC-92739-37 | — | 911-828-4633 | ···· | 5202 MARKET ST | Los Angeles | CA | 90040 | N/A | — |
| PRV | PRV-28663 | 2026-03-15T13:43:01Z | ANNA | — | HARVEY | 1968-10-09 | null | N/A | NULL | ·· | ·3429 Forest Ave Apt 31 | Chandler | az | 85274 | N/A | CORE-HMO |
| PRV | PRV-28224 | 2026-03-02T23:25:50Z | SHARON | — | DAY | 1962-01-26 | UHC-43990-46 | NULL | 409-448-8805 | N/A | 4771 Indian School Rd | Charlotte | NC | 28232 | — | NULL |
| PRV | PRV-29303 | 2026-04-26T17:24:58Z | Charles | — | Burke | 12-01-1944·· | UNKNOWN | — | +1 674 649 6741 | N/A | 7974 Meadow Ln | Austin | TX | 78770 | UNKNOWN | navigate-hmo |
| PRV | PRV-28867 | 2026-05-12T14:30:33Z | Floras, Jesse | — | — | 2008-11-16 | UHC-66809-51 | UNKNOWN | 751-989-1705 | JESSE.FLORES46@OUTLOOK.COM | 7763 HILLCREST ROAD | Nashville | TN | 37275 | N/A | UNKNOWN |
| PRV | PRV-25861 | 2026-07-30T07:13:09Z | JUDY | — | SCHMIDT | 02/05/02·· | UNKNOWN | •••-••-9889 | (637) 392-3645 | ·N/A | 4339 Park Pl | Tempe·· | AZ | ·85233 | ···· | — |
| PRV | PRV-28471 | 2026-08-12T01:46:55Z | CARLOS | — | BRYANT | 19540918 | — | •••-••-5672 | ·291-994-9150 | null | 6753 HILLCREST ROAD | Tampa | fl | 33609 | UNKNOWN | NULL |
| PRV | PRV-28394 | 2026-02-04T17:30:57Z | RICHARD | — | RYAN | 07/22/2005 | UHC-99882-77 | N/A | 989.926.9507 | - | 1288 Washington Street Apt 35 | Fresno | CA | 93743 | N/A | SELECT-EPO |
| PRV | PRV-29258 | 2026-04-07T12:57:52Z | jonathan | — | meyer·· | 07/27/1993 | UHC-33815-73 | N/A | 9179306798 | jonathan.meyer@proton.me | ·5475 Baseline Road | Atlanta | Georgia·· | 30368 | — | — |
| PRV | PRV-28399 | 2026-07-02T00:54:00Z | david | P. | price | 09-01-1938 | — | NULL | (652) 443-4175 | N/A | 7458 Bayshore Drive | Columbus | OH | 43245-6247 | ·NULL | null |
| PRV | PRV-22409 | 2026-03-26T18:26:40Z | Lucia | — | Cox | 1983-07-14 | UHC-14104-68 | — | 420-625-1798 | LUCIA.COX@AOL.COM | 7864 Harbor Blvd | Fresno | CA | 93710 | — | UNKNOWN |
| PRV | PRV-24534 | 2026-09-25T16:51:48Z | Sophia | U | Williamson | 6/9/1944 | UHC-37598-10 | — | — | null | 7952 Grand Avenue | Plano | TX | ·75077 | — | null·· |
| PRV | PRV-28938 | 2026-07-08T00:59:29Z | Linda | — | Thomas | 07/21/08 | — | — | 2549984 | null | 1820 VALLEY VIEW DRIVE | Mesa | AZ | 85215 | N/A | N/A |
| PRV | PRV-22074 | 2026-02-02T20:52:20Z | JENNIFER | — | HAWKINS | 1943-07-14 | UHC-46500-91 | null | UNKNOWN | jennifer.hawkins90@hotmail.com | 1107 LAKE VIEW ROAD Apt 40 | Denver | CO | 80266 | — | — |
| PRV | PRV-27073 | 2026-10-16T18:50:15Z | ·Vazquez, Maria | V. | — | 6/1/1990 | UHC-44744-44 | - | 8449166831 | NULL | 7929 Union St·· | Charlotte | NC | 28230 | null | UNKNOWN |
| PRV | PRV-24324 | 2026-01-01T03:42:40Z | nathan | — | watkins | 1982-09-26 | UHC-78419-09 | NULL | 18563790874 | — | 7109 Central Avenue | Phoenix | az | 85034 | - | UNKNOWN·· |
| PRV | PRV-23108 | 2026-04-04T21:54:02Z | Arthur | — | Santos | 1960-11-09 | — | — | 3755721481 | ARTHUR.SANTOS@OUTLOOK.COM | - | NULL | — | N/A | UNKNOWN | ···· |
| PRV | PRV-28211 | 2026-10-09T23:37:12Z | Shirley | T | Carr | 1938-09-16 | — | N/A | — | shirley.carr@proton.me·· | 281 Meadow Ln #541 | Fresno | CA | 93770 | — | N/A |
| PRV | PRV-25573 | 2026-04-11T03:46:25Z | Nancy | N | Morgan | 1988-01-04 | N/A | UNKNOWN | 6385606 | NANCY.MORGAN1@GMAIL.COM | 1598 CANYON RD | Minneapolis | MN | 55415 | N/A | -·· |
| PRV | PRV-23416 | 2026-01-20T17:13:46Z | Eugene | — | ·Freeman | 02/19/40 | — | — | 898-450-1490 | null | 8536 OAK STREET | Austin | TX | 78732 | — | N/A·· |
| PRV | PRV-24197 | 2026-09-27T07:40:29Z | ·jordan | — | stone | 1989-11-22 | UHC-29838-90 | null | 453.401.9809 | — | — | — | null | — | - | null·· |
| PRV | PRV-24182 | 2026-07-27T04:30:48Z | maria | — | kim | 1946-06-22 | — | •••-••-8470 | - | ·MARIA.KIM55@OUTLOOK.COM | 1529 MARKET STREET | ·Tempe | ·AZ | 85233 | - | CHOICE-PLUS-PPO |
| PRV | PRV-29368 | 2026-08-28T02:34:08Z | Nathan | — | ·Heernandez | 09/28/98 | -·· | NULL | 6626810799 | N/A | UNKNOWN | UNKNOWN | N/A | — | null | ·UNKNOWN |
| PRV | PRV-28892 | 2026-06-22T21:53:16Z | ELIZABETH | — | PENA | 1972-08-11 | N/A | - | 564-473-2575 | null | 8280 Apache Boulevard | Houston | TX | 77028 | — | ·NULL |
| PRV | PRV-24417 | 2026-01-11T20:58:32Z | CAROLYN | J | BENNETT | 1962-07-28 | — | UNKNOWN | 339.432.2127 | NULL | 4016 Baseline Rd | Jacksonville | FL | 32221 | UNKNOWN | N/A |
| PRV | PRV-21959 | 2026-05-14T20:56:57Z | ARJUN | R | HUNT | 2002-02-13·· | NULL | null | (707) 788-7410 | — | N/A | N/A | N/A | - | — | UNKNOWN |
| PRV | PRV-28588 | 2026-05-02T23:35:37Z | KAYLA | — | DOMINGUEZ | 2005-12-04 | - | N/A | (792) 368-9334 | ·- | 3204 Bayshore Dr | Plano | TX | 75051-5974 | ·UNKNOWN | — |
| PRV | PRV-26988 | 2026-10-10T14:23:39Z | Day, Kathleen | — | — | ·1982-02-23 | UHC-81831-31 | — | null | UNKNOWN | 5003 Ocean Avenue | ·Glendale | AZ | 85390-5779 | - | NAVIGATE-HMO |
| PRV | PRV-28190 | 2026-06-18T22:33:19Z | MARCUS | — | MONTGOMERY | 1966-02-07 | ·UHC-94734-12 | null·· | (739) 222-7653 | marcus.montgomery@gmail.com | 1942 Meadow Ln | CHANDLER | AZ·· | 85203 | null | UNKNOWN |
| PRV | PRV-23807 | 2026-04-23T05:11:54Z | Jonathan | Q | Ruiz | 1954-10-10 | UHC-38105-67 | null | 4116103 | ·NULL | 5460 Broadway | Plano | TX | 75096 | - | ·OPTIONS-PPO |
| PRV | PRV-29533 | 2026-01-03T10:23:38Z | mateo | — | black | ·09/12/1994 | ···· | N/A | 3126194905 | null | — | -·· | UNKNOWN | - | - | - |
| PRV | PRV-27093 | 2026-02-23T08:24:14Z | PATRICIA | — | GIBSON | Jun 6, 2002 | - | — | 3894389925 | — | 9178 Cedar Ln | Denver | CO·· | NULL | NULL | — |
| PRV | PRV-24020 | 2026-08-15T05:24:38Z | TERESA | L | CASTRO | 07/06/74 | UHC-25853-30 | — | (596) 856-2151·· | — | 324 Ridge Road | Tampa | FL | UNKNOWN | — | — |
| PRV | PRV-25983 | 2026-09-02T22:00:43Z | Phillips, Adam | T. | — | 10/14/1981 | UHC-19294-10 | — | (295) 450-1523 | — | 4287 Washington Street | San Antonio | ·TX | 78273·· | N/A | — |
| PRV | PRV-26060 | 2026-06-18T05:33:44Z | ·MASON | — | SANCHEZ | ·1953-01-04 | — | UNKNOWN | — | N/A | 1884 FOREST AVENUE | San Antonio | TX | 78278 | — | N/A |
| PRV | PRV-26145 | 2026-05-08T17:22:18Z | GARY | — | JENKINS | 1989-05-08 | NULL·· | — | (237) 716-2164 | — | 5509 Palm Drive | Jacksonville | FL | 32273·· | null | — |
| PRV | PRV-29502 | 2026-05-16T19:22:34Z | Noah | N·· | Fuller | 1992-09-24 | UHC-26908-10 | — | 5162435322 | noah.fuller@yahoo.com | 443 Broadway | Houston | Texas | 77060 | UNKNOWN | — |
| PRV | PRV-26457 | 2026-07-29T11:28:17Z | Kayla | ·· | Rice | 1997-11-11 | UHC-34816-40 | — | (510) 625-8098 | — | 3442 CHURCH STREET | Gilbert | AZ | 85272 | — | N/A |
| PRV | PRV-27036 | 2026-02-16T09:12:51Z | ANDREA | — | LUCAS | 19920401·· | UNKNOWN | •••-••-3186 | 381.636.5031 | NULL | 4378 Lake View Rd | Denver | CO | 80245 | ·NULL | UNKNOWN |
| PRV | PRV-29545 | 2026-10-14T11:26:35Z | MARY | — | FOSTER | 1978-06-27 | ·uhc-70030-68 | — | 19672593697·· | N/A | - | UNKNOWN | ···· | NULL | — | UNKNOWN·· |
| PRV | PRV-22126 | 2026-09-01T08:10:11Z | ·Janet | — | Boyd | 1976-01-03·· | N/A | NULL | 784-816-0075 | — | 711 Desert Sky Blvd | Nashville | TN | 37271 | null·· | ···· |
| PRV | PRV-20641 | 2026-05-07T01:32:35Z | Mateo | — | Tran | 01-12-1990 | — | ·· | (413) 977-8715 | N/A | 849 ELM STREET | SAN ANTONIO | Texas | 78207 | null | — |
| PRV | PRV-21468 | 2026-04-13T07:12:28Z | Patricia | — | Grant | 19621113 | UHC-86096-74 | - | 317-745-2390 | — | 2725 Hillcrest Road | Mesa | Arizona | — | N/A·· | CHOICE-PLUS-PPO |
| PRV | PRV-29034 | 2026-05-25T06:00:14Z | Joseph | I | Lucas | 1963-11-28 | UHC-13804-58 | — | 630-268-9018 | — | 4555 LINCOLN WAY | Atlanta | ·GA | 30345-3962 | ···· | NAVIGATE-HMO |
| PRV | PRV-26012 | 2026-01-25T23:04:09Z | SHIRLEY | — | ARNOLD | 1994-10-28 | — | N/A | 8925602942 | shirley.arnold66@icloud.com | null | — | NULL | - | — | — |
| PRV | PRV-22500 | 2026-02-13T01:45:30Z | Morrison, Lawrence | L | — | 1965-09-14 | UHC-89838-16 | N/A | 18405275947 | — | 2495 PINE DR | Miami | FL | ·33199 | — | NULL |
| PRV | PRV-22175 | 2026-02-12T14:30:45Z | CARROLL | C. | PAT | 01/15/1986 | NULL | •••-••-8593 | 510.648.9849 | — | 9191 Meadow Lane | San Antonio | TX | 78280·· | null | UNKNOWN |
| PRV | PRV-22605 | 2026-09-19T09:42:11Z | Elizabeth | — | Bell | 12/27/1969 | UHC-65359-87 | — | (347) 649-1358 | ELIZABETH.BELL@HOTMAIL.COM | 4741 Hillcrest Road | Dallas | TX·· | 75249 | UNKNOWN | N/A |
| PRV | PRV-22669 | 2026-03-27T07:16:50Z | ·Santiago | — | McDonald | ·1991-02-20 | — | •••-••-4989 | 15596507491 | UNKNOWN | 9803 CANYON RD | DENVER·· | CO | 80207 | — | — |
| PRV | PRV-23085 | 2026-01-18T10:24:26Z | ·Joshua | — | Rogers | 01/23/1964 | ·UNKNOWN | •••-••-3563 | 17892493354 | null | 7625 MAPLE AVENUE·· | San Diego | California | 92187 | - | — |
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:46.062Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty