This Report was generated by: cpp2sqlite

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

File Analysis

swisspeddose.ch

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

Cases 762

<CaseID> set: 762
<ATCCode> set: 266
<ROACode> set: 14

Indications 383

<IndicationKey> map: 383

Dosages 1423

<CaseId> set: 762
vec: 1423

Codes 6167

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

Swissmedic

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

rows: 17908

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: 195
Without Zulassungsnummer: 13

DHPC HPC

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

Count: 25
Without Zulassungsnummer: 21

AIPS

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

medicalInformation fi de 4542

ATC codes 0

from aips: 0
from swissmedic: 0
unique (from both aips and swissmedic): 0

ATC code text

from aips: 0
from peddose: 0
no text found: 0

Missing html files

Regnrs: 69266 html: 5ef966b419c74454924120d685e948cc-de.html
Regnrs: 56109 html: 57b85b60f50648d5a389ecee7c93aa23-de.html
Regnrs: 56539 html: 7452fa6ab6a04698b5411ea837d57f97-de.html
Regnrs: 29080 html: be82a9bfde43416c9e17a122bff8988a-de.html
Regnrs: 57264 html: b7adabfbf53b46c3a752b4f8251c2d5b-de.html
Regnrs: 49621 html: 07a778ddf1be4a2eb5de908e93c84986-de.html
Regnrs: 15322 html: 09295ff68ade441796d9052e9a325d55-de.html
Regnrs: 52489 html: 61a856a9b7934f2a859eb62a5142e5e7-de.html

Swissmedic has 15959 matching packages

RefData

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

PHARMA items: 15243
PHARMA items with GTIN starting with "7680": 14229
articles: 15243

BAG

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

preparations: 6561
packs: 10187
packs without GTIN: 63
GTIN recovered from <SwissmedicNo8>: 59
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

9945 GTIN are also in swissmedic
9869 GTIN are also in refdata

Swissreg

../input/swissreg.json

Count: 995

Sappinfo (filtered)

../input/sappinfo.xlsx

Unique ATC set: 215
rows Breast Feeding: 182
rows Pregnancy: 282

Usage

aips REGNRS (found/not found)

in refdata: 4792/603 (5395)
in swissmedic: 1234/4161 (5395)
in bag: 55/5340 (5395)
not found anywhere: 86

42127, 67451, 66587, 66214, 66078, 44778, 68147, 62955, 22672, 63014, 56469, 60489, 68922, 68182, 68335, 68286, 55381, 68326, 12730, 68478, 50490, 68400, 68359, 67792, 68596, 38174, 01677, 46003, 67546, 68579, 47915, 44676, 03579, 20406, 67197, 39828, 10286, 58034, 67022, 67819, 67557, 30984, 67063, 34088, 56929, 59210, 48299, 66236, 66237, 49034, 17664, 65840, 66642, 66708, 67095, 67158, 65940, 54032, 54033, 26339, 42134, 24024, 54089, 65120, 65161, 54173, 61560, 61561, 61562, 61564, 61566, 00701, 57755, 60372, 41547, 56545, 42185, 56212, 51390, 52537, 47110, 45699, 46871, 48147, 43667, 37687

in refdata: 4792/603 (5395)

in swissmedic: 1234/4161 (5395)

in bag: 55/5340 (5395)

not found anywhere: 86

ATC not found: 73

42127, 67451, 66587, 66214, 66078, 44778, 68147, 62955, 22672, 63014, 56469, 60489, 68922, 68182, 68335, 68286, 55381, 68326, 12730, 68478, 50490, 68400, 68359, 67792, 67575, 68596, 38174, 67546, 68579, 47915, 44676, 67197, 39828, 10286, 58034, 67022, 67819, 67557, 30984, 67063, 34088, 56929, 59210, 48299, 66236, 66237, 49034, 17664, 65840, 66642, 66708, 67095, 67158, 65940, 58943, 54032, 54033, 26339, 42134, 24024, 54089, 62038, 65120, 65161, 54173, 00701, 18346, 57755, 60372, 41547, 56545, 42185, 56212, 51390, 52537, 47110, 45699, 46871, 48147, 37687

RefData

GTINs used: 13163

Swissmedic

GTINs used: 2930
recovered dosage 714

BAG

GTINs used: 147

ATC Codes

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

A01, A03AD, A05AX, A08AA, B05CB, B06AX, C02DD, D08AE, D09, D09A, D09AA, G03XX, H02C, H02CA, J05AJ, J06BC, 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, N05BX, N05CJ, P02CF, R07AB, V03AH, V06, V06D, V08CB

swisspeddose.ch

ATC with <Case>: 1079
ATC without <Case>: 3389
tables created: 3887

Sappinfo

Unique ATC

breastFeed: 144
pregnancy: 190

Tables created

breastFeed: 878
pregnancy: 1244

Thu Oct 23 04:13:12 2025