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-20485 | 2026-08-13T13:41:06Z | Terry·· | — | ·Hansen | 10/9/1956 | — | UNKNOWN | 479.889.8424 | UNKNOWN | 9836 Camelback Road | GILBERT | AZ | 85294 | ·N/A | OPTIONS-PPO |
| PRV | PRV-20596 | 2026-05-16T10:30:45Z | lisa | H | payne | 06-05-1986 | null | null | 460-918-7364 | NULL·· | 4985 Sage Ct | Atlanta | ·GA | 30333 | N/A | — |
| PRV | PRV-24013 | 2026-02-15T06:13:46Z | Paul | ·· | Millls | 08/05/00 | UHC-43060-63 | — | (784) 517-0118 | null | 5434 Indian School Rd | Plano | TX | — | — | MEDICARE-ADV-B |
| PRV | PRV-28065 | 2026-02-17T10:13:58Z | LAUREN | R | MURPHY·· | Aug 21, 1969 | - | — | 923.729.7088 | null | 2578 Lake View Road | Orlando | FL | 32845 | UNKNOWN | N/A |
| PRV | PRV-22552 | 2026-02-27T15:47:29Z | Stephen | — | Munoz | 11-04-1971 | — | null | 5838556176 | stephen.munoz14@proton.me | ·4303 Maple Avenue | Scottsdale | AZ | 85280 | NULL | ···· |
| PRV | PRV-27434 | 2026-08-24T02:31:17Z | Alan | — | ·Wheeler | 09-03-1941 | NULL | •••-••-6485 | 12066442524 | ·· | 2513 Bayshore Drive | LAS VEGAS | NV | 89167 | — | NULL |
| PRV | PRV-22347 | 2026-08-05T04:58:57Z | Bryen·· | — | Ryan | 6/11/1983 | — | ·· | 19684781122 | UNKNOWN | 1607 Desert Sky Boulevard | Sacramento | CA | 95858 | UNKNOWN | — |
| PRV | PRV-23356 | 2026-02-24T16:02:28Z | Murphy, Mason | B | — | 1956-11-11 | UHC-40374-19 | NULL | (211) 879-9022 | N/A | 3805 Pine Drive Apt 28 | EDEN PRAIRIE | MN | 55300 | N/A | — |
| PRV | PRV-25760 | 2026-09-04T00:08:46Z | Nicole | I | Barnes | 19930126 | UHC-03627-37 | UNKNOWN | 17259883788 | null | 480 WASHINGTON ST | Nashville | tn | 37288 | UNKNOWN | — |
| PRV | PRV-20159 | 2026-01-12T04:45:29Z | Debra | X | Bishop·· | 1939-08-24 | UHC-47053-48 | — | 421-483-1954 | UNKNOWN | 6338 Grand Ave #441 | Orlando | FL·· | 32862 | N/A | NULL |
| PRV | PRV-26264 | 2026-03-04T20:32:20Z | AMANDA | — | HALL | 2005-05-01 | — | — | (478) 243-2432 | UNKNOWN | 9017 CHURCH ST | Mesa | AZ·· | 85215 | — | N/A |
| PRV | PRV-27125 | 2026-03-08T11:03:17Z | TIMOTHHY | S | ALEXANDER | 1962-08-04 | — | — | (821) 406-3545 | — | 4556 Desert Sky Boulevard | Fresno | CA | 93724 | N/A | — |
| PRV | PRV-25862 | 2026-06-22T23:22:20Z | Judy | — | Schmidt | Feb 5, 2002 | - | - | 16373923645 | null | 4339 Park Pl Apt 12 | Tempe | Arizona | 85233-0763 | NULL | null |
| PRV | PRV-22521 | 2026-10-02T14:06:41Z | Alan | O | Howell | ·1999-05-27 | — | — | (798) 251-0452 | — | 8558 VALLEY VIEW DRIVE | Tucson | Arizona | 85736 | null | UNKNOWN |
| PRV | PRV-20543 | 2026-08-04T18:16:36Z | teresa | — | chavez | 1953-05-09 | UHC3653542 | — | +1 436 212 4413 | TERESA.CHAVEZ@AOL.COM | 1648 Valley View Drive | Eden Prairie | MN | 55343 | NULL·· | null |
| PRV | PRV-28419 | 2026-07-31T10:04:09Z | patricia | S. | davis | 01/17/02 | ·· | N/A | 614-605-2699 | — | 5868 OAK ST | Plano | TX | 75095 | N/A | — |
| PRV | PRV-21887 | 2026-02-28T18:02:58Z | SOPHIA | H | MRQUEZ | 01-09-1986 | UHC-21684-62 | — | - | sophia.marquez@yahoo.com | 6786 MEADOW LN | Fresno | CA | 93755 | - | — |
| PRV | PRV-22655 | 2026-03-23T09:14:10Z | diane | — | sanders | Apr 9, 2003 | UHC-96847-82 | — | +1 778 626 7217 | — | 2151 MESA DRIVE | Miami | FL | 33164 | ·· | — |
| PRV | PRV-22094 | 2026-04-06T13:01:02Z | Charles | ·· | Richards | 1999-10-04 | UHC-80345-16 | — | (319) 333-2198 | — | 7872 Hillcrest Road | San Antonio | TX | 78201-2157 | ···· | — |
| PRV | PRV-23610 | 2026-10-06T08:00:39Z | Angela | — | Kennedy | 1978-03-17 | UHC-27371-43 | - | 666.774.5792 | NULL | 7826 Elm St | Austin | TX | 78725 | null | NULL·· |
| PRV | PRV-22213 | 2026-04-18T14:30:55Z | Camila·· | — | Sandoval | 9172-06-25 | ·· | ·N/A | 615-386-1685 | CAMILA.SANDOVAL@YAHOO.COM | 7717 OCEAN AVE | Jacksonville | FL | 32220 | — | null |
| PRV | PRV-22834 | 2026-06-14T11:11:22Z | Willie | X | Reed | 02-02-2000 | UHC-69931-09·· | — | 9466321803 | NULL | ·· | - | N/A | - | NULL | — |
| PRV | PRV-21971 | 2026-01-23T16:17:22Z | Karen | — | Brown | 1946-06-08·· | ·null | null | 544-558-7670 | NULL | 1462 River Rd | Tucson | AZ | 85765 | null | UNKNOWN |
| PRV | PRV-20759 | 2026-09-23T01:06:48Z | AMY | — | MONTGOMERY | 1969-05-19 | null | — | 19546973499·· | — | 375 MESA DR | Phoenix | AZ | N/A | N/A | N/A |
| PRV | PRV-25836 | 2026-03-09T00:53:43Z | BEVERLY | — | LYNCH | 1991-04-16 | N/A | — | — | - | 7879 Washington Street | Sacramento | CA | 95867 | null | — |
| PRV | PRV-29038 | 2026-09-26T12:55:41Z | Jessica | — | ·Alvarez | Mar 27, 1950 | UNKNOWN | N/A | ·17407250663 | jessica.alvarez42@yahoo.com·· | 976 Sunset Blvd | Gilbert | az | 85218-4016 | N/A | - |
| PRV | PRV-27450 | 2026-03-25T10:19:23Z | Gloria | — | Clark | 27-08-1976 | UHC-28114-30 | UNKNOWN | 7976787660 | — | 5774 INDIAN SCHOOL RD | Sacramento | CA | 95882-0243 | - | — |
| PRV | PRV-28683 | 2026-05-18T04:38:19Z | KEVIN | — | BURTON | ·28-02-1974 | ·uhc-40231-03 | N/A | (884) 608-1503 | - | 6383 Mountain View Dr | Gilbert | AZ | 85246 | null | — |
| PRV | PRV-28933 | 2026-02-02T04:35:17Z | JUSTIN | H | FOWLER | 1981-12-21 | UHC-57350-28 | N/A | — | JUSTIN.FOWLER84@YAHOO.COM | 9821 SAGE COURT | Phoenix | AZ | 85081 | null·· | - |
| PRV | PRV-24715 | 2026-08-09T05:17:07Z | timothy | — | robertson | Jan 6, 1952 | UHC-04478-97 | - | 424-951-5029 | - | 2331 VALLEY VIEW DRIVE | ·Orlando | Florida | 32820 | — | NULL |
| PRV | PRV-23206 | 2026-05-02T04:24:55Z | ·James | — | Harris | 1952-02-13 | UHC-25858-43 | N/A | (540) 783-5550 | — | 2668 Union St | Sacramento | CA | 95869 | null | null |
| PRV | PRV-21143 | 2026-07-28T23:31:44Z | Bobby | — | Waang | 1951-08-03 | NULL | - | 238-665-0626 | — | 167 Harbor Blvd | SACRAMENTO | CA | 95888 | — | — |
| PRV | PRV-27022 | 2026-01-16T20:02:02Z | Justin | — | Ryan | 1975-11-04 | — | — | 12153826228 | justin.ryan@proton.me | 1898 Camelback Road | Plano | TX | — | - | MEDICARE-ADV-A |
| PRV | PRV-20810 | 2026-04-18T15:16:17Z | Gerald P | — | Li | 1954-12-24 | UNKNOWN | null | (791) 321-3625 | NULL | 7477 River Road | Jacksonville | FL | — | ·null | null |
| PRV | PRV-23809 | 2026-01-12T23:22:28Z | ·Ronald | — | Daniels | 1943-03-18 | UHC-95529-06 | - | 630-457-4545 | UNKNOWN | 2498 OAK ST | Plano | ·TX | 75033 | NULL | — |
| PRV | PRV-27050 | 2026-02-24T20:00:44Z | Ryan | — | Myers | 06/28/51 | UHC-22890-68 | - | 5225174293 | - | 3563 River Rd Apt 30 | ·Plano | TX | 75031 | ·· | ·· |
| PRV | PRV-20715 | 2026-07-28T01:57:36Z | ETHAN | ···· | HUGHES | 1959-03-09 | — | — | 458-370-1146 | null | 3985 Palm Drive | Tucson | AZ | 85755 | ·· | UNKNOWN |
| PRV | PRV-27746 | 2026-09-17T09:47:14Z | Robert | A | Jrodan | 1969-07-05 | UNKNOWN | NULL | ·372-340-8224 | null | 8316 Mesa Dr | FRESNO | CA | 93714 | N/A | OPTIONS-PPO |
| PRV | PRV-29000 | 2026-04-10T04:44:03Z | Edwards, Brandon | J | — | 1948-04-23 | UHC-65049-62 | — | null | NULL | 3531 Church Street·· | Sacramento | CA | 95850-4614 | - | ·NULL |
| PRV | PRV-25837 | 2026-03-26T12:47:17Z | Chrs | — | Morgan | 01-09-2007 | NULL | — | (398) 867-9277 | UNKNOWN | 469 PINE DR | Austin | TX | 78759 | UNKNOWN | N/A |
| PRV | PRV-20495 | 2026-05-20T12:20:22Z | MARTHA | ·· | SIMMONS | 2002-02-09 | NULL | UNKNOWN | - | UNKNOWN·· | 1191 Park Place | Atlanta | GA | 30306 | - | null |
| PRV | PRV-27476 | 2026-03-24T02:09:36Z | ARTHUR | — | WASHINGTON | 2000-07-27 | UHC-09983-59 | — | null | - | 7566 Willow Ct | Gilbert | az | ·85294 | ·NULL | - |
| PRV | PRV-27465 | 2026-07-14T19:01:27Z | Lucia | — | Williams | 1996-04-13 | null | NULL | ···· | lucia.williams86@hotmail.com | 7236 Central Avenue | SAN ANTONIO | Texas | 78247 | NULL | N/A |
| PRV | PRV-26500 | 2026-10-14T14:29:45Z | Saara | — | Williams | Nov 20, 1983 | — | — | 3034258929 | NULL | 5208 Sunset Blvd | Chandler | AZ | 85252 | — | null |
| PRV | PRV-23049 | 2026-04-18T11:00:19Z | ronald | — | dominguuez | 1989-05-26 | UHC-96584-75 | •••-••-8755 | N/A | RONALD.DOMINGUEZ@AOL.COM | null | — | NULL | — | UNKNOWN | — |
| PRV | PRV-21200 | 2026-07-13T13:04:54Z | JULIA | — | HUNT | 1965-02-23 | — | •••-••-6102 | UNKNOWN | null | 9025 Cedar Ln | Seattle | ·WA | 98161 | UNKNOWN·· | — |
| PRV | PRV-23568 | 2026-10-04T07:33:58Z | Harold | U. | Rogers | 2005-10-51 | UHC-54307-35 | ·UNKNOWN | 466-651-8737 | harold.rogers@proton.me | 955 LAKE VIEW ROAD | Eden Prairie | MN | 55301 | - | null |
| PRV | PRV-21612 | 2026-09-06T15:33:31Z | Gabriel | P. | Salazar | 02/04/43 | — | NULL | 2378144343 | ···· | null | - | null·· | null | — | N/A |
| PRV | PRV-26133 | 2026-01-21T10:56:48Z | Pamela | ·X | Rodriguez | Nov 7, 1996·· | UHC6391360 | — | 461.680.4801 | pamela.rodriguez35@proton.me | 1749 Hillcrest Road | Fresno | CA | 93795 | null | UNKNOWN |
| PRV | PRV-26055 | 2026-01-18T07:52:17Z | gloria | — | tran | 19450504 | — | — | 5176778499 | — | 403 LAKE VIEW ROAD | Tampa | FL | 33674 | — | - |
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:36.698Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty