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-62880 | 2026-09-08T02:56:54Z | Mei | D | ·Griffin | 1994-03-17 | NULL | NULL | - | mei.griffin@aol.com | 9170 Union St | Tucson | AZ | — | ·· | UNKNOWN |
| TPA | TPA-51741 | 2026-06-28T07:31:23Z | KATE | ·· | DEAN | 1958-12-09 | — | •••-••-1698 | 504-541-2694 | UNKNOWN | 2022 Canyon Rd | Denver | Colorado | 80279-5830 | GRP-3945 | — |
| TPA | TPA-53902 | 2026-07-12T21:03:40Z | ·Brandon | — | Jacobs | 08/05/55 | — | UNKNOWN | NULL·· | - | 9500 GRAND AVE·· | Orlando | FL | 32825 | null | MEDICARE-ADV-A |
| TPA | TPA-51246 | 2026-08-23T03:45:37Z | roy·· | — | tucker | 1946-01-17 | UHC-34706-33 | NULL | — | — | ·7341 Oak Street | ATLANTA | GA | 30300 | null | OPTIONS-PPO |
| TPA | TPA-59703 | 2026-01-16T18:04:01Z | Kelly, Isabella | — | — | 1959-02-25 | UHC-28896-64 | •••-••-7625 | 5933422 | - | 2733 Sunset Boulevard | Dallas | TX | 75215 | null | — |
| TPA | TPA-50368 | 2026-08-26T17:38:29Z | SOFIA | — | CHAVEZ | 1996-12-23 | — | •••-••-1325 | (481) 667-2397 | null·· | 3709 SUNSET BOULEVARD | Los Angeles | CA·· | 90067 | — | UNKNOWN |
| TPA | TPA-54478 | 2026-03-16T05:46:09Z | ZACHARY | K.·· | LONG | 1957-09-19 | N/A | UNKNOWN | NULL | — | 8115 Spring St | Tempe | Arizona | 85267 | ·N/A | OPTIONS-PPO·· |
| TPA | TPA-55718 | 2026-05-11T01:35:54Z | Jean | — | Graham | 1961-08-15 | - | — | 12056761681 | — | 1653 Ridge Road | Tampa | FL | 33658-5311 | GRP-6270 | ·· |
| TPA | TPA-64344 | 2026-03-08T11:08:37Z | ana | — | murphhy | 1949-09-21 | UNKNOWN | NULL | null | — | 2678 BAYSHORE DRIVE | ·Tempe | AZ | ·85265 | - | null |
| TPA | TPA-58967 | 2026-03-26T00:59:54Z | AISHA | B | COOPER | 19620306 | N/A | NULL | UNKNOWN | null·· | 7175 Broadway·· | Denver | Colorado | 80200·· | GRP-1998 | - |
| TPA | TPA-64385 | 2026-02-01T17:47:47Z | DENISE | ·· | ·SULLIVAN | 1965-08-05 | — | N/A | +1 837 794 4492 | null | 7428 LINCOLN WAY | Chandler | Arizona | ·85272 | GRP-9731 | NULL |
| TPA | TPA-51363 | 2026-06-21T16:16:38Z | Stephens, Joe | — | — | 19750311 | - | •••-••-8994 | 3118285793 | N/A | 302 Church St | Columbus | Ohio | 43237 | NULL | — |
| TPA | TPA-57683 | 2026-04-04T09:42:26Z | Evelyn | ···· | Jensen | 2005-05-28 | UHC-72278-72 | •••-••-4712 | null | N/A | 9886 SAGE COURT | Phoenix | AZ | 85052 | - | — |
| TPA | TPA-53314 | 2026-07-28T14:11:10Z | JACK | — | HERNANDEZ | 1955-12-04 | - | •••-••-3008 | — | UNKNOWN | 916 Indian School Rd | Columbus | ·OH | - | NULL | CHOICE-PLUS-PPO |
| TPA | TPA-62157 | 2026-09-26T15:28:22Z | LINDA | — | SMITH·· | 9160-12-14 | — | ·· | — | null | 6026 Indian School Road | Tampa | FL | 33609-7549 | UNKNOWN | — |
| TPA | TPA-53936 | 2026-07-21T20:21:14Z | GRACE | — | HILL | 03/20/1995 | NULL | UNKNOWN | — | — | 8723 Harbor Boulevard | Plano | TX | 75086 | ·· | MEDICARE-ADV-B |
| TPA | TPA-54996 | 2026-04-17T19:12:49Z | Sandra | — | Clark | 9/6/1967 | — | - | 262.350.3155 | UNKNOWN | 9762 Apache Boulevard | Gilbert | AZ | 85260 | GRP-1716 | — |
| TPA | TPA-57718 | 2026-10-11T17:00:38Z | Rachel | — | Webb·· | 4/13/2001 | ···· | •••-••-1857 | N/A | null | 5298 MAPLE AVE | Atlanta | ·GA | 30378 | NULL | UNKNOWN |
| TPA | TPA-50210 | 2026-06-05T13:19:06Z | Ortiz, Judith | — | — | 1/5/1981 | N/A | — | 7199290 | UNKNOWN | 9287 Camelback Rd | Gilbert | AZ | 85216 | null | UNKNOWN |
| TPA | TPA-53267 | 2026-08-05T10:29:20Z | PATRICIA | — | HAYES | 07/03/2000·· | N/A·· | — | - | patricia.hayes@gmail.com | 5615 Grand Avenue | Jacksonville | FL | 32275-0958 | GRP-1026 | N/A |
| TPA | TPA-52904 | 2026-10-09T02:41:54Z | NANCY | — | ·ANDREWS | 1983-12-26 | - | N/A | UNKNOWN | - | 627 Grand Avenue | Glendale | AZ | 85355-0898 | ·N/A | MEDICARE-ADV-B |
| TPA | TPA-55328 | 2026-06-22T10:54:52Z | Kayla·· | — | Bradley | 1953-02-12 | — | •••-••-2841 | null | - | 3936 Jefferson Avenue | Charlotte | NC | N/A | null | null |
| TPA | TPA-62653 | 2026-03-29T17:00:06Z | MARTHA | — | DAVIS | 1983-01-03 | - | UNKNOWN | ·(723) 732-5112 | MARTHA.DAVIS17@AOL.COM | 1368 HARBOR BLVD·· | San Antonio | Texas | 78271 | GRP-9133 | ·NULL |
| TPA | TPA-62371 | 2026-03-24T16:54:02Z | Hoffman, Lisa | — | — | 01/28/1942 | UHC-60324-02 | — | — | lisa.hoffman79@outlook.com | 1890 Apache Boulevard | Eden Prairie | ·MN | 55342 | ·· | UNKNOWN |
| TPA | TPA-63869 | 2026-03-13T04:17:32Z | Jerry·· | — | ·Roberts | 2005-11-21 | null | •••-••-1845 | +1 519 886 2869 | ···· | ·8059 Valley View Drive | Scottsdale | AZ | 85272 | GRP-6476 | — |
| TPA | TPA-56382 | 2026-10-08T00:36:14Z | Walter | ·· | Murphy | 1962-03-01 | UHC-07820-82 | — | N/A | N/A | 3903 Palm Drive | Glendale | ·AZ | 85315·· | GRP-9434 | NULL |
| TPA | TPA-56786 | 2026-01-13T06:14:06Z | Lawrence | — | Kennedy | Jul 23, 1940 | — | - | ·9592139256 | ·· | 2893 BASELINE RD | ·Dallas | TX | 75217 | GRP-7416 | — |
| TPA | TPA-54280 | 2026-03-18T07:04:24Z | Roger | — | Lewis | 1952-04-16 | UNKNOWN | UNKNOWN | (944) 844-5964 | roger.lewis@gmail.com | 9404 Highland Ave | Miami | ·Florida | 33115-0393 | — | MEDICARE-ADV-A |
| TPA | TPA-51561 | 2026-04-11T14:31:16Z | PHILIP | — | HARRIS·· | 1978-06-25 | — | N/A | — | NULL | 1274 Main Street·· | ·Austin | TX | ·78761 | — | — |
| TPA | TPA-55701 | 2026-07-24T08:29:29Z | janice | — | hunt | 1956-12-24 | null | ·- | — | null | ·5192 Lincoln Way | Charlotte | NC | 28268 | - | NAVIGATE-HMO |
| TPA | TPA-56227 | 2026-05-06T23:37:29Z | Sandoval, Jesse | — | ·· | 1962-10-14 | UHC-22226-32 | •••-••-8777 | 876.267.4493 | jesse.sandoval55@gmail.com | 2084 Jefferson Avenue | Jacksonville | FL | 32286 | NULL | UNKNOWN |
| TPA | TPA-63578 | 2026-02-08T23:54:02Z | austin | ·· | santos | 9/16/2004 | — | — | (305) 276-8455 | — | 9199 Church St Apt 5 | Dallas | TX | 75207-3367 | N/A·· | — |
| TPA | TPA-54949 | 2026-02-03T15:39:53Z | Austin, Daniel | — | — | 1967-05-16 | null | UNKNOWN | UNKNOWN | - | 7940 Mesa Dr Apt 37 | Scottsdale | Arizona | UNKNOWN | — | null |
| TPA | TPA-55119 | 2026-02-28T08:06:43Z | Juan | — | Jordan | ·2000-07-03 | — | UNKNOWN | null | — | 7107 JEFFERSON AVENUE | PLANO | TX | 75064 | GRP-8385 | — |
| TPA | TPA-64126 | 2026-01-26T06:38:51Z | JOSE | K | CARPENTER | ·9143-04-07 | N/A | - | N/A | — | 4048 WILLOW COURT | Plano | TX | 75049·· | UNKNOWN | - |
| TPA | TPA-62878 | 2026-01-04T15:26:54Z | ·Mei | — | Griffin | 1994-03-17 | — | •••-••-8720 | UNKNOWN | ·· | UNKNOWN | UNKNOWN | null | ·N/A | — | NAVIGATE-HMO |
| TPA | TPA-59500 | 2026-09-30T08:31:58Z | PAUL | — | JRDAN | 1958-10-24 | UNKNOWN | •••-••-0361 | N/A | NULL | 3424 Apache Blvd Apt 26 | Los Angeles | CA | 90020 | N/A | SELECT-EPO |
| TPA | TPA-61750 | 2026-09-14T09:48:29Z | Barbara | — | Moreno | 19680717·· | — | •••-••-6902 | N/A | ·· | 5040 Oak St | Nashville | TN | 37264 | — | ·NAVIGATE-HMO |
| TPA | TPA-55570 | 2026-02-16T03:10:30Z | Yuki | — | Hoffman | 19400310 | null·· | NULL | 16493741097 | — | 4114 River Road | Tampa | FL | ·33648 | GRP-0969 | — |
| TPA | TPA-63943 | 2026-10-07T10:03:18Z | JERRY | R | OBRIEN | 1955-01-02·· | NULL | — | (875) 841-4482 | jerry.obrien7@gmail.com | 4060 Mesa Dr | Jacksonville | FL | 32204 | GRP-8889 | NAVIGATE-HMO |
| TPA | TPA-62343 | 2026-10-11T16:57:59Z | nick | M | garcia | 1964-11-11 | null | - | NULL | null·· | 9584 HILLCREST ROAD | Eden Prairie | MN | 55370 | N/A | ·· |
| TPA | TPA-56494 | 2026-03-17T00:17:15Z | Munoz, Janet | — | — | ·1941-09-07 | — | N/A | — | — | 4965 Mesa Drive | Gilbert | AZ | 85269 | — | — |
| TPA | TPA-63887 | 2026-03-18T03:29:26Z | ANNA | — | WEAVER | 26-12-1965 | UHC-31781-97 | •••-••-4797 | — | NULL | UNKNOWN | NULL | null·· | ·· | NULL | — |
| TPA | TPA-58869 | 2026-03-03T08:42:37Z | Olivia | — | Turner | 09/17/1974 | — | N/A | - | — | 1202 PINE DR | Tucson·· | AZ | ·85746 | UNKNOWN | — |
| TPA | TPA-55490 | 2026-09-30T12:28:21Z | Watkins, Alexis | — | — | 1946-10-08 | null | •••-••-7576 | N/A | - | NULL | — | N/A | NULL | - | CORE-HMO |
| TPA | TPA-58666 | 2026-05-25T06:20:01Z | LISA·· | Y. | YOUNG | 1964-10-21 | NULL | •••-••-0939 | — | — | 2499 Elm Street | Fresno | ca | 93777 | GRP-2736 | — |
| TPA | TPA-61104 | 2026-09-10T08:47:03Z | ·Steven, Coleman | — | ·· | Sep 27, 1943 | — | N/A | N/A | NULL | — | UNKNOWN·· | N/A | N/A | ·GRP-3256 | NULL |
| TPA | TPA-61300 | 2026-04-01T04:50:02Z | Oliver, Justin | — | — | 1964-08-14 | N/A | — | N/A | — | 7132 CHURCH ST | ·Las Vegas | NV | 89195 | — | OPTIONS-PPO |
| TPA | TPA-60318 | 2026-04-18T21:12:24Z | Maria | — | Coleman | 1984-05-06 | ·null | •••-••-9862 | N/A | null | — | — | UNKNOWN | NULL | GRP-4039 | UNKNOWN |
| TPA | TPA-63208 | 2026-06-29T20:13:56Z | BARBARA | — | ·PETERS | 1951-04-10 | — | null | N/A | barbara.peters@yahoo.com | 4436 Maple Ave | Tampa·· | FL | 33650·· | null | null |
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.728Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty