This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50141 | 50141 | 1931-03-28 | 8 | b | Police in Tokyo have a clash with civilians. | Japan | http://trove.nla.gov.au/newspaper/page/24090331 | 24090331 | |
50142 | 50142 | 1931-03-28 | 8 | b | Two American female missionaries are murdered in China. | China | http://trove.nla.gov.au/newspaper/page/24090331 | 24090331 | |
50143 | 50143 | 1931-03-28 | 8 | b | America has more storage of gold than any other countries. | America | http://trove.nla.gov.au/newspaper/page/24090331 | 24090331 | |
50144 | 50144 | 1931-03-28 | 8 | b | Japanese people dislike their prime minister. | Japan | http://trove.nla.gov.au/newspaper/page/24090331 | 24090331 | |
50145 | 50145 | 1931-03-28 | 8 | b | British ships lay down the biggest ever torpedo. | Britain | http://trove.nla.gov.au/newspaper/page/24090331 | 24090331 | |
50146 | 50146 | 1931-03-28 | 8 | b | French navy to build new warship. | France | http://trove.nla.gov.au/newspaper/page/24090331 | 24090331 | |
50147 | 50147 | 1931-03-28 | 8 | b | French authority imposes heavy tariff on Australian products. | Britain | http://trove.nla.gov.au/newspaper/page/24090331 | 24090331 | |
50148 | 50148 | 1931-03-28 | 8 | c | American government in deficit. | America | http://trove.nla.gov.au/newspaper/page/24090331 | 24090331 | |
50149 | 50149 | 1931-03-28 | 8 | c | Three political convicts executed in India. | Other... | http://trove.nla.gov.au/newspaper/page/24090331 | 24090331 | |
50150 | 50150 | 1931-03-28 | 8 | c | An American woman and her donations to the missionary work in China. | America | http://trove.nla.gov.au/newspaper/page/24090331 | 24090331 | |
50151 | 50151 | 1931-03-28 | 8 | c | Australia news/ Unemployed people are punished in Sydney for overclaiming grain supplies. A man in Sydney commit suicide. A passenger plane disappears on its way from Sydney to Melbourne. Federal government in heavy debts. Chinese sailor runs away in Sydney. Labour government of NSW proposes to abandon the senate and to replace the state governor. Parcels lost in a train. Food cheque stolen in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090331 | 24090331 |
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]);