This Report was generated by: cpp2sqlite
- ./cpp2sqlite
- --verbose
- --inDir
- ../input
File Analysis
swisspeddose.ch
../input/../downloads/swisspeddosepublication_v4.xml
Cases 547
- <CaseID> set: 547
- <ATCCode> set: 171
- <ROACode> set: 14
Indications 292
Dosages 931
- <CaseId> set: 547
- vec: 931
Codes 5632
- _ALTERRELATION: 8
- _FG: 2
- _GEWICHT: 2
- ATC: 5406
- 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 : 645
- Total grün(1): 0
- Total hellgrün(2): 0
- Total orange(3): 0
- Total rot(4): 0
- Total Gelb(5): 0
Batchrecalls
../input/../downloads/chargenrueckrufe_de.json
- Count: 94
- Without Zulassungsnummer: 8
DHPC HPC
../input/../downloads/dhpc_hpc_de.json
- Count: 49
- Without Zulassungsnummer: 53
AIPS
../input/../downloads/aips.xml
- medicalInformation fi de 4499
ATC codes 4499
- from aips: 4445
- from swissmedic: 42
- unique (from both aips and swissmedic): 1756
Titles with empty or invalid ATC code: 12
- RN: <67575> , title: <Abecma®>
- RN: <58943> , title: <Apligraf>
- RN: <55442> , title: <ASCOSAL® Brausetabletten>
- RN: <67469> , title: <Breyanzi®>
- RN: <00000> , title: <DIGIFAB® DIGOXIN IMMUNE FAB (OVINE)>
- RN: <00000> , title: <FACTOR X P BEHRING>
- RN: <66778> , title: <KYMRIAH®>
- RN: <00000> , title: <SUCCICAPTAL 200 mg, Hartkapseln>
- RN: <67884> , title: <Tecartus®>
- RN: <00000> , title: <Veklury®>
- RN: <66986> , title: <YESCARTA®>
- RN: <63051> , title: <Zeel comp.>
ATC code text
- from aips: 4227
- from peddose: 209
- no text found: 51
rgnrs that contained duplicates
titles with rn 00000 (ignored)
- DIGIFAB® DIGOXIN IMMUNE FAB (OVINE)
- FACTOR X P BEHRING
- SUCCICAPTAL 200 mg, Hartkapseln
- Veklury®
Swissmedic has 16136 matching packages
RefData
../input/../downloads/refdata_pharma.xml
- PHARMA items: 16320
- PHARMA items with GTIN starting with "7680": 15133
- articles: 16322
BAG
../input/../downloads/bag_preparations.xml
- preparations: 6378
- packs: 10012
- packs without GTIN: 97
- GTIN recovered from <SwissmedicNo8>: 93
- GTIN unrecoverable from <SwissmedicNo8>: 4
<SwissmedicNo8> empty
- <NameDe> Morphinium HCl, <DescriptionDe> Inj Lös 10 mg
- <NameDe> Morphinium HCl, <DescriptionDe> Inj Lös 10 mg
- <NameDe> Morphinium HCl, <DescriptionDe> Inj Lös 20 mg
- <NameDe> Morphinium HCl, <DescriptionDe> Inj Lös 20 mg
Cross-reference
- 9709 GTIN are also in swissmedic
- 9817 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: 4813/617 (5430)
- in swissmedic: 1322/4108 (5430)
- in bag: 26/5404 (5430)
- not found anywhere: 70
54802, 54803, 55179, 46117, 25022, 67063, 55114, 53121, 55701, 44694, 63086, 49806, 36030, 42134, 56422, 57191, 71102, 60230, 17664, 52358, 52417, 47646, 41569, 66556, 57933, 57601, 65179, 62891, 55508, 52489, 20406, 03579, 71204, 59795, 56327, 62840, 61320, 61325, 67546, 55461, 30901, 34736, 00654, 65150, 26339, 55494, 51741, 51742, 61193, 61186, 54974, 57659, 12358, 59375, 57534, 47589, 62914, 65840, 66642, 56000, 55779, 67193, 63193, 42497, 65475, 62217, 66560, 61260, 62439, 62567
XML
title_str separator ';' was replaced for rgnrs
- 50655, 47920 "Ecomucyl® Sandoz Brausetabletten; Ecomucyl® Sandoz Granulat"
- 51075, 51076 "Calciumfolinat Sandoz® eco, Injektions-/Infusionslösung; Calciumfolinat Sandoz®, Kapseln"
- 52787, 52788 "Trabar 50; Trabar 100"
- 53985, 55622 "ACC Sandoz® Brausetabletten; ACC Sandoz® Granulat"
- 54842 "CoAprovel® 150/12,5; 300/12,5; 300/25"
- 58620, 58674 "Mycophenolat-Mofetil Sandoz® 250 mg, Kapseln; Mycophenolat-Mofetil Sandoz® 500 mg, Filmtabletten"
- 61222, 61223, 61896 "Montelukast Sandoz® Granulat; Montelukast Sandoz® Kautabletten; Montelukast Sandoz® Filmtabletten"
- 62278 "Irbesartan HCT Zentiva®150/12,5; 300/12,5; 300/25"
- 62728, 62730 "Diclo-Acino 25/50, Filmtabletten; Diclo-Acino 100 retard, Retardkapseln"
- 62904 "Perindopril-Indapamid-Mepha 2.5/0.625 mg, Filmtabletten; Perindopril-Indapamid-Mepha 5/1.25 mg, Filmtabletten"
XML
For these rgnrs, <img> has no "alt" attribute
- 42809
- 44521
- 46489, 65479
- 49796
- 54785, 65474
- 55057
- 56202
- 58734
- 62442
- 62780
- 65561
- 66533
- 67007
- 67565
- 67941
- 68145
- 68229
RefData
Swissmedic
- GTINs used: 3248
- recovered dosage 966
BAG
ATC Codes
- 47 missing branches from ../input/atc_codes_multi_lingual.txt
A01, C02DD, D08A1, D09, D09A, D09AA, G03XX, H02C, H02CA, J05AJ, J06BD, L01CE, L01E, L01EA, L01EB, L01EC, L01ED, L01EE, L01EF, L01EH, L01EJ, L01EK, L01EL, L01EM, L01EN, L01EX, L01F, L01FA, L01FB, L01FD, L01FE, L01FF, L01FX, L01XG, L01XH, L01XJ, L01XK, L01XY, L91, L91A, L91AB, M03BA, M04AC, N02CD, N03X, N03X1, N05BX
swisspeddose.ch
- ATC with <Case>: 787
- ATC without <Case>: 3699
- tables created: 3087
Sappinfo
Unique ATC
- breastFeed: 147
- pregnancy: 193
Tables created
- breastFeed: 949
- pregnancy: 1340
Thu Oct 6 04:09:42 2022