This Report was generated by: cpp2sqlite
- ./cpp2sqlite
- --verbose
- --inDir
- ../input
File Analysis
swisspeddose.ch
../input/../downloads/swisspeddosepublication_v4.xml
Cases 737
- <CaseID> set: 737
- <ATCCode> set: 254
- <ROACode> set: 14
Indications 367
Dosages 1335
- <CaseId> set: 737
- vec: 1335
Codes 5919
- _ALTERRELATION: 10
- _FG: 2
- _GEWICHT: 2
- ATC: 5683
- DOSISTYP: 86
- DOSISUNIT: 35
- 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 : 736
- 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: 183
- Without Zulassungsnummer: 13
DHPC HPC
../input/../downloads/dhpc_hpc_de.json
- Count: 67
- Without Zulassungsnummer: 53
AIPS
../input/../downloads/aips.xml
- medicalInformation fi de 4581
ATC codes 4581
- from aips: 4531
- from swissmedic: 38
- unique (from both aips and swissmedic): 1795
Titles with empty or invalid ATC code: 12
- RN: <58943> , title: <Apligraf>
- RN: <55442> , title: <ASCOSAL® Brausetabletten>
- RN: <51390> , title: <Becetamol® Tropfen>
- RN: <00000> , title: <DIGIFAB®, Lyophilisat>
- RN: <00000> , title: <Erythrozytenkonzentrat (EK) leukozytendepletiert, in additiver Lösung>
- RN: <00000> , title: <FACTOR X P BEHRING>
- RN: <12730> , title: <Methergin Injektionslösung s.c., i.m., i.v.>
- RN: <00000> , title: <Plasma (frisch gefroren), leukozytendepletiert, pathogeninaktiviert (INTERCEPT®)>
- RN: <00000> , title: <Plasma (frisch gefroren), leukozytendepletiert, quarantänegelagert (FGPq)>
- RN: <00000> , title: <SUCCICAPTAL 200 mg, Hartkapseln>
- RN: <67451> , title: <Tegsedi>
- RN: <00000> , title: <Thrombozytenkonzentrat, leukozytendepletiert und pathogeninaktiviert (Intercept®)>
ATC code text
- from aips: 4123
- from peddose: 389
- no text found: 57
titles with rn 00000 (ignored)
- DIGIFAB®, Lyophilisat
- Erythrozytenkonzentrat (EK) leukozytendepletiert, in additiver Lösung
- FACTOR X P BEHRING
- Plasma (frisch gefroren), leukozytendepletiert, pathogeninaktiviert (INTERCEPT®)
- Plasma (frisch gefroren), leukozytendepletiert, quarantänegelagert (FGPq)
- SUCCICAPTAL 200 mg, Hartkapseln
- Thrombozytenkonzentrat, leukozytendepletiert und pathogeninaktiviert (Intercept®)
Swissmedic has 16150 matching packages
RefData
../input/../downloads/refdata_pharma.xml
- PHARMA items: 16468
- PHARMA items with GTIN starting with "7680": 15387
- articles: 16470
BAG
../input/../downloads/bag_preparations.xml
- preparations: 6593
- packs: 10233
- packs without GTIN: 66
- GTIN recovered from <SwissmedicNo8>: 62
- 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
- 9969 GTIN are also in swissmedic
- 10000 GTIN are also in refdata
Sappinfo (filtered)
../input/sappinfo.xlsx
- Unique ATC set: 215
- rows Breast Feeding: 182
- rows Pregnancy: 282
Usage
aips REGNRS (found/not found)
- in refdata: 4866/586 (5452)
- in swissmedic: 1266/4186 (5452)
- in bag: 22/5430 (5452)
- not found anywhere: 86
54802, 54803, 66078, 42127, 69514, 55179, 55442, 66996, 25022, 51390, 67063, 55114, 31839, 56545, 43319, 39828, 10286, 42134, 56422, 57191, 17664, 55381, 47646, 41569, 67022, 57933, 65179, 47956, 55508, 44676, 65331, 52489, 20406, 03579, 71204, 59795, 59093, 62840, 67546, 65120, 54032, 54033, 55461, 67197, 46871, 48147, 56264, 56264, 00654, 65150, 41341, 68478, 47915, 56212, 26339, 44778, 55494, 51741, 51742, 54974, 68579, 57659, 56469, 60489, 67819, 67557, 61560, 61561, 61562, 61564, 61566, 65840, 66642, 66708, 67095, 67158, 49034, 01677, 46003, 24024, 47110, 68400, 42441, 56198, 61260, 62439
XML
title_str separator ';' was replaced for rgnrs
- 22114, 25644 "Syntocinon® Konzentrat zur Herstellung einer Injektions-/Infusionslösung; Syntocinon® Nasenspray, Lösung"
- 50655, 47920 "Ecomucyl® Sandoz Brausetabletten; Ecomucyl® Sandoz Granulat"
- 50710, 54157, 50709 "Zofran®, Filmtabletten; Zofran®, Infusionskonzentrat/Injektionslösung; Zofran®, Zydis® Schmelztabletten"
- 54842 "CoAprovel® 150/12,5; 300/12,5; 300/25"
- 58620, 58674 "Mycophenolat-Mofetil Sandoz® 250 mg, Kapseln; Mycophenolat-Mofetil Sandoz® 500 mg, Filmtabletten"
- 61222, 61223, 61896 "Montelukast Sandoz® Granulat; Montelukast Sandoz® Kautabletten; Montelukast Sandoz® Filmtabletten"
- 62278 "Irbesartan HCT Zentiva®150/12,5; 300/12,5; 300/25"
- 62904 "Perindopril-Indapamid-Mepha 2.5/0.625 mg, Filmtabletten; Perindopril-Indapamid-Mepha 5/1.25 mg, Filmtabletten"
XML
For these rgnrs, <img> has no "alt" attribute
- 46489, 65479
- 54785, 65474
- 56202
- 57460
- 58734
- 62385
- 62386
- 62780
- 65561
- 66411
- 66533
- 67565
- 68145
- 68229
- 68864
- 68996
- 69330
- 69443
RefData
Swissmedic
- GTINs used: 3063
- recovered dosage 773
BAG
ATC Codes
- 67 missing branches from ../input/atc_codes_multi_lingual.txt
A01, A03AD, A05AX, B05CB, B06AX, C02DD, C09XX, D08AE, D09, D09A, D09AA, G03XX, H02C, H02CA, J05AJ, 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, N03X, N03X1, N05BX, N05CJ, P02CF, R07AB
swisspeddose.ch
- ATC with <Case>: 1067
- ATC without <Case>: 3501
- tables created: 3912
Sappinfo
Unique ATC
- breastFeed: 144
- pregnancy: 191
Tables created
- breastFeed: 901
- pregnancy: 1275
Sun Mar 23 04:16:32 2025