This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28767 | 28767 | 1914-05-02 | 2 | a-b | Editorial by the Tung Wah Times on the training and education of servicemen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093094 | 24093094 | |
28768 | 28768 | 1914-05-02 | 2 | b | Criticism in China on the proposal of tenurable presidency. | China | http://trove.nla.gov.au/newspaper/page/24093094 | 24093094 | |
28769 | 28769 | 1914-05-02 | 2 | b-c | Chinese President Yuan Shikai on the revision of constitution. | China | http://trove.nla.gov.au/newspaper/page/24093094 | 24093094 | |
28770 | 28770 | 1914-05-02 | 2 | c | The future of China (parliament, local self-government and national administration). | China | http://trove.nla.gov.au/newspaper/page/24093094 | 24093094 | |
28771 | 28771 | 1914-05-02 | 2 | c-d | Draft regulations on the national affairs consulting committee of the Republic of China. | China | http://trove.nla.gov.au/newspaper/page/24093094 | 24093094 | |
28772 | 28772 | 1914-05-02 | 2 | d | Chinese Ministry of Finance reports the repayment of foreign debts. | China | http://trove.nla.gov.au/newspaper/page/24093094 | 24093094 | |
28773 | 28773 | 1914-05-02 | 2 | d | Implementation of the compulsory education in China and the report. | China | http://trove.nla.gov.au/newspaper/page/24093094 | 24093094 |
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]);