This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50084 | 50084 | 1931-03-14 | 3 | a | The Nanjing government compensates Japanese for their loss during the war in southeastern China. | China | http://trove.nla.gov.au/newspaper/page/24090307 | 24090307 | |
50085 | 50085 | 1931-03-14 | 3 | a | Zhang Xueliang takes over the munitions factory in Shanxi former controlled by Yan Xishan. | China | http://trove.nla.gov.au/newspaper/page/24090307 | 24090307 | |
50090 | 50090 | 1931-03-14 | 5 | a | Hong Kong news/ Gold price in Hong Kong. Textile industry in Hong Kong. Bandits and their kidnap in Hong Kong. Contract to be revised for the railway from Guangzhou to Kowloon. Sugar industry in the upsurge of gold prices. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090309 | 24090309 |
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]);