This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36651 | 36651 | 1921-02-26 | 2 | a-b | First part of the editorial on the Guangdong situations before and after the Republic of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093453 | 24093453 | |
36652 | 36652 | 1921-02-26 | 2 | c | Crisis of Qingdao under the Japanese rule. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093453 | 24093453 | |
36653 | 36653 | 1921-02-26 | 2 | c | Sichuan, Guangxi and Guizhou have given up their claim of independence, and response of the Beijing government. | China | http://trove.nla.gov.au/newspaper/page/24093453 | 24093453 | |
36654 | 36654 | 1921-02-26 | 2 | c | Beijing government disapproves to the election of provincial governor by local people. | China | http://trove.nla.gov.au/newspaper/page/24093453 | 24093453 | |
36655 | 36655 | 1921-02-26 | 2 | c | Yunnan governor Tang Mingeng gives up independence claim and send envoy to Beijing for unification negotiation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093453 | 24093453 |
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]);