This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41282 | 41282 | 1924-03-22 | 2 | a-b | Editorial by the Tung Wah Times provides advice to the people who are advocate of The Three Principles of the People -- nationalism, democracy and people's livelihood. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100656 | 24100656 | |
41283 | 41283 | 1924-03-22 | 2 | b-c | The negotiation between China and Russia. | China | http://trove.nla.gov.au/newspaper/page/24100656 | 24100656 | |
41284 | 41284 | 1924-03-22 | 2 | c-d | Japanese in Tianjin demand their government to give up the Twenty-one Demands. | China | http://trove.nla.gov.au/newspaper/page/24100656 | 24100656 | |
41285 | 41285 | 1924-03-22 | 2 | d | Britain and Italy have recognised the Soviet Russian government. | Britain | http://trove.nla.gov.au/newspaper/page/24100656 | 24100656 | |
41286 | 41286 | 1924-03-22 | 2 | e | Number of Korean people in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24100656 | 24100656 | |
41287 | 41287 | 1924-03-22 | 2 | e | There is now air service between Beijing and Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24100656 | 24100656 | |
41288 | 41288 | 1924-03-22 | 2 | e-f | Prince of Mongolia has a secret visit to Russia and their talks. | Other... | http://trove.nla.gov.au/newspaper/page/24100656 | 24100656 | |
41289 | 41289 | 1924-03-22 | 2 | f | Beijing government appoints Qi Xieyuan general-inspector of Jiangsu, Anhui and Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24100656 | 24100656 | |
41290 | 41290 | 1924-03-22 | 2 | f | Political situation in Moscow after the death of Lenin. | Russia | http://trove.nla.gov.au/newspaper/page/24100656 | 24100656 |
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]);