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 |
---|---|---|---|---|---|---|---|---|---|
47698 | 47698 | 1928-12-22 | 8 | b | The Nationalist government in Nanjing abolishes the Overseas Chinese Bureau and the notice from the Chinese Consulate-General in Australia to the Chinese Chamber of Commerce in Sydney. The woman is released in Sydney for murder of her Chinese husband. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099064 | 24099064 | |
47697 | 47697 | 1928-12-22 | 8 | a | Tobacco import of China and the competition. | America | http://trove.nla.gov.au/newspaper/page/24099064 | 24099064 | |
47696 | 47696 | 1928-12-22 | 8 | a | American government set up consulate in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099064 | 24099064 | |
47695 | 47695 | 1928-12-22 | 8 | a | Famine in north China. | China | http://trove.nla.gov.au/newspaper/page/24099064 | 24099064 | |
47694 | 47694 | 1928-12-22 | 8 | a | Chaos in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24099064 | 24099064 | |
47693 | 47693 | 1928-12-22 | 8 | a | Australian woman is stolen while touring Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24099064 | 24099064 | |
47692 | 47692 | 1928-12-22 | 8 | a | Workers on riots in Caribbean. | Other... | http://trove.nla.gov.au/newspaper/page/24099064 | 24099064 | |
47691 | 47691 | 1928-12-22 | 6-7 | a-d | Guangdong news/ Guangdong representatives reports their attendance to the national commercial chamber meeting in Shanghai. The leftist faction and their recent propaganda. Inland navigation and the difficulties. Many soldiers in Guangdong are deserting. Birthday celebration for Sun Yatsen in Guangzhou. Silk factory in Nanhai on strike. Drought in Chaoyang. News from Zengcheng. Bandits in the Beijiang area destroy forest. News from Dongguan. Shops in Shunde. Bandits suppressed in the north area. Plan for restructure in Xinhui county. Bandits in Panyu and Zengcheng county. No waitress allowed in Jiujiang, of Nanhai county. | China | http://trove.nla.gov.au/newspaper/page/24099062 | 24099062 | |
47690 | 47690 | 1928-12-22 | 5 | d-e | Second part of the report on the celebrations organised by the Chinese communities in Auckland, New Zealand, on the National Day of October 10. | New Zealand | http://trove.nla.gov.au/newspaper/page/24099059 | 24099059 | |
47689 | 47689 | 1928-12-22 | 5 | a | Hong Kong news/ Li Jishen arrives Hong Kong. Dongguan county orders gunboats from Hong Kong. A man is punished for marrying concubine. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099059 | 24099059 | |
47688 | 47688 | 1928-12-22 | 3 | e | Zhang Ji delivers a public speech after becoming chairman of the Nationalist branch in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24099057 | 24099057 | |
47687 | 47687 | 1928-12-22 | 3 | b-d | People in Manchuria protect the railway. | China | http://trove.nla.gov.au/newspaper/page/24099057 | 24099057 | |
47686 | 47686 | 1928-12-22 | 2 | f | Internal fighting within the Chinese Nationalist Party. | China | http://trove.nla.gov.au/newspaper/page/24099058 | 24099058 | |
47685 | 47685 | 1928-12-22 | 2 | e | Jiang Jieshi comments on the affairs of the Nationalist Party. | China | http://trove.nla.gov.au/newspaper/page/24099058 | 24099058 | |
47684 | 47684 | 1928-12-22 | 2 | e | Hu Hanmin replies to the Shanghai commercial chambers. | China | http://trove.nla.gov.au/newspaper/page/24099058 | 24099058 | |
47683 | 47683 | 1928-12-22 | 2 | e | Express train resumes service on the Tianjin-Pukou railway. | China | http://trove.nla.gov.au/newspaper/page/24099058 | 24099058 | |
47682 | 47682 | 1928-12-22 | 2 | e | Song Meiling to be mayor of Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099058 | 24099058 | |
47681 | 47681 | 1928-12-22 | 2 | d | China's tariff autonomy starts from next year. | China | http://trove.nla.gov.au/newspaper/page/24099058 | 24099058 | |
47680 | 47680 | 1928-12-22 | 2 | d | Foreign minister Wang Zhengting on the foreign policy of China. | China | http://trove.nla.gov.au/newspaper/page/24099058 | 24099058 |
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]);