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 |
|---|---|---|---|---|---|---|---|---|---|
| 54075 | 54075 | 1934-04-21 | 2 | a | Editorial on the status of Puyi. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095980 | 24095980 | |
| 54076 | 54076 | 1934-04-21 | 2 | b | China news/ Japanese troops continue to harass the north China. Second part of the draft constitution of Republic of China. Jiang Jieshi to convene a national conference on administrative reform. Zheng Xiaoxu on the way to Japan to sign treaty. Seventieth birthday of Duan Qirui. | China | http://trove.nla.gov.au/newspaper/page/24095980 | 24095980 | |
| 54077 | 54077 | 1934-04-21 | 3 | a | Sun Dianying vows to fight to the end. | China | http://trove.nla.gov.au/newspaper/page/24095979 | 24095979 | |
| 54078 | 54078 | 1934-04-21 | 3 | a | Japan and America start a secret talk. | Britain | http://trove.nla.gov.au/newspaper/page/24095979 | 24095979 | |
| 54079 | 54079 | 1934-04-21 | 3 | d | A city in Japan disappears after a fire. | Japan | http://trove.nla.gov.au/newspaper/page/24095979 | 24095979 | |
| 54080 | 54080 | 1934-04-21 | 5 | d | Women's bathroom in Beijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095987 | 24095987 | |
| 54081 | 54081 | 1934-04-21 | 5 | f | How much Japanese have secured from Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095987 | 24095987 | |
| 54082 | 54082 | 1934-04-21 | 7-8 | a-f | Guangdong news/ The Huangpu Navy School is managed by the Headquarters. Li Zongren leaves Nanning for Guangzhou. Cai Tingkai is going overseas. The Southwest authority requests the Nanjing government to investigate on the Chinese immigrants murdered in Thailand. Guangdong manufactures five aeroplanes. Candidate finalised for the provincial governor. New requirements for payment of land and security taxes in Guangzhou. Exhibition in Guangzhou of the air defence equipment. Tang Shaoyi requests to cancel the export tax of China products. Efforts to save business in Hong Kong. Registration of sand land. Fighting in Boluo between bandits and government troops. | China | http://trove.nla.gov.au/newspaper/page/24095989 | 24095989 | |
| 54083 | 54083 | 1934-04-21 | 6 | a | Russian plane saves sailors. | Russia | http://trove.nla.gov.au/newspaper/page/24095990 | 24095990 | |
| 54084 | 54084 | 1934-04-21 | 6 | a | Japanese defence minister resigns. | Japan | http://trove.nla.gov.au/newspaper/page/24095990 | 24095990 | |
| 54085 | 54085 | 1934-04-21 | 6 | a | Germany reorganises its military forces. | Britain | http://trove.nla.gov.au/newspaper/page/24095990 | 24095990 | |
| 54086 | 54086 | 1934-04-21 | 6 | c | Tibet to reduce its army numbers. | Other... | http://trove.nla.gov.au/newspaper/page/24095990 | 24095990 | |
| 54087 | 54087 | 1934-04-21 | 6 | c | Japanese pressure on China. | Japan | http://trove.nla.gov.au/newspaper/page/24095990 | 24095990 | |
| 54088 | 54088 | 1934-04-21 | 6 | d | Thailand government denies any cooperation with Japan for river project. | Other... | http://trove.nla.gov.au/newspaper/page/24095990 | 24095990 | |
| 54089 | 54089 | 1934-04-21 | 6 | d | Australia news/ Wool export increases. Japanese goods on the world market. Chinese communities in Sydney farewell Guo Jianying on his return to China. Two Chinese men in Sydney on trial for fighting. A Chinese man commits suicide in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095990 | 24095990 |
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]);