This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25341 | 25341 | 1911-12-02 | 2 | c | Dirty history of Fujian governor | Fujian governor has a dirty history. | Other... | http://trove.nla.gov.au/newspaper/page/24092019 | 24092019 |
25356 | 25356 | 1911-12-02 | 3 | c | Beijing news | Foreigners are happy about revolutionary riots in China. Imperial guardian appeals for stopping each province's borrowing more foreign loans. Chairman of Hubei advisory committee keeps silent after he returned from his Beijing trip. A murder case of Chinese overseas students in Russia. | Other... | http://trove.nla.gov.au/newspaper/page/24092018 | 24092018 |
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 |
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]);