This Report was generated by: cpp2sqlite
- ./cpp2sqlite
- --verbose
- --fhir
- --lang=fr
- --inDir
- ../input
File Analysis
swisspeddose.ch
../input/../downloads/swisspeddosepublication_v4.xml
Cases 775
- <CaseID> set: 774
- <ATCCode> set: 272
- <ROACode> set: 14
Indications 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
ATC Codes
../input/atc_codes_multi_lingual.txt
Drugshortage
../input/../downloads/drugshortage.json
- GTINs : 712
- 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: 212
- Without Zulassungsnummer: 15
DHPC HPC
../input/../downloads/dhpc_hpc_fr.json
- Count: 18
- Without Zulassungsnummer: 28
AIPS
../input/../downloads/aips.xml
- medicalInformation fi fr 4589
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
- 49673
- 49673
- 37979
- 52476
- 52476
- 55337
- 65426
- 43167
- 24926, 44939
- 61442
- 61442
- 53773
- 58868, 63166, 66931
- 65383
- 34282
- 68434
- 68434
- 65088
- 65088
- 68354
- 56038
- 56038
- 69501
Missing html files
- Regnrs: 52810 html: d28d309c2ea44ce8b4fce80b73e80a7e-fr.html
- Regnrs: 56539 html: 7452fa6ab6a04698b5411ea837d57f97-fr.html
- Regnrs: 29080 html: be82a9bfde43416c9e17a122bff8988a-fr.html
- Regnrs: 49621 html: 07a778ddf1be4a2eb5de908e93c84986-fr.html
- Regnrs: 15322 html: 09295ff68ade441796d9052e9a325d55-fr.html
- Regnrs: 52489 html: 61a856a9b7934f2a859eb62a5142e5e7-fr.html
Swissmedic has 16164 matching packages
RefData
../input/../downloads/refdata_pharma.xml
- PHARMA items: 16801
- PHARMA items with GTIN starting with "7680": 14962
- articles: 16801
BAG FHIR
../input/../downloads/fhir-sl-fr.ndjson
- preparations: 6780
- packs: 10462
- packs without GTIN: 110
GTIN empty
- Eltrombopag NOBEL cpr pell 75 mg blist 28 pce, 69450
- DEKAs Plus liquid 60 ml,
- DEKAs Plus Softgels caps bte 60 pce,
- Fresubin 2 kcal Drink liq neutre flatcap 4x 200 ml,
- Mevalia PKU Balance 1+ bte 500 g,
- Mevalia PKU Balance complete 0-1 bte 500 g,
- Mevalia PKU Balance complete 1+ bte 500 g,
- Thallous chloride TI-201 Curium sol inj 213 MBq fl 1 pce, 44065
- Neocate junior pdr 400 g,
- Fresubin 2 kcal Fibre Drink liq choc flatcap 4x 200 ml,
- Pertector générateur 2.3-57.1 GBq 1 pce, 65778
- Tekcis Tc-99m générateur 1 pce, 62442
- 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
- XPhe smart A pdr neutre bte 500 g,
- XPhe smart A pdr vanille bte 500 g,
- XPhe smart A pdr citron 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,
- Candesartan CPS cpr 8 mg blist 28 pce, 62569
- Comirnaty LP.8.1 disp inj 30 mcg/dose ser pré 0.3 ml (emballage individuel), 70403
- Diaphin SR cpr pell ret 200 mg 100 pce, 57720
- Stamicis set marquage subst sèche fl 5 pce, 59062
- Encepur N susp inj enf sans aiguille ser pré 0.25 ml (emballage individuel),
- Fresubin 2 kcal Drink liq apric/pêc flatcap 4x 200 ml,
- Fresubin 2 kcal Drink liq fruit boi flatcap 4x 200 ml,
- Fresubin 2 kcal Fibre Drink liq lemo flatcap 4x 200 ml,
- Hemgenix conc perf 10ml 13-24 pce, 61-120 kg PC flac 1 pce, 68780
- Létrozole Zentiva cpr pell 2.5 mg blist 30 pce, 61501
- Menveo subst sèche c solv flac 1 pce (emballage individuel), 62502
- Sodiumiodide (I-123) sol inj 37 MBq amp 1 pce, 52574
- Vicks Nasivin spray nasal 0.05 % fl 10 ml, 54613
- Vicks Nasivin gtt nas 0.01 % fl 5 ml, 70160
- Sodium iodide I-123 Curium sol inj 74 MBq flac 2 ml, 52729
- TechneScan DMSA subst sèche fl 5 pce, 55446
- TechneScan DTPA subst sèche fl 5 pce, 42809
- Tektrotyd trousse de marquage subst sèche flac 2 pce, 66540
- XPhe smart J pdr neutre bte 500 g,
- OctreoScan subst sèche c solv fl 2 pce, 52810
- Metoject auto-injecteur sol inj 7.5 mg / 0.15 ml stylo pré 1 pce, 65672
- Metoject auto-injecteur sol inj 20 mg / 0.4 ml stylo pré 1 pce, 65672
- Mevalia PKU Balance 14+ 500 g,
- XPhe smart A pdr fruits des bois bte 500 g,
- Sodium iodide I-123 Curium sol inj 370 MBq flac 10 ml, 52729
- Teceos subst sèche 14.2 mg fl 5 pce, 44521
- Candesartan Plus CPS cpr 32/12.5mg blist 28 pce, 62570
- Candesartan Plus CPS cpr 32/25mg blist 28 pce, 62570
- Metoject auto-injecteur sol inj 10 mg / 0.2 ml stylo pré 1 pce, 65672
- Sodiumiodide (I-123) caps 7.4 MBq 1 pce, 52573
- MIBG I-123 Curium sol inj 222 MBq amp 3 ml, 52731
- Morphinium HCl sol inj 10 mg amp 10 pce,
- Morphinium HCl sol inj 10 mg amp 100 pce,
- Sodium iodide I-131 T Curium caps 1 pce, 52728
- Hemgenix conc perf 10ml 37-48 pce, 181-240 kg PC flac 1 pce, 68780
- Metoject auto-injecteur sol inj 15 mg / 0.3 ml stylo pré 1 pce, 65672
- Metoject auto-injecteur sol inj 17.5 mg / 0.35 ml stylo pré 1 pce, 65672
- Metoject auto-injecteur sol inj 25 mg / 0.5 ml stylo pré 1 pce, 65672
- Morphinium HCl sol inj 20 mg amp 10 pce,
- Morphinium HCl sol inj 20 mg amp 100 pce,
- Thallous chloride TI-201 Curium sol inj 370 MBq fl 1 pce, 44065
- Citrate yttrium (90Y) YMM1 susp inj 555 MBq 15 ml, 51703
- Zolgensma sol perf 2x 10e13 génomes vecteurs/ml set 1 pce, 67529
- TechneScan MAG3 subst sèche fl 5 pce, 49796
- Sodium iodide I-123 Curium sol inj 185 MBq flac 5 ml, 52729
- Vitarubin Dépôt sol inj 1 mg/ml amp 1 ml (emballage individuel), 33584
- Candesartan CPS cpr 16 mg blist 28 pce, 62569
- Candesartan CPS cpr 32 mg blist 28 pce, 62569
- Candesartan Plus CPS cpr 16/12.5mg blist 28 pce, 62570
- Eltrombopag NOBEL cpr pell 50 mg blist 14 pce, 69450
- Eltrombopag NOBEL cpr pell 50 mg blist 28 pce, 69450
- Diaphin subst sèche 5 g i.v. amp 1 pce, 55561
- Eltrombopag NOBEL cpr pell 12.5 mg blist 14 pce, 69450
- TechneScan HDP subst sèche fl 5 pce, 49638
- Thallous chloride TI-201 Curium sol inj 85 MBq fl 1 pce, 44065
- MIBG I-123 Curium sol inj 148 MBq amp 2 ml, 52731
- MIBG I-123 Curium sol inj 370 MBq amp 5 ml, 52731
- Fresubin 2 kcal Drink liq vanille flatcap 4x 200 ml,
- FSME Immun Junior susp inj sans aiguille ser pré 0.25 ml (emballage individuel),
- Sodium iodide I-123 Curium sol inj 37 MBq flac 1 ml, 52729
- Diaphin IR cpr 200 mg 100 pce, 57724
- Hemgenix conc perf 10ml 1-12 pce, 51-60 kg PC flac 1 pce, 68780
- Metoject auto-injecteur sol inj 12.5 mg / 0.25 ml stylo pré 1 pce, 65672
- Metoject auto-injecteur sol inj 22.5 mg / 0.45 ml stylo pré 1 pce, 65672
- Candesartan CPS cpr 4 mg blist 7 pce, 62569
- Candesartan Plus CPS cpr 8/12.5mg blist 28 pce, 62570
- Eltrombopag NOBEL cpr pell 25 mg blist 14 pce, 69450
- Eltrombopag NOBEL cpr pell 25 mg blist 28 pce, 69450
- Fresubin 2 kcal Fibre Drink liq capp flatcap 4x 200 ml,
- Hemgenix conc perf 10ml 25-36 pce, 121-180 kg PC flac 1 pce, 68780
- Iopidine gtt opht 1 % 24 monodos 0.25 ml, 53737
- Mevalia PKU Balance 6+ bte 500 g,
- MIBG I-123 Curium sol inj 74 MBq amp 1 ml, 52731
- Ultravist 370 sol inj 370 mg/ml 30 ml flac 1 pce, 46969
- Scintimun Granulocyte subst sèche set marquage fl 2 pce, 51672
- Vicks Nasivin spray nasal 0.025 % fl 10 ml, 54613
Cross-reference (BAG FHIR)
- 10016 GTIN are also in swissmedic
- 9953 GTIN are also in refdata
Swissreg
../input/swissreg.json
Sappinfo (filtered)
../input/sappinfo.xlsx
- Unique ATC set: 215
- rows Breast Feeding: 182
- rows Pregnancy: 282
Usage
aips REGNRS (found/not found)
- in refdata: 4895/534 (5429)
- in swissmedic: 1132/4297 (5429)
- in bag: 41/5388 (5429)
- not found anywhere: 74
70763, 70764, 70757, 70387, 70392, 61560, 61561, 61562, 61564, 61566, 68478, 68326, 68286, 65940, 62965, 42127, 66214, 66078, 68147, 22672, 68922, 55381, 62659, 12730, 65210, 50490, 68400, 68359, 68596, 38174, 01677, 46003, 68579, 67996, 44676, 58502, 39828, 10286, 67022, 67819, 67557, 67063, 56929, 59210, 48299, 66236, 66237, 65237, 49034, 17664, 65840, 66642, 66708, 67095, 67158, 54032, 54033, 26339, 42134, 24024, 65120, 65161, 54173, 57755, 41547, 56545, 56212, 52537, 47110, 45699, 46871, 48147, 43667, 36185
in refdata: 4895/534 (5429)
in swissmedic: 1132/4297 (5429)
in bag: 41/5388 (5429)
not found anywhere: 74
ATC not found: 67
70490, 70763, 70764, 70757, 70387, 70392, 68573, 68478, 68326, 69485, 69405, 68286, 65940, 62965, 42127, 66214, 66078, 68147, 22672, 68922, 55381, 62659, 12730, 65210, 50490, 68400, 68359, 68596, 38174, 68579, 67996, 44676, 58502, 39828, 10286, 67022, 67819, 67557, 67063, 56929, 59210, 48299, 66236, 66237, 65237, 49034, 17664, 65840, 66642, 66708, 67095, 67158, 58943, 54032, 54033, 26339, 42134, 24024, 62038, 65120, 65161, 54173, 18346, 57755, 41547, 56545, 56212, 52537, 47110, 45699, 46871, 48147, 36185
RefData
Swissmedic
- GTINs used: 2679
- recovered dosage 652
BAG
BAG FHIR
ATC Codes
- 73 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, 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>: 1113
- ATC without <Case>: 3408
- tables created: 3964
Sappinfo
Unique ATC
- breastFeed: 144
- pregnancy: 190
Tables created
- breastFeed: 881
- pregnancy: 1252
Mon Apr 27 04:10:52 2026