This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33668 | 33668 | 1918-09-28 | 3 | b-c | Sichuan province to borrow loans from Japan and the water rights to be mortgaged. | China | http://trove.nla.gov.au/newspaper/page/24097443 | 24097443 | |
33679 | 33679 | 1918-09-28 | 7 | b-c | Australia news/ New South Wales state authority advises the people to live a simple life. Budget report by the federal treasurer to the parliament. More taxes collected for tobacco and wines. Chinese businessman Zhou Yuwen dies in Sydney at the age of 51. Wu Elou farewells Zhou Ruiting (Fengzhen) from Bendigo and Wu Dehe from New Zealand on their return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097447 | 24097447 | |
33684 | 33684 | 1918-09-28 | 8 | b-c | Beijing news/ Hubei governor Wang Zhanyuan suggests to stop internal fighting for the outside threats. Cao Kun sends a telegram to the central government and the contents. Central authority in Beijing investigates the troops from the south. British ambassador in Beijing mentions once again the railway from Wenzhou to Hangzhou in Zhejiang province. Protest in Jilin province against the loans for forest and mining projects. | China | http://trove.nla.gov.au/newspaper/page/24097450 | 24097450 |
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]);