This data as json, CSV (advanced)
Suggested facets: page, column, description, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 32536 | 32536 | 1917-08-11 | 2 | a | The Wing On Company in Shanghai urges shareholders to pay their dues and their public notice. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095793 | 24095793 | |
| 32537 | 32537 | 1917-08-11 | 2 | a-d | Editorial by Tung Wah Times claims that China should not have two governments respectively in the south and in the north. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095793 | 24095793 | |
| 32538 | 32538 | 1917-08-11 | 2 | d-f | Liang Qichao on the Chinese foreign policy, part VI (final part). | China | http://trove.nla.gov.au/newspaper/page/24095793 | 24095793 | |
| 32539 | 32539 | 1917-08-11 | 2 | f | Wang Zhanyuan suggests to re-elect members of the Chinese parliament and his circular telegram. | China | http://trove.nla.gov.au/newspaper/page/24095793 | 24095793 | |
| 32540 | 32540 | 1917-08-11 | 3 | -b | Sun Faxu suggests to draft another constitution of China and his circular telegram. | China | http://trove.nla.gov.au/newspaper/page/24095792 | 24095792 | |
| 32541 | 32541 | 1917-08-11 | 3 | c-d | Chronology of the Chinese Republic. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095792 | 24095792 | |
| 32542 | 32542 | 1917-08-11 | 3 | d-e | The Entente countries to help each other and their strategies. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095792 | 24095792 | |
| 32543 | 32543 | 1917-08-11 | 3 | e | American businessmen urge to organise a Sino-American chamber of commerce. | China | http://trove.nla.gov.au/newspaper/page/24095792 | 24095792 | |
| 32544 | 32544 | 1917-08-11 | 3 | e | China to declare war with Germany. | Canada | http://trove.nla.gov.au/newspaper/page/24095792 | 24095792 | |
| 32545 | 32545 | 1917-08-11 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095792 | 24095792 | |
| 32546 | 32546 | 1917-08-11 | 6 | a-c | Second and final part of the law on self government at village and town (xiang) level in China. | China | http://trove.nla.gov.au/newspaper/page/24095797 | 24095797 | |
| 32547 | 32547 | 1917-08-11 | 6 | c-d | Miscellaneous report on the restoration of monarchy in China. | China | http://trove.nla.gov.au/newspaper/page/24095797 | 24095797 | |
| 32548 | 32548 | 1917-08-11 | 7 | a-b | Proposal written by Peng Shao'an, Chinese businessman in Melbourne, on the establishment of a steamship company. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095796 | 24095796 | |
| 32549 | 32549 | 1917-08-11 | 7 | b-c | Train and tram workers are on strike in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095796 | 24095796 | |
| 32550 | 32550 | 1917-08-11 | 7 | c | Foreign report on the current politics in China. | Canada | http://trove.nla.gov.au/newspaper/page/24095796 | 24095796 | |
| 32551 | 32551 | 1917-08-11 | 7 | c-d | Miscellaneous report on the restoration of monarchy in China. | China | http://trove.nla.gov.au/newspaper/page/24095796 | 24095796 | |
| 32552 | 32552 | 1917-08-11 | 8 | a-c | Beijing news/ | http://trove.nla.gov.au/newspaper/page/24095799 | 24095799 |
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]);