This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id
Link | rowid | date | page | column ▼ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41330 | 41330 | 1924-03-29 | 3 | a | An attempt to assassinate Governor Zhao Hengti in Hunan and the investigation. | China | http://trove.nla.gov.au/newspaper/page/24100663 | 24100663 | |
41342 | 41342 | 1924-03-29 | 7 | a | Australian federal government to sink one of the warships. | Australia | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41343 | 41343 | 1924-03-29 | 7 | a | Chinese Consulate General in Melbourne has a new office manager, Qu Sunyi, who is arriving in Sydney from China, and his background. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41320 | 41320 | 1924-03-29 | 2 | a-b | Sun Yatsen detains the magistrate of Heshan county and comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100664 | 24100664 | |
41339 | 41339 | 1924-03-29 | 6 | a-b | A letter from Ling Ji, manager of the Bank of China in Guangzhou, to Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24100668 | 24100668 | |
41344 | 41344 | 1924-03-29 | 7 | a-b | The Sydney pianist is sentenced to death for murdering his three daughters. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41354 | 41354 | 1924-03-29 | 8 | a-d | Guangdong news/ Provincial governor tries to pacify the agitation of the rice market in Guangzhou. Rice price goes down. A notice by the Commercial Chamber in Guangzhou on the issue of shoupiao. The shoupiao issued by charity institutions in Guangzhou. Leaflets and the memory service in Guangzhou for Lenin. Shop owners in Macao close their business for a strike. Huang Shaoxiong in Wuzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100670 | 24100670 | |
41331 | 41331 | 1924-03-29 | 3 | b | Support and opposition to the election of Chinese Deputy President in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100663 | 24100663 | |
41332 | 41332 | 1924-03-29 | 3 | b | The case of gold Franc will be heard by an international tribunal. | China | http://trove.nla.gov.au/newspaper/page/24100663 | 24100663 | |
41321 | 41321 | 1924-03-29 | 2 | b-c | Members of national parliament in Beijing campaign for revision of the Constitution. | China | http://trove.nla.gov.au/newspaper/page/24100664 | 24100664 | |
41333 | 41333 | 1924-03-29 | 3 | b-c | American businessmen gather in New York and will help silk industry in China. | America | http://trove.nla.gov.au/newspaper/page/24100663 | 24100663 | |
41340 | 41340 | 1924-03-29 | 6 | b-d | Li Liejun on Sun Yatsen, Sun Ke and the communist experiment in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24100668 | 24100668 | |
41322 | 41322 | 1924-03-29 | 2 | c | Sun Yatsen sends envoys to seek recognition of his southern government by foreign powers. | China | http://trove.nla.gov.au/newspaper/page/24100664 | 24100664 | |
41323 | 41323 | 1924-03-29 | 2 | c | Beijing government to have a meeting on the Guangdong issues. | China | http://trove.nla.gov.au/newspaper/page/24100664 | 24100664 | |
41345 | 41345 | 1924-03-29 | 7 | c | A man in Sydney is sentenced to seven years' imprisonment for fighting. | Australia | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41346 | 41346 | 1924-03-29 | 7 | c | A young woman in Sydney dies of abortion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41347 | 41347 | 1924-03-29 | 7 | c | Chinese market gardener Wu Zhen and his excellent performance in the agriculture show in Glen Innes. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41348 | 41348 | 1924-03-29 | 7 | c | Chinese football team to visit New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41324 | 41324 | 1924-03-29 | 2 | c-d | A survey on the debt that Beijing government owes to foreign countries (amount, name of country, and due date, etc). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100664 | 24100664 | |
41334 | 41334 | 1924-03-29 | 3 | c-d | Archaeologist in Gansu province, China, finds pottery and others belonging to the Yin and Shang dynasties. | China | http://trove.nla.gov.au/newspaper/page/24100663 | 24100663 | |
41335 | 41335 | 1924-03-29 | 3 | d | A Japanese submarine sinks after collision with a warship. | China | http://trove.nla.gov.au/newspaper/page/24100663 | 24100663 | |
41349 | 41349 | 1924-03-29 | 7 | d | Passengers of Lingnan, a liner of the Chungwah Navigation Company Ltd, write in praise of the service on board. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41325 | 41325 | 1924-03-29 | 2 | d-e | Beijing government, under premier Sun Baoqi, is to organise a tariff conference. | China | http://trove.nla.gov.au/newspaper/page/24100664 | 24100664 | |
41336 | 41336 | 1924-03-29 | 3 | d-e | China and Russia blame each other for the failure of treaty negotiation. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100663 | 24100663 | |
41341 | 41341 | 1924-03-29 | 6 | d-e | The Russian Communist (Bolshevik) after the death of Lenin. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100668 | 24100668 | |
41350 | 41350 | 1924-03-29 | 7 | d-e | Gong yi tang (The Dong Guan Goon Yee Tong) in Sydney is to set up a board and its notice for election of the board directors. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41326 | 41326 | 1924-03-29 | 2 | e | A telegram from the Beijing cabinet to Sun Yatsen in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24100664 | 24100664 | |
41327 | 41327 | 1924-03-29 | 2 | e | Chinese premier Sun Baoqi is keen to start peace talks with Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24100664 | 24100664 | |
41337 | 41337 | 1924-03-29 | 3 | e | Irish army fire at British soldiers and the casualties. | Britain | http://trove.nla.gov.au/newspaper/page/24100663 | 24100663 | |
41338 | 41338 | 1924-03-29 | 3 | e | American consul in Guangzhou asks for protection on behalf of American businessmen there. | America | http://trove.nla.gov.au/newspaper/page/24100663 | 24100663 | |
41351 | 41351 | 1924-03-29 | 7 | e | Farewell message by Chen Junle on his return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41355 | 41355 | 1924-03-29 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100670 | 24100670 | |
41356 | 41356 | 1924-03-29 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100670 | 24100670 | |
41328 | 41328 | 1924-03-29 | 2 | e-f | Duan Qirui delays his leaving for the south. | China | http://trove.nla.gov.au/newspaper/page/24100664 | 24100664 | |
41352 | 41352 | 1924-03-29 | 7 | f | Chinese immigrants in Samoa island write and thank Chinese consul Li Zhaosong for his great help. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41353 | 41353 | 1924-03-29 | 7 | f | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41329 | 41329 | 1924-03-29 | 2-3 | f-a | Dispute between Du Xigui and Wen Shude and the mediation effort. | China | http://trove.nla.gov.au/newspaper/page/24100664 | 24100664 |
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]);