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-1386592026-03-29T22:53:58ZTimothyU.JacobsAug 19, 1944UHC-20013-02•••-••-473614835536919NULL2140 PALM DRGILBERTAZ85240GRP-8457MEDICARE-ADV-B
ENRENR-1279252026-02-08T03:12:09ZSEANJ.LE5/23/1995UHC-51623-66•••-••-0669(958) 562-4543SEAN.LE74@OUTLOOK.COM465 Willow CtAUSTINTexas··78743GRP-3510CHOICE-PLUS-PPO
ENRENR-1333722026-06-04T05:49:09ZReed, Scott——1965-09-13UHC-22245-78•••-••-0556660-649-6281—9322 Lincoln Way Apt 24DenverColorado80259GRP-0562··MEDICARE-ADV-B··
ENRENR-1319662026-07-06T10:04:45ZDOUGLAS—WRIGHT1980-08-10·N/A•••-••-1602487.677.6455—·3478 Mountain View DrLAS VEGASNV89103-7405GRP-4124CORE-HMO
ENRENR-1324732026-06-25T15:19:22ZMichael—Carroll1945-03-04UHC-06684-18•••-••-0986+1 808 730 5597michael.carroll73@hotmail.com5576 Indian School RdTempeAZ85247GRP-1498OPTIONS-PPO
ENR ENR-1042272026-06-24T14:22:52Z Buurke, AdamH·····1940-09-04UHC-31213-74•••-••-7408(592) 484-3277null1835 Hillcrest RdNashvilleTennessee37249GRP-6748MEDICARE-ADV-B
ENRENR-1151352026-01-10T00:47:53ZHarrison, StevenN.—16-10-1963··UHC-95603-45•••-••-8866N/Asteven.harrison18@hotmail.com5754 Church Street·CHANDLERaz85237GRP-9970MEDICARE-ADV-B
ENRENR-1249352026-10-14T22:16:02ZSharonS.Maldonado10/27/1938UHC-77322-66•••-••-4372——2247 Palm DriveJACKSONVILLEfl32250GRP-9763OPTIONS-PPO
ENRENR-1178212026-08-20T04:36:31ZKEITH—BANKS1959-07-01UHC-64031-66•••-••-99724206415138KEITH.BANKS16@HOTMAIL.COM8804 Camelback RoadLas VegasNV89171GRP-8619OPTIONS-PPO
ENRENR-1221802026-07-06T22:33:50ZCharlotteX.James1991-08-17UHC-14077-28•••-••-2558(946) 705-3438—372 Market St Apt 11TampaFlorida33607GRP-2461CORE-HMO
ENRENR-1022622026-05-26T02:01:52Zroy···Kmorrison1998-02-12UHC-82890-22•••-••-4975·655-213-5358roy.morrison@gmail.com4630 Pine DrJacksonvilleFL32266GRP-3330CHOICE-PLUS-PPO
ENRENR-1146942026-07-04T07:13:41ZBryan··—Garrett1986-03-15UHC-88623-17-8317962876··BRYAN.GARRETT@YAHOO.COM8805 BroadwayCharlotteNC28207GRP-6126OPTIONS-PPO
ENRENR-1003632026-09-22T07:42:58Zanngela—bryantApr 6, 1938UHC-22165-57•••-••-3352—·ANGELA.BRYANT@HOTMAIL.COM9768 SPRING STMesaAZ85236GRP-0135SELECT-EPO
ENRENR-1093372026-01-27T08:14:38ZARTHURRORTIZ06-05-1968UHC-41253-19•••-••-0958(218) 364-1233arthur.ortiz10@aol.com4506 Valley View Dr Apt 1GLENDALEAZ85370GRP-0417CORE-HMO
ENRENR-1412432026-02-27T03:14:21ZJOAN—ELLIOTT5/3/1983UHC-90045-65•••-••-58032212298865—8888 Central AveMIAMIFL33158GRP-2764MEDICARE-ADV-A
ENRENR-1330192026-05-01T08:57:36ZCATHERINEV.·DAY07/04/43··UHC-08875-72•••-••-4980(698) 727-7846catherine.day@hotmail.com·5538 GRAND AVEPlanoTX75047GRP-7016MEDICARE-ADV-A
ENRENR-1138102026-09-04T02:43:15ZSarah·YAustin19390722UHC-41524-15··•••-••-3928(764) 709-8002SARAH.AUSTIN9@GMAIL.COM6125 Harbor Boulevard Apt 29HoustonTX—GRP-8185MEDICARE-ADV-A
ENRENR-1111482026-09-05T16:32:27ZRoy—Mendez1973-06-03UHC-66622-59UNKNOWN-ROY.MENDEZ99@OUTLOOK.COM9188 Elm StreetMinneapolisMN55499GRP-4999MEDICARE-ADV-A
ENRENR-1370252026-02-14T03:32:33Zdorothy—ortega19701707UHC-76525-44•••-••-8432(563) 914-5188DOROTHY.ORTEGA86@ICLOUD.COM3937 CEDAR LANEChandlerAZ·85261GRP-0399CHOICE-PLUS-PPO
ENRENR-1191392026-09-16T17:15:49Zisabella··Asanchez1952-07-26UHC0790491•••-••-256519575266463ISABELLA.SANCHEZ@OUTLOOK.COM··3413 Valley View DriveSan AntonioTX78284GRP-0129MEDICARE-ADV-A
ENRENR-1410482026-02-03T23:53:07ZEvelyn—Pak1965-01-24UHC-44290-82•••-••-6812—EVELYN.PARK62@AOL.COM732 Hillcrest RdScottsdaleAZ85236GRP-7086CHOICE-PLUS-PPO
ENRENR-1107042026-01-22T09:47:45ZJason—Mason1983-09-02UHC-84953-50··—+1 527 880 8118jason.mason16@gmail.com6011 Washington StSACRAMENTOCA95800··GRP-9555OPTIONS-PPO
ENRENR-1430322026-06-23T21:05:20ZFatima—Vargas20020111UHC-02626-87•••-••-91333893628436fatima.vargas66@yahoo.com1022 MEADOW LN Apt 36Los AngelesCA90093GRP-8359NAVIGATE-HMO
ENRENR-1064032026-02-08T01:32:49ZDonnaG.Clark02/28/42UHC-07526-15•••-••-6177771-337-8828NULL6773 INDIAN SCHOOL ROADMINNEAPOLISMN55407GRP-4003NAVIGATE-HMO
ENRENR-1183982026-06-14T07:31:32ZmikeN.franklin1977-08-13UHC-12780-16•••-••-607012815891955null4937 Canyon Rd·PlanoTexas75059GRP-0398MEDICARE-ADV-B
ENRENR-1032662026-05-15T19:58:02ZBennett, Randy··C—18-10-1985UHC-58759-94•••-••-7228605.664.3384··randy.bennett@gmail.com161 Union StreetLOS ANGELESCA90040GRP-6541CORE-HMO
ENRENR-1321652026-04-03T11:50:38ZHEATHER··QMORENO1963-08-07UHC-49093-34•••-••-0384873-461-2717HEATHER.MORENO43@PROTON.ME2841 Lake View RoadSAN DIEGO·California92191·GRP-1493SELECT-EPO
ENR ENR-1175832026-04-13T04:27:42ZvirginiaBrice1966-10-24·UHC-38636-83•••-••-6483—null7413 OCEAN AVENUELas VegasNV89148GRP-8304SELECT-EPO
ENRENR-1200872026-04-03T01:39:27ZJACQUELINE—HANSEN12/04/1978UHC-13034-91•••-••-24286756564710JACQUELINE.HANSEN@OUTLOOK.COM9569 Desert Sky BoulevardNashvilleTN37294GRP-3773SELECT-EPO
ENRENR-1301492026-09-06T01:00:43ZHANNAH··Q.CRAWFORD·Oct 15, 1989NULL•••-••-1677(545) 535-6644····3271 Broadway Apt 19ChandlerAZ··85208GRP-4604OPTIONS-PPO
ENRENR-1094552026-03-14T04:42:16ZMason—Mitchell09/23/81UHC-11047-22··•••-••-8271836-629-7454UNKNOWN8653 Union Street Apt 14MinneapolisMN··55497GRP-2565MEDICARE-ADV-A
ENRENR-1405112026-01-09T20:34:25ZSantosHGrace1970-26-27UHC-38799-01•••-••-18575604733272-1178 CENTRAL AVEAUSTINTX78779GRP-8804OPTIONS-PPO
ENRENR-1303072026-05-19T18:25:43Z ·SantiagoO.Foster1987-03-15UHC-08857-93null17864705098NULL6861 Ridge RdEden PrairieMNUNKNOWNGRP-0489NAVIGATE-HMO
ENRENR-1380562026-03-17T02:58:11ZBRYANSHART1939-02-13UHC4030797•••-••-440016103510985BRYAN.HART@GMAIL.COM1403 Park PlMinneapolisMN55440-9454GRP-1571·CHOICE-PLUS-PPO
ENRENR-1270262026-07-31T18:09:55ZReed, JoshuaR.—·1964-07-11UHC2757159•••-••-159614596368811UNKNOWN4407 SAGE COURTAustinTX78721GRP-0664CHOICE-PLUS-PPO
ENRENR-1329652026-01-30T04:42:30ZPeterH.Weber1994-11-15UHC-47607-12•••-••-9056467-586-0424UNKNOWN4643 Canyon RoadMinneapolisMN55487··GRP-0337CHOICE-PLUS-PPO
ENRENR-1311772026-05-26T07:23:31Z marcO··baarnes18-12-1976UHC-28940-99•••-••-78052998604333marcus.barnes35@gmail.com5166 INDIAN SCHOOL RDGilbert··AZ85294GRP-4737options-ppo
ENRENR-1073692026-09-06T21:12:05ZADAM—VASQUEZDec 15, 1978UHC-91157-09··—(397) 428-7745adam.vasquez@aol.com9625 HILLCREST ROADCHARLOTTENC28263GRP-0117MEDICARE-ADV-A
ENR ENR-1413512026-03-13T14:36:02ZKeithTBlackJun 7, 1995UHC-03770-61•••-••-4343··keith.black@aol.com6161 Church StMiamiFlorida—GRP-0700OPTIONS-PPO
ENRENR-1148132026-09-28T12:54:36Zadam—bailey1993-04-26UHC-28602-56•••-••-85405936105188adam.bailey@outlook.com8267 Sage CtFresnoCA93726GRP-0905··CORE-HMO
ENRENR-1109252026-02-25T05:17:53Z HELEN—·SPENCER1939-09-05UHC-12971-42•••-••-6408394-537-2124HELEN.SPENCER@AOL.COM3371 Meadow Lane Apt 40ORLANDOFL32807GRP-0708SELECT-EPO
ENRENR-1059782026-03-20T09:14:52ZLISANSYLVA2002-04-16UHC-88580-44•••-••-5377839.390.3031lisa.silva72@yahoo.com6174 Willow CtColumbusOH43235GRP-4998CORE-HMO
ENRENR-1136052026-01-06T00:01:59ZJAKEBCOLLINS07/06/1952UHC-09689-71··•••-••-9105·(726) 217-7422N/A2742 Oak StGilbert···AZ85230GRP-2157CHOICE-PLUS-PPO
ENRENR-1399172026-02-11T06:58:48Z HannahLOliver·Feb 16, 2001UHC-68626-53•••-••-3298·6804366562NULL178 CANYON ROAD #242OrlandoFL··32808GRP-2636MEDICARE-ADV-A
ENRENR-122652 2026-03-07T01:14:44ZJudith—Cole1994-02-04UHC-18901-24•••-••-65985374340268··NULL-—N/A—GRP-6392SELECT-EPO
ENRENR-1378512026-05-31T16:46:45ZAndrea—Espinoza·04/26/75UHC-67937-38•••-••-539013258427741andrea.espinoza@proton.me1525 Canyon RdGlendale··AZ85359··GRP-6808core-hmo
ENRENR-1059272026-08-02T14:20:27ZKathleenZSandoval1960-25-14UHC-84252-16•••-••-8227789-235-2194kathleen.sandoval@aol.com5904 CENTRAL AVENUETEMPEAZ85242GRP-2515CHOICE-PLUS-PPO
ENRENR-1429942026-06-19T16:23:56Z·AARONT.ALEXANDER07/23/93UHC-25370-27•••-••-52425785142617aaron.alexander11@gmail.com5873 UNION STTampaFL33615GRP-4246SELECT-EPO
ENRENR-1114182026-09-14T15:35:45Z Alan—Wright1989-12-18UHC-55110-52•••-••-84458023353758alan.wright26@icloud.com3178 Lincoln Way··Seattle··Washington98157·GRP-2716MEDICARE-ADV-A
ENRENR-1078322026-01-29T19:07:48ZMARYF··GARRETT19970515··UHC-41408-06•••-••-64933553547487UNKNOWN5195 MAPLE AVETempeAZ85265GRP-2078NAVIGATE-HMO
43,101 rows, page 122 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:37.763Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty