This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
16059 | 16059 | 1906-08-18 | 3 | a | Report on the salvaging of sunken Japanese warship. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801058 | 26801058 | |
16060 | 16060 | 1906-08-18 | 3 | a | Japanese fishermen shot dead or arrested in Alaska. Japan and the United States of America are negotiating over this matter. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801058 | 26801058 | |
16061 | 16061 | 1906-08-18 | 3 | b | Both Newfoundland and Colombia in America have a high rate of tax to maintain the ban on Chinese immigrants. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801058 | 26801058 | |
16062 | 16062 | 1906-08-18 | 3 | b | Russia swallowed by revolutionary tides. Revolutionary movement sweeps Poland and St Petersburg. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801058 | 26801058 | |
16063 | 16063 | 1906-08-18 | 3 | b | China and Britain reach an agreement over the Tibet treaty. Brief outline of the treaty and comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801058 | 26801058 | |
16064 | 16064 | 1906-08-18 | 3 | b | Emperor of Turkey is critically ill. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801058 | 26801058 | |
16065 | 16065 | 1906-08-18 | 3 | b | Japanese government seeks compensation from Russia for feeding their Prisoners of War. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801058 | 26801058 | |
16066 | 16066 | 1906-08-18 | 3 | b | Persia plans to set up a parliament and adopt a system of constitutional monarchy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801058 | 26801058 | |
16067 | 16067 | 1906-08-18 | 3 | b | American authority employs 2,500 Chinese labourers to open the Panama Canal. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801058 | 26801058 | |
16068 | 16068 | 1906-08-18 | 3 | b | British foreign secretary and Hong Kong governor seek to reinstate Robert Hart to the position of inspector general of the Chinese Maritime Customs Bureau. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801058 | 26801058 |
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]);