This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24753 | 24753 | 1911-07-29 | 2 | c | Personnel changes in the cabinet | Big personnel changes are to happen in the new cabinet. | Other... | http://trove.nla.gov.au/newspaper/page/24091859 | 24091859 |
24767 | 24767 | 1911-07-29 | 3 | c | Beijing news | Budget for the new cabinet and the emperor's assistance office. Budget for the autumn military exercise. The emperor intends to extend its garden in Haidian, Beijing. Yuan Sikai and the imperial family. Military railways are to be built. Zegong asks government to handle salt dealings. Lu Zhengxiang is sent to Russia to revise China's treaty with Russia. | Other... | http://trove.nla.gov.au/newspaper/page/24091858 | 24091858 |
24776 | 24776 | 1911-07-29 | 7 | c | Recruitment of foreign engineer | Transport Department recruits a foreign chief engineer. | China | http://trove.nla.gov.au/newspaper/page/24091862 | 24091862 |
24777 | 24777 | 1911-07-29 | 7 | c | Mexican government promises compensation | Mexican government promises compensation for those Chinese killed recently. | Other... | http://trove.nla.gov.au/newspaper/page/24091862 | 24091862 |
24778 | 24778 | 1911-07-29 | 7 | c | Thefts in Guangdong | Thefts are popular in Guangdong. | Other... | http://trove.nla.gov.au/newspaper/page/24091862 | 24091862 |
24781 | 24781 | 1911-07-29 | 8 | c | Russia intends to control Manchu | Russia intends to wholly control Manchu. | Other... | http://trove.nla.gov.au/newspaper/page/24091865 | 24091865 |
24782 | 24782 | 1911-07-29 | 8 | c | The army chief's plan | The army chief reveals his plan for military administration. | Other... | http://trove.nla.gov.au/newspaper/page/24091865 | 24091865 |
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]);