This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17873 | 17873 | 1907-08-03 | 3 | a-b | Guangdong news. Friendship between Qin Chunxuan and Hu Fan. Preparation underway to establish some army schools in Guangzhou. Zhou Fu will not be demoted. Hunan railway company comes to raise funds in Guangdong. New governor Qin Chunxuan and his entourage. Qin Chunxuan suggests to use Beiyang military officers to train the New Army of Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801419 | 26801419 | |
17874 | 17874 | 1907-08-03 | 3 | b | Prince of Germany talks about the yellow peril, their cooperation with France, Japan's ambition, and recent dispute between Japan and America. | Britain | http://trove.nla.gov.au/newspaper/page/26801419 | 26801419 | |
17875 | 17875 | 1907-08-03 | 3 | b | Report on anti-Japanese movement in San Francisco. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801419 | 26801419 | |
17876 | 17876 | 1907-08-03 | 3 | b | An explosion at a coal mine in Japan claims 471 lives. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801419 | 26801419 | |
17877 | 17877 | 1907-08-03 | 3 | b | Britain and Russia sign a treaty but no details are reported. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801419 | 26801419 | |
17878 | 17878 | 1907-08-03 | 3 | b | Fire in British Colombia, Canada. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801419 | 26801419 | |
17879 | 17879 | 1907-08-03 | 3 | b-c | Another attempt to assassinate Tsar of Russia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801419 | 26801419 | |
17880 | 17880 | 1907-08-03 | 3 | c | Two thousand Chinese labourers in South Africa want to renew their labour contract. | Australia | http://trove.nla.gov.au/newspaper/page/26801419 | 26801419 | |
17881 | 17881 | 1907-08-03 | 3 | c | Japan and Russia sign a treaty in St Petersburg on commerce, fishing and other issues. | Australia | http://trove.nla.gov.au/newspaper/page/26801419 | 26801419 | |
17882 | 17882 | 1907-08-03 | 3 | c | Further report on the internal chaos in Korea and Japanese involvement. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801419 | 26801419 | |
17883 | 17883 | 1907-08-03 | 3 | c-d | Report on the case of Duan Zhigui. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801419 | 26801419 | |
17884 | 17884 | 1907-08-03 | 3 | d | Oxford University in Britain will publish an academic magazine in 150 languages. Number of marriages in Japan in 1907. A big hotel in Chicago. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801419 | 26801419 |
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]);