This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 5555 | 5555 | 1900-06-27 | 2 | a-b | A discussion on recent riots in Beijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102854 | 24102854 | |
| 5556 | 5556 | 1900-06-27 | 2 | b-c | The first part of a list outlining foreign gunboats in east Asia. | Other... | http://trove.nla.gov.au/newspaper/page/24102854 | 24102854 | |
| 5557 | 5557 | 1900-06-27 | 2 | c-d | A letter from spendthrift to miser. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102854 | 24102854 | |
| 5558 | 5558 | 1900-06-27 | 2 | d | Explorations and discoveries by Westerners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102854 | 24102854 | |
| 5559 | 5559 | 1900-06-27 | 2 | d | Xu Yingkui, Governor of Fujian province, did not celebrate his birthday this year, but his mother's instead. | China | http://trove.nla.gov.au/newspaper/page/24102854 | 24102854 | |
| 5560 | 5560 | 1900-06-27 | 2 | e | Chinese merchants in Singapore consider raising money in China to buy life insurance for the Emperor in a foreign insurance company. | Singapore | http://trove.nla.gov.au/newspaper/page/24102854 | 24102854 | |
| 5561 | 5561 | 1900-06-27 | 2 | e | Bandits in Xijiang River, Guangdong, such as Ou Xin and Flu Zankai, have their own name cards. | China | http://trove.nla.gov.au/newspaper/page/24102854 | 24102854 | |
| 5562 | 5562 | 1900-06-27 | 2 | e | Liu Xuexun, an assistant to Li Hongzhang and big gambler, was nearly killed by others. | China | http://trove.nla.gov.au/newspaper/page/24102854 | 24102854 | |
| 5563 | 5563 | 1900-06-27 | 2 | e | Two leaders of local residents in the Philippines have escaped. | Other... | http://trove.nla.gov.au/newspaper/page/24102854 | 24102854 | |
| 5564 | 5564 | 1900-06-27 | 2 | e | Two Japanese educators plan to build a girls school in Sousa or Hangzhou. | China | http://trove.nla.gov.au/newspaper/page/24102854 | 24102854 | |
| 5565 | 5565 | 1900-06-27 | 3 | a | The amount of China's national debt. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102853 | 24102853 | |
| 5566 | 5566 | 1900-06-27 | 3 | a | The war between Britain and Transvaal in South Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24102853 | 24102853 | |
| 5567 | 5567 | 1900-06-27 | 3 | a | Famine and epidemics in India. | Australia | http://trove.nla.gov.au/newspaper/page/24102853 | 24102853 | |
| 5568 | 5568 | 1900-06-27 | 3 | b | A businessman in Melbourne was penalised for tax evasion. | Australia | http://trove.nla.gov.au/newspaper/page/24102853 | 24102853 | |
| 5569 | 5569 | 1900-06-27 | 3 | b | Clashes between Chinese and foreign troops in Tianjin; Li Hongzhang's opinion on the fortifications in Dagukou; Britain and France send troops to China. | China | http://trove.nla.gov.au/newspaper/page/24102853 | 24102853 | |
| 5570 | 5570 | 1900-06-27 | 3 | b | Russia has secured a port from Korea. | Japan | http://trove.nla.gov.au/newspaper/page/24102853 | 24102853 |
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]);