This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40153 | 40153 | 1923-07-28 | 2 | a-b | Editorial on more crisis in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094488 | 24094488 | |
40156 | 40156 | 1923-07-28 | 3 | a-b | Effort to topple Li Yuanhong in Beijing and the political conspiracy. Correspondence between different power groups (Gao Lingwei and five others resign, telegram to Zhang Shaozeng in Tianjin, Wang Chengbin to Li Yuanhong, Qi Xieyuan's circular telegram). | China | http://trove.nla.gov.au/newspaper/page/24094487 | 24094487 | |
40161 | 40161 | 1923-07-28 | 6 | a-b | Situation in Guangdong may have fundamental change. | China | http://trove.nla.gov.au/newspaper/page/24094492 | 24094492 |
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]);