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 |
---|---|---|---|---|---|---|---|---|---|
50692 | 50692 | 1931-09-12 | 2 | b | Second and final part of editorial on the negotiation between China and Japan over the atrocity of Japanese police in Jilin province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090519 | 24090519 | |
50693 | 50693 | 1931-09-12 | 2 | d | The anti-Chinese movement in Mexico and the tragedy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090519 | 24090519 | |
50699 | 50699 | 1931-09-12 | 5 | d | Story of Scholar He. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090520 | 24090520 | |
50700 | 50700 | 1931-09-12 | 5 | e | Notices issued by the Chinese Consulate-General in Australia | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090520 | 24090520 | |
50710 | 50710 | 1931-09-12 | 8 | c | Australia news/ Chinese Consul-General in Australia Gui Zhi talks to his French counterpart on the execution of Chinese in French colony. Chinese opium addicts arrested in Sydney. Police arrest the Communist members in Sydney. A bank in Brisbane is suddenly closed down. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090525 | 24090525 | |
50711 | 50711 | 1931-09-12 | 8 | d | 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/24090525 | 24090525 |
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]);