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