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-24552 | 2026-02-20T09:58:17Z | MATTHHEW·· | Q | GILBERT | 1950-10-25 | - | — | +1 716 942 1920 | — | — | — | UNKNOWN | UNKNOWN | N/A | - |
| PRV | PRV-24186 | 2026-03-03T06:25:45Z | Douglas | — | Mendez | 1959-08-10 | null | •••-••-0518 | (343) 885-9555 | — | 630 Apache Blvd | Plano·· | TX | 75015 | — | CORE-HMO |
| PRV | PRV-25136 | 2026-09-05T17:07:54Z | Kathy | L | Weber | 1983-04-19 | UHC-61537-64 | N/A | 966-790-7447 | N/A | 6853 Lake View Road | ·SAN ANTONIO | TX | 78232 | — | CHOICE-PLUS-PPO |
| PRV | PRV-20180 | 2026-10-04T18:15:49Z | Lisa | — | Fernandez | ·02-08-1994 | — | — | 14397644733 | NULL | 6537 Lake View Road | Nashville·· | ·TN | 37219·· | N/A | ·N/A |
| PRV | PRV-20993 | 2026-07-25T04:28:32Z | Billy | ···· | Hughes | 1980-03-14 | UHC-09060-83 | UNKNOWN | 7882827080 | — | 2722 WASHINGTON STREET | Nashville | TN | 37287 | - | UNKNOWN |
| PRV | PRV-26714 | 2026-05-30T00:09:24Z | Brian | — | Guzman | 1991-03-04 | NULL | NULL | ·+1 485 792 4918 | BRIAN.GUZMAN99@ICLOUD.COM | 5697 Camelback Rd | Glendale | AZ | 85340·· | — | — |
| PRV | PRV-27685 | 2026-05-05T09:00:20Z | Jean | — | Campbell | 1944-11-22 | - | ·NULL | 17872370494 | UNKNOWN | ·3206 SAGE COURT | Dallas | Texas | 75214 | ·· | null·· |
| PRV | PRV-23204 | 2026-03-25T01:28:20Z | LARUA | Z. | LI | 1953-03-28 | - | — | - | UNKNOWN | 6983 Willow Ct | Scottsdale·· | ·Arizona | 85213 | — | null |
| PRV | PRV-28118 | 2026-03-20T04:03:04Z | Sofia | — | Ortega | Oct 7, 1997 | NULL | null | ···· | null | 5180 Sage Ct | Eden Prairie | MN | 55390 | — | - |
| PRV | PRV-20172 | 2026-08-12T00:01:31Z | ·William | — | Contreras·· | 1988-08-12 | ·UHC-82947-39 | — | 797-287-3843 | null | - | N/A | — | — | ·null | - |
| PRV | PRV-22857 | 2026-05-23T00:04:13Z | GABRIEL | G | CHEN | 1997-06-05 | UHC-42326-53 | UNKNOWN | 13578173583 | - | null | - | — | - | NULL | — |
| PRV | PRV-20330 | 2026-01-14T13:15:23Z | JESSE·· | F | HUNT | 12/05/06 | NULL | — | ·(969) 529-3747 | null | 2087 Camelback Road #802 | TAMPA | FL | 33636 | - | — |
| PRV | PRV-25253 | 2026-01-14T14:21:00Z | Cheryl | — | Cunningham | Feb 20, 1963 | UHC6986258 | •••-••-9561 | (819) 427-8892 | UNKNOWN·· | 9223 Elm St | Seattle | wa | 98192 | NULL | null |
| PRV | PRV-21049 | 2026-05-08T06:57:24Z | Jessica | G | Rios | 1950-07-04 | UNKNOWN | null | (634) 822-1949 | JESSICA.RIOS@OUTLOOK.COM | 552 Spring Street | Charlotte | nc | 28238 | NULL | - |
| PRV | PRV-24426 | 2026-04-05T16:39:19Z | Cheryl | — | Henderson | 1993-07-27 | UHC3187596 | — | 8965456508 | NULL | UNKNOWN·· | null | — | N/A | - | MEDICARE-ADV-A |
| PRV | PRV-24980 | 2026-03-06T10:31:41Z | Hoffman, Sandra | — | — | 1969-10-27 | ·UHC-22666-98 | — | 7888898371 | SANDRA.HOFFMAN@AOL.COM | 7038 Desert Sky Blvd | Mesa | AZ | 85253 | — | - |
| PRV | PRV-21303 | 2026-05-09T03:17:08Z | Grace | — | Gardner | 1961-12-10 | — | N/A | 16323031694 | NULL | 4389 Mesa Dr | Eden Prairie | MN·· | 55324 | — | SELECT-EPO |
| PRV | PRV-26658 | 2026-09-25T09:09:23Z | Timothy | ·· | Phillips | 2005-07-25 | ·UHC-10844-40 | — | 303-861-5081 | ·timothy.phillips@gmail.com | — | — | — | N/A | null | — |
| PRV | PRV-25680 | 2026-07-11T10:45:17Z | Judith | — | Li | 04/07/76 | UHC-83073-66 | — | 270.765.9891 | N/A | ·3151 Ridge Rd | Eden Prairie | MN·· | 55355 | — | CHOICE-PLUS-PPO |
| PRV | PRV-20184 | 2026-05-12T09:10:58Z | JACQUELINE | — | LAWRENCE | 6/11/2007 | — | UNKNOWN | 5248002302 | — | 8326 Desert Sky Blvd | Eden Prairie | MN·· | UNKNOWN | — | N/A |
| PRV | PRV-20839 | 2026-03-14T17:00:58Z | Greg | — | Hudson | 20010505 | UHC-35926-32 | NULL·· | 422.389.1622 | gregory.hudson91@icloud.com | 3589 Spring Street | TUCSON | AZ | 85701-1874 | — | NAVIGATE-HMO |
| PRV | PRV-23890 | 2026-10-17T10:14:21Z | KEITH | Z | GONZALES | 1971-04-03 | UHC-47275-39 | — | 12347925896 | NULL | 3073 Sage Court | Scottsdale | AZ | 85203 | - | SELECT-EPO |
| PRV | PRV-20647 | 2026-05-14T16:29:38Z | Julie | — | Hansen·· | 1973-09-25 | UHC-11629-44 | — | 4145977826 | julie.hansen18@aol.com | 667 OAK ST | Eden Prairie | MN | 55336-1601 | — | NULL |
| PRV | PRV-24996 | 2026-10-01T04:50:37Z | DANIELLE | G·· | GARZA | Oct 19, 1996 | UHC-85381-16 | NULL | (606) 286-4936 | danielle.garza@outlook.com | 3040 Spring Street | Glendale | AZ | 85371 | NULL | — |
| PRV | PRV-27572 | 2026-01-26T15:35:56Z | KATHLEEN | — | DAY·· | 21-11-1966 | UHC-04206-33 | ···· | 4146753098 | — | 3932 MEADOW LANE | Tampa | FL | 33660 | - | null |
| PRV | PRV-22596 | 2026-09-20T18:52:56Z | AUSTIN | — | BRYANT | 1982-03-20 | UNKNOWN·· | •••-••-3251 | (527) 555-9875 | austin.bryant@outlook.com·· | 3056 Willow Court | Houston | Texas | 77008 | ·- | NULL |
| PRV | PRV-27312 | 2026-03-10T04:38:15Z | Mei | ·N | Tucker·· | 28-09-1974·· | UHC-96295-40 | NULL | 7514722370·· | mei.tucker@hotmail.com | 5805 MARKET ST | Atlanta | GA | 30300 | UNKNOWN | N/A |
| PRV | PRV-27340 | 2026-07-16T09:52:06Z | carol | C. | meyer | 1979-07-21 | UHC-67181-84 | - | 12429489581 | carol.meyer30@yahoo.com | 3897 Camelback Rd·· | Nashville | TN | 37265 | — | MEDICARE-ADV-B |
| PRV | PRV-25870 | 2026-08-28T12:36:01Z | LAUREN | — | MCCOY | 1946-01-06 | UHC-57720-33 | — | (545) 943-7491 | lauren.mccoy@aol.com | 692 Spring Street | Charlotte | NC | 28248 | — | null |
| PRV | PRV-20391 | 2026-06-06T03:19:05Z | STEVEN | Y. | LEWIS | ·11/8/1941 | UHC-52617-07 | — | 9614692590 | — | ·5518 Harbor Blvd | Fresno | CA | 93783 | N/A | UNKNOWN |
| PRV | PRV-25110 | 2026-05-19T01:56:15Z | Carolyn | F·· | Munoz | 19801027 | UHC0118077 | •••-••-9666 | (503) 276-3388 | null | 9026 Maple Ave | SAN ANTONIO | ·tx | 78219 | — | UNKNOWN·· |
| PRV | PRV-24535 | 2026-02-27T05:16:43Z | ruth | — | west·· | 01/09/76 | UHC-47531-91 | — | 7219560400 | NULL | 8654 LAKE VIEW RD | GLENDALE | AZ | 85342 | null | - |
| PRV | PRV-23645 | 2026-03-31T07:19:41Z | DAN | — | FRANKLIN | Aug 17, 1938 | UHC6671248 | UNKNOWN·· | (842) 729-1442 | daniel.franklin@yahoo.com | 4019 Mountain View Drive Apt 13 | Atlanta | GA | 30340 | - | CHOICE-PLUS-PPO |
| PRV | PRV-20104 | 2026-02-14T04:07:53Z | Mary | — | Willis | 1956-06-18 | — | — | 242-678-0770 | null | 8319 Main Street | Mesa·· | ·AZ | 85263 | — | MEDICARE-ADV-A |
| PRV | PRV-24414 | 2026-03-23T22:46:43Z | AAMNDA | — | CARTER | 2008-02-14 | UHC-73912-48 | NULL | null | null | 4036 Valley View Dr | Chandler | AZ | 85274 | UNKNOWN | UNKNOWN |
| PRV | PRV-24470 | 2026-05-22T19:55:29Z | JOSHUA | — | GORDON | ·1958-12-25 | — | NULL | (484) 911-6152 | null | 4104 Union St·· | Jacksonville | FL | 32286·· | ···· | MEDICARE-ADV-A |
| PRV | PRV-28373 | 2026-02-20T07:50:01Z | Alice | W | Montgomery | 1987-10-21 | NULL | NULL | 768.607.9473·· | N/A | 4933 Spring Street | COLUMBUS | OH | 43204 | null | — |
| PRV | PRV-26417 | 2026-06-18T10:19:55Z | henry | — | allen | 1971-80-01 | UHC7666303 | UNKNOWN | (858) 776-8212 | henry.allen@gmail.com | 8503 Pine Drive | Columbus | OH | 43254 | null | — |
| PRV | PRV-27102 | 2026-02-20T17:48:24Z | Austin | — | ·White | 23-06-1964 | UHC8001618 | NULL | (632) 857-2529 | — | 2976 Market St | Minneapolis | MN | 55456 | — | - |
| PRV | PRV-27109 | 2026-08-24T07:46:14Z | Hudson, Donald | ···· | — | 1976-01-19 | UHC-43303-53 | N/A | +1 701 747 4994 | — | 6764 Baseline Rd | Charlotte·· | NC | 28284-0052 | N/A | NAVIGATE-HMO |
| PRV | PRV-28259 | 2026-10-06T06:50:52Z | BRANDON | — | COOLLINS | ·Jul 8, 1981 | UHC-98443-74 | — | (330) 520-9122 | — | 1704 Desert Sky Boulevard·· | TAMPA | FL | ·33665 | — | - |
| PRV | PRV-23403 | 2026-10-16T05:03:40Z | Castro, Mary | L. | — | 1960-07-19 | UHC4156660 | •••-••-5511 | ·N/A | mary.castro80@icloud.com | 7608 OCEAN AVE | Seattle | WA | 98125 | - | N/A |
| PRV | PRV-25941 | 2026-01-08T22:52:50Z | Gabriel | — | ·Thompson | 1962-10-09·· | UHC-12785-40 | •••-••-2596 | (247) 870-6650 | NULL | 6602 Valley View Drive | San Antonio | TX | 78273-2174 | — | — |
| PRV | PRV-20519 | 2026-04-22T01:59:22Z | JUDITH | — | SANTIAGO | 03/24/1952 | UHC-25546-73 | •••-••-8492 | (386) 689-5554 | — | ·2694 Market St | Denver | CO | 80216 | — | null |
| PRV | PRV-22663 | 2026-03-06T21:08:38Z | Schmidt, Donna | — | — | 02/23/1983 | UHC-88832-04 | •••-••-5906 | - | ·donna.schmidt56@aol.com | 6092 Meadow Lane | San Antonio | TX | 78250 | — | — |
| PRV | PRV-26141 | 2026-06-29T15:39:30Z | Elijah | — | Gutierrez | 1966-05-09 | UNKNOWN | - | — | — | 8582 WASHINGTON STREET | San Antonio | TX | NULL | — | MEDICARE-ADV-B·· |
| PRV | PRV-27003 | 2026-02-05T06:09:07Z | ·Amy | — | Warren | 08-12-1940 | - | NULL | 7503852602 | amy.warren@aol.com·· | 8408 Palm Dr #631 | Columbus | OH | — | — | ·UNKNOWN |
| PRV | PRV-26096 | 2026-02-13T17:21:11Z | carl | — | ·rivera | 1980-12-03 | UHC-16910-17 | -·· | 3902427961 | N/A | 5451 Grand Avenue Apt 3 | EDEN PRAIRIE | MN | N/A | ·N/A | — |
| PRV | PRV-23846 | 2026-09-17T07:22:34Z | KARN | — | MORRISON | Jun 28, 2000 | UNKNOWN | NULL | 476-411-6775 | N/A | 5196 CEDAR LANE | Miami | FL | - | N/A | — |
| PRV | PRV-25426 | 2026-02-21T16:24:06Z | peter·· | — | west | 08/09/1938 | — | •••-••-3037 | 6856053731 | peter.west65@outlook.com | 6880 Valley View Drive | ·FRESNO | CA | 93777 | — | 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:38.471Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty