This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28713 | 28713 | 1914-04-18 | 2 | b-c | Orders issued by Chinese President Yuan Shikai on abolition of provincial legislature assembly and others. | China | http://trove.nla.gov.au/newspaper/page/24093078 | 24093078 | |
28723 | 28723 | 1914-04-18 | 3 | b-c | German spy in London and their activities. | Britain | http://trove.nla.gov.au/newspaper/page/24093077 | 24093077 | |
28726 | 28726 | 1914-04-18 | 3 | b-c | Beijing news/ Discussions in China on the reform of local administrative system. President Yuan Shikai and the revolutionary rebels. China to borrow loans from France for railway construction. Xu Donghai and the reform of cabinet system in China. Jiangxi provincial authority asks for financial assistance. | China | http://trove.nla.gov.au/newspaper/page/24093077 | 24093077 | |
28729 | 28729 | 1914-04-18 | 6 | b-c | News on the death of Zhao Bingjun, former governor of Zhili province. | China | http://trove.nla.gov.au/newspaper/page/24093082 | 24093082 | |
28731 | 28731 | 1914-04-18 | 7 | b-c | Australia news/ Passengers of the St Albans comment on the service on aboard. A girl is brought to trial in Sydney for shooting her former boyfriend. Fire alarm in the agricultural show in Sydney. Sydney woman is penalised for opium smuggling. New South Wales state government to collect stamp duty. Report on the Royal Exhibition Show in Sydney. Smallpox is back to Sydney. An Australian-born Chinese boy, a brother of the Sydney An Yee Lee shop owner Li Yuanxin, is kidnapped in Guangzhou and has now been rescued, while Australian Governor-General also writes to British consul in Guangzhou for help. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093081 | 24093081 |
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]);