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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
40852 | 40852 | 1923-12-29 | 3 | a-b | Xu Chongzhi is leaving Guangdong. | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
40855 | 40855 | 1923-12-29 | 3 | c | Earthquake in Mexico. | Canada | http://trove.nla.gov.au/newspaper/page/24094663 | 24094663 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
40860 | 40860 | 1923-12-29 | 3 | d-e | Foreign weapons are smuggled into China. | Britain | http://trove.nla.gov.au/newspaper/page/24094663 | 24094663 | |
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 | |
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 | |
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 | |
40862 | 40862 | 1923-12-29 | 3 | f | Internal fighting in the Guangzhou military circle. | China | http://trove.nla.gov.au/newspaper/page/24094663 | 24094663 | |
40851 | 40851 | 1923-12-29 | 2-3 | f-a | A visit to Tibet. | China | http://trove.nla.gov.au/newspaper/page/24094664 | 24094664 |
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]);