This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24537 | 24537 | 1911-05-20 | 2 | b-c | Crimes of traitors | Crimes of national traitors such as Cao Ruling are revealed. | China | http://trove.nla.gov.au/newspaper/page/24091778 | 24091778 |
24541 | 24541 | 1911-05-20 | 3 | a | Drug-smoking ban treaty extended | The drug-smoking ban treaty is extended for another seven years. | China | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24542 | 24542 | 1911-05-20 | 3 | a | Fire in Jiling | A big fire disaster happened in Jiling. | China | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24544 | 24544 | 1911-05-20 | 3 | a | Foreign loans for building railways | Chinese government proposes more loans for building its railways. | China | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24555 | 24555 | 1911-05-20 | 3 | d | Beijing news | Li Jingman has been promoted. The transition from old cabinet to new cabinet. Government asks for military reserve funds. Zhen Beizi and his delegation set for British coronation. Hu Xinwu may be promoted. Commander-in-chief of three provinces of north China proposes a new appointment of army chairman for the three provinces. Governor of north China asks for actions to deal with Russia and Japan. A senior official still smokes drugs. | China | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24556 | 24556 | 1911-05-20 | 3 | c-d | Guangdong news | Governor inspects Nanqiang School. Guangdong government asks for Beijing's approval to turn Yulin Island into a military base. Dealing with Yishanyuan bank. New policy for passports. Governor approved for air craft flying experiment. A rich family's house has been rent for gambling. Xiangshan has set up a workers' union. | China | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
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]);