This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33150 | 33150 | 1918-03-30 | 7 | b-c | Australia news/ Hundreds of wives of the Australian servicemen are returning. Chinese man in Sydney Huang Guanjie, son of Tiy Sing fruit shop boss Huang Zaixing, is awarded doctor's degree at the University of Sydney. Chinese boy in Sydney Zhan Zhaoying, son of Zhan Fu, is awarded for his excellent school performance. Tobacco prices are going up. Sydney police raid opium growing in the mountain valley. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097235 | 24097235 | |
33151 | 33151 | 1918-03-30 | 7 | c | Fire and flood in north island of New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24097235 | 24097235 | |
33152 | 33152 | 1918-03-30 | 7 | c | Duan Qirui becomes Chinese premier once again. China and Japan to jointly interfere with the Siberian affairs and their plan. | Britain | http://trove.nla.gov.au/newspaper/page/24097235 | 24097235 | |
33153 | 33153 | 1918-03-30 | 7 | c-d | Miscellaneous report on Chinese politics. | China | http://trove.nla.gov.au/newspaper/page/24097235 | 24097235 | |
33154 | 33154 | 1918-03-30 | 7 | e | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097235 | 24097235 |
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]);