This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25402 | 25402 | 1911-12-09 | 7 | a-b | Australian news | Shen Dunhe's donations to China. West Australia sends six boxes of apples to British King in India for coronation. Australian federal government proposes to have an office in London. Another more than 1000 British migrants arrived in Victoria. Australian expedition to the South Pole marches on. Parliamentary members ask for salary increase. An Australian kills his family and then suicides. Portugal builds wireless telephone on one of its colonial islands near Australia. British paoqiu (nnn) team competes Australian team in Sydney. | Other... | http://trove.nla.gov.au/newspaper/page/24092030 | 24092030 |
25403 | 25403 | 1911-12-09 | 7 | b | Urgent Message from China's Donghua Hospital | An urgent message from China's Donghua Hospital asks for donations to those suffer from war disasters in Hubei. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092030 | 24092030 |
25404 | 25404 | 1911-12-09 | 7 | b | Capital for the Republic | The revolutionaries announces to have Nanjing as its capital. | China | http://trove.nla.gov.au/newspaper/page/24092030 | 24092030 |
25405 | 25405 | 1911-12-09 | 7 | b | Britain sends troops to Hankou | Britain sends troops to Hankou, Hubei due to revolutionary riots there. | China | http://trove.nla.gov.au/newspaper/page/24092030 | 24092030 |
25406 | 25406 | 1911-12-09 | 7 | b | Another call for peaceful negotiation | Revolutionaries and government both call for peaceful negotiation. | China | http://trove.nla.gov.au/newspaper/page/24092030 | 24092030 |
25407 | 25407 | 1911-12-09 | 7 | b | Yichang lost to revolutionaries | Yichang has lost to revolutionaries. | China | http://trove.nla.gov.au/newspaper/page/24092030 | 24092030 |
25408 | 25408 | 1911-12-09 | 7 | b | Students of Nanjing University flee away | Overseas students of Nanjing University flee away due to revolutionary riots there. | Other... | http://trove.nla.gov.au/newspaper/page/24092030 | 24092030 |
25409 | 25409 | 1911-12-09 | 7 | c | Japanese miliatry and economy | Japan decides to build more warships next year, which is to affect its economy greatly. | Japan | http://trove.nla.gov.au/newspaper/page/24092030 | 24092030 |
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]);