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 |
|---|---|---|---|---|---|---|---|---|---|
| 48197 | 48197 | 1929-06-15 | 2 | b | Go along with or against the world trends, second part of comments by the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099248 | 24099248 | |
| 48198 | 48198 | 1929-06-15 | 2 | d | The Outer Mongolia under the control of Soviet Russia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099248 | 24099248 | |
| 48199 | 48199 | 1929-06-15 | 2 | d | The Central Government Troops (zhong yang jun) suddenly move to Wuhan. Nanjing government dispatches more troops to aid Guangdong in their attack on Guangxi. Zhang Xueliang dispatches his troops to enter Shanhaiguan. An explanation by the foreign minister Wang Chonghui for the taking over of the provisional court in the Shanghai international concessions. Chu Yupu surrenders to Liu Zhennian. Wang Jingwei will not return to China at the moment. He Yingqing arrives Hankou. Dr Chen Huanzhang is returning to China from America. | China | http://trove.nla.gov.au/newspaper/page/24099248 | 24099248 | |
| 48200 | 48200 | 1929-06-15 | 3 | a | An exhibition of products from Sichuan and Xikang. | China | http://trove.nla.gov.au/newspaper/page/24099247 | 24099247 | |
| 48201 | 48201 | 1929-06-15 | 3 | b | People in Jilin province urge the government to take back the railways. | China | http://trove.nla.gov.au/newspaper/page/24099247 | 24099247 | |
| 48202 | 48202 | 1929-06-15 | 3 | c | Chinese foreign ministry delivers diplomatic note to British, American, French and Dutch missions in China for the taking back of consular jurisdiction. | China | http://trove.nla.gov.au/newspaper/page/24099247 | 24099247 | |
| 48203 | 48203 | 1929-06-15 | 3 | e | Detailed report on the fire in Hangzhou. | China | http://trove.nla.gov.au/newspaper/page/24099247 | 24099247 | |
| 48204 | 48204 | 1929-06-15 | 5 | a | Hong Kong news/ Guangxi military commanders Hu Zongduo, Tao Jun and Xia Wei arrive Hong Kong by French liner. Key Party and military figures gather in Hong Kong hotels. Passenger liner from Hong Kong to Wuzhou is shot by government troops. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099249 | 24099249 | |
| 48205 | 48205 | 1929-06-15 | 5 | b | Woman Liang Muzheng saves her husband. A case of rape in Changzhou, Jiangsu province. A family tragedy in Guangzhou. A man in Guangzhou makes money from his three daughters. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099249 | 24099249 | |
| 48206 | 48206 | 1929-06-15 | 6-7 | a-d | Guangdong news/ Attitude of the navy on the arrival of military conflicts. Recent manoeuvre of the naval forces in Guangdong. Military news from Dongjiang area. Commercial chambers in Qujiang county requests to abolish some exorbitant taxes. Surtax collected for medical cream in Panyu county. Sand land farmers from Xinhui county submit their petition to the provincial authority. Labour disputes of the Xinning railway line. People in Taishan oppose to the road projects. Bandit chieftain Liang Xifen is arrested. Road project in Zhaoqing completed. Bandits in Shunde county attack government troops. Floods in Shilong town, of Dongguan. Model county Zhongshan to organise a public security unit. | China | http://trove.nla.gov.au/newspaper/page/24099252 | 24099252 | |
| 48207 | 48207 | 1929-06-15 | 8 | a | Deterioration of the diplomatic relations between China and Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24099254 | 24099254 | |
| 48208 | 48208 | 1929-06-15 | 8 | a | Documents seized from the Soviet Russian consulate in Harbin. | China | http://trove.nla.gov.au/newspaper/page/24099254 | 24099254 | |
| 48209 | 48209 | 1929-06-15 | 8 | a | Water shortage in Hong Kong. | Canada | http://trove.nla.gov.au/newspaper/page/24099254 | 24099254 | |
| 48210 | 48210 | 1929-06-15 | 8 | a-c | Australia news/ Limit for the use of gas in Sydney. Coal miners on strike in New South Wales. Opium smugglers detained in Sydney. Amount of rice produced in New South Wales this year. A man is punished for speeding. Telephone company in Sydney sacks an employee for illegally installing telephone machine for customer. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099254 | 24099254 |
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]);