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 |
---|---|---|---|---|---|---|---|---|---|
46648 | 46648 | 1928-01-07 | 5 | b | A shop in Paris sells babies. | France | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
46644 | 46644 | 1928-01-07 | 5 | a | Guangzhou is quiet. | China | http://trove.nla.gov.au/newspaper/page/24098657 | 24098657 | |
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 | |
46642 | 46642 | 1928-01-07 | 5 | a | Japan's foreign trade. | Japan | 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 | |
46639 | 46639 | 1928-01-07 | 3 | e | Jin Yunpeng arrives Tianjin secretly. | China | http://trove.nla.gov.au/newspaper/page/24098655 | 24098655 | |
46643 | 46643 | 1928-01-07 | 5 | a | Refugees in Zhili and Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098657 | 24098657 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
46651 | 46651 | 1928-01-07 | 7 | a | The biggest bus in the world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098659 | 24098659 | |
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 | |
46637 | 46637 | 1928-01-07 | 3 | d | Unprecedented plague of locusts in Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098655 | 24098655 |
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]);