This Report was generated by: cpp2sqlite

• ./cpp2sqlite
• --verbose
• --fhir
• --inDir
• ../input

File Analysis

swisspeddose.ch

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

Cases 775

• <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: 17942

ATC Codes

../input/atc_codes_multi_lingual.txt

• # lines: 2635

Drugshortage

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

• GTINs : 712
• 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: 210
• Without Zulassungsnummer: 13

DHPC HPC

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

• Count: 25
• Without Zulassungsnummer: 21

AIPS

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

• medicalInformation fi de 4588

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-de.html
• Regnrs: 56539 html: 7452fa6ab6a04698b5411ea837d57f97-de.html
• Regnrs: 29080 html: be82a9bfde43416c9e17a122bff8988a-de.html
• Regnrs: 49621 html: 07a778ddf1be4a2eb5de908e93c84986-de.html
• Regnrs: 15322 html: 09295ff68ade441796d9052e9a325d55-de.html
• Regnrs: 52489 html: 61a856a9b7934f2a859eb62a5142e5e7-de.html

Swissmedic has 16161 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-de.ndjson

• preparations: 6780
• packs: 10462
• packs without GTIN: 110

GTIN empty

1. Eltrombopag NOBEL Filmtabl 75 mg Blist 28 Stk, 69450
2. DEKAs Plus liquid 60 ml,
3. DEKAs Plus Softgels Kaps Ds 60 Stk,
4. Fresubin 2 kcal Drink liq Neutral FlatCap 4x 200 ml,
5. Mevalia PKU Balance 1+ Ds 500 g,
6. Mevalia PKU Balance complete 0-1 Ds 500 g,
7. Mevalia PKU Balance complete 1+ Ds 500 g,
8. Thallous chloride TI-201 Curium Inj Lös 213 MBq Fl 1 Stk, 44065
9. Neocate Junior Plv 400 g,
10. Fresubin 2 kcal Fibre Drink liq Scho FlatCap 4x 200 ml,
11. Pertector Generator 2.3-57.1 GBq 1 Stk, 65778
12. Tekcis Tc-99m Generator 1 Stk, 62442
13. UltratechneKow FM Generator 2.15 GBq 1 Stk, 49358
14. UltratechneKow FM Generator 4.3 GBq 1 Stk, 49358
15. UltratechneKow FM Generator 6.45 GBq 1 Stk, 49358
16. UltratechneKow FM Generator 8.6 GBq 1 Stk, 49358
17. UltratechneKow FM Generator 10.75 GBq 1 Stk, 49358
18. UltratechneKow FM Generator 12.9 GBq 1 Stk, 49358
19. UltratechneKow FM Generator 17.2 GBq 1 Stk, 49358
20. UltratechneKow FM Generator 21.5 GBq 1 Stk, 49358
21. UltratechneKow FM Generator 25.8 GBq 1 Stk, 49358
22. UltratechneKow FM Generator 30.1 GBq 1 Stk, 49358
23. UltratechneKow FM Generator 34.4 GBq 1 Stk, 49358
24. UltratechneKow FM Generator 43 GBq 1 Stk, 49358
25. XPhe smart A Plv neutral Ds 500 g,
26. XPhe smart A Plv Vanille Ds 500 g,
27. XPhe smart A Plv Zitrone Ds 500 g,
28. XPhe smart J Plv Vanille Ds 500 g,
29. XPhe smart J Plv Waldbeeren Ds 500 g,
30. XPhe smart J Plv Zitrone Ds 500 g,
31. XPhe smart K Plv neutral Ds 500 g,
32. XPhe smart K Plv Vanille Ds 500 g,
33. XPhe smart K Plv Waldbeeren Ds 500 g,
34. XPhe smart K Plv Zitrone Ds 500 g,
35. Candesartan CPS Tabl 8 mg Blist 28 Stk, 62569
36. Comirnaty LP.8.1 Inj Disp 30 mcg/Dosis Fertspr 0.3 ml (Teilpackung), 70403
37. Diaphin SR Ret Filmtabl 200 mg 100 Stk, 57720
38. Stamicis Markierungsbesteck Trockensub Fl 5 Stk, 59062
39. Encepur N Inj Susp Kind ohne Nadel Fertspr 0.25 ml (Teilpackung),
40. Fresubin 2 kcal Drink liq Apri/Pfir FlatCap 4x 200 ml,
41. Fresubin 2 kcal Drink liq Waldfruch FlatCap 4x 200 ml,
42. Fresubin 2 kcal Fibre Drink liq Lemo FlatCap 4x 200 ml,
43. Hemgenix Inf Konz 10ml 13-24 Stk, 61-120 kg KG Durchstf 1 Stk, 68780
44. Letrozol Zentiva Filmtabl 2.5 mg Blist 30 Stk, 61501
45. Menveo Trockensub c Solv Durchstf 1 Stk (Teilpackung), 62502
46. Natriumiodid (I-123) Inj Lös 37 MBq Amp 1 Stk, 52574
47. Vicks Nasivin Nasenspray 0.05 % Fl 10 ml, 54613
48. Vicks Nasivin Gtt Nas 0.01 % Fl 5 ml, 70160
49. Sodium iodide I-123 Curium Inj Lös 74 MBq Durchstf 2 ml, 52729
50. TechneScan DMSA Trockensub Fl 5 Stk, 55446
51. TechneScan DTPA Trockensub Fl 5 Stk, 42809
52. Tektrotyd Markierungsbesteck Trockensub Durchstf 2 Stk, 66540
53. XPhe smart J Plv neutral Ds 500 g,
54. OctreoScan Trockensub c Solv Fl 2 Stk, 52810
55. Metoject Autoinjektor Inj Lös 7.5 mg / 0.15 ml Fertpen 1 Stk, 65672
56. Metoject Autoinjektor Inj Lös 20 mg / 0.4 ml Fertpen 1 Stk, 65672
57. Mevalia PKU Balance 14+ 500 g,
58. XPhe smart A Plv Waldbeeren Ds 500 g,
59. Sodium iodide I-123 Curium Inj Lös 370 MBq Durchstf 10 ml, 52729
60. Teceos Trockensub 14.2 mg Fl 5 Stk, 44521
61. Candesartan Plus CPS Tabl 32/12.5mg Blist 28 Stk, 62570
62. Candesartan Plus CPS Tabl 32/25mg Blist 28 Stk, 62570
63. Metoject Autoinjektor Inj Lös 10 mg / 0.2 ml Fertpen 1 Stk, 65672
64. Natriumiodid (I-123) Kaps 7.4 MBq 1 Stk, 52573
65. MIBG I-123 Curium Inj Lös 222 MBq Amp 3 ml, 52731
66. Morphinium HCl Inj Lös 10 mg Amp 10 Stk,
67. Morphinium HCl Inj Lös 10 mg Amp 100 Stk,
68. Sodium iodide I-131 T Curium Kaps 1 Stk, 52728
69. Hemgenix Inf Konz 10ml 37-48 Stk, 181-240 kg KG Durchstf 1 Stk, 68780
70. Metoject Autoinjektor Inj Lös 15 mg / 0.3 ml Fertpen 1 Stk, 65672
71. Metoject Autoinjektor Inj Lös 17.5 mg / 0.35 ml Fertpen 1 Stk, 65672
72. Metoject Autoinjektor Inj Lös 25 mg / 0.5 ml Fertpen 1 Stk, 65672
73. Morphinium HCl Inj Lös 20 mg Amp 10 Stk,
74. Morphinium HCl Inj Lös 20 mg Amp 100 Stk,
75. Thallous chloride TI-201 Curium Inj Lös 370 MBq Fl 1 Stk, 44065
76. Yttriumcitrat (90Y) YMM1 Inj Susp 555 MBq 15 ml, 51703
77. Zolgensma Inf Lös 2x 10e13 Vektorgenome/ml Set 1 Stk, 67529
78. TechneScan MAG3 Trockensub Fl 5 Stk, 49796
79. Sodium iodide I-123 Curium Inj Lös 185 MBq Durchstf 5 ml, 52729
80. Vitarubin Depot Inj Lös 1 mg/ml Amp 1 ml (Teilpackung), 33584
81. Candesartan CPS Tabl 16 mg Blist 28 Stk, 62569
82. Candesartan CPS Tabl 32 mg Blist 28 Stk, 62569
83. Candesartan Plus CPS Tabl 16/12.5mg Blist 28 Stk, 62570
84. Eltrombopag NOBEL Filmtabl 50 mg Blist 14 Stk, 69450
85. Eltrombopag NOBEL Filmtabl 50 mg Blist 28 Stk, 69450
86. Diaphin Trockensub 5 g i.v. Amp 1 Stk, 55561
87. Eltrombopag NOBEL Filmtabl 12.5 mg Blist 14 Stk, 69450
88. TechneScan HDP Trockensub Fl 5 Stk, 49638
89. Thallous chloride TI-201 Curium Inj Lös 85 MBq Fl 1 Stk, 44065
90. MIBG I-123 Curium Inj Lös 148 MBq Amp 2 ml, 52731
91. MIBG I-123 Curium Inj Lös 370 MBq Amp 5 ml, 52731
92. Fresubin 2 kcal Drink liq Vanille FlatCap 4x 200 ml,
93. FSME Immun Junior Inj Susp ohne Nadel Fertspr 0.25 ml (Teilpackung),
94. Sodium iodide I-123 Curium Inj Lös 37 MBq Durchstf 1 ml, 52729
95. Diaphin IR Tabl 200 mg 100 Stk, 57724
96. Hemgenix Inf Konz 10ml 1-12 Stk, 51-60 kg KG Durchstf 1 Stk, 68780
97. Metoject Autoinjektor Inj Lös 12.5 mg / 0.25 ml Fertpen 1 Stk, 65672
98. Metoject Autoinjektor Inj Lös 22.5 mg / 0.45 ml Fertpen 1 Stk, 65672
99. Candesartan CPS Tabl 4 mg Blist 7 Stk, 62569
100. Candesartan Plus CPS Tabl 8/12.5mg Blist 28 Stk, 62570
101. Eltrombopag NOBEL Filmtabl 25 mg Blist 14 Stk, 69450
102. Eltrombopag NOBEL Filmtabl 25 mg Blist 28 Stk, 69450
103. Fresubin 2 kcal Fibre Drink liq Capp FlatCap 4x 200 ml,
104. Hemgenix Inf Konz 10ml 25-36 Stk, 121-180 kg KG Durchstf 1 Stk, 68780
105. Iopidine Gtt Opht 1 % 24 Monodos 0.25 ml, 53737
106. Mevalia PKU Balance 6+ Ds 500 g,
107. MIBG I-123 Curium Inj Lös 74 MBq Amp 1 ml, 52731
108. Ultravist 370 Inj Lös 370 mg/ml 30 ml Fl 1 Stk, 46969
109. Scintimun Granulocyte Trockensub Markierungsbesteck Fl 2 Stk, 51672
110. Vicks Nasivin Nasenspray 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

• Count: 1014

Sappinfo (filtered)

../input/sappinfo.xlsx

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

Usage

aips REGNRS (found/not found)

• in refdata: 4893/534 (5427)
• in swissmedic: 1132/4295 (5427)
• in bag: 41/5386 (5427)
• not found anywhere: 74

RefData

• GTINs used: 13656

Swissmedic

• GTINs used: 2679
• recovered dosage 652

BAG

• GTINs used: 0

BAG FHIR

• GTINs used: 108

ATC Codes

• 74 missing branches from ../input/atc_codes_multi_lingual.txt

swisspeddose.ch

• ATC with <Case>: 1130
• ATC without <Case>: 3454
• tables created: 4028

Sappinfo

Unique ATC

• breastFeed: 146
• pregnancy: 192

Tables created

• breastFeed: 890
• pregnancy: 1274

Sat Apr 25 04:21:52 2026