This data as json, CSV (advanced)
Suggested facets: column
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 1778 | 1778 | 1899-02-18 | 2 | a | The colourful clouds of luckiness appeared in Beijing. | http://trove.nla.gov.au/newspaper/page/24102297 | 24102297 | ||
| 1779 | 1779 | 1899-02-18 | 2 | b | The four characters Qin Chunxuan wrote before leaving Guangdong. | http://trove.nla.gov.au/newspaper/page/24102297 | 24102297 | ||
| 1780 | 1780 | 1899-02-18 | 2 | b | A farewell poem written by Tao Bingxi of Panyu to farewell Qin Chunxuan. | http://trove.nla.gov.au/newspaper/page/24102297 | 24102297 | ||
| 1781 | 1781 | 1899-02-18 | 2 | b | An ill Chinese man was dignosed with leprosy, sent to hospital in Sydney. | http://trove.nla.gov.au/newspaper/page/24102297 | 24102297 | ||
| 1782 | 1782 | 1899-02-18 | 2 | b-c | Woman in Xiangshan waits for her fiance to return from Macao. | http://trove.nla.gov.au/newspaper/page/24102297 | 24102297 | ||
| 1783 | 1783 | 1899-02-18 | 2 | c | New newspaper, Qing Yi Bao, created in Yokohama following example of Shi Wu Bao in Shanghai. Liang Qichao is the chief writer. | http://trove.nla.gov.au/newspaper/page/24102297 | 24102297 | ||
| 1784 | 1784 | 1899-02-18 | 2 | c-d | Couple in Zengcheng lead a happy life after marrying recently. | http://trove.nla.gov.au/newspaper/page/24102297 | 24102297 | ||
| 1785 | 1785 | 1899-02-18 | 2 | d | US and local forces clash in Luzon as fighting resumes. | http://trove.nla.gov.au/newspaper/page/24102297 | 24102297 | ||
| 1786 | 1786 | 1899-02-18 | 2 | d | New governor of New South Wales to take up his position soon. | http://trove.nla.gov.au/newspaper/page/24102297 | 24102297 | ||
| 1787 | 1787 | 1899-02-18 | 2 | d | Lin Yik Tong organises party for Chinese and Western businessmen. Over 260 people attended. | http://trove.nla.gov.au/newspaper/page/24102297 | 24102297 | ||
| 1788 | 1788 | 1899-02-18 | 2 | d-e | High-ranking official has six characters in his office which reveal his real thoughts. | http://trove.nla.gov.au/newspaper/page/24102297 | 24102297 | ||
| 1789 | 1789 | 1899-02-18 | 2 | e | Zhang Qiaoye, governor of Xinjiang, recalled to Beijing for new appointment; freak dog in Beijing has two horns. | http://trove.nla.gov.au/newspaper/page/24102297 | 24102297 | ||
| 1790 | 1790 | 1899-02-18 | 2 | e-f | A tiger was seen in the mountains of Xiangshan. | http://trove.nla.gov.au/newspaper/page/24102297 | 24102297 | ||
| 1791 | 1791 | 1899-02-18 | 2 | f | An old man in Panyu successfully passed the imperial examination. | http://trove.nla.gov.au/newspaper/page/24102297 | 24102297 | ||
| 1792 | 1792 | 1899-02-18 | 2 | f | Chinese money exported for use by overseas Chinese. | http://trove.nla.gov.au/newspaper/page/24102297 | 24102297 |
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]);