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 |
|---|---|---|---|---|---|---|---|---|---|
| 41320 | 41320 | 1924-03-29 | 2 | a-b | Sun Yatsen detains the magistrate of Heshan county and comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100664 | 24100664 | |
| 41324 | 41324 | 1924-03-29 | 2 | c-d | A survey on the debt that Beijing government owes to foreign countries (amount, name of country, and due date, etc). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100664 | 24100664 | |
| 41341 | 41341 | 1924-03-29 | 6 | d-e | The Russian Communist (Bolshevik) after the death of Lenin. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100668 | 24100668 | |
| 41343 | 41343 | 1924-03-29 | 7 | a | Chinese Consulate General in Melbourne has a new office manager, Qu Sunyi, who is arriving in Sydney from China, and his background. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
| 41344 | 41344 | 1924-03-29 | 7 | a-b | The Sydney pianist is sentenced to death for murdering his three daughters. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
| 41346 | 41346 | 1924-03-29 | 7 | c | A young woman in Sydney dies of abortion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
| 41347 | 41347 | 1924-03-29 | 7 | c | Chinese market gardener Wu Zhen and his excellent performance in the agriculture show in Glen Innes. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
| 41349 | 41349 | 1924-03-29 | 7 | d | Passengers of Lingnan, a liner of the Chungwah Navigation Company Ltd, write in praise of the service on board. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
| 41350 | 41350 | 1924-03-29 | 7 | d-e | Gong yi tang (The Dong Guan Goon Yee Tong) in Sydney is to set up a board and its notice for election of the board directors. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
| 41351 | 41351 | 1924-03-29 | 7 | e | Farewell message by Chen Junle on his return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
| 41352 | 41352 | 1924-03-29 | 7 | f | Chinese immigrants in Samoa island write and thank Chinese consul Li Zhaosong for his great help. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
| 41353 | 41353 | 1924-03-29 | 7 | f | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
| 41354 | 41354 | 1924-03-29 | 8 | a-d | Guangdong news/ Provincial governor tries to pacify the agitation of the rice market in Guangzhou. Rice price goes down. A notice by the Commercial Chamber in Guangzhou on the issue of shoupiao. The shoupiao issued by charity institutions in Guangzhou. Leaflets and the memory service in Guangzhou for Lenin. Shop owners in Macao close their business for a strike. Huang Shaoxiong in Wuzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100670 | 24100670 | |
| 41355 | 41355 | 1924-03-29 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100670 | 24100670 | |
| 41356 | 41356 | 1924-03-29 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100670 | 24100670 |
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]);