This Report was generated by: cpp2sqlite

./cpp2sqlite
--verbose
--fhir
--lang=fr
--inDir
../input

File Analysis

swisspeddose.ch

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

Cases 774

<CaseID> set: 774
<ATCCode> set: 272
<ROACode> set: 14

Indications 390

<IndicationKey> map: 390

Dosages 1448

<CaseId> set: 774
vec: 1448

Codes 6179

_ALTERRELATION: 12
_FG: 2
_GEWICHT: 2
ATC: 5932
DOSISTYP: 86
DOSISUNIT: 44
EVIDENZ: 6
ROA: 79
ZEIT: 16

Swissmedic

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

rows: 18080

ATC Codes

../input/atc_codes_multi_lingual.txt

# lines: 2635

Drugshortage

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

GTINs : 22
Total vert(1): 0
Total vert clair(2): 0
Total orange(3): 0
Total rouge(4): 0
Total Jaune(5): 0

Batchrecalls

../input/../downloads/chargenrueckrufe_fr.json

Count: 220
Without Zulassungsnummer: 15

DHPC HPC

../input/../downloads/dhpc_hpc_fr.json

Count: 29
Without Zulassungsnummer: 40

AIPS

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

medicalInformation fi fr 4641

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

rgnrs that contained duplicates

29550
29550
29550
68030
68030
52022
52022
37482
70193
70193
53108
53108
55497
55497
49673
49673
65383
37979
52476
52476
55337
65426
43167
24926, 44939
61442
61442
53773
58868, 63166, 66931
34282
68434
68434
65088
65088
68354
56038
56038
69501

Missing html files

Regnrs: 49621 html: 07a778ddf1be4a2eb5de908e93c84986-fr.html
Regnrs: 15322 html: 09295ff68ade441796d9052e9a325d55-fr.html
Regnrs: 52489 html: 61a856a9b7934f2a859eb62a5142e5e7-fr.html

Swissmedic has 16250 matching packages

BAG FHIR

../input/../downloads/fhir-sl-fr.ndjson

preparations: 6781
packs: 10416
packs without GTIN: 87

GTIN empty

