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 |
---|---|---|---|---|---|---|---|---|---|
54272 | 54272 | 1934-06-30 | 6 | d | Racial discrimination in America. | America | 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 | |
54261 | 54261 | 1934-06-30 | 2 | d | Japan seeks economic cooperation with China. | China | http://trove.nla.gov.au/newspaper/page/24096068 | 24096068 | |
54262 | 54262 | 1934-06-30 | 2 | e | Aviation industry in Guangxi. | China | 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 | |
54266 | 54266 | 1934-06-30 | 3 | e | Ma Zhanshan arrives Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24096067 | 24096067 | |
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 | |
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 | |
54273 | 54273 | 1934-06-30 | 6 | d | Relations between Russia and Japan. | China | http://trove.nla.gov.au/newspaper/page/24096072 | 24096072 | |
54265 | 54265 | 1934-06-30 | 3 | d | Japanese cabinet reviews its China policy. | Japan | 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 | |
54271 | 54271 | 1934-06-30 | 6 | c | Religious rites in India. | Other... | 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 | |
54274 | 54274 | 1934-06-30 | 6 | e | The war in South America. | South America | http://trove.nla.gov.au/newspaper/page/24096072 | 24096072 | |
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 | |
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 | |
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]);