This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53013 | 53013 | 1933-06-24 | 6 | a | Japan boycotts Indian cotton. | Japan | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 | |
53014 | 53014 | 1933-06-24 | 6 | a | An international conference on economic development in London. | Britain | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 | |
53015 | 53015 | 1933-06-24 | 6 | a | Election in Mexico and the chaos. | Other... | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 | |
53016 | 53016 | 1933-06-24 | 6 | b | League of Nations refuses to recognise the Manchurian state government. | Britain | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 | |
53017 | 53017 | 1933-06-24 | 6 | b | Bandits in Shenyang demand ransom from French man. | China | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 | |
53018 | 53018 | 1933-06-24 | 6 | c | Japanese withdraw their troops from north China. | China | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 | |
53019 | 53019 | 1933-06-24 | 6 | c | Dispute between Britain and Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 | |
53020 | 53020 | 1933-06-24 | 6 | d | Australia news/ Japanese fishermen murdered in Darwin. Police in Sydney raid shops. Cabinet factory in Perth on fire. Japanese steal marine products in north Australian water territories. Australian and New Zealand to have a joint exercise. Heavy fog in Sydney harbour. Chinese man robbed in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 | |
53021 | 53021 | 1933-06-24 | 6 | f | A census notice issued by the Commonwealth government of Australia on 30 June 1933. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 | |
53022 | 53022 | 1933-06-24 | 6 | a | Advertisement of the Bank of New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 |
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]);