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-27202 | 2026-07-28T09:08:55Z | Isabella | ···· | Perkins | 1995-04-22 | UHC-94647-17 | - | +1 987 346 1132 | isabella.perkins29@gmail.com | 4650 Union Street | DALLAS | TX | 75245 | NULL | — |
| PRV | PRV-27272 | 2026-04-23T21:40:54Z | Daniel | — | Garcia | 12/04/1976 | — | — | (826) 991-2312·· | — | 645 Union Street | ·ORLANDO | FL | 32805 | - | — |
| PRV | PRV-21370 | 2026-03-05T16:52:59Z | JESSE | — | HERNANDEZ | 1989-02-19 | ···· | NULL | 796.602.5148 | jesse.hernandez62@hotmail.com | 2786 SPRING STREET | FRESNO | CA | NULL | - | SELECT-EPO |
| PRV | PRV-25457 | 2026-05-19T13:32:33Z | Judy | — | Soto | 1981-01-26 | UHC6435417 | N/A | 6219908463 | — | 9496 RIDGE RD | Glendale | AZ | 85322 | — | null |
| PRV | PRV-24550 | 2026-05-22T05:34:21Z | Ahmed | V | Hernandez | 1942-04-15 | UHC-21736-01 | UNKNOWN | null | N/A | 3347 Jefferson Ave | Sacramento | CA | 95805 | ·· | UNKNOWN |
| PRV | PRV-24112 | 2026-03-06T11:20:24Z | Nancy | E | Richardson | ·1989-05-28 | UHC-36357-39 | •••-••-6411 | 6637138851 | nancy.richardson@proton.me | 7539 Canyon Rd | SAN ANTONIO | TX | 78216 | UNKNOWN | — |
| PRV | PRV-21101 | 2026-08-06T13:13:18Z | diego | — | pena | ·08/12/1993 | — | ·- | 5868388473 | — | 43 Washington St | Atlanta | GA | 30375 | UNKNOWN | -·· |
| PRV | PRV-29342 | 2026-09-08T22:37:39Z | CHARLES·· | — | JORDAN | 3/19/1963 | UNKNOWN | — | (856) 232-5024 | charles.jordan@proton.me | 9327 Pine Drive·· | Las Vegas | NV | 89168 | N/A | NULL |
| PRV | PRV-28209 | 2026-09-13T22:38:44Z | Reed, Raymond | ···· | — | 07/04/97 | — | N/A | 381-651-2027 | raymond.reed@proton.me | ·NULL | - | — | NULL | — | — |
| PRV | PRV-24328 | 2026-09-06T06:22:53Z | ·Carlos | U | Ramos | Jun 9, 1967 | UHC-80608-77 | — | (634) 762-4987 | — | 2238 Indian School Road | TEMPE | AZ | 85255·· | N/A | N/A |
| PRV | PRV-21044 | 2026-10-18T14:09:55Z | Abigail | — | Freeman | 20-01-1940 | null | - | 397.577.5670 | ·ABIGAIL.FREEMAN23@OUTLOOK.COM | 7577 Baseline Rd | Minneapolis | MN | ·55477 | — | — |
| PRV | PRV-27381 | 2026-01-22T05:04:48Z | MATEO | V. | DEAN | 2000-12-27 | UHC-92928-49 | •••-••-5388 | 921.912.0581 | MATEO.DEAN@PROTON.ME | 493 Forest Avenue | Plano | TX | ·75046-7549 | null | — |
| PRV | PRV-21389 | 2026-05-08T12:21:38Z | Andrea | W. | Jimenez | 11/18/1988 | UHC-98262-95 | ·· | (354) 212-6812 | andrea.jimenez@icloud.com | 4934 Broadway | Denver | CO | 80225 | N/A | — |
| PRV | PRV-22702 | 2026-05-02T12:28:05Z | Gomez, Nikholas·· | — | — | 1968-02-09 | ·UNKNOWN | NULL | +1 479 373 0345 | nicholas.gomez56@icloud.com | 5772 Mesa Dr·· | Phoenix | AZ | UNKNOWN | - | — |
| PRV | PRV-26233 | 2026-09-08T07:36:51Z | Nicole | — | ·Soto | Oct 4, 1965 | UHC-91369-21 | •••-••-5648 | +1 490 276 1204·· | - | 1106 Union St·· | ·Jacksonville | FL | 32203·· | UNKNOWN | MEDICARE-ADV-B |
| PRV | PRV-24829 | 2026-01-25T01:09:30Z | Hannah | — | Porter | 2007-10-26 | UHC-06283-41·· | UNKNOWN | 6189332176 | — | 2195 Mesa Dr | Eden Prairie | mn | N/A | NULL | — |
| PRV | PRV-26805 | 2026-09-02T16:57:57Z | alan | ···· | adams·· | 08/10/67 | uhc-50559-22·· | N/A | ·(280) 495-1766 | — | 3569 Meadow Ln | Minneapolis | mn | 55480 | - | ·- |
| PRV | PRV-24047 | 2026-06-11T17:52:17Z | Gary | P | Coopeer | 1949-01-93 | — | ·UNKNOWN | 9572674322 | null | 7995 Sage Court | Atlanta | GA | 30321 | UNKNOWN | SELECT-EPO·· |
| PRV | PRV-29530 | 2026-08-10T12:42:26Z | Jacob | ·· | Espinoza·· | 1943-03-01 | ···· | •••-••-8984 | 2186631113 | NULL | 9827 Lake View Rd | San Diego | ca | 92130 | — | UNKNOWN |
| PRV | PRV-23733 | 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-24796 | 2026-03-14T05:02:07Z | BRITTANY | — | BENNETT | 01-03-1976 | UHC-13990-39 | N/A | (259) 876-8170 | — | 8266 Central Ave | Gilbert | Arizona | 85298 | NULL | NULL |
| PRV | PRV-25175 | 2026-07-30T12:21:31Z | christopher | — | guerrero | ·8/4/1990 | UHC-94197-05 | •••-••-4202 | UNKNOWN | — | 7502 Forest Ave | Scottsdale | AZ | 85226 | N/A | — |
| PRV | PRV-27755 | 2026-07-02T10:09:13Z | FRANK | — | FERNANDEZ | 1987-09-07 | — | — | 421-629-3411 | null | NULL | UNKNOWN | NULL | - | - | — |
| PRV | PRV-29047 | 2026-09-21T10:21:53Z | RAYMOND | Q | ·ALVARADO | 1940-05-14 | uhc-63639-31 | UNKNOWN | 211-491-1603 | raymond.alvarado@outlook.com | 1325 Market St | DALLAS | TX | 75230 | — | null |
| PRV | PRV-28516 | 2026-06-16T03:40:56Z | NATALIE | — | WALSH | 1980-57-07 | N/A | — | UNKNOWN | null | — | NULL | — | - | null | null |
| PRV | PRV-20066 | 2026-09-25T04:10:16Z | AUSTIN | — | STONE | ·1949-11-17 | ·· | •••-••-5740 | 4625530574 | — | 4169 Jefferson Ave Apt 22 | Chandler | AZ | ·85252 | ·NULL | MEDICARE-ADV-A |
| PRV | PRV-23717 | 2026-02-18T03:24:38Z | Fox, Barbara | — | — | 1964-06-23 | ·null | NULL | +1 959 529 7462 | UNKNOWN | ·4433 Ridge Road | Tempe | AZ | 85288 | - | MEDICARE-ADV-A |
| PRV | PRV-20472 | 2026-10-18T08:15:33Z | Joe | W | Olson | Aug 5, 1974 | UHC-29037-70 | UNKNOWN | 9517227677 | NULL | 8587 MEADOW LN | Minneapolis | MN | 55480·· | — | UNKNOWN |
| PRV | PRV-22716 | 2026-06-02T21:43:38Z | SANDRA | M | FOX | 01/19/1971 | UHC-53823-26 | NULL | (235) 287-5157 | sandra.fox@yahoo.com | 8751 Washington Street | Las Vegas | NV | 89156 | — | NULL |
| PRV | PRV-27891 | 2026-04-16T16:25:47Z | Harvey, Joe | C | — | 1970-03-07 | ·UHC-23152-20 | null | 605.402.3698 | UNKNOWN | 7400 Spring St | Orlando | FL | 32890 | N/A | UNKNOWN·· |
| PRV | PRV-28409 | 2026-02-17T13:16:17Z | stephanie | C | martinez | 5/7/1943 | — | ···· | (703) 857-6417 | null | 9578 Camelback Rd | Orlando | FL | 32816 | - | — |
| PRV | PRV-22145 | 2026-06-14T10:27:56Z | Lori | S | Williams | 07/03/84 | UHC-29788-73 | — | 2018001039 | ·- | 7541 Washington St | Fresno | CA | 93734 | — | null |
| PRV | PRV-21697 | 2026-05-13T16:55:52Z | Wylson, Samuel | ·· | — | 2003-04-10 | UHC5340390 | •••-••-3185 | 685-841-3242 | — | 4811 Broadway | Sacramento | ·CA | 95865 | — | - |
| PRV | PRV-26023 | 2026-02-17T01:10:38Z | Russell, Sophia | — | — | ·02/02/99 | NULL | — | +1 327 712 2749 | ·null | 7724 APACHE BOULEVARD | PHOENIX | AZ | 85020-6109 | — | SELECT-EPO |
| PRV | PRV-24027 | 2026-02-04T22:09:33Z | GREEN | — | HIROSHI | 07/05/92 | NULL | N/A | UNKNOWN | - | 367 Harbor Boulevard | Tempe | AZ | ·85249 | — | NULL |
| PRV | PRV-27190 | 2026-10-07T09:06:49Z | Amy | — | Parker | 1963-04-23 | ·UHC-88714-34 | N/A | +1 339 401 0900 | - | 9756 LINCOLN WAY | Los Angeles | CA | 90067-3303 | - | null |
| PRV | PRV-29089 | 2026-03-17T02:50:26Z | theresa | — | yaang | 1991-04-03 | - | NULL | (374) 949-0510 | THERESA.YANG@GMAIL.COM | 6217 BAYSHORE DR | Plano | TX | 75085 | null | null |
| PRV | PRV-29395 | 2026-07-30T06:51:53Z | Asiha | ···· | Warren | 1954-02-24 | UHC-69267-08 | — | 18815888540 | aisha.warren@icloud.com | - | NULL | null | null | N/A | null |
| PRV | PRV-28374 | 2026-02-13T09:12:29Z | Charles·· | — | Kngiht | Sep 19, 1979 | null | — | ···· | charles.knight@icloud.com | 6096 Maple Avenue | Tempe | AZ | 85259 | — | - |
| PRV | PRV-22933 | 2026-05-04T09:29:13Z | — | B. | — | 1982-11-25 | UHC-14257-05 | — | +1 888 985 1041 | ·JAMES.COX61@OUTLOOK.COM | 5562 Indian School Rd | Denver | CO | 80254-6814 | — | NULL |
| PRV | PRV-22611 | 2026-09-01T23:44:50Z | paul | ···· | patel | 1969-07-13 | NULL | •••-••-0921 | UNKNOWN | - | 9164 Union St | Sacramento | CA | 95802 | NULL | CHOICE-PLUS-PPO |
| PRV | PRV-29363 | 2026-07-23T03:55:35Z | Randy | — | Scott | 1973-03-08 | UHC-99947-20 | — | (432) 617-8920 | — | 2010 SUNSET BLVD | Tampa | FL | 33625 | - | - |
| PRV | PRV-27793 | 2026-10-16T07:40:37Z | JENNIFER | — | MURRAY | 1949-07-08 | NULL | •••-••-4360 | 380.833.7421 | JENNIFER.MURRAY62@OUTLOOK.COM | 4105 APACHE BOULEVARD | Gilbert | AZ | 85268-9774 | - | - |
| PRV | PRV-20782 | 2026-01-05T18:16:12Z | Sandra | K·· | Wallace | 1943-05-15 | — | •••-••-1024 | 638.385.7939 | null·· | 9327 Lincoln Way | Mesa | AZ | 85228-0860·· | N/A | NULL |
| PRV | PRV-26542 | 2026-06-17T06:47:52Z | James | — | Reid | 1961-07-16 | — | null | (741) 602-6447 | — | 2241 CHURCH ST | Gilbert | AZ | 85285 | NULL | ·N/A |
| PRV | PRV-20627 | 2026-04-19T19:04:54Z | NOAH | — | HOWARD | 2005-11-15 | UNKNOWN | UNKNOWN | 485-915-0806 | — | NULL | ···· | ·null | null | N/A | NULL |
| PRV | PRV-25584 | 2026-04-23T19:39:22Z | Joe | — | Fox | 1969-04-05 | UHC-72012-65 | ···· | 558-768-1049 | joe.fox@yahoo.com | 62 BROADWAY | Mesa | AZ | NULL·· | NULL | — |
| PRV | PRV-23123 | 2026-07-12T19:34:13Z | MARK | T. | HARVEY·· | 1969-12-23 | UHC8999998 | ·- | - | — | 7633 Bayshore Dr | LOS ANGELES | CA | 90094 | — | UNKNOWN |
| PRV | PRV-20845 | 2026-06-14T10:52:49Z | Philip | — | Le | 1983-04-22 | UHC-39834-94 | - | 7534863035 | PHILIP.LE7@AOL.COM | — | N/A | null | — | — | - |
| PRV | PRV-26066 | 2026-06-04T05:25:30Z | Jerry | X.·· | Martin·· | 03/08/1939 | ·- | UNKNOWN | ·· | - | 8116 Ridge Road | NASHVILLE | TN | 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:52.243Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty