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-22799 | 2026-01-07T16:37:01Z | GEORGE | — | RICHARDSON | 03/11/2004 | N/A | •••-••-1430 | ·+1 404 357 2491 | george.richardson@hotmail.com | 7985 Palm Dr | ·Sacramento | CA | 95884 | ···· | CORE-HMO |
| PRV | PRV-23159 | 2026-05-24T03:40:40Z | Wrren, Jese | — | — | 2008-11-17 | UHC-51170-46 | UNKNOWN·· | (463) 830-1687 | NULL | 7100 Hillcrest Rd | GILBERT | AZ | 85243 | null | - |
| PRV | PRV-27014 | 2026-05-28T08:27:17Z | Heather | — | Chavez | 1947-10-03 | UHC-48341-50 | •••-••-2903 | (299) 558-0953 | NULL | 698 Apache Blvd | Miami | Florida | 33189 | — | - |
| PRV | PRV-20686 | 2026-04-13T08:06:05Z | Sean | K | Jenkins | 1946-04-18 | — | — | 6543950 | null | 2326 Desert Sky Boulevard | CHANDLER | Arizona | - | — | — |
| PRV | PRV-20640 | 2026-03-20T05:39:32Z | CATHERINE | L | PHILLIPS | ·1981-08-26 | UHC-13217-11 | ·UNKNOWN | 5992624121 | CATHERINE.PHILLIPS@ICLOUD.COM | 8247 DESERT SKY BLVD | Seattle | WA | 98164 | null | ·N/A |
| PRV | PRV-28607 | 2026-09-28T23:17:00Z | Jose | ·· | Day | 2004-10-04 | UHC-65678-01 | — | 328.416.2887 | jose.day80@aol.com | 3940 Desert Sky Boulevard | Plano | TX | 75035 | UNKNOWN | null |
| PRV | PRV-22533 | 2026-01-24T11:02:31Z | Samantha | — | ·Alvarado | 1987-10-11 | null | •••-••-0355 | 610-242-2246 | samantha.alvarado@aol.com | 2471 Sunset Boulevard #195 | Fresno | CA | 93777·· | — | CHOICE-PLUS-PPO |
| PRV | PRV-24052 | 2026-07-25T17:55:39Z | ray | — | gilbert | 1995-07-08·· | UHC4752061 | — | 415-456-0807 | N/A | 6778 Sage Ct | Plano | TX | 75054 | — | — |
| PRV | PRV-29061 | 2026-04-24T14:00:53Z | NATALIE | — | MEDINA | 1963-09-06 | — | N/A | 489-329-4533 | natalie.medina@proton.me·· | 9112 River Road | Columbus | OH | 43250 | NULL | — |
| PRV | PRV-23538 | 2026-09-03T09:37:58Z | ashley | — | thompson | 6/17/2003 | UHC-02035-47 | — | (834) 838-5087 | - | 5416 Lincoln Way | Sacramento | CA | 95875 | UNKNOWN | — |
| PRV | PRV-24282 | 2026-08-16T22:56:01Z | Margaret | — | Patterson | 1977-09-12 | - | •••-••-7120 | 8035518926 | MARGARET.PATTERSON@ICLOUD.COM | 2729 Lincoln Way | Columbus | OH | 43264 | - | NAVIGATE-HMO·· |
| PRV | PRV-20725 | 2026-09-15T15:06:04Z | Mei | G | Torres | 1955-05-20 | — | UNKNOWN | 214-793-4215 | NULL | 6149 Central Avenue | Austin·· | TX | 78736 | — | — |
| PRV | PRV-24788 | 2026-09-16T22:25:35Z | KAREN | — | COOK | 1983-00-24 | UHC-61680-99·· | — | ·6046958693 | — | 7461 Mountain View Drive | Fresno | CA | NULL | UNKNOWN | OPTIONS-PPO |
| PRV | PRV-26876 | 2026-04-24T19:10:54Z | Richard | — | Boyd | 1960-01-03 | null | — | 2893718455 | UNKNOWN | 3990 OAK STREET | Tucson | AZ | 85789 | N/A | — |
| PRV | PRV-20242 | 2026-10-12T09:00:47Z | MARK | Y | FREEMAN | 2006-04-11 | null | ·- | 648.326.3859 | null | 8601 Jefferson Ave | Scottsdale | Arizona | 85277-6651·· | — | — |
| PRV | PRV-25903 | 2026-07-08T03:20:49Z | Zachary | X. | Mejia | 1961-08-07 | NULL | •••-••-2282 | 464-426-0763 | zachary.mejia38@gmail.com | — | null | — | — | UNKNOWN | — |
| PRV | PRV-29191 | 2026-02-19T10:56:53Z | GERALD | — | GARDNER | 1975-05-50 | null | •••-••-1652 | 8648705554 | null | 2107 Willow Court | San Antonio | TX | — | — | null |
| PRV | PRV-21240 | 2026-01-19T19:30:01Z | Carl | A. | Hoffman | 1941-12-11 | UHC1247499 | N/A·· | UNKNOWN | carl.hoffman@proton.me | 7522 Indian School Road | MIAMI | FL | 33185 | — | N/A |
| PRV | PRV-26391 | 2026-09-11T00:33:26Z | MARCUS | — | BELL | 19560702 | UHC-55171-32 | — | — | — | ·4720 PARK PLACE | Dallas | TX | 75237 | N/A | — |
| PRV | PRV-24630 | 2026-04-13T06:39:46Z | Peter | — | Baker | 4/28/2001 | UHC-99981-31 | — | N/A | - | 9241 SUNSET BOULEVARD | Fresno | CA | 93757-2317 | N/A | — |
| PRV | PRV-28694 | 2026-02-19T03:27:42Z | Sean | — | Vega | 1996-02-13 | UHC-58043-65 | •••-••-2469 | 15273840197 | ·N/A | 8359 Indian School Rd | Denver | CO | 80240 | - | — |
| PRV | PRV-24099 | 2026-08-10T02:12:31Z | Lynch, Isabella | ·N | — | 1998-01-28 | UHC-07898-24 | — | (718) 322-3704 | isabella.lynch36@gmail.com | 630 Church Street | Phoenix | AZ | 85099 | — | MEDICARE-ADV-B·· |
| PRV | PRV-27115 | 2026-05-26T09:57:28Z | Joshua | N. | Vasquez | 1966-07-05 | UHC-78452-70 | •••-••-6003 | (637) 637-1994 | JOSHUA.VASQUEZ34@PROTON.ME | 9356 PARK PL | Atlanta | GA | 30380 | — | NULL |
| PRV | PRV-28805 | 2026-04-29T05:24:18Z | Emily | — | Smith | 2002-12-16 | — | — | 5906622794 | - | 709 SPRING ST | Miami | FL | 33113 | — | — |
| PRV | PRV-22386 | 2026-08-11T22:52:42Z | kimberly | — | young | 07/18/74 | N/A | - | +1 361 218 6867 | kimberly.young@gmail.com | 5824 Washington Street | Mesa | AZ | 85291 | N/A | null·· |
| PRV | PRV-23180 | 2026-04-04T23:07:28Z | Kayla | — | ·Stephens | 1947-07-20 | UHC-86478-96 | •••-••-9676 | (801) 538-5915 | UNKNOWN | 2909 Washington Street #771 | Miami | FL·· | 33106-7064 | - | N/A |
| PRV | PRV-29514 | 2026-02-10T14:02:48Z | CHERYL | — | CARR | 11-12-1981 | — | UNKNOWN | 625-429-3747 | CHERYL.CARR96@AOL.COM | N/A | null | - | — | — | — |
| PRV | PRV-26632 | 2026-06-23T00:07:42Z | Scott | — | Thomas | 1979-06-10 | -·· | N/A | 7138305068 | — | 3750 Bayshore Drive | Chandler | Arizona | 85239 | N/A | UNKNOWN |
| PRV | PRV-22813 | 2026-03-27T14:53:57Z | Denise | F | Lopez | 1984-03-27 | UNKNOWN | •••-••-1528 | 894-661-3553 | DENISE.LOPEZ42@AOL.COM | 5822 HILLCREST RD | Minneapolis | ·MN | ···· | — | - |
| PRV | PRV-28312 | 2026-10-16T15:46:43Z | philip | — | wright·· | 1978-08-11 | N/A | — | (490) 744-9861 | ·philip.wright@proton.me | UNKNOWN | — | N/A | — | NULL | — |
| PRV | PRV-20150 | 2026-01-03T16:24:29Z | Mary | — | Hoffman | 2000-09-03 | ·UHC-18674-07 | - | (603) 242-8636·· | N/A | ·6372 Oak St | Glendale | AZ | 85303 | - | ·NULL |
| PRV | PRV-29086 | 2026-06-15T08:35:03Z | ANDREW | C. | PATEL | May 13, 1981 | NULL | — | 929-439-3483 | — | 4615 Maple Avenue | SAN ANTONIO | tx | N/A | — | — |
| PRV | PRV-26582 | 2026-01-07T05:04:32Z | ·brenda | A. | baker | 1/23/1962 | UHC-57775-48 | NULL | 6448973432 | — | — | — | — | — | — | ·N/A |
| PRV | PRV-28620 | 2026-05-30T22:59:48Z | Michelle | — | Lyynch | 1944-05-17 | NULL | null | 834-614-5726 | - | 7066 CENTRAL AVE·· | Jacksonville | FL | ·32227 | null | — |
| PRV | PRV-22715 | 2026-05-26T20:46:56Z | rachel | W | elliott·· | 19951125 | — | UNKNOWN | 961-285-2033 | rachel.elliott95@aol.com | 9231 River Road | San Antonio | TX | — | N/A | - |
| PRV | PRV-25399 | 2026-09-06T17:32:02Z | omar | — | rivera | 19561101 | UHC3423180 | •••-••-4992 | 950.904.0727 | — | 2530 Sunset Boulevard | Tampa | FL | 33636 | null | — |
| PRV | PRV-21713 | 2026-05-25T20:31:45Z | Larry·· | — | Bradley | 1979-01-15 | UHC-38911-80 | •••-••-2648 | N/A | LARRY.BRADLEY@AOL.COM | 1967 Meadow Lane | TUCSON | ·AZ | 85756 | N/A | N/A |
| PRV | PRV-23370 | 2026-05-16T17:40:10Z | Emily·· | Y. | Guzman | 1938-01-16 | - | N/A | (957) 254-8194 | ·N/A | 88 Sage Court | Gilbert | AZ | 85204 | N/A | -·· |
| PRV | PRV-21632 | 2026-05-26T13:12:06Z | Edward | — | Robertson | ·Nov 16, 1995 | UHC-78337-86 | null | 9648396355 | null | 2821 Indian School Rd | Tampa | FL | 33618 | ·- | N/A |
| PRV | PRV-29435 | 2026-05-11T12:13:47Z | amy·· | — | bowman | Aug 19, 2001 | UHC-43285-35 | NULL | 305-440-8132 | — | 6542 VALLEY VIEW DRIVE | Eden Prairie | MN | 55368 | NULL | — |
| PRV | PRV-21806 | 2026-09-17T09:05:18Z | SANDRA | — | LUCAS | 2007-12-14 | UHC-39711-12 | •••-••-6419 | 537-405-1445 | sandra.lucas56@yahoo.com | 8619 Broadway | AUSTIN | TX | 78777 | NULL | null |
| PRV | PRV-28784 | 2026-06-24T11:58:54Z | Julia | ·Z | Nelson | 1997-06-11 | null | •••-••-7296 | (814) 213-5020 | NULL | ·6787 MAPLE AVE | Tucson | AZ | UNKNOWN | null | UNKNOWN |
| PRV | PRV-26857 | 2026-03-04T11:22:14Z | Kelly, Camila | — | — | 1962-06-14 | NULL | NULL | 8273197244 | ·· | 9580 CANYON ROAD | MESA | AZ | 85248 | — | SELECT-EPO |
| PRV | PRV-28319 | 2026-05-02T23:29:13Z | Michael | — | Nunez | 12/7/1991 | ·UHC-34718-24 | ·null | (370) 498-8608·· | — | N/A | - | UNKNOWN | null | UNKNOWN | options-ppo |
| PRV | PRV-26703 | 2026-08-10T22:55:30Z | Oliver, Charlotte | — | — | 1975-02-24·· | UHC-36496-49 | - | (953) 869-9888 | - | 5885 Highland Avenue | Phoenix | az·· | 85036-8554 | - | — |
| PRV | PRV-27860 | 2026-01-06T07:41:18Z | Sandra | ·· | ·Ward | 5/25/1996 | ·· | •••-••-0849 | (608) 546-0242 | NULL | 7221 Park Pl | Gilbert | Arizona | 85275 | null | - |
| PRV | PRV-29305 | 2026-07-28T01:22:50Z | Evelyn | U | Guzman | 07/11/90 | — | — | 324-322-9844 | - | 5792 BAYSHORE DRIVE | Seattle | WA | 98178 | null·· | — |
| PRV | PRV-24141 | 2026-02-04T23:42:07Z | JANET | W | WALLACE | 1939-11-19 | UHC-29568-55 | null | 858-879-3971 | janet.wallace74@icloud.com | 2662 ELM ST Apt 37 | Glendale | AZ | 85395 | N/A | NULL·· |
| PRV | PRV-26547 | 2026-06-08T20:54:38Z | jeramy X | ···· | ·pena | 10-07-1952 | — | — | (528) 373-4031 | N/A | ·2723 Indian School Rd | Orlando | FL | 32847 | — | — |
| PRV | PRV-20450 | 2026-07-16T05:06:54Z | Janice | — | Rice | 1938-12-26 | UHC-09502-63 | UNKNOWN | UNKNOWN | UNKNOWN | 8888 Palm Dr | TUCSON | Arizona | N/A | - | 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:53.127Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty