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-141400 2026-06-11T03:59:47ZAnnO.YangDec 23, 2005UHC-10737-46•••-••-13827524101002ann.yang3@yahoo.com8622 Union StMesaAZ85243GRP-2258MEDICARE-ADV-B
ENRENR-1391112026-09-03T11:48:58ZRuiz, Yuki——19720321UHC-19041-11··•••-••-29023605516yuki.ruiz22@gmail.com6056 Ridge RoadNASHVILLETN37257··GRP-5255··NAVIGATE-HMO
ENRENR-1103322026-04-07T16:11:03ZraymondSdelgado··1975-12-28UHC-13862-33•••-••-0904+1 443 830 5646raymond.delgado@gmail.com873 Mountain View DriveJacksonvilleFL32230GRP-1973MEDICARE-ADV-A
ENRENR-1425882026-04-19T07:09:46ZTimothy—Ruiz1954-03-13UHC-03420-49··•••-••-70186723872551TIMOTHY.RUIZ14@OUTLOOK.COM··5283 Bayshore DrGilbertAZ85274GRP-9272MEDICARE-ADV-A
ENRENR-1107532026-07-28T17:14:22ZRyan—Graham7/9/1972UHC-26938-57•••-••-1945338-964-3307ryan.graham85@hotmail.com2179 River Road·DenverCO80267GRP-4201SELECT-EPO
ENRENR-1131012026-08-31T05:10:16ZJose—Carter09/11/1996UHC-93162-93•••-••-8744507-654-5104null··9314 Jefferson AvenueJACKSONVILLEFL·32281GRP-8734MEDICARE-ADV-B··
ENRENR-139930 2026-06-26T14:33:29ZOMARVFISHER·1995-03-19UHC-39161-40—(428) 715-0689OMAR.FISHER40@ICLOUD.COM8386 OCEAN AVENUELas VegasNV89106GRP-2773·NAVIGATE-HMO
ENRENR-1284132026-06-06T15:01:15ZTHOMAS—RODRIGUEZ··Sep 10, 1948UHC-16493-55•••-••-89008356459710thomas.rodriguez26@proton.me6430 Maple AvenueMinneapolis··MN55497·GRP-6907MEDICARE-ADV-A
ENRENR-1233232026-09-13T14:28:20ZbettyX.knight4/12/1943UHC-77127-65•••-••-8926467-978-5368—4717 Indian School RdSacramentoCA95812GRP-8490CHOICE-PLUS-PPO
ENRENR-1330452026-06-27T01:45:52Zvirginia—olson··1966-07-03UHC-98466-07•••-••-0201(340) 940-7031virginia.olson@aol.com8141 Cedar LaneTempeAZ85201GRP-0197MEDICARE-ADV-B
ENRENR-1097862026-01-24T09:13:52ZAngela—·Baker07/15/56UHC-46469-11•••-••-4089443-898-0166ANGELA.BAKER14@OUTLOOK.COM3469 GRAND AVENUEMiamiFlorida33104GRP-9358MEDICARE-ADV-A
ENRENR-1185852026-09-25T13:32:31ZDorothyZ.Boyd1945-09-27UHC-51915-20•••-••-6361967.678.9974dorothy.boyd73@proton.me··7813 LINCOLN WAYSacramentoca95894GRP-3008·NAVIGATE-HMO
ENRENR-1318902026-07-22T23:21:37ZJULIAZLONG07/20/2006UHC-98702-21•••-••-7181641-451-7463julia.long@gmail.com-——nullGRP-9956NAVIGATE-HMO
ENRENR-1390832026-08-12T18:43:05ZNICHOLAS—KELLEY21-09-1946UHC-80488-15N/A·(880) 265-5372N/A9036 Maple AveMinneapolisMN55496GRP-4602MEDICARE-ADV-B
ENRENR-1091672026-10-02T18:37:03ZAndrew—WoodsNov 16, 1973·UHC-68285-69•••-••-6083+1 934 358 2652··andrew.woods73@proton.me872 Union StGilbertAZ85250··GRP-2913NAVIGATE-HMO··
ENRENR-1284042026-02-08T04:30:11ZMarianaGWilson··1947-70-01UHC-28998-30·N/A·3802001109mariana.wilson@gmail.com4779 Canyon RdDALLASTX75272GRP-7709SELECT-EPO
ENRENR-1179352026-05-12T13:09:40ZSamantha—Diaz1998-08-23UHC-92123-72•••-••-60567985037UNKNOWN5983 Cedar LaneNashvilleTennessee37206·GRP-1569MEDICARE-ADV-A
ENR ENR-1325232026-09-16T00:09:51ZMoore, AishhaD.—·11/7/1996UHC-61480-16•••-••-0971784-826-9253AISHA.MOORE84@OUTLOOK.COM7689 Apache BlvdLas VegasNV89140··GRP-1593MEDICARE-ADV-A
ENRENR-1257852026-01-16T06:37:37ZMorales, Hannah——2008-03-17UHC-26431-55··N/A··(636) 316-0943NULL·3620 Main StreetAtlantaGA30316GRP-0686CHOICE-PLUS-PPO
ENRENR-1015122026-05-29T00:45:20ZDONNAQWEAVER01/05/83uhc-86931-10•••-••-5432737-384-1188—8693 Desert Sky BoulevardChandler··AZ85299GRP-6812CORE-HMO
ENRENR-1352062026-04-02T18:01:37ZJoanHMcCoy1940-08-24UHC-51360-90•••-••-8994552-761-0032joan.mccoy@gmail.com5697 Main St··Sacramento··CA95855GRP-3677MEDICARE-ADV-A
ENRENR-1173272026-03-28T13:56:35ZmarcusZbutler1982-06-16UHC-16283-93•••-••-6769452.877.5947marcus.butler57@outlook.com7360 Canyon Rd·San AntonioTX—GRP-5958MEDICARE-ADV-A
ENRENR-1182722026-08-20T21:18:58ZKENNETH—GIBSON5/1/1983UHC-37529-99•••-••-5694N/A··KENNETH.GIBSON@HOTMAIL.COM9424 Central Avenue #543SAN ANTONIOTX78266GRP-5324OPTIONS-PPO··
ENRENR-1111402026-03-19T19:32:54ZDenny—HansonAug 9, 1976·UHC-15271-12•••-••-5620418-248-8366dennis.hanson84@outlook.com4704 Ridge RoadPhoenixAZ85091GRP-9850··MEDICARE-ADV-A
ENRENR-1368942026-06-17T17:41:14ZSandra··—Lane2/1/1941UHC-33329-64•••-••-4484670-360-1291SANDRA.LANE19@HOTMAIL.COM·3444 Canyon RoadFresno·CA93799GRP-5653CORE-HMO
ENRENR-1274012026-01-15T13:48:54ZDENNISMHANSENMay 6, 1940UHC-38793-05•••-••-0228(658) 449-6728dennis.hansen@hotmail.com·9125 Jefferson AvenuePhoenixAZ85058GRP-0968MEDICARE-ADV-B
ENRENR-1157572026-02-27T04:25:54ZAlbert—Butler0620-02-08UHC-78321-66•••-••-94458716909998·null4427 Jefferson AveTEMPEAZ85238GRP-6787choice-plus-ppo
ENRENR-1159402026-09-18T22:19:23Z lawrence··rodriguez1939-09-17UHC-25245-14•••-••-1635·721-464-7303LAWRENCE.RODRIGUEZ@AOL.COM·2258 Church StreetNashvilleTN37277GRP-2579NAVIGATE-HMO
ENRENR-1131632026-01-20T06:59:18ZpaulBmarshall08/08/65UHC-73694-41•••-••-1845·895-658-6819paul.marshall@gmail.com8380 Ocean Ave #276Tampafl33627GRP-0777MEDICARE-ADV-B
ENRENR-1411352026-03-25T17:21:35ZHENDERSONMPAMELA1982-11-18UHC-88764-79•••-••-3115NULLUNKNOWN7821 Hillcrest RoadOrlandoFL32856GRP-3821·NAVIGATE-HMO
ENRENR-1355102026-07-10T03:15:48Z·JeanTDavis1947-11-14UHC-21027-35•••-••-1932648.924.9295jean.davis27@gmail.com5123 FOREST AVENUESACRAMENTO··CA95804GRP-8765NAVIGATE-HMO
ENRENR-1354112026-08-29T04:29:50ZTerry—LeMar 25, 1984UHC-38720-12··•••-••-124712108168784—825 Union StDenverCO80279GRP-4896··NAVIGATE-HMO
ENRENR-1115372026-08-05T02:51:50ZAISHA·ZHERNANDEZ11/18/1983UHC-28782-95•••-••-974613947131223NULL·4309 Mesa DrSeattleWA98167GRP-2111SELECT-EPO
ENRENR-1104622026-08-29T10:11:17ZCYNTHIAILUCAS12/23/64UHC-72108-02•••-••-4380420.236.1988cynthia.lucas@proton.me64 INDIAN SCHOOL ROADMinneapolismn55436GRP-8734medicare-adv-a
ENRENR-1254062026-08-10T11:42:23Z—A—2005-07-19UHC-11787-31•••-••-7537·548.548.9458N/A872 Willow CtLas VegasNV89105GRP-4681MEDICARE-ADV-A
ENRENR-1230552026-04-02T02:54:49ZLuna, Carllos——Nov 5, 1956UHC-61107-88•••-••-3401——8583 JEFFERSON AVENUEDenverCO80271GRP-6083options-ppo
ENRENR-1261892026-04-20T19:38:27ZRodriguez, Judith——19583027—•••-••-9397236-868-9933JUDITH.RODRIGUEZ90@GMAIL.COM3081 SAGE CT·SCOTTSDALEAZ85279GRP-5740OPTIONS-PPO
ENRENR-1402772026-01-12T14:09:04Z MattJBarnes1970-12-14UHC-50903-12•••-••-3717(977) 514-3867matthew.barnes@hotmail.com2666 Indian School RdDallasTX75221GRP-1795··MEDICARE-ADV-A
ENRENR-1220632026-01-11T16:02:46ZMICHELLE P.····REED08/23/62UHC-33270-80•••-••-3685(650) 636-9202MICHELLE.REED@ICLOUD.COM8956 Central AveSAN DIEGO·CA·92173-0488·GRP-7449OPTIONS-PPO
ENRENR-1123292026-08-19T18:48:15ZRALPHR·SIMMONSMay 14, 1962UHC-34659-40•••-••-5131533-606-4870ralph.simmons68@outlook.com6693 Washington StreetSan DiegoCA92176GRP-2068OPTIONS-PPO
ENRENR-1388012026-04-02T17:06:21ZPierce, Lauren——·1975-02-04UHC-58226-07•••-••-35134477615739lauren.pierce62@gmail.com2672 Hillcrest RdColumbus··OH43211··GRP-2077NAVIGATE-HMO
ENRENR-1036702026-04-16T14:40:54ZRoger—Ramirez07/09/89UHC4189242null4152862267N/A6531 Lincoln WayTempeAZ85222GRP-2196MEDICARE-ADV-B
ENRENR-1110632026-06-04T04:02:28ZMATTHEW—·PAYNE1985-11-08UHC-29793-81•••-••-4849645-465-7355MATTHEW.PAYNE@GMAIL.COM5751 Ocean AveChandlerAZ85252-1528GRP-1782·MEDICARE-ADV-A
ENRENR-1217702026-10-02T20:44:19ZEthan—Welch1949-09-13UHC-59122-39•••-••-1343—ETHAN.WELCH@OUTLOOK.COM1962 Mesa DriveSan AntonioTX·78221GRP-3894CORE-HMO
ENRENR-1012892026-02-01T09:07:09Z·WilliamBDaniels1941-08-01·UHC-75567-70•••-••-95825252377028william.daniels77@gmail.com1798 RIDGE ROAD··AustinTX78778GRP-7088OPTIONS-PPO
ENRENR-1201312026-07-06T01:13:22ZKIMBERLYEMARQUEZ1942-05-15UHC-94929-40··•••-••-03889042302544kimberly.marquez@aol.com1432 VALLEY VIEW DRLAS VEGASNV89170GRP-3132OPTIONS-PPO
ENRENR-1343332026-01-08T00:48:53ZAlbert······Hudson1987-02-28UHC-30177-86—(381) 978-4034-5297 OAK STREETTampa··FL33660GRP-6516OPTIONS-PPO
ENRENR-104431 2026-05-26T16:38:30ZSOFIA—CARPENTER··1995-70-07UHC-20485-01•••-••-5404764.742.7104sofia.carpenter@icloud.com4840 Central AveNashville·TN37231-3752GRP-4014··CHOICE-PLUS-PPO
ENRENR-1140622026-06-26T12:51:40ZmarcusM.richards1938-09-07UHC-84572-92null·237.349.7336—5611 HILLCREST RDJacksonvilleFL32242GRP-6745CORE-HMO
ENRENR-1322922026-05-01T19:53:47ZANNAQTHOMAS09/25/41UHC-56472-94•••-••-4327(715) 999-4211anna.thomas40@hotmail.com5238 Washington StColumbusOH43288GRP-1364SELECT-EPO
43,101 rows, page 215 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.358Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty