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 |
|---|---|---|---|---|---|---|---|---|---|
| 54128 | 54128 | 1934-05-12 | 2 | a | First part of comments on the constitution and the constitutional politics in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096010 | 24096010 | |
| 54129 | 54129 | 1934-05-12 | 2 | b | China news/ The southwest of China will be under the command of the Central government in Nanjing. The fifth part of the draft constitution of the Republic of China. Jiang Jieshi on the selection and appointment of local administrators. Wang Jingwei and Jiang Jieshi write to Chen Jitang on the reform of provincial system. | China | http://trove.nla.gov.au/newspaper/page/24096010 | 24096010 | |
| 54130 | 54130 | 1934-05-12 | 3 | a | Envoy of Xinjiang government Wu Aichen talks in Beijing about the Xinjiang issues. | China | http://trove.nla.gov.au/newspaper/page/24096009 | 24096009 | |
| 54131 | 54131 | 1934-05-12 | 3 | b | Japanese attitude towards the military existence of Soviet Russia in the Far East. | China | http://trove.nla.gov.au/newspaper/page/24096009 | 24096009 | |
| 54132 | 54132 | 1934-05-12 | 3 | b | Political parties in the Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24096009 | 24096009 | |
| 54133 | 54133 | 1934-05-12 | 3 | d | Russian ambassador in Washington on the war between Japan and Russia. | America | http://trove.nla.gov.au/newspaper/page/24096009 | 24096009 | |
| 54134 | 54134 | 1934-05-12 | 3 | d | The communist activists in American navy. | America | http://trove.nla.gov.au/newspaper/page/24096009 | 24096009 | |
| 54135 | 54135 | 1934-05-12 | 3 | e | The independence of the Philippines from America. | America | http://trove.nla.gov.au/newspaper/page/24096009 | 24096009 | |
| 54136 | 54136 | 1934-05-12 | 3 | e | Zhang Xiaoxu in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096009 | 24096009 | |
| 54137 | 54137 | 1934-05-12 | 5 | a | Massage in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096011 | 24096011 | |
| 54138 | 54138 | 1934-05-12 | 5 | d | On the novel Dream in the Red Chamber (hong lou meng). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096011 | 24096011 | |
| 54139 | 54139 | 1934-05-12 | 5 | f | Tibet welcomes the return of a living Buddha. | China | http://trove.nla.gov.au/newspaper/page/24096011 | 24096011 | |
| 54140 | 54140 | 1934-05-12 | 7-8 | a-f | Guangdong news/ Fighting with the communist troops in the east of Guangdong. Provincial governor Huang Xuchu and his policy. Building of the railway from Guangzhou to Hankou. Provincial authority welcomes living Buddha from Tibet. Business recovery in Hong Kong and Guangdong. Japanese goods in Hong Kong market and the competition with British goods. Girl in Zhongshan county murders her mother. Properties of the Confucian Temple in Taishan. A man in Nanhai has four wives. | China | http://trove.nla.gov.au/newspaper/page/24096013 | 24096013 | |
| 54141 | 54141 | 1934-05-12 | 6 | a | Chinese consul-general in Paris talks about Japanese invasion. | France | http://trove.nla.gov.au/newspaper/page/24096014 | 24096014 | |
| 54142 | 54142 | 1934-05-12 | 6 | a | Lottery in China. | China | http://trove.nla.gov.au/newspaper/page/24096014 | 24096014 | |
| 54143 | 54143 | 1934-05-12 | 6 | b | Council of legislature in Nanjing meets to discuss Japan policy. | China | http://trove.nla.gov.au/newspaper/page/24096014 | 24096014 | |
| 54144 | 54144 | 1934-05-12 | 6 | c | Japanese cabinet on their Far East policy. | Japan | http://trove.nla.gov.au/newspaper/page/24096014 | 24096014 | |
| 54145 | 54145 | 1934-05-12 | 6 | c | Puppet Manchurian state seeks alliance with Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24096014 | 24096014 | |
| 54146 | 54146 | 1934-05-12 | 6 | d | The air forces of Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24096014 | 24096014 | |
| 54147 | 54147 | 1934-05-12 | 6 | e | Australia news/ Trade statistics between China and Australia in the past six years. Bandits fail to rob treasury of the Sydney city council. Visitor talks about modern China on his return. Chinese government entertains Australian trade commissioner. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096014 | 24096014 |
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]);