This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32400 | 32400 | 1917-06-23 | 3 | a-b | Tang Hualong supports the war with Germany and his public speech. | China | http://trove.nla.gov.au/newspaper/page/24095736 | 24095736 | |
32406 | 32406 | 1917-06-23 | 6 | a-b | Beijing news/ Members of the parliament meet Premier Duan Qirui. Earthquake in the south of Tianjin. The process of China's involvement in the World War. Chen Jintao and his destiny. Debate on the status of Confucianism. Chinese President Li Yuanhong entertains foreign missions in Beijing. Secret societies in China. | China | http://trove.nla.gov.au/newspaper/page/24095741 | 24095741 |
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]);