This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id
Link | rowid | date | page | column | title | description ▼ | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
40851 | 40851 | 1923-12-29 | 2-3 | f-a | A visit to Tibet. | China | http://trove.nla.gov.au/newspaper/page/24094664 | 24094664 | |
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 | |
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 | |
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 | |
40857 | 40857 | 1923-12-29 | 3 | d | Beijing cabinet resigns and the explanation. | America | http://trove.nla.gov.au/newspaper/page/24094663 | 24094663 | |
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 | |
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 | |
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 | |
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 | |
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 | |
40855 | 40855 | 1923-12-29 | 3 | c | Earthquake in Mexico. | Canada | 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 | |
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 | |
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 | |
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 | |
40860 | 40860 | 1923-12-29 | 3 | d-e | Foreign weapons are smuggled into China. | Britain | http://trove.nla.gov.au/newspaper/page/24094663 | 24094663 | |
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 | |
40878 | 40878 | 1923-12-29 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094669 | 24094669 | |
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 | |
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 | |
40862 | 40862 | 1923-12-29 | 3 | f | Internal fighting in the Guangzhou military circle. | China | http://trove.nla.gov.au/newspaper/page/24094663 | 24094663 | |
40879 | 40879 | 1923-12-29 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094669 | 24094669 | |
40875 | 40875 | 1923-12-29 | 7 | d | Mexican authority bans entry of Chinese immigrant. | Other... | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
40852 | 40852 | 1923-12-29 | 3 | a-b | Xu Chongzhi is leaving Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24094663 | 24094663 |
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]);