This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29208 | 29208 | 1914-09-05 | 2 | a-b | Editorial on the difference between the centralisation of state authority and autocratic monarchy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093236 | 24093236 | |
29216 | 29216 | 1914-09-05 | 6 | a-b | Miscellaneous report on the Chinese politics and officialdom. | China | http://trove.nla.gov.au/newspaper/page/24093240 | 24093240 | |
29219 | 29219 | 1914-09-05 | 7 | a-b | Australia news/ Chinese communities in Cairns, Queensland, and New Zealand donate to the flood victims in Guangdong. Australian and New Zealand naval fleets join together and their whereabouts. New Zealand troops occupy Samoa island. More Chinese are returning from Noumea, of New Caledonia. Business remains normal in the Sydney banks. Insurance charges increase due to the war. Natives of Songlong town, Gaoyao county, in Sydney actively donate to the flood victims in their hometown. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093239 | 24093239 | |
29223 | 29223 | 1914-09-05 | 8 | a-b | Beijing news/ Chinese government in Beijing to build headquarters of supreme commander. Wu Tingfang to be the foreign minister. Scholar comments on the provisional constitution. China and Britain to revise their opium trade treaty. Plan for repayment of the indemnity to foreign countries in 1915. Russia to annex Mongolia. Chinese government is considering to appoint honorary consul among overseas Chinese communities. | China | http://trove.nla.gov.au/newspaper/page/24093242 | 24093242 |
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]);