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-1386392026-09-26T16:24:07ZMegan··—Elliott3/18/1999UHC-54964-91•••-••-4314(260) 756-5704·MEGAN.ELLIOTT36@ICLOUD.COM2593 HARBOR BLVDOrlandoFL32822GRP-2888·MEDICARE-ADV-B
ENRENR-1149472026-07-31T01:28:21Z NathanAHarvey·03/06/1976UHC-45536-99•••-••-701214384618456UNKNOWN3666 LAKE VIEW ROADPhoenixAZ85092··GRP-4101OPTIONS-PPO
ENRENR-1134072026-03-11T19:57:03Z·AliceCLane1961-02-10UHC-89889-41•••-••-2297422-264-6336alice.lane96@icloud.com1232 Mesa Drive #773Nashvilletn37288GRP-3138CORE-HMO
ENRENR-1404082026-02-21T12:14:49ZJulie—Hansen··May 27, 1947UHC-90762-59··•••-••-9213(423) 231-9218julie.hansen@gmail.com7954 Main StreetTucsonArizona85776GRP-5999NAVIGATE-HMO
ENRENR-106529 2026-05-25T12:13:36ZHarvey, ArthurP.—1968-01-28UHC-03671-48•••-••-2261(456) 943-5045ARTHUR.HARVEY86@ICLOUD.COM5009 DESERT SKY BLVDLas VegasNV89143GRP-9184MEDICARE-ADV-A
ENRENR-1023452026-01-01T09:05:12ZJordan—Armstrong·1990-06-22uhc-21547-04•••-••-8728+1 722 496 7167jordan.armstrong12@hotmail.com5162 Bayshore DrSan AntonioTX78276GRP-3190CORE-HMO
ENR ENR-1362232026-10-05T22:52:33Zjulia—long1996-11-22UHC0262016•••-••-7294(906) 345-6768JULIA.LONG@ICLOUD.COM6422 Lincoln Way··MiamiFL33173·GRP-2018CORE-HMO
ENRENR-1386492026-02-26T03:07:14ZMELISSA····BURNS1981-06-05UHC-05550-71•••-••-1570(594) 859-0409melissa.burns52@outlook.com··5052 Willow Ct Apt 2GilbertAZ85218GRP-7394SELECT-EPO
ENRENR-1258332026-01-22T10:38:12Z ThomasF.Smith09/18/1986UHC9559856null··372-894-7313THOMAS.SMITH45@ICLOUD.COM8313 Hillcrest RdLos AngelesCA90031GRP-5416OPTIONS-PPO
ENRENR-100824 2026-06-06T13:39:22ZMichelle··—Payne19860624UHC-32156-45•••-••-580316979038642michelle.payne@outlook.com7765 Baseline RdNASHVILLETN37231GRP-5630OPTIONS-PPO
ENRENR-1371422026-01-19T05:17:33Zdavid··romero2006-04-11UHC-40862-03•••-••-71146739887DAVID.ROMERO@OUTLOOK.COM6332 INDIAN SCHOOL ROADOrlandoFL32899GRP-3609MEDICARE-ADV-B
ENRENR-1120842026-09-03T14:43:18ZStevenH.Gilbert1963-10-24UHC-22739-27-6664356977steven.gilbert64@gmail.com·2769 LINCOLN WAYTampaFL33611GRP-5736NAVIGATE-HMO
ENRENR-1067672026-05-28T00:44:19ZDouglas—Hernandez19451012UHC-13991-22•••-••-6186(262) 391-9056DOUGLAS.HERNANDEZ69@YAHOO.COM1934 Lincoln WaySan AntonioTX78213··GRP-2319MEDICARE-ADV-B
ENRENR-1036132026-06-23T05:06:10ZCynthiaFGeorge08/22/91UHC-29724-43•••-••-4703N/AN/A5169 Spring StOrlandoFlorida32800GRP-3734CORE-HMO
ENRENR-140703 2026-08-13T08:12:48ZAmanda—Andrews10/25/71UHC-57948-95•••-••-09487375028148AMANDA.ANDREWS57@HOTMAIL.COM·7758 CENTRAL AVEChandlerAZ—GRP-7575NAVIGATE-HMO
ENRENR-114703 2026-01-19T04:21:44ZPHILIP—SCHULTZ1984-10-21UHC-31083-42•••-••-2535736-706-7778philip.schultz@icloud.com7756 Cedar LnCharlotteNC··28295GRP-0362OPTIONS-PPO
ENRENR-1225002026-04-22T20:47:27ZEspinoza, Michelle——1946-04-06UHC-29691-87•••-••-3988449-514-2562michelle.espinoza@hotmail.com7579 Ocean AveCHANDLERAZ85219GRP-1057SELECT-EPO
ENRENR-1412642026-05-26T04:31:49ZGerald·VJackson2006-03-04UHC-81537-76•••-••-735618405849275gerald.jackson11@aol.com5371 Meadow LnTampafl33609GRP-5980··OPTIONS-PPO
ENRENR-1190362026-02-26T17:45:06Z·LUCIAC.RUSSELL01/23/69UHC-13987-43•••-••-58732614470—8135 Jefferson AvenueFresnoCA93767GRP-1118SELECT-EPO
ENRENR-1080322026-08-05T02:58:00ZLUISIPORTER2006-06-17UHC-75154-53null665-857-8571LUIS.PORTER@YAHOO.COM2013 Lake View Rd·JacksonvilleFL··32286GRP-5201SELECT-EPO
ENRENR-1049082026-08-28T09:17:42Zraymond—vasquez10/5/1997UHC-16882-10•••-••-9268546-967-8576raymond.vasquez19@hotmail.com2095 CEDAR LANETampaFL33669GRP-6512CHOICE-PLUS-PPO
ENRENR-1391942026-09-27T16:10:28ZJeremyS.Stevens··1963-04-25UHC-14258-31··•••-••-87358314021809··—5943 Harbor Blvd Apt 18HoustonTX—GRP-1205CORE-HMO
ENRENR-1316762026-06-23T22:34:16ZyukiCramos13-07-1959UHC-80469-73•••-••-0856(482) 719-1739—6994 OAK ST·HOUSTONTX77057GRP-3087NAVIGATE-HMO
ENRENR-1168762026-02-13T11:23:19ZSamanthaQ··Medina1993-01-09uhc-02306-10•••-••-7314(921) 300-5051samantha.medina@yahoo.com6921 BASELINE RDSacramentoCANULLGRP-9189CHOICE-PLUS-PPO
ENR ENR-1139082026-09-03T08:45:01ZJanet—CarrollDec 9, 1979UHC-24627-62•••-••-821413865808267JANET.CARROLL@ICLOUD.COM2629 SAGE CTDenverCO80226-1591GRP-4040CHOICE-PLUS-PPO··
ENR ENR-1091962026-01-02T16:52:05ZDennisJBaker·1967-07-16UHC-24430-47•••-••-35786542482250DENNIS.BAKER@AOL.COM4332 Jefferson AvenueOrlandoFL32882GRP-1399CORE-HMO
ENRENR-1219062026-03-13T21:35:07ZKAYLA—MURRAY19880907UHC-48642-30•••-••-02819564426103kayla.murray@proton.me6435 Palm DriveMESAAZ85295GRP-5142MEDICARE-ADV-A
ENRENR-1210042026-04-23T13:48:07ZjosephX.sandoval1955-12-11UHC-40500-84•••-••-5356(987) 629-3003joseph.sandoval98@icloud.com1355 Lincoln WayLos AngelesCA90050GRP-0674··MEDICARE-ADV-B
ENRENR-1180232026-04-06T18:12:25ZJen—Smith1152-20-00UHC-75273-23NULL——1879 Bayshore DriveJacksonvilleFL32298GRP-7374OPTIONS-PPO
ENRENR-1112682026-04-26T20:28:31ZAlice—Thomas1982-12-07UHC-39620-83•••-••-2415614.338.9310ALICE.THOMAS38@HOTMAIL.COM1048 Sunset BoulevardCharlotteNC28299GRP-8732NAVIGATE-HMO
ENRENR-1375402026-06-06T02:46:40ZBaker, AdamZ.—1998-11-08UHC-26096-08•••-••-4283N/Aadam.baker@outlook.com1209 PARK PLEden PrairieMN55324GRP-7238NAVIGATE-HMO
ENRENR-1057592026-04-18T02:39:24ZJaet—Harris19580417UHC-34545-51•••-••-2733886.440.1179JANET.HARRIS@GMAIL.COM8158 Highland AvenueTucsonaz85726GRP-5685CHOICE-PLUS-PPO
ENRENR-1091512026-05-09T16:24:37Zgregory—campbell19431006UHC-08567-09•••-••-6571UNKNOWN—5886 Forest Ave··CHARLOTTENC28287GRP-5464SELECT-EPO
ENRENR-1230432026-08-26T05:25:31ZNicck—Garrett1950-08-02UHC-62777-97N/A7185612477—9125 Sage CourtMesaAZ85280GRP-3843CORE-HMO
ENRENR-1259992026-05-30T23:49:33Z·GERALD··MALDONADO04/17/46-•••-••-44299844676267gerald.maldonado81@aol.com·336 BroadwayCHANDLERAZ85223GRP-5947CHOICE-PLUS-PPO
ENRENR-1122632026-10-08T20:58:35ZMarkBDavisJun 10, 1962UHC-18118-85•••-••-6289·NULLmark.davis@proton.me1403 Pine DriveMesaAZ85248GRP-8177OPTIONS-PPO··
ENRENR-1175572026-06-29T04:55:34ZOLIVIA—ROBERTSON·1950-11-13UHC-92375-65•••-••-165315592256717·olivia.robertson@gmail.com·4970 Grand AvenueHouston··TX77091GRP-4388OPTIONS-PPO
ENR ENR-1327282026-01-02T22:50:52Zbrittany—alvaredo19910917UHC-89357-17•••-••-1492597-582-6766—7794 BASELINE ROAD #601Phoenixaz85044GRP-8578SELECT-EPO
ENRENR-137148 2026-02-28T05:12:01ZAHSLEY—JIMEENEZ1917-12-23UHC-92358-67··•••-••-107519584953788NULL7437 Forest AveJacksonvilleFL-GRP-2256CHOICE-PLUS-PPO
ENRENR-1202762026-01-29T00:16:57ZDeborahA.LewisNov 25, 1993UHC-89079-11•••-••-89807155689372DEBORAH.LEWIS@GMAIL.COM3727 WILLOW CTCharlotteNC·28205GRP-1276MEDICARE-ADV-A
ENRENR-1101832026-01-14T16:30:38ZChristina—Young19460115UHC-65599-85NULL453-354-4179N/A1509 Maple AveDENVERCO—GRP-9362MEDICARE-ADV-A
ENRENR-1047652026-06-29T16:23:46ZMoreno, Daniel——1998-12-25UHC-23626-94•••-••-74046303292198daniel.moreno@proton.me5133 BroadwayEDEN PRAIRIEMN55358-4303··GRP-9227SELECT-EPO
ENRENR-1156982026-09-20T15:46:32ZKAYLAXWHEELER1959-05-28UHC-93146-81N/A(731) 551-4621kayla.wheeler@proton.me3581 Palm DrGlendaleAZ85361GRP-6211··CHOICE-PLUS-PPO
ENRENR-116767 2026-06-04T03:00:47ZTurner, EthanU····7/21/1979UHC-63512-82•••-••-564414725798708UNKNOWN3909 Central AvenueSeattlewa··98119GRP-1641CORE-HMO
ENRENR-1266282026-05-22T12:27:54Z·Joe—Moreno1979-11-20UHC-55158-75•••-••-5735465-750-0539joe.moreno48@hotmail.com8522 Main StreetAustinTX78796GRP-6023MEDICARE-ADV-A
ENRENR-1032172026-05-17T13:26:30Z·AUSTINCHOLMES1976-02-25··UHC-67964-27•••-••-2124(389) 932-1696AUSTIN.HOLMES33@ICLOUD.COM1540 BASELINE RDCharlotteNC28262GRP-8758CORE-HMO
ENRENR-1282042026-01-09T01:04:51ZJulie—Hoffman03/12/40UHC-83320-02•••-••-0561+1 647 658 4349julie.hoffman@gmail.com5665 PARK PLACEEden PrairieMN55392-2264GRP-3205CORE-HMO
ENRENR-1391892026-09-21T04:30:31ZsandraSrios2006-03-11UHC-43703-75··•••-••-9449708-607-4594SANDRA.RIOS86@YAHOO.COM8800 Pine Dr Apt 32SACRAMENTOCA95874GRP-2521·OPTIONS-PPO
ENRENR-1350012026-04-19T22:54:52ZReyas, MatthewD—1955-11-13UHC-49750-83•••-••-6043—matthew.reyes12@gmail.com8544 Central Avenue Apt 16AustinTX78742GRP-6206CHOICE-PLUS-PPO
ENRENR-1127562026-10-03T10:46:23ZEugene—Coleman01/20/86UHC-30788-02•••-••-8944818-864-5196eugene.coleman21@hotmail.com9066 Ocean AvenueAustinTX78748GRP-9985SELECT-EPO
43,101 rows, page 74 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:36.708Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty