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-24028 | 2026-02-09T02:50:26Z | wayne | ···· | ryan | 1988-04-16 | — | •••-••-1114 | 620-419-5305 | wayne.ryan33@outlook.com | NULL | NULL | NULL | UNKNOWN | null | NAVIGATE-HMO |
| PRV | PRV-29045 | 2026-07-12T12:59:19Z | Charlotte | — | Chapman | 11/17/79 | NULL | - | (407) 599-1025 | — | 3896 CHURCH STREET | Miami | FL | 33103 | null | NULL |
| PRV | PRV-26702 | 2026-09-15T17:58:36Z | Eric | G. | Perkins | 21-11-1999 | — | null | 5103145653 | — | 7227 SUNSET BOULEVARD | Tampa | FL | 33639 | — | — |
| PRV | PRV-22961 | 2026-08-28T09:40:10Z | GARY·· | — | WEST | 16-04-1940 | NULL | null | +1 603 203 7228 | UNKNOWN | 5456 Cedar Ln | Eden Prairie | MN | 55398·· | ·- | - |
| PRV | PRV-27048 | 2026-06-11T15:57:30Z | JULIE | ·· | CUNNINGHAM | 1995-02-07 | UHC-66087-50 | — | 7614043718 | — | - | N/A | - | - | NULL | UNKNOWN |
| PRV | PRV-25181 | 2026-08-04T21:15:49Z | Alice | — | Barnes | 10/16/1990 | UHC-85052-77 | — | — | ALICE.BARNES82@PROTON.ME | 3043 Lincoln Way #998 | SAN ANTONIO | tx | 78288 | N/A | UNKNOWN |
| PRV | PRV-20241 | 2026-10-09T13:41:38Z | alexander | — | murphy | 1960-08-22 | UNKNOWN | •••-••-4827 | (958) 683-1073 | alexander.murphy@aol.com | 2012 PALM DR | Eden Prairie | MN | 55302 | N/A | — |
| PRV | PRV-27987 | 2026-07-17T15:25:28Z | Wilson, Sandra | L | — | 12/11/1938 | null | — | (399) 803-6007 | NULL | 3901 Forest Ave | Dallas | TX | 75245 | NULL | SELECT-EPO |
| PRV | PRV-28324 | 2026-04-19T04:35:53Z | Scott | ·· | Kelley | 1995-07-25 | UHC-50527-90 | — | 17095904912 | — | 9189 Canyon Road | Seattle | WA | 98100 | N/A | — |
| PRV | PRV-27848 | 2026-03-13T20:22:47Z | Tony | — | Hunt | 02-05-1939 | UHC-11062-05 | — | (913) 448-5813 | anthony.hunt@gmail.com | 7124 MOUNTAIN VIEW DRIVE | Fresno | California | 93795 | UNKNOWN | NAVIGATE-HMO |
| PRV | PRV-25274 | 2026-07-04T18:50:13Z | Amy | N | Larson | 6/2/2005 | UHC-16715-78 | — | 934-605-8373 | — | 1811 CANYON ROAD | Scottsdale | AZ·· | 85207 | N/A | — |
| PRV | PRV-24697 | 2026-03-17T23:14:56Z | Judy | ·· | ·Cox | 1985-03-11 | UHC-31243-27 | — | +1 701 458 0447 | — | 1767 MEADOW LN | SACRAMENTO | CA | 95871 | ·UNKNOWN | N/A |
| PRV | PRV-21316 | 2026-03-03T00:57:16Z | Ambeer | W. | Mejia | 02/17/1953 | UHC-13136-66 | ·UNKNOWN | 4953626145 | null | 5149 Mesa Dr | Gilbert | AZ | 85265 | — | - |
| PRV | PRV-28352 | 2026-09-29T00:58:17Z | Kennedy, Alexander | — | — | 1962-10-17 | UHC4615015 | — | 281-866-8900 | ALEXANDER.KENNEDY@GMAIL.COM | 5630 Forest Ave | Miami | FL | - | N/A | — |
| PRV | PRV-28876 | 2026-02-11T23:36:33Z | Beverly | — | Smith | 19690316 | — | •••-••-6504 | 981-834-7806 | — | 5753 APACHE BLVD | Dallas | TX | 75248 | — | - |
| PRV | PRV-25436 | 2026-01-29T15:11:11Z | Sara | — | OBrien | ·2005-07-18 | UHC-73544-87 | — | 599-906-6106 | null | 8510 Sage Court | Orlando | FL | — | NULL | null |
| PRV | PRV-29037 | 2026-01-19T10:38:57Z | Diana | — | Cruz | 1984-05-15 | — | N/A | (987) 794-9457 | - | null | null | — | N/A | — | UNKNOWN |
| PRV | PRV-26396 | 2026-09-05T22:52:03Z | EMMA | L | VEA | Aug 26, 1940 | UHC6127863 | UNKNOWN | 494-411-8245 | — | - | NULL | UNKNOWN | NULL | UNKNOWN | - |
| PRV | PRV-25284 | 2026-05-01T15:20:55Z | Jack·· | ·· | Carlson | 10/14/85 | UNKNOWN | null | null | NULL | 4608 Main St | Nashville | ·Tennessee | 37208 | null | NULL |
| PRV | PRV-27267 | 2026-03-01T19:46:57Z | Frances | D | Jackson | Feb 19, 1961 | null·· | — | 12867510402 | null | 809 Apache Blvd | Minneapolis | mn | 55415 | — | CHOICE-PLUS-PPO |
| PRV | PRV-27792 | 2026-03-13T11:26:37Z | Joan | ···· | Morales | 1945-05-09 | — | NULL | 3524229122 | ···· | 2787 Union St | Jacksonville | FL | 32218 | ·UNKNOWN | — |
| PRV | PRV-26565 | 2026-10-18T11:20:10Z | Richard | — | Morales | 2008-06-20 | ·NULL | - | 9209453·· | richard.morales87@icloud.com | 3133 Indian School Rd | GILBERT | AZ | 85267 | ···· | null |
| PRV | PRV-28965 | 2026-10-02T09:06:53Z | Diane·· | R | Schultz | 19480824 | UHC-38918-12 | — | 4099193242 | DIANE.SCHULTZ@GMAIL.COM | 7348 Bayshore Drive | Columbus | OH | 43211 | null | OPTIONS-PPO |
| PRV | PRV-28990 | 2026-06-09T16:43:30Z | Bradley | — | Matthews | 07/15/1992 | UHC-27612-44 | — | - | — | 6175 HIGHLAND AVENUE | San Antonio | TX | 78274 | null | ·NAVIGATE-HMO |
| PRV | PRV-21852 | 2026-01-07T02:00:09Z | JOE | F | BISHOP | 09/16/06 | UHC3123905 | •••-••-2502 | 12115342399 | -·· | 4760 CANYON RD | Phoenix | Arizona | 85094 | UNKNOWN | — |
| PRV | PRV-22095 | 2026-01-31T22:29:34Z | VALENTINA | — | WHEELER | 1944-03-26 | UHC-63084-83 | — | +1 432 796 4908 | valentina.wheeler38@gmail.com | 7039 BROADWAY | Atlanta | GA | 30329 | NULL·· | SELECT-EPO |
| PRV | PRV-24156 | 2026-03-28T07:49:39Z | Charlotte | — | Washington | 08/24/05 | UHC-01290-54 | ·· | 9836933003 | — | 1416 WASHINGTON STREET Apt 15·· | Denver | Colorado | 80211 | — | — |
| PRV | PRV-27139 | 2026-09-22T17:58:33Z | SUSAN | ···· | VAZQUEZ | ·2007-09-06 | NULL | UNKNOWN | 3206987761 | NULL | 7588 Apache Blvd | Eden Prairie | MN | 55378 | ·· | — |
| PRV | PRV-24548 | 2026-09-09T08:13:34Z | CAROLYN | — | JORDAN | 1952-10-12 | N/A | •••-••-0666 | 9293703365 | carolyn.jordan@icloud.com | 3878 MARKET STREET | CHARLOTTE | NC | 28245 | NULL | NULL |
| PRV | PRV-21556 | 2026-02-28T23:00:59Z | christopehr | — | wallace | ·2000-08-07 | null·· | — | ·529-751-7988 | christopher.wallace@outlook.com | 2898 Indian School Rd·· | SAN DIEGO | CA | 92101 | — | - |
| PRV | PRV-24616 | 2026-09-13T01:50:16Z | Larry | — | Mejia | 1944-06-07 | N/A | UNKNOWN | 8282764875 | N/A | ·3854 DESERT SKY BOULEVARD Apt 20 | JACKSONVILLE | FL | 32222·· | UNKNOWN | — |
| PRV | PRV-23574 | 2026-02-15T00:58:55Z | Sims | — | Heather | 1986-06-13 | UHC-21954-04 | null | (762) 844-3339 | — | 8996 Church St | Tampa | FL | 33665 | — | SELECT-EPO |
| PRV | PRV-25982 | 2026-02-10T11:58:58Z | Arthur | I. | Espinoza | 19911023 | UNKNOWN | null | (515) 472-7968·· | arthur.espinoza@proton.me | 2783 Market St #919 | Gilbert | AZ | 85284 | N/A | — |
| PRV | PRV-22773 | 2026-04-12T14:10:40Z | NATHAN | — | CUNNINGHAM | 1938-05-08 | UHC-14810-76 | NULL | NULL·· | nathan.cunningham@icloud.com | 8203 Lake View Rd | Atlanta | Georgia | 30399 | - | UNKNOWN |
| PRV | PRV-27979 | 2026-04-16T13:07:07Z | ELIZABETH·· | Z | ·STEPHENS | 1940-06-08 | - | null | 846-720-6570 | UNKNOWN·· | 9528 Meadow Lane | Austin | Texas | — | N/A | — |
| PRV | PRV-23268 | 2026-10-14T04:11:17Z | Hoffman, Lucia | — | — | 06/26/71 | UHC2403758·· | ·null | 816-317-1375 | null | 2795 SAGE CT #798 | ·Los Angeles | CA | 90011 | NULL | — |
| PRV | PRV-24803 | 2026-02-05T04:21:36Z | Jose | L | ·Morrison | 1953-08-27 | UHC-06840-28 | •••-••-0218 | 707.713.2703 | jose.morrison56@yahoo.com | - | NULL | — | N/A | UNKNOWN | UNKNOWN |
| PRV | PRV-22589 | 2026-10-12T12:36:33Z | brenda | — | alvarado | 06/28/80 | UHC-41851-99 | •••-••-5433 | — | ·· | 6602 OAK STREET | JACKSONVILLE | Florida | 32243 | — | — |
| PRV | PRV-24173 | 2026-04-02T12:01:36Z | AHMED | — | JACKSON | 19800721 | — | ·N/A | (916) 579-8865 | null | 6354 Lincoln Way | Eden Prairie | MN | 55395 | UNKNOWN | UNKNOWN |
| PRV | PRV-28772 | 2026-06-09T02:22:43Z | abigail | — | maldonado | 08/23/08 | NULL | N/A | 6616983529 | - | 1734 HILLCREST ROAD | Tampa | FL | 33650 | null | N/A |
| PRV | PRV-25445 | 2026-01-12T15:21:11Z | Janice | — | Weaver | Oct 17, 1973 | UNKNOWN | - | 613-803-0040 | janice.weaver61@outlook.com | 1279 Oak Street | Denver | CO | 80225-7516 | — | — |
| PRV | PRV-26657 | 2026-04-02T21:29:44Z | Theresa | — | Hicks | 1969-02-09 | UHC-01574-14 | •••-••-6652 | NULL | ···· | 1799 Highland Ave | Jacksonville | FL | — | — | — |
| PRV | PRV-21581 | 2026-05-05T17:28:54Z | DIANE | — | SANTIAGO | 1982-08-20 | N/A | N/A | (612) 483-5022 | diane.santiago91@outlook.com | 7407 Valley View Drive | Denver | CO | 80230 | — | null |
| PRV | PRV-24362 | 2026-07-31T17:51:12Z | Dorothy | — | Hudson | Nov 8, 1988·· | null | •••-••-2244 | 823-512-5322 | N/A | 3077 Meadow Ln | Minneapolis | ·Minnesota | 55437 | UNKNOWN | — |
| PRV | PRV-27507 | 2026-04-15T18:56:02Z | Nancy | — | Gibson | Jun 23, 1977 | UHC-33101-19·· | N/A | 5344699459 | nancy.gibson12@hotmail.com | 8766 INDIAN SCHOOL ROAD | Las Vegas | NV | 89149 | — | - |
| PRV | PRV-25400 | 2026-02-04T16:17:50Z | JEAN·· | K | SINGH | 1951-03-25 | UHC-61363-09 | — | 4426005971 | NULL | 6624 Hillcrest Rd #875·· | PHOENIX | AZ | 85054 | ·· | - |
| PRV | PRV-23325 | 2026-06-10T20:24:54Z | JOSEPH | P. | WALSH | 1946-09-24 | UHC-88359-68 | •••-••-8169 | 356.500.0394 | — | ·6650 Indian School Road | San Diego | CA | 92172 | null | — |
| PRV | PRV-29198 | 2026-10-08T23:23:49Z | Perkins, Anthony | — | — | 1988-06-09 | N/A | •••-••-8840 | — | UNKNOWN | 5905 ELM STREET | LAS VEGAS | NV | 89113 | null | MEDICARE-ADV-A |
| PRV | PRV-23682 | 2026-07-22T11:33:36Z | Timothy | — | Castro | 1964-07-24 | UHC-74969-23 | — | 891-410-7340 | - | 4333 Palm Dr | FRESNO | CA | 93746 | — | N/A |
| PRV | PRV-28535 | 2026-08-19T08:41:49Z | Jocye | — | Baker | 0328-14-96·· | null | N/A | 603-711-1101 | joyce.baker@aol.com | ·· | NULL | null | 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:42:56.166Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty