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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
45104 | 45104 | 1926-08-28 | 5 | c | Anti-Japanese movement in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101681 | 24101681 | |
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 | |
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 | |
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 | |
45102 | 45102 | 1926-08-28 | 5 | b | Coup in Greece. | Other... | http://trove.nla.gov.au/newspaper/page/24101681 | 24101681 | |
45111 | 45111 | 1926-08-28 | 6 | c | Cuba bans entry of foreign actors. | Other... | http://trove.nla.gov.au/newspaper/page/24101684 | 24101684 | |
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 | |
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 | |
45099 | 45099 | 1926-08-28 | 5 | a | Feng Yuxiang is returning to China. | 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 | |
45109 | 45109 | 1926-08-28 | 6 | b | Industrial development in the Soviet Russia. | Other... | 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 | |
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 | |
45097 | 45097 | 1926-08-28 | 5 | a | Peace movement in the Balkan peninsula. | Britain | 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 | |
45101 | 45101 | 1926-08-28 | 5 | a | Revolution in Nicaragua. | America | 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 | |
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 | |
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 | |
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 | |
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 |
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]);