This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46707 | 46707 | 1928-02-04 | 5 | a | The Communists in Guangzhou is planning another rebellion. Foreign powers to ask the Nationalist government in Nanjing to suppress bandits seriously. Farewell to British military commander in Shanghai. Warlords in north China purchase large numbers of weapons from overseas and the report. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098681 | 24098681 | |
46708 | 46708 | 1928-02-04 | 5 | b | Troops in Moscow and their mutiny. | Britain | http://trove.nla.gov.au/newspaper/page/24098681 | 24098681 | |
46709 | 46709 | 1928-02-04 | 5 | b-c | Soviet Russian consuls are leaving China. The execution of Zhan Dabei and Li Hanjun in Shanghai. Duan Qirui seeks to mediate the conflict between Yan Xishan and Zhang Zuolin. Progress of the Northern Expedition. | China | http://trove.nla.gov.au/newspaper/page/24098681 | 24098681 | |
46710 | 46710 | 1928-02-04 | 5 | d | Advertisement for Assurance Homes of Australia Ltd, the investment of the century, in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098681 | 24098681 |
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]);