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-22951 | 2026-10-14T12:04:20Z | nancy·· | — | lynch | 2/10/1970 | ·UHC-62977-75 | •••-••-3864 | 8325056289 | NANCY.LYNCH68@AOL.COM | ·1365 SPRING ST | DENVER | CO | 80289 | UNKNOWN | — |
| PRV | PRV-27058 | 2026-04-22T20:08:04Z | HELEN | — | PETERS | 16-05-1941 | UHC-13869-39 | — | 862.677.7215·· | - | 7041 RIDGE RD | SCOTTSDALE | AZ | 85268 | ···· | — |
| PRV | PRV-25549 | 2026-07-23T01:42:37Z | Michelle | J. | Carpener | 20031226 | UHC-19794-40 | •••-••-2403 | (446) 624-7822 | N/A | N/A | NULL | UNKNOWN | — | — | N/A |
| PRV | PRV-20528 | 2026-05-05T15:38:56Z | Abigail | — | Snyder | 1970-01-20 | UHC-21758-85 | — | 14774688648 | — | 565 OCEAN AVE | Plano | tx | 75087 | — | — |
| PRV | PRV-26991 | 2026-08-12T11:22:59Z | ISABELLA | — | SILVA | 1973-11-18 | UHC-93649-89 | - | +1 884 318 6465 | - | 9728 Harbor Boulevard | Austin | TX | 78792 | N/A | null |
| PRV | PRV-24730 | 2026-01-14T21:28:36Z | Albert | — | ·Johnston | 13-03-1961 | UHC-99093-54 | null | 9212037775 | - | 6902 Indian School Road | CHANDLER | AZ | 85283 | — | null |
| PRV | PRV-28521 | 2026-01-31T18:07:52Z | Luis | — | Blakc | 1993-12-20 | — | N/A·· | 865-394-1391 | ·· | 6457 Broadway #676·· | Tempe | Arizona | 85276 | UNKNOWN | NULL |
| PRV | PRV-22504 | 2026-08-11T13:47:56Z | JUDY | — | PEYNE | 1950-01-20 | UHC-70825-08 | NULL | ·6587975545 | UNKNOWN | 1141 Indian School Rd | ·MINNEAPOLIS | MN·· | 55402 | null | ···· |
| PRV | PRV-21746 | 2026-03-04T23:14:49Z | Donald | — | Martin | 17-01-1980 | uhc-71366-28 | — | null | NULL·· | 4944 Sage Ct | Gilbert | AZ | 85249 | NULL | — |
| PRV | PRV-21660 | 2026-07-30T15:05:02Z | Mary | — | Schmidt | 1977-05-21 | — | null | N/A | MARY.SCHMIDT44@GMAIL.COM | 6452 Harbor Boulevard | Miami | FL | 33132 | — | ·null |
| PRV | PRV-21886 | 2026-02-17T07:07:34Z | ·Hannah | ···· | Hunt | 1988-10-03 | — | null | — | UNKNOWN | 2590 Sage Ct | Glendale | AZ | 85319 | — | NULL·· |
| PRV | PRV-25833 | 2026-09-08T03:00:10Z | Marcus | G | Phillips | 07/07/1947 | UHC-71760-25 | null | +1 546 892 1111 | marcus.phillips@proton.me | 1165 Indian School Road | Denver | CO | 80293 | ···· | — |
| PRV | PRV-20337 | 2026-03-29T15:17:37Z | Nathan | Y | Delgado | Dec 17, 1947 | uhc-06879-35 | NULL | 12056078663 | ·- | 425 DESERT SKY BOULEVARD | Dallas | TX | 75287 | N/A | — |
| PRV | PRV-22464 | 2026-08-14T08:57:44Z | Janet | ···· | Holmes | 2001-05-05 | UHC-27263-09 | NULL | 760-813-2571 | janet.holmes83@hotmail.com | 5096 River Road | LAS VEGAS | NV | 89148 | - | NULL |
| PRV | PRV-28738 | 2026-02-21T09:36:18Z | Lauren | — | Sullivan·· | 19380708 | UHC-65196-52 | •••-••-8329 | 8249268872 | lauren.sullivan@proton.me | 6489 Oak Street #854 | Seattle | WA | 98189 | - | MEDICARE-ADV-B |
| PRV | PRV-26962 | 2026-04-12T08:14:14Z | Shirley·· | L. | Harrison | 1940-04-24·· | — | null | +1 747 521 2037 | — | 3720 CAMELBACK RD | Atlanta | GA | 30356 | — | — |
| PRV | PRV-20238 | 2026-03-21T18:09:14Z | Kenneth | — | Stewart | Mar 25, 1995 | — | UNKNOWN | 12322345091 | - | 2211 Mesa Dr | Denver | CO | 80273-1592 | ·- | OPTIONS-PPO |
| PRV | PRV-27531 | 2026-04-29T11:28:48Z | Abigail | B | Stone | 1952-01-07 | UNKNOWN | •••-••-0530 | (773) 518-9731 | - | 7249 RIVER ROAD·· | Seattle·· | WA | 98171 | NULL·· | — |
| PRV | PRV-23141 | 2026-07-12T20:29:01Z | Powell, Edward | — | — | 1968-08-27 | UHC-15445-60 | N/A | (700) 866-4825 | edward.powell76@outlook.com | 1518 Indian School Rd | Tucson | AZ | 85731 | null | N/A |
| PRV | PRV-23662 | 2026-08-08T17:39:16Z | Ethan | — | Walsh | 3/7/1941 | — | •••-••-8007 | 562.237.7660 | ETHAN.WALSH@GMAIL.COM | 5428 Mountain View Drive | TAMPA | FL·· | 33633 | UNKNOWN | - |
| PRV | PRV-25430 | 2026-07-18T15:27:10Z | Paul | — | Campbell | 07/01/57 | UHC-49908-48 | NULL | -·· | — | 571 Palm Drive | SACRAMENTO·· | CA·· | 95891 | — | — |
| PRV | PRV-20298 | 2026-10-17T06:47:09Z | carolyn | — | lewis | 1996-08-27 | - | — | — | CAROLYN.LEWIS40@HOTMAIL.COM | 5024 Spring Street | CHARLOTTE | NC | 28254 | NULL | — |
| PRV | PRV-23582 | 2026-05-19T22:42:49Z | Debbie | X | Jimenez | 11/20/1956 | NULL | — | UNKNOWN | DEBORAH.JIMENEZ12@AOL.COM | 5416 Market Street | Orlando | FL | 32873 | — | — |
| PRV | PRV-23522 | 2026-08-01T23:13:16Z | Kyle | — | Henry | 1990-02-17·· | null | — | 5553431166 | NULL | 7259 Ocean Avenue | Seattle | ·WA | 98176 | NULL | MEDICARE-ADV-A |
| PRV | PRV-28380 | 2026-03-07T12:04:27Z | Madison | — | Butler | 1975-06-07 | NULL | — | — | madison.butler@gmail.com | N/A | N/A | N/A | -·· | N/A | CHOICE-PLUS-PPO |
| PRV | PRV-28254 | 2026-09-09T10:38:29Z | Logan | J | Larson | 04/19/45 | - | - | 986.688.7457 | N/A | 6157 Forest Avenue | Phoenix | AZ | 85053 | UNKNOWN | — |
| PRV | PRV-23874 | 2026-08-23T12:09:48Z | Keith | V | Smith | 19970506 | UHC-42383-68 | •••-••-4877 | 4134845736 | UNKNOWN | 8139 WASHINGTON STREET | Jacksonville | FL | 32275 | — | — |
| PRV | PRV-21937 | 2026-05-17T04:36:38Z | Sophia | Z. | Carroll | 23-02-1979 | — | — | +1 581 638 8412 | — | 5642 Desert Sky Blvd | Atlanta | GA | 30394 | — | - |
| PRV | PRV-26646 | 2026-04-20T00:20:13Z | MERIANA | — | RIOS | 1962-04-19 | UHC7575451 | — | 18695158736 | — | 9238 Washington Street | Orlando | FL | 32816 | ·null | — |
| PRV | PRV-26448 | 2026-09-07T06:40:38Z | Eric | — | Walsh | 9/23/1948 | NULL | — | null | — | 2093 Indian School Road | TUCSON | AZ | 85756 | — | null |
| PRV | PRV-20977 | 2026-06-14T19:33:28Z | Bruce | G·· | Cooper | 06/28/67 | N/A | N/A | 8924544397 | — | — | - | — | - | UNKNOWN·· | — |
| PRV | PRV-22173 | 2026-08-29T11:27:32Z | Emily | — | Spencer | 14-01-2002 | N/A | NULL | 4985182489 | null | 7951 Bayshore Dr | Los Angeles | CA | 90029 | UNKNOWN·· | — |
| PRV | PRV-26022 | 2026-10-09T03:30:59Z | Catherine | — | Gonzales | 1976-10-27 | — | UNKNOWN | 905-413-2211 | CATHERINE.GONZALES@PROTON.ME | 8551 Lake View Road Apt 28 | LOS ANGELES·· | CA | 90032 | UNKNOWN | ···· |
| PRV | PRV-22179 | 2026-02-03T13:09:17Z | ·JORDAN | — | HARRIS | Dec 25, 1951 | — | ·null | (259) 646-1176 | - | 1233 FOREST AVENUE | ·Las Vegas | NV | 89120 | — | null |
| PRV | PRV-25681 | 2026-06-14T18:04:40Z | Timothy·· | — | Clark | 09/22/59 | UHC-35369-94 | - | 3883590899 | TIMOTHY.CLARK@PROTON.ME | 1801 Mountain View Drive | ORLANDO | fl | 32874 | UNKNOWN | N/A |
| PRV | PRV-25044 | 2026-06-05T02:02:49Z | Peter | ·· | Arnold | 1994-08-02 | NULL | N/A | 831-392-4397 | N/A | 1574 Oak St | Mesa | AZ | 85216 | NULL | — |
| PRV | PRV-22554 | 2026-10-08T09:13:07Z | JACQUELINE | — | BAKER | 1945-11-08 | — | — | 7607876 | JACQUELINE.BAKER@ICLOUD.COM | 6071 Palm Drive | ATLANTA | GA | 30360 | null | NULL |
| PRV | PRV-24424 | 2026-06-21T21:52:16Z | Ray, Elizabeth | ···· | — | Aug 26, 1992 | UHC-71909-01 | NULL | 5403587821 | elizabeth.ray25@icloud.com | 3693 MAIN ST | Scottsdale | AZ | 85288 | UNKNOWN·· | - |
| PRV | PRV-23732 | 2026-09-02T16:13:05Z | ·SUSAN | — | WATSON | 1941-02-08 | N/A | — | 240-316-1345 | UNKNOWN | ·2514 Broadway | ATLANTA | GA | 30335 | N/A | — |
| PRV | PRV-27122 | 2026-02-03T18:51:22Z | MADISON | — | EDWARDS | ·Jan 13, 1995 | N/A | NULL | (435) 683-0530 | madison.edwards@outlook.com | 7010 MEADOW LANE | Charlotte | NC | 28277·· | UNKNOWN·· | ·· |
| PRV | PRV-25297 | 2026-06-07T10:49:37Z | Madison | ·· | Stephens | 1951-08-04 | — | - | 482-324-9184 | - | 1893 WASHINGTON ST | Chandler | AZ | 85243 | - | — |
| PRV | PRV-25892 | 2026-06-07T03:15:04Z | DORIS | — | ·CHAVEZ | 1945-06-01·· | UHC-61116-89 | — | +1 621 916 2496 | — | 3187 MAIN ST | Phoenix | AZ | 85004 | — | null |
| PRV | PRV-20511 | 2026-06-21T14:17:29Z | Thomas, Andrew | — | — | 06/26/38 | null | N/A | 16132471757 | — | 3126 INDIAN SCHOOL RD Apt 17 | TAMPA | FL | 33694 | null | — |
| PRV | PRV-28807 | 2026-06-28T10:04:13Z | patrick·· | — | garcia | 01/23/1994 | UHC-20619-89 | •••-••-4657 | (807) 576-2696 | N/A | 1341 Mesa Dr | ·Chandler | AZ | 85226 | — | NAVIGATE-HMO |
| PRV | PRV-23863 | 2026-03-12T08:43:30Z | ·Priya | — | Rogers | 1973-04-22 | UNKNOWN | - | 595-821-8044 | — | 8021 Ocean Ave | Fresno | CA | 93719 | N/A | — |
| PRV | PRV-25751 | 2026-01-01T08:18:38Z | Randy | — | Nelson | 1980-11-09 | null | — | 6327349209 | null | 4414 Sage Ct | Chandler | az | 85229 | — | OPTIONS-PPO |
| PRV | PRV-28233 | 2026-06-07T04:45:58Z | JANICE | L | HAMILTON | 1977-02-23 | - | N/A | 396-672-0156 | janice.hamilton39@hotmail.com | 6541 Cedar Ln | Las Vegas | NV | 89137 | — | - |
| PRV | PRV-24138 | 2026-06-01T08:03:12Z | Walter | — | Medina | 2008-11-16 | UHC-70862-60 | ·null | 766-975-9855 | N/A | 974 Canyon Road | ·Tempe | AZ | 85223-4137 | ·UNKNOWN | UNKNOWN |
| PRV | PRV-23374 | 2026-02-10T11:32:51Z | Kayla | — | Vargas | 1987-08-09 | — | •••-••-5772 | 6316839 | — | ·9824 Elm St | SCOTTSDALE | ·AZ | ·85239-4167 | - | ···· |
| PRV | PRV-26505 | 2026-04-23T11:17:08Z | Hansen, Donna | — | — | 1961-06-10 | — | - | (870) 450-6805 | — | 33 Meadow Lane | Atlanta | GA | UNKNOWN | 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:00.194Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty