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 |
---|---|---|---|---|---|---|---|---|---|
41626 | 41626 | 1924-05-31 | 3 | e | Li Liejun has arrived Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24100736 | 24100736 | |
41627 | 41627 | 1924-05-31 | 3 | e | American journalist interviews Sun Yatsen in Guangzhou. | America | http://trove.nla.gov.au/newspaper/page/24100736 | 24100736 | |
41631 | 41631 | 1924-05-31 | 6 | e | The Sun company in Hong Kong pays dividends to its shareholders. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100741 | 24100741 | |
41642 | 41642 | 1924-05-31 | 7 | e | A notice by the Heng Shan Tang (an association of Chinese fellows from Nanhai, Panyu and Shunde counties) in Sydney on the transfer of remains of their deceased fellows back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100740 | 24100740 | |
41644 | 41644 | 1924-05-31 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100743 | 24100743 | |
41645 | 41645 | 1924-05-31 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100743 | 24100743 |
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]);