Candesartan CPS cpr 4 mg blist 7 pce, 62569
Candesartan CPS cpr 8 mg blist 28 pce, 62569
Candesartan CPS cpr 16 mg blist 28 pce, 62569
Candesartan CPS cpr 32 mg blist 28 pce, 62569
Candesartan Plus CPS cpr 8/12.5mg blist 28 pce, 62570
Candesartan Plus CPS cpr 16/12.5mg blist 28 pce, 62570
Candesartan Plus CPS cpr 32/12.5mg blist 28 pce, 62570
Candesartan Plus CPS cpr 32/25mg blist 28 pce, 62570
Comirnaty XFG disp inj 30 mcg/0.3 ml ser pré 1 pce (emballage individuel), 70893
DEKAs Plus liquid 60 ml,
DEKAs Plus Softgels caps bte 60 pce,
Diaphin subst sèche 5 g i.v. amp 1 pce, 55561
Encepur N susp inj enf sans aiguille ser pré 0.25 ml (emballage individuel),
Enflonsia sol inj 105 mg/0.7 ml ser pré 1 pce (emballage individuel), 70145
Fresubin 2 kcal Drink liq apric/pêc flatcap 4x 200 ml,
Fresubin 2 kcal Drink liq neutre flatcap 4x 200 ml,
Fresubin 2 kcal Drink liq vanille flatcap 4x 200 ml,
Fresubin 2 kcal Drink liq fruit boi flatcap 4x 200 ml,
Fresubin 2 kcal Fibre Drink liq capp flatcap 4x 200 ml,
Fresubin 2 kcal Fibre Drink liq lemo flatcap 4x 200 ml,
Fresubin 2 kcal Fibre Drink liq choc flatcap 4x 200 ml,
FSME Immun Junior susp inj sans aiguille ser pré 0.25 ml (emballage individuel),
Iopidine gtt opht 1 % 24 monodos 0.25 ml, 53737
Létrozole Zentiva cpr pell 2.5 mg blist 30 pce, 61501
Menveo subst sèche c solv flac 1 pce (emballage individuel), 62502
Mevalia PKU Balance 1+ bte 500 g,
Mevalia PKU Balance 14+ 500 g,
Mevalia PKU Balance 6+ bte 500 g,
Mevalia PKU Balance complete 0-1 bte 500 g,
Mevalia PKU Balance complete 1+ bte 500 g,
MIBG I-123 Curium sol inj 74 MBq amp 1 ml, 52731
MIBG I-123 Curium sol inj 148 MBq amp 2 ml, 52731
MIBG I-123 Curium sol inj 222 MBq amp 3 ml, 52731
MIBG I-123 Curium sol inj 370 MBq amp 5 ml, 52731
Morphinium HCl sol inj 10 mg amp 10 pce,
Morphinium HCl sol inj 10 mg amp 100 pce,
Morphinium HCl sol inj 20 mg amp 10 pce,
Morphinium HCl sol inj 20 mg amp 100 pce,
Sodiumiodide (I-123) caps 7.4 MBq 1 pce, 52573
Neocate junior pdr 400 g,
OctreoScan subst sèche c solv fl 2 pce, 52810
Pertector générateur 2.3-57.1 GBq 1 pce, 65778
Scintimun Granulocyte subst sèche set marquage fl 2 pce, 51672
Sodium iodide I-123 Curium sol inj 37 MBq flac 1 ml, 52729
Sodium iodide I-123 Curium sol inj 74 MBq flac 2 ml, 52729
Sodium iodide I-123 Curium sol inj 185 MBq flac 5 ml, 52729
Sodium iodide I-123 Curium sol inj 370 MBq flac 10 ml, 52729
Sodium iodide I-131 T Curium caps 1 pce, 52728
Spikevax XFG disp inj 50 mcg/0.5 ml ser pré 1 pce (emballage individuel), 70847
Stamicis set marquage subst sèche fl 5 pce, 59062
Teceos subst sèche 14.2 mg fl 5 pce, 44521
TechneScan DMSA subst sèche fl 5 pce, 55446
TechneScan DTPA subst sèche fl 5 pce, 42809
TechneScan HDP subst sèche fl 5 pce, 49638
TechneScan MAG3 subst sèche fl 5 pce, 49796
Tekcis Tc-99m générateur 1 pce, 62442
Tektrotyd trousse de marquage subst sèche flac 2 pce, 66540
Thallous chloride TI-201 Curium sol inj 85 MBq fl 1 pce, 44065
Thallous chloride TI-201 Curium sol inj 213 MBq fl 1 pce, 44065
Thallous chloride TI-201 Curium sol inj 370 MBq fl 1 pce, 44065
UltratechneKow FM générateur 2.15 GBq 1 pce, 49358
UltratechneKow FM générateur 4.3 GBq 1 pce, 49358
UltratechneKow FM générateur 6.45 GBq 1 pce, 49358
UltratechneKow FM générateur 8.6 GBq 1 pce, 49358
UltratechneKow FM générateur 10.75 GBq 1 pce, 49358
UltratechneKow FM générateur 12.9 GBq 1 pce, 49358
UltratechneKow FM générateur 17.2 GBq 1 pce, 49358
UltratechneKow FM générateur 21.5 GBq 1 pce, 49358
UltratechneKow FM générateur 25.8 GBq 1 pce, 49358
UltratechneKow FM générateur 30.1 GBq 1 pce, 49358
UltratechneKow FM générateur 34.4 GBq 1 pce, 49358
UltratechneKow FM générateur 43 GBq 1 pce, 49358
Vitarubin Dépôt sol inj 1 mg/ml amp 1 ml (emballage individuel), 33584
XPhe smart A pdr neutre bte 500 g,
XPhe smart A pdr vanille bte 500 g,
XPhe smart A pdr fruits des bois bte 500 g,
XPhe smart A pdr citron bte 500 g,
XPhe smart J pdr neutre bte 500 g,
XPhe smart J pdr vanille bte 500 g,
XPhe smart J pdr fruits des bois bte 500 g,
XPhe smart J pdr citron bte 500 g,
XPhe smart K pdr neutre bte 500 g,
XPhe smart K pdr vanille bte 500 g,
XPhe smart K pdr fruits des bois bte 500 g,
XPhe smart K pdr citron bte 500 g,
Citrate yttrium (90Y) YMM1 susp inj 555 MBq 15 ml, 51703
Zolgensma sol perf 2x 10e13 génomes vecteurs/ml set 1 pce, 67529

Cross-reference (BAG FHIR)

10011 GTIN are also in swissmedic
0 GTIN are also in refdata

