This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25372 | 25372 | 1911-12-02 | 8 | a-b | Details about Wuchang's fall | Details about how Wuchang fell into revolutionary hands. | Other... | http://trove.nla.gov.au/newspaper/page/24092025 | 24092025 |
25373 | 25373 | 1911-12-02 | 8 | b | General Feng's death | Report on how General Feng was bombed dead. | Other... | http://trove.nla.gov.au/newspaper/page/24092025 | 24092025 |
25374 | 25374 | 1911-12-02 | 8 | b-c | Guangzhou correspondence | All Business Association holds a meeting to discuss current situation in China. | Other... | http://trove.nla.gov.au/newspaper/page/24092025 | 24092025 |
25375 | 25375 | 1911-12-02 | 8 | c | Current situation in Guangdong | Government orders troops to be alert. Troops are asked to guard gates of Guangdong. Governor asks residents to be calm. Many people flee out of Guangdong feared of coming of revolutionaries. Many businesses closed. | Other... | http://trove.nla.gov.au/newspaper/page/24092025 | 24092025 |
25376 | 25376 | 1911-12-02 | 8 | c-d | Guangdong is said to be independent | Guangdong governor asks people not to believe the rumour that Guangdong is to be independent. | Other... | http://trove.nla.gov.au/newspaper/page/24092025 | 24092025 |
25377 | 25377 | 1911-12-02 | 8 | d | Travel notes | Some travel notes about American president, Italian royal family's cars and a Frenchman tours around the world. | Other... | http://trove.nla.gov.au/newspaper/page/24092025 | 24092025 |
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]);