This Report was generated by: cpp2sqlite
- ./cpp2sqlite
- --verbose
- --lang=fr
- --inDir
- ../input
File Analysis
swisspeddose.ch
../input/../downloads/swisspeddosepublication_v4.xml
Cases 688
- <CaseID> set: 684
- <ATCCode> set: 236
- <ROACode> set: 14
Indications 348
Dosages 1228
- <CaseId> set: 684
- vec: 1228
Codes 5916
- _ALTERRELATION: 9
- _FG: 2
- _GEWICHT: 2
- ATC: 5682
- DOSISTYP: 86
- DOSISUNIT: 35
- EVIDENZ: 6
- ROA: 79
- ZEIT: 15
Swissmedic
../input/../downloads/swissmedic_packages.xlsx
ATC Codes
../input/atc_codes_multi_lingual.txt
Drugshortage
../input/../downloads/drugshortage.json
- GTINs : 822
- 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: 100
- Without Zulassungsnummer: 5
DHPC HPC
../input/../downloads/dhpc_hpc_fr.json
- Count: 43
- Without Zulassungsnummer: 77
AIPS
../input/../downloads/aips.xml
- medicalInformation fi fr 4550
ATC codes 4550
- from aips: 4497
- from swissmedic: 42
- unique (from both aips and swissmedic): 1783
Titles with empty or invalid ATC code: 11
- RN: <58943> , title: <Apligraf>
- RN: <55442> , title: <Ascosal® comprimés effervescents>
- RN: <51390> , title: <Becetamol® Gouttes>
- RN: <00000> , title: <Concentré érythrocytaire (CE) déplété en leucocytes, en solution additive>
- RN: <00000> , title: <Concentré plaquettaire déplété en leucocytes, à pathogènes inactivés (Intercept®)>
- RN: <00000> , title: <DIGIFAB®, Lyophilisat>
- RN: <00000> , title: <FACTOR X P BEHRING>
- RN: <00000> , title: <Plasma (frais congelé), déplété en leucocytes, conservé en quarantaine (PFCq)>
- RN: <00000> , title: <Plasma (frais congelé), déplété en leucocytes, soumis à l’inactivation des agents pathogènes (INTERC>
- RN: <00000> , title: <SUCCICAPTAL 200 mg, Gélules>
- RN: <63051> , title: <Zeel comp.>
ATC code text
- from aips: 4123
- from peddose: 394
- no text found: 22
rgnrs that contained duplicates
titles with rn 00000 (ignored)
- Concentré érythrocytaire (CE) déplété en leucocytes, en solution additive
- Concentré plaquettaire déplété en leucocytes, à pathogènes inactivés (Intercept®)
- DIGIFAB®, Lyophilisat
- FACTOR X P BEHRING
- Plasma (frais congelé), déplété en leucocytes, conservé en quarantaine (PFCq)
- Plasma (frais congelé), déplété en leucocytes, soumis à l’inactivation des agents pathogènes (INTERC
- SUCCICAPTAL 200 mg, Gélules
Swissmedic has 16067 matching packages
RefData
../input/../downloads/refdata_pharma.xml
- PHARMA items: 16360
- PHARMA items with GTIN starting with "7680": 15245
- articles: 16362
BAG
../input/../downloads/bag_preparations.xml
- preparations: 6515
- packs: 10208
- packs without GTIN: 74
- GTIN recovered from <SwissmedicNo8>: 70
- GTIN unrecoverable from <SwissmedicNo8>: 4
<SwissmedicNo8> empty
- <NameFr> Morphinium HCl, <DescriptionFr> sol inj 10 mg
- <NameFr> Morphinium HCl, <DescriptionFr> sol inj 10 mg
- <NameFr> Morphinium HCl, <DescriptionFr> sol inj 20 mg
- <NameFr> Morphinium HCl, <DescriptionFr> sol inj 20 mg
Cross-reference
- 9786 GTIN are also in swissmedic
- 9996 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: 4840/584 (5424)
- in swissmedic: 1282/4142 (5424)
- in bag: 32/5392 (5424)
- not found anywhere: 80
66465, 54802, 54803, 55179, 53994, 66996, 25022, 67063, 55114, 56749, 55823, 39828, 10286, 42134, 56422, 57191, 60230, 30157, 47646, 41569, 67022, 57933, 65179, 55508, 44676, 52489, 20406, 03579, 71204, 59795, 66337, 17664, 62840, 61320, 61325, 67546, 65120, 54032, 54033, 55461, 67197, 30901, 46871, 00654, 65150, 41341, 68478, 47915, 26339, 44778, 55494, 51741, 51742, 54006, 54974, 62809, 57659, 57534, 67819, 67557, 47589, 48134, 47481, 65840, 66642, 66708, 67095, 67158, 49034, 68003, 38359, 38130, 53703, 66660, 42497, 24024, 48198, 56198, 61260, 62439
XML
title_str separator ';' was replaced for rgnrs
- 22114, 25644 "Syntocinon®solution à diluer pour solution injectable/pour perfusion; Syntocinon® spray nasal, solution"
- 50655, 47920 "Ecomucyl® Sandoz comprimés effervescents; Ecomucyl® Sandoz granulés"
- 50710, 54157, 50709 "Zofran®, comprimés pelliculés; Zofran®, concentré pour perfusion/solution injectable; Zofran®, Zydis comprimés orodispersibles"
- 52787, 52788 "Trabar 50; Trabar 100"
- 54842 "CoAprovel® 150/12,5; 300/12,5; 300/25"
- 58620, 58674 "Mycophénolate-Mofétil Sandoz® 250 mg, capsules; Mycophénolate-Mofétil Sandoz® 500 mg, comprimés pelliculés"
- 61222, 61223, 61896 "Montélukast Sandoz® granulé; Montélukast Sandoz® comprimés â mâcher; Montélukast Sandoz® comprimés pelliculés"
- 62278 "Irbesartan HCT Zentiva® 150/12,5; 300/12,5; 300/25"
- 62728, 62730 "Diclo-Acino 25/50, comprimés pelliculés; Diclo-Acino 100 retard, capsules à libération prolongée"
- 62904 "Perindopril-Indapamid-Mepha 2.5/0.625 mg, comprimés pelliculés; Perindopril-Indapamid-Mepha 5/1.25 mg, comprimés pelliculés"
XML
For these rgnrs, <img> has no "alt" attribute
- 42809
- 46489, 65479
- 52810
- 54785, 65474
- 58734
- 62780
- 63123
- 65561
- 66533
- 67007
- 68229
- 68864
- 68996
RefData
Swissmedic
- GTINs used: 3127
- recovered dosage 811
BAG
ATC Codes
- 59 missing branches from ../input/atc_codes_multi_lingual.txt
A01, A03AD, B05CB, C02DD, D08AE, D09, D09A, D09AA, G03XX, H02C, H02CA, J05AJ, J06BD, J07BN, L01CE, L01E, L01EA, L01EB, L01EC, L01ED, L01EE, L01EF, L01EH, L01EJ, L01EK, L01EL, L01EM, L01EN, L01EX, L01F, L01FA, L01FB, L01FC, L01FD, L01FE, L01FF, L01FG, L01FX, L01FY, L01XF, L01XG, L01XH, L01XJ, L01XK, L01XL, L01XY, L04AJ, L91, L91A, L91AB, M03BA, M04AC, N02BF, N02CD, N03X, N03X1, N05BX, N05CJ, P02CF
swisspeddose.ch
- ATC with <Case>: 1015
- ATC without <Case>: 3523
- tables created: 3697
Sappinfo
Unique ATC
- breastFeed: 146
- pregnancy: 192
Tables created
- breastFeed: 917
- pregnancy: 1294
Wed Apr 24 04:04:53 2024