This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31518 | 31518 | 1916-08-26 | 3 | b-c | Chinese President Li Yuanhong talks to Japanese journalists. | China | |||
31528 | 31528 | 1916-08-26 | 7 | b-c | Japan dispatches more troops to Korea. Japan appoints new ambassador to China. Orders issued by the Chinese Central government to local provinces. Number of foreigners in China and their business firms. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095384 | 24095384 |
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]);