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 |
---|---|---|---|---|---|---|---|---|---|
54148 | 54148 | 1934-05-19 | 2 | Second part of comments on the constitution and the constitutional politics in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096018 | 24096018 | ||
54149 | 54149 | 1934-05-19 | 2 | c | China news/ Remains of Sun Dianying's troops. Council of Legislature has a secret discussion on the north China issues. The sixth part of the draft constitution of the Republic of China. Chaos in Guizhou province end. Jiang Jieshi orders provinces to unify their financial management. | China | http://trove.nla.gov.au/newspaper/page/24096018 | 24096018 | |
54150 | 54150 | 1934-05-19 | 3 | a | Japanese invasion of Manchuria and north China and the resistance of Chinese troops. | China | http://trove.nla.gov.au/newspaper/page/24096017 | 24096017 | |
54151 | 54151 | 1934-05-19 | 3 | d | Russian foreign minister visits the League of Nations. | Other... | http://trove.nla.gov.au/newspaper/page/24096017 | 24096017 | |
54152 | 54152 | 1934-05-19 | 3 | e | Both Britain and America call for world peace. | Britain | http://trove.nla.gov.au/newspaper/page/24096017 | 24096017 | |
54153 | 54153 | 1934-05-19 | 3 | e | America prepares to deal with the military power of Japan. | China | http://trove.nla.gov.au/newspaper/page/24096017 | 24096017 | |
54154 | 54154 | 1934-05-19 | 3 | e | Chinese immigrants need guarantee before their entry into Brazil. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096017 | 24096017 | |
54155 | 54155 | 1934-05-19 | 3 | f | Chinese financial ministry to reform the currency system. | China | http://trove.nla.gov.au/newspaper/page/24096017 | 24096017 | |
54156 | 54156 | 1934-05-19 | 3 | g | Japanese immigration to Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096017 | 24096017 | |
54157 | 54157 | 1934-05-19 | 5 | a | Article by Deng Chumin on the Qingming Festival. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096019 | 24096019 | |
54158 | 54158 | 1934-05-19 | 5 | c | Memorial statue for prostitute in Jiangmen. | China | http://trove.nla.gov.au/newspaper/page/24096019 | 24096019 | |
54159 | 54159 | 1934-05-19 | 5 | e | Chinese communities in Wellington, New Zealand, donate to the Zhongshan University in Guangzhou and names listed. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096019 | 24096019 | |
54160 | 54160 | 1934-05-19 | 7-8 | a-f | Guangdong news/ The Southwest authority questions the central government in Nanjing on the crisis in north China. Talks by Cai Tingkai on his leaving for overseas. Three-year army farm in Guangdong. Businessmen returned from overseas are planning to set up glass factory in Guangzhou. Students of the Yao minority arrives Shaoguan. | China | http://trove.nla.gov.au/newspaper/page/24096021 | 24096021 | |
54161 | 54161 | 1934-05-19 | 6 | a | Outer Mongolia resists to the Japanese and Manchurian invasion. | China | http://trove.nla.gov.au/newspaper/page/24096022 | 24096022 | |
54162 | 54162 | 1934-05-19 | 6 | a | Lantern Festival and the parade in Nanjing. | Britain | http://trove.nla.gov.au/newspaper/page/24096022 | 24096022 | |
54163 | 54163 | 1934-05-19 | 6 | c | Britain restricts import of Japanese cotton products. | Canada | http://trove.nla.gov.au/newspaper/page/24096022 | 24096022 | |
54164 | 54164 | 1934-05-19 | 6 | d | Jiang Jieshi bans opium smoking. | China | http://trove.nla.gov.au/newspaper/page/24096022 | 24096022 | |
54165 | 54165 | 1934-05-19 | 6 | d | Chinese foreign minister Wang Zhengting talks with Japanese envoy on the crisis in north China. | China | http://trove.nla.gov.au/newspaper/page/24096022 | 24096022 | |
54166 | 54166 | 1934-05-19 | 6 | d | British newspaper on the war between Japan and Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24096022 | 24096022 | |
54167 | 54167 | 1934-05-19 | 6 | e | Chinese and Indian immigrants are fighting in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096022 | 24096022 | |
54168 | 54168 | 1934-05-19 | 6 | e | Competition between Chinese and Italian gardens in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096022 | 24096022 |
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]);