This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48147 | 48147 | 1929-06-01 | 2 | b | The key of politics relies on the administration of people, comments written by Wang Zhixian. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099232 | 24099232 | |
48148 | 48148 | 1929-06-01 | 2 | b | A major earthquake may happen soon. | Britain | http://trove.nla.gov.au/newspaper/page/24099232 | 24099232 | |
48157 | 48157 | 1929-06-01 | 3 | b | Coal mines in Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24099231 | 24099231 | |
48173 | 48173 | 1929-06-01 | 8 | b | Turkish parliament imposes new restrictions on foreign immigrants. | Britain | http://trove.nla.gov.au/newspaper/page/24099238 | 24099238 | |
48174 | 48174 | 1929-06-01 | 8 | b | Australia news/ Second part of the report on the fighting of the Chinese Chamber of Commerce for peanut import and their letter to the government authorities signed by Chairman Zhu Songqing. Customer is detained in a Sydney restaurant for using counterfeit bank notes. New Chinese Consul-General in Australia Song Faxiang assumes office. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099238 | 24099238 |
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]);