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

Enrollment only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1249872026-03-11T08:56:39ZElizabeth····Simmons1985-06-17UHC-07694-89•••-••-06959257653754·ELIZABETH.SIMMONS@YAHOO.COM9041 Baseline RoadFRESNOCA·93797GRP-1867NAVIGATE-HMO
ENRENR-1351582026-02-02T08:58:17ZScottSLe1960-06-05UHC-13697-19•••-••-0437(758) 863-1704SCOTT.LE@YAHOO.COM586 CANYON RDGilbert·AZ85216GRP-6218MEDICARE-ADV-B
ENRENR-1206012026-02-05T10:58:01ZAustin, Camila—··1969-04-17UHC-85544-97•••-••-4088+1 818 346 5862camila.austin@gmail.com8623 River RoadLas VegasNevada89135GRP-1937OPTIONS-PPO
ENRENR-1023092026-04-12T10:57:34Zkathrine···T.russellNov 1, 1954UHC-43937-93—+1 269 966 7607UNKNOWN1701 Washington StLAS VEGASNV89176GRP-8408NAVIGATE-HMO
ENRENR-1313952026-09-16T15:20:02Z RANDYA.WASHINGTON03/22/08UHC-15953-69•••-••-7240+1 671 573 1701randy.washington@outlook.com3155 SUNSET BLVDMinneapolisMN55489GRP-6922MEDICARE-ADV-B
ENRENR-1384752026-04-20T02:33:43ZHiroshiZPierce19530621UHC2866510•••-••-5192450-616-0415HIROSHI.PIERCE81@YAHOO.COM8169 CANYON RD Apt 21SAN DIEGOCA92188GRP-8767CHOICE-PLUS-PPO
ENRENR-1227862026-06-16T13:43:32ZBettyK.Garcia1999-09-19UHC-86761-69··•••-••-3241+1 633 733 4891BETTY.GARCIA@OUTLOOK.COM3070 Park PlaceSan DiegoCA92178GRP-5207SELECT-EPO
ENRENR-1346002026-04-02T00:56:10ZdorothyT.wagner2002-11-17UHC0572197•••-••-2984(525) 265-8092dorothy.wagner@icloud.com5737 Lake View RdTAMPAFlorida33698-0423GRP-5979MEDICARE-ADV-A
ENRENR-1016172026-01-30T13:01:32ZAdams, BrandonO—1957-09-08UHC-04938-69•••-••-330913874682776null2111 Jefferson Avenue·Eden PrairieMN55357GRP-8165medicare-adv-b
ENRENR-1036462026-03-16T21:36:35ZRUTHE.WELLS2003-12-08UHC-16007-69•••-••-0594822-770-8183RUTH.WELLS@GMAIL.COM-—NULL-GRP-1853MEDICARE-ADV-A
ENRENR-1234882026-08-08T03:53:06ZJacqueline, MaldonadoC.··19831005·UHC2955972•••-••-456914487602518UNKNOWN5838 Apache Blvd·GlendaleAZ85300GRP-7803NAVIGATE-HMO
ENRENR-1291292026-01-04T23:37:45ZSmith, YukiW—Feb 28, 1995UHC-02831-95•••-••-5034+1 421 554 2241yuki.smith72@hotmail.com8941 HIGHLAND AVE #285PhoenixAZ85056-2162GRP-6923SELECT-EPO
ENRENR-1024882026-03-01T08:59:59ZsofiaPjones1996-10-20UHC-34570-67···2274115717UNKNOWN8631 Spring StreetMiamiFL··33139·GRP-6763SELECT-EPO
ENRENR-1293402026-09-19T03:14:33ZCastor, NancyL—8/6/1986UHC-90346-97—754-760-1844UNKNOWN4187 CHURCH STREETFresnoCalifornia—GRP-0649CHOICE-PLUS-PPO
ENRENR-1216732026-03-09T14:57:31ZSANTIAGO—·WHITE1956-03-09UHC9073254•••-••-69013015493284santiago.white@outlook.com9371 CANYON ROAD Apt 16OrlandoFLN/AGRP-8664SELECT-EPO
ENRENR-110278 2026-06-28T10:54:24ZKENNETHLAUSTIN1948-09-16UHC-51251-30•••-••-2959531-524-2344—4707 PALM DRColumbus··OH43278GRP-0248·MEDICARE-ADV-B
ENRENR-1129582026-04-30T20:20:32ZAMBER—GREEN1976-03-15UHC-30412-77NULL6891115-·2929 Maple AveSeattleWA98104GRP-9690MEDICARE-ADV-A
ENRENR-1025382026-09-18T01:44:31ZIsabellaY.··PriceMar 25, 1964UHC-41557-49•••-••-4013473-449-5502isabella.price71@gmail.com7692 Meadow LaneSan AntonioTX78235GRP-6999MEDICARE-ADV-A
ENRENR-1115792026-09-07T00:08:07Z BryanS.Smith·2003-10-02UHC-11693-40•••-••-107617415637435bryan.smith@gmail.com8664 RIDGE ROADNashville·TN37207GRP-3739CORE-HMO
ENRENR-1181232026-08-08T15:19:00Z Karen F—Wong20010925··UHC7592748•••-••-20945548531415UNKNOWN6744 UNION ST··TempeAZ85263GRP-2674OPTIONS-PPO
ENRENR-1367512026-04-17T01:37:40Z lauren—castillo1995-02-27NULL•••-••-46135838302953lauren.castillo@proton.me1958 HIGHLAND AVEAUSTINTX78734·GRP-0189MEDICARE-ADV-B
ENRENR-1382122026-01-14T19:40:35ZMargaretZFreeman2007-05-19UHC-69240-19•••-••-0922nullmargaret.freeman41@yahoo.com2160 Sunset BoulevardTUCSONAZ85789GRP-6965OPTIONS-PPO
ENRENR-1108742026-09-09T04:43:05ZJacquelineEMorgan2005-03-07UHC-18123-57•••-••-8814488-655-6989jacqueline.morgan@proton.me6138 Canyon RdLAS VEGASNV89144GRP-6617CHOICE-PLUS-PPO
ENRENR-1051162026-01-12T19:50:10ZKyle···Carroll1971-10-06UHC-02178-09•••-••-8488748.274.5828NULL4181 Maple Avenue Apt 13ChandlerAZ85268GRP-5368MEDICARE-ADV-A
ENRENR-1368052026-07-13T07:12:20ZJANICE··LHAMILTONFeb 23, 1977UHC-98453-76•••-••-442913966720156null6541 Cedar LaneLas VegasNV89137GRP-1984·OPTIONS-PPO
ENRENR-1061452026-07-01T08:34:29ZMARGARET—SMITH1976-01-15UHC-25071-63•••-••-50063342591824margaret.smith33@gmail.com1446 RIDGE ROADCHANDLERAZ85248GRP-4715···OPTIONS-PPO
ENRENR-1385842026-09-16T03:33:00ZJeanFCole1968-08-07UHC-91000-09··•••-••-82504124694708—7258 SPRING STScottsdaleAZ85234·GRP-9987NAVIGATE-HMO
ENRENR-1396112026-03-13T09:50:38ZBruceSDavis1965-05-08UHC-07071-47•••-••-3015·7219149963BRUCE.DAVIS15@PROTON.ME3981 Canyon RoadGILBERTAZ85252GRP-4597MEDICARE-ADV-A
ENRENR-1388452026-04-14T23:21:12ZGaryJ.Graham05/19/1991—•••-••-2473275-336-3092gary.graham@yahoo.com6136 Willow CourtLos AngelesCA90038GRP-4099·CORE-HMO
ENRENR-1356232026-04-05T22:12:55ZANNHTHOMAS08/05/44UHC-26331-71•••-••-371014459448313·ann.thomas@proton.me7631 GRAND AVETucsonAZ85730GRP-5089OPTIONS-PPO
ENRENR-141556 2026-01-17T19:36:48ZNatalliePBennett1992-11-25·null•••-••-4005961-963-3546natalie.bennett@icloud.com517 RIVER RD··HoustonTX77063GRP-9067SELECT-EPO
ENRENR-1326622026-03-26T20:58:55ZDenise—Alexander1954-06-06UHC-25357-86•••-••-8285408.552.0921denise.alexander84@proton.me·1316 SUNSET BOULEVARDNASHVILLETN37233GRP-4528NAVIGATE-HMO
ENRENR-1166122026-06-04T21:21:29ZBarbaraZ.·RobinsonMar 9, 1953UHC-20413-79•••-••-0450428.683.6779barbara.robinson@hotmail.com1839 RIVER ROAD··MiamiFLNULLGRP-2462NAVIGATE-HMO
ENRENR-1171292026-09-23T08:54:01ZJudyA.Harper1972-10-01UHC-60527-88•••-••-6703890-537-9188judy.harper@gmail.com9383 Oak StCharlotteNC—GRP-7897CHOICE-PLUS-PPO
ENRENR-1198722026-06-21T16:18:03ZJULIE—FLORESMar 17, 1949UHC-51387-50•••-••-5653——7740 Highland AvenueGilbertAZ·85259GRP-7780CORE-HMO
ENRENR-1286402026-03-23T07:14:02ZCATHERINE—FORD1977-12-27UHC8120391•••-••-0967(972) 898-0314CATHERINE.FORD@ICLOUD.COM1919 Harbor BoulevardSacramentoCA95809··GRP-0178CHOICE-PLUS-PPO
ENRENR-1065462026-03-11T05:00:22ZCatherineN.Peterson1957-01-12UHC-39833-21•••-••-665719309505082catherine.peterson34@icloud.com277 Main StreetMiamiFL33121GRP-5010MEDICARE-ADV-B
ENRENR-1364882026-03-19T14:03:52ZWAYNEZ.CRUZ1964-09-07UHC-31174-70•••-••-3355478.431.1718WAYNE.CRUZ@ICLOUD.COM5670 INDIAN SCHOOL RDSeattle··WA98179GRP-9701·SELECT-EPO
ENRENR-1371682026-08-07T07:13:20ZIsabella—Mejia·1962-12-17UHC-73135-01•••-••-25196616241617isabella.mejia96@gmail.com9832 WASHINGTON STREETPhoenix·AZ85075GRP-7099NAVIGATE-HMO
ENRENR-1139692026-02-22T20:14:44ZVega, Carl——12/26/1939UHC-72214-77•••-••-01276338953920CARL.VEGA@ICLOUD.COM2668 Camelback RdScottsdaleAZ··85250GRP-2892MEDICARE-ADV-A
ENRENR-1398182026-05-24T17:48:13ZCharlesXButler1963-10-19UHC-33196-93•••-••-55268462801030charles.butler62@icloud.com·7058 Central AveMIAMIFL-GRP-8867CHOICE-PLUS-PPO
ENRENR-1247432026-08-01T23:59:28ZHANNAHNANDREWS03/21/76UHC-25949-03•••-••-8310(959) 567-1574HANNAH.ANDREWS86@PROTON.ME113 Elm StreetColumbusOhio43245GRP-5115NAVIGATE-HMO
ENRENR-1323792026-09-25T08:23:59ZDouglasIWeaver1956-07-25UHC-61518-06•••-••-2720(546) 422-3496douglas.weaver@yahoo.com4633 Main StGilbertAZ85277GRP-2482SELECT-EPO
ENRENR-1082952026-02-06T06:52:24Z NANCYN.BISHOP1989-02-21UHC-38129-07··•••-••-2150404-791-4035nancy.bishop63@icloud.com1959 OCEAN AVEORLANDOFL32821·GRP-1100CHOICE-PLUS-PPO
ENRENR-1315692026-01-16T12:22:46ZKATHERINE—LYNCH1977-04-16UHC-48716-64•••-••-20469806328774KATHERINE.LYNCH@ICLOUD.COM9476 Ocean AvenueAtlanta·GA30317GRP-0284CHOICE-PLUS-PPO
ENRENR-1157862026-04-06T11:59:01ZANGELAAGREENE1952-05-01UHC-77777-60•••-••-1291NULLANGELA.GREENE@ICLOUD.COM3078 SAGE COURT Apt 17San AntonioTexas··78265GRP-7704NAVIGATE-HMO
ENRENR-1365652026-07-09T05:55:00ZPamelaP.Jimenez09/02/72UHC-07568-10•••-••-24209377995611pamela.jimenez42@outlook.com4894 BROADWAY Apt 25CHARLOTTENC28222GRP-3508NAVIGATE-HMO
ENRENR-1161702026-04-19T02:17:49Zvirginia—ross19990713UHC-44106-88•••-••-4263(574) 297-7313virginia.ross@proton.me6241 Main StOrlandoFL·32827GRP-7113MEDICARE-ADV-A
ENRENR-1406352026-10-11T23:44:22ZKENNETHH.GARRETT4/11/1999·UHC-93400-76•••-••-72708187002990···1710 Harbor BoulevardMinneapolisMN55446GRP-6212CORE-HMO
ENRENR-1403802026-01-12T10:47:07ZHenry—Soto02/26/68UHC-32029-14•••-••-19765242635765—·8371 RIVER RDAustinTX78748-4679GRP-1883SELECT-EPO
43,101 rows, page 257 of 863PreviousNext

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:42:40.643Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty