Thousand and one blister. Search for overpriced drugs
Recently, the Ministry of Health laid out a table with marginal prices for essential medicines , I was not bothered and checked how often these limits were exceeded in Moscow.
The idea was this: to take the prices of medicines that are available on the Internet on Sputnik , aptekamos.ru or poisklekarstv.ru to somehow combine them with marginal prices and see if excess occurs often.
First, about the registry, which was laid out by the Ministry of Health : firstly, it turned out that all these data were available on grls.rosminzdrav.ru . They are updated there every day and presented in the form of a neat Excel file. Therefore, having worn out with a tablet that was laid out by the Ministry of Health , I switched to the data of the GRLS. Dataset looked like this:
')
The list of vitally necessary includes ~ 3200 drugs, but taking into account the different forms, dosages and manufacturers, it turns out ~ 20 000 items. For each, the maximum price is indicated, at which the manufacturer can sell the medicine to wholesalers. It is important to note here that the maximum price is indicated for the manufacturer, and not for the pharmacy. On the price tag on the storefront, the value can be much higher due to taxes, wholesale and retail mark-ups, but more on that later.
Then it was necessary for each of the ~ 20,000 positions to find the prices that are in the pharmacies of the capital. For this, I took the wonderful Satellite / Medical site and, pointing out one medicine after another, collected all the prices. 200 names could not be found, for 800 drugs there were no pharmacies that would sell them. Thus, the number of items for which pharmacy prices could potentially be found has drastically reduced from ~ 20,000 to ~ 8,000. I do not think that this is bad, apparently, the remaining positions are completely unpopular, if they are not found in pharmacies in Moscow. One can still assume that the drugs are sold, but Sputnik does not know about them. Maybe. But, according to my estimates, the coverage of pharmacies at this service is about 25%, which is quite a lot. If there is no price, then the drug is really unpopular.
Then the most interesting thing began, the drugs needed to be combined in forms and dosages. Naturally, the spelling there is different everywhere, so I had to figure out what “d / v / v”, “d / endotracheal”, “d / p / k” and “d / v / m” are, to take into account that “10 thousand KIE / ml "is the same as" 10,000 KIE / ml "and" 1 g + 62.5 mg "is not different from" 1000 mg + 62.5 mg ". As a result, 75% of the forms and dosages were able to combine, which is not bad.
Then I drew for each medicine a small picture of the form:
On it, each pharmacy price is represented by a blue stripe, the excess cases are marked in red. For almost all drugs, I observed severe excess in large quantities. Then I did not know how much to take into account in order to calculate the marginal price correctly.
Firstly, there are different manufacturers of medicines, you need to take the most expensive of them. Be sure to take into account taxes, wholesale and retail allowances. For example, a manufacturer can sell 30 capsules "Tulosin" for 471.89 rubles. or cheaper . Wholesale and retail markups are different for different price categories. For Moscow pharmacies for the price category “up to 500r.” The wholesale premium is 15%, retail - 28%. Therefore, we add to 471.89r. 43%, we get 674.80. If the pharmacy is organized by a legal entity, and not an individual entrepreneur, then the wholesale and retail markups are taxed, so we add 10% to 674.80p and get 742.28. In the general case, the dependence of the maximum value on the price list on the marginal price of the manufacturer looks like this:
It is important to note that the pharmacy can not play on the price due to the steps on the chart. If the marginal price of the drug, for example, 502r., Then it falls into the category of "from 500r.". It does not matter that the pharmacy bought it for 499 p. to make margins, as in the category "up to 500r." She can not.
Almost all. It is only necessary to take into account that the prices in the registry sometimes change. It even happens that they decrease (four bars below the unit in the image below), so you need to deflate the entire registry archive and take the maximum price for the entire period.
After all the subtleties were taken into account, the number of preparations with excess exceeded significantly and became approximately 5%. This is a bit and the elevations there were usually small, but I still decided to walk around the pharmacies, check whether everything works correctly.
He put the pharmacies with elevations on the map and went into five of them:
In three, indeed, were exceeded:
In order to be completely confident and to get achivok for one thing, I dashed off complaints to gorod.mos.ru and now there even someone deals with them:
Then, thanks to Linkov, Yuri and Vasily Pushkin, with whom I met at the hackathon according to open data, I was able to communicate with people who are in the subject. They went to the Analytical Center under the Government of the Russian Federation, where they are generally not concerned with excesses in general, they are more interested in the general price dynamics. Were in the Ministry of Health, they did not really like the intonation, nobody wants to fine there. The Ministry of Public Health and Social Affairs said that it is impossible to determine the maximum price automatically and “a special approach is needed for each case,” they have been doing this for many years. Representatives of the Association of pharmacy chains and one large commercial network did not believe in the existence of any number of large excesses, they know in practice how carefully pharmacies check the regulatory authorities. There is almost no place for violations there.
Nevertheless, all the developments were arranged in the form of a primitive reference 1001blister.ru . Price data there is presented in a super-aggregated form, because the Satellite, of course, cannot share them. Mention any pharmacies are missing. The handbook can be used to find out the maximum prices for drugs that you regularly use. They say that sometimes pharmacists in pharmacies start offering discounts when you call a legal price limit.
The idea was this: to take the prices of medicines that are available on the Internet on Sputnik , aptekamos.ru or poisklekarstv.ru to somehow combine them with marginal prices and see if excess occurs often.
First, about the registry, which was laid out by the Ministry of Health : firstly, it turned out that all these data were available on grls.rosminzdrav.ru . They are updated there every day and presented in the form of a neat Excel file. Therefore, having worn out with a tablet that was laid out by the Ministry of Health , I switched to the data of the GRLS. Dataset looked like this:
')
The list of vitally necessary includes ~ 3200 drugs, but taking into account the different forms, dosages and manufacturers, it turns out ~ 20 000 items. For each, the maximum price is indicated, at which the manufacturer can sell the medicine to wholesalers. It is important to note here that the maximum price is indicated for the manufacturer, and not for the pharmacy. On the price tag on the storefront, the value can be much higher due to taxes, wholesale and retail mark-ups, but more on that later.
Then it was necessary for each of the ~ 20,000 positions to find the prices that are in the pharmacies of the capital. For this, I took the wonderful Satellite / Medical site and, pointing out one medicine after another, collected all the prices. 200 names could not be found, for 800 drugs there were no pharmacies that would sell them. Thus, the number of items for which pharmacy prices could potentially be found has drastically reduced from ~ 20,000 to ~ 8,000. I do not think that this is bad, apparently, the remaining positions are completely unpopular, if they are not found in pharmacies in Moscow. One can still assume that the drugs are sold, but Sputnik does not know about them. Maybe. But, according to my estimates, the coverage of pharmacies at this service is about 25%, which is quite a lot. If there is no price, then the drug is really unpopular.
Then the most interesting thing began, the drugs needed to be combined in forms and dosages. Naturally, the spelling there is different everywhere, so I had to figure out what “d / v / v”, “d / endotracheal”, “d / p / k” and “d / v / m” are, to take into account that “10 thousand KIE / ml "is the same as" 10,000 KIE / ml "and" 1 g + 62.5 mg "is not different from" 1000 mg + 62.5 mg ". As a result, 75% of the forms and dosages were able to combine, which is not bad.
Then I drew for each medicine a small picture of the form:
On it, each pharmacy price is represented by a blue stripe, the excess cases are marked in red. For almost all drugs, I observed severe excess in large quantities. Then I did not know how much to take into account in order to calculate the marginal price correctly.
Firstly, there are different manufacturers of medicines, you need to take the most expensive of them. Be sure to take into account taxes, wholesale and retail allowances. For example, a manufacturer can sell 30 capsules "Tulosin" for 471.89 rubles. or cheaper . Wholesale and retail markups are different for different price categories. For Moscow pharmacies for the price category “up to 500r.” The wholesale premium is 15%, retail - 28%. Therefore, we add to 471.89r. 43%, we get 674.80. If the pharmacy is organized by a legal entity, and not an individual entrepreneur, then the wholesale and retail markups are taxed, so we add 10% to 674.80p and get 742.28. In the general case, the dependence of the maximum value on the price list on the marginal price of the manufacturer looks like this:
It is important to note that the pharmacy can not play on the price due to the steps on the chart. If the marginal price of the drug, for example, 502r., Then it falls into the category of "from 500r.". It does not matter that the pharmacy bought it for 499 p. to make margins, as in the category "up to 500r." She can not.
Almost all. It is only necessary to take into account that the prices in the registry sometimes change. It even happens that they decrease (four bars below the unit in the image below), so you need to deflate the entire registry archive and take the maximum price for the entire period.
After all the subtleties were taken into account, the number of preparations with excess exceeded significantly and became approximately 5%. This is a bit and the elevations there were usually small, but I still decided to walk around the pharmacies, check whether everything works correctly.
He put the pharmacies with elevations on the map and went into five of them:
In three, indeed, were exceeded:
In order to be completely confident and to get achivok for one thing, I dashed off complaints to gorod.mos.ru and now there even someone deals with them:
Then, thanks to Linkov, Yuri and Vasily Pushkin, with whom I met at the hackathon according to open data, I was able to communicate with people who are in the subject. They went to the Analytical Center under the Government of the Russian Federation, where they are generally not concerned with excesses in general, they are more interested in the general price dynamics. Were in the Ministry of Health, they did not really like the intonation, nobody wants to fine there. The Ministry of Public Health and Social Affairs said that it is impossible to determine the maximum price automatically and “a special approach is needed for each case,” they have been doing this for many years. Representatives of the Association of pharmacy chains and one large commercial network did not believe in the existence of any number of large excesses, they know in practice how carefully pharmacies check the regulatory authorities. There is almost no place for violations there.
Nevertheless, all the developments were arranged in the form of a primitive reference 1001blister.ru . Price data there is presented in a super-aggregated form, because the Satellite, of course, cannot share them. Mention any pharmacies are missing. The handbook can be used to find out the maximum prices for drugs that you regularly use. They say that sometimes pharmacists in pharmacies start offering discounts when you call a legal price limit.
Source: https://habr.com/ru/post/265655/
All Articles