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-1177502026-08-19T23:24:40ZEthan··SHernandezOct 24, 1990UHC-16392-66•••-••-33096976975727ETHAN.HERNANDEZ45@PROTON.ME2044 PARK PLCOLUMBUS·OH43227-4176GRP-9680SELECT-EPO
ENRENR-1306042026-04-08T01:51:00Z VictoriaV.Wright1982-10-28UHC-88256-05··•••-••-32526724467499victoria.wright20@gmail.com1417 CAMELBACK ROADLas Vegas··NV89176GRP-1277CHOICE-PLUS-PPO
ENRENR-1382242026-01-04T01:58:23ZElizabeth U.—Olson1946-11-20UHC-70010-46•••-••-36605755586667elizabeth.olson50@icloud.com6038 Grand AvenueDallasTexas75221-2472GRP-6663CHOICE-PLUS-PPO
ENRENR-1121402026-08-01T10:26:29ZNICOLE—DOMINGUEZ1958-03-15UHC-20516-54•••-••-990518735083241NICOLE.DOMINGUEZ@AOL.COM8946 Willow CtAtlantaGA30356GRP-8632··CORE-HMO
ENRENR-1262952026-04-10T09:47:25Z Wagner, GregoryS.—4/22/1968UHC-10634-98•••-••-54489892776402GREGORY.WAGNER@OUTLOOK.COM3175 Mesa DrScottsdaleaz85228-8503GRP-8280MEDICARE-ADV-A
ENRENR-1406772026-03-03T08:38:24ZOMMAR—CHEN1995-12-06UHC4984402UNKNOWN+1 644 678 5403omar.chen@icloud.com·3734 RIVER ROADLas VegasNV—GRP-8631CORE-HMO··
ENRENR-1095842026-10-18T01:47:10ZPriya L.—King04/05/2005UHC-86564-50··•••-••-8614(933) 226-2394priya.king@yahoo.com2281 River RoadSan AntonioTX78226GRP-6852SELECT-EPO
ENRENR-1327832026-06-22T03:06:49ZMICHELLE—·COLLINS06/16/52UHC2348777•••-••-11666669913michelle.collins90@gmail.com498 Valley View DrAUSTINTX78735GRP-7459CHOICE-PLUS-PPO
ENRENR-1354772026-07-11T16:43:38ZPriyaUCarpenter··1993-08-18UHC-51460-71•••-••-8430624-234-0634priya.carpenter@hotmail.com9840 Broadway Apt 11ScottsdaleAZ85244··GRP-1800MEDICARE-ADV-B
ENRENR-1167402026-05-23T12:37:37ZMATEOY.MITCHELL19830913UHC-96273-93•••-••-0269291.708.0633MATEO.MITCHELL35@AOL.COM8102 Forest AvenueEden PrairieMN55382GRP-2111MEDICARE-ADV-B
ENRENR-1317372026-04-11T07:35:46ZADAMDTAYLOR1958-11-06··UHC-10122-04•••-••-3642(839) 900-4971N/A5074 Ocean Avenue #916ScottsdaleAZ85252GRP-3622SELECT-EPO
ENRENR-1119512026-04-10T06:25:23ZJoyceH.··Patterson··1973-07-17UHC-06691-69•••-••-75172577197097joyce.patterson25@outlook.com4507 Highland AveSan AntonioTX78278GRP-2503NAVIGATE-HMO
ENRENR-1325872026-09-21T14:52:58ZWALTERN.HARVEY1993-04-04UHC-72900-01•••-••-7675221-375-3520walter.harvey@hotmail.com7007 HARBOR BLVDGilbertAZ85214·GRP-4674MEDICARE-ADV-A
ENRENR-1295242026-09-24T22:12:17ZPayne, Wayne——1943-03-23UHC-02376-16•••-••-1648911-724-0489wayne.payne@icloud.comUNKNOWNN/A-—GRP-5176NAVIGATE-HMO
ENRENR-1147492026-01-25T20:34:06ZYUKIL.YANG·1951-02-25UHC-67697-54•••-••-88384204910984yuki.yang@hotmail.com5848 Washington StSan AntonioTX78247GRP-4616MEDICARE-ADV-B
ENRENR-1126952026-08-16T23:29:54ZBRYAN—GONZALEZ1964-07-25—UNKNOWN890-875-7716bryan.gonzalez38@outlook.com5607 Desert Sky BlvdPhoenixAZ85041GRP-6286MEDICARE-ADV-A
ENRENR-1398652026-03-07T14:24:21Z·Ruiz, Smantha—····1978-04-18UHC-04065-77•••-••-80092504472466samantha.ruiz@aol.com3319 Harbor BlvdSAN ANTONIOTX·78295GRP-0334CHOICE-PLUS-PPO
ENRENR-1073952026-02-24T23:41:54ZJESSICA—TAYLOR1952-02-22UHC-33596-12•••-••-1156·344-890-0471jessica.taylor66@icloud.com2381 LINCOLN WAYNashvilleTN·37246GRP-1811MEDICARE-ADV-B
ENRENR-1083502026-01-12T17:11:41ZCharlotte—Green1989-07-24UHC-29473-65•••-••-0022+1 394 442 2474charlotte.green@gmail.com5098 BASELINE ROAD·DenverCO80212GRP-4500MEDICARE-ADV-A
ENRENR-1140132026-04-12T05:22:48ZMARCUS—YANG1963-12-06UHC9794747N/A5212322900NULL9784 Maple AvenueTampaFL33684GRP-8518CORE-HMO
ENRENR-1324322026-03-27T14:42:40ZAmyTOliiver1964-04-19UHC-18678-76•••-••-0273742-558-5921amy.oliver@hotmail.com6412 Meadow LnColumbusOH43278GRP-3259CORE-HMO
ENRENR-1088712026-04-21T14:57:22ZDIANA—ESTRADA1996-11-10UHC-89971-19NULL15762514278DIANA.ESTRADA@GMAIL.COM··2583 Harbor BoulevardEden PrairieMN55397GRP-2150CHOICE-PLUS-PPO
ENRENR-1127352026-05-20T08:12:37ZJamesB.Aguilar·1996-05-17UHC-01258-69•••-••-2209(411) 732-5497N/A6531 Meadow LaneGLENDALEAZ85395GRP-9755SELECT-EPO
ENRENR-1159342026-03-07T03:40:57ZABIGAILMFOWLER01/20/1967UHC-50189-14UNKNOWN5052924447abigail.fowler7@hotmail.com6693 Sage Court··MiamiFL33172GRP-9138CHOICE-PLUS-PPO
ENRENR-1261862026-08-07T01:14:38ZZACHARYX.MEJIA1961-08-07UHC-08699-24•••-••-2282·464-426-0763UNKNOWN4300 MESA DRDenver··CO80246GRP-7939navigate-hmo
ENRENR-1141122026-05-30T13:41:19ZGloria A—Lnua2000-10-22UHC-66011-86•••-••-06858468266485··gloria.luna70@outlook.com104 Ocean AveSan AntonioTexas78221GRP-8526CHOICE-PLUS-PPO
ENRENR-1095292026-06-25T12:16:15ZNathan—Singh01/14/43UHC-25477-01•••-••-6505383-350-2796nathan.singh@gmail.com6404 Park PlaceMinneapolisMN55484·GRP-5446MEDICARE-ADV-B
ENRENR-131024 2026-01-11T09:03:49ZEMMA··WKIM1960-10-12UHC-21805-55•••-••-92772528356406emma.kim@yahoo.com6430 WASHINGTON STREETPhoenixArizona85093GRP-0385NAVIGATE-HMO
ENRENR-1132282026-09-20T03:22:53ZAMBER—HAMILTON1974-09-16UHC-67162-01•••-••-6308(872) 227-7065AMBER.HAMILTON23@YAHOO.COM6618 MAPLE AVENUESan DiegoCalifornia92172GRP-6839OPTIONS-PPO
ENRENR-1191242026-09-20T23:00:47ZMichael·K.Young1954-12-19UHC-00382-28•••-••-9867+1 600 344 7974michael.young@hotmail.com2952 Palm DriveMESAaz·85236GRP-3940·NAVIGATE-HMO
ENRENR-1102752026-03-12T21:34:01ZJeffreyFHanson12/22/61·UHC-29874-41•••-••-82866779313774—4192 Maple AveTAMPAFL··33604GRP-4131MEDICARE-ADV-A
ENRENR-1020062026-08-08T01:05:17ZMARIAPPETERSON1984-06-19UHC-70195-31•••-••-5857+1 810 434 9538-9048 Lake View RoadTempeAZNULLGRP-0346MEDICARE-ADV-B
ENRENR-1050052026-08-04T16:47:36ZAnna—Armstrong05-07-2002UHC-24555-91•••-••-73684383975442anna.armstrong@yahoo.com2216 Willow CourtPlanoTX75064GRP-7360MEDICARE-ADV-B
ENRENR-1372952026-08-31T03:55:21ZElijahSHall0276-19-73-—472-251-0367ELIJAH.HALL91@OUTLOOK.COM··9680 Elm StreetNashvilleTN37232GRP-0763NAVIGATE-HMO··
ENRENR-1058952026-08-14T18:42:05Z Luna·IGregory2002-09-09UHC-29698-66•••-••-6123·346-835-0435null1516 Market StreetTEMPE·AZ85251··GRP-6337MEDICARE-ADV-A
ENRENR-1072782026-01-03T09:35:32ZLarryW.Spencer1976-10-23UHC-16960-57•••-••-9130+1 324 426 3912larry.spencer@proton.me-———GRP-9754SELECT-EPO
ENRENR-1347442026-06-30T03:14:21ZKathleenMMiller10/03/1944··UHC-61179-15•••-••-2808·646.697.3331kathleen.miller@aol.com6044 SAGE COURT Apt 14SacramentoCA··95834GRP-7472CORE-HMO
ENRENR-1148732026-07-31T02:49:26ZMARYVFERGUSON1975-01-63-•••-••-9626918-806-5515MARY.FERGUSON60@AOL.COM1945 Meadow LnSEATTLEWA98197GRP-8088CHOICE-PLUS-PPO
ENRENR-1168302026-09-12T22:43:56ZMADISONCRIICHARDS11/09/46UHC-62417-20—4209473320·MADISON.RICHARDS40@OUTLOOK.COM4785 Cedar LnGILBERT··AZ··85276GRP-4306SELECT-EPO
ENRENR-1265142026-10-15T03:38:32ZSusan—YangJan 13, 2000UHC-21009-42•••-••-3788(476) 986-9935susan.yang@yahoo.com3414 CHURCH ST Apt 12JacksonvilleFL32295-6661··GRP-6365NAVIGATE-HMO
ENRENR-1309242026-07-05T17:31:51ZDORISX.TORRES1988-08-17UHC-69907-96•••-••-5489(524) 391-1523doris.torres@aol.com7807 SUNSET BOULEVARDPhoenix·AZN/AGRP-3197OPTIONS-PPO
ENR ENR-1225062026-06-26T13:51:25ZMAONOTHOMPSON12-11-1973UHC-69452-86•••-••-4076··-3206 Willow CourtTucsonAZ85745GRP-1486NAVIGATE-HMO
ENRENR-1344422026-10-06T07:27:38Z·DebarS.Henry1975-09-24UHC1894866•••-••-61446483032290NULL3297 Cedar LnHoustonTexas77015GRP-0431OPTIONS-PPO
ENRENR-1196692026-01-20T03:27:30ZKathrynT···Gonzalez1988-08-13·UHC-91606-76•••-••-4524601-998-2729KATHRYN.GONZALEZ79@OUTLOOK.COM4472 Main St Apt 35·MinneapolisMN55483GRP-4783medicare-adv-a
ENR ENR-1096512026-04-24T12:41:40ZMEI—RYAN1977-12-11UHC-76121-14•••-••-5080+1 325 358 7505MEI.RYAN17@OUTLOOK.COM2450 Market StMESAAZ85244GRP-0264OPTIONS-PPO
ENRENR-1428082026-04-14T17:11:43ZMartin, SamanthaU—12/18/86UHC-06474-19•••-••-7990827-712-2983samantha.martin53@proton.me9519 JEFFERSON AVEEden PrairieMN··55332GRP-4570NAVIGATE-HMO
ENRENR-1126272026-08-03T01:35:56ZSantiagoTCole1978-07-01UHC-58427-78•••-••-59745073568422SANTIAGO.COLE43@GMAIL.COM6345 Valley View DrPhoenixAZ85045GRP-9154CHOICE-PLUS-PPO
ENRENR-1373522026-07-31T01:50:11ZMARTHAT.BLACK07/25/79UHC-60855-59•••-••-4498727-574-1569—4783 River Road··MinneapolisMinnesota55407·GRP-2562CORE-HMO
ENRENR-1067842026-01-02T03:35:45Z·DENISEL.MORGAN12/27/1995UHC-49964-55•••-••-208615346232496—5211 Harbor Blvd Apt 36HoustonTX77085-9911GRP-2395MEDICARE-ADV-A
ENRENR-1073702026-08-31T17:51:44ZJoshuaTJohnston2001-01-19UHC-20659-99··•••-••-73797685883071JOSHUA.JOHNSTON@GMAIL.COM6768 JEFFERSON AVEEden PrairieMN55369GRP-9044SELECT-EPO
43,101 rows, page 188 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.325Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty