| id | name |
|---|---|
| 1 | John Doe |
| 2 | Jane Smith |
| 3 | Michael Johnson |
| 4 | Emily Davis |
| 5 | David Brown |
| id | title | press_release | interview | author_id |
|---|---|---|---|---|
| (→ Authors.id) | ||||
| 1 | Britain Is Cutting Taxes Again. Why Now? | This is a press release about Britain cutting taxes again. | An interview discussing the tax cut. | 1 |
| 2 | US Economy on the Rise. | A discussion of the recent growth in the US economy. | No interview. | 2 |
| 3 | European Markets Stabilize. | Discussing the recent stabilization of European markets. | An interview with a market analyst. | 3 |
| 4 | Tech Giants Dominate Market. | Examining the dominance of tech giants in various industries. | No interview. | 4 |
| 5 | Climate Change Impact on Business. | Assessing the impact of climate change on business operations. | An interview with an environmental economist. | 5 |
| id | name |
|---|---|
| 1 | The Daily Herald |
| 2 | Financial Times |
| 3 | Wall Street Journal |
| 4 | Economic Weekly |
| 5 | Business Today |
| article_id | outlet_id | publication_date |
|---|---|---|
| (→ Articles.id) | (→ NewsOutlets.id) | |
| 1 | 1 | 2022-07-01 |
| 2 | 2 | 2022-07-02 |
| 3 | 3 | 2022-07-03 |
| 4 | 4 | 2022-07-04 |
| 5 | 5 | 2022-07-05 |
| id | source_name |
|---|---|
| 1 | World Bank Report |
| 2 | International Monetary Fund Study |
| 3 | Central Intelligence Agency Analysis |
| 4 | United Nations Environmental Programme Research |
| 5 | National Bureau of Economic Research Data |
| article_id | source_id | reference_text |
|---|---|---|
| (→ Articles.id) | (→ Sources.id) | |
| 1 | 1 | According to the World Bank report... |
| 1 | 2 | As stated in the IMF study... |
| 2 | 3 | Based on CIA analysis... |
| 3 | 4 | UNEP research shows... |
| 4 | 5 | NBER data indicates... |