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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
54162 | 54162 | 1934-05-19 | 6 | a | Lantern Festival and the parade in Nanjing. | Britain | 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 | |
54163 | 54163 | 1934-05-19 | 6 | c | Britain restricts import of Japanese cotton products. | Canada | http://trove.nla.gov.au/newspaper/page/24096022 | 24096022 | |
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 | |
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 | |
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 | |
54158 | 54158 | 1934-05-19 | 5 | c | Memorial statue for prostitute in Jiangmen. | China | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | ||
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 | |
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]);