This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54141 | 54141 | 1934-05-12 | 6 | a | Chinese consul-general in Paris talks about Japanese invasion. | France | http://trove.nla.gov.au/newspaper/page/24096014 | 24096014 | |
54142 | 54142 | 1934-05-12 | 6 | a | Lottery in China. | China | http://trove.nla.gov.au/newspaper/page/24096014 | 24096014 | |
54143 | 54143 | 1934-05-12 | 6 | b | Council of legislature in Nanjing meets to discuss Japan policy. | China | http://trove.nla.gov.au/newspaper/page/24096014 | 24096014 | |
54144 | 54144 | 1934-05-12 | 6 | c | Japanese cabinet on their Far East policy. | Japan | http://trove.nla.gov.au/newspaper/page/24096014 | 24096014 | |
54145 | 54145 | 1934-05-12 | 6 | c | Puppet Manchurian state seeks alliance with Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24096014 | 24096014 | |
54146 | 54146 | 1934-05-12 | 6 | d | The air forces of Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24096014 | 24096014 | |
54147 | 54147 | 1934-05-12 | 6 | e | Australia news/ Trade statistics between China and Australia in the past six years. Bandits fail to rob treasury of the Sydney city council. Visitor talks about modern China on his return. Chinese government entertains Australian trade commissioner. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096014 | 24096014 |
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]);