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-56584 | 2026-01-04T03:12:14Z | Alice | — | Peters | 1997-11-27 | — | - | — | NULL | 8453 APACHE BLVD | Plano | TX | 75040 | - | NULL |
| TPA | TPA-51124 | 2026-01-16T16:38:31Z | Donna | — | Torres | 11-10-1981 | NULL·· | N/A | UNKNOWN | N/A | NULL | UNKNOWN·· | null | — | - | CHOICE-PLUS-PPO |
| TPA | TPA-64366 | 2026-06-17T17:06:18Z | Mark | — | Vazquez | Sep 24, 1989·· | UHC-24042-15 | N/A | - | UNKNOWN | 1533 Mesa Dr | Atlanta | GA | 30358 | ·GRP-6555 | — |
| TPA | TPA-62215 | 2026-05-12T23:59:37Z | steve | E. | cole | 1970-03-07 | — | NULL | +1 296 518 9340 | — | 8077 Willow Ct | ·Tempe | AZ | 85258 | GRP-6033 | — |
| TPA | TPA-57845 | 2026-01-02T11:57:22Z | Walter | — | Chavez | 1994-05-07 | - | null | - | walter.chavez96@icloud.com | 7980 Maple Avenue | Austin | tx | 78761 | GRP-5337 | - |
| TPA | TPA-56413 | 2026-06-10T09:39:43Z | Charles | — | Hanson | 10-07-1948 | — | — | 678-766-5084 | — | ·4807 Maple Ave | Tempe | az | 85267 | — | — |
| TPA | TPA-64172 | 2026-04-26T03:41:45Z | ·Jesse | — | Coleman | ·Feb 4, 1983 | — | UNKNOWN | null | UNKNOWN | NULL | N/A | — | N/A | N/A | ···· |
| TPA | TPA-58633 | 2026-02-26T18:29:39Z | Dylan | — | Robinson | 07/15/07 | ·NULL | UNKNOWN | N/A | null | 3396 Maple Avenue | Orlando | FL | 32819-3487 | ·GRP-0634 | — |
| TPA | TPA-62723 | 2026-06-03T00:48:14Z | Isabella | — | Hall | 1948-03-05 | UNKNOWN | null | 12195570261 | — | 9712 WASHINGTON ST | Houston | Texas | 77040-8480 | UNKNOWN | — |
| TPA | TPA-64238 | 2026-08-27T06:23:34Z | Webb, Larry | ·· | — | 2004-10-23 | N/A | NULL | NULL | — | 6503 Church Street | Orlando | FL | null | NULL | — |
| TPA | TPA-59119 | 2026-04-23T05:00:42Z | JORDAN | ···· | LI | 2004-01-13 | N/A | — | null | ·· | 6736 Mesa Drive | Orlando | FL | 32894-9218 | null | - |
| TPA | TPA-54698 | 2026-05-13T20:16:10Z | Evelyn | M | Williams | 2007-09-27 | NULL | ·· | — | ···· | 8149 BAYSHORE DRIVE | TEMPE | AZ | 85270 | UNKNOWN | — |
| TPA | TPA-50540 | 2026-08-11T10:09:45Z | PAMELA | — | GARRETT | 1944-12-07 | UNKNOWN | - | +1 961 404 6705 | PAMELA.GARRETT@HOTMAIL.COM | 9254 Grand Avenue | Chandler | az | 85265 | UNKNOWN | ·NAVIGATE-HMO |
| TPA | TPA-62145 | 2026-06-05T19:33:10Z | Ruth | — | Flores | 1999-02-18 | NULL | NULL | — | — | 7256 Valley View Dr | GILBERT | AZ | 85292 | N/A | null |
| TPA | TPA-61181 | 2026-07-31T05:41:15Z | BENJAMIN | — | STONE·· | 28-11-1986 | UHC-33045-31 | •••-••-1600 | — | — | 8811 Palm Drive | Tampa | FL·· | 33645 | N/A | — |
| TPA | TPA-53636 | 2026-05-25T13:54:28Z | Elizabeth | — | Ramirez | 2003-01-11 | — | null | NULL | elizabeth.ramirez@hotmail.com | 2787 INDIAN SCHOOL RD | AUSTIN | TX | 78741 | GRP-6176 | null |
| TPA | TPA-51409 | 2026-05-21T12:26:51Z | ·Eugene | — | Henderson | Jan 23, 1938 | UHC-97281-64 | N/A | — | UNKNOWN | 3955 CHURCH ST | Sacramento | CA·· | 95861-9920 | NULL | SELECT-EPO |
| TPA | TPA-56527 | 2026-06-24T11:00:11Z | Kathryn | — | Hall | ·1978-10-11 | — | — | - | ·null | NULL·· | null | null | — | GRP-9206 | SELECT-EPO |
| TPA | TPA-56614 | 2026-06-06T17:32:11Z | Christopher·· | ·· | Fuller | 19470527 | NULL | — | (912) 852-0357 | - | 7758 RIVER RD | EDEN PRAIRIE | MN | 55395 | null | — |
| TPA | TPA-64030 | 2026-02-02T14:05:41Z | Camila | F | Fuller | 1989-01-15 | - | — | 6003770152 | camila.fuller@hotmail.com | 5726 Church St | Sacramento | CA | 95831 | GRP-3601 | OPTIONS-PPO |
| TPA | TPA-54860 | 2026-05-11T21:00:09Z | Jacob | — | Phillips | 1996-11-10 | — | null | 539-645-5044 | - | — | — | NULL | - | — | UNKNOWN |
| TPA | TPA-58797 | 2026-05-10T07:30:00Z | Mateo | O | Hansen | 1996-01-23 | UHC-39094-52·· | - | N/A | N/A | 1668 JEFFERSON AVE | Chandler | AZ | 85243 | GRP-9170 | OPTIONS-PPO |
| TPA | TPA-50681 | 2026-02-28T01:39:37Z | Jesse | T | Jordan | 10/10/1968 | - | -·· | (775) 339-1645 | null | 9252 Indian School Road | Austin | TX | N/A | NULL | - |
| TPA | TPA-50284 | 2026-03-31T13:31:55Z | Sarah | — | Howell | 19660527 | - | — | (237) 355-0725 | — | 320 Main St | AUSTIN | Texas | ·UNKNOWN | — | CHOICE-PLUS-PPO |
| TPA | TPA-57025 | 2026-05-24T11:00:46Z | Brenda | — | Harper | 5/15/1940 | NULL | N/A | — | — | 7291 OCEAN AVENUE | Mesa | AZ | 85254 | GRP-9830 | ···· |
| TPA | TPA-51373 | 2026-07-28T12:49:39Z | BRENDA | — | ESTRADA | 12/15/63 | — | — | ·- | null | 8397 Canyon Road | Tucson·· | AZ | 85738 | — | — |
| TPA | TPA-62680 | 2026-09-10T15:36:50Z | JOE·· | — | PERRY·· | 1940-12-09 | - | •••-••-9224 | NULL | joe.perry@icloud.com | 4480 Willow Court | Denver | CO | UNKNOWN | N/A | SELECT-EPO |
| TPA | TPA-59778 | 2026-03-08T09:48:39Z | Mark | — | Payne | 1972-10-19 | — | - | null | N/A | N/A | ·- | — | N/A | ·· | — |
| TPA | TPA-62561 | 2026-02-27T00:57:00Z | Ashley | — | Hill | 1960-06-11 | — | — | — | — | 3073 Jefferson Avenue | PHOENIX | AZ | 85000 | UNKNOWN·· | — |
| TPA | TPA-61899 | 2026-04-09T05:59:41Z | Hunter, Juan | N | — | ·1965-09-22 | — | •••-••-6245 | 618-773-4842·· | NULL | 5057 Valley View Dr | Chandler | Arizona·· | 85249 | UNKNOWN | - |
| TPA | TPA-63373 | 2026-10-14T15:28:33Z | patrick | — | robinson | 1971-12-01 | — | UNKNOWN | — | UNKNOWN | 1715 RIDGE ROAD | ·Denver | Colorado | 80231 | GRP-8423 | — |
| TPA | TPA-57899 | 2026-04-14T06:24:41Z | THOMAS | — | HAMILTON | 1948-05-17 | null | NULL | — | THOMAS.HAMILTON@HOTMAIL.COM | 3945 MARKET ST | Glendale | AZ | 85374 | GRP-1083 | CHOICE-PLUS-PPO·· |
| TPA | TPA-57570 | 2026-04-15T12:53:29Z | Joyce | — | ·Ramirez | 2007-06-07 | — | - | NULL | null | N/A | UNKNOWN | - | ·· | — | ···· |
| TPA | TPA-59424 | 2026-02-26T02:10:31Z | — | — | — | 1965-06-27 | — | NULL | 18943771501 | N/A | 9031 Jefferson Ave | AUSTIN | TX·· | NULL | N/A | - |
| TPA | TPA-52307 | 2026-09-11T04:42:11Z | Dylan | — | Hill | 1962-01-21 | N/A·· | - | — | NULL | 5307 Valley View Drive | Charlotte | NC | — | NULL·· | CHOICE-PLUS-PPO |
| TPA | TPA-51335 | 2026-08-03T09:32:50Z | Sean | — | Howard | 2003-03-02 | N/A | — | (796) 565-0732·· | UNKNOWN | 1024 Lincoln Way | GILBERT | AZ | 85274-9939 | - | CHOICE-PLUS-PPO |
| TPA | TPA-57357 | 2026-05-31T02:42:33Z | Kelly | — | Espinoza | 1999-11-27 | null | — | ·· | - | 2936 Canyon Road·· | SACRAMENTO | CA | 95858 | ·null | - |
| TPA | TPA-56317 | 2026-05-17T11:20:55Z | ·Don | — | Dixon | 02/22/1950 | UNKNOWN | •••-••-0717 | null | — | 2856 Union St | Glendale | AZ | 85376 | null | OPTIONS-PPO |
| TPA | TPA-57476 | 2026-06-08T16:21:32Z | Elijah | — | Richardson | 19510402 | — | — | UNKNOWN | null | 3875 Park Pl | ORLANDO·· | FL | 32864 | N/A | SELECT-EPO |
| TPA | TPA-55728 | 2026-08-05T23:17:04Z | Julia | — | Jackson | 19580916 | UNKNOWN | - | NULL | julia.jackson62@outlook.com | — | UNKNOWN·· | ·- | UNKNOWN | N/A | CHOICE-PLUS-PPO |
| TPA | TPA-55346 | 2026-10-01T22:42:37Z | Jeffrey | — | Shaw | 1971-09-20 | UHC-23558-85 | ·· | N/A | jeffrey.shaw94@icloud.com | — | ···· | ···· | ·· | — | N/A |
| TPA | TPA-55626 | 2026-03-19T07:08:12Z | brittany | — | hernandez | 1972-01-22 | null | •••-••-2258 | 3471351·· | - | UNKNOWN | — | - | null | ·· | - |
| TPA | TPA-52767 | 2026-09-11T22:57:27Z | TYLER | — | GUTIERREZ | 4/1/1971 | UNKNOWN | •••-••-4139 | (761) 901-9746 | N/A | 2641 Lincoln Way | San Antonio | TX | 78299 | GRP-2107 | NAVIGATE-HMO |
| TPA | TPA-59888 | 2026-02-09T19:32:07Z | ·Brittany | — | Wong | 1978-04-20 | UNKNOWN | •••-••-1592 | null | NULL | 1666 Mountain View Drive | Los Angeles | California | 90096 | UNKNOWN | CHOICE-PLUS-PPO |
| TPA | TPA-55955 | 2026-04-21T10:16:58Z | ashley | A | arnold | 12/17/1960 | null | •••-••-6499 | — | — | 5208 Baseline Rd | Sacramento | CA | - | N/A | — |
| TPA | TPA-55276 | 2026-09-07T23:14:08Z | JOSE | — | WANG | 02/03/1988 | N/A | — | null | ·jose.wang@gmail.com | 3956 INDIAN SCHOOL RD | Atlanta | GA | 30308-7534 | — | — |
| TPA | TPA-60319 | 2026-06-15T20:04:33Z | MARIA | X | COLEMAN | 5/6/1984 | — | N/A | N/A | NULL | 2369 BROADWAY | Houston | Texas | 77031 | GRP-4039 | — |
| TPA | TPA-60339 | 2026-05-05T16:42:18Z | SAMUEL | G | RAMIREZ | 2001-06-06 | NULL | ·UNKNOWN | ·null | - | 8485 BROADWAY | Tampa | FL | 33696 | — | — |
| TPA | TPA-57954 | 2026-04-23T09:09:00Z | ana | — | grant | ·19790623 | — | UNKNOWN | — | — | 9741 OAK ST | MINNEAPOLIS | MN | 55447 | UNKNOWN | MEDICARE-ADV-B |
| TPA | TPA-52340 | 2026-04-09T04:58:03Z | Joseph | — | Kennedy | Jun 9, 1946 | — | •••-••-5370 | N/A | joseph.kennedy@outlook.com | 522 VALLEY VIEW DRIVE | Fresno | CA | ·93708 | — | — |
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:53.126Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty