This data as json, CSV (advanced)
Suggested facets: page, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
6618 | 6618 | 1900-12-12 | 2 | d-e | The Emperor orders the punishment of Gang Yi and other officials. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24103045 | 24103045 | |
8494 | 8494 | 1901-09-04 | 2 | d-e | Report on the arrival of Prince Chun in Germany. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100156 | 24100156 | |
10622 | 10622 | 1902-05-17 | 2 | d-e | A copy of the official note presented by American government to Russia and China. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100428 | 24100428 | |
35574 | 35574 | 1920-04-10 | 2 | d-e | First part of the speech delivered in Hong Kong by Wang Zhengting, Chinese delegate to the Paris Peace Conference. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098117 | 24098117 | |
36448 | 36448 | 1921-01-01 | 2 | d-e | Three chief commanders in Guangdong (Sun Yatsen, Tang Shaoyi and Wu Tingfang) comment on the current situations in that province, and expedition to Guangxi. Proposal to include agriculture, trade and education departments in the new military government. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24093378 | 24093378 | |
37763 | 37763 | 1921-10-29 | 2 | d-e | Macao authority issues ultimatum on their military conflict with Chinese troops. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24093735 | 24093735 | |
41336 | 41336 | 1924-03-29 | 3 | d-e | China and Russia blame each other for the failure of treaty negotiation. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100663 | 24100663 | |
41841 | 41841 | 1924-07-19 | 6 | d-e | Chinese typewriter invented in Shanghai. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100797 | 24100797 |
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]);