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 |
---|---|---|---|---|---|---|---|---|---|
50712 | 50712 | 1931-09-19 | 2 | b | First part of editorial on China's negotiations with Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090527 | 24090527 | |
50717 | 50717 | 1931-09-19 | 3 | b | Jiang Jieshi and Zhang Xueliang discuss solutions to the current crisis. Atrocities of Japanese in Qingdao. More than 40 counties are flooded in Henan province. Missiles manufactured in the munitions factory in Liaoning. Ambition of the Soviet Union for communist propaganda in China. The Grand Canal in Jiangsu province and the floods. | China | http://trove.nla.gov.au/newspaper/page/24090526 | 24090526 | |
50722 | 50722 | 1931-09-19 | 8 | b | Australia to build a wool factory in China. | Britain | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
50723 | 50723 | 1931-09-19 | 8 | b | The Hong Kong - Shanghai Banking Corporation finds counterfeit bank notes. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
50724 | 50724 | 1931-09-19 | 8 | b | Russia exports petrol to China. | China | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
50725 | 50725 | 1931-09-19 | 8 | b | Train bombed in Hungary. | Britain | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
50726 | 50726 | 1931-09-19 | 8 | b | Guangdong troops occupy Hengyang in Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
50727 | 50727 | 1931-09-19 | 8 | b | Gandhi arrives London and his speech. | Britain | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 |
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]);