This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50560 | 50560 | 1931-08-01 | 2 | c | Commercial chamber in Shanghai refuses to introduce Australian flour into China market because of the existing immigration restrictions on Chinese. | China | http://trove.nla.gov.au/newspaper/page/24090469 | 24090469 | |
50561 | 50561 | 1931-08-01 | 2 | c | Influence in Jinan following the Japanese invasion. Wang Zhengting on the negotiations with Japan. More Japanese morphine and heroine are smuggled into China. Sichuan troops arrive Yichang, Hubei province. Financial crisis in Manchuria. Panchen Lama accepts the title conferred by the Central Government. Railway talks between China and Russia. Revenue declines for two railways in China. Chen Guangzhong sets fire on forest. Cuba wants to build a sugar factory in China and the processing by the Nanjing government. Japanese police in Shenyang. Sichuan situations. Proposal to impeach Huang Boqun for his luxurious wedding. Expensive grave for the late Tan Yankai. Aerolite falls in the Taihang Mountain, Shanxi province. Zhang Xueliang is recovering. A petition group in Beijing goes on hunger strike. Japanese police in Changchun, Jilin province, shoot Chinese workers. China purchases war planes. Huge amount of tax income on opium. Floods in north China. | China | http://trove.nla.gov.au/newspaper/page/24090469 | 24090469 | |
50564 | 50564 | 1931-08-01 | 3 | c | Japanese speed up their immigration into China and a new survey. | China | http://trove.nla.gov.au/newspaper/page/24090468 | 24090468 | |
50578 | 50578 | 1931-08-01 | 8 | c | Indian students assassinate the governor-general. | Other... | http://trove.nla.gov.au/newspaper/page/24090475 | 24090475 | |
50579 | 50579 | 1931-08-01 | 8 | c | Accident of war plane in Poland. | Other... | http://trove.nla.gov.au/newspaper/page/24090475 | 24090475 | |
50580 | 50580 | 1931-08-01 | 8 | c | The longest road in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24090475 | 24090475 | |
50581 | 50581 | 1931-08-01 | 8 | c | Ms Johnson is flying from Britain to Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24090475 | 24090475 | |
50582 | 50582 | 1931-08-01 | 8 | c | President of Chile runs away. | Other... | http://trove.nla.gov.au/newspaper/page/24090475 | 24090475 | |
50583 | 50583 | 1931-08-01 | 8 | c | Australia news/ Policeman in injured by robbers. The Savings Bank of New South Wales is closed down once again. More Australian wheat are exported to China. Opium addicts are penalised in Sydney. Three Chinese men are robbed in Sydney. Shop owner is sentenced in Sydney for killing a thief. Issue of lottery postponed again. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090475 | 24090475 |
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]);