This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24329 | 24329 | 1911-02-18 | 3 | a | Fights between religious gangs | According to the news from London, fights between religious gangs happened in Yunnan. | Britain | http://trove.nla.gov.au/newspaper/page/24091669 | 24091669 |
24330 | 24330 | 1911-02-18 | 3 | a | The Regent escaped an assassin | According to the news from London, the Regent escaped an assassin. | Britain | http://trove.nla.gov.au/newspaper/page/24091669 | 24091669 |
24331 | 24331 | 1911-02-18 | 3 | a | China's population and education | China's population and education. | China | http://trove.nla.gov.au/newspaper/page/24091669 | 24091669 |
24332 | 24332 | 1911-02-18 | 3 | a | The US pays attention to China's famine | The US pays attention to China's famine and sends food and others to China. | America | http://trove.nla.gov.au/newspaper/page/24091669 | 24091669 |
24333 | 24333 | 1911-02-18 | 3 | a-b | Three million people appealed on the epidemic | Three million people appealed to the government due to more than 8 thousand people death from the epidemic. | China | http://trove.nla.gov.au/newspaper/page/24091669 | 24091669 |
24334 | 24334 | 1911-02-18 | 3 | b | Kang Yue (nnn) appointed governor to Canada | Duke Kang Yue (nnn) was appointed governor to Canada. | Britain | http://trove.nla.gov.au/newspaper/page/24091669 | 24091669 |
24335 | 24335 | 1911-02-18 | 3 | b | The development of navy in those powerful nations | The development of navy in those powerful nations in the last twenty years. | Britain | http://trove.nla.gov.au/newspaper/page/24091669 | 24091669 |
24336 | 24336 | 1911-02-18 | 3 | b | Persian minister was shot | A Persian (Iran) minister was shot by two Americans. | Other... | http://trove.nla.gov.au/newspaper/page/24091669 | 24091669 |
24337 | 24337 | 1911-02-18 | 3 | b | Russia will strengthen its navy | Russia is going to strengthen its navy. | Russia | http://trove.nla.gov.au/newspaper/page/24091669 | 24091669 |
24338 | 24338 | 1911-02-18 | 3 | b | British parliament re-opened | The British parliament re-opened its session. | Britain | http://trove.nla.gov.au/newspaper/page/24091669 | 24091669 |
24339 | 24339 | 1911-02-18 | 3 | b | The population of Prussians | The population of Prussians has increased in Germany. | Other... | http://trove.nla.gov.au/newspaper/page/24091669 | 24091669 |
24340 | 24340 | 1911-02-18 | 3 | b | The issue of the Party's ban | Mr Wen and Xiao appealed to the Regent for the lift of the party's ban. Yuan Sikai sent someone to Beijing to ask the Regent to keep the party's ban. Tao Beile appealed to the Regent for the lift of the party's ban. The state council asked to relieve those reformers. | China | http://trove.nla.gov.au/newspaper/page/24091669 | 24091669 |
24341 | 24341 | 1911-02-18 | 3 | c | Beijing news | The corruption of overman Zhang; reduction and abolishment of eunuch; women from aristocratic families had a meeting to propose abolishment of concubine system; the Constitution Library is compiling a constitutional reference book; the State Council's new building; the abolishment of treaties signed during the Opium Wars; the Qing government announced to the international organisation in Hague that the Qing government was an constitutional government; students Wang Ji and Tang Geng travelled around the world. | China | http://trove.nla.gov.au/newspaper/page/24091669 | 24091669 |
24342 | 24342 | 1911-02-18 | 3 | c-d | Guangdong news | Governor Zhang inspected Guangdong; Governor Zhang appointed new secretaries of the governor's office. Governor Zhang officially started his office; congradulation to newly-appointed Governor Zhang; new director of Guangdong transportation bureau was designing his plan; gambler Su was arrested; 25 members of the provincial parliament asked for resign; officials from the Department of Studies came to ask Guangdong for its debt to the Department. | China | http://trove.nla.gov.au/newspaper/page/24091669 | 24091669 |
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]);