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 |
---|---|---|---|---|---|---|---|---|---|
47619 | 47619 | 1928-12-01 | 2 | b | Editorial by Tung Wah Times claims that politicians should behave in a moral way. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
47620 | 47620 | 1928-12-01 | 2 | c | Jilin may declare independence. | China | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
47621 | 47621 | 1928-12-01 | 2 | c | The Nanjing government to borrow foreign loans. | China | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
47622 | 47622 | 1928-12-01 | 2 | c | Bandits and thieves in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
47623 | 47623 | 1928-12-01 | 2 | c | Zhang Xueliang to return some vehicles to the south. Zhang Xueliang escapes an assassination. Press censorship in Shanghai. Situation changes suddenly in Shandong. Talks halt between China and Portugal on the treaty review. Others news from China. | China | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
47624 | 47624 | 1928-12-01 | 2 | d | First cabinet meeting of the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
47625 | 47625 | 1928-12-01 | 2 | e | He Jian in Hunan province executes key communist figures and the report. | China | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
47626 | 47626 | 1928-12-01 | 2 | f | Zhang Xueliang is reluctant to give up Rehe province. | China | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
47627 | 47627 | 1928-12-01 | 3 | b | Jiangxi province under the new administration. | China | http://trove.nla.gov.au/newspaper/page/24099033 | 24099033 | |
47628 | 47628 | 1928-12-01 | 3 | c | Taixu Master of the Law delivers Buddhist speeches in France and the report. | France | http://trove.nla.gov.au/newspaper/page/24099033 | 24099033 | |
47629 | 47629 | 1928-12-01 | 3 | d | The Social Security Maintenance Society in Jinan, Shandong, and a report on its true feature. | China | http://trove.nla.gov.au/newspaper/page/24099033 | 24099033 | |
47630 | 47630 | 1928-12-01 | 3 | f | Yan Xishan is going to Nanjing and might be minister of internal affairs. | China | http://trove.nla.gov.au/newspaper/page/24099033 | 24099033 | |
47631 | 47631 | 1928-12-01 | 5 | a | Hong Kong news/ Customs authority seize smuggled weapons. Hong Kong businessmen contract to develop the Dongsha islands for marine products. Chinese commercial chambers in Hong Kong to build a library and the progress. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099035 | 24099035 | |
47632 | 47632 | 1928-12-01 | 6-7 | a-d | Guangdong news/ Official inspection on opium smuggling and the obstacles. Li Jishen is returning from Nanjing. Drought in Guangdong and the damages. The Communists never stop making trouble. Businessmen demand the government to repay the bonds. Road construction in Gaoyao and the turbulence. Fire in Xinqiao town, of Gaoyao county. Public security troops in Dongguan on the way to suppress bandits. Peasants in Panyu county appeal for tax reduction. Bandit chieftain Tang Jiannan in Xinhui county is arrested. Street construction in Xinhui county. Bandits in Enping county. Evil gentry punished in Shunde county. | China | http://trove.nla.gov.au/newspaper/page/24099038 | 24099038 | |
47633 | 47633 | 1928-12-01 | 8 | a | Troops in Beiping harass trams. | China | http://trove.nla.gov.au/newspaper/page/24099040 | 24099040 | |
47634 | 47634 | 1928-12-01 | 8 | a | The Anglo-Japanese alliance and its future. | Japan | http://trove.nla.gov.au/newspaper/page/24099040 | 24099040 | |
47635 | 47635 | 1928-12-01 | 8 | a | Talks between China and Japan halt again. | China | http://trove.nla.gov.au/newspaper/page/24099040 | 24099040 | |
47636 | 47636 | 1928-12-01 | 8 | a | Number of fires in Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24099040 | 24099040 | |
47637 | 47637 | 1928-12-01 | 8 | a | King of Britain is sick. | Britain | http://trove.nla.gov.au/newspaper/page/24099040 | 24099040 | |
47638 | 47638 | 1928-12-01 | 8 | a | Australia news/ Police in Sydney detain thief at night. A man on trial for murder of his wife. Mr Henry Schwieger becomes chairman of the board of the Primary Producers' Bank of Australia Ltd. Gibbs & Bright Co Ltd moves. fire in New Zealand. Two Italian immigrants are arrested in Sydney. A school teacher is found adultery with his student. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099040 | 24099040 |
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]);