This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 2811 | 2811 | 1899-06-21 | 2 | a-c | The fourth and final part of a report submitted by Qing Qin Wang. | http://trove.nla.gov.au/newspaper/page/24102440 | 24102440 | ||
| 2812 | 2812 | 1899-06-21 | 2 | c-e | The fourth and final part of an essay on business association and local and national administration. | http://trove.nla.gov.au/newspaper/page/24102440 | 24102440 | ||
| 2813 | 2813 | 1899-06-21 | 2 | e | An article written by Zhu Yutang advising Chinese to quit opium-smoking. | http://trove.nla.gov.au/newspaper/page/24102440 | 24102440 | ||
| 2814 | 2814 | 1899-06-21 | 2 | e-f | Chinese fellow, Yong Li, of Sussex Street, Sydney, was robbed. | http://trove.nla.gov.au/newspaper/page/24102440 | 24102440 | ||
| 2815 | 2815 | 1899-06-21 | 2 | f | More than 200 people die while mining gold in South Africa. | http://trove.nla.gov.au/newspaper/page/24102440 | 24102440 | ||
| 2816 | 2816 | 1899-06-21 | 2 | f | A man from Austria explores Antarctica. | http://trove.nla.gov.au/newspaper/page/24102440 | 24102440 | ||
| 2817 | 2817 | 1899-06-21 | 3 | a | A dragon in the mountain of Xinhui county brings disaster whenever it comes out. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2818 | 2818 | 1899-06-21 | 3 | a | An earthquake in Victoria. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2819 | 2819 | 1899-06-21 | 3 | a | Famine in Russia has been followed by epidemic. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2820 | 2820 | 1899-06-21 | 3 | b | Two robbers were arrested and charged with attacking Chinese man in South Melbourne. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2821 | 2821 | 1899-06-21 | 3 | b | A newspaper in Sydney was fined for defamation. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2822 | 2822 | 1899-06-21 | 3 | b | Korea leases out three ports to Russia for 12 years. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2823 | 2823 | 1899-06-21 | 3 | b | A commander of the Italian army was arrested by French forces. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2824 | 2824 | 1899-06-21 | 3 | b | Number of Chinese migrant in the USA. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2825 | 2825 | 1899-06-21 | 3 | b | Price of metal in London. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2826 | 2826 | 1899-06-21 | 3 | b | Fighting between USA troops and local forces in the Philippines. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2827 | 2827 | 1899-06-21 | 3 | c | A hotel in Sydney was robbed. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2828 | 2828 | 1899-06-21 | 3 | c | French government has more budget for military training. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2829 | 2829 | 1899-06-21 | 3 | c | Discussions between Germany and the Netherlands on the international peace conference. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2830 | 2830 | 1899-06-21 | 3 | c | German newspaper comments on British opinions on the international peace conference. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2831 | 2831 | 1899-06-21 | 3 | c | Church and other organisations raise funds for hospitals in London. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2832 | 2832 | 1899-06-21 | 3 | c-d | Weather, rain falls in New South Wales. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2833 | 2833 | 1899-06-21 | 3 | d | Three men in NSW die after an explosion in a mine. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2834 | 2834 | 1899-06-21 | 3 | d | War in Luzon, involvement of USA. Counterattack by soldiers of the Philippines army. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2835 | 2835 | 1899-06-21 | 3 | d | Epidemic disease in Persia. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2836 | 2836 | 1899-06-21 | 3 | d | A philanthropist's good work in Britain. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2837 | 2837 | 1899-06-21 | 3 | e | British government outraged at China's refusal to remove the Guangxi governor. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2838 | 2838 | 1899-06-21 | 3 | e | London prepares to open a river. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2839 | 2839 | 1899-06-21 | 3 | e | An old woman in Melbourne canot find her way home. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2840 | 2840 | 1899-06-21 | 3 | e | A suspect of in a murder case was detained in Brisbane. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2841 | 2841 | 1899-06-21 | 3 | e | Governor of Hubei province remains loyal to the nation. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2842 | 2842 | 1899-06-21 | 3 | e-f | A mother in Foshan cheated during her marriage for the benefit of her daughter. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2843 | 2843 | 1899-06-21 | 3 | f | Imperial court of China plans to select beautiful girls for the court. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2844 | 2844 | 1899-06-21 | 3 | f | Eight Chinese return home with gold. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 |
JSON shape: default, array, newline-delimited
CREATE TABLE [article_index] (
[date] TEXT,
[page] TEXT,
[column] TEXT,
[title] TEXT,
[description] TEXT,
[source] TEXT,
[page_url] TEXT,
[trove_id] TEXT
);
CREATE INDEX [idx_article_index_date]
ON [article_index] ([date]);