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 |
---|---|---|---|---|---|---|---|---|---|
46818 | 46818 | 1928-03-10 | 5 | a | Hong Kong news/ Guangdong provincial government seeks to borrow loans from Hong Kong sources. Further report on the case of Wang Zongzhu. Another suicide for love on the ferry from Guangzhou to Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098721 | 24098721 | |
46821 | 46821 | 1928-03-10 | 6 | a | Li Jishen and his strategies to deal with the communists in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24098724 | 24098724 | |
46826 | 46826 | 1928-03-10 | 7 | a | Yellow River is flooding in Shandong province. A Japanese cargo is stranded in the Taiwan Strait. The Communist Party members in Hunan province set fire to temples. Many people of Lufeng and Haifeng county are fleeing the Communist disasters. | China | http://trove.nla.gov.au/newspaper/page/24098723 | 24098723 | |
46827 | 46827 | 1928-03-10 | 7 | a | Britain, France, Germany, Italy and Japan to have a conference for world peace. | Other... | http://trove.nla.gov.au/newspaper/page/24098723 | 24098723 | |
46828 | 46828 | 1928-03-10 | 7 | a | Beijing government appoints Pan Fu, Gu Weijun and others to the international tariff conference. | China | http://trove.nla.gov.au/newspaper/page/24098723 | 24098723 |
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]);