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-1020482026-08-21T16:29:18ZAndreaFHarvey1969-06-15UHC-18716-94•••-••-27476706982879—2003 MEADOW LNLos AngelesCA90064GRP-5795NAVIGATE-HMO
ENRENR-1162192026-07-20T22:29:26ZJUSTIN—GONZALES1962-09-12UHC-43830-36•••-••-0143576-234-2993—2916 BROADWAYSeattleWA98115··GRP-5460CHOICE-PLUS-PPO
ENRENR-1191412026-05-30T12:30:43ZJudith—Howell02-05-1993··UHC-20985-03•••-••-5587554.478.3967JUDITH.HOWELL@AOL.COM5164 Park PlaceHoustonTX77081GRP-7326MEDICARE-ADV-B
ENRENR-1332112026-06-26T02:01:28Zjoan··Fsntos01/04/1978UHC-63620-14•••-••-2483NULL—8108 Ridge Rd Apt 2DallasTX·75208GRP-9593SELECT-EPO
ENR ENR-1022232026-07-04T08:00:14ZSEANMNUNEZ1997-10-03UHC-98948-59—442-515-0403sean.nunez70@proton.me4431 Forest AvenueFresnoCA93704GRP-3779OPTIONS-PPO
ENRENR-1227712026-03-13T02:09:06ZJULIA—HERNANDEZ01/22/1968·UHC-90008-83•••-••-31802602121968-789 Canyon RdOrlandoFLnullGRP-5354CHOICE-PLUS-PPO
ENRENR-1426272026-08-13T13:59:54ZJUAN··SNYDER·1939-04-17UHC-15581-31-9678554juan.snyder@gmail.com7663 SPRING STREETLas VegasNV89164GRP-7929CHOICE-PLUS-PPO
ENRENR-1105582026-01-15T11:40:12ZStephenW·Herrera1949-10-11N/A•••-••-821617542809782stephen.herrera@icloud.com3354 GRAND AVENashvilleTN37254GRP-2713SELECT-EPO
ENRENR-1319262026-04-17T22:35:37Z Grace—Payne25-11-1973UHC-34652-72•••-••-5909504-874-8926—4276 DESERT SKY BOULEVARDSAN ANTONIOTX78287GRP-9284NAVIGATE-HMO
ENRENR-1128132026-08-22T20:02:41Z·thomas—kniht07/28/1978UHC-83731-45•••-••-4515nullTHOMAS.KNIGHT@AOL.COM6318 MOUNTAIN VIEW DRIVELas VegasNV89122GRP-7363··CORE-HMO
ENRENR-102950 2026-04-12T17:35:55ZJordan—Gardner26-01-1961UHC-08053-83•••-••-8461850-396-6253jordan.gardner69@proton.me2247 Sage Ct·Las VegasNV89127GRP-2002SELECT-EPO
ENRENR-1374622026-08-23T12:38:50Z·frances—lee05/01/1957UHC-90770-55•••-••-8397462.797.8086FRANCES.LEE@HOTMAIL.COM2460 Jefferson AveChandlerAZ85252GRP-0673SELECT-EPO
ENRENR-1223502026-08-05T19:12:11ZKEVINGDAY1994-04-10UHC-09372-85•••-••-1539——8737 Meadow LanePLANOTX75023-7950GRP-5836CHOICE-PLUS-PPO
ENR ENR-1045702026-06-08T13:22:30ZCARLMROBERTSON—UHC-16735-84•••-••-9507+1 532 284 9643carl.robertson39@proton.me3388 Jefferson AvenuePhoenixArizona85003GRP-3572SELECT-EPO
ENRENR-1102542026-03-29T04:24:21ZEmilyBGibson1977-10-15UHC-33914-45··N/A5169147893·emily.gibson15@icloud.com960 PALM DRIVE Apt 15FresnoCalifornia··93744GRP-9177SELECT-EPO··
ENRENR-1057312026-07-30T01:27:47ZRANDY—CASTRO1969-09-18UHC-12260-95•••-••-3331(289) 544-6528randy.castro91@hotmail.com8169 Oak StLas VegasNVnullGRP-9918SELECT-EPO
ENRENR-1141492026-04-15T06:08:11ZBettyFScott1997-04-26··UHC-67968-32null323-239-4648betty.scott65@outlook.com·9740 APACHE BOULEVARDChandlerAZ85288GRP-1854OPTIONS-PPO
ENRENR-1216252026-09-20T06:03:08ZFATIMAPSANDERS1958-04-02UHC-05917-75··•••-••-9951·3886008236fatima.sanders59@outlook.com283 Meadow LaneAustinTX78770-5855GRP-6888SELECT-EPO
ENRENR-1162462026-03-02T11:07:17ZALBERT—ADAMS1993-05-20UHC9620875•••-••-4980(329) 666-8359·albert.adams@yahoo.com3174 Willow Ct··San DiegoCA92146··GRP-2987NAVIGATE-HMO
ENRENR-1055712026-09-23T07:30:29ZGRACEB.RYAN1984-09-27UHC-34087-82•••-••-3422+1 482 884 4407grace.ryan79@proton.me4892 Grand AvenueNashville··TN37277GRP-8943MEDICARE-ADV-A
ENRENR-1182442026-02-08T02:53:31ZBruce—Banks6/21/1983··UHC-96150-75•••-••-3666(351) 586-0335null5040 Harbor Blvd·AtlantaGA30334GRP-5797MEDICARE-ADV-B
ENR ENR-1186152026-02-11T06:00:09ZMariaZLarson05/07/1943·UHC-77438-22•••-••-6173—MARIA.LARSON17@HOTMAIL.COM3626 UNION STREETSeattleWA·98192GRP-9002OPTIONS-PPO··
ENRENR-1140702026-08-12T23:59:26ZCAMILA··—KNIGHT2/1/1975UHC-56856-16•••-••-03449185685593camila.knight@outlook.com531 BASELINE ROAD Apt 2CHARLOTTENC28297GRP-8442CHOICE-PLUS-PPO
ENRENR-1211162026-05-17T16:03:33ZThomas, Raymond——1966-03-27UHC-02723-41•••-••-24878274614635RAYMOND.THOMAS54@GMAIL.COM··7605 Harbor BoulevardPhoenixAZ85007GRP-4847medicare-adv-a
ENRENR-1316792026-05-04T08:24:09ZMichael—·Porter2003-09-12UHC-50791-32•••-••-84564312582237michael.porter@aol.com6745 CHURCH STDenverCO80203GRP-0219·SELECT-EPO
ENRENR-1319402026-08-10T23:11:03Z Howard, RuthX—1995-01-05UHC-04494-26•••-••-62032024675UNKNOWN8779 Camelback RoadOrlandoFL32869GRP-8218··CHOICE-PLUS-PPO
ENRENR-1233932026-04-07T07:47:00ZMariaVWagner1983-05-02UHC-23015-94•••-••-9065+1 405 917 9634maria.wagner9@hotmail.com4726 VALLEY VIEW DRIVE Apt 13··Orlando·FL32877GRP-4548CORE-HMO
ENRENR-1143982026-09-12T19:50:54ZDanielBSimpson···Feb 2, 1993UHC-88269-52-3575368442daniel.simpson10@aol.com9741 MESA DRIVESeattleWA98190GRP-4744MEDICARE-ADV-A
ENR ENR-1143922026-02-14T20:57:36ZROBERT··VMURRAY1960-04-28UHC-06624-68NULL12265750560ROBERT.MURRAY@PROTON.ME8849 MESA DRIVETampaFL33680GRP-3661MEDICARE-ADV-B
ENRENR-1240162026-10-13T22:21:31ZJeremyERomero1983-01-03UHC-88992-26•••-••-8585780-752-9557·jeremy.romero56@proton.me6792 Church StreetJacksonvilleFL32239GRP-4588NAVIGATE-HMO
ENRENR-1188782026-03-20T00:11:23ZKathryn—Nunez·27-11-1984UHC-98186-22•••-••-54517087994006—3733 Meadow LaneLos AngelesCA90025GRP-7586CORE-HMO
ENRENR-1231782026-07-09T11:20:41ZANDREWDLAWIS8/3/1954UHC-15384-70•••-••-3223487-522-4917andrew.lewis87@gmail.com1089 Willow CtTampaFL33670GRP-9954CHOICE-PLUS-PPO
ENRENR-1118922026-05-07T02:50:05ZAnnaJAllen07/07/1977UHC-01802-26•••-••-7296N/AN/A4429 MESA DRIVE Apt 26TempeArizona85289GRP-3404MEDICARE-ADV-A
ENRENR-1089162026-07-28T22:28:21Z Amy—Andrews1968-08-10UHC-27865-67•••-••-3089N/AAMY.ANDREWS36@OUTLOOK.COM6269 Market StreetMinneapolismnUNKNOWNGRP-6058·MEDICARE-ADV-B
ENRENR-1078162026-08-16T20:51:27ZFRANCES··ANDERSON05-02-1976UHC-49348-09•••-••-0100324-834-6442······7806 Market StDallasTexas75260GRP-5859MEDICARE-ADV-A
ENRENR-1113152026-02-05T09:52:51Z Joshua—Holmes20-04-1977·UHC-28099-06null+1 719 708 6582joshua.holmes@outlook.com7245 River RoadGlendaleAZ85336GRP-9480NAVIGATE-HMO
ENRENR-1238142026-07-18T20:26:28Z JASON—BRYANTDec 1, 1955UHC9783697—(595) 389-7036··JASON.BRYANT@GMAIL.COM4131 Market StChandlerArizona85216GRP-3910·choice-plus-ppo
ENRENR-1294382026-05-10T01:18:35ZJoshuaR.Brown1941-01-13UHC-44263-86•••-••-1178(845) 248-9238JOSHUA.BROWN@YAHOO.COM5027 MOUNTAIN VIEW DRIVE Apt 10TempeAZ85246GRP-7449OPTIONS-PPO
ENRENR-1057022026-01-31T21:33:34ZBRENDAY.WALSH1988-04-20UHC-09527-12•••-••-31545647345428brenda.walsh67@proton.me8975 Cedar LaneSACRAMENTOCA95805GRP-7988MEDICARE-ADV-A
ENRENR-1320352026-06-02T01:37:33Z KELLYAMUNOZ07/06/71UHC-16171-83—610-953-5292KELLY.MUNOZ@OUTLOOK.COM997 Bayshore DriveTempeAZ85247GRP-6319core-hmo
ENRENR-1131772026-05-11T12:04:35ZPatrickEPeters1944-02-03UHC-27180-63•••-••-7285NULLpatrick.peters78@icloud.com3967 Willow CtGLENDALEAZ85346GRP-0521CORE-HMO
ENRENR-1124422026-05-03T04:01:39ZPATRICKO.JONES1960-04-02··UHC-31564-40•••-••-6236437.920.1990PATRICK.JONES47@PROTON.ME4740 CANYON RD··Charlotte·NC28245GRP-3400CHOICE-PLUS-PPO
ENRENR-1256042026-08-31T02:32:04Z·ROBERT—HANSEN4/9/1977UHC-07624-17—NULLrobert.hansen@outlook.com3895 Mesa DriveFresnoCA93759GRP-0329OPTIONS-PPO
ENRENR-1171882026-06-14T11:21:37Z·cynthia—mejia1957-06-17UHC8000611-·5234744072CYNTHIA.MEJIA15@ICLOUD.COM·8021 Spring StAustinTX78792GRP-3720CORE-HMO
ENRENR-1098142026-05-20T17:14:18ZmeganA·rivera1971-12-11··UHC-47269-27•••-••-6972900-557-1687··4402 Elm StSan AntonioTX78286GRP-8200OPTIONS-PPO··
ENRENR-1073772026-04-07T23:18:01ZCARLVSIMPSON1996-07-23UHC-92604-46N/A··2286672223carl.simpson@icloud.com6021 Apache BoulevardGILBERTAZ85292·GRP-8999CORE-HMO
ENRENR-1237882026-07-29T07:24:13ZKATHRYN—JENKINS1979-07-12UHC-10064-66•••-••-10844104585436··KATHRYN.JENKINS@OUTLOOK.COM5752 CAMELBACK ROADAustinTX78731GRP-6837MEDICARE-ADV-B··
ENR ENR-1059092026-04-12T16:27:45ZNatalieN.King1946-01-09UHC-53620-37•••-••-6898434-783-6508natalie.king@gmail.com5353 Valley View DrMesaAZ85256GRP-5298NAVIGATE-HMO
ENRENR-1004572026-05-09T01:09:42ZJACKIETJOHNSTON8/7/1999UHC5632370··•••-••-13679353383997-568 JEFFERSON AVEPLANOTexasnullGRP-2650MEDICARE-ADV-B
ENR ENR-1020032026-07-09T23:00:07ZSOPHIA—KNIGHT6/2/1952UHC-81254-07-+1 777 244 6323sophia.knight@outlook.com··6841 BAYSHORE DRTampaFL33637GRP-9276NAVIGATE-HMO
43,101 rows, page 165 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:38.494Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty