This Report was generated by: cpp2sqlite

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

File Analysis

swisspeddose.ch

../input/../downloads/swisspeddosepublication_v3.xml

Cases 529

• <CaseID> set: 529
• <ATCCode> set: 159
• <ROACode> set: 13

Indications 282

• <IndicationKey> map: 282

Dosages 896

• <CaseId> set: 529
• vec: 896

Codes 5631

• _ALTERRELATION: 8
• _FG: 2
• _GEWICHT: 2
• ATC: 5405
• DOSISTYP: 81
• DOSISUNIT: 35
• EVIDENZ: 6
• ROA: 78
• ZEIT: 14

Swissmedic

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

• rows: 17985

ATC Codes

../input/atc_codes_multi_lingual.txt

• # lines: 2635

Drugshortage

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

• GTINs : 465
• 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: 96
• Without Zulassungsnummer: 9

DHPC HPC

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

• Count: 44
• Without Zulassungsnummer: 52

AIPS

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

• medicalInformation fi de 4467

ATC codes 4467

• from aips: 4416
• from swissmedic: 38
• unique (from both aips and swissmedic): 1745

Titles with empty or invalid ATC code: 13

• RN: <67575> , title: <Abecma®>
• RN: <58943> , title: <Apligraf>
• RN: <67469> , title: <Breyanzi®>
• RN: <00000> , title: <DIGIFAB® DIGOXIN IMMUNE FAB (OVINE)>
• RN: <00000> , title: <EVUSHELD 100 mg/ml + 100 mg/ml Solution for Injection>
• RN: <00000> , title: <FACTOR X P BEHRING>
• RN: <66778> , title: <KYMRIAH®>
• RN: <00000> , title: <Paxlovid™>
• RN: <00000> , title: <SUCCICAPTAL 200 mg, Hartkapseln>
• RN: <67884> , title: <Tecartus®>
• RN: <00000> , title: <Veklury®>
• RN: <66986> , title: <YESCARTA®>
• RN: <63051> , title: <Zeel comp.>

ATC code text

• from aips: 4235
• from peddose: 188
• no text found: 31

rgnrs that contained duplicates

• 26396, 26395

titles with rn 00000 (ignored)

• DIGIFAB® DIGOXIN IMMUNE FAB (OVINE)
• EVUSHELD 100 mg/ml + 100 mg/ml Solution for Injection
• FACTOR X P BEHRING
• Paxlovid™
• SUCCICAPTAL 200 mg, Hartkapseln
• Veklury®

Swissmedic has 16077 matching packages

RefData

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

• PHARMA items: 16256
• PHARMA items with GTIN starting with "7680": 15072
• articles: 16258

BAG

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

• preparations: 6351
• packs: 9968
• packs without GTIN: 89
• GTIN recovered from <SwissmedicNo8>: 85
• 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

• 9639 GTIN are also in swissmedic
• 9774 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: 4784/611 (5395)
• in swissmedic: 1316/4079 (5395)
• in bag: 27/5368 (5395)
• not found anywhere: 74

XML

title_str separator ';' was replaced for rgnrs

• 50655, 47920 "Ecomucyl® Sandoz Brausetabletten; Ecomucyl® Sandoz Granulat"
• 51075, 51076 "Calciumfolinat Sandoz® eco, Injektions-/Infusionslösung; Calciumfolinat Sandoz®, Kapseln"
• 52787, 52788 "Trabar 50; Trabar 100"
• 53985, 55622 "ACC Sandoz® Brausetabletten; ACC Sandoz® Granulat"
• 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"
• 62728, 62730 "Diclo-Acino 25/50, Filmtabletten; Diclo-Acino 100 retard, Retardkapseln"
• 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

• 42809
• 44521
• 46489, 65479
• 49796
• 54785, 65474
• 55057
• 56202
• 57289
• 58182, 59376, 59377
• 58618
• 58734
• 62442
• 62780
• 65561
• 67007
• 67565
• 67941
• 68145
• 68229

RefData

• GTINs used: 13576

Swissmedic

• GTINs used: 3227
• recovered dosage 955

BAG

• GTINs used: 68

ATC Codes

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

swisspeddose.ch

• ATC with <Case>: 735
• ATC without <Case>: 3718
• tables created: 3044

Sappinfo

Unique ATC

• breastFeed: 147
• pregnancy: 193

Tables created

• breastFeed: 963
• pregnancy: 1350

Sat May 28 04:13:38 2022