Characteristics of raw data
There are about 40 million rows of raw data after cleaning, which contains the prescription number (PN), Consumer's names (Name), the Consumption date (Date), the name of TCMs (CMN), dosages (DD), and the number of days taken (days). The sample table of raw data is shown in Table 2 and the patient’s name in the table is anonymized. 40 million rows of data are stored in the MySQL database for further analysis.
Table 2 A sample table of raw data
PN
|
Date
|
Name
|
days (d)
|
CMN
|
DD (g/d)
|
115368
|
2018/9/1
|
Patient1
|
7
|
Scutellariae radix
|
12
|
115368
|
2018/9/1
|
Patient1
|
7
|
Glycyrrhizae radix et rhizoma
|
15
|
115368
|
2018/9/1
|
Patient1
|
7
|
Atractylodis macrocephalae rhizoma
|
25
|
115368
|
2018/9/1
|
Patient1
|
7
|
Citri reticulatae pericarpium
|
15
|
115368
|
2018/9/1
|
Patient1
|
7
|
Rhei radix et rhizoma
|
6
|
115368
|
2018/9/1
|
Patient1
|
7
|
Trichosanthis radix
|
15
|
130869
|
2018/9/1
|
Patient2
|
7
|
Bupleuri radix
|
30
|
130869
|
2018/9/1
|
Patient2
|
7
|
Glycyrrhizae radix et rhizoma
|
18
|
130869
|
2018/9/1
|
Patient2
|
7
|
Rhei radix et rhizoma
|
10
|
130869
|
2018/9/1
|
Patient2
|
7
|
Magnoliae officinalis cortex
|
30
|
130869
|
2018/9/1
|
Patient2
|
7
|
Menthae haplocalycis herba
|
9
|
130869
|
2018/9/1
|
Patient2
|
7
|
Coicis semen
|
60
|
Consumption situation of all TCMs
The results of all TCMs consumption situations include the annual consumption, consumption days, and the average daily consumption of TCMs. The result indicates that a total of 408,250 people consumed TCMs in these Shanghai hospitals and pharmacies in 2019. Table 3 shows averages of annual consumption, consumption days and average daily consumption of all TCMs are 12923 g, 44 d, and 259 g/d, respectively. The distribution of annual consumption of TCMs consumers is shown in Fig. 2.
Table 3 Averages and quantiles of annual consumption, consumption days, and average daily consumption of all TCMs
|
Annual consumption (g)
|
Consumption days (d)
|
Average daily consumption (g/d)
|
P5
|
868
|
7
|
102
|
P50
|
5208
|
21
|
245
|
P95
|
53256
|
168
|
456
|
Mean
|
12923
|
44
|
259
|
Consumption situation of 20 specific Chinese medicines
Fig. 3 indicates that the number of consumers of Astragali radix, Atractylodis macrocephalae rhizoma and Glycyrrhizae radix et rhizoma is the top three. The number of people who consume these three Chinese medicines exceeds 250,000, which means that more than half of the consumers contain these kinds of Chinese medicines. Averages and quantiles of the annual consumption of 20 specific Chinese medicines are shown in Fig. 4. The TCM with the highest consumption is Astragali Radix, and its P95 of annual consumption is close to 4000 g/y (Table 4). Depending on the results of data analysis, the average consumption days of each Chinese medicine in 2019 are between 25 and 44 days (Table 5). Table 6 shows the average daily consumption of TCMs during the days of consuming TCMs.
Table 4 Averages and quantiles of the annual consumption of 20 specific TCMs (g/y)
Name of TCMs
|
P5
|
P50
|
P90
|
P95
|
P97.5
|
Mean
|
P. lactiflora
|
63
|
210
|
1050
|
1630
|
2310
|
457
|
A. macrocephala
|
63
|
252
|
1449
|
2226
|
3108
|
593
|
S. miltiorrhiza
|
84
|
420
|
1725
|
2940
|
4200
|
783
|
C. smyrnioides
|
70
|
252
|
1260
|
1974
|
2730
|
545
|
L. Barbarum
|
35
|
126
|
560
|
854
|
1218
|
238
|
G. uralensis
|
70
|
252
|
1155
|
1680
|
2394
|
491
|
A. membranaceus
|
105
|
420
|
2520
|
3990
|
5670
|
1032
|
S. baicalensis
|
63
|
168
|
756
|
1134
|
1638
|
329
|
L. japonica
|
45
|
143
|
630
|
1008
|
1512
|
301
|
C. morifolium
|
42
|
126
|
530
|
840
|
1260
|
261
|
O. japonicus
|
63
|
210
|
1008
|
1554
|
2310
|
436
|
P. ginseng
|
63
|
210
|
1050
|
1680
|
2310
|
461
|
A. bidentata
|
21
|
147
|
924
|
1680
|
2730
|
424
|
P. notoginseng
|
28
|
150
|
728
|
1120
|
1596
|
305
|
D. Opposita
|
84
|
336
|
1680
|
2520
|
3570
|
686
|
D. nobile
|
63
|
280
|
1470
|
2240
|
3150
|
602
|
Z. jujuba
|
63
|
252
|
1260
|
2058
|
2940
|
557
|
E. sinensis Walker
|
54
|
126
|
567
|
882
|
1190
|
258
|
C. yanhusuo
|
63
|
210
|
840
|
1431
|
2100
|
408
|
C. lacryma-jobi
|
105
|
420
|
2310
|
3780
|
5125
|
960
|
Table 5 Averages and quantiles of consumption days of 20 specific TCMs (d)
Name of TCMs
|
P5
|
P50
|
P90
|
P95
|
P97.5
|
Mean
|
P. lactiflora
|
7
|
14
|
70
|
112
|
154
|
32
|
A. macrocephala
|
7
|
21
|
105
|
161
|
224
|
43
|
S. miltiorrhiza
|
7
|
19
|
84
|
126
|
182
|
37
|
C. smyrnioides
|
7
|
17
|
84
|
126
|
175
|
36
|
L. Barbarum
|
7
|
14
|
84
|
126
|
168
|
35
|
G. uralensis
|
7
|
21
|
84
|
126
|
182
|
37
|
A. membranaceus
|
7
|
21
|
112
|
168
|
224
|
44
|
S. baicalensis
|
7
|
14
|
70
|
112
|
154
|
32
|
L. japonica
|
7
|
14
|
56
|
84
|
121
|
26
|
C. morifolium
|
7
|
14
|
56
|
84
|
112
|
25
|
O. japonicus
|
7
|
14
|
84
|
126
|
168
|
35
|
P. ginseng
|
7
|
21
|
84
|
119
|
168
|
35
|
A. bidentata
|
7
|
21
|
84
|
133
|
182
|
37
|
P. notoginseng
|
7
|
14
|
70
|
111
|
147
|
32
|
D. Opposita
|
7
|
21
|
98
|
140
|
196
|
39
|
D. nobile
|
7
|
20
|
84
|
140
|
189
|
38
|
Z. jujuba
|
7
|
21
|
84
|
126
|
168
|
36
|
E. sinensis Walker
|
7
|
14
|
56
|
84
|
126
|
26
|
C. yanhusuo
|
7
|
14
|
63
|
91
|
126
|
29
|
C. lacryma-jobi
|
7
|
21
|
105
|
154
|
210
|
42
|
Table 6 Averages and quantiles of Average daily consumption of 20 specific TCMs (g/d)
Name of TCMs
|
P5
|
P50
|
P90
|
P95
|
P97.5
|
Mean
|
P. lactiflora
|
9
|
13
|
19
|
30
|
30
|
14
|
A. macrocephala
|
9
|
12
|
18
|
27
|
30
|
14
|
S. miltiorrhiza
|
9
|
15
|
30
|
30
|
58
|
20
|
C. smyrnioides
|
9
|
15
|
24
|
30
|
30
|
15
|
L. Barbarum
|
3
|
6
|
9
|
10
|
12
|
7
|
G. uralensis
|
8
|
12
|
18
|
22
|
30
|
13
|
A. membranaceus
|
9
|
20
|
30
|
38
|
50
|
22
|
S. baicalensis
|
6
|
9
|
15
|
15
|
18
|
10
|
L. japonica
|
6
|
9
|
18
|
20
|
30
|
11
|
C. morifolium
|
6
|
9
|
15
|
20
|
30
|
10
|
O. japonicus
|
8
|
10
|
18
|
20
|
29
|
12
|
P. ginseng
|
8
|
11
|
18
|
27
|
30
|
13
|
A. bidentata
|
3
|
8
|
20
|
30
|
30
|
10
|
P. notoginseng
|
2
|
9
|
15
|
18
|
30
|
9
|
D. Opposita
|
9
|
15
|
30
|
30
|
30
|
17
|
D. nobile
|
9
|
15
|
30
|
30
|
30
|
16
|
Z. jujuba
|
8
|
15
|
28
|
30
|
30
|
15
|
E. sinensis Walker
|
6
|
9
|
12
|
15
|
18
|
10
|
C. yanhusuo
|
8
|
12
|
25
|
30
|
30
|
14
|
C. lacryma-jobi
|
9
|
22
|
30
|
30
|
30
|
22
|
Preliminary establishment of the Chinese medicine consumption database (CMCD)
Based on the above results, we constructed a user-friendly database, the Chinese medicine consumption database (CMCD), which can also be accessed at http://112.53.182.21:1444/, using R package Shiny. On this website, administrators can upload new processed Chinese medicine consumption data to keep the database updated and maintained. Users also can browse each specific Chinese medicine and download the excel format of medicine consumption data from the website.