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
Third-party administrator only, ordered by line number
| Source | Record | Received | First | Middle | Last | DOB | Member ID | SSN | Phone | Address | City | State | ZIP | Group | Plan | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TPA | TPA-56351 | 2026-07-11T06:24:18Z | KAYLA | — | KELLEY | 1951-11-09 | — | N/A | 5756694771 | — | NULL | — | — | N/A·· | GRP-8727 | ·MEDICARE-ADV-A |
| TPA | TPA-51462 | 2026-08-20T01:35:15Z | Christine | — | Ruzi | 1967-08-16·· | ·· | - | 255-784-4055 | N/A | 3332 Willow Ct | ·LAS VEGAS | NV | 89104 | - | — |
| TPA | TPA-55299 | 2026-03-08T00:12:55Z | ·Heather | — | Lynch·· | 05/07/61 | UNKNOWN·· | — | N/A | null | 8994 Broadway | Fresno | CA | 93786 | NULL | OPTIONS-PPO |
| TPA | TPA-51393 | 2026-07-13T12:19:45Z | MICHAEL | S | CAMPBELL | 0095-20-05 | N/A | UNKNOWN | — | null | 1057 MAPLE AVE | ·AUSTIN | TX | 78731 | GRP-6985 | — |
| TPA | TPA-59852 | 2026-04-09T14:00:36Z | FRANK | — | FERNANDEZ | 1960-04-04 | UHC-46561-13 | NULL | UNKNOWN | - | 6763 MESA DR | Glendale | AZ | 85323 | GRP-4395 | SELECT-EPO |
| TPA | TPA-52141 | 2026-05-13T04:34:00Z | Henry, Diana | ·· | — | 1951-02-61 | — | •••-••-6673 | UNKNOWN | UNKNOWN·· | 9167 Camelback Rd | Eden Prairie | mn | UNKNOWN | — | null |
| TPA | TPA-55939 | 2026-09-18T08:27:11Z | evelyn | — | moore | 1951-12-15 | — | null | 514-561-4453 | - | 3953 Baseline Rd | Charlotte | NC | 28290 | NULL | — |
| TPA | TPA-51838 | 2026-07-02T23:43:47Z | Nathan | — | Padilla·· | 12/21/1945 | N/A | N/A | 287-350-2135 | null | - | ···· | — | null·· | NULL·· | null |
| TPA | TPA-55986 | 2026-05-10T21:15:33Z | Suphia | — | Hill | Aug 12, 1975 | UHC-72031-89·· | UNKNOWN | 2908416465 | — | 4128 Spring Street | Denver | CO | 80218 | N/A | N/A |
| TPA | TPA-50648 | 2026-01-25T19:48:56Z | sofia | — | chen | 1996-09-25 | ·- | — | — | — | 7943 Washington Street Apt 15 | Phoenix | AZ | 85006 | NULL | — |
| TPA | TPA-52874 | 2026-06-28T13:15:53Z | Allbert | — | Banks | 1998-02-12 | NULL | •••-••-4071 | 8845781258 | albert.banks@icloud.com | 4654 Lake View Road | San Diego | CA | 92144 | UNKNOWN | NULL |
| TPA | TPA-55617 | 2026-06-16T15:45:56Z | Emily | — | Murray | 1992-02-20 | UHC-96474-99 | •••-••-9919 | ···· | NULL | 8357 Spring Street #750 | ·CHARLOTTE | NC | 28293 | — | CORE-HMO |
| TPA | TPA-55314 | 2026-01-31T18:14:05Z | Martha | — | Cole | 1964-12-06 | — | — | - | N/A | 7007 Central Avenue | GILBERT | AZ | 85258 | GRP-4006 | OPTIONS-PPO |
| TPA | TPA-62404 | 2026-05-07T21:57:13Z | Kayla | — | Jensen | 1992-05-06 | — | — | 6499027116 | ·N/A | N/A | N/A | — | - | ·GRP-3697 | OPTIONS-PPO |
| TPA | TPA-63030 | 2026-09-08T13:58:03Z | Garcia, Christina | — | — | 1969-02-11 | — | NULL | 4336748812 | null | N/A | — | — | — | GRP-0690 | N/A |
| TPA | TPA-53871 | 2026-08-15T08:50:41Z | Jonathan | V. | Watson | 1953-07-23 | null | ·- | 464.426.9775 | — | — | UNKNOWN | — | — | GRP-9353 | - |
| TPA | TPA-57409 | 2026-05-13T23:04:28Z | peter | — | gray | 08/23/85 | - | null | - | - | 876 SPRING STREET | Los Angeles | CA | 90015 | UNKNOWN | — |
| TPA | TPA-59302 | 2026-07-22T05:43:15Z | Riley, Dorothy | — | — | 1986-06-31 | — | — | +1 855 926 4082 | DOROTHY.RILEY45@GMAIL.COM | NULL | N/A·· | — | UNKNOWN | NULL | NAVIGATE-HMO |
| TPA | TPA-51381 | 2026-03-19T08:48:09Z | JANET | — | JENKINS | 1976-05-08 | null·· | UNKNOWN | 979-486-7603 | N/A | 5208 MAIN STREET | PHOENIX | AZ | 85004-5527 | - | — |
| TPA | TPA-59290 | 2026-02-15T13:51:52Z | Riley, Denise | — | — | 08/11/90 | - | •••-••-6651 | null | - | ·4126 BAYSHORE DRIVE | ·Minneapolis | MN | 55435 | GRP-6760 | — |
| TPA | TPA-63356 | 2026-07-22T10:06:01Z | ·Maria | — | Reeed | 3/19/1944 | UHC-26909-68 | N/A | — | — | 7228 Ridge Road | JACKSONVILLE | ·FL | 32257 | - | MEDICARE-ADV-A |
| TPA | TPA-55754 | 2026-05-02T10:52:25Z | Charlotte | — | Payne | 1980-02-28 | UHC-82916-23 | — | — | — | 421 Main Street | Tampa | FL | 33669 | NULL | N/A |
| TPA | TPA-54782 | 2026-02-27T00:03:54Z | DORIS | — | ADAMS | 06/12/84 | — | •••-••-6329 | (574) 450-2759·· | NULL | 1221 Harbor Blvd | Chandler | Arizona | 85270 | UNKNOWN | NULL |
| TPA | TPA-51388 | 2026-04-12T14:22:23Z | ALICE | T | BLACK | 07-05-1953 | N/A | UNKNOWN | 357-954-3916 | null | — | — | UNKNOWN | — | GRP-9309 | MEDICARE-ADV-B |
| TPA | TPA-54813 | 2026-08-09T10:37:15Z | Haannah | — | Sandoval | 2000-09-08 | null | NULL | — | — | 9114 Grand Avenue | Tucson | AZ | 85739 | GRP-6581 | null |
| TPA | TPA-64253 | 2026-07-05T04:54:00Z | Myers, David | — | ···· | 1999-02-24 | UHC-12504-38 | •••-••-8611 | 15834592995 | NULL | 6706 MAPLE AVE | GLENDALE | ·Arizona | 85371 | GRP-2424 | — |
| TPA | TPA-59203 | 2026-05-02T13:25:57Z | Tom | — | Bnks | 1970-05-19 | null | •••-••-9572 | NULL | — | 707 Meadow Lane | San Antonio | tx | ·78210 | GRP-9439 | null |
| TPA | TPA-53874 | 2026-05-09T19:31:13Z | Gloria | V | King | 1/14/1974 | - | UNKNOWN | 512-292-0811·· | — | 9840 Spring Street | ·Houston | TX | 77055 | null·· | ···· |
| TPA | TPA-61145 | 2026-05-02T19:08:26Z | Diiana | ·· | Medina | 1960-04-04 | — | •••-••-4104 | ·N/A | — | - | ·- | null | — | — | — |
| TPA | TPA-64021 | 2026-10-03T00:06:14Z | Kyle | — | Oliver | 12/19/1974 | — | NULL | ···· | — | 16 MESA DRIVE | Minneapolis | MN | 55428 | — | - |
| TPA | TPA-53650 | 2026-06-09T07:21:50Z | Kelly | — | Alvarado | 1957-08-04 | NULL | — | — | — | 431 Lake View Rd | San Diego | ·CA | 92144 | N/A | — |
| TPA | TPA-57811 | 2026-09-17T19:37:54Z | George | ···· | Perez | 24-01-1969 | UNKNOWN·· | N/A | 946.922.6873 | UNKNOWN | 8873 Indian School Rd | LAS VEGAS | NV·· | 89190 | — | NULL |
| TPA | TPA-63406 | 2026-05-27T00:17:14Z | Donna | — | Lawson | 1973-12-08 | — | - | — | — | 112 GRAND AVE | Phoenix | AZ | 85030-0895 | ·· | UNKNOWN |
| TPA | TPA-62417 | 2026-01-21T22:44:24Z | steven | — | cole·· | 1982-09-07 | - | null | 8198040252 | steven.cole@hotmail.com | 5310 Sunset Boulevard Apt 36 | Glendale | Arizona | N/A | N/A | NULL |
| TPA | TPA-64131 | 2026-02-10T15:27:01Z | Mateo I | — | Sims | 1981-03-12 | UNKNOWN·· | N/A | — | — | NULL | ···· | NULL | N/A | GRP-1147 | - |
| TPA | TPA-59562 | 2026-04-16T04:34:41Z | ·CHARLOTTE | ·P | HAYES | 10/15/1991 | UNKNOWN | •••-••-1555 | - | — | 7221 BAYSHORE DR | Los Angeles·· | CA | ·90097 | null | null |
| TPA | TPA-50520 | 2026-08-26T02:54:02Z | Katherine | — | Carpenter | 1949-04-23 | — | •••-••-3349 | +1 670 683 9429 | — | 4824 Lake View Rd | Plano | TX | 75046-9817 | GRP-3317 | — |
| TPA | TPA-64184 | 2026-04-09T15:50:37Z | MELISSA | — | FOX·· | 10/28/1979 | UNKNOWN | N/A | 332-636-3708 | N/A | 7882 Baseline Rd Apt 33·· | Atlanta | GA | 30393 | - | — |
| TPA | TPA-54257 | 2026-03-15T05:14:46Z | Charoltte·· | — | Parker | 07-09-1998 | — | — | — | — | null | null | ···· | - | NULL | — |
| TPA | TPA-59296 | 2026-06-01T08:59:30Z | Brandon | M. | Aguilar | 1950-12-15 | - | — | N/A | ·BRANDON.AGUILAR1@AOL.COM | 7796 Maple Ave | Tucson | AZ | 85743 | - | NULL |
| TPA | TPA-59473 | 2026-06-17T13:51:36Z | Nathan | — | Martinez | 1944-04-01 | N/A | — | 949-444-3956 | — | 2561 Bayshore Dr | NASHVILLE | Tennessee | 37207 | ·- | — |
| TPA | TPA-59110 | 2026-03-24T01:47:44Z | BRYAN | — | GRAHAM | 9/4/1999 | -·· | •••-••-5197 | 17656448229 | UNKNOWN·· | — | NULL | null | — | ·NULL | — |
| TPA | TPA-57625 | 2026-06-24T15:22:58Z | adam | — | dunn | 2005-09-13 | — | •••-••-3699 | 9466266907 | ADAM.DUNN@PROTON.ME | 232 Lincoln Way | Atlanta | ·GA | 30366 | GRP-9344 | MEDICARE-ADV-B |
| TPA | TPA-59346 | 2026-04-21T18:23:42Z | Phillips, Amanda | — | — | 07/18/87 | UHC-49815-50 | ·· | NULL | AMANDA.PHILLIPS@HOTMAIL.COM | - | UNKNOWN | UNKNOWN | null | - | core-hmo |
| TPA | TPA-63234 | 2026-07-03T23:51:07Z | ·Scott, Jessica | — | — | 1971-03-12 | N/A | null | 224-730-1960 | jessica.scott@hotmail.com | 2188 Hillcrest Road | GILBERT | Arizona | 85274 | NULL | — |
| TPA | TPA-52283 | 2026-05-25T08:59:07Z | Katherine | — | Lucas·· | Jul 16, 2000 | — | ·- | — | null | — | - | — | — | UNKNOWN | SELECT-EPO |
| TPA | TPA-54256 | 2026-08-26T04:02:59Z | CHARLOTTE | ···· | PARKER | 1998-09-07 | - | — | — | charlotte.parker@icloud.com | N/A | NULL | — | — | GRP-5379 | UNKNOWN |
| TPA | TPA-61576 | 2026-06-27T06:06:44Z | Gibson, Abigail | ·· | — | 1947-09-22 | — | — | — | ·· | 8715 Mesa Drive | Dallas | TX | 75239 | ·GRP-6129 | — |
| TPA | TPA-60674 | 2026-07-22T12:39:51Z | Joshua | ···· | Fisher | 1995-07-05 | null | — | null | — | ·4253 Meadow Lane | Los Angeles | CA | 90016 | - | NULL |
| TPA | TPA-63120 | 2026-07-24T04:49:49Z | ROBERT | — | BROOKS | 02/24/1999 | UNKNOWN | •••-••-6367 | (580) 559-5575 | robert.brooks33@hotmail.com | 5314 PALM DRIVE | Fresno | CA | ·· | N/A | CHOICE-PLUS-PPO |
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.720Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty