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 |
---|---|---|---|---|---|---|---|---|---|
46886 | 46886 | 1928-03-31 | 2 | b | Tung Wah Times comments on the orders issued by Guangdong government to disband all trade unions. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098744 | 24098744 | |
46892 | 46892 | 1928-03-31 | 3 | b | The new Japanese cabinet and their China policy. | China | http://trove.nla.gov.au/newspaper/page/24098743 | 24098743 | |
46893 | 46893 | 1928-03-31 | 3 | b | The enthroning ceremony for the emperor of Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24098743 | 24098743 | |
46898 | 46898 | 1928-03-31 | 5 | b | First part of a survey on the handmade paper industry in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098745 | 24098745 | |
46904 | 46904 | 1928-03-31 | 7 | b | Australia news/ A young woman is raped in Darlinghurst, Sydney. Chinese school boy in Sydney dies in an accident. Chinese are penalised for opium smoking. White men are penalised for gambling. White women in Melbourne are detained for dating black boys from America. Young woman in detained in Sydney for shoplift. Ouyang Nan, businessman in Sydney and member of the Nationalist Party branch, sues Liang Yunzhou because their have different attitude towards the Nanjing and Wuhan governments. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098747 | 24098747 |
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]);