This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54560 | 54560 | 1934-09-29 | 6 | a | Russia has joined the League of Nations. | Other... | http://trove.nla.gov.au/newspaper/page/24096178 | 24096178 | |
54561 | 54561 | 1934-09-29 | 6 | a | Manchurian state government seeks recognition of Australian government. | China | http://trove.nla.gov.au/newspaper/page/24096178 | 24096178 | |
54562 | 54562 | 1934-09-29 | 6 | a | Earthquake in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24096178 | 24096178 | |
54563 | 54563 | 1934-09-29 | 6 | b | Chinese pirates in the South China Sea. | China | http://trove.nla.gov.au/newspaper/page/24096178 | 24096178 | |
54564 | 54564 | 1934-09-29 | 6 | c | Chaos in Turkmenistan of Soviet Union. | Britain | http://trove.nla.gov.au/newspaper/page/24096178 | 24096178 | |
54565 | 54565 | 1934-09-29 | 6 | c | Typhoon in Japan and the tragedy. | Japan | http://trove.nla.gov.au/newspaper/page/24096178 | 24096178 | |
54566 | 54566 | 1934-09-29 | 6 | e | China may quit the League of Nations. | Britain | http://trove.nla.gov.au/newspaper/page/24096178 | 24096178 | |
54567 | 54567 | 1934-09-29 | 6 | e | Australia news/ Chinese garden is forced to move. Chinese man detained in Sydney for wig smuggling. How much tax the Australian people pay. Chinese swimmer Guo Zhongheng comes to visit Melbourne. Japanese purchases Australian milk and butter. Australia federal government to sign trade agreements with some countries. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096178 | 24096178 |
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]);