This Report was generated by: cpp2sqlite

./cpp2sqlite
--verbose
--inDir
../input

File Analysis

swisspeddose.ch

../input/../downloads/swisspeddosepublication_v4.xml

Cases 760

<CaseID> set: 760
<ATCCode> set: 265
<ROACode> set: 14

Indications 381

<IndicationKey> map: 381

Dosages 1410

<CaseId> set: 760
vec: 1410

Codes 5919

_ALTERRELATION: 10
_FG: 2
_GEWICHT: 2
ATC: 5683
DOSISTYP: 86
DOSISUNIT: 35
EVIDENZ: 6
ROA: 79
ZEIT: 16

Swissmedic

../input/../downloads/swissmedic_packages.xlsx

rows: 17865

ATC Codes

../input/atc_codes_multi_lingual.txt

# lines: 2635

Drugshortage

../input/../downloads/drugshortage.json

GTINs : 730
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: 186
Without Zulassungsnummer: 13

DHPC HPC

../input/../downloads/dhpc_hpc_de.json

Count: 22
Without Zulassungsnummer: 17

AIPS

../input/../downloads/aips.xml

medicalInformation fi de 4601

ATC codes 4601

from aips: 4551
from swissmedic: 38
unique (from both aips and swissmedic): 1806

Titles with empty or invalid ATC code: 12

RN: <58943> , title: <Apligraf>
RN: <55442> , title: <ASCOSAL® Brausetabletten>
RN: <51390> , title: <Becetamol® Tropfen>
RN: <00000> , title: <DIGIFAB®, Lyophilisat>
RN: <00000> , title: <Erythrozytenkonzentrat (EK) leukozytendepletiert, in additiver Lösung>
RN: <00000> , title: <FACTOR X P BEHRING>
RN: <12730> , title: <Methergin Injektionslösung s.c., i.m., i.v.>
RN: <00000> , title: <Plasma (frisch gefroren), leukozytendepletiert, pathogeninaktiviert (INTERCEPT®)>
RN: <00000> , title: <Plasma (frisch gefroren), leukozytendepletiert, quarantänegelagert (FGPq)>
RN: <00000> , title: <SUCCICAPTAL 200 mg, Hartkapseln>
RN: <67451> , title: <Tegsedi>
RN: <00000> , title: <Thrombozytenkonzentrat, leukozytendepletiert und pathogeninaktiviert (Intercept®)>

ATC code text

from aips: 4115
from peddose: 399
no text found: 75

titles with rn 00000 (ignored)

DIGIFAB®, Lyophilisat
Erythrozytenkonzentrat (EK) leukozytendepletiert, in additiver Lösung
FACTOR X P BEHRING
Plasma (frisch gefroren), leukozytendepletiert, pathogeninaktiviert (INTERCEPT®)
Plasma (frisch gefroren), leukozytendepletiert, quarantänegelagert (FGPq)
SUCCICAPTAL 200 mg, Hartkapseln
Thrombozytenkonzentrat, leukozytendepletiert und pathogeninaktiviert (Intercept®)

Swissmedic has 16071 matching packages

RefData

../input/../downloads/refdata_pharma.xml

PHARMA items: 14850
PHARMA items with GTIN starting with "7680": 13997
articles: 14850

BAG

../input/../downloads/bag_preparations.xml

preparations: 6584
packs: 10219
packs without GTIN: 74
GTIN recovered from <SwissmedicNo8>: 70
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

9980 GTIN are also in swissmedic
9878 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: 4827/647 (5474)
in swissmedic: 1254/4220 (5474)
in bag: 65/5409 (5474)
not found anywhere: 113

54802, 54803, 66078, 48299, 40467, 42127, 70016, 55179, 55442, 41547, 66996, 25022, 68286, 51390, 54173, 67063, 60372, 55114, 56545, 43319, 49259, 39828, 10286, 42134, 66236, 66237, 56422, 57191, 17664, 55381, 40841, 68147, 41569, 67022, 56929, 38174, 57933, 00701, 65179, 47956, 55508, 54904, 44676, 65331, 52489, 67792, 20406, 03579, 71204, 59795, 65161, 34088, 59210, 42185, 59093, 62840, 67546, 65120, 54089, 54032, 54033, 55461, 67197, 46871, 48147, 65150, 41341, 68478, 68335, 47915, 56212, 26339, 44778, 55494, 51741, 51742, 63014, 54974, 52537, 68579, 57659, 22672, 56469, 60489, 45699, 67819, 67557, 61560, 61561, 61562, 61564, 61566, 65840, 66642, 66708, 67095, 67158, 37687, 49034, 01677, 46003, 43667, 67451, 24024, 47110, 68400, 42441, 56198, 62955, 58034, 68238, 61260, 62439

XML

title_str separator ';' was replaced for rgnrs

22114, 25644 "Syntocinon® Konzentrat zur Herstellung einer Injektions-/Infusionslösung; Syntocinon® Nasenspray, Lösung"
50655, 47920 "Ecomucyl® Sandoz Brausetabletten; Ecomucyl® Sandoz Granulat"
50710, 54157, 50709 "Zofran®, Filmtabletten; Zofran®, Infusionskonzentrat/Injektionslösung; Zofran®, Zydis® Schmelztabletten"
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"
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

46489, 65479
54785, 65474
56202
57460
58108
58734
62385
62386
62780
63255
65561
66930
67565
68145
68229
68864
68996
69330
69443

RefData

GTINs used: 13178

Swissmedic

GTINs used: 2968
recovered dosage 729

BAG

GTINs used: 154

ATC Codes

67 missing branches from ../input/atc_codes_multi_lingual.txt

A01, A03AD, A05AX, B05CB, B06AX, C02DD, C09XX, D08AE, D09, D09A, D09AA, G03XX, H02C, H02CA, J05AJ, J06BD, J07BN, L01CE, L01E, L01EA, L01EB, L01EC, L01ED, L01EE, L01EF, L01EG, L01EH, L01EJ, L01EK, L01EL, L01EM, L01EN, L01EX, L01F, L01FA, L01FB, L01FC, L01FD, L01FE, L01FF, L01FG, L01FX, L01FY, L01XF, L01XG, L01XH, L01XJ, L01XK, L01XL, L01XM, L01XY, L04AE, L04AF, L04AG, L04AH, L04AJ, L04AK, M03BA, M04AC, N02BF, N02CD, N03X, N03X1, N05BX, N05CJ, P02CF, R07AB

swisspeddose.ch

ATC with <Case>: 1101
ATC without <Case>: 3487
tables created: 3979

Sappinfo

Unique ATC

breastFeed: 145
pregnancy: 191

Tables created

breastFeed: 897
pregnancy: 1278

Thu Jul 3 04:13:34 2025