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-26552 | 2026-09-04T07:12:40Z | arjun | B. | palmer | 1946-06-25 | - | — | 5404493938 | — | 6417 Canyon Rd | Mesa | AZ | ·- | N/A | N/A |
| PRV | PRV-21592 | 2026-07-26T00:27:06Z | VALEENTINA | ·B | DUNCAN | 08-02-1952 | — | •••-••-5242 | ·+1 331 766 7418 | — | 5220 INDIAN SCHOOL RD·· | Los Angeles | CA | 90089-5191 | null·· | — |
| PRV | PRV-28641 | 2026-08-30T21:58:13Z | ·MARIA | — | ROSE | Sep 16, 1969 | - | •••-••-5622 | 7594134013·· | UNKNOWN | ·1103 SUNSET BLVD | Seattle | WA | 98123 | — | - |
| PRV | PRV-25777 | 2026-02-13T17:09:44Z | RACHEL | — | FREEMAN | 1974-12-07·· | — | •••-••-8242 | 9563321775 | - | 7580 Central Ave | NASHVILLE | tn | 37276 | - | ·UNKNOWN |
| PRV | PRV-22326 | 2026-02-26T04:39:15Z | Larry | — | Walker·· | 5/24/1993 | UNKNOWN | N/A | 2322253654 | N/A·· | 5805 Mesa Dr | EDEN PRAIRIE·· | ·MN | 55329 | UNKNOWN | UNKNOWN |
| PRV | PRV-24619 | 2026-06-09T23:47:44Z | ·Logan | — | Lawson | 11/11/1992 | — | UNKNOWN | (283) 680-7393 | — | 9216 MESA DR | Atlanta | GA | 30313 | — | CORE-HMO |
| PRV | PRV-23859 | 2026-07-29T12:09:03Z | Miller, Gary | — | — | ·Apr 20, 1993 | - | - | +1 211 292 0633 | — | 6416 Harbor Boulevard | LOS ANGELES | CA | 90038 | — | — |
| PRV | PRV-24110 | 2026-03-20T20:30:16Z | Donna | — | Foster | 1995-07-14 | NULL | NULL | 14476310906 | null | NULL | NULL | — | — | — | — |
| PRV | PRV-29578 | 2026-01-07T05:07:25Z | Tyler | — | Lewis | 1972-06-24 | — | N/A·· | 267-614-3133 | TYLER.LEWIS86@ICLOUD.COM | 2862 Forest Ave | LOS ANGELES | CA | 90080 | UNKNOWN | - |
| PRV | PRV-20132 | 2026-08-26T21:41:45Z | Amenda | H. | Campbell | 1953-03-03 | N/A | null | (655) 645-5375 | — | 2081 PARK PL Apt 20 | Columbus | oh | 43220 | — | UNKNOWN |
| PRV | PRV-26107 | 2026-04-21T10:31:42Z | Butelr, Virginia | — | — | 2007-10-13 | UHC-66385-71 | — | 2373512451 | NULL | 2022 Spring Street·· | Las Vegas | NV | 89163 | NULL | UNKNOWN |
| PRV | PRV-21276 | 2026-07-28T23:00:28Z | LUCIA | M | WOOD | 1943-02-52 | — | — | 3418749619 | null | 8150 Pine Dr | FRESNO | CA | ·93726 | NULL | SELECT-EPO |
| PRV | PRV-21951 | 2026-06-10T21:07:48Z | andrea | — | foster | May 24, 2002 | UHC-45296-24 | null | 8298611 | null | 3205 Union St | ·Tucson | AZ | 85789 | null | NULL·· |
| PRV | PRV-21355 | 2026-08-01T11:04:12Z | Ashley | — | Gordon | Nov 11, 1983·· | null | •••-••-6987 | (579) 799-6732 | — | ·7103 Spring St Apt 1 | Glendale | AZ | UNKNOWN | NULL | - |
| PRV | PRV-21062 | 2026-01-18T19:11:08Z | VICTORIA | — | COOK | 1942-07-17 | - | NULL | 540-608-5923 | N/A | 8105 Cedar Ln | Fresno | CA | 93756 | UNKNOWN·· | UNKNOWN |
| PRV | PRV-20734 | 2026-04-25T14:57:46Z | Ortega, Julia | — | — | 0926-91-99 | - | -·· | — | ···· | 9413 Jefferson Avenue | Denver | CO | 80281 | UNKNOWN | — |
| PRV | PRV-20359 | 2026-07-21T18:29:42Z | Victoria | — | Wilson | ·6/12/1951 | UHC-11161-09 | NULL | 934-663-1750 | — | 9848 Indian School Rd | Jacksonville | FL·· | ·NULL | — | — |
| PRV | PRV-21965 | 2026-04-21T19:22:53Z | Jacqueline, Nunez | — | — | 6/14/1947 | UHC-70312-06 | — | 4592746367 | jacqueline.nunez64@aol.com | 2269 SAGE COURT | GLENDALE | AZ | 85342-2812 | N/A | UNKNOWN |
| PRV | PRV-28017 | 2026-06-20T00:13:58Z | Fatima | — | Freeman | 19860904 | UHC-38123-26 | UNKNOWN | +1 543 821 6398 | FATIMA.FREEMAN62@OUTLOOK.COM | 6623 CHURCH STREET | Glendale | AZ | 85378 | NULL | SELECT-EPO |
| PRV | PRV-25905 | 2026-06-23T09:56:58Z | ·Jaon | — | Le | 1962-09-25 | UHC-35979-49 | NULL | 8633354878 | joan.le97@hotmail.com | 2959 Maple Avenue | SAN DIEGO | CA | 92121 | - | MEDICARE-ADV-B |
| PRV | PRV-25716 | 2026-03-19T17:39:15Z | Pena, Robert | — | — | 1996-09-07 | UHC8345057 | - | 6343820671 | — | NULL | - | N/A | - | NULL | N/A |
| PRV | PRV-28175 | 2026-02-24T05:07:23Z | Arnold, Laura | — | — | Sep 24, 1982 | - | •••-••-6851 | 389-403-3525 | null | 6320 Main Street | SCOTTSDALE | AZ | ·85283 | N/A | - |
| PRV | PRV-27548 | 2026-08-23T16:43:22Z | Sharon | — | Hicks | 11-02-1955 | ···· | •••-••-6329 | (709) 744-5554 | sharon.hicks@hotmail.com | 6437 Spring Street | Scottsdale | AZ | 85280 | — | - |
| PRV | PRV-20284 | 2026-05-03T04:55:12Z | DONNA | — | SANCHEZ | 1979-09-22 | — | NULL | 9370001 | donna.sanchez@yahoo.com | 2472 Harbor Boulevard·· | Scottsdale | AZ | 85225 | N/A | UNKNOWN |
| PRV | PRV-21728 | 2026-02-09T06:16:51Z | Evelyn | — | Sith | 1970-05-01 | — | — | 9723211528 | - | 1370 Broadway | Glendale·· | AZ | 85301 | NULL | null |
| PRV | PRV-28424 | 2026-08-11T23:16:26Z | Sullivan, Jordan | L. | — | 14-02-2001 | - | •••-••-3496 | 6698503292 | ·· | 2637 Ocean Ave | Gilbert | AZ | 85253 | null | — |
| PRV | PRV-27180 | 2026-04-26T12:37:40Z | BILLY | M. | BURNS | 1994-09-28 | - | null | 632-733-0132 | billy.burns@hotmail.com | 1909 RIVER RD | COLUMBUS | OH | 43251 | UNKNOWN | NULL |
| PRV | PRV-20814 | 2026-06-08T16:39:03Z | OMAR | — | VAZQUZ | 15-09-1953 | UHC3379046 | UNKNOWN | ·6527212 | null | 753 Camelback Rd Apt 21 | TUCSON·· | AZ | ·85752 | UNKNOWN | — |
| PRV | PRV-24668 | 2026-08-26T08:43:47Z | ·Gardner, Marcus | — | ···· | 03/10/91 | ·UHC-24243-44 | — | 9809267086·· | NULL·· | 9015 Meadow Lane | SACRAMENTO | CA | 95890 | UNKNOWN | — |
| PRV | PRV-26636 | 2026-10-12T02:51:09Z | SEAN | — | GARDNER·· | 1960-47-20 | UHC-33476-72 | •••-••-4226 | - | ···· | 9447 LAKE VIEW ROAD | Seattle | WA | 98112 | null | null |
| PRV | PRV-26301 | 2026-07-04T01:57:15Z | Fostre, Sandra | — | — | 19-07-2001 | N/A | UNKNOWN | 8917708882·· | N/A | 2551 Pine Drive | ·Columbus | ·OH | ···· | - | — |
| PRV | PRV-29263 | 2026-08-18T16:46:26Z | jacqueline | ···· | richards | 2004-09-10 | — | N/A | (335) 206-0718 | null | 2754 Main St | DALLAS | TX | 75298 | — | — |
| PRV | PRV-23783 | 2026-07-25T11:03:52Z | JOSH | — | STONE | 19770807 | N/A | — | 7415293754 | N/A | 9296 Jefferson Ave | Plano | TX | 75096 | UNKNOWN | — |
| PRV | PRV-28289 | 2026-06-28T07:11:23Z | Terry | — | Bailey | 1996-06-13 | UHC-05528-15 | •••-••-9538 | 471-603-9319 | null | 2861 Oak St | Gilbert | AZ | 85278 | - | MEDICARE-ADV-A |
| PRV | PRV-27201 | 2026-06-19T07:06:25Z | Ralph K | — | ·Collins | 1989-01-03 | UNKNOWN | — | 925-730-7915 | UNKNOWN | 1999 OCEAN AVENUE | Columbus | OH | 43240-9414 | N/A | — |
| PRV | PRV-23054 | 2026-05-21T06:36:25Z | kenneth | V. | sanders | ·N/A | UHC-49739-30 | ·· | ···· | KENNETH.SANDERS30@AOL.COM | 5503 JEFFERSON AVENUE | Nashville | TN | 37274-5636 | — | — |
| PRV | PRV-25601 | 2026-06-04T21:37:25Z | Heather | — | Morales | 1942-08-03 | N/A·· | null | 408-726-0394 | heather.morales@hotmail.com | 6122 Baseline Road | AUSTIN | TX | 78708 | — | NULL·· |
| PRV | PRV-29018 | 2026-05-07T11:57:30Z | Diego | P. | Montgomery·· | 1950-06-08 | — | — | +1 942 911 8311 | — | UNKNOWN | UNKNOWN | ···· | UNKNOWN | N/A | CORE-HMO |
| PRV | PRV-24661 | 2026-04-10T04:50:04Z | Tyler | — | Banks | 24-05-2001 | — | •••-••-9943 | 508-654-6382 | null | ·6126 Ocean Avenue | Seattle | WA | 98110 | N/A | UNKNOWN |
| PRV | PRV-23754 | 2026-08-03T00:48:26Z | Amanda | — | Montgoery | 3/19/1969 | null | •••-••-8990 | 7775358349 | — | 6520 Harbor Blvd | Plano | TX | 75061-0363 | N/A | NULL |
| PRV | PRV-25616 | 2026-02-16T05:56:27Z | Joseph·· | — | Carpenter | 1/28/1942 | UHC7938069 | •••-••-7598 | N/A | NULL | 874 Main St | Tucson | AZ | 85713 | NULL | null |
| PRV | PRV-29162 | 2026-05-30T10:43:37Z | RYAN | T. | ANDERSON | 1999-10-17 | UHC-78959-95 | NULL | (556) 382-3951 | ryan.anderson79@aol.com | 1852 Main Street | Las Vegas | NV·· | 89111 | null | - |
| PRV | PRV-25787 | 2026-01-17T08:48:01Z | Vincent | — | Guerrero | 19650901 | — | — | 2012751580 | UNKNOWN | 4646 BASELINE ROAD | Minneapolis | MN | 55483 | ···· | MEDICARE-ADV-B |
| PRV | PRV-25641 | 2026-06-03T06:27:39Z | Danielle | — | Wheeler | 1997-09-09 | UHC-34384-77 | null | (676) 211-4890 | UNKNOWN | 3755 CHURCH STREET | HOUSTON | TX | 77002-9972 | N/A | CORE-HMO·· |
| PRV | PRV-24613 | 2026-09-21T22:13:13Z | AISHA | G | ANDERSON | 10/20/1978 | UHC-70821-83 | N/A | NULL | aisha.anderson@gmail.com | 2830 Indian School Road | Plano | ·Texas | null | — | — |
| PRV | PRV-21258 | 2026-07-13T08:22:28Z | JOE | M | FLORES | 1977-12-18·· | — | - | 16988253862 | N/A | 8481 River Rd | PLANO | TX | 75008 | N/A | ·choice-plus-ppo |
| PRV | PRV-24217 | 2026-03-12T16:25:25Z | Jordan | — | Warren | 06/16/97 | UHC-42873-90 | - | +1 283 540 5830 | — | 6339 Harbor Boulevard | Fresno | CA | 93779 | UNKNOWN·· | — |
| PRV | PRV-24122 | 2026-04-01T12:06:09Z | Tyler | Q | Alvarado | 03/01/93 | UHC-30206-42 | UNKNOWN·· | — | null | 1297 Valley View Drive | Gilbert | AZ | 85264 | UNKNOWN | UNKNOWN |
| PRV | PRV-23095 | 2026-08-11T04:27:20Z | Arjun | — | ·Gutierrez | 2005-12-12 | UHC-35844-53 | null | (497) 603-0816 | N/A | 1284 Canyon Rd·· | San Antonio | TX | 78238 | null | N/A |
| PRV | PRV-26095 | 2026-07-23T22:04:28Z | ·Linda | — | McDonald | 1980-04-09 | UHC-70228-56 | •••-••-7783 | 6556550558 | — | ·6056 Highland Ave | Atlanta·· | Georgia | 30385 | — | — |
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:49.088Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty