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 |
---|---|---|---|---|---|---|---|---|---|
50533 | 50533 | 1931-07-25 | 2 | b | The Nationalist Party branch in Shanghai oppose to the establishment of an office for opium ban, and comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090461 | 24090461 | |
50543 | 50543 | 1931-07-25 | 5 | b | Zhan Tianyou and the bronze statue of Chinese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090462 | 24090462 | |
50544 | 50544 | 1931-07-25 | 5 | d | Dongguan county authority in Guangdong has new method to examine all prostitutes. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090462 | 24090462 | |
50545 | 50545 | 1931-07-25 | 5 | e | Japanese women and the waitress. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090462 | 24090462 | |
50546 | 50546 | 1931-07-25 | 5 | e | Comments on the international trade and reciprocities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090462 | 24090462 | |
50557 | 50557 | 1931-07-25 | 8 | c | Australia news/ Member of Federal House of Representatives criticises the use of public car for private purpose. Sales of lottery to be postponed. Young Chinese man is sentenced for car accident. Party on board of the passenger liner Changte and speakers include Pang Zijun, Chinese Consul-General Gui Zhi, Zhu Songqing, Ouyang Nan, Huang Zhu, Liu Guangfu and others. NSW state government needs money for daily administration. Two Chinese men are detained in Sydney for gambling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090467 | 24090467 | |
50558 | 50558 | 1931-07-25 | 8 | e | Notice issued by the Chinese Consulate-General in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090467 | 24090467 |
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]);