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 |
---|---|---|---|---|---|---|---|---|---|
42660 | 42660 | 1925-02-07 | 2 | a | Editorial on the national congress in Beijing to deal with the aftermath (of the warlord conflict). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101021 | 24101021 | |
42663 | 42663 | 1925-02-07 | 3 | a | Sun Yatsen's German doctor reports that Sun is hospitalised in Beijing. Duan Qirui visits Sun Yatsen in the hospital. | China | http://trove.nla.gov.au/newspaper/page/24101020 | 24101020 | |
42671 | 42671 | 1925-02-07 | 7 | a | Notice from the Chinese Chamber of Commerce for a general meeting to elect board directors. A notice notice on Min Bao's criticism on its handling of donations to the flood victims in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101024 | 24101024 | |
42672 | 42672 | 1925-02-07 | 7 | a | A bank robbery in Caulfield, Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24101024 | 24101024 | |
42673 | 42673 | 1925-02-07 | 7 | a | The price of bread is going up again in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101024 | 24101024 | |
42674 | 42674 | 1925-02-07 | 7 | a | Two illegal Chinese immigrants are captured in New South Wales while on their run. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101024 | 24101024 | |
42675 | 42675 | 1925-02-07 | 7 | a | Soviet Russia initiates boycott to British goods. | Britain | http://trove.nla.gov.au/newspaper/page/24101024 | 24101024 | |
42676 | 42676 | 1925-02-07 | 7 | a | Sun Yatsen in the Beijing hospital and report on his illness. | China | http://trove.nla.gov.au/newspaper/page/24101024 | 24101024 |
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]);