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-1278792026-03-22T05:24:47ZGabriel—MartinezSep 10, 1996UHC-03742-58•••-••-4985(782) 555-2427gabriel.martinez91@gmail.com6184 CEDAR LANEScottsdaleAZ85239GRP-0525CORE-HMO··
ENRENR-1189342026-02-17T14:16:42ZSHARON—MCDONALD1997-05-14UHC-36499-31•••-••-4314461-974-2707sharon.mcdonald53@yahoo.com9406 BroadwayTempeAZ85210GRP-4442MEDICARE-ADV-A
ENRENR-1250822026-10-03T23:45:15ZBarbara—Espinoza19530307UHC-74131-02•••-••-4751(927) 429-7274····1702 LINCOLN WAYJacksonvilleFlorida32214GRP-6708SELECT-EPO
ENRENR-1195042026-02-18T23:09:55ZSmith, Lucia——19980616UHC-11040-64•••-••-23243373871lucia.smith74@icloud.com2181 FOREST AVENUEHoustonTX··77007GRP-1780·SELECT-EPO
ENRENR-1165022026-06-11T16:48:06Zkaren—wagner1995-02-07UHC7754867•••-••-59945572330096null3199 Market StreetNashvilleTN37213GRP-2945·MEDICARE-ADV-B
ENRENR-1257762026-06-24T05:39:16ZWILLMESPINOZA1960-09-11UHC4139631•••-••-2572664-616-8492william.espinoza54@hotmail.com9710 Palm Drive··Eden PrairieMN55395·GRP-1388CHOICE-PLUS-PPO
ENRENR-1399972026-07-16T00:04:20ZStephenUHerrera1950-05-18UHC-99274-57•••-••-5522930-410-5875STEPHEN.HERRERA10@GMAIL.COM1373 Park PlaceMINNEAPOLISmn55449-0003GRP-0342CHOICE-PLUS-PPO
ENRENR-1050382026-04-18T11:30:52ZTIMOTHYP.REED01/06/52UHC-12264-39•••-••-75563625575timothy.reed@icloud.com6718 LINCOLN WAYMIAMIfl33103GRP-3411SELECT-EPO
ENRENR-1250472026-03-27T20:54:10ZKYLE—TRAN-UHC5361959··•••-••-87864514110427kyle.tran2@outlook.com4149 Willow CourtEden PrairieMN55321GRP-1840medicare-adv-a
ENRENR-1389332026-09-30T07:02:34ZMadisonU.·Franklin·1975-01-16UHC-89354-81•••-••-07858366963MADISON.FRANKLIN95@YAHOO.COM6733 Oak StTucsonAZ85711···GRP-5925SELECT-EPO
ENRENR-1430872026-04-03T15:54:13Z Guerrero, Virginia——1939-07-02UHC4976458•••-••-8938-virginia.guerrero5@hotmail.com7836 Ocean AvenueMiamiFL—GRP-4170NAVIGATE-HMO
ENRENR-1415722026-05-16T21:48:51ZChristopher····Willis1953-10-21UHC-10720-18•••-••-4064963.564.2838···christopher.willis62@gmail.com269 Indian School RoadJacksonvilleFL32278·GRP-3864core-hmo
ENRENR-1071582026-02-01T16:27:44ZRussellRLe2003-01-08UHC-61621-22··•••-••-5718(499) 414-2493russell.le@outlook.com4534 Market StOrlandoFL32879···GRP-1871MEDICARE-ADV-B
ENRENR-1176902026-05-31T19:45:47ZRalphXAlexander3/28/1981UHC-79617-45•••-••-4262+1 603 818 3908ralph.alexander@aol.com3489 Jefferson AvenueSAN ANTONIOTX78255GRP-9172SELECT-EPO
ENRENR-1130342026-02-03T19:41:45Z·Lawrence, Linda—····1940-05-16UHC-42978-12•••-••-8516873-589-0123UNKNOWN4617 Palm Drive Apt 39TUCSONAZ85757GRP-9441SELECT-EPO
ENRENR-1295642026-05-12T01:23:51ZRichards, SusanB—1983-02-21UHC-61678-33•••-••-46729686807594susan.richards@yahoo.com··——NULLGRP-8005MEDICARE-ADV-A
ENRENR-1278392026-04-20T18:47:55ZYoung, LuisO—1947-11-15··UHC-96425-54•••-••-152719133048270luis.young76@proton.me5246 Camelback RdLAS VEGAS·NV—GRP-9413choice-plus-ppo
ENRENR-1346342026-03-16T15:53:16ZNathanSBurns1992-03-08UHC-47004-80•••-••-2619N/Anathan.burns@icloud.com4792 FOREST AVENUEGILBERTAZ85264GRP-2267MEDICARE-ADV-B
ENRENR-1073172026-02-16T17:59:43Z·Reynolds, Jacqueline——1982-11-20UHC-88771-87•••-••-02412869903127jacqueline.reynolds47@icloud.com·5254 Main St·Las VegasNV89174-0107GRP-2905··SELECT-EPO
ENRENR-1036762026-08-02T06:32:59ZOMAR—WALLACE2001-05-06UHC-93067-55•••-••-737117379933580omar.wallace@aol.com9222 Ridge RoadCharlotteNC28236GRP-8911OPTIONS-PPO
ENRENR-1383722026-07-24T01:31:45ZMariaFDiaz··1983-06-20UHC-45228-06•••-••-1422-MARIA.DIAZ@ICLOUD.COM5160 Valley View Drive··San AntonioTX78208GRP-2770MEDICARE-ADV-B
ENRENR-1329022026-08-01T22:05:44ZAnn—Holmes1939-01-21UHC-62292-14•••-••-97093022761400ann.holmes69@gmail.com8044 Main StreetChandlerAZ·85266GRP-0883SELECT-EPO
ENRENR-1375782026-01-24T14:45:56ZAllen—Auztin1939-03-24—•••-••-3770399-360-4770NULL2083 CEDAR LANEPhoenixArizona··85079GRP-2600CHOICE-PLUS-PPO
ENRENR-1092462026-08-13T20:31:57ZGAORGEYHANSON1964-01-16UHC5338218•••-••-49338286846877··—3568 Elm Street·SAN ANTONIOTexas78229GRP-2721MEDICARE-ADV-B
ENRENR-142749 2026-09-04T16:38:12ZELIJAH—ARNOLD··14-11-1983UHC-88669-71UNKNOWN4014026092elijah.arnold@icloud.com1210 Sage CtEden PrairieMN55393··GRP-1318MEDICARE-ADV-B
ENRENR-1116822026-09-26T02:56:05ZMelissaWWillis2001-11-16UHC-20645-30•••-••-22363177356N/A2108 Sage CourtAtlantaGAUNKNOWNGRP-8103CORE-HMO
ENRENR-1278292026-04-22T11:45:43ZStevenR.Pirce1939-01-16UHC-78273-41•••-••-3034(806) 404-8558·null2043 GRAND AVEHoustonTX-GRP-3400OPTIONS-PPO
ENRENR-1135872026-01-29T15:10:26ZdonnaOhoffman1998-08-07UHC-23819-12•••-••-3348440-265-6997null5099 Canyon RoadColumbusOH43264GRP-3895MEDICARE-ADV-A
ENRENR-1137492026-08-04T21:22:05ZJuan··Santos3/14/1947UHC-82854-28•••-••-7591(594) 872-5739juan.santos@yahoo.com9303 CENTRAL AVENASHVILLETN37231GRP-8013CHOICE-PLUS-PPO
ENRENR-1298062026-05-03T06:48:57ZLOGAN—LUNA·8/17/1954UHC-71151-34•••-••-4541(485) 917-1910NULL2999 Sage CtLas Vegas··nv89195GRP-3886MEDICARE-ADV-A
ENRENR-1394252026-07-04T22:31:31Z·Laura G.—Thomposn1974-11-15UHC-51193-39•••-••-6685204-920-0384null2287 Church StreetORLANDOFL32816GRP-6352MEDICARE-ADV-B
ENRENR-1035492026-06-05T07:48:48ZMei—Wilsn1944-02-23uhc-43668-25•••-••-43387469940803mei.wilson45@hotmail.com·8621 Sunset BoulevardEDEN PRAIRIEMN55342GRP-2626CHOICE-PLUS-PPO
ENRENR-1233012026-05-29T08:27:16ZREBECCA··SALAZER1960-03-16UHC-42362-52•••-••-3340401-279-8296REBECCA.SALAZAR20@HOTMAIL.COM1717 Palm DrMinneapolismn·55451GRP-2679OPTIONS-PPO
ENRENR-1040172026-03-14T18:25:50ZDeniseQ.Bennett2003-06-18UHC-03526-27•••-••-6154361-494-7193denise.bennett@aol.com3143 MOUNTAIN VIEW DRDenverCO80286GRP-3828CHOICE-PLUS-PPO
ENRENR-1370722026-07-16T12:50:33ZWalker, RyanS—07/19/79UHC-79552-94—5897311153RYAN.WALKER@ICLOUD.COM9299 Hillcrest RoadLas VegasNV89102·GRP-6462NAVIGATE-HMO
ENRENR-116903 2026-07-24T15:26:11ZJustinSLawrence1945-06-12UHC-56970-09•••-••-211016774423139justin.lawrence@gmail.com1593 SPRING STREETMIAMIFL33194GRP-5189medicare-adv-a
ENRENR-1013872026-08-15T08:07:38ZNANCY··—MALDONADO2003-02-08UHC-45547-55•••-••-232818716575373—9518 Maple Avenue·EDEN PRAIRIEMN55319GRP-5648medicare-adv-a
ENRENR-1039492026-08-21T23:36:55Z RICHARDLWRIGHT1965-07-20UHC-10330-79•••-••-3165826.519.4705RICHARD.WRIGHT@OUTLOOK.COM7463 Mesa DrAustinTX78731GRP-8771SELECT-EPO
ENRENR-1136122026-03-03T16:35:33Z Powell, HeatherT.—19760409UHC9340915•••-••-189716565984051·-1816 SPRING ST #128AtlantaGAUNKNOWNGRP-8982MEDICARE-ADV-A
ENRENR-1139812026-07-31T01:53:28Z·PeterQFox1989-01-24UHC2006548•••-••-1280(923) 277-1914peter.fox@icloud.com4747 Oak St #648ChandlerAZ—GRP-8078options-ppo
ENRENR-1073002026-09-03T09:15:22ZHeatherQAustin1990-10-11UHC-98318-39•••-••-4853—heather.austin36@outlook.com6047 Lincoln WayAustinTX78774GRP-3524··MEDICARE-ADV-B
ENRENR-1282592026-08-09T02:36:12ZJohnson, NatalieE—19681003UHC-69553-31•••-••-0612·420.483.7222—3534 SUNSET BLVDLos AngelesCAnull·GRP-7151NAVIGATE-HMO
ENRENR-1127092026-01-22T01:55:14ZWei—Jenkins1/1/1985UHC-07937-89•••-••-3599625-761-6400NULL2854 Elm StreetNASHVILLE·TN·37253GRP-9392MEDICARE-ADV-B
ENR ENR-1011252026-04-11T16:20:08Zryan—kelly1969-12-07UHC-98387-34··•••-••-9121+1 221 623 2833UNKNOWN2586 Oak StreetMinneapolisMN···55492GRP-6959MEDICARE-ADV-B
ENRENR-1262252026-03-18T17:35:08ZLindaXWagner·1994-05-17UHC-79792-87•••-••-11703179276389···linda.wagner@aol.com4845 Hillcrest RdSan Diego··CA92136GRP-3499MEDICARE-ADV-A
ENRENR-108151 2026-09-15T10:20:57ZADAM U—LYNCH1951-04-07UHC-96043-54•••-••-2869(857) 725-9713———N/A—GRP-5370MEDICARE-ADV-A
ENRENR-1008082026-08-22T22:27:31Z KaylaIMcDonald2002-09-02UHC-95609-38N/A(634) 314-9707N/A256 Jefferson AveLAS VEGASNV89134GRP-1547SELECT-EPO
ENRENR-1354232026-09-18T07:04:01Zdoris··—delgado02/23/08UHC-53156-32•••-••-8097(808) 813-1526doris.delgado@hotmail.com—-——·GRP-7035OPTIONS-PPO
ENRENR-1365322026-09-02T08:00:00ZCHERYLL.PETERSON1958-03-10UHC2246354•••-••-2058·(834) 409-9831—8368 Hillcrest RoadDenverCO80272GRP-5598NAVIGATE-HMO
ENR ENR-1124902026-10-06T23:37:23ZMarcus—Nichols2002-06-09UHC-15781-86•••-••-9277889-625-7139—3910 Oak StreetJacksonvilleFL32271GRP-8734NAVIGATE-HMO
43,101 rows, page 289 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:43.449Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty