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 |
|---|---|---|---|---|---|---|---|---|---|
| 41455 | 41455 | 1924-04-26 | 2 | a-b | Editorial on the model in Guangdong for self-defence of local villagers. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100696 | 24100696 | |
| 41456 | 41456 | 1924-04-26 | 2 | b-d | Preparation for the third national sports game that to be held in Wuchang, Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24100696 | 24100696 | |
| 41457 | 41457 | 1924-04-26 | 2 | d | Foreign powers are studying possible development of Chinese politics. | China | http://trove.nla.gov.au/newspaper/page/24100696 | 24100696 | |
| 41458 | 41458 | 1924-04-26 | 2 | d-e | Full draft of the treaty between China and Russia. | Other... | http://trove.nla.gov.au/newspaper/page/24100696 | 24100696 | |
| 41459 | 41459 | 1924-04-26 | 2 | e-f | Japanese ambassador in Beijing denies that Sun Yatsen mortgages public property for more loans. | China | http://trove.nla.gov.au/newspaper/page/24100696 | 24100696 | |
| 41460 | 41460 | 1924-04-26 | 2 | f | Bi Weiyuan, director of the Overseas Chinese Affairs Office in Beijing, is to visit Chinese communities in Nanyang area (Southeast Asia). | China | http://trove.nla.gov.au/newspaper/page/24100696 | 24100696 | |
| 41461 | 41461 | 1924-04-26 | 2 | f | Chita government refuses to revise their discrimination regulations against Chinese. | China | http://trove.nla.gov.au/newspaper/page/24100696 | 24100696 | |
| 41462 | 41462 | 1924-04-26 | 2-3 | f-a | Relation between Japan and Russia deteriorates. | Other... | http://trove.nla.gov.au/newspaper/page/24100696 | 24100696 | |
| 41463 | 41463 | 1924-04-26 | 3 | a-c | Zhang Yi, division commander of Fujian army, defects to the north. | China | http://trove.nla.gov.au/newspaper/page/24100695 | 24100695 | |
| 41464 | 41464 | 1924-04-26 | 3 | c | Naval force in Fujian province are trying to drive out Wang Yongquan. | China | http://trove.nla.gov.au/newspaper/page/24100695 | 24100695 | |
| 41465 | 41465 | 1924-04-26 | 3 | d | Black donkey in Baodi county, a suburb of Beijing, helps to capture the murder. | China | http://trove.nla.gov.au/newspaper/page/24100695 | 24100695 | |
| 41466 | 41466 | 1924-04-26 | 3 | e | The case of gold Franc and the dispute over the Guangzhou Bay. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100695 | 24100695 | |
| 41467 | 41467 | 1924-04-26 | 3 | e | American House of Representatives formally approves to ban Japanese immigrant. | Canada | http://trove.nla.gov.au/newspaper/page/24100695 | 24100695 | |
| 41468 | 41468 | 1924-04-26 | 3 | e | Some of Sun Yatsen's army in Fujian province are defeated and dispersed. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100695 | 24100695 | |
| 41469 | 41469 | 1924-04-26 | 3 | f | A German merchant ship runs on rocks near Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100695 | 24100695 | |
| 41470 | 41470 | 1924-04-26 | 3 | f | Statistics on suicide in America. | America | http://trove.nla.gov.au/newspaper/page/24100695 | 24100695 | |
| 41471 | 41471 | 1924-04-26 | 6 | a-e | Second and final part of the special and detailed report on the Chinese Communist Party: its past, present and the future. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100700 | 24100700 | |
| 41472 | 41472 | 1924-04-26 | 7 | a | Tung Wah Times comments on the war in Dongjiang area. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100699 | 24100699 | |
| 41473 | 41473 | 1924-04-26 | 7 | a-b | Australian federal government issues new bank notes. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100699 | 24100699 | |
| 41474 | 41474 | 1924-04-26 | 7 | b | Number of visitors to The Royal Centenary Show, Moore Park, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100699 | 24100699 | |
| 41475 | 41475 | 1924-04-26 | 7 | b | A homicide case in the warship docked in Sydney harbour. | Australia | http://trove.nla.gov.au/newspaper/page/24100699 | 24100699 | |
| 41476 | 41476 | 1924-04-26 | 7 | b | Labour Party in New South Wales drives out all communist members. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100699 | 24100699 | |
| 41477 | 41477 | 1924-04-26 | 7 | b | A case of homicide in a Sydney hotel. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100699 | 24100699 | |
| 41478 | 41478 | 1924-04-26 | 7 | c | A man in north Sydney shoots dead his son-in-law. | Australia | http://trove.nla.gov.au/newspaper/page/24100699 | 24100699 | |
| 41479 | 41479 | 1924-04-26 | 7 | c | A man is crushed to death while crossing railway line. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100699 | 24100699 | |
| 41480 | 41480 | 1924-04-26 | 7 | c | Railway workers are on strike in Auckland. | New Zealand | http://trove.nla.gov.au/newspaper/page/24100699 | 24100699 | |
| 41481 | 41481 | 1924-04-26 | 7 | c-d | Troops from Henan province kills local residents and businessmen in Shaozhou and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100699 | 24100699 | |
| 41482 | 41482 | 1924-04-26 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100699 | 24100699 | |
| 41483 | 41483 | 1924-04-26 | 7 | e | A notice by the Heng Shan Tang (an association of Chinese fellows from Nanhai, Panyu and Shunde counties) in Sydney on the transfer of remains of their deceased fellows back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100699 | 24100699 | |
| 41484 | 41484 | 1924-04-26 | 8 | a-d | Guangdong news/ A meeting of the provincial Financial Committee. Yang Shukan regains his control over the Yunnan army. Some communist members join the revolutionary party for money. Yunnan army burn down villages in Panyu county. Dongguan high school has a new principal and the chaos that followed. Xie Xinzhun becomes new magistrate of Zengcheng county. Troops in Gaoming county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100701 | 24100701 | |
| 41485 | 41485 | 1924-04-26 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100701 | 24100701 | |
| 41486 | 41486 | 1924-04-26 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100701 | 24100701 |
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]);