This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50702 | 50702 | 1931-09-12 | 8 | b | Japanese ship transport rice to the flooding area in north China. | Japan | http://trove.nla.gov.au/newspaper/page/24090525 | 24090525 | |
50703 | 50703 | 1931-09-12 | 8 | b | Water retreat a bit in the Yangtze River. | China | http://trove.nla.gov.au/newspaper/page/24090525 | 24090525 | |
50704 | 50704 | 1931-09-12 | 8 | b | A plan book of the Soviet Union for communist propaganda in China. | China | http://trove.nla.gov.au/newspaper/page/24090525 | 24090525 | |
50705 | 50705 | 1931-09-12 | 8 | b | Mexico deports Chinese. | Canada | http://trove.nla.gov.au/newspaper/page/24090525 | 24090525 | |
50706 | 50706 | 1931-09-12 | 8 | b | The Chinese Nationalist government purchases wheat from America for disasters relief. | America | http://trove.nla.gov.au/newspaper/page/24090525 | 24090525 | |
50707 | 50707 | 1931-09-12 | 8 | c | An official report on the flooding disasters in China. | China | http://trove.nla.gov.au/newspaper/page/24090525 | 24090525 | |
50708 | 50708 | 1931-09-12 | 8 | c | Mutiny of the Chile navy. | Other... | http://trove.nla.gov.au/newspaper/page/24090525 | 24090525 | |
50709 | 50709 | 1931-09-12 | 8 | c | Alarm of floods of the north part of the Grand Canal in China. | China | http://trove.nla.gov.au/newspaper/page/24090525 | 24090525 | |
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]);