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

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
TPATPA-599082026-03-11T22:21:12ZDavid—Fernandez1951-08-26-—N/Adavid.fernandez35@outlook.com4905 Spring StHoustonTX77012··—OPTIONS-PPO
TPATPA-559642026-06-27T19:07:09ZBryan—Jimenez1961-03-08UHC5234182———1671 Bayshore DrivePhoenixAZ85054NULL—
TPATPA-605492026-04-12T16:01:16ZChristina—Franklin1966-05-21nullnull—-8753 Lincoln WayPHOENIX·AZ85052UNKNOWN—
TPATPA-509992026-07-22T01:54:24Zroger—crawford1966-01-21··UHC-92649-44•••-••-3888(309) 848-5055-8719 OAK STREETPhoenixAZ85008··GRP-0937UNKNOWN
TPATPA-643282026-09-25T21:14:03ZLucia—LucasSep 22, 1942N/ANULL—N/A6590 GRAND AVESacramentoCA95827-6614GRP-5484NULL
TPATPA-524232026-03-03T20:02:56ZTheresa··—·Harvey1953-09-10—•••-••-5304N/A-———nullN/AUNKNOWN
TPATPA-571862026-01-27T06:27:13ZcarolNross1987-03-24————5318 CENTRAL AVEOrlandoFL32845GRP-0880N/A
TPATPA-564062026-01-03T13:43:31Z Evans, Mariana——1997-10-27—·N/A—-9718 RIVER RDNashvilleTN37251NULL··OPTIONS-PPO
TPATPA-548562026-01-05T23:27:14ZCarl—Thompson1958-01-03—-·UNKNOWN-··683 SPRING STREETOrlandoFL32803-9273GRP-0933MEDICARE-ADV-A
TPATPA-575742026-07-19T12:03:28ZcarlosI··berry1980-07-27—•••-••-988119023242532NULL2017 Palm DrMesaAZ·85295GRP-3042UNKNOWN
TPATPA-536632026-06-04T04:28:24ZGLORIA—LE1940-08-28———NULL1542 Highland AvenueSCOTTSDALEAZ85295N/A—
TPATPA-606612026-02-20T03:19:29Zalexis—wasshington··02/18/88UNKNOWN•••-••-7309·N/A—4319 Camelback RoadTampaFL33696—UNKNOWN
TPATPA-546892026-05-11T07:51:06ZWebb, LoriN.—19900701UHC-69037-61•••-••-7908-null2854 Maple Avenue Apt 38Miami··Florida33172GRP-9907—
TPATPA-551092026-09-12T04:16:49ZSANTIAGO—MILLER1951-02-23UHC-98037-76•••-••-7392—null963 Mountain View DrSacramentoca95893-4103N/A—
TPATPA-557842026-05-29T10:40:14Zmarcus—chavez-·N/A•••-••-6715—····5658 Valley View DrNashvilleTN37298—SELECT-EPO
TPATPA-588512026-06-23T20:31:11ZThomas—·Holmes19971219UNKNOWNUNKNOWN16828810217N/A2283 BroadwayEden PrairieMN··55363-3772GRP-4044MEDICARE-ADV-A
TPATPA-548862026-08-28T03:38:49ZMason, Justin——2002-01-09UNKNOWNNULL(760) 422-6272—8634 Sunset BlvdDallasTexasnull——
TPATPA-626012026-01-06T06:27:39ZVICTORIA—HART1977-07-08nullNULL8102738134null··660 Union StreetSan AntonioTX78272—N/A
TPATPA-539242026-03-30T15:59:07ZBrandon—Hanson11/20/58UNKNOWN•••-••-604616632974563—5096 MESA DR·LOS ANGELESCalifornia··UNKNOWNGRP-3633··CHOICE-PLUS-PPO
TPATPA-549522026-08-31T06:01:54ZStephanie—Hayes19820625—•••-••-8772490-410-1885UNKNOWN6718 Elm StScottsdaleAZ··85232-2636GRP-2582UNKNOWN
TPATPA-507402026-03-24T10:17:08Zdylan—kim24-06-2007UHC-93308-26—nullN/A··7800 Elm StreetDallasTX··75249—····
TPATPA-540472026-01-24T14:14:00Z Madison—Garza02-04-1979UHC-61120-69•••-••-7820·-—1278 Sage CourtDenverCO··80280NULL—
TPATPA-518652026-02-20T20:15:58ZGARY—WELCH1940-12-20—nullNULL—1042 Church StreetTampaFlorida33621N/Anull
TPATPA-588702026-08-20T22:12:17Zloan—gardner6/26/1946nullN/A15898706565logan.gardner@icloud.com6261 Washington StreetSan AntonioTX78256UNKNOWN··UNKNOWN
TPATPA-638682026-07-07T11:31:48ZJerry—RobertsNov 21, 2005··UHC-19892-59null5198862869—8059 Valley View DriveSCOTTSDALEAZ85272——
TPATPA-561352026-08-02T13:36:26ZSAMUEL—RICHARDS1938-05-17UHC-77129-51——NULL1323 Park Place Apt 36SEATTLEWA98101GRP-7045—
TPATPA-619362026-01-25T08:52:06Z Marilyn—Guerrero05/12/97—•••-••-1972931-566-3424UNKNOWN3267 Mesa DriveOrlandoFLN/A-null
TPATPA-513232026-03-01T00:19:13ZLAURAF.·REYES1987-02-18-•••-••-1890—··6236 Spring StreetDALLASTX75216-MEDICARE-ADV-B
TPATPA-531702026-06-23T22:37:43ZGrece—Hayes1964-09-27—NULL·222-562-1741-4935 APACHE BOULEVARDOrlandoFL32804GRP-0743MEDICARE-ADV-A
TPATPA-549052026-06-26T23:22:54ZVICTORIA—PADILLA1952-10-26·UHC-84331-08NULL——5959 CANYON ROADLAS VEGASnv89122——
TPA TPA-562212026-08-16T08:23:14ZCAROL—GARDNER1997-04-28UHC-82456-87—508-901-3089N/A2681 Washington StreetTampaFL33667GRP-6012MEDICARE-ADV-B
TPATPA-642082026-08-16T23:48:17ZVALENTINA—DIAZ1942-03-10—-(839) 414-7263VALENTINA.DIAZ67@OUTLOOK.COM8551 Indian School Road Apt 35MesaAZ85238GRP-3151—
TPATPA-643972026-10-09T08:20:33Z·ROY—COLLINS11/26/48——UNKNOWNUNKNOWN9360 Ocean AvenuePlanoTX·75007——
TPATPA-606302026-02-11T02:44:58ZSofia—Walkre01-10-1997N/A•••-••-7272—N/A3784 Oak StMesaAZ——null
TPATPA-586992026-10-17T09:50:16ZRUSSELL····HAMILTON1974-01-01-UNKNOWN—NULL5634 Hillcrest RdSan AntonioTX··78232UNKNOWNOPTIONS-PPO
TPATPA-529022026-06-24T22:30:15ZAlexander—Gomez7/4/1961··-•••-••-8230——9313 Mountain View DrSan DiegoCA92151—N/A
TPATPA-606842026-05-31T20:50:45ZHart, Mariana——1940-09-21—•••-••-92565906139619·MARIANA.HART@HOTMAIL.COM4802 Union StreetGilbertAZ·85265UNKNOWN—
TPATPA-605902026-03-04T08:52:03ZAlice—Russell19760909—NULLN/A-1599 BAYSHORE DRIVEOrlandoFL32890-1771GRP-0790UNKNOWN
TPATPA-603432026-04-28T16:34:29ZWEI—SOTOOct 8, 1961UHC-13631-55NULL-wei.soto@proton.me·6071 Valley View DriveColumbusOH43240GRP-4948—
TPATPA-571212026-09-16T21:41:26Zgreen—charlotte1946-08-06-•••-••-1527950-221-0414-4490 VALLEY VIEW DRMINNEAPOLISMN55449null—
TPATPA-609792026-03-22T20:13:28ZTucker—Mei··UHC-96295-40—7514722370-5689 SPRING STREETAustinTX78792null—
TPATPA-523502026-01-13T21:30:04ZBETTY—WARREN2000-12-24null•••-••-8897—NULL5525 Union St #622MINNEAPOLISMN··55457-NULL
TPATPA-586672026-08-03T01:42:07ZCox, DanielleX.—1943-04-12————5635 Spring StreetSacramentocaUNKNOWN—····
TPATPA-552812026-07-25T20:14:30Z frank··—castilloJan 2, 2005UHC-40282-62•••-••-2113——3298 JEFFERSON AVENUEMiamiFL33129—·NULL
TPATPA-539092026-01-17T16:19:49ZGebrielOMejia12-12-1961UNKNOWN•••-••-7803NULL-1816 Forest AvenueOrlandoFL32826NULL—
TPA TPA-57939 2026-06-11T06:58:02ZCole··—Kevin02/14/1961UHC-88488-78—415-222-7207—2813 Market StreetEDEN PRAIRIEMN55329N/A—
TPATPA-618342026-06-18T04:55:41ZSsan—WadrOct 13, 1976·UHC-82540-45null····—1262 Canyon Road #492COLUMBUSOH43220-CORE-HMO
TPATPA-577372026-04-03T16:12:04Z·sean—luna1971-05-16—•••-••-7234null—3548 BASELINE ROADChandleraz85211GRP-3201NULL
TPATPA-600632026-08-26T03:55:30ZWeber, Laura··——1941-09-14———UNKNOWN3697 Highland AvenueOrlandoFL-—OPTIONS-PPO
TPATPA-596892026-09-17T04:59:00ZRamirez, Mary——May 21, 1986-UNKNOWNN/A—9497 Willow CourtEDEN PRAIRIEMN55379NULLN/A
14,474 rows, page 240 of 290PreviousNext

Bronze layer rules

What is guaranteed for downstream layers

  • As received
    Values are stored exactly as the feed delivered them, including whitespace, inconsistent casing and placeholder tokens such as NULL or N/A.
  • No transformation
    Bronze is never edited in place. Every fix lives in silver and is traceable back here by record ID.
  • Line number preserved
    The line number records each row's position in the source file, so a value can be located in the original extract.
  • Load timestamp
    The load timestamp marks when the row landed in the lakehouse; this batch landed 2026-10-22T12:43:00.215Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty