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 |
---|---|---|---|---|---|---|---|---|---|
29161 | 29161 | 1914-08-15 | 3 | a | Orders issued by Chinese President Yuan Shikai to remove Wang Zhixin for corruption. | China | http://trove.nla.gov.au/newspaper/page/24093211 | 24093211 | |
29162 | 29162 | 1914-08-15 | 3 | a | Tibetan representatives put forward their requests in the negotiation with Chen Yifan, representative of the Chinese government. | China | http://trove.nla.gov.au/newspaper/page/24093211 | 24093211 | |
29165 | 29165 | 1914-08-15 | 6 | a | A notice issued by the Chinese Chamber of Commerce on the award of Patriotic Medals to the Chinese citizens in Australia for their contribution towards the Citizenship Levy (guo min juan). Names of all medalists throughout Australia are listed (societies and individuals). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093216 | 24093216 | |
29166 | 29166 | 1914-08-15 | 7 | a | Australia news/ Fewer merchant ships are arriving in Australia due to the war in Europe. Many young Australians are recruited. Australian federal government commandeer ships in Sydney. Passenger liner St Albans of Gibbs Bright & Co, is stuck in Townsville, Queensland, on its way from Sydney to Hong Kong. German warships in Samoa island. | Australia | http://trove.nla.gov.au/newspaper/page/24093215 | 24093215 |
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]);