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-26332 | 2026-03-03T01:04:08Z | GLORIA | — | STEWART | 1979-03-28 | N/A | - | (477) 256-1517 | N/A | 7869 INDIAN SCHOOL ROAD | Jacksonville | FL·· | NULL | UNKNOWN | — |
| PRV | PRV-25830 | 2026-09-12T04:23:22Z | jennifer·· | — | russell | 2003-03-03·· | UHC-52480-15 | - | 214-757-6362 | N/A | 8600 Ridge Road | Chandler | AZ | 85287-3276 | — | CORE-HMO |
| PRV | PRV-27776 | 2026-06-09T06:39:35Z | anna | — | boyd | 1965-11-09 | UHC-73892-28 | •••-••-1823 | 15442414118 | — | 6021 Broadway | Dallas | TX | — | null | CORE-HMO |
| PRV | PRV-28885 | 2026-01-10T05:35:30Z | Terry | — | Salazar | 12/6/1946 | NULL | UNKNOWN | N/A | UNKNOWN | 1265 Desert Sky Blvd | Austin | TX | - | - | null |
| PRV | PRV-27597 | 2026-03-31T13:16:20Z | Barbara | — | Little | 1987-04-01 | UHC-84382-79 | NULL | NULL | barbara.little33@yahoo.com | 629 Spring Street | SACRAMENTO | CA | 95841·· | N/A | UNKNOWN |
| PRV | PRV-23977 | 2026-06-29T10:30:19Z | JACOB | ·· | WBEB | 19850507 | UHC-07880-02 | — | — | - | ·6904 BROADWAY #970 | Houston | TX | 77048 | — | UNKNOWN |
| PRV | PRV-22529 | 2026-09-02T06:11:36Z | Rachel·· | V | Ford | 09/06/2006 | UHC-33536-04 | — | 2424692124 | RACHEL.FORD@ICLOUD.COM | 9233 Pine Drive·· | Minneapolis | MN | 55486 | null | NAVIGATE-HMO |
| PRV | PRV-24502 | 2026-10-02T17:11:01Z | Pamela | — | Fuller | ·1926-07-15 | ···· | •••-••-2432 | 3507003668 | pamela.fuller73@aol.com | 3814 MARKET ST | San Diego | CA | 92154 | null | N/A |
| PRV | PRV-25524 | 2026-08-16T07:02:22Z | GRAY | S | BRUCE | 1997-05-17 | UHC-70709-95 | - | 318.206.3982 | N/A | 3961 Baseline Rd | Minneapolis | MN | 55410 | — | - |
| PRV | PRV-20035 | 2026-05-21T10:14:29Z | Mariana | — | Turner | 07/23/1997 | NULL | NULL | 3437119710·· | NULL | 9224 SAGE COURT·· | Nashville | TN | 37264-0469 | — | - |
| PRV | PRV-23581 | 2026-10-15T05:27:34Z | Mateo | P·· | OBrien | ·Mar 9, 1969 | ·UHC-64674-51 | NULL | UNKNOWN | mateo.obrien23@yahoo.com | ·9873 PINE DR | ·Fresno | CA | 93740 | N/A | ·NULL |
| PRV | PRV-25330 | 2026-04-25T05:43:37Z | Jean | — | Bell | 1964-07-22 | NULL | - | (274) 719-6456 | jean.bell76@aol.com | 9449 OCEAN AVE | Houston | TX | 77047 | N/A | null·· |
| PRV | PRV-26874 | 2026-08-24T17:37:48Z | robert | — | moore | 1975-11-08 | - | UNKNOWN | (235) 472-9736 | robert.moore@outlook.com | 3363 Meadow Lane | Tucson | AZ | 85725 | UNKNOWN | MEDICARE-ADV-A |
| PRV | PRV-27757 | 2026-02-15T17:06:37Z | BRITTANY | — | WALSH | 1984-05-09 | - | - | 966.401.3822 | — | 6263 Forest Avenue | Denver | ·CO | 80220 | N/A | — |
| PRV | PRV-28982 | 2026-07-15T09:27:20Z | Olivia | — | Myers | 2008-06-12 | UHC-72847-85 | •••-••-1961 | (959) 792-3349 | olivia.myers@proton.me | 369 Apache Boulevard | Los Angeles | CA | 90023 | NULL | null |
| PRV | PRV-28664 | 2026-02-21T05:12:57Z | ANDY | — | FORD | ·04/18/67 | — | •••-••-7912 | 255-719-0087 | null·· | 4446 BAYSHORE DR | Scottsdale | AZ | 85266 | — | - |
| PRV | PRV-22855 | 2026-03-18T22:51:53Z | santiago | — | munoz | 2005-03-19 | UHC-00179-07 | null | (305) 336-7010 | - | 6165 PALM DR | Chandler | AZ | 85262 | null | MEDICARE-ADV-A |
| PRV | PRV-20473 | 2026-03-21T17:37:12Z | Gonzales, Ronald | ·G | — | May 19, 1951 | UHC7788907 | ·UNKNOWN | UNKNOWN | UNKNOWN | 2738 CENTRAL AVE | Jacksonville | FL | 32239 | — | UNKNOWN |
| PRV | PRV-23759 | 2026-05-14T21:02:26Z | Ruth | A. | Olson | ·1998-12-15 | NULL | ···· | NULL | UNKNOWN | NULL | - | N/A | — | ·null | ·N/A |
| PRV | PRV-21672 | 2026-04-25T22:13:58Z | Jacqueline | R | Ruiz | 1956-04-09 | UHC1722077 | — | 612-757-5916 | jacqueline.ruiz@aol.com | 4080 Elm St | Glendale | AZ | 85362 | — | N/A |
| PRV | PRV-22727 | 2026-05-17T04:34:14Z | Cynthia | — | Elliott | 2007-09-02 | UHC3872248 | NULL | 15113382771·· | - | 9248 Sage Ct | SAN ANTONIO | ·TX | 78200 | — | N/A |
| PRV | PRV-21873 | 2026-03-23T06:40:18Z | Maria | — | Marquez | 1967-08-01 | ·UHC-91326-09 | null | 3512180185 | NULL | 8371 SPRING ST | ATLANTA | GA | 30325 | — | NULL |
| PRV | PRV-24705 | 2026-02-23T00:22:19Z | Betty·· | — | Hart | 04/17/1993 | UHC-32493-85 | null | (915) 818-0225 | — | UNKNOWN | — | N/A | ·null | - | — |
| PRV | PRV-29113 | 2026-07-29T14:19:24Z | ·Morales, Patrick | — | — | 19660501 | UHC-01065-38 | •••-••-5246 | ·8953673611 | — | ·1729 Central Avenue | SACRAMENTO | CA | 95803 | null | UNKNOWN |
| PRV | PRV-25242 | 2026-07-28T17:10:25Z | RYAN | — | CHEN | 1104-19-63 | UHC-69720-39 | •••-••-6278 | null | ryan.chen51@yahoo.com | 4269 Maple Ave #585 | San Diego | CA | 92151-9763 | — | null |
| PRV | PRV-21574 | 2026-10-06T19:00:07Z | Walter | — | Espinoza | 1976-05-06 | UHC-40017-55 | NULL | 509.593.2183 | NULL | 9590 BAYSHORE DR | GILBERT | AZ | 85229 | null | NAVIGATE-HMO |
| PRV | PRV-26148 | 2026-10-18T20:24:47Z | JULIA | — | GARZA | 1951-12-07 | ·· | •••-••-7890 | N/A | julia.garza75@aol.com | 9030 Indian School Rd | Las Vegas | NV | 89162 | — | - |
| PRV | PRV-21306 | 2026-01-20T11:50:56Z | sofia | — | luna | 01/17/95 | UHC-09907-30 | — | (519) 593-7770 | sofia.luna24@yahoo.com | 4207 Cedar Lane | Dallas | TX | 75249 | — | MEDICARE-ADV-A |
| PRV | PRV-21733 | 2026-01-03T20:37:36Z | james | ·M. | hamilton | ·1994-09-27 | null·· | NULL | 466-325-6249 | james.hamilton@gmail.com | 2485 Mountain View Drive | Los Angeles | CA | ·· | UNKNOWN | — |
| PRV | PRV-24679 | 2026-10-12T01:05:36Z | FATIMA | — | MORENO | 1957-07-16 | UHC-24101-25 | - | 758-229-1647·· | ·fatima.moreno@aol.com | 7442 Oak Street Apt 36 | Denver | CO | 80254 | UNKNOWN | NULL |
| PRV | PRV-25947 | 2026-09-08T22:12:50Z | Alan | O. | Pierce | 1970-01-22 | — | UNKNOWN | - | - | 4710 Camelback Road | Charlotte·· | NC | 28235 | - | NAVIGATE-HMO |
| PRV | PRV-27543 | 2026-07-13T22:36:28Z | Aaron | — | Nunez | ·1987-02-13 | — | - | (920) 442-8633 | AARON.NUNEZ79@OUTLOOK.COM | 5598 Canyon Road | TAMPA | FL | 33653 | UNKNOWN | — |
| PRV | PRV-28310 | 2026-06-12T00:52:15Z | MICHELLE | — | HARRISON | 2000-04-28 | N/A | UNKNOWN | - | NULL | 2767 Indian School Rd | Jacksonville | fl | 32204 | N/A | null |
| PRV | PRV-21922 | 2026-08-25T18:29:33Z | KATHERINE | — | STEVENS | ·19521220 | UHC-93932-26 | - | (428) 875-5375 | null | 7115 Apache Blvd | Jacksonville | Florida | 32255 | N/A·· | - |
| PRV | PRV-22576 | 2026-01-22T03:09:16Z | Hall, Alexander·· | N | — | 08/13/64 | UHC-37831-18 | ·UNKNOWN | NULL | UNKNOWN | 1436 River Rd | Nashville | TN | 37292 | — | — |
| PRV | PRV-29419 | 2026-08-01T06:45:40Z | Alan | S. | Lynch | 1959-07-02 | - | null | UNKNOWN | -·· | UNKNOWN | ·· | - | UNKNOWN | — | ·- |
| PRV | PRV-21625 | 2026-09-10T05:43:25Z | ·Terry | D.·· | Guzman | 19501208 | NULL | N/A | (475) 871-2939 | — | 3966 BAYSHORE DRIVE | Nashville | TN | 37247 | NULL | — |
| PRV | PRV-20275 | 2026-09-21T02:31:44Z | WAYNE | — | DIAZ | ·1974-08-03 | — | — | 810-381-9715 | - | 7786 Highland Ave | Minneapolis | MN | 55484-8064 | null | MEDICARE-ADV-B |
| PRV | PRV-21637 | 2026-01-28T12:56:28Z | JESSICA | — | ·TAYLOR | ·1951-02-22 | — | - | 3448900471 | ·· | 2381 LINCOLN WAY | Nashville | TN | 37246 | N/A·· | ·N/A |
| PRV | PRV-22867 | 2026-05-26T13:39:50Z | AHMED | — | ORTEGA | 19380124 | UHC-80634-45·· | UNKNOWN | (485) 367-2099 | — | ·2686 Cedar Ln | Houston | TX | 77044 | — | — |
| PRV | PRV-28600 | 2026-01-01T22:20:07Z | VIRGINIA | Y·· | WONG | 1971-03-07 | UHC-96611-25 | •••-••-5853 | 671-435-7218 | NULL | 6349 RIVER ROAD | Chandler | ·AZ | 85271 | — | SELECT-EPO |
| PRV | PRV-28971 | 2026-03-10T10:10:13Z | Sandra | — | McCoy | ·Nov 15, 1999 | N/A | UNKNOWN | 2688183877 | SANDRA.MCCOY@GMAIL.COM | 2098 Camelback Rd | Scottsdale | AZ | ·85282 | - | — |
| PRV | PRV-24124 | 2026-04-17T21:21:42Z | angela | — | espinoza | 12/14/05 | UHC8586470 | •••-••-8897 | 4256206749 | — | N/A | ·- | null | null | NULL | N/A |
| PRV | PRV-25473 | 2026-02-05T17:10:51Z | KAYLA | ···· | BROOKS | 1955-09-14 | null | NULL | 5992514981 | NULL | 2690 Oak Street Apt 4 | LOS ANGELES | CA | ·90007 | UNKNOWN | NAVIGATE-HMO |
| PRV | PRV-21155 | 2026-08-21T14:23:04Z | JEREMY | — | RICHARDS | Jul 11, 1990 | UHC-44276-58 | •••-••-9889 | (541) 255-2374 | jeremy.richards65@icloud.com | 9885 Union Street | Atlanta | GA | 30394 | N/A | — |
| PRV | PRV-27591 | 2026-07-17T01:58:19Z | DEBRA | E | SPENCER | Jul 17, 2002 | UNKNOWN | — | NULL | debra.spencer@aol.com | 1364 WILLOW COURT | ·PLANO | TX | 75023 | — | MEDICARE-ADV-B |
| PRV | PRV-23923 | 2026-05-03T14:03:00Z | TYLER | — | ALLEN | 09/22/71 | N/A | N/A | +1 675 842 6337 | — | 6556 Apache Blvd | PLANO | TX | 75082 | UNKNOWN | null |
| PRV | PRV-29200 | 2026-02-24T17:28:48Z | Anna | E | Weaver | 1965-12-26 | UHC-31781-97 | •••-••-4797 | 663-928-2869 | ·· | 400 Forest Avenue | SCOTTSDALE | ·AZ | 85221 | — | — |
| PRV | PRV-26211 | 2026-02-14T04:06:45Z | Mason | — | Ortiz | 02/08/2008 | N/A | N/A | 827-243-2942 | mason.ortiz@icloud.com | 9428 LAKE VIEW ROAD | Tempe | AZ | 85262 | — | CHOICE-PLUS-PPO |
| PRV | PRV-22787 | 2026-05-04T17:40:35Z | KEVIN | W. | STEWART | 17-06-1974 | UHC-27292-56 | •••-••-6009 | ·8483260593 | kevin.stewart54@icloud.com | 5356 Washington Street | Phoenix | az | 85065 | — | — |
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.439Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty