This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34203 | 34203 | 1919-03-01 | 2 | a-b | Editorial by Tung Wah Times comments on the appointment of Yuan Dai military adviser by the Chinese President Xu Shichang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097630 | 24097630 | |
34204 | 34204 | 1919-03-01 | 2 | b-c | Liang Qichao on China's declaration of war with Germany, the fifth part of the retrospect. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097630 | 24097630 | |
34211 | 34211 | 1919-03-01 | 3 | b | Foreign newspaper reports the peace talks in China between the south and the north. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097629 | 24097629 | |
34225 | 34225 | 1919-03-01 | 7 | a-b | Australia news/ The New South Wales Chinese Chamber of Commerce to elect new committee members. Flu in Sydney and the casualties. School teachers in Sydney request earlier return of their students. Chinese businessman in Sydney Yang Meicheng dies from flu. Gibbs Bright & Co to resume its liner service from Australia to Hong Kong. Flu in Victoria and the casualties. Flu in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097633 | 24097633 | |
34226 | 34226 | 1919-03-01 | 7 | c | A passenger plane service from London to Paris. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097633 | 24097633 | |
34227 | 34227 | 1919-03-01 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. Mails for pickup at the Tung Wah Times. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097633 | 24097633 |
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]);