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 |
---|---|---|---|---|---|---|---|---|---|
47339 | 47339 | 1928-08-18 | 5 | a | Hong Kong news/ Chinese businessmen in Hong Kong to set up the South China Textile Company. Submarine tunnel to be built in Kowloon. Various bank notes issued by different banks. Business dull for clothes shop. He Xiangni leaves Hong Kong for Shanghai. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098915 | 24098915 | |
47343 | 47343 | 1928-08-18 | 8 | a | Floods of the Yangtze River. | China | http://trove.nla.gov.au/newspaper/page/24098920 | 24098920 | |
47344 | 47344 | 1928-08-18 | 8 | a | The fifth congress of the Nationalist Party in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098920 | 24098920 | |
47345 | 47345 | 1928-08-18 | 8 | a | Inheritance of a rich man in Belgium. | Britain | http://trove.nla.gov.au/newspaper/page/24098920 | 24098920 | |
47346 | 47346 | 1928-08-18 | 8 | a | The Communists in the south of Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24098920 | 24098920 | |
47347 | 47347 | 1928-08-18 | 8 | a | Japanese cabinet on the treaty with China. | Australia | http://trove.nla.gov.au/newspaper/page/24098920 | 24098920 |
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]);