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 |
---|---|---|---|---|---|---|---|---|---|
50646 | 50646 | 1931-08-29 | 2 | b | Editorial by Tung Wah Times on the efforts to eliminate bandits in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090503 | 24090503 | |
50656 | 50656 | 1931-08-29 | 5 | b | An old man in Shandong province. A young rebellion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090504 | 24090504 | |
50657 | 50657 | 1931-08-29 | 5 | d | The ten characteristics of great men. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090504 | 24090504 | |
50658 | 50658 | 1931-08-29 | 5 | d | Notices issued by the Chinese Consulate in Melbourne and Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090504 | 24090504 | |
50667 | 50667 | 1931-08-29 | 8 | d | Australia news/ Chinese consul-general Gui Zhi talks with various parties on the murder case involved Chinese. The Overseas Chinese Famine Relief Committee in Shanghai calls for donations to the flooding victims in China. The Nationalists and the Hua An Hui (Chinese Society) in Darwin fight each other for the remains of the deceased countrymen. Six Chinese are beheaded in New Zealand. Another bank is closed down in Sydney. Proposal to stop import of tomato. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090509 | 24090509 | |
50668 | 50668 | 1931-08-29 | 8 | e | Chinese Chamber of Commerce in Sydney calls for donations to the flooding areas in China and names listed for all donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090509 | 24090509 |
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]);