This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56087 | 56087 | 1936-07-18 | 8 | a | More Japanese troops in north China. | Britain | http://trove.nla.gov.au/newspaper/page/24096928 | 24096928 | |
56088 | 56088 | 1936-07-18 | 8 | a | Japanese in Changchun, Jilin province, arrest Indian businessman and the negotiation between Britain and Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24096928 | 24096928 | |
56089 | 56089 | 1936-07-18 | 8 | b | The military power of China. | China | http://trove.nla.gov.au/newspaper/page/24096928 | 24096928 | |
56090 | 56090 | 1936-07-18 | 8 | d | Chen Jitang surrender himself to the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24096928 | 24096928 | |
56091 | 56091 | 1936-07-18 | 8 | d | Treaty of alliance signed by Italy and Germany. | Britain | http://trove.nla.gov.au/newspaper/page/24096928 | 24096928 | |
56092 | 56092 | 1936-07-18 | 8 | e | Australia news/ Chinese Youth Club in Sydney organises a dancing party to raise funds for the flooding victims in China. Japanese businessman is murdered in Shanghai. Trade between Australia and Japan. Sydney to rebuild some streets. Chinese market garden is robbed near Sydney. Australian government purchases more war planes. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096928 | 24096928 |
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]);