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 |
---|---|---|---|---|---|---|---|---|---|
42899 | 42899 | 1925-03-28 | 2 | a-b | The end of Sun Yatsen, editorial by the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101078 | 24101078 | |
42900 | 42900 | 1925-03-28 | 2 | b-c | Second and final part of a report on the national congress in Beijing (shan hou hui yi) to deal with the aftermath. Statement issued by the conference. | China | http://trove.nla.gov.au/newspaper/page/24101078 | 24101078 | |
42901 | 42901 | 1925-03-28 | 2 | c-d | Wu Peifu in the new year. | China | http://trove.nla.gov.au/newspaper/page/24101078 | 24101078 | |
42902 | 42902 | 1925-03-28 | 2-3 | d-a | Xiao Yaonan bans the Guomindang and other political activists in Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24101078 | 24101078 | |
42903 | 42903 | 1925-03-28 | 3 | a | Chinese government and the outer Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24101077 | 24101077 | |
42904 | 42904 | 1925-03-28 | 3 | a-b | Chinese government regains the submarine cable in Qingdao, of Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24101077 | 24101077 | |
42905 | 42905 | 1925-03-28 | 3 | b | National Road Transportation Association in China suggests to disband some armies for road construction. | China | http://trove.nla.gov.au/newspaper/page/24101077 | 24101077 | |
42906 | 42906 | 1925-03-28 | 3 | c | Duan Qirui talks to some Nationalist Party (Guomindang) members in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101077 | 24101077 | |
42907 | 42907 | 1925-03-28 | 3 | c | American naval fleet on the way to visit Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24101077 | 24101077 | |
42908 | 42908 | 1925-03-28 | 3 | c-d | Relation between Japan and American improves. | America | http://trove.nla.gov.au/newspaper/page/24101077 | 24101077 | |
42909 | 42909 | 1925-03-28 | 3 | d | A coal mine explodes in the west of Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24101077 | 24101077 | |
42910 | 42910 | 1925-03-28 | 3 | d | A failed attempt to assassinate leader of Soviet Russia. | Other... | http://trove.nla.gov.au/newspaper/page/24101077 | 24101077 | |
42911 | 42911 | 1925-03-28 | 3 | d | Famine in Russia and the casualties. | Britain | http://trove.nla.gov.au/newspaper/page/24101077 | 24101077 | |
42912 | 42912 | 1925-03-28 | 3 | d-e | King of Britain to visit France. | Britain | http://trove.nla.gov.au/newspaper/page/24101077 | 24101077 | |
42913 | 42913 | 1925-03-28 | 3 | e | Russian embassy in Paris lose classified documents. | Britain | http://trove.nla.gov.au/newspaper/page/24101077 | 24101077 | |
42914 | 42914 | 1925-03-28 | 3 | e-f | Fire in Tokyo and the casualties. | Japan | http://trove.nla.gov.au/newspaper/page/24101077 | 24101077 | |
42915 | 42915 | 1925-03-28 | 3 | e | Flood in Peru. | Canada | http://trove.nla.gov.au/newspaper/page/24101077 | 24101077 | |
42916 | 42916 | 1925-03-28 | 3 | e | Storm in the west of America. | America | http://trove.nla.gov.au/newspaper/page/24101077 | 24101077 | |
42917 | 42917 | 1925-03-28 | 3 | e-f | Earthquake in Yunnan province, China. | China | http://trove.nla.gov.au/newspaper/page/24101077 | 24101077 | |
42918 | 42918 | 1925-03-28 | 3 | f | Remains of Sun Yatsen is transferred to the Central Park in Beijing and the ceremony. Christian funeral is under preparation. | China | http://trove.nla.gov.au/newspaper/page/24101077 | 24101077 | |
42919 | 42919 | 1925-03-28 | 5 | a-c | Articles written by anonymous authors condemn Huang Laiwang, Liu Boming, Xu Richu, and other Nationalist Party (Guomindang) members in Sydney and their radical propaganda. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101079 | 24101079 | |
42920 | 42920 | 1925-03-28 | 6 | a-c | Draft statement of the national congress (shan hou hui yi) in Beijing and its solutions. | China | http://trove.nla.gov.au/newspaper/page/24101082 | 24101082 | |
42921 | 42921 | 1925-03-28 | 6 | c-d | Article written by anonymous author condemns the Nationalist Party (Guomindang) members in Sydney and their radical propaganda. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101082 | 24101082 | |
42922 | 42922 | 1925-03-28 | 7 | a | Australia's trade with Germany and the statistics on import and export. | Australia | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42923 | 42923 | 1925-03-28 | 7 | a | Population increases in New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42924 | 42924 | 1925-03-28 | 7 | a | Italian consul in Australia suggests to accept more immigrants. | Australia | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42925 | 42925 | 1925-03-28 | 7 | a | Quarrel between Chinese shop owner and white customer in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42926 | 42926 | 1925-03-28 | 7 | a | An old couple is crushed to death in a traffic accident in Parramatta, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42927 | 42927 | 1925-03-28 | 7 | a-b | Chinese Chamber of Commerce in Sydney gathers to congratulate their new board directors. Speakers include Su Yiguang, Wu Zhaoquan, Zhu Songqing, Chen Qingyi, Guo Jianying, Zheng Fanchang, Pan Yonghan, Liu Junchen, Wu Elou, Guo Jiexiu, Zhang Fu, Chen Zanhua, Lin Run, and Liu Guangfu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42928 | 42928 | 1925-03-28 | 7 | c | A Chinese wedding in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42929 | 42929 | 1925-03-28 | 7 | c | Korean people attack Japanese police bureau in the north of Korea. | Japan | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42930 | 42930 | 1925-03-28 | 7 | c | International peace conference to be held in San Francisco in 1926. | America | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42931 | 42931 | 1925-03-28 | 7 | c | Bandits in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42932 | 42932 | 1925-03-28 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42933 | 42933 | 1925-03-28 | 8 | a-d | Guangdong news/ Hu Hanmin borrows loans from Japan. Sun Yatsen's government and their censorship on freedom of speech. Hu Sishun orders his troops back from Dongjiang. Li Jishen sends his troops to collect levy. Han Youze declines to the post of magistrate in Boluo county. More Sun Yatsen's soldier desert. People in Xiangshan county complains the local bureaucracy. Robbery in Xiangshan county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101084 | 24101084 | |
42934 | 42934 | 1925-03-28 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101084 | 24101084 | |
42935 | 42935 | 1925-03-28 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101084 | 24101084 |
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]);