This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46614 | 46614 | 1927-12-31 | 5 | a | Documents found in Soviet Russian consulate in Guangzhou about their communist propaganda. | China | http://trove.nla.gov.au/newspaper/page/24098649 | 24098649 | |
46615 | 46615 | 1927-12-31 | 5 | a | Shandong provincial authority confiscates British goods and the negotiations. | Britain | http://trove.nla.gov.au/newspaper/page/24098649 | 24098649 | |
46616 | 46616 | 1927-12-31 | 5 | a | Rumours say Japanese seek to take over the railway line in Shandong province from Jiaozhou to Jinan. | Japan | http://trove.nla.gov.au/newspaper/page/24098649 | 24098649 | |
46617 | 46617 | 1927-12-31 | 5 | a | Tang Shengzhi is besieged by Chinese students in Japan. | China | http://trove.nla.gov.au/newspaper/page/24098649 | 24098649 | |
46618 | 46618 | 1927-12-31 | 5 | a | A declaration issued by Wu Chaoshu, foreign minister of the Nationalist government in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24098649 | 24098649 | |
46624 | 46624 | 1927-12-31 | 7 | a | Australia news/ Telegram from Tang Shaoyi to the Australian Chinese communities on the Communist riots in Guangdong and the disasters. The Sun and other Australian companies in Hong Kong are safe. Three suspects are arrested in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098651 | 24098651 |
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]);