This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34046 | 34046 | 1919-02-01 | 2 | e | A telegram from Chinese President Xu Shichang to Tang Shaoyi and Tang's reply. | China | http://trove.nla.gov.au/newspaper/page/24097591 | 24097591 | |
34047 | 34047 | 1919-02-01 | 2 | f | Liang Qichao proposes to reform Chinese tariff regulations. | China | http://trove.nla.gov.au/newspaper/page/24097591 | 24097591 | |
34048 | 34048 | 1919-02-01 | 2 | f | Peace efforts in the south-western China. | China | http://trove.nla.gov.au/newspaper/page/24097591 | 24097591 | |
34049 | 34049 | 1919-02-01 | 3 | a | Assassination in China during the conflict between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24097590 | 24097590 | |
34064 | 34064 | 1919-02-01 | 8 | b-c | Beijing news/ Sufferings of the Chinese in Russia. Governor of Jiangxi province Chen Xiufeng stays in Beijing. Proposal for separate government in the south and in the north of China. Princess of Thailand comes to visit China. | China | http://trove.nla.gov.au/newspaper/page/24097596 | 24097596 | |
34065 | 34065 | 1919-02-01 | 8 | c | Guangdong news/ Qin Chunxuan resigns from the position of peace representation. The war expense of the south and the north. Business report from Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24097596 | 24097596 |
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]);