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-29562 | 2026-07-16T14:58:15Z | mary | — | mccoy·· | 19-02-2002 | UHC-45825-03·· | UNKNOWN | 755-393-6940 | UNKNOWN | 52 HARBOR BOULEVARD | PHOENIX | AZ | 85079 | — | — |
| PRV | PRV-28288 | 2026-06-10T08:32:31Z | LAURA | — | THOMAS | 1940-04-21 | UHC6347740 | N/A | 810-480-4448 | — | 2534 CENTRAL AVENUE | Columbus | OH | 43227·· | — | null |
| PRV | PRV-20515 | 2026-05-22T21:03:49Z | ·DOROTHY | ·· | JACOBS | 02/04/1942 | — | — | (432) 201-1656 | UNKNOWN | 2626 River Road | FRESNO | CA | 93771 | N/A | — |
| PRV | PRV-20464 | 2026-01-30T12:09:15Z | ·MARY | — | MURRAY | 1980-11-05·· | NULL | — | 211-679-3407 | mary.murray@aol.com | 1000 SPRING STREET | Miami | fl | 33103·· | — | - |
| PRV | PRV-24064 | 2026-03-14T06:36:46Z | MARIANA·· | — | SANTIAGO | 2007-11-22 | UHC-36282-56 | •••-••-8803 | 5317807023 | UNKNOWN | 4386 Jefferson Avenue·· | Tucson | AZ | 85737 | - | — |
| PRV | PRV-25104 | 2026-01-10T04:06:09Z | Jordan | D. | Vasquez | 1992-08-12 | null | •••-••-2816 | 942.499.7975 | jordan.vasquez@aol.com | NULL | NULL | — | null | ·- | UNKNOWN |
| PRV | PRV-20322 | 2026-09-25T15:45:55Z | Henry | — | Gray | 1950-12-21 | ···· | - | UNKNOWN | UNKNOWN·· | 119 Park Place | GILBERT | AZ | 85282 | null | ·NULL |
| PRV | PRV-23364 | 2026-09-28T23:35:25Z | JULIE | — | JOHNSON | 12/09/71 | UNKNOWN | NULL | N/A | N/A | 4699 Sunset Boulevard | Houston | TX | 77023 | null | null |
| PRV | PRV-22401 | 2026-08-24T23:16:34Z | Paul | — | Padilla | ·Dec 6, 1957 | uhc-43955-02 | NULL | 6535784633 | paul.padilla24@proton.me | 3595 Meadow Ln | Scottsdale | AZ | 85200 | — | null·· |
| PRV | PRV-23968 | 2026-08-16T03:55:20Z | Stephanie | S. | Castillo | 1999-07-09·· | null·· | null | ·3576652033 | stephanie.castillo@proton.me | 6638 GRAND AVE | Houston | TX | — | UNKNOWN | SELECT-EPO |
| PRV | PRV-20236 | 2026-03-28T14:18:50Z | Peters, Christina | ···· | — | 10/27/1943 | UHC-28826-82 | NULL | 3535380503 | UNKNOWN | N/A·· | UNKNOWN | — | ·UNKNOWN | UNKNOWN | - |
| PRV | PRV-28505 | 2026-06-16T13:41:35Z | JUDY | ·· | PATTERSON·· | 03/07/1998 | — | •••-••-9645 | 2455673822 | N/A | 7921 Church Street | Austin | TX | 78767 | — | null |
| PRV | PRV-24396 | 2026-07-07T16:10:21Z | ·Jimmy | — | Gray | ·1952-01-18 | null·· | •••-••-2586 | 282-327-5553 | N/A | 5047 UNION STREET | Charlotte | NC | 28266 | — | null |
| PRV | PRV-27846 | 2026-04-15T21:45:29Z | Lori | — | ·Allen | 1938-12-02 | UHC-74577-60 | - | +1 968 929 1275 | lori.allen88@proton.me | 2361 Market St | Plano | TX | 75099 | — | NULL |
| PRV | PRV-21412 | 2026-01-22T03:10:09Z | KATHLEEN | — | WALLACE | Mar 14, 2000 | UHC-39042-54 | — | - | ·NULL | 6675 HARBOR BLVD | Los Angeles | CA | 90015 | — | — |
| PRV | PRV-24766 | 2026-09-20T04:32:32Z | Aguilar, Jordan | A. | — | 19451104 | -·· | — | (831) 928-1593 | UNKNOWN | — | null | UNKNOWN | - | — | — |
| PRV | PRV-27709 | 2026-03-15T05:23:03Z | ANN·· | U | BAILEY | 06-01-2005 | - | — | 834.755.6210 | ANN.BAILEY@HOTMAIL.COM | 6633 Oak St | Chandler | AZ | ·85210 | NULL | null·· |
| PRV | PRV-27123 | 2026-06-19T20:11:46Z | Morgan, Omar | — | — | Dec 3, 1977 | UHC-44342-53 | null | (557) 766-7877 | N/A | ·9037 River Road | Sacramento·· | CA·· | — | — | - |
| PRV | PRV-20697 | 2026-05-12T22:46:26Z | Jacob | — | Black | Dec 2, 1992 | null | •••-••-4783 | ·368.780.1602 | - | 8159 Canyon Road | SACRAMENTO | CA | 95831-8368 | — | N/A |
| PRV | PRV-24308 | 2026-03-29T19:03:31Z | Arjun | ·· | ·Johnston | 1966-02-05 | UHC-67323-93 | •••-••-0761 | (631) 981-2942 | arjun.johnston18@aol.com | 3085 FOREST AVE | Austin | TX | 78763-4214 | N/A | — |
| PRV | PRV-27386 | 2026-07-13T20:36:38Z | Dorothy | — | Mejia | 8/27/1961·· | UHC-13045-75·· | - | — | dorothy.mejia27@icloud.com | null | — | null | — | - | — |
| PRV | PRV-28486 | 2026-10-02T19:22:31Z | WALTER | — | CARLSON | 1955-10-26 | UHC-39159-19 | — | (429) 540-6549 | — | 2773 Mountain View Dr | Phoenix | AZ | 85067 | null | — |
| PRV | PRV-26460 | 2026-09-04T17:17:06Z | Kennedy, Melissa | E | — | 11/03/1998 | NULL | - | 464-340-5080 | — | 7833 PARK PLACE | Fresno | CA | 93785 | — | — |
| PRV | PRV-22871 | 2026-04-26T02:11:44Z | Bradley, Olivia | — | — | 1969-04-23 | — | UNKNOWN | ·7374687565 | ·null | 3185 Apache Boulevard | ·Las Vegas | NV | 89116·· | — | null·· |
| PRV | PRV-20263 | 2026-09-23T13:14:52Z | Diana | — | Ross | 1985-04-21 | UHC-68670-46 | — | (466) 467-7953 | UNKNOWN | 5464 OAK STREET | Tempe | AZ·· | 85277 | NULL | - |
| PRV | PRV-21744 | 2026-09-10T21:19:01Z | Ethan | — | Li | 1947-07-13 | UHC-48504-34 | - | 323-205-0702 | ethan.li@gmail.com | 2446 MOUNTAIN VIEW DRIVE | Phoenix | AZ | 85064 | NULL | null |
| PRV | PRV-24279 | 2026-06-05T15:51:36Z | Santiago | M | Woods | Jul 20, 1999 | — | •••-••-1829 | 657-893-5566 | null | 8090 Lake View Rd #730 | CHANDLER | AZ | 85278 | NULL·· | choice-plus-ppo |
| PRV | PRV-25319 | 2026-07-23T01:13:00Z | MARY | — | COX | 1974-07-26 | N/A | NULL·· | - | N/A | 8749 Indian School Rd | Seattle | WA | 98151 | null | — |
| PRV | PRV-22819 | 2026-06-12T05:11:09Z | DONALD | E | FOX | 1994-09-09 | UHC-76516-01 | •••-••-8427 | UNKNOWN·· | null | 3402 PINE DRIVE | Tampa | FL | 33694 | — | - |
| PRV | PRV-21751 | 2026-06-11T18:55:02Z | TYLER | — | MASOON | 1971-03-26 | UHC-20831-74 | NULL | +1 557 697 4499 | ·null | 1085 MEADOW LN | Atlanta | GA | 30305 | UNKNOWN | — |
| PRV | PRV-29144 | 2026-04-21T01:41:58Z | Teresa | — | Munoz·· | May 17, 1949 | null | UNKNOWN | NULL | NULL | — | — | — | NULL | — | UNKNOWN |
| PRV | PRV-29529 | 2026-01-15T20:27:14Z | Fox, Laura | U | — | 1942-12-04 | N/A | N/A | 254-253-3119 | NULL | 3669 Spring St | Minneapolis | MN | 55474 | — | CORE-HMO |
| PRV | PRV-23038 | 2026-06-23T07:21:21Z | Ahmed | — | Burke·· | 19580622 | UHC-38144-72 | null | 387-764-7745 | NULL | 2720 Spring Street | Minneapolis | MN | 55435 | UNKNOWN | — |
| PRV | PRV-20677 | 2026-07-08T12:53:52Z | MIKE | W. | REYES | 1945-11-25 | UHC-84549-13 | •••-••-3023 | (348) 384-9828 | michael.reyes97@outlook.com·· | N/A | — | — | ···· | NULL | ·· |
| PRV | PRV-21000 | 2026-01-15T12:19:14Z | Terry | — | Padilla | 07/25/1940 | UHC-74052-85 | •••-••-9057 | 3276196347 | — | 5031 Camelback Rd | Plano | TX | 75003 | - | NULL |
| PRV | PRV-22829 | 2026-03-28T00:20:26Z | aisha·· | ···· | mason | 2002-10-17 | UHC-99034-92 | — | (411) 670-5178·· | aisha.mason26@outlook.com | 5568 Hillcrest Road | San Diego | California | ·92148 | — | null |
| PRV | PRV-22432 | 2026-02-22T16:57:44Z | Mateo | K | Clark | 2006-01-06 | N/A | - | (857) 465-9904 | mateo.clark7@aol.com | 399 MESA DR Apt 29 | Scottsdale | AZ | 85204 | null | NULL |
| PRV | PRV-28457 | 2026-03-24T18:30:12Z | ·Contreras, Michael | T | — | 9/7/1974 | UHC-41501-29 | - | 422-920-8685 | michael.contreras67@gmail.com | 5364 PINE DR | Houston | Texas | 77058 | - | — |
| PRV | PRV-21380 | 2026-04-04T04:11:26Z | Natalie | L. | Welch | 07-10-1981 | UHC-77444-76 | N/A | (643) 618-9753 | UNKNOWN | 218 Valley View Dr #844 | Tempe | AZ·· | 85274 | NULL | NAVIGATE-HMO |
| PRV | PRV-21092 | 2026-05-21T04:30:29Z | MARIA | — | MUNOZ | ·1974-05-22 | UHC-02382-28 | null | NULL | MARIA.MUNOZ94@AOL.COM | 7712 Cedar Ln | Tempe | ·AZ | 85257 | - | NULL |
| PRV | PRV-23479 | 2026-05-23T00:40:19Z | JULIE | J | WILSON | 1020-19-09 | UHC7638141 | - | (285) 947-6131 | UNKNOWN | 9127 Pine Dr #522 | COLUMBUS | Ohio | 43249 | N/A | — |
| PRV | PRV-28763 | 2026-04-27T22:36:23Z | Aisha·· | H. | King·· | 1981-07-14 | UHC-01605-28 | — | (460) 433-4400 | aisha.king@icloud.com | 2857 LINCOLN WAY | ·CHANDLER | AZ | 85208 | NULL | null |
| PRV | PRV-23536 | 2026-02-11T05:46:42Z | Diego | L·· | Carroll | ·1953-07-05 | UHC-04213-88 | •••-••-1902 | 9617760210 | DIEGO.CARROLL65@PROTON.ME | NULL | null | null | N/A | — | - |
| PRV | PRV-22897 | 2026-09-12T15:28:32Z | MARCUS | — | BRYANT | 1970-06-24 | UHC-24560-06 | ·· | 3754172797 | NULL·· | 7423 Spring St #682·· | Fresno | CA | 93766 | - | — |
| PRV | PRV-20434 | 2026-05-31T22:56:28Z | Bryan | — | Cruz | ·1941-08-23 | N/A | •••-••-2816 | 541.283.3470 | UNKNOWN | 2664 Park Place Apt 16 | Eden Prairie·· | MN | 55330 | null | ·NAVIGATE-HMO |
| PRV | PRV-21400 | 2026-08-21T11:31:12Z | Heather | — | Myers | 1958-01-04 | UHC-23811-98 | NULL | 14379955558 | N/A | 5967 Ridge Road #439 | Phoenix | AZ | 85039 | null | N/A |
| PRV | PRV-22081 | 2026-09-21T17:31:44Z | charlotte | ·· | ·coleman | 5/5/1994·· | — | •••-••-5676 | 703-576-1622 | CHARLOTTE.COLEMAN@AOL.COM | 4598 BASELINE ROAD | Nashville | TN | 37221 | UNKNOWN | SELECT-EPO |
| PRV | PRV-23020 | 2026-05-10T08:25:55Z | ·Olivia | L | Ruiz | 08-03-1979·· | — | — | — | ·olivia.ruiz@icloud.com | 4821 Market St | Austin | TX | 78765 | — | - |
| PRV | PRV-23700 | 2026-09-14T20:42:45Z | Santiago | — | Wong | 1969-01-19 | UNKNOWN | null | 6855242033 | santiago.wong@yahoo.com | ·- | null·· | ·UNKNOWN | UNKNOWN | UNKNOWN | ·N/A |
| PRV | PRV-28073 | 2026-08-29T16:04:34Z | Owens, Mariana | — | — | 1998-06-24 | N/A | null | 519-898-1877 | mariana.owens@aol.com | 6172 Ocean Ave | Orlando | FL | 32836 | — | N/A |
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:37.743Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty