This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52670 | 52670 | 1933-03-18 | 6 | a | Soviet Russia remains neutral over the Manchurian issues. | Russia | http://trove.nla.gov.au/newspaper/page/24091160 | 24091160 | |
52671 | 52671 | 1933-03-18 | 6 | a | Japanese seek to occupy New Guinea. | Britain | http://trove.nla.gov.au/newspaper/page/24091160 | 24091160 | |
52672 | 52672 | 1933-03-18 | 6 | a | Epidemic disease in Mumbai. | Other... | http://trove.nla.gov.au/newspaper/page/24091160 | 24091160 | |
52673 | 52673 | 1933-03-18 | 6 | a | Japan and Holland fail to reach agreement in their treaty talks. | Britain | http://trove.nla.gov.au/newspaper/page/24091160 | 24091160 | |
52674 | 52674 | 1933-03-18 | 6 | b | Jiang Jieshi and Zhang Xueliang to meet in Baoding, Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24091160 | 24091160 | |
52675 | 52675 | 1933-03-18 | 6 | b | American President Roosevelt helps to save banks from bankruptcy. | America | http://trove.nla.gov.au/newspaper/page/24091160 | 24091160 | |
52676 | 52676 | 1933-03-18 | 6 | c | Secretary of British embassy in Tokyo is arrested. | Japan | http://trove.nla.gov.au/newspaper/page/24091160 | 24091160 | |
52677 | 52677 | 1933-03-18 | 6 | c | Earthquake in America. | America | http://trove.nla.gov.au/newspaper/page/24091160 | 24091160 | |
52678 | 52678 | 1933-03-18 | 6 | d | The war between China and Japan. | China | http://trove.nla.gov.au/newspaper/page/24091160 | 24091160 | |
52679 | 52679 | 1933-03-18 | 6 | e | Australia news/ Federal government to reform the tax system. German warships come to visit Australia. The Chinese Society (zhong hua gong hui) sends telegram to the Chinese army in the Rehe front. Chinese man in Sydney arrested for smuggled opium. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091160 | 24091160 |
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]);