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 |
---|---|---|---|---|---|---|---|---|---|
48497 | 48497 | 1929-09-28 | 3 | a | Natural and man-made calamities in Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24099372 | 24099372 | |
48498 | 48498 | 1929-09-28 | 3 | a | Britain and Egypt sign an agreement on the independence and the consular jurisdiction. | Britain | http://trove.nla.gov.au/newspaper/page/24099372 | 24099372 | |
48499 | 48499 | 1929-09-28 | 3 | b | Soviet Russia seeks to control Xinjiang, Northwest of China. | China | http://trove.nla.gov.au/newspaper/page/24099372 | 24099372 | |
48500 | 48500 | 1929-09-28 | 3 | b | Chinese delegation at the international labour conference and their proposals. | China | http://trove.nla.gov.au/newspaper/page/24099372 | 24099372 | |
48501 | 48501 | 1929-09-28 | 3 | e | Troops in Sichuan province and their mutiny. | China | http://trove.nla.gov.au/newspaper/page/24099372 | 24099372 | |
48491 | 48491 | 1929-09-28 | 2 | b | Third part of comments written by Shun Sheng says that China could not rely on foreign support. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099373 | 24099373 | |
48492 | 48492 | 1929-09-28 | 2 | c | The war in Kunming, Yunnan province. | China | http://trove.nla.gov.au/newspaper/page/24099373 | 24099373 | |
48493 | 48493 | 1929-09-28 | 2 | d | Chen Siheng, member of the Executive Nationalist Committee in Donghai county, Jiangsu province, and Zhang Jinshu, chairman of the labour union, are arrested and executed and the report. | China | http://trove.nla.gov.au/newspaper/page/24099373 | 24099373 | |
48494 | 48494 | 1929-09-28 | 2 | e | Businessmen in Fujian province resume their business activities and the report. | China | http://trove.nla.gov.au/newspaper/page/24099373 | 24099373 | |
48495 | 48495 | 1929-09-28 | 2 | f | Progress of the Longhai Railway project in China. | China | http://trove.nla.gov.au/newspaper/page/24099373 | 24099373 | |
48496 | 48496 | 1929-09-28 | 2 | f | A talk between Japan and Russia over the railways in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24099373 | 24099373 | |
48502 | 48502 | 1929-09-28 | 5 | a | Guangdong news/ Typhoon in the Xijiang area, Guangdong, and the damages. | China | http://trove.nla.gov.au/newspaper/page/24099374 | 24099374 | |
48503 | 48503 | 1929-09-28 | 5 | e | A notice issued by the Chinese Consulate-General in Australia says their main office would be moved from Melbourne to Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099374 | 24099374 | |
48504 | 48504 | 1929-09-28 | 6-7 | a-d | Guangdong news/ Retired servicemen commit robbery in Guangzhou. A meeting of restaurateurs in Guangzhou and their petitions. Guangdong commercial chambers appeals for abolition of some levies. Butchers reopen their shops following the abolition of some special taxes. Proposal to collect special tax on flour. Bandits collect ransom in the victim's house. A woman in Guangzhou beat her sister-in-law. Commercial chambers in Shilong town complain about exorbitant taxes. A loose woman in Zhongshan county marries a mad man. A man in Foshan is sentenced to imprisonment for beating his mother. Bandit chieftain executed on the site in Shunde county. A case of rape in Xinhui and the compensation. Epidemic disease in Xinhui county. Man women are prostitutes in Jiujiang. Two cases of suicide in Xinhui. Bandits in Xinxing county. | China | http://trove.nla.gov.au/newspaper/page/24099377 | 24099377 | |
48505 | 48505 | 1929-09-28 | 8 | c | Russian authority dispatches more troops to the border with China. | China | http://trove.nla.gov.au/newspaper/page/24099379 | 24099379 | |
48506 | 48506 | 1929-09-28 | 8 | c | Female pirates hijack Japanese ship near Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099379 | 24099379 | |
48507 | 48507 | 1929-09-28 | 8 | c | Russian immigrants are detained in Vancouver, Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24099379 | 24099379 | |
48508 | 48508 | 1929-09-28 | 8 | d | American coast guards detain British ship for illegal wines. | America | http://trove.nla.gov.au/newspaper/page/24099379 | 24099379 | |
48509 | 48509 | 1929-09-28 | 8 | d | Zhang Fakui defects Jiang Jieshi and the reason. | China | http://trove.nla.gov.au/newspaper/page/24099379 | 24099379 | |
48510 | 48510 | 1929-09-28 | 8 | d | Man-made fog in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24099379 | 24099379 | |
48511 | 48511 | 1929-09-28 | 8 | e | Miscellaneous report on the coming military conflict between Russia and China. | China | http://trove.nla.gov.au/newspaper/page/24099379 | 24099379 | |
48512 | 48512 | 1929-09-28 | 8 | f | Australia news/ Agricultural authority issues new regulations on fruit sales. A mad man makes trouble in a train. Drunken policeman directs traffic in Sydney and is punished. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099379 | 24099379 |
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]);