This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 45091 | 45091 | 1926-08-28 | 2 | c-d | Editorial on the patriotism and the anticommunist movement in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101680 | 24101680 | |
| 45092 | 45092 | 1926-08-28 | 2 | d-f | Wu Peifu on the international tariff conference and the resolutions. | China | http://trove.nla.gov.au/newspaper/page/24101680 | 24101680 | |
| 45093 | 45093 | 1926-08-28 | 2 | f | The Northern Expedition and the situations on the border of Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24101680 | 24101680 | |
| 45094 | 45094 | 1926-08-28 | 3 | d | Japanese on the international tariff conference. | Japan | http://trove.nla.gov.au/newspaper/page/24101679 | 24101679 | |
| 45095 | 45095 | 1926-08-28 | 3 | d-f | News on the war in Northwest China. | China | http://trove.nla.gov.au/newspaper/page/24101679 | 24101679 | |
| 45096 | 45096 | 1926-08-28 | 3 | f | An alliance of seven provinces against Guangdong is to be organised. | China | http://trove.nla.gov.au/newspaper/page/24101679 | 24101679 | |
| 45097 | 45097 | 1926-08-28 | 5 | a | Peace movement in the Balkan peninsula. | Britain | http://trove.nla.gov.au/newspaper/page/24101681 | 24101681 | |
| 45098 | 45098 | 1926-08-28 | 5 | a | Two British gunboats on the way to Changsha, of Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24101681 | 24101681 | |
| 45099 | 45099 | 1926-08-28 | 5 | a | Feng Yuxiang is returning to China. | China | http://trove.nla.gov.au/newspaper/page/24101681 | 24101681 | |
| 45100 | 45100 | 1926-08-28 | 5 | a | Zhang Xueliang is praise for his effort to wipe out the communists. | China | http://trove.nla.gov.au/newspaper/page/24101681 | 24101681 | |
| 45101 | 45101 | 1926-08-28 | 5 | a | Revolution in Nicaragua. | America | http://trove.nla.gov.au/newspaper/page/24101681 | 24101681 | |
| 45102 | 45102 | 1926-08-28 | 5 | b | Coup in Greece. | Other... | http://trove.nla.gov.au/newspaper/page/24101681 | 24101681 | |
| 45103 | 45103 | 1926-08-28 | 5 | b | American government to abolish the extraterritoriality in China. | America | http://trove.nla.gov.au/newspaper/page/24101681 | 24101681 | |
| 45104 | 45104 | 1926-08-28 | 5 | c | Anti-Japanese movement in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101681 | 24101681 | |
| 45105 | 45105 | 1926-08-28 | 5 | c | Pirates near Macao. | Other... | http://trove.nla.gov.au/newspaper/page/24101681 | 24101681 | |
| 45106 | 45106 | 1926-08-28 | 5 | c | Chinese bandits in Hong Kong hijack a Western fishing boat. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101681 | 24101681 | |
| 45107 | 45107 | 1926-08-28 | 5 | c | The Hong Kong governor on the strike and the effects. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101681 | 24101681 | |
| 45108 | 45108 | 1926-08-28 | 6 | a-b | Disarmament and the future of Europe. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101684 | 24101684 | |
| 45109 | 45109 | 1926-08-28 | 6 | b | Industrial development in the Soviet Russia. | Other... | http://trove.nla.gov.au/newspaper/page/24101684 | 24101684 | |
| 45110 | 45110 | 1926-08-28 | 6 | c | A case of murder in the Chinese community of Hawaii. | America | http://trove.nla.gov.au/newspaper/page/24101684 | 24101684 | |
| 45111 | 45111 | 1926-08-28 | 6 | c | Cuba bans entry of foreign actors. | Other... | http://trove.nla.gov.au/newspaper/page/24101684 | 24101684 | |
| 45112 | 45112 | 1926-08-28 | 6 | c | Chinese community in Cuba and the Guangzhou government. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101684 | 24101684 | |
| 45113 | 45113 | 1926-08-28 | 7 | a-c | Australia news/ The New South Wales state authority investigate the Chinese furniture shops and their working hours. Captain is punished in Sydney for illegal immigrants. Rapist is sentenced to death in Melbourne. Conclusion of the court hearing in New Castle on the illegal Chinese immigrant. Japanese parliament members come to visit Australia. Chinese Chamber of Commerce in Sydney prepares to celebrate the birthday of Confucius. Shop burglary in Brisbane. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101683 | 24101683 | |
| 45114 | 45114 | 1926-08-28 | 7 | d | Advertisement for the Australia-China Navigation Company Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101683 | 24101683 | |
| 45115 | 45115 | 1926-08-28 | 7 | d | A notice by the Chinese Presbyterian church in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101683 | 24101683 | |
| 45116 | 45116 | 1926-08-28 | 8 | a-d | Guangdong news/ Talks in Guangzhou to end the strike and the foreign settlements. Taxes to be collected for medicine wines. Gaoyao county asks for assistance for famine relief. Zhu Zhuowen escapes from bandits. An attempt to assassinate Jiang Jieshi. Luo Kun has occupies Danshui county. | China | http://trove.nla.gov.au/newspaper/page/24101686 | 24101686 |
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]);