This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
15355 | 15355 | 1906-02-17 | 3 | a | Japan is expanding its business into China, the Philippines, Sakhalin Island and other parts of Asia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800902 | 26800902 | |
15356 | 15356 | 1906-02-17 | 3 | b | China asks Russia to withdraw its troops from Manchuria and to compensate China's share of the Sino-Russia Bank. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800902 | 26800902 | |
15357 | 15357 | 1906-02-17 | 3 | a | Foreign troops will remain to stay in China for the time being. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800902 | 26800902 | |
15358 | 15358 | 1906-02-17 | 3 | b | More missionary cases in Jiangsu and Fujian provinces. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800902 | 26800902 | |
15359 | 15359 | 1906-02-17 | 3 | b | Income of King of Belgium. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800902 | 26800902 | |
15360 | 15360 | 1906-02-17 | 3 | b | China is seeking to take back Weihaiwei from Britain after the Russo-Japanese War. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800902 | 26800902 | |
15361 | 15361 | 1906-02-17 | 3 | b | Germany is to build bigger warship. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800902 | 26800902 | |
15362 | 15362 | 1906-02-17 | 3 | b | New South Wales has secured a loan from Britain. | Britain | http://trove.nla.gov.au/newspaper/page/26800902 | 26800902 | |
15363 | 15363 | 1906-02-17 | 3 | b | Chaos in British colony, Transvaal (South Africa), and German colony in West Africa. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800902 | 26800902 | |
15364 | 15364 | 1906-02-17 | 3 | b | Xu Shiqin reports on the Chinese communities in the Philippines and their business there. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800902 | 26800902 |
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]);