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-23185 | 2026-04-06T02:10:50Z | Pameela | — | Simpson | 05/06/41 | null | UNKNOWN | 695-221-4174 | null | 3913 Baseline Rd | Scottsdale | AZ | - | — | NULL |
| PRV | PRV-28612 | 2026-06-25T05:21:55Z | Cheryl | — | Sanchez | ·20041026 | UHC-38922-46 | •••-••-0909 | 13358407861 | N/A | 8988 Ocean Ave | SAN ANTONIO | TX·· | N/A | N/A·· | — |
| PRV | PRV-22540 | 2026-07-13T14:35:49Z | SUSAN | — | MURPHY | 1996-06-03 | UHC-71234-34 | •••-••-3532 | (757) 667-4321·· | ·· | 1234 Broadway | TEMPE | AZ | 85231 | — | null |
| PRV | PRV-27156 | 2026-02-12T10:35:39Z | Jacob | — | Jackson | 1949-03-05 | NULL | •••-••-8161 | ·13796739736 | jacob.jackson@aol.com | ·1810 PALM DR | Charlotte | NC | 28221 | null | NAVIGATE-HMO |
| PRV | PRV-21097 | 2026-06-13T13:28:53Z | Albert | — | Marshall | 1938-08-12 | — | — | 6812672132 | — | 1431 Ocean Avenue | San Diego | California | N/A | — | UNKNOWN |
| PRV | PRV-22598 | 2026-09-13T06:35:09Z | WILLIE | — | ·RIVERA | 07/07/60 | — | null | - | willie.rivera52@icloud.com | — | N/A | NULL | - | UNKNOWN | ·NULL |
| PRV | PRV-28786 | 2026-02-08T09:11:52Z | MATEO | Y | GARDNER | 11/03/91 | UHC-88333-70 | UNKNOWN | 228-371-6017 | mateo.gardner@proton.me | 2185 Market St | MINNEAPOLIS | MN | 55468·· | null | MEDICARE-ADV-B |
| PRV | PRV-23641 | 2026-08-18T21:35:37Z | Jerry | — | Burke | 18-08-1976 | UHC-38441-26 | UNKNOWN | (671) 605-9679 | N/A | 8032 Valley View Drive | Nashville | TN | 37248 | - | — |
| PRV | PRV-24936 | 2026-02-21T20:03:45Z | MADISON | W | LEE | 0301-89-72 | null | null·· | (875) 551-5132 | — | 7266 Sage Ct | Houston | TX | 77098 | NULL | — |
| PRV | PRV-25435 | 2026-06-09T17:02:49Z | Janat | — | Morrison | 19931128 | null | null | 284-824-7814 | UNKNOWN | 9399 CEDAR LN | San Antonio | TX | 78206 | - | - |
| PRV | PRV-20975 | 2026-07-03T20:13:55Z | Carlos | — | Hanson | Sep 3, 1971 | — | •••-••-5447 | 4344881217 | null | - | - | — | NULL·· | — | N/A |
| PRV | PRV-29278 | 2026-05-10T10:14:40Z | Henry | — | Rojas | ·1974-05-02 | - | •••-••-1350 | 3472937102 | henry.rojas47@outlook.com | 7604 Hillcrest Rd | TEMPE | AZ | 85216 | N/A | UNKNOWN |
| PRV | PRV-20510 | 2026-07-06T17:37:47Z | FRANK·· | — | LI | 1974-10-04·· | null | ·N/A | 3346189898 | N/A | — | — | NULL | UNKNOWN | null | N/A |
| PRV | PRV-25816 | 2026-04-01T05:57:29Z | justin | — | butler·· | 11/08/1953 | UHC-04020-20 | •••-••-0040 | 6109317064 | UNKNOWN | 2044 Mountain View Drive | Austin | TX | 78706 | — | UNKNOWN |
| PRV | PRV-21909 | 2026-08-27T04:33:38Z | LUIS·· | — | REED·· | 24-04-1944 | UHC-97310-50 | UNKNOWN | 2423077489 | null | 3980 Meadow Lane | Orlando | Florida | 32821 | - | UNKNOWN |
| PRV | PRV-27255 | 2026-06-11T09:51:17Z | Sandra | ·· | OBrien | 1975-11-28 | null | — | 4458089307 | ·- | 6992 Jefferson Avenue | Fresno | California | 93777 | - | NULL |
| PRV | PRV-26226 | 2026-03-20T07:34:20Z | CAROLYN | X | DAY | 3/6/1973 | UHC-57139-59 | N/A | 3562322 | null | 3750 RIVER ROAD Apt 20 | Seattle | WA | 98170-3245 | null | UNKNOWN |
| PRV | PRV-22639 | 2026-09-14T16:40:32Z | MEI | X | KING | 1984-03-02 | - | — | 975-231-7921 | mei.king@gmail.com | 6745 Union St | Eden Prairie | MN | 55358 | — | CHOICE-PLUS-PPO |
| PRV | PRV-26280 | 2026-10-03T02:24:32Z | Maria | — | Fissher | 1979-01-17 | uhc-18891-77 | - | 7403681565 | null | 5536 WASHINGTON ST | Charlotte | NC | 28228 | null | MEDICARE-ADV-B |
| PRV | PRV-23087 | 2026-01-27T16:35:47Z | Emily | — | Anderson | 1953-02-16 | UHC-77460-19 | — | 15059545342 | — | — | UNKNOWN | - | — | NULL | ·· |
| PRV | PRV-26489 | 2026-05-15T15:13:41Z | NOAH | — | WRIGHT | 06/04/1960 | ·UHC-86044-28 | — | 783-484-0937 | NULL | 7972 Hillcrest Road | Scottsdale | AZ | 85253 | NULL | SELECT-EPO |
| PRV | PRV-28831 | 2026-08-11T12:15:28Z | zachary | U. | ·blacck | 2008-07-06 | UHC-26635-36 | •••-••-4584 | 775.549.5429 | NULL | 7325 Oak St | ORLANDO | FL | 32820-8524 | — | OPTIONS-PPO |
| PRV | PRV-20739 | 2026-03-28T06:55:39Z | ELIZABETH | ·· | GARDNER | 12-04-1981 | null | NULL | 468-928-4206 | null | 7874 UNION ST | Orlando | FL | 32863 | null | UNKNOWN |
| PRV | PRV-23241 | 2026-09-16T00:03:00Z | ·Gabriel | — | Castillo | 1990-10-01 | NULL | UNKNOWN | (396) 884-1043 | gabriel.castillo@proton.me | 1163 Church Street | Plano·· | TX | 75066 | — | — |
| PRV | PRV-29169 | 2026-01-27T11:38:20Z | Elizabeht | — | Matthews | 08/26/1994 | UHC-83163-59 | ·- | (625) 759-9798 | NULL | 8220 BAYSHORE DRIVE | Orlando | FL | 32855 | — | null |
| PRV | PRV-26238 | 2026-02-22T00:02:37Z | Jean | — | Rodriguez | 2002-01-01 | NULL | — | 6172578463 | - | 4404 Valley View Drive | Atlanta | GA | 30335 | NULL | — |
| PRV | PRV-24196 | 2026-10-10T11:52:03Z | Jess | — | Simpson | 1942-12-23 | UHC-26563-44 | null | (362) 891-2877 | N/A | 6565 JEFFERSON AVENUE | SEATTLE | WA | — | — | — |
| PRV | PRV-29192 | 2026-08-30T02:29:51Z | ·Wayne | — | Lopez | 12/26/01 | - | •••-••-2582 | 6396090321 | wayne.lopez@aol.com | 8070 HIGHLAND AVENUE | Dallas | TX | 75296-0410 | UNKNOWN | NAVIGATE-HMO |
| PRV | PRV-21190 | 2026-05-17T04:40:07Z | Little, Marcus | T. | — | 2001-03-28 | N/A | - | 872-584-1589 | ·N/A | 9687 RIDGE RD | GILBERT | AZ | 85266 | — | MEDICARE-ADV-A |
| PRV | PRV-25296 | 2026-05-13T16:28:35Z | Roger | — | Moreno | 2005-01-25 | — | ···· | — | N/A | — | - | — | -·· | N/A | - |
| PRV | PRV-20231 | 2026-04-12T11:05:04Z | JOOSHUA | — | VASQUEZ | 1940-01-03 | NULL | — | (827) 637-2355 | JOSHUA.VASQUEZ@GMAIL.COM | 8275 Washington St | Austin | TX | 78773 | — | null |
| PRV | PRV-20093 | 2026-07-29T19:58:23Z | Jessica | — | Meyer | 20091121 | UHC-28846-42 | null | 774-636-9717 | — | 1685 INDIAN SCHOOL ROAD #692 | Eden Prairie | mn | 55342 | — | OPTIONS-PPO |
| PRV | PRV-23193 | 2026-05-07T09:53:01Z | Helen | — | McCoy | 04/17/2004·· | UNKNOWN | •••-••-6349 | (413) 381-9639 | NULL | 1922 Central Ave | Phoenix | AZ | ·85092 | NULL | UNKNOWN |
| PRV | PRV-20724 | 2026-08-16T02:04:17Z | Charlotte | — | Clark | 7/20/1939 | null | — | 5662282063 | null | 7782 River Rd | Minneapolis | MN | 55447 | null | MEDICARE-ADV-A |
| PRV | PRV-26292 | 2026-02-16T11:22:41Z | Joyce | — | Moreno | Jul 28, 1943 | - | — | UNKNOWN | JOYCE.MORENO28@GMAIL.COM | 2582 Hillcrest Road | Seattle | WA | 98152 | UNKNOWN | — |
| PRV | PRV-28460 | 2026-05-21T22:05:25Z | Ann | — | Santiago | 1990-01-07·· | UHC7201889 | NULL | (431) 341-4103 | ANN.SANTIAGO@GMAIL.COM·· | 4669 Main St | Glendale | AZ | 85338-3649 | — | N/A |
| PRV | PRV-26948 | 2026-10-18T11:25:20Z | Lene, Ashely | D | — | 1993-09-20 | NULL | ·- | +1 365 609 9814 | — | 4467 INDIAN SCHOOL RD | LAS VEGAS | NV | 89116 | — | - |
| PRV | PRV-23769 | 2026-05-27T08:58:30Z | DORIS | — | EVANS | 12/19/1939 | — | - | (357) 922-4649 | DORIS.EVANS@GMAIL.COM | 7062 Apache Blvd | Fresno | CA | 93772 | UNKNOWN | — |
| PRV | PRV-20586 | 2026-08-15T16:14:03Z | STEPHEN | — | GARZA | 1947-12-11 | — | — | 19046536487·· | — | 9896 RIDGE ROAD | Orlando | FL | ·32863 | - | options-ppo |
| PRV | PRV-27145 | 2026-01-19T00:49:46Z | Richard | — | Murphy | Feb 22, 1992 | UHC-66444-91 | — | 6824514806 | NULL | — | NULL | — | — | null | N/A |
| PRV | PRV-29004 | 2026-04-14T14:00:02Z | Jason | — | Powell | 1940-03-25 | — | •••-••-2199 | (421) 307-1637 | JASON.POWELL@GMAIL.COM | 9000 SPRING STREET | Phoenix | AZ | 85047 | null | NULL |
| PRV | PRV-26031 | 2026-04-20T23:33:58Z | Green, Samuel | — | — | 09/27/2005·· | - | NULL | (631) 452-8134 | samuel.green@hotmail.com | 44 Sage Ct | SAN DIEGO | CA | 92153 | — | OPTIONS-PPO |
| PRV | PRV-28962 | 2026-01-14T16:06:01Z | Donna·· | — | Salazar | 1978-06-02 | — | NULL | 16144530709 | donna.salazar@icloud.com | 212 Forest Ave | Orlando | FL | 32817 | null | null |
| PRV | PRV-26849 | 2026-05-03T10:42:11Z | Sara | — | Wallace | 10/27/1970 | UHC-48359-67 | null | 665.967.1601 | — | 298 Ridge Road | Minneapolis | MN | 55471 | — | NULL |
| PRV | PRV-27371 | 2026-05-13T03:31:06Z | Ashley | J. | Oliver | 4/6/1973 | UHC-27439-19 | null | 5064834373 | UNKNOWN | — | UNKNOWN | N/A | — | null | — |
| PRV | PRV-26473 | 2026-07-11T19:13:00Z | Noah | ···· | Clark | 1959-02-15 | UHC7933067 | •••-••-8058 | 9502449281 | ·NOAH.CLARK@PROTON.ME | 1599 Central Ave | LAS VEGAS | Nevada | 89117-1980 | UNKNOWN | N/A·· |
| PRV | PRV-22088 | 2026-08-14T05:56:07Z | EMMA | — | TUCKER | 1955-10-18 | UHC6704513 | — | 6116766 | emma.tucker@icloud.com | 4116 Market Street | MESA | AZ | 85245 | — | UNKNOWN |
| PRV | PRV-24645 | 2026-09-18T10:56:37Z | ·ELIJAH | — | GORDON | 11/12/1978 | — | — | 856.930.1356 | — | 2459 Bayshore Drive | ·ATLANTA | GA | 30359 | - | core-hmo |
| PRV | PRV-26941 | 2026-04-15T04:57:14Z | DOUGAS | — | DANIELS | 1957-01-06 | UHC4368230 | null | 3985199 | - | 3223 Washington St | Denver | Colorado | 80215 | — | — |
| PRV | PRV-23245 | 2026-02-24T16:56:22Z | ·Morales, Tyler | M. | — | 7/2/1959 | NULL | N/A | 7264591183 | NULL | ·3280 RIDGE ROAD | Mesa·· | AZ | 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:56.291Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty