This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24383 | 24383 | 1911-03-04 | 3 | a | Negotiation between China and Russia | China and Russia settled down the issue of Yili in Xinjiang. | Russia | http://trove.nla.gov.au/newspaper/page/24091685 | 24091685 |
24384 | 24384 | 1911-03-04 | 3 | a | America strictly bans opium | America forfeited illegal opium mostly from Canada and Mexico and announced it strictly bans opium. | America | http://trove.nla.gov.au/newspaper/page/24091685 | 24091685 |
24385 | 24385 | 1911-03-04 | 3 | a | Epidemic in Manchu | Many died from the epidemic in Manchu. | China | http://trove.nla.gov.au/newspaper/page/24091685 | 24091685 |
24386 | 24386 | 1911-03-04 | 3 | a | British King meets prime ministers on schedule | British King meets prime ministers of its colonies according to its schedule. | Britain | http://trove.nla.gov.au/newspaper/page/24091685 | 24091685 |
24387 | 24387 | 1911-03-04 | 3 | a | Various countries are planning to expand their navies and armies | Various countries are planning to expand their navies and armies. | Other... | http://trove.nla.gov.au/newspaper/page/24091685 | 24091685 |
24388 | 24388 | 1911-03-04 | 3 | a-b | The dream of world peace organisation | America proposed to have a world peace organisation. The proposal received positive response from Britain and France. But China should consider it carefully. | Other... | http://trove.nla.gov.au/newspaper/page/24091685 | 24091685 |
24389 | 24389 | 1911-03-04 | 3 | b | America-Japanese new agreement | America has reached a new agreement with Japan, which will stop Japan to export its labourers to America. | America | http://trove.nla.gov.au/newspaper/page/24091685 | 24091685 |
24390 | 24390 | 1911-03-04 | 3 | b | Opium and Britain | China asks Britain to ban its export of opium to China. | China | http://trove.nla.gov.au/newspaper/page/24091685 | 24091685 |
24391 | 24391 | 1911-03-04 | 3 | b | Russia develops Siberia | Russia planned to develop Siberia with building a new railway. | Russia | http://trove.nla.gov.au/newspaper/page/24091685 | 24091685 |
24392 | 24392 | 1911-03-04 | 3 | b | China's education department concerns education of overseas Chinese | China's education department concerns education of its overseas Chinese. | China | http://trove.nla.gov.au/newspaper/page/24091685 | 24091685 |
24393 | 24393 | 1911-03-04 | 3 | b | The military intelligence bans foreigners to do surveys in China | The military intelligence bans foreigners to do detailed surveys in China. | China | http://trove.nla.gov.au/newspaper/page/24091685 | 24091685 |
24394 | 24394 | 1911-03-04 | 3 | c | Beijing news | The issue of the resign of a senior official; the issue of lease of the three northeast provinces to foreign countries; the emperor practises calligraphy; the closing of the Adversory Department; and more money were allocated to Jiangsu and Anhui for their famine disasters. | China | http://trove.nla.gov.au/newspaper/page/24091685 | 24091685 |
24395 | 24395 | 1911-03-04 | 3 | c-d | Guangdong news | the issue of military budget; the issue of Guangdong's levy to the Boxer Indemnity; corruption in the army in Guangdong; the arrangements for emperor's visit to Guangdong; and Dongjiang is suffering the infamous name as the place of thefts. | China | http://trove.nla.gov.au/newspaper/page/24091685 | 24091685 |
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]);