This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25384 | 25384 | 1911-12-09 | 3 | a | Riots in China | Revolutionary riots result in several cities falling into revolutionary hands. | China | http://trove.nla.gov.au/newspaper/page/24092026 | 24092026 |
25385 | 25385 | 1911-12-09 | 3 | a-b | Canadian government welcomes migrants | Number of British migrants has increased in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24092026 | 24092026 |
25386 | 25386 | 1911-12-09 | 3 | b | Japanese finance | Japanese finance is in deficit. Withdraw of more budget for military expansion applauds wide support. | Japan | http://trove.nla.gov.au/newspaper/page/24092026 | 24092026 |
25387 | 25387 | 1911-12-09 | 3 | b | Russia is likely to have a war with Persia | Russia is likely to have a war with Persia over the issue of former Persian king's property. | Britain | http://trove.nla.gov.au/newspaper/page/24092026 | 24092026 |
25388 | 25388 | 1911-12-09 | 3 | b | Coronation ceremony for Thailand's king | A coronation ceremony is held for Thailand's king. | Other... | http://trove.nla.gov.au/newspaper/page/24092026 | 24092026 |
25389 | 25389 | 1911-12-09 | 3 | b | A photo of Thailand's king | A photo of Thailand's king. | Other... | http://trove.nla.gov.au/newspaper/page/24092026 | 24092026 |
25390 | 25390 | 1911-12-09 | 3 | b | A message from British overseas Chinese | A message from overseas Chinese in Britain asks for support for establishment of a republic China. | China | http://trove.nla.gov.au/newspaper/page/24092026 | 24092026 |
25391 | 25391 | 1911-12-09 | 3 | c | Government's attitude toward public opinions | Government is more careful of public opinions. | China | http://trove.nla.gov.au/newspaper/page/24092026 | 24092026 |
25392 | 25392 | 1911-12-09 | 3 | c | New regulations in the constitution | New important regulations in the constitution include emperor's limits of right etc. | Other... | http://trove.nla.gov.au/newspaper/page/24092026 | 24092026 |
25393 | 25393 | 1911-12-09 | 3 | c | Chaos in Hubei government | Officials of Hubei government flee one after another due to revolutionary riots. | Other... | http://trove.nla.gov.au/newspaper/page/24092026 | 24092026 |
25394 | 25394 | 1911-12-09 | 3 | c | Military office examines Hubei financial account | Military office examines Hubei financial account. | Other... | http://trove.nla.gov.au/newspaper/page/24092026 | 24092026 |
25395 | 25395 | 1911-12-09 | 3 | c-d | Guangdong news | Various organisations ask for union. Governor rewards new army for their efforts to protect Guangdong. Army general asks for calm and do not believe any rumour about revolution. Banks are busy with answering people's demands for more security boxes. Hong Kong is to be over populated with more and more people fleeing there from Guangdong. Revolutionary assassin of General Feng dies due to serious wound. | Other... | http://trove.nla.gov.au/newspaper/page/24092026 | 24092026 |
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]);