This Report was generated by: cpp2sqlite

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

File Analysis

swisspeddose.ch

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

Cases 713

• <CaseID> set: 713
• <ATCCode> set: 245
• <ROACode> set: 14

Indications 364

• <IndicationKey> map: 364

Dosages 1275

• <CaseId> set: 713
• vec: 1275

Codes 5918

• _ALTERRELATION: 10
• _FG: 2
• _GEWICHT: 2
• ATC: 5683
• DOSISTYP: 86
• DOSISUNIT: 35
• EVIDENZ: 6
• ROA: 79
• ZEIT: 15

Swissmedic

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

• rows: 17902

ATC Codes

../input/atc_codes_multi_lingual.txt

• # lines: 2635

Drugshortage

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

• GTINs : 723
• 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: 100
• Without Zulassungsnummer: 5

DHPC HPC

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

• Count: 68
• Without Zulassungsnummer: 52

AIPS

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

• medicalInformation fi de 4556

ATC codes 4556

• from aips: 4501
• from swissmedic: 43
• unique (from both aips and swissmedic): 1792

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: <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®)>
• RN: <63051> , title: <Zeel comp.>

ATC code text

• from aips: 4113
• from peddose: 390
• no text found: 41

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 16069 matching packages

RefData

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

• PHARMA items: 16412
• PHARMA items with GTIN starting with "7680": 15318
• articles: 16414

BAG

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

• preparations: 6511
• packs: 10171
• packs without GTIN: 67
• GTIN recovered from <SwissmedicNo8>: 63
• GTIN unrecoverable from <SwissmedicNo8>: 4

<SwissmedicNo8> empty

1. <NameDe> Morphinium HCl, <DescriptionDe> Inj Lös 10 mg
2. <NameDe> Morphinium HCl, <DescriptionDe> Inj Lös 10 mg
3. <NameDe> Morphinium HCl, <DescriptionDe> Inj Lös 20 mg
4. <NameDe> Morphinium HCl, <DescriptionDe> Inj Lös 20 mg

Cross-reference

• 9875 GTIN are also in swissmedic
• 9995 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: 4853/576 (5429)
• in swissmedic: 1262/4167 (5429)
• in bag: 26/5403 (5429)
• not found anywhere: 80

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"
• 52787, 52788 "Trabar 50; Trabar 100"
• 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
• 58734
• 62385
• 62386
• 62780
• 65561
• 66411
• 66533
• 66930
• 67565
• 68145
• 68229
• 68864
• 68996
• 69481

RefData

• GTINs used: 13804

Swissmedic

• GTINs used: 3072
• recovered dosage 791

BAG

• GTINs used: 38

ATC Codes

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

swisspeddose.ch

• ATC with <Case>: 1041
• ATC without <Case>: 3502
• tables created: 3777

Sappinfo

Unique ATC

• breastFeed: 145
• pregnancy: 192

Tables created

• breastFeed: 904
• pregnancy: 1278

Sun Oct 27 04:11:29 2024