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-52763 | 2026-05-11T05:43:41Z | Sharon | — | Hanson | 2000-07-07 | — | •••-••-7005 | NULL | UNKNOWN | 33 River Rd | Sacramento | CA | 95834 | N/A | MEDICARE-ADV-A |
| TPA | TPA-56754 | 2026-08-28T15:47:20Z | Daniel | — | Warren | 2007-05-06 | NULL | — | N/A | NULL | NULL | N/A | — | — | GRP-6268 | NAVIGATE-HMO |
| TPA | TPA-63696 | 2026-03-08T18:37:11Z | Amanda | — | Andrews | 9171-10-25 | UHC-57948-95 | NULL | null | — | 7758 Central Ave | CHANDLER | AZ·· | 85275 | - | - |
| TPA | TPA-61144 | 2026-08-29T12:53:45Z | AISHA·· | — | MONTGOMERY | 1940-08-14·· | NULL | •••-••-9558 | - | — | 6702 RIVER ROAD | Las Vegas | NV | 89125 | - | — |
| TPA | TPA-50394 | 2026-09-13T21:30:25Z | PATRICK | — | MOORE·· | Mar 4, 1955 | — | N/A | — | UNKNOWN | 1188 LINCOLN WAY | SCOTTSDALE | AZ | 85236 | GRP-3879 | — |
| TPA | TPA-52023 | 2026-08-15T03:36:44Z | Debra | ·· | Marquez | 03/18/1996 | uhc-56584-90 | N/A | — | debra.marquez@yahoo.com | 4462 FOREST AVENUE | Minneapolis | MN | 55483 | — | null |
| TPA | TPA-50167 | 2026-05-29T00:44:37Z | CHRISTOPHER | — | PIERCE | 1944-11-18 | UNKNOWN | - | — | CHRISTOPHER.PIERCE@YAHOO.COM | 3313 DESERT SKY BOULEVARD | Minneapolis | MN | 55405 | — | - |
| TPA | TPA-60051 | 2026-06-22T09:33:53Z | Maldonado, Scott | ···· | — | 1988-06-23 | — | NULL | UNKNOWN | N/A | 5599 Palm Drive | Atlanta | GA | 30317 | null | — |
| TPA | TPA-58121 | 2026-09-05T20:11:46Z | EVELYN | — | RODRIGUEZ | 06/17/63 | N/A | UNKNOWN | 19769376282 | evelyn.rodriguez17@icloud.com | 9796 Union Street | Fresno | ·CA | 93765 | — | N/A |
| TPA | TPA-64142 | 2026-08-04T09:32:58Z | Jacqueline | — | Mitchell·· | 1952-08-19 | UNKNOWN | - | null | null | 4556 Grand Ave | Atlanta·· | GA | 30384 | GRP-3218 | OPTIONS-PPO |
| TPA | TPA-57733 | 2026-08-31T15:40:12Z | Vega, Judy | E. | — | 1996-03-15 | — | null | ·915-739-0906 | — | null | — | null | null | - | — |
| TPA | TPA-58034 | 2026-04-22T11:37:00Z | brandon | — | reid | 11/07/1968 | — | NULL | NULL·· | - | NULL | - | — | — | NULL | — |
| TPA | TPA-56648 | 2026-01-12T21:41:55Z | STEPHANIE | J | MORGAN | 9158-01-03 | — | — | — | — | 338 Valley View Drive | Tempe | AZ | 85252 | — | null |
| TPA | TPA-62259 | 2026-01-15T21:15:49Z | vasquez | ·· | shirley | — | N/A | null | NULL | shirley.vasquez83@icloud.com | - | null | — | - | — | OPTIONS-PPO |
| TPA | TPA-57953 | 2026-10-09T04:30:55Z | rachel | ·Q | jacobs | ·04/04/97 | N/A | null | - | - | ·8448 Camelback Road #179 | Gilbert | AZ | 85206 | N/A | UNKNOWN |
| TPA | TPA-58006 | 2026-09-30T11:04:45Z | Emma | G. | Cook | 19600223 | ···· | •••-••-1588 | — | — | 2069 WILLOW CT | Houston | TX | ·77096 | N/A | NULL |
| TPA | TPA-62844 | 2026-06-15T02:39:06Z | frank | — | sanchez | 06/22/1993·· | null | NULL | null | frank.sanchez@outlook.com | 3489 Ridge Road | ·Miami | FL | 33153 | GRP-9934 | null |
| TPA | TPA-60213 | 2026-07-15T01:38:54Z | Logan | — | Greene | 1965-08-04 | UHC-51467-56 | null | 5107683 | - | — | N/A | UNKNOWN | — | — | null |
| TPA | TPA-57029 | 2026-08-08T10:14:39Z | Judith | — | Mills | 1943-05-28 | — | •••-••-2221 | — | N/A | 7674 Pine Dr | DENVER | CO | 80205 | GRP-5605 | MEDICARE-ADV-B |
| TPA | TPA-63669 | 2026-01-27T17:00:25Z | Doris | J. | ·Carlson | 1955-11-08 | ···· | NULL | NULL | — | — | UNKNOWN | UNKNOWN | N/A | ···· | — |
| TPA | TPA-58818 | 2026-06-03T10:04:25Z | megan | — | richards | Dec 4, 2007 | - | NULL | N/A | — | 5739 Oak St | Tempe | AZ | 85283 | UNKNOWN | ·NULL |
| TPA | TPA-51179 | 2026-07-14T03:56:35Z | JUSTIN | — | MURPHY | 1997-05-06 | — | — | 540-750-0245 | UNKNOWN·· | 176 LAKE VIEW ROAD | Gilbert | AZ | 85253 | GRP-0129 | — |
| TPA | TPA-64472 | 2026-10-02T06:34:49Z | William | — | Jordan | ·4/2/1957 | — | — | N/A | - | 8101 OAK ST | Houston | TX | 77065 | — | MEDICARE-ADV-A |
| TPA | TPA-52302 | 2026-01-31T22:29:32Z | Megan | — | Watkins | 10/10/97 | - | — | 208-670-8343 | — | 2995 MOUNTAIN VIEW DR | San Diego | CA | ·92132-0897 | ·NULL | N/A |
| TPA | TPA-57787 | 2026-03-01T21:59:16Z | ADAM·· | ···· | RUIZ | 2002-03-19 | UHC-93885-30 | •••-••-9004 | 5249089026·· | — | N/A | — | N/A | - | — | UNKNOWN |
| TPA | TPA-51190 | 2026-09-27T23:37:01Z | ·Gary | B | Martin | 5/19/1975 | NULL | N/A | ·- | UNKNOWN | 8737 Main St·· | Denver | CO | 80251 | GRP-6063 | null |
| TPA | TPA-58915 | 2026-05-03T02:48:58Z | MARCUS | S | WONG | 1988-04-10 | — | — | 803.459.3381 | N/A | 3182 Union Street | Gilbert | ·AZ | 85211 | — | UNKNOWN |
| TPA | TPA-58352 | 2026-01-15T16:41:03Z | Amber | — | Marquez | 8/13/1957 | — | null | (465) 414-8527 | amber.marquez90@icloud.com | 4020 Meadow Ln | San Antonio | ·TX | 78256 | — | — |
| TPA | TPA-54740 | 2026-02-19T04:55:24Z | ashley | ···· | ·gibson | 12-08-2005·· | NULL | null | — | NULL | 8818 MAPLE AVE·· | Phoenix | AZ | 85045 | — | OPTIONS-PPO |
| TPA | TPA-63048 | 2026-07-01T02:48:37Z | BETTY | — | MARSHALL | 1957-11-08 | UHC-98142-18 | •••-••-1114 | (941) 919-9010 | betty.marshall@yahoo.com | 9766 Mesa Drive Apt 31 | Gilbert | az | 85212-7459 | — | N/A |
| TPA | TPA-54888 | 2026-09-22T11:59:55Z | Fuller, Kenneth | — | — | UNKNOWN | ·N/A | N/A | N/A | NULL·· | 7076 Lake View Road | Seattle | WA | 98176 | - | MEDICARE-ADV-A |
| TPA | TPA-50174 | 2026-08-28T14:05:10Z | ·Madison | M | Wright | 11/10/1971·· | null | NULL | — | madison.wright@icloud.com | — | — | - | NULL | GRP-6275 | — |
| TPA | TPA-64059 | 2026-07-21T03:38:56Z | Wright, Daniel | ···· | — | 01/04/1993 | null | NULL | null | — | 3838 Lincoln Way | Las Vegas | NV | 89167 | GRP-1508 | UNKNOWN |
| TPA | TPA-56287 | 2026-08-07T21:24:03Z | BRIAN | — | OLSON·· | 1998-12-23·· | UNKNOWN | •••-••-9694 | (536) 427-6399 | - | - | null | NULL | N/A | GRP-7292 | ·· |
| TPA | TPA-58266 | 2026-06-02T18:12:51Z | Lewis | — | Brenda | 1941-12-12 | UHC-46833-10 | •••-••-6902 | ·N/A | NULL | 5805 Valley View Drive Apt 38·· | Charlotte | NC | 28267-9653 | GRP-7205 | SELECT-EPO |
| TPA | TPA-57185 | 2026-01-26T16:57:57Z | Christopher | — | White | ·04/15/78 | - | NULL | NULL | — | 6212 Broadway | Orlando | FL | 32820-6173 | GRP-4627 | MEDICARE-ADV-B |
| TPA | TPA-58816 | 2026-04-16T16:02:48Z | Jeeremy | — | Robertts | 1994-12-02 | N/A | •••-••-6376 | (531) 871-5301 | — | 9863 Sage Court #320 | COLUMBUS | OH | 43260·· | UNKNOWN | — |
| TPA | TPA-58036 | 2026-07-25T01:18:59Z | Juan | — | Stephens | 9180-04-17 | null | •••-••-8222 | 202-385-3058·· | — | 9366 Indian School Road | Jacksonville | FL | 32273 | ·null | SELECT-EPO |
| TPA | TPA-61281 | 2026-10-12T09:37:47Z | Marri | — | Stone | 1995-09-12 | UHC-60339-87 | — | 943-453-4428 | ·maria.stone88@hotmail.com | 459 Main Street | Phoenix | AZ | 85028 | GRP-3511 | - |
| TPA | TPA-51947 | 2026-03-25T03:56:11Z | SHIRLEY | — | ALVAREZ | 07/17/86 | NULL | •••-••-7961 | - | NULL | 1833 Grand Avenue | Gilbert | AZ | 85203 | NULL | - |
| TPA | TPA-54263 | 2026-06-23T00:48:36Z | Kimberly | — | Hernandez | 10/17/1979 | N/A | — | — | kimberly.hernandez74@icloud.com | UNKNOWN | UNKNOWN·· | - | — | GRP-4996 | MEDICARE-ADV-A |
| TPA | TPA-56739 | 2026-03-05T05:16:08Z | JACIKE | — | ·MCCOY | 11/01/39 | — | null·· | UNKNOWN | UNKNOWN | NULL | NULL | — | — | NULL | null |
| TPA | TPA-64020 | 2026-01-01T00:49:34Z | kyle | ···· | oliver | 1974-12-19 | — | UNKNOWN | N/A | NULL | 16 Mesa Dr | Minneapolis | ·MN | 55428 | ·UNKNOWN | — |
| TPA | TPA-61122 | 2026-03-13T18:20:20Z | SOFIA·· | — | GUERRERO | 1958-11-24 | - | •••-••-3571 | — | null | 748 CEDAR LN Apt 31 | Eden Prairie | MN | 55381 | — | NULL |
| TPA | TPA-51312 | 2026-09-25T01:30:50Z | Lwarence | — | Lawson·· | 11/27/1947 | — | •••-••-6576 | 5579213346 | — | 3465 PARK PL | Phoenix·· | AZ | 85011 | — | UNKNOWN |
| TPA | TPA-58176 | 2026-04-17T02:52:39Z | Camila | ·· | Howell | 1993-08-02 | UHC-03133-67 | — | (212) 246-8677 | null | 882 HARBOR BOULEVARD·· | Phoenix | AZ | 85036 | N/A | — |
| TPA | TPA-62533 | 2026-03-27T20:30:43Z | shirley | A | meyer | 09/12/1976 | UHC-36691-72 | •••-••-5366 | ···· | SHIRLEY.MEYER73@GMAIL.COM | 413 CEDAR LANE | Seattle | WA | 98187 | ·GRP-1484 | NULL |
| TPA | TPA-50586 | 2026-06-20T16:56:37Z | CATHERINE | — | ELLIS | 1939-12-19 | UNKNOWN·· | — | 7513768712 | — | 3991 Park Pl | Chandler | AZ | 85202 | GRP-4011 | — |
| TPA | TPA-51800 | 2026-10-11T02:24:20Z | JEAN | — | WELSH | 1949-10-02 | NULL | — | 445.285.4437 | NULL | 2051 Canyon Road | Los Angeles | CA | 90059 | GRP-1699 | - |
| TPA | TPA-59128 | 2026-07-17T11:14:01Z | JULIA·· | — | GARZA | 1951-12-07 | UHC-69609-77 | — | 287.918.0689·· | N/A | 9030 INDIAN SCHOOL ROAD | LAS VEGAS | ·NV | 89162-6124 | GRP-7255 | SELECT-EPO |
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:46.067Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty