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 |
---|---|---|---|---|---|---|---|---|---|
29111 | 29111 | 1914-08-01 | 2 | b-d | Opening ceremony of the Political Affairs Committee (can zheng yuan) in Beijing and backgrounds of the committee members. | China | http://trove.nla.gov.au/newspaper/page/24093196 | 24093196 | |
29112 | 29112 | 1914-08-01 | 3 | a | Chinese President Yuan Shikai on the new generation of people. | China | http://trove.nla.gov.au/newspaper/page/24093195 | 24093195 | |
29122 | 29122 | 1914-08-01 | 3 | b-c | Beijing news/ Chinese President Yuan Shikai talks his major policy. Chinese government to revise the etiquette. The Progressive Party (jin bu dang) and their anniversary celebration. Japanese authority might deport Sun Yatsen. Japan changes its policy towards the Chinese rebels. Town is flooded in Pingxiang, of Hubei province and the report. Rebels arrested in Shandong province and their confession. | China | http://trove.nla.gov.au/newspaper/page/24093195 | 24093195 | |
29123 | 29123 | 1914-08-01 | 3 | c-d | Guangdong news/ Provincial authority issued a public notice to retrieve old coins. Investigation on the assets confiscated from Kang Youwei. Zhaoqing asks for more funds for the flood relief. Human bodies found in the river in Guangzhou. Guangdong province is to be divided into six prefectures. Confucian Society in Guangzhou has a seminar. | China | http://trove.nla.gov.au/newspaper/page/24093195 | 24093195 | |
29125 | 29125 | 1914-08-01 | 6 | b | Kaiping county to build or rebuild all roads and a notice issued by the county magistrate Long Zhize on the infrastructure development. | China | http://trove.nla.gov.au/newspaper/page/24093200 | 24093200 | |
29126 | 29126 | 1914-08-01 | 6 | b-c | Miscellaneous report on the Chinese politics and officialdom. | China | http://trove.nla.gov.au/newspaper/page/24093200 | 24093200 |
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]);