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 : 715
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 4606

ATC codes 4606

from aips: 4556
from swissmedic: 38
unique (from both aips and swissmedic): 1807

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: 4118
from peddose: 400
no text found: 76

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 16083 matching packages

RefData

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

PHARMA items: 14871
PHARMA items with GTIN starting with "7680": 14016
articles: 14871

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
9869 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: 4825/654 (5479)
in swissmedic: 1258/4221 (5479)
in bag: 65/5414 (5479)
not found anywhere: 114

54802, 54803, 66078, 48299, 40467, 42127, 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, 70352, 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, 62736, 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
69694

RefData

GTINs used: 13182

Swissmedic

GTINs used: 2977
recovered dosage 738

BAG

GTINs used: 154

ATC Codes

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

A01, A03AD, A05AX, A08AA, 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>: 1102
ATC without <Case>: 3491
tables created: 3988

Sappinfo

Unique ATC

breastFeed: 145
pregnancy: 191

Tables created

breastFeed: 899
pregnancy: 1283

Wed Jul 16 04:13:34 2025