This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 |
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]);