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 |
---|---|---|---|---|---|---|---|---|---|
54568 | 54568 | 1934-10-06 | 2 | a | First part of an editorial on Confucianism and the national crisis in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096182 | 24096182 | |
54569 | 54569 | 1934-10-06 | 2 | c | Celebrations in Nanjing and Qufu, of Shandong province, on the birthday of Confucius. | China | http://trove.nla.gov.au/newspaper/page/24096182 | 24096182 | |
54570 | 54570 | 1934-10-06 | 2 | d | Drought and floods in China. | China | http://trove.nla.gov.au/newspaper/page/24096182 | 24096182 | |
54571 | 54571 | 1934-10-06 | 2 | e | Japanese are busying preparing for the war with Russian. | China | http://trove.nla.gov.au/newspaper/page/24096182 | 24096182 | |
54572 | 54572 | 1934-10-06 | 2 | e | Liu Guitang organises East Asian Republic Army in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24096182 | 24096182 | |
54573 | 54573 | 1934-10-06 | 2 | f | Peasants in Chaoyang, Liaoning province, and their fighting with Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24096182 | 24096182 | |
54574 | 54574 | 1934-10-06 | 3 | a | American warships gather in the Pacific region. | America | http://trove.nla.gov.au/newspaper/page/24096181 | 24096181 | |
54575 | 54575 | 1934-10-06 | 3 | b | Heat waves swallow Nanjing and Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096181 | 24096181 | |
54576 | 54576 | 1934-10-06 | 3 | c | Chinese immigrants are beaten in Japan. | China | http://trove.nla.gov.au/newspaper/page/24096181 | 24096181 | |
54577 | 54577 | 1934-10-06 | 3 | e | Britain prepares for war and the attitudes of its colonies. | Britain | http://trove.nla.gov.au/newspaper/page/24096181 | 24096181 | |
54578 | 54578 | 1934-10-06 | 3 | f | Graduation means unemployment in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24096181 | 24096181 | |
54579 | 54579 | 1934-10-06 | 5 | d | A visit to the grave of Hai Rui, official of the Ming Dynasty. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096183 | 24096183 | |
54580 | 54580 | 1934-10-06 | 7-8 | a-f | Guangdong news/ Liu Luyin to Nanjing for a discussion of cooperation between Nanjing and Guangzhou. Preparation for the railway construction from Guangzhou to Shantou and the involvement of foreign loans. Guangdong to manufacture gas masks. The communist troops under Xiao Ke and Li Zongbao. A survey on the business in Guangzhou. New business town in Dongguan. Floods in Dongguan. Road projects in Taishan and Yangchun counties and the disputes. | China | http://trove.nla.gov.au/newspaper/page/24096185 | 24096185 | |
54581 | 54581 | 1934-10-06 | 6 | a | Further report on the typhoon in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096186 | 24096186 | |
54582 | 54582 | 1934-10-06 | 6 | a | American scholar on the coming war between Russia and Japan. | America | http://trove.nla.gov.au/newspaper/page/24096186 | 24096186 | |
54583 | 54583 | 1934-10-06 | 6 | b | Afghanistan joins the League of Nations. | Other... | http://trove.nla.gov.au/newspaper/page/24096186 | 24096186 | |
54584 | 54584 | 1934-10-06 | 6 | b | Belgium bans Australian wheat. | Britain | http://trove.nla.gov.au/newspaper/page/24096186 | 24096186 | |
54585 | 54585 | 1934-10-06 | 6 | a | A terrible scene of the future war. | Britain | http://trove.nla.gov.au/newspaper/page/24096186 | 24096186 | |
54586 | 54586 | 1934-10-06 | 6 | d | Industrial prosperity in Japan and the reasons. | Other... | http://trove.nla.gov.au/newspaper/page/24096186 | 24096186 | |
54587 | 54587 | 1934-10-06 | 6 | d | A Russian man is sentenced for bigamy. | Russia | http://trove.nla.gov.au/newspaper/page/24096186 | 24096186 | |
54588 | 54588 | 1934-10-06 | 6 | d | Hurricane in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096186 | 24096186 | |
54589 | 54589 | 1934-10-06 | 6 | e | Australia news/ Statistics about Australia for the first half of this year. The Labour Party is defeated in the federal election. Performance of Chinese boxing coach Huang Boquan. Population on the Nauru island. More European women are smoking. Furniture industry in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096186 | 24096186 |
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]);