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 |
---|---|---|---|---|---|---|---|---|---|
47129 | 47129 | 1928-06-09 | 8 | a | A big plane manufactured in Berlin, Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24098840 | 24098840 | |
47121 | 47121 | 1928-06-09 | 3 | c | American naval fleet suddenly arrives Qingdao, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098833 | 24098833 | |
47120 | 47120 | 1928-06-09 | 3 | c | Ancient Chinese bell found in Java and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098833 | 24098833 | |
47137 | 47137 | 1928-06-09 | 8 | c | Australia news/ Baby girl found abandoned in Sydney railway station. Polish immigrant in Geelong, Victoria, is found forging bank notes. Australian pilot flies directly from North America to Australia. Chinese gardener is burgled in New South Wales. Chinese man is charged with illegal entry before marrying a white girl. Chinese man in Sydney is hospitalised in madhouse. A Sydney girl is raped. Illegal wine sold in Sydney and the investigation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098840 | 24098840 | |
47118 | 47118 | 1928-06-09 | 2 | f | Disasters in Shandong province and the refugees. | China | http://trove.nla.gov.au/newspaper/page/24098834 | 24098834 | |
47114 | 47114 | 1928-06-09 | 2 | b | Editorial by Tung Wah Times on China's foreign policy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098834 | 24098834 | |
47135 | 47135 | 1928-06-09 | 8 | b | Feng Yuxiang is considering to defect once again. | China | http://trove.nla.gov.au/newspaper/page/24098840 | 24098840 | |
47126 | 47126 | 1928-06-09 | 5 | b | Fifth part of the survey on the tobacco production in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098835 | 24098835 | |
47124 | 47124 | 1928-06-09 | 3 | e | Fire in Chongqing, of Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24098833 | 24098833 | |
47115 | 47115 | 1928-06-09 | 2 | c | Foreign ministry of the Beijing government protests against Japanese invasion in Shandong. | China | http://trove.nla.gov.au/newspaper/page/24098834 | 24098834 | |
47116 | 47116 | 1928-06-09 | 2 | d | Foreign ministry of the Nationalist government in Nanjing rebuffs Japanese declaration. | Japan | http://trove.nla.gov.au/newspaper/page/24098834 | 24098834 | |
47127 | 47127 | 1928-06-09 | 6 | a-d | Guangdong news/ Neighbour houses are demolished for the building of Sun Yatsen Memorial Hall in Guangzhou. Government officials also try to control the value of bank notes. Petition to abolish extra taxes on vegetable peddlers. A report submitted by Li Jishen to the central committee of the Nationalist government in Nanjing on the Guangdong situations. Security troops organised in Gaoming county. | China | http://trove.nla.gov.au/newspaper/page/24098838 | 24098838 | |
47128 | 47128 | 1928-06-09 | 7 | a-d | Guangdong news/ Number of the Communist members arrested in Guangzhou. Road construction in Zhongshan county. Mediation Committee in Zengcheng for the clan fighting. Further report on the clan fighting in Panyu and Zengcheng county. Bandits arrested in the Beijiang area. Bandits in Taishan county pretend to be government officials. Mails opened illegally in the Taishan county post office. Bandits suppressed in the Seven Stars Cliff (qi xing yan) area. Visitor to Haifeng talks about the situations there. | China | http://trove.nla.gov.au/newspaper/page/24098837 | 24098837 | |
47125 | 47125 | 1928-06-09 | 5 | a | Hong Kong news/ Yu Meiyan commits suicide. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098835 | 24098835 | |
47119 | 47119 | 1928-06-09 | 3 | b | Lu Zhengxiang is now a monk. | China | http://trove.nla.gov.au/newspaper/page/24098833 | 24098833 | |
47123 | 47123 | 1928-06-09 | 3 | e | Number of Japanese nationals in Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098833 | 24098833 | |
47117 | 47117 | 1928-06-09 | 2 | e | Orders issued by the Nationalist government in Nanjing to promote traditional morality. | China | http://trove.nla.gov.au/newspaper/page/24098834 | 24098834 | |
47132 | 47132 | 1928-06-09 | 8 | b | Soviet Russia provides assistance to the strikers in India. | Other... | http://trove.nla.gov.au/newspaper/page/24098840 | 24098840 | |
47133 | 47133 | 1928-06-09 | 8 | b | Sun Chuanfang resigns from the position of General Commander of Zhili and Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098840 | 24098840 | |
47122 | 47122 | 1928-06-09 | 3 | d | The Big Sword Society bandits are active on the border with Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24098833 | 24098833 | |
47136 | 47136 | 1928-06-09 | 8 | c | Zhang Xueliang, Yang Yuting, and Yan Xishan after the death of Zhang Zuolin. | Japan | http://trove.nla.gov.au/newspaper/page/24098840 | 24098840 | |
47134 | 47134 | 1928-06-09 | 8 | b | Zhang Zuolin dies in a bomb explosion and the report. | Japan | http://trove.nla.gov.au/newspaper/page/24098840 | 24098840 | |
47130 | 47130 | 1928-06-09 | 8 | a | Zhang Zuolin has left Beijing for the north-east. | China | http://trove.nla.gov.au/newspaper/page/24098840 | 24098840 | |
47131 | 47131 | 1928-06-09 | 8 | a | Zhang Zuolin is killed in a bomb explosion on his way from Beijing to Fengtian. | Japan | http://trove.nla.gov.au/newspaper/page/24098840 | 24098840 |
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]);