Swissreg

../input/swissreg.json

Count: 1031

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/5484 (5484)
in swissmedic: 5338/146 (5484)
in bag: 62/5422 (5484)
not found anywhere: 138

67446, 99999, 53634, 53635, 43667, 39242, 65899, 52179, 00613, 54571, 67792, 61560, 61561, 61562, 61564, 61566, 61568, 61569, 61570, 61571, 61572, 61573, 61574, 61575, 61576, 61578, 61580, 61582, 61584, 61585, 61586, 61587, 61589, 61590, 61591, 61593, 61595, 61596, 61597, 61598, 61599, 61600, 61601, 61602, 61603, 61605, 61607, 61609, 61614, 61615, 61616, 61617, 61618, 61619, 68478, 68326, 68286, 65940, 63011, 62603, 66183, 42127, 66214, 66078, 22672, 55483, 68243, 68922, 65978, 55381, 12730, 68527, 68275, 68605, 65210, 50490, 68400, 68596, 68391, 38174, 01677, 46003, 68579, 52371, 67996, 44676, 53164, 39828, 10286, 49433, 67756, 67022, 67819, 67557, 66530, 67063, 56929, 59210, 48299, 66236, 66237, 12337, 19035, 49034, 17664, 65840, 66642, 66708, 67095, 67158, 43753, 42414, 46590, 54032, 54033, 26339, 42134, 24024, 65120, 52371, 65161, 37272, 54173, 50478, 57207, 41547, 57449, 56545, 57054, 56212, 53262, 53130, 52537, 47110, 45386, 46871, 48147, 36185

in refdata: 0/5484 (5484)

in swissmedic: 5338/146 (5484)

in bag: 62/5422 (5484)

not found anywhere: 138

ATC not found: 98

67446, 99999, 53634, 53635, 68547, 68590, 39242, 68575, 65899, 68573, 52179, 00613, 54571, 67792, 68212, 61560, 61561, 61562, 61564, 61566, 61568, 61569, 61570, 61571, 61572, 61573, 61574, 61575, 61576, 61578, 61580, 61582, 61584, 61585, 61586, 61587, 61589, 61590, 61591, 61593, 61595, 61596, 61597, 61598, 61599, 61600, 61601, 61602, 61603, 61605, 61607, 61609, 61614, 61615, 61616, 61617, 61618, 61619, 46206, 68478, 68326, 69485, 69405, 68286, 65940, 63011, 62603, 66183, 42127, 66214, 66078, 22672, 68581, 68580, 55483, 68243, 68922, 65978, 55381, 12730, 68527, 68275, 68605, 65210, 50490, 68400, 68596, 68391, 38174, 68579, 52371, 67996, 44676, 53164, 39828, 10286, 49433, 67756, 67022, 67819, 67557, 66530, 67063, 56929, 59210, 48299, 66236, 66237, 12337, 19035, 49034, 17664, 65840, 66642, 66708, 67095, 67158, 43753, 42414, 46590, 58943, 54032, 54033, 26339, 42134, 24024, 62038, 65120, 52371, 65161, 54173, 18346, 50478, 57207, 41547, 57449, 56545, 57054, 56212, 53262, 53130, 52646, 52537, 47110, 45386, 46871, 48147, 36185

RefData

GTINs used: 0

Swissmedic

GTINs used: 16250
recovered dosage 3365

BAG

GTINs used: 0

BAG FHIR

GTINs used: 151

ATC Codes

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

A01, A03AD, A05AX, A08AA, A10X, A10XX, B05CB, B06AX, C02DD, C02KN, D08AE, D09, D09A, D09AA, G03XX, H02C, H02CA, J05AJ, J06BD, J07BN, J07BP, L01CE, L01E, L01EA, L01EB, L01EC, L01ED, L01EE, L01EF, L01EG, L01EH, L01EJ, L01EK, L01EL, L01EM, L01EN, L01EP, 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, L04AL, M03BA, M04AC, N02BF, N02CD, N05BX, N05CJ, P02CF, R07AB, V03AH, V06, V06D, V08CB

swisspeddose.ch

ATC with <Case>: 1116
ATC without <Case>: 3426
tables created: 3990

Sappinfo

Unique ATC

breastFeed: 144
pregnancy: 190

Tables created

breastFeed: 894
pregnancy: 1273

Sat Sep 5 05:11:37 2026