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 |
|---|---|---|---|---|---|---|---|---|---|
| 11088 | 11088 | 1902-10-18 | 2 | a-b | Second part of the report on the clashes between Chinese students in Japan and Cai Jun, Chinese ambassador to Tokyo. | Japan | http://trove.nla.gov.au/newspaper/page/24100516 | 24100516 | |
| 11089 | 11089 | 1902-10-18 | 2 | b | Tap water to be installed in the Summer Palace; Li Lianying's brother; Tianjin to be returned to China; Yuan Shikai arrived Tianjin for talks with foreign missions. | China | http://trove.nla.gov.au/newspaper/page/24100516 | 24100516 | |
| 11090 | 11090 | 1902-10-18 | 2 | c | Song Bolu has been captured. | China | http://trove.nla.gov.au/newspaper/page/24100516 | 24100516 | |
| 11091 | 11091 | 1902-10-18 | 2 | c | Two criminals in Chengdu, Sichuan province, were executed by boy soldiers. | China | http://trove.nla.gov.au/newspaper/page/24100516 | 24100516 | |
| 11092 | 11092 | 1902-10-18 | 2 | c | The life of Zai Lan after his retirement. | China | http://trove.nla.gov.au/newspaper/page/24100516 | 24100516 | |
| 11093 | 11093 | 1902-10-18 | 2 | c | Manchuria's response to sending students overseas; students in Hubei province protest against the new policy. | China | http://trove.nla.gov.au/newspaper/page/24100516 | 24100516 | |
| 11094 | 11094 | 1902-10-18 | 2 | c | Catholics in Henan province, China, and their influence. | China | http://trove.nla.gov.au/newspaper/page/24100516 | 24100516 | |
| 11095 | 11095 | 1902-10-18 | 3 | a | The comments of Russian ambassador to Beijing. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100515 | 24100515 | |
| 11096 | 11096 | 1902-10-18 | 3 | a | Coal miners on strike in the United States; Yokohama manufactures new gunboats; China's new policy for sending students to study overseas; Liu Kunyi has died; Zhang Zhidong takes over Liu Kunyi's power; British ambassador to Beijing is going on holiday; Britain and Germany to withdraw their troops from Shanghai; Russia returns south Manchuria to China. | Other... | http://trove.nla.gov.au/newspaper/page/24100515 | 24100515 | |
| 11097 | 11097 | 1902-10-18 | 3 | a | Australia is to cancel its free train service provided to servicemen, government officials and railway workers. | Australia | http://trove.nla.gov.au/newspaper/page/24100515 | 24100515 | |
| 11098 | 11098 | 1902-10-18 | 3 | b | Capital punishment. A Dandenong woman who murdered her husband is to be hanged. | Australia | http://trove.nla.gov.au/newspaper/page/24100515 | 24100515 | |
| 11099 | 11099 | 1902-10-18 | 3 | b | A further report on the trial of the man who murdered Mei Guangda. | Australia | http://trove.nla.gov.au/newspaper/page/24100515 | 24100515 | |
| 11100 | 11100 | 1902-10-18 | 3 | b | Weather changes in New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24100515 | 24100515 | |
| 11101 | 11101 | 1902-10-18 | 3 | c | Chinese community in Melbourne receives telegram from Guangdong asking for donations to the flooding area. | Australia | http://trove.nla.gov.au/newspaper/page/24100515 | 24100515 | |
| 11102 | 11102 | 1902-10-18 | 3 | c | A pub in Sydney was burglarised. | Australia | http://trove.nla.gov.au/newspaper/page/24100515 | 24100515 | |
| 11103 | 11103 | 1902-10-18 | 3 | c | Strike in America and Switzerland. | Australia | http://trove.nla.gov.au/newspaper/page/24100515 | 24100515 | |
| 11104 | 11104 | 1902-10-18 | 3 | c | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100515 | 24100515 |
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]);