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-22327 | 2026-07-21T22:21:14Z | Crawford, Brian | X | ·· | 1992-10-20 | uhc-01606-11 | •••-••-6699 | — | - | 8357 Mountain View Drive | Nashville | TN | 37218 | NULL | — |
| PRV | PRV-24845 | 2026-01-08T22:57:12Z | ·Arthur | T. | Wagner | 19540618 | UHC-89496-41 | - | — | UNKNOWN | ·6277 Spring St | Tempe | AZ | 85224 | NULL | null |
| PRV | PRV-20721 | 2026-07-18T03:29:11Z | KATHLEEN | — | COLE | 1991-08-26 | UHC-27256-01 | •••-••-0743 | (584) 507-2561 | — | 7611 Central Ave | FRESNO | CA | 93730-6505 | UNKNOWN | — |
| PRV | PRV-23094 | 2026-07-25T06:06:05Z | ralph | G. | burns | 1962-07-13 | NULL | — | (227) 615-7714 | NULL | — | null | null | NULL | — | CHOICE-PLUS-PPO |
| PRV | PRV-25307 | 2026-03-19T05:15:05Z | MARIANA | — | RAY | 14-12-1981 | — | — | 4435063290·· | NULL | 5557 HILLCREST ROAD | Minneapolis | MN | 55417 | ·· | UNKNOWN |
| PRV | PRV-22738 | 2026-06-18T04:09:59Z | Cynthia | ·I. | Diaz | ·02-12-2002 | UHC-72241-56·· | — | ·858.606.4607 | — | 4342 BASELINE ROAD | Denver | Colorado | 80274 | — | SELECT-EPO |
| PRV | PRV-26040 | 2026-06-09T14:24:50Z | donna | — | ·greene | UNKNOWN·· | UHC-31782-23 | NULL | 856-860-9815 | donna.greene81@proton.me | 5500 HILLCREST RD | San Diego | CA | 92179 | — | NULL |
| PRV | PRV-23895 | 2026-02-04T19:33:26Z | Camila | — | Snyder | 19511111 | — | - | 325-553-1780 | CAMILA.SNYDER@HOTMAIL.COM | 8443 VALLEY VIEW DR | Austin | TX | 78762 | NULL | — |
| PRV | PRV-24494 | 2026-02-09T20:18:16Z | Andrew | — | Larson | 1994-01-10 | UHC-19155-72 | null | 2022588 | null | 7764 HIGHLAND AVENUE | AUSTIN | TX | 78710 | null | NULL |
| PRV | PRV-26263 | 2026-06-02T22:18:27Z | Josaph | — | Stephens | 5/21/1975 | UNKNOWN | - | 13204081111 | — | — | N/A | NULL | null | — | UNKNOWN |
| PRV | PRV-27839 | 2026-10-09T16:48:30Z | THERESA | ···· | RIOS | 07/20/08 | UHC-59751-66 | null | null | — | 3083 Sage Ct | Houston·· | TX | 77063 | — | - |
| PRV | PRV-24249 | 2026-06-02T11:08:47Z | ·Porter, Jordan | — | — | 2001-04-17 | UNKNOWN | - | - | - | 2631 HIGHLAND AVENUE | Austin | TX | 78707 | — | — |
| PRV | PRV-26290 | 2026-07-26T00:02:26Z | abbby | — | cunningham | 1938-09-28 | UNKNOWN | •••-••-6999 | (877) 295-3074 | — | 4046 Oak Street | TAMPA | FL | 33663 | — | null·· |
| PRV | PRV-20462 | 2026-05-12T02:42:07Z | Natalie | J | Simpson | 1940-11-11 | UHC-12051-83·· | UNKNOWN | 4947090529 | NATALIE.SIMPSON40@YAHOO.COM | 4332 MAPLE AVE | Jacksonville | FL | UNKNOWN | — | NULL |
| PRV | PRV-23280 | 2026-07-02T00:09:33Z | ·Charles | C | Bryant | 1969-02-06 | ·UHC-01319-03 | N/A | 4216140249 | NULL | 5690 Lincoln Way | SACRAMENTO | CA | 95838-7081 | - | N/A |
| PRV | PRV-23548 | 2026-06-18T21:13:07Z | Sharon | Z | Davis | 1962-12-16 | null | UNKNOWN | — | sharon.davis@proton.me | 5576 Highland Avenue | Fresno | CA | 93750 | UNKNOWN | N/A |
| PRV | PRV-20910 | 2026-05-18T20:10:59Z | Christian | — | Lawson | 1975-02-12 | — | — | null | - | 3874 Jefferson Avenue | CHANDLER | AZ | 85235 | ·· | NULL |
| PRV | PRV-29493 | 2026-02-16T23:36:53Z | Nunez, Sara | ·· | — | 1940-06-09 | UHC-01441-42 | - | 891.719.8125 | sara.nunez@proton.me·· | 3337 MARKET STREET | Los Angeles | CA | ·90049 | null | — |
| PRV | PRV-21950 | 2026-07-26T12:12:38Z | Collins, Danielle | — | ·· | Oct 27, 1983 | null | UNKNOWN | 482-488-4280 | N/A | 2407 Park Pl | ·Tampa | Florida | 33610 | UNKNOWN | CHOICE-PLUS-PPO |
| PRV | PRV-27505 | 2026-08-11T17:36:38Z | ANDREW | A | HARPER | 1980-05-08 | UHC-99041-25 | — | (946) 819-9420 | NULL | 5722 LINCOLN WAY | Tempe | AZ | - | — | N/A |
| PRV | PRV-27455 | 2026-06-11T19:38:03Z | ARTHUR | P | CARTER | 09/20/53 | ·null | N/A | 5048582651 | ARTHUR.CARTER@YAHOO.COM | 7582 Washington Street | CHANDLER | AZ | 85272 | — | - |
| PRV | PRV-26851 | 2026-09-27T22:51:28Z | RACHEL | — | GARZA | 1951-02-09 | — | — | (236) 328-3587 | — | 4470 Park Place | Fresno | CA | 93732·· | — | - |
| PRV | PRV-25659 | 2026-08-08T13:16:19Z | RYAN | A | GONZALEZ | 1945-02-20 | null | — | 903-891-7608·· | — | 7455 Ridge Road | ·Dallas | TX | 75209 | — | - |
| PRV | PRV-23478 | 2026-01-10T20:05:23Z | Yuki | E | Hunter | 08-10-1998 | — | - | 8896057324 | — | 730 Forest Avenue | FRESNO | California | 93780 | — | NULL |
| PRV | PRV-25563 | 2026-09-11T04:03:52Z | Randy | Z.·· | Fisher | 1/26/1984 | — | N/A·· | +1 840 554 7906 | randy.fisher89@aol.com | N/A | — | UNKNOWN | - | — | CHOICE-PLUS-PPO |
| PRV | PRV-25246 | 2026-08-11T01:01:15Z | Parker, Amy | F | — | 05/10/48 | UHC-80718-08 | •••-••-0257 | 7085473846 | NULL | 3601 Jefferson Avenue | Scottsdale | AZ | 85292 | UNKNOWN | — |
| PRV | PRV-26224 | 2026-02-12T08:50:48Z | Powell, Michelle | — | — | 1966-11-26 | N/A | — | 8846791047 | null | 7546 OCEAN AVE·· | Chandler | ·Arizona | 85269-5146 | UNKNOWN | UNKNOWN |
| PRV | PRV-23409 | 2026-06-01T07:12:23Z | Juan | C·· | Singh | 1968-07-02 | — | — | 4119668·· | ·null | 4657 Cedar Lane | Miami | FL | 33155 | — | SELECT-EPO |
| PRV | PRV-21663 | 2026-08-27T08:23:57Z | WILLIAM | — | SIMPSON | 1999-12-22 | - | ·NULL | 679.946.4475 | — | 4472 Baseline Rd | Scottsdale | AZ | ·85240 | UNKNOWN | — |
| PRV | PRV-27656 | 2026-08-11T06:46:38Z | AARON | — | ·MORALES | 21-04-1967 | N/A | •••-••-6192 | ·N/A | NULL | 840 Main St | Atlanta | GA | 30315 | null | CHOICE-PLUS-PPO |
| PRV | PRV-21519 | 2026-03-27T10:55:00Z | Ryan | ·· | Green | ·Dec 3, 1995 | — | •••-••-3418 | 5993419936 | -·· | 1735 Sunset Boulevard | Phoenix | AZ | ·85035 | — | N/A |
| PRV | PRV-29549 | 2026-09-20T16:12:47Z | Amber | ·G. | Griffin | 12/09/1939 | UHC-63625-50 | UNKNOWN | N/A | — | 6088 Desert Sky Blvd | San Diego | CA | 92193 | — | — |
| PRV | PRV-28432 | 2026-08-19T03:52:50Z | GREGORY | — | ·PENA | Apr 24, 1944 | UHC-46769-63 | — | 5237698601 | N/A | 1872 Meadow Lane | COLUMBUS | OH | 43218 | NULL·· | - |
| PRV | PRV-24000 | 2026-03-25T11:36:52Z | Sara | ·· | Butler | 03-12-1957 | — | — | 228-339-3807 | — | ···· | — | ·null | — | N/A | OPTIONS-PPO |
| PRV | PRV-24881 | 2026-01-28T16:21:00Z | judith | — | owens | 1954-02-15 | N/A | N/A | (610) 775-6168 | null | 1095 Willow Court | Las Vegas | NV | 89164 | ···· | UNKNOWN |
| PRV | PRV-25505 | 2026-05-19T09:06:59Z | Luis | U | Adams | 06/10/1983 | NULL | — | (724) 233-7381 | null | 6541 Palm Dr | Phoenix | AZ | 85078 | UNKNOWN | NAVIGATE-HMO |
| PRV | PRV-24005 | 2026-07-06T02:35:47Z | Doris | — | Dominguez | 2001-12-16 | N/A | UNKNOWN | 791-620-7064 | — | 6256 Sunset Boulevard | Scottsdale | AZ | 85220 | NULL | N/A |
| PRV | PRV-23669 | 2026-07-14T16:16:11Z | Abigail | — | Alexander | 1940-03-04 | UHC-74593-20 | •••-••-1571 | — | abigail.alexander52@gmail.com | 6190 Indian School Road | Atlanta | ga·· | 30392 | - | MEDICARE-ADV-B |
| PRV | PRV-26683 | 2026-06-08T22:46:09Z | Carlos | — | Williamson | 1977-07-01 | UHC-61358-72 | - | ·7075107974 | — | ·5335 Highland Ave | Tempe | ·AZ | 85242·· | UNKNOWN | — |
| PRV | PRV-22127 | 2026-04-17T19:04:45Z | GRACE | — | ·PHILLIPS | 1939-01-26 | — | NULL | +1 232 261 7469 | — | 7250 Pine Drive | Houston | TX | 77002 | N/A | — |
| PRV | PRV-24238 | 2026-07-21T14:51:56Z | BRUEC | — | WOOD | 2005-07-12 | — | NULL | 497-639-4392 | NULL | 7942 Church St | Tampa | FL | 33626 | null | NULL |
| PRV | PRV-28192 | 2026-03-17T09:44:30Z | DENISE | S | LITTLE | 19751122 | UHC-01972-71 | — | 17135072421 | NULL | 3747 Market St | MESA | Arizona | 85207 | ·· | NULL |
| PRV | PRV-23994 | 2026-04-18T01:41:40Z | HENRY | — | DEAN | 19700910 | UNKNOWN | - | 677-881-4211 | null | 2175 Jefferson Avenue | Glendale | AZ | 85347 | null | — |
| PRV | PRV-20681 | 2026-07-24T09:28:08Z | Lawrence, Johnston | — | — | 10/18/52 | — | NULL | (523) 804-1388 | lawrence.johnston@outlook.com | 5968 Park Pl | Chandler | AZ | 85223 | ·null | MEDICARE-ADV-B |
| PRV | PRV-24445 | 2026-09-25T23:13:01Z | Jacob | — | ·Banks | 1988-07-10 | UHC-77320-90 | UNKNOWN | 4548488407 | null | 5849 Cedar Lane | MESA | AZ | - | UNKNOWN | ·· |
| PRV | PRV-27824 | 2026-02-14T05:10:50Z | Catherine | U. | Medina | Sep 7, 1970 | UHC-50377-75·· | null | ·13318657151 | catherine.medina18@icloud.com | 4377 Park Place | Houston | TX | 77001 | NULL·· | MEDICARE-ADV-A |
| PRV | PRV-24228 | 2026-08-16T00:26:23Z | sara | F | murphy | 1/24/2008 | — | — | — | SARA.MURPHY@OUTLOOK.COM | 7201 Cedar Ln | Las Vegas | NV | 89184 | - | — |
| PRV | PRV-25887 | 2026-03-21T07:47:09Z | Santiago | P | ·OBrien | 1991-08-09 | — | •••-••-5597 | 4775862551 | NULL | N/A | — | N/A | ···· | - | NULL |
| PRV | PRV-24831 | 2026-04-06T17:55:57Z | Carlos | — | Kennedy | 2/5/1976·· | UHC-61491-38 | •••-••-8923 | 901-489-6388 | N/A | 4777 Palm Dr | Orlando | FL | 32867 | — | null |
| PRV | PRV-24506 | 2026-07-09T05:40:05Z | Amanda | — | Gomez | 2008-04-23 | UHC-45484-57 | — | (842) 311-3025 | UNKNOWN | NULL | — | N/A | — | — | — |
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:37.738Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty