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 |
---|---|---|---|---|---|---|---|---|---|
45101 | 45101 | 1926-08-28 | 5 | a | Revolution in Nicaragua. | America | 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 | |
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 | |
45097 | 45097 | 1926-08-28 | 5 | a | Peace movement in the Balkan peninsula. | Britain | http://trove.nla.gov.au/newspaper/page/24101681 | 24101681 | |
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 | |
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 | |
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 | |
45104 | 45104 | 1926-08-28 | 5 | c | Anti-Japanese movement in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101681 | 24101681 | |
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 | |
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 | |
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 | |
45094 | 45094 | 1926-08-28 | 3 | d | Japanese on the international tariff conference. | Japan | http://trove.nla.gov.au/newspaper/page/24101679 | 24101679 | |
45102 | 45102 | 1926-08-28 | 5 | b | Coup in Greece. | Other... | 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 | |
45109 | 45109 | 1926-08-28 | 6 | b | Industrial development in the Soviet Russia. | Other... | 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 | |
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 | |
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 | |
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 |
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]);