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 |
---|---|---|---|---|---|---|---|---|---|
46628 | 46628 | 1928-01-07 | 2 | a | Comments by Tung Wah Times on the occasion of New Year and the responsibilities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098656 | 24098656 | |
46629 | 46629 | 1928-01-07 | 2 | c | The Nationalist troops and the westward expedition to Wuhan and their victory. | China | http://trove.nla.gov.au/newspaper/page/24098656 | 24098656 | |
46630 | 46630 | 1928-01-07 | 2 | d | Tragedies while trying to attack Tang Shengzhi and the report. | China | http://trove.nla.gov.au/newspaper/page/24098656 | 24098656 | |
46631 | 46631 | 1928-01-07 | 2 | e | Governor of Hong Kong is welcomed in Beijing and his speech. | China | http://trove.nla.gov.au/newspaper/page/24098656 | 24098656 | |
46632 | 46632 | 1928-01-07 | 2 | f | The Nationalist government in Nanjing to set up the second short-wave radio station. | China | http://trove.nla.gov.au/newspaper/page/24098656 | 24098656 | |
46633 | 46633 | 1928-01-07 | 3 | b | Japan's attempt to take over Manchuria and Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24098655 | 24098655 | |
46634 | 46634 | 1928-01-07 | 3 | b | Russian authority dispatches more troops to the border with Heilongjiang province of China. Soviet Russia seeks to control the Ussuri River on the border with China. | China | http://trove.nla.gov.au/newspaper/page/24098655 | 24098655 | |
46635 | 46635 | 1928-01-07 | 3 | c | French newspaper comments on the anti-Chinese sentiments in Vietnam. | China | http://trove.nla.gov.au/newspaper/page/24098655 | 24098655 | |
46636 | 46636 | 1928-01-07 | 3 | d | Tang Shengzhi is wanted by the Nationalist government in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24098655 | 24098655 | |
46637 | 46637 | 1928-01-07 | 3 | d | Unprecedented plague of locusts in Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098655 | 24098655 | |
46638 | 46638 | 1928-01-07 | 3 | d | Tens of thousands of refugees in Zhili and Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098655 | 24098655 | |
46639 | 46639 | 1928-01-07 | 3 | e | Jin Yunpeng arrives Tianjin secretly. | China | http://trove.nla.gov.au/newspaper/page/24098655 | 24098655 | |
46640 | 46640 | 1928-01-07 | 3 | e | Statistics on China's internal and external debts. | China | http://trove.nla.gov.au/newspaper/page/24098655 | 24098655 | |
46641 | 46641 | 1928-01-07 | 5 | a | The Nationalist government in Nanjing and Zhang Zuolin seek cooperation to wipe out the Communists. | Britain | http://trove.nla.gov.au/newspaper/page/24098657 | 24098657 | |
46642 | 46642 | 1928-01-07 | 5 | a | Japan's foreign trade. | Japan | http://trove.nla.gov.au/newspaper/page/24098657 | 24098657 | |
46643 | 46643 | 1928-01-07 | 5 | a | Refugees in Zhili and Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098657 | 24098657 | |
46644 | 46644 | 1928-01-07 | 5 | a | Guangzhou is quiet. | China | http://trove.nla.gov.au/newspaper/page/24098657 | 24098657 | |
46645 | 46645 | 1928-01-07 | 5 | b | Bandits in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098657 | 24098657 | |
46646 | 46646 | 1928-01-07 | 5 | b | Bandits rob a bank in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24098657 | 24098657 | |
46647 | 46647 | 1928-01-07 | 5 | b | French foreign minister talks on the world peace. | Britain | http://trove.nla.gov.au/newspaper/page/24098657 | 24098657 | |
46648 | 46648 | 1928-01-07 | 5 | b | A shop in Paris sells babies. | France | http://trove.nla.gov.au/newspaper/page/24098657 | 24098657 | |
46649 | 46649 | 1928-01-07 | 5 | c | Jiang Jieshi refuses to come back to his post. Gas used by Zhang Zuolin's army in their battle with Yan Xishan. | China | http://trove.nla.gov.au/newspaper/page/24098657 | 24098657 | |
46650 | 46650 | 1928-01-07 | 7 | a | Australia news/ A white man is arrested in Sydney for illegally raising funds among the Chinese community. Fire on the eve of New Year in Victoria. Fire in Adelaide. Tariff income of the federal government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098659 | 24098659 | |
46651 | 46651 | 1928-01-07 | 7 | a | The biggest bus in the world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098659 | 24098659 | |
46652 | 46652 | 1928-01-07 | 8 | a-d | Guangdong news/ Road construction in Zhongshan county. Pirates in Zhongshan county kidnap two cruisers. Four hooligans detained in Taishan county. Villages robbed in Zengcheng county. Agricultural harvest in Huizhou. Business dull in Dongguan county because of banditry. Bandits in Dongguan. Bandits hijack ferries in west Guangdong. Unprecedented famine in Heping county. New road connect Yunfu and Gaoyao counties. Bandits' robbery in Boluo county. Tap water in Taishan county. | China | http://trove.nla.gov.au/newspaper/page/24098662 | 24098662 |
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]);