This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49194 | 49194 | 1930-05-31 | 2 | d | War clouds in Sichuan province. Zhang Zongchang seeks another opportunity. War planes leave Nanjing with gas bombs. Shi Yousan arrests envoy of Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24099651 | 24099651 | |
49195 | 49195 | 1930-05-31 | 2 | d | Amount of Boxer Indemnity refunded by Britain. Russian troops in Manchuria. Loss of China during the conflict with Russian. Yan Xishan to appoint Yan Huiqing foreign minister. Yan Xishan sets up banks. Nearly 1 million troops are against Jiang Jieshi. Telegram from Zou Lu and Xie Chi to Tan Zhen. Reply from Wang Jingwei to Yan Xishan. Jiang Jieshi to review his troops in the north. Jiang Jieshi goes to Xuzhou to review his troops personally. Nanjing troops are ready to fight. | China | http://trove.nla.gov.au/newspaper/page/24099651 | 24099651 | |
49199 | 49199 | 1930-05-31 | 3 | d | Japanese are preparing for a large-scale invasion into the Manchuria of China. | China | http://trove.nla.gov.au/newspaper/page/24099650 | 24099650 | |
49202 | 49202 | 1930-05-31 | 5 | d | Court judge falls in love with the woman who applies for divorce. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099652 | 24099652 | |
49203 | 49203 | 1930-05-31 | 5 | d | Acknowledgement issued by Huang Qiming, principal of the Peizheng School in Guangzhou for the donations from Chinese communities in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099652 | 24099652 | |
49205 | 49205 | 1930-05-31 | 8 | d | Communists in Jiangxi province murder three foreign missionaries. | China | http://trove.nla.gov.au/newspaper/page/24099657 | 24099657 | |
49206 | 49206 | 1930-05-31 | 8 | d | Number of people killed in car accident in America. | America | http://trove.nla.gov.au/newspaper/page/24099657 | 24099657 | |
49207 | 49207 | 1930-05-31 | 8 | d | Feng Yuxiang personally supervise his troops. | China | http://trove.nla.gov.au/newspaper/page/24099657 | 24099657 | |
49208 | 49208 | 1930-05-31 | 8 | d | A cargo ship on fire in Honolulu. | America | http://trove.nla.gov.au/newspaper/page/24099657 | 24099657 | |
49209 | 49209 | 1930-05-31 | 8 | d | Troops from the north win over Jiang Jieshi's army. | China | http://trove.nla.gov.au/newspaper/page/24099657 | 24099657 | |
49210 | 49210 | 1930-05-31 | 8 | d | Chaos in India. | Other... | http://trove.nla.gov.au/newspaper/page/24099657 | 24099657 |
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]);