This Report was generated by: cpp2sqlite

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

File Analysis

swisspeddose.ch

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

Cases 737

<CaseID> set: 737
<ATCCode> set: 254
<ROACode> set: 14

Indications 367

<IndicationKey> map: 367

Dosages 1335

<CaseId> set: 737
vec: 1335

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: 17949

ATC Codes

../input/atc_codes_multi_lingual.txt

# lines: 2635

Drugshortage

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

GTINs : 742
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: 183
Without Zulassungsnummer: 13

DHPC HPC

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

Count: 67
Without Zulassungsnummer: 53

AIPS

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

medicalInformation fi de 4586

ATC codes 4586

from aips: 4536
from swissmedic: 38
unique (from both aips and swissmedic): 1798

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: 4123
from peddose: 391
no text found: 60

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

RefData

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

PHARMA items: 16481
PHARMA items with GTIN starting with "7680": 15400
articles: 16483

BAG

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

preparations: 6593
packs: 10233
packs without GTIN: 66
GTIN recovered from <SwissmedicNo8>: 62
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

9969 GTIN are also in swissmedic
9996 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: 4874/584 (5458)
in swissmedic: 1265/4193 (5458)
in bag: 22/5436 (5458)
not found anywhere: 86

54802, 54803, 66078, 42127, 69514, 55179, 55442, 66996, 25022, 51390, 67063, 55114, 31839, 56545, 43319, 39828, 10286, 42134, 56422, 57191, 17664, 55381, 47646, 41569, 67022, 57933, 65179, 47956, 55508, 44676, 65331, 52489, 20406, 03579, 71204, 59795, 59093, 62840, 67546, 65120, 54032, 54033, 55461, 67197, 46871, 48147, 56264, 56264, 00654, 65150, 41341, 68478, 47915, 56212, 26339, 44778, 55494, 51741, 51742, 54974, 68579, 57659, 56469, 60489, 67819, 67557, 61560, 61561, 61562, 61564, 61566, 65840, 66642, 66708, 67095, 67158, 49034, 01677, 46003, 24024, 47110, 68400, 42441, 56198, 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
58734
62385
62386
62780
65561
66411
66533
67565
68145
68229
68864
68996
69330
69443

RefData

GTINs used: 13895

Swissmedic

GTINs used: 3052
recovered dosage 767

BAG

GTINs used: 31

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>: 1069
ATC without <Case>: 3504
tables created: 3922

Sappinfo

Unique ATC

breastFeed: 144
pregnancy: 191

Tables created

breastFeed: 902
pregnancy: 1278

Mon Mar 31 04:17:48 2025