This data as json, CSV (advanced)
Suggested facets: page, column, 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 | |
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 | |
46899 | 46899 | 1928-03-31 | 5 | d | Revenge against a playboy. | 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 | |
46905 | 46905 | 1928-03-31 | 7 | e | A notice by the Wing On Textile Company in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098747 | 24098747 | |
46906 | 46906 | 1928-03-31 | 7 | e | A notice by the Chinese Presbyterian Church in Sydney. | 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]);