This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54296 | 54296 | 1934-07-07 | 6 | a | The nonaggression agreement between Japan and America. | Britain | http://trove.nla.gov.au/newspaper/page/24096080 | 24096080 | |
54297 | 54297 | 1934-07-07 | 6 | a | Japanese financial minister prepares new budget. | Japan | http://trove.nla.gov.au/newspaper/page/24096080 | 24096080 | |
54298 | 54298 | 1934-07-07 | 6 | a | America on the possible alliance of Japan and Britain. | America | http://trove.nla.gov.au/newspaper/page/24096080 | 24096080 | |
54299 | 54299 | 1934-07-07 | 6 | b | Gu Weijun in Europe. | Other... | http://trove.nla.gov.au/newspaper/page/24096080 | 24096080 | |
54300 | 54300 | 1934-07-07 | 6 | b | Battle on the border of Yunnan province of China and Burma. | Other... | http://trove.nla.gov.au/newspaper/page/24096080 | 24096080 | |
54301 | 54301 | 1934-07-07 | 6 | c | Floods in India. | Other... | http://trove.nla.gov.au/newspaper/page/24096080 | 24096080 | |
54302 | 54302 | 1934-07-07 | 6 | c | Two Japanese warship collide. | Japan | http://trove.nla.gov.au/newspaper/page/24096080 | 24096080 | |
54303 | 54303 | 1934-07-07 | 6 | d | Australia news/ Notice to gardeners in Sydney who have a booth in the market. A robbery in Sydney. Japanese continue to purchase wool from Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096080 | 24096080 |
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]);