This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28656 | 28656 | 1914-04-04 | 3 | a | The Hague conference to discuss China's compensation to foreign countries for their loss during the 1911 Revolution. | China | http://trove.nla.gov.au/newspaper/page/24093061 | 24093061 | |
28657 | 28657 | 1914-04-04 | 3 | a | The bandits in Shaanxi province. | China | http://trove.nla.gov.au/newspaper/page/24093061 | 24093061 | |
28658 | 28658 | 1914-04-04 | 3 | a | India to build a new capital and the budget. | Britain | http://trove.nla.gov.au/newspaper/page/24093061 | 24093061 | |
28659 | 28659 | 1914-04-04 | 3 | a | The United Kingdom of Britain to be a democratic republic. | Britain | http://trove.nla.gov.au/newspaper/page/24093061 | 24093061 | |
28660 | 28660 | 1914-04-04 | 3 | a-b | Another Japanese cabinet resigns. | Japan | http://trove.nla.gov.au/newspaper/page/24093061 | 24093061 | |
28661 | 28661 | 1914-04-04 | 3 | b | Revolutionary armies are defeated in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24093061 | 24093061 | |
28662 | 28662 | 1914-04-04 | 3 | b | Empress of Japan is ill seriously. | Japan | http://trove.nla.gov.au/newspaper/page/24093061 | 24093061 | |
28663 | 28663 | 1914-04-04 | 3 | b | Air mail services in Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24093061 | 24093061 | |
28664 | 28664 | 1914-04-04 | 3 | b | Chinese government troops are defeated by bandits near Tongguan, of Shaanxi province. | China | http://trove.nla.gov.au/newspaper/page/24093061 | 24093061 | |
28665 | 28665 | 1914-04-04 | 3 | b | People in Prussia demand to demolish all gallows. | Britain | http://trove.nla.gov.au/newspaper/page/24093061 | 24093061 | |
28666 | 28666 | 1914-04-04 | 3 | b | French Treasurer's wife shoots dead chief-editor of a newspaper. | Britain | http://trove.nla.gov.au/newspaper/page/24093061 | 24093061 | |
28667 | 28667 | 1914-04-04 | 3 | c | Britain is keen to lead other countries to carve up China. | Britain | http://trove.nla.gov.au/newspaper/page/24093061 | 24093061 | |
28668 | 28668 | 1914-04-04 | 3 | c | Beijing news/ Organisational regulations on the central provisional constitution committee. President Yuan Shikai orders to suppress bandits. The curfew imposed in the international settlement in Shanghai and why. To abolish military governor or governor in the province and the discussion. Self-government in local province. | China | http://trove.nla.gov.au/newspaper/page/24093061 | 24093061 | |
28669 | 28669 | 1914-04-04 | 3 | c-d | Guangdong news/ Statistics of loans owed by the Guangdong province. Bandits and their robbery in Guangzhou. Election to be supervised in the Guangzhou-Hankou railway company. Government authority executes bandits. Bandit chieftain Wu Tian is executed in Zengcheng county. A young man in Chenghai county beats his grandmother. | China | http://trove.nla.gov.au/newspaper/page/24093061 | 24093061 |
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]);