This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 21359 | 21359 | 1909-07-24 | 3 | a | Correspondence from Beijing/ Magistrate of Shanghai under impeachment. Xu Shichang arrives Beijing to take his office of minister of communications. Xi Liang as new governor of Manchuria. More merchant societies are established among Chinese communities in Nanyang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
| 21360 | 21360 | 1909-07-24 | 3 | b-c | Tang Shaoyi arrives in Hong Kong on his way back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
| 21361 | 21361 | 1909-07-24 | 3 | b | Zai Ze and Tie Liang raise funds for Chinese navy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
| 21362 | 21362 | 1909-07-24 | 3 | b | Sun Yatsen leaves Singapore for Europe. | Other... | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
| 21363 | 21363 | 1909-07-24 | 3 | b | Revolutionary movement in Persia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
| 21364 | 21364 | 1909-07-24 | 3 | b-c | Emperor of Turkey has huge amount of savings in German bank. | Britain | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
| 21365 | 21365 | 1909-07-24 | 3 | c | American naval fleet on the way to the Philippines. | Britain | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
| 21366 | 21366 | 1909-07-24 | 3 | c | German cabinet reshuffled following the resignation of the Chancellor. | Britain | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
| 21367 | 21367 | 1909-07-24 | 3 | c | A British submarine sinks in the Atlantic. | Britain | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
| 21368 | 21368 | 1909-07-24 | 3 | c | American President Taft appoints new ambassador to China. | Britain | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
| 21369 | 21369 | 1909-07-24 | 3 | c | Earthquake in Greece. | Britain | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
| 21370 | 21370 | 1909-07-24 | 3 | c | Number of university students in France. | France | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
| 21371 | 21371 | 1909-07-24 | 3 | c | Survey on naval forces in Britain, Germany, America, France, Japan, Italy and Russia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
| 21372 | 21372 | 1909-07-24 | 3 | d | Divorce in France and the numbers. | Other... | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
| 21373 | 21373 | 1909-07-24 | 3 | d | Tung Wah Times comments on involvement of foreign loans in the railway construction in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 |
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]);