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 |
---|---|---|---|---|---|---|---|---|---|
39913 | 39913 | 1923-06-02 | 3 | a | House of Representatives in Beijing discusses the petition submitted by the northeastern people in Beijing and their protest against Japan. | China | http://trove.nla.gov.au/newspaper/page/24094423 | 24094423 | |
39925 | 39925 | 1923-06-02 | 7 | a | Decline of the shipping industry in Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24094427 | 24094427 | |
39926 | 39926 | 1923-06-02 | 7 | a | Tram in Sydney will operate for 48 hours a week and some employees will be sacked. | Australia | http://trove.nla.gov.au/newspaper/page/24094427 | 24094427 | |
39927 | 39927 | 1923-06-02 | 7 | a | A white woman in Pitt Street, Sydney, is penalised for selling wine illegally. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094427 | 24094427 | |
39928 | 39928 | 1923-06-02 | 7 | a | A slaughterhouse in Parramatta, Sydney, is on fire. | Australia | http://trove.nla.gov.au/newspaper/page/24094427 | 24094427 | |
39929 | 39929 | 1923-06-02 | 7 | a | Transportation development in Xiangshan county, Guangdong, and the fundraising in Australian Chinese communities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094427 | 24094427 | |
39923 | 39923 | 1923-06-02 | 6 | a-b | Commercial Chamber in Shanghai issues a circular telegram and appeal to abrogate the Twenty-one Demands. | China | http://trove.nla.gov.au/newspaper/page/24094428 | 24094428 | |
39910 | 39910 | 1923-06-02 | 2 | a-c | Editorial on the war in the call for disarmament in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094424 | 24094424 | |
39934 | 39934 | 1923-06-02 | 8 | a-d | Guangdong news/ Military situation in Guangdong. Sun Yatsen is to raise internal loans. Businessman to reconstruct the old Guangzhou army headquarters for commercial purpose. People in Nanhai county oppose to the reconstruction of the government building. Hong Kong businessmen are against the sale of farms in near Guangzhou. Liu Zhenhuan advises Sun Yatsen to continue the north expedition. Guangzhou students organise themselves to check forgery goods. Zhao Shibei suggests to collect cemetery tax. Sun Yatsen is urged to disband civil corps. Army looting in Zhaoqing. Troops are moved to the Dongjiang River area. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094430 | 24094430 | |
39914 | 39914 | 1923-06-02 | 3 | b | Beijing people are keen to stop trade relations with Japan. | China | http://trove.nla.gov.au/newspaper/page/24094423 | 24094423 | |
39930 | 39930 | 1923-06-02 | 7 | b | Readers are reminded of the fraud in Sydney streets. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094427 | 24094427 | |
39931 | 39931 | 1923-06-02 | 7 | b | Chinese consul in Melbourne Shi Shaozeng is transferring to Bandung and his farewell in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094427 | 24094427 | |
39932 | 39932 | 1923-06-02 | 7 | b | A child is found dead in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094427 | 24094427 | |
39915 | 39915 | 1923-06-02 | 3 | b-c | National Commercial Chamber in Shanghai sends telegram to the Treasury in Beijing for the proposed internal loans. | China | http://trove.nla.gov.au/newspaper/page/24094423 | 24094423 | |
39924 | 39924 | 1923-06-02 | 6 | b-d | A telegram from Shen Hongying to the Yunnan army commander. | China | http://trove.nla.gov.au/newspaper/page/24094428 | 24094428 | |
39916 | 39916 | 1923-06-02 | 3 | c | Chinese parliament might be moved to Guangzhou once again. | China | http://trove.nla.gov.au/newspaper/page/24094423 | 24094423 | |
39933 | 39933 | 1923-06-02 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094427 | 24094427 | |
39917 | 39917 | 1923-06-02 | 3 | c-d | School students in Zhejiang province are poisoned and the investigation. | China | http://trove.nla.gov.au/newspaper/page/24094423 | 24094423 | |
39911 | 39911 | 1923-06-02 | 2 | c-e | Chinese President Li Yuanhong issues a circular telegram on truce and peace talks. | China | http://trove.nla.gov.au/newspaper/page/24094424 | 24094424 | |
39918 | 39918 | 1923-06-02 | 3 | e | Communist movement in Germany. | Britain | http://trove.nla.gov.au/newspaper/page/24094423 | 24094423 | |
39919 | 39919 | 1923-06-02 | 3 | e | Government troops are trying to suppress bandits in Shandong province. | America | http://trove.nla.gov.au/newspaper/page/24094423 | 24094423 | |
39935 | 39935 | 1923-06-02 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094430 | 24094430 | |
39936 | 39936 | 1923-06-02 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094430 | 24094430 | |
39912 | 39912 | 1923-06-02 | 2 | e-f | The first step of the union of the southwest provinces in China. | China | http://trove.nla.gov.au/newspaper/page/24094424 | 24094424 | |
39920 | 39920 | 1923-06-02 | 3 | f | Bomb blast in a Warsaw university, Poland. | Britain | http://trove.nla.gov.au/newspaper/page/24094423 | 24094423 | |
39921 | 39921 | 1923-06-02 | 3 | f | No more revolutionary movement in north China. | Britain | http://trove.nla.gov.au/newspaper/page/24094423 | 24094423 | |
39922 | 39922 | 1923-06-02 | 3 | f | Hungarian Premier is executed in a revolutionary movement. | Britain | http://trove.nla.gov.au/newspaper/page/24094423 | 24094423 |
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]);