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 |
|---|---|---|---|---|---|---|---|---|---|
| 40792 | 40792 | 1923-12-15 | 2 | a-b | Editorial by the Tung Wah Times assures that the Guangdong problem might be solved soon. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094648 | 24094648 | |
| 40793 | 40793 | 1923-12-15 | 2 | b-d | Sixth part of the constitution of the Republic of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094648 | 24094648 | |
| 40795 | 40795 | 1923-12-15 | 3 | a-f | A detailed year-end budget report of the China-Australia Steamship Mail Line (1922 and 1923), submitted by its managing director Yu Rong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094647 | 24094647 | |
| 40799 | 40799 | 1923-12-15 | 6 | d | Chinese Chamber of Commerce organises a fundraising concert/ party in the city Town Hall for Sydney hospital and those who are involved include Ye Tonggui and his wife, actor Lang Deshan, Zhang Maokuan, Zhu Hechou, Liu Guangfu, and Ma Zanfen. And report on the programme. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094652 | 24094652 | |
| 40800 | 40800 | 1923-12-15 | 7 | a | A foreign businessman is robbed in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094651 | 24094651 | |
| 40801 | 40801 | 1923-12-15 | 7 | a | Two illegal Chinese immigrants are detained on their way from Suva, Fiji, to Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094651 | 24094651 | |
| 40802 | 40802 | 1923-12-15 | 7 | a | A theatre in Paddington, Sydney, is on fire. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094651 | 24094651 | |
| 40803 | 40803 | 1923-12-15 | 7 | a-b | A new proposal to the Sydney city council to restrict Chinese market gardener and vegetable peddlers. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094651 | 24094651 | |
| 40804 | 40804 | 1923-12-15 | 7 | b | Two men fight in Sydney for a woman and one is killed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094651 | 24094651 | |
| 40805 | 40805 | 1923-12-15 | 7 | b | A skilled female thief in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094651 | 24094651 | |
| 40809 | 40809 | 1923-12-15 | 7 | c-d | Miscellaneous report on the war in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094651 | 24094651 | |
| 40810 | 40810 | 1923-12-15 | 7 | e | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094651 | 24094651 | |
| 40811 | 40811 | 1923-12-15 | 8 | a-d | Guangdong news/ Chen Qiyuan withdraws money from the bank by force. Sun Yatsen speaks to his troops. Sun Yatsen's English secretary Chen Youren can not assure the takeover of Huizhou. More battles in Guangdong. Guangdong army occupy Boluo and Shilong. Jiang Guangliang escapes. Hong Zhaolin writes to his family. Liu Yushan and Liu Zhenhuan are disbanded. Guangzhou will turn into battle field. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094654 | 24094654 | |
| 40812 | 40812 | 1923-12-15 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094654 | 24094654 | |
| 40813 | 40813 | 1923-12-15 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094654 | 24094654 |
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]);