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 |
---|---|---|---|---|---|---|---|---|---|
54259 | 54259 | 1934-06-30 | 2 | a | Another comments on the diplomacy in north and south China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096068 | 24096068 | |
54263 | 54263 | 1934-06-30 | 3 | a | Japanese governor of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096067 | 24096067 | |
54267 | 54267 | 1934-06-30 | 5 | a | Pilgrim to the Miaofeng Mountain near Beijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096070 | 24096070 | |
54269 | 54269 | 1934-06-30 | 6 | a | Japanese navy on exercise. | Japan | http://trove.nla.gov.au/newspaper/page/24096072 | 24096072 | |
54270 | 54270 | 1934-06-30 | 6 | a | Bandits in the Yellow River hijack British ship. | China | http://trove.nla.gov.au/newspaper/page/24096072 | 24096072 | |
54268 | 54268 | 1934-06-30 | 7-8 | a-f | Guangdong news/ Jiang Jieshi moves more troops to Fujian. Overseas Chinese delegation to visit Guizhou. Commercial chamber in Guangzhou organised delegation to visit Australia. Business in Hong Kong. Sale of Chinese silk in Shantou. Drama performance in Guangdong. The summer in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24096071 | 24096071 | |
54260 | 54260 | 1934-06-30 | 2 | c | Feng Yuxiang in Shandong. | China | http://trove.nla.gov.au/newspaper/page/24096068 | 24096068 | |
54264 | 54264 | 1934-06-30 | 3 | c | League of Nations discusses the drug problems in China. | Other... | http://trove.nla.gov.au/newspaper/page/24096067 | 24096067 | |
54271 | 54271 | 1934-06-30 | 6 | c | Religious rites in India. | Other... | http://trove.nla.gov.au/newspaper/page/24096072 | 24096072 | |
54261 | 54261 | 1934-06-30 | 2 | d | Japan seeks economic cooperation with China. | China | http://trove.nla.gov.au/newspaper/page/24096068 | 24096068 | |
54265 | 54265 | 1934-06-30 | 3 | d | Japanese cabinet reviews its China policy. | Japan | http://trove.nla.gov.au/newspaper/page/24096067 | 24096067 | |
54272 | 54272 | 1934-06-30 | 6 | d | Racial discrimination in America. | America | http://trove.nla.gov.au/newspaper/page/24096072 | 24096072 | |
54273 | 54273 | 1934-06-30 | 6 | d | Relations between Russia and Japan. | China | http://trove.nla.gov.au/newspaper/page/24096072 | 24096072 | |
54262 | 54262 | 1934-06-30 | 2 | e | Aviation industry in Guangxi. | China | http://trove.nla.gov.au/newspaper/page/24096068 | 24096068 | |
54266 | 54266 | 1934-06-30 | 3 | e | Ma Zhanshan arrives Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24096067 | 24096067 | |
54274 | 54274 | 1934-06-30 | 6 | e | The war in South America. | South America | http://trove.nla.gov.au/newspaper/page/24096072 | 24096072 | |
54275 | 54275 | 1934-06-30 | 6 | e | Chinese man arrested in Fiji for opium smuggling. | Other... | http://trove.nla.gov.au/newspaper/page/24096072 | 24096072 | |
54276 | 54276 | 1934-06-30 | 6 | f | Australia news/ Heavy tax in Australia. Shops are required to follow price regulations for tobacco products. Prosperous market for tobacco. New methods to pay the personal income tax. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096072 | 24096072 |
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]);