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 |
---|---|---|---|---|---|---|---|---|---|
10811 | 10811 | 1902-06-11 | 2 | d | Hu Yunmei's suggestions on police organisation have been accepted; rumours in Beijing on the imperial return; Yuan Shikai keen to reform; Wang Wenshao was impeached. | China | http://trove.nla.gov.au/newspaper/page/24100453 | 24100453 | |
10812 | 10812 | 1902-06-11 | 2 | d | Empress Dowager tries to get some experts. | China | http://trove.nla.gov.au/newspaper/page/24100453 | 24100453 | |
10813 | 10813 | 1902-06-11 | 2 | d | Rong Lu is recovering from illness. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100453 | 24100453 | |
10814 | 10814 | 1902-06-11 | 2 | d | Empress Dowager and Emperor Guangxu comment on the alliance between Russia and France. | China | http://trove.nla.gov.au/newspaper/page/24100453 | 24100453 | |
10815 | 10815 | 1902-06-11 | 2 | d | Huang Zengyuan comments on the political operations in China. | China | http://trove.nla.gov.au/newspaper/page/24100453 | 24100453 | |
10816 | 10816 | 1902-06-11 | 2 | d | Yuan Shikai comments on Cai Jun's letter to the Department of Foreign Affairs. | China | http://trove.nla.gov.au/newspaper/page/24100453 | 24100453 | |
10834 | 10834 | 1902-06-11 | 3 | d | Statistics of Chinese population in New South Wales, ratio of men and women, number born in Australia, other population details.. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100452 | 24100452 | |
10835 | 10835 | 1902-06-11 | 3 | d | Britain and Transvaal talk in an attempt to end the war in South Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24100452 | 24100452 |
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]);