This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28500 | 28500 | 1914-02-28 | 3 | a | Chinese government to abolish the system of military governorship. | China | http://trove.nla.gov.au/newspaper/page/24093021 | 24093021 | |
28501 | 28501 | 1914-02-28 | 3 | a | Yuan Shikai and Li Yuanhong praise Kang Youwei. | China | http://trove.nla.gov.au/newspaper/page/24093021 | 24093021 | |
28502 | 28502 | 1914-02-28 | 3 | a | Zhang Binglin (Taiyan) makes trouble in the Presidential office in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24093021 | 24093021 | |
28503 | 28503 | 1914-02-28 | 3 | b | Financial panic in China. | China | http://trove.nla.gov.au/newspaper/page/24093021 | 24093021 | |
28504 | 28504 | 1914-02-28 | 3 | b | British government to cancel naval exercise this year. | Britain | http://trove.nla.gov.au/newspaper/page/24093021 | 24093021 | |
28505 | 28505 | 1914-02-28 | 3 | b | Date is set for the opening of the Panama Canal. | America | http://trove.nla.gov.au/newspaper/page/24093021 | 24093021 | |
28506 | 28506 | 1914-02-28 | 3 | b | Sick servicemen in German and French armies. | Britain | http://trove.nla.gov.au/newspaper/page/24093021 | 24093021 | |
28507 | 28507 | 1914-02-28 | 3 | b | Germany has built new warships. | Britain | http://trove.nla.gov.au/newspaper/page/24093021 | 24093021 | |
28508 | 28508 | 1914-02-28 | 3 | b | Japan dispatches more troops to Manchuria and Korea. | Britain | http://trove.nla.gov.au/newspaper/page/24093021 | 24093021 | |
28509 | 28509 | 1914-02-28 | 3 | b | Poor and homeless people in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24093021 | 24093021 | |
28510 | 28510 | 1914-02-28 | 3 | b | German government interferes with newspaper publishing. | Germany | http://trove.nla.gov.au/newspaper/page/24093021 | 24093021 | |
28511 | 28511 | 1914-02-28 | 3 | b | Troops in Mexico kill foreigners. | Other... | http://trove.nla.gov.au/newspaper/page/24093021 | 24093021 | |
28512 | 28512 | 1914-02-28 | 3 | c | Prussia, France, Britain, Transvaal, Japan and Russia and their loss in the various war. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093021 | 24093021 | |
28513 | 28513 | 1914-02-28 | 3 | c-d | Beijing news/ President Yuan Shikai orders to disband all political parties. Yuan Shikai on Confucianism. President Yuan Shikai on the New Year. President Yuan Shikai dispatches troops to Mongolia. Tibet issues and the negotiation between Britain and China. | China | http://trove.nla.gov.au/newspaper/page/24093021 | 24093021 | |
28514 | 28514 | 1914-02-28 | 3 | d | Guangdong news/ Central government notifies Guangdong on the new name of national parliament. Guangdong students in Japan request to set Confucianism the state religion of China. Abolition of likin and the increase of tax. Bank of Guangdong to be established. Servicemen to be disciplined. | China | http://trove.nla.gov.au/newspaper/page/24093021 | 24093021 |
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]);