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 |
---|---|---|---|---|---|---|---|---|---|
47696 | 47696 | 1928-12-22 | 8 | a | American government set up consulate in Nanjing. | China | 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 | |
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 | |
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 | |
47695 | 47695 | 1928-12-22 | 8 | a | Famine in north China. | China | http://trove.nla.gov.au/newspaper/page/24099064 | 24099064 | |
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 | |
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 | |
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 | |
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 | |
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 | |
47687 | 47687 | 1928-12-22 | 3 | b-d | People in Manchuria protect the railway. | China | http://trove.nla.gov.au/newspaper/page/24099057 | 24099057 | |
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 | |
47682 | 47682 | 1928-12-22 | 2 | e | Song Meiling to be mayor of Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099058 | 24099058 | |
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 | |
47692 | 47692 | 1928-12-22 | 8 | a | Workers on riots in Caribbean. | Other... | http://trove.nla.gov.au/newspaper/page/24099064 | 24099064 | |
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 |
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]);