This data as json, CSV (advanced)
Suggested facets: page, column, description, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50827 | 50827 | 1931-10-24 | 2 | b | China going to perish: comments by Tung Wah Times on Japanese invasion of Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090567 | 24090567 | |
50828 | 50828 | 1931-10-24 | 2 | b | Miscellaneous report on Japanese invasion of Manchuria and international responses. | China | http://trove.nla.gov.au/newspaper/page/24090567 | 24090567 | |
50829 | 50829 | 1931-10-24 | 2 | f | American government sends ultimate to Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24090567 | 24090567 | |
50830 | 50830 | 1931-10-24 | 2 | f | Different response of foreign countries on Japanese invasion of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090567 | 24090567 | |
50831 | 50831 | 1931-10-24 | 3 | a-f | Miscellaneous report on Japanese invasion of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090566 | 24090566 | |
50832 | 50832 | 1931-10-24 | 5 | a | The zhi gong tang, Chinese Constitutionalist Party and other associations jointly appeal to stop internal conflict in order to fight Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090568 | 24090568 | |
50833 | 50833 | 1931-10-24 | 5 | d | Travel notes to Korea. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090568 | 24090568 | |
50834 | 50834 | 1931-10-24 | 5 | e | Chinese Chamber of Commerce in Sydney calls for donations to the flooding areas in China and names listed for all donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090568 | 24090568 | |
50835 | 50835 | 1931-10-24 | 6-7 | a-d | Guangdong news/ Japanese consul visits Chen Youren for three times. A run on Japanese bank in Guangzhou. Reconciliation between Guangdong and Nanjing. Vegetables businessmen protest against the export taxes. Conditions for peace and reconciliation between Nanjing and Guangdong. Tang Shengzhi and the Hunan army and the cost. Gold mine in Lianshan county. Dam building Shantou and the disputes. Clash between police and civil corps in Dongguan. Villagers in fighting in Zhongshan county. More levies on tea and snacks in Taishan county. Demonstration of prostitutes in Jiangmen. Bandits in Enping loot villages. Police in Guangzhou raid opium dens. | China | http://trove.nla.gov.au/newspaper/page/24090571 | 24090571 | |
50836 | 50836 | 1931-10-24 | 8 | a | Miscellaneous report on Japanese invasion of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090573 | 24090573 | |
50837 | 50837 | 1931-10-24 | 8 | c | Thomas Edison dies. | America | http://trove.nla.gov.au/newspaper/page/24090573 | 24090573 | |
50838 | 50838 | 1931-10-24 | 8 | d | A bank robbery in America. | America | http://trove.nla.gov.au/newspaper/page/24090573 | 24090573 | |
50839 | 50839 | 1931-10-24 | 8 | d | Australia news/ A letter from the Chinese Consulate-General in Australia on the complaints of the Chinese communities in Queensland. A traffic collision in Sydney. Gibbs & Bright liner refuse to carry Japanese passengers. The Overseas Chinese Famine Relief Committee in Shanghai writes to the Chinese Chamber of Commerce of New South Wales on the relief work in China. New ship for the liner service between China and Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090573 | 24090573 |
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]);