This data as json, CSV (advanced)
Suggested facets: page, title, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21920 | 21920 | 1909-11-06 | 3 | c-d | French and their adventure in Yunnanprovince. | France | http://trove.nla.gov.au/newspaper/page/26802383 | 26802383 | |
25746 | 25746 | 1912-02-17 | 2 | c-d | Li Yuanhong's current activities | Li Yuanhong is elected as vice president of the Republic of China. Li's official building is to be expanded. Li orders to make new currency for the new government. Student Army aroused opposition by forcing people to cut queue and Li orders to stop the ruthless measures. Sun Wu, Xu Shengjing, Peng Hanqian were recommended to be candidates for senators but lost in the election. | France | http://trove.nla.gov.au/newspaper/page/24092107 | 24092107 |
28968 | 28968 | 1914-06-20 | 3 | c-d | A French farmer sues a pilot for flying across his farm and the court hearing. | France | http://trove.nla.gov.au/newspaper/page/24093147 | 24093147 | |
30281 | 30281 | 1915-07-17 | 3 | c-d | Battle situation in Turkish strait between French, British and Turkish troops. | France | http://trove.nla.gov.au/newspaper/page/24094912 | 24094912 | |
33066 | 33066 | 1918-03-02 | 3 | c-d | A conference in Paris to promote the friendship between China and France and the report. | France | http://trove.nla.gov.au/newspaper/page/24097199 | 24097199 | |
34511 | 34511 | 1919-05-24 | 3 | c-d | Liang Qichao in Paris and his activities there. | France | http://trove.nla.gov.au/newspaper/page/24097725 | 24097725 | |
40557 | 40557 | 1923-10-20 | 2 | c-d | Second and final part of a report that the Chinese community in France oppose to the condominium of railway in China. | France | http://trove.nla.gov.au/newspaper/page/24094584 | 24094584 |
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]);