This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
10294 | 10294 | 1902-04-12 | 2 | e | Xu Qi pretended to be an obedient man when foreign troops entered Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100388 | 24100388 | |
10295 | 10295 | 1902-04-12 | 2 | e | Everybody in Beijing talks reform but reforms are actually never implemented. | China | http://trove.nla.gov.au/newspaper/page/24100388 | 24100388 | |
10296 | 10296 | 1902-04-12 | 2 | e | Yuan Shikai's suggestions on how to improve army training. | China | http://trove.nla.gov.au/newspaper/page/24100388 | 24100388 | |
10297 | 10297 | 1902-04-12 | 2 | e | A further report on Rong Lu's newspaper, Jiu Bao, in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24100388 | 24100388 | |
10298 | 10298 | 1902-04-12 | 2 | e | Lu Qingliu, a student of Beiyang University in Tianjin, applied to study in Japan at his own expense and has been approved. | China | http://trove.nla.gov.au/newspaper/page/24100388 | 24100388 | |
10299 | 10299 | 1902-04-12 | 2 | e | Lantern riddles from Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24100388 | 24100388 | |
10316 | 10316 | 1902-04-12 | 3 | e | The lawsuit between Li Bu and the Tung Wah News has not been settled. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100387 | 24100387 | |
10317 | 10317 | 1902-04-12 | 3 | e | Chinese consul general in Singapore, Luo Zongyao, came to visit Australia. He toured Brisbane, Sydney, Tung Wah News office, and is now on the way to Melbourne on invitation of Prime Minister Edmund Barton. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100387 | 24100387 |
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]);