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 | |
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 | |
54262 | 54262 | 1934-06-30 | 2 | e | Aviation industry in Guangxi. | China | http://trove.nla.gov.au/newspaper/page/24096068 | 24096068 | |
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 | |
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 | |
54260 | 54260 | 1934-06-30 | 2 | c | Feng Yuxiang in Shandong. | China | http://trove.nla.gov.au/newspaper/page/24096068 | 24096068 | |
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 | |
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 | |
54263 | 54263 | 1934-06-30 | 3 | a | Japanese governor of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096067 | 24096067 | |
54269 | 54269 | 1934-06-30 | 6 | a | Japanese navy on exercise. | Japan | http://trove.nla.gov.au/newspaper/page/24096072 | 24096072 | |
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 | |
54266 | 54266 | 1934-06-30 | 3 | e | Ma Zhanshan arrives Nanjing. | 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 | |
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 | |
54271 | 54271 | 1934-06-30 | 6 | c | Religious rites in India. | Other... | http://trove.nla.gov.au/newspaper/page/24096072 | 24096072 | |
54274 | 54274 | 1934-06-30 | 6 | e | The war in South America. | South America | 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]);