This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28647 | 28647 | 1914-04-04 | 2 | a-b | Editorial on the Chines school education in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093062 | 24093062 | |
28648 | 28648 | 1914-04-04 | 2 | b | Chinese cabinet dispatches inspectors to local province to investigate government redundancy, payment of revenue and reform of civil service. | China | http://trove.nla.gov.au/newspaper/page/24093062 | 24093062 | |
28649 | 28649 | 1914-04-04 | 2 | b-c | Chinese Premier Xiong Xiling resigns and the approval by President Yuan Shikai. | China | http://trove.nla.gov.au/newspaper/page/24093062 | 24093062 | |
28650 | 28650 | 1914-04-04 | 2 | c | Proposal in China to abolish the position of vice president. | China | http://trove.nla.gov.au/newspaper/page/24093062 | 24093062 | |
28651 | 28651 | 1914-04-04 | 2 | c | Chinese ministry of foreign affairs to standardise negotiations with foreign countries. | China | http://trove.nla.gov.au/newspaper/page/24093062 | 24093062 | |
28652 | 28652 | 1914-04-04 | 2 | c | Political conference in Beijing discusses the celebrations on National Day and the date. | China | http://trove.nla.gov.au/newspaper/page/24093062 | 24093062 | |
28653 | 28653 | 1914-04-04 | 2 | c-d | Zhang Zuolin in Fengtian convenes a conference on the reform of government system. | China | http://trove.nla.gov.au/newspaper/page/24093062 | 24093062 | |
28654 | 28654 | 1914-04-04 | 2 | d | Foreign missions want to expand their settlement in Hankou, Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24093062 | 24093062 | |
28655 | 28655 | 1914-04-04 | 2 | d | Hubei authority arrests some bandit remains in Hankou and the report. | China | http://trove.nla.gov.au/newspaper/page/24093062 | 24093062 |
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]);