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

ATC Codes

../input/atc_codes_multi_lingual.txt

# lines: 2635

Drugshortage

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

GTINs : 713
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: 198
Without Zulassungsnummer: 13

DHPC HPC

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

Count: 25
Without Zulassungsnummer: 21

AIPS

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

medicalInformation fi de 4551

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: 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 15993 matching packages

RefData

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

PHARMA items: 15722
PHARMA items with GTIN starting with "7680": 14478
articles: 15722

BAG

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

preparations: 6566
packs: 10193
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

9938 GTIN are also in swissmedic
9872 GTIN are also in refdata

Swissreg

../input/swissreg.json

Count: 0

Sappinfo (filtered)

../input/sappinfo.xlsx

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

Usage

aips REGNRS (found/not found)

in refdata: 0/0 (0)
in swissmedic: 0/0 (0)
in bag: 0/0 (0)
not found anywhere: 83

65940, 68326, 42127, 67451, 66587, 66214, 66078, 68147, 62955, 22672, 63014, 56469, 60489, 68922, 68182, 68335, 68286, 55381, 12730, 68478, 50490, 68400, 68359, 67792, 68596, 38174, 01677, 46003, 68579, 47915, 44676, 03579, 20406, 67197, 39828, 10286, 58034, 67022, 67819, 67557, 30984, 67063, 56929, 59210, 48299, 66236, 66237, 49034, 17664, 65840, 66642, 66708, 67095, 67158, 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: 0/0 (0)

in swissmedic: 0/0 (0)

in bag: 0/0 (0)

not found anywhere: 83

ATC not found: 69

65940, 68326, 42127, 67451, 66587, 66214, 66078, 68147, 62955, 22672, 63014, 56469, 60489, 68922, 68182, 68335, 68286, 55381, 12730, 68478, 50490, 68400, 68359, 67792, 68596, 38174, 68579, 47915, 44676, 67197, 39828, 10286, 58034, 67022, 67819, 67557, 30984, 67063, 56929, 59210, 48299, 66236, 66237, 49034, 17664, 65840, 66642, 66708, 67095, 67158, 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: 13201

Swissmedic

GTINs used: 2931
recovered dosage 711

BAG

GTINs used: 151

ATC Codes

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

A01, A03AD, A05AX, A08AA, B05CB, B06AX, C02DD, C02KN, 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>: 1083
ATC without <Case>: 3398
tables created: 3901

Sappinfo

Unique ATC

breastFeed: 144
pregnancy: 190

Tables created

breastFeed: 875
pregnancy: 1245

Sat Nov 22 04:18:11 2025