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-20837 | 2026-08-21T12:57:49Z | PATRICK | — | MCDONALD | 09/01/61 | UHC-20249-57 | UNKNOWN | 16435500728 | patrick.mcdonald42@hotmail.com·· | 8384 Baseline Rd | Jacksonville | FL | 32286 | null | MEDICARE-ADV-B |
| PRV | PRV-20672 | 2026-08-27T18:04:05Z | denny | — | sandeers | 1982-03-12 | N/A | - | null | DENNIS.SANDERS62@YAHOO.COM | — | UNKNOWN | — | ·NULL | ···· | NULL |
| PRV | PRV-28105 | 2026-02-27T05:47:04Z | hiroshi | — | nichols | 1940-10-19 | - | NULL | 224.541.2449 | - | 3716 CAMELBACK RD | Denver·· | Colorado | 80219 | — | - |
| PRV | PRV-29333 | 2026-07-01T18:10:29Z | ·Margaret | F. | Fernandez | 9/28/1938 | UHC-38371-52 | null | — | - | 1878 Ocean Ave | Atlanta | Georgia·· | 30309-9694 | — | SELECT-EPO |
| PRV | PRV-27319 | 2026-08-08T08:42:07Z | Rebeecca | — | Casstro | 1961-12-19 | UHC-67749-01 | — | (361) 442-1066 | — | 5577 Valley View Dr | SCOTTSDALE | AZ | 85240 | N/A | - |
| PRV | PRV-23929 | 2026-10-09T19:10:03Z | Richard | R | Boyd | 8/7/2001 | UHC-29020-28 | •••-••-6752 | 9136960693 | N/A | 1939 WILLOW COURT | Austin | TX | 78742 | N/A | — |
| PRV | PRV-21927 | 2026-04-29T02:24:05Z | jonathan | — | weaver | ·1979-02-25 | — | — | +1 732 853 5279 | NULL | 1511 Palm Drive·· | Tucson | ·az | 85793 | null | — |
| PRV | PRV-25814 | 2026-10-10T11:58:11Z | lawrence | P. | harvey | 01/13/1948 | null | NULL | 325.229.2733 | lawrence.harvey59@yahoo.com | 455 CANYON ROAD | Los Angeles | CA | 90051 | N/A | null |
| PRV | PRV-29553 | 2026-03-19T06:38:20Z | Gonzales, Isabella | — | — | 1983-10-21 | null | •••-••-0985 | +1 388 523 8477·· | isabella.gonzales35@yahoo.com | 4192 Apache Blvd | FRESNO | CA | 93704 | — | ·N/A |
| PRV | PRV-20477 | 2026-06-11T18:09:52Z | Guerrero, Helen | — | — | 1982-11-01 | - | — | (418) 717-4453 | UNKNOWN | NULL | — | NULL | — | ·null | — |
| PRV | PRV-20784 | 2026-08-27T23:39:20Z | Nick | Q | Simpson | 19521128 | UHC-41916-76 | — | 4854792555 | UNKNOWN | null | — | ·NULL | N/A | — | N/A |
| PRV | PRV-20601 | 2026-03-13T20:43:06Z | Allen, Stephanie | X | — | 1995-11-20 | - | •••-••-0417 | NULL·· | null | 8645 Apache Blvd | Tempe | az | — | NULL·· | SELECT-EPO |
| PRV | PRV-27299 | 2026-02-26T10:59:27Z | sofia | — | lucas | 19690412·· | UHC-89122-72 | — | 660-644-2234 | — | 9873 Union Street | Austin | TX | 78744 | — | N/A |
| PRV | PRV-28365 | 2026-05-02T14:27:31Z | Dinaa | ···· | Freemna | 02/21/05 | UHC-59043-73 | null | NULL | diana.freeman68@aol.com | 8283 OCEAN AVENUE | San Diego | CA | 92171 | null | — |
| PRV | PRV-26899 | 2026-10-06T20:13:01Z | deb | I | johnson | 22-12-1966 | NULL·· | null | — | UNKNOWN | 1475 Ridge Rd | Phoenix·· | AZ | 85079 | - | UNKNOWN |
| PRV | PRV-23975 | 2026-02-25T17:48:40Z | Alan | — | Bennett | 9/11/1985 | — | — | 632-660-1015 | null | 2470 LAKE VIEW ROAD | Charlotte | NC | ·28209 | NULL | CHOICE-PLUS-PPO |
| PRV | PRV-27137 | 2026-01-27T06:30:31Z | susen | B. | vazquez | 2007-09-06 | UHC-84134-22 | UNKNOWN | 13206987761·· | — | — | UNKNOWN | N/A | — | — | ·null |
| PRV | PRV-22812 | 2026-09-17T00:58:15Z | DONNA | — | COLEMAN | 1942-10-15 | UHC-56324-15 | •••-••-5870 | 624-506-5244 | null | ·7430 Palm Drive | Sacramento | CA | 95848 | NULL | NAVIGATE-HMO |
| PRV | PRV-29472 | 2026-03-25T06:00:48Z | Howard, Rebecca | — | — | 19980619 | UHC-89882-71 | null | 795.572.9868 | REBECCA.HOWARD39@ICLOUD.COM | 7322 Camelback Road | Austin·· | TX | 78751 | ·UNKNOWN | — |
| PRV | PRV-28758 | 2026-02-10T22:40:43Z | FATIMA | — | KNIGHT | ·1963-09-13 | UNKNOWN | N/A | +1 469 634 5513 | — | UNKNOWN | UNKNOWN | NULL | null | ·UNKNOWN | — |
| PRV | PRV-20305 | 2026-08-13T07:53:58Z | JOAN | — | ·SINGH | Mar 25, 1960 | — | null | 724.891.9613 | — | ·5676 Palm Drive | Eden Prairie | ·MN | 55317-5461 | — | — |
| PRV | PRV-20838 | 2026-10-17T09:57:05Z | Vega, Justin | — | — | 1963-07-18 | — | N/A | 711-853-3690 | - | 8801 WASHINGTON ST | Austin | TX | 78794 | N/A | SELECT-EPO |
| PRV | PRV-24505 | 2026-01-30T13:22:25Z | Roger | ·R | Aguilar | 1979-07-06 | UHC-34944-90 | — | 9273954·· | — | — | — | — | UNKNOWN | NULL | CHOICE-PLUS-PPO |
| PRV | PRV-20745 | 2026-02-06T11:56:57Z | Kelly | — | Carter·· | Jun 3, 1964 | UHC-41007-06 | null·· | null | UNKNOWN | null | — | ·- | — | — | null |
| PRV | PRV-29489 | 2026-08-13T14:29:57Z | EVELN | H | WRIGHT | 1986-04-13 | — | •••-••-4079 | UNKNOWN | evelyn.wright93@aol.com | 7919 HARBOR BOULEVARD | ·Jacksonville | FL | ·32236 | - | SELECT-EPO |
| PRV | PRV-25996 | 2026-04-25T22:09:10Z | Gibson, Melissa | I | — | 7/9/1965·· | — | N/A·· | 298.211.0885·· | N/A | 9252 MESA DR | Mesa | ·AZ | - | — | null |
| PRV | PRV-27735 | 2026-06-24T08:33:38Z | Ahmed | B. | ·Lewis | 27-06-1971 | UHC-60945-08 | N/A | 930-628-2183 | UNKNOWN | 6845 INDIAN SCHOOL RD | COLUMBUS | OH | 43216 | — | MEDICARE-ADV-A |
| PRV | PRV-25993 | 2026-07-21T00:44:50Z | LGOAN | R. | PARK | 09-12-1943 | — | - | 532-279-1353 | logan.park46@hotmail.com | 8579 Highland Ave | Sacramento | CA | — | N/A | - |
| PRV | PRV-26605 | 2026-09-25T17:28:36Z | dylan | — | gibson·· | 2002-01-13 | — | •••-••-6320 | 6757098180 | dylan.gibson99@outlook.com | 8165 Meadow Lane | Jacksonville·· | FL | 32264 | N/A | CHOICE-PLUS-PPO |
| PRV | PRV-26667 | 2026-09-01T07:00:13Z | CHARLOTTE | — | WELCH | 19-01-2005 | UHC-86033-30 | — | 14717463433 | charlotte.welch@proton.me | 3149 Cedar Lane | PLANO | TX | 75039 | — | — |
| PRV | PRV-26371 | 2026-03-30T00:39:21Z | Jordan, Paul | — | — | 10/24/58 | UHC-04379-22 | — | 3518967 | paul.jordan@icloud.com | 3424 Apache Blvd | LOS ANGELES | CA | 90020 | — | null |
| PRV | PRV-20959 | 2026-08-11T19:20:30Z | Doris | — | Sullivan | 1938-05-11 | UHC-02605-16 | •••-••-3033 | (277) 654-4676 | UNKNOWN | 2615 Park Place·· | Atlanta | GA | 30380 | UNKNOWN | — |
| PRV | PRV-28679 | 2026-09-16T20:02:10Z | DIANE | P. | SNYDER | 1952-05-14 | - | — | — | ···· | ·2666 Spring St | Austin | Texas | 78738 | UNKNOWN | — |
| PRV | PRV-23995 | 2026-04-13T05:43:02Z | JOHN | — | GREENE | 07/18/40 | — | — | 766.411.8050 | john.greene83@proton.me | 7982 Mesa Dr | Eden Prairie | MN | 55370 | NULL | UNKNOWN |
| PRV | PRV-22984 | 2026-08-07T01:46:53Z | LAWRENCE | — | HICKS | 16-03-1954 | null | — | ·6608903294 | — | 1518 Canyon Road | Eden Prairie | MN | 55323 | null | CORE-HMO |
| PRV | PRV-29522 | 2026-05-16T06:26:20Z | Christina | — | Martinez | 2000-02-25 | UHC-18976-50 | - | 12275227938 | null | ·8291 Sunset Boulevard | Houston | TX | 77059 | — | UNKNOWN |
| PRV | PRV-22930 | 2026-08-17T20:56:01Z | Emily | — | Nguyen | 2005-12-28 | null | - | 9036446652 | N/A | 2586 Indian School Rd | Sacramento | CA | 95836 | null | UNKNOWN |
| PRV | PRV-27617 | 2026-01-18T06:35:22Z | Austin | — | Tucker | 1949-03-19 | — | — | +1 477 964 2858 | austin.tucker71@yahoo.com | 9774 CENTRAL AVE | Mesa | ·AZ | 85289 | — | — |
| PRV | PRV-26535 | 2026-06-25T11:36:58Z | ·Marilyn | — | Daniels | 1964-06-17 | UHC-85880-83 | — | ·9025455044 | N/A | 2712 Canyon Rd·· | Tempe | AZ·· | 85250 | null | NAVIGATE-HMO |
| PRV | PRV-29390 | 2026-07-27T13:51:17Z | Adam | — | Schmidt | 1973-02-12 | -·· | •••-••-4907 | 264-941-5444 | N/A | 3416 Palm Dr | Orlando | FL | 32827·· | NULL | - |
| PRV | PRV-24727 | 2026-08-29T00:24:04Z | Lucia | ·· | Hawkins | 01/14/2008 | UHC-18251-37 | N/A | 14345373950 | — | 6889 Ocean Ave | Tempe | AZ | 85218-0906 | NULL | NULL·· |
| PRV | PRV-22803 | 2026-01-19T04:53:58Z | BILLY | — | HOLMES | 1941-01-13 | UHC5197856 | N/A | (469) 648-2637 | NULL·· | 1950 VALLEY VIEW DRIVE | Charlotte | ·NC | 28241 | — | N/A |
| PRV | PRV-29347 | 2026-07-26T11:37:47Z | Diego | P.·· | Dominguez | 19850101 | null | — | 666-723-2138 | — | 3937 Lake View Rd | Austin | Texas | 78784-4859 | UNKNOWN | NULL |
| PRV | PRV-28751 | 2026-01-04T00:44:06Z | Contreras, Kyle | — | ·· | 06/10/1962 | UHC-17396-44 | UNKNOWN | — | NULL | — | UNKNOWN | — | — | N/A | CORE-HMO |
| PRV | PRV-22124 | 2026-06-21T11:40:29Z | WALLACE | — | AHMED | 11-07-1970 | — | — | — | - | N/A | - | null | NULL | N/A | UNKNOWN |
| PRV | PRV-22355 | 2026-02-19T20:48:57Z | JESS | — | RYVERA·· | 2006-11-22 | UHC-07697-36 | N/A | 359-692-3588 | — | ·207 Canyon Rd | Miami | FL | 33103 | — | navigate-hmo |
| PRV | PRV-24992 | 2026-07-21T16:12:33Z | Wlater | C | Cle | 3/19/1946 | UHC-18104-33 | ·NULL | (267) 383-1887 | - | 6107 Palm Dr | Atlanta·· | GA | 30382 | - | CHOICE-PLUS-PPO |
| PRV | PRV-21034 | 2026-09-16T01:54:18Z | Rachel | K | Fernandez | 1965-06-19 | — | — | 4387420693 | — | 2170 Hillcrest Road | Sacramento | CA | 95830 | UNKNOWN | N/A·· |
| PRV | PRV-21885 | 2026-07-01T19:22:23Z | HEATHER | — | ESTRADA | 1964-12-10·· | N/A | •••-••-2291 | 9808767200 | — | - | — | UNKNOWN·· | N/A | — | - |
| PRV | PRV-26048 | 2026-05-14T23:45:15Z | Theresa | — | Wagner | 1942-07-27 | ·UHC-18014-03 | •••-••-2874 | 730-488-1951 | theresa.wagner@hotmail.com | 8816 Valley View Dr | Eden Prairie | MN | 55387 | UNKNOWN | 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:43:03.432Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty