This data as json, CSV (advanced)
Suggested facets: page, column, 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 | |
| 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 | |
| 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]);