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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
47682 | 47682 | 1928-12-22 | 2 | e | Song Meiling to be mayor of Nanjing. | 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 | |
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 | |
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 | |
47686 | 47686 | 1928-12-22 | 2 | f | Internal fighting within the Chinese Nationalist Party. | China | http://trove.nla.gov.au/newspaper/page/24099058 | 24099058 | |
47687 | 47687 | 1928-12-22 | 3 | b-d | People in Manchuria protect the railway. | China | http://trove.nla.gov.au/newspaper/page/24099057 | 24099057 | |
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 | |
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 | |
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 | |
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 | |
47692 | 47692 | 1928-12-22 | 8 | a | Workers on riots in Caribbean. | Other... | 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 | |
47694 | 47694 | 1928-12-22 | 8 | a | Chaos in Mexico. | America | 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 | |
47696 | 47696 | 1928-12-22 | 8 | a | American government set up consulate in Nanjing. | China | 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 | |
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 |
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]);