This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 40844 | 40844 | 1923-12-29 | 2 | a-b | Editorial on the dead end of Sun Yatsen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094664 | 24094664 | |
| 40845 | 40845 | 1923-12-29 | 2 | b-c | President Cao Kun to organise a celebration in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24094664 | 24094664 | |
| 40846 | 40846 | 1923-12-29 | 2 | c | Agreement signed between China and Britain on the return of Weihaiwei. | China | http://trove.nla.gov.au/newspaper/page/24094664 | 24094664 | |
| 40847 | 40847 | 1923-12-29 | 2 | c-d | English newspaper in Shanghai reports the political refugees in the international settlement. | China | http://trove.nla.gov.au/newspaper/page/24094664 | 24094664 | |
| 40848 | 40848 | 1923-12-29 | 2 | d | Hong Kong businessman He Dong is going north for national peace. He Dong talks in Shanghai on the peace talks. | China | http://trove.nla.gov.au/newspaper/page/24094664 | 24094664 | |
| 40849 | 40849 | 1923-12-29 | 2 | d-e | Beijing government is trying hard to raise funds for administration and military purpose. | China | http://trove.nla.gov.au/newspaper/page/24094664 | 24094664 | |
| 40850 | 40850 | 1923-12-29 | 2 | f | French authority on China's repayment of indemnity. | China | http://trove.nla.gov.au/newspaper/page/24094664 | 24094664 | |
| 40851 | 40851 | 1923-12-29 | 2-3 | f-a | A visit to Tibet. | China | http://trove.nla.gov.au/newspaper/page/24094664 | 24094664 | |
| 40852 | 40852 | 1923-12-29 | 3 | a-b | Xu Chongzhi is leaving Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24094663 | 24094663 | |
| 40853 | 40853 | 1923-12-29 | 3 | b-c | China prepares to take back the Guangzhou Bay. | China | http://trove.nla.gov.au/newspaper/page/24094663 | 24094663 | |
| 40854 | 40854 | 1923-12-29 | 3 | c | Bandit chieftain who organised the kidnap of foreigners in Shandong province has been executed. | America | http://trove.nla.gov.au/newspaper/page/24094663 | 24094663 | |
| 40855 | 40855 | 1923-12-29 | 3 | c | Earthquake in Mexico. | Canada | http://trove.nla.gov.au/newspaper/page/24094663 | 24094663 | |
| 40856 | 40856 | 1923-12-29 | 3 | c-d | Sun Yatsen explains his motives to withhold the customs duties. | Britain | http://trove.nla.gov.au/newspaper/page/24094663 | 24094663 | |
| 40857 | 40857 | 1923-12-29 | 3 | d | Beijing cabinet resigns and the explanation. | America | http://trove.nla.gov.au/newspaper/page/24094663 | 24094663 | |
| 40858 | 40858 | 1923-12-29 | 3 | d | Earthquake in the Philippines. | Other... | http://trove.nla.gov.au/newspaper/page/24094663 | 24094663 | |
| 40859 | 40859 | 1923-12-29 | 3 | d | Boycott to American and British goods in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24094663 | 24094663 | |
| 40860 | 40860 | 1923-12-29 | 3 | d-e | Foreign weapons are smuggled into China. | Britain | http://trove.nla.gov.au/newspaper/page/24094663 | 24094663 | |
| 40861 | 40861 | 1923-12-29 | 3 | e-f | Sun Yatsen talks to British parliamentarian in Guangzhou. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24094663 | 24094663 | |
| 40862 | 40862 | 1923-12-29 | 3 | f | Internal fighting in the Guangzhou military circle. | China | http://trove.nla.gov.au/newspaper/page/24094663 | 24094663 | |
| 40863 | 40863 | 1923-12-29 | 6 | a-b | A plea from the navigation businessmen in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24094668 | 24094668 | |
| 40864 | 40864 | 1923-12-29 | 6 | b | More than 160 Chinese are murdered in Japan during the earthquake, Gu Weijun and Wang Zhengting start negotiation with Japanese authorities. | China | http://trove.nla.gov.au/newspaper/page/24094668 | 24094668 | |
| 40865 | 40865 | 1923-12-29 | 6 | b-c | Foreign missions in Beijing request Chinese government to put down bandits as soon as possible. | China | http://trove.nla.gov.au/newspaper/page/24094668 | 24094668 | |
| 40866 | 40866 | 1923-12-29 | 6 | c-d | British, French and Japanese ambassadors in Beijing protest misappropriation of salt tax in Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24094668 | 24094668 | |
| 40867 | 40867 | 1923-12-29 | 7 | a | A Sydney woman is punished for baby murder. | Australia | http://trove.nla.gov.au/newspaper/page/24094667 | 24094667 | |
| 40868 | 40868 | 1923-12-29 | 7 | a | A shop in Flinders Street, Melbourne is on fire. | Australia | http://trove.nla.gov.au/newspaper/page/24094667 | 24094667 | |
| 40869 | 40869 | 1923-12-29 | 7 | a | A young woman in Sydney is found using counterfeit bank notes. | Australia | http://trove.nla.gov.au/newspaper/page/24094667 | 24094667 | |
| 40870 | 40870 | 1923-12-29 | 7 | a | Two illegal Japanese immigrants are detained in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094667 | 24094667 | |
| 40871 | 40871 | 1923-12-29 | 7 | a-b | A Sydney department store is on fire. | Australia | http://trove.nla.gov.au/newspaper/page/24094667 | 24094667 | |
| 40872 | 40872 | 1923-12-29 | 7 | b-c | Miscellaneous report on the visit and match of Chinese football team in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094667 | 24094667 | |
| 40873 | 40873 | 1923-12-29 | 7 | c | A report from Zengcheng county on the war between Chen Jiongming and Sun Yatsen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094667 | 24094667 | |
| 40874 | 40874 | 1923-12-29 | 7 | c-d | Canadian authority issues new regulations on Chinese immigration. | Canada | http://trove.nla.gov.au/newspaper/page/24094667 | 24094667 | |
| 40875 | 40875 | 1923-12-29 | 7 | d | Mexican authority bans entry of Chinese immigrant. | Other... | http://trove.nla.gov.au/newspaper/page/24094667 | 24094667 | |
| 40876 | 40876 | 1923-12-29 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094667 | 24094667 | |
| 40877 | 40877 | 1923-12-29 | 8 | a-d | Guangdong news/ A junior officer reports the battle. Army looting near Guangzhou. Many government employees flea to Macao. Zhang Zurong joins Guangdong army. Zheng Runqi leads his army back to Guangdong. Army in the north starts attack on Shixing county. Guangdong army has arrived Huaxian county. The retreat of Guangdong army. Shilong town after being taken over by Guangdong army. Xiangshan people are against the new magistrate Lin Jingchun. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094669 | 24094669 | |
| 40878 | 40878 | 1923-12-29 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094669 | 24094669 | |
| 40879 | 40879 | 1923-12-29 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094669 | 24094669 |
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]);