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 | |
| 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 | |
| 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 | |
| 54265 | 54265 | 1934-06-30 | 3 | d | Japanese cabinet reviews its China policy. | Japan | 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 | |
| 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 | |
| 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 | |
| 54271 | 54271 | 1934-06-30 | 6 | c | Religious rites in India. | Other... | http://trove.nla.gov.au/newspaper/page/24096072 | 24096072 | |
| 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 | |
| 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]);