This Report was generated by: cpp2sqlite
- ./cpp2sqlite
- --verbose
- --lang=fr
- --inDir
- ../input
File Analysis
swisspeddose.ch
../input/../downloads/swisspeddosepublication_v3.xml
Cases 529
- <CaseID> set: 529
- <ATCCode> set: 159
- <ROACode> set: 13
Indications 282
Dosages 896
- <CaseId> set: 529
- vec: 896
Codes 5631
- _ALTERRELATION: 8
- _FG: 2
- _GEWICHT: 2
- ATC: 5405
- DOSISTYP: 81
- DOSISUNIT: 35
- EVIDENZ: 6
- ROA: 78
- ZEIT: 14
Swissmedic
../input/../downloads/swissmedic_packages.xlsx
ATC Codes
../input/atc_codes_multi_lingual.txt
Drugshortage
../input/../downloads/drugshortage.json
- GTINs : 465
- Total vert(1): 0
- Total vert clair(2): 0
- Total orange(3): 0
- Total rouge(4): 0
- Total Jaune(5): 0
Batchrecalls
../input/../downloads/chargenrueckrufe_fr.json
- Count: 101
- Without Zulassungsnummer: 8
DHPC HPC
../input/../downloads/dhpc_hpc_fr.json
- Count: 30
- Without Zulassungsnummer: 66
AIPS
../input/../downloads/aips.xml
- medicalInformation fi fr 4467
ATC codes 4467
- from aips: 4416
- from swissmedic: 38
- unique (from both aips and swissmedic): 1745
Titles with empty or invalid ATC code: 13
- RN: <67575> , title: <Abecma®>
- RN: <58943> , title: <Apligraf>
- RN: <67469> , title: <Breyanzi®>
- RN: <00000> , title: <DIGIFAB® DIGOXIN IMMUNE FAB (OVINE)>
- RN: <00000> , title: <EVUSHELD 100 mg/ml + 100 mg/ml Solution for Injection>
- RN: <00000> , title: <FACTOR X P BEHRING>
- RN: <66778> , title: <KYMRIAH®>
- RN: <00000> , title: <Paxlovid™>
- RN: <00000> , title: <SUCCICAPTAL 200 mg, Gélules>
- RN: <67884> , title: <Tecartus®>
- RN: <00000> , title: <Veklury®>
- RN: <66986> , title: <YESCARTA®>
- RN: <63051> , title: <Zeel comp.>
ATC code text
- from aips: 4211
- from peddose: 212
- no text found: 31
rgnrs that contained duplicates
titles with rn 00000 (ignored)
- DIGIFAB® DIGOXIN IMMUNE FAB (OVINE)
- EVUSHELD 100 mg/ml + 100 mg/ml Solution for Injection
- FACTOR X P BEHRING
- Paxlovid™
- SUCCICAPTAL 200 mg, Gélules
- Veklury®
Swissmedic has 16077 matching packages
RefData
../input/../downloads/refdata_pharma.xml
- PHARMA items: 16256
- PHARMA items with GTIN starting with "7680": 15072
- articles: 16258
BAG
../input/../downloads/bag_preparations.xml
- preparations: 6351
- packs: 9968
- packs without GTIN: 89
- GTIN recovered from <SwissmedicNo8>: 85
- GTIN unrecoverable from <SwissmedicNo8>: 4
<SwissmedicNo8> empty
- <NameFr> Morphinium HCl, <DescriptionFr> sol inj 10 mg
- <NameFr> Morphinium HCl, <DescriptionFr> sol inj 10 mg
- <NameFr> Morphinium HCl, <DescriptionFr> sol inj 20 mg
- <NameFr> Morphinium HCl, <DescriptionFr> sol inj 20 mg
Cross-reference
- 9639 GTIN are also in swissmedic
- 9774 GTIN are also in refdata
Sappinfo (filtered)
../input/sappinfo.xlsx
- Unique ATC set: 215
- rows Breast Feeding: 182
- rows Pregnancy: 282
Usage
aips REGNRS (found/not found)
- in refdata: 4784/611 (5395)
- in swissmedic: 1316/4079 (5395)
- in bag: 27/5368 (5395)
- not found anywhere: 74
68319, 54802, 54803, 60010, 55179, 46117, 58817, 25022, 62881, 67063, 55114, 44694, 63086, 62848, 62849, 62850, 36030, 65097, 42134, 56422, 63020, 57191, 60230, 62411, 47646, 41569, 66556, 57933, 57601, 57735, 65179, 62891, 55508, 52489, 20406, 03579, 71204, 59795, 57541, 56327, 62840, 61325, 67546, 62391, 55461, 30901, 34736, 00654, 65150, 52365, 55494, 51741, 51742, 54974, 57659, 12358, 59375, 68498, 54521, 47589, 62914, 65840, 66642, 56949, 62486, 42497, 71102, 65475, 62217, 57458, 41556, 61260, 62439, 62567
XML
title_str separator ';' was replaced for rgnrs
- 50655, 47920 "Ecomucyl® Sandoz comprimés effervescents; Ecomucyl® Sandoz granulés"
- 51075, 51076 "Folinate de calcium Sandoz® eco, solution injectable/pour perfusion; Folinate de calcium Sandoz®, capsules"
- 52787, 52788 "Trabar 50; Trabar 100"
- 53985, 55622 "ACC Sandoz® comprimés effervescents; ACC Sandoz® granulés"
- 54842 "CoAprovel® 150/12,5; 300/12,5; 300/25"
- 58620, 58674 "Mycophénolate-Mofétil Sandoz® 250 mg, capsules; Mycophénolate-Mofétil Sandoz® 500 mg, comprimés pelliculés"
- 61222, 61223, 61896 "Montélukast Sandoz® granulé; Montélukast Sandoz® comprimés â mâcher; Montélukast Sandoz® comprimés pelliculés"
- 62278 "Irbesartan HCT Zentiva® 150/12,5; 300/12,5; 300/25"
- 62728, 62730 "Diclo-Acino 25/50, comprimés pelliculés; Diclo-Acino 100 retard, capsules à libération prolongée"
- 62904 "Perindopril-Indapamid-Mepha 2.5/0.625 mg, comprimés pelliculés; Perindopril-Indapamid-Mepha 5/1.25 mg, comprimés pelliculés"
XML
For these rgnrs, <img> has no "alt" attribute
- 42809
- 46489, 65479
- 49796
- 52810
- 54785, 65474
- 55057
- 58182, 59376, 59377
- 58734
- 62780
- 63123
- 65561
- 67941
- 68229
RefData
Swissmedic
- GTINs used: 3227
- recovered dosage 955
BAG
ATC Codes
- 44 missing branches from ../input/atc_codes_multi_lingual.txt
A01, C02DD, D08A1, D09, D09A, D09AA, G03XX, H02C, H02CA, J05AJ, L01CE, L01E, L01EA, L01EB, L01EC, L01ED, L01EE, L01EF, L01EH, L01EJ, L01EK, L01EL, L01EM, L01EN, L01EX, L01F, L01FA, L01FB, L01FD, L01FF, L01FX, L01XG, L01XJ, L01XK, L01XY, L91, L91A, L91AB, M03BA, M04AC, N02CD, N03X, N03X1, N05BX
swisspeddose.ch
- ATC with <Case>: 735
- ATC without <Case>: 3718
- tables created: 3044
Sappinfo
Unique ATC
- breastFeed: 147
- pregnancy: 193
Tables created
- breastFeed: 963
- pregnancy: 1350
Sat May 28 04:08:00 2022