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-21651 | 2026-08-02T12:46:19Z | AMANDA | — | WRIGHT | 1972-08-09 | ···· | — | (405) 644-9641 | null | 1297 Willow Court | CHARLOTTE | NC | 28241 | null | — |
| PRV | PRV-27007 | 2026-05-05T04:03:16Z | Christopher | — | Reynolds | 02/17/1962 | UHC-61478-29 | N/A | ·610.583.2971 | — | 1652 Maple Ave | Orlando | FL | 32861 | ·- | - |
| PRV | PRV-22536 | 2026-10-05T07:06:15Z | vincent·· | ···· | pena | 1945-02-06 | — | — | +1 368 343 0541 | NULL | ·3385 Hillcrest Rd | Minneapolis | MN | 55480 | — | — |
| PRV | PRV-26812 | 2026-05-16T08:48:02Z | Diego | — | Ferguson | 1984-06-08 | UHC-07762-22 | — | (970) 685-9537 | DIEGO.FERGUSON81@YAHOO.COM·· | 1523 Union Street | SAN ANTONIO | TX | 78229 | UNKNOWN | null |
| PRV | PRV-27729 | 2026-01-14T02:30:08Z | Lauren | — | Nunz·· | Oct 25, 1981 | — | ·NULL | 7892727876 | LAUREN.NUNEZ@YAHOO.COM | 4391 OAK STREET | Nashville | Tennessee | 37213 | — | — |
| PRV | PRV-28527 | 2026-06-06T06:21:49Z | Frances | — | Wood | ·1962-08-02 | UHC-40418-04 | UNKNOWN | +1 417 391 9073 | — | 7219 Cedar Lane | AUSTIN | TX | 78721 | UNKNOWN | NULL |
| PRV | PRV-24817 | 2026-04-19T20:44:48Z | AMANDA | — | WASHINGTON | 2000-07-01 | UHC-98242-34 | — | 7737883172 | N/A | 2909 Spring Street | Charlotte | NC | UNKNOWN | — | N/A |
| PRV | PRV-27674 | 2026-02-22T01:47:43Z | Sarah | — | Li | Mar 24, 1946 | null | •••-••-7395 | 7365121624 | NULL | 4849 Mesa Drive | Chandler | az | 85232·· | N/A | — |
| PRV | PRV-21602 | 2026-08-10T19:07:22Z | Wayne | — | Gutierrez | 11/13/1982 | UHC-35850-27 | •••-••-7927 | (428) 713-1616·· | wayne.gutierrez@yahoo.com | 7979 PARK PLACE | Miami | fl | 33196 | — | null |
| PRV | PRV-25503 | 2026-08-20T20:56:00Z | Simpson, Roy | Q | — | 1956-07-16 | UHC-12089-16 | N/A | (967) 775-5119 | — | 9767 HARBOR BLVD·· | Gilbert | Arizona | UNKNOWN | — | — |
| PRV | PRV-22156 | 2026-08-29T11:26:18Z | Diaz, Billy | X | — | 1969-05-21 | — | null | 716-213-9220 | - | 9501 Meadow Ln | San Antonio | TX | 78201·· | - | N/A |
| PRV | PRV-28565 | 2026-07-21T04:15:37Z | Ken | H. | Hunter | 05-12-1940 | — | UNKNOWN | 281-883-1642 | kenneth.hunter@outlook.com | 5984 Lake View Road | Atlanta | GA | 30334 | NULL | NULL |
| PRV | PRV-28656 | 2026-07-15T05:20:50Z | bruce | — | black | 1996-05-13 | NULL | NULL | +1 508 503 0697 | ·UNKNOWN | 1170 Cedar Ln | Seattle·· | WA | 98165 | — | — |
| PRV | PRV-23348 | 2026-09-27T11:21:12Z | Ortiz, Valentina | — | ·· | 1958-09-28 | UHC-23200-97 | •••-••-3866 | — | — | 2148 Willow Ct | Columbus | oh | N/A | NULL | OPTIONS-PPO |
| PRV | PRV-24067 | 2026-02-23T10:03:07Z | Nancy | D | Walsh | 1946-02-24 | uhc-03744-02 | •••-••-4199 | 975-522-0095 | — | 5331 Lake View Rd | MINNEAPOLIS | ·MN | 55449 | — | UNKNOWN |
| PRV | PRV-23876 | 2026-01-03T00:25:46Z | FRANCES | B. | CARPENTER | 1989-07-13 | — | •••-••-0870 | +1 278 937 0578 | null | 1399 Mountain View Dr | Plano | TX | ·75046 | NULL | OPTIONS-PPO |
| PRV | PRV-25069 | 2026-05-04T18:11:19Z | Mei | — | Wilson | 03/11/78 | UHC-28950-12 | null | — | — | 3147 Lincoln Way | Charlotte | NC | N/A·· | ·null | — |
| PRV | PRV-29364 | 2026-03-23T07:30:11Z | ·bobby | — | ortiz | 1946-10-03 | UHC-60754-75 | NULL | - | bobby.ortiz40@hotmail.com | 4494 Indian School Rd | Miami | FL | 33150 | UNKNOWN | - |
| PRV | PRV-20297 | 2026-08-05T08:01:11Z | John | Z | Taylor | Aug 28, 1971 | UHC-19378-10 | •••-••-6348 | +1 467 385 7651 | NULL | 8613 Washington Street | ATLANTA | GA | 30374 | ·· | - |
| PRV | PRV-21294 | 2026-02-01T06:52:50Z | Harvey, Alexis | — | — | 2/11/1991 | UHC-56292-04 | N/A | — | — | 6202 BAYSHORE DRIVE | Nashville | TN | 37211 | — | null |
| PRV | PRV-27165 | 2026-08-24T20:14:35Z | DIANE | — | DOMINGUEZ·· | 06-08-1946 | - | — | 978.985.8984 | diane.dominguez57@hotmail.com | 9605 Union Street | SACRAMENTO | California | 95862 | — | null |
| PRV | PRV-24251 | 2026-07-30T10:00:35Z | KELLY | — | PATTESON | 12/03/48 | UHC-93961-32 | N/A | 605-379-8623 | — | ·124 Grand Ave | Gilbert | AZ | 85259 | — | — |
| PRV | PRV-22153 | 2026-05-12T19:22:05Z | ·Thomas | V | Fields | 1966-08-23 | null | — | (576) 538-0438 | — | null | ···· | — | — | — | — |
| PRV | PRV-25491 | 2026-05-02T11:32:23Z | Megan | ···· | Washington | 1972-11-17 | UHC-86025-95 | — | 3808779671 | — | 2946 Maple Avenue Apt 23 | Nashville | TN | ·37276 | - | — |
| PRV | PRV-22820 | 2026-02-21T18:52:39Z | Jonathan | M. | Patel | Dec 21, 1961 | null | UNKNOWN | 2478348380 | — | 4336 Desert Sky Boulevard Apt 33 | Glendale | Arizona | 85381 | null | ·- |
| PRV | PRV-21059 | 2026-01-15T16:29:18Z | Amber | G | Nichols | 1993-03-03 | UHC-10935-86 | null | (462) 509-3460 | - | 1003 Sage Court | Scottsdale | AZ | — | — | - |
| PRV | PRV-25845 | 2026-05-18T19:56:49Z | Richard·· | E | Lwason | May 25, 1976 | UHC-60156-03 | — | (375) 443-5819 | — | ·9040 Ridge Road | Las Vegas | NV | - | NULL | — |
| PRV | PRV-23580 | 2026-05-26T01:23:48Z | SHARON | — | ·THOMAS | 09/22/1942 | ·UHC-96128-13 | •••-••-2534 | 6802037 | UNKNOWN | 3073 Lincoln Way | San Antonio | ·TX | 78243-9718 | NULL | null |
| PRV | PRV-29512 | 2026-07-26T15:15:08Z | Amanda | — | Bennett | 01/08/04 | UHC-35446-77 | - | 482-762-9839 | - | 6065 UNION STREET | Columbus·· | OH | 43251 | NULL | ···· |
| PRV | PRV-25510 | 2026-08-05T11:51:09Z | Ruth | — | Palmer | 1979-02-26 | - | — | (483) 860-0196·· | — | NULL | — | — | — | - | UNKNOWN·· |
| PRV | PRV-23338 | 2026-03-23T04:30:46Z | Elijah | ·· | Weber | 9/16/1993 | UHC7699558 | ·· | UNKNOWN | elijah.weber@outlook.com | 6572 Washington St | Fresno | CA | 93780 | ·UNKNOWN | NULL |
| PRV | PRV-22633 | 2026-06-24T08:19:08Z | Kathryn | — | ·Bailey | 1952-03-04 | — | N/A | (388) 662-0737 | N/A | 4062 Baseline Road #826 | Tampa | FL·· | — | NULL | CORE-HMO |
| PRV | PRV-24974 | 2026-04-01T03:51:34Z | Nancy | W | Hansen | 1975-08-24 | - | UNKNOWN | 587.405.2485 | nancy.hansen@hotmail.com | 8671 Harbor Boulevard | Charlotte | NC | 28282 | N/A | N/A |
| PRV | PRV-21053 | 2026-01-24T03:48:31Z | MEI | A. | GRIFFIN | 1/25/1958 | — | — | null·· | mei.griffin@aol.com | 7654 Mesa Dr | Sacramento | CA | ·95860 | NULL | OPTIONS-PPO |
| PRV | PRV-28051 | 2026-05-26T21:34:01Z | mateo | — | park | 1945-02-10 | UHC-91913-60 | •••-••-2939 | 894-615-6013 | ·mateo.park89@yahoo.com | 485 Jefferson Avenue | Glendale | AZ | 85396 | — | — |
| PRV | PRV-21039 | 2026-02-21T10:32:23Z | Ramirez, Janice | — | — | 2/17/1973 | UHC-60736-65 | •••-••-5284 | 2633376732 | JANICE.RAMIREZ38@AOL.COM | 4673 SUNSET BOULEVARD | ·Eden Prairie | MN | 55358 | N/A | — |
| PRV | PRV-27460 | 2026-08-22T22:33:49Z | Thomas | — | Matthews·· | 20020828 | UHC-58466-91 | ·NULL | 3193831 | thomas.matthews@hotmail.com | 8141 Mountain View Drive·· | Miami | FL | 33161 | — | ·null |
| PRV | PRV-26554 | 2026-05-28T01:50:20Z | BARBARA | V | ROGERS | Dec 17, 1993 | — | - | (932) 498-3128 | UNKNOWN | 3065 VALLEY VIEW DR | Mesa | AZ | 85292 | ···· | NULL |
| PRV | PRV-26999 | 2026-01-22T01:17:19Z | JUUSTIN W | — | GARRETT | Sep 4, 1988 | UHC-18690-32 | - | 748-510-2147 | — | 1158 RIVER ROAD | TAMPA | FL | 33677 | UNKNOWN | NULL |
| PRV | PRV-26580 | 2026-09-05T16:27:08Z | Cunningham, Maria | — | — | 1959-10-20 | UNKNOWN | •••-••-3893 | +1 898 808 5832 | NULL | 7075 Pine Drive | Los Angeles | CA | ·90008 | ·N/A | OPTIONS-PPO |
| PRV | PRV-22002 | 2026-09-16T15:09:35Z | Bradley | — | Tailor | 02/24/77 | UHC-96928-98 | — | 6317958677 | ·UNKNOWN | 4774 Meadow Lane | PLANO | TX | 75045 | N/A | UNKNOWN |
| PRV | PRV-23951 | 2026-09-22T15:02:48Z | Sandra·· | — | Williamson | 1981-10-08 | UHC-46877-79 | — | 493-942-5136 | — | N/A | — | - | ·- | UNKNOWN·· | N/A |
| PRV | PRV-23680 | 2026-04-28T13:38:18Z | Jack·· | Z | Arnold | 2007-11-16 | N/A | UNKNOWN | (701) 966-1203 | JACK.ARNOLD@GMAIL.COM | ·2516 Central Avenue | DENVER | CO | 80212 | — | -·· |
| PRV | PRV-25954 | 2026-08-14T15:22:06Z | Laura | P | Perry | 2/9/1980 | UHC-48608-36 | NULL | (903) 820-3639 | — | — | null | UNKNOWN | — | N/A | - |
| PRV | PRV-21406 | 2026-08-11T12:39:19Z | BRENDA | — | JOHNSTON | 1996-01-24 | ·· | NULL | 18784258724 | ·BRENDA.JOHNSTON56@OUTLOOK.COM | 1490 River Rd | TAMPA | FL | 33656-1886 | N/A | - |
| PRV | PRV-27574 | 2026-09-19T16:35:41Z | Sharon | L | Stevens | ·19480804 | UHC-69450-62 | N/A | (682) 845-9845 | UNKNOWN | 5794 JEFFERSON AVE | Los Angeles | CA | 90084 | - | — |
| PRV | PRV-28180 | 2026-05-25T08:18:33Z | MARY | — | HERRERA | 03/20/73 | NULL | N/A | — | null | 7943 Palm Drive | Houston | TX | 77040 | UNKNOWN | - |
| PRV | PRV-22555 | 2026-02-22T13:48:59Z | Cheryl | — | Rios | 1947-10-04 | UHC0410347 | — | (747) 786-8492·· | — | 6678 Mountain View Drive | Columbus | OH | 43272 | NULL | NULL |
| PRV | PRV-26777 | 2026-04-15T01:43:31Z | Jennifer | — | Burton·· | 1969-06-02 | UHC-57790-33 | N/A | 9013974607 | jennifer.burton13@yahoo.com | ·- | UNKNOWN | ·null | — | N/A | — |
| PRV | PRV-23064 | 2026-05-28T16:10:21Z | ·Paul | A | Crawford·· | 04/03/00 | UHC-85132-11 | UNKNOWN | 4066652 | — | 5404 Highland Avenue | Columbus | OH | 43298 | — | ·CHOICE-PLUS-PPO |
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:43.608Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty