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 |
---|---|---|---|---|---|---|---|---|---|
54575 | 54575 | 1934-10-06 | 3 | b | Heat waves swallow Nanjing and Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096181 | 24096181 | |
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 | |
54574 | 54574 | 1934-10-06 | 3 | a | American warships gather in the Pacific region. | America | http://trove.nla.gov.au/newspaper/page/24096181 | 24096181 | |
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 | |
54585 | 54585 | 1934-10-06 | 6 | a | A terrible scene of the future war. | Britain | http://trove.nla.gov.au/newspaper/page/24096186 | 24096186 | |
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 | |
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 | |
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 | |
54576 | 54576 | 1934-10-06 | 3 | c | Chinese immigrants are beaten in Japan. | China | http://trove.nla.gov.au/newspaper/page/24096181 | 24096181 | |
54570 | 54570 | 1934-10-06 | 2 | d | Drought and floods in China. | China | http://trove.nla.gov.au/newspaper/page/24096182 | 24096182 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
54578 | 54578 | 1934-10-06 | 3 | f | Graduation means unemployment in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24096181 | 24096181 |
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]);