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 |
---|---|---|---|---|---|---|---|---|---|
53982 | 53982 | 1934-03-24 | 2 | a | Editorial on the future of Chinese national heroes. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091573 | 24091573 | |
53987 | 53987 | 1934-03-24 | 3 | a | Fu Zuoyi returns to commander his troops in Suiyuan. | China | http://trove.nla.gov.au/newspaper/page/24091572 | 24091572 | |
53988 | 53988 | 1934-03-24 | 3 | a | Japanese goods on the Beijing market. | China | http://trove.nla.gov.au/newspaper/page/24091572 | 24091572 | |
53997 | 53997 | 1934-03-24 | 5 | a | Feng Yuxiang and his hobby. | China | http://trove.nla.gov.au/newspaper/page/24091574 | 24091574 | |
54002 | 54002 | 1934-03-24 | 6 | a | Chinese man in Singapore shoots dead police officer. | Singapore | http://trove.nla.gov.au/newspaper/page/24091577 | 24091577 | |
54003 | 54003 | 1934-03-24 | 6 | a | Japanese and the naval port in Singapore. | Japan | http://trove.nla.gov.au/newspaper/page/24091577 | 24091577 | |
54001 | 54001 | 1934-03-24 | 7-8 | a-f | Guangdong news/ Reform of the provincial administration and the candidates for governor. The whereabouts of Cai Tingkai. Reform of provincial administration and the Party affairs. The Guangzhou market during the Chinese New Year. All civilians are required to register. The business in Guangzhou last year. Grain supply in the coming Spring. Bandit chieftain arrested in Enping. Clan clashes in Shunde. | China | http://trove.nla.gov.au/newspaper/page/24091576 | 24091576 | |
53983 | 53983 | 1934-03-24 | 2 | b | Zhang Xueliang arrives Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24091573 | 24091573 | |
53989 | 53989 | 1934-03-24 | 3 | b | Yan Huiqing talks on his arrival in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24091572 | 24091572 | |
53998 | 53998 | 1934-03-24 | 5 | b | A delegation of Chinese businessmen from Hong Kong comes to visit Australia and the first part of the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091574 | 24091574 | |
53984 | 53984 | 1934-03-24 | 2 | c | Bank of Anhui is closed down. | China | http://trove.nla.gov.au/newspaper/page/24091573 | 24091573 | |
53985 | 53985 | 1934-03-24 | 2 | c | Murderer of Li Minzhou, manager of the Sun Sun Company in Shanghai, is sentenced to life imprisonment. | China | http://trove.nla.gov.au/newspaper/page/24091573 | 24091573 | |
53986 | 53986 | 1934-03-24 | 2 | c | China news/ Sichuan troops join to suppress the communists. Battle in the south of Xinjiang. Guangxi provincial authority trains county magistrates. The autonomous administration in Mongolia. Japanese ambassador meets Wang Jingwei. | China | http://trove.nla.gov.au/newspaper/page/24091573 | 24091573 | |
53990 | 53990 | 1934-03-24 | 3 | c | Japanese administration of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091572 | 24091572 | |
53999 | 53999 | 1934-03-24 | 5 | c | A speech by Kuang Fuzhuo at the Sydney Chinese Baptism Church. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091574 | 24091574 | |
53991 | 53991 | 1934-03-24 | 3 | d | American navy and airforce troops have joint exercise. | America | http://trove.nla.gov.au/newspaper/page/24091572 | 24091572 | |
54004 | 54004 | 1934-03-24 | 6 | d | Rebellion of Muslims in Xinjiang. | Russia | http://trove.nla.gov.au/newspaper/page/24091577 | 24091577 | |
53992 | 53992 | 1934-03-24 | 3 | e | China and Britain sign nonaggression treaty. | China | http://trove.nla.gov.au/newspaper/page/24091572 | 24091572 | |
53993 | 53993 | 1934-03-24 | 3 | e | Political chaos in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24091572 | 24091572 | |
53994 | 53994 | 1934-03-24 | 3 | e | Recent relations between Russia and Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24091572 | 24091572 | |
54000 | 54000 | 1934-03-24 | 5 | e | Jiang Hua, a Chinese man in Sydney, claims that Chen Shaokuan should be the No. 1 Criminal in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091574 | 24091574 | |
54005 | 54005 | 1934-03-24 | 6 | e | Australia news/ Royal Agricultural Show to be opened in time. Australian trade delegation on the war to visit the Far East. Storm in Cairns, Queensland. Theft and robbery in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091577 | 24091577 | |
53995 | 53995 | 1934-03-24 | 3 | f | Japanese are building airports in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091572 | 24091572 | |
53996 | 53996 | 1934-03-24 | 3 | f | American government maintain the silver price. | America | http://trove.nla.gov.au/newspaper/page/24091572 | 24091572 |
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]);