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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);